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

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

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

Line 155: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ptr_Enr_Temp_Appr');

151: THEN
152: -- Debug message
153: IF (PV_DEBUG_HIGH_ON) THEN
154:
155: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ptr_Enr_Temp_Appr');
156: END IF;
157:
158: -- Invoke validation procedures
159: Validate_ptr_enr_temp_appr(

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

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

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

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

Line 244: WHEN PVX_UTILITY_PVT.resource_locked THEN

240: p_data => x_msg_data
241: );
242: EXCEPTION
243:
244: WHEN PVX_UTILITY_PVT.resource_locked THEN
245: x_return_status := FND_API.g_ret_sts_error;
246: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
247: FND_MSG_PUB.Add;
248:

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

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

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

382:
383: -- Debug Message
384: IF (PV_DEBUG_HIGH_ON) THEN
385:
386: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
387: END IF;
388:
389: OPEN c_get_Ptr_Enr_Temp_Appr( l_tar_approver_rec.entity_approver_id);
390:

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

392:
393: If ( c_get_Ptr_Enr_Temp_Appr%NOTFOUND) THEN
394:
395: --kvattiku: Oct 27, 05 Commented out and replacing it with FND_MSG calls
396: --PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
397: -- p_token_name => 'INFO',
398: -- p_token_value => 'Ptr_Enr_Temp_Appr') ;
399: --RAISE FND_API.G_EXC_ERROR;
400:

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

407:
408: -- Debug Message
409: IF (PV_DEBUG_HIGH_ON) THEN
410:
411: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');
412: END IF;
413: CLOSE c_get_Ptr_Enr_Temp_Appr;
414:
415:

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

417: l_tar_approver_rec.object_version_number = FND_API.G_MISS_NUM )
418: Then
419:
420: --kvattiku: Oct 27, 05 Commented out and replacing it with FND_MSG calls
421: --PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
422: -- p_token_name => 'COLUMN',
423: -- p_token_value => 'Last_Update_Date') ;
424: --raise FND_API.G_EXC_ERROR;
425:

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

434: If (l_tar_approver_rec.object_version_number <> l_ref_approver_rec.object_version_number)
435: Then
436:
437: --kvattiku: Oct 27, 05 Commented out and replacing it with FND_MSG calls
438: --PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
439: -- p_token_name => 'INFO',
440: -- p_token_value => 'Ptr_Enr_Temp_Appr') ;
441: --raise FND_API.G_EXC_ERROR;
442:

Line 457: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ptr_Enr_Temp_Appr');

453: THEN
454: -- Debug message
455: IF (PV_DEBUG_HIGH_ON) THEN
456:
457: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ptr_Enr_Temp_Appr');
458: END IF;
459:
460: -- Invoke validation procedures
461: Validate_ptr_enr_temp_appr(

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

476:
477: -- Debug Message
478: IF (PV_DEBUG_HIGH_ON) THEN
479:
480: PVX_UTILITY_PVT.debug_message( 'Private API: Calling update table handler');
481: END IF;
482:
483: -- Invoke table handler(Pv_Ge_Temp_Approvers_Pkg.Update_Row)
484: Pv_Ge_Temp_Approvers_Pkg.Update_Row(

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

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

Line 521: WHEN PVX_Utility_PVT.API_RECORD_CHANGED THEN

517: (p_count => x_msg_count,
518: p_data => x_msg_data
519: );
520: EXCEPTION
521: WHEN PVX_Utility_PVT.API_RECORD_CHANGED THEN
522: x_return_status := Fnd_Api.G_RET_STS_ERROR;
523: IF (PV_DEBUG_HIGH_ON) THEN
524: Pvx_Utility_Pvt.debug_message('PRIVATE API: - OPEN CURSOR');
525: END IF;

Line 524: Pvx_Utility_Pvt.debug_message('PRIVATE API: - OPEN CURSOR');

520: EXCEPTION
521: WHEN PVX_Utility_PVT.API_RECORD_CHANGED THEN
522: x_return_status := Fnd_Api.G_RET_STS_ERROR;
523: IF (PV_DEBUG_HIGH_ON) THEN
524: Pvx_Utility_Pvt.debug_message('PRIVATE API: - OPEN CURSOR');
525: END IF;
526: OPEN c_get_Ptr_Enr_Temp_Appr( l_tar_approver_rec.entity_approver_id);
527: FETCH c_get_Ptr_Enr_Temp_Appr INTO l_ref_approver_rec ;
528: If ( c_get_Ptr_Enr_Temp_Appr%NOTFOUND) THEN

Line 535: Pvx_Utility_Pvt.debug_message('PRIVATE API: - CLOSE CURSOR');

531: FND_MSG_PUB.Add;
532: END IF;
533: -- Debug Message
534: IF (PV_DEBUG_HIGH_ON) THEN
535: Pvx_Utility_Pvt.debug_message('PRIVATE API: - CLOSE CURSOR');
536: END IF;
537: CLOSE c_get_Ptr_Enr_Temp_Appr;
538: If (l_tar_approver_rec.object_version_number <> l_ref_approver_rec.object_version_number) THEN
539: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 550: WHEN PVX_UTILITY_PVT.resource_locked THEN

546: p_count => x_msg_count,
547: p_data => x_msg_data
548: );
549:
550: WHEN PVX_UTILITY_PVT.resource_locked THEN
551:
552: --kvattiku: Oct 27, 05 Commented out and replacing it with FND_MSG calls
553: --x_return_status := FND_API.g_ret_sts_error;
554: --PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

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

550: WHEN PVX_UTILITY_PVT.resource_locked THEN
551:
552: --kvattiku: Oct 27, 05 Commented out and replacing it with FND_MSG calls
553: --x_return_status := FND_API.g_ret_sts_error;
554: --PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
555:
556: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
557: FND_MSG_PUB.Add;
558: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

689: --
690: -- Debug Message
691: IF (PV_DEBUG_HIGH_ON) THEN
692:
693: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
694: END IF;
695:
696: -- Invoke table handler(Pv_Ge_Temp_Approvers_Pkg.Delete_Row)
697: Pv_Ge_Temp_Approvers_Pkg.Delete_Row(

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

710:
711: -- Debug Message
712: IF (PV_DEBUG_HIGH_ON) THEN
713:
714: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
715: END IF;
716:
717:
718: -- Standard call to get message count and if count is 1, get message info.

Line 725: WHEN PVX_UTILITY_PVT.resource_locked THEN

721: p_data => x_msg_data
722: );
723: EXCEPTION
724:
725: WHEN PVX_UTILITY_PVT.resource_locked THEN
726: x_return_status := FND_API.g_ret_sts_error;
727: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
728: FND_MSG_PUB.Add;
729:

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

820:
821: -- Debug Message
822: IF (PV_DEBUG_HIGH_ON) THEN
823:
824: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
825: END IF;
826:
827:
828: -- Initialize message list if p_init_msg_list is set to TRUE.

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

858: p_count => x_msg_count,
859: p_data => x_msg_data);
860: IF (PV_DEBUG_HIGH_ON) THEN
861:
862: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
863: END IF;
864: EXCEPTION
865:
866: WHEN PVX_UTILITY_PVT.resource_locked THEN

Line 866: WHEN PVX_UTILITY_PVT.resource_locked THEN

862: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
863: END IF;
864: EXCEPTION
865:
866: WHEN PVX_UTILITY_PVT.resource_locked THEN
867: x_return_status := FND_API.g_ret_sts_error;
868: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
869: FND_MSG_PUB.Add;
870:

Line 921: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

917: x_return_status := FND_API.g_ret_sts_success;
918: IF p_validation_mode = JTF_PLSQL_API.g_create
919: AND p_approver_rec.entity_approver_id IS NOT NULL
920: THEN
921: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
922: 'pv_ge_temp_approvers',
923: 'entity_approver_id = ''' || p_approver_rec.entity_approver_id ||''''
924: );
925: END IF;

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

1289:
1290: -- Debug Message
1291: IF (PV_DEBUG_HIGH_ON) THEN
1292:
1293: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1294: END IF;
1295:
1296:
1297:

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

1301:
1302: -- Debug Message
1303: IF (PV_DEBUG_HIGH_ON) THEN
1304:
1305: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1306: END IF;
1307:
1308:
1309: -- Standard call to get message count and if count is 1, get message info.

Line 1316: WHEN PVX_UTILITY_PVT.resource_locked THEN

1312: p_data => x_msg_data
1313: );
1314: EXCEPTION
1315:
1316: WHEN PVX_UTILITY_PVT.resource_locked THEN
1317: x_return_status := FND_API.g_ret_sts_error;
1318: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
1319: FND_MSG_PUB.Add;
1320:

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

1382:
1383: -- Debug Message
1384: IF (PV_DEBUG_HIGH_ON) THEN
1385:
1386: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1387: END IF;
1388: -- Standard call to get message count and if count is 1, get message info.
1389: FND_MSG_PUB.Count_And_Get
1390: (p_count => x_msg_count,