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.OTAP_CMERGE dependencies on ARP_MESSAGE

Line 58: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

54: BEGIN
55: IF process_mode='LOCK' THEN
56: NULL;
57: ELSE
58: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
59: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_BOOKING_DEALS',FALSE);
60: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
61: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
62:

Line 59: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_BOOKING_DEALS',FALSE);

55: IF process_mode='LOCK' THEN
56: NULL;
57: ELSE
58: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
59: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_BOOKING_DEALS',FALSE);
60: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
61: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
62:
63: open merged_records;

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

120: EXIT;
121: END IF;
122: END LOOP;
123:
124: arp_message.set_name('AR','AR_ROWS_UPDATED');
125: arp_message.set_token('NUM_ROWS',to_char(l_count));
126: END IF;
127: EXCEPTION
128: WHEN OTHERS THEN

Line 125: arp_message.set_token('NUM_ROWS',to_char(l_count));

121: END IF;
122: END LOOP;
123:
124: arp_message.set_name('AR','AR_ROWS_UPDATED');
125: arp_message.set_token('NUM_ROWS',to_char(l_count));
126: END IF;
127: EXCEPTION
128: WHEN OTHERS THEN
129: arp_message.set_line( 'OTA_TBD');

Line 129: arp_message.set_line( 'OTA_TBD');

125: arp_message.set_token('NUM_ROWS',to_char(l_count));
126: END IF;
127: EXCEPTION
128: WHEN OTHERS THEN
129: arp_message.set_line( 'OTA_TBD');
130: RAISE;
131: END OTA_TBD;
132:
133: --

Line 205: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

201: BEGIN
202: IF process_mode='LOCK' THEN
203: NULL;
204: ELSE
205: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
206: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_DELEGATE_BOOKINGS',FALSE);
207: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
208: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
209:

Line 206: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_DELEGATE_BOOKINGS',FALSE);

202: IF process_mode='LOCK' THEN
203: NULL;
204: ELSE
205: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
206: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_DELEGATE_BOOKINGS',FALSE);
207: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
208: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
209:
210:

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

291: EXIT;
292: END IF;
293: END LOOP;
294:
295: arp_message.set_name('AR','AR_ROWS_UPDATED');
296: arp_message.set_token('NUM_ROWS',to_char(l_count));
297: END IF;
298: EXCEPTION
299: WHEN OTHERS THEN

Line 296: arp_message.set_token('NUM_ROWS',to_char(l_count));

292: END IF;
293: END LOOP;
294:
295: arp_message.set_name('AR','AR_ROWS_UPDATED');
296: arp_message.set_token('NUM_ROWS',to_char(l_count));
297: END IF;
298: EXCEPTION
299: WHEN OTHERS THEN
300: arp_message.set_line( 'OTA_TDB');

Line 300: arp_message.set_line( 'OTA_TDB');

296: arp_message.set_token('NUM_ROWS',to_char(l_count));
297: END IF;
298: EXCEPTION
299: WHEN OTHERS THEN
300: arp_message.set_line( 'OTA_TDB');
301: RAISE;
302: END OTA_TDB;
303:
304: --

Line 391: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

387: BEGIN
388: IF process_mode='LOCK' THEN
389: NULL;
390: ELSE
391: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
392: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_FINANCE_HEADERS',FALSE);
393: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
394: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
395:

Line 392: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_FINANCE_HEADERS',FALSE);

388: IF process_mode='LOCK' THEN
389: NULL;
390: ELSE
391: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
392: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_FINANCE_HEADERS',FALSE);
393: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
394: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
395:
396: open merged_records;

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

479: EXIT;
480: END IF;
481: END LOOP;
482:
483: arp_message.set_name('AR','AR_ROWS_UPDATED');
484: arp_message.set_token('NUM_ROWS',to_char(l_count));
485: END IF;
486: EXCEPTION
487: WHEN OTHERS THEN

Line 484: arp_message.set_token('NUM_ROWS',to_char(l_count));

480: END IF;
481: END LOOP;
482:
483: arp_message.set_name('AR','AR_ROWS_UPDATED');
484: arp_message.set_token('NUM_ROWS',to_char(l_count));
485: END IF;
486: EXCEPTION
487: WHEN OTHERS THEN
488: arp_message.set_line( 'OTA_TFH');

Line 488: arp_message.set_line( 'OTA_TFH');

484: arp_message.set_token('NUM_ROWS',to_char(l_count));
485: END IF;
486: EXCEPTION
487: WHEN OTHERS THEN
488: arp_message.set_line( 'OTA_TFH');
489: RAISE;
490: END OTA_TFH;
491:
492: --

Line 563: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

559: BEGIN
560: IF process_mode='LOCK' THEN
561: NULL;
562: ELSE
563: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
564: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_EVENT_ASSOCIATIONS',FALSE);
565: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
566: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
567:

Line 564: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_EVENT_ASSOCIATIONS',FALSE);

560: IF process_mode='LOCK' THEN
561: NULL;
562: ELSE
563: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
564: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_EVENT_ASSOCIATIONS',FALSE);
565: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
566: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
567:
568: open merged_records;

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

775: CLOSE csr_duplicate_record;
776: END LOOP;
777: END IF;
778:
779: arp_message.set_name('AR','AR_ROWS_DELETED');
780: arp_message.set_token('NUM_ROWS',to_char(l_del_count));
781:
782: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
783: IF MERGE_HEADER_ID_LIST.COUNT = 0 THEN

Line 780: arp_message.set_token('NUM_ROWS',to_char(l_del_count));

776: END LOOP;
777: END IF;
778:
779: arp_message.set_name('AR','AR_ROWS_DELETED');
780: arp_message.set_token('NUM_ROWS',to_char(l_del_count));
781:
782: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
783: IF MERGE_HEADER_ID_LIST.COUNT = 0 THEN
784: exit;

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

797: END LOOP;
798:
799: END LOOP;
800:
801: arp_message.set_name('AR','AR_ROWS_UPDATED');
802: arp_message.set_token('NUM_ROWS',to_char(l_count));
803: END IF;
804: EXCEPTION
805: WHEN OTHERS THEN

Line 802: arp_message.set_token('NUM_ROWS',to_char(l_count));

798:
799: END LOOP;
800:
801: arp_message.set_name('AR','AR_ROWS_UPDATED');
802: arp_message.set_token('NUM_ROWS',to_char(l_count));
803: END IF;
804: EXCEPTION
805: WHEN OTHERS THEN
806: arp_message.set_line( 'OTA_TEA');

Line 806: arp_message.set_line( 'OTA_TEA');

802: arp_message.set_token('NUM_ROWS',to_char(l_count));
803: END IF;
804: EXCEPTION
805: WHEN OTHERS THEN
806: arp_message.set_line( 'OTA_TEA');
807: RAISE;
808: END OTA_TEA;
809:
810: --

Line 858: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

854: BEGIN
855: IF process_mode='LOCK' THEN
856: NULL;
857: ELSE
858: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
859: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_NOTRNG_HISTORIES',FALSE);
860: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
861: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
862:

Line 859: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_NOTRNG_HISTORIES',FALSE);

855: IF process_mode='LOCK' THEN
856: NULL;
857: ELSE
858: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
859: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_NOTRNG_HISTORIES',FALSE);
860: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
861: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
862:
863: open merged_records;

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

920: EXIT;
921: END IF;
922: END LOOP;
923:
924: arp_message.set_name('AR','AR_ROWS_UPDATED');
925: arp_message.set_token('NUM_ROWS',to_char(l_count));
926: END IF;
927: EXCEPTION
928: WHEN OTHERS THEN

Line 925: arp_message.set_token('NUM_ROWS',to_char(l_count));

921: END IF;
922: END LOOP;
923:
924: arp_message.set_name('AR','AR_ROWS_UPDATED');
925: arp_message.set_token('NUM_ROWS',to_char(l_count));
926: END IF;
927: EXCEPTION
928: WHEN OTHERS THEN
929: arp_message.set_line( 'OTA_TNH');

Line 929: arp_message.set_line( 'OTA_TNH');

925: arp_message.set_token('NUM_ROWS',to_char(l_count));
926: END IF;
927: EXCEPTION
928: WHEN OTHERS THEN
929: arp_message.set_line( 'OTA_TNH');
930: RAISE;
931: END OTA_TNH;
932:
933: --

Line 940: arp_message.set_line( 'OTAP_CMERGE.MERGE()+' );

936: PROCEDURE merge (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
937: --
938: BEGIN
939: --
940: arp_message.set_line( 'OTAP_CMERGE.MERGE()+' );
941: --
942: OTA_TDB( req_id, set_num, process_mode );
943: OTA_TBD( req_id, set_num, process_mode );
944: -- Bug 3561222

Line 951: arp_message.set_line( 'OTAP_CMERGE.MERGE()-' );

947: OTA_TNH( req_id, set_num, process_mode );
948: -- Bug 3561222
949: OTA_TEA( req_id, set_num, process_mode );
950: --
951: arp_message.set_line( 'OTAP_CMERGE.MERGE()-' );
952: --
953: END merge;
954: --
955: --