40:
41: IF g_output_dir IS NULL
42: THEN
43:
44: g_output_dir := FND_PROFILE.VALUE('ECX_UTL_LOG_DIR') ;
45:
46: END IF;
47:
48: select value
178:
179: BEGIN
180:
181: -- Init Vars
182: l_fnd_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
183: l_fnd_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
184: l_language := userenv('LANG');
185:
186: -- Real code starts here
179: BEGIN
180:
181: -- Init Vars
182: l_fnd_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
183: l_fnd_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
184: l_language := userenv('LANG');
185:
186: -- Real code starts here
187: -- FND_PROFILE package is not available for workflow (WF),
183: l_fnd_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
184: l_language := userenv('LANG');
185:
186: -- Real code starts here
187: -- FND_PROFILE package is not available for workflow (WF),
188: -- therefore manually set WHO column values
189: IF p_api_caller = 'WF' THEN
190: l_fnd_user_id := p_user_id;
191: l_fnd_login_id := '';