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_STRATEGY_CNT_PUB dependencies on FND_PROFILE

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

153: BEGIN
154: -- initialize variable here
155: l_api_name := 'START_WORKFLOW';
156: l_stry_cnt_rec := IEX_STRATEGY_TYPE_PUB.INST_STRY_CNT_REC;
157: l_default_rs_id := NVL(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'), 0);
158: l_resource_id := NVL(fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE'), 0);
159: b_Skip := 'F';
160: l_gracePeriod := NVL(to_number(FND_PROFILE.VALUE('IEX_STRY_GRACE_PERIOD')), 0);
161: pre_delinquency_flag := 'N';

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

154: -- initialize variable here
155: l_api_name := 'START_WORKFLOW';
156: l_stry_cnt_rec := IEX_STRATEGY_TYPE_PUB.INST_STRY_CNT_REC;
157: l_default_rs_id := NVL(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'), 0);
158: l_resource_id := NVL(fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE'), 0);
159: b_Skip := 'F';
160: l_gracePeriod := NVL(to_number(FND_PROFILE.VALUE('IEX_STRY_GRACE_PERIOD')), 0);
161: pre_delinquency_flag := 'N';
162: vCheckList := 'N';

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

156: l_stry_cnt_rec := IEX_STRATEGY_TYPE_PUB.INST_STRY_CNT_REC;
157: l_default_rs_id := NVL(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'), 0);
158: l_resource_id := NVL(fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE'), 0);
159: b_Skip := 'F';
160: l_gracePeriod := NVL(to_number(FND_PROFILE.VALUE('IEX_STRY_GRACE_PERIOD')), 0);
161: pre_delinquency_flag := 'N';
162: vCheckList := 'N';
163: l_batch_size := NVL(to_number(FND_PROFILE.VALUE('IEX_BATCH_SIZE')), 5000);
164: l_save_count := 0;

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

159: b_Skip := 'F';
160: l_gracePeriod := NVL(to_number(FND_PROFILE.VALUE('IEX_STRY_GRACE_PERIOD')), 0);
161: pre_delinquency_flag := 'N';
162: vCheckList := 'N';
163: l_batch_size := NVL(to_number(FND_PROFILE.VALUE('IEX_BATCH_SIZE')), 5000);
164: l_save_count := 0;
165: l_commit_count := 0;
166: -- Begin - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
167: l_ignore_switch := NVL(p_ignore_switch, 'N');

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

172: -- Initialize API return status to SUCCESS
173: l_return_status := FND_API.G_RET_STS_SUCCESS;
174:
175: /* Check the required profiles for Strategy Concurrent before starting */
176: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
177: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Strategy creation aborted. ' );
178: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Strategy Disabled by Profile ');
179: return;
180: end if;

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

184: write_log(FND_LOG.LEVEL_UNEXPECTED, 'No Default Strategy Run Level from IEX_APP_PREFERENCES ');
185: b_Skip := 'T';
186: end if;
187:
188: l_StrategyTempID := NVL(to_number(FND_PROFILE.VALUE('IEX_STRATEGY_DEFAULT_TEMPLATE')), 0);
189: if (l_StrategyTempID = 0) Then
190: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Strategy creation stopped. ' );
191: write_log(FND_LOG.LEVEL_UNEXPECTED, 'No Default Strategy Template Profile ');
192: b_Skip := 'T';

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

698: -- end bug 4944801 ctlee 01/18/2006
699:
700:
701: --Start bug 6794510 gnramasa 7th feb 2008
702: if (NVL(FND_PROFILE.VALUE('IEX_SKIP_DEFAULT_STRATEGY_ASSIGNMENT'), 'N') = 'Y') then
703: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
704: IEX_DEBUG_PUB.LogMessage( 'Skip Default Strategy Assignment Profile value is: Y' );
705: IEX_DEBUG_PUB.LogMessage( 'l_strategy_template_id: '|| l_strategy_template_id);
706: IEX_DEBUG_PUB.LogMessage( 'l_StrategyTempID: '|| l_StrategyTempID);

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

1037:
1038: -- Initialize API return status to SUCCESS
1039: l_return_status := FND_API.G_RET_STS_SUCCESS;
1040:
1041: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
1042: write_log(FND_LOG.LEVEL_STATEMENT,' Profile Name IEX: Strategy Disabled (IEX_STRATEGY_DISABLED) set to YES ');
1043: return;
1044: end if;
1045: -- Standard Start of API savepoint

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

1576: and tg.enabled_flag <> 'N'
1577: and trunc(sysdate) between trunc(nvl(tg.valid_from_dt,sysdate))
1578: and trunc(nvl(tg.valid_to_dt,sysdate)) );
1579: BEGIN
1580: l_StrategyTempID := NVL(to_number(FND_PROFILE.VALUE('IEX_STRATEGY_DEFAULT_TEMPLATE')), 0);
1581: if (l_StrategyTempID = 0) Then
1582: Open C_getFirstTempID;
1583: fetch C_getFirstTempID into lCursorStrategyTempID;
1584: if C_getFirstTempID%FOUND then

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

1624: fnd_file.put_line(FND_FILE.LOG,' Trace not enabled');
1625: dbms_session.set_sql_trace(FALSE);
1626: END IF;
1627: --Bug# 6870773 Naveen
1628: l_org_enabled := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');
1629: -- l_org_id := fnd_profile.value('ORG_ID');
1630: l_org_id:=p_org_id;
1631:
1632: if l_org_enabled = 'Y' then

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

1625: dbms_session.set_sql_trace(FALSE);
1626: END IF;
1627: --Bug# 6870773 Naveen
1628: l_org_enabled := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');
1629: -- l_org_id := fnd_profile.value('ORG_ID');
1630: l_org_id:=p_org_id;
1631:
1632: if l_org_enabled = 'Y' then
1633: fnd_file.put_line(FND_FILE.LOG, 'Profile for processing strategies by operating unit is On ' || ' Org Id = ' || l_org_id);

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

1868: --end Naveen
1869:
1870: BEGIN
1871: -- initialize values
1872: PG_DEBUG := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
1873: l_enabled := 'N';
1874:
1875: l_DelStatusCurrent := 'CURRENT';
1876: /* begin add for bug 4408860 - add checking CLOSE status from case delinquency */

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

1887: l_Yes := 'Y';
1888: l_No := 'N';
1889: l_StratObjectFilterType := 'IEXSTRAT';
1890:
1891: l_enabled := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
1892: if (l_enabled = 'N') then
1893: l_MsgLevel := FND_LOG.LEVEL_UNEXPECTED;
1894: else
1895: l_MsgLevel := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

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

1891: l_enabled := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
1892: if (l_enabled = 'N') then
1893: l_MsgLevel := FND_LOG.LEVEL_UNEXPECTED;
1894: else
1895: l_MsgLevel := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
1896: end if;
1897: l_DefaultTempID := GetDefaultStrategyTempID;
1898:
1899: -- Start for bug # 5487449 on 28/08/2006 by gnramasa

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

1910: fnd_file.put_line(FND_FILE.LOG, 'Default Template Name raised Exception ' || SQLCODE || ' ' || SQLERRM);
1911: END;
1912:
1913: begin
1914: l_default_rs_id := NVL(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'), 0);
1915: select SOURCE_NAME,USER_NAME
1916: into l_SourceName,l_UserName
1917: from jtf_rs_resource_extns
1918: where RESOURCE_ID=l_default_rs_id;

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

1924: -- Start for bug # 5877743 on 28/02/2007 by gnramasa
1925: begin
1926: --Begin Bug#7205287 31-Jul-2008 barathsr
1927: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Work Item Assignment Collector level from Profile (IEX: Territory Access Level) :'-- (IEX: Collector Access Level) :'
1928: || NVL(fnd_profile.value('IEX_ACCESS_LEVEL'), 'PARTY'));
1929: --End Bug#7205287 31-Jul-2008 barathsr
1930: EXCEPTION
1931: WHEN OTHERS THEN
1932: fnd_file.put_line(FND_FILE.LOG, 'Resource Name raised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);