DBA Data[Home] [Help]

APPS.IEX_SCORE_NEW_PVT dependencies on FND_PROFILE

Line 7: --G_Debug_Level NUMBER := to_number(nvl(fnd_profile.value('IEX_DEBUG_LEVEL'), '0'));

3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_SCORE_NEW_PVT';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvscfb.pls';
7: --G_Debug_Level NUMBER := to_number(nvl(fnd_profile.value('IEX_DEBUG_LEVEL'), '0'));
8: G_Batch_Size NUMBER ;
9: PG_DEBUG NUMBER ;
10:
11: G_MIN_SCORE VARCHAR2(100);

Line 1199: l_pf_value varchar2(50) := nvl(FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL'),'');

1195: l_msg_count NUMBER;
1196:
1197: -- bug 6128024
1198: l_pf_name varchar2(100);
1199: l_pf_value varchar2(50) := nvl(FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL'),'');
1200:
1201: type score_ids is table of number index by binary_integer;
1202: l_num_score_engines score_ids;
1203:

Line 1241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Default Operating Unit : ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('DEFAULT_ORG_ID')), ' '));

1237: exception
1238: when others then l_pf_name := null;
1239: end;
1240:
1241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Default Operating Unit : ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('DEFAULT_ORG_ID')), ' '));
1242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Operating Unit: ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('ORG_ID')), ' '));
1243: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Security Profile: ' || l_pf_name);
1244: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1245: -- End bug 6128024

Line 1242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Operating Unit: ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('ORG_ID')), ' '));

1238: when others then l_pf_name := null;
1239: end;
1240:
1241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Default Operating Unit : ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('DEFAULT_ORG_ID')), ' '));
1242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Operating Unit: ' || NVL(mo_global.get_ou_name(FND_PROFILE.VALUE('ORG_ID')), ' '));
1243: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile Value MO: Security Profile: ' || l_pf_name);
1244: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1245: -- End bug 6128024
1246:

Line 2245: G_Batch_Size := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));

2241: --
2242:
2243:
2244: BEGIN
2245: G_Batch_Size := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));
2246: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2247:
2248: G_MIN_SCORE := '1';
2249: G_MAX_SCORE := '100';