DBA Data[Home] [Help]

APPS.FV_CMERGE dependencies on ARP_MESSAGE

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

83: BEGIN
84: IF process_mode='LOCK' THEN
85: NULL;
86: ELSE
87: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
88: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_CUST_FINANCE_CHRGS',FALSE);
89: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
90: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
91: END IF;

Line 88: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_CUST_FINANCE_CHRGS',FALSE);

84: IF process_mode='LOCK' THEN
85: NULL;
86: ELSE
87: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
88: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_CUST_FINANCE_CHRGS',FALSE);
89: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
90: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
91: END IF;
92:

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

173: EXIT;
174: END IF;
175: END LOOP;
176:
177: arp_message.set_name('AR','AR_ROWS_UPDATED');
178: arp_message.set_token('NUM_ROWS',to_char(l_count));
179: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
180: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
181: END IF;

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

174: END IF;
175: END LOOP;
176:
177: arp_message.set_name('AR','AR_ROWS_UPDATED');
178: arp_message.set_token('NUM_ROWS',to_char(l_count));
179: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
180: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
181: END IF;
182: END IF;

Line 187: arp_message.set_line( 'FV_CUST_FINANCE_CHRGS');

183: EXCEPTION
184: WHEN OTHERS THEN
185: l_errbuf := SQLERRM;
186: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception', l_errbuf);
187: arp_message.set_line( 'FV_CUST_FINANCE_CHRGS');
188: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
189: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
190: END IF;
191: RAISE;

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

235: BEGIN
236: IF process_mode='LOCK' THEN
237: NULL;
238: ELSE
239: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
240: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_CUST_VEND_XREFS',FALSE);
241: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
242: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
243: END IF;

Line 240: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_CUST_VEND_XREFS',FALSE);

236: IF process_mode='LOCK' THEN
237: NULL;
238: ELSE
239: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
240: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_CUST_VEND_XREFS',FALSE);
241: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
242: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
243: END IF;
244: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

Line 259: arp_message.set_name('AR','AR_ROWS_DELETED');

255: and racm.customer_id = t.customer_id);
256:
257: g_count := SQL%ROWCOUNT;
258:
259: arp_message.set_name('AR','AR_ROWS_DELETED');
260: arp_message.set_token('NUM_ROWS',to_char(g_count));
261: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
262: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
263: END IF;

Line 260: arp_message.set_token('NUM_ROWS',to_char(g_count));

256:
257: g_count := SQL%ROWCOUNT;
258:
259: arp_message.set_name('AR','AR_ROWS_DELETED');
260: arp_message.set_token('NUM_ROWS',to_char(g_count));
261: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
262: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
263: END IF;
264:

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

323: EXIT;
324: END IF;
325: END LOOP;
326:
327: arp_message.set_name('AR','AR_ROWS_UPDATED');
328: arp_message.set_token('NUM_ROWS',to_char(l_count));
329: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
330: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
331: END IF;

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

324: END IF;
325: END LOOP;
326:
327: arp_message.set_name('AR','AR_ROWS_UPDATED');
328: arp_message.set_token('NUM_ROWS',to_char(l_count));
329: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
330: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
331: END IF;
332: END IF;

Line 337: arp_message.set_line( 'FV_CUST_VEND_XREFS');

333: EXCEPTION
334: WHEN OTHERS THEN
335: l_errbuf := SQLERRM;
336: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception', l_errbuf);
337: arp_message.set_line( 'FV_CUST_VEND_XREFS');
338: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
339: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
340: END IF;
341: RAISE;

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

384: BEGIN
385: IF process_mode='LOCK' THEN
386: NULL;
387: ELSE
388: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
389: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INTERAGENCY_FUNDS',FALSE);
390: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
391: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
392: END IF;

Line 389: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INTERAGENCY_FUNDS',FALSE);

385: IF process_mode='LOCK' THEN
386: NULL;
387: ELSE
388: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
389: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INTERAGENCY_FUNDS',FALSE);
390: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
391: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
392: END IF;
393: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

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

454: EXIT;
455: END IF;
456: END LOOP;
457:
458: arp_message.set_name('AR','AR_ROWS_UPDATED');
459: arp_message.set_token('NUM_ROWS',to_char(l_count));
460: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
461: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
462: END IF;

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

455: END IF;
456: END LOOP;
457:
458: arp_message.set_name('AR','AR_ROWS_UPDATED');
459: arp_message.set_token('NUM_ROWS',to_char(l_count));
460: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
461: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
462: END IF;
463: END IF;

Line 468: arp_message.set_line( 'FV_INTERAGENCY_FUNDS');

464: EXCEPTION
465: WHEN OTHERS THEN
466: l_errbuf := SQLERRM;
467: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception', l_errbuf);
468: arp_message.set_line( 'FV_INTERAGENCY_FUNDS');
469: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
470: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
471: END IF;
472: RAISE;

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

539: BEGIN
540: IF process_mode='LOCK' THEN
541: NULL;
542: ELSE
543: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
544: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INTERIM_CASH_RECEIPTS',FALSE);
545: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
546: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
547: END IF;

Line 544: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INTERIM_CASH_RECEIPTS',FALSE);

540: IF process_mode='LOCK' THEN
541: NULL;
542: ELSE
543: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
544: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INTERIM_CASH_RECEIPTS',FALSE);
545: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
546: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
547: END IF;
548: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

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

628: EXIT;
629: END IF;
630: END LOOP;
631:
632: arp_message.set_name('AR','AR_ROWS_UPDATED');
633: arp_message.set_token('NUM_ROWS',to_char(l_count));
634: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
636: END IF;

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

629: END IF;
630: END LOOP;
631:
632: arp_message.set_name('AR','AR_ROWS_UPDATED');
633: arp_message.set_token('NUM_ROWS',to_char(l_count));
634: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
636: END IF;
637: END IF;

Line 642: arp_message.set_line( 'FV_INTERIM_CASH_RECEIPTS');

638: EXCEPTION
639: WHEN OTHERS THEN
640: l_errbuf := SQLERRM;
641: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception', l_errbuf);
642: arp_message.set_line( 'FV_INTERIM_CASH_RECEIPTS');
643: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
644: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
645: END IF;
646: RAISE;

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

701: BEGIN
702: IF process_mode='LOCK' THEN
703: NULL;
704: ELSE
705: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
706: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INVOICE_FINANCE_CHRGS',FALSE);
707: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
708: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
709: END IF;

Line 706: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INVOICE_FINANCE_CHRGS',FALSE);

702: IF process_mode='LOCK' THEN
703: NULL;
704: ELSE
705: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
706: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INVOICE_FINANCE_CHRGS',FALSE);
707: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
708: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
709: END IF;
710: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

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

779: EXIT;
780: END IF;
781: END LOOP;
782:
783: arp_message.set_name('AR','AR_ROWS_UPDATED');
784: arp_message.set_token('NUM_ROWS',to_char(l_count));
785: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
786: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
787: END IF;

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

780: END IF;
781: END LOOP;
782:
783: arp_message.set_name('AR','AR_ROWS_UPDATED');
784: arp_message.set_token('NUM_ROWS',to_char(l_count));
785: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
786: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
787: END IF;
788: END IF;

Line 793: arp_message.set_line( 'FV_INVOICE_FINANCE_CHRGS');

789: EXCEPTION
790: WHEN OTHERS THEN
791: l_errbuf := SQLERRM;
792: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception', l_errbuf);
793: arp_message.set_line( 'FV_INVOICE_FINANCE_CHRGS');
794: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
795: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
796: END IF;
797: RAISE;

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

841: BEGIN
842: IF process_mode='LOCK' THEN
843: NULL;
844: ELSE
845: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
846: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_IPAC_TRX',FALSE);
847: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
849: END IF;

Line 846: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_IPAC_TRX',FALSE);

842: IF process_mode='LOCK' THEN
843: NULL;
844: ELSE
845: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
846: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_IPAC_TRX',FALSE);
847: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
849: END IF;
850: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

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

911: EXIT;
912: END IF;
913: END LOOP;
914:
915: arp_message.set_name('AR','AR_ROWS_UPDATED');
916: arp_message.set_token('NUM_ROWS',to_char(l_count));
917: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
918: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
919: END IF;

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

912: END IF;
913: END LOOP;
914:
915: arp_message.set_name('AR','AR_ROWS_UPDATED');
916: arp_message.set_token('NUM_ROWS',to_char(l_count));
917: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
918: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
919: END IF;
920: END IF;

Line 925: arp_message.set_line( 'FV_IPAC_TRX');

921: EXCEPTION
922: WHEN OTHERS THEN
923: l_errbuf := SQLERRM;
924: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception', l_errbuf);
925: arp_message.set_line( 'FV_IPAC_TRX');
926: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
927: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_ERROR, l_module_name);
928: END IF;
929: RAISE;