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

APPS.OKL_POT_PVT dependencies on OKC_API

Line 7: px_error_rec IN OUT NOCOPY OKC_API.ERROR_REC_TYPE,

3: ---------------------------------------------------------------------------
4: -- PROCEDURE load_error_tbl
5: ---------------------------------------------------------------------------
6: PROCEDURE load_error_tbl (
7: px_error_rec IN OUT NOCOPY OKC_API.ERROR_REC_TYPE,
8: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
9:
10: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
11: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;

Line 8: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

4: -- PROCEDURE load_error_tbl
5: ---------------------------------------------------------------------------
6: PROCEDURE load_error_tbl (
7: px_error_rec IN OUT NOCOPY OKC_API.ERROR_REC_TYPE,
8: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
9:
10: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
11: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;
12: l_msg_idx INTEGER := FND_MSG_PUB.G_NEXT;

Line 40: -- in a OKC_API.ERROR_TBL_TYPE, and returns it.

36: ---------------------------------------------------------------------------
37: -- FUNCTION find_highest_exception
38: ---------------------------------------------------------------------------
39: -- Finds the highest exception (G_RET_STS_UNEXP_ERROR)
40: -- in a OKC_API.ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN OKC_API.ERROR_TBL_TYPE
43: ) RETURN VARCHAR2 IS
44: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 42: p_error_tbl IN OKC_API.ERROR_TBL_TYPE

38: ---------------------------------------------------------------------------
39: -- Finds the highest exception (G_RET_STS_UNEXP_ERROR)
40: -- in a OKC_API.ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN OKC_API.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

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

40: -- in a OKC_API.ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN OKC_API.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 182: x_return_status := OKC_API.G_RET_STS_SUCCESS;

178: ) RETURN potv_rec_type IS
179: l_potv_rec potv_rec_type;
180: l_row_notfound BOOLEAN := TRUE;
181: BEGIN
182: x_return_status := OKC_API.G_RET_STS_SUCCESS;
183: l_potv_rec := get_rec(p_potv_rec, l_row_notfound);
184: IF (l_row_notfound) THEN
185: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
186: x_return_status := OKC_API.G_RET_STS_ERROR;

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

181: BEGIN
182: x_return_status := OKC_API.G_RET_STS_SUCCESS;
183: l_potv_rec := get_rec(p_potv_rec, l_row_notfound);
184: IF (l_row_notfound) THEN
185: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
186: x_return_status := OKC_API.G_RET_STS_ERROR;
187: END IF;
188: RETURN(l_potv_rec);
189: END get_rec;

Line 186: x_return_status := OKC_API.G_RET_STS_ERROR;

182: x_return_status := OKC_API.G_RET_STS_SUCCESS;
183: l_potv_rec := get_rec(p_potv_rec, l_row_notfound);
184: IF (l_row_notfound) THEN
185: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
186: x_return_status := OKC_API.G_RET_STS_ERROR;
187: END IF;
188: RETURN(l_potv_rec);
189: END get_rec;
190: -----------------------------------------------------------

Line 289: x_return_status := OKC_API.G_RET_STS_SUCCESS;

285: ) RETURN pot_rec_type IS
286: l_pot_rec pot_rec_type;
287: l_row_notfound BOOLEAN := TRUE;
288: BEGIN
289: x_return_status := OKC_API.G_RET_STS_SUCCESS;
290: l_pot_rec := get_rec(p_pot_rec, l_row_notfound);
291: IF (l_row_notfound) THEN
292: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
293: x_return_status := OKC_API.G_RET_STS_ERROR;

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

288: BEGIN
289: x_return_status := OKC_API.G_RET_STS_SUCCESS;
290: l_pot_rec := get_rec(p_pot_rec, l_row_notfound);
291: IF (l_row_notfound) THEN
292: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
293: x_return_status := OKC_API.G_RET_STS_ERROR;
294: END IF;
295: RETURN(l_pot_rec);
296: END get_rec;

Line 293: x_return_status := OKC_API.G_RET_STS_ERROR;

289: x_return_status := OKC_API.G_RET_STS_SUCCESS;
290: l_pot_rec := get_rec(p_pot_rec, l_row_notfound);
291: IF (l_row_notfound) THEN
292: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
293: x_return_status := OKC_API.G_RET_STS_ERROR;
294: END IF;
295: RETURN(l_pot_rec);
296: END get_rec;
297: -----------------------------------------------------------

Line 317: IF (l_potv_rec.id = OKC_API.G_MISS_NUM ) THEN

