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

Line 1147: related message or error message is updated in the records processed table( JAI_CMN_MTAX_UPD_DTLS)

1143: This procedure processess one of the program blocks specified. Each block fetches the data that needs to be
1144: applied with tax rate changes based on tax category id given in the setups or given in the input parameters.
1145: Each program block does the following coding: Looks at the setups for the defaulting tax category and replaces
1146: the old tax category with new tax category taxes and then recalculates the taxes. If there are any errors, then
1147: related message or error message is updated in the records processed table( JAI_CMN_MTAX_UPD_DTLS)
1148:
1149: 2. 27/01/2005 Harshita J for Bug #3765133 . FileVersion# 115.1
1150: Changes made in the Procedure to capture tax_amounts for adhoc taxes.
1151:

Line 1800: INSERT INTO JAI_CMN_MTAX_UPD_DTLS ( MTAX_DTL_ID,

1796:
1797: -- ENTRY INTO Request Details table that contains the shipment records processed during Mass Tax Changes
1798: -- If any error occurs while processing the record, the error_reason column is updated with corresponding error message
1799: -- later in the code
1800: INSERT INTO JAI_CMN_MTAX_UPD_DTLS ( MTAX_DTL_ID,
1801: batch_id,
1802: detail_id,
1803: document_type,
1804: document_no,

Line 1818: jai_cmn_mtax_upd_dtls_s.nextval,

1814: last_updated_by ,
1815: last_update_date
1816: )
1817: VALUES (
1818: jai_cmn_mtax_upd_dtls_s.nextval,
1819: v_batch_id,
1820: shipment_rec.line_focus_id,
1821: shipment_rec.shipment_type,
1822: shipment_rec.document_no,

Line 2072: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id

2068:
2069: -- ended, Harshita for Bug #3765133
2070:
2071:
2072: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id
2073: WHERE batch_id = v_batch_id AND detail_id = shipment_rec.line_focus_id;
2074:
2075: IF p_override_manual_taxes <> 'Y' THEN
2076: --* modifying the tax line number of the manual taxes starting from 1..n manual taxes *

Line 2179: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

2175:
2176: ELSE -- Failed to remove old taxes and insert new taxes because of some reason(will be shown in the LOG)
2177:
2178: -- v_message := v_message_01;
2179: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2180: WHERE batch_id = v_batch_id AND detail_id = shipment_rec.line_focus_id;
2181:
2182: -- Write the details of the Shipment Details to the log file why the taxes were not recalculated *
2183: IF v_debug THEN

Line 2213: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

2209:
2210: ELSE -- IF v_dflt_tax_category_id IS NOT NULL THEN
2211:
2212: v_message := v_message_01;
2213: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2214: WHERE batch_id = v_batch_id AND detail_id = shipment_rec.line_focus_id;
2215:
2216: IF v_debug THEN
2217: 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 2259: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

2255: ELSE
2256: v_message := v_message||', dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;
2257: END IF;
2258:
2259: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2260: WHERE batch_id = v_batch_id AND detail_id = shipment_rec.line_focus_id;
2261:
2262:
2263: IF SQL%NOTFOUND THEN

Line 2264: INSERT INTO jai_cmn_mtax_upd_dtls (

2260: WHERE batch_id = v_batch_id AND detail_id = shipment_rec.line_focus_id;
2261:
2262:
2263: IF SQL%NOTFOUND THEN
2264: INSERT INTO jai_cmn_mtax_upd_dtls (
2265: mtax_dtl_id,
2266: batch_id,
2267: detail_id,
2268: document_type,

Line 2285: VALUES ( jai_cmn_mtax_upd_dtls_s.nextval,

2281: last_updated_by ,
2282: last_update_date
2283:
2284: )
2285: VALUES ( jai_cmn_mtax_upd_dtls_s.nextval,
2286: v_batch_id,
2287: shipment_rec.line_focus_id,
2288: shipment_rec.shipment_type,
2289: shipment_rec.document_no,

Line 2386: INSERT INTO jai_cmn_mtax_upd_dtls ( mtax_dtl_id,

2382:
2383: -- ENTRY INTO Request Details table that contains the shipment records processed during Mass Tax Changes
2384: -- If any error occurs while processing the record, the error_reason column is updated with corresponding error message
2385: -- later in the code
2386: INSERT INTO jai_cmn_mtax_upd_dtls ( mtax_dtl_id,
2387: batch_id,
2388: detail_id,
2389: document_type,
2390: document_no,

Line 2405: jai_cmn_mtax_upd_dtls_s.nextval,

2401: last_updated_by ,
2402: last_update_date
2403: )
2404: VALUES (
2405: jai_cmn_mtax_upd_dtls_s.nextval,
2406: v_batch_id,
2407: releases_rec.line_focus_id,
2408: releases_rec.shipment_type,
2409: releases_rec.document_no,

Line 2661: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id

2657: WHERE line_focus_id = -releases_rec.line_focus_id);
2658:
2659: -- ended, Harshita for Bug #3765133
2660:
2661: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id
2662: WHERE batch_id = v_batch_id AND detail_id = releases_rec.line_focus_id;
2663:
2664: IF p_override_manual_taxes <> 'Y' THEN
2665: -- modifying the tax line number of the manual taxes starting from 1..n manual taxes *

Line 2767: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

2763: WHERE rowid = releases_rec.rowid;
2764:
2765: ELSE -- Failed to remove old taxes and insert new taxes because of some reason(will be shown in the LOG)
2766: -- v_message := v_message_01;
2767: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2768: WHERE batch_id = v_batch_id AND detail_id = releases_rec.line_focus_id;
2769:
2770: -- Write the details of the Shipment Details to the log file why the taxes were not recalculated
2771: IF v_debug THEN

Line 2800: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

2796: -- ended, Harshita for Bug #3765133
2797:
2798: ELSE -- IF v_dflt_tax_category_id IS NOT NULL
2799: v_message := v_message_01;
2800: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2801: WHERE batch_id = v_batch_id AND detail_id = releases_rec.line_focus_id;
2802:
2803: IF v_debug THEN
2804: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - Order No. '||releases_rec.document_no||', -> '|| releases_rec.po_line_id||

Line 2846: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

2842: ELSE
2843: v_message := v_message||', dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;
2844: END IF;
2845:
2846: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
2847: WHERE batch_id = v_batch_id AND detail_id = releases_rec.line_focus_id;
2848:
2849: -- as advised by APARAJITA
2850: IF sql%notfound THEN

Line 2851: INSERT INTO JAI_CMN_MTAX_UPD_DTLS

2847: WHERE batch_id = v_batch_id AND detail_id = releases_rec.line_focus_id;
2848:
2849: -- as advised by APARAJITA
2850: IF sql%notfound THEN
2851: INSERT INTO JAI_CMN_MTAX_UPD_DTLS
2852: (
2853: mtax_dtl_id,
2854: batch_id,
2855: detail_id,

Line 2873: VALUES ( JAI_CMN_MTAX_UPD_DTLS_S.nextval,

2869: creation_date ,
2870: last_updated_by ,
2871: last_update_date
2872: )
2873: VALUES ( JAI_CMN_MTAX_UPD_DTLS_S.nextval,
2874: v_batch_id,
2875: releases_rec.line_focus_id,
2876: releases_rec.shipment_type,
2877: releases_rec.document_no,

Line 2959: INSERT INTO JAI_CMN_MTAX_UPD_DTLS (

2955:
2956: -- There wont be any partial receipts in this case, so No partial Case
2957:
2958: -- ENTRY INTO Request Details table that contains the shipment records processed during Mass Tax Changes
2959: INSERT INTO JAI_CMN_MTAX_UPD_DTLS (
2960: mtax_dtl_id,
2961: batch_id,
2962: detail_id,
2963: document_type,

Line 2977: jai_cmn_mtax_upd_dtls_s.nextval,

2973: last_updated_by ,
2974: last_update_date
2975: )
2976: VALUES (
2977: jai_cmn_mtax_upd_dtls_s.nextval,
2978: v_batch_id,
2979: reqn_rec.requisition_line_id,
2980: reqn_rec.type_lookup_code,
2981: reqn_rec.document_no,

Line 3248: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id

3244: WHERE requisition_line_id = -reqn_rec.requisition_line_id);
3245:
3246: -- ended, Harshita for Bug #3765133
3247:
3248: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id
3249: WHERE batch_id = v_batch_id AND detail_id = reqn_rec.requisition_line_id;
3250:
3251: IF p_override_manual_taxes <> 'Y' THEN
3252: --* modifying the tax line number of the manual taxes starting from 1..n manual taxes *

Line 3349: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

3345: -- WHERE requisition_line_id = reqn_rec.requisition_line_id;
3346:
3347: ELSE -- Failed to remove old taxes and insert new taxes because of some reason(will be shown in the LOG)
3348: -- v_message := v_message_01;
3349: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
3350: WHERE batch_id = v_batch_id AND detail_id = reqn_rec.requisition_line_id;
3351:
3352: --*XYZ Write the details of the Requisition Details to the log file why the taxes were not recalculated *
3353: IF v_debug THEN

Line 3382: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

3378: -- ended, Harshita for Bug #3765133
3379:
3380: ELSE
3381: v_message := v_message_01;
3382: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
3383: WHERE batch_id = v_batch_id AND detail_id = reqn_rec.requisition_line_id;
3384:
3385: IF v_debug THEN
3386: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - Requisition No. '||reqn_rec.document_no||

Line 3428: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

3424: ELSE
3425: v_message := v_message||', dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;
3426: END IF;
3427:
3428: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
3429: WHERE batch_id = v_batch_id AND detail_id = reqn_rec.requisition_line_id;
3430:
3431: -- as advised by APARAJITA
3432: IF SQL%NOTFOUND THEN

Line 3437: INSERT INTO JAI_CMN_MTAX_UPD_DTLS (

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,
3439: batch_id,
3440: detail_id,
3441: document_type,

Line 3457: jai_cmn_mtax_upd_dtls_s.nextval,

3453: last_updated_by ,
3454: last_update_date
3455: )
3456: VALUES (
3457: jai_cmn_mtax_upd_dtls_s.nextval,
3458: v_batch_id,
3459: reqn_rec.requisition_line_id,
3460: reqn_rec.type_lookup_code,
3461: reqn_rec.document_no,

Line 3555: INSERT INTO JAI_CMN_MTAX_UPD_DTLS (

3551:
3552: -- ENTRY INTO Request Details table that contains the shipment records processed during Mass Tax Changes
3553: -- If any error occurs while processing the record, the error_reason column is updated with corresponding error message
3554: -- later in the code
3555: INSERT INTO JAI_CMN_MTAX_UPD_DTLS (
3556: mtax_dtl_id,
3557: batch_id,
3558: detail_id,
3559: document_type,

Line 3573: jai_cmn_mtax_upd_dtls_s.nextval,

3569: last_updated_by ,
3570: last_update_date
3571: )
3572: VALUES (
3573: jai_cmn_mtax_upd_dtls_s.nextval,
3574: v_batch_id,
3575: so_rec.line_id,
3576: 'SO',
3577: so_rec.document_no,

Line 3767: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id

3763:
3764: -- ended, Harshita for Bug #3765133
3765:
3766:
3767: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id
3768: WHERE batch_id = v_batch_id AND detail_id = so_rec.line_id;
3769:
3770: IF p_override_manual_taxes <> 'Y' THEN
3771: --* modifying the tax line number of the manual taxes starting from 1..n manual taxes *

Line 4009: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

4005: --------------------------------------------------------------------------------------------
4006:
4007: ELSE -- Failed to remove old taxes and insert new taxes because of some reason(will be shown in the LOG)
4008:
4009: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
4010: WHERE batch_id = v_batch_id AND detail_id = so_rec.line_id;
4011:
4012: --*XYZ Write the details of the Shipment Details to the log file why the taxes were not recalculated *
4013: IF v_debug THEN

Line 4042: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

4038:
4039: ELSE
4040:
4041: v_message := v_message_01;
4042: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
4043: WHERE batch_id = v_batch_id AND detail_id = so_rec.line_id;
4044:
4045: IF v_debug THEN
4046: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - Sales Order No. '||so_rec.order_number||

Line 4089: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

4085: ELSE
4086: v_message := v_message||', dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;
4087: END IF;
4088:
4089: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
4090: WHERE batch_id = v_batch_id AND detail_id = so_rec.line_id;
4091:
4092: -- as advised by APARAJITA
4093: IF sql%notfound THEN

Line 4094: INSERT INTO JAI_CMN_MTAX_UPD_DTLS (

4090: WHERE batch_id = v_batch_id AND detail_id = so_rec.line_id;
4091:
4092: -- as advised by APARAJITA
4093: IF sql%notfound THEN
4094: INSERT INTO JAI_CMN_MTAX_UPD_DTLS (
4095: MTAX_DTL_ID,
4096: batch_id,
4097: detail_id,
4098: document_type,

Line 4114: jai_cmn_mtax_upd_dtls_s.nextval,

4110: last_updated_by ,
4111: last_update_date
4112: )
4113: VALUES (
4114: jai_cmn_mtax_upd_dtls_s.nextval,
4115: v_batch_id, so_rec.line_id,
4116: 'SO',
4117: so_rec.document_no,
4118: so_rec.line_number,

Line 4207: INSERT INTO JAI_CMN_MTAX_UPD_DTLS (

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
4206: -- later in the code
4207: INSERT INTO JAI_CMN_MTAX_UPD_DTLS (
4208: mtax_dtl_id,
4209: batch_id,
4210: detail_id,
4211: document_type,

Line 4225: jai_cmn_mtax_upd_dtls_s.nextval,

4221: last_updated_by ,
4222: last_update_date
4223: )
4224: VALUES (
4225: jai_cmn_mtax_upd_dtls_s.nextval,
4226: v_batch_id,
4227: boe_rec.boe_detail_id,
4228: 'BOE',
4229: boe_rec.boe_id,

Line 4405: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id

4401: where boe_detail_id = -boe_rec.boe_detail_id
4402: );
4403:
4404:
4405: UPDATE JAI_CMN_MTAX_UPD_DTLS SET new_tax_category_id = v_dflt_tax_category_id
4406: WHERE batch_id = v_batch_id AND detail_id = boe_rec.boe_detail_id;
4407:
4408: IF p_override_manual_taxes <> 'Y' THEN
4409: --* modifying the tax line number of the manual taxes starting from 1..n manual taxes *

Line 4569: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

4565:
4566:
4567: ELSE -- Failed to remove old taxes and insert new taxes because of some reason(will be shown in the LOG)
4568:
4569: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
4570: WHERE batch_id = v_batch_id AND detail_id = boe_rec.boe_detail_id;
4571:
4572: --*XYZ Write the details of the Shipment Details to the log file why the taxes were not recalculated *
4573: IF v_debug THEN

Line 4595: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

4591:
4592: ELSE
4593:
4594: v_message := v_message_01;
4595: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
4596: WHERE batch_id = v_batch_id AND detail_id = boe_rec.boe_detail_id;
4597:
4598: IF v_debug THEN
4599: UTL_FILE.PUT_LINE(v_myfilehandle, 'Default tax_category_id IS Null - BOE id. '||boe_rec.boe_id||

Line 4642: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message

4638: ELSE
4639: v_message := v_message||', dflt_tax_category -> '||v_dflt_tax_category_id||', SQLERRM -> '||SQLERRM;
4640: END IF;
4641:
4642: UPDATE JAI_CMN_MTAX_UPD_DTLS SET error_reason = v_message
4643: WHERE batch_id = v_batch_id AND detail_id = boe_rec.boe_detail_id;
4644:
4645:
4646: IF sql%notfound THEN

Line 4647: INSERT INTO JAI_CMN_MTAX_UPD_DTLS (

4643: WHERE batch_id = v_batch_id AND detail_id = boe_rec.boe_detail_id;
4644:
4645:
4646: IF sql%notfound THEN
4647: INSERT INTO JAI_CMN_MTAX_UPD_DTLS (
4648: MTAX_DTL_ID,
4649: batch_id,
4650: detail_id,
4651: document_type,

Line 4667: jai_cmn_mtax_upd_dtls_s.nextval,

4663: last_updated_by ,
4664: last_update_date
4665: )
4666: VALUES (
4667: jai_cmn_mtax_upd_dtls_s.nextval,
4668: v_batch_id, boe_rec.boe_detail_id,
4669: 'BOE',
4670: boe_rec.document_no,
4671: boe_rec.line_number,