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 AMS_UTILITY_PVT

Line 118: AMS_Utility_PVT.debug_message(l_full_name ||': validate');

114:
115: ----------------------- validate -----------------------
116: IF (AMS_DEBUG_HIGH_ON) THEN
117:
118: AMS_Utility_PVT.debug_message(l_full_name ||': validate');
119: END IF;
120: if (l_act_Resource_rec.arc_act_resource_used_by = 'SESSION')
121: THEN
122: OPEN c_get_object_date(l_act_Resource_rec.act_resource_used_by_id, l_act_Resource_rec.arc_act_resource_used_by);

Line 133: AMS_Utility_PVT.debug_message('l_start_date ' ||to_char(l_startdate,'DD-MON-RRRR HH24:MI'));

129: l_startdate := TO_DATE (l_strDate, 'DD-MM-YYYY HH24:MI');
130: l_act_Resource_rec.start_date_time := l_startdate;
131: IF (AMS_DEBUG_HIGH_ON) THEN
132:
133: AMS_Utility_PVT.debug_message('l_start_date ' ||to_char(l_startdate,'DD-MON-RRRR HH24:MI'));
134: END IF;
135:
136: l_strDate := NULL;
137: l_strTime := NULL;

Line 145: AMS_Utility_PVT.debug_message('l_end_date ' ||to_char(l_enddate,'DD-MON-RRRR HH24:MI'));

141: l_enddate := TO_DATE (l_strDate, 'DD-MM-YYYY HH24:MI');
142: l_act_Resource_rec.end_date_time := l_enddate;
143: IF (AMS_DEBUG_HIGH_ON) THEN
144:
145: AMS_Utility_PVT.debug_message('l_end_date ' ||to_char(l_enddate,'DD-MON-RRRR HH24:MI'));
146: END IF;
147:
148:
149: IF (AMS_DEBUG_HIGH_ON) THEN

Line 155: AMS_Utility_PVT.debug_message('l_start_date ' ||to_char(l_startdate,'DD-MON-RRRR HH24:MI'));

151:
152:
153:
154:
155: AMS_Utility_PVT.debug_message('l_start_date ' ||to_char(l_startdate,'DD-MON-RRRR HH24:MI'));
156:
157:
158: END IF;
159: END IF;

Line 394: AMS_Utility_PVT.debug_message('l_start_date ' ||to_char(l_startdate,'DD-MON-RRRR HH24:MI'));

390: l_startdate := TO_DATE (l_strDate, 'DD-MM-YYYY HH24:MI');
391: l_act_Resource_rec.start_date_time := l_startdate;
392: IF (AMS_DEBUG_HIGH_ON) THEN
393:
394: AMS_Utility_PVT.debug_message('l_start_date ' ||to_char(l_startdate,'DD-MON-RRRR HH24:MI'));
395: END IF;
396:
397: l_strDate := NULL;
398: l_strTime := NULL;

Line 406: AMS_Utility_PVT.debug_message('l_end_date ' ||to_char(l_enddate,'DD-MON-RRRR HH24:MI'));

402: l_enddate := TO_DATE (l_strDate, 'DD-MM-YYYY HH24:MI');
403: l_act_Resource_rec.end_date_time := l_enddate;
404: IF (AMS_DEBUG_HIGH_ON) THEN
405:
406: AMS_Utility_PVT.debug_message('l_end_date ' ||to_char(l_enddate,'DD-MON-RRRR HH24:MI'));
407: END IF;
408:
409:
410: IF (AMS_DEBUG_HIGH_ON) THEN

Line 416: AMS_Utility_PVT.debug_message('l_start_date ' ||to_char(l_startdate,'DD-MON-RRRR HH24:MI'));

412:
413:
414:
415:
416: AMS_Utility_PVT.debug_message('l_start_date ' ||to_char(l_startdate,'DD-MON-RRRR HH24:MI'));
417:
418:
419: END IF;
420: end if;

Line 433: AMS_Utility_PVT.debug_message(l_api_name||': check items');

429:
430:
431:
432:
433: AMS_Utility_PVT.debug_message(l_api_name||': check items');
434:
435:
436: END IF;
437:

Line 770: WHEN AMS_Utility_PVT.resource_locked THEN

766: ( p_count => x_msg_count,
767: p_data => x_msg_data,
768: p_encoded => FND_API.G_FALSE
769: );
770: WHEN AMS_Utility_PVT.resource_locked THEN
771: x_return_status := FND_API.g_ret_sts_error;
772: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
773: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
774: FND_MSG_PUB.add;

Line 851: AMS_Utility_PVT.debug_message(l_full_name||': check items');

847: IF (AMS_DEBUG_HIGH_ON) THEN
848:
849:
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

Line 875: AMS_Utility_PVT.debug_message(l_full_name||': check record level');

871: -- Perform cross attribute validation AND missing attribute checks. Record
872: -- level validation.
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(

Line 952: IF AMS_Utility_PVT.check_uniqueness(

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',
954: 'activity_resource_id = ' || p_act_Resource_rec.activity_resource_id
955: ) = FND_API.g_false
956: THEN

Line 1119: IF AMS_Utility_PVT.check_fk_exists(

1115: /*--------------------- application_id ------------------------
1116: IF p_act_Resource_rec.application_id <> FND_API.g_miss_num AND
1117: p_act_Resource_rec.application_id is NOT NULL
1118: THEN
1119: IF AMS_Utility_PVT.check_fk_exists(
1120: 'fnd_application',
1121: 'application_id',
1122: p_act_Resource_rec.application_id
1123: ) = FND_API.g_false

Line 1138: IF AMS_Utility_PVT.check_fk_exists(

1134:
1135: ----------------------- user_status_id ------------------------
1136: IF p_act_Resource_rec.user_status_id <> FND_API.g_miss_num
1137: AND p_act_Resource_rec.user_status_id IS NOT NULL THEN
1138: IF AMS_Utility_PVT.check_fk_exists(
1139: 'ams_user_statuses_b',
1140: 'user_status_id',
1141: p_act_Resource_rec.user_status_id
1142: ) = FND_API.g_false

Line 1161: IF AMS_Utility_PVT.Check_FK_Exists (

1157: THEN
1158: l_table_name := 'HZ_PARTIES';
1159: l_pk_name := 'PARTY_ID';
1160: l_pk_value := p_act_Resource_rec.resource_id;
1161: IF AMS_Utility_PVT.Check_FK_Exists (
1162: p_table_name => l_table_name
1163: ,p_pk_name => l_pk_name
1164: ,p_pk_value => l_pk_value
1165: ) = FND_API.G_FALSE

Line 1192: IF AMS_Utility_PVT.Check_FK_Exists (

1188: l_pk_name := 'EVENT_OFFER_ID';
1189: END IF;
1190:
1191: l_pk_value := p_act_Resource_rec.act_resource_used_by_id;
1192: IF AMS_Utility_PVT.Check_FK_Exists (
1193: p_table_name => l_table_name
1194: ,p_pk_name => l_pk_name
1195: ,p_pk_value => l_pk_value
1196: ) = FND_API.G_FALSE

Line 1231: IF AMS_Utility_PVT.check_lookup_exists(

1227: ----------------------- role_code ------------------------
1228: IF p_act_Resource_rec.role_cd <> FND_API.g_miss_char
1229: AND p_act_Resource_rec.role_cd IS NOT NULL
1230: THEN
1231: IF AMS_Utility_PVT.check_lookup_exists(
1232: p_lookup_type => 'AMS_EVENT_ROLE',
1233: p_lookup_code => p_act_Resource_rec.role_cd
1234: ) = FND_API.g_false
1235: THEN

Line 1250: IF AMS_Utility_PVT.check_lookup_exists(

1246: ----------------------- status ------------------------
1247: IF p_act_Resource_rec.system_status_code <> FND_API.g_miss_char
1248: AND p_act_Resource_rec.system_status_code IS NOT NULL
1249: THEN
1250: IF AMS_Utility_PVT.check_lookup_exists(
1251: p_lookup_type => 'AMS_EVENT_AGENDA_STATUS',
1252: p_lookup_code => p_act_Resource_rec.system_status_code
1253: ) = FND_API.g_false
1254: THEN

Line 1267: IF AMS_Utility_PVT.check_lookup_exists(

1263: END IF;
1264:
1265: ---------------- ARC_ACT_RESOURCE_USED_BY ------------
1266: IF p_act_Resource_rec.ARC_ACT_RESOURCE_USED_BY <> FND_API.g_miss_char THEN
1267: IF AMS_Utility_PVT.check_lookup_exists(
1268: p_lookup_type => 'AMS_SYS_ARC_QUALIFIER',
1269: p_lookup_code => p_act_Resource_rec.ARC_ACT_RESOURCE_USED_BY
1270: ) = FND_API.g_false
1271: THEN

Line 1308: IF AMS_Utility_PVT.is_Y_or_N(p_act_Resource_rec.primary_flag) = FND_API.g_false

1304: ----------------------- primary_flag ------------------------
1305: /* IF p_act_Resource_rec.primary_flag <> FND_API.g_miss_char
1306: AND p_act_Resource_rec.primary_flag IS NOT NULL
1307: THEN
1308: IF AMS_Utility_PVT.is_Y_or_N(p_act_Resource_rec.primary_flag) = FND_API.g_false
1309: THEN
1310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1311: THEN
1312: FND_MESSAGE.set_name('AMS', 'AMS_OBJ_BAD_PRIMARY_FLAG');

Line 1531: AMS_UTILITY_PVT.debug_message('Resource Start Time' || TO_CHAR(l_res_start_time,'DD-MM-YYYY HH24:MI') );

1527: l_parent_start_time := TO_DATE(TO_CHAR(l_event_start_date,'HH24:MI'),'HH24:MI');
1528: l_parent_end_time := TO_DATE(TO_CHAR(l_event_end_date,'HH24:MI'),'HH24:MI');
1529: IF (AMS_DEBUG_HIGH_ON) THEN
1530:
1531: AMS_UTILITY_PVT.debug_message('Resource Start Time' || TO_CHAR(l_res_start_time,'DD-MM-YYYY HH24:MI') );
1532: END IF;
1533: IF (AMS_DEBUG_HIGH_ON) THEN
1534:
1535: AMS_UTILITY_PVT.debug_message('Resource End Time' || TO_CHAR(l_res_end_time,'DD-MM-YYYY HH24:MI') );

Line 1535: AMS_UTILITY_PVT.debug_message('Resource End Time' || TO_CHAR(l_res_end_time,'DD-MM-YYYY HH24:MI') );

1531: AMS_UTILITY_PVT.debug_message('Resource Start Time' || TO_CHAR(l_res_start_time,'DD-MM-YYYY HH24:MI') );
1532: END IF;
1533: IF (AMS_DEBUG_HIGH_ON) THEN
1534:
1535: AMS_UTILITY_PVT.debug_message('Resource End Time' || TO_CHAR(l_res_end_time,'DD-MM-YYYY HH24:MI') );
1536: END IF;
1537: IF (AMS_DEBUG_HIGH_ON) THEN
1538:
1539: AMS_UTILITY_PVT.debug_message('Parent Start Time' || TO_CHAR(l_parent_start_time,'DD-MM-YYYY HH24:MI') || TO_CHAR(l_event_start_date,'DD-MM-YYYY HH24:MI'));

Line 1539: AMS_UTILITY_PVT.debug_message('Parent Start Time' || TO_CHAR(l_parent_start_time,'DD-MM-YYYY HH24:MI') || TO_CHAR(l_event_start_date,'DD-MM-YYYY HH24:MI'));

1535: AMS_UTILITY_PVT.debug_message('Resource End Time' || TO_CHAR(l_res_end_time,'DD-MM-YYYY HH24:MI') );
1536: END IF;
1537: IF (AMS_DEBUG_HIGH_ON) THEN
1538:
1539: AMS_UTILITY_PVT.debug_message('Parent Start Time' || TO_CHAR(l_parent_start_time,'DD-MM-YYYY HH24:MI') || TO_CHAR(l_event_start_date,'DD-MM-YYYY HH24:MI'));
1540: END IF;
1541: IF (AMS_DEBUG_HIGH_ON) THEN
1542:
1543: AMS_UTILITY_PVT.debug_message('Parent End Time' || TO_CHAR(l_parent_End_time,'DD-MM-YYYY HH24:MI') || TO_CHAR(l_event_end_date,'DD-MM-YYYY HH24:MI'));

Line 1543: AMS_UTILITY_PVT.debug_message('Parent End Time' || TO_CHAR(l_parent_End_time,'DD-MM-YYYY HH24:MI') || TO_CHAR(l_event_end_date,'DD-MM-YYYY HH24:MI'));

1539: AMS_UTILITY_PVT.debug_message('Parent Start Time' || TO_CHAR(l_parent_start_time,'DD-MM-YYYY HH24:MI') || TO_CHAR(l_event_start_date,'DD-MM-YYYY HH24:MI'));
1540: END IF;
1541: IF (AMS_DEBUG_HIGH_ON) THEN
1542:
1543: AMS_UTILITY_PVT.debug_message('Parent End Time' || TO_CHAR(l_parent_End_time,'DD-MM-YYYY HH24:MI') || TO_CHAR(l_event_end_date,'DD-MM-YYYY HH24:MI'));
1544: END IF;
1545: */
1546:
1547:

Line 1551: AMS_UTILITY_PVT.debug_message('Checking uk_items');

1547:
1548: --------------------------------------Create mode--------------------------
1549: IF (AMS_DEBUG_HIGH_ON) THEN
1550:
1551: AMS_UTILITY_PVT.debug_message('Checking uk_items');
1552: END IF;
1553: check_Act_Rsc_uk_items(
1554: p_act_Resource_rec => p_act_Resource_rec,
1555: p_validation_mode => p_validation_mode,

Line 1562: AMS_UTILITY_PVT.debug_message('Checking req_items');

1558:
1559: -------------------------- Create or Update Mode ----------------------------
1560: IF (AMS_DEBUG_HIGH_ON) THEN
1561:
1562: AMS_UTILITY_PVT.debug_message('Checking req_items');
1563: END IF;
1564: check_Act_Rsc_req_items(
1565: p_act_Resource_rec => p_act_Resource_rec,
1566: x_return_status => x_return_status

Line 1577: AMS_UTILITY_PVT.debug_message('Checking fk_items');

1573: IF (AMS_DEBUG_HIGH_ON) THEN
1574:
1575:
1576:
1577: AMS_UTILITY_PVT.debug_message('Checking fk_items');
1578:
1579: END IF;
1580: check_Act_Rsc_fk_items(
1581: p_act_Resource_rec => p_act_Resource_rec,

Line 1592: AMS_UTILITY_PVT.debug_message('Checking lookup_items');

1588: IF (AMS_DEBUG_HIGH_ON) THEN
1589:
1590:
1591:
1592: AMS_UTILITY_PVT.debug_message('Checking lookup_items');
1593:
1594: END IF;
1595: check_Act_Rsc_lookup_items(
1596: p_act_Resource_rec => p_act_Resource_rec,

Line 1607: AMS_UTILITY_PVT.debug_message('Checking flag_items');

1603: IF (AMS_DEBUG_HIGH_ON) THEN
1604:
1605:
1606:
1607: AMS_UTILITY_PVT.debug_message('Checking flag_items');
1608:
1609: END IF;
1610: check_Act_Rsc_flag_items(
1611: p_act_Resource_rec => p_act_Resource_rec,

Line 1635: AMS_UTILITY_PVT.debug_message('Checking Resource is already booked');

1631: IF (AMS_DEBUG_HIGH_ON) THEN
1632:
1633:
1634:
1635: AMS_UTILITY_PVT.debug_message('Checking Resource is already booked');
1636:
1637: END IF;
1638: check_Resource_booked(
1639: p_act_Resource_rec => p_act_Resource_rec,

Line 2087: AMS_Utility_PVT.debug_message('The resource_id is ' || p_act_Resource_rec.resource_id);

2083: IF (AMS_DEBUG_HIGH_ON) THEN
2084:
2085:
2086:
2087: AMS_Utility_PVT.debug_message('The resource_id is ' || p_act_Resource_rec.resource_id);
2088:
2089: END IF;
2090: IF (AMS_DEBUG_HIGH_ON) THEN
2091:

Line 2092: AMS_Utility_PVT.debug_message('The count for sessions/SESSION is ' || l_count);

2088:
2089: END IF;
2090: IF (AMS_DEBUG_HIGH_ON) THEN
2091:
2092: AMS_Utility_PVT.debug_message('The count for sessions/SESSION is ' || l_count);
2093: END IF;
2094: /* If l_count > 0 i.e. there are some existing sessions with date overlap.
2095: So Error out.
2096: */

Line 2114: AMS_Utility_PVT.debug_message('The count for events/SESSION is ' || l_count);

2110: IF (AMS_DEBUG_HIGH_ON) THEN
2111:
2112:
2113:
2114: AMS_Utility_PVT.debug_message('The count for events/SESSION is ' || l_count);
2115:
2116: END IF;
2117: /* If l_count > 0 i.e. there are some existing events with date overlap.
2118: So Error out.

Line 2147: AMS_Utility_PVT.debug_message('The count for events/(EVEO/EONE) is ' || l_count);

2143: IF (AMS_DEBUG_HIGH_ON) THEN
2144:
2145:
2146:
2147: AMS_Utility_PVT.debug_message('The count for events/(EVEO/EONE) is ' || l_count);
2148:
2149: END IF;
2150: /* If l_count > 0 i.e. there are some existing events with date overlap.
2151: So Error out.

Line 2171: AMS_Utility_PVT.debug_message('The count for Sessions/(EVEO/EONE) is ' || l_count);

2167: IF (AMS_DEBUG_HIGH_ON) THEN
2168:
2169:
2170:
2171: AMS_Utility_PVT.debug_message('The count for Sessions/(EVEO/EONE) is ' || l_count);
2172:
2173: END IF;
2174: /* If l_count > 0 i.e. there are some existing sessions with date overlap.
2175: So Error out.