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_PS_CNDCLSES_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 113: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

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

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

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

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

139:
140: -- Debug Message
141: IF (AMS_DEBUG_HIGH_ON) THEN
142:
143: AMS_UTILITY_PVT.debug_message('Private API: Calling create table handler');
144: END IF;
145:
146: select CND_CLAUSE_REF_CODE bulk collect into l_str_tab
147: from ams_iba_ps_cndclses_b

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

199:
200: -- Debug Message
201: IF (AMS_DEBUG_HIGH_ON) THEN
202:
203: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
204: END IF;
205:
206: -- Standard call to get message count and if count is 1, get message info.
207: FND_MSG_PUB.Count_And_Get

Line 213: WHEN AMS_Utility_PVT.resource_locked THEN

209: p_data => x_msg_data
210: );
211: EXCEPTION
212:
213: WHEN AMS_Utility_PVT.resource_locked THEN
214: x_return_status := FND_API.g_ret_sts_error;
215: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
216:
217: WHEN FND_API.G_EXC_ERROR THEN

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

211: EXCEPTION
212:
213: WHEN AMS_Utility_PVT.resource_locked THEN
214: x_return_status := FND_API.g_ret_sts_error;
215: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
216:
217: WHEN FND_API.G_EXC_ERROR THEN
218: ROLLBACK TO CREATE_Ps_Cndclses_PVT;
219: x_return_status := FND_API.G_RET_STS_ERROR;

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

302:
303: -- Debug Message
304: IF (AMS_DEBUG_HIGH_ON) THEN
305:
306: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
307: END IF;
308:
309:
310: -- Initialize API return status to SUCCESS

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

312:
313: -- Debug Message
314: IF (AMS_DEBUG_HIGH_ON) THEN
315:
316: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
317: END IF;
318:
319: --/*
320: OPEN c_get_Ps_Cndclses( l_tar_ps_cndclses_rec.cnd_clause_id);

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

321:
322: FETCH c_get_Ps_Cndclses INTO l_ref_ps_cndclses_rec ;
323:
324: If ( c_get_Ps_Cndclses%NOTFOUND) THEN
325: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
326: p_token_name => 'INFO',
327: p_token_value => 'Ps_Cndclses') ;
328: RAISE FND_API.G_EXC_ERROR;
329: END IF;

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

329: END IF;
330: -- Debug Message
331: IF (AMS_DEBUG_HIGH_ON) THEN
332:
333: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
334: END IF;
335: CLOSE c_get_Ps_Cndclses;
336: --*/
337:

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

336: --*/
337:
338: If (l_tar_ps_cndclses_rec.object_version_number is NULL or
339: l_tar_ps_cndclses_rec.object_version_number = FND_API.G_MISS_NUM ) Then
340: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
341: p_token_name => 'COLUMN',
342: p_token_value => 'Last_Update_Date') ;
343: raise FND_API.G_EXC_ERROR;
344: End if;

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

343: raise FND_API.G_EXC_ERROR;
344: End if;
345: -- Check Whether record has been changed by someone else
346: If (l_tar_ps_cndclses_rec.object_version_number <> l_ref_ps_cndclses_rec.object_version_number) Then
347: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
348: p_token_name => 'INFO',
349: p_token_value => 'Ps_Cndclses') ;
350: raise FND_API.G_EXC_ERROR;
351: End if;

Line 357: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ps_Cndclses');

353: THEN
354: -- Debug message
355: IF (AMS_DEBUG_HIGH_ON) THEN
356:
357: AMS_UTILITY_PVT.debug_message('Private API: Validate_Ps_Cndclses');
358: END IF;
359:
360: -- Invoke validation procedures
361: Validate_ps_cndclses(

Line 377: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;

373: END IF;
374:
375:
376: -- Debug Message
377: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;
378:
379: -- Invoke table handler(AMS_IBA_PS_CNDCLSES_B_PKG.Update_Row)
380: AMS_IBA_PS_CNDCLSES_B_PKG.Update_Row(
381: p_created_by => FND_GLOBAL.USER_ID,

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

405:
406: -- Debug Message
407: IF (AMS_DEBUG_HIGH_ON) THEN
408:
409: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
410: END IF;
411:
412: -- Standard call to get message count and if count is 1, get message info.
413: FND_MSG_PUB.Count_And_Get

Line 419: WHEN AMS_Utility_PVT.resource_locked THEN

415: p_data => x_msg_data
416: );
417: EXCEPTION
418:
419: WHEN AMS_Utility_PVT.resource_locked THEN
420: x_return_status := FND_API.g_ret_sts_error;
421: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
422:
423: WHEN FND_API.G_EXC_ERROR THEN

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

417: EXCEPTION
418:
419: WHEN AMS_Utility_PVT.resource_locked THEN
420: x_return_status := FND_API.g_ret_sts_error;
421: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
422:
423: WHEN FND_API.G_EXC_ERROR THEN
424: ROLLBACK TO UPDATE_Ps_Cndclses_PVT;
425: x_return_status := FND_API.G_RET_STS_ERROR;

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

498:
499: -- Debug Message
500: IF (AMS_DEBUG_HIGH_ON) THEN
501:
502: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
503: END IF;
504:
505: -- Initialize API return status to SUCCESS
506: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

535: -- Debug Message
536:
537: IF (AMS_DEBUG_HIGH_ON) THEN
538:
539: AMS_UTILITY_PVT.debug_message('Private API: Calling delete table handler');
540:
541: END IF;
542:
543: -- Invoke table handler(AMS_IBA_PS_CNDCLSES_B_PKG.Delete_Row)

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

555:
556: -- Debug Message
557: IF (AMS_DEBUG_HIGH_ON) THEN
558:
559: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
560: END IF;
561:
562: -- Standard call to get message count and if count is 1, get message info.
563: FND_MSG_PUB.Count_And_Get

Line 570: WHEN AMS_Utility_PVT.resource_locked THEN

566: );
567:
568: EXCEPTION
569:
570: WHEN AMS_Utility_PVT.resource_locked THEN
571: x_return_status := FND_API.g_ret_sts_error;
572: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
573:
574: WHEN FND_API.G_EXC_ERROR THEN

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

568: EXCEPTION
569:
570: WHEN AMS_Utility_PVT.resource_locked THEN
571: x_return_status := FND_API.g_ret_sts_error;
572: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
573:
574: WHEN FND_API.G_EXC_ERROR THEN
575: ROLLBACK TO DELETE_Ps_Cndclses_PVT;
576: x_return_status := FND_API.G_RET_STS_ERROR;

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

636: BEGIN
637:
638: -- Debug Message
639: IF (AMS_DEBUG_HIGH_ON) THEN
640: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
641: END IF;
642:
643: -- Initialize message list if p_init_msg_list is set to TRUE.
644: IF FND_API.to_Boolean( p_init_msg_list )

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

661:
662: ------------------------ lock -------------------------
663:
664: IF (AMS_DEBUG_HIGH_ON) THEN
665: AMS_Utility_PVT.debug_message(l_full_name||': start');
666: END IF;
667: OPEN c_Ps_Cndclses;
668:
669: FETCH c_Ps_Cndclses INTO l_CND_CLAUSE_ID;

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

685: p_count => x_msg_count,
686: p_data => x_msg_data);
687: IF (AMS_DEBUG_HIGH_ON) THEN
688:
689: AMS_Utility_PVT.debug_message(l_full_name ||': end');
690: END IF;
691: EXCEPTION
692:
693: WHEN AMS_Utility_PVT.resource_locked THEN

Line 693: WHEN AMS_Utility_PVT.resource_locked THEN

689: AMS_Utility_PVT.debug_message(l_full_name ||': end');
690: END IF;
691: EXCEPTION
692:
693: WHEN AMS_Utility_PVT.resource_locked THEN
694: x_return_status := FND_API.g_ret_sts_error;
695: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
696:
697: WHEN FND_API.G_EXC_ERROR THEN

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

691: EXCEPTION
692:
693: WHEN AMS_Utility_PVT.resource_locked THEN
694: x_return_status := FND_API.g_ret_sts_error;
695: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
696:
697: WHEN FND_API.G_EXC_ERROR THEN
698: ROLLBACK TO LOCK_Ps_Cndclses_PVT;
699: x_return_status := FND_API.G_RET_STS_ERROR;

Line 743: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

739:
740: BEGIN
741: x_return_status := FND_API.g_ret_sts_success;
742: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
743: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
744: 'AMS_IBA_PS_CNDCLSES_B',
745: 'CND_CLAUSE_ID = ''' || p_ps_cndclses_rec.CND_CLAUSE_ID ||''''
746: );
747: ELSE

Line 748: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

744: 'AMS_IBA_PS_CNDCLSES_B',
745: 'CND_CLAUSE_ID = ''' || p_ps_cndclses_rec.CND_CLAUSE_ID ||''''
746: );
747: ELSE
748: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
749: 'AMS_IBA_PS_CNDCLSES_B',
750: 'CND_CLAUSE_ID = ''' || p_ps_cndclses_rec.CND_CLAUSE_ID ||
751: ''' AND CND_CLAUSE_ID <> ' || p_ps_cndclses_rec.CND_CLAUSE_ID
752: );

Line 756: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CND_CLAUSE_ID_DUPLICATE');

752: );
753: END IF;
754:
755: IF l_valid_flag = FND_API.g_false THEN
756: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CND_CLAUSE_ID_DUPLICATE');
757: x_return_status := FND_API.g_ret_sts_error;
758: RETURN;
759: END IF;
760:

Line 776: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_created_by');

772: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
773:
774:
775: IF p_ps_cndclses_rec.created_by = FND_API.g_miss_num OR p_ps_cndclses_rec.created_by IS NULL THEN
776: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_created_by');
777: x_return_status := FND_API.g_ret_sts_error;
778: RETURN;
779: END IF;
780:

Line 783: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_creation_date');

779: END IF;
780:
781:
782: IF p_ps_cndclses_rec.creation_date = FND_API.g_miss_date OR p_ps_cndclses_rec.creation_date IS NULL THEN
783: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_creation_date');
784: x_return_status := FND_API.g_ret_sts_error;
785: RETURN;
786: END IF;
787:

Line 790: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_last_updated_by');

786: END IF;
787:
788:
789: IF p_ps_cndclses_rec.last_updated_by = FND_API.g_miss_num OR p_ps_cndclses_rec.last_updated_by IS NULL THEN
790: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_last_updated_by');
791: x_return_status := FND_API.g_ret_sts_error;
792: RETURN;
793: END IF;
794:

Line 797: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_last_update_date');

793: END IF;
794:
795:
796: IF p_ps_cndclses_rec.last_update_date = FND_API.g_miss_date OR p_ps_cndclses_rec.last_update_date IS NULL THEN
797: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_last_update_date');
798: x_return_status := FND_API.g_ret_sts_error;
799: RETURN;
800: END IF;
801:

Line 804: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_cnd_clause_id');

800: END IF;
801:
802:
803: IF p_ps_cndclses_rec.cnd_clause_id = FND_API.g_miss_num OR p_ps_cndclses_rec.cnd_clause_id IS NULL THEN
804: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_cnd_clause_id');
805: x_return_status := FND_API.g_ret_sts_error;
806: RETURN;
807: END IF;
808: ELSE

Line 812: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_created_by');

808: ELSE
809:
810:
811: IF p_ps_cndclses_rec.created_by IS NULL THEN
812: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_created_by');
813: x_return_status := FND_API.g_ret_sts_error;
814: RETURN;
815: END IF;
816:

Line 819: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_creation_date');

815: END IF;
816:
817:
818: IF p_ps_cndclses_rec.creation_date IS NULL THEN
819: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_creation_date');
820: x_return_status := FND_API.g_ret_sts_error;
821: RETURN;
822: END IF;
823:

Line 826: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_last_updated_by');

822: END IF;
823:
824:
825: IF p_ps_cndclses_rec.last_updated_by IS NULL THEN
826: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_last_updated_by');
827: x_return_status := FND_API.g_ret_sts_error;
828: RETURN;
829: END IF;
830:

Line 833: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_last_update_date');

829: END IF;
830:
831:
832: IF p_ps_cndclses_rec.last_update_date IS NULL THEN
833: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_last_update_date');
834: x_return_status := FND_API.g_ret_sts_error;
835: RETURN;
836: END IF;
837:

Line 840: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_cnd_clause_id');

836: END IF;
837:
838:
839: IF p_ps_cndclses_rec.cnd_clause_id IS NULL THEN
840: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ps_cndclses_NO_cnd_clause_id');
841: x_return_status := FND_API.g_ret_sts_error;
842: RETURN;
843: END IF;
844: END IF;

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

1068:
1069: */
1070: -- Debug Message
1071: IF (AMS_DEBUG_HIGH_ON) THEN
1072: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1073: END IF;
1074:
1075: -- Initialize API return status to SUCCESS
1076: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1076: x_return_status := FND_API.G_RET_STS_SUCCESS;
1077:
1078: -- Debug Message
1079: IF (AMS_DEBUG_HIGH_ON) THEN
1080: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1081: END IF;
1082:
1083: -- Standard call to get message count and if count is 1, get message info.
1084: FND_MSG_PUB.Count_And_Get

Line 1090: WHEN AMS_Utility_PVT.resource_locked THEN

1086: p_data => x_msg_data
1087: );
1088: EXCEPTION
1089:
1090: WHEN AMS_Utility_PVT.resource_locked THEN
1091: x_return_status := FND_API.g_ret_sts_error;
1092: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1093:
1094: WHEN FND_API.G_EXC_ERROR THEN

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

1088: EXCEPTION
1089:
1090: WHEN AMS_Utility_PVT.resource_locked THEN
1091: x_return_status := FND_API.g_ret_sts_error;
1092: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1093:
1094: WHEN FND_API.G_EXC_ERROR THEN
1095: ROLLBACK TO VALIDATE_Ps_Cndclses_;
1096: x_return_status := FND_API.G_RET_STS_ERROR;

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

1153:
1154: -- Debug Message
1155: IF (AMS_DEBUG_HIGH_ON) THEN
1156:
1157: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1158: END IF;
1159: -- Standard call to get message count and if count is 1, get message info.
1160: FND_MSG_PUB.Count_And_Get
1161: (p_count => x_msg_count,