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

Line 60: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

56: l_error_text VARCHAR2(512);
57: BEGIN
58:
59: --log key input parameters
60: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
61: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id||' ,p_new_contract_number='||p_new_contract_number||' ,p_new_contract_modifier='||p_new_contract_modifier||
62: ' ,p_new_start_date='||p_new_start_date||' ,p_new_end_date='||p_new_end_date||' ,p_new_duration='||p_new_duration||' ,p_new_uom_code='||p_new_uom_code||' ,p_renewal_called_from_ui='||p_renewal_called_from_ui);
63: END IF;
64:

Line 61: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id||' ,p_new_contract_number='||p_new_contract_number||' ,p_new_contract_modifier='||p_new_contract_modifier||

57: BEGIN
58:
59: --log key input parameters
60: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
61: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id||' ,p_new_contract_number='||p_new_contract_number||' ,p_new_contract_modifier='||p_new_contract_modifier||
62: ' ,p_new_start_date='||p_new_start_date||' ,p_new_end_date='||p_new_end_date||' ,p_new_duration='||p_new_duration||' ,p_new_uom_code='||p_new_uom_code||' ,p_renewal_called_from_ui='||p_renewal_called_from_ui);
63: END IF;
64:
65: --standard api initilization and checks

Line 103: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

99: IF FND_API.to_boolean( p_commit ) THEN
100: COMMIT;
101: END IF;
102:
103: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
104: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
105: END IF;
106: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
107:

Line 104: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);

100: COMMIT;
101: END IF;
102:
103: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
104: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
105: END IF;
106: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
107:
108: EXCEPTION

Line 113: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

109: WHEN FND_API.g_exc_error THEN
110: ROLLBACK TO renew_contract_PUB;
111: x_return_status := FND_API.g_ret_sts_error ;
112:
113: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
114: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
115: END IF;
116: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
117:

Line 114: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);

110: ROLLBACK TO renew_contract_PUB;
111: x_return_status := FND_API.g_ret_sts_error ;
112:
113: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
114: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
115: END IF;
116: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
117:
118: WHEN FND_API.g_exc_unexpected_error THEN

Line 122: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

118: WHEN FND_API.g_exc_unexpected_error THEN
119: ROLLBACK TO renew_contract_PUB;
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
121:
122: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
123: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
124: END IF;
125: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
126:

Line 123: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);

119: ROLLBACK TO renew_contract_PUB;
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
121:
122: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
123: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
124: END IF;
125: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
126:
127: WHEN OTHERS THEN

Line 131: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

127: WHEN OTHERS THEN
128: ROLLBACK TO renew_contract_PUB;
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
130:
131: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
132: --first log the sqlerrm
133: l_error_text := substr (SQLERRM, 1, 240);
134: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
135: --then add it to the message api list

Line 134: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

130:
131: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
132: --first log the sqlerrm
133: l_error_text := substr (SQLERRM, 1, 240);
134: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
135: --then add it to the message api list
136: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
137: END IF;
138: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

Line 174: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

170: l_error_text VARCHAR2(512);
171: BEGIN
172:
173: --log key input parameters
174: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
175: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id||' ,p_date='||p_date||' ,p_validation_level='||p_validation_level);
176: END IF;
177:
178: --standard api initilization and checks

Line 175: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id||' ,p_date='||p_date||' ,p_validation_level='||p_validation_level);

171: BEGIN
172:
173: --log key input parameters
174: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
175: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id||' ,p_date='||p_date||' ,p_validation_level='||p_validation_level);
176: END IF;
177:
178: --standard api initilization and checks
179: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN

Line 207: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

203: RAISE FND_API.g_exc_error;
204: END IF;
205:
206:
207: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
208: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
209: END IF;
210: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
211:

Line 208: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);

204: END IF;
205:
206:
207: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
208: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
209: END IF;
210: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
211:
212: EXCEPTION

Line 216: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

212: EXCEPTION
213: WHEN FND_API.g_exc_error THEN
214: x_return_status := FND_API.g_ret_sts_error ;
215:
216: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
217: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
218: END IF;
219: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
220:

Line 217: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);

213: WHEN FND_API.g_exc_error THEN
214: x_return_status := FND_API.g_ret_sts_error ;
215:
216: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
217: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
218: END IF;
219: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
220:
221: WHEN FND_API.g_exc_unexpected_error THEN

Line 224: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

220:
221: WHEN FND_API.g_exc_unexpected_error THEN
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
223:
224: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
225: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
226: END IF;
227: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
228:

Line 225: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);

221: WHEN FND_API.g_exc_unexpected_error THEN
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
223:
224: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
225: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
226: END IF;
227: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
228:
229: WHEN OTHERS THEN

Line 232: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

228:
229: WHEN OTHERS THEN
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
231:
232: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
233: --first log the sqlerrm
234: l_error_text := substr (SQLERRM, 1, 240);
235: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
236: --then add it to the message api list

Line 235: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

231:
232: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
233: --first log the sqlerrm
234: l_error_text := substr (SQLERRM, 1, 240);
235: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
236: --then add it to the message api list
237: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
238: END IF;
239: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

Line 276: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

272:
273: BEGIN
274:
275: --log key input parameters
276: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
277: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id);
278: END IF;
279:
280: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 277: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id);

273: BEGIN
274:
275: --log key input parameters
276: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
277: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id);
278: END IF;
279:
280: l_return_status := FND_API.G_RET_STS_SUCCESS;
281: OKS_RENEW_CONTRACT_PVT.validate_renewal(p_api_version => 1,

Line 301: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

297: --all other conditions return false
298: l_return_value := FND_API.G_FALSE; --F
299: END IF;
300:
301: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
302: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'l_return_status='||l_return_status||' ,l_validation_status='||l_validation_status||' ,l_return_value='||l_return_value);
303: END IF;
304:
305: RETURN l_return_value;

Line 302: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'l_return_status='||l_return_status||' ,l_validation_status='||l_validation_status||' ,l_return_value='||l_return_value);

298: l_return_value := FND_API.G_FALSE; --F
299: END IF;
300:
301: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
302: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'l_return_status='||l_return_status||' ,l_validation_status='||l_validation_status||' ,l_return_value='||l_return_value);
303: END IF;
304:
305: RETURN l_return_value;
306:

Line 310: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

306:
307: EXCEPTION
308:
309: WHEN OTHERS THEN
310: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
311: --first log the sqlerrm
312: l_error_text := substr (SQLERRM, 1, 240);
313: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
314: --then add it to the message api list

Line 313: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

309: WHEN OTHERS THEN
310: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
311: --first log the sqlerrm
312: l_error_text := substr (SQLERRM, 1, 240);
313: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
314: --then add it to the message api list
315: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
316: END IF;
317:

Line 349: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

345: l_error_text VARCHAR2(512);
346: BEGIN
347:
348: --log key input parameters
349: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
350: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id||' ,p_commit='||p_commit);
351: END IF;
352:
353: --standard api initilization and checks

Line 350: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id||' ,p_commit='||p_commit);

346: BEGIN
347:
348: --log key input parameters
349: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
350: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id||' ,p_commit='||p_commit);
351: END IF;
352:
353: --standard api initilization and checks
354: SAVEPOINT update_invoice_text_PUB;

Line 383: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

379: IF FND_API.to_boolean( p_commit ) THEN
380: COMMIT;
381: END IF;
382:
383: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
384: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
385: END IF;
386: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
387:

Line 384: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);

380: COMMIT;
381: END IF;
382:
383: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
384: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status);
385: END IF;
386: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
387:
388: EXCEPTION

Line 393: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

389: WHEN FND_API.g_exc_error THEN
390: ROLLBACK TO update_invoice_text_PUB;
391: x_return_status := FND_API.g_ret_sts_error ;
392:
393: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
394: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
395: END IF;
396: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
397:

Line 394: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);

390: ROLLBACK TO update_invoice_text_PUB;
391: x_return_status := FND_API.g_ret_sts_error ;
392:
393: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
394: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
395: END IF;
396: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
397:
398: WHEN FND_API.g_exc_unexpected_error THEN

Line 402: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

398: WHEN FND_API.g_exc_unexpected_error THEN
399: ROLLBACK TO update_invoice_text_PUB;
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
401:
402: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
403: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
404: END IF;
405: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
406:

Line 403: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);

399: ROLLBACK TO update_invoice_text_PUB;
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
401:
402: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
403: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
404: END IF;
405: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
406:
407: WHEN OTHERS THEN

Line 411: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

407: WHEN OTHERS THEN
408: ROLLBACK TO update_invoice_text_PUB;
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
410:
411: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
412: --first log the sqlerrm
413: l_error_text := substr (SQLERRM, 1, 240);
414: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
415: --then add it to the message api list

Line 414: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

410:
411: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
412: --first log the sqlerrm
413: l_error_text := substr (SQLERRM, 1, 240);
414: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
415: --then add it to the message api list
416: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
417: END IF;
418: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );

Line 454: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

450: l_error_text VARCHAR2(512);
451: BEGIN
452:
453: --log key input parameters
454: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
455: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id||' ,p_hdesk_user_id='||p_hdesk_user_id);
456: END IF;
457:
458: --standard api initilization and checks

Line 455: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id||' ,p_hdesk_user_id='||p_hdesk_user_id);

451: BEGIN
452:
453: --log key input parameters
454: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
455: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id=' || p_chr_id||' ,p_hdesk_user_id='||p_hdesk_user_id);
456: END IF;
457:
458: --standard api initilization and checks
459: IF NOT FND_API.compatible_api_call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)THEN

Line 484: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

480: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
481: RAISE FND_API.g_exc_error;
482: END IF;
483:
484: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
485: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status||' ,x_user_id='||x_user_id||' ,x_user_name='||x_user_name);
486: END IF;
487: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
488:

Line 485: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status||' ,x_user_id='||x_user_id||' ,x_user_name='||x_user_name);

481: RAISE FND_API.g_exc_error;
482: END IF;
483:
484: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
485: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'x_return_status='|| x_return_status||' ,x_user_id='||x_user_id||' ,x_user_name='||x_user_name);
486: END IF;
487: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
488:
489: EXCEPTION

Line 493: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

489: EXCEPTION
490: WHEN FND_API.g_exc_error THEN
491: x_return_status := FND_API.g_ret_sts_error ;
492:
493: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
494: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
495: END IF;
496: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
497:

Line 494: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);

490: WHEN FND_API.g_exc_error THEN
491: x_return_status := FND_API.g_ret_sts_error ;
492:
493: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
494: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
495: END IF;
496: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
497:
498: WHEN FND_API.g_exc_unexpected_error THEN

Line 501: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

497:
498: WHEN FND_API.g_exc_unexpected_error THEN
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
500:
501: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
502: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
503: END IF;
504: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
505:

Line 502: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);

498: WHEN FND_API.g_exc_unexpected_error THEN
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
500:
501: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
502: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
503: END IF;
504: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
505:
506: WHEN OTHERS THEN

Line 509: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

505:
506: WHEN OTHERS THEN
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
508:
509: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
510: --first log the sqlerrm
511: l_error_text := substr (SQLERRM, 1, 240);
512: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
513: --then add it to the message api list

Line 512: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

508:
509: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
510: --first log the sqlerrm
511: l_error_text := substr (SQLERRM, 1, 240);
512: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
513: --then add it to the message api list
514: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
515: END IF;
516: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );