30: if (p_document_number is null) then
31: raise invalid_input;
32: end if;
33:
34: random_number := wf_core.random;
35: logical_id := ecx_trading_partner_pvt.getOAGLOGICALID();
36: date_time := to_char(sysdate, 'YYYY-MM-DD-HH24-MI-SS');
37:
38: x_payload_id := (date_time || '.' || p_document_number || '.' || random_number || '@' || logical_id);
155:
156: if (ecx_eng_utils.g_server_tz is null) then
157: -- get the timezone string
158: -- Check for the Installation Type ( Standalone or Embedded );
159: l_install_mode := wf_core.translate('WF_INSTALL');
160: if l_install_mode = 'EMBEDDED'
161: then
162: l_string := 'begin
163: fnd_profile.get(' || '''ECX_SERVER_TIMEZONE''' || ', ecx_eng_utils.g_server_tz);
163: fnd_profile.get(' || '''ECX_SERVER_TIMEZONE''' || ', ecx_eng_utils.g_server_tz);
164: end;';
165: execute immediate l_string ;
166: else
167: ecx_eng_utils.g_server_tz:= wf_core.translate('ECX_SERVER_TIMEZONE');
168: end if;
169: end if;
170:
171: if (ecx_eng_utils.g_server_tz is null)
248:
249: if (ecx_eng_utils.g_server_tz is null) then
250: -- get the DB timezone ID
251: -- Check for the Installation Type ( Standalone or Embedded );
252: l_install_mode := wf_core.translate('WF_INSTALL');
253:
254: if l_install_mode = 'EMBEDDED'
255: then
256: l_string := 'begin
257: fnd_profile.get(' || '''ECX_SERVER_TIMEZONE''' || ', ecx_eng_utils.g_server_tz);
258: end;';
259: execute immediate l_string ;
260: else
261: ecx_eng_utils.g_server_tz:= wf_core.translate('ECX_SERVER_TIMEZONE');
262: end if;
263: end if;
264:
265: if (ecx_eng_utils.g_server_tz is null)