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.PA_CONTROL_ITEMS_UTILS dependencies on PA_DEBUG

Line 3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1: PACKAGE BODY PA_CONTROL_ITEMS_UTILS AS
2: --$Header: PACICIUB.pls 120.19.12020000.3 2013/03/19 15:34:31 svmohamm ship $
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: G_user_id NUMBER:=-999;
6: G_party_id NUMBER:=-999;
7: G_party_name VARCHAR2(360):= NULL ;

Line 948: IF P_PA_DEBUG_MODE = 'Y' THEN

944: x_msg_count := 0;
945: x_msg_data := '';
946:
947: -- Initialize the Error Stack
948: IF P_PA_DEBUG_MODE = 'Y' THEN
949: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
950: END IF;
951:
952: pa_debug.write_file('ChangeCiStatus: p_pa_debug_mode :'||p_pa_debug_mode);

Line 949: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');

945: x_msg_data := '';
946:
947: -- Initialize the Error Stack
948: IF P_PA_DEBUG_MODE = 'Y' THEN
949: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
950: END IF;
951:
952: pa_debug.write_file('ChangeCiStatus: p_pa_debug_mode :'||p_pa_debug_mode);
953:

Line 952: pa_debug.write_file('ChangeCiStatus: p_pa_debug_mode :'||p_pa_debug_mode);

948: IF P_PA_DEBUG_MODE = 'Y' THEN
949: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
950: END IF;
951:
952: pa_debug.write_file('ChangeCiStatus: p_pa_debug_mode :'||p_pa_debug_mode);
953:
954: -- Initialize the return status to success
955: x_return_status := FND_API.G_RET_STS_SUCCESS;
956:

Line 984: IF P_PA_DEBUG_MODE = 'Y' THEN

980:
981: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
982: -- debug_msg_s1 ('6 ' || x_return_status);
983:
984: IF P_PA_DEBUG_MODE = 'Y' THEN
985: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
986: END IF;
987:
988: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (

Line 985: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');

981: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
982: -- debug_msg_s1 ('6 ' || x_return_status);
983:
984: IF P_PA_DEBUG_MODE = 'Y' THEN
985: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
986: END IF;
987:
988: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (
989: 1.0,

Line 1001: IF P_PA_DEBUG_MODE = 'Y' THEN

997: x_return_status,
998: x_msg_count,
999: x_msg_data
1000: );
1001: IF P_PA_DEBUG_MODE = 'Y' THEN
1002: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
1003: END IF;
1004:
1005:

Line 1002: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');

998: x_msg_count,
999: x_msg_data
1000: );
1001: IF P_PA_DEBUG_MODE = 'Y' THEN
1002: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
1003: END IF;
1004:
1005:
1006: --Bug # 4618856 - if statement is added to check the return status

Line 1010: IF P_PA_DEBUG_MODE = 'Y' THEN

1006: --Bug # 4618856 - if statement is added to check the return status
1007: IF (x_return_status = 'S') THEN
1008:
1009: /* Bug#3297238: call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
1010: IF P_PA_DEBUG_MODE = 'Y' THEN
1011: pa_debug.write_file('ChangeCiStatus: before call to ADD_STATUS_CHANGE_COMMENT');
1012: END IF;
1013:
1014: DBMS_LOCK.SLEEP(1); -- Bug 7022037

Line 1011: pa_debug.write_file('ChangeCiStatus: before call to ADD_STATUS_CHANGE_COMMENT');

1007: IF (x_return_status = 'S') THEN
1008:
1009: /* Bug#3297238: call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
1010: IF P_PA_DEBUG_MODE = 'Y' THEN
1011: pa_debug.write_file('ChangeCiStatus: before call to ADD_STATUS_CHANGE_COMMENT');
1012: END IF;
1013:
1014: DBMS_LOCK.SLEEP(1); -- Bug 7022037
1015:

Line 1027: IF P_PA_DEBUG_MODE = 'Y' THEN

1023: ,x_return_status => x_return_status
1024: ,x_msg_count => x_msg_count
1025: ,x_msg_data => x_msg_data );
1026:
1027: IF P_PA_DEBUG_MODE = 'Y' THEN
1028: pa_debug.write_file('ChangeCiStatus: after call to ADD_STATUS_CHANGE_COMMENT');
1029: END IF;
1030: END IF;
1031:

Line 1028: pa_debug.write_file('ChangeCiStatus: after call to ADD_STATUS_CHANGE_COMMENT');

1024: ,x_msg_count => x_msg_count
1025: ,x_msg_data => x_msg_data );
1026:
1027: IF P_PA_DEBUG_MODE = 'Y' THEN
1028: pa_debug.write_file('ChangeCiStatus: after call to ADD_STATUS_CHANGE_COMMENT');
1029: END IF;
1030: END IF;
1031:
1032: END IF;

Line 1089: IF P_PA_DEBUG_MODE = 'Y' THEN

1085: -- Bug#14267314 end.
1086: -- Commit if the flag is set and there is no error
1087: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1088:
1089: IF P_PA_DEBUG_MODE = 'Y' THEN
1090: pa_debug.write_file('ChangeCiStatus: before COMMIT');
1091: END IF;
1092:
1093: COMMIT;

Line 1090: pa_debug.write_file('ChangeCiStatus: before COMMIT');

1086: -- Commit if the flag is set and there is no error
1087: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1088:
1089: IF P_PA_DEBUG_MODE = 'Y' THEN
1090: pa_debug.write_file('ChangeCiStatus: before COMMIT');
1091: END IF;
1092:
1093: COMMIT;
1094:

Line 1107: Pa_Debug.Reset_Err_Stack;

1103: ,p_msg_index_out => l_msg_index_out
1104: );
1105: END IF;
1106:
1107: Pa_Debug.Reset_Err_Stack;
1108:
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111:

Line 1112: IF P_PA_DEBUG_MODE = 'Y' THEN

1108:
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111:
1112: IF P_PA_DEBUG_MODE = 'Y' THEN
1113: pa_debug.write_file('ChangeCiStatus: in when others exception');
1114: END IF;
1115:
1116: ROLLBACK;

Line 1113: pa_debug.write_file('ChangeCiStatus: in when others exception');

1109: EXCEPTION
1110: WHEN OTHERS THEN
1111:
1112: IF P_PA_DEBUG_MODE = 'Y' THEN
1113: pa_debug.write_file('ChangeCiStatus: in when others exception');
1114: END IF;
1115:
1116: ROLLBACK;
1117:

Line 2281: IF P_PA_DEBUG_MODE = 'Y' THEN

2277: x_msg_data := '';
2278: x_start_wf := l_start_wf;
2279:
2280: -- Initialize the Error Stack
2281: IF P_PA_DEBUG_MODE = 'Y' THEN
2282: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2283: END IF;
2284:
2285: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);

Line 2282: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');

2278: x_start_wf := l_start_wf;
2279:
2280: -- Initialize the Error Stack
2281: IF P_PA_DEBUG_MODE = 'Y' THEN
2282: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2283: END IF;
2284:
2285: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);
2286:

Line 2285: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);

2281: IF P_PA_DEBUG_MODE = 'Y' THEN
2282: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2283: END IF;
2284:
2285: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);
2286:
2287: -- Initialize the return status to success
2288: x_return_status := FND_API.G_RET_STS_SUCCESS;
2289:

Line 2338: IF P_PA_DEBUG_MODE = 'Y' THEN

2334: x_msg_count => x_msg_count,
2335: x_msg_data => x_msg_data );
2336:
2337: END IF;
2338: IF P_PA_DEBUG_MODE = 'Y' THEN
2339: pa_debug.write_file('ChangeCiStatusValidate: pa_ci_security_pkg.check_change_status_access :'||l_temp);
2340: END IF;
2341:
2342: IF (l_temp <> 'T') THEN

Line 2339: pa_debug.write_file('ChangeCiStatusValidate: pa_ci_security_pkg.check_change_status_access :'||l_temp);

2335: x_msg_data => x_msg_data );
2336:
2337: END IF;
2338: IF P_PA_DEBUG_MODE = 'Y' THEN
2339: pa_debug.write_file('ChangeCiStatusValidate: pa_ci_security_pkg.check_change_status_access :'||l_temp);
2340: END IF;
2341:
2342: IF (l_temp <> 'T') THEN
2343:

Line 2344: IF P_PA_DEBUG_MODE = 'Y' THEN

2340: END IF;
2341:
2342: IF (l_temp <> 'T') THEN
2343:
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'

Line 2345: pa_debug.write_file('ChangeCiStatusValidate: PA_CI_STATUS_UPDATE_INV');

2341:
2342: IF (l_temp <> 'T') THEN
2343:
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');

Line 2363: IF P_PA_DEBUG_MODE = 'Y' THEN

2359: OPEN c_submit_status(p_status);
2360: FETCH c_submit_status INTO l_submit_status_flag, l_submit_status;
2361: CLOSE c_submit_status;
2362:
2363: IF P_PA_DEBUG_MODE = 'Y' THEN
2364: pa_debug.write_file('ChangeCiStatusValidate: l_submit_status_flag :'||l_submit_status_flag);
2365: pa_debug.write_file('ChangeCiStatusValidate: l_submit_status:'||l_submit_status);
2366: END IF;
2367:

Line 2364: pa_debug.write_file('ChangeCiStatusValidate: l_submit_status_flag :'||l_submit_status_flag);

2360: FETCH c_submit_status INTO l_submit_status_flag, l_submit_status;
2361: CLOSE c_submit_status;
2362:
2363: IF P_PA_DEBUG_MODE = 'Y' THEN
2364: pa_debug.write_file('ChangeCiStatusValidate: l_submit_status_flag :'||l_submit_status_flag);
2365: pa_debug.write_file('ChangeCiStatusValidate: l_submit_status:'||l_submit_status);
2366: END IF;
2367:
2368: IF l_submit_status_flag = 'Y' THEN

Line 2365: pa_debug.write_file('ChangeCiStatusValidate: l_submit_status:'||l_submit_status);

2361: CLOSE c_submit_status;
2362:
2363: IF P_PA_DEBUG_MODE = 'Y' THEN
2364: pa_debug.write_file('ChangeCiStatusValidate: l_submit_status_flag :'||l_submit_status_flag);
2365: pa_debug.write_file('ChangeCiStatusValidate: l_submit_status:'||l_submit_status);
2366: END IF;
2367:
2368: IF l_submit_status_flag = 'Y' THEN
2369:

Line 2371: IF P_PA_DEBUG_MODE = 'Y' THEN

2367:
2368: IF l_submit_status_flag = 'Y' THEN
2369:
2370: l_approval_required := checkapprovalrequired (p_ci_id);
2371: IF P_PA_DEBUG_MODE = 'Y' THEN
2372: pa_debug.write_file('ChangeCiStatusValidate: l_approval_required :'||l_approval_required);
2373: END IF;
2374:
2375: IF l_approval_required = 'Y' or l_approval_required = 'A' THEN

Line 2372: pa_debug.write_file('ChangeCiStatusValidate: l_approval_required :'||l_approval_required);

2368: IF l_submit_status_flag = 'Y' THEN
2369:
2370: l_approval_required := checkapprovalrequired (p_ci_id);
2371: IF P_PA_DEBUG_MODE = 'Y' THEN
2372: pa_debug.write_file('ChangeCiStatusValidate: l_approval_required :'||l_approval_required);
2373: END IF;
2374:
2375: IF l_approval_required = 'Y' or l_approval_required = 'A' THEN
2376: -- check the type is CR, CO, ISSUE

Line 2379: IF P_PA_DEBUG_MODE = 'Y' THEN

2375: IF l_approval_required = 'Y' or l_approval_required = 'A' THEN
2376: -- check the type is CR, CO, ISSUE
2377: l_type := getcitypeclasscode(p_ci_id);
2378:
2379: IF P_PA_DEBUG_MODE = 'Y' THEN
2380: pa_debug.write_file('ChangeCiStatusValidate: l_type :'||l_type);
2381: END IF;
2382:
2383: IF l_type = 'CHANGE_ORDER' OR l_type = 'CHANGE_REQUEST' OR l_type = 'ISSUE' THEN

Line 2380: pa_debug.write_file('ChangeCiStatusValidate: l_type :'||l_type);

2376: -- check the type is CR, CO, ISSUE
2377: l_type := getcitypeclasscode(p_ci_id);
2378:
2379: IF P_PA_DEBUG_MODE = 'Y' THEN
2380: pa_debug.write_file('ChangeCiStatusValidate: l_type :'||l_type);
2381: END IF;
2382:
2383: IF l_type = 'CHANGE_ORDER' OR l_type = 'CHANGE_REQUEST' OR l_type = 'ISSUE' THEN
2384:

Line 2395: IF P_PA_DEBUG_MODE = 'Y' THEN

2391: l_start_wf := 'N';
2392: x_start_wf := l_start_wf;
2393: x_new_status := l_new_status;
2394:
2395: IF P_PA_DEBUG_MODE = 'Y' THEN
2396: pa_debug.write_file('ChangeCiStatusValidate: l_new_status :'||l_new_status);
2397: pa_debug.write_file('ChangeCiStatusValidate: l_start_wf :'||l_start_wf);
2398: END IF;
2399:

Line 2396: pa_debug.write_file('ChangeCiStatusValidate: l_new_status :'||l_new_status);

2392: x_start_wf := l_start_wf;
2393: x_new_status := l_new_status;
2394:
2395: IF P_PA_DEBUG_MODE = 'Y' THEN
2396: pa_debug.write_file('ChangeCiStatusValidate: l_new_status :'||l_new_status);
2397: pa_debug.write_file('ChangeCiStatusValidate: l_start_wf :'||l_start_wf);
2398: END IF;
2399:
2400: END IF;

Line 2397: pa_debug.write_file('ChangeCiStatusValidate: l_start_wf :'||l_start_wf);

2393: x_new_status := l_new_status;
2394:
2395: IF P_PA_DEBUG_MODE = 'Y' THEN
2396: pa_debug.write_file('ChangeCiStatusValidate: l_new_status :'||l_new_status);
2397: pa_debug.write_file('ChangeCiStatusValidate: l_start_wf :'||l_start_wf);
2398: END IF;
2399:
2400: END IF;
2401:

Line 2404: IF P_PA_DEBUG_MODE = 'Y' THEN

2400: END IF;
2401:
2402: l_temp := pa_ci_actions_util.check_open_actions_exist (p_ci_id);
2403:
2404: IF P_PA_DEBUG_MODE = 'Y' THEN
2405: pa_debug.write_file('ChangeCiStatusValidate: pa_ci_actions_util.check_open_actions_exist :'||l_temp);
2406:
2407: END IF;
2408:

Line 2405: pa_debug.write_file('ChangeCiStatusValidate: pa_ci_actions_util.check_open_actions_exist :'||l_temp);

2401:
2402: l_temp := pa_ci_actions_util.check_open_actions_exist (p_ci_id);
2403:
2404: IF P_PA_DEBUG_MODE = 'Y' THEN
2405: pa_debug.write_file('ChangeCiStatusValidate: pa_ci_actions_util.check_open_actions_exist :'||l_temp);
2406:
2407: END IF;
2408:
2409: IF l_temp = 'Y' THEN

Line 2412: IF P_PA_DEBUG_MODE = 'Y' THEN

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;
2415: x_return_status := FND_API.G_RET_STS_ERROR;
2416: ELSE

Line 2413: pa_debug.write_file('ChangeCiStatus: PA_CI_OPEN_ACTION_EXIST');

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;
2415: x_return_status := FND_API.G_RET_STS_ERROR;
2416: ELSE
2417: -- check resolution is provided

Line 2419: IF P_PA_DEBUG_MODE = 'Y' THEN

2415: x_return_status := FND_API.G_RET_STS_ERROR;
2416: ELSE
2417: -- check resolution is provided
2418: IF p_resolution_check = 'UI' THEN
2419: IF P_PA_DEBUG_MODE = 'Y' THEN
2420: pa_debug.write_file('ChangeCiStatus: checkresolutionrequired :'||checkresolutionrequired(p_ci_id));
2421: END IF;
2422: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2423:

Line 2420: pa_debug.write_file('ChangeCiStatus: checkresolutionrequired :'||checkresolutionrequired(p_ci_id));

2416: ELSE
2417: -- check resolution is provided
2418: IF p_resolution_check = 'UI' THEN
2419: IF P_PA_DEBUG_MODE = 'Y' THEN
2420: pa_debug.write_file('ChangeCiStatus: checkresolutionrequired :'||checkresolutionrequired(p_ci_id));
2421: END IF;
2422: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2423:
2424: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2424: IF P_PA_DEBUG_MODE = 'Y' THEN

2420: pa_debug.write_file('ChangeCiStatus: checkresolutionrequired :'||checkresolutionrequired(p_ci_id));
2421: END IF;
2422: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2423:
2424: IF P_PA_DEBUG_MODE = 'Y' THEN
2425: pa_debug.write_file('ChangeCiStatusValidate: checkhasresolution :'||checkhasresolution (p_ci_id));
2426: END IF;
2427: IF checkhasresolution (p_ci_id) = 'Y' THEN
2428: IF l_type = 'CHANGE_ORDER' OR l_type = 'CHANGE_REQUEST' OR l_type = 'ISSUE' THEN

Line 2425: pa_debug.write_file('ChangeCiStatusValidate: checkhasresolution :'||checkhasresolution (p_ci_id));

2421: END IF;
2422: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2423:
2424: IF P_PA_DEBUG_MODE = 'Y' THEN
2425: pa_debug.write_file('ChangeCiStatusValidate: checkhasresolution :'||checkhasresolution (p_ci_id));
2426: END IF;
2427: IF checkhasresolution (p_ci_id) = 'Y' THEN
2428: IF l_type = 'CHANGE_ORDER' OR l_type = 'CHANGE_REQUEST' OR l_type = 'ISSUE' THEN
2429: NULL;

Line 2434: IF P_PA_DEBUG_MODE = 'Y' THEN

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;
2437: x_return_status := FND_API.G_RET_STS_ERROR;
2438: END IF;

Line 2435: pa_debug.write_file('ChangeCiStatus: PA_CI_RESOLUTION_OPEN');

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;
2437: x_return_status := FND_API.G_RET_STS_ERROR;
2438: END IF;
2439: END IF;

Line 2441: IF P_PA_DEBUG_MODE = 'Y' THEN

2437: x_return_status := FND_API.G_RET_STS_ERROR;
2438: END IF;
2439: END IF;
2440: ELSIF p_resolution_check = 'AMG' THEN
2441: IF P_PA_DEBUG_MODE = 'Y' THEN
2442: pa_debug.write_file('ChangeCiStatus: AMG checkresolutionrequired :'||checkresolutionrequired(p_ci_id));
2443: END IF;
2444: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2445: x_resolution_req := 'Y';

Line 2442: pa_debug.write_file('ChangeCiStatus: AMG checkresolutionrequired :'||checkresolutionrequired(p_ci_id));

2438: END IF;
2439: END IF;
2440: ELSIF p_resolution_check = 'AMG' THEN
2441: IF P_PA_DEBUG_MODE = 'Y' THEN
2442: pa_debug.write_file('ChangeCiStatus: AMG checkresolutionrequired :'||checkresolutionrequired(p_ci_id));
2443: END IF;
2444: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2445: x_resolution_req := 'Y';
2446: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2446: IF P_PA_DEBUG_MODE = 'Y' THEN

2442: pa_debug.write_file('ChangeCiStatus: AMG checkresolutionrequired :'||checkresolutionrequired(p_ci_id));
2443: END IF;
2444: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2445: x_resolution_req := 'Y';
2446: IF P_PA_DEBUG_MODE = 'Y' THEN
2447: pa_debug.write_file('ChangeCiStatusValidate: AMG checkhasresolution :'||checkhasresolution (p_ci_id));
2448: END IF;
2449: END IF;
2450: END IF; /* IF p_resolution_check = 'UI' */

Line 2447: pa_debug.write_file('ChangeCiStatusValidate: AMG checkhasresolution :'||checkhasresolution (p_ci_id));

2443: END IF;
2444: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2445: x_resolution_req := 'Y';
2446: IF P_PA_DEBUG_MODE = 'Y' THEN
2447: pa_debug.write_file('ChangeCiStatusValidate: AMG checkhasresolution :'||checkhasresolution (p_ci_id));
2448: END IF;
2449: END IF;
2450: END IF; /* IF p_resolution_check = 'UI' */
2451: END IF; /* if l_temp = 'Y' */

Line 2456: IF P_PA_DEBUG_MODE = 'Y' THEN

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;

Line 2457: pa_debug.write_file('ChangeCiStatus: PA_CI_SUBMIT_INV');

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:

Line 2465: IF P_PA_DEBUG_MODE = 'Y' THEN

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;
2468: x_return_status := FND_API.G_RET_STS_ERROR;
2469: END IF; /* IF l_approval_required = 'Y' or l_approval_required = 'A' THEN */

Line 2466: pa_debug.write_file('ChangeCiStatusValidate: PA_CI_APPROVAL_NOT_REQ');

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;
2468: x_return_status := FND_API.G_RET_STS_ERROR;
2469: END IF; /* IF l_approval_required = 'Y' or l_approval_required = 'A' THEN */
2470:

