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

Line 13: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

9: -- History
10: -- 01/24/2000 julou created
11: -- 01/31/2000 mpande modified delete procedure for cascade delete
12: -------------------------------------------------------------------------------
13: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
16:
17: PROCEDURE create_list_word_replace

Line 14: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

10: -- 01/24/2000 julou created
11: -- 01/31/2000 mpande modified delete procedure for cascade delete
12: -------------------------------------------------------------------------------
13: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
16:
17: PROCEDURE create_list_word_replace
18: (

Line 15: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

11: -- 01/31/2000 mpande modified delete procedure for cascade delete
12: -------------------------------------------------------------------------------
13: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
16:
17: PROCEDURE create_list_word_replace
18: (
19: p_api_version IN NUMBER,

Line 54: FND_MSG_PUB.initialize;

50: -- initialize
51: SAVEPOINT create_list_word_replace;
52:
53: IF FND_API.to_boolean(p_init_msg_list) THEN
54: FND_MSG_PUB.initialize;
55: END IF;
56:
57:
58: IF (AMS_DEBUG_HIGH_ON) THEN

Line 160: FND_MSG_PUB.count_and_get

156: IF FND_API.to_boolean(p_commit) THEN
157: COMMIT;
158: END IF;
159:
160: FND_MSG_PUB.count_and_get
161: (
162: p_encoded => FND_API.g_false,
163: p_count => x_msg_count,
164: p_data => x_msg_data

Line 180: FND_MSG_PUB.count_and_get

176:
177: WHEN FND_API.g_exc_error THEN
178: ROLLBACK TO create_list_word_replace;
179: x_return_status := FND_API.g_ret_sts_error;
180: FND_MSG_PUB.count_and_get
181: (
182: p_encoded => FND_API.g_false,
183: p_count => x_msg_count,
184: p_data => x_msg_data

Line 190: FND_MSG_PUB.count_and_get

186:
187: WHEN FND_API.g_exc_unexpected_error THEN
188: ROLLBACK TO create_list_word_replace;
189: x_return_status := FND_API.g_ret_sts_unexp_error;
190: FND_MSG_PUB.count_and_get
191: (
192: p_encoded => FND_API.g_false,
193: p_count => x_msg_count,
194: p_data => x_msg_data

Line 200: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

196:
197: WHEN OTHERS THEN
198: ROLLBACK TO create_list_word_replace;
199: x_return_status :=FND_API.g_ret_sts_unexp_error;
200: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
201: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
202: END IF;
203: FND_MSG_PUB.count_and_get
204: (

Line 201: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

197: WHEN OTHERS THEN
198: ROLLBACK TO create_list_word_replace;
199: x_return_status :=FND_API.g_ret_sts_unexp_error;
200: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
201: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
202: END IF;
203: FND_MSG_PUB.count_and_get
204: (
205: p_encoded => FND_API.g_false,

Line 203: FND_MSG_PUB.count_and_get

199: x_return_status :=FND_API.g_ret_sts_unexp_error;
200: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
201: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
202: END IF;
203: FND_MSG_PUB.count_and_get
204: (
205: p_encoded => FND_API.g_false,
206: p_count => x_msg_count,
207: p_data => x_msg_data

Line 246: FND_MSG_PUB.initialize;

242: -- initialize
243: SAVEPOINT update_list_word_replace;
244:
245: IF FND_API.to_boolean(p_init_msg_list) THEN
246: FND_MSG_PUB.initialize;
247: END IF;
248:
249: IF (AMS_DEBUG_HIGH_ON) THEN
250:

Line 319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

315: WHERE list_word_replaces_id = l_wrd_rpl_rec.list_word_replaces_id
316: AND object_version_number = l_wrd_rpl_rec.object_version_number;
317:
318: IF (SQL%NOTFOUND) THEN
319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
320: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
321: FND_MSG_PUB.add;
322: END IF;
323: RAISE FND_API.g_exc_error;

Line 321: FND_MSG_PUB.add;

317:
318: IF (SQL%NOTFOUND) THEN
319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
320: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
321: FND_MSG_PUB.add;
322: END IF;
323: RAISE FND_API.g_exc_error;
324: END IF;
325:

Line 331: FND_MSG_PUB.count_and_get

327: IF FND_API.to_boolean(p_commit) THEN
328: COMMIT;
329: END IF;
330:
331: FND_MSG_PUB.count_and_get
332: (
333: P_ENCODED => FND_API.g_false,
334: p_count => x_msg_count,
335: p_data => x_msg_data

Line 351: FND_MSG_PUB.count_and_get

347:
348: WHEN FND_API.g_exc_error THEN
349: ROLLBACK TO update_list_word_replace;
350: x_return_status := FND_API.g_ret_sts_error;
351: FND_MSG_PUB.count_and_get
352: (
353: p_encoded => FND_API.g_false,
354: p_count => x_msg_count,
355: p_data => x_msg_data

Line 361: FND_MSG_PUB.count_and_get

357:
358: WHEN FND_API.g_exc_unexpected_error THEN
359: ROLLBACK TO update_list_word_replace;
360: x_return_status := FND_API.g_ret_sts_unexp_error;
361: FND_MSG_PUB.count_and_get
362: (
363: p_encoded => FND_API.g_false,
364: p_count => x_msg_count,
365: p_data => x_msg_data

Line 371: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

367:
368: WHEN OTHERS THEN
369: ROLLBACK TO update_list_word_replace;
370: x_return_status :=FND_API.g_ret_sts_unexp_error;
371: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
372: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
373: END IF;
374: FND_MSG_PUB.count_and_get
375: (

Line 372: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

368: WHEN OTHERS THEN
369: ROLLBACK TO update_list_word_replace;
370: x_return_status :=FND_API.g_ret_sts_unexp_error;
371: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
372: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
373: END IF;
374: FND_MSG_PUB.count_and_get
375: (
376: p_encoded => FND_API.g_false,

Line 374: FND_MSG_PUB.count_and_get

370: x_return_status :=FND_API.g_ret_sts_unexp_error;
371: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
372: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
373: END IF;
374: FND_MSG_PUB.count_and_get
375: (
376: p_encoded => FND_API.g_false,
377: p_count => x_msg_count,
378: p_data => x_msg_data

Line 430: FND_MSG_PUB.initialize;

426:
427: END IF;
428:
429: IF FND_API.to_boolean(p_init_msg_list) THEN
430: FND_MSG_PUB.initialize;
431: END IF;
432:
433: IF NOT FND_API.compatible_api_call
434: (

Line 457: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

453: WHERE list_word_replaces_id = p_wrd_rpl_id
454: AND object_version_number = p_object_version;
455:
456: IF (SQL%NOTFOUND) THEN
457: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
458: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
459: FND_MSG_PUB.add;
460: END IF;
461: RAISE FND_API.g_exc_error;

Line 459: FND_MSG_PUB.add;

455:
456: IF (SQL%NOTFOUND) THEN
457: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
458: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
459: FND_MSG_PUB.add;
460: END IF;
461: RAISE FND_API.g_exc_error;
462: END IF;
463: IF (AMS_DEBUG_HIGH_ON) THEN

Line 494: FND_MSG_PUB.count_and_get

490: IF FND_API.to_boolean(p_commit) THEN
491: COMMIT;
492: END IF;
493:
494: FND_MSG_PUB.count_and_get
495: (
496: P_ENCODED => FND_API.g_false,
497: p_count => x_msg_count,
498: p_data => x_msg_data

Line 514: FND_MSG_PUB.count_and_get

510:
511: WHEN FND_API.g_exc_error THEN
512: ROLLBACK TO delete_list_word_replace;
513: x_return_status := FND_API.g_ret_sts_error;
514: FND_MSG_PUB.count_and_get
515: (
516: p_encoded => FND_API.g_false,
517: p_count => x_msg_count,
518: p_data => x_msg_data

Line 524: FND_MSG_PUB.count_and_get

520:
521: WHEN FND_API.g_exc_unexpected_error THEN
522: ROLLBACK TO delete_list_word_replace;
523: x_return_status := FND_API.g_ret_sts_unexp_error;
524: FND_MSG_PUB.count_and_get
525: (
526: p_encoded => FND_API.g_false,
527: p_count => x_msg_count,
528: p_data => x_msg_data

Line 534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

530:
531: WHEN OTHERS THEN
532: ROLLBACK TO delete_list_word_replace;
533: x_return_status :=FND_API.g_ret_sts_unexp_error;
534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
535: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
536: END IF;
537: FND_MSG_PUB.count_and_get
538: (

Line 535: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

531: WHEN OTHERS THEN
532: ROLLBACK TO delete_list_word_replace;
533: x_return_status :=FND_API.g_ret_sts_unexp_error;
534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
535: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
536: END IF;
537: FND_MSG_PUB.count_and_get
538: (
539: p_encoded => FND_API.g_false,

Line 537: FND_MSG_PUB.count_and_get

533: x_return_status :=FND_API.g_ret_sts_unexp_error;
534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
535: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
536: END IF;
537: FND_MSG_PUB.count_and_get
538: (
539: p_encoded => FND_API.g_false,
540: p_count => x_msg_count,
541: p_data => x_msg_data

Line 587: FND_MSG_PUB.initialize;

583: AMS_Utility_PVT.debug_message(l_full_name || ': start');
584: END IF;
585:
586: IF FND_API.to_boolean(p_init_msg_list) THEN
587: FND_MSG_PUB.initialize;
588: END IF;
589:
590: IF NOT FND_API.compatible_api_call
591: (

Line 613: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

609: OPEN c_list_word_replace;
610: FETCH c_list_word_replace INTO l_wrd_rpl_id;
611: IF (c_list_word_replace%NOTFOUND) THEN
612: CLOSE c_list_word_replace;
613: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
614: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
615: FND_MSG_PUB.add;
616: END IF;
617: RAISE FND_API.g_exc_error;

Line 615: FND_MSG_PUB.add;

611: IF (c_list_word_replace%NOTFOUND) THEN
612: CLOSE c_list_word_replace;
613: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
614: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
615: FND_MSG_PUB.add;
616: END IF;
617: RAISE FND_API.g_exc_error;
618: END IF;
619: CLOSE c_list_word_replace;

Line 622: FND_MSG_PUB.count_and_get

618: END IF;
619: CLOSE c_list_word_replace;
620:
621: -- finish
622: FND_MSG_PUB.count_and_get
623: (
624: p_encoded => FND_API.g_false,
625: p_count => x_msg_count,
626: p_data => x_msg_data

Line 641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

637: EXCEPTION
638:
639: WHEN AMS_Utility_PVT.resource_locked THEN
640: x_return_status := FND_API.g_ret_sts_error;
641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
642: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
643: FND_MSG_PUB.add;
644: END IF;
645: FND_MSG_PUB.count_and_get

Line 643: FND_MSG_PUB.add;

639: WHEN AMS_Utility_PVT.resource_locked THEN
640: x_return_status := FND_API.g_ret_sts_error;
641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
642: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
643: FND_MSG_PUB.add;
644: END IF;
645: FND_MSG_PUB.count_and_get
646: (
647: p_encoded => FND_API.g_false,

Line 645: FND_MSG_PUB.count_and_get

641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
642: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
643: FND_MSG_PUB.add;
644: END IF;
645: FND_MSG_PUB.count_and_get
646: (
647: p_encoded => FND_API.g_false,
648: p_count => x_msg_count,
649: p_data => x_msg_data

Line 654: FND_MSG_PUB.count_and_get

650: );
651:
652: WHEN FND_API.g_exc_error THEN
653: x_return_status := FND_API.g_ret_sts_error;
654: FND_MSG_PUB.count_and_get
655: (
656: p_encoded => FND_API.g_false,
657: p_count => x_msg_count,
658: p_data => x_msg_data

Line 663: FND_MSG_PUB.count_and_get

659: );
660:
661: WHEN FND_API.g_exc_unexpected_error THEN
662: x_return_status := FND_API.g_ret_sts_unexp_error;
663: FND_MSG_PUB.count_and_get
664: (
665: p_encoded => FND_API.g_false,
666: p_count => x_msg_count,
667: p_data => x_msg_data

Line 672: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

668: );
669:
670: WHEN OTHERS THEN
671: x_return_status :=FND_API.g_ret_sts_unexp_error;
672: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
673: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
674: END IF;
675: FND_MSG_PUB.count_and_get
676: (

Line 673: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

669:
670: WHEN OTHERS THEN
671: x_return_status :=FND_API.g_ret_sts_unexp_error;
672: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
673: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
674: END IF;
675: FND_MSG_PUB.count_and_get
676: (
677: p_encoded => FND_API.g_false,

Line 675: FND_MSG_PUB.count_and_get

671: x_return_status :=FND_API.g_ret_sts_unexp_error;
672: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
673: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
674: END IF;
675: FND_MSG_PUB.count_and_get
676: (
677: p_encoded => FND_API.g_false,
678: p_count => x_msg_count,
679: p_data => x_msg_data

Line 756: FND_MSG_PUB.count_and_get

752:
753: -- record level
754:
755: -------------------- finish --------------------------
756: FND_MSG_PUB.count_and_get
757: (
758: p_encoded => FND_API.g_false,
759: p_count => x_msg_count,
760: p_data => x_msg_data

Line 774: FND_MSG_PUB.count_and_get

770:
771: EXCEPTION
772: WHEN FND_API.g_exc_error THEN
773: x_return_status := FND_API.g_ret_sts_error;
774: FND_MSG_PUB.count_and_get
775: (
776: p_encoded => FND_API.g_false,
777: p_count => x_msg_count,
778: p_data => x_msg_data

Line 783: FND_MSG_PUB.count_and_get

779: );
780:
781: WHEN FND_API.g_exc_unexpected_error THEN
782: x_return_status := FND_API.g_ret_sts_unexp_error ;
783: FND_MSG_PUB.count_and_get
784: (
785: p_encoded => FND_API.g_false,
786: p_count => x_msg_count,
787: p_data => x_msg_data

Line 792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

788: );
789:
790: WHEN OTHERS THEN
791: x_return_status := FND_API.g_ret_sts_unexp_error;
792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
793: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
794: END IF;
795:
796: FND_MSG_PUB.count_and_get

Line 793: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

789:
790: WHEN OTHERS THEN
791: x_return_status := FND_API.g_ret_sts_unexp_error;
792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
793: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
794: END IF;
795:
796: FND_MSG_PUB.count_and_get
797: (

Line 796: FND_MSG_PUB.count_and_get

792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
793: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
794: END IF;
795:
796: FND_MSG_PUB.count_and_get
797: (
798: p_encoded => FND_API.g_false,
799: p_count => x_msg_count,
800: p_data => x_msg_data

Line 888: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

884:
885: -- check list_word_replaces_id
886: IF p_wrd_rpl_rec.list_word_replaces_id IS NULL
887: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
888: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
889: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_REPLACES_NO_ID');
890: FND_MSG_PUB.add;
891: END IF;
892:

Line 890: FND_MSG_PUB.add;

886: IF p_wrd_rpl_rec.list_word_replaces_id IS NULL
887: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
888: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
889: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_REPLACES_NO_ID');
890: FND_MSG_PUB.add;
891: END IF;
892:
893: x_return_status := FND_API.g_ret_sts_error;
894: RETURN;

Line 901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

897: -- check object_version_number
898: IF p_wrd_rpl_rec.object_version_number IS NULL
899: AND p_validation_mode = JTF_PLSQL_API.g_update
900: THEN
901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
902: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
903: FND_MSG_PUB.add;
904: END IF;
905:

Line 903: FND_MSG_PUB.add;

899: AND p_validation_mode = JTF_PLSQL_API.g_update
900: THEN
901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
902: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
903: FND_MSG_PUB.add;
904: END IF;
905:
906: x_return_status := FND_API.g_ret_sts_error;
907: RETURN;

Line 912: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

908: END IF;
909:
910: -- check original_word
911: IF p_wrd_rpl_rec.original_word IS NULL THEN
912: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
913: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ORG_WRD');
914: FND_MSG_PUB.add;
915: END IF;
916:

Line 914: FND_MSG_PUB.add;

910: -- check original_word
911: IF p_wrd_rpl_rec.original_word IS NULL THEN
912: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
913: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ORG_WRD');
914: FND_MSG_PUB.add;
915: END IF;
916:
917: x_return_status := FND_API.g_ret_sts_error;
918: RETURN;

Line 923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

919: END IF;
920:
921: -- check replacement_word
922: IF p_wrd_rpl_rec.replacement_word IS NULL THEN
923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
924: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_RPL_WRD');
925: FND_MSG_PUB.add;
926: END IF;
927:

Line 925: FND_MSG_PUB.add;

921: -- check replacement_word
922: IF p_wrd_rpl_rec.replacement_word IS NULL THEN
923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
924: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_RPL_WRD');
925: FND_MSG_PUB.add;
926: END IF;
927:
928: x_return_status := FND_API.g_ret_sts_error;
929: RETURN;

Line 934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

930: END IF;
931:
932: -- check enabled_flag
933: IF p_wrd_rpl_rec.enabled_flag IS NULL THEN
934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
935: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');
936: FND_MSG_PUB.add;
937: END IF;
938:

Line 936: FND_MSG_PUB.add;

932: -- check enabled_flag
933: IF p_wrd_rpl_rec.enabled_flag IS NULL THEN
934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
935: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');
936: FND_MSG_PUB.add;
937: END IF;
938:
939: x_return_status := FND_API.g_ret_sts_error;
940: RETURN;

Line 946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

942:
943: IF p_wrd_rpl_rec.enabled_flag <> 'Y'
944: AND p_wrd_rpl_rec.enabled_flag <> 'N'
945: THEN
946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
947: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');
948: FND_MSG_PUB.add;
949: END IF;
950:

Line 948: FND_MSG_PUB.add;

944: AND p_wrd_rpl_rec.enabled_flag <> 'N'
945: THEN
946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
947: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');
948: FND_MSG_PUB.add;
949: END IF;
950:
951: x_return_status := FND_API.g_ret_sts_error;
952: RETURN;

Line 990: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

986: );
987: END IF;
988:
989: IF l_uk_flag = FND_API.g_false THEN
990: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
991: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_REPLACES_NO_ID');
992: FND_MSG_PUB.add;
993: END IF;
994:

Line 992: FND_MSG_PUB.add;

988:
989: IF l_uk_flag = FND_API.g_false THEN
990: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
991: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_REPLACES_NO_ID');
992: FND_MSG_PUB.add;
993: END IF;
994:
995: x_return_status := FND_API.g_ret_sts_error;
996: RETURN;

Line 1018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1014: );
1015: END IF;
1016:
1017: IF l_uk_flag = FND_API.g_false THEN
1018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1019: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_RPL_DUP_ORG_RPL');
1020: FND_MSG_PUB.add;
1021: END IF;
1022:

Line 1020: FND_MSG_PUB.add;

1016:
1017: IF l_uk_flag = FND_API.g_false THEN
1018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1019: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_RPL_DUP_ORG_RPL');
1020: FND_MSG_PUB.add;
1021: END IF;
1022:
1023: x_return_status := FND_API.g_ret_sts_error;
1024: RETURN;

Line 1057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1053: OPEN c_list_word_replace;
1054: FETCH c_list_word_replace INTO l_wrd_rpl_rec;
1055: IF (c_list_word_replace%NOTFOUND) THEN
1056: CLOSE c_list_word_replace;
1057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1058: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1059: FND_MSG_PUB.add;
1060: END IF;
1061: RAISE FND_API.g_exc_error;

Line 1059: FND_MSG_PUB.add;

1055: IF (c_list_word_replace%NOTFOUND) THEN
1056: CLOSE c_list_word_replace;
1057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1058: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1059: FND_MSG_PUB.add;
1060: END IF;
1061: RAISE FND_API.g_exc_error;
1062: END IF;
1063: CLOSE c_list_word_replace;