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_OM_TAX_PROCESSING_PKG dependencies on JAI_CONSTANTS

Line 174: AND tax_types.regime_code = jai_constants.vat_regime;

170: WHERE jstl.line_id = cp_line_id
171: AND jstl.header_id = cp_header_id
172: AND jtc.tax_id = jstl.tax_id
173: AND jtc.tax_type = tax_types.tax_type
174: AND tax_types.regime_code = jai_constants.vat_regime;
175:
176: CURSOR cur_chk_excise_exists (cp_line_id JAI_OM_OE_SO_TAXES.LINE_ID%TYPE,
177: cp_header_id JAI_OM_OE_SO_TAXES.HEADER_ID%TYPE
178: )

Line 186: AND jtc.tax_type in ( jai_constants.tax_type_excise,

182: JAI_CMN_TAXES_ALL jtc
183: WHERE jstl.line_id = cp_line_id
184: AND jstl.header_id = cp_header_id
185: AND jtc.tax_id = jstl.tax_id
186: AND jtc.tax_type in ( jai_constants.tax_type_excise,
187: jai_constants.tax_type_exc_additional,
188: jai_constants.tax_type_exc_other,
189: jai_constants.tax_type_exc_edu_cess,
190: jai_constants.tax_type_sh_exc_edu_cess);

Line 187: jai_constants.tax_type_exc_additional,

183: WHERE jstl.line_id = cp_line_id
184: AND jstl.header_id = cp_header_id
185: AND jtc.tax_id = jstl.tax_id
186: AND jtc.tax_type in ( jai_constants.tax_type_excise,
187: jai_constants.tax_type_exc_additional,
188: jai_constants.tax_type_exc_other,
189: jai_constants.tax_type_exc_edu_cess,
190: jai_constants.tax_type_sh_exc_edu_cess);
191:

Line 188: jai_constants.tax_type_exc_other,

184: AND jstl.header_id = cp_header_id
185: AND jtc.tax_id = jstl.tax_id
186: AND jtc.tax_type in ( jai_constants.tax_type_excise,
187: jai_constants.tax_type_exc_additional,
188: jai_constants.tax_type_exc_other,
189: jai_constants.tax_type_exc_edu_cess,
190: jai_constants.tax_type_sh_exc_edu_cess);
191:
192: CURSOR cur_chk_org_loc_setup (cp_organization_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,

Line 189: jai_constants.tax_type_exc_edu_cess,

185: AND jtc.tax_id = jstl.tax_id
186: AND jtc.tax_type in ( jai_constants.tax_type_excise,
187: jai_constants.tax_type_exc_additional,
188: jai_constants.tax_type_exc_other,
189: jai_constants.tax_type_exc_edu_cess,
190: jai_constants.tax_type_sh_exc_edu_cess);
191:
192: CURSOR cur_chk_org_loc_setup (cp_organization_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
193: cp_location_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE

Line 190: jai_constants.tax_type_sh_exc_edu_cess);

186: AND jtc.tax_type in ( jai_constants.tax_type_excise,
187: jai_constants.tax_type_exc_additional,
188: jai_constants.tax_type_exc_other,
189: jai_constants.tax_type_exc_edu_cess,
190: jai_constants.tax_type_sh_exc_edu_cess);
191:
192: CURSOR cur_chk_org_loc_setup (cp_organization_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
193: cp_location_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE
194: )

Line 202: AND rgms.regime_code = jai_constants.vat_regime;

198: JAI_RGM_DEFINITIONS rgms
199: WHERE rgmpt.regime_id = rgms.regime_id
200: AND rgmpt.location_id = cp_location_id
201: AND rgmpt.organization_id = cp_organization_id
202: AND rgms.regime_code = jai_constants.vat_regime;
203:
204: tab_ooh OE_ORDER_HEADERS_ALL%ROWTYPE ;
205: CURSOR cur_get_org_hdr (cp_header_id OE_ORDER_HEADERS_ALL.HEADER_ID%TYPE)
206: IS

Line 239: px_return_code := jai_constants.successful ;

235: ln_model_item_id NUMBER ;
236:
237: BEGIN
238:
239: px_return_code := jai_constants.successful ;
240:
241: v_inventory_item_id :=p_rec_new.inventory_item_id ;
242: v_organization_id :=p_rec_new.ship_from_org_id ;
243: v_subinventory :=p_rec_new.subinventory ;

Line 255: px_return_code := jai_constants.successful ;

251: FND_LOG.STRING(G_LEVEL_STATEMENT,
252: G_MODULE_NAME || v_api_name,
253: ' This procedure just process type is ORDER, skip it for line_id' || p_rec_new.line_id);
254: END IF;
255: px_return_code := jai_constants.successful ;
256: px_return_message := 'This procedure just process type is ORDER, skip it for line_id' || p_rec_new.line_id ;
257: return;
258: END IF;
259:

Line 281: px_return_code := jai_constants.expected_error ;

277: FND_LOG.STRING(G_LEVEL_STATEMENT,
278: G_MODULE_NAME || v_api_name,
279: ' Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || p_rec_new.line_id);
280: END IF;
281: px_return_code := jai_constants.expected_error ;
282: px_return_message := 'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || p_rec_new.line_id ;
283: return ;
284: END IF;
285:

Line 298: px_return_code := jai_constants.expected_error ;

294: p_shipment_line_number => ln_shipment_line_number,
295: p_error_msg => lv_error_msg
296: ) ;
297: IF nvl(lv_ret_flag,'S') = 'EE' THEN
298: px_return_code := jai_constants.expected_error ;
299: px_return_message := lv_error_msg;
300: return ;
301: ELSIF nvl(lv_ret_flag,'S') = 'UE' THEN
302: px_return_code := jai_constants.expected_error ;

Line 302: px_return_code := jai_constants.expected_error ;

298: px_return_code := jai_constants.expected_error ;
299: px_return_message := lv_error_msg;
300: return ;
301: ELSIF nvl(lv_ret_flag,'S') = 'UE' THEN
302: px_return_code := jai_constants.expected_error ;
303: px_return_message := lv_error_msg;
304: return ;
305: END IF ;
306:

Line 337: px_return_code := jai_constants.expected_error ;

333: G_MODULE_NAME || v_api_name,
334: 'An item which is not Excisable has Excise Taxes attached.' ||
335: 'Please correct the item attribute or remove the Excise type of taxes');
336: END IF;
337: px_return_code := jai_constants.expected_error ;
338: px_return_message := 'An item which is not Excisable has Excise Taxes attached.' ||
339: 'Please correct the item attribute or remove the Excise type of taxes' ;
340: return ;
341: END IF;

Line 381: px_return_code := jai_constants.expected_error ;

377: FND_LOG.STRING(G_LEVEL_STATEMENT,
378: G_MODULE_NAME || v_api_name,
379: ' Mandatory India Localization Sub-inventory Setup not done for this Location from where shipment is made');
380: END IF;
381: px_return_code := jai_constants.expected_error ;
382: px_return_message := 'Mandatory India Localization Sub-inventory Setup not done for this Location from where shipment is made' ;
383: return ;
384: end if ;
385: end if;

Line 433: jai_inv_items_pkg.jai_get_attrib ( p_regime_code => jai_constants.vat_regime

429: OPEN c_model_item_id(ln_ato_line_id) ;
430: FETCH c_model_item_id INTO ln_model_item_id ;
431: CLOSE c_model_item_id ;
432:
433: jai_inv_items_pkg.jai_get_attrib ( p_regime_code => jai_constants.vat_regime
434: , p_organization_id => p_rec_new.ship_from_org_id
435: , p_inventory_item_id => ln_model_item_id
436: , p_attribute_code => jai_constants.rgm_attr_item_applicable
437: , p_attribute_value => lv_applicable

Line 436: , p_attribute_code => jai_constants.rgm_attr_item_applicable

432:
433: jai_inv_items_pkg.jai_get_attrib ( p_regime_code => jai_constants.vat_regime
434: , p_organization_id => p_rec_new.ship_from_org_id
435: , p_inventory_item_id => ln_model_item_id
436: , p_attribute_code => jai_constants.rgm_attr_item_applicable
437: , p_attribute_value => lv_applicable
438: , p_process_flag => lv_process_flag
439: , p_process_msg => lv_process_message
440: );

Line 443: jai_inv_items_pkg.jai_get_attrib ( p_regime_code => jai_constants.vat_regime

439: , p_process_msg => lv_process_message
440: );
441: ELSE
442:
443: jai_inv_items_pkg.jai_get_attrib ( p_regime_code => jai_constants.vat_regime
444: , p_organization_id => p_rec_new.ship_from_org_id
445: , p_inventory_item_id => p_rec_new.inventory_item_id
446: , p_attribute_code => jai_constants.rgm_attr_item_applicable
447: , p_attribute_value => lv_applicable

Line 446: , p_attribute_code => jai_constants.rgm_attr_item_applicable

442:
443: jai_inv_items_pkg.jai_get_attrib ( p_regime_code => jai_constants.vat_regime
444: , p_organization_id => p_rec_new.ship_from_org_id
445: , p_inventory_item_id => p_rec_new.inventory_item_id
446: , p_attribute_code => jai_constants.rgm_attr_item_applicable
447: , p_attribute_value => lv_applicable
448: , p_process_flag => lv_process_flag
449: , p_process_msg => lv_process_message
450: );

Line 452: IF lv_process_flag = jai_constants.successful

448: , p_process_flag => lv_process_flag
449: , p_process_msg => lv_process_message
450: );
451: END IF;
452: IF lv_process_flag = jai_constants.successful
453: AND nvl(lv_applicable,'N') = 'N' THEN
454: /*
455: ||item is not vatable
456: */

Line 466: ELSIF lv_process_flag <> jai_constants.successful THEN

462: app_exception.raise_exception( EXCEPTION_TYPE => 'APP'
463: ,EXCEPTION_CODE => NULL
464: ,EXCEPTION_TEXT => 'An item which is not Vatable has VAT Taxes attached.Please correct the item attribute or remove the VAT type of taxes'
465: );
466: ELSIF lv_process_flag <> jai_constants.successful THEN
467: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
468: FND_LOG.STRING(G_LEVEL_STATEMENT,
469: G_MODULE_NAME || v_api_name,
470: lv_process_message);

Line 483: p_event => jai_constants.wsh_ship_confirm ,

479: END IF;
480: END IF;
481:
482: jai_ar_tcs_rep_pkg.process_transactions ( p_ooh => tab_ooh ,
483: p_event => jai_constants.wsh_ship_confirm ,
484: p_process_flag => lv_process_flag ,
485: p_process_message => lv_process_message
486: );
487:

Line 488: IF lv_process_flag = jai_constants.expected_error OR

484: p_process_flag => lv_process_flag ,
485: p_process_message => lv_process_message
486: );
487:
488: IF lv_process_flag = jai_constants.expected_error OR
489: lv_process_flag = jai_constants.unexpected_error
490: THEN
491: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
492: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 489: lv_process_flag = jai_constants.unexpected_error

485: p_process_message => lv_process_message
486: );
487:
488: IF lv_process_flag = jai_constants.expected_error OR
489: lv_process_flag = jai_constants.unexpected_error
490: THEN
491: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
492: FND_LOG.STRING(G_LEVEL_STATEMENT,
493: G_MODULE_NAME || v_api_name,

Line 504: IF lv_process_flag = jai_constants.unexpected_error THEN

500:
501:
502: EXCEPTION
503: WHEN le_error THEN
504: IF lv_process_flag = jai_constants.unexpected_error THEN
505: lv_process_message := substr (lv_process_message || ' Object = JAI_OM_TAX_PROCESSING_PKG.ORDER_LINE_VALIDATION ', 1,1999) ;
506: END IF;
507:
508:

Line 1207: WHERE regime_code = jai_constants.vat_regime

1203:
1204: CURSOR c_check_vat_type_tax_exists(cp_tax_type VARCHAR2) IS
1205: SELECT 1
1206: FROM jai_regime_tax_types_v
1207: WHERE regime_code = jai_constants.vat_regime
1208: AND tax_type = cp_tax_type;
1209:
1210: cursor cur_get_ddetail_id(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,
1211: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) is

Line 1339: px_return_code := jai_constants.successful;

1335: v_service_type_code varchar2(30);
1336:
1337: BEGIN
1338:
1339: px_return_code := jai_constants.successful;
1340: v_rma_quantity_uom := pr_order_line.order_quantity_uom;
1341: OPEN c_sales_order_cur;
1342: FETCH c_sales_order_cur
1343: INTO v_orig_ord_qty, v_service_type_code;

Line 1546: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,

1542: IF (rec_cur_get_picking_tax_lines.tax_type IN
1543: ('Excise',
1544: 'Addl. Excise',
1545: 'Other Excise',
1546: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
1547: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) AND
1548: v_excise_flag = 'N') OR
1549: (rec_cur_get_picking_tax_lines.tax_type IN
1550: ('Sales Tax', 'CST') AND v_sales_flag = 'N') OR

Line 1547: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) AND

1543: ('Excise',
1544: 'Addl. Excise',
1545: 'Other Excise',
1546: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
1547: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) AND
1548: v_excise_flag = 'N') OR
1549: (rec_cur_get_picking_tax_lines.tax_type IN
1550: ('Sales Tax', 'CST') AND v_sales_flag = 'N') OR
1551: (lv_check_vat_type_exists = 1 AND v_vat_flag = 'N') THEN

Line 1742: px_return_code := jai_constants.expected_error;

1738: -- Details in picking lines not found . Raise an error message
1739: CLOSE cur_get_picking_lines;
1740: /* RAISE_APPLICATION_ERROR (-20001,'No data found in localisation shipping tables, hence copy cannot be done');
1741: */
1742: px_return_code := jai_constants.expected_error;
1743: px_return_message := 'No data found in localisation shipping tables,hence copy cannot be done';
1744: return;
1745: END IF;
1746: CLOSE cur_get_picking_lines;

Line 1963: WHERE regime_code = jai_constants.vat_regime

1959:
1960: CURSOR c_check_vat_type_tax_exists(cp_tax_type VARCHAR2) IS
1961: SELECT 1
1962: FROM jai_regime_tax_types_v
1963: WHERE regime_code = jai_constants.vat_regime
1964: AND tax_type = cp_tax_type;
1965:
1966: cursor cur_get_ddetail_id(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE,
1967: p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) is

Line 2048: px_return_code := jai_constants.successful;

2044: -- need to insert into JAI_OM_OE_RMA_LINES from the source.
2045:
2046: IF pr_order_line.return_context IS NULL THEN
2047:
2048: px_return_code := jai_constants.successful;
2049:
2050: open c_rma_details(pr_order_line.source_document_id,
2051: pr_order_line.source_document_line_id);
2052: fetch c_rma_details

Line 2170: px_return_code := jai_constants.successful;

2166: elsif pr_order_line.return_context = 'ORDER' THEN
2167: -- here need to code the cases where order catego
2168: --this script will execute only for the return order context.
2169:
2170: px_return_code := jai_constants.successful;
2171: v_rma_quantity_uom := pr_order_line.order_quantity_uom;
2172:
2173: OPEN c_sales_order_cur;
2174: FETCH c_sales_order_cur

Line 2380: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,

2376: IF (rec_cur_get_picking_tax_lines.tax_type IN
2377: ('Excise',
2378: 'Addl. Excise',
2379: 'Other Excise',
2380: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2381: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) AND
2382: v_excise_flag = 'N') OR
2383: (rec_cur_get_picking_tax_lines.tax_type IN
2384: ('Sales Tax', 'CST') AND v_sales_flag = 'N') OR

Line 2381: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) AND

2377: ('Excise',
2378: 'Addl. Excise',
2379: 'Other Excise',
2380: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,
2381: JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) AND
2382: v_excise_flag = 'N') OR
2383: (rec_cur_get_picking_tax_lines.tax_type IN
2384: ('Sales Tax', 'CST') AND v_sales_flag = 'N') OR
2385: (lv_check_vat_type_exists = 1 AND v_vat_flag = 'N') THEN

Line 2575: px_return_code := jai_constants.expected_error;

2571: ELSE
2572: -- Details in picking lines not found . Raise an error message
2573: CLOSE cur_get_picking_lines;
2574:
2575: px_return_code := jai_constants.expected_error;
2576: px_return_message := 'No data found in localisation shipping tables,hence copy cannot be done';
2577: return;
2578: END IF;
2579: CLOSE cur_get_picking_lines;

Line 2670: if (p_return_code <> jai_constants.successful) then

2666: copy_order_to_return(pr_order_line => pr_new_line,
2667: p_order_number => p_header_info.order_number,
2668: px_return_code => p_return_code,
2669: px_return_message => p_return_message);
2670: if (p_return_code <> jai_constants.successful) then
2671: return;
2672: end if;
2673:
2674: ELSIF rtrim(ltrim(v_source_order_category_code)) = 'MIXED' AND

Line 2681: if (p_return_code <> jai_constants.successful) then

2677: copy_mixed_to_return(pr_order_line => pr_new_line,
2678: p_order_number => p_header_info.order_number,
2679: px_return_code => p_return_code,
2680: px_return_message => p_return_message);
2681: if (p_return_code <> jai_constants.successful) then
2682: return;
2683: end if;
2684:
2685: ELSIF v_source_order_category_code = 'RETURN' AND

Line 2688: p_return_code := jai_constants.expected_error;

2684:
2685: ELSIF v_source_order_category_code = 'RETURN' AND
2686: v_line_category_code = 'RETURN' THEN
2687: -- Raise an Error
2688: p_return_code := jai_constants.expected_error;
2689: p_return_message := 'Copying of Return Order to Return Order is not currently supported with India Localization Taxes';
2690: return;
2691: END IF;
2692: EXCEPTION

Line 2744: AND b.tax_type <> jai_constants.tax_type_tds /* 'TDS'; Ramananda for removal of SQL LITERALs */

2740: SELECT SUM(A.tax_amount)
2741: FROM JAI_OM_OE_RMA_TAXES a, JAI_CMN_TAXES_ALL b
2742: WHERE a.rma_line_id = p_line_id
2743: AND b.tax_id = A.tax_id
2744: AND b.tax_type <> jai_constants.tax_type_tds /* 'TDS'; Ramananda for removal of SQL LITERALs */
2745: AND NVL(b.inclusive_tax_flag, 'N') = 'N';
2746:
2747: CURSOR order_tax_amount_Cur(p_header_id NUMBER, p_line_id NUMBER) IS
2748: SELECT SUM(A.tax_amount)

Line 2753: AND b.tax_type <> jai_constants.tax_type_tds

2749: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b
2750: WHERE A.Header_ID = p_header_id
2751: AND A.line_id = p_line_id
2752: AND b.tax_id = A.tax_id
2753: AND b.tax_type <> jai_constants.tax_type_tds
2754: AND NVL(b.inclusive_tax_flag, 'N') = 'N';
2755:
2756: v_transaction_name VARCHAR2(30);
2757: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

Line 3440: AND b.tax_type <> jai_constants.tax_type_tds

3436: FROM JAI_OM_OE_SO_TAXES A, JAI_CMN_TAXES_ALL b
3437: WHERE A.Header_ID = p_header_id
3438: AND A.line_id = p_line_id
3439: AND b.tax_id = A.tax_id
3440: AND b.tax_type <> jai_constants.tax_type_tds
3441: AND NVL(b.inclusive_tax_flag, 'N') = 'N';
3442:
3443: copy_rec get_copy_order_line%ROWTYPE;
3444: c_source_line_id NUMBER;

Line 3793: pv_return_code := jai_constants.successful;

3789: G_MODULE_NAME || v_api_name || '.BEGIN',
3790: G_PKG_NAME || ': ' || v_api_name || '()+');
3791: END IF;
3792:
3793: pv_return_code := jai_constants.successful;
3794:
3795: if (pv_action = jai_constants.updating and
3796: ((nvl(pr_old.line_number, -9999) <> nvl(pr_new.line_number, -9998)) and
3797: pr_new.line_number is not null)) OR

Line 3795: if (pv_action = jai_constants.updating and

3791: END IF;
3792:
3793: pv_return_code := jai_constants.successful;
3794:
3795: if (pv_action = jai_constants.updating and
3796: ((nvl(pr_old.line_number, -9999) <> nvl(pr_new.line_number, -9998)) and
3797: pr_new.line_number is not null)) OR
3798: (pv_action = jai_constants.updating and
3799: ((nvl(pr_old.shipment_number, -9999) <>

Line 3798: (pv_action = jai_constants.updating and

3794:
3795: if (pv_action = jai_constants.updating and
3796: ((nvl(pr_old.line_number, -9999) <> nvl(pr_new.line_number, -9998)) and
3797: pr_new.line_number is not null)) OR
3798: (pv_action = jai_constants.updating and
3799: ((nvl(pr_old.shipment_number, -9999) <>
3800: nvl(pr_new.shipment_number, -9998)) and
3801: pr_new.shipment_number is not null)) then
3802:

Line 3846: IF pv_action = jai_constants.updating AND

3842: ' Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) ||
3843: ' ~ ' || TO_CHAR(pr_new.line_id));
3844: END IF;
3845:
3846: IF pv_action = jai_constants.updating AND
3847: pr_new.inventory_item_id <> pr_old.inventory_item_id THEN
3848: DELETE JAI_OM_OE_SO_LINES WHERE line_id = pr_new.line_id;
3849:
3850: DELETE JAI_OM_OE_SO_TAXES WHERE line_id = pr_new.line_id;

Line 3898: if (pv_return_code <> jai_constants.successful) then

3894: p_header_info => r_get_header_info,
3895: p_return_code => pv_return_code,
3896: p_return_message => pv_return_message);
3897:
3898: if (pv_return_code <> jai_constants.successful) then
3899: return;
3900: end if;
3901:
3902: ELSE

Line 3974: Pv_return_code := jai_constants.unexpected_error;

3970: '** Error END OF POPULATE_TAX ~ ' ||
3971: TO_CHAR(SYSDATE, 'DD/mm/rrrr hh24:mi:ss'));
3972: END IF;
3973:
3974: Pv_return_code := jai_constants.unexpected_error;
3975: Pv_return_message := 'Encountered an error in JAI_OM_TAX_PROCESSING_PKG.POPULATE_TAX ' ||
3976: substr(sqlerrm, 1, 1900);
3977: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
3978: FND_LOG.STRING(G_LEVEL_UNEXPECTED,

Line 4159: pv_return_code := jai_constants.successful;

4155: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4156: G_MODULE_NAME || v_api_name || '.BEGIN',
4157: G_PKG_NAME || ': ' || v_api_name || '()+');
4158: END IF;
4159: pv_return_code := jai_constants.successful;
4160:
4161: v_line_id := pr_new.line_id;
4162: v_header_id := pr_new.header_id;
4163: v_warehouse_id := pr_new.SHIP_FROM_ORG_ID;

Line 4301: pv_return_code := jai_constants.successful;

4297: WHERE line_id = v_line_id;
4298:
4299: cur_rec_get_assessable_value rec_get_assessable_value%ROWTYPE;
4300: BEGIN
4301: pv_return_code := jai_constants.successful;
4302:
4303: if v_assessable_value IS NOT NULL THEN
4304:
4305: OPEN rec_get_assessable_value;

Line 4457: Pv_return_code := jai_constants.unexpected_error;

4453: ' RETURN_CODE = ' || pv_return_code);
4454: END IF;
4455: EXCEPTION
4456: WHEN OTHERS THEN
4457: Pv_return_code := jai_constants.unexpected_error;
4458: Pv_return_message := 'Encountered an error in JAI_OM_TAX_PROCESSING_PKG.UPDATE_TAX ' ||
4459: substr(sqlerrm, 1, 1900);
4460: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
4461: FND_LOG.STRING(G_LEVEL_UNEXPECTED,

Line 4571: pv_return_code := jai_constants.successful;

4567: G_MODULE_NAME || v_api_name || '.BEGIN',
4568: G_PKG_NAME || ': ' || v_api_name || '()+');
4569: END IF;
4570:
4571: pv_return_code := jai_constants.successful;
4572:
4573: OPEN Get_Count;
4574: FETCH Get_Count
4575: INTO v_exist_ship;

Line 4578: pv_action = jai_constants.inserting THEN

4574: FETCH Get_Count
4575: INTO v_exist_ship;
4576: CLOSE Get_Count;
4577: If pr_new.item_type_code = 'CONFIG' and pr_new.ato_line_id is not null AND
4578: pv_action = jai_constants.inserting THEN
4579: OPEN cur_chk_item_dtls(pr_new.SHIP_from_ORG_ID,
4580: pr_new.inventory_item_id);
4581: FETCH cur_chk_item_dtls
4582: INTO ln_item_exists;

Line 4607: pn_regime_code => jai_constants.vat_regime);

4603: jai_inv_items_pkg.copy_items(pn_organization_id => pr_new.SHIP_from_ORG_ID,
4604: pn_inventory_item_id => pr_new.inventory_item_id,
4605: pn_source_organization_id => ln_organization_id,
4606: pn_source_inventory_item_id => ln_inventory_item_id,
4607: pn_regime_code => jai_constants.vat_regime);
4608:
4609: END IF;
4610: END IF;
4611:

Line 4631: IF pv_action IN (jai_constants.INSERTING, jai_constants.UPDATING) AND

4627: 'PO' 'Customer PO India'
4628:
4629: */
4630:
4631: IF pv_action IN (jai_constants.INSERTING, jai_constants.UPDATING) AND
4632: pr_new.reference_header_id IS NOT NULL THEN
4633:
4634: OPEN cur_get_delivery_detail_id;
4635: FETCH cur_get_delivery_detail_id

Line 4743: Pv_return_code := jai_constants.unexpected_error;

4739: ' RETURN_CODE = ' || pv_return_code);
4740: END IF;
4741: EXCEPTION
4742: WHEN OTHERS THEN
4743: Pv_return_code := jai_constants.unexpected_error;
4744: Pv_return_message := 'Encountered an error in JAI_OM_TAX_PROCESSING_PKG.DEFAULT_TAX ' ||
4745: substr(sqlerrm, 1, 1900);
4746: IF (G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
4747: FND_LOG.STRING(G_LEVEL_UNEXPECTED,