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.

[Home] [Help]

APPS.IEX_STRATEGY_CNT_PUB dependencies on FND_PROFILE

Line 320: l_default_rs_id := NVL(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'), 0);

316: BEGIN
317: -- initialize variable here
318: l_api_name := 'START_WORKFLOW';
319: l_stry_cnt_rec := IEX_STRATEGY_TYPE_PUB.INST_STRY_CNT_REC;
320: l_default_rs_id := NVL(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'), 0);
321: l_resource_id := NVL(fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE'), 0);
322: b_Skip := 'F';
323: l_gracePeriod := NVL(to_number(FND_PROFILE.VALUE('IEX_STRY_GRACE_PERIOD')), 0);
324: pre_delinquency_flag := 'N';

Line 321: l_resource_id := NVL(fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE'), 0);

317: -- initialize variable here
318: l_api_name := 'START_WORKFLOW';
319: l_stry_cnt_rec := IEX_STRATEGY_TYPE_PUB.INST_STRY_CNT_REC;
320: l_default_rs_id := NVL(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'), 0);
321: l_resource_id := NVL(fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE'), 0);
322: b_Skip := 'F';
323: l_gracePeriod := NVL(to_number(FND_PROFILE.VALUE('IEX_STRY_GRACE_PERIOD')), 0);
324: pre_delinquency_flag := 'N';
325: vCheckList := 'N';

Line 323: l_gracePeriod := NVL(to_number(FND_PROFILE.VALUE('IEX_STRY_GRACE_PERIOD')), 0);

319: l_stry_cnt_rec := IEX_STRATEGY_TYPE_PUB.INST_STRY_CNT_REC;
320: l_default_rs_id := NVL(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'), 0);
321: l_resource_id := NVL(fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE'), 0);
322: b_Skip := 'F';
323: l_gracePeriod := NVL(to_number(FND_PROFILE.VALUE('IEX_STRY_GRACE_PERIOD')), 0);
324: pre_delinquency_flag := 'N';
325: vCheckList := 'N';
326: l_batch_size := NVL(to_number(FND_PROFILE.VALUE('IEX_BATCH_SIZE')), 5000);
327: l_save_count := 0;

Line 326: l_batch_size := NVL(to_number(FND_PROFILE.VALUE('IEX_BATCH_SIZE')), 5000);

322: b_Skip := 'F';
323: l_gracePeriod := NVL(to_number(FND_PROFILE.VALUE('IEX_STRY_GRACE_PERIOD')), 0);
324: pre_delinquency_flag := 'N';
325: vCheckList := 'N';
326: l_batch_size := NVL(to_number(FND_PROFILE.VALUE('IEX_BATCH_SIZE')), 5000);
327: l_save_count := 0;
328: l_commit_count := 0;
329: -- Begin - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
330: l_ignore_switch := NVL(p_ignore_switch, 'N');

Line 339: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then

335: -- Initialize API return status to SUCCESS
336: l_return_status := FND_API.G_RET_STS_SUCCESS;
337:
338: /* Check the required profiles for Strategy Concurrent before starting */
339: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
340: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Strategy creation aborted. ' );
341: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Strategy Disabled by Profile ');
342: return;
343: end if;

Line 351: l_StrategyTempID := NVL(to_number(FND_PROFILE.VALUE('IEX_STRATEGY_DEFAULT_TEMPLATE')), 0);

347: write_log(FND_LOG.LEVEL_UNEXPECTED, 'No Default Strategy Run Level from IEX_APP_PREFERENCES ');
348: b_Skip := 'T';
349: end if;
350:
351: l_StrategyTempID := NVL(to_number(FND_PROFILE.VALUE('IEX_STRATEGY_DEFAULT_TEMPLATE')), 0);
352: if (l_StrategyTempID = 0) Then
353: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Strategy creation stopped. ' );
354: write_log(FND_LOG.LEVEL_UNEXPECTED, 'No Default Strategy Template Profile ');
355: b_Skip := 'T';

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

817: exit;
818: end loop;
819: Close c_gracePeriod;
820: END IF;
821: l_turnoff_coll_on_bankru := nvl(fnd_profile.value('IEX_TURNOFF_COLLECT_BANKRUPTCY'),'N');
822: write_log(FND_LOG.LEVEL_PROCEDURE, 'l_turnoff_coll_on_bankru: ' || l_turnoff_coll_on_bankru);
823:
824: if l_turnoff_coll_on_bankru = 'Y' then
825: open c_no_of_bankruptcy (l_stry_cnt_rec.PARTY_CUST_ID);

Line 1042: if (NVL(FND_PROFILE.VALUE('IEX_SKIP_DEFAULT_STRATEGY_ASSIGNMENT'), 'N') = 'Y') then

1038: -- end bug 4944801 ctlee 01/18/2006
1039:
1040:
1041: --Start bug 6794510 gnramasa 7th feb 2008
1042: if (NVL(FND_PROFILE.VALUE('IEX_SKIP_DEFAULT_STRATEGY_ASSIGNMENT'), 'N') = 'Y') then
1043: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1044: IEX_DEBUG_PUB.LogMessage( 'Skip Default Strategy Assignment Profile value is: Y' );
1045: IEX_DEBUG_PUB.LogMessage( 'l_strategy_template_id: '|| l_strategy_template_id);
1046: IEX_DEBUG_PUB.LogMessage( 'l_StrategyTempID: '|| l_StrategyTempID);

Line 1543: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then

1539:
1540: -- Initialize API return status to SUCCESS
1541: l_return_status := FND_API.G_RET_STS_SUCCESS;
1542:
1543: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
1544: write_log(FND_LOG.LEVEL_STATEMENT,' Profile Name IEX: Strategy Disabled (IEX_STRATEGY_DISABLED) set to YES ');
1545: return;
1546: end if;
1547: -- Standard Start of API savepoint

Line 2194: AND DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',temgp.scoring_engine_id,'-1') =

2190: st.strategy_level = l_DefaultStrategyLevel and
2191: OBF.OBJECT_ID(+) = ST.Strategy_temp_Group_ID and
2192: OBF.OBJECT_FILTER_TYPE(+) = l_StratObjectFilterType
2193: AND st.strategy_temp_group_id = temgp.group_id -- added scoring engine filter
2194: AND DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',temgp.scoring_engine_id,'-1') =
2195: DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',p_stry_cnt_rec.score_id , '-1') -- for bug 13388975 pnaveenk
2196: and (TRUNC(SYSDATE) BETWEEN TRUNC(NVL(st.valid_from_dt, SYSDATE))
2197: AND TRUNC(NVL(st.valid_to_dt, SYSDATE)))
2198: and exists (select 1 from IEX_STRATEGY_WORK_TEMP_XREF strx

Line 2195: DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',p_stry_cnt_rec.score_id , '-1') -- for bug 13388975 pnaveenk

2191: OBF.OBJECT_ID(+) = ST.Strategy_temp_Group_ID and
2192: OBF.OBJECT_FILTER_TYPE(+) = l_StratObjectFilterType
2193: AND st.strategy_temp_group_id = temgp.group_id -- added scoring engine filter
2194: AND DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',temgp.scoring_engine_id,'-1') =
2195: DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',p_stry_cnt_rec.score_id , '-1') -- for bug 13388975 pnaveenk
2196: and (TRUNC(SYSDATE) BETWEEN TRUNC(NVL(st.valid_from_dt, SYSDATE))
2197: AND TRUNC(NVL(st.valid_to_dt, SYSDATE)))
2198: and exists (select 1 from IEX_STRATEGY_WORK_TEMP_XREF strx
2199: where strx.strategy_temp_id = st.strategy_temp_id)

Line 2221: AND DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',temgp.scoring_engine_id,'-1') =

2217: st.strategy_level = l_DefaultStrategyLevel and
2218: OBF.OBJECT_ID(+) = ST.Strategy_temp_Group_ID and
2219: OBF.OBJECT_FILTER_TYPE(+) = l_StratObjectFilterType
2220: AND st.strategy_temp_group_id = temgp.group_id -- added for bug 13388975
2221: AND DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',temgp.scoring_engine_id,'-1') =
2222: DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',p_stry_cnt_rec.score_id , '-1')
2223: and (TRUNC(SYSDATE) BETWEEN TRUNC(NVL(st.valid_from_dt, SYSDATE))
2224: AND TRUNC(NVL(st.valid_to_dt, SYSDATE)))
2225: and exists (select 1 from IEX_STRATEGY_WORK_TEMP_XREF strx

Line 2222: DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',p_stry_cnt_rec.score_id , '-1')

2218: OBF.OBJECT_ID(+) = ST.Strategy_temp_Group_ID and
2219: OBF.OBJECT_FILTER_TYPE(+) = l_StratObjectFilterType
2220: AND st.strategy_temp_group_id = temgp.group_id -- added for bug 13388975
2221: AND DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',temgp.scoring_engine_id,'-1') =
2222: DECODE(fnd_profile.value('IEX_USE_STRATEGY_SCORING'),'Y',p_stry_cnt_rec.score_id , '-1')
2223: and (TRUNC(SYSDATE) BETWEEN TRUNC(NVL(st.valid_from_dt, SYSDATE))
2224: AND TRUNC(NVL(st.valid_to_dt, SYSDATE)))
2225: and exists (select 1 from IEX_STRATEGY_WORK_TEMP_XREF strx
2226: where strx.strategy_temp_id = st.strategy_temp_id)

Line 2364: l_StrategyTempID := NVL(to_number(FND_PROFILE.VALUE('IEX_STRATEGY_DEFAULT_TEMPLATE')), 0);

2360: and tg.enabled_flag <> 'N'
2361: and trunc(sysdate) between trunc(nvl(tg.valid_from_dt,sysdate))
2362: and trunc(nvl(tg.valid_to_dt,sysdate)) );
2363: BEGIN
2364: l_StrategyTempID := NVL(to_number(FND_PROFILE.VALUE('IEX_STRATEGY_DEFAULT_TEMPLATE')), 0);
2365: if (l_StrategyTempID = 0) Then
2366: Open C_getFirstTempID;
2367: fetch C_getFirstTempID into lCursorStrategyTempID;
2368: if C_getFirstTempID%FOUND then

Line 2518: l_org_enabled := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');

2514: fnd_file.put_line(FND_FILE.LOG,' Trace not enabled');
2515: dbms_session.set_sql_trace(FALSE);
2516: END IF;
2517: --Bug# 6870773 Naveen
2518: l_org_enabled := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');
2519: -- l_org_id := fnd_profile.value('ORG_ID');
2520: l_org_id:=p_org_id;
2521:
2522: --call gen_xml_header_data_strategy to generate the xml header data

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

2515: dbms_session.set_sql_trace(FALSE);
2516: END IF;
2517: --Bug# 6870773 Naveen
2518: l_org_enabled := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');
2519: -- l_org_id := fnd_profile.value('ORG_ID');
2520: l_org_id:=p_org_id;
2521:
2522: --call gen_xml_header_data_strategy to generate the xml header data
2523: IF p_show_output ='Y' THEN

Line 3281: l_Assignment_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

3277: where resource_id = p_resource_id;
3278:
3279: begin
3280: writelog('Begin get_resource');
3281: l_Assignment_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
3282:
3283: l_default_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
3284: l_resource_id := l_default_resource_id;
3285:

Line 3283: l_default_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);

3279: begin
3280: writelog('Begin get_resource');
3281: l_Assignment_Level := NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
3282:
3283: l_default_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
3284: l_resource_id := l_default_resource_id;
3285:
3286: l_party_id := p_strategy_rec.party_id;
3287: l_cust_acct_id := p_strategy_rec.cust_account_id;

Line 3413: l_terr_acc_level := NVL(fnd_profile.value('IEX_ACCESS_LEVEL'), 'PARTY');

3409: into l_report_date
3410: from dual;
3411: writelog('gen_xml_header_data_strategy: l_report_date: ' || l_report_date);
3412:
3413: l_terr_acc_level := NVL(fnd_profile.value('IEX_ACCESS_LEVEL'), 'PARTY');
3414: writelog('gen_xml_header_data_strategy: l_terr_acc_level: ' || l_terr_acc_level);
3415:
3416: -- l_lookup_code := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');
3417: l_pro_sty_by_ou := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N'); --Added for Bug 10037019 03-Sep-2010 barathsr

Line 3416: -- l_lookup_code := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');

3412:
3413: l_terr_acc_level := NVL(fnd_profile.value('IEX_ACCESS_LEVEL'), 'PARTY');
3414: writelog('gen_xml_header_data_strategy: l_terr_acc_level: ' || l_terr_acc_level);
3415:
3416: -- l_lookup_code := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');
3417: l_pro_sty_by_ou := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N'); --Added for Bug 10037019 03-Sep-2010 barathsr
3418: writelog('gen_xml_header_data_strategy: l_pro_sty_by_ou: ' || l_pro_sty_by_ou);
3419:
3420: /* open c_get_lookup_meaning (l_lookup_code);

Line 3417: l_pro_sty_by_ou := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N'); --Added for Bug 10037019 03-Sep-2010 barathsr

3413: l_terr_acc_level := NVL(fnd_profile.value('IEX_ACCESS_LEVEL'), 'PARTY');
3414: writelog('gen_xml_header_data_strategy: l_terr_acc_level: ' || l_terr_acc_level);
3415:
3416: -- l_lookup_code := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');
3417: l_pro_sty_by_ou := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N'); --Added for Bug 10037019 03-Sep-2010 barathsr
3418: writelog('gen_xml_header_data_strategy: l_pro_sty_by_ou: ' || l_pro_sty_by_ou);
3419:
3420: /* open c_get_lookup_meaning (l_lookup_code);
3421: fetch c_get_lookup_meaning into l_pro_sty_by_ou;

Line 3424: -- l_lookup_code := NVL(FND_PROFILE.VALUE('IEX_SKIP_DEFAULT_STRATEGY_ASSIGNMENT'), 'N');

3420: /* open c_get_lookup_meaning (l_lookup_code);
3421: fetch c_get_lookup_meaning into l_pro_sty_by_ou;
3422: close c_get_lookup_meaning;*/
3423:
3424: -- l_lookup_code := NVL(FND_PROFILE.VALUE('IEX_SKIP_DEFAULT_STRATEGY_ASSIGNMENT'), 'N');
3425: l_skip_def_sty_assign:= NVL(FND_PROFILE.VALUE('IEX_SKIP_DEFAULT_STRATEGY_ASSIGNMENT'), 'N');--Added for Bug 10037019 03-Sep-2010 barathsr
3426: writelog('gen_xml_header_data_strategy: l_skip_def_sty_assign: ' || l_skip_def_sty_assign);
3427: /* open c_get_lookup_meaning (l_lookup_code);
3428: fetch c_get_lookup_meaning into l_skip_def_sty_assign;

Line 3425: l_skip_def_sty_assign:= NVL(FND_PROFILE.VALUE('IEX_SKIP_DEFAULT_STRATEGY_ASSIGNMENT'), 'N');--Added for Bug 10037019 03-Sep-2010 barathsr

3421: fetch c_get_lookup_meaning into l_pro_sty_by_ou;
3422: close c_get_lookup_meaning;*/
3423:
3424: -- l_lookup_code := NVL(FND_PROFILE.VALUE('IEX_SKIP_DEFAULT_STRATEGY_ASSIGNMENT'), 'N');
3425: l_skip_def_sty_assign:= NVL(FND_PROFILE.VALUE('IEX_SKIP_DEFAULT_STRATEGY_ASSIGNMENT'), 'N');--Added for Bug 10037019 03-Sep-2010 barathsr
3426: writelog('gen_xml_header_data_strategy: l_skip_def_sty_assign: ' || l_skip_def_sty_assign);
3427: /* open c_get_lookup_meaning (l_lookup_code);
3428: fetch c_get_lookup_meaning into l_skip_def_sty_assign;
3429: close c_get_lookup_meaning;*/

Line 3431: l_resource_id := NVL(fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE'), 0);

3427: /* open c_get_lookup_meaning (l_lookup_code);
3428: fetch c_get_lookup_meaning into l_skip_def_sty_assign;
3429: close c_get_lookup_meaning;*/
3430:
3431: l_resource_id := NVL(fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE'), 0);
3432: open c_resource_name (l_resource_id);
3433: fetch c_resource_name into l_fulfilment_rs;
3434: close c_resource_name;
3435:

Line 3496: l_grace_preiod := NVL(to_number(FND_PROFILE.VALUE('IEX_STRY_GRACE_PERIOD')), 0);

3492: end if;
3493:
3494:
3495:
3496: l_grace_preiod := NVL(to_number(FND_PROFILE.VALUE('IEX_STRY_GRACE_PERIOD')), 0);
3497:
3498: FND_FILE.put_line( FND_FILE.LOG,'Start constructing the XML Header');
3499: l_new_line := '
3500: ';

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

3505: /* Prepare the tag for the report heading */
3506: --Start adding for bug 9094791 gnramasa 17th Nov 09
3507: --l_xml_header := '';
3508: -- Instead of hard coding the value, pick the charcter set value from "ICX: Client IANA Encoding" profile.
3509: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
3510: l_xml_header := '';
3511: --End adding for bug 9094791 gnramasa 17th Nov 09
3512: l_xml_header := l_xml_header ||l_new_line||'';
3513: l_xml_header := l_xml_header ||l_new_line||' '||l_report_date||'';

Line 4175: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

4171: --End adding for bug 8630852 by gnramasa 9-July-09
4172:
4173: BEGIN
4174: -- initialize values
4175: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
4176: l_enabled := 'N';
4177:
4178: l_DelStatusCurrent := 'CURRENT';
4179: /* begin add for bug 4408860 - add checking CLOSE status from case delinquency */

Line 4194: l_enabled := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');

4190: l_Yes := 'Y';
4191: l_No := 'N';
4192: l_StratObjectFilterType := 'IEXSTRAT';
4193:
4194: l_enabled := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
4195: if (l_enabled = 'N') then
4196: l_MsgLevel := FND_LOG.LEVEL_UNEXPECTED;
4197: else
4198: l_MsgLevel := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

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

4194: l_enabled := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
4195: if (l_enabled = 'N') then
4196: l_MsgLevel := FND_LOG.LEVEL_UNEXPECTED;
4197: else
4198: l_MsgLevel := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
4199: end if;
4200: -- l_DefaultTempID := GetDefaultStrategyTempID;
4201: -- chaged for bug 9795455 pnaveenk
4202: l_DefaultTempID := NVL(TO_NUMBER(fnd_profile.value('IEX_STRATEGY_DEFAULT_TEMPLATE')),0);

Line 4202: l_DefaultTempID := NVL(TO_NUMBER(fnd_profile.value('IEX_STRATEGY_DEFAULT_TEMPLATE')),0);

4198: l_MsgLevel := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
4199: end if;
4200: -- l_DefaultTempID := GetDefaultStrategyTempID;
4201: -- chaged for bug 9795455 pnaveenk
4202: l_DefaultTempID := NVL(TO_NUMBER(fnd_profile.value('IEX_STRATEGY_DEFAULT_TEMPLATE')),0);
4203:
4204: -- Start for bug # 5487449 on 28/08/2006 by gnramasa
4205: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Default Template ID ' || l_DefaultTempID || ' Profile Name IEX: Strategy Default Template (IEX_STRATEGY_DEFAULT_TEMPLATE)');
4206: begin

Line 4220: l_default_rs_id := NVL(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'), 0);

4216: fnd_file.put_line(FND_FILE.LOG, 'Default Template Name raised Exception ' || SQLCODE || ' ' || SQLERRM);
4217: END;
4218:
4219: begin
4220: l_default_rs_id := NVL(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'), 0);
4221: select SOURCE_NAME,USER_NAME
4222: into l_SourceName,l_UserName
4223: from jtf_rs_resource_extns
4224: where RESOURCE_ID=l_default_rs_id;

Line 4234: || NVL(fnd_profile.value('IEX_ACCESS_LEVEL'), 'PARTY'));

4230: -- Start for bug # 5877743 on 28/02/2007 by gnramasa
4231: begin
4232: --Begin Bug#7205287 31-Jul-2008 barathsr
4233: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Work Item Assignment Collector level from Profile (IEX: Territory Access Level) :'-- (IEX: Collector Access Level) :'
4234: || NVL(fnd_profile.value('IEX_ACCESS_LEVEL'), 'PARTY'));
4235: --End Bug#7205287 31-Jul-2008 barathsr
4236: EXCEPTION
4237: WHEN OTHERS THEN
4238: fnd_file.put_line(FND_FILE.LOG, 'Work Item Assignment Collector level raised exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);