[Home] [Help]
4863: l_po_number PO_HEADERS.SEGMENT1%type;
4864: l_message varchar2(2001);
4865: l_ammendment_message varchar2(2001);
4866: l_change_summary PO_HEADERS.CHANGE_SUMMARY%type;
4867: l_timezone HZ_TIMEZONES_VL.NAME%TYPE;
4868: l_timezone_id varchar2(10);
4869: l_agreement_assign_query varchar2(2001);
4870: l_arc_agreement_assign_query varchar2(2001);
4871: l_fileClob CLOB := NULL;
4871: l_fileClob CLOB := NULL;
4872: l_variablePosition number := 0;
4873: l_resultOffset number ; -- to store the offset
4874: l_tempXMLResult clob; -- temp xml clob;
4875: l_offset HZ_TIMEZONES_VL.GMT_DEVIATION_HOURS%type; -- to store GMT time difference
4876: l_address_details clob; -- bug#3580225: Clob to hold the address details XML
4877:
4878: l_okc_doc_type VARCHAR2(20); --
4879:
5195: BEGIN
5196: --Bug 6692126 Get the profile value based on prepares context
5197: --Bug 6692126 SELECT fnd_profile.value('SERVER_TIMEZONE_ID') into l_timezone_id from dual;
5198: l_timezone_id := get_preparer_profile(p_document_id, p_document_type, 'SERVER_TIMEZONE_ID'); --Bug 6692126
5199: SELECT name, gmt_deviation_hours into l_timezone, l_offset from HZ_TIMEZONES_VL where timezone_id = to_number(l_timezone_id);
5200: EXCEPTION
5201: WHEN OTHERS THEN
5202: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
5203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Timezone: ','Inside Timezone Exception Handler');