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 642: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

638:
639: PROCEDURE checkandstartworkflow
640: (
641: p_api_version IN NUMBER := 1.0,
642: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
643: p_commit IN VARCHAR2 := FND_API.g_false,
644: p_validate_only IN VARCHAR2 := FND_API.g_true,
645: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
646:

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

639: PROCEDURE checkandstartworkflow
640: (
641: p_api_version IN NUMBER := 1.0,
642: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
643: p_commit IN VARCHAR2 := FND_API.g_false,
644: p_validate_only IN VARCHAR2 := FND_API.g_true,
645: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
646:
647: p_ci_id in NUMBER,

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

640: (
641: p_api_version IN NUMBER := 1.0,
642: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
643: p_commit IN VARCHAR2 := FND_API.g_false,
644: p_validate_only IN VARCHAR2 := FND_API.g_true,
645: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
646:
647: p_ci_id in NUMBER,
648: p_status_code IN VARCHAR2,

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

641: p_api_version IN NUMBER := 1.0,
642: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
643: p_commit IN VARCHAR2 := FND_API.g_false,
644: p_validate_only IN VARCHAR2 := FND_API.g_true,
645: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
646:
647: p_ci_id in NUMBER,
648: p_status_code IN VARCHAR2,
649:

Line 670: x_return_status := FND_API.G_RET_STS_SUCCESS;

666:
667: BEGIN
668:
669: -- Initialize the return status to success
670: x_return_status := FND_API.G_RET_STS_SUCCESS;
671:
672: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
673: OPEN get_wf_info;
674: FETCH get_wf_info INTO l_wf_item_type, l_wf_process_name, l_wf_enable;

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

668:
669: -- Initialize the return status to success
670: x_return_status := FND_API.G_RET_STS_SUCCESS;
671:
672: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
673: OPEN get_wf_info;
674: FETCH get_wf_info INTO l_wf_item_type, l_wf_process_name, l_wf_enable;
675:
676: --debug_msg_s1 ('start workflow ' || p_status_code);

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

704:
705: PROCEDURE CancelWorkflow
706: (
707: p_api_version IN NUMBER := 1.0,
708: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
709: p_commit IN VARCHAR2 := FND_API.g_false,
710: p_validate_only IN VARCHAR2 := FND_API.g_true,
711: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
712:

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

705: PROCEDURE CancelWorkflow
706: (
707: p_api_version IN NUMBER := 1.0,
708: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
709: p_commit IN VARCHAR2 := FND_API.g_false,
710: p_validate_only IN VARCHAR2 := FND_API.g_true,
711: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
712:
713: p_ci_id in NUMBER,

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

706: (
707: p_api_version IN NUMBER := 1.0,
708: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
709: p_commit IN VARCHAR2 := FND_API.g_false,
710: p_validate_only IN VARCHAR2 := FND_API.g_true,
711: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
712:
713: p_ci_id in NUMBER,
714:

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

707: p_api_version IN NUMBER := 1.0,
708: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
709: p_commit IN VARCHAR2 := FND_API.g_false,
710: p_validate_only IN VARCHAR2 := FND_API.g_true,
711: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
712:
713: p_ci_id in NUMBER,
714:
715: x_msg_count out NOCOPY NUMBER,

Line 759: x_return_status := FND_API.G_RET_STS_SUCCESS;

755:
756: BEGIN
757:
758: -- Initialize the return status to success
759: x_return_status := FND_API.G_RET_STS_SUCCESS;
760:
761: OPEN get_project_id;
762: FETCH get_project_id INTO l_project_id;
763: CLOSE get_project_id;

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

762: FETCH get_project_id INTO l_project_id;
763: CLOSE get_project_id;
764:
765:
766: IF (p_validate_only <>FND_API.g_true AND x_return_status = FND_API.g_ret_sts_success) then
767: OPEN get_item_key;
768: FETCH get_item_key INTO l_item_key, l_wf_item_type;
769:
770: IF get_item_key%found THEN

Line 806: p_init_msg_list IN VARCHAR2 := fnd_api.g_true

802:
803: END;
804:
805: PROCEDURE ChangeCIStatus (
806: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
807: ,p_commit IN VARCHAR2 := FND_API.g_false
808: ,p_validate_only IN VARCHAR2 := FND_API.g_true
809: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
810: ,p_ci_id in number

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

803: END;
804:
805: PROCEDURE ChangeCIStatus (
806: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
807: ,p_commit IN VARCHAR2 := FND_API.g_false
808: ,p_validate_only IN VARCHAR2 := FND_API.g_true
809: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
810: ,p_ci_id in number
811: ,p_status in varchar2

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

804:
805: PROCEDURE ChangeCIStatus (
806: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
807: ,p_commit IN VARCHAR2 := FND_API.g_false
808: ,p_validate_only IN VARCHAR2 := FND_API.g_true
809: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
810: ,p_ci_id in number
811: ,p_status in varchar2
812: ,p_comment in VARCHAR2 := null

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

805: PROCEDURE ChangeCIStatus (
806: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
807: ,p_commit IN VARCHAR2 := FND_API.g_false
808: ,p_validate_only IN VARCHAR2 := FND_API.g_true
809: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
810: ,p_ci_id in number
811: ,p_status in varchar2
812: ,p_comment in VARCHAR2 := null
813: ,p_enforce_security in Varchar2 DEFAULT 'Y'

Line 890: IF p_init_msg_list = FND_API.G_TRUE THEN

886:
887:
888: BEGIN
889:
890: IF p_init_msg_list = FND_API.G_TRUE THEN
891: fnd_msg_pub.initialize;
892: END IF;
893:
894: x_msg_count := 0;

Line 905: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
907: OPEN get_ci_info;
908: FETCH get_ci_info INTO l_curr_status, l_project_id;
909: CLOSE get_ci_info;

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

927: ,x_msg_count => x_msg_count
928: ,x_msg_data => x_msg_data);
929:
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');

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

983:
984:
985: --debug_msg_s1 ('after change the status ' || x_return_status);
986:
987: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
988:
989: PostChangeCIStatus (
990: p_init_msg_list
991: ,p_commit

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

1005:
1006: END IF;
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;

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

1018:
1019: x_msg_count := FND_MSG_PUB.Count_Msg;
1020:
1021: IF x_msg_count = 1 THEN
1022: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE
1023: ,p_msg_index => 1
1024: ,p_data => x_msg_data
1025: ,p_msg_index_out => l_msg_index_out
1026: );

Line 1913: p_init_msg_list => FND_API.G_TRUE

1909: x_return_status);
1910:
1911: /* call pa_control_items_utils.changecistatus api to revert the status;
1912: PA_CONTROL_ITEMS_UTILS.ChangeCIStatus (
1913: p_init_msg_list => FND_API.G_TRUE
1914: ,p_validate_only => FND_API.G_FALSE
1915: ,p_ci_id => p_ci_id
1916: ,p_status => l_prev_status
1917: ,p_record_version_number => p_record_version_number

Line 1914: ,p_validate_only => FND_API.G_FALSE

1910:
1911: /* call pa_control_items_utils.changecistatus api to revert the status;
1912: PA_CONTROL_ITEMS_UTILS.ChangeCIStatus (
1913: p_init_msg_list => FND_API.G_TRUE
1914: ,p_validate_only => FND_API.G_FALSE
1915: ,p_ci_id => p_ci_id
1916: ,p_status => l_prev_status
1917: ,p_record_version_number => p_record_version_number
1918: ,x_num_of_actions => l_open_actions_num

Line 1926: ,p_init_msg_list => FND_API.G_TRUE

1922: */
1923:
1924: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (
1925: p_api_version => 1.0
1926: ,p_init_msg_list => FND_API.G_TRUE
1927: ,p_validate_only => FND_API.G_FALSE
1928: ,p_ci_id => p_ci_id
1929: ,p_status_code => l_prev_status
1930: ,p_record_version_number => p_record_version_number

Line 1927: ,p_validate_only => FND_API.G_FALSE

1923:
1924: pa_control_items_pvt.UPDATE_CONTROL_ITEM_STATUS (
1925: p_api_version => 1.0
1926: ,p_init_msg_list => FND_API.G_TRUE
1927: ,p_validate_only => FND_API.G_FALSE
1928: ,p_ci_id => p_ci_id
1929: ,p_status_code => l_prev_status
1930: ,p_record_version_number => p_record_version_number
1931: ,x_return_status => x_return_status

Line 2001: x_return_status := fnd_api.g_ret_sts_success;

1997: l_new_status_name pa_project_statuses.project_status_name%TYPE;
1998: l_old_status_name pa_project_statuses.project_status_name%TYPE;
1999:
2000: BEGIN
2001: x_return_status := fnd_api.g_ret_sts_success;
2002: x_msg_data := 0;
2003:
2004: l_new_sysstatus := getSystemStatus(p_new_project_status);
2005: l_old_sysstatus := getSystemStatus(p_old_project_status);

Line 2055: WHEN FND_API.G_EXC_ERROR THEN

2051: P_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN,
2052: P_CI_ACTION_ID => L_CI_ACTION_ID);
2053:
2054: EXCEPTION
2055: WHEN FND_API.G_EXC_ERROR THEN
2056: x_return_status := 'E';
2057: WHEN OTHERS THEN
2058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2059: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',

Line 2058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2054: EXCEPTION
2055: WHEN FND_API.G_EXC_ERROR THEN
2056: x_return_status := 'E';
2057: WHEN OTHERS THEN
2058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2059: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
2060: p_procedure_name => 'ADD_STATUS_CHANGE_COMMENT',
2061: p_error_text => SUBSTRB(SQLERRM,1,240));
2062: RAISE;

Line 2074: x_return_status := FND_API.G_RET_STS_SUCCESS;

2070: ,x_msg_count OUT NOCOPY NUMBER
2071: ,x_msg_data OUT NOCOPY VARCHAR2 )
2072: IS
2073: BEGIN
2074: x_return_status := FND_API.G_RET_STS_SUCCESS;
2075:
2076: DELETE FROM pa_obj_status_changes
2077: WHERE object_type = p_object_type
2078: AND object_id = p_object_id;

Line 2082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2078: AND object_id = p_object_id;
2079:
2080: EXCEPTION
2081: WHEN OTHERS THEN
2082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2083: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CONTROL_ITEMS_UTILS',
2084: p_procedure_name => 'DELETE_OBJ_STATUS_CHANGES',
2085: p_error_text => SUBSTRB(SQLERRM,1,240));
2086: RAISE;

Line 2090: p_init_msg_list IN VARCHAR2 := fnd_api.g_true

2086: RAISE;
2087: END DELETE_OBJ_STATUS_CHANGES;
2088:
2089: PROCEDURE ChangeCIStatusValidate (
2090: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2091: ,p_commit IN VARCHAR2 := FND_API.g_false
2092: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2093: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2094: ,p_ci_id IN NUMBER

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

2087: END DELETE_OBJ_STATUS_CHANGES;
2088:
2089: PROCEDURE ChangeCIStatusValidate (
2090: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2091: ,p_commit IN VARCHAR2 := FND_API.g_false
2092: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2093: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2094: ,p_ci_id IN NUMBER
2095: ,p_status IN VARCHAR2

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

2088:
2089: PROCEDURE ChangeCIStatusValidate (
2090: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2091: ,p_commit IN VARCHAR2 := FND_API.g_false
2092: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2093: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2094: ,p_ci_id IN NUMBER
2095: ,p_status IN VARCHAR2
2096: ,p_enforce_security IN VARCHAR2 DEFAULT 'Y'

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

2089: PROCEDURE ChangeCIStatusValidate (
2090: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2091: ,p_commit IN VARCHAR2 := FND_API.g_false
2092: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2093: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2094: ,p_ci_id IN NUMBER
2095: ,p_status IN VARCHAR2
2096: ,p_enforce_security IN VARCHAR2 DEFAULT 'Y'
2097: ,p_resolution_check IN VARCHAR2 DEFAULT 'UI'

Line 2175: IF p_init_msg_list = FND_API.G_TRUE THEN

2171:
2172:
2173: BEGIN
2174:
2175: IF p_init_msg_list = FND_API.G_TRUE THEN
2176: fnd_msg_pub.initialize;
2177: END IF;
2178:
2179: x_msg_count := 0;

Line 2191: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
2193: OPEN get_ci_info;
2194: FETCH get_ci_info INTO l_status, l_project_id;
2195: CLOSE get_ci_info;

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

2210: l_new_status := p_status;
2211: x_new_status := l_new_status;
2212:
2213:
2214: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2215: -- Check Security Access for Update
2216: -- bug fix
2217: -- do not call secruity check for CR when from APPROVED to CLOSED
2218: -- or from CLOSED to APPROVED (added by MSU)

Line 2240: x_return_status := FND_API.G_RET_STS_ERROR;

2236: pa_debug.write_file('ChangeCiStatusValidate: PA_CI_STATUS_UPDATE_INV');
2237: END IF;
2238: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2239: ,p_msg_name => 'PA_CI_STATUS_UPDATE_INV');
2240: x_return_status := FND_API.G_RET_STS_ERROR;
2241: END IF;
2242: END IF;
2243: END IF;
2244:

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

2242: END IF;
2243: END IF;
2244:
2245:
2246: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2247:
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;

Line 2304: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2326: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2348: x_return_status := FND_API.G_RET_STS_ERROR;

2344: ,p_msg_name => 'PA_CI_SUBMIT_INV');
2345: IF P_PA_DEBUG_MODE = 'Y' THEN
2346: pa_debug.write_file('ChangeCiStatus: PA_CI_SUBMIT_INV');
2347: END IF;
2348: x_return_status := FND_API.G_RET_STS_ERROR;
2349: END IF;
2350:
2351: ELSE
2352: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 2357: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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:
2360: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2361: -- check if submit is OK for finacial impact
2362:
2363: OPEN check_if_fin_impact_exists;
2364: FETCH check_if_fin_impact_exists INTO l_tp;

Line 2418: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 2467: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

2467: x_return_status := FND_API.G_RET_STS_ERROR;
2468: END IF;
2469: END IF;
2470:
2471: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2472: l_temp := pa_ci_actions_util.check_open_actions_exist (p_ci_id);
2473:
2474: IF l_temp = 'Y' THEN
2475: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 2481: x_return_status := FND_API.G_RET_STS_ERROR;

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;
2483:
2484: IF p_resolution_check = 'UI' THEN
2485: IF checkresolutionrequired(p_ci_id) = 'Y' THEN

Line 2494: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2526: x_return_status := FND_API.G_RET_STS_ERROR;

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;
2527: END IF;
2528:
2529: ELSIF l_next_sys_status = 'CI_CLOSED' THEN
2530:

Line 2543: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2559: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2588: p_init_msg_list IN VARCHAR2 := fnd_api.g_true

2584: END ChangeCIStatusValidate;
2585:
2586:
2587: PROCEDURE PostChangeCIStatus (
2588: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2589: ,p_commit IN VARCHAR2 := FND_API.g_false
2590: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2591: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2592: ,p_ci_id in number

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

2585:
2586:
2587: PROCEDURE PostChangeCIStatus (
2588: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2589: ,p_commit IN VARCHAR2 := FND_API.g_false
2590: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2591: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2592: ,p_ci_id in number
2593: ,p_curr_status in varchar2

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

2586:
2587: PROCEDURE PostChangeCIStatus (
2588: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2589: ,p_commit IN VARCHAR2 := FND_API.g_false
2590: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2591: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2592: ,p_ci_id in number
2593: ,p_curr_status in varchar2
2594: ,p_new_status in varchar2

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

2587: PROCEDURE PostChangeCIStatus (
2588: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
2589: ,p_commit IN VARCHAR2 := FND_API.g_false
2590: ,p_validate_only IN VARCHAR2 := FND_API.g_true
2591: ,p_max_msg_count IN NUMBER := FND_API.g_miss_num
2592: ,p_ci_id in number
2593: ,p_curr_status in varchar2
2594: ,p_new_status in varchar2
2595: ,p_start_wf in VARCHAR2

Line 2616: IF p_init_msg_list = FND_API.G_TRUE THEN

2612: l_curr_sys_status := getSystemStatus(p_curr_status);
2613: l_next_sys_status := getSystemStatus(p_new_status);
2614:
2615:
2616: IF p_init_msg_list = FND_API.G_TRUE THEN
2617: fnd_msg_pub.initialize;
2618: END IF;
2619:
2620: x_msg_count := 0;

Line 2631: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

2629:
2630: -- Initialize the return status to success
2631: x_return_status := FND_API.G_RET_STS_SUCCESS;
2632:
2633: IF (p_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2634:
2635: IF l_curr_sys_status = 'CI_APPROVED' or l_curr_sys_status = 'CI_SUBMITTED' or l_curr_sys_status = 'CI_WORKING' THEN
2636:
2637: IF l_next_sys_status = 'CI_CANCELED' THEN

Line 2674: IF (l_curr_sys_status = 'CI_WORKING' and p_validate_only <> fnd_api.g_true AND x_return_status = 'S') 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
2675:
2676: pa_ci_actions_pvt.cancel_all_actions
2677: (
2678: p_init_msg_list=> p_init_msg_list,

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

2692:
2693: END IF;
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;