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

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

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

Line 106: PVX_Utility_PVT.debug_message(l_full_name ||': validate');

102: IF (PV_DEBUG_HIGH_ON) THEN
103:
104:
105:
106: PVX_Utility_PVT.debug_message(l_full_name ||': validate');
107:
108: END IF;
109:
110: IF FND_GLOBAL.User_Id IS NULL THEN

Line 137: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - program_benefits_id = '|| l_prgm_benefits_rec.program_benefits_id);

133:
134: -- Debug message
135: IF (PV_DEBUG_HIGH_ON) THEN
136:
137: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - program_benefits_id = '|| l_prgm_benefits_rec.program_benefits_id);
138: END IF;
139:
140: -- Populate the default required items
141: l_prgm_benefits_rec.last_update_date := SYSDATE;

Line 152: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - Validate_Prgm_Benefits');

148: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
149: -- Debug message
150: IF (PV_DEBUG_HIGH_ON) THEN
151:
152: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - Validate_Prgm_Benefits');
153: END IF;
154:
155:
156: -- Invoke validation procedures

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

166: );
167: -- Debug message
168: IF (PV_DEBUG_HIGH_ON) THEN
169:
170: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - Validate_Prgm_Benefits return_status = ' || x_return_status );
171: END IF;
172:
173: END IF;
174:

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

