DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_OM_OE_GEN_TAXINV_T

Line 1732: FROM JAI_OM_OE_GEN_TAXINV_T

1728: AND location_id = cp_location_id;
1729:
1730: CURSOR c_excise_invoice_not_done ( cp_Delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE)IS
1731: SELECT 1
1732: FROM JAI_OM_OE_GEN_TAXINV_T
1733: WHERE delivery_id = cp_delivery_id;
1734:
1735: ln_excise_invoice_not_done NUMBER;
1736:

Line 1902: || It means the delivery is still existing in the JAI_OM_OE_GEN_TAXINV_T table

1898: END IF;
1899:
1900: IF ln_excise_invoice_not_done = 1 THEN
1901: /*
1902: || It means the delivery is still existing in the JAI_OM_OE_GEN_TAXINV_T table
1903: || It means that the excise invoice generation was either not processed or errored out.
1904: || We need to raise an error saying that excise invoice number needs to be run before VAT processing can happen.
1905: */
1906: lv_inv_gen_process_flag := jai_constants.expected_error;

Line 1920: || Control comes here - It means record for the delivery does not exist in the JAI_OM_OE_GEN_TAXINV_T table

1916: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
1917: goto NEXTDELIVERY;
1918: ELSE
1919: /*
1920: || Control comes here - It means record for the delivery does not exist in the JAI_OM_OE_GEN_TAXINV_T table
1921: because of reasons such as :
1922: || a. Delivery does not have excise taxes
1923: || b. Explicit setting such as bond register is set to DOMESTIC_WITHOUT_EXCISE or EXPORT_WITHOUT_EXCISE
1924: || c. The item itself is not excisable , hence no excise invoice num is generated.