Line 2478: IF P_PA_DEBUG_MODE = 'Y' THEN

2474: OPEN check_if_fin_impact_exists;
2475: FETCH check_if_fin_impact_exists INTO l_tp;
2476: CLOSE check_if_fin_impact_exists;
2477:
2478: IF P_PA_DEBUG_MODE = 'Y' THEN
2479: pa_debug.write_file('ChangeCiStatusValidate: check_if_fin_impact_exists: '||l_tp);
2480: END IF;
2481:
2482: IF l_tp = 'Y' THEN

Line 2479: pa_debug.write_file('ChangeCiStatusValidate: check_if_fin_impact_exists: '||l_tp);

2475: FETCH check_if_fin_impact_exists INTO l_tp;
2476: CLOSE check_if_fin_impact_exists;
2477:
2478: IF P_PA_DEBUG_MODE = 'Y' THEN
2479: pa_debug.write_file('ChangeCiStatusValidate: check_if_fin_impact_exists: '||l_tp);
2480: END IF;
2481:
2482: IF l_tp = 'Y' THEN
2483:

Line 2484: IF P_PA_DEBUG_MODE = 'Y' THEN

2480: END IF;
2481:
2482: IF l_tp = 'Y' THEN
2483:
2484: IF P_PA_DEBUG_MODE = 'Y' THEN
2485: pa_debug.write_file('ChangeCiStatus: before call to Pa_Fp_Control_Items_Utils.Fp_Ci_Impact_Submit_Chk');
2486:
2487: END IF;
2488:

Line 2485: pa_debug.write_file('ChangeCiStatus: before call to Pa_Fp_Control_Items_Utils.Fp_Ci_Impact_Submit_Chk');

2481:
2482: IF l_tp = 'Y' THEN
2483:
2484: IF P_PA_DEBUG_MODE = 'Y' THEN
2485: pa_debug.write_file('ChangeCiStatus: before call to Pa_Fp_Control_Items_Utils.Fp_Ci_Impact_Submit_Chk');
2486:
2487: END IF;
2488:
2489: Pa_Fp_Control_Items_Utils.Fp_Ci_Impact_Submit_Chk

Line 2496: IF P_PA_DEBUG_MODE = 'Y' THEN

2492: ,x_return_status => x_return_status
2493: ,x_msg_count => x_msg_count
2494: ,x_msg_data => x_msg_data) ;
2495:
2496: IF P_PA_DEBUG_MODE = 'Y' THEN
2497: pa_debug.write_file('ChangeCiStatusValidate: after call to Pa_Fp_Control_Items_Utils.Fp_Ci_Impact_Submit_Chk');
2498:
2499: END IF;
2500:

Line 2497: pa_debug.write_file('ChangeCiStatusValidate: after call to Pa_Fp_Control_Items_Utils.Fp_Ci_Impact_Submit_Chk');

2493: ,x_msg_count => x_msg_count
2494: ,x_msg_data => x_msg_data) ;
2495:
2496: IF P_PA_DEBUG_MODE = 'Y' THEN
2497: pa_debug.write_file('ChangeCiStatusValidate: after call to Pa_Fp_Control_Items_Utils.Fp_Ci_Impact_Submit_Chk');
2498:
2499: END IF;
2500:
2501: END IF;

Line 2506: IF P_PA_DEBUG_MODE = 'Y' THEN

2502: END IF;
2503:
2504: END IF; /* IF l_submit_status_flag = 'Y' THEN */
2505:
2506: IF P_PA_DEBUG_MODE = 'Y' THEN
2507: pa_debug.write_file('ChangeCiStatusValidate: end of ');
2508: END IF;
2509:
2510: IF l_next_sys_status = 'CI_CANCELED' THEN

Line 2507: pa_debug.write_file('ChangeCiStatusValidate: end of ');

2503:
2504: END IF; /* IF l_submit_status_flag = 'Y' THEN */
2505:
2506: IF P_PA_DEBUG_MODE = 'Y' THEN
2507: pa_debug.write_file('ChangeCiStatusValidate: end of ');
2508: END IF;
2509:
2510: IF l_next_sys_status = 'CI_CANCELED' THEN
2511:

Line 2512: IF P_PA_DEBUG_MODE = 'Y' THEN

2508: END IF;
2509:
2510: IF l_next_sys_status = 'CI_CANCELED' THEN
2511:
2512: IF P_PA_DEBUG_MODE = 'Y' THEN
2513: pa_debug.write_file('ChangeCiStatusValidate: in ');
2514: END IF;
2515: l_type := getcitypeclasscode(p_ci_id);
2516:

Line 2513: pa_debug.write_file('ChangeCiStatusValidate: in ');

2509:
2510: IF l_next_sys_status = 'CI_CANCELED' THEN
2511:
2512: IF P_PA_DEBUG_MODE = 'Y' THEN
2513: pa_debug.write_file('ChangeCiStatusValidate: in ');
2514: END IF;
2515: l_type := getcitypeclasscode(p_ci_id);
2516:
2517: IF l_type = 'CHANGE_ORDER' OR l_type = 'CHANGE_REQUEST' THEN

Line 2525: IF P_PA_DEBUG_MODE = 'Y' THEN

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 PA_CI_CANCEL_INV_IMP');
2527:
2528: END IF;
2529: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2526: pa_debug.write_file('ChangeCiStatusValidate: in PA_CI_CANCEL_INV_IMP');

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 PA_CI_CANCEL_INV_IMP');
2527:
2528: END IF;
2529: x_return_status := FND_API.G_RET_STS_ERROR;
2530: END IF;

Line 2535: IF P_PA_DEBUG_MODE = 'Y' THEN

2531: END IF;
2532:
2533: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2534: -- cancel workflow
2535: IF P_PA_DEBUG_MODE = 'Y' THEN
2536: pa_debug.write_file('ChangeCiStatusValidate: in before cancelworkflow');
2537:
2538: END IF;
2539: cancelworkflow

Line 2536: pa_debug.write_file('ChangeCiStatusValidate: in before cancelworkflow');

2532:
2533: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2534: -- cancel workflow
2535: IF P_PA_DEBUG_MODE = 'Y' THEN
2536: pa_debug.write_file('ChangeCiStatusValidate: in before cancelworkflow');
2537:
2538: END IF;
2539: cancelworkflow
2540: (

Line 2551: IF P_PA_DEBUG_MODE = 'Y' THEN

2547: x_msg_count ,
2548: x_msg_data ,
2549: x_return_status
2550: );
2551: IF P_PA_DEBUG_MODE = 'Y' THEN
2552: pa_debug.write_file('ChangeCiStatusValidate: in after cancelworkflow');
2553:
2554: END IF;
2555:

Line 2552: pa_debug.write_file('ChangeCiStatusValidate: in after cancelworkflow');

2548: x_msg_data ,
2549: x_return_status
2550: );
2551: IF P_PA_DEBUG_MODE = 'Y' THEN
2552: pa_debug.write_file('ChangeCiStatusValidate: in after cancelworkflow');
2553:
2554: END IF;
2555:
2556: END IF;

Line 2560: IF P_PA_DEBUG_MODE = 'Y' THEN

2556: END IF;
2557:
2558: ELSIF l_next_sys_status = 'CI_CLOSED' THEN
2559:
2560: IF P_PA_DEBUG_MODE = 'Y' THEN
2561: pa_debug.write_file('ChangeCiStatusValidate: in ');
2562: END IF;
2563:
2564: l_type := getcitypeclasscode(p_ci_id);

Line 2561: pa_debug.write_file('ChangeCiStatusValidate: in ');

2557:
2558: ELSIF l_next_sys_status = 'CI_CLOSED' THEN
2559:
2560: IF P_PA_DEBUG_MODE = 'Y' THEN
2561: pa_debug.write_file('ChangeCiStatusValidate: in ');
2562: END IF;
2563:
2564: l_type := getcitypeclasscode(p_ci_id);
2565:

Line 2574: IF P_PA_DEBUG_MODE = 'Y' THEN

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 PA_CI_CLOSE_INV_IMP');
2576:
2577: END IF;
2578: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2575: pa_debug.write_file('ChangeCiStatusValidate: in PA_CI_CLOSE_INV_IMP');

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 PA_CI_CLOSE_INV_IMP');
2576:
2577: END IF;
2578: x_return_status := FND_API.G_RET_STS_ERROR;
2579: END IF;

Line 2588: IF P_PA_DEBUG_MODE = 'Y' THEN

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 PA_CI_CLOSE_INV_ACT');
2590:
2591: END IF;
2592: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2589: pa_debug.write_file('ChangeCiStatusValidate: in PA_CI_CLOSE_INV_ACT');

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 PA_CI_CLOSE_INV_ACT');
2590:
2591: END IF;
2592: x_return_status := FND_API.G_RET_STS_ERROR;
2593: END IF;

Line 2602: IF P_PA_DEBUG_MODE = '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 PA_CI_CLOSE_INV_RES');
2604: END IF;
2605: x_return_status := FND_API.G_RET_STS_ERROR;
2606: END IF;

Line 2603: pa_debug.write_file('ChangeCiStatus: in PA_CI_CLOSE_INV_RES');

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 PA_CI_CLOSE_INV_RES');
2604: END IF;
2605: x_return_status := FND_API.G_RET_STS_ERROR;
2606: END IF;
2607: END IF;

Line 2621: IF P_PA_DEBUG_MODE = 'Y' THEN

2617: END IF;
2618:
2619: IF l_curr_sys_status = 'CI_APPROVED' THEN
2620:
2621: IF P_PA_DEBUG_MODE = 'Y' THEN
2622: pa_debug.write_file('ChangeCiStatus: in and');
2623: END IF;
2624:
2625: IF l_next_sys_status = 'CI_WORKING' THEN

Line 2622: pa_debug.write_file('ChangeCiStatus: in and');

2618:
2619: IF l_curr_sys_status = 'CI_APPROVED' THEN
2620:
2621: IF P_PA_DEBUG_MODE = 'Y' THEN
2622: pa_debug.write_file('ChangeCiStatus: in and');
2623: END IF;
2624:
2625: IF l_next_sys_status = 'CI_WORKING' THEN
2626: -- check no impact is implemented

Line 2632: IF P_PA_DEBUG_MODE = 'Y' THEN

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 PA_CI_WORKING_INV_IMP');
2634:
2635:
2636: END IF;

Line 2633: pa_debug.write_file('ChangeCiStatus: in PA_CI_WORKING_INV_IMP');

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 PA_CI_WORKING_INV_IMP');
2634:
2635:
2636: END IF;
2637: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2651: IF P_PA_DEBUG_MODE = 'Y' THEN

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 PA_CI_CLOSE_INV_IMP');
2653: END IF;
2654: x_return_status := FND_API.G_RET_STS_ERROR;
2655: END IF;

Line 2652: pa_debug.write_file('ChangeCiStatus: in PA_CI_CLOSE_INV_IMP');

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 PA_CI_CLOSE_INV_IMP');
2653: END IF;
2654: x_return_status := FND_API.G_RET_STS_ERROR;
2655: END IF;
2656: END IF;

Line 2667: IF P_PA_DEBUG_MODE = 'Y' THEN

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 PA_CI_CANCEL_INV_IMP');
2669: END IF;
2670: x_return_status := FND_API.G_RET_STS_ERROR;
2671: END IF;

Line 2668: pa_debug.write_file('ChangeCiStatus: in PA_CI_CANCEL_INV_IMP');

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 PA_CI_CANCEL_INV_IMP');
2669: END IF;
2670: x_return_status := FND_API.G_RET_STS_ERROR;
2671: END IF;
2672: END IF;

Line 2681: IF P_PA_DEBUG_MODE = 'Y' THEN

2677:
2678: EXCEPTION
2679: WHEN OTHERS THEN
2680:
2681: IF P_PA_DEBUG_MODE = 'Y' THEN
2682: pa_debug.write_file('ChangeCiStatus: in when others exception');
2683: END IF;
2684:
2685: ROLLBACK;

Line 2682: pa_debug.write_file('ChangeCiStatus: in when others exception');

2678: EXCEPTION
2679: WHEN OTHERS THEN
2680:
2681: IF P_PA_DEBUG_MODE = 'Y' THEN
2682: pa_debug.write_file('ChangeCiStatus: in when others exception');
2683: END IF;
2684:
2685: ROLLBACK;
2686:

Line 2735: IF P_PA_DEBUG_MODE = 'Y' THEN

2731: x_msg_count := 0;
2732: x_msg_data := '';
2733:
2734: -- Initialize the Error Stack
2735: IF P_PA_DEBUG_MODE = 'Y' THEN
2736: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2737: END IF;
2738:
2739: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);

Line 2736: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');

2732: x_msg_data := '';
2733:
2734: -- Initialize the Error Stack
2735: IF P_PA_DEBUG_MODE = 'Y' THEN
2736: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2737: END IF;
2738:
2739: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);
2740:

Line 2739: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);

2735: IF P_PA_DEBUG_MODE = 'Y' THEN
2736: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2737: END IF;
2738:
2739: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);
2740:
2741: -- Initialize the return status to success
2742: x_return_status := FND_API.G_RET_STS_SUCCESS;
2743:

Line 2751: IF P_PA_DEBUG_MODE = 'Y' THEN

2747:
2748: IF l_next_sys_status = 'CI_CANCELED' THEN
2749: -- set included CR status to APPROVED
2750:
2751: IF P_PA_DEBUG_MODE = 'Y' THEN
2752: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.change_included_cr_status');
2753: END IF;
2754:
2755: pa_control_items_pvt.change_included_cr_status

Line 2752: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.change_included_cr_status');

2748: IF l_next_sys_status = 'CI_CANCELED' THEN
2749: -- set included CR status to APPROVED
2750:
2751: IF P_PA_DEBUG_MODE = 'Y' THEN
2752: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.change_included_cr_status');
2753: END IF;
2754:
2755: pa_control_items_pvt.change_included_cr_status
2756: (p_ci_id,

Line 2762: IF P_PA_DEBUG_MODE = 'Y' THEN

2758: x_msg_count,
2759: x_msg_data
2760: );
2761:
2762: IF P_PA_DEBUG_MODE = 'Y' THEN
2763: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.change_included_cr_status');
2764: END IF;
2765:
2766: ----- call delete included items api here

Line 2763: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.change_included_cr_status');

2759: x_msg_data
2760: );
2761:
2762: IF P_PA_DEBUG_MODE = 'Y' THEN
2763: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.change_included_cr_status');
2764: END IF;
2765:
2766: ----- call delete included items api here
2767:

Line 2768: IF P_PA_DEBUG_MODE = 'Y' THEN

2764: END IF;
2765:
2766: ----- call delete included items api here
2767:
2768: IF P_PA_DEBUG_MODE = 'Y' THEN
2769: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.delete_all_included_crs');
2770: END IF;
2771:
2772: pa_control_items_pvt.delete_all_included_crs

Line 2769: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.delete_all_included_crs');

2765:
2766: ----- call delete included items api here
2767:
2768: IF P_PA_DEBUG_MODE = 'Y' THEN
2769: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.delete_all_included_crs');
2770: END IF;
2771:
2772: pa_control_items_pvt.delete_all_included_crs
2773: (p_validate_only => 'F',

Line 2780: IF P_PA_DEBUG_MODE = 'Y' THEN

2776: x_return_status => x_return_status,
2777: x_msg_count => x_msg_count,
2778: x_msg_data => x_msg_data);
2779:
2780: IF P_PA_DEBUG_MODE = 'Y' THEN
2781: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.delete_all_included_crs');
2782: END IF;
2783:
2784: -- cancel open actions

Line 2781: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.delete_all_included_crs');

2777: x_msg_count => x_msg_count,
2778: x_msg_data => x_msg_data);
2779:
2780: IF P_PA_DEBUG_MODE = 'Y' THEN
2781: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.delete_all_included_crs');
2782: END IF;
2783:
2784: -- cancel open actions
2785: IF (l_curr_sys_status = 'CI_WORKING' and p_validate_only <> fnd_api.g_true AND x_return_status = 'S') then

Line 2809: IF P_PA_DEBUG_MODE = 'Y' THEN

2805: END IF;
2806:
2807: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2808:
2809: IF P_PA_DEBUG_MODE = 'Y' THEN
2810: pa_debug.write_file('ChangeCiStatus: l_start_wf :'||l_start_wf);
2811: END IF;
2812:
2813: IF (l_start_wf = 'Y') then

Line 2810: pa_debug.write_file('ChangeCiStatus: l_start_wf :'||l_start_wf);

2806:
2807: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2808:
2809: IF P_PA_DEBUG_MODE = 'Y' THEN
2810: pa_debug.write_file('ChangeCiStatus: l_start_wf :'||l_start_wf);
2811: END IF;
2812:
2813: IF (l_start_wf = 'Y') then
2814:

Line 2815: IF P_PA_DEBUG_MODE = 'Y' THEN

2811: END IF;
2812:
2813: IF (l_start_wf = 'Y') then
2814:
2815: IF P_PA_DEBUG_MODE = 'Y' THEN
2816:
2817: pa_debug.write_file('ChangeCiStatus: before call to checkandstartworkflow');
2818: END IF;
2819:

Line 2817: pa_debug.write_file('ChangeCiStatus: before call to checkandstartworkflow');

2813: IF (l_start_wf = 'Y') then
2814:
2815: IF P_PA_DEBUG_MODE = 'Y' THEN
2816:
2817: pa_debug.write_file('ChangeCiStatus: before call to checkandstartworkflow');
2818: END IF;
2819:
2820: checkandstartworkflow
2821: (

Line 2834: IF P_PA_DEBUG_MODE = 'Y' THEN

2830: x_msg_data ,
2831: x_return_status
2832: );
2833:
2834: IF P_PA_DEBUG_MODE = 'Y' THEN
2835: pa_debug.write_file('ChangeCiStatus: after call to checkandstartworkflow');
2836: END IF;
2837:
2838: END IF;

Line 2835: pa_debug.write_file('ChangeCiStatus: after call to checkandstartworkflow');

2831: x_return_status
2832: );
2833:
2834: IF P_PA_DEBUG_MODE = 'Y' THEN
2835: pa_debug.write_file('ChangeCiStatus: after call to checkandstartworkflow');
2836: END IF;
2837:
2838: END IF;
2839:

Line 2847: IF P_PA_DEBUG_MODE = 'Y' THEN

