APPS.AMS_VENUE_PVT dependencies on FND_MSG_PUB

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

41: --
42: -- Global CONSTANTS
43: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_Venue_PVT';
44:
45: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
46: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
47: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
48:
49: PROCEDURE Create_Venue_Base (

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

42: -- Global CONSTANTS
43: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_Venue_PVT';
44:
45: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
46: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
47: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
48:
49: PROCEDURE Create_Venue_Base (
50: p_api_version IN NUMBER,

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

43: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_Venue_PVT';
44:
45: AMS_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
46: AMS_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
47: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
48:
49: PROCEDURE Create_Venue_Base (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 183: FND_MSG_PUB.initialize;

179: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
180: END IF;
181:
182: IF FND_API.to_boolean (p_init_msg_list) THEN
183: FND_MSG_PUB.initialize;
184: END IF;
185:
186: IF NOT FND_API.compatible_api_call (
187: L_API_VERSION,

Line 458: FND_MSG_PUB.count_and_get(

454: EXCEPTION
455: WHEN FND_API.g_exc_error THEN
456: ROLLBACK TO Create_Venue;
457: x_return_status := FND_API.g_ret_sts_error;
458: FND_MSG_PUB.count_and_get(
459: p_encoded => FND_API.g_false,
460: p_count => x_msg_count,
461: p_data => x_msg_data
462: );

Line 466: FND_MSG_PUB.count_and_get (

462: );
463: WHEN FND_API.g_exc_unexpected_error THEN
464: ROLLBACK TO Create_Venue;
465: x_return_status := FND_API.g_ret_sts_unexp_error ;
466: FND_MSG_PUB.count_and_get (
467: p_encoded => FND_API.g_false,
468: p_count => x_msg_count,
469: p_data => x_msg_data
470: );

Line 475: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

471: WHEN OTHERS THEN
472: ROLLBACK TO Create_Venue;
473: x_return_status := FND_API.g_ret_sts_unexp_error ;
474:
475: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
476: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
477: END IF;
478:
479: FND_MSG_PUB.count_and_get (

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

472: ROLLBACK TO Create_Venue;
473: x_return_status := FND_API.g_ret_sts_unexp_error ;
474:
475: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
476: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
477: END IF;
478:
479: FND_MSG_PUB.count_and_get (
480: p_encoded => FND_API.g_false,

Line 479: FND_MSG_PUB.count_and_get (

475: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
476: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
477: END IF;
478:
479: FND_MSG_PUB.count_and_get (
480: p_encoded => FND_API.g_false,
481: p_count => x_msg_count,
482: p_data => x_msg_data
483: );

Line 529: FND_MSG_PUB.initialize;

525:
526: END IF;
527:
528: IF FND_API.to_boolean (p_init_msg_list) THEN
529: FND_MSG_PUB.initialize;
530: END IF;
531:
532: IF NOT FND_API.compatible_api_call (
533: L_API_VERSION,

Line 563: FND_MSG_PUB.count_and_get(

559: EXCEPTION
560: WHEN FND_API.g_exc_error THEN
561: ROLLBACK TO Create_Venue;
562: x_return_status := FND_API.g_ret_sts_error;
563: FND_MSG_PUB.count_and_get(
564: p_encoded => FND_API.g_false,
565: p_count => x_msg_count,
566: p_data => x_msg_data
567: );

Line 571: FND_MSG_PUB.count_and_get (

567: );
568: WHEN FND_API.g_exc_unexpected_error THEN
569: ROLLBACK TO Create_Venue;
570: x_return_status := FND_API.g_ret_sts_unexp_error ;
571: FND_MSG_PUB.count_and_get (
572: p_encoded => FND_API.g_false,
573: p_count => x_msg_count,
574: p_data => x_msg_data
575: );

Line 580: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

576: WHEN OTHERS THEN
577: ROLLBACK TO Create_Venue;
578: x_return_status := FND_API.g_ret_sts_unexp_error ;
579:
580: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
581: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
582: END IF;
583:
584: FND_MSG_PUB.count_and_get (

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

577: ROLLBACK TO Create_Venue;
578: x_return_status := FND_API.g_ret_sts_unexp_error ;
579:
580: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
581: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
582: END IF;
583:
584: FND_MSG_PUB.count_and_get (
585: p_encoded => FND_API.g_false,

Line 584: FND_MSG_PUB.count_and_get (

580: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
581: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
582: END IF;
583:
584: FND_MSG_PUB.count_and_get (
585: p_encoded => FND_API.g_false,
586: p_count => x_msg_count,
587: p_data => x_msg_data
588: );

Line 889: FND_MSG_PUB.count_and_get(

885: IF FND_API.To_Boolean ( p_commit ) THEN
886: COMMIT WORK;
887: END IF;
888:
889: FND_MSG_PUB.count_and_get(
890: p_encoded => FND_API.g_false,
891: p_count => x_msg_count,
892: p_data => x_msg_data
893: );

Line 901: FND_MSG_PUB.count_and_get(

897: EXCEPTION
898: WHEN FND_API.g_exc_error THEN
899: ROLLBACK TO Create_Venue;
900: x_return_status := FND_API.g_ret_sts_error;
901: FND_MSG_PUB.count_and_get(
902: p_encoded => FND_API.g_false,
903: p_count => x_msg_count,
904: p_data => x_msg_data
905: );

Line 909: FND_MSG_PUB.count_and_get (

905: );
906: WHEN FND_API.g_exc_unexpected_error THEN
907: ROLLBACK TO Create_Venue;
908: x_return_status := FND_API.g_ret_sts_unexp_error ;
909: FND_MSG_PUB.count_and_get (
910: p_encoded => FND_API.g_false,
911: p_count => x_msg_count,
912: p_data => x_msg_data
913: );

Line 918: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

914: WHEN OTHERS THEN
915: ROLLBACK TO Create_Venue;
916: x_return_status := FND_API.g_ret_sts_unexp_error ;
917:
918: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
919: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
920: END IF;
921:
922: FND_MSG_PUB.count_and_get (

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

915: ROLLBACK TO Create_Venue;
916: x_return_status := FND_API.g_ret_sts_unexp_error ;
917:
918: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
919: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
920: END IF;
921:
922: FND_MSG_PUB.count_and_get (
923: p_encoded => FND_API.g_false,

Line 922: FND_MSG_PUB.count_and_get (

918: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
919: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
920: END IF;
921:
922: FND_MSG_PUB.count_and_get (
923: p_encoded => FND_API.g_false,
924: p_count => x_msg_count,
925: p_data => x_msg_data
926: );

Line 990: FND_MSG_PUB.initialize;

986:
987: END IF;
988:
989: IF FND_API.to_boolean (p_init_msg_list) THEN
990: FND_MSG_PUB.initialize;
991: END IF;
992:
993: IF NOT FND_API.compatible_api_call(
994: l_api_version,

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

1022: OPEN c_location(l_venue_rec.venue_id);
1023: FETCH c_location INTO l_address1, l_address2, l_city, l_state, l_country;
1024: IF c_location%NOTFOUND THEN
1025: CLOSE c_location;
1026: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1027: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1028: FND_MSG_PUB.add;
1029: END IF;
1030: RAISE FND_API.g_exc_error;

Line 1028: FND_MSG_PUB.add;

1024: IF c_location%NOTFOUND THEN
1025: CLOSE c_location;
1026: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1027: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1028: FND_MSG_PUB.add;
1029: END IF;
1030: RAISE FND_API.g_exc_error;
1031: END IF;
1032: CLOSE c_location;

Line 1142: FND_MSG_PUB.count_and_get (

1138: EXCEPTION
1139: WHEN FND_API.g_exc_error THEN
1140: ROLLBACK TO Update_Venue;
1141: x_return_status := FND_API.g_ret_sts_error;
1142: FND_MSG_PUB.count_and_get (
1143: p_encoded => FND_API.g_false,
1144: p_count => x_msg_count,
1145: p_data => x_msg_data
1146: );

Line 1150: FND_MSG_PUB.count_and_get (

1146: );
1147: WHEN FND_API.g_exc_unexpected_error THEN
1148: ROLLBACK TO Update_Venue;
1149: x_return_status := FND_API.g_ret_sts_unexp_error ;
1150: FND_MSG_PUB.count_and_get (
1151: p_encoded => FND_API.g_false,
1152: p_count => x_msg_count,
1153: p_data => x_msg_data
1154: );

Line 1159: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1155: WHEN OTHERS THEN
1156: ROLLBACK TO Update_Venue;
1157: x_return_status := FND_API.g_ret_sts_unexp_error ;
1158:
1159: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1160: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1161: END IF;
1162:
1163: FND_MSG_PUB.count_and_get (

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

1156: ROLLBACK TO Update_Venue;
1157: x_return_status := FND_API.g_ret_sts_unexp_error ;
1158:
1159: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1160: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1161: END IF;
1162:
1163: FND_MSG_PUB.count_and_get (
1164: p_encoded => FND_API.g_false,

Line 1163: FND_MSG_PUB.count_and_get (

1159: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1160: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1161: END IF;
1162:
1163: FND_MSG_PUB.count_and_get (
1164: p_encoded => FND_API.g_false,
1165: p_count => x_msg_count,
1166: p_data => x_msg_data
1167: );

Line 1209: FND_MSG_PUB.initialize;

1205:
1206: END IF;
1207:
1208: IF FND_API.to_boolean (p_init_msg_list) THEN
1209: FND_MSG_PUB.initialize;
1210: END IF;
1211:
1212: IF NOT FND_API.compatible_api_call(
1213: l_api_version,

Line 1256: FND_MSG_PUB.count_and_get (

1252: EXCEPTION
1253: WHEN FND_API.g_exc_error THEN
1254: ROLLBACK TO Update_Venue;
1255: x_return_status := FND_API.g_ret_sts_error;
1256: FND_MSG_PUB.count_and_get (
1257: p_encoded => FND_API.g_false,
1258: p_count => x_msg_count,
1259: p_data => x_msg_data
1260: );

Line 1264: FND_MSG_PUB.count_and_get (

1260: );
1261: WHEN FND_API.g_exc_unexpected_error THEN
1262: ROLLBACK TO Update_Venue;
1263: x_return_status := FND_API.g_ret_sts_unexp_error ;
1264: FND_MSG_PUB.count_and_get (
1265: p_encoded => FND_API.g_false,
1266: p_count => x_msg_count,
1267: p_data => x_msg_data
1268: );

Line 1273: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1269: WHEN OTHERS THEN
1270: ROLLBACK TO Update_Venue;
1271: x_return_status := FND_API.g_ret_sts_unexp_error ;
1272:
1273: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1274: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1275: END IF;
1276:
1277: FND_MSG_PUB.count_and_get (

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

1270: ROLLBACK TO Update_Venue;
1271: x_return_status := FND_API.g_ret_sts_unexp_error ;
1272:
1273: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1274: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1275: END IF;
1276:
1277: FND_MSG_PUB.count_and_get (
1278: p_encoded => FND_API.g_false,

Line 1277: FND_MSG_PUB.count_and_get (

1273: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1274: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1275: END IF;
1276:
1277: FND_MSG_PUB.count_and_get (
1278: p_encoded => FND_API.g_false,
1279: p_count => x_msg_count,
1280: p_data => x_msg_data
1281: );

Line 1383: FND_MSG_PUB.add;

1379: and SOURCE_LANG = USERENV('LANG');
1380:
1381: IF (l_rec_cnt > 0) THEN
1382: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_DUP_NAME');
1383: FND_MSG_PUB.add;
1384: RAISE FND_API.g_exc_error;
1385: END IF;
1386:
1387:

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

1439: AND object_version_number = l_venue_rec.object_version_number;
1440: -- GDEODHAR : Sept 29, 2000 : Added the AND condition.
1441:
1442: IF (SQL%NOTFOUND) THEN
1443: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1444: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
1445: FND_MSG_PUB.add;
1446: END IF;
1447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1445: FND_MSG_PUB.add;

1441:
1442: IF (SQL%NOTFOUND) THEN
1443: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1444: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
1445: FND_MSG_PUB.add;
1446: END IF;
1447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1448: END IF;
1449:

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

1458: WHERE venue_id = l_venue_rec.venue_id
1459: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
1460:
1461: IF (SQL%NOTFOUND) THEN
1462: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1463: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
1464: FND_MSG_PUB.add;
1465: END IF;
1466: RAISE FND_API.g_exc_error;

Line 1464: FND_MSG_PUB.add;

1460:
1461: IF (SQL%NOTFOUND) THEN
1462: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1463: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
1464: FND_MSG_PUB.add;
1465: END IF;
1466: RAISE FND_API.g_exc_error;
1467: END IF;
1468:

Line 1474: FND_MSG_PUB.count_and_get (

1470: IF FND_API.to_boolean (p_commit) THEN
1471: COMMIT;
1472: END IF;
1473:
1474: FND_MSG_PUB.count_and_get (
1475: p_encoded => FND_API.g_false,
1476: p_count => x_msg_count,
1477: p_data => x_msg_data
1478: );

Line 1492: FND_MSG_PUB.count_and_get (

1488: EXCEPTION
1489: WHEN FND_API.g_exc_error THEN
1490: ROLLBACK TO Update_Venue;
1491: x_return_status := FND_API.g_ret_sts_error;
1492: FND_MSG_PUB.count_and_get (
1493: p_encoded => FND_API.g_false,
1494: p_count => x_msg_count,
1495: p_data => x_msg_data
1496: );

Line 1500: FND_MSG_PUB.count_and_get (

1496: );
1497: WHEN FND_API.g_exc_unexpected_error THEN
1498: ROLLBACK TO Update_Venue;
1499: x_return_status := FND_API.g_ret_sts_unexp_error ;
1500: FND_MSG_PUB.count_and_get (
1501: p_encoded => FND_API.g_false,
1502: p_count => x_msg_count,
1503: p_data => x_msg_data
1504: );

Line 1509: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1505: WHEN OTHERS THEN
1506: ROLLBACK TO Update_Venue;
1507: x_return_status := FND_API.g_ret_sts_unexp_error ;
1508:
1509: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1510: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1511: END IF;
1512:
1513: FND_MSG_PUB.count_and_get (

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

1506: ROLLBACK TO Update_Venue;
1507: x_return_status := FND_API.g_ret_sts_unexp_error ;
1508:
1509: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1510: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1511: END IF;
1512:
1513: FND_MSG_PUB.count_and_get (
1514: p_encoded => FND_API.g_false,

Line 1513: FND_MSG_PUB.count_and_get (

1509: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1510: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1511: END IF;
1512:
1513: FND_MSG_PUB.count_and_get (
1514: p_encoded => FND_API.g_false,
1515: p_count => x_msg_count,
1516: p_data => x_msg_data
1517: );

Line 1556: FND_MSG_PUB.initialize;

1552:
1553: END IF;
1554:
1555: IF FND_API.to_boolean (p_init_msg_list) THEN
1556: FND_MSG_PUB.initialize;
1557: END IF;
1558:
1559: IF NOT FND_API.compatible_api_call (
1560: l_api_version,

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

1577: DELETE FROM ams_venues_tl
1578: WHERE venue_id = p_venue_id;
1579:
1580: IF (SQL%NOTFOUND) THEN
1581: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1582: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
1583: FND_MSG_PUB.add;
1584: END IF;
1585: RAISE FND_API.g_exc_error;

Line 1583: FND_MSG_PUB.add;

1579:
1580: IF (SQL%NOTFOUND) THEN
1581: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1582: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
1583: FND_MSG_PUB.add;
1584: END IF;
1585: RAISE FND_API.g_exc_error;
1586: END IF;
1587:

Line 1597: FND_MSG_PUB.count_and_get (

1593: IF FND_API.to_boolean (p_commit) THEN
1594: COMMIT;
1595: END IF;
1596:
1597: FND_MSG_PUB.count_and_get (
1598: p_encoded => FND_API.g_false,
1599: p_count => x_msg_count,
1600: p_data => x_msg_data
1601: );

Line 1615: FND_MSG_PUB.count_and_get (

1611: EXCEPTION
1612: WHEN FND_API.g_exc_error THEN
1613: ROLLBACK TO Delete_Venue;
1614: x_return_status := FND_API.g_ret_sts_error;
1615: FND_MSG_PUB.count_and_get (
1616: p_encoded => FND_API.g_false,
1617: p_count => x_msg_count,
1618: p_data => x_msg_data
1619: );

Line 1623: FND_MSG_PUB.count_and_get (

1619: );
1620: WHEN FND_API.g_exc_unexpected_error THEN
1621: ROLLBACK TO Delete_Venue;
1622: x_return_status := FND_API.g_ret_sts_unexp_error ;
1623: FND_MSG_PUB.count_and_get (
1624: p_encoded => FND_API.g_false,
1625: p_count => x_msg_count,
1626: p_data => x_msg_data
1627: );

Line 1632: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1628: WHEN OTHERS THEN
1629: ROLLBACK TO Delete_Venue;
1630: x_return_status := FND_API.g_ret_sts_unexp_error ;
1631:
1632: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1633: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1634: END IF;
1635:
1636: FND_MSG_PUB.count_and_get (

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

1629: ROLLBACK TO Delete_Venue;
1630: x_return_status := FND_API.g_ret_sts_unexp_error ;
1631:
1632: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1633: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1634: END IF;
1635:
1636: FND_MSG_PUB.count_and_get (
1637: p_encoded => FND_API.g_false,

Line 1636: FND_MSG_PUB.count_and_get (

1632: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1633: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1634: END IF;
1635:
1636: FND_MSG_PUB.count_and_get (
1637: p_encoded => FND_API.g_false,
1638: p_count => x_msg_count,
1639: p_data => x_msg_data
1640: );

Line 1690: FND_MSG_PUB.initialize;

1686: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1687: END IF;
1688:
1689: IF FND_API.to_boolean (p_init_msg_list) THEN
1690: FND_MSG_PUB.initialize;
1691: END IF;
1692:
1693: IF NOT FND_API.compatible_api_call (
1694: l_api_version,

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

1710: OPEN c_lock;
1711: FETCH c_lock INTO l_dummy;
1712: IF (c_lock%NOTFOUND) THEN
1713: CLOSE c_lock;
1714: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1715: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1716: FND_MSG_PUB.add;
1717: END IF;
1718: RAISE FND_API.g_exc_error;

Line 1716: FND_MSG_PUB.add;

1712: IF (c_lock%NOTFOUND) THEN
1713: CLOSE c_lock;
1714: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1715: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1716: FND_MSG_PUB.add;
1717: END IF;
1718: RAISE FND_API.g_exc_error;
1719: END IF;
1720: CLOSE c_lock;

Line 1723: FND_MSG_PUB.count_and_get (

1719: END IF;
1720: CLOSE c_lock;
1721:
1722: -------------------- finish --------------------------
1723: FND_MSG_PUB.count_and_get (
1724: p_encoded => FND_API.g_false,
1725: p_count => x_msg_count,
1726: p_data => x_msg_data
1727: );

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

1736:
1737: EXCEPTION
1738: WHEN AMS_Utility_PVT.resource_locked THEN
1739: x_return_status := FND_API.g_ret_sts_error;
1740: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1741: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
1742: FND_MSG_PUB.add;
1743: END IF;
1744:

Line 1742: FND_MSG_PUB.add;

1738: WHEN AMS_Utility_PVT.resource_locked THEN
1739: x_return_status := FND_API.g_ret_sts_error;
1740: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1741: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
1742: FND_MSG_PUB.add;
1743: END IF;
1744:
1745: FND_MSG_PUB.count_and_get (
1746: p_encoded => FND_API.g_false,

Line 1745: FND_MSG_PUB.count_and_get (

1741: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
1742: FND_MSG_PUB.add;
1743: END IF;
1744:
1745: FND_MSG_PUB.count_and_get (
1746: p_encoded => FND_API.g_false,
1747: p_count => x_msg_count,
1748: p_data => x_msg_data
1749: );

Line 1752: FND_MSG_PUB.count_and_get (

1748: p_data => x_msg_data
1749: );
1750: WHEN FND_API.g_exc_error THEN
1751: x_return_status := FND_API.g_ret_sts_error;
1752: FND_MSG_PUB.count_and_get (
1753: p_encoded => FND_API.g_false,
1754: p_count => x_msg_count,
1755: p_data => x_msg_data
1756: );

Line 1759: FND_MSG_PUB.count_and_get (

1755: p_data => x_msg_data
1756: );
1757: WHEN FND_API.g_exc_unexpected_error THEN
1758: x_return_status := FND_API.g_ret_sts_unexp_error ;
1759: FND_MSG_PUB.count_and_get (
1760: p_encoded => FND_API.g_false,
1761: p_count => x_msg_count,
1762: p_data => x_msg_data
1763: );

Line 1766: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1762: p_data => x_msg_data
1763: );
1764: WHEN OTHERS THEN
1765: x_return_status := FND_API.g_ret_sts_unexp_error ;
1766: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1767: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1768: END IF;
1769:
1770: FND_MSG_PUB.count_and_get (

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

1763: );
1764: WHEN OTHERS THEN
1765: x_return_status := FND_API.g_ret_sts_unexp_error ;
1766: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1767: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1768: END IF;
1769:
1770: FND_MSG_PUB.count_and_get (
1771: p_encoded => FND_API.g_false,

Line 1770: FND_MSG_PUB.count_and_get (

1766: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1767: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1768: END IF;
1769:
1770: FND_MSG_PUB.count_and_get (
1771: p_encoded => FND_API.g_false,
1772: p_count => x_msg_count,
1773: p_data => x_msg_data
1774: );

Line 1810: FND_MSG_PUB.initialize;

1806: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1807: END IF;
1808:
1809: IF FND_API.to_boolean (p_init_msg_list) THEN
1810: FND_MSG_PUB.initialize;
1811: END IF;
1812:
1813: IF NOT FND_API.compatible_api_call (
1814: l_api_version,

Line 1868: FND_MSG_PUB.count_and_get (

1864: END IF;
1865: END IF;
1866:
1867: -------------------- finish --------------------------
1868: FND_MSG_PUB.count_and_get (
1869: p_encoded => FND_API.g_false,
1870: p_count => x_msg_count,
1871: p_data => x_msg_data
1872: );

Line 1885: FND_MSG_PUB.count_and_get (

1881:
1882: EXCEPTION
1883: WHEN FND_API.g_exc_error THEN
1884: x_return_status := FND_API.g_ret_sts_error;
1885: FND_MSG_PUB.count_and_get (
1886: p_encoded => FND_API.g_false,
1887: p_count => x_msg_count,
1888: p_data => x_msg_data
1889: );

Line 1892: FND_MSG_PUB.count_and_get (

1888: p_data => x_msg_data
1889: );
1890: WHEN FND_API.g_exc_unexpected_error THEN
1891: x_return_status := FND_API.g_ret_sts_unexp_error ;
1892: FND_MSG_PUB.count_and_get (
1893: p_encoded => FND_API.g_false,
1894: p_count => x_msg_count,
1895: p_data => x_msg_data
1896: );

Line 1899: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1895: p_data => x_msg_data
1896: );
1897: WHEN OTHERS THEN
1898: x_return_status := FND_API.g_ret_sts_unexp_error;
1899: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1900: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1901: END IF;
1902:
1903: FND_MSG_PUB.count_and_get (

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

1896: );
1897: WHEN OTHERS THEN
1898: x_return_status := FND_API.g_ret_sts_unexp_error;
1899: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1900: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1901: END IF;
1902:
1903: FND_MSG_PUB.count_and_get (
1904: p_encoded => FND_API.g_false,

Line 1903: FND_MSG_PUB.count_and_get (

1899: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1900: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1901: END IF;
1902:
1903: FND_MSG_PUB.count_and_get (
1904: p_encoded => FND_API.g_false,
1905: p_count => x_msg_count,
1906: p_data => x_msg_data
1907: );

Line 1975: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

1971: );
1972:
1973: IF(p_venue_rec.usage_cost < 0)
1974: THEN
1975: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1976: THEN
1977: Fnd_Message.set_name('AMS', 'AMS_USAGE_COST_NEG');
1978: Fnd_Msg_Pub.ADD;
1979: END IF;

Line 1978: Fnd_Msg_Pub.ADD;

1974: THEN
1975: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1976: THEN
1977: Fnd_Message.set_name('AMS', 'AMS_USAGE_COST_NEG');
1978: Fnd_Msg_Pub.ADD;
1979: END IF;
1980: RAISE FND_API.g_exc_error;
1981: END IF;
1982:

Line 1985: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

1981: END IF;
1982:
1983: IF(p_venue_rec.capacity < 0)
1984: THEN
1985: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1986: THEN
1987: Fnd_Message.set_name('AMS', 'AMS_CAPACITY_NEG');
1988: Fnd_Msg_Pub.ADD;
1989: END IF;

Line 1988: Fnd_Msg_Pub.ADD;

1984: THEN
1985: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1986: THEN
1987: Fnd_Message.set_name('AMS', 'AMS_CAPACITY_NEG');
1988: Fnd_Msg_Pub.ADD;
1989: END IF;
1990: RAISE FND_API.g_exc_error;
1991: END IF;
1992:

Line 1995: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

1991: END IF;
1992:
1993: IF(p_venue_rec.ceiling_height < 0)
1994: THEN
1995: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1996: THEN
1997: Fnd_Message.set_name('AMS', 'AMS_CEILING_HEIGHT_NEG');
1998: Fnd_Msg_Pub.ADD;
1999: END IF;

Line 1998: Fnd_Msg_Pub.ADD;

1994: THEN
1995: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1996: THEN
1997: Fnd_Message.set_name('AMS', 'AMS_CEILING_HEIGHT_NEG');
1998: Fnd_Msg_Pub.ADD;
1999: END IF;
2000: RAISE FND_API.g_exc_error;
2001: END IF;
2002:

Line 2008: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

2004: ceiling height and capacity on May 9, 2003 for bug 2950429 */
2005:
2006: IF(length(p_venue_rec.ceiling_height) > 15)
2007: THEN
2008: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2009: THEN
2010: Fnd_Message.set_name('AMS', 'AMS_OVERSIZE_CEILING_HEIGHT');
2011: Fnd_Msg_Pub.ADD;
2012: END IF;

Line 2011: Fnd_Msg_Pub.ADD;

2007: THEN
2008: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2009: THEN
2010: Fnd_Message.set_name('AMS', 'AMS_OVERSIZE_CEILING_HEIGHT');
2011: Fnd_Msg_Pub.ADD;
2012: END IF;
2013: RAISE FND_API.g_exc_error;
2014: END IF;
2015:

Line 2018: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)

2014: END IF;
2015:
2016: IF(length(p_venue_rec.capacity) > 15)
2017: THEN
2018: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2019: THEN
2020: Fnd_Message.set_name('AMS', 'AMS_OVERSIZE_CAPACITY');
2021: Fnd_Msg_Pub.ADD;
2022: END IF;

Line 2021: Fnd_Msg_Pub.ADD;

2017: THEN
2018: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
2019: THEN
2020: Fnd_Message.set_name('AMS', 'AMS_OVERSIZE_CAPACITY');
2021: Fnd_Msg_Pub.ADD;
2022: END IF;
2023: RAISE FND_API.g_exc_error;
2024: END IF;
2025:

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

2152: OPEN c_venue(p_venue_rec.venue_id);
2153: FETCH c_venue INTO l_venue_rec;
2154: IF c_venue%NOTFOUND THEN
2155: CLOSE c_venue;
2156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2157: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2158: FND_MSG_PUB.add;
2159: END IF;
2160: RAISE FND_API.g_exc_error;

Line 2158: FND_MSG_PUB.add;

2154: IF c_venue%NOTFOUND THEN
2155: CLOSE c_venue;
2156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2157: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2158: FND_MSG_PUB.add;
2159: END IF;
2160: RAISE FND_API.g_exc_error;
2161: END IF;
2162: CLOSE c_venue;

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

2165: OPEN c_location(l_venue_rec.party_id);
2166: FETCH c_location INTO l_address1, l_address2, l_city, l_state, l_country;
2167: IF c_location%NOTFOUND THEN
2168: CLOSE c_location;
2169: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2170: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2171: FND_MSG_PUB.add;
2172: END IF;
2173: RAISE FND_API.g_exc_error;

Line 2171: FND_MSG_PUB.add;

2167: IF c_location%NOTFOUND THEN
2168: CLOSE c_location;
2169: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2170: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2171: FND_MSG_PUB.add;
2172: END IF;
2173: RAISE FND_API.g_exc_error;
2174: END IF;
2175: CLOSE c_location;

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

2445: IF ( (p_object_type <> 'ROOM')
2446: AND (p_venue_rec.venue_type_code IS NULL)
2447: )
2448: THEN
2449: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2450: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_NO_VENUE_TYPE');
2451: FND_MSG_PUB.add;
2452: END IF;
2453: x_return_status := FND_API.g_ret_sts_error;

Line 2451: FND_MSG_PUB.add;

2447: )
2448: THEN
2449: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2450: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_NO_VENUE_TYPE');
2451: FND_MSG_PUB.add;
2452: END IF;
2453: x_return_status := FND_API.g_ret_sts_error;
2454: RETURN;
2455: END IF;

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

2458: IF ( (p_object_type = 'ROOM')
2459: AND (p_venue_rec.venue_name IS NULL)
2460: )
2461: THEN
2462: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2463: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_NO_VENUE_NAME');
2464: FND_MSG_PUB.add;
2465: END IF;
2466:

Line 2464: FND_MSG_PUB.add;

2460: )
2461: THEN
2462: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2463: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_NO_VENUE_NAME');
2464: FND_MSG_PUB.add;
2465: END IF;
2466:
2467: x_return_status := FND_API.g_ret_sts_error;
2468: RETURN;

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

2472: IF ( (p_object_type = 'ROOM')
2473: AND (p_venue_rec.parent_venue_id IS NULL)
2474: )
2475: THEN
2476: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2477: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_NO_PARENT_ID');
2478: FND_MSG_PUB.add;
2479: END IF;
2480:

Line 2478: FND_MSG_PUB.add;

2474: )
2475: THEN
2476: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2477: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_NO_PARENT_ID');
2478: FND_MSG_PUB.add;
2479: END IF;
2480:
2481: x_return_status := FND_API.g_ret_sts_error;
2482: RETURN;

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

2522: 'ams_venues_vl',
2523: 'venue_id = ' || p_venue_rec.venue_id
2524: ) = FND_API.g_false
2525: THEN
2526: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2527: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_DUP_VENUE_ID');
2528: FND_MSG_PUB.add;
2529:
2530: END IF;

Line 2528: FND_MSG_PUB.add;

2524: ) = FND_API.g_false
2525: THEN
2526: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2527: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_DUP_VENUE_ID');
2528: FND_MSG_PUB.add;
2529:
2530: END IF;
2531: x_return_status := FND_API.g_ret_sts_error;
2532:

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

2576: */
2577: IF l_dummy = 1 THEN
2578: --IF l_valid_flag = FND_API.g_false THEN bug # 1490374
2579:
2580: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2581: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_DUP_NAME');
2582: FND_MSG_PUB.add;
2583:
2584:

Line 2582: FND_MSG_PUB.add;

2578: --IF l_valid_flag = FND_API.g_false THEN bug # 1490374
2579:
2580: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2581: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_DUP_NAME');
2582: FND_MSG_PUB.add;
2583:
2584:
2585: END IF;
2586: x_return_status := FND_API.g_ret_sts_error;

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

2611: 'party_id',
2612: p_venue_rec.party_id
2613: ) = FND_API.g_false
2614: THEN
2615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2616: THEN
2617: FND_MESSAGE.set_name('AMS', 'AMS_VENUE_BAD_LOCATION_ID');
2618: FND_MSG_PUB.add;
2619: END IF;

Line 2618: FND_MSG_PUB.add;

2614: THEN
2615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2616: THEN
2617: FND_MESSAGE.set_name('AMS', 'AMS_VENUE_BAD_LOCATION_ID');
2618: FND_MSG_PUB.add;
2619: END IF;
2620:
2621: x_return_status := FND_API.g_ret_sts_error;
2622: RETURN;

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

2629: 'venue_id',
2630: p_venue_rec.parent_venue_id
2631: ) = FND_API.g_false
2632: THEN
2633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2634: THEN
2635: FND_MESSAGE.set_name('AMS', 'AMS_ROOM_BAD_PARENT_VENUE');
2636: FND_MSG_PUB.add;
2637: END IF;

Line 2636: FND_MSG_PUB.add;

2632: THEN
2633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2634: THEN
2635: FND_MESSAGE.set_name('AMS', 'AMS_ROOM_BAD_PARENT_VENUE');
2636: FND_MSG_PUB.add;
2637: END IF;
2638:
2639: x_return_status := FND_API.g_ret_sts_error;
2640: RETURN;

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

2654: p_evh_rec.currency_code_fc,
2655: AMS_Utility_PVT.g_varchar2
2656: ) = FND_API.g_false
2657: THEN
2658: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2659: THEN
2660: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_CURRENCY_CODE_FC');
2661: FND_MSG_PUB.add;
2662: END IF;

Line 2661: FND_MSG_PUB.add;

2657: THEN
2658: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2659: THEN
2660: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_CURRENCY_CODE_FC');
2661: FND_MSG_PUB.add;
2662: END IF;
2663: x_return_status := FND_API.g_ret_sts_error;
2664: RETURN;
2665: END IF;

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

2688: p_lookup_type => L_VENUE_TYPE,
2689: p_lookup_code => p_venue_rec.venue_type_code
2690: ) = FND_API.g_false
2691: THEN
2692: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2693: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_VENUE_TYPE');
2694: FND_MSG_PUB.add;
2695: END IF;
2696:

Line 2694: FND_MSG_PUB.add;

2690: ) = FND_API.g_false
2691: THEN
2692: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2693: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_VENUE_TYPE');
2694: FND_MSG_PUB.add;
2695: END IF;
2696:
2697: x_return_status := FND_API.g_ret_sts_error;
2698: RETURN;

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

2708: p_lookup_type => L_AREA_SIZE_UOM_CODE,
2709: p_lookup_code => p_venue_rec.area_size_uom_code
2710: ) = FND_API.g_false
2711: THEN
2712: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2713: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_AREA_SIZE_UOM_CODE');
2714: FND_MSG_PUB.add;
2715: END IF;
2716:

Line 2714: FND_MSG_PUB.add;

2710: ) = FND_API.g_false
2711: THEN
2712: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2713: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_AREA_SIZE_UOM_CODE');
2714: FND_MSG_PUB.add;
2715: END IF;
2716:
2717: x_return_status := FND_API.g_ret_sts_error;
2718: RETURN;

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

2728: p_lookup_type => L_CEILING_HEIGHT_UOM_CODE,
2729: p_lookup_code => p_venue_rec.ceiling_height_uom_code
2730: ) = FND_API.g_false
2731: THEN
2732: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2733: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_CEILING_HEIGHT_UOM_CODE');
2734: FND_MSG_PUB.add;
2735: END IF;
2736:

Line 2734: FND_MSG_PUB.add;

2730: ) = FND_API.g_false
2731: THEN
2732: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2733: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_CEILING_HEIGHT_UOM_CODE');
2734: FND_MSG_PUB.add;
2735: END IF;
2736:
2737: x_return_status := FND_API.g_ret_sts_error;
2738: RETURN;

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

2746: p_lookup_type => L_USAGE_COST_CURRENCY_CODE,
2747: p_lookup_code => p_venue_rec.usage_cost_currency_code
2748: ) = FND_API.g_false
2749: THEN
2750: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2751: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_USAGE_COST_CURRENCY_CODE');
2752: FND_MSG_PUB.add;
2753: END IF;
2754:

Line 2752: FND_MSG_PUB.add;

2748: ) = FND_API.g_false
2749: THEN
2750: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2751: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_USAGE_COST_CURRENCY_CODE');
2752: FND_MSG_PUB.add;
2753: END IF;
2754:
2755: x_return_status := FND_API.g_ret_sts_error;
2756: RETURN;

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

2774:
2775: -- INTERNAL_FLAG
2776: IF p_venue_rec.internal_flag <> FND_API.g_miss_char AND p_venue_rec.internal_flag IS NOT NULL THEN
2777: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.internal_flag) = FND_API.g_false THEN
2778: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2779: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_INTERNAL_FLAG');
2780: FND_MSG_PUB.add;
2781: END IF;
2782:

Line 2780: FND_MSG_PUB.add;

2776: IF p_venue_rec.internal_flag <> FND_API.g_miss_char AND p_venue_rec.internal_flag IS NOT NULL THEN
2777: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.internal_flag) = FND_API.g_false THEN
2778: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2779: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_INTERNAL_FLAG');
2780: FND_MSG_PUB.add;
2781: END IF;
2782:
2783: x_return_status := FND_API.g_ret_sts_error;
2784: RETURN;

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

2787:
2788: -- ENABLED_FLAG
2789: IF p_venue_rec.enabled_flag <> FND_API.g_miss_char AND p_venue_rec.enabled_flag IS NOT NULL THEN
2790: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.enabled_flag) = FND_API.g_false THEN
2791: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2792: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_ENABLED_FLAG');
2793: FND_MSG_PUB.add;
2794: END IF;
2795:

Line 2793: FND_MSG_PUB.add;

2789: IF p_venue_rec.enabled_flag <> FND_API.g_miss_char AND p_venue_rec.enabled_flag IS NOT NULL THEN
2790: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.enabled_flag) = FND_API.g_false THEN
2791: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2792: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_ENABLED_FLAG');
2793: FND_MSG_PUB.add;
2794: END IF;
2795:
2796: x_return_status := FND_API.g_ret_sts_error;
2797: RETURN;

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

2800:
2801: -- DIRECT_PHONE_FLAG
2802: IF p_venue_rec.direct_phone_flag <> FND_API.g_miss_char AND p_venue_rec.direct_phone_flag IS NOT NULL THEN
2803: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.direct_phone_flag) = FND_API.g_false THEN
2804: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2805: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_DIRECT_PH');
2806: FND_MSG_PUB.add;
2807: END IF;
2808:

Line 2806: FND_MSG_PUB.add;

2802: IF p_venue_rec.direct_phone_flag <> FND_API.g_miss_char AND p_venue_rec.direct_phone_flag IS NOT NULL THEN
2803: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.direct_phone_flag) = FND_API.g_false THEN
2804: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2805: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_DIRECT_PH');
2806: FND_MSG_PUB.add;
2807: END IF;
2808:
2809: x_return_status := FND_API.g_ret_sts_error;
2810: RETURN;