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

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

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

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

127:
128:
129: IF FND_GLOBAL.User_Id IS NULL
130: THEN
131: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 140: AMS_UTILITY_PVT.debug_message('Private API: Validate_Rule_Group');

136: THEN
137: -- Debug message
138: IF (AMS_DEBUG_HIGH_ON) THEN
139:
140: AMS_UTILITY_PVT.debug_message('Private API: Validate_Rule_Group');
141: END IF;
142:
143: -- Invoke validation procedures
144: Validate_rule_group(

Line 161: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create for Rule');

157: /*
158: -- Debug Message
159: IF (AMS_DEBUG_HIGH_ON) THEN
160:
161: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create for Rule');
162: END IF;
163:
164: l_ps_rules_rec.rulegroup_id := l_rulegroup_id;
165: l_ps_rules_rec.posting_id := p_rule_group_rec.posting_id;

Line 220: AMS_UTILITY_PVT.debug_message( 'Private API: Created Rule');

216:
217: -- Debug Message
218: IF (AMS_DEBUG_HIGH_ON) THEN
219:
220: AMS_UTILITY_PVT.debug_message( 'Private API: Created Rule');
221: END IF;
222: */
223:
224: -- Debug Message

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

223:
224: -- Debug Message
225: IF (AMS_DEBUG_HIGH_ON) THEN
226:
227: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
228: END IF;
229:
230: -- Invoke table handler(AMS_IBA_PS_RULEGRPS_B_PKG.Insert_Row)
231: AMS_IBA_PS_RULEGRPS_B_PKG.Insert_Row(

Line 255: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create for Rule');

251:
252: -- Debug Message
253: IF (AMS_DEBUG_HIGH_ON) THEN
254:
255: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create for Rule');
256: END IF;
257:
258: l_ps_rules_rec.rulegroup_id := l_rulegroup_id;
259: l_ps_rules_rec.posting_id := p_rule_group_rec.posting_id;

Line 314: AMS_UTILITY_PVT.debug_message( 'Private API: Created Rule');

310:
311: -- Debug Message
312: IF (AMS_DEBUG_HIGH_ON) THEN
313:
314: AMS_UTILITY_PVT.debug_message( 'Private API: Created Rule');
315: END IF;
316:
317: -- Standard check for p_commit
318: IF FND_API.to_Boolean( p_commit )

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

324:
325: -- Debug Message
326: IF (AMS_DEBUG_HIGH_ON) THEN
327:
328: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
329: END IF;
330:
331: -- Standard call to get message count and if count is 1, get message info.
332: FND_MSG_PUB.Count_And_Get

Line 339: WHEN AMS_Utility_PVT.resource_locked THEN

335: );
336:
337: EXCEPTION
338:
339: WHEN AMS_Utility_PVT.resource_locked THEN
340: x_return_status := FND_API.g_ret_sts_error;
341: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
342:
343: WHEN FND_API.G_EXC_ERROR THEN

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

337: EXCEPTION
338:
339: WHEN AMS_Utility_PVT.resource_locked THEN
340: x_return_status := FND_API.g_ret_sts_error;
341: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
342:
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO CREATE_Rule_Group_PVT;
345: x_return_status := FND_API.G_RET_STS_ERROR;

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

428:
429: -- Debug Message
430: IF (AMS_DEBUG_HIGH_ON) THEN
431:
432: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
433: END IF;
434:
435:
436: -- Initialize API return status to SUCCESS

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

458:
459: -- Debug Message
460: IF (AMS_DEBUG_HIGH_ON) THEN
461:
462: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
463: END IF;
464:
465: OPEN c_object_version(p_rule_group_rec.rulegroup_id);
466:

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

466:
467: FETCH c_object_version INTO l_object_version;
468:
469: If ( c_object_version%NOTFOUND) THEN
470: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
471: p_token_name => 'INFO',
472: p_token_value => 'Rulegroup') ;
473: RAISE FND_API.G_EXC_ERROR;
474: END IF;

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

474: END IF;
475: -- Debug Message
476: IF (AMS_DEBUG_HIGH_ON) THEN
477:
478: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
479: END IF;
480: CLOSE c_object_version;
481:
482: IF (p_rule_group_rec.object_version_number is NULL or

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

480: CLOSE c_object_version;
481:
482: IF (p_rule_group_rec.object_version_number is NULL or
483: p_rule_group_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
484: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
485: p_token_name => 'COLUMN',
486: p_token_value => 'object_version_number') ;
487: raise FND_API.G_EXC_ERROR;
488: END IF;

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

488: END IF;
489:
490: -- Check Whether record has been changed by someone else
491: IF (p_rule_group_rec.object_version_number <> l_object_version) THEN
492: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
493: p_token_name => 'INFO',
494: p_token_value => 'Rulegroup') ;
495: raise FND_API.G_EXC_ERROR;
496: END IF;

Line 503: AMS_UTILITY_PVT.debug_message('Private API: Validate_Rule_Group');

499: THEN
500: -- Debug message
501: IF (AMS_DEBUG_HIGH_ON) THEN
502:
503: AMS_UTILITY_PVT.debug_message('Private API: Validate_Rule_Group');
504: END IF;
505:
506: -- Invoke validation procedures
507: Validate_rule_group(

Line 525: AMS_UTILITY_PVT.debug_message('Checking Strategy Type');

521:
522: -- Debug Message
523: IF (AMS_DEBUG_HIGH_ON) THEN
524:
525: AMS_UTILITY_PVT.debug_message('Checking Strategy Type');
526: END IF;
527:
528: IF (AMS_DEBUG_HIGH_ON) THEN
529:

Line 532: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor');

528: IF (AMS_DEBUG_HIGH_ON) THEN
529:
530:
531:
532: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor');
533:
534: END IF;
535:
536: OPEN c_strategy_type(p_rule_group_rec.rulegroup_id);

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

537:
538: FETCH c_strategy_type INTO l_strategy_type;
539:
540: If ( c_strategy_type%NOTFOUND) THEN
541: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
542: p_token_name => 'INFO',
543: p_token_value => 'Rulegroup') ;
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;

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

544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546: IF (AMS_DEBUG_HIGH_ON) THEN
547:
548: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
549: END IF;
550: CLOSE c_strategy_type;
551:
552: IF (l_strategy_type <> p_rule_group_rec.strategy_type) THEN

Line 555: AMS_UTILITY_PVT.debug_message('Deleting all old Strategy entries');

551:
552: IF (l_strategy_type <> p_rule_group_rec.strategy_type) THEN
553: IF (AMS_DEBUG_HIGH_ON) THEN
554:
555: AMS_UTILITY_PVT.debug_message('Deleting all old Strategy entries');
556: END IF;
557:
558: UPDATE AMS_IBA_PS_RULES SET
559: bus_priority_code = null,

Line 574: AMS_UTILITY_PVT.debug_message('Trying to update B and TL tables for rulegrp and rules');

570: IF (AMS_DEBUG_HIGH_ON) THEN
571:
572:
573:
574: AMS_UTILITY_PVT.debug_message('Trying to update B and TL tables for rulegrp and rules');
575:
576: END IF;
577:
578: Update AMS_IBA_PS_RULEGRPS_B

Line 616: AMS_UTILITY_PVT.debug_message('Private API: Updated B');

612:
613: IF (AMS_DEBUG_HIGH_ON) THEN
614:
615:
616: AMS_UTILITY_PVT.debug_message('Private API: Updated B');
617:
618: END IF;
619:
620: UPDATE AMS_IBA_PS_RULEGRPS_TL

Line 643: AMS_UTILITY_PVT.debug_message('Private API: Updated TL');

639: IF (AMS_DEBUG_HIGH_ON) THEN
640:
641:
642:
643: AMS_UTILITY_PVT.debug_message('Private API: Updated TL');
644:
645: END IF;
646:
647: --

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

657:
658: -- Debug Message
659: IF (AMS_DEBUG_HIGH_ON) THEN
660:
661: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
662: END IF;
663:
664: -- Standard call to get message count and if count is 1, get message info.
665: FND_MSG_PUB.Count_And_Get

Line 671: WHEN AMS_Utility_PVT.resource_locked THEN

667: p_data => x_msg_data
668: );
669: EXCEPTION
670:
671: WHEN AMS_Utility_PVT.resource_locked THEN
672: x_return_status := FND_API.g_ret_sts_error;
673: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
674:
675: WHEN FND_API.G_EXC_ERROR THEN

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

669: EXCEPTION
670:
671: WHEN AMS_Utility_PVT.resource_locked THEN
672: x_return_status := FND_API.g_ret_sts_error;
673: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
674:
675: WHEN FND_API.G_EXC_ERROR THEN
676: ROLLBACK TO UPDATE_Rule_Group_PVT;
677: x_return_status := FND_API.G_RET_STS_ERROR;

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

746:
747: -- Debug Message
748: IF (AMS_DEBUG_HIGH_ON) THEN
749:
750: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
751: END IF;
752:
753:
754: -- Initialize API return status to SUCCESS

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

759: --
760: -- Debug Message
761: IF (AMS_DEBUG_HIGH_ON) THEN
762:
763: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
764: END IF;
765:
766: -- Invoke table handler(AMS_IBA_PS_RULEGRPS_B_PKG.Delete_Row)
767: AMS_IBA_PS_RULEGRPS_B_PKG.Delete_Row(

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

779:
780: -- Debug Message
781: IF (AMS_DEBUG_HIGH_ON) THEN
782:
783: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
784: END IF;
785:
786: -- Standard call to get message count and if count is 1, get message info.
787: FND_MSG_PUB.Count_And_Get

Line 793: WHEN AMS_Utility_PVT.resource_locked THEN

789: p_data => x_msg_data
790: );
791: EXCEPTION
792:
793: WHEN AMS_Utility_PVT.resource_locked THEN
794: x_return_status := FND_API.g_ret_sts_error;
795: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
796:
797: WHEN FND_API.G_EXC_ERROR THEN

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

791: EXCEPTION
792:
793: WHEN AMS_Utility_PVT.resource_locked THEN
794: x_return_status := FND_API.g_ret_sts_error;
795: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
796:
797: WHEN FND_API.G_EXC_ERROR THEN
798: ROLLBACK TO DELETE_Rule_Group_PVT;
799: x_return_status := FND_API.G_RET_STS_ERROR;

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

861:
862: -- Debug Message
863: IF (AMS_DEBUG_HIGH_ON) THEN
864:
865: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
866: END IF;
867:
868: -- Initialize message list if p_init_msg_list is set to TRUE.
869: IF FND_API.to_Boolean( p_init_msg_list )

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

890: IF (AMS_DEBUG_HIGH_ON) THEN
891:
892:
893:
894: AMS_Utility_PVT.debug_message(l_full_name||': start');
895:
896: END IF;
897: OPEN c_Rule_Group;
898:

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

915: p_count => x_msg_count,
916: p_data => x_msg_data);
917: IF (AMS_DEBUG_HIGH_ON) THEN
918:
919: AMS_Utility_PVT.debug_message(l_full_name ||': end');
920: END IF;
921: EXCEPTION
922:
923: WHEN AMS_Utility_PVT.resource_locked THEN

Line 923: WHEN AMS_Utility_PVT.resource_locked THEN

919: AMS_Utility_PVT.debug_message(l_full_name ||': end');
920: END IF;
921: EXCEPTION
922:
923: WHEN AMS_Utility_PVT.resource_locked THEN
924: x_return_status := FND_API.g_ret_sts_error;
925: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
926:
927: WHEN FND_API.G_EXC_ERROR THEN

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

921: EXCEPTION
922:
923: WHEN AMS_Utility_PVT.resource_locked THEN
924: x_return_status := FND_API.g_ret_sts_error;
925: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
926:
927: WHEN FND_API.G_EXC_ERROR THEN
928: ROLLBACK TO LOCK_Rule_Group_PVT;
929: x_return_status := FND_API.G_RET_STS_ERROR;

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

1136:
1137: -- Debug Message
1138: IF (AMS_DEBUG_HIGH_ON) THEN
1139:
1140: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1141: END IF;
1142:
1143:
1144: -- Initialize API return status to SUCCESS

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

1147:
1148: -- Debug Message
1149: IF (AMS_DEBUG_HIGH_ON) THEN
1150:
1151: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1152: END IF;
1153:
1154: -- Standard call to get message count and if count is 1, get message info.
1155: FND_MSG_PUB.Count_And_Get

Line 1161: WHEN AMS_Utility_PVT.resource_locked THEN

1157: p_data => x_msg_data
1158: );
1159: EXCEPTION
1160:
1161: WHEN AMS_Utility_PVT.resource_locked THEN
1162: x_return_status := FND_API.g_ret_sts_error;
1163: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1164:
1165: WHEN FND_API.G_EXC_ERROR THEN

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

1159: EXCEPTION
1160:
1161: WHEN AMS_Utility_PVT.resource_locked THEN
1162: x_return_status := FND_API.g_ret_sts_error;
1163: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1164:
1165: WHEN FND_API.G_EXC_ERROR THEN
1166: ROLLBACK TO VALIDATE_Rule_Group_;
1167: x_return_status := FND_API.G_RET_STS_ERROR;

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

1224:
1225: -- Debug Message
1226: IF (AMS_DEBUG_HIGH_ON) THEN
1227:
1228: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1229: END IF;
1230: -- Standard call to get message count and if count is 1, get message info.
1231: FND_MSG_PUB.Count_And_Get
1232: (p_count => x_msg_count,