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 437: ln_conc_request_id FND_CONCURRENT_REQUESTS.request_id%TYPE;

433: p_trx_from_date IN DATE,
434: p_trx_till_date IN DATE
435: ) IS
436:
437: ln_conc_request_id FND_CONCURRENT_REQUESTS.request_id%TYPE;
438: ln_conc_request_date FND_CONCURRENT_REQUESTS.request_date%TYPE;
439:
440: CURSOR c_request_date(cp_request_id IN NUMBER) IS
441: SELECT request_date

Line 438: ln_conc_request_date FND_CONCURRENT_REQUESTS.request_date%TYPE;

434: p_trx_till_date IN DATE
435: ) IS
436:
437: ln_conc_request_id FND_CONCURRENT_REQUESTS.request_id%TYPE;
438: ln_conc_request_date FND_CONCURRENT_REQUESTS.request_date%TYPE;
439:
440: CURSOR c_request_date(cp_request_id IN NUMBER) IS
441: SELECT request_date
442: FROM fnd_concurrent_requests

Line 442: FROM fnd_concurrent_requests

438: ln_conc_request_date FND_CONCURRENT_REQUESTS.request_date%TYPE;
439:
440: CURSOR c_request_date(cp_request_id IN NUMBER) IS
441: SELECT request_date
442: FROM fnd_concurrent_requests
443: WHERE request_id = cp_request_id;
444:
445: /* Added by Ramananda for bug#4407165 */
446: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_processing_pkg.insert_request_details';

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

4332: /*
4333: || Atleast one delivery failed Atleast one delivery Succeeded
4334: || Signal completion with warning
4335: */
4336: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', NVL(lv_acct_process_message,lv_inv_gen_process_message));
4337: retcode := '1';
4338: -- added by zhiwei.xin on 10-JAN-2013 for bug#16167577 wsh error handling begin
4339: errbuf := NVL(lv_acct_process_message,lv_inv_gen_process_message);
4340: -- added by zhiwei.xin on 10-JAN-2013 for bug#16167577 wsh error handling end.

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

4343: /*
4344: || Atleast one delivery Succeeded and none failed
4345: || Signal completion with success
4346: */
4347: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', NULL);
4348: retcode := '0';
4349: END IF;
4350: IF ln_failure_delivery_ctr > 0 AND ln_success_delivery_Ctr = 0 then
4351: /*

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

4354: */
4355: retcode := '2';
4356: errbuf := NVL(lv_acct_process_message,lv_inv_gen_process_message);
4357: -- added by zhiwei.xin on 10-JAN-2013 for bug#16167577 wsh error handling end.
4358: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',NVL(lv_acct_process_message,lv_inv_gen_process_message));
4359: END IF;
4360: IF ln_failure_delivery_ctr = 0 AND ln_success_delivery_Ctr = 0 then
4361: /*
4362: || No delivery failed and No delivery Succeeded

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

4361: /*
4362: || No delivery failed and No delivery Succeeded
4363: || Signal completion with Success
4364: */
4365: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', NULL);
4366: retcode := '0';
4367: END IF;
4368:
4369: -- added by Allen Yang for bug 9709477 13-May-2010, begin

Line 4381: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', lv_same_as_excise_conf_warning);

4377: -------------------------------------------------
4378: Fnd_File.PUT_LINE(Fnd_File.LOG, lv_same_as_excise_conf_warning);
4379: -------------------------------------------------
4380: -- added by Allen Yang for bug 9737119, end
4381: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', lv_same_as_excise_conf_warning);
4382: retcode := '1';
4383: -- added by zhiwei.xin on 10-JAN-2013 for bug#16167577 wsh error handling begin
4384: errbuf := lv_same_as_excise_conf_warning;
4385: -- added by zhiwei.xin on 10-JAN-2013 for bug#16167577 wsh error handling end.

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

4389: EXCEPTION
4390: WHEN OTHERS THEN
4391: RETCODE := '2';
4392: Fnd_File.PUT_LINE(Fnd_File.LOG,'Unexpected Error occured in procedure jai_cmn_rgm_processing_pkg.process '||substr(sqlerrm,1,300));
4393: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',substr(sqlerrm,1,1000));
4394: ERRBUF := substr(sqlerrm,1,1000);
4395: lv_inv_gen_process_flag := jai_constants.unexpected_error;
4396: lv_acct_process_flag := jai_constants.unexpected_error;
4397: lv_inv_gen_process_message := sqlerrm;