DBA Data[Home] [Help]

APPS.IGI_RPI_ITEMS_PKG dependencies on FND_MESSAGE

Line 117: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

113: EXCEPTION
114: WHEN NO_DATA_FOUND THEN RETURN;
115: WHEN app_exceptions.application_exception THEN RAISE;
116: WHEN OTHERS THEN
117: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
118: fnd_message.set_token('PROCEDURE',
119: 'IGI_RPI_ITEMS_PKG.Insert_Row');
120: -- bug 3199481, start block
121: IF (l_unexp_level >= l_debug_level) THEN

Line 118: fnd_message.set_token('PROCEDURE',

114: WHEN NO_DATA_FOUND THEN RETURN;
115: WHEN app_exceptions.application_exception THEN RAISE;
116: WHEN OTHERS THEN
117: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
118: fnd_message.set_token('PROCEDURE',
119: 'IGI_RPI_ITEMS_PKG.Insert_Row');
120: -- bug 3199481, start block
121: IF (l_unexp_level >= l_debug_level) THEN
122: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_UNEXP_ERROR');

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

118: fnd_message.set_token('PROCEDURE',
119: 'IGI_RPI_ITEMS_PKG.Insert_Row');
120: -- bug 3199481, start block
121: IF (l_unexp_level >= l_debug_level) THEN
122: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_UNEXP_ERROR');
123: FND_MESSAGE.SET_TOKEN('CODE', sqlcode);
124: FND_MESSAGE.SET_TOKEN('MSG', sqlerrm);
125:
126: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_rpi_items_pkg.insert_row.Msg1',TRUE);

Line 123: FND_MESSAGE.SET_TOKEN('CODE', sqlcode);

119: 'IGI_RPI_ITEMS_PKG.Insert_Row');
120: -- bug 3199481, start block
121: IF (l_unexp_level >= l_debug_level) THEN
122: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_UNEXP_ERROR');
123: FND_MESSAGE.SET_TOKEN('CODE', sqlcode);
124: FND_MESSAGE.SET_TOKEN('MSG', sqlerrm);
125:
126: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_rpi_items_pkg.insert_row.Msg1',TRUE);
127: END IF;

Line 124: FND_MESSAGE.SET_TOKEN('MSG', sqlerrm);

120: -- bug 3199481, start block
121: IF (l_unexp_level >= l_debug_level) THEN
122: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_UNEXP_ERROR');
123: FND_MESSAGE.SET_TOKEN('CODE', sqlcode);
124: FND_MESSAGE.SET_TOKEN('MSG', sqlerrm);
125:
126: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_rpi_items_pkg.insert_row.Msg1',TRUE);
127: END IF;
128: -- bug 3199481, end block

Line 179: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

175: EXCEPTION
176: WHEN NO_DATA_FOUND THEN RETURN;
177: WHEN app_exceptions.application_exception THEN RAISE;
178: WHEN OTHERS THEN
179: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
180: fnd_message.set_token('PROCEDURE',
181: 'IGI_RPI_ITEMS_PKG.Update_Row');
182: -- bug 3199481, start block
183: IF (l_unexp_level >= l_debug_level) THEN

Line 180: fnd_message.set_token('PROCEDURE',

176: WHEN NO_DATA_FOUND THEN RETURN;
177: WHEN app_exceptions.application_exception THEN RAISE;
178: WHEN OTHERS THEN
179: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
180: fnd_message.set_token('PROCEDURE',
181: 'IGI_RPI_ITEMS_PKG.Update_Row');
182: -- bug 3199481, start block
183: IF (l_unexp_level >= l_debug_level) THEN
184: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_UNEXP_ERROR');

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

180: fnd_message.set_token('PROCEDURE',
181: 'IGI_RPI_ITEMS_PKG.Update_Row');
182: -- bug 3199481, start block
183: IF (l_unexp_level >= l_debug_level) THEN
184: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_UNEXP_ERROR');
185: FND_MESSAGE.SET_TOKEN('CODE', sqlcode);
186: FND_MESSAGE.SET_TOKEN('MSG', sqlerrm);
187:
188: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_rpi_items_pkg.update_row.Msg1',TRUE);

Line 185: FND_MESSAGE.SET_TOKEN('CODE', sqlcode);

181: 'IGI_RPI_ITEMS_PKG.Update_Row');
182: -- bug 3199481, start block
183: IF (l_unexp_level >= l_debug_level) THEN
184: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_UNEXP_ERROR');
185: FND_MESSAGE.SET_TOKEN('CODE', sqlcode);
186: FND_MESSAGE.SET_TOKEN('MSG', sqlerrm);
187:
188: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_rpi_items_pkg.update_row.Msg1',TRUE);
189: END IF;

Line 186: FND_MESSAGE.SET_TOKEN('MSG', sqlerrm);

182: -- bug 3199481, start block
183: IF (l_unexp_level >= l_debug_level) THEN
184: FND_MESSAGE.SET_NAME('IGI', 'IGI_LOGGING_UNEXP_ERROR');
185: FND_MESSAGE.SET_TOKEN('CODE', sqlcode);
186: FND_MESSAGE.SET_TOKEN('MSG', sqlerrm);
187:
188: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igi_rpi_items_pkg.update_row.Msg1',TRUE);
189: END IF;
190: -- bug 3199481, end block