47: return (l_limit);
48: WHEN OTHERS
49: THEN
50: IF ( l_unexp_level >= l_debug_level) THEN
51: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
52: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
53: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
54: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrub.IGI_ITR_PREP_APPRV_PKG.get_authorization_limit',TRUE);
55: END IF;
48: WHEN OTHERS
49: THEN
50: IF ( l_unexp_level >= l_debug_level) THEN
51: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
52: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
53: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
54: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrub.IGI_ITR_PREP_APPRV_PKG.get_authorization_limit',TRUE);
55: END IF;
56: raise_application_error (-20001,'IGI_ITR_PREP_APPRV_PKG.get_authorization_limit'||SQLERRM);
49: THEN
50: IF ( l_unexp_level >= l_debug_level) THEN
51: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
52: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
53: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
54: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrub.IGI_ITR_PREP_APPRV_PKG.get_authorization_limit',TRUE);
55: END IF;
56: raise_application_error (-20001,'IGI_ITR_PREP_APPRV_PKG.get_authorization_limit'||SQLERRM);
57:
129: /* ssemwal for NOCOPY begin(1) */
130: p_prep_can_approve := Null;
131: /* ssemwal for NOCOPY end(1) */
132: IF ( l_unexp_level >= l_debug_level) THEN
133: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
134: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
135: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
136: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrub.IGI_ITR_PREP_APPRV_PKG.can_preparer_approve',TRUE);
137: END IF;
130: p_prep_can_approve := Null;
131: /* ssemwal for NOCOPY end(1) */
132: IF ( l_unexp_level >= l_debug_level) THEN
133: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
134: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
135: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
136: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrub.IGI_ITR_PREP_APPRV_PKG.can_preparer_approve',TRUE);
137: END IF;
138: raise_application_error
131: /* ssemwal for NOCOPY end(1) */
132: IF ( l_unexp_level >= l_debug_level) THEN
133: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
134: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
135: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
136: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrub.IGI_ITR_PREP_APPRV_PKG.can_preparer_approve',TRUE);
137: END IF;
138: raise_application_error
139: (-20001,'IGI_ITR_PREP_APPRV_PKG.can_preparer_approve'||SQLERRM);