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_CAT_SCHEMA_UPLOAD_PVT dependencies on ICX_CAT_SCHEMA_UPLOAD_PVT

Line 1: PACKAGE BODY ICX_CAT_SCHEMA_UPLOAD_PVT AS

1: PACKAGE BODY ICX_CAT_SCHEMA_UPLOAD_PVT AS
2: /* $Header: ICXVSULB.pls 120.12 2006/08/03 03:03:21 kaholee noship $*/
3:
4: -- Default number of characters for columns created as VARCHAR2
5: DEFAULT_COLUMN_SIZE CONSTANT Number := 700;

Line 50: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.get_nullify_values(' ||

46: EXCEPTION
47: WHEN OTHERS THEN
48: RAISE_APPLICATION_ERROR
49: (-20000,
50: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.get_nullify_values(' ||
51: l_err_loc || '), ' || SQLERRM);
52: END get_nullify_values;
53:
54: -- Procedure to validate the descriptor before it gets created

Line 258: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.validate_descriptor_for_create(' ||

254: EXCEPTION
255: WHEN OTHERS THEN
256: RAISE_APPLICATION_ERROR
257: (-20000,
258: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.validate_descriptor_for_create(' ||
259: l_err_loc || '), ' || SQLERRM);
260:
261: END validate_descriptor_for_create;
262:

Line 307: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.save_failed_category(' ||

303: WHEN OTHERS THEN
304: ROLLBACK;
305: RAISE_APPLICATION_ERROR
306: (-20000,
307: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.save_failed_category(' ||
308: l_err_loc || '), ' || SQLERRM);
309: END save_failed_category;
310:
311: -- procedure to save the failed descriptor into the failed lines table

Line 391: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.save_failed_descriptor(' ||

387: WHEN OTHERS THEN
388: ROLLBACK;
389: RAISE_APPLICATION_ERROR
390: (-20000,
391: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.save_failed_descriptor(' ||
392: l_err_loc || '), ' || SQLERRM);
393: END save_failed_descriptor;
394:
395: -- procedure to save the failed relationships into the failed lines table

Line 439: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.save_failed_relationship(' ||

435: WHEN OTHERS THEN
436: ROLLBACK;
437: RAISE_APPLICATION_ERROR
438: (-20000,
439: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.save_failed_relationship(' ||
440: l_err_loc || '), ' || SQLERRM);
441: END save_failed_relationship;
442:
443: -- inserts a row into the failed lines table

Line 473: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.insert_failed_line(' ||

469: WHEN OTHERS THEN
470: ROLLBACK;
471: RAISE_APPLICATION_ERROR
472: (-20000,
473: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.insert_failed_line(' ||
474: l_err_loc || '), ' || SQLERRM);
475: END insert_failed_line;
476:
477: -- inserts a row into the failed messages table

Line 504: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.insert_failed_message(' ||

500: WHEN OTHERS THEN
501: ROLLBACK;
502: RAISE_APPLICATION_ERROR
503: (-20000,
504: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.insert_failed_message(' ||
505: l_err_loc || '), ' || SQLERRM);
506: END insert_failed_message;
507:
508:

Line 562: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.create_category(' ||

558: WHEN OTHERS THEN
559: ROLLBACK;
560: RAISE_APPLICATION_ERROR
561: (-20000,
562: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.create_category(' ||
563: l_err_loc || '), ' || SQLERRM);
564: END create_category;
565:
566: -- procedure to update a category

Line 650: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.update_category(' ||

646: WHEN OTHERS THEN
647: ROLLBACK;
648: RAISE_APPLICATION_ERROR
649: (-20000,
650: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.update_category(' ||
651: l_err_loc || '), ' || SQLERRM);
652: END update_category;
653:
654:

Line 767: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.delete_category(' ||

763: WHEN OTHERS THEN
764: ROLLBACK;
765: RAISE_APPLICATION_ERROR
766: (-20000,
767: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.delete_category(' ||
768: l_err_loc || '), ' || SQLERRM);
769: END delete_category;
770:
771: -- procedure to validate a category

Line 996: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.validate_category(' ||

992: EXCEPTION
993: WHEN OTHERS THEN
994: RAISE_APPLICATION_ERROR
995: (-20000,
996: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.validate_category(' ||
997: l_err_loc || '), ' || SQLERRM);
998: END validate_category;
999:
1000:

Line 1152: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.can_category_be_deleted(' ||

1148: EXCEPTION
1149: WHEN OTHERS THEN
1150: RAISE_APPLICATION_ERROR
1151: (-20000,
1152: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.can_category_be_deleted(' ||
1153: l_err_loc || '), ' || SQLERRM);
1154: END can_category_be_deleted;
1155:
1156:

Line 1246: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.add_relationship(' ||

1242: WHEN OTHERS THEN
1243: ROLLBACK;
1244: RAISE_APPLICATION_ERROR
1245: (-20000,
1246: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.add_relationship(' ||
1247: l_err_loc || '), ' || SQLERRM);
1248: END add_relationship;
1249:
1250:

Line 1300: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.delete_relationship(' ||

1296: WHEN OTHERS THEN
1297: ROLLBACK;
1298: RAISE_APPLICATION_ERROR
1299: (-20000,
1300: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.delete_relationship(' ||
1301: l_err_loc || '), ' || SQLERRM);
1302: END delete_relationship;
1303:
1304:

Line 1634: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.validate_relationship(' ||

1630: EXCEPTION
1631: WHEN OTHERS THEN
1632: RAISE_APPLICATION_ERROR
1633: (-20000,
1634: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.validate_relationship(' ||
1635: l_err_loc || '), ' || SQLERRM);
1636: END validate_relationship;
1637:
1638:

Line 1775: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.create_descriptor(' ||

1771: WHEN OTHERS THEN
1772: ROLLBACK;
1773: RAISE_APPLICATION_ERROR
1774: (-20000,
1775: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.create_descriptor(' ||
1776: l_err_loc || '), ' || SQLERRM);
1777: END create_descriptor;
1778:
1779: -- procedure to increment the schema version

Line 1825: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.inc_schema_change_version(' ||

1821: WHEN OTHERS THEN
1822: ROLLBACK;
1823: RAISE_APPLICATION_ERROR
1824: (-20000,
1825: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.inc_schema_change_version(' ||
1826: l_err_loc || '), ' || SQLERRM);
1827: END inc_schema_change_version;
1828:
1829:

Line 1994: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.assign_section_tag(' ||

1990: EXCEPTION
1991: WHEN OTHERS THEN
1992: RAISE_APPLICATION_ERROR
1993: (-20000,
1994: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.assign_section_tag(' ||
1995: l_err_loc || '), ' || SQLERRM);
1996: END assign_section_tag;
1997:
1998:

Line 2089: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.release_section_tag(' ||

2085: EXCEPTION
2086: WHEN OTHERS THEN
2087: RAISE_APPLICATION_ERROR
2088: (-20000,
2089: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.release_section_tag(' ||
2090: l_err_loc || '), ' || SQLERRM);
2091: END release_section_tag;
2092:
2093:

Line 2185: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.update_descriptor(' ||

2181: WHEN OTHERS THEN
2182: ROLLBACK;
2183: RAISE_APPLICATION_ERROR
2184: (-20000,
2185: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.update_descriptor(' ||
2186: l_err_loc || '), ' || SQLERRM);
2187: END update_descriptor;
2188:
2189:

Line 2257: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.delete_descriptor(' ||

2253: WHEN OTHERS THEN
2254: ROLLBACK;
2255: RAISE_APPLICATION_ERROR
2256: (-20000,
2257: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.delete_descriptor(' ||
2258: l_err_loc || '), ' || SQLERRM);
2259: END delete_descriptor;
2260:
2261:

Line 2407: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.can_descriptor_be_deleted(' ||

2403: EXCEPTION
2404: WHEN OTHERS THEN
2405: RAISE_APPLICATION_ERROR
2406: (-20000,
2407: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.can_descriptor_be_deleted(' ||
2408: l_err_loc || '), ' || SQLERRM);
2409: END can_descriptor_be_deleted;
2410:
2411:

Line 2921: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.validate_descriptor(' ||

2917: EXCEPTION
2918: WHEN OTHERS THEN
2919: RAISE_APPLICATION_ERROR
2920: (-20000,
2921: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.validate_descriptor(' ||
2922: l_err_loc || '), ' || SQLERRM);
2923: END validate_descriptor;
2924:
2925:

Line 3038: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.purge_loader_tables(' ||

3034: WHEN OTHERS THEN
3035: ROLLBACK;
3036: RAISE_APPLICATION_ERROR
3037: (-20000,
3038: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.purge_loader_tables(' ||
3039: l_err_loc || '), ' || SQLERRM);
3040: END purge_loader_tables;
3041:
3042: -- procedure to populate the ctx desc for schema load

Line 3190: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.populate_ctx_desc(' ||

3186: WHEN OTHERS THEN
3187: ROLLBACK;
3188: RAISE_APPLICATION_ERROR
3189: (-20000,
3190: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.populate_ctx_desc(' ||
3191: l_err_loc || '), ' || SQLERRM);
3192: END populate_ctx_desc;
3193:
3194: -- methods for online schema

Line 3241: x_errbuf := 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.populate_for_cat_rename(' ||

3237: EXCEPTION
3238: WHEN OTHERS THEN
3239: ROLLBACK;
3240: x_retcode := 2;
3241: x_errbuf := 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.populate_for_cat_rename(' ||
3242: l_err_loc || '), ' || SQLERRM;
3243: update_job_status(l_request_id, 'ERROR');
3244: END populate_for_cat_rename;
3245:

Line 3291: x_errbuf := 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.populate_for_searchable_change(' ||

3287: EXCEPTION
3288: WHEN OTHERS THEN
3289: ROLLBACK;
3290: x_retcode := 2;
3291: x_errbuf := 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.populate_for_searchable_change(' ||
3292: l_err_loc || '), ' || SQLERRM;
3293: update_job_status(l_request_id, 'ERROR');
3294:
3295: END populate_for_searchable_change;

Line 3328: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(' ||

3324: WHEN OTHERS THEN
3325: ROLLBACK;
3326: RAISE_APPLICATION_ERROR
3327: (-20000,
3328: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(' ||
3329: l_err_loc || '), ' || SQLERRM);
3330: END update_job_status;
3331:
3332: END ICX_CAT_SCHEMA_UPLOAD_PVT;

Line 3332: END ICX_CAT_SCHEMA_UPLOAD_PVT;

3328: 'Exception at ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(' ||
3329: l_err_loc || '), ' || SQLERRM);
3330: END update_job_status;
3331:
3332: END ICX_CAT_SCHEMA_UPLOAD_PVT;