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 JAI_CMN_MTAX_UPD_DTLS_S

Line 1419: jai_cmn_mtax_upd_dtls_s.nextval,

1415: last_updated_by ,
1416: last_update_date
1417: )
1418: VALUES (
1419: jai_cmn_mtax_upd_dtls_s.nextval,
1420: v_batch_id,
1421: shipment_rec.line_focus_id,
1422: shipment_rec.shipment_type,
1423: shipment_rec.document_no,

Line 1669: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id

1665:
1666: -- ended, Harshita for Bug #3765133
1667:
1668:
1669: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id
1670: WHERE batch_id = v_batch_id AND detail_id = shipment_rec.line_focus_id;
1671:
1672: IF p_override_manual_taxes <> 'Y' THEN
1673: --* modifying the tax line number of the manual taxes starting from 1..n manual taxes *

Line 1760: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

1756:
1757: ELSE -- Failed to remove old taxes and insert new taxes because of some reason(will be shown in the LOG)
1758:
1759: -- v_message := v_message_01;
1760: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
1761: WHERE batch_id = v_batch_id AND detail_id = shipment_rec.line_focus_id;
1762:
1763: -- Write the details of the Shipment Details to the log file why the taxes were not recalculated *
1764: IF v_debug THEN

Line 1794: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

1790:
1791: ELSE -- IF v_dflt_tax_category_id IS NOT NULL THEN
1792:
1793: v_message := v_message_01;
1794: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
1795: WHERE batch_id = v_batch_id AND detail_id = shipment_rec.line_focus_id;
1796:
1797: IF v_debug THEN
1798: UTL_FILE.PUT_LINE(v_myfilehandle, 'v_dflt_tax_category_id is null for : Order No. '||shipment_rec.document_no||', -> '|| shipment_rec.po_line_id||

Line 1840: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

1836: ELSE
1837: v_message := v_message||', dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;
1838: END IF;
1839:
1840: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
1841: WHERE batch_id = v_batch_id AND detail_id = shipment_rec.line_focus_id;
1842:
1843:
1844: IF SQL%NOTFOUND THEN

Line 1866: VALUES ( jai_cmn_mtax_upd_dtls_s.nextval,

1862: last_updated_by ,
1863: last_update_date
1864:
1865: )
1866: VALUES ( jai_cmn_mtax_upd_dtls_s.nextval,
1867: v_batch_id,
1868: shipment_rec.line_focus_id,
1869: shipment_rec.shipment_type,
1870: shipment_rec.document_no,

Line 1981: jai_cmn_mtax_upd_dtls_s.nextval,

1977: last_updated_by ,
1978: last_update_date
1979: )
1980: VALUES (
1981: jai_cmn_mtax_upd_dtls_s.nextval,
1982: v_batch_id,
1983: releases_rec.line_focus_id,
1984: releases_rec.shipment_type,
1985: releases_rec.document_no,

Line 2233: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id

2229: WHERE line_focus_id = -releases_rec.line_focus_id);
2230:
2231: -- ended, Harshita for Bug #3765133
2232:
2233: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id
2234: WHERE batch_id = v_batch_id AND detail_id = releases_rec.line_focus_id;
2235:
2236: IF p_override_manual_taxes <> 'Y' THEN
2237: -- modifying the tax line number of the manual taxes starting from 1..n manual taxes *

Line 2322: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

2318: WHERE rowid = releases_rec.rowid;
2319:
2320: ELSE -- Failed to remove old taxes and insert new taxes because of some reason(will be shown in the LOG)
2321: -- v_message := v_message_01;
2322: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2323: WHERE batch_id = v_batch_id AND detail_id = releases_rec.line_focus_id;
2324:
2325: -- Write the details of the Shipment Details to the log file why the taxes were not recalculated
2326: IF v_debug THEN

Line 2355: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

2351: -- ended, Harshita for Bug #3765133
2352:
2353: ELSE -- IF v_dflt_tax_category_id IS NOT NULL
2354: v_message := v_message_01;
2355: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2356: WHERE batch_id = v_batch_id AND detail_id = releases_rec.line_focus_id;
2357:
2358: IF v_debug THEN
2359: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||

Line 2401: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

2397: ELSE
2398: v_message := v_message||', dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;
2399: END IF;
2400:
2401: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2402: WHERE batch_id = v_batch_id AND detail_id = releases_rec.line_focus_id;
2403:
2404: -- as advised by APARAJITA
2405: IF sql%notfound THEN

Line 2428: VALUES ( JAI_CMN_MTAX_UPD_DTLS_S.nextval,

2424: creation_date ,
2425: last_updated_by ,
2426: last_update_date
2427: )
2428: VALUES ( JAI_CMN_MTAX_UPD_DTLS_S.nextval,
2429: v_batch_id,
2430: releases_rec.line_focus_id,
2431: releases_rec.shipment_type,
2432: releases_rec.document_no,

Line 2527: jai_cmn_mtax_upd_dtls_s.nextval,

2523: last_updated_by ,
2524: last_update_date
2525: )
2526: VALUES (
2527: jai_cmn_mtax_upd_dtls_s.nextval,
2528: v_batch_id,
2529: reqn_rec.requisition_line_id,
2530: reqn_rec.type_lookup_code,
2531: reqn_rec.document_no,

Line 2794: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id

2790: WHERE requisition_line_id = -reqn_rec.requisition_line_id);
2791:
2792: -- ended, Harshita for Bug #3765133
2793:
2794: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id
2795: WHERE batch_id = v_batch_id AND detail_id = reqn_rec.requisition_line_id;
2796:
2797: IF p_override_manual_taxes <> 'Y' THEN
2798: --* modifying the tax line number of the manual taxes starting from 1..n manual taxes *

Line 2880: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

2876: -- WHERE requisition_line_id = reqn_rec.requisition_line_id;
2877:
2878: ELSE -- Failed to remove old taxes and insert new taxes because of some reason(will be shown in the LOG)
2879: -- v_message := v_message_01;
2880: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2881: WHERE batch_id = v_batch_id AND detail_id = reqn_rec.requisition_line_id;
2882:
2883: --*XYZ Write the details of the Requisition Details to the log file why the taxes were not recalculated *
2884: IF v_debug THEN

Line 2913: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

2909: -- ended, Harshita for Bug #3765133
2910:
2911: ELSE
2912: v_message := v_message_01;
2913: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2914: WHERE batch_id = v_batch_id AND detail_id = reqn_rec.requisition_line_id;
2915:
2916: IF v_debug THEN
2917: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - Requisition No. '||reqn_rec.document_no||

Line 2959: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

2955: ELSE
2956: v_message := v_message||', dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;
2957: END IF;
2958:
2959: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2960: WHERE batch_id = v_batch_id AND detail_id = reqn_rec.requisition_line_id;
2961:
2962: -- as advised by APARAJITA
2963: IF SQL%NOTFOUND THEN

Line 2988: jai_cmn_mtax_upd_dtls_s.nextval,

2984: last_updated_by ,
2985: last_update_date
2986: )
2987: VALUES (
2988: jai_cmn_mtax_upd_dtls_s.nextval,
2989: v_batch_id,
2990: reqn_rec.requisition_line_id,
2991: reqn_rec.type_lookup_code,
2992: reqn_rec.document_no,

Line 3099: jai_cmn_mtax_upd_dtls_s.nextval,

3095: last_updated_by ,
3096: last_update_date
3097: )
3098: VALUES (
3099: jai_cmn_mtax_upd_dtls_s.nextval,
3100: v_batch_id,
3101: so_rec.line_id,
3102: 'SO',
3103: so_rec.document_no,

Line 3280: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id

3276:
3277: -- ended, Harshita for Bug #3765133
3278:
3279:
3280: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id
3281: WHERE batch_id = v_batch_id AND detail_id = so_rec.line_id;
3282:
3283: IF p_override_manual_taxes <> 'Y' THEN
3284: --* modifying the tax line number of the manual taxes starting from 1..n manual taxes *

Line 3420: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

3416: --------------------------------------------------------------------------------------------
3417:
3418: ELSE -- Failed to remove old taxes and insert new taxes because of some reason(will be shown in the LOG)
3419:
3420: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
3421: WHERE batch_id = v_batch_id AND detail_id = so_rec.line_id;
3422:
3423: --*XYZ Write the details of the Shipment Details to the log file why the taxes were not recalculated *
3424: IF v_debug THEN

Line 3453: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

3449:
3450: ELSE
3451:
3452: v_message := v_message_01;
3453: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
3454: WHERE batch_id = v_batch_id AND detail_id = so_rec.line_id;
3455:
3456: IF v_debug THEN
3457: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - Sales Order No. '||so_rec.order_number||

Line 3500: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

3496: ELSE
3497: v_message := v_message||', dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;
3498: END IF;
3499:
3500: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
3501: WHERE batch_id = v_batch_id AND detail_id = so_rec.line_id;
3502:
3503: -- as advised by APARAJITA
3504: IF sql%notfound THEN

Line 3525: jai_cmn_mtax_upd_dtls_s.nextval,

3521: last_updated_by ,
3522: last_update_date
3523: )
3524: VALUES (
3525: jai_cmn_mtax_upd_dtls_s.nextval,
3526: v_batch_id, so_rec.line_id,
3527: 'SO',
3528: so_rec.document_no,
3529: so_rec.line_number,