APPS.AMS_ASSOCIATIONS_PVT dependencies on FND_MSG_PUB

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

9: --
10: -- HISTORY
11: -- 10/30/01 musman created
12: ---------------------------------------------------------------------
13: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
16:
17: PROCEDURE check_association_dates(

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

10: -- HISTORY
11: -- 10/30/01 musman created
12: ---------------------------------------------------------------------
13: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
16:
17: PROCEDURE check_association_dates(
18: p_association_rec IN association_rec_type,

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

11: -- 10/30/01 musman created
12: ---------------------------------------------------------------------
13: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
16:
17: PROCEDURE check_association_dates(
18: p_association_rec IN association_rec_type,
19: x_return_status OUT NOCOPY VARCHAR2

Line 104: FND_MSG_PUB.initialize;

100:
101: END IF;
102:
103: IF FND_API.to_boolean(p_init_msg_list) THEN
104: FND_MSG_PUB.initialize;
105: END IF;
106:
107: IF NOT FND_API.compatible_api_call(
108: l_api_version,

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

146: end if;
147:
148: IF l_association_rec.master_object_type <> 'CSCH' THEN
149: if AMS_ACCESS_PVT.check_update_access(l_association_rec.MASTER_OBJECT_ID, l_association_rec.MASTER_OBJECT_TYPE, l_res_id, 'USER') = 'N' then
150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
151: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --resuing message
152: FND_MSG_PUB.add;
153: END IF;
154: RAISE FND_API.g_exc_error;

Line 152: FND_MSG_PUB.add;

148: IF l_association_rec.master_object_type <> 'CSCH' THEN
149: if AMS_ACCESS_PVT.check_update_access(l_association_rec.MASTER_OBJECT_ID, l_association_rec.MASTER_OBJECT_TYPE, l_res_id, 'USER') = 'N' then
150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
151: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --resuing message
152: FND_MSG_PUB.add;
153: END IF;
154: RAISE FND_API.g_exc_error;
155: end if;
156: END IF ;

Line 175: if FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) then

171: FETCH c_get_lang_code INTO l_csch_lang_code;
172: CLOSE c_get_lang_code;
173:
174: if (l_csch_lang_code <> l_delv_lang_code) then
175: if FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) then
176: FND_MESSAGE.set_name('AMS', 'AMS_DELV_CSCH_LANGUAGE');
177: FND_MSG_PUB.add;
178: end if;
179: RAISE FND_API.g_exc_error;

Line 177: FND_MSG_PUB.add;

173:
174: if (l_csch_lang_code <> l_delv_lang_code) then
175: if FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) then
176: FND_MESSAGE.set_name('AMS', 'AMS_DELV_CSCH_LANGUAGE');
177: FND_MSG_PUB.add;
178: end if;
179: RAISE FND_API.g_exc_error;
180: end if;
181:

Line 192: if FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) then

188: if ((l_association_rec.QUANTITY_NEEDED_BY_DATE > l_delv_to_date )
189: OR
190: (l_association_rec.QUANTITY_NEEDED_BY_DATE < l_delv_from_date )) then
191:
192: if FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) then
193: FND_MESSAGE.set_name('AMS', 'AMS_DELV_INVALID_DATES');
194: FND_MSG_PUB.add;
195: end if;
196: RAISE FND_API.g_exc_error;

Line 194: FND_MSG_PUB.add;

190: (l_association_rec.QUANTITY_NEEDED_BY_DATE < l_delv_from_date )) then
191:
192: if FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) then
193: FND_MESSAGE.set_name('AMS', 'AMS_DELV_INVALID_DATES');
194: FND_MSG_PUB.add;
195: end if;
196: RAISE FND_API.g_exc_error;
197: end if;
198:

Line 363: FND_MSG_PUB.count_and_get(

359: IF FND_API.to_boolean(p_commit) THEN
360: COMMIT;
361: END IF;
362:
363: FND_MSG_PUB.count_and_get(
364: p_encoded => FND_API.g_false,
365: p_count => x_msg_count,
366: p_data => x_msg_data
367: );

Line 382: FND_MSG_PUB.count_and_get(

378:
379: WHEN FND_API.g_exc_error THEN
380: ROLLBACK TO create_association;
381: x_return_status := FND_API.g_ret_sts_error;
382: FND_MSG_PUB.count_and_get(
383: p_encoded => FND_API.g_false,
384: p_count => x_msg_count,
385: p_data => x_msg_data
386: );

Line 391: FND_MSG_PUB.count_and_get(

387:
388: WHEN FND_API.g_exc_unexpected_error THEN
389: ROLLBACK TO create_association;
390: x_return_status := FND_API.g_ret_sts_unexp_error ;
391: FND_MSG_PUB.count_and_get(
392: p_encoded => FND_API.g_false,
393: p_count => x_msg_count,
394: p_data => x_msg_data
395: );

Line 402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

398: WHEN OTHERS THEN
399: ROLLBACK TO create_association;
400: x_return_status := FND_API.g_ret_sts_unexp_error ;
401:
402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
403: THEN
404: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
405: END IF;
406:

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

400: x_return_status := FND_API.g_ret_sts_unexp_error ;
401:
402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
403: THEN
404: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
405: END IF;
406:
407: FND_MSG_PUB.count_and_get(
408: p_encoded => FND_API.g_false,

Line 407: FND_MSG_PUB.count_and_get(

403: THEN
404: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
405: END IF;
406:
407: FND_MSG_PUB.count_and_get(
408: p_encoded => FND_API.g_false,
409: p_count => x_msg_count,
410: p_data => x_msg_data
411: );

Line 492: FND_MSG_PUB.initialize;

488:
489: END IF;
490:
491: IF FND_API.to_boolean(p_init_msg_list) THEN
492: FND_MSG_PUB.initialize;
493: END IF;
494:
495: IF NOT FND_API.compatible_api_call(
496: l_api_version,

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

516: close get_master_info;
517:
518: IF l_master <> 'CSCH' THEN
519: if AMS_ACCESS_PVT.check_update_access(l_master_id, l_master, l_res_id, 'USER') = 'N' then
520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
521: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --reusing message
522: FND_MSG_PUB.add;
523: END IF;
524: RAISE FND_API.g_exc_error;

Line 522: FND_MSG_PUB.add;

518: IF l_master <> 'CSCH' THEN
519: if AMS_ACCESS_PVT.check_update_access(l_master_id, l_master, l_res_id, 'USER') = 'N' then
520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
521: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --reusing message
522: FND_MSG_PUB.add;
523: END IF;
524: RAISE FND_API.g_exc_error;
525: end if;
526: END IF ;

Line 543: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

539: WHERE object_association_id = p_object_association_id
540: AND object_version_number = p_object_version;
541:
542: IF (SQL%NOTFOUND) THEN
543: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
544: THEN
545: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
546: FND_MSG_PUB.add;
547: END IF;

Line 546: FND_MSG_PUB.add;

542: IF (SQL%NOTFOUND) THEN
543: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
544: THEN
545: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
546: FND_MSG_PUB.add;
547: END IF;
548: RAISE FND_API.g_exc_error;
549: END IF;
550:

Line 607: FND_MSG_PUB.count_and_get(

603: IF FND_API.to_boolean(p_commit) THEN
604: COMMIT;
605: END IF;
606:
607: FND_MSG_PUB.count_and_get(
608: p_encoded => FND_API.g_false,
609: p_count => x_msg_count,
610: p_data => x_msg_data
611: );

Line 626: FND_MSG_PUB.count_and_get(

622:
623: WHEN FND_API.g_exc_error THEN
624: ROLLBACK TO delete_association;
625: x_return_status := FND_API.g_ret_sts_error;
626: FND_MSG_PUB.count_and_get(
627: p_encoded => FND_API.g_false,
628: p_count => x_msg_count,
629: p_data => x_msg_data
630: );

Line 635: FND_MSG_PUB.count_and_get(

631:
632: WHEN FND_API.g_exc_unexpected_error THEN
633: ROLLBACK TO delete_association;
634: x_return_status := FND_API.g_ret_sts_unexp_error ;
635: FND_MSG_PUB.count_and_get(
636: p_encoded => FND_API.g_false,
637: p_count => x_msg_count,
638: p_data => x_msg_data
639: );

Line 645: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

641: WHEN OTHERS THEN
642: ROLLBACK TO delete_association;
643: x_return_status := FND_API.g_ret_sts_unexp_error ;
644:
645: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
646: THEN
647: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
648: END IF;
649:

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

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

Line 650: FND_MSG_PUB.count_and_get(

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

Line 702: FND_MSG_PUB.initialize;

698: AMS_Utility_PVT.debug_message(l_full_name||': start');
699: END IF;
700:
701: IF FND_API.to_boolean(p_init_msg_list) THEN
702: FND_MSG_PUB.initialize;
703: END IF;
704:
705: IF NOT FND_API.compatible_api_call(
706: l_api_version,

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

722: OPEN c_association_b;
723: FETCH c_association_b INTO l_object_association_id;
724: IF (c_association_b%NOTFOUND) THEN
725: CLOSE c_association_b;
726: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
727: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
728: FND_MSG_PUB.add;
729: END IF;
730: RAISE FND_API.g_exc_error;

Line 728: FND_MSG_PUB.add;

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

Line 734: FND_MSG_PUB.count_and_get(

730: RAISE FND_API.g_exc_error;
731: END IF;
732: CLOSE c_association_b;
733: -------------------- finish --------------------------
734: FND_MSG_PUB.count_and_get(
735: p_encoded => FND_API.g_false,
736: p_count => x_msg_count,
737: p_data => x_msg_data
738: );

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

748: EXCEPTION
749:
750: WHEN AMS_Utility_PVT.resource_locked THEN
751: x_return_status := FND_API.g_ret_sts_error;
752: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
753: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
754: FND_MSG_PUB.add;
755: END IF;
756:

Line 754: FND_MSG_PUB.add;

750: WHEN AMS_Utility_PVT.resource_locked THEN
751: x_return_status := FND_API.g_ret_sts_error;
752: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
753: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
754: FND_MSG_PUB.add;
755: END IF;
756:
757: FND_MSG_PUB.count_and_get(
758: p_encoded => FND_API.g_false,

Line 757: FND_MSG_PUB.count_and_get(

753: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
754: FND_MSG_PUB.add;
755: END IF;
756:
757: FND_MSG_PUB.count_and_get(
758: p_encoded => FND_API.g_false,
759: p_count => x_msg_count,
760: p_data => x_msg_data
761: );

Line 765: FND_MSG_PUB.count_and_get(

761: );
762:
763: WHEN FND_API.g_exc_error THEN
764: x_return_status := FND_API.g_ret_sts_error;
765: FND_MSG_PUB.count_and_get(
766: p_encoded => FND_API.g_false,
767: p_count => x_msg_count,
768: p_data => x_msg_data
769: );

Line 773: FND_MSG_PUB.count_and_get(

769: );
770:
771: WHEN FND_API.g_exc_unexpected_error THEN
772: x_return_status := FND_API.g_ret_sts_unexp_error ;
773: FND_MSG_PUB.count_and_get(
774: p_encoded => FND_API.g_false,
775: p_count => x_msg_count,
776: p_data => x_msg_data
777: );

Line 781: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

777: );
778:
779: WHEN OTHERS THEN
780: x_return_status := FND_API.g_ret_sts_unexp_error ;
781: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
782: THEN
783: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
784: END IF;
785:

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

779: WHEN OTHERS THEN
780: x_return_status := FND_API.g_ret_sts_unexp_error ;
781: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
782: THEN
783: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
784: END IF;
785:
786: FND_MSG_PUB.count_and_get(
787: p_encoded => FND_API.g_false,

Line 786: FND_MSG_PUB.count_and_get(

782: THEN
783: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
784: END IF;
785:
786: FND_MSG_PUB.count_and_get(
787: p_encoded => FND_API.g_false,
788: p_count => x_msg_count,
789: p_data => x_msg_data
790: );

Line 844: FND_MSG_PUB.initialize;

840:
841: END IF;
842:
843: IF FND_API.to_boolean(p_init_msg_list) THEN
844: FND_MSG_PUB.initialize;
845: END IF;
846:
847: IF NOT FND_API.compatible_api_call(
848: l_api_version,

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

900: end if;
901:
902: IF l_association_rec.master_object_type <> 'CSCH' THEN
903: if AMS_ACCESS_PVT.check_update_access(l_association_rec.MASTER_OBJECT_ID, l_association_rec.MASTER_OBJECT_TYPE, l_res_id, 'USER') = 'N' then
904: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
905: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');
906: FND_MSG_PUB.add;
907: END IF;
908: RAISE FND_API.g_exc_error;

Line 906: FND_MSG_PUB.add;

902: IF l_association_rec.master_object_type <> 'CSCH' THEN
903: if AMS_ACCESS_PVT.check_update_access(l_association_rec.MASTER_OBJECT_ID, l_association_rec.MASTER_OBJECT_TYPE, l_res_id, 'USER') = 'N' then
904: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
905: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');
906: FND_MSG_PUB.add;
907: END IF;
908: RAISE FND_API.g_exc_error;
909: end if;
910: END IF ;

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

954: WHERE object_association_id = l_association_rec.object_association_id
955: AND object_version_number = l_association_rec.object_version_number;
956:
957: IF (SQL%NOTFOUND) THEN
958: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
959: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
960: FND_MSG_PUB.add;
961: END IF;
962: RAISE FND_API.g_exc_error;

Line 960: FND_MSG_PUB.add;

956:
957: IF (SQL%NOTFOUND) THEN
958: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
959: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
960: FND_MSG_PUB.add;
961: END IF;
962: RAISE FND_API.g_exc_error;
963: END IF;
964:

Line 970: FND_MSG_PUB.count_and_get(

966: IF FND_API.to_boolean(p_commit) THEN
967: COMMIT;
968: END IF;
969:
970: FND_MSG_PUB.count_and_get(
971: p_encoded => FND_API.g_false,
972: p_count => x_msg_count,
973: p_data => x_msg_data
974: );

Line 989: FND_MSG_PUB.count_and_get(

985:
986: WHEN FND_API.g_exc_error THEN
987: ROLLBACK TO update_association;
988: x_return_status := FND_API.g_ret_sts_error;
989: FND_MSG_PUB.count_and_get(
990: p_encoded => FND_API.g_false,
991: p_count => x_msg_count,
992: p_data => x_msg_data
993: );

Line 998: FND_MSG_PUB.count_and_get(

994:
995: WHEN FND_API.g_exc_unexpected_error THEN
996: ROLLBACK TO update_association;
997: x_return_status := FND_API.g_ret_sts_unexp_error ;
998: FND_MSG_PUB.count_and_get(
999: p_encoded => FND_API.g_false,
1000: p_count => x_msg_count,
1001: p_data => x_msg_data
1002: );

Line 1008: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1004: WHEN OTHERS THEN
1005: ROLLBACK TO update_association;
1006: x_return_status := FND_API.g_ret_sts_unexp_error ;
1007:
1008: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1009: THEN
1010: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1011: END IF;
1012:

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

1006: x_return_status := FND_API.g_ret_sts_unexp_error ;
1007:
1008: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1009: THEN
1010: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1011: END IF;
1012:
1013: FND_MSG_PUB.count_and_get(
1014: p_encoded => FND_API.g_false,

Line 1013: FND_MSG_PUB.count_and_get(

1009: THEN
1010: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1011: END IF;
1012:
1013: FND_MSG_PUB.count_and_get(
1014: p_encoded => FND_API.g_false,
1015: p_count => x_msg_count,
1016: p_data => x_msg_data
1017: );

Line 1054: FND_MSG_PUB.initialize;

1050: AMS_Utility_PVT.debug_message(l_full_name||': start');
1051: END IF;
1052:
1053: IF FND_API.to_boolean(p_init_msg_list) THEN
1054: FND_MSG_PUB.initialize;
1055: END IF;
1056:
1057: IF NOT FND_API.compatible_api_call(
1058: l_api_version,

Line 1110: FND_MSG_PUB.count_and_get(

1106: END IF;
1107: END IF;
1108:
1109: -------------------- finish --------------------------
1110: FND_MSG_PUB.count_and_get(
1111: p_encoded => FND_API.g_false,
1112: p_count => x_msg_count,
1113: p_data => x_msg_data
1114: );

Line 1128: FND_MSG_PUB.count_and_get(

1124: EXCEPTION
1125:
1126: WHEN FND_API.g_exc_error THEN
1127: x_return_status := FND_API.g_ret_sts_error;
1128: FND_MSG_PUB.count_and_get(
1129: p_encoded => FND_API.g_false,
1130: p_count => x_msg_count,
1131: p_data => x_msg_data
1132: );

Line 1136: FND_MSG_PUB.count_and_get(

1132: );
1133:
1134: WHEN FND_API.g_exc_unexpected_error THEN
1135: x_return_status := FND_API.g_ret_sts_unexp_error ;
1136: FND_MSG_PUB.count_and_get(
1137: p_encoded => FND_API.g_false,
1138: p_count => x_msg_count,
1139: p_data => x_msg_data
1140: );

Line 1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1140: );
1141:
1142: WHEN OTHERS THEN
1143: x_return_status := FND_API.g_ret_sts_unexp_error;
1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1145: THEN
1146: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1147: END IF;
1148:

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

1142: WHEN OTHERS THEN
1143: x_return_status := FND_API.g_ret_sts_unexp_error;
1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1145: THEN
1146: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1147: END IF;
1148:
1149: FND_MSG_PUB.count_and_get(
1150: p_encoded => FND_API.g_false,

Line 1149: FND_MSG_PUB.count_and_get(

1145: THEN
1146: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1147: END IF;
1148:
1149: FND_MSG_PUB.count_and_get(
1150: p_encoded => FND_API.g_false,
1151: p_count => x_msg_count,
1152: p_data => x_msg_data
1153: );

Line 1204: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1200: l_foreign_table_id,
1201: p_master_id
1202: ) = FND_API.g_false
1203: THEN
1204: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1205: THEN
1206: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_MASTER_ID');
1207: FND_MSG_PUB.add;
1208: END IF;

Line 1207: FND_MSG_PUB.add;

1203: THEN
1204: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1205: THEN
1206: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_MASTER_ID');
1207: FND_MSG_PUB.add;
1208: END IF;
1209:
1210: return FND_API.g_false;
1211: END IF;

Line 1240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1236: l_foreign_table_id,
1237: p_using_id
1238: ) = FND_API.g_false
1239: THEN
1240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1241: THEN
1242: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_USING_ID');
1243: FND_MSG_PUB.add;
1244: END IF;

Line 1243: FND_MSG_PUB.add;

1239: THEN
1240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1241: THEN
1242: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_USING_ID');
1243: FND_MSG_PUB.add;
1244: END IF;
1245:
1246: return FND_API.g_false;
1247: END IF;

Line 1269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1265: x_return_status := FND_API.g_ret_sts_success;
1266:
1267: ------------------------ user_status_id --------------------------
1268: IF p_association_rec.master_object_id IS NULL THEN
1269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1270: THEN
1271: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_NO_MASTER_OBJ_ID');
1272: FND_MSG_PUB.add;
1273: END IF;

Line 1272: FND_MSG_PUB.add;

1268: IF p_association_rec.master_object_id IS NULL THEN
1269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1270: THEN
1271: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_NO_MASTER_OBJ_ID');
1272: FND_MSG_PUB.add;
1273: END IF;
1274:
1275: x_return_status := FND_API.g_ret_sts_error;
1276: RETURN;

Line 1280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1276: RETURN;
1277: END IF;
1278:
1279: IF p_association_rec.using_object_id IS NULL THEN
1280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1281: THEN
1282: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_NO_USING_OBJ_ID');
1283: FND_MSG_PUB.add;
1284: END IF;

Line 1283: FND_MSG_PUB.add;

1279: IF p_association_rec.using_object_id IS NULL THEN
1280: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1281: THEN
1282: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_NO_USING_OBJ_ID');
1283: FND_MSG_PUB.add;
1284: END IF;
1285:
1286: x_return_status := FND_API.g_ret_sts_error;
1287: RETURN;

Line 1291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1287: RETURN;
1288: END IF;
1289:
1290: IF p_association_rec.using_object_type IS NULL THEN
1291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1292: THEN
1293: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_NO_USING_OBJ_TYPE');
1294: FND_MSG_PUB.add;
1295: END IF;

Line 1294: FND_MSG_PUB.add;

1290: IF p_association_rec.using_object_type IS NULL THEN
1291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1292: THEN
1293: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_NO_USING_OBJ_TYPE');
1294: FND_MSG_PUB.add;
1295: END IF;
1296:
1297: x_return_status := FND_API.g_ret_sts_error;
1298: RETURN;

Line 1302: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1298: RETURN;
1299: END IF;
1300:
1301: IF p_association_rec.master_object_type IS NULL THEN
1302: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1303: THEN
1304: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_NO_MASTER_OBJ_TYPE');
1305: FND_MSG_PUB.add;
1306: END IF;

Line 1305: FND_MSG_PUB.add;

1301: IF p_association_rec.master_object_type IS NULL THEN
1302: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1303: THEN
1304: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_NO_MASTER_OBJ_TYPE');
1305: FND_MSG_PUB.add;
1306: END IF;
1307:
1308: x_return_status := FND_API.g_ret_sts_error;
1309: RETURN;

Line 1313: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1309: RETURN;
1310: END IF;
1311:
1312: IF p_association_rec.primary_flag IS NULL THEN
1313: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1314: THEN
1315: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_NO_PRIMARY_FLAG');
1316: FND_MSG_PUB.add;
1317: END IF;

Line 1316: FND_MSG_PUB.add;

1312: IF p_association_rec.primary_flag IS NULL THEN
1313: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1314: THEN
1315: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_NO_PRIMARY_FLAG');
1316: FND_MSG_PUB.add;
1317: END IF;
1318:
1319: x_return_status := FND_API.g_ret_sts_error;
1320: RETURN;

Line 1373: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1369: 'ams_object_associations',
1370: 'object_association_id = ' || p_association_rec.object_association_id
1371: ) = FND_API.g_false
1372: THEN
1373: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1374: THEN
1375: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_DUPLICATE_ID');
1376: FND_MSG_PUB.add;
1377: END IF;

Line 1376: FND_MSG_PUB.add;

1372: THEN
1373: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1374: THEN
1375: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_DUPLICATE_ID');
1376: FND_MSG_PUB.add;
1377: END IF;
1378: x_return_status := FND_API.g_ret_sts_error;
1379: RETURN;
1380: END IF;

Line 1394: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1390: FETCH c_check_obj INTO l_valid_flag;
1391: CLOSE c_check_obj;
1392:
1393: IF l_valid_flag = 'Y' THEN
1394: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1395: THEN
1396: FND_MESSAGE.set_name('AMS','AMS_ACCESS_DUPLICATE_ID');
1397: FND_MSG_PUB.add;
1398: END IF;

Line 1397: FND_MSG_PUB.add;

1393: IF l_valid_flag = 'Y' THEN
1394: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1395: THEN
1396: FND_MESSAGE.set_name('AMS','AMS_ACCESS_DUPLICATE_ID');
1397: FND_MSG_PUB.add;
1398: END IF;
1399: x_return_status := FND_API.g_ret_sts_error;
1400: RETURN;
1401: END IF;

Line 1442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1438: p_lookup_type => 'AMS_OBJECT_USAGE_TYPE',
1439: p_lookup_code => p_association_rec.usage_type
1440: ) = FND_API.g_false
1441: THEN
1442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1443: THEN
1444: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_USAGE_TYPE');
1445: FND_MSG_PUB.add;
1446: x_return_status := FND_API.g_ret_sts_error;

Line 1445: FND_MSG_PUB.add;

1441: THEN
1442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1443: THEN
1444: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_USAGE_TYPE');
1445: FND_MSG_PUB.add;
1446: x_return_status := FND_API.g_ret_sts_error;
1447: RETURN;
1448: END IF;
1449: ELSE

Line 1460: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1456: p_lookup_type => 'AMS_MASTER_OBJECT_TYPE',
1457: p_lookup_code => p_association_rec.master_object_type
1458: ) = FND_API.g_false
1459: THEN
1460: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1461: THEN
1462: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_MASTER_TYPE');
1463: FND_MSG_PUB.add;
1464: x_return_status := FND_API.g_ret_sts_error;

Line 1463: FND_MSG_PUB.add;

1459: THEN
1460: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1461: THEN
1462: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_MASTER_TYPE');
1463: FND_MSG_PUB.add;
1464: x_return_status := FND_API.g_ret_sts_error;
1465: RETURN;
1466: END IF;
1467: END IF;

Line 1477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1473: p_lookup_type => 'AMS_USING_OBJECT_TYPE',
1474: p_lookup_code => p_association_rec.using_object_type
1475: ) = FND_API.g_false
1476: THEN
1477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1478: THEN
1479: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_USING_TYPE');
1480: FND_MSG_PUB.add;
1481: x_return_status := FND_API.g_ret_sts_error;

Line 1480: FND_MSG_PUB.add;

1476: THEN
1477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1478: THEN
1479: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_USING_TYPE');
1480: FND_MSG_PUB.add;
1481: x_return_status := FND_API.g_ret_sts_error;
1482: RETURN;
1483: END IF;
1484: END IF;

Line 1504: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1500: l_using_type := p_association_rec.using_object_type;
1501:
1502: IF check_association(l_master_type,l_master_id, l_using_type, l_using_id) = FND_API.g_false
1503: THEN
1504: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1505: THEN
1506: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_ASSOCIATION');
1507: FND_MSG_PUB.add;
1508: x_return_status := FND_API.g_ret_sts_error;

Line 1507: FND_MSG_PUB.add;

1503: THEN
1504: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1505: THEN
1506: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_ASSOCIATION');
1507: FND_MSG_PUB.add;
1508: x_return_status := FND_API.g_ret_sts_error;
1509: RETURN;
1510: END IF;
1511: END IF; /* check association */

Line 1527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1523: ,p_pk_data_type => AMS_Utility_PVT.G_VARCHAR2
1524: ,p_additional_where_clause => l_additional_where_clause
1525: ) = FND_API.G_FALSE
1526: THEN
1527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1528: THEN
1529: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_CURRENCY_CODE');
1530: FND_MSG_PUB.add;
1531: END IF;

Line 1530: FND_MSG_PUB.add;

1526: THEN
1527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1528: THEN
1529: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_CURRENCY_CODE');
1530: FND_MSG_PUB.add;
1531: END IF;
1532:
1533: x_return_status := FND_API.g_ret_sts_error;
1534: RETURN;

Line 1546: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1542: p_lookup_type => 'AMS_EVENT_FULFILL_ON',
1543: p_lookup_code => p_association_rec.fulfill_on_type_code
1544: ) = FND_API.g_false
1545: THEN
1546: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1547: THEN
1548: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_FULFILL');
1549: FND_MSG_PUB.add;
1550: END IF;

Line 1549: FND_MSG_PUB.add;

1545: THEN
1546: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1547: THEN
1548: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_FULFILL');
1549: FND_MSG_PUB.add;
1550: END IF;
1551:
1552: x_return_status := FND_API.g_ret_sts_error;
1553: RETURN;

Line 1581: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1577: AND p_association_rec.primary_flag IS NOT NULL
1578: THEN
1579: IF AMS_Utility_PVT.is_Y_or_N(p_association_rec.primary_flag) = FND_API.g_false
1580: THEN
1581: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1582: THEN
1583: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_PRIMARY_FLAG');
1584: FND_MSG_PUB.add;
1585: END IF;

Line 1584: FND_MSG_PUB.add;

1580: THEN
1581: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1582: THEN
1583: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_PRIMARY_FLAG');
1584: FND_MSG_PUB.add;
1585: END IF;
1586:
1587: x_return_status := FND_API.g_ret_sts_error;
1588: RETURN;

Line 1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1593: AND p_association_rec.cost_frozen_flag IS NOT NULL
1594: THEN
1595: IF AMS_Utility_PVT.is_Y_or_N(p_association_rec.cost_frozen_flag) = FND_API.g_false
1596: THEN
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1598: THEN
1599: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_COST_FROZEN_FLAG');
1600: FND_MSG_PUB.add;
1601: END IF;

Line 1600: FND_MSG_PUB.add;

1596: THEN
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1598: THEN
1599: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_COST_FROZEN_FLAG');
1600: FND_MSG_PUB.add;
1601: END IF;
1602:
1603: x_return_status := FND_API.g_ret_sts_error;
1604: RETURN;

Line 1684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1680: OPEN c_csch_end_date(p_association_rec.master_object_id);
1681: FETCH c_csch_end_date INTO l_end_date;
1682: CLOSE c_csch_end_date;
1683: ELSE
1684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1685: THEN
1686: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_MASTER_TYPE');
1687: FND_MSG_PUB.add;
1688: x_return_status := FND_API.g_ret_sts_error;

Line 1687: FND_MSG_PUB.add;

1683: ELSE
1684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1685: THEN
1686: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_INVALID_MASTER_TYPE');
1687: FND_MSG_PUB.add;
1688: x_return_status := FND_API.g_ret_sts_error;
1689: RETURN;
1690: END IF;
1691: END IF;

Line 1698: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1694: AND p_association_rec.quantity_needed_by_date <> FND_API.g_miss_date
1695: THEN
1696: IF p_association_rec.quantity_needed_by_date > l_end_date
1697: THEN
1698: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1699: THEN
1700: FND_MESSAGE.set_name('AMS', 'AMS_MASTER_OBJ_INVALID_DATES');
1701: FND_MSG_PUB.add;
1702: END IF;

Line 1701: FND_MSG_PUB.add;

1697: THEN
1698: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1699: THEN
1700: FND_MESSAGE.set_name('AMS', 'AMS_MASTER_OBJ_INVALID_DATES');
1701: FND_MSG_PUB.add;
1702: END IF;
1703: x_return_status := FND_API.g_ret_sts_error;
1704: RETURN;
1705: END IF;

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

1807: OPEN c_association;
1808: FETCH c_association INTO l_association_rec;
1809: IF c_association%NOTFOUND THEN
1810: CLOSE c_association;
1811: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1812: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1813: FND_MSG_PUB.add;
1814: END IF;
1815: RAISE FND_API.g_exc_error;

Line 1813: FND_MSG_PUB.add;

1809: IF c_association%NOTFOUND THEN
1810: CLOSE c_association;
1811: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1812: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1813: FND_MSG_PUB.add;
1814: END IF;
1815: RAISE FND_API.g_exc_error;
1816: END IF;
1817: CLOSE c_association;