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_SQE_PVT dependencies on ICX_CAT_UTIL_PVT

Line 40: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

36: BEGIN
37:
38: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
39: l_log_string := 'Starting create_sqes_for_zone: ' || p_content_zone_id;
40: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
41: END IF;
42: l_err_loc := 100;
43:
44: -- now we will construct the intermedia expressions for the zone

Line 59: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

55: l_err_loc := 400;
56: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
57: l_log_string := 'One of the intermedia expressions for this zone is > 2000 bytes.';
58: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
59: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
60: END IF;
61: -- length exceeded, cannot create sqes, return status is error(E)
62: x_return_status := 'E';
63: ELSE

Line 74: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

70:
71: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
72: l_log_string := 'New sqe sequence is: ' || l_sqe_sequence;
73: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
74: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
75: END IF;
76: l_err_loc := 600;
77: -- and form the sqe names
78: l_int_sqe_name := 'icxzi' || l_sqe_sequence;

Line 91: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

87:
88: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
89: l_log_string := 'Finished Storing sqes';
90: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
91: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
92: END IF;
93:
94: l_err_loc := 800;
95: -- now if the original content zone had an sqe_sequence, store it in deleted sqes

Line 106: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

102:
103: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: l_log_string := 'Inserted old sqe sequence into deleted sqes. Old sqe sequence: ' || x_sqe_sequence;
105: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
106: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
107: END IF;
108: END IF;
109:
110: l_err_loc := 900;

Line 125: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

121:
122: l_err_loc := 1100;
123: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
124: l_log_string := 'End create_sqes_for_zone: ' || p_content_zone_id || ' return status is ' || x_return_status;
125: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
126: END IF;
127:
128: EXCEPTION
129: WHEN OTHERS THEN

Line 156: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

152: BEGIN
153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: l_log_string := 'Starting combine_exprs: expr1 = ' || p_expr1 || ' expr2 = ' || p_expr2
155: || ' expr3 = ' || p_expr3;
156: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
157: END IF;
158: l_err_loc := 100;
159: -- first set first to 1 i.e true
160: l_first := 1;

Line 194: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

190:
191: l_err_loc := 400;
192: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
193: l_log_string := 'End combine_exprs: result expr is: ' || x_result_expr;
194: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
195: END IF;
196:
197: EXCEPTION
198: WHEN OTHERS THEN

Line 237: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

233: l_everything_expr VARCHAR2(2000);
234: BEGIN
235: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
236: l_log_string := 'Starting construct_exprs_for_zone';
237: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
238: END IF;
239: l_err_loc := 100;
240:
241: -- first we initialize the fixed sqes

Line 276: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

272:
273: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
274: l_log_string := 'Item Type expr for Internal: ' || l_item_type_expr;
275: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
276: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
277: END IF;
278: l_err_loc := 700;
279: -- now we combine the expressions for internal
280: -- note that we pass '' for supplier since this is not needed

Line 314: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

310:
311: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
312: l_log_string := 'Item Type expr for Purchase: ' || l_item_type_expr;
313: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
314: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
315: END IF;
316:
317: l_err_loc := 1500;
318: -- now we combine the expressions for purchase

Line 346: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

342: END IF;
343: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
344: l_log_string := 'Item Type expr for both: ' || l_item_type_expr;
345: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
346: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
347: END IF;
348: l_err_loc := 2500;
349: -- now we combine the expressions for purchase
350: combine_exprs(l_supplier_and_site_expr, l_category_expr, l_item_type_expr, x_both_intermedia_expression);

Line 364: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

360: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
361: l_log_string := 'End construct_exprs_for_zone: Internal String:'
362: || x_int_intermedia_expression || ' Purchase String: ' || x_purch_intermedia_expression
363: || ' Both String: ' || x_both_intermedia_expression;
364: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
365: END IF;
366: EXCEPTION
367: WHEN OTHERS THEN
368: ROLLBACK;

Line 396: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

392: l_supplier_and_site_expr VARCHAR2(32000);
393: BEGIN
394: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
395: l_log_string := 'Starting construct_supp_and_site_expr';
396: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
397: END IF;
398: l_err_loc := 100;
399:
400: -- initialize the expressions to ''

Line 535: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

531: l_err_loc := 3200;
532: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
533: l_log_string := 'End construct_supp_and_site_expr: Supplier and site expr is:'
534: || x_supplier_and_site_expr;
535: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
536: END IF;
537: EXCEPTION
538: WHEN OTHERS THEN
539: ROLLBACK;

Line 567: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

563: l_current_category_id_list VARCHAR2(32000);
564: BEGIN
565: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
566: l_log_string := 'Starting construct_category_expr';
567: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
568: END IF;
569: l_err_loc := 100;
570: -- initialize the expressions to ''
571: l_category_id_list := '';

Line 682: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

678: l_err_loc := 1800;
679: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
680: l_log_string := 'End construct_category_expr: Category expr is:'
681: || x_category_expr;
682: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
683: END IF;
684: EXCEPTION
685: WHEN OTHERS THEN
686: ROLLBACK;

Line 704: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

700: l_sqe_sequences ICX_TBL_NUMBER;
701: BEGIN
702: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
703: l_log_string := 'Starting purge_deleted_sqes';
704: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
705: END IF;
706:
707: l_err_loc := 100;
708:

Line 730: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

726: FOR i in 1..l_sqe_sequences.COUNT LOOP
727: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
728: l_log_string := 'Removing sqes for sqe_sequence: ' || l_sqe_sequences(i);
729: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
730: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
731: END IF;
732: l_err_loc := 300;
733: ctx_query.remove_sqe('icxzi' || l_sqe_sequences(i));
734: ctx_query.remove_sqe('icxzp' || l_sqe_sequences(i));

Line 751: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

747:
748: l_err_loc := 500;
749: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
750: l_log_string := 'End purge_deleted_sqes';
751: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
752: END IF;
753:
754: EXCEPTION
755: WHEN OTHERS THEN

Line 795: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

791: l_first_errored_zone PLS_INTEGER;
792: BEGIN
793: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
794: l_log_string := 'Starting sync_sqes_hier_change_internal';
795: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
796: END IF;
797: l_first_errored_zone := 1;
798: x_return_status := 'S';
799:

Line 851: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

847: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: l_log_string := 'Succesfully updating the sequence for content_zone: ' || l_content_zone_ids(i)
849: || ' to sqe_sequence: ' || l_sqe_sequences(i);
850: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
851: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
852: END IF;
853: ELSE
854: l_err_loc := 700;
855: x_return_status := 'E';

Line 859: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

855: x_return_status := 'E';
856: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
857: l_log_string := 'Error for content_zone: ' || l_content_zone_ids(i) || ' sqe_sequence: ' || l_sqe_sequences(i);
858: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
859: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
860: END IF;
861: -- error
862: IF (l_first_errored_zone = 1) THEN
863: l_first_errored_zone := 0;

Line 882: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

878: WHERE zone_id = l_content_zone_ids(i);
879:
880: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
881: l_log_string := 'End sync_sqes_hier_change_internal';
882: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
883: END IF;
884: EXCEPTION
885: WHEN OTHERS THEN
886: ROLLBACK;

Line 916: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

912: l_token_list VARCHAR2(4000);
913: BEGIN
914: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
915: l_log_string := 'Starting sync_sqes_for_hierarchy_change';
916: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
917: END IF;
918: l_err_loc := 100;
919:
920: -- first start off with no error

Line 942: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

938: IF (l_return_status = 'E') THEN
939: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
940: l_log_string := 'Could not sync sqes for some zones. Updating the job to error.';
941: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
942: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
943: END IF;
944: l_err_loc := 600;
945: -- update the job status to error
946: x_retcode := 1;

Line 971: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

967:
968: l_err_loc := 1100;
969: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
970: l_log_string := 'End sync_sqes_for_hierarchy_change';
971: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
972: END IF;
973:
974: EXCEPTION
975: WHEN OTHERS THEN

Line 1016: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

1012: l_errored_zone_name_list VARCHAR2(4000);
1013: BEGIN
1014: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1015: l_log_string := 'Starting sync_sqes_hier_change';
1016: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1017: END IF;
1018: l_err_loc := 100;
1019: -- call the main API to do the sync
1020: sync_sqes_hier_change_internal(x_return_status, l_errored_zone_name_list);

Line 1028: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

1024: IF (x_return_status = 'E') THEN
1025: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1026: l_log_string := 'Could not sync sqes for some zones. Returning error.';
1027: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1028: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
1029: END IF;
1030: l_err_loc := 800;
1031: INSERT INTO icx_por_failed_line_messages
1032: (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,

Line 1049: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

1045:
1046: l_err_loc := 1000;
1047: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1048: l_log_string := 'End sync_sqes_hier_change';
1049: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
1050: END IF;
1051: EXCEPTION
1052: WHEN OTHERS THEN
1053: ROLLBACK;

Line 1088: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

1084: l_token_list VARCHAR2(4000);
1085: BEGIN
1086: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1087: l_log_string := 'Starting sync_sqes_for_all_zones';
1088: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1089: END IF;
1090: -- first start off with no error
1091: l_first_errored_zone := 1;
1092:

Line 1143: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

1139: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1140: l_log_string := 'Succesfully updating the sequence for content_zone: ' || l_content_zone_ids(i)
1141: || ' to sqe_sequence: ' || l_sqe_sequences(i);
1142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1143: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
1144: END IF;
1145: ELSE
1146: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1147: l_log_string := 'Error for content_zone: ' || l_content_zone_ids(i) || ' sqe_sequence: ' || l_sqe_sequences(i);

Line 1149: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

1145: ELSE
1146: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1147: l_log_string := 'Error for content_zone: ' || l_content_zone_ids(i) || ' sqe_sequence: ' || l_sqe_sequences(i);
1148: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1149: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
1150: END IF;
1151: l_err_loc := 700;
1152: -- error
1153: IF (l_first_errored_zone = 1) THEN

Line 1178: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

1174:
1175: l_err_loc := 1000;
1176: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1177: l_log_string := 'End sync_sqes_for_all_zones';
1178: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
1179: END IF;
1180:
1181: EXCEPTION
1182: WHEN OTHERS THEN