175: Validate_partner_pgm_type(
176: p_api_version_number => 1.0
177: ,p_init_msg_list => FND_API.G_FALSE
178: ,p_validation_level => p_validation_level
179: ,p_validation_mode => JTF_PLSQL_API.g_create
180: ,p_ptr_prgm_type_rec => l_ptr_prgm_type_rec
181: ,x_return_status => x_return_status
182: ,x_msg_count => x_msg_count
183: ,x_msg_data => x_msg_data
393: Validate_partner_pgm_type(
394: p_api_version_number => 1.0
395: ,p_init_msg_list => FND_API.G_FALSE
396: ,p_validation_level => p_validation_level
397: ,p_validation_mode => JTF_PLSQL_API.g_update
398: ,p_ptr_prgm_type_rec => p_ptr_prgm_type_rec
399: ,x_return_status => x_return_status
400: ,x_msg_count => x_msg_count
401: ,x_msg_data => x_msg_data
833:
834:
835: PROCEDURE Check_UK_Items(
836: p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type
837: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
838: ,x_return_status OUT NOCOPY VARCHAR2
839: )
840: IS
841:
842: l_valid_flag VARCHAR2(1);
843:
844: BEGIN
845: x_return_status := FND_API.g_ret_sts_success;
846: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
847:
848: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
849: 'PV_PARTNER_PROGRAM_TYPE_B',
850: 'PROGRAM_TYPE_ID = ''' || p_ptr_prgm_type_rec.PROGRAM_TYPE_ID ||''''
870:
871:
872: PROCEDURE Check_Req_Items(
873: p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type
874: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
875: ,x_return_status OUT NOCOPY VARCHAR2
876: )
877: IS
878: BEGIN
877: IS
878: BEGIN
879: x_return_status := FND_API.g_ret_sts_success;
880:
881: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
882:
883: IF p_ptr_prgm_type_rec.PROGRAM_TYPE_ID = FND_API.g_miss_num
884: OR p_ptr_prgm_type_rec.PROGRAM_TYPE_ID IS NULL THEN
885: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1250: p_api_version_number IN NUMBER
1251: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1252: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1253: ,p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type
1254: ,p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.G_UPDATE
1255: ,x_return_status OUT NOCOPY VARCHAR2
1256: ,x_msg_count OUT NOCOPY NUMBER
1257: ,x_msg_data OUT NOCOPY VARCHAR2
1258: )
1291:
1292: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - start');
1293: END IF;
1294:
1295: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1296: -- Debug message
1297: IF (PV_DEBUG_HIGH_ON) THEN
1298:
1299: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - prior to Check_Items call');
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318: END IF;
1319: END IF;
1320:
1321: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1322: Validate_Rec(
1323: p_api_version_number => 1.0
1324: ,p_init_msg_list => FND_API.G_FALSE
1325: ,x_return_status => x_return_status
1394: ,x_return_status OUT NOCOPY VARCHAR2
1395: ,x_msg_count OUT NOCOPY NUMBER
1396: ,x_msg_data OUT NOCOPY VARCHAR2
1397: ,p_ptr_prgm_type_rec IN ptr_prgm_type_rec_type
1398: ,p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.G_UPDATE
1399: )
1400: IS
1401: BEGIN
1402: -- Initialize message list if p_init_msg_list is set to TRUE.