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.BIS_CREATE_REQUESTSET dependencies on FND_CONCURRENT

Line 536: fnd_concurrent_programs d,

532: from
533: fnd_request_sets a,
534: fnd_request_set_programs b,
535: fnd_request_set_stages c,
536: fnd_concurrent_programs d,
537: fnd_application e,
538: fnd_application f
539: where a.request_set_id=b.request_set_id
540: and b.request_set_stage_id=c.request_set_stage_id

Line 1092: fnd_concurrent_programs b

1088: a.CONC_PROGRAM_NAME CONCURRENT_PROGRAM_NAME,
1089: a.CONC_APP_SHORT_NAME APPLICATION_SHORT_NAME
1090: from
1091: bis_obj_prog_linkages a,
1092: fnd_concurrent_programs b
1093: where a.object_name=p_objectname
1094: and a.object_type=p_objecttype
1095: and a.enabled_flag='Y'
1096: and a.CONC_PROGRAM_NAME<>g_bsc_loader_ind_program

Line 1811: fnd_concurrent_programs b

1807: a.CONC_PROGRAM_NAME CONCURRENT_PROGRAM_NAME,
1808: a.CONC_APP_SHORT_NAME APPLICATION_SHORT_NAME
1809: from
1810: bis_obj_prog_linkages a,
1811: fnd_concurrent_programs b
1812: where a.object_name=p_objectname
1813: and a.object_type=p_objecttype
1814: and a.enabled_flag='Y'
1815: ---and (nvl(a.refresh_mode,'INCR')=p_refresh_mode or nvl(a.refresh_mode,'INCR')='INIT_INCR')

Line 2802: fnd_concurrent_programs b,

2798: c.object_type,
2799: c.object_name
2800: from
2801: fnd_request_set_programs a,
2802: fnd_concurrent_programs b,
2803: bis_obj_prog_linkages c,
2804: BIS_BIA_RSG_STAGE_OBJECTS d
2805: where a.set_application_id=p_set_app_id
2806: and a.request_set_id=p_set_id

Line 2841: fnd_concurrent_programs b,

2837: select
2838: distinct d.CUSTOM_API custom_api
2839: from
2840: fnd_request_set_programs a,
2841: fnd_concurrent_programs b,
2842: bis_obj_prog_linkages c,
2843: bis_obj_properties d
2844: where a.set_application_id=p_set_app_id
2845: and a.request_set_id=p_set_id

Line 3445: l_call_status := FND_CONCURRENT.get_request_status(l_req_id , null, null,

3441: BIS_COLLECTION_UTILITIES.debug(' Req#' || l_req_id || ', can not moniter the status!' );
3442: return TRUE;
3443: end if;
3444:
3445: l_call_status := FND_CONCURRENT.get_request_status(l_req_id , null, null,
3446: l_phase, l_status, l_req_phase, l_dev_status, l_message);
3447: if (NOT l_call_status ) then
3448: RAISE_APPLICATION_ERROR (-20000,'Error happened in request: ' || l_req_id);
3449: end if;

Line 3459: l_call_status := fnd_concurrent.set_completion_status('TERMINATED' ,NULL);

3455: BIS_COLLECTION_UTILITIES.debug(' Req#' || l_req_id || ' is completed!' );
3456: IF (l_status = 'Error' OR l_dev_status = 'ERROR') THEN
3457: RAISE_APPLICATION_ERROR (-20000,'Error happened in request: ' || l_req_id);
3458: ELSIF (l_status = 'Terminated' OR l_dev_status = 'TERMINATED') THEN
3459: l_call_status := fnd_concurrent.set_completion_status('TERMINATED' ,NULL);
3460: RAISE_APPLICATION_ERROR (-20000,'request: ' || l_req_id || ' was terminated!');
3461: ELSIF (l_status = 'Warning' OR l_dev_status = 'WARNING') THEN
3462: l_call_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
3463: return FALSE;

Line 3462: l_call_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);

3458: ELSIF (l_status = 'Terminated' OR l_dev_status = 'TERMINATED') THEN
3459: l_call_status := fnd_concurrent.set_completion_status('TERMINATED' ,NULL);
3460: RAISE_APPLICATION_ERROR (-20000,'request: ' || l_req_id || ' was terminated!');
3461: ELSIF (l_status = 'Warning' OR l_dev_status = 'WARNING') THEN
3462: l_call_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
3463: return FALSE;
3464: ELSE
3465: return FALSE;
3466: END IF;

Line 3587: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);

3583: for l_set_rec in c_set_with_unimpl_obj loop
3584: BIS_COLLECTION_UTILITIES.put_line(l_set_rec.user_request_set_name);
3585: end loop;
3586: BIS_COLLECTION_UTILITIES.put_line('-----------End of the request set list------');
3587: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
3588: end if;
3589: end;
3590:
3591:

Line 3632: fnd_concurrent_requests req

3628: select
3629: req.argument1,
3630: req.argument2
3631: from
3632: fnd_concurrent_requests req
3633: where
3634: req.request_id = p_req_id ;
3635:
3636: CURSOR mv_log_truncate_running IS

Line 3638: FROM fnd_concurrent_programs prog, fnd_concurrent_requests req

3634: req.request_id = p_req_id ;
3635:
3636: CURSOR mv_log_truncate_running IS
3637: SELECT req.request_id REQUEST, req.phase_code Phase, requested_start_date s_date
3638: FROM fnd_concurrent_programs prog, fnd_concurrent_requests req
3639: WHERE prog.CONCURRENT_PROGRAM_NAME = 'BIS_BIA_TRUNCATE_EMPTY_MV_LOGS'
3640: AND req.concurrent_program_id = prog.concurrent_program_id
3641: AND req.program_application_id = prog.application_id
3642: AND req.phase_code = 'R';

Line 3679: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);

3675: EXCEPTION WHEN OTHERS THEN
3676: BIS_COLLECTION_UTILITIES.put_line('Exception while adding record for RS Run in BIS_RS_RUN_HISTORY_TABLE or updating terminated request set. ignorable exception ' || sqlerrm);
3677: errbuf := sqlerrm;
3678: retcode := sqlcode;
3679: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
3680: END;
3681: ELSE
3682: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
3683: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');

Line 3758: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);

3754: EXCEPTION WHEN OTHERS THEN
3755: BIS_COLLECTION_UTILITIES.put_line('Exception happens in preparation program, ' || sqlerrm);
3756: errbuf := sqlerrm;
3757: retcode := sqlcode;
3758: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
3759: END;
3760:
3761: end preparation_conc;
3762:

Line 3863: from fnd_concurrent_programs

3859: begin
3860: l_exist_flag:='N';
3861: select 'Y'
3862: into l_exist_flag
3863: from fnd_concurrent_programs
3864: where concurrent_program_name='BSC_LOAD_INDICATORS_DATA'
3865: and application_id=271;
3866: return l_exist_flag;
3867: exception

Line 4293: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);

4289: when others then
4290: BIS_COLLECTION_UTILITIES.put_line('Exception happens in ' || 'bis_create_requestset.seed_data_validation, ' || sqlerrm);
4291: errbuf := sqlerrm;
4292: retcode := '2';
4293: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
4294: end;
4295:
4296: /*
4297: Enh#3473874

Line 4441: FROM BIS_RS_PROG_RUN_HISTORY bis, FND_CONCURRENT_PROGRAMS_VL fnd

4437: l_root_request_id NUMBER;
4438:
4439: CURSOR c_get_all_prog_status IS
4440: SELECT request_id, user_concurrent_program_name NAME, 'PROG' TYPE
4441: FROM BIS_RS_PROG_RUN_HISTORY bis, FND_CONCURRENT_PROGRAMS_VL fnd
4442: WHERE bis.set_request_id = l_root_request_id AND bis.status_code ='E'
4443: AND bis.prog_app_id = fnd.application_id AND bis.program_id = fnd.concurrent_program_id
4444: UNION
4445: SELECT request_id, user_stage_name NAME, 'STAGE' TYPE

Line 4443: AND bis.prog_app_id = fnd.application_id AND bis.program_id = fnd.concurrent_program_id

4439: CURSOR c_get_all_prog_status IS
4440: SELECT request_id, user_concurrent_program_name NAME, 'PROG' TYPE
4441: FROM BIS_RS_PROG_RUN_HISTORY bis, FND_CONCURRENT_PROGRAMS_VL fnd
4442: WHERE bis.set_request_id = l_root_request_id AND bis.status_code ='E'
4443: AND bis.prog_app_id = fnd.application_id AND bis.program_id = fnd.concurrent_program_id
4444: UNION
4445: SELECT request_id, user_stage_name NAME, 'STAGE' TYPE
4446: FROM BIS_RS_STAGE_RUN_HISTORY bis, FND_REQUEST_SET_STAGES_VL fnd
4447: WHERE set_request_id = l_root_request_id AND status_code ='E'

Line 4464: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);

4460: CLOSE c_get_all_prog_status;
4461: IF (l_type = 'PROG') THEN
4462: BIS_COLLECTION_UTILITIES.put_line('Program - '||l_name || ', Request Id # '||l_request_id ||' completed with status=Error');
4463: BIS_COLLECTION_UTILITIES.put_line('Hence setting status of the current program (BIS Request Set Status Check Program) to Error.');
4464: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4465: ELSIF (l_type = 'STAGE') THEN
4466: BIS_COLLECTION_UTILITIES.put_line(l_name || ', Request Id # '||l_request_id ||' completed with status=Error');
4467: BIS_COLLECTION_UTILITIES.put_line('Hence setting status of the current program to Error.');
4468: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);

Line 4468: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);

4464: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4465: ELSIF (l_type = 'STAGE') THEN
4466: BIS_COLLECTION_UTILITIES.put_line(l_name || ', Request Id # '||l_request_id ||' completed with status=Error');
4467: BIS_COLLECTION_UTILITIES.put_line('Hence setting status of the current program to Error.');
4468: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4469: ELSE
4470: BIS_COLLECTION_UTILITIES.put_line('All the programs in the request set completed Successfully.');
4471: END IF;
4472: EXCEPTION

Line 4475: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);

4471: END IF;
4472: EXCEPTION
4473: WHEN OTHERS THEN
4474: BIS_COLLECTION_UTILITIES.put_line('Exception in set_rs_status' || sqlerrm);
4475: l_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
4476: BIS_COLLECTION_UTILITIES.put_line('BIS Request Set Status Check Program completed with internal exception,');
4477: BIS_COLLECTION_UTILITIES.put_line('due to this the correct status of the programs in the request set can not be found.');
4478: BIS_COLLECTION_UTILITIES.put_line('Note that the status of Request set can be Normal or Warning even though one of the');
4479: BIS_COLLECTION_UTILITIES.put_line('program might have completed with error.');

Line 4515: FROM fnd_concurrent_requests cr, fnd_request_sets rs

4511: FUNCTION is_history_collect_on(p_root_request_id IN NUMBER) RETURN BOOLEAN
4512: IS
4513: CURSOR c_request_set_details IS
4514: SELECT rs.request_set_name
4515: FROM fnd_concurrent_requests cr, fnd_request_sets rs
4516: WHERE cr.request_id = p_root_request_id
4517: AND rs.application_id = cr.argument1
4518: AND rs.request_set_id = cr.argument2;
4519: l_request_set_name VARCHAR2(1000);