2688:
2689: if (ecx_actions.g_server_timezone is null) then
2690: --- Check for the Installation Type ( Standalone or Embedded );
2691: if (ecx_utils.g_install_mode is null) then
2692: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
2693: end if;
2694:
2695: if ecx_utils.g_install_mode = 'EMBEDDED'
2696: then
2698: fnd_profile.get('||'''ECX_SERVER_TIMEZONE'''||',ecx_actions.g_server_timezone);
2699: end;';
2700: execute immediate i_string ;
2701: else
2702: ecx_actions.g_server_timezone:= wf_core.translate('ECX_SERVER_TIMEZONE');
2703: end if;
2704: end if;
2705:
2706:
3486:
3487: if (ecx_actions.g_server_timezone is null) then
3488: --- Check for the Installation Type ( Standalone or Embedded );
3489: if (ecx_utils.g_install_mode is null) then
3490: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
3491: end if;
3492:
3493: if ecx_utils.g_install_mode = 'EMBEDDED'
3494: then
3496: fnd_profile.get('||'''ECX_SERVER_TIMEZONE'''||',ecx_actions.g_server_timezone);
3497: end;';
3498: execute immediate i_string ;
3499: else
3500: ecx_actions.g_server_timezone:= wf_core.translate('ECX_SERVER_TIMEZONE');
3501: end if;
3502: end if;
3503:
3504: -- if profile option is not set assume gmt
4590:
4591: if (ecx_actions.g_xslt_dir is null) then
4592: --- Check for the Installation Type ( Standalone or Embedded );
4593: if (ecx_utils.g_install_mode is null) then
4594: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
4595: end if;
4596:
4597: if ecx_utils.g_install_mode = 'EMBEDDED'
4598: then
4600: fnd_profile.get('||'''ECX_UTL_XSLT_DIR'''||',ecx_actions.g_xslt_dir);
4601: end;';
4602: execute immediate i_string ;
4603: else
4604: ecx_actions.g_xslt_dir:= wf_core.translate('ECX_UTL_XSLT_DIR');
4605: end if;
4606: end if;
4607:
4608: i_fullpath := ecx_actions.g_xslt_dir||ecx_utils.getFileSeparator()||i_filename;
5884:
5885: if (ecx_actions.g_xslt_dir is null) then
5886: --- Check for the Installation Type ( Standalone or Embedded );
5887: if (ecx_utils.g_install_mode is null) then
5888: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
5889: end if;
5890:
5891: if ecx_utils.g_install_mode = 'EMBEDDED'
5892: then
5894: fnd_profile.get('||'''ECX_UTL_XSLT_DIR'''||',ecx_actions.g_xslt_dir);
5895: end;';
5896: execute immediate i_string ;
5897: else
5898: ecx_actions.g_xslt_dir:= wf_core.translate('ECX_UTL_XSLT_DIR');
5899: end if;
5900: end if;
5901:
5902: i_fullpath := ecx_actions.g_xslt_dir||ecx_utils.getFileSeparator()||i_filename;