eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_LOC_AREAS_PVT dependencies on FND_MESSAGE

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

359: AND object_version_number = l_loc_area_rec.object_version_number;
360:
361: IF (SQL%NOTFOUND) THEN
362: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
363: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
364: FND_MSG_PUB.add;
365: END IF;
366: RAISE FND_API.g_exc_error;
367: END IF;

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

377: AND USERENV('LANG') IN (language, source_lang);
378:
379: IF (SQL%NOTFOUND) THEN
380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
381: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
382: FND_MSG_PUB.add;
383: END IF;
384: RAISE FND_API.g_exc_error;
385: END IF;

Line 509: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_HAS_CHILD');

505: -- check if the area has child
506: IF l_child_exist IS NOT NULL
507: THEN
508: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
509: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_HAS_CHILD');
510: FND_MSG_PUB.add;
511: END IF;
512: RAISE FND_API.g_exc_error;
513: END IF;

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

517: WHERE location_area_id = p_loc_area_id;
518:
519: IF (SQL%NOTFOUND) THEN
520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
521: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
522: FND_MSG_PUB.add;
523: END IF;
524: RAISE FND_API.g_exc_error;
525: END IF;

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

541: -- end of added
542:
543: IF (SQL%NOTFOUND) THEN
544: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
545: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
546: FND_MSG_PUB.add;
547: END IF;
548: RAISE FND_API.g_exc_error;
549: END IF;

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

667: FETCH c_loc_area_b INTO l_loc_area_id;
668: IF (c_loc_area_b%NOTFOUND) THEN
669: CLOSE c_loc_area_b;
670: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
671: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
672: FND_MSG_PUB.add;
673: END IF;
674: RAISE FND_API.g_exc_error;
675: END IF;

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

679: FETCH c_loc_area_tl INTO l_loc_area_id;
680: IF (c_loc_area_tl%NOTFOUND) THEN
681: CLOSE c_loc_area_tl;
682: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
683: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
684: FND_MSG_PUB.add;
685: END IF;
686: RAISE FND_API.g_exc_error;
687: END IF;

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

701:
702: WHEN JTF_Utility_PVT.resource_locked THEN
703: x_return_status := FND_API.g_ret_sts_error;
704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
705: FND_MESSAGE.set_name('JTF', 'JTF_API_RESOURCE_LOCKED');
706: FND_MSG_PUB.add;
707: END IF;
708: FND_MSG_PUB.count_and_get
709: (

Line 966: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_NO_LOC_AREA_ID');

962: -- check location_area_id
963: IF p_loc_area_rec.location_area_id IS NULL
964: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
965: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
966: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_NO_LOC_AREA_ID');
967: FND_MSG_PUB.add;
968: END IF;
969:
970: x_return_status := FND_API.g_ret_sts_error;

Line 977: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_NO_LOC_TYPE_CODE');

973:
974: -- check location_type_code
975: IF p_loc_area_rec.location_type_code IS NULL THEN
976: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
977: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_NO_LOC_TYPE_CODE');
978: FND_MSG_PUB.add;
979: END IF;
980:
981: x_return_status := FND_API.g_ret_sts_error;

Line 990: FND_MESSAGE.set_name('JTF', 'JTF_API_NO_OBJ_VER_NUM');

986: IF p_loc_area_rec.object_version_number IS NULL
987: AND p_validation_mode = JTF_PLSQL_API.g_update
988: THEN
989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
990: FND_MESSAGE.set_name('JTF', 'JTF_API_NO_OBJ_VER_NUM');
991: FND_MSG_PUB.add;
992: END IF;
993:
994: x_return_status := FND_API.g_ret_sts_error;

Line 1001: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_NO_START_DATE');

997:
998: -- check start_date_active
999: IF p_loc_area_rec.start_date_active IS NULL THEN
1000: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1001: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_NO_START_DATE');
1002: FND_MSG_PUB.add;
1003: END IF;
1004:
1005: x_return_status := FND_API.g_ret_sts_error;

Line 1012: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_NO_AREA_NAME');

1008:
1009: -- check locaton_area_name
1010: IF p_loc_area_rec.location_area_name IS NULL THEN
1011: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1012: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_NO_AREA_NAME');
1013: FND_MSG_PUB.add;
1014: END IF;
1015:
1016: x_return_status := FND_API.g_ret_sts_error;

Line 1025: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_NO_AREA_CODE');

1021: IF p_loc_area_rec.location_area_code IS NULL
1022: OR p_loc_area_rec.location_area_code = FND_API.g_miss_char
1023: THEN
1024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1025: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_NO_AREA_CODE');
1026: FND_MSG_PUB.add;
1027: END IF;
1028:
1029: x_return_status := FND_API.g_ret_sts_error;

Line 1039: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_BAD_PARENT_ID');

1035: IF p_loc_area_rec.parent_location_area_id = FND_API.g_miss_num
1036: OR p_loc_area_rec.parent_location_area_id IS NULL
1037: THEN
1038: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1039: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_BAD_PARENT_ID');
1040: FND_MSG_PUB.add;
1041: END IF;
1042:
1043: x_return_status := FND_API.g_ret_sts_error;

Line 1056: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_WORLD_EXISTS');

1052: THEN
1053: IF p_validation_mode = JTF_PLSQL_API.g_create
1054: THEN
1055: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1056: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_WORLD_EXISTS');
1057: FND_MSG_PUB.add;
1058: END IF;
1059:
1060: x_return_status := FND_API.g_ret_sts_error;

Line 1068: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_BAD_PARENT_ID');

1064: IF p_loc_area_rec.parent_location_area_id IS NOT NULL
1065: AND p_loc_area_rec.parent_location_area_id <> FND_API.g_miss_num
1066: THEN -- creating new world, no parent allowed
1067: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1068: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_BAD_PARENT_ID');
1069: FND_MSG_PUB.add;
1070: END IF;
1071:
1072: x_return_status := FND_API.g_ret_sts_error;

Line 1137: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREAS_DUPLICATE_ID');

1133: END IF;
1134:
1135: IF l_uk_flag = FND_API.g_false THEN
1136: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1137: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREAS_DUPLICATE_ID');
1138: FND_MSG_PUB.add;
1139: END IF;
1140:
1141: x_return_status := FND_API.g_ret_sts_error;

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

1170: END IF;
1171:
1172: IF l_uk_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_AREA_DUP_AREA_CODE');
1175: FND_MSG_PUB.add;
1176: END IF;
1177:
1178: x_return_status := FND_API.g_ret_sts_error;

Line 1197: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREAS_DUP_NAME_LANG');

1193: END IF;
1194:
1195: IF l_count = 1 THEN
1196: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1197: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREAS_DUP_NAME_LANG');
1198: FND_MSG_PUB.add;
1199: END IF;
1200:
1201: x_return_status := FND_API.g_ret_sts_error;

Line 1238: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_BAD_LOC_TYPE_CODE');

1234: );
1235:
1236: IF l_fk_flag = FND_API.g_false THEN
1237: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1238: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_BAD_LOC_TYPE_CODE');
1239: FND_MSG_PUB.add;
1240: END IF;
1241:
1242: x_return_status := FND_API.g_ret_sts_error;

Line 1259: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_BAD_PARENT_ID');

1255: );
1256:
1257: IF l_fk_flag = FND_API.g_false THEN
1258: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1259: FND_MESSAGE.set_name('JTF', 'JTF_LOC_AREA_BAD_PARENT_ID');
1260: FND_MSG_PUB.add;
1261: END IF;
1262:
1263: x_return_status := FND_API.g_ret_sts_error;

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

1298: l_start_date := p_complete_rec.start_date_active;
1299: l_end_date := p_complete_rec.end_date_active;
1300: IF l_start_date > l_end_date THEN
1301: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1302: FND_MESSAGE.set_name('JTF', 'JTF_START_DATE_AFTER_END_DATE');
1303: FND_MSG_PUB.add;
1304: END IF;
1305:
1306: x_return_status := FND_API.g_ret_sts_error;

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

1338: FETCH c_loc_area INTO l_loc_area_rec;
1339: IF (c_loc_area%NOTFOUND) THEN
1340: CLOSE c_loc_area;
1341: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1342: FND_MESSAGE.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
1343: FND_MSG_PUB.add;
1344: END IF;
1345: RAISE FND_API.g_exc_error;
1346: END IF;