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_ATTRIBUTE_USAGE_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 120: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Attribute_Usage');

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

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

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

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

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

Line 209: WHEN PVX_Utility_PVT.resource_locked THEN

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

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

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

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

296: END IF;
297:
298: -- Debug Message
299: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
300: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
301: END IF;
302:
303:
304: -- Initialize API return status to SUCCESS

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

305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306:
307: -- Debug Message
308: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
309: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');
310: END IF;
311:
312: OPEN c_get_Attribute_Usage( l_tar_attribute_usage_rec.attribute_usage_id);
313:

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

324: RAISE FND_API.G_EXC_ERROR;
325: END IF;
326: -- Debug Message
327: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
328: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Close Cursor');
329: END IF;
330:
331: CLOSE c_get_Attribute_Usage;
332:

Line 359: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Attribute_Usage');

355: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
356: THEN
357: -- Debug message
358: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
359: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Attribute_Usage');
360: END IF;
361:
362: -- Invoke validation procedures
363: Validate_attribute_usage(

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

378: END IF;
379:
380:
381: -- Debug Message
382: --PVX_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'Private API: Calling update table handler');
383: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
384: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
385: END IF;
386:

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

380:
381: -- Debug Message
382: --PVX_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'Private API: Calling update table handler');
383: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
384: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
385: END IF;
386:
387: -- Invoke table handler(PV_ATTRIBUTE_USAGES_PKG.Update_Row)
388: PV_ATTRIBUTE_USAGES_PKG.Update_Row(

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

417:
418:
419: -- Debug Message
420: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
421: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
422: END IF;
423:
424: -- Standard call to get message count and if count is 1, get message info.
425: FND_MSG_PUB.Count_And_Get

Line 431: WHEN PVX_Utility_PVT.resource_locked THEN

427: p_data => x_msg_data
428: );
429: EXCEPTION
430: /*
431: WHEN PVX_Utility_PVT.resource_locked THEN
432: x_return_status := FND_API.g_ret_sts_error;
433: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
434: */
435: WHEN FND_API.G_EXC_ERROR THEN

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

429: EXCEPTION
430: /*
431: WHEN PVX_Utility_PVT.resource_locked THEN
432: x_return_status := FND_API.g_ret_sts_error;
433: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
434: */
435: WHEN FND_API.G_EXC_ERROR THEN
436: ROLLBACK TO UPDATE_Attribute_Usage_PVT;
437: x_return_status := FND_API.G_RET_STS_ERROR;

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

508: END IF;
509:
510: -- Debug Message
511: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
512: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
513: END IF;
514:
515:
516: -- Initialize API return status to SUCCESS

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

520: -- Api body
521: --
522: -- Debug Message
523: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
524: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');
525: END IF;
526:
527:
528: -- Invoke table handler(PV_ATTRIBUTE_USAGES_PKG.Delete_Row)

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

540:
541:
542: -- Debug Message
543: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
544: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
545: END IF;
546:
547: -- Standard call to get message count and if count is 1, get message info.
548: FND_MSG_PUB.Count_And_Get

Line 554: WHEN PVX_Utility_PVT.resource_locked THEN

550: p_data => x_msg_data
551: );
552: EXCEPTION
553: /*
554: WHEN PVX_Utility_PVT.resource_locked THEN
555: x_return_status := FND_API.g_ret_sts_error;
556: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
557: */
558: WHEN FND_API.G_EXC_ERROR THEN

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

552: EXCEPTION
553: /*
554: WHEN PVX_Utility_PVT.resource_locked THEN
555: x_return_status := FND_API.g_ret_sts_error;
556: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
557: */
558: WHEN FND_API.G_EXC_ERROR THEN
559: ROLLBACK TO DELETE_Attribute_Usage_PVT;
560: x_return_status := FND_API.G_RET_STS_ERROR;

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

621: BEGIN
622:
623: -- Debug Message
624: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
625: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
626: END IF;
627:
628: -- Initialize message list if p_init_msg_list is set to TRUE.
629: IF FND_API.to_Boolean( p_init_msg_list )

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

646:
647:
648: ------------------------ lock -------------------------
649: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
650: PVX_Utility_PVT.debug_message(l_full_name||': start');
651: END IF;
652: OPEN c_Attribute_Usage;
653:
654: FETCH c_Attribute_Usage INTO l_ATTRIBUTE_USAGE_ID;

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

671: p_encoded => FND_API.g_false,
672: p_count => x_msg_count,
673: p_data => x_msg_data);
674: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
675: PVX_Utility_PVT.debug_message(l_full_name ||': end');
676: END IF;
677: EXCEPTION
678: /*
679: WHEN PVX_Utility_PVT.resource_locked THEN

Line 679: WHEN PVX_Utility_PVT.resource_locked THEN

675: PVX_Utility_PVT.debug_message(l_full_name ||': end');
676: END IF;
677: EXCEPTION
678: /*
679: WHEN PVX_Utility_PVT.resource_locked THEN
680: x_return_status := FND_API.g_ret_sts_error;
681: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
682: */
683: WHEN FND_API.G_EXC_ERROR THEN

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

677: EXCEPTION
678: /*
679: WHEN PVX_Utility_PVT.resource_locked THEN
680: x_return_status := FND_API.g_ret_sts_error;
681: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
682: */
683: WHEN FND_API.G_EXC_ERROR THEN
684: ROLLBACK TO LOCK_Attribute_Usage_PVT;
685: x_return_status := FND_API.G_RET_STS_ERROR;

Line 729: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

725:
726: BEGIN
727: x_return_status := FND_API.g_ret_sts_success;
728: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
729: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
730: 'PV_ATTRIBUTE_USAGES',
731: 'ATTRIBUTE_USAGE_ID = ''' || p_attribute_usage_rec.ATTRIBUTE_USAGE_ID ||''''
732: );
733: ELSE

Line 734: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

730: 'PV_ATTRIBUTE_USAGES',
731: 'ATTRIBUTE_USAGE_ID = ''' || p_attribute_usage_rec.ATTRIBUTE_USAGE_ID ||''''
732: );
733: ELSE
734: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
735: 'PV_ATTRIBUTE_USAGES',
736: 'ATTRIBUTE_USAGE_ID = ''' || p_attribute_usage_rec.ATTRIBUTE_USAGE_ID ||
737: ''' AND ATTRIBUTE_USAGE_ID <> ' || p_attribute_usage_rec.ATTRIBUTE_USAGE_ID
738: );

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

1256:
1257:
1258: -- Debug Message
1259: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1260: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
1261: END IF;
1262:
1263: -- Initialize API return status to SUCCESS
1264: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1265:
1266:
1267: -- Debug Message
1268: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1269: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1270: END IF;
1271:
1272: -- Standard call to get message count and if count is 1, get message info.
1273: FND_MSG_PUB.Count_And_Get

Line 1279: WHEN PVX_Utility_PVT.resource_locked THEN

1275: p_data => x_msg_data
1276: );
1277: EXCEPTION
1278: /*
1279: WHEN PVX_Utility_PVT.resource_locked THEN
1280: x_return_status := FND_API.g_ret_sts_error;
1281: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1282: */
1283: WHEN FND_API.G_EXC_ERROR THEN

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

1277: EXCEPTION
1278: /*
1279: WHEN PVX_Utility_PVT.resource_locked THEN
1280: x_return_status := FND_API.g_ret_sts_error;
1281: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1282: */
1283: WHEN FND_API.G_EXC_ERROR THEN
1284: ROLLBACK TO VALIDATE_Attribute_Usage;
1285: x_return_status := FND_API.G_RET_STS_ERROR;

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

1342: -- x_return_status := FND_API.G_RET_STS_ERROR;
1343:
1344: -- Debug Message
1345: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1346: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1347: END IF;
1348: -- Standard call to get message count and if count is 1, get message info.
1349: FND_MSG_PUB.Count_And_Get
1350: (p_count => x_msg_count,