80: l_both_sqe_name := 'icxzb' || l_sqe_sequence;
81:
82: l_err_loc := 700;
83: -- now store the sqes
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
81:
82: l_err_loc := 700;
83: -- now store the sqes
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';
82: l_err_loc := 700;
83: -- now store the sqes
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,
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));
745: ctx_query.remove_sqe('icxzp' || l_sqe_sequences(i));
746: ctx_query.remove_sqe('icxzb' || l_sqe_sequences(i));
747: END LOOP;
748: EXCEPTION
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));
745: ctx_query.remove_sqe('icxzp' || l_sqe_sequences(i));
746: ctx_query.remove_sqe('icxzb' || l_sqe_sequences(i));
747: END LOOP;
748: EXCEPTION
749: WHEN OTHERS THEN
742: END IF;
743: l_err_loc := 300;
744: ctx_query.remove_sqe('icxzi' || l_sqe_sequences(i));
745: ctx_query.remove_sqe('icxzp' || l_sqe_sequences(i));
746: ctx_query.remove_sqe('icxzb' || l_sqe_sequences(i));
747: END LOOP;
748: EXCEPTION
749: WHEN OTHERS THEN
750: NULL;