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_UTILS

Line 111: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

107: END IF;
108:
109: /*validating the CI_ID for null value*/
110: if p_ci_id is null or p_ci_id = G_PA_MISS_NUM then
111: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
112: p_msg_name => 'PA_CI_MISS_CI_ID');
113: if l_debug_mode = 'Y' then
114: pa_debug.g_err_stage:= 'The ci_id is null';
115: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 242: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

238: END IF;
239:
240: /*validating the CI_ID for null value*/
241: if p_ci_id is null or p_ci_id = G_PA_MISS_NUM then
242: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
243: p_msg_name => 'PA_CI_MISS_CI_ID');
244: if l_debug_mode = 'Y' then
245: pa_debug.g_err_stage:= 'The ci_id is null';
246: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 370: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

366: END IF;
367:
368: /*validating the CI_ID for null value*/
369: if p_ci_id is null or p_ci_id = G_PA_MISS_NUM then
370: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
371: p_msg_name => 'PA_CI_MISS_CI_ID');
372: if l_debug_mode = 'Y' then
373: pa_debug.g_err_stage:= 'The ci_id is null';
374: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 495: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

491: END IF;
492:
493: /*validating the CI_ID for null value*/
494: if p_ci_id is null or p_ci_id = G_PA_MISS_NUM then
495: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
496: p_msg_name => 'PA_CI_MISS_CI_ID');
497: if l_debug_mode = 'Y' then
498: pa_debug.g_err_stage:= 'The ci_id is null';
499: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 636: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

632: END IF;
633:
634: /*validating the CI_ID for null value*/
635: if p_ci_id is null or p_ci_id = G_PA_MISS_NUM then
636: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
637: p_msg_name => 'PA_CI_MISS_CI_ID');
638: if l_debug_mode = 'Y' then
639: pa_debug.g_err_stage:= 'The ci_id is null';
640: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 787: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

783: END IF;
784:
785: /*validating the CI_ID for null value*/
786: if p_ci_id is null or p_ci_id = G_PA_MISS_NUM then
787: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
788: p_msg_name => 'PA_CI_MISS_CI_ID');
789: if l_debug_mode = 'Y' then
790: pa_debug.g_err_stage:= 'The ci_id is null';
791: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 919: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

915: END IF;
916:
917: /*validating the CI_ID for null value*/
918: if p_ci_id is null or p_ci_id = G_PA_MISS_NUM then
919: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
920: p_msg_name => 'PA_CI_MISS_CI_ID');
921: if l_debug_mode = 'Y' then
922: pa_debug.g_err_stage:= 'The ci_id is null';
923: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 1053: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1049: END IF;
1050:
1051: /*validating the CI_ID for null value*/
1052: if p_ci_id is null or p_ci_id = G_PA_MISS_NUM then
1053: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1054: p_msg_name => 'PA_CI_MISS_CI_ID');
1055: if l_debug_mode = 'Y' then
1056: pa_debug.g_err_stage:= 'The ci_id is null';
1057: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 1185: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1181: END IF;
1182:
1183: /*validating the CI_ID for null value*/
1184: if p_ci_id is null or p_ci_id = G_PA_MISS_NUM then
1185: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1186: p_msg_name => 'PA_CI_MISS_CI_ID');
1187: if l_debug_mode = 'Y' then
1188: pa_debug.g_err_stage:= 'The ci_id is null';
1189: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 1316: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

1312: END IF;
1313:
1314: /*validating the CI_ID for null value*/
1315: if p_ci_id is null or p_ci_id = G_PA_MISS_NUM then
1316: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1317: p_msg_name => 'PA_CI_MISS_CI_ID');
1318: if l_debug_mode = 'Y' then
1319: pa_debug.g_err_stage:= 'The ci_id is null';
1320: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 1459: PA_UTILS.Add_Message (p_App_Short_Name => 'PA'

1455: -- Check for the null p_ci_transaction_id value.
1456: -- report Error.
1457: IF P_CI_TRANSACTION_ID IS NULL THEN
1458: -- Add message to the Error Stack that Ci_Id is NULL.
1459: PA_UTILS.Add_Message (p_App_Short_Name => 'PA'
1460: , p_Msg_Name => 'PA_CI_MISS_TRANS_ID'
1461: );
1462: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1463: -- Raise the Invalid Argument exception.

Line 1470: PA_UTILS.Add_Message (p_App_Short_Name => 'PA'

1466: open Check_Valid_CI_TRANS_ID;
1467: fetch Check_Valid_CI_TRANS_ID into l_transaction_id,l_ci_id;
1468: if Check_Valid_CI_TRANS_ID%notfound then
1469: -- Add message to the Error Stack that Ci_Id is NULL.
1470: PA_UTILS.Add_Message (p_App_Short_Name => 'PA'
1471: , p_Msg_Name => 'PA_CI_INV_TRANS_ID'
1472: );
1473: close Check_Valid_CI_TRANS_ID;
1474: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 1483: PA_UTILS.add_Message( p_app_short_name => 'PA'

1479: END IF;
1480:
1481: /*Security check for the CI_ID UpdateAccess*/
1482: if 'T' <> Pa_ci_security_pkg.check_update_access (l_ci_id) then
1483: PA_UTILS.add_Message( p_app_short_name => 'PA'
1484: ,p_msg_name => 'PA_CI_NO_UPDATE_ACCESS');
1485: x_return_status := FND_API.G_RET_STS_ERROR;
1486: if l_debug_mode = 'Y' then
1487: pa_debug.g_err_stage:= 'the CI_ID does not have the update access';

Line 1497: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1493: /* Check for the status control: check whether the action CONTROL_ITEM_ALLOW_UPDATE is allowed on the current status of the issue. */
1494: open c_get_status(l_ci_id);
1495: fetch c_get_status into l_status_code;
1496: if c_get_status%notfound then
1497: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1498: ,p_msg_name =>'PA_CI_INV_CI_ID');
1499: if l_debug_mode = 'Y' then
1500: pa_debug.g_err_stage:= 'the ci_id is invalid';
1501: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 1511: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_ALLOW_UPDATE');

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;
1514:
1515:

Line 1763: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1759:
1760: x_msg_count := 0;
1761:
1762: if p_ci_id is null or p_ci_id = G_PA_MISS_NUM then
1763: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1764: ,p_msg_name => 'PA_CI_MISS_CI_ID');
1765: if l_debug_mode = 'Y' then
1766: pa_debug.g_err_stage:= 'the ci_id is null';
1767: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 1777: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1773: open c_get_control_item_data;
1774: fetch c_get_control_item_data into cp;
1775: if c_get_control_item_data%NOTFOUND then
1776:
1777: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1778: ,p_msg_name => 'PA_CI_INV_CI_ID');
1779: if l_debug_mode = 'Y' then
1780: pa_debug.g_err_stage:= 'the ci_id is invalid';
1781: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 1855: PA_UTILS.add_Message( p_app_short_name => 'PA'

1851: /*Security check for the CI_ID UpdateAccess*/
1852: check_s := pa_ci_security_pkg.check_update_access(p_ci_id);
1853:
1854: if 'T' <> check_s then
1855: PA_UTILS.add_Message( p_app_short_name => 'PA'
1856: ,p_msg_name => 'PA_CI_NO_UPDATE_ACCESS');
1857: x_return_status := FND_API.G_RET_STS_ERROR;
1858: if l_debug_mode = 'Y' then
1859: pa_debug.g_err_stage:= 'the CI_ID does not have the update access';

Line 1888: PA_UTILS.add_Message( p_app_short_name => 'PA'

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');
1890: x_return_status := FND_API.G_RET_STS_ERROR;
1891: if l_debug_mode = 'Y' then
1892: pa_debug.g_err_stage:= 'the CI_ID does not have the update access for the current status';

Line 1992: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1988:
1989: l_rows := DBMS_SQL.EXECUTE(l_cursor);
1990:
1991: IF (l_rows < 0) THEN
1992: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1993: ,p_msg_name => 'PA_TO_STATUS_INVALID');
1994: x_return_status := FND_API.G_RET_STS_ERROR;
1995: l_to_status_flag := 'N';
1996: ELSE

Line 2003: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1999: if l_rows1 > 0 THEN
2000: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);
2001: l_ci_status_code := l_ci_status_code_1;
2002: else
2003: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2004: ,p_msg_name => 'PA_TO_STATUS_INVALID');
2005: x_return_status := FND_API.G_RET_STS_ERROR;
2006: l_to_status_flag := 'N';
2007: end if;

Line 2015: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NULL_STATUS');

2011: dbms_sql.close_cursor(l_cursor);
2012: END IF;
2013: ELSIF p_ci_status_code IS NULL THEN
2014: l_ci_status_code := p_ci_status_code;
2015: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NULL_STATUS');
2016: x_return_status := FND_API.G_RET_STS_ERROR;
2017: l_to_status_flag := 'N';
2018: END IF;
2019:

Line 2036: PA_UTILS.add_Message( p_app_short_name => 'PA'

2032: if p_progress_status_code <> G_PA_MISS_CHAR and p_progress_status_code is not null then
2033: open c_check_Progress_code;
2034: fetch c_check_Progress_code into c_check_Progress_code_rec;
2035: if c_check_Progress_code%notfound then
2036: PA_UTILS.add_Message( p_app_short_name => 'PA'
2037: ,p_msg_name => 'PA_CI_INV_PRG_CODE');
2038: x_return_status := FND_API.G_RET_STS_ERROR;
2039: if l_debug_mode = 'Y' then
2040: pa_debug.g_err_stage:= 'Invalid progress Code is passed';

Line 2049: PA_UTILS.add_Message( p_app_short_name => 'PA'

2045: l_progress_status_code := p_progress_status_code;
2046: close c_check_Progress_code;
2047: end if;
2048: elsif p_progress_status_code is null then
2049: PA_UTILS.add_Message( p_app_short_name => 'PA'
2050: ,p_msg_name => 'PA_PROGRESS_STATUS_NULL');
2051: if l_debug_mode = 'Y' then
2052: pa_debug.g_err_stage:= 'Progress Code is null';
2053: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 2062: PA_UTILS.add_Message( p_app_short_name => 'PA'

2058: if p_resolution_code <> G_PA_MISS_CHAR and p_resolution_code is not null then
2059: open c_get_resolution_codes(l_ci_type_id);
2060: fetch c_get_resolution_codes into c_get_resolution_codes_rec;
2061: if c_get_resolution_codes%notfound then
2062: PA_UTILS.add_Message( p_app_short_name => 'PA'
2063: ,p_msg_name => 'PA_CI_RESOLUTION_INV');
2064: x_return_status := FND_API.G_RET_STS_ERROR;
2065: if l_debug_mode = 'Y' then
2066: pa_debug.g_err_stage:= 'the Resolution Code is invalid';

Line 2141: PA_UTILS.Add_Message( p_app_short_name => 'PA'

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;
2144: END IF;
2145: ELSE

Line 2147: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2143: x_return_status := FND_API.G_RET_STS_ERROR;
2144: END IF;
2145: ELSE
2146: IF (l_resolution_code_id IS NULL) THEN
2147: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2148: ,p_msg_name => 'PA_CI_RESOLUTION_OPEN');
2149: x_return_status := FND_API.G_RET_STS_ERROR;
2150: END IF;
2151: END IF;

Line 2157: PA_UTILS.Add_Message( p_app_short_name => 'PA'

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;
2160: END IF;
2161: ELSE

Line 2163: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2159: x_return_status := FND_API.G_RET_STS_ERROR;
2160: END IF;
2161: ELSE
2162: IF (l_resolution_code_id IS NULL) THEN
2163: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2164: ,p_msg_name => 'PA_CI_CLOSE_INV_RES');
2165: x_return_status := FND_API.G_RET_STS_ERROR;
2166: END IF;
2167: END IF;

Line 4542: pa_utils.add_message(p_app_short_name => 'PA',

4538: /* at this point in code action_id and assignee id would have been dervied if code reaches here*/
4539: /* compare the assignee_id for this action with the party id of the logged inuser to determine the priv
4540: to take action*/
4541: if l_party_id is null then
4542: pa_utils.add_message(p_app_short_name => 'PA',
4543: p_msg_name => 'PA_CI_ACTION_NO_ACCESS');
4544: if (l_debug_mode = 'Y') then
4545: pa_debug.g_err_stage := 'Apps Initialization is not been done';
4546: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 4551: pa_utils.add_message(p_app_short_name => 'PA',

4547: end if;
4548: raise fnd_api.g_exc_error;
4549: elsif( l_assignee_id is not null and (l_assignee_id <> l_party_id) ) then
4550: /*user doesnt have privilige to update the action*/
4551: pa_utils.add_message(p_app_short_name => 'PA',
4552: p_msg_name => 'PA_CI_ACTION_NO_ACCESS');
4553: if (l_debug_mode = 'Y') then
4554: pa_debug.g_err_stage := 'user doesnt have access to update the action';
4555: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 4561: pa_utils.add_message(p_app_short_name => 'PA',

4557: raise fnd_api.g_exc_error;
4558: end if;
4559:
4560: if( p_close_action_flag = 'Y' and p_reassign_action_flag = 'Y') then
4561: pa_utils.add_message(p_app_short_name => 'PA',
4562: p_msg_name => 'PA_CI_BOTH_REASSGN_CLSE');
4563: if (l_debug_mode = 'Y') then
4564: pa_debug.g_err_stage := 'you cannot both close and reassign the action.';
4565: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 4572: pa_utils.add_message(p_app_short_name => 'PA',

4568: end if;-- if( p_close_action_flag := 'Y' and p_reassign_action_flag := 'Y') then
4569:
4570: /*validathe value for the close action flg. It can be either Y, N or G_PA_MISS_CHAR*/
4571: if (p_close_action_flag <> 'N' and p_close_action_flag <> 'Y' and p_close_action_flag <> G_PA_MISS_CHAR) then
4572: pa_utils.add_message(p_app_short_name => 'PA',
4573: p_msg_name => 'PA_CI_INV_CLS_ACT_FLG');
4574: if (l_debug_mode = 'Y') then
4575: pa_debug.g_err_stage := 'Invalid value for close action flag';
4576: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 4584: pa_utils.add_message(p_app_short_name => 'PA',

4580:
4581: /*validathe value for the reassign action flg. It can be either Y, N or G_PA_MISS_CHAR*/
4582: if (p_reassign_action_flag <> 'N' and p_reassign_action_flag <> 'Y' and
4583: p_reassign_action_flag <> G_PA_MISS_CHAR ) then
4584: pa_utils.add_message(p_app_short_name => 'PA',
4585: p_msg_name => 'PA_CI_INV_REASSGN_ACT_FLG');
4586: if (l_debug_mode = 'Y') then
4587: pa_debug.g_err_stage := 'Invalid value for reassign action flag';
4588: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 4612: pa_utils.add_message(p_app_short_name => 'PA',

4608: close get_action_attrs;
4609:
4610: /*Only open actions can be closed*/
4611: if get_action_attrs_rec.status_code <> 'CI_ACTION_OPEN' then
4612: pa_utils.add_message(p_app_short_name => 'PA',
4613: p_msg_name => 'PA_CI_CLS_OPEN_ACT');
4614: if (l_debug_mode = 'Y') then
4615: pa_debug.g_err_stage := 'only open actions can be closed';
4616: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 4626: pa_utils.add_message(p_app_short_name => 'PA',

4622: if(get_action_attrs_rec.sign_off_required_flag = 'Y') then
4623: /*sign off flag is acknowledged only when sign_off_required_flag is Y*/
4624: /*although sign off is optional but if a value is supplied then it should be either Y or N*/
4625: if(p_sign_off_flag <> 'N' and p_sign_off_flag <> 'Y') then
4626: pa_utils.add_message(p_app_short_name => 'PA',
4627: p_msg_name => 'PA_CI_INV_SIGN_OFF_FLAG');
4628: if (l_debug_mode = 'Y') then
4629: pa_debug.g_err_stage := 'sign off flag can either be Y or N';
4630: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 4706: pa_utils.add_message(p_app_short_name => 'PA',

4702: close get_action_attrs;
4703:
4704: /*only open actions can be reassigned.*/
4705: if get_action_attrs_rec.status_code <> 'CI_ACTION_OPEN' then
4706: pa_utils.add_message(p_app_short_name => 'PA',
4707: p_msg_name => 'PA_CI_REASSGN_OPEN_ACT');
4708: if (l_debug_mode = 'Y') then
4709: pa_debug.g_err_stage := 'only open actions can be reassigned';
4710: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 4721: pa_utils.add_message(p_app_short_name => 'PA',

4717: if(get_action_attrs_rec.sign_off_required_flag = 'Y') then
4718: /*sign off flag is acknowledged only when sign_off_required_flag is Y*/
4719: /*although sign off is optional but if a value is supplied then it should be either Y or N*/
4720: if(p_sign_off_flag <> 'N' and p_sign_off_flag <> 'Y') then
4721: pa_utils.add_message(p_app_short_name => 'PA',
4722: p_msg_name => 'PA_CI_INV_SIGN_OFF_FLAG');
4723: if (l_debug_mode = 'Y') then
4724: pa_debug.g_err_stage := 'sign off flag can either be Y or N';
4725: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 5090: pa_utils.add_message(p_app_short_name => 'PA',

5086: if x_return_status = FND_API.G_RET_STS_SUCCESS then
5087: open c_get_ci_id(l_action_id);
5088: fetch c_get_ci_id into l_ci_id,l_record_version_number,l_created_by, l_status_code;
5089: if c_get_ci_id%notfound then
5090: pa_utils.add_message(p_app_short_name => 'PA',
5091: p_msg_name => 'PA_CI_INV_ACT_ID');
5092: if (l_debug_mode = 'Y') then
5093: pa_debug.g_err_stage := 'invalid action_id passed';
5094: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 5103: pa_utils.add_message(p_app_short_name => 'PA',

5099: else
5100: /*User can only delete the actions, which are created by him*/
5101: close c_get_ci_id;
5102: if l_created_by <> l_user_id then
5103: pa_utils.add_message(p_app_short_name => 'PA',
5104: p_msg_name => 'PA_CI_ACTION_NO_ACCESS');
5105: if (l_debug_mode = 'Y') then
5106: pa_debug.g_err_stage := 'invalid action_id passed';
5107: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 5114: pa_utils.add_message(p_app_short_name => 'PA',

5110:
5111: raise FND_API.G_EXC_ERROR;
5112: end if;
5113: if l_status_code <> 'CI_ACTION_OPEN' then
5114: pa_utils.add_message(p_app_short_name => 'PA',
5115: p_msg_name => 'PA_CI_CANCEL_OPEN_ACTION');
5116: if (l_debug_mode = 'Y') then
5117: pa_debug.g_err_stage := 'Only open actions can be cancelled';
5118: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 5132: PA_UTILS.add_Message( p_app_short_name => 'PA'

5128: /*Security check - whether the cancel button is existing in the UI*/
5129: check_s := pa_ci_security_pkg.check_item_owner_project_auth(l_ci_id);
5130:
5131: if check_s <> 'T' then
5132: PA_UTILS.add_Message( p_app_short_name => 'PA'
5133: ,p_msg_name => 'PA_CI_NO_UPDATE_ACCESS');
5134: x_return_status := FND_API.G_RET_STS_ERROR;
5135: if l_debug_mode = 'Y' then
5136: pa_debug.g_err_stage:= 'Does not have the update access';

Line 5289: PA_UTILS.Add_Message (

5285: -- Close the Cursor.
5286: CLOSE Get_CI_Type_Class_Code;
5287:
5288: -- Add the Error Message to the Stack.
5289: PA_UTILS.Add_Message (
5290: p_App_Short_Name => 'PA'
5291: , p_Msg_Name => 'PA_CI_INV_CI_ID');
5292: -- Raise the Error.
5293: if l_debug_mode = 'Y' then

Line 5442: PA_UTILS.Add_Message (

5438: -- Close the Cursor.
5439: CLOSE Get_CI_Type_Class_Code;
5440:
5441: -- Add the Error Message to the Stack.
5442: PA_UTILS.Add_Message (
5443: p_App_Short_Name => 'PA'
5444: , p_Msg_Name => 'PA_CI_INV_CI_ID');
5445: if l_debug_mode = 'Y' then
5446: pa_debug.g_err_stage:= 'Invalid API Use';

Line 5597: PA_UTILS.Add_Message (

5593: -- Close the Cursor.
5594: CLOSE Get_CI_Type_Class_Code;
5595:
5596: -- Add the Error Message to the Stack.
5597: PA_UTILS.Add_Message (
5598: p_App_Short_Name => 'PA'
5599: , p_Msg_Name => 'PA_CI_INV_CI_ID');
5600: if l_debug_mode = 'Y' then
5601: pa_debug.g_err_stage:= 'Invalid API Use';

Line 5754: PA_UTILS.Add_Message (

5750: -- If the Ci_Id that is passed in is NULL then report
5751: -- Error.
5752: IF (p_Ci_Id IS NULL) THEN
5753: -- Add message to the Error Stack that Ci_Id is NULL.
5754: PA_UTILS.Add_Message (
5755: p_App_Short_Name => 'PA'
5756: , p_Msg_Name => 'PA_CI_MISS_CI_ID'
5757: );
5758: if l_debug_mode = 'Y' then

Line 5775: PA_UTILS.Add_Message (

5771: -- Close the Cursor.
5772: CLOSE Check_Valid_CI;
5773:
5774: -- Add message to the Error Stack that this Ci_Id is Invalid.
5775: PA_UTILS.Add_Message (
5776: p_App_Short_Name => 'PA'
5777: , p_Msg_Name => 'PA_CI_INV_CI_ID'
5778: );
5779: if l_debug_mode = 'Y' then

Line 5839: PA_UTILS.Add_Message (

5835: END LOOP;
5836: ELSE -- If View access is denied to the User for this Control Item.
5837: -- Add message to the Error Stack that the user does not
5838: -- have the privilege to update this Control Item.
5839: PA_UTILS.Add_Message (
5840: p_App_Short_Name => 'PA'
5841: , p_Msg_Name => 'PA_CI_NO_ALLOW_UPDATE'
5842: );
5843:

Line 5991: PA_UTILS.Add_Message (

5987: -- If the Ci_Id that is passed in is NULL then report
5988: -- Error.
5989: IF (p_Ci_Id IS NULL) THEN
5990: -- Add message to the Error Stack that Ci_Id is NULL.
5991: PA_UTILS.Add_Message (
5992: p_App_Short_Name => 'PA'
5993: , p_Msg_Name => 'PA_CI_MISS_CI_ID'
5994: );
5995: if l_debug_mode = 'Y' then

Line 6012: PA_UTILS.Add_Message (

6008: -- Close the Cursor.
6009: CLOSE Check_Valid_CI;
6010:
6011: -- Add message to the Error Stack that this Ci_Id is Invalid.
6012: PA_UTILS.Add_Message (
6013: p_App_Short_Name => 'PA'
6014: , p_Msg_Name => 'PA_CI_INV_CI_ID'
6015: );
6016: if l_debug_mode = 'Y' then

Line 6063: PA_UTILS.Add_Message (

6059: -- Close the Cursor.
6060: CLOSE Check_Valid_CI;
6061:
6062: -- Add message to the Error Stack that this Ci_Id is Invalid.
6063: PA_UTILS.Add_Message (
6064: p_App_Short_Name => 'PA'
6065: , p_Msg_Name => 'PA_CI_RELATED_ITEM_INVALID'
6066: , p_Token1 => 'NUMBER'
6067: , p_Value1 => i

Line 6113: PA_UTILS.Add_Message (

6109: -- Check if Update Access was denied or not.
6110: IF (l_UpdateAccess <> 'T') THEN
6111: -- Add message to the Error Stack that the user does not
6112: -- have the privilege to update this Control Item.
6113: PA_UTILS.Add_Message (
6114: p_App_Short_Name => 'PA'
6115: , p_Msg_Name => 'PA_CI_UPDATE_NOT_ALLOWED'
6116: );
6117: if l_debug_mode = 'Y' then

Line 6127: PA_UTILS.Add_Message (

6123: -- Check if update was denied by Status Control or not.
6124: IF (l_UpdateAllowed <> 'Y') THEN
6125: -- Add message to the Error Stack that this Control Item
6126: -- cannot be updated in its present status.
6127: PA_UTILS.Add_Message (
6128: p_App_Short_Name => 'PA'
6129: , p_Msg_Name => 'PA_CI_NO_ALLOW_UPDATE'
6130: );
6131: if l_debug_mode = 'Y' then

Line 6146: PA_UTILS.Add_Message (

6142: CLOSE Check_Workflow_On_CI;
6143:
6144: -- Add message to the Error Stack that this Ci_Id has Workflow
6145: -- attached.
6146: PA_UTILS.Add_Message (
6147: p_App_Short_Name => 'PA'
6148: , p_Msg_Name => 'PA_CI_APPROVAL_WORKFLOW'
6149: );
6150: if l_debug_mode = 'Y' then

Line 6297: PA_UTILS.Add_Message (

6293: -- If any of the Ci_Ids that are passed in is NULL then
6294: -- report Error.
6295: IF (p_Ci_Id IS NULL OR p_To_Ci_Id IS NULL) THEN
6296: -- Add message to the Error Stack that Ci_Id is NULL.
6297: PA_UTILS.Add_Message (
6298: p_App_Short_Name => 'PA'
6299: , p_Msg_Name => 'PA_CI_MISS_CI_ID'
6300: );
6301: if l_debug_mode = 'Y' then

Line 6318: PA_UTILS.Add_Message (

6314: -- Close the Cursor.
6315: CLOSE Check_Valid_CI;
6316:
6317: -- Add message to the Error Stack that this Ci_Id is Invalid.
6318: PA_UTILS.Add_Message (
6319: p_App_Short_Name => 'PA'
6320: , p_Msg_Name => 'PA_CI_INV_CI_ID'
6321: );
6322: if l_debug_mode = 'Y' then

Line 6340: PA_UTILS.Add_Message (

6336: -- Close the Cursor.
6337: CLOSE Check_Valid_CI;
6338:
6339: -- Add message to the Error Stack that this Ci_Id is Invalid.
6340: PA_UTILS.Add_Message (
6341: p_App_Short_Name => 'PA'
6342: , p_Msg_Name => 'PA_CI_INV_CI_ID'
6343: );
6344: if l_debug_mode = 'Y' then

Line 6400: PA_UTILS.Add_Message (

6396: -- Check if Update Access was denied or not.
6397: IF (l_UpdateAccess <> 'T') THEN
6398: -- Add message to the Error Stack that the user does not
6399: -- have the privilege to update this Control Item.
6400: PA_UTILS.Add_Message (
6401: p_App_Short_Name => 'PA'
6402: , p_Msg_Name => 'PA_CI_UPDATE_NOT_ALLOWED'
6403: );
6404: if l_debug_mode = 'Y' then

Line 6414: PA_UTILS.Add_Message (

6410: -- Check if update was denied by Status Control or not.
6411: IF (l_UpdateAllowed <> 'Y') THEN
6412: -- Add message to the Error Stack that this Control Item
6413: -- cannot be updated in its present status.
6414: PA_UTILS.Add_Message (
6415: p_App_Short_Name => 'PA'
6416: , p_Msg_Name => 'PA_CI_NO_ALLOW_UPDATE'
6417: );
6418: if l_debug_mode = 'Y' then

Line 6433: PA_UTILS.Add_Message (

6429: CLOSE Check_Workflow_On_CI;
6430:
6431: -- Add message to the Error Stack that this Ci_Id has Workflow
6432: -- attached.
6433: PA_UTILS.Add_Message (
6434: p_App_Short_Name => 'PA'
6435: , p_Msg_Name => 'PA_CI_APPROVAL_WORKFLOW'
6436: );
6437: if l_debug_mode = 'Y' then

Line 6796: PA_UTILS.Add_Message( p_app_short_name => 'PA'

6792: OPEN curr_row;
6793: FETCH curr_row INTO cp;
6794: IF curr_row%NOTFOUND then
6795: close curr_row;
6796: PA_UTILS.Add_Message( p_app_short_name => 'PA'
6797: ,p_msg_name => 'PA_CI_INVALID_ITEM'); /* Change this message */
6798: RAISE FND_API.G_EXC_ERROR;
6799: ELSE
6800:

Line 6858: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

6854: CLOSE c_info;
6855:
6856: /* Added to check invalid API usage*/
6857: if l_ci_type_class_code <> l_class_code then
6858: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
6859: p_msg_name => 'PA_CI_INV_API_USE');
6860: if l_debug_mode = 'Y' then
6861: pa_debug.g_err_stage:= 'wrong usage of the api for the control item type';
6862: pa_debug.write(l_module,pa_debug.g_err_stage,l_debug_level3);

Line 6878: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_UPDATE_ACCESS');

6874: l_check_update_access := pa_ci_security_pkg.check_update_access(p_ci_id);
6875:
6876: IF (l_check_update_access = 'F') THEN
6877:
6878: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_UPDATE_ACCESS');
6879: RAISE FND_API.G_EXC_ERROR;
6880:
6881: END IF;
6882:

Line 6893: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_ALLOW_UPDATE');

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');
6894: RAISE FND_API.G_EXC_ERROR;
6895:
6896: END IF;
6897:

Line 6910: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_APPROVAL_WORKFLOW');

6906: FETCH c_submit_status INTO l_enable_wf_flag, l_wf_success_status_code, l_wf_failure_status_code;
6907: CLOSE c_submit_status;
6908: IF (l_enable_wf_flag = 'Y' AND l_wf_success_status_code IS NOT NULL AND l_wf_failure_status_code IS NOT NULL) THEN
6909:
6910: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_APPROVAL_WORKFLOW');
6911: RAISE FND_API.G_EXC_ERROR;
6912:
6913: END IF;
6914:

Line 6992: PA_UTILS.Add_Message( p_app_short_name => 'PA'

6988:
6989: l_rows := DBMS_SQL.EXECUTE(l_cursor);
6990:
6991: IF (l_rows < 0) THEN
6992: PA_UTILS.Add_Message( p_app_short_name => 'PA'
6993: ,p_msg_name => 'PA_TO_STATUS_INVALID');
6994: x_return_status := FND_API.G_RET_STS_ERROR;
6995: l_to_status_flag := 'N';
6996: ELSE

Line 7003: PA_UTILS.Add_Message( p_app_short_name => 'PA'

6999: if l_rows1 > 0 THEN
7000: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);
7001: l_ci_status_code := l_ci_status_code_1;
7002: else
7003: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7004: ,p_msg_name => 'PA_TO_STATUS_INVALID');
7005: x_return_status := FND_API.G_RET_STS_ERROR;
7006: l_to_status_flag := 'N';
7007: end if;

Line 7019: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7015: dbms_sql.close_cursor(l_cursor);
7016: END IF;
7017: ELSIF p_ci_status_code IS NULL THEN
7018: l_ci_status_code := p_ci_status_code;
7019: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7020: ,p_msg_name => 'PA_CI_NULL_STATUS');
7021: x_return_status := FND_API.G_RET_STS_ERROR;
7022: l_to_status_flag := 'N';
7023: END IF;

Line 7036: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NULL_SUMMARY');

7032: NULL;
7033: ELSIF p_summary IS NOT NULL THEN
7034: l_summary := p_summary;
7035: ELSIF p_summary IS NULL THEN
7036: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NULL_SUMMARY');
7037: x_return_status := FND_API.G_RET_STS_ERROR;
7038: END IF;
7039:
7040: IF p_description = G_PA_MISS_CHAR THEN

Line 7055: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7051: l_owner_id := l_curr_owner_id;
7052: ELSIF p_owner_id IS NOT NULL THEN
7053: l_owner_id := p_owner_id;
7054: IF (l_owner_id = l_curr_owner_id) then
7055: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7056: ,p_msg_name => 'PA_CI_CHANGE_OWNER_INVALID');
7057: x_return_status := 'E';
7058:
7059: ELSIF (l_owner_id <> l_curr_owner_id) then

Line 7062: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7058:
7059: ELSIF (l_owner_id <> l_curr_owner_id) then
7060: l_chgowner_allowed := pa_ci_security_pkg.check_change_owner_access(p_ci_id);
7061: IF (l_chgowner_allowed <> 'T') then
7062: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7063: ,p_msg_name => 'PA_CI_OWNER_CHG_NOT_ALLOWED');
7064: x_return_status := 'E';
7065: else
7066: l_to_owner_allowed := pa_ci_security_pkg.is_to_owner_allowed(p_ci_id, l_owner_id);

Line 7068: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7064: x_return_status := 'E';
7065: else
7066: l_to_owner_allowed := pa_ci_security_pkg.is_to_owner_allowed(p_ci_id, l_owner_id);
7067: if (l_to_owner_allowed <> 'T') then
7068: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7069: ,p_msg_name => 'PA_CI_TO_OWNER_NOT_ALLOWED');
7070: x_return_status := 'E';
7071: else
7072:

Line 7077: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7073: /*get the Passed owner name*/
7074: OPEN c_get_owner(l_owner_id,l_project_id);
7075: FETCH c_get_owner into l_owner_name;
7076: if (c_get_owner%notfound) then
7077: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7078: ,p_msg_name => 'PA_CI_CHANGE_OWNER_INVALID');
7079: x_return_status := 'E';
7080: end if;
7081: close c_get_owner;

Line 7087: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7083: /*Get the Current Owner name*/
7084: OPEN c_get_owner(l_curr_owner_id,l_project_id);
7085: FETCH c_get_owner into l_curr_owner_name;
7086: if (c_get_owner%notfound) then
7087: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7088: ,p_msg_name => 'PA_CI_CHANGE_OWNER_INVALID');
7089: x_return_status := 'E';
7090: end if;
7091: close c_get_owner;

Line 7114: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7110: end if;
7111: end if;
7112: end if;
7113: ELSIF p_owner_id IS NULL THEN
7114: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7115: ,p_msg_name => 'PA_CI_OWNER_NULL');
7116: x_return_status := FND_API.G_RET_STS_ERROR;
7117: END IF;
7118:

Line 7126: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7122: OPEN c_classification (l_ci_type_id, p_classification_code);
7123: FETCH c_classification INTO l_classification_code_id;
7124: IF c_classification%NOTFOUND then
7125: -- close c_classification;
7126: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7127: ,p_msg_name => 'PA_CI_CLASSIFICATION_INV');
7128: x_return_status := FND_API.G_RET_STS_ERROR;
7129: END IF;
7130: close c_classification;

Line 7132: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7128: x_return_status := FND_API.G_RET_STS_ERROR;
7129: END IF;
7130: close c_classification;
7131: ELSIF p_classification_code IS NULL THEN
7132: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7133: ,p_msg_name => 'PA_CI_CLASSIFICATION_NULL');
7134: x_return_status := FND_API.G_RET_STS_ERROR;
7135: END IF;
7136:

Line 7144: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7140: OPEN c_reason (l_ci_type_id, p_reason_code);
7141: FETCH c_reason INTO l_reason_code_id;
7142: IF c_reason%NOTFOUND then
7143: -- close c_reason;
7144: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7145: ,p_msg_name => 'PA_CI_REASON_INV');
7146: x_return_status := FND_API.G_RET_STS_ERROR;
7147: END IF;
7148: close c_reason;

Line 7150: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7146: x_return_status := FND_API.G_RET_STS_ERROR;
7147: END IF;
7148: close c_reason;
7149: ELSIF p_reason_code IS NULL THEN
7150: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7151: ,p_msg_name => 'PA_CI_REASON_NULL');
7152: x_return_status := FND_API.G_RET_STS_ERROR;
7153: END IF;
7154:

Line 7167: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7163: WHERE project_id = l_project_id
7164: AND proj_element_id = p_object_id;
7165:
7166: EXCEPTION WHEN TOO_MANY_ROWS THEN
7167: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7168: ,p_msg_name => 'PA_OBJECT_NAME_MULTIPLE');
7169: x_return_status := FND_API.G_RET_STS_ERROR;
7170:
7171: WHEN OTHERS THEN

Line 7172: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7168: ,p_msg_name => 'PA_OBJECT_NAME_MULTIPLE');
7169: x_return_status := FND_API.G_RET_STS_ERROR;
7170:
7171: WHEN OTHERS THEN
7172: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7173: ,p_msg_name => 'PA_OBJECT_NAME_INV');
7174: x_return_status := FND_API.G_RET_STS_ERROR;
7175: END;
7176: ELSIF p_object_id IS NULL THEN

Line 7186: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7182: ELSIF p_object_type IS NOT NULL THEN
7183: IF p_object_type = 'PA_TASKS' THEN
7184: l_object_type := p_object_type;
7185: ELSE
7186: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7187: ,p_msg_name => 'PA_OBJECT_TYPE_INV');
7188: x_return_status := FND_API.G_RET_STS_ERROR;
7189: END IF;
7190: ELSIF p_object_type IS NULL THEN

Line 7209: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7205: OPEN c_lkup(l_priority_type, p_priority_code);
7206: FETCH c_lkup INTO l_priority_code;
7207: IF c_lkup%NOTFOUND then
7208: -- close c_lkup;
7209: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7210: ,p_msg_name => 'PA_CI_PRIORITY_INV');
7211: x_return_status := FND_API.G_RET_STS_ERROR;
7212: END IF;
7213: close c_lkup;

Line 7225: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7221: OPEN c_lkup(l_effort_type, p_effort_level_code);
7222: FETCH c_lkup INTO l_effort_level_code;
7223: IF c_lkup%NOTFOUND then
7224: -- close c_lkup;
7225: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7226: ,p_msg_name => 'PA_CI_EFFORT_INV');
7227: x_return_status := FND_API.G_RET_STS_ERROR;
7228: END IF;
7229: close c_lkup;

Line 7258: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7254: OPEN c_lkup(l_source_type, p_source_type_code);
7255: FETCH c_lkup INTO l_source_type_code;
7256: IF c_lkup%NOTFOUND then
7257: -- close c_lkup;
7258: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7259: ,p_msg_name => 'PA_CI_SOURCE_TYPE_INV');
7260: x_return_status := FND_API.G_RET_STS_ERROR;
7261: END IF;
7262: close c_lkup;

Line 7302: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7298: NULL;
7299: ELSIF p_progress_as_of_date IS NOT NULL THEN
7300: l_progress_as_of_date := p_progress_as_of_date;
7301: ELSIF p_progress_as_of_date IS NULL THEN
7302: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7303: ,p_msg_name => 'PA_AS_OF_DATE_NULL');
7304: x_return_status := FND_API.G_RET_STS_ERROR;
7305: END IF;
7306:

Line 7322: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7318:
7319: IF p_ci_number = G_PA_MISS_CHAR THEN
7320: IF l_ci_number IS NULL THEN
7321: IF (l_curr_system_status = 'CI_DRAFT' AND (l_new_system_status IS NOT NULL AND l_new_system_status <> 'CI_DRAFT')) THEN
7322: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7323: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
7324: x_return_status := FND_API.G_RET_STS_ERROR;
7325: ELSIF l_curr_system_status <> 'CI_DRAFT' THEN
7326: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 7326: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7322: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7323: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
7324: x_return_status := FND_API.G_RET_STS_ERROR;
7325: ELSIF l_curr_system_status <> 'CI_DRAFT' THEN
7326: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7327: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
7328: x_return_status := FND_API.G_RET_STS_ERROR;
7329: END IF;
7330: END IF;

Line 7333: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7329: END IF;
7330: END IF;
7331: ELSIF p_ci_number IS NULL THEN
7332: IF (l_curr_system_status = 'CI_DRAFT' AND (l_new_system_status IS NOT NULL AND l_new_system_status <> 'CI_DRAFT')) THEN
7333: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7334: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
7335: x_return_status := FND_API.G_RET_STS_ERROR;
7336: ELSIF l_curr_system_status <> 'CI_DRAFT' THEN
7337: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 7337: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7333: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7334: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
7335: x_return_status := FND_API.G_RET_STS_ERROR;
7336: ELSIF l_curr_system_status <> 'CI_DRAFT' THEN
7337: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7338: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
7339: x_return_status := FND_API.G_RET_STS_ERROR;
7340: END IF;
7341: END IF;

Line 7352: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7348: IF (c_ci_number%NOTFOUND) then
7349: CLOSE c_ci_number;
7350: ELSE
7351: CLOSE c_ci_number;
7352: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7353: ,p_msg_name => 'PA_CI_DUPLICATE_CI_NUMBER');
7354: x_return_status := FND_API.G_RET_STS_ERROR;
7355: END IF;
7356: END IF;

Line 7368: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7364: OPEN c_statuses(l_progress_type, p_progress_status_code);
7365: FETCH c_statuses INTO l_progress_status_code;
7366: IF c_statuses%NOTFOUND then
7367: close c_statuses;
7368: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7369: ,p_msg_name => 'PA_PROGRESS_STATUS_INV');
7370: x_return_status := FND_API.G_RET_STS_ERROR;
7371: END IF;
7372: close c_statuses;

Line 7374: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7370: x_return_status := FND_API.G_RET_STS_ERROR;
7371: END IF;
7372: close c_statuses;
7373: ELSIF p_progress_status_code IS NULL THEN
7374: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7375: ,p_msg_name => 'PA_PROGRESS_STATUS_NULL');
7376: x_return_status := FND_API.G_RET_STS_ERROR;
7377: END IF;
7378:

Line 7392: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7388: OPEN c_resolution (l_ci_type_id, p_resolution_code);
7389: FETCH c_resolution INTO l_resolution_code_id;
7390: IF c_resolution%NOTFOUND then
7391: close c_resolution;
7392: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7393: ,p_msg_name => 'PA_CI_RESOLUTION_INV');
7394: x_return_status := FND_API.G_RET_STS_ERROR;
7395: END IF;
7396: close c_resolution;

Line 7551: PA_UTILS.Add_Message( p_app_short_name => 'PA'

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;
7554: END IF;
7555: ELSE

Line 7557: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7553: x_return_status := FND_API.G_RET_STS_ERROR;
7554: END IF;
7555: ELSE
7556: IF (l_resolution_code_id IS NULL) THEN
7557: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7558: ,p_msg_name => 'PA_CI_RESOLUTION_OPEN');
7559: x_return_status := FND_API.G_RET_STS_ERROR;
7560: END IF;
7561: END IF;

Line 7567: PA_UTILS.Add_Message( p_app_short_name => 'PA'

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;
7570: END IF;
7571: ELSE

Line 7573: PA_UTILS.Add_Message( p_app_short_name => 'PA'

7569: x_return_status := FND_API.G_RET_STS_ERROR;
7570: END IF;
7571: ELSE
7572: IF (l_resolution_code_id IS NULL) THEN
7573: PA_UTILS.Add_Message( p_app_short_name => 'PA'
7574: ,p_msg_name => 'PA_CI_CLOSE_INV_RES');
7575: x_return_status := FND_API.G_RET_STS_ERROR;
7576: END IF;
7577: END IF;

Line 8056: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8052: OPEN curr_row;
8053: FETCH curr_row INTO cp;
8054: IF curr_row%NOTFOUND then
8055: close curr_row;
8056: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8057: ,p_msg_name => 'PA_CI_INVALID_ITEM'); /* Change this message */
8058: RAISE FND_API.G_EXC_ERROR;
8059: ELSE
8060:

Line 8119: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

8115: CLOSE c_info;
8116:
8117: /* Added to check invalid API usage*/
8118: if l_ci_type_class_code <> l_class_code then
8119: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
8120: p_msg_name => 'PA_CI_INV_API_USE');
8121: if l_debug_mode = 'Y' then
8122: pa_debug.g_err_stage:= 'wrong usage of the api for the control item type';
8123: pa_debug.write(l_module,pa_debug.g_err_stage,l_debug_level3);

Line 8139: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_UPDATE_ACCESS');

8135: l_check_update_access := pa_ci_security_pkg.check_update_access(p_ci_id);
8136:
8137: IF (l_check_update_access = 'F') THEN
8138:
8139: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_UPDATE_ACCESS');
8140: RAISE FND_API.G_EXC_ERROR;
8141:
8142: END IF;
8143:

Line 8154: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_ALLOW_UPDATE');

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');
8155: RAISE FND_API.G_EXC_ERROR;
8156:
8157: END IF;
8158:

Line 8172: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_APPROVAL_WORKFLOW');

8168: CLOSE c_submit_status;
8169:
8170: IF (l_enable_wf_flag = 'Y' AND l_wf_success_status_code IS NOT NULL AND l_wf_failure_status_code IS NOT NULL) THEN
8171:
8172: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_APPROVAL_WORKFLOW');
8173: RAISE FND_API.G_EXC_ERROR;
8174:
8175: END IF;
8176:

Line 8247: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8243:
8244: l_rows := DBMS_SQL.EXECUTE(l_cursor);
8245:
8246: IF (l_rows < 0) THEN
8247: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8248: ,p_msg_name => 'PA_TO_STATUS_INVALID');
8249: x_return_status := FND_API.G_RET_STS_ERROR;
8250: l_to_status_flag := 'N';
8251: ELSE

Line 8258: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8254: if l_rows1 > 0 THEN
8255: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);
8256: l_ci_status_code := l_ci_status_code_1;
8257: else
8258: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8259: ,p_msg_name => 'PA_TO_STATUS_INVALID');
8260: x_return_status := FND_API.G_RET_STS_ERROR;
8261: l_to_status_flag := 'N';
8262: end if;

Line 8270: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NULL_STATUS');

8266: dbms_sql.close_cursor(l_cursor);
8267: END IF;
8268: ELSIF p_ci_status_code IS NULL THEN
8269: l_ci_status_code := p_ci_status_code;
8270: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NULL_STATUS');
8271: x_return_status := FND_API.G_RET_STS_ERROR;
8272: l_to_status_flag := 'N';
8273: END IF;
8274:

Line 8286: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NULL_SUMMARY');

8282: NULL;
8283: ELSIF p_summary IS NOT NULL THEN
8284: l_summary := p_summary;
8285: ELSIF p_summary IS NULL THEN
8286: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NULL_SUMMARY');
8287: x_return_status := FND_API.G_RET_STS_ERROR;
8288: END IF;
8289:
8290: IF p_description = G_PA_MISS_CHAR THEN

Line 8304: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8300: l_owner_id := l_curr_owner_id;
8301: ELSIF p_owner_id IS NOT NULL THEN
8302: l_owner_id := p_owner_id;
8303: IF (l_owner_id = l_curr_owner_id) then
8304: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8305: ,p_msg_name => 'PA_CI_CHANGE_OWNER_INVALID');
8306: x_return_status := 'E';
8307:
8308: ELSIF (l_owner_id <> l_curr_owner_id) then

Line 8311: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8307:
8308: ELSIF (l_owner_id <> l_curr_owner_id) then
8309: l_chgowner_allowed := pa_ci_security_pkg.check_change_owner_access(p_ci_id);
8310: IF (l_chgowner_allowed <> 'T') then
8311: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8312: ,p_msg_name => 'PA_CI_OWNER_CHG_NOT_ALLOWED');
8313: x_return_status := 'E';
8314: else
8315: l_to_owner_allowed := pa_ci_security_pkg.is_to_owner_allowed(p_ci_id, l_owner_id);

Line 8317: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8313: x_return_status := 'E';
8314: else
8315: l_to_owner_allowed := pa_ci_security_pkg.is_to_owner_allowed(p_ci_id, l_owner_id);
8316: if (l_to_owner_allowed <> 'T') then
8317: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8318: ,p_msg_name => 'PA_CI_TO_OWNER_NOT_ALLOWED');
8319: x_return_status := 'E';
8320: else
8321:

Line 8326: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8322: /*get the Passed owner names*/
8323: OPEN c_get_owner(l_owner_id,l_project_id);
8324: FETCH c_get_owner into l_owner_name;
8325: if (c_get_owner%notfound) then
8326: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8327: ,p_msg_name => 'PA_CI_CHANGE_OWNER_INVALID');
8328: x_return_status := 'E';
8329: end if;
8330: close c_get_owner;

Line 8336: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8332: /*Get the Current Owner name*/
8333: OPEN c_get_owner(l_curr_owner_id,l_project_id);
8334: FETCH c_get_owner into l_curr_owner_name;
8335: if (c_get_owner%notfound) then
8336: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8337: ,p_msg_name => 'PA_CI_CHANGE_OWNER_INVALID');
8338: x_return_status := 'E';
8339: end if;
8340: close c_get_owner;

Line 8365: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8361: end if;
8362: ELSIF p_owner_id IS NOT NULL THEN
8363: l_owner_id := p_owner_id;
8364: IF (l_owner_id = l_curr_owner_id) then
8365: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8366: ,p_msg_name => 'PA_CI_CHANGE_OWNER_INVALID');
8367: x_return_status := 'E';
8368: END IF;
8369: /* Getting validated in pa_control_items_pub.update_control_item API. */

Line 8371: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8367: x_return_status := 'E';
8368: END IF;
8369: /* Getting validated in pa_control_items_pub.update_control_item API. */
8370: ELSIF p_owner_id IS NULL THEN
8371: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8372: ,p_msg_name => 'PA_CI_OWNER_NULL');
8373: x_return_status := FND_API.G_RET_STS_ERROR;
8374: END IF;
8375:

Line 8383: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8379: OPEN c_classification (l_ci_type_id, p_classification_code);
8380: FETCH c_classification INTO l_classification_code_id;
8381: IF c_classification%NOTFOUND then
8382: -- close c_classification;
8383: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8384: ,p_msg_name => 'PA_CI_CLASSIFICATION_INV');
8385: x_return_status := FND_API.G_RET_STS_ERROR;
8386: END IF;
8387: close c_classification;

Line 8389: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8385: x_return_status := FND_API.G_RET_STS_ERROR;
8386: END IF;
8387: close c_classification;
8388: ELSIF p_classification_code IS NULL THEN
8389: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8390: ,p_msg_name => 'PA_CI_CLASSIFICATION_NULL');
8391: x_return_status := FND_API.G_RET_STS_ERROR;
8392: END IF;
8393:

Line 8401: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8397: OPEN c_reason (l_ci_type_id, p_reason_code);
8398: FETCH c_reason INTO l_reason_code_id;
8399: IF c_reason%NOTFOUND then
8400: -- close c_reason;
8401: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8402: ,p_msg_name => 'PA_CI_REASON_INV');
8403: x_return_status := FND_API.G_RET_STS_ERROR;
8404: END IF;
8405: close c_reason;

Line 8407: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8403: x_return_status := FND_API.G_RET_STS_ERROR;
8404: END IF;
8405: close c_reason;
8406: ELSIF p_reason_code IS NULL THEN
8407: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8408: ,p_msg_name => 'PA_CI_REASON_NULL');
8409: x_return_status := FND_API.G_RET_STS_ERROR;
8410: END IF;
8411:

Line 8424: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8420: WHERE project_id = l_project_id
8421: AND proj_element_id = p_object_id;
8422:
8423: EXCEPTION WHEN TOO_MANY_ROWS THEN
8424: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8425: ,p_msg_name => 'PA_OBJECT_NAME_MULTIPLE');
8426: x_return_status := FND_API.G_RET_STS_ERROR;
8427:
8428: WHEN OTHERS THEN

Line 8429: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8425: ,p_msg_name => 'PA_OBJECT_NAME_MULTIPLE');
8426: x_return_status := FND_API.G_RET_STS_ERROR;
8427:
8428: WHEN OTHERS THEN
8429: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8430: ,p_msg_name => 'PA_OBJECT_NAME_INV');
8431: x_return_status := FND_API.G_RET_STS_ERROR;
8432: END;
8433: ELSIF p_object_id IS NULL THEN

Line 8443: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8439: ELSIF p_object_type IS NOT NULL THEN
8440: IF p_object_type = 'PA_TASKS' THEN
8441: l_object_type := p_object_type;
8442: ELSE
8443: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8444: ,p_msg_name => 'PA_OBJECT_TYPE_INV');
8445: x_return_status := FND_API.G_RET_STS_ERROR;
8446: END IF;
8447: ELSIF p_object_type IS NULL THEN

Line 8466: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8462: OPEN c_lkup(l_priority_type, p_priority_code);
8463: FETCH c_lkup INTO l_priority_code;
8464: IF c_lkup%NOTFOUND then
8465: -- close c_lkup;
8466: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8467: ,p_msg_name => 'PA_CI_PRIORITY_INV');
8468: x_return_status := FND_API.G_RET_STS_ERROR;
8469: END IF;
8470: close c_lkup;

Line 8482: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8478: OPEN c_lkup(l_effort_type, p_effort_level_code);
8479: FETCH c_lkup INTO l_effort_level_code;
8480: IF c_lkup%NOTFOUND then
8481: -- close c_lkup;
8482: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8483: ,p_msg_name => 'PA_CI_EFFORT_INV');
8484: x_return_status := FND_API.G_RET_STS_ERROR;
8485: END IF;
8486: close c_lkup;

Line 8515: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8511: OPEN c_lkup(l_source_type, p_source_type_code);
8512: FETCH c_lkup INTO l_source_type_code;
8513: IF c_lkup%NOTFOUND then
8514: -- close c_lkup;
8515: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8516: ,p_msg_name => 'PA_CI_SOURCE_TYPE_INV');
8517: x_return_status := FND_API.G_RET_STS_ERROR;
8518: END IF;
8519: close c_lkup;

Line 8559: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8555: NULL;
8556: ELSIF p_progress_as_of_date IS NOT NULL THEN
8557: l_progress_as_of_date := p_progress_as_of_date;
8558: ELSIF p_progress_as_of_date IS NULL THEN
8559: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8560: ,p_msg_name => 'PA_AS_OF_DATE_NULL');
8561: x_return_status := FND_API.G_RET_STS_ERROR;
8562: END IF;
8563:

Line 8579: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8575:
8576: IF p_ci_number = G_PA_MISS_CHAR THEN
8577: IF l_ci_number IS NULL THEN
8578: IF (l_curr_system_status = 'CI_DRAFT' AND (l_new_system_status IS NOT NULL AND l_new_system_status <> 'CI_DRAFT')) THEN
8579: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8580: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
8581: x_return_status := FND_API.G_RET_STS_ERROR;
8582: ELSIF l_curr_system_status <> 'CI_DRAFT' THEN
8583: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 8583: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8579: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8580: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
8581: x_return_status := FND_API.G_RET_STS_ERROR;
8582: ELSIF l_curr_system_status <> 'CI_DRAFT' THEN
8583: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8584: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
8585: x_return_status := FND_API.G_RET_STS_ERROR;
8586: END IF;
8587: END IF;

Line 8590: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8586: END IF;
8587: END IF;
8588: ELSIF p_ci_number IS NULL THEN
8589: IF (l_curr_system_status = 'CI_DRAFT' AND (l_new_system_status IS NOT NULL AND l_new_system_status <> 'CI_DRAFT')) THEN
8590: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8591: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
8592: x_return_status := FND_API.G_RET_STS_ERROR;
8593: ELSIF l_curr_system_status <> 'CI_DRAFT' THEN
8594: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 8594: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8590: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8591: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
8592: x_return_status := FND_API.G_RET_STS_ERROR;
8593: ELSIF l_curr_system_status <> 'CI_DRAFT' THEN
8594: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8595: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
8596: x_return_status := FND_API.G_RET_STS_ERROR;
8597: END IF;
8598: END IF;

Line 8609: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8605: IF (c_ci_number%NOTFOUND) then
8606: CLOSE c_ci_number;
8607: ELSE
8608: CLOSE c_ci_number;
8609: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8610: ,p_msg_name => 'PA_CI_DUPLICATE_CI_NUMBER');
8611: x_return_status := FND_API.G_RET_STS_ERROR;
8612: END IF;
8613: END IF;

Line 8625: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8621: OPEN c_statuses(l_progress_type, p_progress_status_code);
8622: FETCH c_statuses INTO l_progress_status_code;
8623: IF c_statuses%NOTFOUND then
8624: close c_statuses;
8625: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8626: ,p_msg_name => 'PA_PROGRESS_STATUS_INV');
8627: x_return_status := FND_API.G_RET_STS_ERROR;
8628: END IF;
8629: close c_statuses;

Line 8631: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8627: x_return_status := FND_API.G_RET_STS_ERROR;
8628: END IF;
8629: close c_statuses;
8630: ELSIF p_progress_status_code IS NULL THEN
8631: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8632: ,p_msg_name => 'PA_PROGRESS_STATUS_NULL');
8633: x_return_status := FND_API.G_RET_STS_ERROR;
8634: END IF;
8635:

Line 8649: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8645: OPEN c_resolution (l_ci_type_id, p_resolution_code);
8646: FETCH c_resolution INTO l_resolution_code_id;
8647: IF c_resolution%NOTFOUND then
8648: close c_resolution;
8649: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8650: ,p_msg_name => 'PA_CI_RESOLUTION_INV');
8651: x_return_status := FND_API.G_RET_STS_ERROR;
8652: END IF;
8653: close c_resolution;

Line 8808: PA_UTILS.Add_Message( p_app_short_name => 'PA'

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;
8811: END IF;
8812: ELSE

Line 8814: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8810: x_return_status := FND_API.G_RET_STS_ERROR;
8811: END IF;
8812: ELSE
8813: IF (l_resolution_code_id IS NULL) THEN
8814: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8815: ,p_msg_name => 'PA_CI_RESOLUTION_OPEN');
8816: x_return_status := FND_API.G_RET_STS_ERROR;
8817: END IF;
8818: END IF;

Line 8824: PA_UTILS.Add_Message( p_app_short_name => 'PA'

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;
8827: END IF;
8828: ELSE

Line 8830: PA_UTILS.Add_Message( p_app_short_name => 'PA'

8826: x_return_status := FND_API.G_RET_STS_ERROR;
8827: END IF;
8828: ELSE
8829: IF (l_resolution_code_id IS NULL) THEN
8830: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8831: ,p_msg_name => 'PA_CI_CLOSE_INV_RES');
8832: x_return_status := FND_API.G_RET_STS_ERROR;
8833: END IF;
8834: END IF;

Line 9313: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9309: OPEN curr_row;
9310: FETCH curr_row INTO cp;
9311: IF curr_row%NOTFOUND then
9312: close curr_row;
9313: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9314: ,p_msg_name => 'PA_CI_INVALID_ITEM'); /* Change this message */
9315: RAISE FND_API.G_EXC_ERROR;
9316: ELSE
9317:

Line 9376: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

9372:
9373:
9374: /* Added to check invalid API usage*/
9375: if l_ci_type_class_code <> l_class_code then
9376: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
9377: p_msg_name => 'PA_CI_INV_API_USE');
9378: if l_debug_mode = 'Y' then
9379: pa_debug.g_err_stage:= 'wrong usage of the api for the control item type';
9380: pa_debug.write(l_module,pa_debug.g_err_stage,l_debug_level3);

Line 9395: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_UPDATE_ACCESS');

9391: l_check_update_access := pa_ci_security_pkg.check_update_access(p_ci_id);
9392:
9393: IF (l_check_update_access = 'F') THEN
9394:
9395: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_UPDATE_ACCESS');
9396: RAISE FND_API.G_EXC_ERROR;
9397:
9398: END IF;
9399:

Line 9410: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NO_ALLOW_UPDATE');

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');
9411: RAISE FND_API.G_EXC_ERROR;
9412:
9413: END IF;
9414:

Line 9428: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_APPROVAL_WORKFLOW');

9424: CLOSE c_submit_status;
9425:
9426: IF (l_enable_wf_flag = 'Y' AND l_wf_success_status_code IS NOT NULL AND l_wf_failure_status_code IS NOT NULL) THEN
9427:
9428: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_APPROVAL_WORKFLOW');
9429: RAISE FND_API.G_EXC_ERROR;
9430:
9431: END IF;
9432:

Line 9504: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9500:
9501: l_rows := DBMS_SQL.EXECUTE(l_cursor);
9502:
9503: IF (l_rows < 0) THEN
9504: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9505: ,p_msg_name => 'PA_TO_STATUS_INVALID');
9506: x_return_status := FND_API.G_RET_STS_ERROR;
9507: l_to_status_flag := 'N';
9508: ELSE

Line 9515: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9511: if l_rows1 > 0 THEN
9512: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ci_status_code_1);
9513: l_ci_status_code := l_ci_status_code_1;
9514: else
9515: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9516: ,p_msg_name => 'PA_TO_STATUS_INVALID');
9517: x_return_status := FND_API.G_RET_STS_ERROR;
9518: l_to_status_flag := 'N';
9519: end if;

Line 9527: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NULL_STATUS');

9523: dbms_sql.close_cursor(l_cursor);
9524: END IF;
9525: ELSIF p_ci_status_code IS NULL THEN
9526: l_ci_status_code := p_ci_status_code;
9527: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NULL_STATUS');
9528: x_return_status := FND_API.G_RET_STS_ERROR;
9529: l_to_status_flag := 'N';
9530: END IF;
9531:

Line 9543: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NULL_SUMMARY');

9539: NULL;
9540: ELSIF p_summary IS NOT NULL THEN
9541: l_summary := p_summary;
9542: ELSIF p_summary IS NULL THEN
9543: PA_UTILS.ADD_MESSAGE('PA', 'PA_CI_NULL_SUMMARY');
9544: x_return_status := FND_API.G_RET_STS_ERROR;
9545: END IF;
9546:
9547: IF p_description = G_PA_MISS_CHAR THEN

Line 9561: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9557: l_owner_id := l_curr_owner_id;
9558: ELSIF p_owner_id IS NOT NULL THEN
9559: l_owner_id := p_owner_id;
9560: IF (l_owner_id = l_curr_owner_id) then
9561: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9562: ,p_msg_name => 'PA_CI_CHANGE_OWNER_INVALID');
9563: x_return_status := 'E';
9564:
9565: ELSIF (l_owner_id <> l_curr_owner_id) then

Line 9568: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9564:
9565: ELSIF (l_owner_id <> l_curr_owner_id) then
9566: l_chgowner_allowed := pa_ci_security_pkg.check_change_owner_access(p_ci_id);
9567: IF (l_chgowner_allowed <> 'T') then
9568: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9569: ,p_msg_name => 'PA_CI_OWNER_CHG_NOT_ALLOWED');
9570: x_return_status := 'E';
9571: else
9572: l_to_owner_allowed := pa_ci_security_pkg.is_to_owner_allowed(p_ci_id, l_owner_id);

Line 9574: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9570: x_return_status := 'E';
9571: else
9572: l_to_owner_allowed := pa_ci_security_pkg.is_to_owner_allowed(p_ci_id, l_owner_id);
9573: if (l_to_owner_allowed <> 'T') then
9574: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9575: ,p_msg_name => 'PA_CI_TO_OWNER_NOT_ALLOWED');
9576: x_return_status := 'E';
9577: else
9578:

Line 9583: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9579: /*get the Passed owner names*/
9580: OPEN c_get_owner(l_owner_id,l_project_id);
9581: FETCH c_get_owner into l_owner_name;
9582: if (c_get_owner%notfound) then
9583: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9584: ,p_msg_name => 'PA_CI_CHANGE_OWNER_INVALID');
9585: x_return_status := 'E';
9586: end if;
9587: close c_get_owner;

Line 9593: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9589: /*Get the Current Owner name*/
9590: OPEN c_get_owner(l_curr_owner_id,l_project_id);
9591: FETCH c_get_owner into l_curr_owner_name;
9592: if (c_get_owner%notfound) then
9593: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9594: ,p_msg_name => 'PA_CI_CHANGE_OWNER_INVALID');
9595: x_return_status := 'E';
9596: end if;
9597: close c_get_owner;

Line 9623: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9619: end if;
9620: ELSIF p_owner_id IS NOT NULL THEN
9621: l_owner_id := p_owner_id;
9622: IF (l_owner_id = l_curr_owner_id) then
9623: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9624: ,p_msg_name => 'PA_CI_CHANGE_OWNER_INVALID');
9625: x_return_status := 'E';
9626: END IF;
9627: /* Getting validated in pa_control_items_pub.update_control_item API. */

Line 9629: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9625: x_return_status := 'E';
9626: END IF;
9627: /* Getting validated in pa_control_items_pub.update_control_item API. */
9628: ELSIF p_owner_id IS NULL THEN
9629: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9630: ,p_msg_name => 'PA_CI_OWNER_NULL');
9631: x_return_status := FND_API.G_RET_STS_ERROR;
9632: END IF;
9633:

Line 9641: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9637: OPEN c_classification (l_ci_type_id, p_classification_code);
9638: FETCH c_classification INTO l_classification_code_id;
9639: IF c_classification%NOTFOUND then
9640: -- close c_classification;
9641: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9642: ,p_msg_name => 'PA_CI_CLASSIFICATION_INV');
9643: x_return_status := FND_API.G_RET_STS_ERROR;
9644: END IF;
9645: close c_classification;

Line 9647: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9643: x_return_status := FND_API.G_RET_STS_ERROR;
9644: END IF;
9645: close c_classification;
9646: ELSIF p_classification_code IS NULL THEN
9647: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9648: ,p_msg_name => 'PA_CI_CLASSIFICATION_NULL');
9649: x_return_status := FND_API.G_RET_STS_ERROR;
9650: END IF;
9651:

Line 9659: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9655: OPEN c_reason (l_ci_type_id, p_reason_code);
9656: FETCH c_reason INTO l_reason_code_id;
9657: IF c_reason%NOTFOUND then
9658: -- close c_reason;
9659: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9660: ,p_msg_name => 'PA_CI_REASON_INV');
9661: x_return_status := FND_API.G_RET_STS_ERROR;
9662: END IF;
9663: close c_reason;

Line 9665: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9661: x_return_status := FND_API.G_RET_STS_ERROR;
9662: END IF;
9663: close c_reason;
9664: ELSIF p_reason_code IS NULL THEN
9665: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9666: ,p_msg_name => 'PA_CI_REASON_NULL');
9667: x_return_status := FND_API.G_RET_STS_ERROR;
9668: END IF;
9669:

Line 9682: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9678: WHERE project_id = l_project_id
9679: AND proj_element_id = p_object_id;
9680:
9681: EXCEPTION WHEN TOO_MANY_ROWS THEN
9682: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9683: ,p_msg_name => 'PA_OBJECT_NAME_MULTIPLE');
9684: x_return_status := FND_API.G_RET_STS_ERROR;
9685:
9686: WHEN OTHERS THEN

Line 9687: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9683: ,p_msg_name => 'PA_OBJECT_NAME_MULTIPLE');
9684: x_return_status := FND_API.G_RET_STS_ERROR;
9685:
9686: WHEN OTHERS THEN
9687: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9688: ,p_msg_name => 'PA_OBJECT_NAME_INV');
9689: x_return_status := FND_API.G_RET_STS_ERROR;
9690: END;
9691: ELSIF p_object_id IS NULL THEN

Line 9701: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9697: ELSIF p_object_type IS NOT NULL THEN
9698: IF p_object_type = 'PA_TASKS' THEN
9699: l_object_type := p_object_type;
9700: ELSE
9701: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9702: ,p_msg_name => 'PA_OBJECT_TYPE_INV');
9703: x_return_status := FND_API.G_RET_STS_ERROR;
9704: END IF;
9705: ELSIF p_object_type IS NULL THEN

Line 9724: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9720: OPEN c_lkup(l_priority_type, p_priority_code);
9721: FETCH c_lkup INTO l_priority_code;
9722: IF c_lkup%NOTFOUND then
9723: -- close c_lkup;
9724: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9725: ,p_msg_name => 'PA_CI_PRIORITY_INV');
9726: x_return_status := FND_API.G_RET_STS_ERROR;
9727: END IF;
9728: close c_lkup;

Line 9740: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9736: OPEN c_lkup(l_effort_type, p_effort_level_code);
9737: FETCH c_lkup INTO l_effort_level_code;
9738: IF c_lkup%NOTFOUND then
9739: -- close c_lkup;
9740: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9741: ,p_msg_name => 'PA_CI_EFFORT_INV');
9742: x_return_status := FND_API.G_RET_STS_ERROR;
9743: END IF;
9744: close c_lkup;

Line 9773: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9769: OPEN c_lkup(l_source_type, p_source_type_code);
9770: FETCH c_lkup INTO l_source_type_code;
9771: IF c_lkup%NOTFOUND then
9772: -- close c_lkup;
9773: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9774: ,p_msg_name => 'PA_CI_SOURCE_TYPE_INV');
9775: x_return_status := FND_API.G_RET_STS_ERROR;
9776: END IF;
9777: close c_lkup;

Line 9817: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9813: NULL;
9814: ELSIF p_progress_as_of_date IS NOT NULL THEN
9815: l_progress_as_of_date := p_progress_as_of_date;
9816: ELSIF p_progress_as_of_date IS NULL THEN
9817: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9818: ,p_msg_name => 'PA_AS_OF_DATE_NULL');
9819: x_return_status := FND_API.G_RET_STS_ERROR;
9820: END IF;
9821:

Line 9837: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9833:
9834: IF p_ci_number = G_PA_MISS_CHAR THEN
9835: IF l_ci_number IS NULL THEN
9836: IF (l_curr_system_status = 'CI_DRAFT' AND (l_new_system_status IS NOT NULL AND l_new_system_status <> 'CI_DRAFT')) THEN
9837: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9838: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
9839: x_return_status := FND_API.G_RET_STS_ERROR;
9840: ELSIF l_curr_system_status <> 'CI_DRAFT' THEN
9841: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 9841: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9837: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9838: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
9839: x_return_status := FND_API.G_RET_STS_ERROR;
9840: ELSIF l_curr_system_status <> 'CI_DRAFT' THEN
9841: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9842: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
9843: x_return_status := FND_API.G_RET_STS_ERROR;
9844: END IF;
9845: END IF;

Line 9848: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9844: END IF;
9845: END IF;
9846: ELSIF p_ci_number IS NULL THEN
9847: IF (l_curr_system_status = 'CI_DRAFT' AND (l_new_system_status IS NOT NULL AND l_new_system_status <> 'CI_DRAFT')) THEN
9848: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9849: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
9850: x_return_status := FND_API.G_RET_STS_ERROR;
9851: ELSIF l_curr_system_status <> 'CI_DRAFT' THEN
9852: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 9852: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9848: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9849: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
9850: x_return_status := FND_API.G_RET_STS_ERROR;
9851: ELSIF l_curr_system_status <> 'CI_DRAFT' THEN
9852: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9853: ,p_msg_name => 'PA_CI_NO_CI_NUMBER');
9854: x_return_status := FND_API.G_RET_STS_ERROR;
9855: END IF;
9856: END IF;

Line 9867: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9863: IF (c_ci_number%NOTFOUND) then
9864: CLOSE c_ci_number;
9865: ELSE
9866: CLOSE c_ci_number;
9867: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9868: ,p_msg_name => 'PA_CI_DUPLICATE_CI_NUMBER');
9869: x_return_status := FND_API.G_RET_STS_ERROR;
9870: END IF;
9871: END IF;

Line 9883: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9879: OPEN c_statuses(l_progress_type, p_progress_status_code);
9880: FETCH c_statuses INTO l_progress_status_code;
9881: IF c_statuses%NOTFOUND then
9882: close c_statuses;
9883: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9884: ,p_msg_name => 'PA_PROGRESS_STATUS_INV');
9885: x_return_status := FND_API.G_RET_STS_ERROR;
9886: END IF;
9887: close c_statuses;

Line 9889: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9885: x_return_status := FND_API.G_RET_STS_ERROR;
9886: END IF;
9887: close c_statuses;
9888: ELSIF p_progress_status_code IS NULL THEN
9889: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9890: ,p_msg_name => 'PA_PROGRESS_STATUS_NULL');
9891: x_return_status := FND_API.G_RET_STS_ERROR;
9892: END IF;
9893:

Line 9907: PA_UTILS.Add_Message( p_app_short_name => 'PA'

9903: OPEN c_resolution (l_ci_type_id, p_resolution_code);
9904: FETCH c_resolution INTO l_resolution_code_id;
9905: IF c_resolution%NOTFOUND then
9906: close c_resolution;
9907: PA_UTILS.Add_Message( p_app_short_name => 'PA'
9908: ,p_msg_name => 'PA_CI_RESOLUTION_INV');
9909: x_return_status := FND_API.G_RET_STS_ERROR;
9910: END IF;
9911: close c_resolution;

Line 10066: PA_UTILS.Add_Message( p_app_short_name => 'PA'

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;
10069: END IF;
10070: ELSE

Line 10072: PA_UTILS.Add_Message( p_app_short_name => 'PA'

10068: x_return_status := FND_API.G_RET_STS_ERROR;
10069: END IF;
10070: ELSE
10071: IF (l_resolution_code_id IS NULL) THEN
10072: PA_UTILS.Add_Message( p_app_short_name => 'PA'
10073: ,p_msg_name => 'PA_CI_RESOLUTION_OPEN');
10074: x_return_status := FND_API.G_RET_STS_ERROR;
10075: END IF;
10076: END IF;

Line 10082: PA_UTILS.Add_Message( p_app_short_name => 'PA'

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;
10085: END IF;
10086: ELSE

Line 10088: PA_UTILS.Add_Message( p_app_short_name => 'PA'

10084: x_return_status := FND_API.G_RET_STS_ERROR;
10085: END IF;
10086: ELSE
10087: IF (l_resolution_code_id IS NULL) THEN
10088: PA_UTILS.Add_Message( p_app_short_name => 'PA'
10089: ,p_msg_name => 'PA_CI_CLOSE_INV_RES');
10090: x_return_status := FND_API.G_RET_STS_ERROR;
10091: END IF;
10092: END IF;