148:
149: EXCEPTION
150: WHEN OTHERS THEN
151:
152: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
153:
154: IF ( l_unexp_level >= l_debug_level ) THEN
155:
156: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
152: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
153:
154: IF ( l_unexp_level >= l_debug_level ) THEN
155:
156: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
157: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
158: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
159: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.GetAdjustments',TRUE);
160: END IF;
153:
154: IF ( l_unexp_level >= l_debug_level ) THEN
155:
156: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
157: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
158: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
159: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.GetAdjustments',TRUE);
160: END IF;
161:
154: IF ( l_unexp_level >= l_debug_level ) THEN
155:
156: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
157: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
158: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
159: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.GetAdjustments',TRUE);
160: END IF;
161:
162: RAISE;
345: WHEN OTHERS THEN
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.pls.igircajb.IGIRCABJB.GetTxnDistributions',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.pls.igircajb.IGIRCABJB.GetTxnDistributions',TRUE);
353: END IF;
354:
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.pls.igircajb.IGIRCABJB.GetTxnDistributions',TRUE);
353: END IF;
354:
355: RAISE;
499: WHEN OTHERS THEN
500:
501: IF ( l_unexp_level >= l_debug_level ) THEN
502:
503: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
504: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
505: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
506: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.GetRxptHistory',TRUE);
507: END IF;
500:
501: IF ( l_unexp_level >= l_debug_level ) THEN
502:
503: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
504: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
505: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
506: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.GetRxptHistory',TRUE);
507: END IF;
508:
501: IF ( l_unexp_level >= l_debug_level ) THEN
502:
503: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
504: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
505: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
506: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.GetRxptHistory',TRUE);
507: END IF;
508:
509: RAISE;
767: WHEN OTHERS THEN
768:
769: IF ( l_unexp_level >= l_debug_level ) THEN
770:
771: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
772: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
773: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
774: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.GetRecApplications',TRUE);
775: END IF;
768:
769: IF ( l_unexp_level >= l_debug_level ) THEN
770:
771: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
772: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
773: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
774: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.GetRecApplications',TRUE);
775: END IF;
776: RAISE;
769: IF ( l_unexp_level >= l_debug_level ) THEN
770:
771: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
772: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
773: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
774: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.GetRecApplications',TRUE);
775: END IF;
776: RAISE;
777: END;
899: WHEN OTHERS THEN
900:
901: IF ( l_unexp_level >= l_debug_level ) THEN
902:
903: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
904: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
905: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
906: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.GetMiscCashDates',TRUE);
907: END IF;
900:
901: IF ( l_unexp_level >= l_debug_level ) THEN
902:
903: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
904: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
905: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
906: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.GetMiscCashDates',TRUE);
907: END IF;
908:
901: IF ( l_unexp_level >= l_debug_level ) THEN
902:
903: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
904: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
905: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
906: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.GetMiscCashDates',TRUE);
907: END IF;
908:
909: RAISE;
957: WHEN OTHERS THEN
958:
959: IF ( l_unexp_level >= l_debug_level ) THEN
960:
961: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
962: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
963: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
964: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.CheckBalance',TRUE);
965: END IF;
958:
959: IF ( l_unexp_level >= l_debug_level ) THEN
960:
961: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
962: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
963: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
964: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.CheckBalance',TRUE);
965: END IF;
966:
959: IF ( l_unexp_level >= l_debug_level ) THEN
960:
961: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
962: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
963: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
964: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.CheckBalance',TRUE);
965: END IF;
966:
967: RAISE;
1000: WHEN OTHERS THEN
1001:
1002: IF ( l_unexp_level >= l_debug_level ) THEN
1003:
1004: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1005: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1006: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1007: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.Report',TRUE);
1008: END IF;
1001:
1002: IF ( l_unexp_level >= l_debug_level ) THEN
1003:
1004: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1005: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1006: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1007: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.Report',TRUE);
1008: END IF;
1009:
1002: IF ( l_unexp_level >= l_debug_level ) THEN
1003:
1004: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1005: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1006: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1007: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.Report',TRUE);
1008: END IF;
1009:
1010: RAISE_APPLICATION_ERROR( -20000, sqlerrm||'$Revision: 120.8.12000000.5 $:Report( p_Report ):' );
1063: EXCEPTION
1064: WHEN OTHERS THEN
1065: --bug 3199481 fnd logging changes: sdixit: start block
1066: --standard way to handle when-others as per FND logging guidelines
1067: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1068: --retcode := 2;
1069: --errbuf := Fnd_message.get;
1070:
1071: IF ( l_unexp_level >= l_debug_level ) THEN
1065: --bug 3199481 fnd logging changes: sdixit: start block
1066: --standard way to handle when-others as per FND logging guidelines
1067: --FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1068: --retcode := 2;
1069: --errbuf := Fnd_message.get;
1070:
1071: IF ( l_unexp_level >= l_debug_level ) THEN
1072:
1073: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1069: --errbuf := Fnd_message.get;
1070:
1071: IF ( l_unexp_level >= l_debug_level ) THEN
1072:
1073: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1074: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1075: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1076: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.SubmitReconcileReport',TRUE);
1077: END IF;
1070:
1071: IF ( l_unexp_level >= l_debug_level ) THEN
1072:
1073: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1074: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1075: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1076: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.SubmitReconcileReport',TRUE);
1077: END IF;
1078: --bug 3199481 fnd logging changes: sdixit: end block
1071: IF ( l_unexp_level >= l_debug_level ) THEN
1072:
1073: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1074: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1075: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1076: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJB.SubmitReconcileReport',TRUE);
1077: END IF;
1078: --bug 3199481 fnd logging changes: sdixit: end block
1079:
1130: --standard way to handle when-others as per FND logging guidelines
1131:
1132: IF ( l_unexp_level >= l_debug_level ) THEN
1133:
1134: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1135: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1136: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1137: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.ReportQutput',TRUE);
1138: END IF;
1131:
1132: IF ( l_unexp_level >= l_debug_level ) THEN
1133:
1134: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1135: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1136: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1137: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.ReportQutput',TRUE);
1138: END IF;
1139: --bug 3199481 fnd logging changes: sdixit: end block
1132: IF ( l_unexp_level >= l_debug_level ) THEN
1133:
1134: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1135: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1136: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1137: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.ReportQutput',TRUE);
1138: END IF;
1139: --bug 3199481 fnd logging changes: sdixit: end block
1140: RAISE;
1456:
1457: EXCEPTION
1458: WHEN OTHERS THEN
1459:
1460: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1461: retcode := 2;
1462: errbuf := Fnd_message.get;
1463:
1464: IF ( l_unexp_level >= l_debug_level ) THEN
1458: WHEN OTHERS THEN
1459:
1460: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_USER_ERROR'); -- Seeded Message
1461: retcode := 2;
1462: errbuf := Fnd_message.get;
1463:
1464: IF ( l_unexp_level >= l_debug_level ) THEN
1465:
1466: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1462: errbuf := Fnd_message.get;
1463:
1464: IF ( l_unexp_level >= l_debug_level ) THEN
1465:
1466: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1467: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1468: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1469: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.ReportCBR',TRUE);
1470: END IF;
1463:
1464: IF ( l_unexp_level >= l_debug_level ) THEN
1465:
1466: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1467: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1468: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1469: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.ReportCBR',TRUE);
1470: END IF;
1471:
1464: IF ( l_unexp_level >= l_debug_level ) THEN
1465:
1466: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
1467: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
1468: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
1469: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igircajb.IGIRCABJP.ReportCBR',TRUE);
1470: END IF;
1471:
1472: RAISE;