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 FND_CONCURRENT

Line 200: ln_conc_request_id FND_CONCURRENT_REQUESTS.request_id%TYPE;

196: p_trx_from_date IN DATE,
197: p_trx_till_date IN DATE
198: ) IS
199:
200: ln_conc_request_id FND_CONCURRENT_REQUESTS.request_id%TYPE;
201: ln_conc_request_date FND_CONCURRENT_REQUESTS.request_date%TYPE;
202:
203: CURSOR c_request_date(cp_request_id IN NUMBER) IS
204: SELECT request_date

Line 201: ln_conc_request_date FND_CONCURRENT_REQUESTS.request_date%TYPE;

197: p_trx_till_date IN DATE
198: ) IS
199:
200: ln_conc_request_id FND_CONCURRENT_REQUESTS.request_id%TYPE;
201: ln_conc_request_date FND_CONCURRENT_REQUESTS.request_date%TYPE;
202:
203: CURSOR c_request_date(cp_request_id IN NUMBER) IS
204: SELECT request_date
205: FROM fnd_concurrent_requests

Line 205: FROM fnd_concurrent_requests

201: ln_conc_request_date FND_CONCURRENT_REQUESTS.request_date%TYPE;
202:
203: CURSOR c_request_date(cp_request_id IN NUMBER) IS
204: SELECT request_date
205: FROM fnd_concurrent_requests
206: WHERE request_id = cp_request_id;
207:
208: /* Added by Ramananda for bug#4407165 */
209: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_processing_pkg.insert_request_details';

Line 2338: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', NVL(lv_acct_process_message,lv_inv_gen_process_message));

2334: /*
2335: || Atleast one delivery failed Atleast one delivery Succeeded
2336: || Signal completion with warning
2337: */
2338: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', NVL(lv_acct_process_message,lv_inv_gen_process_message));
2339: retcode := '1';
2340: END IF;
2341: IF ln_failure_delivery_ctr = 0 AND ln_success_delivery_Ctr > 0 then
2342: /*

Line 2346: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', NULL);

2342: /*
2343: || Atleast one delivery Succeeded and none failed
2344: || Signal completion with success
2345: */
2346: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', NULL);
2347: retcode := '0';
2348: END IF;
2349: IF ln_failure_delivery_ctr > 0 AND ln_success_delivery_Ctr = 0 then
2350: /*

Line 2355: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',NVL(lv_acct_process_message,lv_inv_gen_process_message));

2351: || Atleast one delivery failed and No delivery Succeeded
2352: || Signal completion with error
2353: */
2354: retcode := '2';
2355: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',NVL(lv_acct_process_message,lv_inv_gen_process_message));
2356: END IF;
2357: IF ln_failure_delivery_ctr = 0 AND ln_success_delivery_Ctr = 0 then
2358: /*
2359: || No delivery failed and No delivery Succeeded

Line 2362: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', NULL);

2358: /*
2359: || No delivery failed and No delivery Succeeded
2360: || Signal completion with Success
2361: */
2362: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', NULL);
2363: retcode := '0';
2364: END IF;
2365:
2366: EXCEPTION

Line 2370: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',substr(sqlerrm,1,1000));

2366: EXCEPTION
2367: WHEN OTHERS THEN
2368: RETCODE := '2';
2369: Fnd_File.PUT_LINE(Fnd_File.LOG,'Unexpected Error occured in procedure jai_cmn_rgm_processing_pkg.process '||substr(sqlerrm,1,300));
2370: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',substr(sqlerrm,1,1000));
2371: ERRBUF := substr(sqlerrm,1,1000);
2372: lv_inv_gen_process_flag := jai_constants.unexpected_error;
2373: lv_acct_process_flag := jai_constants.unexpected_error;
2374: lv_inv_gen_process_message := sqlerrm;