If all the parameters passed are correct and the update is successful, a blank (‘ ‘) is returned in the p_result parameter.
Otherwise, p_result contains all the errors that were found for the given data. In most cases, a numeric error message is completed by the name of the faulty column.
Example
If m_api_qs.upd_qs is called, and it returns the following value:
Result = 201,104 - ESCALATION_PERCENT,102 - ESCALATION_DAYS,101 - NO_BID_IND,106 - CURRENCY_CODE,INTEREST,
This means:
-
The given quote summary does not exist (201).
-
The value for ESCALATION_PERCENT is not a numeric one (104).
-
The value for ESCALATION_DAYS is too large (102).
-
NO_BID_IND cannot be set to NULL (101).
-
The value for CURRENCY_CODE is not valid; perhaps a unit not belonging to the CURRENCY unit group has been passed to the package (106).
-
A column named INTEREST is not supported by this package.
For information on the available error codes, see Appendix C: Error Codes.