FTE_CHCK_ROUTINE (System Preference)#
USER EXIT#
| Description | This preference identifies a user exit to be invoked upon entry of the Required FTE field. |
| Set at | IMFN for functions based on Posting code (RPO) |
| Takes effect | Upon re-entry to the screen |
| Values | Value is the name of the PL/SQL function that has been defined for the user exit |
| Default | If not defined, no variation to system logic occurs |
Notes#
This function is called when the Required FTE value is changed. This occurs when a new position code is entered, or when the user enters a value in the REQUIRED_FTE field.This function must be constructed to take three parameters:
- DPS_ID
- The ID of the position code that has been entered for this posting. Note that this value be NULL, if it has not yet been entered.
- REQUISITION_DATE
- The requisition date that has been entered. Note that this value may be NULL, if it has not yet been entered.
- REQUIRED_FTE
- The Required FTE value that has been entered.
This function would then execute the desired logic, and will return a numeric value that has the following properties:
- >= 0
- No error, Required FTE field is set to this returned value
- < 0
- Error. The system will pop up a message, to be created as a user defined message on IMMS as FTE_nnn where nnn is the absolute value of the error. For example, a return value of -1 will pop up message FTE_1 from IMMS. If the message is not found, a generic message will be popped up, and an entry will be made in IMMS with this generic message. In the error condition, the Required FTE value is set to 0.
Your user exit logic must also handle the cases where the DPS_ID and / or REQUISITION_DATE parameters are NULL.
