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

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

120: IF (AMS_DEBUG_HIGH_ON) THEN
121:
122:
123:
124: AMS_Utility_PVT.debug_message(l_full_name||': start');
125:
126: END IF;
127:
128: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 161: AMS_Utility_PVT.debug_message(l_full_name ||': Update Trigger');

157: IF (AMS_DEBUG_HIGH_ON) THEN
158:
159:
160:
161: AMS_Utility_PVT.debug_message(l_full_name ||': Update Trigger');
162:
163: END IF;
164:
165:

Line 198: AMS_Utility_PVT.debug_message(l_full_name ||'CG : Create Trigger Check' || 'Trigger type = ' || p_trig_rec.triggering_type);

194:
195:
196: l_thldchk_rec.trigger_id := x_trigger_id;
197: IF (AMS_DEBUG_HIGH_ON) THEN
198: AMS_Utility_PVT.debug_message(l_full_name ||'CG : Create Trigger Check' || 'Trigger type = ' || p_trig_rec.triggering_type);
199: END IF;
200:
201: IF ( p_trig_rec.triggering_type <> 'DATE' ) THEN
202: AMS_THLDCHK_PVT.Create_thldchk

Line 232: AMS_Utility_PVT.debug_message(l_full_name ||': Create Trigger Actions');

228: -- 22/apr/03 cgoyal uncommented the Create Trigger Actions code for 11.5.8 backport
229: --=================================================================================
230:
231: IF (AMS_DEBUG_HIGH_ON) THEN
232: AMS_Utility_PVT.debug_message(l_full_name ||': Create Trigger Actions');
233: END IF;
234:
235: IF (p_trig_Rec.notify_flag = 'Y')
236: THEN

Line 303: AMS_Utility_PVT.debug_message(l_full_name ||': before calling initialize var');

299: -- raise an event with send date as the trigger start date
300:
301: l_parameter_list := WF_PARAMETER_LIST_T();
302:
303: AMS_Utility_PVT.debug_message(l_full_name ||': before calling initialize var');
304:
305: -- AMS_WFTrig_PVT.Initialize_Var( p_trigger_id => x_trigger_id
306: -- , x_param_list => l_parameter_list);
307:

Line 313: AMS_Utility_PVT.debug_message(l_full_name ||': after calling initialize var');

309: wf_event.AddParameterToList(p_name => 'AMS_TRIGGER_ID',
310: p_value => x_trigger_id,
311: p_parameterlist => l_parameter_list);
312:
313: AMS_Utility_PVT.debug_message(l_full_name ||': after calling initialize var');
314:
315: l_new_item_key := x_trigger_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
316:
317: -- soagrawa added on 09-jul-2003 for bug 3043277

Line 322: AMS_Utility_PVT.Create_Log (

318: OPEN c_st_dt(x_trigger_id);
319: FETCH c_st_dt INTO l_st_dt;
320: CLOSE c_st_dt;
321:
322: AMS_Utility_PVT.Create_Log (
323: x_return_status => x_msg_data,
324: p_arc_log_used_by => 'TRIG',
325: p_log_used_by_id => x_trigger_id,
326: -- soagrawa modified on 09-jul-2003 for bug 3043277

Line 340: AMS_Utility_PVT.debug_message(l_full_name ||': raised WF event');

336: -- soagrawa modified on 09-jul-2003 for bug 3043277
337: -- p_send_date => p_trig_rec.start_date_time);
338: p_send_date => l_st_dt);
339:
340: AMS_Utility_PVT.debug_message(l_full_name ||': raised WF event');
341:
342: AMS_Utility_PVT.Create_Log (
343: x_return_status => x_msg_data,
344: p_arc_log_used_by => 'TRIG',

Line 342: AMS_Utility_PVT.Create_Log (

338: p_send_date => l_st_dt);
339:
340: AMS_Utility_PVT.debug_message(l_full_name ||': raised WF event');
341:
342: AMS_Utility_PVT.Create_Log (
343: x_return_status => x_msg_data,
344: p_arc_log_used_by => 'TRIG',
345: p_log_used_by_id => x_trigger_id,
346: -- soagrawa modified on 09-jul-2003 for bug 3043277

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

377: IF (AMS_DEBUG_HIGH_ON) THEN
378:
379:
380:
381: AMS_Utility_PVT.debug_message(l_full_name ||': end');
382:
383: END IF;
384:
385: EXCEPTION

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

501: -- Debug Message
502: --
503: IF (AMS_DEBUG_HIGH_ON) THEN
504:
505: AMS_Utility_PVT.debug_message(l_full_name||': start');
506: END IF;
507:
508: --
509: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 536: AMS_Utility_PVT.debug_message(l_full_name||': Update Trigger');

532: -- API body
533: --
534: /*
535: IF (AMS_DEBUG_HIGH_ON) THEN
536: AMS_Utility_PVT.debug_message(l_full_name||': Update Trigger');
537: END IF;
538: -- following code added by soagrawa for update modification on 04/18/2001
539: OPEN c_trig_process_id(p_trig_rec.trigger_id);
540: FETCH c_trig_process_id INTO l_trigger_process_id;

Line 567: AMS_Utility_PVT.debug_message(l_full_name ||': Create Trigger Check');

563: --
564: */
565:
566: IF (AMS_DEBUG_HIGH_ON) THEN
567: AMS_Utility_PVT.debug_message(l_full_name ||': Create Trigger Check');
568: END IF;
569:
570: IF ( p_trig_rec.triggering_type <> 'DATE' )
571: THEN

Line 648: AMS_Utility_PVT.debug_message(l_full_name ||': Create Trigger Actions');

644: -- 22/apr/03 cgoyal uncommented the Update Trigger Actions code for 11.5.8 backport
645: --=================================================================================
646:
647: IF (AMS_DEBUG_HIGH_ON) THEN
648: AMS_Utility_PVT.debug_message(l_full_name ||': Create Trigger Actions');
649: END IF;
650:
651: OPEN c_trig_actions_det(p_trig_rec.trigger_id);
652: FETCH c_trig_actions_det INTO l_notify_flag, l_execute_schedule_flag;

Line 664: AMS_Utility_PVT.debug_message(l_full_name ||'l_notify_flag: '||l_notify_flag);

660: END IF;
661: CLOSE c_trig_actions_det;
662:
663: IF (AMS_DEBUG_HIGH_ON) THEN
664: AMS_Utility_PVT.debug_message(l_full_name ||'l_notify_flag: '||l_notify_flag);
665: AMS_Utility_PVT.debug_message(l_full_name ||'l_execute_schedule_flag: '||l_execute_schedule_flag);
666: AMS_Utility_PVT.debug_message(l_full_name ||'p_trig_rec.notify_flag: '||p_trig_rec.notify_flag);
667: AMS_Utility_PVT.debug_message(l_full_name ||'p_trig_rec.EXECUTE_SCHEDULE_FLAG : '||p_trig_rec.EXECUTE_SCHEDULE_FLAG );
668: END IF;

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

661: CLOSE c_trig_actions_det;
662:
663: IF (AMS_DEBUG_HIGH_ON) THEN
664: AMS_Utility_PVT.debug_message(l_full_name ||'l_notify_flag: '||l_notify_flag);
665: AMS_Utility_PVT.debug_message(l_full_name ||'l_execute_schedule_flag: '||l_execute_schedule_flag);
666: AMS_Utility_PVT.debug_message(l_full_name ||'p_trig_rec.notify_flag: '||p_trig_rec.notify_flag);
667: AMS_Utility_PVT.debug_message(l_full_name ||'p_trig_rec.EXECUTE_SCHEDULE_FLAG : '||p_trig_rec.EXECUTE_SCHEDULE_FLAG );
668: END IF;
669:

Line 666: AMS_Utility_PVT.debug_message(l_full_name ||'p_trig_rec.notify_flag: '||p_trig_rec.notify_flag);

662:
663: IF (AMS_DEBUG_HIGH_ON) THEN
664: AMS_Utility_PVT.debug_message(l_full_name ||'l_notify_flag: '||l_notify_flag);
665: AMS_Utility_PVT.debug_message(l_full_name ||'l_execute_schedule_flag: '||l_execute_schedule_flag);
666: AMS_Utility_PVT.debug_message(l_full_name ||'p_trig_rec.notify_flag: '||p_trig_rec.notify_flag);
667: AMS_Utility_PVT.debug_message(l_full_name ||'p_trig_rec.EXECUTE_SCHEDULE_FLAG : '||p_trig_rec.EXECUTE_SCHEDULE_FLAG );
668: END IF;
669:
670: /* ----------------------- NOTIFICATION ACTION ------------------------------------- */

Line 667: AMS_Utility_PVT.debug_message(l_full_name ||'p_trig_rec.EXECUTE_SCHEDULE_FLAG : '||p_trig_rec.EXECUTE_SCHEDULE_FLAG );

663: IF (AMS_DEBUG_HIGH_ON) THEN
664: AMS_Utility_PVT.debug_message(l_full_name ||'l_notify_flag: '||l_notify_flag);
665: AMS_Utility_PVT.debug_message(l_full_name ||'l_execute_schedule_flag: '||l_execute_schedule_flag);
666: AMS_Utility_PVT.debug_message(l_full_name ||'p_trig_rec.notify_flag: '||p_trig_rec.notify_flag);
667: AMS_Utility_PVT.debug_message(l_full_name ||'p_trig_rec.EXECUTE_SCHEDULE_FLAG : '||p_trig_rec.EXECUTE_SCHEDULE_FLAG );
668: END IF;
669:
670: /* ----------------------- NOTIFICATION ACTION ------------------------------------- */
671:

Line 676: AMS_Utility_PVT.debug_message(l_full_name ||': Case 1');

672: -- notify flag action didnt change => update
673: IF (p_trig_rec.notify_flag = 'Y' AND l_notify_flag = 'Y')
674: THEN
675:
676: AMS_Utility_PVT.debug_message(l_full_name ||': Case 1');
677:
678: OPEN c_actions_det(p_trig_rec.trigger_id, 'NOTIFY');
679: FETCH c_actions_det INTO l_trig_action_id, l_object_version_number;
680: IF (c_actions_det%NOTFOUND) THEN

Line 718: AMS_Utility_PVT.debug_message(l_full_name ||': Case 2');

714:
715: -- notify flag action was added => create
716: IF (p_trig_rec.notify_flag = 'Y' AND l_notify_flag = 'N')
717: THEN
718: AMS_Utility_PVT.debug_message(l_full_name ||': Case 2');
719: l_thldact_rec.trigger_id := p_trig_rec.trigger_id;
720: l_thldact_rec.trigger_action_id := null;
721: l_thldact_rec.execute_action_type := 'NOTIFY';
722:

Line 747: AMS_Utility_PVT.debug_message(l_full_name ||': Case 3');

743:
744: -- notify flag action was removed => delete
745: IF (p_trig_rec.notify_flag = 'N' AND l_notify_flag = 'Y')
746: THEN
747: AMS_Utility_PVT.debug_message(l_full_name ||': Case 3');
748: OPEN c_actions_det(p_trig_rec.trigger_id, 'NOTIFY');
749: FETCH c_actions_det INTO l_trig_action_id, l_object_version_number;
750: IF (c_actions_det%NOTFOUND) THEN
751: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 786: AMS_Utility_PVT.debug_message(l_full_name ||': Case 4');

782:
783: -- EXECUTE_SCHEDULE_FLAG action didnt change => update
784: IF (p_trig_rec.EXECUTE_SCHEDULE_FLAG = 'Y' AND l_execute_schedule_flag = 'Y')
785: THEN
786: AMS_Utility_PVT.debug_message(l_full_name ||': Case 4');
787: NULL;
788: -- nothing to update
789: /*
790: OPEN c_actions_det(p_trig_rec.trigger_id, 'EXECUTE');

Line 830: AMS_Utility_PVT.debug_message(l_full_name ||': Case 5');

826:
827: -- EXECUTE_SCHEDULE_FLAG action was added => create
828: IF (p_trig_rec.EXECUTE_SCHEDULE_FLAG = 'Y' AND l_execute_schedule_flag = 'N')
829: THEN
830: AMS_Utility_PVT.debug_message(l_full_name ||': Case 5');
831: l_thldact_rec.trigger_id := p_trig_rec.trigger_id;
832: l_thldact_rec.trigger_action_id := null;
833: l_thldact_rec.execute_action_type := 'EXECUTE';
834: l_thldact_rec.action_for_id := null;

Line 860: AMS_Utility_PVT.debug_message(l_full_name ||': Case 6');

856:
857: -- EXECUTE_SCHEDULE_FLAG action was removed => delete
858: IF (p_trig_rec.EXECUTE_SCHEDULE_FLAG = 'N' AND l_execute_schedule_flag = 'Y')
859: THEN
860: AMS_Utility_PVT.debug_message(l_full_name ||': Case 6');
861: OPEN c_actions_det(p_trig_rec.trigger_id, 'EXECUTE');
862: FETCH c_actions_det INTO l_trig_action_id, l_object_version_number;
863: IF (c_actions_det%NOTFOUND) THEN
864: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 898: AMS_Utility_PVT.debug_message(l_full_name||': Update Trigger');

894: /* ------------------- update trigger now ---------------------- */
895: -- moved to later by soagrawa 30-apr-2003
896:
897: IF (AMS_DEBUG_HIGH_ON) THEN
898: AMS_Utility_PVT.debug_message(l_full_name||': Update Trigger');
899: END IF;
900:
901:
902: -- following code added by soagrawa for update modification on 04/18/2001

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

955: );
956:
957:
958: IF (AMS_DEBUG_HIGH_ON) THEN
959: AMS_Utility_PVT.debug_message(l_full_name ||': end');
960: END IF;
961:
962: EXCEPTION
963: WHEN FND_API.G_EXC_ERROR THEN

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

1046: -- Standard Start of API savepoint
1047: SAVEPOINT Activate_Trig_PVT;
1048:
1049: IF (AMS_DEBUG_HIGH_ON) THEN
1050: AMS_Utility_PVT.debug_message(l_full_name||': start');
1051: END IF;
1052:
1053: IF FND_API.to_boolean(p_init_msg_list) THEN
1054: FND_MSG_PUB.initialize;

Line 1072: AMS_Utility_PVT.debug_message(l_full_name ||': Activate Trigger');

1068:
1069: -- API body
1070:
1071: IF (AMS_DEBUG_HIGH_ON) THEN
1072: AMS_Utility_PVT.debug_message(l_full_name ||': Activate Trigger');
1073: END IF;
1074:
1075: -- Give Call to Trigger Engine here
1076: l_parameter_list := WF_PARAMETER_LIST_T();

Line 1078: AMS_Utility_PVT.debug_message(l_full_name ||': before calling Activate');

1074:
1075: -- Give Call to Trigger Engine here
1076: l_parameter_list := WF_PARAMETER_LIST_T();
1077:
1078: AMS_Utility_PVT.debug_message(l_full_name ||': before calling Activate');
1079:
1080: wf_event.AddParameterToList(p_name => 'AMS_TRIGGER_ID',
1081: p_value => p_trigger_id,
1082: p_parameterlist => l_parameter_list);

Line 1084: AMS_Utility_PVT.debug_message(l_full_name ||': after AddParameterToList');

1080: wf_event.AddParameterToList(p_name => 'AMS_TRIGGER_ID',
1081: p_value => p_trigger_id,
1082: p_parameterlist => l_parameter_list);
1083:
1084: AMS_Utility_PVT.debug_message(l_full_name ||': after AddParameterToList');
1085:
1086: l_new_item_key := p_trigger_id || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
1087:
1088: OPEN c_st_dt(p_trigger_id);

Line 1096: AMS_UTILITY_PVT.Convert_Timezone(

1092: -- if start_date_time is in past, reset it to current date time.
1093: IF l_st_dt < SYSDATE THEN
1094: l_st_dt := SYSDATE;
1095: -- get the user date for current time.
1096: AMS_UTILITY_PVT.Convert_Timezone(
1097: p_init_msg_list => p_init_msg_list
1098: , x_return_status => x_return_status
1099: , x_msg_count => x_msg_count
1100: , x_msg_data => x_msg_data

Line 1108: AMS_Utility_PVT.Create_Log (

1104: , x_out_time => l_user_st_dt
1105: );
1106: END IF;
1107:
1108: AMS_Utility_PVT.Create_Log (
1109: x_return_status => x_msg_data,
1110: p_arc_log_used_by => 'TRIG',
1111: p_log_used_by_id => p_trigger_id,
1112: p_msg_data => 'Activate_Trigger : 1. For Trigger ID = ' || p_trigger_id || ' l_new_item_key = ' || l_new_item_key || 'event send date ' || l_st_dt,

Line 1122: AMS_Utility_PVT.debug_message(l_full_name ||': raised WF event');

1118: p_event_key => l_new_item_key,
1119: p_parameters => l_parameter_list,
1120: p_send_date => l_st_dt);
1121:
1122: AMS_Utility_PVT.debug_message(l_full_name ||': raised WF event');
1123:
1124: AMS_Utility_PVT.Create_Log (
1125: x_return_status => x_msg_data,
1126: p_arc_log_used_by => 'TRIG',

Line 1124: AMS_Utility_PVT.Create_Log (

1120: p_send_date => l_st_dt);
1121:
1122: AMS_Utility_PVT.debug_message(l_full_name ||': raised WF event');
1123:
1124: AMS_Utility_PVT.Create_Log (
1125: x_return_status => x_msg_data,
1126: p_arc_log_used_by => 'TRIG',
1127: p_log_used_by_id => p_trigger_id,
1128: p_msg_data => 'Activate_Trigger : raised with send date '||to_char(l_st_dt,'DD-MM-YYYY HH:MI:SS AM'),

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

1150: p_encoded => FND_API.G_FALSE
1151: );
1152:
1153: IF (AMS_DEBUG_HIGH_ON) THEN
1154: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1155: END IF;
1156:
1157: EXCEPTION
1158: WHEN FND_API.G_EXC_ERROR THEN