[Home] [Help]
57: return 'CI_WORKING';
58:
59: end GET_INITIAL_CI_STATUS;
60:
61: -- has been replaced by get_party_id in PA_UTILS
62: -- Function get_party_id (
63: -- p_resource_id in number,
64: -- p_resource_type_id in number )
65: -- return number
2234: IF (l_temp <> 'T') THEN
2235: IF P_PA_DEBUG_MODE = 'Y' THEN
2236: pa_debug.write_file('ChangeCiStatusValidate: PA_CI_STATUS_UPDATE_INV');
2237: END IF;
2238: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2239: ,p_msg_name => 'PA_CI_STATUS_UPDATE_INV');
2240: x_return_status := FND_API.G_RET_STS_ERROR;
2241: END IF;
2242: END IF;
2295:
2296: END IF;
2297:
2298: IF l_temp = 'Y' THEN
2299: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2300: ,p_msg_name => 'PA_CI_OPEN_ACTION_EXISTS');
2301: IF P_PA_DEBUG_MODE = 'Y' THEN
2302: pa_debug.write_file('ChangeCiStatus: PA_CI_OPEN_ACTION_EXIST');
2303: END IF;
2317: IF l_type = 'CHANGE_ORDER' OR l_type = 'CHANGE_REQUEST' OR l_type = 'ISSUE' THEN
2318: NULL;
2319: END IF;
2320: ELSE
2321: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2322: ,p_msg_name => 'PA_CI_RESOLUTION_OPEN');
2323: IF P_PA_DEBUG_MODE = 'Y' THEN
2324: pa_debug.write_file('ChangeCiStatus: PA_CI_RESOLUTION_OPEN');
2325: END IF;
2339: END IF; /* IF p_resolution_check = 'UI' */
2340: END IF; /* if l_temp = 'Y' */
2341:
2342: ELSE
2343: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2344: ,p_msg_name => 'PA_CI_SUBMIT_INV');
2345: IF P_PA_DEBUG_MODE = 'Y' THEN
2346: pa_debug.write_file('ChangeCiStatus: PA_CI_SUBMIT_INV');
2347: END IF;
2348: x_return_status := FND_API.G_RET_STS_ERROR;
2349: END IF;
2350:
2351: ELSE
2352: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2353: ,p_msg_name => 'PA_CI_APPROVAL_NOT_REQ');
2354: IF P_PA_DEBUG_MODE = 'Y' THEN
2355: pa_debug.write_file('ChangeCiStatusValidate: PA_CI_APPROVAL_NOT_REQ');
2356: END IF;
2408: l_ret := pa_ci_impacts_util.is_any_impact_implemented(p_ci_id);
2409:
2410:
2411: IF (l_ret ) THEN
2412: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2413: ,p_msg_name => 'PA_CI_CANCEL_INV_IMP');
2414: IF P_PA_DEBUG_MODE = 'Y' THEN
2415: pa_debug.write_file('ChangeCiStatusValidate: in
2416:
2457:
2458: l_ret := pa_ci_impacts_util.is_all_impact_implemented(p_ci_id);
2459:
2460: IF (NOT l_ret ) THEN
2461: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2462: ,p_msg_name => 'PA_CI_CLOSE_INV_IMP');
2463: IF P_PA_DEBUG_MODE = 'Y' THEN
2464: pa_debug.write_file('ChangeCiStatusValidate: in
2465:
2471: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2472: l_temp := pa_ci_actions_util.check_open_actions_exist (p_ci_id);
2473:
2474: IF l_temp = 'Y' THEN
2475: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2476: ,p_msg_name => 'PA_CI_CLOSE_INV_ACT');
2477: IF P_PA_DEBUG_MODE = 'Y' THEN
2478: pa_debug.write_file('ChangeCiStatusValidate: in
2479:
2485: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2486: IF checkhasresolution (p_ci_id) = 'Y' THEN
2487: NULL;
2488: ELSE
2489: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2490: ,p_msg_name => 'PA_CI_CLOSE_INV_RES');
2491: IF P_PA_DEBUG_MODE = 'Y' THEN
2492: pa_debug.write_file('ChangeCiStatus: in
2493: END IF;
2515: -- check no impact is implemented
2516: l_ret := pa_ci_impacts_util.is_any_impact_implemented(p_ci_id);
2517:
2518: IF (l_ret ) THEN
2519: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2520: ,p_msg_name => 'PA_CI_WORKING_INV_IMP');
2521: IF P_PA_DEBUG_MODE = 'Y' THEN
2522: pa_debug.write_file('ChangeCiStatus: in
2523:
2534: IF l_type = 'CHANGE_ORDER' then
2535: l_ret := pa_ci_impacts_util.is_all_impact_implemented(p_ci_id);
2536:
2537: IF (NOT l_ret ) THEN
2538: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2539: ,p_msg_name => 'PA_CI_CLOSE_INV_IMP');
2540: IF P_PA_DEBUG_MODE = 'Y' THEN
2541: pa_debug.write_file('ChangeCiStatus: in
2542: END IF;
2550: l_ret := pa_ci_impacts_util.is_any_impact_implemented
2551: (p_ci_id);
2552:
2553: IF (l_ret ) THEN
2554: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2555: ,p_msg_name => 'PA_CI_CANCEL_INV_IMP');
2556: IF P_PA_DEBUG_MODE = 'Y' THEN
2557: pa_debug.write_file('ChangeCiStatus: in
2558: END IF;