149: --standard way to handle when-others as per FND logging guidelines
150:
151: IF ( l_unexp_level >= l_debug_level ) THEN
152:
153: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
154: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
155: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
156: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.l.igipmsdb.ParentDistributionID',TRUE);
157: END IF;
150:
151: IF ( l_unexp_level >= l_debug_level ) THEN
152:
153: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
154: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
155: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
156: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.l.igipmsdb.ParentDistributionID',TRUE);
157: END IF;
158: --bug 3199481 fnd logging changes: sdixit: end block
151: IF ( l_unexp_level >= l_debug_level ) THEN
152:
153: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
154: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
155: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
156: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.l.igipmsdb.ParentDistributionID',TRUE);
157: END IF;
158: --bug 3199481 fnd logging changes: sdixit: end block
159: return -1;
345: --standard way to handle when-others as per FND logging guidelines
346:
347: IF ( l_unexp_level >= l_debug_level ) THEN
348:
349: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
350: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
351: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
352: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igipmsdb.IGIPMSDA.SynchronizeInvoice',TRUE);
353: END IF;
346:
347: IF ( l_unexp_level >= l_debug_level ) THEN
348:
349: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
350: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
351: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
352: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igipmsdb.IGIPMSDA.SynchronizeInvoice',TRUE);
353: END IF;
354: --bug 3199481 fnd logging changes: sdixit: end block
347: IF ( l_unexp_level >= l_debug_level ) THEN
348:
349: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
350: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
351: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
352: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igipmsdb.IGIPMSDA.SynchronizeInvoice',TRUE);
353: END IF;
354: --bug 3199481 fnd logging changes: sdixit: end block
355: raise_application_error ( -20000, SQLERRM);
408: retcode := 0;
409: EXCEPTION WHEN OTHERS THEN
410: rollback;
411: --bug 3199481 fnd logging changes: sdixit: start block
412: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
413: retcode := 2;
414: errbuf := Fnd_message.get;
415:
416: IF ( l_unexp_level >= l_debug_level ) THEN
410: rollback;
411: --bug 3199481 fnd logging changes: sdixit: start block
412: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
413: retcode := 2;
414: errbuf := Fnd_message.get;
415:
416: IF ( l_unexp_level >= l_debug_level ) THEN
417:
418: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
414: errbuf := Fnd_message.get;
415:
416: IF ( l_unexp_level >= l_debug_level ) THEN
417:
418: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
419: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
420: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
421: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igipmsdb.IGIPMSDA.SynchronizeTransfer',TRUE);
422: END IF;
415:
416: IF ( l_unexp_level >= l_debug_level ) THEN
417:
418: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
419: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
420: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
421: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igipmsdb.IGIPMSDA.SynchronizeTransfer',TRUE);
422: END IF;
423: --bug 3199481 fnd logging changes: sdixit: end block
416: IF ( l_unexp_level >= l_debug_level ) THEN
417:
418: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
419: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
420: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
421: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igipmsdb.IGIPMSDA.SynchronizeTransfer',TRUE);
422: END IF;
423: --bug 3199481 fnd logging changes: sdixit: end block
424: return;
485: --bug 3199481 fnd logging changes:sdixit :start
486:
487: IF ( l_unexp_level >= l_debug_level ) THEN
488:
489: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
490: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
491: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
492: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.l.igipmsdb.IGIPMSDA.ModeCheck',TRUE);
493: END IF;
486:
487: IF ( l_unexp_level >= l_debug_level ) THEN
488:
489: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
490: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
491: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
492: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.l.igipmsdb.IGIPMSDA.ModeCheck',TRUE);
493: END IF;
494: return FALSE;
487: IF ( l_unexp_level >= l_debug_level ) THEN
488:
489: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
490: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
491: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
492: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.l.igipmsdb.IGIPMSDA.ModeCheck',TRUE);
493: END IF;
494: return FALSE;
495: END ModeCheck;
531: --bug 3199481 fnd logging changes: sdixit: start block
532: --errbuf := SQLERRM;
533: --retcode := 2;
534: --standard way to handle when-others as per FND logging guidelines
535: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
536: retcode := 2;
537: errbuf := Fnd_message.get;
538:
539: IF ( l_unexp_level >= l_debug_level ) THEN
533: --retcode := 2;
534: --standard way to handle when-others as per FND logging guidelines
535: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
536: retcode := 2;
537: errbuf := Fnd_message.get;
538:
539: IF ( l_unexp_level >= l_debug_level ) THEN
540:
541: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
537: errbuf := Fnd_message.get;
538:
539: IF ( l_unexp_level >= l_debug_level ) THEN
540:
541: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
542: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
543: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
544: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igipmsdb.IGIPMSDA.Synchronize',TRUE);
545: END IF;
538:
539: IF ( l_unexp_level >= l_debug_level ) THEN
540:
541: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
542: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
543: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
544: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igipmsdb.IGIPMSDA.Synchronize',TRUE);
545: END IF;
546: --bug 3199481 fnd logging changes: sdixit: end block
539: IF ( l_unexp_level >= l_debug_level ) THEN
540:
541: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
542: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
543: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
544: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igipmsdb.IGIPMSDA.Synchronize',TRUE);
545: END IF;
546: --bug 3199481 fnd logging changes: sdixit: end block
547: return;