[Home] [Help]
545:
546: These check also needs to be implemented at shipping level
547:
548: Solution:-
549: Created the procedure jai_om_utils_pkg.validate_excise_exemption to validate all the above conditions and called the same
550: with the relevent parameters. This has resolved the issue
551:
552: Dependency Due To The Current Bug :
553: 1. This trigger ja_in_wsh_dlry_au_rel_stat_trg.sql (618.1) call the
550: with the relevent parameters. This has resolved the issue
551:
552: Dependency Due To The Current Bug :
553: 1. This trigger ja_in_wsh_dlry_au_rel_stat_trg.sql (618.1) call the
554: function ->jai_om_utils_pkg.validate_excise_exemption(618.1) and hence has dependencies
555:
556: 8. ssumaith - Bug#3441684 file version 618.2 : 20-feb-04
557:
558: After match receipts is done for a delivery , when back-ordering is performed, the delivery
696:
697: -- Start Of Bug #3392528,
698: /*
699: This code has been added by aiyer for the bug 3392528.
700: Call the function jai_om_utils_pkg.validate_excise_exemption to validate the different valid combination of values
701: that can exists between JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the
702: table JAI_OM_OE_SO_TAXES
703: */
704:
705: OPEN c_chk_exc_exmpt_rule;
706: FETCH c_chk_exc_exmpt_rule INTO lv_excise_exempt_type,ln_line_number,ln_shipment_line_number,v_quantity;
707: CLOSE c_chk_exc_exmpt_rule ;
708:
709: lv_ret_flag := jai_om_utils_pkg.validate_excise_exemption (
710: p_line_id => pr_new.source_line_id ,
711: p_excise_exempt_type => lv_excise_exempt_type ,
712: p_line_number => ln_line_number ,
713: p_shipment_line_number => ln_shipment_line_number ,