[Home] [Help]
9: g_ret_sts_success CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_success;
10: g_ret_sts_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_error;
11: g_ret_sts_unexp_error CONSTANT VARCHAR2(1):= fnd_api.g_ret_sts_unexp_error;
12:
13: c_resp_app_id CONSTANT NUMBER := FND_GLOBAL.RESP_APPL_ID;
14:
15: c_log_level_1 CONSTANT NUMBER := fnd_log.level_statement;
16: c_log_level_2 CONSTANT NUMBER := fnd_log.level_procedure;
17: c_log_level_3 CONSTANT NUMBER := fnd_log.level_event;
1179: ELSE
1180: -- This is for objects which are not execution locked i.e.
1181: -- v_executable_lock_flag = 'N'
1182:
1183: v_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1184:
1185: -- If this object execution is already registered and is currently running,
1186: -- then it is a restart, else it is a normal run.
1187: SELECT DECODE(COUNT(*),1,'RESTART','NORMAL') INTO x_exec_state
2936: v_rstatus VARCHAR2(80);
2937: v_drphase VARCHAR2(30);
2938: v_dstatus VARCHAR2(30);
2939: v_message VARCHAR2 (240);
2940: v_user_id NUMBER := FND_GLOBAL.User_Id;
2941: v_last_update_login NUMBER := FND_GLOBAL.Login_Id;
2942: l_api_name CONSTANT VARCHAR2(30) := 'set_exec_state';
2943: l_api_version CONSTANT NUMBER := 1.0;
2944:
2937: v_drphase VARCHAR2(30);
2938: v_dstatus VARCHAR2(30);
2939: v_message VARCHAR2 (240);
2940: v_user_id NUMBER := FND_GLOBAL.User_Id;
2941: v_last_update_login NUMBER := FND_GLOBAL.Login_Id;
2942: l_api_name CONSTANT VARCHAR2(30) := 'set_exec_state';
2943: l_api_version CONSTANT NUMBER := 1.0;
2944:
2945: v_cancelled_status VARCHAR2(30);
3156: AND r.output_dataset_code = p_output_dataset_code;
3157:
3158: IF v_normal_run = 'F' AND p_calling_context = 'ENGINE' THEN
3159:
3160: v_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3161:
3162: -- Check if this is a restart
3163: SELECT DECODE(COUNT(*),1,'T','F') INTO v_restart
3164: FROM fem_pl_object_executions o, fem_pl_requests r
3317: AND o.exec_status_code = 'RUNNING';
3318:
3319: IF v_normal_run = 'F' AND p_calling_context = 'ENGINE' THEN
3320:
3321: v_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3322:
3323: -- Check if this is a restart
3324: SELECT DECODE(COUNT(*),1,'T','F') INTO v_restart
3325: FROM fem_pl_object_executions o, fem_pl_requests r
3489: AND r.source_system_code = p_source_system_code;
3490:
3491: IF v_normal_run = 'F' AND p_calling_context = 'ENGINE' THEN
3492:
3493: v_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3494:
3495: -- Check if this is a restart
3496: SELECT DECODE(COUNT(*),1,'T','F') INTO v_restart
3497: FROM fem_pl_object_executions o, fem_pl_requests r
3656: AND o.exec_status_code = 'RUNNING';
3657:
3658: IF v_normal_run = 'F' AND p_calling_context = 'ENGINE' THEN
3659:
3660: v_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3661:
3662: -- Check if this is a restart
3663: SELECT DECODE(COUNT(*),1,'T','F') INTO v_restart
3664: FROM fem_pl_object_executions o, fem_pl_requests r
3827: AND o.exec_status_code = 'RUNNING';
3828:
3829: IF v_normal_run = 'F' AND p_calling_context = 'ENGINE' THEN
3830:
3831: v_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3832:
3833: -- Check if this is a restart
3834: SELECT DECODE(COUNT(*),1,'T','F') INTO v_restart
3835: FROM fem_pl_object_executions o, fem_pl_requests r
3974: WHERE o.exec_object_definition_id = p_exec_object_definition_id;
3975:
3976: IF v_normal_run = 'F' AND p_calling_context = 'ENGINE' THEN
3977:
3978: v_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3979:
3980: -- Check if this is a restart
3981: SELECT DECODE(COUNT(*),1,'T','F') INTO v_restart
3982: FROM fem_pl_object_executions o