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

Line 80: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');

76: END IF;
77:
78: -- Debug Message
79: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
80: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
81: END IF;
82:
83: -- Initialize API return status to SUCCESS
84: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 119: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Attr_Principal');

115: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
116: THEN
117: -- Debug message
118: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
119: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Attr_Principal');
120: end if;
121:
122: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : Before Validate_Attr_Principal' );
123:

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

151:
152: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : After Validate' );
153: -- Debug Message
154: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
155: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling create table handler');
156: END IF;
157:
158: -- Invoke table handler(PV_Attr_PrincipalS_PKG.Insert_Row)
159: PV_Attr_PrincipalS_PKG.Insert_Row(

Line 192: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');

188:
189:
190: -- Debug Message
191: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
192: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
193: END IF;
194:
195: -- Standard call to get message count and if count is 1, get message info.
196: FND_MSG_PUB.Count_And_Get

Line 202: WHEN PVX_Utility_PVT.resource_locked THEN

198: p_data => x_msg_data
199: );
200: EXCEPTION
201: /*
202: WHEN PVX_Utility_PVT.resource_locked THEN
203: x_return_status := FND_API.g_ret_sts_error;
204: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
205: */
206: WHEN FND_API.G_EXC_ERROR THEN

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

200: EXCEPTION
201: /*
202: WHEN PVX_Utility_PVT.resource_locked THEN
203: x_return_status := FND_API.g_ret_sts_error;
204: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
205: */
206: WHEN FND_API.G_EXC_ERROR THEN
207: ROLLBACK TO CREATE_Attr_Principal_PVT;
208: x_return_status := FND_API.G_RET_STS_ERROR;

Line 293: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');

289: END IF;
290:
291: -- Debug Message
292: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
293: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
294: END IF;
295:
296:
297: -- Initialize API return status to SUCCESS

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

298: x_return_status := FND_API.G_RET_STS_SUCCESS;
299:
300: -- Debug Message
301: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
302: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');
303: END IF;
304:
305: OPEN c_get_Attr_Principal( l_tar_Attr_Principal_rec.Attr_Principal_id);
306:

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

317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319: -- Debug Message
320: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
321: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Close Cursor');
322: END IF;
323:
324: CLOSE c_get_Attr_Principal;
325:

Line 352: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Attr_Principal');

348: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
349: THEN
350: -- Debug message
351: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
352: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Attr_Principal');
353: END IF;
354:
355: -- Invoke validation procedures
356: Validate_Attr_Principal(

Line 375: --PVX_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'Private API: Calling update table handler');

371: END IF;
372:
373:
374: -- Debug Message
375: --PVX_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'Private API: Calling update table handler');
376: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
377: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
378: END IF;
379:

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

373:
374: -- Debug Message
375: --PVX_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'Private API: Calling update table handler');
376: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
377: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
378: END IF;
379:
380: -- Invoke table handler(PV_Attr_PrincipalS_PKG.Update_Row)
381: PV_Attr_PrincipalS_PKG.Update_Row(

Line 408: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');

404:
405:
406: -- Debug Message
407: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
408: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
409: END IF;
410:
411: -- Standard call to get message count and if count is 1, get message info.
412: FND_MSG_PUB.Count_And_Get

Line 418: WHEN PVX_Utility_PVT.resource_locked THEN

414: p_data => x_msg_data
415: );
416: EXCEPTION
417: /*
418: WHEN PVX_Utility_PVT.resource_locked THEN
419: x_return_status := FND_API.g_ret_sts_error;
420: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
421: */
422: WHEN FND_API.G_EXC_ERROR THEN

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

416: EXCEPTION
417: /*
418: WHEN PVX_Utility_PVT.resource_locked THEN
419: x_return_status := FND_API.g_ret_sts_error;
420: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
421: */
422: WHEN FND_API.G_EXC_ERROR THEN
423: ROLLBACK TO UPDATE_Attr_Principal_PVT;
424: x_return_status := FND_API.G_RET_STS_ERROR;

Line 499: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');

495: END IF;
496:
497: -- Debug Message
498: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
499: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
500: END IF;
501:
502:
503: -- Initialize API return status to SUCCESS

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

507: -- Api body
508: --
509: -- Debug Message
510: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
511: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');
512: END IF;
513:
514:
515: -- Invoke table handler(PV_Attr_PrincipalS_PKG.Delete_Row)

Line 531: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');

527:
528:
529: -- Debug Message
530: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
531: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
532: END IF;
533:
534: -- Standard call to get message count and if count is 1, get message info.
535: FND_MSG_PUB.Count_And_Get

Line 541: WHEN PVX_Utility_PVT.resource_locked THEN

537: p_data => x_msg_data
538: );
539: EXCEPTION
540: /*
541: WHEN PVX_Utility_PVT.resource_locked THEN
542: x_return_status := FND_API.g_ret_sts_error;
543: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
544: */
545: WHEN FND_API.G_EXC_ERROR THEN

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

539: EXCEPTION
540: /*
541: WHEN PVX_Utility_PVT.resource_locked THEN
542: x_return_status := FND_API.g_ret_sts_error;
543: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
544: */
545: WHEN FND_API.G_EXC_ERROR THEN
546: ROLLBACK TO DELETE_Attr_Principal_PVT;
547: x_return_status := FND_API.G_RET_STS_ERROR;

Line 612: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');

608: BEGIN
609:
610: -- Debug Message
611: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
612: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
613: END IF;
614:
615: -- Initialize message list if p_init_msg_list is set to TRUE.
616: IF FND_API.to_Boolean( p_init_msg_list )

Line 637: PVX_Utility_PVT.debug_message(l_full_name||': start');

633:
634:
635: ------------------------ lock -------------------------
636: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
637: PVX_Utility_PVT.debug_message(l_full_name||': start');
638: END IF;
639: OPEN c_Attr_Principal;
640:
641: FETCH c_Attr_Principal INTO l_Attr_Principal_ID;

Line 662: PVX_Utility_PVT.debug_message(l_full_name ||': end');

658: p_encoded => FND_API.g_false,
659: p_count => x_msg_count,
660: p_data => x_msg_data);
661: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
662: PVX_Utility_PVT.debug_message(l_full_name ||': end');
663: END IF;
664: EXCEPTION
665: /*
666: WHEN PVX_Utility_PVT.resource_locked THEN

Line 666: WHEN PVX_Utility_PVT.resource_locked THEN

662: PVX_Utility_PVT.debug_message(l_full_name ||': end');
663: END IF;
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 => 'PV_API_RESOURCE_LOCKED');
669: */
670: WHEN FND_API.G_EXC_ERROR THEN

Line 668: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_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 => 'PV_API_RESOURCE_LOCKED');
669: */
670: WHEN FND_API.G_EXC_ERROR THEN
671: ROLLBACK TO LOCK_Attr_Principal_PVT;
672: x_return_status := FND_API.G_RET_STS_ERROR;

Line 716: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

712:
713: BEGIN
714: x_return_status := FND_API.g_ret_sts_success;
715: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
716: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
717: 'PV_Attr_PrincipalS',
718: 'Attr_Principal_ID = ''' || p_Attr_Principal_rec.Attr_Principal_ID ||''''
719: );
720: ELSE

Line 721: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

717: 'PV_Attr_PrincipalS',
718: 'Attr_Principal_ID = ''' || p_Attr_Principal_rec.Attr_Principal_ID ||''''
719: );
720: ELSE
721: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
722: 'PV_Attr_PrincipalS',
723: 'Attr_Principal_ID = ''' || p_Attr_Principal_rec.Attr_Principal_ID ||
724: ''' AND Attr_Principal_ID <> ' || p_Attr_Principal_rec.Attr_Principal_ID
725: );

Line 1154: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');

1150:
1151:
1152: -- Debug Message
1153: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1154: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
1155: END IF;
1156:
1157: -- Initialize API return status to SUCCESS
1158: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1163: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');

1159:
1160:
1161: -- Debug Message
1162: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1163: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1164: END IF;
1165:
1166: -- Standard call to get message count and if count is 1, get message info.
1167: FND_MSG_PUB.Count_And_Get

Line 1173: WHEN PVX_Utility_PVT.resource_locked THEN

1169: p_data => x_msg_data
1170: );
1171: EXCEPTION
1172: /*
1173: WHEN PVX_Utility_PVT.resource_locked THEN
1174: x_return_status := FND_API.g_ret_sts_error;
1175: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1176: */
1177: WHEN FND_API.G_EXC_ERROR THEN

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

1171: EXCEPTION
1172: /*
1173: WHEN PVX_Utility_PVT.resource_locked THEN
1174: x_return_status := FND_API.g_ret_sts_error;
1175: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1176: */
1177: WHEN FND_API.G_EXC_ERROR THEN
1178: ROLLBACK TO VALIDATE_Attr_Principal;
1179: x_return_status := FND_API.G_RET_STS_ERROR;

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

1236: -- x_return_status := FND_API.G_RET_STS_ERROR;
1237:
1238: -- Debug Message
1239: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1240: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1241: END IF;
1242: -- Standard call to get message count and if count is 1, get message info.
1243: FND_MSG_PUB.Count_And_Get
1244: (p_count => x_msg_count,