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_EVENTHEADER_PVT dependencies on JTF_PLSQL_API

Line 1159: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1155: END IF;
1156:
1157: -- item level validation
1158:
1159: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1160: check_evh_items(
1161: p_evh_rec => p_evh_rec,
1162: p_validation_mode => JTF_PLSQL_API.g_update,
1163: x_return_status => l_return_status

Line 1162: p_validation_mode => JTF_PLSQL_API.g_update,

1158:
1159: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1160: check_evh_items(
1161: p_evh_rec => p_evh_rec,
1162: p_validation_mode => JTF_PLSQL_API.g_update,
1163: x_return_status => l_return_status
1164: );
1165: IF (AMS_DEBUG_HIGH_ON) THEN
1166:

Line 1178: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1174: END IF;
1175: END IF;
1176:
1177:
1178: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1179: check_evh_record(
1180: p_evh_rec => p_evh_rec,
1181: p_complete_rec => l_evh_rec,
1182: x_return_status => l_return_status

Line 1202: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN

1198: END IF;
1199:
1200:
1201: -- inter-entity level
1202: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN
1203: check_evh_inter_entity(
1204: p_evh_rec => p_evh_rec,
1205: p_complete_rec => l_evh_rec,
1206: p_validation_mode => JTF_PLSQL_API.g_update,

Line 1206: p_validation_mode => JTF_PLSQL_API.g_update,

1202: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN
1203: check_evh_inter_entity(
1204: p_evh_rec => p_evh_rec,
1205: p_complete_rec => l_evh_rec,
1206: p_validation_mode => JTF_PLSQL_API.g_update,
1207: x_return_status => l_return_status
1208: );
1209:
1210: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1902: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1898:
1899: AMS_Utility_PVT.debug_message(l_full_name||': check items');
1900: END IF;
1901:
1902: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1903: check_evh_items(
1904: p_evh_rec => p_evh_rec,
1905: p_validation_mode => JTF_PLSQL_API.g_create,
1906: x_return_status => l_return_status

Line 1905: p_validation_mode => JTF_PLSQL_API.g_create,

1901:
1902: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1903: check_evh_items(
1904: p_evh_rec => p_evh_rec,
1905: p_validation_mode => JTF_PLSQL_API.g_create,
1906: x_return_status => l_return_status
1907: );
1908:
1909: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1924: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1920: AMS_Utility_PVT.debug_message(l_full_name||': check record');
1921:
1922: END IF;
1923:
1924: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1925: check_evh_record(
1926: p_evh_rec => p_evh_rec,
1927: p_complete_rec => NULL,
1928: x_return_status => l_return_status

Line 1950: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN

1946:
1947:
1948: END IF;
1949:
1950: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_inter_entity THEN
1951: IF p_evh_rec.event_level = 'MAIN' THEN
1952: check_evh_inter_entity(
1953: p_evh_rec => p_evh_rec,
1954: p_complete_rec => p_evh_rec,

Line 1955: p_validation_mode => JTF_PLSQL_API.g_create,

1951: IF p_evh_rec.event_level = 'MAIN' THEN
1952: check_evh_inter_entity(
1953: p_evh_rec => p_evh_rec,
1954: p_complete_rec => p_evh_rec,
1955: p_validation_mode => JTF_PLSQL_API.g_create,
1956: x_return_status => l_return_status
1957: );
1958: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1959: RAISE FND_API.g_exc_unexpected_error;

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

2152: -- 11/19/1999 rvaka updated.
2153: ---------------------------------------------------------------------
2154: PROCEDURE check_evh_uk_items(
2155: p_evh_rec IN evh_rec_type,
2156: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2157: x_return_status OUT NOCOPY VARCHAR2
2158: )
2159: IS
2160:

Line 2182: IF p_validation_mode = JTF_PLSQL_API.g_create

2178:
2179: -- For create_event_header, when event_header_id is passed in, we need to
2180: -- check if this event_header_id is unique.
2181:
2182: IF p_validation_mode = JTF_PLSQL_API.g_create
2183: AND p_evh_rec.event_header_id IS NOT NULL
2184: THEN
2185: IF AMS_Utility_PVT.check_uniqueness(
2186: 'ams_event_headers_vl',

Line 2204: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

2200: -- For create_event_header, when source_code is passed in, we need to
2201: -- check if this source_code is unique.
2202: -- For creating, check if source_code is unique in ams_source_codes.
2203: -- Update of source_code is not allowed.
2204: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2205: IF p_evh_rec.source_code IS NOT NULL THEN
2206: /*
2207: IF AMS_Utility_PVT.check_uniqueness(
2208: 'ams_source_codes',

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

2860: -- 12/18/1999 rvaka updated.
2861: ---------------------------------------------------------------------
2862: PROCEDURE check_evh_items(
2863: p_evh_rec IN evh_rec_type,
2864: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2865: x_return_status OUT NOCOPY VARCHAR2
2866: )
2867: IS
2868: BEGIN

Line 2878: IF p_validation_mode = JTF_PLSQL_API.g_update THEN

2874: -- check if the p_evh_rec has any columns that should not be updated at this stage as per the business logic.
2875: -- Also when the event is in active stage (will add later)
2876: --changes to marketing message and budget related columns should not be allowed.
2877:
2878: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
2879: check_evh_update_ok_items(
2880: p_evh_rec => p_evh_rec,
2881: x_return_status => x_return_status
2882: );