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_RESOURCE_PUB dependencies on FND_MSG_PUB

Line 139: FND_MSG_PUB.ADD;

135: RAISE FND_API.G_EXC_ERROR;
136: END IF;
137: IF l_function_allowed = 'N' THEN
138: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
139: FND_MSG_PUB.ADD;
140: p_resource_list_out_rec.return_status:= FND_API.G_RET_STS_ERROR;
141: p_return_status := FND_API.g_ret_sts_error;
142: RAISE FND_API.G_EXC_ERROR;
143: END IF;

Line 167: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

163: p_err_stack => l_err_stack
164: );
165:
166: IF l_err_code > 0 THEN
167: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
168: THEN
169: IF NOT pa_project_pvt.check_valid_message (l_err_stage) THEN
170: FND_MESSAGE.SET_NAME ('PA','PA_ERR_IN_RES_LIST_CREATION');
171: ELSE

Line 174: FND_MSG_PUB.ADD;

170: FND_MESSAGE.SET_NAME ('PA','PA_ERR_IN_RES_LIST_CREATION');
171: ELSE
172: FND_MESSAGE.SET_NAME('PA',l_err_stage);
173: END IF;
174: FND_MSG_PUB.ADD;
175: END IF;
176: RAISE FND_API.G_EXC_ERROR;
177: END IF;
178: IF l_err_code < 0 THEN

Line 179: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

175: END IF;
176: RAISE FND_API.G_EXC_ERROR;
177: END IF;
178: IF l_err_code < 0 THEN
179: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
180: THEN
181: FND_MSG_PUB.Add_Exc_Msg
182: ( p_pkg_name => 'G_PKG_NAME'
183: , p_procedure_name => 'CREATE_RESOURCE_LIST'

Line 181: FND_MSG_PUB.Add_Exc_Msg

177: END IF;
178: IF l_err_code < 0 THEN
179: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
180: THEN
181: FND_MSG_PUB.Add_Exc_Msg
182: ( p_pkg_name => 'G_PKG_NAME'
183: , p_procedure_name => 'CREATE_RESOURCE_LIST'
184: , p_error_text => 'ORA-'||LPAD(SUBSTR(l_err_code, 2), 5, '0')
185: );

Line 224: FND_MSG_PUB.Count_And_Get

220: WHEN FND_API.G_EXC_ERROR THEN
221: p_return_status := FND_API.G_RET_STS_ERROR ;
222: ROLLBACK TO Create_Resource_List_Pub;
223:
224: FND_MSG_PUB.Count_And_Get
225: ( p_count => p_msg_count ,
226: p_data => p_msg_data );
227:
228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 232: FND_MSG_PUB.Count_And_Get

228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
229: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: ROLLBACK TO Create_Resource_List_Pub;
231:
232: FND_MSG_PUB.Count_And_Get
233: ( p_count => p_msg_count ,
234: p_data => p_msg_data );
235:
236: WHEN OTHERS THEN

Line 239: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

235:
236: WHEN OTHERS THEN
237: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: ROLLBACK TO Create_Resource_List_Pub;
239: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
240:
241: FND_MSG_PUB.Add_Exc_Msg
242: ( p_pkg_name => G_PKG_NAME ,
243: p_procedure_name => l_api_name

Line 241: FND_MSG_PUB.Add_Exc_Msg

237: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: ROLLBACK TO Create_Resource_List_Pub;
239: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
240:
241: FND_MSG_PUB.Add_Exc_Msg
242: ( p_pkg_name => G_PKG_NAME ,
243: p_procedure_name => l_api_name
244: );
245:

Line 248: FND_MSG_PUB.Count_And_Get

244: );
245:
246: END IF;
247:
248: FND_MSG_PUB.Count_And_Get
249: ( p_count => p_msg_count ,
250: p_data => p_msg_data );
251:
252: END Create_Resource_List;

Line 349: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

345: p_err_stack => l_err_stack,
346: p_return_status => l_return_status );
347:
348: IF l_err_code > 0 THEN
349: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
350: THEN
351: IF NOT pa_project_pvt.check_valid_message (l_err_stage) THEN
352: FND_MESSAGE.SET_NAME ('PA','PA_ERR_IN_RL_MEMB_CREATION');
353: ELSE

Line 356: FND_MSG_PUB.ADD;

352: FND_MESSAGE.SET_NAME ('PA','PA_ERR_IN_RL_MEMB_CREATION');
353: ELSE
354: FND_MESSAGE.SET_NAME('PA',l_err_stage);
355: END IF;
356: FND_MSG_PUB.ADD;
357: END IF;
358: RAISE FND_API.G_EXC_ERROR;
359:
360: ELSIF

Line 362: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

358: RAISE FND_API.G_EXC_ERROR;
359:
360: ELSIF
361: l_err_code < 0 THEN
362: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
363: THEN
364: FND_MSG_PUB.Add_Exc_Msg
365: ( p_pkg_name => 'G_PKG_NAME'
366: , p_procedure_name => 'PROCESS_MEMBERS'

Line 364: FND_MSG_PUB.Add_Exc_Msg

360: ELSIF
361: l_err_code < 0 THEN
362: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
363: THEN
364: FND_MSG_PUB.Add_Exc_Msg
365: ( p_pkg_name => 'G_PKG_NAME'
366: , p_procedure_name => 'PROCESS_MEMBERS'
367: , p_error_text => 'ORA-'||LPAD(SUBSTR(l_err_code, 2), 5, '0')
368: );

Line 388: FND_MSG_PUB.Count_And_Get

384:
385: p_return_status := FND_API.G_RET_STS_ERROR ;
386: ROLLBACK TO Process_Members_Pub;
387:
388: FND_MSG_PUB.Count_And_Get
389: ( p_count => p_msg_count ,
390: p_data => p_msg_data );
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 397: FND_MSG_PUB.Count_And_Get

393:
394: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
395: ROLLBACK TO Process_Members_Pub;
396:
397: FND_MSG_PUB.Count_And_Get
398: ( p_count => p_msg_count ,
399: p_data => p_msg_data );
400:
401: WHEN OTHERS THEN

Line 406: IF FND_MSG_PUB.Check_Msg_Level

402:
403: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
404: ROLLBACK TO Process_Members_Pub;
405:
406: IF FND_MSG_PUB.Check_Msg_Level
407: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
408:
409: FND_MSG_PUB.Add_Exc_Msg
410: ( p_pkg_name => G_PKG_NAME ,

Line 407: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

403: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
404: ROLLBACK TO Process_Members_Pub;
405:
406: IF FND_MSG_PUB.Check_Msg_Level
407: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
408:
409: FND_MSG_PUB.Add_Exc_Msg
410: ( p_pkg_name => G_PKG_NAME ,
411: p_procedure_name => l_api_name

Line 409: FND_MSG_PUB.Add_Exc_Msg

405:
406: IF FND_MSG_PUB.Check_Msg_Level
407: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
408:
409: FND_MSG_PUB.Add_Exc_Msg
410: ( p_pkg_name => G_PKG_NAME ,
411: p_procedure_name => l_api_name
412: );
413:

Line 416: FND_MSG_PUB.Count_And_Get

412: );
413:
414: END IF;
415:
416: FND_MSG_PUB.Count_And_Get
417: ( p_count => p_msg_count ,
418: p_data => p_msg_data );
419:
420: END Process_Members;

Line 488: FND_MSG_PUB.ADD;

484:
485: IF ((p_resource_alias IS NULL ) OR
486: (p_resource_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR)) THEN
487: FND_MESSAGE.SET_NAME('PA','PA_NEW_ALIAS_IS_INVALID ');
488: FND_MSG_PUB.ADD;
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;
491:
492: l_person_id := NULL;

Line 547: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

543: END IF;
544: OPEN l_org_csr;
545: FETCH l_org_csr INTO l_proj_organization_id;
546: IF l_org_csr%NOTFOUND THEN
547: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
548: THEN
549: FND_MESSAGE.SET_NAME('PA','PA_INVALID_ORGANIZATION');
550: FND_MSG_PUB.ADD;
551: END IF;

Line 550: FND_MSG_PUB.ADD;

546: IF l_org_csr%NOTFOUND THEN
547: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
548: THEN
549: FND_MESSAGE.SET_NAME('PA','PA_INVALID_ORGANIZATION');
550: FND_MSG_PUB.ADD;
551: END IF;
552: CLOSE l_org_csr;
553: RAISE FND_API.G_EXC_ERROR;
554: ELSE

Line 619: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

615: END IF;
616:
617: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
618:
619: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
620: FND_MSG_PUB.Add_Exc_Msg
621: ( p_pkg_name => G_PKG_NAME ,
622: p_procedure_name => l_api_name
623: );

Line 620: FND_MSG_PUB.Add_Exc_Msg

616:
617: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
618:
619: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
620: FND_MSG_PUB.Add_Exc_Msg
621: ( p_pkg_name => G_PKG_NAME ,
622: p_procedure_name => l_api_name
623: );
624: END IF;

Line 650: FND_MSG_PUB.initialize;

646:
647: l_api_name CONSTANT VARCHAR2(30) := 'Init_Create_Resource_List';
648:
649: BEGIN
650: FND_MSG_PUB.initialize;
651:
652: -- Initialize Resource List Globals
653: g_resource_list_rec := g_miss_resource_list_rec;
654: g_resource_list_out_rec := g_miss_resource_list_out_rec;

Line 670: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

666: EXCEPTION
667:
668: WHEN OTHERS THEN
669:
670: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
671: FND_MSG_PUB.Add_Exc_Msg
672: ( p_pkg_name => G_PKG_NAME ,
673: p_procedure_name => l_api_name
674: );

Line 671: FND_MSG_PUB.Add_Exc_Msg

667:
668: WHEN OTHERS THEN
669:
670: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
671: FND_MSG_PUB.Add_Exc_Msg
672: ( p_pkg_name => G_PKG_NAME ,
673: p_procedure_name => l_api_name
674: );
675: END IF;

Line 745: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

741: WHEN OTHERS THEN
742:
743: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
744:
745: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
746: FND_MSG_PUB.Add_Exc_Msg
747: ( p_pkg_name => G_PKG_NAME ,
748: p_procedure_name => l_api_name
749: );

Line 746: FND_MSG_PUB.Add_Exc_Msg

742:
743: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
744:
745: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
746: FND_MSG_PUB.Add_Exc_Msg
747: ( p_pkg_name => G_PKG_NAME ,
748: p_procedure_name => l_api_name
749: );
750: END IF;

Line 855: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

851: WHEN OTHERS THEN
852:
853: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
854:
855: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
856: FND_MSG_PUB.Add_Exc_Msg
857: ( p_pkg_name => G_PKG_NAME ,
858: p_procedure_name => l_api_name
859: );

Line 856: FND_MSG_PUB.Add_Exc_Msg

852:
853: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
854:
855: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
856: FND_MSG_PUB.Add_Exc_Msg
857: ( p_pkg_name => G_PKG_NAME ,
858: p_procedure_name => l_api_name
859: );
860: END IF;

Line 931: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

927: WHEN OTHERS THEN
928:
929: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
930:
931: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
932: FND_MSG_PUB.Add_Exc_Msg
933: ( p_pkg_name => G_PKG_NAME ,
934: p_procedure_name => l_api_name
935: );

Line 932: FND_MSG_PUB.Add_Exc_Msg

928:
929: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
930:
931: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
932: FND_MSG_PUB.Add_Exc_Msg
933: ( p_pkg_name => G_PKG_NAME ,
934: p_procedure_name => l_api_name
935: );
936: END IF;

Line 938: FND_MSG_PUB.Count_And_Get

934: p_procedure_name => l_api_name
935: );
936: END IF;
937:
938: FND_MSG_PUB.Count_And_Get
939: ( p_count => p_msg_count ,
940: p_data => p_msg_data );
941:
942:

Line 1002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

998: WHEN OTHERS THEN
999:
1000: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1001:
1002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1003: FND_MSG_PUB.Add_Exc_Msg
1004: ( p_pkg_name => G_PKG_NAME ,
1005: p_procedure_name => l_api_name
1006: );

Line 1003: FND_MSG_PUB.Add_Exc_Msg

999:
1000: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1001:
1002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1003: FND_MSG_PUB.Add_Exc_Msg
1004: ( p_pkg_name => G_PKG_NAME ,
1005: p_procedure_name => l_api_name
1006: );
1007: END IF;

Line 1084: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1080: WHEN OTHERS THEN
1081:
1082: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1083:
1084: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1085: FND_MSG_PUB.Add_Exc_Msg
1086: ( p_pkg_name => G_PKG_NAME ,
1087: p_procedure_name => l_api_name
1088: );

Line 1085: FND_MSG_PUB.Add_Exc_Msg

1081:
1082: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1083:
1084: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1085: FND_MSG_PUB.Add_Exc_Msg
1086: ( p_pkg_name => G_PKG_NAME ,
1087: p_procedure_name => l_api_name
1088: );
1089: END IF;

Line 1278: FND_MSG_PUB.ADD;

1274: RAISE FND_API.G_EXC_ERROR;
1275: END IF;
1276: IF l_function_allowed = 'N' THEN
1277: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
1278: FND_MSG_PUB.ADD;
1279: p_return_status := FND_API.g_ret_sts_error;
1280: RAISE FND_API.G_EXC_ERROR;
1281: END IF;
1282:

Line 1285: FND_MSG_PUB.initialize;

1281: END IF;
1282:
1283: IF FND_API.to_boolean( p_init_msg_list )
1284: THEN
1285: FND_MSG_PUB.initialize;
1286: END IF;
1287:
1288: -- -----------------------------------------------------------------------
1289: -- Resource List HEADER

Line 1319: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1315: -- If a start date and end date are passed, then the start date must be not be later than the end date.
1316:
1317: IF ((p_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)) THEN
1318: IF (p_start_date IS NULL) THEN
1319: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1320: THEN
1321: FND_MESSAGE.SET_NAME('PA','PA_INVALID_START_DATE');
1322: FND_MSG_PUB.ADD;
1323: END IF;

Line 1322: FND_MSG_PUB.ADD;

1318: IF (p_start_date IS NULL) THEN
1319: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1320: THEN
1321: FND_MESSAGE.SET_NAME('PA','PA_INVALID_START_DATE');
1322: FND_MSG_PUB.ADD;
1323: END IF;
1324: RAISE FND_API.G_EXC_ERROR;
1325: ELSIF ((p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1326: AND (p_end_date IS NOT NULL)) THEN

Line 1329: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1325: ELSIF ((p_end_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE)
1326: AND (p_end_date IS NOT NULL)) THEN
1327: IF (p_start_date > p_end_date)
1328: THEN
1329: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1330: THEN
1331: FND_MESSAGE.SET_NAME('PA','PA_INVALID_START_DATE');
1332: FND_MSG_PUB.ADD;
1333: END IF;

Line 1332: FND_MSG_PUB.ADD;

1328: THEN
1329: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1330: THEN
1331: FND_MESSAGE.SET_NAME('PA','PA_INVALID_START_DATE');
1332: FND_MSG_PUB.ADD;
1333: END IF;
1334: RAISE FND_API.G_EXC_ERROR;
1335: END IF;
1336: END IF;

Line 1345: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1341:
1342: -- New List Name Must NOT Be Null
1343:
1344: IF (p_new_list_name IS NULL) THEN
1345: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1346: THEN
1347: FND_MESSAGE.SET_NAME('PA', 'PA_NEW_RES_LIST_NO_NULL');
1348: FND_MSG_PUB.ADD;
1349: END IF;

Line 1348: FND_MSG_PUB.ADD;

1344: IF (p_new_list_name IS NULL) THEN
1345: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1346: THEN
1347: FND_MESSAGE.SET_NAME('PA', 'PA_NEW_RES_LIST_NO_NULL');
1348: FND_MSG_PUB.ADD;
1349: END IF;
1350: RAISE FND_API.G_EXC_ERROR;
1351: END IF;
1352:

Line 1359: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1355: IF (p_new_list_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1356: OPEN l_new_list_name_csr (p_new_list_name);
1357: FETCH l_new_list_name_csr INTO l_dummy;
1358: IF (l_new_list_name_csr %FOUND) THEN
1359: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1360: THEN
1361: FND_MESSAGE.SET_NAME('PA', 'PA_RE_RL_UNIQUE');
1362: FND_MSG_PUB.ADD;
1363: END IF;

Line 1362: FND_MSG_PUB.ADD;

1358: IF (l_new_list_name_csr %FOUND) THEN
1359: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1360: THEN
1361: FND_MESSAGE.SET_NAME('PA', 'PA_RE_RL_UNIQUE');
1362: FND_MSG_PUB.ADD;
1363: END IF;
1364: CLOSE l_new_list_name_csr;
1365: RAISE FND_API.G_EXC_ERROR;
1366: ELSE

Line 1377: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1373: IF (p_grouped_by_type <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
1374: OPEN l_grouped_by_type_csr ( l_resource_list_id);
1375: FETCH l_grouped_by_type_csr INTO l_dummy;
1376: IF (l_grouped_by_type_csr%FOUND) THEN
1377: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1378: THEN
1379: FND_MESSAGE.SET_NAME('PA', 'PA_NO_CHANGE_GROUP_BY_TYPE');
1380: FND_MSG_PUB.ADD;
1381: END IF;

Line 1380: FND_MSG_PUB.ADD;

1376: IF (l_grouped_by_type_csr%FOUND) THEN
1377: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1378: THEN
1379: FND_MESSAGE.SET_NAME('PA', 'PA_NO_CHANGE_GROUP_BY_TYPE');
1380: FND_MSG_PUB.ADD;
1381: END IF;
1382: CLOSE l_grouped_by_type_csr;
1383: RAISE FND_API.G_EXC_ERROR;
1384: ELSE

Line 1399: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1395: ELSE
1396: OPEN l_resource_type_csr (p_grouped_by_type);
1397: FETCH l_resource_type_csr INTO l_resource_type_id;
1398: IF (l_resource_type_csr%NOTFOUND) THEN
1399: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1400: THEN
1401: FND_MESSAGE.SET_NAME('PA', 'PA_GROUPED_RT_INVALID');
1402: FND_MSG_PUB.ADD;
1403: END IF;

Line 1402: FND_MSG_PUB.ADD;

1398: IF (l_resource_type_csr%NOTFOUND) THEN
1399: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1400: THEN
1401: FND_MESSAGE.SET_NAME('PA', 'PA_GROUPED_RT_INVALID');
1402: FND_MSG_PUB.ADD;
1403: END IF;
1404: CLOSE l_resource_type_csr;
1405: RAISE FND_API.G_EXC_ERROR;
1406: ELSE

Line 1431: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1427: (l_end_date_active_old IS NOT NULL))
1428: THEN
1429: IF (p_start_date > l_end_date_active_old)
1430: THEN
1431: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1432: THEN
1433: FND_MESSAGE.SET_NAME('PA','PA_INVALID_START_DATE');
1434: FND_MSG_PUB.ADD;
1435: END IF;

Line 1434: FND_MSG_PUB.ADD;

1430: THEN
1431: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1432: THEN
1433: FND_MESSAGE.SET_NAME('PA','PA_INVALID_START_DATE');
1434: FND_MSG_PUB.ADD;
1435: END IF;
1436: RAISE FND_API.G_EXC_ERROR;
1437: END IF;
1438: END IF;

Line 1447: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1443: AND (p_end_date IS NOT NULL))
1444: THEN
1445: IF (l_start_date_active_old > p_end_date)
1446: THEN
1447: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1448: THEN
1449: FND_MESSAGE.SET_NAME('PA','PA_INVALID_END_DATE');
1450: FND_MSG_PUB.ADD;
1451: END IF;

Line 1450: FND_MSG_PUB.ADD;

1446: THEN
1447: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1448: THEN
1449: FND_MESSAGE.SET_NAME('PA','PA_INVALID_END_DATE');
1450: FND_MSG_PUB.ADD;
1451: END IF;
1452: RAISE FND_API.G_EXC_ERROR;
1453: END IF;
1454: END IF;

Line 1670: FND_MSG_PUB.Count_And_Get

1666:
1667: p_return_status := FND_API.G_RET_STS_ERROR ;
1668: ROLLBACK TO Update_Resource_List_Pub;
1669:
1670: FND_MSG_PUB.Count_And_Get
1671: ( p_count => p_msg_count ,
1672: p_data => p_msg_data );
1673:
1674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1679: FND_MSG_PUB.Count_And_Get

1675:
1676: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1677: ROLLBACK TO Update_Resource_List_Pub;
1678:
1679: FND_MSG_PUB.Count_And_Get
1680: ( p_count => p_msg_count ,
1681: p_data => p_msg_data );
1682:
1683: WHEN ROW_ALREADY_LOCKED THEN

Line 1686: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1682:
1683: WHEN ROW_ALREADY_LOCKED THEN
1684:
1685: p_return_status := FND_API.G_RET_STS_ERROR ;
1686: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1687: THEN
1688: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
1689: FND_MESSAGE.SET_TOKEN('ENTITY', 'RESOURCE_LIST');
1690: FND_MSG_PUB.ADD;

Line 1690: FND_MSG_PUB.ADD;

1686: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1687: THEN
1688: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
1689: FND_MESSAGE.SET_TOKEN('ENTITY', 'RESOURCE_LIST');
1690: FND_MSG_PUB.ADD;
1691: END IF;
1692:
1693: ROLLBACK TO Update_Resource_List_Mbr_Pub;
1694:

Line 1695: FND_MSG_PUB.Count_And_Get

1691: END IF;
1692:
1693: ROLLBACK TO Update_Resource_List_Mbr_Pub;
1694:
1695: FND_MSG_PUB.Count_And_Get
1696: ( p_count => p_msg_count ,
1697: p_data => p_msg_data );
1698:
1699:

Line 1705: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1701:
1702: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1703: ROLLBACK TO Update_Resource_List_Pub;
1704:
1705: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1706:
1707: FND_MSG_PUB.Add_Exc_Msg
1708: ( p_pkg_name => G_PKG_NAME ,
1709: p_procedure_name => l_api_name

Line 1707: FND_MSG_PUB.Add_Exc_Msg

1703: ROLLBACK TO Update_Resource_List_Pub;
1704:
1705: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1706:
1707: FND_MSG_PUB.Add_Exc_Msg
1708: ( p_pkg_name => G_PKG_NAME ,
1709: p_procedure_name => l_api_name
1710: );
1711:

Line 1714: FND_MSG_PUB.Count_And_Get

1710: );
1711:
1712: END IF;
1713:
1714: FND_MSG_PUB.Count_And_Get
1715: ( p_count => p_msg_count ,
1716: p_data => p_msg_data );
1717:
1718: END Update_Resource_List;

Line 1749: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1745: EXCEPTION
1746:
1747: WHEN OTHERS THEN
1748:
1749: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1750: FND_MSG_PUB.Add_Exc_Msg
1751: ( p_pkg_name => G_PKG_NAME ,
1752: p_procedure_name => l_api_name
1753: );

Line 1750: FND_MSG_PUB.Add_Exc_Msg

1746:
1747: WHEN OTHERS THEN
1748:
1749: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1750: FND_MSG_PUB.Add_Exc_Msg
1751: ( p_pkg_name => G_PKG_NAME ,
1752: p_procedure_name => l_api_name
1753: );
1754: END IF;

Line 1829: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1825: WHEN OTHERS THEN
1826:
1827: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1828:
1829: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1830: FND_MSG_PUB.Add_Exc_Msg
1831: ( p_pkg_name => G_PKG_NAME ,
1832: p_procedure_name => l_api_name
1833: );

Line 1830: FND_MSG_PUB.Add_Exc_Msg

1826:
1827: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1828:
1829: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1830: FND_MSG_PUB.Add_Exc_Msg
1831: ( p_pkg_name => G_PKG_NAME ,
1832: p_procedure_name => l_api_name
1833: );
1834: END IF;

Line 1836: FND_MSG_PUB.Count_And_Get

1832: p_procedure_name => l_api_name
1833: );
1834: END IF;
1835:
1836: FND_MSG_PUB.Count_And_Get
1837: ( p_count => p_msg_count ,
1838: p_data => p_msg_data );
1839:
1840: END Exec_Update_Resource_List;

Line 1951: FND_MSG_PUB.ADD;

1947: RAISE FND_API.G_EXC_ERROR;
1948: END IF;
1949: IF l_function_allowed = 'N' THEN
1950: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
1951: FND_MSG_PUB.ADD;
1952: p_return_status := FND_API.g_ret_sts_error;
1953: RAISE FND_API.G_EXC_ERROR;
1954: END IF;
1955:

Line 1958: FND_MSG_PUB.initialize;

1954: END IF;
1955:
1956: IF FND_API.to_boolean( p_init_msg_list )
1957: THEN
1958: FND_MSG_PUB.initialize;
1959: END IF;
1960:
1961: p_return_status := FND_API.G_RET_STS_SUCCESS;
1962:

Line 1988: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1984: l_resource_list_id => l_resource_list_id,
1985: x_err_code => x_err_code,
1986: x_err_stage => x_err_stage);
1987: IF x_err_code <> 0 THEN
1988: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1989: FND_MESSAGE.SET_NAME('PA', x_err_stage);
1990: FND_MSG_PUB.ADD;
1991: END IF;
1992: RAISE FND_API.G_EXC_ERROR;

Line 1990: FND_MSG_PUB.ADD;

1986: x_err_stage => x_err_stage);
1987: IF x_err_code <> 0 THEN
1988: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1989: FND_MESSAGE.SET_NAME('PA', x_err_stage);
1990: FND_MSG_PUB.ADD;
1991: END IF;
1992: RAISE FND_API.G_EXC_ERROR;
1993: END IF;
1994:

Line 2016: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2012:
2013: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2014: ROLLBACK TO Delete_Resource_List_Pub;
2015:
2016: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2017: THEN
2018: FND_MESSAGE.SET_NAME('PA','PA_RL_MEMBER_DELETE_ERROR');
2019: FND_MSG_PUB.ADD;
2020: END IF;

Line 2019: FND_MSG_PUB.ADD;

2015:
2016: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2017: THEN
2018: FND_MESSAGE.SET_NAME('PA','PA_RL_MEMBER_DELETE_ERROR');
2019: FND_MSG_PUB.ADD;
2020: END IF;
2021:
2022: FND_MSG_PUB.Count_And_Get
2023: ( p_count => p_msg_count ,

Line 2022: FND_MSG_PUB.Count_And_Get

2018: FND_MESSAGE.SET_NAME('PA','PA_RL_MEMBER_DELETE_ERROR');
2019: FND_MSG_PUB.ADD;
2020: END IF;
2021:
2022: FND_MSG_PUB.Count_And_Get
2023: ( p_count => p_msg_count ,
2024: p_data => p_msg_data );
2025:
2026: END;

Line 2048: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2044:
2045: p_return_status := FND_API.G_RET_STS_ERROR ;
2046: ROLLBACK TO Delete_Resource_List_Pub;
2047:
2048: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2049: THEN
2050: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
2051: FND_MESSAGE.SET_TOKEN('ENTITY', 'RESOURCE_LIST');
2052: FND_MSG_PUB.ADD;

Line 2052: FND_MSG_PUB.ADD;

2048: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2049: THEN
2050: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
2051: FND_MESSAGE.SET_TOKEN('ENTITY', 'RESOURCE_LIST');
2052: FND_MSG_PUB.ADD;
2053: END IF;
2054:
2055: FND_MSG_PUB.Count_And_Get
2056: ( p_count => p_msg_count ,

Line 2055: FND_MSG_PUB.Count_And_Get

2051: FND_MESSAGE.SET_TOKEN('ENTITY', 'RESOURCE_LIST');
2052: FND_MSG_PUB.ADD;
2053: END IF;
2054:
2055: FND_MSG_PUB.Count_And_Get
2056: ( p_count => p_msg_count ,
2057: p_data => p_msg_data );
2058:
2059: WHEN OTHERS THEN

Line 2064: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2060:
2061: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2062: ROLLBACK TO Delete_Resource_List_Pub;
2063:
2064: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2065: THEN
2066: FND_MESSAGE.SET_NAME('PA','PA_RL_DELETE_ERROR');
2067: FND_MSG_PUB.ADD;
2068: END IF;

Line 2067: FND_MSG_PUB.ADD;

2063:
2064: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2065: THEN
2066: FND_MESSAGE.SET_NAME('PA','PA_RL_DELETE_ERROR');
2067: FND_MSG_PUB.ADD;
2068: END IF;
2069:
2070: FND_MSG_PUB.Count_And_Get
2071: ( p_count => p_msg_count ,

Line 2070: FND_MSG_PUB.Count_And_Get

2066: FND_MESSAGE.SET_NAME('PA','PA_RL_DELETE_ERROR');
2067: FND_MSG_PUB.ADD;
2068: END IF;
2069:
2070: FND_MSG_PUB.Count_And_Get
2071: ( p_count => p_msg_count ,
2072: p_data => p_msg_data );
2073:
2074: END;

Line 2082: FND_MSG_PUB.Count_And_Get

2078: THEN
2079: COMMIT;
2080: END IF;
2081:
2082: FND_MSG_PUB.Count_And_Get
2083: ( p_count => p_msg_count ,
2084: p_data => p_msg_data );
2085:
2086:

Line 2094: FND_MSG_PUB.Count_And_Get

2090:
2091: p_return_status := FND_API.G_RET_STS_ERROR ;
2092: ROLLBACK TO Delete_Resource_List_Pub;
2093:
2094: FND_MSG_PUB.Count_And_Get
2095: ( p_count => p_msg_count ,
2096: p_data => p_msg_data );
2097:
2098: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2103: FND_MSG_PUB.Count_And_Get

2099:
2100: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2101: ROLLBACK TO Delete_Resource_List_Pub;
2102:
2103: FND_MSG_PUB.Count_And_Get
2104: ( p_count => p_msg_count ,
2105: p_data => p_msg_data );
2106:
2107: WHEN OTHERS THEN

Line 2112: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2108:
2109: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2110: ROLLBACK TO Delete_Resource_List_Pub;
2111:
2112: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2113: FND_MSG_PUB.Add_Exc_Msg
2114: ( p_pkg_name => G_PKG_NAME ,
2115: p_procedure_name => l_api_name
2116: );

Line 2113: FND_MSG_PUB.Add_Exc_Msg

2109: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2110: ROLLBACK TO Delete_Resource_List_Pub;
2111:
2112: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2113: FND_MSG_PUB.Add_Exc_Msg
2114: ( p_pkg_name => G_PKG_NAME ,
2115: p_procedure_name => l_api_name
2116: );
2117: END IF;

Line 2119: FND_MSG_PUB.Count_And_Get

2115: p_procedure_name => l_api_name
2116: );
2117: END IF;
2118:
2119: FND_MSG_PUB.Count_And_Get
2120: ( p_count => p_msg_count ,
2121: p_data => p_msg_data );
2122:
2123:

Line 2214: FND_MSG_PUB.initialize;

2210: p_return_status := FND_API.G_RET_STS_SUCCESS;
2211:
2212: IF FND_API.to_boolean( p_init_msg_list)
2213: THEN
2214: FND_MSG_PUB.initialize;
2215: END IF;
2216:
2217: l_resp_id := FND_GLOBAL.Resp_id;
2218:

Line 2244: FND_MSG_PUB.ADD;

2240: RAISE FND_API.G_EXC_ERROR;
2241: END IF;
2242: IF l_function_allowed = 'N' THEN
2243: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
2244: FND_MSG_PUB.ADD;
2245: p_return_status := FND_API.g_ret_sts_error;
2246: RAISE FND_API.G_EXC_ERROR;
2247: END IF;
2248:

Line 2261: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2257:
2258:
2259: IF p_resource_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2260: p_resource_list_member_id := NULL;
2261: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2262: THEN
2263: FND_MESSAGE.SET_NAME('PA','PA_RL_RES_TYPE_CODE_REQD');
2264: FND_MSG_PUB.ADD;
2265: END IF;

Line 2264: FND_MSG_PUB.ADD;

2260: p_resource_list_member_id := NULL;
2261: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2262: THEN
2263: FND_MESSAGE.SET_NAME('PA','PA_RL_RES_TYPE_CODE_REQD');
2264: FND_MSG_PUB.ADD;
2265: END IF;
2266: RAISE FND_API.G_EXC_ERROR;
2267: END IF;
2268:

Line 2270: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2266: RAISE FND_API.G_EXC_ERROR;
2267: END IF;
2268:
2269: IF p_resource_attr_value = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
2270: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2271: THEN
2272: IF p_resource_type_code = 'EMPLOYEE' THEN
2273: FND_MESSAGE.SET_NAME('PA', 'PA_NO_PERSON_ID');
2274: ELSIF p_resource_type_code = 'JOB' THEN

Line 2290: FND_MSG_PUB.ADD;

2286: ELSIF p_resource_type_code = 'REVENUE_CATEGORY' THEN
2287: FND_MESSAGE.SET_NAME('PA', 'REVENUE_CATEGORY');
2288: END IF;
2289: p_resource_list_member_id := NULL;
2290: FND_MSG_PUB.ADD;
2291: END IF;
2292: RAISE FND_API.G_EXC_ERROR;
2293: END IF;
2294:

Line 2320: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2316: l_group_resource_type,
2317: l_job_group_id; -- Added for the bug 2486405.
2318: IF l_resource_list_csr%NOTFOUND THEN
2319: CLOSE l_resource_list_csr;
2320: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2321: THEN
2322: FND_MESSAGE.SET_NAME('PA', 'PA_RL_INVALID');
2323: FND_MSG_PUB.ADD;
2324: END IF;

Line 2323: FND_MSG_PUB.ADD;

2319: CLOSE l_resource_list_csr;
2320: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2321: THEN
2322: FND_MESSAGE.SET_NAME('PA', 'PA_RL_INVALID');
2323: FND_MSG_PUB.ADD;
2324: END IF;
2325: RAISE FND_API.G_EXC_ERROR;
2326: ELSE
2327: CLOSE l_resource_list_csr;

Line 2333: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2329:
2330: IF l_group_resource_type_id <> 0 AND
2331: (p_resource_group_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR AND
2332: p_resource_group_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN
2333: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2334: THEN
2335: FND_MESSAGE.SET_NAME('PA', 'PA_RL_GROUPED');
2336: FND_MSG_PUB.ADD;
2337: END IF;

Line 2336: FND_MSG_PUB.ADD;

2332: p_resource_group_alias = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ) THEN
2333: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2334: THEN
2335: FND_MESSAGE.SET_NAME('PA', 'PA_RL_GROUPED');
2336: FND_MSG_PUB.ADD;
2337: END IF;
2338: RAISE FND_API.G_EXC_ERROR;
2339: END IF;
2340:

Line 2397: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2393: p_err_stack => l_err_stack,
2394: p_return_status => l_return_status );
2395:
2396: IF l_err_code > 0 THEN
2397: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2398: THEN
2399: IF NOT pa_project_pvt.check_valid_message (l_err_stage) THEN
2400: FND_MESSAGE.SET_NAME ('PA','PA_ERR_IN_RL_MEMB_CREATION');
2401: ELSE

Line 2404: FND_MSG_PUB.ADD;

2400: FND_MESSAGE.SET_NAME ('PA','PA_ERR_IN_RL_MEMB_CREATION');
2401: ELSE
2402: FND_MESSAGE.SET_NAME ('PA',l_err_stage);
2403: END IF;
2404: FND_MSG_PUB.ADD;
2405: END IF;
2406: RAISE FND_API.G_EXC_ERROR;
2407: END IF;
2408:

Line 2410: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2406: RAISE FND_API.G_EXC_ERROR;
2407: END IF;
2408:
2409: IF l_err_code < 0 THEN
2410: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2411: THEN
2412: FND_MSG_PUB.Add_Exc_Msg
2413: ( p_pkg_name => 'G_PKG_NAME'
2414: , p_procedure_name => 'ADD_RESOURCE_LIST_MEMBER'

Line 2412: FND_MSG_PUB.Add_Exc_Msg

2408:
2409: IF l_err_code < 0 THEN
2410: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2411: THEN
2412: FND_MSG_PUB.Add_Exc_Msg
2413: ( p_pkg_name => 'G_PKG_NAME'
2414: , p_procedure_name => 'ADD_RESOURCE_LIST_MEMBER'
2415: , p_error_text => 'ORA-'||LPAD(SUBSTR(l_err_code, 2), 5, '0')
2416: );

Line 2439: FND_MSG_PUB.Count_And_Get

2435:
2436: p_return_status := FND_API.G_RET_STS_ERROR ;
2437: ROLLBACK TO Add_Resource_List_Member_Pub;
2438:
2439: FND_MSG_PUB.Count_And_Get
2440: ( p_count => p_msg_count ,
2441: p_data => p_msg_data );
2442:
2443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2448: FND_MSG_PUB.Count_And_Get

2444:
2445: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2446: ROLLBACK TO Add_Resource_List_Member_Pub;
2447:
2448: FND_MSG_PUB.Count_And_Get
2449: ( p_count => p_msg_count ,
2450: p_data => p_msg_data );
2451:
2452: WHEN OTHERS THEN

Line 2457: IF FND_MSG_PUB.Check_Msg_Level

2453:
2454: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2455: ROLLBACK TO Add_Resource_List_Member_Pub;
2456:
2457: IF FND_MSG_PUB.Check_Msg_Level
2458: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2459:
2460: FND_MSG_PUB.Add_Exc_Msg
2461: ( p_pkg_name => G_PKG_NAME ,

Line 2458: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2454: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2455: ROLLBACK TO Add_Resource_List_Member_Pub;
2456:
2457: IF FND_MSG_PUB.Check_Msg_Level
2458: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2459:
2460: FND_MSG_PUB.Add_Exc_Msg
2461: ( p_pkg_name => G_PKG_NAME ,
2462: p_procedure_name => l_api_name

Line 2460: FND_MSG_PUB.Add_Exc_Msg

2456:
2457: IF FND_MSG_PUB.Check_Msg_Level
2458: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2459:
2460: FND_MSG_PUB.Add_Exc_Msg
2461: ( p_pkg_name => G_PKG_NAME ,
2462: p_procedure_name => l_api_name
2463: );
2464:

Line 2467: FND_MSG_PUB.Count_And_Get

2463: );
2464:
2465: END IF;
2466:
2467: FND_MSG_PUB.Count_And_Get
2468: ( p_count => p_msg_count ,
2469: p_data => p_msg_data );
2470:
2471: END Add_Resource_List_Member;

Line 2630: FND_MSG_PUB.ADD;

2626: RAISE FND_API.G_EXC_ERROR;
2627: END IF;
2628: IF l_function_allowed = 'N' THEN
2629: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
2630: FND_MSG_PUB.ADD;
2631: p_return_status := FND_API.g_ret_sts_error;
2632: RAISE FND_API.G_EXC_ERROR;
2633: END IF;
2634:

Line 2637: FND_MSG_PUB.initialize;

2633: END IF;
2634:
2635: IF FND_API.to_boolean( p_init_msg_list )
2636: THEN
2637: FND_MSG_PUB.initialize;
2638: END IF;
2639:
2640: -- VALUE LAYER ----------------------------------------------------------------
2641:

Line 2674: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2670:
2671: -- Passed Column-Related Parameters Cannot Be Null
2672:
2673: IF (p_new_alias IS NULL) THEN
2674: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2675: THEN
2676: FND_MESSAGE.SET_NAME('PA','PA_P_NEW_ALIAS_NO_NULL');
2677: FND_MSG_PUB.ADD;
2678: END IF;

Line 2677: FND_MSG_PUB.ADD;

2673: IF (p_new_alias IS NULL) THEN
2674: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2675: THEN
2676: FND_MESSAGE.SET_NAME('PA','PA_P_NEW_ALIAS_NO_NULL');
2677: FND_MSG_PUB.ADD;
2678: END IF;
2679: RAISE FND_API.G_EXC_ERROR;
2680: END IF;
2681:

Line 2683: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2679: RAISE FND_API.G_EXC_ERROR;
2680: END IF;
2681:
2682: IF (p_sort_order IS NULL) THEN
2683: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2684: THEN
2685: FND_MESSAGE.SET_NAME('PA','PA_P_SORT_ORDER_NO_NULL');
2686: FND_MSG_PUB.ADD;
2687: END IF;

Line 2686: FND_MSG_PUB.ADD;

2682: IF (p_sort_order IS NULL) THEN
2683: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2684: THEN
2685: FND_MESSAGE.SET_NAME('PA','PA_P_SORT_ORDER_NO_NULL');
2686: FND_MSG_PUB.ADD;
2687: END IF;
2688: RAISE FND_API.G_EXC_ERROR;
2689: END IF;
2690:

Line 2692: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2688: RAISE FND_API.G_EXC_ERROR;
2689: END IF;
2690:
2691: IF (p_enabled_flag IS NULL) THEN
2692: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2693: THEN
2694: FND_MESSAGE.SET_NAME('PA','PA_P_ENABLED_FLAG_NO_NULL');
2695: FND_MSG_PUB.ADD;
2696: END IF;

Line 2695: FND_MSG_PUB.ADD;

2691: IF (p_enabled_flag IS NULL) THEN
2692: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2693: THEN
2694: FND_MESSAGE.SET_NAME('PA','PA_P_ENABLED_FLAG_NO_NULL');
2695: FND_MSG_PUB.ADD;
2696: END IF;
2697: RAISE FND_API.G_EXC_ERROR;
2698: END IF;
2699:

Line 2709: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2705: ELSE
2706: IF (p_enabled_flag IN ('Y', 'N')) THEN
2707: l_enabled_flag_new := p_enabled_flag;
2708: ELSE
2709: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2710: THEN
2711: FND_MESSAGE.SET_NAME('PA','PA_ENABLED_FLAG_YES_NO');
2712: FND_MSG_PUB.ADD;
2713: END IF;

Line 2712: FND_MSG_PUB.ADD;

2708: ELSE
2709: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2710: THEN
2711: FND_MESSAGE.SET_NAME('PA','PA_ENABLED_FLAG_YES_NO');
2712: FND_MSG_PUB.ADD;
2713: END IF;
2714: RAISE FND_API.G_EXC_ERROR;
2715: END IF;
2716: END IF;

Line 2735: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2731:
2732: OPEN l_new_alias_none_csr (p_new_alias , l_resource_list_id );
2733: FETCH l_new_alias_none_csr INTO l_dummy;
2734: IF (l_new_alias_none_csr%FOUND) THEN
2735: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2736: THEN
2737: FND_MESSAGE.SET_NAME('PA','PA_P_NEW_ALIAS_NOT_UNIQUE ');
2738: FND_MSG_PUB.ADD;
2739: END IF;

Line 2738: FND_MSG_PUB.ADD;

2734: IF (l_new_alias_none_csr%FOUND) THEN
2735: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2736: THEN
2737: FND_MESSAGE.SET_NAME('PA','PA_P_NEW_ALIAS_NOT_UNIQUE ');
2738: FND_MSG_PUB.ADD;
2739: END IF;
2740: CLOSE l_new_alias_none_csr;
2741: RAISE FND_API.G_EXC_ERROR;
2742: ELSE

Line 2761: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2757: OPEN l_new_alias_grouped_csr (p_new_alias , l_parent_member_id );
2758:
2759: FETCH l_new_alias_grouped_csr INTO l_dummy;
2760: IF (l_new_alias_grouped_csr%FOUND) THEN
2761: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2762: THEN
2763: FND_MESSAGE.SET_NAME('PA','PA_P_NEW_ALIAS_NOT_UNIQUE ');
2764: FND_MSG_PUB.ADD;
2765: END IF;

Line 2764: FND_MSG_PUB.ADD;

2760: IF (l_new_alias_grouped_csr%FOUND) THEN
2761: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2762: THEN
2763: FND_MESSAGE.SET_NAME('PA','PA_P_NEW_ALIAS_NOT_UNIQUE ');
2764: FND_MSG_PUB.ADD;
2765: END IF;
2766: CLOSE l_new_alias_grouped_csr;
2767: RAISE FND_API.G_EXC_ERROR;
2768: ELSE

Line 2844: FND_MSG_PUB.Count_And_Get

2840:
2841: p_return_status := FND_API.G_RET_STS_ERROR ;
2842: ROLLBACK TO Update_Resource_List_Mbr_Pub;
2843:
2844: FND_MSG_PUB.Count_And_Get
2845: ( p_count => p_msg_count ,
2846: p_data => p_msg_data );
2847:
2848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2853: FND_MSG_PUB.Count_And_Get

2849:
2850: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2851: ROLLBACK TO Update_Resource_List_Mbr_Pub;
2852:
2853: FND_MSG_PUB.Count_And_Get
2854: ( p_count => p_msg_count ,
2855: p_data => p_msg_data );
2856:
2857: WHEN ROW_ALREADY_LOCKED THEN

Line 2860: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2856:
2857: WHEN ROW_ALREADY_LOCKED THEN
2858:
2859: p_return_status := FND_API.G_RET_STS_ERROR ;
2860: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2861: THEN
2862: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
2863: FND_MESSAGE.SET_TOKEN('ENTITY', 'RESOURCE_LIST_MEMBER');
2864: FND_MSG_PUB.ADD;

Line 2864: FND_MSG_PUB.ADD;

2860: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2861: THEN
2862: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
2863: FND_MESSAGE.SET_TOKEN('ENTITY', 'RESOURCE_LIST_MEMBER');
2864: FND_MSG_PUB.ADD;
2865: END IF;
2866:
2867: ROLLBACK TO Update_Resource_List_Mbr_Pub;
2868:

Line 2869: FND_MSG_PUB.Count_And_Get

2865: END IF;
2866:
2867: ROLLBACK TO Update_Resource_List_Mbr_Pub;
2868:
2869: FND_MSG_PUB.Count_And_Get
2870: ( p_count => p_msg_count ,
2871: p_data => p_msg_data );
2872:
2873:

Line 2879: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2875:
2876: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2877: ROLLBACK TO Update_Resource_List_Mbr_Pub;
2878:
2879: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2880: FND_MSG_PUB.Add_Exc_Msg
2881: ( p_pkg_name => G_PKG_NAME ,
2882: p_procedure_name => l_api_name
2883: );

Line 2880: FND_MSG_PUB.Add_Exc_Msg

2876: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2877: ROLLBACK TO Update_Resource_List_Mbr_Pub;
2878:
2879: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2880: FND_MSG_PUB.Add_Exc_Msg
2881: ( p_pkg_name => G_PKG_NAME ,
2882: p_procedure_name => l_api_name
2883: );
2884: END IF;

Line 2886: FND_MSG_PUB.Count_And_Get

2882: p_procedure_name => l_api_name
2883: );
2884: END IF;
2885:
2886: FND_MSG_PUB.Count_And_Get
2887: ( p_count => p_msg_count ,
2888: p_data => p_msg_data );
2889:
2890: END Update_Resource_List_Member;

Line 2999: FND_MSG_PUB.ADD;

2995: RAISE FND_API.G_EXC_ERROR;
2996: END IF;
2997: IF l_function_allowed = 'N' THEN
2998: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
2999: FND_MSG_PUB.ADD;
3000: p_return_status := FND_API.g_ret_sts_error;
3001: RAISE FND_API.G_EXC_ERROR;
3002: END IF;
3003: IF FND_API.to_boolean( p_init_msg_list )

Line 3005: FND_MSG_PUB.initialize;

3001: RAISE FND_API.G_EXC_ERROR;
3002: END IF;
3003: IF FND_API.to_boolean( p_init_msg_list )
3004: THEN
3005: FND_MSG_PUB.initialize;
3006: END IF;
3007:
3008: p_return_status := FND_API.G_RET_STS_SUCCESS;
3009:

Line 3047: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3043:
3044: PA_GET_RESOURCE.delete_resource_list_member_ok(l_resource_list_id,l_resource_list_member_id,x_err_code,x_err_stage);
3045:
3046: IF x_err_code <> 0 THEN
3047: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3048: FND_MESSAGE.SET_NAME('PA',x_err_stage);
3049: FND_MSG_PUB.ADD;
3050: END IF;
3051: RAISE FND_API.G_EXC_ERROR;

Line 3049: FND_MSG_PUB.ADD;

3045:
3046: IF x_err_code <> 0 THEN
3047: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3048: FND_MESSAGE.SET_NAME('PA',x_err_stage);
3049: FND_MSG_PUB.ADD;
3050: END IF;
3051: RAISE FND_API.G_EXC_ERROR;
3052: END IF;
3053:

Line 3106: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3102: X_MSG_DATA =>x_err_stage,
3103: X_RETURN_STATUS =>l_return_status);
3104:
3105: IF x_err_code <> 0 THEN
3106: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3107: FND_MESSAGE.SET_NAME('PA',x_err_stage);
3108: FND_MSG_PUB.ADD;
3109: END IF;
3110: RAISE FND_API.G_EXC_ERROR;

Line 3108: FND_MSG_PUB.ADD;

3104:
3105: IF x_err_code <> 0 THEN
3106: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3107: FND_MESSAGE.SET_NAME('PA',x_err_stage);
3108: FND_MSG_PUB.ADD;
3109: END IF;
3110: RAISE FND_API.G_EXC_ERROR;
3111: END IF;
3112: END IF;

Line 3128: FND_MSG_PUB.Count_And_Get

3124:
3125: p_return_status := FND_API.G_RET_STS_ERROR ;
3126: ROLLBACK TO Delete_Resource_List_Mbr_Pub;
3127:
3128: FND_MSG_PUB.Count_And_Get
3129: ( p_count => p_msg_count ,
3130: p_data => p_msg_data );
3131:
3132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3137: FND_MSG_PUB.Count_And_Get

3133:
3134: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3135: ROLLBACK TO Delete_Resource_List_Mbr_Pub;
3136:
3137: FND_MSG_PUB.Count_And_Get
3138: ( p_count => p_msg_count ,
3139: p_data => p_msg_data );
3140:
3141: WHEN ROW_ALREADY_LOCKED THEN

Line 3146: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3142:
3143: p_return_status := FND_API.G_RET_STS_ERROR ;
3144: ROLLBACK TO Delete_Resource_List_Mbr_Pub;
3145:
3146: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3147: THEN
3148: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
3149: FND_MESSAGE.SET_TOKEN('ENTITY', 'RESOURCE_LIST');
3150: FND_MSG_PUB.ADD;

Line 3150: FND_MSG_PUB.ADD;

3146: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3147: THEN
3148: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
3149: FND_MESSAGE.SET_TOKEN('ENTITY', 'RESOURCE_LIST');
3150: FND_MSG_PUB.ADD;
3151: END IF;
3152:
3153: FND_MSG_PUB.Count_And_Get
3154: ( p_count => p_msg_count ,

Line 3153: FND_MSG_PUB.Count_And_Get

3149: FND_MESSAGE.SET_TOKEN('ENTITY', 'RESOURCE_LIST');
3150: FND_MSG_PUB.ADD;
3151: END IF;
3152:
3153: FND_MSG_PUB.Count_And_Get
3154: ( p_count => p_msg_count ,
3155: p_data => p_msg_data );
3156:
3157: WHEN OTHERS THEN

Line 3162: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3158:
3159: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3160: ROLLBACK TO Delete_Resource_List_Mbr_Pub;
3161:
3162: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3163: THEN
3164: FND_MSG_PUB.Add_Exc_Msg
3165: ( p_pkg_name => G_PKG_NAME ,
3166: p_procedure_name => l_api_name

Line 3164: FND_MSG_PUB.Add_Exc_Msg

3160: ROLLBACK TO Delete_Resource_List_Mbr_Pub;
3161:
3162: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3163: THEN
3164: FND_MSG_PUB.Add_Exc_Msg
3165: ( p_pkg_name => G_PKG_NAME ,
3166: p_procedure_name => l_api_name
3167: );
3168: END IF;

Line 3170: FND_MSG_PUB.Count_And_Get

3166: p_procedure_name => l_api_name
3167: );
3168: END IF;
3169:
3170: FND_MSG_PUB.Count_And_Get
3171: ( p_count => p_msg_count ,
3172: p_data => p_msg_data );
3173:
3174: END Delete_Resource_list_Member;

Line 3332: FND_MSG_PUB.ADD;

3328: RAISE FND_API.G_EXC_ERROR;
3329: END IF;
3330: IF l_function_allowed = 'N' THEN
3331: FND_MESSAGE.SET_NAME('PA','PA_FUNCTION_SECURITY_ENFORCED');
3332: FND_MSG_PUB.ADD;
3333: p_return_status := FND_API.g_ret_sts_error;
3334: RAISE FND_API.G_EXC_ERROR;
3335: END IF;
3336:

Line 3339: FND_MSG_PUB.initialize;

3335: END IF;
3336:
3337: IF FND_API.to_boolean( p_init_msg_list )
3338: THEN
3339: FND_MSG_PUB.initialize;
3340: END IF;
3341:
3342: p_return_status := FND_API.G_RET_STS_SUCCESS;
3343:

Line 3375: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3371: -- Added validation for p_sort_by Allowable Values
3372: -- -----------------------------------------------------------------------------------------
3373:
3374: IF ((p_sort_by <> 'ALIAS') AND (p_sort_by <> 'RESOURCE_NAME')) THEN
3375: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3376: THEN
3377: FND_MESSAGE.SET_NAME('PA','PA_INVALID_SORT_BY');
3378: FND_MSG_PUB.ADD;
3379: END IF;

Line 3378: FND_MSG_PUB.ADD;

3374: IF ((p_sort_by <> 'ALIAS') AND (p_sort_by <> 'RESOURCE_NAME')) THEN
3375: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3376: THEN
3377: FND_MESSAGE.SET_NAME('PA','PA_INVALID_SORT_BY');
3378: FND_MSG_PUB.ADD;
3379: END IF;
3380: RAISE FND_API.G_EXC_ERROR;
3381: END IF;
3382:

Line 3391: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3387: IF (l_resource_group_alias IS NOT NULL) THEN
3388: OPEN l_rsrc_grp_csr (l_resource_list_id, l_resource_group_alias);
3389: FETCH l_rsrc_grp_csr INTO l_resource_list_member_id;
3390: IF (l_rsrc_grp_csr %NOTFOUND) THEN
3391: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3392: THEN
3393: FND_MESSAGE.SET_NAME('PA','PA_INVALID_RSRC_GROUP_ALIAS');
3394: FND_MSG_PUB.ADD;
3395: END IF;

Line 3394: FND_MSG_PUB.ADD;

3390: IF (l_rsrc_grp_csr %NOTFOUND) THEN
3391: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3392: THEN
3393: FND_MESSAGE.SET_NAME('PA','PA_INVALID_RSRC_GROUP_ALIAS');
3394: FND_MSG_PUB.ADD;
3395: END IF;
3396: RAISE FND_API.G_EXC_ERROR;
3397: END IF;
3398: CLOSE l_rsrc_grp_csr ;

Line 3475: FND_MSG_PUB.Count_And_Get

3471:
3472: p_return_status := FND_API.G_RET_STS_ERROR ;
3473: ROLLBACK TO Sort_Resource_List_Mbr_Pub;
3474:
3475: FND_MSG_PUB.Count_And_Get
3476: ( p_count => p_msg_count ,
3477: p_data => p_msg_data );
3478:
3479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3484: FND_MSG_PUB.Count_And_Get

3480:
3481: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3482: ROLLBACK TO Sort_Resource_List_Mbr_Pub;
3483:
3484: FND_MSG_PUB.Count_And_Get
3485: ( p_count => p_msg_count ,
3486: p_data => p_msg_data );
3487:
3488: WHEN ROW_ALREADY_LOCKED THEN

Line 3493: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3489:
3490: p_return_status := FND_API.G_RET_STS_ERROR ;
3491: ROLLBACK TO Sort_Resource_List_Mbr_Pub;
3492:
3493: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3494: THEN
3495: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
3496: FND_MESSAGE.SET_TOKEN('ENTITY', 'RESOURCE_LIST_MEMBER');
3497: FND_MSG_PUB.ADD;

Line 3497: FND_MSG_PUB.ADD;

3493: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3494: THEN
3495: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED');
3496: FND_MESSAGE.SET_TOKEN('ENTITY', 'RESOURCE_LIST_MEMBER');
3497: FND_MSG_PUB.ADD;
3498: END IF;
3499:
3500: FND_MSG_PUB.Count_And_Get
3501: ( p_count => p_msg_count ,

Line 3500: FND_MSG_PUB.Count_And_Get

3496: FND_MESSAGE.SET_TOKEN('ENTITY', 'RESOURCE_LIST_MEMBER');
3497: FND_MSG_PUB.ADD;
3498: END IF;
3499:
3500: FND_MSG_PUB.Count_And_Get
3501: ( p_count => p_msg_count ,
3502: p_data => p_msg_data );
3503:
3504: WHEN OTHERS THEN

Line 3509: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3505:
3506: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3507: ROLLBACK TO Sort_Resource_List_Mbr_Pub;
3508:
3509: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3510: FND_MSG_PUB.Add_Exc_Msg
3511: ( p_pkg_name => G_PKG_NAME ,
3512: p_procedure_name => l_api_name
3513: );

Line 3510: FND_MSG_PUB.Add_Exc_Msg

3506: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3507: ROLLBACK TO Sort_Resource_List_Mbr_Pub;
3508:
3509: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3510: FND_MSG_PUB.Add_Exc_Msg
3511: ( p_pkg_name => G_PKG_NAME ,
3512: p_procedure_name => l_api_name
3513: );
3514: END IF;

Line 3516: FND_MSG_PUB.Count_And_Get

3512: p_procedure_name => l_api_name
3513: );
3514: END IF;
3515:
3516: FND_MSG_PUB.Count_And_Get
3517: ( p_count => p_msg_count ,
3518: p_data => p_msg_data );
3519:
3520:

Line 3569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3565: EXCEPTION
3566:
3567: WHEN OTHERS THEN
3568:
3569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3570:
3571: FND_MSG_PUB.Add_Exc_Msg
3572: ( p_pkg_name => G_PKG_NAME ,
3573: p_procedure_name => l_api_name

Line 3571: FND_MSG_PUB.Add_Exc_Msg

3567: WHEN OTHERS THEN
3568:
3569: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3570:
3571: FND_MSG_PUB.Add_Exc_Msg
3572: ( p_pkg_name => G_PKG_NAME ,
3573: p_procedure_name => l_api_name
3574: );
3575:

Line 3625: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3621:
3622: OPEN l_resource_list_csr (p_resource_list_id);
3623: FETCH l_resource_list_csr INTO l_dummy;
3624: IF (l_resource_list_csr %NOTFOUND) THEN
3625: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3626: THEN
3627: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
3628: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Resource List');
3629: FND_MESSAGE.SET_TOKEN('ATTR_VALUE', p_resource_list_id);

Line 3630: FND_MSG_PUB.ADD;

3626: THEN
3627: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
3628: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Resource List');
3629: FND_MESSAGE.SET_TOKEN('ATTR_VALUE', p_resource_list_id);
3630: FND_MSG_PUB.ADD;
3631: END IF;
3632: CLOSE l_resource_list_csr;
3633: RAISE FND_API.G_EXC_ERROR;
3634: ELSE

Line 3648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

3644: Fetch_Resource_list_id
3645: (p_resource_list_name => p_resource_list_name );
3646:
3647: IF l_resource_list_id IS NULL THEN
3648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3649: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
3650: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Resource List Name');
3651: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_resource_list_name);
3652: FND_MSG_PUB.ADD;

Line 3652: FND_MSG_PUB.ADD;

3648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3649: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
3650: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Resource List Name');
3651: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_resource_list_name);
3652: FND_MSG_PUB.ADD;
3653: RAISE FND_API.G_EXC_ERROR;
3654: END IF;
3655: ELSE
3656: p_out_resource_list_id := l_resource_list_id;

Line 3675: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3671:
3672: WHEN OTHERS THEN
3673:
3674: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3675: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3676:
3677: FND_MSG_PUB.Add_Exc_Msg
3678: ( p_pkg_name => G_PKG_NAME ,
3679: p_procedure_name => l_api_name );

Line 3677: FND_MSG_PUB.Add_Exc_Msg

3673:
3674: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3675: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3676:
3677: FND_MSG_PUB.Add_Exc_Msg
3678: ( p_pkg_name => G_PKG_NAME ,
3679: p_procedure_name => l_api_name );
3680:
3681: END IF;

Line 3733: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3729: EXCEPTION
3730:
3731: WHEN OTHERS THEN
3732:
3733: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3734:
3735: FND_MSG_PUB.Add_Exc_Msg
3736: ( p_pkg_name => G_PKG_NAME ,
3737: p_procedure_name => l_api_name

Line 3735: FND_MSG_PUB.Add_Exc_Msg

3731: WHEN OTHERS THEN
3732:
3733: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3734:
3735: FND_MSG_PUB.Add_Exc_Msg
3736: ( p_pkg_name => G_PKG_NAME ,
3737: p_procedure_name => l_api_name
3738: );
3739:

Line 3822: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3818: p_object_type => l_object_type);
3819:
3820: FETCH l_resource_list_members_csr INTO l_dummy;
3821: IF (l_resource_list_members_csr %NOTFOUND) THEN
3822: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3823: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
3824: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Resource List Member');
3825: FND_MESSAGE.SET_TOKEN('ATTR_VALUE', p_resource_list_member_id);
3826: FND_MSG_PUB.ADD;

Line 3826: FND_MSG_PUB.ADD;

3822: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3823: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
3824: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Resource List Member');
3825: FND_MESSAGE.SET_TOKEN('ATTR_VALUE', p_resource_list_member_id);
3826: FND_MSG_PUB.ADD;
3827: END IF;
3828: CLOSE l_resource_list_members_csr;
3829: RAISE FND_API.G_EXC_ERROR;
3830: ELSE

Line 3860: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

3856:
3857: IF (l_resource_list_member_id IS NULL ) THEN
3858:
3859: p_out_resource_list_member_id := NULL;
3860: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3861: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
3862: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Alias');
3863: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_alias);
3864: FND_MSG_PUB.ADD;

Line 3864: FND_MSG_PUB.ADD;

3860: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3861: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
3862: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Alias');
3863: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_alias);
3864: FND_MSG_PUB.ADD;
3865: END IF;
3866: RAISE FND_API.G_EXC_ERROR;
3867:
3868: ELSE

Line 3888: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3884: WHEN OTHERS THEN
3885:
3886: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3887:
3888: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3889:
3890: FND_MSG_PUB.Add_Exc_Msg
3891: ( p_pkg_name => G_PKG_NAME ,
3892: p_procedure_name => l_api_name

Line 3890: FND_MSG_PUB.Add_Exc_Msg

3886: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3887:
3888: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3889:
3890: FND_MSG_PUB.Add_Exc_Msg
3891: ( p_pkg_name => G_PKG_NAME ,
3892: p_procedure_name => l_api_name
3893: );
3894:

Line 3971: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3967:
3968: OPEN l_emp_csr(p_resource_attr_value);
3969: FETCH l_emp_csr INTO p_resource_name;
3970: IF (l_emp_csr%NOTFOUND) THEN
3971: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3972: THEN
3973: FND_MESSAGE.SET_NAME('PA','PA_INVALID_EMPLOYEE');
3974: FND_MSG_PUB.ADD;
3975: END IF;

Line 3974: FND_MSG_PUB.ADD;

3970: IF (l_emp_csr%NOTFOUND) THEN
3971: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3972: THEN
3973: FND_MESSAGE.SET_NAME('PA','PA_INVALID_EMPLOYEE');
3974: FND_MSG_PUB.ADD;
3975: END IF;
3976: CLOSE l_emp_csr;
3977: RAISE FND_API.G_EXC_ERROR;
3978: ELSE

Line 3988: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3984:
3985: OPEN l_job_csr(p_resource_attr_value);
3986: FETCH l_job_csr INTO p_resource_name;
3987: IF (l_job_csr%NOTFOUND) THEN
3988: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3989: THEN
3990: FND_MESSAGE.SET_NAME('PA','PA_INVALID_JOB');
3991: FND_MSG_PUB.ADD;
3992: END IF;

Line 3991: FND_MSG_PUB.ADD;

3987: IF (l_job_csr%NOTFOUND) THEN
3988: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3989: THEN
3990: FND_MESSAGE.SET_NAME('PA','PA_INVALID_JOB');
3991: FND_MSG_PUB.ADD;
3992: END IF;
3993: CLOSE l_job_csr;
3994: RAISE FND_API.G_EXC_ERROR;
3995: ELSE

Line 4005: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4001:
4002: OPEN l_org_csr(p_resource_attr_value);
4003: FETCH l_org_csr INTO p_resource_name;
4004: IF (l_org_csr%NOTFOUND) THEN
4005: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4006: THEN
4007: FND_MESSAGE.SET_NAME('PA','PA_INVALID_ORGANIZATION');
4008: FND_MSG_PUB.ADD;
4009: END IF;

Line 4008: FND_MSG_PUB.ADD;

4004: IF (l_org_csr%NOTFOUND) THEN
4005: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4006: THEN
4007: FND_MESSAGE.SET_NAME('PA','PA_INVALID_ORGANIZATION');
4008: FND_MSG_PUB.ADD;
4009: END IF;
4010: CLOSE l_org_csr;
4011: RAISE FND_API.G_EXC_ERROR;
4012: ELSE

Line 4022: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4018:
4019: OPEN l_vendor_csr(p_resource_attr_value);
4020: FETCH l_vendor_csr INTO p_resource_name;
4021: IF (l_vendor_csr%NOTFOUND) THEN
4022: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4023: THEN
4024: FND_MESSAGE.SET_NAME('PA','PA_INVALID_VENDOR');
4025: FND_MSG_PUB.ADD;
4026: END IF;

Line 4025: FND_MSG_PUB.ADD;

4021: IF (l_vendor_csr%NOTFOUND) THEN
4022: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4023: THEN
4024: FND_MESSAGE.SET_NAME('PA','PA_INVALID_VENDOR');
4025: FND_MSG_PUB.ADD;
4026: END IF;
4027: CLOSE l_vendor_csr;
4028: RAISE FND_API.G_EXC_ERROR;
4029: ELSE

Line 4039: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4035:
4036: OPEN l_exp_type_csr(p_resource_attr_value);
4037: FETCH l_exp_type_csr INTO p_resource_name;
4038: IF (l_exp_type_csr%NOTFOUND) THEN
4039: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4040: THEN
4041: FND_MESSAGE.SET_NAME('PA','PA_INVALID_EXPENDITURE_TYPE');
4042: FND_MSG_PUB.ADD;
4043: END IF;

Line 4042: FND_MSG_PUB.ADD;

4038: IF (l_exp_type_csr%NOTFOUND) THEN
4039: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4040: THEN
4041: FND_MESSAGE.SET_NAME('PA','PA_INVALID_EXPENDITURE_TYPE');
4042: FND_MSG_PUB.ADD;
4043: END IF;
4044: CLOSE l_exp_type_csr;
4045: RAISE FND_API.G_EXC_ERROR;
4046: ELSE

Line 4056: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4052:
4053: OPEN l_exp_category_csr(p_resource_attr_value);
4054: FETCH l_exp_category_csr INTO p_resource_name;
4055: IF (l_exp_category_csr%NOTFOUND) THEN
4056: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4057: THEN
4058: FND_MESSAGE.SET_NAME('PA','PA_INVALID_EXP_CATEGORY');
4059: FND_MSG_PUB.ADD;
4060: END IF;

Line 4059: FND_MSG_PUB.ADD;

4055: IF (l_exp_category_csr%NOTFOUND) THEN
4056: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4057: THEN
4058: FND_MESSAGE.SET_NAME('PA','PA_INVALID_EXP_CATEGORY');
4059: FND_MSG_PUB.ADD;
4060: END IF;
4061: CLOSE l_exp_category_csr;
4062: RAISE FND_API.G_EXC_ERROR;
4063: ELSE

Line 4073: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4069:
4070: OPEN l_event_type_csr(p_resource_attr_value);
4071: FETCH l_event_type_csr INTO p_resource_name;
4072: IF (l_event_type_csr%NOTFOUND) THEN
4073: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4074: THEN
4075: FND_MESSAGE.SET_NAME('PA','PA_INVALID_EVENT_TYPE');
4076: FND_MSG_PUB.ADD;
4077: END IF;

Line 4076: FND_MSG_PUB.ADD;

4072: IF (l_event_type_csr%NOTFOUND) THEN
4073: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4074: THEN
4075: FND_MESSAGE.SET_NAME('PA','PA_INVALID_EVENT_TYPE');
4076: FND_MSG_PUB.ADD;
4077: END IF;
4078: CLOSE l_exp_type_csr;
4079: RAISE FND_API.G_EXC_ERROR;
4080: ELSE

Line 4090: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4086:
4087: OPEN l_rev_category_csr(p_resource_attr_value);
4088: FETCH l_rev_category_csr INTO p_resource_name;
4089: IF (l_rev_category_csr%NOTFOUND) THEN
4090: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4091: THEN
4092: FND_MESSAGE.SET_NAME('PA','PA_INVALID_REV_CATEG');
4093: FND_MSG_PUB.ADD;
4094: END IF;

Line 4093: FND_MSG_PUB.ADD;

4089: IF (l_rev_category_csr%NOTFOUND) THEN
4090: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4091: THEN
4092: FND_MESSAGE.SET_NAME('PA','PA_INVALID_REV_CATEG');
4093: FND_MSG_PUB.ADD;
4094: END IF;
4095: CLOSE l_rev_category_csr;
4096: RAISE FND_API.G_EXC_ERROR;
4097: ELSE

Line 4116: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4112: WHEN OTHERS THEN
4113:
4114: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4115:
4116: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4117:
4118: FND_MSG_PUB.Add_Exc_Msg
4119: ( p_pkg_name => G_PKG_NAME ,
4120: p_procedure_name => l_api_name

Line 4118: FND_MSG_PUB.Add_Exc_Msg

4114: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4115:
4116: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4117:
4118: FND_MSG_PUB.Add_Exc_Msg
4119: ( p_pkg_name => G_PKG_NAME ,
4120: p_procedure_name => l_api_name
4121: );
4122: