APPS.PAP_CMERGE_BB2 dependencies on PAP_CMERGE

Line 1: PACKAGE BODY PAP_CMERGE_BB2 AS

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

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

79: --
80: BEGIN
81: --
82: /* Added for Tca audit*/
83: IF pap_cmerge.g_audit_profile = 'Y' THEN
84: --
85: -- Inserting the data into HZ_CUSTOMER_MERGE_LOG table for
86: -- PA_PROJECT_CONTACTS table. All rows are inserted that are going
87: -- to be deleted for old customer.

Line 227: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE_BB1.MERGE_PA_PROJECT_CONTACTS()+' );

223: BEGIN
224: --
225: -- update log file for entering this module successfully.
226: --
227: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE_BB1.MERGE_PA_PROJECT_CONTACTS()+' );
228: --
229: -- update log file to indicate table name being updated.
230: --
231: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );

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

281: end if;
282: /* Added for TCA audit */
283: -- Checking for the profile flag for audit.
284: --
285: IF pap_cmerge.g_audit_profile = 'Y' THEN
286: --
287: -- Inserting data into HZ_CUSTOMER_MERGE_LOG table for
288: -- PA_PROJECT_CONTACTS table the new and old contact id.
289: --

Line 330: END IF; -- end if of IF pap_cmerge.g_audit_profile = 'Y' THEN

326: WHERE PC.PROJECT_ID = var_project_id
327: AND PC.CUSTOMER_ID = var_customer_id);
328:
329:
330: END IF; -- end if of IF pap_cmerge.g_audit_profile = 'Y' THEN
331: --
332: /* end of Tca audit*/
333: --
334: -- update table pa_project_contacts with new customer_id.

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

377:
378: commenting out this code as the new bill_ship_customer_id will
379: be present in var_racm_customer_id fetched from cursor_4*/
380:
381: IF pap_cmerge.g_audit_profile = 'Y' THEN
382: --
383: -- Inserting data into HZ_CUSTOMER_MERGE_LOG table for
384: -- PA_PROJECT_CONTACTS table the new and old contact id.
385: --

Line 428: END IF; -- end if of IF pap_cmerge.g_audit_profile = 'Y' THEN

424: AND PC.CUSTOMER_ID = var_customer_id
425: AND PC.BILL_SHIP_CUSTOMER_ID=var_bill_ship_customer_id);
426:
427:
428: END IF; -- end if of IF pap_cmerge.g_audit_profile = 'Y' THEN
429:
430: UPDATE pa_project_contacts PC
431: SET BILL_SHIP_CUSTOMER_ID = var_racm_customer_id,
432: LAST_UPDATE_DATE = SYSDATE,

Line 465: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE_BB1.MERGE_PA_PROJECT_CONTACTS()-' );

461: total_record_del_count := 0;
462: --
463: -- update log file for exiting this module successfully.
464: --
465: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE_BB1.MERGE_PA_PROJECT_CONTACTS()-' );
466: --
467: EXCEPTION
468: --
469: WHEN OTHERS THEN

Line 470: ARP_MESSAGE.SET_ERROR( 'PAP_CMERGE_BB1.MERGE_PA_PROJECT_CONTACTS' );

466: --
467: EXCEPTION
468: --
469: WHEN OTHERS THEN
470: ARP_MESSAGE.SET_ERROR( 'PAP_CMERGE_BB1.MERGE_PA_PROJECT_CONTACTS' );
471: RAISE;
472:
473: END MERGE_PA_PROJECT_CONTACTS;
474: --

Line 475: END PAP_CMERGE_BB2;

471: RAISE;
472:
473: END MERGE_PA_PROJECT_CONTACTS;
474: --
475: END PAP_CMERGE_BB2;