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.ICX_CATG dependencies on HTP

Line 54: htp.htmlOpen;

50: IF l_total_rows = 0 THEN
51: -- Print the no data found message.
52: -- Do not spwan the spread sheet
53: -- This will not happen
54: htp.htmlOpen;
55: htp.headOpen;
56: icx_util.copyright;
57: js.scriptOpen;
58: icx_admin_sig.help_win_script(v_help_url, v_language_code);

Line 55: htp.headOpen;

51: -- Print the no data found message.
52: -- Do not spwan the spread sheet
53: -- This will not happen
54: htp.htmlOpen;
55: htp.headOpen;
56: icx_util.copyright;
57: js.scriptOpen;
58: icx_admin_sig.help_win_script(v_help_url, v_language_code);
59: js.scriptClose;

Line 60: htp.title(ak_query_pkg.g_regions_table(0).name);

56: icx_util.copyright;
57: js.scriptOpen;
58: icx_admin_sig.help_win_script(v_help_url, v_language_code);
59: js.scriptClose;
60: htp.title(ak_query_pkg.g_regions_table(0).name);
61: htp.headClose;
62:
63: icx_admin_sig.toolbar(language_code => v_language_code,
64: disp_find => 'icx_store_catg_templates.find_categories');

Line 61: htp.headClose;

57: js.scriptOpen;
58: icx_admin_sig.help_win_script(v_help_url, v_language_code);
59: js.scriptClose;
60: htp.title(ak_query_pkg.g_regions_table(0).name);
61: htp.headClose;
62:
63: icx_admin_sig.toolbar(language_code => v_language_code,
64: disp_find => 'icx_store_catg_templates.find_categories');
65: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');

Line 68: htp.br;

64: disp_find => 'icx_store_catg_templates.find_categories');
65: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
66: fnd_message.set_token('NAME_OF_REGION_TOKEN',
67: ak_query_pkg.g_regions_table(0).name);
68: htp.br;
69: htp.tableOpen('BORDER=0');
70: htp.tableRowOpen;
71: htp.tableData(cvalue => ''||fnd_message.get||'
72: ',cattributes => 'VALIGN="MIDDLE"');

Line 69: htp.tableOpen('BORDER=0');

65: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
66: fnd_message.set_token('NAME_OF_REGION_TOKEN',
67: ak_query_pkg.g_regions_table(0).name);
68: htp.br;
69: htp.tableOpen('BORDER=0');
70: htp.tableRowOpen;
71: htp.tableData(cvalue => ''||fnd_message.get||'
72: ',cattributes => 'VALIGN="MIDDLE"');
73: htp.tableClose;

Line 70: htp.tableRowOpen;

66: fnd_message.set_token('NAME_OF_REGION_TOKEN',
67: ak_query_pkg.g_regions_table(0).name);
68: htp.br;
69: htp.tableOpen('BORDER=0');
70: htp.tableRowOpen;
71: htp.tableData(cvalue => ''||fnd_message.get||'
72: ',cattributes => 'VALIGN="MIDDLE"');
73: htp.tableClose;
74: htp.br;

Line 71: htp.tableData(cvalue => ''||fnd_message.get||'

67: ak_query_pkg.g_regions_table(0).name);
68: htp.br;
69: htp.tableOpen('BORDER=0');
70: htp.tableRowOpen;
71: htp.tableData(cvalue => ''||fnd_message.get||'
72: ',cattributes => 'VALIGN="MIDDLE"');
73: htp.tableClose;
74: htp.br;
75: icx_admin_sig.footer;

Line 73: htp.tableClose;

69: htp.tableOpen('BORDER=0');
70: htp.tableRowOpen;
71: htp.tableData(cvalue => ''||fnd_message.get||'
72: ',cattributes => 'VALIGN="MIDDLE"');
73: htp.tableClose;
74: htp.br;
75: icx_admin_sig.footer;
76: ELSE
77: -- Set the mime type to spread sheet for automatic spawning

Line 74: htp.br;

70: htp.tableRowOpen;
71: htp.tableData(cvalue => ''||fnd_message.get||'
72: ',cattributes => 'VALIGN="MIDDLE"');
73: htp.tableClose;
74: htp.br;
75: icx_admin_sig.footer;
76: ELSE
77: -- Set the mime type to spread sheet for automatic spawning
78: owa_util.mime_header('application/msexcel');

Line 82: htp.p(FND_MESSAGE.GET);

78: owa_util.mime_header('application/msexcel');
79:
80: -- Print the first three instruction lines
81: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE1');
82: htp.p(FND_MESSAGE.GET);
83: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE2');
84: FND_MESSAGE.SET_TOKEN('ICX_DATE_FORMAT', l_date_format);
85: htp.p(FND_MESSAGE.GET);
86: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE3');

Line 85: htp.p(FND_MESSAGE.GET);

81: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE1');
82: htp.p(FND_MESSAGE.GET);
83: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE2');
84: FND_MESSAGE.SET_TOKEN('ICX_DATE_FORMAT', l_date_format);
85: htp.p(FND_MESSAGE.GET);
86: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE3');
87: htp.p(FND_MESSAGE.GET);
88: htp.p;
89:

Line 87: htp.p(FND_MESSAGE.GET);

83: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE2');
84: FND_MESSAGE.SET_TOKEN('ICX_DATE_FORMAT', l_date_format);
85: htp.p(FND_MESSAGE.GET);
86: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE3');
87: htp.p(FND_MESSAGE.GET);
88: htp.p;
89:
90: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
91: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'

Line 88: htp.p;

84: FND_MESSAGE.SET_TOKEN('ICX_DATE_FORMAT', l_date_format);
85: htp.p(FND_MESSAGE.GET);
86: FND_MESSAGE.SET_NAME('ICX','ICX_CATG_XL_LINE3');
87: htp.p(FND_MESSAGE.GET);
88: htp.p;
89:
90: FOR i IN ak_query_pkg.g_items_table.FIRST..ak_query_pkg.g_items_table.LAST LOOP
91: IF (ak_query_pkg.g_items_table(i).secured_column = 'F'
92: AND ak_query_pkg.g_items_table(i).node_display_flag = 'Y' )

Line 102: htp.p(l_line);

98:
99: END LOOP;
100:
101: -- Print the line string
102: htp.p(l_line);
103:
104: -- FOR r IN p_start_row -1..v_end_row - 1 LOOP
105: FOR r IN ak_query_pkg.g_results_table.FIRST..ak_query_pkg.g_results_table.LAST LOOP
106: icx_util.transfer_Row_To_Column(ak_query_pkg.g_results_table(r),y_table);

Line 120: htp.p(l_line);

116: END IF; -- IF ... secured_column = 'F'...
117:
118: END LOOP; -- FOR i ...
119:
120: htp.p(l_line);
121:
122: END LOOP; -- FOR r ...
123:
124: END IF; -- IF l_totlal_rows = 0

Line 130: -- htp.p('Error in xls: ' || substr(SQLERRM, 1, 512));

126: END IF; -- IF validateSession
127:
128: EXCEPTION
129: WHEN OTHERS THEN
130: -- htp.p('Error in xls: ' || substr(SQLERRM, 1, 512));
131: icx_util.add_error(substr(SQLERRM, 12, 512));
132: icx_util.error_page_print;
133: END xls;
134: