87: BEGIN
88: IF process_mode='LOCK' THEN
89: NULL;
90: ELSE
91: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
92: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMERS',FALSE);
93: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
94: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
95:
88: IF process_mode='LOCK' THEN
89: NULL;
90: ELSE
91: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
92: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMERS',FALSE);
93: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
94: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
95:
96: open merged_records;
166: EXIT;
167: END IF;
168: END LOOP;
169:
170: arp_message.set_name('AR','AR_ROWS_UPDATED');
171: arp_message.set_token('NUM_ROWS',to_char(l_count));
172: END IF;
173: EXCEPTION
174: WHEN OTHERS THEN
167: END IF;
168: END LOOP;
169:
170: arp_message.set_name('AR','AR_ROWS_UPDATED');
171: arp_message.set_token('NUM_ROWS',to_char(l_count));
172: END IF;
173: EXCEPTION
174: WHEN OTHERS THEN
175: arp_message.set_line( 'CSC_CUSTOMERS_MERGE');
171: arp_message.set_token('NUM_ROWS',to_char(l_count));
172: END IF;
173: EXCEPTION
174: WHEN OTHERS THEN
175: arp_message.set_line( 'CSC_CUSTOMERS_MERGE');
176: RAISE;
177: END CSC_CUSTOMERS_MERGE;
178:
179: PROCEDURE CSC_CUSTOMERS_AUDIT_HIST_MERGE (
206: BEGIN
207: IF process_mode='LOCK' THEN
208: NULL;
209: ELSE
210: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
211: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMERS_AUDIT_HIST',FALSE);
212: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
213: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
214:
207: IF process_mode='LOCK' THEN
208: NULL;
209: ELSE
210: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
211: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMERS_AUDIT_HIST',FALSE);
212: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
213: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
214:
215: open merged_records;
278: EXIT;
279: END IF;
280: END LOOP;
281:
282: arp_message.set_name('AR','AR_ROWS_UPDATED');
283: arp_message.set_token('NUM_ROWS',to_char(l_count));
284: END IF;
285: EXCEPTION
286: WHEN OTHERS THEN
279: END IF;
280: END LOOP;
281:
282: arp_message.set_name('AR','AR_ROWS_UPDATED');
283: arp_message.set_token('NUM_ROWS',to_char(l_count));
284: END IF;
285: EXCEPTION
286: WHEN OTHERS THEN
287: arp_message.set_line( 'CSC_CUSTOMERS_AUDIT_HIST_MERGE');
283: arp_message.set_token('NUM_ROWS',to_char(l_count));
284: END IF;
285: EXCEPTION
286: WHEN OTHERS THEN
287: arp_message.set_line( 'CSC_CUSTOMERS_AUDIT_HIST_MERGE');
288: RAISE;
289: END CSC_CUSTOMERS_AUDIT_HIST_MERGE;
290:
291: PROCEDURE CSC_CUSTOMIZED_PLANS_MERGE (
324: BEGIN
325: IF process_mode='LOCK' THEN
326: NULL;
327: ELSE
328: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
329: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMIZED_PLANS',FALSE);
330: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
331: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
332:
325: IF process_mode='LOCK' THEN
326: NULL;
327: ELSE
328: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
329: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMIZED_PLANS',FALSE);
330: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
331: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
332:
333: open merged_records;
403: EXIT;
404: END IF;
405: END LOOP;
406:
407: arp_message.set_name('AR','AR_ROWS_UPDATED');
408: arp_message.set_token('NUM_ROWS',to_char(l_count));
409: END IF;
410: EXCEPTION
411: WHEN OTHERS THEN
404: END IF;
405: END LOOP;
406:
407: arp_message.set_name('AR','AR_ROWS_UPDATED');
408: arp_message.set_token('NUM_ROWS',to_char(l_count));
409: END IF;
410: EXCEPTION
411: WHEN OTHERS THEN
412: arp_message.set_line( 'CSC_CUSTOMIZED_PLANS_MERGE');
408: arp_message.set_token('NUM_ROWS',to_char(l_count));
409: END IF;
410: EXCEPTION
411: WHEN OTHERS THEN
412: arp_message.set_line( 'CSC_CUSTOMIZED_PLANS_MERGE');
413: RAISE;
414: END CSC_CUSTOMIZED_PLANS_MERGE;
415:
416: PROCEDURE CSC_CUST_PLANS_MERGE (
455: BEGIN
456: IF process_mode='LOCK' THEN
457: NULL;
458: ELSE
459: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
460: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUST_PLANS',FALSE);
461: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
462: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
463:
456: IF process_mode='LOCK' THEN
457: NULL;
458: ELSE
459: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
460: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUST_PLANS',FALSE);
461: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
462: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
463:
464: open merged_records;
559: EXIT;
560: END IF;
561: END LOOP;
562:
563: arp_message.set_name('AR','AR_ROWS_UPDATED');
564: arp_message.set_token('NUM_ROWS',to_char(l_count));
565: END IF;
566: EXCEPTION
567: WHEN OTHERS THEN
560: END IF;
561: END LOOP;
562:
563: arp_message.set_name('AR','AR_ROWS_UPDATED');
564: arp_message.set_token('NUM_ROWS',to_char(l_count));
565: END IF;
566: EXCEPTION
567: WHEN OTHERS THEN
568: arp_message.set_line( 'CSC_CUST_PLANS_MERGE');
564: arp_message.set_token('NUM_ROWS',to_char(l_count));
565: END IF;
566: EXCEPTION
567: WHEN OTHERS THEN
568: arp_message.set_line( 'CSC_CUST_PLANS_MERGE');
569: RAISE;
570: END CSC_CUST_PLANS_MERGE;
571:
572: PROCEDURE CSC_CUST_PLANS_AUDIT_MERGE (
611: BEGIN
612: IF process_mode='LOCK' THEN
613: NULL;
614: ELSE
615: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
616: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUST_PLANS_AUDIT',FALSE);
617: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
618: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
619:
612: IF process_mode='LOCK' THEN
613: NULL;
614: ELSE
615: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
616: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUST_PLANS_AUDIT',FALSE);
617: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
618: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
619:
620: open merged_records;
699: EXIT;
700: END IF;
701: END LOOP;
702:
703: arp_message.set_name('AR','AR_ROWS_UPDATED');
704: arp_message.set_token('NUM_ROWS',to_char(l_count));
705: END IF;
706: EXCEPTION
707: WHEN OTHERS THEN
700: END IF;
701: END LOOP;
702:
703: arp_message.set_name('AR','AR_ROWS_UPDATED');
704: arp_message.set_token('NUM_ROWS',to_char(l_count));
705: END IF;
706: EXCEPTION
707: WHEN OTHERS THEN
708: arp_message.set_line( 'CSC_CUST_PLANS_AUDIT_MERGE');
704: arp_message.set_token('NUM_ROWS',to_char(l_count));
705: END IF;
706: EXCEPTION
707: WHEN OTHERS THEN
708: arp_message.set_line( 'CSC_CUST_PLANS_AUDIT_MERGE');
709: RAISE;
710: END CSC_CUST_PLANS_AUDIT_MERGE;
711:
712: END CSC_ACCOUNT_MERGE_PKG;