313: return (true);
314:
315: exception
316: when relclass_insert_error then
317: fnd_message.set_name ('FND', 'CONC-RelClass insert failed');
318: fnd_message.set_token ('APPLICATION', 0, FALSE);
319: fnd_message.set_token ('CLASS', relseqno, FALSE);
320: return (false);
321: when dual_no_rows then
314:
315: exception
316: when relclass_insert_error then
317: fnd_message.set_name ('FND', 'CONC-RelClass insert failed');
318: fnd_message.set_token ('APPLICATION', 0, FALSE);
319: fnd_message.set_token ('CLASS', relseqno, FALSE);
320: return (false);
321: when dual_no_rows then
322: fnd_message.set_name ('FND', 'No Rows in Dual');
315: exception
316: when relclass_insert_error then
317: fnd_message.set_name ('FND', 'CONC-RelClass insert failed');
318: fnd_message.set_token ('APPLICATION', 0, FALSE);
319: fnd_message.set_token ('CLASS', relseqno, FALSE);
320: return (false);
321: when dual_no_rows then
322: fnd_message.set_name ('FND', 'No Rows in Dual');
323: return (false);
318: fnd_message.set_token ('APPLICATION', 0, FALSE);
319: fnd_message.set_token ('CLASS', relseqno, FALSE);
320: return (false);
321: when dual_no_rows then
322: fnd_message.set_name ('FND', 'No Rows in Dual');
323: return (false);
324: when dual_too_many_rows then
325: fnd_message.set_name ('FND', 'Too many rows in Dual');
326: return (false);
321: when dual_no_rows then
322: fnd_message.set_name ('FND', 'No Rows in Dual');
323: return (false);
324: when dual_too_many_rows then
325: fnd_message.set_name ('FND', 'Too many rows in Dual');
326: return (false);
327: when others then
328: fnd_message.set_name ('FND', 'SQL-Generic error');
329: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
324: when dual_too_many_rows then
325: fnd_message.set_name ('FND', 'Too many rows in Dual');
326: return (false);
327: when others then
328: fnd_message.set_name ('FND', 'SQL-Generic error');
329: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
330: fnd_message.set_token ('REASON', sqlerrm, FALSE);
331: fnd_message.set_token ('ROUTINE', 'assign_specific_sch: others', FALSE);
332: return (false);
325: fnd_message.set_name ('FND', 'Too many rows in Dual');
326: return (false);
327: when others then
328: fnd_message.set_name ('FND', 'SQL-Generic error');
329: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
330: fnd_message.set_token ('REASON', sqlerrm, FALSE);
331: fnd_message.set_token ('ROUTINE', 'assign_specific_sch: others', FALSE);
332: return (false);
333:
326: return (false);
327: when others then
328: fnd_message.set_name ('FND', 'SQL-Generic error');
329: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
330: fnd_message.set_token ('REASON', sqlerrm, FALSE);
331: fnd_message.set_token ('ROUTINE', 'assign_specific_sch: others', FALSE);
332: return (false);
333:
334: end assign_specific_sch;
327: when others then
328: fnd_message.set_name ('FND', 'SQL-Generic error');
329: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
330: fnd_message.set_token ('REASON', sqlerrm, FALSE);
331: fnd_message.set_token ('ROUTINE', 'assign_specific_sch: others', FALSE);
332: return (false);
333:
334: end assign_specific_sch;
335: