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 361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

357: END IF;
358:
359: l_err_loc := 2800;
360: --Bug 13527354
361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
362: l_log_string := 'End construct_exprs_for_zone: Internal String:'
363: || x_int_intermedia_expression;
364: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name,l_api_name,l_log_string);
365: l_log_string:= ' Purchase String: ' || x_purch_intermedia_expression;

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

394: l_supplier_site_id_list VARCHAR2(32000);
395: l_exclude_expr VARCHAR2(100);
396: l_supplier_and_site_expr VARCHAR2(32000);
397: BEGIN
398: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
399: l_log_string := 'Starting construct_supp_and_site_expr';
400: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
401: END IF;
402: l_err_loc := 100;

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

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

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

565: l_category_ids ICX_TBL_NUMBER;
566: l_category_id_list VARCHAR2(32000);
567: l_current_category_id_list VARCHAR2(32000);
568: BEGIN
569: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
570: l_log_string := 'Starting construct_category_expr';
571: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
572: END IF;
573: l_err_loc := 100;

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

686: END IF;
687: l_err_loc := 1700;
688: END IF;
689: l_err_loc := 1800;
690: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
691: l_log_string := 'End construct_category_expr: Category expr is:'
692: || x_category_expr;
693: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
694: END IF;

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

709: l_log_string VARCHAR2(32000);
710: l_err_loc PLS_INTEGER;
711: l_sqe_sequences ICX_TBL_NUMBER;
712: BEGIN
713: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
714: l_log_string := 'Starting purge_deleted_sqes';
715: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
716: END IF;
717:

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

734: -- the same sqes which will throw an exception. to avoid this we catch the exception
735: -- and do nothing
736: BEGIN
737: FOR i in 1..l_sqe_sequences.COUNT LOOP
738: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
739: l_log_string := 'Removing sqes for sqe_sequence: ' || l_sqe_sequences(i);
740: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
741: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
742: END IF;

Line 740: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

736: BEGIN
737: FOR i in 1..l_sqe_sequences.COUNT LOOP
738: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
739: l_log_string := 'Removing sqes for sqe_sequence: ' || l_sqe_sequences(i);
740: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
741: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
742: END IF;
743: l_err_loc := 300;
744: ctx_query.remove_sqe('icxzi' || l_sqe_sequences(i));

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

756: DELETE FROM icx_cat_deleted_sqes
757: WHERE sqe_sequence = l_sqe_sequences(i);
758:
759: l_err_loc := 500;
760: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
761: l_log_string := 'End purge_deleted_sqes';
762: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
763: END IF;
764:

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

800: l_return_status VARCHAR2(1);
801: l_current_sqe_sequence NUMBER;
802: l_first_errored_zone PLS_INTEGER;
803: BEGIN
804: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
805: l_log_string := 'Starting sync_sqes_hier_change_internal';
806: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
807: END IF;
808: l_first_errored_zone := 1;

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

854: IF (l_return_status = 'S') THEN
855: l_err_loc := 600;
856: -- success, update the sqe sequence
857: l_sqe_sequences(i) := l_current_sqe_sequence;
858: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
859: l_log_string := 'Succesfully updating the sequence for content_zone: ' || l_content_zone_ids(i)
860: || ' to sqe_sequence: ' || l_sqe_sequences(i);
861: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
862: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

Line 861: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

857: l_sqe_sequences(i) := l_current_sqe_sequence;
858: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
859: l_log_string := 'Succesfully updating the sequence for content_zone: ' || l_content_zone_ids(i)
860: || ' to sqe_sequence: ' || l_sqe_sequences(i);
861: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
862: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
863: END IF;
864: ELSE
865: l_err_loc := 700;

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

863: END IF;
864: ELSE
865: l_err_loc := 700;
866: x_return_status := 'E';
867: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
868: l_log_string := 'Error for content_zone: ' || l_content_zone_ids(i) || ' sqe_sequence: ' || l_sqe_sequences(i);
869: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
870: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
871: END IF;

Line 869: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

865: l_err_loc := 700;
866: x_return_status := 'E';
867: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
868: l_log_string := 'Error for content_zone: ' || l_content_zone_ids(i) || ' sqe_sequence: ' || l_sqe_sequences(i);
869: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
870: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
871: END IF;
872: -- error
873: IF (l_first_errored_zone = 1) THEN

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

887: UPDATE icx_cat_content_zones_b
888: SET sqe_sequence = l_sqe_sequences(i)
889: WHERE zone_id = l_content_zone_ids(i);
890:
891: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
892: l_log_string := 'End sync_sqes_hier_change_internal';
893: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
894: END IF;
895: EXCEPTION

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

921: l_return_status VARCHAR2(1);
922: l_errored_zone_name_list VARCHAR2(4000);
923: l_token_list VARCHAR2(4000);
924: BEGIN
925: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
926: l_log_string := 'Starting sync_sqes_for_hierarchy_change';
927: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
928: END IF;
929: l_err_loc := 100;

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

946:
947: l_err_loc := 500;
948: -- set job status depending on whether there is an error on not
949: IF (l_return_status = 'E') THEN
950: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
951: l_log_string := 'Could not sync sqes for some zones. Updating the job to error.';
952: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
953: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
954: END IF;

Line 952: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

948: -- set job status depending on whether there is an error on not
949: IF (l_return_status = 'E') THEN
950: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
951: l_log_string := 'Could not sync sqes for some zones. Updating the job to error.';
952: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
953: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
954: END IF;
955: l_err_loc := 600;
956: -- update the job status to error

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

976:
977: COMMIT;
978:
979: l_err_loc := 1100;
980: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
981: l_log_string := 'End sync_sqes_for_hierarchy_change';
982: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
983: END IF;
984:

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

1021: l_err_loc PLS_INTEGER;
1022: l_request_id NUMBER;
1023: l_errored_zone_name_list VARCHAR2(4000);
1024: BEGIN
1025: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1026: l_log_string := 'Starting sync_sqes_hier_change';
1027: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1028: END IF;
1029: l_err_loc := 100;

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

1032:
1033: l_err_loc := 500;
1034: -- if there is an error then we insert into failed lines and failed line messages
1035: IF (x_return_status = 'E') THEN
1036: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1037: l_log_string := 'Could not sync sqes for some zones. Returning error.';
1038: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1039: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
1040: END IF;

Line 1038: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1034: -- if there is an error then we insert into failed lines and failed line messages
1035: IF (x_return_status = 'E') THEN
1036: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1037: l_log_string := 'Could not sync sqes for some zones. Returning error.';
1038: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1039: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
1040: END IF;
1041: l_err_loc := 800;
1042: INSERT INTO icx_por_failed_line_messages

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

1054: fnd_global.prog_appl_id, fnd_global.conc_login_id);
1055: END IF;
1056:
1057: l_err_loc := 1000;
1058: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1059: l_log_string := 'End sync_sqes_hier_change';
1060: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
1061: END IF;
1062: EXCEPTION

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

1093: l_errored_zone_name_list VARCHAR2(4000);
1094: l_first_errored_zone PLS_INTEGER;
1095: l_token_list VARCHAR2(4000);
1096: BEGIN
1097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1098: l_log_string := 'Starting sync_sqes_for_all_zones';
1099: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1100: END IF;
1101: -- first start off with no error

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

1146: IF (l_return_status = 'S') THEN
1147: l_err_loc := 600;
1148: -- success, update the sqe sequence
1149: l_sqe_sequences(i) := l_current_sqe_sequence;
1150: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1151: l_log_string := 'Succesfully updating the sequence for content_zone: ' || l_content_zone_ids(i)
1152: || ' to sqe_sequence: ' || l_sqe_sequences(i);
1153: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1154: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

Line 1153: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1149: l_sqe_sequences(i) := l_current_sqe_sequence;
1150: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1151: l_log_string := 'Succesfully updating the sequence for content_zone: ' || l_content_zone_ids(i)
1152: || ' to sqe_sequence: ' || l_sqe_sequences(i);
1153: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1154: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
1155: END IF;
1156: ELSE
1157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1153: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1154: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
1155: END IF;
1156: ELSE
1157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1158: l_log_string := 'Error for content_zone: ' || l_content_zone_ids(i) || ' sqe_sequence: ' || l_sqe_sequences(i);
1159: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1160: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
1161: END IF;

Line 1159: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

1155: END IF;
1156: ELSE
1157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1158: l_log_string := 'Error for content_zone: ' || l_content_zone_ids(i) || ' sqe_sequence: ' || l_sqe_sequences(i);
1159: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1160: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
1161: END IF;
1162: l_err_loc := 700;
1163: -- error

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

1183:
1184: COMMIT;
1185:
1186: l_err_loc := 1000;
1187: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1188: l_log_string := 'End sync_sqes_for_all_zones';
1189: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
1190: END IF;
1191: