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

Line 92: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || ' start');

88: END IF;
89:
90: -- Debug Message
91: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
92: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || ' start');
93: END IF;
94:
95: -- Initialize API return status to SUCCESS
96: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 215: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Entity_Attr');

211: IF ( P_validation_level >= Fnd_Api.G_VALID_LEVEL_FULL)
212: THEN
213: -- Debug message
214: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
215: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Entity_Attr');
216: END IF;
217: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : Before Validate_Entity_Attr' );
218:
219: -- Populate the default required items

Line 252: Pvx_Utility_Pvt.debug_message( 'Private API: Calling create table handler');

248: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : After Validate' );
249:
250: -- Debug Message
251: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
252: Pvx_Utility_Pvt.debug_message( 'Private API: Calling create table handler');
253: END IF;
254:
255: --display flag should be Y for LEAd entity for the following types
256: -- to suport OTS attrs.

Line 322: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');

318: COMMIT WORK;
319: END IF;
320: -- Debug Message
321: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
322: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
323: END IF;
324: -- Standard call to get message count and if count is 1, get message info.
325: Fnd_Msg_Pub.Count_And_Get
326: (p_count => x_msg_count,

Line 430: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');

426: END IF;
427:
428: -- Debug Message
429: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
430: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
431: END IF;
432: -- Initialize API return status to SUCCESS
433: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
434:

Line 437: Pvx_Utility_Pvt.debug_message('Private API: - Open Cursor to Select');

433: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
434:
435: -- Debug Message
436: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
437: Pvx_Utility_Pvt.debug_message('Private API: - Open Cursor to Select');
438: END IF;
439: OPEN c_get_Entity_Attribute( l_tar_entity_attr_rec.entity_attr_id);
440:
441: FETCH c_get_Entity_Attribute INTO l_ref_entity_attr_rec ;

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

450: END IF;
451:
452: -- Debug Message
453: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
454: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Close Cursor');
455: END IF;
456:
457: CLOSE c_get_Entity_Attribute;
458:

Line 544: Pvx_Utility_Pvt.debug_message('Private API: Validate_Entity_Attr');

540: IF ( P_validation_level >= Fnd_Api.G_VALID_LEVEL_FULL)
541: THEN
542: -- Debug message
543: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
544: Pvx_Utility_Pvt.debug_message('Private API: Validate_Entity_Attr');
545: END IF;
546: -- Invoke validation procedures
547: Validate_Entity_Attr(
548: p_api_version_number => 1.0

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

558: RAISE Fnd_Api.G_EXC_ERROR;
559: END IF;
560: -- Debug Message
561: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
562: Pvx_Utility_Pvt.debug_message('Private API: '||l_full_name||' - Calling update table handler');
563: END IF;
564:
565:
566: l_lov_string := p_entity_attr_rec.lov_string;

Line 606: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');

602: COMMIT WORK;
603: END IF;
604: -- Debug Message
605: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
606: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
607: END IF;
608: -- Standard call to get message count and if count is 1, get message info.
609: Fnd_Msg_Pub.Count_And_Get
610: (p_count => x_msg_count,

Line 707: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'Start');

703: THEN
704: Fnd_Msg_Pub.initialize;
705: END IF;
706: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
707: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'Start');
708: END IF;
709:
710: -- Initialize API return status to SUCCESS
711: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 843: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');

839: end if;
840: -- Initialize API return status to SUCCESS
841: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
842: -- Debug Message
843: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
844: -- Standard call to get message count and if count is 1, get message info.
845: Fnd_Msg_Pub.Count_And_Get
846: (p_count => x_msg_count
847: ,p_data => x_msg_data

Line 949: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'Start');

945: THEN
946: Fnd_Msg_Pub.initialize;
947: END IF;
948: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
949: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'Start');
950: END IF;
951:
952: -- Initialize API return status to SUCCESS
953: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 977: Pvx_Utility_Pvt.debug_message('Private API: ' || 'The query:--' || l_exec_sql_text);

973: ' into lookup_code, lookup_meaning, lookup_description ' ||
974: ' using '|| p_attribute_id || ' ; end;'
975: ;
976: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
977: Pvx_Utility_Pvt.debug_message('Private API: ' || 'The query:--' || l_exec_sql_text);
978: END IF;
979:
980: DBMS_SQL.parse(v_cursor, l_exec_sql_text ,DBMS_SQL.NATIVE);
981: */

Line 984: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Before opening cursor' );

980: DBMS_SQL.parse(v_cursor, l_exec_sql_text ,DBMS_SQL.NATIVE);
981: */
982:
983: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
984: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Before opening cursor' );
985: END IF;
986:
987: OPEN lc_lov_cursor FOR l_lov_string USING p_attribute_id;
988: LOOP

Line 994: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Before fetching1' );

990:
991: FETCH lc_lov_cursor INTO l_lookup_code, l_lookup_meaning, l_lookup_description;
992: EXIT WHEN lc_lov_cursor%NOTFOUND;
993: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
994: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Before fetching1' );
995: END IF;
996:
997:
998: l_lov_result := l_lov_result || l_lookup_meaning || ', ';

Line 1001: Pvx_Utility_Pvt.debug_message('Private API:' || l_lookup_meaning || ':' );

997:
998: l_lov_result := l_lov_result || l_lookup_meaning || ', ';
999:
1000: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1001: Pvx_Utility_Pvt.debug_message('Private API:' || l_lookup_meaning || ':' );
1002: END IF;
1003:
1004:
1005: END LOOP;

Line 1010: Pvx_Utility_Pvt.debug_message('Private API: ' || 'closing cursor' );

1006:
1007: CLOSE lc_lov_cursor;
1008:
1009: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1010: Pvx_Utility_Pvt.debug_message('Private API: ' || 'closing cursor' );
1011: END IF;
1012:
1013: x_lov_result := substr(l_lov_result,1, length(l_lov_result)-2);
1014:

Line 1025: Pvx_Utility_Pvt.debug_message('Private API: ' || 'error Code:--' || l_error_code);

1021: l_parse_error2 := 'Y';
1022:
1023:
1024: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1025: Pvx_Utility_Pvt.debug_message('Private API: ' || 'error Code:--' || l_error_code);
1026: END IF;
1027:
1028: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1029: Pvx_Utility_Pvt.debug_message('Private API: ' || 'error Message:--' || l_error_message);

Line 1029: Pvx_Utility_Pvt.debug_message('Private API: ' || 'error Message:--' || l_error_message);

1025: Pvx_Utility_Pvt.debug_message('Private API: ' || 'error Code:--' || l_error_code);
1026: END IF;
1027:
1028: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1029: Pvx_Utility_Pvt.debug_message('Private API: ' || 'error Message:--' || l_error_message);
1030: END IF;
1031:
1032: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1033: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

Line 1050: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Lov String:--' || l_lov_string);

1046:
1047: end;
1048:
1049: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1050: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Lov String:--' || l_lov_string);
1051: END IF;
1052: /*
1053: if(l_parse_error2 = 'Y' and l_lov_string is not null ) then
1054: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 1070: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Before opening cursor' );

1066: RAISE FND_API.G_EXC_ERROR;
1067: else
1068:
1069: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1070: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Before opening cursor' );
1071: END IF;
1072:
1073: OPEN lc_lov_cursor FOR l_lov_string USING p_attribute_id;
1074: LOOP

Line 1077: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Before fetching1' );

1073: OPEN lc_lov_cursor FOR l_lov_string USING p_attribute_id;
1074: LOOP
1075: EXIT WHEN lc_lov_cursor%NOTFOUND;
1076: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1077: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Before fetching1' );
1078: END IF;
1079:
1080: FETCH lc_lov_cursor INTO l_lookup_code, l_lookup_meaning, l_lookup_description;
1081:

Line 1084: Pvx_Utility_Pvt.debug_message('Private API:' || l_lookup_meaning || ':' );

1080: FETCH lc_lov_cursor INTO l_lookup_code, l_lookup_meaning, l_lookup_description;
1081:
1082: l_lov_result := l_lov_result || ',' || l_lookup_meaning || ' ';
1083: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1084: Pvx_Utility_Pvt.debug_message('Private API:' || l_lookup_meaning || ':' );
1085: END IF;
1086:
1087: END LOOP;
1088:

Line 1092: Pvx_Utility_Pvt.debug_message('Private API: ' || 'closing cursor' );

1088:
1089: CLOSE lc_lov_cursor;
1090:
1091: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1092: Pvx_Utility_Pvt.debug_message('Private API: ' || 'closing cursor' );
1093: END IF;
1094: x_lov_result := substr(l_lov_result,1, length(l_lov_result)-1);
1095:
1096: end if;

Line 1103: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');

1099:
1100: -- Initialize API return status to SUCCESS
1101: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1102: -- Debug Message
1103: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
1104: -- Standard call to get message count and if count is 1, get message info.
1105: Fnd_Msg_Pub.Count_And_Get
1106: (p_count => x_msg_count
1107: ,p_data => x_msg_data

Line 1211: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');

1207: Fnd_Msg_Pub.initialize;
1208: END IF;
1209: -- Debug Message
1210: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1211: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
1212: END IF;
1213: -- Initialize API return status to SUCCESS
1214: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1215: --

Line 1280: Pvx_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');

1276:
1277:
1278: -- Debug Message
1279: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1280: Pvx_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');
1281: END IF;
1282: -- Invoke table handler(PV_ENTITY_ATTRS_PKG.Delete_Row)
1283: Pv_Entity_Attrs_Pkg.Delete_Row(
1284: p_ENTITY_ATTR_ID => p_ENTITY_ATTR_ID);

Line 1295: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');

1291: COMMIT WORK;
1292: END IF;
1293: -- Debug Message
1294: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1295: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
1296: END IF;
1297: -- Standard call to get message count and if count is 1, get message info.
1298: Fnd_Msg_Pub.Count_And_Get
1299: (p_count => x_msg_count,

Line 1365: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');

1361: FOR UPDATE NOWAIT;
1362: BEGIN
1363: -- Debug Message
1364: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1365: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
1366: END IF;
1367: -- Initialize message list if p_init_msg_list is set to TRUE.
1368: IF Fnd_Api.to_Boolean( p_init_msg_list )
1369: THEN

Line 1385: Pvx_Utility_Pvt.debug_message(l_full_name||': start');

1381: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1382:
1383: ------------------------ lock -------------------------
1384: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1385: Pvx_Utility_Pvt.debug_message(l_full_name||': start');
1386: END IF;
1387: OPEN c_Entity_Attribute;
1388: FETCH c_Entity_Attribute INTO l_ENTITY_ATTR_ID;
1389: IF (c_Entity_Attribute%NOTFOUND) THEN

Line 1404: Pvx_Utility_Pvt.debug_message(l_full_name ||': end');

1400: p_encoded => Fnd_Api.g_false,
1401: p_count => x_msg_count,
1402: p_data => x_msg_data);
1403: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1404: Pvx_Utility_Pvt.debug_message(l_full_name ||': end');
1405: END IF;
1406: EXCEPTION
1407: /*
1408: WHEN PV_Utility_PVT.resource_locked THEN

Line 1455: l_valid_flag := Pvx_Utility_Pvt.check_uniqueness(

1451: l_valid_flag VARCHAR2(1);
1452: BEGIN
1453: x_return_status := Fnd_Api.g_ret_sts_success;
1454: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
1455: l_valid_flag := Pvx_Utility_Pvt.check_uniqueness(
1456: 'PV_ENTITY_ATTRS',
1457: 'ENTITY_ATTR_ID = ''' || p_entity_attr_rec.ENTITY_ATTR_ID ||''''
1458: );
1459: ELSE

Line 1460: l_valid_flag := Pvx_Utility_Pvt.check_uniqueness(

1456: 'PV_ENTITY_ATTRS',
1457: 'ENTITY_ATTR_ID = ''' || p_entity_attr_rec.ENTITY_ATTR_ID ||''''
1458: );
1459: ELSE
1460: l_valid_flag := Pvx_Utility_Pvt.check_uniqueness(
1461: 'PV_ENTITY_ATTRS',
1462: 'ENTITY_ATTR_ID = ''' || p_entity_attr_rec.ENTITY_ATTR_ID ||
1463: ''' AND ENTITY_ATTR_ID <> ' || p_entity_attr_rec.ENTITY_ATTR_ID
1464: );

Line 2037: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');

2033: END IF;
2034: END IF;
2035: -- Debug Message
2036: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2037: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
2038: END IF;
2039: -- Initialize API return status to SUCCESS
2040: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2041: -- Debug Message

Line 2043: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');

2039: -- Initialize API return status to SUCCESS
2040: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2041: -- Debug Message
2042: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2043: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
2044: END IF;
2045: -- Standard call to get message count and if count is 1, get message info.
2046: Fnd_Msg_Pub.Count_And_Get
2047: (p_count => x_msg_count

Line 2118: Pvx_Utility_Pvt.debug_message('Private API: Validate_dm_model_rec');

2114: -- x_return_status := FND_API.G_RET_STS_ERROR;
2115:
2116: -- Debug Message
2117: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2118: Pvx_Utility_Pvt.debug_message('Private API: Validate_dm_model_rec');
2119: END IF;
2120:
2121: -- Standard call to get message count and if count is 1, get message info.
2122: Fnd_Msg_Pub.Count_And_Get (