2843:
2844: EXCEPTION
2845: WHEN OTHERS THEN
2846:
2847: IF P_PA_DEBUG_MODE = 'Y' THEN
2848: pa_debug.write_file('ChangeCiStatus: in when others exception');
2849: END IF;
2850:
2851: ROLLBACK;

Line 2848: pa_debug.write_file('ChangeCiStatus: in when others exception');

2844: EXCEPTION
2845: WHEN OTHERS THEN
2846:
2847: IF P_PA_DEBUG_MODE = 'Y' THEN
2848: pa_debug.write_file('ChangeCiStatus: in when others exception');
2849: END IF;
2850:
2851: ROLLBACK;
2852:

Line 2888: IF P_PA_DEBUG_MODE = 'Y' THEN

2884: x_msg_count := 0;
2885: x_msg_data := '';
2886:
2887: -- Initialize the Error Stack
2888: IF P_PA_DEBUG_MODE = 'Y' THEN
2889: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatusWorking');
2890: END IF;
2891:
2892: pa_debug.write_file('ChangeCIStatusWorking: p_pa_debug_mode :'||p_pa_debug_mode);

Line 2889: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatusWorking');

2885: x_msg_data := '';
2886:
2887: -- Initialize the Error Stack
2888: IF P_PA_DEBUG_MODE = 'Y' THEN
2889: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatusWorking');
2890: END IF;
2891:
2892: pa_debug.write_file('ChangeCIStatusWorking: p_pa_debug_mode :'||p_pa_debug_mode);
2893:

Line 2892: pa_debug.write_file('ChangeCIStatusWorking: p_pa_debug_mode :'||p_pa_debug_mode);

2888: IF P_PA_DEBUG_MODE = 'Y' THEN
2889: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatusWorking');
2890: END IF;
2891:
2892: pa_debug.write_file('ChangeCIStatusWorking: p_pa_debug_mode :'||p_pa_debug_mode);
2893:
2894: -- Initialize the return status to success
2895: x_return_status := FND_API.G_RET_STS_SUCCESS;
2896: l_new_status := p_status;

Line 2899: IF P_PA_DEBUG_MODE = 'Y' THEN

2895: x_return_status := FND_API.G_RET_STS_SUCCESS;
2896: l_new_status := p_status;
2897:
2898: -- debug_msg_s1 ('6 ' || x_return_status);
2899: IF P_PA_DEBUG_MODE = 'Y' THEN
2900: pa_debug.write_file('ChangeCIStatusWorking: before call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
2901: END IF;
2902: -- We have verified all the validations while updation. This block is getting executed means
2903: -- some error have been occured, hence we will update the CI status to working.

Line 2900: pa_debug.write_file('ChangeCIStatusWorking: before call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');

2896: l_new_status := p_status;
2897:
2898: -- debug_msg_s1 ('6 ' || x_return_status);
2899: IF P_PA_DEBUG_MODE = 'Y' THEN
2900: pa_debug.write_file('ChangeCIStatusWorking: before call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
2901: END IF;
2902: -- We have verified all the validations while updation. This block is getting executed means
2903: -- some error have been occured, hence we will update the CI status to working.
2904: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (

Line 2917: IF P_PA_DEBUG_MODE = 'Y' THEN

2913: x_return_status,
2914: x_msg_count,
2915: x_msg_data
2916: );
2917: IF P_PA_DEBUG_MODE = 'Y' THEN
2918: pa_debug.write_file('ChangeCIStatusWorking: after call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
2919: END IF;
2920: -- Commit if the flag is set and there is no error
2921: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 2918: pa_debug.write_file('ChangeCIStatusWorking: after call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');

2914: x_msg_count,
2915: x_msg_data
2916: );
2917: IF P_PA_DEBUG_MODE = 'Y' THEN
2918: pa_debug.write_file('ChangeCIStatusWorking: after call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
2919: END IF;
2920: -- Commit if the flag is set and there is no error
2921: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2922:

Line 2923: IF P_PA_DEBUG_MODE = 'Y' THEN

2919: END IF;
2920: -- Commit if the flag is set and there is no error
2921: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2922:
2923: IF P_PA_DEBUG_MODE = 'Y' THEN
2924: pa_debug.write_file('ChangeCIStatusWorking: before COMMIT');
2925: END IF;
2926:
2927: COMMIT;

Line 2924: pa_debug.write_file('ChangeCIStatusWorking: before COMMIT');

2920: -- Commit if the flag is set and there is no error
2921: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2922:
2923: IF P_PA_DEBUG_MODE = 'Y' THEN
2924: pa_debug.write_file('ChangeCIStatusWorking: before COMMIT');
2925: END IF;
2926:
2927: COMMIT;
2928:

Line 2941: Pa_Debug.Reset_Err_Stack;

2937: ,p_msg_index_out => l_msg_index_out
2938: );
2939: END IF;
2940:
2941: Pa_Debug.Reset_Err_Stack;
2942:
2943: EXCEPTION
2944: WHEN OTHERS THEN
2945:

Line 2946: IF P_PA_DEBUG_MODE = 'Y' THEN

2942:
2943: EXCEPTION
2944: WHEN OTHERS THEN
2945:
2946: IF P_PA_DEBUG_MODE = 'Y' THEN
2947: pa_debug.write_file('ChangeCIStatusWorking: in when others exception');
2948: END IF;
2949:
2950: ROLLBACK;

Line 2947: pa_debug.write_file('ChangeCIStatusWorking: in when others exception');

2943: EXCEPTION
2944: WHEN OTHERS THEN
2945:
2946: IF P_PA_DEBUG_MODE = 'Y' THEN
2947: pa_debug.write_file('ChangeCIStatusWorking: in when others exception');
2948: END IF;
2949:
2950: ROLLBACK;
2951: