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

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

36: );
37: -- Check_User_Status_UK_Items
38: PROCEDURE Check_User_Status_UK_Items (
39: p_user_status_rec IN User_Status_Rec_Type,
40: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
41: x_return_status OUT NOCOPY VARCHAR2
42: );
43: -- Check_User_Status_FK_Items
44: PROCEDURE Check_User_Status_FK_Items (

Line 349: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

345: RAISE FND_API.g_exc_error;
346: END IF;
347: ELSE
348:
349: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
350: Check_User_Status_Items (
351: p_user_status_rec => p_user_status_rec,
352: p_validation_mode => JTF_PLSQL_API.g_update,
353: x_return_status => l_return_status

Line 352: p_validation_mode => JTF_PLSQL_API.g_update,

348:
349: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
350: Check_User_Status_Items (
351: p_user_status_rec => p_user_status_rec,
352: p_validation_mode => JTF_PLSQL_API.g_update,
353: x_return_status => l_return_status
354: );
355: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
356: RAISE FND_API.g_exc_unexpected_error;

Line 361: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

357: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
358: RAISE FND_API.g_exc_error;
359: END IF;
360: END IF;
361: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
362: Check_User_Status_Record (
363: p_user_status_rec => p_user_status_rec,
364: p_complete_rec => l_user_status_rec,
365: x_return_status => l_return_status

Line 790: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

786: IF (AMS_DEBUG_HIGH_ON) THEN
787:
788: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');
789: END IF;
790: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
791: Check_User_Status_Items (
792: p_user_status_rec => p_user_status_rec,
793: p_validation_mode => JTF_PLSQL_API.g_create,
794: x_return_status => l_return_status

Line 793: p_validation_mode => JTF_PLSQL_API.g_create,

789: END IF;
790: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
791: Check_User_Status_Items (
792: p_user_status_rec => p_user_status_rec,
793: p_validation_mode => JTF_PLSQL_API.g_create,
794: x_return_status => l_return_status
795: );
796: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
797: RAISE FND_API.g_exc_unexpected_error;

Line 806: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

802: IF (AMS_DEBUG_HIGH_ON) THEN
803:
804: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');
805: END IF;
806: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
807: Check_User_Status_Record (
808: p_user_status_rec => p_user_status_rec,
809: p_complete_rec => NULL,
810: x_return_status => l_return_status

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

859: --
860: ---------------------------------------------------------------------
861: PROCEDURE Check_User_Status_Items (
862: p_user_status_rec IN User_Status_Rec_Type,
863: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
864: x_return_status OUT NOCOPY VARCHAR2
865: )
866: IS
867: BEGIN

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

1246: END Check_User_Status_Req_Items;
1247: -- Check_User_Status_UK_Items
1248: PROCEDURE Check_User_Status_UK_Items (
1249: p_user_status_rec IN User_Status_Rec_Type,
1250: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1251: x_return_status OUT NOCOPY VARCHAR2
1252: )
1253: IS
1254: l_valid_flag VARCHAR2(1);

Line 1260: IF p_validation_mode = JTF_PLSQL_API.g_create

1256: x_return_status := FND_API.g_ret_sts_success;
1257: -- MEDIA_ID
1258: -- For Create_User_Status, when ID is passed in, we need to
1259: -- check if this ID is unique.
1260: IF p_validation_mode = JTF_PLSQL_API.g_create
1261: AND p_user_status_rec.user_status_id IS NOT NULL
1262: THEN
1263: IF AMS_Utility_PVT.check_uniqueness(
1264: 'ams_user_statuses_vl',

Line 1278: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

1274: END IF;
1275: END IF;
1276: -- check if NAME is UNIQUE
1277: -- modified sugupta 02/22/2000 UNIQUENESS OF NAME LIMITED TO THAT ACTIVITY TYPE
1278: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1279: l_valid_flag := AMS_Utility_PVT.check_uniqueness (
1280: 'ams_user_statuses_vl',
1281: 'name = ''' || p_user_status_rec.name ||
1282: ''' AND system_status_type = '''|| p_user_status_rec.system_status_type || ''''