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_CRA_PVT dependencies on OKL_API

Line 7: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,

3: ---------------------------------------------------------------------------
4: -- PROCEDURE load_error_tbl
5: ---------------------------------------------------------------------------
6: PROCEDURE load_error_tbl (
7: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,
8: px_error_tbl IN OUT NOCOPY OKL_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 OKL_API.ERROR_TBL_TYPE) IS

4: -- PROCEDURE load_error_tbl
5: ---------------------------------------------------------------------------
6: PROCEDURE load_error_tbl (
7: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,
8: px_error_tbl IN OUT NOCOPY OKL_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 OKL_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 OKL_API.ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN OKL_API.ERROR_TBL_TYPE
43: ) RETURN VARCHAR2 IS
44: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 42: p_error_tbl IN OKL_API.ERROR_TBL_TYPE

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

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

40: -- in a OKL_API.ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN OKL_API.ERROR_TBL_TYPE
43: ) RETURN VARCHAR2 IS
44: l_return_status VARCHAR2(1) := OKL_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 <> OKL_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 <> OKL_API.G_RET_STS_SUCCESS) THEN
51: IF (l_return_status <> OKL_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 <> OKL_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 <> OKL_API.G_RET_STS_SUCCESS) THEN
51: IF (l_return_status <> OKL_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 206: x_return_status := OKL_API.G_RET_STS_SUCCESS;

202: ) RETURN crav_rec_type IS
203: l_crav_rec crav_rec_type;
204: l_row_notfound BOOLEAN := TRUE;
205: BEGIN
206: x_return_status := OKL_API.G_RET_STS_SUCCESS;
207: l_crav_rec := get_rec(p_crav_rec, l_row_notfound);
208: IF (l_row_notfound) THEN
209: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REPORT_AMOUNT_ID');
210: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 209: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REPORT_AMOUNT_ID');

205: BEGIN
206: x_return_status := OKL_API.G_RET_STS_SUCCESS;
207: l_crav_rec := get_rec(p_crav_rec, l_row_notfound);
208: IF (l_row_notfound) THEN
209: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REPORT_AMOUNT_ID');
210: x_return_status := OKL_API.G_RET_STS_ERROR;
211: END IF;
212: RETURN(l_crav_rec);
213: END get_rec;

Line 210: x_return_status := OKL_API.G_RET_STS_ERROR;

206: x_return_status := OKL_API.G_RET_STS_SUCCESS;
207: l_crav_rec := get_rec(p_crav_rec, l_row_notfound);
208: IF (l_row_notfound) THEN
209: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REPORT_AMOUNT_ID');
210: x_return_status := OKL_API.G_RET_STS_ERROR;
211: END IF;
212: RETURN(l_crav_rec);
213: END get_rec;
214: -----------------------------------------------------------

Line 337: x_return_status := OKL_API.G_RET_STS_SUCCESS;

333: ) RETURN cra_rec_type IS
334: l_cra_rec cra_rec_type;
335: l_row_notfound BOOLEAN := TRUE;
336: BEGIN
337: x_return_status := OKL_API.G_RET_STS_SUCCESS;
338: l_cra_rec := get_rec(p_cra_rec, l_row_notfound);
339: IF (l_row_notfound) THEN
340: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REPORT_AMOUNT_ID');
341: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 340: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REPORT_AMOUNT_ID');

336: BEGIN
337: x_return_status := OKL_API.G_RET_STS_SUCCESS;
338: l_cra_rec := get_rec(p_cra_rec, l_row_notfound);
339: IF (l_row_notfound) THEN
340: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REPORT_AMOUNT_ID');
341: x_return_status := OKL_API.G_RET_STS_ERROR;
342: END IF;
343: RETURN(l_cra_rec);
344: END get_rec;

Line 341: x_return_status := OKL_API.G_RET_STS_ERROR;

337: x_return_status := OKL_API.G_RET_STS_SUCCESS;
338: l_cra_rec := get_rec(p_cra_rec, l_row_notfound);
339: IF (l_row_notfound) THEN
340: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REPORT_AMOUNT_ID');
341: x_return_status := OKL_API.G_RET_STS_ERROR;
342: END IF;
343: RETURN(l_cra_rec);
344: END get_rec;
345: -----------------------------------------------------------

Line 363: IF (l_crav_rec.cure_report_amount_id = OKL_API.G_MISS_NUM ) THEN

359: p_crav_rec IN crav_rec_type
360: ) RETURN crav_rec_type IS
361: l_crav_rec crav_rec_type := p_crav_rec;
362: BEGIN
363: IF (l_crav_rec.cure_report_amount_id = OKL_API.G_MISS_NUM ) THEN
364: l_crav_rec.cure_report_amount_id := NULL;
365: END IF;
366: IF (l_crav_rec.cure_amount_id = OKL_API.G_MISS_NUM ) THEN
367: l_crav_rec.cure_amount_id := NULL;

Line 366: IF (l_crav_rec.cure_amount_id = OKL_API.G_MISS_NUM ) THEN

362: BEGIN
363: IF (l_crav_rec.cure_report_amount_id = OKL_API.G_MISS_NUM ) THEN
364: l_crav_rec.cure_report_amount_id := NULL;
365: END IF;
366: IF (l_crav_rec.cure_amount_id = OKL_API.G_MISS_NUM ) THEN
367: l_crav_rec.cure_amount_id := NULL;
368: END IF;
369: IF (l_crav_rec.cure_report_id = OKL_API.G_MISS_NUM ) THEN
370: l_crav_rec.cure_report_id := NULL;

Line 369: IF (l_crav_rec.cure_report_id = OKL_API.G_MISS_NUM ) THEN

365: END IF;
366: IF (l_crav_rec.cure_amount_id = OKL_API.G_MISS_NUM ) THEN
367: l_crav_rec.cure_amount_id := NULL;
368: END IF;
369: IF (l_crav_rec.cure_report_id = OKL_API.G_MISS_NUM ) THEN
370: l_crav_rec.cure_report_id := NULL;
371: END IF;
372: IF (l_crav_rec.request_type = OKL_API.G_MISS_CHAR ) THEN
373: l_crav_rec.request_type := NULL;

Line 372: IF (l_crav_rec.request_type = OKL_API.G_MISS_CHAR ) THEN

368: END IF;
369: IF (l_crav_rec.cure_report_id = OKL_API.G_MISS_NUM ) THEN
370: l_crav_rec.cure_report_id := NULL;
371: END IF;
372: IF (l_crav_rec.request_type = OKL_API.G_MISS_CHAR ) THEN
373: l_crav_rec.request_type := NULL;
374: END IF;
375: IF (l_crav_rec.cures_in_possession = OKL_API.G_MISS_NUM ) THEN
376: l_crav_rec.cures_in_possession := NULL;

Line 375: IF (l_crav_rec.cures_in_possession = OKL_API.G_MISS_NUM ) THEN

371: END IF;
372: IF (l_crav_rec.request_type = OKL_API.G_MISS_CHAR ) THEN
373: l_crav_rec.request_type := NULL;
374: END IF;
375: IF (l_crav_rec.cures_in_possession = OKL_API.G_MISS_NUM ) THEN
376: l_crav_rec.cures_in_possession := NULL;
377: END IF;
378: IF (l_crav_rec.claimed_cure_amount = OKL_API.G_MISS_NUM ) THEN
379: l_crav_rec.claimed_cure_amount := NULL;

Line 378: IF (l_crav_rec.claimed_cure_amount = OKL_API.G_MISS_NUM ) THEN

374: END IF;
375: IF (l_crav_rec.cures_in_possession = OKL_API.G_MISS_NUM ) THEN
376: l_crav_rec.cures_in_possession := NULL;
377: END IF;
378: IF (l_crav_rec.claimed_cure_amount = OKL_API.G_MISS_NUM ) THEN
379: l_crav_rec.claimed_cure_amount := NULL;
380: END IF;
381: IF (l_crav_rec.past_due_amount = OKL_API.G_MISS_NUM ) THEN
382: l_crav_rec.past_due_amount := NULL;

Line 381: IF (l_crav_rec.past_due_amount = OKL_API.G_MISS_NUM ) THEN

377: END IF;
378: IF (l_crav_rec.claimed_cure_amount = OKL_API.G_MISS_NUM ) THEN
379: l_crav_rec.claimed_cure_amount := NULL;
380: END IF;
381: IF (l_crav_rec.past_due_amount = OKL_API.G_MISS_NUM ) THEN
382: l_crav_rec.past_due_amount := NULL;
383: END IF;
384: IF (l_crav_rec.eligible_cure_amount = OKL_API.G_MISS_NUM ) THEN
385: l_crav_rec.eligible_cure_amount := NULL;

Line 384: IF (l_crav_rec.eligible_cure_amount = OKL_API.G_MISS_NUM ) THEN

380: END IF;
381: IF (l_crav_rec.past_due_amount = OKL_API.G_MISS_NUM ) THEN
382: l_crav_rec.past_due_amount := NULL;
383: END IF;
384: IF (l_crav_rec.eligible_cure_amount = OKL_API.G_MISS_NUM ) THEN
385: l_crav_rec.eligible_cure_amount := NULL;
386: END IF;
387: IF (l_crav_rec.repurchase_amount = OKL_API.G_MISS_NUM ) THEN
388: l_crav_rec.repurchase_amount := NULL;

Line 387: IF (l_crav_rec.repurchase_amount = OKL_API.G_MISS_NUM ) THEN

383: END IF;
384: IF (l_crav_rec.eligible_cure_amount = OKL_API.G_MISS_NUM ) THEN
385: l_crav_rec.eligible_cure_amount := NULL;
386: END IF;
387: IF (l_crav_rec.repurchase_amount = OKL_API.G_MISS_NUM ) THEN
388: l_crav_rec.repurchase_amount := NULL;
389: END IF;
390: IF (l_crav_rec.outstanding_amount = OKL_API.G_MISS_NUM ) THEN
391: l_crav_rec.outstanding_amount := NULL;

Line 390: IF (l_crav_rec.outstanding_amount = OKL_API.G_MISS_NUM ) THEN

386: END IF;
387: IF (l_crav_rec.repurchase_amount = OKL_API.G_MISS_NUM ) THEN
388: l_crav_rec.repurchase_amount := NULL;
389: END IF;
390: IF (l_crav_rec.outstanding_amount = OKL_API.G_MISS_NUM ) THEN
391: l_crav_rec.outstanding_amount := NULL;
392: END IF;
393: IF (l_crav_rec.times_cured = OKL_API.G_MISS_NUM ) THEN
394: l_crav_rec.times_cured := NULL;

Line 393: IF (l_crav_rec.times_cured = OKL_API.G_MISS_NUM ) THEN

389: END IF;
390: IF (l_crav_rec.outstanding_amount = OKL_API.G_MISS_NUM ) THEN
391: l_crav_rec.outstanding_amount := NULL;
392: END IF;
393: IF (l_crav_rec.times_cured = OKL_API.G_MISS_NUM ) THEN
394: l_crav_rec.times_cured := NULL;
395: END IF;
396: IF (l_crav_rec.payments_remaining = OKL_API.G_MISS_NUM ) THEN
397: l_crav_rec.payments_remaining := NULL;

Line 396: IF (l_crav_rec.payments_remaining = OKL_API.G_MISS_NUM ) THEN

392: END IF;
393: IF (l_crav_rec.times_cured = OKL_API.G_MISS_NUM ) THEN
394: l_crav_rec.times_cured := NULL;
395: END IF;
396: IF (l_crav_rec.payments_remaining = OKL_API.G_MISS_NUM ) THEN
397: l_crav_rec.payments_remaining := NULL;
398: END IF;
399: IF (l_crav_rec.status = OKL_API.G_MISS_CHAR ) THEN
400: l_crav_rec.status := NULL;

Line 399: IF (l_crav_rec.status = OKL_API.G_MISS_CHAR ) THEN

395: END IF;
396: IF (l_crav_rec.payments_remaining = OKL_API.G_MISS_NUM ) THEN
397: l_crav_rec.payments_remaining := NULL;
398: END IF;
399: IF (l_crav_rec.status = OKL_API.G_MISS_CHAR ) THEN
400: l_crav_rec.status := NULL;
401: END IF;
402: IF (l_crav_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
403: l_crav_rec.object_version_number := NULL;

Line 402: IF (l_crav_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN

398: END IF;
399: IF (l_crav_rec.status = OKL_API.G_MISS_CHAR ) THEN
400: l_crav_rec.status := NULL;
401: END IF;
402: IF (l_crav_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
403: l_crav_rec.object_version_number := NULL;
404: END IF;
405: IF (l_crav_rec.org_id = OKL_API.G_MISS_NUM ) THEN
406: l_crav_rec.org_id := NULL;

Line 405: IF (l_crav_rec.org_id = OKL_API.G_MISS_NUM ) THEN

401: END IF;
402: IF (l_crav_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
403: l_crav_rec.object_version_number := NULL;
404: END IF;
405: IF (l_crav_rec.org_id = OKL_API.G_MISS_NUM ) THEN
406: l_crav_rec.org_id := NULL;
407: END IF;
408: IF (l_crav_rec.request_id = OKL_API.G_MISS_NUM ) THEN
409: l_crav_rec.request_id := NULL;

Line 408: IF (l_crav_rec.request_id = OKL_API.G_MISS_NUM ) THEN

404: END IF;
405: IF (l_crav_rec.org_id = OKL_API.G_MISS_NUM ) THEN
406: l_crav_rec.org_id := NULL;
407: END IF;
408: IF (l_crav_rec.request_id = OKL_API.G_MISS_NUM ) THEN
409: l_crav_rec.request_id := NULL;
410: END IF;
411: IF (l_crav_rec.program_application_id = OKL_API.G_MISS_NUM ) THEN
412: l_crav_rec.program_application_id := NULL;

Line 411: IF (l_crav_rec.program_application_id = OKL_API.G_MISS_NUM ) THEN

407: END IF;
408: IF (l_crav_rec.request_id = OKL_API.G_MISS_NUM ) THEN
409: l_crav_rec.request_id := NULL;
410: END IF;
411: IF (l_crav_rec.program_application_id = OKL_API.G_MISS_NUM ) THEN
412: l_crav_rec.program_application_id := NULL;
413: END IF;
414: IF (l_crav_rec.program_id = OKL_API.G_MISS_NUM ) THEN
415: l_crav_rec.program_id := NULL;

Line 414: IF (l_crav_rec.program_id = OKL_API.G_MISS_NUM ) THEN

410: END IF;
411: IF (l_crav_rec.program_application_id = OKL_API.G_MISS_NUM ) THEN
412: l_crav_rec.program_application_id := NULL;
413: END IF;
414: IF (l_crav_rec.program_id = OKL_API.G_MISS_NUM ) THEN
415: l_crav_rec.program_id := NULL;
416: END IF;
417: IF (l_crav_rec.program_update_date = OKL_API.G_MISS_DATE ) THEN
418: l_crav_rec.program_update_date := NULL;

Line 417: IF (l_crav_rec.program_update_date = OKL_API.G_MISS_DATE ) THEN

413: END IF;
414: IF (l_crav_rec.program_id = OKL_API.G_MISS_NUM ) THEN
415: l_crav_rec.program_id := NULL;
416: END IF;
417: IF (l_crav_rec.program_update_date = OKL_API.G_MISS_DATE ) THEN
418: l_crav_rec.program_update_date := NULL;
419: END IF;
420: IF (l_crav_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
421: l_crav_rec.attribute_category := NULL;

Line 420: IF (l_crav_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN

416: END IF;
417: IF (l_crav_rec.program_update_date = OKL_API.G_MISS_DATE ) THEN
418: l_crav_rec.program_update_date := NULL;
419: END IF;
420: IF (l_crav_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
421: l_crav_rec.attribute_category := NULL;
422: END IF;
423: IF (l_crav_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
424: l_crav_rec.attribute1 := NULL;

Line 423: IF (l_crav_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN

419: END IF;
420: IF (l_crav_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
421: l_crav_rec.attribute_category := NULL;
422: END IF;
423: IF (l_crav_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
424: l_crav_rec.attribute1 := NULL;
425: END IF;
426: IF (l_crav_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
427: l_crav_rec.attribute2 := NULL;

Line 426: IF (l_crav_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN

422: END IF;
423: IF (l_crav_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
424: l_crav_rec.attribute1 := NULL;
425: END IF;
426: IF (l_crav_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
427: l_crav_rec.attribute2 := NULL;
428: END IF;
429: IF (l_crav_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
430: l_crav_rec.attribute3 := NULL;

Line 429: IF (l_crav_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN

425: END IF;
426: IF (l_crav_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
427: l_crav_rec.attribute2 := NULL;
428: END IF;
429: IF (l_crav_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
430: l_crav_rec.attribute3 := NULL;
431: END IF;
432: IF (l_crav_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
433: l_crav_rec.attribute4 := NULL;

Line 432: IF (l_crav_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN

428: END IF;
429: IF (l_crav_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
430: l_crav_rec.attribute3 := NULL;
431: END IF;
432: IF (l_crav_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
433: l_crav_rec.attribute4 := NULL;
434: END IF;
435: IF (l_crav_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
436: l_crav_rec.attribute5 := NULL;

Line 435: IF (l_crav_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN

431: END IF;
432: IF (l_crav_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
433: l_crav_rec.attribute4 := NULL;
434: END IF;
435: IF (l_crav_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
436: l_crav_rec.attribute5 := NULL;
437: END IF;
438: IF (l_crav_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
439: l_crav_rec.attribute6 := NULL;

Line 438: IF (l_crav_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN

434: END IF;
435: IF (l_crav_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
436: l_crav_rec.attribute5 := NULL;
437: END IF;
438: IF (l_crav_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
439: l_crav_rec.attribute6 := NULL;
440: END IF;
441: IF (l_crav_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
442: l_crav_rec.attribute7 := NULL;

Line 441: IF (l_crav_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN

437: END IF;
438: IF (l_crav_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
439: l_crav_rec.attribute6 := NULL;
440: END IF;
441: IF (l_crav_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
442: l_crav_rec.attribute7 := NULL;
443: END IF;
444: IF (l_crav_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
445: l_crav_rec.attribute8 := NULL;

Line 444: IF (l_crav_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN

440: END IF;
441: IF (l_crav_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
442: l_crav_rec.attribute7 := NULL;
443: END IF;
444: IF (l_crav_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
445: l_crav_rec.attribute8 := NULL;
446: END IF;
447: IF (l_crav_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
448: l_crav_rec.attribute9 := NULL;

Line 447: IF (l_crav_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN

443: END IF;
444: IF (l_crav_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
445: l_crav_rec.attribute8 := NULL;
446: END IF;
447: IF (l_crav_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
448: l_crav_rec.attribute9 := NULL;
449: END IF;
450: IF (l_crav_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
451: l_crav_rec.attribute10 := NULL;

Line 450: IF (l_crav_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN

446: END IF;
447: IF (l_crav_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
448: l_crav_rec.attribute9 := NULL;
449: END IF;
450: IF (l_crav_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
451: l_crav_rec.attribute10 := NULL;
452: END IF;
453: IF (l_crav_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
454: l_crav_rec.attribute11 := NULL;

Line 453: IF (l_crav_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN

449: END IF;
450: IF (l_crav_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
451: l_crav_rec.attribute10 := NULL;
452: END IF;
453: IF (l_crav_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
454: l_crav_rec.attribute11 := NULL;
455: END IF;
456: IF (l_crav_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
457: l_crav_rec.attribute12 := NULL;

Line 456: IF (l_crav_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN

452: END IF;
453: IF (l_crav_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
454: l_crav_rec.attribute11 := NULL;
455: END IF;
456: IF (l_crav_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
457: l_crav_rec.attribute12 := NULL;
458: END IF;
459: IF (l_crav_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
460: l_crav_rec.attribute13 := NULL;

Line 459: IF (l_crav_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN

455: END IF;
456: IF (l_crav_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
457: l_crav_rec.attribute12 := NULL;
458: END IF;
459: IF (l_crav_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
460: l_crav_rec.attribute13 := NULL;
461: END IF;
462: IF (l_crav_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
463: l_crav_rec.attribute14 := NULL;

Line 462: IF (l_crav_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN

458: END IF;
459: IF (l_crav_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
460: l_crav_rec.attribute13 := NULL;
461: END IF;
462: IF (l_crav_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
463: l_crav_rec.attribute14 := NULL;
464: END IF;
465: IF (l_crav_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
466: l_crav_rec.attribute15 := NULL;

Line 465: IF (l_crav_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN

461: END IF;
462: IF (l_crav_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
463: l_crav_rec.attribute14 := NULL;
464: END IF;
465: IF (l_crav_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
466: l_crav_rec.attribute15 := NULL;
467: END IF;
468: IF (l_crav_rec.created_by = OKL_API.G_MISS_NUM ) THEN
469: l_crav_rec.created_by := NULL;

Line 468: IF (l_crav_rec.created_by = OKL_API.G_MISS_NUM ) THEN

464: END IF;
465: IF (l_crav_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
466: l_crav_rec.attribute15 := NULL;
467: END IF;
468: IF (l_crav_rec.created_by = OKL_API.G_MISS_NUM ) THEN
469: l_crav_rec.created_by := NULL;
470: END IF;
471: IF (l_crav_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
472: l_crav_rec.creation_date := NULL;

Line 471: IF (l_crav_rec.creation_date = OKL_API.G_MISS_DATE ) THEN

467: END IF;
468: IF (l_crav_rec.created_by = OKL_API.G_MISS_NUM ) THEN
469: l_crav_rec.created_by := NULL;
470: END IF;
471: IF (l_crav_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
472: l_crav_rec.creation_date := NULL;
473: END IF;
474: IF (l_crav_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
475: l_crav_rec.last_updated_by := NULL;

Line 474: IF (l_crav_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN

470: END IF;
471: IF (l_crav_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
472: l_crav_rec.creation_date := NULL;
473: END IF;
474: IF (l_crav_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
475: l_crav_rec.last_updated_by := NULL;
476: END IF;
477: IF (l_crav_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
478: l_crav_rec.last_update_date := NULL;

Line 477: IF (l_crav_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN

473: END IF;
474: IF (l_crav_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
475: l_crav_rec.last_updated_by := NULL;
476: END IF;
477: IF (l_crav_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
478: l_crav_rec.last_update_date := NULL;
479: END IF;
480: IF (l_crav_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
481: l_crav_rec.last_update_login := NULL;

Line 480: IF (l_crav_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN

476: END IF;
477: IF (l_crav_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
478: l_crav_rec.last_update_date := NULL;
479: END IF;
480: IF (l_crav_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
481: l_crav_rec.last_update_login := NULL;
482: END IF;
483: RETURN(l_crav_rec);
484: END null_out_defaults;

Line 491: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

487: ----------------------------------------------------
488: PROCEDURE validate_cure_report_amount_id(
489: x_return_status OUT NOCOPY VARCHAR2,
490: p_crav_rec IN crav_rec_type) IS
491: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
492:
493: BEGIN
494:
495: IF (p_crav_rec.cure_report_amount_id = OKL_API.G_MISS_NUM OR

Line 495: IF (p_crav_rec.cure_report_amount_id = OKL_API.G_MISS_NUM OR

491: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
492:
493: BEGIN
494:
495: IF (p_crav_rec.cure_report_amount_id = OKL_API.G_MISS_NUM OR
496: p_crav_rec.cure_report_amount_id IS NULL)
497: THEN
498: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_report_amount_id');
499: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 498: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_report_amount_id');

494:
495: IF (p_crav_rec.cure_report_amount_id = OKL_API.G_MISS_NUM OR
496: p_crav_rec.cure_report_amount_id IS NULL)
497: THEN
498: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_report_amount_id');
499: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
500: END IF;
501: x_return_status := l_return_status;
502: EXCEPTION

Line 499: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

495: IF (p_crav_rec.cure_report_amount_id = OKL_API.G_MISS_NUM OR
496: p_crav_rec.cure_report_amount_id IS NULL)
497: THEN
498: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_report_amount_id');
499: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
500: END IF;
501: x_return_status := l_return_status;
502: EXCEPTION
503: WHEN OTHERS THEN

Line 504: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

500: END IF;
501: x_return_status := l_return_status;
502: EXCEPTION
503: WHEN OTHERS THEN
504: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
505: ,p_msg_name => G_UNEXPECTED_ERROR
506: ,p_token1 => G_SQLCODE_TOKEN
507: ,p_token1_value => SQLCODE
508: ,p_token2 => G_SQLERRM_TOKEN

Line 510: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

506: ,p_token1 => G_SQLCODE_TOKEN
507: ,p_token1_value => SQLCODE
508: ,p_token2 => G_SQLERRM_TOKEN
509: ,p_token2_value => SQLERRM);
510: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
511: END validate_cure_report_amount_id;
512:
513: ---------------------------------------------
514: -- Validate_Attributes for: CURE_AMOUNT_ID --

Line 519: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

515: ---------------------------------------------
516: PROCEDURE validate_cure_amount_id(
517: x_return_status OUT NOCOPY VARCHAR2,
518: p_crav_rec IN crav_rec_type) IS
519: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
520: BEGIN
521:
522: IF (p_crav_rec.cure_amount_id = OKL_API.G_MISS_NUM OR
523: p_crav_rec.cure_amount_id IS NULL)

Line 522: IF (p_crav_rec.cure_amount_id = OKL_API.G_MISS_NUM OR

518: p_crav_rec IN crav_rec_type) IS
519: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
520: BEGIN
521:
522: IF (p_crav_rec.cure_amount_id = OKL_API.G_MISS_NUM OR
523: p_crav_rec.cure_amount_id IS NULL)
524: THEN
525: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_amount_id');
526: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 525: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_amount_id');

521:
522: IF (p_crav_rec.cure_amount_id = OKL_API.G_MISS_NUM OR
523: p_crav_rec.cure_amount_id IS NULL)
524: THEN
525: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_amount_id');
526: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
527:
528: END IF;
529:

Line 526: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

522: IF (p_crav_rec.cure_amount_id = OKL_API.G_MISS_NUM OR
523: p_crav_rec.cure_amount_id IS NULL)
524: THEN
525: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_amount_id');
526: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
527:
528: END IF;
529:
530: x_return_status := l_return_status;

Line 534: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

530: x_return_status := l_return_status;
531:
532: EXCEPTION
533: WHEN OTHERS THEN
534: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
535: ,p_msg_name => G_UNEXPECTED_ERROR
536: ,p_token1 => G_SQLCODE_TOKEN
537: ,p_token1_value => SQLCODE
538: ,p_token2 => G_SQLERRM_TOKEN

Line 540: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

536: ,p_token1 => G_SQLCODE_TOKEN
537: ,p_token1_value => SQLCODE
538: ,p_token2 => G_SQLERRM_TOKEN
539: ,p_token2_value => SQLERRM);
540: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
541: END validate_cure_amount_id;
542: ---------------------------------------------
543: -- Validate_Attributes for: CURE_REPORT_ID --
544: ---------------------------------------------

Line 548: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

544: ---------------------------------------------
545: PROCEDURE validate_cure_report_id(
546: x_return_status OUT NOCOPY VARCHAR2,
547: p_crav_rec IN crav_rec_type) IS
548: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
549: l_approval_status OKL_CURE_REPORTS.approval_status%TYPE;
550:
551: -- Check if the request is still in WIP status
552: CURSOR get_request_status (p_cure_report_id IN NUMBER) IS

Line 559: IF (p_crav_rec.cure_report_id = OKL_API.G_MISS_NUM OR

555: WHERE cure_report_id = p_cure_report_id;
556:
557: BEGIN
558:
559: IF (p_crav_rec.cure_report_id = OKL_API.G_MISS_NUM OR
560: p_crav_rec.cure_report_id IS NULL)
561: THEN
562: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_report_id');
563: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 562: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_report_id');

558:
559: IF (p_crav_rec.cure_report_id = OKL_API.G_MISS_NUM OR
560: p_crav_rec.cure_report_id IS NULL)
561: THEN
562: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_report_id');
563: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
564: END IF;
565:
566: -- Get Request Status

Line 563: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

559: IF (p_crav_rec.cure_report_id = OKL_API.G_MISS_NUM OR
560: p_crav_rec.cure_report_id IS NULL)
561: THEN
562: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_report_id');
563: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
564: END IF;
565:
566: -- Get Request Status
567: OPEN get_request_status (p_crav_rec.cure_report_id);

Line 574: OKL_API.set_message(G_APP_NAME, G_CANNOT_UPDATE_REQUEST, G_COL_NAME_TOKEN, 'cure_report_id');

570:
571: IF ((l_approval_status IS NOT NULL) AND
572: (l_approval_status <> 'IN_PROGRESS'))
573: THEN
574: OKL_API.set_message(G_APP_NAME, G_CANNOT_UPDATE_REQUEST, G_COL_NAME_TOKEN, 'cure_report_id');
575: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
576: END IF;
577:
578: x_return_status := l_return_status;

Line 575: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

571: IF ((l_approval_status IS NOT NULL) AND
572: (l_approval_status <> 'IN_PROGRESS'))
573: THEN
574: OKL_API.set_message(G_APP_NAME, G_CANNOT_UPDATE_REQUEST, G_COL_NAME_TOKEN, 'cure_report_id');
575: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
576: END IF;
577:
578: x_return_status := l_return_status;
579:

Line 583: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

579:
580: EXCEPTION
581:
582: WHEN OTHERS THEN
583: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
584: ,p_msg_name => G_UNEXPECTED_ERROR
585: ,p_token1 => G_SQLCODE_TOKEN
586: ,p_token1_value => SQLCODE
587: ,p_token2 => G_SQLERRM_TOKEN

Line 589: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

585: ,p_token1 => G_SQLCODE_TOKEN
586: ,p_token1_value => SQLCODE
587: ,p_token2 => G_SQLERRM_TOKEN
588: ,p_token2_value => SQLERRM);
589: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
590: END validate_cure_report_id;
591:
592: ---------------------------------------------
593: -- Validate_Attributes for: REQUEST_TYPE --

Line 598: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

594: ---------------------------------------------
595: PROCEDURE validate_request_type(
596: x_return_status OUT NOCOPY VARCHAR2,
597: p_crav_rec IN crav_rec_type) IS
598: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
599: BEGIN
600:
601: IF (p_crav_rec.request_type = OKL_API.G_MISS_CHAR OR
602: p_crav_rec.request_type IS NULL)

Line 601: IF (p_crav_rec.request_type = OKL_API.G_MISS_CHAR OR

597: p_crav_rec IN crav_rec_type) IS
598: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
599: BEGIN
600:
601: IF (p_crav_rec.request_type = OKL_API.G_MISS_CHAR OR
602: p_crav_rec.request_type IS NULL)
603: THEN
604: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'request_type');
605: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 604: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'request_type');

600:
601: IF (p_crav_rec.request_type = OKL_API.G_MISS_CHAR OR
602: p_crav_rec.request_type IS NULL)
603: THEN
604: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'request_type');
605: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
606: END IF;
607: x_return_status := l_return_status;
608:

Line 605: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

601: IF (p_crav_rec.request_type = OKL_API.G_MISS_CHAR OR
602: p_crav_rec.request_type IS NULL)
603: THEN
604: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'request_type');
605: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
606: END IF;
607: x_return_status := l_return_status;
608:
609: EXCEPTION

Line 612: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

608:
609: EXCEPTION
610:
611: WHEN OTHERS THEN
612: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
613: ,p_msg_name => G_UNEXPECTED_ERROR
614: ,p_token1 => G_SQLCODE_TOKEN
615: ,p_token1_value => SQLCODE
616: ,p_token2 => G_SQLERRM_TOKEN

Line 618: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

614: ,p_token1 => G_SQLCODE_TOKEN
615: ,p_token1_value => SQLCODE
616: ,p_token2 => G_SQLERRM_TOKEN
617: ,p_token2_value => SQLERRM);
618: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
619: END validate_request_type;
620:
621: ----------------------------------------------------
622: -- Validate_Attributes for: OBJECT_VERSION_NUMBER --

Line 627: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

623: ----------------------------------------------------
624: PROCEDURE validate_object_version_number(
625: x_return_status OUT NOCOPY VARCHAR2,
626: p_crav_rec IN crav_rec_type) IS
627: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
628: BEGIN
629:
630: IF (p_crav_rec.object_version_number = OKL_API.G_MISS_NUM OR
631: p_crav_rec.object_version_number IS NULL)

Line 630: IF (p_crav_rec.object_version_number = OKL_API.G_MISS_NUM OR

626: p_crav_rec IN crav_rec_type) IS
627: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
628: BEGIN
629:
630: IF (p_crav_rec.object_version_number = OKL_API.G_MISS_NUM OR
631: p_crav_rec.object_version_number IS NULL)
632: THEN
633: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
634: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 633: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');

629:
630: IF (p_crav_rec.object_version_number = OKL_API.G_MISS_NUM OR
631: p_crav_rec.object_version_number IS NULL)
632: THEN
633: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
634: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
635: END IF;
636: x_return_status := l_return_status;
637:

Line 634: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

630: IF (p_crav_rec.object_version_number = OKL_API.G_MISS_NUM OR
631: p_crav_rec.object_version_number IS NULL)
632: THEN
633: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
634: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
635: END IF;
636: x_return_status := l_return_status;
637:
638: EXCEPTION

Line 640: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

636: x_return_status := l_return_status;
637:
638: EXCEPTION
639: WHEN OTHERS THEN
640: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
641: ,p_msg_name => G_UNEXPECTED_ERROR
642: ,p_token1 => G_SQLCODE_TOKEN
643: ,p_token1_value => SQLCODE
644: ,p_token2 => G_SQLERRM_TOKEN

Line 646: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

642: ,p_token1 => G_SQLCODE_TOKEN
643: ,p_token1_value => SQLCODE
644: ,p_token2 => G_SQLERRM_TOKEN
645: ,p_token2_value => SQLERRM);
646: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
647: END validate_object_version_number;
648:
649: ---------------------------------------------------------------------------
650: -- FUNCTION Validate_Attributes

Line 658: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

654: -------------------------------------------------------
655: FUNCTION Validate_Attributes (
656: p_crav_rec IN crav_rec_type
657: ) RETURN VARCHAR2 IS
658: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
659: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
660: BEGIN
661: -----------------------------
662: -- Column Level Validation --

Line 659: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

655: FUNCTION Validate_Attributes (
656: p_crav_rec IN crav_rec_type
657: ) RETURN VARCHAR2 IS
658: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
659: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
660: BEGIN
661: -----------------------------
662: -- Column Level Validation --
663: -----------------------------

Line 668: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

664: -- ***
665: -- cure_report_amount_id
666: -- ***
667: validate_cure_report_amount_id(l_return_status, p_crav_rec);
668: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
669: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
670: x_return_status := l_return_status;
671: RAISE G_EXCEPTION_HALT_VALIDATION;
672: ELSE

Line 669: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

665: -- cure_report_amount_id
666: -- ***
667: validate_cure_report_amount_id(l_return_status, p_crav_rec);
668: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
669: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
670: x_return_status := l_return_status;
671: RAISE G_EXCEPTION_HALT_VALIDATION;
672: ELSE
673: x_return_status := l_return_status;

Line 681: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

677: -- ***
678: -- cure_amount_id
679: -- ***
680: validate_cure_amount_id(l_return_status, p_crav_rec);
681: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
682: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
683: x_return_status := l_return_status;
684: RAISE G_EXCEPTION_HALT_VALIDATION;
685: ELSE

Line 682: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

678: -- cure_amount_id
679: -- ***
680: validate_cure_amount_id(l_return_status, p_crav_rec);
681: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
682: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
683: x_return_status := l_return_status;
684: RAISE G_EXCEPTION_HALT_VALIDATION;
685: ELSE
686: x_return_status := l_return_status;

Line 694: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

690: -- ***
691: -- cure_report_id
692: -- ***
693: validate_cure_report_id(l_return_status, p_crav_rec);
694: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
695: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
696: x_return_status := l_return_status;
697: RAISE G_EXCEPTION_HALT_VALIDATION;
698: ELSE

Line 695: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

691: -- cure_report_id
692: -- ***
693: validate_cure_report_id(l_return_status, p_crav_rec);
694: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
695: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
696: x_return_status := l_return_status;
697: RAISE G_EXCEPTION_HALT_VALIDATION;
698: ELSE
699: x_return_status := l_return_status;

Line 707: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

703: -- ***
704: -- request_type
705: -- ***
706: validate_request_type(l_return_status, p_crav_rec);
707: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
708: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
709: x_return_status := l_return_status;
710: RAISE G_EXCEPTION_HALT_VALIDATION;
711: ELSE

Line 708: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

704: -- request_type
705: -- ***
706: validate_request_type(l_return_status, p_crav_rec);
707: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
708: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
709: x_return_status := l_return_status;
710: RAISE G_EXCEPTION_HALT_VALIDATION;
711: ELSE
712: x_return_status := l_return_status;

Line 720: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

716: -- ***
717: -- object_version_number
718: -- ***
719: validate_object_version_number(l_return_status, p_crav_rec);
720: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
721: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
722: x_return_status := l_return_status;
723: RAISE G_EXCEPTION_HALT_VALIDATION;
724: ELSE

Line 721: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

717: -- object_version_number
718: -- ***
719: validate_object_version_number(l_return_status, p_crav_rec);
720: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
721: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
722: x_return_status := l_return_status;
723: RAISE G_EXCEPTION_HALT_VALIDATION;
724: ELSE
725: x_return_status := l_return_status;

Line 734: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

730: EXCEPTION
731: WHEN G_EXCEPTION_HALT_VALIDATION THEN
732: RETURN(l_return_status);
733: WHEN OTHERS THEN
734: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
735: ,p_msg_name => G_UNEXPECTED_ERROR
736: ,p_token1 => G_SQLCODE_TOKEN
737: ,p_token1_value => SQLCODE
738: ,p_token2 => G_SQLERRM_TOKEN

Line 740: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

736: ,p_token1 => G_SQLCODE_TOKEN
737: ,p_token1_value => SQLCODE
738: ,p_token2 => G_SQLERRM_TOKEN
739: ,p_token2_value => SQLERRM);
740: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
741: RETURN(l_return_status);
742: END Validate_Attributes;
743: ---------------------------------------------------------------------------
744: -- PROCEDURE Validate_Record

Line 753: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

749: FUNCTION Validate_Record (
750: p_crav_rec IN crav_rec_type,
751: p_db_crav_rec IN crav_rec_type
752: ) RETURN VARCHAR2 IS
753: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
754: BEGIN
755: RETURN (l_return_status);
756: END Validate_Record;
757: FUNCTION Validate_Record (

Line 760: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

756: END Validate_Record;
757: FUNCTION Validate_Record (
758: p_crav_rec IN crav_rec_type
759: ) RETURN VARCHAR2 IS
760: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
761: l_db_crav_rec crav_rec_type := get_rec(p_crav_rec);
762: BEGIN
763: l_return_status := Validate_Record(p_crav_rec => p_crav_rec,
764: p_db_crav_rec => l_db_crav_rec);

Line 879: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

875: p_crav_rec IN crav_rec_type) IS
876:
877: l_api_version CONSTANT NUMBER := 1;
878: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
879: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
880: l_crav_rec crav_rec_type := p_crav_rec;
881: l_cra_rec cra_rec_type;
882: l_cra_rec cra_rec_type;
883: BEGIN

Line 884: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

880: l_crav_rec crav_rec_type := p_crav_rec;
881: l_cra_rec cra_rec_type;
882: l_cra_rec cra_rec_type;
883: BEGIN
884: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
885: G_PKG_NAME,
886: p_init_msg_list,
887: l_api_version,
888: p_api_version,

Line 891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

887: l_api_version,
888: p_api_version,
889: '_PVT',
890: x_return_status);
891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
894: RAISE OKL_API.G_EXCEPTION_ERROR;
895: END IF;

Line 892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

888: p_api_version,
889: '_PVT',
890: x_return_status);
891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
894: RAISE OKL_API.G_EXCEPTION_ERROR;
895: END IF;
896: --- Validate all non-missing attributes (Item Level Validation)

Line 893: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

889: '_PVT',
890: x_return_status);
891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
894: RAISE OKL_API.G_EXCEPTION_ERROR;
895: END IF;
896: --- Validate all non-missing attributes (Item Level Validation)
897: l_return_status := Validate_Attributes(l_crav_rec);

Line 894: RAISE OKL_API.G_EXCEPTION_ERROR;

890: x_return_status);
891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
894: RAISE OKL_API.G_EXCEPTION_ERROR;
895: END IF;
896: --- Validate all non-missing attributes (Item Level Validation)
897: l_return_status := Validate_Attributes(l_crav_rec);
898: --- If any errors happen abort API

Line 899: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

895: END IF;
896: --- Validate all non-missing attributes (Item Level Validation)
897: l_return_status := Validate_Attributes(l_crav_rec);
898: --- If any errors happen abort API
899: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
901: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
902: RAISE OKL_API.G_EXCEPTION_ERROR;
903: END IF;

Line 900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

896: --- Validate all non-missing attributes (Item Level Validation)
897: l_return_status := Validate_Attributes(l_crav_rec);
898: --- If any errors happen abort API
899: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
901: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
902: RAISE OKL_API.G_EXCEPTION_ERROR;
903: END IF;
904: l_return_status := Validate_Record(l_crav_rec);

Line 901: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

897: l_return_status := Validate_Attributes(l_crav_rec);
898: --- If any errors happen abort API
899: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
901: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
902: RAISE OKL_API.G_EXCEPTION_ERROR;
903: END IF;
904: l_return_status := Validate_Record(l_crav_rec);
905: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 902: RAISE OKL_API.G_EXCEPTION_ERROR;

898: --- If any errors happen abort API
899: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
901: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
902: RAISE OKL_API.G_EXCEPTION_ERROR;
903: END IF;
904: l_return_status := Validate_Record(l_crav_rec);
905: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
906: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 905: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

901: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
902: RAISE OKL_API.G_EXCEPTION_ERROR;
903: END IF;
904: l_return_status := Validate_Record(l_crav_rec);
905: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
906: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
908: RAISE OKL_API.G_EXCEPTION_ERROR;
909: END IF;

Line 906: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

902: RAISE OKL_API.G_EXCEPTION_ERROR;
903: END IF;
904: l_return_status := Validate_Record(l_crav_rec);
905: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
906: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
908: RAISE OKL_API.G_EXCEPTION_ERROR;
909: END IF;
910: x_return_status := l_return_status;

Line 907: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

903: END IF;
904: l_return_status := Validate_Record(l_crav_rec);
905: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
906: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
908: RAISE OKL_API.G_EXCEPTION_ERROR;
909: END IF;
910: x_return_status := l_return_status;
911: EXCEPTION

Line 908: RAISE OKL_API.G_EXCEPTION_ERROR;

904: l_return_status := Validate_Record(l_crav_rec);
905: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
906: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
908: RAISE OKL_API.G_EXCEPTION_ERROR;
909: END IF;
910: x_return_status := l_return_status;
911: EXCEPTION
912: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 912: WHEN OKL_API.G_EXCEPTION_ERROR THEN

908: RAISE OKL_API.G_EXCEPTION_ERROR;
909: END IF;
910: x_return_status := l_return_status;
911: EXCEPTION
912: WHEN OKL_API.G_EXCEPTION_ERROR THEN
913: x_return_status := OKL_API.HANDLE_EXCEPTIONS
914: (
915: l_api_name,
916: G_PKG_NAME,

Line 913: x_return_status := OKL_API.HANDLE_EXCEPTIONS

909: END IF;
910: x_return_status := l_return_status;
911: EXCEPTION
912: WHEN OKL_API.G_EXCEPTION_ERROR THEN
913: x_return_status := OKL_API.HANDLE_EXCEPTIONS
914: (
915: l_api_name,
916: G_PKG_NAME,
917: 'OKL_API.G_RET_STS_ERROR',

Line 917: 'OKL_API.G_RET_STS_ERROR',

913: x_return_status := OKL_API.HANDLE_EXCEPTIONS
914: (
915: l_api_name,
916: G_PKG_NAME,
917: 'OKL_API.G_RET_STS_ERROR',
918: x_msg_count,
919: x_msg_data,
920: '_PVT'
921: );

Line 922: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

918: x_msg_count,
919: x_msg_data,
920: '_PVT'
921: );
922: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
923: x_return_status := OKL_API.HANDLE_EXCEPTIONS
924: (
925: l_api_name,
926: G_PKG_NAME,

Line 923: x_return_status := OKL_API.HANDLE_EXCEPTIONS

919: x_msg_data,
920: '_PVT'
921: );
922: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
923: x_return_status := OKL_API.HANDLE_EXCEPTIONS
924: (
925: l_api_name,
926: G_PKG_NAME,
927: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 927: 'OKL_API.G_RET_STS_UNEXP_ERROR',

923: x_return_status := OKL_API.HANDLE_EXCEPTIONS
924: (
925: l_api_name,
926: G_PKG_NAME,
927: 'OKL_API.G_RET_STS_UNEXP_ERROR',
928: x_msg_count,
929: x_msg_data,
930: '_PVT'
931: );

Line 933: x_return_status := OKL_API.HANDLE_EXCEPTIONS

929: x_msg_data,
930: '_PVT'
931: );
932: WHEN OTHERS THEN
933: x_return_status := OKL_API.HANDLE_EXCEPTIONS
934: (
935: l_api_name,
936: G_PKG_NAME,
937: 'OTHERS',

Line 953: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

949: x_return_status OUT NOCOPY VARCHAR2,
950: x_msg_count OUT NOCOPY NUMBER,
951: x_msg_data OUT NOCOPY VARCHAR2,
952: p_crav_tbl IN crav_tbl_type,
953: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
954:
955: l_api_version CONSTANT NUMBER := 1;
956: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
957: i NUMBER := 0;

Line 959: OKL_API.init_msg_list(p_init_msg_list);

955: l_api_version CONSTANT NUMBER := 1;
956: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
957: i NUMBER := 0;
958: BEGIN
959: OKL_API.init_msg_list(p_init_msg_list);
960: -- Make sure PL/SQL table has records in it before passing
961: IF (p_crav_tbl.COUNT > 0) THEN
962: i := p_crav_tbl.FIRST;
963: LOOP

Line 965: l_error_rec OKL_API.ERROR_REC_TYPE;

961: IF (p_crav_tbl.COUNT > 0) THEN
962: i := p_crav_tbl.FIRST;
963: LOOP
964: DECLARE
965: l_error_rec OKL_API.ERROR_REC_TYPE;
966: BEGIN
967: l_error_rec.api_name := l_api_name;
968: l_error_rec.api_package := G_PKG_NAME;
969: l_error_rec.idx := i;

Line 972: p_init_msg_list => OKL_API.G_FALSE,

968: l_error_rec.api_package := G_PKG_NAME;
969: l_error_rec.idx := i;
970: validate_row (
971: p_api_version => p_api_version,
972: p_init_msg_list => OKL_API.G_FALSE,
973: x_return_status => l_error_rec.error_type,
974: x_msg_count => l_error_rec.msg_count,
975: x_msg_data => l_error_rec.msg_data,
976: p_crav_rec => p_crav_tbl(i));

Line 977: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN

973: x_return_status => l_error_rec.error_type,
974: x_msg_count => l_error_rec.msg_count,
975: x_msg_data => l_error_rec.msg_data,
976: p_crav_rec => p_crav_tbl(i));
977: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
978: l_error_rec.sqlcode := SQLCODE;
979: load_error_tbl(l_error_rec, px_error_tbl);
980: ELSE
981: x_msg_count := l_error_rec.msg_count;

Line 985: WHEN OKL_API.G_EXCEPTION_ERROR THEN

981: x_msg_count := l_error_rec.msg_count;
982: x_msg_data := l_error_rec.msg_data;
983: END IF;
984: EXCEPTION
985: WHEN OKL_API.G_EXCEPTION_ERROR THEN
986: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
987: l_error_rec.sqlcode := SQLCODE;
988: load_error_tbl(l_error_rec, px_error_tbl);
989: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 986: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;

982: x_msg_data := l_error_rec.msg_data;
983: END IF;
984: EXCEPTION
985: WHEN OKL_API.G_EXCEPTION_ERROR THEN
986: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
987: l_error_rec.sqlcode := SQLCODE;
988: load_error_tbl(l_error_rec, px_error_tbl);
989: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
990: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 989: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

985: WHEN OKL_API.G_EXCEPTION_ERROR THEN
986: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
987: l_error_rec.sqlcode := SQLCODE;
988: load_error_tbl(l_error_rec, px_error_tbl);
989: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
990: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
991: l_error_rec.sqlcode := SQLCODE;
992: load_error_tbl(l_error_rec, px_error_tbl);
993: WHEN OTHERS THEN

Line 990: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

986: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
987: l_error_rec.sqlcode := SQLCODE;
988: load_error_tbl(l_error_rec, px_error_tbl);
989: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
990: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
991: l_error_rec.sqlcode := SQLCODE;
992: load_error_tbl(l_error_rec, px_error_tbl);
993: WHEN OTHERS THEN
994: l_error_rec.error_type := 'OTHERS';

Line 1005: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1001: END IF;
1002: -- Loop through the error_tbl to find the error with the highest severity
1003: -- and return it.
1004: x_return_status := find_highest_exception(px_error_tbl);
1005: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1006: EXCEPTION
1007: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1008: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1009: (

Line 1007: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1003: -- and return it.
1004: x_return_status := find_highest_exception(px_error_tbl);
1005: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1006: EXCEPTION
1007: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1008: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1009: (
1010: l_api_name,
1011: G_PKG_NAME,

Line 1008: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1004: x_return_status := find_highest_exception(px_error_tbl);
1005: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1006: EXCEPTION
1007: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1008: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1009: (
1010: l_api_name,
1011: G_PKG_NAME,
1012: 'OKL_API.G_RET_STS_ERROR',

Line 1012: 'OKL_API.G_RET_STS_ERROR',

1008: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1009: (
1010: l_api_name,
1011: G_PKG_NAME,
1012: 'OKL_API.G_RET_STS_ERROR',
1013: x_msg_count,
1014: x_msg_data,
1015: '_PVT'
1016: );

Line 1017: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1018: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1014: x_msg_data,
1015: '_PVT'
1016: );
1017: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1018: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1019: (
1020: l_api_name,
1021: G_PKG_NAME,
1022: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1022: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1028: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1024: x_msg_data,
1025: '_PVT'
1026: );
1027: WHEN OTHERS THEN
1028: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1029: (
1030: l_api_name,
1031: G_PKG_NAME,
1032: 'OTHERS',

Line 1052: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1048: p_crav_tbl IN crav_tbl_type) IS
1049:
1050: l_api_version CONSTANT NUMBER := 1;
1051: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1052: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1053: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1054: BEGIN
1055: OKL_API.init_msg_list(p_init_msg_list);
1056: -- Make sure PL/SQL table has records in it before passing

Line 1053: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1049:
1050: l_api_version CONSTANT NUMBER := 1;
1051: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1052: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1053: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1054: BEGIN
1055: OKL_API.init_msg_list(p_init_msg_list);
1056: -- Make sure PL/SQL table has records in it before passing
1057: IF (p_crav_tbl.COUNT > 0) THEN

Line 1055: OKL_API.init_msg_list(p_init_msg_list);

1051: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1052: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1053: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1054: BEGIN
1055: OKL_API.init_msg_list(p_init_msg_list);
1056: -- Make sure PL/SQL table has records in it before passing
1057: IF (p_crav_tbl.COUNT > 0) THEN
1058: validate_row (
1059: p_api_version => p_api_version,

Line 1060: p_init_msg_list => OKL_API.G_FALSE,

1056: -- Make sure PL/SQL table has records in it before passing
1057: IF (p_crav_tbl.COUNT > 0) THEN
1058: validate_row (
1059: p_api_version => p_api_version,
1060: p_init_msg_list => OKL_API.G_FALSE,
1061: x_return_status => x_return_status,
1062: x_msg_count => x_msg_count,
1063: x_msg_data => x_msg_data,
1064: p_crav_tbl => p_crav_tbl,

Line 1067: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1063: x_msg_data => x_msg_data,
1064: p_crav_tbl => p_crav_tbl,
1065: px_error_tbl => l_error_tbl);
1066: END IF;
1067: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1068: EXCEPTION
1069: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1070: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1071: (

Line 1069: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1065: px_error_tbl => l_error_tbl);
1066: END IF;
1067: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1068: EXCEPTION
1069: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1070: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1071: (
1072: l_api_name,
1073: G_PKG_NAME,

Line 1070: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1066: END IF;
1067: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1068: EXCEPTION
1069: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1070: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1071: (
1072: l_api_name,
1073: G_PKG_NAME,
1074: 'OKL_API.G_RET_STS_ERROR',

Line 1074: 'OKL_API.G_RET_STS_ERROR',

1070: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1071: (
1072: l_api_name,
1073: G_PKG_NAME,
1074: 'OKL_API.G_RET_STS_ERROR',
1075: x_msg_count,
1076: x_msg_data,
1077: '_PVT'
1078: );

Line 1079: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1075: x_msg_count,
1076: x_msg_data,
1077: '_PVT'
1078: );
1079: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1080: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1081: (
1082: l_api_name,
1083: G_PKG_NAME,

Line 1080: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1076: x_msg_data,
1077: '_PVT'
1078: );
1079: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1080: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1081: (
1082: l_api_name,
1083: G_PKG_NAME,
1084: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1084: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1080: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1081: (
1082: l_api_name,
1083: G_PKG_NAME,
1084: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1085: x_msg_count,
1086: x_msg_data,
1087: '_PVT'
1088: );

Line 1090: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1086: x_msg_data,
1087: '_PVT'
1088: );
1089: WHEN OTHERS THEN
1090: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1091: (
1092: l_api_name,
1093: G_PKG_NAME,
1094: 'OTHERS',

Line 1117: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1113: x_cra_rec OUT NOCOPY cra_rec_type) IS
1114:
1115: l_api_version CONSTANT NUMBER := 1;
1116: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1117: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1118: l_cra_rec cra_rec_type := p_cra_rec;
1119: l_def_cra_rec cra_rec_type;
1120: ------------------------------------------------
1121: -- Set_Attributes for:OKL_CURE_REPORT_AMOUNTS --

Line 1127: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1123: FUNCTION Set_Attributes (
1124: p_cra_rec IN cra_rec_type,
1125: x_cra_rec OUT NOCOPY cra_rec_type
1126: ) RETURN VARCHAR2 IS
1127: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1128: BEGIN
1129: x_cra_rec := p_cra_rec;
1130: RETURN(l_return_status);
1131: END Set_Attributes;

Line 1133: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1129: x_cra_rec := p_cra_rec;
1130: RETURN(l_return_status);
1131: END Set_Attributes;
1132: BEGIN
1133: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1134: p_init_msg_list,
1135: '_PVT',
1136: x_return_status);
1137: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1137: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1133: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1134: p_init_msg_list,
1135: '_PVT',
1136: x_return_status);
1137: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1139: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1140: RAISE OKL_API.G_EXCEPTION_ERROR;
1141: END IF;

Line 1138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1134: p_init_msg_list,
1135: '_PVT',
1136: x_return_status);
1137: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1139: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1140: RAISE OKL_API.G_EXCEPTION_ERROR;
1141: END IF;
1142: --- Setting item atributes

Line 1139: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1135: '_PVT',
1136: x_return_status);
1137: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1139: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1140: RAISE OKL_API.G_EXCEPTION_ERROR;
1141: END IF;
1142: --- Setting item atributes
1143: l_return_status := Set_Attributes(

Line 1140: RAISE OKL_API.G_EXCEPTION_ERROR;

1136: x_return_status);
1137: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1139: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1140: RAISE OKL_API.G_EXCEPTION_ERROR;
1141: END IF;
1142: --- Setting item atributes
1143: l_return_status := Set_Attributes(
1144: p_cra_rec, -- IN

Line 1147: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1143: l_return_status := Set_Attributes(
1144: p_cra_rec, -- IN
1145: l_cra_rec); -- OUT
1146: --- If any errors happen abort API
1147: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_ERROR;
1151: END IF;

Line 1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1144: p_cra_rec, -- IN
1145: l_cra_rec); -- OUT
1146: --- If any errors happen abort API
1147: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_ERROR;
1151: END IF;
1152: INSERT INTO OKL_CURE_REPORT_AMOUNTS(

Line 1149: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1145: l_cra_rec); -- OUT
1146: --- If any errors happen abort API
1147: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_ERROR;
1151: END IF;
1152: INSERT INTO OKL_CURE_REPORT_AMOUNTS(
1153: cure_report_amount_id,

Line 1150: RAISE OKL_API.G_EXCEPTION_ERROR;

1146: --- If any errors happen abort API
1147: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_ERROR;
1151: END IF;
1152: INSERT INTO OKL_CURE_REPORT_AMOUNTS(
1153: cure_report_amount_id,
1154: cure_amount_id,

Line 1237: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1233: l_cra_rec.last_update_login);
1234: -- Set OUT values
1235: x_cra_rec := l_cra_rec;
1236: x_return_status := l_return_status;
1237: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1238: EXCEPTION
1239: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1240: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1241: (

Line 1239: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1235: x_cra_rec := l_cra_rec;
1236: x_return_status := l_return_status;
1237: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1238: EXCEPTION
1239: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1240: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1241: (
1242: l_api_name,
1243: G_PKG_NAME,

Line 1240: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1236: x_return_status := l_return_status;
1237: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1238: EXCEPTION
1239: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1240: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1241: (
1242: l_api_name,
1243: G_PKG_NAME,
1244: 'OKL_API.G_RET_STS_ERROR',

Line 1244: 'OKL_API.G_RET_STS_ERROR',

1240: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1241: (
1242: l_api_name,
1243: G_PKG_NAME,
1244: 'OKL_API.G_RET_STS_ERROR',
1245: x_msg_count,
1246: x_msg_data,
1247: '_PVT'
1248: );

Line 1249: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1245: x_msg_count,
1246: x_msg_data,
1247: '_PVT'
1248: );
1249: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1250: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1251: (
1252: l_api_name,
1253: G_PKG_NAME,

Line 1250: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1246: x_msg_data,
1247: '_PVT'
1248: );
1249: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1250: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1251: (
1252: l_api_name,
1253: G_PKG_NAME,
1254: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1254: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1250: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1251: (
1252: l_api_name,
1253: G_PKG_NAME,
1254: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1255: x_msg_count,
1256: x_msg_data,
1257: '_PVT'
1258: );

Line 1260: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1256: x_msg_data,
1257: '_PVT'
1258: );
1259: WHEN OTHERS THEN
1260: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1261: (
1262: l_api_name,
1263: G_PKG_NAME,
1264: 'OTHERS',

Line 1284: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1280: x_crav_rec OUT NOCOPY crav_rec_type) IS
1281:
1282: l_api_version CONSTANT NUMBER := 1;
1283: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1284: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1285: l_crav_rec crav_rec_type := p_crav_rec;
1286: l_def_crav_rec crav_rec_type;
1287: l_cra_rec cra_rec_type;
1288: lx_cra_rec cra_rec_type;

Line 1311: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1307: FUNCTION Set_Attributes (
1308: p_crav_rec IN crav_rec_type,
1309: x_crav_rec OUT NOCOPY crav_rec_type
1310: ) RETURN VARCHAR2 IS
1311: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1312: BEGIN
1313: x_crav_rec := p_crav_rec;
1314: x_crav_rec.OBJECT_VERSION_NUMBER := 1;
1315: RETURN(l_return_status);

Line 1318: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1314: x_crav_rec.OBJECT_VERSION_NUMBER := 1;
1315: RETURN(l_return_status);
1316: END Set_Attributes;
1317: BEGIN
1318: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1319: G_PKG_NAME,
1320: p_init_msg_list,
1321: l_api_version,
1322: p_api_version,

Line 1325: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1321: l_api_version,
1322: p_api_version,
1323: '_PVT',
1324: x_return_status);
1325: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1327: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1328: RAISE OKL_API.G_EXCEPTION_ERROR;
1329: END IF;

Line 1326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1322: p_api_version,
1323: '_PVT',
1324: x_return_status);
1325: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1327: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1328: RAISE OKL_API.G_EXCEPTION_ERROR;
1329: END IF;
1330: l_crav_rec := null_out_defaults(p_crav_rec);

Line 1327: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1323: '_PVT',
1324: x_return_status);
1325: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1327: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1328: RAISE OKL_API.G_EXCEPTION_ERROR;
1329: END IF;
1330: l_crav_rec := null_out_defaults(p_crav_rec);
1331: -- Set primary key value

Line 1328: RAISE OKL_API.G_EXCEPTION_ERROR;

1324: x_return_status);
1325: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1327: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1328: RAISE OKL_API.G_EXCEPTION_ERROR;
1329: END IF;
1330: l_crav_rec := null_out_defaults(p_crav_rec);
1331: -- Set primary key value
1332: l_crav_rec.CURE_REPORT_AMOUNT_ID := get_seq_id;

Line 1338: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1334: l_return_Status := Set_Attributes(
1335: l_crav_rec, -- IN
1336: l_def_crav_rec); -- OUT
1337: --- If any errors happen abort API
1338: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1340: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1341: RAISE OKL_API.G_EXCEPTION_ERROR;
1342: END IF;

Line 1339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1335: l_crav_rec, -- IN
1336: l_def_crav_rec); -- OUT
1337: --- If any errors happen abort API
1338: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1340: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1341: RAISE OKL_API.G_EXCEPTION_ERROR;
1342: END IF;
1343: l_def_crav_rec := fill_who_columns(l_def_crav_rec);

Line 1340: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1336: l_def_crav_rec); -- OUT
1337: --- If any errors happen abort API
1338: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1340: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1341: RAISE OKL_API.G_EXCEPTION_ERROR;
1342: END IF;
1343: l_def_crav_rec := fill_who_columns(l_def_crav_rec);
1344: --- Validate all non-missing attributes (Item Level Validation)

Line 1341: RAISE OKL_API.G_EXCEPTION_ERROR;

1337: --- If any errors happen abort API
1338: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1340: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1341: RAISE OKL_API.G_EXCEPTION_ERROR;
1342: END IF;
1343: l_def_crav_rec := fill_who_columns(l_def_crav_rec);
1344: --- Validate all non-missing attributes (Item Level Validation)
1345: l_return_status := Validate_Attributes(l_def_crav_rec);

Line 1347: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1343: l_def_crav_rec := fill_who_columns(l_def_crav_rec);
1344: --- Validate all non-missing attributes (Item Level Validation)
1345: l_return_status := Validate_Attributes(l_def_crav_rec);
1346: --- If any errors happen abort API
1347: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1349: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1350: RAISE OKL_API.G_EXCEPTION_ERROR;
1351: END IF;

Line 1348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1344: --- Validate all non-missing attributes (Item Level Validation)
1345: l_return_status := Validate_Attributes(l_def_crav_rec);
1346: --- If any errors happen abort API
1347: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1349: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1350: RAISE OKL_API.G_EXCEPTION_ERROR;
1351: END IF;
1352: l_return_status := Validate_Record(l_def_crav_rec);

Line 1349: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1345: l_return_status := Validate_Attributes(l_def_crav_rec);
1346: --- If any errors happen abort API
1347: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1349: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1350: RAISE OKL_API.G_EXCEPTION_ERROR;
1351: END IF;
1352: l_return_status := Validate_Record(l_def_crav_rec);
1353: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1350: RAISE OKL_API.G_EXCEPTION_ERROR;

1346: --- If any errors happen abort API
1347: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1349: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1350: RAISE OKL_API.G_EXCEPTION_ERROR;
1351: END IF;
1352: l_return_status := Validate_Record(l_def_crav_rec);
1353: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1354: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1353: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1349: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1350: RAISE OKL_API.G_EXCEPTION_ERROR;
1351: END IF;
1352: l_return_status := Validate_Record(l_def_crav_rec);
1353: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1354: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1355: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1356: RAISE OKL_API.G_EXCEPTION_ERROR;
1357: END IF;

Line 1354: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1350: RAISE OKL_API.G_EXCEPTION_ERROR;
1351: END IF;
1352: l_return_status := Validate_Record(l_def_crav_rec);
1353: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1354: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1355: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1356: RAISE OKL_API.G_EXCEPTION_ERROR;
1357: END IF;
1358: -----------------------------------------

Line 1355: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1351: END IF;
1352: l_return_status := Validate_Record(l_def_crav_rec);
1353: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1354: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1355: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1356: RAISE OKL_API.G_EXCEPTION_ERROR;
1357: END IF;
1358: -----------------------------------------
1359: -- Move VIEW record to "Child" records --

Line 1356: RAISE OKL_API.G_EXCEPTION_ERROR;

1352: l_return_status := Validate_Record(l_def_crav_rec);
1353: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1354: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1355: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1356: RAISE OKL_API.G_EXCEPTION_ERROR;
1357: END IF;
1358: -----------------------------------------
1359: -- Move VIEW record to "Child" records --
1360: -----------------------------------------

Line 1373: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1369: x_msg_data,
1370: l_cra_rec,
1371: lx_cra_rec
1372: );
1373: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1374: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1375: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1376: RAISE OKL_API.G_EXCEPTION_ERROR;
1377: END IF;

Line 1374: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1370: l_cra_rec,
1371: lx_cra_rec
1372: );
1373: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1374: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1375: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1376: RAISE OKL_API.G_EXCEPTION_ERROR;
1377: END IF;
1378: migrate(lx_cra_rec, l_def_crav_rec);

Line 1375: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1371: lx_cra_rec
1372: );
1373: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1374: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1375: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1376: RAISE OKL_API.G_EXCEPTION_ERROR;
1377: END IF;
1378: migrate(lx_cra_rec, l_def_crav_rec);
1379: -- Set OUT values

Line 1376: RAISE OKL_API.G_EXCEPTION_ERROR;

1372: );
1373: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1374: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1375: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1376: RAISE OKL_API.G_EXCEPTION_ERROR;
1377: END IF;
1378: migrate(lx_cra_rec, l_def_crav_rec);
1379: -- Set OUT values
1380: x_crav_rec := l_def_crav_rec;

Line 1382: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1378: migrate(lx_cra_rec, l_def_crav_rec);
1379: -- Set OUT values
1380: x_crav_rec := l_def_crav_rec;
1381: x_return_status := l_return_status;
1382: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1383: EXCEPTION
1384: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1385: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1386: (

Line 1384: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1380: x_crav_rec := l_def_crav_rec;
1381: x_return_status := l_return_status;
1382: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1383: EXCEPTION
1384: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1385: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1386: (
1387: l_api_name,
1388: G_PKG_NAME,

Line 1385: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1381: x_return_status := l_return_status;
1382: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1383: EXCEPTION
1384: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1385: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1386: (
1387: l_api_name,
1388: G_PKG_NAME,
1389: 'OKL_API.G_RET_STS_ERROR',

Line 1389: 'OKL_API.G_RET_STS_ERROR',

1385: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1386: (
1387: l_api_name,
1388: G_PKG_NAME,
1389: 'OKL_API.G_RET_STS_ERROR',
1390: x_msg_count,
1391: x_msg_data,
1392: '_PVT'
1393: );

Line 1394: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1390: x_msg_count,
1391: x_msg_data,
1392: '_PVT'
1393: );
1394: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1395: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1396: (
1397: l_api_name,
1398: G_PKG_NAME,

Line 1395: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1391: x_msg_data,
1392: '_PVT'
1393: );
1394: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1395: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1396: (
1397: l_api_name,
1398: G_PKG_NAME,
1399: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1399: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1395: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1396: (
1397: l_api_name,
1398: G_PKG_NAME,
1399: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1400: x_msg_count,
1401: x_msg_data,
1402: '_PVT'
1403: );

Line 1405: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1401: x_msg_data,
1402: '_PVT'
1403: );
1404: WHEN OTHERS THEN
1405: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1406: (
1407: l_api_name,
1408: G_PKG_NAME,
1409: 'OTHERS',

Line 1426: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

1422: x_msg_count OUT NOCOPY NUMBER,
1423: x_msg_data OUT NOCOPY VARCHAR2,
1424: p_crav_tbl IN crav_tbl_type,
1425: x_crav_tbl OUT NOCOPY crav_tbl_type,
1426: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1427:
1428: l_api_version CONSTANT NUMBER := 1;
1429: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1430: i NUMBER := 0;

Line 1432: OKL_API.init_msg_list(p_init_msg_list);

1428: l_api_version CONSTANT NUMBER := 1;
1429: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1430: i NUMBER := 0;
1431: BEGIN
1432: OKL_API.init_msg_list(p_init_msg_list);
1433: -- Make sure PL/SQL table has records in it before passing
1434: IF (p_crav_tbl.COUNT > 0) THEN
1435: i := p_crav_tbl.FIRST;
1436: LOOP

Line 1438: l_error_rec OKL_API.ERROR_REC_TYPE;

1434: IF (p_crav_tbl.COUNT > 0) THEN
1435: i := p_crav_tbl.FIRST;
1436: LOOP
1437: DECLARE
1438: l_error_rec OKL_API.ERROR_REC_TYPE;
1439: BEGIN
1440: l_error_rec.api_name := l_api_name;
1441: l_error_rec.api_package := G_PKG_NAME;
1442: l_error_rec.idx := i;

Line 1445: p_init_msg_list => OKL_API.G_FALSE,

1441: l_error_rec.api_package := G_PKG_NAME;
1442: l_error_rec.idx := i;
1443: insert_row (
1444: p_api_version => p_api_version,
1445: p_init_msg_list => OKL_API.G_FALSE,
1446: x_return_status => l_error_rec.error_type,
1447: x_msg_count => l_error_rec.msg_count,
1448: x_msg_data => l_error_rec.msg_data,
1449: p_crav_rec => p_crav_tbl(i),

Line 1451: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN

1447: x_msg_count => l_error_rec.msg_count,
1448: x_msg_data => l_error_rec.msg_data,
1449: p_crav_rec => p_crav_tbl(i),
1450: x_crav_rec => x_crav_tbl(i));
1451: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
1452: l_error_rec.sqlcode := SQLCODE;
1453: load_error_tbl(l_error_rec, px_error_tbl);
1454: ELSE
1455: x_msg_count := l_error_rec.msg_count;

Line 1459: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1455: x_msg_count := l_error_rec.msg_count;
1456: x_msg_data := l_error_rec.msg_data;
1457: END IF;
1458: EXCEPTION
1459: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1460: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1461: l_error_rec.sqlcode := SQLCODE;
1462: load_error_tbl(l_error_rec, px_error_tbl);
1463: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1460: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;

1456: x_msg_data := l_error_rec.msg_data;
1457: END IF;
1458: EXCEPTION
1459: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1460: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1461: l_error_rec.sqlcode := SQLCODE;
1462: load_error_tbl(l_error_rec, px_error_tbl);
1463: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1464: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1463: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1459: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1460: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1461: l_error_rec.sqlcode := SQLCODE;
1462: load_error_tbl(l_error_rec, px_error_tbl);
1463: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1464: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1465: l_error_rec.sqlcode := SQLCODE;
1466: load_error_tbl(l_error_rec, px_error_tbl);
1467: WHEN OTHERS THEN

Line 1464: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

1460: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1461: l_error_rec.sqlcode := SQLCODE;
1462: load_error_tbl(l_error_rec, px_error_tbl);
1463: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1464: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1465: l_error_rec.sqlcode := SQLCODE;
1466: load_error_tbl(l_error_rec, px_error_tbl);
1467: WHEN OTHERS THEN
1468: l_error_rec.error_type := 'OTHERS';

Line 1479: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1475: END IF;
1476: -- Loop through the error_tbl to find the error with the highest severity
1477: -- and return it.
1478: x_return_status := find_highest_exception(px_error_tbl);
1479: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1480: EXCEPTION
1481: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1482: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1483: (

Line 1481: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1477: -- and return it.
1478: x_return_status := find_highest_exception(px_error_tbl);
1479: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1480: EXCEPTION
1481: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1482: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1483: (
1484: l_api_name,
1485: G_PKG_NAME,

Line 1482: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1486: 'OKL_API.G_RET_STS_ERROR',

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

Line 1491: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1492: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1496: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1502: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1527: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1523: x_crav_tbl OUT NOCOPY crav_tbl_type) IS
1524:
1525: l_api_version CONSTANT NUMBER := 1;
1526: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1527: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1528: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1529: BEGIN
1530: OKL_API.init_msg_list(p_init_msg_list);
1531: -- Make sure PL/SQL table has records in it before passing

Line 1528: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1524:
1525: l_api_version CONSTANT NUMBER := 1;
1526: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1527: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1528: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1529: BEGIN
1530: OKL_API.init_msg_list(p_init_msg_list);
1531: -- Make sure PL/SQL table has records in it before passing
1532: IF (p_crav_tbl.COUNT > 0) THEN

Line 1530: OKL_API.init_msg_list(p_init_msg_list);

1526: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1527: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1528: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1529: BEGIN
1530: OKL_API.init_msg_list(p_init_msg_list);
1531: -- Make sure PL/SQL table has records in it before passing
1532: IF (p_crav_tbl.COUNT > 0) THEN
1533: insert_row (
1534: p_api_version => p_api_version,

Line 1535: p_init_msg_list => OKL_API.G_FALSE,

1531: -- Make sure PL/SQL table has records in it before passing
1532: IF (p_crav_tbl.COUNT > 0) THEN
1533: insert_row (
1534: p_api_version => p_api_version,
1535: p_init_msg_list => OKL_API.G_FALSE,
1536: x_return_status => x_return_status,
1537: x_msg_count => x_msg_count,
1538: x_msg_data => x_msg_data,
1539: p_crav_tbl => p_crav_tbl,

Line 1543: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1539: p_crav_tbl => p_crav_tbl,
1540: x_crav_tbl => x_crav_tbl,
1541: px_error_tbl => l_error_tbl);
1542: END IF;
1543: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1544: EXCEPTION
1545: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1546: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1547: (

Line 1545: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1541: px_error_tbl => l_error_tbl);
1542: END IF;
1543: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1544: EXCEPTION
1545: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1546: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1547: (
1548: l_api_name,
1549: G_PKG_NAME,

Line 1546: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1542: END IF;
1543: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1544: EXCEPTION
1545: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1546: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1547: (
1548: l_api_name,
1549: G_PKG_NAME,
1550: 'OKL_API.G_RET_STS_ERROR',

Line 1550: 'OKL_API.G_RET_STS_ERROR',

1546: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1547: (
1548: l_api_name,
1549: G_PKG_NAME,
1550: 'OKL_API.G_RET_STS_ERROR',
1551: x_msg_count,
1552: x_msg_data,
1553: '_PVT'
1554: );

Line 1555: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1551: x_msg_count,
1552: x_msg_data,
1553: '_PVT'
1554: );
1555: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1556: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1557: (
1558: l_api_name,
1559: G_PKG_NAME,

Line 1556: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1552: x_msg_data,
1553: '_PVT'
1554: );
1555: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1556: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1557: (
1558: l_api_name,
1559: G_PKG_NAME,
1560: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1560: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1556: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1557: (
1558: l_api_name,
1559: G_PKG_NAME,
1560: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1561: x_msg_count,
1562: x_msg_data,
1563: '_PVT'
1564: );

Line 1566: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1562: x_msg_data,
1563: '_PVT'
1564: );
1565: WHEN OTHERS THEN
1566: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1567: (
1568: l_api_name,
1569: G_PKG_NAME,
1570: 'OTHERS',

Line 1605: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1601: FROM OKL_CURE_REPORT_AMOUNTS
1602: WHERE CURE_REPORT_AMOUNT_ID = p_cra_rec.cure_report_amount_id;
1603: l_api_version CONSTANT NUMBER := 1;
1604: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1605: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1606: l_object_version_number OKL_CURE_REPORT_AMOUNTS.OBJECT_VERSION_NUMBER%TYPE;
1607: lc_object_version_number OKL_CURE_REPORT_AMOUNTS.OBJECT_VERSION_NUMBER%TYPE;
1608: l_row_notfound BOOLEAN := FALSE;
1609: lc_row_notfound BOOLEAN := FALSE;

Line 1611: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1607: lc_object_version_number OKL_CURE_REPORT_AMOUNTS.OBJECT_VERSION_NUMBER%TYPE;
1608: l_row_notfound BOOLEAN := FALSE;
1609: lc_row_notfound BOOLEAN := FALSE;
1610: BEGIN
1611: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1612: p_init_msg_list,
1613: '_PVT',
1614: x_return_status);
1615: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1615: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1611: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1612: p_init_msg_list,
1613: '_PVT',
1614: x_return_status);
1615: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1616: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1617: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1618: RAISE OKL_API.G_EXCEPTION_ERROR;
1619: END IF;

Line 1616: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1612: p_init_msg_list,
1613: '_PVT',
1614: x_return_status);
1615: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1616: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1617: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1618: RAISE OKL_API.G_EXCEPTION_ERROR;
1619: END IF;
1620: BEGIN

Line 1617: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1613: '_PVT',
1614: x_return_status);
1615: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1616: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1617: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1618: RAISE OKL_API.G_EXCEPTION_ERROR;
1619: END IF;
1620: BEGIN
1621: OPEN lock_csr(p_cra_rec);

Line 1618: RAISE OKL_API.G_EXCEPTION_ERROR;

1614: x_return_status);
1615: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1616: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1617: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1618: RAISE OKL_API.G_EXCEPTION_ERROR;
1619: END IF;
1620: BEGIN
1621: OPEN lock_csr(p_cra_rec);
1622: FETCH lock_csr INTO l_object_version_number;

Line 1630: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1626: WHEN E_Resource_Busy THEN
1627: IF (lock_csr%ISOPEN) THEN
1628: CLOSE lock_csr;
1629: END IF;
1630: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1631: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1632: END;
1633:
1634: IF ( l_row_notfound ) THEN

Line 1641: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1637: lc_row_notfound := lchk_csr%NOTFOUND;
1638: CLOSE lchk_csr;
1639: END IF;
1640: IF (lc_row_notfound) THEN
1641: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1642: RAISE OKL_API.G_EXCEPTION_ERROR;
1643: ELSIF lc_object_version_number > p_cra_rec.object_version_number THEN
1644: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1645: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1642: RAISE OKL_API.G_EXCEPTION_ERROR;

1638: CLOSE lchk_csr;
1639: END IF;
1640: IF (lc_row_notfound) THEN
1641: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1642: RAISE OKL_API.G_EXCEPTION_ERROR;
1643: ELSIF lc_object_version_number > p_cra_rec.object_version_number THEN
1644: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1645: RAISE OKL_API.G_EXCEPTION_ERROR;
1646: ELSIF lc_object_version_number <> p_cra_rec.object_version_number THEN

Line 1644: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1640: IF (lc_row_notfound) THEN
1641: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1642: RAISE OKL_API.G_EXCEPTION_ERROR;
1643: ELSIF lc_object_version_number > p_cra_rec.object_version_number THEN
1644: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1645: RAISE OKL_API.G_EXCEPTION_ERROR;
1646: ELSIF lc_object_version_number <> p_cra_rec.object_version_number THEN
1647: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1648: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1645: RAISE OKL_API.G_EXCEPTION_ERROR;

1641: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1642: RAISE OKL_API.G_EXCEPTION_ERROR;
1643: ELSIF lc_object_version_number > p_cra_rec.object_version_number THEN
1644: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1645: RAISE OKL_API.G_EXCEPTION_ERROR;
1646: ELSIF lc_object_version_number <> p_cra_rec.object_version_number THEN
1647: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1648: RAISE OKL_API.G_EXCEPTION_ERROR;
1649: ELSIF lc_object_version_number = -1 THEN

Line 1647: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1643: ELSIF lc_object_version_number > p_cra_rec.object_version_number THEN
1644: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1645: RAISE OKL_API.G_EXCEPTION_ERROR;
1646: ELSIF lc_object_version_number <> p_cra_rec.object_version_number THEN
1647: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1648: RAISE OKL_API.G_EXCEPTION_ERROR;
1649: ELSIF lc_object_version_number = -1 THEN
1650: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1651: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1648: RAISE OKL_API.G_EXCEPTION_ERROR;

1644: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1645: RAISE OKL_API.G_EXCEPTION_ERROR;
1646: ELSIF lc_object_version_number <> p_cra_rec.object_version_number THEN
1647: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1648: RAISE OKL_API.G_EXCEPTION_ERROR;
1649: ELSIF lc_object_version_number = -1 THEN
1650: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1651: RAISE OKL_API.G_EXCEPTION_ERROR;
1652: END IF;

Line 1650: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1646: ELSIF lc_object_version_number <> p_cra_rec.object_version_number THEN
1647: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1648: RAISE OKL_API.G_EXCEPTION_ERROR;
1649: ELSIF lc_object_version_number = -1 THEN
1650: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1651: RAISE OKL_API.G_EXCEPTION_ERROR;
1652: END IF;
1653: x_return_status := l_return_status;
1654: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1651: RAISE OKL_API.G_EXCEPTION_ERROR;

1647: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1648: RAISE OKL_API.G_EXCEPTION_ERROR;
1649: ELSIF lc_object_version_number = -1 THEN
1650: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1651: RAISE OKL_API.G_EXCEPTION_ERROR;
1652: END IF;
1653: x_return_status := l_return_status;
1654: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1655: EXCEPTION

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

1650: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1651: RAISE OKL_API.G_EXCEPTION_ERROR;
1652: END IF;
1653: x_return_status := l_return_status;
1654: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1655: EXCEPTION
1656: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1657: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1658: (

Line 1656: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1652: END IF;
1653: x_return_status := l_return_status;
1654: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1655: EXCEPTION
1656: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1657: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1658: (
1659: l_api_name,
1660: G_PKG_NAME,

Line 1657: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1661: 'OKL_API.G_RET_STS_ERROR',

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

Line 1666: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1667: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1671: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1677: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1696: p_crav_rec IN crav_rec_type) IS
1697:
1698: l_api_version CONSTANT NUMBER := 1;
1699: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1700: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1701: l_cra_rec cra_rec_type;
1702: BEGIN
1703: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1704: G_PKG_NAME,

Line 1703: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1699: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1700: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1701: l_cra_rec cra_rec_type;
1702: BEGIN
1703: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1704: G_PKG_NAME,
1705: p_init_msg_list,
1706: l_api_version,
1707: p_api_version,

Line 1710: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1706: l_api_version,
1707: p_api_version,
1708: '_PVT',
1709: x_return_status);
1710: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1712: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1713: RAISE OKL_API.G_EXCEPTION_ERROR;
1714: END IF;

Line 1711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1707: p_api_version,
1708: '_PVT',
1709: x_return_status);
1710: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1712: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1713: RAISE OKL_API.G_EXCEPTION_ERROR;
1714: END IF;
1715: -----------------------------------------

Line 1712: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1708: '_PVT',
1709: x_return_status);
1710: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1712: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1713: RAISE OKL_API.G_EXCEPTION_ERROR;
1714: END IF;
1715: -----------------------------------------
1716: -- Move VIEW record to "Child" records --

Line 1713: RAISE OKL_API.G_EXCEPTION_ERROR;

1709: x_return_status);
1710: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1712: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1713: RAISE OKL_API.G_EXCEPTION_ERROR;
1714: END IF;
1715: -----------------------------------------
1716: -- Move VIEW record to "Child" records --
1717: -----------------------------------------

Line 1729: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1725: x_msg_count,
1726: x_msg_data,
1727: l_cra_rec
1728: );
1729: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1730: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1731: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1732: RAISE OKL_API.G_EXCEPTION_ERROR;
1733: END IF;

Line 1730: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1726: x_msg_data,
1727: l_cra_rec
1728: );
1729: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1730: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1731: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1732: RAISE OKL_API.G_EXCEPTION_ERROR;
1733: END IF;
1734: x_return_status := l_return_status;

Line 1731: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1727: l_cra_rec
1728: );
1729: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1730: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1731: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1732: RAISE OKL_API.G_EXCEPTION_ERROR;
1733: END IF;
1734: x_return_status := l_return_status;
1735: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1732: RAISE OKL_API.G_EXCEPTION_ERROR;

1728: );
1729: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1730: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1731: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1732: RAISE OKL_API.G_EXCEPTION_ERROR;
1733: END IF;
1734: x_return_status := l_return_status;
1735: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1736: EXCEPTION

Line 1735: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1731: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1732: RAISE OKL_API.G_EXCEPTION_ERROR;
1733: END IF;
1734: x_return_status := l_return_status;
1735: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1736: EXCEPTION
1737: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1738: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1739: (

Line 1737: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1733: END IF;
1734: x_return_status := l_return_status;
1735: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1736: EXCEPTION
1737: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1738: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1739: (
1740: l_api_name,
1741: G_PKG_NAME,

Line 1738: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1734: x_return_status := l_return_status;
1735: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1736: EXCEPTION
1737: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1738: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1739: (
1740: l_api_name,
1741: G_PKG_NAME,
1742: 'OKL_API.G_RET_STS_ERROR',

Line 1742: 'OKL_API.G_RET_STS_ERROR',

1738: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1739: (
1740: l_api_name,
1741: G_PKG_NAME,
1742: 'OKL_API.G_RET_STS_ERROR',
1743: x_msg_count,
1744: x_msg_data,
1745: '_PVT'
1746: );

Line 1747: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1743: x_msg_count,
1744: x_msg_data,
1745: '_PVT'
1746: );
1747: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1748: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1749: (
1750: l_api_name,
1751: G_PKG_NAME,

Line 1748: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1744: x_msg_data,
1745: '_PVT'
1746: );
1747: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1748: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1749: (
1750: l_api_name,
1751: G_PKG_NAME,
1752: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1752: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1748: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1749: (
1750: l_api_name,
1751: G_PKG_NAME,
1752: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1753: x_msg_count,
1754: x_msg_data,
1755: '_PVT'
1756: );

Line 1758: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1754: x_msg_data,
1755: '_PVT'
1756: );
1757: WHEN OTHERS THEN
1758: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1759: (
1760: l_api_name,
1761: G_PKG_NAME,
1762: 'OTHERS',

Line 1778: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

1774: x_return_status OUT NOCOPY VARCHAR2,
1775: x_msg_count OUT NOCOPY NUMBER,
1776: x_msg_data OUT NOCOPY VARCHAR2,
1777: p_crav_tbl IN crav_tbl_type,
1778: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1779:
1780: l_api_version CONSTANT NUMBER := 1;
1781: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1782: i NUMBER := 0;

Line 1784: OKL_API.init_msg_list(p_init_msg_list);

1780: l_api_version CONSTANT NUMBER := 1;
1781: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1782: i NUMBER := 0;
1783: BEGIN
1784: OKL_API.init_msg_list(p_init_msg_list);
1785: -- Make sure PL/SQL table has recrods in it before passing
1786: IF (p_crav_tbl.COUNT > 0) THEN
1787: i := p_crav_tbl.FIRST;
1788: LOOP

Line 1790: l_error_rec OKL_API.ERROR_REC_TYPE;

1786: IF (p_crav_tbl.COUNT > 0) THEN
1787: i := p_crav_tbl.FIRST;
1788: LOOP
1789: DECLARE
1790: l_error_rec OKL_API.ERROR_REC_TYPE;
1791: BEGIN
1792: l_error_rec.api_name := l_api_name;
1793: l_error_rec.api_package := G_PKG_NAME;
1794: l_error_rec.idx := i;

Line 1797: p_init_msg_list => OKL_API.G_FALSE,

1793: l_error_rec.api_package := G_PKG_NAME;
1794: l_error_rec.idx := i;
1795: lock_row(
1796: p_api_version => p_api_version,
1797: p_init_msg_list => OKL_API.G_FALSE,
1798: x_return_status => l_error_rec.error_type,
1799: x_msg_count => l_error_rec.msg_count,
1800: x_msg_data => l_error_rec.msg_data,
1801: p_crav_rec => p_crav_tbl(i));

Line 1802: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN

1798: x_return_status => l_error_rec.error_type,
1799: x_msg_count => l_error_rec.msg_count,
1800: x_msg_data => l_error_rec.msg_data,
1801: p_crav_rec => p_crav_tbl(i));
1802: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
1803: l_error_rec.sqlcode := SQLCODE;
1804: load_error_tbl(l_error_rec, px_error_tbl);
1805: ELSE
1806: x_msg_count := l_error_rec.msg_count;

Line 1810: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1806: x_msg_count := l_error_rec.msg_count;
1807: x_msg_data := l_error_rec.msg_data;
1808: END IF;
1809: EXCEPTION
1810: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1811: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1812: l_error_rec.sqlcode := SQLCODE;
1813: load_error_tbl(l_error_rec, px_error_tbl);
1814: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1811: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;

1807: x_msg_data := l_error_rec.msg_data;
1808: END IF;
1809: EXCEPTION
1810: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1811: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1812: l_error_rec.sqlcode := SQLCODE;
1813: load_error_tbl(l_error_rec, px_error_tbl);
1814: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1815: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1814: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1810: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1811: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1812: l_error_rec.sqlcode := SQLCODE;
1813: load_error_tbl(l_error_rec, px_error_tbl);
1814: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1815: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1816: l_error_rec.sqlcode := SQLCODE;
1817: load_error_tbl(l_error_rec, px_error_tbl);
1818: WHEN OTHERS THEN

Line 1815: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

1811: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1812: l_error_rec.sqlcode := SQLCODE;
1813: load_error_tbl(l_error_rec, px_error_tbl);
1814: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1815: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1816: l_error_rec.sqlcode := SQLCODE;
1817: load_error_tbl(l_error_rec, px_error_tbl);
1818: WHEN OTHERS THEN
1819: l_error_rec.error_type := 'OTHERS';

Line 1830: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1826: END IF;
1827: -- Loop through the error_tbl to find the error with the highest severity
1828: -- and return it.
1829: x_return_status := find_highest_exception(px_error_tbl);
1830: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1831: EXCEPTION
1832: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1833: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1834: (

Line 1832: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1828: -- and return it.
1829: x_return_status := find_highest_exception(px_error_tbl);
1830: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1831: EXCEPTION
1832: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1833: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1834: (
1835: l_api_name,
1836: G_PKG_NAME,

Line 1833: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1829: x_return_status := find_highest_exception(px_error_tbl);
1830: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1831: EXCEPTION
1832: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1833: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1834: (
1835: l_api_name,
1836: G_PKG_NAME,
1837: 'OKL_API.G_RET_STS_ERROR',

Line 1837: 'OKL_API.G_RET_STS_ERROR',

1833: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1834: (
1835: l_api_name,
1836: G_PKG_NAME,
1837: 'OKL_API.G_RET_STS_ERROR',
1838: x_msg_count,
1839: x_msg_data,
1840: '_PVT'
1841: );

Line 1842: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1838: x_msg_count,
1839: x_msg_data,
1840: '_PVT'
1841: );
1842: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1843: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1844: (
1845: l_api_name,
1846: G_PKG_NAME,

Line 1843: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1839: x_msg_data,
1840: '_PVT'
1841: );
1842: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1843: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1844: (
1845: l_api_name,
1846: G_PKG_NAME,
1847: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1847: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1853: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1876: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1872: p_crav_tbl IN crav_tbl_type) IS
1873:
1874: l_api_version CONSTANT NUMBER := 1;
1875: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1876: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1877: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1878: BEGIN
1879: OKL_API.init_msg_list(p_init_msg_list);
1880: -- Make sure PL/SQL table has recrods in it before passing

Line 1877: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1873:
1874: l_api_version CONSTANT NUMBER := 1;
1875: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1876: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1877: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1878: BEGIN
1879: OKL_API.init_msg_list(p_init_msg_list);
1880: -- Make sure PL/SQL table has recrods in it before passing
1881: IF (p_crav_tbl.COUNT > 0) THEN

Line 1879: OKL_API.init_msg_list(p_init_msg_list);

1875: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1876: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1877: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1878: BEGIN
1879: OKL_API.init_msg_list(p_init_msg_list);
1880: -- Make sure PL/SQL table has recrods in it before passing
1881: IF (p_crav_tbl.COUNT > 0) THEN
1882: lock_row(
1883: p_api_version => p_api_version,

Line 1884: p_init_msg_list => OKL_API.G_FALSE,

1880: -- Make sure PL/SQL table has recrods in it before passing
1881: IF (p_crav_tbl.COUNT > 0) THEN
1882: lock_row(
1883: p_api_version => p_api_version,
1884: p_init_msg_list => OKL_API.G_FALSE,
1885: x_return_status => x_return_status,
1886: x_msg_count => x_msg_count,
1887: x_msg_data => x_msg_data,
1888: p_crav_tbl => p_crav_tbl,

Line 1891: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1887: x_msg_data => x_msg_data,
1888: p_crav_tbl => p_crav_tbl,
1889: px_error_tbl => l_error_tbl);
1890: END IF;
1891: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1892: EXCEPTION
1893: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1894: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1895: (

Line 1893: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1889: px_error_tbl => l_error_tbl);
1890: END IF;
1891: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1892: EXCEPTION
1893: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1894: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1895: (
1896: l_api_name,
1897: G_PKG_NAME,

Line 1894: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1890: END IF;
1891: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1892: EXCEPTION
1893: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1894: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1895: (
1896: l_api_name,
1897: G_PKG_NAME,
1898: 'OKL_API.G_RET_STS_ERROR',

Line 1898: 'OKL_API.G_RET_STS_ERROR',

1894: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1895: (
1896: l_api_name,
1897: G_PKG_NAME,
1898: 'OKL_API.G_RET_STS_ERROR',
1899: x_msg_count,
1900: x_msg_data,
1901: '_PVT'
1902: );

Line 1903: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1899: x_msg_count,
1900: x_msg_data,
1901: '_PVT'
1902: );
1903: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1904: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1905: (
1906: l_api_name,
1907: G_PKG_NAME,

Line 1904: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1900: x_msg_data,
1901: '_PVT'
1902: );
1903: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1904: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1905: (
1906: l_api_name,
1907: G_PKG_NAME,
1908: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1908: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1904: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1905: (
1906: l_api_name,
1907: G_PKG_NAME,
1908: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1909: x_msg_count,
1910: x_msg_data,
1911: '_PVT'
1912: );

Line 1914: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1910: x_msg_data,
1911: '_PVT'
1912: );
1913: WHEN OTHERS THEN
1914: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1915: (
1916: l_api_name,
1917: G_PKG_NAME,
1918: 'OTHERS',

Line 1940: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1936: x_cra_rec OUT NOCOPY cra_rec_type) IS
1937:
1938: l_api_version CONSTANT NUMBER := 1;
1939: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1940: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1941: l_cra_rec cra_rec_type := p_cra_rec;
1942: l_def_cra_rec cra_rec_type;
1943: l_row_notfound BOOLEAN := TRUE;
1944: ----------------------------------

Line 1953: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1949: x_cra_rec OUT NOCOPY cra_rec_type
1950: ) RETURN VARCHAR2 IS
1951: l_cra_rec cra_rec_type;
1952: l_row_notfound BOOLEAN := TRUE;
1953: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1954: BEGIN
1955: x_cra_rec := p_cra_rec;
1956: -- Get current database values
1957: l_cra_rec := get_rec(p_cra_rec, l_return_status);

Line 1958: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

1954: BEGIN
1955: x_cra_rec := p_cra_rec;
1956: -- Get current database values
1957: l_cra_rec := get_rec(p_cra_rec, l_return_status);
1958: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1959: IF (x_cra_rec.cure_report_amount_id = OKL_API.G_MISS_NUM)
1960: THEN
1961: x_cra_rec.cure_report_amount_id := l_cra_rec.cure_report_amount_id;
1962: END IF;

Line 1959: IF (x_cra_rec.cure_report_amount_id = OKL_API.G_MISS_NUM)

1955: x_cra_rec := p_cra_rec;
1956: -- Get current database values
1957: l_cra_rec := get_rec(p_cra_rec, l_return_status);
1958: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1959: IF (x_cra_rec.cure_report_amount_id = OKL_API.G_MISS_NUM)
1960: THEN
1961: x_cra_rec.cure_report_amount_id := l_cra_rec.cure_report_amount_id;
1962: END IF;
1963: IF (x_cra_rec.cure_amount_id = OKL_API.G_MISS_NUM)

Line 1963: IF (x_cra_rec.cure_amount_id = OKL_API.G_MISS_NUM)

1959: IF (x_cra_rec.cure_report_amount_id = OKL_API.G_MISS_NUM)
1960: THEN
1961: x_cra_rec.cure_report_amount_id := l_cra_rec.cure_report_amount_id;
1962: END IF;
1963: IF (x_cra_rec.cure_amount_id = OKL_API.G_MISS_NUM)
1964: THEN
1965: x_cra_rec.cure_amount_id := l_cra_rec.cure_amount_id;
1966: END IF;
1967: IF (x_cra_rec.cure_report_id = OKL_API.G_MISS_NUM)

Line 1967: IF (x_cra_rec.cure_report_id = OKL_API.G_MISS_NUM)

1963: IF (x_cra_rec.cure_amount_id = OKL_API.G_MISS_NUM)
1964: THEN
1965: x_cra_rec.cure_amount_id := l_cra_rec.cure_amount_id;
1966: END IF;
1967: IF (x_cra_rec.cure_report_id = OKL_API.G_MISS_NUM)
1968: THEN
1969: x_cra_rec.cure_report_id := l_cra_rec.cure_report_id;
1970: END IF;
1971: IF (x_cra_rec.request_type = OKL_API.G_MISS_CHAR)

Line 1971: IF (x_cra_rec.request_type = OKL_API.G_MISS_CHAR)

1967: IF (x_cra_rec.cure_report_id = OKL_API.G_MISS_NUM)
1968: THEN
1969: x_cra_rec.cure_report_id := l_cra_rec.cure_report_id;
1970: END IF;
1971: IF (x_cra_rec.request_type = OKL_API.G_MISS_CHAR)
1972: THEN
1973: x_cra_rec.request_type := l_cra_rec.request_type;
1974: END IF;
1975: IF (x_cra_rec.cures_in_possession = OKL_API.G_MISS_NUM)

Line 1975: IF (x_cra_rec.cures_in_possession = OKL_API.G_MISS_NUM)

1971: IF (x_cra_rec.request_type = OKL_API.G_MISS_CHAR)
1972: THEN
1973: x_cra_rec.request_type := l_cra_rec.request_type;
1974: END IF;
1975: IF (x_cra_rec.cures_in_possession = OKL_API.G_MISS_NUM)
1976: THEN
1977: x_cra_rec.cures_in_possession := l_cra_rec.cures_in_possession;
1978: END IF;
1979: IF (x_cra_rec.claimed_cure_amount = OKL_API.G_MISS_NUM)

Line 1979: IF (x_cra_rec.claimed_cure_amount = OKL_API.G_MISS_NUM)

1975: IF (x_cra_rec.cures_in_possession = OKL_API.G_MISS_NUM)
1976: THEN
1977: x_cra_rec.cures_in_possession := l_cra_rec.cures_in_possession;
1978: END IF;
1979: IF (x_cra_rec.claimed_cure_amount = OKL_API.G_MISS_NUM)
1980: THEN
1981: x_cra_rec.claimed_cure_amount := l_cra_rec.claimed_cure_amount;
1982: END IF;
1983: IF (x_cra_rec.past_due_amount = OKL_API.G_MISS_NUM)

Line 1983: IF (x_cra_rec.past_due_amount = OKL_API.G_MISS_NUM)

1979: IF (x_cra_rec.claimed_cure_amount = OKL_API.G_MISS_NUM)
1980: THEN
1981: x_cra_rec.claimed_cure_amount := l_cra_rec.claimed_cure_amount;
1982: END IF;
1983: IF (x_cra_rec.past_due_amount = OKL_API.G_MISS_NUM)
1984: THEN
1985: x_cra_rec.past_due_amount := l_cra_rec.past_due_amount;
1986: END IF;
1987: IF (x_cra_rec.eligible_cure_amount = OKL_API.G_MISS_NUM)

Line 1987: IF (x_cra_rec.eligible_cure_amount = OKL_API.G_MISS_NUM)

1983: IF (x_cra_rec.past_due_amount = OKL_API.G_MISS_NUM)
1984: THEN
1985: x_cra_rec.past_due_amount := l_cra_rec.past_due_amount;
1986: END IF;
1987: IF (x_cra_rec.eligible_cure_amount = OKL_API.G_MISS_NUM)
1988: THEN
1989: x_cra_rec.eligible_cure_amount := l_cra_rec.eligible_cure_amount;
1990: END IF;
1991: IF (x_cra_rec.repurchase_amount = OKL_API.G_MISS_NUM)

Line 1991: IF (x_cra_rec.repurchase_amount = OKL_API.G_MISS_NUM)

1987: IF (x_cra_rec.eligible_cure_amount = OKL_API.G_MISS_NUM)
1988: THEN
1989: x_cra_rec.eligible_cure_amount := l_cra_rec.eligible_cure_amount;
1990: END IF;
1991: IF (x_cra_rec.repurchase_amount = OKL_API.G_MISS_NUM)
1992: THEN
1993: x_cra_rec.repurchase_amount := l_cra_rec.repurchase_amount;
1994: END IF;
1995: IF (x_cra_rec.outstanding_amount = OKL_API.G_MISS_NUM)

Line 1995: IF (x_cra_rec.outstanding_amount = OKL_API.G_MISS_NUM)

1991: IF (x_cra_rec.repurchase_amount = OKL_API.G_MISS_NUM)
1992: THEN
1993: x_cra_rec.repurchase_amount := l_cra_rec.repurchase_amount;
1994: END IF;
1995: IF (x_cra_rec.outstanding_amount = OKL_API.G_MISS_NUM)
1996: THEN
1997: x_cra_rec.outstanding_amount := l_cra_rec.outstanding_amount;
1998: END IF;
1999: IF (x_cra_rec.times_cured = OKL_API.G_MISS_NUM)

Line 1999: IF (x_cra_rec.times_cured = OKL_API.G_MISS_NUM)

1995: IF (x_cra_rec.outstanding_amount = OKL_API.G_MISS_NUM)
1996: THEN
1997: x_cra_rec.outstanding_amount := l_cra_rec.outstanding_amount;
1998: END IF;
1999: IF (x_cra_rec.times_cured = OKL_API.G_MISS_NUM)
2000: THEN
2001: x_cra_rec.times_cured := l_cra_rec.times_cured;
2002: END IF;
2003: IF (x_cra_rec.payments_remaining = OKL_API.G_MISS_NUM)

Line 2003: IF (x_cra_rec.payments_remaining = OKL_API.G_MISS_NUM)

1999: IF (x_cra_rec.times_cured = OKL_API.G_MISS_NUM)
2000: THEN
2001: x_cra_rec.times_cured := l_cra_rec.times_cured;
2002: END IF;
2003: IF (x_cra_rec.payments_remaining = OKL_API.G_MISS_NUM)
2004: THEN
2005: x_cra_rec.payments_remaining := l_cra_rec.payments_remaining;
2006: END IF;
2007: IF (x_cra_rec.status = OKL_API.G_MISS_CHAR)

Line 2007: IF (x_cra_rec.status = OKL_API.G_MISS_CHAR)

2003: IF (x_cra_rec.payments_remaining = OKL_API.G_MISS_NUM)
2004: THEN
2005: x_cra_rec.payments_remaining := l_cra_rec.payments_remaining;
2006: END IF;
2007: IF (x_cra_rec.status = OKL_API.G_MISS_CHAR)
2008: THEN
2009: x_cra_rec.status := l_cra_rec.status;
2010: END IF;
2011: IF (x_cra_rec.object_version_number = OKL_API.G_MISS_NUM)

Line 2011: IF (x_cra_rec.object_version_number = OKL_API.G_MISS_NUM)

2007: IF (x_cra_rec.status = OKL_API.G_MISS_CHAR)
2008: THEN
2009: x_cra_rec.status := l_cra_rec.status;
2010: END IF;
2011: IF (x_cra_rec.object_version_number = OKL_API.G_MISS_NUM)
2012: THEN
2013: x_cra_rec.object_version_number := l_cra_rec.object_version_number;
2014: END IF;
2015: IF (x_cra_rec.org_id = OKL_API.G_MISS_NUM)

Line 2015: IF (x_cra_rec.org_id = OKL_API.G_MISS_NUM)

2011: IF (x_cra_rec.object_version_number = OKL_API.G_MISS_NUM)
2012: THEN
2013: x_cra_rec.object_version_number := l_cra_rec.object_version_number;
2014: END IF;
2015: IF (x_cra_rec.org_id = OKL_API.G_MISS_NUM)
2016: THEN
2017: x_cra_rec.org_id := l_cra_rec.org_id;
2018: END IF;
2019: IF (x_cra_rec.request_id = OKL_API.G_MISS_NUM)

Line 2019: IF (x_cra_rec.request_id = OKL_API.G_MISS_NUM)

2015: IF (x_cra_rec.org_id = OKL_API.G_MISS_NUM)
2016: THEN
2017: x_cra_rec.org_id := l_cra_rec.org_id;
2018: END IF;
2019: IF (x_cra_rec.request_id = OKL_API.G_MISS_NUM)
2020: THEN
2021: x_cra_rec.request_id := l_cra_rec.request_id;
2022: END IF;
2023: IF (x_cra_rec.program_application_id = OKL_API.G_MISS_NUM)

Line 2023: IF (x_cra_rec.program_application_id = OKL_API.G_MISS_NUM)

2019: IF (x_cra_rec.request_id = OKL_API.G_MISS_NUM)
2020: THEN
2021: x_cra_rec.request_id := l_cra_rec.request_id;
2022: END IF;
2023: IF (x_cra_rec.program_application_id = OKL_API.G_MISS_NUM)
2024: THEN
2025: x_cra_rec.program_application_id := l_cra_rec.program_application_id;
2026: END IF;
2027: IF (x_cra_rec.program_id = OKL_API.G_MISS_NUM)

Line 2027: IF (x_cra_rec.program_id = OKL_API.G_MISS_NUM)

2023: IF (x_cra_rec.program_application_id = OKL_API.G_MISS_NUM)
2024: THEN
2025: x_cra_rec.program_application_id := l_cra_rec.program_application_id;
2026: END IF;
2027: IF (x_cra_rec.program_id = OKL_API.G_MISS_NUM)
2028: THEN
2029: x_cra_rec.program_id := l_cra_rec.program_id;
2030: END IF;
2031: IF (x_cra_rec.program_update_date = OKL_API.G_MISS_DATE)

Line 2031: IF (x_cra_rec.program_update_date = OKL_API.G_MISS_DATE)

2027: IF (x_cra_rec.program_id = OKL_API.G_MISS_NUM)
2028: THEN
2029: x_cra_rec.program_id := l_cra_rec.program_id;
2030: END IF;
2031: IF (x_cra_rec.program_update_date = OKL_API.G_MISS_DATE)
2032: THEN
2033: x_cra_rec.program_update_date := l_cra_rec.program_update_date;
2034: END IF;
2035: IF (x_cra_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 2035: IF (x_cra_rec.attribute_category = OKL_API.G_MISS_CHAR)

2031: IF (x_cra_rec.program_update_date = OKL_API.G_MISS_DATE)
2032: THEN
2033: x_cra_rec.program_update_date := l_cra_rec.program_update_date;
2034: END IF;
2035: IF (x_cra_rec.attribute_category = OKL_API.G_MISS_CHAR)
2036: THEN
2037: x_cra_rec.attribute_category := l_cra_rec.attribute_category;
2038: END IF;
2039: IF (x_cra_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 2039: IF (x_cra_rec.attribute1 = OKL_API.G_MISS_CHAR)

2035: IF (x_cra_rec.attribute_category = OKL_API.G_MISS_CHAR)
2036: THEN
2037: x_cra_rec.attribute_category := l_cra_rec.attribute_category;
2038: END IF;
2039: IF (x_cra_rec.attribute1 = OKL_API.G_MISS_CHAR)
2040: THEN
2041: x_cra_rec.attribute1 := l_cra_rec.attribute1;
2042: END IF;
2043: IF (x_cra_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 2043: IF (x_cra_rec.attribute2 = OKL_API.G_MISS_CHAR)

2039: IF (x_cra_rec.attribute1 = OKL_API.G_MISS_CHAR)
2040: THEN
2041: x_cra_rec.attribute1 := l_cra_rec.attribute1;
2042: END IF;
2043: IF (x_cra_rec.attribute2 = OKL_API.G_MISS_CHAR)
2044: THEN
2045: x_cra_rec.attribute2 := l_cra_rec.attribute2;
2046: END IF;
2047: IF (x_cra_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 2047: IF (x_cra_rec.attribute3 = OKL_API.G_MISS_CHAR)

2043: IF (x_cra_rec.attribute2 = OKL_API.G_MISS_CHAR)
2044: THEN
2045: x_cra_rec.attribute2 := l_cra_rec.attribute2;
2046: END IF;
2047: IF (x_cra_rec.attribute3 = OKL_API.G_MISS_CHAR)
2048: THEN
2049: x_cra_rec.attribute3 := l_cra_rec.attribute3;
2050: END IF;
2051: IF (x_cra_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 2051: IF (x_cra_rec.attribute4 = OKL_API.G_MISS_CHAR)

2047: IF (x_cra_rec.attribute3 = OKL_API.G_MISS_CHAR)
2048: THEN
2049: x_cra_rec.attribute3 := l_cra_rec.attribute3;
2050: END IF;
2051: IF (x_cra_rec.attribute4 = OKL_API.G_MISS_CHAR)
2052: THEN
2053: x_cra_rec.attribute4 := l_cra_rec.attribute4;
2054: END IF;
2055: IF (x_cra_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 2055: IF (x_cra_rec.attribute5 = OKL_API.G_MISS_CHAR)

2051: IF (x_cra_rec.attribute4 = OKL_API.G_MISS_CHAR)
2052: THEN
2053: x_cra_rec.attribute4 := l_cra_rec.attribute4;
2054: END IF;
2055: IF (x_cra_rec.attribute5 = OKL_API.G_MISS_CHAR)
2056: THEN
2057: x_cra_rec.attribute5 := l_cra_rec.attribute5;
2058: END IF;
2059: IF (x_cra_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 2059: IF (x_cra_rec.attribute6 = OKL_API.G_MISS_CHAR)

2055: IF (x_cra_rec.attribute5 = OKL_API.G_MISS_CHAR)
2056: THEN
2057: x_cra_rec.attribute5 := l_cra_rec.attribute5;
2058: END IF;
2059: IF (x_cra_rec.attribute6 = OKL_API.G_MISS_CHAR)
2060: THEN
2061: x_cra_rec.attribute6 := l_cra_rec.attribute6;
2062: END IF;
2063: IF (x_cra_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 2063: IF (x_cra_rec.attribute7 = OKL_API.G_MISS_CHAR)

2059: IF (x_cra_rec.attribute6 = OKL_API.G_MISS_CHAR)
2060: THEN
2061: x_cra_rec.attribute6 := l_cra_rec.attribute6;
2062: END IF;
2063: IF (x_cra_rec.attribute7 = OKL_API.G_MISS_CHAR)
2064: THEN
2065: x_cra_rec.attribute7 := l_cra_rec.attribute7;
2066: END IF;
2067: IF (x_cra_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 2067: IF (x_cra_rec.attribute8 = OKL_API.G_MISS_CHAR)

2063: IF (x_cra_rec.attribute7 = OKL_API.G_MISS_CHAR)
2064: THEN
2065: x_cra_rec.attribute7 := l_cra_rec.attribute7;
2066: END IF;
2067: IF (x_cra_rec.attribute8 = OKL_API.G_MISS_CHAR)
2068: THEN
2069: x_cra_rec.attribute8 := l_cra_rec.attribute8;
2070: END IF;
2071: IF (x_cra_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 2071: IF (x_cra_rec.attribute9 = OKL_API.G_MISS_CHAR)

2067: IF (x_cra_rec.attribute8 = OKL_API.G_MISS_CHAR)
2068: THEN
2069: x_cra_rec.attribute8 := l_cra_rec.attribute8;
2070: END IF;
2071: IF (x_cra_rec.attribute9 = OKL_API.G_MISS_CHAR)
2072: THEN
2073: x_cra_rec.attribute9 := l_cra_rec.attribute9;
2074: END IF;
2075: IF (x_cra_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 2075: IF (x_cra_rec.attribute10 = OKL_API.G_MISS_CHAR)

2071: IF (x_cra_rec.attribute9 = OKL_API.G_MISS_CHAR)
2072: THEN
2073: x_cra_rec.attribute9 := l_cra_rec.attribute9;
2074: END IF;
2075: IF (x_cra_rec.attribute10 = OKL_API.G_MISS_CHAR)
2076: THEN
2077: x_cra_rec.attribute10 := l_cra_rec.attribute10;
2078: END IF;
2079: IF (x_cra_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 2079: IF (x_cra_rec.attribute11 = OKL_API.G_MISS_CHAR)

2075: IF (x_cra_rec.attribute10 = OKL_API.G_MISS_CHAR)
2076: THEN
2077: x_cra_rec.attribute10 := l_cra_rec.attribute10;
2078: END IF;
2079: IF (x_cra_rec.attribute11 = OKL_API.G_MISS_CHAR)
2080: THEN
2081: x_cra_rec.attribute11 := l_cra_rec.attribute11;
2082: END IF;
2083: IF (x_cra_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 2083: IF (x_cra_rec.attribute12 = OKL_API.G_MISS_CHAR)

2079: IF (x_cra_rec.attribute11 = OKL_API.G_MISS_CHAR)
2080: THEN
2081: x_cra_rec.attribute11 := l_cra_rec.attribute11;
2082: END IF;
2083: IF (x_cra_rec.attribute12 = OKL_API.G_MISS_CHAR)
2084: THEN
2085: x_cra_rec.attribute12 := l_cra_rec.attribute12;
2086: END IF;
2087: IF (x_cra_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 2087: IF (x_cra_rec.attribute13 = OKL_API.G_MISS_CHAR)

2083: IF (x_cra_rec.attribute12 = OKL_API.G_MISS_CHAR)
2084: THEN
2085: x_cra_rec.attribute12 := l_cra_rec.attribute12;
2086: END IF;
2087: IF (x_cra_rec.attribute13 = OKL_API.G_MISS_CHAR)
2088: THEN
2089: x_cra_rec.attribute13 := l_cra_rec.attribute13;
2090: END IF;
2091: IF (x_cra_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 2091: IF (x_cra_rec.attribute14 = OKL_API.G_MISS_CHAR)

2087: IF (x_cra_rec.attribute13 = OKL_API.G_MISS_CHAR)
2088: THEN
2089: x_cra_rec.attribute13 := l_cra_rec.attribute13;
2090: END IF;
2091: IF (x_cra_rec.attribute14 = OKL_API.G_MISS_CHAR)
2092: THEN
2093: x_cra_rec.attribute14 := l_cra_rec.attribute14;
2094: END IF;
2095: IF (x_cra_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 2095: IF (x_cra_rec.attribute15 = OKL_API.G_MISS_CHAR)

2091: IF (x_cra_rec.attribute14 = OKL_API.G_MISS_CHAR)
2092: THEN
2093: x_cra_rec.attribute14 := l_cra_rec.attribute14;
2094: END IF;
2095: IF (x_cra_rec.attribute15 = OKL_API.G_MISS_CHAR)
2096: THEN
2097: x_cra_rec.attribute15 := l_cra_rec.attribute15;
2098: END IF;
2099: IF (x_cra_rec.created_by = OKL_API.G_MISS_NUM)

Line 2099: IF (x_cra_rec.created_by = OKL_API.G_MISS_NUM)

2095: IF (x_cra_rec.attribute15 = OKL_API.G_MISS_CHAR)
2096: THEN
2097: x_cra_rec.attribute15 := l_cra_rec.attribute15;
2098: END IF;
2099: IF (x_cra_rec.created_by = OKL_API.G_MISS_NUM)
2100: THEN
2101: x_cra_rec.created_by := l_cra_rec.created_by;
2102: END IF;
2103: IF (x_cra_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2103: IF (x_cra_rec.creation_date = OKL_API.G_MISS_DATE)

2099: IF (x_cra_rec.created_by = OKL_API.G_MISS_NUM)
2100: THEN
2101: x_cra_rec.created_by := l_cra_rec.created_by;
2102: END IF;
2103: IF (x_cra_rec.creation_date = OKL_API.G_MISS_DATE)
2104: THEN
2105: x_cra_rec.creation_date := l_cra_rec.creation_date;
2106: END IF;
2107: IF (x_cra_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2107: IF (x_cra_rec.last_updated_by = OKL_API.G_MISS_NUM)

2103: IF (x_cra_rec.creation_date = OKL_API.G_MISS_DATE)
2104: THEN
2105: x_cra_rec.creation_date := l_cra_rec.creation_date;
2106: END IF;
2107: IF (x_cra_rec.last_updated_by = OKL_API.G_MISS_NUM)
2108: THEN
2109: x_cra_rec.last_updated_by := l_cra_rec.last_updated_by;
2110: END IF;
2111: IF (x_cra_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2111: IF (x_cra_rec.last_update_date = OKL_API.G_MISS_DATE)

2107: IF (x_cra_rec.last_updated_by = OKL_API.G_MISS_NUM)
2108: THEN
2109: x_cra_rec.last_updated_by := l_cra_rec.last_updated_by;
2110: END IF;
2111: IF (x_cra_rec.last_update_date = OKL_API.G_MISS_DATE)
2112: THEN
2113: x_cra_rec.last_update_date := l_cra_rec.last_update_date;
2114: END IF;
2115: IF (x_cra_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2115: IF (x_cra_rec.last_update_login = OKL_API.G_MISS_NUM)

2111: IF (x_cra_rec.last_update_date = OKL_API.G_MISS_DATE)
2112: THEN
2113: x_cra_rec.last_update_date := l_cra_rec.last_update_date;
2114: END IF;
2115: IF (x_cra_rec.last_update_login = OKL_API.G_MISS_NUM)
2116: THEN
2117: x_cra_rec.last_update_login := l_cra_rec.last_update_login;
2118: END IF;
2119: END IF;

Line 2129: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2125: FUNCTION Set_Attributes (
2126: p_cra_rec IN cra_rec_type,
2127: x_cra_rec OUT NOCOPY cra_rec_type
2128: ) RETURN VARCHAR2 IS
2129: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2130: BEGIN
2131: x_cra_rec := p_cra_rec;
2132: x_cra_rec.OBJECT_VERSION_NUMBER := p_cra_rec.OBJECT_VERSION_NUMBER + 1;
2133: RETURN(l_return_status);

Line 2136: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

2132: x_cra_rec.OBJECT_VERSION_NUMBER := p_cra_rec.OBJECT_VERSION_NUMBER + 1;
2133: RETURN(l_return_status);
2134: END Set_Attributes;
2135: BEGIN
2136: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2137: p_init_msg_list,
2138: '_PVT',
2139: x_return_status);
2140: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2140: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2136: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2137: p_init_msg_list,
2138: '_PVT',
2139: x_return_status);
2140: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2143: RAISE OKL_API.G_EXCEPTION_ERROR;
2144: END IF;

Line 2141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2137: p_init_msg_list,
2138: '_PVT',
2139: x_return_status);
2140: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2143: RAISE OKL_API.G_EXCEPTION_ERROR;
2144: END IF;
2145: --- Setting item attributes

Line 2142: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2138: '_PVT',
2139: x_return_status);
2140: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2143: RAISE OKL_API.G_EXCEPTION_ERROR;
2144: END IF;
2145: --- Setting item attributes
2146: l_return_status := Set_Attributes(

Line 2143: RAISE OKL_API.G_EXCEPTION_ERROR;

2139: x_return_status);
2140: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2143: RAISE OKL_API.G_EXCEPTION_ERROR;
2144: END IF;
2145: --- Setting item attributes
2146: l_return_status := Set_Attributes(
2147: p_cra_rec, -- IN

Line 2150: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2146: l_return_status := Set_Attributes(
2147: p_cra_rec, -- IN
2148: l_cra_rec); -- OUT
2149: --- If any errors happen abort API
2150: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2151: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2152: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2153: RAISE OKL_API.G_EXCEPTION_ERROR;
2154: END IF;

Line 2151: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2147: p_cra_rec, -- IN
2148: l_cra_rec); -- OUT
2149: --- If any errors happen abort API
2150: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2151: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2152: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2153: RAISE OKL_API.G_EXCEPTION_ERROR;
2154: END IF;
2155: l_return_status := populate_new_record(l_cra_rec, l_def_cra_rec);

Line 2152: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2148: l_cra_rec); -- OUT
2149: --- If any errors happen abort API
2150: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2151: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2152: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2153: RAISE OKL_API.G_EXCEPTION_ERROR;
2154: END IF;
2155: l_return_status := populate_new_record(l_cra_rec, l_def_cra_rec);
2156: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2153: RAISE OKL_API.G_EXCEPTION_ERROR;

2149: --- If any errors happen abort API
2150: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2151: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2152: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2153: RAISE OKL_API.G_EXCEPTION_ERROR;
2154: END IF;
2155: l_return_status := populate_new_record(l_cra_rec, l_def_cra_rec);
2156: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2156: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2152: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2153: RAISE OKL_API.G_EXCEPTION_ERROR;
2154: END IF;
2155: l_return_status := populate_new_record(l_cra_rec, l_def_cra_rec);
2156: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2158: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2159: RAISE OKL_API.G_EXCEPTION_ERROR;
2160: END IF;

Line 2157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2153: RAISE OKL_API.G_EXCEPTION_ERROR;
2154: END IF;
2155: l_return_status := populate_new_record(l_cra_rec, l_def_cra_rec);
2156: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2158: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2159: RAISE OKL_API.G_EXCEPTION_ERROR;
2160: END IF;
2161: UPDATE OKL_CURE_REPORT_AMOUNTS

Line 2158: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2154: END IF;
2155: l_return_status := populate_new_record(l_cra_rec, l_def_cra_rec);
2156: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2158: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2159: RAISE OKL_API.G_EXCEPTION_ERROR;
2160: END IF;
2161: UPDATE OKL_CURE_REPORT_AMOUNTS
2162: SET CURE_AMOUNT_ID = l_def_cra_rec.cure_amount_id,

Line 2159: RAISE OKL_API.G_EXCEPTION_ERROR;

2155: l_return_status := populate_new_record(l_cra_rec, l_def_cra_rec);
2156: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2158: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2159: RAISE OKL_API.G_EXCEPTION_ERROR;
2160: END IF;
2161: UPDATE OKL_CURE_REPORT_AMOUNTS
2162: SET CURE_AMOUNT_ID = l_def_cra_rec.cure_amount_id,
2163: CURE_REPORT_ID = l_def_cra_rec.cure_report_id,

Line 2205: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2201: WHERE CURE_REPORT_AMOUNT_ID = l_def_cra_rec.cure_report_amount_id;
2202:
2203: x_cra_rec := l_cra_rec;
2204: x_return_status := l_return_status;
2205: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2206: EXCEPTION
2207: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2208: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2209: (

Line 2207: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2203: x_cra_rec := l_cra_rec;
2204: x_return_status := l_return_status;
2205: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2206: EXCEPTION
2207: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2208: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2209: (
2210: l_api_name,
2211: G_PKG_NAME,

Line 2208: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2204: x_return_status := l_return_status;
2205: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2206: EXCEPTION
2207: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2208: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2209: (
2210: l_api_name,
2211: G_PKG_NAME,
2212: 'OKL_API.G_RET_STS_ERROR',

Line 2212: 'OKL_API.G_RET_STS_ERROR',

2208: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2209: (
2210: l_api_name,
2211: G_PKG_NAME,
2212: 'OKL_API.G_RET_STS_ERROR',
2213: x_msg_count,
2214: x_msg_data,
2215: '_PVT'
2216: );

Line 2217: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2213: x_msg_count,
2214: x_msg_data,
2215: '_PVT'
2216: );
2217: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2218: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2219: (
2220: l_api_name,
2221: G_PKG_NAME,

Line 2218: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2214: x_msg_data,
2215: '_PVT'
2216: );
2217: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2218: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2219: (
2220: l_api_name,
2221: G_PKG_NAME,
2222: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2222: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2218: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2219: (
2220: l_api_name,
2221: G_PKG_NAME,
2222: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2223: x_msg_count,
2224: x_msg_data,
2225: '_PVT'
2226: );

Line 2228: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2224: x_msg_data,
2225: '_PVT'
2226: );
2227: WHEN OTHERS THEN
2228: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2229: (
2230: l_api_name,
2231: G_PKG_NAME,
2232: 'OTHERS',

Line 2252: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2248: x_crav_rec OUT NOCOPY crav_rec_type) IS
2249:
2250: l_api_version CONSTANT NUMBER := 1;
2251: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2252: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2253: l_crav_rec crav_rec_type := p_crav_rec;
2254: l_def_crav_rec crav_rec_type;
2255: l_db_crav_rec crav_rec_type;
2256: l_cra_rec cra_rec_type;

Line 2279: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2275: p_crav_rec IN crav_rec_type,
2276: x_crav_rec OUT NOCOPY crav_rec_type
2277: ) RETURN VARCHAR2 IS
2278: l_row_notfound BOOLEAN := TRUE;
2279: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2280: BEGIN
2281: x_crav_rec := p_crav_rec;
2282: -- Get current database values
2283: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it

Line 2286: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

2282: -- Get current database values
2283: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2284: -- so it may be verified through LOCK_ROW.
2285: l_db_crav_rec := get_rec(p_crav_rec, l_return_status);
2286: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2287: IF (x_crav_rec.cure_report_amount_id = OKL_API.G_MISS_NUM)
2288: THEN
2289: x_crav_rec.cure_report_amount_id := l_db_crav_rec.cure_report_amount_id;
2290: END IF;

Line 2287: IF (x_crav_rec.cure_report_amount_id = OKL_API.G_MISS_NUM)

2283: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2284: -- so it may be verified through LOCK_ROW.
2285: l_db_crav_rec := get_rec(p_crav_rec, l_return_status);
2286: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2287: IF (x_crav_rec.cure_report_amount_id = OKL_API.G_MISS_NUM)
2288: THEN
2289: x_crav_rec.cure_report_amount_id := l_db_crav_rec.cure_report_amount_id;
2290: END IF;
2291: IF (x_crav_rec.cure_amount_id = OKL_API.G_MISS_NUM)

Line 2291: IF (x_crav_rec.cure_amount_id = OKL_API.G_MISS_NUM)

2287: IF (x_crav_rec.cure_report_amount_id = OKL_API.G_MISS_NUM)
2288: THEN
2289: x_crav_rec.cure_report_amount_id := l_db_crav_rec.cure_report_amount_id;
2290: END IF;
2291: IF (x_crav_rec.cure_amount_id = OKL_API.G_MISS_NUM)
2292: THEN
2293: x_crav_rec.cure_amount_id := l_db_crav_rec.cure_amount_id;
2294: END IF;
2295: IF (x_crav_rec.cure_report_id = OKL_API.G_MISS_NUM)

Line 2295: IF (x_crav_rec.cure_report_id = OKL_API.G_MISS_NUM)

2291: IF (x_crav_rec.cure_amount_id = OKL_API.G_MISS_NUM)
2292: THEN
2293: x_crav_rec.cure_amount_id := l_db_crav_rec.cure_amount_id;
2294: END IF;
2295: IF (x_crav_rec.cure_report_id = OKL_API.G_MISS_NUM)
2296: THEN
2297: x_crav_rec.cure_report_id := l_db_crav_rec.cure_report_id;
2298: END IF;
2299: IF (x_crav_rec.request_type = OKL_API.G_MISS_CHAR)

Line 2299: IF (x_crav_rec.request_type = OKL_API.G_MISS_CHAR)

2295: IF (x_crav_rec.cure_report_id = OKL_API.G_MISS_NUM)
2296: THEN
2297: x_crav_rec.cure_report_id := l_db_crav_rec.cure_report_id;
2298: END IF;
2299: IF (x_crav_rec.request_type = OKL_API.G_MISS_CHAR)
2300: THEN
2301: x_crav_rec.request_type := l_db_crav_rec.request_type;
2302: END IF;
2303: IF (x_crav_rec.cures_in_possession = OKL_API.G_MISS_NUM)

Line 2303: IF (x_crav_rec.cures_in_possession = OKL_API.G_MISS_NUM)

2299: IF (x_crav_rec.request_type = OKL_API.G_MISS_CHAR)
2300: THEN
2301: x_crav_rec.request_type := l_db_crav_rec.request_type;
2302: END IF;
2303: IF (x_crav_rec.cures_in_possession = OKL_API.G_MISS_NUM)
2304: THEN
2305: x_crav_rec.cures_in_possession := l_db_crav_rec.cures_in_possession;
2306: END IF;
2307: IF (x_crav_rec.claimed_cure_amount = OKL_API.G_MISS_NUM)

Line 2307: IF (x_crav_rec.claimed_cure_amount = OKL_API.G_MISS_NUM)

2303: IF (x_crav_rec.cures_in_possession = OKL_API.G_MISS_NUM)
2304: THEN
2305: x_crav_rec.cures_in_possession := l_db_crav_rec.cures_in_possession;
2306: END IF;
2307: IF (x_crav_rec.claimed_cure_amount = OKL_API.G_MISS_NUM)
2308: THEN
2309: x_crav_rec.claimed_cure_amount := l_db_crav_rec.claimed_cure_amount;
2310: END IF;
2311: IF (x_crav_rec.past_due_amount = OKL_API.G_MISS_NUM)

Line 2311: IF (x_crav_rec.past_due_amount = OKL_API.G_MISS_NUM)

2307: IF (x_crav_rec.claimed_cure_amount = OKL_API.G_MISS_NUM)
2308: THEN
2309: x_crav_rec.claimed_cure_amount := l_db_crav_rec.claimed_cure_amount;
2310: END IF;
2311: IF (x_crav_rec.past_due_amount = OKL_API.G_MISS_NUM)
2312: THEN
2313: x_crav_rec.past_due_amount := l_db_crav_rec.past_due_amount;
2314: END IF;
2315: IF (x_crav_rec.eligible_cure_amount = OKL_API.G_MISS_NUM)

Line 2315: IF (x_crav_rec.eligible_cure_amount = OKL_API.G_MISS_NUM)

2311: IF (x_crav_rec.past_due_amount = OKL_API.G_MISS_NUM)
2312: THEN
2313: x_crav_rec.past_due_amount := l_db_crav_rec.past_due_amount;
2314: END IF;
2315: IF (x_crav_rec.eligible_cure_amount = OKL_API.G_MISS_NUM)
2316: THEN
2317: x_crav_rec.eligible_cure_amount := l_db_crav_rec.eligible_cure_amount;
2318: END IF;
2319: IF (x_crav_rec.repurchase_amount = OKL_API.G_MISS_NUM)

Line 2319: IF (x_crav_rec.repurchase_amount = OKL_API.G_MISS_NUM)

2315: IF (x_crav_rec.eligible_cure_amount = OKL_API.G_MISS_NUM)
2316: THEN
2317: x_crav_rec.eligible_cure_amount := l_db_crav_rec.eligible_cure_amount;
2318: END IF;
2319: IF (x_crav_rec.repurchase_amount = OKL_API.G_MISS_NUM)
2320: THEN
2321: x_crav_rec.repurchase_amount := l_db_crav_rec.repurchase_amount;
2322: END IF;
2323: IF (x_crav_rec.outstanding_amount = OKL_API.G_MISS_NUM)

Line 2323: IF (x_crav_rec.outstanding_amount = OKL_API.G_MISS_NUM)

2319: IF (x_crav_rec.repurchase_amount = OKL_API.G_MISS_NUM)
2320: THEN
2321: x_crav_rec.repurchase_amount := l_db_crav_rec.repurchase_amount;
2322: END IF;
2323: IF (x_crav_rec.outstanding_amount = OKL_API.G_MISS_NUM)
2324: THEN
2325: x_crav_rec.outstanding_amount := l_db_crav_rec.outstanding_amount;
2326: END IF;
2327: IF (x_crav_rec.times_cured = OKL_API.G_MISS_NUM)

Line 2327: IF (x_crav_rec.times_cured = OKL_API.G_MISS_NUM)

2323: IF (x_crav_rec.outstanding_amount = OKL_API.G_MISS_NUM)
2324: THEN
2325: x_crav_rec.outstanding_amount := l_db_crav_rec.outstanding_amount;
2326: END IF;
2327: IF (x_crav_rec.times_cured = OKL_API.G_MISS_NUM)
2328: THEN
2329: x_crav_rec.times_cured := l_db_crav_rec.times_cured;
2330: END IF;
2331: IF (x_crav_rec.payments_remaining = OKL_API.G_MISS_NUM)

Line 2331: IF (x_crav_rec.payments_remaining = OKL_API.G_MISS_NUM)

2327: IF (x_crav_rec.times_cured = OKL_API.G_MISS_NUM)
2328: THEN
2329: x_crav_rec.times_cured := l_db_crav_rec.times_cured;
2330: END IF;
2331: IF (x_crav_rec.payments_remaining = OKL_API.G_MISS_NUM)
2332: THEN
2333: x_crav_rec.payments_remaining := l_db_crav_rec.payments_remaining;
2334: END IF;
2335: IF (x_crav_rec.status = OKL_API.G_MISS_CHAR)

Line 2335: IF (x_crav_rec.status = OKL_API.G_MISS_CHAR)

2331: IF (x_crav_rec.payments_remaining = OKL_API.G_MISS_NUM)
2332: THEN
2333: x_crav_rec.payments_remaining := l_db_crav_rec.payments_remaining;
2334: END IF;
2335: IF (x_crav_rec.status = OKL_API.G_MISS_CHAR)
2336: THEN
2337: x_crav_rec.status := l_db_crav_rec.status;
2338: END IF;
2339: IF (x_crav_rec.org_id = OKL_API.G_MISS_NUM)

Line 2339: IF (x_crav_rec.org_id = OKL_API.G_MISS_NUM)

2335: IF (x_crav_rec.status = OKL_API.G_MISS_CHAR)
2336: THEN
2337: x_crav_rec.status := l_db_crav_rec.status;
2338: END IF;
2339: IF (x_crav_rec.org_id = OKL_API.G_MISS_NUM)
2340: THEN
2341: x_crav_rec.org_id := l_db_crav_rec.org_id;
2342: END IF;
2343: IF (x_crav_rec.request_id = OKL_API.G_MISS_NUM)

Line 2343: IF (x_crav_rec.request_id = OKL_API.G_MISS_NUM)

2339: IF (x_crav_rec.org_id = OKL_API.G_MISS_NUM)
2340: THEN
2341: x_crav_rec.org_id := l_db_crav_rec.org_id;
2342: END IF;
2343: IF (x_crav_rec.request_id = OKL_API.G_MISS_NUM)
2344: THEN
2345: x_crav_rec.request_id := l_db_crav_rec.request_id;
2346: END IF;
2347: IF (x_crav_rec.program_application_id = OKL_API.G_MISS_NUM)

Line 2347: IF (x_crav_rec.program_application_id = OKL_API.G_MISS_NUM)

2343: IF (x_crav_rec.request_id = OKL_API.G_MISS_NUM)
2344: THEN
2345: x_crav_rec.request_id := l_db_crav_rec.request_id;
2346: END IF;
2347: IF (x_crav_rec.program_application_id = OKL_API.G_MISS_NUM)
2348: THEN
2349: x_crav_rec.program_application_id := l_db_crav_rec.program_application_id;
2350: END IF;
2351: IF (x_crav_rec.program_id = OKL_API.G_MISS_NUM)

Line 2351: IF (x_crav_rec.program_id = OKL_API.G_MISS_NUM)

2347: IF (x_crav_rec.program_application_id = OKL_API.G_MISS_NUM)
2348: THEN
2349: x_crav_rec.program_application_id := l_db_crav_rec.program_application_id;
2350: END IF;
2351: IF (x_crav_rec.program_id = OKL_API.G_MISS_NUM)
2352: THEN
2353: x_crav_rec.program_id := l_db_crav_rec.program_id;
2354: END IF;
2355: IF (x_crav_rec.program_update_date = OKL_API.G_MISS_DATE)

Line 2355: IF (x_crav_rec.program_update_date = OKL_API.G_MISS_DATE)

2351: IF (x_crav_rec.program_id = OKL_API.G_MISS_NUM)
2352: THEN
2353: x_crav_rec.program_id := l_db_crav_rec.program_id;
2354: END IF;
2355: IF (x_crav_rec.program_update_date = OKL_API.G_MISS_DATE)
2356: THEN
2357: x_crav_rec.program_update_date := l_db_crav_rec.program_update_date;
2358: END IF;
2359: IF (x_crav_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 2359: IF (x_crav_rec.attribute_category = OKL_API.G_MISS_CHAR)

2355: IF (x_crav_rec.program_update_date = OKL_API.G_MISS_DATE)
2356: THEN
2357: x_crav_rec.program_update_date := l_db_crav_rec.program_update_date;
2358: END IF;
2359: IF (x_crav_rec.attribute_category = OKL_API.G_MISS_CHAR)
2360: THEN
2361: x_crav_rec.attribute_category := l_db_crav_rec.attribute_category;
2362: END IF;
2363: IF (x_crav_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 2363: IF (x_crav_rec.attribute1 = OKL_API.G_MISS_CHAR)

2359: IF (x_crav_rec.attribute_category = OKL_API.G_MISS_CHAR)
2360: THEN
2361: x_crav_rec.attribute_category := l_db_crav_rec.attribute_category;
2362: END IF;
2363: IF (x_crav_rec.attribute1 = OKL_API.G_MISS_CHAR)
2364: THEN
2365: x_crav_rec.attribute1 := l_db_crav_rec.attribute1;
2366: END IF;
2367: IF (x_crav_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 2367: IF (x_crav_rec.attribute2 = OKL_API.G_MISS_CHAR)

2363: IF (x_crav_rec.attribute1 = OKL_API.G_MISS_CHAR)
2364: THEN
2365: x_crav_rec.attribute1 := l_db_crav_rec.attribute1;
2366: END IF;
2367: IF (x_crav_rec.attribute2 = OKL_API.G_MISS_CHAR)
2368: THEN
2369: x_crav_rec.attribute2 := l_db_crav_rec.attribute2;
2370: END IF;
2371: IF (x_crav_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 2371: IF (x_crav_rec.attribute3 = OKL_API.G_MISS_CHAR)

2367: IF (x_crav_rec.attribute2 = OKL_API.G_MISS_CHAR)
2368: THEN
2369: x_crav_rec.attribute2 := l_db_crav_rec.attribute2;
2370: END IF;
2371: IF (x_crav_rec.attribute3 = OKL_API.G_MISS_CHAR)
2372: THEN
2373: x_crav_rec.attribute3 := l_db_crav_rec.attribute3;
2374: END IF;
2375: IF (x_crav_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 2375: IF (x_crav_rec.attribute4 = OKL_API.G_MISS_CHAR)

2371: IF (x_crav_rec.attribute3 = OKL_API.G_MISS_CHAR)
2372: THEN
2373: x_crav_rec.attribute3 := l_db_crav_rec.attribute3;
2374: END IF;
2375: IF (x_crav_rec.attribute4 = OKL_API.G_MISS_CHAR)
2376: THEN
2377: x_crav_rec.attribute4 := l_db_crav_rec.attribute4;
2378: END IF;
2379: IF (x_crav_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 2379: IF (x_crav_rec.attribute5 = OKL_API.G_MISS_CHAR)

2375: IF (x_crav_rec.attribute4 = OKL_API.G_MISS_CHAR)
2376: THEN
2377: x_crav_rec.attribute4 := l_db_crav_rec.attribute4;
2378: END IF;
2379: IF (x_crav_rec.attribute5 = OKL_API.G_MISS_CHAR)
2380: THEN
2381: x_crav_rec.attribute5 := l_db_crav_rec.attribute5;
2382: END IF;
2383: IF (x_crav_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 2383: IF (x_crav_rec.attribute6 = OKL_API.G_MISS_CHAR)

2379: IF (x_crav_rec.attribute5 = OKL_API.G_MISS_CHAR)
2380: THEN
2381: x_crav_rec.attribute5 := l_db_crav_rec.attribute5;
2382: END IF;
2383: IF (x_crav_rec.attribute6 = OKL_API.G_MISS_CHAR)
2384: THEN
2385: x_crav_rec.attribute6 := l_db_crav_rec.attribute6;
2386: END IF;
2387: IF (x_crav_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 2387: IF (x_crav_rec.attribute7 = OKL_API.G_MISS_CHAR)

2383: IF (x_crav_rec.attribute6 = OKL_API.G_MISS_CHAR)
2384: THEN
2385: x_crav_rec.attribute6 := l_db_crav_rec.attribute6;
2386: END IF;
2387: IF (x_crav_rec.attribute7 = OKL_API.G_MISS_CHAR)
2388: THEN
2389: x_crav_rec.attribute7 := l_db_crav_rec.attribute7;
2390: END IF;
2391: IF (x_crav_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 2391: IF (x_crav_rec.attribute8 = OKL_API.G_MISS_CHAR)

2387: IF (x_crav_rec.attribute7 = OKL_API.G_MISS_CHAR)
2388: THEN
2389: x_crav_rec.attribute7 := l_db_crav_rec.attribute7;
2390: END IF;
2391: IF (x_crav_rec.attribute8 = OKL_API.G_MISS_CHAR)
2392: THEN
2393: x_crav_rec.attribute8 := l_db_crav_rec.attribute8;
2394: END IF;
2395: IF (x_crav_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 2395: IF (x_crav_rec.attribute9 = OKL_API.G_MISS_CHAR)

2391: IF (x_crav_rec.attribute8 = OKL_API.G_MISS_CHAR)
2392: THEN
2393: x_crav_rec.attribute8 := l_db_crav_rec.attribute8;
2394: END IF;
2395: IF (x_crav_rec.attribute9 = OKL_API.G_MISS_CHAR)
2396: THEN
2397: x_crav_rec.attribute9 := l_db_crav_rec.attribute9;
2398: END IF;
2399: IF (x_crav_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 2399: IF (x_crav_rec.attribute10 = OKL_API.G_MISS_CHAR)

2395: IF (x_crav_rec.attribute9 = OKL_API.G_MISS_CHAR)
2396: THEN
2397: x_crav_rec.attribute9 := l_db_crav_rec.attribute9;
2398: END IF;
2399: IF (x_crav_rec.attribute10 = OKL_API.G_MISS_CHAR)
2400: THEN
2401: x_crav_rec.attribute10 := l_db_crav_rec.attribute10;
2402: END IF;
2403: IF (x_crav_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 2403: IF (x_crav_rec.attribute11 = OKL_API.G_MISS_CHAR)

2399: IF (x_crav_rec.attribute10 = OKL_API.G_MISS_CHAR)
2400: THEN
2401: x_crav_rec.attribute10 := l_db_crav_rec.attribute10;
2402: END IF;
2403: IF (x_crav_rec.attribute11 = OKL_API.G_MISS_CHAR)
2404: THEN
2405: x_crav_rec.attribute11 := l_db_crav_rec.attribute11;
2406: END IF;
2407: IF (x_crav_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 2407: IF (x_crav_rec.attribute12 = OKL_API.G_MISS_CHAR)

2403: IF (x_crav_rec.attribute11 = OKL_API.G_MISS_CHAR)
2404: THEN
2405: x_crav_rec.attribute11 := l_db_crav_rec.attribute11;
2406: END IF;
2407: IF (x_crav_rec.attribute12 = OKL_API.G_MISS_CHAR)
2408: THEN
2409: x_crav_rec.attribute12 := l_db_crav_rec.attribute12;
2410: END IF;
2411: IF (x_crav_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 2411: IF (x_crav_rec.attribute13 = OKL_API.G_MISS_CHAR)

2407: IF (x_crav_rec.attribute12 = OKL_API.G_MISS_CHAR)
2408: THEN
2409: x_crav_rec.attribute12 := l_db_crav_rec.attribute12;
2410: END IF;
2411: IF (x_crav_rec.attribute13 = OKL_API.G_MISS_CHAR)
2412: THEN
2413: x_crav_rec.attribute13 := l_db_crav_rec.attribute13;
2414: END IF;
2415: IF (x_crav_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 2415: IF (x_crav_rec.attribute14 = OKL_API.G_MISS_CHAR)

2411: IF (x_crav_rec.attribute13 = OKL_API.G_MISS_CHAR)
2412: THEN
2413: x_crav_rec.attribute13 := l_db_crav_rec.attribute13;
2414: END IF;
2415: IF (x_crav_rec.attribute14 = OKL_API.G_MISS_CHAR)
2416: THEN
2417: x_crav_rec.attribute14 := l_db_crav_rec.attribute14;
2418: END IF;
2419: IF (x_crav_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 2419: IF (x_crav_rec.attribute15 = OKL_API.G_MISS_CHAR)

2415: IF (x_crav_rec.attribute14 = OKL_API.G_MISS_CHAR)
2416: THEN
2417: x_crav_rec.attribute14 := l_db_crav_rec.attribute14;
2418: END IF;
2419: IF (x_crav_rec.attribute15 = OKL_API.G_MISS_CHAR)
2420: THEN
2421: x_crav_rec.attribute15 := l_db_crav_rec.attribute15;
2422: END IF;
2423: IF (x_crav_rec.created_by = OKL_API.G_MISS_NUM)

Line 2423: IF (x_crav_rec.created_by = OKL_API.G_MISS_NUM)

2419: IF (x_crav_rec.attribute15 = OKL_API.G_MISS_CHAR)
2420: THEN
2421: x_crav_rec.attribute15 := l_db_crav_rec.attribute15;
2422: END IF;
2423: IF (x_crav_rec.created_by = OKL_API.G_MISS_NUM)
2424: THEN
2425: x_crav_rec.created_by := l_db_crav_rec.created_by;
2426: END IF;
2427: IF (x_crav_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2427: IF (x_crav_rec.creation_date = OKL_API.G_MISS_DATE)

2423: IF (x_crav_rec.created_by = OKL_API.G_MISS_NUM)
2424: THEN
2425: x_crav_rec.created_by := l_db_crav_rec.created_by;
2426: END IF;
2427: IF (x_crav_rec.creation_date = OKL_API.G_MISS_DATE)
2428: THEN
2429: x_crav_rec.creation_date := l_db_crav_rec.creation_date;
2430: END IF;
2431: IF (x_crav_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2431: IF (x_crav_rec.last_updated_by = OKL_API.G_MISS_NUM)

2427: IF (x_crav_rec.creation_date = OKL_API.G_MISS_DATE)
2428: THEN
2429: x_crav_rec.creation_date := l_db_crav_rec.creation_date;
2430: END IF;
2431: IF (x_crav_rec.last_updated_by = OKL_API.G_MISS_NUM)
2432: THEN
2433: x_crav_rec.last_updated_by := l_db_crav_rec.last_updated_by;
2434: END IF;
2435: IF (x_crav_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2435: IF (x_crav_rec.last_update_date = OKL_API.G_MISS_DATE)

2431: IF (x_crav_rec.last_updated_by = OKL_API.G_MISS_NUM)
2432: THEN
2433: x_crav_rec.last_updated_by := l_db_crav_rec.last_updated_by;
2434: END IF;
2435: IF (x_crav_rec.last_update_date = OKL_API.G_MISS_DATE)
2436: THEN
2437: x_crav_rec.last_update_date := l_db_crav_rec.last_update_date;
2438: END IF;
2439: IF (x_crav_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2439: IF (x_crav_rec.last_update_login = OKL_API.G_MISS_NUM)

2435: IF (x_crav_rec.last_update_date = OKL_API.G_MISS_DATE)
2436: THEN
2437: x_crav_rec.last_update_date := l_db_crav_rec.last_update_date;
2438: END IF;
2439: IF (x_crav_rec.last_update_login = OKL_API.G_MISS_NUM)
2440: THEN
2441: x_crav_rec.last_update_login := l_db_crav_rec.last_update_login;
2442: END IF;
2443: END IF;

Line 2453: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2449: FUNCTION Set_Attributes (
2450: p_crav_rec IN crav_rec_type,
2451: x_crav_rec OUT NOCOPY crav_rec_type
2452: ) RETURN VARCHAR2 IS
2453: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2454: BEGIN
2455: x_crav_rec := p_crav_rec;
2456: RETURN(l_return_status);
2457: END Set_Attributes;

Line 2459: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

2455: x_crav_rec := p_crav_rec;
2456: RETURN(l_return_status);
2457: END Set_Attributes;
2458: BEGIN
2459: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2460: G_PKG_NAME,
2461: p_init_msg_list,
2462: l_api_version,
2463: p_api_version,

Line 2466: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2462: l_api_version,
2463: p_api_version,
2464: '_PVT',
2465: x_return_status);
2466: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2467: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2468: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2469: RAISE OKL_API.G_EXCEPTION_ERROR;
2470: END IF;

Line 2467: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2463: p_api_version,
2464: '_PVT',
2465: x_return_status);
2466: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2467: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2468: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2469: RAISE OKL_API.G_EXCEPTION_ERROR;
2470: END IF;
2471: --- Setting item attributes

Line 2468: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2464: '_PVT',
2465: x_return_status);
2466: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2467: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2468: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2469: RAISE OKL_API.G_EXCEPTION_ERROR;
2470: END IF;
2471: --- Setting item attributes
2472: l_return_status := Set_Attributes(

Line 2469: RAISE OKL_API.G_EXCEPTION_ERROR;

2465: x_return_status);
2466: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2467: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2468: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2469: RAISE OKL_API.G_EXCEPTION_ERROR;
2470: END IF;
2471: --- Setting item attributes
2472: l_return_status := Set_Attributes(
2473: p_crav_rec, -- IN

Line 2476: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2472: l_return_status := Set_Attributes(
2473: p_crav_rec, -- IN
2474: x_crav_rec); -- OUT
2475: --- If any errors happen abort API
2476: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2478: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2479: RAISE OKL_API.G_EXCEPTION_ERROR;
2480: END IF;

Line 2477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2473: p_crav_rec, -- IN
2474: x_crav_rec); -- OUT
2475: --- If any errors happen abort API
2476: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2478: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2479: RAISE OKL_API.G_EXCEPTION_ERROR;
2480: END IF;
2481: l_return_status := populate_new_record(l_crav_rec, l_def_crav_rec);

Line 2478: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2474: x_crav_rec); -- OUT
2475: --- If any errors happen abort API
2476: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2478: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2479: RAISE OKL_API.G_EXCEPTION_ERROR;
2480: END IF;
2481: l_return_status := populate_new_record(l_crav_rec, l_def_crav_rec);
2482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2479: RAISE OKL_API.G_EXCEPTION_ERROR;

2475: --- If any errors happen abort API
2476: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2477: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2478: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2479: RAISE OKL_API.G_EXCEPTION_ERROR;
2480: END IF;
2481: l_return_status := populate_new_record(l_crav_rec, l_def_crav_rec);
2482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2478: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2479: RAISE OKL_API.G_EXCEPTION_ERROR;
2480: END IF;
2481: l_return_status := populate_new_record(l_crav_rec, l_def_crav_rec);
2482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2484: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2485: RAISE OKL_API.G_EXCEPTION_ERROR;
2486: END IF;

Line 2483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2479: RAISE OKL_API.G_EXCEPTION_ERROR;
2480: END IF;
2481: l_return_status := populate_new_record(l_crav_rec, l_def_crav_rec);
2482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2484: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2485: RAISE OKL_API.G_EXCEPTION_ERROR;
2486: END IF;
2487: l_def_crav_rec := fill_who_columns(l_def_crav_rec);

Line 2484: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2480: END IF;
2481: l_return_status := populate_new_record(l_crav_rec, l_def_crav_rec);
2482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2484: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2485: RAISE OKL_API.G_EXCEPTION_ERROR;
2486: END IF;
2487: l_def_crav_rec := fill_who_columns(l_def_crav_rec);
2488: --- Validate all non-missing attributes (Item Level Validation)

Line 2485: RAISE OKL_API.G_EXCEPTION_ERROR;

2481: l_return_status := populate_new_record(l_crav_rec, l_def_crav_rec);
2482: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2484: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2485: RAISE OKL_API.G_EXCEPTION_ERROR;
2486: END IF;
2487: l_def_crav_rec := fill_who_columns(l_def_crav_rec);
2488: --- Validate all non-missing attributes (Item Level Validation)
2489: l_return_status := Validate_Attributes(l_def_crav_rec);

Line 2491: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2487: l_def_crav_rec := fill_who_columns(l_def_crav_rec);
2488: --- Validate all non-missing attributes (Item Level Validation)
2489: l_return_status := Validate_Attributes(l_def_crav_rec);
2490: --- If any errors happen abort API
2491: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2492: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2493: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2494: RAISE OKL_API.G_EXCEPTION_ERROR;
2495: END IF;

Line 2492: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2488: --- Validate all non-missing attributes (Item Level Validation)
2489: l_return_status := Validate_Attributes(l_def_crav_rec);
2490: --- If any errors happen abort API
2491: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2492: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2493: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2494: RAISE OKL_API.G_EXCEPTION_ERROR;
2495: END IF;
2496: l_return_status := Validate_Record(l_def_crav_rec, l_db_crav_rec);

Line 2493: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2489: l_return_status := Validate_Attributes(l_def_crav_rec);
2490: --- If any errors happen abort API
2491: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2492: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2493: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2494: RAISE OKL_API.G_EXCEPTION_ERROR;
2495: END IF;
2496: l_return_status := Validate_Record(l_def_crav_rec, l_db_crav_rec);
2497: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2494: RAISE OKL_API.G_EXCEPTION_ERROR;

2490: --- If any errors happen abort API
2491: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2492: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2493: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2494: RAISE OKL_API.G_EXCEPTION_ERROR;
2495: END IF;
2496: l_return_status := Validate_Record(l_def_crav_rec, l_db_crav_rec);
2497: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2497: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2493: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2494: RAISE OKL_API.G_EXCEPTION_ERROR;
2495: END IF;
2496: l_return_status := Validate_Record(l_def_crav_rec, l_db_crav_rec);
2497: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2499: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2500: RAISE OKL_API.G_EXCEPTION_ERROR;
2501: END IF;

Line 2498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2494: RAISE OKL_API.G_EXCEPTION_ERROR;
2495: END IF;
2496: l_return_status := Validate_Record(l_def_crav_rec, l_db_crav_rec);
2497: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2499: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2500: RAISE OKL_API.G_EXCEPTION_ERROR;
2501: END IF;
2502:

Line 2499: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2495: END IF;
2496: l_return_status := Validate_Record(l_def_crav_rec, l_db_crav_rec);
2497: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2499: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2500: RAISE OKL_API.G_EXCEPTION_ERROR;
2501: END IF;
2502:
2503: -- Lock the Record

Line 2500: RAISE OKL_API.G_EXCEPTION_ERROR;

2496: l_return_status := Validate_Record(l_def_crav_rec, l_db_crav_rec);
2497: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2499: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2500: RAISE OKL_API.G_EXCEPTION_ERROR;
2501: END IF;
2502:
2503: -- Lock the Record
2504: lock_row(

Line 2511: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2507: x_return_status => l_return_status,
2508: x_msg_count => x_msg_count,
2509: x_msg_data => x_msg_data,
2510: p_crav_rec => p_crav_rec);
2511: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2512: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2513: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2514: RAISE OKL_API.G_EXCEPTION_ERROR;
2515: END IF;

Line 2512: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2508: x_msg_count => x_msg_count,
2509: x_msg_data => x_msg_data,
2510: p_crav_rec => p_crav_rec);
2511: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2512: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2513: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2514: RAISE OKL_API.G_EXCEPTION_ERROR;
2515: END IF;
2516:

Line 2513: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2509: x_msg_data => x_msg_data,
2510: p_crav_rec => p_crav_rec);
2511: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2512: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2513: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2514: RAISE OKL_API.G_EXCEPTION_ERROR;
2515: END IF;
2516:
2517: -----------------------------------------

Line 2514: RAISE OKL_API.G_EXCEPTION_ERROR;

2510: p_crav_rec => p_crav_rec);
2511: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2512: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2513: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2514: RAISE OKL_API.G_EXCEPTION_ERROR;
2515: END IF;
2516:
2517: -----------------------------------------
2518: -- Move VIEW record to "Child" records --

Line 2532: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2528: x_msg_data,
2529: l_cra_rec,
2530: lx_cra_rec
2531: );
2532: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2533: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2534: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2535: RAISE OKL_API.G_EXCEPTION_ERROR;
2536: END IF;

Line 2533: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2529: l_cra_rec,
2530: lx_cra_rec
2531: );
2532: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2533: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2534: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2535: RAISE OKL_API.G_EXCEPTION_ERROR;
2536: END IF;
2537: migrate(lx_cra_rec, l_def_crav_rec);

Line 2534: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2530: lx_cra_rec
2531: );
2532: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2533: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2534: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2535: RAISE OKL_API.G_EXCEPTION_ERROR;
2536: END IF;
2537: migrate(lx_cra_rec, l_def_crav_rec);
2538: x_crav_rec := l_def_crav_rec;

Line 2535: RAISE OKL_API.G_EXCEPTION_ERROR;

2531: );
2532: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2533: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2534: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2535: RAISE OKL_API.G_EXCEPTION_ERROR;
2536: END IF;
2537: migrate(lx_cra_rec, l_def_crav_rec);
2538: x_crav_rec := l_def_crav_rec;
2539: x_return_status := l_return_status;

Line 2540: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2536: END IF;
2537: migrate(lx_cra_rec, l_def_crav_rec);
2538: x_crav_rec := l_def_crav_rec;
2539: x_return_status := l_return_status;
2540: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2541: EXCEPTION
2542: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2543: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2544: (

Line 2542: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2538: x_crav_rec := l_def_crav_rec;
2539: x_return_status := l_return_status;
2540: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2541: EXCEPTION
2542: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2543: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2544: (
2545: l_api_name,
2546: G_PKG_NAME,

Line 2543: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2539: x_return_status := l_return_status;
2540: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2541: EXCEPTION
2542: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2543: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2544: (
2545: l_api_name,
2546: G_PKG_NAME,
2547: 'OKL_API.G_RET_STS_ERROR',

Line 2547: 'OKL_API.G_RET_STS_ERROR',

2543: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2544: (
2545: l_api_name,
2546: G_PKG_NAME,
2547: 'OKL_API.G_RET_STS_ERROR',
2548: x_msg_count,
2549: x_msg_data,
2550: '_PVT'
2551: );

Line 2552: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2548: x_msg_count,
2549: x_msg_data,
2550: '_PVT'
2551: );
2552: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2553: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2554: (
2555: l_api_name,
2556: G_PKG_NAME,

Line 2553: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2549: x_msg_data,
2550: '_PVT'
2551: );
2552: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2553: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2554: (
2555: l_api_name,
2556: G_PKG_NAME,
2557: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2557: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2553: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2554: (
2555: l_api_name,
2556: G_PKG_NAME,
2557: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2558: x_msg_count,
2559: x_msg_data,
2560: '_PVT'
2561: );

Line 2563: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2559: x_msg_data,
2560: '_PVT'
2561: );
2562: WHEN OTHERS THEN
2563: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2564: (
2565: l_api_name,
2566: G_PKG_NAME,
2567: 'OTHERS',

Line 2584: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

2580: x_msg_count OUT NOCOPY NUMBER,
2581: x_msg_data OUT NOCOPY VARCHAR2,
2582: p_crav_tbl IN crav_tbl_type,
2583: x_crav_tbl OUT NOCOPY crav_tbl_type,
2584: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2585:
2586: l_api_version CONSTANT NUMBER := 1;
2587: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2588: i NUMBER := 0;

Line 2590: OKL_API.init_msg_list(p_init_msg_list);

2586: l_api_version CONSTANT NUMBER := 1;
2587: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2588: i NUMBER := 0;
2589: BEGIN
2590: OKL_API.init_msg_list(p_init_msg_list);
2591: -- Make sure PL/SQL table has records in it before passing
2592: IF (p_crav_tbl.COUNT > 0) THEN
2593: i := p_crav_tbl.FIRST;
2594: LOOP

Line 2596: l_error_rec OKL_API.ERROR_REC_TYPE;

2592: IF (p_crav_tbl.COUNT > 0) THEN
2593: i := p_crav_tbl.FIRST;
2594: LOOP
2595: DECLARE
2596: l_error_rec OKL_API.ERROR_REC_TYPE;
2597: BEGIN
2598: l_error_rec.api_name := l_api_name;
2599: l_error_rec.api_package := G_PKG_NAME;
2600: l_error_rec.idx := i;

Line 2603: p_init_msg_list => OKL_API.G_FALSE,

2599: l_error_rec.api_package := G_PKG_NAME;
2600: l_error_rec.idx := i;
2601: update_row (
2602: p_api_version => p_api_version,
2603: p_init_msg_list => OKL_API.G_FALSE,
2604: x_return_status => l_error_rec.error_type,
2605: x_msg_count => l_error_rec.msg_count,
2606: x_msg_data => l_error_rec.msg_data,
2607: p_crav_rec => p_crav_tbl(i),

Line 2609: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN

2605: x_msg_count => l_error_rec.msg_count,
2606: x_msg_data => l_error_rec.msg_data,
2607: p_crav_rec => p_crav_tbl(i),
2608: x_crav_rec => x_crav_tbl(i));
2609: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
2610: l_error_rec.sqlcode := SQLCODE;
2611: load_error_tbl(l_error_rec, px_error_tbl);
2612: ELSE
2613: x_msg_count := l_error_rec.msg_count;

Line 2617: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2613: x_msg_count := l_error_rec.msg_count;
2614: x_msg_data := l_error_rec.msg_data;
2615: END IF;
2616: EXCEPTION
2617: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2618: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2619: l_error_rec.sqlcode := SQLCODE;
2620: load_error_tbl(l_error_rec, px_error_tbl);
2621: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2618: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;

2614: x_msg_data := l_error_rec.msg_data;
2615: END IF;
2616: EXCEPTION
2617: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2618: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2619: l_error_rec.sqlcode := SQLCODE;
2620: load_error_tbl(l_error_rec, px_error_tbl);
2621: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2622: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2621: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2617: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2618: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2619: l_error_rec.sqlcode := SQLCODE;
2620: load_error_tbl(l_error_rec, px_error_tbl);
2621: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2622: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2623: l_error_rec.sqlcode := SQLCODE;
2624: load_error_tbl(l_error_rec, px_error_tbl);
2625: WHEN OTHERS THEN

Line 2622: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

2618: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2619: l_error_rec.sqlcode := SQLCODE;
2620: load_error_tbl(l_error_rec, px_error_tbl);
2621: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2622: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2623: l_error_rec.sqlcode := SQLCODE;
2624: load_error_tbl(l_error_rec, px_error_tbl);
2625: WHEN OTHERS THEN
2626: l_error_rec.error_type := 'OTHERS';

Line 2637: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2633: END IF;
2634: -- Loop through the error_tbl to find the error with the highest severity
2635: -- and return it.
2636: x_return_status := find_highest_exception(px_error_tbl);
2637: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2638: EXCEPTION
2639: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2640: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2641: (

Line 2639: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2635: -- and return it.
2636: x_return_status := find_highest_exception(px_error_tbl);
2637: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2638: EXCEPTION
2639: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2640: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2641: (
2642: l_api_name,
2643: G_PKG_NAME,

Line 2640: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2636: x_return_status := find_highest_exception(px_error_tbl);
2637: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2638: EXCEPTION
2639: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2640: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2641: (
2642: l_api_name,
2643: G_PKG_NAME,
2644: 'OKL_API.G_RET_STS_ERROR',

Line 2644: 'OKL_API.G_RET_STS_ERROR',

2640: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2641: (
2642: l_api_name,
2643: G_PKG_NAME,
2644: 'OKL_API.G_RET_STS_ERROR',
2645: x_msg_count,
2646: x_msg_data,
2647: '_PVT'
2648: );

Line 2649: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2645: x_msg_count,
2646: x_msg_data,
2647: '_PVT'
2648: );
2649: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2650: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2651: (
2652: l_api_name,
2653: G_PKG_NAME,

Line 2650: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2646: x_msg_data,
2647: '_PVT'
2648: );
2649: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2650: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2651: (
2652: l_api_name,
2653: G_PKG_NAME,
2654: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2654: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2650: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2651: (
2652: l_api_name,
2653: G_PKG_NAME,
2654: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2655: x_msg_count,
2656: x_msg_data,
2657: '_PVT'
2658: );

Line 2660: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2656: x_msg_data,
2657: '_PVT'
2658: );
2659: WHEN OTHERS THEN
2660: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2661: (
2662: l_api_name,
2663: G_PKG_NAME,
2664: 'OTHERS',

Line 2685: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2681: x_crav_tbl OUT NOCOPY crav_tbl_type) IS
2682:
2683: l_api_version CONSTANT NUMBER := 1;
2684: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2685: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2686: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2687: BEGIN
2688: OKL_API.init_msg_list(p_init_msg_list);
2689: -- Make sure PL/SQL table has records in it before passing

Line 2686: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2682:
2683: l_api_version CONSTANT NUMBER := 1;
2684: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2685: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2686: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2687: BEGIN
2688: OKL_API.init_msg_list(p_init_msg_list);
2689: -- Make sure PL/SQL table has records in it before passing
2690: IF (p_crav_tbl.COUNT > 0) THEN

Line 2688: OKL_API.init_msg_list(p_init_msg_list);

2684: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2685: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2686: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2687: BEGIN
2688: OKL_API.init_msg_list(p_init_msg_list);
2689: -- Make sure PL/SQL table has records in it before passing
2690: IF (p_crav_tbl.COUNT > 0) THEN
2691: update_row (
2692: p_api_version => p_api_version,

Line 2693: p_init_msg_list => OKL_API.G_FALSE,

2689: -- Make sure PL/SQL table has records in it before passing
2690: IF (p_crav_tbl.COUNT > 0) THEN
2691: update_row (
2692: p_api_version => p_api_version,
2693: p_init_msg_list => OKL_API.G_FALSE,
2694: x_return_status => x_return_status,
2695: x_msg_count => x_msg_count,
2696: x_msg_data => x_msg_data,
2697: p_crav_tbl => p_crav_tbl,

Line 2701: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2697: p_crav_tbl => p_crav_tbl,
2698: x_crav_tbl => x_crav_tbl,
2699: px_error_tbl => l_error_tbl);
2700: END IF;
2701: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2702: EXCEPTION
2703: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2704: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2705: (

Line 2703: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2699: px_error_tbl => l_error_tbl);
2700: END IF;
2701: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2702: EXCEPTION
2703: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2704: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2705: (
2706: l_api_name,
2707: G_PKG_NAME,

Line 2704: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2708: 'OKL_API.G_RET_STS_ERROR',

2704: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2705: (
2706: l_api_name,
2707: G_PKG_NAME,
2708: 'OKL_API.G_RET_STS_ERROR',
2709: x_msg_count,
2710: x_msg_data,
2711: '_PVT'
2712: );

Line 2713: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2714: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2718: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2714: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2715: (
2716: l_api_name,
2717: G_PKG_NAME,
2718: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2719: x_msg_count,
2720: x_msg_data,
2721: '_PVT'
2722: );

Line 2724: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2750: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2746: p_cra_rec IN cra_rec_type) IS
2747:
2748: l_api_version CONSTANT NUMBER := 1;
2749: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2750: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2751: l_cra_rec cra_rec_type := p_cra_rec;
2752: l_row_notfound BOOLEAN := TRUE;
2753: BEGIN
2754: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2754: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

2750: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2751: l_cra_rec cra_rec_type := p_cra_rec;
2752: l_row_notfound BOOLEAN := TRUE;
2753: BEGIN
2754: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2755: p_init_msg_list,
2756: '_PVT',
2757: x_return_status);
2758: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2758: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2754: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2755: p_init_msg_list,
2756: '_PVT',
2757: x_return_status);
2758: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2759: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2760: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2761: RAISE OKL_API.G_EXCEPTION_ERROR;
2762: END IF;

Line 2759: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2755: p_init_msg_list,
2756: '_PVT',
2757: x_return_status);
2758: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2759: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2760: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2761: RAISE OKL_API.G_EXCEPTION_ERROR;
2762: END IF;
2763:

Line 2760: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2756: '_PVT',
2757: x_return_status);
2758: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2759: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2760: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2761: RAISE OKL_API.G_EXCEPTION_ERROR;
2762: END IF;
2763:
2764: DELETE FROM OKL_CURE_REPORT_AMOUNTS

Line 2761: RAISE OKL_API.G_EXCEPTION_ERROR;

2757: x_return_status);
2758: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2759: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2760: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2761: RAISE OKL_API.G_EXCEPTION_ERROR;
2762: END IF;
2763:
2764: DELETE FROM OKL_CURE_REPORT_AMOUNTS
2765: WHERE CURE_REPORT_AMOUNT_ID = p_cra_rec.cure_report_amount_id;

Line 2768: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2764: DELETE FROM OKL_CURE_REPORT_AMOUNTS
2765: WHERE CURE_REPORT_AMOUNT_ID = p_cra_rec.cure_report_amount_id;
2766:
2767: x_return_status := l_return_status;
2768: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2769: EXCEPTION
2770: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2771: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2772: (

Line 2770: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2766:
2767: x_return_status := l_return_status;
2768: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2769: EXCEPTION
2770: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2771: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2772: (
2773: l_api_name,
2774: G_PKG_NAME,

Line 2771: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2767: x_return_status := l_return_status;
2768: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2769: EXCEPTION
2770: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2771: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2772: (
2773: l_api_name,
2774: G_PKG_NAME,
2775: 'OKL_API.G_RET_STS_ERROR',

Line 2775: 'OKL_API.G_RET_STS_ERROR',

2771: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2772: (
2773: l_api_name,
2774: G_PKG_NAME,
2775: 'OKL_API.G_RET_STS_ERROR',
2776: x_msg_count,
2777: x_msg_data,
2778: '_PVT'
2779: );

Line 2780: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2776: x_msg_count,
2777: x_msg_data,
2778: '_PVT'
2779: );
2780: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2781: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2782: (
2783: l_api_name,
2784: G_PKG_NAME,

Line 2781: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2777: x_msg_data,
2778: '_PVT'
2779: );
2780: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2781: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2782: (
2783: l_api_name,
2784: G_PKG_NAME,
2785: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2785: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2781: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2782: (
2783: l_api_name,
2784: G_PKG_NAME,
2785: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2786: x_msg_count,
2787: x_msg_data,
2788: '_PVT'
2789: );

Line 2791: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2787: x_msg_data,
2788: '_PVT'
2789: );
2790: WHEN OTHERS THEN
2791: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2792: (
2793: l_api_name,
2794: G_PKG_NAME,
2795: 'OTHERS',

Line 2814: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2810: p_crav_rec IN crav_rec_type) IS
2811:
2812: l_api_version CONSTANT NUMBER := 1;
2813: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2814: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2815: l_crav_rec crav_rec_type := p_crav_rec;
2816: l_cra_rec cra_rec_type;
2817: BEGIN
2818: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 2818: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

2814: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2815: l_crav_rec crav_rec_type := p_crav_rec;
2816: l_cra_rec cra_rec_type;
2817: BEGIN
2818: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2819: G_PKG_NAME,
2820: p_init_msg_list,
2821: l_api_version,
2822: p_api_version,

Line 2825: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2821: l_api_version,
2822: p_api_version,
2823: '_PVT',
2824: x_return_status);
2825: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2828: RAISE OKL_API.G_EXCEPTION_ERROR;
2829: END IF;

Line 2826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2822: p_api_version,
2823: '_PVT',
2824: x_return_status);
2825: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2828: RAISE OKL_API.G_EXCEPTION_ERROR;
2829: END IF;
2830: -----------------------------------------

Line 2827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2823: '_PVT',
2824: x_return_status);
2825: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2828: RAISE OKL_API.G_EXCEPTION_ERROR;
2829: END IF;
2830: -----------------------------------------
2831: -- Move VIEW record to "Child" records --

Line 2828: RAISE OKL_API.G_EXCEPTION_ERROR;

2824: x_return_status);
2825: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2828: RAISE OKL_API.G_EXCEPTION_ERROR;
2829: END IF;
2830: -----------------------------------------
2831: -- Move VIEW record to "Child" records --
2832: -----------------------------------------

Line 2844: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2840: x_msg_count,
2841: x_msg_data,
2842: l_cra_rec
2843: );
2844: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2846: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2847: RAISE OKL_API.G_EXCEPTION_ERROR;
2848: END IF;

Line 2845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2841: x_msg_data,
2842: l_cra_rec
2843: );
2844: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2846: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2847: RAISE OKL_API.G_EXCEPTION_ERROR;
2848: END IF;
2849: x_return_status := l_return_status;

Line 2846: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2842: l_cra_rec
2843: );
2844: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2846: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2847: RAISE OKL_API.G_EXCEPTION_ERROR;
2848: END IF;
2849: x_return_status := l_return_status;
2850: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2847: RAISE OKL_API.G_EXCEPTION_ERROR;

2843: );
2844: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2846: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2847: RAISE OKL_API.G_EXCEPTION_ERROR;
2848: END IF;
2849: x_return_status := l_return_status;
2850: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2851: EXCEPTION

Line 2850: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2846: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2847: RAISE OKL_API.G_EXCEPTION_ERROR;
2848: END IF;
2849: x_return_status := l_return_status;
2850: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2851: EXCEPTION
2852: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2853: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2854: (

Line 2852: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2848: END IF;
2849: x_return_status := l_return_status;
2850: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2851: EXCEPTION
2852: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2853: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2854: (
2855: l_api_name,
2856: G_PKG_NAME,

Line 2853: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2849: x_return_status := l_return_status;
2850: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2851: EXCEPTION
2852: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2853: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2854: (
2855: l_api_name,
2856: G_PKG_NAME,
2857: 'OKL_API.G_RET_STS_ERROR',

Line 2857: 'OKL_API.G_RET_STS_ERROR',

2853: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2854: (
2855: l_api_name,
2856: G_PKG_NAME,
2857: 'OKL_API.G_RET_STS_ERROR',
2858: x_msg_count,
2859: x_msg_data,
2860: '_PVT'
2861: );

Line 2862: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2858: x_msg_count,
2859: x_msg_data,
2860: '_PVT'
2861: );
2862: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2863: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2864: (
2865: l_api_name,
2866: G_PKG_NAME,

Line 2863: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2859: x_msg_data,
2860: '_PVT'
2861: );
2862: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2863: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2864: (
2865: l_api_name,
2866: G_PKG_NAME,
2867: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2867: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2863: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2864: (
2865: l_api_name,
2866: G_PKG_NAME,
2867: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2868: x_msg_count,
2869: x_msg_data,
2870: '_PVT'
2871: );

Line 2873: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2869: x_msg_data,
2870: '_PVT'
2871: );
2872: WHEN OTHERS THEN
2873: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2874: (
2875: l_api_name,
2876: G_PKG_NAME,
2877: 'OTHERS',

Line 2893: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

2889: x_return_status OUT NOCOPY VARCHAR2,
2890: x_msg_count OUT NOCOPY NUMBER,
2891: x_msg_data OUT NOCOPY VARCHAR2,
2892: p_crav_tbl IN crav_tbl_type,
2893: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2894:
2895: l_api_version CONSTANT NUMBER := 1;
2896: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2897: i NUMBER := 0;

Line 2899: OKL_API.init_msg_list(p_init_msg_list);

2895: l_api_version CONSTANT NUMBER := 1;
2896: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2897: i NUMBER := 0;
2898: BEGIN
2899: OKL_API.init_msg_list(p_init_msg_list);
2900: -- Make sure PL/SQL table has records in it before passing
2901: IF (p_crav_tbl.COUNT > 0) THEN
2902: i := p_crav_tbl.FIRST;
2903: LOOP

Line 2905: l_error_rec OKL_API.ERROR_REC_TYPE;

2901: IF (p_crav_tbl.COUNT > 0) THEN
2902: i := p_crav_tbl.FIRST;
2903: LOOP
2904: DECLARE
2905: l_error_rec OKL_API.ERROR_REC_TYPE;
2906: BEGIN
2907: l_error_rec.api_name := l_api_name;
2908: l_error_rec.api_package := G_PKG_NAME;
2909: l_error_rec.idx := i;

Line 2912: p_init_msg_list => OKL_API.G_FALSE,

2908: l_error_rec.api_package := G_PKG_NAME;
2909: l_error_rec.idx := i;
2910: delete_row (
2911: p_api_version => p_api_version,
2912: p_init_msg_list => OKL_API.G_FALSE,
2913: x_return_status => l_error_rec.error_type,
2914: x_msg_count => l_error_rec.msg_count,
2915: x_msg_data => l_error_rec.msg_data,
2916: p_crav_rec => p_crav_tbl(i));

Line 2917: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN

2913: x_return_status => l_error_rec.error_type,
2914: x_msg_count => l_error_rec.msg_count,
2915: x_msg_data => l_error_rec.msg_data,
2916: p_crav_rec => p_crav_tbl(i));
2917: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
2918: l_error_rec.sqlcode := SQLCODE;
2919: load_error_tbl(l_error_rec, px_error_tbl);
2920: ELSE
2921: x_msg_count := l_error_rec.msg_count;

Line 2925: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2921: x_msg_count := l_error_rec.msg_count;
2922: x_msg_data := l_error_rec.msg_data;
2923: END IF;
2924: EXCEPTION
2925: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2926: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2927: l_error_rec.sqlcode := SQLCODE;
2928: load_error_tbl(l_error_rec, px_error_tbl);
2929: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2926: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;

2922: x_msg_data := l_error_rec.msg_data;
2923: END IF;
2924: EXCEPTION
2925: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2926: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2927: l_error_rec.sqlcode := SQLCODE;
2928: load_error_tbl(l_error_rec, px_error_tbl);
2929: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2930: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2929: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2925: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2926: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2927: l_error_rec.sqlcode := SQLCODE;
2928: load_error_tbl(l_error_rec, px_error_tbl);
2929: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2930: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2931: l_error_rec.sqlcode := SQLCODE;
2932: load_error_tbl(l_error_rec, px_error_tbl);
2933: WHEN OTHERS THEN

Line 2930: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

2926: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2927: l_error_rec.sqlcode := SQLCODE;
2928: load_error_tbl(l_error_rec, px_error_tbl);
2929: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2930: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2931: l_error_rec.sqlcode := SQLCODE;
2932: load_error_tbl(l_error_rec, px_error_tbl);
2933: WHEN OTHERS THEN
2934: l_error_rec.error_type := 'OTHERS';

Line 2945: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2941: END IF;
2942: -- Loop through the error_tbl to find the error with the highest severity
2943: -- and return it.
2944: x_return_status := find_highest_exception(px_error_tbl);
2945: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2946: EXCEPTION
2947: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2948: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2949: (

Line 2947: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2943: -- and return it.
2944: x_return_status := find_highest_exception(px_error_tbl);
2945: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2946: EXCEPTION
2947: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2948: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2949: (
2950: l_api_name,
2951: G_PKG_NAME,

Line 2948: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2944: x_return_status := find_highest_exception(px_error_tbl);
2945: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2946: EXCEPTION
2947: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2948: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2949: (
2950: l_api_name,
2951: G_PKG_NAME,
2952: 'OKL_API.G_RET_STS_ERROR',

Line 2952: 'OKL_API.G_RET_STS_ERROR',

2948: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2949: (
2950: l_api_name,
2951: G_PKG_NAME,
2952: 'OKL_API.G_RET_STS_ERROR',
2953: x_msg_count,
2954: x_msg_data,
2955: '_PVT'
2956: );

Line 2957: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2953: x_msg_count,
2954: x_msg_data,
2955: '_PVT'
2956: );
2957: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2958: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2959: (
2960: l_api_name,
2961: G_PKG_NAME,

Line 2958: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2954: x_msg_data,
2955: '_PVT'
2956: );
2957: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2958: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2959: (
2960: l_api_name,
2961: G_PKG_NAME,
2962: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2962: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2958: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2959: (
2960: l_api_name,
2961: G_PKG_NAME,
2962: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2963: x_msg_count,
2964: x_msg_data,
2965: '_PVT'
2966: );

Line 2968: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2964: x_msg_data,
2965: '_PVT'
2966: );
2967: WHEN OTHERS THEN
2968: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2969: (
2970: l_api_name,
2971: G_PKG_NAME,
2972: 'OTHERS',

Line 2992: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2988: p_crav_tbl IN crav_tbl_type) IS
2989:
2990: l_api_version CONSTANT NUMBER := 1;
2991: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2992: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2993: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2994: BEGIN
2995: OKL_API.init_msg_list(p_init_msg_list);
2996: -- Make sure PL/SQL table has records in it before passing

Line 2993: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2989:
2990: l_api_version CONSTANT NUMBER := 1;
2991: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2992: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2993: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2994: BEGIN
2995: OKL_API.init_msg_list(p_init_msg_list);
2996: -- Make sure PL/SQL table has records in it before passing
2997: IF (p_crav_tbl.COUNT > 0) THEN

Line 2995: OKL_API.init_msg_list(p_init_msg_list);

2991: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2992: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2993: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2994: BEGIN
2995: OKL_API.init_msg_list(p_init_msg_list);
2996: -- Make sure PL/SQL table has records in it before passing
2997: IF (p_crav_tbl.COUNT > 0) THEN
2998: delete_row (
2999: p_api_version => p_api_version,

Line 3000: p_init_msg_list => OKL_API.G_FALSE,

2996: -- Make sure PL/SQL table has records in it before passing
2997: IF (p_crav_tbl.COUNT > 0) THEN
2998: delete_row (
2999: p_api_version => p_api_version,
3000: p_init_msg_list => OKL_API.G_FALSE,
3001: x_return_status => x_return_status,
3002: x_msg_count => x_msg_count,
3003: x_msg_data => x_msg_data,
3004: p_crav_tbl => p_crav_tbl,

Line 3007: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

3003: x_msg_data => x_msg_data,
3004: p_crav_tbl => p_crav_tbl,
3005: px_error_tbl => l_error_tbl);
3006: END IF;
3007: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3008: EXCEPTION
3009: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3010: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3011: (

Line 3009: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3005: px_error_tbl => l_error_tbl);
3006: END IF;
3007: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3008: EXCEPTION
3009: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3010: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3011: (
3012: l_api_name,
3013: G_PKG_NAME,

Line 3010: x_return_status := OKL_API.HANDLE_EXCEPTIONS

3006: END IF;
3007: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3008: EXCEPTION
3009: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3010: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3011: (
3012: l_api_name,
3013: G_PKG_NAME,
3014: 'OKL_API.G_RET_STS_ERROR',

Line 3014: 'OKL_API.G_RET_STS_ERROR',

3010: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3011: (
3012: l_api_name,
3013: G_PKG_NAME,
3014: 'OKL_API.G_RET_STS_ERROR',
3015: x_msg_count,
3016: x_msg_data,
3017: '_PVT'
3018: );

Line 3019: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3015: x_msg_count,
3016: x_msg_data,
3017: '_PVT'
3018: );
3019: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3020: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3021: (
3022: l_api_name,
3023: G_PKG_NAME,

Line 3020: x_return_status := OKL_API.HANDLE_EXCEPTIONS

3016: x_msg_data,
3017: '_PVT'
3018: );
3019: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3020: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3021: (
3022: l_api_name,
3023: G_PKG_NAME,
3024: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3024: 'OKL_API.G_RET_STS_UNEXP_ERROR',

3020: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3021: (
3022: l_api_name,
3023: G_PKG_NAME,
3024: 'OKL_API.G_RET_STS_UNEXP_ERROR',
3025: x_msg_count,
3026: x_msg_data,
3027: '_PVT'
3028: );

Line 3030: x_return_status := OKL_API.HANDLE_EXCEPTIONS

3026: x_msg_data,
3027: '_PVT'
3028: );
3029: WHEN OTHERS THEN
3030: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3031: (
3032: l_api_name,
3033: G_PKG_NAME,
3034: 'OTHERS',