APPS.AMS_DELIVERABLE_PVT dependencies on FND_MSG_PUB

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

10: -- HISTORY
11: -- 02/16/2000 khung@us Create.
12: ---------------------------------------------------------------------
13:
14: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
15: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
16: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
17:
18: PROCEDURE create_pricelist_header

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

11: -- 02/16/2000 khung@us Create.
12: ---------------------------------------------------------------------
13:
14: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
15: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
16: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
17:
18: PROCEDURE create_pricelist_header
19: (

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

12: ---------------------------------------------------------------------
13:
14: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
15: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
16: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
17:
18: PROCEDURE create_pricelist_header
19: (
20: p_api_version IN NUMBER,

Line 302: FND_MSG_PUB.initialize;

298: AMS_Utility_PVT.debug_message(l_full_name||': start');
299: END IF;
300:
301: IF FND_API.to_boolean(p_init_msg_list) THEN
302: FND_MSG_PUB.initialize;
303: END IF;
304:
305: IF NOT FND_API.compatible_api_call
306: (

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

750: AMS_UTILITY_PVT.debug_message('the return status from :'||l_return_status);
751: END IF;
752:
753: IF l_return_status = FND_API.g_ret_sts_error THEN
754: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
755: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
756: END IF;
757:
758: FND_MSG_PUB.count_and_get(

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

751: END IF;
752:
753: IF l_return_status = FND_API.g_ret_sts_error THEN
754: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
755: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
756: END IF;
757:
758: FND_MSG_PUB.count_and_get(
759: p_encoded => FND_API.g_false,

Line 758: FND_MSG_PUB.count_and_get(

754: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
755: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
756: END IF;
757:
758: FND_MSG_PUB.count_and_get(
759: p_encoded => FND_API.g_false,
760: p_count => x_msg_count,
761: p_data => x_msg_data
762: );

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

763:
764: RAISE FND_API.g_exc_error;
765:
766: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
768: THEN
769: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
770: END IF;
771:

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

765:
766: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
768: THEN
769: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
770: END IF;
771:
772: FND_MSG_PUB.count_and_get(
773: p_encoded => FND_API.g_false,

Line 772: FND_MSG_PUB.count_and_get(

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

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

798: );
799:
800: IF l_return_status = FND_API.g_ret_sts_error THEN
801:
802: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
803: THEN
804: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
805: END IF;
806:

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

800: IF l_return_status = FND_API.g_ret_sts_error THEN
801:
802: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
803: THEN
804: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
805: END IF;
806:
807: FND_MSG_PUB.count_and_get(
808: p_encoded => FND_API.g_false,

Line 807: FND_MSG_PUB.count_and_get(

803: THEN
804: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
805: END IF;
806:
807: FND_MSG_PUB.count_and_get(
808: p_encoded => FND_API.g_false,
809: p_count => x_msg_count,
810: p_data => x_msg_data
811: );

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

811: );
812: RAISE FND_API.g_exc_error;
813: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
814:
815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
816: THEN
817: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
818: END IF;
819:

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

813: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
814:
815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
816: THEN
817: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
818: END IF;
819:
820: FND_MSG_PUB.count_and_get(
821: p_encoded => FND_API.g_false,

Line 820: FND_MSG_PUB.count_and_get(

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

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

848: p_association_rec => l_association_rec,
849: x_object_association_id => l_object_association_id
850: );
851: IF l_return_status = FND_API.g_ret_sts_error THEN
852: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
853: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
854: END IF;
855: FND_MSG_PUB.count_and_get
856: (

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

849: x_object_association_id => l_object_association_id
850: );
851: IF l_return_status = FND_API.g_ret_sts_error THEN
852: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
853: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
854: END IF;
855: FND_MSG_PUB.count_and_get
856: (
857: p_encoded => FND_API.g_false,

Line 855: FND_MSG_PUB.count_and_get

851: IF l_return_status = FND_API.g_ret_sts_error THEN
852: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
853: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
854: END IF;
855: FND_MSG_PUB.count_and_get
856: (
857: p_encoded => FND_API.g_false,
858: p_count => x_msg_count,
859: p_data => x_msg_data

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

859: p_data => x_msg_data
860: );
861: RAISE FND_API.g_exc_error;
862: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
863: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
864: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
865: END IF;
866: FND_MSG_PUB.count_and_get
867: (

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

860: );
861: RAISE FND_API.g_exc_error;
862: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
863: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
864: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
865: END IF;
866: FND_MSG_PUB.count_and_get
867: (
868: p_encoded => FND_API.g_false,

Line 866: FND_MSG_PUB.count_and_get

862: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
863: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
864: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
865: END IF;
866: FND_MSG_PUB.count_and_get
867: (
868: p_encoded => FND_API.g_false,
869: p_count => x_msg_count,
870: p_data => x_msg_data

Line 884: FND_MSG_PUB.count_and_get(

880: IF FND_API.to_boolean(p_commit) THEN
881: COMMIT;
882: END IF;
883:
884: FND_MSG_PUB.count_and_get(
885: p_encoded => FND_API.g_false,
886: p_count => x_msg_count,
887: p_data => x_msg_data
888: );

Line 899: FND_MSG_PUB.count_and_get(

895:
896: WHEN FND_API.g_exc_error THEN
897: ROLLBACK TO create_deliverable;
898: x_return_status := FND_API.g_ret_sts_error;
899: FND_MSG_PUB.count_and_get(
900: p_encoded => FND_API.g_false,
901: p_count => x_msg_count,
902: p_data => x_msg_data
903: );

Line 908: FND_MSG_PUB.count_and_get(

904:
905: WHEN FND_API.g_exc_unexpected_error THEN
906: ROLLBACK TO create_deliverable;
907: x_return_status := FND_API.g_ret_sts_unexp_error ;
908: FND_MSG_PUB.count_and_get(
909: p_encoded => FND_API.g_false,
910: p_count => x_msg_count,
911: p_data => x_msg_data
912: );

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

914: WHEN OTHERS THEN
915: ROLLBACK TO create_deliverable;
916: x_return_status := FND_API.g_ret_sts_unexp_error ;
917:
918: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
919: THEN
920: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
921: END IF;
922:

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

916: x_return_status := FND_API.g_ret_sts_unexp_error ;
917:
918: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
919: THEN
920: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
921: END IF;
922:
923: FND_MSG_PUB.count_and_get(
924: p_encoded => FND_API.g_false,

Line 923: FND_MSG_PUB.count_and_get(

919: THEN
920: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
921: END IF;
922:
923: FND_MSG_PUB.count_and_get(
924: p_encoded => FND_API.g_false,
925: p_count => x_msg_count,
926: p_data => x_msg_data
927: );

Line 969: FND_MSG_PUB.initialize;

965: AMS_Utility_PVT.debug_message(l_full_name||': start');
966: END IF;
967:
968: IF FND_API.to_boolean(p_init_msg_list) THEN
969: FND_MSG_PUB.initialize;
970: END IF;
971:
972: IF NOT FND_API.compatible_api_call(
973: l_api_version,

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

989: WHERE deliverable_id = p_deliv_id
990: AND object_version_number = p_object_version;
991:
992: IF (SQL%NOTFOUND) THEN
993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
994: THEN
995: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
996: FND_MSG_PUB.add;
997: END IF;

Line 996: FND_MSG_PUB.add;

992: IF (SQL%NOTFOUND) THEN
993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
994: THEN
995: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
996: FND_MSG_PUB.add;
997: END IF;
998: RAISE FND_API.g_exc_error;
999: END IF;
1000:

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

1001: DELETE FROM ams_deliverables_all_tl
1002: WHERE deliverable_id = p_deliv_id;
1003:
1004: IF (SQL%NOTFOUND) THEN
1005: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1006: THEN
1007: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1008: FND_MSG_PUB.add;
1009: END IF;

Line 1008: FND_MSG_PUB.add;

1004: IF (SQL%NOTFOUND) THEN
1005: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1006: THEN
1007: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1008: FND_MSG_PUB.add;
1009: END IF;
1010: RAISE FND_API.g_exc_error;
1011: END IF;
1012:

Line 1018: FND_MSG_PUB.count_and_get(

1014: IF FND_API.to_boolean(p_commit) THEN
1015: COMMIT;
1016: END IF;
1017:
1018: FND_MSG_PUB.count_and_get(
1019: p_encoded => FND_API.g_false,
1020: p_count => x_msg_count,
1021: p_data => x_msg_data
1022: );

Line 1033: FND_MSG_PUB.count_and_get(

1029:
1030: WHEN FND_API.g_exc_error THEN
1031: ROLLBACK TO delete_deliverable;
1032: x_return_status := FND_API.g_ret_sts_error;
1033: FND_MSG_PUB.count_and_get(
1034: p_encoded => FND_API.g_false,
1035: p_count => x_msg_count,
1036: p_data => x_msg_data
1037: );

Line 1042: FND_MSG_PUB.count_and_get(

1038:
1039: WHEN FND_API.g_exc_unexpected_error THEN
1040: ROLLBACK TO delete_deliverable;
1041: x_return_status := FND_API.g_ret_sts_unexp_error ;
1042: FND_MSG_PUB.count_and_get(
1043: p_encoded => FND_API.g_false,
1044: p_count => x_msg_count,
1045: p_data => x_msg_data
1046: );

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

1048: WHEN OTHERS THEN
1049: ROLLBACK TO delete_deliverable;
1050: x_return_status := FND_API.g_ret_sts_unexp_error ;
1051:
1052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1053: THEN
1054: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1055: END IF;
1056:

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

1050: x_return_status := FND_API.g_ret_sts_unexp_error ;
1051:
1052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1053: THEN
1054: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1055: END IF;
1056:
1057: FND_MSG_PUB.count_and_get(
1058: p_encoded => FND_API.g_false,

Line 1057: FND_MSG_PUB.count_and_get(

1053: THEN
1054: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1055: END IF;
1056:
1057: FND_MSG_PUB.count_and_get(
1058: p_encoded => FND_API.g_false,
1059: p_count => x_msg_count,
1060: p_data => x_msg_data
1061: );

Line 1117: FND_MSG_PUB.initialize;

1113: AMS_Utility_PVT.debug_message(l_full_name||': start');
1114: END IF;
1115:
1116: IF FND_API.to_boolean(p_init_msg_list) THEN
1117: FND_MSG_PUB.initialize;
1118: END IF;
1119:
1120: IF NOT FND_API.compatible_api_call(
1121: l_api_version,

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

1137: OPEN c_deliv_b;
1138: FETCH c_deliv_b INTO l_deliv_id;
1139: IF (c_deliv_b%NOTFOUND) THEN
1140: CLOSE c_deliv_b;
1141: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1142: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1143: FND_MSG_PUB.add;
1144: END IF;
1145: RAISE FND_API.g_exc_error;

Line 1143: FND_MSG_PUB.add;

1139: IF (c_deliv_b%NOTFOUND) THEN
1140: CLOSE c_deliv_b;
1141: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1142: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1143: FND_MSG_PUB.add;
1144: END IF;
1145: RAISE FND_API.g_exc_error;
1146: END IF;
1147: CLOSE c_deliv_b;

Line 1153: FND_MSG_PUB.count_and_get(

1149: OPEN c_deliv_tl;
1150: CLOSE c_deliv_tl;
1151:
1152: -------------------- finish --------------------------
1153: FND_MSG_PUB.count_and_get(
1154: p_encoded => FND_API.g_false,
1155: p_count => x_msg_count,
1156: p_data => x_msg_data
1157: );

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

1159: EXCEPTION
1160:
1161: WHEN AMS_Utility_PVT.resource_locked THEN
1162: x_return_status := FND_API.g_ret_sts_error;
1163: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1164: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1165: FND_MSG_PUB.add;
1166: END IF;
1167:

Line 1165: FND_MSG_PUB.add;

1161: WHEN AMS_Utility_PVT.resource_locked THEN
1162: x_return_status := FND_API.g_ret_sts_error;
1163: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1164: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1165: FND_MSG_PUB.add;
1166: END IF;
1167:
1168: FND_MSG_PUB.count_and_get(
1169: p_encoded => FND_API.g_false,

Line 1168: FND_MSG_PUB.count_and_get(

1164: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1165: FND_MSG_PUB.add;
1166: END IF;
1167:
1168: FND_MSG_PUB.count_and_get(
1169: p_encoded => FND_API.g_false,
1170: p_count => x_msg_count,
1171: p_data => x_msg_data
1172: );

Line 1176: FND_MSG_PUB.count_and_get(

1172: );
1173:
1174: WHEN FND_API.g_exc_error THEN
1175: x_return_status := FND_API.g_ret_sts_error;
1176: FND_MSG_PUB.count_and_get(
1177: p_encoded => FND_API.g_false,
1178: p_count => x_msg_count,
1179: p_data => x_msg_data
1180: );

Line 1184: FND_MSG_PUB.count_and_get(

1180: );
1181:
1182: WHEN FND_API.g_exc_unexpected_error THEN
1183: x_return_status := FND_API.g_ret_sts_unexp_error ;
1184: FND_MSG_PUB.count_and_get(
1185: p_encoded => FND_API.g_false,
1186: p_count => x_msg_count,
1187: p_data => x_msg_data
1188: );

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

1188: );
1189:
1190: WHEN OTHERS THEN
1191: x_return_status := FND_API.g_ret_sts_unexp_error ;
1192: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1193: THEN
1194: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1195: END IF;
1196:

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

1190: WHEN OTHERS THEN
1191: x_return_status := FND_API.g_ret_sts_unexp_error ;
1192: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1193: THEN
1194: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1195: END IF;
1196:
1197: FND_MSG_PUB.count_and_get(
1198: p_encoded => FND_API.g_false,

Line 1197: FND_MSG_PUB.count_and_get(

1193: THEN
1194: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1195: END IF;
1196:
1197: FND_MSG_PUB.count_and_get(
1198: p_encoded => FND_API.g_false,
1199: p_count => x_msg_count,
1200: p_data => x_msg_data
1201: );

Line 1413: FND_MSG_PUB.initialize;

1409: AMS_Utility_PVT.debug_message(l_full_name||': start');
1410: END IF;
1411:
1412: IF FND_API.to_boolean(p_init_msg_list) THEN
1413: FND_MSG_PUB.initialize;
1414: END IF;
1415:
1416: IF NOT FND_API.compatible_api_call(
1417: l_api_version,

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

1437: fetch get_res_id into l_res_id;
1438: close get_res_id;
1439: end if;
1440: if AMS_ACCESS_PVT.check_update_access(l_deliv_rec.deliverable_id, 'DELV', l_res_id, 'USER') = 'N' then
1441: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1442: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');-- reusing the message
1443: FND_MSG_PUB.add;
1444: END IF;
1445: RAISE FND_API.g_exc_error;

Line 1443: FND_MSG_PUB.add;

1439: end if;
1440: if AMS_ACCESS_PVT.check_update_access(l_deliv_rec.deliverable_id, 'DELV', l_res_id, 'USER') = 'N' then
1441: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1442: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');-- reusing the message
1443: FND_MSG_PUB.add;
1444: END IF;
1445: RAISE FND_API.g_exc_error;
1446: end if;
1447: --01/24/02 added for access check bug #2764852 mukumar end

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

1915: IF (AMS_DEBUG_HIGH_ON) THEN
1916:
1917: ams_utility_pvt.debug_message (' SQL NOT FOUND ');
1918: END IF;
1919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1920: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1921: FND_MSG_PUB.add;
1922: END IF;
1923: RAISE FND_API.g_exc_error;

Line 1921: FND_MSG_PUB.add;

1917: ams_utility_pvt.debug_message (' SQL NOT FOUND ');
1918: END IF;
1919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1920: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1921: FND_MSG_PUB.add;
1922: END IF;
1923: RAISE FND_API.g_exc_error;
1924: END IF;
1925: IF (AMS_DEBUG_HIGH_ON) THEN

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

1936: WHERE deliverable_id = l_deliv_rec.deliverable_id
1937: AND USERENV('LANG') IN (language, source_lang);
1938:
1939: IF (SQL%NOTFOUND) THEN
1940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1941: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1942: FND_MSG_PUB.add;
1943: END IF;
1944: RAISE FND_API.g_exc_error;

Line 1942: FND_MSG_PUB.add;

1938:
1939: IF (SQL%NOTFOUND) THEN
1940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1941: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1942: FND_MSG_PUB.add;
1943: END IF;
1944: RAISE FND_API.g_exc_error;
1945: END IF;
1946:

Line 2002: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1998: --
1999: -- IF Approval_required_flag( l_deliv_rec.setup_id, 'BAPL') = FND_API.g_true
2000: -- AND l_budget_lines_exist = 'N' THEN
2001: --
2002: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2003: -- FND_MESSAGE.set_name('AMS', 'AMS_EVE_NO_BGT_SRC');
2004: -- FND_MSG_PUB.add;
2005: -- END IF;
2006: -- RAISE FND_API.g_exc_error;

Line 2004: -- FND_MSG_PUB.add;

2000: -- AND l_budget_lines_exist = 'N' THEN
2001: --
2002: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2003: -- FND_MESSAGE.set_name('AMS', 'AMS_EVE_NO_BGT_SRC');
2004: -- FND_MSG_PUB.add;
2005: -- END IF;
2006: -- RAISE FND_API.g_exc_error;
2007: -- END IF;
2008: -- *****************************************

Line 2065: FND_MSG_PUB.count_and_get(

2061: IF FND_API.to_boolean(p_commit) THEN
2062: COMMIT;
2063: END IF;
2064:
2065: FND_MSG_PUB.count_and_get(
2066: p_encoded => FND_API.g_false,
2067: p_count => x_msg_count,
2068: p_data => x_msg_data
2069: );

Line 2084: FND_MSG_PUB.count_and_get(

2080:
2081: WHEN FND_API.g_exc_error THEN
2082: ROLLBACK TO update_deliverable;
2083: x_return_status := FND_API.g_ret_sts_error;
2084: FND_MSG_PUB.count_and_get(
2085: p_encoded => FND_API.g_false,
2086: p_count => x_msg_count,
2087: p_data => x_msg_data
2088: );

Line 2093: FND_MSG_PUB.count_and_get(

2089:
2090: WHEN FND_API.g_exc_unexpected_error THEN
2091: ROLLBACK TO update_deliverable;
2092: x_return_status := FND_API.g_ret_sts_unexp_error ;
2093: FND_MSG_PUB.count_and_get(
2094: p_encoded => FND_API.g_false,
2095: p_count => x_msg_count,
2096: p_data => x_msg_data
2097: );

Line 2101: --FND_MSG_PUB.count_and_get(

2097: );
2098:
2099: WHEN inv_creation_error THEN
2100: /*-modify on 08/07/2000 khung
2101: --FND_MSG_PUB.count_and_get(
2102: p_encoded => FND_API.g_false,
2103: -- p_count => x_msg_count,
2104: -- p_data => x_msg_data
2105: -- );*/

Line 2108: FND_MSG_PUB.count_and_get(

2104: -- p_data => x_msg_data
2105: -- );*/
2106: ROLLBACK TO update_deliverable;
2107: FOR i IN 1 .. x_error_tbl.count LOOP
2108: FND_MSG_PUB.count_and_get(
2109: p_encoded => FND_API.g_false,
2110: p_count => x_msg_count,
2111: p_data => x_error_tbl(i).message_text
2112: );

Line 2121: FND_MSG_PUB.count_and_get(

2117: END LOOP;
2118:
2119: WHEN jtf_inv_item_creation_error THEN
2120: ROLLBACK TO update_deliverable;
2121: FND_MSG_PUB.count_and_get(
2122: p_encoded => FND_API.g_false,
2123: p_count => x_msg_count,
2124: p_data => x_msg_data
2125: );

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

2125: );
2126: WHEN OTHERS THEN
2127: ROLLBACK TO update_deliverable;
2128: x_return_status := FND_API.g_ret_sts_unexp_error ;
2129: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2130: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2131: END IF;
2132: FND_MSG_PUB.count_and_get(
2133: p_encoded => FND_API.g_false,

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

2126: WHEN OTHERS THEN
2127: ROLLBACK TO update_deliverable;
2128: x_return_status := FND_API.g_ret_sts_unexp_error ;
2129: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2130: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2131: END IF;
2132: FND_MSG_PUB.count_and_get(
2133: p_encoded => FND_API.g_false,
2134: p_count => x_msg_count,

Line 2132: FND_MSG_PUB.count_and_get(

2128: x_return_status := FND_API.g_ret_sts_unexp_error ;
2129: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2130: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2131: END IF;
2132: FND_MSG_PUB.count_and_get(
2133: p_encoded => FND_API.g_false,
2134: p_count => x_msg_count,
2135: p_data => x_msg_data
2136: );

Line 2174: FND_MSG_PUB.initialize;

2170: AMS_Utility_PVT.debug_message(l_full_name||': start');
2171: END IF;
2172:
2173: IF FND_API.to_boolean(p_init_msg_list) THEN
2174: FND_MSG_PUB.initialize;
2175: END IF;
2176:
2177: IF NOT FND_API.compatible_api_call(
2178: l_api_version,

Line 2245: FND_MSG_PUB.count_and_get(

2241:
2242: END IF;
2243:
2244: -------------------- finish --------------------------
2245: FND_MSG_PUB.count_and_get(
2246: p_encoded => FND_API.g_false,
2247: p_count => x_msg_count,
2248: p_data => x_msg_data
2249: );

Line 2263: FND_MSG_PUB.count_and_get(

2259: EXCEPTION
2260:
2261: WHEN FND_API.g_exc_error THEN
2262: x_return_status := FND_API.g_ret_sts_error;
2263: FND_MSG_PUB.count_and_get(
2264: p_encoded => FND_API.g_false,
2265: p_count => x_msg_count,
2266: p_data => x_msg_data
2267: );

Line 2271: FND_MSG_PUB.count_and_get(

2267: );
2268:
2269: WHEN FND_API.g_exc_unexpected_error THEN
2270: x_return_status := FND_API.g_ret_sts_unexp_error ;
2271: FND_MSG_PUB.count_and_get(
2272: p_encoded => FND_API.g_false,
2273: p_count => x_msg_count,
2274: p_data => x_msg_data
2275: );

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

2275: );
2276:
2277: WHEN OTHERS THEN
2278: x_return_status := FND_API.g_ret_sts_unexp_error;
2279: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2280: THEN
2281: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2282: END IF;
2283:

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

2277: WHEN OTHERS THEN
2278: x_return_status := FND_API.g_ret_sts_unexp_error;
2279: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2280: THEN
2281: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2282: END IF;
2283:
2284: FND_MSG_PUB.count_and_get(
2285: p_encoded => FND_API.g_false,

Line 2284: FND_MSG_PUB.count_and_get(

2280: THEN
2281: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2282: END IF;
2283:
2284: FND_MSG_PUB.count_and_get(
2285: p_encoded => FND_API.g_false,
2286: p_count => x_msg_count,
2287: p_data => x_msg_data
2288: );

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

2308:
2309: -------------------- put required items here ---------------------
2310:
2311: IF p_deliv_rec.language_code IS NULL THEN
2312: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2313: THEN
2314: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_LANGUAGE_CODE');
2315: FND_MSG_PUB.add;
2316: END IF;

Line 2315: FND_MSG_PUB.add;

2311: IF p_deliv_rec.language_code IS NULL THEN
2312: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2313: THEN
2314: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_LANGUAGE_CODE');
2315: FND_MSG_PUB.add;
2316: END IF;
2317:
2318: x_return_status := FND_API.g_ret_sts_error;
2319: RETURN;

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

2319: RETURN;
2320: END IF;
2321:
2322: IF p_deliv_rec.deliverable_name IS NULL THEN
2323: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2324: THEN
2325: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_DELIVERABLE_NAME');
2326: FND_MSG_PUB.add;
2327: END IF;

Line 2326: FND_MSG_PUB.add;

2322: IF p_deliv_rec.deliverable_name IS NULL THEN
2323: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2324: THEN
2325: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_DELIVERABLE_NAME');
2326: FND_MSG_PUB.add;
2327: END IF;
2328:
2329: x_return_status := FND_API.g_ret_sts_error;
2330: RETURN;

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

2330: RETURN;
2331: END IF;
2332:
2333: IF p_deliv_rec.actual_avail_from_date IS NULL THEN
2334: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2335: THEN
2336: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_FROM_DATE');
2337: FND_MSG_PUB.add;
2338: END IF;

Line 2337: FND_MSG_PUB.add;

2333: IF p_deliv_rec.actual_avail_from_date IS NULL THEN
2334: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2335: THEN
2336: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_FROM_DATE');
2337: FND_MSG_PUB.add;
2338: END IF;
2339:
2340: x_return_status := FND_API.g_ret_sts_error;
2341: RETURN;

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

2341: RETURN;
2342: END IF;
2343:
2344: IF p_deliv_rec.actual_avail_to_date IS NULL THEN
2345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2346: THEN
2347: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_TO_DATE');
2348: FND_MSG_PUB.add;
2349: END IF;

Line 2348: FND_MSG_PUB.add;

2344: IF p_deliv_rec.actual_avail_to_date IS NULL THEN
2345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2346: THEN
2347: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_TO_DATE');
2348: FND_MSG_PUB.add;
2349: END IF;
2350:
2351: x_return_status := FND_API.g_ret_sts_error;
2352: RETURN;

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

2352: RETURN;
2353: END IF;
2354:
2355: IF p_deliv_rec.forecasted_complete_date IS NULL THEN
2356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2357: THEN
2358: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_FOREC_DATE');
2359: FND_MSG_PUB.add;
2360: END IF;

Line 2359: FND_MSG_PUB.add;

2355: IF p_deliv_rec.forecasted_complete_date IS NULL THEN
2356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2357: THEN
2358: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_FOREC_DATE');
2359: FND_MSG_PUB.add;
2360: END IF;
2361:
2362: x_return_status := FND_API.g_ret_sts_error;
2363: RETURN;

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

2363: RETURN;
2364: END IF;
2365:
2366: IF p_deliv_rec.owner_user_id IS NULL THEN
2367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2368: THEN
2369: FND_MESSAGE.set_name('AMS', 'AMS_EVT_REG_NO_OWNER_ID');
2370: FND_MSG_PUB.add;
2371: END IF;

Line 2370: FND_MSG_PUB.add;

2366: IF p_deliv_rec.owner_user_id IS NULL THEN
2367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2368: THEN
2369: FND_MESSAGE.set_name('AMS', 'AMS_EVT_REG_NO_OWNER_ID');
2370: FND_MSG_PUB.add;
2371: END IF;
2372:
2373: x_return_status := FND_API.g_ret_sts_error;
2374: RETURN;

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

2374: RETURN;
2375: END IF;
2376:
2377: IF p_deliv_rec.setup_id IS NULL THEN
2378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2379: THEN
2380: FND_MESSAGE.set_name('AMS', 'AMS_FUND_NO_CUSTOM_SETUP');
2381: FND_MSG_PUB.add;
2382: END IF;

Line 2381: FND_MSG_PUB.add;

2377: IF p_deliv_rec.setup_id IS NULL THEN
2378: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2379: THEN
2380: FND_MESSAGE.set_name('AMS', 'AMS_FUND_NO_CUSTOM_SETUP');
2381: FND_MSG_PUB.add;
2382: END IF;
2383:
2384: x_return_status := FND_API.g_ret_sts_error;
2385: RETURN;

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

2385: RETURN;
2386: END IF;
2387:
2388: IF p_deliv_rec.country_id IS NULL THEN
2389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2390: THEN
2391: FND_MESSAGE.set_name('AMS', 'AMS_DILG_BAD_CITY');
2392: FND_MSG_PUB.add;
2393: END IF;

Line 2392: FND_MSG_PUB.add;

2388: IF p_deliv_rec.country_id IS NULL THEN
2389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2390: THEN
2391: FND_MESSAGE.set_name('AMS', 'AMS_DILG_BAD_CITY');
2392: FND_MSG_PUB.add;
2393: END IF;
2394:
2395: x_return_status := FND_API.g_ret_sts_error;
2396: RETURN;

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

2396: RETURN;
2397: END IF;
2398:
2399: IF p_deliv_rec.category_Type_id IS NULL THEN
2400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2401: THEN
2402: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_NO_CATEGORY_ID');
2403: FND_MSG_PUB.add;
2404: END IF;

Line 2403: FND_MSG_PUB.add;

2399: IF p_deliv_rec.category_Type_id IS NULL THEN
2400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2401: THEN
2402: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_NO_CATEGORY_ID');
2403: FND_MSG_PUB.add;
2404: END IF;
2405:
2406: x_return_status := FND_API.g_ret_sts_error;
2407: RETURN;

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

2407: RETURN;
2408: END IF;
2409:
2410: IF p_deliv_rec.category_sub_Type_id IS NULL THEN
2411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2412: THEN
2413: FND_MESSAGE.set_name('AMS', 'AMS_SUB_CATEGORY_IS_MISSING');
2414: FND_MSG_PUB.add;
2415: END IF;

Line 2414: FND_MSG_PUB.add;

2410: IF p_deliv_rec.category_sub_Type_id IS NULL THEN
2411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2412: THEN
2413: FND_MESSAGE.set_name('AMS', 'AMS_SUB_CATEGORY_IS_MISSING');
2414: FND_MSG_PUB.add;
2415: END IF;
2416:
2417: x_return_status := FND_API.g_ret_sts_error;
2418: RETURN;

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

2418: RETURN;
2419: END IF;
2420:
2421: IF p_deliv_rec.version IS NULL THEN
2422: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2423: THEN
2424: FND_MESSAGE.set_name('AMS', 'AMS_DELV_VERSION_MISSING');
2425: FND_MSG_PUB.add;
2426: END IF;

Line 2425: FND_MSG_PUB.add;

2421: IF p_deliv_rec.version IS NULL THEN
2422: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2423: THEN
2424: FND_MESSAGE.set_name('AMS', 'AMS_DELV_VERSION_MISSING');
2425: FND_MSG_PUB.add;
2426: END IF;
2427:
2428: x_return_status := FND_API.g_ret_sts_error;
2429: RETURN;

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

2429: RETURN;
2430: END IF;
2431:
2432: IF p_deliv_rec.transaction_currency_code IS NULL THEN
2433: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2434: THEN
2435: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BUDGET_NO_CURRENCY');
2436: FND_MSG_PUB.add;
2437: END IF;

Line 2436: FND_MSG_PUB.add;

2432: IF p_deliv_rec.transaction_currency_code IS NULL THEN
2433: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2434: THEN
2435: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BUDGET_NO_CURRENCY');
2436: FND_MSG_PUB.add;
2437: END IF;
2438:
2439: x_return_status := FND_API.g_ret_sts_error;
2440: RETURN;

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

2493: 'ams_deliverables_vl',
2494: 'deliverable_id = ' || p_deliv_rec.deliverable_id
2495: ) = FND_API.g_false
2496: THEN
2497: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2498: THEN
2499: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_ID');
2500: FND_MSG_PUB.add;
2501: END IF;

Line 2500: FND_MSG_PUB.add;

2496: THEN
2497: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2498: THEN
2499: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_ID');
2500: FND_MSG_PUB.add;
2501: END IF;
2502: x_return_status := FND_API.g_ret_sts_error;
2503: RETURN;
2504: END IF;

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

2519: CLOSE c_check_uniq;
2520:
2521: IF (l_uniq_flag = 'N')
2522: THEN
2523: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2524: THEN
2525: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUP_NAME_VERSION');
2526: FND_MSG_PUB.add;
2527: END IF;

Line 2526: FND_MSG_PUB.add;

2522: THEN
2523: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2524: THEN
2525: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUP_NAME_VERSION');
2526: FND_MSG_PUB.add;
2527: END IF;
2528: x_return_status := FND_API.g_ret_sts_error;
2529: RETURN;
2530: END IF;

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

2547: END IF;
2548:
2549: IF (l_uniq_flag_u = 'N')
2550: THEN
2551: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2552: THEN
2553: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUP_NAME_VERSION');
2554: FND_MSG_PUB.add;
2555: END IF;

Line 2554: FND_MSG_PUB.add;

2550: THEN
2551: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2552: THEN
2553: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUP_NAME_VERSION');
2554: FND_MSG_PUB.add;
2555: END IF;
2556: x_return_status := FND_API.g_ret_sts_error;
2557: RETURN;
2558: END IF;

Line 2580: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

2576: -- ''' AND deliverable_id <> ' || p_deliv_rec.deliverable_id
2577: -- );
2578: --END IF;
2579: --IF l_valid_flag = FND_API.g_false THEN
2580: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2581: -- THEN
2582: -- FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_NAME');
2583: -- FND_MSG_PUB.add;
2584: -- END IF;

Line 2583: -- FND_MSG_PUB.add;

2579: --IF l_valid_flag = FND_API.g_false THEN
2580: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2581: -- THEN
2582: -- FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_NAME');
2583: -- FND_MSG_PUB.add;
2584: -- END IF;
2585: -- x_return_status := FND_API.g_ret_sts_error;
2586: -- RETURN;
2587: --END IF;

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

2647: 'category_id',
2648: p_deliv_rec.category_type_id
2649: ) = FND_API.g_false
2650: THEN
2651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2652: THEN
2653: FND_MESSAGE.set_name('AMS', 'AMS_FUND_BAD_CATEGORY_ID');
2654: FND_MSG_PUB.add;
2655: END IF;

Line 2654: FND_MSG_PUB.add;

2650: THEN
2651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2652: THEN
2653: FND_MESSAGE.set_name('AMS', 'AMS_FUND_BAD_CATEGORY_ID');
2654: FND_MSG_PUB.add;
2655: END IF;
2656: x_return_status := FND_API.g_ret_sts_error;
2657: RETURN;
2658: END IF;

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

2667: 'category_id',
2668: p_deliv_rec.category_sub_type_id
2669: ) = FND_API.g_false
2670: THEN
2671: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2672: THEN
2673: FND_MESSAGE.set_name('AMS', 'AMS_SUB_CATEGORY_IS_MISSING');
2674: FND_MSG_PUB.add;
2675: END IF;

Line 2674: FND_MSG_PUB.add;

2670: THEN
2671: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2672: THEN
2673: FND_MESSAGE.set_name('AMS', 'AMS_SUB_CATEGORY_IS_MISSING');
2674: FND_MSG_PUB.add;
2675: END IF;
2676: x_return_status := FND_API.g_ret_sts_error;
2677: RETURN;
2678: END IF;

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

2687: 'custom_setup_id',
2688: p_deliv_rec.setup_id
2689: ) = FND_API.g_false
2690: THEN
2691: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2692: THEN
2693: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_CUSTOM_SETUP');
2694: FND_MSG_PUB.add;
2695: END IF;

Line 2694: FND_MSG_PUB.add;

2690: THEN
2691: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2692: THEN
2693: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_CUSTOM_SETUP');
2694: FND_MSG_PUB.add;
2695: END IF;
2696: x_return_status := FND_API.g_ret_sts_error;
2697: RETURN;
2698: END IF;

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

2795: p_lookup_type => 'AMS_DELIV_STATUS',
2796: p_lookup_code => p_deliv_rec.status_code
2797: ) = FND_API.g_false
2798: THEN
2799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2800: THEN
2801: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_STATUS_CODE');
2802: FND_MSG_PUB.add;
2803: END IF;

Line 2802: FND_MSG_PUB.add;

2798: THEN
2799: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2800: THEN
2801: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_STATUS_CODE');
2802: FND_MSG_PUB.add;
2803: END IF;
2804:
2805: x_return_status := FND_API.g_ret_sts_error;
2806: RETURN;

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

2907: AND p_deliv_rec.kit_flag IS NOT NULL
2908: THEN
2909: IF AMS_Utility_PVT.is_Y_or_N(p_deliv_rec.kit_flag) = FND_API.g_false
2910: THEN
2911: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2912: THEN
2913: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_KIT_FLAG');
2914: FND_MSG_PUB.add;
2915: END IF;

Line 2914: FND_MSG_PUB.add;

2910: THEN
2911: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2912: THEN
2913: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_KIT_FLAG');
2914: FND_MSG_PUB.add;
2915: END IF;
2916:
2917: x_return_status := FND_API.g_ret_sts_error;
2918: RETURN;

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

2947: OR (l_old_kit_flag = 'Y' AND p_deliv_rec.kit_flag = 'N')
2948: OR (l_old_kit_flag = 'N' AND p_deliv_rec.kit_flag = 'Y'))
2949: )
2950: THEN
2951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2952: THEN
2953: FND_MESSAGE.set_name('AMS', 'AMS_DELV_NO_UPD_AVAL_STATUS');
2954: FND_MSG_PUB.add;
2955: END IF;

Line 2954: FND_MSG_PUB.add;

2950: THEN
2951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2952: THEN
2953: FND_MESSAGE.set_name('AMS', 'AMS_DELV_NO_UPD_AVAL_STATUS');
2954: FND_MSG_PUB.add;
2955: END IF;
2956: x_return_status := FND_API.g_ret_sts_error;
2957: RETURN;
2958: END IF;

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

2959:
2960: IF (l_old_electronic_flag='N'
2961: AND p_deliv_rec.can_fulfill_electronic_flag = 'Y'
2962: AND l_old_inventory_flag ='Y' )THEN
2963: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2964: THEN
2965: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
2966: FND_MSG_PUB.add;
2967: END IF;

Line 2966: FND_MSG_PUB.add;

2962: AND l_old_inventory_flag ='Y' )THEN
2963: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2964: THEN
2965: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
2966: FND_MSG_PUB.add;
2967: END IF;
2968: x_return_status := FND_API.g_ret_sts_error;
2969: RETURN;
2970: END IF;

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

2973: -- if an inv item is attached ,cannot make electronic to physical
2974: IF (l_old_physical_flag='N'
2975: AND p_deliv_rec.can_fulfill_physical_flag = 'Y'
2976: AND l_old_inventory_flag ='Y' )THEN
2977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2978: THEN
2979: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
2980: FND_MSG_PUB.add;
2981: END IF;

Line 2980: FND_MSG_PUB.add;

2976: AND l_old_inventory_flag ='Y' )THEN
2977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2978: THEN
2979: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
2980: FND_MSG_PUB.add;
2981: END IF;
2982: x_return_status := FND_API.g_ret_sts_error;
2983: RETURN;
2984: -- if an inv item is attached ,cannot change phy-inventoried to stock manually

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

2987: AND p_deliv_rec.inventory_flag='N'
2988: AND p_deliv_rec.can_fulfill_physical_flag = 'Y'
2989: AND (p_deliv_rec.kit_flag ='N' OR (p_deliv_rec.kit_flag='Y' and l_qp_profile='Y')))
2990: THEN
2991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2992: THEN
2993: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
2994: FND_MSG_PUB.add;
2995: END IF;

Line 2994: FND_MSG_PUB.add;

2990: THEN
2991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2992: THEN
2993: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
2994: FND_MSG_PUB.add;
2995: END IF;
2996: x_return_status := FND_API.g_ret_sts_error;
2997: RETURN;
2998: END IF;

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

3003:
3004: IF (l_old_electronic_flag='N'
3005: AND p_deliv_rec.can_fulfill_electronic_flag = 'Y'
3006: AND l_quantity_on_hand >0 )THEN
3007: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3008: THEN
3009: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
3010: FND_MSG_PUB.add;
3011: END IF;

Line 3010: FND_MSG_PUB.add;

3006: AND l_quantity_on_hand >0 )THEN
3007: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3008: THEN
3009: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
3010: FND_MSG_PUB.add;
3011: END IF;
3012: x_return_status := FND_API.g_ret_sts_error;
3013: RETURN;
3014: END IF;

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

3018: END IF;
3019: IF (l_old_inventory_flag='N'
3020: AND p_deliv_rec.inventory_flag = 'Y'
3021: AND l_quantity_on_hand >0 )THEN
3022: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3023: THEN
3024: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_IFLAG');
3025: FND_MSG_PUB.add;
3026: END IF;

Line 3025: FND_MSG_PUB.add;

3021: AND l_quantity_on_hand >0 )THEN
3022: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3023: THEN
3024: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_IFLAG');
3025: FND_MSG_PUB.add;
3026: END IF;
3027: x_return_status := FND_API.g_ret_sts_error;
3028: RETURN;
3029: END IF;

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

3041: IF (l_old_electronic_flag='Y'
3042: AND p_deliv_rec.can_fulfill_electronic_flag = 'N'
3043: AND l_kits_check > 0)
3044: THEN
3045: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3046: THEN
3047: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3048: FND_MSG_PUB.add;
3049: END IF;

Line 3048: FND_MSG_PUB.add;

3044: THEN
3045: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3046: THEN
3047: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3048: FND_MSG_PUB.add;
3049: END IF;
3050: x_return_status := FND_API.g_ret_sts_error;
3051: RETURN;
3052: END IF;

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

3054: IF (l_old_physical_flag='Y'
3055: AND p_deliv_rec.can_fulfill_electronic_flag = 'Y'
3056: AND l_kits_check > 0)
3057: THEN
3058: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3059: THEN
3060: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
3061: FND_MSG_PUB.add;
3062: END IF;

Line 3061: FND_MSG_PUB.add;

3057: THEN
3058: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3059: THEN
3060: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
3061: FND_MSG_PUB.add;
3062: END IF;
3063: x_return_status := FND_API.g_ret_sts_error;
3064: RETURN;
3065: END IF;

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

3068: AND l_old_inventory_flag ='N'
3069: AND p_deliv_rec.inventory_flag = 'Y'
3070: AND l_kits_check > 0)
3071: THEN
3072: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3073: THEN
3074: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_IFLAG');
3075: FND_MSG_PUB.add;
3076: END IF;

Line 3075: FND_MSG_PUB.add;

3071: THEN
3072: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3073: THEN
3074: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_IFLAG');
3075: FND_MSG_PUB.add;
3076: END IF;
3077: x_return_status := FND_API.g_ret_sts_error;
3078: RETURN;
3079: END IF;

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

3083: AND l_old_inventory_flag ='Y'
3084: AND p_deliv_rec.inventory_flag = 'N'
3085: AND l_kits_check > 0)
3086: THEN
3087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3088: THEN
3089: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3090: FND_MSG_PUB.add;
3091: END IF;

Line 3090: FND_MSG_PUB.add;

3086: THEN
3087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3088: THEN
3089: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3090: FND_MSG_PUB.add;
3091: END IF;
3092: x_return_status := FND_API.g_ret_sts_error;
3093: RETURN;
3094: /*

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

3097: AND p_deliv_rec.inventory_flag = 'N'
3098: AND l_kits_check > 0
3099: AND p_deliv_rec.non_inv_quantity_on_hand >0)
3100: THEN
3101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3102: THEN
3103: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3104: FND_MSG_PUB.add;
3105: END IF;

Line 3104: FND_MSG_PUB.add;

3100: THEN
3101: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3102: THEN
3103: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3104: FND_MSG_PUB.add;
3105: END IF;
3106: x_return_status := FND_API.g_ret_sts_error;
3107: RETURN;
3108: */

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

3114: --IF DELIV is a KIT, the KIT FLAG cannot be updated to N
3115:
3116: -- If the deliv is a kit, cannot upd kit flag to 'N'
3117: if ((l_kits_check > 0) AND (p_deliv_rec.kit_flag = 'N')) then
3118: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3119: THEN
3120: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_UPD_KIT_TO_N');
3121: FND_MSG_PUB.add;
3122: END IF;

Line 3121: FND_MSG_PUB.add;

3117: if ((l_kits_check > 0) AND (p_deliv_rec.kit_flag = 'N')) then
3118: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3119: THEN
3120: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_UPD_KIT_TO_N');
3121: FND_MSG_PUB.add;
3122: END IF;
3123: x_return_status := FND_API.g_ret_sts_error;
3124: RETURN;
3125: end if;

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

3130: FETCH is_deliv_kit_part INTO l_kits_check;
3131: CLOSE is_deliv_kit_part;
3132:
3133: if ((l_kits_check > 0) AND (p_deliv_rec.kit_flag = 'Y')) then
3134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3135: THEN
3136: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_UPD_KIT_TO_Y');
3137: FND_MSG_PUB.add;
3138: END IF;

Line 3137: FND_MSG_PUB.add;

3133: if ((l_kits_check > 0) AND (p_deliv_rec.kit_flag = 'Y')) then
3134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3135: THEN
3136: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_UPD_KIT_TO_Y');
3137: FND_MSG_PUB.add;
3138: END IF;
3139: x_return_status := FND_API.g_ret_sts_error;
3140: RETURN;
3141: end if;

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

3148: OR (l_old_kit_flag = 'Y'
3149: AND p_deliv_rec.kit_flag ='N'
3150: AND l_old_inventory_flag ='Y'))
3151: THEN
3152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3153: THEN
3154: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_UPD_KIT');
3155: FND_MSG_PUB.add;
3156: END IF;

Line 3155: FND_MSG_PUB.add;

3151: THEN
3152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3153: THEN
3154: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_UPD_KIT');
3155: FND_MSG_PUB.add;
3156: END IF;
3157: x_return_status := FND_API.g_ret_sts_error;
3158: RETURN;
3159: END IF;

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

3162: IF (l_old_electronic_flag='Y'
3163: AND p_deliv_rec.can_fulfill_electronic_flag = 'N'
3164: AND l_kits_check > 0)
3165: THEN
3166: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3167: THEN
3168: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3169: FND_MSG_PUB.add;
3170: END IF;

Line 3169: FND_MSG_PUB.add;

3165: THEN
3166: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3167: THEN
3168: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3169: FND_MSG_PUB.add;
3170: END IF;
3171: x_return_status := FND_API.g_ret_sts_error;
3172: RETURN;
3173: END IF;

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

3175: IF (l_old_physical_flag='Y'
3176: AND p_deliv_rec.can_fulfill_electronic_flag = 'Y'
3177: AND l_kits_check > 0) --l_check_deliv_has_kit = 'Y')
3178: THEN
3179: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3180: THEN
3181: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
3182: FND_MSG_PUB.add;
3183: END IF;

Line 3182: FND_MSG_PUB.add;

3178: THEN
3179: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3180: THEN
3181: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
3182: FND_MSG_PUB.add;
3183: END IF;
3184: x_return_status := FND_API.g_ret_sts_error;
3185: RETURN;
3186: END IF;

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

3189: AND l_old_inventory_flag ='N'
3190: AND p_deliv_rec.inventory_flag = 'Y'
3191: AND l_kits_check > 0)
3192: THEN
3193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3194: THEN
3195: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_IFLAG');
3196: FND_MSG_PUB.add;
3197: END IF;

Line 3196: FND_MSG_PUB.add;

3192: THEN
3193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3194: THEN
3195: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_IFLAG');
3196: FND_MSG_PUB.add;
3197: END IF;
3198: x_return_status := FND_API.g_ret_sts_error;
3199: RETURN;
3200: END IF;

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

3204: AND l_old_inventory_flag ='Y'
3205: AND p_deliv_rec.inventory_flag = 'N'
3206: AND l_kits_check > 0)
3207: THEN
3208: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3209: THEN
3210: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3211: FND_MSG_PUB.add;
3212: END IF;

Line 3211: FND_MSG_PUB.add;

3207: THEN
3208: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3209: THEN
3210: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3211: FND_MSG_PUB.add;
3212: END IF;
3213: x_return_status := FND_API.g_ret_sts_error;
3214: RETURN;
3215: END IF;

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

3417: l_end_date := p_deliv_rec.actual_avail_to_date;
3418: END IF;
3419:
3420: IF l_start_date > l_end_date THEN
3421: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3422: THEN
3423: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DATE_AFTER_DATE');
3424: FND_MSG_PUB.add;
3425: END IF;

Line 3424: FND_MSG_PUB.add;

3420: IF l_start_date > l_end_date THEN
3421: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3422: THEN
3423: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DATE_AFTER_DATE');
3424: FND_MSG_PUB.add;
3425: END IF;
3426: x_return_status := FND_API.g_ret_sts_error;
3427: END IF;
3428: END IF;

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

3442: l_fore_comp_date := p_deliv_rec.forecasted_complete_date;
3443: END IF;
3444:
3445: IF l_start_date < l_fore_comp_date THEN
3446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3447: THEN
3448: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_FOREC_AFTER_START');
3449: FND_MSG_PUB.add;
3450: END IF;

Line 3449: FND_MSG_PUB.add;

3445: IF l_start_date < l_fore_comp_date THEN
3446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3447: THEN
3448: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_FOREC_AFTER_START');
3449: FND_MSG_PUB.add;
3450: END IF;
3451: x_return_status := FND_API.g_ret_sts_error;
3452: END IF;
3453:

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

3453:
3454: /* remove on 06/07/2000 by khung
3455: IF p_deliv_rec.deliverable_id IS NULL THEN -- only for creation
3456: IF l_fore_comp_date < SYSDATE THEN
3457: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3458: THEN
3459: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_FOREC_BEFORE_TODAY');
3460: FND_MSG_PUB.add;
3461: END IF;

Line 3460: FND_MSG_PUB.add;

3456: IF l_fore_comp_date < SYSDATE THEN
3457: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3458: THEN
3459: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_FOREC_BEFORE_TODAY');
3460: FND_MSG_PUB.add;
3461: END IF;
3462: x_return_status := FND_API.g_ret_sts_error;
3463: END IF;
3464: END IF;

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

3658: OPEN c_deliv;
3659: FETCH c_deliv INTO l_deliv_rec;
3660: IF c_deliv%NOTFOUND THEN
3661: CLOSE c_deliv;
3662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3663: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3664: FND_MSG_PUB.add;
3665: END IF;
3666: RAISE FND_API.g_exc_error;

Line 3664: FND_MSG_PUB.add;

3660: IF c_deliv%NOTFOUND THEN
3661: CLOSE c_deliv;
3662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3663: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3664: FND_MSG_PUB.add;
3665: END IF;
3666: RAISE FND_API.g_exc_error;
3667: END IF;
3668: CLOSE c_deliv;

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

4442: AND (l_owner_user_id <> l_resource_id)
4443: AND (l_owner_user_id <> p_deliv_rec.owner_user_id))
4444: THEN
4445:
4446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4447: THEN
4448: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_OWNER');
4449: FND_MSG_PUB.add;
4450: END IF;

Line 4449: FND_MSG_PUB.add;

4445:
4446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4447: THEN
4448: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_OWNER');
4449: FND_MSG_PUB.add;
4450: END IF;
4451:
4452: x_return_status := FND_API.g_ret_sts_error;
4453: RETURN;

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

4505: FETCH check_budget INTO l_budget_lines;
4506: CLOSE check_budget;
4507:
4508: IF l_budget_lines = 'Y' THEN
4509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4510: THEN
4511: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_CURRENCY');
4512: FND_MSG_PUB.add;
4513: END IF;

Line 4512: FND_MSG_PUB.add;

4508: IF l_budget_lines = 'Y' THEN
4509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4510: THEN
4511: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_CURRENCY');
4512: FND_MSG_PUB.add;
4513: END IF;
4514: x_return_status := FND_API.g_ret_sts_error;
4515: RETURN;
4516: END IF;

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

4610:
4611: IF (p_deliv_rec.item_number IS NULL
4612: OR p_deliv_rec.item_number = FND_API.g_miss_char)
4613: THEN
4614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4615: THEN
4616: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_ENTER_PROPER_PARTNO');
4617: FND_MSG_PUB.add;
4618: END IF;

Line 4617: FND_MSG_PUB.add;

4613: THEN
4614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4615: THEN
4616: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_ENTER_PROPER_PARTNO');
4617: FND_MSG_PUB.add;
4618: END IF;
4619: x_return_status := FND_API.g_ret_sts_error;
4620: RETURN;
4621: END IF;

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

4621: END IF;
4622:
4623: IF (l_org_Id IS NULL)
4624: THEN
4625: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4626: THEN
4627: FND_MESSAGE.set_name('AMS', 'AMS_PROD_PROFILE_TIP');
4628: FND_MSG_PUB.add;
4629: END IF;

Line 4628: FND_MSG_PUB.add;

4624: THEN
4625: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4626: THEN
4627: FND_MESSAGE.set_name('AMS', 'AMS_PROD_PROFILE_TIP');
4628: FND_MSG_PUB.add;
4629: END IF;
4630: x_return_status := FND_API.g_ret_sts_error;
4631: RETURN;
4632: END IF;

Line 4702: FND_MSG_PUB.count_and_get(

4698: THEN
4699: x_msg_count := x_error_tbl.count;
4700: FOR i IN 1 .. x_error_tbl.count LOOP
4701: /*
4702: FND_MSG_PUB.count_and_get(
4703: p_encoded => FND_API.g_false,
4704: p_count => x_msg_count,
4705: p_data => x_error_tbl(i).message_text
4706: ); */

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

4705: p_data => x_error_tbl(i).message_text
4706: ); */
4707: IF x_error_tbl(i).message_name IS NOT NULL
4708: THEN
4709: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4710: THEN
4711: FND_MESSAGE.set_name('INV', x_error_tbl(i).message_name);
4712: FND_MSG_PUB.add;
4713: END IF;

Line 4712: FND_MSG_PUB.add;

4708: THEN
4709: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4710: THEN
4711: FND_MESSAGE.set_name('INV', x_error_tbl(i).message_name);
4712: FND_MSG_PUB.add;
4713: END IF;
4714: END IF;
4715: IF (AMS_DEBUG_HIGH_ON) THEN
4716:

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

4755: CLOSE get_active_flag;
4756:
4757: IF l_active_flag = 'N'
4758: THEN
4759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4760: THEN
4761: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_UPD_INACTIVE');
4762: FND_MSG_PUB.add;
4763: END IF;

Line 4762: FND_MSG_PUB.add;

4758: THEN
4759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4760: THEN
4761: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_UPD_INACTIVE');
4762: FND_MSG_PUB.add;
4763: END IF;
4764: x_return_status := FND_API.g_ret_sts_error;
4765: RETURN;
4766: END IF;