DBA Data[Home] [Help]

APPS.IEX_DUNNING_PVT dependencies on FND_PROFILE

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

198: end if;
199:
200: WriteLog(l_api_name || ': Searching location_id, contact_id and contact_point_id the old way...');
201:
202: l_def_rel_type := nvl(fnd_profile.value('IEX_DEF_CORRESP_REL_TYPE'), 'DUNNING');
203: WriteLog(l_api_name || ': IEX_DEF_CORRESP_REL_TYPE profile value: ' || l_def_rel_type);
204:
205: if P_CONTACT_POINT_TYPE = 'PRINTER' then
206:

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

445: THEN
446: FND_MSG_PUB.initialize;
447: END IF;
448:
449: l_dun_contact_level := nvl(fnd_profile.value('IEX_DUNNING_CONTACT_SELECTION_METHOD'), 'ALL'); --Added for bug 6500750 gnramasa 13-Nov-07
450:
451: x_return_status := FND_API.G_RET_STS_SUCCESS;
452:
453: WriteLog('----------' || l_api_name || '----------');

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

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

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

3132: SAVEPOINT Send_Level_DUNNING_PVT;
3133:
3134: --Bug#4679639 schekuri 20-OCT-2005
3135: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
3136: --l_org_id := fnd_profile.value('ORG_ID');
3137: l_org_id:= mo_global.get_current_org_id;
3138:
3139:
3140: -- Standard call to check for call compatibility.

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

3842: SAVEPOINT Send_DUNNING_PVT;
3843:
3844: --Bug#4679639 schekuri 20-OCT-2005
3845: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
3846: --l_org_id := fnd_profile.value('ORG_ID');
3847: l_org_id:= mo_global.get_current_org_id;
3848:
3849: -- Standard call to check for call compatibility.
3850: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

5181: SAVEPOINT Resend_DUNNING_PVT;
5182:
5183: --Bug#4679639 schekuri 20-OCT-2005
5184: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
5185: --l_org_id := fnd_profile.value('ORG_ID');
5186: l_org_id:= mo_global.get_current_org_id;
5187:
5188: -- Standard call to check for call compatibility.
5189: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

6118: Close C_Get_CONTACT_EMAIL;
6119:
6120: elsif (upper(p_method) = 'PRINTER' or upper(p_method)='PRINT' ) then
6121: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Get Printer');
6122: l_printer := NVL(fnd_profile.value('IEX_FFM_PRINTER'), '');
6123: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Printer:'||l_printer);
6124: if (l_printer = '' or l_printer is null) then
6125: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
6126: IEX_DEBUG_PUB.LogMessage(G_PKG_NAME || ' ' || l_api_name || ' - No Printer');

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

6200: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CurrUser='||FND_GLOBAL.USER_ID);
6201: l_content_nm := nIdx; -- Num of Contents you want send out NOCOPY
6202: l_user_id := FND_GLOBAL.USER_ID; --1001247; -- IEXTEST
6203: l_server_id := NULL; -- Using Default Server
6204: l_subject := NVL(FND_PROFILE.value('IEX_FULFILL_SUBJECT'), '');
6205:
6206: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - subject=;||l_subject');
6207: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - CAll SEND_FFM');
6208:

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

6568: end if;
6569:
6570: --clchang updated 07/18/2003 subject cannot be hardcoded
6571: -- bug 3058620
6572: l_subject := NVL(FND_PROFILE.value('IEX_FULFILL_SUBJECT'), '');
6573: if (l_subject is null or l_subject = '') then
6574: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No FFM Subject',0);
6575: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_SUBJECT');
6576: FND_MSG_PUB.Add;

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

7093: l_commit := p_commit;
7094:
7095: --Bug#4679639 schekuri 20-OCT-2005
7096: --Value of profile ORG_ID shouldn't be used for getting ORG_ID after MOAC implementation
7097: --l_org_id := fnd_profile.value('ORG_ID');
7098: l_org_id:= mo_global.get_current_org_id;
7099:
7100: -- clchang added 11/08/04 for 11.5.11
7101: l_level := p_level;

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

7148: end if;
7149:
7150: --clchang updated 07/18/2003 subject cannot be hardcoded
7151: -- bug 3058620
7152: l_subject := NVL(FND_PROFILE.value('IEX_FULFILL_SUBJECT'), '');
7153: if (l_subject is null or l_subject = '') then
7154: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No XML Subject');
7155: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_SUBJECT');
7156: FND_MSG_PUB.Add;

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

7297: --Bug5233002. Fix by LKKUMAR on 31-May-2006. Start.
7298: OPEN C_GET_RES_USER_ID;
7299: FETCH C_GET_RES_USER_ID into l_resource_user_id;
7300: CLOSE C_GET_RES_USER_ID;
7301: l_printer := NVL(fnd_profile.value_specific(NAME => 'IEX_PRT_IPP_PRINTER_NAME',USER_ID => l_resource_user_id),Null);
7302: --Bug5233002. Fix by LKKUMAR on 31-May-2006. End.
7303: IF (l_printer is null) then
7304: WriteLog(G_PKG_NAME || ' ' || l_api_name || ': Setting printer from profile');
7305: l_printer := NVL(fnd_profile.value('IEX_PRT_IPP_PRINTER_NAME'), '');

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

7301: l_printer := NVL(fnd_profile.value_specific(NAME => 'IEX_PRT_IPP_PRINTER_NAME',USER_ID => l_resource_user_id),Null);
7302: --Bug5233002. Fix by LKKUMAR on 31-May-2006. End.
7303: IF (l_printer is null) then
7304: WriteLog(G_PKG_NAME || ' ' || l_api_name || ': Setting printer from profile');
7305: l_printer := NVL(fnd_profile.value('IEX_PRT_IPP_PRINTER_NAME'), '');
7306: END IF;
7307:
7308: IF (l_printer = '' or l_printer is null) THEN
7309: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Printer',0);

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

7747: =======================================*/
7748: if instr( p_method, 'PRINT' ) > 0 then
7749: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Get Printer');
7750: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - userid= '||FND_GLOBAL.USER_ID);
7751: l_printer := NVL(fnd_profile.value('IEX_FFM_PRINTER'), '');
7752: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Printer:'||l_printer);
7753: if (l_printer = '' or l_printer is null) then
7754: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - No Printer');
7755: FND_MESSAGE.Set_Name('IEX', 'IEX_SEND_FAILED_NO_PRINTER');

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

9093: l_return_status VARCHAR2(1);
9094: l_msg_count NUMBER;
9095: l_msg_data VARCHAR2(32767);
9096: l_validation_level NUMBER ;
9097: l_default_rs_id NUMBER := fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE');
9098: l_api_version NUMBER := 1.0;
9099: l_api_name varchar2(25) := 'NEW_TASK';
9100:
9101: BEGIN

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

9675:
9676: BEGIN
9677:
9678: /*l_api_name := 'Get_Resource';
9679: l_default_rs_id := fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE');
9680: l_login := fnd_global.login_id;
9681: l_user := FND_GLOBAL.USER_ID;
9682:
9683: -- IF PG_DEBUG < 10 THEN