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_EVENTOFFER_PVT dependencies on FND_MSG_PUB

Line 5: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

1: PACKAGE BODY AMS_EventOffer_PVT AS
2: /*$Header: amsvevob.pls 120.13 2006/10/26 01:06:17 batoleti ship $*/
3: g_pkg_name CONSTANT VARCHAR2(30):='AMS_EventOffer_PVT';
4:
5: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
6: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
7: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8:
9: PROCEDURE Check_Dates_Range (

Line 6: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

2: /*$Header: amsvevob.pls 120.13 2006/10/26 01:06:17 batoleti ship $*/
3: g_pkg_name CONSTANT VARCHAR2(30):='AMS_EventOffer_PVT';
4:
5: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
6: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
7: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8:
9: PROCEDURE Check_Dates_Range (
10: p_evo_rec IN evo_rec_type,

Line 7: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

3: g_pkg_name CONSTANT VARCHAR2(30):='AMS_EventOffer_PVT';
4:
5: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
6: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
7: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8:
9: PROCEDURE Check_Dates_Range (
10: p_evo_rec IN evo_rec_type,
11: x_return_status OUT NOCOPY VARCHAR2

Line 363: FND_MSG_PUB.initialize;

359:
360: END IF;
361:
362: IF FND_API.to_boolean(p_init_msg_list) THEN
363: FND_MSG_PUB.initialize;
364: END IF;
365:
366: IF NOT FND_API.compatible_api_call(
367: l_api_version,

Line 415: FND_MSG_PUB.add;

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;
419:

Line 490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

486: fetch get_res_id into l_res_id;
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;

Line 492: FND_MSG_PUB.add;

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;
496: END IF;

Line 559: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)

555:
556:
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;

Line 562: Fnd_Msg_Pub.ADD;

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;
566: END IF; -- st tm > end tm

Line 1080: FND_MSG_PUB.count_and_get(

1076: IF FND_API.to_boolean(p_commit) THEN
1077: COMMIT;
1078: END IF;
1079:
1080: FND_MSG_PUB.count_and_get(
1081: p_encoded => FND_API.g_false,
1082: p_count => x_msg_count,
1083: p_data => x_msg_data
1084: );

Line 1099: FND_MSG_PUB.count_and_get(

1095:
1096: WHEN FND_API.g_exc_error THEN
1097: ROLLBACK TO create_event_offer;
1098: x_return_status := FND_API.g_ret_sts_error;
1099: FND_MSG_PUB.count_and_get(
1100: p_encoded => FND_API.g_false,
1101: p_count => x_msg_count,
1102: p_data => x_msg_data
1103: );

Line 1108: FND_MSG_PUB.count_and_get(

1104:
1105: WHEN FND_API.g_exc_unexpected_error THEN
1106: ROLLBACK TO create_event_offer;
1107: x_return_status := FND_API.g_ret_sts_unexp_error ;
1108: FND_MSG_PUB.count_and_get(
1109: p_encoded => FND_API.g_false,
1110: p_count => x_msg_count,
1111: p_data => x_msg_data
1112: );

Line 1127: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1123:
1124: ROLLBACK TO create_event_offer;
1125: x_return_status := FND_API.g_ret_sts_unexp_error ;
1126:
1127: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1128: THEN
1129: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1130: END IF;
1131:

Line 1129: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1125: x_return_status := FND_API.g_ret_sts_unexp_error ;
1126:
1127: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1128: THEN
1129: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1130: END IF;
1131:
1132: FND_MSG_PUB.count_and_get(
1133: p_encoded => FND_API.g_false,

Line 1132: FND_MSG_PUB.count_and_get(

1128: THEN
1129: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1130: END IF;
1131:
1132: FND_MSG_PUB.count_and_get(
1133: p_encoded => FND_API.g_false,
1134: p_count => x_msg_count,
1135: p_data => x_msg_data
1136: );

Line 1201: FND_MSG_PUB.initialize;

1197:
1198: END IF;
1199:
1200: IF FND_API.to_boolean(p_init_msg_list) THEN
1201: FND_MSG_PUB.initialize;
1202: END IF;
1203:
1204: IF NOT FND_API.compatible_api_call(
1205: l_api_version,

Line 1239: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1235: IF (l_level <> 'SUB' OR l_level IS NULL ) THEN
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;

Line 1241: FND_MSG_PUB.add;

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;
1245:

Line 1258: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1254: WHERE event_offer_id = p_evo_id
1255: AND object_version_number = p_object_version;
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;

Line 1261: FND_MSG_PUB.add;

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;
1265:

Line 1271: FND_MSG_PUB.count_and_get(

1267: IF FND_API.to_boolean(p_commit) THEN
1268: COMMIT;
1269: END IF;
1270:
1271: FND_MSG_PUB.count_and_get(
1272: p_encoded => FND_API.g_false,
1273: p_count => x_msg_count,
1274: p_data => x_msg_data
1275: );

Line 1290: FND_MSG_PUB.count_and_get(

1286:
1287: WHEN FND_API.g_exc_error THEN
1288: ROLLBACK TO delete_event_offer;
1289: x_return_status := FND_API.g_ret_sts_error;
1290: FND_MSG_PUB.count_and_get(
1291: p_encoded => FND_API.g_false,
1292: p_count => x_msg_count,
1293: p_data => x_msg_data
1294: );

Line 1299: FND_MSG_PUB.count_and_get(

1295:
1296: WHEN FND_API.g_exc_unexpected_error THEN
1297: ROLLBACK TO delete_event_offer;
1298: x_return_status := FND_API.g_ret_sts_unexp_error ;
1299: FND_MSG_PUB.count_and_get(
1300: p_encoded => FND_API.g_false,
1301: p_count => x_msg_count,
1302: p_data => x_msg_data
1303: );

Line 1309: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1305: WHEN OTHERS THEN
1306: ROLLBACK TO delete_event_offer;
1307: x_return_status := FND_API.g_ret_sts_unexp_error ;
1308:
1309: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1310: THEN
1311: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1312: END IF;
1313:

Line 1311: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1307: x_return_status := FND_API.g_ret_sts_unexp_error ;
1308:
1309: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1310: THEN
1311: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1312: END IF;
1313:
1314: FND_MSG_PUB.count_and_get(
1315: p_encoded => FND_API.g_false,

Line 1314: FND_MSG_PUB.count_and_get(

1310: THEN
1311: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1312: END IF;
1313:
1314: FND_MSG_PUB.count_and_get(
1315: p_encoded => FND_API.g_false,
1316: p_count => x_msg_count,
1317: p_data => x_msg_data
1318: );

Line 1372: FND_MSG_PUB.initialize;

1368: AMS_Utility_PVT.debug_message(l_full_name||': start');
1369: END IF;
1370:
1371: IF FND_API.to_boolean(p_init_msg_list) THEN
1372: FND_MSG_PUB.initialize;
1373: END IF;
1374:
1375: IF NOT FND_API.compatible_api_call(
1376: l_api_version,

Line 1396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1392: OPEN c_evo_b;
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;

Line 1398: FND_MSG_PUB.add;

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;
1402: CLOSE c_evo_b;

Line 1408: FND_MSG_PUB.count_and_get(

1404: OPEN c_evo_tl;
1405: CLOSE c_evo_tl;
1406:
1407: -------------------- finish --------------------------
1408: FND_MSG_PUB.count_and_get(
1409: p_encoded => FND_API.g_false,
1410: p_count => x_msg_count,
1411: p_data => x_msg_data
1412: );

Line 1426: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1422: EXCEPTION
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:

Line 1428: FND_MSG_PUB.add;

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(
1432: p_encoded => FND_API.g_false,

Line 1431: FND_MSG_PUB.count_and_get(

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(
1432: p_encoded => FND_API.g_false,
1433: p_count => x_msg_count,
1434: p_data => x_msg_data
1435: );

Line 1439: FND_MSG_PUB.count_and_get(

1435: );
1436:
1437: WHEN FND_API.g_exc_error THEN
1438: x_return_status := FND_API.g_ret_sts_error;
1439: FND_MSG_PUB.count_and_get(
1440: p_encoded => FND_API.g_false,
1441: p_count => x_msg_count,
1442: p_data => x_msg_data
1443: );

Line 1447: FND_MSG_PUB.count_and_get(

1443: );
1444:
1445: WHEN FND_API.g_exc_unexpected_error THEN
1446: x_return_status := FND_API.g_ret_sts_unexp_error ;
1447: FND_MSG_PUB.count_and_get(
1448: p_encoded => FND_API.g_false,
1449: p_count => x_msg_count,
1450: p_data => x_msg_data
1451: );

Line 1455: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1451: );
1452:
1453: WHEN OTHERS THEN
1454: x_return_status := FND_API.g_ret_sts_unexp_error ;
1455: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1456: THEN
1457: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1458: END IF;
1459:

Line 1457: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1453: WHEN OTHERS THEN
1454: x_return_status := FND_API.g_ret_sts_unexp_error ;
1455: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1456: THEN
1457: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1458: END IF;
1459:
1460: FND_MSG_PUB.count_and_get(
1461: p_encoded => FND_API.g_false,

Line 1460: FND_MSG_PUB.count_and_get(

1456: THEN
1457: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1458: END IF;
1459:
1460: FND_MSG_PUB.count_and_get(
1461: p_encoded => FND_API.g_false,
1462: p_count => x_msg_count,
1463: p_data => x_msg_data
1464: );

Line 1687: FND_MSG_PUB.initialize;

1683:
1684: END IF;
1685:
1686: IF FND_API.to_boolean(p_init_msg_list) THEN
1687: FND_MSG_PUB.initialize;
1688: END IF;
1689:
1690: IF NOT FND_API.compatible_api_call(
1691: l_api_version,

Line 1788: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1784: IF c_bdgt_line_yn%NOTFOUND THEN
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;

Line 1790: FND_MSG_PUB.add;

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;
1794: END IF;

Line 1893: FND_MSG_PUB.add;

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');
1897: FND_MSG_PUB.add;

Line 1897: FND_MSG_PUB.add;

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;
1901: END IF;

Line 1951: FND_MSG_PUB.add;

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');
1955: FND_MSG_PUB.add;

Line 1955: FND_MSG_PUB.add;

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;
1959: END IF;

Line 1993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1989: NULL;
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;

Line 1995: FND_MSG_PUB.add;

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;
1999: END IF;

Line 2251: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2247: OPEN c_location(l_evo_rec.event_offer_id);
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;

Line 2253: FND_MSG_PUB.add;

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;
2257: CLOSE c_location;

Line 2352: Fnd_Msg_Pub.ADD;

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;
2356:

Line 2362: Fnd_Msg_Pub.ADD;

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;
2366:

Line 2746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2742: AND object_version_number = l_evo_rec.object_version_number;
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;

Line 2748: FND_MSG_PUB.add;

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;
2752:

Line 2768: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2764: WHERE event_offer_id = l_evo_rec.event_offer_id
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;

Line 2770: FND_MSG_PUB.add;

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;
2774:

Line 2794: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2790: event_venue_id = l_evo_rec.event_venue_id
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;

Line 2796: FND_MSG_PUB.add;

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;
2800:

Line 2889: FND_MSG_PUB.count_and_get(

2885: IF FND_API.to_boolean(p_commit) THEN
2886: COMMIT;
2887: END IF;
2888:
2889: FND_MSG_PUB.count_and_get(
2890: p_encoded => FND_API.g_false,
2891: p_count => x_msg_count,
2892: p_data => x_msg_data
2893: );

Line 2908: FND_MSG_PUB.count_and_get(

2904:
2905: WHEN FND_API.g_exc_error THEN
2906: ROLLBACK TO update_event_offer;
2907: x_return_status := FND_API.g_ret_sts_error;
2908: FND_MSG_PUB.count_and_get(
2909: p_encoded => FND_API.g_false,
2910: p_count => x_msg_count,
2911: p_data => x_msg_data
2912: );

Line 2917: FND_MSG_PUB.count_and_get(

2913:
2914: WHEN FND_API.g_exc_unexpected_error THEN
2915: ROLLBACK TO update_event_offer;
2916: x_return_status := FND_API.g_ret_sts_unexp_error ;
2917: FND_MSG_PUB.count_and_get(
2918: p_encoded => FND_API.g_false,
2919: p_count => x_msg_count,
2920: p_data => x_msg_data
2921: );

Line 2940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

2936:
2937: ROLLBACK TO update_event_offer;
2938: x_return_status := FND_API.g_ret_sts_unexp_error ;
2939:
2940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2941: THEN
2942: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2943: END IF;
2944:

Line 2942: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2938: x_return_status := FND_API.g_ret_sts_unexp_error ;
2939:
2940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2941: THEN
2942: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2943: END IF;
2944:
2945: FND_MSG_PUB.count_and_get(
2946: p_encoded => FND_API.g_false,

Line 2945: FND_MSG_PUB.count_and_get(

2941: THEN
2942: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2943: END IF;
2944:
2945: FND_MSG_PUB.count_and_get(
2946: p_encoded => FND_API.g_false,
2947: p_count => x_msg_count,
2948: p_data => x_msg_data
2949: );

Line 2986: FND_MSG_PUB.initialize;

2982: AMS_Utility_PVT.debug_message(l_full_name||': start');
2983: END IF;
2984:
2985: IF FND_API.to_boolean(p_init_msg_list) THEN
2986: FND_MSG_PUB.initialize;
2987: END IF;
2988:
2989: IF NOT FND_API.compatible_api_call(
2990: l_api_version,

Line 3064: FND_MSG_PUB.count_and_get(

3060: END IF;
3061: END IF;
3062: END IF;
3063: -------------------- finish --------------------------
3064: FND_MSG_PUB.count_and_get(
3065: p_encoded => FND_API.g_false,
3066: p_count => x_msg_count,
3067: p_data => x_msg_data
3068: );

Line 3082: FND_MSG_PUB.count_and_get(

3078: EXCEPTION
3079:
3080: WHEN FND_API.g_exc_error THEN
3081: x_return_status := FND_API.g_ret_sts_error;
3082: FND_MSG_PUB.count_and_get(
3083: p_encoded => FND_API.g_false,
3084: p_count => x_msg_count,
3085: p_data => x_msg_data
3086: );

Line 3090: FND_MSG_PUB.count_and_get(

3086: );
3087:
3088: WHEN FND_API.g_exc_unexpected_error THEN
3089: x_return_status := FND_API.g_ret_sts_unexp_error ;
3090: FND_MSG_PUB.count_and_get(
3091: p_encoded => FND_API.g_false,
3092: p_count => x_msg_count,
3093: p_data => x_msg_data
3094: );

Line 3098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

3094: );
3095:
3096: WHEN OTHERS THEN
3097: x_return_status := FND_API.g_ret_sts_unexp_error;
3098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3099: THEN
3100: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3101: END IF;
3102:

Line 3100: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3096: WHEN OTHERS THEN
3097: x_return_status := FND_API.g_ret_sts_unexp_error;
3098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3099: THEN
3100: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3101: END IF;
3102:
3103: FND_MSG_PUB.count_and_get(
3104: p_encoded => FND_API.g_false,

Line 3103: FND_MSG_PUB.count_and_get(

3099: THEN
3100: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3101: END IF;
3102:
3103: FND_MSG_PUB.count_and_get(
3104: p_encoded => FND_API.g_false,
3105: p_count => x_msg_count,
3106: p_data => x_msg_data
3107: );

Line 3155: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3151:
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;

Line 3157: FND_MSG_PUB.add;

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;
3161: END IF;

Line 3165: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3161: END IF;
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;

Line 3167: FND_MSG_PUB.add;

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;
3171: END IF;

Line 3175: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3171: END IF;
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;

Line 3177: FND_MSG_PUB.add;

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;
3181: END IF;

Line 3185: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3181: END IF;
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;

Line 3187: FND_MSG_PUB.add;

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;
3191: END IF;

Line 3197: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3193: -- commenting NEEDS TO BE UNCOMMENTED
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;

Line 3199: FND_MSG_PUB.add;

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;
3203: END IF;

Line 3238: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3234: 'ams_event_offers_all_b',
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;

Line 3240: FND_MSG_PUB.add;

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;
3244: END IF;

Line 3264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3260: open c_src_code(p_evo_rec.source_code);
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;

Line 3266: FND_MSG_PUB.add;

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;
3270: END IF;

Line 3309: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3305: 'resource_id',
3306: p_evo_rec.owner_user_id
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;

Line 3312: FND_MSG_PUB.add;

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;
3316: END IF;

Line 3328: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3324: 'application_id',
3325: p_evo_rec.application_id
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;

Line 3331: FND_MSG_PUB.add;

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;
3335: END IF;

Line 3348: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3344: p_evo_rec.inbound_script_name,
3345: AMS_Utility_PVT.g_varchar2
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;

Line 3351: FND_MSG_PUB.add;

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;
3355: END IF;

Line 3367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3363: 'event_header_id',
3364: p_evo_rec.event_header_id
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;

Line 3370: FND_MSG_PUB.add;

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;
3374: END IF;

Line 3387: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3383: 'event_offer_id',
3384: p_evo_rec.parent_event_offer_id
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;

Line 3390: FND_MSG_PUB.add;

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;
3394: END IF;

Line 3405: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3401: 'CAMPAIGN_ID',
3402: p_evo_rec.parent_id
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;

Line 3408: FND_MSG_PUB.add;

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;
3412: END IF;

Line 3424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3420: p_evo_rec.event_duration_uom_code,
3421: AMS_Utility_PVT.g_varchar2
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;

Line 3427: FND_MSG_PUB.add;

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;
3431: END IF;

Line 3442: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3438: 'list_header_id',
3439: p_evo_rec.pricelist_header_id
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;

Line 3445: FND_MSG_PUB.add;

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;
3449: END IF;

Line 3460: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3456: 'list_line_id',
3457: p_evo_rec.pricelist_line_id
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;

Line 3463: FND_MSG_PUB.add;

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;
3467: END IF;

Line 3478: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3474: 'upgrade_tz_id',
3475: p_evo_rec.timezone_id
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;

Line 3481: FND_MSG_PUB.add;

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;
3485: END IF;

Line 3496: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3492: 'upgrade_tz_id',
3493: p_evo_rec.reg_timezone_id
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;

Line 3499: FND_MSG_PUB.add;

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;
3503: END IF;

Line 3514: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3510: 'venue_id',
3511: p_evo_rec.event_venue_id
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;

Line 3517: FND_MSG_PUB.add;

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;
3521: END IF;

Line 3533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3529: p_evo_rec.event_language_code,
3530: AMS_Utility_PVT.g_varchar2
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;

Line 3536: FND_MSG_PUB.add;

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;
3540: END IF;

Line 3551: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3547: 'location_id',
3548: p_evo_rec.event_location_id
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;

Line 3554: FND_MSG_PUB.add;

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;
3558: END IF;

Line 3595: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3591: 'user_status_id',
3592: p_evo_rec.user_status_id
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;

Line 3598: FND_MSG_PUB.add;

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;
3602: RETURN;

Line 3624: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3620: AMS_UTILITY_PVT.g_number,
3621: l_where_clause
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;

Line 3627: FND_MSG_PUB.add;

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;
3631: RETURN;

Line 3669: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3665: p_lookup_type => 'AMS_EVENT_TYPE',
3666: p_lookup_code => p_evo_rec.event_type_code
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;

Line 3672: FND_MSG_PUB.add;

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;
3676: END IF;

Line 3687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3683: p_lookup_type => 'AMS_EVENT_LEVEL',
3684: p_lookup_code => p_evo_rec.event_level
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;

Line 3690: FND_MSG_PUB.add;

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;
3694: END IF;

Line 3705: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3701: p_lookup_type => 'AMS_EVENT_WAITLIST_ACTION',
3702: p_lookup_code => p_evo_rec.waitlist_action_type_code
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;

Line 3708: FND_MSG_PUB.add;

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;
3712: END IF;

Line 3723: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3719: p_lookup_type => 'AMS_EVENT_STREAM_TYPE',
3720: p_lookup_code => p_evo_rec.stream_type_code
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;

Line 3726: FND_MSG_PUB.add;

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;
3730: END IF;

Line 3741: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3737: p_lookup_type => 'AMS_FUND_SOURCE',
3738: p_lookup_code => p_evo_rec.fund_source_type_code
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;

Line 3744: FND_MSG_PUB.add;

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;
3748: END IF;

Line 3759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3755: p_lookup_type => 'AMS_PRIORITY',
3756: p_lookup_code => p_evo_rec.priority_type_code
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;

Line 3762: FND_MSG_PUB.add;

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;
3766: END IF;

Line 3778: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3774: p_lookup_type => 'AMS_EVENT_CERT_CREDIT_TYPE',
3775: p_lookup_code => p_evo_rec.cert_credit_type_code
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;

Line 3781: FND_MSG_PUB.add;

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;
3785: END IF;

Line 3797: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3793: p_lookup_type => 'AMS_EVENT_CANCEL_REASON',
3794: p_lookup_code => p_evo_rec.cancellation_reason_code
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;

Line 3800: FND_MSG_PUB.add;

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;
3804: END IF;

Line 3833: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3829: AND p_evo_rec.active_flag IS NOT NULL
3830: THEN
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;

Line 3836: FND_MSG_PUB.add;

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;
3840: END IF;

Line 3850: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3846: AND p_evo_rec.private_flag IS NOT NULL
3847: THEN
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;

Line 3853: FND_MSG_PUB.add;

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;
3857: END IF;

Line 3865: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3861: AND p_evo_rec.event_full_flag IS NOT NULL
3862: THEN
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;

Line 3868: FND_MSG_PUB.add;

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;
3872: RETURN;

Line 3881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3877: AND p_evo_rec.auto_register_flag IS NOT NULL
3878: THEN
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;

Line 3884: FND_MSG_PUB.add;

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;
3888: RETURN;

Line 3897: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3893: AND p_evo_rec.event_standalone_flag IS NOT NULL
3894: THEN
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;

Line 3900: FND_MSG_PUB.add;

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;
3904: RETURN;

Line 3913: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3909: AND p_evo_rec.reg_required_flag IS NOT NULL
3910: THEN
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;

Line 3916: FND_MSG_PUB.add;

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;
3920: RETURN;

Line 3930: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3926: AND p_evo_rec.reg_invited_only_flag IS NOT NULL
3927: THEN
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;

Line 3933: FND_MSG_PUB.add;

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;
3937: RETURN;

Line 3946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3942: AND p_evo_rec.reg_waitlist_allowed_flag IS NOT NULL
3943: THEN
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;

Line 3949: FND_MSG_PUB.add;

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;
3953: RETURN;

Line 3962: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3958: AND p_evo_rec.reg_overbook_allowed_flag IS NOT NULL
3959: THEN
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;

Line 3965: FND_MSG_PUB.add;

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;
3969: RETURN;

Line 3978: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3974: AND p_evo_rec.reg_charge_flag IS NOT NULL
3975: THEN
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;

Line 3981: FND_MSG_PUB.add;

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;
3985: RETURN;

Line 3994: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

3990: AND p_evo_rec.reg_frozen_flag IS NOT NULL
3991: THEN
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;

Line 3997: FND_MSG_PUB.add;

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;
4001: RETURN;

Line 4011: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

4007: AND p_evo_rec.overflow_flag IS NOT NULL
4008: THEN
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;

Line 4014: FND_MSG_PUB.add;

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;
4018: RETURN;

Line 4027: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

4023: AND p_evo_rec.partner_flag IS NOT NULL
4024: THEN
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;

Line 4030: FND_MSG_PUB.add;

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;
4034: RETURN;

Line 4209: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

4205: l_evo_end_date := p_complete_rec.event_end_date;
4206: END IF;
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;

Line 4212: FND_MSG_PUB.add;

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;
4216: END IF;

Line 4223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4219: open get_parent_date(p_evo_rec.parent_id);
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;

Line 4225: FND_MSG_PUB.add;

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;
4229: END IF;

Line 4231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4227: x_return_status := FND_API.g_ret_sts_error;
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;

Line 4233: FND_MSG_PUB.add;

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;
4237: END IF;

Line 4239: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4235: x_return_status := FND_API.g_ret_sts_error;
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;

Line 4241: FND_MSG_PUB.add;

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;
4245: END IF;

Line 4247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4243: x_return_status := FND_API.g_ret_sts_error;
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;

Line 4249: FND_MSG_PUB.add;

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;
4253: END IF;

Line 4289: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

4285:
4286: AMS_UTILITY_PVT.debug_message('Entered the loop');
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;

Line 4292: FND_MSG_PUB.add;

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;
4296: END IF; -- st tm > end tm

Line 4382: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

4378:
4379:
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;

Line 4385: FND_MSG_PUB.add;

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;
4389: END IF;

Line 4463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4459: OPEN c_evo;
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;

Line 4465: FND_MSG_PUB.add;

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;
4469: CLOSE c_evo;

Line 4489: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

4485: updation process...
4486: *** */
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;

Line 4492: FND_MSG_PUB.add;

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;
4496:

Line 4499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

4495: END IF;
4496:
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;

Line 4502: FND_MSG_PUB.add;

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;
4506: END IF; --batoleti Ref Bug# 4404567

Line 4514: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

4510: AND p_evo_rec.reg_end_date <> FND_API.g_miss_date
4511: THEN
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;

Line 4517: FND_MSG_PUB.add;

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;
4521: END IF;

Line 4527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

4523: IF p_evo_rec.reg_start_date <> FND_API.g_miss_date
4524: AND p_evo_rec.reg_end_date <> FND_API.g_miss_date
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;

Line 4530: FND_MSG_PUB.add;

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
4534: -- test for reg times

Line 4539: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

4535: IF p_evo_rec.reg_start_time <> FND_API.g_miss_date
4536: OR p_evo_rec.reg_end_time <> FND_API.g_miss_date
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;

Line 4542: FND_MSG_PUB.add;

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
4546: END IF; -- check time for miss_dates

Line 4570: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

4566: IF ( (p_evo_rec.REG_MINIMUM_CAPACITY <> FND_API.g_miss_num)
4567: AND (p_evo_rec.REG_MINIMUM_CAPACITY > l_max_cap)
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;

Line 4573: FND_MSG_PUB.add;

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;
4577: END IF;

Line 5142: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

5138: OPEN c_evo;
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;

Line 5144: FND_MSG_PUB.add;

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;
5148: CLOSE c_evo;

Line 5155: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

5151: OPEN c_location(l_evo_rec.event_location_id);
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;

Line 5157: FND_MSG_PUB.add;

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;
5161: CLOSE c_location;

Line 5745: FND_MSG_PUB.add_exc_msg(p_error_text => l_err_txt);

5741: --l_msg_count := x_error_tbl.count;
5742: FOR i IN 1 .. x_error_tbl.count LOOP
5743: l_err_txt := l_err_txt || x_error_tbl(i).message_text;
5744: END LOOP;
5745: FND_MSG_PUB.add_exc_msg(p_error_text => l_err_txt);
5746: FND_MSG_PUB.count_and_get(
5747: p_encoded => FND_API.g_false,
5748: p_count => x_msg_count,
5749: p_data => x_msg_data

Line 5746: FND_MSG_PUB.count_and_get(

5742: FOR i IN 1 .. x_error_tbl.count LOOP
5743: l_err_txt := l_err_txt || x_error_tbl(i).message_text;
5744: END LOOP;
5745: FND_MSG_PUB.add_exc_msg(p_error_text => l_err_txt);
5746: FND_MSG_PUB.count_and_get(
5747: p_encoded => FND_API.g_false,
5748: p_count => x_msg_count,
5749: p_data => x_msg_data
5750: );

Line 5756: FND_MSG_PUB.count_and_get(

5752: WHEN FND_API.g_exc_unexpected_error THEN
5753: --x_return_status := FND_API.g_ret_sts_unexp_error ;
5754: l_msg_count := x_error_tbl.count;
5755: FOR i IN 1 .. x_error_tbl.count LOOP
5756: FND_MSG_PUB.count_and_get(
5757: p_encoded => FND_API.g_false,
5758: p_count => l_msg_count,
5759: p_data => x_error_tbl(i).message_text
5760: );

Line 5766: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

5762:
5763: WHEN OTHERS THEN
5764: -- x_return_status := FND_API.g_ret_sts_unexp_error;
5765: l_msg_count := x_error_tbl.count;
5766: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
5767: THEN
5768: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5769: END IF;
5770:

Line 5768: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

5764: -- x_return_status := FND_API.g_ret_sts_unexp_error;
5765: l_msg_count := x_error_tbl.count;
5766: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
5767: THEN
5768: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5769: END IF;
5770:
5771: FOR i IN 1 .. x_error_tbl.count LOOP
5772: FND_MSG_PUB.count_and_get(

Line 5772: FND_MSG_PUB.count_and_get(

5768: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5769: END IF;
5770:
5771: FOR i IN 1 .. x_error_tbl.count LOOP
5772: FND_MSG_PUB.count_and_get(
5773: p_encoded => FND_API.g_false,
5774: p_count => l_msg_count,
5775: p_data => x_msg_data
5776: );

Line 5905: FND_MSG_PUB.count_and_get(

5901: EXCEPTION
5902:
5903: WHEN FND_API.g_exc_error THEN
5904: x_return_status := FND_API.g_ret_sts_error;
5905: FND_MSG_PUB.count_and_get(
5906: p_encoded => FND_API.g_false,
5907: p_count => x_msg_count,
5908: p_data => x_msg_data
5909: );

Line 5913: FND_MSG_PUB.count_and_get(

5909: );
5910:
5911: WHEN FND_API.g_exc_unexpected_error THEN
5912: x_return_status := FND_API.g_ret_sts_unexp_error ;
5913: FND_MSG_PUB.count_and_get(
5914: p_encoded => FND_API.g_false,
5915: p_count => x_msg_count,
5916: p_data => x_msg_data
5917: );

Line 5921: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

5917: );
5918:
5919: WHEN OTHERS THEN
5920: x_return_status := FND_API.g_ret_sts_unexp_error;
5921: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
5922: THEN
5923: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5924: END IF;
5925: FND_MSG_PUB.count_and_get(

Line 5923: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

5919: WHEN OTHERS THEN
5920: x_return_status := FND_API.g_ret_sts_unexp_error;
5921: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
5922: THEN
5923: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5924: END IF;
5925: FND_MSG_PUB.count_and_get(
5926: p_encoded => FND_API.g_false,
5927: p_count => x_msg_count,

Line 5925: FND_MSG_PUB.count_and_get(

5921: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
5922: THEN
5923: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5924: END IF;
5925: FND_MSG_PUB.count_and_get(
5926: p_encoded => FND_API.g_false,
5927: p_count => x_msg_count,
5928: p_data => x_msg_data
5929: );

Line 6071: FND_MSG_PUB.count_and_get(

6067: EXCEPTION
6068:
6069: WHEN FND_API.g_exc_error THEN
6070: x_return_status := FND_API.g_ret_sts_error;
6071: FND_MSG_PUB.count_and_get(
6072: p_encoded => FND_API.g_false,
6073: p_count => x_msg_count,
6074: p_data => x_msg_data
6075: );

Line 6079: FND_MSG_PUB.count_and_get(

6075: );
6076:
6077: WHEN FND_API.g_exc_unexpected_error THEN
6078: x_return_status := FND_API.g_ret_sts_unexp_error ;
6079: FND_MSG_PUB.count_and_get(
6080: p_encoded => FND_API.g_false,
6081: p_count => x_msg_count,
6082: p_data => x_msg_data
6083: );

Line 6087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

6083: );
6084:
6085: WHEN OTHERS THEN
6086: x_return_status := FND_API.g_ret_sts_unexp_error;
6087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
6088: THEN
6089: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6090: END IF;
6091:

Line 6089: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

6085: WHEN OTHERS THEN
6086: x_return_status := FND_API.g_ret_sts_unexp_error;
6087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
6088: THEN
6089: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6090: END IF;
6091:
6092: FND_MSG_PUB.count_and_get(
6093: p_encoded => FND_API.g_false,

Line 6092: FND_MSG_PUB.count_and_get(

6088: THEN
6089: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6090: END IF;
6091:
6092: FND_MSG_PUB.count_and_get(
6093: p_encoded => FND_API.g_false,
6094: p_count => x_msg_count,
6095: p_data => x_msg_data
6096: );

Line 6151: fnd_msg_pub.initialize;

6147: END IF;
6148:
6149: IF fnd_api.to_boolean(p_init_msg_list)
6150: THEN
6151: fnd_msg_pub.initialize;
6152: END IF;
6153:
6154: IF NOT fnd_api.compatible_api_call(
6155: l_api_version,

Line 6190: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

6186: OPEN c_get_header_info;
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;

Line 6192: FND_MSG_PUB.add;

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;
6196:

Line 6289: fnd_msg_pub.count_and_get(

6285: WHEN fnd_api.g_exc_error
6286: THEN
6287: ROLLBACK TO copy_ev_header_to_offer;
6288: x_return_status := fnd_api.g_ret_sts_error;
6289: fnd_msg_pub.count_and_get(
6290: p_encoded => fnd_api.g_false,
6291: p_count => x_msg_count,
6292: p_data => x_msg_data);
6293: WHEN fnd_api.g_exc_unexpected_error

Line 6301: fnd_msg_pub.count_and_get(

6297: IF (AMS_DEBUG_HIGH_ON) THEN
6298:
6299: ams_utility_pvt.debug_message(l_full_name || ': debug');
6300: END IF;
6301: fnd_msg_pub.count_and_get(
6302: p_encoded => fnd_api.g_false,
6303: p_count => x_msg_count,
6304: p_data => x_msg_data);
6305: WHEN OTHERS THEN

Line 6316: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

6312:
6313: ROLLBACK TO copy_ev_header_to_offer;
6314: x_return_status := fnd_api.g_ret_sts_unexp_error;
6315:
6316: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6317: THEN
6318: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6319: END IF;
6320:

Line 6318: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

6314: x_return_status := fnd_api.g_ret_sts_unexp_error;
6315:
6316: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6317: THEN
6318: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6319: END IF;
6320:
6321: fnd_msg_pub.count_and_get(
6322: p_encoded => fnd_api.g_false,

Line 6321: fnd_msg_pub.count_and_get(

6317: THEN
6318: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6319: END IF;
6320:
6321: fnd_msg_pub.count_and_get(
6322: p_encoded => fnd_api.g_false,
6323: p_count => x_msg_count,
6324: p_data => x_msg_data);
6325: END copy_ev_header_to_offer;

Line 6401: fnd_msg_pub.initialize;

6397: END IF;
6398:
6399: IF fnd_api.to_boolean(p_init_msg_list)
6400: THEN
6401: fnd_msg_pub.initialize;
6402: END IF;
6403:
6404: IF NOT fnd_api.compatible_api_call(
6405: l_api_version,

Line 6742: fnd_msg_pub.count_and_get(

6738: WHEN fnd_api.g_exc_error
6739: THEN
6740: ROLLBACK TO copy_ev_header_associations;
6741: x_return_status := fnd_api.g_ret_sts_error;
6742: fnd_msg_pub.count_and_get(
6743: p_encoded => fnd_api.g_false,
6744: p_count => x_msg_count,
6745: p_data => x_msg_data);
6746: WHEN fnd_api.g_exc_unexpected_error

Line 6754: fnd_msg_pub.count_and_get(

6750: IF (AMS_DEBUG_HIGH_ON) THEN
6751:
6752: ams_utility_pvt.debug_message(l_full_name || ': debug');
6753: END IF;
6754: fnd_msg_pub.count_and_get(
6755: p_encoded => fnd_api.g_false,
6756: p_count => x_msg_count,
6757: p_data => x_msg_data);
6758: WHEN OTHERS

Line 6767: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

6763:
6764: ROLLBACK TO copy_ev_header_associations;
6765: x_return_status := fnd_api.g_ret_sts_unexp_error;
6766:
6767: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6768: THEN
6769: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6770: END IF;
6771:

Line 6769: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

6765: x_return_status := fnd_api.g_ret_sts_unexp_error;
6766:
6767: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6768: THEN
6769: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6770: END IF;
6771:
6772: fnd_msg_pub.count_and_get(
6773: p_encoded => fnd_api.g_false,

Line 6772: fnd_msg_pub.count_and_get(

6768: THEN
6769: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
6770: END IF;
6771:
6772: fnd_msg_pub.count_and_get(
6773: p_encoded => fnd_api.g_false,
6774: p_count => x_msg_count,
6775: p_data => x_msg_data);
6776: END copy_ev_header_associations;

Line 7041: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

7037: IF (AMS_DEBUG_HIGH_ON) THEN
7038:
7039: Ams_Utility_Pvt.debug_message('The start date of Event can not be lesser than that of Program');
7040: END IF;
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');

Line 7053: Fnd_Msg_Pub.ADD;

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;
7055: RETURN;
7056: END IF;
7057: END IF;

Line 7067: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

7063: IF (AMS_DEBUG_HIGH_ON) THEN
7064:
7065: Ams_Utility_Pvt.debug_message('The end date of Event can not be greater than that of Program');
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

Line 7075: Fnd_Msg_Pub.ADD;

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;
7077: RETURN;
7078: END IF;
7079: END IF;

Line 7086: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

7082: IF (AMS_DEBUG_HIGH_ON) THEN
7083:
7084: Ams_Utility_Pvt.debug_message('The end date of Event can not be greater than that of Program');
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

Line 7094: Fnd_Msg_Pub.ADD;

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;
7096: RETURN;
7097: END IF;
7098: END IF;

Line 7105: Fnd_Msg_Pub.ADD;

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;
7109: END IF;

Line 7170: Fnd_Msg_Pub.ADD;

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;
7172: RETURN;
7173:
7174: END IF;