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

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

34: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
35:
36: PROCEDURE Check_Resource_Booked (
37: p_act_Resource_rec IN act_Resource_rec_type,
38: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
39: x_return_status OUT NOCOPY VARCHAR2
40: );
41:
42: -- Procedure AND function declarations.

Line 438: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item

434:
435:
436: END IF;
437:
438: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item
439: THEN
440: Validate_Act_Resource_Items
441: ( p_act_Resource_rec => l_act_Resource_rec,
442: p_validation_mode => JTF_PLSQL_API.g_update,

Line 442: p_validation_mode => JTF_PLSQL_API.g_update,

438: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item
439: THEN
440: Validate_Act_Resource_Items
441: ( p_act_Resource_rec => l_act_Resource_rec,
442: p_validation_mode => JTF_PLSQL_API.g_update,
443: x_return_status => l_return_status
444: );
445: -- If any errors happen abort API.
446: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

Line 854: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item

850:
851: AMS_Utility_PVT.debug_message(l_full_name||': check items');
852:
853: END IF;
854: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item
855: THEN
856: Validate_Act_Resource_Items
857: ( p_act_Resource_rec => l_act_Resource_rec,
858: p_validation_mode => JTF_PLSQL_API.g_create,

Line 858: p_validation_mode => JTF_PLSQL_API.g_create,

854: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item
855: THEN
856: Validate_Act_Resource_Items
857: ( p_act_Resource_rec => l_act_Resource_rec,
858: p_validation_mode => JTF_PLSQL_API.g_create,
859: x_return_status => l_return_status
860: );
861:
862: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

Line 877: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record

873: IF (AMS_DEBUG_HIGH_ON) THEN
874:
875: AMS_Utility_PVT.debug_message(l_full_name||': check record level');
876: END IF;
877: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record
878: THEN
879: Validate_Act_Rsc_Record(
880: p_act_Resource_rec => l_act_Resource_rec,
881: x_return_status => l_return_status

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

932: -- 02/20/2002 gmadana Created.
933: /*****************************************************************************************/
934: PROCEDURE check_Act_Rsc_uk_items(
935: p_act_Resource_rec IN act_Resource_rec_type,
936: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
937: x_return_status OUT NOCOPY VARCHAR2
938: )
939: IS
940: l_valid_flag VARCHAR2(1);

Line 949: IF p_validation_mode = JTF_PLSQL_API.g_create

945:
946: -- For create_act_resource, when activity_resource_id is passed in, we need to
947: -- check if this activity_resource_id is unique.
948:
949: IF p_validation_mode = JTF_PLSQL_API.g_create
950: AND p_act_Resource_rec.activity_resource_id IS NOT NULL
951: THEN
952: IF AMS_Utility_PVT.check_uniqueness(
953: 'ams_act_resources_v',

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

1331: /*****************************************************************************************/
1332:
1333: PROCEDURE Validate_Act_Resource_Items
1334: ( p_act_Resource_rec IN act_Resource_rec_type,
1335: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1336: x_return_status OUT NOCOPY VARCHAR2
1337: ) IS
1338:
1339: l_table_name VARCHAR2(30);

Line 2069: IF(p_validation_mode = Jtf_Plsql_Api.g_create)

2065: IF (p_act_Resource_rec.role_cd <> 'COORDINATOR' )
2066: THEN
2067: IF(p_act_Resource_rec.arc_act_resource_used_by = 'SESSION')
2068: THEN
2069: IF(p_validation_mode = Jtf_Plsql_Api.g_create)
2070: THEN
2071: /* checking across all the sessions for date overlap */
2072: OPEN C_check_sessions_create(p_act_Resource_rec.resource_id);
2073: FETCH C_check_sessions_create INTO l_count;

Line 2075: ELSIF(p_validation_mode = Jtf_Plsql_Api.g_update)

2071: /* checking across all the sessions for date overlap */
2072: OPEN C_check_sessions_create(p_act_Resource_rec.resource_id);
2073: FETCH C_check_sessions_create INTO l_count;
2074: CLOSE C_check_sessions_create;
2075: ELSIF(p_validation_mode = Jtf_Plsql_Api.g_update)
2076: THEN
2077: /* checking across all the sessions excluding itself for date overlap */
2078: OPEN C_check_sessions_update;
2079: FETCH C_check_sessions_update INTO l_count;

Line 2129: IF(p_validation_mode = Jtf_Plsql_Api.g_create)

2125:
2126: ELSIF(p_act_Resource_rec.arc_act_resource_used_by = 'EVEO' OR
2127: p_act_Resource_rec.arc_act_resource_used_by = 'EONE')
2128: THEN
2129: IF(p_validation_mode = Jtf_Plsql_Api.g_create)
2130: THEN
2131: /* checking across all the events for date overlap */
2132: OPEN C_check_events_create;
2133: FETCH C_check_events_create INTO l_count;

Line 2135: ELSIF(p_validation_mode = Jtf_Plsql_Api.g_update)

2131: /* checking across all the events for date overlap */
2132: OPEN C_check_events_create;
2133: FETCH C_check_events_create INTO l_count;
2134: CLOSE C_check_events_create;
2135: ELSIF(p_validation_mode = Jtf_Plsql_Api.g_update)
2136: THEN
2137: /* checking across all the events except itself, for date overlap */
2138: OPEN C_check_events_update;
2139: FETCH C_check_events_update INTO l_count;