APPS.JTY_TRANS_USG_PGM_SQL_PKG dependencies on FND_API

Line 127: RAISE FND_API.G_EXC_ERROR;

123: /* Version cannot be null or ORACLE (reserved for seeded SQLs) */
124: IF ((p_version_name IS NULL) OR (p_version_name = 'ORACLE')) THEN
125: retcode := 2;
126: errbuf := 'Version Name cannot be null or oracle';
127: RAISE FND_API.G_EXC_ERROR;
128: END IF;
129:
130: l_enabled_flag := NVL(p_enabled_flag, 'Y');
131: l_use_total_for_dea_flag := NVL(p_use_total_for_dea_flag, 'N');

Line 162: RAISE FND_API.G_EXC_ERROR;

158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN
160: retcode := 2;
161: errbuf := 'No row in the table jty_trans_usg_pgm_details corr to the source, transaction type and program name passed';
162: RAISE FND_API.G_EXC_ERROR;
163: WHEN OTHERS THEN
164: RAISE;
165: END;
166:

Line 171: RAISE FND_API.G_EXC_ERROR;

167: /* Custom Qualifier supported for pass by reference only */
168: IF (l_param_passing_mechanism = 'PBV') THEN
169: retcode := 2;
170: errbuf := 'Custom Qualifier is not supported for transactions having pass by value parameter passing mechanism';
171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173:
174: /* If this version needs to be enabled, then all other versions need to be disabled */
175: IF (l_enabled_flag = 'Y') THEN

Line 569: WHEN FND_API.G_EXC_ERROR THEN

565: retcode := 0;
566: errbuf := null;
567:
568: EXCEPTION
569: WHEN FND_API.G_EXC_ERROR THEN
570: NULL;
571:
572: WHEN OTHERS THEN
573: if (retcode = 0) then