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.OZF_ACTFORECAST_PVT dependencies on OZF_UTILITY_PVT

Line 238: OZF_Utility_PVT.Debug_Message(l_full_name||': start');

234: IF (OZF_DEBUG_HIGH_ON) THEN
235:
236:
237:
238: OZF_Utility_PVT.Debug_Message(l_full_name||': start');
239:
240: END IF;
241:
242: --

Line 335: OZF_Utility_PVT.debug_message(l_full_name ||': insert');

331: -- Debug message.
332: --
333: IF (OZF_DEBUG_HIGH_ON) THEN
334:
335: OZF_Utility_PVT.debug_message(l_full_name ||': insert');
336: END IF;
337:
338:
339: --

Line 513: OZF_Utility_PVT.debug_message(l_full_name ||': end Success');

509: IF (OZF_DEBUG_HIGH_ON) THEN
510:
511:
512:
513: OZF_Utility_PVT.debug_message(l_full_name ||': end Success');
514:
515: END IF;
516:
517:

Line 604: OZF_Utility_PVT.debug_message(l_full_name||': start');

600: -- Output debug message.
601: --
602: IF (OZF_DEBUG_HIGH_ON) THEN
603:
604: OZF_Utility_PVT.debug_message(l_full_name||': start');
605: END IF;
606:
607: --
608: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 659: OZF_Utility_PVT.debug_message(l_full_name ||': validate ');

655:
656:
657:
658:
659: OZF_Utility_PVT.debug_message(l_full_name ||': validate ');
660:
661:
662: END IF;
663:

Line 669: OZF_Utility_PVT.debug_message(l_full_name ||' 1 ' || l_act_forecast_rec.forecast_id);

665:
666: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
667: IF (OZF_DEBUG_HIGH_ON) THEN
668:
669: OZF_Utility_PVT.debug_message(l_full_name ||' 1 ' || l_act_forecast_rec.forecast_id);
670: END IF;
671: Validate_ActFcst_Items(
672: p_act_forecast_rec => l_act_forecast_rec,
673: p_validation_mode => JTF_PLSQL_API.g_update,

Line 681: OZF_Utility_PVT.debug_message(l_full_name ||' 2 ' || p_act_forecast_rec.forecast_id);

677: RAISE FND_API.g_exc_unexpected_error;
678: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
679: IF (OZF_DEBUG_HIGH_ON) THEN
680:
681: OZF_Utility_PVT.debug_message(l_full_name ||' 2 ' || p_act_forecast_rec.forecast_id);
682: END IF;
683: RAISE FND_API.g_exc_error;
684: END IF;
685: END IF;

Line 717: OZF_Utility_PVT.debug_message(l_full_name ||': Update Activity Metric Facts Table');

713:
714:
715:
716:
717: OZF_Utility_PVT.debug_message(l_full_name ||': Update Activity Metric Facts Table');
718:
719:
720: END IF;
721:

Line 811: OZF_Utility_PVT.debug_message(l_full_name ||': end');

807: -- Debug message.
808: --
809: IF (OZF_DEBUG_HIGH_ON) THEN
810:
811: OZF_Utility_PVT.debug_message(l_full_name ||': end');
812: END IF;
813:
814:
815: EXCEPTION

Line 890: OZF_Utility_PVT.debug_message(l_full_name||': start');

886: -- Output debug message.
887: --
888: IF (OZF_DEBUG_HIGH_ON) THEN
889:
890: OZF_Utility_PVT.debug_message(l_full_name||': start');
891: END IF;
892:
893: --
894: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 923: OZF_Utility_PVT.debug_message(l_full_name ||': delete with Validation');

919:
920: -- Debug message.
921: IF (OZF_DEBUG_HIGH_ON) THEN
922:
923: OZF_Utility_PVT.debug_message(l_full_name ||': delete with Validation');
924: END IF;
925:
926:
927: IF (OZF_DEBUG_HIGH_ON) THEN

Line 933: OZF_Utility_PVT.debug_message('forecast id '||to_char(p_forecast_id));

929:
930:
931:
932:
933: OZF_Utility_PVT.debug_message('forecast id '||to_char(p_forecast_id));
934:
935:
936: END IF;
937: IF (OZF_DEBUG_HIGH_ON) THEN

Line 939: OZF_Utility_PVT.debug_message('object version number '||to_char(p_object_version_number));

935:
936: END IF;
937: IF (OZF_DEBUG_HIGH_ON) THEN
938:
939: OZF_Utility_PVT.debug_message('object version number '||to_char(p_object_version_number));
940: END IF;
941:
942: DELETE from ozf_act_metric_facts_all
943: WHERE act_metric_used_by_id = p_forecast_id

Line 978: OZF_Utility_PVT.debug_message(l_full_name ||': End');

974: -- Debug message.
975: --
976: IF (OZF_DEBUG_HIGH_ON) THEN
977:
978: OZF_Utility_PVT.debug_message(l_full_name ||': End');
979: END IF;
980:
981:
982: --

Line 1065: OZF_Utility_PVT.debug_message(l_full_name||': start');

1061: -- Output debug message.
1062: --
1063: IF (OZF_DEBUG_HIGH_ON) THEN
1064:
1065: OZF_Utility_PVT.debug_message(l_full_name||': start');
1066: END IF;
1067:
1068: --
1069: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1096: OZF_Utility_PVT.debug_message(l_full_name||': lock');

1092: -- Begin API Body
1093: --
1094: IF (OZF_DEBUG_HIGH_ON) THEN
1095:
1096: OZF_Utility_PVT.debug_message(l_full_name||': lock');
1097: END IF;
1098:
1099: OPEN c_act_forecast_info;
1100: FETCH c_act_forecast_info INTO l_forecast_id;

Line 1130: OZF_Utility_PVT.debug_message(l_full_name ||': end');

1126: -- Debug message.
1127: --
1128: IF (OZF_DEBUG_HIGH_ON) THEN
1129:
1130: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1131: END IF;
1132:
1133:
1134: EXCEPTION

Line 1147: WHEN OZF_Utility_PVT.RESOURCE_LOCKED THEN

1143: FND_MSG_PUB.Count_And_Get (
1144: p_count => x_msg_count,
1145: p_data => x_msg_data
1146: );
1147: WHEN OZF_Utility_PVT.RESOURCE_LOCKED THEN
1148: x_return_status := FND_API.G_RET_STS_ERROR ;
1149:
1150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1151: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');

Line 1216: OZF_Utility_PVT.debug_message(l_full_name||': start');

1212: -- Output debug message.
1213: --
1214: IF (OZF_DEBUG_HIGH_ON) THEN
1215:
1216: OZF_Utility_PVT.debug_message(l_full_name||': start');
1217: END IF;
1218:
1219: --
1220: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1250: OZF_Utility_PVT.debug_message(l_full_name||': Validate items');

1246: IF (OZF_DEBUG_HIGH_ON) THEN
1247:
1248:
1249:
1250: OZF_Utility_PVT.debug_message(l_full_name||': Validate items');
1251:
1252: END IF;
1253:
1254: -- Validate required items in the record.

Line 1275: OZF_Utility_PVT.debug_message(l_full_name||': check record');

1271: IF (OZF_DEBUG_HIGH_ON) THEN
1272:
1273:
1274:
1275: OZF_Utility_PVT.debug_message(l_full_name||': check record');
1276:
1277: END IF;
1278:
1279: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

Line 1289: OZF_Utility_PVT.debug_message(l_full_name||': error in check record');

1285:
1286: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1287: IF (OZF_DEBUG_HIGH_ON) THEN
1288:
1289: OZF_Utility_PVT.debug_message(l_full_name||': error in check record');
1290: END IF;
1291: RAISE FND_API.g_exc_unexpected_error;
1292: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1293: IF (OZF_DEBUG_HIGH_ON) THEN

Line 1295: OZF_Utility_PVT.debug_message(l_full_name||': error in check record');

1291: RAISE FND_API.g_exc_unexpected_error;
1292: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1293: IF (OZF_DEBUG_HIGH_ON) THEN
1294:
1295: OZF_Utility_PVT.debug_message(l_full_name||': error in check record');
1296: END IF;
1297: RAISE FND_API.g_exc_error;
1298: END IF;
1299: END IF;

Line 1305: OZF_Utility_PVT.debug_message(l_full_name||': after check record');

1301: IF (OZF_DEBUG_HIGH_ON) THEN
1302:
1303:
1304:
1305: OZF_Utility_PVT.debug_message(l_full_name||': after check record');
1306:
1307: END IF;
1308:
1309:

Line 1328: OZF_Utility_PVT.debug_message(l_full_name ||': end');

1324: IF (OZF_DEBUG_HIGH_ON) THEN
1325:
1326:
1327:
1328: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1329:
1330: END IF;
1331:
1332:

Line 1390: OZF_Utility_PVT.debug_message('forecast_id before exception : ' || p_act_forecast_rec.forecast_id);

1386: IF (OZF_DEBUG_HIGH_ON) THEN
1387:
1388:
1389:
1390: OZF_Utility_PVT.debug_message('forecast_id before exception : ' || p_act_forecast_rec.forecast_id);
1391:
1392: END IF;
1393: IF (OZF_DEBUG_HIGH_ON) THEN
1394:

Line 1395: OZF_Utility_PVT.debug_message('forecast_id before exception : ' || x_complete_fcst_rec.forecast_id);

1391:
1392: END IF;
1393: IF (OZF_DEBUG_HIGH_ON) THEN
1394:
1395: OZF_Utility_PVT.debug_message('forecast_id before exception : ' || x_complete_fcst_rec.forecast_id);
1396: END IF;
1397:
1398: OPEN c_act_forecast;
1399: FETCH c_act_forecast INTO l_act_forecast_rec;

Line 1404: OZF_Utility_PVT.debug_message('forecast_id before raising exception : ' || x_complete_fcst_rec.forecast_id);

1400: IF c_act_forecast%NOTFOUND THEN
1401: CLOSE c_act_forecast;
1402: IF (OZF_DEBUG_HIGH_ON) THEN
1403:
1404: OZF_Utility_PVT.debug_message('forecast_id before raising exception : ' || x_complete_fcst_rec.forecast_id);
1405: END IF;
1406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1407: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1408: FND_MSG_PUB.add;

Line 1418: OZF_Utility_PVT.debug_message('forecast_id before raising : ' || p_act_forecast_rec.forecast_id);

1414: IF (OZF_DEBUG_HIGH_ON) THEN
1415:
1416:
1417:
1418: OZF_Utility_PVT.debug_message('forecast_id before raising : ' || p_act_forecast_rec.forecast_id);
1419:
1420: END IF;
1421:
1422:

Line 1822: IF OZF_Utility_PVT.Check_Uniqueness(

1818: ' act_fcast_used_by_id = '||p_act_forecast_rec.act_fcast_used_by_id ;
1819: l_where_clause := l_where_clause ||
1820: ' last_scenario_id = '||p_act_forecast_rec.last_scenario_id ;
1821:
1822: IF OZF_Utility_PVT.Check_Uniqueness(
1823: p_table_name => 'ozf_act_forecasts_all',
1824: p_where_clause => l_where_clause
1825: ) = FND_API.g_false
1826: THEN

Line 1882: IF OZF_Utility_PVT.check_lookup_exists(

1878:
1879: --FORECAST_TYPE
1880: IF l_act_forecast_rec.forecast_type <> FND_API.G_MISS_CHAR THEN
1881:
1882: IF OZF_Utility_PVT.check_lookup_exists(
1883: p_lookup_type => 'OZF_FCAST_TYPE',
1884: p_lookup_code => l_act_forecast_rec.forecast_type
1885: ) = FND_API.g_false
1886: THEN

Line 1918: IF OZF_Utility_PVT.check_lookup_exists(

1914:
1915: --BASE_QUANTITY_TYPE
1916: IF l_act_forecast_rec.base_quantity_type <> FND_API.G_MISS_CHAR AND l_act_forecast_rec.base_quantity_type IS NOT NULL THEN
1917:
1918: IF OZF_Utility_PVT.check_lookup_exists(
1919: p_lookup_type => 'OZF_FCAST_BASE_VOL_SOURCE',
1920: p_lookup_code => l_act_forecast_rec.base_quantity_type
1921: ) = FND_API.g_false
1922: THEN

Line 1939: IF OZF_Utility_PVT.check_lookup_exists(

1935:
1936: --FORECAST_SPREAD_TYPE
1937: IF l_act_forecast_rec.forecast_spread_type <> FND_API.G_MISS_CHAR AND l_act_forecast_rec.forecast_spread_type IS NOT NULL THEN
1938:
1939: IF OZF_Utility_PVT.check_lookup_exists(
1940: p_lookup_type => 'OZF_FCAST_SPREAD',
1941: p_lookup_code => l_act_forecast_rec.forecast_spread_type
1942: ) = FND_API.g_false
1943: THEN

Line 1962: IF OZF_Utility_PVT.check_lookup_exists(

1958: --FORECAST_UOM_CODE
1959: /* -- This value is being validated in the jsp page thru a LOV
1960: IF l_act_forecast_rec.forecast_uom_code <> FND_API.G_MISS_CHAR THEN
1961:
1962: IF OZF_Utility_PVT.check_lookup_exists(
1963: p_lookup_type => 'OZF_FCAST_UOM',
1964: p_lookup_code => l_act_forecast_rec.forecast_uom_code
1965: ) = FND_API.g_false
1966: THEN

Line 2027: OZF_Utility_PVT.Get_Qual_Table_Name_And_PK (

2023:
2024: IF l_act_forecast_rec.arc_act_fcast_used_by <> FND_API.G_MISS_CHAR THEN
2025:
2026: -- Get table_name and pk_name for the ARC qualifier.
2027: OZF_Utility_PVT.Get_Qual_Table_Name_And_PK (
2028: p_sys_qual => l_act_forecast_rec.arc_act_fcast_used_by,
2029: x_return_status => l_return_status,
2030: x_table_name => l_table_name,
2031: x_pk_name => l_pk_name

Line 2036: l_pk_data_type := OZF_Utility_PVT.G_NUMBER;

2032: );
2033:
2034:
2035: l_pk_value := l_act_forecast_rec.act_fcast_used_by_id;
2036: l_pk_data_type := OZF_Utility_PVT.G_NUMBER;
2037: l_additional_where_clause := NULL;
2038:
2039: IF OZF_Utility_PVT.Check_FK_Exists (
2040: p_table_name => l_table_name

Line 2039: IF OZF_Utility_PVT.Check_FK_Exists (

2035: l_pk_value := l_act_forecast_rec.act_fcast_used_by_id;
2036: l_pk_data_type := OZF_Utility_PVT.G_NUMBER;
2037: l_additional_where_clause := NULL;
2038:
2039: IF OZF_Utility_PVT.Check_FK_Exists (
2040: p_table_name => l_table_name
2041: ,p_pk_name => l_pk_name
2042: ,p_pk_value => l_pk_value
2043: ,p_pk_data_type => l_pk_data_type