APPS.JTF_LOC_HIERARCHIES_PVT dependencies on JTF_PLSQL_API

Line 68: -- IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

64:
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: (

Line 280: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

276:
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: (

Line 285: p_validation_mode => JTF_PLSQL_API.g_update,

281: JTF_Utility_PVT.debug_message(l_full_name || ': validate');
282:
283: check_items
284: (
285: p_validation_mode => JTF_PLSQL_API.g_update,
286: x_return_status => l_return_status,
287: p_loc_hier_rec => l_loc_hier_rec
288: );
289:

Line 305: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

301: l_loc_hier_rec
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,

Line 703: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

699: x_return_status := FND_API.g_ret_sts_success;
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,

Line 707: p_validation_mode => JTF_PLSQL_API.g_create,

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,
709: p_loc_hier_rec => p_loc_hier_rec
710: );
711:

Line 720: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

716: END IF;
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,

Line 865: AND p_validation_mode = JTF_PLSQL_API.g_update THEN

861: x_return_status := FND_API.g_ret_sts_success;
862:
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;

Line 877: AND p_validation_mode = JTF_PLSQL_API.g_update

873: END IF;
874:
875: -- check object_version_number
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;

Line 932: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

928: -- 12/19/1999 julou created
929: -------------------------------------------------------------------------------
930: PROCEDURE check_uk_items
931: (
932: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
933: p_loc_hier_rec IN loc_hier_rec_type,
934: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
935: )
936: IS

Line 945: IF p_validation_mode = JTF_PLSQL_API.g_create

941:
942: x_return_status := FND_API.g_ret_sts_success;
943:
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: (