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.IEX_STRATEGY_WORK_PUB dependencies on IEX_STRATEGY_WORK_PUB

Line 1: package body IEX_STRATEGY_WORK_PUB as

1: package body IEX_STRATEGY_WORK_PUB as
2: --$Header: iexpstmb.pls 120.33.12020000.11 2013/03/15 17:53:10 snuthala ship $
3: ----------- procedure check_work_items_completed ------------------------------
4: /**
5: * check to see if there are any pending

Line 1528: wf_core.context('IEX_STRATEGY_WORK_PUB','wf_send_signal',itemtype,

1524: -- IF PG_DEBUG < 10 THEN
1525: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1526: iex_debug_pub.logmessage('wf_send_signal: ' || 'error message is ' || l_error);
1527: END IF;
1528: wf_core.context('IEX_STRATEGY_WORK_PUB','wf_send_signal',itemtype,
1529: itemkey,to_char(actid),funcmode,l_error);
1530: raise;
1531:
1532: WHEN OTHERS THEN

Line 1534: wf_core.context('IEX_STRATEGY_WORK_PUB','wf_send_signal',itemtype,

1530: raise;
1531:
1532: WHEN OTHERS THEN
1533:
1534: wf_core.context('IEX_STRATEGY_WORK_PUB','wf_send_signal',itemtype,
1535: itemkey,to_char(actid),funcmode);
1536: raise;
1537:
1538:

Line 1779: wf_core.context('IEX_STRATEGY_WORK_PUB','check_dunning',itemtype,

1775: end if;
1776: EXCEPTION
1777: WHEN OTHERS THEN
1778: result := 'COMPLETE:' || 'N';
1779: wf_core.context('IEX_STRATEGY_WORK_PUB','check_dunning',itemtype,
1780: itemkey,to_char(actid),funcmode);
1781: raise;
1782: end check_dunning;
1783:

Line 2648: wf_core.context('IEX_STRATEGY_WORK_PUB','wait_on_hold_signal',itemtype,

2644: END IF;
2645: exception
2646: when others then
2647: result := wf_engine.eng_completed ||':'||wf_no;
2648: wf_core.context('IEX_STRATEGY_WORK_PUB','wait_on_hold_signal',itemtype,
2649: itemkey,to_char(actid),funcmode);
2650: raise;
2651:
2652: END wait_on_hold_signal;

Line 2703: wf_core.context('IEX_STRATEGY_WORK_PUB','wait_delivery_signal',itemtype,

2699: END IF;
2700: exception
2701: when others then
2702: result := wf_engine.eng_completed ||':'||wf_no;
2703: wf_core.context('IEX_STRATEGY_WORK_PUB','wait_delivery_signal',itemtype,
2704: itemkey,to_char(actid),funcmode);
2705: raise;
2706:
2707: END wait_delivery_signal;

Line 2774: wf_core.context('IEX_STRATEGY_WORK_PUB','cal_delivery_wait',itemtype,

2770: END IF;
2771: exception
2772: when others then
2773: result := wf_engine.eng_completed ||':'||wf_no;
2774: wf_core.context('IEX_STRATEGY_WORK_PUB','cal_delivery_wait',itemtype,
2775: itemkey,to_char(actid),funcmode);
2776: raise;
2777:
2778:

Line 2814: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Unable to find work item id corresponding to xml request id '||p_xml_request_id);

2810: itemkey => l_work_item_id,
2811: aname => 'ACTIVITY_NAME');
2812: EXCEPTION
2813: WHEN NO_DATA_FOUND THEN
2814: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Unable to find work item id corresponding to xml request id '||p_xml_request_id);
2815: RETURN;
2816: WHEN OTHERS THEN
2817: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Exception'|| SQLERRM ||' while finding work item id corresponding to xml request id '||p_xml_request_id);
2818: RETURN;

Line 2817: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Exception'|| SQLERRM ||' while finding work item id corresponding to xml request id '||p_xml_request_id);

2813: WHEN NO_DATA_FOUND THEN
2814: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Unable to find work item id corresponding to xml request id '||p_xml_request_id);
2815: RETURN;
2816: WHEN OTHERS THEN
2817: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Exception'|| SQLERRM ||' while finding work item id corresponding to xml request id '||p_xml_request_id);
2818: RETURN;
2819: END;
2820: iex_debug_pub.logmessage('Activity label='||l_activity_label);
2821: IF l_activity_label = 'IEXSTFFM:WAIT_DELIVERY_SIGNAL' and l_work_item_id is not null then

Line 2823: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sending Success Signal');

2819: END;
2820: iex_debug_pub.logmessage('Activity label='||l_activity_label);
2821: IF l_activity_label = 'IEXSTFFM:WAIT_DELIVERY_SIGNAL' and l_work_item_id is not null then
2822: IF p_status = 'SUCCESS' THEN
2823: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sending Success Signal');
2824: wf_engine.CompleteActivity(itemtype => 'IEXSTFFM',
2825: itemkey => l_work_item_id,
2826: activity =>l_activity_label,
2827: result =>'#DEFAULT');

Line 2828: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sent Success Signal');

2824: wf_engine.CompleteActivity(itemtype => 'IEXSTFFM',
2825: itemkey => l_work_item_id,
2826: activity =>l_activity_label,
2827: result =>'#DEFAULT');
2828: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sent Success Signal');
2829: ELSE
2830: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sending Failure Signal');
2831: wf_engine.SetItemAttrText(itemtype => 'IEXSTFFM',
2832: itemkey =>l_work_item_id,

Line 2830: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sending Failure Signal');

2826: activity =>l_activity_label,
2827: result =>'#DEFAULT');
2828: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sent Success Signal');
2829: ELSE
2830: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sending Failure Signal');
2831: wf_engine.SetItemAttrText(itemtype => 'IEXSTFFM',
2832: itemkey =>l_work_item_id,
2833: aname => 'WK_STATUS',
2834: avalue => 'INERROR');

Line 2851: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sent Failure Signal');

2847: wf_engine.CompleteActivity(itemtype => 'IEXSTFFM',
2848: itemkey => l_work_item_id,
2849: activity =>l_activity_label,
2850: result =>'#TIMEOUT');
2851: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sent Failure Signal');
2852: END IF;
2853: END IF;
2854: COMMIT;
2855: iex_debug_pub.logmessage('Collections **** END send_delivery_signal ************');

Line 2859: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:::Exception:::'||SQLERRM);

2855: iex_debug_pub.logmessage('Collections **** END send_delivery_signal ************');
2856: EXCEPTION
2857: WHEN OTHERS THEN
2858: x_error_message:='Exception:'||SQLERRM;
2859: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:::Exception:::'||SQLERRM);
2860: END SEND_DELIVERY_SIGNAL;
2861:
2862:
2863: PROCEDURE auto_retry_notifications(p_from_date in date,

Line 2915: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.auto_retry_notifications:::Exception:::'||SQLERRM);

2911: iex_debug_pub.logmessage('Collections **** END auto_retry_notifications ************');
2912: EXCEPTION
2913: WHEN OTHERS THEN
2914: x_error_message:='Exception:'||SQLERRM;
2915: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.auto_retry_notifications:::Exception:::'||SQLERRM);
2916: END auto_retry_notifications;
2917:
2918: procedure delivery_failed(
2919: itemtype in varchar2,

Line 2942: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.DELIVERY_FAILED:updating status of xml request for work item '||l_work_item_id);

2938: itemkey => itemkey,
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'

Line 2989: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.DELIVERY_FAILED:exception while updating status of xml request'||SQLERRM);

2985: -- End for the bug#8435665
2986:
2987: exception
2988: when others then
2989: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.DELIVERY_FAILED:exception while updating status of xml request'||SQLERRM);
2990: end;
2991:
2992: end if;
2993: EXCEPTION

Line 2995: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.DELIVERY_FAILED:exception'||SQLERRM);

2991:
2992: end if;
2993: EXCEPTION
2994: WHEN OTHERS THEN
2995: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.DELIVERY_FAILED:exception'||SQLERRM);
2996: result := wf_engine.eng_completed ||':'||NULL;
2997: wf_core.context('IEX_STRATEGY_WORK_PUB','delivery_failed',itemtype,
2998: itemkey,to_char(actid),funcmode);
2999: raise;

Line 2997: wf_core.context('IEX_STRATEGY_WORK_PUB','delivery_failed',itemtype,

2993: EXCEPTION
2994: WHEN OTHERS THEN
2995: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.DELIVERY_FAILED:exception'||SQLERRM);
2996: result := wf_engine.eng_completed ||':'||NULL;
2997: wf_core.context('IEX_STRATEGY_WORK_PUB','delivery_failed',itemtype,
2998: itemkey,to_char(actid),funcmode);
2999: raise;
3000: END delivery_failed;
3001:

Line 3013: end IEX_STRATEGY_WORK_PUB;

3009: wf_yes := 'Y';
3010: wf_no := 'N';
3011: --end schekuri Bug#4506922 Date:02-Dec-2005
3012:
3013: end IEX_STRATEGY_WORK_PUB;