DBA Data[Home] [Help]

APPS.CN_CUST_MERGE_PVT dependencies on ARP_MESSAGE

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

92: NULL;
93: ELSE
94:
95: IF l_custmerge_profile_value = 'Y' THEN
96: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
97: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_COMMISSION_HEADERS',FALSE);
98: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
99: END IF;
100:

Line 97: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_COMMISSION_HEADERS',FALSE);

93: ELSE
94:
95: IF l_custmerge_profile_value = 'Y' THEN
96: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
97: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_COMMISSION_HEADERS',FALSE);
98: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
99: END IF;
100:
101: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

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

210: END IF;
211: END LOOP;
212:
213: IF l_custmerge_profile_value = 'Y' THEN
214: arp_message.set_name('AR','AR_ROWS_UPDATED');
215: arp_message.set_token('NUM_ROWS',to_char(l_count));
216: END IF;
217: END IF;
218:

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

211: END LOOP;
212:
213: IF l_custmerge_profile_value = 'Y' THEN
214: arp_message.set_name('AR','AR_ROWS_UPDATED');
215: arp_message.set_token('NUM_ROWS',to_char(l_count));
216: END IF;
217: END IF;
218:
219: EXCEPTION

Line 221: -- arp_message.set_line( 'MERGE_CUSTOMER_IN_HEADER');

217: END IF;
218:
219: EXCEPTION
220: WHEN OTHERS THEN
221: -- arp_message.set_line( 'MERGE_CUSTOMER_IN_HEADER');
222: RAISE;
223: END MERGE_CUSTOMER_IN_HEADER;
224:
225: PROCEDURE MERGE_CUSTOMER_IN_API (req_id NUMBER,

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

310: NULL;
311: ELSE
312:
313: IF l_custmerge_profile_value = 'Y' THEN
314: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
315: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_COMM_LINES_API',FALSE);
316: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
317: END IF;
318:

Line 315: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_COMM_LINES_API',FALSE);

311: ELSE
312:
313: IF l_custmerge_profile_value = 'Y' THEN
314: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
315: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_COMM_LINES_API',FALSE);
316: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
317: END IF;
318:
319: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

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

424: EXIT;
425: END IF;
426: END LOOP;
427:
428: arp_message.set_name('AR','AR_ROWS_UPDATED');
429: arp_message.set_token('NUM_ROWS',to_char(l_count));
430: END IF;
431: EXCEPTION
432: WHEN OTHERS THEN

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

425: END IF;
426: END LOOP;
427:
428: arp_message.set_name('AR','AR_ROWS_UPDATED');
429: arp_message.set_token('NUM_ROWS',to_char(l_count));
430: END IF;
431: EXCEPTION
432: WHEN OTHERS THEN
433: arp_message.set_line( 'MERGE_CUSTOMER_IN_API');

Line 433: arp_message.set_line( 'MERGE_CUSTOMER_IN_API');

429: arp_message.set_token('NUM_ROWS',to_char(l_count));
430: END IF;
431: EXCEPTION
432: WHEN OTHERS THEN
433: arp_message.set_line( 'MERGE_CUSTOMER_IN_API');
434: RAISE;
435: END MERGE_CUSTOMER_IN_API;
436:
437:

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

444: IF process_mode='LOCK' THEN
445: NULL;
446: ELSE
447:
448: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
449: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_CUST_MERGE_INTERFACE',FALSE);
450:
451: Insert into CN_CUST_MERGE_INTERFACE
452: (

Line 449: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_CUST_MERGE_INTERFACE',FALSE);

445: NULL;
446: ELSE
447:
448: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
449: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CN_CUST_MERGE_INTERFACE',FALSE);
450:
451: Insert into CN_CUST_MERGE_INTERFACE
452: (
453: request_id

Line 469: --arp_message.set_line( 'MERGE_CUSTOMER_IN_API');

465: END IF;
466: EXCEPTION
467: WHEN OTHERS THEN
468:
469: --arp_message.set_line( 'MERGE_CUSTOMER_IN_API');
470: RAISE;
471: END populate_customer_merge;
472:
473: procedure customer_merge (req_id NUMBER,