DBA Data[Home] [Help]

APPS.PV_PARTNER_PGM_TYPE_PVT dependencies on PVX_UTILITY_PVT

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

104:
105: -- Debug Message
106: IF (PV_DEBUG_HIGH_ON) THEN
107:
108: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
109: END IF;
110:
111:
112: -- Initialize API return status to SUCCESS

Line 144: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - PROGRAM_TYPE_ID = '|| l_ptr_prgm_type_rec.PROGRAM_TYPE_ID);

140:
141: -- Debug message
142: IF (PV_DEBUG_HIGH_ON) THEN
143:
144: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - PROGRAM_TYPE_ID = '|| l_ptr_prgm_type_rec.PROGRAM_TYPE_ID);
145: END IF;
146:
147: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
148: -- Debug message

Line 151: PVX_UTILITY_PVT.debug_message('Private API ' || l_full_name || ' - Validate_Partner_Pgm_Type');

147: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
148: -- Debug message
149: IF (PV_DEBUG_HIGH_ON) THEN
150:
151: PVX_UTILITY_PVT.debug_message('Private API ' || l_full_name || ' - Validate_Partner_Pgm_Type');
152: END IF;
153:
154: -- Populate the default required items
155: l_ptr_prgm_type_rec.last_update_date := SYSDATE;

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

184: );
185: -- Debug message
186: IF (PV_DEBUG_HIGH_ON) THEN
187:
188: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - Validate_Partner_Program return_status = ' || x_return_status );
189: END IF;
190:
191: END IF;
192:

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

198:
199: -- Debug Message
200: IF (PV_DEBUG_HIGH_ON) THEN
201:
202: PVX_UTILITY_PVT.debug_message( 'Private API: ' || l_full_name || ' - Calling create table handler');
203: END IF;
204:
205: -- Invoke table handler(PV_PARTNER_PGM_TYPE_PKG.Insert_Row)
206: PV_PARTNER_PGM_TYPE_PKG.Insert_Row(

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

233:
234: -- Debug Message
235: IF (PV_DEBUG_HIGH_ON) THEN
236:
237: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
238: END IF;
239:
240: -- Standard check for p_commit
241: IF FND_API.to_Boolean( p_commit ) THEN

Line 255: PVX_UTILITY_PVT.debug_message('In CREATE_PARTNER_PROGRAM API ERROR BLOCK');

251: IF (PV_DEBUG_HIGH_ON) THEN
252:
253:
254:
255: PVX_UTILITY_PVT.debug_message('In CREATE_PARTNER_PROGRAM API ERROR BLOCK');
256:
257: END IF;
258:
259: -- Standard call to get message count and if count=1, get the message

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

327:
328: -- Debug Message
329: IF (PV_DEBUG_HIGH_ON) THEN
330:
331: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
332: END IF;
333:
334: -- Standard call to check for call compatibility.
335: IF NOT FND_API.Compatible_API_Call (l_api_version_number

Line 388: PVX_UTILITY_PVT.debug_message('Private API: '||l_full_name||' - Validate_Partner_Pgm_Type');

384: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
385: -- Debug message
386: IF (PV_DEBUG_HIGH_ON) THEN
387:
388: PVX_UTILITY_PVT.debug_message('Private API: '||l_full_name||' - Validate_Partner_Pgm_Type');
389: END IF;
390:
391:
392: -- Invoke validation procedures

Line 415: PVX_Utility_PVT.debug_message('active_flag = '|| l_tar_ptr_prgm_type_rec.active_flag);

411: IF (PV_DEBUG_HIGH_ON) THEN
412:
413:
414:
415: PVX_Utility_PVT.debug_message('active_flag = '|| l_tar_ptr_prgm_type_rec.active_flag);
416:
417: END IF;
418: -- Check whether this program type can be inactive
419: IF (l_tar_ptr_prgm_type_rec.active_flag <> FND_API.g_miss_char and

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

434:
435: -- Debug Message
436: IF (PV_DEBUG_HIGH_ON) THEN
437:
438: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
439: END IF;
440:
441: -- Invoke table handler(PV_PARTNER_PGM_TYPE_PKG.Update_Row)
442: PV_PARTNER_PGM_TYPE_PKG.Update_Row(

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

464:
465: -- Debug Message
466: IF (PV_DEBUG_HIGH_ON) THEN
467:
468: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
469: END IF;
470:
471: EXCEPTION
472: WHEN FND_API.G_EXC_ERROR THEN

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

547:
548: -- Debug Message
549: IF (PV_DEBUG_HIGH_ON) THEN
550:
551: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
552: END IF;
553:
554: -- Standard call to check for call compatibility.
555: IF NOT FND_API.Compatible_API_Call (l_api_version_number

Line 576: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - checking for object_version_number = ' || p_object_version_number);

572:
573: -- Debug Message
574: IF (PV_DEBUG_HIGH_ON) THEN
575:
576: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - checking for object_version_number = ' || p_object_version_number);
577: END IF;
578: IF (p_object_version_number is NULL or
579: p_object_version_number = FND_API.G_MISS_NUM ) THEN
580:

Line 608: PVX_UTILITY_PVT.debug_message('Private API: '|| l_full_name || ' - Close Cursor');

604:
605: -- Debug Message
606: IF (PV_DEBUG_HIGH_ON) THEN
607:
608: PVX_UTILITY_PVT.debug_message('Private API: '|| l_full_name || ' - Close Cursor');
609: END IF;
610: CLOSE c_get_ptr_prgm_type_rec;
611:
612: IF (l_tar_ptr_prgm_type_rec.object_version_number is NULL or

Line 639: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update for soft delete');

635:
636: -- Debug Message
637: IF (PV_DEBUG_HIGH_ON) THEN
638:
639: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update for soft delete');
640: END IF;
641:
642: -- Invoke table handler(PV_PARTNER_PGM_TYPE_PVT.Update_Partner_Pgm_Type)
643: PV_PARTNER_PGM_TYPE_PVT.Update_Partner_Pgm_Type(

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

664:
665: -- Debug Message
666: IF (PV_DEBUG_HIGH_ON) THEN
667:
668: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
669: END IF;
670:
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN

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

736:
737: -- Debug Message
738: IF (PV_DEBUG_HIGH_ON) THEN
739:
740: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
741: END IF;
742:
743: -- Initialize message list if p_init_msg_list is set to TRUE.
744: IF FND_API.to_Boolean( p_init_msg_list )

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

785:
786: -- Debug Message
787: IF (PV_DEBUG_HIGH_ON) THEN
788:
789: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
790: END IF;
791:
792: EXCEPTION
793: /*

Line 794: WHEN PVX_UTILITY_PVT.resource_locked THEN

790: END IF;
791:
792: EXCEPTION
793: /*
794: WHEN PVX_UTILITY_PVT.resource_locked THEN
795: x_return_status := FND_API.g_ret_sts_error;
796: PVX_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
797: */
798: WHEN FND_API.G_EXC_ERROR THEN

Line 796: PVX_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

792: EXCEPTION
793: /*
794: WHEN PVX_UTILITY_PVT.resource_locked THEN
795: x_return_status := FND_API.g_ret_sts_error;
796: PVX_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
797: */
798: WHEN FND_API.G_EXC_ERROR THEN
799: ROLLBACK TO LOCK_Partner_Pgm_Type_PVT;
800: x_return_status := FND_API.G_RET_STS_ERROR;

Line 848: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

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 ||''''
851: );
852: -- Debug message

Line 855: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API after PROGRAM_TYPE_ID check' );

851: );
852: -- Debug message
853: IF (PV_DEBUG_HIGH_ON) THEN
854:
855: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API after PROGRAM_TYPE_ID check' );
856: END IF;
857:
858: IF l_valid_flag = FND_API.g_false THEN
859: FND_MESSAGE.set_name('PVX', 'PV_API_DUPLICATE_ENTITY');

Line 945: PVX_UTILITY_PVT.debug_message('- In Check_Req_Items API Before Created_by Check' );

941:
942: -- Debug message
943: IF (PV_DEBUG_HIGH_ON) THEN
944:
945: PVX_UTILITY_PVT.debug_message('- In Check_Req_Items API Before Created_by Check' );
946: END IF;
947:
948:
949: IF p_ptr_prgm_type_rec.created_by = FND_API.g_miss_num

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

1052:
1053: -- Debug message
1054: IF (PV_DEBUG_HIGH_ON) THEN
1055:
1056: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_Req_Items call');
1057: END IF;
1058:
1059: -- Check Items Required/NOT NULL API calls
1060: Check_Req_Items(

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

1065:
1066: -- Debug message
1067: IF (PV_DEBUG_HIGH_ON) THEN
1068:
1069: PVX_UTILITY_PVT.debug_message('- After Check_Req_Items. return status = ' || x_return_status);
1070: END IF;
1071:
1072: IF x_return_status <> FND_API.g_ret_sts_success THEN
1073: RETURN;

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

1075:
1076: -- Debug message
1077: IF (PV_DEBUG_HIGH_ON) THEN
1078:
1079: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_UK_Items call');
1080: END IF;
1081:
1082: -- Check Items Uniqueness API calls
1083: Check_UK_Items(

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

1088:
1089: -- Debug message
1090: IF (PV_DEBUG_HIGH_ON) THEN
1091:
1092: PVX_UTILITY_PVT.debug_message('- After Check_UK_Items. return status = ' || x_return_status);
1093: END IF;
1094:
1095: IF x_return_status <> FND_API.g_ret_sts_success THEN
1096: RETURN;

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

1098:
1099: -- Debug message
1100: IF (PV_DEBUG_HIGH_ON) THEN
1101:
1102: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_FK_Items call');
1103: END IF;
1104:
1105: -- Check Items Foreign Keys API calls
1106: Check_FK_Items(

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

1110:
1111: -- Debug message
1112: IF (PV_DEBUG_HIGH_ON) THEN
1113:
1114: PVX_UTILITY_PVT.debug_message('- After Check_FK_Items. return status = ' || x_return_status);
1115: END IF;
1116:
1117: IF x_return_status <> FND_API.g_ret_sts_success THEN
1118: RETURN;

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

1120:
1121: -- Debug message
1122: IF (PV_DEBUG_HIGH_ON) THEN
1123:
1124: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_Lookup_Items call');
1125: END IF;
1126:
1127: -- Check Items Lookups
1128: Check_Lookup_Items(

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

1132:
1133: -- Debug message
1134: IF (PV_DEBUG_HIGH_ON) THEN
1135:
1136: PVX_UTILITY_PVT.debug_message('- After Check_Lookup_Items. return status = ' || x_return_status);
1137: END IF;
1138:
1139: IF x_return_status <> FND_API.g_ret_sts_success THEN
1140: RETURN;

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

1167:
1168: -- Debug message
1169: IF (PV_DEBUG_HIGH_ON) THEN
1170:
1171: PVX_UTILITY_PVT.debug_message('- In Complete_Rec API prior to assigning PROGRAM_TYPE_ID');
1172: END IF;
1173:
1174: -- PROGRAM_TYPE_ID
1175: --IF p_ptr_prgm_type_rec.PROGRAM_TYPE_ID = FND_API.g_miss_num THEN

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

1203:
1204: -- Debug message
1205: IF (PV_DEBUG_HIGH_ON) THEN
1206:
1207: PVX_UTILITY_PVT.debug_message('- In Complete_Rec API prior to assigning object_version_number');
1208: END IF;
1209:
1210: -- object_version_number
1211: --IF p_ptr_prgm_type_rec.object_version_number = FND_API.g_miss_num THEN

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

1288:
1289: -- Debug Message
1290: IF (PV_DEBUG_HIGH_ON) THEN
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

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

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');
1300: END IF;
1301:
1302: Check_Items(
1303: p_ptr_prgm_type_rec => p_ptr_prgm_type_rec

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

1307:
1308: -- Debug message
1309: IF (PV_DEBUG_HIGH_ON) THEN
1310:
1311: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - return status after Check_Items call ' || x_return_status);
1312: END IF;
1313:
1314: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1315: RAISE FND_API.G_EXC_ERROR;

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

1338:
1339: -- Debug Message
1340: IF (PV_DEBUG_HIGH_ON) THEN
1341:
1342: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - end');
1343: END IF;
1344:
1345: -- Standard call to get message count and if count is 1, get message info.
1346: FND_MSG_PUB.Count_And_Get

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

1415:
1416: -- Debug Message
1417: IF (PV_DEBUG_HIGH_ON) THEN
1418:
1419: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1420: END IF;
1421: -- Standard call to get message count and if count is 1, get message info.
1422: FND_MSG_PUB.Count_And_Get(
1423: p_count => x_msg_count