325: end if;
326:
327: exception
328: when no_data_found then
329: fnd_message.set_name ('FND',
330: 'Too many rows in sys.dual');
331: return (-1);
332:
333: when insert_error then
330: 'Too many rows in sys.dual');
331: return (-1);
332:
333: when insert_error then
334: fnd_message.set_name ('FND', 'SQL-Generic error');
335: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
336: fnd_message.set_token ('REASON', sqlerrm, FALSE);
337: fnd_message.set_token ('ROUTINE',
338: 'SUBMIT: conflicts_domain_insert_error', FALSE);
331: return (-1);
332:
333: when insert_error then
334: fnd_message.set_name ('FND', 'SQL-Generic error');
335: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
336: fnd_message.set_token ('REASON', sqlerrm, FALSE);
337: fnd_message.set_token ('ROUTINE',
338: 'SUBMIT: conflicts_domain_insert_error', FALSE);
339: return (-1);
332:
333: when insert_error then
334: fnd_message.set_name ('FND', 'SQL-Generic error');
335: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
336: fnd_message.set_token ('REASON', sqlerrm, FALSE);
337: fnd_message.set_token ('ROUTINE',
338: 'SUBMIT: conflicts_domain_insert_error', FALSE);
339: return (-1);
340:
333: when insert_error then
334: fnd_message.set_name ('FND', 'SQL-Generic error');
335: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
336: fnd_message.set_token ('REASON', sqlerrm, FALSE);
337: fnd_message.set_token ('ROUTINE',
338: 'SUBMIT: conflicts_domain_insert_error', FALSE);
339: return (-1);
340:
341: when dup_val_on_index then
356: return (cdid);
357:
358: exception
359: when others then
360: fnd_message.set_name ('FND', 'SQL-Generic error');
361: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
362: fnd_message.set_token ('REASON', sqlerrm, FALSE);
363: fnd_message.set_token (
364: 'ROUTINE', 'SUBMIT: conflicts_domain', FALSE);
357:
358: exception
359: when others then
360: fnd_message.set_name ('FND', 'SQL-Generic error');
361: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
362: fnd_message.set_token ('REASON', sqlerrm, FALSE);
363: fnd_message.set_token (
364: 'ROUTINE', 'SUBMIT: conflicts_domain', FALSE);
365: return (-1);
358: exception
359: when others then
360: fnd_message.set_name ('FND', 'SQL-Generic error');
361: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
362: fnd_message.set_token ('REASON', sqlerrm, FALSE);
363: fnd_message.set_token (
364: 'ROUTINE', 'SUBMIT: conflicts_domain', FALSE);
365: return (-1);
366:
359: when others then
360: fnd_message.set_name ('FND', 'SQL-Generic error');
361: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
362: fnd_message.set_token ('REASON', sqlerrm, FALSE);
363: fnd_message.set_token (
364: 'ROUTINE', 'SUBMIT: conflicts_domain', FALSE);
365: return (-1);
366:
367: end get_cd_id;