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

Line 111: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || ' start');

107: END IF;
108:
109: -- Debug Message
110: IF (PV_DEBUG_HIGH_ON) THEN
111: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || ' start');
112: END IF;
113:
114: -- Initialize API return status to SUCCESS
115: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 123: PVX_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

119: -- =========================================================================
120:
121: IF FND_GLOBAL.USER_ID IS NULL
122: THEN
123: PVX_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
124: RAISE FND_API.G_EXC_ERROR;
125: END IF;
126:
127: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 131: PVX_Utility_PVT.debug_message('Private API: Validate_Tap_Access_Terrs');

127: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
128: THEN
129: -- Debug Message
130: IF (PV_DEBUG_HIGH_ON) THEN
131: PVX_Utility_PVT.debug_message('Private API: Validate_Tap_Access_Terrs');
132: END IF;
133:
134: -- Invoke validation procedures
135: Validate_Tap_Access_Terrs(

Line 157: PVX_Utility_PVT.debug_message( 'Private API: Calling create table handler');

153: l_terr_id := p_tap_access_terrs_rec.terr_id;
154:
155: -- Debug Message
156: IF (PV_DEBUG_HIGH_ON) THEN
157: PVX_Utility_PVT.debug_message( 'Private API: Calling create table handler');
158: END IF;
159:
160: -- Invoke table handler(Pv_Territory_Accesses_Pkg.Insert_Row)
161: Pv_Tap_Access_Terrs_Pkg.Insert_Row(

Line 200: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || 'end');

196:
197:
198: -- Debug Message
199: IF (PV_DEBUG_HIGH_ON) THEN
200: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || 'end');
201: END IF;
202:
203: -- Standard call to get message count and if count is 1, get message info.
204: FND_MSG_PUB.Count_And_Get

Line 210: WHEN PVX_Utility_PVT.resource_locked THEN

206: p_data => x_msg_data
207: );
208:
209: EXCEPTION
210: WHEN PVX_Utility_PVT.resource_locked THEN
211: x_return_status := FND_API.g_ret_sts_error;
212: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
213:
214: WHEN FND_API.G_EXC_ERROR THEN

Line 212: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

208:
209: EXCEPTION
210: WHEN PVX_Utility_PVT.resource_locked THEN
211: x_return_status := FND_API.g_ret_sts_error;
212: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
213:
214: WHEN FND_API.G_EXC_ERROR THEN
215: ROLLBACK TO Create_Tap_Access_Terrs_Pvt;
216: x_return_status := FND_API.G_RET_STS_ERROR;

Line 339: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || ' Start');

335:
336:
337: -- Debug Message
338: IF (PV_DEBUG_HIGH_ON) THEN
339: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || ' Start');
340: END IF;
341:
342: -- Initialize API return status to SUCCESS
343: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

343: x_return_status := FND_API.G_RET_STS_SUCCESS;
344:
345: -- Debug Message
346: IF (PV_DEBUG_HIGH_ON) THEN
347: PVX_Utility_PVT.debug_message('Private API: - Open Cursor to Select');
348: END IF;
349:
350: OPEN c_get_Territory_Accesses(
351: l_tar_tap_access_terrs_rec.partner_access_id ,

Line 357: PVX_Utility_PVT.Error_Message(

353:
354: FETCH c_get_Territory_Accesses INTO l_ref_territory_access_rec ;
355:
356: IF ( c_get_Territory_Accesses%NOTFOUND) THEN
357: PVX_Utility_PVT.Error_Message(
358: p_message_name => 'API_MISSING_UPDATE_TARGET',
359: p_token_name => 'INFO',
360: p_token_value => 'Territory_Accesses') ;
361:

Line 367: PVX_Utility_PVT.debug_message('Private API: - Close Cursor c_get_Territory_Accesses;');

363: END IF;
364:
365: -- Debug Message
366: IF (PV_DEBUG_HIGH_ON) THEN
367: PVX_Utility_PVT.debug_message('Private API: - Close Cursor c_get_Territory_Accesses;');
368: END IF;
369:
370: CLOSE c_get_Territory_Accesses;
371:

Line 374: PVX_Utility_PVT.Error_Message(

370: CLOSE c_get_Territory_Accesses;
371:
372: If (l_tar_tap_access_terrs_rec.object_version_number is NULL or
373: l_tar_tap_access_terrs_rec.object_version_number = FND_API.G_MISS_NUM ) Then
374: PVX_Utility_PVT.Error_Message(
375: p_message_name => 'API_VERSION_MISSING',
376: p_token_name => 'COLUMN',
377: p_token_value => 'OBJECT_VERSION_NUMBER') ;
378: raise FND_API.G_EXC_ERROR;

Line 383: PVX_Utility_PVT.Error_Message(

379: End if;
380:
381: -- Check Whether record has been changed by someone else
382: If (l_tar_tap_access_terrs_rec.object_version_number <> l_ref_territory_access_rec.object_version_number) Then
383: PVX_Utility_PVT.Error_Message(
384: p_message_name => 'API_RECORD_CHANGED',
385: p_token_name => 'INFO',
386: p_token_value => 'Territory_Accesses') ;
387: raise FND_API.G_EXC_ERROR;

Line 394: PVX_Utility_PVT.debug_message('Private API: Validate_Territory_Accesses');

390: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
391: THEN
392: -- Debug Message
393: IF (PV_DEBUG_HIGH_ON) THEN
394: PVX_Utility_PVT.debug_message('Private API: Validate_Territory_Accesses');
395: END IF;
396:
397: -- Invoke validation procedures
398: Validate_Tap_Access_Terrs(

Line 416: PVX_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

412:
413:
414: -- Debug Message
415: IF (PV_DEBUG_HIGH_ON) THEN
416: PVX_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
417: END IF;
418:
419: -- Invoke table handler(Pv_Territory_Accesses_Pkg.Update_Row)
420: Pv_Tap_Access_Terrs_Pkg.Update_Row(

Line 457: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || ' End');

453:
454:
455: -- Debug Message
456: IF (PV_DEBUG_HIGH_ON) THEN
457: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || ' End');
458: END IF;
459:
460: -- Standard call to get message count and if count is 1, get message info.
461: FND_MSG_PUB.Count_And_Get

Line 467: WHEN PVX_Utility_PVT.resource_locked THEN

463: p_data => x_msg_data
464: );
465: EXCEPTION
466:
467: WHEN PVX_Utility_PVT.resource_locked THEN
468: x_return_status := FND_API.g_ret_sts_error;
469: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
470:
471: WHEN FND_API.G_EXC_ERROR THEN

Line 469: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

465: EXCEPTION
466:
467: WHEN PVX_Utility_PVT.resource_locked THEN
468: x_return_status := FND_API.g_ret_sts_error;
469: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
470:
471: WHEN FND_API.G_EXC_ERROR THEN
472: ROLLBACK TO Update_Tap_Access_Terrs_Pvt;
473: x_return_status := FND_API.G_RET_STS_ERROR;

Line 584: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || ' Start');

580: END IF;
581:
582: -- Debug Message
583: IF (PV_DEBUG_HIGH_ON) THEN
584: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || ' Start');
585: END IF;
586:
587: -- Initialize API return status to SUCCESS
588: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 596: PVX_Utility_PVT.debug_message( 'Private API: Calling delete table handler');

592: --
593:
594: -- Debug Message
595: IF (PV_DEBUG_HIGH_ON) THEN
596: PVX_Utility_PVT.debug_message( 'Private API: Calling delete table handler');
597: END IF;
598:
599: -- Invoke table handler(Pv_Territory_Accesses_Pkg.Delete_Row)
600:

Line 631: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || ' End');

627: END IF;
628:
629: -- Debug Message
630: IF (PV_DEBUG_HIGH_ON) THEN
631: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || ' End');
632: END IF;
633:
634: -- Standard call to get message count and if count is 1, get message info.
635: FND_MSG_PUB.Count_And_Get

Line 641: WHEN PVX_Utility_PVT.resource_locked THEN

637: p_data => x_msg_data
638: );
639: EXCEPTION
640:
641: WHEN PVX_Utility_PVT.resource_locked THEN
642: x_return_status := FND_API.g_ret_sts_error;
643: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
644:
645: WHEN FND_API.G_EXC_ERROR THEN

Line 643: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

639: EXCEPTION
640:
641: WHEN PVX_Utility_PVT.resource_locked THEN
642: x_return_status := FND_API.g_ret_sts_error;
643: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
644:
645: WHEN FND_API.G_EXC_ERROR THEN
646: ROLLBACK TO DELETE_Territory_Accesses_Pvt;
647: x_return_status := FND_API.G_RET_STS_ERROR;

Line 744: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || 'start');

740: SAVEPOINT Lock_Tap_Access_Terrs;
741:
742: -- Debug Message
743: IF (PV_DEBUG_HIGH_ON) THEN
744: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || 'start');
745: END IF;
746:
747: -- Initialize message list if p_init_msg_list is set to TRUE.
748: IF FND_API.to_Boolean( p_init_msg_list )

Line 792: PVX_Utility_PVT.debug_message(l_full_name ||': End');

788: p_data => x_msg_data);
789:
790: -- Debug Message
791: IF (PV_DEBUG_HIGH_ON) THEN
792: PVX_Utility_PVT.debug_message(l_full_name ||': End');
793: END IF;
794: EXCEPTION
795: WHEN PVX_Utility_PVT.resource_locked THEN
796: x_return_status := FND_API.g_ret_sts_error;

Line 795: WHEN PVX_Utility_PVT.resource_locked THEN

791: IF (PV_DEBUG_HIGH_ON) THEN
792: PVX_Utility_PVT.debug_message(l_full_name ||': End');
793: END IF;
794: EXCEPTION
795: WHEN PVX_Utility_PVT.resource_locked THEN
796: x_return_status := FND_API.g_ret_sts_error;
797: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
798:
799: WHEN FND_API.G_EXC_ERROR THEN

Line 797: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

793: END IF;
794: EXCEPTION
795: WHEN PVX_Utility_PVT.resource_locked THEN
796: x_return_status := FND_API.g_ret_sts_error;
797: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
798:
799: WHEN FND_API.G_EXC_ERROR THEN
800: ROLLBACK TO Lock_Tap_Access_Terrs;
801: x_return_status := FND_API.G_RET_STS_ERROR;

Line 862: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_DUPLICATE_ID');

858: p_tap_access_terrs_rec.terr_id);
859: FETCH l_Chk_Terr_Access_Uk_csr INTO l_valid_flag;
860: IF (l_Chk_Terr_Access_Uk_csr%FOUND) THEN
861: CLOSE l_Chk_Terr_Access_Uk_csr;
862: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_DUPLICATE_ID');
863: x_return_status := FND_API.g_ret_sts_error;
864: ELSE
865: CLOSE l_Chk_Terr_Access_Uk_csr;
866: END IF;

Line 884: PVX_Utility_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ACCESS_ID' );

880: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
881:
882: -- Check for required paramter PARTNER_ACCESS_ID.
883: IF p_tap_access_terrs_rec.partner_access_id = FND_API.G_MISS_NUM OR p_tap_access_terrs_rec.partner_access_id IS NULL THEN
884: PVX_Utility_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ACCESS_ID' );
885: x_return_status := FND_API.g_ret_sts_error;
886: END IF;
887:
888: -- Check for required paramter TERR_ID.

Line 890: PVX_Utility_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'TERR_ID' );

886: END IF;
887:
888: -- Check for required paramter TERR_ID.
889: IF p_tap_access_terrs_rec.terr_id = FND_API.G_MISS_NUM OR p_tap_access_terrs_rec.terr_id IS NULL THEN
890: PVX_Utility_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'TERR_ID' );
891: x_return_status := FND_API.g_ret_sts_error;
892: END IF;
893:
894: ELSE

Line 898: PVX_Utility_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ACCESS_ID' );

894: ELSE
895:
896: -- Check for required paramter PARTNER_ACCESS_ID.
897: IF p_tap_access_terrs_rec.partner_access_id = FND_API.G_MISS_NUM THEN
898: PVX_Utility_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'PARTNER_ACCESS_ID' );
899: x_return_status := FND_API.g_ret_sts_error;
900: END IF;
901:
902: -- Check for required paramter TERR_ID.

Line 904: PVX_Utility_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'TERR_ID' );

900: END IF;
901:
902: -- Check for required paramter TERR_ID.
903: IF p_tap_access_terrs_rec.terr_id = FND_API.G_MISS_NUM THEN
904: PVX_Utility_PVT.Error_Message('PV_API_MISSING_REQ_COLUMN', 'COLUMN', 'TERR_ID' );
905: x_return_status := FND_API.g_ret_sts_error;
906: END IF;
907:
908: END IF;

Line 943: PVX_UTILITY_PVT.Error_Message('PV_NO_RECORD_FOUND');

939: FETCH l_chk_paccess_active_csr INTO l_paccess_exist;
940:
941: IF l_chk_paccess_active_csr%NOTFOUND THEN
942: CLOSE l_chk_paccess_active_csr ;
943: PVX_UTILITY_PVT.Error_Message('PV_NO_RECORD_FOUND');
944: x_return_status := FND_API.g_ret_sts_error;
945: ELSE
946: CLOSE l_chk_paccess_active_csr ;
947: END IF;

Line 954: PVX_UTILITY_PVT.Error_Message('PV_TERR_NOT_ACTIVE','TERR_ID',p_tap_access_terrs_rec.terr_id);

950: OPEN l_chk_terr_active_csr(p_tap_access_terrs_rec.terr_id);
951: FETCH l_chk_terr_active_csr INTO l_paccess_exist;
952: IF l_chk_terr_active_csr%NOTFOUND THEN
953: CLOSE l_chk_terr_active_csr ;
954: PVX_UTILITY_PVT.Error_Message('PV_TERR_NOT_ACTIVE','TERR_ID',p_tap_access_terrs_rec.terr_id);
955: x_return_status := FND_API.g_ret_sts_error;
956: ELSE
957: CLOSE l_chk_terr_active_csr;
958: END IF;

Line 1188: PVX_Utility_PVT.debug_message('After Validate_Tap_Access_Terrs_Rec...');

1184: x_msg_data => x_msg_data,
1185: p_tap_access_terrs_rec => l_tap_access_terrs_rec);
1186:
1187: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1188: PVX_Utility_PVT.debug_message('After Validate_Tap_Access_Terrs_Rec...');
1189: END IF;
1190:
1191: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1192: RAISE FND_API.G_EXC_ERROR;

Line 1199: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || 'end');

1195: END IF;
1196: END IF;
1197:
1198: -- Debug Message
1199: PVX_Utility_PVT.debug_message('Private API: ' || l_api_name || 'end');
1200:
1201: -- Standard call to get message count and if count is 1, get message info.
1202: FND_MSG_PUB.Count_And_Get
1203: (p_count => x_msg_count,

Line 1208: WHEN PVX_Utility_PVT.resource_locked THEN

1204: p_data => x_msg_data
1205: );
1206: EXCEPTION
1207:
1208: WHEN PVX_Utility_PVT.resource_locked THEN
1209: x_return_status := FND_API.g_ret_sts_error;
1210: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1211:
1212: WHEN FND_API.G_EXC_ERROR THEN

Line 1210: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1206: EXCEPTION
1207:
1208: WHEN PVX_Utility_PVT.resource_locked THEN
1209: x_return_status := FND_API.g_ret_sts_error;
1210: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1211:
1212: WHEN FND_API.G_EXC_ERROR THEN
1213: ROLLBACK TO Validate_Tap_Access_Terrs_Pvt;
1214: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1273: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');

1269: -- THEN
1270: -- x_return_status := FND_API.G_RET_STS_ERROR;
1271:
1272: -- Debug Message
1273: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1274: -- Standard call to get message count and if count is 1, get message info.
1275: FND_MSG_PUB.Count_And_Get
1276: (p_count => x_msg_count,
1277: p_data => x_msg_data