DBA Data[Home] [Help]

APPS.IEX_STRATEGY_PUB dependencies on FND_PROFILE

Line 12: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

8:
9: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_STRATEGY_PUB';
10:
11:
12: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
13: PG_DEBUG NUMBER ;
14:
15: PROCEDURE create_strategy
16: (

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

252: --End bug 6723540 gnramasa 02 Jan 08
253:
254: l_stry_cnt_rec := IEX_STRATEGY_TYPE_PUB.INST_STRY_CNT_REC;
255:
256: l_default_rs_id := fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE');
257: l_resource_id := fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE');
258: b_Skip := 'F';
259:
260:

Line 257: l_resource_id := fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE');

253:
254: l_stry_cnt_rec := IEX_STRATEGY_TYPE_PUB.INST_STRY_CNT_REC;
255:
256: l_default_rs_id := fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE');
257: l_resource_id := fnd_profile.value('IEX_STRY_FULFILMENT_RESOURCE');
258: b_Skip := 'F';
259:
260:
261: -- Standard Start of API savepoint

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

264: -- Initialize API return status to SUCCESS
265: l_return_status := FND_API.G_RET_STS_SUCCESS;
266:
267: /*
268: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
269: return;
270: end if;
271: */
272:

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

271: */
272:
273: /* check the default profile valuse */
274: /* Check the required profiles for Strategy Concurrent before starting */
275: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
276: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
277: IEX_DEBUG_PUB.LogMessage( 'Strategy creation aborted. ' );
278: IEX_DEBUG_PUB.LogMessage( 'Strategy Disabled by Profile ');
279: END IF;

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

287: END IF;
288: b_Skip := 'T';
289: end if;
290:
291: l_StrategyTempID := NVL(to_number(FND_PROFILE.VALUE('IEX_STRATEGY_DEFAULT_TEMPLATE')), 0);
292: if (l_StrategyTempID = 0) Then
293: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
294: IEX_DEBUG_PUB.LogMessage( 'Strategy creation stopped. ' );
295: IEX_DEBUG_PUB.LogMessage( 'No Default Strategy Template Profile ');

Line 729: if fnd_profile.value('IEX_PROC_STR_ORG')='Y' then

725:
726: l_object_version_number := 1;
727:
728: --Added for Bug# 6870773 by pnaveenk
729: if fnd_profile.value('IEX_PROC_STR_ORG')='Y' then
730: --l_strategy_rec.org_id:=fnd_profile.value('ORG_ID');
731: l_strategy_rec.org_id:=mo_global.get_current_org_id;
732:
733: else

Line 730: --l_strategy_rec.org_id:=fnd_profile.value('ORG_ID');

726: l_object_version_number := 1;
727:
728: --Added for Bug# 6870773 by pnaveenk
729: if fnd_profile.value('IEX_PROC_STR_ORG')='Y' then
730: --l_strategy_rec.org_id:=fnd_profile.value('ORG_ID');
731: l_strategy_rec.org_id:=mo_global.get_current_org_id;
732:
733: else
734: l_strategy_rec.org_id:=NULL;

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

1246:
1247:
1248: -- Initialize API return status to SUCCESS
1249: l_return_status := FND_API.G_RET_STS_SUCCESS;
1250: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
1251: return;
1252: end if;
1253: l_objectType := UPPER(p_ObjectType);
1254:

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

1439: Cursor C_getFirstTempID IS
1440: Select Strategy_Temp_ID FROM IEX_STRATEGY_TEMPLATES_B where
1441: Check_List_YN = 'N';
1442: BEGIN
1443: l_StrategyTempID := NVL(to_number(FND_PROFILE.VALUE('IEX_STRATEGY_DEFAULT_TEMPLATE')), 0);
1444: if (l_StrategyTempID = 0) Then
1445: Open C_getFirstTempID;
1446: fetch C_getFirstTempID into lCursorStrategyTempID;
1447: if C_getFirstTempID%FOUND then

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

1518: fStrategyVersionNumber := 2.0;
1519: l_object_version_number := 2.0;
1520:
1521: x_return_status := 'T';
1522: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
1523: return;
1524: end if;
1525:
1526: FND_MSG_PUB.initialize;

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

1701: fStrategyVersionNumber := 2.0;
1702: l_object_version_number := 2.0;
1703:
1704: x_return_status := FND_API.G_RET_STS_SUCCESS;
1705: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
1706: return;
1707: end if;
1708: -- Standard Start of API savepoint
1709: SAVEPOINT SET_STRATEGY;

Line 1862: l_MsgLevel := NVL(to_number(FND_PROFILE.VALUE('FND_AS_MSG_LEVEL_THRESHOLD')), FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1858: BEGIN
1859: -- initialize variables
1860: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1861:
1862: l_MsgLevel := NVL(to_number(FND_PROFILE.VALUE('FND_AS_MSG_LEVEL_THRESHOLD')), FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1863: l_DefaultTempID := GetDefaultStrategyTempID;
1864: begin
1865: select decode(preference_value, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 40)
1866: into l_DefaultStrategyLevel