APPS.PAP_CMERGE_BB1 dependencies on PAP_CMERGE

Line 1: PACKAGE BODY PAP_CMERGE_BB1 AS

1: PACKAGE BODY PAP_CMERGE_BB1 AS
2: -- $Header: PAPCMR1B.pls 120.1 2005/08/05 00:27:56 rgandhi noship $
3: --
4: -- function to retrieve new and old customer id's.
5: --

Line 130: IF pap_cmerge.g_audit_profile = 'Y' THEN

126: end if;
127: /* till here */
128: --
129: /* Added for TCA audit */
130: IF pap_cmerge.g_audit_profile = 'Y' THEN
131: --
132: -- It inserts the data into HZ_CUSTOMER_MERGE_LOG table
133: -- for PA_AGREEMENTS table and stamps the new agreement
134: -- number and old agreement number.

Line 219: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE_BB2.MERGE_PA_AGREEMENTS()+' );

215: BEGIN
216: --
217: -- update log file to indicate the module being executed.
218: --
219: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE_BB2.MERGE_PA_AGREEMENTS()+' );
220: --
221: -- update log file to indicate the table being updated.
222: --
223: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );

Line 283: IF pap_cmerge.g_audit_profile = 'Y' THEN

279: end if;
280: --
281: /* Added for TCA audit */
282: --
283: IF pap_cmerge.g_audit_profile = 'Y' THEN
284: --
285: -- Inserts data into HZ_CUSTOMER_MERGE_LOG table for
286: -- PA_AGREEMENTS table and stamps agreement id with old
287: -- and new customer id .

Line 348: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE_BB2.MERGE_PA_AGREEMENTS()-' );

344: total_record_upd_count := 0;
345: --
346: -- update log file to indicate successful exit of this module.
347: --
348: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE_BB2.MERGE_PA_AGREEMENTS()-' );
349: --
350: EXCEPTION
351: --
352: WHEN out_of_limit THEN

Line 354: ARP_MESSAGE.SET_ERROR( 'PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS' );

350: EXCEPTION
351: --
352: WHEN out_of_limit THEN
353: ARP_MESSAGE.SET_ERROR( 'Duplicate agreement number exceeding 99' );
354: ARP_MESSAGE.SET_ERROR( 'PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS' );
355: RAISE;
356: WHEN OTHERS THEN
357: ARP_MESSAGE.SET_ERROR( 'PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS' );
358: RAISE;

Line 357: ARP_MESSAGE.SET_ERROR( 'PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS' );

353: ARP_MESSAGE.SET_ERROR( 'Duplicate agreement number exceeding 99' );
354: ARP_MESSAGE.SET_ERROR( 'PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS' );
355: RAISE;
356: WHEN OTHERS THEN
357: ARP_MESSAGE.SET_ERROR( 'PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS' );
358: RAISE;
359: --
360: END MERGE_PA_AGREEMENTS;
361: --

Line 362: END PAP_CMERGE_BB1;

358: RAISE;
359: --
360: END MERGE_PA_AGREEMENTS;
361: --
362: END PAP_CMERGE_BB1;