261: l_user_id := FND_GLOBAL.USER_ID;
262: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
263: l_sysdate := sysdate;
264:
265: /* Check to see if the unique id is alreday present in jtf_seeded_qual_all_b */
266: SELECT count(*)
267: INTO l_count
268: FROM jtf_seeded_qual_all_b
269: WHERE seeded_qual_id = p_seeded_qual_id;
264:
265: /* Check to see if the unique id is alreday present in jtf_seeded_qual_all_b */
266: SELECT count(*)
267: INTO l_count
268: FROM jtf_seeded_qual_all_b
269: WHERE seeded_qual_id = p_seeded_qual_id;
270:
271: IF (l_count > 0) THEN
272: retcode := 2;
269: WHERE seeded_qual_id = p_seeded_qual_id;
270:
271: IF (l_count > 0) THEN
272: retcode := 2;
273: errbuf := 'Unique ID alreday present in jtf_seeded_qual_all_b';
274: RAISE FND_API.G_EXC_ERROR;
275: END IF;
276:
277: /* Check to see if the unique id is alreday present in jtf_qual_usgs_all */
328:
329: /* Check if a qualifier exists with the same name */
330: SELECT count(*)
331: INTO l_count
332: FROM jtf_seeded_qual_all_b
333: WHERE upper(name) = upper(p_name);
334:
335: IF (l_count > 0) THEN
336: retcode := 2;
337: errbuf := 'Qualifier exist with the same name';
338: RAISE FND_API.G_EXC_ERROR;
339: END IF;
340:
341: INSERT INTO JTF_SEEDED_QUAL_ALL_B (
342: SEEDED_QUAL_ID,
343: LAST_UPDATE_DATE,
344: LAST_UPDATED_BY,
345: CREATION_DATE,