[Home] [Help]
1329: WHEN GL_CURRENCY_API.NO_RATE THEN
1330: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1331: -- No rate exist for for given conversion date and type between
1332: -- transaction currency and functional currency
1333: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_NO_RATE');
1334: FND_MSG_PUB.Add;
1335: END IF;
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337:
1339: RETURN;
1340: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
1341: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1342: -- Atleast One of the two Currencies specified is invalid
1343: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_CURR');
1344: FND_MSG_PUB.Add;
1345: END IF;
1346: x_return_status := FND_API.G_RET_STS_ERROR;
1347:
1717:
1718: IF (l_freeze_status = Fnd_Api.G_TRUE) THEN
1719: -- frozen to create the record
1720: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1721: Fnd_Message.Set_Name('AMS', 'AMS_METR_FROZEN');
1722: Fnd_Msg_Pub.ADD;
1723: END IF;
1724: l_return_status := Fnd_Api.G_RET_STS_ERROR;
1725: END IF;
2388: x_msg_data => x_msg_data);
2389: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2390: -- BUG2486379: Display budget utilization errors.
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;
2488: --
2489: -- Add error message to API message list.
2490: --
2491: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2492: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2493: Fnd_Msg_Pub.ADD;
2494: END IF;
2495: RAISE Fnd_Api.g_exc_error;
2496: END IF;
2507: --
2508: -- Add error message to API message list.
2509: --
2510: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2511: Fnd_Message.set_name('AMS', 'AMS_API_VARREC_NOT_FOUND');
2512: Fnd_Msg_Pub.ADD;
2513: END IF;
2514: RAISE Fnd_Api.g_exc_error;
2515: END IF;
2771: -- DMVINCEN: There is no reason for this restriction.
2772: -- IF IsSeeded (p_activity_metric_id) THEN
2773: -- IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
2774: -- THEN
2775: -- Fnd_Message.set_name('AMS', 'AMS_METR_SEEDED_METR');
2776: -- Fnd_Msg_Pub.ADD;
2777: -- END IF;
2778: --
2779: -- RAISE Fnd_Api.G_EXC_ERROR;
2807: CLOSE c_check_child_exists;
2808:
2809: IF l_child_type = 'SUMMARY' THEN
2810: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2811: Fnd_Message.set_name('AMS', 'AMS_METR_CANT_DELETE_PARENT');
2812: Fnd_Msg_Pub.ADD;
2813: END IF;
2814: RAISE Fnd_Api.g_exc_error;
2815: END IF;
2820: OPEN c_actmet_details(p_activity_metric_id);
2821: FETCH c_actmet_details INTO l_act_metric_rec;
2822: IF (c_actmet_details%NOTFOUND) THEN
2823: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2824: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2825: Fnd_Msg_Pub.ADD;
2826: END IF;
2827: RAISE Fnd_Api.g_exc_error;
2828: END IF;
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;
2848: END IF;
2849: l_return_status := Fnd_Api.G_RET_STS_ERROR;
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;
2848: END IF;
2849: l_return_status := Fnd_Api.G_RET_STS_ERROR;
2850: END IF;
2860:
2861: IF (l_freeze_status = Fnd_Api.G_TRUE) THEN
2862: -- frozen to create the record
2863: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2864: Fnd_Message.Set_Name('AMS', 'AMS_METR_FROZEN');
2865: Fnd_Msg_Pub.ADD;
2866: END IF;
2867: l_return_status := Fnd_Api.G_RET_STS_ERROR;
2868: END IF;
2876:
2877: -- If the actual value has been posted to the budget do not delete.
2878: IF l_act_metric_rec.published_flag = 'Y' THEN
2879: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2880: Fnd_Message.SET_NAME('AMS', 'AMS_METR_PUBLISHED');
2881: Fnd_Msg_Pub.ADD;
2882: END IF;
2883: RAISE Fnd_Api.g_exc_error;
2884: END IF;
2904: AND object_version_number = p_object_version_number;
2905:
2906: IF SQL%NOTFOUND THEN
2907: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2908: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2909: Fnd_Msg_Pub.ADD;
2910: END IF;
2911: RAISE Fnd_Api.g_exc_error;
2912: END IF;
3343: OPEN c_metric_info(p_activity_metric_id);
3344: FETCH c_metric_info INTO l_metrics_name;
3345: CLOSE c_metric_info;
3346: IF l_metrics_name is not null THEN
3347: Fnd_Message.set_name('AMS', 'AMS_METR_RECORD_NOT_FOUND');
3348: Fnd_Message.set_token('METRIC', l_metrics_name);
3349: Fnd_Msg_Pub.ADD;
3350: ELSE
3351: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3344: FETCH c_metric_info INTO l_metrics_name;
3345: CLOSE c_metric_info;
3346: IF l_metrics_name is not null THEN
3347: Fnd_Message.set_name('AMS', 'AMS_METR_RECORD_NOT_FOUND');
3348: Fnd_Message.set_token('METRIC', l_metrics_name);
3349: Fnd_Msg_Pub.ADD;
3350: ELSE
3351: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3352: Fnd_Msg_Pub.ADD;
3347: Fnd_Message.set_name('AMS', 'AMS_METR_RECORD_NOT_FOUND');
3348: Fnd_Message.set_token('METRIC', l_metrics_name);
3349: Fnd_Msg_Pub.ADD;
3350: ELSE
3351: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3352: Fnd_Msg_Pub.ADD;
3353: END IF;
3354: END IF;
3355: RAISE Fnd_Api.g_exc_error;
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');
3398: Fnd_Msg_Pub.ADD;
3399: END IF;
3400:
3401: Fnd_Msg_Pub.Count_And_Get (
3601: THEN
3602: -- missing required fields
3603: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3604: THEN -- MMSG
3605: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_APP_ID');
3606: Fnd_Msg_Pub.ADD;
3607: END IF;
3608:
3609: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3618: THEN
3619: -- missing required fields
3620: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3621: THEN -- MMSG
3622: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_ARC_USED_FOR');
3623: Fnd_Msg_Pub.ADD;
3624: END IF;
3625:
3626: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3636: THEN
3637: -- missing required fields
3638: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3639: THEN -- MMSG
3640: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_ARC_USED_FOR');
3641: Fnd_Msg_Pub.ADD;
3642: END IF;
3643:
3644: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3653: THEN
3654: -- missing required fields
3655: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3656: THEN -- MMSG
3657: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_METRIC_ID');
3658: Fnd_Msg_Pub.ADD;
3659: END IF;
3660:
3661: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3672: THEN
3673: -- missing required fields
3674: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3675: THEN -- MMSG
3676: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_UOM');
3677: FND_MSG_PUB.Add;
3678: END IF;
3679:
3680: x_return_status := FND_API.G_RET_STS_ERROR;
3692: THEN
3693: -- missing required fields
3694: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3695: THEN -- MMSG
3696: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_SENSITIVE');
3697: Fnd_Msg_Pub.ADD;
3698: END IF;
3699:
3700: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3772: ) = Fnd_Api.g_false
3773: THEN
3774: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
3775: THEN
3776: Fnd_Message.set_name('AMS', 'AMS_METR_ACT_DUP_ID');
3777: Fnd_Msg_Pub.ADD;
3778: END IF;
3779: x_return_status := Fnd_Api.g_ret_sts_error;
3780: RETURN;
3795: CLOSE c_check_function;
3796:
3797: IF l_test IS NULL THEN
3798: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3799: Fnd_Message.set_name('AMS', 'AMS_ACT_MET_DUP_FUNCTION');
3800: Fnd_Msg_Pub.ADD;
3801: END IF;
3802: x_return_status := Fnd_Api.g_ret_sts_error;
3803: END IF;
3881: IF c_check_metric_id%NOTFOUND
3882: THEN
3883: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3884: THEN
3885: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_MET');
3886: FND_MSG_PUB.ADD;
3887: END IF;
3888:
3889: x_return_status := FND_API.G_RET_STS_ERROR;
3900: IF c_check_currency%NOTFOUND
3901: THEN
3902: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3903: THEN
3904: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_TRANS_CUR');
3905: FND_MSG_PUB.ADD;
3906: END IF;
3907:
3908: x_return_status := FND_API.G_RET_STS_ERROR;
3922: IF c_check_currency%NOTFOUND
3923: THEN
3924: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3925: THEN
3926: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_FUNC_CUR');
3927: FND_MSG_PUB.ADD;
3928: END IF;
3929:
3930: x_return_status := FND_API.G_RET_STS_ERROR;
3950: ) = Fnd_Api.G_FALSE
3951: THEN
3952: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3953: THEN
3954: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_TRANS_CUR');
3955: Fnd_Msg_Pub.ADD;
3956: END IF;
3957:
3958: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3976: ) = Fnd_Api.G_FALSE
3977: THEN
3978: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3979: THEN
3980: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_FUNC_CUR');
3981: Fnd_Msg_Pub.ADD;
3982: END IF;
3983:
3984: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4001: = Fnd_Api.G_FALSE
4002: THEN
4003: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
4004: THEN
4005: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_SENS_FLAG');
4006: Fnd_Msg_Pub.ADD;
4007: END IF;
4008:
4009: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4027: FETCH c_arc_metric_usage INTO l_dummy;
4028: CLOSE c_arc_metric_usage;
4029: IF l_dummy IS NULL THEN
4030: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4031: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_USED_BY');
4032: FND_MSG_PUB.add;
4033: END IF;
4034: x_return_status := FND_API.g_ret_sts_error;
4035: END IF;
4044: FETCH c_arc_metric_usage INTO l_dummy;
4045: CLOSE c_arc_metric_usage;
4046: IF l_dummy IS NULL THEN
4047: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4048: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_ORIGIN');
4049: FND_MSG_PUB.add;
4050: END IF;
4051: x_return_status := FND_API.g_ret_sts_error;
4052: END IF;
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',
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: );
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',
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;
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);
4241: Fnd_Msg_Pub.ADD;
4242: END IF; --msg_pub if
4243: x_return_status := Fnd_Api.G_RET_STS_ERROR;
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);
4241: Fnd_Msg_Pub.ADD;
4242: END IF; --msg_pub if
4243: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4244: END IF;
4265: IF (l_allow_actual_update = 'N') THEN
4266: --object is not active and profile is N hence do not allow update
4267: IF (l_freeze_status = Fnd_Api.G_FALSE) THEN
4268: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4269: Fnd_Message.set_name('AMS', 'AMS_METR_UPDATE_ACTUAL');
4270: Fnd_Msg_Pub.ADD;
4271: END IF; --msg_pub if
4272:
4273: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4296: IF (l_allow_actual_update = 'N') THEN
4297: --object is not active and profile is N hence do not allow update
4298: IF (l_freeze_status = Fnd_Api.G_FALSE) THEN
4299: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4300: Fnd_Message.set_name('AMS', 'AMS_METR_UPDATE_ACTUAL');
4301: Fnd_Msg_Pub.ADD;
4302: END IF; --msg_pub if
4303:
4304: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4335: THEN
4336:
4337: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
4338: THEN
4339: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_ACT_USAGE');
4340: Fnd_Msg_Pub.ADD;
4341: END IF;
4342:
4343: x_return_status := Fnd_Api.G_RET_STS_ERROR;
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);
4359: Fnd_Msg_Pub.ADD;
4360: END IF;
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);
4359: Fnd_Msg_Pub.ADD;
4360: END IF;
4361:
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);
4359: Fnd_Msg_Pub.ADD;
4360: END IF;
4361:
4362: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4374: IF c_check_uom%NOTFOUND
4375: THEN
4376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4377: THEN
4378: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_UOM');
4379: FND_MSG_PUB.ADD;
4380: END IF;
4381:
4382: x_return_status := FND_API.G_RET_STS_ERROR;
4399: ,p_object_id => l_act_metrics_rec.act_metric_used_by_id
4400: ) = Fnd_Api.G_FALSE
4401: THEN
4402: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
4403: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_ORIGIN');
4404: Fnd_Msg_Pub.ADD;
4405: END IF;
4406:
4407: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4503: FETCH c_act_metric INTO l_act_metric_rec;
4504: IF c_act_metric%NOTFOUND THEN
4505: CLOSE c_act_metric;
4506: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4507: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
4508: Fnd_Msg_Pub.ADD;
4509: END IF;
4510: RAISE Fnd_Api.g_exc_error;
4511: END IF;
5782:
5783: EXCEPTION
5784: WHEN Gl_Currency_Api.NO_RATE THEN
5785: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5786: Fnd_Message.Set_Name ('AMS', 'AMS_NO_RATE');
5787: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5788: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5789: Fnd_Msg_Pub.ADD;
5790: END IF;
5783: EXCEPTION
5784: WHEN Gl_Currency_Api.NO_RATE THEN
5785: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5786: Fnd_Message.Set_Name ('AMS', 'AMS_NO_RATE');
5787: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5788: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5789: Fnd_Msg_Pub.ADD;
5790: END IF;
5791: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5784: WHEN Gl_Currency_Api.NO_RATE THEN
5785: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5786: Fnd_Message.Set_Name ('AMS', 'AMS_NO_RATE');
5787: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5788: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5789: Fnd_Msg_Pub.ADD;
5790: END IF;
5791: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5792: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5790: END IF;
5791: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5792: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5793: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5794: Fnd_Message.Set_Name ('AMS', 'AMS_INVALID_CURR');
5795: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5796: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5797: Fnd_Msg_Pub.ADD;
5798: END IF;
5791: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5792: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5793: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5794: Fnd_Message.Set_Name ('AMS', 'AMS_INVALID_CURR');
5795: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5796: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5797: Fnd_Msg_Pub.ADD;
5798: END IF;
5799: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5792: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5793: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5794: Fnd_Message.Set_Name ('AMS', 'AMS_INVALID_CURR');
5795: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5796: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5797: Fnd_Msg_Pub.ADD;
5798: END IF;
5799: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5800: END Convert_Currency2;
5874:
5875: EXCEPTION
5876: WHEN Gl_Currency_Api.NO_RATE THEN
5877: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5878: Fnd_Message.Set_Name ('AMS', 'AMS_NO_RATE');
5879: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5880: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5881: Fnd_Msg_Pub.ADD;
5882: END IF;
5875: EXCEPTION
5876: WHEN Gl_Currency_Api.NO_RATE THEN
5877: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5878: Fnd_Message.Set_Name ('AMS', 'AMS_NO_RATE');
5879: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5880: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5881: Fnd_Msg_Pub.ADD;
5882: END IF;
5883: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5876: WHEN Gl_Currency_Api.NO_RATE THEN
5877: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5878: Fnd_Message.Set_Name ('AMS', 'AMS_NO_RATE');
5879: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5880: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5881: Fnd_Msg_Pub.ADD;
5882: END IF;
5883: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5884: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5882: END IF;
5883: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5884: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5885: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5886: Fnd_Message.Set_Name ('AMS', 'AMS_INVALID_CURR');
5887: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5888: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5889: Fnd_Msg_Pub.ADD;
5890: END IF;
5883: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5884: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5885: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5886: Fnd_Message.Set_Name ('AMS', 'AMS_INVALID_CURR');
5887: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5888: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5889: Fnd_Msg_Pub.ADD;
5890: END IF;
5891: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5884: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5885: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5886: Fnd_Message.Set_Name ('AMS', 'AMS_INVALID_CURR');
5887: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5888: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5889: Fnd_Msg_Pub.ADD;
5890: END IF;
5891: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5892: END Convert_Currency_Vector;
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
7382: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_OBJECTS');
7383: Fnd_Msg_Pub.ADD;
7384: END IF;
7385: l_return_status := Fnd_Api.G_RET_STS_ERROR;
7386:
7388:
7389: --check if source object was not found
7390: IF (l_source_object_exists = Fnd_Api.G_FALSE) THEN
7391: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7392: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_SOURCE');
7393: Fnd_Message.set_token('OBJECT', l_object_name);
7394: Fnd_Msg_Pub.ADD;
7395: END IF;
7396: l_return_status := Fnd_Api.G_RET_STS_ERROR;
7389: --check if source object was not found
7390: IF (l_source_object_exists = Fnd_Api.G_FALSE) THEN
7391: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7392: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_SOURCE');
7393: Fnd_Message.set_token('OBJECT', l_object_name);
7394: Fnd_Msg_Pub.ADD;
7395: END IF;
7396: l_return_status := Fnd_Api.G_RET_STS_ERROR;
7397: END IF;
7426:
7427: --check if target object was not found
7428: IF (l_target_object_exists = Fnd_Api.G_FALSE) THEN
7429: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7430: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_TARGET');
7431: Fnd_Message.set_token('OBJECT', l_object_name);
7432: Fnd_Msg_Pub.ADD;
7433: END IF;
7434: l_return_status := Fnd_Api.G_RET_STS_ERROR;
7427: --check if target object was not found
7428: IF (l_target_object_exists = Fnd_Api.G_FALSE) THEN
7429: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7430: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_TARGET');
7431: Fnd_Message.set_token('OBJECT', l_object_name);
7432: Fnd_Msg_Pub.ADD;
7433: END IF;
7434: l_return_status := Fnd_Api.G_RET_STS_ERROR;
7435: