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:
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;
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
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');
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: --
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:
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:
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
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');
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: --
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:
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;
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
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');
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: --
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:
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;
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
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;
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
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');
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: --
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:
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;
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
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');
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: --
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
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: --