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.AMS_ACCESS_PVT dependencies on FND_MESSAGE

Line 171: FND_MESSAGE.set_name('AMS', 'AMS_RUN_ACCESS_REFRESH_PROGRAM');

167:
168: OPEN c_group_exists;
169: FETCH c_group_exists INTO l_group_exists;
170: IF p_access_rec.arc_user_or_role_type = 'GROUP' AND c_group_exists%NOTFOUND THEN
171: FND_MESSAGE.set_name('AMS', 'AMS_RUN_ACCESS_REFRESH_PROGRAM');
172: FND_MSG_PUB.add;
173: RAISE FND_API.g_exc_error;
174: END IF;
175: CLOSE c_group_exists;

Line 245: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');

241: x_msg_data => x_msg_data
242: );
243:
244: IF l_return_status = FND_API.g_ret_sts_error THEN
245: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
246: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
247: FND_MSG_PUB.add;
248: RAISE FND_API.g_exc_error;
249: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 246: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

242: );
243:
244: IF l_return_status = FND_API.g_ret_sts_error THEN
245: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
246: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
247: FND_MSG_PUB.add;
248: RAISE FND_API.g_exc_error;
249: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
250: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

Line 250: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

246: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
247: FND_MSG_PUB.add;
248: RAISE FND_API.g_exc_error;
249: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
250: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
251: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
252: FND_MSG_PUB.add;
253: RAISE FND_API.g_exc_unexpected_error;
254: END IF;

Line 251: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

247: FND_MSG_PUB.add;
248: RAISE FND_API.g_exc_error;
249: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
250: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
251: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
252: FND_MSG_PUB.add;
253: RAISE FND_API.g_exc_unexpected_error;
254: END IF;
255:

Line 353: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');

349: x_msg_data => x_msg_data
350: );
351:
352: IF l_return_status = FND_API.g_ret_sts_error THEN
353: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
354: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
355: FND_MSG_PUB.add;
356: RAISE FND_API.g_exc_error;
357: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 354: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

350: );
351:
352: IF l_return_status = FND_API.g_ret_sts_error THEN
353: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
354: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
355: FND_MSG_PUB.add;
356: RAISE FND_API.g_exc_error;
357: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
358: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

Line 358: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

354: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
355: FND_MSG_PUB.add;
356: RAISE FND_API.g_exc_error;
357: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
358: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
359: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
360: FND_MSG_PUB.add;
361: RAISE FND_API.g_exc_unexpected_error;
362: END IF;

Line 359: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

355: FND_MSG_PUB.add;
356: RAISE FND_API.g_exc_error;
357: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
358: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
359: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
360: FND_MSG_PUB.add;
361: RAISE FND_API.g_exc_unexpected_error;
362: END IF;
363:

Line 458: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');

454: x_msg_data => x_msg_data
455: );
456:
457: IF l_return_status = FND_API.g_ret_sts_error THEN
458: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
459: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
460: FND_MSG_PUB.add;
461: RAISE FND_API.g_exc_error;
462: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 459: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

455: );
456:
457: IF l_return_status = FND_API.g_ret_sts_error THEN
458: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
459: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
460: FND_MSG_PUB.add;
461: RAISE FND_API.g_exc_error;
462: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
463: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

Line 463: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

459: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
460: FND_MSG_PUB.add;
461: RAISE FND_API.g_exc_error;
462: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
463: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
464: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
465: FND_MSG_PUB.add;
466: RAISE FND_API.g_exc_unexpected_error;
467: END IF;

Line 464: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

460: FND_MSG_PUB.add;
461: RAISE FND_API.g_exc_error;
462: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
463: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
464: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
465: FND_MSG_PUB.add;
466: RAISE FND_API.g_exc_unexpected_error;
467: END IF;
468: END IF; --for arc_user_or_role_type = 'USER'

Line 692: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

688:
689: IF (SQL%NOTFOUND) THEN
690: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
691: THEN
692: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
693: FND_MSG_PUB.add;
694: END IF;
695: RAISE FND_API.g_exc_error;
696: END IF;

Line 727: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

723:
724: IF (SQL%NOTFOUND) THEN
725: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
726: THEN
727: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
728: FND_MSG_PUB.add;
729: END IF;
730: RAISE FND_API.g_exc_error;
731: END IF;

Line 744: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');

740: x_msg_data => x_msg_data
741: );
742:
743: IF l_return_status = FND_API.g_ret_sts_error THEN
744: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
745: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
746: FND_MSG_PUB.add;
747: RAISE FND_API.g_exc_error;
748: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 745: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

