eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_CMERGE_ARCPF dependencies on ARP_MESSAGE

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 149: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );

145: CLOSE c2;
146:
147: --site level delete
148:
149: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
150: arp_message.set_token( 'TABLE_NAME', 'AR_CREDIT_HISTORIES', FALSE );
151:
152: --Bug 1725662: Modified 'ar_ch' to use index.
153:

Line 150: arp_message.set_token( 'TABLE_NAME', 'AR_CREDIT_HISTORIES', FALSE );

146:
147: --site level delete
148:
149: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
150: arp_message.set_token( 'TABLE_NAME', 'AR_CREDIT_HISTORIES', FALSE );
151:
152: --Bug 1725662: Modified 'ar_ch' to use index.
153:
154: DELETE FROM AR_CREDIT_HISTORIES yt

Line 165: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );

161: AND m.delete_duplicate_flag = 'Y');
162:
163: g_count := sql%rowcount;
164:
165: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );
166: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
167:
168: --customer level delete
169:

Line 166: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

162:
163: g_count := sql%rowcount;
164:
165: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );
166: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
167:
168: --customer level delete
169:
170: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );

Line 170: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );

166: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
167:
168: --customer level delete
169:
170: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
171: arp_message.set_token( 'TABLE_NAME', 'AR_CREDIT_HISTORIES', FALSE );
172:
173: DELETE FROM AR_CREDIT_HISTORIES yt
174: WHERE customer_id IN (

Line 171: arp_message.set_token( 'TABLE_NAME', 'AR_CREDIT_HISTORIES', FALSE );

167:
168: --customer level delete
169:
170: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
171: arp_message.set_token( 'TABLE_NAME', 'AR_CREDIT_HISTORIES', FALSE );
172:
173: DELETE FROM AR_CREDIT_HISTORIES yt
174: WHERE customer_id IN (
175: SELECT m.duplicate_id

Line 190: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );

186: AND acct.status <> 'D' );
187:
188: g_count := sql%rowcount;
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:

Line 191: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

187:
188: g_count := sql%rowcount;
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

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 288: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE' );

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' );
289: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );
290:
291: OPEN c1;
292: CLOSE c1;

Line 289: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );

285:
286: IF process_mode = 'LOCK' THEN
287:
288: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE' );
289: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );
290:
291: OPEN c1;
292: CLOSE c1;
293:

Line 305: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );

301:
302: /*************** 'inactivate' mode ***************/
303:
304: --site level inactivate
305: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
306: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );
307:
308: UPDATE hz_customer_profiles yt
309: SET status = 'I',

Line 306: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );

302: /*************** 'inactivate' mode ***************/
303:
304: --site level inactivate
305: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
306: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );
307:
308: UPDATE hz_customer_profiles yt
309: SET status = 'I',
310: last_update_date = sysdate,

Line 327: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );

323: AND m.delete_duplicate_flag = 'N' ) ;
324:
325: g_count := sql%rowcount;
326:
327: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
328: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
329:
330: --customer level inactivate
331: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );

Line 328: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

324:
325: g_count := sql%rowcount;
326:
327: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
328: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
329:
330: --customer level inactivate
331: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
332: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );

Line 331: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );

327: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
328: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
329:
330: --customer level inactivate
331: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
332: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );
333:
334: UPDATE hz_customer_profiles yt
335: SET status = 'I',

Line 332: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );

328: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
329:
330: --customer level inactivate
331: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
332: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );
333:
334: UPDATE hz_customer_profiles yt
335: SET status = 'I',
336: last_update_date = sysdate,

Line 359: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );

355: AND acct.status = 'A');
356:
357: g_count := sql%rowcount;
358:
359: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
360: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
361:
362: /*************** 'delete' mode ***************/
363: --Bug 1535542: Mark the rows need to be deleted by setting status to 'D'.

Line 360: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

356:
357: g_count := sql%rowcount;
358:
359: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
360: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
361:
362: /*************** 'delete' mode ***************/
363: --Bug 1535542: Mark the rows need to be deleted by setting status to 'D'.
364: --Physically delete them after merge.

Line 367: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );

363: --Bug 1535542: Mark the rows need to be deleted by setting status to 'D'.
364: --Physically delete them after merge.
365:
366: --site level 'delete'
367: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
368: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );
369:
370: UPDATE hz_customer_profiles
371: SET status = 'D'

Line 368: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );

364: --Physically delete them after merge.
365:
366: --site level 'delete'
367: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
368: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );
369:
370: UPDATE hz_customer_profiles
371: SET status = 'D'
372: WHERE site_use_id IN (

Line 382: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );

378: AND m.delete_duplicate_flag = 'Y' ) ;
379:
380: g_count := sql%rowcount;
381:
382: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
383: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
384:
385: --customer level 'delete'
386: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );

Line 383: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

379:
380: g_count := sql%rowcount;
381:
382: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
383: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
384:
385: --customer level 'delete'
386: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
387: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );

Line 386: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );

382: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
383: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
384:
385: --customer level 'delete'
386: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
387: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );
388:
389: UPDATE hz_customer_profiles yt
390: SET status = 'D'

Line 387: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );

383: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
384:
385: --customer level 'delete'
386: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
387: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );
388:
389: UPDATE hz_customer_profiles yt
390: SET status = 'D'
391: WHERE cust_account_id IN (

Line 407: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );

403: AND acct.status <> 'D' );
404:
405: g_count := sql%rowcount;
406:
407: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
408: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
409:
410: END IF;
411:

Line 408: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

404:
405: g_count := sql%rowcount;
406:
407: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
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()-' );

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 491: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE' );

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' );
492: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
493:
494: OPEN c1;
495: CLOSE c1;

Line 492: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );

488:
489: IF process_mode = 'LOCK' THEN
490:
491: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE' );
492: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
493:
494: OPEN c1;
495: CLOSE c1;
496:

Line 505: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

501:
502: /*************** 'inactivate' mode ***************/
503:
504: --site level inactivate
505: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
506: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
507:
508: UPDATE HZ_CUST_PROFILE_AMTS yt
509: SET last_update_date = sysdate,

Line 506: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );

502: /*************** 'inactivate' mode ***************/
503:
504: --site level inactivate
505: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
506: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
507:
508: UPDATE HZ_CUST_PROFILE_AMTS yt
509: SET last_update_date = sysdate,
510: last_updated_by = arp_standard.profile.user_id,

Line 526: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );

522: AND m.delete_duplicate_flag = 'N' );
523:
524: g_count := sql%rowcount;
525:
526: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
527: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
528:
529: --customer level inactivate
530: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );

Line 527: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

523:
524: g_count := sql%rowcount;
525:
526: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
527: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
528:
529: --customer level inactivate
530: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
531: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );

Line 530: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );

526: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
527: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
528:
529: --customer level inactivate
530: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
531: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
532:
533: UPDATE HZ_CUST_PROFILE_AMTS yt
534: SET last_update_date = sysdate,

Line 531: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );

527: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
528:
529: --customer level inactivate
530: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
531: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
532:
533: UPDATE HZ_CUST_PROFILE_AMTS yt
534: SET last_update_date = sysdate,
535: last_updated_by = arp_standard.profile.user_id,

Line 557: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );

553: AND acct.status = 'A') ;
554:
555: g_count := sql%rowcount;
556:
557: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
558: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
559:
560: END IF;
561:

Line 558: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

554:
555: g_count := sql%rowcount;
556:
557: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
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()-' );

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 655: arp_message.set_name( 'AR', 'AR_DELETING_TABLE');

651: ar_ch( req_id, set_num, 'DUMMY' );
652:
653: /*****************************************************/
654:
655: arp_message.set_name( 'AR', 'AR_DELETING_TABLE');
656: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );
657:
658: OPEN profiles;
659: CLOSE profiles;

Line 656: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );

652:
653: /*****************************************************/
654:
655: arp_message.set_name( 'AR', 'AR_DELETING_TABLE');
656: arp_message.set_token( 'TABLE_NAME', 'HZ_CUSTOMER_PROFILES', FALSE );
657:
658: OPEN profiles;
659: CLOSE profiles;
660:

Line 673: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );

669: AND status = 'D';
670:
671: g_count := sql%rowcount;
672:
673: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );
674: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
675:
676: /*****************************************************/
677:

Line 674: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

670:
671: g_count := sql%rowcount;
672:
673: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );
674: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
675:
676: /*****************************************************/
677:
678: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );

Line 678: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );

674: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
675:
676: /*****************************************************/
677:
678: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
679: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
680:
681: OPEN profile_amt_site;
682: CLOSE profile_amt_site;

Line 679: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );

675:
676: /*****************************************************/
677:
678: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
679: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
680:
681: OPEN profile_amt_site;
682: CLOSE profile_amt_site;
683:

Line 699: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );

695: AND m.delete_duplicate_flag = 'Y' );
696:
697: g_count := sql%rowcount;
698:
699: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );
700: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
701:
702: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
703: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );

Line 700: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

696:
697: g_count := sql%rowcount;
698:
699: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );
700: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
701:
702: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
703: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
704:

Line 702: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );

698:
699: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );
700: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
701:
702: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
703: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
704:
705: --account level
706: DELETE FROM HZ_CUST_PROFILE_AMTS yt

Line 703: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );

699: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );
700: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
701:
702: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
703: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_PROFILE_AMTS', FALSE );
704:
705: --account level
706: DELETE FROM HZ_CUST_PROFILE_AMTS yt
707: WHERE cust_account_id IN (

Line 723: arp_message.set_name( 'AR', 'AR_ROWS_DELETED' );

719: AND acct.status <> 'D' );
720:
721: g_count := sql%rowcount;
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:

Line 724: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );

720:
721: g_count := sql%rowcount;
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

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: