[Home] [Help]
1185: v_sql_cmd VARCHAR2(32766);
1186:
1187: CURSOR c_sub_req_id IS
1188: SELECT request_id
1189: FROM fnd_concurrent_requests R,
1190: fnd_concurrent_programs P
1191: WHERE parent_request_id = v_req_id
1192: AND R.concurrent_program_id = P.concurrent_program_id
1193: AND P.concurrent_program_name = c_mp_sub_prg
1186:
1187: CURSOR c_sub_req_id IS
1188: SELECT request_id
1189: FROM fnd_concurrent_requests R,
1190: fnd_concurrent_programs P
1191: WHERE parent_request_id = v_req_id
1192: AND R.concurrent_program_id = P.concurrent_program_id
1193: AND P.concurrent_program_name = c_mp_sub_prg
1194: AND P.application_id = c_mp_app_id
1410: p_msg_text => v_prg_msg);
1411: FEM_ENGINES_PKG.USER_MESSAGE(
1412: p_msg_text => v_prg_msg);
1413:
1414: -- f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS(
1415: -- 'WARNING',null);
1416: END;
1417: END;
1418: END;
1496: ----------------------------------
1497: DELETE FROM fem_mp_process_ctl_t T
1498: WHERE rule_id = p_rule_id
1499: AND (req_id IN (SELECT request_id
1500: FROM fnd_concurrent_requests
1501: WHERE phase_code = 'C')
1502: OR NOT EXISTS (SELECT 1 FROM fnd_concurrent_requests
1503: WHERE request_id = T.req_id));
1504:
1498: WHERE rule_id = p_rule_id
1499: AND (req_id IN (SELECT request_id
1500: FROM fnd_concurrent_requests
1501: WHERE phase_code = 'C')
1502: OR NOT EXISTS (SELECT 1 FROM fnd_concurrent_requests
1503: WHERE request_id = T.req_id));
1504:
1505: DELETE FROM fem_mp_process_args_t T
1506: WHERE rule_id = p_rule_id
1504:
1505: DELETE FROM fem_mp_process_args_t T
1506: WHERE rule_id = p_rule_id
1507: AND (req_id IN (SELECT request_id
1508: FROM fnd_concurrent_requests
1509: WHERE phase_code = 'C')
1510: OR NOT EXISTS (SELECT 1 FROM fnd_concurrent_requests
1511: WHERE request_id = T.req_id));
1512: COMMIT;
1506: WHERE rule_id = p_rule_id
1507: AND (req_id IN (SELECT request_id
1508: FROM fnd_concurrent_requests
1509: WHERE phase_code = 'C')
1510: OR NOT EXISTS (SELECT 1 FROM fnd_concurrent_requests
1511: WHERE request_id = T.req_id));
1512: COMMIT;
1513:
1514: IF (v_slc_type > 0)
1761: p_module => v_block||'.v_sub_req_id{531.1}',
1762: p_msg_text => v_sub_req_id);
1763:
1764: LOOP
1765: f_req_wait := FND_CONCURRENT.WAIT_FOR_REQUEST
1766: (v_sub_req_id,5,0,v_req_phase,v_req_status,
1767: v_dev_phase,v_dev_status,v_req_message);
1768:
1769: FEM_ENGINES_PKG.TECH_MESSAGE(
1861: p_msg_text => v_prg_msg);
1862: FEM_ENGINES_PKG.USER_MESSAGE(
1863: p_msg_text => v_prg_msg);
1864:
1865: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',null);
1866: x_prg_stat := 'COMPLETE:WARNING';
1867: x_exception_code := 'FEM_MP_SOFT_KILL_WARN';
1868:
1869: WHEN e_no_rule_id THEN
1880: p_msg_text => v_prg_msg);
1881: FEM_ENGINES_PKG.USER_MESSAGE(
1882: p_msg_text => v_prg_msg);
1883:
1884: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
1885: x_prg_stat := 'COMPLETE:ERROR';
1886: x_exception_code := 'FEM_MP_BAD_OBJECT_ERR';
1887:
1888: WHEN e_no_mp_method THEN
1899: p_msg_text => v_prg_msg);
1900: FEM_ENGINES_PKG.USER_MESSAGE(
1901: p_msg_text => v_prg_msg);
1902:
1903: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
1904: x_prg_stat := 'COMPLETE:ERROR';
1905: x_exception_code := 'FEM_MP_NO_METHOD_ERR';
1906:
1907: WHEN e_bad_mp_settings THEN
1918: p_msg_text => v_prg_msg);
1919: FEM_ENGINES_PKG.USER_MESSAGE(
1920: p_msg_text => v_prg_msg);
1921:
1922: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
1923: x_prg_stat := 'COMPLETE:ERROR';
1924: x_exception_code := 'FEM_MP_BAD_SETTINGS_ERR';
1925:
1926: WHEN e_no_data_slices THEN
1935: (p_severity => c_log_level_5,
1936: p_module => v_block||'.Build_Data_Slices{544}',
1937: p_msg_text => v_prg_msg);
1938:
1939: --f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
1940: x_prg_stat := 'COMPLETE:ERROR';
1941: x_exception_code := 'FEM_MP_NO_DATA_SLICES_ERR';
1942:
1943: WHEN e_no_subreq THEN
1954: p_msg_text => v_prg_msg);
1955: FEM_ENGINES_PKG.USER_MESSAGE(
1956: p_msg_text => v_prg_msg);
1957:
1958: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
1959: x_prg_stat := 'COMPLETE:ERROR';
1960: x_exception_code := 'FEM_MP_NO_SUBREQ_ERR';
1961:
1962: WHEN others THEN
1978: '||v_stack);
1979: FEM_ENGINES_PKG.USER_MESSAGE(
1980: p_msg_text => v_prg_msg);
1981:
1982: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
1983: x_prg_stat := 'COMPLETE:ERROR';
1984: x_exception_code := 'FEM_MP_UNEXP_ERR';
1985:
1986: END Master;
4665: p_token2 => 'REQUEST',
4666: p_value2 => v_sub_req_id);
4667:
4668: v_sub_msg := FND_MSG_PUB.GET(p_encoded => 'F');
4669: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',null);
4670:
4671: ELSE
4672: FEM_ENGINES_PKG.PUT_MESSAGE(
4673: p_app_name => 'FEM',
4677: p_token2 => 'REQUEST',
4678: p_value2 => v_sub_req_id);
4679:
4680: v_sub_msg := FND_MSG_PUB.GET(p_encoded => 'F');
4681: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
4682:
4683: END IF;
4684:
4685: FEM_ENGINES_PKG.TECH_MESSAGE
4712: p_msg_text => v_sub_msg);
4713: FEM_ENGINES_PKG.USER_MESSAGE(
4714: p_msg_text => v_sub_msg);
4715:
4716: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
4717:
4718: WHEN others THEN
4719: v_stack := dbms_utility.format_call_stack;
4720:
4737: '||v_stack);
4738: FEM_ENGINES_PKG.USER_MESSAGE(
4739: p_msg_text => v_sub_msg);
4740:
4741: f_set_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',null);
4742:
4743: END Sub_Request;
4744:
4745: