DBA Data[Home] [Help]

APPS.JTF_TASK_CUST_MERGE_PKG dependencies on ARP_MESSAGE

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

115: BEGIN
116: IF p_process_mode='LOCK' THEN
117: NULL;
118: ELSE
119: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
120: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_TASKS_B',FALSE);
121:
122: HZ_ACCT_MERGE_UTIL.load_set(p_set_number, p_request_id);
123:

Line 120: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_TASKS_B',FALSE);

116: IF p_process_mode='LOCK' THEN
117: NULL;
118: ELSE
119: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
120: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_TASKS_B',FALSE);
121:
122: HZ_ACCT_MERGE_UTIL.load_set(p_set_number, p_request_id);
123:
124: open merged_records;

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

189: EXIT;
190: END IF;
191: END LOOP;
192:
193: arp_message.set_name('AR','AR_ROWS_UPDATED');
194: arp_message.set_token('NUM_ROWS',to_char(l_count));
195: END IF;
196: EXCEPTION
197: WHEN OTHERS THEN

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

190: END IF;
191: END LOOP;
192:
193: arp_message.set_name('AR','AR_ROWS_UPDATED');
194: arp_message.set_token('NUM_ROWS',to_char(l_count));
195: END IF;
196: EXCEPTION
197: WHEN OTHERS THEN
198: arp_message.set_line( 'merge_tasks');

Line 198: arp_message.set_line( 'merge_tasks');

194: arp_message.set_token('NUM_ROWS',to_char(l_count));
195: END IF;
196: EXCEPTION
197: WHEN OTHERS THEN
198: arp_message.set_line( 'merge_tasks');
199: RAISE;
200: END merge_tasks;
201:
202: ----------------------------------------------------------------------

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

248: BEGIN
249: IF p_process_mode='LOCK' THEN
250: NULL;
251: ELSE
252: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
253: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_TASK_AUDITS_B',FALSE);
254:
255: HZ_ACCT_MERGE_UTIL.load_set(p_set_number, p_request_id);
256:

Line 253: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_TASK_AUDITS_B',FALSE);

249: IF p_process_mode='LOCK' THEN
250: NULL;
251: ELSE
252: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
253: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_TASK_AUDITS_B',FALSE);
254:
255: HZ_ACCT_MERGE_UTIL.load_set(p_set_number, p_request_id);
256:
257: open merged_records;

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

329: EXIT;
330: END IF;
331: END LOOP;
332:
333: arp_message.set_name('AR','AR_ROWS_UPDATED');
334: arp_message.set_token('NUM_ROWS',to_char(l_count));
335: END IF;
336: EXCEPTION
337: WHEN OTHERS THEN

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

330: END IF;
331: END LOOP;
332:
333: arp_message.set_name('AR','AR_ROWS_UPDATED');
334: arp_message.set_token('NUM_ROWS',to_char(l_count));
335: END IF;
336: EXCEPTION
337: WHEN OTHERS THEN
338: arp_message.set_line( 'merge_audits');

Line 338: arp_message.set_line( 'merge_audits');

334: arp_message.set_token('NUM_ROWS',to_char(l_count));
335: END IF;
336: EXCEPTION
337: WHEN OTHERS THEN
338: arp_message.set_line( 'merge_audits');
339: RAISE;
340: END merge_audits;
341:
342: ----------------------------------------------------------------------

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

396: BEGIN
397: IF p_process_mode='LOCK' THEN
398: NULL;
399: ELSE
400: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
401: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_PERZ_QUERY_PARAM',FALSE);
402:
403: HZ_ACCT_MERGE_UTIL.load_set(p_set_number, p_request_id);
404: load_acct_number_set(p_set_number, p_request_id);

Line 401: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_PERZ_QUERY_PARAM',FALSE);

397: IF p_process_mode='LOCK' THEN
398: NULL;
399: ELSE
400: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
401: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JTF_PERZ_QUERY_PARAM',FALSE);
402:
403: HZ_ACCT_MERGE_UTIL.load_set(p_set_number, p_request_id);
404: load_acct_number_set(p_set_number, p_request_id);
405:

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

517: END IF;
518:
519: END LOOP;
520:
521: arp_message.set_name('AR','AR_ROWS_UPDATED');
522: arp_message.set_token('NUM_ROWS',to_char(l_count));
523: END IF;
524: EXCEPTION
525: WHEN OTHERS THEN

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

518:
519: END LOOP;
520:
521: arp_message.set_name('AR','AR_ROWS_UPDATED');
522: arp_message.set_token('NUM_ROWS',to_char(l_count));
523: END IF;
524: EXCEPTION
525: WHEN OTHERS THEN
526: arp_message.set_line( 'merge_perz');

Line 526: arp_message.set_line( 'merge_perz');

522: arp_message.set_token('NUM_ROWS',to_char(l_count));
523: END IF;
524: EXCEPTION
525: WHEN OTHERS THEN
526: arp_message.set_line( 'merge_perz');
527: RAISE;
528: END merge_perz;
529:
530: PROCEDURE Task_Account_Merge(

Line 536: arp_message.set_line('CRM_MERGE.JTF_TASK_CUST_MERGE_PKG()+');

532: p_set_number IN NUMBER,
533: p_process_mode IN VARCHAR2) Is
534:
535: BEGIN
536: arp_message.set_line('CRM_MERGE.JTF_TASK_CUST_MERGE_PKG()+');
537:
538: g_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
539:
540: merge_tasks (p_request_id => p_request_id,

Line 553: arp_message.set_error (SQLCODE || SQLERRM);

549: p_set_number => p_set_number,
550: p_process_mode => p_process_mode);
551: EXCEPTION
552: WHEN OTHERS THEN
553: arp_message.set_error (SQLCODE || SQLERRM);
554: arp_message.set_error ('CRM_MERGE.JTF_TASK_CUST_MERGE_PKG()');
555: RAISE;
556: END Task_Account_Merge;
557:

Line 554: arp_message.set_error ('CRM_MERGE.JTF_TASK_CUST_MERGE_PKG()');

550: p_process_mode => p_process_mode);
551: EXCEPTION
552: WHEN OTHERS THEN
553: arp_message.set_error (SQLCODE || SQLERRM);
554: arp_message.set_error ('CRM_MERGE.JTF_TASK_CUST_MERGE_PKG()');
555: RAISE;
556: END Task_Account_Merge;
557:
558: END JTF_TASK_CUST_MERGE_PKG;