eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SPP_PVT dependencies on OKC_API

Line 225: IF (l_sppv_rec.id = OKC_API.G_MISS_NUM) THEN

221: p_sppv_rec IN sppv_rec_type
222: ) RETURN sppv_rec_type IS
223: l_sppv_rec sppv_rec_type := p_sppv_rec;
224: BEGIN
225: IF (l_sppv_rec.id = OKC_API.G_MISS_NUM) THEN
226: l_sppv_rec.id := NULL;
227: END IF;
228: IF (l_sppv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
229: l_sppv_rec.object_version_number := NULL;

Line 228: IF (l_sppv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

224: BEGIN
225: IF (l_sppv_rec.id = OKC_API.G_MISS_NUM) THEN
226: l_sppv_rec.id := NULL;
227: END IF;
228: IF (l_sppv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
229: l_sppv_rec.object_version_number := NULL;
230: END IF;
231: IF (l_sppv_rec.name = OKC_API.G_MISS_CHAR) THEN
232: l_sppv_rec.name := NULL;

Line 231: IF (l_sppv_rec.name = OKC_API.G_MISS_CHAR) THEN

227: END IF;
228: IF (l_sppv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
229: l_sppv_rec.object_version_number := NULL;
230: END IF;
231: IF (l_sppv_rec.name = OKC_API.G_MISS_CHAR) THEN
232: l_sppv_rec.name := NULL;
233: END IF;
234: IF (l_sppv_rec.version = OKC_API.G_MISS_CHAR) THEN
235: l_sppv_rec.version := NULL;

Line 234: IF (l_sppv_rec.version = OKC_API.G_MISS_CHAR) THEN

230: END IF;
231: IF (l_sppv_rec.name = OKC_API.G_MISS_CHAR) THEN
232: l_sppv_rec.name := NULL;
233: END IF;
234: IF (l_sppv_rec.version = OKC_API.G_MISS_CHAR) THEN
235: l_sppv_rec.version := NULL;
236: END IF;
237: IF (l_sppv_rec.date_start = OKC_API.G_MISS_DATE) THEN
238: l_sppv_rec.date_start := NULL;

Line 237: IF (l_sppv_rec.date_start = OKC_API.G_MISS_DATE) THEN

233: END IF;
234: IF (l_sppv_rec.version = OKC_API.G_MISS_CHAR) THEN
235: l_sppv_rec.version := NULL;
236: END IF;
237: IF (l_sppv_rec.date_start = OKC_API.G_MISS_DATE) THEN
238: l_sppv_rec.date_start := NULL;
239: END IF;
240: IF (l_sppv_rec.date_end = OKC_API.G_MISS_DATE) THEN
241: l_sppv_rec.date_end := NULL;

Line 240: IF (l_sppv_rec.date_end = OKC_API.G_MISS_DATE) THEN

236: END IF;
237: IF (l_sppv_rec.date_start = OKC_API.G_MISS_DATE) THEN
238: l_sppv_rec.date_start := NULL;
239: END IF;
240: IF (l_sppv_rec.date_end = OKC_API.G_MISS_DATE) THEN
241: l_sppv_rec.date_end := NULL;
242: END IF;
243: IF (l_sppv_rec.description = OKC_API.G_MISS_CHAR) THEN
244: l_sppv_rec.description := NULL;

Line 243: IF (l_sppv_rec.description = OKC_API.G_MISS_CHAR) THEN

239: END IF;
240: IF (l_sppv_rec.date_end = OKC_API.G_MISS_DATE) THEN
241: l_sppv_rec.date_end := NULL;
242: END IF;
243: IF (l_sppv_rec.description = OKC_API.G_MISS_CHAR) THEN
244: l_sppv_rec.description := NULL;
245: END IF;
246: IF (l_sppv_rec.sps_code = OKC_API.G_MISS_CHAR) THEN
247: l_sppv_rec.sps_code := NULL;

Line 246: IF (l_sppv_rec.sps_code = OKC_API.G_MISS_CHAR) THEN

242: END IF;
243: IF (l_sppv_rec.description = OKC_API.G_MISS_CHAR) THEN
244: l_sppv_rec.description := NULL;
245: END IF;
246: IF (l_sppv_rec.sps_code = OKC_API.G_MISS_CHAR) THEN
247: l_sppv_rec.sps_code := NULL;
248: END IF;
249: IF (l_sppv_rec.dyp_code = OKC_API.G_MISS_CHAR) THEN
250: l_sppv_rec.dyp_code := NULL;

Line 249: IF (l_sppv_rec.dyp_code = OKC_API.G_MISS_CHAR) THEN

245: END IF;
246: IF (l_sppv_rec.sps_code = OKC_API.G_MISS_CHAR) THEN
247: l_sppv_rec.sps_code := NULL;
248: END IF;
249: IF (l_sppv_rec.dyp_code = OKC_API.G_MISS_CHAR) THEN
250: l_sppv_rec.dyp_code := NULL;
251: END IF;
252: IF (l_sppv_rec.array_yn = OKC_API.G_MISS_CHAR) THEN
253: l_sppv_rec.array_yn := NULL;

Line 252: IF (l_sppv_rec.array_yn = OKC_API.G_MISS_CHAR) THEN

248: END IF;
249: IF (l_sppv_rec.dyp_code = OKC_API.G_MISS_CHAR) THEN
250: l_sppv_rec.dyp_code := NULL;
251: END IF;
252: IF (l_sppv_rec.array_yn = OKC_API.G_MISS_CHAR) THEN
253: l_sppv_rec.array_yn := NULL;
254: END IF;
255: IF (l_sppv_rec.xml_tag = OKC_API.G_MISS_CHAR) THEN
256: l_sppv_rec.xml_tag := NULL;

Line 255: IF (l_sppv_rec.xml_tag = OKC_API.G_MISS_CHAR) THEN

251: END IF;
252: IF (l_sppv_rec.array_yn = OKC_API.G_MISS_CHAR) THEN
253: l_sppv_rec.array_yn := NULL;
254: END IF;
255: IF (l_sppv_rec.xml_tag = OKC_API.G_MISS_CHAR) THEN
256: l_sppv_rec.xml_tag := NULL;
257: END IF;
258: IF (l_sppv_rec.attribute_category = OKC_API.G_MISS_CHAR) THEN
259: l_sppv_rec.attribute_category := NULL;

Line 258: IF (l_sppv_rec.attribute_category = OKC_API.G_MISS_CHAR) THEN

254: END IF;
255: IF (l_sppv_rec.xml_tag = OKC_API.G_MISS_CHAR) THEN
256: l_sppv_rec.xml_tag := NULL;
257: END IF;
258: IF (l_sppv_rec.attribute_category = OKC_API.G_MISS_CHAR) THEN
259: l_sppv_rec.attribute_category := NULL;
260: END IF;
261: IF (l_sppv_rec.attribute1 = OKC_API.G_MISS_CHAR) THEN
262: l_sppv_rec.attribute1 := NULL;

Line 261: IF (l_sppv_rec.attribute1 = OKC_API.G_MISS_CHAR) THEN

257: END IF;
258: IF (l_sppv_rec.attribute_category = OKC_API.G_MISS_CHAR) THEN
259: l_sppv_rec.attribute_category := NULL;
260: END IF;
261: IF (l_sppv_rec.attribute1 = OKC_API.G_MISS_CHAR) THEN
262: l_sppv_rec.attribute1 := NULL;
263: END IF;
264: IF (l_sppv_rec.attribute2 = OKC_API.G_MISS_CHAR) THEN
265: l_sppv_rec.attribute2 := NULL;

Line 264: IF (l_sppv_rec.attribute2 = OKC_API.G_MISS_CHAR) THEN

260: END IF;
261: IF (l_sppv_rec.attribute1 = OKC_API.G_MISS_CHAR) THEN
262: l_sppv_rec.attribute1 := NULL;
263: END IF;
264: IF (l_sppv_rec.attribute2 = OKC_API.G_MISS_CHAR) THEN
265: l_sppv_rec.attribute2 := NULL;
266: END IF;
267: IF (l_sppv_rec.attribute3 = OKC_API.G_MISS_CHAR) THEN
268: l_sppv_rec.attribute3 := NULL;

Line 267: IF (l_sppv_rec.attribute3 = OKC_API.G_MISS_CHAR) THEN

263: END IF;
264: IF (l_sppv_rec.attribute2 = OKC_API.G_MISS_CHAR) THEN
265: l_sppv_rec.attribute2 := NULL;
266: END IF;
267: IF (l_sppv_rec.attribute3 = OKC_API.G_MISS_CHAR) THEN
268: l_sppv_rec.attribute3 := NULL;
269: END IF;
270: IF (l_sppv_rec.attribute4 = OKC_API.G_MISS_CHAR) THEN
271: l_sppv_rec.attribute4 := NULL;

Line 270: IF (l_sppv_rec.attribute4 = OKC_API.G_MISS_CHAR) THEN

266: END IF;
267: IF (l_sppv_rec.attribute3 = OKC_API.G_MISS_CHAR) THEN
268: l_sppv_rec.attribute3 := NULL;
269: END IF;
270: IF (l_sppv_rec.attribute4 = OKC_API.G_MISS_CHAR) THEN
271: l_sppv_rec.attribute4 := NULL;
272: END IF;
273: IF (l_sppv_rec.attribute5 = OKC_API.G_MISS_CHAR) THEN
274: l_sppv_rec.attribute5 := NULL;

Line 273: IF (l_sppv_rec.attribute5 = OKC_API.G_MISS_CHAR) THEN

269: END IF;
270: IF (l_sppv_rec.attribute4 = OKC_API.G_MISS_CHAR) THEN
271: l_sppv_rec.attribute4 := NULL;
272: END IF;
273: IF (l_sppv_rec.attribute5 = OKC_API.G_MISS_CHAR) THEN
274: l_sppv_rec.attribute5 := NULL;
275: END IF;
276: IF (l_sppv_rec.attribute6 = OKC_API.G_MISS_CHAR) THEN
277: l_sppv_rec.attribute6 := NULL;

Line 276: IF (l_sppv_rec.attribute6 = OKC_API.G_MISS_CHAR) THEN

272: END IF;
273: IF (l_sppv_rec.attribute5 = OKC_API.G_MISS_CHAR) THEN
274: l_sppv_rec.attribute5 := NULL;
275: END IF;
276: IF (l_sppv_rec.attribute6 = OKC_API.G_MISS_CHAR) THEN
277: l_sppv_rec.attribute6 := NULL;
278: END IF;
279: IF (l_sppv_rec.attribute7 = OKC_API.G_MISS_CHAR) THEN
280: l_sppv_rec.attribute7 := NULL;

Line 279: IF (l_sppv_rec.attribute7 = OKC_API.G_MISS_CHAR) THEN

275: END IF;
276: IF (l_sppv_rec.attribute6 = OKC_API.G_MISS_CHAR) THEN
277: l_sppv_rec.attribute6 := NULL;
278: END IF;
279: IF (l_sppv_rec.attribute7 = OKC_API.G_MISS_CHAR) THEN
280: l_sppv_rec.attribute7 := NULL;
281: END IF;
282: IF (l_sppv_rec.attribute8 = OKC_API.G_MISS_CHAR) THEN
283: l_sppv_rec.attribute8 := NULL;

Line 282: IF (l_sppv_rec.attribute8 = OKC_API.G_MISS_CHAR) THEN

278: END IF;
279: IF (l_sppv_rec.attribute7 = OKC_API.G_MISS_CHAR) THEN
280: l_sppv_rec.attribute7 := NULL;
281: END IF;
282: IF (l_sppv_rec.attribute8 = OKC_API.G_MISS_CHAR) THEN
283: l_sppv_rec.attribute8 := NULL;
284: END IF;
285: IF (l_sppv_rec.attribute9 = OKC_API.G_MISS_CHAR) THEN
286: l_sppv_rec.attribute9 := NULL;

Line 285: IF (l_sppv_rec.attribute9 = OKC_API.G_MISS_CHAR) THEN

281: END IF;
282: IF (l_sppv_rec.attribute8 = OKC_API.G_MISS_CHAR) THEN
283: l_sppv_rec.attribute8 := NULL;
284: END IF;
285: IF (l_sppv_rec.attribute9 = OKC_API.G_MISS_CHAR) THEN
286: l_sppv_rec.attribute9 := NULL;
287: END IF;
288: IF (l_sppv_rec.attribute10 = OKC_API.G_MISS_CHAR) THEN
289: l_sppv_rec.attribute10 := NULL;

Line 288: IF (l_sppv_rec.attribute10 = OKC_API.G_MISS_CHAR) THEN

284: END IF;
285: IF (l_sppv_rec.attribute9 = OKC_API.G_MISS_CHAR) THEN
286: l_sppv_rec.attribute9 := NULL;
287: END IF;
288: IF (l_sppv_rec.attribute10 = OKC_API.G_MISS_CHAR) THEN
289: l_sppv_rec.attribute10 := NULL;
290: END IF;
291: IF (l_sppv_rec.attribute11 = OKC_API.G_MISS_CHAR) THEN
292: l_sppv_rec.attribute11 := NULL;

Line 291: IF (l_sppv_rec.attribute11 = OKC_API.G_MISS_CHAR) THEN

287: END IF;
288: IF (l_sppv_rec.attribute10 = OKC_API.G_MISS_CHAR) THEN
289: l_sppv_rec.attribute10 := NULL;
290: END IF;
291: IF (l_sppv_rec.attribute11 = OKC_API.G_MISS_CHAR) THEN
292: l_sppv_rec.attribute11 := NULL;
293: END IF;
294: IF (l_sppv_rec.attribute12 = OKC_API.G_MISS_CHAR) THEN
295: l_sppv_rec.attribute12 := NULL;

Line 294: IF (l_sppv_rec.attribute12 = OKC_API.G_MISS_CHAR) THEN

290: END IF;
291: IF (l_sppv_rec.attribute11 = OKC_API.G_MISS_CHAR) THEN
292: l_sppv_rec.attribute11 := NULL;
293: END IF;
294: IF (l_sppv_rec.attribute12 = OKC_API.G_MISS_CHAR) THEN
295: l_sppv_rec.attribute12 := NULL;
296: END IF;
297: IF (l_sppv_rec.attribute13 = OKC_API.G_MISS_CHAR) THEN
298: l_sppv_rec.attribute13 := NULL;

Line 297: IF (l_sppv_rec.attribute13 = OKC_API.G_MISS_CHAR) THEN

293: END IF;
294: IF (l_sppv_rec.attribute12 = OKC_API.G_MISS_CHAR) THEN
295: l_sppv_rec.attribute12 := NULL;
296: END IF;
297: IF (l_sppv_rec.attribute13 = OKC_API.G_MISS_CHAR) THEN
298: l_sppv_rec.attribute13 := NULL;
299: END IF;
300: IF (l_sppv_rec.attribute14 = OKC_API.G_MISS_CHAR) THEN
301: l_sppv_rec.attribute14 := NULL;

Line 300: IF (l_sppv_rec.attribute14 = OKC_API.G_MISS_CHAR) THEN

296: END IF;
297: IF (l_sppv_rec.attribute13 = OKC_API.G_MISS_CHAR) THEN
298: l_sppv_rec.attribute13 := NULL;
299: END IF;
300: IF (l_sppv_rec.attribute14 = OKC_API.G_MISS_CHAR) THEN
301: l_sppv_rec.attribute14 := NULL;
302: END IF;
303: IF (l_sppv_rec.attribute15 = OKC_API.G_MISS_CHAR) THEN
304: l_sppv_rec.attribute15 := NULL;

Line 303: IF (l_sppv_rec.attribute15 = OKC_API.G_MISS_CHAR) THEN

299: END IF;
300: IF (l_sppv_rec.attribute14 = OKC_API.G_MISS_CHAR) THEN
301: l_sppv_rec.attribute14 := NULL;
302: END IF;
303: IF (l_sppv_rec.attribute15 = OKC_API.G_MISS_CHAR) THEN
304: l_sppv_rec.attribute15 := NULL;
305: END IF;
306: IF (l_sppv_rec.created_by = OKC_API.G_MISS_NUM) THEN
307: l_sppv_rec.created_by := NULL;

Line 306: IF (l_sppv_rec.created_by = OKC_API.G_MISS_NUM) THEN

302: END IF;
303: IF (l_sppv_rec.attribute15 = OKC_API.G_MISS_CHAR) THEN
304: l_sppv_rec.attribute15 := NULL;
305: END IF;
306: IF (l_sppv_rec.created_by = OKC_API.G_MISS_NUM) THEN
307: l_sppv_rec.created_by := NULL;
308: END IF;
309: IF (l_sppv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
310: l_sppv_rec.last_updated_by := NULL;

Line 309: IF (l_sppv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

305: END IF;
306: IF (l_sppv_rec.created_by = OKC_API.G_MISS_NUM) THEN
307: l_sppv_rec.created_by := NULL;
308: END IF;
309: IF (l_sppv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
310: l_sppv_rec.last_updated_by := NULL;
311: END IF;
312: IF (l_sppv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
313: l_sppv_rec.creation_date := NULL;

Line 312: IF (l_sppv_rec.creation_date = OKC_API.G_MISS_DATE) THEN

308: END IF;
309: IF (l_sppv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
310: l_sppv_rec.last_updated_by := NULL;
311: END IF;
312: IF (l_sppv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
313: l_sppv_rec.creation_date := NULL;
314: END IF;
315: IF (l_sppv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
316: l_sppv_rec.last_update_date := NULL;

Line 315: IF (l_sppv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

311: END IF;
312: IF (l_sppv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
313: l_sppv_rec.creation_date := NULL;
314: END IF;
315: IF (l_sppv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
316: l_sppv_rec.last_update_date := NULL;
317: END IF;
318: IF (l_sppv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
319: l_sppv_rec.last_update_login := NULL;

Line 318: IF (l_sppv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

314: END IF;
315: IF (l_sppv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
316: l_sppv_rec.last_update_date := NULL;
317: END IF;
318: IF (l_sppv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
319: l_sppv_rec.last_update_login := NULL;
320: END IF;
321: RETURN(l_sppv_rec);
322: END null_out_defaults;

Line 335: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

331: ---------------------------------------------------
332: FUNCTION Validate_Attributes (
333: p_sppv_rec IN sppv_rec_type
334: ) RETURN VARCHAR2 IS
335: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
336: BEGIN
337: IF p_sppv_rec.id = OKC_API.G_MISS_NUM OR
338: p_sppv_rec.id IS NULL
339: THEN

Line 337: IF p_sppv_rec.id = OKC_API.G_MISS_NUM OR

333: p_sppv_rec IN sppv_rec_type
334: ) RETURN VARCHAR2 IS
335: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
336: BEGIN
337: IF p_sppv_rec.id = OKC_API.G_MISS_NUM OR
338: p_sppv_rec.id IS NULL
339: THEN
340: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
341: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 340: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

336: BEGIN
337: IF p_sppv_rec.id = OKC_API.G_MISS_NUM OR
338: p_sppv_rec.id IS NULL
339: THEN
340: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
341: l_return_status := OKC_API.G_RET_STS_ERROR;
342: ELSIF p_sppv_rec.date_start = OKC_API.G_MISS_DATE OR
343: p_sppv_rec.date_start IS NULL
344: THEN

Line 341: l_return_status := OKC_API.G_RET_STS_ERROR;

337: IF p_sppv_rec.id = OKC_API.G_MISS_NUM OR
338: p_sppv_rec.id IS NULL
339: THEN
340: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
341: l_return_status := OKC_API.G_RET_STS_ERROR;
342: ELSIF p_sppv_rec.date_start = OKC_API.G_MISS_DATE OR
343: p_sppv_rec.date_start IS NULL
344: THEN
345: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'date_start');

Line 342: ELSIF p_sppv_rec.date_start = OKC_API.G_MISS_DATE OR

338: p_sppv_rec.id IS NULL
339: THEN
340: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
341: l_return_status := OKC_API.G_RET_STS_ERROR;
342: ELSIF p_sppv_rec.date_start = OKC_API.G_MISS_DATE OR
343: p_sppv_rec.date_start IS NULL
344: THEN
345: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'date_start');
346: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 345: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'date_start');

341: l_return_status := OKC_API.G_RET_STS_ERROR;
342: ELSIF p_sppv_rec.date_start = OKC_API.G_MISS_DATE OR
343: p_sppv_rec.date_start IS NULL
344: THEN
345: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'date_start');
346: l_return_status := OKC_API.G_RET_STS_ERROR;
347: ELSIF p_sppv_rec.name = OKC_API.G_MISS_CHAR OR
348: p_sppv_rec.name IS NULL
349: THEN

Line 346: l_return_status := OKC_API.G_RET_STS_ERROR;

342: ELSIF p_sppv_rec.date_start = OKC_API.G_MISS_DATE OR
343: p_sppv_rec.date_start IS NULL
344: THEN
345: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'date_start');
346: l_return_status := OKC_API.G_RET_STS_ERROR;
347: ELSIF p_sppv_rec.name = OKC_API.G_MISS_CHAR OR
348: p_sppv_rec.name IS NULL
349: THEN
350: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');

Line 347: ELSIF p_sppv_rec.name = OKC_API.G_MISS_CHAR OR

343: p_sppv_rec.date_start IS NULL
344: THEN
345: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'date_start');
346: l_return_status := OKC_API.G_RET_STS_ERROR;
347: ELSIF p_sppv_rec.name = OKC_API.G_MISS_CHAR OR
348: p_sppv_rec.name IS NULL
349: THEN
350: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
351: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 350: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');

346: l_return_status := OKC_API.G_RET_STS_ERROR;
347: ELSIF p_sppv_rec.name = OKC_API.G_MISS_CHAR OR
348: p_sppv_rec.name IS NULL
349: THEN
350: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
351: l_return_status := OKC_API.G_RET_STS_ERROR;
352: ELSIF p_sppv_rec.sps_code = OKC_API.G_MISS_CHAR OR
353: p_sppv_rec.sps_code IS NULL
354: THEN

Line 351: l_return_status := OKC_API.G_RET_STS_ERROR;

347: ELSIF p_sppv_rec.name = OKC_API.G_MISS_CHAR OR
348: p_sppv_rec.name IS NULL
349: THEN
350: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
351: l_return_status := OKC_API.G_RET_STS_ERROR;
352: ELSIF p_sppv_rec.sps_code = OKC_API.G_MISS_CHAR OR
353: p_sppv_rec.sps_code IS NULL
354: THEN
355: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sps_code');

Line 352: ELSIF p_sppv_rec.sps_code = OKC_API.G_MISS_CHAR OR

348: p_sppv_rec.name IS NULL
349: THEN
350: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
351: l_return_status := OKC_API.G_RET_STS_ERROR;
352: ELSIF p_sppv_rec.sps_code = OKC_API.G_MISS_CHAR OR
353: p_sppv_rec.sps_code IS NULL
354: THEN
355: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sps_code');
356: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 355: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sps_code');

351: l_return_status := OKC_API.G_RET_STS_ERROR;
352: ELSIF p_sppv_rec.sps_code = OKC_API.G_MISS_CHAR OR
353: p_sppv_rec.sps_code IS NULL
354: THEN
355: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sps_code');
356: l_return_status := OKC_API.G_RET_STS_ERROR;
357: ELSIF p_sppv_rec.dyp_code = OKC_API.G_MISS_CHAR OR
358: p_sppv_rec.dyp_code IS NULL
359: THEN

Line 356: l_return_status := OKC_API.G_RET_STS_ERROR;

352: ELSIF p_sppv_rec.sps_code = OKC_API.G_MISS_CHAR OR
353: p_sppv_rec.sps_code IS NULL
354: THEN
355: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sps_code');
356: l_return_status := OKC_API.G_RET_STS_ERROR;
357: ELSIF p_sppv_rec.dyp_code = OKC_API.G_MISS_CHAR OR
358: p_sppv_rec.dyp_code IS NULL
359: THEN
360: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dyp_code');

Line 357: ELSIF p_sppv_rec.dyp_code = OKC_API.G_MISS_CHAR OR

353: p_sppv_rec.sps_code IS NULL
354: THEN
355: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'sps_code');
356: l_return_status := OKC_API.G_RET_STS_ERROR;
357: ELSIF p_sppv_rec.dyp_code = OKC_API.G_MISS_CHAR OR
358: p_sppv_rec.dyp_code IS NULL
359: THEN
360: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dyp_code');
361: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 360: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dyp_code');

356: l_return_status := OKC_API.G_RET_STS_ERROR;
357: ELSIF p_sppv_rec.dyp_code = OKC_API.G_MISS_CHAR OR
358: p_sppv_rec.dyp_code IS NULL
359: THEN
360: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dyp_code');
361: l_return_status := OKC_API.G_RET_STS_ERROR;
362: ELSIF p_sppv_rec.array_yn = OKC_API.G_MISS_CHAR OR
363: p_sppv_rec.array_yn IS NULL
364: THEN

Line 361: l_return_status := OKC_API.G_RET_STS_ERROR;

357: ELSIF p_sppv_rec.dyp_code = OKC_API.G_MISS_CHAR OR
358: p_sppv_rec.dyp_code IS NULL
359: THEN
360: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dyp_code');
361: l_return_status := OKC_API.G_RET_STS_ERROR;
362: ELSIF p_sppv_rec.array_yn = OKC_API.G_MISS_CHAR OR
363: p_sppv_rec.array_yn IS NULL
364: THEN
365: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'array_yn');

Line 362: ELSIF p_sppv_rec.array_yn = OKC_API.G_MISS_CHAR OR

358: p_sppv_rec.dyp_code IS NULL
359: THEN
360: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dyp_code');
361: l_return_status := OKC_API.G_RET_STS_ERROR;
362: ELSIF p_sppv_rec.array_yn = OKC_API.G_MISS_CHAR OR
363: p_sppv_rec.array_yn IS NULL
364: THEN
365: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'array_yn');
366: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 365: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'array_yn');

361: l_return_status := OKC_API.G_RET_STS_ERROR;
362: ELSIF p_sppv_rec.array_yn = OKC_API.G_MISS_CHAR OR
363: p_sppv_rec.array_yn IS NULL
364: THEN
365: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'array_yn');
366: l_return_status := OKC_API.G_RET_STS_ERROR;
367: ELSIF p_sppv_rec.object_version_number = OKC_API.G_MISS_NUM OR
368: p_sppv_rec.object_version_number IS NULL
369: THEN

Line 366: l_return_status := OKC_API.G_RET_STS_ERROR;

362: ELSIF p_sppv_rec.array_yn = OKC_API.G_MISS_CHAR OR
363: p_sppv_rec.array_yn IS NULL
364: THEN
365: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'array_yn');
366: l_return_status := OKC_API.G_RET_STS_ERROR;
367: ELSIF p_sppv_rec.object_version_number = OKC_API.G_MISS_NUM OR
368: p_sppv_rec.object_version_number IS NULL
369: THEN
370: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 367: ELSIF p_sppv_rec.object_version_number = OKC_API.G_MISS_NUM OR

363: p_sppv_rec.array_yn IS NULL
364: THEN
365: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'array_yn');
366: l_return_status := OKC_API.G_RET_STS_ERROR;
367: ELSIF p_sppv_rec.object_version_number = OKC_API.G_MISS_NUM OR
368: p_sppv_rec.object_version_number IS NULL
369: THEN
370: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
371: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 370: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

366: l_return_status := OKC_API.G_RET_STS_ERROR;
367: ELSIF p_sppv_rec.object_version_number = OKC_API.G_MISS_NUM OR
368: p_sppv_rec.object_version_number IS NULL
369: THEN
370: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
371: l_return_status := OKC_API.G_RET_STS_ERROR;
372: END IF;
373: RETURN(l_return_status);
374: END Validate_Attributes;

Line 371: l_return_status := OKC_API.G_RET_STS_ERROR;

367: ELSIF p_sppv_rec.object_version_number = OKC_API.G_MISS_NUM OR
368: p_sppv_rec.object_version_number IS NULL
369: THEN
370: OKC_API.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
371: l_return_status := OKC_API.G_RET_STS_ERROR;
372: END IF;
373: RETURN(l_return_status);
374: END Validate_Attributes;
375: ---------------------------------------------------------------------------

Line 384: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

380: -----------------------------------------------
381: FUNCTION Validate_Record (
382: p_sppv_rec IN sppv_rec_type
383: ) RETURN VARCHAR2 IS
384: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
385: BEGIN
386: RETURN (l_return_status);
387: END Validate_Record;
388: */

Line 411: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

407: x_return_status OUT NOCOPY VARCHAR2
408: ) IS
409: BEGIN
410: -- initialize return status
411: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
412: IF p_sppv_rec.id = Okc_Api.G_MISS_NUM OR
413: p_sppv_rec.id IS NULL
414: THEN
415: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

Line 412: IF p_sppv_rec.id = Okc_Api.G_MISS_NUM OR

408: ) IS
409: BEGIN
410: -- initialize return status
411: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
412: IF p_sppv_rec.id = Okc_Api.G_MISS_NUM OR
413: p_sppv_rec.id IS NULL
414: THEN
415: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
416: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 415: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

411: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
412: IF p_sppv_rec.id = Okc_Api.G_MISS_NUM OR
413: p_sppv_rec.id IS NULL
414: THEN
415: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
416: x_return_status := Okc_Api.G_RET_STS_ERROR;
417: RAISE G_EXCEPTION_HALT_VALIDATION;
418: END IF;
419: EXCEPTION

Line 416: x_return_status := Okc_Api.G_RET_STS_ERROR;

412: IF p_sppv_rec.id = Okc_Api.G_MISS_NUM OR
413: p_sppv_rec.id IS NULL
414: THEN
415: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
416: x_return_status := Okc_Api.G_RET_STS_ERROR;
417: RAISE G_EXCEPTION_HALT_VALIDATION;
418: END IF;
419: EXCEPTION
420: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 426: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

422: -- with the next column
423: NULL;
424: WHEN OTHERS THEN
425: -- store SQL error message on message stack for caller
426: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
427: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
428: ,p_token1 => G_OKL_SQLCODE_TOKEN
429: ,p_token1_value => SQLCODE
430: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 433: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

429: ,p_token1_value => SQLCODE
430: ,p_token2 => G_OKL_SQLERRM_TOKEN
431: ,p_token2_value => SQLERRM);
432: -- notify caller of an UNEXPECTED error
433: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
434: END Validate_Id;
435: ---------------------------------------------------------------------------
436: -- PROCEDURE Validate_Object_Version_Number
437: ---------------------------------------------------------------------------

Line 453: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

449: x_return_status OUT NOCOPY VARCHAR2
450: ) IS
451: BEGIN
452: -- initialize return status
453: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
454: IF p_sppv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
455: p_sppv_rec.object_version_number IS NULL
456: THEN
457: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 454: IF p_sppv_rec.object_version_number = Okc_Api.G_MISS_NUM OR

450: ) IS
451: BEGIN
452: -- initialize return status
453: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
454: IF p_sppv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
455: p_sppv_rec.object_version_number IS NULL
456: THEN
457: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
458: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 457: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

453: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
454: IF p_sppv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
455: p_sppv_rec.object_version_number IS NULL
456: THEN
457: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
458: x_return_status := Okc_Api.G_RET_STS_ERROR;
459: RAISE G_EXCEPTION_HALT_VALIDATION;
460: END IF;
461: EXCEPTION

Line 458: x_return_status := Okc_Api.G_RET_STS_ERROR;

454: IF p_sppv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
455: p_sppv_rec.object_version_number IS NULL
456: THEN
457: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
458: x_return_status := Okc_Api.G_RET_STS_ERROR;
459: RAISE G_EXCEPTION_HALT_VALIDATION;
460: END IF;
461: EXCEPTION
462: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 468: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

464: -- with the next column
465: NULL;
466: WHEN OTHERS THEN
467: -- store SQL error message on message stack for caller
468: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
469: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
470: ,p_token1 => G_OKL_SQLCODE_TOKEN
471: ,p_token1_value => SQLCODE
472: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 475: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

471: ,p_token1_value => SQLCODE
472: ,p_token2 => G_OKL_SQLERRM_TOKEN
473: ,p_token2_value => SQLERRM);
474: -- notify caller of an UNEXPECTED error
475: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
476: END Validate_Object_Version_Number;
477: ---------------------------------------------------------------------------
478: -- PROCEDURE Validate_Date_Start
479: ---------------------------------------------------------------------------

Line 495: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

491: x_return_status OUT NOCOPY VARCHAR2
492: ) IS
493: BEGIN
494: -- initialize return status
495: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
496: IF p_sppv_rec.Date_Start = Okc_Api.G_MISS_DATE OR
497: p_sppv_rec.Date_Start IS NULL
498: THEN
499: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Date_Start');

Line 496: IF p_sppv_rec.Date_Start = Okc_Api.G_MISS_DATE OR

492: ) IS
493: BEGIN
494: -- initialize return status
495: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
496: IF p_sppv_rec.Date_Start = Okc_Api.G_MISS_DATE OR
497: p_sppv_rec.Date_Start IS NULL
498: THEN
499: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Date_Start');
500: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 499: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Date_Start');

495: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
496: IF p_sppv_rec.Date_Start = Okc_Api.G_MISS_DATE OR
497: p_sppv_rec.Date_Start IS NULL
498: THEN
499: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Date_Start');
500: x_return_status := Okc_Api.G_RET_STS_ERROR;
501: RAISE G_EXCEPTION_HALT_VALIDATION;
502: END IF;
503: EXCEPTION

Line 500: x_return_status := Okc_Api.G_RET_STS_ERROR;

496: IF p_sppv_rec.Date_Start = Okc_Api.G_MISS_DATE OR
497: p_sppv_rec.Date_Start IS NULL
498: THEN
499: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Date_Start');
500: x_return_status := Okc_Api.G_RET_STS_ERROR;
501: RAISE G_EXCEPTION_HALT_VALIDATION;
502: END IF;
503: EXCEPTION
504: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 510: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

506: -- with the next column
507: NULL;
508: WHEN OTHERS THEN
509: -- store SQL error message on message stack for caller
510: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
511: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
512: ,p_token1 => G_OKL_SQLCODE_TOKEN
513: ,p_token1_value => SQLCODE
514: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 517: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

513: ,p_token1_value => SQLCODE
514: ,p_token2 => G_OKL_SQLERRM_TOKEN
515: ,p_token2_value => SQLERRM);
516: -- notify caller of an UNEXPECTED error
517: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
518: END Validate_Date_Start;
519: ------------------------------------------------------------------------------
520: -- PROCEDURE Validate_Date_End
521: ------------------------------------------------------------------------------

Line 535: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

531: PROCEDURE Validate_Date_End(
532: p_sppv_rec IN sppv_rec_type,
533: x_return_status OUT NOCOPY VARCHAR2)
534: IS
535: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
536: BEGIN
537: -- initialize return status
538: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
539: -- check for data before processing

Line 538: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

534: IS
535: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
536: BEGIN
537: -- initialize return status
538: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
539: -- check for data before processing
540: IF p_sppv_rec.date_end <> OKC_API.G_MISS_DATE AND p_sppv_rec.date_end IS NOT NULL
541: THEN
542: IF p_sppv_rec.date_end < p_sppv_rec.date_start

Line 540: IF p_sppv_rec.date_end <> OKC_API.G_MISS_DATE AND p_sppv_rec.date_end IS NOT NULL

536: BEGIN
537: -- initialize return status
538: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
539: -- check for data before processing
540: IF p_sppv_rec.date_end <> OKC_API.G_MISS_DATE AND p_sppv_rec.date_end IS NOT NULL
541: THEN
542: IF p_sppv_rec.date_end < p_sppv_rec.date_start
543: THEN
544: Okc_Api.SET_MESSAGE( p_app_name => G_OKC_APP,

Line 544: Okc_Api.SET_MESSAGE( p_app_name => G_OKC_APP,

540: IF p_sppv_rec.date_end <> OKC_API.G_MISS_DATE AND p_sppv_rec.date_end IS NOT NULL
541: THEN
542: IF p_sppv_rec.date_end < p_sppv_rec.date_start
543: THEN
544: Okc_Api.SET_MESSAGE( p_app_name => G_OKC_APP,
545: p_msg_name => g_invalid_value,
546: p_token1 => g_col_name_token,
547: p_token1_value => 'Date_End' );
548: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 548: x_return_status := Okc_Api.G_RET_STS_ERROR;

544: Okc_Api.SET_MESSAGE( p_app_name => G_OKC_APP,
545: p_msg_name => g_invalid_value,
546: p_token1 => g_col_name_token,
547: p_token1_value => 'Date_End' );
548: x_return_status := Okc_Api.G_RET_STS_ERROR;
549: RAISE G_EXCEPTION_HALT_VALIDATION;
550: END IF;
551: END IF;
552: EXCEPTION

Line 559: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

555: -- with the next column
556: NULL;
557: WHEN OTHERS THEN
558: -- store SQL error message on message stack for caller
559: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
560: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
561: ,p_token1 => G_OKL_SQLCODE_TOKEN
562: ,p_token1_value => SQLCODE
563: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 566: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

562: ,p_token1_value => SQLCODE
563: ,p_token2 => G_OKL_SQLERRM_TOKEN
564: ,p_token2_value => SQLERRM);
565: -- notify caller of an UNEXPECTED error
566: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
567: END Validate_Date_End;
568: ---------------------------------------------------------------------------
569: -- PROCEDURE Validate_Name
570: ---------------------------------------------------------------------------

Line 586: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

582: x_return_status OUT NOCOPY VARCHAR2
583: ) IS
584: BEGIN
585: -- initialize return status
586: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
587: IF p_sppv_rec.Name = Okc_Api.G_MISS_CHAR OR
588: p_sppv_rec.Name IS NULL
589: THEN
590: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Name');

Line 587: IF p_sppv_rec.Name = Okc_Api.G_MISS_CHAR OR

583: ) IS
584: BEGIN
585: -- initialize return status
586: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
587: IF p_sppv_rec.Name = Okc_Api.G_MISS_CHAR OR
588: p_sppv_rec.Name IS NULL
589: THEN
590: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Name');
591: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 590: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Name');

586: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
587: IF p_sppv_rec.Name = Okc_Api.G_MISS_CHAR OR
588: p_sppv_rec.Name IS NULL
589: THEN
590: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Name');
591: x_return_status := Okc_Api.G_RET_STS_ERROR;
592: RAISE G_EXCEPTION_HALT_VALIDATION;
593: END IF;
594: EXCEPTION

Line 591: x_return_status := Okc_Api.G_RET_STS_ERROR;

587: IF p_sppv_rec.Name = Okc_Api.G_MISS_CHAR OR
588: p_sppv_rec.Name IS NULL
589: THEN
590: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Name');
591: x_return_status := Okc_Api.G_RET_STS_ERROR;
592: RAISE G_EXCEPTION_HALT_VALIDATION;
593: END IF;
594: EXCEPTION
595: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 601: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

597: -- with the next column
598: NULL;
599: WHEN OTHERS THEN
600: -- store SQL error message on message stack for caller
601: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
602: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
603: ,p_token1 => G_OKL_SQLCODE_TOKEN
604: ,p_token1_value => SQLCODE
605: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 608: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

604: ,p_token1_value => SQLCODE
605: ,p_token2 => G_OKL_SQLERRM_TOKEN
606: ,p_token2_value => SQLERRM);
607: -- notify caller of an UNEXPECTED error
608: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
609: END Validate_Name;
610: ---------------------------------------------------------------------------
611: -- PROCEDURE Validate_Version
612: ---------------------------------------------------------------------------

Line 628: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

624: x_return_status OUT NOCOPY VARCHAR2
625: ) IS
626: BEGIN
627: -- initialize return status
628: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
629: IF p_sppv_rec.Version = Okc_Api.G_MISS_CHAR OR
630: p_sppv_rec.Version IS NULL
631: THEN
632: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Version');

Line 629: IF p_sppv_rec.Version = Okc_Api.G_MISS_CHAR OR

625: ) IS
626: BEGIN
627: -- initialize return status
628: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
629: IF p_sppv_rec.Version = Okc_Api.G_MISS_CHAR OR
630: p_sppv_rec.Version IS NULL
631: THEN
632: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Version');
633: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 632: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Version');

628: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
629: IF p_sppv_rec.Version = Okc_Api.G_MISS_CHAR OR
630: p_sppv_rec.Version IS NULL
631: THEN
632: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Version');
633: x_return_status := Okc_Api.G_RET_STS_ERROR;
634: RAISE G_EXCEPTION_HALT_VALIDATION;
635: END IF;
636: EXCEPTION

Line 633: x_return_status := Okc_Api.G_RET_STS_ERROR;

629: IF p_sppv_rec.Version = Okc_Api.G_MISS_CHAR OR
630: p_sppv_rec.Version IS NULL
631: THEN
632: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Version');
633: x_return_status := Okc_Api.G_RET_STS_ERROR;
634: RAISE G_EXCEPTION_HALT_VALIDATION;
635: END IF;
636: EXCEPTION
637: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 643: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

639: -- with the next column
640: NULL;
641: WHEN OTHERS THEN
642: -- store SQL error message on message stack for caller
643: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
644: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
645: ,p_token1 => G_OKL_SQLCODE_TOKEN
646: ,p_token1_value => SQLCODE
647: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 650: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

646: ,p_token1_value => SQLCODE
647: ,p_token2 => G_OKL_SQLERRM_TOKEN
648: ,p_token2_value => SQLERRM);
649: -- notify caller of an UNEXPECTED error
650: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
651: END Validate_Version;
652: ---------------------------------------------------------------------------
653: -- PROCEDURE Validate_Sps_Code
654: --------------------------------------------------------------------------

Line 673: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

669: l_found VARCHAR2(1);
670:
671: BEGIN
672: -- initialize return status
673: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
674: -- check for data before processing
675: IF (p_sppv_rec.sps_code IS NULL) OR
676: (p_sppv_rec .sps_code = Okc_Api.G_MISS_CHAR) THEN
677: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

Line 676: (p_sppv_rec .sps_code = Okc_Api.G_MISS_CHAR) THEN

672: -- initialize return status
673: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
674: -- check for data before processing
675: IF (p_sppv_rec.sps_code IS NULL) OR
676: (p_sppv_rec .sps_code = Okc_Api.G_MISS_CHAR) THEN
677: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
678: ,p_msg_name => g_required_value
679: ,p_token1 => g_col_name_token
680: ,p_token1_value => 'SPS_CODE');

Line 677: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

673: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
674: -- check for data before processing
675: IF (p_sppv_rec.sps_code IS NULL) OR
676: (p_sppv_rec .sps_code = Okc_Api.G_MISS_CHAR) THEN
677: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
678: ,p_msg_name => g_required_value
679: ,p_token1 => g_col_name_token
680: ,p_token1_value => 'SPS_CODE');
681: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 681: x_return_status := Okc_Api.G_RET_STS_ERROR;

677: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
678: ,p_msg_name => g_required_value
679: ,p_token1 => g_col_name_token
680: ,p_token1_value => 'SPS_CODE');
681: x_return_status := Okc_Api.G_RET_STS_ERROR;
682: RAISE G_EXCEPTION_HALT_VALIDATION;
683: ELSE
684: --Check if sps_code exists in the fnd_common_lookups or not
685: l_found := okl_accounting_util.validate_lookup_code(p_lookup_type => 'OKL_PRICE_PARAMS_SPS_CODE',

Line 690: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SPS_CODE');

686: p_lookup_code => p_sppv_rec.sps_code);
687:
688:
689: IF (l_found <> OKL_API.G_TRUE ) THEN
690: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SPS_CODE');
691: x_return_status := Okc_Api.G_RET_STS_ERROR;
692: -- raise the exception as there's no matching foreign key value
693: RAISE G_EXCEPTION_HALT_VALIDATION;
694: END IF;

Line 691: x_return_status := Okc_Api.G_RET_STS_ERROR;

687:
688:
689: IF (l_found <> OKL_API.G_TRUE ) THEN
690: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SPS_CODE');
691: x_return_status := Okc_Api.G_RET_STS_ERROR;
692: -- raise the exception as there's no matching foreign key value
693: RAISE G_EXCEPTION_HALT_VALIDATION;
694: END IF;
695: END IF;

Line 703: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

699: -- with the next column
700: NULL;
701: WHEN OTHERS THEN
702: -- store SQL error message on message stack for caller
703: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
704: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
705: ,p_token1 => G_OKL_SQLCODE_TOKEN
706: ,p_token1_value => SQLCODE
707: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 710: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

706: ,p_token1_value => SQLCODE
707: ,p_token2 => G_OKL_SQLERRM_TOKEN
708: ,p_token2_value => SQLERRM);
709: -- notify caller of an UNEXPECTED error
710: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
711: END Validate_Sps_Code;
712: ---------------------------------------------------------------------------
713: -- PROCEDURE Validate_Dyp_Code
714: --------------------------------------------------------------------------

Line 733: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

729: l_found VARCHAR2(1);
730:
731: BEGIN
732: -- initialize return status
733: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
734: -- check for data before processing
735: IF (p_sppv_rec.dyp_code IS NULL) OR
736: (p_sppv_rec .dyp_code = Okc_Api.G_MISS_CHAR) THEN
737: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

Line 736: (p_sppv_rec .dyp_code = Okc_Api.G_MISS_CHAR) THEN

732: -- initialize return status
733: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
734: -- check for data before processing
735: IF (p_sppv_rec.dyp_code IS NULL) OR
736: (p_sppv_rec .dyp_code = Okc_Api.G_MISS_CHAR) THEN
737: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
738: ,p_msg_name => g_required_value
739: ,p_token1 => g_col_name_token
740: ,p_token1_value => 'DYP_CODE');

Line 737: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP

733: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
734: -- check for data before processing
735: IF (p_sppv_rec.dyp_code IS NULL) OR
736: (p_sppv_rec .dyp_code = Okc_Api.G_MISS_CHAR) THEN
737: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
738: ,p_msg_name => g_required_value
739: ,p_token1 => g_col_name_token
740: ,p_token1_value => 'DYP_CODE');
741: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 741: x_return_status := Okc_Api.G_RET_STS_ERROR;

737: Okc_Api.SET_MESSAGE(p_app_name => G_OKC_APP
738: ,p_msg_name => g_required_value
739: ,p_token1 => g_col_name_token
740: ,p_token1_value => 'DYP_CODE');
741: x_return_status := Okc_Api.G_RET_STS_ERROR;
742: RAISE G_EXCEPTION_HALT_VALIDATION;
743: ELSIF p_sppv_rec.dyp_code IS NOT NULL THEN
744: --Check if dyp_code exists in the fnd_common_lookups or not
745: l_found := okl_accounting_util.validate_lookup_code(p_lookup_type => 'OKL_PRICE_PARAMS_DYP_CODE',

Line 750: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SPS_CODE');

746: p_lookup_code => p_sppv_rec.dyp_code);
747:
748:
749: IF (l_found <> OKL_API.G_TRUE ) THEN
750: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SPS_CODE');
751: x_return_status := Okc_Api.G_RET_STS_ERROR;
752: -- raise the exception as there's no matching foreign key value
753: RAISE G_EXCEPTION_HALT_VALIDATION;
754: END IF;

Line 751: x_return_status := Okc_Api.G_RET_STS_ERROR;

747:
748:
749: IF (l_found <> OKL_API.G_TRUE ) THEN
750: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SPS_CODE');
751: x_return_status := Okc_Api.G_RET_STS_ERROR;
752: -- raise the exception as there's no matching foreign key value
753: RAISE G_EXCEPTION_HALT_VALIDATION;
754: END IF;
755: END IF;

Line 763: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

759: -- with the next column
760: NULL;
761: WHEN OTHERS THEN
762: -- store SQL error message on message stack for caller
763: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
764: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
765: ,p_token1 => G_OKL_SQLCODE_TOKEN
766: ,p_token1_value => SQLCODE
767: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 770: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

766: ,p_token1_value => SQLCODE
767: ,p_token2 => G_OKL_SQLERRM_TOKEN
768: ,p_token2_value => SQLERRM);
769: -- notify caller of an UNEXPECTED error
770: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
771: END Validate_Dyp_Code;
772: ---------------------------------------------------------------------------
773: -- PROCEDURE Validate_Array_Yn
774: ---------------------------------------------------------------------------

Line 793: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

789: l_found VARCHAR2(1);
790:
791: BEGIN
792: -- initialize return status
793: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
794: IF p_sppv_rec.Array_Yn = Okc_Api.G_MISS_CHAR OR
795: p_sppv_rec.Array_Yn IS NULL
796: THEN
797: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Array_Yn');

Line 794: IF p_sppv_rec.Array_Yn = Okc_Api.G_MISS_CHAR OR

790:
791: BEGIN
792: -- initialize return status
793: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
794: IF p_sppv_rec.Array_Yn = Okc_Api.G_MISS_CHAR OR
795: p_sppv_rec.Array_Yn IS NULL
796: THEN
797: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Array_Yn');
798: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 797: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Array_Yn');

793: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
794: IF p_sppv_rec.Array_Yn = Okc_Api.G_MISS_CHAR OR
795: p_sppv_rec.Array_Yn IS NULL
796: THEN
797: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Array_Yn');
798: x_return_status := Okc_Api.G_RET_STS_ERROR;
799: RAISE G_EXCEPTION_HALT_VALIDATION;
800: ELSE
801: l_found := okl_accounting_util.validate_lookup_code(p_lookup_type => 'YES_NO',

Line 798: x_return_status := Okc_Api.G_RET_STS_ERROR;

794: IF p_sppv_rec.Array_Yn = Okc_Api.G_MISS_CHAR OR
795: p_sppv_rec.Array_Yn IS NULL
796: THEN
797: Okc_Api.set_message(G_OKC_APP, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'Array_Yn');
798: x_return_status := Okc_Api.G_RET_STS_ERROR;
799: RAISE G_EXCEPTION_HALT_VALIDATION;
800: ELSE
801: l_found := okl_accounting_util.validate_lookup_code(p_lookup_type => 'YES_NO',
802: p_lookup_code => p_sppv_rec.Array_yn,

Line 808: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Array_YN');

804: p_view_app_id => 0);
805:
806:
807: IF (l_found <> OKL_API.G_TRUE ) THEN
808: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Array_YN');
809: x_return_status := Okc_Api.G_RET_STS_ERROR;
810: -- raise the exception as there's no matching foreign key value
811: RAISE G_EXCEPTION_HALT_VALIDATION;
812: END IF;

Line 809: x_return_status := Okc_Api.G_RET_STS_ERROR;

805:
806:
807: IF (l_found <> OKL_API.G_TRUE ) THEN
808: OKC_API.set_message(G_OKC_APP, G_INVALID_VALUE,G_COL_NAME_TOKEN,'Array_YN');
809: x_return_status := Okc_Api.G_RET_STS_ERROR;
810: -- raise the exception as there's no matching foreign key value
811: RAISE G_EXCEPTION_HALT_VALIDATION;
812: END IF;
813: END IF;

Line 821: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

817: -- with the next column
818: NULL;
819: WHEN OTHERS THEN
820: -- store SQL error message on message stack for caller
821: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
822: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
823: ,p_token1 => G_OKL_SQLCODE_TOKEN
824: ,p_token1_value => SQLCODE
825: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 828: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

824: ,p_token1_value => SQLCODE
825: ,p_token2 => G_OKL_SQLERRM_TOKEN
826: ,p_token2_value => SQLERRM);
827: -- notify caller of an UNEXPECTED error
828: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
829: END Validate_Array_Yn;
830: ---------------------------------------------------------------------------
831: -- FUNCTION Validate_Attributes
832: ---------------------------------------------------------------------------

Line 845: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

841: ---------------------------------------------------------------------------
842: FUNCTION Validate_Attributes (
843: p_sppv_rec IN sppv_rec_type
844: ) RETURN VARCHAR2 IS
845: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
846: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
847: BEGIN
848: -- call each column-level validation
849: -- Validate_Id

Line 846: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

842: FUNCTION Validate_Attributes (
843: p_sppv_rec IN sppv_rec_type
844: ) RETURN VARCHAR2 IS
845: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
846: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
847: BEGIN
848: -- call each column-level validation
849: -- Validate_Id
850: Validate_Id(p_sppv_rec, x_return_status);

Line 851: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

847: BEGIN
848: -- call each column-level validation
849: -- Validate_Id
850: Validate_Id(p_sppv_rec, x_return_status);
851: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
852: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
853: -- need to exit
854: l_return_status := x_return_status;
855: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 852: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

848: -- call each column-level validation
849: -- Validate_Id
850: Validate_Id(p_sppv_rec, x_return_status);
851: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
852: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
853: -- need to exit
854: l_return_status := x_return_status;
855: RAISE G_EXCEPTION_HALT_VALIDATION;
856: ELSE

Line 863: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

859: END IF;
860: END IF;
861: -- Validate_Object_Version_Number
862: Validate_Object_Version_Number(p_sppv_rec, x_return_status);
863: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
864: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
865: -- need to exit
866: l_return_status := x_return_status;
867: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 864: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

860: END IF;
861: -- Validate_Object_Version_Number
862: Validate_Object_Version_Number(p_sppv_rec, x_return_status);
863: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
864: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
865: -- need to exit
866: l_return_status := x_return_status;
867: RAISE G_EXCEPTION_HALT_VALIDATION;
868: ELSE

Line 875: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

871: END IF;
872: END IF;
873: -- Validate_Name
874: Validate_Name(p_sppv_rec, x_return_status);
875: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
876: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
877: -- need to exit
878: l_return_status := x_return_status;
879: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 876: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

872: END IF;
873: -- Validate_Name
874: Validate_Name(p_sppv_rec, x_return_status);
875: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
876: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
877: -- need to exit
878: l_return_status := x_return_status;
879: RAISE G_EXCEPTION_HALT_VALIDATION;
880: ELSE

Line 887: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

883: END IF;
884: END IF;
885: -- Validate_Version
886: Validate_Version(p_sppv_rec, x_return_status);
887: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
888: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
889: -- need to exit
890: l_return_status := x_return_status;
891: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 888: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

884: END IF;
885: -- Validate_Version
886: Validate_Version(p_sppv_rec, x_return_status);
887: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
888: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
889: -- need to exit
890: l_return_status := x_return_status;
891: RAISE G_EXCEPTION_HALT_VALIDATION;
892: ELSE

Line 899: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

895: END IF;
896: END IF;
897: -- Validate_Date_Start
898: Validate_Date_Start(p_sppv_rec, x_return_status);
899: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
900: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
901: -- need to exit
902: l_return_status := x_return_status;
903: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 900: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

896: END IF;
897: -- Validate_Date_Start
898: Validate_Date_Start(p_sppv_rec, x_return_status);
899: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
900: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
901: -- need to exit
902: l_return_status := x_return_status;
903: RAISE G_EXCEPTION_HALT_VALIDATION;
904: ELSE

Line 911: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

907: END IF;
908: END IF;
909: -- Validate_Date_End
910: Validate_Date_End(p_sppv_rec, x_return_status);
911: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
912: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
913: -- need to exit
914: l_return_status := x_return_status;
915: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 912: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

908: END IF;
909: -- Validate_Date_End
910: Validate_Date_End(p_sppv_rec, x_return_status);
911: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
912: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
913: -- need to exit
914: l_return_status := x_return_status;
915: RAISE G_EXCEPTION_HALT_VALIDATION;
916: ELSE

Line 923: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

919: END IF;
920: END IF;
921: -- Validate_Sps_Code
922: Validate_Sps_Code(p_sppv_rec, x_return_status);
923: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
924: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
925: -- need to exit
926: l_return_status := x_return_status;
927: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 924: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

920: END IF;
921: -- Validate_Sps_Code
922: Validate_Sps_Code(p_sppv_rec, x_return_status);
923: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
924: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
925: -- need to exit
926: l_return_status := x_return_status;
927: RAISE G_EXCEPTION_HALT_VALIDATION;
928: ELSE

Line 935: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

931: END IF;
932: END IF;
933: -- Validate_Dyp_Code
934: Validate_Dyp_Code(p_sppv_rec, x_return_status);
935: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
936: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
937: -- need to exit
938: l_return_status := x_return_status;
939: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 936: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

932: END IF;
933: -- Validate_Dyp_Code
934: Validate_Dyp_Code(p_sppv_rec, x_return_status);
935: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
936: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
937: -- need to exit
938: l_return_status := x_return_status;
939: RAISE G_EXCEPTION_HALT_VALIDATION;
940: ELSE

Line 947: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

943: END IF;
944: END IF;
945: -- Validate_Array_Yn
946: Validate_Array_Yn(p_sppv_rec, x_return_status);
947: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
948: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
949: -- need to exit
950: l_return_status := x_return_status;
951: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 948: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

944: END IF;
945: -- Validate_Array_Yn
946: Validate_Array_Yn(p_sppv_rec, x_return_status);
947: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
948: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
949: -- need to exit
950: l_return_status := x_return_status;
951: RAISE G_EXCEPTION_HALT_VALIDATION;
952: ELSE

Line 965: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

961: NULL;
962: RETURN (l_return_status);
963: WHEN OTHERS THEN
964: -- store SQL error message on message stack for caller
965: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
966: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
967: ,p_token1 => G_OKL_SQLCODE_TOKEN
968: ,p_token1_value => SQLCODE
969: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 972: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

968: ,p_token1_value => SQLCODE
969: ,p_token2 => G_OKL_SQLERRM_TOKEN
970: ,p_token2_value => SQLERRM);
971: -- notify caller of an UNEXPECTED error
972: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
973: RETURN(l_return_status);
974: END Validate_Attributes;
975: ---------------------------------------------------------------------------
976: -- PROCEDURE Validate_Unique_Spp_Record

Line 1001: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

997: AND version = p_rec.version
998: AND id <> NVL(p_rec.id,-9999);
999: BEGIN
1000: -- initialize return status
1001: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1002: OPEN okl_spp_uk_csr(p_sppv_rec);
1003: FETCH okl_spp_uk_csr INTO l_dummy;
1004: l_row_found := okl_spp_uk_csr%FOUND;
1005: CLOSE okl_spp_uk_csr;

Line 1007: Okc_Api.set_message(G_APP_NAME,G_OKL_UNQS);

1003: FETCH okl_spp_uk_csr INTO l_dummy;
1004: l_row_found := okl_spp_uk_csr%FOUND;
1005: CLOSE okl_spp_uk_csr;
1006: IF l_row_found THEN
1007: Okc_Api.set_message(G_APP_NAME,G_OKL_UNQS);
1008: x_return_status := Okc_Api.G_RET_STS_ERROR;
1009: END IF;
1010: EXCEPTION
1011: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1008: x_return_status := Okc_Api.G_RET_STS_ERROR;

1004: l_row_found := okl_spp_uk_csr%FOUND;
1005: CLOSE okl_spp_uk_csr;
1006: IF l_row_found THEN
1007: Okc_Api.set_message(G_APP_NAME,G_OKL_UNQS);
1008: x_return_status := Okc_Api.G_RET_STS_ERROR;
1009: END IF;
1010: EXCEPTION
1011: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1012: -- no processing necessary; validation can continue

Line 1017: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

1013: -- with the next column
1014: NULL;
1015: WHEN OTHERS THEN
1016: -- store SQL error message on message stack for caller
1017: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
1018: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
1019: ,p_token1 => G_OKL_SQLCODE_TOKEN
1020: ,p_token1_value => SQLCODE
1021: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 1024: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1020: ,p_token1_value => SQLCODE
1021: ,p_token2 => G_OKL_SQLERRM_TOKEN
1022: ,p_token2_value => SQLERRM);
1023: -- notify caller of an UNEXPECTED error
1024: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1025: END Validate_Unique_spp_Record;
1026: ---------------------------------------------------------------------------
1027: -- PROCEDURE Validate_Record
1028: ---------------------------------------------------------------------------

Line 1041: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1037: ---------------------------------------------------------------------------
1038: FUNCTION Validate_Record (
1039: p_sppv_rec IN sppv_rec_type
1040: ) RETURN VARCHAR2 IS
1041: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1042: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1043: BEGIN
1044: -- Validate_Unique_Spp_Record
1045: Validate_Unique_Spp_Record(p_sppv_rec, x_return_status);

Line 1042: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1038: FUNCTION Validate_Record (
1039: p_sppv_rec IN sppv_rec_type
1040: ) RETURN VARCHAR2 IS
1041: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1042: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1043: BEGIN
1044: -- Validate_Unique_Spp_Record
1045: Validate_Unique_Spp_Record(p_sppv_rec, x_return_status);
1046: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

Line 1046: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1042: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1043: BEGIN
1044: -- Validate_Unique_Spp_Record
1045: Validate_Unique_Spp_Record(p_sppv_rec, x_return_status);
1046: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1047: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1048: -- need to leave
1049: l_return_status := x_return_status;
1050: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1047: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1043: BEGIN
1044: -- Validate_Unique_Spp_Record
1045: Validate_Unique_Spp_Record(p_sppv_rec, x_return_status);
1046: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1047: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1048: -- need to leave
1049: l_return_status := x_return_status;
1050: RAISE G_EXCEPTION_HALT_VALIDATION;
1051: ELSE

Line 1064: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

1060: NULL;
1061: RETURN (l_return_status);
1062: WHEN OTHERS THEN
1063: -- store SQL error message on message stack for caller
1064: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
1065: ,p_msg_name => G_OKL_UNEXPECTED_ERROR
1066: ,p_token1 => G_OKL_SQLCODE_TOKEN
1067: ,p_token1_value => SQLCODE
1068: ,p_token2 => G_OKL_SQLERRM_TOKEN

Line 1071: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1067: ,p_token1_value => SQLCODE
1068: ,p_token2 => G_OKL_SQLERRM_TOKEN
1069: ,p_token2_value => SQLERRM);
1070: -- notify caller of an UNEXPECTED error
1071: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1072: RETURN(l_return_status);
1073: END Validate_Record;
1074: -- END change : mvasudev
1075: ---------------------------------------------------------------------------

Line 1164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1160: -- validate_row for:OKL_SIF_PRICE_PARMS_V --
1161: --------------------------------------------
1162: PROCEDURE validate_row(
1163: p_api_version IN NUMBER,
1164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1165: x_return_status OUT NOCOPY VARCHAR2,
1166: x_msg_count OUT NOCOPY NUMBER,
1167: x_msg_data OUT NOCOPY VARCHAR2,
1168: p_sppv_rec IN sppv_rec_type) IS

Line 1171: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1167: x_msg_data OUT NOCOPY VARCHAR2,
1168: p_sppv_rec IN sppv_rec_type) IS
1169: l_api_version CONSTANT NUMBER := 1;
1170: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1171: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1172: l_sppv_rec sppv_rec_type := p_sppv_rec;
1173: l_spp_rec spp_rec_type;
1174: BEGIN
1175: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1175: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1171: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1172: l_sppv_rec sppv_rec_type := p_sppv_rec;
1173: l_spp_rec spp_rec_type;
1174: BEGIN
1175: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1176: G_PKG_NAME,
1177: p_init_msg_list,
1178: l_api_version,
1179: p_api_version,

Line 1182: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1178: l_api_version,
1179: p_api_version,
1180: '_PVT',
1181: x_return_status);
1182: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1184: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1185: RAISE OKC_API.G_EXCEPTION_ERROR;
1186: END IF;

Line 1183: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1179: p_api_version,
1180: '_PVT',
1181: x_return_status);
1182: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1184: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1185: RAISE OKC_API.G_EXCEPTION_ERROR;
1186: END IF;
1187: --- Validate all non-missing attributes (Item Level Validation)

Line 1184: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1180: '_PVT',
1181: x_return_status);
1182: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1184: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1185: RAISE OKC_API.G_EXCEPTION_ERROR;
1186: END IF;
1187: --- Validate all non-missing attributes (Item Level Validation)
1188: l_return_status := Validate_Attributes(l_sppv_rec);

Line 1185: RAISE OKC_API.G_EXCEPTION_ERROR;

1181: x_return_status);
1182: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1184: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1185: RAISE OKC_API.G_EXCEPTION_ERROR;
1186: END IF;
1187: --- Validate all non-missing attributes (Item Level Validation)
1188: l_return_status := Validate_Attributes(l_sppv_rec);
1189: --- If any errors happen abort API

Line 1190: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1186: END IF;
1187: --- Validate all non-missing attributes (Item Level Validation)
1188: l_return_status := Validate_Attributes(l_sppv_rec);
1189: --- If any errors happen abort API
1190: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1192: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1193: RAISE OKC_API.G_EXCEPTION_ERROR;
1194: END IF;

Line 1191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1187: --- Validate all non-missing attributes (Item Level Validation)
1188: l_return_status := Validate_Attributes(l_sppv_rec);
1189: --- If any errors happen abort API
1190: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1192: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1193: RAISE OKC_API.G_EXCEPTION_ERROR;
1194: END IF;
1195: l_return_status := Validate_Record(l_sppv_rec);

Line 1192: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1188: l_return_status := Validate_Attributes(l_sppv_rec);
1189: --- If any errors happen abort API
1190: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1192: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1193: RAISE OKC_API.G_EXCEPTION_ERROR;
1194: END IF;
1195: l_return_status := Validate_Record(l_sppv_rec);
1196: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1193: RAISE OKC_API.G_EXCEPTION_ERROR;

1189: --- If any errors happen abort API
1190: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1191: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1192: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1193: RAISE OKC_API.G_EXCEPTION_ERROR;
1194: END IF;
1195: l_return_status := Validate_Record(l_sppv_rec);
1196: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1196: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1192: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1193: RAISE OKC_API.G_EXCEPTION_ERROR;
1194: END IF;
1195: l_return_status := Validate_Record(l_sppv_rec);
1196: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1199: RAISE OKC_API.G_EXCEPTION_ERROR;
1200: END IF;

Line 1197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1193: RAISE OKC_API.G_EXCEPTION_ERROR;
1194: END IF;
1195: l_return_status := Validate_Record(l_sppv_rec);
1196: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1199: RAISE OKC_API.G_EXCEPTION_ERROR;
1200: END IF;
1201: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1198: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1194: END IF;
1195: l_return_status := Validate_Record(l_sppv_rec);
1196: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1199: RAISE OKC_API.G_EXCEPTION_ERROR;
1200: END IF;
1201: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1202: EXCEPTION

Line 1199: RAISE OKC_API.G_EXCEPTION_ERROR;

1195: l_return_status := Validate_Record(l_sppv_rec);
1196: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1199: RAISE OKC_API.G_EXCEPTION_ERROR;
1200: END IF;
1201: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1202: EXCEPTION
1203: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1201: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1197: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1198: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1199: RAISE OKC_API.G_EXCEPTION_ERROR;
1200: END IF;
1201: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1202: EXCEPTION
1203: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1204: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1205: (

Line 1203: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1199: RAISE OKC_API.G_EXCEPTION_ERROR;
1200: END IF;
1201: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1202: EXCEPTION
1203: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1204: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1205: (
1206: l_api_name,
1207: G_PKG_NAME,

Line 1204: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1200: END IF;
1201: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1202: EXCEPTION
1203: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1204: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1205: (
1206: l_api_name,
1207: G_PKG_NAME,
1208: 'OKC_API.G_RET_STS_ERROR',

Line 1208: 'OKC_API.G_RET_STS_ERROR',

1204: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1205: (
1206: l_api_name,
1207: G_PKG_NAME,
1208: 'OKC_API.G_RET_STS_ERROR',
1209: x_msg_count,
1210: x_msg_data,
1211: '_PVT'
1212: );

Line 1213: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1209: x_msg_count,
1210: x_msg_data,
1211: '_PVT'
1212: );
1213: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1214: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1215: (
1216: l_api_name,
1217: G_PKG_NAME,

Line 1214: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1210: x_msg_data,
1211: '_PVT'
1212: );
1213: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1214: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1215: (
1216: l_api_name,
1217: G_PKG_NAME,
1218: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1218: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1214: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1215: (
1216: l_api_name,
1217: G_PKG_NAME,
1218: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1219: x_msg_count,
1220: x_msg_data,
1221: '_PVT'
1222: );

Line 1224: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1220: x_msg_data,
1221: '_PVT'
1222: );
1223: WHEN OTHERS THEN
1224: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1225: (
1226: l_api_name,
1227: G_PKG_NAME,
1228: 'OTHERS',

Line 1239: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1235: -- PL/SQL TBL validate_row for:SPPV_TBL --
1236: ------------------------------------------
1237: PROCEDURE validate_row(
1238: p_api_version IN NUMBER,
1239: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1240: x_return_status OUT NOCOPY VARCHAR2,
1241: x_msg_count OUT NOCOPY NUMBER,
1242: x_msg_data OUT NOCOPY VARCHAR2,
1243: p_sppv_tbl IN sppv_tbl_type) IS

Line 1246: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1242: x_msg_data OUT NOCOPY VARCHAR2,
1243: p_sppv_tbl IN sppv_tbl_type) IS
1244: l_api_version CONSTANT NUMBER := 1;
1245: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1246: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1247: i NUMBER := 0;
1248: -- START change : mvasudev, 08/16/2001
1249: -- Adding OverAll Status Flag
1250: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 1250: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1246: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1247: i NUMBER := 0;
1248: -- START change : mvasudev, 08/16/2001
1249: -- Adding OverAll Status Flag
1250: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1251: -- END change : mvasudev
1252: BEGIN
1253: OKC_API.init_msg_list(p_init_msg_list);
1254: -- Make sure PL/SQL table has records in it before passing

Line 1253: OKC_API.init_msg_list(p_init_msg_list);

1249: -- Adding OverAll Status Flag
1250: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1251: -- END change : mvasudev
1252: BEGIN
1253: OKC_API.init_msg_list(p_init_msg_list);
1254: -- Make sure PL/SQL table has records in it before passing
1255: IF (p_sppv_tbl.COUNT > 0) THEN
1256: i := p_sppv_tbl.FIRST;
1257: LOOP

Line 1260: p_init_msg_list => OKC_API.G_FALSE,

1256: i := p_sppv_tbl.FIRST;
1257: LOOP
1258: validate_row (
1259: p_api_version => p_api_version,
1260: p_init_msg_list => OKC_API.G_FALSE,
1261: x_return_status => x_return_status,
1262: x_msg_count => x_msg_count,
1263: x_msg_data => x_msg_data,
1264: p_sppv_rec => p_sppv_tbl(i));

Line 1267: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1263: x_msg_data => x_msg_data,
1264: p_sppv_rec => p_sppv_tbl(i));
1265: -- START change : mvasudev, 08/16/2001
1266: -- store the highest degree of error
1267: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1268: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1269: l_overall_status := x_return_status;
1270: END IF;
1271: END IF;

Line 1268: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1264: p_sppv_rec => p_sppv_tbl(i));
1265: -- START change : mvasudev, 08/16/2001
1266: -- store the highest degree of error
1267: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1268: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1269: l_overall_status := x_return_status;
1270: END IF;
1271: END IF;
1272: -- END change : mvasudev

Line 1282: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1278: x_return_status := l_overall_status;
1279: -- END change : mvasudev
1280: END IF;
1281: EXCEPTION
1282: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1284: (
1285: l_api_name,
1286: G_PKG_NAME,

Line 1283: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1279: -- END change : mvasudev
1280: END IF;
1281: EXCEPTION
1282: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1284: (
1285: l_api_name,
1286: G_PKG_NAME,
1287: 'OKC_API.G_RET_STS_ERROR',

Line 1287: 'OKC_API.G_RET_STS_ERROR',

1283: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1284: (
1285: l_api_name,
1286: G_PKG_NAME,
1287: 'OKC_API.G_RET_STS_ERROR',
1288: x_msg_count,
1289: x_msg_data,
1290: '_PVT'
1291: );

Line 1292: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1288: x_msg_count,
1289: x_msg_data,
1290: '_PVT'
1291: );
1292: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1293: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1294: (
1295: l_api_name,
1296: G_PKG_NAME,

Line 1293: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1289: x_msg_data,
1290: '_PVT'
1291: );
1292: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1293: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1294: (
1295: l_api_name,
1296: G_PKG_NAME,
1297: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1297: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1293: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1294: (
1295: l_api_name,
1296: G_PKG_NAME,
1297: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1298: x_msg_count,
1299: x_msg_data,
1300: '_PVT'
1301: );

Line 1303: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1299: x_msg_data,
1300: '_PVT'
1301: );
1302: WHEN OTHERS THEN
1303: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1304: (
1305: l_api_name,
1306: G_PKG_NAME,
1307: 'OTHERS',

Line 1320: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1316: ----------------------------------------
1317: -- insert_row for:OKL_SIF_PRICE_PARMS --
1318: ----------------------------------------
1319: PROCEDURE insert_row(
1320: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1321: x_return_status OUT NOCOPY VARCHAR2,
1322: x_msg_count OUT NOCOPY NUMBER,
1323: x_msg_data OUT NOCOPY VARCHAR2,
1324: p_spp_rec IN spp_rec_type,

Line 1328: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1324: p_spp_rec IN spp_rec_type,
1325: x_spp_rec OUT NOCOPY spp_rec_type) IS
1326: l_api_version CONSTANT NUMBER := 1;
1327: l_api_name CONSTANT VARCHAR2(30) := 'PARMS_insert_row';
1328: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1329: l_spp_rec spp_rec_type := p_spp_rec;
1330: l_def_spp_rec spp_rec_type;
1331: --------------------------------------------
1332: -- Set_Attributes for:OKL_SIF_PRICE_PARMS --

Line 1338: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1334: FUNCTION Set_Attributes (
1335: p_spp_rec IN spp_rec_type,
1336: x_spp_rec OUT NOCOPY spp_rec_type
1337: ) RETURN VARCHAR2 IS
1338: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1339: BEGIN
1340: x_spp_rec := p_spp_rec;
1341: RETURN(l_return_status);
1342: END Set_Attributes;

Line 1344: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1340: x_spp_rec := p_spp_rec;
1341: RETURN(l_return_status);
1342: END Set_Attributes;
1343: BEGIN
1344: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1345: p_init_msg_list,
1346: '_PVT',
1347: x_return_status);
1348: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1348: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1344: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1345: p_init_msg_list,
1346: '_PVT',
1347: x_return_status);
1348: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1349: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1350: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1351: RAISE OKC_API.G_EXCEPTION_ERROR;
1352: END IF;

Line 1349: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1345: p_init_msg_list,
1346: '_PVT',
1347: x_return_status);
1348: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1349: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1350: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1351: RAISE OKC_API.G_EXCEPTION_ERROR;
1352: END IF;
1353: --- Setting item attributes

Line 1350: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1346: '_PVT',
1347: x_return_status);
1348: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1349: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1350: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1351: RAISE OKC_API.G_EXCEPTION_ERROR;
1352: END IF;
1353: --- Setting item attributes
1354: l_return_status := Set_Attributes(

Line 1351: RAISE OKC_API.G_EXCEPTION_ERROR;

1347: x_return_status);
1348: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1349: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1350: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1351: RAISE OKC_API.G_EXCEPTION_ERROR;
1352: END IF;
1353: --- Setting item attributes
1354: l_return_status := Set_Attributes(
1355: p_spp_rec, -- IN

Line 1358: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1354: l_return_status := Set_Attributes(
1355: p_spp_rec, -- IN
1356: l_spp_rec); -- OUT
1357: --- If any errors happen abort API
1358: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1359: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1360: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1361: RAISE OKC_API.G_EXCEPTION_ERROR;
1362: END IF;

Line 1359: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1355: p_spp_rec, -- IN
1356: l_spp_rec); -- OUT
1357: --- If any errors happen abort API
1358: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1359: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1360: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1361: RAISE OKC_API.G_EXCEPTION_ERROR;
1362: END IF;
1363: INSERT INTO OKL_SIF_PRICE_PARMS(

Line 1360: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1356: l_spp_rec); -- OUT
1357: --- If any errors happen abort API
1358: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1359: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1360: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1361: RAISE OKC_API.G_EXCEPTION_ERROR;
1362: END IF;
1363: INSERT INTO OKL_SIF_PRICE_PARMS(
1364: id,

Line 1361: RAISE OKC_API.G_EXCEPTION_ERROR;

1357: --- If any errors happen abort API
1358: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1359: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1360: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1361: RAISE OKC_API.G_EXCEPTION_ERROR;
1362: END IF;
1363: INSERT INTO OKL_SIF_PRICE_PARMS(
1364: id,
1365: object_version_number,

Line 1431: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1427: l_spp_rec.last_update_date,
1428: l_spp_rec.last_update_login);
1429: -- Set OUT values
1430: x_spp_rec := l_spp_rec;
1431: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1432: EXCEPTION
1433: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1434: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1435: (

Line 1433: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1429: -- Set OUT values
1430: x_spp_rec := l_spp_rec;
1431: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1432: EXCEPTION
1433: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1434: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1435: (
1436: l_api_name,
1437: G_PKG_NAME,

Line 1434: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1430: x_spp_rec := l_spp_rec;
1431: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1432: EXCEPTION
1433: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1434: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1435: (
1436: l_api_name,
1437: G_PKG_NAME,
1438: 'OKC_API.G_RET_STS_ERROR',

Line 1438: 'OKC_API.G_RET_STS_ERROR',

1434: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1435: (
1436: l_api_name,
1437: G_PKG_NAME,
1438: 'OKC_API.G_RET_STS_ERROR',
1439: x_msg_count,
1440: x_msg_data,
1441: '_PVT'
1442: );

Line 1443: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1439: x_msg_count,
1440: x_msg_data,
1441: '_PVT'
1442: );
1443: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1444: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1445: (
1446: l_api_name,
1447: G_PKG_NAME,

Line 1444: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1440: x_msg_data,
1441: '_PVT'
1442: );
1443: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1444: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1445: (
1446: l_api_name,
1447: G_PKG_NAME,
1448: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1448: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1444: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1445: (
1446: l_api_name,
1447: G_PKG_NAME,
1448: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1449: x_msg_count,
1450: x_msg_data,
1451: '_PVT'
1452: );

Line 1454: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1450: x_msg_data,
1451: '_PVT'
1452: );
1453: WHEN OTHERS THEN
1454: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1455: (
1456: l_api_name,
1457: G_PKG_NAME,
1458: 'OTHERS',

Line 1469: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1465: -- insert_row for:OKL_SIF_PRICE_PARMS_V --
1466: ------------------------------------------
1467: PROCEDURE insert_row(
1468: p_api_version IN NUMBER,
1469: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1470: x_return_status OUT NOCOPY VARCHAR2,
1471: x_msg_count OUT NOCOPY NUMBER,
1472: x_msg_data OUT NOCOPY VARCHAR2,
1473: p_sppv_rec IN sppv_rec_type,

Line 1477: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1473: p_sppv_rec IN sppv_rec_type,
1474: x_sppv_rec OUT NOCOPY sppv_rec_type) IS
1475: l_api_version CONSTANT NUMBER := 1;
1476: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1477: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1478: l_sppv_rec sppv_rec_type;
1479: l_def_sppv_rec sppv_rec_type;
1480: l_spp_rec spp_rec_type;
1481: lx_spp_rec spp_rec_type;

Line 1504: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1500: FUNCTION Set_Attributes (
1501: p_sppv_rec IN sppv_rec_type,
1502: x_sppv_rec OUT NOCOPY sppv_rec_type
1503: ) RETURN VARCHAR2 IS
1504: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1505: BEGIN
1506: x_sppv_rec := p_sppv_rec;
1507: x_sppv_rec.OBJECT_VERSION_NUMBER := 1;
1508: RETURN(l_return_status);

Line 1511: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1507: x_sppv_rec.OBJECT_VERSION_NUMBER := 1;
1508: RETURN(l_return_status);
1509: END Set_Attributes;
1510: BEGIN
1511: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1512: G_PKG_NAME,
1513: p_init_msg_list,
1514: l_api_version,
1515: p_api_version,

Line 1518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1514: l_api_version,
1515: p_api_version,
1516: '_PVT',
1517: x_return_status);
1518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1521: RAISE OKC_API.G_EXCEPTION_ERROR;
1522: END IF;

Line 1519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1515: p_api_version,
1516: '_PVT',
1517: x_return_status);
1518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1521: RAISE OKC_API.G_EXCEPTION_ERROR;
1522: END IF;
1523: l_sppv_rec := null_out_defaults(p_sppv_rec);

Line 1520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1516: '_PVT',
1517: x_return_status);
1518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1521: RAISE OKC_API.G_EXCEPTION_ERROR;
1522: END IF;
1523: l_sppv_rec := null_out_defaults(p_sppv_rec);
1524: -- Set primary key value

Line 1521: RAISE OKC_API.G_EXCEPTION_ERROR;

1517: x_return_status);
1518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1521: RAISE OKC_API.G_EXCEPTION_ERROR;
1522: END IF;
1523: l_sppv_rec := null_out_defaults(p_sppv_rec);
1524: -- Set primary key value
1525: l_sppv_rec.ID := get_seq_id;

Line 1531: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1527: l_return_status := Set_Attributes(
1528: l_sppv_rec, -- IN
1529: l_def_sppv_rec); -- OUT
1530: --- If any errors happen abort API
1531: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1532: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1533: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1534: RAISE OKC_API.G_EXCEPTION_ERROR;
1535: END IF;

Line 1532: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1528: l_sppv_rec, -- IN
1529: l_def_sppv_rec); -- OUT
1530: --- If any errors happen abort API
1531: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1532: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1533: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1534: RAISE OKC_API.G_EXCEPTION_ERROR;
1535: END IF;
1536: l_def_sppv_rec := fill_who_columns(l_def_sppv_rec);

Line 1533: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1529: l_def_sppv_rec); -- OUT
1530: --- If any errors happen abort API
1531: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1532: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1533: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1534: RAISE OKC_API.G_EXCEPTION_ERROR;
1535: END IF;
1536: l_def_sppv_rec := fill_who_columns(l_def_sppv_rec);
1537: --- Validate all non-missing attributes (Item Level Validation)

Line 1534: RAISE OKC_API.G_EXCEPTION_ERROR;

1530: --- If any errors happen abort API
1531: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1532: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1533: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1534: RAISE OKC_API.G_EXCEPTION_ERROR;
1535: END IF;
1536: l_def_sppv_rec := fill_who_columns(l_def_sppv_rec);
1537: --- Validate all non-missing attributes (Item Level Validation)
1538: l_return_status := Validate_Attributes(l_def_sppv_rec);

Line 1540: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1536: l_def_sppv_rec := fill_who_columns(l_def_sppv_rec);
1537: --- Validate all non-missing attributes (Item Level Validation)
1538: l_return_status := Validate_Attributes(l_def_sppv_rec);
1539: --- If any errors happen abort API
1540: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1541: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1542: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1543: RAISE OKC_API.G_EXCEPTION_ERROR;
1544: END IF;

Line 1541: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1537: --- Validate all non-missing attributes (Item Level Validation)
1538: l_return_status := Validate_Attributes(l_def_sppv_rec);
1539: --- If any errors happen abort API
1540: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1541: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1542: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1543: RAISE OKC_API.G_EXCEPTION_ERROR;
1544: END IF;
1545: l_return_status := Validate_Record(l_def_sppv_rec);

Line 1542: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1538: l_return_status := Validate_Attributes(l_def_sppv_rec);
1539: --- If any errors happen abort API
1540: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1541: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1542: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1543: RAISE OKC_API.G_EXCEPTION_ERROR;
1544: END IF;
1545: l_return_status := Validate_Record(l_def_sppv_rec);
1546: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1543: RAISE OKC_API.G_EXCEPTION_ERROR;

1539: --- If any errors happen abort API
1540: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1541: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1542: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1543: RAISE OKC_API.G_EXCEPTION_ERROR;
1544: END IF;
1545: l_return_status := Validate_Record(l_def_sppv_rec);
1546: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1546: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1542: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1543: RAISE OKC_API.G_EXCEPTION_ERROR;
1544: END IF;
1545: l_return_status := Validate_Record(l_def_sppv_rec);
1546: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1548: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1549: RAISE OKC_API.G_EXCEPTION_ERROR;
1550: END IF;

Line 1547: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1543: RAISE OKC_API.G_EXCEPTION_ERROR;
1544: END IF;
1545: l_return_status := Validate_Record(l_def_sppv_rec);
1546: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1548: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1549: RAISE OKC_API.G_EXCEPTION_ERROR;
1550: END IF;
1551: --------------------------------------

Line 1548: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1544: END IF;
1545: l_return_status := Validate_Record(l_def_sppv_rec);
1546: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1548: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1549: RAISE OKC_API.G_EXCEPTION_ERROR;
1550: END IF;
1551: --------------------------------------
1552: -- Move VIEW record to "Child" records

Line 1549: RAISE OKC_API.G_EXCEPTION_ERROR;

1545: l_return_status := Validate_Record(l_def_sppv_rec);
1546: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1548: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1549: RAISE OKC_API.G_EXCEPTION_ERROR;
1550: END IF;
1551: --------------------------------------
1552: -- Move VIEW record to "Child" records
1553: --------------------------------------

Line 1566: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1562: x_msg_data,
1563: l_spp_rec,
1564: lx_spp_rec
1565: );
1566: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1568: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1569: RAISE OKC_API.G_EXCEPTION_ERROR;
1570: END IF;

Line 1567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1563: l_spp_rec,
1564: lx_spp_rec
1565: );
1566: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1568: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1569: RAISE OKC_API.G_EXCEPTION_ERROR;
1570: END IF;
1571: migrate(lx_spp_rec, l_def_sppv_rec);

Line 1568: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1564: lx_spp_rec
1565: );
1566: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1568: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1569: RAISE OKC_API.G_EXCEPTION_ERROR;
1570: END IF;
1571: migrate(lx_spp_rec, l_def_sppv_rec);
1572: -- Set OUT values

Line 1569: RAISE OKC_API.G_EXCEPTION_ERROR;

1565: );
1566: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1568: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1569: RAISE OKC_API.G_EXCEPTION_ERROR;
1570: END IF;
1571: migrate(lx_spp_rec, l_def_sppv_rec);
1572: -- Set OUT values
1573: x_sppv_rec := l_def_sppv_rec;

Line 1574: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1570: END IF;
1571: migrate(lx_spp_rec, l_def_sppv_rec);
1572: -- Set OUT values
1573: x_sppv_rec := l_def_sppv_rec;
1574: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1575: EXCEPTION
1576: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1577: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1578: (

Line 1576: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1572: -- Set OUT values
1573: x_sppv_rec := l_def_sppv_rec;
1574: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1575: EXCEPTION
1576: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1577: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1578: (
1579: l_api_name,
1580: G_PKG_NAME,

Line 1577: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1573: x_sppv_rec := l_def_sppv_rec;
1574: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1575: EXCEPTION
1576: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1577: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1578: (
1579: l_api_name,
1580: G_PKG_NAME,
1581: 'OKC_API.G_RET_STS_ERROR',

Line 1581: 'OKC_API.G_RET_STS_ERROR',

1577: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1578: (
1579: l_api_name,
1580: G_PKG_NAME,
1581: 'OKC_API.G_RET_STS_ERROR',
1582: x_msg_count,
1583: x_msg_data,
1584: '_PVT'
1585: );

Line 1586: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1582: x_msg_count,
1583: x_msg_data,
1584: '_PVT'
1585: );
1586: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1587: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1588: (
1589: l_api_name,
1590: G_PKG_NAME,

Line 1587: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1583: x_msg_data,
1584: '_PVT'
1585: );
1586: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1587: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1588: (
1589: l_api_name,
1590: G_PKG_NAME,
1591: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1591: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1587: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1588: (
1589: l_api_name,
1590: G_PKG_NAME,
1591: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1592: x_msg_count,
1593: x_msg_data,
1594: '_PVT'
1595: );

Line 1597: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1593: x_msg_data,
1594: '_PVT'
1595: );
1596: WHEN OTHERS THEN
1597: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1598: (
1599: l_api_name,
1600: G_PKG_NAME,
1601: 'OTHERS',

Line 1612: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1608: -- PL/SQL TBL insert_row for:SPPV_TBL --
1609: ----------------------------------------
1610: PROCEDURE insert_row(
1611: p_api_version IN NUMBER,
1612: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1613: x_return_status OUT NOCOPY VARCHAR2,
1614: x_msg_count OUT NOCOPY NUMBER,
1615: x_msg_data OUT NOCOPY VARCHAR2,
1616: p_sppv_tbl IN sppv_tbl_type,

Line 1620: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1616: p_sppv_tbl IN sppv_tbl_type,
1617: x_sppv_tbl OUT NOCOPY sppv_tbl_type) IS
1618: l_api_version CONSTANT NUMBER := 1;
1619: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1620: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1621: i NUMBER := 0;
1622: -- START change : mvasudev, 08/16/2001
1623: -- Adding OverAll Status Flag
1624: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 1624: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1620: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1621: i NUMBER := 0;
1622: -- START change : mvasudev, 08/16/2001
1623: -- Adding OverAll Status Flag
1624: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1625: -- END change : mvasudev
1626: BEGIN
1627: OKC_API.init_msg_list(p_init_msg_list);
1628: -- Make sure PL/SQL table has records in it before passing

Line 1627: OKC_API.init_msg_list(p_init_msg_list);

1623: -- Adding OverAll Status Flag
1624: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1625: -- END change : mvasudev
1626: BEGIN
1627: OKC_API.init_msg_list(p_init_msg_list);
1628: -- Make sure PL/SQL table has records in it before passing
1629: IF (p_sppv_tbl.COUNT > 0) THEN
1630: i := p_sppv_tbl.FIRST;
1631: LOOP

Line 1634: p_init_msg_list => OKC_API.G_FALSE,

1630: i := p_sppv_tbl.FIRST;
1631: LOOP
1632: insert_row (
1633: p_api_version => p_api_version,
1634: p_init_msg_list => OKC_API.G_FALSE,
1635: x_return_status => x_return_status,
1636: x_msg_count => x_msg_count,
1637: x_msg_data => x_msg_data,
1638: p_sppv_rec => p_sppv_tbl(i),

Line 1642: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1638: p_sppv_rec => p_sppv_tbl(i),
1639: x_sppv_rec => x_sppv_tbl(i));
1640: -- START change : mvasudev, 08/16/2001
1641: -- store the highest degree of error
1642: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1643: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1644: l_overall_status := x_return_status;
1645: END IF;
1646: END IF;

Line 1643: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1639: x_sppv_rec => x_sppv_tbl(i));
1640: -- START change : mvasudev, 08/16/2001
1641: -- store the highest degree of error
1642: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1643: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1644: l_overall_status := x_return_status;
1645: END IF;
1646: END IF;
1647: -- END change : mvasudev

Line 1657: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1653: x_return_status := l_overall_status;
1654: -- END change : mvasudev
1655: END IF;
1656: EXCEPTION
1657: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1658: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1659: (
1660: l_api_name,
1661: G_PKG_NAME,

Line 1658: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1654: -- END change : mvasudev
1655: END IF;
1656: EXCEPTION
1657: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1658: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1659: (
1660: l_api_name,
1661: G_PKG_NAME,
1662: 'OKC_API.G_RET_STS_ERROR',

Line 1662: 'OKC_API.G_RET_STS_ERROR',

1658: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1659: (
1660: l_api_name,
1661: G_PKG_NAME,
1662: 'OKC_API.G_RET_STS_ERROR',
1663: x_msg_count,
1664: x_msg_data,
1665: '_PVT'
1666: );

Line 1667: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1663: x_msg_count,
1664: x_msg_data,
1665: '_PVT'
1666: );
1667: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1668: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1669: (
1670: l_api_name,
1671: G_PKG_NAME,

Line 1668: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1664: x_msg_data,
1665: '_PVT'
1666: );
1667: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1668: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1669: (
1670: l_api_name,
1671: G_PKG_NAME,
1672: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1672: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1668: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1669: (
1670: l_api_name,
1671: G_PKG_NAME,
1672: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1673: x_msg_count,
1674: x_msg_data,
1675: '_PVT'
1676: );

Line 1678: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1674: x_msg_data,
1675: '_PVT'
1676: );
1677: WHEN OTHERS THEN
1678: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1679: (
1680: l_api_name,
1681: G_PKG_NAME,
1682: 'OTHERS',

Line 1695: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1691: --------------------------------------
1692: -- lock_row for:OKL_SIF_PRICE_PARMS --
1693: --------------------------------------
1694: PROCEDURE lock_row(
1695: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1696: x_return_status OUT NOCOPY VARCHAR2,
1697: x_msg_count OUT NOCOPY NUMBER,
1698: x_msg_data OUT NOCOPY VARCHAR2,
1699: p_spp_rec IN spp_rec_type) IS

Line 1714: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1710: FROM OKL_SIF_PRICE_PARMS
1711: WHERE ID = p_spp_rec.id;
1712: l_api_version CONSTANT NUMBER := 1;
1713: l_api_name CONSTANT VARCHAR2(30) := 'PARMS_lock_row';
1714: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1715: l_object_version_number OKL_SIF_PRICE_PARMS.OBJECT_VERSION_NUMBER%TYPE;
1716: lc_object_version_number OKL_SIF_PRICE_PARMS.OBJECT_VERSION_NUMBER%TYPE;
1717: l_row_notfound BOOLEAN := FALSE;
1718: lc_row_notfound BOOLEAN := FALSE;

Line 1720: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1716: lc_object_version_number OKL_SIF_PRICE_PARMS.OBJECT_VERSION_NUMBER%TYPE;
1717: l_row_notfound BOOLEAN := FALSE;
1718: lc_row_notfound BOOLEAN := FALSE;
1719: BEGIN
1720: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1721: p_init_msg_list,
1722: '_PVT',
1723: x_return_status);
1724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1720: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1721: p_init_msg_list,
1722: '_PVT',
1723: x_return_status);
1724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1726: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_ERROR;
1728: END IF;

Line 1725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1721: p_init_msg_list,
1722: '_PVT',
1723: x_return_status);
1724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1726: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_ERROR;
1728: END IF;
1729: BEGIN

Line 1726: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1722: '_PVT',
1723: x_return_status);
1724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1726: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_ERROR;
1728: END IF;
1729: BEGIN
1730: OPEN lock_csr(p_spp_rec);

Line 1727: RAISE OKC_API.G_EXCEPTION_ERROR;

1723: x_return_status);
1724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1726: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_ERROR;
1728: END IF;
1729: BEGIN
1730: OPEN lock_csr(p_spp_rec);
1731: FETCH lock_csr INTO l_object_version_number;

Line 1739: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1735: WHEN E_Resource_Busy THEN
1736: IF (lock_csr%ISOPEN) THEN
1737: CLOSE lock_csr;
1738: END IF;
1739: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1740: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1741: END;
1742: IF ( l_row_notfound ) THEN
1743: OPEN lchk_csr(p_spp_rec);

Line 1749: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1745: lc_row_notfound := lchk_csr%NOTFOUND;
1746: CLOSE lchk_csr;
1747: END IF;
1748: IF (lc_row_notfound) THEN
1749: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1750: RAISE OKC_API.G_EXCEPTION_ERROR;
1751: ELSIF lc_object_version_number > p_spp_rec.object_version_number THEN
1752: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1753: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1750: RAISE OKC_API.G_EXCEPTION_ERROR;

1746: CLOSE lchk_csr;
1747: END IF;
1748: IF (lc_row_notfound) THEN
1749: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1750: RAISE OKC_API.G_EXCEPTION_ERROR;
1751: ELSIF lc_object_version_number > p_spp_rec.object_version_number THEN
1752: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1753: RAISE OKC_API.G_EXCEPTION_ERROR;
1754: ELSIF lc_object_version_number <> p_spp_rec.object_version_number THEN

Line 1752: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1748: IF (lc_row_notfound) THEN
1749: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1750: RAISE OKC_API.G_EXCEPTION_ERROR;
1751: ELSIF lc_object_version_number > p_spp_rec.object_version_number THEN
1752: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1753: RAISE OKC_API.G_EXCEPTION_ERROR;
1754: ELSIF lc_object_version_number <> p_spp_rec.object_version_number THEN
1755: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1756: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1753: RAISE OKC_API.G_EXCEPTION_ERROR;

1749: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1750: RAISE OKC_API.G_EXCEPTION_ERROR;
1751: ELSIF lc_object_version_number > p_spp_rec.object_version_number THEN
1752: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1753: RAISE OKC_API.G_EXCEPTION_ERROR;
1754: ELSIF lc_object_version_number <> p_spp_rec.object_version_number THEN
1755: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1756: RAISE OKC_API.G_EXCEPTION_ERROR;
1757: ELSIF lc_object_version_number = -1 THEN

Line 1755: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1751: ELSIF lc_object_version_number > p_spp_rec.object_version_number THEN
1752: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1753: RAISE OKC_API.G_EXCEPTION_ERROR;
1754: ELSIF lc_object_version_number <> p_spp_rec.object_version_number THEN
1755: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1756: RAISE OKC_API.G_EXCEPTION_ERROR;
1757: ELSIF lc_object_version_number = -1 THEN
1758: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);
1759: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1756: RAISE OKC_API.G_EXCEPTION_ERROR;

1752: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1753: RAISE OKC_API.G_EXCEPTION_ERROR;
1754: ELSIF lc_object_version_number <> p_spp_rec.object_version_number THEN
1755: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1756: RAISE OKC_API.G_EXCEPTION_ERROR;
1757: ELSIF lc_object_version_number = -1 THEN
1758: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);
1759: RAISE OKC_API.G_EXCEPTION_ERROR;
1760: END IF;

Line 1758: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);

1754: ELSIF lc_object_version_number <> p_spp_rec.object_version_number THEN
1755: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1756: RAISE OKC_API.G_EXCEPTION_ERROR;
1757: ELSIF lc_object_version_number = -1 THEN
1758: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);
1759: RAISE OKC_API.G_EXCEPTION_ERROR;
1760: END IF;
1761: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1762: EXCEPTION

Line 1759: RAISE OKC_API.G_EXCEPTION_ERROR;

1755: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1756: RAISE OKC_API.G_EXCEPTION_ERROR;
1757: ELSIF lc_object_version_number = -1 THEN
1758: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);
1759: RAISE OKC_API.G_EXCEPTION_ERROR;
1760: END IF;
1761: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1762: EXCEPTION
1763: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1761: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1757: ELSIF lc_object_version_number = -1 THEN
1758: OKC_API.set_message(G_OKC_APP,G_RECORD_LOGICALLY_DELETED);
1759: RAISE OKC_API.G_EXCEPTION_ERROR;
1760: END IF;
1761: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1762: EXCEPTION
1763: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1764: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1765: (

Line 1763: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1759: RAISE OKC_API.G_EXCEPTION_ERROR;
1760: END IF;
1761: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1762: EXCEPTION
1763: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1764: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1765: (
1766: l_api_name,
1767: G_PKG_NAME,

Line 1764: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1760: END IF;
1761: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1762: EXCEPTION
1763: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1764: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1765: (
1766: l_api_name,
1767: G_PKG_NAME,
1768: 'OKC_API.G_RET_STS_ERROR',

Line 1768: 'OKC_API.G_RET_STS_ERROR',

1764: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1765: (
1766: l_api_name,
1767: G_PKG_NAME,
1768: 'OKC_API.G_RET_STS_ERROR',
1769: x_msg_count,
1770: x_msg_data,
1771: '_PVT'
1772: );

Line 1773: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1769: x_msg_count,
1770: x_msg_data,
1771: '_PVT'
1772: );
1773: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1774: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1775: (
1776: l_api_name,
1777: G_PKG_NAME,

Line 1774: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1770: x_msg_data,
1771: '_PVT'
1772: );
1773: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1774: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1775: (
1776: l_api_name,
1777: G_PKG_NAME,
1778: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1778: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1774: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1775: (
1776: l_api_name,
1777: G_PKG_NAME,
1778: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1779: x_msg_count,
1780: x_msg_data,
1781: '_PVT'
1782: );

Line 1784: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1780: x_msg_data,
1781: '_PVT'
1782: );
1783: WHEN OTHERS THEN
1784: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1785: (
1786: l_api_name,
1787: G_PKG_NAME,
1788: 'OTHERS',

Line 1799: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1795: -- lock_row for:OKL_SIF_PRICE_PARMS_V --
1796: ----------------------------------------
1797: PROCEDURE lock_row(
1798: p_api_version IN NUMBER,
1799: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1800: x_return_status OUT NOCOPY VARCHAR2,
1801: x_msg_count OUT NOCOPY NUMBER,
1802: x_msg_data OUT NOCOPY VARCHAR2,
1803: p_sppv_rec IN sppv_rec_type) IS

Line 1806: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1802: x_msg_data OUT NOCOPY VARCHAR2,
1803: p_sppv_rec IN sppv_rec_type) IS
1804: l_api_version CONSTANT NUMBER := 1;
1805: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1806: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1807: l_spp_rec spp_rec_type;
1808: BEGIN
1809: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1810: G_PKG_NAME,

Line 1809: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1805: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1806: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1807: l_spp_rec spp_rec_type;
1808: BEGIN
1809: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1810: G_PKG_NAME,
1811: p_init_msg_list,
1812: l_api_version,
1813: p_api_version,

Line 1816: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1812: l_api_version,
1813: p_api_version,
1814: '_PVT',
1815: x_return_status);
1816: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1817: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1818: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1819: RAISE OKC_API.G_EXCEPTION_ERROR;
1820: END IF;

Line 1817: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1813: p_api_version,
1814: '_PVT',
1815: x_return_status);
1816: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1817: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1818: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1819: RAISE OKC_API.G_EXCEPTION_ERROR;
1820: END IF;
1821: --------------------------------------

Line 1818: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1814: '_PVT',
1815: x_return_status);
1816: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1817: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1818: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1819: RAISE OKC_API.G_EXCEPTION_ERROR;
1820: END IF;
1821: --------------------------------------
1822: -- Move VIEW record to "Child" records

Line 1819: RAISE OKC_API.G_EXCEPTION_ERROR;

1815: x_return_status);
1816: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1817: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1818: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1819: RAISE OKC_API.G_EXCEPTION_ERROR;
1820: END IF;
1821: --------------------------------------
1822: -- Move VIEW record to "Child" records
1823: --------------------------------------

Line 1835: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1831: x_msg_count,
1832: x_msg_data,
1833: l_spp_rec
1834: );
1835: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1836: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1837: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1838: RAISE OKC_API.G_EXCEPTION_ERROR;
1839: END IF;

Line 1836: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1832: x_msg_data,
1833: l_spp_rec
1834: );
1835: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1836: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1837: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1838: RAISE OKC_API.G_EXCEPTION_ERROR;
1839: END IF;
1840: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1837: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1833: l_spp_rec
1834: );
1835: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1836: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1837: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1838: RAISE OKC_API.G_EXCEPTION_ERROR;
1839: END IF;
1840: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1841: EXCEPTION

Line 1838: RAISE OKC_API.G_EXCEPTION_ERROR;

1834: );
1835: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1836: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1837: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1838: RAISE OKC_API.G_EXCEPTION_ERROR;
1839: END IF;
1840: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1841: EXCEPTION
1842: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1840: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1836: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1837: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1838: RAISE OKC_API.G_EXCEPTION_ERROR;
1839: END IF;
1840: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1841: EXCEPTION
1842: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1843: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1844: (

Line 1842: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1838: RAISE OKC_API.G_EXCEPTION_ERROR;
1839: END IF;
1840: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1841: EXCEPTION
1842: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1843: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1844: (
1845: l_api_name,
1846: G_PKG_NAME,

Line 1843: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1839: END IF;
1840: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1841: EXCEPTION
1842: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1843: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1844: (
1845: l_api_name,
1846: G_PKG_NAME,
1847: 'OKC_API.G_RET_STS_ERROR',

Line 1847: 'OKC_API.G_RET_STS_ERROR',

1843: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1844: (
1845: l_api_name,
1846: G_PKG_NAME,
1847: 'OKC_API.G_RET_STS_ERROR',
1848: x_msg_count,
1849: x_msg_data,
1850: '_PVT'
1851: );

Line 1852: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1848: x_msg_count,
1849: x_msg_data,
1850: '_PVT'
1851: );
1852: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1853: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1854: (
1855: l_api_name,
1856: G_PKG_NAME,

Line 1853: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1849: x_msg_data,
1850: '_PVT'
1851: );
1852: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1853: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1854: (
1855: l_api_name,
1856: G_PKG_NAME,
1857: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1857: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1853: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1854: (
1855: l_api_name,
1856: G_PKG_NAME,
1857: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1858: x_msg_count,
1859: x_msg_data,
1860: '_PVT'
1861: );

Line 1863: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1859: x_msg_data,
1860: '_PVT'
1861: );
1862: WHEN OTHERS THEN
1863: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1864: (
1865: l_api_name,
1866: G_PKG_NAME,
1867: 'OTHERS',

Line 1878: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1874: -- PL/SQL TBL lock_row for:SPPV_TBL --
1875: --------------------------------------
1876: PROCEDURE lock_row(
1877: p_api_version IN NUMBER,
1878: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1879: x_return_status OUT NOCOPY VARCHAR2,
1880: x_msg_count OUT NOCOPY NUMBER,
1881: x_msg_data OUT NOCOPY VARCHAR2,
1882: p_sppv_tbl IN sppv_tbl_type) IS

Line 1885: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1881: x_msg_data OUT NOCOPY VARCHAR2,
1882: p_sppv_tbl IN sppv_tbl_type) IS
1883: l_api_version CONSTANT NUMBER := 1;
1884: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1885: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1886: i NUMBER := 0;
1887: -- START change : mvasudev, 08/16/2001
1888: -- Adding OverAll Status Flag
1889: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 1889: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1885: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1886: i NUMBER := 0;
1887: -- START change : mvasudev, 08/16/2001
1888: -- Adding OverAll Status Flag
1889: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1890: -- END change : mvasudev
1891: BEGIN
1892: OKC_API.init_msg_list(p_init_msg_list);
1893: -- Make sure PL/SQL table has records in it before passing

Line 1892: OKC_API.init_msg_list(p_init_msg_list);

1888: -- Adding OverAll Status Flag
1889: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1890: -- END change : mvasudev
1891: BEGIN
1892: OKC_API.init_msg_list(p_init_msg_list);
1893: -- Make sure PL/SQL table has records in it before passing
1894: IF (p_sppv_tbl.COUNT > 0) THEN
1895: i := p_sppv_tbl.FIRST;
1896: LOOP

Line 1899: p_init_msg_list => OKC_API.G_FALSE,

1895: i := p_sppv_tbl.FIRST;
1896: LOOP
1897: lock_row (
1898: p_api_version => p_api_version,
1899: p_init_msg_list => OKC_API.G_FALSE,
1900: x_return_status => x_return_status,
1901: x_msg_count => x_msg_count,
1902: x_msg_data => x_msg_data,
1903: p_sppv_rec => p_sppv_tbl(i));

Line 1906: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1902: x_msg_data => x_msg_data,
1903: p_sppv_rec => p_sppv_tbl(i));
1904: -- START change : mvasudev, 08/16/2001
1905: -- store the highest degree of error
1906: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1907: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1908: l_overall_status := x_return_status;
1909: END IF;
1910: END IF;

Line 1907: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1903: p_sppv_rec => p_sppv_tbl(i));
1904: -- START change : mvasudev, 08/16/2001
1905: -- store the highest degree of error
1906: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1907: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1908: l_overall_status := x_return_status;
1909: END IF;
1910: END IF;
1911: -- END change : mvasudev

Line 1921: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1917: x_return_status := l_overall_status;
1918: -- END change : mvasudev
1919: END IF;
1920: EXCEPTION
1921: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1922: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1923: (
1924: l_api_name,
1925: G_PKG_NAME,

Line 1922: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1918: -- END change : mvasudev
1919: END IF;
1920: EXCEPTION
1921: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1922: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1923: (
1924: l_api_name,
1925: G_PKG_NAME,
1926: 'OKC_API.G_RET_STS_ERROR',

Line 1926: 'OKC_API.G_RET_STS_ERROR',

1922: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1923: (
1924: l_api_name,
1925: G_PKG_NAME,
1926: 'OKC_API.G_RET_STS_ERROR',
1927: x_msg_count,
1928: x_msg_data,
1929: '_PVT'
1930: );

Line 1931: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1927: x_msg_count,
1928: x_msg_data,
1929: '_PVT'
1930: );
1931: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1932: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1933: (
1934: l_api_name,
1935: G_PKG_NAME,

Line 1932: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1928: x_msg_data,
1929: '_PVT'
1930: );
1931: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1932: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1933: (
1934: l_api_name,
1935: G_PKG_NAME,
1936: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1936: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1932: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1933: (
1934: l_api_name,
1935: G_PKG_NAME,
1936: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1937: x_msg_count,
1938: x_msg_data,
1939: '_PVT'
1940: );

Line 1942: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1938: x_msg_data,
1939: '_PVT'
1940: );
1941: WHEN OTHERS THEN
1942: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1943: (
1944: l_api_name,
1945: G_PKG_NAME,
1946: 'OTHERS',

Line 1959: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1955: ----------------------------------------
1956: -- update_row for:OKL_SIF_PRICE_PARMS --
1957: ----------------------------------------
1958: PROCEDURE update_row(
1959: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1960: x_return_status OUT NOCOPY VARCHAR2,
1961: x_msg_count OUT NOCOPY NUMBER,
1962: x_msg_data OUT NOCOPY VARCHAR2,
1963: p_spp_rec IN spp_rec_type,

Line 1967: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1963: p_spp_rec IN spp_rec_type,
1964: x_spp_rec OUT NOCOPY spp_rec_type) IS
1965: l_api_version CONSTANT NUMBER := 1;
1966: l_api_name CONSTANT VARCHAR2(30) := 'PARMS_update_row';
1967: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1968: l_spp_rec spp_rec_type := p_spp_rec;
1969: l_def_spp_rec spp_rec_type;
1970: l_row_notfound BOOLEAN := TRUE;
1971: ----------------------------------

Line 1980: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1976: x_spp_rec OUT NOCOPY spp_rec_type
1977: ) RETURN VARCHAR2 IS
1978: l_spp_rec spp_rec_type;
1979: l_row_notfound BOOLEAN := TRUE;
1980: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1981: BEGIN
1982: x_spp_rec := p_spp_rec;
1983: -- Get current database values
1984: l_spp_rec := get_rec(p_spp_rec, l_row_notfound);

Line 1986: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1982: x_spp_rec := p_spp_rec;
1983: -- Get current database values
1984: l_spp_rec := get_rec(p_spp_rec, l_row_notfound);
1985: IF (l_row_notfound) THEN
1986: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1987: END IF;
1988: IF (x_spp_rec.id = OKC_API.G_MISS_NUM)
1989: THEN
1990: x_spp_rec.id := l_spp_rec.id;

Line 1988: IF (x_spp_rec.id = OKC_API.G_MISS_NUM)

1984: l_spp_rec := get_rec(p_spp_rec, l_row_notfound);
1985: IF (l_row_notfound) THEN
1986: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1987: END IF;
1988: IF (x_spp_rec.id = OKC_API.G_MISS_NUM)
1989: THEN
1990: x_spp_rec.id := l_spp_rec.id;
1991: END IF;
1992: IF (x_spp_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1992: IF (x_spp_rec.object_version_number = OKC_API.G_MISS_NUM)

1988: IF (x_spp_rec.id = OKC_API.G_MISS_NUM)
1989: THEN
1990: x_spp_rec.id := l_spp_rec.id;
1991: END IF;
1992: IF (x_spp_rec.object_version_number = OKC_API.G_MISS_NUM)
1993: THEN
1994: x_spp_rec.object_version_number := l_spp_rec.object_version_number;
1995: END IF;
1996: IF (x_spp_rec.name = OKC_API.G_MISS_CHAR)

Line 1996: IF (x_spp_rec.name = OKC_API.G_MISS_CHAR)

1992: IF (x_spp_rec.object_version_number = OKC_API.G_MISS_NUM)
1993: THEN
1994: x_spp_rec.object_version_number := l_spp_rec.object_version_number;
1995: END IF;
1996: IF (x_spp_rec.name = OKC_API.G_MISS_CHAR)
1997: THEN
1998: x_spp_rec.name := l_spp_rec.name;
1999: END IF;
2000: IF (x_spp_rec.version = OKC_API.G_MISS_CHAR)

Line 2000: IF (x_spp_rec.version = OKC_API.G_MISS_CHAR)

1996: IF (x_spp_rec.name = OKC_API.G_MISS_CHAR)
1997: THEN
1998: x_spp_rec.name := l_spp_rec.name;
1999: END IF;
2000: IF (x_spp_rec.version = OKC_API.G_MISS_CHAR)
2001: THEN
2002: x_spp_rec.version := l_spp_rec.version;
2003: END IF;
2004: IF (x_spp_rec.date_start = OKC_API.G_MISS_DATE)

Line 2004: IF (x_spp_rec.date_start = OKC_API.G_MISS_DATE)

2000: IF (x_spp_rec.version = OKC_API.G_MISS_CHAR)
2001: THEN
2002: x_spp_rec.version := l_spp_rec.version;
2003: END IF;
2004: IF (x_spp_rec.date_start = OKC_API.G_MISS_DATE)
2005: THEN
2006: x_spp_rec.date_start := l_spp_rec.date_start;
2007: END IF;
2008: IF (x_spp_rec.date_end = OKC_API.G_MISS_DATE)

Line 2008: IF (x_spp_rec.date_end = OKC_API.G_MISS_DATE)

2004: IF (x_spp_rec.date_start = OKC_API.G_MISS_DATE)
2005: THEN
2006: x_spp_rec.date_start := l_spp_rec.date_start;
2007: END IF;
2008: IF (x_spp_rec.date_end = OKC_API.G_MISS_DATE)
2009: THEN
2010: x_spp_rec.date_end := l_spp_rec.date_end;
2011: END IF;
2012: IF (x_spp_rec.description = OKC_API.G_MISS_CHAR)

Line 2012: IF (x_spp_rec.description = OKC_API.G_MISS_CHAR)

2008: IF (x_spp_rec.date_end = OKC_API.G_MISS_DATE)
2009: THEN
2010: x_spp_rec.date_end := l_spp_rec.date_end;
2011: END IF;
2012: IF (x_spp_rec.description = OKC_API.G_MISS_CHAR)
2013: THEN
2014: x_spp_rec.description := l_spp_rec.description;
2015: END IF;
2016: IF (x_spp_rec.sps_code = OKC_API.G_MISS_CHAR)

Line 2016: IF (x_spp_rec.sps_code = OKC_API.G_MISS_CHAR)

2012: IF (x_spp_rec.description = OKC_API.G_MISS_CHAR)
2013: THEN
2014: x_spp_rec.description := l_spp_rec.description;
2015: END IF;
2016: IF (x_spp_rec.sps_code = OKC_API.G_MISS_CHAR)
2017: THEN
2018: x_spp_rec.sps_code := l_spp_rec.sps_code;
2019: END IF;
2020: IF (x_spp_rec.dyp_code = OKC_API.G_MISS_CHAR)

Line 2020: IF (x_spp_rec.dyp_code = OKC_API.G_MISS_CHAR)

2016: IF (x_spp_rec.sps_code = OKC_API.G_MISS_CHAR)
2017: THEN
2018: x_spp_rec.sps_code := l_spp_rec.sps_code;
2019: END IF;
2020: IF (x_spp_rec.dyp_code = OKC_API.G_MISS_CHAR)
2021: THEN
2022: x_spp_rec.dyp_code := l_spp_rec.dyp_code;
2023: END IF;
2024: IF (x_spp_rec.array_yn = OKC_API.G_MISS_CHAR)

Line 2024: IF (x_spp_rec.array_yn = OKC_API.G_MISS_CHAR)

2020: IF (x_spp_rec.dyp_code = OKC_API.G_MISS_CHAR)
2021: THEN
2022: x_spp_rec.dyp_code := l_spp_rec.dyp_code;
2023: END IF;
2024: IF (x_spp_rec.array_yn = OKC_API.G_MISS_CHAR)
2025: THEN
2026: x_spp_rec.array_yn := l_spp_rec.array_yn;
2027: END IF;
2028: IF (x_spp_rec.xml_tag = OKC_API.G_MISS_CHAR)

Line 2028: IF (x_spp_rec.xml_tag = OKC_API.G_MISS_CHAR)

2024: IF (x_spp_rec.array_yn = OKC_API.G_MISS_CHAR)
2025: THEN
2026: x_spp_rec.array_yn := l_spp_rec.array_yn;
2027: END IF;
2028: IF (x_spp_rec.xml_tag = OKC_API.G_MISS_CHAR)
2029: THEN
2030: x_spp_rec.xml_tag := l_spp_rec.xml_tag;
2031: END IF;
2032: IF (x_spp_rec.attribute_category = OKC_API.G_MISS_CHAR)

Line 2032: IF (x_spp_rec.attribute_category = OKC_API.G_MISS_CHAR)

2028: IF (x_spp_rec.xml_tag = OKC_API.G_MISS_CHAR)
2029: THEN
2030: x_spp_rec.xml_tag := l_spp_rec.xml_tag;
2031: END IF;
2032: IF (x_spp_rec.attribute_category = OKC_API.G_MISS_CHAR)
2033: THEN
2034: x_spp_rec.attribute_category := l_spp_rec.attribute_category;
2035: END IF;
2036: IF (x_spp_rec.attribute1 = OKC_API.G_MISS_CHAR)

Line 2036: IF (x_spp_rec.attribute1 = OKC_API.G_MISS_CHAR)

2032: IF (x_spp_rec.attribute_category = OKC_API.G_MISS_CHAR)
2033: THEN
2034: x_spp_rec.attribute_category := l_spp_rec.attribute_category;
2035: END IF;
2036: IF (x_spp_rec.attribute1 = OKC_API.G_MISS_CHAR)
2037: THEN
2038: x_spp_rec.attribute1 := l_spp_rec.attribute1;
2039: END IF;
2040: IF (x_spp_rec.attribute2 = OKC_API.G_MISS_CHAR)

Line 2040: IF (x_spp_rec.attribute2 = OKC_API.G_MISS_CHAR)

2036: IF (x_spp_rec.attribute1 = OKC_API.G_MISS_CHAR)
2037: THEN
2038: x_spp_rec.attribute1 := l_spp_rec.attribute1;
2039: END IF;
2040: IF (x_spp_rec.attribute2 = OKC_API.G_MISS_CHAR)
2041: THEN
2042: x_spp_rec.attribute2 := l_spp_rec.attribute2;
2043: END IF;
2044: IF (x_spp_rec.attribute3 = OKC_API.G_MISS_CHAR)

Line 2044: IF (x_spp_rec.attribute3 = OKC_API.G_MISS_CHAR)

2040: IF (x_spp_rec.attribute2 = OKC_API.G_MISS_CHAR)
2041: THEN
2042: x_spp_rec.attribute2 := l_spp_rec.attribute2;
2043: END IF;
2044: IF (x_spp_rec.attribute3 = OKC_API.G_MISS_CHAR)
2045: THEN
2046: x_spp_rec.attribute3 := l_spp_rec.attribute3;
2047: END IF;
2048: IF (x_spp_rec.attribute4 = OKC_API.G_MISS_CHAR)

Line 2048: IF (x_spp_rec.attribute4 = OKC_API.G_MISS_CHAR)

2044: IF (x_spp_rec.attribute3 = OKC_API.G_MISS_CHAR)
2045: THEN
2046: x_spp_rec.attribute3 := l_spp_rec.attribute3;
2047: END IF;
2048: IF (x_spp_rec.attribute4 = OKC_API.G_MISS_CHAR)
2049: THEN
2050: x_spp_rec.attribute4 := l_spp_rec.attribute4;
2051: END IF;
2052: IF (x_spp_rec.attribute5 = OKC_API.G_MISS_CHAR)

Line 2052: IF (x_spp_rec.attribute5 = OKC_API.G_MISS_CHAR)

2048: IF (x_spp_rec.attribute4 = OKC_API.G_MISS_CHAR)
2049: THEN
2050: x_spp_rec.attribute4 := l_spp_rec.attribute4;
2051: END IF;
2052: IF (x_spp_rec.attribute5 = OKC_API.G_MISS_CHAR)
2053: THEN
2054: x_spp_rec.attribute5 := l_spp_rec.attribute5;
2055: END IF;
2056: IF (x_spp_rec.attribute6 = OKC_API.G_MISS_CHAR)

Line 2056: IF (x_spp_rec.attribute6 = OKC_API.G_MISS_CHAR)

2052: IF (x_spp_rec.attribute5 = OKC_API.G_MISS_CHAR)
2053: THEN
2054: x_spp_rec.attribute5 := l_spp_rec.attribute5;
2055: END IF;
2056: IF (x_spp_rec.attribute6 = OKC_API.G_MISS_CHAR)
2057: THEN
2058: x_spp_rec.attribute6 := l_spp_rec.attribute6;
2059: END IF;
2060: IF (x_spp_rec.attribute7 = OKC_API.G_MISS_CHAR)

Line 2060: IF (x_spp_rec.attribute7 = OKC_API.G_MISS_CHAR)

2056: IF (x_spp_rec.attribute6 = OKC_API.G_MISS_CHAR)
2057: THEN
2058: x_spp_rec.attribute6 := l_spp_rec.attribute6;
2059: END IF;
2060: IF (x_spp_rec.attribute7 = OKC_API.G_MISS_CHAR)
2061: THEN
2062: x_spp_rec.attribute7 := l_spp_rec.attribute7;
2063: END IF;
2064: IF (x_spp_rec.attribute8 = OKC_API.G_MISS_CHAR)

Line 2064: IF (x_spp_rec.attribute8 = OKC_API.G_MISS_CHAR)

2060: IF (x_spp_rec.attribute7 = OKC_API.G_MISS_CHAR)
2061: THEN
2062: x_spp_rec.attribute7 := l_spp_rec.attribute7;
2063: END IF;
2064: IF (x_spp_rec.attribute8 = OKC_API.G_MISS_CHAR)
2065: THEN
2066: x_spp_rec.attribute8 := l_spp_rec.attribute8;
2067: END IF;
2068: IF (x_spp_rec.attribute9 = OKC_API.G_MISS_CHAR)

Line 2068: IF (x_spp_rec.attribute9 = OKC_API.G_MISS_CHAR)

2064: IF (x_spp_rec.attribute8 = OKC_API.G_MISS_CHAR)
2065: THEN
2066: x_spp_rec.attribute8 := l_spp_rec.attribute8;
2067: END IF;
2068: IF (x_spp_rec.attribute9 = OKC_API.G_MISS_CHAR)
2069: THEN
2070: x_spp_rec.attribute9 := l_spp_rec.attribute9;
2071: END IF;
2072: IF (x_spp_rec.attribute10 = OKC_API.G_MISS_CHAR)

Line 2072: IF (x_spp_rec.attribute10 = OKC_API.G_MISS_CHAR)

2068: IF (x_spp_rec.attribute9 = OKC_API.G_MISS_CHAR)
2069: THEN
2070: x_spp_rec.attribute9 := l_spp_rec.attribute9;
2071: END IF;
2072: IF (x_spp_rec.attribute10 = OKC_API.G_MISS_CHAR)
2073: THEN
2074: x_spp_rec.attribute10 := l_spp_rec.attribute10;
2075: END IF;
2076: IF (x_spp_rec.attribute11 = OKC_API.G_MISS_CHAR)

Line 2076: IF (x_spp_rec.attribute11 = OKC_API.G_MISS_CHAR)

2072: IF (x_spp_rec.attribute10 = OKC_API.G_MISS_CHAR)
2073: THEN
2074: x_spp_rec.attribute10 := l_spp_rec.attribute10;
2075: END IF;
2076: IF (x_spp_rec.attribute11 = OKC_API.G_MISS_CHAR)
2077: THEN
2078: x_spp_rec.attribute11 := l_spp_rec.attribute11;
2079: END IF;
2080: IF (x_spp_rec.attribute12 = OKC_API.G_MISS_CHAR)

Line 2080: IF (x_spp_rec.attribute12 = OKC_API.G_MISS_CHAR)

2076: IF (x_spp_rec.attribute11 = OKC_API.G_MISS_CHAR)
2077: THEN
2078: x_spp_rec.attribute11 := l_spp_rec.attribute11;
2079: END IF;
2080: IF (x_spp_rec.attribute12 = OKC_API.G_MISS_CHAR)
2081: THEN
2082: x_spp_rec.attribute12 := l_spp_rec.attribute12;
2083: END IF;
2084: IF (x_spp_rec.attribute13 = OKC_API.G_MISS_CHAR)

Line 2084: IF (x_spp_rec.attribute13 = OKC_API.G_MISS_CHAR)

2080: IF (x_spp_rec.attribute12 = OKC_API.G_MISS_CHAR)
2081: THEN
2082: x_spp_rec.attribute12 := l_spp_rec.attribute12;
2083: END IF;
2084: IF (x_spp_rec.attribute13 = OKC_API.G_MISS_CHAR)
2085: THEN
2086: x_spp_rec.attribute13 := l_spp_rec.attribute13;
2087: END IF;
2088: IF (x_spp_rec.attribute14 = OKC_API.G_MISS_CHAR)

Line 2088: IF (x_spp_rec.attribute14 = OKC_API.G_MISS_CHAR)

2084: IF (x_spp_rec.attribute13 = OKC_API.G_MISS_CHAR)
2085: THEN
2086: x_spp_rec.attribute13 := l_spp_rec.attribute13;
2087: END IF;
2088: IF (x_spp_rec.attribute14 = OKC_API.G_MISS_CHAR)
2089: THEN
2090: x_spp_rec.attribute14 := l_spp_rec.attribute14;
2091: END IF;
2092: IF (x_spp_rec.attribute15 = OKC_API.G_MISS_CHAR)

Line 2092: IF (x_spp_rec.attribute15 = OKC_API.G_MISS_CHAR)

2088: IF (x_spp_rec.attribute14 = OKC_API.G_MISS_CHAR)
2089: THEN
2090: x_spp_rec.attribute14 := l_spp_rec.attribute14;
2091: END IF;
2092: IF (x_spp_rec.attribute15 = OKC_API.G_MISS_CHAR)
2093: THEN
2094: x_spp_rec.attribute15 := l_spp_rec.attribute15;
2095: END IF;
2096: IF (x_spp_rec.created_by = OKC_API.G_MISS_NUM)

Line 2096: IF (x_spp_rec.created_by = OKC_API.G_MISS_NUM)

2092: IF (x_spp_rec.attribute15 = OKC_API.G_MISS_CHAR)
2093: THEN
2094: x_spp_rec.attribute15 := l_spp_rec.attribute15;
2095: END IF;
2096: IF (x_spp_rec.created_by = OKC_API.G_MISS_NUM)
2097: THEN
2098: x_spp_rec.created_by := l_spp_rec.created_by;
2099: END IF;
2100: IF (x_spp_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2100: IF (x_spp_rec.last_updated_by = OKC_API.G_MISS_NUM)

2096: IF (x_spp_rec.created_by = OKC_API.G_MISS_NUM)
2097: THEN
2098: x_spp_rec.created_by := l_spp_rec.created_by;
2099: END IF;
2100: IF (x_spp_rec.last_updated_by = OKC_API.G_MISS_NUM)
2101: THEN
2102: x_spp_rec.last_updated_by := l_spp_rec.last_updated_by;
2103: END IF;
2104: IF (x_spp_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2104: IF (x_spp_rec.creation_date = OKC_API.G_MISS_DATE)

2100: IF (x_spp_rec.last_updated_by = OKC_API.G_MISS_NUM)
2101: THEN
2102: x_spp_rec.last_updated_by := l_spp_rec.last_updated_by;
2103: END IF;
2104: IF (x_spp_rec.creation_date = OKC_API.G_MISS_DATE)
2105: THEN
2106: x_spp_rec.creation_date := l_spp_rec.creation_date;
2107: END IF;
2108: IF (x_spp_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2108: IF (x_spp_rec.last_update_date = OKC_API.G_MISS_DATE)

2104: IF (x_spp_rec.creation_date = OKC_API.G_MISS_DATE)
2105: THEN
2106: x_spp_rec.creation_date := l_spp_rec.creation_date;
2107: END IF;
2108: IF (x_spp_rec.last_update_date = OKC_API.G_MISS_DATE)
2109: THEN
2110: x_spp_rec.last_update_date := l_spp_rec.last_update_date;
2111: END IF;
2112: IF (x_spp_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2112: IF (x_spp_rec.last_update_login = OKC_API.G_MISS_NUM)

2108: IF (x_spp_rec.last_update_date = OKC_API.G_MISS_DATE)
2109: THEN
2110: x_spp_rec.last_update_date := l_spp_rec.last_update_date;
2111: END IF;
2112: IF (x_spp_rec.last_update_login = OKC_API.G_MISS_NUM)
2113: THEN
2114: x_spp_rec.last_update_login := l_spp_rec.last_update_login;
2115: END IF;
2116: RETURN(l_return_status);

Line 2125: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2121: FUNCTION Set_Attributes (
2122: p_spp_rec IN spp_rec_type,
2123: x_spp_rec OUT NOCOPY spp_rec_type
2124: ) RETURN VARCHAR2 IS
2125: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2126: BEGIN
2127: x_spp_rec := p_spp_rec;
2128: RETURN(l_return_status);
2129: END Set_Attributes;

Line 2131: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

2127: x_spp_rec := p_spp_rec;
2128: RETURN(l_return_status);
2129: END Set_Attributes;
2130: BEGIN
2131: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2132: p_init_msg_list,
2133: '_PVT',
2134: x_return_status);
2135: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2135: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2131: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2132: p_init_msg_list,
2133: '_PVT',
2134: x_return_status);
2135: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2136: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2137: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2138: RAISE OKC_API.G_EXCEPTION_ERROR;
2139: END IF;

Line 2136: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2132: p_init_msg_list,
2133: '_PVT',
2134: x_return_status);
2135: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2136: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2137: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2138: RAISE OKC_API.G_EXCEPTION_ERROR;
2139: END IF;
2140: --- Setting item attributes

Line 2137: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2133: '_PVT',
2134: x_return_status);
2135: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2136: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2137: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2138: RAISE OKC_API.G_EXCEPTION_ERROR;
2139: END IF;
2140: --- Setting item attributes
2141: l_return_status := Set_Attributes(

Line 2138: RAISE OKC_API.G_EXCEPTION_ERROR;

2134: x_return_status);
2135: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2136: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2137: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2138: RAISE OKC_API.G_EXCEPTION_ERROR;
2139: END IF;
2140: --- Setting item attributes
2141: l_return_status := Set_Attributes(
2142: p_spp_rec, -- IN

Line 2145: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2141: l_return_status := Set_Attributes(
2142: p_spp_rec, -- IN
2143: l_spp_rec); -- OUT
2144: --- If any errors happen abort API
2145: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2146: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2147: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2148: RAISE OKC_API.G_EXCEPTION_ERROR;
2149: END IF;

Line 2146: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2142: p_spp_rec, -- IN
2143: l_spp_rec); -- OUT
2144: --- If any errors happen abort API
2145: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2146: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2147: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2148: RAISE OKC_API.G_EXCEPTION_ERROR;
2149: END IF;
2150: l_return_status := populate_new_record(l_spp_rec, l_def_spp_rec);

Line 2147: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2143: l_spp_rec); -- OUT
2144: --- If any errors happen abort API
2145: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2146: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2147: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2148: RAISE OKC_API.G_EXCEPTION_ERROR;
2149: END IF;
2150: l_return_status := populate_new_record(l_spp_rec, l_def_spp_rec);
2151: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2148: RAISE OKC_API.G_EXCEPTION_ERROR;

2144: --- If any errors happen abort API
2145: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2146: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2147: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2148: RAISE OKC_API.G_EXCEPTION_ERROR;
2149: END IF;
2150: l_return_status := populate_new_record(l_spp_rec, l_def_spp_rec);
2151: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2152: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2151: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2147: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2148: RAISE OKC_API.G_EXCEPTION_ERROR;
2149: END IF;
2150: l_return_status := populate_new_record(l_spp_rec, l_def_spp_rec);
2151: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2152: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2153: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2154: RAISE OKC_API.G_EXCEPTION_ERROR;
2155: END IF;

Line 2152: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2148: RAISE OKC_API.G_EXCEPTION_ERROR;
2149: END IF;
2150: l_return_status := populate_new_record(l_spp_rec, l_def_spp_rec);
2151: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2152: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2153: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2154: RAISE OKC_API.G_EXCEPTION_ERROR;
2155: END IF;
2156: UPDATE OKL_SIF_PRICE_PARMS

Line 2153: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2149: END IF;
2150: l_return_status := populate_new_record(l_spp_rec, l_def_spp_rec);
2151: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2152: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2153: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2154: RAISE OKC_API.G_EXCEPTION_ERROR;
2155: END IF;
2156: UPDATE OKL_SIF_PRICE_PARMS
2157: SET OBJECT_VERSION_NUMBER = l_def_spp_rec.object_version_number,

Line 2154: RAISE OKC_API.G_EXCEPTION_ERROR;

2150: l_return_status := populate_new_record(l_spp_rec, l_def_spp_rec);
2151: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2152: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2153: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2154: RAISE OKC_API.G_EXCEPTION_ERROR;
2155: END IF;
2156: UPDATE OKL_SIF_PRICE_PARMS
2157: SET OBJECT_VERSION_NUMBER = l_def_spp_rec.object_version_number,
2158: NAME = l_def_spp_rec.name,

Line 2190: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2186: LAST_UPDATE_DATE = l_def_spp_rec.last_update_date,
2187: LAST_UPDATE_LOGIN = l_def_spp_rec.last_update_login
2188: WHERE ID = l_def_spp_rec.id;
2189: x_spp_rec := l_def_spp_rec;
2190: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2191: EXCEPTION
2192: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2193: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2194: (

Line 2192: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2188: WHERE ID = l_def_spp_rec.id;
2189: x_spp_rec := l_def_spp_rec;
2190: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2191: EXCEPTION
2192: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2193: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2194: (
2195: l_api_name,
2196: G_PKG_NAME,

Line 2193: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2189: x_spp_rec := l_def_spp_rec;
2190: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2191: EXCEPTION
2192: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2193: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2194: (
2195: l_api_name,
2196: G_PKG_NAME,
2197: 'OKC_API.G_RET_STS_ERROR',

Line 2197: 'OKC_API.G_RET_STS_ERROR',

2193: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2194: (
2195: l_api_name,
2196: G_PKG_NAME,
2197: 'OKC_API.G_RET_STS_ERROR',
2198: x_msg_count,
2199: x_msg_data,
2200: '_PVT'
2201: );

Line 2202: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2198: x_msg_count,
2199: x_msg_data,
2200: '_PVT'
2201: );
2202: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2203: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2204: (
2205: l_api_name,
2206: G_PKG_NAME,

Line 2203: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2199: x_msg_data,
2200: '_PVT'
2201: );
2202: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2203: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2204: (
2205: l_api_name,
2206: G_PKG_NAME,
2207: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2207: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2203: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2204: (
2205: l_api_name,
2206: G_PKG_NAME,
2207: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2208: x_msg_count,
2209: x_msg_data,
2210: '_PVT'
2211: );

Line 2213: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2209: x_msg_data,
2210: '_PVT'
2211: );
2212: WHEN OTHERS THEN
2213: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2214: (
2215: l_api_name,
2216: G_PKG_NAME,
2217: 'OTHERS',

Line 2228: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2224: -- update_row for:OKL_SIF_PRICE_PARMS_V --
2225: ------------------------------------------
2226: PROCEDURE update_row(
2227: p_api_version IN NUMBER,
2228: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2229: x_return_status OUT NOCOPY VARCHAR2,
2230: x_msg_count OUT NOCOPY NUMBER,
2231: x_msg_data OUT NOCOPY VARCHAR2,
2232: p_sppv_rec IN sppv_rec_type,

Line 2236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2232: p_sppv_rec IN sppv_rec_type,
2233: x_sppv_rec OUT NOCOPY sppv_rec_type) IS
2234: l_api_version CONSTANT NUMBER := 1;
2235: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2236: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2237: l_sppv_rec sppv_rec_type := p_sppv_rec;
2238: l_def_sppv_rec sppv_rec_type;
2239: l_spp_rec spp_rec_type;
2240: lx_spp_rec spp_rec_type;

Line 2263: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2259: x_sppv_rec OUT NOCOPY sppv_rec_type
2260: ) RETURN VARCHAR2 IS
2261: l_sppv_rec sppv_rec_type;
2262: l_row_notfound BOOLEAN := TRUE;
2263: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2264: BEGIN
2265: x_sppv_rec := p_sppv_rec;
2266: -- Get current database values
2267: l_sppv_rec := get_rec(p_sppv_rec, l_row_notfound);

Line 2269: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

2265: x_sppv_rec := p_sppv_rec;
2266: -- Get current database values
2267: l_sppv_rec := get_rec(p_sppv_rec, l_row_notfound);
2268: IF (l_row_notfound) THEN
2269: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2270: END IF;
2271: IF (x_sppv_rec.id = OKC_API.G_MISS_NUM)
2272: THEN
2273: x_sppv_rec.id := l_sppv_rec.id;

Line 2271: IF (x_sppv_rec.id = OKC_API.G_MISS_NUM)

2267: l_sppv_rec := get_rec(p_sppv_rec, l_row_notfound);
2268: IF (l_row_notfound) THEN
2269: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2270: END IF;
2271: IF (x_sppv_rec.id = OKC_API.G_MISS_NUM)
2272: THEN
2273: x_sppv_rec.id := l_sppv_rec.id;
2274: END IF;
2275: IF (x_sppv_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 2275: IF (x_sppv_rec.object_version_number = OKC_API.G_MISS_NUM)

2271: IF (x_sppv_rec.id = OKC_API.G_MISS_NUM)
2272: THEN
2273: x_sppv_rec.id := l_sppv_rec.id;
2274: END IF;
2275: IF (x_sppv_rec.object_version_number = OKC_API.G_MISS_NUM)
2276: THEN
2277: x_sppv_rec.object_version_number := l_sppv_rec.object_version_number;
2278: END IF;
2279: IF (x_sppv_rec.name = OKC_API.G_MISS_CHAR)

Line 2279: IF (x_sppv_rec.name = OKC_API.G_MISS_CHAR)

2275: IF (x_sppv_rec.object_version_number = OKC_API.G_MISS_NUM)
2276: THEN
2277: x_sppv_rec.object_version_number := l_sppv_rec.object_version_number;
2278: END IF;
2279: IF (x_sppv_rec.name = OKC_API.G_MISS_CHAR)
2280: THEN
2281: x_sppv_rec.name := l_sppv_rec.name;
2282: END IF;
2283: IF (x_sppv_rec.version = OKC_API.G_MISS_CHAR)

Line 2283: IF (x_sppv_rec.version = OKC_API.G_MISS_CHAR)

2279: IF (x_sppv_rec.name = OKC_API.G_MISS_CHAR)
2280: THEN
2281: x_sppv_rec.name := l_sppv_rec.name;
2282: END IF;
2283: IF (x_sppv_rec.version = OKC_API.G_MISS_CHAR)
2284: THEN
2285: x_sppv_rec.version := l_sppv_rec.version;
2286: END IF;
2287: IF (x_sppv_rec.date_start = OKC_API.G_MISS_DATE)

Line 2287: IF (x_sppv_rec.date_start = OKC_API.G_MISS_DATE)

2283: IF (x_sppv_rec.version = OKC_API.G_MISS_CHAR)
2284: THEN
2285: x_sppv_rec.version := l_sppv_rec.version;
2286: END IF;
2287: IF (x_sppv_rec.date_start = OKC_API.G_MISS_DATE)
2288: THEN
2289: x_sppv_rec.date_start := l_sppv_rec.date_start;
2290: END IF;
2291: IF (x_sppv_rec.date_end = OKC_API.G_MISS_DATE)

Line 2291: IF (x_sppv_rec.date_end = OKC_API.G_MISS_DATE)

2287: IF (x_sppv_rec.date_start = OKC_API.G_MISS_DATE)
2288: THEN
2289: x_sppv_rec.date_start := l_sppv_rec.date_start;
2290: END IF;
2291: IF (x_sppv_rec.date_end = OKC_API.G_MISS_DATE)
2292: THEN
2293: x_sppv_rec.date_end := l_sppv_rec.date_end;
2294: END IF;
2295: IF (x_sppv_rec.description = OKC_API.G_MISS_CHAR)

Line 2295: IF (x_sppv_rec.description = OKC_API.G_MISS_CHAR)

2291: IF (x_sppv_rec.date_end = OKC_API.G_MISS_DATE)
2292: THEN
2293: x_sppv_rec.date_end := l_sppv_rec.date_end;
2294: END IF;
2295: IF (x_sppv_rec.description = OKC_API.G_MISS_CHAR)
2296: THEN
2297: x_sppv_rec.description := l_sppv_rec.description;
2298: END IF;
2299: IF (x_sppv_rec.sps_code = OKC_API.G_MISS_CHAR)

Line 2299: IF (x_sppv_rec.sps_code = OKC_API.G_MISS_CHAR)

2295: IF (x_sppv_rec.description = OKC_API.G_MISS_CHAR)
2296: THEN
2297: x_sppv_rec.description := l_sppv_rec.description;
2298: END IF;
2299: IF (x_sppv_rec.sps_code = OKC_API.G_MISS_CHAR)
2300: THEN
2301: x_sppv_rec.sps_code := l_sppv_rec.sps_code;
2302: END IF;
2303: IF (x_sppv_rec.dyp_code = OKC_API.G_MISS_CHAR)

Line 2303: IF (x_sppv_rec.dyp_code = OKC_API.G_MISS_CHAR)

2299: IF (x_sppv_rec.sps_code = OKC_API.G_MISS_CHAR)
2300: THEN
2301: x_sppv_rec.sps_code := l_sppv_rec.sps_code;
2302: END IF;
2303: IF (x_sppv_rec.dyp_code = OKC_API.G_MISS_CHAR)
2304: THEN
2305: x_sppv_rec.dyp_code := l_sppv_rec.dyp_code;
2306: END IF;
2307: IF (x_sppv_rec.array_yn = OKC_API.G_MISS_CHAR)

Line 2307: IF (x_sppv_rec.array_yn = OKC_API.G_MISS_CHAR)

2303: IF (x_sppv_rec.dyp_code = OKC_API.G_MISS_CHAR)
2304: THEN
2305: x_sppv_rec.dyp_code := l_sppv_rec.dyp_code;
2306: END IF;
2307: IF (x_sppv_rec.array_yn = OKC_API.G_MISS_CHAR)
2308: THEN
2309: x_sppv_rec.array_yn := l_sppv_rec.array_yn;
2310: END IF;
2311: IF (x_sppv_rec.xml_tag = OKC_API.G_MISS_CHAR)

Line 2311: IF (x_sppv_rec.xml_tag = OKC_API.G_MISS_CHAR)

2307: IF (x_sppv_rec.array_yn = OKC_API.G_MISS_CHAR)
2308: THEN
2309: x_sppv_rec.array_yn := l_sppv_rec.array_yn;
2310: END IF;
2311: IF (x_sppv_rec.xml_tag = OKC_API.G_MISS_CHAR)
2312: THEN
2313: x_sppv_rec.xml_tag := l_sppv_rec.xml_tag;
2314: END IF;
2315: IF (x_sppv_rec.attribute_category = OKC_API.G_MISS_CHAR)

Line 2315: IF (x_sppv_rec.attribute_category = OKC_API.G_MISS_CHAR)

2311: IF (x_sppv_rec.xml_tag = OKC_API.G_MISS_CHAR)
2312: THEN
2313: x_sppv_rec.xml_tag := l_sppv_rec.xml_tag;
2314: END IF;
2315: IF (x_sppv_rec.attribute_category = OKC_API.G_MISS_CHAR)
2316: THEN
2317: x_sppv_rec.attribute_category := l_sppv_rec.attribute_category;
2318: END IF;
2319: IF (x_sppv_rec.attribute1 = OKC_API.G_MISS_CHAR)

Line 2319: IF (x_sppv_rec.attribute1 = OKC_API.G_MISS_CHAR)

2315: IF (x_sppv_rec.attribute_category = OKC_API.G_MISS_CHAR)
2316: THEN
2317: x_sppv_rec.attribute_category := l_sppv_rec.attribute_category;
2318: END IF;
2319: IF (x_sppv_rec.attribute1 = OKC_API.G_MISS_CHAR)
2320: THEN
2321: x_sppv_rec.attribute1 := l_sppv_rec.attribute1;
2322: END IF;
2323: IF (x_sppv_rec.attribute2 = OKC_API.G_MISS_CHAR)

Line 2323: IF (x_sppv_rec.attribute2 = OKC_API.G_MISS_CHAR)

2319: IF (x_sppv_rec.attribute1 = OKC_API.G_MISS_CHAR)
2320: THEN
2321: x_sppv_rec.attribute1 := l_sppv_rec.attribute1;
2322: END IF;
2323: IF (x_sppv_rec.attribute2 = OKC_API.G_MISS_CHAR)
2324: THEN
2325: x_sppv_rec.attribute2 := l_sppv_rec.attribute2;
2326: END IF;
2327: IF (x_sppv_rec.attribute3 = OKC_API.G_MISS_CHAR)

Line 2327: IF (x_sppv_rec.attribute3 = OKC_API.G_MISS_CHAR)

2323: IF (x_sppv_rec.attribute2 = OKC_API.G_MISS_CHAR)
2324: THEN
2325: x_sppv_rec.attribute2 := l_sppv_rec.attribute2;
2326: END IF;
2327: IF (x_sppv_rec.attribute3 = OKC_API.G_MISS_CHAR)
2328: THEN
2329: x_sppv_rec.attribute3 := l_sppv_rec.attribute3;
2330: END IF;
2331: IF (x_sppv_rec.attribute4 = OKC_API.G_MISS_CHAR)

Line 2331: IF (x_sppv_rec.attribute4 = OKC_API.G_MISS_CHAR)

2327: IF (x_sppv_rec.attribute3 = OKC_API.G_MISS_CHAR)
2328: THEN
2329: x_sppv_rec.attribute3 := l_sppv_rec.attribute3;
2330: END IF;
2331: IF (x_sppv_rec.attribute4 = OKC_API.G_MISS_CHAR)
2332: THEN
2333: x_sppv_rec.attribute4 := l_sppv_rec.attribute4;
2334: END IF;
2335: IF (x_sppv_rec.attribute5 = OKC_API.G_MISS_CHAR)

Line 2335: IF (x_sppv_rec.attribute5 = OKC_API.G_MISS_CHAR)

2331: IF (x_sppv_rec.attribute4 = OKC_API.G_MISS_CHAR)
2332: THEN
2333: x_sppv_rec.attribute4 := l_sppv_rec.attribute4;
2334: END IF;
2335: IF (x_sppv_rec.attribute5 = OKC_API.G_MISS_CHAR)
2336: THEN
2337: x_sppv_rec.attribute5 := l_sppv_rec.attribute5;
2338: END IF;
2339: IF (x_sppv_rec.attribute6 = OKC_API.G_MISS_CHAR)

Line 2339: IF (x_sppv_rec.attribute6 = OKC_API.G_MISS_CHAR)

2335: IF (x_sppv_rec.attribute5 = OKC_API.G_MISS_CHAR)
2336: THEN
2337: x_sppv_rec.attribute5 := l_sppv_rec.attribute5;
2338: END IF;
2339: IF (x_sppv_rec.attribute6 = OKC_API.G_MISS_CHAR)
2340: THEN
2341: x_sppv_rec.attribute6 := l_sppv_rec.attribute6;
2342: END IF;
2343: IF (x_sppv_rec.attribute7 = OKC_API.G_MISS_CHAR)

Line 2343: IF (x_sppv_rec.attribute7 = OKC_API.G_MISS_CHAR)

2339: IF (x_sppv_rec.attribute6 = OKC_API.G_MISS_CHAR)
2340: THEN
2341: x_sppv_rec.attribute6 := l_sppv_rec.attribute6;
2342: END IF;
2343: IF (x_sppv_rec.attribute7 = OKC_API.G_MISS_CHAR)
2344: THEN
2345: x_sppv_rec.attribute7 := l_sppv_rec.attribute7;
2346: END IF;
2347: IF (x_sppv_rec.attribute8 = OKC_API.G_MISS_CHAR)

Line 2347: IF (x_sppv_rec.attribute8 = OKC_API.G_MISS_CHAR)

2343: IF (x_sppv_rec.attribute7 = OKC_API.G_MISS_CHAR)
2344: THEN
2345: x_sppv_rec.attribute7 := l_sppv_rec.attribute7;
2346: END IF;
2347: IF (x_sppv_rec.attribute8 = OKC_API.G_MISS_CHAR)
2348: THEN
2349: x_sppv_rec.attribute8 := l_sppv_rec.attribute8;
2350: END IF;
2351: IF (x_sppv_rec.attribute9 = OKC_API.G_MISS_CHAR)

Line 2351: IF (x_sppv_rec.attribute9 = OKC_API.G_MISS_CHAR)

2347: IF (x_sppv_rec.attribute8 = OKC_API.G_MISS_CHAR)
2348: THEN
2349: x_sppv_rec.attribute8 := l_sppv_rec.attribute8;
2350: END IF;
2351: IF (x_sppv_rec.attribute9 = OKC_API.G_MISS_CHAR)
2352: THEN
2353: x_sppv_rec.attribute9 := l_sppv_rec.attribute9;
2354: END IF;
2355: IF (x_sppv_rec.attribute10 = OKC_API.G_MISS_CHAR)

Line 2355: IF (x_sppv_rec.attribute10 = OKC_API.G_MISS_CHAR)

2351: IF (x_sppv_rec.attribute9 = OKC_API.G_MISS_CHAR)
2352: THEN
2353: x_sppv_rec.attribute9 := l_sppv_rec.attribute9;
2354: END IF;
2355: IF (x_sppv_rec.attribute10 = OKC_API.G_MISS_CHAR)
2356: THEN
2357: x_sppv_rec.attribute10 := l_sppv_rec.attribute10;
2358: END IF;
2359: IF (x_sppv_rec.attribute11 = OKC_API.G_MISS_CHAR)

Line 2359: IF (x_sppv_rec.attribute11 = OKC_API.G_MISS_CHAR)

2355: IF (x_sppv_rec.attribute10 = OKC_API.G_MISS_CHAR)
2356: THEN
2357: x_sppv_rec.attribute10 := l_sppv_rec.attribute10;
2358: END IF;
2359: IF (x_sppv_rec.attribute11 = OKC_API.G_MISS_CHAR)
2360: THEN
2361: x_sppv_rec.attribute11 := l_sppv_rec.attribute11;
2362: END IF;
2363: IF (x_sppv_rec.attribute12 = OKC_API.G_MISS_CHAR)

Line 2363: IF (x_sppv_rec.attribute12 = OKC_API.G_MISS_CHAR)

2359: IF (x_sppv_rec.attribute11 = OKC_API.G_MISS_CHAR)
2360: THEN
2361: x_sppv_rec.attribute11 := l_sppv_rec.attribute11;
2362: END IF;
2363: IF (x_sppv_rec.attribute12 = OKC_API.G_MISS_CHAR)
2364: THEN
2365: x_sppv_rec.attribute12 := l_sppv_rec.attribute12;
2366: END IF;
2367: IF (x_sppv_rec.attribute13 = OKC_API.G_MISS_CHAR)

Line 2367: IF (x_sppv_rec.attribute13 = OKC_API.G_MISS_CHAR)

2363: IF (x_sppv_rec.attribute12 = OKC_API.G_MISS_CHAR)
2364: THEN
2365: x_sppv_rec.attribute12 := l_sppv_rec.attribute12;
2366: END IF;
2367: IF (x_sppv_rec.attribute13 = OKC_API.G_MISS_CHAR)
2368: THEN
2369: x_sppv_rec.attribute13 := l_sppv_rec.attribute13;
2370: END IF;
2371: IF (x_sppv_rec.attribute14 = OKC_API.G_MISS_CHAR)

Line 2371: IF (x_sppv_rec.attribute14 = OKC_API.G_MISS_CHAR)

2367: IF (x_sppv_rec.attribute13 = OKC_API.G_MISS_CHAR)
2368: THEN
2369: x_sppv_rec.attribute13 := l_sppv_rec.attribute13;
2370: END IF;
2371: IF (x_sppv_rec.attribute14 = OKC_API.G_MISS_CHAR)
2372: THEN
2373: x_sppv_rec.attribute14 := l_sppv_rec.attribute14;
2374: END IF;
2375: IF (x_sppv_rec.attribute15 = OKC_API.G_MISS_CHAR)

Line 2375: IF (x_sppv_rec.attribute15 = OKC_API.G_MISS_CHAR)

2371: IF (x_sppv_rec.attribute14 = OKC_API.G_MISS_CHAR)
2372: THEN
2373: x_sppv_rec.attribute14 := l_sppv_rec.attribute14;
2374: END IF;
2375: IF (x_sppv_rec.attribute15 = OKC_API.G_MISS_CHAR)
2376: THEN
2377: x_sppv_rec.attribute15 := l_sppv_rec.attribute15;
2378: END IF;
2379: IF (x_sppv_rec.created_by = OKC_API.G_MISS_NUM)

Line 2379: IF (x_sppv_rec.created_by = OKC_API.G_MISS_NUM)

2375: IF (x_sppv_rec.attribute15 = OKC_API.G_MISS_CHAR)
2376: THEN
2377: x_sppv_rec.attribute15 := l_sppv_rec.attribute15;
2378: END IF;
2379: IF (x_sppv_rec.created_by = OKC_API.G_MISS_NUM)
2380: THEN
2381: x_sppv_rec.created_by := l_sppv_rec.created_by;
2382: END IF;
2383: IF (x_sppv_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2383: IF (x_sppv_rec.last_updated_by = OKC_API.G_MISS_NUM)

2379: IF (x_sppv_rec.created_by = OKC_API.G_MISS_NUM)
2380: THEN
2381: x_sppv_rec.created_by := l_sppv_rec.created_by;
2382: END IF;
2383: IF (x_sppv_rec.last_updated_by = OKC_API.G_MISS_NUM)
2384: THEN
2385: x_sppv_rec.last_updated_by := l_sppv_rec.last_updated_by;
2386: END IF;
2387: IF (x_sppv_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2387: IF (x_sppv_rec.creation_date = OKC_API.G_MISS_DATE)

2383: IF (x_sppv_rec.last_updated_by = OKC_API.G_MISS_NUM)
2384: THEN
2385: x_sppv_rec.last_updated_by := l_sppv_rec.last_updated_by;
2386: END IF;
2387: IF (x_sppv_rec.creation_date = OKC_API.G_MISS_DATE)
2388: THEN
2389: x_sppv_rec.creation_date := l_sppv_rec.creation_date;
2390: END IF;
2391: IF (x_sppv_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2391: IF (x_sppv_rec.last_update_date = OKC_API.G_MISS_DATE)

2387: IF (x_sppv_rec.creation_date = OKC_API.G_MISS_DATE)
2388: THEN
2389: x_sppv_rec.creation_date := l_sppv_rec.creation_date;
2390: END IF;
2391: IF (x_sppv_rec.last_update_date = OKC_API.G_MISS_DATE)
2392: THEN
2393: x_sppv_rec.last_update_date := l_sppv_rec.last_update_date;
2394: END IF;
2395: IF (x_sppv_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2395: IF (x_sppv_rec.last_update_login = OKC_API.G_MISS_NUM)

2391: IF (x_sppv_rec.last_update_date = OKC_API.G_MISS_DATE)
2392: THEN
2393: x_sppv_rec.last_update_date := l_sppv_rec.last_update_date;
2394: END IF;
2395: IF (x_sppv_rec.last_update_login = OKC_API.G_MISS_NUM)
2396: THEN
2397: x_sppv_rec.last_update_login := l_sppv_rec.last_update_login;
2398: END IF;
2399: RETURN(l_return_status);

Line 2408: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2404: FUNCTION Set_Attributes (
2405: p_sppv_rec IN sppv_rec_type,
2406: x_sppv_rec OUT NOCOPY sppv_rec_type
2407: ) RETURN VARCHAR2 IS
2408: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2409: BEGIN
2410: x_sppv_rec := p_sppv_rec;
2411: x_sppv_rec.OBJECT_VERSION_NUMBER := NVL(x_sppv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2412: RETURN(l_return_status);

Line 2415: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

2411: x_sppv_rec.OBJECT_VERSION_NUMBER := NVL(x_sppv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2412: RETURN(l_return_status);
2413: END Set_Attributes;
2414: BEGIN
2415: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2416: G_PKG_NAME,
2417: p_init_msg_list,
2418: l_api_version,
2419: p_api_version,

Line 2422: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2418: l_api_version,
2419: p_api_version,
2420: '_PVT',
2421: x_return_status);
2422: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2423: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2424: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2425: RAISE OKC_API.G_EXCEPTION_ERROR;
2426: END IF;

Line 2423: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2419: p_api_version,
2420: '_PVT',
2421: x_return_status);
2422: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2423: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2424: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2425: RAISE OKC_API.G_EXCEPTION_ERROR;
2426: END IF;
2427: --- Setting item attributes

Line 2424: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2420: '_PVT',
2421: x_return_status);
2422: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2423: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2424: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2425: RAISE OKC_API.G_EXCEPTION_ERROR;
2426: END IF;
2427: --- Setting item attributes
2428: l_return_status := Set_Attributes(

Line 2425: RAISE OKC_API.G_EXCEPTION_ERROR;

2421: x_return_status);
2422: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2423: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2424: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2425: RAISE OKC_API.G_EXCEPTION_ERROR;
2426: END IF;
2427: --- Setting item attributes
2428: l_return_status := Set_Attributes(
2429: p_sppv_rec, -- IN

Line 2432: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2428: l_return_status := Set_Attributes(
2429: p_sppv_rec, -- IN
2430: l_sppv_rec); -- OUT
2431: --- If any errors happen abort API
2432: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2433: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2434: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2435: RAISE OKC_API.G_EXCEPTION_ERROR;
2436: END IF;

Line 2433: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2429: p_sppv_rec, -- IN
2430: l_sppv_rec); -- OUT
2431: --- If any errors happen abort API
2432: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2433: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2434: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2435: RAISE OKC_API.G_EXCEPTION_ERROR;
2436: END IF;
2437: l_return_status := populate_new_record(l_sppv_rec, l_def_sppv_rec);

Line 2434: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2430: l_sppv_rec); -- OUT
2431: --- If any errors happen abort API
2432: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2433: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2434: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2435: RAISE OKC_API.G_EXCEPTION_ERROR;
2436: END IF;
2437: l_return_status := populate_new_record(l_sppv_rec, l_def_sppv_rec);
2438: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2435: RAISE OKC_API.G_EXCEPTION_ERROR;

2431: --- If any errors happen abort API
2432: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2433: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2434: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2435: RAISE OKC_API.G_EXCEPTION_ERROR;
2436: END IF;
2437: l_return_status := populate_new_record(l_sppv_rec, l_def_sppv_rec);
2438: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2438: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2434: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2435: RAISE OKC_API.G_EXCEPTION_ERROR;
2436: END IF;
2437: l_return_status := populate_new_record(l_sppv_rec, l_def_sppv_rec);
2438: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2440: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2441: RAISE OKC_API.G_EXCEPTION_ERROR;
2442: END IF;

Line 2439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2435: RAISE OKC_API.G_EXCEPTION_ERROR;
2436: END IF;
2437: l_return_status := populate_new_record(l_sppv_rec, l_def_sppv_rec);
2438: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2440: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2441: RAISE OKC_API.G_EXCEPTION_ERROR;
2442: END IF;
2443: l_def_sppv_rec := fill_who_columns(l_def_sppv_rec);

Line 2440: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2436: END IF;
2437: l_return_status := populate_new_record(l_sppv_rec, l_def_sppv_rec);
2438: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2440: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2441: RAISE OKC_API.G_EXCEPTION_ERROR;
2442: END IF;
2443: l_def_sppv_rec := fill_who_columns(l_def_sppv_rec);
2444: --- Validate all non-missing attributes (Item Level Validation)

Line 2441: RAISE OKC_API.G_EXCEPTION_ERROR;

2437: l_return_status := populate_new_record(l_sppv_rec, l_def_sppv_rec);
2438: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2440: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2441: RAISE OKC_API.G_EXCEPTION_ERROR;
2442: END IF;
2443: l_def_sppv_rec := fill_who_columns(l_def_sppv_rec);
2444: --- Validate all non-missing attributes (Item Level Validation)
2445: l_return_status := Validate_Attributes(l_def_sppv_rec);

Line 2447: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2443: l_def_sppv_rec := fill_who_columns(l_def_sppv_rec);
2444: --- Validate all non-missing attributes (Item Level Validation)
2445: l_return_status := Validate_Attributes(l_def_sppv_rec);
2446: --- If any errors happen abort API
2447: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2448: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2449: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2450: RAISE OKC_API.G_EXCEPTION_ERROR;
2451: END IF;

Line 2448: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2444: --- Validate all non-missing attributes (Item Level Validation)
2445: l_return_status := Validate_Attributes(l_def_sppv_rec);
2446: --- If any errors happen abort API
2447: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2448: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2449: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2450: RAISE OKC_API.G_EXCEPTION_ERROR;
2451: END IF;
2452: l_return_status := Validate_Record(l_def_sppv_rec);

Line 2449: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2445: l_return_status := Validate_Attributes(l_def_sppv_rec);
2446: --- If any errors happen abort API
2447: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2448: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2449: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2450: RAISE OKC_API.G_EXCEPTION_ERROR;
2451: END IF;
2452: l_return_status := Validate_Record(l_def_sppv_rec);
2453: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2450: RAISE OKC_API.G_EXCEPTION_ERROR;

2446: --- If any errors happen abort API
2447: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2448: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2449: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2450: RAISE OKC_API.G_EXCEPTION_ERROR;
2451: END IF;
2452: l_return_status := Validate_Record(l_def_sppv_rec);
2453: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2453: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2449: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2450: RAISE OKC_API.G_EXCEPTION_ERROR;
2451: END IF;
2452: l_return_status := Validate_Record(l_def_sppv_rec);
2453: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2455: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2456: RAISE OKC_API.G_EXCEPTION_ERROR;
2457: END IF;

Line 2454: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2450: RAISE OKC_API.G_EXCEPTION_ERROR;
2451: END IF;
2452: l_return_status := Validate_Record(l_def_sppv_rec);
2453: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2455: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2456: RAISE OKC_API.G_EXCEPTION_ERROR;
2457: END IF;
2458: --------------------------------------

Line 2455: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2451: END IF;
2452: l_return_status := Validate_Record(l_def_sppv_rec);
2453: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2455: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2456: RAISE OKC_API.G_EXCEPTION_ERROR;
2457: END IF;
2458: --------------------------------------
2459: -- Move VIEW record to "Child" records

Line 2456: RAISE OKC_API.G_EXCEPTION_ERROR;

2452: l_return_status := Validate_Record(l_def_sppv_rec);
2453: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2455: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2456: RAISE OKC_API.G_EXCEPTION_ERROR;
2457: END IF;
2458: --------------------------------------
2459: -- Move VIEW record to "Child" records
2460: --------------------------------------

Line 2473: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2469: x_msg_data,
2470: l_spp_rec,
2471: lx_spp_rec
2472: );
2473: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2474: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2475: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2476: RAISE OKC_API.G_EXCEPTION_ERROR;
2477: END IF;

Line 2474: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2470: l_spp_rec,
2471: lx_spp_rec
2472: );
2473: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2474: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2475: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2476: RAISE OKC_API.G_EXCEPTION_ERROR;
2477: END IF;
2478: migrate(lx_spp_rec, l_def_sppv_rec);

Line 2475: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2471: lx_spp_rec
2472: );
2473: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2474: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2475: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2476: RAISE OKC_API.G_EXCEPTION_ERROR;
2477: END IF;
2478: migrate(lx_spp_rec, l_def_sppv_rec);
2479: x_sppv_rec := l_def_sppv_rec;

Line 2476: RAISE OKC_API.G_EXCEPTION_ERROR;

2472: );
2473: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2474: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2475: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2476: RAISE OKC_API.G_EXCEPTION_ERROR;
2477: END IF;
2478: migrate(lx_spp_rec, l_def_sppv_rec);
2479: x_sppv_rec := l_def_sppv_rec;
2480: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2480: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2476: RAISE OKC_API.G_EXCEPTION_ERROR;
2477: END IF;
2478: migrate(lx_spp_rec, l_def_sppv_rec);
2479: x_sppv_rec := l_def_sppv_rec;
2480: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2481: EXCEPTION
2482: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2483: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2484: (

Line 2482: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2478: migrate(lx_spp_rec, l_def_sppv_rec);
2479: x_sppv_rec := l_def_sppv_rec;
2480: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2481: EXCEPTION
2482: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2483: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2484: (
2485: l_api_name,
2486: G_PKG_NAME,

Line 2483: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2479: x_sppv_rec := l_def_sppv_rec;
2480: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2481: EXCEPTION
2482: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2483: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2484: (
2485: l_api_name,
2486: G_PKG_NAME,
2487: 'OKC_API.G_RET_STS_ERROR',

Line 2487: 'OKC_API.G_RET_STS_ERROR',

2483: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2484: (
2485: l_api_name,
2486: G_PKG_NAME,
2487: 'OKC_API.G_RET_STS_ERROR',
2488: x_msg_count,
2489: x_msg_data,
2490: '_PVT'
2491: );

Line 2492: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2488: x_msg_count,
2489: x_msg_data,
2490: '_PVT'
2491: );
2492: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2493: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2494: (
2495: l_api_name,
2496: G_PKG_NAME,

Line 2493: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2489: x_msg_data,
2490: '_PVT'
2491: );
2492: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2493: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2494: (
2495: l_api_name,
2496: G_PKG_NAME,
2497: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2497: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2493: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2494: (
2495: l_api_name,
2496: G_PKG_NAME,
2497: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2498: x_msg_count,
2499: x_msg_data,
2500: '_PVT'
2501: );

Line 2503: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2499: x_msg_data,
2500: '_PVT'
2501: );
2502: WHEN OTHERS THEN
2503: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2504: (
2505: l_api_name,
2506: G_PKG_NAME,
2507: 'OTHERS',

Line 2518: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2514: -- PL/SQL TBL update_row for:SPPV_TBL --
2515: ----------------------------------------
2516: PROCEDURE update_row(
2517: p_api_version IN NUMBER,
2518: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2519: x_return_status OUT NOCOPY VARCHAR2,
2520: x_msg_count OUT NOCOPY NUMBER,
2521: x_msg_data OUT NOCOPY VARCHAR2,
2522: p_sppv_tbl IN sppv_tbl_type,

Line 2526: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2522: p_sppv_tbl IN sppv_tbl_type,
2523: x_sppv_tbl OUT NOCOPY sppv_tbl_type) IS
2524: l_api_version CONSTANT NUMBER := 1;
2525: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2526: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2527: i NUMBER := 0;
2528: -- START change : mvasudev, 08/16/2001
2529: -- Adding OverAll Status Flag
2530: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2530: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2526: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2527: i NUMBER := 0;
2528: -- START change : mvasudev, 08/16/2001
2529: -- Adding OverAll Status Flag
2530: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2531: -- END change : mvasudev
2532: BEGIN
2533: OKC_API.init_msg_list(p_init_msg_list);
2534: -- Make sure PL/SQL table has records in it before passing

Line 2533: OKC_API.init_msg_list(p_init_msg_list);

2529: -- Adding OverAll Status Flag
2530: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2531: -- END change : mvasudev
2532: BEGIN
2533: OKC_API.init_msg_list(p_init_msg_list);
2534: -- Make sure PL/SQL table has records in it before passing
2535: IF (p_sppv_tbl.COUNT > 0) THEN
2536: i := p_sppv_tbl.FIRST;
2537: LOOP

Line 2540: p_init_msg_list => OKC_API.G_FALSE,

2536: i := p_sppv_tbl.FIRST;
2537: LOOP
2538: update_row (
2539: p_api_version => p_api_version,
2540: p_init_msg_list => OKC_API.G_FALSE,
2541: x_return_status => x_return_status,
2542: x_msg_count => x_msg_count,
2543: x_msg_data => x_msg_data,
2544: p_sppv_rec => p_sppv_tbl(i),

Line 2548: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

2544: p_sppv_rec => p_sppv_tbl(i),
2545: x_sppv_rec => x_sppv_tbl(i));
2546: -- START change : mvasudev, 08/16/2001
2547: -- store the highest degree of error
2548: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2549: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2550: l_overall_status := x_return_status;
2551: END IF;
2552: END IF;

Line 2549: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

2545: x_sppv_rec => x_sppv_tbl(i));
2546: -- START change : mvasudev, 08/16/2001
2547: -- store the highest degree of error
2548: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2549: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2550: l_overall_status := x_return_status;
2551: END IF;
2552: END IF;
2553: -- END change : mvasudev

Line 2563: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2559: x_return_status := l_overall_status;
2560: -- END change : mvasudev
2561: END IF;
2562: EXCEPTION
2563: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2564: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2565: (
2566: l_api_name,
2567: G_PKG_NAME,

Line 2564: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2560: -- END change : mvasudev
2561: END IF;
2562: EXCEPTION
2563: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2564: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2565: (
2566: l_api_name,
2567: G_PKG_NAME,
2568: 'OKC_API.G_RET_STS_ERROR',

Line 2568: 'OKC_API.G_RET_STS_ERROR',

2564: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2565: (
2566: l_api_name,
2567: G_PKG_NAME,
2568: 'OKC_API.G_RET_STS_ERROR',
2569: x_msg_count,
2570: x_msg_data,
2571: '_PVT'
2572: );

Line 2573: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2569: x_msg_count,
2570: x_msg_data,
2571: '_PVT'
2572: );
2573: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2574: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2575: (
2576: l_api_name,
2577: G_PKG_NAME,

Line 2574: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2570: x_msg_data,
2571: '_PVT'
2572: );
2573: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2574: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2575: (
2576: l_api_name,
2577: G_PKG_NAME,
2578: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2578: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2574: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2575: (
2576: l_api_name,
2577: G_PKG_NAME,
2578: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2579: x_msg_count,
2580: x_msg_data,
2581: '_PVT'
2582: );

Line 2584: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2580: x_msg_data,
2581: '_PVT'
2582: );
2583: WHEN OTHERS THEN
2584: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2585: (
2586: l_api_name,
2587: G_PKG_NAME,
2588: 'OTHERS',

Line 2601: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2597: ----------------------------------------
2598: -- delete_row for:OKL_SIF_PRICE_PARMS --
2599: ----------------------------------------
2600: PROCEDURE delete_row(
2601: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2602: x_return_status OUT NOCOPY VARCHAR2,
2603: x_msg_count OUT NOCOPY NUMBER,
2604: x_msg_data OUT NOCOPY VARCHAR2,
2605: p_spp_rec IN spp_rec_type) IS

Line 2608: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2604: x_msg_data OUT NOCOPY VARCHAR2,
2605: p_spp_rec IN spp_rec_type) IS
2606: l_api_version CONSTANT NUMBER := 1;
2607: l_api_name CONSTANT VARCHAR2(30) := 'PARMS_delete_row';
2608: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2609: l_spp_rec spp_rec_type:= p_spp_rec;
2610: l_row_notfound BOOLEAN := TRUE;
2611: BEGIN
2612: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2612: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

2608: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2609: l_spp_rec spp_rec_type:= p_spp_rec;
2610: l_row_notfound BOOLEAN := TRUE;
2611: BEGIN
2612: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2613: p_init_msg_list,
2614: '_PVT',
2615: x_return_status);
2616: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2616: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2612: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2613: p_init_msg_list,
2614: '_PVT',
2615: x_return_status);
2616: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2618: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2619: RAISE OKC_API.G_EXCEPTION_ERROR;
2620: END IF;

Line 2617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2613: p_init_msg_list,
2614: '_PVT',
2615: x_return_status);
2616: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2618: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2619: RAISE OKC_API.G_EXCEPTION_ERROR;
2620: END IF;
2621: DELETE FROM OKL_SIF_PRICE_PARMS

Line 2618: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2614: '_PVT',
2615: x_return_status);
2616: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2618: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2619: RAISE OKC_API.G_EXCEPTION_ERROR;
2620: END IF;
2621: DELETE FROM OKL_SIF_PRICE_PARMS
2622: WHERE ID = l_spp_rec.id;

Line 2619: RAISE OKC_API.G_EXCEPTION_ERROR;

2615: x_return_status);
2616: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2617: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2618: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2619: RAISE OKC_API.G_EXCEPTION_ERROR;
2620: END IF;
2621: DELETE FROM OKL_SIF_PRICE_PARMS
2622: WHERE ID = l_spp_rec.id;
2623: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2623: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2619: RAISE OKC_API.G_EXCEPTION_ERROR;
2620: END IF;
2621: DELETE FROM OKL_SIF_PRICE_PARMS
2622: WHERE ID = l_spp_rec.id;
2623: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2624: EXCEPTION
2625: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2626: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2627: (

Line 2625: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2621: DELETE FROM OKL_SIF_PRICE_PARMS
2622: WHERE ID = l_spp_rec.id;
2623: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2624: EXCEPTION
2625: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2626: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2627: (
2628: l_api_name,
2629: G_PKG_NAME,

Line 2626: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2622: WHERE ID = l_spp_rec.id;
2623: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2624: EXCEPTION
2625: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2626: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2627: (
2628: l_api_name,
2629: G_PKG_NAME,
2630: 'OKC_API.G_RET_STS_ERROR',

Line 2630: 'OKC_API.G_RET_STS_ERROR',

2626: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2627: (
2628: l_api_name,
2629: G_PKG_NAME,
2630: 'OKC_API.G_RET_STS_ERROR',
2631: x_msg_count,
2632: x_msg_data,
2633: '_PVT'
2634: );

Line 2635: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2631: x_msg_count,
2632: x_msg_data,
2633: '_PVT'
2634: );
2635: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2636: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2637: (
2638: l_api_name,
2639: G_PKG_NAME,

Line 2636: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2632: x_msg_data,
2633: '_PVT'
2634: );
2635: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2636: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2637: (
2638: l_api_name,
2639: G_PKG_NAME,
2640: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2640: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2636: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2637: (
2638: l_api_name,
2639: G_PKG_NAME,
2640: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2641: x_msg_count,
2642: x_msg_data,
2643: '_PVT'
2644: );

Line 2646: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2642: x_msg_data,
2643: '_PVT'
2644: );
2645: WHEN OTHERS THEN
2646: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2647: (
2648: l_api_name,
2649: G_PKG_NAME,
2650: 'OTHERS',

Line 2661: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2657: -- delete_row for:OKL_SIF_PRICE_PARMS_V --
2658: ------------------------------------------
2659: PROCEDURE delete_row(
2660: p_api_version IN NUMBER,
2661: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2662: x_return_status OUT NOCOPY VARCHAR2,
2663: x_msg_count OUT NOCOPY NUMBER,
2664: x_msg_data OUT NOCOPY VARCHAR2,
2665: p_sppv_rec IN sppv_rec_type) IS

Line 2668: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2664: x_msg_data OUT NOCOPY VARCHAR2,
2665: p_sppv_rec IN sppv_rec_type) IS
2666: l_api_version CONSTANT NUMBER := 1;
2667: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2668: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2669: l_sppv_rec sppv_rec_type := p_sppv_rec;
2670: l_spp_rec spp_rec_type;
2671: BEGIN
2672: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2672: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

2668: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2669: l_sppv_rec sppv_rec_type := p_sppv_rec;
2670: l_spp_rec spp_rec_type;
2671: BEGIN
2672: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2673: G_PKG_NAME,
2674: p_init_msg_list,
2675: l_api_version,
2676: p_api_version,

Line 2679: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2675: l_api_version,
2676: p_api_version,
2677: '_PVT',
2678: x_return_status);
2679: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2680: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2681: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2682: RAISE OKC_API.G_EXCEPTION_ERROR;
2683: END IF;

Line 2680: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2676: p_api_version,
2677: '_PVT',
2678: x_return_status);
2679: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2680: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2681: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2682: RAISE OKC_API.G_EXCEPTION_ERROR;
2683: END IF;
2684: --------------------------------------

Line 2681: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2677: '_PVT',
2678: x_return_status);
2679: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2680: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2681: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2682: RAISE OKC_API.G_EXCEPTION_ERROR;
2683: END IF;
2684: --------------------------------------
2685: -- Move VIEW record to "Child" records

Line 2682: RAISE OKC_API.G_EXCEPTION_ERROR;

2678: x_return_status);
2679: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2680: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2681: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2682: RAISE OKC_API.G_EXCEPTION_ERROR;
2683: END IF;
2684: --------------------------------------
2685: -- Move VIEW record to "Child" records
2686: --------------------------------------

Line 2698: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2694: x_msg_count,
2695: x_msg_data,
2696: l_spp_rec
2697: );
2698: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2701: RAISE OKC_API.G_EXCEPTION_ERROR;
2702: END IF;

Line 2699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2695: x_msg_data,
2696: l_spp_rec
2697: );
2698: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2701: RAISE OKC_API.G_EXCEPTION_ERROR;
2702: END IF;
2703: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2696: l_spp_rec
2697: );
2698: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2701: RAISE OKC_API.G_EXCEPTION_ERROR;
2702: END IF;
2703: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2704: EXCEPTION

Line 2701: RAISE OKC_API.G_EXCEPTION_ERROR;

2697: );
2698: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2701: RAISE OKC_API.G_EXCEPTION_ERROR;
2702: END IF;
2703: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2704: EXCEPTION
2705: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2703: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2701: RAISE OKC_API.G_EXCEPTION_ERROR;
2702: END IF;
2703: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2704: EXCEPTION
2705: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2706: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2707: (

Line 2705: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2701: RAISE OKC_API.G_EXCEPTION_ERROR;
2702: END IF;
2703: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2704: EXCEPTION
2705: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2706: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2707: (
2708: l_api_name,
2709: G_PKG_NAME,

Line 2706: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2702: END IF;
2703: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2704: EXCEPTION
2705: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2706: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2707: (
2708: l_api_name,
2709: G_PKG_NAME,
2710: 'OKC_API.G_RET_STS_ERROR',

Line 2710: 'OKC_API.G_RET_STS_ERROR',

2706: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2707: (
2708: l_api_name,
2709: G_PKG_NAME,
2710: 'OKC_API.G_RET_STS_ERROR',
2711: x_msg_count,
2712: x_msg_data,
2713: '_PVT'
2714: );

Line 2715: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2711: x_msg_count,
2712: x_msg_data,
2713: '_PVT'
2714: );
2715: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2716: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2717: (
2718: l_api_name,
2719: G_PKG_NAME,

Line 2716: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2712: x_msg_data,
2713: '_PVT'
2714: );
2715: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2716: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2717: (
2718: l_api_name,
2719: G_PKG_NAME,
2720: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2720: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2716: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2717: (
2718: l_api_name,
2719: G_PKG_NAME,
2720: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2721: x_msg_count,
2722: x_msg_data,
2723: '_PVT'
2724: );

Line 2726: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2722: x_msg_data,
2723: '_PVT'
2724: );
2725: WHEN OTHERS THEN
2726: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2727: (
2728: l_api_name,
2729: G_PKG_NAME,
2730: 'OTHERS',

Line 2741: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2737: -- PL/SQL TBL delete_row for:SPPV_TBL --
2738: ----------------------------------------
2739: PROCEDURE delete_row(
2740: p_api_version IN NUMBER,
2741: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2742: x_return_status OUT NOCOPY VARCHAR2,
2743: x_msg_count OUT NOCOPY NUMBER,
2744: x_msg_data OUT NOCOPY VARCHAR2,
2745: p_sppv_tbl IN sppv_tbl_type) IS

Line 2748: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2744: x_msg_data OUT NOCOPY VARCHAR2,
2745: p_sppv_tbl IN sppv_tbl_type) IS
2746: l_api_version CONSTANT NUMBER := 1;
2747: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2748: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2749: i NUMBER := 0;
2750: -- START change : mvasudev, 08/16/2001
2751: -- Adding OverAll Status Flag
2752: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2752: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2748: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2749: i NUMBER := 0;
2750: -- START change : mvasudev, 08/16/2001
2751: -- Adding OverAll Status Flag
2752: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2753: -- END change : mvasudev
2754: BEGIN
2755: OKC_API.init_msg_list(p_init_msg_list);
2756: -- Make sure PL/SQL table has records in it before passing

Line 2755: OKC_API.init_msg_list(p_init_msg_list);

2751: -- Adding OverAll Status Flag
2752: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2753: -- END change : mvasudev
2754: BEGIN
2755: OKC_API.init_msg_list(p_init_msg_list);
2756: -- Make sure PL/SQL table has records in it before passing
2757: IF (p_sppv_tbl.COUNT > 0) THEN
2758: i := p_sppv_tbl.FIRST;
2759: LOOP

Line 2762: p_init_msg_list => OKC_API.G_FALSE,

2758: i := p_sppv_tbl.FIRST;
2759: LOOP
2760: delete_row (
2761: p_api_version => p_api_version,
2762: p_init_msg_list => OKC_API.G_FALSE,
2763: x_return_status => x_return_status,
2764: x_msg_count => x_msg_count,
2765: x_msg_data => x_msg_data,
2766: p_sppv_rec => p_sppv_tbl(i));

Line 2769: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

2765: x_msg_data => x_msg_data,
2766: p_sppv_rec => p_sppv_tbl(i));
2767: -- START change : mvasudev, 08/16/2001
2768: -- store the highest degree of error
2769: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2770: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2771: l_overall_status := x_return_status;
2772: END IF;
2773: END IF;

Line 2770: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

2766: p_sppv_rec => p_sppv_tbl(i));
2767: -- START change : mvasudev, 08/16/2001
2768: -- store the highest degree of error
2769: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2770: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2771: l_overall_status := x_return_status;
2772: END IF;
2773: END IF;
2774: -- END change : mvasudev

Line 2784: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2780: x_return_status := l_overall_status;
2781: -- END change : mvasudev
2782: END IF;
2783: EXCEPTION
2784: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2785: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2786: (
2787: l_api_name,
2788: G_PKG_NAME,

Line 2785: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2781: -- END change : mvasudev
2782: END IF;
2783: EXCEPTION
2784: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2785: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2786: (
2787: l_api_name,
2788: G_PKG_NAME,
2789: 'OKC_API.G_RET_STS_ERROR',

Line 2789: 'OKC_API.G_RET_STS_ERROR',

2785: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2786: (
2787: l_api_name,
2788: G_PKG_NAME,
2789: 'OKC_API.G_RET_STS_ERROR',
2790: x_msg_count,
2791: x_msg_data,
2792: '_PVT'
2793: );

Line 2794: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2790: x_msg_count,
2791: x_msg_data,
2792: '_PVT'
2793: );
2794: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2795: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2796: (
2797: l_api_name,
2798: G_PKG_NAME,

Line 2795: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2791: x_msg_data,
2792: '_PVT'
2793: );
2794: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2795: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2796: (
2797: l_api_name,
2798: G_PKG_NAME,
2799: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2799: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2795: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2796: (
2797: l_api_name,
2798: G_PKG_NAME,
2799: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2800: x_msg_count,
2801: x_msg_data,
2802: '_PVT'
2803: );

Line 2805: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2801: x_msg_data,
2802: '_PVT'
2803: );
2804: WHEN OTHERS THEN
2805: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2806: (
2807: l_api_name,
2808: G_PKG_NAME,
2809: 'OTHERS',