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

Line 255: Fnd_File.put_line(Fnd_File.LOG, 'Start procedure - jai_ap_match_tax_pkg.process_batch');

251: ------------------------------------------------------------------------------------------------------------------------ */
252: BEGIN
253:
254:
255: Fnd_File.put_line(Fnd_File.LOG, 'Start procedure - jai_ap_match_tax_pkg.process_batch');
256:
257: -- this cursor picks up the invoice lines from the temporary table but does not pick up such invoices which have
258: -- error_flag set to 'Y' for any of it's distribution lines.
259:

Line 365: Fnd_File.put_line(Fnd_File.LOG, ' Processed invoice number(id) : ' || v_invoice_number || '(' || v_prev_invoice_id || ')' );

361: INTO v_invoice_number
362: FROM ap_invoices_all
363: WHERE invoice_id = v_prev_invoice_id;
364:
365: Fnd_File.put_line(Fnd_File.LOG, ' Processed invoice number(id) : ' || v_invoice_number || '(' || v_prev_invoice_id || ')' );
366:
367: END IF;
368:
369: -- set the prev to current.

Line 447: Fnd_File.put_line(Fnd_File.LOG, v_error_mesg || ' FOR invoice number(id)/line id : ' || v_invoice_number

443: FROM ap_invoices_all
444: WHERE invoice_id = c_rec.invoice_id;
445:
446:
447: Fnd_File.put_line(Fnd_File.LOG, v_error_mesg || ' FOR invoice number(id)/line id : ' || v_invoice_number
448: || '(' || c_rec.invoice_id || ')/' || c_rec.invoice_line_number );
449: Fnd_File.put_line(Fnd_File.LOG, 'Error message - ' || v_errbuf);
450:
451: v_prev_invoice_id := c_rec.invoice_id;

Line 449: Fnd_File.put_line(Fnd_File.LOG, 'Error message - ' || v_errbuf);

445:
446:
447: Fnd_File.put_line(Fnd_File.LOG, v_error_mesg || ' FOR invoice number(id)/line id : ' || v_invoice_number
448: || '(' || c_rec.invoice_id || ')/' || c_rec.invoice_line_number );
449: Fnd_File.put_line(Fnd_File.LOG, 'Error message - ' || v_errbuf);
450:
451: v_prev_invoice_id := c_rec.invoice_id;
452: v_error_invoice := 'Y';
453:

Line 476: Fnd_File.put_line(Fnd_File.LOG, ' Processed invoice number(id) : ' || v_invoice_number || '(' || v_prev_invoice_id || ')' );

472: INTO v_invoice_number
473: FROM ap_invoices_all
474: WHERE invoice_id = v_prev_invoice_id;
475:
476: Fnd_File.put_line(Fnd_File.LOG, ' Processed invoice number(id) : ' || v_invoice_number || '(' || v_prev_invoice_id || ')' );
477:
478: END IF;
479:
480:

Line 481: Fnd_File.put_line(Fnd_File.LOG, 'SUCCESSFUL END PROCEDURE - jai_ap_match_tax_pkg.process_batch');

477:
478: END IF;
479:
480:
481: Fnd_File.put_line(Fnd_File.LOG, 'SUCCESSFUL END PROCEDURE - jai_ap_match_tax_pkg.process_batch');
482:
483: EXCEPTION
484:
485: WHEN OTHERS THEN

Line 502: Fnd_File.put_line(Fnd_File.LOG, 'Error END PROCEDURE - jai_ap_match_tax_pkg.process_batch');

498: WHERE ROWID = v_rowid;
499:
500: COMMIT;
501:
502: Fnd_File.put_line(Fnd_File.LOG, 'Error END PROCEDURE - jai_ap_match_tax_pkg.process_batch');
503: Fnd_File.put_line(Fnd_File.LOG, 'Error message - ' || p_errbuf);
504: RETURN;
505:
506: END process_batch;

Line 503: Fnd_File.put_line(Fnd_File.LOG, 'Error message - ' || p_errbuf);

499:
500: COMMIT;
501:
502: Fnd_File.put_line(Fnd_File.LOG, 'Error END PROCEDURE - jai_ap_match_tax_pkg.process_batch');
503: Fnd_File.put_line(Fnd_File.LOG, 'Error message - ' || p_errbuf);
504: RETURN;
505:
506: END process_batch;
507:

Line 1411: Fnd_File.put_line(Fnd_File.LOG, 'Start of function update_payment_schedule');

1407: where invoice_id = inv_id;
1408:
1409: begin
1410:
1411: Fnd_File.put_line(Fnd_File.LOG, 'Start of function update_payment_schedule');
1412:
1413: open c_total_payment_amt;
1414: fetch c_total_payment_amt into v_total_payment_amt;
1415: close c_total_payment_amt;

Line 1418: Fnd_File.put_line(Fnd_File.LOG, 'Cannot update payment schedule, total payment amount :'

1414: fetch c_total_payment_amt into v_total_payment_amt;
1415: close c_total_payment_amt;
1416:
1417: if nvl(v_total_payment_amt, -1) = -1 then --Modified by kunkumar for 5593895
1418: Fnd_File.put_line(Fnd_File.LOG, 'Cannot update payment schedule, total payment amount :'
1419: || to_char(v_total_payment_amt));
1420: return false;
1421: Elsif v_total_payment_amt = 0 Then
1422: v_total_payment_amt := 1;

Line 1474: Fnd_File.put_line(Fnd_File.LOG, 'exception from function update_payment_schedule');

1470: return true;
1471:
1472: exception
1473: when others then
1474: Fnd_File.put_line(Fnd_File.LOG, 'exception from function update_payment_schedule');
1475: Fnd_File.put_line(Fnd_File.LOG, sqlerrm);
1476: return false;
1477: end update_payment_schedule; -- bug # 3218978
1478:

Line 1475: Fnd_File.put_line(Fnd_File.LOG, sqlerrm);

1471:
1472: exception
1473: when others then
1474: Fnd_File.put_line(Fnd_File.LOG, 'exception from function update_payment_schedule');
1475: Fnd_File.put_line(Fnd_File.LOG, sqlerrm);
1476: return false;
1477: end update_payment_schedule; -- bug # 3218978
1478:
1479: -- Start added for bug#3332988

Line 1503: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(insert)');

1499: when others then
1500: IF SQLCODE = -6550 THEN
1501: -- object referred in EXECUTE IMMEDIATE is not available in the database
1502: null;
1503: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(insert)');
1504: ELSE
1505: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(insert)->'||SQLERRM);
1506: RAISE;
1507: END IF;

Line 1505: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(insert)->'||SQLERRM);

1501: -- object referred in EXECUTE IMMEDIATE is not available in the database
1502: null;
1503: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(insert)');
1504: ELSE
1505: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(insert)->'||SQLERRM);
1506: RAISE;
1507: END IF;
1508: end;
1509:

Line 1534: FND_FILE.put_line(FND_FILE.log, 'MRC API is not existing(update)');

1530: when others then
1531: IF SQLCODE = -6551 THEN --Modified by kunkumar for 5593895
1532: -- object referred in EXECUTE IMMEDIATE is not available in the database
1533: null;
1534: FND_FILE.put_line(FND_FILE.log, 'MRC API is not existing(update)');
1535: ELSE
1536: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(update)->'||SQLERRM);
1537: RAISE;
1538: END IF;

Line 1536: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(update)->'||SQLERRM);

1532: -- object referred in EXECUTE IMMEDIATE is not available in the database
1533: null;
1534: FND_FILE.put_line(FND_FILE.log, 'MRC API is not existing(update)');
1535: ELSE
1536: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(update)->'||SQLERRM);
1537: RAISE;
1538: END IF;
1539: end;
1540: /* End added for bug#3332988 */

Line 1582: Fnd_File.put_line(Fnd_File.LOG, 'Start of function apportion_tax_4_price_cor_inv');

1578: cur_quantity_invoiced NUMBER;
1579: v_count NUMBER;
1580: begin
1581:
1582: Fnd_File.put_line(Fnd_File.LOG, 'Start of function apportion_tax_4_price_cor_inv');
1583:
1584: begin
1585: execute immediate 'select /* price_correct_inv_id */, po_distribution_id, amount, quantity_invoiced
1586: from ap_invoice_lines_all

Line 1614: Fnd_File.put_line(Fnd_File.LOG, 'Original item line has -1 amount, cannot apportion tax');--Modified by kunkumar for 5593895

1610: fetch c_get_orig_tax_line into c_get_orig_tax_line_rec;
1611: close c_get_orig_tax_line;
1612:
1613: if c_check_orig_item_line_rec.amount = -1 then --Modified by kunkumar for 5593895
1614: Fnd_File.put_line(Fnd_File.LOG, 'Original item line has -1 amount, cannot apportion tax');--Modified by kunkumar for 5593895
1615: return p_tax_amount;
1616: end if;
1617:
1618: v_amount := ( c_get_orig_tax_line_rec.tax_amount / c_check_orig_item_line_rec.amount)

Line 1621: Fnd_File.put_line(Fnd_File.LOG, ' original amount / tax :' || c_check_orig_item_line_rec.amount

1617:
1618: v_amount := ( c_get_orig_tax_line_rec.tax_amount / c_check_orig_item_line_rec.amount)
1619: * cur_amount;
1620:
1621: Fnd_File.put_line(Fnd_File.LOG, ' original amount / tax :' || c_check_orig_item_line_rec.amount
1622: || '/' || c_get_orig_tax_line_rec.tax_amount);
1623:
1624: return round(v_amount, 2);
1625:

Line 1629: Fnd_File.put_line(Fnd_File.LOG, 'Exception function apportion_tax_4_price_cor_inv :' || sqlerrm);

1625:
1626:
1627: exception
1628: when others then
1629: Fnd_File.put_line(Fnd_File.LOG, 'Exception function apportion_tax_4_price_cor_inv :' || sqlerrm);
1630: return p_tax_amount;
1631: end apportion_tax_4_price_cor_inv;
1632:
1633:

Line 1675: Added the Fnd_File.put_line(Fnd_File.LOG,'') statements to

1671: Corrected it by using quantity_shipped in the r_for_shipment_line
1672: cursor instead of quantity_received.
1673: Quantity_shipped gives the original quantity of the receipt.
1674:
1675: Added the Fnd_File.put_line(Fnd_File.LOG,'') statements to
1676: generate the log also.
1677:
1678: 9. 09/10/2002 Aparajita for bug # 2483164 Version#615.1
1679: Populate the po distribution id and rcv_transactions id for the tax

Line 2110: Fnd_File.put_line(Fnd_File.LOG, 'Start procedure - jai_ap_match_tax_pkg.process_online ');

2106:
2107: ------------------------------------------------------------------------------------------------------- */
2108:
2109:
2110: Fnd_File.put_line(Fnd_File.LOG, 'Start procedure - jai_ap_match_tax_pkg.process_online ');
2111:
2112: OPEN get_ven_info(inv_id);
2113: FETCH get_ven_info INTO get_ven_info_rec;
2114: CLOSE get_ven_info;

Line 2116: Fnd_File.put_line(Fnd_File.LOG,

2112: OPEN get_ven_info(inv_id);
2113: FETCH get_ven_info INTO get_ven_info_rec;
2114: CLOSE get_ven_info;
2115: -- Using pn_invoice_line_number instead of dist_line_no for Bug#4445989
2116: Fnd_File.put_line(Fnd_File.LOG,
2117: 'Input parameters - invoice number(id)/ invoice line no/Matching option :'
2118: || get_ven_info_rec.invoice_num || '(' || inv_id || ')/' || pn_invoice_line_number || '/' || p_rematch);
2119:
2120:

Line 2124: Fnd_File.put_line(Fnd_File.LOG, 'Base invoice has been cancelled, no need to process tax');

2120:
2121: -- start added by bug#3206083
2122: if get_ven_info_rec.cancelled_date is not null then
2123: -- base invoice has been cancelled, no need to process tax.
2124: Fnd_File.put_line(Fnd_File.LOG, 'Base invoice has been cancelled, no need to process tax');
2125: return;
2126: end if;
2127: -- end added by bug#3206083
2128:

Line 2592: Fnd_File.put_line(Fnd_File.LOG, 'lv_accrue_on_receipt_flag='||lv_accrue_on_receipt_flag);

2588: (
2589: p_po_distribution_id => Nvl(po_dist_id,ln_po_dist_id)
2590: );
2591:
2592: Fnd_File.put_line(Fnd_File.LOG, 'lv_accrue_on_receipt_flag='||lv_accrue_on_receipt_flag);
2593:
2594: open c_jai_regimes(jai_constants.service_regime);
2595: fetch c_jai_regimes into r_jai_regimes;
2596: close c_jai_regimes;

Line 2617: Fnd_File.put_line(Fnd_File.LOG, 'inside p_rematch = PO_MATCHING ');

2613: (for_dist_insertion_rec.dist_code_combination_id);
2614:
2615: IF p_rematch = 'PO_MATCHING' THEN
2616:
2617: Fnd_File.put_line(Fnd_File.LOG, 'inside p_rematch = PO_MATCHING ');
2618: ---commented as receipt not required for pure po match
2619: /*following fetch commented out for bug 6595773*/
2620: /*OPEN from_po_distributions(po_dist_id);
2621: FETCH from_po_distributions INTO from_po_distributions_rec;

Line 2663: Fnd_File.put_line(Fnd_File.LOG, ' po match i.adhoc_flag = '||i.adhoc_flag);

2659: r_VAT_regime_tax_type := null;
2660:
2661: -- Start for bug#3752887
2662: --start additions for bug#12697697
2663: Fnd_File.put_line(Fnd_File.LOG, ' po match i.adhoc_flag = '||i.adhoc_flag);
2664: Fnd_File.put_line(Fnd_File.LOG, ' po match qty rate flag i.vat_flag = '||i.vat_flag);
2665: Fnd_File.put_line(Fnd_File.LOG, 'po match i.tax_type = '||i.tax_type);
2666: if i.adhoc_flag='Y' then
2667: -- start bug # 13024213

Line 2664: Fnd_File.put_line(Fnd_File.LOG, ' po match qty rate flag i.vat_flag = '||i.vat_flag);

2660:
2661: -- Start for bug#3752887
2662: --start additions for bug#12697697
2663: Fnd_File.put_line(Fnd_File.LOG, ' po match i.adhoc_flag = '||i.adhoc_flag);
2664: Fnd_File.put_line(Fnd_File.LOG, ' po match qty rate flag i.vat_flag = '||i.vat_flag);
2665: Fnd_File.put_line(Fnd_File.LOG, 'po match i.tax_type = '||i.tax_type);
2666: if i.adhoc_flag='Y' then
2667: -- start bug # 13024213
2668: --if i.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX') and i.vat_flag = 'Q' --Added IN clause for bug#13363329

Line 2665: Fnd_File.put_line(Fnd_File.LOG, 'po match i.tax_type = '||i.tax_type);

2661: -- Start for bug#3752887
2662: --start additions for bug#12697697
2663: Fnd_File.put_line(Fnd_File.LOG, ' po match i.adhoc_flag = '||i.adhoc_flag);
2664: Fnd_File.put_line(Fnd_File.LOG, ' po match qty rate flag i.vat_flag = '||i.vat_flag);
2665: Fnd_File.put_line(Fnd_File.LOG, 'po match i.tax_type = '||i.tax_type);
2666: if i.adhoc_flag='Y' then
2667: -- start bug # 13024213
2668: --if i.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX') and i.vat_flag = 'Q' --Added IN clause for bug#13363329
2669: if i.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX','Excise','EXCISE_EDUCATION_CESS','EXCISE_SH_EDU_CESS') and i.vat_flag = 'Q' -- for bug 16195110 by anupgupt

Line 2686: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount after apportioning = '|| v_tax_amount);

2682: else
2683: v_tax_amount := i.tax_amount * v_apportn_factor_for_item_line;
2684: end if;
2685:
2686: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount after apportioning = '|| v_tax_amount);
2687: --end additions for bug#12697697
2688:
2689: if i.currency <> for_org_id_rec.invoice_currency_code then
2690: v_tax_amount := v_tax_amount / for_org_id_rec.exchange_rate;

Line 2693: fnd_file.put_line(FND_FILE.LOG, ' Value of tax amount -> '|| v_tax_amount);

2689: if i.currency <> for_org_id_rec.invoice_currency_code then
2690: v_tax_amount := v_tax_amount / for_org_id_rec.exchange_rate;
2691: end if;
2692:
2693: fnd_file.put_line(FND_FILE.LOG, ' Value of tax amount -> '|| v_tax_amount);
2694:
2695: OPEN c_tax(i.tax_id);
2696: FETCH c_tax INTO c_tax_rec;
2697: CLOSE c_tax;

Line 2727: fnd_file.put_line(FND_FILE.LOG,

2723: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
2724: fetch c_regime_tax_type into r_service_regime_tax_type;
2725: close c_regime_tax_type;
2726:
2727: fnd_file.put_line(FND_FILE.LOG,
2728: ' Service regime: '||r_service_regime_tax_type.tax_type);
2729:
2730: /* Bug 5358788. Added by Lakshmi Gopalsami
2731: * Fetched the details of VAT regime

Line 2738: fnd_file.put_line(FND_FILE.LOG,

2734: open c_regime_tax_type(r_vat_regimes.regime_id, c_tax_rec.tax_type);
2735: fetch c_regime_tax_type into r_vat_regime_tax_type;
2736: close c_regime_tax_type;
2737:
2738: fnd_file.put_line(FND_FILE.LOG,
2739: ' VAT regime: '||r_vat_regime_tax_type.tax_type);
2740:
2741: /*following code added for bug 6595773*/
2742: /*6595773 start*/

Line 2752: Fnd_File.put_line(Fnd_File.LOG, 'ln_ship_to_organization_id='||ln_ship_to_organization_id

2748: ,ln_ship_to_location_id;
2749: close c_get_ship_to_org_loc;
2750:
2751:
2752: Fnd_File.put_line(Fnd_File.LOG, 'ln_ship_to_organization_id='||ln_ship_to_organization_id
2753: ||', r_po_lines_all.item_id='||r_po_lines_all.item_id
2754: );
2755: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
2756: (

Line 2787: fnd_file.put_line(FND_FILE.LOG,

2783: p_tax_type => c_tax_rec.tax_type,
2784: p_account_name => jai_constants.recovery_interim
2785: );
2786: /*Added by qinglei on 16-Feb-2012 for bug#13561173 end*/
2787: fnd_file.put_line(FND_FILE.LOG,
2788: ' Regime type , CCID '
2789: || r_service_regime_tax_type.tax_type
2790: ||', ' || v_dist_code_combination_id);
2791: /* Bug 5358788. Added by Lakshmi Gopalsami

Line 2798: Fnd_File.put_line(Fnd_File.LOG, 'lv_is_item_an_expense='||lv_is_item_an_expense);

2794: */
2795: /*following elsif and else modified / added for bug 6595773*/
2796: ELSIF r_vat_regime_tax_type.tax_type IS NOT NULL THEN
2797: -- p_rematch = 'PO_MATCHING' then
2798: Fnd_File.put_line(Fnd_File.LOG, 'lv_is_item_an_expense='||lv_is_item_an_expense);
2799: /* v_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account
2800: (
2801: p_regime_id => ln_vat_regime_id,
2802: p_organization_type => jai_constants.orgn_type_io,

Line 2812: fnd_file.put_line(FND_FILE.LOG,

2808: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id; --Added by Bgowrava for Bug#9499146
2809: ELSE
2810: /*v_dist_code_combination_id := c_tax_rec.tax_account_id;*/ --commented by Bgowrava for Bug#9499146
2811: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id; --Added by Bgowrava for Bug#9499146
2812: fnd_file.put_line(FND_FILE.LOG,
2813: ' Regime type , CCID '
2814: || r_vat_regime_tax_type.tax_type
2815: ||', ' || v_dist_code_combination_id);
2816:

Line 2841: fnd_file.put_line(FND_FILE.LOG, ' Value of tax amount after apportion -> '|| v_tax_amount);

2837: END IF;
2838: v_tax_amount := nvl(v_tax_amount,-1); --Modified by kunkumar for bug 5593895
2839: -- End bug#4103473
2840:
2841: fnd_file.put_line(FND_FILE.LOG, ' Value of tax amount after apportion -> '|| v_tax_amount);
2842: --start additions for bug#13422310
2843: fnd_file.put_line(FND_FILE.LOG, 'Before calling JAI_CALC_APMATCH_TAX parameters passed are ');
2844: fnd_file.put_line(FND_FILE.LOG, ' P_MATCH_TYPE -> '||'PO_MATCHING' ||' P_INVOICE_ID -> '||inv_id||
2845: ' P_INVOICE_line_no-> '||pn_invoice_line_number||' P_TAX_ID-> '||i.tax_id||' P_line_locaction_id-> '||ln_po_line_location_id||' P_tax_amount -> '|| v_tax_amount);

Line 2843: fnd_file.put_line(FND_FILE.LOG, 'Before calling JAI_CALC_APMATCH_TAX parameters passed are ');

2839: -- End bug#4103473
2840:
2841: fnd_file.put_line(FND_FILE.LOG, ' Value of tax amount after apportion -> '|| v_tax_amount);
2842: --start additions for bug#13422310
2843: fnd_file.put_line(FND_FILE.LOG, 'Before calling JAI_CALC_APMATCH_TAX parameters passed are ');
2844: fnd_file.put_line(FND_FILE.LOG, ' P_MATCH_TYPE -> '||'PO_MATCHING' ||' P_INVOICE_ID -> '||inv_id||
2845: ' P_INVOICE_line_no-> '||pn_invoice_line_number||' P_TAX_ID-> '||i.tax_id||' P_line_locaction_id-> '||ln_po_line_location_id||' P_tax_amount -> '|| v_tax_amount);
2846: jai_aptax_pkg_client_extn.JAI_CALC_APMATCH_TAX (P_MATCH_TYPE => 'PO_MATCHING',
2847: P_INVOICE_ID =>inv_id,

Line 2844: fnd_file.put_line(FND_FILE.LOG, ' P_MATCH_TYPE -> '||'PO_MATCHING' ||' P_INVOICE_ID -> '||inv_id||

2840:
2841: fnd_file.put_line(FND_FILE.LOG, ' Value of tax amount after apportion -> '|| v_tax_amount);
2842: --start additions for bug#13422310
2843: fnd_file.put_line(FND_FILE.LOG, 'Before calling JAI_CALC_APMATCH_TAX parameters passed are ');
2844: fnd_file.put_line(FND_FILE.LOG, ' P_MATCH_TYPE -> '||'PO_MATCHING' ||' P_INVOICE_ID -> '||inv_id||
2845: ' P_INVOICE_line_no-> '||pn_invoice_line_number||' P_TAX_ID-> '||i.tax_id||' P_line_locaction_id-> '||ln_po_line_location_id||' P_tax_amount -> '|| v_tax_amount);
2846: jai_aptax_pkg_client_extn.JAI_CALC_APMATCH_TAX (P_MATCH_TYPE => 'PO_MATCHING',
2847: P_INVOICE_ID =>inv_id,
2848: P_INVOICE_line_no =>pn_invoice_line_number,

Line 2853: fnd_file.put_line(FND_FILE.LOG, 'the tax amount after the JAI_CALC_APMATCH_TAX call is '||v_tax_amount);

2849: P_TAX_ID => i.tax_id ,
2850: P_line_location_id => ln_po_line_location_id,
2851: P_tax_amount => v_tax_amount
2852: );
2853: fnd_file.put_line(FND_FILE.LOG, 'the tax amount after the JAI_CALC_APMATCH_TAX call is '||v_tax_amount);
2854: --end additions for bug#13422310
2855: --
2856: -- Begin 5763527
2857: --

Line 2918: Fnd_File.put_line(Fnd_File.LOG, 'i.modvat_flag ='||i.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);

2914: END IF;--( NVL(i.inc_tax_flag,'N') = 'N' OR ( NVL(i.inc_tax_flag,'N'))
2915: -------------------------------------------------------------------------------------
2916: --added by Eric for inclusive tax on 20-dec-2007,end
2917:
2918: Fnd_File.put_line(Fnd_File.LOG, 'i.modvat_flag ='||i.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
2919:
2920: if i.modvat_flag = jai_constants.YES
2921: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
2922: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100

Line 2945: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||

2941: end if;
2942: --end additions for bug#11936596
2943:
2944:
2945: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
2946: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
2947: ',ln_nrec_tax_amt='||ln_nrec_tax_amt||' ln_inclurec_tax_amt '||ln_inclurec_tax_amt
2948: );
2949: --

Line 3232: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');

3228: END IF;
3229: -- ELSIF ( lv_tax_type <> 'PR' AND p_project_id IS NULL )
3230: -- THEN
3231: ELSE -- eric removed the above criteria for bug 6888665 and 6888209
3232: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');
3233: --The case process the inclusive NR tax and inclusive RE tax not for project
3234:
3235: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
3236: lv_modvat_flag := i.modvat_flag ;

Line 3254: Fnd_File.put_line(Fnd_File.LOG,

3250:
3251: --ln_inv_line_num := ln_inv_line_num + 1; commented out by eric for inclusive tax
3252:
3253: -- Added by Brathod for Bug#4445989
3254: Fnd_File.put_line(Fnd_File.LOG,
3255: 'Before inserting into ap_invoice_lines_all for line no :' || ln_inv_line_num );
3256:
3257: --insert exclusive tax to the ap tables
3258: --or insert recoverable inclusive tax with project information the ap tables

Line 3388: Fnd_File.put_line(Fnd_File.LOG,

3384: ) ;
3385: end if ;
3386:
3387: --End; --Added by kunkumar for bug 5593895
3388: Fnd_File.put_line(Fnd_File.LOG,
3389: 'Before inserting into ap_invoice_distributions_all for distribution line no :'
3390: ||v_distribution_no );
3391:
3392: -- Start bug#3332988

Line 3398: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);

3394: fetch c_get_invoice_distribution into v_invoice_distribution_id;
3395: close c_get_invoice_distribution;
3396: -- End bug#3332988
3397:
3398: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);
3399:
3400: IF NVL(lv_ap_line_to_inst_flag,'N')='Y'
3401: THEN
3402:

Line 3545: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');

3541: -----------------------------------------------------------------
3542: --added by Eric for inclusive tax on 20-dec-2007,end
3543:
3544:
3545: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
3546:
3547: --added by Eric for inclusive tax on 20-dec-2007,begin
3548: -----------------------------------------------------------------
3549: IF (NVL(lv_tax_line_to_inst_flag,'N') = 'Y')

Line 3693: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_CMN_FA_INV_DIST_ALL');

3689: ------------------------------------------------------------------
3690: --Modified by Eric for bug 8345512 on 13-Jul-2009,end
3691: END IF;
3692: /* Obsoleted as a part of R12 , Bug# 4445989
3693: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_CMN_FA_INV_DIST_ALL');
3694: INSERT INTO JAI_CMN_FA_INV_DIST_ALL
3695: (
3696: invoice_id,
3697: invoice_distribution_id,

Line 3738: fnd_file.put_line(fnd_file.log ,'separate accounting for inclusive taxes option is '||lv_inclu_tax_flag );

3734:
3735: OPEN inclu_flag_cur(v_org_id);
3736: FETCH inclu_flag_cur INTO lv_inclu_tax_flag;
3737: CLOSE inclu_flag_cur;
3738: fnd_file.put_line(fnd_file.log ,'separate accounting for inclusive taxes option is '||lv_inclu_tax_flag );
3739:
3740:
3741: If nvl(lv_accrue_on_receipt_flag ,'N')='Y'
3742: --and nvl(lv_inclu_tax_flag,'N')='Y'

Line 3744: fnd_file.put_line(fnd_file.log ,'Start the Insertion of Inclusive Service tax lines for POT recoverable service amount is '||ln_inclurec_tax_amt);

3740:
3741: If nvl(lv_accrue_on_receipt_flag ,'N')='Y'
3742: --and nvl(lv_inclu_tax_flag,'N')='Y'
3743: then
3744: fnd_file.put_line(fnd_file.log ,'Start the Insertion of Inclusive Service tax lines for POT recoverable service amount is '||ln_inclurec_tax_amt);
3745: lv_tax_line_amount := null;
3746: lv_ap_line_to_inst_flag := null;
3747: ln_inclu_serv_amt := null;
3748: v_dist_code_combination_id := null;

Line 3765: fnd_file.put_line(fnd_file.log ,'Inclusive Service tax lines for POT tax type '||c_tax_rec.tax_type ||' v_org_id '||v_org_id );

3761: then
3762:
3763: lv_tax_line_amount:= ln_inclu_serv_amt ;
3764: lv_ap_line_to_inst_flag := 'Y';
3765: fnd_file.put_line(fnd_file.log ,'Inclusive Service tax lines for POT tax type '||c_tax_rec.tax_type ||' v_org_id '||v_org_id );
3766: v_dist_code_combination_id := check_service_interim_account
3767: (
3768: lv_accrue_on_receipt_flag,
3769: lv_accounting_method_option,

Line 3777: fnd_file.put_line(fnd_file.log ,'Inclusive Service tax lines for positve recovery line POT interim recovery account is '||v_dist_code_combination_id);

3773: 'INCLUSIVE',--12813762
3774: c_tax_rec.tax_type,
3775: Nvl(po_dist_id,ln_po_dist_id)
3776: );
3777: fnd_file.put_line(fnd_file.log ,'Inclusive Service tax lines for positve recovery line POT interim recovery account is '||v_dist_code_combination_id);
3778:
3779: elsif inclu_Serv_line =2
3780: then
3781: lv_tax_line_amount := ln_inclu_serv_amt *-1 ;

Line 3784: fnd_file.put_line(fnd_file.log ,'Inclusive Service tax POT lines for negative recovery line ap accrual account is '||v_dist_code_combination_id);

3780: then
3781: lv_tax_line_amount := ln_inclu_serv_amt *-1 ;
3782: lv_ap_line_to_inst_flag := 'Y';
3783: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
3784: fnd_file.put_line(fnd_file.log ,'Inclusive Service tax POT lines for negative recovery line ap accrual account is '||v_dist_code_combination_id);
3785: end if;
3786: end if;-- pot ln_inclu_serv_amt <>0
3787: IF ( NVL(lv_ap_line_to_inst_flag,'N')='Y')
3788: THEN

Line 3797: Fnd_File.put_line(Fnd_File.LOG,'Before inserting Inclusive Service tax lines for POT into ap_invoice_lines_all for line no :'|| ln_inv_line_num ||' tax amount = '||lv_tax_line_amount);

3793: --For inclusive tax recoverable part, the positive invoice line should use invoice_line_number
3794: --when insert jai_ap_match_inv_taxes used; for the negative line, will use ln_inv_line_num + 1 as
3795: --line number.
3796: --Modified by Qinglei on 10-Feb-2012 for bug#13589613 end
3797: Fnd_File.put_line(Fnd_File.LOG,'Before inserting Inclusive Service tax lines for POT into ap_invoice_lines_all for line no :'|| ln_inv_line_num ||' tax amount = '||lv_tax_line_amount);
3798:
3799: INSERT INTO ap_invoice_lines_all
3800: (
3801: INVOICE_ID

Line 3864: Fnd_File.put_line(Fnd_File.LOG,

3860: /* End 5763527 */
3861: ,po_dist_id --Added for bug#6780154
3862: );
3863:
3864: Fnd_File.put_line(Fnd_File.LOG,
3865: 'Before inserting Inclusive Service tax lines for POT into ap_invoice_distributions_all for distribution line no :' || v_distribution_no);
3866:
3867:
3868: open c_get_invoice_distribution;

Line 3873: fnd_file.put_line(FND_FILE.LOG, 'Inclusive Service tax lines for POT Invoice distribution id '|| v_invoice_distribution_id);

3869: fetch c_get_invoice_distribution into v_invoice_distribution_id;
3870: close c_get_invoice_distribution;
3871:
3872:
3873: fnd_file.put_line(FND_FILE.LOG, 'Inclusive Service tax lines for POT Invoice distribution id '|| v_invoice_distribution_id);
3874:
3875: INSERT INTO ap_invoice_distributions_all
3876: (accounting_date,
3877: accrual_posted_flag,

Line 4072: Fnd_File.put_line(Fnd_File.LOG, 'inside p_rematch = PAY_ON_RECEIPT ');

4068: /*Bug 8866084 - End*/
4069:
4070: ELSIF p_rematch = 'PAY_ON_RECEIPT' THEN
4071:
4072: Fnd_File.put_line(Fnd_File.LOG, 'inside p_rematch = PAY_ON_RECEIPT ');
4073:
4074: IF p_receipt_code = 'RECEIPT' THEN
4075:
4076: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = RECEIPT ');

Line 4076: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = RECEIPT ');

4072: Fnd_File.put_line(Fnd_File.LOG, 'inside p_rematch = PAY_ON_RECEIPT ');
4073:
4074: IF p_receipt_code = 'RECEIPT' THEN
4075:
4076: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = RECEIPT ');
4077:
4078: /* Begin 5763527 */
4079: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);
4080: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id

Line 4079: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);

4075:
4076: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = RECEIPT ');
4077:
4078: /* Begin 5763527 */
4079: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);
4080: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id
4081: ,cp_organization_id => r_rcv_transactions.organization_id --Added by Bgowrava for Bug#7503308
4082: ,cp_shipment_header_id => p_shipment_header_id --Added by Bgowrava for Bug#7503308
4083: ,cp_txn_type => 'DELIVER' --Added by Bgowrava for Bug#7503308

Line 4162: fnd_file.put_line(FND_FILE.LOG,

4158: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
4159: fetch c_regime_tax_type into r_service_regime_tax_type;
4160: close c_regime_tax_type;
4161:
4162: fnd_file.put_line(FND_FILE.LOG,
4163: ' Service regime: '||r_service_regime_tax_type.tax_type);
4164:
4165: /* Bug 5358788. Added by Lakshmi Gopalsami
4166: * Fetched the details of VAT regime

Line 4173: fnd_file.put_line(FND_FILE.LOG,

4169: OPEN c_regime_tax_type(r_vat_regimes.regime_id, c_tax_rec.tax_type);
4170: FETCH c_regime_tax_type INTO r_vat_regime_tax_type;
4171: CLOSE c_regime_tax_type;
4172:
4173: fnd_file.put_line(FND_FILE.LOG,
4174: ' VAT regime: '||r_vat_regime_tax_type.tax_type);
4175:
4176: if r_service_regime_tax_type.tax_type is not null then
4177: /* Service type of tax */

Line 4189: fnd_file.put_line(FND_FILE.LOG,

4185: p_rematch,
4186: c_tax_rec.tax_type,
4187: po_dist_id --Added by JMEENA for bug#6833506
4188: );
4189: fnd_file.put_line(FND_FILE.LOG,
4190: ' Regime type , CCID '
4191: || r_service_regime_tax_type.tax_type
4192: ||', ' || v_dist_code_combination_id);
4193:

Line 4203: fnd_file.put_line(FND_FILE.LOG,

4199: ELSIF r_vat_regime_tax_type.tax_type IS NOT NULL THEN
4200: --p_rematch = 'PO_MATCHING' then
4201:
4202: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
4203: fnd_file.put_line(FND_FILE.LOG,
4204: ' Regime type , CCID '
4205: || r_vat_regime_tax_type.tax_type
4206: ||', ' || v_dist_code_combination_id);
4207: END IF;

Line 4239: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.adhoc_flag = '||tax_lines1_rec.adhoc_flag);

4235:
4236:
4237: -- Start for bug#3752887
4238: --start additions for bug#12697697
4239: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.adhoc_flag = '||tax_lines1_rec.adhoc_flag);
4240: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.vat_flag = '||tax_lines1_rec.vat_flag);
4241: Fnd_File.put_line(Fnd_File.LOG, ' tax_lines1_rec.tax_type = '||tax_lines1_rec.tax_type);
4242: if tax_lines1_rec.adhoc_flag='Y' then
4243: -- start bug # 13024213

Line 4240: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.vat_flag = '||tax_lines1_rec.vat_flag);

4236:
4237: -- Start for bug#3752887
4238: --start additions for bug#12697697
4239: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.adhoc_flag = '||tax_lines1_rec.adhoc_flag);
4240: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.vat_flag = '||tax_lines1_rec.vat_flag);
4241: Fnd_File.put_line(Fnd_File.LOG, ' tax_lines1_rec.tax_type = '||tax_lines1_rec.tax_type);
4242: if tax_lines1_rec.adhoc_flag='Y' then
4243: -- start bug # 13024213
4244: --if tax_lines1_rec.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX') and tax_lines1_rec.vat_flag = 'Q' --Added IN clause for bug 13363329

Line 4241: Fnd_File.put_line(Fnd_File.LOG, ' tax_lines1_rec.tax_type = '||tax_lines1_rec.tax_type);

4237: -- Start for bug#3752887
4238: --start additions for bug#12697697
4239: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.adhoc_flag = '||tax_lines1_rec.adhoc_flag);
4240: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.vat_flag = '||tax_lines1_rec.vat_flag);
4241: Fnd_File.put_line(Fnd_File.LOG, ' tax_lines1_rec.tax_type = '||tax_lines1_rec.tax_type);
4242: if tax_lines1_rec.adhoc_flag='Y' then
4243: -- start bug # 13024213
4244: --if tax_lines1_rec.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX') and tax_lines1_rec.vat_flag = 'Q' --Added IN clause for bug 13363329
4245: if tax_lines1_rec.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX','Excise','EXCISE_EDUCATION_CESS','EXCISE_SH_EDU_CESS') and tax_lines1_rec.vat_flag = 'Q' -- for bug 16195110 by anupgupt

Line 4261: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount after apportiong '||v_tax_amount);

4257: end if;
4258: else
4259: v_tax_amount := tax_lines1_rec.tax_amount * v_apportn_factor_for_item_line;
4260: end if;
4261: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount after apportiong '||v_tax_amount);
4262:
4263: --end additions for bug#12697697
4264:
4265: if for_org_id_rec.invoice_currency_code <> tax_lines1_rec.currency then

Line 4279: Fnd_File.put_line(Fnd_File.LOG, 'c_tax_rec.tax_type='||c_tax_rec.tax_type ||',lv_excise_costing_flag='||lv_excise_costing_flag);

4275: v_tax_amount := nvl(v_tax_amount,-1);
4276: -- End bug#4103473
4277:
4278: /* Bug#5763527 */
4279: Fnd_File.put_line(Fnd_File.LOG, 'c_tax_rec.tax_type='||c_tax_rec.tax_type ||',lv_excise_costing_flag='||lv_excise_costing_flag);
4280: if UPPER(c_tax_rec.tax_type) like '%EXCISE%' then
4281: if lv_excise_costing_flag = 'Y' then
4282: IF nvl(lv_accrue_on_receipt_flag,'#') <> 'Y' -- Bug 6338371
4283: then

Line 4327: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.modvat_flag ='||tax_lines1_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);

4323: END IF;--( NVL(tax_lines1_recinc_tax_flag,'N') = 'N')
4324: -------------------------------------------------------------------------------------
4325: --added by Eric for inclusive tax on 20-dec-2007,end
4326:
4327: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.modvat_flag ='||tax_lines1_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
4328:
4329: if tax_lines1_rec.modvat_flag = jai_constants.YES
4330: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
4331: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0

Line 4344: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||

4340: ln_nrec_tax_amt := round ( nvl(v_tax_amount,0) - nvl(ln_rec_tax_amt,0) , c_tax_rec.rounding_factor) ;
4341: /* Added Tax rounding based on tax rounding factor for bug 6761425 by vumaasha */
4342: lv_tax_type := 'PR'; --changed by eric for inclusive tax on Jan 4,2008
4343: end if;
4344: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
4345: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
4346: ',ln_nrec_tax_amt='||ln_nrec_tax_amt
4347: );
4348:

Line 4542: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');

4538: END IF;
4539: -- ELSIF ( lv_tax_type <> 'PR' AND p_project_id IS NULL )
4540: -- THEN
4541: ELSE -- eric removed the above criteria for bug 6888665 and 6888209
4542: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');
4543: --The case process the inclusive NR tax and inclusive RE tax not for project
4544:
4545: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
4546: lv_modvat_flag := tax_lines1_rec.modvat_flag ;

Line 4558: fnd_file.put_line(fnd_file.log, 'line='||line||', v_tax_amount='|| v_tax_amount

4554:
4555:
4556:
4557:
4558: fnd_file.put_line(fnd_file.log, 'line='||line||', v_tax_amount='|| v_tax_amount
4559: ||'lv_modvat_flag='||lv_modvat_flag
4560: ||'v_assets_tracking_flag='||v_assets_tracking_flag
4561: );
4562:

Line 4568: Fnd_File.put_line(Fnd_File.LOG,

4564: --
4565: -- End 5763527
4566: --
4567:
4568: Fnd_File.put_line(Fnd_File.LOG,
4569: 'Before inserting into ap_invoice_lines_all for line no :'|| ln_inv_line_num );
4570:
4571:
4572: --insert exclusive tax to the ap tables

Line 4658: Fnd_File.put_line(Fnd_File.LOG,

4654: /* End 5763527 */
4655: ,po_dist_id --Added for bug#6780154
4656: );
4657:
4658: Fnd_File.put_line(Fnd_File.LOG,
4659: 'Before inserting into ap_invoice_distributions_all for distribution line no : '
4660: ||v_distribution_no);
4661:
4662: -- Start bug#3332988

Line 4668: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);

4664: fetch c_get_invoice_distribution into v_invoice_distribution_id;
4665: close c_get_invoice_distribution;
4666: -- End bug#3332988
4667:
4668: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);
4669:
4670: INSERT INTO ap_invoice_distributions_all
4671: (
4672: accounting_date,

Line 4793: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');

4789: END IF; --( NVL(lv_ap_line_to_inst_flag,'N')='Y')
4790: ------------------------------------------------------
4791: --added by Eric for inclusive tax on 20-dec-2007,end
4792:
4793: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
4794: INSERT INTO JAI_AP_MATCH_INV_TAXES
4795: (
4796: tax_distribution_id,
4797: exchange_rate_variance,

Line 4914: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_CMN_FA_INV_DIST_ALL ');

4910: --Modified by Eric for bug 8345512 on 13-Jul-2009,end
4911:
4912:
4913: /* Obsoleted as part of R12 , Bug# 4445989
4914: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_CMN_FA_INV_DIST_ALL ');
4915:
4916: INSERT INTO JAI_CMN_FA_INV_DIST_ALL
4917: (
4918: invoice_id,

Line 4988: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = PACKING_SLIP');

4984: */
4985:
4986: ELSIF p_receipt_code = 'PACKING_SLIP' THEN
4987:
4988: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = PACKING_SLIP');
4989:
4990: /* Begin 5763527 */
4991: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);
4992: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id

Line 4991: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);

4987:
4988: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = PACKING_SLIP');
4989:
4990: /* Begin 5763527 */
4991: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);
4992: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id
4993: ,cp_organization_id => r_rcv_transactions.organization_id --Added by Bgowrava for Bug#7503308
4994: ,cp_shipment_header_id => p_shipment_header_id --Added by Bgowrava for Bug#7503308
4995: ,cp_txn_type => 'DELIVER' --Added by Bgowrava for Bug#7503308

Line 5072: fnd_file.put_line(FND_FILE.LOG,

5068: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
5069: fetch c_regime_tax_type into r_service_regime_tax_type;
5070: close c_regime_tax_type;
5071:
5072: fnd_file.put_line(FND_FILE.LOG,
5073: ' Service regime: '||r_service_regime_tax_type.tax_type);
5074:
5075: /* Bug 5358788. Added by Lakshmi Gopalsami
5076: * Fetched the details of VAT regime

Line 5083: fnd_file.put_line(FND_FILE.LOG,

5079: OPEN c_regime_tax_type(r_vat_regimes.regime_id, c_tax_rec.tax_type);
5080: FETCH c_regime_tax_type INTO r_vat_regime_tax_type;
5081: CLOSE c_regime_tax_type;
5082:
5083: fnd_file.put_line(FND_FILE.LOG,
5084: ' VAT regime: '||r_vat_regime_tax_type.tax_type);
5085:
5086: if r_service_regime_tax_type.tax_type is not null then
5087: /* Service type of tax */

Line 5100: fnd_file.put_line(FND_FILE.LOG,

5096: c_tax_rec.tax_type,
5097: po_dist_id --Added by JMEENA for bug#6833506
5098: );
5099:
5100: fnd_file.put_line(FND_FILE.LOG,
5101: ' Regime type , CCID '
5102: || r_service_regime_tax_type.tax_type
5103: ||', ' || v_dist_code_combination_id);
5104:

Line 5114: fnd_file.put_line(FND_FILE.LOG,

5110: ELSIF r_vat_regime_tax_type.tax_type IS NOT NULL THEN
5111: --p_rematch = 'PO_MATCHING' then
5112:
5113: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
5114: fnd_file.put_line(FND_FILE.LOG,
5115: ' Regime type , CCID '
5116: || r_vat_regime_tax_type.tax_type
5117: ||', ' || v_dist_code_combination_id);
5118:

Line 5144: Fnd_File.put_line(Fnd_File.LOG, 'c_tax_rec.tax_type='||c_tax_rec.tax_type ||',lv_excise_costing_flag='||lv_excise_costing_flag);

5140:
5141: /* Service End */
5142:
5143: /* Bug#5763527 */
5144: Fnd_File.put_line(Fnd_File.LOG, 'c_tax_rec.tax_type='||c_tax_rec.tax_type ||',lv_excise_costing_flag='||lv_excise_costing_flag);
5145: if UPPER(c_tax_rec.tax_type) like '%EXCISE%' then
5146: if lv_excise_costing_flag = 'Y' then
5147: IF nvl(lv_accrue_on_receipt_flag,'#') <> 'Y' -- Bug 6338371
5148: then

Line 5209: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.modvat_flag ='||tax_lines1_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);

5205: -------------------------------------------------------------------------------------
5206: --added by Eric for inclusive tax on 20-dec-2007,end
5207:
5208:
5209: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.modvat_flag ='||tax_lines1_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
5210:
5211: if tax_lines1_rec.modvat_flag = jai_constants.YES
5212: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
5213: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100

Line 5237: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||

5233: end if;
5234: --end additions for bug#11936596
5235:
5236:
5237: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
5238: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
5239: ',ln_nrec_tax_amt='||ln_nrec_tax_amt ||' ln_inclurec_tax_amt '||ln_inclurec_tax_amt
5240: );
5241:

Line 5440: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');

5436: END IF;
5437: -- ELSIF ( lv_tax_type <> 'PR' AND p_project_id IS NULL )
5438: -- THEN
5439: ELSE -- eric removed the above criteria for bug 6888665 and 6888209
5440: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');
5441: --The case process the inclusive NR tax and inclusive RE tax not for project
5442:
5443: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
5444: lv_modvat_flag := tax_lines1_rec.modvat_flag ;

Line 5455: Fnd_File.put_line(Fnd_File.LOG,'Before inserting into ap_invoice_lines_all for line no :'

5451: --added by Eric for inclusive tax on 20-dec-2007,end
5452:
5453:
5454:
5455: Fnd_File.put_line(Fnd_File.LOG,'Before inserting into ap_invoice_lines_all for line no :'
5456: || ln_inv_line_num );
5457:
5458:
5459: --insert exclusive tax to the ap tables

Line 5545: Fnd_File.put_line(Fnd_File.LOG,

5541: /* End 5763527 */
5542: ,po_dist_id --Added for bug#6780154
5543: );
5544:
5545: Fnd_File.put_line(Fnd_File.LOG,
5546: 'Before inserting into ap_invoice_distributions_all for distribution line no : ' || v_distribution_no);
5547:
5548: -- Start bug#3332988
5549: open c_get_invoice_distribution;

Line 5554: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);

5550: fetch c_get_invoice_distribution into v_invoice_distribution_id;
5551: close c_get_invoice_distribution;
5552: -- End bug#3332988
5553:
5554: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);
5555:
5556: INSERT INTO ap_invoice_distributions_all
5557: (
5558: accounting_date,

Line 5683: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');

5679: ----------------------------------------------------------------
5680: --added by Eric for inclusive tax on 20-dec-2007,end
5681:
5682:
5683: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
5684:
5685: --added by Eric for inclusive tax on 20-dec-2007,begin
5686: -----------------------------------------------------------------
5687: IF (NVL(lv_tax_line_to_inst_flag,'N') = 'Y')

Line 5819: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_CMN_FA_INV_DIST_ALL ');

5815: ------------------------------------------------------------------
5816: --Modified by Eric for bug 8345512 on 13-Jul-2009,end
5817:
5818: /* Obsoleted as part of R12 , Bug# 4445989
5819: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_CMN_FA_INV_DIST_ALL ');
5820: INSERT INTO JAI_CMN_FA_INV_DIST_ALL
5821: (
5822: invoice_id,
5823: invoice_distribution_id,

Line 5897: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = RCV_MATCHING');

5893:
5894: ELSIF p_rematch = 'RCV_MATCHING' THEN
5895:
5896:
5897: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = RCV_MATCHING');
5898:
5899: /* Begin 5763527 */
5900: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);
5901: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id

Line 5900: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);

5896:
5897: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = RCV_MATCHING');
5898:
5899: /* Begin 5763527 */
5900: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);
5901: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id
5902: ,cp_organization_id => r_rcv_transactions.organization_id --Added by Bgowrava for Bug#7503308
5903: ,cp_shipment_header_id => p_shipment_header_id --Added by Bgowrava for Bug#7503308
5904: ,cp_txn_type => 'DELIVER' --Added by Bgowrava for Bug#7503308

Line 5924: Fnd_File.put_line(Fnd_File.LOG, ' ');

5920: -----------------------------------------------------------
5921: -- Modified by Jason Liu for retroactive price on 2008/01/09
5922: -- Added the parameter lv_source
5923: FOR r_tax_lines_rec IN r_tax_lines_cur(rcv_tran_id,for_org_id_rec.vendor_id,lv_source) LOOP
5924: Fnd_File.put_line(Fnd_File.LOG, ' ');
5925: /* 5763527 */
5926: ln_project_id := null;
5927: ln_task_id := null;
5928: lv_exp_type := null;

Line 5980: Fnd_File.put_line(Fnd_File.LOG, 'c_tax_rec.mod_cr_percentage = '||c_tax_rec.mod_cr_percentage);

5976: v_dist_code_combination_id := null;
5977: --initial the tax_type
5978: lv_tax_type := NULL;--added by eric for inclusive tax on 20-Dec,2007
5979:
5980: Fnd_File.put_line(Fnd_File.LOG, 'c_tax_rec.mod_cr_percentage = '||c_tax_rec.mod_cr_percentage);
5981: -- 5763527, Brathod
5982: -- Modified the if condition to consider partial recoverable lines previous logic was hadling only when it is 100
5983: if r_tax_lines_rec.modvat_flag = jai_constants.YES
5984: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0

Line 5990: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '||lv_tax_type);

5986: /* recoverable tax */
5987: lv_tax_type := 'RE'; --added by eric for inclusive tax on 20-dec,2007
5988: v_assets_tracking_flag := 'N';
5989:
5990: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '||lv_tax_type);
5991:
5992: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
5993: fetch c_regime_tax_type into r_service_regime_tax_type;
5994: close c_regime_tax_type;

Line 5996: fnd_file.put_line(FND_FILE.LOG,

5992: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
5993: fetch c_regime_tax_type into r_service_regime_tax_type;
5994: close c_regime_tax_type;
5995:
5996: fnd_file.put_line(FND_FILE.LOG,
5997: ' Service regime: '||r_service_regime_tax_type.tax_type);
5998:
5999: /* Bug 5358788. Added by Lakshmi Gopalsami
6000: * Fetched the details of VAT regime

Line 6007: fnd_file.put_line(FND_FILE.LOG,

6003: OPEN c_regime_tax_type(r_vat_regimes.regime_id, c_tax_rec.tax_type);
6004: FETCH c_regime_tax_type INTO r_vat_regime_tax_type;
6005: CLOSE c_regime_tax_type;
6006:
6007: fnd_file.put_line(FND_FILE.LOG,
6008: ' VAT regime: '||r_vat_regime_tax_type.tax_type);
6009:
6010: if r_service_regime_tax_type.tax_type is not null then
6011: /* Service type of tax */

Line 6024: fnd_file.put_line(FND_FILE.LOG,

6020: c_tax_rec.tax_type,
6021: po_dist_id --Added by JMEENA for bug#6833506
6022: );
6023: v_assets_tracking_flag := 'N'; /*Added by abezgam Bug# 10375894 */
6024: fnd_file.put_line(FND_FILE.LOG,
6025: ' Regime type , CCID '
6026: || r_service_regime_tax_type.tax_type
6027: ||', ' || v_dist_code_combination_id);
6028:

Line 6039: fnd_file.put_line(FND_FILE.LOG,

6035: --p_rematch = 'RCV_MATCHING' then
6036:
6037: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
6038: v_assets_tracking_flag := 'N'; /*Added by abezgam Bug# 10375894 */
6039: fnd_file.put_line(FND_FILE.LOG,
6040: ' Regime type , CCID '
6041: || r_vat_regime_tax_type.tax_type
6042: ||', ' || v_dist_code_combination_id);
6043:

Line 6061: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '||lv_tax_type);

6057: END if;
6058:
6059: --non recoverable
6060: lv_tax_type := 'NR'; --added by eric for inclusive tax on 20-dec,2007
6061: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '||lv_tax_type);
6062: Fnd_File.put_line(Fnd_File.LOG, 'lv_accrue_on_receipt_flag = '||lv_accrue_on_receipt_flag);
6063: end if; /*nvl(c_tax_rec.mod_cr_percentage, 0) = 100 and c_tax_rec.tax_account_id is not null*/
6064:
6065:

Line 6062: Fnd_File.put_line(Fnd_File.LOG, 'lv_accrue_on_receipt_flag = '||lv_accrue_on_receipt_flag);

6058:
6059: --non recoverable
6060: lv_tax_type := 'NR'; --added by eric for inclusive tax on 20-dec,2007
6061: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '||lv_tax_type);
6062: Fnd_File.put_line(Fnd_File.LOG, 'lv_accrue_on_receipt_flag = '||lv_accrue_on_receipt_flag);
6063: end if; /*nvl(c_tax_rec.mod_cr_percentage, 0) = 100 and c_tax_rec.tax_account_id is not null*/
6064:
6065:
6066: /* Bug#4177452*/

Line 6072: Fnd_File.put_line(Fnd_File.LOG, 'v_dist_code_combination_id : ' || v_dist_code_combination_id ) ;

6068: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
6069: end if;
6070:
6071: /*following line added for bug 6595773*/
6072: Fnd_File.put_line(Fnd_File.LOG, 'v_dist_code_combination_id : ' || v_dist_code_combination_id ) ;
6073: /* Service End */
6074:
6075: -- Start for bug#3752887
6076:

Line 6077: Fnd_File.put_line(Fnd_File.LOG, 'v_apportn_factor_for_item_line = '||v_apportn_factor_for_item_line);

6073: /* Service End */
6074:
6075: -- Start for bug#3752887
6076:
6077: Fnd_File.put_line(Fnd_File.LOG, 'v_apportn_factor_for_item_line = '||v_apportn_factor_for_item_line);
6078: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '||v_tax_amount);
6079:
6080: --start additions for bug#12697697
6081: Fnd_File.put_line(Fnd_File.LOG, 'r_tax_lines_rec.adhoc_flag = '||r_tax_lines_rec.adhoc_flag);

Line 6078: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '||v_tax_amount);

6074:
6075: -- Start for bug#3752887
6076:
6077: Fnd_File.put_line(Fnd_File.LOG, 'v_apportn_factor_for_item_line = '||v_apportn_factor_for_item_line);
6078: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '||v_tax_amount);
6079:
6080: --start additions for bug#12697697
6081: Fnd_File.put_line(Fnd_File.LOG, 'r_tax_lines_rec.adhoc_flag = '||r_tax_lines_rec.adhoc_flag);
6082: Fnd_File.put_line(Fnd_File.LOG, 'r_tax_lines_rec.vat_flag = '||r_tax_lines_rec.vat_flag);

Line 6081: Fnd_File.put_line(Fnd_File.LOG, 'r_tax_lines_rec.adhoc_flag = '||r_tax_lines_rec.adhoc_flag);

6077: Fnd_File.put_line(Fnd_File.LOG, 'v_apportn_factor_for_item_line = '||v_apportn_factor_for_item_line);
6078: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '||v_tax_amount);
6079:
6080: --start additions for bug#12697697
6081: Fnd_File.put_line(Fnd_File.LOG, 'r_tax_lines_rec.adhoc_flag = '||r_tax_lines_rec.adhoc_flag);
6082: Fnd_File.put_line(Fnd_File.LOG, 'r_tax_lines_rec.vat_flag = '||r_tax_lines_rec.vat_flag);
6083: Fnd_File.put_line(Fnd_File.LOG, ' r_tax_lines_rec.tax_type = '||r_tax_lines_rec.tax_type);
6084: if r_tax_lines_rec.adhoc_flag='Y' then
6085: -- start bug # 13024213

Line 6082: Fnd_File.put_line(Fnd_File.LOG, 'r_tax_lines_rec.vat_flag = '||r_tax_lines_rec.vat_flag);

6078: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '||v_tax_amount);
6079:
6080: --start additions for bug#12697697
6081: Fnd_File.put_line(Fnd_File.LOG, 'r_tax_lines_rec.adhoc_flag = '||r_tax_lines_rec.adhoc_flag);
6082: Fnd_File.put_line(Fnd_File.LOG, 'r_tax_lines_rec.vat_flag = '||r_tax_lines_rec.vat_flag);
6083: Fnd_File.put_line(Fnd_File.LOG, ' r_tax_lines_rec.tax_type = '||r_tax_lines_rec.tax_type);
6084: if r_tax_lines_rec.adhoc_flag='Y' then
6085: -- start bug # 13024213
6086: --if r_tax_lines_rec.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX') and r_tax_lines_rec.vat_flag = 'Q' ---Added In clause for bug# 13363329

Line 6083: Fnd_File.put_line(Fnd_File.LOG, ' r_tax_lines_rec.tax_type = '||r_tax_lines_rec.tax_type);

6079:
6080: --start additions for bug#12697697
6081: Fnd_File.put_line(Fnd_File.LOG, 'r_tax_lines_rec.adhoc_flag = '||r_tax_lines_rec.adhoc_flag);
6082: Fnd_File.put_line(Fnd_File.LOG, 'r_tax_lines_rec.vat_flag = '||r_tax_lines_rec.vat_flag);
6083: Fnd_File.put_line(Fnd_File.LOG, ' r_tax_lines_rec.tax_type = '||r_tax_lines_rec.tax_type);
6084: if r_tax_lines_rec.adhoc_flag='Y' then
6085: -- start bug # 13024213
6086: --if r_tax_lines_rec.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX') and r_tax_lines_rec.vat_flag = 'Q' ---Added In clause for bug# 13363329
6087: if r_tax_lines_rec.tax_type in ('Freight','Insurance','Octrai','Other','PURCHASE TAX','ENTRY TAX','Excise','EXCISE_EDUCATION_CESS','EXCISE_SH_EDU_CESS') and r_tax_lines_rec.vat_flag = 'Q' -- for bug 16195110 by anupgupt

Line 6103: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount after apportioning = '||v_tax_amount);

6099: end if;
6100: else
6101: v_tax_amount := r_tax_lines_rec.tax_amount * v_apportn_factor_for_item_line;
6102: end if;
6103: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount after apportioning = '||v_tax_amount);
6104: --end additions for bug#12697697
6105:
6106: if for_org_id_rec.invoice_currency_code <> r_tax_lines_rec.currency then
6107: v_tax_amount := v_tax_amount / for_org_id_rec.exchange_rate;

Line 6111: Fnd_File.put_line(Fnd_File.LOG, 'c_tax_rec.tax_type='||c_tax_rec.tax_type ||',lv_excise_costing_flag='||lv_excise_costing_flag);

6107: v_tax_amount := v_tax_amount / for_org_id_rec.exchange_rate;
6108: end if;
6109:
6110: /* Bug#5763527 */
6111: Fnd_File.put_line(Fnd_File.LOG, 'c_tax_rec.tax_type='||c_tax_rec.tax_type ||',lv_excise_costing_flag='||lv_excise_costing_flag);
6112: if UPPER(c_tax_rec.tax_type) like '%EXCISE%' then
6113:
6114: if lv_excise_costing_flag = 'Y' THEN
6115: IF nvl(lv_accrue_on_receipt_flag , '#') <> 'Y' -- Bug 6338371

Line 6155: fnd_file.put_line(FND_FILE.LOG, 'Before calling JAI_CALC_APMATCH_TAX parameters passed are ');

6151: v_tax_amount := nvl(v_tax_amount, -1); --Modified by kunkumar for bug#5593895
6152: -- End bug#4103473
6153:
6154: --start additions for bug#13422310
6155: fnd_file.put_line(FND_FILE.LOG, 'Before calling JAI_CALC_APMATCH_TAX parameters passed are ');
6156: fnd_file.put_line(FND_FILE.LOG, ' P_MATCH_TYPE -> '||'RCV_MATCHING'||' P_INVOICE_ID -> '||inv_id||
6157: ' P_INVOICE_line_no-> '||pn_invoice_line_number||' P_TAX_ID-> '||r_tax_lines_rec.tax_id||'p_rcv_transaction_id -> '|| rcv_tran_id||' P_tax_amount -> '|| v_tax_amount);
6158: jai_aptax_pkg_client_extn.JAI_CALC_APMATCH_TAX (P_MATCH_TYPE => 'RCV_MATCHING',
6159: P_INVOICE_ID =>inv_id,

Line 6156: fnd_file.put_line(FND_FILE.LOG, ' P_MATCH_TYPE -> '||'RCV_MATCHING'||' P_INVOICE_ID -> '||inv_id||

6152: -- End bug#4103473
6153:
6154: --start additions for bug#13422310
6155: fnd_file.put_line(FND_FILE.LOG, 'Before calling JAI_CALC_APMATCH_TAX parameters passed are ');
6156: fnd_file.put_line(FND_FILE.LOG, ' P_MATCH_TYPE -> '||'RCV_MATCHING'||' P_INVOICE_ID -> '||inv_id||
6157: ' P_INVOICE_line_no-> '||pn_invoice_line_number||' P_TAX_ID-> '||r_tax_lines_rec.tax_id||'p_rcv_transaction_id -> '|| rcv_tran_id||' P_tax_amount -> '|| v_tax_amount);
6158: jai_aptax_pkg_client_extn.JAI_CALC_APMATCH_TAX (P_MATCH_TYPE => 'RCV_MATCHING',
6159: P_INVOICE_ID =>inv_id,
6160: P_INVOICE_line_no =>pn_invoice_line_number,

Line 6165: fnd_file.put_line(FND_FILE.LOG, 'the tax amount after the JAI_CALC_APMATCH_TAX call is '||v_tax_amount);

6161: P_TAX_ID => r_tax_lines_rec.tax_id,
6162: p_rcv_transaction_id => rcv_tran_id,
6163: P_tax_amount => v_tax_amount
6164: );
6165: fnd_file.put_line(FND_FILE.LOG, 'the tax amount after the JAI_CALC_APMATCH_TAX call is '||v_tax_amount);
6166: --end additions for bug#13422310
6167:
6168:
6169: --

Line 6202: Fnd_File.put_line(Fnd_File.LOG, 'r_tax_lines_rec.modvat_flag ='||r_tax_lines_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);

6198:
6199:
6200:
6201:
6202: Fnd_File.put_line(Fnd_File.LOG, 'r_tax_lines_rec.modvat_flag ='||r_tax_lines_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
6203:
6204: if r_tax_lines_rec.modvat_flag = jai_constants.YES
6205: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
6206: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100

Line 6229: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||

6225: ln_inclurec_tax_amt := round ( nvl(v_tax_amount,0) * (c_tax_rec.mod_cr_percentage/100) , c_tax_rec.rounding_factor) ;
6226: end if;
6227: --end additions for bug#11936596
6228:
6229: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
6230: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
6231: ',ln_nrec_tax_amt='||ln_nrec_tax_amt ||' ln_inclurec_tax_amt '||ln_inclurec_tax_amt
6232: );
6233:

Line 6242: Fnd_File.put_line(Fnd_File.LOG, 'ln_lines_to_insert ='|| ln_lines_to_insert);

6238: -- For ordinary lines (with modvat_flag = 'N' or with mod_cr_percentage = 100 fully recoverable) the variable
6239: -- ln_lines_to_insert will have value of 1 and hence only one line will be inserted with full tax amount
6240: --
6241:
6242: Fnd_File.put_line(Fnd_File.LOG, 'ln_lines_to_insert ='|| ln_lines_to_insert);
6243: for line in 1..ln_lines_to_insert
6244: loop
6245: --deleted by eric for inclusive tax on 04-Jan-2008,begin
6246: ---------------------------------------------------------------------------

Line 6291: Fnd_File.put_line(Fnd_File.LOG, 'line = '|| line);

6287: --deleted by eric for inclusive tax on 04-Jan-2008,end
6288:
6289: --added by Eric for inclusive tax on 20-dec-2007,begin
6290: ---------------------------------------------------------------------------
6291: Fnd_File.put_line(Fnd_File.LOG, 'line = '|| line);
6292: Fnd_File.put_line(Fnd_File.LOG, 'inc_tax_flag = '|| NVL(r_tax_lines_rec.inc_tax_flag,'N'));
6293: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '|| lv_tax_type);
6294: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '|| v_tax_amount);
6295: Fnd_File.put_line(Fnd_File.LOG, 'ln_nrec_tax_amt = '|| ln_nrec_tax_amt);

Line 6292: Fnd_File.put_line(Fnd_File.LOG, 'inc_tax_flag = '|| NVL(r_tax_lines_rec.inc_tax_flag,'N'));

6288:
6289: --added by Eric for inclusive tax on 20-dec-2007,begin
6290: ---------------------------------------------------------------------------
6291: Fnd_File.put_line(Fnd_File.LOG, 'line = '|| line);
6292: Fnd_File.put_line(Fnd_File.LOG, 'inc_tax_flag = '|| NVL(r_tax_lines_rec.inc_tax_flag,'N'));
6293: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '|| lv_tax_type);
6294: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '|| v_tax_amount);
6295: Fnd_File.put_line(Fnd_File.LOG, 'ln_nrec_tax_amt = '|| ln_nrec_tax_amt);
6296: Fnd_File.put_line(Fnd_File.LOG, 'ln_rec_tax_amt = '|| ln_rec_tax_amt );

Line 6293: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '|| lv_tax_type);

6289: --added by Eric for inclusive tax on 20-dec-2007,begin
6290: ---------------------------------------------------------------------------
6291: Fnd_File.put_line(Fnd_File.LOG, 'line = '|| line);
6292: Fnd_File.put_line(Fnd_File.LOG, 'inc_tax_flag = '|| NVL(r_tax_lines_rec.inc_tax_flag,'N'));
6293: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '|| lv_tax_type);
6294: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '|| v_tax_amount);
6295: Fnd_File.put_line(Fnd_File.LOG, 'ln_nrec_tax_amt = '|| ln_nrec_tax_amt);
6296: Fnd_File.put_line(Fnd_File.LOG, 'ln_rec_tax_amt = '|| ln_rec_tax_amt );
6297:

Line 6294: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '|| v_tax_amount);

6290: ---------------------------------------------------------------------------
6291: Fnd_File.put_line(Fnd_File.LOG, 'line = '|| line);
6292: Fnd_File.put_line(Fnd_File.LOG, 'inc_tax_flag = '|| NVL(r_tax_lines_rec.inc_tax_flag,'N'));
6293: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '|| lv_tax_type);
6294: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '|| v_tax_amount);
6295: Fnd_File.put_line(Fnd_File.LOG, 'ln_nrec_tax_amt = '|| ln_nrec_tax_amt);
6296: Fnd_File.put_line(Fnd_File.LOG, 'ln_rec_tax_amt = '|| ln_rec_tax_amt );
6297:
6298: IF (NVL(r_tax_lines_rec.inc_tax_flag,'N') = 'N')--exclusive case

Line 6295: Fnd_File.put_line(Fnd_File.LOG, 'ln_nrec_tax_amt = '|| ln_nrec_tax_amt);

6291: Fnd_File.put_line(Fnd_File.LOG, 'line = '|| line);
6292: Fnd_File.put_line(Fnd_File.LOG, 'inc_tax_flag = '|| NVL(r_tax_lines_rec.inc_tax_flag,'N'));
6293: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '|| lv_tax_type);
6294: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '|| v_tax_amount);
6295: Fnd_File.put_line(Fnd_File.LOG, 'ln_nrec_tax_amt = '|| ln_nrec_tax_amt);
6296: Fnd_File.put_line(Fnd_File.LOG, 'ln_rec_tax_amt = '|| ln_rec_tax_amt );
6297:
6298: IF (NVL(r_tax_lines_rec.inc_tax_flag,'N') = 'N')--exclusive case
6299: THEN

Line 6296: Fnd_File.put_line(Fnd_File.LOG, 'ln_rec_tax_amt = '|| ln_rec_tax_amt );

6292: Fnd_File.put_line(Fnd_File.LOG, 'inc_tax_flag = '|| NVL(r_tax_lines_rec.inc_tax_flag,'N'));
6293: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '|| lv_tax_type);
6294: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '|| v_tax_amount);
6295: Fnd_File.put_line(Fnd_File.LOG, 'ln_nrec_tax_amt = '|| ln_nrec_tax_amt);
6296: Fnd_File.put_line(Fnd_File.LOG, 'ln_rec_tax_amt = '|| ln_rec_tax_amt );
6297:
6298: IF (NVL(r_tax_lines_rec.inc_tax_flag,'N') = 'N')--exclusive case
6299: THEN
6300: Fnd_File.put_line(Fnd_File.LOG, 'Exclusive Branch');

Line 6300: Fnd_File.put_line(Fnd_File.LOG, 'Exclusive Branch');

6296: Fnd_File.put_line(Fnd_File.LOG, 'ln_rec_tax_amt = '|| ln_rec_tax_amt );
6297:
6298: IF (NVL(r_tax_lines_rec.inc_tax_flag,'N') = 'N')--exclusive case
6299: THEN
6300: Fnd_File.put_line(Fnd_File.LOG, 'Exclusive Branch');
6301: IF line = 1 then
6302:
6303: v_tax_amount := nvl(ln_rec_tax_amt, v_tax_amount);
6304: lv_tax_line_amount:= v_tax_amount ; --added by eric for inclusive tax

Line 6343: Fnd_File.put_line(Fnd_File.LOG, 'Inclusive Branch');

6339:
6340: END IF; --line = 1
6341: ELSIF (NVL(r_tax_lines_rec.inc_tax_flag,'N') = 'Y') --inclusive case
6342: THEN
6343: Fnd_File.put_line(Fnd_File.LOG, 'Inclusive Branch');
6344: IF( lv_tax_type ='PR')
6345: THEN
6346: Fnd_File.put_line(Fnd_File.LOG, 'PR Tax');
6347: IF ( line = 1 )

Line 6346: Fnd_File.put_line(Fnd_File.LOG, 'PR Tax');

6342: THEN
6343: Fnd_File.put_line(Fnd_File.LOG, 'Inclusive Branch');
6344: IF( lv_tax_type ='PR')
6345: THEN
6346: Fnd_File.put_line(Fnd_File.LOG, 'PR Tax');
6347: IF ( line = 1 )
6348: THEN
6349: --recoverable part
6350: v_tax_amount := ln_rec_tax_amt ;

Line 6410: Fnd_File.put_line(Fnd_File.LOG, 'RE Tax ,p_project_id IS NOT NULL');

6406: ELSIF ( lv_tax_type = 'RE'
6407: AND p_project_id IS NOT NULL
6408: )
6409: THEN
6410: Fnd_File.put_line(Fnd_File.LOG, 'RE Tax ,p_project_id IS NOT NULL');
6411: --recoverable tax without project infor
6412: IF ( line = 1 )
6413: THEN
6414: v_tax_amount := v_tax_amount ;

Line 6447: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');

6443: END IF;
6444: -- ELSIF ( lv_tax_type <> 'PR' AND p_project_id IS NULL )
6445: -- THEN
6446: ELSE -- eric removed the above criteria for bug 6888665 and 6888209
6447: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');
6448: --The case process the inclusive NR tax and inclusive RE tax not for project
6449:
6450: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
6451: lv_modvat_flag := r_tax_lines_rec.modvat_flag ;

Line 6464: Fnd_File.put_line(Fnd_File.LOG,'r_tax_lines_rec.tax_id :'|| r_tax_lines_rec.tax_id );

6460:
6461: --insert exclusive tax to the ap tables
6462: --or insert recoverable inclusive tax with project information the ap tables
6463:
6464: Fnd_File.put_line(Fnd_File.LOG,'r_tax_lines_rec.tax_id :'|| r_tax_lines_rec.tax_id );
6465: Fnd_File.put_line(Fnd_File.LOG,'line :'|| line );
6466: Fnd_File.put_line(Fnd_File.LOG,'lv_ap_line_to_inst_flag :'|| lv_ap_line_to_inst_flag );
6467: Fnd_File.put_line(Fnd_File.LOG,'lv_tax_line_to_inst_flag :'|| lv_tax_line_to_inst_flag );
6468:

Line 6465: Fnd_File.put_line(Fnd_File.LOG,'line :'|| line );

6461: --insert exclusive tax to the ap tables
6462: --or insert recoverable inclusive tax with project information the ap tables
6463:
6464: Fnd_File.put_line(Fnd_File.LOG,'r_tax_lines_rec.tax_id :'|| r_tax_lines_rec.tax_id );
6465: Fnd_File.put_line(Fnd_File.LOG,'line :'|| line );
6466: Fnd_File.put_line(Fnd_File.LOG,'lv_ap_line_to_inst_flag :'|| lv_ap_line_to_inst_flag );
6467: Fnd_File.put_line(Fnd_File.LOG,'lv_tax_line_to_inst_flag :'|| lv_tax_line_to_inst_flag );
6468:
6469: --1.Only exlusive taxes or inclusive recoverable taxes with project information

Line 6466: Fnd_File.put_line(Fnd_File.LOG,'lv_ap_line_to_inst_flag :'|| lv_ap_line_to_inst_flag );

6462: --or insert recoverable inclusive tax with project information the ap tables
6463:
6464: Fnd_File.put_line(Fnd_File.LOG,'r_tax_lines_rec.tax_id :'|| r_tax_lines_rec.tax_id );
6465: Fnd_File.put_line(Fnd_File.LOG,'line :'|| line );
6466: Fnd_File.put_line(Fnd_File.LOG,'lv_ap_line_to_inst_flag :'|| lv_ap_line_to_inst_flag );
6467: Fnd_File.put_line(Fnd_File.LOG,'lv_tax_line_to_inst_flag :'|| lv_tax_line_to_inst_flag );
6468:
6469: --1.Only exlusive taxes or inclusive recoverable taxes with project information
6470: -- are inserted into Ap Lines and Dist Lines

Line 6467: Fnd_File.put_line(Fnd_File.LOG,'lv_tax_line_to_inst_flag :'|| lv_tax_line_to_inst_flag );

6463:
6464: Fnd_File.put_line(Fnd_File.LOG,'r_tax_lines_rec.tax_id :'|| r_tax_lines_rec.tax_id );
6465: Fnd_File.put_line(Fnd_File.LOG,'line :'|| line );
6466: Fnd_File.put_line(Fnd_File.LOG,'lv_ap_line_to_inst_flag :'|| lv_ap_line_to_inst_flag );
6467: Fnd_File.put_line(Fnd_File.LOG,'lv_tax_line_to_inst_flag :'|| lv_tax_line_to_inst_flag );
6468:
6469: --1.Only exlusive taxes or inclusive recoverable taxes with project information
6470: -- are inserted into Ap Lines and Dist Lines
6471:

Line 6483: Fnd_File.put_line(Fnd_File.LOG,'Before inserting into ap_invoice_lines_all for line no :'|| ln_inv_line_num );

6479: ln_inv_line_num := ln_inv_line_num + 1; --added by eric for inlcusive tax
6480: ---------------------------------------------------------------------------
6481: --added by Eric for inclusive tax on 20-dec-2007,end
6482:
6483: Fnd_File.put_line(Fnd_File.LOG,'Before inserting into ap_invoice_lines_all for line no :'|| ln_inv_line_num );
6484:
6485: INSERT INTO ap_invoice_lines_all
6486: (
6487: INVOICE_ID

Line 6552: Fnd_File.put_line(Fnd_File.LOG,

6548: ,po_dist_id --Added for bug#6780154
6549: );
6550:
6551:
6552: Fnd_File.put_line(Fnd_File.LOG,
6553: 'Before inserting into ap_invoice_distributions_all for distribution line no :' || v_distribution_no);
6554:
6555: -- Start bug#3332988
6556: open c_get_invoice_distribution;

Line 6561: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);

6557: fetch c_get_invoice_distribution into v_invoice_distribution_id;
6558: close c_get_invoice_distribution;
6559: -- End bug#3332988
6560:
6561: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);
6562:
6563: INSERT INTO ap_invoice_distributions_all
6564: (
6565: accounting_date,

Line 6702: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');

6698: IF NVL(r_tax_lines_rec.inc_tax_flag,'N') = 'Y' AND NVL(lv_modvat_flag,'N') = 'Y' THEN
6699: ln_inv_line_num := ln_inv_line_num + 1;
6700: END IF;
6701: --Added by Qinglei on 10-Feb-2012 for bug#13589613 end
6702: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
6703: INSERT INTO JAI_AP_MATCH_INV_TAXES
6704: (
6705: tax_distribution_id,
6706: --shipment_line_id,

Line 6840: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_CMN_FA_INV_DIST_ALL ');

6836: ------------------------------------------------------------------
6837: --Modified by Eric for bug 8345512 on 13-Jul-2009,end
6838:
6839: /* Obsoleted as part of R12 , Bug# 4445989
6840: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_CMN_FA_INV_DIST_ALL ');
6841: INSERT INTO JAI_CMN_FA_INV_DIST_ALL
6842: (
6843: invoice_id,
6844: invoice_distribution_id,

Line 6888: fnd_file.put_line(fnd_file.log ,'separate accounting for inclusive taxes option is '||lv_inclu_tax_flag );

6884: --start additions by vkaranam for bug 11936596
6885: OPEN inclu_flag_cur(v_org_id);
6886: FETCH inclu_flag_cur INTO lv_inclu_tax_flag;
6887: CLOSE inclu_flag_cur;
6888: fnd_file.put_line(fnd_file.log ,'separate accounting for inclusive taxes option is '||lv_inclu_tax_flag );
6889: If nvl(lv_accrue_on_receipt_flag ,'N')='Y'
6890: --and nvl(lv_inclu_tax_flag,'N')='Y'
6891: then
6892: fnd_file.put_line(fnd_file.log ,'Start the Insertion of Inclusive Service tax lines for POT recoverable service amount is '||ln_inclurec_tax_amt);

Line 6892: fnd_file.put_line(fnd_file.log ,'Start the Insertion of Inclusive Service tax lines for POT recoverable service amount is '||ln_inclurec_tax_amt);

6888: fnd_file.put_line(fnd_file.log ,'separate accounting for inclusive taxes option is '||lv_inclu_tax_flag );
6889: If nvl(lv_accrue_on_receipt_flag ,'N')='Y'
6890: --and nvl(lv_inclu_tax_flag,'N')='Y'
6891: then
6892: fnd_file.put_line(fnd_file.log ,'Start the Insertion of Inclusive Service tax lines for POT recoverable service amount is '||ln_inclurec_tax_amt);
6893: lv_tax_line_amount := null;
6894: lv_ap_line_to_inst_flag := null;
6895: ln_inclu_serv_amt := null;
6896: v_dist_code_combination_id := null;

Line 6912: fnd_file.put_line(fnd_file.log ,'Inclusive Service tax lines for **** tax type '||c_tax_rec.tax_type ||' v_org_id '||v_org_id ||' ln_po_dist_id '||ln_po_dist_id||' r_jai_regimes.regime_id '||r_jai_regimes.regime_id );

6908: then
6909:
6910: lv_tax_line_amount:= ln_inclu_serv_amt ;
6911: lv_ap_line_to_inst_flag := 'Y';
6912: fnd_file.put_line(fnd_file.log ,'Inclusive Service tax lines for **** tax type '||c_tax_rec.tax_type ||' v_org_id '||v_org_id ||' ln_po_dist_id '||ln_po_dist_id||' r_jai_regimes.regime_id '||r_jai_regimes.regime_id );
6913: fnd_file.put_line(fnd_file.log ,'c_tax_rec.tax_type '||c_tax_rec.tax_type||' po_dist_id '||po_dist_id);
6914: v_dist_code_combination_id := check_service_interim_account
6915: (
6916: lv_accrue_on_receipt_flag,

Line 6913: fnd_file.put_line(fnd_file.log ,'c_tax_rec.tax_type '||c_tax_rec.tax_type||' po_dist_id '||po_dist_id);

6909:
6910: lv_tax_line_amount:= ln_inclu_serv_amt ;
6911: lv_ap_line_to_inst_flag := 'Y';
6912: fnd_file.put_line(fnd_file.log ,'Inclusive Service tax lines for **** tax type '||c_tax_rec.tax_type ||' v_org_id '||v_org_id ||' ln_po_dist_id '||ln_po_dist_id||' r_jai_regimes.regime_id '||r_jai_regimes.regime_id );
6913: fnd_file.put_line(fnd_file.log ,'c_tax_rec.tax_type '||c_tax_rec.tax_type||' po_dist_id '||po_dist_id);
6914: v_dist_code_combination_id := check_service_interim_account
6915: (
6916: lv_accrue_on_receipt_flag,
6917: lv_accounting_method_option,

Line 6925: fnd_file.put_line(fnd_file.log ,'Inclusive Service tax lines for positve recovery line POT interim recovery account is '||v_dist_code_combination_id);

6921: 'INCLUSIVE',--12813762
6922: c_tax_rec.tax_type,
6923: Nvl(po_dist_id,ln_po_dist_id)
6924: );
6925: fnd_file.put_line(fnd_file.log ,'Inclusive Service tax lines for positve recovery line POT interim recovery account is '||v_dist_code_combination_id);
6926:
6927: elsif inclu_Serv_line =2
6928: then
6929: lv_tax_line_amount:= ln_inclu_serv_amt *-1 ;

Line 6932: fnd_file.put_line(fnd_file.log ,'Inclusive Service tax POT lines for negative recovery line ap accrual account is '||v_dist_code_combination_id);

6928: then
6929: lv_tax_line_amount:= ln_inclu_serv_amt *-1 ;
6930: lv_ap_line_to_inst_flag := 'Y';
6931: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
6932: fnd_file.put_line(fnd_file.log ,'Inclusive Service tax POT lines for negative recovery line ap accrual account is '||v_dist_code_combination_id);
6933: end if;
6934: end if;-- pot ln_inclu_serv_amt <>0
6935: IF ( NVL(lv_ap_line_to_inst_flag,'N')='Y')
6936: THEN

Line 6942: Fnd_File.put_line(Fnd_File.LOG,'Before inserting Inclusive Service tax lines for POT into ap_invoice_lines_all for line no :'|| ln_inv_line_num ||' tax amount = '||lv_tax_line_amount);

6938: IF inclu_Serv_line =2 THEN
6939: ln_inv_line_num := ln_inv_line_num + 1;
6940: END IF;
6941: --Modified by Qinglei on 10-Feb-2012 for bug#13589613 end
6942: Fnd_File.put_line(Fnd_File.LOG,'Before inserting Inclusive Service tax lines for POT into ap_invoice_lines_all for line no :'|| ln_inv_line_num ||' tax amount = '||lv_tax_line_amount);
6943:
6944: INSERT INTO ap_invoice_lines_all
6945: (
6946: INVOICE_ID

Line 7008: Fnd_File.put_line(Fnd_File.LOG,

7004: ,po_dist_id
7005: );
7006:
7007:
7008: Fnd_File.put_line(Fnd_File.LOG,
7009: 'Before inserting Inclusive Service tax lines for POT into ap_invoice_distributions_all for distribution line no :' || v_distribution_no);
7010:
7011:
7012: open c_get_invoice_distribution;

Line 7017: fnd_file.put_line(FND_FILE.LOG, 'Inclusive Service tax lines for POT Invoice distribution id '|| v_invoice_distribution_id);

7013: fetch c_get_invoice_distribution into v_invoice_distribution_id;
7014: close c_get_invoice_distribution;
7015:
7016:
7017: fnd_file.put_line(FND_FILE.LOG, 'Inclusive Service tax lines for POT Invoice distribution id '|| v_invoice_distribution_id);
7018:
7019: INSERT INTO ap_invoice_distributions_all
7020: (
7021: accounting_date,

Line 7187: Fnd_File.put_line(Fnd_File.LOG, 'SUCCESSFUL END PROCEDURE - jai_ap_match_tax_pkg.process_online');

7183: ----------------------------------------------------------------------
7184: -- Added by Qiong for reverse charge bug#16001407, End
7185:
7186: <>
7187: Fnd_File.put_line(Fnd_File.LOG, 'SUCCESSFUL END PROCEDURE - jai_ap_match_tax_pkg.process_online');
7188: EXCEPTION
7189: WHEN OTHERS THEN
7190: ERRBUF := SQLERRM;
7191: RETCODE := 2;

Line 7192: Fnd_File.put_line(Fnd_File.LOG, 'EXCEPTION END PROCEDURE - jai_ap_match_tax_pkg.process_online');

7188: EXCEPTION
7189: WHEN OTHERS THEN
7190: ERRBUF := SQLERRM;
7191: RETCODE := 2;
7192: Fnd_File.put_line(Fnd_File.LOG, 'EXCEPTION END PROCEDURE - jai_ap_match_tax_pkg.process_online');
7193: Fnd_File.put_line(Fnd_File.LOG, 'Error : ' || ERRBUF);
7194: END process_online;
7195:
7196: PROCEDURE process_batch_record (

Line 7193: Fnd_File.put_line(Fnd_File.LOG, 'Error : ' || ERRBUF);

7189: WHEN OTHERS THEN
7190: ERRBUF := SQLERRM;
7191: RETCODE := 2;
7192: Fnd_File.put_line(Fnd_File.LOG, 'EXCEPTION END PROCEDURE - jai_ap_match_tax_pkg.process_online');
7193: Fnd_File.put_line(Fnd_File.LOG, 'Error : ' || ERRBUF);
7194: END process_online;
7195:
7196: PROCEDURE process_batch_record (
7197: err_mesg OUT NOCOPY VARCHAR2,

Line 7653: Fnd_File.put_line(Fnd_File.LOG, 'Start of function update_payment_schedule');

7649: where invoice_id = inv_id;
7650:
7651: begin
7652:
7653: Fnd_File.put_line(Fnd_File.LOG, 'Start of function update_payment_schedule');
7654:
7655: open c_total_payment_amt;
7656: fetch c_total_payment_amt into v_total_payment_amt;
7657: close c_total_payment_amt;

Line 7660: Fnd_File.put_line(Fnd_File.LOG, 'Cannot update payment schedule, total payment amount :'

7656: fetch c_total_payment_amt into v_total_payment_amt;
7657: close c_total_payment_amt;
7658:
7659: If nvl(v_total_payment_amt, -1) = -1 then --Added by nprashar for bug # 13854408
7660: Fnd_File.put_line(Fnd_File.LOG, 'Cannot update payment schedule, total payment amount :'
7661: || to_char(v_total_payment_amt));
7662: return false;
7663: Elsif v_total_payment_amt = 0 Then
7664: v_total_payment_amt := 1;

Line 7720: Fnd_File.put_line(Fnd_File.LOG, 'exception from function update_payment_schedule');

7716: return true;
7717:
7718: exception
7719: when others then
7720: Fnd_File.put_line(Fnd_File.LOG, 'exception from function update_payment_schedule');
7721: Fnd_File.put_line(Fnd_File.LOG, sqlerrm);
7722: return false;
7723:
7724: end update_payment_schedule; -- bug # 3218978

Line 7721: Fnd_File.put_line(Fnd_File.LOG, sqlerrm);

7717:
7718: exception
7719: when others then
7720: Fnd_File.put_line(Fnd_File.LOG, 'exception from function update_payment_schedule');
7721: Fnd_File.put_line(Fnd_File.LOG, sqlerrm);
7722: return false;
7723:
7724: end update_payment_schedule; -- bug # 3218978
7725:

Line 7750: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(insert)');

7746: when others then
7747: IF SQLCODE = -6550 THEN
7748: -- object referred in EXECUTE IMMEDIATE is not available in the database
7749: null;
7750: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(insert)');
7751: ELSE
7752: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(insert)->'||SQLERRM);
7753: RAISE;
7754: END IF;

Line 7752: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(insert)->'||SQLERRM);

7748: -- object referred in EXECUTE IMMEDIATE is not available in the database
7749: null;
7750: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(insert)');
7751: ELSE
7752: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(insert)->'||SQLERRM);
7753: RAISE;
7754: END IF;
7755: end;
7756:

Line 7781: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(update)');

7777: when others then
7778: IF SQLCODE = -6550 THEN
7779: -- object referred in EXECUTE IMMEDIATE is not available in the database
7780: null;
7781: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(update)');
7782: ELSE
7783: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(update)->'||SQLERRM);
7784: RAISE;
7785: END IF;

Line 7783: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(update)->'||SQLERRM);

7779: -- object referred in EXECUTE IMMEDIATE is not available in the database
7780: null;
7781: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(update)');
7782: ELSE
7783: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(update)->'||SQLERRM);
7784: RAISE;
7785: END IF;
7786: end;
7787:

Line 8181: Fnd_File.put_line(Fnd_File.LOG, 'Base invoice has been cancelled, no need to process tax');

8177:
8178: -- start added by bug#3206083
8179: if get_ven_info_rec.cancelled_date is not null then
8180: -- base invoice has been cancelled, no need to process tax.
8181: Fnd_File.put_line(Fnd_File.LOG, 'Base invoice has been cancelled, no need to process tax');
8182: return;
8183: end if;
8184: -- end added by bug#3206083
8185:

Line 8373: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id||',lv_excise_costing_flag='||lv_excise_costing_flag);

8369: ,cp_txn_type => 'DELIVER' --Added by Bgowrava for Bug#7503308
8370: ,cp_attribute1 => 'CENVAT_COSTED_FLAG'); --Added by Bgowrava for Bug#7503308
8371: fetch c_get_excise_costing_flag into lv_excise_costing_flag;
8372: close c_get_excise_costing_flag ;
8373: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id||',lv_excise_costing_flag='||lv_excise_costing_flag);
8374: /* End 5763527 */
8375:
8376:
8377: IF p_receipt_code = 'RECEIPT' THEN

Line 8455: fnd_file.put_line(FND_FILE.LOG,

8451: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
8452: fetch c_regime_tax_type into r_service_regime_tax_type;
8453: close c_regime_tax_type;
8454:
8455: fnd_file.put_line(FND_FILE.LOG,
8456: ' Service regime: '||r_service_regime_tax_type.tax_type);
8457:
8458: /* Bug 5358788. Added by Lakshmi Gopalsami
8459: * Fetched the details of VAT regime

Line 8466: fnd_file.put_line(FND_FILE.LOG,

8462: OPEN c_regime_tax_type(r_vat_regimes.regime_id, c_tax_rec.tax_type);
8463: FETCH c_regime_tax_type into r_vat_regime_tax_type;
8464: CLOSE c_regime_tax_type;
8465:
8466: fnd_file.put_line(FND_FILE.LOG,
8467: ' VAT regime: '||r_vat_regime_tax_type.tax_type);
8468:
8469: if r_service_regime_tax_type.tax_type is not null then
8470: /* Service type of tax */

Line 8482: fnd_file.put_line(FND_FILE.LOG,

8478: p_rematch,
8479: c_tax_rec.tax_type,
8480: po_dist_id --Added by JMEENA for bug#6833506
8481: );
8482: fnd_file.put_line(FND_FILE.LOG,
8483: ' Regime type , CCID '
8484: || r_service_regime_tax_type.tax_type
8485: ||', ' || v_dist_code_combination_id);
8486: /* Bug 5358788. Added by Lakshmi Gopalsami

Line 8495: fnd_file.put_line(FND_FILE.LOG,

8491: ELSIF r_vat_regime_tax_type.tax_type IS NOT NULL THEN
8492: -- p_rematch = 'PO_MATCHING' then
8493:
8494: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
8495: fnd_file.put_line(FND_FILE.LOG,
8496: ' Regime type , CCID '
8497: || r_vat_regime_tax_type.tax_type
8498: ||', ' || v_dist_code_combination_id);
8499:

Line 8524: Fnd_File.put_line(Fnd_File.LOG, 'c_tax_rec.tax_type='||c_tax_rec.tax_type ||',lv_excise_costing_flag='||lv_excise_costing_flag);

8520: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
8521: end if;
8522:
8523: /* Bug#5763527 */
8524: Fnd_File.put_line(Fnd_File.LOG, 'c_tax_rec.tax_type='||c_tax_rec.tax_type ||',lv_excise_costing_flag='||lv_excise_costing_flag);
8525: if upper(c_tax_rec.tax_type) like '%EXCISE%' then
8526:
8527: if lv_excise_costing_flag = 'Y' then
8528: IF nvl(lv_accrue_on_receipt_flag , '#') <> 'Y' -- Bug 6338371

Line 8584: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.modvat_flag ='||tax_lines1_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);

8580: END IF;--( NVL(tax_lines1_rec.inc_tax_flag,'N') = 'N' OR )
8581: -------------------------------------------------------------------------------------
8582: --added by Eric for inclusive tax on 20-dec-2007,end
8583:
8584: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.modvat_flag ='||tax_lines1_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
8585:
8586: if tax_lines1_rec.modvat_flag = jai_constants.YES
8587: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
8588: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100

Line 8602: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||

8598: /* Added Tax rounding based on tax rounding factor for bug 6761425 by vumaasha */
8599: lv_tax_type := 'PR'; --changed by eric for inclusive tax on Jan 4,2008
8600:
8601: end if;
8602: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
8603: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
8604: ',ln_nrec_tax_amt='||ln_nrec_tax_amt
8605: );
8606:

Line 8797: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');

8793: END IF;
8794: -- ELSIF ( lv_tax_type <> 'PR' AND p_project_id IS NULL )
8795: -- THEN
8796: ELSE -- eric removed the above criteria for bug 6888665 and 6888209
8797: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');
8798: --The case process the inclusive NR tax and inclusive RE tax not for project
8799:
8800: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
8801: lv_modvat_flag := tax_lines1_rec.modvat_flag ;

Line 8900: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);

8896: open c_get_invoice_distribution;
8897: fetch c_get_invoice_distribution into v_invoice_distribution_id;
8898: close c_get_invoice_distribution;
8899: -- End bug#3332988
8900: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);
8901:
8902: INSERT INTO ap_invoice_distributions_all
8903: (
8904: accounting_date,

Line 9301: fnd_file.put_line(FND_FILE.LOG,

9297: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
9298: fetch c_regime_tax_type into r_service_regime_tax_type;
9299: close c_regime_tax_type;
9300:
9301: fnd_file.put_line(FND_FILE.LOG,
9302: ' Service regime: '||r_service_regime_tax_type.tax_type);
9303:
9304: /* Bug 5358788. Added by Lakshmi Gopalsami
9305: * Fetched the details of VAT regime

Line 9312: fnd_file.put_line(FND_FILE.LOG,

9308: OPEN c_regime_tax_type(r_vat_regimes.regime_id, c_tax_rec.tax_type);
9309: FETCH c_regime_tax_type INTO r_vat_regime_tax_type;
9310: CLOSE c_regime_tax_type;
9311:
9312: fnd_file.put_line(FND_FILE.LOG,
9313: ' VAT regime: '||r_vat_regime_tax_type.tax_type);
9314:
9315: if r_service_regime_tax_type.tax_type is not null then
9316: /* Service type of tax */

Line 9328: fnd_file.put_line(FND_FILE.LOG,

9324: p_rematch,
9325: c_tax_rec.tax_type,
9326: po_dist_id --Added by JMEENA for bug#6833506
9327: );
9328: fnd_file.put_line(FND_FILE.LOG,
9329: ' Regime type , CCID '
9330: || r_service_regime_tax_type.tax_type
9331: ||', ' || v_dist_code_combination_id);
9332:

Line 9342: fnd_file.put_line(FND_FILE.LOG,

9338: ELSIF r_vat_regime_tax_type.tax_type IS NOT NULL THEN
9339: --p_rematch = 'PO_MATCHING' then
9340:
9341: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
9342: fnd_file.put_line(FND_FILE.LOG,
9343: ' Regime type , CCID '
9344: || r_vat_regime_tax_type.tax_type
9345: ||', ' || v_dist_code_combination_id);
9346:

Line 9372: Fnd_File.put_line(Fnd_File.LOG, 'c_tax_rec.tax_type='||c_tax_rec.tax_type ||',lv_excise_costing_flag='||lv_excise_costing_flag);

9368: end if;
9369:
9370:
9371: /* Bug#5763527 */
9372: Fnd_File.put_line(Fnd_File.LOG, 'c_tax_rec.tax_type='||c_tax_rec.tax_type ||',lv_excise_costing_flag='||lv_excise_costing_flag);
9373: if upper(c_tax_rec.tax_type) like '%EXCISE%' then
9374:
9375: if lv_excise_costing_flag = 'Y' THEN
9376: IF nvl(lv_accrue_on_receipt_flag , '#') <> 'Y' THEN -- Bug 6338371

Line 9433: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.modvat_flag ='||tax_lines1_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);

9429: --added by Eric for inclusive tax on 20-dec-2007,end
9430:
9431:
9432:
9433: Fnd_File.put_line(Fnd_File.LOG, 'tax_lines1_rec.modvat_flag ='||tax_lines1_rec.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
9434:
9435: if tax_lines1_rec.modvat_flag = jai_constants.YES
9436: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
9437: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0

Line 9451: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||

9447: /* Added Tax rounding based on tax rounding factor for bug 6761425 by vumaasha */
9448:
9449: lv_tax_type := 'PR'; --changed by eric for inclusive tax on Jan 4,2008
9450: end if;
9451: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
9452: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
9453: ',ln_nrec_tax_amt='||ln_nrec_tax_amt
9454: );
9455:

Line 9651: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');

9647: END IF;
9648: --ELSIF ( lv_tax_type <> 'PR' AND p_project_id IS NULL )
9649: --THEN
9650: ELSE -- eric removed the above criteria for bug 6888665 and 6888209
9651: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');
9652: --The case process the inclusive NR tax and inclusive RE tax not for project
9653:
9654: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
9655: lv_modvat_flag := tax_lines1_rec.modvat_flag ;

Line 9668: fnd_file.put_line(fnd_file.log, 'line='||line||', v_tax_amount='|| v_tax_amount

9664:
9665:
9666:
9667:
9668: fnd_file.put_line(fnd_file.log, 'line='||line||', v_tax_amount='|| v_tax_amount
9669: ||'lv_modvat_flag='||lv_modvat_flag
9670: ||'v_assets_tracking_flag='||v_assets_tracking_flag
9671: );
9672:

Line 9765: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);

9761: open c_get_invoice_distribution;
9762: fetch c_get_invoice_distribution into v_invoice_distribution_id;
9763: close c_get_invoice_distribution;
9764: -- End bug#3332988
9765: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);
9766:
9767: INSERT INTO ap_invoice_distributions_all
9768: (
9769: accounting_date,

Line 10097: Fnd_File.put_line(Fnd_File.LOG, 'Fired when rcv_tran_id IS NULL, match_option is P');

10093:
10094: --IF rcv_tran_id IS NOT NULL THEN
10095: -- to be fired when po_line_locations_all.match_option = 'P'
10096:
10097: Fnd_File.put_line(Fnd_File.LOG, 'Fired when rcv_tran_id IS NULL, match_option is P');
10098:
10099: -- fetch shipment_num from rcv_headers_interface based on invoice_num
10100: -- pramasub start for isupplier IL FP
10101: -- local cursor to fetch shipment number

Line 10194: fnd_file.put_line(FND_FILE.LOG,

10190: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
10191: fetch c_regime_tax_type into r_service_regime_tax_type;
10192: close c_regime_tax_type;
10193:
10194: fnd_file.put_line(FND_FILE.LOG,
10195: ' Service regime: '||r_service_regime_tax_type.tax_type);
10196:
10197: /* Bug 5358788. Added by Lakshmi Gopalsami
10198: * Fetched the details of VAT regime

Line 10205: fnd_file.put_line(FND_FILE.LOG,

10201: OPEN c_regime_tax_type(r_vat_regimes.regime_id, c_tax_rec.tax_type);
10202: FETCH c_regime_tax_type INTO r_vat_regime_tax_type;
10203: CLOSE c_regime_tax_type;
10204:
10205: fnd_file.put_line(FND_FILE.LOG,
10206: ' VAT regime: '||r_vat_regime_tax_type.tax_type);
10207:
10208: if r_service_regime_tax_type.tax_type is not null then
10209: /* Service type of tax */

Line 10221: fnd_file.put_line(FND_FILE.LOG,

10217: p_rematch,
10218: c_tax_rec.tax_type,
10219: po_dist_id --Added by JMEENA for bug#6833506
10220: );
10221: fnd_file.put_line(FND_FILE.LOG,
10222: ' Regime type , CCID '
10223: || r_service_regime_tax_type.tax_type
10224: ||', ' || v_dist_code_combination_id);
10225:

Line 10235: fnd_file.put_line(FND_FILE.LOG,

10231: ELSIF r_vat_regime_tax_type.tax_type IS NOT NULL THEN
10232: --p_rematch = 'PO_MATCHING' then
10233:
10234: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
10235: fnd_file.put_line(FND_FILE.LOG,
10236: ' Regime type , CCID '
10237: || r_vat_regime_tax_type.tax_type
10238: ||', ' || v_dist_code_combination_id);
10239:

Line 10294: Fnd_File.put_line(Fnd_File.LOG, 'i.modvat_flag ='||i.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);

10290: END IF;--( NVL(i.inc_tax_flag,'N') = 'N' OR ( NVL(i.inc_tax_flag,'N'))
10291: -------------------------------------------------------------------------------------
10292: --added by Eric for inclusive tax on 20-dec-2007,end
10293:
10294: Fnd_File.put_line(Fnd_File.LOG, 'i.modvat_flag ='||i.modvat_flag ||',c_tax_rec.mod_cr_percentage='||c_tax_rec.mod_cr_percentage);
10295:
10296: if i.modvat_flag = jai_constants.YES
10297: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
10298: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100

Line 10314: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||

10310:
10311: lv_tax_type := 'PR'; --changed by eric for inclusive tax on Jan 4,2008
10312: end if;
10313:
10314: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
10315: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
10316: ',ln_nrec_tax_amt='||ln_nrec_tax_amt
10317: );
10318:

Line 10515: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');

10511: END IF;
10512: --ELSIF ( lv_tax_type <> 'PR' AND p_project_id IS NULL )
10513: --THEN
10514: ELSE -- eric removed the above criteria for bug 6888665 and 6888209
10515: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');
10516: --The case process the inclusive NR tax and inclusive RE tax not for project
10517:
10518: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
10519: lv_modvat_flag := i.modvat_flag ;

Line 10529: Fnd_File.put_line(Fnd_File.LOG,

10525: -------------------------------------------------------------------------------------------
10526: --added by Eric for inclusive tax on 20-dec-2007,end
10527:
10528:
10529: Fnd_File.put_line(Fnd_File.LOG,
10530: 'Before inserting into ap_invoice_lines_all for line no :' || ln_inv_line_num );
10531:
10532: --insert exclusive tax to the ap tables
10533: --or insert recoverable inclusive tax with project information the ap tables

Line 10618: Fnd_File.put_line(Fnd_File.LOG,

10614: /* End 5763527 */
10615: ,po_dist_id --Added for bug#6780154
10616: );
10617:
10618: Fnd_File.put_line(Fnd_File.LOG,
10619: 'Before inserting into ap_invoice_distributions_all for distribution line no :'
10620: || v_distribution_no);
10621:
10622: -- Start bug#3332988

Line 10627: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);

10623: open c_get_invoice_distribution;
10624: fetch c_get_invoice_distribution into v_invoice_distribution_id;
10625: close c_get_invoice_distribution;
10626: -- End bug#3332988
10627: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);
10628:
10629: INSERT INTO ap_invoice_distributions_all
10630: (
10631: accounting_date,

Line 10748: Fnd_File.put_line(Fnd_File.LOG,

10744: -----------------------------------------------------------------
10745: --added by Eric for inclusive tax on 20-dec-2007,end
10746:
10747:
10748: Fnd_File.put_line(Fnd_File.LOG,
10749: 'Before inserting into JAI_AP_MATCH_INV_TAXES tax id ' || i.tax_id );
10750: --added by Eric for inclusive tax on 20-dec-2007,begin
10751: -----------------------------------------------------------------
10752: IF (NVL(lv_tax_line_to_inst_flag,'N') = 'Y')

Line 10879: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_CMN_FA_INV_DIST_ALL');

10875:
10876: v_statement_no := '50';
10877:
10878: /* Obsoleted as part of R12 , Bug# 4445989
10879: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_CMN_FA_INV_DIST_ALL');
10880: INSERT INTO JAI_CMN_FA_INV_DIST_ALL
10881: (
10882: invoice_id,
10883: invoice_distribution_id,

Line 10975: Fnd_File.put_line(Fnd_File.LOG, 'SQLERRM -> '|| SQLERRM ||', SQLCODE -> '||SQLCODE);

10971:
10972: EXCEPTION
10973: WHEN OTHERS THEN
10974: err_mesg := SQLERRM;
10975: Fnd_File.put_line(Fnd_File.LOG, 'SQLERRM -> '|| SQLERRM ||', SQLCODE -> '||SQLCODE);
10976: Fnd_File.put_line(Fnd_File.LOG, 'Statement -> '|| v_statement_no);
10977: RETURN;
10978: END process_batch_record;
10979:

Line 10976: Fnd_File.put_line(Fnd_File.LOG, 'Statement -> '|| v_statement_no);

10972: EXCEPTION
10973: WHEN OTHERS THEN
10974: err_mesg := SQLERRM;
10975: Fnd_File.put_line(Fnd_File.LOG, 'SQLERRM -> '|| SQLERRM ||', SQLCODE -> '||SQLCODE);
10976: Fnd_File.put_line(Fnd_File.LOG, 'Statement -> '|| v_statement_no);
10977: RETURN;
10978: END process_batch_record;
10979:
10980: END;