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_HIERARCHIES_PVT dependencies on JTF_UTILITY_PVT

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

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

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

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

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

86: END IF;
87: --END IF;
88:
89: -- generate an unique ID if it is not parsed in
90: JTF_Utility_PVT.debug_message(l_full_name || ': insert');
91:
92: IF l_loc_hier_rec.location_hierarchy_id IS NULL THEN
93: LOOP
94: OPEN c_seq;

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

184: p_count => x_msg_count,
185: p_data => x_msg_data
186: );
187:
188: JTF_Utility_PVT.debug_message(l_full_name||': end');
189:
190: EXCEPTION
191:
192: WHEN FND_API.g_exc_error THEN

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

260: IF FND_API.to_boolean(p_init_msg_list) THEN
261: FND_MSG_PUB.initialize;
262: END IF;
263:
264: JTF_Utility_PVT.debug_message(l_full_name || ': start');
265:
266: IF NOT FND_API.compatible_api_call
267: (
268: l_api_version,

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

277: x_return_status := FND_API.g_ret_sts_success;
278:
279: -- validate
280: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
281: JTF_Utility_PVT.debug_message(l_full_name || ': validate');
282:
283: check_items
284: (
285: p_validation_mode => JTF_PLSQL_API.g_update,

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

302: );
303:
304: -- record level
305: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
306: JTF_Utility_PVT.debug_message(l_full_name||': check record');
307: check_record
308: (
309: p_loc_hier_rec => p_loc_hier_rec,
310: p_complete_rec => l_loc_hier_rec,

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

318: END IF;
319: END IF;
320:
321: -- update
322: JTF_Utility_PVT.debug_message(l_full_name||': update');
323:
324: UPDATE JTF_LOC_HIERARCHIES_B SET
325: last_update_date = sysdate,
326: last_updated_by = fnd_global.user_id,

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

371: p_count => x_msg_count,
372: p_data => x_msg_data
373: );
374:
375: JTF_Utility_PVT.debug_message(l_full_name || ': end');
376:
377: EXCEPTION
378:
379: WHEN FND_API.g_exc_error THEN

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

440: BEGIN
441: -- initialize
442: SAVEPOINT delete_hierarchy;
443:
444: JTF_Utility_PVT.debug_message(l_full_name || ': start');
445:
446: IF FND_API.to_boolean(p_init_msg_list) THEN
447: FND_MSG_PUB.initialize;
448: END IF;

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

460:
461: x_return_status := FND_API.g_ret_sts_success;
462:
463: -- delete
464: JTF_Utility_PVT.debug_message(l_full_name || ': delete');
465:
466: DELETE FROM JTF_LOC_HIERARCHIES_B
467: WHERE location_hierarchy_id = p_hier_id
468: AND object_version_number = p_object_version;

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

486: p_count => x_msg_count,
487: p_data => x_msg_data
488: );
489:
490: JTF_Utility_PVT.debug_message(l_full_name || ': end');
491:
492: EXCEPTION
493:
494: WHEN FND_API.g_exc_error THEN

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

560: FOR UPDATE OF location_hierarchy_id NOWAIT;
561:
562: BEGIN
563: -- initialize
564: JTF_Utility_PVT.debug_message(l_full_name || ': start');
565:
566: IF FND_API.to_boolean(p_init_msg_list) THEN
567: FND_MSG_PUB.initialize;
568: END IF;

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

580:
581: x_return_status := FND_API.g_ret_sts_success;
582:
583: -- lock
584: JTF_Utility_PVT.debug_message(l_full_name || ': lock');
585:
586: OPEN c_hier;
587: FETCH c_hier INTO l_hier_id;
588: IF (c_hier%NOTFOUND) THEN

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

602: p_count => x_msg_count,
603: p_data => x_msg_data
604: );
605:
606: JTF_Utility_PVT.debug_message(l_full_name || ': end');
607:
608: EXCEPTION
609:
610: WHEN JTF_Utility_PVT.resource_locked THEN

Line 610: WHEN JTF_Utility_PVT.resource_locked THEN

606: JTF_Utility_PVT.debug_message(l_full_name || ': end');
607:
608: EXCEPTION
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;

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

682:
683: BEGIN
684:
685: ----------------------- initialize --------------------
686: JTF_Utility_PVT.debug_message(l_full_name||': start');
687:
688: IF NOT FND_API.compatible_api_call
689: (
690: l_api_version,

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

700:
701: ---------------------- validate ------------------------
702: -- item level
703: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
704: JTF_Utility_PVT.debug_message(l_full_name||': check items');
705: check_items
706: (
707: p_validation_mode => JTF_PLSQL_API.g_create,
708: x_return_status => l_return_status,

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

717: END IF;
718:
719: -- record level
720: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
721: JTF_Utility_PVT.debug_message(l_full_name||': check record');
722: check_record
723: (
724: p_loc_hier_rec => p_loc_hier_rec,
725: p_complete_rec => p_loc_hier_rec,

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

740: p_count => x_msg_count,
741: p_data => x_msg_data
742: );
743:
744: JTF_Utility_PVT.debug_message(l_full_name ||': end');
745:
746: EXCEPTION
747: WHEN FND_API.g_exc_error THEN
748: x_return_status := FND_API.g_ret_sts_error;

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

796: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
797:
798: BEGIN
799: -- initialize
800: JTF_Utility_PVT.debug_message(l_full_name || ': start');
801:
802: x_return_status := FND_API.g_ret_sts_success;
803:
804: -- check required items

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

801:
802: x_return_status := FND_API.g_ret_sts_success;
803:
804: -- check required items
805: JTF_Utility_PVT.debug_message(l_full_name || ': check required items');
806: check_req_items
807: (
808: p_validation_mode => p_validation_mode,
809: p_loc_hier_rec => p_loc_hier_rec,

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

814: RETURN;
815: END IF;
816:
817: -- check unique key items
818: JTF_Utility_PVT.debug_message(l_full_name || ': check uk items');
819: check_uk_items
820: (
821: p_validation_mode => p_validation_mode,
822: p_loc_hier_rec => p_loc_hier_rec,

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

827: RETURN;
828: END IF;
829:
830: -- check foreign key items
831: JTF_Utility_PVT.debug_message(l_full_name || ': check fk items');
832: check_fk_items
833: (
834: p_loc_hier_rec => p_loc_hier_rec,
835: x_return_status => x_return_status

Line 948: l_uk_flag := JTF_Utility_PVT.check_uniqueness

944: -- check PK, if location_hierarchy_id is parsed in, must check if it is duplicate
945: IF p_validation_mode = JTF_PLSQL_API.g_create
946: AND p_loc_hier_rec.location_hierarchy_id IS NOT NULL
947: THEN
948: l_uk_flag := JTF_Utility_PVT.check_uniqueness
949: (
950: 'JTF_LOC_HIERARCHIES_VL',
951: 'location_hierarchy_id = ' || p_loc_hier_rec.location_hierarchy_id
952: );

Line 989: l_fk_flag := JTF_Utility_PVT.check_fk_exists

985: x_return_status := FND_API.g_ret_sts_success;
986:
987: -- check FK1 location_type_code
988: IF p_loc_hier_rec.location_type_code IS NOT NULL THEN
989: l_fk_flag := JTF_Utility_PVT.check_fk_exists
990: (
991: 'JTF_LOC_TYPES_VL',
992: 'location_type_code',
993: p_loc_hier_rec.location_type_code,

Line 1010: l_fk_flag := JTF_Utility_PVT.check_fk_exists

1006: END IF;
1007:
1008: -- check FK2 created_by_application_id
1009: IF p_loc_hier_rec.created_by_application_id IS NOT NULL THEN
1010: l_fk_flag := JTF_Utility_PVT.check_fk_exists
1011: (
1012: 'FND_APPLICATION',
1013: 'application_id',
1014: p_loc_hier_rec.created_by_application_id

Line 1030: l_fk_flag := JTF_Utility_PVT.check_fk_exists

1026: END IF;
1027:
1028: -- check FK3 area1_id area1_code
1029: IF p_loc_hier_rec.area1_id IS NOT NULL THEN
1030: l_fk_flag := JTF_Utility_PVT.check_fk_exists
1031: (
1032: 'JTF_LOC_AREAS_VL',
1033: 'location_area_id',
1034: p_loc_hier_rec.area1_id,

Line 1052: l_fk_flag := JTF_Utility_PVT.check_fk_exists

1048: END IF;
1049:
1050: -- check FK4 area2_id area2_code
1051: IF p_loc_hier_rec.area2_id IS NOT NULL THEN
1052: l_fk_flag := JTF_Utility_PVT.check_fk_exists
1053: (
1054: 'JTF_LOC_AREAS_VL',
1055: 'location_area_id',
1056: p_loc_hier_rec.area2_id,

Line 1074: l_fk_flag := JTF_Utility_PVT.check_fk_exists

1070: END IF;
1071:
1072: -- check FK5 country_id country_code
1073: IF p_loc_hier_rec.country_id IS NOT NULL THEN
1074: l_fk_flag := JTF_Utility_PVT.check_fk_exists
1075: (
1076: 'JTF_LOC_AREAS_VL',
1077: 'location_area_id',
1078: p_loc_hier_rec.country_id,

Line 1096: l_fk_flag := JTF_Utility_PVT.check_fk_exists

1092: END IF;
1093:
1094: -- check FK6 country_region_id country_region_code
1095: IF p_loc_hier_rec.country_region_id IS NOT NULL THEN
1096: l_fk_flag := JTF_Utility_PVT.check_fk_exists
1097: (
1098: 'JTF_LOC_AREAS_VL',
1099: 'location_area_id',
1100: p_loc_hier_rec.country_region_id,

Line 1118: l_fk_flag := JTF_Utility_PVT.check_fk_exists

1114: END IF;
1115:
1116: -- check FK7 state_id state_code
1117: IF p_loc_hier_rec.state_id IS NOT NULL THEN
1118: l_fk_flag := JTF_Utility_PVT.check_fk_exists
1119: (
1120: 'JTF_LOC_AREAS_VL',
1121: 'location_area_id',
1122: p_loc_hier_rec.state_id,

Line 1140: l_fk_flag := JTF_Utility_PVT.check_fk_exists

1136: END IF;
1137:
1138: -- check FK8 state_region_id state_region_code
1139: IF p_loc_hier_rec.state_region_id IS NOT NULL THEN
1140: l_fk_flag := JTF_Utility_PVT.check_fk_exists
1141: (
1142: 'JTF_LOC_AREAS_VL',
1143: 'location_area_id',
1144: p_loc_hier_rec.state_region_id,

Line 1163: l_fk_flag := JTF_Utility_PVT.check_fk_exists

1159:
1160:
1161: -- check FK9 city_id city_code
1162: IF p_loc_hier_rec.city_id IS NOT NULL THEN
1163: l_fk_flag := JTF_Utility_PVT.check_fk_exists
1164: (
1165: 'JTF_LOC_AREAS_VL',
1166: 'location_area_id',
1167: p_loc_hier_rec.city_id,

Line 1185: l_fk_flag := JTF_Utility_PVT.check_fk_exists

1181: END IF;
1182:
1183: -- check FK10 postal_code_id
1184: IF p_loc_hier_rec.postal_code_id IS NOT NULL THEN
1185: l_fk_flag := JTF_Utility_PVT.check_fk_exists
1186: (
1187: 'JTF_LOC_AREAS_VL',
1188: 'location_area_id',
1189: p_loc_hier_rec.postal_code_id