216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
218: p_data => l_msg_data );
219: IF g_unexp_level >= g_debug_level THEN
220: fnd_message.set_name('IGC','IGC_LOGGING_UNEXP_ERROR');
221: fnd_message.set_token('CODE',SQLCODE);
222: fnd_message.set_token('MESG',SQLERRM);
223: fnd_log.message(g_unexp_level,l_full_path,TRUE);
224: END IF;
217: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
218: p_data => l_msg_data );
219: IF g_unexp_level >= g_debug_level THEN
220: fnd_message.set_name('IGC','IGC_LOGGING_UNEXP_ERROR');
221: fnd_message.set_token('CODE',SQLCODE);
222: fnd_message.set_token('MESG',SQLERRM);
223: fnd_log.message(g_unexp_level,l_full_path,TRUE);
224: END IF;
225: RETURN;
218: p_data => l_msg_data );
219: IF g_unexp_level >= g_debug_level THEN
220: fnd_message.set_name('IGC','IGC_LOGGING_UNEXP_ERROR');
221: fnd_message.set_token('CODE',SQLCODE);
222: fnd_message.set_token('MESG',SQLERRM);
223: fnd_log.message(g_unexp_level,l_full_path,TRUE);
224: END IF;
225: RETURN;
226:
351: WHEN OTHERS THEN
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count, p_data => l_msg_data );
354: IF g_unexp_level >= g_debug_level THEN
355: fnd_message.set_name('IGC','IGC_LOGGING_UNEXP_ERROR');
356: fnd_message.set_token('CODE',SQLCODE);
357: fnd_message.set_token('MESG',SQLERRM);
358: fnd_log.message(g_unexp_level,l_full_path,TRUE);
359: END IF;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count, p_data => l_msg_data );
354: IF g_unexp_level >= g_debug_level THEN
355: fnd_message.set_name('IGC','IGC_LOGGING_UNEXP_ERROR');
356: fnd_message.set_token('CODE',SQLCODE);
357: fnd_message.set_token('MESG',SQLERRM);
358: fnd_log.message(g_unexp_level,l_full_path,TRUE);
359: END IF;
360: RETURN;
353: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count, p_data => l_msg_data );
354: IF g_unexp_level >= g_debug_level THEN
355: fnd_message.set_name('IGC','IGC_LOGGING_UNEXP_ERROR');
356: fnd_message.set_token('CODE',SQLCODE);
357: fnd_message.set_token('MESG',SQLERRM);
358: fnd_log.message(g_unexp_level,l_full_path,TRUE);
359: END IF;
360: RETURN;
361:
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
442: p_data => l_msg_data );
443: IF g_unexp_level >= g_debug_level THEN
444: fnd_message.set_name('IGC','IGC_LOGGING_UNEXP_ERROR');
445: fnd_message.set_token('CODE',SQLCODE);
446: fnd_message.set_token('MESG',SQLERRM);
447: fnd_log.message(g_unexp_level,l_full_path,TRUE);
448: END IF;
441: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
442: p_data => l_msg_data );
443: IF g_unexp_level >= g_debug_level THEN
444: fnd_message.set_name('IGC','IGC_LOGGING_UNEXP_ERROR');
445: fnd_message.set_token('CODE',SQLCODE);
446: fnd_message.set_token('MESG',SQLERRM);
447: fnd_log.message(g_unexp_level,l_full_path,TRUE);
448: END IF;
449: RETURN;
442: p_data => l_msg_data );
443: IF g_unexp_level >= g_debug_level THEN
444: fnd_message.set_name('IGC','IGC_LOGGING_UNEXP_ERROR');
445: fnd_message.set_token('CODE',SQLCODE);
446: fnd_message.set_token('MESG',SQLERRM);
447: fnd_log.message(g_unexp_level,l_full_path,TRUE);
448: END IF;
449: RETURN;
450: