DBA Data[Home] [Help]

APPS.JTF_LOC_POSTAL_CODES_PVT dependencies on JTF_PLSQL_API

Line 256: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

252:
253: IF p_remove_flag <> 'Y' THEN
254: -- item level
255: JTF_Utility_PVT.debug_message(l_full_name || ': validate');
256: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
257: JTF_Utility_PVT.debug_message(l_full_name || ': check items');
258: check_items
259: (
260: p_validation_mode => JTF_PLSQL_API.g_update,

Line 260: p_validation_mode => JTF_PLSQL_API.g_update,

256: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
257: JTF_Utility_PVT.debug_message(l_full_name || ': check items');
258: check_items
259: (
260: p_validation_mode => JTF_PLSQL_API.g_update,
261: x_return_status => l_return_status,
262: p_postal_code_rec => l_postal_code_rec
263: );
264:

Line 273: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

269: END IF;
270: END IF;
271:
272: -- record level
273: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
274: JTF_Utility_PVT.debug_message(l_full_name||': check record');
275: check_record
276: (
277: p_postal_code_rec => p_postal_code_rec,

Line 663: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

659: x_return_status := FND_API.g_ret_sts_success;
660:
661: ---------------------- validate ------------------------
662: -- item level
663: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
664: JTF_Utility_PVT.debug_message(l_full_name||': check items');
665: check_items
666: (
667: p_validation_mode => JTF_PLSQL_API.g_create,

Line 667: p_validation_mode => JTF_PLSQL_API.g_create,

663: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
664: JTF_Utility_PVT.debug_message(l_full_name||': check items');
665: check_items
666: (
667: p_validation_mode => JTF_PLSQL_API.g_create,
668: x_return_status => l_return_status,
669: p_postal_code_rec => p_postal_code_rec
670: );
671:

Line 680: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

676: END IF;
677: END IF;
678:
679: -- record level
680: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
681: JTF_Utility_PVT.debug_message(l_full_name||': check record');
682: check_record
683: (
684: p_postal_code_rec => p_postal_code_rec,

Line 813: AND p_validation_mode = JTF_PLSQL_API.g_update

809: x_return_status := FND_API.g_ret_sts_success;
810:
811: -- check location_postal_code_id
812: IF p_postal_code_rec.location_postal_code_id IS NULL
813: AND p_validation_mode = JTF_PLSQL_API.g_update
814: THEN
815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
816: FND_MESSAGE.set_name('JTF', 'JTF_LOC_POS_NO_LOC_POS_CODE_ID');
817: FND_MSG_PUB.add;

Line 826: AND p_validation_mode = JTF_PLSQL_API.g_update

822: END IF;
823:
824: -- check object_version_number
825: IF p_postal_code_rec.object_version_number IS NULL
826: AND p_validation_mode = JTF_PLSQL_API.g_update
827: THEN
828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
829: FND_MESSAGE.set_name('JTF', 'JTF_API_NO_OBJ_VER_NUM');
830: FND_MSG_PUB.add;