[Home] [Help]
782: BEGIN
783: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
784: iex_debug_pub.logmessage ('send_mail: cancelling all xml requests for this workitem: ' || SQLERRM );
785: END IF;
786: update iex_xml_request_histories
787: set status='CANCELLED'
788: where object_type='IEX_STRATEGY'
789: and status<>'CANCELLED'
790: and xml_request_id in (select xml_request_id
2865: cursor c_error_workitems(l_from_date date) is
2866: select wi.work_item_id work_item_id
2867: from iex_dunnings dun,
2868: iex_strategy_work_items wi,
2869: iex_xml_request_histories xrh
2870: where dun.object_id=wi.work_item_id
2871: and xrh.object_type='IEX_STRATEGY'
2872: and xrh.creation_date>=nvl(l_from_date,xrh.creation_date)
2873: and dun.xml_request_id=xrh.xml_request_id
2939: aname => 'WORKITEM_ID');
2940: if l_work_item_id is not null then
2941: begin
2942: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.DELIVERY_FAILED:updating status of xml request for work item '||l_work_item_id);
2943: update iex_xml_request_histories
2944: set status='OTHER PROCESSING FAILURE',
2945: failure_reason='Request status timed out'
2946: where object_type='IEX_STRATEGY'
2947: --and status<>'CANCELLED'
2969:
2970: result := wf_engine.eng_completed;
2971:
2972: -- Start for the bug#8435665 by PNAVEENK on 15-May-2009
2973: select failure_reason into l_failure_reason from iex_xml_request_histories where xml_request_id = (select max(xml_request_id) from
2974: iex_dunnings
2975: where object_type='IEX_STRATEGY'
2976: and object_id=l_work_item_id)
2977: and failure_reason is not null;