eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RA_ANALYSER_PVT dependencies on DBMS_XMLGEN

Line 2073: -- XML generated with dbms_xmlgen doesnt have encoding information. so we need to manually insert into the resultant CLOB.

2069: -- Open a temporary lob for merging the contents.
2070: dbms_lob.createTemporary( l_fct_data_lob, true );
2071: dbms_lob.open( l_fct_data_lob, dbms_lob.lob_readwrite );
2072:
2073: -- XML generated with dbms_xmlgen doesnt have encoding information. so we need to manually insert into the resultant CLOB.
2074: dbms_lob.write(l_fct_data_lob,length(''),1,'');
2075: /*
2076: mpothuku Added fnd_global.local_chr(10) (or new line) for the Bug 5724555 on 21-Dec-06. FND_FILE.put has a restriction of 32K characters.
2077: If there is no new-line in these 32K characters, it fails. So ensuring that there are new-line characters after every line

Line 2097: --mpothuku added dbms_xmlgen.convert on 08-May-2007 to fix the Bug 6038466

2093: END IF;
2094: IF (p_concurrent_flag = 'Y') THEN
2095: fnd_file.put_line(fnd_file.log, ' -- Creating Clob for Output File -- ');
2096: END IF;
2097: --mpothuku added dbms_xmlgen.convert on 08-May-2007 to fix the Bug 6038466
2098: /*
2099: Note by mpothuku on 09-May-2007: Consider revising the string concat logic below and
2100: write each XML line immediately into the CLOB and the log, so that the l_dummy_string size is not huge.
2101: We already had to increase the size from 1000 to 5000, as XML encode bloats up the size of the strings.

Line 2108: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_org_code_tbl(c)) ||''||fnd_global.local_chr(10);

2104: IF l_incl_in_rpt_flag_tbl(c) = 'Y' THEN -- Check if Interface rec is candidate for Output report.
2105: l_row_count := l_row_count + 1;
2106: l_dummy_string := ''||fnd_global.local_chr(10);
2107: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).ORGANIZATION_ID ||''||fnd_global.local_chr(10);
2108: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_org_code_tbl(c)) ||''||fnd_global.local_chr(10);
2109: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).INVENTORY_ITEM_ID ||''||fnd_global.local_chr(10);
2110: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_name_tbl(c)) ||''||fnd_global.local_chr(10);
2111: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_desc_tbl(c)) ||''||fnd_global.local_chr(10);
2112: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_srl_no_tbl(c)) ||''||fnd_global.local_chr(10);

Line 2110: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_name_tbl(c)) ||''||fnd_global.local_chr(10);

2106: l_dummy_string := ''||fnd_global.local_chr(10);
2107: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).ORGANIZATION_ID ||''||fnd_global.local_chr(10);
2108: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_org_code_tbl(c)) ||''||fnd_global.local_chr(10);
2109: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).INVENTORY_ITEM_ID ||''||fnd_global.local_chr(10);
2110: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_name_tbl(c)) ||''||fnd_global.local_chr(10);
2111: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_desc_tbl(c)) ||''||fnd_global.local_chr(10);
2112: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_srl_no_tbl(c)) ||''||fnd_global.local_chr(10);
2113: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).FORECAST_DESIGNATOR) ||''||fnd_global.local_chr(10);
2114: --mpothuku Added to_char on 23 Aug, 06 for XSL canonical date format to be used by the XMLP report for the Bug 5460793

Line 2111: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_desc_tbl(c)) ||''||fnd_global.local_chr(10);

2107: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).ORGANIZATION_ID ||''||fnd_global.local_chr(10);
2108: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_org_code_tbl(c)) ||''||fnd_global.local_chr(10);
2109: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).INVENTORY_ITEM_ID ||''||fnd_global.local_chr(10);
2110: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_name_tbl(c)) ||''||fnd_global.local_chr(10);
2111: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_desc_tbl(c)) ||''||fnd_global.local_chr(10);
2112: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_srl_no_tbl(c)) ||''||fnd_global.local_chr(10);
2113: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).FORECAST_DESIGNATOR) ||''||fnd_global.local_chr(10);
2114: --mpothuku Added to_char on 23 Aug, 06 for XSL canonical date format to be used by the XMLP report for the Bug 5460793
2115: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'YYYY-MM-DD')||''||fnd_global.local_chr(10);

Line 2112: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_srl_no_tbl(c)) ||''||fnd_global.local_chr(10);

2108: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_org_code_tbl(c)) ||''||fnd_global.local_chr(10);
2109: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).INVENTORY_ITEM_ID ||''||fnd_global.local_chr(10);
2110: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_name_tbl(c)) ||''||fnd_global.local_chr(10);
2111: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_desc_tbl(c)) ||''||fnd_global.local_chr(10);
2112: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_srl_no_tbl(c)) ||''||fnd_global.local_chr(10);
2113: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).FORECAST_DESIGNATOR) ||''||fnd_global.local_chr(10);
2114: --mpothuku Added to_char on 23 Aug, 06 for XSL canonical date format to be used by the XMLP report for the Bug 5460793
2115: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'YYYY-MM-DD')||''||fnd_global.local_chr(10);
2116: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'MON-YYYY')||''||fnd_global.local_chr(10);

Line 2113: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).FORECAST_DESIGNATOR) ||''||fnd_global.local_chr(10);

2109: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).INVENTORY_ITEM_ID ||''||fnd_global.local_chr(10);
2110: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_name_tbl(c)) ||''||fnd_global.local_chr(10);
2111: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_desc_tbl(c)) ||''||fnd_global.local_chr(10);
2112: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_srl_no_tbl(c)) ||''||fnd_global.local_chr(10);
2113: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).FORECAST_DESIGNATOR) ||''||fnd_global.local_chr(10);
2114: --mpothuku Added to_char on 23 Aug, 06 for XSL canonical date format to be used by the XMLP report for the Bug 5460793
2115: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'YYYY-MM-DD')||''||fnd_global.local_chr(10);
2116: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'MON-YYYY')||''||fnd_global.local_chr(10);
2117: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).QUANTITY ||''||fnd_global.local_chr(10);

Line 2124: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).ERROR_MESSAGE) ||''||fnd_global.local_chr(10);

2120: l_dummy_string := l_dummy_string || '' ||l_forecast_osp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2121: l_dummy_string := l_dummy_string || '' ||l_forecast_vwp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2122: l_dummy_string := l_dummy_string || '' ||l_forecast_non_qty_tbl(c) ||''||fnd_global.local_chr(10);
2123: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).PROCESS_STATUS ||''||fnd_global.local_chr(10);
2124: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).ERROR_MESSAGE) ||''||fnd_global.local_chr(10);
2125: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).SOURCE_CODE) ||''||fnd_global.local_chr(10);
2126: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).SOURCE_LINE_ID ||''||fnd_global.local_chr(10);
2127:
2128: -- This 'Hard Coded' Data will be replaced by Lookups / Messages -- Pending

Line 2125: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).SOURCE_CODE) ||''||fnd_global.local_chr(10);

2121: l_dummy_string := l_dummy_string || '' ||l_forecast_vwp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2122: l_dummy_string := l_dummy_string || '' ||l_forecast_non_qty_tbl(c) ||''||fnd_global.local_chr(10);
2123: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).PROCESS_STATUS ||''||fnd_global.local_chr(10);
2124: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).ERROR_MESSAGE) ||''||fnd_global.local_chr(10);
2125: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).SOURCE_CODE) ||''||fnd_global.local_chr(10);
2126: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).SOURCE_LINE_ID ||''||fnd_global.local_chr(10);
2127:
2128: -- This 'Hard Coded' Data will be replaced by Lookups / Messages -- Pending
2129: IF l_forecast_interface_tbl(c).PROCESS_STATUS = 1 THEN