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 AMS_UTILITY_PVT

Line 179: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

175: --------------------- initialize -----------------------
176: SAVEPOINT Create_Venue;
177:
178: IF (AMS_DEBUG_HIGH_ON) THEN
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;

Line 200: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');

196:
197: ----------------------- validate -----------------------
198: IF (AMS_DEBUG_HIGH_ON) THEN
199:
200: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');
201: END IF;
202:
203: -- Only Validate name here for parties - everything else will be done in the base
204: IF (l_venue_rec.venue_name is null)

Line 206: AMS_Utility_PVT.error_message('AMS_VENUE_NO_VENUE_NAME');

202:
203: -- Only Validate name here for parties - everything else will be done in the base
204: IF (l_venue_rec.venue_name is null)
205: THEN
206: AMS_Utility_PVT.error_message('AMS_VENUE_NO_VENUE_NAME');
207: RAISE FND_API.g_exc_error;
208: END IF;
209:
210: l_location_rec.address1 := l_venue_rec.address1;

Line 240: AMS_Utility_PVT.Debug_Message('Location ID: ' || to_char(l_location_id));

236: IF (AMS_DEBUG_HIGH_ON) THEN
237:
238:
239:
240: AMS_Utility_PVT.Debug_Message('Location ID: ' || to_char(l_location_id));
241:
242: END IF;
243:
244: IF l_return_status = FND_API.g_ret_sts_error THEN

Line 269: AMS_Utility_PVT.Debug_Message('Party ID: ' || to_char(l_party_id));

265: IF (AMS_DEBUG_HIGH_ON) THEN
266:
267:
268:
269: AMS_Utility_PVT.Debug_Message('Party ID: ' || to_char(l_party_id));
270:
271: END IF;
272:
273: IF l_return_status = FND_API.g_ret_sts_error THEN

Line 339: AMS_Utility_PVT.Debug_Message('Party Site ID: ' || to_char(l_party_site_id));

335: IF (AMS_DEBUG_HIGH_ON) THEN
336:
337:
338:
339: AMS_Utility_PVT.Debug_Message('Party Site ID: ' || to_char(l_party_site_id));
340:
341: END IF;
342:
343: IF l_return_status = FND_API.g_ret_sts_error THEN

Line 374: AMS_Utility_PVT.Debug_Message('Party Site ID: ' || to_char(l_party_site_use_id));

370: , x_msg_count => x_msg_count
371: , x_msg_data => x_msg_data
372: , x_party_site_use_id => l_party_site_use_id
373: );
374: AMS_Utility_PVT.Debug_Message('Party Site ID: ' || to_char(l_party_site_use_id));
375:
376: IF l_return_status = FND_API.g_ret_sts_error THEN
377: RAISE FND_API.g_exc_error;
378: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 392: AMS_Utility_PVT.Debug_Message('Creating row in AS_ACCESSES_ALL');

388: )
389: THEN
390: IF (AMS_DEBUG_HIGH_ON) THEN
391:
392: AMS_Utility_PVT.Debug_Message('Creating row in AS_ACCESSES_ALL');
393: END IF;
394:
395: l_sales_team_rec.salesforce_id := l_venue_rec.salesforce_id;
396: l_sales_team_rec.customer_id := l_party_id;

Line 422: AMS_Utility_PVT.Debug_Message('Access ID: ' || to_char(l_access_id));

418: IF (AMS_DEBUG_HIGH_ON) THEN
419:
420:
421:
422: AMS_Utility_PVT.Debug_Message('Access ID: ' || to_char(l_access_id));
423:
424: END IF;
425:
426: IF l_return_status = FND_API.g_ret_sts_error THEN

Line 524: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

520: IF (AMS_DEBUG_HIGH_ON) THEN
521:
522:
523:
524: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
525:
526: END IF;
527:
528: IF FND_API.to_boolean (p_init_msg_list) THEN

Line 670: AMS_Utility_PVT.debug_message (l_full_name || ': Check IDs');

666: IF (AMS_DEBUG_HIGH_ON) THEN
667:
668:
669:
670: AMS_Utility_PVT.debug_message (l_full_name || ': Check IDs');
671:
672: END IF;
673: --
674: -- Check for the ID.

Line 702: AMS_Utility_PVT.debug_message (l_full_name || ': Insert ' || p_object_type || ', ' || l_venue_rec.venue_id);

698:
699: -------------------------- insert --------------------------
700: IF (AMS_DEBUG_HIGH_ON) THEN
701:
702: AMS_Utility_PVT.debug_message (l_full_name || ': Insert ' || p_object_type || ', ' || l_venue_rec.venue_id);
703: END IF;
704:
705: --
706: -- Insert into mutli-language supported table.

Line 895: --IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message (l_full_name || ': End');END IF;

891: p_count => x_msg_count,
892: p_data => x_msg_data
893: );
894:
895: --IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message (l_full_name || ': End');END IF;
896:
897: EXCEPTION
898: WHEN FND_API.g_exc_error THEN
899: ROLLBACK TO Create_Venue;

Line 985: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

981: IF (AMS_DEBUG_HIGH_ON) THEN
982:
983:
984:
985: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
986:
987: END IF;
988:
989: IF FND_API.to_boolean (p_init_msg_list) THEN

Line 1007: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');

1003:
1004: ----------------------- validate ----------------------
1005: IF (AMS_DEBUG_HIGH_ON) THEN
1006:
1007: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');
1008: END IF;
1009:
1010: -- replace g_miss_char/num/date with current column values
1011: -- 07/10/2000 IMPORTANT THING TO NOTE ABOUT UPDATE VENUES

Line 1107: AMS_Utility_PVT.Debug_Message('Party Site ID: ' || to_char(l_party_site_id));

1103: IF (AMS_DEBUG_HIGH_ON) THEN
1104:
1105:
1106:
1107: AMS_Utility_PVT.Debug_Message('Party Site ID: ' || to_char(l_party_site_id));
1108:
1109: END IF;
1110:
1111: IF l_return_status = FND_API.g_ret_sts_error THEN

Line 1204: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

1200: IF (AMS_DEBUG_HIGH_ON) THEN
1201:
1202:
1203:
1204: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1205:
1206: END IF;
1207:
1208: IF FND_API.to_boolean (p_init_msg_list) THEN

Line 1226: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');

1222:
1223: ----------------------- validate ----------------------
1224: IF (AMS_DEBUG_HIGH_ON) THEN
1225:
1226: AMS_Utility_PVT.debug_message (l_full_name || ': Validate');
1227: END IF;
1228:
1229: -- replace g_miss_char/num/date with current column values
1230: -- 07/10/2000 IMPORTANT THING TO NOTE ABOUT UPDATE VENUES

Line 1393: AMS_Utility_PVT.debug_message (l_full_name || ': Update');

1389: --batoleti
1390: -------------------------- update --------------------
1391: IF (AMS_DEBUG_HIGH_ON) THEN
1392:
1393: AMS_Utility_PVT.debug_message (l_full_name || ': Update');
1394: END IF;
1395:
1396: UPDATE ams_venues_b
1397: SET

Line 1484: AMS_Utility_PVT.debug_message (l_full_name || ': End');

1480: IF (AMS_DEBUG_HIGH_ON) THEN
1481:
1482:
1483:
1484: AMS_Utility_PVT.debug_message (l_full_name || ': End');
1485:
1486: END IF;
1487:
1488: EXCEPTION

Line 1551: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

1547: IF (AMS_DEBUG_HIGH_ON) THEN
1548:
1549:
1550:
1551: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1552:
1553: END IF;
1554:
1555: IF FND_API.to_boolean (p_init_msg_list) THEN

Line 1573: AMS_Utility_PVT.debug_message (l_full_name || ': Delete');

1569:
1570: ------------------------ delete ------------------------
1571: IF (AMS_DEBUG_HIGH_ON) THEN
1572:
1573: AMS_Utility_PVT.debug_message (l_full_name || ': Delete');
1574: END IF;
1575:
1576: -- Delete TL data
1577: DELETE FROM ams_venues_tl

Line 1607: AMS_Utility_PVT.debug_message (l_full_name || ': End');

1603: IF (AMS_DEBUG_HIGH_ON) THEN
1604:
1605:
1606:
1607: AMS_Utility_PVT.debug_message (l_full_name || ': End');
1608:
1609: END IF;
1610:
1611: EXCEPTION

Line 1686: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

1682: BEGIN
1683: --------------------- initialize -----------------------
1684: IF (AMS_DEBUG_HIGH_ON) THEN
1685:
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;

Line 1707: AMS_Utility_PVT.debug_message (l_full_name || ': Lock');

1703:
1704: ------------------------ lock -------------------------
1705: IF (AMS_DEBUG_HIGH_ON) THEN
1706:
1707: AMS_Utility_PVT.debug_message (l_full_name || ': Lock');
1708: END IF;
1709:
1710: OPEN c_lock;
1711: FETCH c_lock INTO l_dummy;

Line 1733: AMS_Utility_PVT.debug_message (l_full_name || ': End');

1729: IF (AMS_DEBUG_HIGH_ON) THEN
1730:
1731:
1732:
1733: AMS_Utility_PVT.debug_message (l_full_name || ': End');
1734:
1735: END IF;
1736:
1737: EXCEPTION

Line 1738: WHEN AMS_Utility_PVT.resource_locked THEN

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

Line 1806: AMS_Utility_PVT.debug_message (l_full_name || ': Start');

1802: BEGIN
1803: --------------------- initialize -----------------------
1804: IF (AMS_DEBUG_HIGH_ON) THEN
1805:
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;

Line 1827: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');

1823:
1824: ---------------------- validate ------------------------
1825: IF (AMS_DEBUG_HIGH_ON) THEN
1826:
1827: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');
1828: END IF;
1829:
1830: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1831: Check_Venue_Items (

Line 1849: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');

1845: IF (AMS_DEBUG_HIGH_ON) THEN
1846:
1847:
1848:
1849: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');
1850:
1851: END IF;
1852:
1853: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

Line 1878: AMS_Utility_PVT.debug_message (l_full_name || ': End');

1874: IF (AMS_DEBUG_HIGH_ON) THEN
1875:
1876:
1877:
1878: AMS_Utility_PVT.debug_message (l_full_name || ': End');
1879:
1880: END IF;
1881:
1882: EXCEPTION

Line 2521: IF AMS_Utility_PVT.check_uniqueness(

2517: -- check if this ID is unique.
2518: IF p_validation_mode = JTF_PLSQL_API.g_create
2519: AND p_venue_rec.venue_id IS NOT NULL
2520: THEN
2521: IF AMS_Utility_PVT.check_uniqueness(
2522: 'ams_venues_vl',
2523: 'venue_id = ' || p_venue_rec.venue_id
2524: ) = FND_API.g_false
2525: THEN

Line 2544: l_valid_flag := AMS_Utility_PVT.check_uniqueness (

2540: open c_vnu_name_crt(p_venue_rec.venue_name);
2541: fetch c_vnu_name_crt into l_dummy;
2542: close c_vnu_name_crt;
2543: bug # 1490374
2544: l_valid_flag := AMS_Utility_PVT.check_uniqueness (
2545: 'ams_venues_vl',
2546: 'venue_name = ''' || p_venue_rec.venue_name || ''''
2547: );
2548:

Line 2554: l_valid_flag := AMS_Utility_PVT.check_uniqueness (

2550: open c_vnu_name_up(p_venue_rec.venue_name,p_venue_rec.venue_id);
2551: fetch c_vnu_name_up into l_dummy;
2552: close c_vnu_name_up;
2553: bug # 1490374
2554: l_valid_flag := AMS_Utility_PVT.check_uniqueness (
2555: 'ams_venues_vl',
2556: 'venue_name = ''' || p_venue_rec.venue_name ||
2557: ''' AND venue_id <> ' || p_venue_rec.venue_id
2558: );

Line 2609: IF AMS_Utility_PVT.check_fk_exists(

2605:
2606: ----------------------- venue party_id ------------------------
2607: IF nvl(p_object_type, 'VENU') <> 'ROOM' THEN
2608: IF p_venue_rec.location_id <> FND_API.g_miss_num THEN
2609: IF AMS_Utility_PVT.check_fk_exists(
2610: 'hz_parties',
2611: 'party_id',
2612: p_venue_rec.party_id
2613: ) = FND_API.g_false

Line 2627: IF AMS_Utility_PVT.check_fk_exists(

2623: END IF;
2624: END IF;
2625: ELSE
2626: IF p_venue_rec.parent_venue_id <> FND_API.g_miss_num THEN
2627: IF AMS_Utility_PVT.check_fk_exists(
2628: 'ams_venues_b',
2629: 'venue_id',
2630: p_venue_rec.parent_venue_id
2631: ) = FND_API.g_false

Line 2651: IF AMS_Utility_PVT.check_fk_exists(

2647: --------------------- currency_code_fc ------------------------
2648: IF p_evh_rec.currency_code_fc <> FND_API.g_miss_char
2649: AND p_evh_rec.currency_code_fc IS NOT NULL
2650: THEN
2651: IF AMS_Utility_PVT.check_fk_exists(
2652: 'fnd_currencies_vl',
2653: 'currency_code',
2654: p_evh_rec.currency_code_fc,
2655: AMS_Utility_PVT.g_varchar2

Line 2655: AMS_Utility_PVT.g_varchar2

2651: IF AMS_Utility_PVT.check_fk_exists(
2652: 'fnd_currencies_vl',
2653: 'currency_code',
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

Line 2687: IF AMS_Utility_PVT.check_lookup_exists (

2683:
2684: /* --
2685: -- VENUE_TYPE_CODE
2686: IF p_venue_rec.venue_type_code <> FND_API.g_miss_char THEN
2687: IF AMS_Utility_PVT.check_lookup_exists (
2688: p_lookup_type => L_VENUE_TYPE,
2689: p_lookup_code => p_venue_rec.venue_type_code
2690: ) = FND_API.g_false
2691: THEN

Line 2707: IF AMS_Utility_PVT.check_lookup_exists (

2703: /*
2704: --
2705: -- AREA_SIZE_UOM_CODE
2706: IF p_venue_rec.area_size_uom_code <> FND_API.g_miss_char THEN
2707: IF AMS_Utility_PVT.check_lookup_exists (
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

Line 2727: IF AMS_Utility_PVT.check_lookup_exists (

2723:
2724: --
2725: -- CEILING_HEIGHT_UOM_CODE
2726: IF p_venue_rec.ceiling_height_uom_code <> FND_API.g_miss_char THEN
2727: IF AMS_Utility_PVT.check_lookup_exists (
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

Line 2745: IF AMS_Utility_PVT.check_lookup_exists (

2741:
2742: --
2743: -- USAGE_COST_CURRENCY_CODE
2744: IF p_venue_rec.usage_cost_currency_code <> FND_API.g_miss_char THEN
2745: IF AMS_Utility_PVT.check_lookup_exists (
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

Line 2777: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.internal_flag) = FND_API.g_false THEN

2773: x_return_status := FND_API.g_ret_sts_success;
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;

Line 2790: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.enabled_flag) = FND_API.g_false THEN

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

Line 2803: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.direct_phone_flag) = FND_API.g_false THEN

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