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 JTF_PLSQL_API

Line 1724: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1720:
1721: AMS_Utility_PVT.debug_message(l_full_name ||': check items');
1722:
1723: END IF;
1724: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1725: check_evo_items(
1726: p_evo_rec => l_evo_rec,
1727: p_validation_mode => JTF_PLSQL_API.g_update,
1728: x_return_status => l_return_status

Line 1727: p_validation_mode => JTF_PLSQL_API.g_update,

1723: END IF;
1724: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1725: check_evo_items(
1726: p_evo_rec => l_evo_rec,
1727: p_validation_mode => JTF_PLSQL_API.g_update,
1728: x_return_status => l_return_status
1729: );
1730:
1731: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1746: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1742: AMS_Utility_PVT.debug_message(l_full_name ||': check records');
1743:
1744: END IF;
1745:
1746: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1747: check_evo_record(
1748: p_evo_rec => p_evo_rec,
1749: p_complete_rec => l_evo_rec,
1750: x_return_status => l_return_status

Line 1764: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN

1760: IF (AMS_DEBUG_HIGH_ON) THEN
1761:
1762: AMS_Utility_PVT.debug_message(l_full_name ||': check inter-entity');
1763: END IF;
1764: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN
1765: check_evo_inter_entity(
1766: p_evo_rec => p_evo_rec,
1767: p_complete_rec => l_evo_rec,
1768: p_validation_mode => JTF_PLSQL_API.g_update,

Line 1768: p_validation_mode => JTF_PLSQL_API.g_update,

1764: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN
1765: check_evo_inter_entity(
1766: p_evo_rec => p_evo_rec,
1767: p_complete_rec => l_evo_rec,
1768: p_validation_mode => JTF_PLSQL_API.g_update,
1769: x_return_status => l_return_status
1770: );
1771: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1772: RAISE FND_API.g_exc_unexpected_error;

Line 3006: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

3002:
3003: AMS_Utility_PVT.debug_message(l_full_name||': check items');
3004: END IF;
3005:
3006: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3007: check_evo_items(
3008: p_evo_rec => p_evo_rec,
3009: p_validation_mode => JTF_PLSQL_API.g_create,
3010: x_return_status => l_return_status

Line 3009: p_validation_mode => JTF_PLSQL_API.g_create,

3005:
3006: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3007: check_evo_items(
3008: p_evo_rec => p_evo_rec,
3009: p_validation_mode => JTF_PLSQL_API.g_create,
3010: x_return_status => l_return_status
3011: );
3012: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3013: RAISE FND_API.g_exc_unexpected_error;

Line 3027: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

3023: AMS_Utility_PVT.debug_message(l_full_name||': check record');
3024:
3025: END IF;
3026:
3027: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
3028: check_evo_record(
3029: p_evo_rec => p_evo_rec,
3030: p_complete_rec => NULL,
3031: x_return_status => l_return_status

Line 3048: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN

3044: AMS_Utility_PVT.debug_message(l_full_name||': check inter-entity');
3045:
3046: END IF;
3047:
3048: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN
3049: IF p_evo_rec.event_level = 'MAIN' THEN
3050: check_evo_inter_entity(
3051: p_evo_rec => p_evo_rec,
3052: p_complete_rec => p_evo_rec,

Line 3053: p_validation_mode => JTF_PLSQL_API.g_create,

3049: IF p_evo_rec.event_level = 'MAIN' THEN
3050: check_evo_inter_entity(
3051: p_evo_rec => p_evo_rec,
3052: p_complete_rec => p_evo_rec,
3053: p_validation_mode => JTF_PLSQL_API.g_create,
3054: x_return_status => l_return_status
3055: );
3056: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3057: RAISE FND_API.g_exc_unexpected_error;

Line 3216: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

3212: -- 11/23/1999 sugupta Created.
3213: ---------------------------------------------------------------------
3214: PROCEDURE check_evo_uk_items(
3215: p_evo_rec IN evo_rec_type,
3216: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
3217: x_return_status OUT NOCOPY VARCHAR2
3218: )
3219: IS
3220: l_valid_flag VARCHAR2(1);

Line 3230: IF p_validation_mode = JTF_PLSQL_API.g_create

3226: x_return_status := FND_API.g_ret_sts_success;
3227:
3228: -- For create_event_offer, when event_offer_id is passed in, we need to
3229: -- check if this event_offer_id is unique.
3230: IF p_validation_mode = JTF_PLSQL_API.g_create
3231: AND p_evo_rec.event_offer_id IS NOT NULL
3232: THEN
3233: IF AMS_Utility_PVT.check_uniqueness(
3234: 'ams_event_offers_all_b',

Line 3251: IF p_validation_mode = JTF_PLSQL_API.g_create

3247: -- of name, venue and dates/time different.. it should be fine
3248:
3249: -- For create_event_offer, when source_code is passed in, we need to
3250: -- check if this source_code is unique.
3251: IF p_validation_mode = JTF_PLSQL_API.g_create
3252: AND p_evo_rec.source_code IS NOT NULL
3253: THEN
3254: /*
3255: IF AMS_Utility_PVT.check_uniqueness(

Line 4050: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,

4046: -- 11/23/1999 sugupta Created.
4047: ---------------------------------------------------------------------
4048: PROCEDURE check_evo_items(
4049: p_evo_rec IN evo_rec_type,
4050: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
4051: x_return_status OUT NOCOPY VARCHAR2
4052: )
4053: IS
4054: BEGIN

Line 4064: IF p_validation_mode = JTF_PLSQL_API.g_update THEN

4060: IF (AMS_DEBUG_HIGH_ON) THEN
4061:
4062: AMS_UTILITY_PVT.debug_message('before ok_items');
4063: END IF;
4064: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
4065: check_evo_update_ok_items(
4066: p_evo_rec => p_evo_rec,
4067: x_return_status => x_return_status
4068: );

Line 4830: /* IF p_validation_mode = JTF_PLSQL_API.g_update

4826: x_return_status := l_return_status;
4827: END IF;
4828: END IF;
4829:
4830: /* IF p_validation_mode = JTF_PLSQL_API.g_update
4831: THEN
4832: IF p_evo_rec.event_venue_id <> p_complete_rec.event_venue_id
4833: IF p_complete_rec.event_venue_id is NULL
4834: THEN