eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_LDAP_USER dependencies on FND_MESSAGE

Line 38: -- Will attempt to translate the sqlerrms from an dbms_ldap operation into a FND message

34: -------------------------------------------------------------------------------
35: --- REMOVED
36: -- function add_uniquemember(p_ldap_user in fnd_ldap_util.ldap_user_type) return pls_integer is
37: -- translate_ldap_error: Internal
38: -- Will attempt to translate the sqlerrms from an dbms_ldap operation into a FND message
39:
40: -------------------------------------------------------------------------------
41:
42: procedure delete_user(ldapSession in dbms_ldap.session, p_user_guid in fnd_user.user_guid%type ,

Line 277: fnd_message.set_name ('FND', 'FND_SSO_USER_NOT_FOUND');

273: end if;
274:
275: exception
276: when no_such_user_exp then
277: fnd_message.set_name ('FND', 'FND_SSO_USER_NOT_FOUND');
278: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
279: then
280: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
281: end if;

Line 284: fnd_message.set_name ('FND', 'FND_SSO_UNEXP_ERROR');

280: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
281: end if;
282: x_result := fnd_ldap_util.G_FAILURE;
283: when others then
284: fnd_message.set_name ('FND', 'FND_SSO_UNEXP_ERROR');
285: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
286: then
287: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
288: end if;

Line 517: fnd_message.set_name ('FND', 'FND_SSO_INVALID_NEW_USER_NAME');

513: end if;
514:
515: exception
516: when invalid_new_user_exp then
517: fnd_message.set_name ('FND', 'FND_SSO_INVALID_NEW_USER_NAME');
518: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
519: then
520: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
521: end if;

Line 524: fnd_message.set_name ('FND', 'FND_SSO_USER_NOT_FOUND');

520: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
521: end if;
522: x_result := fnd_ldap_util.G_FAILURE;
523: when no_such_user_exp then
524: fnd_message.set_name ('FND', 'FND_SSO_USER_NOT_FOUND');
525: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
526: then
527: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
528: end if;

Line 531: fnd_message.set_name ('FND', 'FND_SSO_UNEXP_ERROR');

527: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
528: end if;
529: x_result := fnd_ldap_util.G_FAILURE;
530: when others then
531: fnd_message.set_name ('FND', 'FND_SSO_UNEXP_ERROR');
532: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
533: then
534: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
535: end if;

Line 659: fnd_message.set_name ('FND', 'FND_SSO_USER_EXISTS');

655:
656: end if;
657:
658: else
659: fnd_message.set_name ('FND', 'FND_SSO_USER_EXISTS');
660: end if;
661:
662: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
663: then

Line 1256: fnd_message.set_name ('FND', 'FND_SSO_USER_NOT_FOUND');

1252: end if;
1253:
1254: exception
1255: when no_such_user_exp then
1256: fnd_message.set_name ('FND', 'FND_SSO_USER_NOT_FOUND');
1257: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1258: then
1259: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1260: end if;

Line 1263: fnd_message.set_name ('FND', 'FND_SSO_UNEXP_ERROR');

1259: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1260: end if;
1261: x_result := fnd_ldap_util.G_FAILURE;
1262: when others then
1263: fnd_message.set_name ('FND', 'FND_SSO_UNEXP_ERROR');
1264: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1265: then
1266: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1267: end if;

Line 1548: fnd_message.set_name('FND', 'FND_SSO_USER_NOT_FOUND');

1544: end if;
1545:
1546: -- user does not exist in OID
1547: else
1548: fnd_message.set_name('FND', 'FND_SSO_USER_NOT_FOUND');
1549: x_result := fnd_ldap_util.G_FAILURE;
1550: end if;
1551:
1552: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 1756: fnd_message.set_name('FND', 'FND_SSO_USER_NOT_FOUND');

1752: x_result := delete_uniquemember(l_ldap_session, p_user_guid);
1753:
1754: -- user does not exist in OID
1755: else
1756: fnd_message.set_name('FND', 'FND_SSO_USER_NOT_FOUND');
1757: x_result := fnd_ldap_util.G_FAILURE;
1758: end if;
1759:
1760: -- other users linked

Line 1769: fnd_message.set_name ('FND', 'FND_SSO_USER_MULT_LINKED');

1765: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Other FND users linked to this OID User');
1766: end if;
1767:
1768: x_result := fnd_ldap_util.G_FAILURE;
1769: fnd_message.set_name ('FND', 'FND_SSO_USER_MULT_LINKED');
1770:
1771: end if;
1772: if ( l_ldap_session is not null) then fnd_ldap_util.c_unbind(l_ldap_session,dummy); end if ;
1773: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 1955: fnd_message.set_name ('FND', 'FND_SSO_USER_NOT_FOUND');

1951: end if;
1952:
1953: exception
1954: when no_such_user_exp then
1955: fnd_message.set_name ('FND', 'FND_SSO_USER_NOT_FOUND');
1956: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1957: then
1958: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1959: end if;

Line 1962: fnd_message.set_name ('FND', 'FND_SSO_UNEXP_ERROR');

1958: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1959: end if;
1960: x_result := fnd_ldap_util.G_FAILURE;
1961: when others then
1962: fnd_message.set_name ('FND', 'FND_SSO_UNEXP_ERROR');
1963: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1964: then
1965: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
1966: end if;

Line 2118: fnd_message.set_name ('FND', 'FND_SSO_USER_NOT_FOUND');

2114: end if;
2115:
2116: exception
2117: when no_such_user_exp then
2118: fnd_message.set_name ('FND', 'FND_SSO_USER_NOT_FOUND');
2119: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2120: then
2121: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
2122: end if;

Line 2125: fnd_message.set_name ('FND', 'FND_SSO_UNEXP_ERROR');

2121: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
2122: end if;
2123: x_result := fnd_ldap_util.G_FAILURE;
2124: when others then
2125: fnd_message.set_name ('FND', 'FND_SSO_UNEXP_ERROR');
2126: if (fnd_log.LEVEL_ERROR >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2127: then
2128: fnd_log.string(fnd_log.LEVEL_ERROR, l_module_source, sqlerrm);
2129: end if;

Line 2492: fnd_message.set_name('FND','FND_SSO_USER_PASSWD_EMPTY');

2488: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'Username: '||p_user_name);
2489: end if;
2490:
2491: if (p_user_name is null or p_password is null ) then
2492: fnd_message.set_name('FND','FND_SSO_USER_PASSWD_EMPTY');
2493: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2494: then
2495: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'END: refusing to validate empty username and/or password');
2496: end if;

Line 2508: fnd_message.set_name('FND','FND_SSO_NOT_LINKED');

2504: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2505: then
2506: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'END: Null guid in FND_USER for: '||p_user_name);
2507: end if;
2508: fnd_message.set_name('FND','FND_SSO_NOT_LINKED');
2509: return fnd_ldap_util.G_FAILURE;
2510: end if;
2511: exception when no_data_found then
2512: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 2516: fnd_message.set_name('FND','FND_SSO_LOGIN_FAILED'); -- do no disclusre the real causeL

2512: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2513: then
2514: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END: user not found');
2515: end if;
2516: fnd_message.set_name('FND','FND_SSO_LOGIN_FAILED'); -- do no disclusre the real causeL
2517: return fnd_ldap_util.G_FAILURE;
2518: when others then
2519: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2520: then

Line 2523: fnd_message.set_name('FND','FND-9914'); -- unexpected error

2519: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2520: then
2521: fnd_log.string(fnd_log.LEVEL_UNEXPECTED ,l_module_source, 'END with exception: '||sqlcode||'-'||sqlerrm);
2522: end if;
2523: fnd_message.set_name('FND','FND-9914'); -- unexpected error
2524: return fnd_ldap_util.G_FAILURE;
2525: end;
2526:
2527: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 2541: fnd_message.set_name('FND','FND_SSO_USER_NOT_FOUND'); -- Carefull, this is INVALID GUID message, wrong acronym though

2537: if (fnd_log.LEVEL_UNEXPECTED >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2538: then
2539: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'Guid['||l_user_guid||'] for '||p_user_name||' is not a valid guid');
2540: end if;
2541: fnd_message.set_name('FND','FND_SSO_USER_NOT_FOUND'); -- Carefull, this is INVALID GUID message, wrong acronym though
2542: return fnd_ldap_util.G_FAILURE;
2543: end;
2544:
2545: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 2561: fnd_message.set_name('FND','FND-9903'); -- OID setup is incomplete

2557: then
2558: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'Invalid OiD Setup: host:'||l_host||' port:'||l_port);
2559: end if;
2560:
2561: fnd_message.set_name('FND','FND-9903'); -- OID setup is incomplete
2562: return fnd_ldap_util.G_FAILURE;
2563: end if;
2564:
2565: l_ldap_auth := fnd_preference.get(FND_LDAP_UTIL.G_INTERNAL, FND_LDAP_UTIL.G_LDAP_SYNCH, FND_LDAP_UTIL.G_DBLDAPAUTHLEVEL);

Line 2577: fnd_message.set_name('FND','FND-9903'); -- OID setup is incomplete

2573: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'Invalid Wallet Setup: authLEvel:'
2574: ||l_ldap_auth||' url:'||l_db_wlt_url||' pwd:'||l_db_wlt_url);
2575: end if;
2576:
2577: fnd_message.set_name('FND','FND-9903'); -- OID setup is incomplete
2578: return fnd_ldap_util.G_FAILURE;
2579: end if;
2580: else
2581: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 2597: fnd_message.set_name('FND','FND_SSO_SYSTEM_NOT_AVAIL');

2593: if (fnd_log.LEVEL_UNEXPECTED>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2594: then
2595: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'Cannot contact OID (init failed) at '||l_host||':'||l_port||':'||sqlcode||'-'||sqlerrm);
2596: end if;
2597: fnd_message.set_name('FND','FND_SSO_SYSTEM_NOT_AVAIL');
2598: return fnd_ldap_util.G_FAILURE;
2599: when others then
2600: raise;
2601: end;

Line 2613: fnd_message.set_name('FND','FND_SSO_INV_AUTH_MODE'); -- Invalid SSL authcode... it is enouggh description

2609: then
2610: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source,' Cannot establish SSL channel to OiD: '||sqlcode||'-'||sqlerrm);
2611: end if;
2612:
2613: fnd_message.set_name('FND','FND_SSO_INV_AUTH_MODE'); -- Invalid SSL authcode... it is enouggh description
2614: return fnd_ldap_util.G_FAILURE;
2615: end;
2616:
2617: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 2636: fnd_message.set_name('FND','FND_SSO_PASSWORD_EXPIRED'); --Your account is locked

2632: l_message := sqlerrm;
2633: -- first we check if the password is real,
2634:
2635: if (instr(l_message,':9000:')>0 )then
2636: fnd_message.set_name('FND','FND_SSO_PASSWORD_EXPIRED'); --Your account is locked
2637: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2638: then
2639: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'OiD account password expired ');
2640: end if;

Line 2642: fnd_message.set_name('FND','FND_SSO_LOCKED'); --Your account is locked

2638: then
2639: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'OiD account password expired ');
2640: end if;
2641: elsif (instr(l_message,':9001:')>0 )then
2642: fnd_message.set_name('FND','FND_SSO_LOCKED'); --Your account is locked
2643: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2644: then
2645: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'OiD account locked');
2646: end if;

Line 2659: fnd_message.set_name('FND','FND_SSO_USER_DISABLED'); --Your account is disabled

2655: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2656: then
2657: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'OiD account is disabled');
2658: end if;
2659: fnd_message.set_name('FND','FND_SSO_USER_DISABLED'); --Your account is disabled
2660: elsif (instr(l_message,':9053:')>0) then
2661: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2662: then
2663: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'OiD account is not active: today is out of [start,end] dates ');

Line 2665: fnd_message.set_name('FND','FND_SSO_NOT_ACTIVE'); --Your account not active. Either past end_date or future start_date

2661: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2662: then
2663: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'OiD account is not active: today is out of [start,end] dates ');
2664: end if;
2665: fnd_message.set_name('FND','FND_SSO_NOT_ACTIVE'); --Your account not active. Either past end_date or future start_date
2666: else --unknown reason
2667: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2668: then
2669: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'cannot bind because:'||l_message);

Line 2672: fnd_message.set_name('FND','FND_APPL_LOGIN_FAILED'); -- invalid username password

2668: then
2669: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'cannot bind because:'||l_message);
2670: end if;
2671: -- maybe is not the reason, but it is enough for return , I guess
2672: fnd_message.set_name('FND','FND_APPL_LOGIN_FAILED'); -- invalid username password
2673: end if;
2674:
2675: else
2676: if (fnd_log.LEVEL_STATEMENT>= fnd_log.G_CURRENT_RUNTIME_LEVEL)

Line 2681: fnd_message.set_name('FND','FND_APPL_LOGIN_FAILED'); -- invalid username password

2677: then
2678: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'OiD password did not match');
2679: end if;
2680: -- maybe is not the reason, but it is enough for return , I guess
2681: fnd_message.set_name('FND','FND_APPL_LOGIN_FAILED'); -- invalid username password
2682: end if;
2683: end if;
2684: if (fnd_log.LEVEL_PROCEDURE>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2685: then

Line 2710: fnd_message.set_name('FND','FND-9914'); -- unexpected error

2706: if (fnd_log.LEVEL_UNEXPECTED>= fnd_log.G_CURRENT_RUNTIME_LEVEL)
2707: then
2708: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, l_module_source, 'END: unexpected '||sqlcode||' - '||sqlerrm);
2709: end if;
2710: fnd_message.set_name('FND','FND-9914'); -- unexpected error
2711: return fnd_ldap_util.G_FAILURE;
2712: end validate_login;
2713:
2714: --