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_UPLOAD dependencies on ICX_POR_SCHEMA_UPLOAD

Line 1: PACKAGE BODY ICX_POR_SCHEMA_UPLOAD AS

1: PACKAGE BODY ICX_POR_SCHEMA_UPLOAD AS
2: /* $Header: ICXSULDB.pls 115.26 2004/08/03 00:56:56 kaholee ship $*/
3:
4: -- Default number of characters for columns created as VARCHAR2
5: DEFAULT_COLUMN_SIZE CONSTANT Number := 700;

Line 182: (-20000, 'Exception at ICX_POR_SCHEMA_UPLOAD.populate_ctx_desc_indexes('||

178: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);
179: END IF;
180:
181: RAISE_APPLICATION_ERROR
182: (-20000, 'Exception at ICX_POR_SCHEMA_UPLOAD.populate_ctx_desc_indexes('||
183: xErrLoc||'), '|| SQLERRM);
184:
185: END populate_ctx_desc_indexes;
186:

Line 308: 'Exception at ICX_POR_SCHEMA_UPLOAD.add_child_category('

304: WHEN OTHERS THEN
305: ROLLBACK;
306:
307: RAISE_APPLICATION_ERROR(-20000,
308: 'Exception at ICX_POR_SCHEMA_UPLOAD.add_child_category('
309: || xErrLoc || '): ' || SQLERRM);
310:
311: END add_child_category;
312:

Line 362: 'Exception at ICX_POR_SCHEMA_UPLOAD.delete_child_category('

358: WHEN OTHERS THEN
359: ROLLBACK;
360:
361: RAISE_APPLICATION_ERROR(-20000,
362: 'Exception at ICX_POR_SCHEMA_UPLOAD.delete_child_category('
363: || xErrLoc || '): ' || SQLERRM);
364:
365: END delete_child_category;
366:

Line 444: 'Exception at ICX_POR_SCHEMA_UPLOAD.create_category('

440: WHEN OTHERS THEN
441: ROLLBACK;
442:
443: RAISE_APPLICATION_ERROR(-20000,
444: 'Exception at ICX_POR_SCHEMA_UPLOAD.create_category('
445: || xErrLoc || '): ' || SQLERRM);
446:
447: END create_category;
448:

Line 628: 'Exception at ICX_POR_SCHEMA_UPLOAD.create_descriptor('

624: WHEN OTHERS THEN
625: ROLLBACK;
626:
627: RAISE_APPLICATION_ERROR(-20000,
628: 'Exception at ICX_POR_SCHEMA_UPLOAD.create_descriptor('
629: || xErrLoc || '): ' || SQLERRM);
630:
631: END create_descriptor;
632:

Line 725: 'Exception at ICX_POR_SCHEMA_UPLOAD.create_descriptor_metadata('

721: WHEN OTHERS THEN
722: ROLLBACK;
723:
724: RAISE_APPLICATION_ERROR(-20000,
725: 'Exception at ICX_POR_SCHEMA_UPLOAD.create_descriptor_metadata('
726: || xErrLoc || '): ' || SQLERRM);
727:
728: END create_descriptor_metadata;
729:

Line 871: 'Exception at ICX_POR_SCHEMA_UPLOAD.update_category('

867: WHEN OTHERS THEN
868: ROLLBACK;
869:
870: RAISE_APPLICATION_ERROR(-20000,
871: 'Exception at ICX_POR_SCHEMA_UPLOAD.update_category('
872: || xErrLoc || '): ' || SQLERRM);
873:
874: END update_category;
875:

Line 1000: 'Exception at ICX_POR_SCHEMA_UPLOAD.update_descriptor('

996: WHEN OTHERS THEN
997: ROLLBACK;
998:
999: RAISE_APPLICATION_ERROR(-20000,
1000: 'Exception at ICX_POR_SCHEMA_UPLOAD.update_descriptor('
1001: || xErrLoc || '): ' || SQLERRM);
1002:
1003: END update_descriptor;
1004:

Line 1098: 'Exception at ICX_POR_SCHEMA_UPLOAD.delete_category('

1094: WHEN OTHERS THEN
1095: ROLLBACK;
1096:
1097: RAISE_APPLICATION_ERROR(-20000,
1098: 'Exception at ICX_POR_SCHEMA_UPLOAD.delete_category('
1099: || xErrLoc || '): ' || SQLERRM);
1100:
1101: END delete_category;
1102:

Line 1156: 'Exception at ICX_POR_SCHEMA_UPLOAD.delete_category_tree('

1152: WHEN OTHERS THEN
1153: ROLLBACK;
1154:
1155: RAISE_APPLICATION_ERROR(-20000,
1156: 'Exception at ICX_POR_SCHEMA_UPLOAD.delete_category_tree('
1157: || xErrLoc || '): ' || SQLERRM);
1158:
1159: END delete_category_tree;
1160:

Line 1263: 'Exception at ICX_POR_SCHEMA_UPLOAD.delete_descriptor('

1259: WHEN OTHERS THEN
1260: ROLLBACK;
1261:
1262: RAISE_APPLICATION_ERROR(-20000,
1263: 'Exception at ICX_POR_SCHEMA_UPLOAD.delete_descriptor('
1264: || xErrLoc || '): ' || SQLERRM);
1265:
1266: END delete_descriptor;
1267:

Line 1694: (-20000, 'Exception at ICX_POR_SCHEMA_UPLOAD.validate_descriptor(ErrLoc = ' || l_progress ||') ' ||

1690: COMMIT;
1691: EXCEPTION
1692: WHEN OTHERS then
1693: RAISE_APPLICATION_ERROR
1694: (-20000, 'Exception at ICX_POR_SCHEMA_UPLOAD.validate_descriptor(ErrLoc = ' || l_progress ||') ' ||
1695: 'SQL Error : ' || SQLERRM);
1696: END validate_descriptor;
1697:
1698: PROCEDURE validate_category(p_request_id IN OUT NOCOPY NUMBER,

Line 1941: (-20000, 'Exception at ICX_POR_SCHEMA_UPLOAD.validate_category(ErrLoc = ' || l_progress ||') ' ||

1937:
1938: EXCEPTION
1939: WHEN others THEN
1940: RAISE_APPLICATION_ERROR
1941: (-20000, 'Exception at ICX_POR_SCHEMA_UPLOAD.validate_category(ErrLoc = ' || l_progress ||') ' ||
1942: 'SQL Error : ' || SQLERRM);
1943: END validate_category;
1944:
1945: PROCEDURE validate_hier_relationship(p_request_id IN OUT NOCOPY NUMBER,

Line 2164: (-20000, 'Exception at ICX_POR_SCHEMA_UPLOAD.validate_hier_relationship(ErrLoc = ' || l_progress ||') ' || 'SQL Error : ' || SQLERRM);

2160: COMMIT;
2161: EXCEPTION
2162: WHEN OTHERS then
2163: RAISE_APPLICATION_ERROR
2164: (-20000, 'Exception at ICX_POR_SCHEMA_UPLOAD.validate_hier_relationship(ErrLoc = ' || l_progress ||') ' || 'SQL Error : ' || SQLERRM);
2165: END validate_hier_relationship;
2166:
2167:
2168: PROCEDURE InsertError(p_request_id in out NOCOPY number,

Line 2203: (-20000, 'Exception at ICX_POR_SCHEMA_UPLOAD.InsertError(ErrLoc = ' || l_progress ||') ' ||

2199: EXCEPTION
2200: WHEN others THEN
2201: -- Debug('[InsertError-'||l_progress||'] '||SQLERRM);
2202: RAISE_APPLICATION_ERROR
2203: (-20000, 'Exception at ICX_POR_SCHEMA_UPLOAD.InsertError(ErrLoc = ' || l_progress ||') ' ||
2204: 'SQL Error : ' || SQLERRM);
2205: END InsertError;
2206:
2207: /**

Line 2267: RAISE_APPLICATION_ERROR(-20000,'Exception at ICX_POR_SCHEMA_UPLOAD.release_section_tag(' || xErrLoc || '): ' || SQLERRM);

2263: COMMIT;
2264: EXCEPTION
2265: WHEN OTHERS THEN
2266: ROLLBACK;
2267: RAISE_APPLICATION_ERROR(-20000,'Exception at ICX_POR_SCHEMA_UPLOAD.release_section_tag(' || xErrLoc || '): ' || SQLERRM);
2268: END release_section_tag;
2269:
2270:
2271: /**

Line 2413: RAISE_APPLICATION_ERROR(-20000,'Exception at ICX_POR_SCHEMA_UPLOAD.assign_section_tag(' || xErrLoc || '): ' || SQLERRM);

2409: COMMIT;
2410: EXCEPTION
2411: WHEN OTHERS THEN
2412: ROLLBACK;
2413: RAISE_APPLICATION_ERROR(-20000,'Exception at ICX_POR_SCHEMA_UPLOAD.assign_section_tag(' || xErrLoc || '): ' || SQLERRM);
2414: END assign_section_tag;
2415:
2416: /**
2417: ** Proc : assign_all_section_tags

Line 2566: RAISE_APPLICATION_ERROR(-20000,'Exception at ICX_POR_SCHEMA_UPLOAD.assign_all_section_tags(' || xErrLoc || '): ' || SQLERRM);

2562: COMMIT;
2563: EXCEPTION
2564: WHEN OTHERS THEN
2565: ROLLBACK;
2566: RAISE_APPLICATION_ERROR(-20000,'Exception at ICX_POR_SCHEMA_UPLOAD.assign_all_section_tags(' || xErrLoc || '): ' || SQLERRM);
2567: END assign_all_section_tags;
2568:
2569: /**
2570: ** Proc : get_stored_in_values

Line 2640: RAISE_APPLICATION_ERROR(-20000,'Exception at ICX_POR_SCHEMA_UPLOAD.get_stored_in_values(' || xErrLoc || '): ' || SQLERRM);

2636:
2637: EXCEPTION
2638: WHEN OTHERS THEN
2639: ROLLBACK;
2640: RAISE_APPLICATION_ERROR(-20000,'Exception at ICX_POR_SCHEMA_UPLOAD.get_stored_in_values(' || xErrLoc || '): ' || SQLERRM);
2641: END get_stored_in_values;
2642:
2643: PROCEDURE save_failed_category(p_request_id IN NUMBER,
2644: p_line_number IN NUMBER,

Line 2943: 'Exception at ICX_POR_SCHEMA_UPLOAD.inc_schema_change_version('

2939: WHEN OTHERS THEN
2940: ROLLBACK;
2941:
2942: RAISE_APPLICATION_ERROR(-20000,
2943: 'Exception at ICX_POR_SCHEMA_UPLOAD.inc_schema_change_version('
2944: || xErrLoc || '): ' || SQLERRM);
2945: END inc_schema_change_version;
2946:
2947: -- Bug#2323821

Line 3155: 'Exception at ICX_POR_SCHEMA_UPLOAD.sync_deleted_descriptors('

3151: WHEN OTHERS THEN
3152: ROLLBACK;
3153:
3154: RAISE_APPLICATION_ERROR(-20000,
3155: 'Exception at ICX_POR_SCHEMA_UPLOAD.sync_deleted_descriptors('
3156: || xErrLoc || '): ' || SQLERRM);
3157:
3158: END sync_deleted_descriptors;
3159:

Line 3253: 'Exception at ICX_POR_SCHEMA_UPLOAD.update_items_for_category('

3249: WHEN OTHERS THEN
3250: ROLLBACK;
3251:
3252: RAISE_APPLICATION_ERROR(-20000,
3253: 'Exception at ICX_POR_SCHEMA_UPLOAD.update_items_for_category('
3254: || xErrLoc || '): ' || SQLERRM);
3255:
3256: END update_items_for_category;
3257:

Line 3320: 'Exception at ICX_POR_SCHEMA_UPLOAD.handle_delete_descriptors('

3316: WHEN OTHERS THEN
3317: ROLLBACK;
3318:
3319: RAISE_APPLICATION_ERROR(-20000,
3320: 'Exception at ICX_POR_SCHEMA_UPLOAD.handle_delete_descriptors('
3321: || xErrLoc || '): ' || SQLERRM);
3322:
3323: END handle_delete_descriptors;
3324:

Line 3325: END ICX_POR_SCHEMA_UPLOAD;

3321: || xErrLoc || '): ' || SQLERRM);
3322:
3323: END handle_delete_descriptors;
3324:
3325: END ICX_POR_SCHEMA_UPLOAD;