APPS.ICX_CAT_SQE_PVT dependencies on ICX_CAT_SQE_PVT

Line 1: PACKAGE BODY ICX_CAT_SQE_PVT AS

1: PACKAGE BODY ICX_CAT_SQE_PVT AS
2: /* $Header: ICXVSQEB.pls 120.5 2006/08/29 02:30:29 sudsubra noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'ICX_CAT_SQE_PVT';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'ICX_CAT_SQE_PVT';

1: PACKAGE BODY ICX_CAT_SQE_PVT AS
2: /* $Header: ICXVSQEB.pls 120.5 2006/08/29 02:30:29 sudsubra noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'ICX_CAT_SQE_PVT';
5:
6: -- procedure to create sqes for a given content zone
7: -- this constructs the intermedia expressions for the content zone, puts
8: -- them into sqes and returns the sqe sequence

Line 133: 'Exception at ICX_CAT_SQE_PVT.create_sqes_for_zone(' ||

129: WHEN OTHERS THEN
130: ROLLBACK;
131: RAISE_APPLICATION_ERROR
132: (-20000,
133: 'Exception at ICX_CAT_SQE_PVT.create_sqes_for_zone(' ||
134: l_err_loc || '), ' || SQLERRM);
135: END create_sqes_for_zone;
136:
137:

Line 202: 'Exception at ICX_CAT_SQE_PVT.combine_exprs(' ||

198: WHEN OTHERS THEN
199: ROLLBACK;
200: RAISE_APPLICATION_ERROR
201: (-20000,
202: 'Exception at ICX_CAT_SQE_PVT.combine_exprs(' ||
203: l_err_loc || '), ' || SQLERRM);
204: END combine_exprs;
205:
206: -- procedure to construct the intermedia expressions for a given zone

Line 371: 'Exception at ICX_CAT_SQE_PVT.construct_exprs_for_zone(' ||

367: WHEN OTHERS THEN
368: ROLLBACK;
369: RAISE_APPLICATION_ERROR
370: (-20000,
371: 'Exception at ICX_CAT_SQE_PVT.construct_exprs_for_zone(' ||
372: l_err_loc || '), ' || SQLERRM);
373: END construct_exprs_for_zone;
374:
375: -- procedure to constuct the supplier and site expression for a given zone

Line 542: 'Exception at ICX_CAT_SQE_PVT.construct_supp_and_site_expr(' ||

538: WHEN OTHERS THEN
539: ROLLBACK;
540: RAISE_APPLICATION_ERROR
541: (-20000,
542: 'Exception at ICX_CAT_SQE_PVT.construct_supp_and_site_expr(' ||
543: l_err_loc || '), ' || SQLERRM);
544: END construct_supp_and_site_expr;
545:
546:

Line 689: 'Exception at ICX_CAT_SQE_PVT.construct_category_expr(' ||

685: WHEN OTHERS THEN
686: ROLLBACK;
687: RAISE_APPLICATION_ERROR
688: (-20000,
689: 'Exception at ICX_CAT_SQE_PVT.construct_category_expr(' ||
690: l_err_loc || '), ' || SQLERRM);
691: END construct_category_expr;
692:
693: -- procedure to purge the deleted sqes

Line 759: 'Exception at ICX_CAT_SQE_PVT.purge_deleted_sqes(' ||

755: WHEN OTHERS THEN
756: ROLLBACK;
757: RAISE_APPLICATION_ERROR
758: (-20000,
759: 'Exception at ICX_CAT_SQE_PVT.purge_deleted_sqes(' ||
760: l_err_loc || '), ' || SQLERRM);
761: END purge_deleted_sqes;
762:
763: -- procedure to sync sqes for all content zones

Line 889: 'Exception at ICX_CAT_SQE_PVT.sync_sqes_hier_change_internal(' ||

885: WHEN OTHERS THEN
886: ROLLBACK;
887: RAISE_APPLICATION_ERROR
888: (-20000,
889: 'Exception at ICX_CAT_SQE_PVT.sync_sqes_hier_change_internal(' ||
890: l_err_loc || '), ' || SQLERRM);
891:
892: END sync_sqes_hier_change_internal;
893:

Line 979: x_errbuf := 'Exception at ICX_CAT_SQE_PVT.sync_sqes_for_hierarchy_change(' ||

975: WHEN OTHERS THEN
976: ROLLBACK;
977:
978: x_retcode := 2;
979: x_errbuf := 'Exception at ICX_CAT_SQE_PVT.sync_sqes_for_hierarchy_change(' ||
980: l_err_loc || '), ' || SQLERRM;
981:
982: -- update the job status to error
983: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'ERROR');

Line 1056: 'Exception at ICX_CAT_SQE_PVT.sync_sqes_for_hierarchy_change(' ||

1052: WHEN OTHERS THEN
1053: ROLLBACK;
1054: RAISE_APPLICATION_ERROR
1055: (-20000,
1056: 'Exception at ICX_CAT_SQE_PVT.sync_sqes_for_hierarchy_change(' ||
1057: l_err_loc || '), ' || SQLERRM);
1058: END sync_sqes_for_hierarchy_change;
1059:
1060: -- procedure to sync the sqes for all the zones

Line 1186: 'Exception at ICX_CAT_SQE_PVT.sync_sqes_for_all_zones(' ||

1182: WHEN OTHERS THEN
1183: ROLLBACK;
1184: RAISE_APPLICATION_ERROR
1185: (-20000,
1186: 'Exception at ICX_CAT_SQE_PVT.sync_sqes_for_all_zones(' ||
1187: l_err_loc || '), ' || SQLERRM);
1188:
1189: END sync_sqes_for_all_zones;
1190:

Line 1191: END ICX_CAT_SQE_PVT;

1187: l_err_loc || '), ' || SQLERRM);
1188:
1189: END sync_sqes_for_all_zones;
1190:
1191: END ICX_CAT_SQE_PVT;