DBA Data[Home] [Help]

APPS.AMS_REFRESHMETRIC_PVT dependencies on AMS_UTILITY_PVT

Line 285: RAISE ams_utility_pvt.resource_locked;

281: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
282: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
283: elsif l_is_locked = FND_API.G_FALSE THEN
284: -- the object needs to be lock by this process.
285: RAISE ams_utility_pvt.resource_locked;
286: END IF;
287:
288:
289: OPEN c_verify_act_metric(l_metric_parent_id,

Line 697: Ams_Utility_Pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER',

693: CLOSE c_get_category_name;
694: l_category_name := SUBSTR(l_category_name,1,85);
695: --Get meaning for the child object type
696: l_object_type_meaning :=
697: Ams_Utility_Pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER',
698: l_child_obj_rec.child_object_type);
699: l_object_type_meaning := SUBSTR(l_object_type_meaning,1,30);
700: -- Assign values to the accrual metric that is being created
701: l_metric_rec.metrics_name :=

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

1351: --
1352: -- Output debug message.
1353: --
1354: IF AMS_DEBUG_HIGH_ON THEN
1355: Ams_Utility_Pvt.debug_message(l_full_name||': START');
1356: END IF;
1357: --
1358: -- Initialize message list if p_init_msg_list is set to TRUE.
1359: --

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

1451: p_count => x_msg_count,
1452: p_data => x_msg_data,
1453: p_encoded => Fnd_Api.G_FALSE
1454: );
1455: --Ams_Utility_Pvt.debug_message(l_full_name ||': end');
1456: EXCEPTION
1457: WHEN Fnd_Api.G_EXC_ERROR THEN
1458: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1459: Fnd_Msg_Pub.Count_And_Get (

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

1548: --
1549: -- Output debug message.
1550: --
1551: IF AMS_DEBUG_HIGH_ON THEN
1552: Ams_Utility_Pvt.debug_message(l_full_name||': start');
1553: END IF;
1554: --
1555: -- Initialize message list if p_init_msg_list is set to TRUE.
1556: --

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

1637: p_data => x_msg_data,
1638: p_encoded => Fnd_Api.G_FALSE
1639: );
1640: IF AMS_DEBUG_HIGH_ON THEN
1641: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
1642: END IF;
1643: EXCEPTION
1644: WHEN Fnd_Api.G_EXC_ERROR THEN
1645: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1816: Ams_Utility_Pvt.debug_message('Now Ref/Calculating act met id: '||p_activity_metric_id);

1812: l_return_status VARCHAR2(1);
1813:
1814: BEGIN
1815: IF AMS_DEBUG_HIGH_ON THEN
1816: Ams_Utility_Pvt.debug_message('Now Ref/Calculating act met id: '||p_activity_metric_id);
1817: END IF;
1818:
1819: --
1820: -- Initialize savepoint.

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

1823: --
1824: -- Output debug message.
1825: --
1826: IF AMS_DEBUG_HIGH_ON THEN
1827: Ams_Utility_Pvt.debug_message(l_full_name||': start');
1828: END IF;
1829: --
1830: -- Initialize message list if p_init_msg_list is set to TRUE.
1831: --

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

2327: --
2328: -- Add success message to message list.
2329: --
2330: IF AMS_DEBUG_HIGH_ON THEN
2331: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
2332: END IF;
2333: EXCEPTION
2334: WHEN Fnd_Api.G_EXC_ERROR THEN
2335: -- ROLLBACK TO CALCULATE_METRIC_SAVEPOINT;

Line 2352: when ams_utility_pvt.resource_locked then

2348: p_data => x_msg_data,
2349: p_encoded => FND_API.G_FALSE
2350: );
2351: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
2352: when ams_utility_pvt.resource_locked then
2353: Fnd_Message.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
2354: Fnd_Msg_Pub.ADD;
2355: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
2356: WHEN OTHERS THEN

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

2548: --
2549: -- Output debug message.
2550: --
2551: IF AMS_DEBUG_HIGH_ON THEN
2552: Ams_Utility_Pvt.debug_message(l_full_name||': START');
2553: END IF;
2554: --
2555: -- Initialize message list if p_init_msg_list is set to TRUE.
2556: --

Line 2632: Ams_Utility_Pvt.debug_message(l_full_name||': Metric_Id='||l_metric_id);

2628: FETCH c_tpl_all_metrics INTO l_metric_id, l_metric_category,
2629: l_accrual_type;
2630: EXIT WHEN c_tpl_all_metrics%NOTFOUND;
2631: IF AMS_DEBUG_HIGH_ON THEN
2632: Ams_Utility_Pvt.debug_message(l_full_name||': Metric_Id='||l_metric_id);
2633: END IF;
2634: /*** choang - 27-oct-2003 - optimized to filter in the metric query
2635: IF (l_has_cost = FND_API.G_TRUE AND l_metric_category IN (901,902)) OR
2636: (l_has_amet = FND_API.G_TRUE AND l_metric_category NOT IN (901,902)) THEN

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

2677: --
2678: -- Debug message.
2679: --
2680: IF AMS_DEBUG_HIGH_ON THEN
2681: Ams_Utility_Pvt.debug_message(l_full_name ||': END');
2682: END IF;
2683: EXCEPTION
2684: WHEN Fnd_Api.G_EXC_ERROR THEN
2685: ROLLBACK TO Copy_Seeded_Metric_pvt;

Line 2785: Ams_Utility_Pvt.Debug_Message(l_full_name||': START');

2781: --
2782: -- Output debug message.
2783: --
2784: IF AMS_DEBUG_HIGH_ON THEN
2785: Ams_Utility_Pvt.Debug_Message(l_full_name||': START');
2786: END IF;
2787: --
2788: -- Initialize message list if p_init_msg_list is set to TRUE.
2789: --

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

2886: --
2887: -- Add success message to message list.
2888: --
2889: IF AMS_DEBUG_HIGH_ON THEN
2890: Ams_Utility_Pvt.debug_message(l_full_name ||': END Success');
2891: END IF;
2892: EXCEPTION
2893: WHEN Fnd_Api.G_EXC_ERROR THEN
2894: ROLLBACK TO Create_App_Metric_pvt;

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

3021: --
3022: -- Output debug message.
3023: --
3024: IF AMS_DEBUG_HIGH_ON THEN
3025: Ams_Utility_Pvt.debug_message(l_full_name||': START');
3026: END IF;
3027: --
3028: -- Initialize message list if p_init_msg_list is set to TRUE.
3029: --

Line 3112: Ams_Utility_Pvt.debug_message('Now Calling Calc Met FOR: '||

3108: LOOP
3109: FETCH c_all_metrics INTO l_all_metrics_rec;
3110: EXIT WHEN c_all_metrics%NOTFOUND;
3111: IF AMS_DEBUG_MEDIUM_ON THEN
3112: Ams_Utility_Pvt.debug_message('Now Calling Calc Met FOR: '||
3113: l_act_metric_rec.act_metric_used_by_id||'-'||
3114: l_act_metric_rec.arc_act_metric_used_by);
3115: END IF;
3116: Calculate_Metric (

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

3158: --
3159: -- Add success message to message list.
3160: --
3161: IF AMS_DEBUG_HIGH_ON THEN
3162: Ams_Utility_Pvt.debug_message(l_full_name ||': END');
3163: END IF;
3164: EXCEPTION
3165: WHEN Fnd_Api.G_EXC_ERROR THEN
3166: ROLLBACK TO Refresh_Metric_SavePoint;

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

3262: --
3263: -- Output debug message.
3264: --
3265: IF AMS_DEBUG_HIGH_ON THEN
3266: Ams_Utility_Pvt.debug_message(l_full_name||': START');
3267: END IF;
3268: --
3269: -- Initialize message list if p_init_msg_list is set to TRUE.
3270: --

Line 3306: RAISE ams_utility_pvt.resource_locked;

3302: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
3303: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
3304: elsif l_is_locked = FND_API.G_FALSE THEN
3305: -- the object needs to be lock by this process.
3306: RAISE ams_utility_pvt.resource_locked;
3307: END IF;
3308:
3309: --
3310: -- Replace the body: 11/19/2002

Line 3334: -- Ams_Utility_Pvt.debug_message('Now Calling Calc Met FOR: '||

3330: p_act_metric_used_by_id);
3331: LOOP
3332: FETCH c_all_metrics INTO l_all_metrics_rec;
3333: EXIT WHEN c_all_metrics%NOTFOUND;
3334: -- Ams_Utility_Pvt.debug_message('Now Calling Calc Met FOR: '||
3335: -- p_arc_act_metric_used_by||'-'||
3336: -- p_act_metric_used_by_id);
3337: Calculate_Metric (
3338: p_api_version => l_api_version ,

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

3398: --
3399: -- Add success message to message list.
3400: --
3401: IF AMS_DEBUG_HIGH_ON THEN
3402: Ams_Utility_Pvt.debug_message(l_full_name ||': END');
3403: END IF;
3404: EXCEPTION
3405: when ams_utility_pvt.resource_locked then
3406: ROLLBACK TO Refresh_Metric_SavePoint2;

Line 3405: when ams_utility_pvt.resource_locked then

3401: IF AMS_DEBUG_HIGH_ON THEN
3402: Ams_Utility_Pvt.debug_message(l_full_name ||': END');
3403: END IF;
3404: EXCEPTION
3405: when ams_utility_pvt.resource_locked then
3406: ROLLBACK TO Refresh_Metric_SavePoint2;
3407: Fnd_Message.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
3408: Fnd_Msg_Pub.ADD;
3409: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

3581: --
3582: -- Output debug message.
3583: --
3584: IF AMS_DEBUG_HIGH_ON THEN
3585: Ams_Utility_Pvt.debug_message(l_full_name||': START');
3586: END IF;
3587: --
3588: -- Initialize message list if p_init_msg_list is set to TRUE.
3589: --

Line 3612: Ams_Utility_Pvt.debug_message(l_full_name||': refresh component:'||

3608: LOOP
3609: FETCH c_get_components INTO l_object_id, l_object_type;
3610: EXIT WHEN c_get_components%NOTFOUND;
3611: IF AMS_DEBUG_MEDIUM_ON THEN
3612: Ams_Utility_Pvt.debug_message(l_full_name||': refresh component:'||
3613: l_object_type||'/'||l_object_id);
3614: END IF;
3615: Refresh_Metric(
3616: p_api_version => p_api_version,

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

3650: --
3651: -- Add success message to message list.
3652: --
3653: IF AMS_DEBUG_HIGH_ON THEN
3654: Ams_Utility_Pvt.debug_message(l_full_name ||': END');
3655: END IF;
3656: EXCEPTION
3657: WHEN Fnd_Api.G_EXC_ERROR THEN
3658: ROLLBACK TO Refresh_Metric_SavePoint;