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

Line 24: pv_return_code := jai_constants.successful ;

20: Where delivery_detail_id = v_delivery_detail_id;
21:
22:
23: BEGIN
24: pv_return_code := jai_constants.successful ;
25:
26: v_DELIVERY_DETAIL_ID := pr_old.DELIVERY_DETAIL_ID;
27: x := 0;
28:

Line 109: pv_return_code := jai_constants.successful ;

105: REM +======================================================================+
106: */
107: PROCEDURE ARU_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
108: BEGIN
109: pv_return_code := jai_constants.successful ;
110: /*------------------------------------------------------------------------------------------
111: FILENAME: ja_in_receipts_match_trg.sql
112:
113: CHANGE HISTORY:

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

419: WHERE jstl.line_id = cp_line_id
420: AND jstl.header_id = cp_header_id
421: AND jtc.tax_id = jstl.tax_id
422: AND jtc.tax_type = tax_types.tax_type
423: AND tax_types.regime_code = jai_constants.vat_regime;
424:
425: CURSOR cur_chk_org_loc_setup (cp_organization_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
426: cp_location_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE
427: )

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

431: JAI_RGM_DEFINITIONS rgms
432: WHERE rgmpt.regime_id = rgms.regime_id
433: AND rgmpt.location_id = cp_location_id
434: AND rgmpt.organization_id = cp_organization_id
435: AND rgms.regime_code = jai_constants.vat_regime;
436:
437: /*
438: ||End of bug 4245073
439: */

Line 465: pv_return_code := jai_constants.successful ;

461:
462: /* End of bug 5631784*/
463:
464: BEGIN
465: pv_return_code := jai_constants.successful ;
466: /***************************************************************************************************************************************************
467:
468: Change History :
469:

Line 693: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || pr_new.Source_line_id ; return ;

689: CLOSE c_ja_in_so_tax_lines_tax_amt;
690:
691: IF NVL(v_line_tax_amount,0) <> NVL(v_sum_tax_amount,0) THEN
692: /* RAISE_APPLICATION_ERROR(-20405,'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || pr_new.Source_line_id);
693: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not matching in JAI_OM_OE_SO_LINES and JA_IN_SO_TAX_LINE FOR LINE_ID ' || pr_new.Source_line_id ; return ;
694: END IF;
695: -- ends here bug # 2689417
696:
697: -- Start Of Bug #3392528,

Line 718: /* raise_application_error(-20406, lv_error_msg ); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_msg ; return ;

714: p_error_msg => lv_error_msg
715: ) ;
716: IF nvl(lv_ret_flag,'S') = 'EE' THEN
717: /* Handle all expected errors in this section. */
718: /* raise_application_error(-20406, lv_error_msg ); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_msg ; return ;
719:
720: ELSIF nvl(lv_ret_flag,'S') = 'UE' THEN
721: /* Handle all unexpected errors in this section. */
722: /* raise_application_error(-20406, lv_error_msg );

Line 723: */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_msg ; return ;

719:
720: ELSIF nvl(lv_ret_flag,'S') = 'UE' THEN
721: /* Handle all unexpected errors in this section. */
722: /* raise_application_error(-20406, lv_error_msg );
723: */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_msg ; return ;
724: END IF ;
725: -- End Of Bug #3392528
726:
727: OPEN location_cursor;

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

759: ,EXCEPTION_TEXT => 'Organization-Location setup does not exist at regime level'
760: );
761: END IF;
762:
763: jai_inv_items_pkg.jai_get_attrib ( p_regime_code => jai_constants.vat_regime
764: , p_organization_id => pr_new.organization_id
765: , p_inventory_item_id => pr_new.inventory_item_id
766: , p_attribute_code => jai_constants.rgm_attr_item_applicable
767: , p_attribute_value => lv_applicable

Line 766: , p_attribute_code => jai_constants.rgm_attr_item_applicable

762:
763: jai_inv_items_pkg.jai_get_attrib ( p_regime_code => jai_constants.vat_regime
764: , p_organization_id => pr_new.organization_id
765: , p_inventory_item_id => pr_new.inventory_item_id
766: , p_attribute_code => jai_constants.rgm_attr_item_applicable
767: , p_attribute_value => lv_applicable
768: , p_process_flag => lv_process_flag
769: , p_process_msg => lv_process_message
770: );

Line 771: IF lv_process_flag = jai_constants.successful

767: , p_attribute_value => lv_applicable
768: , p_process_flag => lv_process_flag
769: , p_process_msg => lv_process_message
770: );
771: IF lv_process_flag = jai_constants.successful
772: AND nvl(lv_applicable,'N') = 'N' THEN
773: /*
774: ||item is not vatable
775: */

Line 781: ELSIF lv_process_flag <> jai_constants.successful THEN

777: ,EXCEPTION_CODE => NULL
778: ,EXCEPTION_TEXT => 'An item which is not Vatable has VAT Taxes attached.
779: Please correct the item attribute or remove the VAT type of taxes'
780: );
781: ELSIF lv_process_flag <> jai_constants.successful THEN
782: app_exception.raise_exception( EXCEPTION_TYPE => 'APP'
783: ,EXCEPTION_CODE => NULL
784: ,EXCEPTION_TEXT => substr (lv_process_message,1,999)
785: );

Line 812: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Mandatory India Localization Sub-inventory Setup not done for this Location from where shipment is made' ; return ;

808: if nvl(pr_new.Released_status,'N') = 'C' then
809:
810: IF v_location_id IS NULL and v_container_item_flag ='N' then
811: /* raise_application_error(-20406, 'Mandatory India Localization Sub-inventory Setup not done for this Location from where shipment is made');
812: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Mandatory India Localization Sub-inventory Setup not done for this Location from where shipment is made' ; return ;
813: end if ;
814: end if;
815: -- ends here - Bug # 2928261
816:

Line 859: pv_return_code := jai_constants.expected_error ; pv_return_message := 'Matched Quantity -- ' || TO_CHAR(NVL(v_matched_qty,0)) ||

855: IF nvl(pr_new.Released_status,'N') = 'C' THEN
856: IF nvl(v_shipped_quantity,0) <> nvl(v_matched_qty,0) THEN
857: /* raise_application_error(-20401, 'Matched Quantity -- ' || TO_CHAR(NVL(v_matched_qty,0)) ||
858: ' should be equal to Shipped Quantity -- ' || TO_CHAR(NVL(v_shipped_quantity,0))); */
859: pv_return_code := jai_constants.expected_error ; pv_return_message := 'Matched Quantity -- ' || TO_CHAR(NVL(v_matched_qty,0)) ||
860: ' should be equal to Shipped Quantity -- ' || TO_CHAR(NVL(v_shipped_quantity,0)); return ;
861:
862: END IF;
863: END IF;

Line 870: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Please Unmatch the Delivery prior to backordering ' ; return ;

866: if nvl(pr_new.Released_status,'N') = 'B' then
867: -- if v_matched_qty = v_quantity and v_matched_qty is not null then
868: if nvl(v_matched_qty,0) > 0 then
869: /* raise_application_error (-20402, 'Please Unmatch the Delivery prior to backordering ');
870: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Please Unmatch the Delivery prior to backordering ' ; return ;
871: end if ;
872: end if;
873: -- ends here additions by sriram - bug# 3441684
874: END IF;

Line 901: ); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'LC Matched Quantity -- ' || TO_CHAR(NVL(v_lc_qty_matched,0)) ||

897:
898: IF NVL(v_lc_qty_matched,-999) <> NVL(v_lc_shipped_qty,-888) THEN
899: /* raise_application_error(-20401, 'LC Matched Quantity -- ' || TO_CHAR(NVL(v_lc_qty_matched,0)) ||
900: ' should be equal to Shipped Quantity -- ' || TO_CHAR(NVL(v_lc_shipped_qty,0)) || ' for LC enabled Orders'
901: ); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'LC Matched Quantity -- ' || TO_CHAR(NVL(v_lc_qty_matched,0)) ||
902: ' should be equal to Shipped Quantity -- ' || TO_CHAR(NVL(v_lc_shipped_qty,0)) || ' for LC enabled Orders'
903: ; return ;
904: END IF;
905:

Line 956: p_event => jai_constants.wsh_ship_confirm ,

952: pv_log_msg => ' Before call to jai_ar_tcs_rep_pkg.process_transactions .'
953: );*/ --commented by bgowrava for Bug #5631784
954:
955: jai_ar_tcs_rep_pkg.process_transactions ( p_ooh => tab_ooh ,
956: p_event => jai_constants.wsh_ship_confirm ,
957: p_process_flag => lv_process_flag ,
958: p_process_message => lv_process_message
959: );
960:

Line 965: IF lv_process_flag = jai_constants.expected_error OR ---------A2

961: /*jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
962: pv_log_msg => ' returned from jai_ar_tcs_rep_pkg.process_transactions .'
963: );*/ --commented by bgowrava for Bug #5631784
964:
965: IF lv_process_flag = jai_constants.expected_error OR ---------A2
966: lv_process_flag = jai_constants.unexpected_error
967: THEN
968: /*
969: || As Returned status is an error hence:-

Line 966: lv_process_flag = jai_constants.unexpected_error

962: pv_log_msg => ' returned from jai_ar_tcs_rep_pkg.process_transactions .'
963: );*/ --commented by bgowrava for Bug #5631784
964:
965: IF lv_process_flag = jai_constants.expected_error OR ---------A2
966: lv_process_flag = jai_constants.unexpected_error
967: THEN
968: /*
969: || As Returned status is an error hence:-
970: || Set out variables p_process_flag and p_process_message accordingly

Line 989: IF lv_process_flag = jai_constants.unexpected_error THEN

985:
986:
987: EXCEPTION
988: WHEN le_error THEN
989: IF lv_process_flag = jai_constants.unexpected_error THEN
990: lv_process_message := substr (lv_process_message || ' Object = ja_in_wsh_dlry_au_rel_stat_trg ', 1,1999) ;
991: END IF;
992:
993:

Line 1495: AND upper(jtc.tax_type) in (upper(jai_constants.tax_type_cvd_edu_cess), upper(jai_constants.tax_type_exc_edu_cess));

1491: (SELECT delivery_detail_id
1492: FROM JAI_OM_WSH_LINES_ALL
1493: WHERE delivery_id = cp_delivery_id
1494: )
1495: AND upper(jtc.tax_type) in (upper(jai_constants.tax_type_cvd_edu_cess), upper(jai_constants.tax_type_exc_edu_cess));
1496:
1497:
1498: -- start, Bgowrava for forward porting bug#5989740
1499:

Line 1513: AND upper(jtc.tax_type) in (upper(jai_constants.tax_type_sh_exc_edu_cess),

1509: (SELECT delivery_detail_id
1510: FROM JAI_OM_WSH_LINES_ALL
1511: WHERE delivery_id = cp_delivery_id
1512: )
1513: AND upper(jtc.tax_type) in (upper(jai_constants.tax_type_sh_exc_edu_cess),
1514: upper(jai_constants.tax_type_sh_cvd_edu_cess)
1515: );
1516: -- end, Bgowrava for forward porting bug#5989740
1517:

Line 1514: upper(jai_constants.tax_type_sh_cvd_edu_cess)

1510: FROM JAI_OM_WSH_LINES_ALL
1511: WHERE delivery_id = cp_delivery_id
1512: )
1513: AND upper(jtc.tax_type) in (upper(jai_constants.tax_type_sh_exc_edu_cess),
1514: upper(jai_constants.tax_type_sh_cvd_edu_cess)
1515: );
1516: -- end, Bgowrava for forward porting bug#5989740
1517:
1518:

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

1536: , jai_regime_tax_types_v tax_types
1537: WHERE jsptl.delivery_detail_id = cp_del_det_id
1538: AND jtc.tax_id = jsptl.tax_id
1539: AND jtc.tax_type = tax_types.tax_type
1540: AND tax_types.regime_code = jai_constants.vat_regime;
1541:
1542: CURSOR cur_get_regime_info (cp_organization_id JAI_RGM_ORG_REGNS_V.ORGANIZATION_ID%TYPE ,
1543: cp_location_id JAI_RGM_ORG_REGNS_V.LOCATION_ID%TYPE
1544: )

Line 1551: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary

1547: attribute_value
1548: FROM JAI_RGM_ORG_REGNS_V orrg
1549: WHERE orrg.organization_id = cp_organization_id
1550: AND orrg.location_id = cp_location_id
1551: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary
1552: AND attribute_code = jai_constants.attr_code_regn_no
1553: AND regime_code = jai_constants.vat_regime;
1554:
1555: CURSOR cur_chk_vat_proc_entry (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE)

Line 1552: AND attribute_code = jai_constants.attr_code_regn_no

1548: FROM JAI_RGM_ORG_REGNS_V orrg
1549: WHERE orrg.organization_id = cp_organization_id
1550: AND orrg.location_id = cp_location_id
1551: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary
1552: AND attribute_code = jai_constants.attr_code_regn_no
1553: AND regime_code = jai_constants.vat_regime;
1554:
1555: CURSOR cur_chk_vat_proc_entry (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE)
1556: IS

Line 1553: AND regime_code = jai_constants.vat_regime;

1549: WHERE orrg.organization_id = cp_organization_id
1550: AND orrg.location_id = cp_location_id
1551: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary
1552: AND attribute_code = jai_constants.attr_code_regn_no
1553: AND regime_code = jai_constants.vat_regime;
1554:
1555: CURSOR cur_chk_vat_proc_entry (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE)
1556: IS
1557: SELECT 1

Line 1586: --lv_process_flag jai_constants.successful%type;

1582:
1583:
1584: /** Bgowrava for forward porting Bug#5631784 */
1585: ln_tcs_exists number;
1586: --lv_process_flag jai_constants.successful%type;
1587: ln_threshold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
1588: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
1589: ln_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%type;
1590: ln_last_line_no number;

