DBA Data[Home] [Help]

APPS.ARP_CMERGE_ARCOL dependencies on ARP_MESSAGE

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

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

Line 57: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_CUSTOMER_CALL_TOPICS',FALSE);

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

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

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

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

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

Line 134: arp_message.set_line( 'ar_cct');

130: arp_message.set_token('NUM_ROWS',to_char(l_count));
131: END IF;
132: EXCEPTION
133: WHEN OTHERS THEN
134: arp_message.set_line( 'ar_cct');
135: RAISE;
136: END ar_cct;
137:
138: /*--------------------------- PRIVATE ROUTINES ------------------------------*/

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

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

Line 188: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_CUSTOMER_CALLS',FALSE);

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

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

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

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

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

Line 265: arp_message.set_line( 'ar_ccalls');

261: arp_message.set_token('NUM_ROWS',to_char(l_count));
262: END IF;
263: EXCEPTION
264: WHEN OTHERS THEN
265: arp_message.set_line( 'ar_ccalls');
266: RAISE;
267: END ar_ccalls;
268:
269: /*--------------------------- PRIVATE ROUTINES ------------------------------*/

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

316: BEGIN
317: IF process_mode='LOCK' THEN
318: NULL;
319: ELSE
320: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
321: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_STATEMENTS_HISTORY',FALSE);
322: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
323: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
324:

Line 321: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_STATEMENTS_HISTORY',FALSE);

317: IF process_mode='LOCK' THEN
318: NULL;
319: ELSE
320: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
321: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_STATEMENTS_HISTORY',FALSE);
322: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
323: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
324:
325: open merged_records;

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

393: EXIT;
394: END IF;
395: END LOOP;
396:
397: arp_message.set_name('AR','AR_ROWS_UPDATED');
398: arp_message.set_token('NUM_ROWS',to_char(l_count));
399: END IF;
400: EXCEPTION
401: WHEN OTHERS THEN

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

394: END IF;
395: END LOOP;
396:
397: arp_message.set_name('AR','AR_ROWS_UPDATED');
398: arp_message.set_token('NUM_ROWS',to_char(l_count));
399: END IF;
400: EXCEPTION
401: WHEN OTHERS THEN
402: arp_message.set_line( 'ar_sh');

Line 402: arp_message.set_line( 'ar_sh');

398: arp_message.set_token('NUM_ROWS',to_char(l_count));
399: END IF;
400: EXCEPTION
401: WHEN OTHERS THEN
402: arp_message.set_line( 'ar_sh');
403: RAISE;
404: END ar_sh;
405:
406: /*---------------------------- PUBLIC ROUTINES ------------------------------*/

Line 411: arp_message.set_line( 'ARP_CMERGE_ARCOL.MERGE()+' );

407:
408: PROCEDURE merge (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
409: BEGIN
410:
411: arp_message.set_line( 'ARP_CMERGE_ARCOL.MERGE()+' );
412:
413: ar_cct( req_id, set_num, process_mode );
414: /* bug354192 : added call to following procedures */
415:

Line 419: arp_message.set_line( 'ARP_CMERGE_ARCOL.MERGE()-' );

415:
416: ar_ccalls( req_id, set_num, process_mode );
417: ar_sh( req_id, set_num, process_mode );
418:
419: arp_message.set_line( 'ARP_CMERGE_ARCOL.MERGE()-' );
420:
421: END merge;
422:
423: end ARP_CMERGE_ARCOL;