DBA Data[Home] [Help]

APPS.JTF_LOC_HIERARCHIES_PVT dependencies on FND_MESSAGE

Line 357: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');

353: AND object_version_number = l_loc_hier_rec.object_version_number;
354:
355: IF (SQL%NOTFOUND) THEN
356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
357: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
358: FND_MSG_PUB.add;
359: END IF;
360: RAISE FND_API.g_exc_error;
361: END IF;

Line 472: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');

468: AND object_version_number = p_object_version;
469:
470: IF (SQL%NOTFOUND) THEN
471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
472: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
473: FND_MSG_PUB.add;
474: END IF;
475: RAISE FND_API.g_exc_error;
476: END IF;

Line 591: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');

587: FETCH c_hier INTO l_hier_id;
588: IF (c_hier%NOTFOUND) THEN
589: CLOSE c_hier;
590: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
591: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
592: FND_MSG_PUB.add;
593: END IF;
594: RAISE FND_API.g_exc_error;
595: END IF;

Line 613: FND_MESSAGE.set_name('JTF', 'JTF_API_RESOURCE_LOCKED');

609:
610: WHEN JTF_Utility_PVT.resource_locked THEN
611: x_return_status := FND_API.g_ret_sts_error;
612: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
613: FND_MESSAGE.set_name('JTF', 'JTF_API_RESOURCE_LOCKED');
614: FND_MSG_PUB.add;
615: END IF;
616: FND_MSG_PUB.count_and_get
617: (

Line 867: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_LOC_HIER_ID');

863: -- check location_hierarchy_id
864: IF p_loc_hier_rec.location_hierarchy_id IS NULL
865: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
866: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
867: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_LOC_HIER_ID');
868: FND_MSG_PUB.add;
869: END IF;
870:
871: x_return_status := FND_API.g_ret_sts_error;

Line 880: FND_MESSAGE.set_name('JTF', 'JTF_NO_OBJ_VER_NUM');

876: IF p_loc_hier_rec.object_version_number IS NULL
877: AND p_validation_mode = JTF_PLSQL_API.g_update
878: THEN
879: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
880: FND_MESSAGE.set_name('JTF', 'JTF_NO_OBJ_VER_NUM');
881: FND_MSG_PUB.add;
882: END IF;
883:
884: x_return_status := FND_API.g_ret_sts_error;

Line 891: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_CR_BY_APP_ID');

887:
888: -- check created_by_application_id
889: IF p_loc_hier_rec.created_by_application_id IS NULL THEN
890: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
891: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_CR_BY_APP_ID');
892: FND_MSG_PUB.add;
893: END IF;
894:
895: x_return_status := FND_API.g_ret_sts_error;

Line 902: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_LOC_TYPE_CODE');

898:
899: -- check location_type_code
900: IF p_loc_hier_rec.location_type_code IS NULL THEN
901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
902: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_LOC_TYPE_CODE');
903: FND_MSG_PUB.add;
904: END IF;
905:
906: x_return_status := FND_API.g_ret_sts_error;

Line 913: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_STAT_DATE');

909:
910: -- check start_date_active
911: IF p_loc_hier_rec.start_date_active IS NULL THEN
912: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
913: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_NO_STAT_DATE');
914: FND_MSG_PUB.add;
915: END IF;
916:
917: x_return_status := FND_API.g_ret_sts_error;

Line 957: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIERARCHY_DUPLICATE_ID');

953: END IF;
954:
955: IF l_uk_flag = FND_API.g_false THEN
956: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
957: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIERARCHY_DUPLICATE_ID');
958: FND_MSG_PUB.add;
959: END IF;
960:
961: x_return_status := FND_API.g_ret_sts_error;

Line 999: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_LOC_TYPE_CODE');

995: );
996:
997: IF l_fk_flag = FND_API.g_false THEN
998: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
999: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_LOC_TYPE_CODE');
1000: FND_MSG_PUB.add;
1001: END IF;
1002:
1003: x_return_status := FND_API.g_ret_sts_error;

Line 1019: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_APP_ID');

1015: );
1016:
1017: IF l_fk_flag = FND_API.g_false THEN
1018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1019: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_APP_ID');
1020: FND_MSG_PUB.add;
1021: END IF;
1022:
1023: x_return_status := FND_API.g_ret_sts_error;

Line 1041: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_AREA1');

1037: );
1038:
1039: IF l_fk_flag = FND_API.g_false THEN
1040: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1041: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_AREA1');
1042: FND_MSG_PUB.add;
1043: END IF;
1044:
1045: x_return_status := FND_API.g_ret_sts_error;

Line 1063: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_AREA2');

1059: );
1060:
1061: IF l_fk_flag = FND_API.g_false THEN
1062: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1063: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_AREA2');
1064: FND_MSG_PUB.add;
1065: END IF;
1066:
1067: x_return_status := FND_API.g_ret_sts_error;

Line 1085: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_COUNTRY');

1081: );
1082:
1083: IF l_fk_flag = FND_API.g_false THEN
1084: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1085: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_COUNTRY');
1086: FND_MSG_PUB.add;
1087: END IF;
1088:
1089: x_return_status := FND_API.g_ret_sts_error;

Line 1107: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_COUNTRY_REGN');

1103: );
1104:
1105: IF l_fk_flag = FND_API.g_false THEN
1106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1107: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_COUNTRY_REGN');
1108: FND_MSG_PUB.add;
1109: END IF;
1110:
1111: x_return_status := FND_API.g_ret_sts_error;

Line 1129: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_STATE');

1125: );
1126:
1127: IF l_fk_flag = FND_API.g_false THEN
1128: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1129: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_STATE');
1130: FND_MSG_PUB.add;
1131: END IF;
1132:
1133: x_return_status := FND_API.g_ret_sts_error;

Line 1151: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_STATE_REGN');

1147: );
1148:
1149: IF l_fk_flag = FND_API.g_false THEN
1150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1151: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_STATE_REGN');
1152: FND_MSG_PUB.add;
1153: END IF;
1154:
1155: x_return_status := FND_API.g_ret_sts_error;

Line 1174: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_CITY');

1170: );
1171:
1172: IF l_fk_flag = FND_API.g_false THEN
1173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1174: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_CITY');
1175: FND_MSG_PUB.add;
1176: END IF;
1177:
1178: x_return_status := FND_API.g_ret_sts_error;

Line 1194: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_POSTAL_CODE');

1190: );
1191:
1192: IF l_fk_flag = FND_API.g_false THEN
1193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1194: FND_MESSAGE.set_name('JTF', 'JTF_LOC_HIER_BAD_POSTAL_CODE');
1195: FND_MSG_PUB.add;
1196: END IF;
1197:
1198: x_return_status := FND_API.g_ret_sts_error;

Line 1237: FND_MESSAGE.set_name('JTF', 'JTF_START_DATE_AFTER_END_DATE');

1233: l_start_date := p_complete_rec.start_date_active;
1234: l_end_date := p_complete_rec.end_date_active;
1235: IF l_start_date > l_end_date THEN
1236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1237: FND_MESSAGE.set_name('JTF', 'JTF_START_DATE_AFTER_END_DATE');
1238: FND_MSG_PUB.add;
1239: END IF;
1240:
1241: x_return_status := FND_API.g_ret_sts_error;

Line 1277: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');

1273: FETCH c_hier INTO l_loc_hier_rec;
1274: IF (c_hier%NOTFOUND) THEN
1275: CLOSE c_hier;
1276: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1277: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
1278: FND_MSG_PUB.add;
1279: END IF;
1280: RAISE FND_API.g_exc_error;
1281: END IF;