APPS.IEX_PROMISE_RECON_RPT_PKG dependencies on FND_PROFILE

Line 175: select NVL(FND_PROFILE.value('IEX_LEASE_ENABLED'), 'N')

171: end if;
172:
173: --Start for bug 10054672 gnramasa 27th Aug 10
174: /*
175: select NVL(FND_PROFILE.value('IEX_LEASE_ENABLED'), 'N')
176: into l_ctr_enbl_flg
177: from dual;
178:
179: if l_ctr_enbl_flg='N' then

Line 190: select nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'),'N')

186: l_where :=l_where||' and ipd1.contract_id is null';
187:
188: --End for bug 10054672 gnramasa 27th Aug 10
189:
190: select nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'),'N')
191: into l_coll_rate
192: from dual;
193:
194: if l_coll_rate is null then

Line 471: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');

467: /* Prepare the tag for the report heading */
468: --Start adding for bug 10213070 snuthala 19th Oct 10
469: --l_xml_header := '';
470: -- Instead of hard coding the value, pick the charcter set value from "ICX: Client IANA Encoding" profile.
471: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
472: l_xml_header := '';
473: --End adding for bug 10213070 snuthala 19th Oct 10
474: l_xml_header := l_xml_header ||l_new_line||'';
475: l_xml_header := l_xml_header ||l_new_line||' '||l_new_line;

Line 560: select nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'),'N')

556: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
557: FND_FILE.put_line( FND_FILE.LOG,'*****Start of pmt_amt_cnt procedure***********') ;
558:
559:
560: select nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'),'N')
561: into l_coll_rate
562: from dual;
563:
564: /*if l_coll_rate is null then

Line 576: select NVL(FND_PROFILE.value('IEX_LEASE_ENABLED'), 'N')

572: end if;
573:
574: --Start for bug 10054672 gnramasa 27th Aug 10
575: /*
576: select NVL(FND_PROFILE.value('IEX_LEASE_ENABLED'), 'N')
577: into l_ctr_enbl_flg
578: from dual;
579:
580: if l_ctr_enbl_flg='N' then

Line 805: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');

801: G_LOG_ENABLED := 'N';
802: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
803:
804: /* getting msg logging info */
805: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
806: if (G_LOG_ENABLED = 'N') then
807: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
808: else
809: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

Line 809: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

805: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
806: if (G_LOG_ENABLED = 'N') then
807: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
808: else
809: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
810: end if;
811:
812: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
813: