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_POR_SCHEMA_UPGRADE dependencies on ICX_POR_EXT_UTL

Line 196: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Open the get_categories cursor to get distinct categories');

192: BEGIN
193:
194: -- Open the cursor for getting categories that have descriptors
195: l_loc := 100;
196: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Open the get_categories cursor to get distinct categories');
197:
198: open get_categories for
199: select distinct RT_CATEGORY_ID
200: from icx_cat_descriptors_tl;

Line 204: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Loop through every category to assign section tag and section map');

200: from icx_cat_descriptors_tl;
201:
202: l_loc := 200;
203:
204: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Loop through every category to assign section tag and section map');
205:
206: -- Loop through every category to assign section tag and section map.
207: LOOP
208: l_loc := 300;

Line 222: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Assigning section tag and section map for rt_category_id = '|| l_category_ids(i));

218: l_loc := 300+i;
219:
220: ICX_POR_SCHEMA_UPLOAD.assign_all_section_tags(l_category_ids(i));
221:
222: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Assigning section tag and section map for rt_category_id = '|| l_category_ids(i));
223:
224: end loop;
225: l_loc := 10000;
226:

Line 231: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Close cursor...');

227: COMMIT;
228: END LOOP;
229: l_loc := 20000;
230:
231: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Close cursor...');
232: CLOSE get_categories;
233: l_loc := 20010;
234:
235: EXCEPTION

Line 253: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Schema upgrade Start.');

249: PROCEDURE upgrade IS
250: BEGIN
251: l_loc := 100;
252:
253: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Schema upgrade Start.');
254:
255: -- Populate the rows in all the schema tables(Categories, Descriptors, TOC)
256: create_new_categ_descs_tables();
257: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Created the new Category, Descriptor and TOC table.');

Line 257: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Created the new Category, Descriptor and TOC table.');

253: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Schema upgrade Start.');
254:
255: -- Populate the rows in all the schema tables(Categories, Descriptors, TOC)
256: create_new_categ_descs_tables();
257: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Created the new Category, Descriptor and TOC table.');
258: l_loc := 200;
259:
260: assign_section_tag_and_map();
261: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Populated the new Category and Descriptors table with section maps and section tags.');

Line 261: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Populated the new Category and Descriptors table with section maps and section tags.');

257: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Created the new Category, Descriptor and TOC table.');
258: l_loc := 200;
259:
260: assign_section_tag_and_map();
261: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Populated the new Category and Descriptors table with section maps and section tags.');
262:
263: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'End Upgrade');
264:
265: EXCEPTION

Line 263: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'End Upgrade');

259:
260: assign_section_tag_and_map();
261: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'Populated the new Category and Descriptors table with section maps and section tags.');
262:
263: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'End Upgrade');
264:
265: EXCEPTION
266: WHEN OTHERS THEN
267: