[Home] [Help]
524:
525:
526: FUNCTION validate_excise_exemption
527: (
528: p_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE ,
529: p_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ,
530: p_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ,
531: p_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ,
532: p_error_msg OUT NOCOPY VARCHAR2
525:
526: FUNCTION validate_excise_exemption
527: (
528: p_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE ,
529: p_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ,
530: p_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ,
531: p_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ,
532: p_error_msg OUT NOCOPY VARCHAR2
533: )
526: FUNCTION validate_excise_exemption
527: (
528: p_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE ,
529: p_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ,
530: p_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ,
531: p_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ,
532: p_error_msg OUT NOCOPY VARCHAR2
533: )
534: RETURN VARCHAR2
527: (
528: p_line_id JAI_OM_OE_SO_LINES.LINE_ID%TYPE ,
529: p_excise_exempt_type JAI_OM_OE_SO_LINES.EXCISE_EXEMPT_TYPE%TYPE ,
530: p_line_number JAI_OM_OE_SO_LINES.LINE_NUMBER%TYPE ,
531: p_shipment_line_number JAI_OM_OE_SO_LINES.SHIPMENT_LINE_NUMBER%TYPE ,
532: p_error_msg OUT NOCOPY VARCHAR2
533: )
534: RETURN VARCHAR2
535: /***************************************************************************************************************************************************************
540:
541: Bug : 3436541
542:
543: Purpose : This function validates the different valid combination of values that can exist between
544: JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the table JAI_OM_OE_SO_TAXES
545:
546: A sales order In India Localization Order Management should be allowed to be shipped only when the
547: following conditions are satisfied: -
548: 1. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like
544: JAI_OM_OE_SO_LINES.excise_exempt_type and tax types associated with the table JAI_OM_OE_SO_TAXES
545:
546: A sales order In India Localization Order Management should be allowed to be shipped only when the
547: following conditions are satisfied: -
548: 1. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like
549: 'EXCISE_EXEMPT_CERT', 'CT2','CT3' should not have Modvat Receovery type of taxes attached
550: ( table JAI_OM_OE_SO_TAXES)
551:
552: 2. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like
548: 1. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like
549: 'EXCISE_EXEMPT_CERT', 'CT2','CT3' should not have Modvat Receovery type of taxes attached
550: ( table JAI_OM_OE_SO_TAXES)
551:
552: 2. A Sales order with excise exemption types (field JAI_OM_OE_SO_LINES.excise_exempt_type) like
553: 'EXCISE_EXEMPT_CERT_OTH', 'CT2_OTH' should have modvat recovery type of tax attached
554: ( table JAI_OM_OE_SO_TAXES)
555:
556: 3. A sales order which does not have any excise exemptions specified (Null value for field
553: 'EXCISE_EXEMPT_CERT_OTH', 'CT2_OTH' should have modvat recovery type of tax attached
554: ( table JAI_OM_OE_SO_TAXES)
555:
556: 3. A sales order which does not have any excise exemptions specified (Null value for field
557: JAI_OM_OE_SO_LINES.excise_exempt_type) should not have any Modvat Recovery type of taxes
558: ( table JAI_OM_OE_SO_TAXES).
559:
560: This function returns an error when any of the above conditions are not satisified.
561: