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_SCHEDULERULES_PVT dependencies on AMS_SCHEDULER

Line 1: PACKAGE BODY AMS_ScheduleRules_PVT AS

1: PACKAGE BODY AMS_ScheduleRules_PVT AS
2: /* $Header: amsvsbrb.pls 120.35 2011/09/06 05:22:25 annsrini ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30):='AMS_ScheduleRules_PVT';

Line 5: g_pkg_name CONSTANT VARCHAR2(30):='AMS_ScheduleRules_PVT';

1: PACKAGE BODY AMS_ScheduleRules_PVT AS
2: /* $Header: amsvsbrb.pls 120.35 2011/09/06 05:22:25 annsrini ship $ */
3:
4:
5: g_pkg_name CONSTANT VARCHAR2(30):='AMS_ScheduleRules_PVT';
6: g_log_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: --========================================================================
8: -- FUNCTION
9: -- Target_Group_Exist

Line 121: AMS_ScheduleRules_PVT.collateral_activation_rule(

117:
118: -- Initialize API return status to SUCCESS
119: x_status_code := FND_API.G_RET_STS_SUCCESS;
120:
121: AMS_ScheduleRules_PVT.collateral_activation_rule(
122: p_scheduleid => p_scheduleid,
123: x_status_code => l_return_status,
124: x_msg_count => l_msg_count,
125: x_msg_data => l_msg_data) ;

Line 5055: ams_scheduler scheduler,

5051: parentCSCH.start_date_time,
5052: parentCSCH.end_date_time,
5053: parentCSCH.status_code
5054: FROM ams_campaign_schedules_vl csch,
5055: ams_scheduler scheduler,
5056: ams_campaigns_all_b camp,
5057: ams_campaign_Schedules_b parentCSCH
5058: WHERE csch.schedule_id = p_schedule_id
5059: AND scheduler.OBJECT_ID = nvl(csch.orig_csch_id, csch.schedule_id)

Line 5222: aname => 'AMS_SCHEDULER_FREQUENCY',

5218: avalue => l_csch_orig_id);
5219:
5220: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
5221: itemkey => itemkey,
5222: aname => 'AMS_SCHEDULER_FREQUENCY',
5223: avalue => l_sched_freq);
5224:
5225: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5226: itemkey => itemkey,

Line 5227: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE',

5223: avalue => l_sched_freq);
5224:
5225: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5226: itemkey => itemkey,
5227: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE',
5228: avalue => l_sched_freq_type);
5229:
5230: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5231: itemkey => itemkey,

Line 5258: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE',

5254:
5255:
5256: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5257: itemkey => itemkey ,
5258: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE',
5259: avalue => l_schedule_next_run_st_date);
5260:
5261: END IF;
5262:

Line 5451: aname => 'AMS_SCHEDULER_FREQUENCY');

5447:
5448: l_scheduler_frequency := WF_ENGINE.GetItemAttrNumber(
5449: itemtype => itemtype,
5450: itemkey => itemkey ,
5451: aname => 'AMS_SCHEDULER_FREQUENCY');
5452:
5453: l_scheduler_frequency_type := WF_ENGINE.GetItemAttrText(
5454: itemtype => itemtype,
5455: itemkey => itemkey ,

Line 5456: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');

5452:
5453: l_scheduler_frequency_type := WF_ENGINE.GetItemAttrText(
5454: itemtype => itemtype,
5455: itemkey => itemkey ,
5456: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');
5457:
5458: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Calling AMS_SCHEDULER_PVT.Schedule_Repeat with freq type ' ||l_scheduler_frequency_type);
5459:
5460:

Line 5458: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Calling AMS_SCHEDULER_PVT.Schedule_Repeat with freq type ' ||l_scheduler_frequency_type);

5454: itemtype => itemtype,
5455: itemkey => itemkey ,
5456: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');
5457:
5458: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Calling AMS_SCHEDULER_PVT.Schedule_Repeat with freq type ' ||l_scheduler_frequency_type);
5459:
5460:
5461: l_new_last_run_date := WF_ENGINE.GetItemAttrDate(
5462: itemtype => itemtype,

Line 5464: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');

5460:
5461: l_new_last_run_date := WF_ENGINE.GetItemAttrDate(
5462: itemtype => itemtype,
5463: itemkey => itemkey ,
5464: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');
5465:
5466:
5467:
5468: SELECT nvl(orig_csch_id, schedule_id)

Line 5485: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Calling AMS_SCHEDULER_PVT.Schedule_Repeat with freq type ' ||l_scheduler_frequency_type||'; For Schedule Id: '||l_schedule_id);

5481:
5482: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Schedule_Repeat returned last run date from the WF Engine : '||to_char(l_new_last_run_date,'DD-MON-RRRR HH24:MI:SS')||'; For Schedule Id: '||l_schedule_id);
5483:
5484:
5485: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Calling AMS_SCHEDULER_PVT.Schedule_Repeat with freq type ' ||l_scheduler_frequency_type||'; For Schedule Id: '||l_schedule_id);
5486:
5487:
5488: AMS_SCHEDULER_PVT.Schedule_Repeat (
5489: p_last_run_date => l_new_last_run_date,

Line 5488: AMS_SCHEDULER_PVT.Schedule_Repeat (

5484:
5485: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Calling AMS_SCHEDULER_PVT.Schedule_Repeat with freq type ' ||l_scheduler_frequency_type||'; For Schedule Id: '||l_schedule_id);
5486:
5487:
5488: AMS_SCHEDULER_PVT.Schedule_Repeat (
5489: p_last_run_date => l_new_last_run_date,
5490: p_frequency => l_scheduler_frequency,
5491: p_frequency_type => l_scheduler_frequency_type,
5492: x_next_run_date => l_scheduler_next_run_date,

Line 5505: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE',

5501: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Schedule_Repeat returned next run date is : '||to_char(l_scheduler_next_run_date,'DD-MON-RRRR HH24:MI:SS')||' Schedule Id is : '||l_schedule_id);
5502:
5503: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5504: itemkey => itemkey ,
5505: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE',
5506: avalue => l_scheduler_next_run_date);
5507:
5508: result := 'COMPLETE:SUCCESS' ;
5509: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS

Line 5519: p_wf_err_attrib => 'AMS_SCHEDULER_ERROR_MSG');

5515: Handle_Error(p_itemtype => itemtype,
5516: p_itemkey => itemkey,
5517: p_msg_count => l_msg_count,
5518: p_msg_data => l_msg_data,
5519: p_wf_err_attrib => 'AMS_SCHEDULER_ERROR_MSG');
5520:
5521: WRITE_LOG(l_api_name, 'Error in scheduling next run start date caught for schedule id: '||l_schedule_id);
5522: result := 'COMPLETE:ERROR' ;
5523:

Line 5583: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');

5579:
5580: l_schedule_next_run_date := WF_ENGINE.GetItemAttrDate(
5581: itemtype => itemtype,
5582: itemkey => itemkey ,
5583: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');
5584:
5585: l_parent_end_date := WF_ENGINE.GetItemAttrDate(
5586: itemtype => itemtype,
5587: itemkey => itemkey ,

Line 5689: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');

5685:
5686: l_schedule_start_date := WF_ENGINE.GetItemAttrDate(
5687: itemtype => itemtype,
5688: itemkey => itemkey ,
5689: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');
5690:
5691: l_scheduler_frequency := WF_ENGINE.GetItemAttrNumber(
5692: itemtype => itemtype,
5693: itemkey => itemkey ,

Line 5694: aname => 'AMS_SCHEDULER_FREQUENCY');

5690:
5691: l_scheduler_frequency := WF_ENGINE.GetItemAttrNumber(
5692: itemtype => itemtype,
5693: itemkey => itemkey ,
5694: aname => 'AMS_SCHEDULER_FREQUENCY');
5695:
5696: l_scheduler_frequency_type := WF_ENGINE.GetItemAttrText(
5697: itemtype => itemtype,
5698: itemkey => itemkey ,

Line 5699: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');

5695:
5696: l_scheduler_frequency_type := WF_ENGINE.GetItemAttrText(
5697: itemtype => itemtype,
5698: itemkey => itemkey ,
5699: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');
5700:
5701: --anchaudh: commented out on 11 Jun '05 to fix bug#4477717 .
5702: /*AMS_UTILITY_PVT.Convert_Timezone(
5703: p_init_msg_list => FND_API.G_TRUE,

Line 5713: AMS_SCHEDULER_PVT.Schedule_Repeat(

5709: p_convert_type => 'USER',
5710: x_out_time => l_usr_start_time
5711: );
5712:
5713: AMS_SCHEDULER_PVT.Schedule_Repeat(
5714: p_last_run_date => l_usr_start_time,
5715: p_frequency => l_scheduler_frequency,
5716: p_frequency_type => l_scheduler_frequency_type,
5717: x_next_run_date => l_schedule_end_date,

Line 5756: AMS_SCHEDULER_PVT.Create_Next_Schedule ( p_parent_sched_id => l_parent_sched_id,

5752: l_schedule_end_date := nvl(l_parent_end_date, l_campaign_end_date);
5753: --END IF;
5754:
5755:
5756: AMS_SCHEDULER_PVT.Create_Next_Schedule ( p_parent_sched_id => l_parent_sched_id,
5757: p_child_sched_st_date => l_schedule_start_date,--l_usr_start_time,
5758: p_child_sched_en_date => l_schedule_end_date,
5759: x_child_sched_id => l_child_sched_id,
5760: x_msg_count => l_msg_count,

Line 5852: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE'

5848: p_parameterlist => l_parameter_list);
5849:
5850: l_schedule_next_run_st_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype,
5851: itemkey => itemkey ,
5852: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE'
5853: );
5854:
5855: l_temp_variable := to_char(l_schedule_next_run_st_date,'DD-MON-RRRR HH24:MI:SS');
5856:

Line 5861: WRITE_LOG(l_api_name, 'WF_REPEAT_RAISE_EVENT: ADD AMS_SCHEDULER_NEXT_RUN_ST_DATE TO PARAMTER LIST : '||

5857: wf_event.AddParameterToList(p_name => 'AMS_PARENT_STATUS',
5858: p_value => l_temp_variable,
5859: p_parameterlist => l_parameter_list);
5860:
5861: WRITE_LOG(l_api_name, 'WF_REPEAT_RAISE_EVENT: ADD AMS_SCHEDULER_NEXT_RUN_ST_DATE TO PARAMTER LIST : '||
5862: '|| NEW SCHEDULE ID PASSED: '||l_schedule_id||'; || '
5863: ||to_char(l_schedule_next_run_st_date,'DD-MON-RRRR HH24:MI:SS')||' ; '
5864: ||'|| L_TEMP_VARIABLE VALUE PASSED: '||l_temp_variable||'|| SYSDATE: '
5865: ||to_char(sysdate,'DD-MON-RRRR HH24:MI:SS'));

Line 6097: WF_CORE.CONTEXT('AMS_ScheduleRules_PVT','HANDLE_COLLATERAL',

6093:
6094: EXCEPTION
6095:
6096: WHEN OTHERS THEN
6097: WF_CORE.CONTEXT('AMS_ScheduleRules_PVT','HANDLE_COLLATERAL',
6098: p_event.getEventName( ), p_subscription_guid);
6099: WF_EVENT.setErrorInfo(p_event, 'ERROR');
6100: RETURN 'ERROR';
6101: END HANDLE_COLLATERAL;

Line 6142: ams_scheduler scheduler,

6138: frequency_type,
6139: end_date_time,
6140: campaign_id
6141: FROM ams_campaign_schedules_b csch,
6142: ams_scheduler scheduler,
6143: AMS_MEDIA_VL Med,
6144: ams_lookups lookup
6145: WHERE csch.schedule_id = p_schedule_id
6146: AND scheduler.OBJECT_ID(+) = nvl(csch.orig_csch_id, csch.schedule_id)

Line 6238: aname => 'AMS_SCHEDULER_FREQUENCY' ));

6234: --Repeating activity
6235: l_scheduler_frequency := to_number(WF_ENGINE.GetItemAttrText(
6236: itemtype => itemtype,
6237: itemkey => itemkey ,
6238: aname => 'AMS_SCHEDULER_FREQUENCY' ));
6239: IF (l_scheduler_frequency IS NULL) THEN
6240: -- this means that the repeating activity is in the Schedule Execution flow
6241: AMS_SCHEDULER_PVT.Schedule_Repeat (
6242: p_last_run_date => SYSDATE,

Line 6241: AMS_SCHEDULER_PVT.Schedule_Repeat (

6237: itemkey => itemkey ,
6238: aname => 'AMS_SCHEDULER_FREQUENCY' ));
6239: IF (l_scheduler_frequency IS NULL) THEN
6240: -- this means that the repeating activity is in the Schedule Execution flow
6241: AMS_SCHEDULER_PVT.Schedule_Repeat (
6242: p_last_run_date => SYSDATE,
6243: p_frequency => l_query_freq,
6244: p_frequency_type => l_query_freq_type,
6245: x_next_run_date => l_scheduler_next_run_date,

Line 6285: aname => 'AMS_SCHEDULER_FREQ_MEANING',

6281: avalue => l_new_schedule_name );
6282: END IF;
6283: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
6284: itemkey => itemkey ,
6285: aname => 'AMS_SCHEDULER_FREQ_MEANING',
6286: avalue => l_freq_meaning );
6287:
6288: END IF;
6289: -- set the message 'Repeating Activity' from FND_MESSAGES

Line 6331: END AMS_ScheduleRules_PVT ;

6327: wf_core.context(G_PKG_NAME,'CHECK_NOTIFICATION_PREFERENCE',itemtype,itemkey,actid,funcmode);
6328: raise ;
6329: END CHECK_NOTIFICATION_PREFERENCE;
6330:
6331: END AMS_ScheduleRules_PVT ;