200: where user_name = UPPER(c_user_name);
201:
202: if u.user_id = 6
203: then
204: c_error_msg := fnd_message.get;
205: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
206: c_login_msg := fnd_message.get;
207: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
208: end if;
201:
202: if u.user_id = 6
203: then
204: c_error_msg := fnd_message.get;
205: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
206: c_login_msg := fnd_message.get;
207: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
208: end if;
209:
202: if u.user_id = 6
203: then
204: c_error_msg := fnd_message.get;
205: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
206: c_login_msg := fnd_message.get;
207: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
208: end if;
209:
210:
283: end if; -- u.end_date is null or u.end_date > sysdate
284: end if; -- l_expired
285:
286: else
287: -- l_msg_code := fnd_message.get; 2697634
288: fnd_message.parse_encoded(fnd_message.get_encoded,l_app,l_msg_code);
289: if l_msg_code = 'SECURITY_APPL_LOGIN_FAILED'
290: then
291:
284: end if; -- l_expired
285:
286: else
287: -- l_msg_code := fnd_message.get; 2697634
288: fnd_message.parse_encoded(fnd_message.get_encoded,l_app,l_msg_code);
289: if l_msg_code = 'SECURITY_APPL_LOGIN_FAILED'
290: then
291:
292: begin
324: then
325:
326: if c_validate_only = 'N'
327: then
328: fnd_message.set_name('ICX','ICX_ACCT_EXPIRED');
329: c_error_msg := fnd_message.get;
330: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
331: c_login_msg := fnd_message.get;
332:
325:
326: if c_validate_only = 'N'
327: then
328: fnd_message.set_name('ICX','ICX_ACCT_EXPIRED');
329: c_error_msg := fnd_message.get;
330: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
331: c_login_msg := fnd_message.get;
332:
333: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
326: if c_validate_only = 'N'
327: then
328: fnd_message.set_name('ICX','ICX_ACCT_EXPIRED');
329: c_error_msg := fnd_message.get;
330: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
331: c_login_msg := fnd_message.get;
332:
333: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
334: end if;
327: then
328: fnd_message.set_name('ICX','ICX_ACCT_EXPIRED');
329: c_error_msg := fnd_message.get;
330: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
331: c_login_msg := fnd_message.get;
332:
333: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
334: end if;
335:
349: then
350: if c_validate_only = 'N'
351: then
352:
353: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
354: c_error_msg := fnd_message.get;
355: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
356: c_login_msg := fnd_message.get;
357:
350: if c_validate_only = 'N'
351: then
352:
353: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
354: c_error_msg := fnd_message.get;
355: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
356: c_login_msg := fnd_message.get;
357:
358:
351: then
352:
353: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
354: c_error_msg := fnd_message.get;
355: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
356: c_login_msg := fnd_message.get;
357:
358:
359: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
352:
353: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
354: c_error_msg := fnd_message.get;
355: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
356: c_login_msg := fnd_message.get;
357:
358:
359: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
360:
376: if c_validate_only = 'N'
377: then
378:
379: --Start Bug 3161306
380: select fnd_message.get into c_error_msg1 from dual;
381: if c_error_msg1 like 'Oracle error%'
382: then
383: htp.p(c_error_msg1);
384: htp.nl;
385: htp.line;
386: end if;
387: --End Bug 3161306
388:
389: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
390: c_error_msg := fnd_message.get;
391: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
392: c_login_msg := fnd_message.get;
393:
386: end if;
387: --End Bug 3161306
388:
389: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
390: c_error_msg := fnd_message.get;
391: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
392: c_login_msg := fnd_message.get;
393:
394: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
387: --End Bug 3161306
388:
389: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
390: c_error_msg := fnd_message.get;
391: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
392: c_login_msg := fnd_message.get;
393:
394: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
395: end if;
388:
389: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
390: c_error_msg := fnd_message.get;
391: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
392: c_login_msg := fnd_message.get;
393:
394: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
395: end if;
396:
450: htp.htmlClose;
451:
452: exception
453: when others then
454: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
455: l_error_msg := fnd_message.get;
456: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
457: l_login_msg := fnd_message.get;
458:
451:
452: exception
453: when others then
454: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
455: l_error_msg := fnd_message.get;
456: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
457: l_login_msg := fnd_message.get;
458:
459: OracleApps.displayLogin(l_error_msg||' '||l_login_msg,'IC','Y');
452: exception
453: when others then
454: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
455: l_error_msg := fnd_message.get;
456: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
457: l_login_msg := fnd_message.get;
458:
459: OracleApps.displayLogin(l_error_msg||' '||l_login_msg,'IC','Y');
460:
453: when others then
454: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
455: l_error_msg := fnd_message.get;
456: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
457: l_login_msg := fnd_message.get;
458:
459: OracleApps.displayLogin(l_error_msg||' '||l_login_msg,'IC','Y');
460:
461: insert into icx_failures
1065: c_mode_code => 'SLAVE') ;
1066:
1067: exception
1068: when others then
1069: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
1070: c_error_msg := fnd_message.get;
1071: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
1072: c_login_msg := fnd_message.get;
1073:
1066:
1067: exception
1068: when others then
1069: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
1070: c_error_msg := fnd_message.get;
1071: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
1072: c_login_msg := fnd_message.get;
1073:
1074: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
1067: exception
1068: when others then
1069: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
1070: c_error_msg := fnd_message.get;
1071: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
1072: c_login_msg := fnd_message.get;
1073:
1074: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
1075:
1068: when others then
1069: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
1070: c_error_msg := fnd_message.get;
1071: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
1072: c_login_msg := fnd_message.get;
1073:
1074: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
1075:
1076: insert into icx_failures
1810: when e_session_invalid
1811: then
1812: if c_validate_only = 'N'
1813: then
1814: -- fnd_message.set_name('ICX','ICX_SESSION_FAILED');
1815: -- c_error_msg := fnd_message.get;
1816: -- fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1817: -- c_login_msg := fnd_message.get;
1818:
1811: then
1812: if c_validate_only = 'N'
1813: then
1814: -- fnd_message.set_name('ICX','ICX_SESSION_FAILED');
1815: -- c_error_msg := fnd_message.get;
1816: -- fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1817: -- c_login_msg := fnd_message.get;
1818:
1819: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
1812: if c_validate_only = 'N'
1813: then
1814: -- fnd_message.set_name('ICX','ICX_SESSION_FAILED');
1815: -- c_error_msg := fnd_message.get;
1816: -- fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1817: -- c_login_msg := fnd_message.get;
1818:
1819: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
1820: c_login_msg := fnd_message.get;
1813: then
1814: -- fnd_message.set_name('ICX','ICX_SESSION_FAILED');
1815: -- c_error_msg := fnd_message.get;
1816: -- fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1817: -- c_login_msg := fnd_message.get;
1818:
1819: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
1820: c_login_msg := fnd_message.get;
1821: c_error_msg := dbms_utility.format_error_stack;
1815: -- c_error_msg := fnd_message.get;
1816: -- fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1817: -- c_login_msg := fnd_message.get;
1818:
1819: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
1820: c_login_msg := fnd_message.get;
1821: c_error_msg := dbms_utility.format_error_stack;
1822:
1823: if g_session_id is not null
1816: -- fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1817: -- c_login_msg := fnd_message.get;
1818:
1819: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
1820: c_login_msg := fnd_message.get;
1821: c_error_msg := dbms_utility.format_error_stack;
1822:
1823: if g_session_id is not null
1824: then
1830:
1831: OracleApps.displayLogin(c_login_msg||' '||c_error_msg,'IC','Y');
1832: return FALSE;
1833: else
1834: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
1835: c_error_msg := fnd_message.get;
1836: g_validation_error := substr(c_error_msg,1,240);
1837: return FALSE;
1838: end if;
1831: OracleApps.displayLogin(c_login_msg||' '||c_error_msg,'IC','Y');
1832: return FALSE;
1833: else
1834: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
1835: c_error_msg := fnd_message.get;
1836: g_validation_error := substr(c_error_msg,1,240);
1837: return FALSE;
1838: end if;
1839:
1840: when e_exceed_limit
1841: then
1842: if c_validate_only = 'N'
1843: then
1844: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
1845: c_error_msg := fnd_message.get;
1846: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1847: c_login_msg := fnd_message.get;
1848: IF g_user_id IS NOT NULL THEN
1841: then
1842: if c_validate_only = 'N'
1843: then
1844: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
1845: c_error_msg := fnd_message.get;
1846: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1847: c_login_msg := fnd_message.get;
1848: IF g_user_id IS NOT NULL THEN
1849: SELECT user_name
1842: if c_validate_only = 'N'
1843: then
1844: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
1845: c_error_msg := fnd_message.get;
1846: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1847: c_login_msg := fnd_message.get;
1848: IF g_user_id IS NOT NULL THEN
1849: SELECT user_name
1850: INTO c_user_name
1843: then
1844: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
1845: c_error_msg := fnd_message.get;
1846: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1847: c_login_msg := fnd_message.get;
1848: IF g_user_id IS NOT NULL THEN
1849: SELECT user_name
1850: INTO c_user_name
1851: FROM fnd_user
1942: END IF; --recreate
1943:
1944: return FALSE;
1945: else
1946: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
1947: c_error_msg := fnd_message.get;
1948: g_validation_error := substr(c_error_msg,1,240);
1949: return FALSE;
1950: end if;
1943:
1944: return FALSE;
1945: else
1946: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
1947: c_error_msg := fnd_message.get;
1948: g_validation_error := substr(c_error_msg,1,240);
1949: return FALSE;
1950: end if;
1951:
2014: select substr(c_error_msg,12,512) into c_display_error from dual;
2015: icx_util.add_error(c_display_error);
2016: icx_admin_sig.error_screen(c_display_error);
2017:
2018: -- fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2019: -- fnd_message.set_name('ICX','ICX_INVALID_FUNCTION');
2020: -- c_error_msg := fnd_message.get;
2021: -- fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
2022: -- c_login_msg := fnd_message.get;
2015: icx_util.add_error(c_display_error);
2016: icx_admin_sig.error_screen(c_display_error);
2017:
2018: -- fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2019: -- fnd_message.set_name('ICX','ICX_INVALID_FUNCTION');
2020: -- c_error_msg := fnd_message.get;
2021: -- fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
2022: -- c_login_msg := fnd_message.get;
2023:
2016: icx_admin_sig.error_screen(c_display_error);
2017:
2018: -- fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2019: -- fnd_message.set_name('ICX','ICX_INVALID_FUNCTION');
2020: -- c_error_msg := fnd_message.get;
2021: -- fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
2022: -- c_login_msg := fnd_message.get;
2023:
2024: if g_session_id is not null
2017:
2018: -- fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2019: -- fnd_message.set_name('ICX','ICX_INVALID_FUNCTION');
2020: -- c_error_msg := fnd_message.get;
2021: -- fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
2022: -- c_login_msg := fnd_message.get;
2023:
2024: if g_session_id is not null
2025: then
2018: -- fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2019: -- fnd_message.set_name('ICX','ICX_INVALID_FUNCTION');
2020: -- c_error_msg := fnd_message.get;
2021: -- fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
2022: -- c_login_msg := fnd_message.get;
2023:
2024: if g_session_id is not null
2025: then
2026: update icx_sessions
2031: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2032:
2033: return FALSE;
2034: else
2035: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2036: c_error_msg := fnd_message.get;
2037: g_validation_error := substr(c_error_msg,1,240);
2038: return FALSE;
2039: end if;
2032:
2033: return FALSE;
2034: else
2035: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2036: c_error_msg := fnd_message.get;
2037: g_validation_error := substr(c_error_msg,1,240);
2038: return FALSE;
2039: end if;
2040:
2041: when others
2042: then
2043: if c_validate_only = 'N'
2044: then
2045: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2046: c_error_msg := fnd_message.get;
2047: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2048: c_login_msg := fnd_message.get;
2049:
2042: then
2043: if c_validate_only = 'N'
2044: then
2045: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2046: c_error_msg := fnd_message.get;
2047: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2048: c_login_msg := fnd_message.get;
2049:
2050: if g_session_id is not null
2043: if c_validate_only = 'N'
2044: then
2045: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2046: c_error_msg := fnd_message.get;
2047: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2048: c_login_msg := fnd_message.get;
2049:
2050: if g_session_id is not null
2051: then
2044: then
2045: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2046: c_error_msg := fnd_message.get;
2047: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2048: c_login_msg := fnd_message.get;
2049:
2050: if g_session_id is not null
2051: then
2052: update icx_sessions
2268:
2269: exception
2270: when e_session_invalid
2271: then
2272: -- fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2273: return ('INVALID');
2274: when e_exceed_limit
2275: then
2276: -- fnd_message.set_name('ICX','ICX_LIMIT_EXCEEDED');
2272: -- fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2273: return ('INVALID');
2274: when e_exceed_limit
2275: then
2276: -- fnd_message.set_name('ICX','ICX_LIMIT_EXCEEDED');
2277: return ('EXPIRED');
2278: when others
2279: then
2280: -- fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2276: -- fnd_message.set_name('ICX','ICX_LIMIT_EXCEEDED');
2277: return ('EXPIRED');
2278: when others
2279: then
2280: -- fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2281: return ('INVALID');
2282: end;--Check Session PVT
2283:
2284: -- ***********************************************
2344: when e_session_invalid
2345: then
2346: if c_validate_only = 'N'
2347: then
2348: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2349: c_error_msg := fnd_message.get;
2350: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2351: c_login_msg := fnd_message.get;
2352:
2345: then
2346: if c_validate_only = 'N'
2347: then
2348: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2349: c_error_msg := fnd_message.get;
2350: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2351: c_login_msg := fnd_message.get;
2352:
2353: if n_session_id is not null
2346: if c_validate_only = 'N'
2347: then
2348: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2349: c_error_msg := fnd_message.get;
2350: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2351: c_login_msg := fnd_message.get;
2352:
2353: if n_session_id is not null
2354: then
2347: then
2348: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2349: c_error_msg := fnd_message.get;
2350: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2351: c_login_msg := fnd_message.get;
2352:
2353: if n_session_id is not null
2354: then
2355: update icx_sessions
2366: when others
2367: then
2368: if c_validate_only = 'N'
2369: then
2370: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2371: c_error_msg := fnd_message.get;
2372: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2373: c_login_msg := fnd_message.get;
2374:
2367: then
2368: if c_validate_only = 'N'
2369: then
2370: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2371: c_error_msg := fnd_message.get;
2372: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2373: c_login_msg := fnd_message.get;
2374:
2375: if n_session_id is not null
2368: if c_validate_only = 'N'
2369: then
2370: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2371: c_error_msg := fnd_message.get;
2372: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2373: c_login_msg := fnd_message.get;
2374:
2375: if n_session_id is not null
2376: then
2369: then
2370: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2371: c_error_msg := fnd_message.get;
2372: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2373: c_login_msg := fnd_message.get;
2374:
2375: if n_session_id is not null
2376: then
2377: update icx_sessions
2379: where session_id = n_session_id;
2380: COMMIT; -- mputman added 1574527
2381: end if;
2382: --Bug 3957805
2383: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
2384: c_login_msg := fnd_message.get;
2385: c_error_msg := dbms_utility.format_error_stack;
2386:
2387: OracleApps.displayLogin(c_login_msg||' '||c_error_msg,'IC','Y');
2380: COMMIT; -- mputman added 1574527
2381: end if;
2382: --Bug 3957805
2383: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
2384: c_login_msg := fnd_message.get;
2385: c_error_msg := dbms_utility.format_error_stack;
2386:
2387: OracleApps.displayLogin(c_login_msg||' '||c_error_msg,'IC','Y');
2388: return FALSE;
2591:
2592: exception
2593: when e_exceeded_limit
2594: then
2595: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
2596: c_error_msg := fnd_message.get;
2597: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2598: c_login_msg := fnd_message.get;
2599: p_return_status := '-1';
2592: exception
2593: when e_exceeded_limit
2594: then
2595: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
2596: c_error_msg := fnd_message.get;
2597: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2598: c_login_msg := fnd_message.get;
2599: p_return_status := '-1';
2600:
2593: when e_exceeded_limit
2594: then
2595: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
2596: c_error_msg := fnd_message.get;
2597: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2598: c_login_msg := fnd_message.get;
2599: p_return_status := '-1';
2600:
2601: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2594: then
2595: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
2596: c_error_msg := fnd_message.get;
2597: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2598: c_login_msg := fnd_message.get;
2599: p_return_status := '-1';
2600:
2601: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2602:
2600:
2601: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2602:
2603: when others then
2604: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2605: c_error_msg := fnd_message.get;
2606: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2607: c_login_msg := fnd_message.get;
2608: p_return_status := '-1';
2601: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2602:
2603: when others then
2604: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2605: c_error_msg := fnd_message.get;
2606: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2607: c_login_msg := fnd_message.get;
2608: p_return_status := '-1';
2609:
2602:
2603: when others then
2604: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2605: c_error_msg := fnd_message.get;
2606: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2607: c_login_msg := fnd_message.get;
2608: p_return_status := '-1';
2609:
2610: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2603: when others then
2604: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2605: c_error_msg := fnd_message.get;
2606: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2607: c_login_msg := fnd_message.get;
2608: p_return_status := '-1';
2609:
2610: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2611: end;
2680:
2681: exception
2682: when e_exceeded_limit
2683: then
2684: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
2685: c_error_msg := fnd_message.get;
2686: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2687: c_login_msg := fnd_message.get;
2688: p_return_status := '-1';
2681: exception
2682: when e_exceeded_limit
2683: then
2684: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
2685: c_error_msg := fnd_message.get;
2686: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2687: c_login_msg := fnd_message.get;
2688: p_return_status := '-1';
2689:
2682: when e_exceeded_limit
2683: then
2684: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
2685: c_error_msg := fnd_message.get;
2686: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2687: c_login_msg := fnd_message.get;
2688: p_return_status := '-1';
2689:
2690: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2683: then
2684: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
2685: c_error_msg := fnd_message.get;
2686: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2687: c_login_msg := fnd_message.get;
2688: p_return_status := '-1';
2689:
2690: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2691:
2689:
2690: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2691:
2692: when others then
2693: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2694: c_error_msg := fnd_message.get;
2695: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2696: c_login_msg := fnd_message.get;
2697: p_return_status := '-1';
2690: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2691:
2692: when others then
2693: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2694: c_error_msg := fnd_message.get;
2695: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2696: c_login_msg := fnd_message.get;
2697: p_return_status := '-1';
2698:
2691:
2692: when others then
2693: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2694: c_error_msg := fnd_message.get;
2695: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2696: c_login_msg := fnd_message.get;
2697: p_return_status := '-1';
2698:
2699: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2692: when others then
2693: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2694: c_error_msg := fnd_message.get;
2695: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2696: c_login_msg := fnd_message.get;
2697: p_return_status := '-1';
2698:
2699: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2700: end;
2764:
2765: exception
2766: when e_exceeded_limit
2767: then
2768: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
2769: c_error_msg := fnd_message.get;
2770: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2771: c_login_msg := fnd_message.get;
2772: p_return_status := '-1';
2765: exception
2766: when e_exceeded_limit
2767: then
2768: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
2769: c_error_msg := fnd_message.get;
2770: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2771: c_login_msg := fnd_message.get;
2772: p_return_status := '-1';
2773:
2766: when e_exceeded_limit
2767: then
2768: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
2769: c_error_msg := fnd_message.get;
2770: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2771: c_login_msg := fnd_message.get;
2772: p_return_status := '-1';
2773:
2774: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2767: then
2768: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
2769: c_error_msg := fnd_message.get;
2770: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2771: c_login_msg := fnd_message.get;
2772: p_return_status := '-1';
2773:
2774: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2775:
2773:
2774: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2775:
2776: when others then
2777: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2778: c_error_msg := fnd_message.get;
2779: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2780: c_login_msg := fnd_message.get;
2781: p_return_status := '-1';
2774: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2775:
2776: when others then
2777: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2778: c_error_msg := fnd_message.get;
2779: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2780: c_login_msg := fnd_message.get;
2781: p_return_status := '-1';
2782:
2775:
2776: when others then
2777: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2778: c_error_msg := fnd_message.get;
2779: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2780: c_login_msg := fnd_message.get;
2781: p_return_status := '-1';
2782:
2783: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2776: when others then
2777: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2778: c_error_msg := fnd_message.get;
2779: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2780: c_login_msg := fnd_message.get;
2781: p_return_status := '-1';
2782:
2783: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2784: end;
2831: end if;
2832:
2833: exception
2834: when others then
2835: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2836: c_error_msg := fnd_message.get;
2837: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2838: c_login_msg := fnd_message.get;
2839:
2832:
2833: exception
2834: when others then
2835: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2836: c_error_msg := fnd_message.get;
2837: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2838: c_login_msg := fnd_message.get;
2839:
2840: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2833: exception
2834: when others then
2835: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2836: c_error_msg := fnd_message.get;
2837: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2838: c_login_msg := fnd_message.get;
2839:
2840: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2841: end;
2834: when others then
2835: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2836: c_error_msg := fnd_message.get;
2837: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2838: c_login_msg := fnd_message.get;
2839:
2840: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2841: end;
2842:
2867: end if;
2868:
2869: exception
2870: when others then
2871: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2872: c_error_msg := fnd_message.get;
2873: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2874: c_login_msg := fnd_message.get;
2875:
2868:
2869: exception
2870: when others then
2871: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2872: c_error_msg := fnd_message.get;
2873: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2874: c_login_msg := fnd_message.get;
2875:
2876: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2869: exception
2870: when others then
2871: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2872: c_error_msg := fnd_message.get;
2873: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2874: c_login_msg := fnd_message.get;
2875:
2876: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2877: end;
2870: when others then
2871: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2872: c_error_msg := fnd_message.get;
2873: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2874: c_login_msg := fnd_message.get;
2875:
2876: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2877: end;
2878:
3094: return(n_id);
3095: exception
3096: when e_exceeded_limit
3097: then
3098: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
3099: c_error_msg := fnd_message.get;
3100: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3101: c_login_msg := fnd_message.get;
3102:
3095: exception
3096: when e_exceeded_limit
3097: then
3098: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
3099: c_error_msg := fnd_message.get;
3100: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3101: c_login_msg := fnd_message.get;
3102:
3103: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3096: when e_exceeded_limit
3097: then
3098: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
3099: c_error_msg := fnd_message.get;
3100: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3101: c_login_msg := fnd_message.get;
3102:
3103: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3104: return '-1';
3097: then
3098: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
3099: c_error_msg := fnd_message.get;
3100: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3101: c_login_msg := fnd_message.get;
3102:
3103: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3104: return '-1';
3105:
3108: then
3109: return getNLS_PARAMETER('NLS_DATE_FORMAT');
3110: else
3111:
3112: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
3113: c_error_msg := fnd_message.get;
3114: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3115: c_login_msg := fnd_message.get;
3116:
3109: return getNLS_PARAMETER('NLS_DATE_FORMAT');
3110: else
3111:
3112: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
3113: c_error_msg := fnd_message.get;
3114: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3115: c_login_msg := fnd_message.get;
3116:
3117: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3110: else
3111:
3112: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
3113: c_error_msg := fnd_message.get;
3114: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3115: c_login_msg := fnd_message.get;
3116:
3117: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3118:
3111:
3112: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
3113: c_error_msg := fnd_message.get;
3114: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3115: c_login_msg := fnd_message.get;
3116:
3117: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3118:
3119: return '-1';
4143: then
4144:
4145: if c_validate_only = 'N'
4146: then
4147: fnd_message.set_name('ICX','ICX_ACCT_EXPIRED');
4148: c_error_msg := fnd_message.get;
4149: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
4150: c_login_msg := fnd_message.get;
4151:
4144:
4145: if c_validate_only = 'N'
4146: then
4147: fnd_message.set_name('ICX','ICX_ACCT_EXPIRED');
4148: c_error_msg := fnd_message.get;
4149: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
4150: c_login_msg := fnd_message.get;
4151:
4152: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
4145: if c_validate_only = 'N'
4146: then
4147: fnd_message.set_name('ICX','ICX_ACCT_EXPIRED');
4148: c_error_msg := fnd_message.get;
4149: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
4150: c_login_msg := fnd_message.get;
4151:
4152: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
4153: end if;
4146: then
4147: fnd_message.set_name('ICX','ICX_ACCT_EXPIRED');
4148: c_error_msg := fnd_message.get;
4149: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
4150: c_login_msg := fnd_message.get;
4151:
4152: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
4153: end if;
4154:
4167: when e_signin_invalid OR e_invalid_password
4168: then
4169: if c_validate_only = 'N'
4170: then
4171: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
4172: c_error_msg := fnd_message.get;
4173: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4174: c_login_msg := fnd_message.get;
4175:
4168: then
4169: if c_validate_only = 'N'
4170: then
4171: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
4172: c_error_msg := fnd_message.get;
4173: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4174: c_login_msg := fnd_message.get;
4175:
4176: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
4169: if c_validate_only = 'N'
4170: then
4171: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
4172: c_error_msg := fnd_message.get;
4173: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4174: c_login_msg := fnd_message.get;
4175:
4176: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
4177: end if;
4170: then
4171: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
4172: c_error_msg := fnd_message.get;
4173: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4174: c_login_msg := fnd_message.get;
4175:
4176: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
4177: end if;
4178:
4190: when others
4191: then
4192: if c_validate_only = 'N'
4193: then
4194: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
4195: c_error_msg := fnd_message.get;
4196: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4197: c_login_msg := fnd_message.get;
4198:
4191: then
4192: if c_validate_only = 'N'
4193: then
4194: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
4195: c_error_msg := fnd_message.get;
4196: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4197: c_login_msg := fnd_message.get;
4198:
4199: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
4192: if c_validate_only = 'N'
4193: then
4194: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
4195: c_error_msg := fnd_message.get;
4196: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4197: c_login_msg := fnd_message.get;
4198:
4199: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
4200: end if;
4193: then
4194: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
4195: c_error_msg := fnd_message.get;
4196: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4197: c_login_msg := fnd_message.get;
4198:
4199: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
4200: end if;
4201: /*