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_RULE_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_rule_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_rule_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_rule_field
17: (
18: p_api_version IN NUMBER,

Line 59: FND_MSG_PUB.initialize;

55: -- initialize
56: SAVEPOINT create_list_rule_field;
57:
58: IF FND_API.to_boolean(p_init_msg_list) THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61:
62:
63: IF (AMS_DEBUG_HIGH_ON) THEN

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

88: FETCH c_list_rule_count INTO l_list_rule_count;
89: CLOSE c_list_rule_count;
90:
91: IF l_list_rule_count > 0 THEN
92: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
93: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_CANNOT_MODIFY');
94: FND_MSG_PUB.add;
95: END IF;
96: ---RAISE FND_API.g_exc_error;

Line 94: FND_MSG_PUB.add;

90:
91: IF l_list_rule_count > 0 THEN
92: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
93: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_CANNOT_MODIFY');
94: FND_MSG_PUB.add;
95: END IF;
96: ---RAISE FND_API.g_exc_error;
97: END IF;
98:

Line 183: FND_MSG_PUB.count_and_get

179: IF FND_API.to_boolean(p_commit) THEN
180: COMMIT;
181: END IF;
182:
183: FND_MSG_PUB.count_and_get
184: (
185: p_encoded => FND_API.g_false,
186: p_count => x_msg_count,
187: p_data => x_msg_data

Line 203: FND_MSG_PUB.count_and_get

199:
200: WHEN FND_API.g_exc_error THEN
201: ROLLBACK TO create_list_rule_field;
202: x_return_status := FND_API.g_ret_sts_error;
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 213: FND_MSG_PUB.count_and_get

209:
210: WHEN FND_API.g_exc_unexpected_error THEN
211: ROLLBACK TO create_list_rule_field;
212: x_return_status := FND_API.g_ret_sts_unexp_error;
213: FND_MSG_PUB.count_and_get
214: (
215: p_encoded => FND_API.g_false,
216: p_count => x_msg_count,
217: p_data => x_msg_data

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

219:
220: WHEN OTHERS THEN
221: ROLLBACK TO create_list_rule_field;
222: x_return_status :=FND_API.g_ret_sts_unexp_error;
223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
224: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
225: END IF;
226: FND_MSG_PUB.count_and_get
227: (

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

220: WHEN OTHERS THEN
221: ROLLBACK TO create_list_rule_field;
222: x_return_status :=FND_API.g_ret_sts_unexp_error;
223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
224: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
225: END IF;
226: FND_MSG_PUB.count_and_get
227: (
228: p_encoded => FND_API.g_false,

Line 226: FND_MSG_PUB.count_and_get

222: x_return_status :=FND_API.g_ret_sts_unexp_error;
223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
224: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
225: END IF;
226: FND_MSG_PUB.count_and_get
227: (
228: p_encoded => FND_API.g_false,
229: p_count => x_msg_count,
230: p_data => x_msg_data

Line 269: FND_MSG_PUB.initialize;

265: -- initialize
266: SAVEPOINT update_list_rule_field;
267:
268: IF FND_API.to_boolean(p_init_msg_list) THEN
269: FND_MSG_PUB.initialize;
270: END IF;
271:
272: IF (AMS_DEBUG_HIGH_ON) THEN
273:

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

341: WHERE list_rule_field_id = l_rule_fld_rec.list_rule_field_id
342: AND object_version_number = l_rule_fld_rec.object_version_number;
343:
344: IF (SQL%NOTFOUND) THEN
345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
346: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
347: FND_MSG_PUB.add;
348: END IF;
349: RAISE FND_API.g_exc_error;

Line 347: FND_MSG_PUB.add;

343:
344: IF (SQL%NOTFOUND) THEN
345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
346: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
347: FND_MSG_PUB.add;
348: END IF;
349: RAISE FND_API.g_exc_error;
350: END IF;
351:

Line 357: FND_MSG_PUB.count_and_get

353: IF FND_API.to_boolean(p_commit) THEN
354: COMMIT;
355: END IF;
356:
357: FND_MSG_PUB.count_and_get
358: (
359: P_ENCODED => FND_API.g_false,
360: p_count => x_msg_count,
361: p_data => x_msg_data

Line 377: FND_MSG_PUB.count_and_get

373:
374: WHEN FND_API.g_exc_error THEN
375: ROLLBACK TO update_list_rule_field;
376: x_return_status := FND_API.g_ret_sts_error;
377: FND_MSG_PUB.count_and_get
378: (
379: p_encoded => FND_API.g_false,
380: p_count => x_msg_count,
381: p_data => x_msg_data

Line 387: FND_MSG_PUB.count_and_get

383:
384: WHEN FND_API.g_exc_unexpected_error THEN
385: ROLLBACK TO update_list_rule_field;
386: x_return_status := FND_API.g_ret_sts_unexp_error;
387: FND_MSG_PUB.count_and_get
388: (
389: p_encoded => FND_API.g_false,
390: p_count => x_msg_count,
391: p_data => x_msg_data

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

393:
394: WHEN OTHERS THEN
395: ROLLBACK TO update_list_rule_field;
396: x_return_status :=FND_API.g_ret_sts_unexp_error;
397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
398: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
399: END IF;
400: FND_MSG_PUB.count_and_get
401: (

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

394: WHEN OTHERS THEN
395: ROLLBACK TO update_list_rule_field;
396: x_return_status :=FND_API.g_ret_sts_unexp_error;
397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
398: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
399: END IF;
400: FND_MSG_PUB.count_and_get
401: (
402: p_encoded => FND_API.g_false,

Line 400: FND_MSG_PUB.count_and_get

396: x_return_status :=FND_API.g_ret_sts_unexp_error;
397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
398: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
399: END IF;
400: FND_MSG_PUB.count_and_get
401: (
402: p_encoded => FND_API.g_false,
403: p_count => x_msg_count,
404: p_data => x_msg_data

Line 462: FND_MSG_PUB.initialize;

458:
459: END IF;
460:
461: IF FND_API.to_boolean(p_init_msg_list) THEN
462: FND_MSG_PUB.initialize;
463: END IF;
464:
465: IF NOT FND_API.compatible_api_call
466: (

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

483: FETCH c_list_rule_count INTO l_list_rule_count;
484: CLOSE c_list_rule_count;
485:
486: IF l_list_rule_count > 0 THEN
487: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
488: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_CANNOT_MODIFY');
489: FND_MSG_PUB.add;
490: END IF;
491: ---RAISE FND_API.g_exc_error;

Line 489: FND_MSG_PUB.add;

485:
486: IF l_list_rule_count > 0 THEN
487: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
488: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_CANNOT_MODIFY');
489: FND_MSG_PUB.add;
490: END IF;
491: ---RAISE FND_API.g_exc_error;
492: END IF;
493:

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

501: WHERE list_rule_field_id = p_rule_fld_id
502: AND object_version_number = p_object_version;
503:
504: IF (SQL%NOTFOUND) THEN
505: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
506: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
507: FND_MSG_PUB.add;
508: END IF;
509: RAISE FND_API.g_exc_error;

Line 507: FND_MSG_PUB.add;

503:
504: IF (SQL%NOTFOUND) THEN
505: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
506: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
507: FND_MSG_PUB.add;
508: END IF;
509: RAISE FND_API.g_exc_error;
510: END IF;
511:

Line 517: FND_MSG_PUB.count_and_get

513: IF FND_API.to_boolean(p_commit) THEN
514: COMMIT;
515: END IF;
516:
517: FND_MSG_PUB.count_and_get
518: (
519: P_ENCODED => FND_API.g_false,
520: p_count => x_msg_count,
521: p_data => x_msg_data

Line 537: FND_MSG_PUB.count_and_get

533:
534: WHEN FND_API.g_exc_error THEN
535: ROLLBACK TO delete_list_rule_field;
536: x_return_status := FND_API.g_ret_sts_error;
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 547: FND_MSG_PUB.count_and_get

543:
544: WHEN FND_API.g_exc_unexpected_error THEN
545: ROLLBACK TO delete_list_rule_field;
546: x_return_status := FND_API.g_ret_sts_unexp_error;
547: FND_MSG_PUB.count_and_get
548: (
549: p_encoded => FND_API.g_false,
550: p_count => x_msg_count,
551: p_data => x_msg_data

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

553:
554: WHEN OTHERS THEN
555: ROLLBACK TO delete_list_rule_field;
556: x_return_status :=FND_API.g_ret_sts_unexp_error;
557: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
558: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
559: END IF;
560: FND_MSG_PUB.count_and_get
561: (

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

554: WHEN OTHERS THEN
555: ROLLBACK TO delete_list_rule_field;
556: x_return_status :=FND_API.g_ret_sts_unexp_error;
557: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
558: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
559: END IF;
560: FND_MSG_PUB.count_and_get
561: (
562: p_encoded => FND_API.g_false,

Line 560: FND_MSG_PUB.count_and_get

556: x_return_status :=FND_API.g_ret_sts_unexp_error;
557: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
558: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
559: END IF;
560: FND_MSG_PUB.count_and_get
561: (
562: p_encoded => FND_API.g_false,
563: p_count => x_msg_count,
564: p_data => x_msg_data

Line 610: FND_MSG_PUB.initialize;

606: AMS_Utility_PVT.debug_message(l_full_name || ': start');
607: END IF;
608:
609: IF FND_API.to_boolean(p_init_msg_list) THEN
610: FND_MSG_PUB.initialize;
611: END IF;
612:
613: IF NOT FND_API.compatible_api_call
614: (

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

632: OPEN c_list_rule_field;
633: FETCH c_list_rule_field INTO l_rule_fld_id;
634: IF (c_list_rule_field%NOTFOUND) THEN
635: CLOSE c_list_rule_field;
636: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) 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;

Line 638: FND_MSG_PUB.add;

634: IF (c_list_rule_field%NOTFOUND) THEN
635: CLOSE c_list_rule_field;
636: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) 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;
642: CLOSE c_list_rule_field;

Line 645: FND_MSG_PUB.count_and_get

641: END IF;
642: CLOSE c_list_rule_field;
643:
644: -- finish
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 664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

660: EXCEPTION
661:
662: WHEN AMS_Utility_PVT.resource_locked THEN
663: x_return_status := FND_API.g_ret_sts_error;
664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
665: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
666: FND_MSG_PUB.add;
667: END IF;
668: FND_MSG_PUB.count_and_get

Line 666: FND_MSG_PUB.add;

662: WHEN AMS_Utility_PVT.resource_locked THEN
663: x_return_status := FND_API.g_ret_sts_error;
664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
665: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
666: FND_MSG_PUB.add;
667: END IF;
668: FND_MSG_PUB.count_and_get
669: (
670: p_encoded => FND_API.g_false,

Line 668: FND_MSG_PUB.count_and_get

664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
665: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
666: FND_MSG_PUB.add;
667: END IF;
668: FND_MSG_PUB.count_and_get
669: (
670: p_encoded => FND_API.g_false,
671: p_count => x_msg_count,
672: p_data => x_msg_data

Line 677: FND_MSG_PUB.count_and_get

673: );
674:
675: WHEN FND_API.g_exc_error THEN
676: x_return_status := FND_API.g_ret_sts_error;
677: FND_MSG_PUB.count_and_get
678: (
679: p_encoded => FND_API.g_false,
680: p_count => x_msg_count,
681: p_data => x_msg_data

Line 686: FND_MSG_PUB.count_and_get

682: );
683:
684: WHEN FND_API.g_exc_unexpected_error THEN
685: x_return_status := FND_API.g_ret_sts_unexp_error;
686: FND_MSG_PUB.count_and_get
687: (
688: p_encoded => FND_API.g_false,
689: p_count => x_msg_count,
690: p_data => x_msg_data

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

691: );
692:
693: WHEN OTHERS THEN
694: x_return_status :=FND_API.g_ret_sts_unexp_error;
695: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
696: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
697: END IF;
698: FND_MSG_PUB.count_and_get
699: (

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

692:
693: WHEN OTHERS THEN
694: x_return_status :=FND_API.g_ret_sts_unexp_error;
695: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
696: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
697: END IF;
698: FND_MSG_PUB.count_and_get
699: (
700: p_encoded => FND_API.g_false,

Line 698: FND_MSG_PUB.count_and_get

694: x_return_status :=FND_API.g_ret_sts_unexp_error;
695: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
696: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
697: END IF;
698: FND_MSG_PUB.count_and_get
699: (
700: p_encoded => FND_API.g_false,
701: p_count => x_msg_count,
702: p_data => x_msg_data

Line 779: FND_MSG_PUB.count_and_get

775:
776: -- record level
777:
778: -------------------- finish --------------------------
779: FND_MSG_PUB.count_and_get
780: (
781: p_encoded => FND_API.g_false,
782: p_count => x_msg_count,
783: p_data => x_msg_data

Line 797: FND_MSG_PUB.count_and_get

793:
794: EXCEPTION
795: WHEN FND_API.g_exc_error THEN
796: x_return_status := FND_API.g_ret_sts_error;
797: FND_MSG_PUB.count_and_get
798: (
799: p_encoded => FND_API.g_false,
800: p_count => x_msg_count,
801: p_data => x_msg_data

Line 806: FND_MSG_PUB.count_and_get

802: );
803:
804: WHEN FND_API.g_exc_unexpected_error THEN
805: x_return_status := FND_API.g_ret_sts_unexp_error ;
806: FND_MSG_PUB.count_and_get
807: (
808: p_encoded => FND_API.g_false,
809: p_count => x_msg_count,
810: p_data => x_msg_data

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

811: );
812:
813: WHEN OTHERS THEN
814: x_return_status := FND_API.g_ret_sts_unexp_error;
815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
816: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
817: END IF;
818:
819: FND_MSG_PUB.count_and_get

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

812:
813: WHEN OTHERS THEN
814: x_return_status := FND_API.g_ret_sts_unexp_error;
815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
816: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
817: END IF;
818:
819: FND_MSG_PUB.count_and_get
820: (

Line 819: FND_MSG_PUB.count_and_get

815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
816: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
817: END IF;
818:
819: FND_MSG_PUB.count_and_get
820: (
821: p_encoded => FND_API.g_false,
822: p_count => x_msg_count,
823: p_data => x_msg_data

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

922:
923: -- check list_rule_field_id
924: IF p_rule_fld_rec.list_rule_field_id IS NULL
925: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
926: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
927: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_ID');
928: FND_MSG_PUB.add;
929: END IF;
930:

Line 928: FND_MSG_PUB.add;

924: IF p_rule_fld_rec.list_rule_field_id IS NULL
925: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
926: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
927: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_ID');
928: FND_MSG_PUB.add;
929: END IF;
930:
931: x_return_status := FND_API.g_ret_sts_error;
932: RETURN;

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

935: -- check object_version_number
936: IF p_rule_fld_rec.object_version_number IS NULL
937: AND p_validation_mode = JTF_PLSQL_API.g_update
938: THEN
939: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
940: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
941: FND_MSG_PUB.add;
942: END IF;
943:

Line 941: FND_MSG_PUB.add;

937: AND p_validation_mode = JTF_PLSQL_API.g_update
938: THEN
939: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
940: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
941: FND_MSG_PUB.add;
942: END IF;
943:
944: x_return_status := FND_API.g_ret_sts_error;
945: RETURN;

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

946: END IF;
947:
948: -- check field_table_name
949: IF p_rule_fld_rec.field_table_name IS NULL THEN
950: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
951: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_TBL_NAME');
952: FND_MSG_PUB.add;
953: END IF;
954:

Line 952: FND_MSG_PUB.add;

948: -- check field_table_name
949: IF p_rule_fld_rec.field_table_name IS NULL THEN
950: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
951: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_TBL_NAME');
952: FND_MSG_PUB.add;
953: END IF;
954:
955: x_return_status := FND_API.g_ret_sts_error;
956: RETURN;

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

957: END IF;
958:
959: -- check field_column_name
960: IF p_rule_fld_rec.field_column_name IS NULL THEN
961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
962: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_COL_NAME');
963: FND_MSG_PUB.add;
964: END IF;
965:

Line 963: FND_MSG_PUB.add;

959: -- check field_column_name
960: IF p_rule_fld_rec.field_column_name IS NULL THEN
961: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
962: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_COL_NAME');
963: FND_MSG_PUB.add;
964: END IF;
965:
966: x_return_status := FND_API.g_ret_sts_error;
967: RETURN;

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

968: END IF;
969:
970: -- check list_rule_id
971: IF p_rule_fld_rec.list_rule_id IS NULL THEN
972: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
973: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_ID');
974: FND_MSG_PUB.add;
975: END IF;
976:

Line 974: FND_MSG_PUB.add;

970: -- check list_rule_id
971: IF p_rule_fld_rec.list_rule_id IS NULL THEN
972: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
973: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_ID');
974: FND_MSG_PUB.add;
975: END IF;
976:
977: x_return_status := FND_API.g_ret_sts_error;
978: RETURN;

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

1010: 'field_column_name = ''' || p_rule_fld_rec.field_column_name || ''''
1011: );
1012:
1013: IF l_fk_flag = FND_API.g_false THEN
1014: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1015: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_BAD_TBL_COL');
1016: FND_MSG_PUB.add;
1017: END IF;
1018:

Line 1016: FND_MSG_PUB.add;

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

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

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

Line 1035: FND_MSG_PUB.add;

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

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

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

Line 1080: FND_MSG_PUB.add;

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

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

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

Line 1110: FND_MSG_PUB.add;

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

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

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

Line 1149: FND_MSG_PUB.add;

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