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 212: Fnd_File.put_line(Fnd_File.LOG, 'Start procedure - jai_ap_match_tax_pkg.process_batch');

208: ------------------------------------------------------------------------------------------------------------------------ */
209: BEGIN
210:
211:
212: Fnd_File.put_line(Fnd_File.LOG, 'Start procedure - jai_ap_match_tax_pkg.process_batch');
213:
214: -- this cursor picks up the invoice lines from the temporary table but does not pick up such invoices which have
215: -- error_flag set to 'Y' for any of it's distribution lines.
216:

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

318: INTO v_invoice_number
319: FROM ap_invoices_all
320: WHERE invoice_id = v_prev_invoice_id;
321:
322: Fnd_File.put_line(Fnd_File.LOG, ' Processed invoice number(id) : ' || v_invoice_number || '(' || v_prev_invoice_id || ')' );
323:
324: END IF;
325:
326: -- set the prev to current.

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

400: FROM ap_invoices_all
401: WHERE invoice_id = c_rec.invoice_id;
402:
403:
404: Fnd_File.put_line(Fnd_File.LOG, v_error_mesg || ' FOR invoice number(id)/line id : ' || v_invoice_number
405: || '(' || c_rec.invoice_id || ')/' || c_rec.invoice_line_number );
406: Fnd_File.put_line(Fnd_File.LOG, 'Error message - ' || v_errbuf);
407:
408: v_prev_invoice_id := c_rec.invoice_id;

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

402:
403:
404: Fnd_File.put_line(Fnd_File.LOG, v_error_mesg || ' FOR invoice number(id)/line id : ' || v_invoice_number
405: || '(' || c_rec.invoice_id || ')/' || c_rec.invoice_line_number );
406: Fnd_File.put_line(Fnd_File.LOG, 'Error message - ' || v_errbuf);
407:
408: v_prev_invoice_id := c_rec.invoice_id;
409: v_error_invoice := 'Y';
410:

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

429: INTO v_invoice_number
430: FROM ap_invoices_all
431: WHERE invoice_id = v_prev_invoice_id;
432:
433: Fnd_File.put_line(Fnd_File.LOG, ' Processed invoice number(id) : ' || v_invoice_number || '(' || v_prev_invoice_id || ')' );
434:
435: END IF;
436:
437:

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

434:
435: END IF;
436:
437:
438: Fnd_File.put_line(Fnd_File.LOG, 'SUCCESSFUL END PROCEDURE - jai_ap_match_tax_pkg.process_batch');
439:
440: EXCEPTION
441:
442: WHEN OTHERS THEN

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

455: WHERE ROWID = v_rowid;
456:
457: COMMIT;
458:
459: Fnd_File.put_line(Fnd_File.LOG, 'Error END PROCEDURE - jai_ap_match_tax_pkg.process_batch');
460: Fnd_File.put_line(Fnd_File.LOG, 'Error message - ' || p_errbuf);
461: RETURN;
462:
463: END process_batch;

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

456:
457: COMMIT;
458:
459: Fnd_File.put_line(Fnd_File.LOG, 'Error END PROCEDURE - jai_ap_match_tax_pkg.process_batch');
460: Fnd_File.put_line(Fnd_File.LOG, 'Error message - ' || p_errbuf);
461: RETURN;
462:
463: END process_batch;
464:

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

1090: where invoice_id = inv_id;
1091:
1092: begin
1093:
1094: Fnd_File.put_line(Fnd_File.LOG, 'Start of function update_payment_schedule');
1095:
1096: open c_total_payment_amt;
1097: fetch c_total_payment_amt into v_total_payment_amt;
1098: close c_total_payment_amt;

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

1097: fetch c_total_payment_amt into v_total_payment_amt;
1098: close c_total_payment_amt;
1099:
1100: if nvl(v_total_payment_amt, -1) = -1 then --Modified by kunkumar for 5593895
1101: Fnd_File.put_line(Fnd_File.LOG, 'Cannot update payment schedule, total payment amount :'
1102: || to_char(v_total_payment_amt));
1103: return false;
1104: end if;
1105:

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

1151: return true;
1152:
1153: exception
1154: when others then
1155: Fnd_File.put_line(Fnd_File.LOG, 'exception from function update_payment_schedule');
1156: Fnd_File.put_line(Fnd_File.LOG, sqlerrm);
1157: return false;
1158: end update_payment_schedule; -- bug # 3218978
1159:

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

1152:
1153: exception
1154: when others then
1155: Fnd_File.put_line(Fnd_File.LOG, 'exception from function update_payment_schedule');
1156: Fnd_File.put_line(Fnd_File.LOG, sqlerrm);
1157: return false;
1158: end update_payment_schedule; -- bug # 3218978
1159:
1160: -- Start added for bug#3332988

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

1180: when others then
1181: IF SQLCODE = -6550 THEN
1182: -- object referred in EXECUTE IMMEDIATE is not available in the database
1183: null;
1184: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(insert)');
1185: ELSE
1186: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(insert)->'||SQLERRM);
1187: RAISE;
1188: END IF;

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

1182: -- object referred in EXECUTE IMMEDIATE is not available in the database
1183: null;
1184: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(insert)');
1185: ELSE
1186: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(insert)->'||SQLERRM);
1187: RAISE;
1188: END IF;
1189: end;
1190:

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

1211: when others then
1212: IF SQLCODE = -6551 THEN --Modified by kunkumar for 5593895
1213: -- object referred in EXECUTE IMMEDIATE is not available in the database
1214: null;
1215: FND_FILE.put_line(FND_FILE.log, 'MRC API is not existing(update)');
1216: ELSE
1217: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(update)->'||SQLERRM);
1218: RAISE;
1219: END IF;

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

1213: -- object referred in EXECUTE IMMEDIATE is not available in the database
1214: null;
1215: FND_FILE.put_line(FND_FILE.log, 'MRC API is not existing(update)');
1216: ELSE
1217: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(update)->'||SQLERRM);
1218: RAISE;
1219: END IF;
1220: end;
1221: /* End added for bug#3332988 */

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

1251: cur_quantity_invoiced NUMBER;
1252: v_count NUMBER;
1253: begin
1254:
1255: Fnd_File.put_line(Fnd_File.LOG, 'Start of function apportion_tax_4_price_cor_inv');
1256:
1257: begin
1258: execute immediate 'select /* price_correct_inv_id */, po_distribution_id, amount, quantity_invoiced
1259: from ap_invoice_lines_all

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

1283: fetch c_get_orig_tax_line into c_get_orig_tax_line_rec;
1284: close c_get_orig_tax_line;
1285:
1286: if c_check_orig_item_line_rec.amount = -1 then --Modified by kunkumar for 5593895
1287: Fnd_File.put_line(Fnd_File.LOG, 'Original item line has -1 amount, cannot apportion tax');--Modified by kunkumar for 5593895
1288: return p_tax_amount;
1289: end if;
1290:
1291: v_amount := ( c_get_orig_tax_line_rec.tax_amount / c_check_orig_item_line_rec.amount)

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

1290:
1291: v_amount := ( c_get_orig_tax_line_rec.tax_amount / c_check_orig_item_line_rec.amount)
1292: * cur_amount;
1293:
1294: Fnd_File.put_line(Fnd_File.LOG, ' original amount / tax :' || c_check_orig_item_line_rec.amount
1295: || '/' || c_get_orig_tax_line_rec.tax_amount);
1296:
1297: return round(v_amount, 2);
1298:

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

1298:
1299:
1300: exception
1301: when others then
1302: Fnd_File.put_line(Fnd_File.LOG, 'Exception function apportion_tax_4_price_cor_inv :' || sqlerrm);
1303: return p_tax_amount;
1304: end apportion_tax_4_price_cor_inv;
1305:
1306:

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

1344: Corrected it by using quantity_shipped in the r_for_shipment_line
1345: cursor instead of quantity_received.
1346: Quantity_shipped gives the original quantity of the receipt.
1347:
1348: Added the Fnd_File.put_line(Fnd_File.LOG,'') statements to
1349: generate the log also.
1350:
1351: 9. 09/10/2002 Aparajita for bug # 2483164 Version#615.1
1352: Populate the po distribution id and rcv_transactions id for the tax

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

1766:
1767: ------------------------------------------------------------------------------------------------------- */
1768:
1769:
1770: Fnd_File.put_line(Fnd_File.LOG, 'Start procedure - jai_ap_match_tax_pkg.process_online ');
1771:
1772: OPEN get_ven_info(inv_id);
1773: FETCH get_ven_info INTO get_ven_info_rec;
1774: CLOSE get_ven_info;

Line 1776: Fnd_File.put_line(Fnd_File.LOG,

1772: OPEN get_ven_info(inv_id);
1773: FETCH get_ven_info INTO get_ven_info_rec;
1774: CLOSE get_ven_info;
1775: -- Using pn_invoice_line_number instead of dist_line_no for Bug#4445989
1776: Fnd_File.put_line(Fnd_File.LOG,
1777: 'Input parameters - invoice number(id)/ invoice line no/Matching option :'
1778: || get_ven_info_rec.invoice_num || '(' || inv_id || ')/' || pn_invoice_line_number || '/' || p_rematch);
1779:
1780:

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

1780:
1781: -- start added by bug#3206083
1782: if get_ven_info_rec.cancelled_date is not null then
1783: -- base invoice has been cancelled, no need to process tax.
1784: Fnd_File.put_line(Fnd_File.LOG, 'Base invoice has been cancelled, no need to process tax');
1785: return;
1786: end if;
1787: -- end added by bug#3206083
1788:

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

1953: (
1954: p_po_distribution_id => po_dist_id
1955: );
1956:
1957: Fnd_File.put_line(Fnd_File.LOG, 'lv_accrue_on_receipt_flag='||lv_accrue_on_receipt_flag);
1958:
1959: open c_jai_regimes(jai_constants.service_regime);
1960: fetch c_jai_regimes into r_jai_regimes;
1961: close c_jai_regimes;

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

1978: (for_dist_insertion_rec.dist_code_combination_id);
1979:
1980: IF p_rematch = 'PO_MATCHING' THEN
1981:
1982: Fnd_File.put_line(Fnd_File.LOG, 'inside p_rematch = PO_MATCHING ');
1983: ---commented as receipt not required for pure po match
1984: /*following fetch commented out for bug 6595773*/
1985: /*OPEN from_po_distributions(po_dist_id);
1986: FETCH from_po_distributions INTO from_po_distributions_rec;

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

2043: if i.currency <> for_org_id_rec.invoice_currency_code then
2044: v_tax_amount := v_tax_amount / for_org_id_rec.exchange_rate;
2045: end if;
2046:
2047: fnd_file.put_line(FND_FILE.LOG, ' Value of tax amount -> '|| v_tax_amount);
2048:
2049: if nvl(for_dist_insertion_rec.invoice_price_variance, -1) <>-1 --Modified by kunkumar for bug 5593895
2050: and
2051: nvl(for_dist_insertion_rec.amount, -1) <> -1 then --Modified by kunkumar for bug 5593895

Line 2092: fnd_file.put_line(FND_FILE.LOG,

2088: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
2089: fetch c_regime_tax_type into r_service_regime_tax_type;
2090: close c_regime_tax_type;
2091:
2092: fnd_file.put_line(FND_FILE.LOG,
2093: ' Service regime: '||r_service_regime_tax_type.tax_type);
2094:
2095: /* Bug 5358788. Added by Lakshmi Gopalsami
2096: * Fetched the details of VAT regime

Line 2103: fnd_file.put_line(FND_FILE.LOG,

2099: open c_regime_tax_type(r_vat_regimes.regime_id, c_tax_rec.tax_type);
2100: fetch c_regime_tax_type into r_vat_regime_tax_type;
2101: close c_regime_tax_type;
2102:
2103: fnd_file.put_line(FND_FILE.LOG,
2104: ' VAT regime: '||r_vat_regime_tax_type.tax_type);
2105:
2106: /*following code added for bug 6595773*/
2107: /*6595773 start*/

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

2113: ,ln_ship_to_location_id;
2114: close c_get_ship_to_org_loc;
2115:
2116:
2117: Fnd_File.put_line(Fnd_File.LOG, 'ln_ship_to_organization_id='||ln_ship_to_organization_id
2118: ||', r_po_lines_all.item_id='||r_po_lines_all.item_id
2119: );
2120: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
2121: (

Line 2139: fnd_file.put_line(FND_FILE.LOG,

2135: p_rematch,
2136: c_tax_rec.tax_type,
2137: po_dist_id --Added by JMEENA for bug#6833506
2138: );
2139: fnd_file.put_line(FND_FILE.LOG,
2140: ' Regime type , CCID '
2141: || r_service_regime_tax_type.tax_type
2142: ||', ' || v_dist_code_combination_id);
2143: /* Bug 5358788. Added by Lakshmi Gopalsami

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

2146: */
2147: /*following elsif and else modified / added for bug 6595773*/
2148: ELSIF r_vat_regime_tax_type.tax_type IS NOT NULL THEN
2149: -- p_rematch = 'PO_MATCHING' then
2150: Fnd_File.put_line(Fnd_File.LOG, 'lv_is_item_an_expense='||lv_is_item_an_expense);
2151: v_dist_code_combination_id := jai_cmn_rgm_recording_pkg.get_account
2152: (
2153: p_regime_id => ln_vat_regime_id,
2154: p_organization_type => jai_constants.orgn_type_io,

Line 2162: fnd_file.put_line(FND_FILE.LOG,

2158: p_account_name => jai_constants.recovery /*RECOVERY*/
2159: );
2160: ELSE
2161: v_dist_code_combination_id := c_tax_rec.tax_account_id;
2162: fnd_file.put_line(FND_FILE.LOG,
2163: ' Regime type , CCID '
2164: || r_vat_regime_tax_type.tax_type
2165: ||', ' || v_dist_code_combination_id);
2166:

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

2193: END IF;
2194: v_tax_amount := nvl(v_tax_amount,-1); --Modified by kunkumar for bug 5593895
2195: -- End bug#4103473
2196:
2197: fnd_file.put_line(FND_FILE.LOG, ' Value of tax amount after apportion -> '|| v_tax_amount);
2198:
2199: --
2200: -- Begin 5763527
2201: --

Line 2262: 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);

2258: END IF;--( NVL(i.inc_tax_flag,'N') = 'N' OR ( NVL(i.inc_tax_flag,'N'))
2259: -------------------------------------------------------------------------------------
2260: --added by Eric for inclusive tax on 20-dec-2007,end
2261:
2262: 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);
2263:
2264: if i.modvat_flag = jai_constants.YES
2265: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
2266: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100

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

2276:
2277: lv_tax_type := 'PR'; --changed by eric for inclusive tax on Jan 4,2008
2278:
2279: end if;
2280: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
2281: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
2282: ',ln_nrec_tax_amt='||ln_nrec_tax_amt
2283: );
2284:

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

2564: END IF;
2565: -- ELSIF ( lv_tax_type <> 'PR' AND p_project_id IS NULL )
2566: -- THEN
2567: ELSE -- eric removed the above criteria for bug 6888665 and 6888209
2568: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');
2569: --The case process the inclusive NR tax and inclusive RE tax not for project
2570:
2571: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
2572: lv_modvat_flag := i.modvat_flag ;

Line 2590: Fnd_File.put_line(Fnd_File.LOG,

2586:
2587: --ln_inv_line_num := ln_inv_line_num + 1; commented out by eric for inclusive tax
2588:
2589: -- Added by Brathod for Bug#4445989
2590: Fnd_File.put_line(Fnd_File.LOG,
2591: 'Before inserting into ap_invoice_lines_all for line no :' || ln_inv_line_num );
2592:
2593: --insert exclusive tax to the ap tables
2594: --or insert recoverable inclusive tax with project information the ap tables

Line 2678: Fnd_File.put_line(Fnd_File.LOG,

2674: /* End 5763527 */
2675: ,po_dist_id --Added for bug#6780154
2676: );
2677:
2678: Fnd_File.put_line(Fnd_File.LOG,
2679: 'Before inserting into ap_invoice_distributions_all for distribution line no :'
2680: ||v_distribution_no );
2681:
2682: -- Start bug#3332988

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

2684: fetch c_get_invoice_distribution into v_invoice_distribution_id;
2685: close c_get_invoice_distribution;
2686: -- End bug#3332988
2687:
2688: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);
2689:
2690:
2691: INSERT INTO ap_invoice_distributions_all
2692: (

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

2808: -----------------------------------------------------------------
2809: --added by Eric for inclusive tax on 20-dec-2007,end
2810:
2811:
2812: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
2813:
2814: --added by Eric for inclusive tax on 20-dec-2007,begin
2815: -----------------------------------------------------------------
2816: IF (NVL(lv_tax_line_to_inst_flag,'N') = 'Y')

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

2924: cum_tax_amt := cum_tax_amt + ROUND(v_tax_amount, ln_precision);
2925:
2926:
2927: /* Obsoleted as a part of R12 , Bug# 4445989
2928: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_CMN_FA_INV_DIST_ALL');
2929: INSERT INTO JAI_CMN_FA_INV_DIST_ALL
2930: (
2931: invoice_id,
2932: invoice_distribution_id,

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

2973: */
2974:
2975: ELSIF p_rematch = 'PAY_ON_RECEIPT' THEN
2976:
2977: Fnd_File.put_line(Fnd_File.LOG, 'inside p_rematch = PAY_ON_RECEIPT ');
2978:
2979: IF p_receipt_code = 'RECEIPT' THEN
2980:
2981: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = RECEIPT ');

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

2977: Fnd_File.put_line(Fnd_File.LOG, 'inside p_rematch = PAY_ON_RECEIPT ');
2978:
2979: IF p_receipt_code = 'RECEIPT' THEN
2980:
2981: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = RECEIPT ');
2982:
2983: /* Begin 5763527 */
2984: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);
2985: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id

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

2980:
2981: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = RECEIPT ');
2982:
2983: /* Begin 5763527 */
2984: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);
2985: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id
2986: ,cp_organization_id => r_rcv_transactions.organization_id --Added by Bgowrava for Bug#7503308
2987: ,cp_shipment_header_id => p_shipment_header_id --Added by Bgowrava for Bug#7503308
2988: ,cp_txn_type => 'DELIVER' --Added by Bgowrava for Bug#7503308

Line 3062: fnd_file.put_line(FND_FILE.LOG,

3058: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
3059: fetch c_regime_tax_type into r_service_regime_tax_type;
3060: close c_regime_tax_type;
3061:
3062: fnd_file.put_line(FND_FILE.LOG,
3063: ' Service regime: '||r_service_regime_tax_type.tax_type);
3064:
3065: /* Bug 5358788. Added by Lakshmi Gopalsami
3066: * Fetched the details of VAT regime

Line 3073: fnd_file.put_line(FND_FILE.LOG,

3069: OPEN c_regime_tax_type(r_vat_regimes.regime_id, c_tax_rec.tax_type);
3070: FETCH c_regime_tax_type INTO r_vat_regime_tax_type;
3071: CLOSE c_regime_tax_type;
3072:
3073: fnd_file.put_line(FND_FILE.LOG,
3074: ' VAT regime: '||r_vat_regime_tax_type.tax_type);
3075:
3076: if r_service_regime_tax_type.tax_type is not null then
3077: /* Service type of tax */

Line 3089: fnd_file.put_line(FND_FILE.LOG,

3085: p_rematch,
3086: c_tax_rec.tax_type,
3087: po_dist_id --Added by JMEENA for bug#6833506
3088: );
3089: fnd_file.put_line(FND_FILE.LOG,
3090: ' Regime type , CCID '
3091: || r_service_regime_tax_type.tax_type
3092: ||', ' || v_dist_code_combination_id);
3093:

Line 3103: fnd_file.put_line(FND_FILE.LOG,

3099: ELSIF r_vat_regime_tax_type.tax_type IS NOT NULL THEN
3100: --p_rematch = 'PO_MATCHING' then
3101:
3102: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
3103: fnd_file.put_line(FND_FILE.LOG,
3104: ' Regime type , CCID '
3105: || r_vat_regime_tax_type.tax_type
3106: ||', ' || v_dist_code_combination_id);
3107: END IF;

Line 3154: 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);

3150: v_tax_amount := nvl(v_tax_amount,-1);
3151: -- End bug#4103473
3152:
3153: /* Bug#5763527 */
3154: 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);
3155: if UPPER(c_tax_rec.tax_type) like '%EXCISE%' then
3156: if lv_excise_costing_flag = 'Y' then
3157: IF nvl(lv_accrue_on_receipt_flag,'#') <> 'Y' -- Bug 6338371
3158: then

Line 3202: 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);

3198: END IF;--( NVL(tax_lines1_recinc_tax_flag,'N') = 'N')
3199: -------------------------------------------------------------------------------------
3200: --added by Eric for inclusive tax on 20-dec-2007,end
3201:
3202: 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);
3203:
3204: if tax_lines1_rec.modvat_flag = jai_constants.YES
3205: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
3206: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0

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

3214: ln_rec_tax_amt := nvl(v_tax_amount,0) * (c_tax_rec.mod_cr_percentage/100) ;
3215: ln_nrec_tax_amt := nvl(v_tax_amount,0) - nvl(ln_rec_tax_amt,0);
3216: lv_tax_type := 'PR'; --changed by eric for inclusive tax on Jan 4,2008
3217: end if;
3218: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
3219: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
3220: ',ln_nrec_tax_amt='||ln_nrec_tax_amt
3221: );
3222:

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

3412: END IF;
3413: -- ELSIF ( lv_tax_type <> 'PR' AND p_project_id IS NULL )
3414: -- THEN
3415: ELSE -- eric removed the above criteria for bug 6888665 and 6888209
3416: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');
3417: --The case process the inclusive NR tax and inclusive RE tax not for project
3418:
3419: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
3420: lv_modvat_flag := tax_lines1_rec.modvat_flag ;

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

3428:
3429:
3430:
3431:
3432: fnd_file.put_line(fnd_file.log, 'line='||line||', v_tax_amount='|| v_tax_amount
3433: ||'lv_modvat_flag='||lv_modvat_flag
3434: ||'v_assets_tracking_flag='||v_assets_tracking_flag
3435: );
3436:

Line 3442: Fnd_File.put_line(Fnd_File.LOG,

3438: --
3439: -- End 5763527
3440: --
3441:
3442: Fnd_File.put_line(Fnd_File.LOG,
3443: 'Before inserting into ap_invoice_lines_all for line no :'|| ln_inv_line_num );
3444:
3445:
3446: --insert exclusive tax to the ap tables

Line 3532: Fnd_File.put_line(Fnd_File.LOG,

3528: /* End 5763527 */
3529: ,po_dist_id --Added for bug#6780154
3530: );
3531:
3532: Fnd_File.put_line(Fnd_File.LOG,
3533: 'Before inserting into ap_invoice_distributions_all for distribution line no : '
3534: ||v_distribution_no);
3535:
3536: -- Start bug#3332988

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

3538: fetch c_get_invoice_distribution into v_invoice_distribution_id;
3539: close c_get_invoice_distribution;
3540: -- End bug#3332988
3541:
3542: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);
3543:
3544: INSERT INTO ap_invoice_distributions_all
3545: (
3546: accounting_date,

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

3659: END IF; --( NVL(lv_ap_line_to_inst_flag,'N')='Y')
3660: ------------------------------------------------------
3661: --added by Eric for inclusive tax on 20-dec-2007,end
3662:
3663: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
3664: INSERT INTO JAI_AP_MATCH_INV_TAXES
3665: (
3666: tax_distribution_id,
3667: exchange_rate_variance,

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

3768: */
3769: cum_tax_amt := cum_tax_amt + round(v_tax_amount, ln_precision); -- ROUND(v_tax_amount, 2),bug#2567799
3770:
3771: /* Obsoleted as part of R12 , Bug# 4445989
3772: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_CMN_FA_INV_DIST_ALL ');
3773:
3774: INSERT INTO JAI_CMN_FA_INV_DIST_ALL
3775: (
3776: invoice_id,

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

3842: */
3843:
3844: ELSIF p_receipt_code = 'PACKING_SLIP' THEN
3845:
3846: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = PACKING_SLIP');
3847:
3848: /* Begin 5763527 */
3849: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);
3850: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id

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

3845:
3846: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = PACKING_SLIP');
3847:
3848: /* Begin 5763527 */
3849: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);
3850: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id
3851: ,cp_organization_id => r_rcv_transactions.organization_id --Added by Bgowrava for Bug#7503308
3852: ,cp_shipment_header_id => p_shipment_header_id --Added by Bgowrava for Bug#7503308
3853: ,cp_txn_type => 'DELIVER' --Added by Bgowrava for Bug#7503308

Line 3924: fnd_file.put_line(FND_FILE.LOG,

3920: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
3921: fetch c_regime_tax_type into r_service_regime_tax_type;
3922: close c_regime_tax_type;
3923:
3924: fnd_file.put_line(FND_FILE.LOG,
3925: ' Service regime: '||r_service_regime_tax_type.tax_type);
3926:
3927: /* Bug 5358788. Added by Lakshmi Gopalsami
3928: * Fetched the details of VAT regime

Line 3935: fnd_file.put_line(FND_FILE.LOG,

3931: OPEN c_regime_tax_type(r_vat_regimes.regime_id, c_tax_rec.tax_type);
3932: FETCH c_regime_tax_type INTO r_vat_regime_tax_type;
3933: CLOSE c_regime_tax_type;
3934:
3935: fnd_file.put_line(FND_FILE.LOG,
3936: ' VAT regime: '||r_vat_regime_tax_type.tax_type);
3937:
3938: if r_service_regime_tax_type.tax_type is not null then
3939: /* Service type of tax */

Line 3952: fnd_file.put_line(FND_FILE.LOG,

3948: c_tax_rec.tax_type,
3949: po_dist_id --Added by JMEENA for bug#6833506
3950: );
3951:
3952: fnd_file.put_line(FND_FILE.LOG,
3953: ' Regime type , CCID '
3954: || r_service_regime_tax_type.tax_type
3955: ||', ' || v_dist_code_combination_id);
3956:

Line 3966: fnd_file.put_line(FND_FILE.LOG,

3962: ELSIF r_vat_regime_tax_type.tax_type IS NOT NULL THEN
3963: --p_rematch = 'PO_MATCHING' then
3964:
3965: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
3966: fnd_file.put_line(FND_FILE.LOG,
3967: ' Regime type , CCID '
3968: || r_vat_regime_tax_type.tax_type
3969: ||', ' || v_dist_code_combination_id);
3970:

Line 3996: 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);

3992:
3993: /* Service End */
3994:
3995: /* Bug#5763527 */
3996: 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);
3997: if UPPER(c_tax_rec.tax_type) like '%EXCISE%' then
3998: if lv_excise_costing_flag = 'Y' then
3999: IF nvl(lv_accrue_on_receipt_flag,'#') <> 'Y' -- Bug 6338371
4000: then

Line 4061: 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);

4057: -------------------------------------------------------------------------------------
4058: --added by Eric for inclusive tax on 20-dec-2007,end
4059:
4060:
4061: 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);
4062:
4063: if tax_lines1_rec.modvat_flag = jai_constants.YES
4064: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
4065: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100

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

4076:
4077: lv_tax_type := 'PR'; --changed by eric for inclusive tax on Jan 4,2008
4078:
4079: end if;
4080: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
4081: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
4082: ',ln_nrec_tax_amt='||ln_nrec_tax_amt
4083: );
4084:

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

4277: END IF;
4278: -- ELSIF ( lv_tax_type <> 'PR' AND p_project_id IS NULL )
4279: -- THEN
4280: ELSE -- eric removed the above criteria for bug 6888665 and 6888209
4281: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');
4282: --The case process the inclusive NR tax and inclusive RE tax not for project
4283:
4284: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
4285: lv_modvat_flag := tax_lines1_rec.modvat_flag ;

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

4292: --added by Eric for inclusive tax on 20-dec-2007,end
4293:
4294:
4295:
4296: Fnd_File.put_line(Fnd_File.LOG,'Before inserting into ap_invoice_lines_all for line no :'
4297: || ln_inv_line_num );
4298:
4299:
4300: --insert exclusive tax to the ap tables

Line 4386: Fnd_File.put_line(Fnd_File.LOG,

4382: /* End 5763527 */
4383: ,po_dist_id --Added for bug#6780154
4384: );
4385:
4386: Fnd_File.put_line(Fnd_File.LOG,
4387: 'Before inserting into ap_invoice_distributions_all for distribution line no : ' || v_distribution_no);
4388:
4389: -- Start bug#3332988
4390: open c_get_invoice_distribution;

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

4391: fetch c_get_invoice_distribution into v_invoice_distribution_id;
4392: close c_get_invoice_distribution;
4393: -- End bug#3332988
4394:
4395: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);
4396:
4397: INSERT INTO ap_invoice_distributions_all
4398: (
4399: accounting_date,

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

4515: ----------------------------------------------------------------
4516: --added by Eric for inclusive tax on 20-dec-2007,end
4517:
4518:
4519: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
4520:
4521: --added by Eric for inclusive tax on 20-dec-2007,begin
4522: -----------------------------------------------------------------
4523: IF (NVL(lv_tax_line_to_inst_flag,'N') = 'Y')

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

4641:
4642: cum_tax_amt := cum_tax_amt + round(v_tax_amount,ln_precision); -- ROUND(v_tax_amount, 2) bug#2567799;
4643:
4644: /* Obsoleted as part of R12 , Bug# 4445989
4645: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_CMN_FA_INV_DIST_ALL ');
4646: INSERT INTO JAI_CMN_FA_INV_DIST_ALL
4647: (
4648: invoice_id,
4649: invoice_distribution_id,

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

4719:
4720: ELSIF p_rematch = 'RCV_MATCHING' THEN
4721:
4722:
4723: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = RCV_MATCHING');
4724:
4725: /* Begin 5763527 */
4726: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);
4727: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id

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

4722:
4723: Fnd_File.put_line(Fnd_File.LOG, 'inside p_receipt_code = RCV_MATCHING');
4724:
4725: /* Begin 5763527 */
4726: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id);
4727: open c_get_excise_costing_flag (cp_rcv_transaction_id => rcv_tran_id
4728: ,cp_organization_id => r_rcv_transactions.organization_id --Added by Bgowrava for Bug#7503308
4729: ,cp_shipment_header_id => p_shipment_header_id --Added by Bgowrava for Bug#7503308
4730: ,cp_txn_type => 'DELIVER' --Added by Bgowrava for Bug#7503308

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

4746: -----------------------------------------------------------
4747: -- Modified by Jason Liu for retroactive price on 2008/01/09
4748: -- Added the parameter lv_source
4749: FOR r_tax_lines_rec IN r_tax_lines_cur(rcv_tran_id,for_org_id_rec.vendor_id,lv_source) LOOP
4750: Fnd_File.put_line(Fnd_File.LOG, ' ');
4751: /* 5763527 */
4752: ln_project_id := null;
4753: ln_task_id := null;
4754: lv_exp_type := null;

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

4797: v_dist_code_combination_id := null;
4798: --initial the tax_type
4799: lv_tax_type := NULL;--added by eric for inclusive tax on 20-Dec,2007
4800:
4801: Fnd_File.put_line(Fnd_File.LOG, 'c_tax_rec.mod_cr_percentage = '||c_tax_rec.mod_cr_percentage);
4802: -- 5763527, Brathod
4803: -- Modified the if condition to consider partial recoverable lines previous logic was hadling only when it is 100
4804: if r_tax_lines_rec.modvat_flag = jai_constants.YES
4805: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0

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

4807: /* recoverable tax */
4808: lv_tax_type := 'RE'; --added by eric for inclusive tax on 20-dec,2007
4809: v_assets_tracking_flag := 'N';
4810:
4811: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '||lv_tax_type);
4812:
4813: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
4814: fetch c_regime_tax_type into r_service_regime_tax_type;
4815: close c_regime_tax_type;

Line 4817: fnd_file.put_line(FND_FILE.LOG,

4813: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
4814: fetch c_regime_tax_type into r_service_regime_tax_type;
4815: close c_regime_tax_type;
4816:
4817: fnd_file.put_line(FND_FILE.LOG,
4818: ' Service regime: '||r_service_regime_tax_type.tax_type);
4819:
4820: /* Bug 5358788. Added by Lakshmi Gopalsami
4821: * Fetched the details of VAT regime

Line 4828: fnd_file.put_line(FND_FILE.LOG,

4824: OPEN c_regime_tax_type(r_vat_regimes.regime_id, c_tax_rec.tax_type);
4825: FETCH c_regime_tax_type INTO r_vat_regime_tax_type;
4826: CLOSE c_regime_tax_type;
4827:
4828: fnd_file.put_line(FND_FILE.LOG,
4829: ' VAT regime: '||r_vat_regime_tax_type.tax_type);
4830:
4831: if r_service_regime_tax_type.tax_type is not null then
4832: /* Service type of tax */

Line 4844: fnd_file.put_line(FND_FILE.LOG,

4840: p_rematch,
4841: c_tax_rec.tax_type,
4842: po_dist_id --Added by JMEENA for bug#6833506
4843: );
4844: fnd_file.put_line(FND_FILE.LOG,
4845: ' Regime type , CCID '
4846: || r_service_regime_tax_type.tax_type
4847: ||', ' || v_dist_code_combination_id);
4848:

Line 4858: fnd_file.put_line(FND_FILE.LOG,

4854: ELSIF r_vat_regime_tax_type.tax_type IS NOT NULL THEN
4855: --p_rematch = 'RCV_MATCHING' then
4856:
4857: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
4858: fnd_file.put_line(FND_FILE.LOG,
4859: ' Regime type , CCID '
4860: || r_vat_regime_tax_type.tax_type
4861: ||', ' || v_dist_code_combination_id);
4862:

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

4876: END if;
4877:
4878: --non recoverable
4879: lv_tax_type := 'NR'; --added by eric for inclusive tax on 20-dec,2007
4880: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '||lv_tax_type);
4881: Fnd_File.put_line(Fnd_File.LOG, 'lv_accrue_on_receipt_flag = '||lv_accrue_on_receipt_flag);
4882: end if; /*nvl(c_tax_rec.mod_cr_percentage, 0) = 100 and c_tax_rec.tax_account_id is not null*/
4883:
4884:

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

4877:
4878: --non recoverable
4879: lv_tax_type := 'NR'; --added by eric for inclusive tax on 20-dec,2007
4880: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '||lv_tax_type);
4881: Fnd_File.put_line(Fnd_File.LOG, 'lv_accrue_on_receipt_flag = '||lv_accrue_on_receipt_flag);
4882: end if; /*nvl(c_tax_rec.mod_cr_percentage, 0) = 100 and c_tax_rec.tax_account_id is not null*/
4883:
4884:
4885: /* Bug#4177452*/

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

4887: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
4888: end if;
4889:
4890: /*following line added for bug 6595773*/
4891: Fnd_File.put_line(Fnd_File.LOG, 'v_dist_code_combination_id : ' || v_dist_code_combination_id ) ;
4892: /* Service End */
4893:
4894: -- Start for bug#3752887
4895: v_tax_amount := r_tax_lines_rec.tax_amount * v_apportn_factor_for_item_line;

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

4892: /* Service End */
4893:
4894: -- Start for bug#3752887
4895: v_tax_amount := r_tax_lines_rec.tax_amount * v_apportn_factor_for_item_line;
4896: Fnd_File.put_line(Fnd_File.LOG, 'v_apportn_factor_for_item_line = '||v_apportn_factor_for_item_line);
4897: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '||v_tax_amount);
4898:
4899: if for_org_id_rec.invoice_currency_code <> r_tax_lines_rec.currency then
4900: v_tax_amount := v_tax_amount / for_org_id_rec.exchange_rate;

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

4893:
4894: -- Start for bug#3752887
4895: v_tax_amount := r_tax_lines_rec.tax_amount * v_apportn_factor_for_item_line;
4896: Fnd_File.put_line(Fnd_File.LOG, 'v_apportn_factor_for_item_line = '||v_apportn_factor_for_item_line);
4897: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '||v_tax_amount);
4898:
4899: if for_org_id_rec.invoice_currency_code <> r_tax_lines_rec.currency then
4900: v_tax_amount := v_tax_amount / for_org_id_rec.exchange_rate;
4901: end if;

Line 4904: 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);

4900: v_tax_amount := v_tax_amount / for_org_id_rec.exchange_rate;
4901: end if;
4902:
4903: /* Bug#5763527 */
4904: 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);
4905: if UPPER(c_tax_rec.tax_type) like '%EXCISE%' then
4906:
4907: if lv_excise_costing_flag = 'Y' THEN
4908: IF nvl(lv_accrue_on_receipt_flag , '#') <> 'Y' -- Bug 6338371

Line 4980: 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);

4976:
4977:
4978:
4979:
4980: 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);
4981:
4982: if r_tax_lines_rec.modvat_flag = jai_constants.YES
4983: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
4984: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100

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

4996: ln_nrec_tax_amt := nvl(v_tax_amount,0) - nvl(ln_rec_tax_amt,0);
4997:
4998: lv_tax_type := 'PR'; --added by eric for inclusive tax on Jan 4,2008
4999: end if;
5000: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
5001: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
5002: ',ln_nrec_tax_amt='||ln_nrec_tax_amt
5003: );
5004:

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

5008: -- For ordinary lines (with modvat_flag = 'N' or with mod_cr_percentage = 100 fully recoverable) the variable
5009: -- ln_lines_to_insert will have value of 1 and hence only one line will be inserted with full tax amount
5010: --
5011:
5012: Fnd_File.put_line(Fnd_File.LOG, 'ln_lines_to_insert ='|| ln_lines_to_insert);
5013: for line in 1..ln_lines_to_insert
5014: loop
5015: --deleted by eric for inclusive tax on 04-Jan-2008,begin
5016: ---------------------------------------------------------------------------

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

5057: --deleted by eric for inclusive tax on 04-Jan-2008,end
5058:
5059: --added by Eric for inclusive tax on 20-dec-2007,begin
5060: ---------------------------------------------------------------------------
5061: Fnd_File.put_line(Fnd_File.LOG, 'line = '|| line);
5062: Fnd_File.put_line(Fnd_File.LOG, 'inc_tax_flag = '|| NVL(r_tax_lines_rec.inc_tax_flag,'N'));
5063: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '|| lv_tax_type);
5064: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '|| v_tax_amount);
5065: Fnd_File.put_line(Fnd_File.LOG, 'ln_nrec_tax_amt = '|| ln_nrec_tax_amt);

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

5058:
5059: --added by Eric for inclusive tax on 20-dec-2007,begin
5060: ---------------------------------------------------------------------------
5061: Fnd_File.put_line(Fnd_File.LOG, 'line = '|| line);
5062: Fnd_File.put_line(Fnd_File.LOG, 'inc_tax_flag = '|| NVL(r_tax_lines_rec.inc_tax_flag,'N'));
5063: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '|| lv_tax_type);
5064: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '|| v_tax_amount);
5065: Fnd_File.put_line(Fnd_File.LOG, 'ln_nrec_tax_amt = '|| ln_nrec_tax_amt);
5066: Fnd_File.put_line(Fnd_File.LOG, 'ln_rec_tax_amt = '|| ln_rec_tax_amt );

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

5059: --added by Eric for inclusive tax on 20-dec-2007,begin
5060: ---------------------------------------------------------------------------
5061: Fnd_File.put_line(Fnd_File.LOG, 'line = '|| line);
5062: Fnd_File.put_line(Fnd_File.LOG, 'inc_tax_flag = '|| NVL(r_tax_lines_rec.inc_tax_flag,'N'));
5063: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '|| lv_tax_type);
5064: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '|| v_tax_amount);
5065: Fnd_File.put_line(Fnd_File.LOG, 'ln_nrec_tax_amt = '|| ln_nrec_tax_amt);
5066: Fnd_File.put_line(Fnd_File.LOG, 'ln_rec_tax_amt = '|| ln_rec_tax_amt );
5067:

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

5060: ---------------------------------------------------------------------------
5061: Fnd_File.put_line(Fnd_File.LOG, 'line = '|| line);
5062: Fnd_File.put_line(Fnd_File.LOG, 'inc_tax_flag = '|| NVL(r_tax_lines_rec.inc_tax_flag,'N'));
5063: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '|| lv_tax_type);
5064: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '|| v_tax_amount);
5065: Fnd_File.put_line(Fnd_File.LOG, 'ln_nrec_tax_amt = '|| ln_nrec_tax_amt);
5066: Fnd_File.put_line(Fnd_File.LOG, 'ln_rec_tax_amt = '|| ln_rec_tax_amt );
5067:
5068: IF (NVL(r_tax_lines_rec.inc_tax_flag,'N') = 'N')--exclusive case

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

5061: Fnd_File.put_line(Fnd_File.LOG, 'line = '|| line);
5062: Fnd_File.put_line(Fnd_File.LOG, 'inc_tax_flag = '|| NVL(r_tax_lines_rec.inc_tax_flag,'N'));
5063: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '|| lv_tax_type);
5064: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '|| v_tax_amount);
5065: Fnd_File.put_line(Fnd_File.LOG, 'ln_nrec_tax_amt = '|| ln_nrec_tax_amt);
5066: Fnd_File.put_line(Fnd_File.LOG, 'ln_rec_tax_amt = '|| ln_rec_tax_amt );
5067:
5068: IF (NVL(r_tax_lines_rec.inc_tax_flag,'N') = 'N')--exclusive case
5069: THEN

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

5062: Fnd_File.put_line(Fnd_File.LOG, 'inc_tax_flag = '|| NVL(r_tax_lines_rec.inc_tax_flag,'N'));
5063: Fnd_File.put_line(Fnd_File.LOG, 'lv_tax_type = '|| lv_tax_type);
5064: Fnd_File.put_line(Fnd_File.LOG, 'v_tax_amount = '|| v_tax_amount);
5065: Fnd_File.put_line(Fnd_File.LOG, 'ln_nrec_tax_amt = '|| ln_nrec_tax_amt);
5066: Fnd_File.put_line(Fnd_File.LOG, 'ln_rec_tax_amt = '|| ln_rec_tax_amt );
5067:
5068: IF (NVL(r_tax_lines_rec.inc_tax_flag,'N') = 'N')--exclusive case
5069: THEN
5070: Fnd_File.put_line(Fnd_File.LOG, 'Exclusive Branch');

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

5066: Fnd_File.put_line(Fnd_File.LOG, 'ln_rec_tax_amt = '|| ln_rec_tax_amt );
5067:
5068: IF (NVL(r_tax_lines_rec.inc_tax_flag,'N') = 'N')--exclusive case
5069: THEN
5070: Fnd_File.put_line(Fnd_File.LOG, 'Exclusive Branch');
5071: IF line = 1 then
5072:
5073: v_tax_amount := nvl(ln_rec_tax_amt, v_tax_amount);
5074: lv_tax_line_amount:= v_tax_amount ; --added by eric for inclusive tax

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

5109:
5110: END IF; --line = 1
5111: ELSIF (NVL(r_tax_lines_rec.inc_tax_flag,'N') = 'Y') --inclusive case
5112: THEN
5113: Fnd_File.put_line(Fnd_File.LOG, 'Inclusive Branch');
5114: IF( lv_tax_type ='PR')
5115: THEN
5116: Fnd_File.put_line(Fnd_File.LOG, 'PR Tax');
5117: IF ( line = 1 )

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

5112: THEN
5113: Fnd_File.put_line(Fnd_File.LOG, 'Inclusive Branch');
5114: IF( lv_tax_type ='PR')
5115: THEN
5116: Fnd_File.put_line(Fnd_File.LOG, 'PR Tax');
5117: IF ( line = 1 )
5118: THEN
5119: --recoverable part
5120: v_tax_amount := ln_rec_tax_amt ;

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

5176: ELSIF ( lv_tax_type = 'RE'
5177: AND p_project_id IS NOT NULL
5178: )
5179: THEN
5180: Fnd_File.put_line(Fnd_File.LOG, 'RE Tax ,p_project_id IS NOT NULL');
5181: --recoverable tax without project infor
5182: IF ( line = 1 )
5183: THEN
5184: v_tax_amount := v_tax_amount ;

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

5213: END IF;
5214: -- ELSIF ( lv_tax_type <> 'PR' AND p_project_id IS NULL )
5215: -- THEN
5216: ELSE -- eric removed the above criteria for bug 6888665 and 6888209
5217: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');
5218: --The case process the inclusive NR tax and inclusive RE tax not for project
5219:
5220: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
5221: lv_modvat_flag := r_tax_lines_rec.modvat_flag ;

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

5230:
5231: --insert exclusive tax to the ap tables
5232: --or insert recoverable inclusive tax with project information the ap tables
5233:
5234: Fnd_File.put_line(Fnd_File.LOG,'r_tax_lines_rec.tax_id :'|| r_tax_lines_rec.tax_id );
5235: Fnd_File.put_line(Fnd_File.LOG,'line :'|| line );
5236: Fnd_File.put_line(Fnd_File.LOG,'lv_ap_line_to_inst_flag :'|| lv_ap_line_to_inst_flag );
5237: Fnd_File.put_line(Fnd_File.LOG,'lv_tax_line_to_inst_flag :'|| lv_tax_line_to_inst_flag );
5238:

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

5231: --insert exclusive tax to the ap tables
5232: --or insert recoverable inclusive tax with project information the ap tables
5233:
5234: Fnd_File.put_line(Fnd_File.LOG,'r_tax_lines_rec.tax_id :'|| r_tax_lines_rec.tax_id );
5235: Fnd_File.put_line(Fnd_File.LOG,'line :'|| line );
5236: Fnd_File.put_line(Fnd_File.LOG,'lv_ap_line_to_inst_flag :'|| lv_ap_line_to_inst_flag );
5237: Fnd_File.put_line(Fnd_File.LOG,'lv_tax_line_to_inst_flag :'|| lv_tax_line_to_inst_flag );
5238:
5239: --1.Only exlusive taxes or inclusive recoverable taxes with project information

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

5232: --or insert recoverable inclusive tax with project information the ap tables
5233:
5234: Fnd_File.put_line(Fnd_File.LOG,'r_tax_lines_rec.tax_id :'|| r_tax_lines_rec.tax_id );
5235: Fnd_File.put_line(Fnd_File.LOG,'line :'|| line );
5236: Fnd_File.put_line(Fnd_File.LOG,'lv_ap_line_to_inst_flag :'|| lv_ap_line_to_inst_flag );
5237: Fnd_File.put_line(Fnd_File.LOG,'lv_tax_line_to_inst_flag :'|| lv_tax_line_to_inst_flag );
5238:
5239: --1.Only exlusive taxes or inclusive recoverable taxes with project information
5240: -- are inserted into Ap Lines and Dist Lines

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

5233:
5234: Fnd_File.put_line(Fnd_File.LOG,'r_tax_lines_rec.tax_id :'|| r_tax_lines_rec.tax_id );
5235: Fnd_File.put_line(Fnd_File.LOG,'line :'|| line );
5236: Fnd_File.put_line(Fnd_File.LOG,'lv_ap_line_to_inst_flag :'|| lv_ap_line_to_inst_flag );
5237: Fnd_File.put_line(Fnd_File.LOG,'lv_tax_line_to_inst_flag :'|| lv_tax_line_to_inst_flag );
5238:
5239: --1.Only exlusive taxes or inclusive recoverable taxes with project information
5240: -- are inserted into Ap Lines and Dist Lines
5241:

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

5249: ln_inv_line_num := ln_inv_line_num + 1; --added by eric for inlcusive tax
5250: ---------------------------------------------------------------------------
5251: --added by Eric for inclusive tax on 20-dec-2007,end
5252:
5253: Fnd_File.put_line(Fnd_File.LOG,'Before inserting into ap_invoice_lines_all for line no :'|| ln_inv_line_num );
5254:
5255: INSERT INTO ap_invoice_lines_all
5256: (
5257: INVOICE_ID

Line 5322: Fnd_File.put_line(Fnd_File.LOG,

5318: ,po_dist_id --Added for bug#6780154
5319: );
5320:
5321:
5322: Fnd_File.put_line(Fnd_File.LOG,
5323: 'Before inserting into ap_invoice_distributions_all for distribution line no :' || v_distribution_no);
5324:
5325: -- Start bug#3332988
5326: open c_get_invoice_distribution;

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

5327: fetch c_get_invoice_distribution into v_invoice_distribution_id;
5328: close c_get_invoice_distribution;
5329: -- End bug#3332988
5330:
5331: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);
5332:
5333: INSERT INTO ap_invoice_distributions_all
5334: (
5335: accounting_date,

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

5462: THEN
5463: -----------------------------------------------------------------
5464: --added by Eric for inclusive tax on 20-dec-2007,end
5465:
5466: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
5467: INSERT INTO JAI_AP_MATCH_INV_TAXES
5468: (
5469: tax_distribution_id,
5470: --shipment_line_id,

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

5582:
5583: cum_tax_amt := cum_tax_amt + ROUND(v_tax_amount, ln_precision);
5584:
5585: /* Obsoleted as part of R12 , Bug# 4445989
5586: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_CMN_FA_INV_DIST_ALL ');
5587: INSERT INTO JAI_CMN_FA_INV_DIST_ALL
5588: (
5589: invoice_id,
5590: invoice_distribution_id,

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

5633:
5634: END IF; -- p_rematch = 'RCV_MATCHING'
5635:
5636:
5637: Fnd_File.put_line(Fnd_File.LOG, 'SUCCESSFUL END PROCEDURE - jai_ap_match_tax_pkg.process_online');
5638:
5639: EXCEPTION
5640: WHEN OTHERS THEN
5641: ERRBUF := SQLERRM;

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

5639: EXCEPTION
5640: WHEN OTHERS THEN
5641: ERRBUF := SQLERRM;
5642: RETCODE := 2;
5643: Fnd_File.put_line(Fnd_File.LOG, 'EXCEPTION END PROCEDURE - jai_ap_match_tax_pkg.process_online');
5644: Fnd_File.put_line(Fnd_File.LOG, 'Error : ' || ERRBUF);
5645: END process_online;
5646:
5647: PROCEDURE process_batch_record (

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

5640: WHEN OTHERS THEN
5641: ERRBUF := SQLERRM;
5642: RETCODE := 2;
5643: Fnd_File.put_line(Fnd_File.LOG, 'EXCEPTION END PROCEDURE - jai_ap_match_tax_pkg.process_online');
5644: Fnd_File.put_line(Fnd_File.LOG, 'Error : ' || ERRBUF);
5645: END process_online;
5646:
5647: PROCEDURE process_batch_record (
5648: err_mesg OUT NOCOPY VARCHAR2,

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

6097: where invoice_id = inv_id;
6098:
6099: begin
6100:
6101: Fnd_File.put_line(Fnd_File.LOG, 'Start of function update_payment_schedule');
6102:
6103: open c_total_payment_amt;
6104: fetch c_total_payment_amt into v_total_payment_amt;
6105: close c_total_payment_amt;

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

6104: fetch c_total_payment_amt into v_total_payment_amt;
6105: close c_total_payment_amt;
6106:
6107: if nvl(v_total_payment_amt, 0) = 0 then
6108: Fnd_File.put_line(Fnd_File.LOG, 'Cannot update payment schedule, total payment amount :'
6109: || to_char(v_total_payment_amt));
6110: return false;
6111: end if;
6112:

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

6162: return true;
6163:
6164: exception
6165: when others then
6166: Fnd_File.put_line(Fnd_File.LOG, 'exception from function update_payment_schedule');
6167: Fnd_File.put_line(Fnd_File.LOG, sqlerrm);
6168: return false;
6169:
6170: end update_payment_schedule; -- bug # 3218978

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

6163:
6164: exception
6165: when others then
6166: Fnd_File.put_line(Fnd_File.LOG, 'exception from function update_payment_schedule');
6167: Fnd_File.put_line(Fnd_File.LOG, sqlerrm);
6168: return false;
6169:
6170: end update_payment_schedule; -- bug # 3218978
6171:

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

6192: when others then
6193: IF SQLCODE = -6550 THEN
6194: -- object referred in EXECUTE IMMEDIATE is not available in the database
6195: null;
6196: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(insert)');
6197: ELSE
6198: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(insert)->'||SQLERRM);
6199: RAISE;
6200: END IF;

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

6194: -- object referred in EXECUTE IMMEDIATE is not available in the database
6195: null;
6196: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(insert)');
6197: ELSE
6198: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(insert)->'||SQLERRM);
6199: RAISE;
6200: END IF;
6201: end;
6202:

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

6223: when others then
6224: IF SQLCODE = -6550 THEN
6225: -- object referred in EXECUTE IMMEDIATE is not available in the database
6226: null;
6227: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(update)');
6228: ELSE
6229: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(update)->'||SQLERRM);
6230: RAISE;
6231: END IF;

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

6225: -- object referred in EXECUTE IMMEDIATE is not available in the database
6226: null;
6227: FND_FILE.put_line(FND_FILE.log, '*** MRC API is not existing(update)');
6228: ELSE
6229: FND_FILE.put_line(FND_FILE.log, 'MRC API exists and different err(update)->'||SQLERRM);
6230: RAISE;
6231: END IF;
6232: end;
6233:

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

6623:
6624: -- start added by bug#3206083
6625: if get_ven_info_rec.cancelled_date is not null then
6626: -- base invoice has been cancelled, no need to process tax.
6627: Fnd_File.put_line(Fnd_File.LOG, 'Base invoice has been cancelled, no need to process tax');
6628: return;
6629: end if;
6630: -- end added by bug#3206083
6631:

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

6815: ,cp_txn_type => 'DELIVER' --Added by Bgowrava for Bug#7503308
6816: ,cp_attribute1 => 'CENVAT_COSTED_FLAG'); --Added by Bgowrava for Bug#7503308
6817: fetch c_get_excise_costing_flag into lv_excise_costing_flag;
6818: close c_get_excise_costing_flag ;
6819: fnd_file.put_line(fnd_file.log, 'rcv_tran_id='||rcv_tran_id||',lv_excise_costing_flag='||lv_excise_costing_flag);
6820: /* End 5763527 */
6821:
6822:
6823: IF p_receipt_code = 'RECEIPT' THEN

Line 6895: fnd_file.put_line(FND_FILE.LOG,

6891: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
6892: fetch c_regime_tax_type into r_service_regime_tax_type;
6893: close c_regime_tax_type;
6894:
6895: fnd_file.put_line(FND_FILE.LOG,
6896: ' Service regime: '||r_service_regime_tax_type.tax_type);
6897:
6898: /* Bug 5358788. Added by Lakshmi Gopalsami
6899: * Fetched the details of VAT regime

Line 6906: fnd_file.put_line(FND_FILE.LOG,

6902: OPEN c_regime_tax_type(r_vat_regimes.regime_id, c_tax_rec.tax_type);
6903: FETCH c_regime_tax_type into r_vat_regime_tax_type;
6904: CLOSE c_regime_tax_type;
6905:
6906: fnd_file.put_line(FND_FILE.LOG,
6907: ' VAT regime: '||r_vat_regime_tax_type.tax_type);
6908:
6909: if r_service_regime_tax_type.tax_type is not null then
6910: /* Service type of tax */

Line 6922: fnd_file.put_line(FND_FILE.LOG,

6918: p_rematch,
6919: c_tax_rec.tax_type,
6920: po_dist_id --Added by JMEENA for bug#6833506
6921: );
6922: fnd_file.put_line(FND_FILE.LOG,
6923: ' Regime type , CCID '
6924: || r_service_regime_tax_type.tax_type
6925: ||', ' || v_dist_code_combination_id);
6926: /* Bug 5358788. Added by Lakshmi Gopalsami

Line 6935: fnd_file.put_line(FND_FILE.LOG,

6931: ELSIF r_vat_regime_tax_type.tax_type IS NOT NULL THEN
6932: -- p_rematch = 'PO_MATCHING' then
6933:
6934: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
6935: fnd_file.put_line(FND_FILE.LOG,
6936: ' Regime type , CCID '
6937: || r_vat_regime_tax_type.tax_type
6938: ||', ' || v_dist_code_combination_id);
6939:

Line 6964: 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);

6960: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
6961: end if;
6962:
6963: /* Bug#5763527 */
6964: 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);
6965: if upper(c_tax_rec.tax_type) like '%EXCISE%' then
6966:
6967: if lv_excise_costing_flag = 'Y' then
6968: IF nvl(lv_accrue_on_receipt_flag , '#') <> 'Y' -- Bug 6338371

Line 7024: 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);

7020: END IF;--( NVL(tax_lines1_rec.inc_tax_flag,'N') = 'N' OR )
7021: -------------------------------------------------------------------------------------
7022: --added by Eric for inclusive tax on 20-dec-2007,end
7023:
7024: 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);
7025:
7026: if tax_lines1_rec.modvat_flag = jai_constants.YES
7027: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
7028: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100

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

7038: ln_nrec_tax_amt := nvl(v_tax_amount,0) - nvl(ln_rec_tax_amt,0);
7039: lv_tax_type := 'PR'; --changed by eric for inclusive tax on Jan 4,2008
7040:
7041: end if;
7042: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
7043: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
7044: ',ln_nrec_tax_amt='||ln_nrec_tax_amt
7045: );
7046:

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

7233: END IF;
7234: -- ELSIF ( lv_tax_type <> 'PR' AND p_project_id IS NULL )
7235: -- THEN
7236: ELSE -- eric removed the above criteria for bug 6888665 and 6888209
7237: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');
7238: --The case process the inclusive NR tax and inclusive RE tax not for project
7239:
7240: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
7241: lv_modvat_flag := tax_lines1_rec.modvat_flag ;

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

7336: open c_get_invoice_distribution;
7337: fetch c_get_invoice_distribution into v_invoice_distribution_id;
7338: close c_get_invoice_distribution;
7339: -- End bug#3332988
7340: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);
7341:
7342: INSERT INTO ap_invoice_distributions_all
7343: (
7344: accounting_date,

Line 7724: fnd_file.put_line(FND_FILE.LOG,

7720: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
7721: fetch c_regime_tax_type into r_service_regime_tax_type;
7722: close c_regime_tax_type;
7723:
7724: fnd_file.put_line(FND_FILE.LOG,
7725: ' Service regime: '||r_service_regime_tax_type.tax_type);
7726:
7727: /* Bug 5358788. Added by Lakshmi Gopalsami
7728: * Fetched the details of VAT regime

Line 7735: fnd_file.put_line(FND_FILE.LOG,

7731: OPEN c_regime_tax_type(r_vat_regimes.regime_id, c_tax_rec.tax_type);
7732: FETCH c_regime_tax_type INTO r_vat_regime_tax_type;
7733: CLOSE c_regime_tax_type;
7734:
7735: fnd_file.put_line(FND_FILE.LOG,
7736: ' VAT regime: '||r_vat_regime_tax_type.tax_type);
7737:
7738: if r_service_regime_tax_type.tax_type is not null then
7739: /* Service type of tax */

Line 7751: fnd_file.put_line(FND_FILE.LOG,

7747: p_rematch,
7748: c_tax_rec.tax_type,
7749: po_dist_id --Added by JMEENA for bug#6833506
7750: );
7751: fnd_file.put_line(FND_FILE.LOG,
7752: ' Regime type , CCID '
7753: || r_service_regime_tax_type.tax_type
7754: ||', ' || v_dist_code_combination_id);
7755:

Line 7765: fnd_file.put_line(FND_FILE.LOG,

7761: ELSIF r_vat_regime_tax_type.tax_type IS NOT NULL THEN
7762: --p_rematch = 'PO_MATCHING' then
7763:
7764: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
7765: fnd_file.put_line(FND_FILE.LOG,
7766: ' Regime type , CCID '
7767: || r_vat_regime_tax_type.tax_type
7768: ||', ' || v_dist_code_combination_id);
7769:

Line 7795: 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);

7791: end if;
7792:
7793:
7794: /* Bug#5763527 */
7795: 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);
7796: if upper(c_tax_rec.tax_type) like '%EXCISE%' then
7797:
7798: if lv_excise_costing_flag = 'Y' THEN
7799: IF nvl(lv_accrue_on_receipt_flag , '#') <> 'Y' THEN -- Bug 6338371

Line 7856: 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);

7852: --added by Eric for inclusive tax on 20-dec-2007,end
7853:
7854:
7855:
7856: 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);
7857:
7858: if tax_lines1_rec.modvat_flag = jai_constants.YES
7859: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100
7860: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0

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

7869: ln_nrec_tax_amt := nvl(v_tax_amount,0) - nvl(ln_rec_tax_amt,0);
7870:
7871: lv_tax_type := 'PR'; --changed by eric for inclusive tax on Jan 4,2008
7872: end if;
7873: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
7874: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
7875: ',ln_nrec_tax_amt='||ln_nrec_tax_amt
7876: );
7877:

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

8069: END IF;
8070: --ELSIF ( lv_tax_type <> 'PR' AND p_project_id IS NULL )
8071: --THEN
8072: ELSE -- eric removed the above criteria for bug 6888665 and 6888209
8073: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');
8074: --The case process the inclusive NR tax and inclusive RE tax not for project
8075:
8076: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
8077: lv_modvat_flag := tax_lines1_rec.modvat_flag ;

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

8086:
8087:
8088:
8089:
8090: fnd_file.put_line(fnd_file.log, 'line='||line||', v_tax_amount='|| v_tax_amount
8091: ||'lv_modvat_flag='||lv_modvat_flag
8092: ||'v_assets_tracking_flag='||v_assets_tracking_flag
8093: );
8094:

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

8183: open c_get_invoice_distribution;
8184: fetch c_get_invoice_distribution into v_invoice_distribution_id;
8185: close c_get_invoice_distribution;
8186: -- End bug#3332988
8187: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);
8188:
8189: INSERT INTO ap_invoice_distributions_all
8190: (
8191: accounting_date,

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

8509:
8510: --IF rcv_tran_id IS NOT NULL THEN
8511: -- to be fired when po_line_locations_all.match_option = 'P'
8512:
8513: Fnd_File.put_line(Fnd_File.LOG, 'Fired when rcv_tran_id IS NULL, match_option is P');
8514:
8515: -- fetch shipment_num from rcv_headers_interface based on invoice_num
8516: -- pramasub start for isupplier IL FP
8517: -- local cursor to fetch shipment number

Line 8605: fnd_file.put_line(FND_FILE.LOG,

8601: open c_regime_tax_type(r_jai_regimes.regime_id, c_tax_rec.tax_type);
8602: fetch c_regime_tax_type into r_service_regime_tax_type;
8603: close c_regime_tax_type;
8604:
8605: fnd_file.put_line(FND_FILE.LOG,
8606: ' Service regime: '||r_service_regime_tax_type.tax_type);
8607:
8608: /* Bug 5358788. Added by Lakshmi Gopalsami
8609: * Fetched the details of VAT regime

Line 8616: fnd_file.put_line(FND_FILE.LOG,

8612: OPEN c_regime_tax_type(r_vat_regimes.regime_id, c_tax_rec.tax_type);
8613: FETCH c_regime_tax_type INTO r_vat_regime_tax_type;
8614: CLOSE c_regime_tax_type;
8615:
8616: fnd_file.put_line(FND_FILE.LOG,
8617: ' VAT regime: '||r_vat_regime_tax_type.tax_type);
8618:
8619: if r_service_regime_tax_type.tax_type is not null then
8620: /* Service type of tax */

Line 8632: fnd_file.put_line(FND_FILE.LOG,

8628: p_rematch,
8629: c_tax_rec.tax_type,
8630: po_dist_id --Added by JMEENA for bug#6833506
8631: );
8632: fnd_file.put_line(FND_FILE.LOG,
8633: ' Regime type , CCID '
8634: || r_service_regime_tax_type.tax_type
8635: ||', ' || v_dist_code_combination_id);
8636:

Line 8646: fnd_file.put_line(FND_FILE.LOG,

8642: ELSIF r_vat_regime_tax_type.tax_type IS NOT NULL THEN
8643: --p_rematch = 'PO_MATCHING' then
8644:
8645: v_dist_code_combination_id := for_dist_insertion_rec.dist_code_combination_id;
8646: fnd_file.put_line(FND_FILE.LOG,
8647: ' Regime type , CCID '
8648: || r_vat_regime_tax_type.tax_type
8649: ||', ' || v_dist_code_combination_id);
8650:

Line 8705: 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);

8701: END IF;--( NVL(i.inc_tax_flag,'N') = 'N' OR ( NVL(i.inc_tax_flag,'N'))
8702: -------------------------------------------------------------------------------------
8703: --added by Eric for inclusive tax on 20-dec-2007,end
8704:
8705: 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);
8706:
8707: if i.modvat_flag = jai_constants.YES
8708: and nvl(c_tax_rec.mod_cr_percentage, -1) > 0
8709: and nvl(c_tax_rec.mod_cr_percentage, -1) < 100

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

8720:
8721: lv_tax_type := 'PR'; --changed by eric for inclusive tax on Jan 4,2008
8722: end if;
8723:
8724: fnd_file.put_line(fnd_file.log, 'ln_lines_to_insert='||ln_lines_to_insert||
8725: ',ln_rec_tax_amt='||ln_rec_tax_amt ||
8726: ',ln_nrec_tax_amt='||ln_nrec_tax_amt
8727: );
8728:

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

8921: END IF;
8922: --ELSIF ( lv_tax_type <> 'PR' AND p_project_id IS NULL )
8923: --THEN
8924: ELSE -- eric removed the above criteria for bug 6888665 and 6888209
8925: Fnd_File.put_line(Fnd_File.LOG, 'NOT Inclusive PR Tax,NOT Inclusive RE for project ');
8926: --The case process the inclusive NR tax and inclusive RE tax not for project
8927:
8928: lv_tax_line_amount := v_tax_amount ; --added by eric for inclusive tax
8929: lv_modvat_flag := i.modvat_flag ;

Line 8939: Fnd_File.put_line(Fnd_File.LOG,

8935: -------------------------------------------------------------------------------------------
8936: --added by Eric for inclusive tax on 20-dec-2007,end
8937:
8938:
8939: Fnd_File.put_line(Fnd_File.LOG,
8940: 'Before inserting into ap_invoice_lines_all for line no :' || ln_inv_line_num );
8941:
8942: --insert exclusive tax to the ap tables
8943: --or insert recoverable inclusive tax with project information the ap tables

Line 9028: Fnd_File.put_line(Fnd_File.LOG,

9024: /* End 5763527 */
9025: ,po_dist_id --Added for bug#6780154
9026: );
9027:
9028: Fnd_File.put_line(Fnd_File.LOG,
9029: 'Before inserting into ap_invoice_distributions_all for distribution line no :'
9030: || v_distribution_no);
9031:
9032: -- Start bug#3332988

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

9033: open c_get_invoice_distribution;
9034: fetch c_get_invoice_distribution into v_invoice_distribution_id;
9035: close c_get_invoice_distribution;
9036: -- End bug#3332988
9037: fnd_file.put_line(FND_FILE.LOG, ' Invoice distribution id '|| v_invoice_distribution_id);
9038:
9039: INSERT INTO ap_invoice_distributions_all
9040: (
9041: accounting_date,

Line 9157: Fnd_File.put_line(Fnd_File.LOG,

9153: -----------------------------------------------------------------
9154: --added by Eric for inclusive tax on 20-dec-2007,end
9155:
9156:
9157: Fnd_File.put_line(Fnd_File.LOG,
9158: 'Before inserting into JAI_AP_MATCH_INV_TAXES tax id ' || i.tax_id );
9159: --added by Eric for inclusive tax on 20-dec-2007,begin
9160: -----------------------------------------------------------------
9161: IF (NVL(lv_tax_line_to_inst_flag,'N') = 'Y')

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

9272:
9273: v_statement_no := '50';
9274:
9275: /* Obsoleted as part of R12 , Bug# 4445989
9276: Fnd_File.put_line(Fnd_File.LOG, 'Before inserting into JAI_CMN_FA_INV_DIST_ALL');
9277: INSERT INTO JAI_CMN_FA_INV_DIST_ALL
9278: (
9279: invoice_id,
9280: invoice_distribution_id,

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

9368:
9369: EXCEPTION
9370: WHEN OTHERS THEN
9371: err_mesg := SQLERRM;
9372: Fnd_File.put_line(Fnd_File.LOG, 'SQLERRM -> '|| SQLERRM ||', SQLCODE -> '||SQLCODE);
9373: Fnd_File.put_line(Fnd_File.LOG, 'Statement -> '|| v_statement_no);
9374: RETURN;
9375: END process_batch_record;
9376:

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

9369: EXCEPTION
9370: WHEN OTHERS THEN
9371: err_mesg := SQLERRM;
9372: Fnd_File.put_line(Fnd_File.LOG, 'SQLERRM -> '|| SQLERRM ||', SQLCODE -> '||SQLCODE);
9373: Fnd_File.put_line(Fnd_File.LOG, 'Statement -> '|| v_statement_no);
9374: RETURN;
9375: END process_batch_record;
9376:
9377: END;