APPS.JTY_CUST_QUAL_PKG dependencies on FND_API

Line 274: RAISE FND_API.G_EXC_ERROR;

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 */
278: SELECT count(*)

Line 286: RAISE FND_API.G_EXC_ERROR;

282:
283: IF (l_count > 0) THEN
284: retcode := 2;
285: errbuf := 'Unique ID alreday present in jtf_qual_usgs_all';
286: RAISE FND_API.G_EXC_ERROR;
287: END IF;
288:
289: /* get the qual_type_usg_id corr to source and transaction type */
290: BEGIN

Line 300: RAISE FND_API.G_EXC_ERROR;

296: EXCEPTION
297: WHEN OTHERS THEN
298: retcode := 2;
299: errbuf := 'Error in getting qual_type_usg_id from source_id and trans_type_id';
300: RAISE FND_API.G_EXC_ERROR;
301: END;
302:
303: /* get the attribute value insert and update statement */
304: get_attr_val_stmt(

Line 326: RAISE FND_API.G_EXC_ERROR;

322: retcode => retcode,
323: errbuf => errbuf);
324:
325: IF (retcode <> 0) THEN
326: RAISE FND_API.G_EXC_ERROR;
327: END IF;
328:
329: /* Check if a qualifier exists with the same name */
330: SELECT count(*)

Line 338: RAISE FND_API.G_EXC_ERROR;

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,

Line 525: RAISE FND_API.G_EXC_ERROR;

521:
522: IF (l_success_flag <> 'Y') THEN
523: retcode := 2;
524: errbuf := 'Error adding columns to the denorm value tables';
525: RAISE FND_API.G_EXC_ERROR;
526: END IF;
527: END IF;
528:
529: retcode := 0;

Line 532: WHEN FND_API.G_EXC_ERROR THEN

528:
529: retcode := 0;
530: errbuf := null;
531: EXCEPTION
532: WHEN FND_API.G_EXC_ERROR THEN
533: NULL;
534:
535: WHEN OTHERS THEN
536: retcode := 2;