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

Line 81: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || ' start');

77:
78: -- Debug Message
79: --DBMS_output.put_line('Private API: ' || L_FULL_NAME || ' start');
80: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
81: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || ' start');
82: end if;
83:
84:
85: -- Initialize API return status to SUCCESS

Line 123: PVX_UTILITY_PVT.debug_message('Private API: Validate_Attribute');

119: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
120: THEN
121: -- Debug message
122: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
123: PVX_UTILITY_PVT.debug_message('Private API: Validate_Attribute');
124: END IF;
125:
126: --DBMS_output.put_line('Before validate_attribute');
127:

Line 191: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

187:
188:
189:
190: -- Debug Message
191: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
192:
193: -- Invoke table handler(PV_ATTRIBUTE_PKG.Insert_Row)
194: PV_ATTRIBUTE_PKG.Insert_Row(
195: px_attribute_id => l_attribute_rec.attribute_id,

Line 246: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');

242:
243:
244: -- Debug Message
245: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
246: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');
247: END IF;
248:
249: -- Standard call to get message count and if count is 1, get message info.
250: FND_MSG_PUB.Count_And_Get

Line 257: WHEN PVX_UTILITY_PVT.resource_locked THEN

253: );
254: EXCEPTION
255:
256: /*
257: WHEN PVX_UTILITY_PVT.resource_locked THEN
258: x_return_status := FND_API.g_ret_sts_error;
259: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
260: */
261:

Line 259: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

255:
256: /*
257: WHEN PVX_UTILITY_PVT.resource_locked THEN
258: x_return_status := FND_API.g_ret_sts_error;
259: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
260: */
261:
262: WHEN FND_API.G_EXC_ERROR THEN
263: ROLLBACK TO CREATE_Attribute_PVT;

Line 371: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'start');

367: END IF;
368:
369: -- Debug Message
370: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
371: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'start');
372: END IF;
373:
374:
375: -- Initialize API return status to SUCCESS

Line 380: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

376: x_return_status := FND_API.G_RET_STS_SUCCESS;
377:
378: -- Debug Message
379: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
380: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
381: END IF;
382:
383:
384:

Line 402: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');

398: END IF;
399:
400: -- Debug Message
401: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
402: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');
403: END IF;
404: CLOSE c_get_Attribute;
405:
406:

Line 671: PVX_UTILITY_PVT.debug_message('Private API: Validate_Attribute');

667: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
668: THEN
669: -- Debug message
670: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
671: PVX_UTILITY_PVT.debug_message('Private API: Validate_Attribute');
672: END IF;
673: --dbms_output.put_line('Before Validate_attribute');
674: -- Invoke validation procedures
675: Validate_attribute(

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

691: END IF;
692:
693: -- Debug Message
694: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
695: PVX_UTILITY_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
696: END IF;
697:
698: --DBMS_output.put_line('Before update_row');
699:

Line 750: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');

746:
747:
748: -- Debug Message
749: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
750: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');
751: END IF;
752:
753: -- Standard call to get message count and if count is 1, get message info.
754: FND_MSG_PUB.Count_And_Get

Line 761: WHEN PVX_UTILITY_PVT.resource_locked THEN

757: );
758: EXCEPTION
759:
760: /*
761: WHEN PVX_UTILITY_PVT.resource_locked THEN
762: x_return_status := FND_API.g_ret_sts_error;
763: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
764: */
765:

Line 763: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

759:
760: /*
761: WHEN PVX_UTILITY_PVT.resource_locked THEN
762: x_return_status := FND_API.g_ret_sts_error;
763: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
764: */
765:
766: WHEN FND_API.G_EXC_ERROR THEN
767: ROLLBACK TO UPDATE_Attribute_PVT;

Line 907: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || ' start');

903: END IF;
904:
905: -- Debug Message
906: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
907: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || ' start');
908: END IF;
909:
910: -- Initialize API return status to SUCCESS
911: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1071: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

1067:
1068:
1069: --start deleting
1070: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1071: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1072: END IF;
1073:
1074:
1075: --delete all rows from pv_attr_codes table

Line 1080: PVX_UTILITY_PVT.debug_message( 'Calling PV_ATTRIBUTE_CODE_PVT.Delete_Attribute_Code for : ' ||x.attr_code_id );

1076:
1077: for x in lc_attribute_codes (pc_attribute_id =>p_attribute_id)
1078: loop
1079: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1080: PVX_UTILITY_PVT.debug_message( 'Calling PV_ATTRIBUTE_CODE_PVT.Delete_Attribute_Code for : ' ||x.attr_code_id );
1081: END IF;
1082:
1083: PV_ATTRIBUTE_CODE_PVT.Delete_Attribute_Code(
1084: p_api_version_number => p_api_version_number

Line 1104: PVX_UTILITY_PVT.debug_message( 'Calling PV_Attribute_Usage_PVT.Delete_Attribute_Usage for : ' ||x.attribute_usage_id );

1100:
1101: for x in lc_attribute_usages (pc_attribute_id =>p_attribute_id)
1102: loop
1103:
1104: PVX_UTILITY_PVT.debug_message( 'Calling PV_Attribute_Usage_PVT.Delete_Attribute_Usage for : ' ||x.attribute_usage_id );
1105: PV_Attribute_Usage_PVT.Delete_Attribute_Usage(
1106: p_api_version_number => p_api_version_number
1107: ,p_init_msg_list => p_init_msg_list
1108: ,p_commit => p_commit

Line 1128: PVX_UTILITY_PVT.debug_message( 'Calling PV_Entity_Attribute_Pvt.Delete_Entity_Attr for : ' ||x.entity_attr_id );

1124: for x in lc_entity_attrs (pc_attribute_id =>p_attribute_id)
1125: loop
1126:
1127: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1128: PVX_UTILITY_PVT.debug_message( 'Calling PV_Entity_Attribute_Pvt.Delete_Entity_Attr for : ' ||x.entity_attr_id );
1129: END IF;
1130: PV_Entity_Attribute_Pvt.Delete_Entity_Attr(
1131: p_api_version_number => p_api_version_number
1132: ,p_init_msg_list => p_init_msg_list

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_DEBUG_LOW)) 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 1174: WHEN PVX_UTILITY_PVT.resource_locked THEN

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

Line 1176: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1172:
1173: /*
1174: WHEN PVX_UTILITY_PVT.resource_locked THEN
1175: x_return_status := FND_API.g_ret_sts_error;
1176: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1177: */
1178:
1179: WHEN FND_API.G_EXC_ERROR THEN
1180: ROLLBACK TO DELETE_Attribute_PVT;

Line 1247: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'start');

1243: BEGIN
1244:
1245: -- Debug Message
1246: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1247: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'start');
1248: END IF;
1249:
1250: -- Initialize message list if p_init_msg_list is set to TRUE.
1251: IF FND_API.to_Boolean( p_init_msg_list )

Line 1272: PVX_UTILITY_PVT.debug_message(l_full_name||': start');

1268:
1269:
1270: ------------------------ lock -------------------------
1271:
1272: PVX_UTILITY_PVT.debug_message(l_full_name||': start');
1273: OPEN c_Attribute;
1274:
1275: FETCH c_Attribute INTO l_ATTRIBUTE_ID;
1276:

Line 1293: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');

1289: FND_MSG_PUB.count_and_get(
1290: p_encoded => FND_API.g_false,
1291: p_count => x_msg_count,
1292: p_data => x_msg_data);
1293: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
1294: EXCEPTION
1295:
1296: WHEN PVX_UTILITY_PVT.resource_locked THEN
1297: x_return_status := FND_API.g_ret_sts_error;

Line 1296: WHEN PVX_UTILITY_PVT.resource_locked THEN

1292: p_data => x_msg_data);
1293: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
1294: EXCEPTION
1295:
1296: WHEN PVX_UTILITY_PVT.resource_locked THEN
1297: x_return_status := FND_API.g_ret_sts_error;
1298: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1299:
1300: WHEN FND_API.G_EXC_ERROR THEN

Line 1298: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1294: EXCEPTION
1295:
1296: WHEN PVX_UTILITY_PVT.resource_locked THEN
1297: x_return_status := FND_API.g_ret_sts_error;
1298: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1299:
1300: WHEN FND_API.G_EXC_ERROR THEN
1301: ROLLBACK TO LOCK_Attribute_PVT;
1302: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1352: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

1348: BEGIN
1349:
1350: x_return_status := FND_API.g_ret_sts_success;
1351: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1352: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
1353: 'PV_ATTRIBUTES_B',
1354: 'ATTRIBUTE_ID = ''' || p_attribute_rec.ATTRIBUTE_ID ||''''
1355: );
1356: ELSE

Line 1357: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

1353: 'PV_ATTRIBUTES_B',
1354: 'ATTRIBUTE_ID = ''' || p_attribute_rec.ATTRIBUTE_ID ||''''
1355: );
1356: ELSE
1357: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
1358: 'PV_ATTRIBUTES_B',
1359: 'ATTRIBUTE_ID = ''' || p_attribute_rec.ATTRIBUTE_ID ||
1360: ''' AND ATTRIBUTE_ID <> ' || p_attribute_rec.ATTRIBUTE_ID
1361: );

Line 1403: l_valid_tl_flag := PVX_UTILITY_PVT.check_uniqueness(

1399:
1400:
1401:
1402: /* IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1403: l_valid_tl_flag := PVX_UTILITY_PVT.check_uniqueness(
1404: 'PV_ATTRIBUTES_TL','SHORT_NAME = ''' || p_attribute_rec.SHORT_NAME
1405: ||''' AND LANGUAGE = ' || userenv('LANG') );
1406: END IF ;
1407:

Line 1973: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'start');

1969: END IF;
1970:
1971: -- Debug Message
1972: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1973: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'start');
1974: END IF;
1975:
1976:
1977: -- Initialize API return status to SUCCESS

Line 1982: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');

1978: x_return_status := FND_API.G_RET_STS_SUCCESS;
1979:
1980: -- Debug Message
1981: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1982: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');
1983: END IF;
1984:
1985: -- Standard call to get message count and if count is 1, get message info.
1986: FND_MSG_PUB.Count_And_Get

Line 1992: WHEN PVX_UTILITY_PVT.resource_locked THEN

1988: p_data => x_msg_data
1989: );
1990: EXCEPTION
1991:
1992: WHEN PVX_UTILITY_PVT.resource_locked THEN
1993:
1994: x_return_status := FND_API.g_ret_sts_error;
1995: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1996:

Line 1995: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1991:
1992: WHEN PVX_UTILITY_PVT.resource_locked THEN
1993:
1994: x_return_status := FND_API.g_ret_sts_error;
1995: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1996:
1997: WHEN FND_API.G_EXC_ERROR THEN
1998: ROLLBACK TO VALIDATE_Attribute_PVT;
1999: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2064: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

2060: -- x_return_status := FND_API.G_RET_STS_ERROR;
2061:
2062: -- Debug Message
2063: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2064: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
2065: END IF;
2066: -- Standard call to get message count and if count is 1, get message info.
2067: FND_MSG_PUB.Count_And_Get
2068: (p_count => x_msg_count,