DBA Data[Home] [Help]

APPS.CSC_ACCOUNT_MERGE_PKG dependencies on ARP_MESSAGE

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

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:

Line 92: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMERS',FALSE);

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;

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

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

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

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

Line 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 (

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

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:

Line 211: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMERS_AUDIT_HIST',FALSE);

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;

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

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

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

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

Line 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 (

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

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:

Line 329: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUSTOMIZED_PLANS',FALSE);

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;

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

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

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

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

Line 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 (

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

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:

Line 460: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUST_PLANS',FALSE);

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;

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

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

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

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

Line 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 (

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

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:

Line 616: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSC_CUST_PLANS_AUDIT',FALSE);

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;

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

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

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

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

Line 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;