[Home] [Help]
4119: l_po_number PO_HEADERS.SEGMENT1%type;
4120: l_message varchar2(2001);
4121: l_ammendment_message varchar2(2001);
4122: l_change_summary PO_HEADERS.CHANGE_SUMMARY%type;
4123: l_timezone HZ_TIMEZONES_VL.NAME%TYPE;
4124: l_timezone_id varchar2(10);
4125: l_agreement_assign_query varchar2(2001);
4126: l_arc_agreement_assign_query varchar2(2001);
4127: l_fileClob CLOB := NULL;
4127: l_fileClob CLOB := NULL;
4128: l_variablePosition number :=0;
4129: l_resultOffset number ; -- to store the offset
4130: l_tempXMLResult clob; -- temp xml clob;
4131: l_offset HZ_TIMEZONES_VL.GMT_DEVIATION_HOURS%type; -- to store GMT time difference
4132: l_address_details clob; -- bug#3580225: Clob to hold the address details XML
4133:
4134: l_okc_doc_type VARCHAR2(20); --
4135:
4437: BEGIN
4438: --Bug 6692126 Get the profile value based on prepares context
4439: --Bug 6692126 SELECT fnd_profile.value('SERVER_TIMEZONE_ID') into l_timezone_id from dual;
4440: l_timezone_id := get_preparer_profile(p_document_id,p_document_type,'SERVER_TIMEZONE_ID'); --Bug 6692126
4441: SELECT name, gmt_deviation_hours into l_timezone, l_offset from HZ_TIMEZONES_VL where timezone_id=to_number(l_timezone_id);
4442: EXCEPTION
4443: WHEN OTHERS THEN
4444: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
4445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Timezone: ','Inside Timezone Exception Handler');