184:
185: -- Debug Message
186: IF (PV_DEBUG_HIGH_ON) THEN
187:
188: PVX_UTILITY_PVT.debug_message( 'Private API:' || l_full_name || ' - Calling create table handler');
189: END IF;
190:
191: -- Invoke table handler(PV_PRGM_BENEFITS_PKG.Insert_Row)
192: PV_PRGM_BENEFITS_PKG.Insert_Row(

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

220:
221: -- Debug Message
222: IF (PV_DEBUG_HIGH_ON) THEN
223:
224: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
225: END IF;
226:
227: -- Standard check for p_commit
228: IF FND_API.to_Boolean( p_commit ) THEN

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

337:
338: -- Debug Message
339: IF (PV_DEBUG_HIGH_ON) THEN
340:
341: PVX_UTILITY_PVT.debug_message('Private API: '||l_full_name||' - Close Cursor');
342: END IF;
343: CLOSE c_get_Prgm_Benefits;
344:
345: If (l_tar_prgm_benefits_rec.object_version_number is NULL or

Line 366: PVX_UTILITY_PVT.debug_message('Private API: '||l_full_name||' - Validate_Prgm_Benefits');

362: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
363: -- Debug message
364: IF (PV_DEBUG_HIGH_ON) THEN
365:
366: PVX_UTILITY_PVT.debug_message('Private API: '||l_full_name||' - Validate_Prgm_Benefits');
367: END IF;
368:
369: -- Invoke validation procedures
370: Validate_Prgm_Benefits(

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

393:
394: -- Debug Message
395: IF (PV_DEBUG_HIGH_ON) THEN
396:
397: Pvx_Utility_Pvt.debug_message('Private API: '||l_full_name||' - Calling update table handler');
398: END IF;
399:
400: -- Invoke table handler(PV_PRGM_BENEFITS_PKG.Update_Row)
401: PV_PRGM_BENEFITS_PKG.Update_Row(

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

424:
425: -- Debug Message
426: IF (PV_DEBUG_HIGH_ON) THEN
427:
428: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
429: END IF;
430:
431: EXCEPTION
432: WHEN FND_API.G_EXC_ERROR THEN

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

495:
496: -- Debug Message
497: IF (PV_DEBUG_HIGH_ON) THEN
498:
499: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - start');
500: END IF;
501:
502: -- Standard call to check for call compatibility.
503: IF NOT FND_API.Compatible_API_Call (l_api_version_number

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

520:
521: -- Debug Message
522: IF (PV_DEBUG_HIGH_ON) THEN
523:
524: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler...');
525: END IF;
526:
527: -- Invoke table handler(PV_PRGM_BENEFITS_PKG.Delete_Row)
528: PV_PRGM_BENEFITS_PKG.Delete_Row(

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

543:
544: -- Debug Message
545: IF (PV_DEBUG_HIGH_ON) THEN
546:
547: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
548: END IF;
549:
550: EXCEPTION
551: WHEN FND_API.G_EXC_ERROR THEN

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

616:
617: -- Debug Message
618: IF (PV_DEBUG_HIGH_ON) THEN
619:
620: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || 'start');
621: END IF;
622:
623: -- Initialize message list if p_init_msg_list is set to TRUE.
624: IF FND_API.to_Boolean( p_init_msg_list )

Line 651: PVX_UTILITY_PVT.debug_message(l_full_name||': start');

647: IF (PV_DEBUG_HIGH_ON) THEN
648:
649:
650:
651: PVX_UTILITY_PVT.debug_message(l_full_name||': start');
652:
653: END IF;
654: OPEN c_Prgm_Benefits;
655:

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

675:
676: -- Debug Message
677: IF (PV_DEBUG_HIGH_ON) THEN
678:
679: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' - end');
680: END IF;
681:
682: EXCEPTION
683: /*

Line 684: WHEN PVX_UTILITY_PVT.resource_locked THEN

680: END IF;
681:
682: EXCEPTION
683: /*
684: WHEN PVX_UTILITY_PVT.resource_locked THEN
685: x_return_status := FND_API.g_ret_sts_error;
686: PVX_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
687: */
688: WHEN FND_API.G_EXC_ERROR THEN

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

682: EXCEPTION
683: /*
684: WHEN PVX_UTILITY_PVT.resource_locked THEN
685: x_return_status := FND_API.g_ret_sts_error;
686: PVX_UTILITY_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
687: */
688: WHEN FND_API.G_EXC_ERROR THEN
689: ROLLBACK TO LOCK_Prgm_Benefits_PVT;
690: x_return_status := FND_API.G_RET_STS_ERROR;

Line 740: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

736:
737: x_return_status := FND_API.g_ret_sts_success;
738: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
739:
740: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
741: 'PV_PROGRAM_BENEFITS',
742: 'program_benefits_id = ''' || p_prgm_benefits_rec.program_benefits_id ||''''
743: );
744:

Line 756: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API' );

752: END IF;
753: -- Debug message
754: IF (PV_DEBUG_HIGH_ON) THEN
755:
756: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API' );
757: END IF;
758: END IF;
759:
760: END Check_UK_Items;

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

876:
877: -- Debug message
878: IF (PV_DEBUG_HIGH_ON) THEN
879:
880: PVX_UTILITY_PVT.debug_message('- In Check_Req_Items API Before Created_by Check' );
881: END IF;
882:
883: IF p_prgm_benefits_rec.created_by = FND_API.g_miss_num
884: OR p_prgm_benefits_rec.created_by IS NULL THEN

Line 971: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items : Before PROGRAM_ID fk check : PROGRAM_ID ' || p_prgm_benefits_rec.PROGRAM_ID);

967:
968: -- Debug message
969: IF (PV_DEBUG_HIGH_ON) THEN
970:
971: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items : Before PROGRAM_ID fk check : PROGRAM_ID ' || p_prgm_benefits_rec.PROGRAM_ID);
972: END IF;
973:
974: IF PVX_Utility_PVT.check_fk_exists(
975: 'PV_PARTNER_PROGRAM_B', -- Parent schema object having the primary key

Line 974: IF PVX_Utility_PVT.check_fk_exists(

970:
971: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items : Before PROGRAM_ID fk check : PROGRAM_ID ' || p_prgm_benefits_rec.PROGRAM_ID);
972: END IF;
973:
974: IF PVX_Utility_PVT.check_fk_exists(
975: 'PV_PARTNER_PROGRAM_B', -- Parent schema object having the primary key
976: 'PROGRAM_ID', -- Column name in the parent object that maps to the fk value
977: p_prgm_benefits_rec.PROGRAM_ID, -- Value of fk to be validated against the parent object's pk column
978: PVX_utility_PVT.g_number, -- datatype of fk

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

974: IF PVX_Utility_PVT.check_fk_exists(
975: 'PV_PARTNER_PROGRAM_B', -- Parent schema object having the primary key
976: 'PROGRAM_ID', -- Column name in the parent object that maps to the fk value
977: p_prgm_benefits_rec.PROGRAM_ID, -- Value of fk to be validated against the parent object's pk column
978: PVX_utility_PVT.g_number, -- datatype of fk
979: NULL
980: ) = FND_API.g_false
981: THEN
982: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 996: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items : After program_id fk check ');

992:
993: -- Debug message
994: IF (PV_DEBUG_HIGH_ON) THEN
995:
996: PVX_UTILITY_PVT.debug_message('- In Check_FK_Items : After program_id fk check ');
997: END IF;
998:
999: END Check_FK_Items;
1000:

Line 1018: IF PVX_Utility_PVT.check_lookup_exists(

1014: /*
1015: ----------------------- Benefit_Code lookup ------------------------
1016: IF p_prgm_benefits_rec.Benefit_Code <> FND_API.g_miss_char THEN
1017:
1018: IF PVX_Utility_PVT.check_lookup_exists(
1019: 'FND_LOOKUP_VALUES', -- Look up Table Name
1020: 'PV_PROGRAM_BENEFITS', -- Lookup Type
1021: p_prgm_benefits_rec.Benefit_Code -- Lookup Code
1022: ) = FND_API.g_false

Line 1039: PVX_UTILITY_PVT.debug_message('- In Check_Lookup_Items : x_return_status = '||x_return_status);

1035:
1036: -- Debug message
1037: IF (PV_DEBUG_HIGH_ON) THEN
1038:
1039: PVX_UTILITY_PVT.debug_message('- In Check_Lookup_Items : x_return_status = '||x_return_status);
1040: END IF;
1041:
1042: END Check_Lookup_Items;
1043:

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

1058:
1059: -- Debug message
1060: IF (PV_DEBUG_HIGH_ON) THEN
1061:
1062: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_Req_Items call');
1063: END IF;
1064:
1065: -- Check Items Required/NOT NULL API calls
1066: Check_Req_Items(

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

1071:
1072: -- Debug message
1073: IF (PV_DEBUG_HIGH_ON) THEN
1074:
1075: PVX_UTILITY_PVT.debug_message('- After Check_Req_Items. return status = ' || x_return_status);
1076: END IF;
1077:
1078: IF x_return_status <> FND_API.g_ret_sts_success THEN
1079: RETURN;

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

1081:
1082: -- Debug message
1083: IF (PV_DEBUG_HIGH_ON) THEN
1084:
1085: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_UK_Items call');
1086: END IF;
1087:
1088: -- Check Items Uniqueness API calls
1089: Check_UK_Items(

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

1094:
1095: -- Debug message
1096: IF (PV_DEBUG_HIGH_ON) THEN
1097:
1098: PVX_UTILITY_PVT.debug_message('- After Check_UK_Items. return status = ' || x_return_status);
1099: END IF;
1100:
1101: IF x_return_status <> FND_API.g_ret_sts_success THEN
1102: RETURN;

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

1104:
1105: -- Debug message
1106: IF (PV_DEBUG_HIGH_ON) THEN
1107:
1108: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_FK_Items call');
1109: END IF;
1110:
1111: -- Check Items Foreign Keys API calls
1112: Check_FK_Items(

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

1116:
1117: -- Debug message
1118: IF (PV_DEBUG_HIGH_ON) THEN
1119:
1120: PVX_UTILITY_PVT.debug_message('- After Check_FK_Items. return status = ' || x_return_status);
1121: END IF;
1122:
1123: IF x_return_status <> FND_API.g_ret_sts_success THEN
1124: RETURN;

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

1126:
1127: -- Debug message
1128: IF (PV_DEBUG_HIGH_ON) THEN
1129:
1130: PVX_UTILITY_PVT.debug_message('- Check_Items API prior to Check_Lookup_Items call');
1131: END IF;
1132:
1133: -- Check Items Lookups
1134: Check_Lookup_Items(

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

1138:
1139: -- Debug message
1140: IF (PV_DEBUG_HIGH_ON) THEN
1141:
1142: PVX_UTILITY_PVT.debug_message('- After Check_Lookup_Items. return status = ' || x_return_status);
1143: END IF;
1144:
1145: IF x_return_status <> FND_API.g_ret_sts_success THEN
1146: RETURN;

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

1175:
1176: -- Debug message
1177: IF (PV_DEBUG_HIGH_ON) THEN
1178:
1179: PVX_UTILITY_PVT.debug_message('- In Complete_Rec API prior to assigning program_id');
1180: END IF;
1181:
1182: -- program_benefits_id
1183: -- IF p_prgm_benefits_rec.program_benefits_id = FND_API.g_miss_num THEN

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

1298:
1299: -- Debug Message
1300: IF (PV_DEBUG_HIGH_ON) THEN
1301:
1302: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - start');
1303: END IF;
1304:
1305: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1306: -- Debug message

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

1305: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1306: -- Debug message
1307: IF (PV_DEBUG_HIGH_ON) THEN
1308:
1309: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - prior to Check_Items call');
1310: END IF;
1311:
1312: Check_Items(
1313: p_prgm_benefits_rec => p_prgm_benefits_rec

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

1317:
1318: -- Debug message
1319: IF (PV_DEBUG_HIGH_ON) THEN
1320:
1321: PVX_UTILITY_PVT.debug_message(' Private API: ' || l_full_name || ' - return status after Check_Items call ' || x_return_status);
1322: END IF;
1323:
1324: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1325: RAISE FND_API.G_EXC_ERROR;

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

1348:
1349: -- Debug Message
1350: IF (PV_DEBUG_HIGH_ON) THEN
1351:
1352: PVX_UTILITY_PVT.debug_message('Private API: ' || l_full_name || ' - end');
1353: END IF;
1354:
1355: -- Standard call to get message count and if count is 1, get message info.
1356: FND_MSG_PUB.Count_And_Get