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

Line 1001: -- currency conversions with centralized AMS_UTILITY_PVT

997: -- 10/25/1999 ptendulk Created
998: -- 08/28/2000 SVEERAVE Modified to convert/default metric values with
999: -- currencies and with out currencies in case of manual
1000: -- or non-manual type metrics. Replaced API call for
1001: -- currency conversions with centralized AMS_UTILITY_PVT
1002: -- api.
1003: -- 10/11/2000 SVEERAVE Defaulted trans_currency_code to be that of parent
1004: -- object's
1005: -- End of comments

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

1648: --
1649: --SAVEPOINT Create_ActMetric2_pvt;
1650:
1651: IF (AMS_DEBUG_HIGH_ON) THEN
1652: Ams_Utility_Pvt.Debug_Message(l_full_name||': start');
1653: END IF;
1654:
1655:
1656: l_org_id := fnd_profile.value('DEFAULT_ORG_ID');

Line 1702: Ams_Utility_Pvt.Debug_Message(l_full_name||': ignore metric id: ' || p_act_metric_rec.metric_id);

1698: AND UPPER(l_met_info.metric_calculation_type) IN ('MANUAL', 'FUNCTION') THEN
1699: -- choang - 26-dec-2002 - ignore the metric when create activity metric
1700: -- requested.
1701: IF (AMS_DEBUG_HIGH_ON) THEN
1702: Ams_Utility_Pvt.Debug_Message(l_full_name||': ignore metric id: ' || p_act_metric_rec.metric_id);
1703: END IF;
1704:
1705: RETURN;
1706: -- l_return_status := Fnd_Api.G_RET_STS_ERROR;

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

1821: --
1822: -- Debug message.
1823: --
1824: IF (AMS_DEBUG_HIGH_ON) THEN
1825: Ams_Utility_Pvt.debug_message(l_full_name ||': insert');
1826: END IF;
1827:
1828: IF l_act_metrics_rec.activity_metric_id IS NULL THEN
1829: LOOP

Line 1847: Ams_Utility_Pvt.Debug_Message(l_full_name||': The org id is ' || l_org_id);

1843:
1844:
1845:
1846: IF (AMS_DEBUG_HIGH_ON) THEN
1847: Ams_Utility_Pvt.Debug_Message(l_full_name||': The org id is ' || l_org_id);
1848: END IF;
1849: --
1850: -- Insert into the base table.
1851: --

Line 2025: Ams_Utility_Pvt.Debug_Message(l_full_name||': Variable Metric id='||

2021: AND l_accrual_type = G_VARIABLE
2022: AND l_compute_using_function IS NOT NULL THEN
2023:
2024: IF (AMS_DEBUG_HIGH_ON) THEN
2025: Ams_Utility_Pvt.Debug_Message(l_full_name||': Variable Metric id='||
2026: l_act_metrics_rec.metric_id);
2027: Ams_Utility_Pvt.Debug_Message(l_full_name||': compute_using_function='||
2028: l_compute_using_function||'.');
2029: END IF;

Line 2027: Ams_Utility_Pvt.Debug_Message(l_full_name||': compute_using_function='||

2023:
2024: IF (AMS_DEBUG_HIGH_ON) THEN
2025: Ams_Utility_Pvt.Debug_Message(l_full_name||': Variable Metric id='||
2026: l_act_metrics_rec.metric_id);
2027: Ams_Utility_Pvt.Debug_Message(l_full_name||': compute_using_function='||
2028: l_compute_using_function||'.');
2029: END IF;
2030:
2031: -- Check for a multiplier metric.

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

2122: --
2123: -- Add success message to message list.
2124: --
2125: IF (AMS_DEBUG_HIGH_ON) THEN
2126: Ams_Utility_Pvt.debug_message(l_full_name ||': end Success');
2127: END IF;
2128:
2129: /*
2130: EXCEPTION

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

2228:
2229:
2230: IF (AMS_DEBUG_HIGH_ON) THEN
2231:
2232: Ams_Utility_Pvt.debug_message('Now updating act met id: '||p_act_metric_rec.activity_metric_id);
2233:
2234: END IF;
2235: --
2236: -- Initialize savepoint.

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

2239: --
2240: -- Output debug message.
2241: --
2242: IF (AMS_DEBUG_HIGH_ON) THEN
2243: Ams_Utility_Pvt.debug_message(l_full_name||': start');
2244: END IF;
2245: --
2246: -- Initialize message list if p_init_msg_list is set to TRUE.
2247: --

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

2270: --
2271: -- Debug Message
2272:
2273: IF (AMS_DEBUG_HIGH_ON) THEN
2274: Ams_Utility_Pvt.debug_message(l_full_name ||': validate');
2275: END IF;
2276:
2277: -- BUG4391308: Added locking to prevent overwriting.
2278: Lock_ActMetric ( 1.0, fnd_api.G_FALSE,

Line 2295: Ams_Utility_Pvt.debug_message(l_full_name ||': select calc type, metric_id ='||l_actmet_rec.metric_id);

2291: Complete_ActMetric_Rec(p_act_metric_rec, l_actmet_rec);
2292:
2293:
2294: IF (AMS_DEBUG_HIGH_ON) THEN
2295: Ams_Utility_Pvt.debug_message(l_full_name ||': select calc type, metric_id ='||l_actmet_rec.metric_id);
2296: END IF;
2297:
2298: SELECT metric_calculation_type
2299: INTO l_calc_type

Line 2395: -- Ams_Utility_Pvt.debug_message('You can not post this cost!');

2391: -- Fnd_Msg_Pub.Initialize;
2392: Fnd_Message.set_name('AMS', 'AMS_MET_NO_POST');
2393: Fnd_Msg_Pub.ADD;
2394: --IF (AMS_DEBUG_HIGH_ON) THEN
2395: -- Ams_Utility_Pvt.debug_message('You can not post this cost!');
2396: --END IF;
2397: END IF;
2398: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
2399: RAISE Fnd_Api.g_exc_unexpected_error;

Line 2406: Ams_Utility_Pvt.debug_message(l_full_name ||': update Activity Metrics Table');

2402: END IF;
2403: END IF;
2404:
2405: IF (AMS_DEBUG_HIGH_ON) THEN
2406: Ams_Utility_Pvt.debug_message(l_full_name ||': update Activity Metrics Table');
2407: END IF;
2408:
2409: -- Update AMS_ACT_METRICS_ALL
2410: UPDATE ams_act_metrics_all

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

2547: --
2548: -- Debug message.
2549: --
2550: IF (AMS_DEBUG_HIGH_ON) THEN
2551: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
2552: END IF;
2553:
2554:
2555: EXCEPTION

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

2742: --
2743: -- Output debug message.
2744: --
2745: IF (AMS_DEBUG_HIGH_ON) THEN
2746: Ams_Utility_Pvt.debug_message(l_full_name||': start');
2747: END IF;
2748:
2749: --
2750: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2843: l_object_name := ams_utility_pvt.get_lookup_meaning(

2839: IF (l_freeze_status = Fnd_Api.G_TRUE) THEN
2840: -- frozen to create the record
2841: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2842: -- sunkumar 04/30/2003 added message for delete status of objects depending on status (ACTIVE, CANCELLED, COMPLETED)
2843: l_object_name := ams_utility_pvt.get_lookup_meaning(
2844: 'AMS_SYS_ARC_QUALIFIER',l_act_metric_rec.arc_act_metric_used_by);
2845: Fnd_Message.Set_Name('AMS', 'AMS_METR_DELETE');
2846: Fnd_Message.set_token('OBJECT', l_object_name);
2847: Fnd_Msg_Pub.ADD;

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

2884: END IF;
2885:
2886: -- Debug message.
2887: IF (AMS_DEBUG_HIGH_ON) THEN
2888: Ams_Utility_Pvt.debug_message(l_full_name ||': delete with Validation');
2889: END IF;
2890:
2891: -- huili added on 05/07/2001 to check dependent activity metrics
2892: l_depend_act_met_id := NULL;

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

2951: --
2952: -- Debug message.
2953: --
2954: IF (AMS_DEBUG_HIGH_ON) THEN
2955: Ams_Utility_Pvt.debug_message(l_full_name ||': End');
2956: END IF;
2957:
2958: --
2959: -- Standard API to get message count, and if 1,

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

3068: --
3069: -- Output debug message.
3070: --
3071: IF (AMS_DEBUG_HIGH_ON) THEN
3072: Ams_Utility_Pvt.debug_message(l_full_name||': start');
3073: END IF;
3074:
3075: --
3076: -- Initialize message list if p_init_msg_list is set to TRUE.

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

3201: --
3202: -- Debug message.
3203: --
3204: IF (AMS_DEBUG_HIGH_ON) THEN
3205: Ams_Utility_Pvt.debug_message(l_full_name ||': End');
3206: END IF;
3207:
3208: --
3209: -- Standard API to get message count, and if 1,

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

3296: --
3297: -- Output debug message.
3298: --
3299: IF (AMS_DEBUG_HIGH_ON) THEN
3300: Ams_Utility_Pvt.debug_message(l_full_name||': start');
3301: END IF;
3302:
3303: --
3304: -- Initialize message list if p_init_msg_list is set to TRUE.

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

3326: --
3327: -- Begin API Body
3328: --
3329: IF (AMS_DEBUG_HIGH_ON) THEN
3330: Ams_Utility_Pvt.debug_message(l_full_name||': lock');
3331: END IF;
3332:
3333:
3334: OPEN c_act_metrics_info;

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

3370: --
3371: -- Debug message.
3372: --
3373: IF (AMS_DEBUG_HIGH_ON) THEN
3374: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
3375: END IF;
3376:
3377:
3378: EXCEPTION

Line 3393: WHEN Ams_Utility_Pvt.RESOURCE_LOCKED THEN

3389: p_count => x_msg_count,
3390: p_data => x_msg_data,
3391: p_encoded => FND_API.G_FALSE
3392: );
3393: WHEN Ams_Utility_Pvt.RESOURCE_LOCKED THEN
3394: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
3395:
3396: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3397: Fnd_Message.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');

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

3453: --
3454: -- Output debug message.
3455: --
3456: IF (AMS_DEBUG_HIGH_ON) THEN
3457: Ams_Utility_Pvt.debug_message(l_full_name||': start');
3458: END IF;
3459:
3460: --
3461: -- Initialize message list if p_init_msg_list is set to TRUE.

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

3484: -- Begin API Body.
3485: --
3486:
3487: IF (AMS_DEBUG_HIGH_ON) THEN
3488: Ams_Utility_Pvt.debug_message(l_full_name||': Validate items');
3489: END IF;
3490:
3491: -- Validate required items in the record.
3492: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

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

3505: END IF;
3506: END IF;
3507:
3508: IF (AMS_DEBUG_HIGH_ON) THEN
3509: Ams_Utility_Pvt.debug_message(l_full_name||': check record');
3510: END IF;
3511:
3512: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN
3513: Validate_ActMetric_record(

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

3537: p_encoded => Fnd_Api.G_FALSE
3538: );
3539:
3540: IF (AMS_DEBUG_HIGH_ON) THEN
3541: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
3542: END IF;
3543:
3544: EXCEPTION
3545: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 3769: IF Ams_Utility_Pvt.Check_Uniqueness(

3765: AND p_act_metric_rec.activity_metric_id IS NOT NULL
3766: THEN
3767: l_where_clause := ' activity_metric_id = '||p_act_metric_rec.activity_metric_id ;
3768:
3769: IF Ams_Utility_Pvt.Check_Uniqueness(
3770: p_table_name => 'ams_act_metrics_all',
3771: p_where_clause => l_where_clause
3772: ) = Fnd_Api.g_false
3773: THEN

Line 3942: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;

3938: /*
3939: l_table_name := 'FND_CURRENCIES';
3940: l_pk_name := 'CURRENCY_CODE';
3941: l_pk_value := l_act_metrics_rec.transaction_currency_code;
3942: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
3943: l_additional_where_clause := ' enabled_flag = ''Y''';
3944: IF Ams_Utility_Pvt.Check_FK_Exists (
3945: p_table_name => l_table_name
3946: ,p_pk_name => l_pk_name

Line 3944: IF Ams_Utility_Pvt.Check_FK_Exists (

3940: l_pk_name := 'CURRENCY_CODE';
3941: l_pk_value := l_act_metrics_rec.transaction_currency_code;
3942: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
3943: l_additional_where_clause := ' enabled_flag = ''Y''';
3944: IF Ams_Utility_Pvt.Check_FK_Exists (
3945: p_table_name => l_table_name
3946: ,p_pk_name => l_pk_name
3947: ,p_pk_value => l_pk_value
3948: ,p_pk_data_type => l_pk_data_type

Line 3967: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;

3963:
3964: /*l_table_name := 'FND_CURRENCIES';
3965: l_pk_name := 'CURRENCY_CODE';
3966: l_pk_value := l_act_metrics_rec.functional_currency_code;
3967: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
3968: l_additional_where_clause := ' enabled_flag = ''Y''';
3969:
3970: IF Ams_Utility_Pvt.Check_FK_Exists (
3971: p_table_name => l_table_name

Line 3970: IF Ams_Utility_Pvt.Check_FK_Exists (

3966: l_pk_value := l_act_metrics_rec.functional_currency_code;
3967: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
3968: l_additional_where_clause := ' enabled_flag = ''Y''';
3969:
3970: IF Ams_Utility_Pvt.Check_FK_Exists (
3971: p_table_name => l_table_name
3972: ,p_pk_name => l_pk_name
3973: ,p_pk_value => l_pk_value
3974: ,p_pk_data_type => l_pk_data_type

Line 4000: IF Ams_Utility_Pvt.Is_Y_Or_N (l_act_metrics_rec.sensitive_data_flag)

3996: --
3997:
3998: -- SENSITIVE_DATA_FLAG
3999: IF l_act_metrics_rec.sensitive_data_flag <> Fnd_Api.G_MISS_CHAR THEN
4000: IF Ams_Utility_Pvt.Is_Y_Or_N (l_act_metrics_rec.sensitive_data_flag)
4001: = Fnd_Api.G_FALSE
4002: THEN
4003: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
4004: THEN

Line 4197: p_user_or_role_id => AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id),

4193: -- choang - 11-may-2005 - validate edit metric access
4194: IF AMS_Access_PVT.check_update_access (
4195: p_object_id => l_act_metrics_rec.act_metric_used_by_id,
4196: p_object_type => l_act_metrics_rec.arc_act_metric_used_by,
4197: p_user_or_role_id => AMS_Utility_PVT.get_resource_id (FND_GLOBAL.user_id),
4198: p_user_or_role_type => 'USER') <> 'F' THEN
4199: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4200: FND_MESSAGE.set_name ('AMS', 'AMS_NO_METRIC_UPDATE_ACCESS');
4201: FND_MESSAGE.set_token('OBJECT',

Line 4202: AMS_Utility_PVT.get_object_name(l_act_metrics_rec.arc_act_metric_used_by,

4198: p_user_or_role_type => 'USER') <> 'F' THEN
4199: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4200: FND_MESSAGE.set_name ('AMS', 'AMS_NO_METRIC_UPDATE_ACCESS');
4201: FND_MESSAGE.set_token('OBJECT',
4202: AMS_Utility_PVT.get_object_name(l_act_metrics_rec.arc_act_metric_used_by,
4203: l_act_metrics_rec.act_metric_used_by_id)
4204: );
4205: FND_MSG_PUB.add;
4206: -- exit the program immediately after this

Line 4236: l_object_name := ams_utility_pvt.get_lookup_meaning(

4232: -- to set trans_forecasted_value back to
4233: -- its original value
4234:
4235: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4236: l_object_name := ams_utility_pvt.get_lookup_meaning(
4237: 'AMS_SYS_ARC_QUALIFIER',
4238: l_act_metrics_rec.arc_act_metric_used_by);
4239: Fnd_Message.set_name('AMS', 'AMS_UPDATE_FORECAST');
4240: Fnd_Message.set_token('OBJECT', l_object_name);

Line 4354: l_object_name := ams_utility_pvt.get_lookup_meaning(

4350: ,p_object_id => l_act_metrics_rec.act_metric_used_by_id
4351: ) = Fnd_Api.G_FALSE
4352: THEN
4353: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
4354: l_object_name := ams_utility_pvt.get_lookup_meaning(
4355: 'AMS_SYS_ARC_QUALIFIER',l_act_metrics_rec.arc_act_metric_used_by);
4356: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_OBJECT');
4357: Fnd_Message.Set_Token('OBJTYPE',l_object_name);
4358: Fnd_Message.Set_Token('OBJID',l_pk_value);

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

4862: --
4863: -- Output debug message.
4864: --
4865: IF (AMS_DEBUG_HIGH_ON) THEN
4866: Ams_Utility_Pvt.debug_message(l_full_name||': start');
4867: END IF;
4868:
4869: --
4870: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4900: Ams_Utility_Pvt.debug_message(l_full_name||': Update');

4896: --
4897: -- Output debug message.
4898: --
4899: IF (AMS_DEBUG_HIGH_ON) THEN
4900: Ams_Utility_Pvt.debug_message(l_full_name||': Update');
4901: END IF;
4902:
4903: UPDATE ams_act_metrics_all
4904: SET func_committed_value = p_func_committed_value

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

4937: --
4938: -- Output debug message.
4939: --
4940: IF (AMS_DEBUG_HIGH_ON) THEN
4941: Ams_Utility_Pvt.debug_message(l_full_name||': End');
4942: END IF;
4943:
4944:
4945: EXCEPTION

Line 5332: Ams_Utility_Pvt.debug_message('Invalidating object: '||p_used_by_type||

5328: l_used_by_type VARCHAR2(100) := p_used_by_type;
5329: BEGIN
5330: IF (AMS_DEBUG_HIGH_ON) THEN
5331:
5332: Ams_Utility_Pvt.debug_message('Invalidating object: '||p_used_by_type||
5333: ', '||p_used_by_id);
5334: END IF;
5335:
5336: --

Line 5345: Ams_Utility_Pvt.debug_message(l_full_name||': START');

5341: -- Output debug message.
5342: --
5343: IF (AMS_DEBUG_HIGH_ON) THEN
5344:
5345: Ams_Utility_Pvt.debug_message(l_full_name||': START');
5346: END IF;
5347:
5348: --
5349: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 5405: Ams_Utility_Pvt.debug_message(l_full_name ||': END');

5401: -- Debug message.
5402: --
5403: IF (AMS_DEBUG_HIGH_ON) THEN
5404:
5405: Ams_Utility_Pvt.debug_message(l_full_name ||': END');
5406: END IF;
5407:
5408: EXCEPTION
5409: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 5493: Ams_Utility_Pvt.debug_message('Now posting costs FOR object: '||p_obj_type||':'||p_obj_id);

5489: l_func_currency VARCHAR2(30);
5490:
5491: BEGIN
5492: IF (AMS_DEBUG_HIGH_ON) THEN
5493: Ams_Utility_Pvt.debug_message('Now posting costs FOR object: '||p_obj_type||':'||p_obj_id);
5494: END IF;
5495:
5496: --
5497: -- Initialize savepoint.

Line 5504: Ams_Utility_Pvt.debug_message(l_full_name||': START');

5500: --
5501: -- Output debug message.
5502: --
5503: IF (AMS_DEBUG_HIGH_ON) THEN
5504: Ams_Utility_Pvt.debug_message(l_full_name||': START');
5505: END IF;
5506:
5507: --
5508: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 5583: Ams_Utility_Pvt.debug_message(l_full_name ||': END');

5579: --
5580: -- Debug message.
5581: --
5582: IF (AMS_DEBUG_HIGH_ON) THEN
5583: Ams_Utility_Pvt.debug_message(l_full_name ||': END');
5584: END IF;
5585:
5586:
5587: EXCEPTION

Line 6696: Ams_Utility_Pvt.debug_message(l_full_name||': START');

6692: --
6693: -- Output debug message.
6694: --
6695: IF (AMS_DEBUG_HIGH_ON) THEN
6696: Ams_Utility_Pvt.debug_message(l_full_name||': START');
6697: Ams_Utility_Pvt.debug_message('Generating results FOR object: '||
6698: p_object_type||':'||p_object_id||', metric id'||p_metric_id);
6699: Ams_Utility_Pvt.debug_message('FROM/TO/interval/unit: '||
6700: p_from_date||'/'||p_to_date||'/'||p_increment||'/'||p_interval_unit);

Line 6697: Ams_Utility_Pvt.debug_message('Generating results FOR object: '||

6693: -- Output debug message.
6694: --
6695: IF (AMS_DEBUG_HIGH_ON) THEN
6696: Ams_Utility_Pvt.debug_message(l_full_name||': START');
6697: Ams_Utility_Pvt.debug_message('Generating results FOR object: '||
6698: p_object_type||':'||p_object_id||', metric id'||p_metric_id);
6699: Ams_Utility_Pvt.debug_message('FROM/TO/interval/unit: '||
6700: p_from_date||'/'||p_to_date||'/'||p_increment||'/'||p_interval_unit);
6701: END IF;

Line 6699: Ams_Utility_Pvt.debug_message('FROM/TO/interval/unit: '||

6695: IF (AMS_DEBUG_HIGH_ON) THEN
6696: Ams_Utility_Pvt.debug_message(l_full_name||': START');
6697: Ams_Utility_Pvt.debug_message('Generating results FOR object: '||
6698: p_object_type||':'||p_object_id||', metric id'||p_metric_id);
6699: Ams_Utility_Pvt.debug_message('FROM/TO/interval/unit: '||
6700: p_from_date||'/'||p_to_date||'/'||p_increment||'/'||p_interval_unit);
6701: END IF;
6702:
6703: --

Line 6888: Ams_Utility_Pvt.debug_message('Generated: '||x_result_table.COUNT||' results');

6884:
6885: x_result_table := l_result_table;
6886:
6887: IF (AMS_DEBUG_HIGH_ON) THEN
6888: Ams_Utility_Pvt.debug_message('Generated: '||x_result_table.COUNT||' results');
6889: END IF;
6890:
6891: --
6892: -- End API Body

Line 6909: Ams_Utility_Pvt.debug_message(l_full_name ||': END');

6905: --
6906: -- Debug message.
6907: --
6908: IF (AMS_DEBUG_HIGH_ON) THEN
6909: Ams_Utility_Pvt.debug_message(l_full_name ||': END');
6910: END IF;
6911:
6912: EXCEPTION
6913: WHEN Fnd_Api.G_EXC_ERROR THEN

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

7083: -- Initialize savepoint.
7084: SAVEPOINT Copy_Metric_pvt;
7085:
7086: IF (AMS_DEBUG_HIGH_ON) THEN
7087: Ams_Utility_Pvt.Debug_Message(l_full_name||': start');
7088: END IF;
7089:
7090: -- Initialize message list if p_init_msg_list is set to TRUE.
7091: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 7213: Ams_Utility_Pvt.debug_message(l_full_name ||': END');

7209: --
7210: -- Debug message.
7211: --
7212: IF (AMS_DEBUG_HIGH_ON) THEN
7213: Ams_Utility_Pvt.debug_message(l_full_name ||': END');
7214: END IF;
7215:
7216: EXCEPTION
7217: WHEN FND_API.G_EXC_ERROR THEN

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

7315: BEGIN
7316:
7317: -- Output debug message.
7318: IF (AMS_DEBUG_HIGH_ON) THEN
7319: Ams_Utility_Pvt.debug_message(l_full_name||': start');
7320: END IF;
7321:
7322: -- Initialize message list if p_init_msg_list is set to TRUE.
7323: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN

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

7337: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
7338:
7339: -- Begin API Body.
7340: IF (AMS_DEBUG_HIGH_ON) THEN
7341: Ams_Utility_Pvt.debug_message(l_full_name||': Validate items');
7342: END IF;
7343:
7344: --check source object exists
7345: IF (l_source_object_type IN ('RCAM', 'CAMP')) THEN

Line 7377: l_object_name := ams_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER', l_source_object_type);

7373: l_valid_object := Fnd_Api.G_TRUE;
7374:
7375: END IF;
7376:
7377: l_object_name := ams_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER', l_source_object_type);
7378:
7379: --the object type passed is not a valid one for metrics.
7380: IF (l_valid_object = Fnd_Api.G_FALSE) THEN
7381: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

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

7446: );
7447:
7448: -- Add success message to message list.
7449: IF (AMS_DEBUG_HIGH_ON) THEN
7450: Ams_Utility_Pvt.debug_message(l_full_name ||': end Success');
7451: END IF;
7452:
7453: x_return_status := l_return_status;
7454:

Line 7535: AMS_Utility_PVT.error_message ('AMS_INVALID_SYS_QUAL', 'SYS_QUALIFIER', p_arc_act_metric_used_by);

7531: ELSIF (p_arc_act_metric_used_by = 'ALIST') THEN
7532: l_table_name := 'AMS_ACT_LISTS';
7533: l_pk_name := 'ACT_LIST_HEADER_ID';
7534: ELSE
7535: AMS_Utility_PVT.error_message ('AMS_INVALID_SYS_QUAL', 'SYS_QUALIFIER', p_arc_act_metric_used_by);
7536: x_return_status := FND_API.g_ret_sts_unexp_error;
7537: l_table_name := NULL;
7538: l_pk_name := NULL;
7539: END IF;

Line 7548: ams_utility_pvt.debug_message('SQL statement: '||l_sql);

7544: ' SET object_version_number = object_version_number '||
7545: ' WHERE ' || UPPER(l_pk_name) || ' = :b1 ';
7546:
7547: IF (AMS_DEBUG_HIGH_ON) THEN
7548: ams_utility_pvt.debug_message('SQL statement: '||l_sql);
7549: END IF;
7550:
7551: BEGIN
7552: EXECUTE IMMEDIATE l_sql