[Home] [Help]
531:
532: if p_parent_request_id is not null then
533: l_con_req_id := p_parent_request_id;
534: else
535: l_con_req_id := FND_GLOBAL.Conc_Request_Id;
536: end if;
537:
538: -- Added for bug#8845762 by SNUTHALA on 9/14/2009
539: --Start adding for bug 10158389 gnramasa 4th Oct 10
582: ,p_object_version_number => l_user_id
583: ,p_request_id => -1
584: ,p_worker_id => -1
585: ,p_confirmation_mode => null -- added by gnramasa for bug 8489610 14-May-09
586: ,p_conc_request_id => l_con_req_id --FND_GLOBAL.Conc_Request_Id -- added by gnramasa for bug 8489610 14-May-09
587: ,p_org_id => p_org_id -- added for bug 9151851
588: ,p_template_language => lower(l_templ_lang) -- added by gnramasa for bug 8489610 28-May-09
589: ,p_template_territory => upper(l_templ_terr) -- added by gnramasa for bug 8489610 28-May-09
590: ,p_document_type => l_document_type
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
639:
640: if nvl(fnd_profile.value('IEX_USE_CUST_LANG_DUNN_LETTER'),'N') = 'N' 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: