323: end if;
324:
325: exception
326: when no_data_found then
327: fnd_message.set_name ('FND',
328: 'Too many rows in sys.dual');
329: return (-1);
330:
331: when insert_error then
328: 'Too many rows in sys.dual');
329: return (-1);
330:
331: when insert_error 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',
336: 'SUBMIT: conflicts_domain_insert_error', FALSE);
329: return (-1);
330:
331: when insert_error 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',
336: 'SUBMIT: conflicts_domain_insert_error', FALSE);
337: return (-1);
330:
331: when insert_error 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',
336: 'SUBMIT: conflicts_domain_insert_error', FALSE);
337: return (-1);
338:
331: when insert_error 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',
336: 'SUBMIT: conflicts_domain_insert_error', FALSE);
337: return (-1);
338:
339: when dup_val_on_index then
354: return (cdid);
355:
356: exception
357: when others then
358: fnd_message.set_name ('FND', 'SQL-Generic error');
359: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
360: fnd_message.set_token ('REASON', sqlerrm, FALSE);
361: fnd_message.set_token (
362: 'ROUTINE', 'SUBMIT: conflicts_domain', FALSE);
355:
356: exception
357: when others then
358: fnd_message.set_name ('FND', 'SQL-Generic error');
359: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
360: fnd_message.set_token ('REASON', sqlerrm, FALSE);
361: fnd_message.set_token (
362: 'ROUTINE', 'SUBMIT: conflicts_domain', FALSE);
363: return (-1);
356: exception
357: when others then
358: fnd_message.set_name ('FND', 'SQL-Generic error');
359: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
360: fnd_message.set_token ('REASON', sqlerrm, FALSE);
361: fnd_message.set_token (
362: 'ROUTINE', 'SUBMIT: conflicts_domain', FALSE);
363: return (-1);
364:
357: when others then
358: fnd_message.set_name ('FND', 'SQL-Generic error');
359: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
360: fnd_message.set_token ('REASON', sqlerrm, FALSE);
361: fnd_message.set_token (
362: 'ROUTINE', 'SUBMIT: conflicts_domain', FALSE);
363: return (-1);
364:
365: end get_cd_id;