[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
2344: IF P_PA_DEBUG_MODE = 'Y' THEN
2345: pa_debug.write_file('ChangeCiStatusValidate: PA_CI_STATUS_UPDATE_INV');
2346: END IF;
2347:
2348: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2349: ,p_msg_name => 'PA_CI_STATUS_UPDATE_INV');
2350: x_return_status := FND_API.G_RET_STS_ERROR;
2351: END IF;
2352: -- Bug#13683760 changes end.
2406:
2407: END IF;
2408:
2409: IF l_temp = 'Y' THEN
2410: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2411: ,p_msg_name => 'PA_CI_OPEN_ACTION_EXISTS');
2412: IF P_PA_DEBUG_MODE = 'Y' THEN
2413: pa_debug.write_file('ChangeCiStatus: PA_CI_OPEN_ACTION_EXIST');
2414: END IF;
2428: IF l_type = 'CHANGE_ORDER' OR l_type = 'CHANGE_REQUEST' OR l_type = 'ISSUE' THEN
2429: NULL;
2430: END IF;
2431: ELSE
2432: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2433: ,p_msg_name => 'PA_CI_RESOLUTION_OPEN');
2434: IF P_PA_DEBUG_MODE = 'Y' THEN
2435: pa_debug.write_file('ChangeCiStatus: PA_CI_RESOLUTION_OPEN');
2436: END IF;
2450: END IF; /* IF p_resolution_check = 'UI' */
2451: END IF; /* if l_temp = 'Y' */
2452:
2453: ELSE
2454: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2455: ,p_msg_name => 'PA_CI_SUBMIT_INV');
2456: IF P_PA_DEBUG_MODE = 'Y' THEN
2457: pa_debug.write_file('ChangeCiStatus: PA_CI_SUBMIT_INV');
2458: END IF;
2459: x_return_status := FND_API.G_RET_STS_ERROR;
2460: END IF;
2461:
2462: ELSE
2463: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2464: ,p_msg_name => 'PA_CI_APPROVAL_NOT_REQ');
2465: IF P_PA_DEBUG_MODE = 'Y' THEN
2466: pa_debug.write_file('ChangeCiStatusValidate: PA_CI_APPROVAL_NOT_REQ');
2467: END IF;
2519: l_ret := pa_ci_impacts_util.is_any_impact_implemented(p_ci_id);
2520:
2521:
2522: IF (l_ret ) THEN
2523: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2524: ,p_msg_name => 'PA_CI_CANCEL_INV_IMP');
2525: IF P_PA_DEBUG_MODE = 'Y' THEN
2526: pa_debug.write_file('ChangeCiStatusValidate: in
2527:
2568:
2569: l_ret := pa_ci_impacts_util.is_all_impact_implemented(p_ci_id);
2570:
2571: IF (NOT l_ret ) THEN
2572: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2573: ,p_msg_name => 'PA_CI_CLOSE_INV_IMP');
2574: IF P_PA_DEBUG_MODE = 'Y' THEN
2575: pa_debug.write_file('ChangeCiStatusValidate: in
2576:
2582: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2583: l_temp := pa_ci_actions_util.check_open_actions_exist (p_ci_id);
2584:
2585: IF l_temp = 'Y' THEN
2586: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2587: ,p_msg_name => 'PA_CI_CLOSE_INV_ACT');
2588: IF P_PA_DEBUG_MODE = 'Y' THEN
2589: pa_debug.write_file('ChangeCiStatusValidate: in
2590:
2596: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2597: IF checkhasresolution (p_ci_id) = 'Y' THEN
2598: NULL;
2599: ELSE
2600: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2601: ,p_msg_name => 'PA_CI_CLOSE_INV_RES');
2602: IF P_PA_DEBUG_MODE = 'Y' THEN
2603: pa_debug.write_file('ChangeCiStatus: in
2604: END IF;
2626: -- check no impact is implemented
2627: l_ret := pa_ci_impacts_util.is_any_impact_implemented(p_ci_id);
2628:
2629: IF (l_ret ) THEN
2630: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2631: ,p_msg_name => 'PA_CI_WORKING_INV_IMP');
2632: IF P_PA_DEBUG_MODE = 'Y' THEN
2633: pa_debug.write_file('ChangeCiStatus: in
2634:
2645: IF l_type = 'CHANGE_ORDER' then
2646: l_ret := pa_ci_impacts_util.is_all_impact_implemented(p_ci_id);
2647:
2648: IF (NOT l_ret ) THEN
2649: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2650: ,p_msg_name => 'PA_CI_CLOSE_INV_IMP');
2651: IF P_PA_DEBUG_MODE = 'Y' THEN
2652: pa_debug.write_file('ChangeCiStatus: in
2653: END IF;
2661: l_ret := pa_ci_impacts_util.is_any_impact_implemented
2662: (p_ci_id);
2663:
2664: IF (l_ret ) THEN
2665: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2666: ,p_msg_name => 'PA_CI_CANCEL_INV_IMP');
2667: IF P_PA_DEBUG_MODE = 'Y' THEN
2668: pa_debug.write_file('ChangeCiStatus: in
2669: END IF;