APPS.AMS_PRETTY_URL_PVT dependencies on JTF_PLSQL_API

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

767:
768:
769: PROCEDURE check_pretty_url_uk_items(
770: p_pretty_url_rec IN pretty_url_rec_type,
771: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
772: x_return_status OUT NOCOPY VARCHAR2)
773: IS
774: l_valid_flag VARCHAR2(1);
775:

Line 778: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

774: l_valid_flag VARCHAR2(1);
775:
776: BEGIN
777: x_return_status := FND_API.g_ret_sts_success;
778: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
779: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
780: 'AMS_PRETTY_URL',
781: 'PRETTY_URL_ID = ''' || p_pretty_url_rec.PRETTY_URL_ID ||''''
782: );

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

797: END check_pretty_url_uk_items;
798:
799: PROCEDURE check_pretty_url_req_items(
800: p_pretty_url_rec IN pretty_url_rec_type,
801: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
802: x_return_status OUT NOCOPY VARCHAR2
803: )
804: IS
805: BEGIN

Line 808: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

804: IS
805: BEGIN
806: x_return_status := FND_API.g_ret_sts_success;
807:
808: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
809:
810:
811: IF p_pretty_url_rec.pretty_url_id = FND_API.g_miss_num OR p_pretty_url_rec.pretty_url_id IS NULL THEN
812: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_pretty_url_id');

Line 1063: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1059: IF FND_API.to_Boolean( p_init_msg_list )
1060: THEN
1061: FND_MSG_PUB.initialize;
1062: END IF;
1063: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1064: Check_pretty_url_Items(
1065: p_pretty_url_rec => p_pretty_url_rec,
1066: p_validation_mode => JTF_PLSQL_API.g_update,
1067: x_return_status => x_return_status

Line 1066: p_validation_mode => JTF_PLSQL_API.g_update,

1062: END IF;
1063: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1064: Check_pretty_url_Items(
1065: p_pretty_url_rec => p_pretty_url_rec,
1066: p_validation_mode => JTF_PLSQL_API.g_update,
1067: x_return_status => x_return_status
1068: );
1069:
1070: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1082: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1078: p_pretty_url_rec => p_pretty_url_rec,
1079: x_complete_rec => l_pretty_url_rec
1080: );
1081:
1082: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1083: Validate_pretty_url_Rec(
1084: p_api_version_number => 1.0,
1085: p_init_msg_list => FND_API.G_FALSE,
1086: x_return_status => x_return_status,