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

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

8: --
9: -- History
10: -- 01/24/2000 julou created
11: -------------------------------------------------------------------------------
12: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
13: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
14: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
15:
16: PROCEDURE create_list_word_field

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

9: -- History
10: -- 01/24/2000 julou created
11: -------------------------------------------------------------------------------
12: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
13: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
14: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
15:
16: PROCEDURE create_list_word_field
17: (

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

10: -- 01/24/2000 julou created
11: -------------------------------------------------------------------------------
12: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
13: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
14: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
15:
16: PROCEDURE create_list_word_field
17: (
18: p_api_version IN NUMBER,

Line 53: FND_MSG_PUB.initialize;

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

Line 165: FND_MSG_PUB.count_and_get

161: IF FND_API.to_boolean(p_commit) THEN
162: COMMIT;
163: END IF;
164:
165: FND_MSG_PUB.count_and_get
166: (
167: p_encoded => FND_API.g_false,
168: p_count => x_msg_count,
169: p_data => x_msg_data

Line 185: FND_MSG_PUB.count_and_get

181:
182: WHEN FND_API.g_exc_error THEN
183: ROLLBACK TO create_list_word_field;
184: x_return_status := FND_API.g_ret_sts_error;
185: FND_MSG_PUB.count_and_get
186: (
187: p_encoded => FND_API.g_false,
188: p_count => x_msg_count,
189: p_data => x_msg_data

Line 195: FND_MSG_PUB.count_and_get

191:
192: WHEN FND_API.g_exc_unexpected_error THEN
193: ROLLBACK TO create_list_word_field;
194: x_return_status := FND_API.g_ret_sts_unexp_error;
195: FND_MSG_PUB.count_and_get
196: (
197: p_encoded => FND_API.g_false,
198: p_count => x_msg_count,
199: p_data => x_msg_data

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

201:
202: WHEN OTHERS THEN
203: ROLLBACK TO create_list_word_field;
204: x_return_status :=FND_API.g_ret_sts_unexp_error;
205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
206: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
207: END IF;
208: FND_MSG_PUB.count_and_get
209: (

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

202: WHEN OTHERS THEN
203: ROLLBACK TO create_list_word_field;
204: x_return_status :=FND_API.g_ret_sts_unexp_error;
205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
206: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
207: END IF;
208: FND_MSG_PUB.count_and_get
209: (
210: p_encoded => FND_API.g_false,

Line 208: FND_MSG_PUB.count_and_get

204: x_return_status :=FND_API.g_ret_sts_unexp_error;
205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
206: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
207: END IF;
208: FND_MSG_PUB.count_and_get
209: (
210: p_encoded => FND_API.g_false,
211: p_count => x_msg_count,
212: p_data => x_msg_data

Line 251: FND_MSG_PUB.initialize;

247: -- initialize
248: SAVEPOINT update_list_word_field;
249:
250: IF FND_API.to_boolean(p_init_msg_list) THEN
251: FND_MSG_PUB.initialize;
252: END IF;
253:
254: IF (AMS_DEBUG_HIGH_ON) THEN
255:

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

323: WHERE list_word_field_id = l_wrd_fld_rec.list_word_field_id
324: AND object_version_number = l_wrd_fld_rec.object_version_number;
325:
326: IF (SQL%NOTFOUND) THEN
327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
328: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
329: FND_MSG_PUB.add;
330: END IF;
331: RAISE FND_API.g_exc_error;

Line 329: FND_MSG_PUB.add;

325:
326: IF (SQL%NOTFOUND) THEN
327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
328: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
329: FND_MSG_PUB.add;
330: END IF;
331: RAISE FND_API.g_exc_error;
332: END IF;
333:

Line 339: FND_MSG_PUB.count_and_get

335: IF FND_API.to_boolean(p_commit) THEN
336: COMMIT;
337: END IF;
338:
339: FND_MSG_PUB.count_and_get
340: (
341: P_ENCODED => FND_API.g_false,
342: p_count => x_msg_count,
343: p_data => x_msg_data

Line 359: FND_MSG_PUB.count_and_get

355:
356: WHEN FND_API.g_exc_error THEN
357: ROLLBACK TO update_list_word_field;
358: x_return_status := FND_API.g_ret_sts_error;
359: FND_MSG_PUB.count_and_get
360: (
361: p_encoded => FND_API.g_false,
362: p_count => x_msg_count,
363: p_data => x_msg_data

Line 369: FND_MSG_PUB.count_and_get

365:
366: WHEN FND_API.g_exc_unexpected_error THEN
367: ROLLBACK TO update_list_word_field;
368: x_return_status := FND_API.g_ret_sts_unexp_error;
369: FND_MSG_PUB.count_and_get
370: (
371: p_encoded => FND_API.g_false,
372: p_count => x_msg_count,
373: p_data => x_msg_data

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

375:
376: WHEN OTHERS THEN
377: ROLLBACK TO update_list_word_field;
378: x_return_status :=FND_API.g_ret_sts_unexp_error;
379: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
380: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
381: END IF;
382: FND_MSG_PUB.count_and_get
383: (

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

376: WHEN OTHERS THEN
377: ROLLBACK TO update_list_word_field;
378: x_return_status :=FND_API.g_ret_sts_unexp_error;
379: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
380: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
381: END IF;
382: FND_MSG_PUB.count_and_get
383: (
384: p_encoded => FND_API.g_false,

Line 382: FND_MSG_PUB.count_and_get

378: x_return_status :=FND_API.g_ret_sts_unexp_error;
379: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
380: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
381: END IF;
382: FND_MSG_PUB.count_and_get
383: (
384: p_encoded => FND_API.g_false,
385: p_count => x_msg_count,
386: 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_field_id = p_wrd_fld_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:

Line 469: FND_MSG_PUB.count_and_get

465: IF FND_API.to_boolean(p_commit) THEN
466: COMMIT;
467: END IF;
468:
469: FND_MSG_PUB.count_and_get
470: (
471: P_ENCODED => FND_API.g_false,
472: p_count => x_msg_count,
473: p_data => x_msg_data

Line 489: FND_MSG_PUB.count_and_get

485:
486: WHEN FND_API.g_exc_error THEN
487: ROLLBACK TO delete_list_word_field;
488: x_return_status := FND_API.g_ret_sts_error;
489: FND_MSG_PUB.count_and_get
490: (
491: p_encoded => FND_API.g_false,
492: p_count => x_msg_count,
493: p_data => x_msg_data

Line 499: FND_MSG_PUB.count_and_get

495:
496: WHEN FND_API.g_exc_unexpected_error THEN
497: ROLLBACK TO delete_list_word_field;
498: x_return_status := FND_API.g_ret_sts_unexp_error;
499: FND_MSG_PUB.count_and_get
500: (
501: p_encoded => FND_API.g_false,
502: p_count => x_msg_count,
503: p_data => x_msg_data

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

505:
506: WHEN OTHERS THEN
507: ROLLBACK TO delete_list_word_field;
508: x_return_status :=FND_API.g_ret_sts_unexp_error;
509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
510: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
511: END IF;
512: FND_MSG_PUB.count_and_get
513: (

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

506: WHEN OTHERS THEN
507: ROLLBACK TO delete_list_word_field;
508: x_return_status :=FND_API.g_ret_sts_unexp_error;
509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
510: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
511: END IF;
512: FND_MSG_PUB.count_and_get
513: (
514: p_encoded => FND_API.g_false,

Line 512: FND_MSG_PUB.count_and_get

508: x_return_status :=FND_API.g_ret_sts_unexp_error;
509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
510: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
511: END IF;
512: FND_MSG_PUB.count_and_get
513: (
514: p_encoded => FND_API.g_false,
515: p_count => x_msg_count,
516: p_data => x_msg_data

Line 562: FND_MSG_PUB.initialize;

558: AMS_Utility_PVT.debug_message(l_full_name || ': start');
559: END IF;
560:
561: IF FND_API.to_boolean(p_init_msg_list) THEN
562: FND_MSG_PUB.initialize;
563: END IF;
564:
565: IF NOT FND_API.compatible_api_call
566: (

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

584: OPEN c_list_word_field;
585: FETCH c_list_word_field INTO l_wrd_fld_id;
586: IF (c_list_word_field%NOTFOUND) THEN
587: CLOSE c_list_word_field;
588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
589: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
590: FND_MSG_PUB.add;
591: END IF;
592: RAISE FND_API.g_exc_error;

Line 590: FND_MSG_PUB.add;

586: IF (c_list_word_field%NOTFOUND) THEN
587: CLOSE c_list_word_field;
588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
589: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
590: FND_MSG_PUB.add;
591: END IF;
592: RAISE FND_API.g_exc_error;
593: END IF;
594: CLOSE c_list_word_field;

Line 597: FND_MSG_PUB.count_and_get

593: END IF;
594: CLOSE c_list_word_field;
595:
596: -- finish
597: FND_MSG_PUB.count_and_get
598: (
599: p_encoded => FND_API.g_false,
600: p_count => x_msg_count,
601: p_data => x_msg_data

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

612: EXCEPTION
613:
614: WHEN AMS_Utility_PVT.resource_locked THEN
615: x_return_status := FND_API.g_ret_sts_error;
616: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
617: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
618: FND_MSG_PUB.add;
619: END IF;
620: FND_MSG_PUB.count_and_get

Line 618: FND_MSG_PUB.add;

614: WHEN AMS_Utility_PVT.resource_locked THEN
615: x_return_status := FND_API.g_ret_sts_error;
616: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
617: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
618: FND_MSG_PUB.add;
619: END IF;
620: FND_MSG_PUB.count_and_get
621: (
622: p_encoded => FND_API.g_false,

Line 620: FND_MSG_PUB.count_and_get

616: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
617: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
618: FND_MSG_PUB.add;
619: END IF;
620: FND_MSG_PUB.count_and_get
621: (
622: p_encoded => FND_API.g_false,
623: p_count => x_msg_count,
624: p_data => x_msg_data

Line 629: FND_MSG_PUB.count_and_get

625: );
626:
627: WHEN FND_API.g_exc_error THEN
628: x_return_status := FND_API.g_ret_sts_error;
629: FND_MSG_PUB.count_and_get
630: (
631: p_encoded => FND_API.g_false,
632: p_count => x_msg_count,
633: p_data => x_msg_data

Line 638: FND_MSG_PUB.count_and_get

634: );
635:
636: WHEN FND_API.g_exc_unexpected_error THEN
637: x_return_status := FND_API.g_ret_sts_unexp_error;
638: FND_MSG_PUB.count_and_get
639: (
640: p_encoded => FND_API.g_false,
641: p_count => x_msg_count,
642: p_data => x_msg_data

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

643: );
644:
645: WHEN OTHERS THEN
646: x_return_status :=FND_API.g_ret_sts_unexp_error;
647: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
648: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
649: END IF;
650: FND_MSG_PUB.count_and_get
651: (

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

644:
645: WHEN OTHERS THEN
646: x_return_status :=FND_API.g_ret_sts_unexp_error;
647: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
648: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
649: END IF;
650: FND_MSG_PUB.count_and_get
651: (
652: p_encoded => FND_API.g_false,

Line 650: FND_MSG_PUB.count_and_get

646: x_return_status :=FND_API.g_ret_sts_unexp_error;
647: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
648: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
649: END IF;
650: FND_MSG_PUB.count_and_get
651: (
652: p_encoded => FND_API.g_false,
653: p_count => x_msg_count,
654: p_data => x_msg_data

Line 731: FND_MSG_PUB.count_and_get

727:
728: -- record level
729:
730: -------------------- finish --------------------------
731: FND_MSG_PUB.count_and_get
732: (
733: p_encoded => FND_API.g_false,
734: p_count => x_msg_count,
735: p_data => x_msg_data

Line 749: FND_MSG_PUB.count_and_get

745:
746: EXCEPTION
747: WHEN FND_API.g_exc_error THEN
748: x_return_status := FND_API.g_ret_sts_error;
749: FND_MSG_PUB.count_and_get
750: (
751: p_encoded => FND_API.g_false,
752: p_count => x_msg_count,
753: p_data => x_msg_data

Line 758: FND_MSG_PUB.count_and_get

754: );
755:
756: WHEN FND_API.g_exc_unexpected_error THEN
757: x_return_status := FND_API.g_ret_sts_unexp_error ;
758: FND_MSG_PUB.count_and_get
759: (
760: p_encoded => FND_API.g_false,
761: p_count => x_msg_count,
762: p_data => x_msg_data

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

763: );
764:
765: WHEN OTHERS THEN
766: x_return_status := FND_API.g_ret_sts_unexp_error;
767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
768: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
769: END IF;
770:
771: FND_MSG_PUB.count_and_get

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

764:
765: WHEN OTHERS THEN
766: x_return_status := FND_API.g_ret_sts_unexp_error;
767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
768: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
769: END IF;
770:
771: FND_MSG_PUB.count_and_get
772: (

Line 771: FND_MSG_PUB.count_and_get

767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
768: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
769: END IF;
770:
771: FND_MSG_PUB.count_and_get
772: (
773: p_encoded => FND_API.g_false,
774: p_count => x_msg_count,
775: p_data => x_msg_data

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

874:
875: -- check list_word_field_id
876: IF p_wrd_fld_rec.list_word_field_id IS NULL
877: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
878: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
879: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FIELDS_NO_ID');
880: FND_MSG_PUB.add;
881: END IF;
882:

Line 880: FND_MSG_PUB.add;

876: IF p_wrd_fld_rec.list_word_field_id IS NULL
877: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
878: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
879: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FIELDS_NO_ID');
880: FND_MSG_PUB.add;
881: END IF;
882:
883: x_return_status := FND_API.g_ret_sts_error;
884: RETURN;

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

887: -- check object_version_number
888: IF p_wrd_fld_rec.object_version_number IS NULL
889: AND p_validation_mode = JTF_PLSQL_API.g_update
890: THEN
891: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
892: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
893: FND_MSG_PUB.add;
894: END IF;
895:

Line 893: FND_MSG_PUB.add;

889: AND p_validation_mode = JTF_PLSQL_API.g_update
890: THEN
891: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
892: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
893: FND_MSG_PUB.add;
894: END IF;
895:
896: x_return_status := FND_API.g_ret_sts_error;
897: RETURN;

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

898: END IF;
899:
900: -- check field_table_name
901: IF p_wrd_fld_rec.field_table_name IS NULL THEN
902: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
903: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_TBL_NAME');
904: FND_MSG_PUB.add;
905: END IF;
906:

Line 904: FND_MSG_PUB.add;

900: -- check field_table_name
901: IF p_wrd_fld_rec.field_table_name IS NULL THEN
902: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
903: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_TBL_NAME');
904: FND_MSG_PUB.add;
905: END IF;
906:
907: x_return_status := FND_API.g_ret_sts_error;
908: RETURN;

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

909: END IF;
910:
911: -- check field_column_name
912: IF p_wrd_fld_rec.field_column_name IS NULL THEN
913: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
914: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_COL_NAME');
915: FND_MSG_PUB.add;
916: END IF;
917:

Line 915: FND_MSG_PUB.add;

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

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

920: END IF;
921:
922: -- check list_word_replaces_id
923: IF p_wrd_fld_rec.list_word_replaces_id IS NULL THEN
924: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
925: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_RPL_ID');
926: FND_MSG_PUB.add;
927: END IF;
928:

Line 926: FND_MSG_PUB.add;

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

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

931: END IF;
932:
933: -- check original_word
934: IF p_wrd_fld_rec.original_word IS NULL THEN
935: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
936: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ORG_WRD');
937: FND_MSG_PUB.add;
938: END IF;
939:

Line 937: FND_MSG_PUB.add;

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

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

942: END IF;
943:
944: -- check replacement_word
945: IF p_wrd_fld_rec.replacement_word IS NULL 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_RPL_WRD');
948: FND_MSG_PUB.add;
949: END IF;
950:

Line 948: FND_MSG_PUB.add;

944: -- check replacement_word
945: IF p_wrd_fld_rec.replacement_word IS NULL 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_RPL_WRD');
948: FND_MSG_PUB.add;
949: END IF;
950:
951: x_return_status := FND_API.g_ret_sts_error;
952: RETURN;

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

953: END IF;
954:
955: -- check enabled_flag
956: IF p_wrd_fld_rec.enabled_flag IS NULL THEN
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
958: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');
959: FND_MSG_PUB.add;
960: END IF;
961:

Line 959: FND_MSG_PUB.add;

955: -- check enabled_flag
956: IF p_wrd_fld_rec.enabled_flag IS NULL THEN
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
958: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');
959: FND_MSG_PUB.add;
960: END IF;
961:
962: x_return_status := FND_API.g_ret_sts_error;
963: RETURN;

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

966: IF p_wrd_fld_rec.enabled_flag <> 'Y'
967: AND p_wrd_fld_rec.enabled_flag <> 'N'
968: AND p_wrd_fld_rec.enabled_flag <> FND_API.g_miss_char
969: THEN
970: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
971: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');
972: FND_MSG_PUB.add;
973: END IF;
974:

Line 972: FND_MSG_PUB.add;

968: AND p_wrd_fld_rec.enabled_flag <> FND_API.g_miss_char
969: THEN
970: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
971: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');
972: FND_MSG_PUB.add;
973: END IF;
974:
975: x_return_status := FND_API.g_ret_sts_error;
976: RETURN;

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

1008: 'field_column_name = ''' || p_wrd_fld_rec.field_column_name || ''''
1009: );
1010:
1011: IF l_fk_flag = FND_API.g_false THEN
1012: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1013: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FLD_BAD_TBL_COL');
1014: FND_MSG_PUB.add;
1015: END IF;
1016:

Line 1014: FND_MSG_PUB.add;

1010:
1011: IF l_fk_flag = FND_API.g_false THEN
1012: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1013: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FLD_BAD_TBL_COL');
1014: FND_MSG_PUB.add;
1015: END IF;
1016:
1017: x_return_status := FND_API.g_ret_sts_error;
1018: RETURN;

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

1027: p_wrd_fld_rec.list_word_replaces_id
1028: );
1029:
1030: IF l_fk_flag = FND_API.g_false THEN
1031: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1032: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FLD_BAD_RPL_ID');
1033: FND_MSG_PUB.add;
1034: END IF;
1035:

Line 1033: FND_MSG_PUB.add;

1029:
1030: IF l_fk_flag = FND_API.g_false THEN
1031: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1032: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FLD_BAD_RPL_ID');
1033: FND_MSG_PUB.add;
1034: END IF;
1035:
1036: x_return_status := FND_API.g_ret_sts_error;
1037: RETURN;

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

1072: );
1073: END IF;
1074:
1075: IF l_uk_flag = FND_API.g_false THEN
1076: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1077: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FIELDS_NO_ID');
1078: FND_MSG_PUB.add;
1079: END IF;
1080:

Line 1078: FND_MSG_PUB.add;

1074:
1075: IF l_uk_flag = FND_API.g_false THEN
1076: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1077: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FIELDS_NO_ID');
1078: FND_MSG_PUB.add;
1079: END IF;
1080:
1081: x_return_status := FND_API.g_ret_sts_error;
1082: RETURN;

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

1102: );
1103: END IF;
1104:
1105: IF l_uk_flag = FND_API.g_false THEN
1106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1107: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FLD_DUP_RP_TB_CO');
1108: FND_MSG_PUB.add;
1109: END IF;
1110:

Line 1108: FND_MSG_PUB.add;

1104:
1105: IF l_uk_flag = FND_API.g_false THEN
1106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1107: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FLD_DUP_RP_TB_CO');
1108: FND_MSG_PUB.add;
1109: END IF;
1110:
1111: x_return_status := FND_API.g_ret_sts_error;
1112: RETURN;

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

1141: OPEN c_list_word_field;
1142: FETCH c_list_word_field INTO l_wrd_fld_rec;
1143: IF (c_list_word_field%NOTFOUND) THEN
1144: CLOSE c_list_word_field;
1145: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1146: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1147: FND_MSG_PUB.add;
1148: END IF;
1149: RAISE FND_API.g_exc_error;

Line 1147: FND_MSG_PUB.add;

1143: IF (c_list_word_field%NOTFOUND) THEN
1144: CLOSE c_list_word_field;
1145: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1146: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1147: FND_MSG_PUB.add;
1148: END IF;
1149: RAISE FND_API.g_exc_error;
1150: END IF;
1151: CLOSE c_list_word_field;