APPS.AMS_GEO_AREAS_PVT dependencies on JTF_PLSQL_API

Line 78: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

74:
75: x_return_status := FND_API.g_ret_sts_success;
76:
77: -- validate
78: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
79: IF (AMS_DEBUG_HIGH_ON) THEN
80:
81: AMS_Utility_PVT.debug_message(l_full_name || ': validate');
82: END IF;

Line 332: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

328: p_geo_area_rec,
329: l_geo_area_rec
330: );
331: -- validate
332: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
333: IF (AMS_DEBUG_HIGH_ON) THEN
334:
335: AMS_Utility_PVT.debug_message(l_full_name || ': validate'||l_geo_area_rec.object_version_number);
336: END IF;

Line 340: p_validation_mode => JTF_PLSQL_API.g_update,

336: END IF;
337:
338: check_items
339: (
340: p_validation_mode => JTF_PLSQL_API.g_update,
341: x_return_status => l_return_status,
342: p_geo_area_rec => l_geo_area_rec
343: );
344:

Line 823: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

819:
820: x_return_status := FND_API.g_ret_sts_success;
821:
822: ---------------------- validate ------------------------
823: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
824: IF (AMS_DEBUG_HIGH_ON) THEN
825:
826: AMS_Utility_PVT.debug_message(l_full_name||': check items');
827: END IF;

Line 830: p_validation_mode => JTF_PLSQL_API.g_create,

826: AMS_Utility_PVT.debug_message(l_full_name||': check items');
827: END IF;
828: check_items
829: (
830: p_validation_mode => JTF_PLSQL_API.g_create,
831: x_return_status => l_return_status,
832: p_geo_area_rec => p_geo_area_rec
833: );
834:

Line 988: AND p_validation_mode = JTF_PLSQL_API.g_update THEN

984: x_return_status := FND_API.g_ret_sts_success;
985:
986: -- check activity_geo_area_id
987: IF p_geo_area_rec.activity_geo_area_id IS NULL
988: AND p_validation_mode = JTF_PLSQL_API.g_update THEN
989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
990: FND_MESSAGE.set_name('AMS', 'AMS_GEO_NO_ACT_AREA_ID');
991: FND_MSG_PUB.add;
992: END IF;

Line 1000: AND p_validation_mode = JTF_PLSQL_API.g_update

996: END IF;
997:
998: -- check object_version_number
999: IF p_geo_area_rec.object_version_number IS NULL
1000: AND p_validation_mode = JTF_PLSQL_API.g_update
1001: THEN
1002: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1003: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_OBJ_VER_NUM');
1004: FND_MSG_PUB.add;

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

1073: -- 12/3/1999 julou created
1074: -------------------------------------------------------------------------------
1075: PROCEDURE check_geo_area_uk_items
1076: (
1077: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1078: p_geo_area_rec IN geo_area_rec_type,
1079: x_return_status OUT NOCOPY VARCHAR2
1080: )
1081: IS

Line 1090: IF p_validation_mode = JTF_PLSQL_API.g_create

1086:
1087: x_return_status := FND_API.g_ret_sts_success;
1088:
1089: -- check PK, if activity_geo_area_id is passed in, must check if it is duplicate
1090: IF p_validation_mode = JTF_PLSQL_API.g_create
1091: AND p_geo_area_rec.activity_geo_area_id IS NOT NULL
1092: THEN
1093: l_uk_flag := AMS_Utility_PVT.check_uniqueness
1094: (