eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_LOCKBOX_FC_PKG dependencies on FND_LOG

Line 163: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

159: l_module_name VARCHAR2(200) := g_module_name || 'main';
160: BEGIN
161:
162: v_transmission_id := x_transmission_id;
163: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
164: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'STARTING THE MAIN PROCESS. PROCESSING TRANSMISSION '||
165: 'ID '||to_char(v_transmission_id));
166: END IF;
167:

Line 164: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'STARTING THE MAIN PROCESS. PROCESSING TRANSMISSION '||

160: BEGIN
161:
162: v_transmission_id := x_transmission_id;
163: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
164: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'STARTING THE MAIN PROCESS. PROCESSING TRANSMISSION '||
165: 'ID '||to_char(v_transmission_id));
166: END IF;
167:
168: -- clear records out of fv_lockbox_ipa_temp for current transmission

Line 176: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

172: -- finding all batches within the transmission.
173: FOR c_batches_rec IN c_batches(v_transmission_id) LOOP
174:
175: v_batch_id := c_batches_rec.batch_id;
176: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING BATCH_ID = '||TO_CHAR(V_BATCH_ID));
178: END IF;
179:
180: v_org_id := c_batches_rec.org_id;

Line 177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING BATCH_ID = '||TO_CHAR(V_BATCH_ID));

173: FOR c_batches_rec IN c_batches(v_transmission_id) LOOP
174:
175: v_batch_id := c_batches_rec.batch_id;
176: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING BATCH_ID = '||TO_CHAR(V_BATCH_ID));
178: END IF;
179:
180: v_org_id := c_batches_rec.org_id;
181:

Line 182: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

178: END IF;
179:
180: v_org_id := c_batches_rec.org_id;
181:
182: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
183: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FINDING ALL RECEIPTS THAT ARE APPLIED TO INVOICES');
184: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'POPULATING FV_LOCKBOX_IPA_TEMP W/TOTALS OF DEBIT MEMOS');
185: END IF;
186: -- finding all the receipts applied to invoices within the batch

Line 183: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FINDING ALL RECEIPTS THAT ARE APPLIED TO INVOICES');

179:
180: v_org_id := c_batches_rec.org_id;
181:
182: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
183: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FINDING ALL RECEIPTS THAT ARE APPLIED TO INVOICES');
184: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'POPULATING FV_LOCKBOX_IPA_TEMP W/TOTALS OF DEBIT MEMOS');
185: END IF;
186: -- finding all the receipts applied to invoices within the batch
187: FOR c_invoices_rec IN c_invoices(v_batch_id,v_org_id) LOOP

Line 184: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'POPULATING FV_LOCKBOX_IPA_TEMP W/TOTALS OF DEBIT MEMOS');

180: v_org_id := c_batches_rec.org_id;
181:
182: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
183: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FINDING ALL RECEIPTS THAT ARE APPLIED TO INVOICES');
184: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'POPULATING FV_LOCKBOX_IPA_TEMP W/TOTALS OF DEBIT MEMOS');
185: END IF;
186: -- finding all the receipts applied to invoices within the batch
187: FOR c_invoices_rec IN c_invoices(v_batch_id,v_org_id) LOOP
188:

Line 208: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',v_errbuf);

204: EXCEPTION
205: WHEN others THEN
206: v_retcode := '2';
207: v_errbuf := 'fv_lockbox_ipa_temp_s '||sqlerrm;
208: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',v_errbuf);
209: ROLLBACK;
210: RAISE;
211: END;
212:

Line 235: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

231: END LOOP; -- c_debit_memos
232:
233: END LOOP; -- c_invoices
234:
235: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FINDING RECEIPT WITH APPLICATION TO DEBIT MEMOS');
237: END IF;
238:
239: -- find all finance charge debit memos within batch

Line 236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FINDING RECEIPT WITH APPLICATION TO DEBIT MEMOS');

232:
233: END LOOP; -- c_invoices
234:
235: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FINDING RECEIPT WITH APPLICATION TO DEBIT MEMOS');
237: END IF;
238:
239: -- find all finance charge debit memos within batch
240: FOR c_receipt_dms_rec IN c_receipt_dms(v_batch_id, v_org_id) LOOP

Line 263: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

259: process_receipt_applications;
260:
261: END LOOP; -- c_batches
262:
263: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
264: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'***COMPLETED PROCESS SUCCESFULLY***');
265: END IF;
266:
267: x_retcode := '0';

Line 264: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'COMPLETED PROCESS SUCCESFULLY');

260:
261: END LOOP; -- c_batches
262:
263: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
264: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'***COMPLETED PROCESS SUCCESFULLY***');
265: END IF;
266:
267: x_retcode := '0';
268: EXCEPTION

Line 303: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',x_errbuf);

299: close c_finchrg_total;
300: END IF;
301:
302: ROLLBACK;
303: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',x_errbuf);
304:
305:
306: END main;
307:

Line 322: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

318: l_module_name VARCHAR2(200) := g_module_name || 'process_receipt_applications';
319:
320: BEGIN
321:
322: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
323: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'STARTING PROCESS_RECEIPT_APPLICATIONS');
324: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FINDING ALL INVOICE APPLICATIONS WITHIN THE BATCH');
325: END IF;
326:

Line 323: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'STARTING PROCESS_RECEIPT_APPLICATIONS');

319:
320: BEGIN
321:
322: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
323: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'STARTING PROCESS_RECEIPT_APPLICATIONS');
324: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FINDING ALL INVOICE APPLICATIONS WITHIN THE BATCH');
325: END IF;
326:
327: -- getting all invoices to pay off within the batch

Line 324: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FINDING ALL INVOICE APPLICATIONS WITHIN THE BATCH');

320: BEGIN
321:
322: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
323: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'STARTING PROCESS_RECEIPT_APPLICATIONS');
324: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FINDING ALL INVOICE APPLICATIONS WITHIN THE BATCH');
325: END IF;
326:
327: -- getting all invoices to pay off within the batch
328: FOR c_receipt_details_rec IN c_receipt_details(v_batch_id, v_org_id) LOOP

Line 344: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

340:
341: -- reset cash_receipt_line_id used during insert_cash_receipt
342: v_cash_receipt_line_id_ctr := 0;
343:
344: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
345: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_CASH_RECEIPT_ID = '||TO_CHAR(V_CASH_RECEIPT_ID));
346: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_CASH_RECEIPT_LINE_ID = '
347: ||to_char(v_cash_receipt_line_id));
348: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_APPL_INV_AMT = '||TO_CHAR(V_APPL_INV_AMT));

Line 345: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_CASH_RECEIPT_ID = '||TO_CHAR(V_CASH_RECEIPT_ID));

341: -- reset cash_receipt_line_id used during insert_cash_receipt
342: v_cash_receipt_line_id_ctr := 0;
343:
344: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
345: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_CASH_RECEIPT_ID = '||TO_CHAR(V_CASH_RECEIPT_ID));
346: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_CASH_RECEIPT_LINE_ID = '
347: ||to_char(v_cash_receipt_line_id));
348: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_APPL_INV_AMT = '||TO_CHAR(V_APPL_INV_AMT));
349: END IF;

Line 346: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_CASH_RECEIPT_LINE_ID = '

342: v_cash_receipt_line_id_ctr := 0;
343:
344: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
345: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_CASH_RECEIPT_ID = '||TO_CHAR(V_CASH_RECEIPT_ID));
346: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_CASH_RECEIPT_LINE_ID = '
347: ||to_char(v_cash_receipt_line_id));
348: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_APPL_INV_AMT = '||TO_CHAR(V_APPL_INV_AMT));
349: END IF;
350:

Line 348: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_APPL_INV_AMT = '||TO_CHAR(V_APPL_INV_AMT));

344: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
345: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_CASH_RECEIPT_ID = '||TO_CHAR(V_CASH_RECEIPT_ID));
346: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_CASH_RECEIPT_LINE_ID = '
347: ||to_char(v_cash_receipt_line_id));
348: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'V_APPL_INV_AMT = '||TO_CHAR(V_APPL_INV_AMT));
349: END IF;
350:
351: -- get finance charge debit memo totals for an invoice
352: OPEN c_finchrg_total(v_transmission_id, v_batch_id,v_appl_inv_id);

Line 363: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

359:
360: EXIT when c_finchrg_total%NOTFOUND;
361:
362: -- amount remaining is >= to the total amount due on the debit memo
363: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
364: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'DEBIT MEMO ID = '||TO_CHAR(V_APPL_DM_ID));
365: END IF;
366:
367: IF v_appl_amt_remain >= v_dm_amt THEN

Line 364: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'DEBIT MEMO ID = '||TO_CHAR(V_APPL_DM_ID));

360: EXIT when c_finchrg_total%NOTFOUND;
361:
362: -- amount remaining is >= to the total amount due on the debit memo
363: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
364: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'DEBIT MEMO ID = '||TO_CHAR(V_APPL_DM_ID));
365: END IF;
366:
367: IF v_appl_amt_remain >= v_dm_amt THEN
368: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 368: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

364: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'DEBIT MEMO ID = '||TO_CHAR(V_APPL_DM_ID));
365: END IF;
366:
367: IF v_appl_amt_remain >= v_dm_amt THEN
368: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
369: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT REMAIN > DM AMT');
370: END IF;
371:
372: v_appl_amt_remain := v_appl_amt_remain - v_dm_amt;

Line 369: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT REMAIN > DM AMT');

365: END IF;
366:
367: IF v_appl_amt_remain >= v_dm_amt THEN
368: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
369: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT REMAIN > DM AMT');
370: END IF;
371:
372: v_appl_amt_remain := v_appl_amt_remain - v_dm_amt;
373:

Line 384: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

380: update_lockbox_temp(v_dm_amt);
381: END IF;
382:
383: ELSE -- amount remaining is less than the amount due of the debit memo.
384: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
385: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT REMAIN < DM AMT');
386: END IF;
387:
388: IF v_origin = 'R' THEN

Line 385: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT REMAIN < DM AMT');

381: END IF;
382:
383: ELSE -- amount remaining is less than the amount due of the debit memo.
384: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
385: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT REMAIN < DM AMT');
386: END IF;
387:
388: IF v_origin = 'R' THEN
389: -- when a receipt comes from ar_interim_cash_receipts table

Line 399: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

395:
396: insert_cash_receipt(v_appl_dm_id, v_dm_pay_sch_id,
397: v_appl_amt_remain, null);
398:
399: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
400: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE AR_INTERIM_CASH_RECEIPTS TO MULTIPLE');
401: END IF;
402: update ar_interim_cash_receipts
403: set customer_trx_id = null,

Line 400: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE AR_INTERIM_CASH_RECEIPTS TO MULTIPLE');

396: insert_cash_receipt(v_appl_dm_id, v_dm_pay_sch_id,
397: v_appl_amt_remain, null);
398:
399: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
400: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE AR_INTERIM_CASH_RECEIPTS TO MULTIPLE');
401: END IF;
402: update ar_interim_cash_receipts
403: set customer_trx_id = null,
404: payment_schedule_id = null,

Line 446: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

442: -- this is for the case when have paid off all the finance charge debit
443: -- memo and monies still remain to apply. Adjust the original
444: -- invoice application receipt record.
445:
446: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
447: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'3RD BRANCH');
448: END IF;
449:
450: IF v_origin = 'R' THEN

Line 447: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'3RD BRANCH');

443: -- memo and monies still remain to apply. Adjust the original
444: -- invoice application receipt record.
445:
446: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
447: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'3RD BRANCH');
448: END IF;
449:
450: IF v_origin = 'R' THEN
451: -- when a receipt comes from ar_interim_cash_receipts table

Line 461: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

457:
458: insert_cash_receipt(v_appl_inv_id, v_appl_inv_ps_id,
459: v_appl_amt_remain, v_transaction_code);
460:
461: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
462: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE AR_INTERIM_CASH_RECEIPTS TO MULTIPLE');
463: END IF;
464: update ar_interim_cash_receipts
465: set customer_trx_id = null,

Line 462: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE AR_INTERIM_CASH_RECEIPTS TO MULTIPLE');

458: insert_cash_receipt(v_appl_inv_id, v_appl_inv_ps_id,
459: v_appl_amt_remain, v_transaction_code);
460:
461: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
462: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE AR_INTERIM_CASH_RECEIPTS TO MULTIPLE');
463: END IF;
464: update ar_interim_cash_receipts
465: set customer_trx_id = null,
466: payment_schedule_id = null,

Line 495: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'ERROR OCCURRED IN PROCESS_RECEIPT_APPLICATION - '||SQLERRM);

491: WHEN others THEN
492: IF v_retcode is null THEN
493: v_retcode := '2';
494: v_errbuf := 'process_receipt_application '||sqlerrm;
495: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'ERROR OCCURRED IN PROCESS_RECEIPT_APPLICATION - '||SQLERRM);
496: END IF;
497:
498: ROLLBACK;
499: RAISE;

Line 529: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

525:
526: END IF;
527:
528: v_cash_receipt_line_id_ctr := nvl(v_cash_receipt_line_id_ctr,0) + 1;
529: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
530: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CTR = '||TO_CHAR(V_CASH_RECEIPT_LINE_ID_CTR));
531: END IF;
532:
533: insert into ar_interim_cash_rcpt_lines_all

Line 530: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CTR = '||TO_CHAR(V_CASH_RECEIPT_LINE_ID_CTR));

526: END IF;
527:
528: v_cash_receipt_line_id_ctr := nvl(v_cash_receipt_line_id_ctr,0) + 1;
529: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
530: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CTR = '||TO_CHAR(V_CASH_RECEIPT_LINE_ID_CTR));
531: END IF;
532:
533: insert into ar_interim_cash_rcpt_lines_all
534: (cash_receipt_id,

Line 561: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

557: v_batch_id,
558: v_ussgl_tran_code);
559:
560:
561: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
562: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'INSERTED NEW CASH RECEIPT FOR CUSTOMER_TRX_ID '||
563: to_char(v_cust_trx_id));
564: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOR THE AMOUNT OF '||TO_CHAR(V_AMOUNT));
565: END IF;

Line 562: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'INSERTED NEW CASH RECEIPT FOR CUSTOMER_TRX_ID '||

558: v_ussgl_tran_code);
559:
560:
561: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
562: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'INSERTED NEW CASH RECEIPT FOR CUSTOMER_TRX_ID '||
563: to_char(v_cust_trx_id));
564: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOR THE AMOUNT OF '||TO_CHAR(V_AMOUNT));
565: END IF;
566:

Line 564: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOR THE AMOUNT OF '||TO_CHAR(V_AMOUNT));

560:
561: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
562: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'INSERTED NEW CASH RECEIPT FOR CUSTOMER_TRX_ID '||
563: to_char(v_cust_trx_id));
564: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOR THE AMOUNT OF '||TO_CHAR(V_AMOUNT));
565: END IF;
566:
567: EXCEPTION
568: WHEN others THEN

Line 571: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'ERROR OCCURRED IN INSERT_CASH_RECEIPT - '||SQLERRM);

567: EXCEPTION
568: WHEN others THEN
569: v_retcode := '2';
570: v_errbuf := 'insert_cash_receipt '||sqlerrm;
571: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'ERROR OCCURRED IN INSERT_CASH_RECEIPT - '||SQLERRM);
572: ROLLBACK;
573: RAISE;
574:
575: END insert_cash_receipt;

Line 596: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

592: where debit_memo_id = v_appl_dm_id -- current debit memo being processed
593: and invoice_id = v_appl_inv_id -- current invoice being processed
594: and batch_id = v_batch_id; -- curent batch being processed
595:
596: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
597: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE TEMP TABLE DECREASING BY '
598: ||to_char(v_decrease_dm_amount));
599: END IF;
600: EXCEPTION

Line 597: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE TEMP TABLE DECREASING BY '

593: and invoice_id = v_appl_inv_id -- current invoice being processed
594: and batch_id = v_batch_id; -- curent batch being processed
595:
596: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
597: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE TEMP TABLE DECREASING BY '
598: ||to_char(v_decrease_dm_amount));
599: END IF;
600: EXCEPTION
601: WHEN others THEN

Line 604: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'ERROR OCCURRED IN UPDATE_LOCKBOX_TEMP - '||SQLERRM);

600: EXCEPTION
601: WHEN others THEN
602: v_retcode := '2';
603: v_errbuf := 'update_lockbox_temp '||sqlerrm;
604: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'ERROR OCCURRED IN UPDATE_LOCKBOX_TEMP - '||SQLERRM);
605: ROLLBACK;
606: RAISE;
607:
608: END update_lockbox_temp;

Line 641: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

637: last_update_date = v_last_update_date
638: where cash_receipt_id = v_cash_receipt_id
639: and cash_receipt_line_id = v_cash_receipt_line_id;
640:
641: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
642: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE INTERIM LINES TABLE SETTING AMOUNT = '
643: ||to_char(v_decrease_appl_amt)||' on cash_receipt_id '
644: ||to_char(v_cash_receipt_id));
645: END IF;

Line 642: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE INTERIM LINES TABLE SETTING AMOUNT = '

638: where cash_receipt_id = v_cash_receipt_id
639: and cash_receipt_line_id = v_cash_receipt_line_id;
640:
641: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
642: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE INTERIM LINES TABLE SETTING AMOUNT = '
643: ||to_char(v_decrease_appl_amt)||' on cash_receipt_id '
644: ||to_char(v_cash_receipt_id));
645: END IF;
646:

Line 652: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'ERROR OCCURRED IN UPDATE_INTERIM_TABLE - '||SQLERRM);

648: EXCEPTION
649: WHEN others THEN
650: v_retcode := '2';
651: v_errbuf := 'update_interim_table '||sqlerrm;
652: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'ERROR OCCURRED IN UPDATE_INTERIM_TABLE - '||SQLERRM);
653: ROLLBACK;
654: RAISE;
655:
656: END update_interim_table;