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.

APPS.IEX_DUNNING_PVT dependencies on FND_PROFILE

Line 208: l_def_rel_type := nvl(fnd_profile.value('IEX_DEF_CORRESP_REL_TYPE'), 'DUNNING');

204: end if;
205:
206: WriteLog(l_api_name || ': Searching location_id, contact_id and contact_point_id the old way...');
207:
208: l_def_rel_type := nvl(fnd_profile.value('IEX_DEF_CORRESP_REL_TYPE'), 'DUNNING');
209: WriteLog(l_api_name || ': IEX_DEF_CORRESP_REL_TYPE profile value: ' || l_def_rel_type);
210:
211: if P_CONTACT_POINT_TYPE = 'PRINTER' then
212:

Line 455: l_dun_contact_level := nvl(fnd_profile.value('IEX_DUNNING_CONTACT_SELECTION_METHOD'), 'ALL'); --Added for bug 6500750 gnramasa 13-Nov-07

451: THEN
452: FND_MSG_PUB.initialize;
453: END IF;
454:
455: l_dun_contact_level := nvl(fnd_profile.value('IEX_DUNNING_CONTACT_SELECTION_METHOD'), 'ALL'); --Added for bug 6500750 gnramasa 13-Nov-07
456:
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459: WriteLog('----------' || l_api_name || '----------');

Line 789: l_dun_contact_level := nvl(fnd_profile.value('IEX_DUNNING_CONTACT_SELECTION_METHOD'), 'ALL'); --Added for bug 6500750 gnramasa 13-Nov-07

785: THEN
786: FND_MSG_PUB.initialize;
787: END IF;
788:
789: l_dun_contact_level := nvl(fnd_profile.value('IEX_DUNNING_CONTACT_SELECTION_METHOD'), 'ALL'); --Added for bug 6500750 gnramasa 13-Nov-07
790:
791: x_return_status := FND_API.G_RET_STS_SUCCESS;
792:
793: WriteLog('----------' || l_api_name || '----------');

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

4266: SAVEPOINT Send_Level_DUNNING_PVT;
4267:
4268: --Bug#4679639 schekuri 20-OCT-2005
4269: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
4270: --l_org_id := fnd_profile.value('ORG_ID');
4271: l_org_id:= mo_global.get_current_org_id;
4272: WriteLog(' org_id in send_level_dunning ' || l_org_id);
4273:
4274: -- Standard call to check for call compatibility.

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

4303: x_return_status := FND_API.G_RET_STS_SUCCESS;
4304: --
4305: -- Api body
4306: --
4307: l_turnoff_coll_on_bankru := nvl(fnd_profile.value('IEX_TURNOFF_COLLECT_BANKRUPTCY'),'N');
4308: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_turnoff_coll_on_bankru: ' || l_turnoff_coll_on_bankru);
4309:
4310: l_party_cust_id := p_delinquencies_tbl(1).party_cust_id;
4311: l_account_id := p_delinquencies_tbl(1).cust_account_id;

Line 4390: select fnd_profile.value(nvl('IEX_ALLOW_DUN_FULL_PROMISE','N')) into l_allow_send from dual; -- Added for bug#8408162

4386: close c_fully_promised_billto;
4387: end if;
4388:
4389: --End bug 7197038 gnramasa 8th july 08
4390: select fnd_profile.value(nvl('IEX_ALLOW_DUN_FULL_PROMISE','N')) into l_allow_send from dual; -- Added for bug#8408162
4391:
4392: if l_turnoff_coll_on_bankru = 'Y' then
4393: open c_no_of_bankruptcy (p_delinquencies_tbl(1).party_cust_id);
4394: fetch c_no_of_bankruptcy into l_no_of_bankruptcy;

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

5459: SAVEPOINT Send_Level_Staged_Dunning_PVT;
5460:
5461: --Bug#4679639 schekuri 20-OCT-2005
5462: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
5463: --l_org_id := fnd_profile.value('ORG_ID');
5464: l_org_id:= mo_global.get_current_org_id;
5465: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_org_id = ' || l_org_id);
5466:
5467: -- Standard call to check for call compatibility.

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

5499: x_return_status := FND_API.G_RET_STS_SUCCESS;
5500: --
5501: -- Api body
5502: --
5503: l_turnoff_coll_on_bankru := nvl(fnd_profile.value('IEX_TURNOFF_COLLECT_BANKRUPTCY'),'N');
5504: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_turnoff_coll_on_bankru: ' || l_turnoff_coll_on_bankru);
5505:
5506: l_party_cust_id := p_delinquencies_tbl(1).party_cust_id;
5507: l_account_id := p_delinquencies_tbl(1).cust_account_id;

Line 6336: l_inv_xdo_template_id := fnd_profile.value('IEX_INVOICE_FULFILLMENT_TEMPLATE');

6332: END IF;
6333: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_invoice_copies: l_invoice_copies');
6334: l_inv_xdo_template_id := null;
6335: if nvl(l_invoice_copies,'N') = 'Y' then
6336: l_inv_xdo_template_id := fnd_profile.value('IEX_INVOICE_FULFILLMENT_TEMPLATE');
6337: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Template ID for Invoice : '||l_inv_xdo_template_id);
6338:
6339: /*===========================================
6340: * Check the status of the template

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

7086: SAVEPOINT Send_DUNNING_PVT;
7087:
7088: --Bug#4679639 schekuri 20-OCT-2005
7089: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
7090: --l_org_id := fnd_profile.value('ORG_ID');
7091: l_org_id:= mo_global.get_current_org_id;
7092: WriteLog(' org_id in send dunning '|| l_org_id);
7093: -- Standard call to check for call compatibility.
7094: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

7113: --
7114: -- Api body
7115: --
7116: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - ' || p_resend_flag);
7117: l_turnoff_coll_on_bankru := nvl(fnd_profile.value('IEX_TURNOFF_COLLECT_BANKRUPTCY'),'N');
7118: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_turnoff_coll_on_bankru: ' || l_turnoff_coll_on_bankru);
7119:
7120: FOR i in 1..p_delinquencies_tbl.count
7121: LOOP

Line 7201: select fnd_profile.value(nvl('IEX_ALLOW_DUN_FULL_PROMISE','N')) into l_allow_send from dual;

7197: and pd.status='COLLECTABLE'
7198: and pd.state='PROMISE'
7199: group by pd.delinquency_id
7200: having sum(nvl(pd.promise_amount,0))>=ps.amount_due_remaining);
7201: select fnd_profile.value(nvl('IEX_ALLOW_DUN_FULL_PROMISE','N')) into l_allow_send from dual;
7202:
7203: if l_turnoff_coll_on_bankru = 'Y' then
7204: open c_no_of_bankruptcy (l_party_cust_id);
7205: fetch c_no_of_bankruptcy into l_no_of_bankruptcy;

Line 7455: l_check_dunn_profile := nvl(fnd_profile.value('IEX_CHK_DUNN_AT_FUNC_CURR'), 'Y');

7451: END IF;
7452: close C_AMOUNT;
7453:
7454: /* bug 14797201 start....
7455: l_check_dunn_profile := nvl(fnd_profile.value('IEX_CHK_DUNN_AT_FUNC_CURR'), 'Y');
7456: l_rate_type := nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'), 'Corporate');
7457:
7458: if l_check_dunn_profile = 'Y' and (l_curr_code <> l_min_currency_code) then
7459: begin

Line 7456: l_rate_type := nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'), 'Corporate');

7452: close C_AMOUNT;
7453:
7454: /* bug 14797201 start....
7455: l_check_dunn_profile := nvl(fnd_profile.value('IEX_CHK_DUNN_AT_FUNC_CURR'), 'Y');
7456: l_rate_type := nvl(fnd_profile.value('IEX_COLLECTIONS_RATE_TYPE'), 'Corporate');
7457:
7458: if l_check_dunn_profile = 'Y' and (l_curr_code <> l_min_currency_code) then
7459: begin
7460: l_convert_amount := gl_currency_api.convert_amount(

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

8287: SAVEPOINT Send_Staged_Dunning_PVT;
8288:
8289: --Bug#4679639 schekuri 20-OCT-2005
8290: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
8291: --l_org_id := fnd_profile.value('ORG_ID');
8292: l_org_id:= mo_global.get_current_org_id;
8293: WriteLog(G_PKG_NAME || ' ' || l_api_name ||' org_id in send dunning '|| l_org_id);
8294:
8295: -- Standard call to check for call compatibility.

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

8315: --
8316: -- Api body
8317: --
8318: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - ' || p_resend_flag);
8319: l_turnoff_coll_on_bankru := nvl(fnd_profile.value('IEX_TURNOFF_COLLECT_BANKRUPTCY'),'N');
8320: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - l_turnoff_coll_on_bankru: ' || l_turnoff_coll_on_bankru);
8321:
8322: l_validation_level := FND_API.G_VALID_LEVEL_FULL;
8323:

Line 8740: l_inv_xdo_template_id := fnd_profile.value('IEX_INVOICE_FULFILLMENT_TEMPLATE');

8736: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - delid='||l_delinquency_id);
8737: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - object_id='||l_delinquency_id);
8738: l_inv_xdo_template_id := null;
8739: if nvl(l_invoice_copies,'N') = 'Y' then
8740: l_inv_xdo_template_id := fnd_profile.value('IEX_INVOICE_FULFILLMENT_TEMPLATE');
8741: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Template ID for Invoice : '||l_inv_xdo_template_id);
8742:
8743: /*===========================================
8744: * Check the status of the template

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

11304: SAVEPOINT Resend_DUNNING_PVT;
11305:
11306: --Bug#4679639 schekuri 20-OCT-2005
11307: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
11308: --l_org_id := fnd_profile.value('ORG_ID');
11309: l_org_id:= mo_global.get_current_org_id;
11310:
11311: -- Standard call to check for call compatibility.
11312: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

12115: SAVEPOINT Resend_Staged_Dunning_PVT;
12116:
12117: --Bug#4679639 schekuri 20-OCT-2005
12118: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
12119: --l_org_id := fnd_profile.value('ORG_ID');
12120: l_org_id:= mo_global.get_current_org_id;
12121:
12122: -- Standard call to check for call compatibility.
12123: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 13174: l_printer := NVL(fnd_profile.value('IEX_FFM_PRINTER'), '');

13170: Close C_Get_CONTACT_EMAIL;
13171:
13172: elsif (upper(p_method) = 'PRINTER' or upper(p_method)='PRINT' ) then
13173: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Get Printer');
13174: l_printer := NVL(fnd_profile.value('IEX_FFM_PRINTER'), '');
13175: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Printer:'||l_printer);
13176: if (l_printer = '' or l_printer is null) then
13177: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
13178: IEX_DEBUG_PUB.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - No Printer');

Line 13254: l_subject := NVL(FND_PROFILE.value('IEX_FULFILL_SUBJECT'), '');

13250: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CurrUser='||FND_GLOBAL.USER_ID);
13251: l_content_nm := nIdx; -- Num of Contents you want send out NOCOPY
13252: l_user_id := FND_GLOBAL.USER_ID; --1001247; -- IEXTEST
13253: l_server_id := NULL; -- Using Default Server
13254: l_subject := NVL(FND_PROFILE.value('IEX_FULFILL_SUBJECT'), '');
13255:
13256: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - subject=;||l_subject');
13257: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CAll SEND_FFM');
13258:

Line 13628: l_subject := NVL(FND_PROFILE.value('IEX_FULFILL_SUBJECT'), '');

13624: end if;
13625:
13626: --clchang updated 07/18/2003 subject cannot be hardcoded
13627: -- bug 3058620
13628: l_subject := NVL(FND_PROFILE.value('IEX_FULFILL_SUBJECT'), '');
13629: if (l_subject is null or l_subject = '') then
13630: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No FFM Subject',0);
13631: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_SUBJECT');
13632: FND_MSG_PUB.Add;

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

14191: l_commit := p_commit;
14192:
14193: --Bug#4679639 schekuri 20-OCT-2005
14194: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
14195: --l_org_id := fnd_profile.value('ORG_ID');
14196: l_org_id:= mo_global.get_current_org_id;
14197:
14198: -- clchang added 11/08/04 for 11.5.11
14199: l_level := p_level;

Line 14280: fnd_profile.get_specific(

14276: open c_user_level_profile(l_resource_id);
14277: fetch c_user_level_profile into b_user_id;
14278: close c_user_level_profile;
14279:
14280: fnd_profile.get_specific(
14281: NAME_Z => 'IEX_FULFILL_SUBJECT',
14282: USER_ID_Z => b_user_id,
14283: RESPONSIBILITY_ID_Z=>NULL,
14284: APPLICATION_ID_Z =>NULL,

Line 14292: l_subject := NVL(FND_PROFILE.value('IEX_FULFILL_SUBJECT'), '');

14288: SERVER_ID_Z=>NULL);
14289: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' User level Fulfillment Subject Profile value: ' || l_subject);
14290:
14291: if l_subject is null then
14292: l_subject := NVL(FND_PROFILE.value('IEX_FULFILL_SUBJECT'), '');
14293: end if;
14294:
14295: -- end for bug 8916424
14296:

Line 14594: l_printer := NVL(fnd_profile.value_specific(NAME => 'IEX_PRT_IPP_PRINTER_NAME',USER_ID => l_resource_user_id),Null);

14590: --Bug5233002. Fix by LKKUMAR on 31-May-2006. Start.
14591: OPEN C_GET_RES_USER_ID;
14592: FETCH C_GET_RES_USER_ID into l_resource_user_id;
14593: CLOSE C_GET_RES_USER_ID;
14594: l_printer := NVL(fnd_profile.value_specific(NAME => 'IEX_PRT_IPP_PRINTER_NAME',USER_ID => l_resource_user_id),Null);
14595: --Bug5233002. Fix by LKKUMAR on 31-May-2006. End.
14596: IF (l_printer is null) then
14597: WriteLog(G_PKG_NAME || ' ' || l_api_name || ': Setting printer from profile');
14598: l_printer := NVL(fnd_profile.value('IEX_PRT_IPP_PRINTER_NAME'), '');

Line 14598: l_printer := NVL(fnd_profile.value('IEX_PRT_IPP_PRINTER_NAME'), '');

14594: l_printer := NVL(fnd_profile.value_specific(NAME => 'IEX_PRT_IPP_PRINTER_NAME',USER_ID => l_resource_user_id),Null);
14595: --Bug5233002. Fix by LKKUMAR on 31-May-2006. End.
14596: IF (l_printer is null) then
14597: WriteLog(G_PKG_NAME || ' ' || l_api_name || ': Setting printer from profile');
14598: l_printer := NVL(fnd_profile.value('IEX_PRT_IPP_PRINTER_NAME'), '');
14599: END IF;
14600:
14601: IF (l_printer = '' or l_printer is null) THEN
14602: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Printer',0);

Line 15262: l_printer := NVL(fnd_profile.value('IEX_FFM_PRINTER'), '');

15258: =======================================*/
15259: if instr( p_method, 'PRINT' ) > 0 then
15260: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Get Printer');
15261: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - userid= '||FND_GLOBAL.USER_ID);
15262: l_printer := NVL(fnd_profile.value('IEX_FFM_PRINTER'), '');
15263: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Printer:'||l_printer);
15264: if (l_printer = '' or l_printer is null) then
15265: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Printer');
15266: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PRINTER');

Line 16786: l_default_rs_id NUMBER := fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE');

16782: l_return_status VARCHAR2(1);
16783: l_msg_count NUMBER;
16784: l_msg_data VARCHAR2(32767);
16785: l_validation_level NUMBER ;
16786: l_default_rs_id NUMBER := fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE');
16787: l_api_version NUMBER := 1.0;
16788: l_api_name varchar2(25) := 'NEW_TASK';
16789: --fix start for bug 14036760 by sunagesh on 08-05-12
16790: l_taskname varchar2(30);

Line 17391: l_default_rs_id := fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE');

17387:
17388: BEGIN
17389:
17390: /*l_api_name := 'Get_Resource';
17391: l_default_rs_id := fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE');
17392: l_login := fnd_global.login_id;
17393: l_user := FND_GLOBAL.USER_ID;
17394:
17395: -- IF PG_DEBUG < 10 THEN

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

18073: /* Prepare the tag for the report heading */
18074: --Start adding for bug 10141904 gnramasa 24th Sep 10
18075: --l_xml_header := '';
18076: -- Instead of hard coding the value, pick the charcter set value from "ICX: Client IANA Encoding" profile.
18077: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
18078: l_xml_header := '';
18079: --End adding for bug 10141904 gnramasa 24th Sep 10
18080: l_xml_header := l_xml_header ||l_new_line||'';
18081: l_xml_header := l_xml_header ||l_new_line||' '||l_report_date||'';

Line 18189: l_template_id := fnd_profile.value('IEX_INVOICE_FULFILLMENT_TEMPLATE');

18185: */
18186:
18187: begin
18188: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Start');
18189: l_template_id := fnd_profile.value('IEX_INVOICE_FULFILLMENT_TEMPLATE');
18190: --l_send_method := NVL(fnd_profile.value('IEX_FULFILLMENT_SEND_METHOD'),'EMAIL');
18191: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Template ID for Invoice : '||l_template_id);
18192: --WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Send method : '||l_send_method);
18193:

Line 18190: --l_send_method := NVL(fnd_profile.value('IEX_FULFILLMENT_SEND_METHOD'),'EMAIL');

18186:
18187: begin
18188: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Start');
18189: l_template_id := fnd_profile.value('IEX_INVOICE_FULFILLMENT_TEMPLATE');
18190: --l_send_method := NVL(fnd_profile.value('IEX_FULFILLMENT_SEND_METHOD'),'EMAIL');
18191: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Template ID for Invoice : '||l_template_id);
18192: --WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Send method : '||l_send_method);
18193:
18194: vPLSQL1 := 'select idt.cust_trx_id, ' ||