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_RGM_INVOICE_GEN_T

Line 1600: || will be flagged as errored in the table JAI_RGM_INVOICE_GEN_T for the delivery_id

1596: || and the same value retained for this record set of same cust / cust site
1597: || a.2) If the parameter p_single_invoice_num is set to 'N' , then for each delivery a seperate vat invoice number
1598: || will be generated.
1599: || If the generate vat invoice number api returns error , then the subsection b will not be processed and the delivery
1600: || will be flagged as errored in the table JAI_RGM_INVOICE_GEN_T for the delivery_id
1601: ||
1602: || b) make a call to the api to process accounting
1603: ||
1604: || b.1 If it returns success then if the p_process_action = 'All' then flag both the fields VAT_INV_GEN_STATUS

Line 1810: FROM JAI_RGM_INVOICE_GEN_T

1806: (
1807: SELECT delivery_id , delivery_date , organization_id , location_id , vat_invoice_no,
1808: party_id , party_site_id , party_type ,
1809: vat_inv_gen_status , vat_acct_status
1810: FROM JAI_RGM_INVOICE_GEN_T
1811: WHERE regime_id = p_regime_id
1812: AND registration_num = NVL(p_registration_num,registration_num)
1813: /* Where clause has been modified to add the regime_id
1814: and p_registration_number Added by aiyer - bug# 4523205 */

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

1947: vat_invoice_date = excise_invoice_date
1948: WHERE delivery_id = mainrec.delivery_id;
1949:
1950: IF lv_debug = 'Y' THEN
1951: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_rgm_invoice_gen_t for ex inv num');
1952: END IF;
1953:
1954: UPDATE JAI_RGM_INVOICE_GEN_T
1955: SET vat_invoice_no = lv_vat_invoice_number ,

Line 1954: UPDATE JAI_RGM_INVOICE_GEN_T

1950: IF lv_debug = 'Y' THEN
1951: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before updating jai_rgm_invoice_gen_t for ex inv num');
1952: END IF;
1953:
1954: UPDATE JAI_RGM_INVOICE_GEN_T
1955: SET vat_invoice_no = lv_vat_invoice_number ,
1956: vat_inv_gen_status = 'C',
1957: vat_inv_gen_err_message = NULL , /* added the following in the update columns - srjayara for bug 4702156*/
1958: request_id = ln_conc_request_id,

Line 1968: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after updating jai_rgm_invoice_gen_t for ex inv num');

1964: WHERE Delivery_id = mainrec.delivery_id;
1965:
1966:
1967: IF lv_debug = 'Y' THEN
1968: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after updating jai_rgm_invoice_gen_t for ex inv num');
1969: END IF;
1970:
1971: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
1972:

Line 2064: UPDATE JAI_RGM_INVOICE_GEN_T

2060: LAST_UPDATE_LOGIN = fnd_global.login_id,
2061: LAST_UPDATED_BY = fnd_global.user_id
2062: WHERE DELIVERY_ID = mainrec.delivery_id;
2063:
2064: UPDATE JAI_RGM_INVOICE_GEN_T
2065: SET vat_invoice_no = lv_vat_invoice_number,
2066: vat_inv_gen_status = 'C',
2067: request_id = ln_conc_request_id,
2068: program_id = ln_conc_progam_id,

Line 2099: FROM JAI_RGM_INVOICE_GEN_T

2095: last_update_login = fnd_global.login_id,
2096: last_updated_by = fnd_global.user_id
2097: WHERE delivery_id IN
2098: (SELECT delivery_id
2099: FROM JAI_RGM_INVOICE_GEN_T
2100: WHERE party_id = ln_current_party_id
2101: AND party_site_id = ln_current_party_site_id
2102: AND party_type = mainrec.party_type
2103: AND vat_inv_gen_status <> 'C'

Line 2108: UPDATE JAI_RGM_INVOICE_GEN_T

2104: AND delivery_id between NVL(P_DELIVERY_ID_FROM,delivery_id) AND NVL(P_DELIVERY_ID_TO,delivery_id)
2105: AND delivery_Date between NVL(P_DELIVERY_DATE_FROM,Delivery_date) AND NVL(P_DELIVERY_DATE_TO,delivery_date)
2106: );
2107:
2108: UPDATE JAI_RGM_INVOICE_GEN_T
2109: SET vat_invoice_no = lv_vat_invoice_number,
2110: vat_inv_gen_status = 'C',
2111: request_id = ln_conc_request_id,
2112: program_id = ln_conc_progam_id,

Line 2117: FROM JAI_RGM_INVOICE_GEN_T

2113: program_application_id = ln_conc_prog_appl_id,
2114: last_update_login = fnd_global.conc_login_id
2115: WHERE delivery_id IN
2116: (SELECT delivery_id
2117: FROM JAI_RGM_INVOICE_GEN_T
2118: WHERE party_id = ln_current_party_id
2119: AND party_site_id = ln_current_party_site_id
2120: AND party_type = mainrec.party_type
2121: AND vat_inv_gen_status <> 'C'

Line 2173: UPDATE JAI_RGM_INVOICE_GEN_T

2169: last_update_login = fnd_global.login_id,
2170: last_updated_by = fnd_global.user_id
2171: WHERE delivery_id = mainrec.delivery_id;
2172:
2173: UPDATE JAI_RGM_INVOICE_GEN_T
2174: SET vat_invoice_no = lv_vat_invoice_number,
2175: vat_inv_gen_status = 'C',
2176: vat_inv_gen_err_message = NULL , /*following columns added by srjayara for bug 4702156*/
2177: request_id = ln_conc_request_id,

Line 2190: UPDATE JAI_RGM_INVOICE_GEN_T

2186: lv_inv_gen_process_message := 'No VAT Invoice Number Generated';
2187: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
2188: END IF;
2189: ELSE
2190: UPDATE JAI_RGM_INVOICE_GEN_T
2191: SET vat_inv_gen_err_message = substr(lv_inv_gen_process_message,1,1000),
2192: vat_inv_gen_status = 'E',
2193: request_id = ln_conc_request_id, /*following columns added by srjayara for bug 4702156*/
2194: program_id = ln_conc_progam_id,

Line 2270: UPDATE JAI_RGM_INVOICE_GEN_T

2266: /*
2267: || Both the activities have been succesfully completed
2268: || Can commit the changes made to the delivery.
2269: */
2270: UPDATE JAI_RGM_INVOICE_GEN_T
2271: SET vat_acct_status = 'C',
2272: vat_inv_gen_err_message = NULL, /*following columns added by srjayara for bug 4702156*/
2273: request_id = ln_conc_request_id,
2274: program_id = ln_conc_progam_id,

Line 2294: UPDATE JAI_RGM_INVOICE_GEN_T

2290: */
2291: ROLLBACK;
2292:
2293: IF lv_inv_gen_process_flag <> jai_constants.successful THEN
2294: UPDATE JAI_RGM_INVOICE_GEN_T
2295: SET vat_inv_gen_err_message = substr(lv_inv_gen_process_message,1,1000),
2296: vat_inv_gen_status = 'E',
2297: request_id = ln_conc_request_id, /*following columns added by srjayara for bug 4702156*/
2298: program_id = ln_conc_progam_id,

Line 2306: UPDATE JAI_RGM_INVOICE_GEN_T

2302: WHERE delivery_id = mainrec.delivery_id;
2303: END IF;
2304:
2305: IF lv_acct_process_flag <> jai_constants.successful THEN
2306: UPDATE JAI_RGM_INVOICE_GEN_T
2307: SET vat_acct_err_message = substr(lv_acct_process_message,1,1000),
2308: vat_acct_status = 'E',
2309: request_id = ln_conc_request_id, /*following columns added by srjayara for bug 4702156*/
2310: program_id = ln_conc_progam_id,