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 337: Ams_Utility_Pvt.Debug_Message(l_full_name||': The org id is ' || l_org_id);

333: SAVEPOINT Create_Metric_pvt;
334:
335: l_org_id := fnd_profile.value('DEFAULT_ORG_ID');
336:
337: Ams_Utility_Pvt.Debug_Message(l_full_name||': The org id is ' || l_org_id);
338:
339:
340: Ams_Utility_Pvt.Debug_Message(l_full_name||': start');
341:

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

336:
337: Ams_Utility_Pvt.Debug_Message(l_full_name||': The org id is ' || l_org_id);
338:
339:
340: Ams_Utility_Pvt.Debug_Message(l_full_name||': start');
341:
342: --
343: -- Initialize message list if p_init_msg_list is set to TRUE.
344: --

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

393:
394: --
395: -- Debug message.
396: --
397: Ams_Utility_Pvt.debug_message(l_full_name ||': insert');
398:
399: IF l_metrics_rec.metric_id IS NULL THEN
400: LOOP
401: --

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

507: );
508:
509: -- Debug message.
510: --
511: Ams_Utility_Pvt.debug_message(l_full_name ||': insert TL ');
512:
513: --
514: -- Insert into the translation table.
515: --

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

573:
574: --
575: -- Add success message to message list.
576: --
577: Ams_Utility_Pvt.debug_message(l_full_name ||': end Success');
578:
579:
580: EXCEPTION
581: WHEN FND_API.G_EXC_ERROR THEN

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

656:
657: --
658: -- Output debug message.
659: --
660: Ams_Utility_Pvt.debug_message(l_full_name||': start');
661:
662: --
663: -- Initialize message list if p_init_msg_list is set to TRUE.
664: --

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

724: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
725: RAISE FND_API.g_exc_unexpected_error;
726: END IF;
727:
728: -- Ams_Utility_Pvt.debug_message(l_full_name ||': validate');
729:
730: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
731: Validate_Metric_items(
732: p_metric_rec => l_metrics_rec,

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

766: RAISE FND_API.g_exc_error;
767: END IF;
768: END IF;
769:
770: -- Ams_Utility_Pvt.debug_message(l_full_name ||': update Metrics Base Table');
771:
772: --function metric
773: IF UPPER(l_metrics_rec.metric_calculation_type) = G_FUNCTION THEN
774: IF l_metrics_rec.function_name IS NULL

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

833: RAISE FND_API.g_exc_error;
834: END IF;
835:
836: -- Debug message.
837: Ams_Utility_Pvt.debug_message(l_full_name ||': updateMetrics TL Table');
838:
839: -- Update AMS_METRICS_ALL_TL
840: UPDATE ams_metrics_all_tl
841: SET metrics_name = l_metrics_rec.metrics_name,

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

881:
882: --
883: -- Debug message.
884: --
885: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
886:
887:
888: EXCEPTION
889: WHEN FND_API.G_EXC_ERROR THEN

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

977:
978: --
979: -- Output debug message.
980: --
981: Ams_Utility_Pvt.debug_message(l_full_name||': start');
982:
983: --
984: -- Initialize message list if p_init_msg_list is set to TRUE.
985: --

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

1082: END IF;
1083: -- end addition
1084:
1085: -- Debug message.
1086: Ams_Utility_Pvt.debug_message(l_full_name ||': delete with Validation');
1087:
1088: DELETE FROM ams_metrics_all_b
1089: WHERE metric_id = p_metric_id
1090: AND object_version_number = p_object_version_number;

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

1127:
1128: --
1129: -- Debug message.
1130: --
1131: Ams_Utility_Pvt.debug_message(l_full_name ||': End');
1132:
1133:
1134: --
1135: -- Standard API to get message count, and if 1,

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

1221: BEGIN
1222: --
1223: -- Output debug message.
1224: --
1225: Ams_Utility_Pvt.debug_message(l_full_name||': start');
1226:
1227: --
1228: -- Initialize message list if p_init_msg_list is set to TRUE.
1229: --

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

1249:
1250: --
1251: -- Begin API Body
1252: --
1253: Ams_Utility_Pvt.debug_message(l_full_name||': lock');
1254:
1255:
1256: OPEN c_metrics_info;
1257: FETCH c_metrics_info INTO l_metric_id;

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

1283:
1284: --
1285: -- Debug message.
1286: --
1287: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
1288:
1289:
1290: EXCEPTION
1291: WHEN FND_API.G_EXC_ERROR THEN

Line 1304: WHEN Ams_Utility_Pvt.RESOURCE_LOCKED THEN

1300: p_encoded => FND_API.g_false,
1301: p_count => x_msg_count,
1302: p_data => x_msg_data
1303: );
1304: WHEN Ams_Utility_Pvt.RESOURCE_LOCKED THEN
1305: x_return_status := FND_API.G_RET_STS_ERROR ;
1306:
1307: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1308: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');

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

1364: BEGIN
1365: --
1366: -- Output debug message.
1367: --
1368: Ams_Utility_Pvt.debug_message(l_full_name||': start');
1369:
1370: --
1371: -- Initialize message list if p_init_msg_list is set to TRUE.
1372: --

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

1393: --
1394: -- Begin API Body.
1395: --
1396:
1397: Ams_Utility_Pvt.debug_message(l_full_name||': Validate items');
1398:
1399: -- Validate required items in the record.
1400: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1401:

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

1413: RAISE FND_API.G_EXC_ERROR;
1414: END IF;
1415: END IF;
1416:
1417: Ams_Utility_Pvt.debug_message(l_full_name||': check record');
1418:
1419: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1420: -- dmvincen 02/24/2004: set p_complete_rec to p_metric_rec from null.
1421: Validate_Metric_record(

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

1446: );
1447:
1448:
1449:
1450: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
1451:
1452:
1453:
1454: EXCEPTION

Line 1779: IF Ams_Utility_Pvt.Check_Uniqueness(

1775: AND p_metric_rec.metric_id IS NOT NULL
1776: THEN
1777: l_where_clause := ' metric_id = '||p_metric_rec.metric_id ;
1778:
1779: IF Ams_Utility_Pvt.Check_Uniqueness(
1780: p_table_name => 'ams_metrics_vl',
1781: p_where_clause => l_where_clause
1782: ) = FND_API.g_false
1783: THEN

Line 1813: IF AMS_Utility_PVT.Check_Uniqueness(

1809: p_metric_rec.metric_id;
1810:
1811: END IF;
1812:
1813: IF AMS_Utility_PVT.Check_Uniqueness(
1814: p_table_name => 'ams_metrics_vl',
1815: p_where_clause => l_where_clause
1816: ) = FND_API.g_false
1817: THEN

Line 1973: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;

1969: /*commented by sunkumar 20-april-2004 */
1970: /* l_table_name := 'AMS_METRICS_VL';
1971: l_pk_name := 'METRIC_ID';
1972: l_pk_value := l_metrics_rec.metric_parent_id;
1973: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
1974: l_additional_where_clause := ' metric_calculation_type = '''||G_ROLLUP||'''';
1975:
1976: IF Ams_Utility_Pvt.Check_FK_Exists (
1977: p_table_name => l_table_name

Line 1976: IF Ams_Utility_Pvt.Check_FK_Exists (

1972: l_pk_value := l_metrics_rec.metric_parent_id;
1973: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
1974: l_additional_where_clause := ' metric_calculation_type = '''||G_ROLLUP||'''';
1975:
1976: IF Ams_Utility_Pvt.Check_FK_Exists (
1977: p_table_name => l_table_name
1978: ,p_pk_name => l_pk_name
1979: ,p_pk_value => l_pk_value
1980: ,p_pk_data_type => l_pk_data_type

Line 2026: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;

2022:
2023: /* l_table_name := 'AMS_METRICS_VL';
2024: l_pk_name := 'METRIC_ID';
2025: l_pk_value := l_metrics_rec.summary_metric_id;
2026: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
2027: l_additional_where_clause := ' metric_calculation_type = '''||G_SUMMARY||'''';
2028:
2029: IF Ams_Utility_Pvt.Check_FK_Exists (
2030: p_table_name => l_table_name

Line 2029: IF Ams_Utility_Pvt.Check_FK_Exists (

2025: l_pk_value := l_metrics_rec.summary_metric_id;
2026: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
2027: l_additional_where_clause := ' metric_calculation_type = '''||G_SUMMARY||'''';
2028:
2029: IF Ams_Utility_Pvt.Check_FK_Exists (
2030: p_table_name => l_table_name
2031: ,p_pk_name => l_pk_name
2032: ,p_pk_value => l_pk_value
2033: ,p_pk_data_type => l_pk_data_type

Line 2074: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;

2070:
2071: /* l_table_name := 'MTL_UOM_CLASSES';
2072: l_pk_name := 'UOM_CLASS';
2073: l_pk_value := l_metrics_rec.uom_type;
2074: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
2075: l_additional_where_clause := NULL;
2076:
2077: IF Ams_Utility_Pvt.Check_FK_Exists (
2078: p_table_name => l_table_name

Line 2077: IF Ams_Utility_Pvt.Check_FK_Exists (

2073: l_pk_value := l_metrics_rec.uom_type;
2074: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
2075: l_additional_where_clause := NULL;
2076:
2077: IF Ams_Utility_Pvt.Check_FK_Exists (
2078: p_table_name => l_table_name
2079: ,p_pk_name => l_pk_name
2080: ,p_pk_value => l_pk_value
2081: ,p_pk_data_type => l_pk_data_type

Line 2122: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;

2118:
2119: /*l_table_name := 'AMS_CATEGORIES_VL';
2120: l_pk_name := 'CATEGORY_ID';
2121: l_pk_value := l_metrics_rec.metric_category;
2122: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
2123: l_additional_where_clause := ' enabled_flag = ''Y'''||
2124: ' and arc_category_created_for = ''METR''';
2125:
2126: IF Ams_Utility_Pvt.Check_FK_Exists (

Line 2126: IF Ams_Utility_Pvt.Check_FK_Exists (

2122: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
2123: l_additional_where_clause := ' enabled_flag = ''Y'''||
2124: ' and arc_category_created_for = ''METR''';
2125:
2126: IF Ams_Utility_Pvt.Check_FK_Exists (
2127: p_table_name => l_table_name
2128: ,p_pk_name => l_pk_name
2129: ,p_pk_value => l_pk_value
2130: ,p_pk_data_type => l_pk_data_type

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

2152: --
2153:
2154: -- SENSITIVE_DATA_FLAG
2155: IF l_metrics_rec.sensitive_data_flag <> FND_API.G_MISS_CHAR THEN
2156: IF Ams_Utility_Pvt.Is_Y_Or_N(l_metrics_rec.sensitive_data_flag)
2157: = FND_API.G_FALSE
2158: THEN
2159: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2160: THEN

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

2168: END IF;
2169:
2170: -- ENABLED_FLAG
2171: IF l_metrics_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN
2172: IF Ams_Utility_Pvt.Is_Y_Or_N(l_metrics_rec.enabled_flag)
2173: = FND_API.G_FALSE
2174: THEN
2175: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2176: THEN

Line 2197: IF Ams_Utility_Pvt.Check_Lookup_Exists (

2193:
2194: -- ACCRUAL_TYPE
2195: IF l_metrics_rec.accrual_type <> FND_API.G_MISS_CHAR THEN
2196: l_lookup_type := 'AMS_METRIC_ACCRUAL_TYPE';
2197: IF Ams_Utility_Pvt.Check_Lookup_Exists (
2198: p_lookup_table_name => 'AMS_LOOKUPS'
2199: ,p_lookup_type => l_lookup_type
2200: ,p_lookup_code => l_metrics_rec.accrual_type
2201: ) = FND_API.G_FALSE

Line 2218: Ams_Utility_Pvt.Check_Lookup_Exists (

2214: -- DMVINCEN 05/15/2001: Allow SUMMARY for 11.5.4.11 (change in 11.5.5).
2215: IF l_metrics_rec.metric_calculation_type <> FND_API.G_MISS_CHAR THEN
2216: l_lookup_type := 'AMS_METRIC_CALCULATION_TYPE';
2217: IF -- l_metrics_rec.metric_calculation_type <> G_SUMMARY AND
2218: Ams_Utility_Pvt.Check_Lookup_Exists (
2219: p_lookup_table_name => 'AMS_LOOKUPS'
2220: ,p_lookup_type => l_lookup_type
2221: ,p_lookup_code => l_metrics_rec.metric_calculation_type
2222: ) = FND_API.G_FALSE

Line 2238: IF Ams_Utility_Pvt.Check_Lookup_Exists (

2234:
2235: -- VALUE_TYPE
2236: IF l_metrics_rec.DISPLAY_TYPE <> FND_API.G_MISS_CHAR THEN
2237: l_lookup_type := 'AMS_METRIC_DISPLAY_TYPE';
2238: IF Ams_Utility_Pvt.Check_Lookup_Exists (
2239: p_lookup_table_name => 'AMS_LOOKUPS'
2240: ,p_lookup_type => l_lookup_type
2241: ,p_lookup_code => l_metrics_rec.DISPLAY_TYPE
2242: ) = FND_API.G_FALSE

Line 2258: IF Ams_Utility_Pvt.Check_Lookup_Exists (

2254:
2255: -- VALUE_TYPE
2256: IF l_metrics_rec.value_type <> FND_API.G_MISS_CHAR THEN
2257: l_lookup_type := 'AMS_METRIC_VALUE_TYPE';
2258: IF Ams_Utility_Pvt.Check_Lookup_Exists (
2259: p_lookup_table_name => 'AMS_LOOKUPS'
2260: ,p_lookup_type => l_lookup_type
2261: ,p_lookup_code => l_metrics_rec.value_type
2262: ) = FND_API.G_FALSE

Line 2308: -- IF AMS_Utility_PVT.Check_Lookup_Exists (

2304: OR (l_metrics_rec.arc_metric_used_for_object <> 'ANY'
2305: AND l_metrics_rec.metric_calculation_type in (G_ROLLUP, G_SUMMARY))
2306:
2307: -- l_lookup_type := 'AMS_SYS_ARC_QUALIFIER';
2308: -- IF AMS_Utility_PVT.Check_Lookup_Exists (
2309: -- p_lookup_table_name => 'AMS_LOOKUPS'
2310: -- ,p_lookup_type => l_lookup_type
2311: -- ,p_lookup_code => l_metrics_rec.arc_metric_used_for_object
2312: -- ) = FND_API.G_FALSE

Line 2585: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;

2581:
2582: /*l_table_name := 'AMS_CATEGORIES_VL';
2583: l_pk_name := 'CATEGORY_ID';
2584: l_pk_value := p_complete_rec.metric_sub_category;
2585: l_pk_data_type := Ams_Utility_Pvt.G_NUMBER;
2586: l_additional_where_clause := ' enabled_flag = ''Y'''||
2587: ' and arc_category_created_for = ''METR'''||
2588: ' and parent_category_id = '||
2589: p_complete_rec.metric_category;

Line 2591: IF Ams_Utility_Pvt.Check_FK_Exists (

2587: ' and arc_category_created_for = ''METR'''||
2588: ' and parent_category_id = '||
2589: p_complete_rec.metric_category;
2590:
2591: IF Ams_Utility_Pvt.Check_FK_Exists (
2592: p_table_name => l_table_name
2593: ,p_pk_name => l_pk_name
2594: ,p_pk_value => l_pk_value
2595: ,p_pk_data_type => l_pk_data_type

Line 2620: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;

2616: -- END IF;
2617: /* l_table_name := 'MTL_UNITS_OF_MEASURE';
2618: l_pk_name := 'UOM_CODE';
2619: l_pk_value := p_complete_rec.default_uom_code;
2620: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
2621: l_additional_where_clause := ' uom_class = '''||p_complete_rec.uom_type||'''';
2622:
2623: IF Ams_Utility_Pvt.Check_FK_Exists (
2624: p_table_name => l_table_name

Line 2623: IF Ams_Utility_Pvt.Check_FK_Exists (

2619: l_pk_value := p_complete_rec.default_uom_code;
2620: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
2621: l_additional_where_clause := ' uom_class = '''||p_complete_rec.uom_type||'''';
2622:
2623: IF Ams_Utility_Pvt.Check_FK_Exists (
2624: p_table_name => l_table_name
2625: ,p_pk_name => l_pk_name
2626: ,p_pk_value => l_pk_value
2627: ,p_pk_data_type => l_pk_data_type

Line 2748: l_name := AMS_UTILITY_PVT.get_lookup_meaning(

2744: END IF;
2745: IF l_object_type <> p_complete_rec.arc_metric_used_for_object THEN
2746: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2747: FND_MESSAGE.Set_Name ('AMS', 'AMS_METR_INVALID_MULTI_OBJ');
2748: l_name := AMS_UTILITY_PVT.get_lookup_meaning(
2749: 'AMS_METRIC_OBJECT_TYPE',l_object_type);
2750: FND_MESSAGE.set_token('OBJECT',
2751: NVL(l_name,l_object_type), FALSE);
2752: FND_MSG_PUB.ADD;

Line 2759: l_name := AMS_UTILITY_PVT.get_lookup_meaning(

2755: END IF;
2756: IF l_calculation_type NOT IN (G_MANUAL, G_FUNCTION) THEN
2757: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2758: FND_MESSAGE.Set_Name ('AMS', 'AMS_METR_INVALID_MULTI_CALC');
2759: l_name := AMS_UTILITY_PVT.get_lookup_meaning(
2760: 'AMS_METRIC_CALCULATION_TYPE',l_calculation_type);
2761: FND_MESSAGE.set_token('CALCULATION',
2762: NVL(l_name,l_calculation_type), FALSE);
2763: FND_MSG_PUB.ADD;

Line 3184: /*IF Ams_Utility_Pvt.Check_FK_Exists (

3180:
3181:
3182:
3183: -- AMS_ACT_METRICS_ALL
3184: /*IF Ams_Utility_Pvt.Check_FK_Exists (
3185: p_table_name => 'AMS_ACT_METRICS_ALL',
3186: p_pk_name => 'METRIC_ID',
3187: p_pk_value => l_metric_id,
3188: p_pk_data_type => Ams_Utility_Pvt.G_NUMBER

Line 3188: p_pk_data_type => Ams_Utility_Pvt.G_NUMBER

3184: /*IF Ams_Utility_Pvt.Check_FK_Exists (
3185: p_table_name => 'AMS_ACT_METRICS_ALL',
3186: p_pk_name => 'METRIC_ID',
3187: p_pk_value => l_metric_id,
3188: p_pk_data_type => Ams_Utility_Pvt.G_NUMBER
3189: ) = FND_API.G_TRUE
3190: THEN
3191: x_return_status := FND_API.G_RET_STS_ERROR;
3192: RETURN;

Line 3207: -- IF AMS_Utility_PVT.Check_FK_Exists (

3203: -- id of any other id
3204:
3205: -- Original Code
3206:
3207: -- IF AMS_Utility_PVT.Check_FK_Exists (
3208: -- p_table_name => 'AMS_METRICS_VL',
3209: -- p_pk_name => 'METRIC_ID',
3210: -- p_pk_value => l_metrics_rec.metric_parent_id
3211: -- ) = FND_API.G_TRUE

Line 3221: -- IF AMS_Utility_PVT.Check_FK_Exists (

3217: -- it's parent.
3218:
3219: -- comment out the following for bug 1356700 fix
3220: -- 07/17/2000 khung
3221: -- IF AMS_Utility_PVT.Check_FK_Exists (
3222: -- p_table_name => 'AMS_METRICS_VL',
3223: -- p_pk_name => 'METRIC_PARENT_ID',
3224: -- p_pk_value => l_metric_id,
3225: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER

Line 3225: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER

3221: -- IF AMS_Utility_PVT.Check_FK_Exists (
3222: -- p_table_name => 'AMS_METRICS_VL',
3223: -- p_pk_name => 'METRIC_PARENT_ID',
3224: -- p_pk_value => l_metric_id,
3225: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER
3226: -- ) = FND_API.G_TRUE
3227: -- End of the changes made by PTENDULK on 08/19/1999
3228: -- THEN
3229: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 3248: -- IF AMS_Utility_PVT.Check_FK_Exists (

3244: -- Start of the changes made by PTENDULK on 08/19/1999
3245: -- The check is modified to check whether this metric id is Summary metric
3246: -- id of any other metric id
3247: -- Original Code
3248: -- IF AMS_Utility_PVT.Check_FK_Exists (
3249: -- p_table_name => 'AMS_METRICS_VL',
3250: -- p_pk_name => 'METRIC_ID',
3251: -- p_pk_value => l_metrics_rec.summary_metric_id
3252: -- ) = FND_API.G_TRUE

Line 3261: -- IF AMS_Utility_PVT.Check_FK_Exists (

3257: -- it's summary rollup.
3258:
3259: -- comment out the following for bug 1356700 fix
3260: -- 07/17/2000 khung
3261: -- IF AMS_Utility_PVT.Check_FK_Exists (
3262: -- p_table_name => 'AMS_METRICS_VL',
3263: -- p_pk_name => 'SUMMARY_METRIC_ID',
3264: -- p_pk_value => l_metric_id,
3265: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER

Line 3265: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER

3261: -- IF AMS_Utility_PVT.Check_FK_Exists (
3262: -- p_table_name => 'AMS_METRICS_VL',
3263: -- p_pk_name => 'SUMMARY_METRIC_ID',
3264: -- p_pk_value => l_metric_id,
3265: -- p_pk_data_type => AMS_Utility_PVT.G_NUMBER
3266: -- ) = FND_API.G_TRUE
3267: -- End of the changes made by PTENDULK on 08/19/1999
3268: -- THEN
3269: