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 767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

763: AMS_UTILITY_PVT.debug_message('the return status from :'||l_return_status);
764: END IF;
765:
766: IF l_return_status = FND_API.g_ret_sts_error THEN
767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
768: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
769: END IF;
770:
771: FND_MSG_PUB.count_and_get(

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

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

Line 771: FND_MSG_PUB.count_and_get(

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

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

776:
777: RAISE FND_API.g_exc_error;
778:
779: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
781: THEN
782: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
783: END IF;
784:

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

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

Line 785: FND_MSG_PUB.count_and_get(

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

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

811: );
812:
813: IF l_return_status = FND_API.g_ret_sts_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: IF l_return_status = FND_API.g_ret_sts_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 828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

824: );
825: RAISE FND_API.g_exc_error;
826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
827:
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
829: THEN
830: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
831: END IF;
832:

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

826: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
827:
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
829: THEN
830: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
831: END IF;
832:
833: FND_MSG_PUB.count_and_get(
834: p_encoded => FND_API.g_false,

Line 833: FND_MSG_PUB.count_and_get(

829: THEN
830: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
831: END IF;
832:
833: FND_MSG_PUB.count_and_get(
834: p_encoded => FND_API.g_false,
835: p_count => x_msg_count,
836: p_data => x_msg_data
837: );

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

861: p_association_rec => l_association_rec,
862: x_object_association_id => l_object_association_id
863: );
864: IF l_return_status = FND_API.g_ret_sts_error THEN
865: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
866: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
867: END IF;
868: FND_MSG_PUB.count_and_get
869: (

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

862: x_object_association_id => l_object_association_id
863: );
864: IF l_return_status = FND_API.g_ret_sts_error THEN
865: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
866: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
867: END IF;
868: FND_MSG_PUB.count_and_get
869: (
870: p_encoded => FND_API.g_false,

Line 868: FND_MSG_PUB.count_and_get

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

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

872: p_data => x_msg_data
873: );
874: RAISE FND_API.g_exc_error;
875: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
876: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
877: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
878: END IF;
879: FND_MSG_PUB.count_and_get
880: (

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

873: );
874: RAISE FND_API.g_exc_error;
875: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
876: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
877: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
878: END IF;
879: FND_MSG_PUB.count_and_get
880: (
881: p_encoded => FND_API.g_false,

Line 879: FND_MSG_PUB.count_and_get

875: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
876: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
877: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
878: END IF;
879: FND_MSG_PUB.count_and_get
880: (
881: p_encoded => FND_API.g_false,
882: p_count => x_msg_count,
883: p_data => x_msg_data

Line 897: FND_MSG_PUB.count_and_get(

893: IF FND_API.to_boolean(p_commit) THEN
894: COMMIT;
895: END IF;
896:
897: FND_MSG_PUB.count_and_get(
898: p_encoded => FND_API.g_false,
899: p_count => x_msg_count,
900: p_data => x_msg_data
901: );

Line 912: FND_MSG_PUB.count_and_get(

908:
909: WHEN FND_API.g_exc_error THEN
910: ROLLBACK TO create_deliverable;
911: x_return_status := FND_API.g_ret_sts_error;
912: FND_MSG_PUB.count_and_get(
913: p_encoded => FND_API.g_false,
914: p_count => x_msg_count,
915: p_data => x_msg_data
916: );

Line 921: FND_MSG_PUB.count_and_get(

917:
918: WHEN FND_API.g_exc_unexpected_error THEN
919: ROLLBACK TO create_deliverable;
920: x_return_status := FND_API.g_ret_sts_unexp_error ;
921: FND_MSG_PUB.count_and_get(
922: p_encoded => FND_API.g_false,
923: p_count => x_msg_count,
924: p_data => x_msg_data
925: );

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

927: WHEN OTHERS THEN
928: ROLLBACK TO create_deliverable;
929: x_return_status := FND_API.g_ret_sts_unexp_error ;
930:
931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
932: THEN
933: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
934: END IF;
935:

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

929: x_return_status := FND_API.g_ret_sts_unexp_error ;
930:
931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
932: THEN
933: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
934: END IF;
935:
936: FND_MSG_PUB.count_and_get(
937: p_encoded => FND_API.g_false,

Line 936: FND_MSG_PUB.count_and_get(

932: THEN
933: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
934: END IF;
935:
936: FND_MSG_PUB.count_and_get(
937: p_encoded => FND_API.g_false,
938: p_count => x_msg_count,
939: p_data => x_msg_data
940: );

Line 982: FND_MSG_PUB.initialize;

978: AMS_Utility_PVT.debug_message(l_full_name||': start');
979: END IF;
980:
981: IF FND_API.to_boolean(p_init_msg_list) THEN
982: FND_MSG_PUB.initialize;
983: END IF;
984:
985: IF NOT FND_API.compatible_api_call(
986: l_api_version,

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

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

Line 1009: FND_MSG_PUB.add;

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

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

1014: DELETE FROM ams_deliverables_all_tl
1015: WHERE deliverable_id = p_deliv_id;
1016:
1017: IF (SQL%NOTFOUND) THEN
1018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1019: THEN
1020: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1021: FND_MSG_PUB.add;
1022: END IF;

Line 1021: FND_MSG_PUB.add;

1017: IF (SQL%NOTFOUND) THEN
1018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1019: THEN
1020: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1021: FND_MSG_PUB.add;
1022: END IF;
1023: RAISE FND_API.g_exc_error;
1024: END IF;
1025:

Line 1031: FND_MSG_PUB.count_and_get(

1027: IF FND_API.to_boolean(p_commit) THEN
1028: COMMIT;
1029: END IF;
1030:
1031: FND_MSG_PUB.count_and_get(
1032: p_encoded => FND_API.g_false,
1033: p_count => x_msg_count,
1034: p_data => x_msg_data
1035: );

Line 1046: FND_MSG_PUB.count_and_get(

1042:
1043: WHEN FND_API.g_exc_error THEN
1044: ROLLBACK TO delete_deliverable;
1045: x_return_status := FND_API.g_ret_sts_error;
1046: FND_MSG_PUB.count_and_get(
1047: p_encoded => FND_API.g_false,
1048: p_count => x_msg_count,
1049: p_data => x_msg_data
1050: );

Line 1055: FND_MSG_PUB.count_and_get(

1051:
1052: WHEN FND_API.g_exc_unexpected_error THEN
1053: ROLLBACK TO delete_deliverable;
1054: x_return_status := FND_API.g_ret_sts_unexp_error ;
1055: FND_MSG_PUB.count_and_get(
1056: p_encoded => FND_API.g_false,
1057: p_count => x_msg_count,
1058: p_data => x_msg_data
1059: );

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

1061: WHEN OTHERS THEN
1062: ROLLBACK TO delete_deliverable;
1063: x_return_status := FND_API.g_ret_sts_unexp_error ;
1064:
1065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1066: THEN
1067: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1068: END IF;
1069:

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

1063: x_return_status := FND_API.g_ret_sts_unexp_error ;
1064:
1065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1066: THEN
1067: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1068: END IF;
1069:
1070: FND_MSG_PUB.count_and_get(
1071: p_encoded => FND_API.g_false,

Line 1070: FND_MSG_PUB.count_and_get(

1066: THEN
1067: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1068: END IF;
1069:
1070: FND_MSG_PUB.count_and_get(
1071: p_encoded => FND_API.g_false,
1072: p_count => x_msg_count,
1073: p_data => x_msg_data
1074: );

Line 1130: FND_MSG_PUB.initialize;

1126: AMS_Utility_PVT.debug_message(l_full_name||': start');
1127: END IF;
1128:
1129: IF FND_API.to_boolean(p_init_msg_list) THEN
1130: FND_MSG_PUB.initialize;
1131: END IF;
1132:
1133: IF NOT FND_API.compatible_api_call(
1134: l_api_version,

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

1150: OPEN c_deliv_b;
1151: FETCH c_deliv_b INTO l_deliv_id;
1152: IF (c_deliv_b%NOTFOUND) THEN
1153: CLOSE c_deliv_b;
1154: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1155: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1156: FND_MSG_PUB.add;
1157: END IF;
1158: RAISE FND_API.g_exc_error;

Line 1156: FND_MSG_PUB.add;

1152: IF (c_deliv_b%NOTFOUND) THEN
1153: CLOSE c_deliv_b;
1154: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1155: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1156: FND_MSG_PUB.add;
1157: END IF;
1158: RAISE FND_API.g_exc_error;
1159: END IF;
1160: CLOSE c_deliv_b;

Line 1166: FND_MSG_PUB.count_and_get(

1162: OPEN c_deliv_tl;
1163: CLOSE c_deliv_tl;
1164:
1165: -------------------- finish --------------------------
1166: FND_MSG_PUB.count_and_get(
1167: p_encoded => FND_API.g_false,
1168: p_count => x_msg_count,
1169: p_data => x_msg_data
1170: );

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

1172: EXCEPTION
1173:
1174: WHEN AMS_Utility_PVT.resource_locked THEN
1175: x_return_status := FND_API.g_ret_sts_error;
1176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1177: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1178: FND_MSG_PUB.add;
1179: END IF;
1180:

Line 1178: FND_MSG_PUB.add;

1174: WHEN AMS_Utility_PVT.resource_locked THEN
1175: x_return_status := FND_API.g_ret_sts_error;
1176: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1177: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1178: FND_MSG_PUB.add;
1179: END IF;
1180:
1181: FND_MSG_PUB.count_and_get(
1182: p_encoded => FND_API.g_false,

Line 1181: FND_MSG_PUB.count_and_get(

1177: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1178: FND_MSG_PUB.add;
1179: END IF;
1180:
1181: FND_MSG_PUB.count_and_get(
1182: p_encoded => FND_API.g_false,
1183: p_count => x_msg_count,
1184: p_data => x_msg_data
1185: );

Line 1189: FND_MSG_PUB.count_and_get(

1185: );
1186:
1187: WHEN FND_API.g_exc_error THEN
1188: x_return_status := FND_API.g_ret_sts_error;
1189: FND_MSG_PUB.count_and_get(
1190: p_encoded => FND_API.g_false,
1191: p_count => x_msg_count,
1192: p_data => x_msg_data
1193: );

Line 1197: FND_MSG_PUB.count_and_get(

1193: );
1194:
1195: WHEN FND_API.g_exc_unexpected_error THEN
1196: x_return_status := FND_API.g_ret_sts_unexp_error ;
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 1205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1201: );
1202:
1203: WHEN OTHERS THEN
1204: x_return_status := FND_API.g_ret_sts_unexp_error ;
1205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1206: THEN
1207: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1208: END IF;
1209:

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

1203: WHEN OTHERS THEN
1204: x_return_status := FND_API.g_ret_sts_unexp_error ;
1205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1206: THEN
1207: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1208: END IF;
1209:
1210: FND_MSG_PUB.count_and_get(
1211: p_encoded => FND_API.g_false,

Line 1210: FND_MSG_PUB.count_and_get(

1206: THEN
1207: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1208: END IF;
1209:
1210: FND_MSG_PUB.count_and_get(
1211: p_encoded => FND_API.g_false,
1212: p_count => x_msg_count,
1213: p_data => x_msg_data
1214: );

Line 1426: FND_MSG_PUB.initialize;

1422: AMS_Utility_PVT.debug_message(l_full_name||': start');
1423: END IF;
1424:
1425: IF FND_API.to_boolean(p_init_msg_list) THEN
1426: FND_MSG_PUB.initialize;
1427: END IF;
1428:
1429: IF NOT FND_API.compatible_api_call(
1430: l_api_version,

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

1450: fetch get_res_id into l_res_id;
1451: close get_res_id;
1452: end if;
1453: if AMS_ACCESS_PVT.check_update_access(l_deliv_rec.deliverable_id, 'DELV', l_res_id, 'USER') = 'N' then
1454: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1455: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');-- reusing the message
1456: FND_MSG_PUB.add;
1457: END IF;
1458: RAISE FND_API.g_exc_error;

Line 1456: FND_MSG_PUB.add;

1452: end if;
1453: if AMS_ACCESS_PVT.check_update_access(l_deliv_rec.deliverable_id, 'DELV', l_res_id, 'USER') = 'N' then
1454: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1455: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');-- reusing the message
1456: FND_MSG_PUB.add;
1457: END IF;
1458: RAISE FND_API.g_exc_error;
1459: end if;
1460: --01/24/02 added for access check bug #2764852 mukumar end

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

1928: IF (AMS_DEBUG_HIGH_ON) THEN
1929:
1930: ams_utility_pvt.debug_message (' SQL NOT FOUND ');
1931: END IF;
1932: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1933: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1934: FND_MSG_PUB.add;
1935: END IF;
1936: RAISE FND_API.g_exc_error;

Line 1934: FND_MSG_PUB.add;

1930: ams_utility_pvt.debug_message (' SQL NOT FOUND ');
1931: END IF;
1932: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1933: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1934: FND_MSG_PUB.add;
1935: END IF;
1936: RAISE FND_API.g_exc_error;
1937: END IF;
1938: IF (AMS_DEBUG_HIGH_ON) THEN

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

1949: WHERE deliverable_id = l_deliv_rec.deliverable_id
1950: AND USERENV('LANG') IN (language, source_lang);
1951:
1952: IF (SQL%NOTFOUND) THEN
1953: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1954: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1955: FND_MSG_PUB.add;
1956: END IF;
1957: RAISE FND_API.g_exc_error;

Line 1955: FND_MSG_PUB.add;

1951:
1952: IF (SQL%NOTFOUND) THEN
1953: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1954: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1955: FND_MSG_PUB.add;
1956: END IF;
1957: RAISE FND_API.g_exc_error;
1958: END IF;
1959:

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

2011: --
2012: -- IF Approval_required_flag( l_deliv_rec.setup_id, 'BAPL') = FND_API.g_true
2013: -- AND l_budget_lines_exist = 'N' THEN
2014: --
2015: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2016: -- FND_MESSAGE.set_name('AMS', 'AMS_EVE_NO_BGT_SRC');
2017: -- FND_MSG_PUB.add;
2018: -- END IF;
2019: -- RAISE FND_API.g_exc_error;

Line 2017: -- FND_MSG_PUB.add;

2013: -- AND l_budget_lines_exist = 'N' THEN
2014: --
2015: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2016: -- FND_MESSAGE.set_name('AMS', 'AMS_EVE_NO_BGT_SRC');
2017: -- FND_MSG_PUB.add;
2018: -- END IF;
2019: -- RAISE FND_API.g_exc_error;
2020: -- END IF;
2021: -- *****************************************

Line 2078: FND_MSG_PUB.count_and_get(

2074: IF FND_API.to_boolean(p_commit) THEN
2075: COMMIT;
2076: END IF;
2077:
2078: FND_MSG_PUB.count_and_get(
2079: p_encoded => FND_API.g_false,
2080: p_count => x_msg_count,
2081: p_data => x_msg_data
2082: );

Line 2097: FND_MSG_PUB.count_and_get(

2093:
2094: WHEN FND_API.g_exc_error THEN
2095: ROLLBACK TO update_deliverable;
2096: x_return_status := FND_API.g_ret_sts_error;
2097: FND_MSG_PUB.count_and_get(
2098: p_encoded => FND_API.g_false,
2099: p_count => x_msg_count,
2100: p_data => x_msg_data
2101: );

Line 2106: FND_MSG_PUB.count_and_get(

2102:
2103: WHEN FND_API.g_exc_unexpected_error THEN
2104: ROLLBACK TO update_deliverable;
2105: x_return_status := FND_API.g_ret_sts_unexp_error ;
2106: FND_MSG_PUB.count_and_get(
2107: p_encoded => FND_API.g_false,
2108: p_count => x_msg_count,
2109: p_data => x_msg_data
2110: );

Line 2114: --FND_MSG_PUB.count_and_get(

2110: );
2111:
2112: WHEN inv_creation_error THEN
2113: /*-modify on 08/07/2000 khung
2114: --FND_MSG_PUB.count_and_get(
2115: p_encoded => FND_API.g_false,
2116: -- p_count => x_msg_count,
2117: -- p_data => x_msg_data
2118: -- );*/

Line 2121: FND_MSG_PUB.count_and_get(

2117: -- p_data => x_msg_data
2118: -- );*/
2119: ROLLBACK TO update_deliverable;
2120: FOR i IN 1 .. x_error_tbl.count LOOP
2121: FND_MSG_PUB.count_and_get(
2122: p_encoded => FND_API.g_false,
2123: p_count => x_msg_count,
2124: p_data => x_error_tbl(i).message_text
2125: );

Line 2134: FND_MSG_PUB.count_and_get(

2130: END LOOP;
2131:
2132: WHEN jtf_inv_item_creation_error THEN
2133: ROLLBACK TO update_deliverable;
2134: FND_MSG_PUB.count_and_get(
2135: p_encoded => FND_API.g_false,
2136: p_count => x_msg_count,
2137: p_data => x_msg_data
2138: );

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

2138: );
2139: WHEN OTHERS THEN
2140: ROLLBACK TO update_deliverable;
2141: x_return_status := FND_API.g_ret_sts_unexp_error ;
2142: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2143: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2144: END IF;
2145: FND_MSG_PUB.count_and_get(
2146: p_encoded => FND_API.g_false,

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

2139: WHEN OTHERS THEN
2140: ROLLBACK TO update_deliverable;
2141: x_return_status := FND_API.g_ret_sts_unexp_error ;
2142: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2143: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2144: END IF;
2145: FND_MSG_PUB.count_and_get(
2146: p_encoded => FND_API.g_false,
2147: p_count => x_msg_count,

Line 2145: FND_MSG_PUB.count_and_get(

2141: x_return_status := FND_API.g_ret_sts_unexp_error ;
2142: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2143: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2144: END IF;
2145: FND_MSG_PUB.count_and_get(
2146: p_encoded => FND_API.g_false,
2147: p_count => x_msg_count,
2148: p_data => x_msg_data
2149: );

Line 2187: FND_MSG_PUB.initialize;

2183: AMS_Utility_PVT.debug_message(l_full_name||': start');
2184: END IF;
2185:
2186: IF FND_API.to_boolean(p_init_msg_list) THEN
2187: FND_MSG_PUB.initialize;
2188: END IF;
2189:
2190: IF NOT FND_API.compatible_api_call(
2191: l_api_version,

Line 2258: FND_MSG_PUB.count_and_get(

2254:
2255: END IF;
2256:
2257: -------------------- finish --------------------------
2258: FND_MSG_PUB.count_and_get(
2259: p_encoded => FND_API.g_false,
2260: p_count => x_msg_count,
2261: p_data => x_msg_data
2262: );

Line 2276: FND_MSG_PUB.count_and_get(

2272: EXCEPTION
2273:
2274: WHEN FND_API.g_exc_error THEN
2275: x_return_status := FND_API.g_ret_sts_error;
2276: FND_MSG_PUB.count_and_get(
2277: p_encoded => FND_API.g_false,
2278: p_count => x_msg_count,
2279: p_data => x_msg_data
2280: );

Line 2284: FND_MSG_PUB.count_and_get(

2280: );
2281:
2282: WHEN FND_API.g_exc_unexpected_error THEN
2283: x_return_status := FND_API.g_ret_sts_unexp_error ;
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 2292: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

2288: );
2289:
2290: WHEN OTHERS THEN
2291: x_return_status := FND_API.g_ret_sts_unexp_error;
2292: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2293: THEN
2294: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2295: END IF;
2296:

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

2290: WHEN OTHERS THEN
2291: x_return_status := FND_API.g_ret_sts_unexp_error;
2292: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2293: THEN
2294: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2295: END IF;
2296:
2297: FND_MSG_PUB.count_and_get(
2298: p_encoded => FND_API.g_false,

Line 2297: FND_MSG_PUB.count_and_get(

2293: THEN
2294: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2295: END IF;
2296:
2297: FND_MSG_PUB.count_and_get(
2298: p_encoded => FND_API.g_false,
2299: p_count => x_msg_count,
2300: p_data => x_msg_data
2301: );

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

2321:
2322: -------------------- put required items here ---------------------
2323:
2324: IF p_deliv_rec.language_code IS NULL THEN
2325: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2326: THEN
2327: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_LANGUAGE_CODE');
2328: FND_MSG_PUB.add;
2329: END IF;

Line 2328: FND_MSG_PUB.add;

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

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

2332: RETURN;
2333: END IF;
2334:
2335: IF p_deliv_rec.deliverable_name IS NULL THEN
2336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2337: THEN
2338: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_DELIVERABLE_NAME');
2339: FND_MSG_PUB.add;
2340: END IF;

Line 2339: FND_MSG_PUB.add;

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

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

2343: RETURN;
2344: END IF;
2345:
2346: IF p_deliv_rec.actual_avail_from_date IS NULL THEN
2347: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2348: THEN
2349: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_FROM_DATE');
2350: FND_MSG_PUB.add;
2351: END IF;

Line 2350: FND_MSG_PUB.add;

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

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

2354: RETURN;
2355: END IF;
2356:
2357: IF p_deliv_rec.actual_avail_to_date IS NULL THEN
2358: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2359: THEN
2360: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_TO_DATE');
2361: FND_MSG_PUB.add;
2362: END IF;

Line 2361: FND_MSG_PUB.add;

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

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

2365: RETURN;
2366: END IF;
2367:
2368: IF p_deliv_rec.forecasted_complete_date IS NULL THEN
2369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2370: THEN
2371: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_NO_FOREC_DATE');
2372: FND_MSG_PUB.add;
2373: END IF;

Line 2372: FND_MSG_PUB.add;

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

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

2376: RETURN;
2377: END IF;
2378:
2379: IF p_deliv_rec.owner_user_id IS NULL THEN
2380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2381: THEN
2382: FND_MESSAGE.set_name('AMS', 'AMS_EVT_REG_NO_OWNER_ID');
2383: FND_MSG_PUB.add;
2384: END IF;

Line 2383: FND_MSG_PUB.add;

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

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

2387: RETURN;
2388: END IF;
2389:
2390: IF p_deliv_rec.setup_id IS NULL THEN
2391: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2392: THEN
2393: FND_MESSAGE.set_name('AMS', 'AMS_FUND_NO_CUSTOM_SETUP');
2394: FND_MSG_PUB.add;
2395: END IF;

Line 2394: FND_MSG_PUB.add;

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

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

2398: RETURN;
2399: END IF;
2400:
2401: IF p_deliv_rec.country_id IS NULL THEN
2402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2403: THEN
2404: FND_MESSAGE.set_name('AMS', 'AMS_DILG_BAD_CITY');
2405: FND_MSG_PUB.add;
2406: END IF;

Line 2405: FND_MSG_PUB.add;

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

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

2409: RETURN;
2410: END IF;
2411:
2412: IF p_deliv_rec.category_Type_id IS NULL THEN
2413: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2414: THEN
2415: FND_MESSAGE.set_name('AMS', 'AMS_ACT_CAT_NO_CATEGORY_ID');
2416: FND_MSG_PUB.add;
2417: END IF;

Line 2416: FND_MSG_PUB.add;

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

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

2420: RETURN;
2421: END IF;
2422:
2423: IF p_deliv_rec.category_sub_Type_id IS NULL THEN
2424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2425: THEN
2426: FND_MESSAGE.set_name('AMS', 'AMS_SUB_CATEGORY_IS_MISSING');
2427: FND_MSG_PUB.add;
2428: END IF;

Line 2427: FND_MSG_PUB.add;

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

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

2431: RETURN;
2432: END IF;
2433:
2434: IF p_deliv_rec.version IS NULL THEN
2435: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2436: THEN
2437: FND_MESSAGE.set_name('AMS', 'AMS_DELV_VERSION_MISSING');
2438: FND_MSG_PUB.add;
2439: END IF;

Line 2438: FND_MSG_PUB.add;

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

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

2442: RETURN;
2443: END IF;
2444:
2445: IF p_deliv_rec.transaction_currency_code IS NULL THEN
2446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2447: THEN
2448: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BUDGET_NO_CURRENCY');
2449: FND_MSG_PUB.add;
2450: END IF;

Line 2449: FND_MSG_PUB.add;

2445: IF p_deliv_rec.transaction_currency_code IS NULL THEN
2446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2447: THEN
2448: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BUDGET_NO_CURRENCY');
2449: FND_MSG_PUB.add;
2450: END IF;
2451:
2452: x_return_status := FND_API.g_ret_sts_error;
2453: RETURN;

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

2506: 'ams_deliverables_vl',
2507: 'deliverable_id = ' || p_deliv_rec.deliverable_id
2508: ) = FND_API.g_false
2509: THEN
2510: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2511: THEN
2512: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_ID');
2513: FND_MSG_PUB.add;
2514: END IF;

Line 2513: FND_MSG_PUB.add;

2509: THEN
2510: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2511: THEN
2512: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_ID');
2513: FND_MSG_PUB.add;
2514: END IF;
2515: x_return_status := FND_API.g_ret_sts_error;
2516: RETURN;
2517: END IF;

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

2532: CLOSE c_check_uniq;
2533:
2534: IF (l_uniq_flag = 'N')
2535: THEN
2536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2537: THEN
2538: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUP_NAME_VERSION');
2539: FND_MSG_PUB.add;
2540: END IF;

Line 2539: FND_MSG_PUB.add;

2535: THEN
2536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2537: THEN
2538: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUP_NAME_VERSION');
2539: FND_MSG_PUB.add;
2540: END IF;
2541: x_return_status := FND_API.g_ret_sts_error;
2542: RETURN;
2543: END IF;

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

2560: END IF;
2561:
2562: IF (l_uniq_flag_u = 'N')
2563: THEN
2564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2565: THEN
2566: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUP_NAME_VERSION');
2567: FND_MSG_PUB.add;
2568: END IF;

Line 2567: FND_MSG_PUB.add;

2563: THEN
2564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2565: THEN
2566: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUP_NAME_VERSION');
2567: FND_MSG_PUB.add;
2568: END IF;
2569: x_return_status := FND_API.g_ret_sts_error;
2570: RETURN;
2571: END IF;

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

2589: -- ''' AND deliverable_id <> ' || p_deliv_rec.deliverable_id
2590: -- );
2591: --END IF;
2592: --IF l_valid_flag = FND_API.g_false THEN
2593: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2594: -- THEN
2595: -- FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_NAME');
2596: -- FND_MSG_PUB.add;
2597: -- END IF;

Line 2596: -- FND_MSG_PUB.add;

2592: --IF l_valid_flag = FND_API.g_false THEN
2593: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2594: -- THEN
2595: -- FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DUPLICATE_NAME');
2596: -- FND_MSG_PUB.add;
2597: -- END IF;
2598: -- x_return_status := FND_API.g_ret_sts_error;
2599: -- RETURN;
2600: --END IF;

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

2660: 'category_id',
2661: p_deliv_rec.category_type_id
2662: ) = FND_API.g_false
2663: THEN
2664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2665: THEN
2666: FND_MESSAGE.set_name('AMS', 'AMS_FUND_BAD_CATEGORY_ID');
2667: FND_MSG_PUB.add;
2668: END IF;

Line 2667: FND_MSG_PUB.add;

2663: THEN
2664: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2665: THEN
2666: FND_MESSAGE.set_name('AMS', 'AMS_FUND_BAD_CATEGORY_ID');
2667: FND_MSG_PUB.add;
2668: END IF;
2669: x_return_status := FND_API.g_ret_sts_error;
2670: RETURN;
2671: END IF;

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

2680: 'category_id',
2681: p_deliv_rec.category_sub_type_id
2682: ) = FND_API.g_false
2683: THEN
2684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2685: THEN
2686: FND_MESSAGE.set_name('AMS', 'AMS_SUB_CATEGORY_IS_MISSING');
2687: FND_MSG_PUB.add;
2688: END IF;

Line 2687: FND_MSG_PUB.add;

2683: THEN
2684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2685: THEN
2686: FND_MESSAGE.set_name('AMS', 'AMS_SUB_CATEGORY_IS_MISSING');
2687: FND_MSG_PUB.add;
2688: END IF;
2689: x_return_status := FND_API.g_ret_sts_error;
2690: RETURN;
2691: END IF;

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

2700: 'custom_setup_id',
2701: p_deliv_rec.setup_id
2702: ) = FND_API.g_false
2703: THEN
2704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2705: THEN
2706: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_CUSTOM_SETUP');
2707: FND_MSG_PUB.add;
2708: END IF;

Line 2707: FND_MSG_PUB.add;

2703: THEN
2704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2705: THEN
2706: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_BAD_CUSTOM_SETUP');
2707: FND_MSG_PUB.add;
2708: END IF;
2709: x_return_status := FND_API.g_ret_sts_error;
2710: RETURN;
2711: END IF;

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

2808: p_lookup_type => 'AMS_DELIV_STATUS',
2809: p_lookup_code => p_deliv_rec.status_code
2810: ) = FND_API.g_false
2811: THEN
2812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2813: THEN
2814: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_STATUS_CODE');
2815: FND_MSG_PUB.add;
2816: END IF;

Line 2815: FND_MSG_PUB.add;

2811: THEN
2812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2813: THEN
2814: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_STATUS_CODE');
2815: FND_MSG_PUB.add;
2816: END IF;
2817:
2818: x_return_status := FND_API.g_ret_sts_error;
2819: RETURN;

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

2920: AND p_deliv_rec.kit_flag IS NOT NULL
2921: THEN
2922: IF AMS_Utility_PVT.is_Y_or_N(p_deliv_rec.kit_flag) = FND_API.g_false
2923: THEN
2924: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2925: THEN
2926: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_KIT_FLAG');
2927: FND_MSG_PUB.add;
2928: END IF;

Line 2927: FND_MSG_PUB.add;

2923: THEN
2924: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2925: THEN
2926: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_BAD_KIT_FLAG');
2927: FND_MSG_PUB.add;
2928: END IF;
2929:
2930: x_return_status := FND_API.g_ret_sts_error;
2931: RETURN;

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

2960: OR (l_old_kit_flag = 'Y' AND p_deliv_rec.kit_flag = 'N')
2961: OR (l_old_kit_flag = 'N' AND p_deliv_rec.kit_flag = 'Y'))
2962: )
2963: THEN
2964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2965: THEN
2966: FND_MESSAGE.set_name('AMS', 'AMS_DELV_NO_UPD_AVAL_STATUS');
2967: FND_MSG_PUB.add;
2968: END IF;

Line 2967: FND_MSG_PUB.add;

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

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

2972:
2973: IF (l_old_electronic_flag='N'
2974: AND p_deliv_rec.can_fulfill_electronic_flag = 'Y'
2975: AND l_old_inventory_flag ='Y' )THEN
2976: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2977: THEN
2978: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
2979: FND_MSG_PUB.add;
2980: END IF;

Line 2979: FND_MSG_PUB.add;

2975: AND l_old_inventory_flag ='Y' )THEN
2976: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2977: THEN
2978: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
2979: FND_MSG_PUB.add;
2980: END IF;
2981: x_return_status := FND_API.g_ret_sts_error;
2982: RETURN;
2983: END IF;

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

2986: -- if an inv item is attached ,cannot make electronic to physical
2987: IF (l_old_physical_flag='N'
2988: AND p_deliv_rec.can_fulfill_physical_flag = 'Y'
2989: AND l_old_inventory_flag ='Y' )THEN
2990: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2991: THEN
2992: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
2993: FND_MSG_PUB.add;
2994: END IF;

Line 2993: FND_MSG_PUB.add;

2989: AND l_old_inventory_flag ='Y' )THEN
2990: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2991: THEN
2992: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
2993: FND_MSG_PUB.add;
2994: END IF;
2995: x_return_status := FND_API.g_ret_sts_error;
2996: RETURN;
2997: -- if an inv item is attached ,cannot change phy-inventoried to stock manually

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

3000: AND p_deliv_rec.inventory_flag='N'
3001: AND p_deliv_rec.can_fulfill_physical_flag = 'Y'
3002: AND (p_deliv_rec.kit_flag ='N' OR (p_deliv_rec.kit_flag='Y' and l_qp_profile='Y')))
3003: THEN
3004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3005: THEN
3006: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3007: FND_MSG_PUB.add;
3008: END IF;

Line 3007: FND_MSG_PUB.add;

3003: THEN
3004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3005: THEN
3006: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3007: FND_MSG_PUB.add;
3008: END IF;
3009: x_return_status := FND_API.g_ret_sts_error;
3010: RETURN;
3011: END IF;

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

3016:
3017: IF (l_old_electronic_flag='N'
3018: AND p_deliv_rec.can_fulfill_electronic_flag = 'Y'
3019: AND l_quantity_on_hand >0 )THEN
3020: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3021: THEN
3022: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
3023: FND_MSG_PUB.add;
3024: END IF;

Line 3023: FND_MSG_PUB.add;

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

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

3031: END IF;
3032: IF (l_old_inventory_flag='N'
3033: AND p_deliv_rec.inventory_flag = 'Y'
3034: AND l_quantity_on_hand >0 )THEN
3035: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3036: THEN
3037: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_IFLAG');
3038: FND_MSG_PUB.add;
3039: END IF;

Line 3038: FND_MSG_PUB.add;

3034: AND l_quantity_on_hand >0 )THEN
3035: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3036: THEN
3037: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_IFLAG');
3038: FND_MSG_PUB.add;
3039: END IF;
3040: x_return_status := FND_API.g_ret_sts_error;
3041: RETURN;
3042: END IF;

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

3054: IF (l_old_electronic_flag='Y'
3055: AND p_deliv_rec.can_fulfill_electronic_flag = 'N'
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_PFLAG');
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_PFLAG');
3061: FND_MSG_PUB.add;
3062: END IF;
3063: x_return_status := FND_API.g_ret_sts_error;
3064: RETURN;
3065: END IF;

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

3067: IF (l_old_physical_flag='Y'
3068: AND p_deliv_rec.can_fulfill_electronic_flag = 'Y'
3069: AND l_kits_check > 0)
3070: THEN
3071: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3072: THEN
3073: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
3074: FND_MSG_PUB.add;
3075: END IF;

Line 3074: FND_MSG_PUB.add;

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

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

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

Line 3088: FND_MSG_PUB.add;

3084: THEN
3085: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3086: THEN
3087: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_IFLAG');
3088: FND_MSG_PUB.add;
3089: END IF;
3090: x_return_status := FND_API.g_ret_sts_error;
3091: RETURN;
3092: END IF;

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

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

Line 3103: FND_MSG_PUB.add;

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

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

3110: AND p_deliv_rec.inventory_flag = 'N'
3111: AND l_kits_check > 0
3112: AND p_deliv_rec.non_inv_quantity_on_hand >0)
3113: THEN
3114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3115: THEN
3116: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3117: FND_MSG_PUB.add;
3118: END IF;

Line 3117: FND_MSG_PUB.add;

3113: THEN
3114: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3115: THEN
3116: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3117: FND_MSG_PUB.add;
3118: END IF;
3119: x_return_status := FND_API.g_ret_sts_error;
3120: RETURN;
3121: */

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

3127: --IF DELIV is a KIT, the KIT FLAG cannot be updated to N
3128:
3129: -- If the deliv is a kit, cannot upd kit flag to 'N'
3130: if ((l_kits_check > 0) AND (p_deliv_rec.kit_flag = 'N')) then
3131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3132: THEN
3133: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_UPD_KIT_TO_N');
3134: FND_MSG_PUB.add;
3135: END IF;

Line 3134: FND_MSG_PUB.add;

3130: if ((l_kits_check > 0) AND (p_deliv_rec.kit_flag = 'N')) then
3131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3132: THEN
3133: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_UPD_KIT_TO_N');
3134: FND_MSG_PUB.add;
3135: END IF;
3136: x_return_status := FND_API.g_ret_sts_error;
3137: RETURN;
3138: end if;

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

3143: FETCH is_deliv_kit_part INTO l_kits_check;
3144: CLOSE is_deliv_kit_part;
3145:
3146: if ((l_kits_check > 0) AND (p_deliv_rec.kit_flag = 'Y')) then
3147: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3148: THEN
3149: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_UPD_KIT_TO_Y');
3150: FND_MSG_PUB.add;
3151: END IF;

Line 3150: FND_MSG_PUB.add;

3146: if ((l_kits_check > 0) AND (p_deliv_rec.kit_flag = 'Y')) then
3147: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3148: THEN
3149: FND_MESSAGE.set_name('AMS', 'AMS_CANNOT_UPD_KIT_TO_Y');
3150: FND_MSG_PUB.add;
3151: END IF;
3152: x_return_status := FND_API.g_ret_sts_error;
3153: RETURN;
3154: end if;

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

3161: OR (l_old_kit_flag = 'Y'
3162: AND p_deliv_rec.kit_flag ='N'
3163: AND l_old_inventory_flag ='Y'))
3164: THEN
3165: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3166: THEN
3167: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_UPD_KIT');
3168: FND_MSG_PUB.add;
3169: END IF;

Line 3168: FND_MSG_PUB.add;

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

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

3175: IF (l_old_electronic_flag='Y'
3176: AND p_deliv_rec.can_fulfill_electronic_flag = 'N'
3177: AND l_kits_check > 0)
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_PFLAG');
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_PFLAG');
3182: FND_MSG_PUB.add;
3183: END IF;
3184: x_return_status := FND_API.g_ret_sts_error;
3185: RETURN;
3186: END IF;

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

3188: IF (l_old_physical_flag='Y'
3189: AND p_deliv_rec.can_fulfill_electronic_flag = 'Y'
3190: AND l_kits_check > 0) --l_check_deliv_has_kit = 'Y')
3191: THEN
3192: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3193: THEN
3194: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_EFLAG');
3195: FND_MSG_PUB.add;
3196: END IF;

Line 3195: FND_MSG_PUB.add;

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

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

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

Line 3209: FND_MSG_PUB.add;

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

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

3217: AND l_old_inventory_flag ='Y'
3218: AND p_deliv_rec.inventory_flag = 'N'
3219: AND l_kits_check > 0)
3220: THEN
3221: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3222: THEN
3223: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3224: FND_MSG_PUB.add;
3225: END IF;

Line 3224: FND_MSG_PUB.add;

3220: THEN
3221: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3222: THEN
3223: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_PFLAG');
3224: FND_MSG_PUB.add;
3225: END IF;
3226: x_return_status := FND_API.g_ret_sts_error;
3227: RETURN;
3228: END IF;

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

3430: l_end_date := p_deliv_rec.actual_avail_to_date;
3431: END IF;
3432:
3433: IF l_start_date > l_end_date THEN
3434: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3435: THEN
3436: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DATE_AFTER_DATE');
3437: FND_MSG_PUB.add;
3438: END IF;

Line 3437: FND_MSG_PUB.add;

3433: IF l_start_date > l_end_date THEN
3434: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3435: THEN
3436: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_DATE_AFTER_DATE');
3437: FND_MSG_PUB.add;
3438: END IF;
3439: x_return_status := FND_API.g_ret_sts_error;
3440: END IF;
3441: END IF;

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

3455: l_fore_comp_date := p_deliv_rec.forecasted_complete_date;
3456: END IF;
3457:
3458: IF l_start_date < l_fore_comp_date THEN
3459: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3460: THEN
3461: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_FOREC_AFTER_START');
3462: FND_MSG_PUB.add;
3463: END IF;

Line 3462: FND_MSG_PUB.add;

3458: IF l_start_date < l_fore_comp_date THEN
3459: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3460: THEN
3461: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_FOREC_AFTER_START');
3462: FND_MSG_PUB.add;
3463: END IF;
3464: x_return_status := FND_API.g_ret_sts_error;
3465: END IF;
3466:

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

3466:
3467: /* remove on 06/07/2000 by khung
3468: IF p_deliv_rec.deliverable_id IS NULL THEN -- only for creation
3469: IF l_fore_comp_date < SYSDATE THEN
3470: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3471: THEN
3472: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_FOREC_BEFORE_TODAY');
3473: FND_MSG_PUB.add;
3474: END IF;

Line 3473: FND_MSG_PUB.add;

3469: IF l_fore_comp_date < SYSDATE THEN
3470: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3471: THEN
3472: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_FOREC_BEFORE_TODAY');
3473: FND_MSG_PUB.add;
3474: END IF;
3475: x_return_status := FND_API.g_ret_sts_error;
3476: END IF;
3477: END IF;

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

3671: OPEN c_deliv;
3672: FETCH c_deliv INTO l_deliv_rec;
3673: IF c_deliv%NOTFOUND THEN
3674: CLOSE c_deliv;
3675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3676: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3677: FND_MSG_PUB.add;
3678: END IF;
3679: RAISE FND_API.g_exc_error;

Line 3677: FND_MSG_PUB.add;

3673: IF c_deliv%NOTFOUND THEN
3674: CLOSE c_deliv;
3675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3676: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3677: FND_MSG_PUB.add;
3678: END IF;
3679: RAISE FND_API.g_exc_error;
3680: END IF;
3681: CLOSE c_deliv;

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

4455: AND (l_owner_user_id <> l_resource_id)
4456: AND (l_owner_user_id <> p_deliv_rec.owner_user_id))
4457: THEN
4458:
4459: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4460: THEN
4461: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_OWNER');
4462: FND_MSG_PUB.add;
4463: END IF;

Line 4462: FND_MSG_PUB.add;

4458:
4459: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4460: THEN
4461: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_OWNER');
4462: FND_MSG_PUB.add;
4463: END IF;
4464:
4465: x_return_status := FND_API.g_ret_sts_error;
4466: RETURN;

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

4518: FETCH check_budget INTO l_budget_lines;
4519: CLOSE check_budget;
4520:
4521: IF l_budget_lines = 'Y' THEN
4522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4523: THEN
4524: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_CURRENCY');
4525: FND_MSG_PUB.add;
4526: END IF;

Line 4525: FND_MSG_PUB.add;

4521: IF l_budget_lines = 'Y' THEN
4522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4523: THEN
4524: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_CHANGE_CURRENCY');
4525: FND_MSG_PUB.add;
4526: END IF;
4527: x_return_status := FND_API.g_ret_sts_error;
4528: RETURN;
4529: END IF;

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

4623:
4624: IF (p_deliv_rec.item_number IS NULL
4625: OR p_deliv_rec.item_number = FND_API.g_miss_char)
4626: THEN
4627: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4628: THEN
4629: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_ENTER_PROPER_PARTNO');
4630: FND_MSG_PUB.add;
4631: END IF;

Line 4630: FND_MSG_PUB.add;

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

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

4634: END IF;
4635:
4636: IF (l_org_Id IS NULL)
4637: THEN
4638: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4639: THEN
4640: FND_MESSAGE.set_name('AMS', 'AMS_PROD_PROFILE_TIP');
4641: FND_MSG_PUB.add;
4642: END IF;

Line 4641: FND_MSG_PUB.add;

4637: THEN
4638: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4639: THEN
4640: FND_MESSAGE.set_name('AMS', 'AMS_PROD_PROFILE_TIP');
4641: FND_MSG_PUB.add;
4642: END IF;
4643: x_return_status := FND_API.g_ret_sts_error;
4644: RETURN;
4645: END IF;

Line 4715: FND_MSG_PUB.count_and_get(

4711: THEN
4712: x_msg_count := x_error_tbl.count;
4713: FOR i IN 1 .. x_error_tbl.count LOOP
4714: /*
4715: FND_MSG_PUB.count_and_get(
4716: p_encoded => FND_API.g_false,
4717: p_count => x_msg_count,
4718: p_data => x_error_tbl(i).message_text
4719: ); */

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

4718: p_data => x_error_tbl(i).message_text
4719: ); */
4720: IF x_error_tbl(i).message_name IS NOT NULL
4721: THEN
4722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4723: THEN
4724: FND_MESSAGE.set_name('INV', x_error_tbl(i).message_name);
4725: FND_MSG_PUB.add;
4726: END IF;

Line 4725: FND_MSG_PUB.add;

4721: THEN
4722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4723: THEN
4724: FND_MESSAGE.set_name('INV', x_error_tbl(i).message_name);
4725: FND_MSG_PUB.add;
4726: END IF;
4727: END IF;
4728: IF (AMS_DEBUG_HIGH_ON) THEN
4729:

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

4768: CLOSE get_active_flag;
4769:
4770: IF l_active_flag = 'N'
4771: THEN
4772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4773: THEN
4774: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_UPD_INACTIVE');
4775: FND_MSG_PUB.add;
4776: END IF;

Line 4775: FND_MSG_PUB.add;

4771: THEN
4772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4773: THEN
4774: FND_MESSAGE.set_name('AMS', 'AMS_DELIV_CANT_UPD_INACTIVE');
4775: FND_MSG_PUB.add;
4776: END IF;
4777: x_return_status := FND_API.g_ret_sts_error;
4778: RETURN;
4779: END IF;