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

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

95: END IF;
96:
97: -- Debug Message
98: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
99: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
100: END IF;
101:
102:
103: -- Initialize API return status to SUCCESS

Line 158: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_attr_value');

154: if ( p_enty_attr_val_rec.entity <> 'ENRQ')
155: then
156: -- Debug message
157: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
158: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_attr_value');
159: END IF;
160:
161: -- Invoke validation procedures
162: Validate_attr_value(

Line 203: PVX_Utility_PVT.debug_message(l_full_name ||': l_already_exists ' || l_already_exists);

199: l_already_exists := 'Y';
200:
201: end loop;
202:
203: PVX_Utility_PVT.debug_message(l_full_name ||': l_already_exists ' || l_already_exists);
204:
205: if(l_already_exists = 'Y'
206: and not (l_attribute_type = 'DROPDOWN'
207: and l_DISPLAY_STYLE in ('EXTERNAL_LOV','MULTI','CHECK','PERCENTAGE')

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

236: end if;
237:
238:
239: -- Debug Message
240: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling create table handler');
241:
242: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Insert_Row)
243: PV_ENTY_ATTR_VALUES_PKG.Insert_Row(
244: px_enty_attr_val_id => l_enty_attr_val_rec.enty_attr_val_id

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

282:
283:
284: -- Debug Message
285: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
286: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
287: END IF;
288:
289: -- Standard call to get message count and if count is 1, get message info.
290: FND_MSG_PUB.Count_And_Get (

Line 297: WHEN PVX_Utility_PVT.resource_locked THEN

293: );
294:
295: EXCEPTION
296: /*
297: WHEN PVX_Utility_PVT.resource_locked THEN
298: x_return_status := FND_API.g_ret_sts_error;
299: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
300: */
301: WHEN FND_API.G_EXC_ERROR THEN

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

295: EXCEPTION
296: /*
297: WHEN PVX_Utility_PVT.resource_locked THEN
298: x_return_status := FND_API.g_ret_sts_error;
299: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
300: */
301: WHEN FND_API.G_EXC_ERROR THEN
302: ROLLBACK TO Create_Attr_Value_PVT;
303: x_return_status := FND_API.G_RET_STS_ERROR;

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

386: END IF;
387:
388: -- Debug Message
389: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
390: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
391: END IF;
392:
393: -- Initialize API return status to SUCCESS
394: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

394: x_return_status := FND_API.G_RET_STS_SUCCESS;
395:
396: -- Debug Message
397: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
398: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');
399: END IF;
400:
401: OPEN c_get_Enty_Attr_Value( l_tar_enty_attr_val_rec.enty_attr_val_id);
402:

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

414: END IF;
415:
416: -- Debug Message
417: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
418: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Close Cursor');
419: END IF;
420: CLOSE c_get_Enty_Attr_Value;
421:
422:

Line 450: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_attr_value');

446: if(p_enty_attr_val_rec.entity <> 'ENRQ')
447: then
448: -- Debug message
449: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
450: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_attr_value');
451: END IF;
452:
453: -- Invoke validation procedures
454: Validate_attr_value(

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

471:
472:
473: -- Debug Message
474: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
475: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
476: END IF;
477:
478: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Update_Row)
479: PV_ENTY_ATTR_VALUES_PKG.Update_Row(

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

510: END IF;
511:
512: -- Debug Message
513: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
514: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
515: END IF;
516: -- Standard call to get message count and if count is 1, get message info.
517: FND_MSG_PUB.Count_And_Get (
518: p_count => x_msg_count

Line 523: WHEN PVX_Utility_PVT.resource_locked THEN

519: ,p_data => x_msg_data
520: );
521: EXCEPTION
522: /*
523: WHEN PVX_Utility_PVT.resource_locked THEN
524: x_return_status := FND_API.g_ret_sts_error;
525: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
526: */
527: WHEN FND_API.G_EXC_ERROR THEN

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

521: EXCEPTION
522: /*
523: WHEN PVX_Utility_PVT.resource_locked THEN
524: x_return_status := FND_API.g_ret_sts_error;
525: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
526: */
527: WHEN FND_API.G_EXC_ERROR THEN
528: ROLLBACK TO Update_Attr_Value_PVT;
529: x_return_status := FND_API.G_RET_STS_ERROR;

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

602: END IF;
603:
604: -- Debug Message
605: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
606: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
607: END IF;
608: -- Initialize API return status to SUCCESS
609: x_return_status := FND_API.G_RET_STS_SUCCESS;
610:

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

612: -- Api body
613: --
614: -- Debug Message
615: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
616: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');
617: END IF;
618: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Delete_Row)
619: PV_ENTY_ATTR_VALUES_PKG.Delete_Row(
620: p_ENTY_ATTR_VAL_ID => p_ENTY_ATTR_VAL_ID);

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

629: END IF;
630:
631: -- Debug Message
632: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
633: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
634: END IF;
635: -- Standard call to get message count and if count is 1, get message info.
636: FND_MSG_PUB.Count_And_Get (
637: p_count => x_msg_count

Line 642: WHEN PVX_Utility_PVT.resource_locked THEN

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

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

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

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

709: BEGIN
710:
711: -- Debug Message
712: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
713: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
714: END IF;
715: -- Initialize message list if p_init_msg_list is set to TRUE.
716: IF FND_API.to_Boolean( p_init_msg_list )
717: THEN

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

734:
735:
736: ------------------------ lock -------------------------
737: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
738: PVX_Utility_PVT.debug_message(l_full_name||': start');
739: END IF;
740: OPEN c_Enty_Attr_Value;
741:
742: FETCH c_Enty_Attr_Value INTO l_ENTY_ATTR_VAL_ID;

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

758: ,p_count => x_msg_count
759: ,p_data => x_msg_data
760: );
761: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
762: PVX_Utility_PVT.debug_message(l_full_name ||': end');
763: END IF;
764: EXCEPTION
765: /*
766: WHEN PVX_Utility_PVT.resource_locked THEN

Line 766: WHEN PVX_Utility_PVT.resource_locked THEN

762: PVX_Utility_PVT.debug_message(l_full_name ||': end');
763: END IF;
764: EXCEPTION
765: /*
766: WHEN PVX_Utility_PVT.resource_locked THEN
767: x_return_status := FND_API.g_ret_sts_error;
768: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
769: */
770: WHEN FND_API.G_EXC_ERROR THEN

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

764: EXCEPTION
765: /*
766: WHEN PVX_Utility_PVT.resource_locked THEN
767: x_return_status := FND_API.g_ret_sts_error;
768: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
769: */
770: WHEN FND_API.G_EXC_ERROR THEN
771: ROLLBACK TO Lock_Attr_Value_PVT;
772: x_return_status := FND_API.G_RET_STS_ERROR;

Line 819: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

815: --DBMS_OUTPUT.PUT_LINE ('entering check_uk_items');
816:
817: x_return_status := FND_API.g_ret_sts_success;
818: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
819: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
820: 'PV_ENTY_ATTR_VALUES'
821: ,'ENTY_ATTR_VAL_ID = ''' || p_enty_attr_val_rec.ENTY_ATTR_VAL_ID ||''''
822: );
823: ELSE

Line 824: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

820: 'PV_ENTY_ATTR_VALUES'
821: ,'ENTY_ATTR_VAL_ID = ''' || p_enty_attr_val_rec.ENTY_ATTR_VAL_ID ||''''
822: );
823: ELSE
824: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
825: 'PV_ENTY_ATTR_VALUES'
826: ,'ENTY_ATTR_VAL_ID = ''' || p_enty_attr_val_rec.ENTY_ATTR_VAL_ID ||
827: ''' AND ENTY_ATTR_VAL_ID <> ' || p_enty_attr_val_rec.ENTY_ATTR_VAL_ID
828: );

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

1145: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1146:
1147: BEGIN
1148: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1149: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
1150: END IF;
1151:
1152: x_return_status := FND_API.g_ret_sts_success;
1153:

Line 1157: PVX_Utility_PVT.debug_message('Attribute Id:'|| p_enty_attr_val_rec.attribute_id||': - entity:' || p_enty_attr_val_rec.entity );

1153:
1154: -- Enter custom code here
1155:
1156: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1157: PVX_Utility_PVT.debug_message('Attribute Id:'|| p_enty_attr_val_rec.attribute_id||': - entity:' || p_enty_attr_val_rec.entity );
1158: END IF;
1159:
1160: for x in c_check_attr_exists(cv_attribute_id => p_enty_attr_val_rec.attribute_id )
1161: loop

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

1472: END IF;
1473:
1474: -- Debug Message
1475: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1476: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
1477: END IF;
1478: -- Initialize API return status to SUCCESS
1479: x_return_status := FND_API.G_RET_STS_SUCCESS;
1480:

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

1479: x_return_status := FND_API.G_RET_STS_SUCCESS;
1480:
1481: -- Debug Message
1482: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1483: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1484: END IF;
1485: -- Standard call to get message count and if count is 1, get message info.
1486: FND_MSG_PUB.Count_And_Get (
1487: p_count => x_msg_count

Line 1492: WHEN PVX_Utility_PVT.resource_locked THEN

1488: ,p_data => x_msg_data
1489: );
1490: EXCEPTION
1491: /*
1492: WHEN PVX_Utility_PVT.resource_locked THEN
1493: x_return_status := FND_API.g_ret_sts_error;
1494: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1495: */
1496: WHEN FND_API.G_EXC_ERROR THEN

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

1490: EXCEPTION
1491: /*
1492: WHEN PVX_Utility_PVT.resource_locked THEN
1493: x_return_status := FND_API.g_ret_sts_error;
1494: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1495: */
1496: WHEN FND_API.G_EXC_ERROR THEN
1497: ROLLBACK TO Validate_attr_value;
1498: x_return_status := FND_API.G_RET_STS_ERROR;

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

1555: -- x_return_status := FND_API.G_RET_STS_ERROR;
1556:
1557: -- Debug Message
1558: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1559: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1560: END IF;
1561: -- Standard call to get message count and if count is 1, get message info.
1562: FND_MSG_PUB.Count_And_Get (
1563: p_count => x_msg_count