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

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

75: END IF;
76:
77: -- Debug Message
78: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
79: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
80: end if;
81:
82:
83: -- Initialize API return status to SUCCESS

Line 122: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Attribute_Code');

118: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
119: THEN
120: -- Debug message
121: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
122: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Attribute_Code');
123: end if;
124:
125: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : Before Validate_attribute_Code' );
126:

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

154:
155: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : After Validate' );
156: -- Debug Message
157: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
158: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling create table handler');
159: end if;
160:
161: -- Invoke table handler(PV_ATTRIBUTE_CODE_PKG.Insert_Row)
162: PV_ATTRIBUTE_CODE_PKG.Insert_Row(

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

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

Line 207: WHEN PVX_Utility_PVT.resource_locked THEN

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

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

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

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

333: END IF;
334:
335: -- Debug Message
336: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
337: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
338: end if;
339:
340:
341: -- Initialize API return status to SUCCESS

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

342: x_return_status := FND_API.G_RET_STS_SUCCESS;
343:
344: -- Debug Message
345: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
346: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');
347: end if;
348:
349:
350: OPEN c_get_attribute_code( l_tar_attribute_code_rec.attr_code_id);

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

362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364: -- Debug Message
365: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
366: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Close Cursor');
367: end if;
368: CLOSE c_get_attribute_code;
369:
370: if(l_ref_attribute_code_rec.enabled_flag = 'Y' and p_attribute_code_rec.enabled_flag= 'N') then

Line 491: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Attribute_Code');

487: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
488: THEN
489: -- Debug message
490: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
491: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Attribute_Code');
492: end if;
493:
494: -- Invoke validation procedures
495: Validate_Attribute_Code(

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

511:
512:
513: -- Debug Message
514: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
515: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
516: end if;
517:
518: -- Invoke table handler(PV_ATTRIBUTE_CODE_PKG.Update_Row)
519: PV_ATTRIBUTE_CODE_PKG.Update_Row(

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

545:
546:
547: -- Debug Message
548: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
549: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
550: end if;
551:
552: -- Standard call to get message count and if count is 1, get message info.
553: FND_MSG_PUB.Count_And_Get

Line 559: WHEN PVX_Utility_PVT.resource_locked THEN

555: p_data => x_msg_data
556: );
557: EXCEPTION
558: /*
559: WHEN PVX_Utility_PVT.resource_locked THEN
560: x_return_status := FND_API.g_ret_sts_error;
561: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
562: */
563: WHEN FND_API.G_EXC_ERROR THEN

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

557: EXCEPTION
558: /*
559: WHEN PVX_Utility_PVT.resource_locked THEN
560: x_return_status := FND_API.g_ret_sts_error;
561: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
562: */
563: WHEN FND_API.G_EXC_ERROR THEN
564: ROLLBACK TO UPDATE_Attribute_Code_PVT;
565: x_return_status := FND_API.G_RET_STS_ERROR;

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

675: END IF;
676:
677: -- Debug Message
678: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
679: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
680: end if;
681:
682:
683: -- Initialize API return status to SUCCESS

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

831: end if;
832:
833: -- Debug Message
834: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
835: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');
836: END IF;
837:
838:
839: -- Invoke table handler(PV_ATTRIBUTE_CODE_PKG.Delete_Row)

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

855:
856:
857: -- Debug Message
858: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
859: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
860: END IF;
861:
862: -- Standard call to get message count and if count is 1, get message info.
863: FND_MSG_PUB.Count_And_Get

Line 869: WHEN PVX_Utility_PVT.resource_locked THEN

865: p_data => x_msg_data
866: );
867: EXCEPTION
868: /*
869: WHEN PVX_Utility_PVT.resource_locked THEN
870: x_return_status := FND_API.g_ret_sts_error;
871: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
872: */
873: WHEN FND_API.G_EXC_ERROR THEN

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

867: EXCEPTION
868: /*
869: WHEN PVX_Utility_PVT.resource_locked THEN
870: x_return_status := FND_API.g_ret_sts_error;
871: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
872: */
873: WHEN FND_API.G_EXC_ERROR THEN
874: ROLLBACK TO DELETE_Attribute_Code_PVT;
875: x_return_status := FND_API.G_RET_STS_ERROR;

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

938: SAVEPOINT LOCK_Attribute_Code_PVT;
939:
940: -- Debug Message
941: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
942: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
943: END IF;
944:
945: -- Initialize message list if p_init_msg_list is set to TRUE.
946: IF FND_API.to_Boolean( p_init_msg_list )

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

963:
964:
965: ------------------------ lock -------------------------
966:
967: PVX_Utility_PVT.debug_message(l_full_name||': start');
968: OPEN c_Attribute_Code;
969:
970: FETCH c_Attribute_Code INTO l_ATTR_CODE_ID;
971:

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

985: p_encoded => FND_API.g_false,
986: p_count => x_msg_count,
987: p_data => x_msg_data);
988: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
989: PVX_Utility_PVT.debug_message(l_full_name ||': end');
990: END IF;
991: EXCEPTION
992: /*
993: WHEN PVX_Utility_PVT.resource_locked THEN

Line 993: WHEN PVX_Utility_PVT.resource_locked THEN

989: PVX_Utility_PVT.debug_message(l_full_name ||': end');
990: END IF;
991: EXCEPTION
992: /*
993: WHEN PVX_Utility_PVT.resource_locked THEN
994: x_return_status := FND_API.g_ret_sts_error;
995: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
996: */
997: WHEN FND_API.G_EXC_ERROR THEN

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

991: EXCEPTION
992: /*
993: WHEN PVX_Utility_PVT.resource_locked THEN
994: x_return_status := FND_API.g_ret_sts_error;
995: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
996: */
997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO LOCK_Attribute_Code_PVT;
999: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1049: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

1045:
1046: BEGIN
1047: x_return_status := FND_API.g_ret_sts_success;
1048: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1049: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
1050: 'PV_ATTRIBUTE_CODES_B',
1051: 'ATTR_CODE_ID = ''' || p_attribute_code_rec.ATTR_CODE_ID ||''''
1052: );
1053: ELSE

Line 1054: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

1050: 'PV_ATTRIBUTE_CODES_B',
1051: 'ATTR_CODE_ID = ''' || p_attribute_code_rec.ATTR_CODE_ID ||''''
1052: );
1053: ELSE
1054: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
1055: 'PV_ATTRIBUTE_CODES_B',
1056: 'ATTR_CODE_ID = ''' || p_attribute_code_rec.ATTR_CODE_ID ||
1057: ''' AND ATTR_CODE_ID <> ' || p_attribute_code_rec.ATTR_CODE_ID
1058: );

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

1579:
1580: -- Debug Message
1581:
1582: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1583: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
1584: END IF;
1585: -- Initialize API return status to SUCCESS
1586: x_return_status := FND_API.G_RET_STS_SUCCESS;
1587:

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

1587:
1588:
1589: -- Debug Message
1590: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1591: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1592: END IF;
1593:
1594: -- Standard call to get message count and if count is 1, get message info.
1595: FND_MSG_PUB.Count_And_Get

Line 1601: WHEN PVX_Utility_PVT.resource_locked THEN

1597: p_data => x_msg_data
1598: );
1599: EXCEPTION
1600: /*
1601: WHEN PVX_Utility_PVT.resource_locked THEN
1602: x_return_status := FND_API.g_ret_sts_error;
1603: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1604: */
1605: WHEN FND_API.G_EXC_ERROR THEN

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

1599: EXCEPTION
1600: /*
1601: WHEN PVX_Utility_PVT.resource_locked THEN
1602: x_return_status := FND_API.g_ret_sts_error;
1603: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1604: */
1605: WHEN FND_API.G_EXC_ERROR THEN
1606: ROLLBACK TO Validate_Attribute_Code;
1607: x_return_status := FND_API.G_RET_STS_ERROR;

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

1664: -- x_return_status := FND_API.G_RET_STS_ERROR;
1665:
1666: -- Debug Message
1667: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1668: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1669: END IF;
1670:
1671: -- Standard call to get message count and if count is 1, get message info.
1672: FND_MSG_PUB.Count_And_Get