260: debugger('ROUTINE:'||routine);
261: debugger('ERRNO:'||errcode);
262: debugger('REASON:'||errmsg);
263: end if;
264: fnd_message.set_name(FND_CONST.FND, 'SQL_PLSQL_ERROR');
265: fnd_message.set_token('ROUTINE', routine);
266: fnd_message.set_token('ERRNO', errcode);
267: fnd_message.set_token('REASON', errmsg);
268: end;
261: debugger('ERRNO:'||errcode);
262: debugger('REASON:'||errmsg);
263: end if;
264: fnd_message.set_name(FND_CONST.FND, 'SQL_PLSQL_ERROR');
265: fnd_message.set_token('ROUTINE', routine);
266: fnd_message.set_token('ERRNO', errcode);
267: fnd_message.set_token('REASON', errmsg);
268: end;
269:
262: debugger('REASON:'||errmsg);
263: end if;
264: fnd_message.set_name(FND_CONST.FND, 'SQL_PLSQL_ERROR');
265: fnd_message.set_token('ROUTINE', routine);
266: fnd_message.set_token('ERRNO', errcode);
267: fnd_message.set_token('REASON', errmsg);
268: end;
269:
270: --
263: end if;
264: fnd_message.set_name(FND_CONST.FND, 'SQL_PLSQL_ERROR');
265: fnd_message.set_token('ROUTINE', routine);
266: fnd_message.set_token('ERRNO', errcode);
267: fnd_message.set_token('REASON', errmsg);
268: end;
269:
270: --
271: -- error (Internal)