DBA Data[Home] [Help]

APPS.PV_PARTNER_ACCESSES_PVT dependencies on PVX_UTILITY_PVT

Line 119: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start.');

115: END IF;
116:
117: -- Debug Message
118: IF (PV_DEBUG_HIGH_ON) THEN
119: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start.');
120: END IF;
121:
122: -- Initialize API return status to SUCCESS
123: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 131: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

127: -- =========================================================================
128:
129: IF FND_GLOBAL.USER_ID IS NULL
130: THEN
131: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 139: PVX_UTILITY_PVT.debug_message('Private API: Validate_Partner_Accesses.');

135: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
136: THEN
137: -- Debug message
138: IF (PV_DEBUG_HIGH_ON) THEN
139: PVX_UTILITY_PVT.debug_message('Private API: Validate_Partner_Accesses.');
140: END IF;
141:
142: -- Invoke validation procedures
143: Validate_partner_accesses(

Line 178: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler.');

174: END IF;
175:
176: -- Debug Message
177: IF (PV_DEBUG_HIGH_ON) THEN
178: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler.');
179: END IF;
180:
181: -- Invoke table handler(Pv_Partner_Accesses_Pkg.Insert_Row)
182: Pv_Partner_Accesses_Pkg.Insert_Row(

Line 243: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end.');

239: END IF;
240:
241: -- Debug Message
242: IF (PV_DEBUG_HIGH_ON) THEN
243: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end.');
244: END IF;
245:
246: -- Standard call to get message count and if count is 1, get message info.
247: FND_MSG_PUB.Count_And_Get

Line 253: WHEN PVX_UTILITY_PVT.resource_locked THEN

249: p_data => x_msg_data
250: );
251: EXCEPTION
252:
253: WHEN PVX_UTILITY_PVT.resource_locked THEN
254: x_return_status := FND_API.g_ret_sts_error;
255: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
256:
257: WHEN FND_API.G_EXC_ERROR THEN

Line 255: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

251: EXCEPTION
252:
253: WHEN PVX_UTILITY_PVT.resource_locked THEN
254: x_return_status := FND_API.g_ret_sts_error;
255: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
256:
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO CREATE_Partner_Accesses_PVT;
259: x_return_status := FND_API.G_RET_STS_ERROR;

Line 375: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');

371: END IF;
372:
373: -- Debug Message
374: IF (PV_DEBUG_HIGH_ON) THEN
375: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
376: END IF;
377:
378: -- Initialize API return status to SUCCESS
379: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 383: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

379: x_return_status := FND_API.G_RET_STS_SUCCESS;
380:
381: -- Debug Message
382: IF (PV_DEBUG_HIGH_ON) THEN
383: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
384: END IF;
385:
386: OPEN c_get_Partner_Accesses( l_tar_partner_access_rec.partner_access_id);
387:

Line 391: PVX_UTILITY_PVT.Error_Message(

387:
388: FETCH c_get_Partner_Accesses INTO l_ref_partner_access_rec ;
389:
390: IF ( c_get_Partner_Accesses%NOTFOUND) THEN
391: PVX_UTILITY_PVT.Error_Message(
392: p_message_name => 'API_MISSING_UPDATE_TARGET',
393: p_token_name => 'INFO',
394: p_token_value => 'Partner_Accesses') ;
395: RAISE FND_API.G_EXC_ERROR;

Line 400: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor c_get_Partner_Accesses');

396: END IF;
397:
398: -- Debug Message
399: IF (PV_DEBUG_HIGH_ON) THEN
400: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor c_get_Partner_Accesses');
401: END IF;
402:
403: CLOSE c_get_Partner_Accesses;
404:

Line 407: PVX_UTILITY_PVT.Error_Message(

403: CLOSE c_get_Partner_Accesses;
404:
405: IF (l_tar_partner_access_rec.object_version_number is NULL or
406: l_tar_partner_access_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
407: PVX_UTILITY_PVT.Error_Message(
408: p_message_name => 'API_VERSION_MISSING',
409: p_token_name => 'COLUMN',
410: p_token_value => 'OBJECT_VERSION_NUMBER') ;
411: raise FND_API.G_EXC_ERROR;

Line 416: PVX_UTILITY_PVT.Error_Message(

412: End if;
413:
414: -- Check Whether record has been changed by someone else
415: IF (l_tar_partner_access_rec.object_version_number <> l_ref_partner_access_rec.object_version_number) THEN
416: PVX_UTILITY_PVT.Error_Message(
417: p_message_name => 'API_RECORD_CHANGED',
418: p_token_name => 'INFO',
419: p_token_value => 'Partner_Accesses') ;
420: raise FND_API.G_EXC_ERROR;

Line 427: PVX_UTILITY_PVT.debug_message('Private API: Validate_Partner_Accesses');

423: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
424: THEN
425: -- Debug Message
426: IF (PV_DEBUG_HIGH_ON) THEN
427: PVX_UTILITY_PVT.debug_message('Private API: Validate_Partner_Accesses');
428: END IF;
429:
430: Validate_partner_accesses(
431: p_api_version_number => 1.0,

Line 448: PVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

444:
445:
446: -- Debug Message
447: IF (PV_DEBUG_HIGH_ON) THEN
448: PVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
449: END IF;
450:
451: -- Invoke table handler(Pv_Partner_Accesses_Pkg.Update_Row)
452: Pv_Partner_Accesses_Pkg.Update_Row(

Line 511: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');

507:
508:
509: -- Debug Message
510: IF (PV_DEBUG_HIGH_ON) THEN
511: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
512: END IF;
513:
514: -- Standard call to get message count and if count is 1, get message info.
515: FND_MSG_PUB.Count_And_Get

Line 521: WHEN PVX_UTILITY_PVT.resource_locked THEN

517: p_data => x_msg_data
518: );
519: EXCEPTION
520:
521: WHEN PVX_UTILITY_PVT.resource_locked THEN
522: x_return_status := FND_API.g_ret_sts_error;
523: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
524:
525: WHEN FND_API.G_EXC_ERROR THEN

Line 523: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

519: EXCEPTION
520:
521: WHEN PVX_UTILITY_PVT.resource_locked THEN
522: x_return_status := FND_API.g_ret_sts_error;
523: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
524:
525: WHEN FND_API.G_EXC_ERROR THEN
526: ROLLBACK TO UPDATE_Partner_Accesses_PVT;
527: x_return_status := FND_API.G_RET_STS_ERROR;

Line 634: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');

630: END IF;
631:
632: -- Debug Message
633: IF (PV_DEBUG_HIGH_ON) THEN
634: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
635: END IF;
636:
637: -- Initialize API return status to SUCCESS
638: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 646: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

642: --
643:
644: -- Debug Message
645: IF (PV_DEBUG_HIGH_ON) THEN
646: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
647: END IF;
648:
649: -- Invoke table handler(Pv_Partner_Accesses_Pkg.Delete_Row)
650: Pv_Partner_Accesses_Pkg.Delete_Row(

Line 679: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');

675: END IF;
676:
677: -- Debug Message
678: IF (PV_DEBUG_HIGH_ON) THEN
679: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' End');
680: END IF;
681:
682: -- Standard call to get message count and if count is 1, get message info.
683: FND_MSG_PUB.Count_And_Get

Line 689: WHEN PVX_UTILITY_PVT.resource_locked THEN

685: p_data => x_msg_data
686: );
687: EXCEPTION
688:
689: WHEN PVX_UTILITY_PVT.resource_locked THEN
690: x_return_status := FND_API.g_ret_sts_error;
691: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
692:
693: WHEN FND_API.G_EXC_ERROR THEN

Line 691: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

687: EXCEPTION
688:
689: WHEN PVX_UTILITY_PVT.resource_locked THEN
690: x_return_status := FND_API.g_ret_sts_error;
691: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
692:
693: WHEN FND_API.G_EXC_ERROR THEN
694: ROLLBACK TO DELETE_Partner_Accesses_PVT;
695: x_return_status := FND_API.G_RET_STS_ERROR;

Line 789: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

785: SAVEPOINT Lock_Partner_Accesses;
786:
787: -- Debug Message
788: IF (PV_DEBUG_HIGH_ON) THEN
789: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
790: END IF;
791:
792: -- Initialize message list if p_init_msg_list is set to TRUE.
793: IF FND_API.to_Boolean( p_init_msg_list )

Line 831: PVX_UTILITY_PVT.debug_message(l_full_name ||': End');

827: p_data => x_msg_data);
828:
829: -- Debug Message
830: IF (PV_DEBUG_HIGH_ON) THEN
831: PVX_UTILITY_PVT.debug_message(l_full_name ||': End');
832: END IF;
833:
834: EXCEPTION
835:

Line 836: WHEN PVX_UTILITY_PVT.resource_locked THEN

832: END IF;
833:
834: EXCEPTION
835:
836: WHEN PVX_UTILITY_PVT.resource_locked THEN
837: x_return_status := FND_API.g_ret_sts_error;
838: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
839:
840: WHEN FND_API.G_EXC_ERROR THEN

Line 838: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

834: EXCEPTION
835:
836: WHEN PVX_UTILITY_PVT.resource_locked THEN
837: x_return_status := FND_API.g_ret_sts_error;
838: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
839:
840: WHEN FND_API.G_EXC_ERROR THEN
841: ROLLBACK TO Lock_Partner_Accesses;
842: x_return_status := FND_API.G_RET_STS_ERROR;

Line 886: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

882: BEGIN
883: x_return_status := FND_API.g_ret_sts_success;
884: IF p_validation_mode = JTF_PLSQL_API.g_create AND
885: p_partner_access_rec.partner_access_id IS NOT NULL THEN
886: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
887: 'pv_partner_accesses',
888: 'partner_access_id = ''' || p_partner_access_rec.partner_access_id ||''''
889: );
890: END IF;

Line 893: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_DUPLICATE_ID');

889: );
890: END IF;
891:
892: IF l_valid_flag = FND_API.g_false THEN
893: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_DUPLICATE_ID');
894: x_return_status := FND_API.g_ret_sts_error;
895: END IF;
896:
897: END chk_Partner_Access_Uk_Items;

Line 912: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ID' );

908: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
909:
910: -- Check for required paramter PARTNER_ID.
911: IF p_partner_access_rec.partner_id = FND_API.G_MISS_NUM OR p_partner_access_rec.partner_id IS NULL THEN
912: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ID' );
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915:
916: -- Check for required paramter RESOURCE_ID.

Line 918: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'RESOURCE_ID' );

914: END IF;
915:
916: -- Check for required paramter RESOURCE_ID.
917: IF p_partner_access_rec.resource_id = FND_API.G_MISS_NUM OR p_partner_access_rec.resource_id IS NULL THEN
918: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'RESOURCE_ID' );
919: x_return_status := FND_API.g_ret_sts_error;
920: END IF;
921:
922: -- Check for required paramter KEEP_FLAG.

Line 924: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'KEEP_FLAG' );

920: END IF;
921:
922: -- Check for required paramter KEEP_FLAG.
923: IF p_partner_access_rec.keep_flag = FND_API.g_miss_char OR p_partner_access_rec.keep_flag IS NULL THEN
924: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'KEEP_FLAG' );
925: x_return_status := FND_API.g_ret_sts_error;
926: END IF;
927:
928: -- Check for required paramter CREATED_BY_TAP_FLAG.

Line 930: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'CREATED_BY_TAP_FLAG' );

926: END IF;
927:
928: -- Check for required paramter CREATED_BY_TAP_FLAG.
929: IF p_partner_access_rec.created_by_tap_flag = FND_API.g_miss_char OR p_partner_access_rec.created_by_tap_flag IS NULL THEN
930: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'CREATED_BY_TAP_FLAG' );
931: x_return_status := FND_API.g_ret_sts_error;
932: END IF;
933:
934: -- Check for required paramter ACCESS_TYPE.

Line 936: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'ACCESS_TYPE' );

932: END IF;
933:
934: -- Check for required paramter ACCESS_TYPE.
935: IF p_partner_access_rec.access_type = FND_API.g_miss_char OR p_partner_access_rec.access_type IS NULL THEN
936: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'ACCESS_TYPE' );
937: x_return_status := FND_API.g_ret_sts_error;
938: END IF;
939:
940: ELSE

Line 944: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ACCESS_ID' );

940: ELSE
941:
942: -- Check for PARTNER_ACCESS_ID in case of Update only.
943: IF p_partner_access_rec.partner_access_id = FND_API.G_MISS_NUM THEN
944: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ACCESS_ID' );
945: x_return_status := FND_API.g_ret_sts_error;
946: END IF;
947:
948: -- Check for required paramter PARTNER_ID.

Line 950: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ID' );

946: END IF;
947:
948: -- Check for required paramter PARTNER_ID.
949: IF p_partner_access_rec.partner_id = FND_API.G_MISS_NUM THEN
950: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ID' );
951: x_return_status := FND_API.g_ret_sts_error;
952: END IF;
953:
954: -- Check for required paramter RESOURCE_ID.

Line 956: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'RESOURCE_ID' );

952: END IF;
953:
954: -- Check for required paramter RESOURCE_ID.
955: IF p_partner_access_rec.resource_id = FND_API.G_MISS_NUM THEN
956: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'RESOURCE_ID' );
957: x_return_status := FND_API.g_ret_sts_error;
958: END IF;
959:
960: -- Check for required paramter KEEP_FLAG.

Line 962: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'KEEP_FLAG' );

958: END IF;
959:
960: -- Check for required paramter KEEP_FLAG.
961: IF p_partner_access_rec.keep_flag = FND_API.g_miss_char THEN
962: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'KEEP_FLAG' );
963: x_return_status := FND_API.g_ret_sts_error;
964: END IF;
965:
966: -- Check for required paramter CREATED_BY_TAP_FLAG.

Line 968: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'CREATED_BY_TAP_FLAG' );

964: END IF;
965:
966: -- Check for required paramter CREATED_BY_TAP_FLAG.
967: IF p_partner_access_rec.created_by_tap_flag = FND_API.g_miss_char THEN
968: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'CREATED_BY_TAP_FLAG' );
969: x_return_status := FND_API.g_ret_sts_error;
970: END IF;
971:
972: -- Check for required paramter ACCESS_TYPE.

Line 974: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'ACCESS_TYPE' );

970: END IF;
971:
972: -- Check for required paramter ACCESS_TYPE.
973: IF p_partner_access_rec.access_type = FND_API.g_miss_char THEN
974: PVX_UTILITY_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'ACCESS_TYPE' );
975: x_return_status := FND_API.g_ret_sts_error;
976: END IF;
977: END IF;
978:

Line 1013: PVX_UTILITY_PVT.Error_Message('PV_PARTNER_NOT_ACTIVE');

1009: FETCH l_chk_partner_active_csr INTO l_partner_active;
1010:
1011: IF l_chk_partner_active_csr%NOTFOUND THEN
1012: CLOSE l_chk_partner_active_csr ;
1013: PVX_UTILITY_PVT.Error_Message('PV_PARTNER_NOT_ACTIVE');
1014: x_return_status := FND_API.g_ret_sts_error;
1015: ELSE
1016: CLOSE l_chk_partner_active_csr ;
1017: END IF;

Line 1025: PVX_UTILITY_PVT.Error_Message('PV_INVALID_RESOURCE_ID');

1021: FETCH l_chk_resource_active_csr INTO l_resource_active;
1022:
1023: IF l_chk_resource_active_csr%NOTFOUND THEN
1024: CLOSE l_chk_resource_active_csr ;
1025: PVX_UTILITY_PVT.Error_Message('PV_INVALID_RESOURCE_ID');
1026: x_return_status := FND_API.g_ret_sts_error;
1027: ELSE
1028: CLOSE l_chk_resource_active_csr ;
1029: END IF;

Line 1310: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');

1306: END IF;
1307:
1308: -- Debug Message
1309: IF (PV_DEBUG_HIGH_ON) THEN
1310: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Start');
1311: END IF;
1312:
1313: -- Initialize message list if p_init_msg_list is set to TRUE.
1314: IF FND_API.to_Boolean( p_init_msg_list )

Line 1366: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1362:
1363:
1364: -- Debug Message
1365: IF (PV_DEBUG_HIGH_ON) THEN
1366: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1367: END IF;
1368:
1369:
1370: -- Standard call to get message count and if count is 1, get message info.

Line 1376: WHEN PVX_UTILITY_PVT.resource_locked THEN

1372: (p_count => x_msg_count,
1373: p_data => x_msg_data
1374: );
1375: EXCEPTION
1376: WHEN PVX_UTILITY_PVT.resource_locked THEN
1377: x_return_status := FND_API.g_ret_sts_error;
1378: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1379:
1380: WHEN FND_API.G_EXC_ERROR THEN

Line 1378: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1374: );
1375: EXCEPTION
1376: WHEN PVX_UTILITY_PVT.resource_locked THEN
1377: x_return_status := FND_API.g_ret_sts_error;
1378: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1379:
1380: WHEN FND_API.G_EXC_ERROR THEN
1381: ROLLBACK TO VALIDATE_Partner_Accesses;
1382: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1446: PVX_UTILITY_PVT.Error_Message('PV_INVALID_FLAG');

1442: -- x_return_status := FND_API.G_RET_STS_ERROR;
1443:
1444: -- Validate the FLAG value for KEEP_FLAG and CREATED_BY TAP_FLAG
1445: IF ( p_partner_access_rec.keep_flag <> 'Y' AND p_partner_access_rec.keep_flag <> 'N' ) THEN
1446: PVX_UTILITY_PVT.Error_Message('PV_INVALID_FLAG');
1447: x_return_status := FND_API.G_RET_STS_ERROR;
1448: END IF;
1449:
1450: IF ( p_partner_access_rec.CREATED_BY_TAP_FLAG <> 'Y' AND p_partner_access_rec.CREATED_BY_TAP_FLAG <> 'N' ) THEN

Line 1451: PVX_UTILITY_PVT.Error_Message('PV_INVALID_FLAG');

1447: x_return_status := FND_API.G_RET_STS_ERROR;
1448: END IF;
1449:
1450: IF ( p_partner_access_rec.CREATED_BY_TAP_FLAG <> 'Y' AND p_partner_access_rec.CREATED_BY_TAP_FLAG <> 'N' ) THEN
1451: PVX_UTILITY_PVT.Error_Message('PV_INVALID_FLAG');
1452: x_return_status := FND_API.G_RET_STS_ERROR;
1453: END IF;
1454:
1455: -- Standard call to get message count and if count is 1, get message info.