DBA Data[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 108: l_resource_id := fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE');

104: l_contact_destination varchar2(240); -- bug 3955222
105: l_contact_party_id number; -- bug 3955222
106: Begin
107: -- initialize variables
108: l_resource_id := fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE');
109: --Bug#4679639 schekuri 20-OCT-2005
110: --Value of profile ORG_ID should not be used for getting org_id
111: --l_org_id := fnd_profile.value('ORG_ID');
112: l_org_id := mo_global.get_current_org_id;

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

107: -- initialize variables
108: l_resource_id := fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE');
109: --Bug#4679639 schekuri 20-OCT-2005
110: --Value of profile ORG_ID should not be used for getting org_id
111: --l_org_id := fnd_profile.value('ORG_ID');
112: l_org_id := mo_global.get_current_org_id;
113:
114:
115: -- IF PG_DEBUG < 10 THEN

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

448: iex_debug_pub.logmessage ('send_mail: ' || ' after fulfil method');
449: END IF;
450:
451: -- ctlee - 5/20 create dunning record; 11/21/2002 remove checking profile error when update a non-existing record
452: -- l_unique_fulfillment := nvl(fnd_profile.value('IEX_STRY_UNIQUE_FULFILMENT'), 'N');
453: -- if (l_unique_fulfillment = 'Y') then
454: l_dunning_rec.delinquency_id := l_delinquency_id;
455: l_dunning_rec.callback_yn := ''; -- l_callback_flag;
456: l_dunning_rec.callback_date := ''; -- l_callback_date;

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

1326: return;
1327: end if;
1328: result := 'COMPLETE:' || 'N';
1329:
1330: l_unique_fulfillment := nvl(fnd_profile.value('IEX_STRY_UNIQUE_FULFILMENT'), 'N');
1331: /*
1332: if (l_unique_fulfillment = 'N') then
1333: result := 'COMPLETE:' || 'Y';
1334: return;

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

1665: l_contact_destination varchar2(240); -- bug 3955222
1666: l_contact_party_id number; -- bug 3955222
1667: BEGIN
1668:
1669: l_resource_id := fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE');
1670: x_status := 'F';
1671: x_request_id := 0;
1672: l_workitem_id := p_work_item_id;
1673: FOR c_rec in c_get_witem_temp(p_work_item_id)

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

1974: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' after fulfil method');
1975: END IF;
1976:
1977: -- ctlee - 5/20 create dunning record
1978: -- l_unique_fulfillment := nvl(fnd_profile.value('IEX_STRY_UNIQUE_FULFILMENT'), 'N');
1979: -- if (l_unique_fulfillment = 'Y') then
1980: l_dunning_rec.delinquency_id := l_delinquency_id;
1981: l_dunning_rec.callback_yn := ''; -- l_callback_flag;
1982: l_dunning_rec.callback_date := ''; -- l_callback_date;