30:
31: else
32:
33:
34: fnd_message.set_name('FND','FND_APPSNAV_NO_AVAIL_APPS');
35: c_error_message := fnd_message.get;
36:
37: icx_util.add_error(c_error_message);
38: icx_admin_sig.error_screen(c_error_message);
31: else
32:
33:
34: fnd_message.set_name('FND','FND_APPSNAV_NO_AVAIL_APPS');
35: c_error_message := fnd_message.get;
36:
37: icx_util.add_error(c_error_message);
38: icx_admin_sig.error_screen(c_error_message);
39:
577: p_event_key=>seq, p_parameters=>e_parameters);
578:
579: DBMS_RANDOM.terminate;
580:
581: fnd_message.set_name('ICX','ICX_FORGOT_PASSWORD');
582: c_error_msg := fnd_message.get;
583:
584: if email_address is null
585: then
578:
579: DBMS_RANDOM.terminate;
580:
581: fnd_message.set_name('ICX','ICX_FORGOT_PASSWORD');
582: c_error_msg := fnd_message.get;
583:
584: if email_address is null
585: then
586:
583:
584: if email_address is null
585: then
586:
587: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
588: c_login_msg := fnd_message.get;
589: fnd_message.set_name('ICX','ICX_EMAIL_ADDRESS_NULL');
590: c_error_msg := fnd_message.get;
591: htp.p(c_login_msg||' '||c_error_msg);
584: if email_address is null
585: then
586:
587: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
588: c_login_msg := fnd_message.get;
589: fnd_message.set_name('ICX','ICX_EMAIL_ADDRESS_NULL');
590: c_error_msg := fnd_message.get;
591: htp.p(c_login_msg||' '||c_error_msg);
592:
585: then
586:
587: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
588: c_login_msg := fnd_message.get;
589: fnd_message.set_name('ICX','ICX_EMAIL_ADDRESS_NULL');
590: c_error_msg := fnd_message.get;
591: htp.p(c_login_msg||' '||c_error_msg);
592:
593: else
586:
587: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
588: c_login_msg := fnd_message.get;
589: fnd_message.set_name('ICX','ICX_EMAIL_ADDRESS_NULL');
590: c_error_msg := fnd_message.get;
591: htp.p(c_login_msg||' '||c_error_msg);
592:
593: else
594: htp.p(c_error_msg||' '||email_address);
607:
608:
609: EXCEPTION
610: when no_data_found then
611: fnd_message.set_name('ICX','ICX_ACCT_EXPIRED');
612: c_error_msg := fnd_message.get;
613: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
614: c_login_msg := fnd_message.get;
615: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
608:
609: EXCEPTION
610: when no_data_found then
611: fnd_message.set_name('ICX','ICX_ACCT_EXPIRED');
612: c_error_msg := fnd_message.get;
613: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
614: c_login_msg := fnd_message.get;
615: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
616: cattributes => 'BORDER=0');
609: EXCEPTION
610: when no_data_found then
611: fnd_message.set_name('ICX','ICX_ACCT_EXPIRED');
612: c_error_msg := fnd_message.get;
613: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
614: c_login_msg := fnd_message.get;
615: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
616: cattributes => 'BORDER=0');
617: htp.tableRowClose;
610: when no_data_found then
611: fnd_message.set_name('ICX','ICX_ACCT_EXPIRED');
612: c_error_msg := fnd_message.get;
613: fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
614: c_login_msg := fnd_message.get;
615: htp.img(curl => '/OA_MEDIA/FNDLOGOS.gif',
616: cattributes => 'BORDER=0');
617: htp.tableRowClose;
618: htp.tableClose;
677:
678: if recreate is not null
679: then
680:
681: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
682: c_error_msg := fnd_message.get;
683: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
684: c_login_msg := fnd_message.get;
685:
678: if recreate is not null
679: then
680:
681: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
682: c_error_msg := fnd_message.get;
683: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
684: c_login_msg := fnd_message.get;
685:
686:
679: then
680:
681: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
682: c_error_msg := fnd_message.get;
683: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
684: c_login_msg := fnd_message.get;
685:
686:
687: l_url := l_url||'&'||'errText='||wfa_html.conv_special_url_chars(c_error_msg)||wfa_html.conv_special_url_chars(c_login_msg);
680:
681: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
682: c_error_msg := fnd_message.get;
683: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
684: c_login_msg := fnd_message.get;
685:
686:
687: l_url := l_url||'&'||'errText='||wfa_html.conv_special_url_chars(c_error_msg)||wfa_html.conv_special_url_chars(c_login_msg);
688:
747: --check to see if we are running in maintenance mode AND that we got here for other than expiry.
748: IF (l_maint_mode <> 'NORMAL') AND (recreate IS NULL) THEN
749:
750:
751: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
752: c_error_msg := fnd_message.get;
753: SELECT home_url
754: INTO l_home_url
755: FROM icx_parameters;
748: IF (l_maint_mode <> 'NORMAL') AND (recreate IS NULL) THEN
749:
750:
751: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
752: c_error_msg := fnd_message.get;
753: SELECT home_url
754: INTO l_home_url
755: FROM icx_parameters;
756:
833: htp.p('');
834: htp.htmlOpen;
835: htp.p('');
834: htp.htmlOpen;
835: htp.p('');
842: ELSE
850: htp.htmlClose;
851:
852: ELSE --not using PORTAL
853: IF recreate IS NOT NULL THEN --let the user know why they are going to a sign on screen
854: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
855: c_error_msg := fnd_message.get;
856: htp.p('');
851:
852: ELSE --not using PORTAL
853: IF recreate IS NOT NULL THEN --let the user know why they are going to a sign on screen
854: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
855: c_error_msg := fnd_message.get;
856: htp.p('');
859: END IF;
861:
862: icx_util.getPrompts(601,'ICX_LOGIN',c_title,c_prompts);
863: IF recreate IS NOT NULL THEN
864:
865: -- fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
866: -- c_error_msg := fnd_message.get;
867: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
868: c_login_msg := fnd_message.get;
869:
862: icx_util.getPrompts(601,'ICX_LOGIN',c_title,c_prompts);
863: IF recreate IS NOT NULL THEN
864:
865: -- fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
866: -- c_error_msg := fnd_message.get;
867: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
868: c_login_msg := fnd_message.get;
869:
870: --mputman moved up for 2214212
863: IF recreate IS NOT NULL THEN
864:
865: -- fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
866: -- c_error_msg := fnd_message.get;
867: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
868: c_login_msg := fnd_message.get;
869:
870: --mputman moved up for 2214212
871: -- l_text := icx_call.decrypt(recreate);
864:
865: -- fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
866: -- c_error_msg := fnd_message.get;
867: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
868: c_login_msg := fnd_message.get;
869:
870: --mputman moved up for 2214212
871: -- l_text := icx_call.decrypt(recreate);
872: -- icx_on_utilities.unpack_parameters(l_text,l_parameters);
1266: owa_util.redirect_url(l_anchor);
1267: owa_util.http_header_close;
1268:
1269: else
1270: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
1271: l_error_msg := fnd_message.get;
1272: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1273: l_login_msg := fnd_message.get;
1274:
1267: owa_util.http_header_close;
1268:
1269: else
1270: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
1271: l_error_msg := fnd_message.get;
1272: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1273: l_login_msg := fnd_message.get;
1274:
1275: OracleApps.displayLogin(l_error_msg||' '||l_login_msg,'IC','Y');
1268:
1269: else
1270: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
1271: l_error_msg := fnd_message.get;
1272: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1273: l_login_msg := fnd_message.get;
1274:
1275: OracleApps.displayLogin(l_error_msg||' '||l_login_msg,'IC','Y');
1276: end if;
1269: else
1270: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
1271: l_error_msg := fnd_message.get;
1272: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1273: l_login_msg := fnd_message.get;
1274:
1275: OracleApps.displayLogin(l_error_msg||' '||l_login_msg,'IC','Y');
1276: end if;
1277:
1374:
1375: owa_util.http_header_close;
1376:
1377: else
1378: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
1379: l_error_msg := fnd_message.get;
1380: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1381: l_login_msg := fnd_message.get;
1382:
1375: owa_util.http_header_close;
1376:
1377: else
1378: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
1379: l_error_msg := fnd_message.get;
1380: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1381: l_login_msg := fnd_message.get;
1382:
1383: OracleApps.displayLogin(l_error_msg||' '||l_login_msg,'IC','Y');
1376:
1377: else
1378: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
1379: l_error_msg := fnd_message.get;
1380: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1381: l_login_msg := fnd_message.get;
1382:
1383: OracleApps.displayLogin(l_error_msg||' '||l_login_msg,'IC','Y');
1384: end if;
1377: else
1378: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
1379: l_error_msg := fnd_message.get;
1380: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1381: l_login_msg := fnd_message.get;
1382:
1383: OracleApps.displayLogin(l_error_msg||' '||l_login_msg,'IC','Y');
1384: end if;
1385:
1527: n_session_id := icx_sec.getsessioncookie;
1528:
1529: if (n_session_id <= 0)
1530: then
1531: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
1532: c_error_msg := fnd_message.get;
1533: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1534: c_login_msg := fnd_message.get;
1535:
1528:
1529: if (n_session_id <= 0)
1530: then
1531: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
1532: c_error_msg := fnd_message.get;
1533: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1534: c_login_msg := fnd_message.get;
1535:
1536: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
1529: if (n_session_id <= 0)
1530: then
1531: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
1532: c_error_msg := fnd_message.get;
1533: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1534: c_login_msg := fnd_message.get;
1535:
1536: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
1537: b_return := FALSE;
1530: then
1531: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
1532: c_error_msg := fnd_message.get;
1533: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1534: c_login_msg := fnd_message.get;
1535:
1536: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
1537: b_return := FALSE;
1538: end if;
1794:
1795: exception
1796: when e_data_error
1797: then
1798: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
1799: c_error_msg := fnd_message.get;
1800: Fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
1801: c_login_msg := fnd_message.get;
1802:
1795: exception
1796: when e_data_error
1797: then
1798: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
1799: c_error_msg := fnd_message.get;
1800: Fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
1801: c_login_msg := fnd_message.get;
1802:
1803: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
1796: when e_data_error
1797: then
1798: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
1799: c_error_msg := fnd_message.get;
1800: Fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
1801: c_login_msg := fnd_message.get;
1802:
1803: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
1804: when others
1797: then
1798: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
1799: c_error_msg := fnd_message.get;
1800: Fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
1801: c_login_msg := fnd_message.get;
1802:
1803: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
1804: when others
1805: then
1807: then
1808: -- *************************
1809: -- something else failed
1810: -- *************************
1811: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
1812: c_error_msg := fnd_message.get;
1813: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1814: c_login_msg := fnd_message.get;
1815:
1808: -- *************************
1809: -- something else failed
1810: -- *************************
1811: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
1812: c_error_msg := fnd_message.get;
1813: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1814: c_login_msg := fnd_message.get;
1815:
1816: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
1809: -- something else failed
1810: -- *************************
1811: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
1812: c_error_msg := fnd_message.get;
1813: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1814: c_login_msg := fnd_message.get;
1815:
1816: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
1817: else
1810: -- *************************
1811: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
1812: c_error_msg := fnd_message.get;
1813: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
1814: c_login_msg := fnd_message.get;
1815:
1816: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
1817: else
1818: -- *************************
2190:
2191: exception
2192: when e_data_error
2193: then
2194: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2195: c_error_msg := fnd_message.get;
2196: Fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
2197: c_login_msg := fnd_message.get;
2198:
2191: exception
2192: when e_data_error
2193: then
2194: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2195: c_error_msg := fnd_message.get;
2196: Fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
2197: c_login_msg := fnd_message.get;
2198:
2199: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2192: when e_data_error
2193: then
2194: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2195: c_error_msg := fnd_message.get;
2196: Fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
2197: c_login_msg := fnd_message.get;
2198:
2199: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2200: when others
2193: then
2194: fnd_message.set_name('ICX','ICX_DATA_INCORRECT');
2195: c_error_msg := fnd_message.get;
2196: Fnd_message.set_name('ICX','ICX_CONTACT_WEBMASTER');
2197: c_login_msg := fnd_message.get;
2198:
2199: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2200: when others
2201: then
2203: then
2204: -- *************************
2205: -- something else failed
2206: -- *************************
2207: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2208: c_error_msg := fnd_message.get;
2209: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2210: c_login_msg := fnd_message.get;
2211:
2204: -- *************************
2205: -- something else failed
2206: -- *************************
2207: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2208: c_error_msg := fnd_message.get;
2209: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2210: c_login_msg := fnd_message.get;
2211:
2212: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2205: -- something else failed
2206: -- *************************
2207: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2208: c_error_msg := fnd_message.get;
2209: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2210: c_login_msg := fnd_message.get;
2211:
2212: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2213: else
2206: -- *************************
2207: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2208: c_error_msg := fnd_message.get;
2209: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2210: c_login_msg := fnd_message.get;
2211:
2212: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2213: else
2214: -- *************************
2313:
2314:
2315: exception
2316: when NO_DATA_FOUND then --mputman added 1545083
2317: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2318: err_mesg := fnd_message.get;
2319: icx_util.add_error(err_mesg);
2320: icx_admin_sig.error_screen(err_mesg);
2321:
2314:
2315: exception
2316: when NO_DATA_FOUND then --mputman added 1545083
2317: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
2318: err_mesg := fnd_message.get;
2319: icx_util.add_error(err_mesg);
2320: icx_admin_sig.error_screen(err_mesg);
2321:
2322: when others then
2854: c_dummy := dbms_sql.execute(c_call);
2855: dbms_sql.close_cursor(c_call);
2856:
2857: else
2858: fnd_message.set_name('ICX','ICX_INVALID_FUNCTION');
2859: c_error_msg := fnd_message.get;
2860: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2861: c_login_msg := fnd_message.get;
2862:
2855: dbms_sql.close_cursor(c_call);
2856:
2857: else
2858: fnd_message.set_name('ICX','ICX_INVALID_FUNCTION');
2859: c_error_msg := fnd_message.get;
2860: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2861: c_login_msg := fnd_message.get;
2862:
2863: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2856:
2857: else
2858: fnd_message.set_name('ICX','ICX_INVALID_FUNCTION');
2859: c_error_msg := fnd_message.get;
2860: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2861: c_login_msg := fnd_message.get;
2862:
2863: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2864:
2857: else
2858: fnd_message.set_name('ICX','ICX_INVALID_FUNCTION');
2859: c_error_msg := fnd_message.get;
2860: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
2861: c_login_msg := fnd_message.get;
2862:
2863: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
2864:
2865: end if;
3009: n_session_id := icx_sec.getsessioncookie;
3010:
3011: if (n_session_id <= 0)
3012: then
3013: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
3014: c_error_msg := fnd_message.get;
3015: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3016: c_login_msg := fnd_message.get;
3017:
3010:
3011: if (n_session_id <= 0)
3012: then
3013: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
3014: c_error_msg := fnd_message.get;
3015: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3016: c_login_msg := fnd_message.get;
3017:
3018: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3011: if (n_session_id <= 0)
3012: then
3013: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
3014: c_error_msg := fnd_message.get;
3015: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3016: c_login_msg := fnd_message.get;
3017:
3018: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3019: else
3012: then
3013: fnd_message.set_name('FND','FND_SESSION_ICX_EXPIRED');
3014: c_error_msg := fnd_message.get;
3015: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3016: c_login_msg := fnd_message.get;
3017:
3018: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3019: else
3020: c_string := '';
3087: htp.headclose;
3088:
3089: l_toolbar.title := wf_core.translate('ICX_PREFERENCES');
3090: l_toolbar.help_url := 'javascript:top.help_window()';
3091: fnd_message.set_name('ICX','ICX_HELP');
3092: l_toolbar.help_mouseover := FND_MESSAGE.GET;
3093:
3094: l_toolbar.menu_url :=owa_util.get_cgi_env('SCRIPT_NAME')||'/OracleNavigate.Responsibility'; --mputman added for bug 1402459
3095: l_toolbar.menu_mouseover := l_prompts(7); -- from region ICX_OBIS_TOOLBAR mputman added for bug 1402459
3088:
3089: l_toolbar.title := wf_core.translate('ICX_PREFERENCES');
3090: l_toolbar.help_url := 'javascript:top.help_window()';
3091: fnd_message.set_name('ICX','ICX_HELP');
3092: l_toolbar.help_mouseover := FND_MESSAGE.GET;
3093:
3094: l_toolbar.menu_url :=owa_util.get_cgi_env('SCRIPT_NAME')||'/OracleNavigate.Responsibility'; --mputman added for bug 1402459
3095: l_toolbar.menu_mouseover := l_prompts(7); -- from region ICX_OBIS_TOOLBAR mputman added for bug 1402459
3096:
3114: p_action => TRUE);
3115:
3116: exception
3117: when others then
3118: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
3119: c_error_msg := fnd_message.get;
3120: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3121: c_login_msg := fnd_message.get;
3122:
3115:
3116: exception
3117: when others then
3118: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
3119: c_error_msg := fnd_message.get;
3120: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3121: c_login_msg := fnd_message.get;
3122:
3123: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3116: exception
3117: when others then
3118: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
3119: c_error_msg := fnd_message.get;
3120: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3121: c_login_msg := fnd_message.get;
3122:
3123: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3124: end;
3117: when others then
3118: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
3119: c_error_msg := fnd_message.get;
3120: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3121: c_login_msg := fnd_message.get;
3122:
3123: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3124: end;
3125:
3329: htp.p('function savepref() {
3330: var l_alert = false');
3331:
3332: l_pwlen := to_number(nvl(Fnd_Profile.Value('SIGNON_PASSWORD_LENGTH'), 5));
3333: fnd_message.set_name('FND','PASSWORD-LONGER');
3334: fnd_message.set_token('LENGTH',to_char(l_pwlen));
3335: l_message := icx_util.replace_quotes(fnd_message.get);
3336: htp.p(' var lpwd = document.userpref.i_5.value;
3337: if (lpwd.length < '||to_char(l_pwlen)||' '||'&'||'&'||' document.userpref.i_4.value != "") {
3330: var l_alert = false');
3331:
3332: l_pwlen := to_number(nvl(Fnd_Profile.Value('SIGNON_PASSWORD_LENGTH'), 5));
3333: fnd_message.set_name('FND','PASSWORD-LONGER');
3334: fnd_message.set_token('LENGTH',to_char(l_pwlen));
3335: l_message := icx_util.replace_quotes(fnd_message.get);
3336: htp.p(' var lpwd = document.userpref.i_5.value;
3337: if (lpwd.length < '||to_char(l_pwlen)||' '||'&'||'&'||' document.userpref.i_4.value != "") {
3338: alert('''||l_message||''');
3331:
3332: l_pwlen := to_number(nvl(Fnd_Profile.Value('SIGNON_PASSWORD_LENGTH'), 5));
3333: fnd_message.set_name('FND','PASSWORD-LONGER');
3334: fnd_message.set_token('LENGTH',to_char(l_pwlen));
3335: l_message := icx_util.replace_quotes(fnd_message.get);
3336: htp.p(' var lpwd = document.userpref.i_5.value;
3337: if (lpwd.length < '||to_char(l_pwlen)||' '||'&'||'&'||' document.userpref.i_4.value != "") {
3338: alert('''||l_message||''');
3339: document.userpref.i_5.focus();
3339: document.userpref.i_5.focus();
3340: l_alert = true
3341: };');
3342:
3343: fnd_message.set_name('ICX','ICX_REQU_REPAS');
3344: l_message := icx_util.replace_quotes(fnd_message.get);
3345: htp.p(' if ((document.userpref.i_5.value != document.userpref.i_6.value)||(document.userpref.i_4.value == "" '||'&'||'&'||' document.userpref.i_5.value !="")) {
3346: alert('''||l_message||''');
3347: document.userpref.i_6.focus();
3340: l_alert = true
3341: };');
3342:
3343: fnd_message.set_name('ICX','ICX_REQU_REPAS');
3344: l_message := icx_util.replace_quotes(fnd_message.get);
3345: htp.p(' if ((document.userpref.i_5.value != document.userpref.i_6.value)||(document.userpref.i_4.value == "" '||'&'||'&'||' document.userpref.i_5.value !="")) {
3346: alert('''||l_message||''');
3347: document.userpref.i_6.focus();
3348: l_alert = true
3443:
3444:
3445: htp.tableRowOpen; -- date format
3446: htp.tableData(c_prompts(3),'RIGHT');
3447: fnd_message.set_name('ICX','ICX_RRRR');
3448: l_message := fnd_message.get;
3449: htp.p('
3444:
3445: htp.tableRowOpen; -- date format
3446: htp.tableData(c_prompts(3),'RIGHT');
3447: fnd_message.set_name('ICX','ICX_RRRR');
3448: l_message := fnd_message.get;
3449: htp.p('
3641: if p_message_flag = 'N' then
3642: icx_cabo.buttons(p_actions => l_actions);
3643:
3644: elsif p_message_flag = 'Y' then
3645: fnd_message.set_name('ICX','ICX_SUCCESS_CONFIRM');
3646: l_actiontext := fnd_message.get;
3647: icx_cabo.buttons(p_actions => l_actions,
3648: p_actiontext => l_actiontext);
3649: else
3642: icx_cabo.buttons(p_actions => l_actions);
3643:
3644: elsif p_message_flag = 'Y' then
3645: fnd_message.set_name('ICX','ICX_SUCCESS_CONFIRM');
3646: l_actiontext := fnd_message.get;
3647: icx_cabo.buttons(p_actions => l_actions,
3648: p_actiontext => l_actiontext);
3649: else
3650: -- retrieve the password change/validation error returned by fnd_user_pvt
3659: end if; --validatesession
3660:
3661: exception
3662: when others then
3663: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
3664: c_error_msg := fnd_message.get;
3665: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3666: c_login_msg := fnd_message.get;
3667:
3660:
3661: exception
3662: when others then
3663: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
3664: c_error_msg := fnd_message.get;
3665: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3666: c_login_msg := fnd_message.get;
3667:
3668: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3661: exception
3662: when others then
3663: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
3664: c_error_msg := fnd_message.get;
3665: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3666: c_login_msg := fnd_message.get;
3667:
3668: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3669: end;
3662: when others then
3663: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
3664: c_error_msg := fnd_message.get;
3665: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3666: c_login_msg := fnd_message.get;
3667:
3668: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3669: end;
3670:
3687: begin
3688: if (i_1 is null) or (i_1 = 'GUEST')
3689: then
3690:
3691: fnd_message.set_name('IBE','IBE_PRMT_UNAUTHORIZED');
3692: c_error_message := fnd_message.get;
3693: htp.p(c_error_message);
3694: else
3695:
3688: if (i_1 is null) or (i_1 = 'GUEST')
3689: then
3690:
3691: fnd_message.set_name('IBE','IBE_PRMT_UNAUTHORIZED');
3692: c_error_message := fnd_message.get;
3693: htp.p(c_error_message);
3694: else
3695:
3696: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
3702: htp.p('function update_user(){
3703: var l_alert = false;');
3704:
3705: l_pwlen := to_number(nvl(Fnd_Profile.Value('SIGNON_PASSWORD_LENGTH'), 5));
3706: fnd_message.set_name('FND','PASSWORD-LONGER');
3707: fnd_message.set_token('LENGTH',to_char(l_pwlen));
3708: l_message := icx_util.replace_quotes(fnd_message.get);
3709: htp.p(' var lpwd = document.newpass.i_3.value;
3710: if (lpwd.length < '||to_char(l_pwlen)||' '||'&'||'&'||' document.newpass.i_2.value != "") {
3703: var l_alert = false;');
3704:
3705: l_pwlen := to_number(nvl(Fnd_Profile.Value('SIGNON_PASSWORD_LENGTH'), 5));
3706: fnd_message.set_name('FND','PASSWORD-LONGER');
3707: fnd_message.set_token('LENGTH',to_char(l_pwlen));
3708: l_message := icx_util.replace_quotes(fnd_message.get);
3709: htp.p(' var lpwd = document.newpass.i_3.value;
3710: if (lpwd.length < '||to_char(l_pwlen)||' '||'&'||'&'||' document.newpass.i_2.value != "") {
3711: alert('''||l_message||''');
3704:
3705: l_pwlen := to_number(nvl(Fnd_Profile.Value('SIGNON_PASSWORD_LENGTH'), 5));
3706: fnd_message.set_name('FND','PASSWORD-LONGER');
3707: fnd_message.set_token('LENGTH',to_char(l_pwlen));
3708: l_message := icx_util.replace_quotes(fnd_message.get);
3709: htp.p(' var lpwd = document.newpass.i_3.value;
3710: if (lpwd.length < '||to_char(l_pwlen)||' '||'&'||'&'||' document.newpass.i_2.value != "") {
3711: alert('''||l_message||''');
3712: document.newpass.i_3.focus();
3712: document.newpass.i_3.focus();
3713: l_alert = true
3714: };');
3715: --start bug 2214425
3716: fnd_message.set_name('FND', 'PASSWORD-INVALID-NO-REUSE');
3717: l_message := icx_util.replace_quotes(fnd_message.get);
3718: htp.p(' if ((document.newpass.i_2.value == document.newpass.i_3.value)||(document.newpass.i_2.value == "" '||'&'||'&'||' document.newpass.i_3.value !="")) {
3719: alert('''||l_message||''');
3720: document.newpass.i_3.focus();
3713: l_alert = true
3714: };');
3715: --start bug 2214425
3716: fnd_message.set_name('FND', 'PASSWORD-INVALID-NO-REUSE');
3717: l_message := icx_util.replace_quotes(fnd_message.get);
3718: htp.p(' if ((document.newpass.i_2.value == document.newpass.i_3.value)||(document.newpass.i_2.value == "" '||'&'||'&'||' document.newpass.i_3.value !="")) {
3719: alert('''||l_message||''');
3720: document.newpass.i_3.focus();
3721: l_alert = true
3722: };');
3723: ----- end
3724:
3725:
3726: fnd_message.set_name('ICX','ICX_REQU_REPAS');
3727: l_message := icx_util.replace_quotes(fnd_message.get);
3728: htp.p(' if ((document.newpass.i_3.value != document.newpass.i_4.value)||(document.newpass.i_2.value == "" '||'&'||'&'||' document.newpass.i_3.value !="")) {
3729: alert('''||l_message||''');
3730: document.newpass.i_4.focus();
3723: ----- end
3724:
3725:
3726: fnd_message.set_name('ICX','ICX_REQU_REPAS');
3727: l_message := icx_util.replace_quotes(fnd_message.get);
3728: htp.p(' if ((document.newpass.i_3.value != document.newpass.i_4.value)||(document.newpass.i_2.value == "" '||'&'||'&'||' document.newpass.i_3.value !="")) {
3729: alert('''||l_message||''');
3730: document.newpass.i_4.focus();
3731: l_alert = true
3746: DISP_MAINMENU => 'N',
3747: DISP_HELP => 'N',
3748: DISP_EXIT => 'N');
3749:
3750: fnd_message.set_name('FND','PASSWORD-EXPIRED');
3751: c_title := fnd_message.get;
3752:
3753: htp.title(c_title);
3754: htp.p('
3747: DISP_HELP => 'N',
3748: DISP_EXIT => 'N');
3749:
3750: fnd_message.set_name('FND','PASSWORD-EXPIRED');
3751: c_title := fnd_message.get;
3752:
3753: htp.title(c_title);
3754: htp.p('
3793: end if;
3794:
3795: exception
3796: when others then
3797: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
3798: c_error_msg := fnd_message.get;
3799: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3800: c_login_msg := fnd_message.get;
3801:
3794:
3795: exception
3796: when others then
3797: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
3798: c_error_msg := fnd_message.get;
3799: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3800: c_login_msg := fnd_message.get;
3801:
3802: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3795: exception
3796: when others then
3797: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
3798: c_error_msg := fnd_message.get;
3799: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3800: c_login_msg := fnd_message.get;
3801:
3802: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3803: end;
3796: when others then
3797: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
3798: c_error_msg := fnd_message.get;
3799: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
3800: c_login_msg := fnd_message.get;
3801:
3802: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
3803: end;
3804:
3877: X_LEVEL_NAME =>'USER',
3878: X_LEVEL_VALUE => l_user_id);
3879: if l_return_stat = FALSE then
3880:
3881: fnd_message.set_name('FND','SQL-NO INSERT');
3882: fnd_message.set_token('TABLE','FND_USER');
3883: fnd_msg_pub.Add;
3884: END IF;
3885:
3878: X_LEVEL_VALUE => l_user_id);
3879: if l_return_stat = FALSE then
3880:
3881: fnd_message.set_name('FND','SQL-NO INSERT');
3882: fnd_message.set_token('TABLE','FND_USER');
3883: fnd_msg_pub.Add;
3884: END IF;
3885:
3886:
3922:
3923: if not l_password_updated
3924: then
3925:
3926: c_error_msg := fnd_message.get; -- get the password update error placed on the stack by fnd_user_pvt
3927: displaywebuserlocal(p_message_flag => c_error_msg);
3928: /*
3929: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
3930: fnd_message.set_encoded(l_msg_data);
3926: c_error_msg := fnd_message.get; -- get the password update error placed on the stack by fnd_user_pvt
3927: displaywebuserlocal(p_message_flag => c_error_msg);
3928: /*
3929: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
3930: fnd_message.set_encoded(l_msg_data);
3931: -- fnd_message.set_name('ICX','ICX_PWD_CHG_INVALID');
3932: c_error_msg := fnd_message.get;
3933:
3934: htp.htmlOpen;
3927: displaywebuserlocal(p_message_flag => c_error_msg);
3928: /*
3929: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
3930: fnd_message.set_encoded(l_msg_data);
3931: -- fnd_message.set_name('ICX','ICX_PWD_CHG_INVALID');
3932: c_error_msg := fnd_message.get;
3933:
3934: htp.htmlOpen;
3935: htp.headOpen;
3928: /*
3929: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
3930: fnd_message.set_encoded(l_msg_data);
3931: -- fnd_message.set_name('ICX','ICX_PWD_CHG_INVALID');
3932: c_error_msg := fnd_message.get;
3933:
3934: htp.htmlOpen;
3935: htp.headOpen;
3936: icx_util.copyright;
3961: begin
3962: n_date_format := to_char(sysdate, nvl(l_date_format,'XXX'));
3963: exception
3964: when others then
3965: fnd_message.set_name('ICX','ICX_USE_DATE_FORMAT');
3966: fnd_message.set_token('FORMAT_MASK_TOKEN','DD/MM/RRRR');
3967: l_message := fnd_message.get;
3968: icx_util.add_error(l_message);
3969: icx_admin_sig.error_screen(l_message);
3962: n_date_format := to_char(sysdate, nvl(l_date_format,'XXX'));
3963: exception
3964: when others then
3965: fnd_message.set_name('ICX','ICX_USE_DATE_FORMAT');
3966: fnd_message.set_token('FORMAT_MASK_TOKEN','DD/MM/RRRR');
3967: l_message := fnd_message.get;
3968: icx_util.add_error(l_message);
3969: icx_admin_sig.error_screen(l_message);
3970: l_password_updated := FALSE;
3963: exception
3964: when others then
3965: fnd_message.set_name('ICX','ICX_USE_DATE_FORMAT');
3966: fnd_message.set_token('FORMAT_MASK_TOKEN','DD/MM/RRRR');
3967: l_message := fnd_message.get;
3968: icx_util.add_error(l_message);
3969: icx_admin_sig.error_screen(l_message);
3970: l_password_updated := FALSE;
3971: end;
4097: --htp.p(SQLERRM);
4098: htp.p(dbms_utility.format_error_stack);
4099:
4100: /*
4101: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
4102: c_error_msg := fnd_message.get;
4103: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4104: c_login_msg := fnd_message.get;
4105: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
4098: htp.p(dbms_utility.format_error_stack);
4099:
4100: /*
4101: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
4102: c_error_msg := fnd_message.get;
4103: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4104: c_login_msg := fnd_message.get;
4105: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
4106: */
4099:
4100: /*
4101: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
4102: c_error_msg := fnd_message.get;
4103: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4104: c_login_msg := fnd_message.get;
4105: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
4106: */
4107: end;
4100: /*
4101: fnd_message.set_name('ICX','ICX_SESSION_FAILED');
4102: c_error_msg := fnd_message.get;
4103: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4104: c_login_msg := fnd_message.get;
4105: OracleApps.displayLogin(c_error_msg||' '||c_login_msg,'IC','Y');
4106: */
4107: end;
4108:
4179: c_PASSWORD2, c_PASSWORD3);
4180: if l_result = 'N'
4181: then
4182: l_password_updated := FALSE;
4183: l_ret_msg := fnd_message.get; --bug 2766487
4184: end if; -- result
4185: else
4186: l_password_updated := FALSE;
4187: l_ret_msg := fnd_message.get; --bug 2766487
4183: l_ret_msg := fnd_message.get; --bug 2766487
4184: end if; -- result
4185: else
4186: l_password_updated := FALSE;
4187: l_ret_msg := fnd_message.get; --bug 2766487
4188: end if; -- c_PASSWORD2 = c_PASSWORD3
4189:
4190: if not l_password_updated
4191: then
4189:
4190: if not l_password_updated
4191: then
4192: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
4193: fnd_message.set_name('ICX','ICX_PWD_CHG_INVALID');
4194: c_error_msg := fnd_message.get;
4195:
4196: htp.htmlOpen;
4197: htp.headOpen;
4190: if not l_password_updated
4191: then
4192: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
4193: fnd_message.set_name('ICX','ICX_PWD_CHG_INVALID');
4194: c_error_msg := fnd_message.get;
4195:
4196: htp.htmlOpen;
4197: htp.headOpen;
4198: icx_util.copyright;
4307:
4308: if not l_password_updated
4309: then
4310: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
4311: fnd_message.set_name('ICX','ICX_PWD_CHG_INVALID');
4312: c_error_msg := fnd_message.get;
4313:
4314: htp.htmlOpen;
4315: htp.headOpen;
4308: if not l_password_updated
4309: then
4310: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
4311: fnd_message.set_name('ICX','ICX_PWD_CHG_INVALID');
4312: c_error_msg := fnd_message.get;
4313:
4314: htp.htmlOpen;
4315: htp.headOpen;
4316: icx_util.copyright;
4759: --htp.p('MPUTMAN - pre validate pwd');htp.nl;
4760: l_validated := fnd_web_sec.validate_login(upper(i_1), i_2);
4761: IF l_validated ='N' THEN --login failed
4762: --htp.p('MPUTMAN - pwd NOT validated');htp.nl;
4763: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
4764: l_message := fnd_message.get;
4765: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4766: l_message := l_message||' '||fnd_message.get;
4767:
4760: l_validated := fnd_web_sec.validate_login(upper(i_1), i_2);
4761: IF l_validated ='N' THEN --login failed
4762: --htp.p('MPUTMAN - pwd NOT validated');htp.nl;
4763: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
4764: l_message := fnd_message.get;
4765: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4766: l_message := l_message||' '||fnd_message.get;
4767:
4768: OracleApps.convertSession(c_token => c_token,
4761: IF l_validated ='N' THEN --login failed
4762: --htp.p('MPUTMAN - pwd NOT validated');htp.nl;
4763: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
4764: l_message := fnd_message.get;
4765: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4766: l_message := l_message||' '||fnd_message.get;
4767:
4768: OracleApps.convertSession(c_token => c_token,
4769: c_message =>l_message);
4762: --htp.p('MPUTMAN - pwd NOT validated');htp.nl;
4763: fnd_message.set_name('ICX','ICX_SIGNIN_INVALID');
4764: l_message := fnd_message.get;
4765: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
4766: l_message := l_message||' '||fnd_message.get;
4767:
4768: OracleApps.convertSession(c_token => c_token,
4769: c_message =>l_message);
4770: ELSE --valid login