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.CZ_IB_LOCKING dependencies on FND_LOG

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

89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90: x_msg_count := 0;
91: x_msg_data := NULL;
92:
93: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
94: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
95: 'List of parameters : ',
96: fnd_log.LEVEL_PROCEDURE);
97:

Line 96: fnd_log.LEVEL_PROCEDURE);

92:
93: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
94: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
95: 'List of parameters : ',
96: fnd_log.LEVEL_PROCEDURE);
97:
98: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
99: 'p_config_session_hdr_id='||TO_CHAR(p_config_session_hdr_id),
100: fnd_log.LEVEL_PROCEDURE);

Line 100: fnd_log.LEVEL_PROCEDURE);

96: fnd_log.LEVEL_PROCEDURE);
97:
98: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
99: 'p_config_session_hdr_id='||TO_CHAR(p_config_session_hdr_id),
100: fnd_log.LEVEL_PROCEDURE);
101:
102: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
103: 'p_config_session_rev_nbr='||TO_CHAR(p_config_session_rev_nbr),
104: fnd_log.LEVEL_PROCEDURE);

Line 104: fnd_log.LEVEL_PROCEDURE);

100: fnd_log.LEVEL_PROCEDURE);
101:
102: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
103: 'p_config_session_rev_nbr='||TO_CHAR(p_config_session_rev_nbr),
104: fnd_log.LEVEL_PROCEDURE);
105:
106: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
107: 'p_config_session_item_id='||TO_CHAR(p_config_session_item_id),
108: fnd_log.LEVEL_PROCEDURE);

Line 108: fnd_log.LEVEL_PROCEDURE);

104: fnd_log.LEVEL_PROCEDURE);
105:
106: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
107: 'p_config_session_item_id='||TO_CHAR(p_config_session_item_id),
108: fnd_log.LEVEL_PROCEDURE);
109:
110: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
111: 'p_source_application_id='||TO_CHAR(p_source_application_id),
112: fnd_log.LEVEL_PROCEDURE);

Line 112: fnd_log.LEVEL_PROCEDURE);

108: fnd_log.LEVEL_PROCEDURE);
109:
110: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
111: 'p_source_application_id='||TO_CHAR(p_source_application_id),
112: fnd_log.LEVEL_PROCEDURE);
113:
114: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
115: 'p_source_header_ref='||p_source_header_ref,
116: fnd_log.LEVEL_PROCEDURE);

Line 116: fnd_log.LEVEL_PROCEDURE);

112: fnd_log.LEVEL_PROCEDURE);
113:
114: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
115: 'p_source_header_ref='||p_source_header_ref,
116: fnd_log.LEVEL_PROCEDURE);
117:
118: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
119: 'p_source_line_ref1='||p_source_line_ref1,
120: fnd_log.LEVEL_PROCEDURE);

Line 120: fnd_log.LEVEL_PROCEDURE);

116: fnd_log.LEVEL_PROCEDURE);
117:
118: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
119: 'p_source_line_ref1='||p_source_line_ref1,
120: fnd_log.LEVEL_PROCEDURE);
121:
122: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
123: 'p_source_line_ref2='||p_source_line_ref2,
124: fnd_log.LEVEL_PROCEDURE);

Line 124: fnd_log.LEVEL_PROCEDURE);

120: fnd_log.LEVEL_PROCEDURE);
121:
122: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
123: 'p_source_line_ref2='||p_source_line_ref2,
124: fnd_log.LEVEL_PROCEDURE);
125:
126: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
127: 'p_source_line_ref3='||p_source_line_ref3,
128: fnd_log.LEVEL_PROCEDURE);

Line 128: fnd_log.LEVEL_PROCEDURE);

124: fnd_log.LEVEL_PROCEDURE);
125:
126: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
127: 'p_source_line_ref3='||p_source_line_ref3,
128: fnd_log.LEVEL_PROCEDURE);
129:
130: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
131: 'p_commit='||p_commit,
132: fnd_log.LEVEL_PROCEDURE);

Line 132: fnd_log.LEVEL_PROCEDURE);

128: fnd_log.LEVEL_PROCEDURE);
129:
130: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
131: 'p_commit='||p_commit,
132: fnd_log.LEVEL_PROCEDURE);
133:
134: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
135: 'p_init_msg_list='||p_init_msg_list,
136: fnd_log.LEVEL_PROCEDURE);

Line 136: fnd_log.LEVEL_PROCEDURE);

132: fnd_log.LEVEL_PROCEDURE);
133:
134: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
135: 'p_init_msg_list='||p_init_msg_list,
136: fnd_log.LEVEL_PROCEDURE);
137:
138: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
139: 'p_validation_level='||TO_CHAR(p_validation_level),
140: fnd_log.LEVEL_PROCEDURE);

Line 140: fnd_log.LEVEL_PROCEDURE);

136: fnd_log.LEVEL_PROCEDURE);
137:
138: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
139: 'p_validation_level='||TO_CHAR(p_validation_level),
140: fnd_log.LEVEL_PROCEDURE);
141:
142: END IF;
143:
144: --

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

154: fnd_msg_pub.count_and_get(p_count => x_msg_count,
155: p_data => x_msg_data);
156: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
157:
158: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
159: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
160: 'Error : Invalid Data : p_config_session_hdr_id/p_config_session_rev_nbr/p_config_session_item_id='||
161: TO_CHAR(p_config_session_hdr_id)||'/'||TO_CHAR(p_config_session_rev_nbr)||'/'||TO_CHAR(p_config_session_item_id),
162: fnd_log.LEVEL_PROCEDURE);

Line 162: fnd_log.LEVEL_PROCEDURE);

158: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
159: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
160: 'Error : Invalid Data : p_config_session_hdr_id/p_config_session_rev_nbr/p_config_session_item_id='||
161: TO_CHAR(p_config_session_hdr_id)||'/'||TO_CHAR(p_config_session_rev_nbr)||'/'||TO_CHAR(p_config_session_item_id),
162: fnd_log.LEVEL_PROCEDURE);
163: END IF;
164: -- it's fatal error => exit
165: RETURN;
166: END IF;

Line 191: ' IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||

187: ' l_config_tbl(l_rec_counter).source_txn_line_ref3 := :8; ' ||
188: ' l_config_tbl(l_rec_counter).config_inst_hdr_id := i.instance_hdr_id; ' ||
189: ' l_config_tbl(l_rec_counter).config_inst_item_id := i.config_item_id; ' ||
190: ' l_config_tbl(l_rec_counter).config_inst_rev_num := i.instance_rev_nbr; ' ||
191: ' IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
192: ' cz_utils.log_report(''CZ_IB_LOCKING'', ''lock_Config'', l_ndebug, ' ||
193: ' ''CSI_CZ_INT.lock_item_instances() will be called for instance_hdr_id=''||TO_CHAR(i.instance_hdr_id) || ' ||
194: ' '' instance_rev_nbr=''||TO_CHAR(i.instance_rev_nbr)||'' config_item_id=''||TO_CHAR(i.config_item_id), ' ||
195: ' fnd_log.LEVEL_PROCEDURE); ' ||

Line 195: ' fnd_log.LEVEL_PROCEDURE); ' ||

191: ' IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
192: ' cz_utils.log_report(''CZ_IB_LOCKING'', ''lock_Config'', l_ndebug, ' ||
193: ' ''CSI_CZ_INT.lock_item_instances() will be called for instance_hdr_id=''||TO_CHAR(i.instance_hdr_id) || ' ||
194: ' '' instance_rev_nbr=''||TO_CHAR(i.instance_rev_nbr)||'' config_item_id=''||TO_CHAR(i.config_item_id), ' ||
195: ' fnd_log.LEVEL_PROCEDURE); ' ||
196: ' END IF; ' ||
197: ' END LOOP; ' ||
198: ' IF l_config_tbl.COUNT > 0 THEN '||
199: ' CSI_CZ_INT.lock_item_instances(p_api_version => 1.0 ' ||

Line 207: ' IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||

203: ' ,px_config_tbl => l_config_tbl ' ||
204: ' ,x_return_status => CZ_IB_LOCKING.m_return_status ' ||
205: ' ,x_msg_count => CZ_IB_LOCKING.m_msg_count ' ||
206: ' ,x_msg_data => CZ_IB_LOCKING.m_msg_data); ' ||
207: ' IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
208: ' cz_utils.log_report(''CZ_IB_LOCKING'', ''lock_Config'', l_ndebug, ' ||
209: ' ''CSI_CZ_INT.lock_item_instances() has been called : x_return_status=''||CZ_IB_LOCKING.m_return_status|| ' ||
210: ' ''x_msg_count=''||to_char(CZ_IB_LOCKING.m_msg_count)||''x_msg_data=''||CZ_IB_LOCKING.m_msg_data, ' ||
211: ' fnd_log.LEVEL_PROCEDURE); ' ||

