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.

[Home] [Help]

APPS.IEX_STRATEGY_WORK_PUB dependencies on FND_PROFILE

Line 8: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

4: /**
5: * check to see if there are any pending
6: * work items to be processed
7: **/
8: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
9: PG_DEBUG NUMBER ;
10:
11: --begin schekuri Bug#4506922 Date:02-Dec-2005
12: wf_yes varchar2(1) ;

Line 128: l_resource_id := fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE');

124: l_dun_yn varchar2(1);
125:
126: Begin
127: -- initialize variables
128: l_resource_id := fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE');
129: --Bug#4679639 schekuri 20-OCT-2005
130: --Value of profile ORG_ID should not be used for getting org_id
131: --l_org_id := fnd_profile.value('ORG_ID');
132: l_org_id := mo_global.get_current_org_id;

Line 131: --l_org_id := fnd_profile.value('ORG_ID');

127: -- initialize variables
128: l_resource_id := fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE');
129: --Bug#4679639 schekuri 20-OCT-2005
130: --Value of profile ORG_ID should not be used for getting org_id
131: --l_org_id := fnd_profile.value('ORG_ID');
132: l_org_id := mo_global.get_current_org_id;
133:
134:
135: -- IF PG_DEBUG < 10 THEN

Line 536: l_turnoff_coll_on_bankru := nvl(fnd_profile.value('IEX_TURNOFF_COLLECT_BANKRUPTCY'),'N');

532: END IF;
533: return; --end for bug 15933013
534: end if;
535:
536: l_turnoff_coll_on_bankru := nvl(fnd_profile.value('IEX_TURNOFF_COLLECT_BANKRUPTCY'),'N');
537: iex_debug_pub.logmessage ('send_mail: ' || ' - l_turnoff_coll_on_bankru: ' || l_turnoff_coll_on_bankru);
538:
539:
540: if l_turnoff_coll_on_bankru = 'Y' then

Line 614: -- l_unique_fulfillment := nvl(fnd_profile.value('IEX_STRY_UNIQUE_FULFILMENT'), 'N');

610: iex_debug_pub.logmessage ('send_mail: ' || ' after fulfil method');
611: END IF;
612: iex_debug_pub.logmessage(' Org_id value ' || l_dunning_rec.org_id);
613: -- ctlee - 5/20 create dunning record; 11/21/2002 remove checking profile error when update a non-existing record
614: -- l_unique_fulfillment := nvl(fnd_profile.value('IEX_STRY_UNIQUE_FULFILMENT'), 'N');
615: -- if (l_unique_fulfillment = 'Y') then
616: l_dunning_rec.delinquency_id := l_delinquency_id;
617: l_dunning_rec.callback_yn := ''; -- l_callback_flag;
618: l_dunning_rec.callback_date := ''; -- l_callback_date;

Line 907: avalue => sysdate+nvl(fnd_profile.value('IEX_DELIVERY_WAIT_DAYS'),0));

903: result := 'COMPLETE:'||'Y';
904: wf_engine.SetItemAttrDate(itemtype => itemtype,
905: itemkey => itemkey,
906: aname => 'DELIVERY_WAIT_TIME',
907: avalue => sysdate+nvl(fnd_profile.value('IEX_DELIVERY_WAIT_DAYS'),0));
908:
909: end if;
910: l_dunning_rec_upd.dunning_id := l_dunning_id;
911: l_dunning_rec_upd.last_update_date := sysdate;

Line 1578: l_unique_fulfillment := nvl(fnd_profile.value('IEX_STRY_UNIQUE_FULFILMENT'), 'N');

1574: return;
1575: end if;
1576: result := 'COMPLETE:' || 'N';
1577:
1578: l_unique_fulfillment := nvl(fnd_profile.value('IEX_STRY_UNIQUE_FULFILMENT'), 'N');
1579: /*
1580: if (l_unique_fulfillment = 'N') then
1581: result := 'COMPLETE:' || 'Y';
1582: return;

Line 1927: l_resource_id := fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE');

1923: l_parent_dunning_id number; -- added to fix 16433137 SNUTHALA MAR/08/2013
1924:
1925: BEGIN
1926:
1927: l_resource_id := fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE');
1928: x_status := 'F';
1929: x_request_id := 0;
1930: l_workitem_id := p_work_item_id;
1931: FOR c_rec in c_get_witem_temp(p_work_item_id)

Line 2330: -- l_unique_fulfillment := nvl(fnd_profile.value('IEX_STRY_UNIQUE_FULFILMENT'), 'N');

2326: END IF;
2327:
2328: select max(dunning_id) into l_parent_dunning_id from iex_dunnings where object_id = p_work_item_id; -- added to fix 16433137 SNUTHALA MAR/08/2013
2329: -- ctlee - 5/20 create dunning record
2330: -- l_unique_fulfillment := nvl(fnd_profile.value('IEX_STRY_UNIQUE_FULFILMENT'), 'N');
2331: -- if (l_unique_fulfillment = 'Y') then
2332: l_dunning_rec.delinquency_id := l_delinquency_id;
2333: l_dunning_rec.callback_yn := ''; -- l_callback_flag;
2334: l_dunning_rec.callback_date := ''; -- l_callback_date;

Line 2731: l_wait_days:=nvl(fnd_profile.value('IEX_DELIVERY_WAIT_DAYS'),0);

2727: result := wf_engine.eng_null;
2728: return;
2729: end if;
2730:
2731: l_wait_days:=nvl(fnd_profile.value('IEX_DELIVERY_WAIT_DAYS'),0);
2732:
2733: l_workitem_status := wf_engine.GetItemAttrText(Itemtype => itemtype,
2734: Itemkey => itemkey,
2735: aname => 'WK_STATUS');

Line 2795: IF NVL(fnd_profile.value('IEX_DELIVERY_WAIT_DAYS'),0)=0 THEN

2791:
2792: begin
2793: iex_debug_pub.logmessage('Collections **** BEGIN send_delivery_signal ************');
2794:
2795: IF NVL(fnd_profile.value('IEX_DELIVERY_WAIT_DAYS'),0)=0 THEN
2796: iex_debug_pub.logmessage('Collections **** send_delivery_signal : Value of profile IEX: Workitem waiting time in days to get delivery status is 0 ************');
2797: return;
2798: END IF;
2799:

Line 2887: IF NVL(fnd_profile.value('IEX_DELIVERY_WAIT_DAYS'),0)=0 THEN

2883:
2884: BEGIN
2885: iex_debug_pub.logmessage('Collections **** BEGIN auto_retry_notifications ************');
2886:
2887: IF NVL(fnd_profile.value('IEX_DELIVERY_WAIT_DAYS'),0)=0 THEN
2888: iex_debug_pub.logmessage('Collections **** auto_retry_notifications : Value of profile IEX: Workitem waiting time in days to get delivery status is 0 ************');
2889: return;
2890: END IF;
2891: