APPS.ICX_CAT_SQE_PVT dependencies on FND_LOG

Line 38: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

34: l_both_sqe_name VARCHAR2(15);
35: l_sqe_sequence NUMBER;
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;

Line 56: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

52: IF (length(l_int_intermedia_expression) > 2000 OR
53: length(l_purch_intermedia_expression) > 2000 OR
54: length(l_both_intermedia_expression) > 2000) THEN
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;

Line 58: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

54: length(l_both_intermedia_expression) > 2000) THEN
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';

Line 71: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

67: SELECT icx_cat_sqe_name_s.nextval
68: INTO l_sqe_sequence
69: FROM dual;
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;

Line 73: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

69: FROM dual;
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

Line 88: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

84: ctx_query.store_sqe(l_int_sqe_name, l_int_intermedia_expression);
85: ctx_query.store_sqe(l_purch_sqe_name, l_purch_intermedia_expression);
86: ctx_query.store_sqe(l_both_sqe_name, l_both_intermedia_expression);
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;

Line 90: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

86: ctx_query.store_sqe(l_both_sqe_name, l_both_intermedia_expression);
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;

Line 103: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

99: last_updated_by, last_update_date, last_update_login)
100: VALUES (x_sqe_sequence, fnd_global.user_id, sysdate, fnd_global.user_id,
101: sysdate, fnd_global.login_id);
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;

Line 105: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

101: sysdate, fnd_global.login_id);
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:

Line 123: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

119: x_return_status := 'S';
120: END IF;
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:

Line 153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

149: l_log_string VARCHAR2(32000);
150: l_err_loc PLS_INTEGER;
151: l_first PLS_INTEGER;
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;

Line 192: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

188: END IF;
189: END IF;
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:

Line 235: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

231: l_invalid_item_type_expr VARCHAR2(50);
232: l_item_type_expr VARCHAR2(2000);
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;

Line 273: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

269: l_err_loc := 600;
270: l_item_type_expr := l_invalid_item_type_expr;
271: END IF;
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;

Line 275: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

271: END IF;
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

Line 311: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

307: l_item_type_expr := '';
308: END IF;
309: END IF;
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;

Line 313: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

309: END IF;
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;

Line 343: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

339: ELSE
340: l_err_loc := 2200;
341: l_item_type_expr := '';
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;

Line 345: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

341: l_item_type_expr := '';
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

Line 360: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

356: x_both_intermedia_expression := l_everything_expr;
357: END IF;
358:
359: l_err_loc := 2800;
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);

Line 394: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

390: l_supplier_site_id_list VARCHAR2(32000);
391: l_exclude_expr VARCHAR2(100);
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;

Line 532: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

528: END IF;
529: END IF;
530:
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;

Line 565: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

561: l_category_ids ICX_TBL_NUMBER;
562: l_category_id_list VARCHAR2(32000);
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;

Line 679: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

675: END IF;
676: l_err_loc := 1700;
677: END IF;
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;

Line 702: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

698: l_log_string VARCHAR2(32000);
699: l_err_loc PLS_INTEGER;
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:

Line 727: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

723: -- the same sqes which will throw an exception. to avoid this we catch the exception
724: -- and do nothing
725: BEGIN
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;

Line 729: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

725: BEGIN
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));

Line 749: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

745: DELETE FROM icx_cat_deleted_sqes
746: WHERE sqe_sequence = l_sqe_sequences(i);
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:

Line 793: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

789: l_return_status VARCHAR2(1);
790: l_current_sqe_sequence NUMBER;
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;

Line 847: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

843: IF (l_return_status = 'S') THEN
844: l_err_loc := 600;
845: -- success, update the sqe sequence
846: l_sqe_sequences(i) := l_current_sqe_sequence;
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);

Line 850: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

846: l_sqe_sequences(i) := l_current_sqe_sequence;
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;

Line 856: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

852: END IF;
853: ELSE
854: l_err_loc := 700;
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;

Line 858: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

854: l_err_loc := 700;
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

Line 880: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

876: UPDATE icx_cat_content_zones_b
877: SET sqe_sequence = l_sqe_sequences(i)
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

Line 914: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

910: l_return_status VARCHAR2(1);
911: l_errored_zone_name_list VARCHAR2(4000);
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;

Line 939: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

935:
936: l_err_loc := 500;
937: -- set job status depending on whether there is an error on not
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;

Line 941: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

937: -- set job status depending on whether there is an error on not
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

Line 969: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

965:
966: COMMIT;
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:

Line 1014: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1010: l_err_loc PLS_INTEGER;
1011: l_request_id NUMBER;
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;

Line 1025: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1021:
1022: l_err_loc := 500;
1023: -- if there is an error then we insert into failed lines and failed line messages
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;

Line 1027: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1023: -- if there is an error then we insert into failed lines and failed line messages
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

Line 1047: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1043: fnd_global.prog_appl_id, fnd_global.conc_login_id);
1044: END IF;
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

Line 1086: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1082: l_errored_zone_name_list VARCHAR2(4000);
1083: l_first_errored_zone PLS_INTEGER;
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

Line 1139: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1135: IF (l_return_status = 'S') THEN
1136: l_err_loc := 600;
1137: -- success, update the sqe sequence
1138: l_sqe_sequences(i) := l_current_sqe_sequence;
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);

Line 1142: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1138: l_sqe_sequences(i) := l_current_sqe_sequence;
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

Line 1146: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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);
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;

Line 1148: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

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);
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

Line 1176: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1172:
1173: COMMIT;
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: