eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_GE_PTNR_RESPS_PVT dependencies on PVX_UTILITY_PVT

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

128:
129: -- Debug Message
130: IF (PV_DEBUG_HIGH_ON) THEN
131:
132: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
133: END IF;
134:
135:
136:

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

142: -- =========================================================================
143:
144: IF FND_GLOBAL.USER_ID IS NULL
145: THEN
146: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
147: RAISE FND_API.G_EXC_ERROR;
148: END IF;
149:
150:

Line 157: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Ptnr_Resps');

153: THEN
154: -- Debug message
155: IF (PV_DEBUG_HIGH_ON) THEN
156:
157: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Ptnr_Resps');
158: END IF;
159:
160: -- Invoke validation procedures
161: Validate_ge_ptnr_resps(

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

193:
194: -- Debug Message
195: IF (PV_DEBUG_HIGH_ON) THEN
196:
197: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
198: END IF;
199:
200: -- Invoke table handler(Pv_Ge_Ptnr_Resps_Pkg.Insert_Row)
201: Pv_Ge_Ptnr_Resps_Pkg.Insert_Row(

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

231:
232: -- Debug Message
233: IF (PV_DEBUG_HIGH_ON) THEN
234:
235: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
236: END IF;
237:
238:
239: -- Standard call to get message count and if count is 1, get message info.

Line 246: WHEN PVX_UTILITY_PVT.resource_locked THEN

242: p_data => x_msg_data
243: );
244: EXCEPTION
245:
246: WHEN PVX_UTILITY_PVT.resource_locked THEN
247: x_return_status := FND_API.g_ret_sts_error;
248: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
249:
250: WHEN FND_API.G_EXC_ERROR THEN

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

244: EXCEPTION
245:
246: WHEN PVX_UTILITY_PVT.resource_locked THEN
247: x_return_status := FND_API.g_ret_sts_error;
248: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
249:
250: WHEN FND_API.G_EXC_ERROR THEN
251: ROLLBACK TO CREATE_Ge_Ptnr_Resps_PVT;
252: x_return_status := FND_API.G_RET_STS_ERROR;

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

372:
373: -- Debug Message
374: IF (PV_DEBUG_HIGH_ON) THEN
375:
376: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
377: END IF;
378:
379:
380:

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

383:
384: -- Debug Message
385: IF (PV_DEBUG_HIGH_ON) THEN
386:
387: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
388: END IF;
389:
390: OPEN c_get_Ge_Ptnr_Resps( l_tar_ge_ptnr_resps_rec.ptnr_resp_id);
391:

Line 395: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

391:
392: FETCH c_get_Ge_Ptnr_Resps INTO l_ref_ge_ptnr_resps_rec ;
393:
394: If ( c_get_Ge_Ptnr_Resps%NOTFOUND) THEN
395: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
396: p_token_name => 'INFO',
397: p_token_value => 'Ge_Ptnr_Resps') ;
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;

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

399: END IF;
400: -- Debug Message
401: IF (PV_DEBUG_HIGH_ON) THEN
402:
403: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');
404: END IF;
405: CLOSE c_get_Ge_Ptnr_Resps;
406:
407:

Line 410: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

406:
407:
408: If (l_tar_ge_ptnr_resps_rec.object_version_number is NULL or
409: l_tar_ge_ptnr_resps_rec.object_version_number = FND_API.G_MISS_NUM ) Then
410: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
411: p_token_name => 'COLUMN',
412: p_token_value => 'Last_Update_Date') ;
413: raise FND_API.G_EXC_ERROR;
414: End if;

Line 417: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

413: raise FND_API.G_EXC_ERROR;
414: End if;
415: -- Check Whether record has been changed by someone else
416: If (l_tar_ge_ptnr_resps_rec.object_version_number <> l_ref_ge_ptnr_resps_rec.object_version_number) Then
417: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
418: p_token_name => 'INFO',
419: p_token_value => 'Ge_Ptnr_Resps') ;
420: raise FND_API.G_EXC_ERROR;
421: End if;

Line 429: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Ptnr_Resps');

425: THEN
426: -- Debug message
427: IF (PV_DEBUG_HIGH_ON) THEN
428:
429: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Ptnr_Resps');
430: END IF;
431:
432: -- Invoke validation procedures
433: Validate_ge_ptnr_resps(

Line 445: PVX_UTILITY_PVT.debug_message('Private API: x_return_status = ' || x_return_status);

441: x_msg_data => x_msg_data);
442: END IF;
443: IF (PV_DEBUG_HIGH_ON) THEN
444:
445: PVX_UTILITY_PVT.debug_message('Private API: x_return_status = ' || x_return_status);
446: END IF;
447:
448: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
449: IF (PV_DEBUG_HIGH_ON) THEN

Line 451: PVX_UTILITY_PVT.debug_message('Private API: x_return_status<>FND_API.G_RET_STS_SUCCESS');

447:
448: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
449: IF (PV_DEBUG_HIGH_ON) THEN
450:
451: PVX_UTILITY_PVT.debug_message('Private API: x_return_status<>FND_API.G_RET_STS_SUCCESS');
452: END IF;
453: RAISE FND_API.G_EXC_ERROR;
454: END IF;
455:

Line 460: PVX_UTILITY_PVT.debug_message('Private API: Calling update table handler');

456:
457: -- Debug Message
458: IF (PV_DEBUG_HIGH_ON) THEN
459:
460: PVX_UTILITY_PVT.debug_message('Private API: Calling update table handler');
461: END IF;
462:
463: -- Invoke table handler(Pv_Ge_Ptnr_Resps_Pkg.Update_Row)
464: Pv_Ge_Ptnr_Resps_Pkg.Update_Row(

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

487:
488: -- Debug Message
489: IF (PV_DEBUG_HIGH_ON) THEN
490:
491: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
492: END IF;
493:
494:
495: -- Standard call to get message count and if count is 1, get message info.

Line 502: WHEN PVX_UTILITY_PVT.resource_locked THEN

498: p_data => x_msg_data
499: );
500: EXCEPTION
501:
502: WHEN PVX_UTILITY_PVT.resource_locked THEN
503: x_return_status := FND_API.g_ret_sts_error;
504: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
505:
506: WHEN FND_API.G_EXC_ERROR THEN

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

500: EXCEPTION
501:
502: WHEN PVX_UTILITY_PVT.resource_locked THEN
503: x_return_status := FND_API.g_ret_sts_error;
504: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
505:
506: WHEN FND_API.G_EXC_ERROR THEN
507: ROLLBACK TO UPDATE_Ge_Ptnr_Resps_PVT;
508: x_return_status := FND_API.G_RET_STS_ERROR;

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

614:
615: -- Debug Message
616: IF (PV_DEBUG_HIGH_ON) THEN
617:
618: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
619: END IF;
620:
621:
622:

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

628: --
629: -- Debug Message
630: IF (PV_DEBUG_HIGH_ON) THEN
631:
632: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
633: END IF;
634:
635: -- Invoke table handler(Pv_Ge_Ptnr_Resps_Pkg.Delete_Row)
636: Pv_Ge_Ptnr_Resps_Pkg.Delete_Row(

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

649:
650: -- Debug Message
651: IF (PV_DEBUG_HIGH_ON) THEN
652:
653: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
654: END IF;
655:
656:
657: -- Standard call to get message count and if count is 1, get message info.

Line 664: WHEN PVX_UTILITY_PVT.resource_locked THEN

660: p_data => x_msg_data
661: );
662: EXCEPTION
663:
664: WHEN PVX_UTILITY_PVT.resource_locked THEN
665: x_return_status := FND_API.g_ret_sts_error;
666: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
667:
668: WHEN FND_API.G_EXC_ERROR THEN

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

662: EXCEPTION
663:
664: WHEN PVX_UTILITY_PVT.resource_locked THEN
665: x_return_status := FND_API.g_ret_sts_error;
666: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
667:
668: WHEN FND_API.G_EXC_ERROR THEN
669: ROLLBACK TO DELETE_Ge_Ptnr_Resps_PVT;
670: x_return_status := FND_API.G_RET_STS_ERROR;

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

758:
759: -- Debug Message
760: IF (PV_DEBUG_HIGH_ON) THEN
761:
762: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
763: END IF;
764:
765:
766: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 800: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');

796: p_count => x_msg_count,
797: p_data => x_msg_data);
798: IF (PV_DEBUG_HIGH_ON) THEN
799:
800: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
801: END IF;
802: EXCEPTION
803:
804: WHEN PVX_UTILITY_PVT.resource_locked THEN

Line 804: WHEN PVX_UTILITY_PVT.resource_locked THEN

800: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
801: END IF;
802: EXCEPTION
803:
804: WHEN PVX_UTILITY_PVT.resource_locked THEN
805: x_return_status := FND_API.g_ret_sts_error;
806: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
807:
808: WHEN FND_API.G_EXC_ERROR THEN

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

802: EXCEPTION
803:
804: WHEN PVX_UTILITY_PVT.resource_locked THEN
805: x_return_status := FND_API.g_ret_sts_error;
806: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
807:
808: WHEN FND_API.G_EXC_ERROR THEN
809: ROLLBACK TO LOCK_Ge_Ptnr_Resps_PVT;
810: x_return_status := FND_API.G_RET_STS_ERROR;

Line 858: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

854: x_return_status := FND_API.g_ret_sts_success;
855: IF p_validation_mode = JTF_PLSQL_API.g_create
856: AND p_ge_ptnr_resps_rec.ptnr_resp_id IS NOT NULL
857: THEN
858: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
859: 'pv_ge_ptnr_resps',
860: 'ptnr_resp_id = ''' || p_ge_ptnr_resps_rec.ptnr_resp_id ||''''
861: );
862: END IF;

Line 865: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_ptnr_resp_id_DUPLICATE');

861: );
862: END IF;
863:
864: IF l_valid_flag = FND_API.g_false THEN
865: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_ptnr_resp_id_DUPLICATE');
866: x_return_status := FND_API.g_ret_sts_error;
867: END IF;
868:
869: IF p_ge_ptnr_resps_rec.PROGRAM_ID is null THEN

Line 870: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

866: x_return_status := FND_API.g_ret_sts_error;
867: END IF;
868:
869: IF p_ge_ptnr_resps_rec.PROGRAM_ID is null THEN
870: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
871: 'pv_ge_ptnr_resps'
872: ,'PARTNER_ID = ''' || p_ge_ptnr_resps_rec.PARTNER_ID ||
873: ''' AND USER_ROLE_CODE = ''' || p_ge_ptnr_resps_rec.USER_ROLE_CODE ||
874: ''' AND RESPONSIBILITY_ID = ''' || p_ge_ptnr_resps_rec.RESPONSIBILITY_ID ||

Line 879: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

875: ''' AND SOURCE_RESP_MAP_RULE_ID = ''' || p_ge_ptnr_resps_rec.SOURCE_RESP_MAP_RULE_ID ||
876: ''' AND RESP_TYPE_CODE = ''' || p_ge_ptnr_resps_rec.RESP_TYPE_CODE || ''''
877: );
878: ELSE
879: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
880: 'pv_ge_ptnr_resps'
881: ,'PROGRAM_ID = ''' || p_ge_ptnr_resps_rec.PROGRAM_ID ||
882: ''' AND PARTNER_ID = ''' || p_ge_ptnr_resps_rec.PARTNER_ID ||
883: ''' AND USER_ROLE_CODE = ''' || p_ge_ptnr_resps_rec.USER_ROLE_CODE ||

Line 891: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_ptnr_resp_id_DUPLICATE');

887: );
888: END IF;
889:
890: IF l_valid_flag = FND_API.g_false THEN
891: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_ptnr_resp_id_DUPLICATE');
892: x_return_status := FND_API.g_ret_sts_error;
893: END IF;
894:
895: END check_Ge_Ptnr_Resps_Uk_Items;

Line 912: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PTNR_RESP_ID' );

908: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
909:
910: /*
911: IF p_ge_ptnr_resps_rec.ptnr_resp_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.ptnr_resp_id IS NULL THEN
912: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PTNR_RESP_ID' );
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915: */
916:

Line 919: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USER_ROLE_CODE' );

915: */
916:
917:
918: IF p_ge_ptnr_resps_rec.user_role_code = FND_API.g_miss_char OR p_ge_ptnr_resps_rec.user_role_code IS NULL THEN
919: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USER_ROLE_CODE' );
920: x_return_status := FND_API.g_ret_sts_error;
921: END IF;
922:
923: IF p_ge_ptnr_resps_rec.responsibility_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.responsibility_id IS NULL THEN

Line 924: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSIBILITY_ID' );

920: x_return_status := FND_API.g_ret_sts_error;
921: END IF;
922:
923: IF p_ge_ptnr_resps_rec.responsibility_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.responsibility_id IS NULL THEN
924: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSIBILITY_ID' );
925: x_return_status := FND_API.g_ret_sts_error;
926: END IF;
927:
928: IF p_ge_ptnr_resps_rec.source_resp_map_rule_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.source_resp_map_rule_id IS NULL THEN

Line 929: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_RESP_MAP_RULE_ID' );

925: x_return_status := FND_API.g_ret_sts_error;
926: END IF;
927:
928: IF p_ge_ptnr_resps_rec.source_resp_map_rule_id = FND_API.G_MISS_NUM OR p_ge_ptnr_resps_rec.source_resp_map_rule_id IS NULL THEN
929: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_RESP_MAP_RULE_ID' );
930: x_return_status := FND_API.g_ret_sts_error;
931: END IF;
932:
933: IF p_ge_ptnr_resps_rec.resp_type_code = FND_API.g_miss_char OR p_ge_ptnr_resps_rec.resp_type_code IS NULL THEN

Line 934: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESP_TYPE_CODE' );

930: x_return_status := FND_API.g_ret_sts_error;
931: END IF;
932:
933: IF p_ge_ptnr_resps_rec.resp_type_code = FND_API.g_miss_char OR p_ge_ptnr_resps_rec.resp_type_code IS NULL THEN
934: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESP_TYPE_CODE' );
935: x_return_status := FND_API.g_ret_sts_error;
936: END IF;
937:
938: ELSE

Line 942: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PTNR_RESP_ID' );

938: ELSE
939:
940:
941: IF p_ge_ptnr_resps_rec.ptnr_resp_id = FND_API.G_MISS_NUM THEN
942: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PTNR_RESP_ID' );
943: x_return_status := FND_API.g_ret_sts_error;
944: END IF;
945:
946:

Line 948: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USER_ROLE_CODE' );

944: END IF;
945:
946:
947: IF p_ge_ptnr_resps_rec.user_role_code = FND_API.g_miss_char THEN
948: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USER_ROLE_CODE' );
949: x_return_status := FND_API.g_ret_sts_error;
950: END IF;
951:
952:

Line 954: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSIBILITY_ID' );

950: END IF;
951:
952:
953: IF p_ge_ptnr_resps_rec.responsibility_id = FND_API.G_MISS_NUM THEN
954: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSIBILITY_ID' );
955: x_return_status := FND_API.g_ret_sts_error;
956: END IF;
957:
958: IF p_ge_ptnr_resps_rec.source_resp_map_rule_id = FND_API.G_MISS_NUM THEN

Line 959: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_RESP_MAP_RULE_ID' );

955: x_return_status := FND_API.g_ret_sts_error;
956: END IF;
957:
958: IF p_ge_ptnr_resps_rec.source_resp_map_rule_id = FND_API.G_MISS_NUM THEN
959: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_RESP_MAP_RULE_ID' );
960: x_return_status := FND_API.g_ret_sts_error;
961: END IF;
962:
963: IF p_ge_ptnr_resps_rec.resp_type_code = FND_API.g_miss_char THEN

Line 964: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESP_TYPE_CODE' );

960: x_return_status := FND_API.g_ret_sts_error;
961: END IF;
962:
963: IF p_ge_ptnr_resps_rec.resp_type_code = FND_API.g_miss_char THEN
964: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESP_TYPE_CODE' );
965: x_return_status := FND_API.g_ret_sts_error;
966: END IF;
967:
968: IF p_ge_ptnr_resps_rec.object_version_number = FND_API.G_MISS_NUM THEN

Line 969: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

965: x_return_status := FND_API.g_ret_sts_error;
966: END IF;
967:
968: IF p_ge_ptnr_resps_rec.object_version_number = FND_API.G_MISS_NUM THEN
969: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
970: x_return_status := FND_API.g_ret_sts_error;
971: END IF;
972: END IF;
973:

Line 987: IF PVX_Utility_PVT.check_fk_exists(

983: BEGIN
984: x_return_status := FND_API.g_ret_sts_success;
985:
986: IF (p_ge_ptnr_resps_rec.resp_type_code = 'PROGRAMS') THEN
987: IF PVX_Utility_PVT.check_fk_exists(
988: 'pv_ge_resp_map_rules', -- Parent schema object having the primary key
989: 'resp_map_rule_id', -- Column name in the parent object that maps to the fk value
990: p_ge_ptnr_resps_rec.source_resp_map_rule_id, -- Value of fk to be validated against the parent object's pk column
991: PVX_utility_PVT.g_number, -- datatype of fk

Line 991: PVX_utility_PVT.g_number, -- datatype of fk

987: IF PVX_Utility_PVT.check_fk_exists(
988: 'pv_ge_resp_map_rules', -- Parent schema object having the primary key
989: 'resp_map_rule_id', -- Column name in the parent object that maps to the fk value
990: p_ge_ptnr_resps_rec.source_resp_map_rule_id, -- Value of fk to be validated against the parent object's pk column
991: PVX_utility_PVT.g_number, -- datatype of fk
992: null
993: ) = FND_API.g_false THEN
994: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
995: FND_MESSAGE.set_name('PV', 'PV_NOT_VALID_RESP_MAP_RULE_ID');

Line 1000: IF PVX_Utility_PVT.check_fk_exists(

996: FND_MSG_PUB.add;
997: END IF;
998: END IF;
999: ELSIF (p_ge_ptnr_resps_rec.resp_type_code = 'STORES') THEN
1000: IF PVX_Utility_PVT.check_fk_exists(
1001: 'pv_program_benefits', -- Parent schema object having the primary key
1002: 'program_benefits_id', -- Column name in the parent object that maps to the fk value
1003: p_ge_ptnr_resps_rec.source_resp_map_rule_id, -- Value of fk to be validated against the parent object's pk column
1004: PVX_utility_PVT.g_number, -- datatype of fk

Line 1004: PVX_utility_PVT.g_number, -- datatype of fk

1000: IF PVX_Utility_PVT.check_fk_exists(
1001: 'pv_program_benefits', -- Parent schema object having the primary key
1002: 'program_benefits_id', -- Column name in the parent object that maps to the fk value
1003: p_ge_ptnr_resps_rec.source_resp_map_rule_id, -- Value of fk to be validated against the parent object's pk column
1004: PVX_utility_PVT.g_number, -- datatype of fk
1005: null
1006: ) = FND_API.g_false THEN
1007: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1008: FND_MESSAGE.set_name('PV', 'PV_NOT_VALID_RESP_MAP_RULE_ID');

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

1262:
1263: -- Debug Message
1264: IF (PV_DEBUG_HIGH_ON) THEN
1265:
1266: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1267: END IF;
1268:
1269:
1270:

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

1274:
1275: -- Debug Message
1276: IF (PV_DEBUG_HIGH_ON) THEN
1277:
1278: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1279: END IF;
1280:
1281:
1282: -- Standard call to get message count and if count is 1, get message info.

Line 1289: WHEN PVX_UTILITY_PVT.resource_locked THEN

1285: p_data => x_msg_data
1286: );
1287: EXCEPTION
1288:
1289: WHEN PVX_UTILITY_PVT.resource_locked THEN
1290: x_return_status := FND_API.g_ret_sts_error;
1291: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1292:
1293: WHEN FND_API.G_EXC_ERROR THEN

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

1287: EXCEPTION
1288:
1289: WHEN PVX_UTILITY_PVT.resource_locked THEN
1290: x_return_status := FND_API.g_ret_sts_error;
1291: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1292:
1293: WHEN FND_API.G_EXC_ERROR THEN
1294: ROLLBACK TO VALIDATE_Ge_Ptnr_Resps_;
1295: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1358: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1354:
1355: -- Debug Message
1356: IF (PV_DEBUG_HIGH_ON) THEN
1357:
1358: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1359: END IF;
1360: -- Standard call to get message count and if count is 1, get message info.
1361: FND_MSG_PUB.Count_And_Get
1362: (p_count => x_msg_count,