APPS.ENG_CHANGE_ROUTE_PEOPLE_UTIL dependencies on FND_PROFILE

Line 49: g_output_dir := FND_PROFILE.VALUE('ECX_UTL_LOG_DIR') ;

45:
46: IF g_output_dir IS NULL
47: THEN
48:
49: g_output_dir := FND_PROFILE.VALUE('ECX_UTL_LOG_DIR') ;
50:
51: END IF;
52:
53: select value

Line 570: l_fnd_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

566:
567: BEGIN
568:
569: -- Initialize Vars
570: l_fnd_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
571: l_fnd_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
572: l_language := userenv('LANG');
573:
574: -- Real code starts here

Line 571: l_fnd_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

567: BEGIN
568:
569: -- Initialize Vars
570: l_fnd_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
571: l_fnd_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
572: l_language := userenv('LANG');
573:
574: -- Real code starts here
575: -- FND_PROFILE package is not available for workflow (WF),

Line 575: -- FND_PROFILE package is not available for workflow (WF),

571: l_fnd_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
572: l_language := userenv('LANG');
573:
574: -- Real code starts here
575: -- FND_PROFILE package is not available for workflow (WF),
576: -- therefore manually set WHO column values
577: IF p_api_caller = 'WF' THEN
578: l_fnd_user_id := p_user_id;
579: l_fnd_login_id := '';