DBA Data[Home] [Help]

APPS.IGIPMSDA dependencies on FND_MESSAGE

Line 153: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

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;

Line 154: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

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

Line 155: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

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;

Line 349: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

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;

Line 350: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

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

Line 351: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

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);

Line 412: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message

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

Line 414: errbuf := Fnd_message.get;

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');

Line 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;

Line 419: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

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

Line 420: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

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;

Line 489: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');

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;

Line 490: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

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;

Line 491: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

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;

Line 535: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message

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

Line 537: errbuf := Fnd_message.get;

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');

Line 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;

Line 542: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);

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

Line 543: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

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;