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 FND_API

Line 686: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

682:
683: PROCEDURE checkandstartworkflow
684: (
685: p_api_version IN NUMBER := 1.0,
686: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
687: p_commit IN VARCHAR2 := FND_API.g_false,
688: p_validate_only IN VARCHAR2 := FND_API.g_true,
689: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
690:

Line 687: p_commit IN VARCHAR2 := FND_API.g_false,

683: PROCEDURE checkandstartworkflow
684: (
685: p_api_version IN NUMBER := 1.0,
686: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
687: p_commit IN VARCHAR2 := FND_API.g_false,
688: p_validate_only IN VARCHAR2 := FND_API.g_true,
689: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
690:
691: p_ci_id in NUMBER,

Line 688: p_validate_only IN VARCHAR2 := FND_API.g_true,

684: (
685: p_api_version IN NUMBER := 1.0,
686: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
687: p_commit IN VARCHAR2 := FND_API.g_false,
688: p_validate_only IN VARCHAR2 := FND_API.g_true,
689: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
690:
691: p_ci_id in NUMBER,
692: p_status_code IN VARCHAR2,

Line 689: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

685: p_api_version IN NUMBER := 1.0,
686: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
687: p_commit IN VARCHAR2 := FND_API.g_false,
688: p_validate_only IN VARCHAR2 := FND_API.g_true,
689: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
690:
691: p_ci_id in NUMBER,
692: p_status_code IN VARCHAR2,
693:

Line 714: x_return_status := FND_API.G_RET_STS_SUCCESS;

710:
711: BEGIN
712:
713: -- Initialize the return status to success
714: x_return_status := FND_API.G_RET_STS_SUCCESS;
715:
716: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
717: OPEN get_wf_info;
718: FETCH get_wf_info INTO l_wf_item_type, l_wf_process_name, l_wf_enable;

Line 716: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then

712:
713: -- Initialize the return status to success
714: x_return_status := FND_API.G_RET_STS_SUCCESS;
715:
716: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
717: OPEN get_wf_info;
718: FETCH get_wf_info INTO l_wf_item_type, l_wf_process_name, l_wf_enable;
719:
720: --debug_msg_s1 ('start workflow ' || p_status_code);

Line 752: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

748:
749: PROCEDURE CancelWorkflow
750: (
751: p_api_version IN NUMBER := 1.0,
752: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
753: p_commit IN VARCHAR2 := FND_API.g_false,
754: p_validate_only IN VARCHAR2 := FND_API.g_true,
755: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
756:

Line 753: p_commit IN VARCHAR2 := FND_API.g_false,

749: PROCEDURE CancelWorkflow
750: (
751: p_api_version IN NUMBER := 1.0,
752: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
753: p_commit IN VARCHAR2 := FND_API.g_false,
754: p_validate_only IN VARCHAR2 := FND_API.g_true,
755: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
756:
757: p_ci_id in NUMBER,

Line 754: p_validate_only IN VARCHAR2 := FND_API.g_true,

750: (
751: p_api_version IN NUMBER := 1.0,
752: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
753: p_commit IN VARCHAR2 := FND_API.g_false,
754: p_validate_only IN VARCHAR2 := FND_API.g_true,
755: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
756:
757: p_ci_id in NUMBER,
758:

Line 755: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

751: p_api_version IN NUMBER := 1.0,
752: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
753: p_commit IN VARCHAR2 := FND_API.g_false,
754: p_validate_only IN VARCHAR2 := FND_API.g_true,
755: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
756:
757: p_ci_id in NUMBER,
758:
759: x_msg_count out NOCOPY NUMBER,

Line 803: x_return_status := FND_API.G_RET_STS_SUCCESS;

799:
800: BEGIN
801:
802: -- Initialize the return status to success
803: x_return_status := FND_API.G_RET_STS_SUCCESS;
804:
805: OPEN get_project_id;
806: FETCH get_project_id INTO l_project_id;
807: CLOSE get_project_id;

Line 810: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then

806: FETCH get_project_id INTO l_project_id;
807: CLOSE get_project_id;
808:
809:
810: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
811: OPEN get_item_key;
812: FETCH get_item_key INTO l_item_key, l_wf_item_type;
813:
814: IF get_item_key%found THEN

Line 850: p_init_msg_list IN VARCHAR2 := fnd_api.g_true

846:
847: END;
848:
849: PROCEDURE ChangeCIStatus (
850: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
851: ,p_commit IN VARCHAR2 := FND_API.g_false
852: ,p_validate_only IN VARCHAR2 := FND_API.g_true
853: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
854: ,p_ci_id in number

Line 851: ,p_commit IN VARCHAR2 := FND_API.g_false

847: END;
848:
849: PROCEDURE ChangeCIStatus (
850: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
851: ,p_commit IN VARCHAR2 := FND_API.g_false
852: ,p_validate_only IN VARCHAR2 := FND_API.g_true
853: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
854: ,p_ci_id in number
855: ,p_status in varchar2

Line 852: ,p_validate_only IN VARCHAR2 := FND_API.g_true

848:
849: PROCEDURE ChangeCIStatus (
850: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
851: ,p_commit IN VARCHAR2 := FND_API.g_false
852: ,p_validate_only IN VARCHAR2 := FND_API.g_true
853: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
854: ,p_ci_id in number
855: ,p_status in varchar2
856: ,p_comment in VARCHAR2 := null

Line 853: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

849: PROCEDURE ChangeCIStatus (
850: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
851: ,p_commit IN VARCHAR2 := FND_API.g_false
852: ,p_validate_only IN VARCHAR2 := FND_API.g_true
853: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
854: ,p_ci_id in number
855: ,p_status in varchar2
856: ,p_comment in VARCHAR2 := null
857: ,p_enforce_security in Varchar2 DEFAULT 'Y'

Line 940: IF p_init_msg_list = FND_API.G_TRUE THEN

936: l_item_key pa_wf_processes.item_key%TYPE; -- Bug#14267314 end.
937:
938: BEGIN
939:
940: IF p_init_msg_list = FND_API.G_TRUE THEN
941: fnd_msg_pub.initialize;
942: END IF;
943:
944: x_msg_count := 0;

Line 955: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
957: OPEN get_ci_info;
958: FETCH get_ci_info INTO l_curr_status, l_project_id;
959: CLOSE get_ci_info;

Line 981: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

977: ,x_msg_count => x_msg_count
978: ,x_msg_data => x_msg_data);
979:
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');

Line 1037: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

1033:
1034:
1035: --debug_msg_s1 ('after change the status ' || x_return_status);
1036:
1037: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
1038:
1039: PostChangeCIStatus (
1040: p_init_msg_list
1041: ,p_commit

Line 1080: if(x_return_status <> FND_API.g_ret_sts_success) then

1076: ,x_return_status => x_return_status
1077: ,x_msg_count => x_msg_count
1078: ,x_msg_data => x_msg_data );
1079:
1080: if(x_return_status <> FND_API.g_ret_sts_success) then
1081: raise FND_API.G_EXC_ERROR;
1082: end if;
1083:
1084: end loop;

Line 1081: raise FND_API.G_EXC_ERROR;

1077: ,x_msg_count => x_msg_count
1078: ,x_msg_data => x_msg_data );
1079:
1080: if(x_return_status <> FND_API.g_ret_sts_success) then
1081: raise FND_API.G_EXC_ERROR;
1082: end if;
1083:
1084: end loop;
1085: -- Bug#14267314 end.

Line 1087: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1083:
1084: end loop;
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;

Line 1100: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

1096:
1097: x_msg_count := FND_MSG_PUB.Count_Msg;
1098:
1099: IF x_msg_count = 1 THEN
1100: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1101: ,p_msg_index => 1
1102: ,p_data => x_msg_data
1103: ,p_msg_index_out => l_msg_index_out
1104: );

Line 2009: p_init_msg_list => FND_API.G_TRUE

2005: x_return_status);
2006:
2007: /* call pa_control_items_utils.changecistatus api to revert the status;
2008: PA_CONTROL_ITEMS_UTILS.ChangeCIStatus (
2009: p_init_msg_list => FND_API.G_TRUE
2010: ,p_validate_only => FND_API.G_FALSE
2011: ,p_ci_id => p_ci_id
2012: ,p_status => l_prev_status
2013: ,p_record_version_number => p_record_version_number

Line 2010: ,p_validate_only => FND_API.G_FALSE

2006:
2007: /* call pa_control_items_utils.changecistatus api to revert the status;
2008: PA_CONTROL_ITEMS_UTILS.ChangeCIStatus (
2009: p_init_msg_list => FND_API.G_TRUE
2010: ,p_validate_only => FND_API.G_FALSE
2011: ,p_ci_id => p_ci_id
2012: ,p_status => l_prev_status
2013: ,p_record_version_number => p_record_version_number
2014: ,x_num_of_actions => l_open_actions_num

Line 2022: ,p_init_msg_list => FND_API.G_TRUE

2018: */
2019:
2020: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (
2021: p_api_version => 1.0
2022: ,p_init_msg_list => FND_API.G_TRUE
2023: ,p_validate_only => FND_API.G_FALSE
2024: ,p_ci_id => p_ci_id
2025: ,p_status_code => l_prev_status
2026: ,p_record_version_number => p_record_version_number

Line 2023: ,p_validate_only => FND_API.G_FALSE

2019:
2020: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (
2021: p_api_version => 1.0
2022: ,p_init_msg_list => FND_API.G_TRUE
2023: ,p_validate_only => FND_API.G_FALSE
2024: ,p_ci_id => p_ci_id
2025: ,p_status_code => l_prev_status
2026: ,p_record_version_number => p_record_version_number
2027: ,x_return_status => x_return_status

Line 2097: x_return_status := fnd_api.g_ret_sts_success;

2093: l_new_status_name pa_project_statuses.project_status_name%TYPE;
2094: l_old_status_name pa_project_statuses.project_status_name%TYPE;
2095:
2096: BEGIN
2097: x_return_status := fnd_api.g_ret_sts_success;
2098: x_msg_data := 0;
2099:
2100: l_new_sysstatus := getSystemStatus(p_new_project_status);
2101: l_old_sysstatus := getSystemStatus(p_old_project_status);

Line 2151: WHEN FND_API.G_EXC_ERROR THEN

2147: P_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN,
2148: P_CI_ACTION_ID => L_CI_ACTION_ID);
2149:
2150: EXCEPTION
2151: WHEN FND_API.G_EXC_ERROR THEN
2152: x_return_status := 'E';
2153: WHEN OTHERS THEN
2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2155: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',

Line 2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2150: EXCEPTION
2151: WHEN FND_API.G_EXC_ERROR THEN
2152: x_return_status := 'E';
2153: WHEN OTHERS THEN
2154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2155: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
2156: p_procedure_name => 'ADD_STATUS_CHANGE_COMMENT',
2157: p_error_text => SUBSTRB(SQLERRM,1,240));
2158: RAISE;

Line 2170: x_return_status := FND_API.G_RET_STS_SUCCESS;

2166: ,x_msg_count OUT NOCOPY NUMBER
2167: ,x_msg_data OUT NOCOPY VARCHAR2 )
2168: IS
2169: BEGIN
2170: x_return_status := FND_API.G_RET_STS_SUCCESS;
2171:
2172: DELETE FROM pa_obj_status_changes
2173: WHERE object_type = p_object_type
2174: AND object_id = p_object_id;

Line 2178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2174: AND object_id = p_object_id;
2175:
2176: EXCEPTION
2177: WHEN OTHERS THEN
2178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2179: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
2180: p_procedure_name => 'DELETE_OBJ_STATUS_CHANGES',
2181: p_error_text => SUBSTRB(SQLERRM,1,240));
2182: RAISE;

Line 2186: p_init_msg_list IN VARCHAR2 := fnd_api.g_true

2182: RAISE;
2183: END DELETE_OBJ_STATUS_CHANGES;
2184:
2185: PROCEDURE ChangeCIStatusValidate (
2186: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2187: ,p_commit IN VARCHAR2 := FND_API.g_false
2188: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2189: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2190: ,p_ci_id IN NUMBER

Line 2187: ,p_commit IN VARCHAR2 := FND_API.g_false

2183: END DELETE_OBJ_STATUS_CHANGES;
2184:
2185: PROCEDURE ChangeCIStatusValidate (
2186: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2187: ,p_commit IN VARCHAR2 := FND_API.g_false
2188: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2189: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2190: ,p_ci_id IN NUMBER
2191: ,p_status IN VARCHAR2

Line 2188: ,p_validate_only IN VARCHAR2 := FND_API.g_true

2184:
2185: PROCEDURE ChangeCIStatusValidate (
2186: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2187: ,p_commit IN VARCHAR2 := FND_API.g_false
2188: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2189: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2190: ,p_ci_id IN NUMBER
2191: ,p_status IN VARCHAR2
2192: ,p_enforce_security IN VARCHAR2 DEFAULT 'Y'

Line 2189: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

2185: PROCEDURE ChangeCIStatusValidate (
2186: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2187: ,p_commit IN VARCHAR2 := FND_API.g_false
2188: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2189: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2190: ,p_ci_id IN NUMBER
2191: ,p_status IN VARCHAR2
2192: ,p_enforce_security IN VARCHAR2 DEFAULT 'Y'
2193: ,p_resolution_check IN VARCHAR2 DEFAULT 'UI'

Line 2272: IF p_init_msg_list = FND_API.G_TRUE THEN

2268:
2269:
2270: BEGIN
2271:
2272: IF p_init_msg_list = FND_API.G_TRUE THEN
2273: fnd_msg_pub.initialize;
2274: END IF;
2275:
2276: x_msg_count := 0;

Line 2288: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
2290: OPEN get_ci_info;
2291: FETCH get_ci_info INTO l_status, l_project_id;
2292: CLOSE get_ci_info;

Line 2311: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

2307: l_new_status := p_status;
2308: x_new_status := l_new_status;
2309:
2310:
2311: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2312: -- Check Security Access for Update
2313: -- bug fix
2314: -- do not call secruity check for CR when from APPROVED to CLOSED
2315: -- or from CLOSED to APPROVED (added by MSU)

Line 2350: x_return_status := FND_API.G_RET_STS_ERROR;

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.
2353: END IF;
2354: END IF;

Line 2357: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

2353: END IF;
2354: END IF;
2355:
2356:
2357: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2358:
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;

Line 2415: x_return_status := FND_API.G_RET_STS_ERROR;

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
2418: IF p_resolution_check = 'UI' THEN
2419: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2437: x_return_status := FND_API.G_RET_STS_ERROR;

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;
2440: ELSIF p_resolution_check = 'AMG' THEN
2441: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2459: x_return_status := FND_API.G_RET_STS_ERROR;

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'

Line 2468: x_return_status := FND_API.G_RET_STS_ERROR;

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:
2471: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2472: -- check if submit is OK for finacial impact

Line 2471: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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:
2471: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2472: -- check if submit is OK for finacial impact
2473:
2474: OPEN check_if_fin_impact_exists;
2475: FETCH check_if_fin_impact_exists INTO l_tp;

Line 2529: x_return_status := FND_API.G_RET_STS_ERROR;

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;
2531: END IF;
2532:
2533: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

Line 2533: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

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

Line 2578: x_return_status := FND_API.G_RET_STS_ERROR;

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;
2580: END IF;
2581:
2582: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

Line 2582: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

2578: x_return_status := FND_API.G_RET_STS_ERROR;
2579: END IF;
2580: END IF;
2581:
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'

Line 2592: x_return_status := FND_API.G_RET_STS_ERROR;

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;
2594:
2595: IF p_resolution_check = 'UI' THEN
2596: IF checkresolutionrequired(p_ci_id) = 'Y' THEN

Line 2605: x_return_status := FND_API.G_RET_STS_ERROR;

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;
2608: ELSIF p_resolution_check = 'AMG' THEN
2609: IF checkresolutionrequired(p_ci_id) = 'Y' THEN

Line 2637: x_return_status := FND_API.G_RET_STS_ERROR;

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;
2638: END IF;
2639:
2640: ELSIF l_next_sys_status = 'CI_CLOSED' THEN
2641:

Line 2654: x_return_status := FND_API.G_RET_STS_ERROR;

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;
2657:
2658: ELSIF l_next_sys_status = 'CI_CANCELED' THEN

Line 2670: x_return_status := FND_API.G_RET_STS_ERROR;

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;
2673:
2674: END IF; /* IF l_curr_sys_status = 'CI_APPROVED' THEN */

Line 2699: p_init_msg_list IN VARCHAR2 := fnd_api.g_true

2695: END ChangeCIStatusValidate;
2696:
2697:
2698: PROCEDURE PostChangeCIStatus (
2699: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2700: ,p_commit IN VARCHAR2 := FND_API.g_false
2701: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2702: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2703: ,p_ci_id in number

Line 2700: ,p_commit IN VARCHAR2 := FND_API.g_false

2696:
2697:
2698: PROCEDURE PostChangeCIStatus (
2699: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2700: ,p_commit IN VARCHAR2 := FND_API.g_false
2701: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2702: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2703: ,p_ci_id in number
2704: ,p_curr_status in varchar2

Line 2701: ,p_validate_only IN VARCHAR2 := FND_API.g_true

2697:
2698: PROCEDURE PostChangeCIStatus (
2699: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2700: ,p_commit IN VARCHAR2 := FND_API.g_false
2701: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2702: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2703: ,p_ci_id in number
2704: ,p_curr_status in varchar2
2705: ,p_new_status in varchar2

Line 2702: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

2698: PROCEDURE PostChangeCIStatus (
2699: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2700: ,p_commit IN VARCHAR2 := FND_API.g_false
2701: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2702: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2703: ,p_ci_id in number
2704: ,p_curr_status in varchar2
2705: ,p_new_status in varchar2
2706: ,p_start_wf in VARCHAR2

Line 2727: IF p_init_msg_list = FND_API.G_TRUE THEN

2723: l_curr_sys_status := getSystemStatus(p_curr_status);
2724: l_next_sys_status := getSystemStatus(p_new_status);
2725:
2726:
2727: IF p_init_msg_list = FND_API.G_TRUE THEN
2728: fnd_msg_pub.initialize;
2729: END IF;
2730:
2731: x_msg_count := 0;

Line 2742: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
2744: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2745:
2746: IF l_curr_sys_status = 'CI_APPROVED' or l_curr_sys_status = 'CI_SUBMITTED' or l_curr_sys_status = 'CI_WORKING' THEN

Line 2744: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

2740:
2741: -- Initialize the return status to success
2742: x_return_status := FND_API.G_RET_STS_SUCCESS;
2743:
2744: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2745:
2746: IF l_curr_sys_status = 'CI_APPROVED' or l_curr_sys_status = 'CI_SUBMITTED' or l_curr_sys_status = 'CI_WORKING' THEN
2747:
2748: IF l_next_sys_status = 'CI_CANCELED' THEN

Line 2785: IF (l_curr_sys_status = 'CI_WORKING' and p_validate_only <> fnd_api.g_true AND x_return_status = 'S') 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
2786:
2787: pa_ci_actions_pvt.cancel_all_actions
2788: (
2789: p_init_msg_list=> p_init_msg_list,

Line 2807: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN

2803:
2804: END IF;
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;

Line 2865: p_init_msg_list IN VARCHAR2 := fnd_api.g_true

2861: END PostChangeCIStatus;
2862:
2863: -- Added as part of Bug#13683760 .
2864: PROCEDURE ChangeCIStatusWorking (
2865: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2866: ,p_commit IN VARCHAR2 := FND_API.g_false
2867: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2868: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2869: ,p_ci_id in number

Line 2866: ,p_commit IN VARCHAR2 := FND_API.g_false

2862:
2863: -- Added as part of Bug#13683760 .
2864: PROCEDURE ChangeCIStatusWorking (
2865: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2866: ,p_commit IN VARCHAR2 := FND_API.g_false
2867: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2868: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2869: ,p_ci_id in number
2870: ,p_status in varchar2

Line 2867: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num

2863: -- Added as part of Bug#13683760 .
2864: PROCEDURE ChangeCIStatusWorking (
2865: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2866: ,p_commit IN VARCHAR2 := FND_API.g_false
2867: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2868: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2869: ,p_ci_id in number
2870: ,p_status in varchar2
2871: ,p_record_version_number IN NUMBER

Line 2868: ,p_validate_only IN VARCHAR2 := FND_API.g_true

2864: PROCEDURE ChangeCIStatusWorking (
2865: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2866: ,p_commit IN VARCHAR2 := FND_API.g_false
2867: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2868: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2869: ,p_ci_id in number
2870: ,p_status in varchar2
2871: ,p_record_version_number IN NUMBER
2872: ,x_return_status OUT NOCOPY VARCHAR2

Line 2880: IF p_init_msg_list = FND_API.G_TRUE THEN

2876: l_new_status VARCHAR2(30);
2877: l_msg_index_out NUMBER;
2878:
2879: BEGIN
2880: IF p_init_msg_list = FND_API.G_TRUE THEN
2881: fnd_msg_pub.initialize;
2882: END IF;
2883:
2884: x_msg_count := 0;

Line 2895: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
2897:
2898: -- debug_msg_s1 ('6 ' || x_return_status);
2899: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2921: IF (p_commit = FND_API.G_TRUE AND x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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:
2923: IF P_PA_DEBUG_MODE = 'Y' THEN
2924: pa_debug.write_file('ChangeCIStatusWorking: before COMMIT');
2925: END IF;

Line 2934: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

2930:
2931: x_msg_count := FND_MSG_PUB.Count_Msg;
2932:
2933: IF x_msg_count = 1 THEN
2934: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
2935: ,p_msg_index => 1
2936: ,p_data => x_msg_data
2937: ,p_msg_index_out => l_msg_index_out
2938: );