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_VENUE_PVT dependencies on FND_MESSAGE

Line 1027: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

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

Line 1382: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_DUP_NAME');

1378: and venue_name = l_venue_rec.venue_name
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:

Line 1444: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');

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

Line 1463: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');

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

Line 1582: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');

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

Line 1715: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

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

Line 1741: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');

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:
1745: FND_MSG_PUB.count_and_get (

Line 1977: Fnd_Message.set_name('AMS', 'AMS_USAGE_COST_NEG');

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;
1980: RAISE FND_API.g_exc_error;
1981: END IF;

Line 1987: Fnd_Message.set_name('AMS', 'AMS_CAPACITY_NEG');

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;
1990: RAISE FND_API.g_exc_error;
1991: END IF;

Line 1997: Fnd_Message.set_name('AMS', 'AMS_CEILING_HEIGHT_NEG');

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;
2000: RAISE FND_API.g_exc_error;
2001: END IF;

Line 2010: Fnd_Message.set_name('AMS', 'AMS_OVERSIZE_CEILING_HEIGHT');

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;
2013: RAISE FND_API.g_exc_error;
2014: END IF;

Line 2020: Fnd_Message.set_name('AMS', 'AMS_OVERSIZE_CAPACITY');

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;
2023: RAISE FND_API.g_exc_error;
2024: END IF;

Line 2157: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

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

Line 2170: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

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

Line 2450: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_NO_VENUE_TYPE');

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

Line 2463: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_NO_VENUE_NAME');

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

Line 2477: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_NO_PARENT_ID');

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

Line 2527: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_DUP_VENUE_ID');

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

Line 2581: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_DUP_NAME');

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

Line 2617: FND_MESSAGE.set_name('AMS', 'AMS_VENUE_BAD_LOCATION_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;
2620:
2621: x_return_status := FND_API.g_ret_sts_error;

Line 2635: FND_MESSAGE.set_name('AMS', 'AMS_ROOM_BAD_PARENT_VENUE');

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

Line 2660: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_CURRENCY_CODE_FC');

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;
2663: x_return_status := FND_API.g_ret_sts_error;
2664: RETURN;

Line 2693: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_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:
2697: x_return_status := FND_API.g_ret_sts_error;

Line 2713: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_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:
2717: x_return_status := FND_API.g_ret_sts_error;

Line 2733: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_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:
2737: x_return_status := FND_API.g_ret_sts_error;

Line 2751: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_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:
2755: x_return_status := FND_API.g_ret_sts_error;

Line 2779: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_INTERNAL_FLAG');

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

Line 2792: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_ENABLED_FLAG');

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

Line 2805: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_DIRECT_PH');

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