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 146: FND_MESSAGE.set_name('AMS', 'AMS_RUN_ACCESS_REFRESH_PROGRAM');

142:
143: OPEN c_group_exists;
144: FETCH c_group_exists INTO l_group_exists;
145: IF p_access_rec.arc_user_or_role_type = 'GROUP' AND c_group_exists%NOTFOUND THEN
146: FND_MESSAGE.set_name('AMS', 'AMS_RUN_ACCESS_REFRESH_PROGRAM');
147: FND_MSG_PUB.add;
148: RAISE FND_API.g_exc_error;
149: END IF;
150: CLOSE c_group_exists;

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

216: x_msg_data => x_msg_data
217: );
218:
219: IF l_return_status = FND_API.g_ret_sts_error THEN
220: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
221: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
222: FND_MSG_PUB.add;
223: RAISE FND_API.g_exc_error;
224: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

217: );
218:
219: IF l_return_status = FND_API.g_ret_sts_error THEN
220: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
221: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
222: FND_MSG_PUB.add;
223: RAISE FND_API.g_exc_error;
224: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
225: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

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

221: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
222: FND_MSG_PUB.add;
223: RAISE FND_API.g_exc_error;
224: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
225: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
226: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
227: FND_MSG_PUB.add;
228: RAISE FND_API.g_exc_unexpected_error;
229: END IF;

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

222: FND_MSG_PUB.add;
223: RAISE FND_API.g_exc_error;
224: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
225: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
226: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
227: FND_MSG_PUB.add;
228: RAISE FND_API.g_exc_unexpected_error;
229: END IF;
230:

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

324: x_msg_data => x_msg_data
325: );
326:
327: IF l_return_status = FND_API.g_ret_sts_error THEN
328: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
329: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
330: FND_MSG_PUB.add;
331: RAISE FND_API.g_exc_error;
332: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

325: );
326:
327: IF l_return_status = FND_API.g_ret_sts_error THEN
328: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
329: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
330: FND_MSG_PUB.add;
331: RAISE FND_API.g_exc_error;
332: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
333: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

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

329: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
330: FND_MSG_PUB.add;
331: RAISE FND_API.g_exc_error;
332: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
333: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
334: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
335: FND_MSG_PUB.add;
336: RAISE FND_API.g_exc_unexpected_error;
337: END IF;

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

330: FND_MSG_PUB.add;
331: RAISE FND_API.g_exc_error;
332: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
333: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
334: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
335: FND_MSG_PUB.add;
336: RAISE FND_API.g_exc_unexpected_error;
337: END IF;
338:

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

531:
532: IF (SQL%NOTFOUND) THEN
533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
534: THEN
535: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
536: FND_MSG_PUB.add;
537: END IF;
538: RAISE FND_API.g_exc_error;
539: END IF;

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

566:
567: IF (SQL%NOTFOUND) THEN
568: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
569: THEN
570: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
571: FND_MSG_PUB.add;
572: END IF;
573: RAISE FND_API.g_exc_error;
574: END IF;

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

583: x_msg_data => x_msg_data
584: );
585:
586: IF l_return_status = FND_API.g_ret_sts_error THEN
587: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
588: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
589: FND_MSG_PUB.add;
590: RAISE FND_API.g_exc_error;
591: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

584: );
585:
586: IF l_return_status = FND_API.g_ret_sts_error THEN
587: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
588: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
589: FND_MSG_PUB.add;
590: RAISE FND_API.g_exc_error;
591: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
592: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

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

588: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
589: FND_MSG_PUB.add;
590: RAISE FND_API.g_exc_error;
591: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
592: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
593: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
594: FND_MSG_PUB.add;
595: RAISE FND_API.g_exc_unexpected_error;
596: END IF;

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

589: FND_MSG_PUB.add;
590: RAISE FND_API.g_exc_error;
591: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
592: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
593: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
594: FND_MSG_PUB.add;
595: RAISE FND_API.g_exc_unexpected_error;
596: END IF;
597: END LOOP;

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

609: x_msg_data => x_msg_data
610: );
611:
612: IF l_return_status = FND_API.g_ret_sts_error THEN
613: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
614: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
615: FND_MSG_PUB.add;
616: RAISE FND_API.g_exc_error;
617: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

610: );
611:
612: IF l_return_status = FND_API.g_ret_sts_error THEN
613: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
614: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
615: FND_MSG_PUB.add;
616: RAISE FND_API.g_exc_error;
617: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
618: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

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

614: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
615: FND_MSG_PUB.add;
616: RAISE FND_API.g_exc_error;
617: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
618: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
619: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
620: FND_MSG_PUB.add;
621: RAISE FND_API.g_exc_unexpected_error;
622: END IF;

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

615: FND_MSG_PUB.add;
616: RAISE FND_API.g_exc_error;
617: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
618: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
619: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
620: FND_MSG_PUB.add;
621: RAISE FND_API.g_exc_unexpected_error;
622: END IF;
623:

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

633:
634: IF (SQL%NOTFOUND) THEN
635: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
636: THEN
637: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
638: FND_MSG_PUB.add;
639: END IF;
640: RAISE FND_API.g_exc_error;
641: END IF;

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

671:
672: IF (SQL%NOTFOUND) THEN
673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
674: THEN
675: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
676: FND_MSG_PUB.add;
677: END IF;
678: RAISE FND_API.g_exc_error;
679: END IF;

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

843: FETCH c_access_b INTO l_access_id;
844: IF (c_access_b%NOTFOUND) THEN
845: CLOSE c_access_b;
846: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
847: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
848: FND_MSG_PUB.add;
849: END IF;
850: RAISE FND_API.g_exc_error;
851: END IF;

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

869:
870: WHEN AMS_Utility_PVT.resource_locked THEN
871: x_return_status := FND_API.g_ret_sts_error;
872: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
873: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
874: FND_MSG_PUB.add;
875: END IF;
876:
877: FND_MSG_PUB.count_and_get(

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

1045: AND object_version_number = l_access_rec.object_version_number;
1046:
1047: IF (SQL%NOTFOUND) THEN
1048: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1049: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1050: FND_MSG_PUB.add;
1051: END IF;
1052: RAISE FND_API.g_exc_error;
1053: END IF;

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

1080: WHERE activity_access_id = l_key_id;
1081:
1082: IF (SQL%NOTFOUND) THEN
1083: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1084: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1085: FND_MSG_PUB.add;
1086: END IF;
1087: RAISE FND_API.g_exc_error;
1088: END IF;

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

1097: x_msg_data => x_msg_data
1098: );
1099:
1100: IF l_return_status = FND_API.g_ret_sts_error THEN
1101: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1102: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1103: FND_MSG_PUB.add;
1104: RAISE FND_API.g_exc_error;
1105: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

1098: );
1099:
1100: IF l_return_status = FND_API.g_ret_sts_error THEN
1101: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1102: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1103: FND_MSG_PUB.add;
1104: RAISE FND_API.g_exc_error;
1105: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1106: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');

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

1102: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1103: FND_MSG_PUB.add;
1104: RAISE FND_API.g_exc_error;
1105: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1106: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1107: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1108: FND_MSG_PUB.add;
1109: RAISE FND_API.g_exc_unexpected_error;
1110: END IF;

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

1103: FND_MSG_PUB.add;
1104: RAISE FND_API.g_exc_error;
1105: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1106: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1107: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1108: FND_MSG_PUB.add;
1109: RAISE FND_API.g_exc_unexpected_error;
1110: END IF;
1111:

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

1127: x_msg_data => x_msg_data
1128: );
1129:
1130: IF l_return_status = FND_API.g_ret_sts_error THEN
1131: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1132: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1133: FND_MSG_PUB.add;
1134: RAISE FND_API.g_exc_error;
1135: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

1128: );
1129:
1130: IF l_return_status = FND_API.g_ret_sts_error THEN
1131: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1132: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1133: FND_MSG_PUB.add;
1134: RAISE FND_API.g_exc_error;
1135: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1136: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');

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

1132: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1133: FND_MSG_PUB.add;
1134: RAISE FND_API.g_exc_error;
1135: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1136: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1137: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1138: FND_MSG_PUB.add;
1139: RAISE FND_API.g_exc_unexpected_error;
1140: END IF;

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

