APPS.HR_AUTH_INT dependencies on FND_LOG

Line 26: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

22:
23: --
24: BEGIN
25: --
26: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
27: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
28: MODULE => g_module || '.' || l_procedure,
29: MESSAGE => 'Entering ' || l_procedure);
30: END IF;

Line 27: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

23: --
24: BEGIN
25: --
26: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
27: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
28: MODULE => g_module || '.' || l_procedure,
29: MESSAGE => 'Entering ' || l_procedure);
30: END IF;
31:

Line 37: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

33: OPEN csr_user;
34: FETCH csr_user INTO l_user;
35: CLOSE csr_user;
36:
37: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
38: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
39: MODULE => g_module || '.' || l_procedure,
40: MESSAGE => 'sso user is ' || l_user);
41: END IF;

Line 38: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

34: FETCH csr_user INTO l_user;
35: CLOSE csr_user;
36:
37: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
38: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
39: MODULE => g_module || '.' || l_procedure,
40: MESSAGE => 'sso user is ' || l_user);
41: END IF;
42:

Line 44: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

40: MESSAGE => 'sso user is ' || l_user);
41: END IF;
42:
43: IF l_user IS NULL THEN
44: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
45: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,
46: MODULE => g_module || '.' || l_procedure,
47: MESSAGE => 'sso user is not found for user_id ' ||
48: p_user_id);

Line 45: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,

41: END IF;
42:
43: IF l_user IS NULL THEN
44: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
45: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,
46: MODULE => g_module || '.' || l_procedure,
47: MESSAGE => 'sso user is not found for user_id ' ||
48: p_user_id);
49: END IF;

Line 52: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

48: p_user_id);
49: END IF;
50: END IF;
51:
52: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
53: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
54: MODULE => g_module || '.' || l_procedure,
55: MESSAGE => 'Exiting ' || l_procedure);
56: END IF;

Line 53: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

49: END IF;
50: END IF;
51:
52: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
53: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
54: MODULE => g_module || '.' || l_procedure,
55: MESSAGE => 'Exiting ' || l_procedure);
56: END IF;
57: RETURN(l_user);

Line 86: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

82:
83: --
84: BEGIN
85: --
86: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
87: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
88: MODULE => g_module || '.' || l_procedure,
89: MESSAGE => 'Entering ' || l_procedure);
90: END IF;

Line 87: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

83: --
84: BEGIN
85: --
86: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
87: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
88: MODULE => g_module || '.' || l_procedure,
89: MESSAGE => 'Entering ' || l_procedure);
90: END IF;
91:

Line 96: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

92: OPEN csr_country;
93: FETCH csr_country INTO l_country;
94: CLOSE csr_country;
95:
96: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
97: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
98: MODULE => g_module || '.' || l_procedure,
99: MESSAGE => 'country is ' || l_country);
100: END IF;

Line 97: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

93: FETCH csr_country INTO l_country;
94: CLOSE csr_country;
95:
96: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
97: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
98: MODULE => g_module || '.' || l_procedure,
99: MESSAGE => 'country is ' || l_country);
100: END IF;
101:

Line 103: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

99: MESSAGE => 'country is ' || l_country);
100: END IF;
101:
102: IF l_country IS NULL THEN
103: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
104: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,
105: MODULE => g_module || '.' || l_procedure,
106: MESSAGE => 'No country associated with person_id ' ||
107: p_person_id);

Line 104: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,

100: END IF;
101:
102: IF l_country IS NULL THEN
103: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
104: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,
105: MODULE => g_module || '.' || l_procedure,
106: MESSAGE => 'No country associated with person_id ' ||
107: p_person_id);
108: END IF;

Line 111: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

107: p_person_id);
108: END IF;
109: END IF;
110:
111: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
112: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
113: MODULE => g_module || '.' || l_procedure,
114: MESSAGE => 'Exiting ' || l_procedure);
115: END IF;

Line 112: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

108: END IF;
109: END IF;
110:
111: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
112: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
113: MODULE => g_module || '.' || l_procedure,
114: MESSAGE => 'Exiting ' || l_procedure);
115: END IF;
116:

Line 136: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

132:
133: --
134: BEGIN
135: --
136: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
137: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
138: MODULE => g_module || '.' || l_procedure,
139: MESSAGE => 'Entering ' || l_procedure);
140: END IF;

Line 137: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

133: --
134: BEGIN
135: --
136: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
137: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
138: MODULE => g_module || '.' || l_procedure,
139: MESSAGE => 'Entering ' || l_procedure);
140: END IF;
141:

Line 144: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

140: END IF;
141:
142: l_url := fnd_profile.value('HR_AUTHORIA_URL_' || p_country);
143:
144: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
145: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
146: MODULE => g_module || '.' || l_procedure,
147: MESSAGE => 'url is ' || l_url);
148: END IF;

Line 145: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

141:
142: l_url := fnd_profile.value('HR_AUTHORIA_URL_' || p_country);
143:
144: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
145: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
146: MODULE => g_module || '.' || l_procedure,
147: MESSAGE => 'url is ' || l_url);
148: END IF;
149:

Line 150: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

146: MODULE => g_module || '.' || l_procedure,
147: MESSAGE => 'url is ' || l_url);
148: END IF;
149:
150: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
151: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
152: MODULE => g_module || '.' || l_procedure,
153: MESSAGE => 'Exiting ' || l_procedure);
154: END IF;

Line 151: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

147: MESSAGE => 'url is ' || l_url);
148: END IF;
149:
150: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
151: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
152: MODULE => g_module || '.' || l_procedure,
153: MESSAGE => 'Exiting ' || l_procedure);
154: END IF;
155:

Line 202: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

198: --
199: BEGIN
200: --
201:
202: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
203: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
204: MODULE => g_module || '.' || l_procedure,
205: MESSAGE => 'Entering ' || l_procedure);
206: END IF;

Line 203: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

199: BEGIN
200: --
201:
202: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
203: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
204: MODULE => g_module || '.' || l_procedure,
205: MESSAGE => 'Entering ' || l_procedure);
206: END IF;
207:

Line 250: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

246: l_FNAME7, l_FVAL7,
247: l_FNAME8, l_FVAL8,
248: l_FNAME9, l_FVAL9);
249:
250: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
251: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
252: MODULE => g_module || '.' || l_procedure,
253: MESSAGE => 'Exiting ' || l_procedure);
254: END IF;

Line 251: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

247: l_FNAME8, l_FVAL8,
248: l_FNAME9, l_FVAL9);
249:
250: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
251: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
252: MODULE => g_module || '.' || l_procedure,
253: MESSAGE => 'Exiting ' || l_procedure);
254: END IF;
255:

Line 303: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

299: --
300: BEGIN
301: --
302:
303: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
304: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
305: MODULE => g_module || '.' || l_procedure,
306: MESSAGE => 'Entering ' || l_procedure);
307: END IF;

Line 304: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

300: BEGIN
301: --
302:
303: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
304: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
305: MODULE => g_module || '.' || l_procedure,
306: MESSAGE => 'Entering ' || l_procedure);
307: END IF;
308:

Line 325: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

321: l_country);
322:
323: EXCEPTION
324: WHEN OTHERS THEN
325: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
326: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,
327: MODULE => g_module || '.' || l_procedure,
328: MESSAGE => 'Unable to determine SSO external ' ||
329: 'application - ' || sqlerrm);

Line 326: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,

322:
323: EXCEPTION
324: WHEN OTHERS THEN
325: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
326: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,
327: MODULE => g_module || '.' || l_procedure,
328: MESSAGE => 'Unable to determine SSO external ' ||
329: 'application - ' || sqlerrm);
330: END IF;

Line 370: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

366: l_USER_PREFS);
367:
368: EXCEPTION
369: WHEN OTHERS THEN
370: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
371: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,
372: MODULE => g_module || '.' || l_procedure,
373: MESSAGE => 'No user found, using defaults');
374: END IF;

Line 371: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,

367:
368: EXCEPTION
369: WHEN OTHERS THEN
370: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
371: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,
372: MODULE => g_module || '.' || l_procedure,
373: MESSAGE => 'No user found, using defaults');
374: END IF;
375: END;

Line 377: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

373: MESSAGE => 'No user found, using defaults');
374: END IF;
375: END;
376:
377: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
378: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
379: MODULE => g_module || '.' || l_procedure,
380: MESSAGE => 'APP_USER is ' || l_APP_USER);
381: END IF;

Line 378: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

374: END IF;
375: END;
376:
377: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
378: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
379: MODULE => g_module || '.' || l_procedure,
380: MESSAGE => 'APP_USER is ' || l_APP_USER);
381: END IF;
382:

Line 389: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

385:
386: -- create user for the first time
387: -- can not store a null password in the SSO
388: -- so user can not already exist
389: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
390: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
391: MODULE => g_module || '.' || l_procedure,
392: MESSAGE => 'creating new user');
393: END IF;

Line 390: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

386: -- create user for the first time
387: -- can not store a null password in the SSO
388: -- so user can not already exist
389: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
390: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
391: MODULE => g_module || '.' || l_procedure,
392: MESSAGE => 'creating new user');
393: END IF;
394:

Line 426: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

422: p_user_prefs => l_USER_PREFS);
423:
424: EXCEPTION
425: WHEN OTHERS THEN
426: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
427: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,
428: MODULE => g_module || '.' || l_procedure,
429: MESSAGE => 'new user error - ' || sqlerrm);
430: END IF;

Line 427: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,

423:
424: EXCEPTION
425: WHEN OTHERS THEN
426: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
427: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,
428: MODULE => g_module || '.' || l_procedure,
429: MESSAGE => 'new user error - ' || sqlerrm);
430: END IF;
431: l_error := 'Error creating new user record in SSO - ' ||

Line 467: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

463: p_fval9 => l_FVAL9,
464: p_user_prefs => l_USER_PREFS);
465: EXCEPTION
466: WHEN OTHERS THEN
467: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
468: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,
469: MODULE => g_module || '.' || l_procedure,
470: MESSAGE => 'existing user error - ' || sqlerrm);
471: END IF;

Line 468: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,

464: p_user_prefs => l_USER_PREFS);
465: EXCEPTION
466: WHEN OTHERS THEN
467: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
468: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,
469: MODULE => g_module || '.' || l_procedure,
470: MESSAGE => 'existing user error - ' || sqlerrm);
471: END IF;
472: l_error := 'Error modifying existing user record in SSO - ' ||

Line 491: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

487: IF l_error IS NOT NULL THEN
488: l_url := 'ERROR: ' || l_error;
489: END IF;
490:
491: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
492: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
493: MODULE => g_module || '.' || l_procedure,
494: MESSAGE => 'url is ' || l_url);
495: END IF;

Line 492: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

488: l_url := 'ERROR: ' || l_error;
489: END IF;
490:
491: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
492: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
493: MODULE => g_module || '.' || l_procedure,
494: MESSAGE => 'url is ' || l_url);
495: END IF;
496:

Line 497: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

493: MODULE => g_module || '.' || l_procedure,
494: MESSAGE => 'url is ' || l_url);
495: END IF;
496:
497: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
498: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
499: MODULE => g_module || '.' || l_procedure,
500: MESSAGE => 'Exiting ' || l_procedure);
501: END IF;

Line 498: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

494: MESSAGE => 'url is ' || l_url);
495: END IF;
496:
497: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
498: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
499: MODULE => g_module || '.' || l_procedure,
500: MESSAGE => 'Exiting ' || l_procedure);
501: END IF;
502:

Line 508: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

504: RETURN(l_url);
505:
506: EXCEPTION
507: WHEN OTHERS THEN
508: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
509: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,
510: MODULE => g_module || '.' || l_procedure,
511: MESSAGE => 'Error whilst determining redirection URL' ||
512: ' - ' || sqlerrm);

Line 509: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,

505:
506: EXCEPTION
507: WHEN OTHERS THEN
508: IF( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
509: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_ERROR,
510: MODULE => g_module || '.' || l_procedure,
511: MESSAGE => 'Error whilst determining redirection URL' ||
512: ' - ' || sqlerrm);
513: END IF;

Line 541: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

537:
538: --
539: BEGIN
540: --
541: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
542: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
543: MODULE => g_module || '.' || l_procedure,
544: MESSAGE => 'Entering ' || l_procedure);
545: END IF;

Line 542: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

538: --
539: BEGIN
540: --
541: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
542: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
543: MODULE => g_module || '.' || l_procedure,
544: MESSAGE => 'Entering ' || l_procedure);
545: END IF;
546:

Line 547: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

543: MODULE => g_module || '.' || l_procedure,
544: MESSAGE => 'Entering ' || l_procedure);
545: END IF;
546:
547: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
548: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
549: MODULE => g_module || '.' || l_procedure,
550: MESSAGE => 'provider is ' || p_provider);
551: END IF;

Line 548: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

544: MESSAGE => 'Entering ' || l_procedure);
545: END IF;
546:
547: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
548: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
549: MODULE => g_module || '.' || l_procedure,
550: MESSAGE => 'provider is ' || p_provider);
551: END IF;
552:

Line 553: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

549: MODULE => g_module || '.' || l_procedure,
550: MESSAGE => 'provider is ' || p_provider);
551: END IF;
552:
553: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
554: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
555: MODULE => g_module || '.' || l_procedure,
556: MESSAGE => 'page is ' || p_page);
557: END IF;

Line 554: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

550: MESSAGE => 'provider is ' || p_provider);
551: END IF;
552:
553: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
554: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
555: MODULE => g_module || '.' || l_procedure,
556: MESSAGE => 'page is ' || p_page);
557: END IF;
558:

Line 559: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

555: MODULE => g_module || '.' || l_procedure,
556: MESSAGE => 'page is ' || p_page);
557: END IF;
558:
559: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
560: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
561: MODULE => g_module || '.' || l_procedure,
562: MESSAGE => 'user_id is ' || p_user_id);
563: END IF;

Line 560: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

556: MESSAGE => 'page is ' || p_page);
557: END IF;
558:
559: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
560: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
561: MODULE => g_module || '.' || l_procedure,
562: MESSAGE => 'user_id is ' || p_user_id);
563: END IF;
564:

Line 565: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

561: MODULE => g_module || '.' || l_procedure,
562: MESSAGE => 'user_id is ' || p_user_id);
563: END IF;
564:
565: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
566: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
567: MODULE => g_module || '.' || l_procedure,
568: MESSAGE => 'page is ' || p_page);
569: END IF;

Line 566: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

562: MESSAGE => 'user_id is ' || p_user_id);
563: END IF;
564:
565: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
566: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
567: MODULE => g_module || '.' || l_procedure,
568: MESSAGE => 'page is ' || p_page);
569: END IF;
570:

Line 571: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

567: MODULE => g_module || '.' || l_procedure,
568: MESSAGE => 'page is ' || p_page);
569: END IF;
570:
571: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
572: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
573: MODULE => g_module || '.' || l_procedure,
574: MESSAGE => 'primary_obj is ' || p_primary_obj);
575: END IF;

Line 572: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

568: MESSAGE => 'page is ' || p_page);
569: END IF;
570:
571: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
572: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
573: MODULE => g_module || '.' || l_procedure,
574: MESSAGE => 'primary_obj is ' || p_primary_obj);
575: END IF;
576:

Line 600: ' Examine FND logging information for more details.';

596: END IF;
597:
598: IF l_error IS NOT NULL THEN
599: l_url := 'ERROR : APPS-47368 : ' || l_error ||
600: ' Examine FND logging information for more details.';
601: END IF;
602:
603: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
604: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

Line 603: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

599: l_url := 'ERROR : APPS-47368 : ' || l_error ||
600: ' Examine FND logging information for more details.';
601: END IF;
602:
603: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
604: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
605: MODULE => g_module || '.' || l_procedure,
606: MESSAGE => 'Exiting ' || l_procedure);
607: END IF;

Line 604: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

600: ' Examine FND logging information for more details.';
601: END IF;
602:
603: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
604: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
605: MODULE => g_module || '.' || l_procedure,
606: MESSAGE => 'Exiting ' || l_procedure);
607: END IF;
608:

Line 636: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

632:
633: --
634: BEGIN
635: --
636: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
637: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
638: MODULE => g_module || '.' || l_procedure,
639: MESSAGE => 'Entering ' || l_procedure);
640: END IF;

Line 637: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

633: --
634: BEGIN
635: --
636: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
637: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
638: MODULE => g_module || '.' || l_procedure,
639: MESSAGE => 'Entering ' || l_procedure);
640: END IF;
641:

Line 648: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

644:
645: -- need to decrypt encrypted user_id
646: l_user_id := hr_sso_utl.decrypt_ps_username(p_user_id);
647:
648: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
649: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
650: MODULE => g_module || '.' || l_procedure,
651: MESSAGE => 'decrypted person_id is ' || l_person_id);
652: END IF;

Line 649: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

645: -- need to decrypt encrypted user_id
646: l_user_id := hr_sso_utl.decrypt_ps_username(p_user_id);
647:
648: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
649: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
650: MODULE => g_module || '.' || l_procedure,
651: MESSAGE => 'decrypted person_id is ' || l_person_id);
652: END IF;
653:

Line 654: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

650: MODULE => g_module || '.' || l_procedure,
651: MESSAGE => 'decrypted person_id is ' || l_person_id);
652: END IF;
653:
654: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
655: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
656: MODULE => g_module || '.' || l_procedure,
657: MESSAGE => 'decrypted user_id is ' || l_user_id);
658: END IF;

Line 655: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

651: MESSAGE => 'decrypted person_id is ' || l_person_id);
652: END IF;
653:
654: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
655: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
656: MODULE => g_module || '.' || l_procedure,
657: MESSAGE => 'decrypted user_id is ' || l_user_id);
658: END IF;
659:

Line 668: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

664: l_person_id,
665: p_page,
666: p_primary_obj);
667:
668: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
669: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
670: MODULE => g_module || '.' || l_procedure,
671: MESSAGE => 'Exiting ' || l_procedure);
672: END IF;

Line 669: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

665: p_page,
666: p_primary_obj);
667:
668: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
669: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
670: MODULE => g_module || '.' || l_procedure,
671: MESSAGE => 'Exiting ' || l_procedure);
672: END IF;
673:

Line 695: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

691: --
692: BEGIN
693: --
694:
695: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
696: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
697: MODULE => g_module || '.' || l_procedure,
698: MESSAGE => 'Entering ' || l_procedure);
699: END IF;

Line 696: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

692: BEGIN
693: --
694:
695: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
696: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
697: MODULE => g_module || '.' || l_procedure,
698: MESSAGE => 'Entering ' || l_procedure);
699: END IF;
700:

Line 707: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

703: -- using the first 8 characters only - SSO limitation
704:
705: l_password := substrb(icx_call.encrypt3(p_person_id),1,8);
706:
707: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
708: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
709: MODULE => g_module || '.' || l_procedure,
710: MESSAGE => 'Exiting ' || l_procedure);
711: END IF;

Line 708: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

704:
705: l_password := substrb(icx_call.encrypt3(p_person_id),1,8);
706:
707: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
708: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
709: MODULE => g_module || '.' || l_procedure,
710: MESSAGE => 'Exiting ' || l_procedure);
711: END IF;
712:

Line 753: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

749: --
750: BEGIN
751: --
752:
753: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
754: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
755: MODULE => g_module || '.' || l_procedure,
756: MESSAGE => 'Entering ' || l_procedure);
757: END IF;

Line 754: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

750: BEGIN
751: --
752:
753: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
754: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
755: MODULE => g_module || '.' || l_procedure,
756: MESSAGE => 'Entering ' || l_procedure);
757: END IF;
758:

Line 772: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

768: OPEN csr_page;
769: FETCH csr_page INTO l_target_page;
770: CLOSE csr_page;
771:
772: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
773: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
774: MODULE => g_module || '.' || l_procedure,
775: MESSAGE => 'target page is ' || l_target_page);
776: END IF;

Line 773: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

769: FETCH csr_page INTO l_target_page;
770: CLOSE csr_page;
771:
772: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
773: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
774: MODULE => g_module || '.' || l_procedure,
775: MESSAGE => 'target page is ' || l_target_page);
776: END IF;
777:

Line 778: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

774: MODULE => g_module || '.' || l_procedure,
775: MESSAGE => 'target page is ' || l_target_page);
776: END IF;
777:
778: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
779: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
780: MODULE => g_module || '.' || l_procedure,
781: MESSAGE => 'Exiting ' || l_procedure);
782: END IF;

Line 779: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

775: MESSAGE => 'target page is ' || l_target_page);
776: END IF;
777:
778: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
779: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
780: MODULE => g_module || '.' || l_procedure,
781: MESSAGE => 'Exiting ' || l_procedure);
782: END IF;
783:

Line 811: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

807:
808: --
809: BEGIN
810: --
811: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
812: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
813: MODULE => g_module || '.' || l_procedure,
814: MESSAGE => 'Entering ' || l_procedure);
815: END IF;

Line 812: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

808: --
809: BEGIN
810: --
811: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
812: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
813: MODULE => g_module || '.' || l_procedure,
814: MESSAGE => 'Entering ' || l_procedure);
815: END IF;
816:

Line 831: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

827: ELSE
828: l_anchor_tag := p_plan_name;
829: END IF;
830:
831: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
832: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
833: MODULE => g_module || '.' || l_procedure,
834: MESSAGE => 'anchor tag is ' || l_anchor_tag);
835: END IF;

Line 832: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,

828: l_anchor_tag := p_plan_name;
829: END IF;
830:
831: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
832: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_STATEMENT,
833: MODULE => g_module || '.' || l_procedure,
834: MESSAGE => 'anchor tag is ' || l_anchor_tag);
835: END IF;
836:

Line 837: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

833: MODULE => g_module || '.' || l_procedure,
834: MESSAGE => 'anchor tag is ' || l_anchor_tag);
835: END IF;
836:
837: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
838: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
839: MODULE => g_module || '.' || l_procedure,
840: MESSAGE => 'Exiting ' || l_procedure);
841: END IF;

Line 838: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

834: MESSAGE => 'anchor tag is ' || l_anchor_tag);
835: END IF;
836:
837: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
838: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
839: MODULE => g_module || '.' || l_procedure,
840: MESSAGE => 'Exiting ' || l_procedure);
841: END IF;
842:

Line 849: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

845: --
846: EXCEPTION
847: --
848: WHEN others THEN
849: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
850: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
851: MODULE => g_module || '.' || l_procedure,
852: MESSAGE => 'Exiting with Exception' || l_procedure);
853: END IF;

Line 850: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

846: EXCEPTION
847: --
848: WHEN others THEN
849: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
850: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
851: MODULE => g_module || '.' || l_procedure,
852: MESSAGE => 'Exiting with Exception' || l_procedure);
853: END IF;
854: RETURN p_plan_name;

Line 901: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

897:
898: --
899: BEGIN
900: --
901: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
902: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
903: MODULE => g_module || '.' || l_procedure,
904: MESSAGE => 'Entering ' || l_procedure);
905: END IF;

Line 902: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

898: --
899: BEGIN
900: --
901: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
902: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
903: MODULE => g_module || '.' || l_procedure,
904: MESSAGE => 'Entering ' || l_procedure);
905: END IF;
906:

Line 923: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

919: IF p_plan_url IS NULL THEN
920:
921: l_hr_authoria_enabled := fnd_profile.value('HR_AUTHORIA_ENABLED');
922:
923: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
924: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
925: MODULE => g_module || '.' || l_procedure,
926: MESSAGE => 'profile HR_AUTHORIA_ENABLED is ' ||
927: l_hr_authoria_enabled);

Line 924: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

920:
921: l_hr_authoria_enabled := fnd_profile.value('HR_AUTHORIA_ENABLED');
922:
923: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
924: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
925: MODULE => g_module || '.' || l_procedure,
926: MESSAGE => 'profile HR_AUTHORIA_ENABLED is ' ||
927: l_hr_authoria_enabled);
928: END IF;

Line 933: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

929:
930: IF UPPER(l_hr_authoria_enabled) = 'Y' then
931: l_hr_kpi_agent := fnd_profile.value('HR_KPI_AGENT');
932:
933: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
934: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
935: MODULE => g_module || '.' || l_procedure,
936: MESSAGE => 'profile HR_KPI_AGENT is ' ||l_hr_kpi_agent);
937: END IF;

Line 934: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

930: IF UPPER(l_hr_authoria_enabled) = 'Y' then
931: l_hr_kpi_agent := fnd_profile.value('HR_KPI_AGENT');
932:
933: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
934: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
935: MODULE => g_module || '.' || l_procedure,
936: MESSAGE => 'profile HR_KPI_AGENT is ' ||l_hr_kpi_agent);
937: END IF;
938:

Line 942: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

938:
939: IF l_hr_kpi_agent is null then
940: l_apps_servlet_agent := fnd_profile.value('APPS_SERVLET_AGENT');
941:
942: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
943: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
944: MODULE => g_module || '.' || l_procedure,
945: MESSAGE => 'profile APPS_SERVLET_AGENT is ' ||
946: l_apps_servlet_agent);

Line 943: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

939: IF l_hr_kpi_agent is null then
940: l_apps_servlet_agent := fnd_profile.value('APPS_SERVLET_AGENT');
941:
942: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
943: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
944: MODULE => g_module || '.' || l_procedure,
945: MESSAGE => 'profile APPS_SERVLET_AGENT is ' ||
946: l_apps_servlet_agent);
947: END IF;

Line 951: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

947: END IF;
948: END IF;
949:
950: l_hr_kpi_servlet := fnd_profile.value('HR_KPI_SERVLET');
951: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
952: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
953: MODULE => g_module || '.' || l_procedure,
954: MESSAGE => 'profile HR_KPI_SERVLET is ' ||
955: l_hr_kpi_servlet);

Line 952: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

948: END IF;
949:
950: l_hr_kpi_servlet := fnd_profile.value('HR_KPI_SERVLET');
951: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
952: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
953: MODULE => g_module || '.' || l_procedure,
954: MESSAGE => 'profile HR_KPI_SERVLET is ' ||
955: l_hr_kpi_servlet);
956: END IF;

Line 960: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

956: END IF;
957:
958: l_dbc_filename := fnd_web_config.database_id;
959:
960: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
961: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
962: MODULE => g_module || '.' || l_procedure,
963: MESSAGE => 'dbc file name is ' || l_dbc_filename);
964: END IF;

Line 961: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

957:
958: l_dbc_filename := fnd_web_config.database_id;
959:
960: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
961: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
962: MODULE => g_module || '.' || l_procedure,
963: MESSAGE => 'dbc file name is ' || l_dbc_filename);
964: END IF;
965:

Line 967: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

963: MESSAGE => 'dbc file name is ' || l_dbc_filename);
964: END IF;
965:
966: l_user_id := ICX_SEC.G_USER_ID;
967: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
968: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
969: MODULE => g_module || '.' || l_procedure,
970: MESSAGE => 'user id is ' || l_user_id);
971: END IF;

Line 968: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

964: END IF;
965:
966: l_user_id := ICX_SEC.G_USER_ID;
967: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
968: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
969: MODULE => g_module || '.' || l_procedure,
970: MESSAGE => 'user id is ' || l_user_id);
971: END IF;
972:

Line 974: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

970: MESSAGE => 'user id is ' || l_user_id);
971: END IF;
972:
973: l_encrypted_user_id := hr_sso_utl.encrypt_ps_username(l_user_id);
974: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
975: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
976: MODULE => g_module || '.' || l_procedure,
977: MESSAGE => 'encryted user id is ' ||
978: l_encrypted_user_id);

Line 975: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

971: END IF;
972:
973: l_encrypted_user_id := hr_sso_utl.encrypt_ps_username(l_user_id);
974: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
975: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
976: MODULE => g_module || '.' || l_procedure,
977: MESSAGE => 'encryted user id is ' ||
978: l_encrypted_user_id);
979: END IF;

Line 982: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

978: l_encrypted_user_id);
979: END IF;
980:
981: l_encrypted_person_id := hr_sso_utl.encrypt_ps_username(p_person_id);
982: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
983: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
984: MODULE => g_module || '.' || l_procedure,
985: MESSAGE => 'encryted person id is ' ||
986: l_encrypted_person_id);

Line 983: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

979: END IF;
980:
981: l_encrypted_person_id := hr_sso_utl.encrypt_ps_username(p_person_id);
982: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
983: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
984: MODULE => g_module || '.' || l_procedure,
985: MESSAGE => 'encryted person id is ' ||
986: l_encrypted_person_id);
987: END IF;

Line 990: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

986: l_encrypted_person_id);
987: END IF;
988:
989: l_page_name := hr_auth_int.get_page(p_plip_id,p_pl_id,p_ler_id);
990: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
991: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
992: MODULE => g_module || '.' || l_procedure,
993: MESSAGE => 'authoria page name is ' || l_page_name);
994: END IF;

Line 991: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

987: END IF;
988:
989: l_page_name := hr_auth_int.get_page(p_plip_id,p_pl_id,p_ler_id);
990: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
991: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
992: MODULE => g_module || '.' || l_procedure,
993: MESSAGE => 'authoria page name is ' || l_page_name);
994: END IF;
995:

Line 998: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

994: END IF;
995:
996: l_primary_obj := to_char(p_pl_id)||'A'||to_char(p_plip_id)||','||
997: p_primary_obj_context;
998: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
999: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1000: MODULE => g_module || '.' || l_procedure,
1001: MESSAGE => 'primary object is ' || l_primary_obj);
1002: END IF;

Line 999: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

995:
996: l_primary_obj := to_char(p_pl_id)||'A'||to_char(p_plip_id)||','||
997: p_primary_obj_context;
998: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
999: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1000: MODULE => g_module || '.' || l_procedure,
1001: MESSAGE => 'primary object is ' || l_primary_obj);
1002: END IF;
1003:

Line 1027: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1023: IF l_ret_val IS NULL THEN
1024: l_ret_val := p_plan_url;
1025: END IF;
1026:
1027: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1028: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1029: MODULE => g_module || '.' || l_procedure,
1030: MESSAGE => 'return url is ' || l_ret_val);
1031: END IF;

Line 1028: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

1024: l_ret_val := p_plan_url;
1025: END IF;
1026:
1027: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1028: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1029: MODULE => g_module || '.' || l_procedure,
1030: MESSAGE => 'return url is ' || l_ret_val);
1031: END IF;
1032:

Line 1033: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1029: MODULE => g_module || '.' || l_procedure,
1030: MESSAGE => 'return url is ' || l_ret_val);
1031: END IF;
1032:
1033: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1034: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1035: MODULE => g_module || '.' || l_procedure,
1036: MESSAGE => 'Exiting ' || l_procedure);
1037: END IF;

Line 1034: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

1030: MESSAGE => 'return url is ' || l_ret_val);
1031: END IF;
1032:
1033: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1034: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1035: MODULE => g_module || '.' || l_procedure,
1036: MESSAGE => 'Exiting ' || l_procedure);
1037: END IF;
1038:

Line 1044: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1040: --
1041: EXCEPTION
1042: --
1043: WHEN others THEN
1044: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1045: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1046: MODULE => g_module || '.' || l_procedure,
1047: MESSAGE => 'Exiting with Exception' || l_procedure);
1048: END IF;

Line 1045: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

1041: EXCEPTION
1042: --
1043: WHEN others THEN
1044: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1045: FND_LOG.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1046: MODULE => g_module || '.' || l_procedure,
1047: MESSAGE => 'Exiting with Exception' || l_procedure);
1048: END IF;
1049: return p_plan_url;