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

Line 5: fnd_file.put_line(fnd_file.output, msg);

1: PACKAGE BODY JE_ES_WHTAX AS
2: /* $Header: jeeswhtb.pls 120.15.12010000.3 2008/08/04 12:27:05 vgadde ship $ */
3: PROCEDURE plsqlmsg ( msg IN VARCHAR2) IS
4: BEGIN
5: fnd_file.put_line(fnd_file.output, msg);
6: END plsqlmsg;
7: PROCEDURE dbmsmsg( msg IN VARCHAR2) IS
8: BEGIN
9: fnd_file.put_line(fnd_file.log,msg);

Line 9: fnd_file.put_line(fnd_file.log,msg);

5: fnd_file.put_line(fnd_file.output, msg);
6: END plsqlmsg;
7: PROCEDURE dbmsmsg( msg IN VARCHAR2) IS
8: BEGIN
9: fnd_file.put_line(fnd_file.log,msg);
10: END dbmsmsg;
11: /* Delete EXTERNAL transactions */
12: PROCEDURE del_trans_x ( -- p_org_name IN VARCHAR2,-- Bug 5207771 org_id removed
13: p_legal_entity_name IN VARCHAR2,

Line 2027: fnd_file.put_line( fnd_file.log,'Parameters :');

2023: p_fetch_tax_rate := nvl(l_tax_rate,p_fetch_tax_rate);
2024: p_fetch_tax_name := nvl(l_tax_name,p_fetch_tax_name);
2025: end;
2026: BEGIN
2027: fnd_file.put_line( fnd_file.log,'Parameters :');
2028: fnd_file.put_line( fnd_file.log,'Selection Criteria : ' || p_pay_inv_sel );
2029: fnd_file.put_line( fnd_file.log,'Summary Report : ' || p_summary );
2030: fnd_file.put_line( fnd_file.log,'Date From : ' || p_date_from );
2031: fnd_file.put_line( fnd_file.log,'Date To : ' || p_date_to );

Line 2028: fnd_file.put_line( fnd_file.log,'Selection Criteria : ' || p_pay_inv_sel );

2024: p_fetch_tax_name := nvl(l_tax_name,p_fetch_tax_name);
2025: end;
2026: BEGIN
2027: fnd_file.put_line( fnd_file.log,'Parameters :');
2028: fnd_file.put_line( fnd_file.log,'Selection Criteria : ' || p_pay_inv_sel );
2029: fnd_file.put_line( fnd_file.log,'Summary Report : ' || p_summary );
2030: fnd_file.put_line( fnd_file.log,'Date From : ' || p_date_from );
2031: fnd_file.put_line( fnd_file.log,'Date To : ' || p_date_to );
2032: fnd_file.put_line( fnd_file.log,'Tax Type : ' || p_wht_tax_type );

Line 2029: fnd_file.put_line( fnd_file.log,'Summary Report : ' || p_summary );

2025: end;
2026: BEGIN
2027: fnd_file.put_line( fnd_file.log,'Parameters :');
2028: fnd_file.put_line( fnd_file.log,'Selection Criteria : ' || p_pay_inv_sel );
2029: fnd_file.put_line( fnd_file.log,'Summary Report : ' || p_summary );
2030: fnd_file.put_line( fnd_file.log,'Date From : ' || p_date_from );
2031: fnd_file.put_line( fnd_file.log,'Date To : ' || p_date_to );
2032: fnd_file.put_line( fnd_file.log,'Tax Type : ' || p_wht_tax_type );
2033: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || p_legal_entity_id );

Line 2030: fnd_file.put_line( fnd_file.log,'Date From : ' || p_date_from );

2026: BEGIN
2027: fnd_file.put_line( fnd_file.log,'Parameters :');
2028: fnd_file.put_line( fnd_file.log,'Selection Criteria : ' || p_pay_inv_sel );
2029: fnd_file.put_line( fnd_file.log,'Summary Report : ' || p_summary );
2030: fnd_file.put_line( fnd_file.log,'Date From : ' || p_date_from );
2031: fnd_file.put_line( fnd_file.log,'Date To : ' || p_date_to );
2032: fnd_file.put_line( fnd_file.log,'Tax Type : ' || p_wht_tax_type );
2033: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || p_legal_entity_id );
2034: fnd_file.put_line( fnd_file.log,'Organization id : ' || p_org_id );

Line 2031: fnd_file.put_line( fnd_file.log,'Date To : ' || p_date_to );

