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_ACTMETRIC_PVT dependencies on OZF_UTILITY_PVT

Line 335: ozf_utility_pvt.Debug_Message(l_full_name||': start');

331: --
332: --SAVEPOINT Create_ActMetric2_pvt;
333:
334: IF (OZF_DEBUG_HIGH_ON) THEN
335: ozf_utility_pvt.Debug_Message(l_full_name||': start');
336: END IF;
337:
338: --
339: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 429: ozf_utility_pvt.debug_message(l_full_name ||': insert');

425: -- Debug message.
426: --
427: IF (OZF_DEBUG_HIGH_ON) THEN
428:
429: ozf_utility_pvt.debug_message(l_full_name ||': insert');
430: END IF;
431:
432: IF l_act_metrics_rec.activity_metric_id IS NULL THEN
433: LOOP

Line 653: ozf_utility_pvt.debug_message(l_full_name ||': end Success');

649: --
650: -- Add success message to message list.
651: --
652: IF (OZF_DEBUG_HIGH_ON) THEN
653: ozf_utility_pvt.debug_message(l_full_name ||': end Success');
654: END IF;
655:
656: /*
657: EXCEPTION

Line 737: ozf_utility_pvt.debug_message('Now updating act met id: '||p_act_metric_rec.activity_metric_id);

733:
734:
735: IF (OZF_DEBUG_HIGH_ON) THEN
736:
737: ozf_utility_pvt.debug_message('Now updating act met id: '||p_act_metric_rec.activity_metric_id);
738:
739: END IF;
740: --
741: -- Initialize savepoint.

Line 748: ozf_utility_pvt.debug_message(l_full_name||': start');

744: --
745: -- Output debug message.
746: --
747: IF (OZF_DEBUG_HIGH_ON) THEN
748: ozf_utility_pvt.debug_message(l_full_name||': start');
749: END IF;
750: --
751: -- Initialize message list if p_init_msg_list is set to TRUE.
752: --

Line 779: ozf_utility_pvt.debug_message(l_full_name ||': validate');

775: --
776: -- Debug Message
777:
778: IF (OZF_DEBUG_HIGH_ON) THEN
779: ozf_utility_pvt.debug_message(l_full_name ||': validate');
780: END IF;
781:
782: -- replace g_miss_char/num/date with current column values
783: Complete_ActMetric_Rec(p_act_metric_rec, l_actmet_rec);

Line 836: ozf_utility_pvt.debug_message(l_full_name ||': update Activity Metrics Table');

832: END IF;
833:
834:
835: IF (OZF_DEBUG_HIGH_ON) THEN
836: ozf_utility_pvt.debug_message(l_full_name ||': update Activity Metrics Table');
837: END IF;
838:
839: -- Update OZF_ACT_METRICS_ALL
840: UPDATE ozf_act_metrics_all

Line 950: ozf_utility_pvt.debug_message(l_full_name ||': end');

946: --
947: -- Debug message.
948: --
949: IF (OZF_DEBUG_HIGH_ON) THEN
950: ozf_utility_pvt.debug_message(l_full_name ||': end');
951: END IF;
952:
953:
954: EXCEPTION

Line 1024: ozf_utility_pvt.debug_message(l_full_name||': start');

1020: --
1021: -- Output debug message.
1022: --
1023: IF (OZF_DEBUG_HIGH_ON) THEN
1024: ozf_utility_pvt.debug_message(l_full_name||': start');
1025: END IF;
1026:
1027: --
1028: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1055: ozf_utility_pvt.debug_message(l_full_name||': Validate items');

1051: -- Begin API Body.
1052: --
1053:
1054: IF (OZF_DEBUG_HIGH_ON) THEN
1055: ozf_utility_pvt.debug_message(l_full_name||': Validate items');
1056: END IF;
1057:
1058: -- Validate required items in the record.
1059: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

Line 1076: ozf_utility_pvt.debug_message(l_full_name||': check record');

1072: END IF;
1073: END IF;
1074:
1075: IF (OZF_DEBUG_HIGH_ON) THEN
1076: ozf_utility_pvt.debug_message(l_full_name||': check record');
1077: END IF;
1078:
1079: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN
1080: Validate_ActMetric_record(

Line 1108: ozf_utility_pvt.debug_message(l_full_name ||': end');

1104: p_encoded => Fnd_Api.G_FALSE
1105: );
1106:
1107: IF (OZF_DEBUG_HIGH_ON) THEN
1108: ozf_utility_pvt.debug_message(l_full_name ||': end');
1109: END IF;
1110:
1111: EXCEPTION
1112: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1334: IF ozf_utility_pvt.Check_Uniqueness(

1330: AND p_act_metric_rec.activity_metric_id IS NOT NULL
1331: THEN
1332: l_where_clause := ' activity_metric_id = '||p_act_metric_rec.activity_metric_id ;
1333:
1334: IF ozf_utility_pvt.Check_Uniqueness(
1335: p_table_name => 'ozf_act_metrics_all',
1336: p_where_clause => l_where_clause
1337: ) = Fnd_Api.g_false
1338: THEN

Line 1435: l_pk_data_type := ozf_utility_pvt.G_NUMBER;

1431: IF l_act_metrics_rec.metric_id <> Fnd_Api.G_MISS_NUM THEN
1432: l_table_name := 'AMS_METRICS_VL';
1433: l_pk_name := 'METRIC_ID';
1434: l_pk_value := l_act_metrics_rec.metric_id;
1435: l_pk_data_type := ozf_utility_pvt.G_NUMBER;
1436: l_additional_where_clause := NULL ;
1437:
1438: IF ozf_utility_pvt.Check_FK_Exists (
1439: p_table_name => l_table_name

Line 1438: IF ozf_utility_pvt.Check_FK_Exists (

1434: l_pk_value := l_act_metrics_rec.metric_id;
1435: l_pk_data_type := ozf_utility_pvt.G_NUMBER;
1436: l_additional_where_clause := NULL ;
1437:
1438: IF ozf_utility_pvt.Check_FK_Exists (
1439: p_table_name => l_table_name
1440: ,p_pk_name => l_pk_name
1441: ,p_pk_value => l_pk_value
1442: ,p_pk_data_type => l_pk_data_type

Line 1465: l_pk_data_type := ozf_utility_pvt.G_VARCHAR2;

1461: IF l_act_metrics_rec.transaction_currency_code <> Fnd_Api.G_MISS_CHAR THEN
1462: l_table_name := 'FND_CURRENCIES';
1463: l_pk_name := 'CURRENCY_CODE';
1464: l_pk_value := l_act_metrics_rec.transaction_currency_code;
1465: l_pk_data_type := ozf_utility_pvt.G_VARCHAR2;
1466: l_additional_where_clause := ' enabled_flag = ''Y''';
1467: IF ozf_utility_pvt.Check_FK_Exists (
1468: p_table_name => l_table_name
1469: ,p_pk_name => l_pk_name

Line 1467: IF ozf_utility_pvt.Check_FK_Exists (

1463: l_pk_name := 'CURRENCY_CODE';
1464: l_pk_value := l_act_metrics_rec.transaction_currency_code;
1465: l_pk_data_type := ozf_utility_pvt.G_VARCHAR2;
1466: l_additional_where_clause := ' enabled_flag = ''Y''';
1467: IF ozf_utility_pvt.Check_FK_Exists (
1468: p_table_name => l_table_name
1469: ,p_pk_name => l_pk_name
1470: ,p_pk_value => l_pk_value
1471: ,p_pk_data_type => l_pk_data_type

Line 1492: l_pk_data_type := ozf_utility_pvt.G_VARCHAR2;

1488: IF l_act_metrics_rec.functional_currency_code <> Fnd_Api.G_MISS_CHAR THEN
1489: l_table_name := 'FND_CURRENCIES';
1490: l_pk_name := 'CURRENCY_CODE';
1491: l_pk_value := l_act_metrics_rec.functional_currency_code;
1492: l_pk_data_type := ozf_utility_pvt.G_VARCHAR2;
1493: l_additional_where_clause := ' enabled_flag = ''Y''';
1494:
1495: IF ozf_utility_pvt.Check_FK_Exists (
1496: p_table_name => l_table_name

Line 1495: IF ozf_utility_pvt.Check_FK_Exists (

1491: l_pk_value := l_act_metrics_rec.functional_currency_code;
1492: l_pk_data_type := ozf_utility_pvt.G_VARCHAR2;
1493: l_additional_where_clause := ' enabled_flag = ''Y''';
1494:
1495: IF ozf_utility_pvt.Check_FK_Exists (
1496: p_table_name => l_table_name
1497: ,p_pk_name => l_pk_name
1498: ,p_pk_value => l_pk_value
1499: ,p_pk_data_type => l_pk_data_type

Line 1525: IF ozf_utility_pvt.Is_Y_Or_N (l_act_metrics_rec.sensitive_data_flag)

1521: --
1522:
1523: -- SENSITIVE_DATA_FLAG
1524: IF l_act_metrics_rec.sensitive_data_flag <> Fnd_Api.G_MISS_CHAR THEN
1525: IF ozf_utility_pvt.Is_Y_Or_N (l_act_metrics_rec.sensitive_data_flag)
1526: = Fnd_Api.G_FALSE
1527: THEN
1528: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1529: THEN

Line 1886: ozf_utility_pvt.Get_Qual_Table_Name_And_PK (

1882: END IF;
1883:
1884:
1885: -- Get table_name and pk_name for the ARC qualifier.
1886: ozf_utility_pvt.Get_Qual_Table_Name_And_PK (
1887: p_sys_qual => l_act_metrics_rec.arc_act_metric_used_by,
1888: x_return_status => l_return_status,
1889: x_table_name => l_table_name,
1890: x_pk_name => l_pk_name

Line 1894: l_pk_data_type := ozf_utility_pvt.G_NUMBER;

1890: x_pk_name => l_pk_name
1891: );
1892:
1893: l_pk_value := l_act_metrics_rec.act_metric_used_by_id;
1894: l_pk_data_type := ozf_utility_pvt.G_NUMBER;
1895: l_additional_where_clause := NULL;
1896:
1897: IF ozf_utility_pvt.Check_FK_Exists (
1898: p_table_name => l_table_name

Line 1897: IF ozf_utility_pvt.Check_FK_Exists (

1893: l_pk_value := l_act_metrics_rec.act_metric_used_by_id;
1894: l_pk_data_type := ozf_utility_pvt.G_NUMBER;
1895: l_additional_where_clause := NULL;
1896:
1897: IF ozf_utility_pvt.Check_FK_Exists (
1898: p_table_name => l_table_name
1899: ,p_pk_name => l_pk_name
1900: ,p_pk_value => l_pk_value
1901: ,p_pk_data_type => l_pk_data_type

Line 1906: l_object_name := ozf_utility_pvt.get_lookup_meaning(

1902: ,p_additional_where_clause => l_additional_where_clause
1903: ) = Fnd_Api.G_FALSE
1904: THEN
1905: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1906: l_object_name := ozf_utility_pvt.get_lookup_meaning(
1907: 'AMS_SYS_ARC_QUALIFIER',l_act_metrics_rec.arc_act_metric_used_by);
1908: Fnd_Message.Set_Name ('OZF', 'OZF_METR_INVALID_OBJECT');
1909: Fnd_Message.Set_Token('OBJTYPE',l_object_name);
1910: Fnd_Message.Set_Token('OBJID',l_pk_value);

Line 1940: l_pk_data_type := ozf_utility_pvt.G_VARCHAR2;

1936: /* yzhao: is METRIC_UOM_CODE used in our code? should it be removed? */
1937: l_table_name := 'MTL_UNITS_OF_MEASURE';
1938: l_pk_name := 'UOM_CODE';
1939: l_pk_value := l_act_metrics_rec.metric_uom_code;
1940: l_pk_data_type := ozf_utility_pvt.G_VARCHAR2;
1941: -- l_additional_where_clause := ' uom_class = ''' || l_metric_details_rec.uom_type || '''' ;
1942:
1943: IF ozf_utility_pvt.Check_FK_Exists (
1944: p_table_name => l_table_name

Line 1943: IF ozf_utility_pvt.Check_FK_Exists (

1939: l_pk_value := l_act_metrics_rec.metric_uom_code;
1940: l_pk_data_type := ozf_utility_pvt.G_VARCHAR2;
1941: -- l_additional_where_clause := ' uom_class = ''' || l_metric_details_rec.uom_type || '''' ;
1942:
1943: IF ozf_utility_pvt.Check_FK_Exists (
1944: p_table_name => l_table_name
1945: ,p_pk_name => l_pk_name
1946: ,p_pk_value => l_pk_value
1947: ,p_pk_data_type => l_pk_data_type

Line 1969: ozf_utility_pvt.Get_Qual_Table_Name_And_PK (

1965: p_complete_rec.activity_metric_origin_id;
1966: END IF;
1967:
1968: -- Get table_name and pk_name for the ARC qualifier.
1969: ozf_utility_pvt.Get_Qual_Table_Name_And_PK (
1970: p_sys_qual => l_act_metrics_rec.arc_activity_metric_origin,
1971: x_return_status => l_return_status,
1972: x_table_name => l_table_name,
1973: x_pk_name => l_pk_name

Line 1977: l_pk_data_type := ozf_utility_pvt.G_NUMBER;

1973: x_pk_name => l_pk_name
1974: );
1975:
1976: l_pk_value := l_act_metrics_rec.activity_metric_origin_id;
1977: l_pk_data_type := ozf_utility_pvt.G_NUMBER;
1978: l_additional_where_clause := NULL;
1979:
1980: IF ozf_utility_pvt.Check_FK_Exists (
1981: p_table_name => l_table_name

Line 1980: IF ozf_utility_pvt.Check_FK_Exists (

1976: l_pk_value := l_act_metrics_rec.activity_metric_origin_id;
1977: l_pk_data_type := ozf_utility_pvt.G_NUMBER;
1978: l_additional_where_clause := NULL;
1979:
1980: IF ozf_utility_pvt.Check_FK_Exists (
1981: p_table_name => l_table_name
1982: ,p_pk_name => l_pk_name
1983: ,p_pk_value => l_pk_value
1984: ,p_pk_data_type => l_pk_data_type