489: retcode := 0;
490:
491: EXCEPTION WHEN OTHERS THEN
492: --bug 3199481 fnd logging changes: sdixit: start block
493: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
494: retcode := 2;
495: errbuf := Fnd_message.get;
496:
497: IF ( l_unexp_level >= l_debug_level ) THEN
491: EXCEPTION WHEN OTHERS THEN
492: --bug 3199481 fnd logging changes: sdixit: start block
493: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
494: retcode := 2;
495: errbuf := Fnd_message.get;
496:
497: IF ( l_unexp_level >= l_debug_level ) THEN
498:
499: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
495: errbuf := Fnd_message.get;
496:
497: IF ( l_unexp_level >= l_debug_level ) THEN
498:
499: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
500: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
501: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
502: FND_LOG.MESSAGE ( l_unexp_level,'igi.pls.igipmgtb.IGIPMGLT.InsertInterfaceRec',TRUE);
503: END IF;
496:
497: IF ( l_unexp_level >= l_debug_level ) THEN
498:
499: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
500: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
501: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
502: FND_LOG.MESSAGE ( l_unexp_level,'igi.pls.igipmgtb.IGIPMGLT.InsertInterfaceRec',TRUE);
503: END IF;
504: --bug 3199481 fnd logging changes: sdixit: end block
497: IF ( l_unexp_level >= l_debug_level ) THEN
498:
499: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
500: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
501: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
502: FND_LOG.MESSAGE ( l_unexp_level,'igi.pls.igipmgtb.IGIPMGLT.InsertInterfaceRec',TRUE);
503: END IF;
504: --bug 3199481 fnd logging changes: sdixit: end block
505: END;