1133: FND_MSG_PUB.add;
1134: RAISE FND_API.g_exc_error;
1135: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1136: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_PROCESS_FAILED');
1137: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1138: FND_MSG_PUB.add;
1139: RAISE FND_API.g_exc_unexpected_error;
1140: END IF;
1141:

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

1151: x_msg_data => x_msg_data
1152: );
1153:
1154: IF l_return_status = FND_API.g_ret_sts_error THEN
1155: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1156: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1157: FND_MSG_PUB.add;
1158: RAISE FND_API.g_exc_error;
1159: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

1152: );
1153:
1154: IF l_return_status = FND_API.g_ret_sts_error THEN
1155: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1156: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1157: FND_MSG_PUB.add;
1158: RAISE FND_API.g_exc_error;
1159: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1160: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

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

1156: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1157: FND_MSG_PUB.add;
1158: RAISE FND_API.g_exc_error;
1159: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1160: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1161: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1162: FND_MSG_PUB.add;
1163: RAISE FND_API.g_exc_unexpected_error;
1164: END IF;

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

1157: FND_MSG_PUB.add;
1158: RAISE FND_API.g_exc_error;
1159: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1160: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1161: -- FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1162: FND_MSG_PUB.add;
1163: RAISE FND_API.g_exc_unexpected_error;
1164: END IF;
1165:

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

1173: x_msg_data => x_msg_data
1174: );
1175:
1176: IF l_return_status = FND_API.g_ret_sts_error THEN
1177: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1178: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1179: FND_MSG_PUB.add;
1180: RAISE FND_API.g_exc_error;
1181: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

1174: );
1175:
1176: IF l_return_status = FND_API.g_ret_sts_error THEN
1177: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1178: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1179: FND_MSG_PUB.add;
1180: RAISE FND_API.g_exc_error;
1181: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1182: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

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

1178: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1179: FND_MSG_PUB.add;
1180: RAISE FND_API.g_exc_error;
1181: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1182: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1183: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1184: FND_MSG_PUB.add;
1185: RAISE FND_API.g_exc_unexpected_error;
1186: END IF;

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

1179: FND_MSG_PUB.add;
1180: RAISE FND_API.g_exc_error;
1181: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1182: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1183: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1184: FND_MSG_PUB.add;
1185: RAISE FND_API.g_exc_unexpected_error;
1186: END IF;
1187: END IF;

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

1349: AND owner_flag = 'Y';
1350:
1351: IF (SQL%NOTFOUND) THEN
1352: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1353: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1354: FND_MSG_PUB.add;
1355: END IF;
1356: RAISE FND_API.g_exc_error;
1357: END IF;

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

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

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

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

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

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

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

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

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

1389: x_msg_data => x_msg_data
1390: );
1391:
1392: IF l_return_status = FND_API.g_ret_sts_error THEN
1393: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1394: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1395: FND_MSG_PUB.add;
1396: RAISE FND_API.g_exc_error;
1397: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

1390: );
1391:
1392: IF l_return_status = FND_API.g_ret_sts_error THEN
1393: FND_MESSAGE.set_name('AMS', 'AMS_DENORM_PROCESS_FAILED');
1394: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1395: FND_MSG_PUB.add;
1396: RAISE FND_API.g_exc_error;
1397: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1398: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');

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

1394: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1395: FND_MSG_PUB.add;
1396: RAISE FND_API.g_exc_error;
1397: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1398: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1399: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1400: FND_MSG_PUB.add;
1401: RAISE FND_API.g_exc_unexpected_error;
1402: END IF;

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

1395: FND_MSG_PUB.add;
1396: RAISE FND_API.g_exc_error;
1397: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1398: FND_MESSAGE.set_name('AMS', 'AMS_INSERT_DENORM_FAILED');
1399: --FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
1400: FND_MSG_PUB.add;
1401: RAISE FND_API.g_exc_unexpected_error;
1402: END IF;
1403:

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

1560: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1561: THEN
1562: IF (p_access_rec.arc_user_or_role_type = 'USER')
1563: THEN
1564: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUP_USER');
1565: ELSE
1566: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUP_GRP');
1567: END IF;
1568: FND_MSG_PUB.add;

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

1562: IF (p_access_rec.arc_user_or_role_type = 'USER')
1563: THEN
1564: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUP_USER');
1565: ELSE
1566: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUP_GRP');
1567: END IF;
1568: FND_MSG_PUB.add;
1569: END IF;
1570: CLOSE c_check_dup;

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

2071: ------------------------ user_status_id --------------------------
2072: IF p_Access_rec.act_access_to_object_id IS NULL THEN
2073: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2074: THEN
2075: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_OBJECT_ID');
2076: FND_MSG_PUB.add;
2077: END IF;
2078:
2079: x_return_status := FND_API.g_ret_sts_error;

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

2082:
2083: IF p_Access_rec.arc_act_access_to_object IS NULL THEN
2084: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2085: THEN
2086: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_OBJECT');
2087: FND_MSG_PUB.add;
2088: END IF;
2089:
2090: x_return_status := FND_API.g_ret_sts_error;

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

2093:
2094: IF p_Access_rec.user_or_role_id IS NULL THEN
2095: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2096: THEN
2097: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_UR_ID');
2098: FND_MSG_PUB.add;
2099: END IF;
2100:
2101: x_return_status := FND_API.g_ret_sts_error;

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

2104:
2105: IF p_Access_rec.arc_user_or_role_type IS NULL THEN
2106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2107: THEN
2108: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_NO_UR_TYPE');
2109: FND_MSG_PUB.add;
2110: END IF;
2111:
2112: x_return_status := FND_API.g_ret_sts_error;

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

2132:
2133: if (c1%FOUND) then
2134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2135: THEN
2136: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUP_USER');
2137: FND_MSG_PUB.add;
2138: END IF;
2139: x_return_status := FND_API.g_ret_sts_error;
2140: RETURN;

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

2179: ) = FND_API.g_false
2180: THEN
2181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2182: THEN
2183: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_DUPLICATE_ID');
2184: FND_MSG_PUB.add;
2185: END IF;
2186: x_return_status := FND_API.g_ret_sts_error;
2187: RETURN;

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

2219: ) = FND_API.g_false
2220: THEN
2221: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2222: THEN
2223: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_USER_ID');
2224: FND_MSG_PUB.add;
2225: END IF;
2226:
2227: x_return_status := FND_API.g_ret_sts_error;

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

2241: ) = FND_API.g_false
2242: THEN
2243: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2244: THEN
2245: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_GROUP_ID');
2246: FND_MSG_PUB.add;
2247: END IF;
2248:
2249: x_return_status := FND_API.g_ret_sts_error;

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

2314: ) = FND_API.g_false
2315: THEN
2316: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2317: THEN
2318: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_SYS_ARC');
2319: FND_MSG_PUB.add;
2320: END IF;
2321: x_return_status := FND_API.g_ret_sts_error;
2322: RETURN;

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

2341: ) = FND_API.g_false
2342: THEN
2343: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2344: THEN
2345: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_USER_TYPE');
2346: FND_MSG_PUB.add;
2347: END IF;
2348:
2349: x_return_status := FND_API.g_ret_sts_error;

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

2377: IF AMS_Utility_PVT.is_Y_or_N(p_access_rec.admin_flag) = FND_API.g_false
2378: THEN
2379: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2380: THEN
2381: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_BAD_ADMIN_FLAG');
2382: FND_MSG_PUB.add;
2383: END IF;
2384:
2385: x_return_status := FND_API.g_ret_sts_error;

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

2524: CLOSE c_user_exist;
2525:
2526: IF l_user_exist = 1 THEN
2527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2528: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_USER_EXIST');
2529: FND_MSG_PUB.add;
2530: END IF;
2531: x_return_status := FND_API.g_ret_sts_error;
2532: END IF;

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

2571:
2572: IF l_start_date > l_end_date THEN
2573: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2574: THEN
2575: FND_MESSAGE.set_name('AMS', 'AMS_ACCESS_INV_DATES');
2576: FND_MSG_PUB.add;
2577: END IF;
2578: x_return_status := FND_API.g_ret_sts_error;
2579: END IF;

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

2648: FETCH c_Access INTO l_Access_rec;
2649: IF c_Access%NOTFOUND THEN
2650: CLOSE c_Access;
2651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2652: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2653: FND_MSG_PUB.add;
2654: END IF;
2655: RAISE FND_API.g_exc_error;
2656: END IF;