Line 211: ' fnd_log.LEVEL_PROCEDURE); ' ||

207: ' IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
208: ' cz_utils.log_report(''CZ_IB_LOCKING'', ''lock_Config'', l_ndebug, ' ||
209: ' ''CSI_CZ_INT.lock_item_instances() has been called : x_return_status=''||CZ_IB_LOCKING.m_return_status|| ' ||
210: ' ''x_msg_count=''||to_char(CZ_IB_LOCKING.m_msg_count)||''x_msg_data=''||CZ_IB_LOCKING.m_msg_data, ' ||
211: ' fnd_log.LEVEL_PROCEDURE); ' ||
212: ' END IF; ' ||
213: ' END IF; '||
214: ' END;' USING
215: p_config_session_hdr_id,p_config_session_rev_nbr,p_config_session_item_id,

Line 231: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: fnd_msg_pub.count_and_get(p_count => x_msg_count,
229: p_data => x_msg_data);
230:
231: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
233: 'Unexpected error : '||fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE),
234: fnd_log.LEVEL_ERROR);
235: END IF;

Line 234: fnd_log.LEVEL_ERROR);

230:
231: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
232: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
233: 'Unexpected error : '||fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE),
234: fnd_log.LEVEL_ERROR);
235: END IF;
236: WHEN OTHERS THEN
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name, 'Fatal error : '||SQLERRM);

Line 241: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name, 'Fatal error : '||SQLERRM);
239: fnd_msg_pub.count_and_get(p_count => x_msg_count,
240: p_data => x_msg_data);
241: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
242: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
243: 'Fatal error : '||SQLERRM,
244: fnd_log.LEVEL_ERROR);
245: END IF;

Line 244: fnd_log.LEVEL_ERROR);

240: p_data => x_msg_data);
241: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
242: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
243: 'Fatal error : '||SQLERRM,
244: fnd_log.LEVEL_ERROR);
245: END IF;
246: END lock_Config;
247:
248: --

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

291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292: x_msg_count := 0;
293: x_msg_data := NULL;
294:
295: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
296: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
297: 'List of parameters : ',
298: fnd_log.LEVEL_PROCEDURE);
299:

Line 298: fnd_log.LEVEL_PROCEDURE);

294:
295: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
296: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
297: 'List of parameters : ',
298: fnd_log.LEVEL_PROCEDURE);
299:
300: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
301: 'p_config_session_hdr_id='||TO_CHAR(p_config_session_hdr_id),
302: fnd_log.LEVEL_PROCEDURE);

Line 302: fnd_log.LEVEL_PROCEDURE);

298: fnd_log.LEVEL_PROCEDURE);
299:
300: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
301: 'p_config_session_hdr_id='||TO_CHAR(p_config_session_hdr_id),
302: fnd_log.LEVEL_PROCEDURE);
303:
304: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
305: 'p_config_session_rev_nbr='||TO_CHAR(p_config_session_rev_nbr),
306: fnd_log.LEVEL_PROCEDURE);

Line 306: fnd_log.LEVEL_PROCEDURE);

302: fnd_log.LEVEL_PROCEDURE);
303:
304: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
305: 'p_config_session_rev_nbr='||TO_CHAR(p_config_session_rev_nbr),
306: fnd_log.LEVEL_PROCEDURE);
307:
308: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
309: 'p_config_session_item_id='||TO_CHAR(p_config_session_item_id),
310: fnd_log.LEVEL_PROCEDURE);

Line 310: fnd_log.LEVEL_PROCEDURE);

306: fnd_log.LEVEL_PROCEDURE);
307:
308: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
309: 'p_config_session_item_id='||TO_CHAR(p_config_session_item_id),
310: fnd_log.LEVEL_PROCEDURE);
311:
312: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
313: 'p_locking_key='||TO_CHAR(p_locking_key),
314: fnd_log.LEVEL_PROCEDURE);

Line 314: fnd_log.LEVEL_PROCEDURE);

310: fnd_log.LEVEL_PROCEDURE);
311:
312: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
313: 'p_locking_key='||TO_CHAR(p_locking_key),
314: fnd_log.LEVEL_PROCEDURE);
315:
316: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
317: 'p_source_application_id='||TO_CHAR(p_source_application_id),
318: fnd_log.LEVEL_PROCEDURE);

Line 318: fnd_log.LEVEL_PROCEDURE);

314: fnd_log.LEVEL_PROCEDURE);
315:
316: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
317: 'p_source_application_id='||TO_CHAR(p_source_application_id),
318: fnd_log.LEVEL_PROCEDURE);
319:
320: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
321: 'p_source_header_ref='||p_source_header_ref,
322: fnd_log.LEVEL_PROCEDURE);

Line 322: fnd_log.LEVEL_PROCEDURE);

318: fnd_log.LEVEL_PROCEDURE);
319:
320: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
321: 'p_source_header_ref='||p_source_header_ref,
322: fnd_log.LEVEL_PROCEDURE);
323:
324: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
325: 'p_source_line_ref1='||p_source_line_ref1,
326: fnd_log.LEVEL_PROCEDURE);

Line 326: fnd_log.LEVEL_PROCEDURE);

322: fnd_log.LEVEL_PROCEDURE);
323:
324: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
325: 'p_source_line_ref1='||p_source_line_ref1,
326: fnd_log.LEVEL_PROCEDURE);
327:
328: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
329: 'p_source_line_ref2='||p_source_line_ref2,
330: fnd_log.LEVEL_PROCEDURE);

Line 330: fnd_log.LEVEL_PROCEDURE);

326: fnd_log.LEVEL_PROCEDURE);
327:
328: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
329: 'p_source_line_ref2='||p_source_line_ref2,
330: fnd_log.LEVEL_PROCEDURE);
331:
332: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
333: 'p_source_line_ref3='||p_source_line_ref3,
334: fnd_log.LEVEL_PROCEDURE);

Line 334: fnd_log.LEVEL_PROCEDURE);

330: fnd_log.LEVEL_PROCEDURE);
331:
332: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
333: 'p_source_line_ref3='||p_source_line_ref3,
334: fnd_log.LEVEL_PROCEDURE);
335:
336: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
337: 'p_commit='||p_commit,
338: fnd_log.LEVEL_PROCEDURE);

Line 338: fnd_log.LEVEL_PROCEDURE);

334: fnd_log.LEVEL_PROCEDURE);
335:
336: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
337: 'p_commit='||p_commit,
338: fnd_log.LEVEL_PROCEDURE);
339:
340: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
341: 'p_init_msg_list='||p_init_msg_list,
342: fnd_log.LEVEL_PROCEDURE);

Line 342: fnd_log.LEVEL_PROCEDURE);

338: fnd_log.LEVEL_PROCEDURE);
339:
340: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
341: 'p_init_msg_list='||p_init_msg_list,
342: fnd_log.LEVEL_PROCEDURE);
343:
344: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
345: 'p_validation_level='||TO_CHAR(p_validation_level),
346: fnd_log.LEVEL_PROCEDURE);

Line 346: fnd_log.LEVEL_PROCEDURE);

342: fnd_log.LEVEL_PROCEDURE);
343:
344: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
345: 'p_validation_level='||TO_CHAR(p_validation_level),
346: fnd_log.LEVEL_PROCEDURE);
347:
348: END IF;
349:
350: --

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

360: fnd_msg_pub.count_and_get(p_count => x_msg_count,
361: p_data => x_msg_data);
362: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
363:
364: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
365: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
366: 'Error : Invalid Data : p_config_session_hdr_id/p_config_session_rev_nbr/p_config_session_item_id='||
367: TO_CHAR(p_config_session_hdr_id)||'/'||TO_CHAR(p_config_session_rev_nbr)||'/'||TO_CHAR(p_config_session_item_id),
368: fnd_log.LEVEL_PROCEDURE);

Line 368: fnd_log.LEVEL_PROCEDURE);

364: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
365: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
366: 'Error : Invalid Data : p_config_session_hdr_id/p_config_session_rev_nbr/p_config_session_item_id='||
367: TO_CHAR(p_config_session_hdr_id)||'/'||TO_CHAR(p_config_session_rev_nbr)||'/'||TO_CHAR(p_config_session_item_id),
368: fnd_log.LEVEL_PROCEDURE);
369: END IF;
370: -- it's fatal error => exit
371: RETURN;
372: END IF;

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

394: ' l_config_tbl(l_rec_counter).lock_id := :9; ' ||
395: ' l_config_tbl(l_rec_counter).config_inst_hdr_id := i.instance_hdr_id; ' ||
396: ' l_config_tbl(l_rec_counter).config_inst_item_id := i.config_item_id; ' ||
397: ' l_config_tbl(l_rec_counter).config_inst_rev_num := i.instance_rev_nbr; ' ||
398: ' IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
399: ' cz_utils.log_report(''CZ_IB_LOCKING'', ''unlock_Config'', l_ndebug, ' ||
400: ' ''CSI_CZ_INT.unlock_item_instances() will be called for instance_hdr_id=''||TO_CHAR(i.instance_hdr_id)|| ' ||
401: ' '' instance_rev_nbr=''||TO_CHAR(i.instance_rev_nbr)||'' config_item_id=''||TO_CHAR(i.config_item_id), ' ||
402: ' fnd_log.LEVEL_PROCEDURE); ' ||

Line 402: ' fnd_log.LEVEL_PROCEDURE); ' ||

398: ' IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
399: ' cz_utils.log_report(''CZ_IB_LOCKING'', ''unlock_Config'', l_ndebug, ' ||
400: ' ''CSI_CZ_INT.unlock_item_instances() will be called for instance_hdr_id=''||TO_CHAR(i.instance_hdr_id)|| ' ||
401: ' '' instance_rev_nbr=''||TO_CHAR(i.instance_rev_nbr)||'' config_item_id=''||TO_CHAR(i.config_item_id), ' ||
402: ' fnd_log.LEVEL_PROCEDURE); ' ||
403: ' END IF; ' ||
404: ' END LOOP; ' ||
405: ' IF l_config_tbl.COUNT > 0 THEN '||
406: ' CSI_CZ_INT.unlock_item_instances(p_api_version => 1.0 ' ||

Line 414: ' IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||

410: ' ,p_config_tbl => l_config_tbl ' ||
411: ' ,x_return_status => CZ_IB_LOCKING.m_return_status ' ||
412: ' ,x_msg_count => CZ_IB_LOCKING.m_msg_count ' ||
413: ' ,x_msg_data => CZ_IB_LOCKING.m_msg_data); ' ||
414: ' IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
415: ' cz_utils.log_report(''CZ_IB_LOCKING'', ''unlock_Config'', l_ndebug, ' ||
416: ' ''CSI_CZ_INT.unlock_item_instances() has been called : x_return_status=''||CZ_IB_LOCKING.m_return_status|| ' ||
417: ' ''x_msg_count=''||to_char(CZ_IB_LOCKING.m_msg_count)||''x_msg_data=''||CZ_IB_LOCKING.m_msg_data, ' ||
418: ' fnd_log.LEVEL_PROCEDURE); ' ||

Line 418: ' fnd_log.LEVEL_PROCEDURE); ' ||

414: ' IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN ' ||
415: ' cz_utils.log_report(''CZ_IB_LOCKING'', ''unlock_Config'', l_ndebug, ' ||
416: ' ''CSI_CZ_INT.unlock_item_instances() has been called : x_return_status=''||CZ_IB_LOCKING.m_return_status|| ' ||
417: ' ''x_msg_count=''||to_char(CZ_IB_LOCKING.m_msg_count)||''x_msg_data=''||CZ_IB_LOCKING.m_msg_data, ' ||
418: ' fnd_log.LEVEL_PROCEDURE); ' ||
419: ' END IF; ' ||
420: ' END IF; '||
421: ' END;' USING
422: p_config_session_hdr_id,p_config_session_rev_nbr,p_config_session_item_id,

Line 437: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: fnd_msg_pub.count_and_get(p_count => x_msg_count,
436: p_data => x_msg_data);
437: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
438: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
439: 'Unexpected error : '||fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE),
440: fnd_log.LEVEL_ERROR);
441: END IF;

Line 440: fnd_log.LEVEL_ERROR);

436: p_data => x_msg_data);
437: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
438: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
439: 'Unexpected error : '||fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE),
440: fnd_log.LEVEL_ERROR);
441: END IF;
442: WHEN OTHERS THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name, 'Fatal error : '||SQLERRM);

Line 447: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name, 'Fatal error : '||SQLERRM);
445: fnd_msg_pub.count_and_get(p_count => x_msg_count,
446: p_data => x_msg_data);
447: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
448: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
449: 'Fatal error : '||SQLERRM,
450: fnd_log.LEVEL_ERROR);
451: END IF;

Line 450: fnd_log.LEVEL_ERROR);

446: p_data => x_msg_data);
447: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
448: cz_utils.log_report(G_PKG_NAME, l_api_name, l_ndebug,
449: 'Fatal error : '||SQLERRM,
450: fnd_log.LEVEL_ERROR);
451: END IF;
452: END unlock_Config;
453:
454: END;