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 WF_ENGINE

Line 3400: l_schedule_id := WF_ENGINE.GetItemAttrText(

3396: l_return_status VARCHAR2(1);
3397: l_schedule_id NUMBER ;
3398: BEGIN
3399:
3400: l_schedule_id := WF_ENGINE.GetItemAttrText(
3401: itemtype => p_itemtype,
3402: itemkey => p_itemkey ,
3403: aname => 'SCHEDULE_ID');
3404:

Line 3424: WF_ENGINE.SetItemAttrText(itemtype => p_itemtype,

3420: l_cnt := l_cnt + 1 ;
3421:
3422: END LOOP ;
3423:
3424: WF_ENGINE.SetItemAttrText(itemtype => p_itemtype,
3425: itemkey => p_itemkey ,
3426: aname => 'ERROR_MESSAGE',
3427: avalue => l_final_data );
3428:

Line 3477: l_schedule_id := WF_ENGINE.GetItemAttrText(

3473: BEGIN
3474: IF (funcmode = 'RUN')
3475: THEN
3476:
3477: l_schedule_id := WF_ENGINE.GetItemAttrText(
3478: itemtype => itemtype,
3479: itemkey => itemkey ,
3480: aname => 'SCHEDULE_ID');
3481:

Line 3510: Wf_Engine.SetItemOwner(itemtype => itemtype,

3506: p_name => l_user_name,
3507: p_display_name => l_display_name );
3508:
3509: IF l_user_name IS NOT NULL THEN
3510: Wf_Engine.SetItemOwner(itemtype => itemtype,
3511: itemkey => itemkey,
3512: owner => l_user_name);
3513: END IF;
3514: END IF;

Line 3517: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3513: END IF;
3514: END IF;
3515: CLOSE c_emp_dtl;
3516:
3517: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3518: itemkey => itemkey,
3519: aname => 'SCHEDULE_NAME',
3520: avalue => l_schedule_rec.schedule_name);
3521:

Line 3522: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

3518: itemkey => itemkey,
3519: aname => 'SCHEDULE_NAME',
3520: avalue => l_schedule_rec.schedule_name);
3521:
3522: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
3523: itemkey => itemkey ,
3524: userkey => l_schedule_rec.schedule_name);
3525:
3526: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 3526: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3522: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
3523: itemkey => itemkey ,
3524: userkey => l_schedule_rec.schedule_name);
3525:
3526: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3527: itemkey => itemkey,
3528: aname => 'SCHEDULE_OWNER',
3529: avalue => l_user_name);
3530:

Line 3531: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3527: itemkey => itemkey,
3528: aname => 'SCHEDULE_OWNER',
3529: avalue => l_user_name);
3530:
3531: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3532: itemkey => itemkey,
3533: aname => 'WF_ADMINISTRATOR',
3534: avalue => l_user_name);
3535:

Line 3536: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3532: itemkey => itemkey,
3533: aname => 'WF_ADMINISTRATOR',
3534: avalue => l_user_name);
3535:
3536: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3537: itemkey => itemkey,
3538: aname => 'SCHEDULE_STATUS',
3539: avalue => l_schedule_rec.status_code);
3540:

Line 3541: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3537: itemkey => itemkey,
3538: aname => 'SCHEDULE_STATUS',
3539: avalue => l_schedule_rec.status_code);
3540:
3541: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3542: itemkey => itemkey,
3543: aname => 'SCHEDULE_CHANNEL',
3544: avalue => l_schedule_rec.activity_id );
3545:

Line 3546: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3542: itemkey => itemkey,
3543: aname => 'SCHEDULE_CHANNEL',
3544: avalue => l_schedule_rec.activity_id );
3545:
3546: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3547: itemkey => itemkey,
3548: aname => 'ACTIVITY_TYPE',
3549: avalue => l_schedule_rec.activity_type );
3550:

Line 3551: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3547: itemkey => itemkey,
3548: aname => 'ACTIVITY_TYPE',
3549: avalue => l_schedule_rec.activity_type );
3550:
3551: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3552: itemkey => itemkey,
3553: aname => 'ERROR_FLAG',
3554: avalue => 'N');
3555: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 3555: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3551: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3552: itemkey => itemkey,
3553: aname => 'ERROR_FLAG',
3554: avalue => 'N');
3555: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3556: itemkey => itemkey,
3557: aname => 'AMS_SCHEDULE_START_DATE',
3558: avalue => l_schedule_rec.start_date_time );
3559:

Line 3560: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

3556: itemkey => itemkey,
3557: aname => 'AMS_SCHEDULE_START_DATE',
3558: avalue => l_schedule_rec.start_date_time );
3559:
3560: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
3561: itemkey => itemkey,
3562: aname => 'AMS_SCHEDULE_END_DATE',
3563: avalue => l_schedule_rec.end_date_time );
3564:

Line 3624: l_schedule_id := WF_ENGINE.GetItemAttrText(

3620: l_user_id := FND_GLOBAL.USER_ID;
3621: l_resp_id := FND_GLOBAL.RESP_ID;
3622: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3623:
3624: l_schedule_id := WF_ENGINE.GetItemAttrText(
3625: itemtype => p_itemtype,
3626: itemkey => p_itemkey ,
3627: aname => 'SCHEDULE_ID');
3628:

Line 3672: l_schedule_id := WF_ENGINE.GetItemAttrText(

3668: -- based on the work item context stored in item attributes
3669: -- get Item Attributes for user_id, responsibility_id and application_id
3670: -- this assumes that they were set as item attribute, probably through
3671: -- definition.
3672: l_schedule_id := WF_ENGINE.GetItemAttrText(
3673: itemtype => p_itemtype,
3674: itemkey => p_itemkey ,
3675: aname => 'SCHEDULE_ID');
3676:

Line 3734: l_schedule_id := WF_ENGINE.GetItemAttrText(

3730: -- dbms_output.put_line('Process Check_Repeat');
3731: -- RUN mode - Normal Process Execution
3732: IF (funcmode = 'RUN')
3733: THEN
3734: l_schedule_id := WF_ENGINE.GetItemAttrText(
3735: itemtype => itemtype,
3736: itemkey => itemkey ,
3737: aname => 'SCHEDULE_ID' );
3738:

Line 3747: l_schedule_status := WF_ENGINE.GetItemAttrText(

3743: p_msg_data => 'Check_Schedule_Status : started',
3744: p_msg_type => 'DEBUG'
3745: );
3746:
3747: l_schedule_status := WF_ENGINE.GetItemAttrText(
3748: itemtype => itemtype,
3749: itemkey => itemkey ,
3750: aname => 'SCHEDULE_STATUS' );
3751:

Line 3826: l_schedule_id := WF_ENGINE.GetItemAttrText(

3822: -- dbms_output.put_line('Process Check_Repeat');
3823: -- RUN mode - Normal Process Execution
3824: IF (funcmode = 'RUN')
3825: THEN
3826: l_schedule_id := WF_ENGINE.GetItemAttrText(
3827: itemtype => itemtype,
3828: itemkey => itemkey ,
3829: aname => 'SCHEDULE_ID' );
3830:

Line 3924: l_schedule_id := WF_ENGINE.GetItemAttrText(

3920: -- dbms_output.put_line('Process Check_Repeat');
3921: -- RUN mode - Normal Process Execution
3922: IF (funcmode = 'RUN')
3923: THEN
3924: l_schedule_id := WF_ENGINE.GetItemAttrText(
3925: itemtype => itemtype,
3926: itemkey => itemkey ,
3927: aname => 'SCHEDULE_ID' );
3928:

Line 3937: l_schedule_activity := WF_ENGINE.GetItemAttrText(

3933: p_msg_data => 'Check_Schedule_Act_Type : started',
3934: p_msg_type => 'DEBUG'
3935: );
3936:
3937: l_schedule_activity := WF_ENGINE.GetItemAttrText(
3938: itemtype => itemtype,
3939: itemkey => itemkey ,
3940: aname => 'ACTIVITY_TYPE' );
3941:

Line 4055: l_schedule_id := WF_ENGINE.GetItemAttrText(

4051: -- RUN mode - Normal Process Execution
4052: IF (funcmode = 'RUN')
4053: THEN
4054: -- get schedule id
4055: l_schedule_id := WF_ENGINE.GetItemAttrText(
4056: itemtype => itemtype,
4057: itemkey => itemkey ,
4058: aname => 'SCHEDULE_ID' );
4059:

Line 4070: l_activity_id := WF_ENGINE.GetItemAttrText(

4066: );
4067:
4068:
4069: -- get schedule activity
4070: l_activity_id := WF_ENGINE.GetItemAttrText(
4071: itemtype => itemtype,
4072: itemkey => itemkey ,
4073: aname => 'SCHEDULE_CHANNEL' );
4074: --

Line 4108: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

4104: p_list_header_id => l_list_id -- target group id
4105: );
4106:
4107: IF l_return_status <> FND_API.g_ret_sts_success THEN
4108: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4109: itemkey => itemkey,
4110: aname => 'ERROR_FLAG',
4111: avalue => 'Y');
4112: Handle_Error(p_itemtype => itemtype,

Line 4147: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

4143: x_msg_data => l_msg_data
4144: );
4145:
4146: IF l_return_status <> FND_API.g_ret_sts_success THEN
4147: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4148: itemkey => itemkey,
4149: aname => 'ERROR_FLAG',
4150: avalue => 'Y');
4151: Handle_Error(p_itemtype => itemtype,

Line 4159: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

4155: RETURN;
4156: END IF;
4157:
4158: /*
4159: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4160: itemkey => itemkey,
4161: aname => 'ERROR_FLAG',
4162: avalue => 'Y');
4163: Handle_Error(p_itemtype => itemtype,

Line 4239: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

4235: p_msg_type => 'DEBUG'
4236: );
4237:
4238: IF l_return_status <> FND_API.g_ret_sts_success THEN
4239: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4240: itemkey => itemkey,
4241: aname => 'ERROR_FLAG',
4242: avalue => 'Y');
4243: Handle_Error(p_itemtype => itemtype,

Line 4281: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

4277: p_msg_type => 'DEBUG'
4278: );
4279:
4280: IF l_return_status <> FND_API.g_ret_sts_success THEN
4281: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4282: itemkey => itemkey,
4283: aname => 'ERROR_FLAG',
4284: avalue => 'Y');
4285: Handle_Error(p_itemtype => itemtype,

Line 4315: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

4311: p_msg_data => 'Execute_Direct_Marketing : Target Group is empty',
4312: p_msg_type => 'DEBUG'
4313: );
4314:
4315: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4316: itemkey => itemkey,
4317: aname => 'ERROR_FLAG',
4318: avalue => 'Y');
4319:

Line 4327: WF_ENGINE.SetItemAttrText(itemtype => itemtype, -- 29-apr-2004 anchaudh : fixed the reopened bug#3553087

4323: p_msg_data => l_msg_data);*/
4324:
4325: l_error_msg := FND_MESSAGE.get_string('AMS','AMS_CSCH_NO_TARGET_GROUP');
4326:
4327: WF_ENGINE.SetItemAttrText(itemtype => itemtype, -- 29-apr-2004 anchaudh : fixed the reopened bug#3553087
4328: itemkey => itemkey,
4329: aname => 'ERROR_MESSAGE',
4330: avalue => l_error_msg);
4331:

Line 4387: l_schedule_id := WF_ENGINE.GetItemAttrText(

4383: BEGIN
4384: -- RUN mode - Normal Process Execution
4385: IF (funcmode = 'RUN')
4386: THEN
4387: l_schedule_id := WF_ENGINE.GetItemAttrText(
4388: itemtype => itemtype,
4389: itemkey => itemkey ,
4390: aname => 'SCHEDULE_ID' );
4391:

Line 4417: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

4413: p_msg_type => 'DEBUG'
4414: );
4415:
4416: IF l_return_status <> FND_API.g_ret_sts_success THEN
4417: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
4418: itemkey => itemkey,
4419: aname => 'ERROR_FLAG',
4420: avalue => 'Y');
4421: Handle_Error(p_itemtype => itemtype,

Line 4642: l_asn_group_id := WF_ENGINE.GetItemAttrText(

4638: CLOSE c_sch_det;
4639:
4640: if(l_triggerable_flag = 'N' and l_trig_repeat_flag = 'N' and l_orig_csch_id IS NULL) then -- anchaudh added for the leads bug.
4641:
4642: l_asn_group_id := WF_ENGINE.GetItemAttrText(
4643: itemtype => itemtype,
4644: itemkey => itemkey ,
4645: aname => 'ASN_GROUP_ID');--anchaudh added for the leads bug.
4646:

Line 4649: l_asn_resource_id := WF_ENGINE.GetItemAttrText(

4645: aname => 'ASN_GROUP_ID');--anchaudh added for the leads bug.
4646:
4647: --insert_log_mesg('Anirban inside generate_leads api, value of l_asn_group_id retrieved is :'||l_asn_group_id);
4648:
4649: l_asn_resource_id := WF_ENGINE.GetItemAttrText(
4650: itemtype => itemtype,
4651: itemkey => itemkey ,
4652: aname => 'ASN_RESOURCE_ID');--anchaudh added for the leads bug.
4653: --insert_log_mesg('Anirban inside generate_leads api, value of l_asn_resource_id retrieved is :'||l_asn_resource_id);

Line 4940: l_schedule_id := WF_ENGINE.GetItemAttrText(

4936: -- dbms_output.put_line('Process Check_Repeat');
4937: -- RUN mode - Normal Process Execution
4938: IF (funcmode = 'RUN')
4939: THEN
4940: l_schedule_id := WF_ENGINE.GetItemAttrText(
4941: itemtype => itemtype,
4942: itemkey => itemkey ,
4943: aname => 'SCHEDULE_ID' );
4944:

Line 4953: l_error_flag := WF_ENGINE.GetItemAttrText(

4949: p_msg_data => 'Check_WF_Error : started',
4950: p_msg_type => 'DEBUG'
4951: );
4952:
4953: l_error_flag := WF_ENGINE.GetItemAttrText(
4954: itemtype => itemtype,
4955: itemkey => itemkey ,
4956: aname => 'ERROR_FLAG' );
4957:

Line 5101: l_schedule_id := WF_ENGINE.GetItemAttrText(

5097: l_api_name := 'Wf_Repeat_Init_var';
5098: IF (funcmode = 'RUN')
5099: THEN
5100:
5101: l_schedule_id := WF_ENGINE.GetItemAttrText(
5102: itemtype => itemtype,
5103: itemkey => itemkey ,
5104: aname => 'SCHEDULE_ID');
5105:

Line 5108: l_temp_varaibale := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

5104: aname => 'SCHEDULE_ID');
5105:
5106:
5107:
5108: l_temp_varaibale := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
5109: itemkey => itemkey ,
5110: aname => 'AMS_PARENT_STATUS'
5111: );
5112:

Line 5127: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

5123: ||l_temp_varaibale);
5124:
5125:
5126:
5127: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
5128: itemkey => itemkey,
5129: aname => 'AMS_SCHEDULE_ID',
5130: avalue => l_schedule_id);
5131:

Line 5169: Wf_Engine.SetItemOwner(itemtype => itemtype,

5165: p_name => l_user_name,
5166: p_display_name => l_display_name );
5167:
5168: IF l_user_name IS NOT NULL THEN
5169: Wf_Engine.SetItemOwner(itemtype => itemtype,
5170: itemkey => itemkey,
5171: owner => l_user_name);
5172: END IF;
5173: END IF;

Line 5176: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5172: END IF;
5173: END IF;
5174: CLOSE c_emp_dtl;
5175:
5176: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5177: itemkey => itemkey,
5178: aname => 'SCHEDULE_NAME',
5179: avalue => l_schedule_name);
5180:

Line 5181: WF_ENGINE.SetItemUserkey(itemtype => itemtype,

5177: itemkey => itemkey,
5178: aname => 'SCHEDULE_NAME',
5179: avalue => l_schedule_name);
5180:
5181: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
5182: itemkey => itemkey ,
5183: userkey => l_schedule_name);
5184:
5185: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

Line 5185: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

5181: WF_ENGINE.SetItemUserkey(itemtype => itemtype,
5182: itemkey => itemkey ,
5183: userkey => l_schedule_name);
5184:
5185: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5186: itemkey => itemkey,
5187: aname => 'AMS_SCHEDULE_START_DATE',
5188: avalue => to_date(l_csch_st_date,'DD-MM-RRRR HH24:MI:SS') );
5189:

Line 5190: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

5186: itemkey => itemkey,
5187: aname => 'AMS_SCHEDULE_START_DATE',
5188: avalue => to_date(l_csch_st_date,'DD-MM-RRRR HH24:MI:SS') );
5189:
5190: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5191: itemkey => itemkey,
5192: aname => 'AMS_SCHEDULE_END_DATE',
5193: avalue => to_date(l_csch_en_date,'DD-MM-RRRR HH24:MI:SS') );
5194:

Line 5195: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5191: itemkey => itemkey,
5192: aname => 'AMS_SCHEDULE_END_DATE',
5193: avalue => to_date(l_csch_en_date,'DD-MM-RRRR HH24:MI:SS') );
5194:
5195: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5196: itemkey => itemkey,
5197: aname => 'SCHEDULE_STATUS',
5198: avalue => l_csch_status);
5199:

Line 5200: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5196: itemkey => itemkey,
5197: aname => 'SCHEDULE_STATUS',
5198: avalue => l_csch_status);
5199:
5200: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5201: itemkey => itemkey,
5202: aname => 'SCHEDULE_OWNER',
5203: avalue => l_user_name);
5204:

Line 5205: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5201: itemkey => itemkey,
5202: aname => 'SCHEDULE_OWNER',
5203: avalue => l_user_name);
5204:
5205: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5206: itemkey => itemkey,
5207: aname => 'SCHEDULE_CHANNEL',
5208: avalue => l_csch_act_id);
5209:

Line 5210: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5206: itemkey => itemkey,
5207: aname => 'SCHEDULE_CHANNEL',
5208: avalue => l_csch_act_id);
5209:
5210: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5211: itemkey => itemkey,
5212: aname => 'ACTIVITY_TYPE',
5213: avalue => l_csch_act_code);
5214:

Line 5215: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

5211: itemkey => itemkey,
5212: aname => 'ACTIVITY_TYPE',
5213: avalue => l_csch_act_code);
5214:
5215: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,
5216: itemkey => itemkey,
5217: aname => 'AMS_ORIG_SCHEDULE_ID',
5218: avalue => l_csch_orig_id);
5219:

Line 5220: WF_ENGINE.SetItemAttrNumber(itemtype => itemtype,

5216: itemkey => itemkey,
5217: aname => 'AMS_ORIG_SCHEDULE_ID',
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:

Line 5225: WF_ENGINE.SetItemAttrText(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,
5227: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE',
5228: avalue => l_sched_freq_type);
5229:

Line 5230: WF_ENGINE.SetItemAttrDate(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,
5232: aname => 'AMS_CAMPAIGN_START_DATE',
5233: avalue => to_date(l_camp_st_date,'DD-MM-RRRR HH24:MI:SS') );
5234:

Line 5235: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

5231: itemkey => itemkey,
5232: aname => 'AMS_CAMPAIGN_START_DATE',
5233: avalue => to_date(l_camp_st_date,'DD-MM-RRRR HH24:MI:SS') );
5234:
5235: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5236: itemkey => itemkey,
5237: aname => 'AMS_CAMPAIGN_END_DATE',
5238: avalue => to_date(l_camp_en_date,'DD-MM-RRRR HH24:MI:SS') );
5239:

Line 5240: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

5236: itemkey => itemkey,
5237: aname => 'AMS_CAMPAIGN_END_DATE',
5238: avalue => to_date(l_camp_en_date,'DD-MM-RRRR HH24:MI:SS') );
5239:
5240: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5241: itemkey => itemkey,
5242: aname => 'AMS_PARENT_START_DATE',
5243: avalue => to_date(l_parent_st_date,'DD-MM-RRRR HH24:MI:SS') );
5244:

Line 5245: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

5241: itemkey => itemkey,
5242: aname => 'AMS_PARENT_START_DATE',
5243: avalue => to_date(l_parent_st_date,'DD-MM-RRRR HH24:MI:SS') );
5244:
5245: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,
5246: itemkey => itemkey,
5247: aname => 'AMS_PARENT_END_DATE',
5248: avalue => to_date(l_parent_en_date,'DD-MM-RRRR HH24:MI:SS') );
5249:

Line 5250: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5246: itemkey => itemkey,
5247: aname => 'AMS_PARENT_END_DATE',
5248: avalue => to_date(l_parent_en_date,'DD-MM-RRRR HH24:MI:SS') );
5249:
5250: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5251: itemkey => itemkey,
5252: aname => 'AMS_PARENT_STATUS',
5253: avalue => l_parent_status);
5254:

Line 5256: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

5252: aname => 'AMS_PARENT_STATUS',
5253: avalue => l_parent_status);
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:

Line 5318: l_schedule_id := WF_ENGINE.GetItemAttrText(

5314:
5315: BEGIN
5316: l_api_name := 'WF_REPEAT_CHECK_EXECUTE';
5317:
5318: l_schedule_id := WF_ENGINE.GetItemAttrText(
5319: itemtype => itemtype,
5320: itemkey => itemkey ,
5321: aname => 'SCHEDULE_ID');
5322:

Line 5333: l_sched_status := WF_ENGINE.GetItemAttrText(

5329: IF (funcmode = 'RUN')
5330: THEN
5331: WRITE_LOG(l_api_name, 'Wf_Repeat_Check_Execute: Schedule id is '||l_schedule_id);
5332:
5333: l_sched_status := WF_ENGINE.GetItemAttrText(
5334: itemtype => itemtype,
5335: itemkey => itemkey ,
5336: aname => 'SCHEDULE_STATUS');
5337:

Line 5338: l_sched_end_date := WF_ENGINE.GetItemAttrDate(

5334: itemtype => itemtype,
5335: itemkey => itemkey ,
5336: aname => 'SCHEDULE_STATUS');
5337:
5338: l_sched_end_date := WF_ENGINE.GetItemAttrDate(
5339: itemtype => itemtype,
5340: itemkey => itemkey ,
5341: aname => 'AMS_SCHEDULE_END_DATE');
5342:

Line 5343: l_orig_csch_status := WF_ENGINE.GetItemAttrText(

5339: itemtype => itemtype,
5340: itemkey => itemkey ,
5341: aname => 'AMS_SCHEDULE_END_DATE');
5342:
5343: l_orig_csch_status := WF_ENGINE.GetItemAttrText(
5344: itemtype => itemtype,
5345: itemkey => itemkey ,
5346: aname => 'AMS_PARENT_STATUS');
5347:

Line 5348: l_orig_csch_end_date := WF_ENGINE.GetItemAttrDate(

5344: itemtype => itemtype,
5345: itemkey => itemkey ,
5346: aname => 'AMS_PARENT_STATUS');
5347:
5348: l_orig_csch_end_date := WF_ENGINE.GetItemAttrDate(
5349: itemtype => itemtype,
5350: itemkey => itemkey ,
5351: aname => 'AMS_PARENT_END_DATE');
5352:

Line 5354: l_camp_end_date := WF_ENGINE.GetItemAttrDate(

5350: itemkey => itemkey ,
5351: aname => 'AMS_PARENT_END_DATE');
5352:
5353:
5354: l_camp_end_date := WF_ENGINE.GetItemAttrDate(
5355: itemtype => itemtype,
5356: itemkey => itemkey ,
5357: aname => 'AMS_CAMPAIGN_END_DATE');
5358:

Line 5442: l_schedule_id := WF_ENGINE.GetItemAttrText(

5438: l_api_name := 'WF_REPEAT_SCHEDULER';
5439: IF (funcmode = 'RUN')
5440: THEN
5441:
5442: l_schedule_id := WF_ENGINE.GetItemAttrText(
5443: itemtype => itemtype,
5444: itemkey => itemkey ,
5445: aname => 'SCHEDULE_ID');
5446: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Schedule id ' ||l_schedule_id);

Line 5448: l_scheduler_frequency := WF_ENGINE.GetItemAttrNumber(

5444: itemkey => itemkey ,
5445: aname => 'SCHEDULE_ID');
5446: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Schedule id ' ||l_schedule_id);
5447:
5448: l_scheduler_frequency := WF_ENGINE.GetItemAttrNumber(
5449: itemtype => itemtype,
5450: itemkey => itemkey ,
5451: aname => 'AMS_SCHEDULER_FREQUENCY');
5452:

Line 5453: l_scheduler_frequency_type := WF_ENGINE.GetItemAttrText(

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 ,
5456: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');
5457:

Line 5461: l_new_last_run_date := WF_ENGINE.GetItemAttrDate(

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,
5463: itemkey => itemkey ,
5464: aname => 'AMS_SCHEDULER_NEXT_RUN_ST_DATE');
5465:

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

5478: END IF;
5479:
5480:
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:

Line 5503: WF_ENGINE.SetItemAttrDate(itemtype => itemtype,

5499: THEN
5500: WRITE_LOG(l_api_name, 'Wf_Repeat_Scheduler: Schedule_Repeat returned success for next run date for schedule id: '||l_schedule_id);
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:

Line 5511: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5507:
5508: result := 'COMPLETE:SUCCESS' ;
5509: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS
5510: THEN
5511: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5512: itemkey => itemkey,
5513: aname => 'ERROR_FLAG',
5514: avalue => 'Y');
5515: Handle_Error(p_itemtype => itemtype,

Line 5574: l_schedule_id := WF_ENGINE.GetItemAttrText(

5570: l_api_name := 'WF_REPEAT_CHECK_CREATE_CSCH';
5571: IF (funcmode = 'RUN')
5572: THEN
5573:
5574: l_schedule_id := WF_ENGINE.GetItemAttrText(
5575: itemtype => itemtype,
5576: itemkey => itemkey ,
5577: aname => 'SCHEDULE_ID');
5578: WRITE_LOG(l_api_name, 'WF_REPEAT_CHECK_CREATE_CSCH: Started for schedule id ' ||l_schedule_id);

Line 5580: l_schedule_next_run_date := WF_ENGINE.GetItemAttrDate(

5576: itemkey => itemkey ,
5577: aname => 'SCHEDULE_ID');
5578: WRITE_LOG(l_api_name, 'WF_REPEAT_CHECK_CREATE_CSCH: Started for schedule id ' ||l_schedule_id);
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:

Line 5585: l_parent_end_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 ,
5588: aname => 'AMS_PARENT_END_DATE');
5589:

Line 5590: l_campaign_end_date := WF_ENGINE.GetItemAttrDate(

5586: itemtype => itemtype,
5587: itemkey => itemkey ,
5588: aname => 'AMS_PARENT_END_DATE');
5589:
5590: l_campaign_end_date := WF_ENGINE.GetItemAttrDate(
5591: itemtype => itemtype,
5592: itemkey => itemkey ,
5593: aname => 'AMS_CAMPAIGN_END_DATE');
5594:

Line 5662: l_schedule_id := WF_ENGINE.GetItemAttrText(

5658: -- WHERE schedule_id = p_schedule_id;
5659:
5660: BEGIN
5661: l_api_name := 'WF_REPEAT_CREATE_CSCH';
5662: l_schedule_id := WF_ENGINE.GetItemAttrText(
5663: itemtype => itemtype,
5664: itemkey => itemkey ,
5665: aname => 'SCHEDULE_ID');
5666:

Line 5671: l_parent_sched_id := WF_ENGINE.GetItemAttrNumber(

5667: IF (funcmode = 'RUN')
5668: THEN
5669: WRITE_LOG(l_api_name, 'WF_REPEAT_CREATE_CSCH: Schedule id is '||l_schedule_id);
5670:
5671: l_parent_sched_id := WF_ENGINE.GetItemAttrNumber(
5672: itemtype => itemtype,
5673: itemkey => itemkey ,
5674: aname => 'AMS_ORIG_SCHEDULE_ID');
5675:

Line 5676: l_campaign_end_date := WF_ENGINE.GetItemAttrDate(

5672: itemtype => itemtype,
5673: itemkey => itemkey ,
5674: aname => 'AMS_ORIG_SCHEDULE_ID');
5675:
5676: l_campaign_end_date := WF_ENGINE.GetItemAttrDate(
5677: itemtype => itemtype,
5678: itemkey => itemkey ,
5679: aname => 'AMS_CAMPAIGN_END_DATE');
5680:

Line 5681: l_parent_end_date := WF_ENGINE.GetItemAttrDate(

5677: itemtype => itemtype,
5678: itemkey => itemkey ,
5679: aname => 'AMS_CAMPAIGN_END_DATE');
5680:
5681: l_parent_end_date := WF_ENGINE.GetItemAttrDate(
5682: itemtype => itemtype,
5683: itemkey => itemkey ,
5684: aname => 'AMS_PARENT_END_DATE');
5685:

Line 5686: l_schedule_start_date := WF_ENGINE.GetItemAttrDate(

5682: itemtype => itemtype,
5683: itemkey => itemkey ,
5684: aname => 'AMS_PARENT_END_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:

Line 5691: l_scheduler_frequency := WF_ENGINE.GetItemAttrNumber(

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 ,
5694: aname => 'AMS_SCHEDULER_FREQUENCY');
5695:

Line 5696: l_scheduler_frequency_type := WF_ENGINE.GetItemAttrText(

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 ,
5699: aname => 'AMS_SCHEDULER_FREQUENCY_TYPE');
5700:

Line 5724: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5720: x_msg_data => l_msg_data);
5721:
5722: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)
5723: THEN
5724: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5725: itemkey => itemkey,
5726: aname => 'ERROR_FLAG',
5727: avalue => 'Y');
5728: Handle_Error(p_itemtype => itemtype,

Line 5769: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5765: IF l_return_status = FND_API.G_RET_STS_SUCCESS
5766: THEN
5767: WRITE_LOG(l_api_name, 'WF_REPEAT_CREATE_CSCH: Create next schedule returned Success ');
5768:
5769: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5770: itemkey => itemkey,
5771: aname => 'AMS_NEW_SCHEDULE_ID',
5772: avalue => l_child_sched_id);
5773:

Line 5777: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

5773:
5774: result := 'COMPLETE:SUCCESS' ;
5775: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS
5776: THEN
5777: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
5778: itemkey => itemkey,
5779: aname => 'ERROR_FLAG',
5780: avalue => 'Y');
5781: Handle_Error(p_itemtype => itemtype,

Line 5839: l_schedule_id := WF_ENGINE.GetItemAttrText(

5835: BEGIN
5836: l_api_name := 'WF_REPEAT_RAISE_EVENT';
5837: IF (funcmode = 'RUN')
5838: THEN
5839: l_schedule_id := WF_ENGINE.GetItemAttrText(
5840: itemtype => itemtype,
5841: itemkey => itemkey ,
5842: aname => 'AMS_NEW_SCHEDULE_ID');
5843:

Line 5850: l_schedule_next_run_st_date := WF_ENGINE.GetItemAttrDate(itemtype => itemtype,

5846: wf_event.AddParameterToList(p_name => 'SCHEDULE_ID',
5847: p_value => l_schedule_id,
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:

Line 6195: l_schedule_id := to_number(WF_ENGINE.GetItemAttrText(

6191:
6192: -- RUN mode - Normal Process Execution
6193: IF (funcmode = 'RUN')
6194: THEN
6195: l_schedule_id := to_number(WF_ENGINE.GetItemAttrText(
6196: itemtype => itemtype,
6197: itemkey => itemkey ,
6198: aname => 'SCHEDULE_ID' ));
6199:

Line 6235: l_scheduler_frequency := to_number(WF_ENGINE.GetItemAttrText(

6231: END IF;
6232:
6233: IF ((l_triggerable_flag = 'N' AND l_trig_repeat_flag = 'Y') OR l_orig_csch_id IS NOT NULL) THEN
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

Line 6266: l_new_schedule_id := TO_NUMBER(WF_ENGINE.GetItemAttrText(

6262: result := 'COMPLETE:F';
6263: END IF;
6264: --RETURN;
6265: ELSE
6266: l_new_schedule_id := TO_NUMBER(WF_ENGINE.GetItemAttrText(
6267: itemtype => itemtype,
6268: itemkey => itemkey ,
6269: aname => 'AMS_NEW_SCHEDULE_ID'));
6270:

Line 6278: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

6274: OPEN l_new_sch_det(l_new_schedule_id);
6275: FETCH l_new_sch_det INTO l_new_schedule_name;
6276: CLOSE l_new_sch_det;
6277:
6278: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
6279: itemkey => itemkey ,
6280: aname => 'AMS_NEW_SCHEDULE_NAME',
6281: avalue => l_new_schedule_name );
6282: END IF;

Line 6283: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

6279: itemkey => itemkey ,
6280: aname => 'AMS_NEW_SCHEDULE_NAME',
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:

Line 6297: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

6293: FND_MESSAGE.Set_Name('AMS', 'AMS_ACTIVITY_PROMPT');
6294: END IF;
6295: l_msg_data := FND_MESSAGE.Get;
6296:
6297: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
6298: itemkey => itemkey ,
6299: aname => 'AMS_ACTIVITY_DESCRIPTION',
6300: avalue => l_msg_data );
6301: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 6301: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

6297: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
6298: itemkey => itemkey ,
6299: aname => 'AMS_ACTIVITY_DESCRIPTION',
6300: avalue => l_msg_data );
6301: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
6302: itemkey => itemkey ,
6303: aname => 'SOURCE_CODE',
6304: avalue => l_source_code );
6305: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

Line 6305: WF_ENGINE.SetItemAttrText(itemtype => itemtype,

6301: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
6302: itemkey => itemkey ,
6303: aname => 'SOURCE_CODE',
6304: avalue => l_source_code );
6305: WF_ENGINE.SetItemAttrText(itemtype => itemtype,
6306: itemkey => itemkey ,
6307: aname => 'AMS_CHANNEL_DESCRIPTION',
6308: avalue => l_media_name );
6309: