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.12.12010000.2 2008/08/22 16:08:05 mumohan 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 898: IF P_PA_DEBUG_MODE = 'Y' THEN

894: x_msg_count := 0;
895: x_msg_data := '';
896:
897: -- Initialize the Error Stack
898: IF P_PA_DEBUG_MODE = 'Y' THEN
899: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
900: END IF;
901:
902: pa_debug.write_file('ChangeCiStatus: p_pa_debug_mode :'||p_pa_debug_mode);

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

895: x_msg_data := '';
896:
897: -- Initialize the Error Stack
898: IF P_PA_DEBUG_MODE = 'Y' THEN
899: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
900: END IF;
901:
902: pa_debug.write_file('ChangeCiStatus: p_pa_debug_mode :'||p_pa_debug_mode);
903:

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

898: IF P_PA_DEBUG_MODE = 'Y' THEN
899: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
900: END IF;
901:
902: pa_debug.write_file('ChangeCiStatus: p_pa_debug_mode :'||p_pa_debug_mode);
903:
904: -- Initialize the return status to success
905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906:

Line 934: IF P_PA_DEBUG_MODE = 'Y' THEN

930:
931: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
932: -- debug_msg_s1 ('6 ' || x_return_status);
933:
934: IF P_PA_DEBUG_MODE = 'Y' THEN
935: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
936: END IF;
937:
938: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (

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

931: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
932: -- debug_msg_s1 ('6 ' || x_return_status);
933:
934: IF P_PA_DEBUG_MODE = 'Y' THEN
935: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
936: END IF;
937:
938: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (
939: 1.0,

Line 951: IF P_PA_DEBUG_MODE = 'Y' THEN

947: x_return_status,
948: x_msg_count,
949: x_msg_data
950: );
951: IF P_PA_DEBUG_MODE = 'Y' THEN
952: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
953: END IF;
954:
955:

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

948: x_msg_count,
949: x_msg_data
950: );
951: IF P_PA_DEBUG_MODE = 'Y' THEN
952: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS');
953: END IF;
954:
955:
956: --Bug # 4618856 - if statement is added to check the return status

Line 960: IF P_PA_DEBUG_MODE = 'Y' THEN

956: --Bug # 4618856 - if statement is added to check the return status
957: IF (x_return_status = 'S') THEN
958:
959: /* Bug#3297238: call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
960: IF P_PA_DEBUG_MODE = 'Y' THEN
961: pa_debug.write_file('ChangeCiStatus: before call to ADD_STATUS_CHANGE_COMMENT');
962: END IF;
963:
964: DBMS_LOCK.SLEEP(1); -- Bug 7022037

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

957: IF (x_return_status = 'S') THEN
958:
959: /* Bug#3297238: call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
960: IF P_PA_DEBUG_MODE = 'Y' THEN
961: pa_debug.write_file('ChangeCiStatus: before call to ADD_STATUS_CHANGE_COMMENT');
962: END IF;
963:
964: DBMS_LOCK.SLEEP(1); -- Bug 7022037
965:

Line 977: IF P_PA_DEBUG_MODE = 'Y' THEN

973: ,x_return_status => x_return_status
974: ,x_msg_count => x_msg_count
975: ,x_msg_data => x_msg_data );
976:
977: IF P_PA_DEBUG_MODE = 'Y' THEN
978: pa_debug.write_file('ChangeCiStatus: after call to ADD_STATUS_CHANGE_COMMENT');
979: END IF;
980: END IF;
981:

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

974: ,x_msg_count => x_msg_count
975: ,x_msg_data => x_msg_data );
976:
977: IF P_PA_DEBUG_MODE = 'Y' THEN
978: pa_debug.write_file('ChangeCiStatus: after call to ADD_STATUS_CHANGE_COMMENT');
979: END IF;
980: END IF;
981:
982: END IF;

Line 1011: IF P_PA_DEBUG_MODE = 'Y' THEN

1007:
1008: -- Commit if the flag is set and there is no error
1009: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1010:
1011: IF P_PA_DEBUG_MODE = 'Y' THEN
1012: pa_debug.write_file('ChangeCiStatus: before COMMIT');
1013: END IF;
1014:
1015: COMMIT;

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

1008: -- Commit if the flag is set and there is no error
1009: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1010:
1011: IF P_PA_DEBUG_MODE = 'Y' THEN
1012: pa_debug.write_file('ChangeCiStatus: before COMMIT');
1013: END IF;
1014:
1015: COMMIT;
1016:

Line 1029: Pa_Debug.Reset_Err_Stack;

1025: ,p_msg_index_out => l_msg_index_out
1026: );
1027: END IF;
1028:
1029: Pa_Debug.Reset_Err_Stack;
1030:
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033:

Line 1034: IF P_PA_DEBUG_MODE = 'Y' THEN

1030:
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033:
1034: IF P_PA_DEBUG_MODE = 'Y' THEN
1035: pa_debug.write_file('ChangeCiStatus: in when others exception');
1036: END IF;
1037:
1038: ROLLBACK;

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

1031: EXCEPTION
1032: WHEN OTHERS THEN
1033:
1034: IF P_PA_DEBUG_MODE = 'Y' THEN
1035: pa_debug.write_file('ChangeCiStatus: in when others exception');
1036: END IF;
1037:
1038: ROLLBACK;
1039:

Line 2184: IF P_PA_DEBUG_MODE = 'Y' THEN

2180: x_msg_data := '';
2181: x_start_wf := l_start_wf;
2182:
2183: -- Initialize the Error Stack
2184: IF P_PA_DEBUG_MODE = 'Y' THEN
2185: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2186: END IF;
2187:
2188: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);

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

2181: x_start_wf := l_start_wf;
2182:
2183: -- Initialize the Error Stack
2184: IF P_PA_DEBUG_MODE = 'Y' THEN
2185: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2186: END IF;
2187:
2188: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);
2189:

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

2184: IF P_PA_DEBUG_MODE = 'Y' THEN
2185: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2186: END IF;
2187:
2188: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);
2189:
2190: -- Initialize the return status to success
2191: x_return_status := FND_API.G_RET_STS_SUCCESS;
2192:

Line 2230: IF P_PA_DEBUG_MODE = 'Y' THEN

2226:
2227: l_temp := pa_ci_security_pkg.check_change_status_access(p_ci_id,
2228: fnd_global.user_id);
2229:
2230: IF P_PA_DEBUG_MODE = 'Y' THEN
2231: pa_debug.write_file('ChangeCiStatusValidate: pa_ci_security_pkg.check_change_status_access :'||l_temp);
2232: END IF;
2233:
2234: IF (l_temp <> 'T') THEN

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

2227: l_temp := pa_ci_security_pkg.check_change_status_access(p_ci_id,
2228: fnd_global.user_id);
2229:
2230: IF P_PA_DEBUG_MODE = 'Y' THEN
2231: pa_debug.write_file('ChangeCiStatusValidate: pa_ci_security_pkg.check_change_status_access :'||l_temp);
2232: END IF;
2233:
2234: IF (l_temp <> 'T') THEN
2235: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2235: IF P_PA_DEBUG_MODE = 'Y' THEN

2231: pa_debug.write_file('ChangeCiStatusValidate: pa_ci_security_pkg.check_change_status_access :'||l_temp);
2232: END IF;
2233:
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');

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

2232: END IF;
2233:
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;

Line 2252: IF P_PA_DEBUG_MODE = 'Y' THEN

2248: OPEN c_submit_status(p_status);
2249: FETCH c_submit_status INTO l_submit_status_flag, l_submit_status;
2250: CLOSE c_submit_status;
2251:
2252: IF P_PA_DEBUG_MODE = 'Y' THEN
2253: pa_debug.write_file('ChangeCiStatusValidate: l_submit_status_flag :'||l_submit_status_flag);
2254: pa_debug.write_file('ChangeCiStatusValidate: l_submit_status:'||l_submit_status);
2255: END IF;
2256:

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

2249: FETCH c_submit_status INTO l_submit_status_flag, l_submit_status;
2250: CLOSE c_submit_status;
2251:
2252: IF P_PA_DEBUG_MODE = 'Y' THEN
2253: pa_debug.write_file('ChangeCiStatusValidate: l_submit_status_flag :'||l_submit_status_flag);
2254: pa_debug.write_file('ChangeCiStatusValidate: l_submit_status:'||l_submit_status);
2255: END IF;
2256:
2257: IF l_submit_status_flag = 'Y' THEN

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

2250: CLOSE c_submit_status;
2251:
2252: IF P_PA_DEBUG_MODE = 'Y' THEN
2253: pa_debug.write_file('ChangeCiStatusValidate: l_submit_status_flag :'||l_submit_status_flag);
2254: pa_debug.write_file('ChangeCiStatusValidate: l_submit_status:'||l_submit_status);
2255: END IF;
2256:
2257: IF l_submit_status_flag = 'Y' THEN
2258:

Line 2260: IF P_PA_DEBUG_MODE = 'Y' THEN

2256:
2257: IF l_submit_status_flag = 'Y' THEN
2258:
2259: l_approval_required := checkapprovalrequired (p_ci_id);
2260: IF P_PA_DEBUG_MODE = 'Y' THEN
2261: pa_debug.write_file('ChangeCiStatusValidate: l_approval_required :'||l_approval_required);
2262: END IF;
2263:
2264: IF l_approval_required = 'Y' or l_approval_required = 'A' THEN

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

2257: IF l_submit_status_flag = 'Y' THEN
2258:
2259: l_approval_required := checkapprovalrequired (p_ci_id);
2260: IF P_PA_DEBUG_MODE = 'Y' THEN
2261: pa_debug.write_file('ChangeCiStatusValidate: l_approval_required :'||l_approval_required);
2262: END IF;
2263:
2264: IF l_approval_required = 'Y' or l_approval_required = 'A' THEN
2265: -- check the type is CR, CO, ISSUE

Line 2268: IF P_PA_DEBUG_MODE = 'Y' THEN

2264: IF l_approval_required = 'Y' or l_approval_required = 'A' THEN
2265: -- check the type is CR, CO, ISSUE
2266: l_type := getcitypeclasscode(p_ci_id);
2267:
2268: IF P_PA_DEBUG_MODE = 'Y' THEN
2269: pa_debug.write_file('ChangeCiStatusValidate: l_type :'||l_type);
2270: END IF;
2271:
2272: IF l_type = 'CHANGE_ORDER' OR l_type = 'CHANGE_REQUEST' OR l_type = 'ISSUE' THEN

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

2265: -- check the type is CR, CO, ISSUE
2266: l_type := getcitypeclasscode(p_ci_id);
2267:
2268: IF P_PA_DEBUG_MODE = 'Y' THEN
2269: pa_debug.write_file('ChangeCiStatusValidate: l_type :'||l_type);
2270: END IF;
2271:
2272: IF l_type = 'CHANGE_ORDER' OR l_type = 'CHANGE_REQUEST' OR l_type = 'ISSUE' THEN
2273:

Line 2284: IF P_PA_DEBUG_MODE = 'Y' THEN

2280: l_start_wf := 'N';
2281: x_start_wf := l_start_wf;
2282: x_new_status := l_new_status;
2283:
2284: IF P_PA_DEBUG_MODE = 'Y' THEN
2285: pa_debug.write_file('ChangeCiStatusValidate: l_new_status :'||l_new_status);
2286: pa_debug.write_file('ChangeCiStatusValidate: l_start_wf :'||l_start_wf);
2287: END IF;
2288:

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

2281: x_start_wf := l_start_wf;
2282: x_new_status := l_new_status;
2283:
2284: IF P_PA_DEBUG_MODE = 'Y' THEN
2285: pa_debug.write_file('ChangeCiStatusValidate: l_new_status :'||l_new_status);
2286: pa_debug.write_file('ChangeCiStatusValidate: l_start_wf :'||l_start_wf);
2287: END IF;
2288:
2289: END IF;

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

2282: x_new_status := l_new_status;
2283:
2284: IF P_PA_DEBUG_MODE = 'Y' THEN
2285: pa_debug.write_file('ChangeCiStatusValidate: l_new_status :'||l_new_status);
2286: pa_debug.write_file('ChangeCiStatusValidate: l_start_wf :'||l_start_wf);
2287: END IF;
2288:
2289: END IF;
2290:

Line 2293: IF P_PA_DEBUG_MODE = 'Y' THEN

2289: END IF;
2290:
2291: l_temp := pa_ci_actions_util.check_open_actions_exist (p_ci_id);
2292:
2293: IF P_PA_DEBUG_MODE = 'Y' THEN
2294: pa_debug.write_file('ChangeCiStatusValidate: pa_ci_actions_util.check_open_actions_exist :'||l_temp);
2295:
2296: END IF;
2297:

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

2290:
2291: l_temp := pa_ci_actions_util.check_open_actions_exist (p_ci_id);
2292:
2293: IF P_PA_DEBUG_MODE = 'Y' THEN
2294: pa_debug.write_file('ChangeCiStatusValidate: pa_ci_actions_util.check_open_actions_exist :'||l_temp);
2295:
2296: END IF;
2297:
2298: IF l_temp = 'Y' THEN

Line 2301: IF P_PA_DEBUG_MODE = 'Y' THEN

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

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

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;
2304: x_return_status := FND_API.G_RET_STS_ERROR;
2305: ELSE
2306: -- check resolution is provided

Line 2308: IF P_PA_DEBUG_MODE = 'Y' THEN

2304: x_return_status := FND_API.G_RET_STS_ERROR;
2305: ELSE
2306: -- check resolution is provided
2307: IF p_resolution_check = 'UI' THEN
2308: IF P_PA_DEBUG_MODE = 'Y' THEN
2309: pa_debug.write_file('ChangeCiStatus: checkresolutionrequired :'||checkresolutionrequired(p_ci_id));
2310: END IF;
2311: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2312:

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

2305: ELSE
2306: -- check resolution is provided
2307: IF p_resolution_check = 'UI' THEN
2308: IF P_PA_DEBUG_MODE = 'Y' THEN
2309: pa_debug.write_file('ChangeCiStatus: checkresolutionrequired :'||checkresolutionrequired(p_ci_id));
2310: END IF;
2311: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2312:
2313: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2313: IF P_PA_DEBUG_MODE = 'Y' THEN

2309: pa_debug.write_file('ChangeCiStatus: checkresolutionrequired :'||checkresolutionrequired(p_ci_id));
2310: END IF;
2311: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2312:
2313: IF P_PA_DEBUG_MODE = 'Y' THEN
2314: pa_debug.write_file('ChangeCiStatusValidate: checkhasresolution :'||checkhasresolution (p_ci_id));
2315: END IF;
2316: IF checkhasresolution (p_ci_id) = 'Y' THEN
2317: IF l_type = 'CHANGE_ORDER' OR l_type = 'CHANGE_REQUEST' OR l_type = 'ISSUE' THEN

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

2310: END IF;
2311: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2312:
2313: IF P_PA_DEBUG_MODE = 'Y' THEN
2314: pa_debug.write_file('ChangeCiStatusValidate: checkhasresolution :'||checkhasresolution (p_ci_id));
2315: END IF;
2316: IF checkhasresolution (p_ci_id) = 'Y' THEN
2317: IF l_type = 'CHANGE_ORDER' OR l_type = 'CHANGE_REQUEST' OR l_type = 'ISSUE' THEN
2318: NULL;

Line 2323: IF P_PA_DEBUG_MODE = 'Y' THEN

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

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

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;
2326: x_return_status := FND_API.G_RET_STS_ERROR;
2327: END IF;
2328: END IF;

Line 2330: IF P_PA_DEBUG_MODE = 'Y' THEN

2326: x_return_status := FND_API.G_RET_STS_ERROR;
2327: END IF;
2328: END IF;
2329: ELSIF p_resolution_check = 'AMG' THEN
2330: IF P_PA_DEBUG_MODE = 'Y' THEN
2331: pa_debug.write_file('ChangeCiStatus: AMG checkresolutionrequired :'||checkresolutionrequired(p_ci_id));
2332: END IF;
2333: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2334: x_resolution_req := 'Y';

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

2327: END IF;
2328: END IF;
2329: ELSIF p_resolution_check = 'AMG' THEN
2330: IF P_PA_DEBUG_MODE = 'Y' THEN
2331: pa_debug.write_file('ChangeCiStatus: AMG checkresolutionrequired :'||checkresolutionrequired(p_ci_id));
2332: END IF;
2333: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2334: x_resolution_req := 'Y';
2335: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2335: IF P_PA_DEBUG_MODE = 'Y' THEN

2331: pa_debug.write_file('ChangeCiStatus: AMG checkresolutionrequired :'||checkresolutionrequired(p_ci_id));
2332: END IF;
2333: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2334: x_resolution_req := 'Y';
2335: IF P_PA_DEBUG_MODE = 'Y' THEN
2336: pa_debug.write_file('ChangeCiStatusValidate: AMG checkhasresolution :'||checkhasresolution (p_ci_id));
2337: END IF;
2338: END IF;
2339: END IF; /* IF p_resolution_check = 'UI' */

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

2332: END IF;
2333: IF checkresolutionrequired(p_ci_id) = 'Y' THEN
2334: x_resolution_req := 'Y';
2335: IF P_PA_DEBUG_MODE = 'Y' THEN
2336: pa_debug.write_file('ChangeCiStatusValidate: AMG checkhasresolution :'||checkhasresolution (p_ci_id));
2337: END IF;
2338: END IF;
2339: END IF; /* IF p_resolution_check = 'UI' */
2340: END IF; /* if l_temp = 'Y' */

Line 2345: IF P_PA_DEBUG_MODE = 'Y' THEN

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;

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

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:

Line 2354: IF P_PA_DEBUG_MODE = 'Y' THEN

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

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

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

Line 2367: IF P_PA_DEBUG_MODE = 'Y' THEN

2363: OPEN check_if_fin_impact_exists;
2364: FETCH check_if_fin_impact_exists INTO l_tp;
2365: CLOSE check_if_fin_impact_exists;
2366:
2367: IF P_PA_DEBUG_MODE = 'Y' THEN
2368: pa_debug.write_file('ChangeCiStatusValidate: check_if_fin_impact_exists: '||l_tp);
2369: END IF;
2370:
2371: IF l_tp = 'Y' THEN

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

2364: FETCH check_if_fin_impact_exists INTO l_tp;
2365: CLOSE check_if_fin_impact_exists;
2366:
2367: IF P_PA_DEBUG_MODE = 'Y' THEN
2368: pa_debug.write_file('ChangeCiStatusValidate: check_if_fin_impact_exists: '||l_tp);
2369: END IF;
2370:
2371: IF l_tp = 'Y' THEN
2372:

Line 2373: IF P_PA_DEBUG_MODE = 'Y' THEN

2369: END IF;
2370:
2371: IF l_tp = 'Y' THEN
2372:
2373: IF P_PA_DEBUG_MODE = 'Y' THEN
2374: pa_debug.write_file('ChangeCiStatus: before call to Pa_Fp_Control_Items_Utils.Fp_Ci_Impact_Submit_Chk');
2375:
2376: END IF;
2377:

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

2370:
2371: IF l_tp = 'Y' THEN
2372:
2373: IF P_PA_DEBUG_MODE = 'Y' THEN
2374: pa_debug.write_file('ChangeCiStatus: before call to Pa_Fp_Control_Items_Utils.Fp_Ci_Impact_Submit_Chk');
2375:
2376: END IF;
2377:
2378: Pa_Fp_Control_Items_Utils.Fp_Ci_Impact_Submit_Chk

Line 2385: IF P_PA_DEBUG_MODE = 'Y' THEN

2381: ,x_return_status => x_return_status
2382: ,x_msg_count => x_msg_count
2383: ,x_msg_data => x_msg_data) ;
2384:
2385: IF P_PA_DEBUG_MODE = 'Y' THEN
2386: pa_debug.write_file('ChangeCiStatusValidate: after call to Pa_Fp_Control_Items_Utils.Fp_Ci_Impact_Submit_Chk');
2387:
2388: END IF;
2389:

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

2382: ,x_msg_count => x_msg_count
2383: ,x_msg_data => x_msg_data) ;
2384:
2385: IF P_PA_DEBUG_MODE = 'Y' THEN
2386: pa_debug.write_file('ChangeCiStatusValidate: after call to Pa_Fp_Control_Items_Utils.Fp_Ci_Impact_Submit_Chk');
2387:
2388: END IF;
2389:
2390: END IF;

Line 2395: IF P_PA_DEBUG_MODE = 'Y' THEN

2391: END IF;
2392:
2393: END IF; /* IF l_submit_status_flag = 'Y' THEN */
2394:
2395: IF P_PA_DEBUG_MODE = 'Y' THEN
2396: pa_debug.write_file('ChangeCiStatusValidate: end of ');
2397: END IF;
2398:
2399: IF l_next_sys_status = 'CI_CANCELED' THEN

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

2392:
2393: END IF; /* IF l_submit_status_flag = 'Y' THEN */
2394:
2395: IF P_PA_DEBUG_MODE = 'Y' THEN
2396: pa_debug.write_file('ChangeCiStatusValidate: end of ');
2397: END IF;
2398:
2399: IF l_next_sys_status = 'CI_CANCELED' THEN
2400:

Line 2401: IF P_PA_DEBUG_MODE = 'Y' THEN

2397: END IF;
2398:
2399: IF l_next_sys_status = 'CI_CANCELED' THEN
2400:
2401: IF P_PA_DEBUG_MODE = 'Y' THEN
2402: pa_debug.write_file('ChangeCiStatusValidate: in ');
2403: END IF;
2404: l_type := getcitypeclasscode(p_ci_id);
2405:

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

2398:
2399: IF l_next_sys_status = 'CI_CANCELED' THEN
2400:
2401: IF P_PA_DEBUG_MODE = 'Y' THEN
2402: pa_debug.write_file('ChangeCiStatusValidate: in ');
2403: END IF;
2404: l_type := getcitypeclasscode(p_ci_id);
2405:
2406: IF l_type = 'CHANGE_ORDER' OR l_type = 'CHANGE_REQUEST' THEN

Line 2414: IF P_PA_DEBUG_MODE = 'Y' THEN

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 PA_CI_CANCEL_INV_IMP');
2416:
2417: END IF;
2418: x_return_status := FND_API.G_RET_STS_ERROR;

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

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 PA_CI_CANCEL_INV_IMP');
2416:
2417: END IF;
2418: x_return_status := FND_API.G_RET_STS_ERROR;
2419: END IF;

Line 2424: IF P_PA_DEBUG_MODE = 'Y' THEN

2420: END IF;
2421:
2422: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2423: -- cancel workflow
2424: IF P_PA_DEBUG_MODE = 'Y' THEN
2425: pa_debug.write_file('ChangeCiStatusValidate: in before cancelworkflow');
2426:
2427: END IF;
2428: cancelworkflow

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

2421:
2422: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2423: -- cancel workflow
2424: IF P_PA_DEBUG_MODE = 'Y' THEN
2425: pa_debug.write_file('ChangeCiStatusValidate: in before cancelworkflow');
2426:
2427: END IF;
2428: cancelworkflow
2429: (

Line 2440: IF P_PA_DEBUG_MODE = 'Y' THEN

2436: x_msg_count ,
2437: x_msg_data ,
2438: x_return_status
2439: );
2440: IF P_PA_DEBUG_MODE = 'Y' THEN
2441: pa_debug.write_file('ChangeCiStatusValidate: in after cancelworkflow');
2442:
2443: END IF;
2444:

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

2437: x_msg_data ,
2438: x_return_status
2439: );
2440: IF P_PA_DEBUG_MODE = 'Y' THEN
2441: pa_debug.write_file('ChangeCiStatusValidate: in after cancelworkflow');
2442:
2443: END IF;
2444:
2445: END IF;

Line 2449: IF P_PA_DEBUG_MODE = 'Y' THEN

2445: END IF;
2446:
2447: ELSIF l_next_sys_status = 'CI_CLOSED' THEN
2448:
2449: IF P_PA_DEBUG_MODE = 'Y' THEN
2450: pa_debug.write_file('ChangeCiStatusValidate: in ');
2451: END IF;
2452:
2453: l_type := getcitypeclasscode(p_ci_id);

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

2446:
2447: ELSIF l_next_sys_status = 'CI_CLOSED' THEN
2448:
2449: IF P_PA_DEBUG_MODE = 'Y' THEN
2450: pa_debug.write_file('ChangeCiStatusValidate: in ');
2451: END IF;
2452:
2453: l_type := getcitypeclasscode(p_ci_id);
2454:

Line 2463: IF P_PA_DEBUG_MODE = 'Y' THEN

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 PA_CI_CLOSE_INV_IMP');
2465:
2466: END IF;
2467: x_return_status := FND_API.G_RET_STS_ERROR;

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

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 PA_CI_CLOSE_INV_IMP');
2465:
2466: END IF;
2467: x_return_status := FND_API.G_RET_STS_ERROR;
2468: END IF;

Line 2477: IF P_PA_DEBUG_MODE = 'Y' THEN

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 PA_CI_CLOSE_INV_ACT');
2479:
2480: END IF;
2481: x_return_status := FND_API.G_RET_STS_ERROR;

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

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 PA_CI_CLOSE_INV_ACT');
2479:
2480: END IF;
2481: x_return_status := FND_API.G_RET_STS_ERROR;
2482: END IF;

Line 2491: IF P_PA_DEBUG_MODE = '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 PA_CI_CLOSE_INV_RES');
2493: END IF;
2494: x_return_status := FND_API.G_RET_STS_ERROR;
2495: END IF;

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

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 PA_CI_CLOSE_INV_RES');
2493: END IF;
2494: x_return_status := FND_API.G_RET_STS_ERROR;
2495: END IF;
2496: END IF;

Line 2510: IF P_PA_DEBUG_MODE = 'Y' THEN

2506: END IF;
2507:
2508: IF l_curr_sys_status = 'CI_APPROVED' THEN
2509:
2510: IF P_PA_DEBUG_MODE = 'Y' THEN
2511: pa_debug.write_file('ChangeCiStatus: in and');
2512: END IF;
2513:
2514: IF l_next_sys_status = 'CI_WORKING' THEN

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

2507:
2508: IF l_curr_sys_status = 'CI_APPROVED' THEN
2509:
2510: IF P_PA_DEBUG_MODE = 'Y' THEN
2511: pa_debug.write_file('ChangeCiStatus: in and');
2512: END IF;
2513:
2514: IF l_next_sys_status = 'CI_WORKING' THEN
2515: -- check no impact is implemented

Line 2521: IF P_PA_DEBUG_MODE = 'Y' THEN

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 PA_CI_WORKING_INV_IMP');
2523:
2524:
2525: END IF;

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

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 PA_CI_WORKING_INV_IMP');
2523:
2524:
2525: END IF;
2526: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2540: IF P_PA_DEBUG_MODE = 'Y' THEN

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 PA_CI_CLOSE_INV_IMP');
2542: END IF;
2543: x_return_status := FND_API.G_RET_STS_ERROR;
2544: END IF;

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

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 PA_CI_CLOSE_INV_IMP');
2542: END IF;
2543: x_return_status := FND_API.G_RET_STS_ERROR;
2544: END IF;
2545: END IF;

Line 2556: IF P_PA_DEBUG_MODE = 'Y' THEN

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 PA_CI_CANCEL_INV_IMP');
2558: END IF;
2559: x_return_status := FND_API.G_RET_STS_ERROR;
2560: END IF;

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

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 PA_CI_CANCEL_INV_IMP');
2558: END IF;
2559: x_return_status := FND_API.G_RET_STS_ERROR;
2560: END IF;
2561: END IF;

Line 2570: IF P_PA_DEBUG_MODE = 'Y' THEN

2566:
2567: EXCEPTION
2568: WHEN OTHERS THEN
2569:
2570: IF P_PA_DEBUG_MODE = 'Y' THEN
2571: pa_debug.write_file('ChangeCiStatus: in when others exception');
2572: END IF;
2573:
2574: ROLLBACK;

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

2567: EXCEPTION
2568: WHEN OTHERS THEN
2569:
2570: IF P_PA_DEBUG_MODE = 'Y' THEN
2571: pa_debug.write_file('ChangeCiStatus: in when others exception');
2572: END IF;
2573:
2574: ROLLBACK;
2575:

Line 2624: IF P_PA_DEBUG_MODE = 'Y' THEN

2620: x_msg_count := 0;
2621: x_msg_data := '';
2622:
2623: -- Initialize the Error Stack
2624: IF P_PA_DEBUG_MODE = 'Y' THEN
2625: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2626: END IF;
2627:
2628: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);

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

2621: x_msg_data := '';
2622:
2623: -- Initialize the Error Stack
2624: IF P_PA_DEBUG_MODE = 'Y' THEN
2625: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2626: END IF;
2627:
2628: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);
2629:

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

2624: IF P_PA_DEBUG_MODE = 'Y' THEN
2625: PA_DEBUG.init_err_stack('PA_CONTROL_ITEMS_UTILS.ChangeCIStatus');
2626: END IF;
2627:
2628: pa_debug.write_file('ChangeCiStatusValidate: p_pa_debug_mode :'||p_pa_debug_mode);
2629:
2630: -- Initialize the return status to success
2631: x_return_status := FND_API.G_RET_STS_SUCCESS;
2632:

Line 2640: IF P_PA_DEBUG_MODE = 'Y' THEN

2636:
2637: IF l_next_sys_status = 'CI_CANCELED' THEN
2638: -- set included CR status to APPROVED
2639:
2640: IF P_PA_DEBUG_MODE = 'Y' THEN
2641: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.change_included_cr_status');
2642: END IF;
2643:
2644: pa_control_items_pvt.change_included_cr_status

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

2637: IF l_next_sys_status = 'CI_CANCELED' THEN
2638: -- set included CR status to APPROVED
2639:
2640: IF P_PA_DEBUG_MODE = 'Y' THEN
2641: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.change_included_cr_status');
2642: END IF;
2643:
2644: pa_control_items_pvt.change_included_cr_status
2645: (p_ci_id,

Line 2651: IF P_PA_DEBUG_MODE = 'Y' THEN

2647: x_msg_count,
2648: x_msg_data
2649: );
2650:
2651: IF P_PA_DEBUG_MODE = 'Y' THEN
2652: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.change_included_cr_status');
2653: END IF;
2654:
2655: ----- call delete included items api here

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

2648: x_msg_data
2649: );
2650:
2651: IF P_PA_DEBUG_MODE = 'Y' THEN
2652: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.change_included_cr_status');
2653: END IF;
2654:
2655: ----- call delete included items api here
2656:

Line 2657: IF P_PA_DEBUG_MODE = 'Y' THEN

2653: END IF;
2654:
2655: ----- call delete included items api here
2656:
2657: IF P_PA_DEBUG_MODE = 'Y' THEN
2658: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.delete_all_included_crs');
2659: END IF;
2660:
2661: pa_control_items_pvt.delete_all_included_crs

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

2654:
2655: ----- call delete included items api here
2656:
2657: IF P_PA_DEBUG_MODE = 'Y' THEN
2658: pa_debug.write_file('ChangeCiStatus: before call to pa_control_items_pvt.delete_all_included_crs');
2659: END IF;
2660:
2661: pa_control_items_pvt.delete_all_included_crs
2662: (p_validate_only => 'F',

Line 2669: IF P_PA_DEBUG_MODE = 'Y' THEN

2665: x_return_status => x_return_status,
2666: x_msg_count => x_msg_count,
2667: x_msg_data => x_msg_data);
2668:
2669: IF P_PA_DEBUG_MODE = 'Y' THEN
2670: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.delete_all_included_crs');
2671: END IF;
2672:
2673: -- cancel open actions

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

2666: x_msg_count => x_msg_count,
2667: x_msg_data => x_msg_data);
2668:
2669: IF P_PA_DEBUG_MODE = 'Y' THEN
2670: pa_debug.write_file('ChangeCiStatus: after call to pa_control_items_pvt.delete_all_included_crs');
2671: END IF;
2672:
2673: -- cancel open actions
2674: IF (l_curr_sys_status = 'CI_WORKING' and p_validate_only <> fnd_api.g_true AND x_return_status = 'S') then

Line 2698: IF P_PA_DEBUG_MODE = 'Y' THEN

2694: END IF;
2695:
2696: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2697:
2698: IF P_PA_DEBUG_MODE = 'Y' THEN
2699: pa_debug.write_file('ChangeCiStatus: l_start_wf :'||l_start_wf);
2700: END IF;
2701:
2702: IF (l_start_wf = 'Y') then

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

2695:
2696: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2697:
2698: IF P_PA_DEBUG_MODE = 'Y' THEN
2699: pa_debug.write_file('ChangeCiStatus: l_start_wf :'||l_start_wf);
2700: END IF;
2701:
2702: IF (l_start_wf = 'Y') then
2703:

Line 2704: IF P_PA_DEBUG_MODE = 'Y' THEN

2700: END IF;
2701:
2702: IF (l_start_wf = 'Y') then
2703:
2704: IF P_PA_DEBUG_MODE = 'Y' THEN
2705:
2706: pa_debug.write_file('ChangeCiStatus: before call to checkandstartworkflow');
2707: END IF;
2708:

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

2702: IF (l_start_wf = 'Y') then
2703:
2704: IF P_PA_DEBUG_MODE = 'Y' THEN
2705:
2706: pa_debug.write_file('ChangeCiStatus: before call to checkandstartworkflow');
2707: END IF;
2708:
2709: checkandstartworkflow
2710: (

Line 2723: IF P_PA_DEBUG_MODE = 'Y' THEN

2719: x_msg_data ,
2720: x_return_status
2721: );
2722:
2723: IF P_PA_DEBUG_MODE = 'Y' THEN
2724: pa_debug.write_file('ChangeCiStatus: after call to checkandstartworkflow');
2725: END IF;
2726:
2727: END IF;

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

2720: x_return_status
2721: );
2722:
2723: IF P_PA_DEBUG_MODE = 'Y' THEN
2724: pa_debug.write_file('ChangeCiStatus: after call to checkandstartworkflow');
2725: END IF;
2726:
2727: END IF;
2728:

Line 2736: IF P_PA_DEBUG_MODE = 'Y' THEN

2732:
2733: EXCEPTION
2734: WHEN OTHERS THEN
2735:
2736: IF P_PA_DEBUG_MODE = 'Y' THEN
2737: pa_debug.write_file('ChangeCiStatus: in when others exception');
2738: END IF;
2739:
2740: ROLLBACK;

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

2733: EXCEPTION
2734: WHEN OTHERS THEN
2735:
2736: IF P_PA_DEBUG_MODE = 'Y' THEN
2737: pa_debug.write_file('ChangeCiStatus: in when others exception');
2738: END IF;
2739:
2740: ROLLBACK;
2741: