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.AMS_METRIC_PVT dependencies on AMS_UTILITY_PVT

Line 21: -- use AMS_Utility_PVT instead of AMS_Global_PVT.

17: -- validate_metric API and added ORG_ID to create and
18: -- update. Began creating template
19: -- API's for activity metrics.
20: -- 31-may-1999 choang@us Updated package qualifier for utility functions to
21: -- use AMS_Utility_PVT instead of AMS_Global_PVT.
22: -- 01-jun-1999 choang@us Added insert and update API for activity metrics
23: -- -- untested.
24: -- 02-jun-1999 choang@us Began on lock API.
25: -- 07-jun-1999 choang@us Added validate rec types extracted from global

Line 108: -- 04/20/2004 sunkumar removed reference to ams_utility_pvt.checkcheck_fk_exists

104: -- 08/27/2003 sunkumar BUG3116703: Modified Validate_Metric_Program
105: -- 08/29/2003 dmvincen Adding display type.
106: -- 02/19/2004 sunkumar bug#3453994
107: -- 02/24/2004 dmvincen BUG3465714: Record validation on create.
108: -- 04/20/2004 sunkumar removed reference to ams_utility_pvt.checkcheck_fk_exists
109: -- 06/17/2004 sunkumar BUG#3697901: Function Type not setting up
110: -- 06/18/2004 sunkumar removed reference to get_function_type instead
111: -- setting up the function/procedure flag in
112: -- Validate_Metric_Program, Made

Line 333: Ams_Utility_Pvt.Debug_Message(l_full_name||': start');

329: -- Initialize savepoint.
330: --
331: SAVEPOINT Create_Metric_pvt;
332:
333: Ams_Utility_Pvt.Debug_Message(l_full_name||': start');
334:
335: --
336: -- Initialize message list if p_init_msg_list is set to TRUE.
337: --

Line 390: Ams_Utility_Pvt.debug_message(l_full_name ||': insert');

386:
387: --
388: -- Debug message.
389: --
390: Ams_Utility_Pvt.debug_message(l_full_name ||': insert');
391:
392: IF l_metrics_rec.metric_id IS NULL THEN
393: LOOP
394: --

Line 504: Ams_Utility_Pvt.debug_message(l_full_name ||': insert TL ');

500: );
501:
502: -- Debug message.
503: --
504: Ams_Utility_Pvt.debug_message(l_full_name ||': insert TL ');
505:
506: --
507: -- Insert into the translation table.
508: --

Line 570: Ams_Utility_Pvt.debug_message(l_full_name ||': end Success');

566:
567: --
568: -- Add success message to message list.
569: --
570: Ams_Utility_Pvt.debug_message(l_full_name ||': end Success');
571:
572:
573: EXCEPTION
574: WHEN FND_API.G_EXC_ERROR THEN

Line 653: Ams_Utility_Pvt.debug_message(l_full_name||': start');

649:
650: --
651: -- Output debug message.
652: --
653: Ams_Utility_Pvt.debug_message(l_full_name||': start');
654:
655: --
656: -- Initialize message list if p_init_msg_list is set to TRUE.
657: --

Line 721: -- Ams_Utility_Pvt.debug_message(l_full_name ||': validate');

717: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
718: RAISE FND_API.g_exc_unexpected_error;
719: END IF;
720:
721: -- Ams_Utility_Pvt.debug_message(l_full_name ||': validate');
722:
723: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
724: Validate_Metric_items(
725: p_metric_rec => l_metrics_rec,

Line 763: -- Ams_Utility_Pvt.debug_message(l_full_name ||': update Metrics Base Table');

759: RAISE FND_API.g_exc_error;
760: END IF;
761: END IF;
762:
763: -- Ams_Utility_Pvt.debug_message(l_full_name ||': update Metrics Base Table');
764:
765: --function metric
766: IF UPPER(l_metrics_rec.metric_calculation_type) = G_FUNCTION THEN
767: IF l_metrics_rec.function_name IS NULL

Line 830: Ams_Utility_Pvt.debug_message(l_full_name ||': updateMetrics TL Table');

826: RAISE FND_API.g_exc_error;
827: END IF;
828:
829: -- Debug message.
830: Ams_Utility_Pvt.debug_message(l_full_name ||': updateMetrics TL Table');
831:
832: -- Update AMS_METRICS_ALL_TL
833: UPDATE ams_metrics_all_tl
834: SET metrics_name = l_metrics_rec.metrics_name,

Line 878: Ams_Utility_Pvt.debug_message(l_full_name ||': end');

874:
875: --
876: -- Debug message.
877: --
878: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
879:
880:
881: EXCEPTION
882: WHEN FND_API.G_EXC_ERROR THEN

Line 974: Ams_Utility_Pvt.debug_message(l_full_name||': start');

970:
971: --
972: -- Output debug message.
973: --
974: Ams_Utility_Pvt.debug_message(l_full_name||': start');
975:
976: --
977: -- Initialize message list if p_init_msg_list is set to TRUE.
978: --

Line 1079: Ams_Utility_Pvt.debug_message(l_full_name ||': delete with Validation');

1075: END IF;
1076: -- end addition
1077:
1078: -- Debug message.
1079: Ams_Utility_Pvt.debug_message(l_full_name ||': delete with Validation');
1080:
1081: DELETE FROM ams_metrics_all_b
1082: WHERE metric_id = p_metric_id
1083: AND object_version_number = p_object_version_number;

Line 1124: Ams_Utility_Pvt.debug_message(l_full_name ||': End');

1120:
1121: --
1122: -- Debug message.
1123: --
1124: Ams_Utility_Pvt.debug_message(l_full_name ||': End');
1125:
1126:
1127: --
1128: -- Standard API to get message count, and if 1,

Line 1218: Ams_Utility_Pvt.debug_message(l_full_name||': start');

1214: BEGIN
1215: --
1216: -- Output debug message.
1217: --
1218: Ams_Utility_Pvt.debug_message(l_full_name||': start');
1219:
1220: --
1221: -- Initialize message list if p_init_msg_list is set to TRUE.
1222: --

Line 1246: Ams_Utility_Pvt.debug_message(l_full_name||': lock');

1242:
1243: --
1244: -- Begin API Body
1245: --
1246: Ams_Utility_Pvt.debug_message(l_full_name||': lock');
1247:
1248:
1249: OPEN c_metrics_info;
1250: FETCH c_metrics_info INTO l_metric_id;

Line 1280: Ams_Utility_Pvt.debug_message(l_full_name ||': end');

1276:
1277: --
1278: -- Debug message.
1279: --
1280: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
1281:
1282:
1283: EXCEPTION
1284: WHEN FND_API.G_EXC_ERROR THEN

Line 1297: WHEN Ams_Utility_Pvt.RESOURCE_LOCKED THEN

1293: p_encoded => FND_API.g_false,
1294: p_count => x_msg_count,
1295: p_data => x_msg_data
1296: );
1297: WHEN Ams_Utility_Pvt.RESOURCE_LOCKED THEN
1298: x_return_status := FND_API.G_RET_STS_ERROR ;
1299:
1300: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1301: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');

Line 1361: Ams_Utility_Pvt.debug_message(l_full_name||': start');

1357: BEGIN
1358: --
1359: -- Output debug message.
1360: --
1361: Ams_Utility_Pvt.debug_message(l_full_name||': start');
1362:
1363: --
1364: -- Initialize message list if p_init_msg_list is set to TRUE.
1365: --

Line 1390: Ams_Utility_Pvt.debug_message(l_full_name||': Validate items');

1386: --
1387: -- Begin API Body.
1388: --
1389:
1390: Ams_Utility_Pvt.debug_message(l_full_name||': Validate items');
1391:
1392: -- Validate required items in the record.
1393: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1394:

Line 1410: Ams_Utility_Pvt.debug_message(l_full_name||': check record');

1406: RAISE FND_API.G_EXC_ERROR;
1407: END IF;
1408: END IF;
1409:
1410: Ams_Utility_Pvt.debug_message(l_full_name||': check record');
1411:
1412: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1413: -- dmvincen 02/24/2004: set p_complete_rec to p_metric_rec from null.
1414: Validate_Metric_record(

Line 1443: Ams_Utility_Pvt.debug_message(l_full_name ||': end');

1439: );
1440:
1441:
1442:
1443: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
1444:
1445:
1446:
1447: EXCEPTION

Line 1772: IF Ams_Utility_Pvt.Check_Uniqueness(

1768: AND p_metric_rec.metric_id IS NOT NULL
1769: THEN
1770: l_where_clause := ' metric_id = '||p_metric_rec.metric_id ;
1771:
1772: IF Ams_Utility_Pvt.Check_Uniqueness(
1773: p_table_name => 'ams_metrics_vl',
1774: p_where_clause => l_where_clause
1775: ) = FND_API.g_false
1776: THEN

Line 1806: IF AMS_Utility_PVT.Check_Uniqueness(

1802: p_metric_rec.metric_id;
1803:
1804: END IF;
1805:
1806: IF AMS_Utility_PVT.Check_Uniqueness(
1807: p_table_name => 'ams_metrics_vl',
1808: p_where_clause => l_where_clause
1809: ) = FND_API.g_false
1810: THEN

Line 1966: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;

1962: /*commented by sunkumar 20-april-2004 */
1963: /* l_table_name := 'AMS_METRICS_VL';
1964: l_pk_name := 'METRIC_ID';
1965: l_pk_value := l_metrics_rec.metric_parent_id;
1966: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
1967: l_additional_where_clause := ' metric_calculation_type = '''||G_ROLLUP||'''';
1968:
1969: IF Ams_Utility_Pvt.Check_FK_Exists (
1970: p_table_name => l_table_name

Line 1969: IF Ams_Utility_Pvt.Check_FK_Exists (

1965: l_pk_value := l_metrics_rec.metric_parent_id;
1966: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
1967: l_additional_where_clause := ' metric_calculation_type = '''||G_ROLLUP||'''';
1968:
1969: IF Ams_Utility_Pvt.Check_FK_Exists (
1970: p_table_name => l_table_name
1971: ,p_pk_name => l_pk_name
1972: ,p_pk_value => l_pk_value
1973: ,p_pk_data_type => l_pk_data_type

Line 2019: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;

2015:
2016: /* l_table_name := 'AMS_METRICS_VL';
2017: l_pk_name := 'METRIC_ID';
2018: l_pk_value := l_metrics_rec.summary_metric_id;
2019: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
2020: l_additional_where_clause := ' metric_calculation_type = '''||G_SUMMARY||'''';
2021:
2022: IF Ams_Utility_Pvt.Check_FK_Exists (
2023: p_table_name => l_table_name

Line 2022: IF Ams_Utility_Pvt.Check_FK_Exists (

2018: l_pk_value := l_metrics_rec.summary_metric_id;
2019: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
2020: l_additional_where_clause := ' metric_calculation_type = '''||G_SUMMARY||'''';
2021:
2022: IF Ams_Utility_Pvt.Check_FK_Exists (
2023: p_table_name => l_table_name
2024: ,p_pk_name => l_pk_name
2025: ,p_pk_value => l_pk_value
2026: ,p_pk_data_type => l_pk_data_type

Line 2067: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;

2063:
2064: /* l_table_name := 'MTL_UOM_CLASSES';
2065: l_pk_name := 'UOM_CLASS';
2066: l_pk_value := l_metrics_rec.uom_type;
2067: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
2068: l_additional_where_clause := NULL;
2069:
2070: IF Ams_Utility_Pvt.Check_FK_Exists (
2071: p_table_name => l_table_name

Line 2070: IF Ams_Utility_Pvt.Check_FK_Exists (

2066: l_pk_value := l_metrics_rec.uom_type;
2067: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
2068: l_additional_where_clause := NULL;
2069:
2070: IF Ams_Utility_Pvt.Check_FK_Exists (
2071: p_table_name => l_table_name
2072: ,p_pk_name => l_pk_name
2073: ,p_pk_value => l_pk_value
2074: ,p_pk_data_type => l_pk_data_type

Line 2115: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;

2111:
2112: /*l_table_name := 'AMS_CATEGORIES_VL';
2113: l_pk_name := 'CATEGORY_ID';
2114: l_pk_value := l_metrics_rec.metric_category;
2115: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
2116: l_additional_where_clause := ' enabled_flag = ''Y'''||
2117: ' and arc_category_created_for = ''METR''';
2118:
2119: IF Ams_Utility_Pvt.Check_FK_Exists (

Line 2119: IF Ams_Utility_Pvt.Check_FK_Exists (

2115: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
2116: l_additional_where_clause := ' enabled_flag = ''Y'''||
2117: ' and arc_category_created_for = ''METR''';
2118:
2119: IF Ams_Utility_Pvt.Check_FK_Exists (
2120: p_table_name => l_table_name
2121: ,p_pk_name => l_pk_name
2122: ,p_pk_value => l_pk_value
2123: ,p_pk_data_type => l_pk_data_type

Line 2149: IF Ams_Utility_Pvt.Is_Y_Or_N(l_metrics_rec.sensitive_data_flag)

2145: --
2146:
2147: -- SENSITIVE_DATA_FLAG
2148: IF l_metrics_rec.sensitive_data_flag <> FND_API.G_MISS_CHAR THEN
2149: IF Ams_Utility_Pvt.Is_Y_Or_N(l_metrics_rec.sensitive_data_flag)
2150: = FND_API.G_FALSE
2151: THEN
2152: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2153: THEN

Line 2165: IF Ams_Utility_Pvt.Is_Y_Or_N(l_metrics_rec.enabled_flag)

2161: END IF;
2162:
2163: -- ENABLED_FLAG
2164: IF l_metrics_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN
2165: IF Ams_Utility_Pvt.Is_Y_Or_N(l_metrics_rec.enabled_flag)
2166: = FND_API.G_FALSE
2167: THEN
2168: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2169: THEN

Line 2190: IF Ams_Utility_Pvt.Check_Lookup_Exists (

2186:
2187: -- ACCRUAL_TYPE
2188: IF l_metrics_rec.accrual_type <> FND_API.G_MISS_CHAR THEN
2189: l_lookup_type := 'AMS_METRIC_ACCRUAL_TYPE';
2190: IF Ams_Utility_Pvt.Check_Lookup_Exists (
2191: p_lookup_table_name => 'AMS_LOOKUPS'
2192: ,p_lookup_type => l_lookup_type
2193: ,p_lookup_code => l_metrics_rec.accrual_type
2194: ) = FND_API.G_FALSE

Line 2211: Ams_Utility_Pvt.Check_Lookup_Exists (

2207: -- DMVINCEN 05/15/2001: Allow SUMMARY for 11.5.4.11 (change in 11.5.5).
2208: IF l_metrics_rec.metric_calculation_type <> FND_API.G_MISS_CHAR THEN
2209: l_lookup_type := 'AMS_METRIC_CALCULATION_TYPE';
2210: IF -- l_metrics_rec.metric_calculation_type <> G_SUMMARY AND
2211: Ams_Utility_Pvt.Check_Lookup_Exists (
2212: p_lookup_table_name => 'AMS_LOOKUPS'
2213: ,p_lookup_type => l_lookup_type
2214: ,p_lookup_code => l_metrics_rec.metric_calculation_type
2215: ) = FND_API.G_FALSE

Line 2231: IF Ams_Utility_Pvt.Check_Lookup_Exists (

2227:
2228: -- VALUE_TYPE
2229: IF l_metrics_rec.DISPLAY_TYPE <> FND_API.G_MISS_CHAR THEN
2230: l_lookup_type := 'AMS_METRIC_DISPLAY_TYPE';
2231: IF Ams_Utility_Pvt.Check_Lookup_Exists (
2232: p_lookup_table_name => 'AMS_LOOKUPS'
2233: ,p_lookup_type => l_lookup_type
2234: ,p_lookup_code => l_metrics_rec.DISPLAY_TYPE
2235: ) = FND_API.G_FALSE

Line 2251: IF Ams_Utility_Pvt.Check_Lookup_Exists (

2247:
2248: -- VALUE_TYPE
2249: IF l_metrics_rec.value_type <> FND_API.G_MISS_CHAR THEN
2250: l_lookup_type := 'AMS_METRIC_VALUE_TYPE';
2251: IF Ams_Utility_Pvt.Check_Lookup_Exists (
2252: p_lookup_table_name => 'AMS_LOOKUPS'
2253: ,p_lookup_type => l_lookup_type
2254: ,p_lookup_code => l_metrics_rec.value_type
2255: ) = FND_API.G_FALSE

Line 2301: -- IF AMS_Utility_PVT.Check_Lookup_Exists (

2297: OR (l_metrics_rec.arc_metric_used_for_object <> 'ANY'
2298: AND l_metrics_rec.metric_calculation_type in (G_ROLLUP, G_SUMMARY))
2299:
2300: -- l_lookup_type := 'AMS_SYS_ARC_QUALIFIER';
2301: -- IF AMS_Utility_PVT.Check_Lookup_Exists (
2302: -- p_lookup_table_name => 'AMS_LOOKUPS'
2303: -- ,p_lookup_type => l_lookup_type
2304: -- ,p_lookup_code => l_metrics_rec.arc_metric_used_for_object
2305: -- ) = FND_API.G_FALSE

Line 2578: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;

2574:
2575: /*l_table_name := 'AMS_CATEGORIES_VL';
2576: l_pk_name := 'CATEGORY_ID';
2577: l_pk_value := p_complete_rec.metric_sub_category;
2578: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
2579: l_additional_where_clause := ' enabled_flag = ''Y'''||
2580: ' and arc_category_created_for = ''METR'''||
2581: ' and parent_category_id = '||
2582: p_complete_rec.metric_category;

Line 2584: IF Ams_Utility_Pvt.Check_FK_Exists (

2580: ' and arc_category_created_for = ''METR'''||
2581: ' and parent_category_id = '||
2582: p_complete_rec.metric_category;
2583:
2584: IF Ams_Utility_Pvt.Check_FK_Exists (
2585: p_table_name => l_table_name
2586: ,p_pk_name => l_pk_name
2587: ,p_pk_value => l_pk_value
2588: ,p_pk_data_type => l_pk_data_type

Line 2613: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;

2609: -- END IF;
2610: /* l_table_name := 'MTL_UNITS_OF_MEASURE';
2611: l_pk_name := 'UOM_CODE';
2612: l_pk_value := p_complete_rec.default_uom_code;
2613: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
2614: l_additional_where_clause := ' uom_class = '''||p_complete_rec.uom_type||'''';
2615:
2616: IF Ams_Utility_Pvt.Check_FK_Exists (
2617: p_table_name => l_table_name

Line 2616: IF Ams_Utility_Pvt.Check_FK_Exists (

2612: l_pk_value := p_complete_rec.default_uom_code;
2613: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
2614: l_additional_where_clause := ' uom_class = '''||p_complete_rec.uom_type||'''';
2615:
2616: IF Ams_Utility_Pvt.Check_FK_Exists (
2617: p_table_name => l_table_name
2618: ,p_pk_name => l_pk_name
2619: ,p_pk_value => l_pk_value
2620: ,p_pk_data_type => l_pk_data_type

Line 2741: l_name := AMS_UTILITY_PVT.get_lookup_meaning(

2737: END IF;
2738: IF l_object_type <> p_complete_rec.arc_metric_used_for_object THEN
2739: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2740: FND_MESSAGE.Set_Name ('AMS', 'AMS_METR_INVALID_MULTI_OBJ');
2741: l_name := AMS_UTILITY_PVT.get_lookup_meaning(
2742: 'AMS_METRIC_OBJECT_TYPE',l_object_type);
2743: FND_MESSAGE.set_token('OBJECT',
2744: NVL(l_name,l_object_type), FALSE);
2745: FND_MSG_PUB.ADD;

Line 2752: l_name := AMS_UTILITY_PVT.get_lookup_meaning(

2748: END IF;
2749: IF l_calculation_type NOT IN (G_MANUAL, G_FUNCTION) THEN
2750: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2751: FND_MESSAGE.Set_Name ('AMS', 'AMS_METR_INVALID_MULTI_CALC');
2752: l_name := AMS_UTILITY_PVT.get_lookup_meaning(
2753: 'AMS_METRIC_CALCULATION_TYPE',l_calculation_type);
2754: FND_MESSAGE.set_token('CALCULATION',
2755: NVL(l_name,l_calculation_type), FALSE);
2756: FND_MSG_PUB.ADD;

Line 3177: /*IF Ams_Utility_Pvt.Check_FK_Exists (

3173:
3174:
3175:
3176: -- AMS_ACT_METRICS_ALL
3177: /*IF Ams_Utility_Pvt.Check_FK_Exists (
3178: p_table_name => 'AMS_ACT_METRICS_ALL',
3179: p_pk_name => 'METRIC_ID',
3180: p_pk_value => l_metric_id,
3181: p_pk_data_type => Ams_Utility_Pvt.G_NUMBER

Line 3181: p_pk_data_type => Ams_Utility_Pvt.G_NUMBER

3177: /*IF Ams_Utility_Pvt.Check_FK_Exists (
3178: p_table_name => 'AMS_ACT_METRICS_ALL',
3179: p_pk_name => 'METRIC_ID',
3180: p_pk_value => l_metric_id,
3181: p_pk_data_type => Ams_Utility_Pvt.G_NUMBER
3182: ) = FND_API.G_TRUE
3183: THEN
3184: x_return_status := FND_API.G_RET_STS_ERROR;
3185: RETURN;

Line 3200: -- IF AMS_Utility_PVT.Check_FK_Exists (

3196: -- id of any other id
3197:
3198: -- Original Code
3199:
3200: -- IF AMS_Utility_PVT.Check_FK_Exists (
3201: -- p_table_name => 'AMS_METRICS_VL',
3202: -- p_pk_name => 'METRIC_ID',
3203: -- p_pk_value => l_metrics_rec.metric_parent_id
3204: -- ) = FND_API.G_TRUE

Line 3214: -- IF AMS_Utility_PVT.Check_FK_Exists (

3210: -- it's parent.
3211:
3212: -- comment out the following for bug 1356700 fix
3213: -- 07/17/2000 khung
3214: -- IF AMS_Utility_PVT.Check_FK_Exists (
3215: -- p_table_name => 'AMS_METRICS_VL',
3216: -- p_pk_name => 'METRIC_PARENT_ID',
3217: -- p_pk_value => l_metric_id,
3218: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER

Line 3218: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER

3214: -- IF AMS_Utility_PVT.Check_FK_Exists (
3215: -- p_table_name => 'AMS_METRICS_VL',
3216: -- p_pk_name => 'METRIC_PARENT_ID',
3217: -- p_pk_value => l_metric_id,
3218: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER
3219: -- ) = FND_API.G_TRUE
3220: -- End of the changes made by PTENDULK on 08/19/1999
3221: -- THEN
3222: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 3241: -- IF AMS_Utility_PVT.Check_FK_Exists (

3237: -- Start of the changes made by PTENDULK on 08/19/1999
3238: -- The check is modified to check whether this metric id is Summary metric
3239: -- id of any other metric id
3240: -- Original Code
3241: -- IF AMS_Utility_PVT.Check_FK_Exists (
3242: -- p_table_name => 'AMS_METRICS_VL',
3243: -- p_pk_name => 'METRIC_ID',
3244: -- p_pk_value => l_metrics_rec.summary_metric_id
3245: -- ) = FND_API.G_TRUE

Line 3254: -- IF AMS_Utility_PVT.Check_FK_Exists (

3250: -- it's summary rollup.
3251:
3252: -- comment out the following for bug 1356700 fix
3253: -- 07/17/2000 khung
3254: -- IF AMS_Utility_PVT.Check_FK_Exists (
3255: -- p_table_name => 'AMS_METRICS_VL',
3256: -- p_pk_name => 'SUMMARY_METRIC_ID',
3257: -- p_pk_value => l_metric_id,
3258: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER

Line 3258: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER

3254: -- IF AMS_Utility_PVT.Check_FK_Exists (
3255: -- p_table_name => 'AMS_METRICS_VL',
3256: -- p_pk_name => 'SUMMARY_METRIC_ID',
3257: -- p_pk_value => l_metric_id,
3258: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER
3259: -- ) = FND_API.G_TRUE
3260: -- End of the changes made by PTENDULK on 08/19/1999
3261: -- THEN
3262: