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.12020000.4 2013/02/08 22:32:00 bpulivar ship $*/
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.12020000.4 2013/02/08 22:32:00 bpulivar ship $*/
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 375: 'Exception at ICX_CAT_SQE_PVT.construct_exprs_for_zone(' ||

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

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

542: WHEN OTHERS THEN
543: ROLLBACK;
544: RAISE_APPLICATION_ERROR
545: (-20000,
546: 'Exception at ICX_CAT_SQE_PVT.construct_supp_and_site_expr(' ||
547: l_err_loc || '), ' || SQLERRM);
548: END construct_supp_and_site_expr;
549:
550:

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

696: WHEN OTHERS THEN
697: ROLLBACK;
698: RAISE_APPLICATION_ERROR
699: (-20000,
700: 'Exception at ICX_CAT_SQE_PVT.construct_category_expr(' ||
701: l_err_loc || '), ' || SQLERRM);
702: END construct_category_expr;
703:
704: -- procedure to purge the deleted sqes

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

766: WHEN OTHERS THEN
767: ROLLBACK;
768: RAISE_APPLICATION_ERROR
769: (-20000,
770: 'Exception at ICX_CAT_SQE_PVT.purge_deleted_sqes(' ||
771: l_err_loc || '), ' || SQLERRM);
772: END purge_deleted_sqes;
773:
774: -- procedure to sync sqes for all content zones

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

896: WHEN OTHERS THEN
897: ROLLBACK;
898: RAISE_APPLICATION_ERROR
899: (-20000,
900: 'Exception at ICX_CAT_SQE_PVT.sync_sqes_hier_change_internal(' ||
901: l_err_loc || '), ' || SQLERRM);
902:
903: END sync_sqes_hier_change_internal;
904:

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

986: WHEN OTHERS THEN
987: ROLLBACK;
988:
989: x_retcode := 2;
990: x_errbuf := 'Exception at ICX_CAT_SQE_PVT.sync_sqes_for_hierarchy_change(' ||
991: l_err_loc || '), ' || SQLERRM;
992:
993: -- update the job status to error
994: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'ERROR');

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

1063: WHEN OTHERS THEN
1064: ROLLBACK;
1065: RAISE_APPLICATION_ERROR
1066: (-20000,
1067: 'Exception at ICX_CAT_SQE_PVT.sync_sqes_for_hierarchy_change(' ||
1068: l_err_loc || '), ' || SQLERRM);
1069: END sync_sqes_for_hierarchy_change;
1070:
1071: -- procedure to sync the sqes for all the zones

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

1193: WHEN OTHERS THEN
1194: ROLLBACK;
1195: RAISE_APPLICATION_ERROR
1196: (-20000,
1197: 'Exception at ICX_CAT_SQE_PVT.sync_sqes_for_all_zones(' ||
1198: l_err_loc || '), ' || SQLERRM);
1199:
1200: END sync_sqes_for_all_zones;
1201:

Line 1202: END ICX_CAT_SQE_PVT;

1198: l_err_loc || '), ' || SQLERRM);
1199:
1200: END sync_sqes_for_all_zones;
1201:
1202: END ICX_CAT_SQE_PVT;