Line 1626: pv_return_code := jai_constants.successful ;

1622: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
1623:
1624:
1625: BEGIN
1626: pv_return_code := jai_constants.successful ;
1627: /*------------------------------------------------------------------------------------------
1628: FILENAME: JA_IN_WSH_DLRY_DTLS_AU_TRG.sql CHANGE HISTORY:
1629: SlNo. DD/MM/YYYY Author and Details of Modifications
1630: ------------------------------------------------------------------------------------------

Line 2002: v_debug_flag := jai_constants.no;

1998: v_tax_amt := 0;
1999: v_base_tax_amt := 0;
2000: v_func_tax_amt := 0;
2001: counter :=0;
2002: v_debug_flag := jai_constants.no;
2003: v_conversion_rate := 0;
2004: v_matched_qty := 0;
2005: v_lc_shipped_qty := pr_new.Shipped_quantity;
2006:

Line 2010: pv_return_code := jai_constants.successful ;

2006:
2007:
2008: IF v_debug_flag ='Y' THEN
2009: BEGIN
2010: pv_return_code := jai_constants.successful ;
2011: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,
2012: Value,SUBSTR (value,1,INSTR(value,',') -1))
2013: INTO v_utl_location
2014: FROM v$parameter

Line 2137: ' should be equal to Shipped Quantity -- ' || TO_CHAR(NVL(v_shipped_quantity,0))); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Matched Quantity -- ' || TO_CHAR(NVL(v_matched_qty,0)) ||

2133: FETCH matched_receipt_cur1 INTO v_matched_qty;
2134: CLOSE matched_receipt_cur1;
2135: IF NVL(v_shipped_quantity,0) <> NVL(v_matched_qty,0) THEN
2136: /* RAISE_APPLICATION_ERROR(-20401, 'Matched Quantity -- ' || TO_CHAR(NVL(v_matched_qty,0)) ||
2137: ' should be equal to Shipped Quantity -- ' || TO_CHAR(NVL(v_shipped_quantity,0))); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Matched Quantity -- ' || TO_CHAR(NVL(v_matched_qty,0)) ||
2138: ' should be equal to Shipped Quantity -- ' || TO_CHAR(NVL(v_shipped_quantity,0)) ; return ;
2139:
2140: END IF;
2141: END IF;

Line 2156: pv_return_code := jai_constants.expected_error ; pv_return_message := 'LC Matched Quantity -- ' || TO_CHAR(NVL(v_lc_qty_matched,0)) ||

2152: CLOSE C_MATCHED_QTY_CUR;
2153: IF NVL(v_lc_qty_matched,-999) <> NVL(v_lc_shipped_qty,-888) THEN
2154: /* RAISE_APPLICATION_ERROR(-20120, 'LC Matched Quantity -- ' || TO_CHAR(NVL(v_lc_qty_matched,0)) ||
2155: ' should be equal to Shipped Quantity -- ' || TO_CHAR(NVL(v_lc_shipped_qty,0)) || ' for LC enabled Orders'); */
2156: pv_return_code := jai_constants.expected_error ; pv_return_message := 'LC Matched Quantity -- ' || TO_CHAR(NVL(v_lc_qty_matched,0)) ||
2157: ' should be equal to Shipped Quantity -- ' || TO_CHAR(NVL(v_lc_shipped_qty,0)) || ' for LC enabled Orders' ; return ;
2158: END IF;
2159:
2160: /* Start, bug#5680459 csahoo

Line 2407: open c_chk_rgm_tax_exists ( cp_regime_code => jai_constants.tcs_regime

2403: */
2404:
2405: ln_tcs_exists := 0; --kunkumar for bug#5604375 and 6066750
2406: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Checking if TCS type of tax exists?'); */ --commented by bgowrava for bug#5631784
2407: open c_chk_rgm_tax_exists ( cp_regime_code => jai_constants.tcs_regime
2408: , cp_delivery_detail_id => v_delivery_detail_id
2409: );
2410: fetch c_chk_rgm_tax_exists into ln_tcs_exists;
2411: close c_chk_rgm_tax_exists ;

Line 2418: open c_get_regime_id (cp_regime_code => jai_constants.tcs_regime);

2414: if nvl(ln_tcs_exists,0) >0 then --kunkumar for bug#5604375 and 6066750
2415: /* TCS type of tax is present */
2416: fnd_file.put_line(FND_FILE.LOG,'Localization' );
2417:
2418: open c_get_regime_id (cp_regime_code => jai_constants.tcs_regime);
2419: fetch c_get_regime_id into ln_tcs_regime_id;
2420: close c_get_regime_id;
2421: /* Find out what is the current slab */
2422: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Get threshold_slab_id. Before calling JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID');*/ --commented by bgowrava for bug#5631784

Line 2427: , p_party_type => jai_constants.party_type_customer

2423: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
2424: (
2425: p_regime_id => ln_tcs_regime_id
2426: , p_organization_id => v_organization_id
2427: , p_party_type => jai_constants.party_type_customer
2428: , p_party_id => v_customer_id
2429: , p_org_id => v_org_id
2430: , p_source_trx_date => v_date_confirmed
2431: , p_threshold_slab_id => ln_threshold_slab_id

Line 2441: if lv_process_flag <> jai_constants.successful then

2437: 'lv_process_flag =' ||lv_process_flag||chr(10)
2438: ||'lv_process_message =' ||lv_process_message
2439: ); */ --commented by bgowrava for bug#5631784
2440:
2441: if lv_process_flag <> jai_constants.successful then
2442: app_exception.raise_exception
2443: (exception_type => 'APP'
2444: ,exception_code => -20275
2445: ,exception_text => lv_process_message

Line 2467: if lv_process_flag <> jai_constants.successful then

2463: ||'lv_process_message =' ||lv_process_message
2464: ); */ --commented by bgowrava for bug#5631784
2465:
2466:
2467: if lv_process_flag <> jai_constants.successful then
2468: app_exception.raise_exception
2469: (exception_type => 'APP'
2470: ,exception_code => -20275
2471: ,exception_text => lv_process_message

Line 2488: and jtc.tax_type = jai_constants.tax_type_tcs;

2484: from JAI_OM_WSH_LINE_TAXES jsptl
2485: , JAI_CMN_TAXES_ALL jtc
2486: where jsptl.delivery_detail_id = v_delivery_detail_id
2487: and jsptl.tax_id = jtc.tax_id
2488: and jtc.tax_type = jai_constants.tax_type_tcs;
2489:
2490: /*
2491: ||Call the helper method to default surcharge taxes on top of the SO taxes using the tax category
2492: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category

Line 2502: , p_source_event => jai_constants.source_ttype_delivery

2498: jai_rgm_thhold_proc_pkg.default_thhold_taxes
2499: (
2500: p_source_trx_id => ''
2501: , p_source_trx_line_id => v_delivery_detail_id
2502: , p_source_event => jai_constants.source_ttype_delivery
2503: , p_action => jai_constants.default_taxes
2504: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
2505: , p_tax_base_line_number => ln_base_line_no
2506: , p_last_line_number => ln_last_line_no

Line 2503: , p_action => jai_constants.default_taxes

2499: (
2500: p_source_trx_id => ''
2501: , p_source_trx_line_id => v_delivery_detail_id
2502: , p_source_event => jai_constants.source_ttype_delivery
2503: , p_action => jai_constants.default_taxes
2504: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
2505: , p_tax_base_line_number => ln_base_line_no
2506: , p_last_line_number => ln_last_line_no
2507: , p_currency_code => v_currency_code

Line 2525: if lv_process_flag <> jai_constants.successful then

2521: ,'lv_process_flag =' ||lv_process_flag||chr(10)
2522: ||'lv_process_message =' ||lv_process_message
2523: ); */ --commented by bgowrava for bug#5631784
2524:
2525: if lv_process_flag <> jai_constants.successful then
2526: app_exception.raise_exception
2527: (exception_type => 'APP'
2528: ,exception_code => -20275
2529: ,exception_text => lv_process_message

Line 2759: lv_vat_invoice_no := jai_constants.not_applicable ;

2755: /*
2756: || VAT invoice number should be punched as 'NA' and accounting should happen
2757: || when 'VAT REVERSAL' type of tax exist and 'VAT' type of tax(es) doesn't exist
2758: */
2759: lv_vat_invoice_no := jai_constants.not_applicable ;
2760: lv_vat_inv_gen_status := 'C' ;
2761: END IF ;
2762:
2763: /*

Line 2821: jai_constants.party_type_customer,

2817: null , -- program_id
2818: null , -- program_update_date
2819: pr_new.customer_id ,
2820: v_ship_to_org_id ,
2821: jai_constants.party_type_customer,
2822: v_creation_date ,
2823: v_created_by ,
2824: v_last_update_date ,
2825: v_last_update_login ,

Line 2879: IF lv_process_flag = jai_constants.expected_error OR ---------A2

2875: /* jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2876: pv_log_msg => ' Returned from jai_ar_tcs_rep_pkg.wsh_interim_accounting '
2877: ); */ --commented by bgowrava for bug#5631784
2878:
2879: IF lv_process_flag = jai_constants.expected_error OR ---------A2
2880: lv_process_flag = jai_constants.unexpected_error
2881: THEN
2882: /*
2883: || As Returned status is an error/not applicable hence:-

Line 2880: lv_process_flag = jai_constants.unexpected_error

2876: pv_log_msg => ' Returned from jai_ar_tcs_rep_pkg.wsh_interim_accounting '
2877: ); */ --commented by bgowrava for bug#5631784
2878:
2879: IF lv_process_flag = jai_constants.expected_error OR ---------A2
2880: lv_process_flag = jai_constants.unexpected_error
2881: THEN
2882: /*
2883: || As Returned status is an error/not applicable hence:-
2884: || Set out variables p_process_flag and p_process_message accordingly

Line 3162: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Bonded Register Validity has Expired on ' || v_reg_exp_date ; return ;

3158:
3159: -- added logic to check if the register validity is ok
3160: IF nvl(v_reg_exp_date,sysdate) < sysdate then
3161: /* RAISE_APPLICATION_ERROR(-20122, 'Bonded Register Validity has Expired on ' || v_reg_exp_date);
3162: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Bonded Register Validity has Expired on ' || v_reg_exp_date ; return ;
3163: end if;
3164: -- added the letter of undertaking comparison in the following if.
3165: -- logic is : to check if it is a letter of undertaking and only then if balance is a problem , raise an error
3166: v_tot_excise_amt := v_tot_excise_amt * v_curr_conv_rate; /* ssumaith - bug#6487667*/

Line 3170: || TO_CHAR(v_tot_excise_amt)); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Bonded Register Has Balance -> '|| TO_CHAR(v_register_balance) || ' ,which IS less than Excisable Amount -> '

3166: v_tot_excise_amt := v_tot_excise_amt * v_curr_conv_rate; /* ssumaith - bug#6487667*/
3167: IF NVL(v_register_balance,0) < NVL(v_tot_excise_amt,0) and nvl(v_lou_flag,'N') = 'N' THEN
3168: /* RAISE_APPLICATION_ERROR(-20120, 'Bonded Register Has Balance -> '
3169: || TO_CHAR(v_register_balance) || ' ,which IS less than Excisable Amount -> '
3170: || TO_CHAR(v_tot_excise_amt)); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Bonded Register Has Balance -> '|| TO_CHAR(v_register_balance) || ' ,which IS less than Excisable Amount -> '
3171: || TO_CHAR(v_tot_excise_amt) ; return ;
3172: END IF;
3173: END IF;
3174: END IF;

Line 3181: /* raise_application_error (-20001,substr(sqlerrm,1,200)); */ pv_return_code := jai_constants.expected_error ; pv_return_message := substr(sqlerrm,1,200) ; return ;

3177: -- end
3178: ---------------------------------------------------------------------------------------
3179: Exception
3180: When Others then
3181: /* raise_application_error (-20001,substr(sqlerrm,1,200)); */ pv_return_code := jai_constants.expected_error ; pv_return_message := substr(sqlerrm,1,200) ; return ;
3182:
3183: END ARU_T3 ;
3184:
3185: END JAI_OM_WDD_TRIGGER_PKG ;