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

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

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

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

106: -- =========================================================================
107:
108: IF FND_GLOBAL.User_Id IS NULL
109: THEN
110: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113: /*
114: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 122: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Assoc');

118: IF (AMS_DEBUG_HIGH_ON) THEN
119:
120:
121:
122: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Assoc');
123:
124: END IF;
125:
126: Invoke validation procedures

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

141: */
142: -- Debug Message
143: IF (AMS_DEBUG_HIGH_ON) THEN
144:
145: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
146: END IF;
147:
148: -- Invoke table handler(AMS_LIST_CONT_RESTRICTIONS_PKG.Insert_Row)
149: AMS_LIST_CONT_RESTRICTIONS_PKG.Insert_Row(

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

176:
177: -- Debug Message
178: IF (AMS_DEBUG_HIGH_ON) THEN
179:
180: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
181: END IF;
182:
183: -- Standard call to get message count and if count is 1, get message info.
184: FND_MSG_PUB.Count_And_Get

Line 190: WHEN AMS_Utility_PVT.resource_locked THEN

186: p_data => x_msg_data
187: );
188: EXCEPTION
189:
190: WHEN AMS_Utility_PVT.resource_locked THEN
191: x_return_status := FND_API.g_ret_sts_error;
192: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
193:
194: WHEN FND_API.G_EXC_ERROR THEN

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

188: EXCEPTION
189:
190: WHEN AMS_Utility_PVT.resource_locked THEN
191: x_return_status := FND_API.g_ret_sts_error;
192: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
193:
194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO CREATE_List_Assoc_PVT;
196: x_return_status := FND_API.G_RET_STS_ERROR;

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

279:
280: -- Debug Message
281: IF (AMS_DEBUG_HIGH_ON) THEN
282:
283: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
284: END IF;
285:
286:
287: -- Initialize API return status to SUCCESS

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

289:
290: -- Debug Message
291: IF (AMS_DEBUG_HIGH_ON) THEN
292:
293: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
294: END IF;
295:
296: /*
297: OPEN c_get_List_Assoc( l_tar_list_assoc_rec.list_cont_restrictions_id);

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

298:
299: FETCH c_get_List_Assoc INTO l_ref_list_assoc_rec ;
300:
301: If ( c_get_List_Assoc%NOTFOUND) THEN
302: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
303: p_token_name => 'INFO',
304: p_token_value => 'List_Assoc') ;
305: RAISE FND_API.G_EXC_ERROR;
306: END IF;

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

306: END IF;
307: -- Debug Message
308: IF (AMS_DEBUG_HIGH_ON) THEN
309:
310: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
311: END IF;
312: CLOSE c_get_List_Assoc;
313: */
314:

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

314:
315:
316: If (l_tar_list_assoc_rec.object_version_number is NULL or
317: l_tar_list_assoc_rec.object_version_number = FND_API.G_MISS_NUM ) Then
318: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
319: p_token_name => 'COLUMN',
320: p_token_value => 'Last_Update_Date') ;
321: raise FND_API.G_EXC_ERROR;
322: End if;

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

321: raise FND_API.G_EXC_ERROR;
322: End if;
323: -- Check Whether record has been changed by someone else
324: If (l_tar_list_assoc_rec.object_version_number <> l_ref_list_assoc_rec.object_version_number) Then
325: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
326: p_token_name => 'INFO',
327: p_token_value => 'List_Assoc') ;
328: raise FND_API.G_EXC_ERROR;
329: End if;

Line 335: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Assoc');

331: THEN
332: -- Debug message
333: IF (AMS_DEBUG_HIGH_ON) THEN
334:
335: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Assoc');
336: END IF;
337:
338: -- Invoke validation procedures
339: Validate_list_assoc(

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

354:
355: -- Debug Message
356: IF (AMS_DEBUG_HIGH_ON) THEN
357:
358: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
359: END IF;
360:
361: -- Invoke table handler(AMS_LIST_CONT_RESTRICTIONS_PKG.Update_Row)
362: AMS_LIST_CONT_RESTRICTIONS_PKG.Update_Row(

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

385:
386: -- Debug Message
387: IF (AMS_DEBUG_HIGH_ON) THEN
388:
389: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
390: END IF;
391:
392: -- Standard call to get message count and if count is 1, get message info.
393: FND_MSG_PUB.Count_And_Get

Line 399: WHEN AMS_Utility_PVT.resource_locked THEN

395: p_data => x_msg_data
396: );
397: EXCEPTION
398:
399: WHEN AMS_Utility_PVT.resource_locked THEN
400: x_return_status := FND_API.g_ret_sts_error;
401: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
402:
403: WHEN FND_API.G_EXC_ERROR THEN

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

397: EXCEPTION
398:
399: WHEN AMS_Utility_PVT.resource_locked THEN
400: x_return_status := FND_API.g_ret_sts_error;
401: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
402:
403: WHEN FND_API.G_EXC_ERROR THEN
404: ROLLBACK TO UPDATE_List_Assoc_PVT;
405: x_return_status := FND_API.G_RET_STS_ERROR;

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

475:
476: -- Debug Message
477: IF (AMS_DEBUG_HIGH_ON) THEN
478:
479: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
480: END IF;
481:
482:
483: -- Initialize API return status to SUCCESS

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

488: --
489: -- Debug Message
490: IF (AMS_DEBUG_HIGH_ON) THEN
491:
492: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
493: END IF;
494:
495: -- Invoke table handler(AMS_LIST_CONT_RESTRICTIONS_PKG.Delete_Row)
496: AMS_LIST_CONT_RESTRICTIONS_PKG.Delete_Row(

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

508:
509: -- Debug Message
510: IF (AMS_DEBUG_HIGH_ON) THEN
511:
512: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
513: END IF;
514:
515: -- Standard call to get message count and if count is 1, get message info.
516: FND_MSG_PUB.Count_And_Get

Line 522: WHEN AMS_Utility_PVT.resource_locked THEN

518: p_data => x_msg_data
519: );
520: EXCEPTION
521:
522: WHEN AMS_Utility_PVT.resource_locked THEN
523: x_return_status := FND_API.g_ret_sts_error;
524: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
525:
526: WHEN FND_API.G_EXC_ERROR THEN

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

520: EXCEPTION
521:
522: WHEN AMS_Utility_PVT.resource_locked THEN
523: x_return_status := FND_API.g_ret_sts_error;
524: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
525:
526: WHEN FND_API.G_EXC_ERROR THEN
527: ROLLBACK TO DELETE_List_Assoc_PVT;
528: x_return_status := FND_API.G_RET_STS_ERROR;

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

590:
591: -- Debug Message
592: IF (AMS_DEBUG_HIGH_ON) THEN
593:
594: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
595: END IF;
596:
597: -- Initialize message list if p_init_msg_list is set to TRUE.
598: IF FND_API.to_Boolean( p_init_msg_list )

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

620: IF (AMS_DEBUG_HIGH_ON) THEN
621:
622:
623:
624: AMS_Utility_PVT.debug_message(l_full_name||': start');
625:
626: END IF;
627: OPEN c_List_Assoc;
628:

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

645: p_count => x_msg_count,
646: p_data => x_msg_data);
647: IF (AMS_DEBUG_HIGH_ON) THEN
648:
649: AMS_Utility_PVT.debug_message(l_full_name ||': end');
650: END IF;
651: EXCEPTION
652:
653: WHEN AMS_Utility_PVT.resource_locked THEN

Line 653: WHEN AMS_Utility_PVT.resource_locked THEN

649: AMS_Utility_PVT.debug_message(l_full_name ||': end');
650: END IF;
651: EXCEPTION
652:
653: WHEN AMS_Utility_PVT.resource_locked THEN
654: x_return_status := FND_API.g_ret_sts_error;
655: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
656:
657: WHEN FND_API.G_EXC_ERROR THEN

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

651: EXCEPTION
652:
653: WHEN AMS_Utility_PVT.resource_locked THEN
654: x_return_status := FND_API.g_ret_sts_error;
655: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
656:
657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO LOCK_List_Assoc_PVT;
659: x_return_status := FND_API.G_RET_STS_ERROR;

Line 703: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

699:
700: BEGIN
701: x_return_status := FND_API.g_ret_sts_success;
702: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
703: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
704: 'AMS_LIST_CONT_RESTRICTIONS',
705: 'LIST_CONTACT_RESTRICTIONs_ID = ''' || p_list_assoc_rec.LIST_CONT_RESTRICTIONs_ID ||''''
706: );
707: ELSE

Line 708: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

704: 'AMS_LIST_CONT_RESTRICTIONS',
705: 'LIST_CONTACT_RESTRICTIONs_ID = ''' || p_list_assoc_rec.LIST_CONT_RESTRICTIONs_ID ||''''
706: );
707: ELSE
708: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
709: 'AMS_LIST_CONT_RESTRICTIONS',
710: 'LIST_CONTACT_RESTRICTIONs_ID = ''' || p_list_assoc_rec.LIST_CONT_RESTRICTIONs_ID ||
711: ''' AND LIST_CONTACT_RESTRICTIONs_ID <> ' || p_list_assoc_rec.LIST_CONT_RESTRICTIONs_ID
712: );

Line 716: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_LIST_CONTACT_RESTRICTIONS_ID_DUPLICATE');

712: );
713: END IF;
714:
715: IF l_valid_flag = FND_API.g_false THEN
716: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_LIST_CONTACT_RESTRICTIONS_ID_DUPLICATE');
717: x_return_status := FND_API.g_ret_sts_error;
718: RETURN;
719: END IF;
720:

Line 753: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_list_contact_restrictions_id');

749: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
750:
751:
752: IF p_list_assoc_rec.list_cont_restrictions_id = FND_API.g_miss_num OR p_list_assoc_rec.list_cont_restrictions_id IS NULL THEN
753: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_list_contact_restrictions_id');
754: x_return_status := FND_API.g_ret_sts_error;
755: RETURN;
756: END IF;
757:

Line 760: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_list_header_id');

756: END IF;
757:
758:
759: IF p_list_assoc_rec.list_header_id = FND_API.g_miss_num OR p_list_assoc_rec.list_header_id IS NULL THEN
760: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_list_header_id');
761: x_return_status := FND_API.g_ret_sts_error;
762: RETURN;
763: END IF;
764:

Line 767: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_last_update_date');

763: END IF;
764:
765:
766: IF p_list_assoc_rec.last_update_date = FND_API.g_miss_date OR p_list_assoc_rec.last_update_date IS NULL THEN
767: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_last_update_date');
768: x_return_status := FND_API.g_ret_sts_error;
769: RETURN;
770: END IF;
771:

Line 774: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_last_updated_by');

770: END IF;
771:
772:
773: IF p_list_assoc_rec.last_updated_by = FND_API.g_miss_num OR p_list_assoc_rec.last_updated_by IS NULL THEN
774: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_last_updated_by');
775: x_return_status := FND_API.g_ret_sts_error;
776: RETURN;
777: END IF;
778:

Line 781: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_creation_date');

777: END IF;
778:
779:
780: IF p_list_assoc_rec.creation_date = FND_API.g_miss_date OR p_list_assoc_rec.creation_date IS NULL THEN
781: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_creation_date');
782: x_return_status := FND_API.g_ret_sts_error;
783: RETURN;
784: END IF;
785:

Line 788: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_created_by');

784: END IF;
785:
786:
787: IF p_list_assoc_rec.created_by = FND_API.g_miss_num OR p_list_assoc_rec.created_by IS NULL THEN
788: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_created_by');
789: x_return_status := FND_API.g_ret_sts_error;
790: RETURN;
791: END IF;
792: ELSE

Line 796: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_list_contact_restrictions_id');

792: ELSE
793:
794:
795: IF p_list_assoc_rec.list_cont_restrictions_id IS NULL THEN
796: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_list_contact_restrictions_id');
797: x_return_status := FND_API.g_ret_sts_error;
798: RETURN;
799: END IF;
800:

Line 803: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_list_header_id');

799: END IF;
800:
801:
802: IF p_list_assoc_rec.list_header_id IS NULL THEN
803: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_list_header_id');
804: x_return_status := FND_API.g_ret_sts_error;
805: RETURN;
806: END IF;
807:

Line 810: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_last_update_date');

806: END IF;
807:
808:
809: IF p_list_assoc_rec.last_update_date IS NULL THEN
810: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_last_update_date');
811: x_return_status := FND_API.g_ret_sts_error;
812: RETURN;
813: END IF;
814:

Line 817: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_last_updated_by');

813: END IF;
814:
815:
816: IF p_list_assoc_rec.last_updated_by IS NULL THEN
817: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_last_updated_by');
818: x_return_status := FND_API.g_ret_sts_error;
819: RETURN;
820: END IF;
821:

Line 824: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_creation_date');

820: END IF;
821:
822:
823: IF p_list_assoc_rec.creation_date IS NULL THEN
824: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_creation_date');
825: x_return_status := FND_API.g_ret_sts_error;
826: RETURN;
827: END IF;
828:

Line 831: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_created_by');

827: END IF;
828:
829:
830: IF p_list_assoc_rec.created_by IS NULL THEN
831: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_assoc_NO_created_by');
832: x_return_status := FND_API.g_ret_sts_error;
833: RETURN;
834: END IF;
835: END IF;

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

1123:
1124: -- Debug Message
1125: IF (AMS_DEBUG_HIGH_ON) THEN
1126:
1127: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1128: END IF;
1129:
1130:
1131: -- Initialize API return status to SUCCESS

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

1134:
1135: -- Debug Message
1136: IF (AMS_DEBUG_HIGH_ON) THEN
1137:
1138: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1139: END IF;
1140:
1141: -- Standard call to get message count and if count is 1, get message info.
1142: FND_MSG_PUB.Count_And_Get

Line 1148: WHEN AMS_Utility_PVT.resource_locked THEN

1144: p_data => x_msg_data
1145: );
1146: EXCEPTION
1147:
1148: WHEN AMS_Utility_PVT.resource_locked THEN
1149: x_return_status := FND_API.g_ret_sts_error;
1150: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1151:
1152: WHEN FND_API.G_EXC_ERROR THEN

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

1146: EXCEPTION
1147:
1148: WHEN AMS_Utility_PVT.resource_locked THEN
1149: x_return_status := FND_API.g_ret_sts_error;
1150: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1151:
1152: WHEN FND_API.G_EXC_ERROR THEN
1153: ROLLBACK TO VALIDATE_List_Assoc_;
1154: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1215: AMS_UTILITY_PVT.debug_message('Private API: Validate_list_assoc_rec');

1211:
1212: -- Debug Message
1213: IF (AMS_DEBUG_HIGH_ON) THEN
1214:
1215: AMS_UTILITY_PVT.debug_message('Private API: Validate_list_assoc_rec');
1216: END IF;
1217: -- Standard call to get message count and if count is 1, get message info.
1218: FND_MSG_PUB.Count_And_Get
1219: (p_count => x_msg_count,