DBA Data[Home] [Help]

APPS.PAP_CMERGE_BB2 dependencies on ARP_MESSAGE

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 231: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );

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' );
232: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CONTACTS' );
233: --
234: OPEN cursor_3;
235: --

Line 232: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CONTACTS' );

228: --
229: -- update log file to indicate table name being updated.
230: --
231: ARP_MESSAGE.SET_NAME( 'AR', 'AR_UPDATING_TABLE' );
232: ARP_MESSAGE.SET_TOKEN( 'TABLE_NAME', 'PA_PROJECT_CONTACTS' );
233: --
234: OPEN cursor_3;
235: --
236: LOOP

Line 453: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );

449: /* CLOSE cursor_3; commented out for CACR*/
450: --
451: -- update log file for total records updated.
452: --
453: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
454: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
455: total_record_upd_count := 0;
456: --
457: -- update log file for total records deleted.

Line 454: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));

450: --
451: -- update log file for total records updated.
452: --
453: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_UPDATED' );
454: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_upd_count ));
455: total_record_upd_count := 0;
456: --
457: -- update log file for total records deleted.
458: --

Line 459: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_DELETED' );

455: total_record_upd_count := 0;
456: --
457: -- update log file for total records deleted.
458: --
459: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_DELETED' );
460: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_del_count ));
461: total_record_del_count := 0;
462: --
463: -- update log file for exiting this module successfully.

Line 460: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_del_count ));

456: --
457: -- update log file for total records deleted.
458: --
459: ARP_MESSAGE.SET_NAME( 'AR', 'AR_ROWS_DELETED' );
460: ARP_MESSAGE.SET_TOKEN( 'NUM_ROWS', TO_CHAR( total_record_del_count ));
461: total_record_del_count := 0;
462: --
463: -- update log file for exiting this module successfully.
464: --

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: --