313: p_potv_rec IN potv_rec_type
314: ) RETURN potv_rec_type IS
315: l_potv_rec potv_rec_type := p_potv_rec;
316: BEGIN
317: IF (l_potv_rec.id = OKC_API.G_MISS_NUM ) THEN
318: l_potv_rec.id := NULL;
319: END IF;
320: IF (l_potv_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
321: l_potv_rec.object_version_number := NULL;

Line 320: IF (l_potv_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN

316: BEGIN
317: IF (l_potv_rec.id = OKC_API.G_MISS_NUM ) THEN
318: l_potv_rec.id := NULL;
319: END IF;
320: IF (l_potv_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
321: l_potv_rec.object_version_number := NULL;
322: END IF;
323: IF (l_potv_rec.code = OKC_API.G_MISS_CHAR ) THEN
324: l_potv_rec.code := NULL;

Line 323: IF (l_potv_rec.code = OKC_API.G_MISS_CHAR ) THEN

319: END IF;
320: IF (l_potv_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
321: l_potv_rec.object_version_number := NULL;
322: END IF;
323: IF (l_potv_rec.code = OKC_API.G_MISS_CHAR ) THEN
324: l_potv_rec.code := NULL;
325: END IF;
326: IF (l_potv_rec.description = OKC_API.G_MISS_CHAR ) THEN
327: l_potv_rec.description := NULL;

Line 326: IF (l_potv_rec.description = OKC_API.G_MISS_CHAR ) THEN

322: END IF;
323: IF (l_potv_rec.code = OKC_API.G_MISS_CHAR ) THEN
324: l_potv_rec.code := NULL;
325: END IF;
326: IF (l_potv_rec.description = OKC_API.G_MISS_CHAR ) THEN
327: l_potv_rec.description := NULL;
328: END IF;
329: IF (l_potv_rec.short_description = OKC_API.G_MISS_CHAR ) THEN
330: l_potv_rec.short_description := NULL;

Line 329: IF (l_potv_rec.short_description = OKC_API.G_MISS_CHAR ) THEN

325: END IF;
326: IF (l_potv_rec.description = OKC_API.G_MISS_CHAR ) THEN
327: l_potv_rec.description := NULL;
328: END IF;
329: IF (l_potv_rec.short_description = OKC_API.G_MISS_CHAR ) THEN
330: l_potv_rec.short_description := NULL;
331: END IF;
332: IF (l_potv_rec.from_date = OKC_API.G_MISS_DATE ) THEN
333: l_potv_rec.from_date := NULL;

Line 332: IF (l_potv_rec.from_date = OKC_API.G_MISS_DATE ) THEN

328: END IF;
329: IF (l_potv_rec.short_description = OKC_API.G_MISS_CHAR ) THEN
330: l_potv_rec.short_description := NULL;
331: END IF;
332: IF (l_potv_rec.from_date = OKC_API.G_MISS_DATE ) THEN
333: l_potv_rec.from_date := NULL;
334: END IF;
335: IF (l_potv_rec.TO_DATE = OKC_API.G_MISS_DATE ) THEN
336: l_potv_rec.TO_DATE := NULL;

Line 335: IF (l_potv_rec.TO_DATE = OKC_API.G_MISS_DATE ) THEN

331: END IF;
332: IF (l_potv_rec.from_date = OKC_API.G_MISS_DATE ) THEN
333: l_potv_rec.from_date := NULL;
334: END IF;
335: IF (l_potv_rec.TO_DATE = OKC_API.G_MISS_DATE ) THEN
336: l_potv_rec.TO_DATE := NULL;
337: END IF;
338: IF (l_potv_rec.attribute_category = OKC_API.G_MISS_CHAR ) THEN
339: l_potv_rec.attribute_category := NULL;

Line 338: IF (l_potv_rec.attribute_category = OKC_API.G_MISS_CHAR ) THEN

334: END IF;
335: IF (l_potv_rec.TO_DATE = OKC_API.G_MISS_DATE ) THEN
336: l_potv_rec.TO_DATE := NULL;
337: END IF;
338: IF (l_potv_rec.attribute_category = OKC_API.G_MISS_CHAR ) THEN
339: l_potv_rec.attribute_category := NULL;
340: END IF;
341: IF (l_potv_rec.attribute1 = OKC_API.G_MISS_CHAR ) THEN
342: l_potv_rec.attribute1 := NULL;

Line 341: IF (l_potv_rec.attribute1 = OKC_API.G_MISS_CHAR ) THEN

337: END IF;
338: IF (l_potv_rec.attribute_category = OKC_API.G_MISS_CHAR ) THEN
339: l_potv_rec.attribute_category := NULL;
340: END IF;
341: IF (l_potv_rec.attribute1 = OKC_API.G_MISS_CHAR ) THEN
342: l_potv_rec.attribute1 := NULL;
343: END IF;
344: IF (l_potv_rec.attribute2 = OKC_API.G_MISS_CHAR ) THEN
345: l_potv_rec.attribute2 := NULL;

Line 344: IF (l_potv_rec.attribute2 = OKC_API.G_MISS_CHAR ) THEN

340: END IF;
341: IF (l_potv_rec.attribute1 = OKC_API.G_MISS_CHAR ) THEN
342: l_potv_rec.attribute1 := NULL;
343: END IF;
344: IF (l_potv_rec.attribute2 = OKC_API.G_MISS_CHAR ) THEN
345: l_potv_rec.attribute2 := NULL;
346: END IF;
347: IF (l_potv_rec.attribute3 = OKC_API.G_MISS_CHAR ) THEN
348: l_potv_rec.attribute3 := NULL;

Line 347: IF (l_potv_rec.attribute3 = OKC_API.G_MISS_CHAR ) THEN

343: END IF;
344: IF (l_potv_rec.attribute2 = OKC_API.G_MISS_CHAR ) THEN
345: l_potv_rec.attribute2 := NULL;
346: END IF;
347: IF (l_potv_rec.attribute3 = OKC_API.G_MISS_CHAR ) THEN
348: l_potv_rec.attribute3 := NULL;
349: END IF;
350: IF (l_potv_rec.attribute4 = OKC_API.G_MISS_CHAR ) THEN
351: l_potv_rec.attribute4 := NULL;

Line 350: IF (l_potv_rec.attribute4 = OKC_API.G_MISS_CHAR ) THEN

346: END IF;
347: IF (l_potv_rec.attribute3 = OKC_API.G_MISS_CHAR ) THEN
348: l_potv_rec.attribute3 := NULL;
349: END IF;
350: IF (l_potv_rec.attribute4 = OKC_API.G_MISS_CHAR ) THEN
351: l_potv_rec.attribute4 := NULL;
352: END IF;
353: IF (l_potv_rec.attribute5 = OKC_API.G_MISS_CHAR ) THEN
354: l_potv_rec.attribute5 := NULL;

Line 353: IF (l_potv_rec.attribute5 = OKC_API.G_MISS_CHAR ) THEN

349: END IF;
350: IF (l_potv_rec.attribute4 = OKC_API.G_MISS_CHAR ) THEN
351: l_potv_rec.attribute4 := NULL;
352: END IF;
353: IF (l_potv_rec.attribute5 = OKC_API.G_MISS_CHAR ) THEN
354: l_potv_rec.attribute5 := NULL;
355: END IF;
356: IF (l_potv_rec.attribute6 = OKC_API.G_MISS_CHAR ) THEN
357: l_potv_rec.attribute6 := NULL;

Line 356: IF (l_potv_rec.attribute6 = OKC_API.G_MISS_CHAR ) THEN

352: END IF;
353: IF (l_potv_rec.attribute5 = OKC_API.G_MISS_CHAR ) THEN
354: l_potv_rec.attribute5 := NULL;
355: END IF;
356: IF (l_potv_rec.attribute6 = OKC_API.G_MISS_CHAR ) THEN
357: l_potv_rec.attribute6 := NULL;
358: END IF;
359: IF (l_potv_rec.attribute7 = OKC_API.G_MISS_CHAR ) THEN
360: l_potv_rec.attribute7 := NULL;

Line 359: IF (l_potv_rec.attribute7 = OKC_API.G_MISS_CHAR ) THEN

355: END IF;
356: IF (l_potv_rec.attribute6 = OKC_API.G_MISS_CHAR ) THEN
357: l_potv_rec.attribute6 := NULL;
358: END IF;
359: IF (l_potv_rec.attribute7 = OKC_API.G_MISS_CHAR ) THEN
360: l_potv_rec.attribute7 := NULL;
361: END IF;
362: IF (l_potv_rec.attribute8 = OKC_API.G_MISS_CHAR ) THEN
363: l_potv_rec.attribute8 := NULL;

Line 362: IF (l_potv_rec.attribute8 = OKC_API.G_MISS_CHAR ) THEN

358: END IF;
359: IF (l_potv_rec.attribute7 = OKC_API.G_MISS_CHAR ) THEN
360: l_potv_rec.attribute7 := NULL;
361: END IF;
362: IF (l_potv_rec.attribute8 = OKC_API.G_MISS_CHAR ) THEN
363: l_potv_rec.attribute8 := NULL;
364: END IF;
365: IF (l_potv_rec.attribute9 = OKC_API.G_MISS_CHAR ) THEN
366: l_potv_rec.attribute9 := NULL;

Line 365: IF (l_potv_rec.attribute9 = OKC_API.G_MISS_CHAR ) THEN

361: END IF;
362: IF (l_potv_rec.attribute8 = OKC_API.G_MISS_CHAR ) THEN
363: l_potv_rec.attribute8 := NULL;
364: END IF;
365: IF (l_potv_rec.attribute9 = OKC_API.G_MISS_CHAR ) THEN
366: l_potv_rec.attribute9 := NULL;
367: END IF;
368: IF (l_potv_rec.attribute10 = OKC_API.G_MISS_CHAR ) THEN
369: l_potv_rec.attribute10 := NULL;

Line 368: IF (l_potv_rec.attribute10 = OKC_API.G_MISS_CHAR ) THEN

364: END IF;
365: IF (l_potv_rec.attribute9 = OKC_API.G_MISS_CHAR ) THEN
366: l_potv_rec.attribute9 := NULL;
367: END IF;
368: IF (l_potv_rec.attribute10 = OKC_API.G_MISS_CHAR ) THEN
369: l_potv_rec.attribute10 := NULL;
370: END IF;
371: IF (l_potv_rec.attribute11 = OKC_API.G_MISS_CHAR ) THEN
372: l_potv_rec.attribute11 := NULL;

Line 371: IF (l_potv_rec.attribute11 = OKC_API.G_MISS_CHAR ) THEN

367: END IF;
368: IF (l_potv_rec.attribute10 = OKC_API.G_MISS_CHAR ) THEN
369: l_potv_rec.attribute10 := NULL;
370: END IF;
371: IF (l_potv_rec.attribute11 = OKC_API.G_MISS_CHAR ) THEN
372: l_potv_rec.attribute11 := NULL;
373: END IF;
374: IF (l_potv_rec.attribute12 = OKC_API.G_MISS_CHAR ) THEN
375: l_potv_rec.attribute12 := NULL;

Line 374: IF (l_potv_rec.attribute12 = OKC_API.G_MISS_CHAR ) THEN

370: END IF;
371: IF (l_potv_rec.attribute11 = OKC_API.G_MISS_CHAR ) THEN
372: l_potv_rec.attribute11 := NULL;
373: END IF;
374: IF (l_potv_rec.attribute12 = OKC_API.G_MISS_CHAR ) THEN
375: l_potv_rec.attribute12 := NULL;
376: END IF;
377: IF (l_potv_rec.attribute13 = OKC_API.G_MISS_CHAR ) THEN
378: l_potv_rec.attribute13 := NULL;

Line 377: IF (l_potv_rec.attribute13 = OKC_API.G_MISS_CHAR ) THEN

373: END IF;
374: IF (l_potv_rec.attribute12 = OKC_API.G_MISS_CHAR ) THEN
375: l_potv_rec.attribute12 := NULL;
376: END IF;
377: IF (l_potv_rec.attribute13 = OKC_API.G_MISS_CHAR ) THEN
378: l_potv_rec.attribute13 := NULL;
379: END IF;
380: IF (l_potv_rec.attribute14 = OKC_API.G_MISS_CHAR ) THEN
381: l_potv_rec.attribute14 := NULL;

Line 380: IF (l_potv_rec.attribute14 = OKC_API.G_MISS_CHAR ) THEN

376: END IF;
377: IF (l_potv_rec.attribute13 = OKC_API.G_MISS_CHAR ) THEN
378: l_potv_rec.attribute13 := NULL;
379: END IF;
380: IF (l_potv_rec.attribute14 = OKC_API.G_MISS_CHAR ) THEN
381: l_potv_rec.attribute14 := NULL;
382: END IF;
383: IF (l_potv_rec.attribute15 = OKC_API.G_MISS_CHAR ) THEN
384: l_potv_rec.attribute15 := NULL;

Line 383: IF (l_potv_rec.attribute15 = OKC_API.G_MISS_CHAR ) THEN

379: END IF;
380: IF (l_potv_rec.attribute14 = OKC_API.G_MISS_CHAR ) THEN
381: l_potv_rec.attribute14 := NULL;
382: END IF;
383: IF (l_potv_rec.attribute15 = OKC_API.G_MISS_CHAR ) THEN
384: l_potv_rec.attribute15 := NULL;
385: END IF;
386: IF (l_potv_rec.created_by = OKC_API.G_MISS_NUM ) THEN
387: l_potv_rec.created_by := NULL;

Line 386: IF (l_potv_rec.created_by = OKC_API.G_MISS_NUM ) THEN

382: END IF;
383: IF (l_potv_rec.attribute15 = OKC_API.G_MISS_CHAR ) THEN
384: l_potv_rec.attribute15 := NULL;
385: END IF;
386: IF (l_potv_rec.created_by = OKC_API.G_MISS_NUM ) THEN
387: l_potv_rec.created_by := NULL;
388: END IF;
389: IF (l_potv_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
390: l_potv_rec.creation_date := NULL;

Line 389: IF (l_potv_rec.creation_date = OKC_API.G_MISS_DATE ) THEN

385: END IF;
386: IF (l_potv_rec.created_by = OKC_API.G_MISS_NUM ) THEN
387: l_potv_rec.created_by := NULL;
388: END IF;
389: IF (l_potv_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
390: l_potv_rec.creation_date := NULL;
391: END IF;
392: IF (l_potv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
393: l_potv_rec.last_updated_by := NULL;

Line 392: IF (l_potv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN

388: END IF;
389: IF (l_potv_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
390: l_potv_rec.creation_date := NULL;
391: END IF;
392: IF (l_potv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
393: l_potv_rec.last_updated_by := NULL;
394: END IF;
395: IF (l_potv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
396: l_potv_rec.last_update_date := NULL;

Line 395: IF (l_potv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN

391: END IF;
392: IF (l_potv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
393: l_potv_rec.last_updated_by := NULL;
394: END IF;
395: IF (l_potv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
396: l_potv_rec.last_update_date := NULL;
397: END IF;
398: IF (l_potv_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
399: l_potv_rec.last_update_login := NULL;

Line 398: IF (l_potv_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN

394: END IF;
395: IF (l_potv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
396: l_potv_rec.last_update_date := NULL;
397: END IF;
398: IF (l_potv_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
399: l_potv_rec.last_update_login := NULL;
400: END IF;
401:
402: RETURN(l_potv_rec);

Line 412: x_return_status := OKC_API.G_RET_STS_SUCCESS;

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

Line 413: IF (p_id = OKC_API.G_MISS_NUM OR

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

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

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

Line 417: x_return_status := OKC_API.G_RET_STS_ERROR;

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

Line 424: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

420: EXCEPTION
421: WHEN G_EXCEPTION_HALT_VALIDATION THEN
422: NULL;
423: WHEN OTHERS THEN
424: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
425: ,p_msg_name => G_UNEXPECTED_ERROR
426: ,p_token1 => G_SQLCODE_TOKEN
427: ,p_token1_value => SQLCODE
428: ,p_token2 => G_SQLERRM_TOKEN

Line 430: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

426: ,p_token1 => G_SQLCODE_TOKEN
427: ,p_token1_value => SQLCODE
428: ,p_token2 => G_SQLERRM_TOKEN
429: ,p_token2_value => SQLERRM);
430: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
431: END validate_id;
432:
433: ----------------------------------------------------
434: -- Validate_Attributes for: OBJECT_VERSION_NUMBER --

Line 440: x_return_status := OKC_API.G_RET_STS_SUCCESS;

436: PROCEDURE validate_object_version_number(
437: x_return_status OUT NOCOPY VARCHAR2,
438: p_object_version_number IN NUMBER) IS
439: BEGIN
440: x_return_status := OKC_API.G_RET_STS_SUCCESS;
441: IF (p_object_version_number = OKC_API.G_MISS_NUM OR
442: p_object_version_number IS NULL)
443: THEN
444: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');

Line 441: IF (p_object_version_number = OKC_API.G_MISS_NUM OR

437: x_return_status OUT NOCOPY VARCHAR2,
438: p_object_version_number IN NUMBER) IS
439: BEGIN
440: x_return_status := OKC_API.G_RET_STS_SUCCESS;
441: IF (p_object_version_number = OKC_API.G_MISS_NUM OR
442: p_object_version_number IS NULL)
443: THEN
444: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
445: x_return_status := OKC_API.G_RET_STS_ERROR;

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

440: x_return_status := OKC_API.G_RET_STS_SUCCESS;
441: IF (p_object_version_number = OKC_API.G_MISS_NUM OR
442: p_object_version_number IS NULL)
443: THEN
444: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
445: x_return_status := OKC_API.G_RET_STS_ERROR;
446: RAISE G_EXCEPTION_HALT_VALIDATION;
447: END IF;
448: EXCEPTION

Line 445: x_return_status := OKC_API.G_RET_STS_ERROR;

441: IF (p_object_version_number = OKC_API.G_MISS_NUM OR
442: p_object_version_number IS NULL)
443: THEN
444: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
445: x_return_status := OKC_API.G_RET_STS_ERROR;
446: RAISE G_EXCEPTION_HALT_VALIDATION;
447: END IF;
448: EXCEPTION
449: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 452: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

448: EXCEPTION
449: WHEN G_EXCEPTION_HALT_VALIDATION THEN
450: NULL;
451: WHEN OTHERS THEN
452: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
453: ,p_msg_name => G_UNEXPECTED_ERROR
454: ,p_token1 => G_SQLCODE_TOKEN
455: ,p_token1_value => SQLCODE
456: ,p_token2 => G_SQLERRM_TOKEN

Line 458: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

454: ,p_token1 => G_SQLCODE_TOKEN
455: ,p_token1_value => SQLCODE
456: ,p_token2 => G_SQLERRM_TOKEN
457: ,p_token2_value => SQLERRM);
458: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
459: END validate_object_version_number;
460:
461: -------------------------------------
462: -- Validate_Attributes for: code --

Line 468: x_return_status := OKC_API.G_RET_STS_SUCCESS;

464: PROCEDURE validate_code(
465: x_return_status OUT NOCOPY VARCHAR2,
466: p_code IN VARCHAR2) IS
467: BEGIN
468: x_return_status := OKC_API.G_RET_STS_SUCCESS;
469: IF (p_code = OKC_API.G_MISS_CHAR OR
470: p_code IS NULL)
471: THEN
472: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'code');

Line 469: IF (p_code = OKC_API.G_MISS_CHAR OR

465: x_return_status OUT NOCOPY VARCHAR2,
466: p_code IN VARCHAR2) IS
467: BEGIN
468: x_return_status := OKC_API.G_RET_STS_SUCCESS;
469: IF (p_code = OKC_API.G_MISS_CHAR OR
470: p_code IS NULL)
471: THEN
472: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'code');
473: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 472: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'code');

468: x_return_status := OKC_API.G_RET_STS_SUCCESS;
469: IF (p_code = OKC_API.G_MISS_CHAR OR
470: p_code IS NULL)
471: THEN
472: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'code');
473: x_return_status := OKC_API.G_RET_STS_ERROR;
474: RAISE G_EXCEPTION_HALT_VALIDATION;
475: END IF;
476: EXCEPTION

Line 473: x_return_status := OKC_API.G_RET_STS_ERROR;

469: IF (p_code = OKC_API.G_MISS_CHAR OR
470: p_code IS NULL)
471: THEN
472: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'code');
473: x_return_status := OKC_API.G_RET_STS_ERROR;
474: RAISE G_EXCEPTION_HALT_VALIDATION;
475: END IF;
476: EXCEPTION
477: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 480: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

476: EXCEPTION
477: WHEN G_EXCEPTION_HALT_VALIDATION THEN
478: NULL;
479: WHEN OTHERS THEN
480: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
481: ,p_msg_name => G_UNEXPECTED_ERROR
482: ,p_token1 => G_SQLCODE_TOKEN
483: ,p_token1_value => SQLCODE
484: ,p_token2 => G_SQLERRM_TOKEN

Line 486: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

482: ,p_token1 => G_SQLCODE_TOKEN
483: ,p_token1_value => SQLCODE
484: ,p_token2 => G_SQLERRM_TOKEN
485: ,p_token2_value => SQLERRM);
486: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
487: END validate_code;
488:
489: ---------------------------------------------------------------------------
490: -- FUNCTION Validate_Attributes

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

494: ---------------------------------------------------
495: FUNCTION Validate_Attributes (
496: p_potv_rec IN potv_rec_type
497: ) RETURN VARCHAR2 IS
498: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
499: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
500: BEGIN
501: -----------------------------
502: -- Column Level Validation --

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

495: FUNCTION Validate_Attributes (
496: p_potv_rec IN potv_rec_type
497: ) RETURN VARCHAR2 IS
498: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
499: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
500: BEGIN
501: -----------------------------
502: -- Column Level Validation --
503: -----------------------------

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

504: -- ***
505: -- id
506: -- ***
507: validate_id(x_return_status, p_potv_rec.id);
508: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
509: l_return_status := x_return_status;
510: RAISE G_EXCEPTION_HALT_VALIDATION;
511: END IF;
512:

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

513: -- ***
514: -- object_version_number
515: -- ***
516: validate_object_version_number(x_return_status, p_potv_rec.object_version_number);
517: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
518: l_return_status := x_return_status;
519: RAISE G_EXCEPTION_HALT_VALIDATION;
520: END IF;
521:

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

522: -- ***
523: -- code
524: -- ***
525: validate_code(x_return_status, p_potv_rec.code);
526: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
527: l_return_status := x_return_status;
528: RAISE G_EXCEPTION_HALT_VALIDATION;
529: END IF;
530:

Line 536: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

532: EXCEPTION
533: WHEN G_EXCEPTION_HALT_VALIDATION THEN
534: RETURN(l_return_status);
535: WHEN OTHERS THEN
536: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
537: ,p_msg_name => G_UNEXPECTED_ERROR
538: ,p_token1 => G_SQLCODE_TOKEN
539: ,p_token1_value => SQLCODE
540: ,p_token2 => G_SQLERRM_TOKEN

Line 542: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

538: ,p_token1 => G_SQLCODE_TOKEN
539: ,p_token1_value => SQLCODE
540: ,p_token2 => G_SQLERRM_TOKEN
541: ,p_token2_value => SQLERRM);
542: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
543: RETURN(l_return_status);
544: END Validate_Attributes;
545: ---------------------------------------------------------------------------
546: -- PROCEDURE Validate_Record

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

551: FUNCTION Validate_Record (
552: p_potv_rec IN potv_rec_type,
553: p_db_potv_rec IN potv_rec_type
554: ) RETURN VARCHAR2 IS
555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
556: ------------------------------------
557: -- FUNCTION validate_foreign_keys --
558: ------------------------------------
559: FUNCTION validate_foreign_keys (

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

560: p_potv_rec IN potv_rec_type,
561: p_db_potv_rec IN potv_rec_type
562: ) RETURN VARCHAR2 IS
563: item_not_found_error EXCEPTION;
564: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
565: l_row_notfound BOOLEAN := TRUE;
566: BEGIN
567: RETURN (l_return_status);
568: EXCEPTION

Line 570: l_return_status := OKC_API.G_RET_STS_ERROR;

566: BEGIN
567: RETURN (l_return_status);
568: EXCEPTION
569: WHEN item_not_found_error THEN
570: l_return_status := OKC_API.G_RET_STS_ERROR;
571: RETURN (l_return_status);
572: END validate_foreign_keys;
573: BEGIN
574: l_return_status := validate_foreign_keys(p_potv_rec, p_db_potv_rec);

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

576: END Validate_Record;
577: FUNCTION Validate_Record (
578: p_potv_rec IN potv_rec_type
579: ) RETURN VARCHAR2 IS
580: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
581: l_db_potv_rec potv_rec_type := get_rec(p_potv_rec);
582: BEGIN
583: l_return_status := Validate_Record(p_potv_rec => p_potv_rec,
584: p_db_potv_rec => l_db_potv_rec);

Line 668: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

664: -- validate_row for:OKL_POOL_TYPES_V --
665: --------------------------------------------
666: PROCEDURE validate_row(
667: p_api_version IN NUMBER,
668: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
669: x_return_status OUT NOCOPY VARCHAR2,
670: x_msg_count OUT NOCOPY NUMBER,
671: x_msg_data OUT NOCOPY VARCHAR2,
672: p_potv_rec IN potv_rec_type) IS

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

672: p_potv_rec IN potv_rec_type) IS
673:
674: l_api_version CONSTANT NUMBER := 1;
675: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
676: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
677: l_potv_rec potv_rec_type := p_potv_rec;
678: l_pot_rec pot_rec_type;
679: l_pot_rec pot_rec_type;
680: BEGIN

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

677: l_potv_rec potv_rec_type := p_potv_rec;
678: l_pot_rec pot_rec_type;
679: l_pot_rec pot_rec_type;
680: BEGIN
681: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
682: G_PKG_NAME,
683: p_init_msg_list,
684: l_api_version,
685: p_api_version,

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

684: l_api_version,
685: p_api_version,
686: '_PVT',
687: x_return_status);
688: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
689: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
690: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
691: RAISE OKC_API.G_EXCEPTION_ERROR;
692: END IF;

Line 689: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

685: p_api_version,
686: '_PVT',
687: x_return_status);
688: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
689: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
690: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
691: RAISE OKC_API.G_EXCEPTION_ERROR;
692: END IF;
693: --- Validate all non-missing attributes (Item Level Validation)

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

686: '_PVT',
687: x_return_status);
688: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
689: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
690: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
691: RAISE OKC_API.G_EXCEPTION_ERROR;
692: END IF;
693: --- Validate all non-missing attributes (Item Level Validation)
694: l_return_status := Validate_Attributes(l_potv_rec);

Line 691: RAISE OKC_API.G_EXCEPTION_ERROR;

687: x_return_status);
688: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
689: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
690: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
691: RAISE OKC_API.G_EXCEPTION_ERROR;
692: END IF;
693: --- Validate all non-missing attributes (Item Level Validation)
694: l_return_status := Validate_Attributes(l_potv_rec);
695: --- If any errors happen abort API

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

692: END IF;
693: --- Validate all non-missing attributes (Item Level Validation)
694: l_return_status := Validate_Attributes(l_potv_rec);
695: --- If any errors happen abort API
696: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
697: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
698: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
699: RAISE OKC_API.G_EXCEPTION_ERROR;
700: END IF;

Line 697: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

693: --- Validate all non-missing attributes (Item Level Validation)
694: l_return_status := Validate_Attributes(l_potv_rec);
695: --- If any errors happen abort API
696: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
697: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
698: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
699: RAISE OKC_API.G_EXCEPTION_ERROR;
700: END IF;
701: l_return_status := Validate_Record(l_potv_rec);

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

694: l_return_status := Validate_Attributes(l_potv_rec);
695: --- If any errors happen abort API
696: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
697: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
698: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
699: RAISE OKC_API.G_EXCEPTION_ERROR;
700: END IF;
701: l_return_status := Validate_Record(l_potv_rec);
702: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 699: RAISE OKC_API.G_EXCEPTION_ERROR;

695: --- If any errors happen abort API
696: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
697: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
698: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
699: RAISE OKC_API.G_EXCEPTION_ERROR;
700: END IF;
701: l_return_status := Validate_Record(l_potv_rec);
702: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
703: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

698: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
699: RAISE OKC_API.G_EXCEPTION_ERROR;
700: END IF;
701: l_return_status := Validate_Record(l_potv_rec);
702: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
703: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
704: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_ERROR;
706: END IF;

Line 703: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

699: RAISE OKC_API.G_EXCEPTION_ERROR;
700: END IF;
701: l_return_status := Validate_Record(l_potv_rec);
702: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
703: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
704: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_ERROR;
706: END IF;
707: x_return_status := l_return_status;

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

700: END IF;
701: l_return_status := Validate_Record(l_potv_rec);
702: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
703: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
704: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_ERROR;
706: END IF;
707: x_return_status := l_return_status;
708: EXCEPTION

Line 705: RAISE OKC_API.G_EXCEPTION_ERROR;

701: l_return_status := Validate_Record(l_potv_rec);
702: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
703: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
704: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_ERROR;
706: END IF;
707: x_return_status := l_return_status;
708: EXCEPTION
709: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 709: WHEN OKC_API.G_EXCEPTION_ERROR THEN

705: RAISE OKC_API.G_EXCEPTION_ERROR;
706: END IF;
707: x_return_status := l_return_status;
708: EXCEPTION
709: WHEN OKC_API.G_EXCEPTION_ERROR THEN
710: x_return_status := OKC_API.HANDLE_EXCEPTIONS
711: (
712: l_api_name,
713: G_PKG_NAME,

Line 710: x_return_status := OKC_API.HANDLE_EXCEPTIONS

706: END IF;
707: x_return_status := l_return_status;
708: EXCEPTION
709: WHEN OKC_API.G_EXCEPTION_ERROR THEN
710: x_return_status := OKC_API.HANDLE_EXCEPTIONS
711: (
712: l_api_name,
713: G_PKG_NAME,
714: 'OKC_API.G_RET_STS_ERROR',

Line 714: 'OKC_API.G_RET_STS_ERROR',

710: x_return_status := OKC_API.HANDLE_EXCEPTIONS
711: (
712: l_api_name,
713: G_PKG_NAME,
714: 'OKC_API.G_RET_STS_ERROR',
715: x_msg_count,
716: x_msg_data,
717: '_PVT'
718: );

Line 719: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

715: x_msg_count,
716: x_msg_data,
717: '_PVT'
718: );
719: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
720: x_return_status := OKC_API.HANDLE_EXCEPTIONS
721: (
722: l_api_name,
723: G_PKG_NAME,

Line 720: x_return_status := OKC_API.HANDLE_EXCEPTIONS

716: x_msg_data,
717: '_PVT'
718: );
719: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
720: x_return_status := OKC_API.HANDLE_EXCEPTIONS
721: (
722: l_api_name,
723: G_PKG_NAME,
724: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 724: 'OKC_API.G_RET_STS_UNEXP_ERROR',

720: x_return_status := OKC_API.HANDLE_EXCEPTIONS
721: (
722: l_api_name,
723: G_PKG_NAME,
724: 'OKC_API.G_RET_STS_UNEXP_ERROR',
725: x_msg_count,
726: x_msg_data,
727: '_PVT'
728: );

Line 730: x_return_status := OKC_API.HANDLE_EXCEPTIONS

726: x_msg_data,
727: '_PVT'
728: );
729: WHEN OTHERS THEN
730: x_return_status := OKC_API.HANDLE_EXCEPTIONS
731: (
732: l_api_name,
733: G_PKG_NAME,
734: 'OTHERS',

Line 745: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

741: -- PL/SQL TBL validate_row for:OKL_POOL_TYPES_V --
742: -------------------------------------------------------
743: PROCEDURE validate_row(
744: p_api_version IN NUMBER,
745: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
746: x_return_status OUT NOCOPY VARCHAR2,
747: x_msg_count OUT NOCOPY NUMBER,
748: x_msg_data OUT NOCOPY VARCHAR2,
749: p_potv_tbl IN potv_tbl_type,

Line 750: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

746: x_return_status OUT NOCOPY VARCHAR2,
747: x_msg_count OUT NOCOPY NUMBER,
748: x_msg_data OUT NOCOPY VARCHAR2,
749: p_potv_tbl IN potv_tbl_type,
750: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
751:
752: l_api_version CONSTANT NUMBER := 1;
753: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
754: i NUMBER := 0;

Line 756: OKC_API.init_msg_list(p_init_msg_list);

752: l_api_version CONSTANT NUMBER := 1;
753: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
754: i NUMBER := 0;
755: BEGIN
756: OKC_API.init_msg_list(p_init_msg_list);
757: -- Make sure PL/SQL table has records in it before passing
758: IF (p_potv_tbl.COUNT > 0) THEN
759: i := p_potv_tbl.FIRST;
760: LOOP

Line 762: l_error_rec OKC_API.ERROR_REC_TYPE;

758: IF (p_potv_tbl.COUNT > 0) THEN
759: i := p_potv_tbl.FIRST;
760: LOOP
761: DECLARE
762: l_error_rec OKC_API.ERROR_REC_TYPE;
763: BEGIN
764: l_error_rec.api_name := l_api_name;
765: l_error_rec.api_package := G_PKG_NAME;
766: l_error_rec.idx := i;

Line 769: p_init_msg_list => OKC_API.G_FALSE,

765: l_error_rec.api_package := G_PKG_NAME;
766: l_error_rec.idx := i;
767: validate_row (
768: p_api_version => p_api_version,
769: p_init_msg_list => OKC_API.G_FALSE,
770: x_return_status => l_error_rec.error_type,
771: x_msg_count => l_error_rec.msg_count,
772: x_msg_data => l_error_rec.msg_data,
773: p_potv_rec => p_potv_tbl(i));

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

770: x_return_status => l_error_rec.error_type,
771: x_msg_count => l_error_rec.msg_count,
772: x_msg_data => l_error_rec.msg_data,
773: p_potv_rec => p_potv_tbl(i));
774: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
775: l_error_rec.SQLCODE := SQLCODE;
776: load_error_tbl(l_error_rec, px_error_tbl);
777: ELSE
778: x_msg_count := l_error_rec.msg_count;

Line 782: WHEN OKC_API.G_EXCEPTION_ERROR THEN

778: x_msg_count := l_error_rec.msg_count;
779: x_msg_data := l_error_rec.msg_data;
780: END IF;
781: EXCEPTION
782: WHEN OKC_API.G_EXCEPTION_ERROR THEN
783: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
784: l_error_rec.SQLCODE := SQLCODE;
785: load_error_tbl(l_error_rec, px_error_tbl);
786: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

779: x_msg_data := l_error_rec.msg_data;
780: END IF;
781: EXCEPTION
782: WHEN OKC_API.G_EXCEPTION_ERROR THEN
783: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
784: l_error_rec.SQLCODE := SQLCODE;
785: load_error_tbl(l_error_rec, px_error_tbl);
786: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
787: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 786: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

782: WHEN OKC_API.G_EXCEPTION_ERROR THEN
783: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
784: l_error_rec.SQLCODE := SQLCODE;
785: load_error_tbl(l_error_rec, px_error_tbl);
786: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
787: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
788: l_error_rec.SQLCODE := SQLCODE;
789: load_error_tbl(l_error_rec, px_error_tbl);
790: WHEN OTHERS THEN

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

783: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
784: l_error_rec.SQLCODE := SQLCODE;
785: load_error_tbl(l_error_rec, px_error_tbl);
786: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
787: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
788: l_error_rec.SQLCODE := SQLCODE;
789: load_error_tbl(l_error_rec, px_error_tbl);
790: WHEN OTHERS THEN
791: l_error_rec.error_type := 'OTHERS';

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

798: END IF;
799: -- Loop through the error_tbl to find the error with the highest severity
800: -- and return it.
801: x_return_status := find_highest_exception(px_error_tbl);
802: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
803: EXCEPTION
804: WHEN OKC_API.G_EXCEPTION_ERROR THEN
805: x_return_status := OKC_API.HANDLE_EXCEPTIONS
806: (

Line 804: WHEN OKC_API.G_EXCEPTION_ERROR THEN

800: -- and return it.
801: x_return_status := find_highest_exception(px_error_tbl);
802: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
803: EXCEPTION
804: WHEN OKC_API.G_EXCEPTION_ERROR THEN
805: x_return_status := OKC_API.HANDLE_EXCEPTIONS
806: (
807: l_api_name,
808: G_PKG_NAME,

Line 805: x_return_status := OKC_API.HANDLE_EXCEPTIONS

801: x_return_status := find_highest_exception(px_error_tbl);
802: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
803: EXCEPTION
804: WHEN OKC_API.G_EXCEPTION_ERROR THEN
805: x_return_status := OKC_API.HANDLE_EXCEPTIONS
806: (
807: l_api_name,
808: G_PKG_NAME,
809: 'OKC_API.G_RET_STS_ERROR',

Line 809: 'OKC_API.G_RET_STS_ERROR',

805: x_return_status := OKC_API.HANDLE_EXCEPTIONS
806: (
807: l_api_name,
808: G_PKG_NAME,
809: 'OKC_API.G_RET_STS_ERROR',
810: x_msg_count,
811: x_msg_data,
812: '_PVT'
813: );

Line 814: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

810: x_msg_count,
811: x_msg_data,
812: '_PVT'
813: );
814: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
815: x_return_status := OKC_API.HANDLE_EXCEPTIONS
816: (
817: l_api_name,
818: G_PKG_NAME,

Line 815: x_return_status := OKC_API.HANDLE_EXCEPTIONS

811: x_msg_data,
812: '_PVT'
813: );
814: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
815: x_return_status := OKC_API.HANDLE_EXCEPTIONS
816: (
817: l_api_name,
818: G_PKG_NAME,
819: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 819: 'OKC_API.G_RET_STS_UNEXP_ERROR',

815: x_return_status := OKC_API.HANDLE_EXCEPTIONS
816: (
817: l_api_name,
818: G_PKG_NAME,
819: 'OKC_API.G_RET_STS_UNEXP_ERROR',
820: x_msg_count,
821: x_msg_data,
822: '_PVT'
823: );

Line 825: x_return_status := OKC_API.HANDLE_EXCEPTIONS

821: x_msg_data,
822: '_PVT'
823: );
824: WHEN OTHERS THEN
825: x_return_status := OKC_API.HANDLE_EXCEPTIONS
826: (
827: l_api_name,
828: G_PKG_NAME,
829: 'OTHERS',

Line 841: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

837: -- PL/SQL TBL validate_row for:OKL_POOL_TYPES_V --
838: -------------------------------------------------------
839: PROCEDURE validate_row(
840: p_api_version IN NUMBER,
841: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
842: x_return_status OUT NOCOPY VARCHAR2,
843: x_msg_count OUT NOCOPY NUMBER,
844: x_msg_data OUT NOCOPY VARCHAR2,
845: p_potv_tbl IN potv_tbl_type) IS

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

845: p_potv_tbl IN potv_tbl_type) IS
846:
847: l_api_version CONSTANT NUMBER := 1;
848: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
849: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
850: l_error_tbl OKC_API.ERROR_TBL_TYPE;
851: BEGIN
852: OKC_API.init_msg_list(p_init_msg_list);
853: -- Make sure PL/SQL table has records in it before passing

Line 850: l_error_tbl OKC_API.ERROR_TBL_TYPE;

846:
847: l_api_version CONSTANT NUMBER := 1;
848: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
849: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
850: l_error_tbl OKC_API.ERROR_TBL_TYPE;
851: BEGIN
852: OKC_API.init_msg_list(p_init_msg_list);
853: -- Make sure PL/SQL table has records in it before passing
854: IF (p_potv_tbl.COUNT > 0) THEN

Line 852: OKC_API.init_msg_list(p_init_msg_list);

848: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
849: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
850: l_error_tbl OKC_API.ERROR_TBL_TYPE;
851: BEGIN
852: OKC_API.init_msg_list(p_init_msg_list);
853: -- Make sure PL/SQL table has records in it before passing
854: IF (p_potv_tbl.COUNT > 0) THEN
855: validate_row (
856: p_api_version => p_api_version,

Line 857: p_init_msg_list => OKC_API.G_FALSE,

853: -- Make sure PL/SQL table has records in it before passing
854: IF (p_potv_tbl.COUNT > 0) THEN
855: validate_row (
856: p_api_version => p_api_version,
857: p_init_msg_list => OKC_API.G_FALSE,
858: x_return_status => x_return_status,
859: x_msg_count => x_msg_count,
860: x_msg_data => x_msg_data,
861: p_potv_tbl => p_potv_tbl,

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

860: x_msg_data => x_msg_data,
861: p_potv_tbl => p_potv_tbl,
862: px_error_tbl => l_error_tbl);
863: END IF;
864: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
865: EXCEPTION
866: WHEN OKC_API.G_EXCEPTION_ERROR THEN
867: x_return_status := OKC_API.HANDLE_EXCEPTIONS
868: (

Line 866: WHEN OKC_API.G_EXCEPTION_ERROR THEN

862: px_error_tbl => l_error_tbl);
863: END IF;
864: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
865: EXCEPTION
866: WHEN OKC_API.G_EXCEPTION_ERROR THEN
867: x_return_status := OKC_API.HANDLE_EXCEPTIONS
868: (
869: l_api_name,
870: G_PKG_NAME,

Line 867: x_return_status := OKC_API.HANDLE_EXCEPTIONS

863: END IF;
864: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
865: EXCEPTION
866: WHEN OKC_API.G_EXCEPTION_ERROR THEN
867: x_return_status := OKC_API.HANDLE_EXCEPTIONS
868: (
869: l_api_name,
870: G_PKG_NAME,
871: 'OKC_API.G_RET_STS_ERROR',

Line 871: 'OKC_API.G_RET_STS_ERROR',

867: x_return_status := OKC_API.HANDLE_EXCEPTIONS
868: (
869: l_api_name,
870: G_PKG_NAME,
871: 'OKC_API.G_RET_STS_ERROR',
872: x_msg_count,
873: x_msg_data,
874: '_PVT'
875: );

Line 876: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

872: x_msg_count,
873: x_msg_data,
874: '_PVT'
875: );
876: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
877: x_return_status := OKC_API.HANDLE_EXCEPTIONS
878: (
879: l_api_name,
880: G_PKG_NAME,

Line 877: x_return_status := OKC_API.HANDLE_EXCEPTIONS

873: x_msg_data,
874: '_PVT'
875: );
876: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
877: x_return_status := OKC_API.HANDLE_EXCEPTIONS
878: (
879: l_api_name,
880: G_PKG_NAME,
881: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 881: 'OKC_API.G_RET_STS_UNEXP_ERROR',

877: x_return_status := OKC_API.HANDLE_EXCEPTIONS
878: (
879: l_api_name,
880: G_PKG_NAME,
881: 'OKC_API.G_RET_STS_UNEXP_ERROR',
882: x_msg_count,
883: x_msg_data,
884: '_PVT'
885: );

Line 887: x_return_status := OKC_API.HANDLE_EXCEPTIONS

883: x_msg_data,
884: '_PVT'
885: );
886: WHEN OTHERS THEN
887: x_return_status := OKC_API.HANDLE_EXCEPTIONS
888: (
889: l_api_name,
890: G_PKG_NAME,
891: 'OTHERS',

Line 905: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

901: ----------------------------------------
902: -- insert_row for:okl_pool_types --
903: ----------------------------------------
904: PROCEDURE insert_row(
905: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
906: x_return_status OUT NOCOPY VARCHAR2,
907: x_msg_count OUT NOCOPY NUMBER,
908: x_msg_data OUT NOCOPY VARCHAR2,
909: p_pot_rec IN pot_rec_type,

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

910: x_pot_rec OUT NOCOPY pot_rec_type) IS
911:
912: l_api_version CONSTANT NUMBER := 1;
913: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
914: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
915: l_pot_rec pot_rec_type := p_pot_rec;
916: l_def_pot_rec pot_rec_type;
917: --------------------------------------------
918: -- Set_Attributes for:okl_pool_types --

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

920: FUNCTION Set_Attributes (
921: p_pot_rec IN pot_rec_type,
922: x_pot_rec OUT NOCOPY pot_rec_type
923: ) RETURN VARCHAR2 IS
924: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
925: BEGIN
926: x_pot_rec := p_pot_rec;
927: RETURN(l_return_status);
928: END Set_Attributes;

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

926: x_pot_rec := p_pot_rec;
927: RETURN(l_return_status);
928: END Set_Attributes;
929: BEGIN
930: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
931: p_init_msg_list,
932: '_PVT',
933: x_return_status);
934: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

930: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
931: p_init_msg_list,
932: '_PVT',
933: x_return_status);
934: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
935: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
937: RAISE OKC_API.G_EXCEPTION_ERROR;
938: END IF;

Line 935: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

931: p_init_msg_list,
932: '_PVT',
933: x_return_status);
934: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
935: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
937: RAISE OKC_API.G_EXCEPTION_ERROR;
938: END IF;
939: --- Setting item atributes

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

932: '_PVT',
933: x_return_status);
934: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
935: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
937: RAISE OKC_API.G_EXCEPTION_ERROR;
938: END IF;
939: --- Setting item atributes
940: l_return_status := Set_Attributes(

Line 937: RAISE OKC_API.G_EXCEPTION_ERROR;

933: x_return_status);
934: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
935: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
937: RAISE OKC_API.G_EXCEPTION_ERROR;
938: END IF;
939: --- Setting item atributes
940: l_return_status := Set_Attributes(
941: p_pot_rec, -- IN

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

940: l_return_status := Set_Attributes(
941: p_pot_rec, -- IN
942: l_pot_rec); -- OUT
943: --- If any errors happen abort API
944: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
945: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
946: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
947: RAISE OKC_API.G_EXCEPTION_ERROR;
948: END IF;

Line 945: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

941: p_pot_rec, -- IN
942: l_pot_rec); -- OUT
943: --- If any errors happen abort API
944: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
945: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
946: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
947: RAISE OKC_API.G_EXCEPTION_ERROR;
948: END IF;
949: INSERT INTO okl_pool_types(

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

942: l_pot_rec); -- OUT
943: --- If any errors happen abort API
944: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
945: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
946: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
947: RAISE OKC_API.G_EXCEPTION_ERROR;
948: END IF;
949: INSERT INTO okl_pool_types(
950: ID,

Line 947: RAISE OKC_API.G_EXCEPTION_ERROR;

943: --- If any errors happen abort API
944: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
945: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
946: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
947: RAISE OKC_API.G_EXCEPTION_ERROR;
948: END IF;
949: INSERT INTO okl_pool_types(
950: ID,
951: OBJECT_VERSION_NUMBER,

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

1006: l_pot_rec.last_update_login);
1007: -- Set OUT values
1008: x_pot_rec := l_pot_rec;
1009: x_return_status := l_return_status;
1010: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1011: EXCEPTION
1012: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1013: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1014: (

Line 1012: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1008: x_pot_rec := l_pot_rec;
1009: x_return_status := l_return_status;
1010: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1011: EXCEPTION
1012: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1013: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1014: (
1015: l_api_name,
1016: G_PKG_NAME,

Line 1013: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1009: x_return_status := l_return_status;
1010: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1011: EXCEPTION
1012: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1013: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1014: (
1015: l_api_name,
1016: G_PKG_NAME,
1017: 'OKC_API.G_RET_STS_ERROR',

Line 1017: 'OKC_API.G_RET_STS_ERROR',

1013: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1014: (
1015: l_api_name,
1016: G_PKG_NAME,
1017: 'OKC_API.G_RET_STS_ERROR',
1018: x_msg_count,
1019: x_msg_data,
1020: '_PVT'
1021: );

Line 1022: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1018: x_msg_count,
1019: x_msg_data,
1020: '_PVT'
1021: );
1022: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1023: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1024: (
1025: l_api_name,
1026: G_PKG_NAME,

Line 1023: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1019: x_msg_data,
1020: '_PVT'
1021: );
1022: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1023: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1024: (
1025: l_api_name,
1026: G_PKG_NAME,
1027: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1027: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1023: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1024: (
1025: l_api_name,
1026: G_PKG_NAME,
1027: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1028: x_msg_count,
1029: x_msg_data,
1030: '_PVT'
1031: );

Line 1033: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1029: x_msg_data,
1030: '_PVT'
1031: );
1032: WHEN OTHERS THEN
1033: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1034: (
1035: l_api_name,
1036: G_PKG_NAME,
1037: 'OTHERS',

Line 1048: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1044: -- insert_row for :OKL_POOL_TYPES_V --
1045: -------------------------------------------
1046: PROCEDURE insert_row(
1047: p_api_version IN NUMBER,
1048: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1049: x_return_status OUT NOCOPY VARCHAR2,
1050: x_msg_count OUT NOCOPY NUMBER,
1051: x_msg_data OUT NOCOPY VARCHAR2,
1052: p_potv_rec IN potv_rec_type,

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

1053: x_potv_rec OUT NOCOPY potv_rec_type) IS
1054:
1055: l_api_version CONSTANT NUMBER := 1;
1056: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1057: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1058: l_potv_rec potv_rec_type := p_potv_rec;
1059: l_def_potv_rec potv_rec_type;
1060: l_pot_rec pot_rec_type;
1061: lx_pot_rec pot_rec_type;

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

1080: FUNCTION Set_Attributes (
1081: p_potv_rec IN potv_rec_type,
1082: x_potv_rec OUT NOCOPY potv_rec_type
1083: ) RETURN VARCHAR2 IS
1084: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1085: BEGIN
1086: x_potv_rec := p_potv_rec;
1087: x_potv_rec.OBJECT_VERSION_NUMBER := 1;
1088: RETURN(l_return_status);

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

1087: x_potv_rec.OBJECT_VERSION_NUMBER := 1;
1088: RETURN(l_return_status);
1089: END Set_Attributes;
1090: BEGIN
1091: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1092: G_PKG_NAME,
1093: p_init_msg_list,
1094: l_api_version,
1095: p_api_version,

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

1094: l_api_version,
1095: p_api_version,
1096: '_PVT',
1097: x_return_status);
1098: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1100: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1101: RAISE OKC_API.G_EXCEPTION_ERROR;
1102: END IF;

Line 1099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1095: p_api_version,
1096: '_PVT',
1097: x_return_status);
1098: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1100: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1101: RAISE OKC_API.G_EXCEPTION_ERROR;
1102: END IF;
1103: l_potv_rec := null_out_defaults(p_potv_rec);

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

1096: '_PVT',
1097: x_return_status);
1098: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1100: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1101: RAISE OKC_API.G_EXCEPTION_ERROR;
1102: END IF;
1103: l_potv_rec := null_out_defaults(p_potv_rec);
1104: -- Set primary key value

Line 1101: RAISE OKC_API.G_EXCEPTION_ERROR;

1097: x_return_status);
1098: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1099: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1100: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1101: RAISE OKC_API.G_EXCEPTION_ERROR;
1102: END IF;
1103: l_potv_rec := null_out_defaults(p_potv_rec);
1104: -- Set primary key value
1105: l_potv_rec.ID := get_seq_id;

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

1107: l_return_Status := Set_Attributes(
1108: l_potv_rec, -- IN
1109: l_def_potv_rec); -- OUT
1110: --- If any errors happen abort API
1111: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1113: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1114: RAISE OKC_API.G_EXCEPTION_ERROR;
1115: END IF;

Line 1112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1108: l_potv_rec, -- IN
1109: l_def_potv_rec); -- OUT
1110: --- If any errors happen abort API
1111: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1113: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1114: RAISE OKC_API.G_EXCEPTION_ERROR;
1115: END IF;
1116: l_def_potv_rec := fill_who_columns(l_def_potv_rec);

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

1109: l_def_potv_rec); -- OUT
1110: --- If any errors happen abort API
1111: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1113: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1114: RAISE OKC_API.G_EXCEPTION_ERROR;
1115: END IF;
1116: l_def_potv_rec := fill_who_columns(l_def_potv_rec);
1117: --- Validate all non-missing attributes (Item Level Validation)

Line 1114: RAISE OKC_API.G_EXCEPTION_ERROR;

1110: --- If any errors happen abort API
1111: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1113: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1114: RAISE OKC_API.G_EXCEPTION_ERROR;
1115: END IF;
1116: l_def_potv_rec := fill_who_columns(l_def_potv_rec);
1117: --- Validate all non-missing attributes (Item Level Validation)
1118: l_return_status := Validate_Attributes(l_def_potv_rec);

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

1116: l_def_potv_rec := fill_who_columns(l_def_potv_rec);
1117: --- Validate all non-missing attributes (Item Level Validation)
1118: l_return_status := Validate_Attributes(l_def_potv_rec);
1119: --- If any errors happen abort API
1120: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1122: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1123: RAISE OKC_API.G_EXCEPTION_ERROR;
1124: END IF;

Line 1121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1117: --- Validate all non-missing attributes (Item Level Validation)
1118: l_return_status := Validate_Attributes(l_def_potv_rec);
1119: --- If any errors happen abort API
1120: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1122: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1123: RAISE OKC_API.G_EXCEPTION_ERROR;
1124: END IF;
1125: l_return_status := Validate_Record(l_def_potv_rec);

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

1118: l_return_status := Validate_Attributes(l_def_potv_rec);
1119: --- If any errors happen abort API
1120: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1122: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1123: RAISE OKC_API.G_EXCEPTION_ERROR;
1124: END IF;
1125: l_return_status := Validate_Record(l_def_potv_rec);
1126: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1123: RAISE OKC_API.G_EXCEPTION_ERROR;

1119: --- If any errors happen abort API
1120: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1122: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1123: RAISE OKC_API.G_EXCEPTION_ERROR;
1124: END IF;
1125: l_return_status := Validate_Record(l_def_potv_rec);
1126: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1122: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1123: RAISE OKC_API.G_EXCEPTION_ERROR;
1124: END IF;
1125: l_return_status := Validate_Record(l_def_potv_rec);
1126: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1128: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1129: RAISE OKC_API.G_EXCEPTION_ERROR;
1130: END IF;

Line 1127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1123: RAISE OKC_API.G_EXCEPTION_ERROR;
1124: END IF;
1125: l_return_status := Validate_Record(l_def_potv_rec);
1126: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1128: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1129: RAISE OKC_API.G_EXCEPTION_ERROR;
1130: END IF;
1131: -----------------------------------------

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

1124: END IF;
1125: l_return_status := Validate_Record(l_def_potv_rec);
1126: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1128: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1129: RAISE OKC_API.G_EXCEPTION_ERROR;
1130: END IF;
1131: -----------------------------------------
1132: -- Move VIEW record to "Child" records --

Line 1129: RAISE OKC_API.G_EXCEPTION_ERROR;

1125: l_return_status := Validate_Record(l_def_potv_rec);
1126: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1128: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1129: RAISE OKC_API.G_EXCEPTION_ERROR;
1130: END IF;
1131: -----------------------------------------
1132: -- Move VIEW record to "Child" records --
1133: -----------------------------------------

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

1142: x_msg_data,
1143: l_pot_rec,
1144: lx_pot_rec
1145: );
1146: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1147: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1148: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1149: RAISE OKC_API.G_EXCEPTION_ERROR;
1150: END IF;

Line 1147: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1143: l_pot_rec,
1144: lx_pot_rec
1145: );
1146: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1147: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1148: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1149: RAISE OKC_API.G_EXCEPTION_ERROR;
1150: END IF;
1151: migrate(lx_pot_rec, l_def_potv_rec);

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

1144: lx_pot_rec
1145: );
1146: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1147: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1148: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1149: RAISE OKC_API.G_EXCEPTION_ERROR;
1150: END IF;
1151: migrate(lx_pot_rec, l_def_potv_rec);
1152: -- Set OUT values

Line 1149: RAISE OKC_API.G_EXCEPTION_ERROR;

1145: );
1146: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1147: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1148: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1149: RAISE OKC_API.G_EXCEPTION_ERROR;
1150: END IF;
1151: migrate(lx_pot_rec, l_def_potv_rec);
1152: -- Set OUT values
1153: x_potv_rec := l_def_potv_rec;

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

1151: migrate(lx_pot_rec, l_def_potv_rec);
1152: -- Set OUT values
1153: x_potv_rec := l_def_potv_rec;
1154: x_return_status := l_return_status;
1155: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1156: EXCEPTION
1157: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1159: (

Line 1157: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1153: x_potv_rec := l_def_potv_rec;
1154: x_return_status := l_return_status;
1155: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1156: EXCEPTION
1157: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1159: (
1160: l_api_name,
1161: G_PKG_NAME,

Line 1158: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1154: x_return_status := l_return_status;
1155: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1156: EXCEPTION
1157: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1159: (
1160: l_api_name,
1161: G_PKG_NAME,
1162: 'OKC_API.G_RET_STS_ERROR',

Line 1162: 'OKC_API.G_RET_STS_ERROR',

1158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1159: (
1160: l_api_name,
1161: G_PKG_NAME,
1162: 'OKC_API.G_RET_STS_ERROR',
1163: x_msg_count,
1164: x_msg_data,
1165: '_PVT'
1166: );

Line 1167: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1163: x_msg_count,
1164: x_msg_data,
1165: '_PVT'
1166: );
1167: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1168: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1169: (
1170: l_api_name,
1171: G_PKG_NAME,

Line 1168: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1164: x_msg_data,
1165: '_PVT'
1166: );
1167: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1168: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1169: (
1170: l_api_name,
1171: G_PKG_NAME,
1172: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1172: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1168: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1169: (
1170: l_api_name,
1171: G_PKG_NAME,
1172: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1173: x_msg_count,
1174: x_msg_data,
1175: '_PVT'
1176: );

Line 1178: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1174: x_msg_data,
1175: '_PVT'
1176: );
1177: WHEN OTHERS THEN
1178: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1179: (
1180: l_api_name,
1181: G_PKG_NAME,
1182: 'OTHERS',

Line 1193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1189: -- PL/SQL TBL insert_row for:potv_TBL --
1190: ----------------------------------------
1191: PROCEDURE insert_row(
1192: p_api_version IN NUMBER,
1193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1194: x_return_status OUT NOCOPY VARCHAR2,
1195: x_msg_count OUT NOCOPY NUMBER,
1196: x_msg_data OUT NOCOPY VARCHAR2,
1197: p_potv_tbl IN potv_tbl_type,

Line 1199: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

1195: x_msg_count OUT NOCOPY NUMBER,
1196: x_msg_data OUT NOCOPY VARCHAR2,
1197: p_potv_tbl IN potv_tbl_type,
1198: x_potv_tbl OUT NOCOPY potv_tbl_type,
1199: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1200:
1201: l_api_version CONSTANT NUMBER := 1;
1202: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1203: i NUMBER := 0;

Line 1205: OKC_API.init_msg_list(p_init_msg_list);

1201: l_api_version CONSTANT NUMBER := 1;
1202: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1203: i NUMBER := 0;
1204: BEGIN
1205: OKC_API.init_msg_list(p_init_msg_list);
1206: -- Make sure PL/SQL table has records in it before passing
1207: IF (p_potv_tbl.COUNT > 0) THEN
1208: i := p_potv_tbl.FIRST;
1209: LOOP

Line 1211: l_error_rec OKC_API.ERROR_REC_TYPE;

1207: IF (p_potv_tbl.COUNT > 0) THEN
1208: i := p_potv_tbl.FIRST;
1209: LOOP
1210: DECLARE
1211: l_error_rec OKC_API.ERROR_REC_TYPE;
1212: BEGIN
1213: l_error_rec.api_name := l_api_name;
1214: l_error_rec.api_package := G_PKG_NAME;
1215: l_error_rec.idx := i;

Line 1218: p_init_msg_list => OKC_API.G_FALSE,

1214: l_error_rec.api_package := G_PKG_NAME;
1215: l_error_rec.idx := i;
1216: insert_row (
1217: p_api_version => p_api_version,
1218: p_init_msg_list => OKC_API.G_FALSE,
1219: x_return_status => l_error_rec.error_type,
1220: x_msg_count => l_error_rec.msg_count,
1221: x_msg_data => l_error_rec.msg_data,
1222: p_potv_rec => p_potv_tbl(i),

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

1220: x_msg_count => l_error_rec.msg_count,
1221: x_msg_data => l_error_rec.msg_data,
1222: p_potv_rec => p_potv_tbl(i),
1223: x_potv_rec => x_potv_tbl(i));
1224: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1225: l_error_rec.SQLCODE := SQLCODE;
1226: load_error_tbl(l_error_rec, px_error_tbl);
1227: ELSE
1228: x_msg_count := l_error_rec.msg_count;

Line 1232: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1228: x_msg_count := l_error_rec.msg_count;
1229: x_msg_data := l_error_rec.msg_data;
1230: END IF;
1231: EXCEPTION
1232: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1233: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1234: l_error_rec.SQLCODE := SQLCODE;
1235: load_error_tbl(l_error_rec, px_error_tbl);
1236: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

1229: x_msg_data := l_error_rec.msg_data;
1230: END IF;
1231: EXCEPTION
1232: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1233: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1234: l_error_rec.SQLCODE := SQLCODE;
1235: load_error_tbl(l_error_rec, px_error_tbl);
1236: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1237: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 1236: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1232: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1233: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1234: l_error_rec.SQLCODE := SQLCODE;
1235: load_error_tbl(l_error_rec, px_error_tbl);
1236: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1237: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1238: l_error_rec.SQLCODE := SQLCODE;
1239: load_error_tbl(l_error_rec, px_error_tbl);
1240: WHEN OTHERS THEN

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

1233: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1234: l_error_rec.SQLCODE := SQLCODE;
1235: load_error_tbl(l_error_rec, px_error_tbl);
1236: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1237: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1238: l_error_rec.SQLCODE := SQLCODE;
1239: load_error_tbl(l_error_rec, px_error_tbl);
1240: WHEN OTHERS THEN
1241: l_error_rec.error_type := 'OTHERS';

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

1248: END IF;
1249: -- Loop through the error_tbl to find the error with the highest severity
1250: -- and return it.
1251: x_return_status := find_highest_exception(px_error_tbl);
1252: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1253: EXCEPTION
1254: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1255: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1256: (

Line 1254: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1250: -- and return it.
1251: x_return_status := find_highest_exception(px_error_tbl);
1252: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1253: EXCEPTION
1254: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1255: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1256: (
1257: l_api_name,
1258: G_PKG_NAME,

Line 1255: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1251: x_return_status := find_highest_exception(px_error_tbl);
1252: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1253: EXCEPTION
1254: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1255: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1256: (
1257: l_api_name,
1258: G_PKG_NAME,
1259: 'OKC_API.G_RET_STS_ERROR',

Line 1259: 'OKC_API.G_RET_STS_ERROR',

1255: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1256: (
1257: l_api_name,
1258: G_PKG_NAME,
1259: 'OKC_API.G_RET_STS_ERROR',
1260: x_msg_count,
1261: x_msg_data,
1262: '_PVT'
1263: );

Line 1264: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1260: x_msg_count,
1261: x_msg_data,
1262: '_PVT'
1263: );
1264: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1265: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1266: (
1267: l_api_name,
1268: G_PKG_NAME,

Line 1265: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1261: x_msg_data,
1262: '_PVT'
1263: );
1264: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1265: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1266: (
1267: l_api_name,
1268: G_PKG_NAME,
1269: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1269: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1265: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1266: (
1267: l_api_name,
1268: G_PKG_NAME,
1269: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1270: x_msg_count,
1271: x_msg_data,
1272: '_PVT'
1273: );

Line 1275: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1271: x_msg_data,
1272: '_PVT'
1273: );
1274: WHEN OTHERS THEN
1275: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1276: (
1277: l_api_name,
1278: G_PKG_NAME,
1279: 'OTHERS',

Line 1291: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1287: -- PL/SQL TBL insert_row for:potv_TBL --
1288: ----------------------------------------
1289: PROCEDURE insert_row(
1290: p_api_version IN NUMBER,
1291: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1292: x_return_status OUT NOCOPY VARCHAR2,
1293: x_msg_count OUT NOCOPY NUMBER,
1294: x_msg_data OUT NOCOPY VARCHAR2,
1295: p_potv_tbl IN potv_tbl_type,

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

1296: x_potv_tbl OUT NOCOPY potv_tbl_type) IS
1297:
1298: l_api_version CONSTANT NUMBER := 1;
1299: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1300: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1301: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1302: BEGIN
1303: OKC_API.init_msg_list(p_init_msg_list);
1304: -- Make sure PL/SQL table has records in it before passing

Line 1301: l_error_tbl OKC_API.ERROR_TBL_TYPE;

1297:
1298: l_api_version CONSTANT NUMBER := 1;
1299: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1300: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1301: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1302: BEGIN
1303: OKC_API.init_msg_list(p_init_msg_list);
1304: -- Make sure PL/SQL table has records in it before passing
1305: IF (p_potv_tbl.COUNT > 0) THEN

Line 1303: OKC_API.init_msg_list(p_init_msg_list);

1299: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1300: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1301: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1302: BEGIN
1303: OKC_API.init_msg_list(p_init_msg_list);
1304: -- Make sure PL/SQL table has records in it before passing
1305: IF (p_potv_tbl.COUNT > 0) THEN
1306: insert_row (
1307: p_api_version => p_api_version,

Line 1308: p_init_msg_list => OKC_API.G_FALSE,

1304: -- Make sure PL/SQL table has records in it before passing
1305: IF (p_potv_tbl.COUNT > 0) THEN
1306: insert_row (
1307: p_api_version => p_api_version,
1308: p_init_msg_list => OKC_API.G_FALSE,
1309: x_return_status => x_return_status,
1310: x_msg_count => x_msg_count,
1311: x_msg_data => x_msg_data,
1312: p_potv_tbl => p_potv_tbl,

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

1312: p_potv_tbl => p_potv_tbl,
1313: x_potv_tbl => x_potv_tbl,
1314: px_error_tbl => l_error_tbl);
1315: END IF;
1316: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1317: EXCEPTION
1318: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1319: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1320: (

Line 1318: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1314: px_error_tbl => l_error_tbl);
1315: END IF;
1316: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1317: EXCEPTION
1318: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1319: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1320: (
1321: l_api_name,
1322: G_PKG_NAME,

Line 1319: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1315: END IF;
1316: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1317: EXCEPTION
1318: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1319: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1320: (
1321: l_api_name,
1322: G_PKG_NAME,
1323: 'OKC_API.G_RET_STS_ERROR',

Line 1323: 'OKC_API.G_RET_STS_ERROR',

1319: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1320: (
1321: l_api_name,
1322: G_PKG_NAME,
1323: 'OKC_API.G_RET_STS_ERROR',
1324: x_msg_count,
1325: x_msg_data,
1326: '_PVT'
1327: );

Line 1328: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1324: x_msg_count,
1325: x_msg_data,
1326: '_PVT'
1327: );
1328: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1329: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1330: (
1331: l_api_name,
1332: G_PKG_NAME,

Line 1329: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1325: x_msg_data,
1326: '_PVT'
1327: );
1328: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1329: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1330: (
1331: l_api_name,
1332: G_PKG_NAME,
1333: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1333: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1329: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1330: (
1331: l_api_name,
1332: G_PKG_NAME,
1333: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1334: x_msg_count,
1335: x_msg_data,
1336: '_PVT'
1337: );

Line 1339: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1335: x_msg_data,
1336: '_PVT'
1337: );
1338: WHEN OTHERS THEN
1339: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1340: (
1341: l_api_name,
1342: G_PKG_NAME,
1343: 'OTHERS',

Line 1357: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1353: --------------------------------------
1354: -- lock_row for:okl_pool_types --
1355: --------------------------------------
1356: PROCEDURE lock_row(
1357: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1358: x_return_status OUT NOCOPY VARCHAR2,
1359: x_msg_count OUT NOCOPY NUMBER,
1360: x_msg_data OUT NOCOPY VARCHAR2,
1361: p_pot_rec IN pot_rec_type) IS

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

1374: FROM okl_pool_types
1375: WHERE ID = p_pot_rec.id;
1376: l_api_version CONSTANT NUMBER := 1;
1377: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1378: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1379: l_object_version_number okl_pool_types.OBJECT_VERSION_NUMBER%TYPE;
1380: lc_object_version_number okl_pool_types.OBJECT_VERSION_NUMBER%TYPE;
1381: l_row_notfound BOOLEAN := FALSE;
1382: lc_row_notfound BOOLEAN := FALSE;

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

1380: lc_object_version_number okl_pool_types.OBJECT_VERSION_NUMBER%TYPE;
1381: l_row_notfound BOOLEAN := FALSE;
1382: lc_row_notfound BOOLEAN := FALSE;
1383: BEGIN
1384: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1385: p_init_msg_list,
1386: '_PVT',
1387: x_return_status);
1388: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1384: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1385: p_init_msg_list,
1386: '_PVT',
1387: x_return_status);
1388: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1389: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1390: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1391: RAISE OKC_API.G_EXCEPTION_ERROR;
1392: END IF;

Line 1389: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1385: p_init_msg_list,
1386: '_PVT',
1387: x_return_status);
1388: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1389: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1390: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1391: RAISE OKC_API.G_EXCEPTION_ERROR;
1392: END IF;
1393: BEGIN

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

1386: '_PVT',
1387: x_return_status);
1388: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1389: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1390: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1391: RAISE OKC_API.G_EXCEPTION_ERROR;
1392: END IF;
1393: BEGIN
1394: OPEN lock_csr(p_pot_rec);

Line 1391: RAISE OKC_API.G_EXCEPTION_ERROR;

1387: x_return_status);
1388: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1389: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1390: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1391: RAISE OKC_API.G_EXCEPTION_ERROR;
1392: END IF;
1393: BEGIN
1394: OPEN lock_csr(p_pot_rec);
1395: FETCH lock_csr INTO l_object_version_number;

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

1399: WHEN E_Resource_Busy THEN
1400: IF (lock_csr%ISOPEN) THEN
1401: CLOSE lock_csr;
1402: END IF;
1403: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1404: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1405: END;
1406:
1407: IF ( l_row_notfound ) THEN

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

1410: lc_row_notfound := lchk_csr%NOTFOUND;
1411: CLOSE lchk_csr;
1412: END IF;
1413: IF (lc_row_notfound) THEN
1414: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1415: RAISE OKC_API.G_EXCEPTION_ERROR;
1416: ELSIF lc_object_version_number > p_pot_rec.object_version_number THEN
1417: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1418: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1415: RAISE OKC_API.G_EXCEPTION_ERROR;

1411: CLOSE lchk_csr;
1412: END IF;
1413: IF (lc_row_notfound) THEN
1414: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1415: RAISE OKC_API.G_EXCEPTION_ERROR;
1416: ELSIF lc_object_version_number > p_pot_rec.object_version_number THEN
1417: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1418: RAISE OKC_API.G_EXCEPTION_ERROR;
1419: ELSIF lc_object_version_number <> p_pot_rec.object_version_number THEN

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

1413: IF (lc_row_notfound) THEN
1414: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1415: RAISE OKC_API.G_EXCEPTION_ERROR;
1416: ELSIF lc_object_version_number > p_pot_rec.object_version_number THEN
1417: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1418: RAISE OKC_API.G_EXCEPTION_ERROR;
1419: ELSIF lc_object_version_number <> p_pot_rec.object_version_number THEN
1420: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1421: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1418: RAISE OKC_API.G_EXCEPTION_ERROR;

1414: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1415: RAISE OKC_API.G_EXCEPTION_ERROR;
1416: ELSIF lc_object_version_number > p_pot_rec.object_version_number THEN
1417: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1418: RAISE OKC_API.G_EXCEPTION_ERROR;
1419: ELSIF lc_object_version_number <> p_pot_rec.object_version_number THEN
1420: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1421: RAISE OKC_API.G_EXCEPTION_ERROR;
1422: ELSIF lc_object_version_number = -1 THEN

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

1416: ELSIF lc_object_version_number > p_pot_rec.object_version_number THEN
1417: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1418: RAISE OKC_API.G_EXCEPTION_ERROR;
1419: ELSIF lc_object_version_number <> p_pot_rec.object_version_number THEN
1420: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1421: RAISE OKC_API.G_EXCEPTION_ERROR;
1422: ELSIF lc_object_version_number = -1 THEN
1423: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1424: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1421: RAISE OKC_API.G_EXCEPTION_ERROR;

1417: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1418: RAISE OKC_API.G_EXCEPTION_ERROR;
1419: ELSIF lc_object_version_number <> p_pot_rec.object_version_number THEN
1420: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1421: RAISE OKC_API.G_EXCEPTION_ERROR;
1422: ELSIF lc_object_version_number = -1 THEN
1423: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1424: RAISE OKC_API.G_EXCEPTION_ERROR;
1425: END IF;

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

1419: ELSIF lc_object_version_number <> p_pot_rec.object_version_number THEN
1420: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1421: RAISE OKC_API.G_EXCEPTION_ERROR;
1422: ELSIF lc_object_version_number = -1 THEN
1423: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1424: RAISE OKC_API.G_EXCEPTION_ERROR;
1425: END IF;
1426: x_return_status := l_return_status;
1427: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1424: RAISE OKC_API.G_EXCEPTION_ERROR;

1420: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1421: RAISE OKC_API.G_EXCEPTION_ERROR;
1422: ELSIF lc_object_version_number = -1 THEN
1423: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1424: RAISE OKC_API.G_EXCEPTION_ERROR;
1425: END IF;
1426: x_return_status := l_return_status;
1427: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1428: EXCEPTION

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

1423: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1424: RAISE OKC_API.G_EXCEPTION_ERROR;
1425: END IF;
1426: x_return_status := l_return_status;
1427: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1428: EXCEPTION
1429: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1430: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1431: (

Line 1429: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1425: END IF;
1426: x_return_status := l_return_status;
1427: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1428: EXCEPTION
1429: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1430: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1431: (
1432: l_api_name,
1433: G_PKG_NAME,

Line 1430: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1426: x_return_status := l_return_status;
1427: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1428: EXCEPTION
1429: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1430: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1431: (
1432: l_api_name,
1433: G_PKG_NAME,
1434: 'OKC_API.G_RET_STS_ERROR',

Line 1434: 'OKC_API.G_RET_STS_ERROR',

1430: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1431: (
1432: l_api_name,
1433: G_PKG_NAME,
1434: 'OKC_API.G_RET_STS_ERROR',
1435: x_msg_count,
1436: x_msg_data,
1437: '_PVT'
1438: );

Line 1439: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1440: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1436: x_msg_data,
1437: '_PVT'
1438: );
1439: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1440: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1441: (
1442: l_api_name,
1443: G_PKG_NAME,
1444: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1444: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1450: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1446: x_msg_data,
1447: '_PVT'
1448: );
1449: WHEN OTHERS THEN
1450: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1451: (
1452: l_api_name,
1453: G_PKG_NAME,
1454: 'OTHERS',

Line 1465: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1461: -- lock_row for: OKL_POOL_TYPES_V --
1462: -----------------------------------------
1463: PROCEDURE lock_row(
1464: p_api_version IN NUMBER,
1465: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1466: x_return_status OUT NOCOPY VARCHAR2,
1467: x_msg_count OUT NOCOPY NUMBER,
1468: x_msg_data OUT NOCOPY VARCHAR2,
1469: p_potv_rec IN potv_rec_type) IS

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

1469: p_potv_rec IN potv_rec_type) IS
1470:
1471: l_api_version CONSTANT NUMBER := 1;
1472: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1473: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1474: l_pot_rec pot_rec_type;
1475: BEGIN
1476: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1477: G_PKG_NAME,

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

1472: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1473: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1474: l_pot_rec pot_rec_type;
1475: BEGIN
1476: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1477: G_PKG_NAME,
1478: p_init_msg_list,
1479: l_api_version,
1480: p_api_version,

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

1479: l_api_version,
1480: p_api_version,
1481: '_PVT',
1482: x_return_status);
1483: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1485: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1486: RAISE OKC_API.G_EXCEPTION_ERROR;
1487: END IF;

Line 1484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1480: p_api_version,
1481: '_PVT',
1482: x_return_status);
1483: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1485: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1486: RAISE OKC_API.G_EXCEPTION_ERROR;
1487: END IF;
1488: -----------------------------------------

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

1481: '_PVT',
1482: x_return_status);
1483: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1485: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1486: RAISE OKC_API.G_EXCEPTION_ERROR;
1487: END IF;
1488: -----------------------------------------
1489: -- Move VIEW record to "Child" records --

Line 1486: RAISE OKC_API.G_EXCEPTION_ERROR;

1482: x_return_status);
1483: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1485: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1486: RAISE OKC_API.G_EXCEPTION_ERROR;
1487: END IF;
1488: -----------------------------------------
1489: -- Move VIEW record to "Child" records --
1490: -----------------------------------------

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

1498: x_msg_count,
1499: x_msg_data,
1500: l_pot_rec
1501: );
1502: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1503: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1504: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1505: RAISE OKC_API.G_EXCEPTION_ERROR;
1506: END IF;

Line 1503: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1499: x_msg_data,
1500: l_pot_rec
1501: );
1502: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1503: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1504: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1505: RAISE OKC_API.G_EXCEPTION_ERROR;
1506: END IF;
1507: x_return_status := l_return_status;

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

1500: l_pot_rec
1501: );
1502: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1503: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1504: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1505: RAISE OKC_API.G_EXCEPTION_ERROR;
1506: END IF;
1507: x_return_status := l_return_status;
1508: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1505: RAISE OKC_API.G_EXCEPTION_ERROR;

1501: );
1502: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1503: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1504: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1505: RAISE OKC_API.G_EXCEPTION_ERROR;
1506: END IF;
1507: x_return_status := l_return_status;
1508: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1509: EXCEPTION

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

1504: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1505: RAISE OKC_API.G_EXCEPTION_ERROR;
1506: END IF;
1507: x_return_status := l_return_status;
1508: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1509: EXCEPTION
1510: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1511: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1512: (

Line 1510: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1506: END IF;
1507: x_return_status := l_return_status;
1508: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1509: EXCEPTION
1510: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1511: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1512: (
1513: l_api_name,
1514: G_PKG_NAME,

Line 1511: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1507: x_return_status := l_return_status;
1508: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1509: EXCEPTION
1510: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1511: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1512: (
1513: l_api_name,
1514: G_PKG_NAME,
1515: 'OKC_API.G_RET_STS_ERROR',

Line 1515: 'OKC_API.G_RET_STS_ERROR',

1511: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1512: (
1513: l_api_name,
1514: G_PKG_NAME,
1515: 'OKC_API.G_RET_STS_ERROR',
1516: x_msg_count,
1517: x_msg_data,
1518: '_PVT'
1519: );

Line 1520: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1516: x_msg_count,
1517: x_msg_data,
1518: '_PVT'
1519: );
1520: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1521: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1522: (
1523: l_api_name,
1524: G_PKG_NAME,

Line 1521: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1517: x_msg_data,
1518: '_PVT'
1519: );
1520: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1521: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1522: (
1523: l_api_name,
1524: G_PKG_NAME,
1525: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1525: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1521: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1522: (
1523: l_api_name,
1524: G_PKG_NAME,
1525: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1526: x_msg_count,
1527: x_msg_data,
1528: '_PVT'
1529: );

Line 1531: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1527: x_msg_data,
1528: '_PVT'
1529: );
1530: WHEN OTHERS THEN
1531: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1532: (
1533: l_api_name,
1534: G_PKG_NAME,
1535: 'OTHERS',

Line 1546: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1542: -- PL/SQL TBL lock_row for:potv_TBL --
1543: --------------------------------------
1544: PROCEDURE lock_row(
1545: p_api_version IN NUMBER,
1546: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1547: x_return_status OUT NOCOPY VARCHAR2,
1548: x_msg_count OUT NOCOPY NUMBER,
1549: x_msg_data OUT NOCOPY VARCHAR2,
1550: p_potv_tbl IN potv_tbl_type,

Line 1551: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

1547: x_return_status OUT NOCOPY VARCHAR2,
1548: x_msg_count OUT NOCOPY NUMBER,
1549: x_msg_data OUT NOCOPY VARCHAR2,
1550: p_potv_tbl IN potv_tbl_type,
1551: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1552:
1553: l_api_version CONSTANT NUMBER := 1;
1554: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1555: i NUMBER := 0;

Line 1557: OKC_API.init_msg_list(p_init_msg_list);

1553: l_api_version CONSTANT NUMBER := 1;
1554: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1555: i NUMBER := 0;
1556: BEGIN
1557: OKC_API.init_msg_list(p_init_msg_list);
1558: -- Make sure PL/SQL table has recrods in it before passing
1559: IF (p_potv_tbl.COUNT > 0) THEN
1560: i := p_potv_tbl.FIRST;
1561: LOOP

Line 1563: l_error_rec OKC_API.ERROR_REC_TYPE;

1559: IF (p_potv_tbl.COUNT > 0) THEN
1560: i := p_potv_tbl.FIRST;
1561: LOOP
1562: DECLARE
1563: l_error_rec OKC_API.ERROR_REC_TYPE;
1564: BEGIN
1565: l_error_rec.api_name := l_api_name;
1566: l_error_rec.api_package := G_PKG_NAME;
1567: l_error_rec.idx := i;

Line 1570: p_init_msg_list => OKC_API.G_FALSE,

1566: l_error_rec.api_package := G_PKG_NAME;
1567: l_error_rec.idx := i;
1568: lock_row(
1569: p_api_version => p_api_version,
1570: p_init_msg_list => OKC_API.G_FALSE,
1571: x_return_status => l_error_rec.error_type,
1572: x_msg_count => l_error_rec.msg_count,
1573: x_msg_data => l_error_rec.msg_data,
1574: p_potv_rec => p_potv_tbl(i));

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

1571: x_return_status => l_error_rec.error_type,
1572: x_msg_count => l_error_rec.msg_count,
1573: x_msg_data => l_error_rec.msg_data,
1574: p_potv_rec => p_potv_tbl(i));
1575: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1576: l_error_rec.SQLCODE := SQLCODE;
1577: load_error_tbl(l_error_rec, px_error_tbl);
1578: ELSE
1579: x_msg_count := l_error_rec.msg_count;

Line 1583: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1579: x_msg_count := l_error_rec.msg_count;
1580: x_msg_data := l_error_rec.msg_data;
1581: END IF;
1582: EXCEPTION
1583: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1584: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1585: l_error_rec.SQLCODE := SQLCODE;
1586: load_error_tbl(l_error_rec, px_error_tbl);
1587: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

1580: x_msg_data := l_error_rec.msg_data;
1581: END IF;
1582: EXCEPTION
1583: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1584: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1585: l_error_rec.SQLCODE := SQLCODE;
1586: load_error_tbl(l_error_rec, px_error_tbl);
1587: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1588: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 1587: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1583: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1584: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1585: l_error_rec.SQLCODE := SQLCODE;
1586: load_error_tbl(l_error_rec, px_error_tbl);
1587: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1588: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1589: l_error_rec.SQLCODE := SQLCODE;
1590: load_error_tbl(l_error_rec, px_error_tbl);
1591: WHEN OTHERS THEN

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

1584: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1585: l_error_rec.SQLCODE := SQLCODE;
1586: load_error_tbl(l_error_rec, px_error_tbl);
1587: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1588: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1589: l_error_rec.SQLCODE := SQLCODE;
1590: load_error_tbl(l_error_rec, px_error_tbl);
1591: WHEN OTHERS THEN
1592: l_error_rec.error_type := 'OTHERS';

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

1599: END IF;
1600: -- Loop through the error_tbl to find the error with the highest severity
1601: -- and return it.
1602: x_return_status := find_highest_exception(px_error_tbl);
1603: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1604: EXCEPTION
1605: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1606: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1607: (

Line 1605: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1601: -- and return it.
1602: x_return_status := find_highest_exception(px_error_tbl);
1603: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1604: EXCEPTION
1605: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1606: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1607: (
1608: l_api_name,
1609: G_PKG_NAME,

Line 1606: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1602: x_return_status := find_highest_exception(px_error_tbl);
1603: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1604: EXCEPTION
1605: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1606: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1607: (
1608: l_api_name,
1609: G_PKG_NAME,
1610: 'OKC_API.G_RET_STS_ERROR',

Line 1610: 'OKC_API.G_RET_STS_ERROR',

1606: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1607: (
1608: l_api_name,
1609: G_PKG_NAME,
1610: 'OKC_API.G_RET_STS_ERROR',
1611: x_msg_count,
1612: x_msg_data,
1613: '_PVT'
1614: );

Line 1615: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1611: x_msg_count,
1612: x_msg_data,
1613: '_PVT'
1614: );
1615: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1616: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1617: (
1618: l_api_name,
1619: G_PKG_NAME,

Line 1616: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1612: x_msg_data,
1613: '_PVT'
1614: );
1615: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1616: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1617: (
1618: l_api_name,
1619: G_PKG_NAME,
1620: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1620: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1616: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1617: (
1618: l_api_name,
1619: G_PKG_NAME,
1620: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1621: x_msg_count,
1622: x_msg_data,
1623: '_PVT'
1624: );

Line 1626: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1622: x_msg_data,
1623: '_PVT'
1624: );
1625: WHEN OTHERS THEN
1626: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1627: (
1628: l_api_name,
1629: G_PKG_NAME,
1630: 'OTHERS',

Line 1641: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1637: -- PL/SQL TBL lock_row for:potv_TBL --
1638: --------------------------------------
1639: PROCEDURE lock_row(
1640: p_api_version IN NUMBER,
1641: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1642: x_return_status OUT NOCOPY VARCHAR2,
1643: x_msg_count OUT NOCOPY NUMBER,
1644: x_msg_data OUT NOCOPY VARCHAR2,
1645: p_potv_tbl IN potv_tbl_type) IS

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

1645: p_potv_tbl IN potv_tbl_type) IS
1646:
1647: l_api_version CONSTANT NUMBER := 1;
1648: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1649: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1650: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1651: BEGIN
1652: OKC_API.init_msg_list(p_init_msg_list);
1653: -- Make sure PL/SQL table has recrods in it before passing

Line 1650: l_error_tbl OKC_API.ERROR_TBL_TYPE;

1646:
1647: l_api_version CONSTANT NUMBER := 1;
1648: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1649: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1650: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1651: BEGIN
1652: OKC_API.init_msg_list(p_init_msg_list);
1653: -- Make sure PL/SQL table has recrods in it before passing
1654: IF (p_potv_tbl.COUNT > 0) THEN

Line 1652: OKC_API.init_msg_list(p_init_msg_list);

1648: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1649: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1650: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1651: BEGIN
1652: OKC_API.init_msg_list(p_init_msg_list);
1653: -- Make sure PL/SQL table has recrods in it before passing
1654: IF (p_potv_tbl.COUNT > 0) THEN
1655: lock_row(
1656: p_api_version => p_api_version,

Line 1657: p_init_msg_list => OKC_API.G_FALSE,

1653: -- Make sure PL/SQL table has recrods in it before passing
1654: IF (p_potv_tbl.COUNT > 0) THEN
1655: lock_row(
1656: p_api_version => p_api_version,
1657: p_init_msg_list => OKC_API.G_FALSE,
1658: x_return_status => x_return_status,
1659: x_msg_count => x_msg_count,
1660: x_msg_data => x_msg_data,
1661: p_potv_tbl => p_potv_tbl,

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

1660: x_msg_data => x_msg_data,
1661: p_potv_tbl => p_potv_tbl,
1662: px_error_tbl => l_error_tbl);
1663: END IF;
1664: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1665: EXCEPTION
1666: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1667: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1668: (

Line 1666: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1662: px_error_tbl => l_error_tbl);
1663: END IF;
1664: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1665: EXCEPTION
1666: WHEN OKC_API.G_EXCEPTION_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: END IF;
1664: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1665: EXCEPTION
1666: WHEN OKC_API.G_EXCEPTION_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_ERROR',

Line 1671: 'OKC_API.G_RET_STS_ERROR',

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

Line 1676: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1677: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1681: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1677: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1678: (
1679: l_api_name,
1680: G_PKG_NAME,
1681: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1682: x_msg_count,
1683: x_msg_data,
1684: '_PVT'
1685: );

Line 1687: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1683: x_msg_data,
1684: '_PVT'
1685: );
1686: WHEN OTHERS THEN
1687: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1688: (
1689: l_api_name,
1690: G_PKG_NAME,
1691: 'OTHERS',

Line 1704: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1700: ----------------------------------------
1701: -- update_row for:okl_pool_types --
1702: ----------------------------------------
1703: PROCEDURE update_row(
1704: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1705: x_return_status OUT NOCOPY VARCHAR2,
1706: x_msg_count OUT NOCOPY NUMBER,
1707: x_msg_data OUT NOCOPY VARCHAR2,
1708: p_pot_rec IN pot_rec_type,

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

1709: x_pot_rec OUT NOCOPY pot_rec_type) IS
1710:
1711: l_api_version CONSTANT NUMBER := 1;
1712: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1713: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1714: l_pot_rec pot_rec_type := p_pot_rec;
1715: l_def_pot_rec pot_rec_type;
1716: l_row_notfound BOOLEAN := TRUE;
1717: ----------------------------------

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

1722: x_pot_rec OUT NOCOPY pot_rec_type
1723: ) RETURN VARCHAR2 IS
1724: l_pot_rec pot_rec_type;
1725: l_row_notfound BOOLEAN := TRUE;
1726: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1727: BEGIN
1728: x_pot_rec := p_pot_rec;
1729: -- Get current database values
1730: l_pot_rec := get_rec(p_pot_rec, l_return_status);

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

1727: BEGIN
1728: x_pot_rec := p_pot_rec;
1729: -- Get current database values
1730: l_pot_rec := get_rec(p_pot_rec, l_return_status);
1731: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1732:
1733: IF (x_pot_rec.id = OKC_API.G_MISS_NUM)
1734: THEN
1735: x_pot_rec.id := l_pot_rec.id;

Line 1733: IF (x_pot_rec.id = OKC_API.G_MISS_NUM)

1729: -- Get current database values
1730: l_pot_rec := get_rec(p_pot_rec, l_return_status);
1731: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1732:
1733: IF (x_pot_rec.id = OKC_API.G_MISS_NUM)
1734: THEN
1735: x_pot_rec.id := l_pot_rec.id;
1736: END IF;
1737: IF (x_pot_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1737: IF (x_pot_rec.object_version_number = OKC_API.G_MISS_NUM)

1733: IF (x_pot_rec.id = OKC_API.G_MISS_NUM)
1734: THEN
1735: x_pot_rec.id := l_pot_rec.id;
1736: END IF;
1737: IF (x_pot_rec.object_version_number = OKC_API.G_MISS_NUM)
1738: THEN
1739: x_pot_rec.object_version_number := l_pot_rec.object_version_number;
1740: END IF;
1741: IF (x_pot_rec.code = OKC_API.G_MISS_CHAR)

Line 1741: IF (x_pot_rec.code = OKC_API.G_MISS_CHAR)

1737: IF (x_pot_rec.object_version_number = OKC_API.G_MISS_NUM)
1738: THEN
1739: x_pot_rec.object_version_number := l_pot_rec.object_version_number;
1740: END IF;
1741: IF (x_pot_rec.code = OKC_API.G_MISS_CHAR)
1742: THEN
1743: x_pot_rec.code := l_pot_rec.code;
1744: END IF;
1745: IF (x_pot_rec.description = OKC_API.G_MISS_CHAR)

Line 1745: IF (x_pot_rec.description = OKC_API.G_MISS_CHAR)

1741: IF (x_pot_rec.code = OKC_API.G_MISS_CHAR)
1742: THEN
1743: x_pot_rec.code := l_pot_rec.code;
1744: END IF;
1745: IF (x_pot_rec.description = OKC_API.G_MISS_CHAR)
1746: THEN
1747: x_pot_rec.description := l_pot_rec.description;
1748: END IF;
1749: IF (x_pot_rec.short_description = OKC_API.G_MISS_CHAR)

Line 1749: IF (x_pot_rec.short_description = OKC_API.G_MISS_CHAR)

1745: IF (x_pot_rec.description = OKC_API.G_MISS_CHAR)
1746: THEN
1747: x_pot_rec.description := l_pot_rec.description;
1748: END IF;
1749: IF (x_pot_rec.short_description = OKC_API.G_MISS_CHAR)
1750: THEN
1751: x_pot_rec.short_description := l_pot_rec.short_description;
1752: END IF;
1753: IF (x_pot_rec.from_date = OKC_API.G_MISS_DATE)

Line 1753: IF (x_pot_rec.from_date = OKC_API.G_MISS_DATE)

1749: IF (x_pot_rec.short_description = OKC_API.G_MISS_CHAR)
1750: THEN
1751: x_pot_rec.short_description := l_pot_rec.short_description;
1752: END IF;
1753: IF (x_pot_rec.from_date = OKC_API.G_MISS_DATE)
1754: THEN
1755: x_pot_rec.from_date := l_pot_rec.from_date;
1756: END IF;
1757: IF (x_pot_rec.TO_DATE = OKC_API.G_MISS_DATE)

Line 1757: IF (x_pot_rec.TO_DATE = OKC_API.G_MISS_DATE)

1753: IF (x_pot_rec.from_date = OKC_API.G_MISS_DATE)
1754: THEN
1755: x_pot_rec.from_date := l_pot_rec.from_date;
1756: END IF;
1757: IF (x_pot_rec.TO_DATE = OKC_API.G_MISS_DATE)
1758: THEN
1759: x_pot_rec.TO_DATE := l_pot_rec.TO_DATE;
1760: END IF;
1761: IF (x_pot_rec.attribute_category = OKC_API.G_MISS_CHAR)

Line 1761: IF (x_pot_rec.attribute_category = OKC_API.G_MISS_CHAR)

1757: IF (x_pot_rec.TO_DATE = OKC_API.G_MISS_DATE)
1758: THEN
1759: x_pot_rec.TO_DATE := l_pot_rec.TO_DATE;
1760: END IF;
1761: IF (x_pot_rec.attribute_category = OKC_API.G_MISS_CHAR)
1762: THEN
1763: x_pot_rec.attribute_category := l_pot_rec.attribute_category;
1764: END IF;
1765: IF (x_pot_rec.attribute1 = OKC_API.G_MISS_CHAR)

Line 1765: IF (x_pot_rec.attribute1 = OKC_API.G_MISS_CHAR)

1761: IF (x_pot_rec.attribute_category = OKC_API.G_MISS_CHAR)
1762: THEN
1763: x_pot_rec.attribute_category := l_pot_rec.attribute_category;
1764: END IF;
1765: IF (x_pot_rec.attribute1 = OKC_API.G_MISS_CHAR)
1766: THEN
1767: x_pot_rec.attribute1 := l_pot_rec.attribute1;
1768: END IF;
1769: IF (x_pot_rec.attribute2 = OKC_API.G_MISS_CHAR)

Line 1769: IF (x_pot_rec.attribute2 = OKC_API.G_MISS_CHAR)

1765: IF (x_pot_rec.attribute1 = OKC_API.G_MISS_CHAR)
1766: THEN
1767: x_pot_rec.attribute1 := l_pot_rec.attribute1;
1768: END IF;
1769: IF (x_pot_rec.attribute2 = OKC_API.G_MISS_CHAR)
1770: THEN
1771: x_pot_rec.attribute2 := l_pot_rec.attribute2;
1772: END IF;
1773: IF (x_pot_rec.attribute3 = OKC_API.G_MISS_CHAR)

Line 1773: IF (x_pot_rec.attribute3 = OKC_API.G_MISS_CHAR)

1769: IF (x_pot_rec.attribute2 = OKC_API.G_MISS_CHAR)
1770: THEN
1771: x_pot_rec.attribute2 := l_pot_rec.attribute2;
1772: END IF;
1773: IF (x_pot_rec.attribute3 = OKC_API.G_MISS_CHAR)
1774: THEN
1775: x_pot_rec.attribute3 := l_pot_rec.attribute3;
1776: END IF;
1777: IF (x_pot_rec.attribute4 = OKC_API.G_MISS_CHAR)

Line 1777: IF (x_pot_rec.attribute4 = OKC_API.G_MISS_CHAR)

1773: IF (x_pot_rec.attribute3 = OKC_API.G_MISS_CHAR)
1774: THEN
1775: x_pot_rec.attribute3 := l_pot_rec.attribute3;
1776: END IF;
1777: IF (x_pot_rec.attribute4 = OKC_API.G_MISS_CHAR)
1778: THEN
1779: x_pot_rec.attribute4 := l_pot_rec.attribute4;
1780: END IF;
1781: IF (x_pot_rec.attribute5 = OKC_API.G_MISS_CHAR)

Line 1781: IF (x_pot_rec.attribute5 = OKC_API.G_MISS_CHAR)

1777: IF (x_pot_rec.attribute4 = OKC_API.G_MISS_CHAR)
1778: THEN
1779: x_pot_rec.attribute4 := l_pot_rec.attribute4;
1780: END IF;
1781: IF (x_pot_rec.attribute5 = OKC_API.G_MISS_CHAR)
1782: THEN
1783: x_pot_rec.attribute5 := l_pot_rec.attribute5;
1784: END IF;
1785: IF (x_pot_rec.attribute6 = OKC_API.G_MISS_CHAR)

Line 1785: IF (x_pot_rec.attribute6 = OKC_API.G_MISS_CHAR)

1781: IF (x_pot_rec.attribute5 = OKC_API.G_MISS_CHAR)
1782: THEN
1783: x_pot_rec.attribute5 := l_pot_rec.attribute5;
1784: END IF;
1785: IF (x_pot_rec.attribute6 = OKC_API.G_MISS_CHAR)
1786: THEN
1787: x_pot_rec.attribute6 := l_pot_rec.attribute6;
1788: END IF;
1789: IF (x_pot_rec.attribute7 = OKC_API.G_MISS_CHAR)

Line 1789: IF (x_pot_rec.attribute7 = OKC_API.G_MISS_CHAR)

1785: IF (x_pot_rec.attribute6 = OKC_API.G_MISS_CHAR)
1786: THEN
1787: x_pot_rec.attribute6 := l_pot_rec.attribute6;
1788: END IF;
1789: IF (x_pot_rec.attribute7 = OKC_API.G_MISS_CHAR)
1790: THEN
1791: x_pot_rec.attribute7 := l_pot_rec.attribute7;
1792: END IF;
1793: IF (x_pot_rec.attribute8 = OKC_API.G_MISS_CHAR)

Line 1793: IF (x_pot_rec.attribute8 = OKC_API.G_MISS_CHAR)

1789: IF (x_pot_rec.attribute7 = OKC_API.G_MISS_CHAR)
1790: THEN
1791: x_pot_rec.attribute7 := l_pot_rec.attribute7;
1792: END IF;
1793: IF (x_pot_rec.attribute8 = OKC_API.G_MISS_CHAR)
1794: THEN
1795: x_pot_rec.attribute8 := l_pot_rec.attribute8;
1796: END IF;
1797: IF (x_pot_rec.attribute9 = OKC_API.G_MISS_CHAR)

Line 1797: IF (x_pot_rec.attribute9 = OKC_API.G_MISS_CHAR)

1793: IF (x_pot_rec.attribute8 = OKC_API.G_MISS_CHAR)
1794: THEN
1795: x_pot_rec.attribute8 := l_pot_rec.attribute8;
1796: END IF;
1797: IF (x_pot_rec.attribute9 = OKC_API.G_MISS_CHAR)
1798: THEN
1799: x_pot_rec.attribute9 := l_pot_rec.attribute9;
1800: END IF;
1801: IF (x_pot_rec.attribute10 = OKC_API.G_MISS_CHAR)

Line 1801: IF (x_pot_rec.attribute10 = OKC_API.G_MISS_CHAR)

1797: IF (x_pot_rec.attribute9 = OKC_API.G_MISS_CHAR)
1798: THEN
1799: x_pot_rec.attribute9 := l_pot_rec.attribute9;
1800: END IF;
1801: IF (x_pot_rec.attribute10 = OKC_API.G_MISS_CHAR)
1802: THEN
1803: x_pot_rec.attribute10 := l_pot_rec.attribute10;
1804: END IF;
1805: IF (x_pot_rec.attribute11 = OKC_API.G_MISS_CHAR)

Line 1805: IF (x_pot_rec.attribute11 = OKC_API.G_MISS_CHAR)

1801: IF (x_pot_rec.attribute10 = OKC_API.G_MISS_CHAR)
1802: THEN
1803: x_pot_rec.attribute10 := l_pot_rec.attribute10;
1804: END IF;
1805: IF (x_pot_rec.attribute11 = OKC_API.G_MISS_CHAR)
1806: THEN
1807: x_pot_rec.attribute11 := l_pot_rec.attribute11;
1808: END IF;
1809: IF (x_pot_rec.attribute12 = OKC_API.G_MISS_CHAR)

Line 1809: IF (x_pot_rec.attribute12 = OKC_API.G_MISS_CHAR)

1805: IF (x_pot_rec.attribute11 = OKC_API.G_MISS_CHAR)
1806: THEN
1807: x_pot_rec.attribute11 := l_pot_rec.attribute11;
1808: END IF;
1809: IF (x_pot_rec.attribute12 = OKC_API.G_MISS_CHAR)
1810: THEN
1811: x_pot_rec.attribute12 := l_pot_rec.attribute12;
1812: END IF;
1813: IF (x_pot_rec.attribute13 = OKC_API.G_MISS_CHAR)

Line 1813: IF (x_pot_rec.attribute13 = OKC_API.G_MISS_CHAR)

1809: IF (x_pot_rec.attribute12 = OKC_API.G_MISS_CHAR)
1810: THEN
1811: x_pot_rec.attribute12 := l_pot_rec.attribute12;
1812: END IF;
1813: IF (x_pot_rec.attribute13 = OKC_API.G_MISS_CHAR)
1814: THEN
1815: x_pot_rec.attribute13 := l_pot_rec.attribute13;
1816: END IF;
1817: IF (x_pot_rec.attribute14 = OKC_API.G_MISS_CHAR)

Line 1817: IF (x_pot_rec.attribute14 = OKC_API.G_MISS_CHAR)

1813: IF (x_pot_rec.attribute13 = OKC_API.G_MISS_CHAR)
1814: THEN
1815: x_pot_rec.attribute13 := l_pot_rec.attribute13;
1816: END IF;
1817: IF (x_pot_rec.attribute14 = OKC_API.G_MISS_CHAR)
1818: THEN
1819: x_pot_rec.attribute14 := l_pot_rec.attribute14;
1820: END IF;
1821: IF (x_pot_rec.attribute15 = OKC_API.G_MISS_CHAR)

Line 1821: IF (x_pot_rec.attribute15 = OKC_API.G_MISS_CHAR)

1817: IF (x_pot_rec.attribute14 = OKC_API.G_MISS_CHAR)
1818: THEN
1819: x_pot_rec.attribute14 := l_pot_rec.attribute14;
1820: END IF;
1821: IF (x_pot_rec.attribute15 = OKC_API.G_MISS_CHAR)
1822: THEN
1823: x_pot_rec.attribute15 := l_pot_rec.attribute15;
1824: END IF;
1825: IF (x_pot_rec.created_by = OKC_API.G_MISS_NUM)

Line 1825: IF (x_pot_rec.created_by = OKC_API.G_MISS_NUM)

1821: IF (x_pot_rec.attribute15 = OKC_API.G_MISS_CHAR)
1822: THEN
1823: x_pot_rec.attribute15 := l_pot_rec.attribute15;
1824: END IF;
1825: IF (x_pot_rec.created_by = OKC_API.G_MISS_NUM)
1826: THEN
1827: x_pot_rec.created_by := l_pot_rec.created_by;
1828: END IF;
1829: IF (x_pot_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1829: IF (x_pot_rec.creation_date = OKC_API.G_MISS_DATE)

1825: IF (x_pot_rec.created_by = OKC_API.G_MISS_NUM)
1826: THEN
1827: x_pot_rec.created_by := l_pot_rec.created_by;
1828: END IF;
1829: IF (x_pot_rec.creation_date = OKC_API.G_MISS_DATE)
1830: THEN
1831: x_pot_rec.creation_date := l_pot_rec.creation_date;
1832: END IF;
1833: IF (x_pot_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1833: IF (x_pot_rec.last_updated_by = OKC_API.G_MISS_NUM)

1829: IF (x_pot_rec.creation_date = OKC_API.G_MISS_DATE)
1830: THEN
1831: x_pot_rec.creation_date := l_pot_rec.creation_date;
1832: END IF;
1833: IF (x_pot_rec.last_updated_by = OKC_API.G_MISS_NUM)
1834: THEN
1835: x_pot_rec.last_updated_by := l_pot_rec.last_updated_by;
1836: END IF;
1837: IF (x_pot_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1837: IF (x_pot_rec.last_update_date = OKC_API.G_MISS_DATE)

1833: IF (x_pot_rec.last_updated_by = OKC_API.G_MISS_NUM)
1834: THEN
1835: x_pot_rec.last_updated_by := l_pot_rec.last_updated_by;
1836: END IF;
1837: IF (x_pot_rec.last_update_date = OKC_API.G_MISS_DATE)
1838: THEN
1839: x_pot_rec.last_update_date := l_pot_rec.last_update_date;
1840: END IF;
1841: IF (x_pot_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1841: IF (x_pot_rec.last_update_login = OKC_API.G_MISS_NUM)

1837: IF (x_pot_rec.last_update_date = OKC_API.G_MISS_DATE)
1838: THEN
1839: x_pot_rec.last_update_date := l_pot_rec.last_update_date;
1840: END IF;
1841: IF (x_pot_rec.last_update_login = OKC_API.G_MISS_NUM)
1842: THEN
1843: x_pot_rec.last_update_login := l_pot_rec.last_update_login;
1844: END IF;
1845: END IF;

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

1851: FUNCTION Set_Attributes (
1852: p_pot_rec IN pot_rec_type,
1853: x_pot_rec OUT NOCOPY pot_rec_type
1854: ) RETURN VARCHAR2 IS
1855: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1856: BEGIN
1857: x_pot_rec := p_pot_rec;
1858: x_pot_rec.OBJECT_VERSION_NUMBER := p_pot_rec.OBJECT_VERSION_NUMBER + 1;
1859: RETURN(l_return_status);

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

1858: x_pot_rec.OBJECT_VERSION_NUMBER := p_pot_rec.OBJECT_VERSION_NUMBER + 1;
1859: RETURN(l_return_status);
1860: END Set_Attributes;
1861: BEGIN
1862: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1863: p_init_msg_list,
1864: '_PVT',
1865: x_return_status);
1866: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1862: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1863: p_init_msg_list,
1864: '_PVT',
1865: x_return_status);
1866: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1867: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1868: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1869: RAISE OKC_API.G_EXCEPTION_ERROR;
1870: END IF;

Line 1867: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1863: p_init_msg_list,
1864: '_PVT',
1865: x_return_status);
1866: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1867: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1868: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1869: RAISE OKC_API.G_EXCEPTION_ERROR;
1870: END IF;
1871: --- Setting item attributes

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

1864: '_PVT',
1865: x_return_status);
1866: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1867: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1868: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1869: RAISE OKC_API.G_EXCEPTION_ERROR;
1870: END IF;
1871: --- Setting item attributes
1872: l_return_status := Set_Attributes(

Line 1869: RAISE OKC_API.G_EXCEPTION_ERROR;

1865: x_return_status);
1866: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1867: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1868: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1869: RAISE OKC_API.G_EXCEPTION_ERROR;
1870: END IF;
1871: --- Setting item attributes
1872: l_return_status := Set_Attributes(
1873: p_pot_rec, -- IN

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

1872: l_return_status := Set_Attributes(
1873: p_pot_rec, -- IN
1874: l_pot_rec); -- OUT
1875: --- If any errors happen abort API
1876: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1877: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1878: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1879: RAISE OKC_API.G_EXCEPTION_ERROR;
1880: END IF;

Line 1877: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1873: p_pot_rec, -- IN
1874: l_pot_rec); -- OUT
1875: --- If any errors happen abort API
1876: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1877: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1878: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1879: RAISE OKC_API.G_EXCEPTION_ERROR;
1880: END IF;
1881: l_return_status := populate_new_record(l_pot_rec, l_def_pot_rec);

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

1874: l_pot_rec); -- OUT
1875: --- If any errors happen abort API
1876: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1877: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1878: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1879: RAISE OKC_API.G_EXCEPTION_ERROR;
1880: END IF;
1881: l_return_status := populate_new_record(l_pot_rec, l_def_pot_rec);
1882: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1879: RAISE OKC_API.G_EXCEPTION_ERROR;

1875: --- If any errors happen abort API
1876: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1877: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1878: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1879: RAISE OKC_API.G_EXCEPTION_ERROR;
1880: END IF;
1881: l_return_status := populate_new_record(l_pot_rec, l_def_pot_rec);
1882: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1878: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1879: RAISE OKC_API.G_EXCEPTION_ERROR;
1880: END IF;
1881: l_return_status := populate_new_record(l_pot_rec, l_def_pot_rec);
1882: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1885: RAISE OKC_API.G_EXCEPTION_ERROR;
1886: END IF;

Line 1883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1879: RAISE OKC_API.G_EXCEPTION_ERROR;
1880: END IF;
1881: l_return_status := populate_new_record(l_pot_rec, l_def_pot_rec);
1882: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1885: RAISE OKC_API.G_EXCEPTION_ERROR;
1886: END IF;
1887: UPDATE okl_pool_types

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

1880: END IF;
1881: l_return_status := populate_new_record(l_pot_rec, l_def_pot_rec);
1882: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1885: RAISE OKC_API.G_EXCEPTION_ERROR;
1886: END IF;
1887: UPDATE okl_pool_types
1888: SET OBJECT_VERSION_NUMBER = l_def_pot_rec.object_version_number,

Line 1885: RAISE OKC_API.G_EXCEPTION_ERROR;

1881: l_return_status := populate_new_record(l_pot_rec, l_def_pot_rec);
1882: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1885: RAISE OKC_API.G_EXCEPTION_ERROR;
1886: END IF;
1887: UPDATE okl_pool_types
1888: SET OBJECT_VERSION_NUMBER = l_def_pot_rec.object_version_number,
1889: CODE = l_def_pot_rec.code,

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

1915: WHERE ID = l_def_pot_rec.id;
1916:
1917: x_pot_rec := l_pot_rec;
1918: x_return_status := l_return_status;
1919: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1920: EXCEPTION
1921: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1922: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1923: (

Line 1921: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1917: x_pot_rec := l_pot_rec;
1918: x_return_status := l_return_status;
1919: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1920: EXCEPTION
1921: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1922: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1923: (
1924: l_api_name,
1925: G_PKG_NAME,

Line 1922: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1918: x_return_status := l_return_status;
1919: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1920: EXCEPTION
1921: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1922: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1923: (
1924: l_api_name,
1925: G_PKG_NAME,
1926: 'OKC_API.G_RET_STS_ERROR',

Line 1926: 'OKC_API.G_RET_STS_ERROR',

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

Line 1931: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1932: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1936: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1942: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1957: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1953: -- update_row for:OKL_POOL_TYPES_V --
1954: ------------------------------------------
1955: PROCEDURE update_row(
1956: p_api_version IN NUMBER,
1957: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1958: x_return_status OUT NOCOPY VARCHAR2,
1959: x_msg_count OUT NOCOPY NUMBER,
1960: x_msg_data OUT NOCOPY VARCHAR2,
1961: p_potv_rec IN potv_rec_type,

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

1962: x_potv_rec OUT NOCOPY potv_rec_type) IS
1963:
1964: l_api_version CONSTANT NUMBER := 1;
1965: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1966: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1967: l_potv_rec potv_rec_type := p_potv_rec;
1968: l_def_potv_rec potv_rec_type;
1969: l_db_potv_rec potv_rec_type;
1970: l_pot_rec pot_rec_type;

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

1989: p_potv_rec IN potv_rec_type,
1990: x_potv_rec OUT NOCOPY potv_rec_type
1991: ) RETURN VARCHAR2 IS
1992: l_row_notfound BOOLEAN := TRUE;
1993: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1994: BEGIN
1995: x_potv_rec := p_potv_rec;
1996: -- Get current database values
1997: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it

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

1996: -- Get current database values
1997: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1998: -- so it may be verified through LOCK_ROW.
1999: l_db_potv_rec := get_rec(p_potv_rec, l_return_status);
2000: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2001: IF (x_potv_rec.id = OKC_API.G_MISS_NUM)
2002: THEN
2003: x_potv_rec.id := l_db_potv_rec.id;
2004: END IF;

Line 2001: IF (x_potv_rec.id = OKC_API.G_MISS_NUM)

1997: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1998: -- so it may be verified through LOCK_ROW.
1999: l_db_potv_rec := get_rec(p_potv_rec, l_return_status);
2000: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
2001: IF (x_potv_rec.id = OKC_API.G_MISS_NUM)
2002: THEN
2003: x_potv_rec.id := l_db_potv_rec.id;
2004: END IF;
2005: IF (x_potv_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 2005: IF (x_potv_rec.object_version_number = OKC_API.G_MISS_NUM)

2001: IF (x_potv_rec.id = OKC_API.G_MISS_NUM)
2002: THEN
2003: x_potv_rec.id := l_db_potv_rec.id;
2004: END IF;
2005: IF (x_potv_rec.object_version_number = OKC_API.G_MISS_NUM)
2006: THEN
2007: x_potv_rec.object_version_number := l_db_potv_rec.object_version_number;
2008: END IF;
2009: IF (x_potv_rec.code = OKC_API.G_MISS_CHAR)

Line 2009: IF (x_potv_rec.code = OKC_API.G_MISS_CHAR)

2005: IF (x_potv_rec.object_version_number = OKC_API.G_MISS_NUM)
2006: THEN
2007: x_potv_rec.object_version_number := l_db_potv_rec.object_version_number;
2008: END IF;
2009: IF (x_potv_rec.code = OKC_API.G_MISS_CHAR)
2010: THEN
2011: x_potv_rec.code := l_db_potv_rec.code;
2012: END IF;
2013: IF (x_potv_rec.description = OKC_API.G_MISS_CHAR)

Line 2013: IF (x_potv_rec.description = OKC_API.G_MISS_CHAR)

2009: IF (x_potv_rec.code = OKC_API.G_MISS_CHAR)
2010: THEN
2011: x_potv_rec.code := l_db_potv_rec.code;
2012: END IF;
2013: IF (x_potv_rec.description = OKC_API.G_MISS_CHAR)
2014: THEN
2015: x_potv_rec.description := l_db_potv_rec.description;
2016: END IF;
2017: IF (x_potv_rec.short_description = OKC_API.G_MISS_CHAR)

Line 2017: IF (x_potv_rec.short_description = OKC_API.G_MISS_CHAR)

2013: IF (x_potv_rec.description = OKC_API.G_MISS_CHAR)
2014: THEN
2015: x_potv_rec.description := l_db_potv_rec.description;
2016: END IF;
2017: IF (x_potv_rec.short_description = OKC_API.G_MISS_CHAR)
2018: THEN
2019: x_potv_rec.short_description := l_db_potv_rec.short_description;
2020: END IF;
2021: IF (x_potv_rec.from_date = OKC_API.G_MISS_DATE)

Line 2021: IF (x_potv_rec.from_date = OKC_API.G_MISS_DATE)

2017: IF (x_potv_rec.short_description = OKC_API.G_MISS_CHAR)
2018: THEN
2019: x_potv_rec.short_description := l_db_potv_rec.short_description;
2020: END IF;
2021: IF (x_potv_rec.from_date = OKC_API.G_MISS_DATE)
2022: THEN
2023: x_potv_rec.from_date := l_db_potv_rec.from_date;
2024: END IF;
2025: IF (x_potv_rec.TO_DATE = OKC_API.G_MISS_DATE)

Line 2025: IF (x_potv_rec.TO_DATE = OKC_API.G_MISS_DATE)

2021: IF (x_potv_rec.from_date = OKC_API.G_MISS_DATE)
2022: THEN
2023: x_potv_rec.from_date := l_db_potv_rec.from_date;
2024: END IF;
2025: IF (x_potv_rec.TO_DATE = OKC_API.G_MISS_DATE)
2026: THEN
2027: x_potv_rec.TO_DATE := l_db_potv_rec.TO_DATE;
2028: END IF;
2029: IF (x_potv_rec.attribute_category = OKC_API.G_MISS_CHAR)

Line 2029: IF (x_potv_rec.attribute_category = OKC_API.G_MISS_CHAR)

2025: IF (x_potv_rec.TO_DATE = OKC_API.G_MISS_DATE)
2026: THEN
2027: x_potv_rec.TO_DATE := l_db_potv_rec.TO_DATE;
2028: END IF;
2029: IF (x_potv_rec.attribute_category = OKC_API.G_MISS_CHAR)
2030: THEN
2031: x_potv_rec.attribute_category := l_db_potv_rec.attribute_category;
2032: END IF;
2033: IF (x_potv_rec.attribute1 = OKC_API.G_MISS_CHAR)

Line 2033: IF (x_potv_rec.attribute1 = OKC_API.G_MISS_CHAR)

2029: IF (x_potv_rec.attribute_category = OKC_API.G_MISS_CHAR)
2030: THEN
2031: x_potv_rec.attribute_category := l_db_potv_rec.attribute_category;
2032: END IF;
2033: IF (x_potv_rec.attribute1 = OKC_API.G_MISS_CHAR)
2034: THEN
2035: x_potv_rec.attribute1 := l_db_potv_rec.attribute1;
2036: END IF;
2037: IF (x_potv_rec.attribute2 = OKC_API.G_MISS_CHAR)

Line 2037: IF (x_potv_rec.attribute2 = OKC_API.G_MISS_CHAR)

2033: IF (x_potv_rec.attribute1 = OKC_API.G_MISS_CHAR)
2034: THEN
2035: x_potv_rec.attribute1 := l_db_potv_rec.attribute1;
2036: END IF;
2037: IF (x_potv_rec.attribute2 = OKC_API.G_MISS_CHAR)
2038: THEN
2039: x_potv_rec.attribute2 := l_db_potv_rec.attribute2;
2040: END IF;
2041: IF (x_potv_rec.attribute3 = OKC_API.G_MISS_CHAR)

Line 2041: IF (x_potv_rec.attribute3 = OKC_API.G_MISS_CHAR)

2037: IF (x_potv_rec.attribute2 = OKC_API.G_MISS_CHAR)
2038: THEN
2039: x_potv_rec.attribute2 := l_db_potv_rec.attribute2;
2040: END IF;
2041: IF (x_potv_rec.attribute3 = OKC_API.G_MISS_CHAR)
2042: THEN
2043: x_potv_rec.attribute3 := l_db_potv_rec.attribute3;
2044: END IF;
2045: IF (x_potv_rec.attribute4 = OKC_API.G_MISS_CHAR)

Line 2045: IF (x_potv_rec.attribute4 = OKC_API.G_MISS_CHAR)

2041: IF (x_potv_rec.attribute3 = OKC_API.G_MISS_CHAR)
2042: THEN
2043: x_potv_rec.attribute3 := l_db_potv_rec.attribute3;
2044: END IF;
2045: IF (x_potv_rec.attribute4 = OKC_API.G_MISS_CHAR)
2046: THEN
2047: x_potv_rec.attribute4 := l_db_potv_rec.attribute4;
2048: END IF;
2049: IF (x_potv_rec.attribute5 = OKC_API.G_MISS_CHAR)

Line 2049: IF (x_potv_rec.attribute5 = OKC_API.G_MISS_CHAR)

2045: IF (x_potv_rec.attribute4 = OKC_API.G_MISS_CHAR)
2046: THEN
2047: x_potv_rec.attribute4 := l_db_potv_rec.attribute4;
2048: END IF;
2049: IF (x_potv_rec.attribute5 = OKC_API.G_MISS_CHAR)
2050: THEN
2051: x_potv_rec.attribute5 := l_db_potv_rec.attribute5;
2052: END IF;
2053: IF (x_potv_rec.attribute6 = OKC_API.G_MISS_CHAR)

Line 2053: IF (x_potv_rec.attribute6 = OKC_API.G_MISS_CHAR)

2049: IF (x_potv_rec.attribute5 = OKC_API.G_MISS_CHAR)
2050: THEN
2051: x_potv_rec.attribute5 := l_db_potv_rec.attribute5;
2052: END IF;
2053: IF (x_potv_rec.attribute6 = OKC_API.G_MISS_CHAR)
2054: THEN
2055: x_potv_rec.attribute6 := l_db_potv_rec.attribute6;
2056: END IF;
2057: IF (x_potv_rec.attribute7 = OKC_API.G_MISS_CHAR)

Line 2057: IF (x_potv_rec.attribute7 = OKC_API.G_MISS_CHAR)

2053: IF (x_potv_rec.attribute6 = OKC_API.G_MISS_CHAR)
2054: THEN
2055: x_potv_rec.attribute6 := l_db_potv_rec.attribute6;
2056: END IF;
2057: IF (x_potv_rec.attribute7 = OKC_API.G_MISS_CHAR)
2058: THEN
2059: x_potv_rec.attribute7 := l_db_potv_rec.attribute7;
2060: END IF;
2061: IF (x_potv_rec.attribute8 = OKC_API.G_MISS_CHAR)

Line 2061: IF (x_potv_rec.attribute8 = OKC_API.G_MISS_CHAR)

2057: IF (x_potv_rec.attribute7 = OKC_API.G_MISS_CHAR)
2058: THEN
2059: x_potv_rec.attribute7 := l_db_potv_rec.attribute7;
2060: END IF;
2061: IF (x_potv_rec.attribute8 = OKC_API.G_MISS_CHAR)
2062: THEN
2063: x_potv_rec.attribute8 := l_db_potv_rec.attribute8;
2064: END IF;
2065: IF (x_potv_rec.attribute9 = OKC_API.G_MISS_CHAR)

Line 2065: IF (x_potv_rec.attribute9 = OKC_API.G_MISS_CHAR)

2061: IF (x_potv_rec.attribute8 = OKC_API.G_MISS_CHAR)
2062: THEN
2063: x_potv_rec.attribute8 := l_db_potv_rec.attribute8;
2064: END IF;
2065: IF (x_potv_rec.attribute9 = OKC_API.G_MISS_CHAR)
2066: THEN
2067: x_potv_rec.attribute9 := l_db_potv_rec.attribute9;
2068: END IF;
2069: IF (x_potv_rec.attribute10 = OKC_API.G_MISS_CHAR)

Line 2069: IF (x_potv_rec.attribute10 = OKC_API.G_MISS_CHAR)

2065: IF (x_potv_rec.attribute9 = OKC_API.G_MISS_CHAR)
2066: THEN
2067: x_potv_rec.attribute9 := l_db_potv_rec.attribute9;
2068: END IF;
2069: IF (x_potv_rec.attribute10 = OKC_API.G_MISS_CHAR)
2070: THEN
2071: x_potv_rec.attribute10 := l_db_potv_rec.attribute10;
2072: END IF;
2073: IF (x_potv_rec.attribute11 = OKC_API.G_MISS_CHAR)

Line 2073: IF (x_potv_rec.attribute11 = OKC_API.G_MISS_CHAR)

2069: IF (x_potv_rec.attribute10 = OKC_API.G_MISS_CHAR)
2070: THEN
2071: x_potv_rec.attribute10 := l_db_potv_rec.attribute10;
2072: END IF;
2073: IF (x_potv_rec.attribute11 = OKC_API.G_MISS_CHAR)
2074: THEN
2075: x_potv_rec.attribute11 := l_db_potv_rec.attribute11;
2076: END IF;
2077: IF (x_potv_rec.attribute12 = OKC_API.G_MISS_CHAR)

Line 2077: IF (x_potv_rec.attribute12 = OKC_API.G_MISS_CHAR)

2073: IF (x_potv_rec.attribute11 = OKC_API.G_MISS_CHAR)
2074: THEN
2075: x_potv_rec.attribute11 := l_db_potv_rec.attribute11;
2076: END IF;
2077: IF (x_potv_rec.attribute12 = OKC_API.G_MISS_CHAR)
2078: THEN
2079: x_potv_rec.attribute12 := l_db_potv_rec.attribute12;
2080: END IF;
2081: IF (x_potv_rec.attribute13 = OKC_API.G_MISS_CHAR)

Line 2081: IF (x_potv_rec.attribute13 = OKC_API.G_MISS_CHAR)

2077: IF (x_potv_rec.attribute12 = OKC_API.G_MISS_CHAR)
2078: THEN
2079: x_potv_rec.attribute12 := l_db_potv_rec.attribute12;
2080: END IF;
2081: IF (x_potv_rec.attribute13 = OKC_API.G_MISS_CHAR)
2082: THEN
2083: x_potv_rec.attribute13 := l_db_potv_rec.attribute13;
2084: END IF;
2085: IF (x_potv_rec.attribute14 = OKC_API.G_MISS_CHAR)

Line 2085: IF (x_potv_rec.attribute14 = OKC_API.G_MISS_CHAR)

2081: IF (x_potv_rec.attribute13 = OKC_API.G_MISS_CHAR)
2082: THEN
2083: x_potv_rec.attribute13 := l_db_potv_rec.attribute13;
2084: END IF;
2085: IF (x_potv_rec.attribute14 = OKC_API.G_MISS_CHAR)
2086: THEN
2087: x_potv_rec.attribute14 := l_db_potv_rec.attribute14;
2088: END IF;
2089: IF (x_potv_rec.attribute15 = OKC_API.G_MISS_CHAR)

Line 2089: IF (x_potv_rec.attribute15 = OKC_API.G_MISS_CHAR)

2085: IF (x_potv_rec.attribute14 = OKC_API.G_MISS_CHAR)
2086: THEN
2087: x_potv_rec.attribute14 := l_db_potv_rec.attribute14;
2088: END IF;
2089: IF (x_potv_rec.attribute15 = OKC_API.G_MISS_CHAR)
2090: THEN
2091: x_potv_rec.attribute15 := l_db_potv_rec.attribute15;
2092: END IF;
2093: IF (x_potv_rec.created_by = OKC_API.G_MISS_NUM)

Line 2093: IF (x_potv_rec.created_by = OKC_API.G_MISS_NUM)

2089: IF (x_potv_rec.attribute15 = OKC_API.G_MISS_CHAR)
2090: THEN
2091: x_potv_rec.attribute15 := l_db_potv_rec.attribute15;
2092: END IF;
2093: IF (x_potv_rec.created_by = OKC_API.G_MISS_NUM)
2094: THEN
2095: x_potv_rec.created_by := l_db_potv_rec.created_by;
2096: END IF;
2097: IF (x_potv_rec.creation_date = OKC_API.G_MISS_DATE)

Line 2097: IF (x_potv_rec.creation_date = OKC_API.G_MISS_DATE)

2093: IF (x_potv_rec.created_by = OKC_API.G_MISS_NUM)
2094: THEN
2095: x_potv_rec.created_by := l_db_potv_rec.created_by;
2096: END IF;
2097: IF (x_potv_rec.creation_date = OKC_API.G_MISS_DATE)
2098: THEN
2099: x_potv_rec.creation_date := l_db_potv_rec.creation_date;
2100: END IF;
2101: IF (x_potv_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 2101: IF (x_potv_rec.last_updated_by = OKC_API.G_MISS_NUM)

2097: IF (x_potv_rec.creation_date = OKC_API.G_MISS_DATE)
2098: THEN
2099: x_potv_rec.creation_date := l_db_potv_rec.creation_date;
2100: END IF;
2101: IF (x_potv_rec.last_updated_by = OKC_API.G_MISS_NUM)
2102: THEN
2103: x_potv_rec.last_updated_by := l_db_potv_rec.last_updated_by;
2104: END IF;
2105: IF (x_potv_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 2105: IF (x_potv_rec.last_update_date = OKC_API.G_MISS_DATE)

2101: IF (x_potv_rec.last_updated_by = OKC_API.G_MISS_NUM)
2102: THEN
2103: x_potv_rec.last_updated_by := l_db_potv_rec.last_updated_by;
2104: END IF;
2105: IF (x_potv_rec.last_update_date = OKC_API.G_MISS_DATE)
2106: THEN
2107: x_potv_rec.last_update_date := l_db_potv_rec.last_update_date;
2108: END IF;
2109: IF (x_potv_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 2109: IF (x_potv_rec.last_update_login = OKC_API.G_MISS_NUM)

2105: IF (x_potv_rec.last_update_date = OKC_API.G_MISS_DATE)
2106: THEN
2107: x_potv_rec.last_update_date := l_db_potv_rec.last_update_date;
2108: END IF;
2109: IF (x_potv_rec.last_update_login = OKC_API.G_MISS_NUM)
2110: THEN
2111: x_potv_rec.last_update_login := l_db_potv_rec.last_update_login;
2112: END IF;
2113: END IF;

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

2119: FUNCTION Set_Attributes (
2120: p_potv_rec IN potv_rec_type,
2121: x_potv_rec OUT NOCOPY potv_rec_type
2122: ) RETURN VARCHAR2 IS
2123: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2124: BEGIN
2125: x_potv_rec := p_potv_rec;
2126: RETURN(l_return_status);
2127: END Set_Attributes;

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

2125: x_potv_rec := p_potv_rec;
2126: RETURN(l_return_status);
2127: END Set_Attributes;
2128: BEGIN
2129: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2130: G_PKG_NAME,
2131: p_init_msg_list,
2132: l_api_version,
2133: p_api_version,

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

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

Line 2137: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 2139: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

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

Line 2147: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 2149: RAISE OKC_API.G_EXCEPTION_ERROR;

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

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

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

Line 2153: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2149: RAISE OKC_API.G_EXCEPTION_ERROR;
2150: END IF;
2151: l_return_status := populate_new_record(l_potv_rec, l_def_potv_rec);
2152: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2153: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2154: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2155: RAISE OKC_API.G_EXCEPTION_ERROR;
2156: END IF;
2157: l_def_potv_rec := fill_who_columns(l_def_potv_rec);

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

2150: END IF;
2151: l_return_status := populate_new_record(l_potv_rec, l_def_potv_rec);
2152: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2153: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2154: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2155: RAISE OKC_API.G_EXCEPTION_ERROR;
2156: END IF;
2157: l_def_potv_rec := fill_who_columns(l_def_potv_rec);
2158: --- Validate all non-missing attributes (Item Level Validation)

Line 2155: RAISE OKC_API.G_EXCEPTION_ERROR;

2151: l_return_status := populate_new_record(l_potv_rec, l_def_potv_rec);
2152: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2153: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2154: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2155: RAISE OKC_API.G_EXCEPTION_ERROR;
2156: END IF;
2157: l_def_potv_rec := fill_who_columns(l_def_potv_rec);
2158: --- Validate all non-missing attributes (Item Level Validation)
2159: l_return_status := Validate_Attributes(l_def_potv_rec);

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

2157: l_def_potv_rec := fill_who_columns(l_def_potv_rec);
2158: --- Validate all non-missing attributes (Item Level Validation)
2159: l_return_status := Validate_Attributes(l_def_potv_rec);
2160: --- If any errors happen abort API
2161: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2162: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2163: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2164: RAISE OKC_API.G_EXCEPTION_ERROR;
2165: END IF;

Line 2162: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2158: --- Validate all non-missing attributes (Item Level Validation)
2159: l_return_status := Validate_Attributes(l_def_potv_rec);
2160: --- If any errors happen abort API
2161: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2162: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2163: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2164: RAISE OKC_API.G_EXCEPTION_ERROR;
2165: END IF;
2166: l_return_status := Validate_Record(l_def_potv_rec, l_db_potv_rec);

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

2159: l_return_status := Validate_Attributes(l_def_potv_rec);
2160: --- If any errors happen abort API
2161: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2162: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2163: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2164: RAISE OKC_API.G_EXCEPTION_ERROR;
2165: END IF;
2166: l_return_status := Validate_Record(l_def_potv_rec, l_db_potv_rec);
2167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2164: RAISE OKC_API.G_EXCEPTION_ERROR;

2160: --- If any errors happen abort API
2161: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2162: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2163: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2164: RAISE OKC_API.G_EXCEPTION_ERROR;
2165: END IF;
2166: l_return_status := Validate_Record(l_def_potv_rec, l_db_potv_rec);
2167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2163: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2164: RAISE OKC_API.G_EXCEPTION_ERROR;
2165: END IF;
2166: l_return_status := Validate_Record(l_def_potv_rec, l_db_potv_rec);
2167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2170: RAISE OKC_API.G_EXCEPTION_ERROR;
2171: END IF;

Line 2168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2164: RAISE OKC_API.G_EXCEPTION_ERROR;
2165: END IF;
2166: l_return_status := Validate_Record(l_def_potv_rec, l_db_potv_rec);
2167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2170: RAISE OKC_API.G_EXCEPTION_ERROR;
2171: END IF;
2172:

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

2165: END IF;
2166: l_return_status := Validate_Record(l_def_potv_rec, l_db_potv_rec);
2167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2170: RAISE OKC_API.G_EXCEPTION_ERROR;
2171: END IF;
2172:
2173: /*

Line 2170: RAISE OKC_API.G_EXCEPTION_ERROR;

2166: l_return_status := Validate_Record(l_def_potv_rec, l_db_potv_rec);
2167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2170: RAISE OKC_API.G_EXCEPTION_ERROR;
2171: END IF;
2172:
2173: /*
2174: MVASUDEV, COMMENTED, 11/08/2002

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

2179: x_return_status => l_return_status,
2180: x_msg_count => x_msg_count,
2181: x_msg_data => x_msg_data,
2182: p_potv_rec => p_potv_rec);
2183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2184: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2185: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2186: RAISE OKC_API.G_EXCEPTION_ERROR;
2187: END IF;

Line 2184: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2180: x_msg_count => x_msg_count,
2181: x_msg_data => x_msg_data,
2182: p_potv_rec => p_potv_rec);
2183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2184: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2185: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2186: RAISE OKC_API.G_EXCEPTION_ERROR;
2187: END IF;
2188: */

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

2181: x_msg_data => x_msg_data,
2182: p_potv_rec => p_potv_rec);
2183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2184: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2185: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2186: RAISE OKC_API.G_EXCEPTION_ERROR;
2187: END IF;
2188: */
2189:

Line 2186: RAISE OKC_API.G_EXCEPTION_ERROR;

2182: p_potv_rec => p_potv_rec);
2183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2184: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2185: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2186: RAISE OKC_API.G_EXCEPTION_ERROR;
2187: END IF;
2188: */
2189:
2190: -----------------------------------------

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

2201: x_msg_data,
2202: l_pot_rec,
2203: lx_pot_rec
2204: );
2205: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2206: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2207: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2208: RAISE OKC_API.G_EXCEPTION_ERROR;
2209: END IF;

Line 2206: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2202: l_pot_rec,
2203: lx_pot_rec
2204: );
2205: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2206: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2207: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2208: RAISE OKC_API.G_EXCEPTION_ERROR;
2209: END IF;
2210: migrate(lx_pot_rec, l_def_potv_rec);

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

2203: lx_pot_rec
2204: );
2205: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2206: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2207: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2208: RAISE OKC_API.G_EXCEPTION_ERROR;
2209: END IF;
2210: migrate(lx_pot_rec, l_def_potv_rec);
2211: x_potv_rec := l_def_potv_rec;

Line 2208: RAISE OKC_API.G_EXCEPTION_ERROR;

2204: );
2205: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2206: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2207: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2208: RAISE OKC_API.G_EXCEPTION_ERROR;
2209: END IF;
2210: migrate(lx_pot_rec, l_def_potv_rec);
2211: x_potv_rec := l_def_potv_rec;
2212: x_return_status := l_return_status;

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

2209: END IF;
2210: migrate(lx_pot_rec, l_def_potv_rec);
2211: x_potv_rec := l_def_potv_rec;
2212: x_return_status := l_return_status;
2213: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2214: EXCEPTION
2215: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2216: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2217: (

Line 2215: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2211: x_potv_rec := l_def_potv_rec;
2212: x_return_status := l_return_status;
2213: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2214: EXCEPTION
2215: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2216: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2217: (
2218: l_api_name,
2219: G_PKG_NAME,

Line 2216: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2212: x_return_status := l_return_status;
2213: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2214: EXCEPTION
2215: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2216: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2217: (
2218: l_api_name,
2219: G_PKG_NAME,
2220: 'OKC_API.G_RET_STS_ERROR',

Line 2220: 'OKC_API.G_RET_STS_ERROR',

2216: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2217: (
2218: l_api_name,
2219: G_PKG_NAME,
2220: 'OKC_API.G_RET_STS_ERROR',
2221: x_msg_count,
2222: x_msg_data,
2223: '_PVT'
2224: );

Line 2225: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2221: x_msg_count,
2222: x_msg_data,
2223: '_PVT'
2224: );
2225: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2226: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2227: (
2228: l_api_name,
2229: G_PKG_NAME,

Line 2226: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2222: x_msg_data,
2223: '_PVT'
2224: );
2225: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2226: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2227: (
2228: l_api_name,
2229: G_PKG_NAME,
2230: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2230: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2226: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2227: (
2228: l_api_name,
2229: G_PKG_NAME,
2230: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2231: x_msg_count,
2232: x_msg_data,
2233: '_PVT'
2234: );

Line 2236: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2232: x_msg_data,
2233: '_PVT'
2234: );
2235: WHEN OTHERS THEN
2236: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2237: (
2238: l_api_name,
2239: G_PKG_NAME,
2240: 'OTHERS',

Line 2251: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2247: -- PL/SQL TBL update_row for:potv_tbl --
2248: ----------------------------------------
2249: PROCEDURE update_row(
2250: p_api_version IN NUMBER,
2251: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2252: x_return_status OUT NOCOPY VARCHAR2,
2253: x_msg_count OUT NOCOPY NUMBER,
2254: x_msg_data OUT NOCOPY VARCHAR2,
2255: p_potv_tbl IN potv_tbl_type,

Line 2257: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

2253: x_msg_count OUT NOCOPY NUMBER,
2254: x_msg_data OUT NOCOPY VARCHAR2,
2255: p_potv_tbl IN potv_tbl_type,
2256: x_potv_tbl OUT NOCOPY potv_tbl_type,
2257: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2258:
2259: l_api_version CONSTANT NUMBER := 1;
2260: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2261: i NUMBER := 0;

Line 2263: OKC_API.init_msg_list(p_init_msg_list);

2259: l_api_version CONSTANT NUMBER := 1;
2260: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2261: i NUMBER := 0;
2262: BEGIN
2263: OKC_API.init_msg_list(p_init_msg_list);
2264: -- Make sure PL/SQL table has records in it before passing
2265: IF (p_potv_tbl.COUNT > 0) THEN
2266: i := p_potv_tbl.FIRST;
2267: LOOP

Line 2269: l_error_rec OKC_API.ERROR_REC_TYPE;

2265: IF (p_potv_tbl.COUNT > 0) THEN
2266: i := p_potv_tbl.FIRST;
2267: LOOP
2268: DECLARE
2269: l_error_rec OKC_API.ERROR_REC_TYPE;
2270: BEGIN
2271: l_error_rec.api_name := l_api_name;
2272: l_error_rec.api_package := G_PKG_NAME;
2273: l_error_rec.idx := i;

Line 2276: p_init_msg_list => OKC_API.G_FALSE,

2272: l_error_rec.api_package := G_PKG_NAME;
2273: l_error_rec.idx := i;
2274: update_row (
2275: p_api_version => p_api_version,
2276: p_init_msg_list => OKC_API.G_FALSE,
2277: x_return_status => l_error_rec.error_type,
2278: x_msg_count => l_error_rec.msg_count,
2279: x_msg_data => l_error_rec.msg_data,
2280: p_potv_rec => p_potv_tbl(i),

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

2278: x_msg_count => l_error_rec.msg_count,
2279: x_msg_data => l_error_rec.msg_data,
2280: p_potv_rec => p_potv_tbl(i),
2281: x_potv_rec => x_potv_tbl(i));
2282: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2283: l_error_rec.SQLCODE := SQLCODE;
2284: load_error_tbl(l_error_rec, px_error_tbl);
2285: ELSE
2286: x_msg_count := l_error_rec.msg_count;

Line 2290: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2286: x_msg_count := l_error_rec.msg_count;
2287: x_msg_data := l_error_rec.msg_data;
2288: END IF;
2289: EXCEPTION
2290: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2291: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2292: l_error_rec.SQLCODE := SQLCODE;
2293: load_error_tbl(l_error_rec, px_error_tbl);
2294: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

2287: x_msg_data := l_error_rec.msg_data;
2288: END IF;
2289: EXCEPTION
2290: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2291: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2292: l_error_rec.SQLCODE := SQLCODE;
2293: load_error_tbl(l_error_rec, px_error_tbl);
2294: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2295: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2294: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2290: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2291: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2292: l_error_rec.SQLCODE := SQLCODE;
2293: load_error_tbl(l_error_rec, px_error_tbl);
2294: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2295: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
2296: l_error_rec.SQLCODE := SQLCODE;
2297: load_error_tbl(l_error_rec, px_error_tbl);
2298: WHEN OTHERS THEN

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

2291: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2292: l_error_rec.SQLCODE := SQLCODE;
2293: load_error_tbl(l_error_rec, px_error_tbl);
2294: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2295: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
2296: l_error_rec.SQLCODE := SQLCODE;
2297: load_error_tbl(l_error_rec, px_error_tbl);
2298: WHEN OTHERS THEN
2299: l_error_rec.error_type := 'OTHERS';

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

2306: END IF;
2307: -- Loop through the error_tbl to find the error with the highest severity
2308: -- and return it.
2309: x_return_status := find_highest_exception(px_error_tbl);
2310: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2311: EXCEPTION
2312: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2313: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2314: (

Line 2312: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2308: -- and return it.
2309: x_return_status := find_highest_exception(px_error_tbl);
2310: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2311: EXCEPTION
2312: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2313: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2314: (
2315: l_api_name,
2316: G_PKG_NAME,

Line 2313: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2309: x_return_status := find_highest_exception(px_error_tbl);
2310: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2311: EXCEPTION
2312: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2313: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2314: (
2315: l_api_name,
2316: G_PKG_NAME,
2317: 'OKC_API.G_RET_STS_ERROR',

Line 2317: 'OKC_API.G_RET_STS_ERROR',

2313: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2314: (
2315: l_api_name,
2316: G_PKG_NAME,
2317: 'OKC_API.G_RET_STS_ERROR',
2318: x_msg_count,
2319: x_msg_data,
2320: '_PVT'
2321: );

Line 2322: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2318: x_msg_count,
2319: x_msg_data,
2320: '_PVT'
2321: );
2322: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2323: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2324: (
2325: l_api_name,
2326: G_PKG_NAME,

Line 2323: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2319: x_msg_data,
2320: '_PVT'
2321: );
2322: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2323: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2324: (
2325: l_api_name,
2326: G_PKG_NAME,
2327: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2327: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2323: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2324: (
2325: l_api_name,
2326: G_PKG_NAME,
2327: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2328: x_msg_count,
2329: x_msg_data,
2330: '_PVT'
2331: );

Line 2333: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2329: x_msg_data,
2330: '_PVT'
2331: );
2332: WHEN OTHERS THEN
2333: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2334: (
2335: l_api_name,
2336: G_PKG_NAME,
2337: 'OTHERS',

Line 2349: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2345: -- PL/SQL TBL update_row for:potv_TBL --
2346: ----------------------------------------
2347: PROCEDURE update_row(
2348: p_api_version IN NUMBER,
2349: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2350: x_return_status OUT NOCOPY VARCHAR2,
2351: x_msg_count OUT NOCOPY NUMBER,
2352: x_msg_data OUT NOCOPY VARCHAR2,
2353: p_potv_tbl IN potv_tbl_type,

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

2354: x_potv_tbl OUT NOCOPY potv_tbl_type) IS
2355:
2356: l_api_version CONSTANT NUMBER := 1;
2357: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2358: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2359: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2360: BEGIN
2361: OKC_API.init_msg_list(p_init_msg_list);
2362: -- Make sure PL/SQL table has records in it before passing

Line 2359: l_error_tbl OKC_API.ERROR_TBL_TYPE;

2355:
2356: l_api_version CONSTANT NUMBER := 1;
2357: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2358: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2359: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2360: BEGIN
2361: OKC_API.init_msg_list(p_init_msg_list);
2362: -- Make sure PL/SQL table has records in it before passing
2363: IF (p_potv_tbl.COUNT > 0) THEN

Line 2361: OKC_API.init_msg_list(p_init_msg_list);

2357: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2358: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2359: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2360: BEGIN
2361: OKC_API.init_msg_list(p_init_msg_list);
2362: -- Make sure PL/SQL table has records in it before passing
2363: IF (p_potv_tbl.COUNT > 0) THEN
2364: update_row (
2365: p_api_version => p_api_version,

Line 2366: p_init_msg_list => OKC_API.G_FALSE,

2362: -- Make sure PL/SQL table has records in it before passing
2363: IF (p_potv_tbl.COUNT > 0) THEN
2364: update_row (
2365: p_api_version => p_api_version,
2366: p_init_msg_list => OKC_API.G_FALSE,
2367: x_return_status => x_return_status,
2368: x_msg_count => x_msg_count,
2369: x_msg_data => x_msg_data,
2370: p_potv_tbl => p_potv_tbl,

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

2370: p_potv_tbl => p_potv_tbl,
2371: x_potv_tbl => x_potv_tbl,
2372: px_error_tbl => l_error_tbl);
2373: END IF;
2374: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2375: EXCEPTION
2376: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2377: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2378: (

Line 2376: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2372: px_error_tbl => l_error_tbl);
2373: END IF;
2374: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2375: EXCEPTION
2376: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2377: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2378: (
2379: l_api_name,
2380: G_PKG_NAME,

Line 2377: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2373: END IF;
2374: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2375: EXCEPTION
2376: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2377: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2378: (
2379: l_api_name,
2380: G_PKG_NAME,
2381: 'OKC_API.G_RET_STS_ERROR',

Line 2381: 'OKC_API.G_RET_STS_ERROR',

2377: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2378: (
2379: l_api_name,
2380: G_PKG_NAME,
2381: 'OKC_API.G_RET_STS_ERROR',
2382: x_msg_count,
2383: x_msg_data,
2384: '_PVT'
2385: );

Line 2386: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2382: x_msg_count,
2383: x_msg_data,
2384: '_PVT'
2385: );
2386: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2387: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2388: (
2389: l_api_name,
2390: G_PKG_NAME,

Line 2387: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2383: x_msg_data,
2384: '_PVT'
2385: );
2386: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2387: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2388: (
2389: l_api_name,
2390: G_PKG_NAME,
2391: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2391: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2387: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2388: (
2389: l_api_name,
2390: G_PKG_NAME,
2391: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2392: x_msg_count,
2393: x_msg_data,
2394: '_PVT'
2395: );

Line 2397: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 2415: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2411: ----------------------------------------
2412: -- delete_row for:okl_pool_types --
2413: ----------------------------------------
2414: PROCEDURE delete_row(
2415: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2416: x_return_status OUT NOCOPY VARCHAR2,
2417: x_msg_count OUT NOCOPY NUMBER,
2418: x_msg_data OUT NOCOPY VARCHAR2,
2419: p_pot_rec IN pot_rec_type) IS

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

2419: p_pot_rec IN pot_rec_type) IS
2420:
2421: l_api_version CONSTANT NUMBER := 1;
2422: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2423: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2424: l_pot_rec pot_rec_type := p_pot_rec;
2425: l_row_notfound BOOLEAN := TRUE;
2426: BEGIN
2427: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2423: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2424: l_pot_rec pot_rec_type := p_pot_rec;
2425: l_row_notfound BOOLEAN := TRUE;
2426: BEGIN
2427: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2428: p_init_msg_list,
2429: '_PVT',
2430: x_return_status);
2431: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

2427: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2428: p_init_msg_list,
2429: '_PVT',
2430: x_return_status);
2431: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2432: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2433: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2434: RAISE OKC_API.G_EXCEPTION_ERROR;
2435: END IF;

Line 2432: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2428: p_init_msg_list,
2429: '_PVT',
2430: x_return_status);
2431: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2432: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2433: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2434: RAISE OKC_API.G_EXCEPTION_ERROR;
2435: END IF;
2436:

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

2429: '_PVT',
2430: x_return_status);
2431: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2432: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2433: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2434: RAISE OKC_API.G_EXCEPTION_ERROR;
2435: END IF;
2436:
2437: DELETE FROM okl_pool_types

Line 2434: RAISE OKC_API.G_EXCEPTION_ERROR;

2430: x_return_status);
2431: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2432: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2433: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2434: RAISE OKC_API.G_EXCEPTION_ERROR;
2435: END IF;
2436:
2437: DELETE FROM okl_pool_types
2438: WHERE ID = p_pot_rec.id;

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

2437: DELETE FROM okl_pool_types
2438: WHERE ID = p_pot_rec.id;
2439:
2440: x_return_status := l_return_status;
2441: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2442: EXCEPTION
2443: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2444: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2445: (

Line 2443: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2439:
2440: x_return_status := l_return_status;
2441: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2442: EXCEPTION
2443: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2444: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2445: (
2446: l_api_name,
2447: G_PKG_NAME,

Line 2444: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2440: x_return_status := l_return_status;
2441: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2442: EXCEPTION
2443: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2444: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2445: (
2446: l_api_name,
2447: G_PKG_NAME,
2448: 'OKC_API.G_RET_STS_ERROR',

Line 2448: 'OKC_API.G_RET_STS_ERROR',

2444: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2445: (
2446: l_api_name,
2447: G_PKG_NAME,
2448: 'OKC_API.G_RET_STS_ERROR',
2449: x_msg_count,
2450: x_msg_data,
2451: '_PVT'
2452: );

Line 2453: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2449: x_msg_count,
2450: x_msg_data,
2451: '_PVT'
2452: );
2453: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2454: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2455: (
2456: l_api_name,
2457: G_PKG_NAME,

Line 2454: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2450: x_msg_data,
2451: '_PVT'
2452: );
2453: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2454: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2455: (
2456: l_api_name,
2457: G_PKG_NAME,
2458: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2458: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2454: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2455: (
2456: l_api_name,
2457: G_PKG_NAME,
2458: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2459: x_msg_count,
2460: x_msg_data,
2461: '_PVT'
2462: );

Line 2464: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2460: x_msg_data,
2461: '_PVT'
2462: );
2463: WHEN OTHERS THEN
2464: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2465: (
2466: l_api_name,
2467: G_PKG_NAME,
2468: 'OTHERS',

Line 2479: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2475: -- delete_row for:OKL_POOL_TYPES_V --
2476: ------------------------------------------
2477: PROCEDURE delete_row(
2478: p_api_version IN NUMBER,
2479: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2480: x_return_status OUT NOCOPY VARCHAR2,
2481: x_msg_count OUT NOCOPY NUMBER,
2482: x_msg_data OUT NOCOPY VARCHAR2,
2483: p_potv_rec IN potv_rec_type) IS

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

2483: p_potv_rec IN potv_rec_type) IS
2484:
2485: l_api_version CONSTANT NUMBER := 1;
2486: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2487: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2488: l_potv_rec potv_rec_type := p_potv_rec;
2489: l_pot_rec pot_rec_type;
2490: BEGIN
2491: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2487: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2488: l_potv_rec potv_rec_type := p_potv_rec;
2489: l_pot_rec pot_rec_type;
2490: BEGIN
2491: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2492: G_PKG_NAME,
2493: p_init_msg_list,
2494: l_api_version,
2495: p_api_version,

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

2494: l_api_version,
2495: p_api_version,
2496: '_PVT',
2497: x_return_status);
2498: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2499: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2500: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2501: RAISE OKC_API.G_EXCEPTION_ERROR;
2502: END IF;

Line 2499: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2495: p_api_version,
2496: '_PVT',
2497: x_return_status);
2498: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2499: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2500: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2501: RAISE OKC_API.G_EXCEPTION_ERROR;
2502: END IF;
2503: -----------------------------------------

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

2496: '_PVT',
2497: x_return_status);
2498: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2499: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2500: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2501: RAISE OKC_API.G_EXCEPTION_ERROR;
2502: END IF;
2503: -----------------------------------------
2504: -- Move VIEW record to "Child" records --

Line 2501: RAISE OKC_API.G_EXCEPTION_ERROR;

2497: x_return_status);
2498: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2499: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2500: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2501: RAISE OKC_API.G_EXCEPTION_ERROR;
2502: END IF;
2503: -----------------------------------------
2504: -- Move VIEW record to "Child" records --
2505: -----------------------------------------

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

2513: x_msg_count,
2514: x_msg_data,
2515: l_pot_rec
2516: );
2517: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2519: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2520: RAISE OKC_API.G_EXCEPTION_ERROR;
2521: END IF;

Line 2518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2514: x_msg_data,
2515: l_pot_rec
2516: );
2517: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2519: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2520: RAISE OKC_API.G_EXCEPTION_ERROR;
2521: END IF;
2522: x_return_status := l_return_status;

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

2515: l_pot_rec
2516: );
2517: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2519: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2520: RAISE OKC_API.G_EXCEPTION_ERROR;
2521: END IF;
2522: x_return_status := l_return_status;
2523: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2520: RAISE OKC_API.G_EXCEPTION_ERROR;

2516: );
2517: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2518: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2519: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2520: RAISE OKC_API.G_EXCEPTION_ERROR;
2521: END IF;
2522: x_return_status := l_return_status;
2523: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2524: EXCEPTION

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

2519: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2520: RAISE OKC_API.G_EXCEPTION_ERROR;
2521: END IF;
2522: x_return_status := l_return_status;
2523: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2524: EXCEPTION
2525: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2526: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2527: (

Line 2525: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2521: END IF;
2522: x_return_status := l_return_status;
2523: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2524: EXCEPTION
2525: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2526: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2527: (
2528: l_api_name,
2529: G_PKG_NAME,

Line 2526: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2522: x_return_status := l_return_status;
2523: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2524: EXCEPTION
2525: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2526: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2527: (
2528: l_api_name,
2529: G_PKG_NAME,
2530: 'OKC_API.G_RET_STS_ERROR',

Line 2530: 'OKC_API.G_RET_STS_ERROR',

2526: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2527: (
2528: l_api_name,
2529: G_PKG_NAME,
2530: 'OKC_API.G_RET_STS_ERROR',
2531: x_msg_count,
2532: x_msg_data,
2533: '_PVT'
2534: );

Line 2535: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2531: x_msg_count,
2532: x_msg_data,
2533: '_PVT'
2534: );
2535: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2536: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2537: (
2538: l_api_name,
2539: G_PKG_NAME,

Line 2536: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2532: x_msg_data,
2533: '_PVT'
2534: );
2535: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2536: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2537: (
2538: l_api_name,
2539: G_PKG_NAME,
2540: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2540: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2536: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2537: (
2538: l_api_name,
2539: G_PKG_NAME,
2540: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2541: x_msg_count,
2542: x_msg_data,
2543: '_PVT'
2544: );

Line 2546: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2542: x_msg_data,
2543: '_PVT'
2544: );
2545: WHEN OTHERS THEN
2546: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2547: (
2548: l_api_name,
2549: G_PKG_NAME,
2550: 'OTHERS',

Line 2561: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2557: -- PL/SQL TBL delete_row for:OKL_POOL_TYPES_V --
2558: -----------------------------------------------------
2559: PROCEDURE delete_row(
2560: p_api_version IN NUMBER,
2561: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2562: x_return_status OUT NOCOPY VARCHAR2,
2563: x_msg_count OUT NOCOPY NUMBER,
2564: x_msg_data OUT NOCOPY VARCHAR2,
2565: p_potv_tbl IN potv_tbl_type,

Line 2566: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

2562: x_return_status OUT NOCOPY VARCHAR2,
2563: x_msg_count OUT NOCOPY NUMBER,
2564: x_msg_data OUT NOCOPY VARCHAR2,
2565: p_potv_tbl IN potv_tbl_type,
2566: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2567:
2568: l_api_version CONSTANT NUMBER := 1;
2569: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2570: i NUMBER := 0;

Line 2572: OKC_API.init_msg_list(p_init_msg_list);

2568: l_api_version CONSTANT NUMBER := 1;
2569: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2570: i NUMBER := 0;
2571: BEGIN
2572: OKC_API.init_msg_list(p_init_msg_list);
2573: -- Make sure PL/SQL table has records in it before passing
2574: IF (p_potv_tbl.COUNT > 0) THEN
2575: i := p_potv_tbl.FIRST;
2576: LOOP

Line 2578: l_error_rec OKC_API.ERROR_REC_TYPE;

2574: IF (p_potv_tbl.COUNT > 0) THEN
2575: i := p_potv_tbl.FIRST;
2576: LOOP
2577: DECLARE
2578: l_error_rec OKC_API.ERROR_REC_TYPE;
2579: BEGIN
2580: l_error_rec.api_name := l_api_name;
2581: l_error_rec.api_package := G_PKG_NAME;
2582: l_error_rec.idx := i;

Line 2585: p_init_msg_list => OKC_API.G_FALSE,

2581: l_error_rec.api_package := G_PKG_NAME;
2582: l_error_rec.idx := i;
2583: delete_row (
2584: p_api_version => p_api_version,
2585: p_init_msg_list => OKC_API.G_FALSE,
2586: x_return_status => l_error_rec.error_type,
2587: x_msg_count => l_error_rec.msg_count,
2588: x_msg_data => l_error_rec.msg_data,
2589: p_potv_rec => p_potv_tbl(i));

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

2586: x_return_status => l_error_rec.error_type,
2587: x_msg_count => l_error_rec.msg_count,
2588: x_msg_data => l_error_rec.msg_data,
2589: p_potv_rec => p_potv_tbl(i));
2590: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2591: l_error_rec.SQLCODE := SQLCODE;
2592: load_error_tbl(l_error_rec, px_error_tbl);
2593: ELSE
2594: x_msg_count := l_error_rec.msg_count;

Line 2598: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2594: x_msg_count := l_error_rec.msg_count;
2595: x_msg_data := l_error_rec.msg_data;
2596: END IF;
2597: EXCEPTION
2598: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2599: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2600: l_error_rec.SQLCODE := SQLCODE;
2601: load_error_tbl(l_error_rec, px_error_tbl);
2602: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

2595: x_msg_data := l_error_rec.msg_data;
2596: END IF;
2597: EXCEPTION
2598: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2599: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2600: l_error_rec.SQLCODE := SQLCODE;
2601: load_error_tbl(l_error_rec, px_error_tbl);
2602: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2603: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2602: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2598: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2599: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2600: l_error_rec.SQLCODE := SQLCODE;
2601: load_error_tbl(l_error_rec, px_error_tbl);
2602: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2603: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
2604: l_error_rec.SQLCODE := SQLCODE;
2605: load_error_tbl(l_error_rec, px_error_tbl);
2606: WHEN OTHERS THEN

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

2599: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2600: l_error_rec.SQLCODE := SQLCODE;
2601: load_error_tbl(l_error_rec, px_error_tbl);
2602: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2603: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
2604: l_error_rec.SQLCODE := SQLCODE;
2605: load_error_tbl(l_error_rec, px_error_tbl);
2606: WHEN OTHERS THEN
2607: l_error_rec.error_type := 'OTHERS';

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

2614: END IF;
2615: -- Loop through the error_tbl to find the error with the highest severity
2616: -- and return it.
2617: x_return_status := find_highest_exception(px_error_tbl);
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: -- and return it.
2617: x_return_status := find_highest_exception(px_error_tbl);
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 := find_highest_exception(px_error_tbl);
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 2657: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2653: -- PL/SQL TBL delete_row for:OKL_POOL_TYPES_V --
2654: -----------------------------------------------------
2655: PROCEDURE delete_row(
2656: p_api_version IN NUMBER,
2657: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2658: x_return_status OUT NOCOPY VARCHAR2,
2659: x_msg_count OUT NOCOPY NUMBER,
2660: x_msg_data OUT NOCOPY VARCHAR2,
2661: p_potv_tbl IN potv_tbl_type) IS

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

2661: p_potv_tbl IN potv_tbl_type) IS
2662:
2663: l_api_version CONSTANT NUMBER := 1;
2664: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2665: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2666: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2667: BEGIN
2668: OKC_API.init_msg_list(p_init_msg_list);
2669: -- Make sure PL/SQL table has records in it before passing

Line 2666: l_error_tbl OKC_API.ERROR_TBL_TYPE;

2662:
2663: l_api_version CONSTANT NUMBER := 1;
2664: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2665: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2666: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2667: BEGIN
2668: OKC_API.init_msg_list(p_init_msg_list);
2669: -- Make sure PL/SQL table has records in it before passing
2670: IF (p_potv_tbl.COUNT > 0) THEN

Line 2668: OKC_API.init_msg_list(p_init_msg_list);

2664: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2665: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2666: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2667: BEGIN
2668: OKC_API.init_msg_list(p_init_msg_list);
2669: -- Make sure PL/SQL table has records in it before passing
2670: IF (p_potv_tbl.COUNT > 0) THEN
2671: delete_row (
2672: p_api_version => p_api_version,

Line 2673: p_init_msg_list => OKC_API.G_FALSE,

2669: -- Make sure PL/SQL table has records in it before passing
2670: IF (p_potv_tbl.COUNT > 0) THEN
2671: delete_row (
2672: p_api_version => p_api_version,
2673: p_init_msg_list => OKC_API.G_FALSE,
2674: x_return_status => x_return_status,
2675: x_msg_count => x_msg_count,
2676: x_msg_data => x_msg_data,
2677: p_potv_tbl => p_potv_tbl,

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

2676: x_msg_data => x_msg_data,
2677: p_potv_tbl => p_potv_tbl,
2678: px_error_tbl => l_error_tbl);
2679: END IF;
2680: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2681: EXCEPTION
2682: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2683: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2684: (

Line 2682: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2678: px_error_tbl => l_error_tbl);
2679: END IF;
2680: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2681: EXCEPTION
2682: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2683: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2684: (
2685: l_api_name,
2686: G_PKG_NAME,

Line 2683: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2679: END IF;
2680: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2681: EXCEPTION
2682: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2683: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2684: (
2685: l_api_name,
2686: G_PKG_NAME,
2687: 'OKC_API.G_RET_STS_ERROR',

Line 2687: 'OKC_API.G_RET_STS_ERROR',

2683: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2684: (
2685: l_api_name,
2686: G_PKG_NAME,
2687: 'OKC_API.G_RET_STS_ERROR',
2688: x_msg_count,
2689: x_msg_data,
2690: '_PVT'
2691: );

Line 2692: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2688: x_msg_count,
2689: x_msg_data,
2690: '_PVT'
2691: );
2692: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2693: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2694: (
2695: l_api_name,
2696: G_PKG_NAME,

Line 2693: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2689: x_msg_data,
2690: '_PVT'
2691: );
2692: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2693: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2694: (
2695: l_api_name,
2696: G_PKG_NAME,
2697: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2697: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2693: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2694: (
2695: l_api_name,
2696: G_PKG_NAME,
2697: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2698: x_msg_count,
2699: x_msg_data,
2700: '_PVT'
2701: );

Line 2703: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2699: x_msg_data,
2700: '_PVT'
2701: );
2702: WHEN OTHERS THEN
2703: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2704: (
2705: l_api_name,
2706: G_PKG_NAME,
2707: 'OTHERS',