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