APPS.AMS_PRTY_URL_ASSOC_PVT dependencies on JTF_PLSQL_API

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

623:
624:
625: PROCEDURE check_prty_url_assoc_uk_items(
626: p_prty_url_assoc_rec IN prty_url_assoc_rec_type,
627: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
628: x_return_status OUT NOCOPY VARCHAR2)
629: IS
630: l_valid_flag VARCHAR2(1);
631:

Line 634: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

630: l_valid_flag VARCHAR2(1);
631:
632: BEGIN
633: x_return_status := FND_API.g_ret_sts_success;
634: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
635: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
636: 'AMS_PRETTY_URL_ASSOC',
637: 'ASSOC_ID = ''' || p_prty_url_assoc_rec.ASSOC_ID ||''''
638: );

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

653: END check_prty_url_assoc_uk_items;
654:
655: PROCEDURE check_prty_url_assoc_req_items(
656: p_prty_url_assoc_rec IN prty_url_assoc_rec_type,
657: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
658: x_return_status OUT NOCOPY VARCHAR2
659: )
660: IS
661: BEGIN

Line 664: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

660: IS
661: BEGIN
662: x_return_status := FND_API.g_ret_sts_success;
663:
664: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
665:
666:
667: IF p_prty_url_assoc_rec.assoc_id = FND_API.g_miss_num OR p_prty_url_assoc_rec.assoc_id IS NULL THEN
668: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_prty_url_assoc_NO_assoc_id');

Line 956: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

952: IF FND_API.to_Boolean( p_init_msg_list )
953: THEN
954: FND_MSG_PUB.initialize;
955: END IF;
956: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
957: Check_prty_url_assoc_Items(
958: p_prty_url_assoc_rec => p_prty_url_assoc_rec,
959: p_validation_mode => JTF_PLSQL_API.g_update,
960: x_return_status => x_return_status

Line 959: p_validation_mode => JTF_PLSQL_API.g_update,

955: END IF;
956: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
957: Check_prty_url_assoc_Items(
958: p_prty_url_assoc_rec => p_prty_url_assoc_rec,
959: p_validation_mode => JTF_PLSQL_API.g_update,
960: x_return_status => x_return_status
961: );
962:
963: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 975: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

971: p_prty_url_assoc_rec => p_prty_url_assoc_rec,
972: x_complete_rec => l_prty_url_assoc_rec
973: );
974:
975: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
976: Validate_prty_url_assoc_Rec(
977: p_api_version_number => 1.0,
978: p_init_msg_list => FND_API.G_FALSE,
979: x_return_status => x_return_status,