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_CMN_RGM_PROCESSING_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 1574: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,

1570: retcode OUT NOCOPY VARCHAR2,
1571: errbuf OUT NOCOPY VARCHAR2,
1572: p_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE,
1573: p_registration_num JAI_RGM_TRX_RECORDS.REGIME_PRIMARY_REGNO%TYPE,
1574: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
1575: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
1576: p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
1577: p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
1578: pv_delivery_date_from VARCHAR2, --DATE, Harshita for Bug 4918870

Line 1575: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,

1571: errbuf OUT NOCOPY VARCHAR2,
1572: p_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE,
1573: p_registration_num JAI_RGM_TRX_RECORDS.REGIME_PRIMARY_REGNO%TYPE,
1574: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
1575: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
1576: p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
1577: p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
1578: pv_delivery_date_from VARCHAR2, --DATE, Harshita for Bug 4918870
1579: pv_delivery_date_to VARCHAR2, --DATE, Harshita for Bug 4918870

Line 1576: p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,

1572: p_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE,
1573: p_registration_num JAI_RGM_TRX_RECORDS.REGIME_PRIMARY_REGNO%TYPE,
1574: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
1575: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
1576: p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
1577: p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
1578: pv_delivery_date_from VARCHAR2, --DATE, Harshita for Bug 4918870
1579: pv_delivery_date_to VARCHAR2, --DATE, Harshita for Bug 4918870
1580: p_process_action VARCHAR2,

Line 1577: p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,

1573: p_registration_num JAI_RGM_TRX_RECORDS.REGIME_PRIMARY_REGNO%TYPE,
1574: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
1575: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
1576: p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
1577: p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
1578: pv_delivery_date_from VARCHAR2, --DATE, Harshita for Bug 4918870
1579: pv_delivery_date_to VARCHAR2, --DATE, Harshita for Bug 4918870
1580: p_process_action VARCHAR2,
1581: p_single_invoice_num VARCHAR2,

Line 1694: ln_order_type_id JAI_OM_WSH_LINES_ALL.ORDER_TYPE_ID%TYPE;

1690: ln_failure_delivery_ctr NUMBER;
1691: ln_success_delivery_Ctr NUMBER;
1692: ln_regime_id NUMBER;
1693: lv_debug VARCHAR2(5); -- := jai_constants.no /* This should be either 'Y' or 'N' */ File.Sql.35 by Brathod
1694: ln_order_type_id JAI_OM_WSH_LINES_ALL.ORDER_TYPE_ID%TYPE;
1695: lv_inv_num_already_generated VARCHAR2(10); --:= jai_constants.value_false File.Sql.35 by Brathod
1696: ln_batch_id NUMBER;
1697: lv_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1698: ln_current_party_id NUMBER;

Line 1705: lv_Excise_invoice_no JAI_OM_WSH_LINES_ALL.EXCISE_INVOICE_NO%TYPE;

1701: ln_conc_progam_id NUMBER;
1702: ln_conc_request_id NUMBER;
1703: ln_conc_prog_appl_id NUMBER;
1704: lv_Same_invoice_no VARCHAR2(100);
1705: lv_Excise_invoice_no JAI_OM_WSH_LINES_ALL.EXCISE_INVOICE_NO%TYPE;
1706: ld_excise_invoice_date JAI_OM_WSH_LINES_ALL.EXCISE_INVOICE_DATE%TYPE;
1707: lb_completion_status BOOLEAN;
1708: ld_override_invoice_date DATE; /* aiyer for the bug 5369250 */
1709: lv_doc_type_class varchar2(2); /*kunkumar for bug #5233925*/

Line 1706: ld_excise_invoice_date JAI_OM_WSH_LINES_ALL.EXCISE_INVOICE_DATE%TYPE;

1702: ln_conc_request_id NUMBER;
1703: ln_conc_prog_appl_id NUMBER;
1704: lv_Same_invoice_no VARCHAR2(100);
1705: lv_Excise_invoice_no JAI_OM_WSH_LINES_ALL.EXCISE_INVOICE_NO%TYPE;
1706: ld_excise_invoice_date JAI_OM_WSH_LINES_ALL.EXCISE_INVOICE_DATE%TYPE;
1707: lb_completion_status BOOLEAN;
1708: ld_override_invoice_date DATE; /* aiyer for the bug 5369250 */
1709: lv_doc_type_class varchar2(2); /*kunkumar for bug #5233925*/
1710: CURSOR c_regime_cur(cp_trx_Date DATE) IS

Line 1716: CURSOR c_shipment_info(cp_Delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS

1712: FROM JAI_RGM_DEFINITIONS
1713: WHERE regime_code = jai_constants.vat_regime;
1714:
1715:
1716: CURSOR c_shipment_info(cp_Delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
1717: SELECT order_type_id , excise_invoice_no
1718: FROM JAI_OM_WSH_LINES_ALL
1719: WHERE delivery_id = cp_delivery_id;
1720:

Line 1718: FROM JAI_OM_WSH_LINES_ALL

1714:
1715:
1716: CURSOR c_shipment_info(cp_Delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
1717: SELECT order_type_id , excise_invoice_no
1718: FROM JAI_OM_WSH_LINES_ALL
1719: WHERE delivery_id = cp_delivery_id;
1720:
1721: CURSOR c_same_inv_no(cp_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE , cp_location_id JAI_OM_WSH_LINES_ALL.location_id%TYPE ) IS
1722: SELECT attribute_Value

Line 1721: CURSOR c_same_inv_no(cp_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE , cp_location_id JAI_OM_WSH_LINES_ALL.location_id%TYPE ) IS

1717: SELECT order_type_id , excise_invoice_no
1718: FROM JAI_OM_WSH_LINES_ALL
1719: WHERE delivery_id = cp_delivery_id;
1720:
1721: CURSOR c_same_inv_no(cp_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE , cp_location_id JAI_OM_WSH_LINES_ALL.location_id%TYPE ) IS
1722: SELECT attribute_Value
1723: FROM JAI_RGM_ORG_REGNS_V
1724: WHERE regime_id = p_regime_id
1725: AND attribute_type_code = jai_constants.regn_type_others

Line 1730: CURSOR c_excise_invoice_not_done ( cp_Delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE)IS

1726: AND attribute_code = jai_constants.attr_code_same_inv_no
1727: AND organization_id = cp_organization_id
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:

Line 1864: || Get the order type id and excise invoice num from the JAI_OM_WSH_LINES_ALL table for the first delivery detail of the delivery

1860: GOTO Processaccounting;
1861: END IF;
1862:
1863: /*
1864: || Get the order type id and excise invoice num from the JAI_OM_WSH_LINES_ALL table for the first delivery detail of the delivery
1865: || and pass this to the api.
1866: || make an API Call to generate the invoice number
1867: */
1868: OPEN c_shipment_info(mainrec.delivery_id);

Line 1938: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_om_wsh_lines_all for ex inv num');

1934: */
1935:
1936: IF lv_debug = 'Y' THEN
1937: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Excise Invoice number - ' || lv_vat_invoice_number || ' Will be used as VAT Invoice number for delivery : ' || mainrec.delivery_id);
1938: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_om_wsh_lines_all for ex inv num');
1939: END IF;
1940:
1941: /*
1942: || Code added by aiyer for the Bug 4534166 (fixed as a part of the bug 4523205)

Line 1945: UPDATE JAI_OM_WSH_LINES_ALL

1941: /*
1942: || Code added by aiyer for the Bug 4534166 (fixed as a part of the bug 4523205)
1943: || removed the returning clause as it was not required.
1944: */
1945: UPDATE JAI_OM_WSH_LINES_ALL
1946: SET vat_invoice_no = excise_invoice_no,
1947: vat_invoice_date = excise_invoice_date
1948: WHERE delivery_id = mainrec.delivery_id;
1949:

Line 1992: || API call again and again to the generation api . Just update the JAI_OM_WSH_LINES_ALL table to set the

1988:
1989: /*
1990: || Check if we need to generate vat invoice number and within that check if an invoice number is already generated.
1991: || if an invoice is already generated and if the parameter p_single_invoice_num is set to 'Y' then do not make an
1992: || API call again and again to the generation api . Just update the JAI_OM_WSH_LINES_ALL table to set the
1993: || vat invoice number for the delivery and continue.
1994: */
1995: /*
1996: || kunkumar - for - bug# 5233925

Line 2050: check the return status and update the JAI_OM_WSH_LINES_ALL table to set the vat invoice number

2046: IF lv_Debug = 'Y' THEN
2047: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_vat_invoice_number:' || lv_vat_invoice_number || lv_inv_gen_process_flag ||lv_inv_gen_process_message);
2048: END IF;
2049: /*
2050: check the return status and update the JAI_OM_WSH_LINES_ALL table to set the vat invoice number
2051: */
2052: IF lv_inv_gen_process_flag = jai_constants.successful THEN
2053: IF lv_vat_invoice_number IS NOT NULL THEN
2054: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;

Line 2056: UPDATE JAI_OM_WSH_LINES_ALL

2052: IF lv_inv_gen_process_flag = jai_constants.successful THEN
2053: IF lv_vat_invoice_number IS NOT NULL THEN
2054: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
2055: lv_inv_num_already_generated := jai_constants.value_true;
2056: UPDATE JAI_OM_WSH_LINES_ALL
2057: SET VAT_INVOICE_NO = lv_vat_invoice_number,
2058: VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate),
2059: LAST_UPDATE_DATE = sysdate,
2060: LAST_UPDATE_LOGIN = fnd_global.login_id,

Line 2089: || Update the vat_invoice_num field in JAI_OM_WSH_LINES_ALL table for the current delivery.

2085: */
2086: IF lv_inv_num_already_generated = jai_constants.value_true AND lv_party_has_changed = jai_constants.value_false THEN
2087: IF lv_vat_invoice_number IS NOT NULL THEN
2088: /*
2089: || Update the vat_invoice_num field in JAI_OM_WSH_LINES_ALL table for the current delivery.
2090: */
2091: UPDATE JAI_OM_WSH_LINES_ALL
2092: SET vat_invoice_no = lv_vat_invoice_number,
2093: VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate),

Line 2091: UPDATE JAI_OM_WSH_LINES_ALL

2087: IF lv_vat_invoice_number IS NOT NULL THEN
2088: /*
2089: || Update the vat_invoice_num field in JAI_OM_WSH_LINES_ALL table for the current delivery.
2090: */
2091: UPDATE JAI_OM_WSH_LINES_ALL
2092: SET vat_invoice_no = lv_vat_invoice_number,
2093: VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate),
2094: last_update_date = sysdate,
2095: last_update_login = fnd_global.login_id,

Line 2165: UPDATE JAI_OM_WSH_LINES_ALL

2161: IF lv_inv_gen_process_flag = jai_constants.successful THEN
2162: IF lv_vat_invoice_number IS NOT NULL THEN
2163: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
2164:
2165: UPDATE JAI_OM_WSH_LINES_ALL
2166: SET vat_invoice_no = lv_vat_invoice_number,
2167: vat_invoice_date = nvl(ld_override_invoice_date ,sysdate),
2168: last_update_date = sysdate,
2169: last_update_login = fnd_global.login_id,