APPS.INV_GEN_LOC_KFV dependencies on INV_LOG_UTIL

Line 58: inv_log_util.TRACE('Created the SQL to create the new VIEW ', 'INVLOC', 9);

54: l_view_text := l_view_text||' SUGGESTED_CUBIC_AREA, SUGGESTED_WEIGHT, LOCATION_SUGGESTED_UNITS, EMPTY_FLAG, MIXED_ITEMS_FLAG, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,';
55: l_view_text := l_view_text||' DESCRIPTION, DESCRIPTIVE_TEXT, DISABLE_DATE, INVENTORY_LOCATION_TYPE, PICKING_ORDER, PHYSICAL_LOCATION_CODE, LOCATION_MAXIMUM_UNITS, ALIAS, ';
56:
57: IF (l_debug = 1) THEN
58: inv_log_util.TRACE('Created the SQL to create the new VIEW ', 'INVLOC', 9);
59: END IF;
60: --
61: --Forming the concatenated segments\
62: --Fetchng the segment delimter

Line 69: inv_log_util.TRACE('Opened the cursor c_delim ', 'INVLOC', 9);

65: FETCH c_delim INTO l_delim;
66: CLOSE c_delim;
67:
68: IF (l_debug = 1) THEN
69: inv_log_util.TRACE('Opened the cursor c_delim ', 'INVLOC', 9);
70: END IF;
71: ---Fetching the concatenated segments
72: OPEN c_cur_seg(l_compatibility);
73: FETCH c_cur_seg INTO l_segment_name;

Line 76: inv_log_util.TRACE('Opened the cursor c_cur_seg ', 'INVLOC', 9);

72: OPEN c_cur_seg(l_compatibility);
73: FETCH c_cur_seg INTO l_segment_name;
74:
75: IF (l_debug = 1) THEN
76: inv_log_util.TRACE('Opened the cursor c_cur_seg ', 'INVLOC', 9);
77: END IF;
78: --
79: IF c_cur_seg%NOTFOUND THEN
80:

Line 92: inv_log_util.TRACE('About to loop on cursor c_cur_seg to get the concatenated segment.', 'INVLOC', 9);

88: l_concat_segments:=l_concat_segments||l_segment_name ;
89: END IF;
90:
91: IF (l_debug = 1) THEN
92: inv_log_util.TRACE('About to loop on cursor c_cur_seg to get the concatenated segment.', 'INVLOC', 9);
93: END IF;
94: --
95: --Forming the concatenated segments
96: LOOP

Line 112: inv_log_util.TRACE('The concatenated segment is '||l_concat_segments, 'INVLOC', 9);

108:
109: -- l_concat_segments := l_concat_segments||l_proj_task_segments||' CONCATENATED_SEGMENTS '; --Bug4345239.commented.
110:
111: IF (l_debug = 1) THEN
112: inv_log_util.TRACE('The concatenated segment is '||l_concat_segments, 'INVLOC', 9);
113: inv_log_util.TRACE('The proj/task segments : '||l_proj_task_segments, 'INVLOC', 9);
114: END IF;
115: --
116:

Line 113: inv_log_util.TRACE('The proj/task segments : '||l_proj_task_segments, 'INVLOC', 9);

109: -- l_concat_segments := l_concat_segments||l_proj_task_segments||' CONCATENATED_SEGMENTS '; --Bug4345239.commented.
110:
111: IF (l_debug = 1) THEN
112: inv_log_util.TRACE('The concatenated segment is '||l_concat_segments, 'INVLOC', 9);
113: inv_log_util.TRACE('The proj/task segments : '||l_proj_task_segments, 'INVLOC', 9);
114: END IF;
115: --
116:
117:

Line 143: inv_log_util.TRACE('Successfully Recompiled the View.', 'INVLOC', 9);

139: l_execute := dbms_sql.execute(l_sqlid);
140: dbms_sql.close_cursor(l_sqlid);
141: --
142: IF (l_debug = 1) THEN
143: inv_log_util.TRACE('Successfully Recompiled the View.', 'INVLOC', 9);
144: END IF;
145: x_errbuf := null;
146: x_retcode := retcode_success;
147:

Line 159: inv_log_util.TRACE('An Error has occurred ErrNum='||TO_CHAR(SQLCODE)||', Error Msg='||SQLERRM, 'INVLOC', 9);

155: CLOSE c_delim;
156: end if;
157: --
158: IF (l_debug = 1) THEN
159: inv_log_util.TRACE('An Error has occurred ErrNum='||TO_CHAR(SQLCODE)||', Error Msg='||SQLERRM, 'INVLOC', 9);
160: END IF;
161: x_errbuf := SQLERRM;
162: x_retcode := retcode_error;
163: RAISE;