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 JTF_UTILITY_PVT

Line 53: JTF_Utility_PVT.debug_message(l_full_name || ': start');

49: FND_MSG_PUB.initialize;
50: END IF;
51:
52:
53: JTF_Utility_PVT.debug_message(l_full_name || ': start');
54:
55: IF NOT FND_API.compatible_api_call
56: (
57: l_api_version,

Line 70: JTF_Utility_PVT.debug_message(l_full_name || ': validate');

66: x_return_status := FND_API.g_ret_sts_success;
67:
68: -- validate
69: -- IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
70: JTF_Utility_PVT.debug_message(l_full_name || ': validate');
71:
72: validate_loc_area
73: (
74: p_api_version => l_api_version,

Line 91: JTF_Utility_PVT.debug_message(l_full_name || ': insert');

87: END IF;
88: -- END IF;
89:
90: -- insert
91: JTF_Utility_PVT.debug_message(l_full_name || ': insert');
92:
93: IF l_loc_area_rec.location_area_id IS NULL THEN
94: LOOP
95: OPEN c_loc_area_seq;

Line 198: JTF_Utility_PVT.debug_message(l_full_name||': end');

194: p_count => x_msg_count,
195: p_data => x_msg_data
196: );
197:
198: JTF_Utility_PVT.debug_message(l_full_name||': end');
199:
200: EXCEPTION
201:
202: WHEN FND_API.g_exc_error THEN

Line 275: JTF_Utility_PVT.debug_message(l_full_name || ': start');

271: IF FND_API.to_boolean(p_init_msg_list) THEN
272: FND_MSG_PUB.initialize;
273: END IF;
274:
275: JTF_Utility_PVT.debug_message(l_full_name || ': start');
276:
277: IF NOT FND_API.compatible_api_call
278: (
279: l_api_version,

Line 301: JTF_Utility_PVT.debug_message(l_full_name || ': validate');

297: -- validate
298: IF p_remove_flag <> 'Y' THEN
299: -- item level
300: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
301: JTF_Utility_PVT.debug_message(l_full_name || ': validate');
302:
303: check_items
304: (
305: p_validation_mode => JTF_PLSQL_API.g_update,

Line 319: JTF_Utility_PVT.debug_message(l_full_name||': check record');

315: END IF;
316:
317: -- record level
318: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
319: JTF_Utility_PVT.debug_message(l_full_name||': check record');
320: check_record
321: (
322: p_loc_area_rec => p_loc_area_rec,
323: p_complete_rec => l_loc_area_rec,

Line 336: JTF_Utility_PVT.debug_message(l_full_name||': update');

332: END IF;
333: END IF;
334:
335: -- update
336: JTF_Utility_PVT.debug_message(l_full_name||': update');
337:
338: IF p_remove_flag = 'Y' THEN
339: l_loc_area_rec.end_date_active := SYSDATE;
340: END IF;

Line 399: JTF_Utility_PVT.debug_message(l_full_name || ': end');

395: p_count => x_msg_count,
396: p_data => x_msg_data
397: );
398:
399: JTF_Utility_PVT.debug_message(l_full_name || ': end');
400:
401: EXCEPTION
402:
403: WHEN FND_API.g_exc_error THEN

Line 479: JTF_Utility_PVT.debug_message(l_full_name || ': start');

475: BEGIN
476: -- initialize
477: SAVEPOINT delete_loc_area;
478:
479: JTF_Utility_PVT.debug_message(l_full_name || ': start');
480:
481: IF FND_API.to_boolean(p_init_msg_list) THEN
482: FND_MSG_PUB.initialize;
483: END IF;

Line 499: JTF_Utility_PVT.debug_message(l_full_name || ': delete');

495:
496: x_return_status := FND_API.g_ret_sts_success;
497:
498: -- delete
499: JTF_Utility_PVT.debug_message(l_full_name || ': delete');
500:
501: OPEN c_child_exist(p_loc_area_id);
502: FETCH c_child_exist INTO l_child_exist;
503: CLOSE c_child_exist;

Line 563: JTF_Utility_PVT.debug_message(l_full_name || ': end');

559: p_count => x_msg_count,
560: p_data => x_msg_data
561: );
562:
563: JTF_Utility_PVT.debug_message(l_full_name || ': end');
564:
565: EXCEPTION
566:
567: WHEN FND_API.g_exc_error THEN

Line 644: JTF_Utility_PVT.debug_message(l_full_name || ': start');

640: FOR UPDATE OF location_area_id NOWAIT;
641:
642: BEGIN
643: -- initialize
644: JTF_Utility_PVT.debug_message(l_full_name || ': start');
645:
646: IF FND_API.to_boolean(p_init_msg_list) THEN
647: FND_MSG_PUB.initialize;
648: END IF;

Line 664: JTF_Utility_PVT.debug_message(l_full_name || ': lock');

660:
661: x_return_status := FND_API.g_ret_sts_success;
662:
663: -- lock
664: JTF_Utility_PVT.debug_message(l_full_name || ': lock');
665:
666: OPEN c_loc_area_b;
667: FETCH c_loc_area_b INTO l_loc_area_id;
668: IF (c_loc_area_b%NOTFOUND) THEN

Line 698: JTF_Utility_PVT.debug_message(l_full_name || ': end');

694: p_count => x_msg_count,
695: p_data => x_msg_data
696: );
697:
698: JTF_Utility_PVT.debug_message(l_full_name || ': end');
699:
700: EXCEPTION
701:
702: WHEN JTF_Utility_PVT.resource_locked THEN

Line 702: WHEN JTF_Utility_PVT.resource_locked THEN

698: JTF_Utility_PVT.debug_message(l_full_name || ': end');
699:
700: EXCEPTION
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;

Line 778: JTF_Utility_PVT.debug_message(l_full_name||': start');

774:
775: BEGIN
776:
777: ----------------------- initialize --------------------
778: JTF_Utility_PVT.debug_message(l_full_name||': start');
779:
780: IF NOT FND_API.compatible_api_call
781: (
782: l_api_version,

Line 795: JTF_Utility_PVT.debug_message(l_full_name||': check items');

791: x_return_status := FND_API.g_ret_sts_success;
792:
793: ---------------------- validate ------------------------
794: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
795: JTF_Utility_PVT.debug_message(l_full_name||': check items');
796: check_items
797: (
798: p_validation_mode => JTF_PLSQL_API.g_create,
799: x_return_status => l_return_status,

Line 812: JTF_Utility_PVT.debug_message(l_full_name||': check record');

808: END IF;
809:
810: -- record level
811: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
812: JTF_Utility_PVT.debug_message(l_full_name||': check record');
813: check_record
814: (
815: p_loc_area_rec => p_loc_area_rec,
816: p_complete_rec => p_loc_area_rec,

Line 834: JTF_Utility_PVT.debug_message(l_full_name ||': end');

830: p_count => x_msg_count,
831: p_data => x_msg_data
832: );
833:
834: JTF_Utility_PVT.debug_message(l_full_name ||': end');
835:
836: EXCEPTION
837: WHEN FND_API.g_exc_error THEN
838: x_return_status := FND_API.g_ret_sts_error;

Line 890: JTF_Utility_PVT.debug_message(l_full_name || ': start');

886: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
887:
888: BEGIN
889: -- initialize
890: JTF_Utility_PVT.debug_message(l_full_name || ': start');
891:
892: x_return_status := FND_API.g_ret_sts_success;
893:
894: -- check required items

Line 895: JTF_Utility_PVT.debug_message(l_full_name || ': check required items');

891:
892: x_return_status := FND_API.g_ret_sts_success;
893:
894: -- check required items
895: JTF_Utility_PVT.debug_message(l_full_name || ': check required items');
896: check_loc_area_req_items
897: (
898: p_validation_mode => p_validation_mode,
899: p_loc_area_rec => p_loc_area_rec,

Line 908: JTF_Utility_PVT.debug_message(l_full_name || ': check uk items');

904: RETURN;
905: END IF;
906:
907: -- check unique key items
908: JTF_Utility_PVT.debug_message(l_full_name || ': check uk items');
909: check_loc_area_uk_items
910: (
911: p_validation_mode => p_validation_mode,
912: p_loc_area_rec => p_loc_area_rec,

Line 921: JTF_Utility_PVT.debug_message(l_full_name || ': check fk items');

917: RETURN;
918: END IF;
919:
920: -- check foreign key items
921: JTF_Utility_PVT.debug_message(l_full_name || ': check fk items');
922: check_loc_area_fk_items
923: (
924: p_loc_area_rec => p_loc_area_rec,
925: x_return_status => x_return_status

Line 1128: l_uk_flag := JTF_Utility_PVT.check_uniqueness

1124: -- check PK, if location_area_id is passed in, must check if it is duplicate
1125: IF p_validation_mode = JTF_PLSQL_API.g_create
1126: AND p_loc_area_rec.location_area_id IS NOT NULL
1127: THEN
1128: l_uk_flag := JTF_Utility_PVT.check_uniqueness
1129: (
1130: 'JTF_LOC_AREAS_VL',
1131: 'location_area_id = ' || p_loc_area_rec.location_area_id
1132: );

Line 1156: l_uk_flag := JTF_Utility_PVT.check_uniqueness

1152: l_parent_loc_str := ' AND parent_location_area_id = ' || p_loc_area_rec.parent_location_area_id;
1153: END IF;
1154:
1155: IF p_loc_area_rec.location_area_id IS NOT NULL THEN
1156: l_uk_flag := JTF_Utility_PVT.check_uniqueness
1157: (
1158: 'JTF_LOC_AREAS_VL',
1159: 'location_area_id <> ' || p_loc_area_rec.location_area_id
1160: || ' AND location_area_code = ''' || p_loc_area_rec.location_area_code || ''''

Line 1164: l_uk_flag := JTF_Utility_PVT.check_uniqueness

1160: || ' AND location_area_code = ''' || p_loc_area_rec.location_area_code || ''''
1161: || l_parent_loc_str
1162: );
1163: ELSE
1164: l_uk_flag := JTF_Utility_PVT.check_uniqueness
1165: (
1166: 'JTF_LOC_AREAS_VL',
1167: 'location_area_code = ''' || p_loc_area_rec.location_area_code || ''''
1168: || l_parent_loc_str

Line 1228: l_fk_flag := JTF_Utility_PVT.check_fk_exists

1224:
1225: x_return_status := FND_API.g_ret_sts_success;
1226:
1227: -- check location_type_code
1228: l_fk_flag := JTF_Utility_PVT.check_fk_exists
1229: (
1230: 'JTF_LOC_TYPES_VL',
1231: 'location_type_code',
1232: p_loc_area_rec.location_type_code,

Line 1250: l_fk_flag := JTF_Utility_PVT.check_fk_exists

1246: -- check parent_location_area_id
1247: IF p_loc_area_rec.parent_location_area_id IS NOT NULL
1248: AND p_loc_area_rec.parent_location_area_id <> FND_API.g_miss_num
1249: THEN
1250: l_fk_flag := JTF_Utility_PVT.check_fk_exists
1251: (
1252: 'JTF_LOC_AREAS_VL',
1253: 'location_area_id',
1254: p_loc_area_rec.parent_location_area_id