225: debugger('ROUTINE:'||routine);
226: debugger('ERRNO:'||errcode);
227: debugger('REASON:'||errmsg);
228: end if;
229: fnd_message.set_name(FND_CONST.FND, 'SQL_PLSQL_ERROR');
230: fnd_message.set_token('ROUTINE', routine);
231: fnd_message.set_token('ERRNO', errcode);
232: fnd_message.set_token('REASON', errmsg);
233: end;
226: debugger('ERRNO:'||errcode);
227: debugger('REASON:'||errmsg);
228: end if;
229: fnd_message.set_name(FND_CONST.FND, 'SQL_PLSQL_ERROR');
230: fnd_message.set_token('ROUTINE', routine);
231: fnd_message.set_token('ERRNO', errcode);
232: fnd_message.set_token('REASON', errmsg);
233: end;
234:
227: debugger('REASON:'||errmsg);
228: end if;
229: fnd_message.set_name(FND_CONST.FND, 'SQL_PLSQL_ERROR');
230: fnd_message.set_token('ROUTINE', routine);
231: fnd_message.set_token('ERRNO', errcode);
232: fnd_message.set_token('REASON', errmsg);
233: end;
234:
235: --
228: end if;
229: fnd_message.set_name(FND_CONST.FND, 'SQL_PLSQL_ERROR');
230: fnd_message.set_token('ROUTINE', routine);
231: fnd_message.set_token('ERRNO', errcode);
232: fnd_message.set_token('REASON', errmsg);
233: end;
234:
235: --
236: -- error (Internal)