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.JL_AR_RECEIVABLE_APPLICATIONS dependencies on FND_FILE

Line 41: fnd_file.put_line(fnd_file.log,'adjgen1');

37:
38: BEGIN
39:
40: /* Check if the adjustment amount is within the limit from the user */
41: fnd_file.put_line(fnd_file.log,'adjgen1');
42: fnd_file.put_line(fnd_file.log,' adjustment generation');
43:
44: BEGIN
45: SELECT 'Y'

Line 42: fnd_file.put_line(fnd_file.log,' adjustment generation');

38: BEGIN
39:
40: /* Check if the adjustment amount is within the limit from the user */
41: fnd_file.put_line(fnd_file.log,'adjgen1');
42: fnd_file.put_line(fnd_file.log,' adjustment generation');
43:
44: BEGIN
45: SELECT 'Y'
46: INTO x_approved_amount

Line 68: fnd_file.put_line(fnd_file.log,'After validate and def');

64: WHERE customer_trx_id = x_customer_trx_id;
65:
66: l_result := ARP_STANDARD.validate_and_default_gl_date(x_receipt_date,x_trans_date,null,null,null,null,null,null,null,null,null,null,x_rcpt_out,x_def_rule,x_err_msg);
67:
68: fnd_file.put_line(fnd_file.log,'After validate and def');
69: SELECT x_user_id,
70: sysdate,
71: x_user_id,
72: x_user_id,

Line 116: fnd_file.put_line(fnd_file.log,'After ar_system_params');

112: adj_rec.POSTING_CONTROL_ID,
113: adj_rec.ACCTD_AMOUNT,
114: adj_rec.ORG_ID
115: FROM ar_system_parameters arsp;
116: fnd_file.put_line(fnd_file.log,'After ar_system_params');
117:
118: arp_util.enable_debug;
119:
120: fnd_file.put_line(fnd_file.log,'Before create_adjustment');

Line 120: fnd_file.put_line(fnd_file.log,'Before create_adjustment');

116: fnd_file.put_line(fnd_file.log,'After ar_system_params');
117:
118: arp_util.enable_debug;
119:
120: fnd_file.put_line(fnd_file.log,'Before create_adjustment');
121: ar_adjust_pub.create_adjustment( p_api_name => 'AR_ADJUST_PUB',
122: p_api_version => 1.0,
123: p_msg_count => x_msg_count,
124: p_msg_data => x_msg_data,

Line 129: fnd_file.put_line(fnd_file.log,'After create_adjustment');

125: p_return_status => x_return_status,
126: p_adj_rec => adj_rec,
127: p_new_adjust_number => x_adjustment_number,
128: p_new_adjust_id => x_adjustment_id);
129: fnd_file.put_line(fnd_file.log,'After create_adjustment');
130:
131: IF PG_DEBUG in ('Y', 'C') THEN
132: arp_util.debug ('adjustment_generation: ' || 'return status: ' || x_return_status);
133: arp_util.debug ('adjustment_generation: ' || 'msg_count : ' || x_msg_count);

Line 257: fnd_file.put_line(fnd_file.log,'Before adjustment generation(1)');

253: (( x_writeoff_amount IS NOT NULL ) AND
254: ((x_calculated_interest - x_received_interest ) <=
255: x_writeoff_amount ))
256: THEN
257: fnd_file.put_line(fnd_file.log,'Before adjustment generation(1)');
258: adjustment_generation (
259: fnd_global.user_id,
260: x_calc_interest_rectrx_id,
261: x_calc_interest_ccid,

Line 269: fnd_file.put_line(fnd_file.log,'Before adjustment generation(2)');

265: x_cash_receipt_id,
266: x_customer_trx_id
267: );
268:
269: fnd_file.put_line(fnd_file.log,'Before adjustment generation(2)');
270: adjustment_generation (
271: fnd_global.user_id,
272: x_writeoff_rectrx_id,
273: x_writeoff_ccid,

Line 281: fnd_file.put_line(fnd_file.log,'Before adjustment generation(3)');

277: x_cash_receipt_id,
278: x_customer_trx_id
279: );
280: ELSE
281: fnd_file.put_line(fnd_file.log,'Before adjustment generation(3)');
282: adjustment_generation (
283: fnd_global.user_id,
284: x_calc_interest_rectrx_id,
285: x_calc_interest_ccid,

Line 292: fnd_file.put_line(fnd_file.log,'Before adjustment generation(4)');

288: x_payment_schedule_id,
289: x_cash_receipt_id,
290: x_customer_trx_id
291: );
292: fnd_file.put_line(fnd_file.log,'Before adjustment generation(4)');
293: adjustment_generation (
294: fnd_global.user_id,
295: x_calc_interest_rectrx_id,
296: x_calc_interest_ccid,

Line 303: fnd_file.put_line(fnd_file.log,'Before adjustment generation(5)');

299: x_payment_schedule_id,
300: x_cash_receipt_id,
301: x_customer_trx_id
302: );
303: fnd_file.put_line(fnd_file.log,'Before adjustment generation(5)');
304: adjustment_generation (
305: fnd_global.user_id,
306: x_writeoff_rectrx_id,
307: x_writeoff_ccid,

Line 318: fnd_file.put_line(fnd_file.log,'Before generate idm');

314: END IF;
315: x_writeoff_date := fnd_date.date_to_canonical(x_rcpt_date);
316:
317: elsif NVL(x_interest_difference_action,'$') = 'GENERATE_IDM' then
318: fnd_file.put_line(fnd_file.log,'Before generate idm');
319: adjustment_generation (
320: fnd_global.user_id,
321: x_calc_interest_rectrx_id,
322: x_calc_interest_ccid,

Line 337: fnd_file.put_line(fnd_file.log,'Before jlbrinterestdebitmemo');

333: /* Date format for Stored Procedures */
334: x_rcpt_date_mm := to_date(x_rcpt_date_char,'DD-MM-YYYY');
335: x_rcpt_date_mm_char := to_char(x_rcpt_date_mm,'DD-MM-YYYY');
336:
337: fnd_file.put_line(fnd_file.log,'Before jlbrinterestdebitmemo');
338:
339: jl_br_ar_generate_debit_memo.jl_br_interest_debit_memo (x_customer_trx_id,
340: x_calculated_interest - x_received_interest ,
341: x_user_id,

Line 352: fnd_file.put_line(fnd_file.log,'After jlbrinterestdebitmemo'||x_return);

348: x_int_revenue_ccid,
349: l_error_code,
350: l_error_msg,
351: l_error_token);
352: fnd_file.put_line(fnd_file.log,'After jlbrinterestdebitmemo'||x_return);
353: IF x_return = '1' THEN
354: fnd_file.put_line(fnd_file.log,'After jlbrinterestdebitmemo');
355: IF PG_DEBUG in ('Y', 'C') THEN
356: arp_util.debug('calc_greaterthan_rec: ' || 'PROBLEMA NA CRIACAO DA NOTA DE DEBITO DE JUROS !!!');

Line 354: fnd_file.put_line(fnd_file.log,'After jlbrinterestdebitmemo');

350: l_error_msg,
351: l_error_token);
352: fnd_file.put_line(fnd_file.log,'After jlbrinterestdebitmemo'||x_return);
353: IF x_return = '1' THEN
354: fnd_file.put_line(fnd_file.log,'After jlbrinterestdebitmemo');
355: IF PG_DEBUG in ('Y', 'C') THEN
356: arp_util.debug('calc_greaterthan_rec: ' || 'PROBLEMA NA CRIACAO DA NOTA DE DEBITO DE JUROS !!!');
357: END IF;
358: END IF;

Line 389: fnd_file.put_line(fnd_file.log,'Before calc greaterthan rec tol');

385: l_error_code NUMBER;
386: l_error_msg VARCHAR2(2000);
387: l_error_token VARCHAR2(100);
388: BEGIN
389: fnd_file.put_line(fnd_file.log,'Before calc greaterthan rec tol');
390: IF (( x_writeoff_tolerance IS NOT NULL ) AND
391: (((x_calculated_interest - x_received_interest )/
392: x_invoice_amount) <= x_writeoff_tolerance ))
393: OR

Line 398: fnd_file.put_line(fnd_file.log,'Before adjustment generation 6');

394: (( x_writeoff_amount IS NOT NULL ) AND
395: ((x_calculated_interest - x_received_interest ) <=
396: x_writeoff_amount ))
397: THEN
398: fnd_file.put_line(fnd_file.log,'Before adjustment generation 6');
399: adjustment_generation (
400: fnd_global.user_id,
401: x_calc_interest_rectrx_id,
402: x_calc_interest_ccid,

Line 409: fnd_file.put_line(fnd_file.log,'Before adjustment generation 7');

405: x_payment_schedule_id,
406: x_cash_receipt_id,
407: x_customer_trx_id);
408:
409: fnd_file.put_line(fnd_file.log,'Before adjustment generation 7');
410: fnd_file.put_line(fnd_file.log,'After 1st adjustment');
411: adjustment_generation (
412: fnd_global.user_id,
413: x_writeoff_rectrx_id,

Line 410: fnd_file.put_line(fnd_file.log,'After 1st adjustment');

406: x_cash_receipt_id,
407: x_customer_trx_id);
408:
409: fnd_file.put_line(fnd_file.log,'Before adjustment generation 7');
410: fnd_file.put_line(fnd_file.log,'After 1st adjustment');
411: adjustment_generation (
412: fnd_global.user_id,
413: x_writeoff_rectrx_id,
414: x_writeoff_ccid,

Line 420: fnd_file.put_line(fnd_file.log,'After 2nd adjustment');

416: x_rcpt_date,
417: x_payment_schedule_id,
418: x_cash_receipt_id,
419: x_customer_trx_id);
420: fnd_file.put_line(fnd_file.log,'After 2nd adjustment');
421:
422: x_writeoff_date := fnd_date.date_to_canonical(x_rcpt_date);
423:
424: fnd_file.put_line(fnd_file.log,'After 3rd adjustment');

Line 424: fnd_file.put_line(fnd_file.log,'After 3rd adjustment');

420: fnd_file.put_line(fnd_file.log,'After 2nd adjustment');
421:
422: x_writeoff_date := fnd_date.date_to_canonical(x_rcpt_date);
423:
424: fnd_file.put_line(fnd_file.log,'After 3rd adjustment');
425:
426: ELSE
427: IF nvl(x_received_interest,0) > 0 THEN
428: fnd_file.put_line(fnd_file.log,'Before adjustment generation 8');

Line 428: fnd_file.put_line(fnd_file.log,'Before adjustment generation 8');

424: fnd_file.put_line(fnd_file.log,'After 3rd adjustment');
425:
426: ELSE
427: IF nvl(x_received_interest,0) > 0 THEN
428: fnd_file.put_line(fnd_file.log,'Before adjustment generation 8');
429: adjustment_generation (
430: fnd_global.user_id,
431: x_calc_interest_rectrx_id,
432: x_calc_interest_ccid,

Line 440: fnd_file.put_line(fnd_file.log,'Before debit memogeneration 8');

436: x_cash_receipt_id,
437: x_customer_trx_id);
438: END IF;
439:
440: fnd_file.put_line(fnd_file.log,'Before debit memogeneration 8');
441: jl_br_ar_generate_debit_memo.jl_br_interest_debit_memo (
442: x_customer_trx_id,
443: x_calculated_interest - x_received_interest ,
444: x_user_id,

Line 481: fnd_file.put_line(fnd_file.log,'Before adjustment generation 9');

477: x_user_id IN NUMBER,
478: x_customer_trx_id IN NUMBER) IS
479: BEGIN
480: IF NVL(x_calculated_interest ,0) > 0 THEN
481: fnd_file.put_line(fnd_file.log,'Before adjustment generation 9');
482: adjustment_generation (
483: fnd_global.user_id,
484: x_calc_interest_rectrx_id,
485: x_calc_interest_ccid,

Line 492: fnd_file.put_line(fnd_file.log,'Before adjustment generation 10');

488: x_payment_schedule_id,
489: x_cash_receipt_id,
490: x_customer_trx_id );
491: END IF;
492: fnd_file.put_line(fnd_file.log,'Before adjustment generation 10');
493: adjustment_generation (
494: fnd_global.user_id,
495: x_int_revenue_rectrx_id,
496: x_int_revenue_ccid,

Line 519: fnd_file.put_line(fnd_file.log,'Before adjustment generation 11');

515: x_cash_receipt_id IN NUMBER,
516: x_user_id IN NUMBER,
517: x_customer_trx_id IN NUMBER) IS
518: BEGIN
519: fnd_file.put_line(fnd_file.log,'Before adjustment generation 11');
520: adjustment_generation (
521: fnd_global.user_id,
522: x_calc_interest_rectrx_id,
523: x_calc_interest_ccid,

Line 571: fnd_file.put_line(fnd_file.log,'Inside Int treatment');

567:
568: x_calculated_interest := fnd_number.canonical_to_number(x_calc_interest);
569: x_received_interest := fnd_number.canonical_to_number(x_rec_interest);
570:
571: fnd_file.put_line(fnd_file.log,'Inside Int treatment');
572: fnd_file.put_line(fnd_file.log,'calc int'||to_char(x_calculated_interest));
573: fnd_file.put_line(fnd_file.log,'rec int'||to_char(x_received_interest));
574:
575: fnd_file.put_line(fnd_file.log,'Before get_accounts()');

Line 572: fnd_file.put_line(fnd_file.log,'calc int'||to_char(x_calculated_interest));

568: x_calculated_interest := fnd_number.canonical_to_number(x_calc_interest);
569: x_received_interest := fnd_number.canonical_to_number(x_rec_interest);
570:
571: fnd_file.put_line(fnd_file.log,'Inside Int treatment');
572: fnd_file.put_line(fnd_file.log,'calc int'||to_char(x_calculated_interest));
573: fnd_file.put_line(fnd_file.log,'rec int'||to_char(x_received_interest));
574:
575: fnd_file.put_line(fnd_file.log,'Before get_accounts()');
576: get_accounts(x_rcpt_method_id,

Line 573: fnd_file.put_line(fnd_file.log,'rec int'||to_char(x_received_interest));

569: x_received_interest := fnd_number.canonical_to_number(x_rec_interest);
570:
571: fnd_file.put_line(fnd_file.log,'Inside Int treatment');
572: fnd_file.put_line(fnd_file.log,'calc int'||to_char(x_calculated_interest));
573: fnd_file.put_line(fnd_file.log,'rec int'||to_char(x_received_interest));
574:
575: fnd_file.put_line(fnd_file.log,'Before get_accounts()');
576: get_accounts(x_rcpt_method_id,
577: x_remit_bank_acct_id,

Line 575: fnd_file.put_line(fnd_file.log,'Before get_accounts()');

571: fnd_file.put_line(fnd_file.log,'Inside Int treatment');
572: fnd_file.put_line(fnd_file.log,'calc int'||to_char(x_calculated_interest));
573: fnd_file.put_line(fnd_file.log,'rec int'||to_char(x_received_interest));
574:
575: fnd_file.put_line(fnd_file.log,'Before get_accounts()');
576: get_accounts(x_rcpt_method_id,
577: x_remit_bank_acct_id,
578: x_writeoff_tolerance,
579: x_writeoff_amount,

Line 588: fnd_file.put_line(fnd_file.log,'After get_accounts');

584: x_int_revenue_ccid,
585: x_int_revenue_rectrx_id,
586: x_return);
587:
588: fnd_file.put_line(fnd_file.log,'After get_accounts');
589:
590: get_ps_parameters(x_payment_schedule_id,
591: x_amount_due_original,
592: x_amount_due_remaining,

Line 595: fnd_file.put_line(fnd_file.log,'After get_psparams');

591: x_amount_due_original,
592: x_amount_due_remaining,
593: x_return);
594:
595: fnd_file.put_line(fnd_file.log,'After get_psparams');
596:
597: IF NVL(x_calculated_interest ,0) > NVL(x_received_interest ,0) THEN
598: IF x_interest_diff_action is NOT NULL THEN
599: fnd_file.put_line(fnd_file.log,'calc_greater_than_rec');

Line 599: fnd_file.put_line(fnd_file.log,'calc_greater_than_rec');

595: fnd_file.put_line(fnd_file.log,'After get_psparams');
596:
597: IF NVL(x_calculated_interest ,0) > NVL(x_received_interest ,0) THEN
598: IF x_interest_diff_action is NOT NULL THEN
599: fnd_file.put_line(fnd_file.log,'calc_greater_than_rec');
600: calc_greaterthan_rec( x_writeoff_tolerance,
601: x_writeoff_amount,
602: x_calculated_interest,
603: x_received_interest,

Line 622: fnd_file.put_line(fnd_file.log,'calc_greater_than_rec_tol');

618: x_interest_diff_action,
619: x_writeoff_date,
620: x_int_revenue_ccid);
621: ELSE
622: fnd_file.put_line(fnd_file.log,'calc_greater_than_rec_tol');
623: calc_greaterthan_rec_tol( x_writeoff_tolerance,
624: x_writeoff_amount,
625: x_calculated_interest,
626: x_received_interest,

Line 646: fnd_file.put_line(fnd_file.log,'calc_less_than_rec_tol');

642: x_int_revenue_ccid);
643: END IF;
644:
645: ELSIF NVL(x_calculated_interest ,0) < NVL(x_received_interest ,0) THEN
646: fnd_file.put_line(fnd_file.log,'calc_less_than_rec_tol');
647: calc_lessthan_rec( x_writeoff_tolerance,
648: x_writeoff_amount,
649: x_calculated_interest,
650: x_received_interest,

Line 662: fnd_file.put_line(fnd_file.log,'calc_equal_rec');

658: x_cash_receipt_id,
659: x_user_id,
660: x_customer_trx_id);
661: ELSIF x_received_interest > 0 THEN
662: fnd_file.put_line(fnd_file.log,'calc_equal_rec');
663: calc_equal_rec( x_writeoff_tolerance,
664: x_writeoff_amount,
665: x_calculated_interest,
666: x_received_interest,

Line 1506: fnd_file.put_line(fnd_file.log,'Inside3 jl_ar_receivable_applications.Create_interest_adjustment()+');

1502:
1503: BEGIN
1504:
1505: --IF PG_DEBUG in ('Y', 'C') THEN
1506: fnd_file.put_line(fnd_file.log,'Inside3 jl_ar_receivable_applications.Create_interest_adjustment()+');
1507: --END IF;
1508:
1509: fnd_file.put_line(fnd_file.log,'Rec Appl Id :'||to_char(p_post_quickcash_req_id));
1510:

Line 1509: fnd_file.put_line(fnd_file.log,'Rec Appl Id :'||to_char(p_post_quickcash_req_id));

1505: --IF PG_DEBUG in ('Y', 'C') THEN
1506: fnd_file.put_line(fnd_file.log,'Inside3 jl_ar_receivable_applications.Create_interest_adjustment()+');
1507: --END IF;
1508:
1509: fnd_file.put_line(fnd_file.log,'Rec Appl Id :'||to_char(p_post_quickcash_req_id));
1510:
1511: x_return_status := FND_API.G_RET_STS_SUCCESS;
1512: For rint in c_int(p_post_quickcash_req_id)
1513: Loop

Line 1515: fnd_file.put_line(fnd_file.log,'After opening the cursor()+');

1511: x_return_status := FND_API.G_RET_STS_SUCCESS;
1512: For rint in c_int(p_post_quickcash_req_id)
1513: Loop
1514:
1515: fnd_file.put_line(fnd_file.log,'After opening the cursor()+');
1516:
1517: update ar_receivable_applications_all
1518: set global_attribute1 = rint.global_attribute3 ,
1519: global_attribute2 = rint.global_attribute4 ,

Line 1530: fnd_file.put_line(fnd_file.log,'After update statement()+');

1526: global_attribute12 = rint.global_attribute10,
1527: global_attribute_category = 'JL.BR.ARXRWMAI.Additional Info'
1528: where receivable_application_id = rint.receivable_application_id;
1529:
1530: fnd_file.put_line(fnd_file.log,'After update statement()+');
1531:
1532: /* ---------------------------------------------------------------------- */
1533: /* Interest Treatment */
1534: /* ---------------------------------------------------------------------- */

Line 1535: fnd_file.put_line(fnd_file.log,'Before get_idm_profiles');

1531:
1532: /* ---------------------------------------------------------------------- */
1533: /* Interest Treatment */
1534: /* ---------------------------------------------------------------------- */
1535: fnd_file.put_line(fnd_file.log,'Before get_idm_profiles');
1536: fnd_file.put_line(fnd_file.log,'User Id '||to_char(fnd_global.user_id));
1537:
1538: JL_ZZ_AR_LIBRARY_1_PKG.get_idm_profiles_from_syspa (
1539: l_trx_type_idm,

Line 1536: fnd_file.put_line(fnd_file.log,'User Id '||to_char(fnd_global.user_id));

1532: /* ---------------------------------------------------------------------- */
1533: /* Interest Treatment */
1534: /* ---------------------------------------------------------------------- */
1535: fnd_file.put_line(fnd_file.log,'Before get_idm_profiles');
1536: fnd_file.put_line(fnd_file.log,'User Id '||to_char(fnd_global.user_id));
1537:
1538: JL_ZZ_AR_LIBRARY_1_PKG.get_idm_profiles_from_syspa (
1539: l_trx_type_idm,
1540: l_batch_source_idm,

Line 1563: fnd_file.put_line(fnd_file.log,'calc int'||rint.global_attribute1);

1559: ar_payment_schedules arps
1560: WHERE arps.payment_schedule_id = rint.applied_payment_schedule_id
1561: AND ract.customer_trx_id = arps.customer_trx_id;
1562:
1563: fnd_file.put_line(fnd_file.log,'calc int'||rint.global_attribute1);
1564: fnd_file.put_line(fnd_file.log,'rec int'||rint.global_attribute2);
1565: fnd_file.put_line(fnd_file.log,'main amt'||rint.global_attribute3);
1566:
1567: Interest_treatment (

Line 1564: fnd_file.put_line(fnd_file.log,'rec int'||rint.global_attribute2);

1560: WHERE arps.payment_schedule_id = rint.applied_payment_schedule_id
1561: AND ract.customer_trx_id = arps.customer_trx_id;
1562:
1563: fnd_file.put_line(fnd_file.log,'calc int'||rint.global_attribute1);
1564: fnd_file.put_line(fnd_file.log,'rec int'||rint.global_attribute2);
1565: fnd_file.put_line(fnd_file.log,'main amt'||rint.global_attribute3);
1566:
1567: Interest_treatment (
1568: rint.applied_payment_schedule_id,

Line 1565: fnd_file.put_line(fnd_file.log,'main amt'||rint.global_attribute3);

1561: AND ract.customer_trx_id = arps.customer_trx_id;
1562:
1563: fnd_file.put_line(fnd_file.log,'calc int'||rint.global_attribute1);
1564: fnd_file.put_line(fnd_file.log,'rec int'||rint.global_attribute2);
1565: fnd_file.put_line(fnd_file.log,'main amt'||rint.global_attribute3);
1566:
1567: Interest_treatment (
1568: rint.applied_payment_schedule_id,
1569: l_cust_trx_id,

Line 1588: fnd_file.put_line(fnd_file.log,'After interest_treatment');

1584: fnd_global.user_id,
1585: rint.remit_bank_acct_use_id,
1586: l_writeoff_date);
1587:
1588: fnd_file.put_line(fnd_file.log,'After interest_treatment');
1589:
1590: End Loop;
1591:
1592: --IF PG_DEBUG in ('Y', 'C') THEN