APPS.IEX_STRATEGY_WORK_PUB dependencies on WF_NOTIFICATION

Line 2878: select notification_id from wf_notifications

2874: and xrh.status not in ('SUCCESSFUL','SUCCESSFUL WITH WARNINGS','OPEN','CANCELLED')
2875: and wi.status_code in ('INERROR_CHECK_NOTIFY');
2876:
2877: cursor c_notification(p_context varchar2) is
2878: select notification_id from wf_notifications
2879: where message_type='IEXSTFFM'
2880: and MESSAGE_NAME='SEND FAILER MESSAGE'
2881: and status='OPEN'
2882: AND context like p_context; -- 'IEXSTFFM:14515%' ;

Line 2896: wf_notification.setattrtext ( nid => rec_notif.notification_id

2892: for rec_error_wi in c_error_workitems(p_from_date) loop
2893: iex_debug_pub.logmessage('Collections **** Before retrying notifications for work item :'||rec_error_wi.work_item_id||'************');
2894: for rec_notif in c_notification('IEXSTFFM:'||rec_error_wi.work_item_id||':%') loop
2895: begin
2896: wf_notification.setattrtext ( nid => rec_notif.notification_id
2897: , aname => 'RESULT'
2898: , avalue => 'RETRY' );
2899:
2900: WF_NOTIFICATION.respond(nid =>rec_notif.notification_id,

Line 2900: WF_NOTIFICATION.respond(nid =>rec_notif.notification_id,

2896: wf_notification.setattrtext ( nid => rec_notif.notification_id
2897: , aname => 'RESULT'
2898: , avalue => 'RETRY' );
2899:
2900: WF_NOTIFICATION.respond(nid =>rec_notif.notification_id,
2901: respond_comment=>'Response sent by IEX: Bulk XML Delivery Manager cp');
2902: exception
2903: when others then
2904: iex_debug_pub.logmessage('Collections **** Erro auto retrying notifications with id :'||rec_notif.notification_id||'************');