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.31.12010000.2 2008/08/08 11:33:34 amlal 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.31.12010000.2 2008/08/08 11:33:34 amlal 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 5025: ams_scheduler scheduler,

5021: parentCSCH.start_date_time,
5022: parentCSCH.end_date_time,
5023: parentCSCH.status_code
5024: FROM ams_campaign_schedules_vl csch,
5025: ams_scheduler scheduler,
5026: ams_campaigns_all_b camp,
5027: ams_campaign_Schedules_b parentCSCH
5028: WHERE csch.schedule_id = p_schedule_id
5029: AND scheduler.OBJECT_ID = nvl(csch.orig_csch_id, csch.schedule_id)

Line 5192: aname => 'AMS_SCHEDULER_FREQUENCY',

5188: avalue => l_csch_orig_id);
5189:
5190: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
5191: itemkey => itemkey,
5192: aname => 'AMS_SCHEDULER_FREQUENCY',
5193: avalue => l_sched_freq);
5194:
5195: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5196: itemkey => itemkey,

Line 5197: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE',

5193: avalue => l_sched_freq);
5194:
5195: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5196: itemkey => itemkey,
5197: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE',
5198: avalue => l_sched_freq_type);
5199:
5200: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5201: itemkey => itemkey,

Line 5228: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE',

5224:
5225:
5226: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5227: itemkey => itemkey ,
5228: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE',
5229: avalue => l_schedule_next_run_st_date);
5230:
5231: END IF;
5232:

Line 5421: aname => 'AMS_SCHEDULER_FREQUENCY');

5417:
5418: l_scheduler_frequency := WF_ENGINE.GetItemAttrNumber(
5419: itemtype => itemtype,
5420: itemkey => itemkey ,
5421: aname => 'AMS_SCHEDULER_FREQUENCY');
5422:
5423: l_scheduler_frequency_type := WF_ENGINE.GetItemAttrText(
5424: itemtype => itemtype,
5425: itemkey => itemkey ,

Line 5426: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');

5422:
5423: l_scheduler_frequency_type := WF_ENGINE.GetItemAttrText(
5424: itemtype => itemtype,
5425: itemkey => itemkey ,
5426: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');
5427:
5428: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Calling AMS_SCHEDULER_PVT.Schedule_Repeat with freq type ' ||l_scheduler_frequency_type);
5429:
5430:

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

5424: itemtype => itemtype,
5425: itemkey => itemkey ,
5426: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');
5427:
5428: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Calling AMS_SCHEDULER_PVT.Schedule_Repeat with freq type ' ||l_scheduler_frequency_type);
5429:
5430:
5431: l_new_last_run_date := WF_ENGINE.GetItemAttrDate(
5432: itemtype => itemtype,

Line 5434: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');

5430:
5431: l_new_last_run_date := WF_ENGINE.GetItemAttrDate(
5432: itemtype => itemtype,
5433: itemkey => itemkey ,
5434: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');
5435:
5436:
5437:
5438: SELECT nvl(orig_csch_id, schedule_id)

Line 5455: 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);

5451:
5452: 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);
5453:
5454:
5455: 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);
5456:
5457:
5458: AMS_SCHEDULER_PVT.Schedule_Repeat (
5459: p_last_run_date => SYSDATE,

Line 5458: AMS_SCHEDULER_PVT.Schedule_Repeat (

5454:
5455: 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);
5456:
5457:
5458: AMS_SCHEDULER_PVT.Schedule_Repeat (
5459: p_last_run_date => SYSDATE,
5460: p_frequency => l_scheduler_frequency,
5461: p_frequency_type => l_scheduler_frequency_type,
5462: x_next_run_date => l_scheduler_next_run_date,

Line 5475: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE',

5471: 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);
5472:
5473: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5474: itemkey => itemkey ,
5475: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE',
5476: avalue => l_scheduler_next_run_date);
5477:
5478: result := 'COMPLETE:SUCCESS' ;
5479: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS

Line 5489: p_wf_err_attrib => 'AMS_SCHEDULER_ERROR_MSG');

5485: Handle_Error(p_itemtype => itemtype,
5486: p_itemkey => itemkey,
5487: p_msg_count => l_msg_count,
5488: p_msg_data => l_msg_data,
5489: p_wf_err_attrib => 'AMS_SCHEDULER_ERROR_MSG');
5490:
5491: WRITE_LOG(l_api_name, 'Error in scheduling next run start date caught for schedule id: '||l_schedule_id);
5492: result := 'COMPLETE:ERROR' ;
5493:

Line 5553: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');

5549:
5550: l_schedule_next_run_date := WF_ENGINE.GetItemAttrDate(
5551: itemtype => itemtype,
5552: itemkey => itemkey ,
5553: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');
5554:
5555: l_parent_end_date := WF_ENGINE.GetItemAttrDate(
5556: itemtype => itemtype,
5557: itemkey => itemkey ,

Line 5659: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');

5655:
5656: l_schedule_start_date := WF_ENGINE.GetItemAttrDate(
5657: itemtype => itemtype,
5658: itemkey => itemkey ,
5659: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');
5660:
5661: l_scheduler_frequency := WF_ENGINE.GetItemAttrNumber(
5662: itemtype => itemtype,
5663: itemkey => itemkey ,

Line 5664: aname => 'AMS_SCHEDULER_FREQUENCY');

5660:
5661: l_scheduler_frequency := WF_ENGINE.GetItemAttrNumber(
5662: itemtype => itemtype,
5663: itemkey => itemkey ,
5664: aname => 'AMS_SCHEDULER_FREQUENCY');
5665:
5666: l_scheduler_frequency_type := WF_ENGINE.GetItemAttrText(
5667: itemtype => itemtype,
5668: itemkey => itemkey ,

Line 5669: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');

5665:
5666: l_scheduler_frequency_type := WF_ENGINE.GetItemAttrText(
5667: itemtype => itemtype,
5668: itemkey => itemkey ,
5669: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');
5670:
5671: --anchaudh: commented out on 11 Jun '05 to fix bug#4477717 .
5672: /*AMS_UTILITY_PVT.Convert_Timezone(
5673: p_init_msg_list => FND_API.G_TRUE,

Line 5683: AMS_SCHEDULER_PVT.Schedule_Repeat(

5679: p_convert_type => 'USER',
5680: x_out_time => l_usr_start_time
5681: );
5682:
5683: AMS_SCHEDULER_PVT.Schedule_Repeat(
5684: p_last_run_date => l_usr_start_time,
5685: p_frequency => l_scheduler_frequency,
5686: p_frequency_type => l_scheduler_frequency_type,
5687: x_next_run_date => l_schedule_end_date,

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

5722: l_schedule_end_date := nvl(l_parent_end_date, l_campaign_end_date);
5723: --END IF;
5724:
5725:
5726: AMS_SCHEDULER_PVT.Create_Next_Schedule ( p_parent_sched_id => l_parent_sched_id,
5727: p_child_sched_st_date => l_schedule_start_date,--l_usr_start_time,
5728: p_child_sched_en_date => l_schedule_end_date,
5729: x_child_sched_id => l_child_sched_id,
5730: x_msg_count => l_msg_count,

Line 5822: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE'

5818: p_parameterlist => l_parameter_list);
5819:
5820: l_schedule_next_run_st_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype,
5821: itemkey => itemkey ,
5822: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE'
5823: );
5824:
5825: l_temp_variable := to_char(l_schedule_next_run_st_date,'DD-MON-RRRR HH24:MI:SS');
5826:

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

5827: wf_event.AddParameterToList(p_name => 'AMS_PARENT_STATUS',
5828: p_value => l_temp_variable,
5829: p_parameterlist => l_parameter_list);
5830:
5831: WRITE_LOG(l_api_name, 'WF_REPEAT_RAISE_EVENT: ADD AMS_SCHEDULER_NEXT_RUN_ST_DATE TO PARAMTER LIST : '||
5832: '|| NEW SCHEDULE ID PASSED: '||l_schedule_id||'; || '
5833: ||to_char(l_schedule_next_run_st_date,'DD-MON-RRRR HH24:MI:SS')||' ; '
5834: ||'|| L_TEMP_VARIABLE VALUE PASSED: '||l_temp_variable||'|| SYSDATE: '
5835: ||to_char(sysdate,'DD-MON-RRRR HH24:MI:SS'));

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

6063:
6064: EXCEPTION
6065:
6066: WHEN OTHERS THEN
6067: WF_CORE.CONTEXT('AMS_ScheduleRules_PVT','HANDLE_COLLATERAL',
6068: p_event.getEventName( ), p_subscription_guid);
6069: WF_EVENT.setErrorInfo(p_event, 'ERROR');
6070: RETURN 'ERROR';
6071: END HANDLE_COLLATERAL;

Line 6112: ams_scheduler scheduler,

6108: frequency_type,
6109: end_date_time,
6110: campaign_id
6111: FROM ams_campaign_schedules_b csch,
6112: ams_scheduler scheduler,
6113: AMS_MEDIA_VL Med,
6114: ams_lookups lookup
6115: WHERE csch.schedule_id = p_schedule_id
6116: AND scheduler.OBJECT_ID(+) = nvl(csch.orig_csch_id, csch.schedule_id)

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

6204: --Repeating activity
6205: l_scheduler_frequency := to_number(WF_ENGINE.GetItemAttrText(
6206: itemtype => itemtype,
6207: itemkey => itemkey ,
6208: aname => 'AMS_SCHEDULER_FREQUENCY' ));
6209: IF (l_scheduler_frequency IS NULL) THEN
6210: -- this means that the repeating activity is in the Schedule Execution flow
6211: AMS_SCHEDULER_PVT.Schedule_Repeat (
6212: p_last_run_date => SYSDATE,

Line 6211: AMS_SCHEDULER_PVT.Schedule_Repeat (

6207: itemkey => itemkey ,
6208: aname => 'AMS_SCHEDULER_FREQUENCY' ));
6209: IF (l_scheduler_frequency IS NULL) THEN
6210: -- this means that the repeating activity is in the Schedule Execution flow
6211: AMS_SCHEDULER_PVT.Schedule_Repeat (
6212: p_last_run_date => SYSDATE,
6213: p_frequency => l_query_freq,
6214: p_frequency_type => l_query_freq_type,
6215: x_next_run_date => l_scheduler_next_run_date,

Line 6255: aname => 'AMS_SCHEDULER_FREQ_MEANING',

6251: avalue => l_new_schedule_name );
6252: END IF;
6253: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
6254: itemkey => itemkey ,
6255: aname => 'AMS_SCHEDULER_FREQ_MEANING',
6256: avalue => l_freq_meaning );
6257:
6258: END IF;
6259: -- set the message 'Repeating Activity' from FND_MESSAGES

Line 6301: END AMS_ScheduleRules_PVT ;

6297: wf_core.context(G_PKG_NAME,'CHECK_NOTIFICATION_PREFERENCE',itemtype,itemkey,actid,funcmode);
6298: raise ;
6299: END CHECK_NOTIFICATION_PREFERENCE;
6300:
6301: END AMS_ScheduleRules_PVT ;