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_PRGM_PTR_TYPES_PVT dependencies on PVX_UTILITY_PVT

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

86:
87: -- Debug Message
88: IF (PV_DEBUG_HIGH_ON) THEN
89:
90: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
91: END IF;
92:
93:
94: -- Initialize API return status to SUCCESS

Line 126: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - program_partner_types_id = '|| l_prgm_ptr_types_rec.program_partner_types_id);

122:
123: -- Debug message
124: IF (PV_DEBUG_HIGH_ON) THEN
125:
126: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - program_partner_types_id = '|| l_prgm_ptr_types_rec.program_partner_types_id);
127: END IF;
128:
129: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
130: -- Debug message

Line 133: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - Validate_Prgm_Ptr_Type');

129: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
130: -- Debug message
131: IF (PV_DEBUG_HIGH_ON) THEN
132:
133: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - Validate_Prgm_Ptr_Type');
134: END IF;
135:
136: -- Populate the default required items
137: l_prgm_ptr_types_rec.last_update_date := SYSDATE;

Line 158: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - Validate_Prgm_Ptr_Type return_status = ' || x_return_status );

154: );
155: -- Debug message
156: IF (PV_DEBUG_HIGH_ON) THEN
157:
158: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - Validate_Prgm_Ptr_Type return_status = ' || x_return_status );
159: END IF;
160:
161: END IF;
162:

Line 172: PVX_UTILITY_PVT.debug_message( 'Private API: ' || l_full_name || ' - Calling create table handler');

168:
169: -- Debug Message
170: IF (PV_DEBUG_HIGH_ON) THEN
171:
172: PVX_UTILITY_PVT.debug_message( 'Private API: ' || l_full_name || ' - Calling create table handler');
173: END IF;
174:
175: -- Invoke table handler(PV_PRGM_PTR_TYPES_PKG.Insert_Row)
176: PV_PRGM_PTR_TYPES_PKG.Insert_Row(

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

201:
202: -- Debug Message
203: IF (PV_DEBUG_HIGH_ON) THEN
204:
205: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
206: END IF;
207:
208: -- Standard check for p_commit
209: IF FND_API.to_Boolean( p_commit ) THEN

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

285:
286: -- Debug Message
287: IF (PV_DEBUG_HIGH_ON) THEN
288:
289: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
290: END IF;
291:
292: -- Standard call to check for call compatibility.
293: IF NOT FND_API.Compatible_API_Call (l_api_version_number

Line 314: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');

310:
311: -- Debug Message
312: IF (PV_DEBUG_HIGH_ON) THEN
313:
314: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');
315: END IF;
316:
317: OPEN c_get_Pgm_Tgt_Ptr_Typ( l_tar_prgm_ptr_types_rec.program_partner_types_id);
318: FETCH c_get_Pgm_Tgt_Ptr_Typ INTO l_ref_prgm_ptr_types_rec ;

Line 332: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Close Cursor');

328:
329: -- Debug Message
330: IF (PV_DEBUG_HIGH_ON) THEN
331:
332: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Close Cursor');
333: END IF;
334: CLOSE c_get_Pgm_Tgt_Ptr_Typ;
335:
336:

Line 358: PVX_UTILITY_PVT.debug_message('Private API: '||l_full_name||' - Validate_Prgm_Ptr_Type');

354: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
355: -- Debug message
356: IF (PV_DEBUG_HIGH_ON) THEN
357:
358: PVX_UTILITY_PVT.debug_message('Private API: '||l_full_name||' - Validate_Prgm_Ptr_Type');
359: END IF;
360:
361:
362: -- Invoke validation procedures

Line 390: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');

386:
387: -- Debug Message
388: IF (PV_DEBUG_HIGH_ON) THEN
389:
390: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
391: END IF;
392:
393: -- Invoke table handler(PV_PRGM_PTR_TYPES_PKG.Update_Row)
394: PV_PRGM_PTR_TYPES_PKG.Update_Row(

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

414:
415: -- Debug Message
416: IF (PV_DEBUG_HIGH_ON) THEN
417:
418: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
419: END IF;
420:
421: EXCEPTION
422: WHEN FND_API.G_EXC_ERROR THEN

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

484:
485: -- Debug Message
486: IF (PV_DEBUG_HIGH_ON) THEN
487:
488: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
489: END IF;
490:
491: -- Standard call to check for call compatibility.
492: IF NOT FND_API.Compatible_API_Call (l_api_version_number

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

509:
510: -- Debug Message
511: IF (PV_DEBUG_HIGH_ON) THEN
512:
513: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
514: END IF;
515:
516: -- Invoke table handler(PV_PRGM_PTR_TYPES_PKG.Delete_Row)
517: PV_PRGM_PTR_TYPES_PKG.Delete_Row(

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

532:
533: -- Debug Message
534: IF (PV_DEBUG_HIGH_ON) THEN
535:
536: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
537: END IF;
538:
539: EXCEPTION
540: WHEN FND_API.G_EXC_ERROR THEN

Line 610: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - start');

606:
607: -- Debug Message
608: IF (PV_DEBUG_HIGH_ON) THEN
609:
610: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - start');
611: END IF;
612:
613: -- Initialize message list if p_init_msg_list is set to TRUE.
614: IF FND_API.to_Boolean( p_init_msg_list )

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

657:
658: -- Debug Message
659: IF (PV_DEBUG_HIGH_ON) THEN
660:
661: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
662: END IF;
663:
664: EXCEPTION
665: /*

Line 666: WHEN PVX_Utility_PVT.resource_locked THEN

662: END IF;
663:
664: EXCEPTION
665: /*
666: WHEN PVX_Utility_PVT.resource_locked THEN
667: x_return_status := FND_API.g_ret_sts_error;
668: PVX_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
669: */
670: WHEN FND_API.G_EXC_ERROR THEN

Line 668: PVX_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

664: EXCEPTION
665: /*
666: WHEN PVX_Utility_PVT.resource_locked THEN
667: x_return_status := FND_API.g_ret_sts_error;
668: PVX_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
669: */
670: WHEN FND_API.G_EXC_ERROR THEN
671: ROLLBACK TO LOCK_PGM_TGT_PTR_TYP_PVT;
672: x_return_status := FND_API.G_RET_STS_ERROR;

Line 721: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

717:
718: x_return_status := FND_API.g_ret_sts_success;
719: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
720:
721: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
722: 'PV_PROGRAM_PARTNER_TYPES'
723: ,'PROGRAM_PARTNER_TYPES_ID = ''' || p_prgm_ptr_types_rec.PROGRAM_PARTNER_TYPES_ID ||''''
724: );
725:

Line 738: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API Before PROGRAM_TYPE_ID check' );

734:
735: -- Debug message
736: IF (PV_DEBUG_HIGH_ON) THEN
737:
738: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API Before PROGRAM_TYPE_ID check' );
739: END IF;
740:
741: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
742: 'PV_PROGRAM_PARTNER_TYPES'

Line 741: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

737:
738: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API Before PROGRAM_TYPE_ID check' );
739: END IF;
740:
741: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
742: 'PV_PROGRAM_PARTNER_TYPES'
743: ,'PROGRAM_TYPE_ID = ''' || p_prgm_ptr_types_rec.PROGRAM_TYPE_ID ||''' AND PARTNER_TYPE = ''' || p_prgm_ptr_types_rec.PARTNER_TYPE || ''''
744: );
745:

Line 903: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items before PROGRAM_TYPE_ID check : PROGRAM_TYPE_ID = ' || p_prgm_ptr_types_rec.PROGRAM_TYPE_ID);

899:
900: -- Debug message
901: IF (PV_DEBUG_HIGH_ON) THEN
902:
903: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items before PROGRAM_TYPE_ID check : PROGRAM_TYPE_ID = ' || p_prgm_ptr_types_rec.PROGRAM_TYPE_ID);
904: END IF;
905:
906: IF PVX_Utility_PVT.check_fk_exists(
907: 'PV_PARTNER_PROGRAM_TYPE_B', -- Parent schema object having the primary key

Line 906: IF PVX_Utility_PVT.check_fk_exists(

902:
903: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items before PROGRAM_TYPE_ID check : PROGRAM_TYPE_ID = ' || p_prgm_ptr_types_rec.PROGRAM_TYPE_ID);
904: END IF;
905:
906: IF PVX_Utility_PVT.check_fk_exists(
907: 'PV_PARTNER_PROGRAM_TYPE_B', -- Parent schema object having the primary key
908: 'PROGRAM_TYPE_ID', -- Column name in the parent object that maps to the fk value
909: p_prgm_ptr_types_rec.PROGRAM_TYPE_ID, -- Value of fk to be validated against the parent object's pk column
910: PVX_utility_PVT.g_number, -- datatype of fk

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

906: IF PVX_Utility_PVT.check_fk_exists(
907: 'PV_PARTNER_PROGRAM_TYPE_B', -- Parent schema object having the primary key
908: 'PROGRAM_TYPE_ID', -- Column name in the parent object that maps to the fk value
909: p_prgm_ptr_types_rec.PROGRAM_TYPE_ID, -- Value of fk to be validated against the parent object's pk column
910: PVX_utility_PVT.g_number, -- datatype of fk
911: NULL
912: ) = FND_API.g_false
913: THEN
914: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 928: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items after PROGRAM_TYPE_ID FK check ');

924:
925: -- Debug message
926: IF (PV_DEBUG_HIGH_ON) THEN
927:
928: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items after PROGRAM_TYPE_ID FK check ');
929: END IF;
930:
931: END Check_FK_Items;
932:

Line 970: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_Req_Items call');

966:
967: -- Debug message
968: IF (PV_DEBUG_HIGH_ON) THEN
969:
970: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_Req_Items call');
971: END IF;
972:
973: -- Check Items Required/NOT NULL API calls
974: Check_Req_Items(

Line 983: PVX_UTILITY_PVT.debug_message('- After Check_Req_Items. return status = ' || x_return_status);

979:
980: -- Debug message
981: IF (PV_DEBUG_HIGH_ON) THEN
982:
983: PVX_UTILITY_PVT.debug_message('- After Check_Req_Items. return status = ' || x_return_status);
984: END IF;
985:
986: IF x_return_status <> FND_API.g_ret_sts_success THEN
987: RETURN;

Line 993: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_UK_Items call');

989:
990: -- Debug message
991: IF (PV_DEBUG_HIGH_ON) THEN
992:
993: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_UK_Items call');
994: END IF;
995:
996: -- Check Items Uniqueness API calls
997: Check_UK_Items(

Line 1006: PVX_UTILITY_PVT.debug_message('- After Check_UK_Items. return status = ' || x_return_status);

1002:
1003: -- Debug message
1004: IF (PV_DEBUG_HIGH_ON) THEN
1005:
1006: PVX_UTILITY_PVT.debug_message('- After Check_UK_Items. return status = ' || x_return_status);
1007: END IF;
1008:
1009: IF x_return_status <> FND_API.g_ret_sts_success THEN
1010: RETURN;

Line 1016: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_FK_Items call');

1012:
1013: -- Debug message
1014: IF (PV_DEBUG_HIGH_ON) THEN
1015:
1016: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_FK_Items call');
1017: END IF;
1018:
1019: -- Check Items Foreign Keys API calls
1020: Check_FK_Items(

Line 1032: PVX_UTILITY_PVT.debug_message('- After Check_FK_Items. return status = ' || x_return_status);

1028:
1029: -- Debug message
1030: IF (PV_DEBUG_HIGH_ON) THEN
1031:
1032: PVX_UTILITY_PVT.debug_message('- After Check_FK_Items. return status = ' || x_return_status);
1033: END IF;
1034:
1035: IF x_return_status <> FND_API.g_ret_sts_success THEN
1036: RETURN;

Line 1042: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_Lookup_Items call');

1038:
1039: -- Debug message
1040: IF (PV_DEBUG_HIGH_ON) THEN
1041:
1042: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_Lookup_Items call');
1043: END IF;
1044:
1045: -- Check Items Lookups
1046: Check_Lookup_Items(

Line 1054: PVX_UTILITY_PVT.debug_message('- After Check_Lookup_Items. return status = ' || x_return_status);

1050:
1051: -- Debug message
1052: IF (PV_DEBUG_HIGH_ON) THEN
1053:
1054: PVX_UTILITY_PVT.debug_message('- After Check_Lookup_Items. return status = ' || x_return_status);
1055: END IF;
1056:
1057: IF x_return_status <> FND_API.g_ret_sts_success THEN
1058: RETURN;

Line 1091: PVX_UTILITY_PVT.debug_message('- In Complete_Rec API prior to assigning program_id');

1087:
1088: -- Debug message
1089: IF (PV_DEBUG_HIGH_ON) THEN
1090:
1091: PVX_UTILITY_PVT.debug_message('- In Complete_Rec API prior to assigning program_id');
1092: END IF;
1093:
1094: -- program_partner_types_id
1095: IF p_prgm_ptr_types_rec.program_partner_types_id IS NULL THEN

Line 1188: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - start');

1184:
1185: -- Debug Message
1186: IF (PV_DEBUG_HIGH_ON) THEN
1187:
1188: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - start');
1189: END IF;
1190:
1191: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1192: -- Debug message

Line 1195: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - prior to Check_Items call');

1191: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1192: -- Debug message
1193: IF (PV_DEBUG_HIGH_ON) THEN
1194:
1195: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - prior to Check_Items call');
1196: END IF;
1197:
1198: Check_Items(
1199: p_prgm_ptr_types_rec => p_prgm_ptr_types_rec

Line 1207: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - return status after Check_Items call ' || x_return_status);

1203:
1204: -- Debug message
1205: IF (PV_DEBUG_HIGH_ON) THEN
1206:
1207: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - return status after Check_Items call ' || x_return_status);
1208: END IF;
1209:
1210: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1211: RAISE FND_API.G_EXC_ERROR;

Line 1238: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - end');

1234:
1235: -- Debug Message
1236: IF (PV_DEBUG_HIGH_ON) THEN
1237:
1238: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - end');
1239: END IF;
1240:
1241: -- Standard call to get message count and if count is 1, get message info.
1242: FND_MSG_PUB.Count_And_Get

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

1314:
1315: -- Debug Message
1316: IF (PV_DEBUG_HIGH_ON) THEN
1317:
1318: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1319: END IF;
1320: -- Standard call to get message count and if count is 1, get message info.
1321: FND_MSG_PUB.Count_And_Get
1322: ( p_count => x_msg_count