[Home] [Help]
623:
624: These check also needs to be implemented at shipping level
625:
626: Solution:-
627: Created the procedure jai_om_utils_pkg.validate_excise_exemption to validate all the above conditions and called the same
628: with the relevent parameters. This has resolved the issue
629:
630: Dependency Due To The Current Bug :
631: 1. This trigger ja_in_wsh_dlry_au_rel_stat_trg.sql (618.1) call the
628: with the relevent parameters. This has resolved the issue
629:
630: Dependency Due To The Current Bug :
631: 1. This trigger ja_in_wsh_dlry_au_rel_stat_trg.sql (618.1) call the
632: function ->jai_om_utils_pkg.validate_excise_exemption(618.1) and hence has dependencies
633:
634: 8. ssumaith - Bug#3441684 file version 618.2 : 20-feb-04
635:
636: After match receipts is done for a delivery , when back-ordering is performed, the delivery
804:
805: -- Start Of Bug #3392528,
806: /*
807: This code has been added by aiyer for the bug 3392528.
808: Call the function jai_om_utils_pkg.validate_excise_exemption to validate the different valid combination of values
809: that can exists between JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the
810: table JAI_OM_OE_SO_TAXES
811: */
812:
813: OPEN c_chk_exc_exmpt_rule;
814: FETCH c_chk_exc_exmpt_rule INTO lv_excise_exempt_type,ln_line_number,ln_shipment_line_number,v_quantity;
815: CLOSE c_chk_exc_exmpt_rule ;
816:
817: lv_ret_flag := jai_om_utils_pkg.validate_excise_exemption (
818: p_line_id => pr_new.source_line_id ,
819: p_excise_exempt_type => lv_excise_exempt_type ,
820: p_line_number => ln_line_number ,
821: p_shipment_line_number => ln_shipment_line_number ,