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_VENUE_RATES_PVT dependencies on AMS_UTILITY_PVT

Line 84: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

80:
81: -- Debug Message
82: IF (AMS_DEBUG_HIGH_ON) THEN
83:
84: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
85: END IF;
86:
87:
88: -- Initialize API return status to SUCCESS

Line 114: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

110: -- =========================================================================
111:
112: IF FND_GLOBAL.User_Id IS NULL
113: THEN
114: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
115: RAISE FND_API.G_EXC_ERROR;
116: END IF;
117:
118: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 123: AMS_UTILITY_PVT.debug_message('Private API: Validate_Venue_Rates');

119: THEN
120: -- Debug message
121: IF (AMS_DEBUG_HIGH_ON) THEN
122:
123: AMS_UTILITY_PVT.debug_message('Private API: Validate_Venue_Rates');
124: END IF;
125:
126: -- Invoke validation procedures
127: Validate_venue_rates(

Line 157: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

153:
154: -- Debug Message
155: IF (AMS_DEBUG_HIGH_ON) THEN
156:
157: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
158: END IF;
159:
160: -- Invoke table handler(AMS_VENUE_RATES_B_PKG.Insert_Row)
161: AMS_VENUE_RATES_B_PKG.Insert_Row(

Line 214: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

210:
211: -- Debug Message
212: IF (AMS_DEBUG_HIGH_ON) THEN
213:
214: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
215: END IF;
216:
217: -- Standard call to get message count and if count is 1, get message info.
218: FND_MSG_PUB.Count_And_Get

Line 224: WHEN AMS_Utility_PVT.resource_locked THEN

220: p_data => x_msg_data
221: );
222: EXCEPTION
223:
224: WHEN AMS_Utility_PVT.resource_locked THEN
225: x_return_status := FND_API.g_ret_sts_error;
226: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
227:
228: WHEN FND_API.G_EXC_ERROR THEN

Line 226: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

222: EXCEPTION
223:
224: WHEN AMS_Utility_PVT.resource_locked THEN
225: x_return_status := FND_API.g_ret_sts_error;
226: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
227:
228: WHEN FND_API.G_EXC_ERROR THEN
229: ROLLBACK TO CREATE_Venue_Rates_PVT;
230: x_return_status := FND_API.G_RET_STS_ERROR;

Line 316: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

312:
313: -- Debug Message
314: IF (AMS_DEBUG_HIGH_ON) THEN
315:
316: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
317: END IF;
318:
319:
320: -- Initialize API return status to SUCCESS

Line 326: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

322:
323: -- Debug Message
324: IF (AMS_DEBUG_HIGH_ON) THEN
325:
326: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
327: END IF;
328:
329: /*
330: OPEN c_get_Venue_Rates( l_tar_venue_rates_rec.rate_id);

Line 335: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

331:
332: FETCH c_get_Venue_Rates INTO l_ref_venue_rates_rec ;
333:
334: If ( c_get_Venue_Rates%NOTFOUND) THEN
335: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
336: p_token_name => 'INFO',
337: p_token_value => 'Venue_Rates') ;
338: RAISE FND_API.G_EXC_ERROR;
339: END IF;

Line 343: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');

339: END IF;
340: -- Debug Message
341: IF (AMS_DEBUG_HIGH_ON) THEN
342:
343: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
344: END IF;
345: CLOSE c_get_Venue_Rates;
346: */
347:

Line 351: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

347:
348:
349: If (l_tar_venue_rates_rec.object_version_number is NULL or
350: l_tar_venue_rates_rec.object_version_number = FND_API.G_MISS_NUM ) Then
351: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
352: p_token_name => 'COLUMN',
353: p_token_value => 'Last_Update_Date') ;
354: raise FND_API.G_EXC_ERROR;
355: End if;

Line 358: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

354: raise FND_API.G_EXC_ERROR;
355: End if;
356: -- Check Whether record has been changed by someone else
357: If (l_tar_venue_rates_rec.object_version_number <> l_ref_venue_rates_rec.object_version_number) Then
358: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
359: p_token_name => 'INFO',
360: p_token_value => 'Venue_Rates') ;
361: raise FND_API.G_EXC_ERROR;
362: End if;

Line 368: AMS_UTILITY_PVT.debug_message('Private API: Validate_Venue_Rates');

364: THEN
365: -- Debug message
366: IF (AMS_DEBUG_HIGH_ON) THEN
367:
368: AMS_UTILITY_PVT.debug_message('Private API: Validate_Venue_Rates');
369: END IF;
370:
371: -- Invoke validation procedures
372: Validate_venue_rates(

Line 391: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');

387:
388: -- Debug Message
389: IF (AMS_DEBUG_HIGH_ON) THEN
390:
391: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
392: END IF;
393:
394: -- Invoke table handler(AMS_VENUE_RATES_B_PKG.Update_Row)
395: AMS_VENUE_RATES_B_PKG.Update_Row(

Line 446: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

442:
443: -- Debug Message
444: IF (AMS_DEBUG_HIGH_ON) THEN
445:
446: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
447: END IF;
448:
449: -- Standard call to get message count and if count is 1, get message info.
450: FND_MSG_PUB.Count_And_Get

Line 456: WHEN AMS_Utility_PVT.resource_locked THEN

452: p_data => x_msg_data
453: );
454: EXCEPTION
455:
456: WHEN AMS_Utility_PVT.resource_locked THEN
457: x_return_status := FND_API.g_ret_sts_error;
458: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
459:
460: WHEN FND_API.G_EXC_ERROR THEN

Line 458: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

454: EXCEPTION
455:
456: WHEN AMS_Utility_PVT.resource_locked THEN
457: x_return_status := FND_API.g_ret_sts_error;
458: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
459:
460: WHEN FND_API.G_EXC_ERROR THEN
461: ROLLBACK TO UPDATE_Venue_Rates_PVT;
462: x_return_status := FND_API.G_RET_STS_ERROR;

Line 535: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

531:
532: -- Debug Message
533: IF (AMS_DEBUG_HIGH_ON) THEN
534:
535: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
536: END IF;
537:
538:
539: -- Initialize API return status to SUCCESS

Line 548: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

544: --
545: -- Debug Message
546: IF (AMS_DEBUG_HIGH_ON) THEN
547:
548: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
549: END IF;
550:
551: -- Invoke table handler(AMS_VENUE_RATES_B_PKG.Delete_Row)
552: AMS_VENUE_RATES_B_PKG.Delete_Row(

Line 568: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

564:
565: -- Debug Message
566: IF (AMS_DEBUG_HIGH_ON) THEN
567:
568: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
569: END IF;
570:
571: -- Standard call to get message count and if count is 1, get message info.
572: FND_MSG_PUB.Count_And_Get

Line 578: WHEN AMS_Utility_PVT.resource_locked THEN

574: p_data => x_msg_data
575: );
576: EXCEPTION
577:
578: WHEN AMS_Utility_PVT.resource_locked THEN
579: x_return_status := FND_API.g_ret_sts_error;
580: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
581:
582: WHEN FND_API.G_EXC_ERROR THEN

Line 580: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

576: EXCEPTION
577:
578: WHEN AMS_Utility_PVT.resource_locked THEN
579: x_return_status := FND_API.g_ret_sts_error;
580: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
581:
582: WHEN FND_API.G_EXC_ERROR THEN
583: ROLLBACK TO DELETE_Venue_Rates_PVT;
584: x_return_status := FND_API.G_RET_STS_ERROR;

Line 650: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

646:
647: -- Debug Message
648: IF (AMS_DEBUG_HIGH_ON) THEN
649:
650: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
651: END IF;
652:
653: -- Initialize message list if p_init_msg_list is set to TRUE.
654: IF FND_API.to_Boolean( p_init_msg_list )

Line 679: AMS_Utility_PVT.debug_message(l_full_name||': start');

675: IF (AMS_DEBUG_HIGH_ON) THEN
676:
677:
678:
679: AMS_Utility_PVT.debug_message(l_full_name||': start');
680:
681: END IF;
682: OPEN c_Venue_Rates;
683:

Line 704: AMS_Utility_PVT.debug_message(l_full_name ||': end');

700: p_count => x_msg_count,
701: p_data => x_msg_data);
702: IF (AMS_DEBUG_HIGH_ON) THEN
703:
704: AMS_Utility_PVT.debug_message(l_full_name ||': end');
705: END IF;
706: EXCEPTION
707:
708: WHEN AMS_Utility_PVT.resource_locked THEN

Line 708: WHEN AMS_Utility_PVT.resource_locked THEN

704: AMS_Utility_PVT.debug_message(l_full_name ||': end');
705: END IF;
706: EXCEPTION
707:
708: WHEN AMS_Utility_PVT.resource_locked THEN
709: x_return_status := FND_API.g_ret_sts_error;
710: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
711:
712: WHEN FND_API.G_EXC_ERROR THEN

Line 710: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

706: EXCEPTION
707:
708: WHEN AMS_Utility_PVT.resource_locked THEN
709: x_return_status := FND_API.g_ret_sts_error;
710: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
711:
712: WHEN FND_API.G_EXC_ERROR THEN
713: ROLLBACK TO LOCK_Venue_Rates_PVT;
714: x_return_status := FND_API.G_RET_STS_ERROR;

Line 758: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

754:
755: BEGIN
756: x_return_status := FND_API.g_ret_sts_success;
757: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
758: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
759: 'AMS_VENUE_RATES_B',
760: 'RATE_ID = ''' || p_venue_rates_rec.RATE_ID ||''''
761: );
762: ELSE

Line 763: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

759: 'AMS_VENUE_RATES_B',
760: 'RATE_ID = ''' || p_venue_rates_rec.RATE_ID ||''''
761: );
762: ELSE
763: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
764: 'AMS_VENUE_RATES_B',
765: 'RATE_ID = ''' || p_venue_rates_rec.RATE_ID ||
766: ''' AND RATE_ID <> ' || p_venue_rates_rec.RATE_ID
767: );

Line 771: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_RATE_ID_DUPLICATE');

767: );
768: END IF;
769:
770: IF l_valid_flag = FND_API.g_false THEN
771: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_RATE_ID_DUPLICATE');
772: x_return_status := FND_API.g_ret_sts_error;
773: RETURN;
774: END IF;
775:

Line 894: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_rate_id');

890: ELSE
891:
892:
893: IF p_venue_rates_rec.rate_id IS NULL THEN
894: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_rate_id');
895: x_return_status := FND_API.g_ret_sts_error;
896: RETURN;
897: END IF;
898:

Line 901: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_last_update_date');

897: END IF;
898:
899: /*
900: IF p_venue_rates_rec.last_update_date IS NULL THEN
901: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_last_update_date');
902: x_return_status := FND_API.g_ret_sts_error;
903: RETURN;
904: END IF;
905:

Line 908: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_last_updated_by');

904: END IF;
905:
906:
907: IF p_venue_rates_rec.last_updated_by IS NULL THEN
908: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_last_updated_by');
909: x_return_status := FND_API.g_ret_sts_error;
910: RETURN;
911: END IF;
912:

Line 915: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_creation_date');

911: END IF;
912:
913:
914: IF p_venue_rates_rec.creation_date IS NULL THEN
915: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_creation_date');
916: x_return_status := FND_API.g_ret_sts_error;
917: RETURN;
918: END IF;
919:

Line 922: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_created_by');

918: END IF;
919:
920:
921: IF p_venue_rates_rec.created_by IS NULL THEN
922: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_created_by');
923: x_return_status := FND_API.g_ret_sts_error;
924: RETURN;
925: END IF;
926:

Line 929: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_venue_id');

925: END IF;
926:
927: */
928: IF p_venue_rates_rec.venue_id IS NULL THEN
929: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_venue_id');
930: x_return_status := FND_API.g_ret_sts_error;
931: RETURN;
932: END IF;
933:

Line 936: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_metric_id');

932: END IF;
933:
934:
935: IF p_venue_rates_rec.metric_id IS NULL THEN
936: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_metric_id');
937: x_return_status := FND_API.g_ret_sts_error;
938: RETURN;
939: END IF;
940:

Line 943: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_transactional_value');

939: END IF;
940:
941:
942: IF p_venue_rates_rec.transactional_value IS NULL THEN
943: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_transactional_value');
944: x_return_status := FND_API.g_ret_sts_error;
945: RETURN;
946: END IF;
947:

Line 950: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_transactional_currency_code');

946: END IF;
947:
948:
949: IF p_venue_rates_rec.transactional_currency_code IS NULL THEN
950: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_transactional_currency_code');
951: x_return_status := FND_API.g_ret_sts_error;
952: RETURN;
953: END IF;
954:

Line 957: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_functional_value');

953: END IF;
954:
955:
956: IF p_venue_rates_rec.functional_value IS NULL THEN
957: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_functional_value');
958: x_return_status := FND_API.g_ret_sts_error;
959: RETURN;
960: END IF;
961:

Line 964: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_functional_currency_code');

960: END IF;
961:
962:
963: IF p_venue_rates_rec.functional_currency_code IS NULL THEN
964: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_functional_currency_code');
965: x_return_status := FND_API.g_ret_sts_error;
966: RETURN;
967: END IF;
968:

Line 971: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_uom_code');

967: END IF;
968:
969:
970: IF p_venue_rates_rec.uom_code IS NULL THEN
971: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_venue_rates_NO_uom_code');
972: x_return_status := FND_API.g_ret_sts_error;
973: RETURN;
974: END IF;
975: END IF;

Line 1001: IF AMS_Utility_PVT.check_lookup_exists(

997:
998: IF p_venue_rates_rec.rate_code <> FND_API.g_miss_char
999: AND p_venue_rates_rec.rate_code IS NOT NULL
1000: THEN
1001: IF AMS_Utility_PVT.check_lookup_exists(
1002: p_lookup_type => 'AMS_RATE_CODE',
1003: p_lookup_code => p_venue_rates_rec.rate_code
1004: ) = FND_API.g_false
1005: THEN

Line 1331: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1327:
1328: -- Debug Message
1329: IF (AMS_DEBUG_HIGH_ON) THEN
1330:
1331: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1332: END IF;
1333:
1334:
1335: -- Initialize API return status to SUCCESS

Line 1342: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1338:
1339: -- Debug Message
1340: IF (AMS_DEBUG_HIGH_ON) THEN
1341:
1342: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1343: END IF;
1344:
1345: -- Standard call to get message count and if count is 1, get message info.
1346: FND_MSG_PUB.Count_And_Get

Line 1352: WHEN AMS_Utility_PVT.resource_locked THEN

1348: p_data => x_msg_data
1349: );
1350: EXCEPTION
1351:
1352: WHEN AMS_Utility_PVT.resource_locked THEN
1353: x_return_status := FND_API.g_ret_sts_error;
1354: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1355:
1356: WHEN FND_API.G_EXC_ERROR THEN

Line 1354: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1350: EXCEPTION
1351:
1352: WHEN AMS_Utility_PVT.resource_locked THEN
1353: x_return_status := FND_API.g_ret_sts_error;
1354: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1355:
1356: WHEN FND_API.G_EXC_ERROR THEN
1357: ROLLBACK TO VALIDATE_Venue_Rates_;
1358: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1419: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1415:
1416: -- Debug Message
1417: IF (AMS_DEBUG_HIGH_ON) THEN
1418:
1419: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1420: END IF;
1421: -- Standard call to get message count and if count is 1, get message info.
1422: FND_MSG_PUB.Count_And_Get
1423: (p_count => x_msg_count,