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_CMN_MTAX_PKG dependencies on FND_FILE

Line 163: fnd_file.put_line( fnd_file.log, 'Processing mass update for document type='|| r_doc_type.document_type);

159: where flxvsets.flex_value_set_id = flxvals.flex_value_set_id
160: and flxvsets.flex_value_set_name = 'JAINMTCH_PO_DOCUMENT_TYPES'
161: )
162: loop
163: fnd_file.put_line( fnd_file.log, 'Processing mass update for document type='|| r_doc_type.document_type);
164:
165: /* For each tax category where invoice mass tax flag is set, call mass tax changes procedure*/
166: for r_tax_cat in (select tax_category_id
167: from jai_cmn_taxctg_updates

Line 199: fnd_file.put_line( fnd_file.log, 'Mass update completed for document type='|| r_doc_type.document_type);

195: --,p_dbms_output => p_dbms_output
196: );
197: end loop; /* r_tax_cat */
198:
199: fnd_file.put_line( fnd_file.log, 'Mass update completed for document type='|| r_doc_type.document_type);
200:
201: end loop; /*r_doc_type*/
202:
203: end process_tax_cat_update;

Line 1186: However as dbms_out.put_line is not standards compliant hence was modified to fnd_file.put_line

1182: 2. Cannot insert null into JAI_CMN_MTAX_HDRS_ALL.
1183: Reason and Fix:-
1184: 1. As the concurrent program JAINMCTH does not have the parameter pv_dbms_output hence the reported error.
1185: This parameter was previously added to debug from backend with dbms_output.
1186: However as dbms_out.put_line is not standards compliant hence was modified to fnd_file.put_line
1187: Now as the parameter pv_debug is already present both in the concurrent program registration and the current procedure
1188: hence removed the pv_dbms_output from both spec and body and instead used the pv_debug for capturing the debug info.
1189: This can now be also enabled from conc program.
1190:

Line 1243: 115.3 hjujjuru 4245089 VAT Implelentationfnd_file.put_line(fnd_file.log,

1239: Version Author Dependencies Comments
1240: 115.2 LGOPALSA IN60106 + Added Cess tax code
1241: 4146708
1242:
1243: 115.3 hjujjuru 4245089 VAT Implelentationfnd_file.put_line(fnd_file.log,
1244: 120.3 Aiyer R12 JAI A Changed for bug 4565665. Spec and body change in jai_cmn_mtax_pkg
1245: --------------------------------------------------------------------------------------------------------------------------*/
1246:
1247: -- Add code by Xiao to get release version on 24-Jul-2009

Line 1283: fnd_file.put_line(fnd_file.log, 'Operating unit ln_org_id is -> '||ln_org_id ||','|| p_from_date||','||p_to_date );

1279: || Added by aiyer for the bug 5490479
1280: || Get the operating unit (org_id)
1281: */
1282: ln_org_id := mo_global.get_current_org_id;
1283: fnd_file.put_line(fnd_file.log, 'Operating unit ln_org_id is -> '||ln_org_id ||','|| p_from_date||','||p_to_date );
1284: /*End of bug 5490479 */
1285:
1286: /* Ramananda for File.Sql.35 */
1287:

Line 1310: || and called fnd_file.put_line to register the info

1306:
1307: /*
1308: || Start of bug 4517919
1309: ||Opened the existing cursor to get the database name
1310: || and called fnd_file.put_line to register the info
1311: || also changed the dbms_support.start and stop trace to execute immediate alter session code
1312: */
1313: OPEN get_audsid;
1314: FETCH get_audsid INTO v_sid, v_serial, v_spid;

Line 1321: FND_FILE.PUT_LINE( FND_FILE.log, 'TraceFile Name = '||lower(v_name1)||'_ora_'||v_spid||'.trc');

1317: OPEN get_dbname;
1318: FETCH get_dbname INTO v_name1;
1319: CLOSE get_dbname;
1320:
1321: FND_FILE.PUT_LINE( FND_FILE.log, 'TraceFile Name = '||lower(v_name1)||'_ora_'||v_spid||'.trc');
1322:
1323: EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ''10046 trace name context forever, level 4''';
1324:
1325: /*

Line 1361: fnd_file.put_line(fnd_file.log,'Input Parameters1. ln_org_id -> '|| ln_org_id||

1357:
1358: END IF;
1359:
1360: IF v_debug THEN
1361: fnd_file.put_line(fnd_file.log,'Input Parameters1. ln_org_id -> '|| ln_org_id||
1362: ', p_document_type -> '||p_document_type || ', p_from_date -> '||p_from_date || ', p_to_date -> '||p_to_date ||
1363: ', p_supplier_id -> '||p_supplier_id || ', p_supplier_site_id -> '||p_supplier_site_id ||
1364: ', p_customer_id -> '||p_customer_id || ', p_customer_site_id -> '||p_customer_site_id ||
1365: ', p_old_tax_category -> '||p_old_tax_category || ', p_new_tax_category -> '||p_new_tax_category

Line 1367: fnd_file.put_line(fnd_file.log,', p_document_no -> '||p_document_no || ', p_release_no -> '||p_release_no ||

1363: ', p_supplier_id -> '||p_supplier_id || ', p_supplier_site_id -> '||p_supplier_site_id ||
1364: ', p_customer_id -> '||p_customer_id || ', p_customer_site_id -> '||p_customer_site_id ||
1365: ', p_old_tax_category -> '||p_old_tax_category || ', p_new_tax_category -> '||p_new_tax_category
1366: );
1367: fnd_file.put_line(fnd_file.log,', p_document_no -> '||p_document_no || ', p_release_no -> '||p_release_no ||
1368: ', p_document_line_no -> '||p_document_line_no || ', p_shipment_no -> '||p_shipment_no ||
1369: ', p_commit_interval -> '||p_commit_interval || ', p_override_manual_taxes -> '||p_override_manual_taxes ||
1370: ', p_process_partial -> '||p_process_partial
1371: );

Line 1446: fnd_file.put_line( fnd_file.log, 'Batch ID -> '|| v_batch_id );

1442:
1443: COMMIT;
1444:
1445: IF v_debug THEN
1446: fnd_file.put_line( fnd_file.log, 'Batch ID -> '|| v_batch_id );
1447: utl_file.put_line( v_myfilehandle, 'Batch ID -> '|| v_batch_id );
1448: END IF;
1449:
1450: IF v_debug THEN

Line 1451: fnd_file.put_line(fnd_file.log, 'Batch ID -> '|| v_batch_id );

1447: utl_file.put_line( v_myfilehandle, 'Batch ID -> '|| v_batch_id );
1448: END IF;
1449:
1450: IF v_debug THEN
1451: fnd_file.put_line(fnd_file.log, 'Batch ID -> '|| v_batch_id );
1452: END IF;
1453:
1454: --//~~~~~~~~~ Actual Code of Tax Recalculation starts from here ~~~~~~~~~//
1455:

Line 1784: fnd_file.put_line(fnd_file.log, 'Partilly received Shipment line cannot be processed. PO No. '||shipment_rec.document_no||

1780: );
1781: END IF;
1782:
1783: IF v_debug THEN
1784: fnd_file.put_line(fnd_file.log, 'Partilly received Shipment line cannot be processed. PO No. '||shipment_rec.document_no||
1785: ', PO header id -> '||shipment_rec.po_header_id||
1786: ', line id -> '|| shipment_rec.po_line_id||
1787: ', line location id -> '|| v_line_location_id||
1788: ', line focus id -> '|| shipment_rec.line_focus_id||

Line 1897: fnd_file.put_line(fnd_file.log, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('

1893: );
1894: END IF;
1895:
1896: IF v_debug THEN
1897: fnd_file.put_line(fnd_file.log, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('
1898: ||shipment_rec.ship_to_organization_id ||', '||shipment_rec.vendor_id
1899: ||', '||shipment_rec.vendor_site_id ||', '|| shipment_rec.item_id ||', '||shipment_rec.po_header_id
1900: ||', '||shipment_rec.po_line_id ||', '||v_dflt_tax_category_id||' );'
1901: );

Line 1917: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);

1913: IF v_debug THEN
1914: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
1915: END IF;
1916: IF v_debug THEN
1917: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
1918: END IF;
1919:
1920: IF v_dflt_tax_category_id IS NOT NULL THEN
1921:

Line 1967: fnd_file.put_line(fnd_file.log,'v_success -> '||v_success||', v_message -> '||v_message);

1963: IF v_debug THEN
1964: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
1965: END IF;
1966: IF v_debug THEN
1967: fnd_file.put_line(fnd_file.log,'v_success -> '||v_success||', v_message -> '||v_message);
1968: END IF;
1969:
1970: IF v_success IN (1, 3, 5) THEN
1971:

Line 2005: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1

2001: END IF;
2002:
2003: IF v_debug THEN
2004: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
2005: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1
2006: ||', tax_rec.p_2 -> '||tax_rec.p_2||', tax_rec.p_3 -> '||tax_rec.p_3
2007: ||', tax_rec.p_4 -> '||tax_rec.p_4||', tax_rec.p_5 -> '||tax_rec.p_5
2008: ||', tax_rec.p_6 -> '||tax_rec.p_6||', tax_rec.p_7 -> '||tax_rec.p_7
2009: ||', tax_rec.p_8 -> '||tax_rec.p_8||', tax_rec.p_9 -> '||tax_rec.p_9

Line 2193: fnd_file.put_line(fnd_file.log, 'No Tax Changes for Order No. '||shipment_rec.document_no||', -> '|| shipment_rec.po_line_id||

2189: ', Message -> '||v_message
2190: );
2191: END IF;
2192: IF v_debug THEN
2193: fnd_file.put_line(fnd_file.log, 'No Tax Changes for Order No. '||shipment_rec.document_no||', -> '|| shipment_rec.po_line_id||
2194: ', PO hdr_id -> '||shipment_rec.po_header_id||
2195: ', line_id -> '|| shipment_rec.po_line_id||', shipment_id -> '|| v_line_location_id ||
2196: ', vendor_id -> '||shipment_rec.vendor_id||
2197: ', vendor_site_id -> '||shipment_rec.vendor_site_id ||

Line 2225: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id is null for : Order No. '||shipment_rec.document_no||', -> '|| shipment_rec.po_line_id||

2221: ', vendor_site_id -> '||shipment_rec.vendor_site_id
2222: );
2223: END IF;
2224: IF v_debug THEN
2225: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id is null for : Order No. '||shipment_rec.document_no||', -> '|| shipment_rec.po_line_id||
2226: ', PO hdr_id -> '||shipment_rec.po_header_id||
2227: ', line_id -> '|| shipment_rec.po_line_id||', shipment_id -> '|| v_line_location_id ||
2228: ', vendor_id -> '||shipment_rec.vendor_id||
2229: ', vendor_site_id -> '||shipment_rec.vendor_site_id

Line 2250: fnd_file.put_line(fnd_file.log,'ROLLBACK to point1, error ->'||SQLERRM );

2246: WHEN OTHERS THEN
2247: ROLLBACK TO point1;
2248:
2249: IF v_debug THEN
2250: fnd_file.put_line(fnd_file.log,'ROLLBACK to point1, error ->'||SQLERRM );
2251: END IF;
2252:
2253: IF v_message IS NULL THEN
2254: v_message := 'Dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;

Line 2370: fnd_file.put_line(fnd_file.log, 'Partilly received Shipment line cannot be processed. PO No. '||releases_rec.document_no||

2366: ', quantity_received -> '||releases_rec.quantity_received
2367: );
2368: END IF;
2369: IF v_debug THEN
2370: fnd_file.put_line(fnd_file.log, 'Partilly received Shipment line cannot be processed. PO No. '||releases_rec.document_no||
2371: ', PO header id -> '||releases_rec.po_header_id||
2372: ', line id -> '|| releases_rec.po_line_id||
2373: ', line location id -> '|| releases_rec.line_location_id||
2374: ', line focus id -> '|| releases_rec.line_focus_id||

Line 2487: fnd_file.put_line(fnd_file.log, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('

2483: ||', '||releases_rec.po_line_id ||', '||v_dflt_tax_category_id||' );'
2484: );
2485: END IF;
2486: IF v_debug THEN
2487: fnd_file.put_line(fnd_file.log, 'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('
2488: ||v_organization_id ||', '||releases_rec.vendor_id
2489: ||', '||releases_rec.vendor_site_id ||', '|| releases_rec.item_id ||', '||releases_rec.po_header_id
2490: ||', '||releases_rec.po_line_id ||', '||v_dflt_tax_category_id||' );'
2491: );

Line 2507: fnd_file.put_line(fnd_file.log, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id );

2503: IF v_debug THEN
2504: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
2505: END IF;
2506: IF v_debug THEN
2507: fnd_file.put_line(fnd_file.log, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id );
2508: END IF;
2509:
2510: IF v_dflt_tax_category_id IS NOT NULL THEN
2511:

Line 2555: fnd_file.put_line(fnd_file.log, 'v_success -> '||v_success||', v_message -> '||v_message);

2551: IF v_debug THEN
2552: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
2553: END IF;
2554: IF v_debug THEN
2555: fnd_file.put_line(fnd_file.log, 'v_success -> '||v_success||', v_message -> '||v_message);
2556: END IF;
2557:
2558: IF v_success IN (1, 3, 5) THEN
2559:

Line 2594: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1

2590: END IF;
2591:
2592: IF v_debug THEN
2593: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
2594: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1
2595: ||', tax_rec.p_2 -> '||tax_rec.p_2||', tax_rec.p_3 -> '||tax_rec.p_3
2596: ||', tax_rec.p_4 -> '||tax_rec.p_4||', tax_rec.p_5 -> '||tax_rec.p_5
2597: ||', tax_rec.p_6 -> '||tax_rec.p_6||', tax_rec.p_7 -> '||tax_rec.p_7
2598: ||', tax_rec.p_8 -> '||tax_rec.p_8||', tax_rec.p_9 -> '||tax_rec.p_9

Line 2781: fnd_file.put_line(fnd_file.log, 'No Tax Changes for Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||

2777: ', Message -> '||v_message
2778: );
2779: END IF;
2780: IF v_debug THEN
2781: fnd_file.put_line(fnd_file.log, 'No Tax Changes for Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||
2782: ', PO hdr_id -> '||releases_rec.po_header_id||
2783: ', line_id -> '|| releases_rec.po_line_id||', shipment_id -> '|| releases_rec.line_location_id ||
2784: ', vendor_id -> '||releases_rec.vendor_id||
2785: ', vendor_site_id -> '||releases_rec.vendor_site_id ||

Line 2812: fnd_file.put_line(fnd_file.log, 'Default tax_category_id IS Null - Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||

2808: ', vendor_site_id -> '||releases_rec.vendor_site_id
2809: );
2810: END IF;
2811: IF v_debug THEN
2812: fnd_file.put_line(fnd_file.log, 'Default tax_category_id IS Null - Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||
2813: ', PO hdr_id -> '||releases_rec.po_header_id||
2814: ', line_id -> '|| releases_rec.po_line_id||', shipment_id -> '|| releases_rec.line_location_id ||
2815: ', vendor_id -> '||releases_rec.vendor_id||
2816: ', vendor_site_id -> '||releases_rec.vendor_site_id

Line 2837: fnd_file.put_line(fnd_file.log,'Rollback to point2, error -> '||SQLERRM);

2833: WHEN OTHERS THEN
2834: ROLLBACK TO point2;
2835:
2836: IF v_debug THEN
2837: fnd_file.put_line(fnd_file.log,'Rollback to point2, error -> '||SQLERRM);
2838: END IF;
2839:
2840: IF v_message IS NULL THEN
2841: v_message := 'Dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;

Line 2953: fnd_file.put_line(fnd_file.log, 'For loop 4' );

2949: IF v_debug THEN
2950: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 4');
2951: END IF;
2952: IF v_debug THEN
2953: fnd_file.put_line(fnd_file.log, 'For loop 4' );
2954: END IF;
2955:
2956: -- There wont be any partial receipts in this case, so No partial Case
2957:

Line 3070: fnd_file.put_line(fnd_file.log,'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('

3066: ||', '||reqn_rec.requisition_line_id ||', '||v_dflt_tax_category_id||' );'
3067: );
3068: END IF;
3069: IF v_debug THEN
3070: fnd_file.put_line(fnd_file.log,'jai_cmn_tax_defaultation_pkg.ja_in_vendor_default_taxes('
3071: ||v_organization_id ||', '||v_vendor_id
3072: ||', '||v_vendor_site_id ||', '|| reqn_rec.item_id ||', '||reqn_rec.requisition_header_id
3073: ||', '||reqn_rec.requisition_line_id ||', '||v_dflt_tax_category_id||' );'
3074: );

Line 3098: fnd_file.put_line(fnd_file.log, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);

3094: IF v_debug THEN
3095: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
3096: END IF;
3097: IF v_debug THEN
3098: fnd_file.put_line(fnd_file.log, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
3099: END IF;
3100:
3101:
3102: IF v_dflt_tax_category_id IS NOT NULL THEN

Line 3148: fnd_file.put_line(fnd_file.log,'v_success -> '||v_success||', v_message -> '||v_message);

3144: IF v_debug THEN
3145: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
3146: END IF;
3147: IF v_debug THEN
3148: fnd_file.put_line(fnd_file.log,'v_success -> '||v_success||', v_message -> '||v_message);
3149: END IF;
3150:
3151:
3152: IF v_success IN (1, 3, 5) THEN

Line 3192: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1

3188: END IF;
3189:
3190: IF v_debug THEN
3191: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
3192: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1
3193: ||', tax_rec.p_2 -> '||tax_rec.p_2||', tax_rec.p_3 -> '||tax_rec.p_3
3194: ||', tax_rec.p_4 -> '||tax_rec.p_4||', tax_rec.p_5 -> '||tax_rec.p_5
3195: ||', tax_rec.p_6 -> '||tax_rec.p_6||', tax_rec.p_7 -> '||tax_rec.p_7
3196: ||', tax_rec.p_8 -> '||tax_rec.p_8||', tax_rec.p_9 -> '||tax_rec.p_9

Line 3363: fnd_file.put_line(fnd_file.log,'No Tax Changes for Requisition No. '||reqn_rec.document_no||

3359: ', Message -> '||v_message
3360: );
3361: END IF;
3362: IF v_debug THEN
3363: fnd_file.put_line(fnd_file.log,'No Tax Changes for Requisition No. '||reqn_rec.document_no||
3364: ', PO hdr_id -> '||reqn_rec.requisition_header_id||
3365: ', line_id -> '|| reqn_rec.requisition_line_id||
3366: ', vendor_id -> '||v_vendor_id||
3367: ', vendor_site_id -> '||v_vendor_site_id ||

Line 3394: fnd_file.put_line(fnd_file.log,'Default tax_category_id IS Null - Requisition No. '||reqn_rec.document_no||

3390: ', vendor_site_id -> '||v_vendor_site_id
3391: );
3392: END IF;
3393: IF v_debug THEN
3394: fnd_file.put_line(fnd_file.log,'Default tax_category_id IS Null - Requisition No. '||reqn_rec.document_no||
3395: ', PO hdr_id -> '||reqn_rec.requisition_header_id||
3396: ', line_id -> '|| reqn_rec.requisition_line_id||
3397: ', vendor_id -> '||v_vendor_id||
3398: ', vendor_site_id -> '||v_vendor_site_id

Line 3419: fnd_file.put_line(fnd_file.log,'Rollback to POINT3, error -> '|| SQLERRM);

3415: WHEN OTHERS THEN
3416: ROLLBACK TO point3;
3417:
3418: IF v_debug THEN
3419: fnd_file.put_line(fnd_file.log,'Rollback to POINT3, error -> '|| SQLERRM);
3420: END IF;
3421:
3422: IF v_message IS NULL THEN
3423: v_message := 'Dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;

Line 3434: fnd_file.put_line(fnd_file.log,'Ex. Record Not found so inserting record');

3430:
3431: -- as advised by APARAJITA
3432: IF SQL%NOTFOUND THEN
3433: IF v_debug THEN
3434: fnd_file.put_line(fnd_file.log,'Ex. Record Not found so inserting record');
3435: END IF;
3436:
3437: INSERT INTO JAI_CMN_MTAX_UPD_DTLS (
3438: mtax_dtl_id,

Line 3526: fnd_file.put_line(fnd_file.log,'For loop3' );

3522: IF v_debug THEN
3523: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 3');
3524: END IF;
3525: IF v_debug THEN
3526: fnd_file.put_line(fnd_file.log,'For loop3' );
3527: END IF;
3528:
3529: -- v_qty_remaining := so_rec.ordered_quantity - so_rec.shipped_quantity ;
3530: -- check for Partially shipped or not. if partial then skip SO line processing

Line 3541: fnd_file.put_line(fnd_file.log,'Partilly shipped Order cannot be processed. Order No. '||so_rec.order_number||

3537: ', ordered_quantity -> '||so_rec.ordered_quantity||
3538: ', shipped_quantity -> '||so_rec.shipped_quantity
3539: );
3540: IF v_debug THEN
3541: fnd_file.put_line(fnd_file.log,'Partilly shipped Order cannot be processed. Order No. '||so_rec.order_number||
3542: ', SO hdr_id -> '||so_rec.header_id||
3543: ', line_id -> '|| so_rec.line_id||
3544: ', ordered_quantity -> '||so_rec.ordered_quantity||
3545: ', shipped_quantity -> '||so_rec.shipped_quantity

Line 3625: fnd_file.put_line(fnd_file.log,'jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes('

3621: );
3622:
3623: END IF;
3624: IF v_debug THEN
3625: fnd_file.put_line(fnd_file.log,'jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes('
3626: ||v_organization_id ||', '||so_rec.customer_id
3627: ||', '||so_rec.ship_to_org_id ||', '||so_rec.inventory_item_id ||', '||so_rec.header_id
3628: ||', '||so_rec.line_id ||', '||v_dflt_tax_category_id||', '||so_rec.tax_category_id||' ); '
3629: );

Line 3640: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);

3636: /*End Changes for Bug 11739957*/
3637: ELSE
3638: v_dflt_tax_category_id := p_new_tax_category;
3639: END IF;
3640: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
3641:
3642: IF v_dflt_tax_category_id IS NULL THEN
3643: jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes( v_organization_id, so_rec.customer_id, so_rec.ship_to_org_id,
3644: so_rec.inventory_item_id, so_rec.header_id, so_rec.line_id, v_dflt_tax_category_id);

Line 3652: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);

3648: IF v_debug THEN
3649: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
3650: END IF;
3651: IF v_debug THEN
3652: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
3653: END IF;
3654:
3655: IF v_dflt_tax_category_id IS NOT NULL THEN
3656:

Line 3697: fnd_file.put_line(fnd_file.log, 'v_success -> '||v_success||', v_message -> '||v_message);

3693: IF v_debug THEN
3694: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
3695: END IF;
3696: IF v_debug THEN
3697: fnd_file.put_line(fnd_file.log, 'v_success -> '||v_success||', v_message -> '||v_message);
3698: END IF;
3699:
3700:
3701: IF v_success IN (1, 3, 5) THEN

Line 3710: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1

3706: j := j + 1;
3707:
3708: IF v_debug THEN
3709: -- Date 31/10/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )
3710: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1
3711: ||', tax_rec.p_2 -> '||tax_rec.p_2||', tax_rec.p_3 -> '||tax_rec.p_3
3712: ||', tax_rec.p_4 -> '||tax_rec.p_4||', tax_rec.p_5 -> '||tax_rec.p_5
3713: ||', tax_rec.p_6 -> '||tax_rec.p_6||', tax_rec.p_7 -> '||tax_rec.p_7
3714: ||', tax_rec.p_8 -> '||tax_rec.p_8||', tax_rec.p_9 -> '||tax_rec.p_9

Line 3786: fnd_file.put_line(fnd_file.log, ' v_converted_rate -> '||v_converted_rate);

3782: v_converted_rate := jai_cmn_utils_pkg.currency_conversion (v_sob_id , so_rec.currency_code,
3783: v_date_ordered , so_rec.conversion_type_code, so_rec.conversion_rate);
3784:
3785: IF v_debug THEN
3786: fnd_file.put_line(fnd_file.log, ' v_converted_rate -> '||v_converted_rate);
3787: END IF;
3788:
3789: OPEN c_address(so_rec.ship_to_org_id);
3790: FETCH c_address INTO v_address_id;

Line 3794: fnd_file.put_line(fnd_file.log, ' v_address_id -> '||v_address_id

3790: FETCH c_address INTO v_address_id;
3791: CLOSE c_address;
3792:
3793: IF v_debug THEN
3794: fnd_file.put_line(fnd_file.log, ' v_address_id -> '||v_address_id
3795: || ', customer_id -> '|| so_rec.customer_id
3796: || ', inventory_item_id -> '|| so_rec.inventory_item_id
3797: || ', order_quantity_uom -> '|| so_rec.order_quantity_uom
3798: || ', v_date_ordered -> '|| v_date_ordered

Line 3833: fnd_file.put_line(fnd_file.log, ' 1 v_assessable_value -> '|| nvl(v_assessable_value,-1) );

3829: FETCH c_get_assessable_value INTO v_assessable_value; --, v_price_list_uom_code;
3830: CLOSE c_get_assessable_value;
3831:
3832: IF v_debug THEN
3833: fnd_file.put_line(fnd_file.log, ' 1 v_assessable_value -> '|| nvl(v_assessable_value,-1) );
3834: END IF;
3835: -- Added by Xiao for Advanced Pricing on 10-Jun-2009, begin
3836: --------------------------------------------------------------------------
3837: -- Add condition by Xiao for specific release version for Advanced Pricing code on 24-Jul-2009

Line 3854: fnd_file.put_line(fnd_file.log, ' 1.1 item category v_assessable_value -> '|| nvl(v_assessable_value,-1) );

3850: CLOSE cust_ass_value_category_cur;
3851: END IF; -- v_assessable_value is null for given customer/site/inventory_item_id/UOM
3852:
3853: IF v_debug THEN
3854: fnd_file.put_line(fnd_file.log, ' 1.1 item category v_assessable_value -> '|| nvl(v_assessable_value,-1) );
3855: END IF;
3856:
3857: END IF; -- lv_release_name NOT LIKE '12.0%'
3858: ------------------------------------------------------------------------

Line 3869: fnd_file.put_line(fnd_file.log, ' 2 v_assessable_value -> '||v_assessable_value);

3865: CLOSE c_get_assessable_value;
3866: END IF;
3867:
3868: IF v_debug THEN
3869: fnd_file.put_line(fnd_file.log, ' 2 v_assessable_value -> '||v_assessable_value);
3870: END IF;
3871:
3872: -- Added by Xiao for Advanced Pricing on 10-Jun-2009, begin
3873: ----------------------------------------------------------------------------------

Line 3892: fnd_file.put_line(fnd_file.log, ' 2.1 item category v_assessable_value -> '|| nvl(v_assessable_value,-1) );

3888: CLOSE cust_ass_value_category_cur;
3889: END IF; -- v_assessable_value is null for given customer/null site/inventory_item_id/UOM
3890:
3891: IF v_debug THEN
3892: fnd_file.put_line(fnd_file.log, ' 2.1 item category v_assessable_value -> '|| nvl(v_assessable_value,-1) );
3893: END IF;
3894:
3895: END IF; -- lv_release_name NOT LIKE '12.0%'
3896: --------------------------------------------------------------------------------

Line 3942: fnd_file.put_line(fnd_file.log, ' ln_vat_assess_value -> '||ln_vat_assess_value);

3938: ) ;
3939:
3940:
3941: IF v_debug THEN
3942: fnd_file.put_line(fnd_file.log, ' ln_vat_assess_value -> '||ln_vat_assess_value);
3943: END IF;
3944:
3945: ln_vat_assess_amount := ln_vat_assess_value * so_rec.ordered_quantity;
3946: --ended, Harshita for bug #4245062

Line 3963: fnd_file.put_line(fnd_file.log, ' ln_gst_assess_value -> '||ln_gst_assess_value);

3959: p_party_type => 'C'
3960: );
3961:
3962: IF v_debug THEN
3963: fnd_file.put_line(fnd_file.log, ' ln_gst_assess_value -> '||ln_gst_assess_value);
3964: END IF;
3965: ln_gst_assess_amount := ln_gst_assess_value * so_rec.ordered_quantity;
3966: ---------------------------------------------------
3967: --Added by zhiwei for bug10043656 GST enhancement 2010/09/14 end

Line 3987: fnd_file.put_line(fnd_file.log, ' line tax = ' || v_line_tax_amount||

3983: UTL_FILE.PUT_LINE(v_myfilehandle ,' line tax = ' || v_line_tax_amount );
3984: UTL_FILE.PUT_LINE(v_myfilehandle, '33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );
3985: END IF;
3986: IF v_debug THEN
3987: fnd_file.put_line(fnd_file.log, ' line tax = ' || v_line_tax_amount||
3988: ', 33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );
3989: END IF;
3990:
3991:

Line 4023: fnd_file.put_line(fnd_file.log, 'No Tax Changes for Order No. '||so_rec.order_number||

4019: ', Message -> '||v_message
4020: );
4021: END IF;
4022: IF v_debug THEN
4023: fnd_file.put_line(fnd_file.log, 'No Tax Changes for Order No. '||so_rec.order_number||
4024: ', SO hdr_id -> '||so_rec.header_id||
4025: ', line_id -> '|| so_rec.line_id||
4026: ', customer_id -> '||so_rec.customer_id||
4027: ', site_use_id -> '||so_rec.ship_to_org_id ||

Line 4055: fnd_file.put_line(fnd_file.log,'Default tax_category_id IS Null - Sales Order No. '||so_rec.order_number||

4051: ', Message -> '||v_message
4052: );
4053: END IF;
4054: IF v_debug THEN
4055: fnd_file.put_line(fnd_file.log,'Default tax_category_id IS Null - Sales Order No. '||so_rec.order_number||
4056: ', SO hdr_id -> '||so_rec.header_id||
4057: ', line_id -> '|| so_rec.line_id||
4058: ', customer_id -> '||so_rec.customer_id||
4059: ', site_use_id -> '||so_rec.ship_to_org_id ||

Line 4080: fnd_file.put_line(fnd_file.log,'ROLLBACK to point4, error -> '|| SQLERRM);

4076: WHEN OTHERS THEN
4077: ROLLBACK TO point4;
4078:
4079: IF v_debug THEN
4080: fnd_file.put_line(fnd_file.log,'ROLLBACK to point4, error -> '|| SQLERRM);
4081: END IF;
4082:
4083: IF v_message IS NULL THEN
4084: v_message := 'Dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;

Line 4181: /*fnd_file.put_line(fnd_file.log,'HOUZW POS0-> v_org_id: '|| v_org_id);

4177: ---------------------------------
4178:
4179: elsIF v_shipment_type IN ( 'BOE' ) THEN
4180:
4181: /*fnd_file.put_line(fnd_file.log,'HOUZW POS0-> v_org_id: '|| v_org_id);
4182: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_from_date: '|| p_from_date);
4183: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_to_date: '|| p_to_date);
4184: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_id: '|| p_customer_id);
4185: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_site_id: '|| p_customer_site_id);

Line 4182: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_from_date: '|| p_from_date);

4178:
4179: elsIF v_shipment_type IN ( 'BOE' ) THEN
4180:
4181: /*fnd_file.put_line(fnd_file.log,'HOUZW POS0-> v_org_id: '|| v_org_id);
4182: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_from_date: '|| p_from_date);
4183: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_to_date: '|| p_to_date);
4184: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_id: '|| p_customer_id);
4185: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_site_id: '|| p_customer_site_id);
4186: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_old_tax_category: '|| p_old_tax_category);

Line 4183: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_to_date: '|| p_to_date);

4179: elsIF v_shipment_type IN ( 'BOE' ) THEN
4180:
4181: /*fnd_file.put_line(fnd_file.log,'HOUZW POS0-> v_org_id: '|| v_org_id);
4182: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_from_date: '|| p_from_date);
4183: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_to_date: '|| p_to_date);
4184: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_id: '|| p_customer_id);
4185: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_site_id: '|| p_customer_site_id);
4186: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_old_tax_category: '|| p_old_tax_category);
4187: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_document_no: '|| p_document_no);

Line 4184: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_id: '|| p_customer_id);

4180:
4181: /*fnd_file.put_line(fnd_file.log,'HOUZW POS0-> v_org_id: '|| v_org_id);
4182: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_from_date: '|| p_from_date);
4183: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_to_date: '|| p_to_date);
4184: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_id: '|| p_customer_id);
4185: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_site_id: '|| p_customer_site_id);
4186: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_old_tax_category: '|| p_old_tax_category);
4187: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_document_no: '|| p_document_no);
4188: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_document_line_no: '|| p_document_line_no);*/

Line 4185: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_site_id: '|| p_customer_site_id);

4181: /*fnd_file.put_line(fnd_file.log,'HOUZW POS0-> v_org_id: '|| v_org_id);
4182: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_from_date: '|| p_from_date);
4183: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_to_date: '|| p_to_date);
4184: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_id: '|| p_customer_id);
4185: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_site_id: '|| p_customer_site_id);
4186: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_old_tax_category: '|| p_old_tax_category);
4187: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_document_no: '|| p_document_no);
4188: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_document_line_no: '|| p_document_line_no);*/
4189:

Line 4186: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_old_tax_category: '|| p_old_tax_category);

4182: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_from_date: '|| p_from_date);
4183: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_to_date: '|| p_to_date);
4184: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_id: '|| p_customer_id);
4185: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_site_id: '|| p_customer_site_id);
4186: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_old_tax_category: '|| p_old_tax_category);
4187: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_document_no: '|| p_document_no);
4188: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_document_line_no: '|| p_document_line_no);*/
4189:
4190:

Line 4187: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_document_no: '|| p_document_no);

4183: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_to_date: '|| p_to_date);
4184: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_id: '|| p_customer_id);
4185: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_site_id: '|| p_customer_site_id);
4186: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_old_tax_category: '|| p_old_tax_category);
4187: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_document_no: '|| p_document_no);
4188: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_document_line_no: '|| p_document_line_no);*/
4189:
4190:
4191: FOR boe_rec IN c_main_boe( v_org_id, trunc(p_from_date), trunc(p_to_date),

Line 4188: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_document_line_no: '|| p_document_line_no);*/

4184: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_id: '|| p_customer_id);
4185: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_customer_site_id: '|| p_customer_site_id);
4186: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_old_tax_category: '|| p_old_tax_category);
4187: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_document_no: '|| p_document_no);
4188: fnd_file.put_line(fnd_file.log,'HOUZW POS0-> p_document_line_no: '|| p_document_line_no);*/
4189:
4190:
4191: FOR boe_rec IN c_main_boe( v_org_id, trunc(p_from_date), trunc(p_to_date),
4192: p_customer_id, p_customer_site_id, p_old_tax_category,

Line 4201: fnd_file.put_line(fnd_file.log,'For loop3' );

4197: IF v_debug THEN
4198: UTL_FILE.PUT_LINE(v_myfilehandle, 'Forloop 3');
4199: END IF;
4200: IF v_debug THEN
4201: fnd_file.put_line(fnd_file.log,'For loop3' );
4202: END IF;
4203:
4204: -- ENTRY INTO Request Details table that contains the shipment records processed during Mass Tax Changes
4205: -- If any error occurs while processing the record, the error_reason column is updated with corresponding error message

Line 4279: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);

4275: IF v_debug THEN
4276: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
4277: END IF;
4278: IF v_debug THEN
4279: fnd_file.put_line(fnd_file.log,'v_dflt_tax_category_id -> ' ||v_dflt_tax_category_id);
4280: END IF;
4281:
4282: IF v_dflt_tax_category_id IS NOT NULL THEN
4283:

Line 4321: fnd_file.put_line(fnd_file.log, 'v_success -> '||v_success||', v_message -> '||v_message);

4317: IF v_debug THEN
4318: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_success -> '||v_success||', v_message -> '||v_message);
4319: END IF;
4320: IF v_debug THEN
4321: fnd_file.put_line(fnd_file.log, 'v_success -> '||v_success||', v_message -> '||v_message);
4322: END IF;
4323:
4324:
4325: IF v_success IN (1, 3, 5) THEN

Line 4333: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1

4329: FOR tax_rec IN c_tax_category_taxes(v_dflt_tax_category_id) LOOP
4330: j := j + 1;
4331:
4332: IF v_debug THEN
4333: fnd_file.put_line(fnd_file.log,'tax_id -> '||tax_rec.tax_id||', tax_rec.p_1 -> '||tax_rec.p_1
4334: ||', tax_rec.p_2 -> '||tax_rec.p_2||', tax_rec.p_3 -> '||tax_rec.p_3
4335: ||', tax_rec.p_4 -> '||tax_rec.p_4||', tax_rec.p_5 -> '||tax_rec.p_5
4336: ||', tax_rec.p_6 -> '||tax_rec.p_6||', tax_rec.p_7 -> '||tax_rec.p_7
4337: ||', tax_rec.p_8 -> '||tax_rec.p_8||', tax_rec.p_9 -> '||tax_rec.p_9

Line 4421: fnd_file.put_line(fnd_file.log, ' 2 v_assessable_value -> '||v_assessable_value);

4417: v_assessable_value := boe_rec.assessable_value; -- internal function call.
4418:
4419:
4420: IF v_debug THEN
4421: fnd_file.put_line(fnd_file.log, ' 2 v_assessable_value -> '||v_assessable_value);
4422: END IF;
4423:
4424:
4425: v_assessable_amount := v_assessable_value * boe_rec.applied_quantity;

Line 4429: /* fnd_file.put_line(fnd_file.log,'HOUZW POS11-> '|| v_assessable_amount);

4425: v_assessable_amount := v_assessable_value * boe_rec.applied_quantity;
4426:
4427:
4428:
4429: /* fnd_file.put_line(fnd_file.log,'HOUZW POS11-> '|| v_assessable_amount);
4430: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.assessable_value:'|| boe_rec.assessable_value);
4431: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> ln_boe_tax_amount'|| ln_boe_tax_amount);
4432: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.boe_quantity'|| boe_rec.boe_quantity);
4433: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.uom_code'|| boe_rec.uom_code);

Line 4430: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.assessable_value:'|| boe_rec.assessable_value);

4426:
4427:
4428:
4429: /* fnd_file.put_line(fnd_file.log,'HOUZW POS11-> '|| v_assessable_amount);
4430: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.assessable_value:'|| boe_rec.assessable_value);
4431: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> ln_boe_tax_amount'|| ln_boe_tax_amount);
4432: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.boe_quantity'|| boe_rec.boe_quantity);
4433: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.uom_code'|| boe_rec.uom_code);
4434: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.inventory_item_id'|| boe_rec.inventory_item_id);*/

Line 4431: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> ln_boe_tax_amount'|| ln_boe_tax_amount);

4427:
4428:
4429: /* fnd_file.put_line(fnd_file.log,'HOUZW POS11-> '|| v_assessable_amount);
4430: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.assessable_value:'|| boe_rec.assessable_value);
4431: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> ln_boe_tax_amount'|| ln_boe_tax_amount);
4432: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.boe_quantity'|| boe_rec.boe_quantity);
4433: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.uom_code'|| boe_rec.uom_code);
4434: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.inventory_item_id'|| boe_rec.inventory_item_id);*/
4435:

Line 4432: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.boe_quantity'|| boe_rec.boe_quantity);

4428:
4429: /* fnd_file.put_line(fnd_file.log,'HOUZW POS11-> '|| v_assessable_amount);
4430: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.assessable_value:'|| boe_rec.assessable_value);
4431: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> ln_boe_tax_amount'|| ln_boe_tax_amount);
4432: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.boe_quantity'|| boe_rec.boe_quantity);
4433: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.uom_code'|| boe_rec.uom_code);
4434: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.inventory_item_id'|| boe_rec.inventory_item_id);*/
4435:
4436:

Line 4433: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.uom_code'|| boe_rec.uom_code);

4429: /* fnd_file.put_line(fnd_file.log,'HOUZW POS11-> '|| v_assessable_amount);
4430: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.assessable_value:'|| boe_rec.assessable_value);
4431: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> ln_boe_tax_amount'|| ln_boe_tax_amount);
4432: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.boe_quantity'|| boe_rec.boe_quantity);
4433: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.uom_code'|| boe_rec.uom_code);
4434: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.inventory_item_id'|| boe_rec.inventory_item_id);*/
4435:
4436:
4437: v_line_tax_amount := v_line_amount;

Line 4434: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.inventory_item_id'|| boe_rec.inventory_item_id);*/

4430: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.assessable_value:'|| boe_rec.assessable_value);
4431: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> ln_boe_tax_amount'|| ln_boe_tax_amount);
4432: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.boe_quantity'|| boe_rec.boe_quantity);
4433: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.uom_code'|| boe_rec.uom_code);
4434: fnd_file.put_line(fnd_file.log,'HOUZW POS11-> boe_rec.inventory_item_id'|| boe_rec.inventory_item_id);*/
4435:
4436:
4437: v_line_tax_amount := v_line_amount;
4438: ln_boe_tax_amount := 0;

Line 4469: fnd_file.put_line(fnd_file.log, ' line tax = ' || v_line_tax_amount||

4465: UTL_FILE.PUT_LINE(v_myfilehandle ,' line tax = ' || v_line_tax_amount );
4466: UTL_FILE.PUT_LINE(v_myfilehandle, '33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );
4467: END IF;
4468: IF v_debug THEN
4469: fnd_file.put_line(fnd_file.log, ' line tax = ' || v_line_tax_amount||
4470: ', 33 assessable_value = '||v_assessable_value||', line tax_amount = '||v_line_tax_amount );
4471: END IF;
4472:
4473: DELETE FROM jai_boe_detail_taxes

Line 4580: fnd_file.put_line(fnd_file.log, 'No Tax Changes for BOE id. '||boe_rec.boe_id||

4576: ', Message -> '||v_message
4577: );
4578: END IF;
4579: IF v_debug THEN
4580: fnd_file.put_line(fnd_file.log, 'No Tax Changes for BOE id. '||boe_rec.boe_id||
4581: ', boe_detail_id -> '|| boe_rec.boe_detail_id||
4582: ', Message -> '||v_message
4583: );
4584: END IF;

Line 4605: fnd_file.put_line(fnd_file.log,'Default tax_category_id IS Null - BOE id. '||boe_rec.boe_id||

4601: ', Message -> '||v_message
4602: );
4603: END IF;
4604: IF v_debug THEN
4605: fnd_file.put_line(fnd_file.log,'Default tax_category_id IS Null - BOE id. '||boe_rec.boe_id||
4606: ', boe_detail_id -> '|| boe_rec.boe_detail_id||
4607: ', Message -> '||v_message
4608: );
4609: END IF;

Line 4613: fnd_file.put_line(fnd_file.log,'HOUZW commit?-> '|| 'n');

4609: END IF;
4610: END IF;
4611:
4612: IF v_commit_interval < p_commit_interval THEN
4613: fnd_file.put_line(fnd_file.log,'HOUZW commit?-> '|| 'n');
4614:
4615: v_commit_interval := v_commit_interval + 1;
4616: ELSE
4617: fnd_file.put_line(fnd_file.log,'HOUZW commit?-> '|| 'y');

Line 4617: fnd_file.put_line(fnd_file.log,'HOUZW commit?-> '|| 'y');

4613: fnd_file.put_line(fnd_file.log,'HOUZW commit?-> '|| 'n');
4614:
4615: v_commit_interval := v_commit_interval + 1;
4616: ELSE
4617: fnd_file.put_line(fnd_file.log,'HOUZW commit?-> '|| 'y');
4618:
4619: COMMIT;
4620: v_commit_interval := 0;
4621: END IF;

Line 4628: fnd_file.put_line(fnd_file.log,'HOUZW err-> '|| sqlerrm);

4624: null;
4625:
4626: EXCEPTION
4627: WHEN OTHERS THEN
4628: fnd_file.put_line(fnd_file.log,'HOUZW err-> '|| sqlerrm);
4629:
4630: ROLLBACK TO point5;
4631:
4632: IF v_debug THEN

Line 4633: fnd_file.put_line(fnd_file.log,'ROLLBACK to point4, error -> '|| SQLERRM);

4629:
4630: ROLLBACK TO point5;
4631:
4632: IF v_debug THEN
4633: fnd_file.put_line(fnd_file.log,'ROLLBACK to point4, error -> '|| SQLERRM);
4634: END IF;
4635:
4636: IF v_message IS NULL THEN
4637: v_message := 'Dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;

Line 4743: fnd_file.put_line(fnd_file.log, 'Main Rollback Performed, '||SQLERRM);

4739:
4740: IF v_debug THEN
4741: UTL_FILE.put_line(v_myfilehandle, ' Rollback Performed');
4742: UTL_FILE.fclose(v_myfilehandle);
4743: fnd_file.put_line(fnd_file.log, 'Main Rollback Performed, '||SQLERRM);
4744: END IF;
4745: v_message := SQLERRM;
4746: UPDATE JAI_CMN_MTAX_HDRS_ALL SET error_message = v_message WHERE batch_id = v_batch_id;
4747:

Line 5136: fnd_file.put_line(fnd_file.log,' 3.1');

5132: p_message := 'No Manual taxes are attached to requisition line, so no problem is deleting the line taxes';
5133: END IF;
5134:
5135: IF v_debug = 'Y' THEN
5136: fnd_file.put_line(fnd_file.log,' 3.1');
5137: END IF;
5138:
5139: RETURN;
5140: ELSIF v_manual = 'Y' AND p_success > 0 THEN

Line 5176: fnd_file.put_line(fnd_file.log,' 3.2');

5172: p_message := 'No Manual taxes are attached to requisition line, so no problem is deleting the line taxes';
5173: END IF;
5174:
5175: IF v_debug = 'Y' THEN
5176: fnd_file.put_line(fnd_file.log,' 3.2');
5177: END IF;
5178:
5179: p_message := 'Manual taxes are attached and there is no problem in deleting the taxes';
5180: