DBA Data[Home] [Help]

APPS.PAP_CMERGE dependencies on PAP_CMERGE

Line 1: PACKAGE BODY PAP_CMERGE AS

1: PACKAGE BODY PAP_CMERGE AS
2: -- $Header: PAPCMR3B.pls 120.2.12010000.4 2008/08/29 14:26:45 arbandyo ship $
3: /* */
4: --
5: -- function to retrieve new customer id for pa_project_customers table

Line 191: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE.MERGE()+' );

187: -- to indicate what package name is being executed.
188: --
189: -- update log file to indicate the module being executed.
190: --
191: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE.MERGE()+' );
192: --
193: --Get the profile option for audit of customer merge
194: g_audit_profile :=NVL(FND_PROFILE.value('HZ_AUDIT_ACCT_MERGE'),'N');
195:

Line 1628: PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS( req_id, set_no );

1624: /* END Added by sbsivara for retention related tables */
1625: --
1626: -- update pa_agreements for customer_id only.
1627: --
1628: PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS( req_id, set_no );
1629: --
1630: -- update pa_project_contacts for customer_id only.
1631: --
1632: PAP_CMERGE_BB2.MERGE_PA_PROJECT_CONTACTS( req_id, set_no );

Line 1632: PAP_CMERGE_BB2.MERGE_PA_PROJECT_CONTACTS( req_id, set_no );

1628: PAP_CMERGE_BB1.MERGE_PA_AGREEMENTS( req_id, set_no );
1629: --
1630: -- update pa_project_contacts for customer_id only.
1631: --
1632: PAP_CMERGE_BB2.MERGE_PA_PROJECT_CONTACTS( req_id, set_no );
1633: --
1634: --
1635: <>
1636: --

Line 1639: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE.MERGE()-' );

1635: <>
1636: --
1637: -- update log file to indicate the successful exit of this module.
1638: --
1639: ARP_MESSAGE.SET_LINE( 'PAP_CMERGE.MERGE()-' );
1640: --
1641: --
1642: EXCEPTION
1643:

Line 1645: ARP_MESSAGE.SET_ERROR( 'PAP_CMERGE.MERGE' );

1641: --
1642: EXCEPTION
1643:
1644: WHEN OTHERS THEN
1645: ARP_MESSAGE.SET_ERROR( 'PAP_CMERGE.MERGE' );
1646: RAISE;
1647:
1648: END MERGE;
1649: --

Line 1652: END PAP_CMERGE;

1648: END MERGE;
1649: --
1650: --
1651: /********************* End of Mission ***********************/
1652: END PAP_CMERGE;