DBA Data[Home] [Help]

APPS.LNS_SUBMIT_FOR_APPROVAL_PUB dependencies on LNS_LOAN_API_ERRORS_GT

Line 84: | other columns in LNS_LOAN_API_ERRORS_GT) in g_errors_rec.

80: |
81: |
82: | NOTES
83: | This procedure builds the error message and stores it (alongwith
84: | other columns in LNS_LOAN_API_ERRORS_GT) in g_errors_rec.
85: |
86: | MODIFICATION HISTORY
87: | Date Author Description of Changes
88: | 28-Mar-2007 MBOLLI Created

Line 100: l_text LNS_LOAN_API_ERRORS_GT.MESSAGE_TEXT%TYPE;

96: ,p_loan_id IN VARCHAR2 DEFAULT NULL
97: ,p_api_name IN VARCHAR2 DEFAULT NULL
98: ,p_err_msg IN VARCHAR2 DEFAULT NULL)
99: IS
100: l_text LNS_LOAN_API_ERRORS_GT.MESSAGE_TEXT%TYPE;
101: BEGIN
102: fnd_message.set_name('LNS', p_message_name);
103: if p_token1 is NOT NULL THEN
104: fnd_message.set_token('TOKEN1',p_token1);

Line 166: insert into LNS_LOAN_API_ERRORS_GT

162: Procedure InsertErrors
163: IS
164: BEGIN
165: FORALL i in 1..g_errors_rec.COUNT
166: insert into LNS_LOAN_API_ERRORS_GT
167: VALUES
168: g_errors_rec(i);
169: EXCEPTION
170: WHEN OTHERS THEN