2027: fnd_file.put_line( fnd_file.log,'Parameters :');
2028: fnd_file.put_line( fnd_file.log,'Selection Criteria : ' || p_pay_inv_sel );
2029: fnd_file.put_line( fnd_file.log,'Summary Report : ' || p_summary );
2030: fnd_file.put_line( fnd_file.log,'Date From : ' || p_date_from );
2031: fnd_file.put_line( fnd_file.log,'Date To : ' || p_date_to );
2032: fnd_file.put_line( fnd_file.log,'Tax Type : ' || p_wht_tax_type );
2033: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || p_legal_entity_id );
2034: fnd_file.put_line( fnd_file.log,'Organization id : ' || p_org_id );
2035: fnd_file.put_line( fnd_file.log,' ');

Line 2032: fnd_file.put_line( fnd_file.log,'Tax Type : ' || p_wht_tax_type );

2028: fnd_file.put_line( fnd_file.log,'Selection Criteria : ' || p_pay_inv_sel );
2029: fnd_file.put_line( fnd_file.log,'Summary Report : ' || p_summary );
2030: fnd_file.put_line( fnd_file.log,'Date From : ' || p_date_from );
2031: fnd_file.put_line( fnd_file.log,'Date To : ' || p_date_to );
2032: fnd_file.put_line( fnd_file.log,'Tax Type : ' || p_wht_tax_type );
2033: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || p_legal_entity_id );
2034: fnd_file.put_line( fnd_file.log,'Organization id : ' || p_org_id );
2035: fnd_file.put_line( fnd_file.log,' ');
2036: -- Added for bug 5277700.

Line 2033: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || p_legal_entity_id );

2029: fnd_file.put_line( fnd_file.log,'Summary Report : ' || p_summary );
2030: fnd_file.put_line( fnd_file.log,'Date From : ' || p_date_from );
2031: fnd_file.put_line( fnd_file.log,'Date To : ' || p_date_to );
2032: fnd_file.put_line( fnd_file.log,'Tax Type : ' || p_wht_tax_type );
2033: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || p_legal_entity_id );
2034: fnd_file.put_line( fnd_file.log,'Organization id : ' || p_org_id );
2035: fnd_file.put_line( fnd_file.log,' ');
2036: -- Added for bug 5277700.
2037: SELECT COUNT(*)

Line 2034: fnd_file.put_line( fnd_file.log,'Organization id : ' || p_org_id );

2030: fnd_file.put_line( fnd_file.log,'Date From : ' || p_date_from );
2031: fnd_file.put_line( fnd_file.log,'Date To : ' || p_date_to );
2032: fnd_file.put_line( fnd_file.log,'Tax Type : ' || p_wht_tax_type );
2033: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || p_legal_entity_id );
2034: fnd_file.put_line( fnd_file.log,'Organization id : ' || p_org_id );
2035: fnd_file.put_line( fnd_file.log,' ');
2036: -- Added for bug 5277700.
2037: SELECT COUNT(*)
2038: INTO l_le_id_count

Line 2035: fnd_file.put_line( fnd_file.log,' ');

2031: fnd_file.put_line( fnd_file.log,'Date To : ' || p_date_to );
2032: fnd_file.put_line( fnd_file.log,'Tax Type : ' || p_wht_tax_type );
2033: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || p_legal_entity_id );
2034: fnd_file.put_line( fnd_file.log,'Organization id : ' || p_org_id );
2035: fnd_file.put_line( fnd_file.log,' ');
2036: -- Added for bug 5277700.
2037: SELECT COUNT(*)
2038: INTO l_le_id_count
2039: FROM je_es_modelo_190_all

Line 2109: -- fnd_file.put_line(fnd_file.log,'In Magnetic');

2105: tax_rate1,
2106: tax_name1;
2107: EXIT WHEN detail_paid%NOTFOUND;
2108: first_record := first_record + 1;
2109: -- fnd_file.put_line(fnd_file.log,'In Magnetic');
2110: -- Retain Old data
2111: if ( first_record = 1 ) then
2112: old_remun_type := remun_type1;
2113: old_sub_remun_type := sub_remun_type1;

Line 2389: -- fnd_file.put_line(fnd_file.log,'Net Amount: '||to_char(net_amount1));

2385: net_amount1 := round((((paid_amount + nvl(discount_amount,0))/ (invoice_amount - invoice_prepaid_amount - invoice_withheld_amount))* net_amount1),func_curr_precision);
2386: withholding_tax_amount1 := round((((paid_amount + nvl(discount_amount,0))/ (invoice_amount - invoice_prepaid_amount - invoice_withheld_amount))* invoice_withheld_amount * -1),func_curr_precision);
2387: end if; -- if nvl(inv_payment_status_flag,'N') ='Y' or <> 'Y'
2388: end if; -- if wht_mode = 'M'
2389: -- fnd_file.put_line(fnd_file.log,'Net Amount: '||to_char(net_amount1));
2390: -- fnd_file.put_line(fnd_file.log,'WHT Amount: '||to_char(withholding_tax_amount1));
2391: if ( withholding_tax_amount1 <>0 )
2392: or (tax_rate1 = 0) then -- Bug 1212074
2393: countrecs := countrecs + 1;

Line 2390: -- fnd_file.put_line(fnd_file.log,'WHT Amount: '||to_char(withholding_tax_amount1));

2386: withholding_tax_amount1 := round((((paid_amount + nvl(discount_amount,0))/ (invoice_amount - invoice_prepaid_amount - invoice_withheld_amount))* invoice_withheld_amount * -1),func_curr_precision);
2387: end if; -- if nvl(inv_payment_status_flag,'N') ='Y' or <> 'Y'
2388: end if; -- if wht_mode = 'M'
2389: -- fnd_file.put_line(fnd_file.log,'Net Amount: '||to_char(net_amount1));
2390: -- fnd_file.put_line(fnd_file.log,'WHT Amount: '||to_char(withholding_tax_amount1));
2391: if ( withholding_tax_amount1 <>0 )
2392: or (tax_rate1 = 0) then -- Bug 1212074
2393: countrecs := countrecs + 1;
2394: ins_trans( legal_entity_id => p_legal_entity_id,

Line 2530: -- fnd_file.put_line(fnd_file.log,'Before No data');

2526: tax_rate1,
2527: tax_name1,
2528: p_legal_entity_id,
2529: p_org_id);
2530: -- fnd_file.put_line(fnd_file.log,'Before No data');
2531: -- Automatic Withholding
2532: -- Withholding calculated at invoice payment time.
2533: if ( wht_mode = 'A' ) then
2534: if (nvl(inv_awt_flag,'N') = 'N') then

Line 2569: -- fnd_file.put_line(fnd_file.log,'Net Amount:' ||to_char(net_amount1));

2565: net_amount1 := round((((paid_amount + nvl(discount_amount,0))/ (invoice_amount - invoice_prepaid_amount - invoice_withheld_amount))* net_amount1),func_curr_precision);
2566: withholding_tax_amount1 := round((((paid_amount + nvl(discount_amount,0))/ (invoice_amount - invoice_prepaid_amount - invoice_withheld_amount))* invoice_withheld_amount * -1),func_curr_precision);
2567: end if; -- if nvl(inv_payment_status_flag,'N') = 'Y' or 'N'
2568: end if; -- if wht_mode = 'M'
2569: -- fnd_file.put_line(fnd_file.log,'Net Amount:' ||to_char(net_amount1));
2570: -- fnd_file.put_line(fnd_file.log,'WHT Amount:' ||to_char(withholding_tax_amount1));
2571: if ( withholding_tax_amount1 <>0 )
2572: or (tax_rate1 = 0) then -- Bug 1212074
2573: countrecs := countrecs + 1;

Line 2570: -- fnd_file.put_line(fnd_file.log,'WHT Amount:' ||to_char(withholding_tax_amount1));

2566: withholding_tax_amount1 := round((((paid_amount + nvl(discount_amount,0))/ (invoice_amount - invoice_prepaid_amount - invoice_withheld_amount))* invoice_withheld_amount * -1),func_curr_precision);
2567: end if; -- if nvl(inv_payment_status_flag,'N') = 'Y' or 'N'
2568: end if; -- if wht_mode = 'M'
2569: -- fnd_file.put_line(fnd_file.log,'Net Amount:' ||to_char(net_amount1));
2570: -- fnd_file.put_line(fnd_file.log,'WHT Amount:' ||to_char(withholding_tax_amount1));
2571: if ( withholding_tax_amount1 <>0 )
2572: or (tax_rate1 = 0) then -- Bug 1212074
2573: countrecs := countrecs + 1;
2574: ins_trans( legal_entity_id => p_legal_entity_id,