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_FORMULA_PVT dependencies on AMS_UTILITY_PVT

Line 298: AMS_Utility_PVT.Debug_Message(l_full_name||': start');

294:
295: SAVEPOINT Execute_Formula_Pvt;
296:
297: IF G_DEBUG THEN
298: AMS_Utility_PVT.Debug_Message(l_full_name||': start');
299: END IF;
300:
301: --
302: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 960: IF AMS_Utility_PVT.check_lookup_exists(p_lookup_type => 'AMS_FORMULA_TYPE',

956:
957: IF l_formula_rec.formula_type <> FND_API.G_MISS_CHAR THEN
958:
959:
960: IF AMS_Utility_PVT.check_lookup_exists(p_lookup_type => 'AMS_FORMULA_TYPE',
961: p_lookup_code => l_formula_rec.formula_type) = FND_API.g_false THEN
962:
963: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
964: FND_MESSAGE.set_name('AMS', 'AMS_FML_INVALID_TYPE');

Line 1015: IF AMS_Utility_PVT.check_lookup_exists(p_lookup_type => 'AMS_FORMULA_ENT_TYPE',

1011:
1012: IF l_formula_entry_rec.formula_entry_type <> FND_API.G_MISS_CHAR THEN
1013:
1014:
1015: IF AMS_Utility_PVT.check_lookup_exists(p_lookup_type => 'AMS_FORMULA_ENT_TYPE',
1016: p_lookup_code => l_formula_entry_rec.formula_entry_type) = FND_API.g_false THEN
1017:
1018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1019: FND_MESSAGE.set_name('AMS', 'AMS_FML_ENT_INVALID_TYPE');

Line 1033: IF AMS_Utility_PVT.check_lookup_exists(p_lookup_type => 'AMS_FORMULA_OPERATOR',

1029:
1030: IF l_formula_entry_rec.formula_entry_operator IS NOT NULL AND l_formula_entry_rec.formula_entry_operator <> FND_API.G_MISS_CHAR THEN
1031:
1032:
1033: IF AMS_Utility_PVT.check_lookup_exists(p_lookup_type => 'AMS_FORMULA_OPERATOR',
1034: p_lookup_code => l_formula_entry_rec.formula_entry_operator) = FND_API.g_false THEN
1035:
1036: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1037: FND_MESSAGE.set_name('AMS', 'AMS_FML_ENT_INVALID_OP');

Line 1086: IF AMS_Utility_PVT.Check_FK_Exists (

1082: x_return_status := FND_API.g_ret_sts_success;
1083:
1084: IF (l_formula_rec.activity_metric_id <> FND_API.G_MISS_NUM) THEN
1085:
1086: IF AMS_Utility_PVT.Check_FK_Exists (
1087: p_table_name => 'AMS_ACT_METRICS_ALL'
1088: ,p_pk_name => 'ACTIVITY_METRIC_ID'
1089: ,p_pk_value => l_formula_rec.activity_metric_id
1090: ,p_pk_data_type => NULL

Line 1144: IF AMS_Utility_PVT.Check_FK_Exists (

1140: x_return_status := FND_API.g_ret_sts_success;
1141:
1142: IF (l_formula_entry_rec.formula_id <> FND_API.G_MISS_NUM) THEN
1143:
1144: IF AMS_Utility_PVT.Check_FK_Exists (
1145: p_table_name => 'AMS_ACT_METRIC_FORMULAS'
1146: ,p_pk_name => 'FORMULA_ID'
1147: ,p_pk_value => l_formula_entry_rec.formula_id
1148: ,p_pk_data_type => NULL

Line 1324: AMS_Utility_PVT.debug_message(l_full_name||': start');

1320: --
1321: -- Output debug message.
1322: --
1323: IF G_DEBUG THEN
1324: AMS_Utility_PVT.debug_message(l_full_name||': start');
1325: END IF;
1326:
1327: --
1328: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1355: AMS_Utility_PVT.debug_message(l_full_name||': Validate items');

1351: -- Begin API Body.
1352: --
1353:
1354: IF G_DEBUG THEN
1355: AMS_Utility_PVT.debug_message(l_full_name||': Validate items');
1356: END IF;
1357:
1358: -- Validate required items in the record.
1359: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1376: AMS_Utility_PVT.debug_message(l_full_name||': check record');

1372: END IF;
1373: END IF;
1374:
1375: IF G_DEBUG THEN
1376: AMS_Utility_PVT.debug_message(l_full_name||': check record');
1377: END IF;
1378:
1379: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1380: Validate_Formula_Rec(

Line 1388: AMS_Utility_PVT.debug_message(l_full_name||': error in check record');

1384: );
1385:
1386: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1387: IF G_DEBUG THEN
1388: AMS_Utility_PVT.debug_message(l_full_name||': error in check record');
1389: END IF;
1390: RAISE FND_API.g_exc_unexpected_error;
1391: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1392: IF G_DEBUG THEN

Line 1393: AMS_Utility_PVT.debug_message(l_full_name||': error in check record');

1389: END IF;
1390: RAISE FND_API.g_exc_unexpected_error;
1391: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1392: IF G_DEBUG THEN
1393: AMS_Utility_PVT.debug_message(l_full_name||': error in check record');
1394: END IF;
1395: RAISE FND_API.g_exc_error;
1396: END IF;
1397: END IF;

Line 1400: AMS_Utility_PVT.debug_message(l_full_name||': after check record');

1396: END IF;
1397: END IF;
1398:
1399: IF G_DEBUG THEN
1400: AMS_Utility_PVT.debug_message(l_full_name||': after check record');
1401: END IF;
1402:
1403:
1404: --

Line 1419: AMS_Utility_PVT.debug_message(l_full_name ||': end');

1415: p_encoded => FND_API.G_FALSE
1416: );
1417:
1418: IF G_DEBUG THEN
1419: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1420: END IF;
1421:
1422:
1423: EXCEPTION

Line 1486: AMS_Utility_PVT.debug_message(l_full_name||': start');

1482: --
1483: -- Output debug message.
1484: --
1485: IF G_DEBUG THEN
1486: AMS_Utility_PVT.debug_message(l_full_name||': start');
1487: END IF;
1488:
1489: --
1490: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1517: AMS_Utility_PVT.debug_message(l_full_name||': Validate items');

1513: -- Begin API Body.
1514: --
1515:
1516: IF G_DEBUG THEN
1517: AMS_Utility_PVT.debug_message(l_full_name||': Validate items');
1518: END IF;
1519:
1520: -- Validate required items in the record.
1521: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1538: AMS_Utility_PVT.debug_message(l_full_name||': check record');

1534: END IF;
1535: END IF;
1536:
1537: IF G_DEBUG THEN
1538: AMS_Utility_PVT.debug_message(l_full_name||': check record');
1539: END IF;
1540:
1541: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1542: Validate_Form_Ent_Rec(

Line 1550: AMS_Utility_PVT.debug_message(l_full_name||': error in check record');

1546: );
1547:
1548: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1549: IF G_DEBUG THEN
1550: AMS_Utility_PVT.debug_message(l_full_name||': error in check record');
1551: END IF;
1552: RAISE FND_API.g_exc_unexpected_error;
1553: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1554: IF G_DEBUG THEN

Line 1555: AMS_Utility_PVT.debug_message(l_full_name||': error in check record');

1551: END IF;
1552: RAISE FND_API.g_exc_unexpected_error;
1553: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1554: IF G_DEBUG THEN
1555: AMS_Utility_PVT.debug_message(l_full_name||': error in check record');
1556: END IF;
1557: RAISE FND_API.g_exc_error;
1558: END IF;
1559: END IF;

Line 1562: AMS_Utility_PVT.debug_message(l_full_name||': after check record');

1558: END IF;
1559: END IF;
1560:
1561: IF G_DEBUG THEN
1562: AMS_Utility_PVT.debug_message(l_full_name||': after check record');
1563: END IF;
1564:
1565:
1566: --

Line 1581: AMS_Utility_PVT.debug_message(l_full_name ||': end');

1577: p_encoded => FND_API.G_FALSE
1578: );
1579:
1580: IF G_DEBUG THEN
1581: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1582: END IF;
1583:
1584:
1585: EXCEPTION

Line 1672: AMS_Utility_PVT.Debug_Message(l_full_name||': start');

1668:
1669: SAVEPOINT Create_Formula_Pvt;
1670:
1671: IF G_DEBUG THEN
1672: AMS_Utility_PVT.Debug_Message(l_full_name||': start');
1673: END IF;
1674:
1675: --
1676: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1767: AMS_Utility_PVT.debug_message(l_full_name ||': insert');

1763: --
1764: -- Debug message.
1765: --
1766: IF G_DEBUG THEN
1767: AMS_Utility_PVT.debug_message(l_full_name ||': insert');
1768: END IF;
1769:
1770:
1771:

Line 1844: AMS_Utility_PVT.debug_message(l_full_name ||': end Success');

1840: -- Add success message to message list.
1841: --
1842:
1843: IF G_DEBUG THEN
1844: AMS_Utility_PVT.debug_message(l_full_name ||': end Success');
1845: END IF;
1846:
1847:
1848:

Line 1948: AMS_Utility_PVT.Debug_Message(l_full_name||': start');

1944:
1945: SAVEPOINT Create_Formula_Entry_Pvt;
1946:
1947: IF G_DEBUG THEN
1948: AMS_Utility_PVT.Debug_Message(l_full_name||': start');
1949: END IF;
1950:
1951: --
1952: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2043: AMS_Utility_PVT.debug_message(l_full_name ||': insert');

2039: --
2040: -- Debug message.
2041: --
2042: IF G_DEBUG THEN
2043: AMS_Utility_PVT.debug_message(l_full_name ||': insert');
2044: END IF;
2045:
2046:
2047:

Line 2124: AMS_Utility_PVT.debug_message(l_full_name ||': end Success');

2120: -- Add success message to message list.
2121: --
2122:
2123: IF G_DEBUG THEN
2124: AMS_Utility_PVT.debug_message(l_full_name ||': end Success');
2125: END IF;
2126:
2127:
2128:

Line 2213: AMS_Utility_PVT.debug_message(l_full_name||': start');

2209: --
2210: -- Output debug message.
2211: --
2212: IF G_DEBUG THEN
2213: AMS_Utility_PVT.debug_message(l_full_name||': start');
2214: END IF;
2215:
2216: --
2217: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2263: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

2259: END IF;
2260:
2261:
2262: IF G_DEBUG THEN
2263: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
2264: END IF;
2265:
2266:
2267:

Line 2304: AMS_Utility_PVT.debug_message(l_full_name ||': Update Activity Metric Formulas Table');

2300: END IF;
2301:
2302:
2303: IF G_DEBUG THEN
2304: AMS_Utility_PVT.debug_message(l_full_name ||': Update Activity Metric Formulas Table');
2305: END IF;
2306:
2307: UPDATE ams_act_metric_formulas SET
2308: activity_metric_id = l_formula_rec.activity_metric_id,

Line 2354: AMS_Utility_PVT.debug_message(l_full_name ||': end');

2350: --
2351: -- Debug message.
2352: --
2353: IF G_DEBUG THEN
2354: AMS_Utility_PVT.debug_message(l_full_name ||': end');
2355: END IF;
2356:
2357:
2358: EXCEPTION

Line 2438: AMS_Utility_PVT.debug_message(l_full_name||': start');

2434: --
2435: -- Output debug message.
2436: --
2437: IF G_DEBUG THEN
2438: AMS_Utility_PVT.debug_message(l_full_name||': start');
2439: END IF;
2440:
2441: --
2442: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2488: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

2484: END IF;
2485:
2486:
2487: IF G_DEBUG THEN
2488: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
2489: END IF;
2490:
2491:
2492:

Line 2528: AMS_Utility_PVT.debug_message(l_full_name ||': Update Activity Metric Formula Entry Table');

2524: END IF;
2525:
2526:
2527: IF G_DEBUG THEN
2528: AMS_Utility_PVT.debug_message(l_full_name ||': Update Activity Metric Formula Entry Table');
2529: END IF;
2530:
2531: UPDATE ams_act_metric_form_ent SET
2532: formula_id = l_formula_entry_rec.formula_id

Line 2582: AMS_Utility_PVT.debug_message(l_full_name ||': end');

2578: --
2579: -- Debug message.
2580: --
2581: IF G_DEBUG THEN
2582: AMS_Utility_PVT.debug_message(l_full_name ||': end');
2583: END IF;
2584:
2585:
2586: EXCEPTION

Line 2658: AMS_Utility_PVT.debug_message(l_full_name||': start');

2654: --
2655: -- Output debug message.
2656: --
2657: IF G_DEBUG THEN
2658: AMS_Utility_PVT.debug_message(l_full_name||': start');
2659: END IF;
2660:
2661: --
2662: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2690: AMS_Utility_PVT.debug_message(l_full_name ||': delete with Validation');

2686: --
2687:
2688: -- Debug message.
2689: IF G_DEBUG THEN
2690: AMS_Utility_PVT.debug_message(l_full_name ||': delete with Validation');
2691:
2692: AMS_Utility_PVT.debug_message('formula id '||to_char(p_formula_id));
2693:
2694: AMS_Utility_PVT.debug_message('object version number '||to_char(p_object_version_number));

Line 2692: AMS_Utility_PVT.debug_message('formula id '||to_char(p_formula_id));

2688: -- Debug message.
2689: IF G_DEBUG THEN
2690: AMS_Utility_PVT.debug_message(l_full_name ||': delete with Validation');
2691:
2692: AMS_Utility_PVT.debug_message('formula id '||to_char(p_formula_id));
2693:
2694: AMS_Utility_PVT.debug_message('object version number '||to_char(p_object_version_number));
2695: END IF;
2696:

Line 2694: AMS_Utility_PVT.debug_message('object version number '||to_char(p_object_version_number));

2690: AMS_Utility_PVT.debug_message(l_full_name ||': delete with Validation');
2691:
2692: AMS_Utility_PVT.debug_message('formula id '||to_char(p_formula_id));
2693:
2694: AMS_Utility_PVT.debug_message('object version number '||to_char(p_object_version_number));
2695: END IF;
2696:
2697: DELETE
2698: FROM ams_act_metric_formulas

Line 2728: AMS_Utility_PVT.debug_message(l_full_name ||': End');

2724: --
2725: -- Debug message.
2726: --
2727: IF G_DEBUG THEN
2728: AMS_Utility_PVT.debug_message(l_full_name ||': End');
2729: END IF;
2730:
2731:
2732: --

Line 2813: AMS_Utility_PVT.debug_message(l_full_name||': start');

2809: --
2810: -- Output debug message.
2811: --
2812: IF G_DEBUG THEN
2813: AMS_Utility_PVT.debug_message(l_full_name||': start');
2814: END IF;
2815:
2816: --
2817: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2845: AMS_Utility_PVT.debug_message(l_full_name ||': delete with Validation');

2841: --
2842:
2843: -- Debug message.
2844: IF G_DEBUG THEN
2845: AMS_Utility_PVT.debug_message(l_full_name ||': delete with Validation');
2846:
2847: AMS_Utility_PVT.debug_message('formula id '||to_char(p_formula_entry_id));
2848:
2849: AMS_Utility_PVT.debug_message('object version number '||to_char(p_object_version_number));

Line 2847: AMS_Utility_PVT.debug_message('formula id '||to_char(p_formula_entry_id));

2843: -- Debug message.
2844: IF G_DEBUG THEN
2845: AMS_Utility_PVT.debug_message(l_full_name ||': delete with Validation');
2846:
2847: AMS_Utility_PVT.debug_message('formula id '||to_char(p_formula_entry_id));
2848:
2849: AMS_Utility_PVT.debug_message('object version number '||to_char(p_object_version_number));
2850: END IF;
2851:

Line 2849: AMS_Utility_PVT.debug_message('object version number '||to_char(p_object_version_number));

2845: AMS_Utility_PVT.debug_message(l_full_name ||': delete with Validation');
2846:
2847: AMS_Utility_PVT.debug_message('formula id '||to_char(p_formula_entry_id));
2848:
2849: AMS_Utility_PVT.debug_message('object version number '||to_char(p_object_version_number));
2850: END IF;
2851:
2852: DELETE
2853: FROM ams_act_metric_form_ent

Line 2879: AMS_Utility_PVT.debug_message(l_full_name ||': End');

2875: --
2876: -- Debug message.
2877: --
2878: IF G_DEBUG THEN
2879: AMS_Utility_PVT.debug_message(l_full_name ||': End');
2880: END IF;
2881:
2882:
2883: --

Line 2965: AMS_Utility_PVT.debug_message(l_full_name||': start');

2961: --
2962: -- Output debug message.
2963: --
2964: IF G_DEBUG THEN
2965: AMS_Utility_PVT.debug_message(l_full_name||': start');
2966: END IF;
2967:
2968: --
2969: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2995: AMS_Utility_PVT.debug_message(l_full_name||': lock');

2991: --
2992: -- Begin API Body
2993: --
2994: IF G_DEBUG THEN
2995: AMS_Utility_PVT.debug_message(l_full_name||': lock');
2996: END IF;
2997:
2998: OPEN c_formula_info;
2999: FETCH c_formula_info INTO l_formula_id;

Line 3028: AMS_Utility_PVT.debug_message(l_full_name ||': end');

3024: --
3025: -- Debug message.
3026: --
3027: IF G_DEBUG THEN
3028: AMS_Utility_PVT.debug_message(l_full_name ||': end');
3029: END IF;
3030:
3031:
3032: EXCEPTION

Line 3045: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN

3041: FND_MSG_PUB.Count_And_Get (
3042: p_count => x_msg_count,
3043: p_data => x_msg_data
3044: );
3045: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN
3046: x_return_status := FND_API.G_RET_STS_ERROR ;
3047:
3048: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3049: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');

Line 3115: AMS_Utility_PVT.debug_message(l_full_name||': start');

3111: --
3112: -- Output debug message.
3113: --
3114: IF G_DEBUG THEN
3115: AMS_Utility_PVT.debug_message(l_full_name||': start');
3116: END IF;
3117:
3118: --
3119: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3145: AMS_Utility_PVT.debug_message(l_full_name||': lock');

3141: --
3142: -- Begin API Body
3143: --
3144: IF G_DEBUG THEN
3145: AMS_Utility_PVT.debug_message(l_full_name||': lock');
3146: END IF;
3147:
3148: OPEN c_formula_entry_info;
3149: FETCH c_formula_entry_info INTO l_formula_entry_id;

Line 3178: AMS_Utility_PVT.debug_message(l_full_name ||': end');

3174: --
3175: -- Debug message.
3176: --
3177: IF G_DEBUG THEN
3178: AMS_Utility_PVT.debug_message(l_full_name ||': end');
3179: END IF;
3180:
3181:
3182: EXCEPTION

Line 3195: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN

3191: FND_MSG_PUB.Count_And_Get (
3192: p_count => x_msg_count,
3193: p_data => x_msg_data
3194: );
3195: WHEN AMS_Utility_PVT.RESOURCE_LOCKED THEN
3196: x_return_status := FND_API.G_RET_STS_ERROR ;
3197:
3198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3199: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');