APPS.ARP_CMERGE_ARCPF dependencies on ARP_CMERGE_ARCPF

Line 1: PACKAGE BODY ARP_CMERGE_ARCPF as

1: PACKAGE BODY ARP_CMERGE_ARCPF as
2: /* $Header: ARPLCPFB.pls 120.3.12010000.2 2009/01/27 10:36:37 vsegu ship $ */
3:
4: g_count NUMBER := 0;
5:

Line 62: arp_message.set_line( 'ARP_CMERGE_ARCPF.MERGE()+' );

58: ) IS
59:
60: BEGIN
61:
62: arp_message.set_line( 'ARP_CMERGE_ARCPF.MERGE()+' );
63:
64: --merge hz_customer_profiles
65: ar_cp( req_id, set_num, process_mode );
66:

Line 70: arp_message.set_line( 'ARP_CMERGE_ARCPF.MERGE()-' );

66:
67: --merge hz_customer_profile_amts
68: ar_cpa( req_id, set_num, process_mode );
69:
70: arp_message.set_line( 'ARP_CMERGE_ARCPF.MERGE()-' );
71:
72: END merge;
73:
74: /*===========================================================================+

Line 137: arp_message.set_line( 'ARP_CMERGE_ARCPF.AR_CH()+' );

133: FOR UPDATE NOWAIT;
134:
135: BEGIN
136:
137: arp_message.set_line( 'ARP_CMERGE_ARCPF.AR_CH()+' );
138:
139: --delete only if delete = 'Y', otherwise leave in as historical data
140: --lock table
141: OPEN c1;

Line 193: arp_message.set_line( 'ARP_CMERGE_ARCPF.AR_CH()-' );

189:
190: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );
191: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
192:
193: arp_message.set_line( 'ARP_CMERGE_ARCPF.AR_CH()-' );
194:
195: EXCEPTION
196:
197: WHEN OTHERS THEN

Line 198: arp_message.set_error( 'ARP_CMERGE_ARCPF.AR_CH');

194:
195: EXCEPTION
196:
197: WHEN OTHERS THEN
198: arp_message.set_error( 'ARP_CMERGE_ARCPF.AR_CH');
199: RAISE;
200:
201: END ar_ch;
202:

Line 284: arp_message.set_line( 'ARP_CMERGE_ARCPF.AR_CP()+' );

280: FOR UPDATE NOWAIT;
281:
282: BEGIN
283:
284: arp_message.set_line( 'ARP_CMERGE_ARCPF.AR_CP()+' );
285:
286: IF process_mode = 'LOCK' THEN
287:
288: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE' );

Line 412: arp_message.set_line( 'ARP_CMERGE_ARCPF.AR_CP()-' );

408: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
409:
410: END IF;
411:
412: arp_message.set_line( 'ARP_CMERGE_ARCPF.AR_CP()-' );
413:
414: EXCEPTION
415:
416: WHEN OTHERS THEN

Line 417: arp_message.set_error( 'ARP_CMERGE_ARCPF.AR_CP');

413:
414: EXCEPTION
415:
416: WHEN OTHERS THEN
417: arp_message.set_error( 'ARP_CMERGE_ARCPF.AR_CP');
418: RAISE;
419:
420: END ar_cp;
421:

Line 487: arp_message.set_line( 'ARP_CMERGE_ARCPF.AR_CPA()+' );

483: FOR UPDATE NOWAIT;
484:
485: BEGIN
486:
487: arp_message.set_line( 'ARP_CMERGE_ARCPF.AR_CPA()+' );
488:
489: IF process_mode = 'LOCK' THEN
490:
491: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE' );

Line 562: arp_message.set_line( 'ARP_CMERGE_ARCPF.AR_CPA()-' );

558: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
559:
560: END IF;
561:
562: arp_message.set_line( 'ARP_CMERGE_ARCPF.AR_CPA()-' );
563:
564: EXCEPTION
565:
566: WHEN OTHERS THEN

Line 567: arp_message.set_error( 'ARP_CMERGE_ARCPF.AR_CPA');

563:
564: EXCEPTION
565:
566: WHEN OTHERS THEN
567: arp_message.set_error( 'ARP_CMERGE_ARCPF.AR_CPA');
568: RAISE;
569:
570: END ar_cpa;
571:

Line 644: arp_message.set_line( 'ARP_CMERGE_ARCPF.delete_rows()+' );

640: FOR UPDATE NOWAIT;
641:
642: BEGIN
643:
644: arp_message.set_line( 'ARP_CMERGE_ARCPF.delete_rows()+' );
645:
646: /*****************************************************/
647:
648: --Bug 1535542: Because ar_ch procedure works only in delete mode, we call it here

Line 726: arp_message.set_line( 'ARP_CMERGE_ARCPF.delete_rows()-' );

722:
723: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );
724: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
725:
726: arp_message.set_line( 'ARP_CMERGE_ARCPF.delete_rows()-' );
727:
728: EXCEPTION
729:
730: WHEN OTHERS THEN

Line 731: arp_message.set_error( 'ARP_CMERGE_ARCPF.delete_rows' );

727:
728: EXCEPTION
729:
730: WHEN OTHERS THEN
731: arp_message.set_error( 'ARP_CMERGE_ARCPF.delete_rows' );
732: RAISE;
733:
734: END delete_rows;
735:

Line 736: END ARP_CMERGE_ARCPF;

732: RAISE;
733:
734: END delete_rows;
735:
736: END ARP_CMERGE_ARCPF;