741: );
742:
743: IF l_return_status = FND_API.g_ret_sts_error THEN
744: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
745: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
746: FND_MSG_PUB.add;
747: RAISE FND_API.g_exc_error;
748: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
749: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

Line 749: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

745: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
746: FND_MSG_PUB.add;
747: RAISE FND_API.g_exc_error;
748: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
749: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
750: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
751: FND_MSG_PUB.add;
752: RAISE FND_API.g_exc_unexpected_error;
753: END IF;

Line 750: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

746: FND_MSG_PUB.add;
747: RAISE FND_API.g_exc_error;
748: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
749: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
750: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
751: FND_MSG_PUB.add;
752: RAISE FND_API.g_exc_unexpected_error;
753: END IF;
754: END LOOP;

Line 775: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

771:
772: IF (SQL%NOTFOUND) THEN
773: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
774: THEN
775: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
776: FND_MSG_PUB.add;
777: END IF;
778: RAISE FND_API.g_exc_error;
779: END IF;

Line 792: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');

788: x_msg_data => x_msg_data
789: );
790:
791: IF l_return_status = FND_API.g_ret_sts_error THEN
792: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
793: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
794: FND_MSG_PUB.add;
795: RAISE FND_API.g_exc_error;
796: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 793: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

789: );
790:
791: IF l_return_status = FND_API.g_ret_sts_error THEN
792: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
793: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
794: FND_MSG_PUB.add;
795: RAISE FND_API.g_exc_error;
796: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
797: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

Line 797: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

793: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
794: FND_MSG_PUB.add;
795: RAISE FND_API.g_exc_error;
796: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
797: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
798: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
799: FND_MSG_PUB.add;
800: RAISE FND_API.g_exc_unexpected_error;
801: END IF;

Line 798: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

794: FND_MSG_PUB.add;
795: RAISE FND_API.g_exc_error;
796: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
797: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
798: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
799: FND_MSG_PUB.add;
800: RAISE FND_API.g_exc_unexpected_error;
801: END IF;
802:

Line 822: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');

818: x_msg_data => x_msg_data
819: );
820:
821: IF l_return_status = FND_API.g_ret_sts_error THEN
822: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
823: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
824: FND_MSG_PUB.add;
825: RAISE FND_API.g_exc_error;
826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 823: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

819: );
820:
821: IF l_return_status = FND_API.g_ret_sts_error THEN
822: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
823: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
824: FND_MSG_PUB.add;
825: RAISE FND_API.g_exc_error;
826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
827: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

Line 827: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

823: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
824: FND_MSG_PUB.add;
825: RAISE FND_API.g_exc_error;
826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
827: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
828: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
829: FND_MSG_PUB.add;
830: RAISE FND_API.g_exc_unexpected_error;
831: END IF;

Line 828: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

824: FND_MSG_PUB.add;
825: RAISE FND_API.g_exc_error;
826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
827: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
828: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
829: FND_MSG_PUB.add;
830: RAISE FND_API.g_exc_unexpected_error;
831: END IF;
832:

Line 846: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

842:
843: IF (SQL%NOTFOUND) THEN
844: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
845: THEN
846: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
847: FND_MSG_PUB.add;
848: END IF;
849: RAISE FND_API.g_exc_error;
850: END IF;

Line 884: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

880:
881: IF (SQL%NOTFOUND) THEN
882: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
883: THEN
884: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
885: FND_MSG_PUB.add;
886: END IF;
887: RAISE FND_API.g_exc_error;
888: END IF;

Line 917: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

913:
914: IF (SQL%NOTFOUND) THEN
915: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
916: THEN
917: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
918: FND_MSG_PUB.add;
919: END IF;
920: RAISE FND_API.g_exc_error;
921: END IF;

Line 1090: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

1086: FETCH c_access_b INTO l_access_id;
1087: IF (c_access_b%NOTFOUND) THEN
1088: CLOSE c_access_b;
1089: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1090: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1091: FND_MSG_PUB.add;
1092: END IF;
1093: RAISE FND_API.g_exc_error;
1094: END IF;

Line 1116: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');

1112:
1113: WHEN AMS_Utility_PVT.resource_locked THEN
1114: x_return_status := FND_API.g_ret_sts_error;
1115: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1116: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1117: FND_MSG_PUB.add;
1118: END IF;
1119:
1120: FND_MSG_PUB.count_and_get(

Line 1320: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

1316: AND object_version_number = l_access_rec.object_version_number;
1317:
1318: IF (SQL%NOTFOUND) THEN
1319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1320: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1321: FND_MSG_PUB.add;
1322: END IF;
1323: RAISE FND_API.g_exc_error;
1324: END IF;

Line 1355: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

1351: WHERE activity_access_id = l_key_id;
1352:
1353: IF (SQL%NOTFOUND) THEN
1354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1355: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1356: FND_MSG_PUB.add;
1357: END IF;
1358: RAISE FND_API.g_exc_error;
1359: END IF;

Line 1372: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');

1368: x_msg_data => x_msg_data
1369: );
1370:
1371: IF l_return_status = FND_API.g_ret_sts_error THEN
1372: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1373: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1374: FND_MSG_PUB.add;
1375: RAISE FND_API.g_exc_error;
1376: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1373: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1369: );
1370:
1371: IF l_return_status = FND_API.g_ret_sts_error THEN
1372: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1373: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1374: FND_MSG_PUB.add;
1375: RAISE FND_API.g_exc_error;
1376: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1377: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');

Line 1377: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');

1373: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1374: FND_MSG_PUB.add;
1375: RAISE FND_API.g_exc_error;
1376: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1377: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1378: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1379: FND_MSG_PUB.add;
1380: RAISE FND_API.g_exc_unexpected_error;
1381: END IF;

Line 1378: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1374: FND_MSG_PUB.add;
1375: RAISE FND_API.g_exc_error;
1376: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1377: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1378: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1379: FND_MSG_PUB.add;
1380: RAISE FND_API.g_exc_unexpected_error;
1381: END IF;
1382:

Line 1426: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

1422: WHERE activity_access_id = l_key_id;
1423:
1424: IF (SQL%NOTFOUND) THEN
1425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1426: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1427: FND_MSG_PUB.add;
1428: END IF;
1429: RAISE FND_API.g_exc_error;
1430: END IF;

Line 1443: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');

1439: x_msg_data => x_msg_data
1440: );
1441:
1442: IF l_return_status = FND_API.g_ret_sts_error THEN
1443: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1444: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1445: FND_MSG_PUB.add;
1446: RAISE FND_API.g_exc_error;
1447: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1444: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1440: );
1441:
1442: IF l_return_status = FND_API.g_ret_sts_error THEN
1443: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1444: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1445: FND_MSG_PUB.add;
1446: RAISE FND_API.g_exc_error;
1447: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1448: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');

Line 1448: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');

1444: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1445: FND_MSG_PUB.add;
1446: RAISE FND_API.g_exc_error;
1447: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1448: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1449: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1450: FND_MSG_PUB.add;
1451: RAISE FND_API.g_exc_unexpected_error;
1452: END IF;

Line 1449: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1445: FND_MSG_PUB.add;
1446: RAISE FND_API.g_exc_error;
1447: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1448: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1449: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1450: FND_MSG_PUB.add;
1451: RAISE FND_API.g_exc_unexpected_error;
1452: END IF;
1453: END IF; --for l_qp_list_header_id IS NOT NULL

Line 1474: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');

1470: x_msg_data => x_msg_data
1471: );
1472:
1473: IF l_return_status = FND_API.g_ret_sts_error THEN
1474: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1475: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1476: FND_MSG_PUB.add;
1477: RAISE FND_API.g_exc_error;
1478: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1475: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1471: );
1472:
1473: IF l_return_status = FND_API.g_ret_sts_error THEN
1474: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1475: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1476: FND_MSG_PUB.add;
1477: RAISE FND_API.g_exc_error;
1478: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1479: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');

Line 1479: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');

1475: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1476: FND_MSG_PUB.add;
1477: RAISE FND_API.g_exc_error;
1478: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1479: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1480: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1481: FND_MSG_PUB.add;
1482: RAISE FND_API.g_exc_unexpected_error;
1483: END IF;

Line 1480: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1476: FND_MSG_PUB.add;
1477: RAISE FND_API.g_exc_error;
1478: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1479: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1480: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1481: FND_MSG_PUB.add;
1482: RAISE FND_API.g_exc_unexpected_error;
1483: END IF;
1484:

Line 1498: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');

1494: x_msg_data => x_msg_data
1495: );
1496:
1497: IF l_return_status = FND_API.g_ret_sts_error THEN
1498: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1499: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1500: FND_MSG_PUB.add;
1501: RAISE FND_API.g_exc_error;
1502: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1499: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1495: );
1496:
1497: IF l_return_status = FND_API.g_ret_sts_error THEN
1498: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1499: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1500: FND_MSG_PUB.add;
1501: RAISE FND_API.g_exc_error;
1502: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1503: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

Line 1503: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

1499: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1500: FND_MSG_PUB.add;
1501: RAISE FND_API.g_exc_error;
1502: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1503: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1504: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1505: FND_MSG_PUB.add;
1506: RAISE FND_API.g_exc_unexpected_error;
1507: END IF;

Line 1504: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1500: FND_MSG_PUB.add;
1501: RAISE FND_API.g_exc_error;
1502: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1503: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1504: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1505: FND_MSG_PUB.add;
1506: RAISE FND_API.g_exc_unexpected_error;
1507: END IF;
1508:

Line 1520: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');

1516: x_msg_data => x_msg_data
1517: );
1518:
1519: IF l_return_status = FND_API.g_ret_sts_error THEN
1520: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1521: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1522: FND_MSG_PUB.add;
1523: RAISE FND_API.g_exc_error;
1524: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1521: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1517: );
1518:
1519: IF l_return_status = FND_API.g_ret_sts_error THEN
1520: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1521: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1522: FND_MSG_PUB.add;
1523: RAISE FND_API.g_exc_error;
1524: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1525: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

Line 1525: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

1521: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1522: FND_MSG_PUB.add;
1523: RAISE FND_API.g_exc_error;
1524: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1525: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1526: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1527: FND_MSG_PUB.add;
1528: RAISE FND_API.g_exc_unexpected_error;
1529: END IF;

Line 1526: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1522: FND_MSG_PUB.add;
1523: RAISE FND_API.g_exc_error;
1524: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1525: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1526: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1527: FND_MSG_PUB.add;
1528: RAISE FND_API.g_exc_unexpected_error;
1529: END IF;
1530: END IF;

Line 1696: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

1692: AND owner_flag = 'Y';
1693:
1694: IF (SQL%NOTFOUND) THEN
1695: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1696: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1697: FND_MSG_PUB.add;
1698: END IF;
1699: RAISE FND_API.g_exc_error;
1700: END IF;

Line 1714: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');

1710: x_msg_data => x_msg_data
1711: );
1712:
1713: IF l_return_status = FND_API.g_ret_sts_error THEN
1714: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1715: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1716: FND_MSG_PUB.add;
1717: RAISE FND_API.g_exc_error;
1718: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1715: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1711: );
1712:
1713: IF l_return_status = FND_API.g_ret_sts_error THEN
1714: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1715: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1716: FND_MSG_PUB.add;
1717: RAISE FND_API.g_exc_error;
1718: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1719: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');

Line 1719: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');

1715: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1716: FND_MSG_PUB.add;
1717: RAISE FND_API.g_exc_error;
1718: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1719: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1720: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1721: FND_MSG_PUB.add;
1722: RAISE FND_API.g_exc_unexpected_error;
1723: END IF;

Line 1720: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1716: FND_MSG_PUB.add;
1717: RAISE FND_API.g_exc_error;
1718: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1719: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1720: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1721: FND_MSG_PUB.add;
1722: RAISE FND_API.g_exc_unexpected_error;
1723: END IF;
1724:

Line 1736: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');

1732: x_msg_data => x_msg_data
1733: );
1734:
1735: IF l_return_status = FND_API.g_ret_sts_error THEN
1736: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1737: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1738: FND_MSG_PUB.add;
1739: RAISE FND_API.g_exc_error;
1740: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1737: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1733: );
1734:
1735: IF l_return_status = FND_API.g_ret_sts_error THEN
1736: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1737: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1738: FND_MSG_PUB.add;
1739: RAISE FND_API.g_exc_error;
1740: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1741: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

Line 1741: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

1737: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1738: FND_MSG_PUB.add;
1739: RAISE FND_API.g_exc_error;
1740: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1741: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1742: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1743: FND_MSG_PUB.add;
1744: RAISE FND_API.g_exc_unexpected_error;
1745: END IF;

Line 1742: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);

1738: FND_MSG_PUB.add;
1739: RAISE FND_API.g_exc_error;
1740: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1741: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1742: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1743: FND_MSG_PUB.add;
1744: RAISE FND_API.g_exc_unexpected_error;
1745: END IF;
1746:

Line 1907: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUP_USER');

1903: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1904: THEN
1905: IF (p_access_rec.arc_user_or_role_type = 'USER')
1906: THEN
1907: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUP_USER');
1908: ELSE
1909: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUP_GRP');
1910: END IF;
1911: FND_MSG_PUB.add;

Line 1909: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUP_GRP');

1905: IF (p_access_rec.arc_user_or_role_type = 'USER')
1906: THEN
1907: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUP_USER');
1908: ELSE
1909: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUP_GRP');
1910: END IF;
1911: FND_MSG_PUB.add;
1912: END IF;
1913: CLOSE c_check_dup;

Line 2418: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_OBJECT_ID');

2414: ------------------------ user_status_id --------------------------
2415: IF p_Access_rec.act_access_to_object_id IS NULL THEN
2416: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2417: THEN
2418: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_OBJECT_ID');
2419: FND_MSG_PUB.add;
2420: END IF;
2421:
2422: x_return_status := FND_API.g_ret_sts_error;

Line 2429: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_OBJECT');

2425:
2426: IF p_Access_rec.arc_act_access_to_object IS NULL THEN
2427: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2428: THEN
2429: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_OBJECT');
2430: FND_MSG_PUB.add;
2431: END IF;
2432:
2433: x_return_status := FND_API.g_ret_sts_error;

Line 2440: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_UR_ID');

2436:
2437: IF p_Access_rec.user_or_role_id IS NULL THEN
2438: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2439: THEN
2440: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_UR_ID');
2441: FND_MSG_PUB.add;
2442: END IF;
2443:
2444: x_return_status := FND_API.g_ret_sts_error;

Line 2451: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_UR_TYPE');

2447:
2448: IF p_Access_rec.arc_user_or_role_type IS NULL THEN
2449: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2450: THEN
2451: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_UR_TYPE');
2452: FND_MSG_PUB.add;
2453: END IF;
2454:
2455: x_return_status := FND_API.g_ret_sts_error;

Line 2479: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUP_USER');

2475:
2476: if (c1%FOUND) then
2477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2478: THEN
2479: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUP_USER');
2480: FND_MSG_PUB.add;
2481: END IF;
2482: x_return_status := FND_API.g_ret_sts_error;
2483: RETURN;

Line 2526: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUPLICATE_ID');

2522: ) = FND_API.g_false
2523: THEN
2524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2525: THEN
2526: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUPLICATE_ID');
2527: FND_MSG_PUB.add;
2528: END IF;
2529: x_return_status := FND_API.g_ret_sts_error;
2530: RETURN;

Line 2566: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_USER_ID');

2562: ) = FND_API.g_false
2563: THEN
2564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2565: THEN
2566: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_USER_ID');
2567: FND_MSG_PUB.add;
2568: END IF;
2569:
2570: x_return_status := FND_API.g_ret_sts_error;

Line 2588: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_GROUP_ID');

2584: ) = FND_API.g_false
2585: THEN
2586: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2587: THEN
2588: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_GROUP_ID');
2589: FND_MSG_PUB.add;
2590: END IF;
2591:
2592: x_return_status := FND_API.g_ret_sts_error;

Line 2661: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_SYS_ARC');

2657: ) = FND_API.g_false
2658: THEN
2659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2660: THEN
2661: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_SYS_ARC');
2662: FND_MSG_PUB.add;
2663: END IF;
2664: x_return_status := FND_API.g_ret_sts_error;
2665: RETURN;

Line 2688: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_USER_TYPE');

2684: ) = FND_API.g_false
2685: THEN
2686: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2687: THEN
2688: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_USER_TYPE');
2689: FND_MSG_PUB.add;
2690: END IF;
2691:
2692: x_return_status := FND_API.g_ret_sts_error;

Line 2724: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_ADMIN_FLAG');

2720: IF AMS_Utility_PVT.is_Y_or_N(p_access_rec.admin_flag) = FND_API.g_false
2721: THEN
2722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2723: THEN
2724: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_ADMIN_FLAG');
2725: FND_MSG_PUB.add;
2726: END IF;
2727:
2728: x_return_status := FND_API.g_ret_sts_error;

Line 2871: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_USER_EXIST');

2867: CLOSE c_user_exist;
2868:
2869: IF l_user_exist = 1 THEN
2870: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2871: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_USER_EXIST');
2872: FND_MSG_PUB.add;
2873: END IF;
2874: x_return_status := FND_API.g_ret_sts_error;
2875: END IF;

Line 2918: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_INV_DATES');

2914:
2915: IF l_start_date > l_end_date THEN
2916: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2917: THEN
2918: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_INV_DATES');
2919: FND_MSG_PUB.add;
2920: END IF;
2921: x_return_status := FND_API.g_ret_sts_error;
2922: END IF;

Line 2995: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

2991: FETCH c_Access INTO l_Access_rec;
2992: IF c_Access%NOTFOUND THEN
2993: CLOSE c_Access;
2994: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2995: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2996: FND_MSG_PUB.add;
2997: END IF;
2998: RAISE FND_API.g_exc_error;
2999: END IF;