355: l_plug_id := getPlug.PLUG_ID;
356: l_display := getPlug.display;
357: l_plugType := getPlug.TYPE;
358: if l_host is null then
359: l_host := owa_util.get_cgi_env('SERVER_NAME');
360: end if;
361: if l_html_call is null then
362: l_html_call := 'x';
363: end if;
443: -- OAS approach
444: -- l_url:= '/OA_JAVA_SERV/oracle.apps.icx.myPage.renderPage';
445: -- Below is for Servlet approach
446: l_url := fnd_profile.value('APPS_SERVLET_AGENT')||'oracle.apps.icx.myPage.renderPage';
447: l_server_name := owa_util.get_cgi_env('SERVER_NAME');
448: l_server_port := owa_util.get_cgi_env('SERVER_PORT');
449:
450: l_url:= l_url||'?db_host='||l_dbhost||'&'||'main_region_id='||to_char(main_region_id)||
451: '&'||'page_id='||to_char(page_id)||'&'||'user_id='||to_char(user_id)||
444: -- l_url:= '/OA_JAVA_SERV/oracle.apps.icx.myPage.renderPage';
445: -- Below is for Servlet approach
446: l_url := fnd_profile.value('APPS_SERVLET_AGENT')||'oracle.apps.icx.myPage.renderPage';
447: l_server_name := owa_util.get_cgi_env('SERVER_NAME');
448: l_server_port := owa_util.get_cgi_env('SERVER_PORT');
449:
450: l_url:= l_url||'?db_host='||l_dbhost||'&'||'main_region_id='||to_char(main_region_id)||
451: '&'||'page_id='||to_char(page_id)||'&'||'user_id='||to_char(user_id)||
452: '&'||'session_id='||to_char(session_id)||'&'||'agent='||l_agent||
527: then
528:
529: l_url := fnd_sso_manager.getLoginUrl;
530:
531: owa_util.mime_header('text/html', FALSE);
532: owa_util.redirect_url(l_url);
533: owa_util.http_header_close;
534:
535: else
528:
529: l_url := fnd_sso_manager.getLoginUrl;
530:
531: owa_util.mime_header('text/html', FALSE);
532: owa_util.redirect_url(l_url);
533: owa_util.http_header_close;
534:
535: else
536:
529: l_url := fnd_sso_manager.getLoginUrl;
530:
531: owa_util.mime_header('text/html', FALSE);
532: owa_util.redirect_url(l_url);
533: owa_util.http_header_close;
534:
535: else
536:
537: /* Only support 115P
821: htp.p ('Please contact System Administrator. ');
822: htp.p ('Profile - APPS_PORTAL is null') ;
823: end If ;
824:
825: owa_util.mime_header('text/html', FALSE);
826: owa_util.redirect_url(l_url);
827: owa_util.http_header_close;
828:
829: elsif fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'FWK'
822: htp.p ('Profile - APPS_PORTAL is null') ;
823: end If ;
824:
825: owa_util.mime_header('text/html', FALSE);
826: owa_util.redirect_url(l_url);
827: owa_util.http_header_close;
828:
829: elsif fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'FWK'
830: then
823: end If ;
824:
825: owa_util.mime_header('text/html', FALSE);
826: owa_util.redirect_url(l_url);
827: owa_util.http_header_close;
828:
829: elsif fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'FWK'
830: then
831: select FUNCTION_ID
839: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
840: p_function_id => l_function_id,
841: p_url_only => 'Y');
842:
843: owa_util.mime_header('text/html', FALSE);
844: owa_util.redirect_url(l_url);
845: owa_util.http_header_close;
846:
847: else -- PHP
840: p_function_id => l_function_id,
841: p_url_only => 'Y');
842:
843: owa_util.mime_header('text/html', FALSE);
844: owa_util.redirect_url(l_url);
845: owa_util.http_header_close;
846:
847: else -- PHP
848: -- begin 1352780 block
841: p_url_only => 'Y');
842:
843: owa_util.mime_header('text/html', FALSE);
844: owa_util.redirect_url(l_url);
845: owa_util.http_header_close;
846:
847: else -- PHP
848: -- begin 1352780 block
849: