[Home] [Help]
410: l_evo_rec.event_standalone_flag := 'Y';
411: ELSIF l_evo_rec.event_object_type = 'EVEO' THEN
412: l_evo_rec.event_standalone_flag := 'N';
413: ELSE
414: FND_MESSAGE.set_name('AMS', 'AMS_DM_SRC_NO_ARC_USED_FOR_OBJ');
415: FND_MSG_PUB.add;
416: RAISE FND_API.g_exc_error;
417: END IF;
418: END IF;
487: close get_res_id;
488: END IF;
489: IF AMS_ACCESS_PVT.check_update_access(l_evo_rec.parent_event_offer_id, l_evo_rec.event_object_type, l_res_id, 'USER') = 'N' then
490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
491: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');-- reusing the message
492: FND_MSG_PUB.add;
493: END IF;
494: RAISE FND_API.g_exc_error;
495: END IF;
557: /* Code Added By GMadana for date/time validation */
558: IF l_evo_rec.event_start_date_time > l_evo_rec.event_end_date_time THEN
559: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
560: THEN
561: Fnd_Message.set_name('AMS', 'AMS_EVO_START_TM_GT_END_TM');
562: Fnd_Msg_Pub.ADD;
563: END IF;
564: x_return_status := Fnd_Api.g_ret_sts_error;
565: RAISE Fnd_Api.g_exc_error;
1236: l_offer_id := p_evo_id;
1237: END IF;
1238: if AMS_ACCESS_PVT.check_update_access(l_offer_id, l_object_type, l_res_id, 'USER') = 'N' then
1239: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1240: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS'); --reusing the message
1241: FND_MSG_PUB.add;
1242: END IF;
1243: RAISE FND_API.g_exc_error;
1244: end if;
1256:
1257: IF (SQL%NOTFOUND) THEN
1258: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1259: THEN
1260: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1261: FND_MSG_PUB.add;
1262: END IF;
1263: RAISE FND_API.g_exc_error;
1264: END IF;
1393: FETCH c_evo_b INTO l_evo_id;
1394: IF (c_evo_b%NOTFOUND) THEN
1395: CLOSE c_evo_b;
1396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1397: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1398: FND_MSG_PUB.add;
1399: END IF;
1400: RAISE FND_API.g_exc_error;
1401: END IF;
1423:
1424: WHEN AMS_Utility_PVT.resource_locked THEN
1425: x_return_status := FND_API.g_ret_sts_error;
1426: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1427: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1428: FND_MSG_PUB.add;
1429: END IF;
1430:
1431: FND_MSG_PUB.count_and_get(
1785: CLOSE c_bdgt_line_yn;
1786: ELSE
1787: CLOSE c_bdgt_line_yn;
1788: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1789: FND_MESSAGE.set_name('AMS', 'AMS_EVENT_BUD_PRESENT');
1790: FND_MSG_PUB.add;
1791: END IF;
1792: RAISE FND_API.g_exc_error;
1793: END IF;
1888: END IF;
1889: ELSE
1890: if l_traget_list_exists = FND_API.G_TRUE
1891: THEN
1892: FND_MESSAGE.set_name('AMS', 'AMS_EVEO_SRCCD_NO_CHNG');
1893: FND_MSG_PUB.add;
1894: RAISE FND_API.g_exc_error;
1895: else
1896: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_UPDATE_SRC_STAT');
1892: FND_MESSAGE.set_name('AMS', 'AMS_EVEO_SRCCD_NO_CHNG');
1893: FND_MSG_PUB.add;
1894: RAISE FND_API.g_exc_error;
1895: else
1896: FND_MESSAGE.set_name('AMS', 'AMS_CAMP_UPDATE_SRC_STAT');
1897: FND_MSG_PUB.add;
1898: RAISE FND_API.g_exc_error;
1899: END IF;
1900: END IF;
1946: END IF;
1947: ELSE
1948: if l_traget_list_exists = FND_API.G_TRUE
1949: THEN
1950: FND_MESSAGE.set_name('AMS', 'AMS_EVEO_GLFLAG_NO_CHANG');
1951: FND_MSG_PUB.add;
1952: RAISE FND_API.g_exc_error;
1953: else
1954: FND_MESSAGE.set_name('AMS', 'AMS_EVNT_UPDATE_GFLG_STAT');
1950: FND_MESSAGE.set_name('AMS', 'AMS_EVEO_GLFLAG_NO_CHANG');
1951: FND_MSG_PUB.add;
1952: RAISE FND_API.g_exc_error;
1953: else
1954: FND_MESSAGE.set_name('AMS', 'AMS_EVNT_UPDATE_GFLG_STAT');
1955: FND_MSG_PUB.add;
1956: RAISE FND_API.g_exc_error;
1957: END IF;
1958: END IF;
1990: ELSE
1991: -- check for access
1992: if AMS_ACCESS_PVT.check_update_access(l_evo_id, l_evo_rec.event_object_type, l_res_id, 'USER') = 'N' then
1993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1994: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_UPDATE_ACCESS');
1995: FND_MSG_PUB.add;
1996: END IF;
1997: RAISE FND_API.g_exc_error;
1998: end if;
2248: FETCH c_location INTO l_address1, l_address2, l_city, l_state, l_country;
2249: IF c_location%NOTFOUND THEN
2250: CLOSE c_location;
2251: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2252: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2253: FND_MSG_PUB.add;
2254: END IF;
2255: RAISE FND_API.g_exc_error;
2256: END IF;
2347: IF l_min_session_time IS NOT NULL AND l_min_session_time < l_evo_rec.event_start_date_time THEN
2348: IF (AMS_DEBUG_HIGH_ON) THEN
2349: AMS_Utility_PVT.debug_message('Event Start is after Min Session Start');
2350: END IF;
2351: Fnd_Message.set_name('AMS', 'AMS_EVT_SESS_STDT_CONFLICT');
2352: Fnd_Msg_Pub.ADD;
2353: x_return_status := Fnd_Api.g_ret_sts_error;
2354: RETURN;
2355: END IF;
2357: IF l_max_session_time IS NOT NULL AND l_max_session_time > l_evo_rec.event_end_date_time THEN
2358: IF (AMS_DEBUG_HIGH_ON) THEN
2359: AMS_Utility_PVT.debug_message('Event End is before Max Session End');
2360: END IF;
2361: Fnd_Message.set_name('AMS', 'AMS_EVT_SESS_EDDT_CONFLICT');
2362: Fnd_Msg_Pub.ADD;
2363: x_return_status := Fnd_Api.g_ret_sts_error;
2364: RETURN;
2365: END IF;
2743: END IF;
2744: -- GDEODHAR : End of changes. Sept. 26th 2000.
2745: IF (SQL%NOTFOUND) THEN
2746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2747: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2748: FND_MSG_PUB.add;
2749: END IF;
2750: RAISE FND_API.g_exc_error;
2751: END IF;
2765: AND USERENV('LANG') IN (language, source_lang);
2766:
2767: IF (SQL%NOTFOUND) THEN
2768: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2769: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2770: FND_MSG_PUB.add;
2771: END IF;
2772: RAISE FND_API.g_exc_error;
2773: END IF;
2791: WHERE event_offer_id = l_evo_rec.event_offer_id;
2792:
2793: IF (SQL%NOTFOUND) THEN
2794: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2795: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2796: FND_MSG_PUB.add;
2797: END IF;
2798: RAISE FND_API.g_exc_error;
2799: END IF;
3152: x_return_status := FND_API.g_ret_sts_success;
3153: ------------------------ owner_user_id --------------------------
3154: IF (p_evo_rec.owner_user_id IS NULL OR p_evo_rec.owner_user_id = FND_API.g_miss_num) THEN
3155: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3156: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_OWNER_ID');
3157: FND_MSG_PUB.add;
3158: END IF;
3159: x_return_status := FND_API.g_ret_sts_error;
3160: RETURN;
3162:
3163: ------------------------ user_status_id --------------------------
3164: IF (p_evo_rec.user_status_id IS NULL OR p_evo_rec.user_status_id = FND_API.g_miss_num) THEN
3165: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3166: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_USER_STATUS_ID');
3167: FND_MSG_PUB.add;
3168: END IF;
3169: x_return_status := FND_API.g_ret_sts_error;
3170: RETURN;
3172:
3173: ------------------------ application_id --------------------------
3174: IF (p_evo_rec.application_id IS NULL OR p_evo_rec.application_id = FND_API.g_miss_num) THEN
3175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3176: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_APPLICATION_ID');
3177: FND_MSG_PUB.add;
3178: END IF;
3179: x_return_status := FND_API.g_ret_sts_error;
3180: RETURN;
3182: ------------------------ parent_event_offer_id--------------------------
3183: IF p_evo_rec.EVENT_LEVEL = 'SUB' THEN
3184: IF (p_evo_rec.parent_event_offer_id IS NULL OR p_evo_rec.parent_event_offer_id = FND_API.g_miss_num) THEN
3185: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3186: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_PARENT_OFFER_ID');
3187: FND_MSG_PUB.add;
3188: END IF;
3189: x_return_status := FND_API.g_ret_sts_error;
3190: RETURN;
3194: ------------------------ custom_setup_id --------------------------
3195: IF (p_evo_rec.event_level = 'MAIN' AND p_evo_rec.parent_type <> 'CSCH' AND
3196: (p_evo_rec.custom_setup_id IS NULL OR p_evo_rec.custom_setup_id = FND_API.g_miss_num)) THEN
3197: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3198: FND_MESSAGE.set_name('AMS', 'AMS_EVO_NO_SETUP_ID');
3199: FND_MSG_PUB.add;
3200: END IF;
3201: x_return_status := FND_API.g_ret_sts_error;
3202: RETURN;
3235: 'event_offer_id = ' || p_evo_rec.event_offer_id
3236: ) = FND_API.g_false
3237: THEN
3238: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3239: FND_MESSAGE.set_name('AMS', 'AMS_EVO_DUPLICATE_ID');
3240: FND_MSG_PUB.add;
3241: END IF;
3242: x_return_status := FND_API.g_ret_sts_error;
3243: RETURN;
3261: fetch c_src_code into l_dummy;
3262: close c_src_code;
3263: IF l_dummy <> 1 THEN
3264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3265: FND_MESSAGE.set_name('AMS', 'AMS_EVO_DUPE_SOURCE');
3266: FND_MSG_PUB.add;
3267: END IF;
3268: x_return_status := FND_API.g_ret_sts_error;
3269: RETURN;
3307: ) = FND_API.g_false
3308: THEN
3309: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3310: THEN
3311: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_OWNER_USER');
3312: FND_MSG_PUB.add;
3313: END IF;
3314: x_return_status := FND_API.g_ret_sts_error;
3315: RETURN;
3326: ) = FND_API.g_false
3327: THEN
3328: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3329: THEN
3330: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_APP_ID');
3331: FND_MSG_PUB.add;
3332: END IF;
3333: x_return_status := FND_API.g_ret_sts_error;
3334: RETURN;
3346: ) = FND_API.g_false
3347: THEN
3348: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3349: THEN
3350: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_INBOUND_SCRIPT');
3351: FND_MSG_PUB.add;
3352: END IF;
3353: x_return_status := FND_API.g_ret_sts_error;
3354: RETURN;
3365: ) = FND_API.g_false
3366: THEN
3367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3368: THEN
3369: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PARENT_HEADER');
3370: FND_MSG_PUB.add;
3371: END IF;
3372: x_return_status := FND_API.g_ret_sts_error;
3373: RETURN;
3385: ) = FND_API.g_false
3386: THEN
3387: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3388: THEN
3389: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PARENT_OFFER');
3390: FND_MSG_PUB.add;
3391: END IF;
3392: x_return_status := FND_API.g_ret_sts_error;
3393: RETURN;
3403: ) = FND_API.g_false
3404: THEN
3405: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3406: THEN
3407: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_PARENT_EVEH');
3408: FND_MSG_PUB.add;
3409: END IF;
3410: x_return_status := FND_API.g_ret_sts_error;
3411: RETURN;
3422: ) = FND_API.g_false
3423: THEN
3424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3425: THEN
3426: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_DUR_UOM_CODE');
3427: FND_MSG_PUB.add;
3428: END IF;
3429: x_return_status := FND_API.g_ret_sts_error;
3430: RETURN;
3440: ) = FND_API.g_false
3441: THEN
3442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3443: THEN
3444: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PRICE_HEADER_ID');
3445: FND_MSG_PUB.add;
3446: END IF;
3447: x_return_status := FND_API.g_ret_sts_error;
3448: RETURN;
3458: ) = FND_API.g_false
3459: THEN
3460: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3461: THEN
3462: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PRICE_LINE_ID');
3463: FND_MSG_PUB.add;
3464: END IF;
3465: x_return_status := FND_API.g_ret_sts_error;
3466: RETURN;
3476: ) = FND_API.g_false
3477: THEN
3478: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3479: THEN
3480: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TIMEZONE_ID');
3481: FND_MSG_PUB.add;
3482: END IF;
3483: x_return_status := FND_API.g_ret_sts_error;
3484: RETURN;
3494: ) = FND_API.g_false
3495: THEN
3496: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3497: THEN
3498: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TIMEZONE_ID');
3499: FND_MSG_PUB.add;
3500: END IF;
3501: x_return_status := FND_API.g_ret_sts_error;
3502: RETURN;
3512: ) = FND_API.g_false
3513: THEN
3514: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3515: THEN
3516: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_VENUE_ID');
3517: FND_MSG_PUB.add;
3518: END IF;
3519: x_return_status := FND_API.g_ret_sts_error;
3520: RETURN;
3531: ) = FND_API.g_false
3532: THEN
3533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3534: THEN
3535: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_LANG_CODE');
3536: FND_MSG_PUB.add;
3537: END IF;
3538: x_return_status := FND_API.g_ret_sts_error;
3539: RETURN;
3549: ) = FND_API.g_false
3550: THEN
3551: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3552: THEN
3553: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_LOCATION_ID');
3554: FND_MSG_PUB.add;
3555: END IF;
3556: x_return_status := FND_API.g_ret_sts_error;
3557: RETURN;
3593: ) = FND_API.g_false
3594: THEN
3595: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3596: THEN
3597: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_USER_ST_ID');
3598: FND_MSG_PUB.add;
3599: END IF;
3600:
3601: x_return_status := FND_API.g_ret_sts_error;
3622: ) = FND_API.g_false
3623: THEN
3624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3625: THEN
3626: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_INV_ITEM_ID');
3627: FND_MSG_PUB.add;
3628: END IF;
3629:
3630: x_return_status := FND_API.g_ret_sts_error;
3667: ) = FND_API.g_false
3668: THEN
3669: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3670: THEN
3671: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_TYPE');
3672: FND_MSG_PUB.add;
3673: END IF;
3674: x_return_status := FND_API.g_ret_sts_error;
3675: RETURN;
3685: ) = FND_API.g_false
3686: THEN
3687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3688: THEN
3689: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_LEVEL');
3690: FND_MSG_PUB.add;
3691: END IF;
3692: x_return_status := FND_API.g_ret_sts_error;
3693: RETURN;
3703: ) = FND_API.g_false
3704: THEN
3705: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3706: THEN
3707: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_WAILIST_ACTION');
3708: FND_MSG_PUB.add;
3709: END IF;
3710: x_return_status := FND_API.g_ret_sts_error;
3711: RETURN;
3721: ) = FND_API.g_false
3722: THEN
3723: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3724: THEN
3725: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_STREAM_TYPE');
3726: FND_MSG_PUB.add;
3727: END IF;
3728: x_return_status := FND_API.g_ret_sts_error;
3729: RETURN;
3739: ) = FND_API.g_false
3740: THEN
3741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3742: THEN
3743: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_FUND_SOURCE');
3744: FND_MSG_PUB.add;
3745: END IF;
3746: x_return_status := FND_API.g_ret_sts_error;
3747: RETURN;
3757: ) = FND_API.g_false
3758: THEN
3759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3760: THEN
3761: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PRIORITY');
3762: FND_MSG_PUB.add;
3763: END IF;
3764: x_return_status := FND_API.g_ret_sts_error;
3765: RETURN;
3776: ) = FND_API.g_false
3777: THEN
3778: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3779: THEN
3780: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_CREDIT_TYPE');
3781: FND_MSG_PUB.add;
3782: END IF;
3783: x_return_status := FND_API.g_ret_sts_error;
3784: RETURN;
3795: ) = FND_API.g_false
3796: THEN
3797: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3798: THEN
3799: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_CANCEL_REASON');
3800: FND_MSG_PUB.add;
3801: END IF;
3802: x_return_status := FND_API.g_ret_sts_error;
3803: RETURN;
3831: IF AMS_Utility_PVT.is_Y_or_N(p_evo_rec.active_flag) = FND_API.g_false
3832: THEN
3833: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3834: THEN
3835: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_ACTIVE_FLAG');
3836: FND_MSG_PUB.add;
3837: END IF;
3838: x_return_status := FND_API.g_ret_sts_error;
3839: RETURN;
3848: IF AMS_Utility_PVT.is_Y_or_N(p_evo_rec.private_flag) = FND_API.g_false
3849: THEN
3850: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3851: THEN
3852: FND_MESSAGE.set_name('AMS', 'AMS_evo_BAD_PRIVATE_FLAG');
3853: FND_MSG_PUB.add;
3854: END IF;
3855: x_return_status := FND_API.g_ret_sts_error;
3856: RETURN;
3863: IF AMS_Utility_PVT.is_Y_or_N(p_evo_rec.event_full_flag) = FND_API.g_false
3864: THEN
3865: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3866: THEN
3867: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_FULL_FLAG');
3868: FND_MSG_PUB.add;
3869: END IF;
3870:
3871: x_return_status := FND_API.g_ret_sts_error;
3879: IF AMS_Utility_PVT.is_Y_or_N(p_evo_rec.auto_register_flag) = FND_API.g_false
3880: THEN
3881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3882: THEN
3883: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_AUTOREG_FLAG');
3884: FND_MSG_PUB.add;
3885: END IF;
3886:
3887: x_return_status := FND_API.g_ret_sts_error;
3895: IF AMS_Utility_PVT.is_Y_or_N(p_evo_rec.event_standalone_flag) = FND_API.g_false
3896: THEN
3897: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3898: THEN
3899: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_STANDALONE_FLAG');
3900: FND_MSG_PUB.add;
3901: END IF;
3902:
3903: x_return_status := FND_API.g_ret_sts_error;
3911: IF AMS_Utility_PVT.is_Y_or_N(p_evo_rec.reg_required_flag) = FND_API.g_false
3912: THEN
3913: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3914: THEN
3915: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_REG_REQUIRED_FLAG');
3916: FND_MSG_PUB.add;
3917: END IF;
3918:
3919: x_return_status := FND_API.g_ret_sts_error;
3928: IF AMS_Utility_PVT.is_Y_or_N(p_evo_rec.reg_invited_only_flag) = FND_API.g_false
3929: THEN
3930: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3931: THEN
3932: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_REG_INVITED_ONLY_FLAG');
3933: FND_MSG_PUB.add;
3934: END IF;
3935:
3936: x_return_status := FND_API.g_ret_sts_error;
3944: IF AMS_Utility_PVT.is_Y_or_N(p_evo_rec.reg_waitlist_allowed_flag) = FND_API.g_false
3945: THEN
3946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3947: THEN
3948: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_REG_WAITLIST_ALLOWED_FLAG');
3949: FND_MSG_PUB.add;
3950: END IF;
3951:
3952: x_return_status := FND_API.g_ret_sts_error;
3960: IF AMS_Utility_PVT.is_Y_or_N(p_evo_rec.reg_overbook_allowed_flag) = FND_API.g_false
3961: THEN
3962: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3963: THEN
3964: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_REG_OVERBOOK_ALLOWED_FLAG');
3965: FND_MSG_PUB.add;
3966: END IF;
3967:
3968: x_return_status := FND_API.g_ret_sts_error;
3976: IF AMS_Utility_PVT.is_Y_or_N(p_evo_rec.reg_charge_flag) = 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_EVO_BAD_REG_CHARGE_FLAG');
3981: FND_MSG_PUB.add;
3982: END IF;
3983:
3984: x_return_status := FND_API.g_ret_sts_error;
3992: IF AMS_Utility_PVT.is_Y_or_N(p_evo_rec.reg_frozen_flag) = FND_API.g_false
3993: THEN
3994: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
3995: THEN
3996: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_REG_FROZEN_FLAG');
3997: FND_MSG_PUB.add;
3998: END IF;
3999:
4000: x_return_status := FND_API.g_ret_sts_error;
4009: IF AMS_Utility_PVT.is_Y_or_N(p_evo_rec.overflow_flag) = FND_API.g_false
4010: THEN
4011: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4012: THEN
4013: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_OVERFLOW_FLAG');
4014: FND_MSG_PUB.add;
4015: END IF;
4016:
4017: x_return_status := FND_API.g_ret_sts_error;
4025: IF AMS_Utility_PVT.is_Y_or_N(p_evo_rec.partner_flag) = FND_API.g_false
4026: THEN
4027: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4028: THEN
4029: FND_MESSAGE.set_name('AMS', 'AMS_EVO_BAD_PARTNER_FLAG');
4030: FND_MSG_PUB.add;
4031: END IF;
4032:
4033: x_return_status := FND_API.g_ret_sts_error;
4207:
4208: IF l_evo_start_date > l_evo_end_date THEN
4209: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4210: THEN
4211: FND_MESSAGE.set_name('AMS', 'AMS_EVO_START_DT_GT_END_DT');
4212: FND_MSG_PUB.add;
4213: END IF;
4214: x_return_status := FND_API.g_ret_sts_error;
4215: return;
4220: fetch get_parent_date into l_parent_start_date, l_parent_end_date;
4221: close get_parent_date;
4222: IF l_evo_start_date < l_parent_start_date THEN
4223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4224: FND_MESSAGE.set_name('AMS', 'AMS_EVO_SD_GT_PRNT_SD');
4225: FND_MSG_PUB.add;
4226: END IF;
4227: x_return_status := FND_API.g_ret_sts_error;
4228: return;
4228: return;
4229: END IF;
4230: IF l_evo_start_date > l_parent_end_date THEN
4231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4232: FND_MESSAGE.set_name('AMS', 'AMS_EVO_SD_LT_PRNT_ED');
4233: FND_MSG_PUB.add;
4234: END IF;
4235: x_return_status := FND_API.g_ret_sts_error;
4236: return;
4236: return;
4237: END IF;
4238: IF l_evo_end_date < l_parent_start_date THEN
4239: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4240: FND_MESSAGE.set_name('AMS', 'AMS_EVO_ED_GT_PRNT_SD');
4241: FND_MSG_PUB.add;
4242: END IF;
4243: x_return_status := FND_API.g_ret_sts_error;
4244: return;
4244: return;
4245: END IF;
4246: IF l_evo_end_date > l_parent_end_date THEN
4247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4248: FND_MESSAGE.set_name('AMS', 'AMS_EVO_ED_LT_PRNT_ED');
4249: FND_MSG_PUB.add;
4250: END IF;
4251: x_return_status := FND_API.g_ret_sts_error;
4252: return;
4287: END IF;
4288:
4289: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4290: THEN
4291: FND_MESSAGE.set_name('AMS', 'AMS_EVO_START_TM_GT_END_TM');
4292: FND_MSG_PUB.add;
4293: END IF;
4294: x_return_status := FND_API.g_ret_sts_error;
4295: return;
4380: IF l_evo_start_date_time > l_evo_end_date_time
4381: THEN
4382: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4383: THEN
4384: FND_MESSAGE.set_name('AMS', 'AMS_EVO_START_TM_GT_END_TM');
4385: FND_MSG_PUB.add;
4386: END IF;
4387: x_return_status := FND_API.g_ret_sts_error;
4388: return;
4460: FETCH c_evo INTO l_evo_rec;
4461: IF c_evo%NOTFOUND THEN
4462: CLOSE c_evo;
4463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4464: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
4465: FND_MSG_PUB.add;
4466: END IF;
4467: RAISE FND_API.g_exc_error;
4468: END IF;
4487: IF p_evo_rec.system_status_code <> 'COMPLETED' THEN ----batoleti Ref Bug# 4404567
4488: IF p_evo_rec.reg_start_date > l_evo_end_date THEN
4489: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4490: THEN
4491: FND_MESSAGE.set_name('AMS', 'AMS_EVO_REGST_DT_GT_START_DT');
4492: FND_MSG_PUB.add;
4493: END IF;
4494: x_return_status := FND_API.g_ret_sts_error;
4495: END IF;
4497:
4498: IF p_evo_rec.reg_end_date > l_evo_end_date THEN
4499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4500: THEN
4501: FND_MESSAGE.set_name('AMS', 'AMS_EVO_REGED_DT_GT_END_DT');
4502: FND_MSG_PUB.add;
4503: END IF;
4504: x_return_status := FND_API.g_ret_sts_error;
4505: END IF;
4512: IF (p_evo_rec.REG_MINIMUM_REQ_BY_DATE > p_evo_rec.reg_end_date or
4513: p_evo_rec.REG_MINIMUM_REQ_BY_DATE < p_evo_rec.reg_start_date)THEN
4514: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4515: THEN
4516: FND_MESSAGE.set_name('AMS', 'AMS_EVO_REQ_DT_GT_RGEND_DT');
4517: FND_MSG_PUB.add;
4518: END IF;
4519: x_return_status := FND_API.g_ret_sts_error;
4520: END IF;
4525: THEN
4526: IF p_evo_rec.reg_start_date > p_evo_rec.reg_end_date THEN
4527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4528: THEN
4529: FND_MESSAGE.set_name('AMS', 'AMS_EVO_RGSTDT_GT_RGEND_DT');
4530: FND_MSG_PUB.add;
4531: END IF;
4532: x_return_status := FND_API.g_ret_sts_error;
4533: ELSIF p_evo_rec.reg_start_date = p_evo_rec.reg_end_date THEN
4537: THEN
4538: IF p_evo_rec.reg_start_time > p_evo_rec.reg_end_time THEN
4539: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4540: THEN
4541: FND_MESSAGE.set_name('AMS', 'AMS_EVO_RGSTTM_GT_RGEND_TM');
4542: FND_MSG_PUB.add;
4543: END IF;
4544: x_return_status := FND_API.g_ret_sts_error;
4545: END IF; -- st tm > end tm
4568: )
4569: THEN
4570: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4571: THEN
4572: FND_MESSAGE.set_name('AMS', 'AMS_EVO_MINCAP_GT_MAXCAP');
4573: FND_MSG_PUB.add;
4574: END IF;
4575: x_return_status := FND_API.g_ret_sts_error;
4576: END IF;
5139: FETCH c_evo INTO l_evo_rec;
5140: IF c_evo%NOTFOUND THEN
5141: CLOSE c_evo;
5142: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5143: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
5144: FND_MSG_PUB.add;
5145: END IF;
5146: RAISE FND_API.g_exc_error;
5147: END IF;
5152: FETCH c_location INTO l_city, l_state, l_country;
5153: IF c_location%NOTFOUND THEN
5154: CLOSE c_location;
5155: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
5156: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
5157: FND_MSG_PUB.add;
5158: END IF;
5159: RAISE FND_API.g_exc_error;
5160: END IF;
6172: 'EVEH',
6173: l_return_status,
6174: l_lookup_meaning);
6175: -- General Message saying copying has started
6176: fnd_message.set_name('AMS', 'AMS_COPY_ELEMENTS');
6177: fnd_message.set_token('ELEMENTS', l_lookup_meaning, TRUE);
6178: l_mesg_text := fnd_message.get;
6179: -- Writing to the Pl/SQLtable
6180: ams_cpyutility_pvt.write_log_mesg('EVEH', p_src_evh_id, l_mesg_text, 'GENERAL');
6173: l_return_status,
6174: l_lookup_meaning);
6175: -- General Message saying copying has started
6176: fnd_message.set_name('AMS', 'AMS_COPY_ELEMENTS');
6177: fnd_message.set_token('ELEMENTS', l_lookup_meaning, TRUE);
6178: l_mesg_text := fnd_message.get;
6179: -- Writing to the Pl/SQLtable
6180: ams_cpyutility_pvt.write_log_mesg('EVEH', p_src_evh_id, l_mesg_text, 'GENERAL');
6181: l_return_status := NULL;
6174: l_lookup_meaning);
6175: -- General Message saying copying has started
6176: fnd_message.set_name('AMS', 'AMS_COPY_ELEMENTS');
6177: fnd_message.set_token('ELEMENTS', l_lookup_meaning, TRUE);
6178: l_mesg_text := fnd_message.get;
6179: -- Writing to the Pl/SQLtable
6180: ams_cpyutility_pvt.write_log_mesg('EVEH', p_src_evh_id, l_mesg_text, 'GENERAL');
6181: l_return_status := NULL;
6182: l_msg_count := 0;
6187: FETCH c_get_header_info into l_eventheader_rec;
6188: IF (c_get_header_info%NOTFOUND) THEN
6189: CLOSE c_get_header_info;
6190: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
6191: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
6192: FND_MSG_PUB.add;
6193: END IF;
6194: RAISE FND_API.g_exc_error;
6195: END IF;
6429: 'EVEH',
6430: l_return_status,
6431: l_lookup_meaning);
6432: -- General Message saying copying has started
6433: fnd_message.set_name('AMS', 'AMS_COPY_ELEMENTS');
6434: fnd_message.set_token('ELEMENTS', l_lookup_meaning, TRUE);
6435: l_mesg_text := fnd_message.get;
6436: -- Writing to the Pl/SQLtable
6437: ams_cpyutility_pvt.write_log_mesg('EVEH', p_src_evh_id, l_mesg_text, 'GENERAL');
6430: l_return_status,
6431: l_lookup_meaning);
6432: -- General Message saying copying has started
6433: fnd_message.set_name('AMS', 'AMS_COPY_ELEMENTS');
6434: fnd_message.set_token('ELEMENTS', l_lookup_meaning, TRUE);
6435: l_mesg_text := fnd_message.get;
6436: -- Writing to the Pl/SQLtable
6437: ams_cpyutility_pvt.write_log_mesg('EVEH', p_src_evh_id, l_mesg_text, 'GENERAL');
6438: l_return_status := NULL;
6431: l_lookup_meaning);
6432: -- General Message saying copying has started
6433: fnd_message.set_name('AMS', 'AMS_COPY_ELEMENTS');
6434: fnd_message.set_token('ELEMENTS', l_lookup_meaning, TRUE);
6435: l_mesg_text := fnd_message.get;
6436: -- Writing to the Pl/SQLtable
6437: ams_cpyutility_pvt.write_log_mesg('EVEH', p_src_evh_id, l_mesg_text, 'GENERAL');
6438: l_return_status := NULL;
6439: l_msg_count := 0;
7041: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7042:
7043: IF (p_evo_rec.event_level = 'MAIN') THEN
7044: IF (p_evo_rec.event_object_type = 'EVEO') THEN
7045: Fnd_Message.set_name('AMS', 'AMS_EVT_STDT_LS_EVNT_STDT');
7046: ELSE
7047: Fnd_Message.set_name('AMS', 'AMS_EVT_STDT_LS_PRG_STDT');
7048: END IF;
7049: ELSIF (p_evo_rec.event_level = 'SUB') THEN
7043: IF (p_evo_rec.event_level = 'MAIN') THEN
7044: IF (p_evo_rec.event_object_type = 'EVEO') THEN
7045: Fnd_Message.set_name('AMS', 'AMS_EVT_STDT_LS_EVNT_STDT');
7046: ELSE
7047: Fnd_Message.set_name('AMS', 'AMS_EVT_STDT_LS_PRG_STDT');
7048: END IF;
7049: ELSIF (p_evo_rec.event_level = 'SUB') THEN
7050: Fnd_Message.set_name('AMS', 'AMS_AGEN_STDT_LS_EVNT_STDT');
7051: END IF;
7046: ELSE
7047: Fnd_Message.set_name('AMS', 'AMS_EVT_STDT_LS_PRG_STDT');
7048: END IF;
7049: ELSIF (p_evo_rec.event_level = 'SUB') THEN
7050: Fnd_Message.set_name('AMS', 'AMS_AGEN_STDT_LS_EVNT_STDT');
7051: END IF;
7052:
7053: Fnd_Msg_Pub.ADD;
7054: x_return_status := Fnd_Api.g_ret_sts_error;
7066: END IF;
7067: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7068:
7069: IF (p_evo_rec.event_object_type = 'EVEO') THEN
7070: Fnd_Message.set_name('AMS', 'AMS_EVT_EDDT_GT_EVNT_EDDT');
7071: ELSE
7072: Fnd_Message.set_name('AMS', 'AMS_EVT_EDDT_GT_PRG_EDDT');
7073: END IF;
7074:
7068:
7069: IF (p_evo_rec.event_object_type = 'EVEO') THEN
7070: Fnd_Message.set_name('AMS', 'AMS_EVT_EDDT_GT_EVNT_EDDT');
7071: ELSE
7072: Fnd_Message.set_name('AMS', 'AMS_EVT_EDDT_GT_PRG_EDDT');
7073: END IF;
7074:
7075: Fnd_Msg_Pub.ADD;
7076: x_return_status := Fnd_Api.g_ret_sts_error;
7085: END IF;
7086: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7087:
7088: IF (p_evo_rec.event_object_type = 'EVEO') THEN
7089: Fnd_Message.set_name('AMS', 'AMS_EVT_EDDT_GT_EVNT_EDDT');
7090: ELSE
7091: Fnd_Message.set_name('AMS', 'AMS_EVT_EDDT_GT_PRG_EDDT');
7092: END IF;
7093:
7087:
7088: IF (p_evo_rec.event_object_type = 'EVEO') THEN
7089: Fnd_Message.set_name('AMS', 'AMS_EVT_EDDT_GT_EVNT_EDDT');
7090: ELSE
7091: Fnd_Message.set_name('AMS', 'AMS_EVT_EDDT_GT_PRG_EDDT');
7092: END IF;
7093:
7094: Fnd_Msg_Pub.ADD;
7095: x_return_status := Fnd_Api.g_ret_sts_error;
7100: END IF;
7101:
7102: IF (p_evo_rec.event_level = 'SUB') THEN
7103: IF (p_evo_rec.event_start_date > l_end_date) THEN
7104: Fnd_Message.set_name('AMS', 'AMS_AGEN_STDT_GT_EVNT_EDDT');
7105: Fnd_Msg_Pub.ADD;
7106: x_return_status := Fnd_Api.g_ret_sts_error;
7107: RETURN;
7108: END IF;
7157: IF (AMS_DEBUG_HIGH_ON) THEN
7158:
7159: Ams_Utility_Pvt.debug_message('The Parent is not Active');
7160: END IF;
7161: Fnd_Message.set_name('AMS', 'AMS_PROGRAM_NOT_ACTIVE');
7162: ELSIF p_evo_rec.event_object_type = 'EVEO' THEN
7163: IF (AMS_DEBUG_HIGH_ON) THEN
7164:
7165: Ams_Utility_Pvt.debug_message('The Parent is not Active');
7163: IF (AMS_DEBUG_HIGH_ON) THEN
7164:
7165: Ams_Utility_Pvt.debug_message('The Parent is not Active');
7166: END IF;
7167: Fnd_Message.set_name('AMS', 'AMS_EVENT_NOT_ACTIVE');
7168: END IF;
7169:
7170: Fnd_Msg_Pub.ADD;
7171: x_return_status := Fnd_Api.g_ret_sts_error;