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_API_PUB dependencies on PA_CONTROL_ITEMS_UTILS

Line 1509: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');

1505: raise FND_API.G_EXC_ERROR ;
1506: end if;
1507: close c_get_status;
1508:
1509: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');
1510: IF (l_chk_status_ctrl = 'N') THEN
1511: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_ALLOW_UPDATE');
1512: RAISE FND_API.G_EXC_ERROR;
1513: END IF;

Line 1517: pa_debug.write(l_module_name, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);

1513: END IF;
1514:
1515:
1516: IF l_debug_mode = 'Y' THEN
1517: pa_debug.write(l_module_name, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);
1518: END IF;
1519:
1520:
1521: if X_RETURN_STATUS = FND_API.g_Ret_Sts_Success then

Line 1885: check_s := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_curr_status_code , 'CONTROL_ITEM_ALLOW_UPDATE');

1881:
1882:
1883: /* Check for the status control: check whether the action CONTROL_ITEM_ALLOW_UPDST is allowed on the current status of the issue. */
1884:
1885: check_s := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_curr_status_code , 'CONTROL_ITEM_ALLOW_UPDATE');
1886:
1887: if check_s <> 'Y' then
1888: PA_UTILS.add_Message( p_app_short_name => 'PA'
1889: ,p_msg_name => 'PA_CI_NO_ALLOW_UPDATE');

Line 1907: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);

1903: /*Validating the p_ci_status_code -
1904: This is taken from Update_issue procedure. So If any changes happen in update_issue then this code needs to
1905: be looked in to*/
1906:
1907: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);
1908:
1909: IF p_ci_status_code = G_PA_MISS_CHAR THEN
1910: l_ci_status_code := l_curr_status_code;
1911: ELSIF p_ci_status_code IS NOT NULL THEN

Line 1948: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

1944: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
1945: ' AND ps.project_status_code not in (select wf_failure_status_code from pa_project_statuses where status_type = '||
1946: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
1947: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
1948: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
1949: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
1950: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
1951: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
1952: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 1951: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

1947: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
1948: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
1949: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
1950: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
1951: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
1952: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
1953: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
1954: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
1955: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||

Line 1953: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

1949: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
1950: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
1951: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
1952: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
1953: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
1954: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
1955: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||
1956: ' ,decode('||''''||l_curr_system_status||''''||', '||'''CI_DRAFT'''||', '||
1957: '''Y'''||' ,'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 2024: l_last_modified_by_id := PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id );

2020: /*end of status_code validation*/
2021:
2022:
2023: --get hz_parties.party_id of the logged in user
2024: l_last_modified_by_id := PA_CONTROL_ITEMS_UTILS.GetPartyId(fnd_global.user_id );
2025:
2026: if p_as_of_date <> G_PA_MISS_DATE and p_as_of_date is not null then
2027: l_as_of_date := p_as_of_date;
2028: else

Line 2098: pa_debug.write(l_module_name, 'Before call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate', l_debug_level3);

2094: l_curr_status_code <> l_ci_status_code AND
2095: l_to_status_flag = 'Y' and x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2096:
2097: IF l_debug_mode = 'Y' THEN
2098: pa_debug.write(l_module_name, 'Before call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate', l_debug_level3);
2099: END IF;
2100:
2101: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (
2102: p_init_msg_list => p_init_msg_list

Line 2101: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (

2097: IF l_debug_mode = 'Y' THEN
2098: pa_debug.write(l_module_name, 'Before call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate', l_debug_level3);
2099: END IF;
2100:
2101: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (
2102: p_init_msg_list => p_init_msg_list
2103: ,p_commit => p_commit
2104: ,p_validate_only => l_validate_only
2105: ,p_max_msg_count => l_max_msg_count

Line 2124: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: x_return_status = '||x_return_status, l_debug_level3);

2120: In case of CR/CO, if Auto Approve on Submission is enabled and while changing the status to submitted,
2121: then the new status would be the success status code defined for the workflow */
2122:
2123: IF l_debug_mode = 'Y' THEN
2124: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: x_return_status = '||x_return_status, l_debug_level3);
2125: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_ci_status_code = '||l_ci_status_code, l_debug_level3);
2126: END IF;
2127:
2128: IF x_return_status = 'S' THEN

Line 2125: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_ci_status_code = '||l_ci_status_code, l_debug_level3);

2121: then the new status would be the success status code defined for the workflow */
2122:
2123: IF l_debug_mode = 'Y' THEN
2124: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: x_return_status = '||x_return_status, l_debug_level3);
2125: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_ci_status_code = '||l_ci_status_code, l_debug_level3);
2126: END IF;
2127:
2128: IF x_return_status = 'S' THEN
2129: l_status_change_flag := 'Y';

Line 2133: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_status_change_flag = '||l_status_change_flag, l_debug_level3);

2129: l_status_change_flag := 'Y';
2130: END IF;
2131:
2132: IF l_debug_mode = 'Y' THEN
2133: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_status_change_flag = '||l_status_change_flag, l_debug_level3);
2134: END IF;
2135:
2136:
2137:

Line 2139: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

2135:
2136:
2137:
2138: IF (l_resolution_req IS NOT NULL AND l_resolution_req = 'Y') THEN
2139: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
2140: IF (l_resolution_code_id IS NULL) THEN
2141: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2142: ,p_msg_name => 'PA_CI_RESOLUTION_OPEN');
2143: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2155: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

2151: END IF;
2152: END IF;
2153:
2154: IF (l_resolution_req_cls IS NOT NULL AND l_resolution_req_cls = 'Y') THEN
2155: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
2156: IF (l_resolution_code_id IS NULL) THEN
2157: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2158: ,p_msg_name => 'PA_CI_CLOSE_INV_RES');
2159: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2242: pa_debug.write(l_module_name, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

2238:
2239: IF (l_status_change_flag = 'Y' AND l_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
2240:
2241: IF l_debug_mode = 'Y' THEN
2242: pa_debug.write(l_module_name, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
2243: END IF;
2244:
2245: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
2246:

Line 2247: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'

2243: END IF;
2244:
2245: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
2246:
2247: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
2248: ,p_object_id => p_ci_id
2249: ,p_type_code => 'CHANGE_STATUS'
2250: ,p_status_type => 'CONTROL_ITEM'
2251: ,p_new_project_status => l_ci_status_code

Line 2259: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

2255: ,x_msg_count => x_msg_count
2256: ,x_msg_data => x_msg_data );
2257:
2258: IF l_debug_mode = 'Y' THEN
2259: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
2260: END IF;
2261:
2262: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
2263: p_init_msg_list

Line 2262: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (

2258: IF l_debug_mode = 'Y' THEN
2259: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
2260: END IF;
2261:
2262: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
2263: p_init_msg_list
2264: ,p_commit
2265: ,l_validate_only
2266: ,l_max_msg_count

Line 2279: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);

2275: ,x_msg_data );
2276:
2277:
2278: IF l_debug_mode = 'Y' THEN
2279: pa_debug.write(l_module_name, 'after call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);
2280: END IF;
2281:
2282: END IF;
2283:

Line 4523: l_party_id := pa_control_items_utils.getpartyid(l_user_id);

4519: end if;
4520:
4521: --Get the party_id for the logged in user
4522: l_user_id := fnd_global.user_id;
4523: l_party_id := pa_control_items_utils.getpartyid(l_user_id);
4524:
4525: /*Check whether the user has privilige to update this action or not and whether the passed action is valid or not*/
4526: /*for checking the privilege check the party id of the logged in user with party id of person to whom the action is assigned*/
4527: PA_CONTROL_API_PVT.validate_priv_and_action(

Line 6049: l_UpdateAllowed := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_StatusCode, 'CONTROL_ITEM_ALLOW_UPDATE', p_Ci_Id);

6045: -- 1. The User has Update access on the Control Item.
6046: -- 2. Update is allowed on the Control Item in this particular
6047: -- status.
6048: l_UpdateAccess := PA_CI_SECURITY_PKG.Check_Update_Access (p_Ci_Id);
6049: l_UpdateAllowed := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_StatusCode, 'CONTROL_ITEM_ALLOW_UPDATE', p_Ci_Id);
6050: IF (l_UpdateAllowed = 'Y' AND l_UpdateAccess = 'T') THEN
6051: -- For each Related Item in the passed in array, insert it.
6052: FOR i IN 1..p_Related_Items_Tbl.COUNT LOOP
6053: -- If the Related Ci_Id that is passed in does not

Line 6376: l_UpdateAllowed := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_StatusCode, 'CONTROL_ITEM_ALLOW_UPDATE', p_Ci_Id);

6372: -- Deleting of Related Items is only allowed on a Control Item if
6373: -- 1. The User has Update access on the Control Item.
6374: -- 2. Update is allowed on the Control Item in this particular
6375: -- status.
6376: l_UpdateAllowed := PA_CONTROL_ITEMS_UTILS.CheckCIActionAllowed ('CONTROL_ITEM', l_StatusCode, 'CONTROL_ITEM_ALLOW_UPDATE', p_Ci_Id);
6377: l_UpdateAccess := PA_CI_SECURITY_PKG.Check_Update_Access (p_Ci_Id);
6378: IF (l_UpdateAllowed = 'Y' AND l_UpdateAccess = 'T') THEN
6379: if l_debug_mode = 'Y' then
6380: pa_debug.g_err_stage:= 'Before Calling PA_CONTROL_ITEMS_PVT.Delete_Related_Item';

Line 6869: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);

6865: end if;
6866:
6867:
6868:
6869: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);
6870:
6871: /* Check if the user can update the item. This requires the user to be owner or to have project authority or
6872: to have open UPDATE actions and status controls are satisfied. */
6873:

Line 6889: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_curr_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');

6885: END IF;
6886:
6887: /* Check for the status control: check whether the action CONTROL_ITEM_ALLOW_UPDATE is allowed on the current status of the issue. */
6888:
6889: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_curr_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');
6890:
6891: IF (l_chk_status_ctrl = 'N') THEN
6892:
6893: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_ALLOW_UPDATE');

Line 6900: pa_debug.write(l_module, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);

6896: END IF;
6897:
6898:
6899: IF l_debug_mode = 'Y' THEN
6900: pa_debug.write(l_module, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);
6901: END IF;
6902:
6903: /* The control item will not be updateable if the current status has approval workflow attached. */
6904:

Line 6955: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

6951: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
6952: ' AND ps.project_status_code not in (select wf_failure_status_code from pa_project_statuses where status_type = '||
6953: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
6954: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
6955: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
6956: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
6957: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
6958: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
6959: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 6958: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

6954: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
6955: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
6956: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
6957: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
6958: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
6959: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
6960: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
6961: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
6962: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||

Line 6960: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

6956: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
6957: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
6958: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
6959: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
6960: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
6961: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
6962: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||
6963: ' ,decode('||''''||l_curr_system_status||''''||', '||'''CI_DRAFT'''||', '||
6964: '''Y'''||' ,'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 7316: l_new_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_ci_status_code);

7312:
7313: IF (p_ci_number = G_PA_MISS_CHAR OR p_ci_number IS NULL) THEN
7314:
7315: IF l_ci_status_code IS NOT NULL THEN
7316: l_new_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_ci_status_code);
7317: END IF;
7318:
7319: IF p_ci_number = G_PA_MISS_CHAR THEN
7320: IF l_ci_number IS NULL THEN

Line 7510: pa_debug.write(l_module, 'Before call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate', l_debug_level3);

7506: l_curr_status_code <> l_ci_status_code AND
7507: l_to_status_flag = 'Y') THEN
7508:
7509: IF l_debug_mode = 'Y' THEN
7510: pa_debug.write(l_module, 'Before call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate', l_debug_level3);
7511: END IF;
7512:
7513: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (
7514: p_init_msg_list => p_init_msg_list

Line 7513: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (

7509: IF l_debug_mode = 'Y' THEN
7510: pa_debug.write(l_module, 'Before call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate', l_debug_level3);
7511: END IF;
7512:
7513: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (
7514: p_init_msg_list => p_init_msg_list
7515: ,p_commit => p_commit
7516: ,p_validate_only => l_validate_only
7517: ,p_max_msg_count => l_max_msg_count

Line 7536: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: x_return_status = '||x_return_status, l_debug_level3);

7532: In case of CR/CO, if Auto Approve on Submission is enabled and while changing the status to submitted,
7533: then the new status would be the success status code defined for the workflow */
7534:
7535: IF l_debug_mode = 'Y' THEN
7536: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: x_return_status = '||x_return_status, l_debug_level3);
7537: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_ci_status_code = '||l_ci_status_code, l_debug_level3);
7538: END IF;
7539:
7540: IF x_return_status = 'S' THEN

Line 7537: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_ci_status_code = '||l_ci_status_code, l_debug_level3);

7533: then the new status would be the success status code defined for the workflow */
7534:
7535: IF l_debug_mode = 'Y' THEN
7536: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: x_return_status = '||x_return_status, l_debug_level3);
7537: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_ci_status_code = '||l_ci_status_code, l_debug_level3);
7538: END IF;
7539:
7540: IF x_return_status = 'S' THEN
7541: l_status_change_flag := 'Y';

Line 7545: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_status_change_flag = '||l_status_change_flag, l_debug_level3);

7541: l_status_change_flag := 'Y';
7542: END IF;
7543:
7544: IF l_debug_mode = 'Y' THEN
7545: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_status_change_flag = '||l_status_change_flag, l_debug_level3);
7546: END IF;
7547:
7548: IF (l_resolution_req IS NOT NULL AND l_resolution_req = 'Y') THEN
7549: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

Line 7549: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

7545: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate: l_status_change_flag = '||l_status_change_flag, l_debug_level3);
7546: END IF;
7547:
7548: IF (l_resolution_req IS NOT NULL AND l_resolution_req = 'Y') THEN
7549: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
7550: IF (l_resolution_code_id IS NULL) THEN
7551: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7552: ,p_msg_name => 'PA_CI_RESOLUTION_OPEN');
7553: x_return_status := FND_API.G_RET_STS_ERROR;

Line 7565: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

7561: END IF;
7562: END IF;
7563:
7564: IF (l_resolution_req_cls IS NOT NULL AND l_resolution_req_cls = 'Y') THEN
7565: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
7566: IF (l_resolution_code_id IS NULL) THEN
7567: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7568: ,p_msg_name => 'PA_CI_CLOSE_INV_RES');
7569: x_return_status := FND_API.G_RET_STS_ERROR;

Line 7660: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

7656:
7657: IF (l_status_change_flag = 'Y' AND l_validate_only <> fnd_api.g_true AND x_return_status = 'S') THEN
7658:
7659: IF l_debug_mode = 'Y' THEN
7660: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
7661: END IF;
7662:
7663: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
7664:

Line 7665: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'

7661: END IF;
7662:
7663: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
7664:
7665: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
7666: ,p_object_id => p_ci_id
7667: ,p_type_code => 'CHANGE_STATUS'
7668: ,p_status_type => 'CONTROL_ITEM'
7669: ,p_new_project_status => l_ci_status_code

Line 7677: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

7673: ,x_msg_count => x_msg_count
7674: ,x_msg_data => x_msg_data );
7675:
7676: IF l_debug_mode = 'Y' THEN
7677: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
7678: END IF;
7679:
7680: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
7681: p_init_msg_list

Line 7680: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (

7676: IF l_debug_mode = 'Y' THEN
7677: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
7678: END IF;
7679:
7680: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
7681: p_init_msg_list
7682: ,p_commit
7683: ,l_validate_only
7684: ,l_max_msg_count

Line 7697: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);

7693: ,x_msg_data );
7694:
7695:
7696: IF l_debug_mode = 'Y' THEN
7697: pa_debug.write(l_module, 'after call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);
7698: END IF;
7699:
7700: END IF;
7701:

Line 8130: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);

8126: end if;
8127:
8128:
8129:
8130: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);
8131:
8132: /* Check if the user can update the item. This requires the user to be owner or to have project authority or
8133: to have open UPDATE actions and status controls are satisfied. */
8134:

Line 8150: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_curr_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');

8146: END IF;
8147:
8148: /* Check for the status control: check whether the action CONTROL_ITEM_ALLOW_UPDATE is allowed on the current status of the issue. */
8149:
8150: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_curr_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');
8151:
8152: IF (l_chk_status_ctrl = 'N') THEN
8153:
8154: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_ALLOW_UPDATE');

Line 8161: pa_debug.write(l_module, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);

8157: END IF;
8158:
8159:
8160: IF l_debug_mode = 'Y' THEN
8161: pa_debug.write(l_module, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);
8162: END IF;
8163:
8164: /* The control item will not be updateable if the current status has approval workflow attached. */
8165:

Line 8217: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

8213: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
8214: ' AND ps.project_status_code not in (select wf_failure_status_code from pa_project_statuses where status_type = '||
8215: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
8216: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
8217: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
8218: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
8219: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
8220: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
8221: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 8220: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

8216: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
8217: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
8218: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
8219: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
8220: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
8221: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
8222: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
8223: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
8224: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||

Line 8222: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

8218: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
8219: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
8220: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
8221: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
8222: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
8223: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
8224: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||
8225: ' ,decode('||''''||l_curr_system_status||''''||', '||'''CI_DRAFT'''||', '||
8226: '''Y'''||' ,'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 8573: l_new_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_ci_status_code);

8569:
8570: IF (p_ci_number = G_PA_MISS_CHAR OR p_ci_number IS NULL) THEN
8571:
8572: IF l_ci_status_code IS NOT NULL THEN
8573: l_new_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_ci_status_code);
8574: END IF;
8575:
8576: IF p_ci_number = G_PA_MISS_CHAR THEN
8577: IF l_ci_number IS NULL THEN

Line 8770: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (

8766: IF l_debug_mode = 'Y' THEN
8767: pa_debug.write(l_module, 'before call to ChangeCIStatusValidate', l_debug_level3);
8768: END IF;
8769:
8770: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (
8771: p_init_msg_list => p_init_msg_list
8772: ,p_commit => p_commit
8773: ,p_validate_only => l_validate_only
8774: ,p_max_msg_count => l_max_msg_count

Line 8806: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

8802: pa_debug.write(l_module, 'After call to ChangeCIStatusValidate :l_status_change_flag = '||l_status_change_flag, l_debug_level3);
8803: END IF;
8804:
8805: IF (l_resolution_req IS NOT NULL AND l_resolution_req = 'Y') THEN
8806: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
8807: IF (l_resolution_code_id IS NULL) THEN
8808: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8809: ,p_msg_name => 'PA_CI_RESOLUTION_OPEN');
8810: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8822: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

8818: END IF;
8819: END IF;
8820:
8821: IF (l_resolution_req_cls IS NOT NULL AND l_resolution_req_cls = 'Y') THEN
8822: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
8823: IF (l_resolution_code_id IS NULL) THEN
8824: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8825: ,p_msg_name => 'PA_CI_CLOSE_INV_RES');
8826: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8919: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

8915:
8916: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
8917:
8918: IF l_debug_mode = 'Y' THEN
8919: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
8920: END IF;
8921:
8922: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
8923: ,p_object_id => p_ci_id

Line 8922: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'

8918: IF l_debug_mode = 'Y' THEN
8919: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
8920: END IF;
8921:
8922: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
8923: ,p_object_id => p_ci_id
8924: ,p_type_code => 'CHANGE_STATUS'
8925: ,p_status_type => 'CONTROL_ITEM'
8926: ,p_new_project_status => l_ci_status_code

Line 8935: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

8931: ,x_msg_data => x_msg_data );
8932:
8933:
8934: IF l_debug_mode = 'Y' THEN
8935: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
8936: END IF;
8937:
8938: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
8939: p_init_msg_list

Line 8938: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (

8934: IF l_debug_mode = 'Y' THEN
8935: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
8936: END IF;
8937:
8938: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
8939: p_init_msg_list
8940: ,p_commit
8941: ,l_validate_only
8942: ,l_max_msg_count

Line 8955: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);

8951: ,x_msg_data );
8952:
8953:
8954: IF l_debug_mode = 'Y' THEN
8955: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);
8956: END IF;
8957:
8958: END IF;
8959:

Line 9386: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);

9382: RAISE FND_API.G_EXC_ERROR;
9383: end if;
9384:
9385:
9386: l_curr_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_curr_status_code);
9387:
9388: /* Check if the user can update the item. This requires the user to be owner or to have project authority or
9389: to have open UPDATE actions and status controls are satisfied. */
9390:

Line 9406: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_curr_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');

9402: END IF;
9403:
9404: /* Check for the status control: check whether the action CONTROL_ITEM_ALLOW_UPDATE is allowed on the current status of the issue. */
9405:
9406: l_chk_status_ctrl := pa_control_items_utils.CheckCIActionAllowed('CONTROL_ITEM', l_curr_status_code, 'CONTROL_ITEM_ALLOW_UPDATE');
9407:
9408: IF (l_chk_status_ctrl = 'N') THEN
9409:
9410: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_ALLOW_UPDATE');

Line 9417: pa_debug.write(l_module, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);

9413: END IF;
9414:
9415:
9416: IF l_debug_mode = 'Y' THEN
9417: pa_debug.write(l_module, 'After call to pa_control_items_utils.CheckCIActionAllowed', l_debug_level3);
9418: END IF;
9419:
9420: /* The control item will not be updateable if the current status has approval workflow attached. */
9421:

Line 9474: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

9470: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
9471: ' AND ps.project_status_code not in (select wf_failure_status_code from pa_project_statuses where status_type = '||
9472: '''CONTROL_ITEM'''||' and wf_success_status_code is not null and wf_failure_status_code is not null)'||
9473: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
9474: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
9475: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
9476: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
9477: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
9478: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 9477: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

9473: ' AND decode(ps.project_system_status_code, '||'''CI_CANCELED'''||
9474: ', nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
9475: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
9476: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
9477: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
9478: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
9479: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
9480: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
9481: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||

Line 9479: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||

9475: '''CONTROL_ITEM_ALLOW_CANCEL'''||', null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
9476: ' AND decode(ps.project_system_status_code,'||'''CI_WORKING'''||
9477: ' ,nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
9478: '''CONTROL_ITEM_ALLOW_REWORK'''||' ,null),'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||
9479: ' AND nvl(pa_control_items_utils.CheckCIActionAllowed('||'''CONTROL_ITEM'''||', '||''''||l_curr_status_code||''''||', '||
9480: '''CONTROL_ITEM_ALLOW_UPDST'''||' ,null),'||'''N'''||' ) = '||'''Y'''||
9481: ' AND decode(ps.project_system_status_code,'||'''CI_DRAFT'''||
9482: ' ,decode('||''''||l_curr_system_status||''''||', '||'''CI_DRAFT'''||', '||
9483: '''Y'''||' ,'||'''N'''||' ),'||'''Y'''||' ) = '||'''Y'''||

Line 9831: l_new_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_ci_status_code);

9827:
9828: IF (p_ci_number = G_PA_MISS_CHAR OR p_ci_number IS NULL) THEN
9829:
9830: IF l_ci_status_code IS NOT NULL THEN
9831: l_new_system_status := PA_CONTROL_ITEMS_UTILS.getSystemStatus(l_ci_status_code);
9832: END IF;
9833:
9834: IF p_ci_number = G_PA_MISS_CHAR THEN
9835: IF l_ci_number IS NULL THEN

Line 10028: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (

10024: IF l_debug_mode = 'Y' THEN
10025: pa_debug.write(l_module, 'before call to ChangeCIStatusValidate', l_debug_level3);
10026: END IF;
10027:
10028: PA_CONTROL_ITEMS_UTILS.ChangeCIStatusValidate (
10029: p_init_msg_list => p_init_msg_list
10030: ,p_commit => p_commit
10031: ,p_validate_only => l_validate_only
10032: ,p_max_msg_count => l_max_msg_count

Line 10064: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

10060: pa_debug.write(l_module, 'After call to ChangeCIStatusValidate : l_status_change_flag = '||l_status_change_flag, l_debug_level3);
10061: END IF;
10062:
10063: IF (l_resolution_req IS NOT NULL AND l_resolution_req = 'Y') THEN
10064: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
10065: IF (l_resolution_code_id IS NULL) THEN
10066: PA_UTILS.Add_Message( p_app_short_name => 'PA'
10067: ,p_msg_name => 'PA_CI_RESOLUTION_OPEN');
10068: x_return_status := FND_API.G_RET_STS_ERROR;

Line 10080: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN

10076: END IF;
10077: END IF;
10078:
10079: IF (l_resolution_req_cls IS NOT NULL AND l_resolution_req_cls = 'Y') THEN
10080: IF (PA_CONTROL_ITEMS_UTILS.checkhasresolution(p_ci_id) <> 'Y' ) THEN
10081: IF (l_resolution_code_id IS NULL) THEN
10082: PA_UTILS.Add_Message( p_app_short_name => 'PA'
10083: ,p_msg_name => 'PA_CI_CLOSE_INV_RES');
10084: x_return_status := FND_API.G_RET_STS_ERROR;

Line 10177: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

10173:
10174: /* call the insert table handlers of pa_obj_status_changes and pa_ci_comments here */
10175:
10176: IF l_debug_mode = 'Y' THEN
10177: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
10178: END IF;
10179:
10180: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
10181: ,p_object_id => p_ci_id

Line 10180: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'

10176: IF l_debug_mode = 'Y' THEN
10177: pa_debug.write(l_module, 'before call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
10178: END IF;
10179:
10180: PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT( p_object_type => 'PA_CI_TYPES'
10181: ,p_object_id => p_ci_id
10182: ,p_type_code => 'CHANGE_STATUS'
10183: ,p_status_type => 'CONTROL_ITEM'
10184: ,p_new_project_status => l_ci_status_code

Line 10193: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);

10189: ,x_msg_data => x_msg_data );
10190:
10191:
10192: IF l_debug_mode = 'Y' THEN
10193: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
10194: END IF;
10195:
10196: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
10197: p_init_msg_list

Line 10196: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (

10192: IF l_debug_mode = 'Y' THEN
10193: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.ADD_STATUS_CHANGE_COMMENT', l_debug_level3);
10194: END IF;
10195:
10196: PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus (
10197: p_init_msg_list
10198: ,p_commit
10199: ,l_validate_only
10200: ,l_max_msg_count

Line 10213: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);

10209: ,x_msg_data );
10210:
10211:
10212: IF l_debug_mode = 'Y' THEN
10213: pa_debug.write(l_module, 'After call to PA_CONTROL_ITEMS_UTILS.PostChangeCIStatus', l_debug_level3);
10214: END IF;
10215:
10216: END IF;
10217: