187: --standard way to handle when-others as per FND logging guidelines
188:
189: IF ( l_unexp_level >= l_debug_level ) THEN
190:
191: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
192: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
193: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
194: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igipmslb.IGIPMSLR.DateFactor',TRUE);
195: END IF;
188:
189: IF ( l_unexp_level >= l_debug_level ) THEN
190:
191: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
192: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
193: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
194: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igipmslb.IGIPMSLR.DateFactor',TRUE);
195: END IF;
196: --bug 3199481 fnd logging changes: sdixit: end block
189: IF ( l_unexp_level >= l_debug_level ) THEN
190:
191: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
192: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
193: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
194: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igipmslb.IGIPMSLR.DateFactor',TRUE);
195: END IF;
196: --bug 3199481 fnd logging changes: sdixit: end block
197: return null;
223: --standard way to handle when-others as per FND logging guidelines
224:
225: IF ( l_unexp_level >= l_debug_level ) THEN
226:
227: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
228: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
229: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
230: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igipmslb.IGIPMSLR.GetDay',TRUE);
231: END IF;
224:
225: IF ( l_unexp_level >= l_debug_level ) THEN
226:
227: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
228: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
229: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
230: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igipmslb.IGIPMSLR.GetDay',TRUE);
231: END IF;
232: --bug 3199481 fnd logging changes: sdixit: end block
225: IF ( l_unexp_level >= l_debug_level ) THEN
226:
227: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
228: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
229: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
230: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igipmslb.IGIPMSLR.GetDay',TRUE);
231: END IF;
232: --bug 3199481 fnd logging changes: sdixit: end block
233: null;