233: Validate_pg_memberships(
234: p_api_version_number => 1.0,
235: p_init_msg_list => FND_API.G_FALSE,
236: p_validation_level => p_validation_level,
237: p_validation_mode => JTF_PLSQL_API.g_create,
238: p_memb_rec => p_memb_rec,
239: x_return_status => x_return_status,
240: x_msg_count => x_msg_count,
241: x_msg_data => x_msg_data);
526: Validate_pg_memberships(
527: p_api_version_number => 1.0,
528: p_init_msg_list => FND_API.G_FALSE,
529: p_validation_level => p_validation_level,
530: p_validation_mode => JTF_PLSQL_API.g_update,
531: p_memb_rec => p_memb_rec,
532: x_return_status => x_return_status,
533: x_msg_count => x_msg_count,
534: x_msg_data => x_msg_data);
950:
951:
952: PROCEDURE check_Memb_Uk_Items(
953: p_memb_rec IN memb_rec_type,
954: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
955: x_return_status OUT NOCOPY VARCHAR2)
956: IS
957: l_valid_flag VARCHAR2(1);
958:
957: l_valid_flag VARCHAR2(1);
958:
959: BEGIN
960: x_return_status := FND_API.g_ret_sts_success;
961: IF p_validation_mode = JTF_PLSQL_API.g_create
962: AND p_memb_rec.membership_id IS NOT NULL
963: THEN
964: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
965: 'pv_pg_memberships',
977:
978:
979: PROCEDURE check_Memb_Req_Items(
980: p_memb_rec IN memb_rec_type,
981: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
982: x_return_status OUT NOCOPY VARCHAR2
983: )
984: IS
985: BEGIN
984: IS
985: BEGIN
986: x_return_status := FND_API.g_ret_sts_success;
987:
988: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
989:
990: /**
991: IF p_memb_rec.membership_id = FND_API.G_MISS_NUM OR p_memb_rec.membership_id IS NULL THEN
992: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MEMBERSHIP_ID' );
1333: FND_MSG_PUB.initialize;
1334: END IF;
1335:
1336:
1337: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1338: Check_memb_Items(
1339: p_memb_rec => p_memb_rec,
1340: p_validation_mode => p_validation_mode,
1341: x_return_status => x_return_status
1347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1348: END IF;
1349: END IF;
1350:
1351: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1352: Default_Memb_Items (p_memb_rec => p_memb_rec ,
1353: x_memb_rec => l_memb_rec) ;
1354: END IF ;
1355:
1360: );
1361:
1362: l_memb_rec := l_memb_rec_out;
1363:
1364: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1365: Validate_memb_Rec(
1366: p_api_version_number => 1.0,
1367: p_init_msg_list => FND_API.G_FALSE,
1368: x_return_status => x_return_status,