DBA Data[Home] [Help]

APPS.ARP_CMERGE_ARTRX dependencies on ARP_MESSAGE

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

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

Line 56: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_CASH_RECEIPTS',FALSE);

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

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

128: EXIT;
129: END IF;
130: END LOOP;
131:
132: arp_message.set_name('AR','AR_ROWS_UPDATED');
133: arp_message.set_token('NUM_ROWS',to_char(l_count));
134: END IF;
135: EXCEPTION
136: WHEN OTHERS THEN

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

129: END IF;
130: END LOOP;
131:
132: arp_message.set_name('AR','AR_ROWS_UPDATED');
133: arp_message.set_token('NUM_ROWS',to_char(l_count));
134: END IF;
135: EXCEPTION
136: WHEN OTHERS THEN
137: arp_message.set_line( 'ar_cr');

Line 137: arp_message.set_line( 'ar_cr');

133: arp_message.set_token('NUM_ROWS',to_char(l_count));
134: END IF;
135: EXCEPTION
136: WHEN OTHERS THEN
137: arp_message.set_line( 'ar_cr');
138: RAISE;
139: END ar_cr;
140:
141: PROCEDURE ar_ps (

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

182: BEGIN
183: IF process_mode='LOCK' THEN
184: NULL;
185: ELSE
186: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
187: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_PAYMENT_SCHEDULES',FALSE);
188: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
189: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
190:

Line 187: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_PAYMENT_SCHEDULES',FALSE);

183: IF process_mode='LOCK' THEN
184: NULL;
185: ELSE
186: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
187: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_PAYMENT_SCHEDULES',FALSE);
188: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
189: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
190:
191: open merged_records;

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

259: EXIT;
260: END IF;
261: END LOOP;
262:
263: arp_message.set_name('AR','AR_ROWS_UPDATED');
264: arp_message.set_token('NUM_ROWS',to_char(l_count));
265: END IF;
266: EXCEPTION
267: WHEN OTHERS THEN

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

260: END IF;
261: END LOOP;
262:
263: arp_message.set_name('AR','AR_ROWS_UPDATED');
264: arp_message.set_token('NUM_ROWS',to_char(l_count));
265: END IF;
266: EXCEPTION
267: WHEN OTHERS THEN
268: arp_message.set_line( 'ar_ps');

Line 268: arp_message.set_line( 'ar_ps');

264: arp_message.set_token('NUM_ROWS',to_char(l_count));
265: END IF;
266: EXCEPTION
267: WHEN OTHERS THEN
268: arp_message.set_line( 'ar_ps');
269: RAISE;
270: END ar_ps;
271:
272:

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

361: BEGIN
362: IF process_mode='LOCK' THEN
363: NULL;
364: ELSE
365: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
366: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_CUSTOMER_TRX',FALSE);
367: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
368: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
369:

Line 366: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_CUSTOMER_TRX',FALSE);

362: IF process_mode='LOCK' THEN
363: NULL;
364: ELSE
365: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
366: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_CUSTOMER_TRX',FALSE);
367: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
368: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
369:
370: 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( 'ra_ct');

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

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( 'ra_ct');
489: RAISE;
490: END ra_ct;
491:
492: PROCEDURE RA_INT (

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

628: BEGIN
629: IF process_mode='LOCK' THEN
630: NULL;
631: ELSE
632: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
633: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_INTERFACE_LINES',FALSE);
634: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
635: /*Additional change for ra_interface_lines under bug2447449*/
636: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

Line 633: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_INTERFACE_LINES',FALSE);

629: IF process_mode='LOCK' THEN
630: NULL;
631: ELSE
632: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
633: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RA_INTERFACE_LINES',FALSE);
634: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
635: /*Additional change for ra_interface_lines under bug2447449*/
636: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
637: open merged_records;

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

788: EXIT;
789: END IF;
790: END LOOP;
791:
792: arp_message.set_name('AR','AR_ROWS_UPDATED');
793: arp_message.set_token('NUM_ROWS',to_char(l_count));
794: END IF;
795: EXCEPTION
796: WHEN OTHERS THEN

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

789: END IF;
790: END LOOP;
791:
792: arp_message.set_name('AR','AR_ROWS_UPDATED');
793: arp_message.set_token('NUM_ROWS',to_char(l_count));
794: END IF;
795: EXCEPTION
796: WHEN OTHERS THEN
797: arp_message.set_line( 'RA_INT');

Line 797: arp_message.set_line( 'RA_INT');

793: arp_message.set_token('NUM_ROWS',to_char(l_count));
794: END IF;
795: EXCEPTION
796: WHEN OTHERS THEN
797: arp_message.set_line( 'RA_INT');
798: RAISE;
799: END RA_INT;
800:
801: PROCEDURE ar_ard (

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

842: BEGIN
843: IF process_mode='LOCK' THEN
844: NULL;
845: ELSE
846: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
847: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_DISTRIBUTIONS',FALSE);
848: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
849: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
850:

Line 847: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_DISTRIBUTIONS',FALSE);

843: IF process_mode='LOCK' THEN
844: NULL;
845: ELSE
846: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
847: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_DISTRIBUTIONS',FALSE);
848: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
849: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
850:
851: open merged_records;

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

915: EXIT;
916: END IF;
917: END LOOP;
918:
919: arp_message.set_name('AR','AR_ROWS_UPDATED');
920: arp_message.set_token('NUM_ROWS',to_char(l_count));
921: END IF;
922: EXCEPTION
923: WHEN OTHERS THEN

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

916: END IF;
917: END LOOP;
918:
919: arp_message.set_name('AR','AR_ROWS_UPDATED');
920: arp_message.set_token('NUM_ROWS',to_char(l_count));
921: END IF;
922: EXCEPTION
923: WHEN OTHERS THEN
924: arp_message.set_line( 'ar_ard');

Line 924: arp_message.set_line( 'ar_ard');

920: arp_message.set_token('NUM_ROWS',to_char(l_count));
921: END IF;
922: EXCEPTION
923: WHEN OTHERS THEN
924: arp_message.set_line( 'ar_ard');
925: RAISE;
926: END ar_ard;
927:
928:

Line 933: arp_message.set_line( 'ARP_CMERGE_ARTRX.MERGE()+' );

929: /*---------------------------- PUBLIC ROUTINES ------------------------------*/
930: PROCEDURE merge (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
931: BEGIN
932:
933: arp_message.set_line( 'ARP_CMERGE_ARTRX.MERGE()+' );
934:
935: ar_cr( req_id, set_num, process_mode );
936: ar_ps( req_id, set_num, process_mode );
937: ra_ct( req_id, set_num, process_mode );

Line 941: arp_message.set_line( 'ARP_CMERGE_ARTRX.MERGE()-' );

937: ra_ct( req_id, set_num, process_mode );
938: ra_int(req_id, set_num, process_mode );
939: ar_ard(req_id, set_num, process_mode );
940:
941: arp_message.set_line( 'ARP_CMERGE_ARTRX.MERGE()-' );
942:
943: EXCEPTION
944: when others then
945: raise;