APPS.AMS_SYSTEM_PRETTY_URL_PVT dependencies on JTF_PLSQL_API

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

628:
629:
630: PROCEDURE CHECK_SYS_PRETTY_URL_uk_itm(
631: p_system_pretty_url_rec IN system_pretty_url_rec_type,
632: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
633: x_return_status OUT NOCOPY VARCHAR2)
634: IS
635: l_valid_flag VARCHAR2(1);
636:

Line 639: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

635: l_valid_flag VARCHAR2(1);
636:
637: BEGIN
638: x_return_status := FND_API.g_ret_sts_success;
639: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
640: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
641: 'AMS_SYSTEM_PRETTY_URL',
642: 'SYSTEM_URL_ID = ''' || p_system_pretty_url_rec.SYSTEM_URL_ID ||''''
643: );

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

658: END CHECK_SYS_PRETTY_URL_uk_itm;
659:
660: PROCEDURE CHECK_SYS_PRETTY_URL_req_items(
661: p_system_pretty_url_rec IN system_pretty_url_rec_type,
662: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
663: x_return_status OUT NOCOPY VARCHAR2
664: )
665: IS
666: BEGIN

Line 669: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

665: IS
666: BEGIN
667: x_return_status := FND_API.g_ret_sts_success;
668:
669: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
670:
671:
672: IF p_system_pretty_url_rec.system_url_id = FND_API.g_miss_num OR p_system_pretty_url_rec.system_url_id IS NULL THEN
673: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url_id');

Line 958: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

954: IF FND_API.to_Boolean( p_init_msg_list )
955: THEN
956: FND_MSG_PUB.initialize;
957: END IF;
958: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
959: CHECK_SYS_PRETTY_URL_ITM(
960: p_system_pretty_url_rec => p_system_pretty_url_rec,
961: p_validation_mode => JTF_PLSQL_API.g_update,
962: x_return_status => x_return_status

Line 961: p_validation_mode => JTF_PLSQL_API.g_update,

957: END IF;
958: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
959: CHECK_SYS_PRETTY_URL_ITM(
960: p_system_pretty_url_rec => p_system_pretty_url_rec,
961: p_validation_mode => JTF_PLSQL_API.g_update,
962: x_return_status => x_return_status
963: );
964:
965: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 977: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

973: p_system_pretty_url_rec => p_system_pretty_url_rec,
974: x_complete_rec => l_system_pretty_url_rec
975: );
976:
977: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
978: Validate_system_pretty_url_Rec(
979: p_api_version_number => 1.0,
980: p_init_msg_list => FND_API.G_FALSE,
981: x_return_status => x_return_status,