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.OKS_BSD_PRINT_PREVIEW_PVT dependencies on OKC_API

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

40: -- in a ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN ERROR_TBL_TYPE
43: ) RETURN VARCHAR2 IS
44: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
45: i INTEGER := 1;
46: BEGIN
47: IF (p_error_tbl.COUNT > 0) THEN
48: i := p_error_tbl.FIRST;

Line 50: IF (p_error_tbl(i).error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

46: BEGIN
47: IF (p_error_tbl.COUNT > 0) THEN
48: i := p_error_tbl.FIRST;
49: LOOP
50: IF (p_error_tbl(i).error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
51: IF (l_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
52: l_return_status := p_error_tbl(i).error_type;
53: END IF;
54: END IF;

Line 51: IF (l_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

47: IF (p_error_tbl.COUNT > 0) THEN
48: i := p_error_tbl.FIRST;
49: LOOP
50: IF (p_error_tbl(i).error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
51: IF (l_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
52: l_return_status := p_error_tbl(i).error_type;
53: END IF;
54: END IF;
55: EXIT WHEN (i = p_error_tbl.LAST);

Line 214: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');

210: l_row_notfound BOOLEAN := TRUE;
211: BEGIN
212: l_bsd_pr_rec := get_rec(p_bsd_pr_rec, l_row_notfound);
213: IF (l_row_notfound) THEN
214: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
215: x_return_status := OKC_API.G_RET_STS_ERROR;
216: END IF;
217: RETURN(l_bsd_pr_rec);
218: END get_rec;

Line 215: x_return_status := OKC_API.G_RET_STS_ERROR;

211: BEGIN
212: l_bsd_pr_rec := get_rec(p_bsd_pr_rec, l_row_notfound);
213: IF (l_row_notfound) THEN
214: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
215: x_return_status := OKC_API.G_RET_STS_ERROR;
216: END IF;
217: RETURN(l_bsd_pr_rec);
218: END get_rec;
219: -----------------------------------------------------------

Line 237: IF (l_bsd_pr_rec.id = OKC_API.G_MISS_NUM ) THEN

233: p_bsd_pr_rec IN bsd_pr_rec_type
234: ) RETURN bsd_pr_rec_type IS
235: l_bsd_pr_rec bsd_pr_rec_type := p_bsd_pr_rec;
236: BEGIN
237: IF (l_bsd_pr_rec.id = OKC_API.G_MISS_NUM ) THEN
238: l_bsd_pr_rec.id := NULL;
239: END IF;
240: IF (l_bsd_pr_rec.bsl_id = OKC_API.G_MISS_NUM ) THEN
241: l_bsd_pr_rec.bsl_id := NULL;

Line 240: IF (l_bsd_pr_rec.bsl_id = OKC_API.G_MISS_NUM ) THEN

236: BEGIN
237: IF (l_bsd_pr_rec.id = OKC_API.G_MISS_NUM ) THEN
238: l_bsd_pr_rec.id := NULL;
239: END IF;
240: IF (l_bsd_pr_rec.bsl_id = OKC_API.G_MISS_NUM ) THEN
241: l_bsd_pr_rec.bsl_id := NULL;
242: END IF;
243: IF (l_bsd_pr_rec.bsl_id_averaged = OKC_API.G_MISS_NUM ) THEN
244: l_bsd_pr_rec.bsl_id_averaged := NULL;

Line 243: IF (l_bsd_pr_rec.bsl_id_averaged = OKC_API.G_MISS_NUM ) THEN

239: END IF;
240: IF (l_bsd_pr_rec.bsl_id = OKC_API.G_MISS_NUM ) THEN
241: l_bsd_pr_rec.bsl_id := NULL;
242: END IF;
243: IF (l_bsd_pr_rec.bsl_id_averaged = OKC_API.G_MISS_NUM ) THEN
244: l_bsd_pr_rec.bsl_id_averaged := NULL;
245: END IF;
246: IF (l_bsd_pr_rec.bsd_id = OKC_API.G_MISS_NUM ) THEN
247: l_bsd_pr_rec.bsd_id := NULL;

Line 246: IF (l_bsd_pr_rec.bsd_id = OKC_API.G_MISS_NUM ) THEN

242: END IF;
243: IF (l_bsd_pr_rec.bsl_id_averaged = OKC_API.G_MISS_NUM ) THEN
244: l_bsd_pr_rec.bsl_id_averaged := NULL;
245: END IF;
246: IF (l_bsd_pr_rec.bsd_id = OKC_API.G_MISS_NUM ) THEN
247: l_bsd_pr_rec.bsd_id := NULL;
248: END IF;
249: IF (l_bsd_pr_rec.bsd_id_applied = OKC_API.G_MISS_NUM ) THEN
250: l_bsd_pr_rec.bsd_id_applied := NULL;

Line 249: IF (l_bsd_pr_rec.bsd_id_applied = OKC_API.G_MISS_NUM ) THEN

245: END IF;
246: IF (l_bsd_pr_rec.bsd_id = OKC_API.G_MISS_NUM ) THEN
247: l_bsd_pr_rec.bsd_id := NULL;
248: END IF;
249: IF (l_bsd_pr_rec.bsd_id_applied = OKC_API.G_MISS_NUM ) THEN
250: l_bsd_pr_rec.bsd_id_applied := NULL;
251: END IF;
252: IF (l_bsd_pr_rec.unit_of_measure = OKC_API.G_MISS_CHAR ) THEN
253: l_bsd_pr_rec.unit_of_measure := NULL;

Line 252: IF (l_bsd_pr_rec.unit_of_measure = OKC_API.G_MISS_CHAR ) THEN

248: END IF;
249: IF (l_bsd_pr_rec.bsd_id_applied = OKC_API.G_MISS_NUM ) THEN
250: l_bsd_pr_rec.bsd_id_applied := NULL;
251: END IF;
252: IF (l_bsd_pr_rec.unit_of_measure = OKC_API.G_MISS_CHAR ) THEN
253: l_bsd_pr_rec.unit_of_measure := NULL;
254: END IF;
255: IF (l_bsd_pr_rec.amcv_yn = OKC_API.G_MISS_CHAR ) THEN
256: l_bsd_pr_rec.amcv_yn := NULL;

Line 255: IF (l_bsd_pr_rec.amcv_yn = OKC_API.G_MISS_CHAR ) THEN

251: END IF;
252: IF (l_bsd_pr_rec.unit_of_measure = OKC_API.G_MISS_CHAR ) THEN
253: l_bsd_pr_rec.unit_of_measure := NULL;
254: END IF;
255: IF (l_bsd_pr_rec.amcv_yn = OKC_API.G_MISS_CHAR ) THEN
256: l_bsd_pr_rec.amcv_yn := NULL;
257: END IF;
258: IF (l_bsd_pr_rec.result = OKC_API.G_MISS_NUM ) THEN
259: l_bsd_pr_rec.result := NULL;

Line 258: IF (l_bsd_pr_rec.result = OKC_API.G_MISS_NUM ) THEN

254: END IF;
255: IF (l_bsd_pr_rec.amcv_yn = OKC_API.G_MISS_CHAR ) THEN
256: l_bsd_pr_rec.amcv_yn := NULL;
257: END IF;
258: IF (l_bsd_pr_rec.result = OKC_API.G_MISS_NUM ) THEN
259: l_bsd_pr_rec.result := NULL;
260: END IF;
261: IF (l_bsd_pr_rec.amount = OKC_API.G_MISS_NUM ) THEN
262: l_bsd_pr_rec.amount := NULL;

Line 261: IF (l_bsd_pr_rec.amount = OKC_API.G_MISS_NUM ) THEN

257: END IF;
258: IF (l_bsd_pr_rec.result = OKC_API.G_MISS_NUM ) THEN
259: l_bsd_pr_rec.result := NULL;
260: END IF;
261: IF (l_bsd_pr_rec.amount = OKC_API.G_MISS_NUM ) THEN
262: l_bsd_pr_rec.amount := NULL;
263: END IF;
264: IF (l_bsd_pr_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
265: l_bsd_pr_rec.object_version_number := NULL;

Line 264: IF (l_bsd_pr_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN

260: END IF;
261: IF (l_bsd_pr_rec.amount = OKC_API.G_MISS_NUM ) THEN
262: l_bsd_pr_rec.amount := NULL;
263: END IF;
264: IF (l_bsd_pr_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
265: l_bsd_pr_rec.object_version_number := NULL;
266: END IF;
267: IF (l_bsd_pr_rec.created_by = OKC_API.G_MISS_NUM ) THEN
268: l_bsd_pr_rec.created_by := NULL;

Line 267: IF (l_bsd_pr_rec.created_by = OKC_API.G_MISS_NUM ) THEN

263: END IF;
264: IF (l_bsd_pr_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
265: l_bsd_pr_rec.object_version_number := NULL;
266: END IF;
267: IF (l_bsd_pr_rec.created_by = OKC_API.G_MISS_NUM ) THEN
268: l_bsd_pr_rec.created_by := NULL;
269: END IF;
270: IF (l_bsd_pr_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
271: l_bsd_pr_rec.creation_date := NULL;

Line 270: IF (l_bsd_pr_rec.creation_date = OKC_API.G_MISS_DATE ) THEN

266: END IF;
267: IF (l_bsd_pr_rec.created_by = OKC_API.G_MISS_NUM ) THEN
268: l_bsd_pr_rec.created_by := NULL;
269: END IF;
270: IF (l_bsd_pr_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
271: l_bsd_pr_rec.creation_date := NULL;
272: END IF;
273: IF (l_bsd_pr_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
274: l_bsd_pr_rec.last_updated_by := NULL;

Line 273: IF (l_bsd_pr_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN

269: END IF;
270: IF (l_bsd_pr_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
271: l_bsd_pr_rec.creation_date := NULL;
272: END IF;
273: IF (l_bsd_pr_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
274: l_bsd_pr_rec.last_updated_by := NULL;
275: END IF;
276: IF (l_bsd_pr_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
277: l_bsd_pr_rec.last_update_date := NULL;

Line 276: IF (l_bsd_pr_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN

272: END IF;
273: IF (l_bsd_pr_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
274: l_bsd_pr_rec.last_updated_by := NULL;
275: END IF;
276: IF (l_bsd_pr_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
277: l_bsd_pr_rec.last_update_date := NULL;
278: END IF;
279: IF (l_bsd_pr_rec.fixed = OKC_API.G_MISS_NUM ) THEN
280: l_bsd_pr_rec.fixed := NULL;

Line 279: IF (l_bsd_pr_rec.fixed = OKC_API.G_MISS_NUM ) THEN

275: END IF;
276: IF (l_bsd_pr_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
277: l_bsd_pr_rec.last_update_date := NULL;
278: END IF;
279: IF (l_bsd_pr_rec.fixed = OKC_API.G_MISS_NUM ) THEN
280: l_bsd_pr_rec.fixed := NULL;
281: END IF;
282: IF (l_bsd_pr_rec.actual = OKC_API.G_MISS_NUM ) THEN
283: l_bsd_pr_rec.actual := NULL;

Line 282: IF (l_bsd_pr_rec.actual = OKC_API.G_MISS_NUM ) THEN

278: END IF;
279: IF (l_bsd_pr_rec.fixed = OKC_API.G_MISS_NUM ) THEN
280: l_bsd_pr_rec.fixed := NULL;
281: END IF;
282: IF (l_bsd_pr_rec.actual = OKC_API.G_MISS_NUM ) THEN
283: l_bsd_pr_rec.actual := NULL;
284: END IF;
285: IF (l_bsd_pr_rec.default_default = OKC_API.G_MISS_NUM ) THEN
286: l_bsd_pr_rec.default_default := NULL;

Line 285: IF (l_bsd_pr_rec.default_default = OKC_API.G_MISS_NUM ) THEN

281: END IF;
282: IF (l_bsd_pr_rec.actual = OKC_API.G_MISS_NUM ) THEN
283: l_bsd_pr_rec.actual := NULL;
284: END IF;
285: IF (l_bsd_pr_rec.default_default = OKC_API.G_MISS_NUM ) THEN
286: l_bsd_pr_rec.default_default := NULL;
287: END IF;
288: IF (l_bsd_pr_rec.adjustment_level = OKC_API.G_MISS_NUM ) THEN
289: l_bsd_pr_rec.adjustment_level := NULL;

Line 288: IF (l_bsd_pr_rec.adjustment_level = OKC_API.G_MISS_NUM ) THEN

284: END IF;
285: IF (l_bsd_pr_rec.default_default = OKC_API.G_MISS_NUM ) THEN
286: l_bsd_pr_rec.default_default := NULL;
287: END IF;
288: IF (l_bsd_pr_rec.adjustment_level = OKC_API.G_MISS_NUM ) THEN
289: l_bsd_pr_rec.adjustment_level := NULL;
290: END IF;
291: IF (l_bsd_pr_rec.adjustment_minimum = OKC_API.G_MISS_NUM ) THEN
292: l_bsd_pr_rec.adjustment_minimum := NULL;

Line 291: IF (l_bsd_pr_rec.adjustment_minimum = OKC_API.G_MISS_NUM ) THEN

287: END IF;
288: IF (l_bsd_pr_rec.adjustment_level = OKC_API.G_MISS_NUM ) THEN
289: l_bsd_pr_rec.adjustment_level := NULL;
290: END IF;
291: IF (l_bsd_pr_rec.adjustment_minimum = OKC_API.G_MISS_NUM ) THEN
292: l_bsd_pr_rec.adjustment_minimum := NULL;
293: END IF;
294: IF (l_bsd_pr_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
295: l_bsd_pr_rec.last_update_login := NULL;

Line 294: IF (l_bsd_pr_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN

290: END IF;
291: IF (l_bsd_pr_rec.adjustment_minimum = OKC_API.G_MISS_NUM ) THEN
292: l_bsd_pr_rec.adjustment_minimum := NULL;
293: END IF;
294: IF (l_bsd_pr_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
295: l_bsd_pr_rec.last_update_login := NULL;
296: END IF;
297: IF (l_bsd_pr_rec.attribute_category = OKC_API.G_MISS_CHAR ) THEN
298: l_bsd_pr_rec.attribute_category := NULL;

Line 297: IF (l_bsd_pr_rec.attribute_category = OKC_API.G_MISS_CHAR ) THEN

293: END IF;
294: IF (l_bsd_pr_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
295: l_bsd_pr_rec.last_update_login := NULL;
296: END IF;
297: IF (l_bsd_pr_rec.attribute_category = OKC_API.G_MISS_CHAR ) THEN
298: l_bsd_pr_rec.attribute_category := NULL;
299: END IF;
300: IF (l_bsd_pr_rec.attribute1 = OKC_API.G_MISS_CHAR ) THEN
301: l_bsd_pr_rec.attribute1 := NULL;

Line 300: IF (l_bsd_pr_rec.attribute1 = OKC_API.G_MISS_CHAR ) THEN

296: END IF;
297: IF (l_bsd_pr_rec.attribute_category = OKC_API.G_MISS_CHAR ) THEN
298: l_bsd_pr_rec.attribute_category := NULL;
299: END IF;
300: IF (l_bsd_pr_rec.attribute1 = OKC_API.G_MISS_CHAR ) THEN
301: l_bsd_pr_rec.attribute1 := NULL;
302: END IF;
303: IF (l_bsd_pr_rec.attribute2 = OKC_API.G_MISS_CHAR ) THEN
304: l_bsd_pr_rec.attribute2 := NULL;

Line 303: IF (l_bsd_pr_rec.attribute2 = OKC_API.G_MISS_CHAR ) THEN

299: END IF;
300: IF (l_bsd_pr_rec.attribute1 = OKC_API.G_MISS_CHAR ) THEN
301: l_bsd_pr_rec.attribute1 := NULL;
302: END IF;
303: IF (l_bsd_pr_rec.attribute2 = OKC_API.G_MISS_CHAR ) THEN
304: l_bsd_pr_rec.attribute2 := NULL;
305: END IF;
306: IF (l_bsd_pr_rec.attribute3 = OKC_API.G_MISS_CHAR ) THEN
307: l_bsd_pr_rec.attribute3 := NULL;

Line 306: IF (l_bsd_pr_rec.attribute3 = OKC_API.G_MISS_CHAR ) THEN

302: END IF;
303: IF (l_bsd_pr_rec.attribute2 = OKC_API.G_MISS_CHAR ) THEN
304: l_bsd_pr_rec.attribute2 := NULL;
305: END IF;
306: IF (l_bsd_pr_rec.attribute3 = OKC_API.G_MISS_CHAR ) THEN
307: l_bsd_pr_rec.attribute3 := NULL;
308: END IF;
309: IF (l_bsd_pr_rec.attribute4 = OKC_API.G_MISS_CHAR ) THEN
310: l_bsd_pr_rec.attribute4 := NULL;

Line 309: IF (l_bsd_pr_rec.attribute4 = OKC_API.G_MISS_CHAR ) THEN

305: END IF;
306: IF (l_bsd_pr_rec.attribute3 = OKC_API.G_MISS_CHAR ) THEN
307: l_bsd_pr_rec.attribute3 := NULL;
308: END IF;
309: IF (l_bsd_pr_rec.attribute4 = OKC_API.G_MISS_CHAR ) THEN
310: l_bsd_pr_rec.attribute4 := NULL;
311: END IF;
312: IF (l_bsd_pr_rec.attribute5 = OKC_API.G_MISS_CHAR ) THEN
313: l_bsd_pr_rec.attribute5 := NULL;

Line 312: IF (l_bsd_pr_rec.attribute5 = OKC_API.G_MISS_CHAR ) THEN

308: END IF;
309: IF (l_bsd_pr_rec.attribute4 = OKC_API.G_MISS_CHAR ) THEN
310: l_bsd_pr_rec.attribute4 := NULL;
311: END IF;
312: IF (l_bsd_pr_rec.attribute5 = OKC_API.G_MISS_CHAR ) THEN
313: l_bsd_pr_rec.attribute5 := NULL;
314: END IF;
315: IF (l_bsd_pr_rec.attribute6 = OKC_API.G_MISS_CHAR ) THEN
316: l_bsd_pr_rec.attribute6 := NULL;

Line 315: IF (l_bsd_pr_rec.attribute6 = OKC_API.G_MISS_CHAR ) THEN

311: END IF;
312: IF (l_bsd_pr_rec.attribute5 = OKC_API.G_MISS_CHAR ) THEN
313: l_bsd_pr_rec.attribute5 := NULL;
314: END IF;
315: IF (l_bsd_pr_rec.attribute6 = OKC_API.G_MISS_CHAR ) THEN
316: l_bsd_pr_rec.attribute6 := NULL;
317: END IF;
318: IF (l_bsd_pr_rec.attribute7 = OKC_API.G_MISS_CHAR ) THEN
319: l_bsd_pr_rec.attribute7 := NULL;

Line 318: IF (l_bsd_pr_rec.attribute7 = OKC_API.G_MISS_CHAR ) THEN

314: END IF;
315: IF (l_bsd_pr_rec.attribute6 = OKC_API.G_MISS_CHAR ) THEN
316: l_bsd_pr_rec.attribute6 := NULL;
317: END IF;
318: IF (l_bsd_pr_rec.attribute7 = OKC_API.G_MISS_CHAR ) THEN
319: l_bsd_pr_rec.attribute7 := NULL;
320: END IF;
321: IF (l_bsd_pr_rec.attribute8 = OKC_API.G_MISS_CHAR ) THEN
322: l_bsd_pr_rec.attribute8 := NULL;

Line 321: IF (l_bsd_pr_rec.attribute8 = OKC_API.G_MISS_CHAR ) THEN

317: END IF;
318: IF (l_bsd_pr_rec.attribute7 = OKC_API.G_MISS_CHAR ) THEN
319: l_bsd_pr_rec.attribute7 := NULL;
320: END IF;
321: IF (l_bsd_pr_rec.attribute8 = OKC_API.G_MISS_CHAR ) THEN
322: l_bsd_pr_rec.attribute8 := NULL;
323: END IF;
324: IF (l_bsd_pr_rec.attribute9 = OKC_API.G_MISS_CHAR ) THEN
325: l_bsd_pr_rec.attribute9 := NULL;

Line 324: IF (l_bsd_pr_rec.attribute9 = OKC_API.G_MISS_CHAR ) THEN

320: END IF;
321: IF (l_bsd_pr_rec.attribute8 = OKC_API.G_MISS_CHAR ) THEN
322: l_bsd_pr_rec.attribute8 := NULL;
323: END IF;
324: IF (l_bsd_pr_rec.attribute9 = OKC_API.G_MISS_CHAR ) THEN
325: l_bsd_pr_rec.attribute9 := NULL;
326: END IF;
327: IF (l_bsd_pr_rec.attribute10 = OKC_API.G_MISS_CHAR ) THEN
328: l_bsd_pr_rec.attribute10 := NULL;

Line 327: IF (l_bsd_pr_rec.attribute10 = OKC_API.G_MISS_CHAR ) THEN

323: END IF;
324: IF (l_bsd_pr_rec.attribute9 = OKC_API.G_MISS_CHAR ) THEN
325: l_bsd_pr_rec.attribute9 := NULL;
326: END IF;
327: IF (l_bsd_pr_rec.attribute10 = OKC_API.G_MISS_CHAR ) THEN
328: l_bsd_pr_rec.attribute10 := NULL;
329: END IF;
330: IF (l_bsd_pr_rec.attribute11 = OKC_API.G_MISS_CHAR ) THEN
331: l_bsd_pr_rec.attribute11 := NULL;

Line 330: IF (l_bsd_pr_rec.attribute11 = OKC_API.G_MISS_CHAR ) THEN

326: END IF;
327: IF (l_bsd_pr_rec.attribute10 = OKC_API.G_MISS_CHAR ) THEN
328: l_bsd_pr_rec.attribute10 := NULL;
329: END IF;
330: IF (l_bsd_pr_rec.attribute11 = OKC_API.G_MISS_CHAR ) THEN
331: l_bsd_pr_rec.attribute11 := NULL;
332: END IF;
333: IF (l_bsd_pr_rec.attribute12 = OKC_API.G_MISS_CHAR ) THEN
334: l_bsd_pr_rec.attribute12 := NULL;

Line 333: IF (l_bsd_pr_rec.attribute12 = OKC_API.G_MISS_CHAR ) THEN

329: END IF;
330: IF (l_bsd_pr_rec.attribute11 = OKC_API.G_MISS_CHAR ) THEN
331: l_bsd_pr_rec.attribute11 := NULL;
332: END IF;
333: IF (l_bsd_pr_rec.attribute12 = OKC_API.G_MISS_CHAR ) THEN
334: l_bsd_pr_rec.attribute12 := NULL;
335: END IF;
336: IF (l_bsd_pr_rec.attribute13 = OKC_API.G_MISS_CHAR ) THEN
337: l_bsd_pr_rec.attribute13 := NULL;

Line 336: IF (l_bsd_pr_rec.attribute13 = OKC_API.G_MISS_CHAR ) THEN

332: END IF;
333: IF (l_bsd_pr_rec.attribute12 = OKC_API.G_MISS_CHAR ) THEN
334: l_bsd_pr_rec.attribute12 := NULL;
335: END IF;
336: IF (l_bsd_pr_rec.attribute13 = OKC_API.G_MISS_CHAR ) THEN
337: l_bsd_pr_rec.attribute13 := NULL;
338: END IF;
339: IF (l_bsd_pr_rec.attribute14 = OKC_API.G_MISS_CHAR ) THEN
340: l_bsd_pr_rec.attribute14 := NULL;

Line 339: IF (l_bsd_pr_rec.attribute14 = OKC_API.G_MISS_CHAR ) THEN

335: END IF;
336: IF (l_bsd_pr_rec.attribute13 = OKC_API.G_MISS_CHAR ) THEN
337: l_bsd_pr_rec.attribute13 := NULL;
338: END IF;
339: IF (l_bsd_pr_rec.attribute14 = OKC_API.G_MISS_CHAR ) THEN
340: l_bsd_pr_rec.attribute14 := NULL;
341: END IF;
342: IF (l_bsd_pr_rec.attribute15 = OKC_API.G_MISS_CHAR ) THEN
343: l_bsd_pr_rec.attribute15 := NULL;

Line 342: IF (l_bsd_pr_rec.attribute15 = OKC_API.G_MISS_CHAR ) THEN

338: END IF;
339: IF (l_bsd_pr_rec.attribute14 = OKC_API.G_MISS_CHAR ) THEN
340: l_bsd_pr_rec.attribute14 := NULL;
341: END IF;
342: IF (l_bsd_pr_rec.attribute15 = OKC_API.G_MISS_CHAR ) THEN
343: l_bsd_pr_rec.attribute15 := NULL;
344: END IF;
345: IF (l_bsd_pr_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
346: l_bsd_pr_rec.security_group_id := NULL;

Line 345: IF (l_bsd_pr_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN

341: END IF;
342: IF (l_bsd_pr_rec.attribute15 = OKC_API.G_MISS_CHAR ) THEN
343: l_bsd_pr_rec.attribute15 := NULL;
344: END IF;
345: IF (l_bsd_pr_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
346: l_bsd_pr_rec.security_group_id := NULL;
347: END IF;
348: IF (l_bsd_pr_rec.start_reading = OKC_API.G_MISS_NUM ) THEN
349: l_bsd_pr_rec.start_reading := NULL;

Line 348: IF (l_bsd_pr_rec.start_reading = OKC_API.G_MISS_NUM ) THEN

344: END IF;
345: IF (l_bsd_pr_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
346: l_bsd_pr_rec.security_group_id := NULL;
347: END IF;
348: IF (l_bsd_pr_rec.start_reading = OKC_API.G_MISS_NUM ) THEN
349: l_bsd_pr_rec.start_reading := NULL;
350: END IF;
351: IF (l_bsd_pr_rec.end_reading = OKC_API.G_MISS_NUM ) THEN
352: l_bsd_pr_rec.end_reading := NULL;

Line 351: IF (l_bsd_pr_rec.end_reading = OKC_API.G_MISS_NUM ) THEN

347: END IF;
348: IF (l_bsd_pr_rec.start_reading = OKC_API.G_MISS_NUM ) THEN
349: l_bsd_pr_rec.start_reading := NULL;
350: END IF;
351: IF (l_bsd_pr_rec.end_reading = OKC_API.G_MISS_NUM ) THEN
352: l_bsd_pr_rec.end_reading := NULL;
353: END IF;
354: IF (l_bsd_pr_rec.base_reading = OKC_API.G_MISS_NUM ) THEN
355: l_bsd_pr_rec.base_reading := NULL;

Line 354: IF (l_bsd_pr_rec.base_reading = OKC_API.G_MISS_NUM ) THEN

350: END IF;
351: IF (l_bsd_pr_rec.end_reading = OKC_API.G_MISS_NUM ) THEN
352: l_bsd_pr_rec.end_reading := NULL;
353: END IF;
354: IF (l_bsd_pr_rec.base_reading = OKC_API.G_MISS_NUM ) THEN
355: l_bsd_pr_rec.base_reading := NULL;
356: END IF;
357: IF (l_bsd_pr_rec.estimated_quantity = OKC_API.G_MISS_NUM ) THEN
358: l_bsd_pr_rec.estimated_quantity := NULL;

Line 357: IF (l_bsd_pr_rec.estimated_quantity = OKC_API.G_MISS_NUM ) THEN

353: END IF;
354: IF (l_bsd_pr_rec.base_reading = OKC_API.G_MISS_NUM ) THEN
355: l_bsd_pr_rec.base_reading := NULL;
356: END IF;
357: IF (l_bsd_pr_rec.estimated_quantity = OKC_API.G_MISS_NUM ) THEN
358: l_bsd_pr_rec.estimated_quantity := NULL;
359: END IF;
360: IF (l_bsd_pr_rec.ccr_id = OKC_API.G_MISS_NUM ) THEN
361: l_bsd_pr_rec.ccr_id := NULL;

Line 360: IF (l_bsd_pr_rec.ccr_id = OKC_API.G_MISS_NUM ) THEN

356: END IF;
357: IF (l_bsd_pr_rec.estimated_quantity = OKC_API.G_MISS_NUM ) THEN
358: l_bsd_pr_rec.estimated_quantity := NULL;
359: END IF;
360: IF (l_bsd_pr_rec.ccr_id = OKC_API.G_MISS_NUM ) THEN
361: l_bsd_pr_rec.ccr_id := NULL;
362: END IF;
363: IF (l_bsd_pr_rec.cgr_id = OKC_API.G_MISS_NUM ) THEN
364: l_bsd_pr_rec.cgr_id := NULL;

Line 363: IF (l_bsd_pr_rec.cgr_id = OKC_API.G_MISS_NUM ) THEN

359: END IF;
360: IF (l_bsd_pr_rec.ccr_id = OKC_API.G_MISS_NUM ) THEN
361: l_bsd_pr_rec.ccr_id := NULL;
362: END IF;
363: IF (l_bsd_pr_rec.cgr_id = OKC_API.G_MISS_NUM ) THEN
364: l_bsd_pr_rec.cgr_id := NULL;
365: END IF;
366: RETURN(l_bsd_pr_rec);
367: END null_out_defaults;

Line 375: x_return_status := OKC_API.G_RET_STS_SUCCESS;

371: PROCEDURE validate_id(
372: x_return_status OUT NOCOPY VARCHAR2,
373: p_id IN NUMBER) IS
374: BEGIN
375: x_return_status := OKC_API.G_RET_STS_SUCCESS;
376: IF (p_id = OKC_API.G_MISS_NUM OR
377: p_id IS NULL)
378: THEN
379: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');

Line 376: IF (p_id = OKC_API.G_MISS_NUM OR

372: x_return_status OUT NOCOPY VARCHAR2,
373: p_id IN NUMBER) IS
374: BEGIN
375: x_return_status := OKC_API.G_RET_STS_SUCCESS;
376: IF (p_id = OKC_API.G_MISS_NUM OR
377: p_id IS NULL)
378: THEN
379: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
380: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 379: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');

375: x_return_status := OKC_API.G_RET_STS_SUCCESS;
376: IF (p_id = OKC_API.G_MISS_NUM OR
377: p_id IS NULL)
378: THEN
379: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
380: x_return_status := OKC_API.G_RET_STS_ERROR;
381: RAISE G_EXCEPTION_HALT_VALIDATION;
382: END IF;
383:

Line 380: x_return_status := OKC_API.G_RET_STS_ERROR;

376: IF (p_id = OKC_API.G_MISS_NUM OR
377: p_id IS NULL)
378: THEN
379: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
380: x_return_status := OKC_API.G_RET_STS_ERROR;
381: RAISE G_EXCEPTION_HALT_VALIDATION;
382: END IF;
383:
384: -- Verify the value fits the length of the column in the database

Line 390: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

386: ,p_col_name => 'id'
387: ,p_col_value => p_id
388: ,x_return_status => x_return_status);
389: -- verify that length is within allowed limits
390: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
391: x_return_status := OKC_API.G_RET_STS_ERROR;
392: RAISE G_EXCEPTION_HALT_VALIDATION;
393: END IF;
394: EXCEPTION

Line 391: x_return_status := OKC_API.G_RET_STS_ERROR;

387: ,p_col_value => p_id
388: ,x_return_status => x_return_status);
389: -- verify that length is within allowed limits
390: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
391: x_return_status := OKC_API.G_RET_STS_ERROR;
392: RAISE G_EXCEPTION_HALT_VALIDATION;
393: END IF;
394: EXCEPTION
395: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 398: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

394: EXCEPTION
395: WHEN G_EXCEPTION_HALT_VALIDATION THEN
396: null;
397: WHEN OTHERS THEN
398: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
399: ,p_msg_name => G_UNEXPECTED_ERROR
400: ,p_token1 => G_SQLCODE_TOKEN
401: ,p_token1_value => SQLCODE
402: ,p_token2 => G_SQLERRM_TOKEN

Line 404: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

400: ,p_token1 => G_SQLCODE_TOKEN
401: ,p_token1_value => SQLCODE
402: ,p_token2 => G_SQLERRM_TOKEN
403: ,p_token2_value => SQLERRM);
404: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
405: END validate_id;
406: -------------------------------------
407: -- Validate_Attributes for: BSL_ID --
408: -------------------------------------

Line 413: x_return_status := OKC_API.G_RET_STS_SUCCESS;

409: PROCEDURE validate_bsl_id(
410: x_return_status OUT NOCOPY VARCHAR2,
411: p_bsl_id IN NUMBER) IS
412: BEGIN
413: x_return_status := OKC_API.G_RET_STS_SUCCESS;
414: IF (p_bsl_id = OKC_API.G_MISS_NUM OR
415: p_bsl_id IS NULL)
416: THEN
417: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'bsl_id');

Line 414: IF (p_bsl_id = OKC_API.G_MISS_NUM OR

410: x_return_status OUT NOCOPY VARCHAR2,
411: p_bsl_id IN NUMBER) IS
412: BEGIN
413: x_return_status := OKC_API.G_RET_STS_SUCCESS;
414: IF (p_bsl_id = OKC_API.G_MISS_NUM OR
415: p_bsl_id IS NULL)
416: THEN
417: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'bsl_id');
418: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 417: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'bsl_id');

413: x_return_status := OKC_API.G_RET_STS_SUCCESS;
414: IF (p_bsl_id = OKC_API.G_MISS_NUM OR
415: p_bsl_id IS NULL)
416: THEN
417: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'bsl_id');
418: x_return_status := OKC_API.G_RET_STS_ERROR;
419: RAISE G_EXCEPTION_HALT_VALIDATION;
420: END IF;
421:

Line 418: x_return_status := OKC_API.G_RET_STS_ERROR;

414: IF (p_bsl_id = OKC_API.G_MISS_NUM OR
415: p_bsl_id IS NULL)
416: THEN
417: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'bsl_id');
418: x_return_status := OKC_API.G_RET_STS_ERROR;
419: RAISE G_EXCEPTION_HALT_VALIDATION;
420: END IF;
421:
422: -- Verify the value fits the length of the column in the database

Line 428: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

424: ,p_col_name => 'bsl_id'
425: ,p_col_value => p_bsl_id
426: ,x_return_status => x_return_status);
427: -- verify that length is within allowed limits
428: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
429: x_return_status := OKC_API.G_RET_STS_ERROR;
430: RAISE G_EXCEPTION_HALT_VALIDATION;
431: END IF;
432: EXCEPTION

Line 429: x_return_status := OKC_API.G_RET_STS_ERROR;

425: ,p_col_value => p_bsl_id
426: ,x_return_status => x_return_status);
427: -- verify that length is within allowed limits
428: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
429: x_return_status := OKC_API.G_RET_STS_ERROR;
430: RAISE G_EXCEPTION_HALT_VALIDATION;
431: END IF;
432: EXCEPTION
433: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 436: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

432: EXCEPTION
433: WHEN G_EXCEPTION_HALT_VALIDATION THEN
434: null;
435: WHEN OTHERS THEN
436: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
437: ,p_msg_name => G_UNEXPECTED_ERROR
438: ,p_token1 => G_SQLCODE_TOKEN
439: ,p_token1_value => SQLCODE
440: ,p_token2 => G_SQLERRM_TOKEN

Line 442: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

438: ,p_token1 => G_SQLCODE_TOKEN
439: ,p_token1_value => SQLCODE
440: ,p_token2 => G_SQLERRM_TOKEN
441: ,p_token2_value => SQLERRM);
442: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
443: END validate_bsl_id;
444: ----------------------------------------------
445: -- Validate_Attributes for: BSL_ID_AVERAGED --
446: ----------------------------------------------

Line 451: x_return_status := OKC_API.G_RET_STS_SUCCESS;

447: PROCEDURE validate_bsl_id_averaged(
448: x_return_status OUT NOCOPY VARCHAR2,
449: p_bsl_id_averaged IN NUMBER) IS
450: BEGIN
451: x_return_status := OKC_API.G_RET_STS_SUCCESS;
452: IF (p_bsl_id_averaged = OKC_API.G_MISS_NUM OR
453: p_bsl_id_averaged IS NULL)
454: THEN
455: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'bsl_id_averaged');

Line 452: IF (p_bsl_id_averaged = OKC_API.G_MISS_NUM OR

448: x_return_status OUT NOCOPY VARCHAR2,
449: p_bsl_id_averaged IN NUMBER) IS
450: BEGIN
451: x_return_status := OKC_API.G_RET_STS_SUCCESS;
452: IF (p_bsl_id_averaged = OKC_API.G_MISS_NUM OR
453: p_bsl_id_averaged IS NULL)
454: THEN
455: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'bsl_id_averaged');
456: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 455: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'bsl_id_averaged');

451: x_return_status := OKC_API.G_RET_STS_SUCCESS;
452: IF (p_bsl_id_averaged = OKC_API.G_MISS_NUM OR
453: p_bsl_id_averaged IS NULL)
454: THEN
455: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'bsl_id_averaged');
456: x_return_status := OKC_API.G_RET_STS_ERROR;
457: RAISE G_EXCEPTION_HALT_VALIDATION;
458: END IF;
459:

Line 456: x_return_status := OKC_API.G_RET_STS_ERROR;

452: IF (p_bsl_id_averaged = OKC_API.G_MISS_NUM OR
453: p_bsl_id_averaged IS NULL)
454: THEN
455: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'bsl_id_averaged');
456: x_return_status := OKC_API.G_RET_STS_ERROR;
457: RAISE G_EXCEPTION_HALT_VALIDATION;
458: END IF;
459:
460: -- Verify the value fits the length of the column in the database

Line 466: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

462: ,p_col_name => 'bsl_id_averaged'
463: ,p_col_value => p_bsl_id_averaged
464: ,x_return_status => x_return_status);
465: -- verify that length is within allowed limits
466: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
467: x_return_status := OKC_API.G_RET_STS_ERROR;
468: RAISE G_EXCEPTION_HALT_VALIDATION;
469: END IF;
470: EXCEPTION

Line 467: x_return_status := OKC_API.G_RET_STS_ERROR;

463: ,p_col_value => p_bsl_id_averaged
464: ,x_return_status => x_return_status);
465: -- verify that length is within allowed limits
466: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
467: x_return_status := OKC_API.G_RET_STS_ERROR;
468: RAISE G_EXCEPTION_HALT_VALIDATION;
469: END IF;
470: EXCEPTION
471: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 474: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

470: EXCEPTION
471: WHEN G_EXCEPTION_HALT_VALIDATION THEN
472: null;
473: WHEN OTHERS THEN
474: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
475: ,p_msg_name => G_UNEXPECTED_ERROR
476: ,p_token1 => G_SQLCODE_TOKEN
477: ,p_token1_value => SQLCODE
478: ,p_token2 => G_SQLERRM_TOKEN

Line 480: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

476: ,p_token1 => G_SQLCODE_TOKEN
477: ,p_token1_value => SQLCODE
478: ,p_token2 => G_SQLERRM_TOKEN
479: ,p_token2_value => SQLERRM);
480: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
481: END validate_bsl_id_averaged;
482: ----------------------------------------------
483: -- Validate_Attributes for: UNIT_OF_MEASURE --
484: ----------------------------------------------

Line 489: x_return_status := OKC_API.G_RET_STS_SUCCESS;

485: PROCEDURE validate_unit_of_measure(
486: x_return_status OUT NOCOPY VARCHAR2,
487: p_unit_of_measure IN VARCHAR2) IS
488: BEGIN
489: x_return_status := OKC_API.G_RET_STS_SUCCESS;
490: IF (p_unit_of_measure = OKC_API.G_MISS_CHAR OR
491: p_unit_of_measure IS NULL)
492: THEN
493: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'unit_of_measure');

Line 490: IF (p_unit_of_measure = OKC_API.G_MISS_CHAR OR

486: x_return_status OUT NOCOPY VARCHAR2,
487: p_unit_of_measure IN VARCHAR2) IS
488: BEGIN
489: x_return_status := OKC_API.G_RET_STS_SUCCESS;
490: IF (p_unit_of_measure = OKC_API.G_MISS_CHAR OR
491: p_unit_of_measure IS NULL)
492: THEN
493: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'unit_of_measure');
494: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 493: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'unit_of_measure');

489: x_return_status := OKC_API.G_RET_STS_SUCCESS;
490: IF (p_unit_of_measure = OKC_API.G_MISS_CHAR OR
491: p_unit_of_measure IS NULL)
492: THEN
493: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'unit_of_measure');
494: x_return_status := OKC_API.G_RET_STS_ERROR;
495: RAISE G_EXCEPTION_HALT_VALIDATION;
496: END IF;
497:

Line 494: x_return_status := OKC_API.G_RET_STS_ERROR;

490: IF (p_unit_of_measure = OKC_API.G_MISS_CHAR OR
491: p_unit_of_measure IS NULL)
492: THEN
493: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'unit_of_measure');
494: x_return_status := OKC_API.G_RET_STS_ERROR;
495: RAISE G_EXCEPTION_HALT_VALIDATION;
496: END IF;
497:
498: -- Verify the value fits the length of the column in the database

Line 504: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

500: ,p_col_name => 'unit_of_measure'
501: ,p_col_value => p_unit_of_measure
502: ,x_return_status => x_return_status);
503: -- verify that length is within allowed limits
504: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
505: x_return_status := OKC_API.G_RET_STS_ERROR;
506: RAISE G_EXCEPTION_HALT_VALIDATION;
507: END IF;
508: EXCEPTION

Line 505: x_return_status := OKC_API.G_RET_STS_ERROR;

501: ,p_col_value => p_unit_of_measure
502: ,x_return_status => x_return_status);
503: -- verify that length is within allowed limits
504: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
505: x_return_status := OKC_API.G_RET_STS_ERROR;
506: RAISE G_EXCEPTION_HALT_VALIDATION;
507: END IF;
508: EXCEPTION
509: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 512: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

508: EXCEPTION
509: WHEN G_EXCEPTION_HALT_VALIDATION THEN
510: null;
511: WHEN OTHERS THEN
512: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
513: ,p_msg_name => G_UNEXPECTED_ERROR
514: ,p_token1 => G_SQLCODE_TOKEN
515: ,p_token1_value => SQLCODE
516: ,p_token2 => G_SQLERRM_TOKEN

Line 518: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

514: ,p_token1 => G_SQLCODE_TOKEN
515: ,p_token1_value => SQLCODE
516: ,p_token2 => G_SQLERRM_TOKEN
517: ,p_token2_value => SQLERRM);
518: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
519: END validate_unit_of_measure;
520: --------------------------------------
521: -- Validate_Attributes for: AMCV_YN --
522: --------------------------------------

Line 527: x_return_status := OKC_API.G_RET_STS_SUCCESS;

523: PROCEDURE validate_amcv_yn(
524: x_return_status OUT NOCOPY VARCHAR2,
525: p_amcv_yn IN VARCHAR2) IS
526: BEGIN
527: x_return_status := OKC_API.G_RET_STS_SUCCESS;
528: IF (p_amcv_yn = OKC_API.G_MISS_CHAR OR
529: p_amcv_yn IS NULL)
530: THEN
531: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'amcv_yn');

Line 528: IF (p_amcv_yn = OKC_API.G_MISS_CHAR OR

524: x_return_status OUT NOCOPY VARCHAR2,
525: p_amcv_yn IN VARCHAR2) IS
526: BEGIN
527: x_return_status := OKC_API.G_RET_STS_SUCCESS;
528: IF (p_amcv_yn = OKC_API.G_MISS_CHAR OR
529: p_amcv_yn IS NULL)
530: THEN
531: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'amcv_yn');
532: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 531: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'amcv_yn');

527: x_return_status := OKC_API.G_RET_STS_SUCCESS;
528: IF (p_amcv_yn = OKC_API.G_MISS_CHAR OR
529: p_amcv_yn IS NULL)
530: THEN
531: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'amcv_yn');
532: x_return_status := OKC_API.G_RET_STS_ERROR;
533: RAISE G_EXCEPTION_HALT_VALIDATION;
534: END IF;
535:

Line 532: x_return_status := OKC_API.G_RET_STS_ERROR;

528: IF (p_amcv_yn = OKC_API.G_MISS_CHAR OR
529: p_amcv_yn IS NULL)
530: THEN
531: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'amcv_yn');
532: x_return_status := OKC_API.G_RET_STS_ERROR;
533: RAISE G_EXCEPTION_HALT_VALIDATION;
534: END IF;
535:
536: -- Verify the value fits the length of the column in the database

Line 542: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

538: ,p_col_name => 'amcv_yn'
539: ,p_col_value => p_amcv_yn
540: ,x_return_status => x_return_status);
541: -- verify that length is within allowed limits
542: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
543: x_return_status := OKC_API.G_RET_STS_ERROR;
544: RAISE G_EXCEPTION_HALT_VALIDATION;
545: END IF;
546: EXCEPTION

Line 543: x_return_status := OKC_API.G_RET_STS_ERROR;

539: ,p_col_value => p_amcv_yn
540: ,x_return_status => x_return_status);
541: -- verify that length is within allowed limits
542: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
543: x_return_status := OKC_API.G_RET_STS_ERROR;
544: RAISE G_EXCEPTION_HALT_VALIDATION;
545: END IF;
546: EXCEPTION
547: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 550: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

546: EXCEPTION
547: WHEN G_EXCEPTION_HALT_VALIDATION THEN
548: null;
549: WHEN OTHERS THEN
550: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
551: ,p_msg_name => G_UNEXPECTED_ERROR
552: ,p_token1 => G_SQLCODE_TOKEN
553: ,p_token1_value => SQLCODE
554: ,p_token2 => G_SQLERRM_TOKEN

Line 556: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

552: ,p_token1 => G_SQLCODE_TOKEN
553: ,p_token1_value => SQLCODE
554: ,p_token2 => G_SQLERRM_TOKEN
555: ,p_token2_value => SQLERRM);
556: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
557: END validate_amcv_yn;
558: -------------------------------------
559: -- Validate_Attributes for: RESULT --
560: -------------------------------------

Line 565: x_return_status := OKC_API.G_RET_STS_SUCCESS;

561: PROCEDURE validate_result(
562: x_return_status OUT NOCOPY VARCHAR2,
563: p_result IN NUMBER) IS
564: BEGIN
565: x_return_status := OKC_API.G_RET_STS_SUCCESS;
566: IF (p_result = OKC_API.G_MISS_NUM OR
567: p_result IS NULL)
568: THEN
569: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'result');

Line 566: IF (p_result = OKC_API.G_MISS_NUM OR

562: x_return_status OUT NOCOPY VARCHAR2,
563: p_result IN NUMBER) IS
564: BEGIN
565: x_return_status := OKC_API.G_RET_STS_SUCCESS;
566: IF (p_result = OKC_API.G_MISS_NUM OR
567: p_result IS NULL)
568: THEN
569: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'result');
570: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 569: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'result');

565: x_return_status := OKC_API.G_RET_STS_SUCCESS;
566: IF (p_result = OKC_API.G_MISS_NUM OR
567: p_result IS NULL)
568: THEN
569: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'result');
570: x_return_status := OKC_API.G_RET_STS_ERROR;
571: RAISE G_EXCEPTION_HALT_VALIDATION;
572: END IF;
573:

Line 570: x_return_status := OKC_API.G_RET_STS_ERROR;

566: IF (p_result = OKC_API.G_MISS_NUM OR
567: p_result IS NULL)
568: THEN
569: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'result');
570: x_return_status := OKC_API.G_RET_STS_ERROR;
571: RAISE G_EXCEPTION_HALT_VALIDATION;
572: END IF;
573:
574: -- Verify the value fits the length of the column in the database

Line 580: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

576: ,p_col_name => 'result'
577: ,p_col_value => p_result
578: ,x_return_status => x_return_status);
579: -- verify that length is within allowed limits
580: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
581: x_return_status := OKC_API.G_RET_STS_ERROR;
582: RAISE G_EXCEPTION_HALT_VALIDATION;
583: END IF;
584: EXCEPTION

Line 581: x_return_status := OKC_API.G_RET_STS_ERROR;

577: ,p_col_value => p_result
578: ,x_return_status => x_return_status);
579: -- verify that length is within allowed limits
580: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
581: x_return_status := OKC_API.G_RET_STS_ERROR;
582: RAISE G_EXCEPTION_HALT_VALIDATION;
583: END IF;
584: EXCEPTION
585: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 588: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

584: EXCEPTION
585: WHEN G_EXCEPTION_HALT_VALIDATION THEN
586: null;
587: WHEN OTHERS THEN
588: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
589: ,p_msg_name => G_UNEXPECTED_ERROR
590: ,p_token1 => G_SQLCODE_TOKEN
591: ,p_token1_value => SQLCODE
592: ,p_token2 => G_SQLERRM_TOKEN

Line 594: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

590: ,p_token1 => G_SQLCODE_TOKEN
591: ,p_token1_value => SQLCODE
592: ,p_token2 => G_SQLERRM_TOKEN
593: ,p_token2_value => SQLERRM);
594: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
595: END validate_result;
596: -------------------------------------
597: -- Validate_Attributes for: AMOUNT --
598: -------------------------------------

Line 603: x_return_status := OKC_API.G_RET_STS_SUCCESS;

599: PROCEDURE validate_amount(
600: x_return_status OUT NOCOPY VARCHAR2,
601: p_amount IN NUMBER) IS
602: BEGIN
603: x_return_status := OKC_API.G_RET_STS_SUCCESS;
604: IF (p_amount = OKC_API.G_MISS_NUM OR
605: p_amount IS NULL)
606: THEN
607: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'amount');

Line 604: IF (p_amount = OKC_API.G_MISS_NUM OR

600: x_return_status OUT NOCOPY VARCHAR2,
601: p_amount IN NUMBER) IS
602: BEGIN
603: x_return_status := OKC_API.G_RET_STS_SUCCESS;
604: IF (p_amount = OKC_API.G_MISS_NUM OR
605: p_amount IS NULL)
606: THEN
607: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'amount');
608: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 607: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'amount');

603: x_return_status := OKC_API.G_RET_STS_SUCCESS;
604: IF (p_amount = OKC_API.G_MISS_NUM OR
605: p_amount IS NULL)
606: THEN
607: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'amount');
608: x_return_status := OKC_API.G_RET_STS_ERROR;
609: RAISE G_EXCEPTION_HALT_VALIDATION;
610: END IF;
611:

Line 608: x_return_status := OKC_API.G_RET_STS_ERROR;

604: IF (p_amount = OKC_API.G_MISS_NUM OR
605: p_amount IS NULL)
606: THEN
607: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'amount');
608: x_return_status := OKC_API.G_RET_STS_ERROR;
609: RAISE G_EXCEPTION_HALT_VALIDATION;
610: END IF;
611:
612: -- Verify the value fits the length of the column in the database

Line 618: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

614: ,p_col_name => 'amount'
615: ,p_col_value => p_amount
616: ,x_return_status => x_return_status);
617: -- verify that length is within allowed limits
618: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
619: x_return_status := OKC_API.G_RET_STS_ERROR;
620: RAISE G_EXCEPTION_HALT_VALIDATION;
621: END IF;
622: EXCEPTION

Line 619: x_return_status := OKC_API.G_RET_STS_ERROR;

615: ,p_col_value => p_amount
616: ,x_return_status => x_return_status);
617: -- verify that length is within allowed limits
618: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
619: x_return_status := OKC_API.G_RET_STS_ERROR;
620: RAISE G_EXCEPTION_HALT_VALIDATION;
621: END IF;
622: EXCEPTION
623: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 626: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

622: EXCEPTION
623: WHEN G_EXCEPTION_HALT_VALIDATION THEN
624: null;
625: WHEN OTHERS THEN
626: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
627: ,p_msg_name => G_UNEXPECTED_ERROR
628: ,p_token1 => G_SQLCODE_TOKEN
629: ,p_token1_value => SQLCODE
630: ,p_token2 => G_SQLERRM_TOKEN

Line 632: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

628: ,p_token1 => G_SQLCODE_TOKEN
629: ,p_token1_value => SQLCODE
630: ,p_token2 => G_SQLERRM_TOKEN
631: ,p_token2_value => SQLERRM);
632: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
633: END validate_amount;
634: ----------------------------------------------------
635: -- Validate_Attributes for: OBJECT_VERSION_NUMBER --
636: ----------------------------------------------------

Line 641: x_return_status := OKC_API.G_RET_STS_SUCCESS;

637: PROCEDURE validate_object_version_number(
638: x_return_status OUT NOCOPY VARCHAR2,
639: p_object_version_number IN NUMBER) IS
640: BEGIN
641: x_return_status := OKC_API.G_RET_STS_SUCCESS;
642: IF (p_object_version_number = OKC_API.G_MISS_NUM OR
643: p_object_version_number IS NULL)
644: THEN
645: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');

Line 642: IF (p_object_version_number = OKC_API.G_MISS_NUM OR

638: x_return_status OUT NOCOPY VARCHAR2,
639: p_object_version_number IN NUMBER) IS
640: BEGIN
641: x_return_status := OKC_API.G_RET_STS_SUCCESS;
642: IF (p_object_version_number = OKC_API.G_MISS_NUM OR
643: p_object_version_number IS NULL)
644: THEN
645: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
646: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 645: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');

641: x_return_status := OKC_API.G_RET_STS_SUCCESS;
642: IF (p_object_version_number = OKC_API.G_MISS_NUM OR
643: p_object_version_number IS NULL)
644: THEN
645: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
646: x_return_status := OKC_API.G_RET_STS_ERROR;
647: RAISE G_EXCEPTION_HALT_VALIDATION;
648: END IF;
649:

Line 646: x_return_status := OKC_API.G_RET_STS_ERROR;

642: IF (p_object_version_number = OKC_API.G_MISS_NUM OR
643: p_object_version_number IS NULL)
644: THEN
645: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
646: x_return_status := OKC_API.G_RET_STS_ERROR;
647: RAISE G_EXCEPTION_HALT_VALIDATION;
648: END IF;
649:
650: -- Verify the value fits the length of the column in the database

Line 656: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

652: ,p_col_name => 'object_version_number'
653: ,p_col_value => p_object_version_number
654: ,x_return_status => x_return_status);
655: -- verify that length is within allowed limits
656: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
657: x_return_status := OKC_API.G_RET_STS_ERROR;
658: RAISE G_EXCEPTION_HALT_VALIDATION;
659: END IF;
660: EXCEPTION

Line 657: x_return_status := OKC_API.G_RET_STS_ERROR;

653: ,p_col_value => p_object_version_number
654: ,x_return_status => x_return_status);
655: -- verify that length is within allowed limits
656: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
657: x_return_status := OKC_API.G_RET_STS_ERROR;
658: RAISE G_EXCEPTION_HALT_VALIDATION;
659: END IF;
660: EXCEPTION
661: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 664: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

660: EXCEPTION
661: WHEN G_EXCEPTION_HALT_VALIDATION THEN
662: null;
663: WHEN OTHERS THEN
664: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
665: ,p_msg_name => G_UNEXPECTED_ERROR
666: ,p_token1 => G_SQLCODE_TOKEN
667: ,p_token1_value => SQLCODE
668: ,p_token2 => G_SQLERRM_TOKEN

Line 670: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

666: ,p_token1 => G_SQLCODE_TOKEN
667: ,p_token1_value => SQLCODE
668: ,p_token2 => G_SQLERRM_TOKEN
669: ,p_token2_value => SQLERRM);
670: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
671: END validate_object_version_number;
672: ---------------------------------------------------------------------------
673: -- FUNCTION Validate_Attributes
674: ---------------------------------------------------------------------------

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

677: ----------------------------------------
678: FUNCTION Validate_Attributes (
679: p_bsd_pr_rec IN bsd_pr_rec_type
680: ) RETURN VARCHAR2 IS
681: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
682: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
683: BEGIN
684: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
685: OKC_UTIL.ADD_VIEW('OKS_BSD_PR', x_return_status);

Line 682: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

678: FUNCTION Validate_Attributes (
679: p_bsd_pr_rec IN bsd_pr_rec_type
680: ) RETURN VARCHAR2 IS
681: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
682: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
683: BEGIN
684: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
685: OKC_UTIL.ADD_VIEW('OKS_BSD_PR', x_return_status);
686: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

Line 686: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

682: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
683: BEGIN
684: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
685: OKC_UTIL.ADD_VIEW('OKS_BSD_PR', x_return_status);
686: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
687: l_return_status := x_return_status;
688: RAISE G_EXCEPTION_HALT_VALIDATION;
689: END IF;
690: -----------------------------

Line 697: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

693: -- ***
694: -- id
695: -- ***
696: validate_id(x_return_status, p_bsd_pr_rec.id);
697: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
698: l_return_status := x_return_status;
699: RAISE G_EXCEPTION_HALT_VALIDATION;
700: END IF;
701:

Line 706: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

702: -- ***
703: -- bsl_id
704: -- ***
705: validate_bsl_id(x_return_status, p_bsd_pr_rec.bsl_id);
706: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
707: l_return_status := x_return_status;
708: RAISE G_EXCEPTION_HALT_VALIDATION;
709: END IF;
710:

Line 715: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

711: -- ***
712: -- bsl_id_averaged
713: -- ***
714: validate_bsl_id_averaged(x_return_status, p_bsd_pr_rec.bsl_id_averaged);
715: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
716: l_return_status := x_return_status;
717: RAISE G_EXCEPTION_HALT_VALIDATION;
718: END IF;
719:

Line 724: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

720: -- ***
721: -- unit_of_measure
722: -- ***
723: validate_unit_of_measure(x_return_status, p_bsd_pr_rec.unit_of_measure);
724: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
725: l_return_status := x_return_status;
726: RAISE G_EXCEPTION_HALT_VALIDATION;
727: END IF;
728:

Line 733: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

729: -- ***
730: -- amcv_yn
731: -- ***
732: validate_amcv_yn(x_return_status, p_bsd_pr_rec.amcv_yn);
733: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
734: l_return_status := x_return_status;
735: RAISE G_EXCEPTION_HALT_VALIDATION;
736: END IF;
737:

Line 742: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

738: -- ***
739: -- result
740: -- ***
741: validate_result(x_return_status, p_bsd_pr_rec.result);
742: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
743: l_return_status := x_return_status;
744: RAISE G_EXCEPTION_HALT_VALIDATION;
745: END IF;
746:

Line 751: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

747: -- ***
748: -- amount
749: -- ***
750: validate_amount(x_return_status, p_bsd_pr_rec.amount);
751: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
752: l_return_status := x_return_status;
753: RAISE G_EXCEPTION_HALT_VALIDATION;
754: END IF;
755:

Line 760: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

756: -- ***
757: -- object_version_number
758: -- ***
759: validate_object_version_number(x_return_status, p_bsd_pr_rec.object_version_number);
760: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
761: l_return_status := x_return_status;
762: RAISE G_EXCEPTION_HALT_VALIDATION;
763: END IF;
764:

Line 770: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

766: EXCEPTION
767: WHEN G_EXCEPTION_HALT_VALIDATION THEN
768: RETURN(l_return_status);
769: WHEN OTHERS THEN
770: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
771: ,p_msg_name => G_UNEXPECTED_ERROR
772: ,p_token1 => G_SQLCODE_TOKEN
773: ,p_token1_value => SQLCODE
774: ,p_token2 => G_SQLERRM_TOKEN

Line 776: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

772: ,p_token1 => G_SQLCODE_TOKEN
773: ,p_token1_value => SQLCODE
774: ,p_token2 => G_SQLERRM_TOKEN
775: ,p_token2_value => SQLERRM);
776: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
777: RETURN(l_return_status);
778: END Validate_Attributes;
779: ---------------------------------------------------------------------------
780: -- PROCEDURE Validate_Record

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

785: FUNCTION Validate_Record (
786: p_bsd_pr_rec IN bsd_pr_rec_type,
787: p_db_bsd_pr_rec IN bsd_pr_rec_type
788: ) RETURN VARCHAR2 IS
789: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
790: ------------------------------------
791: -- FUNCTION validate_foreign_keys --
792: ------------------------------------
793: FUNCTION validate_foreign_keys (

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

806: FROM Oks_Bsd_Pr
807: WHERE oks_bsd_pr.id = p_id;
808: l_oks_bsd_pr_pk oks_bsd_pr_pk_csr%ROWTYPE;
809:
810: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
811: l_row_notfound BOOLEAN := TRUE;
812: BEGIN
813: IF ((p_bsd_pr_rec.BSD_ID IS NOT NULL)
814: AND

Line 822: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BSD_ID');

818: FETCH oks_bsd_pr_pk_csr INTO l_oks_bsd_pr_pk;
819: l_row_notfound := oks_bsd_pr_pk_csr%NOTFOUND;
820: CLOSE oks_bsd_pr_pk_csr;
821: IF (l_row_notfound) THEN
822: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BSD_ID');
823: RAISE item_not_found_error;
824: END IF;
825: END IF;
826: IF ((p_bsd_pr_rec.BSD_ID_APPLIED IS NOT NULL)

Line 835: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BSD_ID_APPLIED');

831: FETCH oks_bsd_pr_pk_csr INTO l_oks_bsd_pr_pk;
832: l_row_notfound := oks_bsd_pr_pk_csr%NOTFOUND;
833: CLOSE oks_bsd_pr_pk_csr;
834: IF (l_row_notfound) THEN
835: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BSD_ID_APPLIED');
836: RAISE item_not_found_error;
837: END IF;
838: END IF;
839: IF ((p_bsd_pr_rec.BSL_ID_AVERAGED IS NOT NULL)

Line 848: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BSL_ID_AVERAGED');

844: FETCH oks_bsl_pr_pk_csr INTO l_oks_bsl_pr_pk;
845: l_row_notfound := oks_bsl_pr_pk_csr%NOTFOUND;
846: CLOSE oks_bsl_pr_pk_csr;
847: IF (l_row_notfound) THEN
848: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BSL_ID_AVERAGED');
849: RAISE item_not_found_error;
850: END IF;
851: END IF;
852: IF ((p_bsd_pr_rec.BSL_ID IS NOT NULL)

Line 861: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BSL_ID');

857: FETCH oks_bsl_pr_pk_csr INTO l_oks_bsl_pr_pk;
858: l_row_notfound := oks_bsl_pr_pk_csr%NOTFOUND;
859: CLOSE oks_bsl_pr_pk_csr;
860: IF (l_row_notfound) THEN
861: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BSL_ID');
862: RAISE item_not_found_error;
863: END IF;
864: END IF;
865: RETURN (l_return_status);

Line 868: l_return_status := OKC_API.G_RET_STS_ERROR;

864: END IF;
865: RETURN (l_return_status);
866: EXCEPTION
867: WHEN item_not_found_error THEN
868: l_return_status := OKC_API.G_RET_STS_ERROR;
869: RETURN (l_return_status);
870: END validate_foreign_keys;
871: BEGIN
872: l_return_status := validate_foreign_keys(p_bsd_pr_rec, p_db_bsd_pr_rec);

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

874: END Validate_Record;
875: FUNCTION Validate_Record (
876: p_bsd_pr_rec IN bsd_pr_rec_type
877: ) RETURN VARCHAR2 IS
878: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
879: l_db_bsd_pr_rec bsd_pr_rec_type := get_rec(p_bsd_pr_rec);
880: BEGIN
881: l_return_status := Validate_Record(p_bsd_pr_rec => p_bsd_pr_rec,
882: p_db_bsd_pr_rec => l_db_bsd_pr_rec);

Line 996: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

992: -- validate_row for:OKS_BSD_PR --
993: ---------------------------------
994: PROCEDURE validate_row(
995: p_api_version IN NUMBER,
996: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
997: x_return_status OUT NOCOPY VARCHAR2,
998: x_msg_count OUT NOCOPY NUMBER,
999: x_msg_data OUT NOCOPY VARCHAR2,
1000: p_bsd_pr_rec IN bsd_pr_rec_type) IS

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

1000: p_bsd_pr_rec IN bsd_pr_rec_type) IS
1001:
1002: l_api_version CONSTANT NUMBER := 1;
1003: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1004: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1005: l_bsd_pr_rec bsd_pr_rec_type := p_bsd_pr_rec;
1006:
1007: BEGIN
1008: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

1004: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1005: l_bsd_pr_rec bsd_pr_rec_type := p_bsd_pr_rec;
1006:
1007: BEGIN
1008: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1009: G_PKG_NAME,
1010: p_init_msg_list,
1011: l_api_version,
1012: p_api_version,

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

1011: l_api_version,
1012: p_api_version,
1013: '_PVT',
1014: x_return_status);
1015: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1016: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1017: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1018: RAISE OKC_API.G_EXCEPTION_ERROR;
1019: END IF;

Line 1016: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1012: p_api_version,
1013: '_PVT',
1014: x_return_status);
1015: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1016: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1017: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1018: RAISE OKC_API.G_EXCEPTION_ERROR;
1019: END IF;
1020: --- Validate all non-missing attributes (Item Level Validation)

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

1013: '_PVT',
1014: x_return_status);
1015: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1016: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1017: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1018: RAISE OKC_API.G_EXCEPTION_ERROR;
1019: END IF;
1020: --- Validate all non-missing attributes (Item Level Validation)
1021: l_return_status := Validate_Attributes(l_bsd_pr_rec);

Line 1018: RAISE OKC_API.G_EXCEPTION_ERROR;

1014: x_return_status);
1015: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1016: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1017: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1018: RAISE OKC_API.G_EXCEPTION_ERROR;
1019: END IF;
1020: --- Validate all non-missing attributes (Item Level Validation)
1021: l_return_status := Validate_Attributes(l_bsd_pr_rec);
1022: --- If any errors happen abort API

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

1019: END IF;
1020: --- Validate all non-missing attributes (Item Level Validation)
1021: l_return_status := Validate_Attributes(l_bsd_pr_rec);
1022: --- If any errors happen abort API
1023: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1026: RAISE OKC_API.G_EXCEPTION_ERROR;
1027: END IF;

Line 1024: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1020: --- Validate all non-missing attributes (Item Level Validation)
1021: l_return_status := Validate_Attributes(l_bsd_pr_rec);
1022: --- If any errors happen abort API
1023: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1026: RAISE OKC_API.G_EXCEPTION_ERROR;
1027: END IF;
1028: l_return_status := Validate_Record(l_bsd_pr_rec);

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

1021: l_return_status := Validate_Attributes(l_bsd_pr_rec);
1022: --- If any errors happen abort API
1023: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1026: RAISE OKC_API.G_EXCEPTION_ERROR;
1027: END IF;
1028: l_return_status := Validate_Record(l_bsd_pr_rec);
1029: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1026: RAISE OKC_API.G_EXCEPTION_ERROR;

1022: --- If any errors happen abort API
1023: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1026: RAISE OKC_API.G_EXCEPTION_ERROR;
1027: END IF;
1028: l_return_status := Validate_Record(l_bsd_pr_rec);
1029: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1030: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1025: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1026: RAISE OKC_API.G_EXCEPTION_ERROR;
1027: END IF;
1028: l_return_status := Validate_Record(l_bsd_pr_rec);
1029: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1030: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1031: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1032: RAISE OKC_API.G_EXCEPTION_ERROR;
1033: END IF;

Line 1030: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1026: RAISE OKC_API.G_EXCEPTION_ERROR;
1027: END IF;
1028: l_return_status := Validate_Record(l_bsd_pr_rec);
1029: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1030: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1031: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1032: RAISE OKC_API.G_EXCEPTION_ERROR;
1033: END IF;
1034: x_return_status := l_return_status;

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

1027: END IF;
1028: l_return_status := Validate_Record(l_bsd_pr_rec);
1029: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1030: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1031: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1032: RAISE OKC_API.G_EXCEPTION_ERROR;
1033: END IF;
1034: x_return_status := l_return_status;
1035: EXCEPTION

Line 1032: RAISE OKC_API.G_EXCEPTION_ERROR;

1028: l_return_status := Validate_Record(l_bsd_pr_rec);
1029: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1030: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1031: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1032: RAISE OKC_API.G_EXCEPTION_ERROR;
1033: END IF;
1034: x_return_status := l_return_status;
1035: EXCEPTION
1036: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1036: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1032: RAISE OKC_API.G_EXCEPTION_ERROR;
1033: END IF;
1034: x_return_status := l_return_status;
1035: EXCEPTION
1036: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1037: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1038: (
1039: l_api_name,
1040: G_PKG_NAME,

Line 1037: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1033: END IF;
1034: x_return_status := l_return_status;
1035: EXCEPTION
1036: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1037: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1038: (
1039: l_api_name,
1040: G_PKG_NAME,
1041: 'OKC_API.G_RET_STS_ERROR',

Line 1041: 'OKC_API.G_RET_STS_ERROR',

1037: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1038: (
1039: l_api_name,
1040: G_PKG_NAME,
1041: 'OKC_API.G_RET_STS_ERROR',
1042: x_msg_count,
1043: x_msg_data,
1044: '_PVT'
1045: );

Line 1046: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1042: x_msg_count,
1043: x_msg_data,
1044: '_PVT'
1045: );
1046: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1047: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1048: (
1049: l_api_name,
1050: G_PKG_NAME,

Line 1047: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1043: x_msg_data,
1044: '_PVT'
1045: );
1046: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1047: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1048: (
1049: l_api_name,
1050: G_PKG_NAME,
1051: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1051: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1047: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1048: (
1049: l_api_name,
1050: G_PKG_NAME,
1051: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1052: x_msg_count,
1053: x_msg_data,
1054: '_PVT'
1055: );

Line 1057: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1053: x_msg_data,
1054: '_PVT'
1055: );
1056: WHEN OTHERS THEN
1057: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1058: (
1059: l_api_name,
1060: G_PKG_NAME,
1061: 'OTHERS',

Line 1072: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1068: -- PL/SQL TBL validate_row for:OKS_BSD_PR --
1069: --------------------------------------------
1070: PROCEDURE validate_row(
1071: p_api_version IN NUMBER,
1072: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1073: x_return_status OUT NOCOPY VARCHAR2,
1074: x_msg_count OUT NOCOPY NUMBER,
1075: x_msg_data OUT NOCOPY VARCHAR2,
1076: p_bsd_pr_tbl IN bsd_pr_tbl_type,

Line 1083: OKC_API.init_msg_list(p_init_msg_list);

1079: l_api_version CONSTANT NUMBER := 1;
1080: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
1081: i NUMBER := 0;
1082: BEGIN
1083: OKC_API.init_msg_list(p_init_msg_list);
1084: -- Make sure PL/SQL table has records in it before passing
1085: IF (p_bsd_pr_tbl.COUNT > 0) THEN
1086: i := p_bsd_pr_tbl.FIRST;
1087: LOOP

Line 1096: p_init_msg_list => OKC_API.G_FALSE,

1092: l_error_rec.api_package := G_PKG_NAME;
1093: l_error_rec.idx := i;
1094: validate_row (
1095: p_api_version => p_api_version,
1096: p_init_msg_list => OKC_API.G_FALSE,
1097: x_return_status => l_error_rec.error_type,
1098: x_msg_count => l_error_rec.msg_count,
1099: x_msg_data => l_error_rec.msg_data,
1100: p_bsd_pr_rec => p_bsd_pr_tbl(i));

Line 1101: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

1097: x_return_status => l_error_rec.error_type,
1098: x_msg_count => l_error_rec.msg_count,
1099: x_msg_data => l_error_rec.msg_data,
1100: p_bsd_pr_rec => p_bsd_pr_tbl(i));
1101: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1102: l_error_rec.sqlcode := SQLCODE;
1103: load_error_tbl(l_error_rec, px_error_tbl);
1104: ELSE
1105: x_msg_count := l_error_rec.msg_count;

Line 1109: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1105: x_msg_count := l_error_rec.msg_count;
1106: x_msg_data := l_error_rec.msg_data;
1107: END IF;
1108: EXCEPTION
1109: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1110: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1111: l_error_rec.sqlcode := SQLCODE;
1112: load_error_tbl(l_error_rec, px_error_tbl);
1113: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1110: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;

1106: x_msg_data := l_error_rec.msg_data;
1107: END IF;
1108: EXCEPTION
1109: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1110: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1111: l_error_rec.sqlcode := SQLCODE;
1112: load_error_tbl(l_error_rec, px_error_tbl);
1113: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1114: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 1113: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1109: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1110: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1111: l_error_rec.sqlcode := SQLCODE;
1112: load_error_tbl(l_error_rec, px_error_tbl);
1113: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1114: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1115: l_error_rec.sqlcode := SQLCODE;
1116: load_error_tbl(l_error_rec, px_error_tbl);
1117: WHEN OTHERS THEN

Line 1114: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

1110: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1111: l_error_rec.sqlcode := SQLCODE;
1112: load_error_tbl(l_error_rec, px_error_tbl);
1113: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1114: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1115: l_error_rec.sqlcode := SQLCODE;
1116: load_error_tbl(l_error_rec, px_error_tbl);
1117: WHEN OTHERS THEN
1118: l_error_rec.error_type := 'OTHERS';

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

1125: END IF;
1126: -- Loop through the error_tbl to find the error with the highest severity
1127: -- and return it.
1128: x_return_status := find_highest_exception(px_error_tbl);
1129: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1130: EXCEPTION
1131: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1132: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1133: (

Line 1131: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1127: -- and return it.
1128: x_return_status := find_highest_exception(px_error_tbl);
1129: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1130: EXCEPTION
1131: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1132: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1133: (
1134: l_api_name,
1135: G_PKG_NAME,

Line 1132: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1128: x_return_status := find_highest_exception(px_error_tbl);
1129: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1130: EXCEPTION
1131: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1132: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1133: (
1134: l_api_name,
1135: G_PKG_NAME,
1136: 'OKC_API.G_RET_STS_ERROR',

Line 1136: 'OKC_API.G_RET_STS_ERROR',

1132: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1133: (
1134: l_api_name,
1135: G_PKG_NAME,
1136: 'OKC_API.G_RET_STS_ERROR',
1137: x_msg_count,
1138: x_msg_data,
1139: '_PVT'
1140: );

Line 1141: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1137: x_msg_count,
1138: x_msg_data,
1139: '_PVT'
1140: );
1141: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1142: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1143: (
1144: l_api_name,
1145: G_PKG_NAME,

Line 1142: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1138: x_msg_data,
1139: '_PVT'
1140: );
1141: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1142: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1143: (
1144: l_api_name,
1145: G_PKG_NAME,
1146: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1146: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1142: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1143: (
1144: l_api_name,
1145: G_PKG_NAME,
1146: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1147: x_msg_count,
1148: x_msg_data,
1149: '_PVT'
1150: );

Line 1152: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1148: x_msg_data,
1149: '_PVT'
1150: );
1151: WHEN OTHERS THEN
1152: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1153: (
1154: l_api_name,
1155: G_PKG_NAME,
1156: 'OTHERS',

Line 1168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1164: -- PL/SQL TBL validate_row for:OKS_BSD_PR --
1165: --------------------------------------------
1166: PROCEDURE validate_row(
1167: p_api_version IN NUMBER,
1168: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1169: x_return_status OUT NOCOPY VARCHAR2,
1170: x_msg_count OUT NOCOPY NUMBER,
1171: x_msg_data OUT NOCOPY VARCHAR2,
1172: p_bsd_pr_tbl IN bsd_pr_tbl_type) IS

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

1172: p_bsd_pr_tbl IN bsd_pr_tbl_type) IS
1173:
1174: l_api_version CONSTANT NUMBER := 1;
1175: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1176: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1177: l_error_tbl ERROR_TBL_TYPE;
1178: BEGIN
1179: OKC_API.init_msg_list(p_init_msg_list);
1180: -- Make sure PL/SQL table has records in it before passing

Line 1179: OKC_API.init_msg_list(p_init_msg_list);

1175: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1176: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1177: l_error_tbl ERROR_TBL_TYPE;
1178: BEGIN
1179: OKC_API.init_msg_list(p_init_msg_list);
1180: -- Make sure PL/SQL table has records in it before passing
1181: IF (p_bsd_pr_tbl.COUNT > 0) THEN
1182: validate_row (
1183: p_api_version => p_api_version,

Line 1184: p_init_msg_list => OKC_API.G_FALSE,

1180: -- Make sure PL/SQL table has records in it before passing
1181: IF (p_bsd_pr_tbl.COUNT > 0) THEN
1182: validate_row (
1183: p_api_version => p_api_version,
1184: p_init_msg_list => OKC_API.G_FALSE,
1185: x_return_status => x_return_status,
1186: x_msg_count => x_msg_count,
1187: x_msg_data => x_msg_data,
1188: p_bsd_pr_tbl => p_bsd_pr_tbl,

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

1187: x_msg_data => x_msg_data,
1188: p_bsd_pr_tbl => p_bsd_pr_tbl,
1189: px_error_tbl => l_error_tbl);
1190: END IF;
1191: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1192: EXCEPTION
1193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1194: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1195: (

Line 1193: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1189: px_error_tbl => l_error_tbl);
1190: END IF;
1191: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1192: EXCEPTION
1193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1194: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1195: (
1196: l_api_name,
1197: G_PKG_NAME,

Line 1194: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1190: END IF;
1191: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1192: EXCEPTION
1193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1194: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1195: (
1196: l_api_name,
1197: G_PKG_NAME,
1198: 'OKC_API.G_RET_STS_ERROR',

Line 1198: 'OKC_API.G_RET_STS_ERROR',

1194: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1195: (
1196: l_api_name,
1197: G_PKG_NAME,
1198: 'OKC_API.G_RET_STS_ERROR',
1199: x_msg_count,
1200: x_msg_data,
1201: '_PVT'
1202: );

Line 1203: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1199: x_msg_count,
1200: x_msg_data,
1201: '_PVT'
1202: );
1203: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_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: x_msg_data,
1201: '_PVT'
1202: );
1203: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_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_UNEXP_ERROR',

Line 1208: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1214: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1229: -- insert_row for:OKS_BSD_PR --
1230: -------------------------------
1231: PROCEDURE insert_row(
1232: p_api_version IN NUMBER,
1233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1234: x_return_status OUT NOCOPY VARCHAR2,
1235: x_msg_count OUT NOCOPY NUMBER,
1236: x_msg_data OUT NOCOPY VARCHAR2,
1237: p_bsd_pr_rec IN bsd_pr_rec_type,

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

1238: x_bsd_pr_rec OUT NOCOPY bsd_pr_rec_type) IS
1239:
1240: l_api_version CONSTANT NUMBER := 1;
1241: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1242: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1243: l_bsd_pr_rec bsd_pr_rec_type := p_bsd_pr_rec;
1244: l_def_bsd_pr_rec bsd_pr_rec_type;
1245: -----------------------------------
1246: -- Set_Attributes for:OKS_BSD_PR --

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

1248: FUNCTION Set_Attributes (
1249: p_bsd_pr_rec IN bsd_pr_rec_type,
1250: x_bsd_pr_rec OUT NOCOPY bsd_pr_rec_type
1251: ) RETURN VARCHAR2 IS
1252: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1253: BEGIN
1254: x_bsd_pr_rec := p_bsd_pr_rec;
1255: RETURN(l_return_status);
1256: END Set_Attributes;

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

1254: x_bsd_pr_rec := p_bsd_pr_rec;
1255: RETURN(l_return_status);
1256: END Set_Attributes;
1257: BEGIN
1258: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1259: p_init_msg_list,
1260: '_PVT',
1261: x_return_status);
1262: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1258: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1259: p_init_msg_list,
1260: '_PVT',
1261: x_return_status);
1262: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1264: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1265: RAISE OKC_API.G_EXCEPTION_ERROR;
1266: END IF;

Line 1263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1259: p_init_msg_list,
1260: '_PVT',
1261: x_return_status);
1262: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1264: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1265: RAISE OKC_API.G_EXCEPTION_ERROR;
1266: END IF;
1267: --- Setting item atributes

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

1260: '_PVT',
1261: x_return_status);
1262: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1264: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1265: RAISE OKC_API.G_EXCEPTION_ERROR;
1266: END IF;
1267: --- Setting item atributes
1268: l_return_status := Set_Attributes(

Line 1265: RAISE OKC_API.G_EXCEPTION_ERROR;

1261: x_return_status);
1262: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1263: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1264: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1265: RAISE OKC_API.G_EXCEPTION_ERROR;
1266: END IF;
1267: --- Setting item atributes
1268: l_return_status := Set_Attributes(
1269: p_bsd_pr_rec, -- IN

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

1268: l_return_status := Set_Attributes(
1269: p_bsd_pr_rec, -- IN
1270: l_bsd_pr_rec); -- OUT
1271: --- If any errors happen abort API
1272: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1274: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1275: RAISE OKC_API.G_EXCEPTION_ERROR;
1276: END IF;

Line 1273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1269: p_bsd_pr_rec, -- IN
1270: l_bsd_pr_rec); -- OUT
1271: --- If any errors happen abort API
1272: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1274: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1275: RAISE OKC_API.G_EXCEPTION_ERROR;
1276: END IF;
1277: INSERT INTO OKS_BSD_PR(

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

1270: l_bsd_pr_rec); -- OUT
1271: --- If any errors happen abort API
1272: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1274: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1275: RAISE OKC_API.G_EXCEPTION_ERROR;
1276: END IF;
1277: INSERT INTO OKS_BSD_PR(
1278: id,

Line 1275: RAISE OKC_API.G_EXCEPTION_ERROR;

1271: --- If any errors happen abort API
1272: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1274: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1275: RAISE OKC_API.G_EXCEPTION_ERROR;
1276: END IF;
1277: INSERT INTO OKS_BSD_PR(
1278: id,
1279: bsl_id,

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

1364: l_bsd_pr_rec.cgr_id);
1365: -- Set OUT values
1366: x_bsd_pr_rec := l_bsd_pr_rec;
1367: x_return_status := l_return_status;
1368: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1369: EXCEPTION
1370: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1371: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1372: (

Line 1370: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1366: x_bsd_pr_rec := l_bsd_pr_rec;
1367: x_return_status := l_return_status;
1368: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1369: EXCEPTION
1370: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1371: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1372: (
1373: l_api_name,
1374: G_PKG_NAME,

Line 1371: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1367: x_return_status := l_return_status;
1368: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1369: EXCEPTION
1370: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1371: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1372: (
1373: l_api_name,
1374: G_PKG_NAME,
1375: 'OKC_API.G_RET_STS_ERROR',

Line 1375: 'OKC_API.G_RET_STS_ERROR',

1371: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1372: (
1373: l_api_name,
1374: G_PKG_NAME,
1375: 'OKC_API.G_RET_STS_ERROR',
1376: x_msg_count,
1377: x_msg_data,
1378: '_PVT'
1379: );

Line 1380: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1376: x_msg_count,
1377: x_msg_data,
1378: '_PVT'
1379: );
1380: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1381: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1382: (
1383: l_api_name,
1384: G_PKG_NAME,

Line 1381: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1377: x_msg_data,
1378: '_PVT'
1379: );
1380: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1381: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1382: (
1383: l_api_name,
1384: G_PKG_NAME,
1385: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1385: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1381: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1382: (
1383: l_api_name,
1384: G_PKG_NAME,
1385: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1386: x_msg_count,
1387: x_msg_data,
1388: '_PVT'
1389: );

Line 1391: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1387: x_msg_data,
1388: '_PVT'
1389: );
1390: WHEN OTHERS THEN
1391: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1392: (
1393: l_api_name,
1394: G_PKG_NAME,
1395: 'OTHERS',

Line 1408: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1404: -----------------------------
1405: -- lock_row for:OKS_BSD_PR --
1406: -----------------------------
1407: PROCEDURE lock_row(
1408: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1409: x_return_status OUT NOCOPY VARCHAR2,
1410: x_msg_count OUT NOCOPY NUMBER,
1411: x_msg_data OUT NOCOPY VARCHAR2,
1412: p_bsd_pr_rec IN bsd_pr_rec_type) IS

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

1425: FROM OKS_BSD_PR
1426: WHERE ID = p_bsd_pr_rec.id;
1427: l_api_version CONSTANT NUMBER := 1;
1428: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1429: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1430: l_object_version_number OKS_BSD_PR.OBJECT_VERSION_NUMBER%TYPE;
1431: lc_object_version_number OKS_BSD_PR.OBJECT_VERSION_NUMBER%TYPE;
1432: l_row_notfound BOOLEAN := FALSE;
1433: lc_row_notfound BOOLEAN := FALSE;

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

1431: lc_object_version_number OKS_BSD_PR.OBJECT_VERSION_NUMBER%TYPE;
1432: l_row_notfound BOOLEAN := FALSE;
1433: lc_row_notfound BOOLEAN := FALSE;
1434: BEGIN
1435: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1436: p_init_msg_list,
1437: '_PVT',
1438: x_return_status);
1439: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1435: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1436: p_init_msg_list,
1437: '_PVT',
1438: x_return_status);
1439: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1440: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1441: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1442: RAISE OKC_API.G_EXCEPTION_ERROR;
1443: END IF;

Line 1440: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1436: p_init_msg_list,
1437: '_PVT',
1438: x_return_status);
1439: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1440: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1441: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1442: RAISE OKC_API.G_EXCEPTION_ERROR;
1443: END IF;
1444: BEGIN

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

1437: '_PVT',
1438: x_return_status);
1439: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1440: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1441: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1442: RAISE OKC_API.G_EXCEPTION_ERROR;
1443: END IF;
1444: BEGIN
1445: OPEN lock_csr(p_bsd_pr_rec);

Line 1442: RAISE OKC_API.G_EXCEPTION_ERROR;

1438: x_return_status);
1439: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1440: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1441: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1442: RAISE OKC_API.G_EXCEPTION_ERROR;
1443: END IF;
1444: BEGIN
1445: OPEN lock_csr(p_bsd_pr_rec);
1446: FETCH lock_csr INTO l_object_version_number;

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

1450: WHEN E_Resource_Busy THEN
1451: IF (lock_csr%ISOPEN) THEN
1452: CLOSE lock_csr;
1453: END IF;
1454: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1455: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1456: END;
1457:
1458: IF ( l_row_notfound ) THEN

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

1461: lc_row_notfound := lchk_csr%NOTFOUND;
1462: CLOSE lchk_csr;
1463: END IF;
1464: IF (lc_row_notfound) THEN
1465: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1466: RAISE OKC_API.G_EXCEPTION_ERROR;
1467: ELSIF lc_object_version_number > p_bsd_pr_rec.object_version_number THEN
1468: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1469: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1466: RAISE OKC_API.G_EXCEPTION_ERROR;

1462: CLOSE lchk_csr;
1463: END IF;
1464: IF (lc_row_notfound) THEN
1465: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1466: RAISE OKC_API.G_EXCEPTION_ERROR;
1467: ELSIF lc_object_version_number > p_bsd_pr_rec.object_version_number THEN
1468: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1469: RAISE OKC_API.G_EXCEPTION_ERROR;
1470: ELSIF lc_object_version_number <> p_bsd_pr_rec.object_version_number THEN

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

1464: IF (lc_row_notfound) THEN
1465: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1466: RAISE OKC_API.G_EXCEPTION_ERROR;
1467: ELSIF lc_object_version_number > p_bsd_pr_rec.object_version_number THEN
1468: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1469: RAISE OKC_API.G_EXCEPTION_ERROR;
1470: ELSIF lc_object_version_number <> p_bsd_pr_rec.object_version_number THEN
1471: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1472: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1469: RAISE OKC_API.G_EXCEPTION_ERROR;

1465: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1466: RAISE OKC_API.G_EXCEPTION_ERROR;
1467: ELSIF lc_object_version_number > p_bsd_pr_rec.object_version_number THEN
1468: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1469: RAISE OKC_API.G_EXCEPTION_ERROR;
1470: ELSIF lc_object_version_number <> p_bsd_pr_rec.object_version_number THEN
1471: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: ELSIF lc_object_version_number = -1 THEN

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

1467: ELSIF lc_object_version_number > p_bsd_pr_rec.object_version_number THEN
1468: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1469: RAISE OKC_API.G_EXCEPTION_ERROR;
1470: ELSIF lc_object_version_number <> p_bsd_pr_rec.object_version_number THEN
1471: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: ELSIF lc_object_version_number = -1 THEN
1474: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1475: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1472: RAISE OKC_API.G_EXCEPTION_ERROR;

1468: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1469: RAISE OKC_API.G_EXCEPTION_ERROR;
1470: ELSIF lc_object_version_number <> p_bsd_pr_rec.object_version_number THEN
1471: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: ELSIF lc_object_version_number = -1 THEN
1474: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;

Line 1474: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1470: ELSIF lc_object_version_number <> p_bsd_pr_rec.object_version_number THEN
1471: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: ELSIF lc_object_version_number = -1 THEN
1474: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477: x_return_status := l_return_status;
1478: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1475: RAISE OKC_API.G_EXCEPTION_ERROR;

1471: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: ELSIF lc_object_version_number = -1 THEN
1474: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477: x_return_status := l_return_status;
1478: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1479: EXCEPTION

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

1474: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477: x_return_status := l_return_status;
1478: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1479: EXCEPTION
1480: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1481: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1482: (

Line 1480: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1476: END IF;
1477: x_return_status := l_return_status;
1478: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1479: EXCEPTION
1480: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1481: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1482: (
1483: l_api_name,
1484: G_PKG_NAME,

Line 1481: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1477: x_return_status := l_return_status;
1478: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1479: EXCEPTION
1480: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1481: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1482: (
1483: l_api_name,
1484: G_PKG_NAME,
1485: 'OKC_API.G_RET_STS_ERROR',

Line 1485: 'OKC_API.G_RET_STS_ERROR',

1481: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1482: (
1483: l_api_name,
1484: G_PKG_NAME,
1485: 'OKC_API.G_RET_STS_ERROR',
1486: x_msg_count,
1487: x_msg_data,
1488: '_PVT'
1489: );

Line 1490: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1486: x_msg_count,
1487: x_msg_data,
1488: '_PVT'
1489: );
1490: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1491: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1492: (
1493: l_api_name,
1494: G_PKG_NAME,

Line 1491: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1487: x_msg_data,
1488: '_PVT'
1489: );
1490: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1491: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1492: (
1493: l_api_name,
1494: G_PKG_NAME,
1495: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1495: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1491: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1492: (
1493: l_api_name,
1494: G_PKG_NAME,
1495: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1496: x_msg_count,
1497: x_msg_data,
1498: '_PVT'
1499: );

Line 1501: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1497: x_msg_data,
1498: '_PVT'
1499: );
1500: WHEN OTHERS THEN
1501: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1502: (
1503: l_api_name,
1504: G_PKG_NAME,
1505: 'OTHERS',

Line 1516: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1512: -- lock_row for: OKS_BSD_PR --
1513: ------------------------------
1514: PROCEDURE lock_row(
1515: p_api_version IN NUMBER,
1516: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1517: x_return_status OUT NOCOPY VARCHAR2,
1518: x_msg_count OUT NOCOPY NUMBER,
1519: x_msg_data OUT NOCOPY VARCHAR2,
1520: p_bsd_pr_rec IN bsd_pr_rec_type) IS

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

1520: p_bsd_pr_rec IN bsd_pr_rec_type) IS
1521:
1522: l_api_version CONSTANT NUMBER := 1;
1523: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1524: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1525: l_bsd_pr_rec bsd_pr_rec_type;
1526: BEGIN
1527: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1528: G_PKG_NAME,

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

1523: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1524: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1525: l_bsd_pr_rec bsd_pr_rec_type;
1526: BEGIN
1527: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1528: G_PKG_NAME,
1529: p_init_msg_list,
1530: l_api_version,
1531: p_api_version,

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

1530: l_api_version,
1531: p_api_version,
1532: '_PVT',
1533: x_return_status);
1534: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1537: RAISE OKC_API.G_EXCEPTION_ERROR;
1538: END IF;

Line 1535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1531: p_api_version,
1532: '_PVT',
1533: x_return_status);
1534: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1537: RAISE OKC_API.G_EXCEPTION_ERROR;
1538: END IF;
1539: -----------------------------------------

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

1532: '_PVT',
1533: x_return_status);
1534: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1537: RAISE OKC_API.G_EXCEPTION_ERROR;
1538: END IF;
1539: -----------------------------------------
1540: -- Move VIEW record to "Child" records --

Line 1537: RAISE OKC_API.G_EXCEPTION_ERROR;

1533: x_return_status);
1534: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1537: RAISE OKC_API.G_EXCEPTION_ERROR;
1538: END IF;
1539: -----------------------------------------
1540: -- Move VIEW record to "Child" records --
1541: -----------------------------------------

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

1549: x_msg_count,
1550: x_msg_data,
1551: l_bsd_pr_rec
1552: );
1553: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1556: RAISE OKC_API.G_EXCEPTION_ERROR;
1557: END IF;

Line 1554: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1550: x_msg_data,
1551: l_bsd_pr_rec
1552: );
1553: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1556: RAISE OKC_API.G_EXCEPTION_ERROR;
1557: END IF;
1558: x_return_status := l_return_status;

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

1551: l_bsd_pr_rec
1552: );
1553: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1556: RAISE OKC_API.G_EXCEPTION_ERROR;
1557: END IF;
1558: x_return_status := l_return_status;
1559: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1556: RAISE OKC_API.G_EXCEPTION_ERROR;

1552: );
1553: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1556: RAISE OKC_API.G_EXCEPTION_ERROR;
1557: END IF;
1558: x_return_status := l_return_status;
1559: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1560: EXCEPTION

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

1555: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1556: RAISE OKC_API.G_EXCEPTION_ERROR;
1557: END IF;
1558: x_return_status := l_return_status;
1559: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1560: EXCEPTION
1561: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1562: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1563: (

Line 1561: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1557: END IF;
1558: x_return_status := l_return_status;
1559: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1560: EXCEPTION
1561: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1562: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1563: (
1564: l_api_name,
1565: G_PKG_NAME,

Line 1562: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1558: x_return_status := l_return_status;
1559: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1560: EXCEPTION
1561: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1562: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1563: (
1564: l_api_name,
1565: G_PKG_NAME,
1566: 'OKC_API.G_RET_STS_ERROR',

Line 1566: 'OKC_API.G_RET_STS_ERROR',

1562: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1563: (
1564: l_api_name,
1565: G_PKG_NAME,
1566: 'OKC_API.G_RET_STS_ERROR',
1567: x_msg_count,
1568: x_msg_data,
1569: '_PVT'
1570: );

Line 1571: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1567: x_msg_count,
1568: x_msg_data,
1569: '_PVT'
1570: );
1571: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1572: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1573: (
1574: l_api_name,
1575: G_PKG_NAME,

Line 1572: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1568: x_msg_data,
1569: '_PVT'
1570: );
1571: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1572: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1573: (
1574: l_api_name,
1575: G_PKG_NAME,
1576: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1576: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1572: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1573: (
1574: l_api_name,
1575: G_PKG_NAME,
1576: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1577: x_msg_count,
1578: x_msg_data,
1579: '_PVT'
1580: );

Line 1582: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1578: x_msg_data,
1579: '_PVT'
1580: );
1581: WHEN OTHERS THEN
1582: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1583: (
1584: l_api_name,
1585: G_PKG_NAME,
1586: 'OTHERS',

Line 1597: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1593: -- PL/SQL TBL lock_row for:BSD_PR_TBL --
1594: ----------------------------------------
1595: PROCEDURE lock_row(
1596: p_api_version IN NUMBER,
1597: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1598: x_return_status OUT NOCOPY VARCHAR2,
1599: x_msg_count OUT NOCOPY NUMBER,
1600: x_msg_data OUT NOCOPY VARCHAR2,
1601: p_bsd_pr_tbl IN bsd_pr_tbl_type,

Line 1608: OKC_API.init_msg_list(p_init_msg_list);

1604: l_api_version CONSTANT NUMBER := 1;
1605: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1606: i NUMBER := 0;
1607: BEGIN
1608: OKC_API.init_msg_list(p_init_msg_list);
1609: -- Make sure PL/SQL table has recrods in it before passing
1610: IF (p_bsd_pr_tbl.COUNT > 0) THEN
1611: i := p_bsd_pr_tbl.FIRST;
1612: LOOP

Line 1621: p_init_msg_list => OKC_API.G_FALSE,

1617: l_error_rec.api_package := G_PKG_NAME;
1618: l_error_rec.idx := i;
1619: lock_row(
1620: p_api_version => p_api_version,
1621: p_init_msg_list => OKC_API.G_FALSE,
1622: x_return_status => l_error_rec.error_type,
1623: x_msg_count => l_error_rec.msg_count,
1624: x_msg_data => l_error_rec.msg_data,
1625: p_bsd_pr_rec => p_bsd_pr_tbl(i));

Line 1626: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

1622: x_return_status => l_error_rec.error_type,
1623: x_msg_count => l_error_rec.msg_count,
1624: x_msg_data => l_error_rec.msg_data,
1625: p_bsd_pr_rec => p_bsd_pr_tbl(i));
1626: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1627: l_error_rec.sqlcode := SQLCODE;
1628: load_error_tbl(l_error_rec, px_error_tbl);
1629: ELSE
1630: x_msg_count := l_error_rec.msg_count;

Line 1634: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1630: x_msg_count := l_error_rec.msg_count;
1631: x_msg_data := l_error_rec.msg_data;
1632: END IF;
1633: EXCEPTION
1634: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1635: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1636: l_error_rec.sqlcode := SQLCODE;
1637: load_error_tbl(l_error_rec, px_error_tbl);
1638: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1635: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;

1631: x_msg_data := l_error_rec.msg_data;
1632: END IF;
1633: EXCEPTION
1634: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1635: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1636: l_error_rec.sqlcode := SQLCODE;
1637: load_error_tbl(l_error_rec, px_error_tbl);
1638: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1639: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 1638: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1634: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1635: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1636: l_error_rec.sqlcode := SQLCODE;
1637: load_error_tbl(l_error_rec, px_error_tbl);
1638: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1639: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1640: l_error_rec.sqlcode := SQLCODE;
1641: load_error_tbl(l_error_rec, px_error_tbl);
1642: WHEN OTHERS THEN

Line 1639: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

1635: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1636: l_error_rec.sqlcode := SQLCODE;
1637: load_error_tbl(l_error_rec, px_error_tbl);
1638: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1639: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1640: l_error_rec.sqlcode := SQLCODE;
1641: load_error_tbl(l_error_rec, px_error_tbl);
1642: WHEN OTHERS THEN
1643: l_error_rec.error_type := 'OTHERS';

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

1650: END IF;
1651: -- Loop through the error_tbl to find the error with the highest severity
1652: -- and return it.
1653: x_return_status := find_highest_exception(px_error_tbl);
1654: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1655: EXCEPTION
1656: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1657: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1658: (

Line 1656: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1652: -- and return it.
1653: x_return_status := find_highest_exception(px_error_tbl);
1654: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1655: EXCEPTION
1656: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1657: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1658: (
1659: l_api_name,
1660: G_PKG_NAME,

Line 1657: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1653: x_return_status := find_highest_exception(px_error_tbl);
1654: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1655: EXCEPTION
1656: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1657: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1658: (
1659: l_api_name,
1660: G_PKG_NAME,
1661: 'OKC_API.G_RET_STS_ERROR',

Line 1661: 'OKC_API.G_RET_STS_ERROR',

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

Line 1666: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1667: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1671: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1677: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1692: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1688: -- PL/SQL TBL lock_row for:BSD_PR_TBL --
1689: ----------------------------------------
1690: PROCEDURE lock_row(
1691: p_api_version IN NUMBER,
1692: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1693: x_return_status OUT NOCOPY VARCHAR2,
1694: x_msg_count OUT NOCOPY NUMBER,
1695: x_msg_data OUT NOCOPY VARCHAR2,
1696: p_bsd_pr_tbl IN bsd_pr_tbl_type) IS

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

1696: p_bsd_pr_tbl IN bsd_pr_tbl_type) IS
1697:
1698: l_api_version CONSTANT NUMBER := 1;
1699: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1700: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1701: l_error_tbl ERROR_TBL_TYPE;
1702: BEGIN
1703: OKC_API.init_msg_list(p_init_msg_list);
1704: -- Make sure PL/SQL table has recrods in it before passing

Line 1703: OKC_API.init_msg_list(p_init_msg_list);

1699: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1700: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1701: l_error_tbl ERROR_TBL_TYPE;
1702: BEGIN
1703: OKC_API.init_msg_list(p_init_msg_list);
1704: -- Make sure PL/SQL table has recrods in it before passing
1705: IF (p_bsd_pr_tbl.COUNT > 0) THEN
1706: lock_row(
1707: p_api_version => p_api_version,

Line 1708: p_init_msg_list => OKC_API.G_FALSE,

1704: -- Make sure PL/SQL table has recrods in it before passing
1705: IF (p_bsd_pr_tbl.COUNT > 0) THEN
1706: lock_row(
1707: p_api_version => p_api_version,
1708: p_init_msg_list => OKC_API.G_FALSE,
1709: x_return_status => x_return_status,
1710: x_msg_count => x_msg_count,
1711: x_msg_data => x_msg_data,
1712: p_bsd_pr_tbl => p_bsd_pr_tbl,

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

1711: x_msg_data => x_msg_data,
1712: p_bsd_pr_tbl => p_bsd_pr_tbl,
1713: px_error_tbl => l_error_tbl);
1714: END IF;
1715: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1716: EXCEPTION
1717: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1718: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1719: (

Line 1717: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1713: px_error_tbl => l_error_tbl);
1714: END IF;
1715: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1716: EXCEPTION
1717: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1718: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1719: (
1720: l_api_name,
1721: G_PKG_NAME,

Line 1718: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1714: END IF;
1715: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1716: EXCEPTION
1717: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1718: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1719: (
1720: l_api_name,
1721: G_PKG_NAME,
1722: 'OKC_API.G_RET_STS_ERROR',

Line 1722: 'OKC_API.G_RET_STS_ERROR',

1718: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1719: (
1720: l_api_name,
1721: G_PKG_NAME,
1722: 'OKC_API.G_RET_STS_ERROR',
1723: x_msg_count,
1724: x_msg_data,
1725: '_PVT'
1726: );

Line 1727: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1723: x_msg_count,
1724: x_msg_data,
1725: '_PVT'
1726: );
1727: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1728: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1729: (
1730: l_api_name,
1731: G_PKG_NAME,

Line 1728: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1724: x_msg_data,
1725: '_PVT'
1726: );
1727: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1728: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1729: (
1730: l_api_name,
1731: G_PKG_NAME,
1732: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1732: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1728: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1729: (
1730: l_api_name,
1731: G_PKG_NAME,
1732: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1733: x_msg_count,
1734: x_msg_data,
1735: '_PVT'
1736: );

Line 1738: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1734: x_msg_data,
1735: '_PVT'
1736: );
1737: WHEN OTHERS THEN
1738: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1739: (
1740: l_api_name,
1741: G_PKG_NAME,
1742: 'OTHERS',

Line 1755: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1751: -------------------------------
1752: -- update_row for:OKS_BSD_PR --
1753: -------------------------------
1754: PROCEDURE update_row(
1755: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1756: x_return_status OUT NOCOPY VARCHAR2,
1757: x_msg_count OUT NOCOPY NUMBER,
1758: x_msg_data OUT NOCOPY VARCHAR2,
1759: p_bsd_pr_rec IN bsd_pr_rec_type,

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

1760: x_bsd_pr_rec OUT NOCOPY bsd_pr_rec_type) IS
1761:
1762: l_api_version CONSTANT NUMBER := 1;
1763: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1764: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1765: l_bsd_pr_rec bsd_pr_rec_type := p_bsd_pr_rec;
1766: l_def_bsd_pr_rec bsd_pr_rec_type;
1767: l_row_notfound BOOLEAN := TRUE;
1768: ----------------------------------

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

1773: x_bsd_pr_rec OUT NOCOPY bsd_pr_rec_type
1774: ) RETURN VARCHAR2 IS
1775: l_bsd_pr_rec bsd_pr_rec_type;
1776: l_row_notfound BOOLEAN := TRUE;
1777: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1778: BEGIN
1779: x_bsd_pr_rec := p_bsd_pr_rec;
1780: -- Get current database values
1781: l_bsd_pr_rec := get_rec(p_bsd_pr_rec, l_return_status);

Line 1782: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1778: BEGIN
1779: x_bsd_pr_rec := p_bsd_pr_rec;
1780: -- Get current database values
1781: l_bsd_pr_rec := get_rec(p_bsd_pr_rec, l_return_status);
1782: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1783: IF (x_bsd_pr_rec.id = OKC_API.G_MISS_NUM)
1784: THEN
1785: x_bsd_pr_rec.id := l_bsd_pr_rec.id;
1786: END IF;

Line 1783: IF (x_bsd_pr_rec.id = OKC_API.G_MISS_NUM)

1779: x_bsd_pr_rec := p_bsd_pr_rec;
1780: -- Get current database values
1781: l_bsd_pr_rec := get_rec(p_bsd_pr_rec, l_return_status);
1782: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1783: IF (x_bsd_pr_rec.id = OKC_API.G_MISS_NUM)
1784: THEN
1785: x_bsd_pr_rec.id := l_bsd_pr_rec.id;
1786: END IF;
1787: IF (x_bsd_pr_rec.bsl_id = OKC_API.G_MISS_NUM)

Line 1787: IF (x_bsd_pr_rec.bsl_id = OKC_API.G_MISS_NUM)

1783: IF (x_bsd_pr_rec.id = OKC_API.G_MISS_NUM)
1784: THEN
1785: x_bsd_pr_rec.id := l_bsd_pr_rec.id;
1786: END IF;
1787: IF (x_bsd_pr_rec.bsl_id = OKC_API.G_MISS_NUM)
1788: THEN
1789: x_bsd_pr_rec.bsl_id := l_bsd_pr_rec.bsl_id;
1790: END IF;
1791: IF (x_bsd_pr_rec.bsl_id_averaged = OKC_API.G_MISS_NUM)

Line 1791: IF (x_bsd_pr_rec.bsl_id_averaged = OKC_API.G_MISS_NUM)

1787: IF (x_bsd_pr_rec.bsl_id = OKC_API.G_MISS_NUM)
1788: THEN
1789: x_bsd_pr_rec.bsl_id := l_bsd_pr_rec.bsl_id;
1790: END IF;
1791: IF (x_bsd_pr_rec.bsl_id_averaged = OKC_API.G_MISS_NUM)
1792: THEN
1793: x_bsd_pr_rec.bsl_id_averaged := l_bsd_pr_rec.bsl_id_averaged;
1794: END IF;
1795: IF (x_bsd_pr_rec.bsd_id = OKC_API.G_MISS_NUM)

Line 1795: IF (x_bsd_pr_rec.bsd_id = OKC_API.G_MISS_NUM)

1791: IF (x_bsd_pr_rec.bsl_id_averaged = OKC_API.G_MISS_NUM)
1792: THEN
1793: x_bsd_pr_rec.bsl_id_averaged := l_bsd_pr_rec.bsl_id_averaged;
1794: END IF;
1795: IF (x_bsd_pr_rec.bsd_id = OKC_API.G_MISS_NUM)
1796: THEN
1797: x_bsd_pr_rec.bsd_id := l_bsd_pr_rec.bsd_id;
1798: END IF;
1799: IF (x_bsd_pr_rec.bsd_id_applied = OKC_API.G_MISS_NUM)

Line 1799: IF (x_bsd_pr_rec.bsd_id_applied = OKC_API.G_MISS_NUM)

1795: IF (x_bsd_pr_rec.bsd_id = OKC_API.G_MISS_NUM)
1796: THEN
1797: x_bsd_pr_rec.bsd_id := l_bsd_pr_rec.bsd_id;
1798: END IF;
1799: IF (x_bsd_pr_rec.bsd_id_applied = OKC_API.G_MISS_NUM)
1800: THEN
1801: x_bsd_pr_rec.bsd_id_applied := l_bsd_pr_rec.bsd_id_applied;
1802: END IF;
1803: IF (x_bsd_pr_rec.unit_of_measure = OKC_API.G_MISS_CHAR)

Line 1803: IF (x_bsd_pr_rec.unit_of_measure = OKC_API.G_MISS_CHAR)

1799: IF (x_bsd_pr_rec.bsd_id_applied = OKC_API.G_MISS_NUM)
1800: THEN
1801: x_bsd_pr_rec.bsd_id_applied := l_bsd_pr_rec.bsd_id_applied;
1802: END IF;
1803: IF (x_bsd_pr_rec.unit_of_measure = OKC_API.G_MISS_CHAR)
1804: THEN
1805: x_bsd_pr_rec.unit_of_measure := l_bsd_pr_rec.unit_of_measure;
1806: END IF;
1807: IF (x_bsd_pr_rec.amcv_yn = OKC_API.G_MISS_CHAR)

Line 1807: IF (x_bsd_pr_rec.amcv_yn = OKC_API.G_MISS_CHAR)

1803: IF (x_bsd_pr_rec.unit_of_measure = OKC_API.G_MISS_CHAR)
1804: THEN
1805: x_bsd_pr_rec.unit_of_measure := l_bsd_pr_rec.unit_of_measure;
1806: END IF;
1807: IF (x_bsd_pr_rec.amcv_yn = OKC_API.G_MISS_CHAR)
1808: THEN
1809: x_bsd_pr_rec.amcv_yn := l_bsd_pr_rec.amcv_yn;
1810: END IF;
1811: IF (x_bsd_pr_rec.result = OKC_API.G_MISS_NUM)

Line 1811: IF (x_bsd_pr_rec.result = OKC_API.G_MISS_NUM)

1807: IF (x_bsd_pr_rec.amcv_yn = OKC_API.G_MISS_CHAR)
1808: THEN
1809: x_bsd_pr_rec.amcv_yn := l_bsd_pr_rec.amcv_yn;
1810: END IF;
1811: IF (x_bsd_pr_rec.result = OKC_API.G_MISS_NUM)
1812: THEN
1813: x_bsd_pr_rec.result := l_bsd_pr_rec.result;
1814: END IF;
1815: IF (x_bsd_pr_rec.amount = OKC_API.G_MISS_NUM)

Line 1815: IF (x_bsd_pr_rec.amount = OKC_API.G_MISS_NUM)

1811: IF (x_bsd_pr_rec.result = OKC_API.G_MISS_NUM)
1812: THEN
1813: x_bsd_pr_rec.result := l_bsd_pr_rec.result;
1814: END IF;
1815: IF (x_bsd_pr_rec.amount = OKC_API.G_MISS_NUM)
1816: THEN
1817: x_bsd_pr_rec.amount := l_bsd_pr_rec.amount;
1818: END IF;
1819: IF (x_bsd_pr_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1819: IF (x_bsd_pr_rec.object_version_number = OKC_API.G_MISS_NUM)

1815: IF (x_bsd_pr_rec.amount = OKC_API.G_MISS_NUM)
1816: THEN
1817: x_bsd_pr_rec.amount := l_bsd_pr_rec.amount;
1818: END IF;
1819: IF (x_bsd_pr_rec.object_version_number = OKC_API.G_MISS_NUM)
1820: THEN
1821: x_bsd_pr_rec.object_version_number := l_bsd_pr_rec.object_version_number;
1822: END IF;
1823: IF (x_bsd_pr_rec.created_by = OKC_API.G_MISS_NUM)

Line 1823: IF (x_bsd_pr_rec.created_by = OKC_API.G_MISS_NUM)

1819: IF (x_bsd_pr_rec.object_version_number = OKC_API.G_MISS_NUM)
1820: THEN
1821: x_bsd_pr_rec.object_version_number := l_bsd_pr_rec.object_version_number;
1822: END IF;
1823: IF (x_bsd_pr_rec.created_by = OKC_API.G_MISS_NUM)
1824: THEN
1825: x_bsd_pr_rec.created_by := l_bsd_pr_rec.created_by;
1826: END IF;
1827: IF (x_bsd_pr_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1827: IF (x_bsd_pr_rec.creation_date = OKC_API.G_MISS_DATE)

1823: IF (x_bsd_pr_rec.created_by = OKC_API.G_MISS_NUM)
1824: THEN
1825: x_bsd_pr_rec.created_by := l_bsd_pr_rec.created_by;
1826: END IF;
1827: IF (x_bsd_pr_rec.creation_date = OKC_API.G_MISS_DATE)
1828: THEN
1829: x_bsd_pr_rec.creation_date := l_bsd_pr_rec.creation_date;
1830: END IF;
1831: IF (x_bsd_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1831: IF (x_bsd_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)

1827: IF (x_bsd_pr_rec.creation_date = OKC_API.G_MISS_DATE)
1828: THEN
1829: x_bsd_pr_rec.creation_date := l_bsd_pr_rec.creation_date;
1830: END IF;
1831: IF (x_bsd_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)
1832: THEN
1833: x_bsd_pr_rec.last_updated_by := l_bsd_pr_rec.last_updated_by;
1834: END IF;
1835: IF (x_bsd_pr_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1835: IF (x_bsd_pr_rec.last_update_date = OKC_API.G_MISS_DATE)

1831: IF (x_bsd_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)
1832: THEN
1833: x_bsd_pr_rec.last_updated_by := l_bsd_pr_rec.last_updated_by;
1834: END IF;
1835: IF (x_bsd_pr_rec.last_update_date = OKC_API.G_MISS_DATE)
1836: THEN
1837: x_bsd_pr_rec.last_update_date := l_bsd_pr_rec.last_update_date;
1838: END IF;
1839: IF (x_bsd_pr_rec.fixed = OKC_API.G_MISS_NUM)

Line 1839: IF (x_bsd_pr_rec.fixed = OKC_API.G_MISS_NUM)

1835: IF (x_bsd_pr_rec.last_update_date = OKC_API.G_MISS_DATE)
1836: THEN
1837: x_bsd_pr_rec.last_update_date := l_bsd_pr_rec.last_update_date;
1838: END IF;
1839: IF (x_bsd_pr_rec.fixed = OKC_API.G_MISS_NUM)
1840: THEN
1841: x_bsd_pr_rec.fixed := l_bsd_pr_rec.fixed;
1842: END IF;
1843: IF (x_bsd_pr_rec.actual = OKC_API.G_MISS_NUM)

Line 1843: IF (x_bsd_pr_rec.actual = OKC_API.G_MISS_NUM)

1839: IF (x_bsd_pr_rec.fixed = OKC_API.G_MISS_NUM)
1840: THEN
1841: x_bsd_pr_rec.fixed := l_bsd_pr_rec.fixed;
1842: END IF;
1843: IF (x_bsd_pr_rec.actual = OKC_API.G_MISS_NUM)
1844: THEN
1845: x_bsd_pr_rec.actual := l_bsd_pr_rec.actual;
1846: END IF;
1847: IF (x_bsd_pr_rec.default_default = OKC_API.G_MISS_NUM)

Line 1847: IF (x_bsd_pr_rec.default_default = OKC_API.G_MISS_NUM)

1843: IF (x_bsd_pr_rec.actual = OKC_API.G_MISS_NUM)
1844: THEN
1845: x_bsd_pr_rec.actual := l_bsd_pr_rec.actual;
1846: END IF;
1847: IF (x_bsd_pr_rec.default_default = OKC_API.G_MISS_NUM)
1848: THEN
1849: x_bsd_pr_rec.default_default := l_bsd_pr_rec.default_default;
1850: END IF;
1851: IF (x_bsd_pr_rec.adjustment_level = OKC_API.G_MISS_NUM)

Line 1851: IF (x_bsd_pr_rec.adjustment_level = OKC_API.G_MISS_NUM)

1847: IF (x_bsd_pr_rec.default_default = OKC_API.G_MISS_NUM)
1848: THEN
1849: x_bsd_pr_rec.default_default := l_bsd_pr_rec.default_default;
1850: END IF;
1851: IF (x_bsd_pr_rec.adjustment_level = OKC_API.G_MISS_NUM)
1852: THEN
1853: x_bsd_pr_rec.adjustment_level := l_bsd_pr_rec.adjustment_level;
1854: END IF;
1855: IF (x_bsd_pr_rec.adjustment_minimum = OKC_API.G_MISS_NUM)

Line 1855: IF (x_bsd_pr_rec.adjustment_minimum = OKC_API.G_MISS_NUM)

1851: IF (x_bsd_pr_rec.adjustment_level = OKC_API.G_MISS_NUM)
1852: THEN
1853: x_bsd_pr_rec.adjustment_level := l_bsd_pr_rec.adjustment_level;
1854: END IF;
1855: IF (x_bsd_pr_rec.adjustment_minimum = OKC_API.G_MISS_NUM)
1856: THEN
1857: x_bsd_pr_rec.adjustment_minimum := l_bsd_pr_rec.adjustment_minimum;
1858: END IF;
1859: IF (x_bsd_pr_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1859: IF (x_bsd_pr_rec.last_update_login = OKC_API.G_MISS_NUM)

1855: IF (x_bsd_pr_rec.adjustment_minimum = OKC_API.G_MISS_NUM)
1856: THEN
1857: x_bsd_pr_rec.adjustment_minimum := l_bsd_pr_rec.adjustment_minimum;
1858: END IF;
1859: IF (x_bsd_pr_rec.last_update_login = OKC_API.G_MISS_NUM)
1860: THEN
1861: x_bsd_pr_rec.last_update_login := l_bsd_pr_rec.last_update_login;
1862: END IF;
1863: IF (x_bsd_pr_rec.attribute_category = OKC_API.G_MISS_CHAR)

Line 1863: IF (x_bsd_pr_rec.attribute_category = OKC_API.G_MISS_CHAR)

1859: IF (x_bsd_pr_rec.last_update_login = OKC_API.G_MISS_NUM)
1860: THEN
1861: x_bsd_pr_rec.last_update_login := l_bsd_pr_rec.last_update_login;
1862: END IF;
1863: IF (x_bsd_pr_rec.attribute_category = OKC_API.G_MISS_CHAR)
1864: THEN
1865: x_bsd_pr_rec.attribute_category := l_bsd_pr_rec.attribute_category;
1866: END IF;
1867: IF (x_bsd_pr_rec.attribute1 = OKC_API.G_MISS_CHAR)

Line 1867: IF (x_bsd_pr_rec.attribute1 = OKC_API.G_MISS_CHAR)

1863: IF (x_bsd_pr_rec.attribute_category = OKC_API.G_MISS_CHAR)
1864: THEN
1865: x_bsd_pr_rec.attribute_category := l_bsd_pr_rec.attribute_category;
1866: END IF;
1867: IF (x_bsd_pr_rec.attribute1 = OKC_API.G_MISS_CHAR)
1868: THEN
1869: x_bsd_pr_rec.attribute1 := l_bsd_pr_rec.attribute1;
1870: END IF;
1871: IF (x_bsd_pr_rec.attribute2 = OKC_API.G_MISS_CHAR)

Line 1871: IF (x_bsd_pr_rec.attribute2 = OKC_API.G_MISS_CHAR)

1867: IF (x_bsd_pr_rec.attribute1 = OKC_API.G_MISS_CHAR)
1868: THEN
1869: x_bsd_pr_rec.attribute1 := l_bsd_pr_rec.attribute1;
1870: END IF;
1871: IF (x_bsd_pr_rec.attribute2 = OKC_API.G_MISS_CHAR)
1872: THEN
1873: x_bsd_pr_rec.attribute2 := l_bsd_pr_rec.attribute2;
1874: END IF;
1875: IF (x_bsd_pr_rec.attribute3 = OKC_API.G_MISS_CHAR)

Line 1875: IF (x_bsd_pr_rec.attribute3 = OKC_API.G_MISS_CHAR)

1871: IF (x_bsd_pr_rec.attribute2 = OKC_API.G_MISS_CHAR)
1872: THEN
1873: x_bsd_pr_rec.attribute2 := l_bsd_pr_rec.attribute2;
1874: END IF;
1875: IF (x_bsd_pr_rec.attribute3 = OKC_API.G_MISS_CHAR)
1876: THEN
1877: x_bsd_pr_rec.attribute3 := l_bsd_pr_rec.attribute3;
1878: END IF;
1879: IF (x_bsd_pr_rec.attribute4 = OKC_API.G_MISS_CHAR)

Line 1879: IF (x_bsd_pr_rec.attribute4 = OKC_API.G_MISS_CHAR)

1875: IF (x_bsd_pr_rec.attribute3 = OKC_API.G_MISS_CHAR)
1876: THEN
1877: x_bsd_pr_rec.attribute3 := l_bsd_pr_rec.attribute3;
1878: END IF;
1879: IF (x_bsd_pr_rec.attribute4 = OKC_API.G_MISS_CHAR)
1880: THEN
1881: x_bsd_pr_rec.attribute4 := l_bsd_pr_rec.attribute4;
1882: END IF;
1883: IF (x_bsd_pr_rec.attribute5 = OKC_API.G_MISS_CHAR)

Line 1883: IF (x_bsd_pr_rec.attribute5 = OKC_API.G_MISS_CHAR)

1879: IF (x_bsd_pr_rec.attribute4 = OKC_API.G_MISS_CHAR)
1880: THEN
1881: x_bsd_pr_rec.attribute4 := l_bsd_pr_rec.attribute4;
1882: END IF;
1883: IF (x_bsd_pr_rec.attribute5 = OKC_API.G_MISS_CHAR)
1884: THEN
1885: x_bsd_pr_rec.attribute5 := l_bsd_pr_rec.attribute5;
1886: END IF;
1887: IF (x_bsd_pr_rec.attribute6 = OKC_API.G_MISS_CHAR)

Line 1887: IF (x_bsd_pr_rec.attribute6 = OKC_API.G_MISS_CHAR)

1883: IF (x_bsd_pr_rec.attribute5 = OKC_API.G_MISS_CHAR)
1884: THEN
1885: x_bsd_pr_rec.attribute5 := l_bsd_pr_rec.attribute5;
1886: END IF;
1887: IF (x_bsd_pr_rec.attribute6 = OKC_API.G_MISS_CHAR)
1888: THEN
1889: x_bsd_pr_rec.attribute6 := l_bsd_pr_rec.attribute6;
1890: END IF;
1891: IF (x_bsd_pr_rec.attribute7 = OKC_API.G_MISS_CHAR)

Line 1891: IF (x_bsd_pr_rec.attribute7 = OKC_API.G_MISS_CHAR)

1887: IF (x_bsd_pr_rec.attribute6 = OKC_API.G_MISS_CHAR)
1888: THEN
1889: x_bsd_pr_rec.attribute6 := l_bsd_pr_rec.attribute6;
1890: END IF;
1891: IF (x_bsd_pr_rec.attribute7 = OKC_API.G_MISS_CHAR)
1892: THEN
1893: x_bsd_pr_rec.attribute7 := l_bsd_pr_rec.attribute7;
1894: END IF;
1895: IF (x_bsd_pr_rec.attribute8 = OKC_API.G_MISS_CHAR)

Line 1895: IF (x_bsd_pr_rec.attribute8 = OKC_API.G_MISS_CHAR)

1891: IF (x_bsd_pr_rec.attribute7 = OKC_API.G_MISS_CHAR)
1892: THEN
1893: x_bsd_pr_rec.attribute7 := l_bsd_pr_rec.attribute7;
1894: END IF;
1895: IF (x_bsd_pr_rec.attribute8 = OKC_API.G_MISS_CHAR)
1896: THEN
1897: x_bsd_pr_rec.attribute8 := l_bsd_pr_rec.attribute8;
1898: END IF;
1899: IF (x_bsd_pr_rec.attribute9 = OKC_API.G_MISS_CHAR)

Line 1899: IF (x_bsd_pr_rec.attribute9 = OKC_API.G_MISS_CHAR)

1895: IF (x_bsd_pr_rec.attribute8 = OKC_API.G_MISS_CHAR)
1896: THEN
1897: x_bsd_pr_rec.attribute8 := l_bsd_pr_rec.attribute8;
1898: END IF;
1899: IF (x_bsd_pr_rec.attribute9 = OKC_API.G_MISS_CHAR)
1900: THEN
1901: x_bsd_pr_rec.attribute9 := l_bsd_pr_rec.attribute9;
1902: END IF;
1903: IF (x_bsd_pr_rec.attribute10 = OKC_API.G_MISS_CHAR)

Line 1903: IF (x_bsd_pr_rec.attribute10 = OKC_API.G_MISS_CHAR)

1899: IF (x_bsd_pr_rec.attribute9 = OKC_API.G_MISS_CHAR)
1900: THEN
1901: x_bsd_pr_rec.attribute9 := l_bsd_pr_rec.attribute9;
1902: END IF;
1903: IF (x_bsd_pr_rec.attribute10 = OKC_API.G_MISS_CHAR)
1904: THEN
1905: x_bsd_pr_rec.attribute10 := l_bsd_pr_rec.attribute10;
1906: END IF;
1907: IF (x_bsd_pr_rec.attribute11 = OKC_API.G_MISS_CHAR)

Line 1907: IF (x_bsd_pr_rec.attribute11 = OKC_API.G_MISS_CHAR)

1903: IF (x_bsd_pr_rec.attribute10 = OKC_API.G_MISS_CHAR)
1904: THEN
1905: x_bsd_pr_rec.attribute10 := l_bsd_pr_rec.attribute10;
1906: END IF;
1907: IF (x_bsd_pr_rec.attribute11 = OKC_API.G_MISS_CHAR)
1908: THEN
1909: x_bsd_pr_rec.attribute11 := l_bsd_pr_rec.attribute11;
1910: END IF;
1911: IF (x_bsd_pr_rec.attribute12 = OKC_API.G_MISS_CHAR)

Line 1911: IF (x_bsd_pr_rec.attribute12 = OKC_API.G_MISS_CHAR)

1907: IF (x_bsd_pr_rec.attribute11 = OKC_API.G_MISS_CHAR)
1908: THEN
1909: x_bsd_pr_rec.attribute11 := l_bsd_pr_rec.attribute11;
1910: END IF;
1911: IF (x_bsd_pr_rec.attribute12 = OKC_API.G_MISS_CHAR)
1912: THEN
1913: x_bsd_pr_rec.attribute12 := l_bsd_pr_rec.attribute12;
1914: END IF;
1915: IF (x_bsd_pr_rec.attribute13 = OKC_API.G_MISS_CHAR)

Line 1915: IF (x_bsd_pr_rec.attribute13 = OKC_API.G_MISS_CHAR)

1911: IF (x_bsd_pr_rec.attribute12 = OKC_API.G_MISS_CHAR)
1912: THEN
1913: x_bsd_pr_rec.attribute12 := l_bsd_pr_rec.attribute12;
1914: END IF;
1915: IF (x_bsd_pr_rec.attribute13 = OKC_API.G_MISS_CHAR)
1916: THEN
1917: x_bsd_pr_rec.attribute13 := l_bsd_pr_rec.attribute13;
1918: END IF;
1919: IF (x_bsd_pr_rec.attribute14 = OKC_API.G_MISS_CHAR)

Line 1919: IF (x_bsd_pr_rec.attribute14 = OKC_API.G_MISS_CHAR)

1915: IF (x_bsd_pr_rec.attribute13 = OKC_API.G_MISS_CHAR)
1916: THEN
1917: x_bsd_pr_rec.attribute13 := l_bsd_pr_rec.attribute13;
1918: END IF;
1919: IF (x_bsd_pr_rec.attribute14 = OKC_API.G_MISS_CHAR)
1920: THEN
1921: x_bsd_pr_rec.attribute14 := l_bsd_pr_rec.attribute14;
1922: END IF;
1923: IF (x_bsd_pr_rec.attribute15 = OKC_API.G_MISS_CHAR)

Line 1923: IF (x_bsd_pr_rec.attribute15 = OKC_API.G_MISS_CHAR)

1919: IF (x_bsd_pr_rec.attribute14 = OKC_API.G_MISS_CHAR)
1920: THEN
1921: x_bsd_pr_rec.attribute14 := l_bsd_pr_rec.attribute14;
1922: END IF;
1923: IF (x_bsd_pr_rec.attribute15 = OKC_API.G_MISS_CHAR)
1924: THEN
1925: x_bsd_pr_rec.attribute15 := l_bsd_pr_rec.attribute15;
1926: END IF;
1927: IF (x_bsd_pr_rec.security_group_id = OKC_API.G_MISS_NUM)

Line 1927: IF (x_bsd_pr_rec.security_group_id = OKC_API.G_MISS_NUM)

1923: IF (x_bsd_pr_rec.attribute15 = OKC_API.G_MISS_CHAR)
1924: THEN
1925: x_bsd_pr_rec.attribute15 := l_bsd_pr_rec.attribute15;
1926: END IF;
1927: IF (x_bsd_pr_rec.security_group_id = OKC_API.G_MISS_NUM)
1928: THEN
1929: x_bsd_pr_rec.security_group_id := l_bsd_pr_rec.security_group_id;
1930: END IF;
1931: IF (x_bsd_pr_rec.start_reading = OKC_API.G_MISS_NUM)

Line 1931: IF (x_bsd_pr_rec.start_reading = OKC_API.G_MISS_NUM)

1927: IF (x_bsd_pr_rec.security_group_id = OKC_API.G_MISS_NUM)
1928: THEN
1929: x_bsd_pr_rec.security_group_id := l_bsd_pr_rec.security_group_id;
1930: END IF;
1931: IF (x_bsd_pr_rec.start_reading = OKC_API.G_MISS_NUM)
1932: THEN
1933: x_bsd_pr_rec.start_reading := l_bsd_pr_rec.start_reading;
1934: END IF;
1935: IF (x_bsd_pr_rec.end_reading = OKC_API.G_MISS_NUM)

Line 1935: IF (x_bsd_pr_rec.end_reading = OKC_API.G_MISS_NUM)

1931: IF (x_bsd_pr_rec.start_reading = OKC_API.G_MISS_NUM)
1932: THEN
1933: x_bsd_pr_rec.start_reading := l_bsd_pr_rec.start_reading;
1934: END IF;
1935: IF (x_bsd_pr_rec.end_reading = OKC_API.G_MISS_NUM)
1936: THEN
1937: x_bsd_pr_rec.end_reading := l_bsd_pr_rec.end_reading;
1938: END IF;
1939: IF (x_bsd_pr_rec.base_reading = OKC_API.G_MISS_NUM)

Line 1939: IF (x_bsd_pr_rec.base_reading = OKC_API.G_MISS_NUM)

1935: IF (x_bsd_pr_rec.end_reading = OKC_API.G_MISS_NUM)
1936: THEN
1937: x_bsd_pr_rec.end_reading := l_bsd_pr_rec.end_reading;
1938: END IF;
1939: IF (x_bsd_pr_rec.base_reading = OKC_API.G_MISS_NUM)
1940: THEN
1941: x_bsd_pr_rec.base_reading := l_bsd_pr_rec.base_reading;
1942: END IF;
1943: IF (x_bsd_pr_rec.estimated_quantity = OKC_API.G_MISS_NUM)

Line 1943: IF (x_bsd_pr_rec.estimated_quantity = OKC_API.G_MISS_NUM)

1939: IF (x_bsd_pr_rec.base_reading = OKC_API.G_MISS_NUM)
1940: THEN
1941: x_bsd_pr_rec.base_reading := l_bsd_pr_rec.base_reading;
1942: END IF;
1943: IF (x_bsd_pr_rec.estimated_quantity = OKC_API.G_MISS_NUM)
1944: THEN
1945: x_bsd_pr_rec.estimated_quantity := l_bsd_pr_rec.estimated_quantity;
1946: END IF;
1947: IF (x_bsd_pr_rec.ccr_id = OKC_API.G_MISS_NUM)

Line 1947: IF (x_bsd_pr_rec.ccr_id = OKC_API.G_MISS_NUM)

1943: IF (x_bsd_pr_rec.estimated_quantity = OKC_API.G_MISS_NUM)
1944: THEN
1945: x_bsd_pr_rec.estimated_quantity := l_bsd_pr_rec.estimated_quantity;
1946: END IF;
1947: IF (x_bsd_pr_rec.ccr_id = OKC_API.G_MISS_NUM)
1948: THEN
1949: x_bsd_pr_rec.ccr_id := l_bsd_pr_rec.ccr_id;
1950: END IF;
1951: IF (x_bsd_pr_rec.cgr_id = OKC_API.G_MISS_NUM)

Line 1951: IF (x_bsd_pr_rec.cgr_id = OKC_API.G_MISS_NUM)

1947: IF (x_bsd_pr_rec.ccr_id = OKC_API.G_MISS_NUM)
1948: THEN
1949: x_bsd_pr_rec.ccr_id := l_bsd_pr_rec.ccr_id;
1950: END IF;
1951: IF (x_bsd_pr_rec.cgr_id = OKC_API.G_MISS_NUM)
1952: THEN
1953: x_bsd_pr_rec.cgr_id := l_bsd_pr_rec.cgr_id;
1954: END IF;
1955: END IF;

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

1961: FUNCTION Set_Attributes (
1962: p_bsd_pr_rec IN bsd_pr_rec_type,
1963: x_bsd_pr_rec OUT NOCOPY bsd_pr_rec_type
1964: ) RETURN VARCHAR2 IS
1965: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1966: BEGIN
1967: x_bsd_pr_rec := p_bsd_pr_rec;
1968: x_bsd_pr_rec.OBJECT_VERSION_NUMBER := p_bsd_pr_rec.OBJECT_VERSION_NUMBER + 1;
1969: RETURN(l_return_status);

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

1968: x_bsd_pr_rec.OBJECT_VERSION_NUMBER := p_bsd_pr_rec.OBJECT_VERSION_NUMBER + 1;
1969: RETURN(l_return_status);
1970: END Set_Attributes;
1971: BEGIN
1972: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1973: p_init_msg_list,
1974: '_PVT',
1975: x_return_status);
1976: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1972: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1973: p_init_msg_list,
1974: '_PVT',
1975: x_return_status);
1976: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1977: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1978: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1979: RAISE OKC_API.G_EXCEPTION_ERROR;
1980: END IF;

Line 1977: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1973: p_init_msg_list,
1974: '_PVT',
1975: x_return_status);
1976: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1977: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1978: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1979: RAISE OKC_API.G_EXCEPTION_ERROR;
1980: END IF;
1981: --- Setting item attributes

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

1974: '_PVT',
1975: x_return_status);
1976: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1977: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1978: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1979: RAISE OKC_API.G_EXCEPTION_ERROR;
1980: END IF;
1981: --- Setting item attributes
1982: l_return_status := Set_Attributes(

Line 1979: RAISE OKC_API.G_EXCEPTION_ERROR;

1975: x_return_status);
1976: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1977: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1978: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1979: RAISE OKC_API.G_EXCEPTION_ERROR;
1980: END IF;
1981: --- Setting item attributes
1982: l_return_status := Set_Attributes(
1983: p_bsd_pr_rec, -- IN

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

1982: l_return_status := Set_Attributes(
1983: p_bsd_pr_rec, -- IN
1984: l_bsd_pr_rec); -- OUT
1985: --- If any errors happen abort API
1986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1989: RAISE OKC_API.G_EXCEPTION_ERROR;
1990: END IF;

Line 1987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1983: p_bsd_pr_rec, -- IN
1984: l_bsd_pr_rec); -- OUT
1985: --- If any errors happen abort API
1986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1989: RAISE OKC_API.G_EXCEPTION_ERROR;
1990: END IF;
1991: l_return_status := populate_new_record(l_bsd_pr_rec, l_def_bsd_pr_rec);

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

1984: l_bsd_pr_rec); -- OUT
1985: --- If any errors happen abort API
1986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1989: RAISE OKC_API.G_EXCEPTION_ERROR;
1990: END IF;
1991: l_return_status := populate_new_record(l_bsd_pr_rec, l_def_bsd_pr_rec);
1992: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1989: RAISE OKC_API.G_EXCEPTION_ERROR;

1985: --- If any errors happen abort API
1986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1989: RAISE OKC_API.G_EXCEPTION_ERROR;
1990: END IF;
1991: l_return_status := populate_new_record(l_bsd_pr_rec, l_def_bsd_pr_rec);
1992: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1989: RAISE OKC_API.G_EXCEPTION_ERROR;
1990: END IF;
1991: l_return_status := populate_new_record(l_bsd_pr_rec, l_def_bsd_pr_rec);
1992: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1994: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1995: RAISE OKC_API.G_EXCEPTION_ERROR;
1996: END IF;

Line 1993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1989: RAISE OKC_API.G_EXCEPTION_ERROR;
1990: END IF;
1991: l_return_status := populate_new_record(l_bsd_pr_rec, l_def_bsd_pr_rec);
1992: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1994: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1995: RAISE OKC_API.G_EXCEPTION_ERROR;
1996: END IF;
1997: UPDATE OKS_BSD_PR

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

1990: END IF;
1991: l_return_status := populate_new_record(l_bsd_pr_rec, l_def_bsd_pr_rec);
1992: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1994: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1995: RAISE OKC_API.G_EXCEPTION_ERROR;
1996: END IF;
1997: UPDATE OKS_BSD_PR
1998: SET BSL_ID = l_def_bsd_pr_rec.bsl_id,

Line 1995: RAISE OKC_API.G_EXCEPTION_ERROR;

1991: l_return_status := populate_new_record(l_bsd_pr_rec, l_def_bsd_pr_rec);
1992: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1994: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1995: RAISE OKC_API.G_EXCEPTION_ERROR;
1996: END IF;
1997: UPDATE OKS_BSD_PR
1998: SET BSL_ID = l_def_bsd_pr_rec.bsl_id,
1999: BSL_ID_AVERAGED = l_def_bsd_pr_rec.bsl_id_averaged,

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

2040: WHERE ID = l_def_bsd_pr_rec.id;
2041:
2042: x_bsd_pr_rec := l_bsd_pr_rec;
2043: x_return_status := l_return_status;
2044: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2045: EXCEPTION
2046: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2047: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2048: (

Line 2046: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2042: x_bsd_pr_rec := l_bsd_pr_rec;
2043: x_return_status := l_return_status;
2044: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2045: EXCEPTION
2046: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2047: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2048: (
2049: l_api_name,
2050: G_PKG_NAME,

Line 2047: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2043: x_return_status := l_return_status;
2044: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2045: EXCEPTION
2046: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2047: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2048: (
2049: l_api_name,
2050: G_PKG_NAME,
2051: 'OKC_API.G_RET_STS_ERROR',

Line 2051: 'OKC_API.G_RET_STS_ERROR',

2047: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2048: (
2049: l_api_name,
2050: G_PKG_NAME,
2051: 'OKC_API.G_RET_STS_ERROR',
2052: x_msg_count,
2053: x_msg_data,
2054: '_PVT'
2055: );

Line 2056: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2052: x_msg_count,
2053: x_msg_data,
2054: '_PVT'
2055: );
2056: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2057: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2058: (
2059: l_api_name,
2060: G_PKG_NAME,

Line 2057: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2053: x_msg_data,
2054: '_PVT'
2055: );
2056: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2057: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2058: (
2059: l_api_name,
2060: G_PKG_NAME,
2061: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2061: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2057: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2058: (
2059: l_api_name,
2060: G_PKG_NAME,
2061: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2062: x_msg_count,
2063: x_msg_data,
2064: '_PVT'
2065: );

Line 2067: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2063: x_msg_data,
2064: '_PVT'
2065: );
2066: WHEN OTHERS THEN
2067: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2068: (
2069: l_api_name,
2070: G_PKG_NAME,
2071: 'OTHERS',

Line 2082: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2078: -- update_row for:OKS_BSD_PR --
2079: -------------------------------
2080: PROCEDURE update_row(
2081: p_api_version IN NUMBER,
2082: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2083: x_return_status OUT NOCOPY VARCHAR2,
2084: x_msg_count OUT NOCOPY NUMBER,
2085: x_msg_data OUT NOCOPY VARCHAR2,
2086: p_bsd_pr_rec IN bsd_pr_rec_type,

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

2087: x_bsd_pr_rec OUT NOCOPY bsd_pr_rec_type) IS
2088:
2089: l_api_version CONSTANT NUMBER := 1;
2090: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2091: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2092: l_bsd_pr_rec bsd_pr_rec_type := p_bsd_pr_rec;
2093: l_def_bsd_pr_rec bsd_pr_rec_type;
2094: l_db_bsd_pr_rec bsd_pr_rec_type;
2095: lx_bsd_pr_rec bsd_pr_rec_type;

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

2113: p_bsd_pr_rec IN bsd_pr_rec_type,
2114: x_bsd_pr_rec OUT NOCOPY bsd_pr_rec_type
2115: ) RETURN VARCHAR2 IS
2116: l_row_notfound BOOLEAN := TRUE;
2117: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2118: BEGIN
2119: x_bsd_pr_rec := p_bsd_pr_rec;
2120: -- Get current database values
2121: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it

Line 2124: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

2120: -- Get current database values
2121: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2122: -- so it may be verified through LOCK_ROW.
2123: l_db_bsd_pr_rec := get_rec(p_bsd_pr_rec, l_return_status);
2124: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2125: IF (x_bsd_pr_rec.id = OKC_API.G_MISS_NUM)
2126: THEN
2127: x_bsd_pr_rec.id := l_db_bsd_pr_rec.id;
2128: END IF;

Line 2125: IF (x_bsd_pr_rec.id = OKC_API.G_MISS_NUM)

2121: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2122: -- so it may be verified through LOCK_ROW.
2123: l_db_bsd_pr_rec := get_rec(p_bsd_pr_rec, l_return_status);
2124: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2125: IF (x_bsd_pr_rec.id = OKC_API.G_MISS_NUM)
2126: THEN
2127: x_bsd_pr_rec.id := l_db_bsd_pr_rec.id;
2128: END IF;
2129: IF (x_bsd_pr_rec.bsl_id = OKC_API.G_MISS_NUM)

Line 2129: IF (x_bsd_pr_rec.bsl_id = OKC_API.G_MISS_NUM)

2125: IF (x_bsd_pr_rec.id = OKC_API.G_MISS_NUM)
2126: THEN
2127: x_bsd_pr_rec.id := l_db_bsd_pr_rec.id;
2128: END IF;
2129: IF (x_bsd_pr_rec.bsl_id = OKC_API.G_MISS_NUM)
2130: THEN
2131: x_bsd_pr_rec.bsl_id := l_db_bsd_pr_rec.bsl_id;
2132: END IF;
2133: IF (x_bsd_pr_rec.bsl_id_averaged = OKC_API.G_MISS_NUM)

Line 2133: IF (x_bsd_pr_rec.bsl_id_averaged = OKC_API.G_MISS_NUM)

2129: IF (x_bsd_pr_rec.bsl_id = OKC_API.G_MISS_NUM)
2130: THEN
2131: x_bsd_pr_rec.bsl_id := l_db_bsd_pr_rec.bsl_id;
2132: END IF;
2133: IF (x_bsd_pr_rec.bsl_id_averaged = OKC_API.G_MISS_NUM)
2134: THEN
2135: x_bsd_pr_rec.bsl_id_averaged := l_db_bsd_pr_rec.bsl_id_averaged;
2136: END IF;
2137: IF (x_bsd_pr_rec.bsd_id = OKC_API.G_MISS_NUM)

Line 2137: IF (x_bsd_pr_rec.bsd_id = OKC_API.G_MISS_NUM)

2133: IF (x_bsd_pr_rec.bsl_id_averaged = OKC_API.G_MISS_NUM)
2134: THEN
2135: x_bsd_pr_rec.bsl_id_averaged := l_db_bsd_pr_rec.bsl_id_averaged;
2136: END IF;
2137: IF (x_bsd_pr_rec.bsd_id = OKC_API.G_MISS_NUM)
2138: THEN
2139: x_bsd_pr_rec.bsd_id := l_db_bsd_pr_rec.bsd_id;
2140: END IF;
2141: IF (x_bsd_pr_rec.bsd_id_applied = OKC_API.G_MISS_NUM)

Line 2141: IF (x_bsd_pr_rec.bsd_id_applied = OKC_API.G_MISS_NUM)

2137: IF (x_bsd_pr_rec.bsd_id = OKC_API.G_MISS_NUM)
2138: THEN
2139: x_bsd_pr_rec.bsd_id := l_db_bsd_pr_rec.bsd_id;
2140: END IF;
2141: IF (x_bsd_pr_rec.bsd_id_applied = OKC_API.G_MISS_NUM)
2142: THEN
2143: x_bsd_pr_rec.bsd_id_applied := l_db_bsd_pr_rec.bsd_id_applied;
2144: END IF;
2145: IF (x_bsd_pr_rec.unit_of_measure = OKC_API.G_MISS_CHAR)

Line 2145: IF (x_bsd_pr_rec.unit_of_measure = OKC_API.G_MISS_CHAR)

2141: IF (x_bsd_pr_rec.bsd_id_applied = OKC_API.G_MISS_NUM)
2142: THEN
2143: x_bsd_pr_rec.bsd_id_applied := l_db_bsd_pr_rec.bsd_id_applied;
2144: END IF;
2145: IF (x_bsd_pr_rec.unit_of_measure = OKC_API.G_MISS_CHAR)
2146: THEN
2147: x_bsd_pr_rec.unit_of_measure := l_db_bsd_pr_rec.unit_of_measure;
2148: END IF;
2149: IF (x_bsd_pr_rec.amcv_yn = OKC_API.G_MISS_CHAR)

Line 2149: IF (x_bsd_pr_rec.amcv_yn = OKC_API.G_MISS_CHAR)

2145: IF (x_bsd_pr_rec.unit_of_measure = OKC_API.G_MISS_CHAR)
2146: THEN
2147: x_bsd_pr_rec.unit_of_measure := l_db_bsd_pr_rec.unit_of_measure;
2148: END IF;
2149: IF (x_bsd_pr_rec.amcv_yn = OKC_API.G_MISS_CHAR)
2150: THEN
2151: x_bsd_pr_rec.amcv_yn := l_db_bsd_pr_rec.amcv_yn;
2152: END IF;
2153: IF (x_bsd_pr_rec.result = OKC_API.G_MISS_NUM)

Line 2153: IF (x_bsd_pr_rec.result = OKC_API.G_MISS_NUM)

2149: IF (x_bsd_pr_rec.amcv_yn = OKC_API.G_MISS_CHAR)
2150: THEN
2151: x_bsd_pr_rec.amcv_yn := l_db_bsd_pr_rec.amcv_yn;
2152: END IF;
2153: IF (x_bsd_pr_rec.result = OKC_API.G_MISS_NUM)
2154: THEN
2155: x_bsd_pr_rec.result := l_db_bsd_pr_rec.result;
2156: END IF;
2157: IF (x_bsd_pr_rec.amount = OKC_API.G_MISS_NUM)

Line 2157: IF (x_bsd_pr_rec.amount = OKC_API.G_MISS_NUM)

2153: IF (x_bsd_pr_rec.result = OKC_API.G_MISS_NUM)
2154: THEN
2155: x_bsd_pr_rec.result := l_db_bsd_pr_rec.result;
2156: END IF;
2157: IF (x_bsd_pr_rec.amount = OKC_API.G_MISS_NUM)
2158: THEN
2159: x_bsd_pr_rec.amount := l_db_bsd_pr_rec.amount;
2160: END IF;
2161: IF (x_bsd_pr_rec.created_by = OKC_API.G_MISS_NUM)

Line 2161: IF (x_bsd_pr_rec.created_by = OKC_API.G_MISS_NUM)

2157: IF (x_bsd_pr_rec.amount = OKC_API.G_MISS_NUM)
2158: THEN
2159: x_bsd_pr_rec.amount := l_db_bsd_pr_rec.amount;
2160: END IF;
2161: IF (x_bsd_pr_rec.created_by = OKC_API.G_MISS_NUM)
2162: THEN
2163: x_bsd_pr_rec.created_by := l_db_bsd_pr_rec.created_by;
2164: END IF;
2165: IF (x_bsd_pr_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2165: IF (x_bsd_pr_rec.creation_date = OKC_API.G_MISS_DATE)

2161: IF (x_bsd_pr_rec.created_by = OKC_API.G_MISS_NUM)
2162: THEN
2163: x_bsd_pr_rec.created_by := l_db_bsd_pr_rec.created_by;
2164: END IF;
2165: IF (x_bsd_pr_rec.creation_date = OKC_API.G_MISS_DATE)
2166: THEN
2167: x_bsd_pr_rec.creation_date := l_db_bsd_pr_rec.creation_date;
2168: END IF;
2169: IF (x_bsd_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2169: IF (x_bsd_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)

2165: IF (x_bsd_pr_rec.creation_date = OKC_API.G_MISS_DATE)
2166: THEN
2167: x_bsd_pr_rec.creation_date := l_db_bsd_pr_rec.creation_date;
2168: END IF;
2169: IF (x_bsd_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)
2170: THEN
2171: x_bsd_pr_rec.last_updated_by := l_db_bsd_pr_rec.last_updated_by;
2172: END IF;
2173: IF (x_bsd_pr_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2173: IF (x_bsd_pr_rec.last_update_date = OKC_API.G_MISS_DATE)

2169: IF (x_bsd_pr_rec.last_updated_by = OKC_API.G_MISS_NUM)
2170: THEN
2171: x_bsd_pr_rec.last_updated_by := l_db_bsd_pr_rec.last_updated_by;
2172: END IF;
2173: IF (x_bsd_pr_rec.last_update_date = OKC_API.G_MISS_DATE)
2174: THEN
2175: x_bsd_pr_rec.last_update_date := l_db_bsd_pr_rec.last_update_date;
2176: END IF;
2177: IF (x_bsd_pr_rec.fixed = OKC_API.G_MISS_NUM)

Line 2177: IF (x_bsd_pr_rec.fixed = OKC_API.G_MISS_NUM)

2173: IF (x_bsd_pr_rec.last_update_date = OKC_API.G_MISS_DATE)
2174: THEN
2175: x_bsd_pr_rec.last_update_date := l_db_bsd_pr_rec.last_update_date;
2176: END IF;
2177: IF (x_bsd_pr_rec.fixed = OKC_API.G_MISS_NUM)
2178: THEN
2179: x_bsd_pr_rec.fixed := l_db_bsd_pr_rec.fixed;
2180: END IF;
2181: IF (x_bsd_pr_rec.actual = OKC_API.G_MISS_NUM)

Line 2181: IF (x_bsd_pr_rec.actual = OKC_API.G_MISS_NUM)

2177: IF (x_bsd_pr_rec.fixed = OKC_API.G_MISS_NUM)
2178: THEN
2179: x_bsd_pr_rec.fixed := l_db_bsd_pr_rec.fixed;
2180: END IF;
2181: IF (x_bsd_pr_rec.actual = OKC_API.G_MISS_NUM)
2182: THEN
2183: x_bsd_pr_rec.actual := l_db_bsd_pr_rec.actual;
2184: END IF;
2185: IF (x_bsd_pr_rec.default_default = OKC_API.G_MISS_NUM)

Line 2185: IF (x_bsd_pr_rec.default_default = OKC_API.G_MISS_NUM)

2181: IF (x_bsd_pr_rec.actual = OKC_API.G_MISS_NUM)
2182: THEN
2183: x_bsd_pr_rec.actual := l_db_bsd_pr_rec.actual;
2184: END IF;
2185: IF (x_bsd_pr_rec.default_default = OKC_API.G_MISS_NUM)
2186: THEN
2187: x_bsd_pr_rec.default_default := l_db_bsd_pr_rec.default_default;
2188: END IF;
2189: IF (x_bsd_pr_rec.adjustment_level = OKC_API.G_MISS_NUM)

Line 2189: IF (x_bsd_pr_rec.adjustment_level = OKC_API.G_MISS_NUM)

2185: IF (x_bsd_pr_rec.default_default = OKC_API.G_MISS_NUM)
2186: THEN
2187: x_bsd_pr_rec.default_default := l_db_bsd_pr_rec.default_default;
2188: END IF;
2189: IF (x_bsd_pr_rec.adjustment_level = OKC_API.G_MISS_NUM)
2190: THEN
2191: x_bsd_pr_rec.adjustment_level := l_db_bsd_pr_rec.adjustment_level;
2192: END IF;
2193: IF (x_bsd_pr_rec.adjustment_minimum = OKC_API.G_MISS_NUM)

Line 2193: IF (x_bsd_pr_rec.adjustment_minimum = OKC_API.G_MISS_NUM)

2189: IF (x_bsd_pr_rec.adjustment_level = OKC_API.G_MISS_NUM)
2190: THEN
2191: x_bsd_pr_rec.adjustment_level := l_db_bsd_pr_rec.adjustment_level;
2192: END IF;
2193: IF (x_bsd_pr_rec.adjustment_minimum = OKC_API.G_MISS_NUM)
2194: THEN
2195: x_bsd_pr_rec.adjustment_minimum := l_db_bsd_pr_rec.adjustment_minimum;
2196: END IF;
2197: IF (x_bsd_pr_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2197: IF (x_bsd_pr_rec.last_update_login = OKC_API.G_MISS_NUM)

2193: IF (x_bsd_pr_rec.adjustment_minimum = OKC_API.G_MISS_NUM)
2194: THEN
2195: x_bsd_pr_rec.adjustment_minimum := l_db_bsd_pr_rec.adjustment_minimum;
2196: END IF;
2197: IF (x_bsd_pr_rec.last_update_login = OKC_API.G_MISS_NUM)
2198: THEN
2199: x_bsd_pr_rec.last_update_login := l_db_bsd_pr_rec.last_update_login;
2200: END IF;
2201: IF (x_bsd_pr_rec.attribute_category = OKC_API.G_MISS_CHAR)

Line 2201: IF (x_bsd_pr_rec.attribute_category = OKC_API.G_MISS_CHAR)

2197: IF (x_bsd_pr_rec.last_update_login = OKC_API.G_MISS_NUM)
2198: THEN
2199: x_bsd_pr_rec.last_update_login := l_db_bsd_pr_rec.last_update_login;
2200: END IF;
2201: IF (x_bsd_pr_rec.attribute_category = OKC_API.G_MISS_CHAR)
2202: THEN
2203: x_bsd_pr_rec.attribute_category := l_db_bsd_pr_rec.attribute_category;
2204: END IF;
2205: IF (x_bsd_pr_rec.attribute1 = OKC_API.G_MISS_CHAR)

Line 2205: IF (x_bsd_pr_rec.attribute1 = OKC_API.G_MISS_CHAR)

2201: IF (x_bsd_pr_rec.attribute_category = OKC_API.G_MISS_CHAR)
2202: THEN
2203: x_bsd_pr_rec.attribute_category := l_db_bsd_pr_rec.attribute_category;
2204: END IF;
2205: IF (x_bsd_pr_rec.attribute1 = OKC_API.G_MISS_CHAR)
2206: THEN
2207: x_bsd_pr_rec.attribute1 := l_db_bsd_pr_rec.attribute1;
2208: END IF;
2209: IF (x_bsd_pr_rec.attribute2 = OKC_API.G_MISS_CHAR)

Line 2209: IF (x_bsd_pr_rec.attribute2 = OKC_API.G_MISS_CHAR)

2205: IF (x_bsd_pr_rec.attribute1 = OKC_API.G_MISS_CHAR)
2206: THEN
2207: x_bsd_pr_rec.attribute1 := l_db_bsd_pr_rec.attribute1;
2208: END IF;
2209: IF (x_bsd_pr_rec.attribute2 = OKC_API.G_MISS_CHAR)
2210: THEN
2211: x_bsd_pr_rec.attribute2 := l_db_bsd_pr_rec.attribute2;
2212: END IF;
2213: IF (x_bsd_pr_rec.attribute3 = OKC_API.G_MISS_CHAR)

Line 2213: IF (x_bsd_pr_rec.attribute3 = OKC_API.G_MISS_CHAR)

2209: IF (x_bsd_pr_rec.attribute2 = OKC_API.G_MISS_CHAR)
2210: THEN
2211: x_bsd_pr_rec.attribute2 := l_db_bsd_pr_rec.attribute2;
2212: END IF;
2213: IF (x_bsd_pr_rec.attribute3 = OKC_API.G_MISS_CHAR)
2214: THEN
2215: x_bsd_pr_rec.attribute3 := l_db_bsd_pr_rec.attribute3;
2216: END IF;
2217: IF (x_bsd_pr_rec.attribute4 = OKC_API.G_MISS_CHAR)

Line 2217: IF (x_bsd_pr_rec.attribute4 = OKC_API.G_MISS_CHAR)

2213: IF (x_bsd_pr_rec.attribute3 = OKC_API.G_MISS_CHAR)
2214: THEN
2215: x_bsd_pr_rec.attribute3 := l_db_bsd_pr_rec.attribute3;
2216: END IF;
2217: IF (x_bsd_pr_rec.attribute4 = OKC_API.G_MISS_CHAR)
2218: THEN
2219: x_bsd_pr_rec.attribute4 := l_db_bsd_pr_rec.attribute4;
2220: END IF;
2221: IF (x_bsd_pr_rec.attribute5 = OKC_API.G_MISS_CHAR)

Line 2221: IF (x_bsd_pr_rec.attribute5 = OKC_API.G_MISS_CHAR)

2217: IF (x_bsd_pr_rec.attribute4 = OKC_API.G_MISS_CHAR)
2218: THEN
2219: x_bsd_pr_rec.attribute4 := l_db_bsd_pr_rec.attribute4;
2220: END IF;
2221: IF (x_bsd_pr_rec.attribute5 = OKC_API.G_MISS_CHAR)
2222: THEN
2223: x_bsd_pr_rec.attribute5 := l_db_bsd_pr_rec.attribute5;
2224: END IF;
2225: IF (x_bsd_pr_rec.attribute6 = OKC_API.G_MISS_CHAR)

Line 2225: IF (x_bsd_pr_rec.attribute6 = OKC_API.G_MISS_CHAR)

2221: IF (x_bsd_pr_rec.attribute5 = OKC_API.G_MISS_CHAR)
2222: THEN
2223: x_bsd_pr_rec.attribute5 := l_db_bsd_pr_rec.attribute5;
2224: END IF;
2225: IF (x_bsd_pr_rec.attribute6 = OKC_API.G_MISS_CHAR)
2226: THEN
2227: x_bsd_pr_rec.attribute6 := l_db_bsd_pr_rec.attribute6;
2228: END IF;
2229: IF (x_bsd_pr_rec.attribute7 = OKC_API.G_MISS_CHAR)

Line 2229: IF (x_bsd_pr_rec.attribute7 = OKC_API.G_MISS_CHAR)

2225: IF (x_bsd_pr_rec.attribute6 = OKC_API.G_MISS_CHAR)
2226: THEN
2227: x_bsd_pr_rec.attribute6 := l_db_bsd_pr_rec.attribute6;
2228: END IF;
2229: IF (x_bsd_pr_rec.attribute7 = OKC_API.G_MISS_CHAR)
2230: THEN
2231: x_bsd_pr_rec.attribute7 := l_db_bsd_pr_rec.attribute7;
2232: END IF;
2233: IF (x_bsd_pr_rec.attribute8 = OKC_API.G_MISS_CHAR)

Line 2233: IF (x_bsd_pr_rec.attribute8 = OKC_API.G_MISS_CHAR)

2229: IF (x_bsd_pr_rec.attribute7 = OKC_API.G_MISS_CHAR)
2230: THEN
2231: x_bsd_pr_rec.attribute7 := l_db_bsd_pr_rec.attribute7;
2232: END IF;
2233: IF (x_bsd_pr_rec.attribute8 = OKC_API.G_MISS_CHAR)
2234: THEN
2235: x_bsd_pr_rec.attribute8 := l_db_bsd_pr_rec.attribute8;
2236: END IF;
2237: IF (x_bsd_pr_rec.attribute9 = OKC_API.G_MISS_CHAR)

Line 2237: IF (x_bsd_pr_rec.attribute9 = OKC_API.G_MISS_CHAR)

2233: IF (x_bsd_pr_rec.attribute8 = OKC_API.G_MISS_CHAR)
2234: THEN
2235: x_bsd_pr_rec.attribute8 := l_db_bsd_pr_rec.attribute8;
2236: END IF;
2237: IF (x_bsd_pr_rec.attribute9 = OKC_API.G_MISS_CHAR)
2238: THEN
2239: x_bsd_pr_rec.attribute9 := l_db_bsd_pr_rec.attribute9;
2240: END IF;
2241: IF (x_bsd_pr_rec.attribute10 = OKC_API.G_MISS_CHAR)

Line 2241: IF (x_bsd_pr_rec.attribute10 = OKC_API.G_MISS_CHAR)

2237: IF (x_bsd_pr_rec.attribute9 = OKC_API.G_MISS_CHAR)
2238: THEN
2239: x_bsd_pr_rec.attribute9 := l_db_bsd_pr_rec.attribute9;
2240: END IF;
2241: IF (x_bsd_pr_rec.attribute10 = OKC_API.G_MISS_CHAR)
2242: THEN
2243: x_bsd_pr_rec.attribute10 := l_db_bsd_pr_rec.attribute10;
2244: END IF;
2245: IF (x_bsd_pr_rec.attribute11 = OKC_API.G_MISS_CHAR)

Line 2245: IF (x_bsd_pr_rec.attribute11 = OKC_API.G_MISS_CHAR)

2241: IF (x_bsd_pr_rec.attribute10 = OKC_API.G_MISS_CHAR)
2242: THEN
2243: x_bsd_pr_rec.attribute10 := l_db_bsd_pr_rec.attribute10;
2244: END IF;
2245: IF (x_bsd_pr_rec.attribute11 = OKC_API.G_MISS_CHAR)
2246: THEN
2247: x_bsd_pr_rec.attribute11 := l_db_bsd_pr_rec.attribute11;
2248: END IF;
2249: IF (x_bsd_pr_rec.attribute12 = OKC_API.G_MISS_CHAR)

Line 2249: IF (x_bsd_pr_rec.attribute12 = OKC_API.G_MISS_CHAR)

2245: IF (x_bsd_pr_rec.attribute11 = OKC_API.G_MISS_CHAR)
2246: THEN
2247: x_bsd_pr_rec.attribute11 := l_db_bsd_pr_rec.attribute11;
2248: END IF;
2249: IF (x_bsd_pr_rec.attribute12 = OKC_API.G_MISS_CHAR)
2250: THEN
2251: x_bsd_pr_rec.attribute12 := l_db_bsd_pr_rec.attribute12;
2252: END IF;
2253: IF (x_bsd_pr_rec.attribute13 = OKC_API.G_MISS_CHAR)

Line 2253: IF (x_bsd_pr_rec.attribute13 = OKC_API.G_MISS_CHAR)

2249: IF (x_bsd_pr_rec.attribute12 = OKC_API.G_MISS_CHAR)
2250: THEN
2251: x_bsd_pr_rec.attribute12 := l_db_bsd_pr_rec.attribute12;
2252: END IF;
2253: IF (x_bsd_pr_rec.attribute13 = OKC_API.G_MISS_CHAR)
2254: THEN
2255: x_bsd_pr_rec.attribute13 := l_db_bsd_pr_rec.attribute13;
2256: END IF;
2257: IF (x_bsd_pr_rec.attribute14 = OKC_API.G_MISS_CHAR)

Line 2257: IF (x_bsd_pr_rec.attribute14 = OKC_API.G_MISS_CHAR)

2253: IF (x_bsd_pr_rec.attribute13 = OKC_API.G_MISS_CHAR)
2254: THEN
2255: x_bsd_pr_rec.attribute13 := l_db_bsd_pr_rec.attribute13;
2256: END IF;
2257: IF (x_bsd_pr_rec.attribute14 = OKC_API.G_MISS_CHAR)
2258: THEN
2259: x_bsd_pr_rec.attribute14 := l_db_bsd_pr_rec.attribute14;
2260: END IF;
2261: IF (x_bsd_pr_rec.attribute15 = OKC_API.G_MISS_CHAR)

Line 2261: IF (x_bsd_pr_rec.attribute15 = OKC_API.G_MISS_CHAR)

2257: IF (x_bsd_pr_rec.attribute14 = OKC_API.G_MISS_CHAR)
2258: THEN
2259: x_bsd_pr_rec.attribute14 := l_db_bsd_pr_rec.attribute14;
2260: END IF;
2261: IF (x_bsd_pr_rec.attribute15 = OKC_API.G_MISS_CHAR)
2262: THEN
2263: x_bsd_pr_rec.attribute15 := l_db_bsd_pr_rec.attribute15;
2264: END IF;
2265: IF (x_bsd_pr_rec.security_group_id = OKC_API.G_MISS_NUM)

Line 2265: IF (x_bsd_pr_rec.security_group_id = OKC_API.G_MISS_NUM)

2261: IF (x_bsd_pr_rec.attribute15 = OKC_API.G_MISS_CHAR)
2262: THEN
2263: x_bsd_pr_rec.attribute15 := l_db_bsd_pr_rec.attribute15;
2264: END IF;
2265: IF (x_bsd_pr_rec.security_group_id = OKC_API.G_MISS_NUM)
2266: THEN
2267: x_bsd_pr_rec.security_group_id := l_db_bsd_pr_rec.security_group_id;
2268: END IF;
2269: IF (x_bsd_pr_rec.start_reading = OKC_API.G_MISS_NUM)

Line 2269: IF (x_bsd_pr_rec.start_reading = OKC_API.G_MISS_NUM)

2265: IF (x_bsd_pr_rec.security_group_id = OKC_API.G_MISS_NUM)
2266: THEN
2267: x_bsd_pr_rec.security_group_id := l_db_bsd_pr_rec.security_group_id;
2268: END IF;
2269: IF (x_bsd_pr_rec.start_reading = OKC_API.G_MISS_NUM)
2270: THEN
2271: x_bsd_pr_rec.start_reading := l_db_bsd_pr_rec.start_reading;
2272: END IF;
2273: IF (x_bsd_pr_rec.end_reading = OKC_API.G_MISS_NUM)

Line 2273: IF (x_bsd_pr_rec.end_reading = OKC_API.G_MISS_NUM)

2269: IF (x_bsd_pr_rec.start_reading = OKC_API.G_MISS_NUM)
2270: THEN
2271: x_bsd_pr_rec.start_reading := l_db_bsd_pr_rec.start_reading;
2272: END IF;
2273: IF (x_bsd_pr_rec.end_reading = OKC_API.G_MISS_NUM)
2274: THEN
2275: x_bsd_pr_rec.end_reading := l_db_bsd_pr_rec.end_reading;
2276: END IF;
2277: IF (x_bsd_pr_rec.base_reading = OKC_API.G_MISS_NUM)

Line 2277: IF (x_bsd_pr_rec.base_reading = OKC_API.G_MISS_NUM)

2273: IF (x_bsd_pr_rec.end_reading = OKC_API.G_MISS_NUM)
2274: THEN
2275: x_bsd_pr_rec.end_reading := l_db_bsd_pr_rec.end_reading;
2276: END IF;
2277: IF (x_bsd_pr_rec.base_reading = OKC_API.G_MISS_NUM)
2278: THEN
2279: x_bsd_pr_rec.base_reading := l_db_bsd_pr_rec.base_reading;
2280: END IF;
2281: IF (x_bsd_pr_rec.estimated_quantity = OKC_API.G_MISS_NUM)

Line 2281: IF (x_bsd_pr_rec.estimated_quantity = OKC_API.G_MISS_NUM)

2277: IF (x_bsd_pr_rec.base_reading = OKC_API.G_MISS_NUM)
2278: THEN
2279: x_bsd_pr_rec.base_reading := l_db_bsd_pr_rec.base_reading;
2280: END IF;
2281: IF (x_bsd_pr_rec.estimated_quantity = OKC_API.G_MISS_NUM)
2282: THEN
2283: x_bsd_pr_rec.estimated_quantity := l_db_bsd_pr_rec.estimated_quantity;
2284: END IF;
2285: IF (x_bsd_pr_rec.ccr_id = OKC_API.G_MISS_NUM)

Line 2285: IF (x_bsd_pr_rec.ccr_id = OKC_API.G_MISS_NUM)

2281: IF (x_bsd_pr_rec.estimated_quantity = OKC_API.G_MISS_NUM)
2282: THEN
2283: x_bsd_pr_rec.estimated_quantity := l_db_bsd_pr_rec.estimated_quantity;
2284: END IF;
2285: IF (x_bsd_pr_rec.ccr_id = OKC_API.G_MISS_NUM)
2286: THEN
2287: x_bsd_pr_rec.ccr_id := l_db_bsd_pr_rec.ccr_id;
2288: END IF;
2289: IF (x_bsd_pr_rec.cgr_id = OKC_API.G_MISS_NUM)

Line 2289: IF (x_bsd_pr_rec.cgr_id = OKC_API.G_MISS_NUM)

2285: IF (x_bsd_pr_rec.ccr_id = OKC_API.G_MISS_NUM)
2286: THEN
2287: x_bsd_pr_rec.ccr_id := l_db_bsd_pr_rec.ccr_id;
2288: END IF;
2289: IF (x_bsd_pr_rec.cgr_id = OKC_API.G_MISS_NUM)
2290: THEN
2291: x_bsd_pr_rec.cgr_id := l_db_bsd_pr_rec.cgr_id;
2292: END IF;
2293: END IF;

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

2299: FUNCTION Set_Attributes (
2300: p_bsd_pr_rec IN bsd_pr_rec_type,
2301: x_bsd_pr_rec OUT NOCOPY bsd_pr_rec_type
2302: ) RETURN VARCHAR2 IS
2303: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2304: BEGIN
2305: x_bsd_pr_rec := p_bsd_pr_rec;
2306: RETURN(l_return_status);
2307: END Set_Attributes;

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

2305: x_bsd_pr_rec := p_bsd_pr_rec;
2306: RETURN(l_return_status);
2307: END Set_Attributes;
2308: BEGIN
2309: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2310: G_PKG_NAME,
2311: p_init_msg_list,
2312: l_api_version,
2313: p_api_version,

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

2312: l_api_version,
2313: p_api_version,
2314: '_PVT',
2315: x_return_status);
2316: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2318: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2319: RAISE OKC_API.G_EXCEPTION_ERROR;
2320: END IF;

Line 2317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2313: p_api_version,
2314: '_PVT',
2315: x_return_status);
2316: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2318: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2319: RAISE OKC_API.G_EXCEPTION_ERROR;
2320: END IF;
2321: --- Setting item attributes

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

2314: '_PVT',
2315: x_return_status);
2316: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2318: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2319: RAISE OKC_API.G_EXCEPTION_ERROR;
2320: END IF;
2321: --- Setting item attributes
2322: l_return_status := Set_Attributes(

Line 2319: RAISE OKC_API.G_EXCEPTION_ERROR;

2315: x_return_status);
2316: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2317: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2318: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2319: RAISE OKC_API.G_EXCEPTION_ERROR;
2320: END IF;
2321: --- Setting item attributes
2322: l_return_status := Set_Attributes(
2323: p_bsd_pr_rec, -- IN

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

2322: l_return_status := Set_Attributes(
2323: p_bsd_pr_rec, -- IN
2324: x_bsd_pr_rec); -- OUT
2325: --- If any errors happen abort API
2326: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2327: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2328: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2329: RAISE OKC_API.G_EXCEPTION_ERROR;
2330: END IF;

Line 2327: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2323: p_bsd_pr_rec, -- IN
2324: x_bsd_pr_rec); -- OUT
2325: --- If any errors happen abort API
2326: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2327: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2328: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2329: RAISE OKC_API.G_EXCEPTION_ERROR;
2330: END IF;
2331: l_return_status := populate_new_record(l_bsd_pr_rec, l_def_bsd_pr_rec);

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

2324: x_bsd_pr_rec); -- OUT
2325: --- If any errors happen abort API
2326: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2327: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2328: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2329: RAISE OKC_API.G_EXCEPTION_ERROR;
2330: END IF;
2331: l_return_status := populate_new_record(l_bsd_pr_rec, l_def_bsd_pr_rec);
2332: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2329: RAISE OKC_API.G_EXCEPTION_ERROR;

2325: --- If any errors happen abort API
2326: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2327: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2328: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2329: RAISE OKC_API.G_EXCEPTION_ERROR;
2330: END IF;
2331: l_return_status := populate_new_record(l_bsd_pr_rec, l_def_bsd_pr_rec);
2332: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2333: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2328: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2329: RAISE OKC_API.G_EXCEPTION_ERROR;
2330: END IF;
2331: l_return_status := populate_new_record(l_bsd_pr_rec, l_def_bsd_pr_rec);
2332: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2333: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2334: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2335: RAISE OKC_API.G_EXCEPTION_ERROR;
2336: END IF;

Line 2333: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2329: RAISE OKC_API.G_EXCEPTION_ERROR;
2330: END IF;
2331: l_return_status := populate_new_record(l_bsd_pr_rec, l_def_bsd_pr_rec);
2332: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2333: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2334: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2335: RAISE OKC_API.G_EXCEPTION_ERROR;
2336: END IF;
2337: l_def_bsd_pr_rec := fill_who_columns(l_def_bsd_pr_rec);

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

2330: END IF;
2331: l_return_status := populate_new_record(l_bsd_pr_rec, l_def_bsd_pr_rec);
2332: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2333: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2334: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2335: RAISE OKC_API.G_EXCEPTION_ERROR;
2336: END IF;
2337: l_def_bsd_pr_rec := fill_who_columns(l_def_bsd_pr_rec);
2338: --- Validate all non-missing attributes (Item Level Validation)

Line 2335: RAISE OKC_API.G_EXCEPTION_ERROR;

2331: l_return_status := populate_new_record(l_bsd_pr_rec, l_def_bsd_pr_rec);
2332: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2333: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2334: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2335: RAISE OKC_API.G_EXCEPTION_ERROR;
2336: END IF;
2337: l_def_bsd_pr_rec := fill_who_columns(l_def_bsd_pr_rec);
2338: --- Validate all non-missing attributes (Item Level Validation)
2339: l_return_status := Validate_Attributes(l_def_bsd_pr_rec);

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

2337: l_def_bsd_pr_rec := fill_who_columns(l_def_bsd_pr_rec);
2338: --- Validate all non-missing attributes (Item Level Validation)
2339: l_return_status := Validate_Attributes(l_def_bsd_pr_rec);
2340: --- If any errors happen abort API
2341: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2342: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2343: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2344: RAISE OKC_API.G_EXCEPTION_ERROR;
2345: END IF;

Line 2342: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2338: --- Validate all non-missing attributes (Item Level Validation)
2339: l_return_status := Validate_Attributes(l_def_bsd_pr_rec);
2340: --- If any errors happen abort API
2341: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2342: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2343: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2344: RAISE OKC_API.G_EXCEPTION_ERROR;
2345: END IF;
2346: l_return_status := Validate_Record(l_def_bsd_pr_rec, l_db_bsd_pr_rec);

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

2339: l_return_status := Validate_Attributes(l_def_bsd_pr_rec);
2340: --- If any errors happen abort API
2341: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2342: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2343: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2344: RAISE OKC_API.G_EXCEPTION_ERROR;
2345: END IF;
2346: l_return_status := Validate_Record(l_def_bsd_pr_rec, l_db_bsd_pr_rec);
2347: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2344: RAISE OKC_API.G_EXCEPTION_ERROR;

2340: --- If any errors happen abort API
2341: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2342: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2343: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2344: RAISE OKC_API.G_EXCEPTION_ERROR;
2345: END IF;
2346: l_return_status := Validate_Record(l_def_bsd_pr_rec, l_db_bsd_pr_rec);
2347: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2348: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2343: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2344: RAISE OKC_API.G_EXCEPTION_ERROR;
2345: END IF;
2346: l_return_status := Validate_Record(l_def_bsd_pr_rec, l_db_bsd_pr_rec);
2347: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2348: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2349: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2350: RAISE OKC_API.G_EXCEPTION_ERROR;
2351: END IF;

Line 2348: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2344: RAISE OKC_API.G_EXCEPTION_ERROR;
2345: END IF;
2346: l_return_status := Validate_Record(l_def_bsd_pr_rec, l_db_bsd_pr_rec);
2347: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2348: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2349: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2350: RAISE OKC_API.G_EXCEPTION_ERROR;
2351: END IF;
2352:

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

2345: END IF;
2346: l_return_status := Validate_Record(l_def_bsd_pr_rec, l_db_bsd_pr_rec);
2347: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2348: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2349: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2350: RAISE OKC_API.G_EXCEPTION_ERROR;
2351: END IF;
2352:
2353: -- Lock the Record

Line 2350: RAISE OKC_API.G_EXCEPTION_ERROR;

2346: l_return_status := Validate_Record(l_def_bsd_pr_rec, l_db_bsd_pr_rec);
2347: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2348: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2349: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2350: RAISE OKC_API.G_EXCEPTION_ERROR;
2351: END IF;
2352:
2353: -- Lock the Record
2354: lock_row(

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

2357: x_return_status => l_return_status,
2358: x_msg_count => x_msg_count,
2359: x_msg_data => x_msg_data,
2360: p_bsd_pr_rec => p_bsd_pr_rec);
2361: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2362: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2363: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2364: RAISE OKC_API.G_EXCEPTION_ERROR;
2365: END IF;

Line 2362: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2358: x_msg_count => x_msg_count,
2359: x_msg_data => x_msg_data,
2360: p_bsd_pr_rec => p_bsd_pr_rec);
2361: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2362: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2363: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2364: RAISE OKC_API.G_EXCEPTION_ERROR;
2365: END IF;
2366:

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

2359: x_msg_data => x_msg_data,
2360: p_bsd_pr_rec => p_bsd_pr_rec);
2361: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2362: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2363: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2364: RAISE OKC_API.G_EXCEPTION_ERROR;
2365: END IF;
2366:
2367: -----------------------------------------

Line 2364: RAISE OKC_API.G_EXCEPTION_ERROR;

2360: p_bsd_pr_rec => p_bsd_pr_rec);
2361: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2362: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2363: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2364: RAISE OKC_API.G_EXCEPTION_ERROR;
2365: END IF;
2366:
2367: -----------------------------------------
2368: -- Move VIEW record to "Child" records --

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

2378: x_msg_data,
2379: l_bsd_pr_rec,
2380: lx_bsd_pr_rec
2381: );
2382: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2384: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2385: RAISE OKC_API.G_EXCEPTION_ERROR;
2386: END IF;

Line 2383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2379: l_bsd_pr_rec,
2380: lx_bsd_pr_rec
2381: );
2382: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2384: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2385: RAISE OKC_API.G_EXCEPTION_ERROR;
2386: END IF;
2387: migrate(lx_bsd_pr_rec, l_def_bsd_pr_rec);

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

2380: lx_bsd_pr_rec
2381: );
2382: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2384: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2385: RAISE OKC_API.G_EXCEPTION_ERROR;
2386: END IF;
2387: migrate(lx_bsd_pr_rec, l_def_bsd_pr_rec);
2388: x_bsd_pr_rec := l_def_bsd_pr_rec;

Line 2385: RAISE OKC_API.G_EXCEPTION_ERROR;

2381: );
2382: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2384: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2385: RAISE OKC_API.G_EXCEPTION_ERROR;
2386: END IF;
2387: migrate(lx_bsd_pr_rec, l_def_bsd_pr_rec);
2388: x_bsd_pr_rec := l_def_bsd_pr_rec;
2389: x_return_status := l_return_status;

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

2386: END IF;
2387: migrate(lx_bsd_pr_rec, l_def_bsd_pr_rec);
2388: x_bsd_pr_rec := l_def_bsd_pr_rec;
2389: x_return_status := l_return_status;
2390: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2391: EXCEPTION
2392: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2393: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2394: (

Line 2392: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2388: x_bsd_pr_rec := l_def_bsd_pr_rec;
2389: x_return_status := l_return_status;
2390: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2391: EXCEPTION
2392: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2393: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2394: (
2395: l_api_name,
2396: G_PKG_NAME,

Line 2393: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2389: x_return_status := l_return_status;
2390: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2391: EXCEPTION
2392: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2393: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2394: (
2395: l_api_name,
2396: G_PKG_NAME,
2397: 'OKC_API.G_RET_STS_ERROR',

Line 2397: 'OKC_API.G_RET_STS_ERROR',

2393: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2394: (
2395: l_api_name,
2396: G_PKG_NAME,
2397: 'OKC_API.G_RET_STS_ERROR',
2398: x_msg_count,
2399: x_msg_data,
2400: '_PVT'
2401: );

Line 2402: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2398: x_msg_count,
2399: x_msg_data,
2400: '_PVT'
2401: );
2402: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2403: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2404: (
2405: l_api_name,
2406: G_PKG_NAME,

Line 2403: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2399: x_msg_data,
2400: '_PVT'
2401: );
2402: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2403: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2404: (
2405: l_api_name,
2406: G_PKG_NAME,
2407: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2407: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2403: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2404: (
2405: l_api_name,
2406: G_PKG_NAME,
2407: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2408: x_msg_count,
2409: x_msg_data,
2410: '_PVT'
2411: );

Line 2413: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2409: x_msg_data,
2410: '_PVT'
2411: );
2412: WHEN OTHERS THEN
2413: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2414: (
2415: l_api_name,
2416: G_PKG_NAME,
2417: 'OTHERS',

Line 2428: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2424: -- PL/SQL TBL update_row for:bsd_pr_tbl --
2425: ------------------------------------------
2426: PROCEDURE update_row(
2427: p_api_version IN NUMBER,
2428: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2429: x_return_status OUT NOCOPY VARCHAR2,
2430: x_msg_count OUT NOCOPY NUMBER,
2431: x_msg_data OUT NOCOPY VARCHAR2,
2432: p_bsd_pr_tbl IN bsd_pr_tbl_type,

Line 2440: OKC_API.init_msg_list(p_init_msg_list);

2436: l_api_version CONSTANT NUMBER := 1;
2437: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2438: i NUMBER := 0;
2439: BEGIN
2440: OKC_API.init_msg_list(p_init_msg_list);
2441: -- Make sure PL/SQL table has records in it before passing
2442: IF (p_bsd_pr_tbl.COUNT > 0) THEN
2443: i := p_bsd_pr_tbl.FIRST;
2444: LOOP

Line 2453: p_init_msg_list => OKC_API.G_FALSE,

2449: l_error_rec.api_package := G_PKG_NAME;
2450: l_error_rec.idx := i;
2451: update_row (
2452: p_api_version => p_api_version,
2453: p_init_msg_list => OKC_API.G_FALSE,
2454: x_return_status => l_error_rec.error_type,
2455: x_msg_count => l_error_rec.msg_count,
2456: x_msg_data => l_error_rec.msg_data,
2457: p_bsd_pr_rec => p_bsd_pr_tbl(i),

Line 2459: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

2455: x_msg_count => l_error_rec.msg_count,
2456: x_msg_data => l_error_rec.msg_data,
2457: p_bsd_pr_rec => p_bsd_pr_tbl(i),
2458: x_bsd_pr_rec => x_bsd_pr_tbl(i));
2459: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2460: l_error_rec.sqlcode := SQLCODE;
2461: load_error_tbl(l_error_rec, px_error_tbl);
2462: ELSE
2463: x_msg_count := l_error_rec.msg_count;

Line 2467: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2463: x_msg_count := l_error_rec.msg_count;
2464: x_msg_data := l_error_rec.msg_data;
2465: END IF;
2466: EXCEPTION
2467: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2468: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2469: l_error_rec.sqlcode := SQLCODE;
2470: load_error_tbl(l_error_rec, px_error_tbl);
2471: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2468: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;

2464: x_msg_data := l_error_rec.msg_data;
2465: END IF;
2466: EXCEPTION
2467: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2468: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2469: l_error_rec.sqlcode := SQLCODE;
2470: load_error_tbl(l_error_rec, px_error_tbl);
2471: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2472: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2471: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2467: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2468: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2469: l_error_rec.sqlcode := SQLCODE;
2470: load_error_tbl(l_error_rec, px_error_tbl);
2471: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2472: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
2473: l_error_rec.sqlcode := SQLCODE;
2474: load_error_tbl(l_error_rec, px_error_tbl);
2475: WHEN OTHERS THEN

Line 2472: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

2468: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2469: l_error_rec.sqlcode := SQLCODE;
2470: load_error_tbl(l_error_rec, px_error_tbl);
2471: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2472: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
2473: l_error_rec.sqlcode := SQLCODE;
2474: load_error_tbl(l_error_rec, px_error_tbl);
2475: WHEN OTHERS THEN
2476: l_error_rec.error_type := 'OTHERS';

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

2483: END IF;
2484: -- Loop through the error_tbl to find the error with the highest severity
2485: -- and return it.
2486: x_return_status := find_highest_exception(px_error_tbl);
2487: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2488: EXCEPTION
2489: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2490: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2491: (

Line 2489: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2485: -- and return it.
2486: x_return_status := find_highest_exception(px_error_tbl);
2487: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2488: EXCEPTION
2489: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2490: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2491: (
2492: l_api_name,
2493: G_PKG_NAME,

Line 2490: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2486: x_return_status := find_highest_exception(px_error_tbl);
2487: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2488: EXCEPTION
2489: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2490: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2491: (
2492: l_api_name,
2493: G_PKG_NAME,
2494: 'OKC_API.G_RET_STS_ERROR',

Line 2494: 'OKC_API.G_RET_STS_ERROR',

2490: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2491: (
2492: l_api_name,
2493: G_PKG_NAME,
2494: 'OKC_API.G_RET_STS_ERROR',
2495: x_msg_count,
2496: x_msg_data,
2497: '_PVT'
2498: );

Line 2499: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2495: x_msg_count,
2496: x_msg_data,
2497: '_PVT'
2498: );
2499: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2500: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2501: (
2502: l_api_name,
2503: G_PKG_NAME,

Line 2500: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2496: x_msg_data,
2497: '_PVT'
2498: );
2499: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2500: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2501: (
2502: l_api_name,
2503: G_PKG_NAME,
2504: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2504: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2500: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2501: (
2502: l_api_name,
2503: G_PKG_NAME,
2504: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2505: x_msg_count,
2506: x_msg_data,
2507: '_PVT'
2508: );

Line 2510: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2506: x_msg_data,
2507: '_PVT'
2508: );
2509: WHEN OTHERS THEN
2510: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2511: (
2512: l_api_name,
2513: G_PKG_NAME,
2514: 'OTHERS',

Line 2526: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2522: -- PL/SQL TBL update_row for:BSD_PR_TBL --
2523: ------------------------------------------
2524: PROCEDURE update_row(
2525: p_api_version IN NUMBER,
2526: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2527: x_return_status OUT NOCOPY VARCHAR2,
2528: x_msg_count OUT NOCOPY NUMBER,
2529: x_msg_data OUT NOCOPY VARCHAR2,
2530: p_bsd_pr_tbl IN bsd_pr_tbl_type,

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

2531: x_bsd_pr_tbl OUT NOCOPY bsd_pr_tbl_type) IS
2532:
2533: l_api_version CONSTANT NUMBER := 1;
2534: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2535: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2536: l_error_tbl ERROR_TBL_TYPE;
2537: BEGIN
2538: OKC_API.init_msg_list(p_init_msg_list);
2539: -- Make sure PL/SQL table has records in it before passing

Line 2538: OKC_API.init_msg_list(p_init_msg_list);

2534: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2535: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2536: l_error_tbl ERROR_TBL_TYPE;
2537: BEGIN
2538: OKC_API.init_msg_list(p_init_msg_list);
2539: -- Make sure PL/SQL table has records in it before passing
2540: IF (p_bsd_pr_tbl.COUNT > 0) THEN
2541: update_row (
2542: p_api_version => p_api_version,

Line 2543: p_init_msg_list => OKC_API.G_FALSE,

2539: -- Make sure PL/SQL table has records in it before passing
2540: IF (p_bsd_pr_tbl.COUNT > 0) THEN
2541: update_row (
2542: p_api_version => p_api_version,
2543: p_init_msg_list => OKC_API.G_FALSE,
2544: x_return_status => x_return_status,
2545: x_msg_count => x_msg_count,
2546: x_msg_data => x_msg_data,
2547: p_bsd_pr_tbl => p_bsd_pr_tbl,

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

2547: p_bsd_pr_tbl => p_bsd_pr_tbl,
2548: x_bsd_pr_tbl => x_bsd_pr_tbl,
2549: px_error_tbl => l_error_tbl);
2550: END IF;
2551: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2552: EXCEPTION
2553: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2554: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2555: (

Line 2553: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2549: px_error_tbl => l_error_tbl);
2550: END IF;
2551: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2552: EXCEPTION
2553: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2554: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2555: (
2556: l_api_name,
2557: G_PKG_NAME,

Line 2554: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2550: END IF;
2551: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2552: EXCEPTION
2553: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2554: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2555: (
2556: l_api_name,
2557: G_PKG_NAME,
2558: 'OKC_API.G_RET_STS_ERROR',

Line 2558: 'OKC_API.G_RET_STS_ERROR',

2554: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2555: (
2556: l_api_name,
2557: G_PKG_NAME,
2558: 'OKC_API.G_RET_STS_ERROR',
2559: x_msg_count,
2560: x_msg_data,
2561: '_PVT'
2562: );

Line 2563: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2559: x_msg_count,
2560: x_msg_data,
2561: '_PVT'
2562: );
2563: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_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: x_msg_data,
2561: '_PVT'
2562: );
2563: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_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_UNEXP_ERROR',

Line 2568: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 2574: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 2592: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2588: -------------------------------
2589: -- delete_row for:OKS_BSD_PR --
2590: -------------------------------
2591: PROCEDURE delete_row(
2592: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2593: x_return_status OUT NOCOPY VARCHAR2,
2594: x_msg_count OUT NOCOPY NUMBER,
2595: x_msg_data OUT NOCOPY VARCHAR2,
2596: p_bsd_pr_rec IN bsd_pr_rec_type) IS

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

2596: p_bsd_pr_rec IN bsd_pr_rec_type) IS
2597:
2598: l_api_version CONSTANT NUMBER := 1;
2599: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2600: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2601: l_bsd_pr_rec bsd_pr_rec_type := p_bsd_pr_rec;
2602: l_row_notfound BOOLEAN := TRUE;
2603: BEGIN
2604: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2600: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2601: l_bsd_pr_rec bsd_pr_rec_type := p_bsd_pr_rec;
2602: l_row_notfound BOOLEAN := TRUE;
2603: BEGIN
2604: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2605: p_init_msg_list,
2606: '_PVT',
2607: x_return_status);
2608: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

2604: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2605: p_init_msg_list,
2606: '_PVT',
2607: x_return_status);
2608: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2609: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2610: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2611: RAISE OKC_API.G_EXCEPTION_ERROR;
2612: END IF;

Line 2609: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2605: p_init_msg_list,
2606: '_PVT',
2607: x_return_status);
2608: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2609: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2610: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2611: RAISE OKC_API.G_EXCEPTION_ERROR;
2612: END IF;
2613:

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

2606: '_PVT',
2607: x_return_status);
2608: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2609: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2610: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2611: RAISE OKC_API.G_EXCEPTION_ERROR;
2612: END IF;
2613:
2614: DELETE FROM OKS_BSD_PR

Line 2611: RAISE OKC_API.G_EXCEPTION_ERROR;

2607: x_return_status);
2608: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2609: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2610: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2611: RAISE OKC_API.G_EXCEPTION_ERROR;
2612: END IF;
2613:
2614: DELETE FROM OKS_BSD_PR
2615: WHERE ID = p_bsd_pr_rec.id;

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

2614: DELETE FROM OKS_BSD_PR
2615: WHERE ID = p_bsd_pr_rec.id;
2616:
2617: x_return_status := l_return_status;
2618: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2619: EXCEPTION
2620: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2621: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2622: (

Line 2620: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2616:
2617: x_return_status := l_return_status;
2618: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2619: EXCEPTION
2620: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2621: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2622: (
2623: l_api_name,
2624: G_PKG_NAME,

Line 2621: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2617: x_return_status := l_return_status;
2618: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2619: EXCEPTION
2620: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2621: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2622: (
2623: l_api_name,
2624: G_PKG_NAME,
2625: 'OKC_API.G_RET_STS_ERROR',

Line 2625: 'OKC_API.G_RET_STS_ERROR',

2621: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2622: (
2623: l_api_name,
2624: G_PKG_NAME,
2625: 'OKC_API.G_RET_STS_ERROR',
2626: x_msg_count,
2627: x_msg_data,
2628: '_PVT'
2629: );

Line 2630: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2631: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2627: x_msg_data,
2628: '_PVT'
2629: );
2630: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2631: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2632: (
2633: l_api_name,
2634: G_PKG_NAME,
2635: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2635: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 2641: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2637: x_msg_data,
2638: '_PVT'
2639: );
2640: WHEN OTHERS THEN
2641: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2642: (
2643: l_api_name,
2644: G_PKG_NAME,
2645: 'OTHERS',

Line 2656: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2652: -- delete_row for:OKS_BSD_PR --
2653: -------------------------------
2654: PROCEDURE delete_row(
2655: p_api_version IN NUMBER,
2656: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2657: x_return_status OUT NOCOPY VARCHAR2,
2658: x_msg_count OUT NOCOPY NUMBER,
2659: x_msg_data OUT NOCOPY VARCHAR2,
2660: p_bsd_pr_rec IN bsd_pr_rec_type) IS

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

2660: p_bsd_pr_rec IN bsd_pr_rec_type) IS
2661:
2662: l_api_version CONSTANT NUMBER := 1;
2663: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2664: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2665: l_bsd_pr_rec bsd_pr_rec_type := p_bsd_pr_rec;
2666: BEGIN
2667: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2668: G_PKG_NAME,

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

2663: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2664: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2665: l_bsd_pr_rec bsd_pr_rec_type := p_bsd_pr_rec;
2666: BEGIN
2667: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2668: G_PKG_NAME,
2669: p_init_msg_list,
2670: l_api_version,
2671: p_api_version,

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

2670: l_api_version,
2671: p_api_version,
2672: '_PVT',
2673: x_return_status);
2674: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2675: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2676: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2677: RAISE OKC_API.G_EXCEPTION_ERROR;
2678: END IF;

Line 2675: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2671: p_api_version,
2672: '_PVT',
2673: x_return_status);
2674: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2675: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2676: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2677: RAISE OKC_API.G_EXCEPTION_ERROR;
2678: END IF;
2679: -----------------------------------------

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

2672: '_PVT',
2673: x_return_status);
2674: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2675: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2676: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2677: RAISE OKC_API.G_EXCEPTION_ERROR;
2678: END IF;
2679: -----------------------------------------
2680: -- Move VIEW record to "Child" records --

Line 2677: RAISE OKC_API.G_EXCEPTION_ERROR;

2673: x_return_status);
2674: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2675: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2676: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2677: RAISE OKC_API.G_EXCEPTION_ERROR;
2678: END IF;
2679: -----------------------------------------
2680: -- Move VIEW record to "Child" records --
2681: -----------------------------------------

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

2689: x_msg_count,
2690: x_msg_data,
2691: l_bsd_pr_rec
2692: );
2693: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2694: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2695: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2696: RAISE OKC_API.G_EXCEPTION_ERROR;
2697: END IF;

Line 2694: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2690: x_msg_data,
2691: l_bsd_pr_rec
2692: );
2693: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2694: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2695: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2696: RAISE OKC_API.G_EXCEPTION_ERROR;
2697: END IF;
2698: x_return_status := l_return_status;

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

2691: l_bsd_pr_rec
2692: );
2693: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2694: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2695: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2696: RAISE OKC_API.G_EXCEPTION_ERROR;
2697: END IF;
2698: x_return_status := l_return_status;
2699: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2696: RAISE OKC_API.G_EXCEPTION_ERROR;

2692: );
2693: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2694: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2695: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2696: RAISE OKC_API.G_EXCEPTION_ERROR;
2697: END IF;
2698: x_return_status := l_return_status;
2699: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2700: EXCEPTION

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

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

Line 2701: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2697: END IF;
2698: x_return_status := l_return_status;
2699: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2700: EXCEPTION
2701: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2702: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2703: (
2704: l_api_name,
2705: G_PKG_NAME,

Line 2702: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2698: x_return_status := l_return_status;
2699: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2700: EXCEPTION
2701: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2702: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2703: (
2704: l_api_name,
2705: G_PKG_NAME,
2706: 'OKC_API.G_RET_STS_ERROR',

Line 2706: 'OKC_API.G_RET_STS_ERROR',

2702: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2703: (
2704: l_api_name,
2705: G_PKG_NAME,
2706: 'OKC_API.G_RET_STS_ERROR',
2707: x_msg_count,
2708: x_msg_data,
2709: '_PVT'
2710: );

Line 2711: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2712: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2708: x_msg_data,
2709: '_PVT'
2710: );
2711: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2712: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2713: (
2714: l_api_name,
2715: G_PKG_NAME,
2716: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2716: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 2722: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2718: x_msg_data,
2719: '_PVT'
2720: );
2721: WHEN OTHERS THEN
2722: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2723: (
2724: l_api_name,
2725: G_PKG_NAME,
2726: 'OTHERS',

Line 2737: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2733: -- PL/SQL TBL delete_row for:OKS_BSD_PR --
2734: ------------------------------------------
2735: PROCEDURE delete_row(
2736: p_api_version IN NUMBER,
2737: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2738: x_return_status OUT NOCOPY VARCHAR2,
2739: x_msg_count OUT NOCOPY NUMBER,
2740: x_msg_data OUT NOCOPY VARCHAR2,
2741: p_bsd_pr_tbl IN bsd_pr_tbl_type,

Line 2748: OKC_API.init_msg_list(p_init_msg_list);

2744: l_api_version CONSTANT NUMBER := 1;
2745: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2746: i NUMBER := 0;
2747: BEGIN
2748: OKC_API.init_msg_list(p_init_msg_list);
2749: -- Make sure PL/SQL table has records in it before passing
2750: IF (p_bsd_pr_tbl.COUNT > 0) THEN
2751: i := p_bsd_pr_tbl.FIRST;
2752: LOOP

Line 2761: p_init_msg_list => OKC_API.G_FALSE,

2757: l_error_rec.api_package := G_PKG_NAME;
2758: l_error_rec.idx := i;
2759: delete_row (
2760: p_api_version => p_api_version,
2761: p_init_msg_list => OKC_API.G_FALSE,
2762: x_return_status => l_error_rec.error_type,
2763: x_msg_count => l_error_rec.msg_count,
2764: x_msg_data => l_error_rec.msg_data,
2765: p_bsd_pr_rec => p_bsd_pr_tbl(i));

Line 2766: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

2762: x_return_status => l_error_rec.error_type,
2763: x_msg_count => l_error_rec.msg_count,
2764: x_msg_data => l_error_rec.msg_data,
2765: p_bsd_pr_rec => p_bsd_pr_tbl(i));
2766: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2767: l_error_rec.sqlcode := SQLCODE;
2768: load_error_tbl(l_error_rec, px_error_tbl);
2769: ELSE
2770: x_msg_count := l_error_rec.msg_count;

Line 2774: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2770: x_msg_count := l_error_rec.msg_count;
2771: x_msg_data := l_error_rec.msg_data;
2772: END IF;
2773: EXCEPTION
2774: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2775: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2776: l_error_rec.sqlcode := SQLCODE;
2777: load_error_tbl(l_error_rec, px_error_tbl);
2778: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2775: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;

2771: x_msg_data := l_error_rec.msg_data;
2772: END IF;
2773: EXCEPTION
2774: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2775: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2776: l_error_rec.sqlcode := SQLCODE;
2777: load_error_tbl(l_error_rec, px_error_tbl);
2778: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2779: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2778: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2774: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2775: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2776: l_error_rec.sqlcode := SQLCODE;
2777: load_error_tbl(l_error_rec, px_error_tbl);
2778: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2779: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
2780: l_error_rec.sqlcode := SQLCODE;
2781: load_error_tbl(l_error_rec, px_error_tbl);
2782: WHEN OTHERS THEN

Line 2779: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

2775: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2776: l_error_rec.sqlcode := SQLCODE;
2777: load_error_tbl(l_error_rec, px_error_tbl);
2778: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2779: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
2780: l_error_rec.sqlcode := SQLCODE;
2781: load_error_tbl(l_error_rec, px_error_tbl);
2782: WHEN OTHERS THEN
2783: l_error_rec.error_type := 'OTHERS';

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

2790: END IF;
2791: -- Loop through the error_tbl to find the error with the highest severity
2792: -- and return it.
2793: x_return_status := find_highest_exception(px_error_tbl);
2794: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2795: EXCEPTION
2796: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2797: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2798: (

Line 2796: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2792: -- and return it.
2793: x_return_status := find_highest_exception(px_error_tbl);
2794: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2795: EXCEPTION
2796: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2797: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2798: (
2799: l_api_name,
2800: G_PKG_NAME,

Line 2797: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2793: x_return_status := find_highest_exception(px_error_tbl);
2794: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2795: EXCEPTION
2796: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2797: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2798: (
2799: l_api_name,
2800: G_PKG_NAME,
2801: 'OKC_API.G_RET_STS_ERROR',

Line 2801: 'OKC_API.G_RET_STS_ERROR',

2797: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2798: (
2799: l_api_name,
2800: G_PKG_NAME,
2801: 'OKC_API.G_RET_STS_ERROR',
2802: x_msg_count,
2803: x_msg_data,
2804: '_PVT'
2805: );

Line 2806: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2807: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2803: x_msg_data,
2804: '_PVT'
2805: );
2806: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2807: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2808: (
2809: l_api_name,
2810: G_PKG_NAME,
2811: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2811: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2807: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2808: (
2809: l_api_name,
2810: G_PKG_NAME,
2811: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2812: x_msg_count,
2813: x_msg_data,
2814: '_PVT'
2815: );

Line 2817: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2813: x_msg_data,
2814: '_PVT'
2815: );
2816: WHEN OTHERS THEN
2817: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2818: (
2819: l_api_name,
2820: G_PKG_NAME,
2821: 'OTHERS',

Line 2833: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2829: -- PL/SQL TBL delete_row for:OKS_BSD_PR --
2830: ------------------------------------------
2831: PROCEDURE delete_row(
2832: p_api_version IN NUMBER,
2833: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2834: x_return_status OUT NOCOPY VARCHAR2,
2835: x_msg_count OUT NOCOPY NUMBER,
2836: x_msg_data OUT NOCOPY VARCHAR2,
2837: p_bsd_pr_tbl IN bsd_pr_tbl_type) IS

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

2837: p_bsd_pr_tbl IN bsd_pr_tbl_type) IS
2838:
2839: l_api_version CONSTANT NUMBER := 1;
2840: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2841: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2842: l_error_tbl ERROR_TBL_TYPE;
2843: BEGIN
2844: OKC_API.init_msg_list(p_init_msg_list);
2845: -- Make sure PL/SQL table has records in it before passing

Line 2844: OKC_API.init_msg_list(p_init_msg_list);

2840: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2841: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2842: l_error_tbl ERROR_TBL_TYPE;
2843: BEGIN
2844: OKC_API.init_msg_list(p_init_msg_list);
2845: -- Make sure PL/SQL table has records in it before passing
2846: IF (p_bsd_pr_tbl.COUNT > 0) THEN
2847: delete_row (
2848: p_api_version => p_api_version,

Line 2849: p_init_msg_list => OKC_API.G_FALSE,

2845: -- Make sure PL/SQL table has records in it before passing
2846: IF (p_bsd_pr_tbl.COUNT > 0) THEN
2847: delete_row (
2848: p_api_version => p_api_version,
2849: p_init_msg_list => OKC_API.G_FALSE,
2850: x_return_status => x_return_status,
2851: x_msg_count => x_msg_count,
2852: x_msg_data => x_msg_data,
2853: p_bsd_pr_tbl => p_bsd_pr_tbl,

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

2852: x_msg_data => x_msg_data,
2853: p_bsd_pr_tbl => p_bsd_pr_tbl,
2854: px_error_tbl => l_error_tbl);
2855: END IF;
2856: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2857: EXCEPTION
2858: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2859: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2860: (

Line 2858: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2854: px_error_tbl => l_error_tbl);
2855: END IF;
2856: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2857: EXCEPTION
2858: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2859: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2860: (
2861: l_api_name,
2862: G_PKG_NAME,

Line 2859: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2855: END IF;
2856: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2857: EXCEPTION
2858: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2859: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2860: (
2861: l_api_name,
2862: G_PKG_NAME,
2863: 'OKC_API.G_RET_STS_ERROR',

Line 2863: 'OKC_API.G_RET_STS_ERROR',

2859: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2860: (
2861: l_api_name,
2862: G_PKG_NAME,
2863: 'OKC_API.G_RET_STS_ERROR',
2864: x_msg_count,
2865: x_msg_data,
2866: '_PVT'
2867: );

Line 2868: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2864: x_msg_count,
2865: x_msg_data,
2866: '_PVT'
2867: );
2868: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2869: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2870: (
2871: l_api_name,
2872: G_PKG_NAME,

Line 2869: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2865: x_msg_data,
2866: '_PVT'
2867: );
2868: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2869: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2870: (
2871: l_api_name,
2872: G_PKG_NAME,
2873: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2873: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2869: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2870: (
2871: l_api_name,
2872: G_PKG_NAME,
2873: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2874: x_msg_count,
2875: x_msg_data,
2876: '_PVT'
2877: );

Line 2879: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2875: x_msg_data,
2876: '_PVT'
2877: );
2878: WHEN OTHERS THEN
2879: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2880: (
2881: l_api_name,
2882: G_PKG_NAME,
2883: 'OTHERS',