DBA Data[Home] [Help]

APPS.IEX_SEND_XML_PVT dependencies on FND_PROFILE

Line 515: if nvl(fnd_profile.value('IEX_USE_CUST_LANG_DUNN_LETTER'),'N') = 'N' then

511: CLOSE C_GET_TEMPCODE;
512: WriteLog(l_msg || ' Additional Template Code = ' || l_addt_tempcode);
513: end if;
514:
515: if nvl(fnd_profile.value('IEX_USE_CUST_LANG_DUNN_LETTER'),'N') = 'N' then
516: l_templ_lang := null;
517: l_templ_terr := null;
518: else
519: --call fetch_lang_terr_of_loc to find the lang and territory of a location.

Line 526: end if; --nvl(fnd_profile.value('IEX_USE_CUST_LANG_DUNN_LETTER'),'N') = 'N' then

522: x_tmpl_lang => l_templ_lang,
523: x_tmpl_terr => l_templ_terr
524: );
525:
526: end if; --nvl(fnd_profile.value('IEX_USE_CUST_LANG_DUNN_LETTER'),'N') = 'N' then
527: --End adding for bug 8649857 gnramasa 3rd July 09
528:
529: WriteLog('Template will be processed with language, l_templ_lang :' || l_templ_lang );
530: WriteLog('Template will be processed with territory, l_templ_terr :' || l_templ_terr );

Line 629: WriteLog(l_msg || ' Delivery... ' || fnd_profile.value('IEX_DELIVER_DUNNING_LETTERS'));

625: --Start adding for bug 8489610 by gnramasa 14-May-09
626: --Don't span the IEXXMLGEN at any time for IEX: Send dunning cp. Irrespective of the IEX_DELIVER_DUNNING_LETTERS profile value,
627: --Span only bulk xml manager at the end i.e in iexpdunb.pls
628:
629: WriteLog(l_msg || ' Delivery... ' || fnd_profile.value('IEX_DELIVER_DUNNING_LETTERS'));
630: WriteLog(l_msg || ' Delivery... p_object_type ' || p_object_type);
631: WriteLog(l_msg || ' Delivery... l_parent_dunning_id ' || l_parent_dunning_id );
632:
633:

Line 634: IF (((fnd_profile.value('IEX_DELIVER_DUNNING_LETTERS')='IMMEDIATE') or

630: WriteLog(l_msg || ' Delivery... p_object_type ' || p_object_type);
631: WriteLog(l_msg || ' Delivery... l_parent_dunning_id ' || l_parent_dunning_id );
632:
633:
634: IF (((fnd_profile.value('IEX_DELIVER_DUNNING_LETTERS')='IMMEDIATE') or
635: (p_object_type not in ('PARTY' , 'IEX_ACCOUNT' , 'IEX_BILLTO' , 'IEX_DELINQUENCY','IEX_STRATEGY')) or
636: (l_parent_dunning_id IS not null)) AND -- and FND_GLOBAL.Conc_Request_Id = -1)) changed the condition to fix 16433137 SNUTHALA MAR/08/2013
637: (p_dunning_mode IS NULL)) then
638: --start added by snuthala 7442795 added if condition such that request will be submitted only if profile value is IMMEDIATE or its called from IEXRCALL

Line 640: if nvl(fnd_profile.value('IEX_USE_CUST_LANG_DUNN_LETTER'),'N') = 'N' then

636: (l_parent_dunning_id IS not null)) AND -- and FND_GLOBAL.Conc_Request_Id = -1)) changed the condition to fix 16433137 SNUTHALA MAR/08/2013
637: (p_dunning_mode IS NULL)) then
638: --start added by snuthala 7442795 added if condition such that request will be submitted only if profile value is IMMEDIATE or its called from IEXRCALL
639:
640: if nvl(fnd_profile.value('IEX_USE_CUST_LANG_DUNN_LETTER'),'N') = 'N' then
641:
642: WriteLog(l_msg || ' Send dunning with currently logged in lang...' );
643:
644: l_submit_request_id := FND_REQUEST.SUBMIT_REQUEST(

Line 674: end if; --if (FND_GLOBAL.Conc_Request_Id = -1) or (fnd_profile.value('IEX_DELIVER_DUNNING_LETTERS')='IMMEDIATE') then

670: ARGUMENT5 => l_tempcode,
671: ARGUMENT6 => lower(l_templ_lang),
672: ARGUMENT7 => upper(l_templ_terr));
673: end if; --profile value lang
674: end if; --if (FND_GLOBAL.Conc_Request_Id = -1) or (fnd_profile.value('IEX_DELIVER_DUNNING_LETTERS')='IMMEDIATE') then
675: --End adding for bug 8489610 by gnramasa 14-May-09
676:
677: COMMIT;
678: