APPS.OKL_CRS_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 190: x_return_status := OKL_API.G_RET_STS_SUCCESS;

186: ) RETURN crsv_rec_type IS
187: l_crsv_rec crsv_rec_type;
188: l_row_notfound BOOLEAN := TRUE;
189: BEGIN
190: x_return_status := OKL_API.G_RET_STS_SUCCESS;
191: l_crsv_rec := get_rec(p_crsv_rec, l_row_notfound);
192: IF (l_row_notfound) THEN
193: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REFUND_STAGE_ID');
194: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 193: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REFUND_STAGE_ID');

189: BEGIN
190: x_return_status := OKL_API.G_RET_STS_SUCCESS;
191: l_crsv_rec := get_rec(p_crsv_rec, l_row_notfound);
192: IF (l_row_notfound) THEN
193: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REFUND_STAGE_ID');
194: x_return_status := OKL_API.G_RET_STS_ERROR;
195: END IF;
196: RETURN(l_crsv_rec);
197: END get_rec;

Line 194: x_return_status := OKL_API.G_RET_STS_ERROR;

190: x_return_status := OKL_API.G_RET_STS_SUCCESS;
191: l_crsv_rec := get_rec(p_crsv_rec, l_row_notfound);
192: IF (l_row_notfound) THEN
193: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REFUND_STAGE_ID');
194: x_return_status := OKL_API.G_RET_STS_ERROR;
195: END IF;
196: RETURN(l_crsv_rec);
197: END get_rec;
198: -----------------------------------------------------------

Line 305: x_return_status := OKL_API.G_RET_STS_SUCCESS;

301: ) RETURN crs_rec_type IS
302: l_crs_rec crs_rec_type;
303: l_row_notfound BOOLEAN := TRUE;
304: BEGIN
305: x_return_status := OKL_API.G_RET_STS_SUCCESS;
306: l_crs_rec := get_rec(p_crs_rec, l_row_notfound);
307: IF (l_row_notfound) THEN
308: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REFUND_STAGE_ID');
309: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 308: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REFUND_STAGE_ID');

304: BEGIN
305: x_return_status := OKL_API.G_RET_STS_SUCCESS;
306: l_crs_rec := get_rec(p_crs_rec, l_row_notfound);
307: IF (l_row_notfound) THEN
308: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REFUND_STAGE_ID');
309: x_return_status := OKL_API.G_RET_STS_ERROR;
310: END IF;
311: RETURN(l_crs_rec);
312: END get_rec;

Line 309: x_return_status := OKL_API.G_RET_STS_ERROR;

305: x_return_status := OKL_API.G_RET_STS_SUCCESS;
306: l_crs_rec := get_rec(p_crs_rec, l_row_notfound);
307: IF (l_row_notfound) THEN
308: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'CURE_REFUND_STAGE_ID');
309: x_return_status := OKL_API.G_RET_STS_ERROR;
310: END IF;
311: RETURN(l_crs_rec);
312: END get_rec;
313: -----------------------------------------------------------

Line 331: IF (l_crsv_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM ) THEN

327: p_crsv_rec IN crsv_rec_type
328: ) RETURN crsv_rec_type IS
329: l_crsv_rec crsv_rec_type := p_crsv_rec;
330: BEGIN
331: IF (l_crsv_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM ) THEN
332: l_crsv_rec.cure_refund_stage_id := NULL;
333: END IF;
334: IF (l_crsv_rec.status = OKL_API.G_MISS_CHAR ) THEN
335: l_crsv_rec.status := NULL;

Line 334: IF (l_crsv_rec.status = OKL_API.G_MISS_CHAR ) THEN

330: BEGIN
331: IF (l_crsv_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM ) THEN
332: l_crsv_rec.cure_refund_stage_id := NULL;
333: END IF;
334: IF (l_crsv_rec.status = OKL_API.G_MISS_CHAR ) THEN
335: l_crsv_rec.status := NULL;
336: END IF;
337: IF (l_crsv_rec.negotiated_amount = OKL_API.G_MISS_NUM ) THEN
338: l_crsv_rec.negotiated_amount := NULL;

Line 337: IF (l_crsv_rec.negotiated_amount = OKL_API.G_MISS_NUM ) THEN

333: END IF;
334: IF (l_crsv_rec.status = OKL_API.G_MISS_CHAR ) THEN
335: l_crsv_rec.status := NULL;
336: END IF;
337: IF (l_crsv_rec.negotiated_amount = OKL_API.G_MISS_NUM ) THEN
338: l_crsv_rec.negotiated_amount := NULL;
339: END IF;
340: IF (l_crsv_rec.received_amount = OKL_API.G_MISS_NUM ) THEN
341: l_crsv_rec.received_amount := NULL;

Line 340: IF (l_crsv_rec.received_amount = OKL_API.G_MISS_NUM ) THEN

336: END IF;
337: IF (l_crsv_rec.negotiated_amount = OKL_API.G_MISS_NUM ) THEN
338: l_crsv_rec.negotiated_amount := NULL;
339: END IF;
340: IF (l_crsv_rec.received_amount = OKL_API.G_MISS_NUM ) THEN
341: l_crsv_rec.received_amount := NULL;
342: END IF;
343: IF (l_crsv_rec.chr_id = OKL_API.G_MISS_NUM ) THEN
344: l_crsv_rec.chr_id := NULL;

Line 343: IF (l_crsv_rec.chr_id = OKL_API.G_MISS_NUM ) THEN

339: END IF;
340: IF (l_crsv_rec.received_amount = OKL_API.G_MISS_NUM ) THEN
341: l_crsv_rec.received_amount := NULL;
342: END IF;
343: IF (l_crsv_rec.chr_id = OKL_API.G_MISS_NUM ) THEN
344: l_crsv_rec.chr_id := NULL;
345: END IF;
346: IF (l_crsv_rec.vendor_id = OKL_API.G_MISS_NUM ) THEN
347: l_crsv_rec.vendor_id := NULL;

Line 346: IF (l_crsv_rec.vendor_id = OKL_API.G_MISS_NUM ) THEN

342: END IF;
343: IF (l_crsv_rec.chr_id = OKL_API.G_MISS_NUM ) THEN
344: l_crsv_rec.chr_id := NULL;
345: END IF;
346: IF (l_crsv_rec.vendor_id = OKL_API.G_MISS_NUM ) THEN
347: l_crsv_rec.vendor_id := NULL;
348: END IF;
349: IF (l_crsv_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
350: l_crsv_rec.object_version_number := NULL;

Line 349: IF (l_crsv_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN

345: END IF;
346: IF (l_crsv_rec.vendor_id = OKL_API.G_MISS_NUM ) THEN
347: l_crsv_rec.vendor_id := NULL;
348: END IF;
349: IF (l_crsv_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
350: l_crsv_rec.object_version_number := NULL;
351: END IF;
352: IF (l_crsv_rec.request_id = OKL_API.G_MISS_NUM ) THEN
353: l_crsv_rec.request_id := NULL;

Line 352: IF (l_crsv_rec.request_id = OKL_API.G_MISS_NUM ) THEN

348: END IF;
349: IF (l_crsv_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
350: l_crsv_rec.object_version_number := NULL;
351: END IF;
352: IF (l_crsv_rec.request_id = OKL_API.G_MISS_NUM ) THEN
353: l_crsv_rec.request_id := NULL;
354: END IF;
355: IF (l_crsv_rec.program_application_id = OKL_API.G_MISS_NUM ) THEN
356: l_crsv_rec.program_application_id := NULL;

Line 355: IF (l_crsv_rec.program_application_id = OKL_API.G_MISS_NUM ) THEN

351: END IF;
352: IF (l_crsv_rec.request_id = OKL_API.G_MISS_NUM ) THEN
353: l_crsv_rec.request_id := NULL;
354: END IF;
355: IF (l_crsv_rec.program_application_id = OKL_API.G_MISS_NUM ) THEN
356: l_crsv_rec.program_application_id := NULL;
357: END IF;
358: IF (l_crsv_rec.program_id = OKL_API.G_MISS_NUM ) THEN
359: l_crsv_rec.program_id := NULL;

Line 358: IF (l_crsv_rec.program_id = OKL_API.G_MISS_NUM ) THEN

354: END IF;
355: IF (l_crsv_rec.program_application_id = OKL_API.G_MISS_NUM ) THEN
356: l_crsv_rec.program_application_id := NULL;
357: END IF;
358: IF (l_crsv_rec.program_id = OKL_API.G_MISS_NUM ) THEN
359: l_crsv_rec.program_id := NULL;
360: END IF;
361: IF (l_crsv_rec.program_update_date = OKL_API.G_MISS_DATE ) THEN
362: l_crsv_rec.program_update_date := NULL;

Line 361: IF (l_crsv_rec.program_update_date = OKL_API.G_MISS_DATE ) THEN

357: END IF;
358: IF (l_crsv_rec.program_id = OKL_API.G_MISS_NUM ) THEN
359: l_crsv_rec.program_id := NULL;
360: END IF;
361: IF (l_crsv_rec.program_update_date = OKL_API.G_MISS_DATE ) THEN
362: l_crsv_rec.program_update_date := NULL;
363: END IF;
364: IF (l_crsv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
365: l_crsv_rec.attribute_category := NULL;

Line 364: IF (l_crsv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN

360: END IF;
361: IF (l_crsv_rec.program_update_date = OKL_API.G_MISS_DATE ) THEN
362: l_crsv_rec.program_update_date := NULL;
363: END IF;
364: IF (l_crsv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
365: l_crsv_rec.attribute_category := NULL;
366: END IF;
367: IF (l_crsv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
368: l_crsv_rec.attribute1 := NULL;

Line 367: IF (l_crsv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN

363: END IF;
364: IF (l_crsv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
365: l_crsv_rec.attribute_category := NULL;
366: END IF;
367: IF (l_crsv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
368: l_crsv_rec.attribute1 := NULL;
369: END IF;
370: IF (l_crsv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
371: l_crsv_rec.attribute2 := NULL;

Line 370: IF (l_crsv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN

366: END IF;
367: IF (l_crsv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
368: l_crsv_rec.attribute1 := NULL;
369: END IF;
370: IF (l_crsv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
371: l_crsv_rec.attribute2 := NULL;
372: END IF;
373: IF (l_crsv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
374: l_crsv_rec.attribute3 := NULL;

Line 373: IF (l_crsv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN

369: END IF;
370: IF (l_crsv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
371: l_crsv_rec.attribute2 := NULL;
372: END IF;
373: IF (l_crsv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
374: l_crsv_rec.attribute3 := NULL;
375: END IF;
376: IF (l_crsv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
377: l_crsv_rec.attribute4 := NULL;

Line 376: IF (l_crsv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN

372: END IF;
373: IF (l_crsv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
374: l_crsv_rec.attribute3 := NULL;
375: END IF;
376: IF (l_crsv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
377: l_crsv_rec.attribute4 := NULL;
378: END IF;
379: IF (l_crsv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
380: l_crsv_rec.attribute5 := NULL;

Line 379: IF (l_crsv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN

375: END IF;
376: IF (l_crsv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
377: l_crsv_rec.attribute4 := NULL;
378: END IF;
379: IF (l_crsv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
380: l_crsv_rec.attribute5 := NULL;
381: END IF;
382: IF (l_crsv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
383: l_crsv_rec.attribute6 := NULL;

Line 382: IF (l_crsv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN

378: END IF;
379: IF (l_crsv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
380: l_crsv_rec.attribute5 := NULL;
381: END IF;
382: IF (l_crsv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
383: l_crsv_rec.attribute6 := NULL;
384: END IF;
385: IF (l_crsv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
386: l_crsv_rec.attribute7 := NULL;

Line 385: IF (l_crsv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN

381: END IF;
382: IF (l_crsv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
383: l_crsv_rec.attribute6 := NULL;
384: END IF;
385: IF (l_crsv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
386: l_crsv_rec.attribute7 := NULL;
387: END IF;
388: IF (l_crsv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
389: l_crsv_rec.attribute8 := NULL;

Line 388: IF (l_crsv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN

384: END IF;
385: IF (l_crsv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
386: l_crsv_rec.attribute7 := NULL;
387: END IF;
388: IF (l_crsv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
389: l_crsv_rec.attribute8 := NULL;
390: END IF;
391: IF (l_crsv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
392: l_crsv_rec.attribute9 := NULL;

Line 391: IF (l_crsv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN

387: END IF;
388: IF (l_crsv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
389: l_crsv_rec.attribute8 := NULL;
390: END IF;
391: IF (l_crsv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
392: l_crsv_rec.attribute9 := NULL;
393: END IF;
394: IF (l_crsv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
395: l_crsv_rec.attribute10 := NULL;

Line 394: IF (l_crsv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN

390: END IF;
391: IF (l_crsv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
392: l_crsv_rec.attribute9 := NULL;
393: END IF;
394: IF (l_crsv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
395: l_crsv_rec.attribute10 := NULL;
396: END IF;
397: IF (l_crsv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
398: l_crsv_rec.attribute11 := NULL;

Line 397: IF (l_crsv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN

393: END IF;
394: IF (l_crsv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
395: l_crsv_rec.attribute10 := NULL;
396: END IF;
397: IF (l_crsv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
398: l_crsv_rec.attribute11 := NULL;
399: END IF;
400: IF (l_crsv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
401: l_crsv_rec.attribute12 := NULL;

Line 400: IF (l_crsv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN

396: END IF;
397: IF (l_crsv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
398: l_crsv_rec.attribute11 := NULL;
399: END IF;
400: IF (l_crsv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
401: l_crsv_rec.attribute12 := NULL;
402: END IF;
403: IF (l_crsv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
404: l_crsv_rec.attribute13 := NULL;

Line 403: IF (l_crsv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN

399: END IF;
400: IF (l_crsv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
401: l_crsv_rec.attribute12 := NULL;
402: END IF;
403: IF (l_crsv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
404: l_crsv_rec.attribute13 := NULL;
405: END IF;
406: IF (l_crsv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
407: l_crsv_rec.attribute14 := NULL;

Line 406: IF (l_crsv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN

402: END IF;
403: IF (l_crsv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
404: l_crsv_rec.attribute13 := NULL;
405: END IF;
406: IF (l_crsv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
407: l_crsv_rec.attribute14 := NULL;
408: END IF;
409: IF (l_crsv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
410: l_crsv_rec.attribute15 := NULL;

Line 409: IF (l_crsv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN

405: END IF;
406: IF (l_crsv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
407: l_crsv_rec.attribute14 := NULL;
408: END IF;
409: IF (l_crsv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
410: l_crsv_rec.attribute15 := NULL;
411: END IF;
412: IF (l_crsv_rec.created_by = OKL_API.G_MISS_NUM ) THEN
413: l_crsv_rec.created_by := NULL;

Line 412: IF (l_crsv_rec.created_by = OKL_API.G_MISS_NUM ) THEN

408: END IF;
409: IF (l_crsv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
410: l_crsv_rec.attribute15 := NULL;
411: END IF;
412: IF (l_crsv_rec.created_by = OKL_API.G_MISS_NUM ) THEN
413: l_crsv_rec.created_by := NULL;
414: END IF;
415: IF (l_crsv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
416: l_crsv_rec.creation_date := NULL;

Line 415: IF (l_crsv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN

411: END IF;
412: IF (l_crsv_rec.created_by = OKL_API.G_MISS_NUM ) THEN
413: l_crsv_rec.created_by := NULL;
414: END IF;
415: IF (l_crsv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
416: l_crsv_rec.creation_date := NULL;
417: END IF;
418: IF (l_crsv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
419: l_crsv_rec.last_updated_by := NULL;

Line 418: IF (l_crsv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN

414: END IF;
415: IF (l_crsv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
416: l_crsv_rec.creation_date := NULL;
417: END IF;
418: IF (l_crsv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
419: l_crsv_rec.last_updated_by := NULL;
420: END IF;
421: IF (l_crsv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
422: l_crsv_rec.last_update_date := NULL;

Line 421: IF (l_crsv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN

417: END IF;
418: IF (l_crsv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
419: l_crsv_rec.last_updated_by := NULL;
420: END IF;
421: IF (l_crsv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
422: l_crsv_rec.last_update_date := NULL;
423: END IF;
424: IF (l_crsv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
425: l_crsv_rec.last_update_login := NULL;

Line 424: IF (l_crsv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN

420: END IF;
421: IF (l_crsv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
422: l_crsv_rec.last_update_date := NULL;
423: END IF;
424: IF (l_crsv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
425: l_crsv_rec.last_update_login := NULL;
426: END IF;
427: RETURN(l_crsv_rec);
428: END null_out_defaults;

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

431: ---------------------------------------------------
432: PROCEDURE validate_cure_refund_stage_id(
433: x_return_status OUT NOCOPY VARCHAR2,
434: p_crsv_rec IN crsv_rec_type) IS
435: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
436: BEGIN
437: IF (p_crsv_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM OR
438: p_crsv_rec.cure_refund_stage_id IS NULL)
439: THEN

Line 437: IF (p_crsv_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM OR

433: x_return_status OUT NOCOPY VARCHAR2,
434: p_crsv_rec IN crsv_rec_type) IS
435: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
436: BEGIN
437: IF (p_crsv_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM OR
438: p_crsv_rec.cure_refund_stage_id IS NULL)
439: THEN
440: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_refund_stage_id');
441: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 440: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_refund_stage_id');

436: BEGIN
437: IF (p_crsv_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM OR
438: p_crsv_rec.cure_refund_stage_id IS NULL)
439: THEN
440: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_refund_stage_id');
441: l_return_status := OKL_API.G_RET_STS_ERROR;
442: END IF;
443: x_return_status := l_return_status;
444: EXCEPTION

Line 441: l_return_status := OKL_API.G_RET_STS_ERROR;

437: IF (p_crsv_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM OR
438: p_crsv_rec.cure_refund_stage_id IS NULL)
439: THEN
440: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cure_refund_stage_id');
441: l_return_status := OKL_API.G_RET_STS_ERROR;
442: END IF;
443: x_return_status := l_return_status;
444: EXCEPTION
445: WHEN OTHERS THEN

Line 446: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

442: END IF;
443: x_return_status := l_return_status;
444: EXCEPTION
445: WHEN OTHERS THEN
446: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
447: ,p_msg_name => G_UNEXPECTED_ERROR
448: ,p_token1 => G_SQLCODE_TOKEN
449: ,p_token1_value => SQLCODE
450: ,p_token2 => G_SQLERRM_TOKEN

Line 452: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

448: ,p_token1 => G_SQLCODE_TOKEN
449: ,p_token1_value => SQLCODE
450: ,p_token2 => G_SQLERRM_TOKEN
451: ,p_token2_value => SQLERRM);
452: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
453: END validate_cure_refund_stage_id;
454: -------------------------------------
455: -- Validate_Attributes for: CHR_ID --
456: -------------------------------------

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

456: -------------------------------------
457: PROCEDURE validate_chr_id(
458: x_return_status OUT NOCOPY VARCHAR2,
459: p_crsv_rec IN crsv_rec_type) IS
460: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
461: BEGIN
462: IF (p_crsv_rec.chr_id = OKL_API.G_MISS_NUM OR
463: p_crsv_rec.chr_id IS NULL)
464: THEN

Line 462: IF (p_crsv_rec.chr_id = OKL_API.G_MISS_NUM OR

458: x_return_status OUT NOCOPY VARCHAR2,
459: p_crsv_rec IN crsv_rec_type) IS
460: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
461: BEGIN
462: IF (p_crsv_rec.chr_id = OKL_API.G_MISS_NUM OR
463: p_crsv_rec.chr_id IS NULL)
464: THEN
465: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'chr_id');
466: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 465: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'chr_id');

461: BEGIN
462: IF (p_crsv_rec.chr_id = OKL_API.G_MISS_NUM OR
463: p_crsv_rec.chr_id IS NULL)
464: THEN
465: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'chr_id');
466: l_return_status := OKL_API.G_RET_STS_ERROR;
467: END IF;
468: x_return_status := l_return_status;
469: EXCEPTION

Line 466: l_return_status := OKL_API.G_RET_STS_ERROR;

462: IF (p_crsv_rec.chr_id = OKL_API.G_MISS_NUM OR
463: p_crsv_rec.chr_id IS NULL)
464: THEN
465: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'chr_id');
466: l_return_status := OKL_API.G_RET_STS_ERROR;
467: END IF;
468: x_return_status := l_return_status;
469: EXCEPTION
470: WHEN OTHERS THEN

Line 471: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

467: END IF;
468: x_return_status := l_return_status;
469: EXCEPTION
470: WHEN OTHERS THEN
471: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
472: ,p_msg_name => G_UNEXPECTED_ERROR
473: ,p_token1 => G_SQLCODE_TOKEN
474: ,p_token1_value => SQLCODE
475: ,p_token2 => G_SQLERRM_TOKEN

Line 477: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

473: ,p_token1 => G_SQLCODE_TOKEN
474: ,p_token1_value => SQLCODE
475: ,p_token2 => G_SQLERRM_TOKEN
476: ,p_token2_value => SQLERRM);
477: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
478: END validate_chr_id;
479: ----------------------------------------
480: -- Validate_Attributes for: VENDOR_ID --
481: ----------------------------------------

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

481: ----------------------------------------
482: PROCEDURE validate_vendor_id(
483: x_return_status OUT NOCOPY VARCHAR2,
484: p_crsv_rec IN crsv_rec_type) IS
485: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
486: BEGIN
487: IF (p_crsv_rec.vendor_id = OKL_API.G_MISS_NUM OR
488: p_crsv_rec.vendor_id IS NULL)
489: THEN

Line 487: IF (p_crsv_rec.vendor_id = OKL_API.G_MISS_NUM OR

483: x_return_status OUT NOCOPY VARCHAR2,
484: p_crsv_rec IN crsv_rec_type) IS
485: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
486: BEGIN
487: IF (p_crsv_rec.vendor_id = OKL_API.G_MISS_NUM OR
488: p_crsv_rec.vendor_id IS NULL)
489: THEN
490: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'vendor_id');
491: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 490: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'vendor_id');

486: BEGIN
487: IF (p_crsv_rec.vendor_id = OKL_API.G_MISS_NUM OR
488: p_crsv_rec.vendor_id IS NULL)
489: THEN
490: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'vendor_id');
491: l_return_status := OKL_API.G_RET_STS_ERROR;
492: END IF;
493: x_return_status := l_return_status;
494: EXCEPTION

Line 491: l_return_status := OKL_API.G_RET_STS_ERROR;

487: IF (p_crsv_rec.vendor_id = OKL_API.G_MISS_NUM OR
488: p_crsv_rec.vendor_id IS NULL)
489: THEN
490: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'vendor_id');
491: l_return_status := OKL_API.G_RET_STS_ERROR;
492: END IF;
493: x_return_status := l_return_status;
494: EXCEPTION
495: WHEN OTHERS THEN

Line 496: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

492: END IF;
493: x_return_status := l_return_status;
494: EXCEPTION
495: WHEN OTHERS THEN
496: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
497: ,p_msg_name => G_UNEXPECTED_ERROR
498: ,p_token1 => G_SQLCODE_TOKEN
499: ,p_token1_value => SQLCODE
500: ,p_token2 => G_SQLERRM_TOKEN

Line 502: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

498: ,p_token1 => G_SQLCODE_TOKEN
499: ,p_token1_value => SQLCODE
500: ,p_token2 => G_SQLERRM_TOKEN
501: ,p_token2_value => SQLERRM);
502: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
503: END validate_vendor_id;
504: ----------------------------------------------------
505: -- Validate_Attributes for: OBJECT_VERSION_NUMBER --
506: ----------------------------------------------------

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

506: ----------------------------------------------------
507: PROCEDURE validate_object_version_number(
508: x_return_status OUT NOCOPY VARCHAR2,
509: p_crsv_rec IN crsv_rec_type) IS
510: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
511: BEGIN
512: IF (p_crsv_rec.object_version_number = OKL_API.G_MISS_NUM OR
513: p_crsv_rec.object_version_number IS NULL)
514: THEN

Line 512: IF (p_crsv_rec.object_version_number = OKL_API.G_MISS_NUM OR

508: x_return_status OUT NOCOPY VARCHAR2,
509: p_crsv_rec IN crsv_rec_type) IS
510: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
511: BEGIN
512: IF (p_crsv_rec.object_version_number = OKL_API.G_MISS_NUM OR
513: p_crsv_rec.object_version_number IS NULL)
514: THEN
515: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
516: l_return_status := OKL_API.G_RET_STS_ERROR;

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

511: BEGIN
512: IF (p_crsv_rec.object_version_number = OKL_API.G_MISS_NUM OR
513: p_crsv_rec.object_version_number IS NULL)
514: THEN
515: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
516: l_return_status := OKL_API.G_RET_STS_ERROR;
517: END IF;
518: x_return_status := l_return_status;
519: EXCEPTION

Line 516: l_return_status := OKL_API.G_RET_STS_ERROR;

512: IF (p_crsv_rec.object_version_number = OKL_API.G_MISS_NUM OR
513: p_crsv_rec.object_version_number IS NULL)
514: THEN
515: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
516: l_return_status := OKL_API.G_RET_STS_ERROR;
517: END IF;
518: x_return_status := l_return_status;
519: EXCEPTION
520: WHEN OTHERS THEN

Line 521: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

517: END IF;
518: x_return_status := l_return_status;
519: EXCEPTION
520: WHEN OTHERS THEN
521: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
522: ,p_msg_name => G_UNEXPECTED_ERROR
523: ,p_token1 => G_SQLCODE_TOKEN
524: ,p_token1_value => SQLCODE
525: ,p_token2 => G_SQLERRM_TOKEN

Line 527: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

523: ,p_token1 => G_SQLCODE_TOKEN
524: ,p_token1_value => SQLCODE
525: ,p_token2 => G_SQLERRM_TOKEN
526: ,p_token2_value => SQLERRM);
527: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
528: END validate_object_version_number;
529: ---------------------------------------------------------------------------
530: -- FUNCTION Validate_Attributes
531: ---------------------------------------------------------------------------

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

534: -----------------------------------------------------
535: FUNCTION Validate_Attributes (
536: p_crsv_rec IN crsv_rec_type
537: ) RETURN VARCHAR2 IS
538: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
539: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
540: BEGIN
541: -----------------------------
542: -- Column Level Validation --

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

535: FUNCTION Validate_Attributes (
536: p_crsv_rec IN crsv_rec_type
537: ) RETURN VARCHAR2 IS
538: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
539: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
540: BEGIN
541: -----------------------------
542: -- Column Level Validation --
543: -----------------------------

Line 548: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

544: -- ***
545: -- cure_refund_stage_id
546: -- ***
547: validate_cure_refund_stage_id(x_return_status, p_crsv_rec);
548: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
549: l_return_status := x_return_status;
550: RAISE G_EXCEPTION_HALT_VALIDATION;
551: END IF;
552:

Line 557: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

553: -- ***
554: -- chr_id
555: -- ***
556: validate_chr_id(x_return_status, p_crsv_rec);
557: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
558: l_return_status := x_return_status;
559: RAISE G_EXCEPTION_HALT_VALIDATION;
560: END IF;
561:

Line 566: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

562: -- ***
563: -- vendor_id
564: -- ***
565: validate_vendor_id(x_return_status, p_crsv_rec);
566: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
567: l_return_status := x_return_status;
568: RAISE G_EXCEPTION_HALT_VALIDATION;
569: END IF;
570:

Line 575: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

571: -- ***
572: -- object_version_number
573: -- ***
574: validate_object_version_number(x_return_status, p_crsv_rec);
575: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
576: l_return_status := x_return_status;
577: RAISE G_EXCEPTION_HALT_VALIDATION;
578: END IF;
579:

Line 585: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

581: EXCEPTION
582: WHEN G_EXCEPTION_HALT_VALIDATION THEN
583: RETURN(l_return_status);
584: WHEN OTHERS THEN
585: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
586: ,p_msg_name => G_UNEXPECTED_ERROR
587: ,p_token1 => G_SQLCODE_TOKEN
588: ,p_token1_value => SQLCODE
589: ,p_token2 => G_SQLERRM_TOKEN

Line 591: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

587: ,p_token1 => G_SQLCODE_TOKEN
588: ,p_token1_value => SQLCODE
589: ,p_token2 => G_SQLERRM_TOKEN
590: ,p_token2_value => SQLERRM);
591: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
592: RETURN(l_return_status);
593: END Validate_Attributes;
594: ---------------------------------------------------------------------------
595: -- PROCEDURE Validate_Record

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

600: FUNCTION Validate_Record (
601: p_crsv_rec IN crsv_rec_type,
602: p_db_crsv_rec IN crsv_rec_type
603: ) RETURN VARCHAR2 IS
604: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
605: BEGIN
606: RETURN (l_return_status);
607: END Validate_Record;
608: FUNCTION Validate_Record (

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

607: END Validate_Record;
608: FUNCTION Validate_Record (
609: p_crsv_rec IN crsv_rec_type
610: ) RETURN VARCHAR2 IS
611: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
612: l_db_crsv_rec crsv_rec_type := get_rec(p_crsv_rec);
613: BEGIN
614: l_return_status := Validate_Record(p_crsv_rec => p_crsv_rec,
615: p_db_crsv_rec => l_db_crsv_rec);

Line 706: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

702: -- validate_row for:OKL_CURE_REFUND_STAGE_V --
703: ----------------------------------------------
704: PROCEDURE validate_row(
705: p_api_version IN NUMBER,
706: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
707: x_return_status OUT NOCOPY VARCHAR2,
708: x_msg_count OUT NOCOPY NUMBER,
709: x_msg_data OUT NOCOPY VARCHAR2,
710: p_crsv_rec IN crsv_rec_type) IS

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

710: p_crsv_rec IN crsv_rec_type) IS
711:
712: l_api_version CONSTANT NUMBER := 1;
713: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
714: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
715: l_crsv_rec crsv_rec_type := p_crsv_rec;
716: l_crs_rec crs_rec_type;
717: l_crs_rec crs_rec_type;
718: BEGIN

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

715: l_crsv_rec crsv_rec_type := p_crsv_rec;
716: l_crs_rec crs_rec_type;
717: l_crs_rec crs_rec_type;
718: BEGIN
719: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
720: G_PKG_NAME,
721: p_init_msg_list,
722: l_api_version,
723: p_api_version,

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

722: l_api_version,
723: p_api_version,
724: '_PVT',
725: x_return_status);
726: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
728: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
729: RAISE OKL_API.G_EXCEPTION_ERROR;
730: END IF;

Line 727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

723: p_api_version,
724: '_PVT',
725: x_return_status);
726: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
728: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
729: RAISE OKL_API.G_EXCEPTION_ERROR;
730: END IF;
731: --- Validate all non-missing attributes (Item Level Validation)

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

724: '_PVT',
725: x_return_status);
726: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
728: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
729: RAISE OKL_API.G_EXCEPTION_ERROR;
730: END IF;
731: --- Validate all non-missing attributes (Item Level Validation)
732: l_return_status := Validate_Attributes(l_crsv_rec);

Line 729: RAISE OKL_API.G_EXCEPTION_ERROR;

725: x_return_status);
726: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
727: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
728: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
729: RAISE OKL_API.G_EXCEPTION_ERROR;
730: END IF;
731: --- Validate all non-missing attributes (Item Level Validation)
732: l_return_status := Validate_Attributes(l_crsv_rec);
733: --- If any errors happen abort API

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

730: END IF;
731: --- Validate all non-missing attributes (Item Level Validation)
732: l_return_status := Validate_Attributes(l_crsv_rec);
733: --- If any errors happen abort API
734: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
735: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
736: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
737: RAISE OKL_API.G_EXCEPTION_ERROR;
738: END IF;

Line 735: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

731: --- Validate all non-missing attributes (Item Level Validation)
732: l_return_status := Validate_Attributes(l_crsv_rec);
733: --- If any errors happen abort API
734: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
735: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
736: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
737: RAISE OKL_API.G_EXCEPTION_ERROR;
738: END IF;
739: l_return_status := Validate_Record(l_crsv_rec);

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

732: l_return_status := Validate_Attributes(l_crsv_rec);
733: --- If any errors happen abort API
734: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
735: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
736: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
737: RAISE OKL_API.G_EXCEPTION_ERROR;
738: END IF;
739: l_return_status := Validate_Record(l_crsv_rec);
740: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 737: RAISE OKL_API.G_EXCEPTION_ERROR;

733: --- If any errors happen abort API
734: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
735: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
736: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
737: RAISE OKL_API.G_EXCEPTION_ERROR;
738: END IF;
739: l_return_status := Validate_Record(l_crsv_rec);
740: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

736: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
737: RAISE OKL_API.G_EXCEPTION_ERROR;
738: END IF;
739: l_return_status := Validate_Record(l_crsv_rec);
740: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
742: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
743: RAISE OKL_API.G_EXCEPTION_ERROR;
744: END IF;

Line 741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

737: RAISE OKL_API.G_EXCEPTION_ERROR;
738: END IF;
739: l_return_status := Validate_Record(l_crsv_rec);
740: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
742: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
743: RAISE OKL_API.G_EXCEPTION_ERROR;
744: END IF;
745: x_return_status := l_return_status;

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

738: END IF;
739: l_return_status := Validate_Record(l_crsv_rec);
740: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
742: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
743: RAISE OKL_API.G_EXCEPTION_ERROR;
744: END IF;
745: x_return_status := l_return_status;
746: EXCEPTION

Line 743: RAISE OKL_API.G_EXCEPTION_ERROR;

739: l_return_status := Validate_Record(l_crsv_rec);
740: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
742: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
743: RAISE OKL_API.G_EXCEPTION_ERROR;
744: END IF;
745: x_return_status := l_return_status;
746: EXCEPTION
747: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 747: WHEN OKL_API.G_EXCEPTION_ERROR THEN

743: RAISE OKL_API.G_EXCEPTION_ERROR;
744: END IF;
745: x_return_status := l_return_status;
746: EXCEPTION
747: WHEN OKL_API.G_EXCEPTION_ERROR THEN
748: x_return_status := OKL_API.HANDLE_EXCEPTIONS
749: (
750: l_api_name,
751: G_PKG_NAME,

Line 748: x_return_status := OKL_API.HANDLE_EXCEPTIONS

744: END IF;
745: x_return_status := l_return_status;
746: EXCEPTION
747: WHEN OKL_API.G_EXCEPTION_ERROR THEN
748: x_return_status := OKL_API.HANDLE_EXCEPTIONS
749: (
750: l_api_name,
751: G_PKG_NAME,
752: 'OKL_API.G_RET_STS_ERROR',

Line 752: 'OKL_API.G_RET_STS_ERROR',

748: x_return_status := OKL_API.HANDLE_EXCEPTIONS
749: (
750: l_api_name,
751: G_PKG_NAME,
752: 'OKL_API.G_RET_STS_ERROR',
753: x_msg_count,
754: x_msg_data,
755: '_PVT'
756: );

Line 757: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

753: x_msg_count,
754: x_msg_data,
755: '_PVT'
756: );
757: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
758: x_return_status := OKL_API.HANDLE_EXCEPTIONS
759: (
760: l_api_name,
761: G_PKG_NAME,

Line 758: x_return_status := OKL_API.HANDLE_EXCEPTIONS

754: x_msg_data,
755: '_PVT'
756: );
757: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
758: x_return_status := OKL_API.HANDLE_EXCEPTIONS
759: (
760: l_api_name,
761: G_PKG_NAME,
762: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 762: 'OKL_API.G_RET_STS_UNEXP_ERROR',

758: x_return_status := OKL_API.HANDLE_EXCEPTIONS
759: (
760: l_api_name,
761: G_PKG_NAME,
762: 'OKL_API.G_RET_STS_UNEXP_ERROR',
763: x_msg_count,
764: x_msg_data,
765: '_PVT'
766: );

Line 768: x_return_status := OKL_API.HANDLE_EXCEPTIONS

764: x_msg_data,
765: '_PVT'
766: );
767: WHEN OTHERS THEN
768: x_return_status := OKL_API.HANDLE_EXCEPTIONS
769: (
770: l_api_name,
771: G_PKG_NAME,
772: 'OTHERS',

Line 783: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

779: -- PL/SQL TBL validate_row for:OKL_CURE_REFUND_STAGE_V --
780: ---------------------------------------------------------
781: PROCEDURE validate_row(
782: p_api_version IN NUMBER,
783: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
784: x_return_status OUT NOCOPY VARCHAR2,
785: x_msg_count OUT NOCOPY NUMBER,
786: x_msg_data OUT NOCOPY VARCHAR2,
787: p_crsv_tbl IN crsv_tbl_type,

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

784: x_return_status OUT NOCOPY VARCHAR2,
785: x_msg_count OUT NOCOPY NUMBER,
786: x_msg_data OUT NOCOPY VARCHAR2,
787: p_crsv_tbl IN crsv_tbl_type,
788: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
789:
790: l_api_version CONSTANT NUMBER := 1;
791: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
792: i NUMBER := 0;

Line 794: OKL_API.init_msg_list(p_init_msg_list);

790: l_api_version CONSTANT NUMBER := 1;
791: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
792: i NUMBER := 0;
793: BEGIN
794: OKL_API.init_msg_list(p_init_msg_list);
795: -- Make sure PL/SQL table has records in it before passing
796: IF (p_crsv_tbl.COUNT > 0) THEN
797: i := p_crsv_tbl.FIRST;
798: LOOP

Line 800: l_error_rec OKL_API.ERROR_REC_TYPE;

796: IF (p_crsv_tbl.COUNT > 0) THEN
797: i := p_crsv_tbl.FIRST;
798: LOOP
799: DECLARE
800: l_error_rec OKL_API.ERROR_REC_TYPE;
801: BEGIN
802: l_error_rec.api_name := l_api_name;
803: l_error_rec.api_package := G_PKG_NAME;
804: l_error_rec.idx := i;

Line 807: p_init_msg_list => OKL_API.G_FALSE,

803: l_error_rec.api_package := G_PKG_NAME;
804: l_error_rec.idx := i;
805: validate_row (
806: p_api_version => p_api_version,
807: p_init_msg_list => OKL_API.G_FALSE,
808: x_return_status => l_error_rec.error_type,
809: x_msg_count => l_error_rec.msg_count,
810: x_msg_data => l_error_rec.msg_data,
811: p_crsv_rec => p_crsv_tbl(i));

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

808: x_return_status => l_error_rec.error_type,
809: x_msg_count => l_error_rec.msg_count,
810: x_msg_data => l_error_rec.msg_data,
811: p_crsv_rec => p_crsv_tbl(i));
812: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
813: l_error_rec.sqlcode := SQLCODE;
814: load_error_tbl(l_error_rec, px_error_tbl);
815: ELSE
816: x_msg_count := l_error_rec.msg_count;

Line 820: WHEN OKL_API.G_EXCEPTION_ERROR THEN

816: x_msg_count := l_error_rec.msg_count;
817: x_msg_data := l_error_rec.msg_data;
818: END IF;
819: EXCEPTION
820: WHEN OKL_API.G_EXCEPTION_ERROR THEN
821: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
822: l_error_rec.sqlcode := SQLCODE;
823: load_error_tbl(l_error_rec, px_error_tbl);
824: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

817: x_msg_data := l_error_rec.msg_data;
818: END IF;
819: EXCEPTION
820: WHEN OKL_API.G_EXCEPTION_ERROR THEN
821: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
822: l_error_rec.sqlcode := SQLCODE;
823: load_error_tbl(l_error_rec, px_error_tbl);
824: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
825: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 824: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

820: WHEN OKL_API.G_EXCEPTION_ERROR THEN
821: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
822: l_error_rec.sqlcode := SQLCODE;
823: load_error_tbl(l_error_rec, px_error_tbl);
824: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
825: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
826: l_error_rec.sqlcode := SQLCODE;
827: load_error_tbl(l_error_rec, px_error_tbl);
828: WHEN OTHERS THEN

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

821: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
822: l_error_rec.sqlcode := SQLCODE;
823: load_error_tbl(l_error_rec, px_error_tbl);
824: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
825: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
826: l_error_rec.sqlcode := SQLCODE;
827: load_error_tbl(l_error_rec, px_error_tbl);
828: WHEN OTHERS THEN
829: l_error_rec.error_type := 'OTHERS';

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

836: END IF;
837: -- Loop through the error_tbl to find the error with the highest severity
838: -- and return it.
839: x_return_status := find_highest_exception(px_error_tbl);
840: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
841: EXCEPTION
842: WHEN OKL_API.G_EXCEPTION_ERROR THEN
843: x_return_status := OKL_API.HANDLE_EXCEPTIONS
844: (

Line 842: WHEN OKL_API.G_EXCEPTION_ERROR THEN

838: -- and return it.
839: x_return_status := find_highest_exception(px_error_tbl);
840: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
841: EXCEPTION
842: WHEN OKL_API.G_EXCEPTION_ERROR THEN
843: x_return_status := OKL_API.HANDLE_EXCEPTIONS
844: (
845: l_api_name,
846: G_PKG_NAME,

Line 843: x_return_status := OKL_API.HANDLE_EXCEPTIONS

839: x_return_status := find_highest_exception(px_error_tbl);
840: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
841: EXCEPTION
842: WHEN OKL_API.G_EXCEPTION_ERROR THEN
843: x_return_status := OKL_API.HANDLE_EXCEPTIONS
844: (
845: l_api_name,
846: G_PKG_NAME,
847: 'OKL_API.G_RET_STS_ERROR',

Line 847: 'OKL_API.G_RET_STS_ERROR',

843: x_return_status := OKL_API.HANDLE_EXCEPTIONS
844: (
845: l_api_name,
846: G_PKG_NAME,
847: 'OKL_API.G_RET_STS_ERROR',
848: x_msg_count,
849: x_msg_data,
850: '_PVT'
851: );

Line 852: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

848: x_msg_count,
849: x_msg_data,
850: '_PVT'
851: );
852: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
853: x_return_status := OKL_API.HANDLE_EXCEPTIONS
854: (
855: l_api_name,
856: G_PKG_NAME,

Line 853: x_return_status := OKL_API.HANDLE_EXCEPTIONS

849: x_msg_data,
850: '_PVT'
851: );
852: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
853: x_return_status := OKL_API.HANDLE_EXCEPTIONS
854: (
855: l_api_name,
856: G_PKG_NAME,
857: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 857: 'OKL_API.G_RET_STS_UNEXP_ERROR',

853: x_return_status := OKL_API.HANDLE_EXCEPTIONS
854: (
855: l_api_name,
856: G_PKG_NAME,
857: 'OKL_API.G_RET_STS_UNEXP_ERROR',
858: x_msg_count,
859: x_msg_data,
860: '_PVT'
861: );

Line 863: x_return_status := OKL_API.HANDLE_EXCEPTIONS

859: x_msg_data,
860: '_PVT'
861: );
862: WHEN OTHERS THEN
863: x_return_status := OKL_API.HANDLE_EXCEPTIONS
864: (
865: l_api_name,
866: G_PKG_NAME,
867: 'OTHERS',

Line 879: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

875: -- PL/SQL TBL validate_row for:OKL_CURE_REFUND_STAGE_V --
876: ---------------------------------------------------------
877: PROCEDURE validate_row(
878: p_api_version IN NUMBER,
879: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
880: x_return_status OUT NOCOPY VARCHAR2,
881: x_msg_count OUT NOCOPY NUMBER,
882: x_msg_data OUT NOCOPY VARCHAR2,
883: p_crsv_tbl IN crsv_tbl_type) IS

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

883: p_crsv_tbl IN crsv_tbl_type) IS
884:
885: l_api_version CONSTANT NUMBER := 1;
886: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
887: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
888: l_error_tbl OKL_API.ERROR_TBL_TYPE;
889: BEGIN
890: OKL_API.init_msg_list(p_init_msg_list);
891: -- Make sure PL/SQL table has records in it before passing

Line 888: l_error_tbl OKL_API.ERROR_TBL_TYPE;

884:
885: l_api_version CONSTANT NUMBER := 1;
886: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
887: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
888: l_error_tbl OKL_API.ERROR_TBL_TYPE;
889: BEGIN
890: OKL_API.init_msg_list(p_init_msg_list);
891: -- Make sure PL/SQL table has records in it before passing
892: IF (p_crsv_tbl.COUNT > 0) THEN

Line 890: OKL_API.init_msg_list(p_init_msg_list);

886: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
887: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
888: l_error_tbl OKL_API.ERROR_TBL_TYPE;
889: BEGIN
890: OKL_API.init_msg_list(p_init_msg_list);
891: -- Make sure PL/SQL table has records in it before passing
892: IF (p_crsv_tbl.COUNT > 0) THEN
893: validate_row (
894: p_api_version => p_api_version,

Line 895: p_init_msg_list => OKL_API.G_FALSE,

891: -- Make sure PL/SQL table has records in it before passing
892: IF (p_crsv_tbl.COUNT > 0) THEN
893: validate_row (
894: p_api_version => p_api_version,
895: p_init_msg_list => OKL_API.G_FALSE,
896: x_return_status => x_return_status,
897: x_msg_count => x_msg_count,
898: x_msg_data => x_msg_data,
899: p_crsv_tbl => p_crsv_tbl,

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

898: x_msg_data => x_msg_data,
899: p_crsv_tbl => p_crsv_tbl,
900: px_error_tbl => l_error_tbl);
901: END IF;
902: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
903: EXCEPTION
904: WHEN OKL_API.G_EXCEPTION_ERROR THEN
905: x_return_status := OKL_API.HANDLE_EXCEPTIONS
906: (

Line 904: WHEN OKL_API.G_EXCEPTION_ERROR THEN

900: px_error_tbl => l_error_tbl);
901: END IF;
902: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
903: EXCEPTION
904: WHEN OKL_API.G_EXCEPTION_ERROR THEN
905: x_return_status := OKL_API.HANDLE_EXCEPTIONS
906: (
907: l_api_name,
908: G_PKG_NAME,

Line 905: x_return_status := OKL_API.HANDLE_EXCEPTIONS

901: END IF;
902: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
903: EXCEPTION
904: WHEN OKL_API.G_EXCEPTION_ERROR THEN
905: x_return_status := OKL_API.HANDLE_EXCEPTIONS
906: (
907: l_api_name,
908: G_PKG_NAME,
909: 'OKL_API.G_RET_STS_ERROR',

Line 909: 'OKL_API.G_RET_STS_ERROR',

905: x_return_status := OKL_API.HANDLE_EXCEPTIONS
906: (
907: l_api_name,
908: G_PKG_NAME,
909: 'OKL_API.G_RET_STS_ERROR',
910: x_msg_count,
911: x_msg_data,
912: '_PVT'
913: );

Line 914: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

910: x_msg_count,
911: x_msg_data,
912: '_PVT'
913: );
914: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
915: x_return_status := OKL_API.HANDLE_EXCEPTIONS
916: (
917: l_api_name,
918: G_PKG_NAME,

Line 915: x_return_status := OKL_API.HANDLE_EXCEPTIONS

911: x_msg_data,
912: '_PVT'
913: );
914: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
915: x_return_status := OKL_API.HANDLE_EXCEPTIONS
916: (
917: l_api_name,
918: G_PKG_NAME,
919: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 919: 'OKL_API.G_RET_STS_UNEXP_ERROR',

915: x_return_status := OKL_API.HANDLE_EXCEPTIONS
916: (
917: l_api_name,
918: G_PKG_NAME,
919: 'OKL_API.G_RET_STS_UNEXP_ERROR',
920: x_msg_count,
921: x_msg_data,
922: '_PVT'
923: );

Line 925: x_return_status := OKL_API.HANDLE_EXCEPTIONS

921: x_msg_data,
922: '_PVT'
923: );
924: WHEN OTHERS THEN
925: x_return_status := OKL_API.HANDLE_EXCEPTIONS
926: (
927: l_api_name,
928: G_PKG_NAME,
929: 'OTHERS',

Line 943: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

939: ------------------------------------------
940: -- insert_row for:OKL_CURE_REFUND_STAGE --
941: ------------------------------------------
942: PROCEDURE insert_row(
943: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
944: x_return_status OUT NOCOPY VARCHAR2,
945: x_msg_count OUT NOCOPY NUMBER,
946: x_msg_data OUT NOCOPY VARCHAR2,
947: p_crs_rec IN crs_rec_type,

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

948: x_crs_rec OUT NOCOPY crs_rec_type) IS
949:
950: l_api_version CONSTANT NUMBER := 1;
951: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
952: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
953: l_crs_rec crs_rec_type := p_crs_rec;
954: l_def_crs_rec crs_rec_type;
955: ----------------------------------------------
956: -- Set_Attributes for:OKL_CURE_REFUND_STAGE --

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

958: FUNCTION Set_Attributes (
959: p_crs_rec IN crs_rec_type,
960: x_crs_rec OUT NOCOPY crs_rec_type
961: ) RETURN VARCHAR2 IS
962: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
963: BEGIN
964: x_crs_rec := p_crs_rec;
965: RETURN(l_return_status);
966: END Set_Attributes;

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

964: x_crs_rec := p_crs_rec;
965: RETURN(l_return_status);
966: END Set_Attributes;
967: BEGIN
968: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
969: p_init_msg_list,
970: '_PVT',
971: x_return_status);
972: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

968: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
969: p_init_msg_list,
970: '_PVT',
971: x_return_status);
972: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
973: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
974: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
975: RAISE OKL_API.G_EXCEPTION_ERROR;
976: END IF;

Line 973: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

969: p_init_msg_list,
970: '_PVT',
971: x_return_status);
972: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
973: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
974: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
975: RAISE OKL_API.G_EXCEPTION_ERROR;
976: END IF;
977: --- Setting item atributes

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

970: '_PVT',
971: x_return_status);
972: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
973: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
974: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
975: RAISE OKL_API.G_EXCEPTION_ERROR;
976: END IF;
977: --- Setting item atributes
978: l_return_status := Set_Attributes(

Line 975: RAISE OKL_API.G_EXCEPTION_ERROR;

971: x_return_status);
972: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
973: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
974: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
975: RAISE OKL_API.G_EXCEPTION_ERROR;
976: END IF;
977: --- Setting item atributes
978: l_return_status := Set_Attributes(
979: p_crs_rec, -- IN

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

978: l_return_status := Set_Attributes(
979: p_crs_rec, -- IN
980: l_crs_rec); -- OUT
981: --- If any errors happen abort API
982: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
983: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
984: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
985: RAISE OKL_API.G_EXCEPTION_ERROR;
986: END IF;

Line 983: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

979: p_crs_rec, -- IN
980: l_crs_rec); -- OUT
981: --- If any errors happen abort API
982: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
983: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
984: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
985: RAISE OKL_API.G_EXCEPTION_ERROR;
986: END IF;
987: INSERT INTO OKL_CURE_REFUND_STAGE(

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

980: l_crs_rec); -- OUT
981: --- If any errors happen abort API
982: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
983: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
984: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
985: RAISE OKL_API.G_EXCEPTION_ERROR;
986: END IF;
987: INSERT INTO OKL_CURE_REFUND_STAGE(
988: cure_refund_stage_id,

Line 985: RAISE OKL_API.G_EXCEPTION_ERROR;

981: --- If any errors happen abort API
982: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
983: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
984: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
985: RAISE OKL_API.G_EXCEPTION_ERROR;
986: END IF;
987: INSERT INTO OKL_CURE_REFUND_STAGE(
988: cure_refund_stage_id,
989: status,

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

1052: l_crs_rec.last_update_login);
1053: -- Set OUT values
1054: x_crs_rec := l_crs_rec;
1055: x_return_status := l_return_status;
1056: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1057: EXCEPTION
1058: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1059: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1060: (

Line 1058: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1054: x_crs_rec := l_crs_rec;
1055: x_return_status := l_return_status;
1056: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1057: EXCEPTION
1058: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1059: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1060: (
1061: l_api_name,
1062: G_PKG_NAME,

Line 1059: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1055: x_return_status := l_return_status;
1056: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1057: EXCEPTION
1058: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1059: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1060: (
1061: l_api_name,
1062: G_PKG_NAME,
1063: 'OKL_API.G_RET_STS_ERROR',

Line 1063: 'OKL_API.G_RET_STS_ERROR',

1059: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1060: (
1061: l_api_name,
1062: G_PKG_NAME,
1063: 'OKL_API.G_RET_STS_ERROR',
1064: x_msg_count,
1065: x_msg_data,
1066: '_PVT'
1067: );

Line 1068: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1064: x_msg_count,
1065: x_msg_data,
1066: '_PVT'
1067: );
1068: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1069: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1070: (
1071: l_api_name,
1072: G_PKG_NAME,

Line 1069: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1065: x_msg_data,
1066: '_PVT'
1067: );
1068: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1069: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1070: (
1071: l_api_name,
1072: G_PKG_NAME,
1073: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1073: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1079: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1094: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1090: -- insert_row for :OKL_CURE_REFUND_STAGE_V --
1091: ---------------------------------------------
1092: PROCEDURE insert_row(
1093: p_api_version IN NUMBER,
1094: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1095: x_return_status OUT NOCOPY VARCHAR2,
1096: x_msg_count OUT NOCOPY NUMBER,
1097: x_msg_data OUT NOCOPY VARCHAR2,
1098: p_crsv_rec IN crsv_rec_type,

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

1099: x_crsv_rec OUT NOCOPY crsv_rec_type) IS
1100:
1101: l_api_version CONSTANT NUMBER := 1;
1102: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1103: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1104: l_crsv_rec crsv_rec_type := p_crsv_rec;
1105: l_def_crsv_rec crsv_rec_type;
1106: l_crs_rec crs_rec_type;
1107: lx_crs_rec crs_rec_type;

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

1126: FUNCTION Set_Attributes (
1127: p_crsv_rec IN crsv_rec_type,
1128: x_crsv_rec OUT NOCOPY crsv_rec_type
1129: ) RETURN VARCHAR2 IS
1130: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1131: BEGIN
1132: x_crsv_rec := p_crsv_rec;
1133: x_crsv_rec.OBJECT_VERSION_NUMBER := 1;
1134: RETURN(l_return_status);

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

1133: x_crsv_rec.OBJECT_VERSION_NUMBER := 1;
1134: RETURN(l_return_status);
1135: END Set_Attributes;
1136: BEGIN
1137: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1138: G_PKG_NAME,
1139: p_init_msg_list,
1140: l_api_version,
1141: p_api_version,

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

1140: l_api_version,
1141: p_api_version,
1142: '_PVT',
1143: x_return_status);
1144: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1145: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1147: RAISE OKL_API.G_EXCEPTION_ERROR;
1148: END IF;

Line 1145: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1141: p_api_version,
1142: '_PVT',
1143: x_return_status);
1144: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1145: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1147: RAISE OKL_API.G_EXCEPTION_ERROR;
1148: END IF;
1149: l_crsv_rec := null_out_defaults(p_crsv_rec);

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

1142: '_PVT',
1143: x_return_status);
1144: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1145: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1147: RAISE OKL_API.G_EXCEPTION_ERROR;
1148: END IF;
1149: l_crsv_rec := null_out_defaults(p_crsv_rec);
1150: -- Set primary key value

Line 1147: RAISE OKL_API.G_EXCEPTION_ERROR;

1143: x_return_status);
1144: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1145: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1147: RAISE OKL_API.G_EXCEPTION_ERROR;
1148: END IF;
1149: l_crsv_rec := null_out_defaults(p_crsv_rec);
1150: -- Set primary key value
1151: l_crsv_rec.CURE_REFUND_STAGE_ID := get_seq_id;

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

1153: l_return_Status := Set_Attributes(
1154: l_crsv_rec, -- IN
1155: l_def_crsv_rec); -- OUT
1156: --- If any errors happen abort API
1157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1160: RAISE OKL_API.G_EXCEPTION_ERROR;
1161: END IF;

Line 1158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1154: l_crsv_rec, -- IN
1155: l_def_crsv_rec); -- OUT
1156: --- If any errors happen abort API
1157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1160: RAISE OKL_API.G_EXCEPTION_ERROR;
1161: END IF;
1162: l_def_crsv_rec := fill_who_columns(l_def_crsv_rec);

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

1155: l_def_crsv_rec); -- OUT
1156: --- If any errors happen abort API
1157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1160: RAISE OKL_API.G_EXCEPTION_ERROR;
1161: END IF;
1162: l_def_crsv_rec := fill_who_columns(l_def_crsv_rec);
1163: --- Validate all non-missing attributes (Item Level Validation)

Line 1160: RAISE OKL_API.G_EXCEPTION_ERROR;

1156: --- If any errors happen abort API
1157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1160: RAISE OKL_API.G_EXCEPTION_ERROR;
1161: END IF;
1162: l_def_crsv_rec := fill_who_columns(l_def_crsv_rec);
1163: --- Validate all non-missing attributes (Item Level Validation)
1164: l_return_status := Validate_Attributes(l_def_crsv_rec);

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

1162: l_def_crsv_rec := fill_who_columns(l_def_crsv_rec);
1163: --- Validate all non-missing attributes (Item Level Validation)
1164: l_return_status := Validate_Attributes(l_def_crsv_rec);
1165: --- If any errors happen abort API
1166: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1168: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_ERROR;
1170: END IF;

Line 1167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1163: --- Validate all non-missing attributes (Item Level Validation)
1164: l_return_status := Validate_Attributes(l_def_crsv_rec);
1165: --- If any errors happen abort API
1166: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1168: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_ERROR;
1170: END IF;
1171: l_return_status := Validate_Record(l_def_crsv_rec);

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

1164: l_return_status := Validate_Attributes(l_def_crsv_rec);
1165: --- If any errors happen abort API
1166: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1168: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_ERROR;
1170: END IF;
1171: l_return_status := Validate_Record(l_def_crsv_rec);
1172: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1169: RAISE OKL_API.G_EXCEPTION_ERROR;

1165: --- If any errors happen abort API
1166: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1168: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_ERROR;
1170: END IF;
1171: l_return_status := Validate_Record(l_def_crsv_rec);
1172: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1168: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_ERROR;
1170: END IF;
1171: l_return_status := Validate_Record(l_def_crsv_rec);
1172: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1174: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1175: RAISE OKL_API.G_EXCEPTION_ERROR;
1176: END IF;

Line 1173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1169: RAISE OKL_API.G_EXCEPTION_ERROR;
1170: END IF;
1171: l_return_status := Validate_Record(l_def_crsv_rec);
1172: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1174: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1175: RAISE OKL_API.G_EXCEPTION_ERROR;
1176: END IF;
1177: -----------------------------------------

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

1170: END IF;
1171: l_return_status := Validate_Record(l_def_crsv_rec);
1172: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1174: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1175: RAISE OKL_API.G_EXCEPTION_ERROR;
1176: END IF;
1177: -----------------------------------------
1178: -- Move VIEW record to "Child" records --

Line 1175: RAISE OKL_API.G_EXCEPTION_ERROR;

1171: l_return_status := Validate_Record(l_def_crsv_rec);
1172: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1174: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1175: RAISE OKL_API.G_EXCEPTION_ERROR;
1176: END IF;
1177: -----------------------------------------
1178: -- Move VIEW record to "Child" records --
1179: -----------------------------------------

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

1188: x_msg_data,
1189: l_crs_rec,
1190: lx_crs_rec
1191: );
1192: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1193: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1194: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1195: RAISE OKL_API.G_EXCEPTION_ERROR;
1196: END IF;

Line 1193: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1189: l_crs_rec,
1190: lx_crs_rec
1191: );
1192: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1193: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1194: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1195: RAISE OKL_API.G_EXCEPTION_ERROR;
1196: END IF;
1197: migrate(lx_crs_rec, l_def_crsv_rec);

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

1190: lx_crs_rec
1191: );
1192: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1193: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1194: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1195: RAISE OKL_API.G_EXCEPTION_ERROR;
1196: END IF;
1197: migrate(lx_crs_rec, l_def_crsv_rec);
1198: -- Set OUT values

Line 1195: RAISE OKL_API.G_EXCEPTION_ERROR;

1191: );
1192: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1193: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1194: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1195: RAISE OKL_API.G_EXCEPTION_ERROR;
1196: END IF;
1197: migrate(lx_crs_rec, l_def_crsv_rec);
1198: -- Set OUT values
1199: x_crsv_rec := l_def_crsv_rec;

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

1197: migrate(lx_crs_rec, l_def_crsv_rec);
1198: -- Set OUT values
1199: x_crsv_rec := l_def_crsv_rec;
1200: x_return_status := l_return_status;
1201: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1202: EXCEPTION
1203: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1204: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1205: (

Line 1203: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1199: x_crsv_rec := l_def_crsv_rec;
1200: x_return_status := l_return_status;
1201: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1202: EXCEPTION
1203: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1204: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1205: (
1206: l_api_name,
1207: G_PKG_NAME,

Line 1204: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1208: 'OKL_API.G_RET_STS_ERROR',

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

Line 1213: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1214: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1218: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1224: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1239: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1235: -- PL/SQL TBL insert_row for:CRSV_TBL --
1236: ----------------------------------------
1237: PROCEDURE insert_row(
1238: p_api_version IN NUMBER,
1239: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1240: x_return_status OUT NOCOPY VARCHAR2,
1241: x_msg_count OUT NOCOPY NUMBER,
1242: x_msg_data OUT NOCOPY VARCHAR2,
1243: p_crsv_tbl IN crsv_tbl_type,

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

1241: x_msg_count OUT NOCOPY NUMBER,
1242: x_msg_data OUT NOCOPY VARCHAR2,
1243: p_crsv_tbl IN crsv_tbl_type,
1244: x_crsv_tbl OUT NOCOPY crsv_tbl_type,
1245: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1246:
1247: l_api_version CONSTANT NUMBER := 1;
1248: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1249: i NUMBER := 0;

Line 1251: OKL_API.init_msg_list(p_init_msg_list);

1247: l_api_version CONSTANT NUMBER := 1;
1248: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1249: i NUMBER := 0;
1250: BEGIN
1251: OKL_API.init_msg_list(p_init_msg_list);
1252: -- Make sure PL/SQL table has records in it before passing
1253: IF (p_crsv_tbl.COUNT > 0) THEN
1254: i := p_crsv_tbl.FIRST;
1255: LOOP

Line 1257: l_error_rec OKL_API.ERROR_REC_TYPE;

1253: IF (p_crsv_tbl.COUNT > 0) THEN
1254: i := p_crsv_tbl.FIRST;
1255: LOOP
1256: DECLARE
1257: l_error_rec OKL_API.ERROR_REC_TYPE;
1258: BEGIN
1259: l_error_rec.api_name := l_api_name;
1260: l_error_rec.api_package := G_PKG_NAME;
1261: l_error_rec.idx := i;

Line 1264: p_init_msg_list => OKL_API.G_FALSE,

1260: l_error_rec.api_package := G_PKG_NAME;
1261: l_error_rec.idx := i;
1262: insert_row (
1263: p_api_version => p_api_version,
1264: p_init_msg_list => OKL_API.G_FALSE,
1265: x_return_status => l_error_rec.error_type,
1266: x_msg_count => l_error_rec.msg_count,
1267: x_msg_data => l_error_rec.msg_data,
1268: p_crsv_rec => p_crsv_tbl(i),

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

1266: x_msg_count => l_error_rec.msg_count,
1267: x_msg_data => l_error_rec.msg_data,
1268: p_crsv_rec => p_crsv_tbl(i),
1269: x_crsv_rec => x_crsv_tbl(i));
1270: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
1271: l_error_rec.sqlcode := SQLCODE;
1272: load_error_tbl(l_error_rec, px_error_tbl);
1273: ELSE
1274: x_msg_count := l_error_rec.msg_count;

Line 1278: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1274: x_msg_count := l_error_rec.msg_count;
1275: x_msg_data := l_error_rec.msg_data;
1276: END IF;
1277: EXCEPTION
1278: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1279: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1280: l_error_rec.sqlcode := SQLCODE;
1281: load_error_tbl(l_error_rec, px_error_tbl);
1282: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

1275: x_msg_data := l_error_rec.msg_data;
1276: END IF;
1277: EXCEPTION
1278: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1279: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1280: l_error_rec.sqlcode := SQLCODE;
1281: load_error_tbl(l_error_rec, px_error_tbl);
1282: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1283: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1282: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1278: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1279: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1280: l_error_rec.sqlcode := SQLCODE;
1281: load_error_tbl(l_error_rec, px_error_tbl);
1282: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1283: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1284: l_error_rec.sqlcode := SQLCODE;
1285: load_error_tbl(l_error_rec, px_error_tbl);
1286: WHEN OTHERS THEN

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

1279: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1280: l_error_rec.sqlcode := SQLCODE;
1281: load_error_tbl(l_error_rec, px_error_tbl);
1282: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1283: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1284: l_error_rec.sqlcode := SQLCODE;
1285: load_error_tbl(l_error_rec, px_error_tbl);
1286: WHEN OTHERS THEN
1287: l_error_rec.error_type := 'OTHERS';

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

1294: END IF;
1295: -- Loop through the error_tbl to find the error with the highest severity
1296: -- and return it.
1297: x_return_status := find_highest_exception(px_error_tbl);
1298: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1299: EXCEPTION
1300: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1301: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1302: (

Line 1300: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1296: -- and return it.
1297: x_return_status := find_highest_exception(px_error_tbl);
1298: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1299: EXCEPTION
1300: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1301: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1302: (
1303: l_api_name,
1304: G_PKG_NAME,

Line 1301: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1297: x_return_status := find_highest_exception(px_error_tbl);
1298: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1299: EXCEPTION
1300: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1301: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1302: (
1303: l_api_name,
1304: G_PKG_NAME,
1305: 'OKL_API.G_RET_STS_ERROR',

Line 1305: 'OKL_API.G_RET_STS_ERROR',

1301: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1302: (
1303: l_api_name,
1304: G_PKG_NAME,
1305: 'OKL_API.G_RET_STS_ERROR',
1306: x_msg_count,
1307: x_msg_data,
1308: '_PVT'
1309: );

Line 1310: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1306: x_msg_count,
1307: x_msg_data,
1308: '_PVT'
1309: );
1310: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1311: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1312: (
1313: l_api_name,
1314: G_PKG_NAME,

Line 1311: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1307: x_msg_data,
1308: '_PVT'
1309: );
1310: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1311: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1312: (
1313: l_api_name,
1314: G_PKG_NAME,
1315: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1315: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1311: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1312: (
1313: l_api_name,
1314: G_PKG_NAME,
1315: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1316: x_msg_count,
1317: x_msg_data,
1318: '_PVT'
1319: );

Line 1321: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1317: x_msg_data,
1318: '_PVT'
1319: );
1320: WHEN OTHERS THEN
1321: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1322: (
1323: l_api_name,
1324: G_PKG_NAME,
1325: 'OTHERS',

Line 1337: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1333: -- PL/SQL TBL insert_row for:CRSV_TBL --
1334: ----------------------------------------
1335: PROCEDURE insert_row(
1336: p_api_version IN NUMBER,
1337: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1338: x_return_status OUT NOCOPY VARCHAR2,
1339: x_msg_count OUT NOCOPY NUMBER,
1340: x_msg_data OUT NOCOPY VARCHAR2,
1341: p_crsv_tbl IN crsv_tbl_type,

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

1342: x_crsv_tbl OUT NOCOPY crsv_tbl_type) IS
1343:
1344: l_api_version CONSTANT NUMBER := 1;
1345: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1346: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1347: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1348: BEGIN
1349: OKL_API.init_msg_list(p_init_msg_list);
1350: -- Make sure PL/SQL table has records in it before passing

Line 1347: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1343:
1344: l_api_version CONSTANT NUMBER := 1;
1345: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1346: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1347: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1348: BEGIN
1349: OKL_API.init_msg_list(p_init_msg_list);
1350: -- Make sure PL/SQL table has records in it before passing
1351: IF (p_crsv_tbl.COUNT > 0) THEN

Line 1349: OKL_API.init_msg_list(p_init_msg_list);

1345: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1346: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1347: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1348: BEGIN
1349: OKL_API.init_msg_list(p_init_msg_list);
1350: -- Make sure PL/SQL table has records in it before passing
1351: IF (p_crsv_tbl.COUNT > 0) THEN
1352: insert_row (
1353: p_api_version => p_api_version,

Line 1354: p_init_msg_list => OKL_API.G_FALSE,

1350: -- Make sure PL/SQL table has records in it before passing
1351: IF (p_crsv_tbl.COUNT > 0) THEN
1352: insert_row (
1353: p_api_version => p_api_version,
1354: p_init_msg_list => OKL_API.G_FALSE,
1355: x_return_status => x_return_status,
1356: x_msg_count => x_msg_count,
1357: x_msg_data => x_msg_data,
1358: p_crsv_tbl => p_crsv_tbl,

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

1358: p_crsv_tbl => p_crsv_tbl,
1359: x_crsv_tbl => x_crsv_tbl,
1360: px_error_tbl => l_error_tbl);
1361: END IF;
1362: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1363: EXCEPTION
1364: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1365: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1366: (

Line 1364: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1360: px_error_tbl => l_error_tbl);
1361: END IF;
1362: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1363: EXCEPTION
1364: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1365: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1366: (
1367: l_api_name,
1368: G_PKG_NAME,

Line 1365: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1361: END IF;
1362: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1363: EXCEPTION
1364: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1365: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1366: (
1367: l_api_name,
1368: G_PKG_NAME,
1369: 'OKL_API.G_RET_STS_ERROR',

Line 1369: 'OKL_API.G_RET_STS_ERROR',

1365: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1366: (
1367: l_api_name,
1368: G_PKG_NAME,
1369: 'OKL_API.G_RET_STS_ERROR',
1370: x_msg_count,
1371: x_msg_data,
1372: '_PVT'
1373: );

Line 1374: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1370: x_msg_count,
1371: x_msg_data,
1372: '_PVT'
1373: );
1374: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1375: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1376: (
1377: l_api_name,
1378: G_PKG_NAME,

Line 1375: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1371: x_msg_data,
1372: '_PVT'
1373: );
1374: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1375: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1376: (
1377: l_api_name,
1378: G_PKG_NAME,
1379: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1379: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1375: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1376: (
1377: l_api_name,
1378: G_PKG_NAME,
1379: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1380: x_msg_count,
1381: x_msg_data,
1382: '_PVT'
1383: );

Line 1385: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1381: x_msg_data,
1382: '_PVT'
1383: );
1384: WHEN OTHERS THEN
1385: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1386: (
1387: l_api_name,
1388: G_PKG_NAME,
1389: 'OTHERS',

Line 1403: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1399: ----------------------------------------
1400: -- lock_row for:OKL_CURE_REFUND_STAGE --
1401: ----------------------------------------
1402: PROCEDURE lock_row(
1403: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1404: x_return_status OUT NOCOPY VARCHAR2,
1405: x_msg_count OUT NOCOPY NUMBER,
1406: x_msg_data OUT NOCOPY VARCHAR2,
1407: p_crs_rec IN crs_rec_type) IS

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

1420: FROM OKL_CURE_REFUND_STAGE
1421: WHERE CURE_REFUND_STAGE_ID = p_crs_rec.cure_refund_stage_id;
1422: l_api_version CONSTANT NUMBER := 1;
1423: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1424: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1425: l_object_version_number OKL_CURE_REFUND_STAGE.OBJECT_VERSION_NUMBER%TYPE;
1426: lc_object_version_number OKL_CURE_REFUND_STAGE.OBJECT_VERSION_NUMBER%TYPE;
1427: l_row_notfound BOOLEAN := FALSE;
1428: lc_row_notfound BOOLEAN := FALSE;

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

1426: lc_object_version_number OKL_CURE_REFUND_STAGE.OBJECT_VERSION_NUMBER%TYPE;
1427: l_row_notfound BOOLEAN := FALSE;
1428: lc_row_notfound BOOLEAN := FALSE;
1429: BEGIN
1430: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1431: p_init_msg_list,
1432: '_PVT',
1433: x_return_status);
1434: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1430: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1431: p_init_msg_list,
1432: '_PVT',
1433: x_return_status);
1434: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1435: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1436: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1437: RAISE OKL_API.G_EXCEPTION_ERROR;
1438: END IF;

Line 1435: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1431: p_init_msg_list,
1432: '_PVT',
1433: x_return_status);
1434: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1435: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1436: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1437: RAISE OKL_API.G_EXCEPTION_ERROR;
1438: END IF;
1439: BEGIN

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

1432: '_PVT',
1433: x_return_status);
1434: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1435: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1436: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1437: RAISE OKL_API.G_EXCEPTION_ERROR;
1438: END IF;
1439: BEGIN
1440: OPEN lock_csr(p_crs_rec);

Line 1437: RAISE OKL_API.G_EXCEPTION_ERROR;

1433: x_return_status);
1434: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1435: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1436: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1437: RAISE OKL_API.G_EXCEPTION_ERROR;
1438: END IF;
1439: BEGIN
1440: OPEN lock_csr(p_crs_rec);
1441: FETCH lock_csr INTO l_object_version_number;

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

1445: WHEN E_Resource_Busy THEN
1446: IF (lock_csr%ISOPEN) THEN
1447: CLOSE lock_csr;
1448: END IF;
1449: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1450: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1451: END;
1452:
1453: IF ( l_row_notfound ) THEN

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

1456: lc_row_notfound := lchk_csr%NOTFOUND;
1457: CLOSE lchk_csr;
1458: END IF;
1459: IF (lc_row_notfound) THEN
1460: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1461: RAISE OKL_API.G_EXCEPTION_ERROR;
1462: ELSIF lc_object_version_number > p_crs_rec.object_version_number THEN
1463: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1464: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1461: RAISE OKL_API.G_EXCEPTION_ERROR;

1457: CLOSE lchk_csr;
1458: END IF;
1459: IF (lc_row_notfound) THEN
1460: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1461: RAISE OKL_API.G_EXCEPTION_ERROR;
1462: ELSIF lc_object_version_number > p_crs_rec.object_version_number THEN
1463: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1464: RAISE OKL_API.G_EXCEPTION_ERROR;
1465: ELSIF lc_object_version_number <> p_crs_rec.object_version_number THEN

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

1459: IF (lc_row_notfound) THEN
1460: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1461: RAISE OKL_API.G_EXCEPTION_ERROR;
1462: ELSIF lc_object_version_number > p_crs_rec.object_version_number THEN
1463: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1464: RAISE OKL_API.G_EXCEPTION_ERROR;
1465: ELSIF lc_object_version_number <> p_crs_rec.object_version_number THEN
1466: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1467: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1464: RAISE OKL_API.G_EXCEPTION_ERROR;

1460: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1461: RAISE OKL_API.G_EXCEPTION_ERROR;
1462: ELSIF lc_object_version_number > p_crs_rec.object_version_number THEN
1463: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1464: RAISE OKL_API.G_EXCEPTION_ERROR;
1465: ELSIF lc_object_version_number <> p_crs_rec.object_version_number THEN
1466: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1467: RAISE OKL_API.G_EXCEPTION_ERROR;
1468: ELSIF lc_object_version_number = -1 THEN

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

1462: ELSIF lc_object_version_number > p_crs_rec.object_version_number THEN
1463: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1464: RAISE OKL_API.G_EXCEPTION_ERROR;
1465: ELSIF lc_object_version_number <> p_crs_rec.object_version_number THEN
1466: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1467: RAISE OKL_API.G_EXCEPTION_ERROR;
1468: ELSIF lc_object_version_number = -1 THEN
1469: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1470: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1467: RAISE OKL_API.G_EXCEPTION_ERROR;

1463: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1464: RAISE OKL_API.G_EXCEPTION_ERROR;
1465: ELSIF lc_object_version_number <> p_crs_rec.object_version_number THEN
1466: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1467: RAISE OKL_API.G_EXCEPTION_ERROR;
1468: ELSIF lc_object_version_number = -1 THEN
1469: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1470: RAISE OKL_API.G_EXCEPTION_ERROR;
1471: END IF;

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

1465: ELSIF lc_object_version_number <> p_crs_rec.object_version_number THEN
1466: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1467: RAISE OKL_API.G_EXCEPTION_ERROR;
1468: ELSIF lc_object_version_number = -1 THEN
1469: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1470: RAISE OKL_API.G_EXCEPTION_ERROR;
1471: END IF;
1472: x_return_status := l_return_status;
1473: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1470: RAISE OKL_API.G_EXCEPTION_ERROR;

1466: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1467: RAISE OKL_API.G_EXCEPTION_ERROR;
1468: ELSIF lc_object_version_number = -1 THEN
1469: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1470: RAISE OKL_API.G_EXCEPTION_ERROR;
1471: END IF;
1472: x_return_status := l_return_status;
1473: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1474: EXCEPTION

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

1469: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1470: RAISE OKL_API.G_EXCEPTION_ERROR;
1471: END IF;
1472: x_return_status := l_return_status;
1473: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1474: EXCEPTION
1475: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1476: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1477: (

Line 1475: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1471: END IF;
1472: x_return_status := l_return_status;
1473: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1474: EXCEPTION
1475: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1476: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1477: (
1478: l_api_name,
1479: G_PKG_NAME,

Line 1476: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1472: x_return_status := l_return_status;
1473: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1474: EXCEPTION
1475: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1476: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1477: (
1478: l_api_name,
1479: G_PKG_NAME,
1480: 'OKL_API.G_RET_STS_ERROR',

Line 1480: 'OKL_API.G_RET_STS_ERROR',

1476: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1477: (
1478: l_api_name,
1479: G_PKG_NAME,
1480: 'OKL_API.G_RET_STS_ERROR',
1481: x_msg_count,
1482: x_msg_data,
1483: '_PVT'
1484: );

Line 1485: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1486: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1490: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1496: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1511: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1507: -- lock_row for: OKL_CURE_REFUND_STAGE_V --
1508: -------------------------------------------
1509: PROCEDURE lock_row(
1510: p_api_version IN NUMBER,
1511: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1512: x_return_status OUT NOCOPY VARCHAR2,
1513: x_msg_count OUT NOCOPY NUMBER,
1514: x_msg_data OUT NOCOPY VARCHAR2,
1515: p_crsv_rec IN crsv_rec_type) IS

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

1515: p_crsv_rec IN crsv_rec_type) IS
1516:
1517: l_api_version CONSTANT NUMBER := 1;
1518: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1519: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1520: l_crs_rec crs_rec_type;
1521: BEGIN
1522: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1523: G_PKG_NAME,

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

1518: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1519: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1520: l_crs_rec crs_rec_type;
1521: BEGIN
1522: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1523: G_PKG_NAME,
1524: p_init_msg_list,
1525: l_api_version,
1526: p_api_version,

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

1525: l_api_version,
1526: p_api_version,
1527: '_PVT',
1528: x_return_status);
1529: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1530: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1531: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1532: RAISE OKL_API.G_EXCEPTION_ERROR;
1533: END IF;

Line 1530: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1526: p_api_version,
1527: '_PVT',
1528: x_return_status);
1529: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1530: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1531: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1532: RAISE OKL_API.G_EXCEPTION_ERROR;
1533: END IF;
1534: -----------------------------------------

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

1527: '_PVT',
1528: x_return_status);
1529: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1530: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1531: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1532: RAISE OKL_API.G_EXCEPTION_ERROR;
1533: END IF;
1534: -----------------------------------------
1535: -- Move VIEW record to "Child" records --

Line 1532: RAISE OKL_API.G_EXCEPTION_ERROR;

1528: x_return_status);
1529: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1530: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1531: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1532: RAISE OKL_API.G_EXCEPTION_ERROR;
1533: END IF;
1534: -----------------------------------------
1535: -- Move VIEW record to "Child" records --
1536: -----------------------------------------

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

1544: x_msg_count,
1545: x_msg_data,
1546: l_crs_rec
1547: );
1548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1551: RAISE OKL_API.G_EXCEPTION_ERROR;
1552: END IF;

Line 1549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1545: x_msg_data,
1546: l_crs_rec
1547: );
1548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1551: RAISE OKL_API.G_EXCEPTION_ERROR;
1552: END IF;
1553: x_return_status := l_return_status;

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

1546: l_crs_rec
1547: );
1548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1551: RAISE OKL_API.G_EXCEPTION_ERROR;
1552: END IF;
1553: x_return_status := l_return_status;
1554: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1551: RAISE OKL_API.G_EXCEPTION_ERROR;

1547: );
1548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1551: RAISE OKL_API.G_EXCEPTION_ERROR;
1552: END IF;
1553: x_return_status := l_return_status;
1554: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1555: EXCEPTION

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

1550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1551: RAISE OKL_API.G_EXCEPTION_ERROR;
1552: END IF;
1553: x_return_status := l_return_status;
1554: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1555: EXCEPTION
1556: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1557: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1558: (

Line 1556: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1552: END IF;
1553: x_return_status := l_return_status;
1554: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1555: EXCEPTION
1556: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1557: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1558: (
1559: l_api_name,
1560: G_PKG_NAME,

Line 1557: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1553: x_return_status := l_return_status;
1554: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1555: EXCEPTION
1556: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1557: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1558: (
1559: l_api_name,
1560: G_PKG_NAME,
1561: 'OKL_API.G_RET_STS_ERROR',

Line 1561: 'OKL_API.G_RET_STS_ERROR',

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

Line 1566: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1567: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1571: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1577: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1573: x_msg_data,
1574: '_PVT'
1575: );
1576: WHEN OTHERS THEN
1577: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1578: (
1579: l_api_name,
1580: G_PKG_NAME,
1581: 'OTHERS',

Line 1592: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1588: -- PL/SQL TBL lock_row for:CRSV_TBL --
1589: --------------------------------------
1590: PROCEDURE lock_row(
1591: p_api_version IN NUMBER,
1592: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1593: x_return_status OUT NOCOPY VARCHAR2,
1594: x_msg_count OUT NOCOPY NUMBER,
1595: x_msg_data OUT NOCOPY VARCHAR2,
1596: p_crsv_tbl IN crsv_tbl_type,

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

1593: x_return_status OUT NOCOPY VARCHAR2,
1594: x_msg_count OUT NOCOPY NUMBER,
1595: x_msg_data OUT NOCOPY VARCHAR2,
1596: p_crsv_tbl IN crsv_tbl_type,
1597: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1598:
1599: l_api_version CONSTANT NUMBER := 1;
1600: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1601: i NUMBER := 0;

Line 1603: OKL_API.init_msg_list(p_init_msg_list);

1599: l_api_version CONSTANT NUMBER := 1;
1600: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1601: i NUMBER := 0;
1602: BEGIN
1603: OKL_API.init_msg_list(p_init_msg_list);
1604: -- Make sure PL/SQL table has recrods in it before passing
1605: IF (p_crsv_tbl.COUNT > 0) THEN
1606: i := p_crsv_tbl.FIRST;
1607: LOOP

Line 1609: l_error_rec OKL_API.ERROR_REC_TYPE;

1605: IF (p_crsv_tbl.COUNT > 0) THEN
1606: i := p_crsv_tbl.FIRST;
1607: LOOP
1608: DECLARE
1609: l_error_rec OKL_API.ERROR_REC_TYPE;
1610: BEGIN
1611: l_error_rec.api_name := l_api_name;
1612: l_error_rec.api_package := G_PKG_NAME;
1613: l_error_rec.idx := i;

Line 1616: p_init_msg_list => OKL_API.G_FALSE,

1612: l_error_rec.api_package := G_PKG_NAME;
1613: l_error_rec.idx := i;
1614: lock_row(
1615: p_api_version => p_api_version,
1616: p_init_msg_list => OKL_API.G_FALSE,
1617: x_return_status => l_error_rec.error_type,
1618: x_msg_count => l_error_rec.msg_count,
1619: x_msg_data => l_error_rec.msg_data,
1620: p_crsv_rec => p_crsv_tbl(i));

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

1617: x_return_status => l_error_rec.error_type,
1618: x_msg_count => l_error_rec.msg_count,
1619: x_msg_data => l_error_rec.msg_data,
1620: p_crsv_rec => p_crsv_tbl(i));
1621: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
1622: l_error_rec.sqlcode := SQLCODE;
1623: load_error_tbl(l_error_rec, px_error_tbl);
1624: ELSE
1625: x_msg_count := l_error_rec.msg_count;

Line 1629: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1625: x_msg_count := l_error_rec.msg_count;
1626: x_msg_data := l_error_rec.msg_data;
1627: END IF;
1628: EXCEPTION
1629: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1630: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1631: l_error_rec.sqlcode := SQLCODE;
1632: load_error_tbl(l_error_rec, px_error_tbl);
1633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

1626: x_msg_data := l_error_rec.msg_data;
1627: END IF;
1628: EXCEPTION
1629: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1630: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1631: l_error_rec.sqlcode := SQLCODE;
1632: load_error_tbl(l_error_rec, px_error_tbl);
1633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1634: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1629: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1630: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1631: l_error_rec.sqlcode := SQLCODE;
1632: load_error_tbl(l_error_rec, px_error_tbl);
1633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1634: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1635: l_error_rec.sqlcode := SQLCODE;
1636: load_error_tbl(l_error_rec, px_error_tbl);
1637: WHEN OTHERS THEN

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

1630: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1631: l_error_rec.sqlcode := SQLCODE;
1632: load_error_tbl(l_error_rec, px_error_tbl);
1633: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1634: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1635: l_error_rec.sqlcode := SQLCODE;
1636: load_error_tbl(l_error_rec, px_error_tbl);
1637: WHEN OTHERS THEN
1638: l_error_rec.error_type := 'OTHERS';

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

1645: END IF;
1646: -- Loop through the error_tbl to find the error with the highest severity
1647: -- and return it.
1648: x_return_status := find_highest_exception(px_error_tbl);
1649: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1650: EXCEPTION
1651: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1652: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1653: (

Line 1651: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1647: -- and return it.
1648: x_return_status := find_highest_exception(px_error_tbl);
1649: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1650: EXCEPTION
1651: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1652: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1653: (
1654: l_api_name,
1655: G_PKG_NAME,

Line 1652: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1648: x_return_status := find_highest_exception(px_error_tbl);
1649: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1650: EXCEPTION
1651: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1652: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1653: (
1654: l_api_name,
1655: G_PKG_NAME,
1656: 'OKL_API.G_RET_STS_ERROR',

Line 1656: 'OKL_API.G_RET_STS_ERROR',

1652: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1653: (
1654: l_api_name,
1655: G_PKG_NAME,
1656: 'OKL_API.G_RET_STS_ERROR',
1657: x_msg_count,
1658: x_msg_data,
1659: '_PVT'
1660: );

Line 1661: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1662: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1658: x_msg_data,
1659: '_PVT'
1660: );
1661: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1662: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1663: (
1664: l_api_name,
1665: G_PKG_NAME,
1666: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1666: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1672: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1668: x_msg_data,
1669: '_PVT'
1670: );
1671: WHEN OTHERS THEN
1672: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1673: (
1674: l_api_name,
1675: G_PKG_NAME,
1676: 'OTHERS',

Line 1687: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1683: -- PL/SQL TBL lock_row for:CRSV_TBL --
1684: --------------------------------------
1685: PROCEDURE lock_row(
1686: p_api_version IN NUMBER,
1687: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1688: x_return_status OUT NOCOPY VARCHAR2,
1689: x_msg_count OUT NOCOPY NUMBER,
1690: x_msg_data OUT NOCOPY VARCHAR2,
1691: p_crsv_tbl IN crsv_tbl_type) IS

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

1691: p_crsv_tbl IN crsv_tbl_type) IS
1692:
1693: l_api_version CONSTANT NUMBER := 1;
1694: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1695: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1696: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1697: BEGIN
1698: OKL_API.init_msg_list(p_init_msg_list);
1699: -- Make sure PL/SQL table has recrods in it before passing

Line 1696: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1692:
1693: l_api_version CONSTANT NUMBER := 1;
1694: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1695: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1696: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1697: BEGIN
1698: OKL_API.init_msg_list(p_init_msg_list);
1699: -- Make sure PL/SQL table has recrods in it before passing
1700: IF (p_crsv_tbl.COUNT > 0) THEN

Line 1698: OKL_API.init_msg_list(p_init_msg_list);

1694: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1695: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1696: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1697: BEGIN
1698: OKL_API.init_msg_list(p_init_msg_list);
1699: -- Make sure PL/SQL table has recrods in it before passing
1700: IF (p_crsv_tbl.COUNT > 0) THEN
1701: lock_row(
1702: p_api_version => p_api_version,

Line 1703: p_init_msg_list => OKL_API.G_FALSE,

1699: -- Make sure PL/SQL table has recrods in it before passing
1700: IF (p_crsv_tbl.COUNT > 0) THEN
1701: lock_row(
1702: p_api_version => p_api_version,
1703: p_init_msg_list => OKL_API.G_FALSE,
1704: x_return_status => x_return_status,
1705: x_msg_count => x_msg_count,
1706: x_msg_data => x_msg_data,
1707: p_crsv_tbl => p_crsv_tbl,

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

1706: x_msg_data => x_msg_data,
1707: p_crsv_tbl => p_crsv_tbl,
1708: px_error_tbl => l_error_tbl);
1709: END IF;
1710: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1711: EXCEPTION
1712: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1713: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1714: (

Line 1712: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1708: px_error_tbl => l_error_tbl);
1709: END IF;
1710: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1711: EXCEPTION
1712: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1713: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1714: (
1715: l_api_name,
1716: G_PKG_NAME,

Line 1713: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1709: END IF;
1710: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1711: EXCEPTION
1712: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1713: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1714: (
1715: l_api_name,
1716: G_PKG_NAME,
1717: 'OKL_API.G_RET_STS_ERROR',

Line 1717: 'OKL_API.G_RET_STS_ERROR',

1713: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1714: (
1715: l_api_name,
1716: G_PKG_NAME,
1717: 'OKL_API.G_RET_STS_ERROR',
1718: x_msg_count,
1719: x_msg_data,
1720: '_PVT'
1721: );

Line 1722: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1723: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1719: x_msg_data,
1720: '_PVT'
1721: );
1722: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1723: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1724: (
1725: l_api_name,
1726: G_PKG_NAME,
1727: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1727: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1733: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1729: x_msg_data,
1730: '_PVT'
1731: );
1732: WHEN OTHERS THEN
1733: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1734: (
1735: l_api_name,
1736: G_PKG_NAME,
1737: 'OTHERS',

Line 1750: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1746: ------------------------------------------
1747: -- update_row for:OKL_CURE_REFUND_STAGE --
1748: ------------------------------------------
1749: PROCEDURE update_row(
1750: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1751: x_return_status OUT NOCOPY VARCHAR2,
1752: x_msg_count OUT NOCOPY NUMBER,
1753: x_msg_data OUT NOCOPY VARCHAR2,
1754: p_crs_rec IN crs_rec_type,

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

1755: x_crs_rec OUT NOCOPY crs_rec_type) IS
1756:
1757: l_api_version CONSTANT NUMBER := 1;
1758: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1759: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1760: l_crs_rec crs_rec_type := p_crs_rec;
1761: l_def_crs_rec crs_rec_type;
1762: l_row_notfound BOOLEAN := TRUE;
1763: ----------------------------------

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

1768: x_crs_rec OUT NOCOPY crs_rec_type
1769: ) RETURN VARCHAR2 IS
1770: l_crs_rec crs_rec_type;
1771: l_row_notfound BOOLEAN := TRUE;
1772: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1773: BEGIN
1774: x_crs_rec := p_crs_rec;
1775: -- Get current database values
1776: l_crs_rec := get_rec(p_crs_rec, l_return_status);

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

1773: BEGIN
1774: x_crs_rec := p_crs_rec;
1775: -- Get current database values
1776: l_crs_rec := get_rec(p_crs_rec, l_return_status);
1777: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1778: IF (x_crs_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM)
1779: THEN
1780: x_crs_rec.cure_refund_stage_id := l_crs_rec.cure_refund_stage_id;
1781: END IF;

Line 1778: IF (x_crs_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM)

1774: x_crs_rec := p_crs_rec;
1775: -- Get current database values
1776: l_crs_rec := get_rec(p_crs_rec, l_return_status);
1777: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1778: IF (x_crs_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM)
1779: THEN
1780: x_crs_rec.cure_refund_stage_id := l_crs_rec.cure_refund_stage_id;
1781: END IF;
1782: IF (x_crs_rec.status = OKL_API.G_MISS_CHAR)

Line 1782: IF (x_crs_rec.status = OKL_API.G_MISS_CHAR)

1778: IF (x_crs_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM)
1779: THEN
1780: x_crs_rec.cure_refund_stage_id := l_crs_rec.cure_refund_stage_id;
1781: END IF;
1782: IF (x_crs_rec.status = OKL_API.G_MISS_CHAR)
1783: THEN
1784: x_crs_rec.status := l_crs_rec.status;
1785: END IF;
1786: IF (x_crs_rec.negotiated_amount = OKL_API.G_MISS_NUM)

Line 1786: IF (x_crs_rec.negotiated_amount = OKL_API.G_MISS_NUM)

1782: IF (x_crs_rec.status = OKL_API.G_MISS_CHAR)
1783: THEN
1784: x_crs_rec.status := l_crs_rec.status;
1785: END IF;
1786: IF (x_crs_rec.negotiated_amount = OKL_API.G_MISS_NUM)
1787: THEN
1788: x_crs_rec.negotiated_amount := l_crs_rec.negotiated_amount;
1789: END IF;
1790: IF (x_crs_rec.received_amount = OKL_API.G_MISS_NUM)

Line 1790: IF (x_crs_rec.received_amount = OKL_API.G_MISS_NUM)

1786: IF (x_crs_rec.negotiated_amount = OKL_API.G_MISS_NUM)
1787: THEN
1788: x_crs_rec.negotiated_amount := l_crs_rec.negotiated_amount;
1789: END IF;
1790: IF (x_crs_rec.received_amount = OKL_API.G_MISS_NUM)
1791: THEN
1792: x_crs_rec.received_amount := l_crs_rec.received_amount;
1793: END IF;
1794: IF (x_crs_rec.chr_id = OKL_API.G_MISS_NUM)

Line 1794: IF (x_crs_rec.chr_id = OKL_API.G_MISS_NUM)

1790: IF (x_crs_rec.received_amount = OKL_API.G_MISS_NUM)
1791: THEN
1792: x_crs_rec.received_amount := l_crs_rec.received_amount;
1793: END IF;
1794: IF (x_crs_rec.chr_id = OKL_API.G_MISS_NUM)
1795: THEN
1796: x_crs_rec.chr_id := l_crs_rec.chr_id;
1797: END IF;
1798: IF (x_crs_rec.object_version_number = OKL_API.G_MISS_NUM)

Line 1798: IF (x_crs_rec.object_version_number = OKL_API.G_MISS_NUM)

1794: IF (x_crs_rec.chr_id = OKL_API.G_MISS_NUM)
1795: THEN
1796: x_crs_rec.chr_id := l_crs_rec.chr_id;
1797: END IF;
1798: IF (x_crs_rec.object_version_number = OKL_API.G_MISS_NUM)
1799: THEN
1800: x_crs_rec.object_version_number := l_crs_rec.object_version_number;
1801: END IF;
1802: IF (x_crs_rec.vendor_id = OKL_API.G_MISS_NUM)

Line 1802: IF (x_crs_rec.vendor_id = OKL_API.G_MISS_NUM)

1798: IF (x_crs_rec.object_version_number = OKL_API.G_MISS_NUM)
1799: THEN
1800: x_crs_rec.object_version_number := l_crs_rec.object_version_number;
1801: END IF;
1802: IF (x_crs_rec.vendor_id = OKL_API.G_MISS_NUM)
1803: THEN
1804: x_crs_rec.vendor_id := l_crs_rec.vendor_id;
1805: END IF;
1806: IF (x_crs_rec.request_id = OKL_API.G_MISS_NUM)

Line 1806: IF (x_crs_rec.request_id = OKL_API.G_MISS_NUM)

1802: IF (x_crs_rec.vendor_id = OKL_API.G_MISS_NUM)
1803: THEN
1804: x_crs_rec.vendor_id := l_crs_rec.vendor_id;
1805: END IF;
1806: IF (x_crs_rec.request_id = OKL_API.G_MISS_NUM)
1807: THEN
1808: x_crs_rec.request_id := l_crs_rec.request_id;
1809: END IF;
1810: IF (x_crs_rec.program_application_id = OKL_API.G_MISS_NUM)

Line 1810: IF (x_crs_rec.program_application_id = OKL_API.G_MISS_NUM)

1806: IF (x_crs_rec.request_id = OKL_API.G_MISS_NUM)
1807: THEN
1808: x_crs_rec.request_id := l_crs_rec.request_id;
1809: END IF;
1810: IF (x_crs_rec.program_application_id = OKL_API.G_MISS_NUM)
1811: THEN
1812: x_crs_rec.program_application_id := l_crs_rec.program_application_id;
1813: END IF;
1814: IF (x_crs_rec.program_id = OKL_API.G_MISS_NUM)

Line 1814: IF (x_crs_rec.program_id = OKL_API.G_MISS_NUM)

1810: IF (x_crs_rec.program_application_id = OKL_API.G_MISS_NUM)
1811: THEN
1812: x_crs_rec.program_application_id := l_crs_rec.program_application_id;
1813: END IF;
1814: IF (x_crs_rec.program_id = OKL_API.G_MISS_NUM)
1815: THEN
1816: x_crs_rec.program_id := l_crs_rec.program_id;
1817: END IF;
1818: IF (x_crs_rec.program_update_date = OKL_API.G_MISS_DATE)

Line 1818: IF (x_crs_rec.program_update_date = OKL_API.G_MISS_DATE)

1814: IF (x_crs_rec.program_id = OKL_API.G_MISS_NUM)
1815: THEN
1816: x_crs_rec.program_id := l_crs_rec.program_id;
1817: END IF;
1818: IF (x_crs_rec.program_update_date = OKL_API.G_MISS_DATE)
1819: THEN
1820: x_crs_rec.program_update_date := l_crs_rec.program_update_date;
1821: END IF;
1822: IF (x_crs_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 1822: IF (x_crs_rec.attribute_category = OKL_API.G_MISS_CHAR)

1818: IF (x_crs_rec.program_update_date = OKL_API.G_MISS_DATE)
1819: THEN
1820: x_crs_rec.program_update_date := l_crs_rec.program_update_date;
1821: END IF;
1822: IF (x_crs_rec.attribute_category = OKL_API.G_MISS_CHAR)
1823: THEN
1824: x_crs_rec.attribute_category := l_crs_rec.attribute_category;
1825: END IF;
1826: IF (x_crs_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 1826: IF (x_crs_rec.attribute1 = OKL_API.G_MISS_CHAR)

1822: IF (x_crs_rec.attribute_category = OKL_API.G_MISS_CHAR)
1823: THEN
1824: x_crs_rec.attribute_category := l_crs_rec.attribute_category;
1825: END IF;
1826: IF (x_crs_rec.attribute1 = OKL_API.G_MISS_CHAR)
1827: THEN
1828: x_crs_rec.attribute1 := l_crs_rec.attribute1;
1829: END IF;
1830: IF (x_crs_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 1830: IF (x_crs_rec.attribute2 = OKL_API.G_MISS_CHAR)

1826: IF (x_crs_rec.attribute1 = OKL_API.G_MISS_CHAR)
1827: THEN
1828: x_crs_rec.attribute1 := l_crs_rec.attribute1;
1829: END IF;
1830: IF (x_crs_rec.attribute2 = OKL_API.G_MISS_CHAR)
1831: THEN
1832: x_crs_rec.attribute2 := l_crs_rec.attribute2;
1833: END IF;
1834: IF (x_crs_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 1834: IF (x_crs_rec.attribute3 = OKL_API.G_MISS_CHAR)

1830: IF (x_crs_rec.attribute2 = OKL_API.G_MISS_CHAR)
1831: THEN
1832: x_crs_rec.attribute2 := l_crs_rec.attribute2;
1833: END IF;
1834: IF (x_crs_rec.attribute3 = OKL_API.G_MISS_CHAR)
1835: THEN
1836: x_crs_rec.attribute3 := l_crs_rec.attribute3;
1837: END IF;
1838: IF (x_crs_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 1838: IF (x_crs_rec.attribute4 = OKL_API.G_MISS_CHAR)

1834: IF (x_crs_rec.attribute3 = OKL_API.G_MISS_CHAR)
1835: THEN
1836: x_crs_rec.attribute3 := l_crs_rec.attribute3;
1837: END IF;
1838: IF (x_crs_rec.attribute4 = OKL_API.G_MISS_CHAR)
1839: THEN
1840: x_crs_rec.attribute4 := l_crs_rec.attribute4;
1841: END IF;
1842: IF (x_crs_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 1842: IF (x_crs_rec.attribute5 = OKL_API.G_MISS_CHAR)

1838: IF (x_crs_rec.attribute4 = OKL_API.G_MISS_CHAR)
1839: THEN
1840: x_crs_rec.attribute4 := l_crs_rec.attribute4;
1841: END IF;
1842: IF (x_crs_rec.attribute5 = OKL_API.G_MISS_CHAR)
1843: THEN
1844: x_crs_rec.attribute5 := l_crs_rec.attribute5;
1845: END IF;
1846: IF (x_crs_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 1846: IF (x_crs_rec.attribute6 = OKL_API.G_MISS_CHAR)

1842: IF (x_crs_rec.attribute5 = OKL_API.G_MISS_CHAR)
1843: THEN
1844: x_crs_rec.attribute5 := l_crs_rec.attribute5;
1845: END IF;
1846: IF (x_crs_rec.attribute6 = OKL_API.G_MISS_CHAR)
1847: THEN
1848: x_crs_rec.attribute6 := l_crs_rec.attribute6;
1849: END IF;
1850: IF (x_crs_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 1850: IF (x_crs_rec.attribute7 = OKL_API.G_MISS_CHAR)

1846: IF (x_crs_rec.attribute6 = OKL_API.G_MISS_CHAR)
1847: THEN
1848: x_crs_rec.attribute6 := l_crs_rec.attribute6;
1849: END IF;
1850: IF (x_crs_rec.attribute7 = OKL_API.G_MISS_CHAR)
1851: THEN
1852: x_crs_rec.attribute7 := l_crs_rec.attribute7;
1853: END IF;
1854: IF (x_crs_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 1854: IF (x_crs_rec.attribute8 = OKL_API.G_MISS_CHAR)

1850: IF (x_crs_rec.attribute7 = OKL_API.G_MISS_CHAR)
1851: THEN
1852: x_crs_rec.attribute7 := l_crs_rec.attribute7;
1853: END IF;
1854: IF (x_crs_rec.attribute8 = OKL_API.G_MISS_CHAR)
1855: THEN
1856: x_crs_rec.attribute8 := l_crs_rec.attribute8;
1857: END IF;
1858: IF (x_crs_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 1858: IF (x_crs_rec.attribute9 = OKL_API.G_MISS_CHAR)

1854: IF (x_crs_rec.attribute8 = OKL_API.G_MISS_CHAR)
1855: THEN
1856: x_crs_rec.attribute8 := l_crs_rec.attribute8;
1857: END IF;
1858: IF (x_crs_rec.attribute9 = OKL_API.G_MISS_CHAR)
1859: THEN
1860: x_crs_rec.attribute9 := l_crs_rec.attribute9;
1861: END IF;
1862: IF (x_crs_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 1862: IF (x_crs_rec.attribute10 = OKL_API.G_MISS_CHAR)

1858: IF (x_crs_rec.attribute9 = OKL_API.G_MISS_CHAR)
1859: THEN
1860: x_crs_rec.attribute9 := l_crs_rec.attribute9;
1861: END IF;
1862: IF (x_crs_rec.attribute10 = OKL_API.G_MISS_CHAR)
1863: THEN
1864: x_crs_rec.attribute10 := l_crs_rec.attribute10;
1865: END IF;
1866: IF (x_crs_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 1866: IF (x_crs_rec.attribute11 = OKL_API.G_MISS_CHAR)

1862: IF (x_crs_rec.attribute10 = OKL_API.G_MISS_CHAR)
1863: THEN
1864: x_crs_rec.attribute10 := l_crs_rec.attribute10;
1865: END IF;
1866: IF (x_crs_rec.attribute11 = OKL_API.G_MISS_CHAR)
1867: THEN
1868: x_crs_rec.attribute11 := l_crs_rec.attribute11;
1869: END IF;
1870: IF (x_crs_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 1870: IF (x_crs_rec.attribute12 = OKL_API.G_MISS_CHAR)

1866: IF (x_crs_rec.attribute11 = OKL_API.G_MISS_CHAR)
1867: THEN
1868: x_crs_rec.attribute11 := l_crs_rec.attribute11;
1869: END IF;
1870: IF (x_crs_rec.attribute12 = OKL_API.G_MISS_CHAR)
1871: THEN
1872: x_crs_rec.attribute12 := l_crs_rec.attribute12;
1873: END IF;
1874: IF (x_crs_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 1874: IF (x_crs_rec.attribute13 = OKL_API.G_MISS_CHAR)

1870: IF (x_crs_rec.attribute12 = OKL_API.G_MISS_CHAR)
1871: THEN
1872: x_crs_rec.attribute12 := l_crs_rec.attribute12;
1873: END IF;
1874: IF (x_crs_rec.attribute13 = OKL_API.G_MISS_CHAR)
1875: THEN
1876: x_crs_rec.attribute13 := l_crs_rec.attribute13;
1877: END IF;
1878: IF (x_crs_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 1878: IF (x_crs_rec.attribute14 = OKL_API.G_MISS_CHAR)

1874: IF (x_crs_rec.attribute13 = OKL_API.G_MISS_CHAR)
1875: THEN
1876: x_crs_rec.attribute13 := l_crs_rec.attribute13;
1877: END IF;
1878: IF (x_crs_rec.attribute14 = OKL_API.G_MISS_CHAR)
1879: THEN
1880: x_crs_rec.attribute14 := l_crs_rec.attribute14;
1881: END IF;
1882: IF (x_crs_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 1882: IF (x_crs_rec.attribute15 = OKL_API.G_MISS_CHAR)

1878: IF (x_crs_rec.attribute14 = OKL_API.G_MISS_CHAR)
1879: THEN
1880: x_crs_rec.attribute14 := l_crs_rec.attribute14;
1881: END IF;
1882: IF (x_crs_rec.attribute15 = OKL_API.G_MISS_CHAR)
1883: THEN
1884: x_crs_rec.attribute15 := l_crs_rec.attribute15;
1885: END IF;
1886: IF (x_crs_rec.created_by = OKL_API.G_MISS_NUM)

Line 1886: IF (x_crs_rec.created_by = OKL_API.G_MISS_NUM)

1882: IF (x_crs_rec.attribute15 = OKL_API.G_MISS_CHAR)
1883: THEN
1884: x_crs_rec.attribute15 := l_crs_rec.attribute15;
1885: END IF;
1886: IF (x_crs_rec.created_by = OKL_API.G_MISS_NUM)
1887: THEN
1888: x_crs_rec.created_by := l_crs_rec.created_by;
1889: END IF;
1890: IF (x_crs_rec.creation_date = OKL_API.G_MISS_DATE)

Line 1890: IF (x_crs_rec.creation_date = OKL_API.G_MISS_DATE)

1886: IF (x_crs_rec.created_by = OKL_API.G_MISS_NUM)
1887: THEN
1888: x_crs_rec.created_by := l_crs_rec.created_by;
1889: END IF;
1890: IF (x_crs_rec.creation_date = OKL_API.G_MISS_DATE)
1891: THEN
1892: x_crs_rec.creation_date := l_crs_rec.creation_date;
1893: END IF;
1894: IF (x_crs_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 1894: IF (x_crs_rec.last_updated_by = OKL_API.G_MISS_NUM)

1890: IF (x_crs_rec.creation_date = OKL_API.G_MISS_DATE)
1891: THEN
1892: x_crs_rec.creation_date := l_crs_rec.creation_date;
1893: END IF;
1894: IF (x_crs_rec.last_updated_by = OKL_API.G_MISS_NUM)
1895: THEN
1896: x_crs_rec.last_updated_by := l_crs_rec.last_updated_by;
1897: END IF;
1898: IF (x_crs_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 1898: IF (x_crs_rec.last_update_date = OKL_API.G_MISS_DATE)

1894: IF (x_crs_rec.last_updated_by = OKL_API.G_MISS_NUM)
1895: THEN
1896: x_crs_rec.last_updated_by := l_crs_rec.last_updated_by;
1897: END IF;
1898: IF (x_crs_rec.last_update_date = OKL_API.G_MISS_DATE)
1899: THEN
1900: x_crs_rec.last_update_date := l_crs_rec.last_update_date;
1901: END IF;
1902: IF (x_crs_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 1902: IF (x_crs_rec.last_update_login = OKL_API.G_MISS_NUM)

1898: IF (x_crs_rec.last_update_date = OKL_API.G_MISS_DATE)
1899: THEN
1900: x_crs_rec.last_update_date := l_crs_rec.last_update_date;
1901: END IF;
1902: IF (x_crs_rec.last_update_login = OKL_API.G_MISS_NUM)
1903: THEN
1904: x_crs_rec.last_update_login := l_crs_rec.last_update_login;
1905: END IF;
1906: END IF;

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

1912: FUNCTION Set_Attributes (
1913: p_crs_rec IN crs_rec_type,
1914: x_crs_rec OUT NOCOPY crs_rec_type
1915: ) RETURN VARCHAR2 IS
1916: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1917: BEGIN
1918: x_crs_rec := p_crs_rec;
1919: x_crs_rec.OBJECT_VERSION_NUMBER := p_crs_rec.OBJECT_VERSION_NUMBER + 1;
1920: RETURN(l_return_status);

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

1919: x_crs_rec.OBJECT_VERSION_NUMBER := p_crs_rec.OBJECT_VERSION_NUMBER + 1;
1920: RETURN(l_return_status);
1921: END Set_Attributes;
1922: BEGIN
1923: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1924: p_init_msg_list,
1925: '_PVT',
1926: x_return_status);
1927: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1923: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1924: p_init_msg_list,
1925: '_PVT',
1926: x_return_status);
1927: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1929: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1930: RAISE OKL_API.G_EXCEPTION_ERROR;
1931: END IF;

Line 1928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1924: p_init_msg_list,
1925: '_PVT',
1926: x_return_status);
1927: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1929: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1930: RAISE OKL_API.G_EXCEPTION_ERROR;
1931: END IF;
1932: --- Setting item attributes

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

1925: '_PVT',
1926: x_return_status);
1927: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1929: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1930: RAISE OKL_API.G_EXCEPTION_ERROR;
1931: END IF;
1932: --- Setting item attributes
1933: l_return_status := Set_Attributes(

Line 1930: RAISE OKL_API.G_EXCEPTION_ERROR;

1926: x_return_status);
1927: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1929: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1930: RAISE OKL_API.G_EXCEPTION_ERROR;
1931: END IF;
1932: --- Setting item attributes
1933: l_return_status := Set_Attributes(
1934: p_crs_rec, -- IN

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

1933: l_return_status := Set_Attributes(
1934: p_crs_rec, -- IN
1935: l_crs_rec); -- OUT
1936: --- If any errors happen abort API
1937: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1938: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1939: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1940: RAISE OKL_API.G_EXCEPTION_ERROR;
1941: END IF;

Line 1938: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1934: p_crs_rec, -- IN
1935: l_crs_rec); -- OUT
1936: --- If any errors happen abort API
1937: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1938: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1939: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1940: RAISE OKL_API.G_EXCEPTION_ERROR;
1941: END IF;
1942: l_return_status := populate_new_record(l_crs_rec, l_def_crs_rec);

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

1935: l_crs_rec); -- OUT
1936: --- If any errors happen abort API
1937: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1938: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1939: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1940: RAISE OKL_API.G_EXCEPTION_ERROR;
1941: END IF;
1942: l_return_status := populate_new_record(l_crs_rec, l_def_crs_rec);
1943: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1940: RAISE OKL_API.G_EXCEPTION_ERROR;

1936: --- If any errors happen abort API
1937: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1938: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1939: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1940: RAISE OKL_API.G_EXCEPTION_ERROR;
1941: END IF;
1942: l_return_status := populate_new_record(l_crs_rec, l_def_crs_rec);
1943: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1939: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1940: RAISE OKL_API.G_EXCEPTION_ERROR;
1941: END IF;
1942: l_return_status := populate_new_record(l_crs_rec, l_def_crs_rec);
1943: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1945: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1946: RAISE OKL_API.G_EXCEPTION_ERROR;
1947: END IF;

Line 1944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1940: RAISE OKL_API.G_EXCEPTION_ERROR;
1941: END IF;
1942: l_return_status := populate_new_record(l_crs_rec, l_def_crs_rec);
1943: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1945: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1946: RAISE OKL_API.G_EXCEPTION_ERROR;
1947: END IF;
1948: UPDATE OKL_CURE_REFUND_STAGE

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

1941: END IF;
1942: l_return_status := populate_new_record(l_crs_rec, l_def_crs_rec);
1943: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1945: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1946: RAISE OKL_API.G_EXCEPTION_ERROR;
1947: END IF;
1948: UPDATE OKL_CURE_REFUND_STAGE
1949: SET STATUS = l_def_crs_rec.status,

Line 1946: RAISE OKL_API.G_EXCEPTION_ERROR;

1942: l_return_status := populate_new_record(l_crs_rec, l_def_crs_rec);
1943: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1945: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1946: RAISE OKL_API.G_EXCEPTION_ERROR;
1947: END IF;
1948: UPDATE OKL_CURE_REFUND_STAGE
1949: SET STATUS = l_def_crs_rec.status,
1950: NEGOTIATED_AMOUNT = l_def_crs_rec.negotiated_amount,

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

1980: WHERE CURE_REFUND_STAGE_ID = l_def_crs_rec.cure_refund_stage_id;
1981:
1982: x_crs_rec := l_crs_rec;
1983: x_return_status := l_return_status;
1984: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1985: EXCEPTION
1986: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1987: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1988: (

Line 1986: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1982: x_crs_rec := l_crs_rec;
1983: x_return_status := l_return_status;
1984: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1985: EXCEPTION
1986: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1987: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1988: (
1989: l_api_name,
1990: G_PKG_NAME,

Line 1987: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1983: x_return_status := l_return_status;
1984: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1985: EXCEPTION
1986: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1987: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1988: (
1989: l_api_name,
1990: G_PKG_NAME,
1991: 'OKL_API.G_RET_STS_ERROR',

Line 1991: 'OKL_API.G_RET_STS_ERROR',

1987: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1988: (
1989: l_api_name,
1990: G_PKG_NAME,
1991: 'OKL_API.G_RET_STS_ERROR',
1992: x_msg_count,
1993: x_msg_data,
1994: '_PVT'
1995: );

Line 1996: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1992: x_msg_count,
1993: x_msg_data,
1994: '_PVT'
1995: );
1996: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1997: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1998: (
1999: l_api_name,
2000: G_PKG_NAME,

Line 1997: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1993: x_msg_data,
1994: '_PVT'
1995: );
1996: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1997: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1998: (
1999: l_api_name,
2000: G_PKG_NAME,
2001: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2001: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1997: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1998: (
1999: l_api_name,
2000: G_PKG_NAME,
2001: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2002: x_msg_count,
2003: x_msg_data,
2004: '_PVT'
2005: );

Line 2007: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2003: x_msg_data,
2004: '_PVT'
2005: );
2006: WHEN OTHERS THEN
2007: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2008: (
2009: l_api_name,
2010: G_PKG_NAME,
2011: 'OTHERS',

Line 2022: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2018: -- update_row for:OKL_CURE_REFUND_STAGE_V --
2019: --------------------------------------------
2020: PROCEDURE update_row(
2021: p_api_version IN NUMBER,
2022: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2023: x_return_status OUT NOCOPY VARCHAR2,
2024: x_msg_count OUT NOCOPY NUMBER,
2025: x_msg_data OUT NOCOPY VARCHAR2,
2026: p_crsv_rec IN crsv_rec_type,

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

2027: x_crsv_rec OUT NOCOPY crsv_rec_type) IS
2028:
2029: l_api_version CONSTANT NUMBER := 1;
2030: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2031: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2032: l_crsv_rec crsv_rec_type := p_crsv_rec;
2033: l_def_crsv_rec crsv_rec_type;
2034: l_db_crsv_rec crsv_rec_type;
2035: l_crs_rec crs_rec_type;

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

2054: p_crsv_rec IN crsv_rec_type,
2055: x_crsv_rec OUT NOCOPY crsv_rec_type
2056: ) RETURN VARCHAR2 IS
2057: l_row_notfound BOOLEAN := TRUE;
2058: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2059: BEGIN
2060: x_crsv_rec := p_crsv_rec;
2061: -- Get current database values
2062: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it

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

2061: -- Get current database values
2062: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2063: -- so it may be verified through LOCK_ROW.
2064: l_db_crsv_rec := get_rec(p_crsv_rec, l_return_status);
2065: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2066: IF (x_crsv_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM)
2067: THEN
2068: x_crsv_rec.cure_refund_stage_id := l_db_crsv_rec.cure_refund_stage_id;
2069: END IF;

Line 2066: IF (x_crsv_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM)

2062: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2063: -- so it may be verified through LOCK_ROW.
2064: l_db_crsv_rec := get_rec(p_crsv_rec, l_return_status);
2065: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2066: IF (x_crsv_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM)
2067: THEN
2068: x_crsv_rec.cure_refund_stage_id := l_db_crsv_rec.cure_refund_stage_id;
2069: END IF;
2070: IF (x_crsv_rec.status = OKL_API.G_MISS_CHAR)

Line 2070: IF (x_crsv_rec.status = OKL_API.G_MISS_CHAR)

2066: IF (x_crsv_rec.cure_refund_stage_id = OKL_API.G_MISS_NUM)
2067: THEN
2068: x_crsv_rec.cure_refund_stage_id := l_db_crsv_rec.cure_refund_stage_id;
2069: END IF;
2070: IF (x_crsv_rec.status = OKL_API.G_MISS_CHAR)
2071: THEN
2072: x_crsv_rec.status := l_db_crsv_rec.status;
2073: END IF;
2074: IF (x_crsv_rec.negotiated_amount = OKL_API.G_MISS_NUM)

Line 2074: IF (x_crsv_rec.negotiated_amount = OKL_API.G_MISS_NUM)

2070: IF (x_crsv_rec.status = OKL_API.G_MISS_CHAR)
2071: THEN
2072: x_crsv_rec.status := l_db_crsv_rec.status;
2073: END IF;
2074: IF (x_crsv_rec.negotiated_amount = OKL_API.G_MISS_NUM)
2075: THEN
2076: x_crsv_rec.negotiated_amount := l_db_crsv_rec.negotiated_amount;
2077: END IF;
2078: IF (x_crsv_rec.received_amount = OKL_API.G_MISS_NUM)

Line 2078: IF (x_crsv_rec.received_amount = OKL_API.G_MISS_NUM)

2074: IF (x_crsv_rec.negotiated_amount = OKL_API.G_MISS_NUM)
2075: THEN
2076: x_crsv_rec.negotiated_amount := l_db_crsv_rec.negotiated_amount;
2077: END IF;
2078: IF (x_crsv_rec.received_amount = OKL_API.G_MISS_NUM)
2079: THEN
2080: x_crsv_rec.received_amount := l_db_crsv_rec.received_amount;
2081: END IF;
2082: IF (x_crsv_rec.chr_id = OKL_API.G_MISS_NUM)

Line 2082: IF (x_crsv_rec.chr_id = OKL_API.G_MISS_NUM)

2078: IF (x_crsv_rec.received_amount = OKL_API.G_MISS_NUM)
2079: THEN
2080: x_crsv_rec.received_amount := l_db_crsv_rec.received_amount;
2081: END IF;
2082: IF (x_crsv_rec.chr_id = OKL_API.G_MISS_NUM)
2083: THEN
2084: x_crsv_rec.chr_id := l_db_crsv_rec.chr_id;
2085: END IF;
2086: IF (x_crsv_rec.vendor_id = OKL_API.G_MISS_NUM)

Line 2086: IF (x_crsv_rec.vendor_id = OKL_API.G_MISS_NUM)

2082: IF (x_crsv_rec.chr_id = OKL_API.G_MISS_NUM)
2083: THEN
2084: x_crsv_rec.chr_id := l_db_crsv_rec.chr_id;
2085: END IF;
2086: IF (x_crsv_rec.vendor_id = OKL_API.G_MISS_NUM)
2087: THEN
2088: x_crsv_rec.vendor_id := l_db_crsv_rec.vendor_id;
2089: END IF;
2090: IF (x_crsv_rec.request_id = OKL_API.G_MISS_NUM)

Line 2090: IF (x_crsv_rec.request_id = OKL_API.G_MISS_NUM)

2086: IF (x_crsv_rec.vendor_id = OKL_API.G_MISS_NUM)
2087: THEN
2088: x_crsv_rec.vendor_id := l_db_crsv_rec.vendor_id;
2089: END IF;
2090: IF (x_crsv_rec.request_id = OKL_API.G_MISS_NUM)
2091: THEN
2092: x_crsv_rec.request_id := l_db_crsv_rec.request_id;
2093: END IF;
2094: IF (x_crsv_rec.program_application_id = OKL_API.G_MISS_NUM)

Line 2094: IF (x_crsv_rec.program_application_id = OKL_API.G_MISS_NUM)

2090: IF (x_crsv_rec.request_id = OKL_API.G_MISS_NUM)
2091: THEN
2092: x_crsv_rec.request_id := l_db_crsv_rec.request_id;
2093: END IF;
2094: IF (x_crsv_rec.program_application_id = OKL_API.G_MISS_NUM)
2095: THEN
2096: x_crsv_rec.program_application_id := l_db_crsv_rec.program_application_id;
2097: END IF;
2098: IF (x_crsv_rec.program_id = OKL_API.G_MISS_NUM)

Line 2098: IF (x_crsv_rec.program_id = OKL_API.G_MISS_NUM)

2094: IF (x_crsv_rec.program_application_id = OKL_API.G_MISS_NUM)
2095: THEN
2096: x_crsv_rec.program_application_id := l_db_crsv_rec.program_application_id;
2097: END IF;
2098: IF (x_crsv_rec.program_id = OKL_API.G_MISS_NUM)
2099: THEN
2100: x_crsv_rec.program_id := l_db_crsv_rec.program_id;
2101: END IF;
2102: IF (x_crsv_rec.program_update_date = OKL_API.G_MISS_DATE)

Line 2102: IF (x_crsv_rec.program_update_date = OKL_API.G_MISS_DATE)

2098: IF (x_crsv_rec.program_id = OKL_API.G_MISS_NUM)
2099: THEN
2100: x_crsv_rec.program_id := l_db_crsv_rec.program_id;
2101: END IF;
2102: IF (x_crsv_rec.program_update_date = OKL_API.G_MISS_DATE)
2103: THEN
2104: x_crsv_rec.program_update_date := l_db_crsv_rec.program_update_date;
2105: END IF;
2106: IF (x_crsv_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 2106: IF (x_crsv_rec.attribute_category = OKL_API.G_MISS_CHAR)

2102: IF (x_crsv_rec.program_update_date = OKL_API.G_MISS_DATE)
2103: THEN
2104: x_crsv_rec.program_update_date := l_db_crsv_rec.program_update_date;
2105: END IF;
2106: IF (x_crsv_rec.attribute_category = OKL_API.G_MISS_CHAR)
2107: THEN
2108: x_crsv_rec.attribute_category := l_db_crsv_rec.attribute_category;
2109: END IF;
2110: IF (x_crsv_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 2110: IF (x_crsv_rec.attribute1 = OKL_API.G_MISS_CHAR)

2106: IF (x_crsv_rec.attribute_category = OKL_API.G_MISS_CHAR)
2107: THEN
2108: x_crsv_rec.attribute_category := l_db_crsv_rec.attribute_category;
2109: END IF;
2110: IF (x_crsv_rec.attribute1 = OKL_API.G_MISS_CHAR)
2111: THEN
2112: x_crsv_rec.attribute1 := l_db_crsv_rec.attribute1;
2113: END IF;
2114: IF (x_crsv_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 2114: IF (x_crsv_rec.attribute2 = OKL_API.G_MISS_CHAR)

2110: IF (x_crsv_rec.attribute1 = OKL_API.G_MISS_CHAR)
2111: THEN
2112: x_crsv_rec.attribute1 := l_db_crsv_rec.attribute1;
2113: END IF;
2114: IF (x_crsv_rec.attribute2 = OKL_API.G_MISS_CHAR)
2115: THEN
2116: x_crsv_rec.attribute2 := l_db_crsv_rec.attribute2;
2117: END IF;
2118: IF (x_crsv_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 2118: IF (x_crsv_rec.attribute3 = OKL_API.G_MISS_CHAR)

2114: IF (x_crsv_rec.attribute2 = OKL_API.G_MISS_CHAR)
2115: THEN
2116: x_crsv_rec.attribute2 := l_db_crsv_rec.attribute2;
2117: END IF;
2118: IF (x_crsv_rec.attribute3 = OKL_API.G_MISS_CHAR)
2119: THEN
2120: x_crsv_rec.attribute3 := l_db_crsv_rec.attribute3;
2121: END IF;
2122: IF (x_crsv_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 2122: IF (x_crsv_rec.attribute4 = OKL_API.G_MISS_CHAR)

2118: IF (x_crsv_rec.attribute3 = OKL_API.G_MISS_CHAR)
2119: THEN
2120: x_crsv_rec.attribute3 := l_db_crsv_rec.attribute3;
2121: END IF;
2122: IF (x_crsv_rec.attribute4 = OKL_API.G_MISS_CHAR)
2123: THEN
2124: x_crsv_rec.attribute4 := l_db_crsv_rec.attribute4;
2125: END IF;
2126: IF (x_crsv_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 2126: IF (x_crsv_rec.attribute5 = OKL_API.G_MISS_CHAR)

2122: IF (x_crsv_rec.attribute4 = OKL_API.G_MISS_CHAR)
2123: THEN
2124: x_crsv_rec.attribute4 := l_db_crsv_rec.attribute4;
2125: END IF;
2126: IF (x_crsv_rec.attribute5 = OKL_API.G_MISS_CHAR)
2127: THEN
2128: x_crsv_rec.attribute5 := l_db_crsv_rec.attribute5;
2129: END IF;
2130: IF (x_crsv_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 2130: IF (x_crsv_rec.attribute6 = OKL_API.G_MISS_CHAR)

2126: IF (x_crsv_rec.attribute5 = OKL_API.G_MISS_CHAR)
2127: THEN
2128: x_crsv_rec.attribute5 := l_db_crsv_rec.attribute5;
2129: END IF;
2130: IF (x_crsv_rec.attribute6 = OKL_API.G_MISS_CHAR)
2131: THEN
2132: x_crsv_rec.attribute6 := l_db_crsv_rec.attribute6;
2133: END IF;
2134: IF (x_crsv_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 2134: IF (x_crsv_rec.attribute7 = OKL_API.G_MISS_CHAR)

2130: IF (x_crsv_rec.attribute6 = OKL_API.G_MISS_CHAR)
2131: THEN
2132: x_crsv_rec.attribute6 := l_db_crsv_rec.attribute6;
2133: END IF;
2134: IF (x_crsv_rec.attribute7 = OKL_API.G_MISS_CHAR)
2135: THEN
2136: x_crsv_rec.attribute7 := l_db_crsv_rec.attribute7;
2137: END IF;
2138: IF (x_crsv_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 2138: IF (x_crsv_rec.attribute8 = OKL_API.G_MISS_CHAR)

2134: IF (x_crsv_rec.attribute7 = OKL_API.G_MISS_CHAR)
2135: THEN
2136: x_crsv_rec.attribute7 := l_db_crsv_rec.attribute7;
2137: END IF;
2138: IF (x_crsv_rec.attribute8 = OKL_API.G_MISS_CHAR)
2139: THEN
2140: x_crsv_rec.attribute8 := l_db_crsv_rec.attribute8;
2141: END IF;
2142: IF (x_crsv_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 2142: IF (x_crsv_rec.attribute9 = OKL_API.G_MISS_CHAR)

2138: IF (x_crsv_rec.attribute8 = OKL_API.G_MISS_CHAR)
2139: THEN
2140: x_crsv_rec.attribute8 := l_db_crsv_rec.attribute8;
2141: END IF;
2142: IF (x_crsv_rec.attribute9 = OKL_API.G_MISS_CHAR)
2143: THEN
2144: x_crsv_rec.attribute9 := l_db_crsv_rec.attribute9;
2145: END IF;
2146: IF (x_crsv_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 2146: IF (x_crsv_rec.attribute10 = OKL_API.G_MISS_CHAR)

2142: IF (x_crsv_rec.attribute9 = OKL_API.G_MISS_CHAR)
2143: THEN
2144: x_crsv_rec.attribute9 := l_db_crsv_rec.attribute9;
2145: END IF;
2146: IF (x_crsv_rec.attribute10 = OKL_API.G_MISS_CHAR)
2147: THEN
2148: x_crsv_rec.attribute10 := l_db_crsv_rec.attribute10;
2149: END IF;
2150: IF (x_crsv_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 2150: IF (x_crsv_rec.attribute11 = OKL_API.G_MISS_CHAR)

2146: IF (x_crsv_rec.attribute10 = OKL_API.G_MISS_CHAR)
2147: THEN
2148: x_crsv_rec.attribute10 := l_db_crsv_rec.attribute10;
2149: END IF;
2150: IF (x_crsv_rec.attribute11 = OKL_API.G_MISS_CHAR)
2151: THEN
2152: x_crsv_rec.attribute11 := l_db_crsv_rec.attribute11;
2153: END IF;
2154: IF (x_crsv_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 2154: IF (x_crsv_rec.attribute12 = OKL_API.G_MISS_CHAR)

2150: IF (x_crsv_rec.attribute11 = OKL_API.G_MISS_CHAR)
2151: THEN
2152: x_crsv_rec.attribute11 := l_db_crsv_rec.attribute11;
2153: END IF;
2154: IF (x_crsv_rec.attribute12 = OKL_API.G_MISS_CHAR)
2155: THEN
2156: x_crsv_rec.attribute12 := l_db_crsv_rec.attribute12;
2157: END IF;
2158: IF (x_crsv_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 2158: IF (x_crsv_rec.attribute13 = OKL_API.G_MISS_CHAR)

2154: IF (x_crsv_rec.attribute12 = OKL_API.G_MISS_CHAR)
2155: THEN
2156: x_crsv_rec.attribute12 := l_db_crsv_rec.attribute12;
2157: END IF;
2158: IF (x_crsv_rec.attribute13 = OKL_API.G_MISS_CHAR)
2159: THEN
2160: x_crsv_rec.attribute13 := l_db_crsv_rec.attribute13;
2161: END IF;
2162: IF (x_crsv_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 2162: IF (x_crsv_rec.attribute14 = OKL_API.G_MISS_CHAR)

2158: IF (x_crsv_rec.attribute13 = OKL_API.G_MISS_CHAR)
2159: THEN
2160: x_crsv_rec.attribute13 := l_db_crsv_rec.attribute13;
2161: END IF;
2162: IF (x_crsv_rec.attribute14 = OKL_API.G_MISS_CHAR)
2163: THEN
2164: x_crsv_rec.attribute14 := l_db_crsv_rec.attribute14;
2165: END IF;
2166: IF (x_crsv_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 2166: IF (x_crsv_rec.attribute15 = OKL_API.G_MISS_CHAR)

2162: IF (x_crsv_rec.attribute14 = OKL_API.G_MISS_CHAR)
2163: THEN
2164: x_crsv_rec.attribute14 := l_db_crsv_rec.attribute14;
2165: END IF;
2166: IF (x_crsv_rec.attribute15 = OKL_API.G_MISS_CHAR)
2167: THEN
2168: x_crsv_rec.attribute15 := l_db_crsv_rec.attribute15;
2169: END IF;
2170: IF (x_crsv_rec.created_by = OKL_API.G_MISS_NUM)

Line 2170: IF (x_crsv_rec.created_by = OKL_API.G_MISS_NUM)

2166: IF (x_crsv_rec.attribute15 = OKL_API.G_MISS_CHAR)
2167: THEN
2168: x_crsv_rec.attribute15 := l_db_crsv_rec.attribute15;
2169: END IF;
2170: IF (x_crsv_rec.created_by = OKL_API.G_MISS_NUM)
2171: THEN
2172: x_crsv_rec.created_by := l_db_crsv_rec.created_by;
2173: END IF;
2174: IF (x_crsv_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2174: IF (x_crsv_rec.creation_date = OKL_API.G_MISS_DATE)

2170: IF (x_crsv_rec.created_by = OKL_API.G_MISS_NUM)
2171: THEN
2172: x_crsv_rec.created_by := l_db_crsv_rec.created_by;
2173: END IF;
2174: IF (x_crsv_rec.creation_date = OKL_API.G_MISS_DATE)
2175: THEN
2176: x_crsv_rec.creation_date := l_db_crsv_rec.creation_date;
2177: END IF;
2178: IF (x_crsv_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2178: IF (x_crsv_rec.last_updated_by = OKL_API.G_MISS_NUM)

2174: IF (x_crsv_rec.creation_date = OKL_API.G_MISS_DATE)
2175: THEN
2176: x_crsv_rec.creation_date := l_db_crsv_rec.creation_date;
2177: END IF;
2178: IF (x_crsv_rec.last_updated_by = OKL_API.G_MISS_NUM)
2179: THEN
2180: x_crsv_rec.last_updated_by := l_db_crsv_rec.last_updated_by;
2181: END IF;
2182: IF (x_crsv_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2182: IF (x_crsv_rec.last_update_date = OKL_API.G_MISS_DATE)

2178: IF (x_crsv_rec.last_updated_by = OKL_API.G_MISS_NUM)
2179: THEN
2180: x_crsv_rec.last_updated_by := l_db_crsv_rec.last_updated_by;
2181: END IF;
2182: IF (x_crsv_rec.last_update_date = OKL_API.G_MISS_DATE)
2183: THEN
2184: x_crsv_rec.last_update_date := l_db_crsv_rec.last_update_date;
2185: END IF;
2186: IF (x_crsv_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2186: IF (x_crsv_rec.last_update_login = OKL_API.G_MISS_NUM)

2182: IF (x_crsv_rec.last_update_date = OKL_API.G_MISS_DATE)
2183: THEN
2184: x_crsv_rec.last_update_date := l_db_crsv_rec.last_update_date;
2185: END IF;
2186: IF (x_crsv_rec.last_update_login = OKL_API.G_MISS_NUM)
2187: THEN
2188: x_crsv_rec.last_update_login := l_db_crsv_rec.last_update_login;
2189: END IF;
2190: END IF;

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

2196: FUNCTION Set_Attributes (
2197: p_crsv_rec IN crsv_rec_type,
2198: x_crsv_rec OUT NOCOPY crsv_rec_type
2199: ) RETURN VARCHAR2 IS
2200: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2201: BEGIN
2202: x_crsv_rec := p_crsv_rec;
2203: RETURN(l_return_status);
2204: END Set_Attributes;

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

2202: x_crsv_rec := p_crsv_rec;
2203: RETURN(l_return_status);
2204: END Set_Attributes;
2205: BEGIN
2206: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2207: G_PKG_NAME,
2208: p_init_msg_list,
2209: l_api_version,
2210: p_api_version,

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

2209: l_api_version,
2210: p_api_version,
2211: '_PVT',
2212: x_return_status);
2213: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2215: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2216: RAISE OKL_API.G_EXCEPTION_ERROR;
2217: END IF;

Line 2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2210: p_api_version,
2211: '_PVT',
2212: x_return_status);
2213: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2215: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2216: RAISE OKL_API.G_EXCEPTION_ERROR;
2217: END IF;
2218: --- Setting item attributes

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

2211: '_PVT',
2212: x_return_status);
2213: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2215: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2216: RAISE OKL_API.G_EXCEPTION_ERROR;
2217: END IF;
2218: --- Setting item attributes
2219: l_return_status := Set_Attributes(

Line 2216: RAISE OKL_API.G_EXCEPTION_ERROR;

2212: x_return_status);
2213: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2215: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2216: RAISE OKL_API.G_EXCEPTION_ERROR;
2217: END IF;
2218: --- Setting item attributes
2219: l_return_status := Set_Attributes(
2220: p_crsv_rec, -- IN

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

2219: l_return_status := Set_Attributes(
2220: p_crsv_rec, -- IN
2221: x_crsv_rec); -- OUT
2222: --- If any errors happen abort API
2223: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2224: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2225: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2226: RAISE OKL_API.G_EXCEPTION_ERROR;
2227: END IF;

Line 2224: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2220: p_crsv_rec, -- IN
2221: x_crsv_rec); -- OUT
2222: --- If any errors happen abort API
2223: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2224: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2225: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2226: RAISE OKL_API.G_EXCEPTION_ERROR;
2227: END IF;
2228: l_return_status := populate_new_record(l_crsv_rec, l_def_crsv_rec);

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

2221: x_crsv_rec); -- OUT
2222: --- If any errors happen abort API
2223: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2224: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2225: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2226: RAISE OKL_API.G_EXCEPTION_ERROR;
2227: END IF;
2228: l_return_status := populate_new_record(l_crsv_rec, l_def_crsv_rec);
2229: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2226: RAISE OKL_API.G_EXCEPTION_ERROR;

2222: --- If any errors happen abort API
2223: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2224: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2225: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2226: RAISE OKL_API.G_EXCEPTION_ERROR;
2227: END IF;
2228: l_return_status := populate_new_record(l_crsv_rec, l_def_crsv_rec);
2229: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2225: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2226: RAISE OKL_API.G_EXCEPTION_ERROR;
2227: END IF;
2228: l_return_status := populate_new_record(l_crsv_rec, l_def_crsv_rec);
2229: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2231: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2232: RAISE OKL_API.G_EXCEPTION_ERROR;
2233: END IF;

Line 2230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2226: RAISE OKL_API.G_EXCEPTION_ERROR;
2227: END IF;
2228: l_return_status := populate_new_record(l_crsv_rec, l_def_crsv_rec);
2229: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2231: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2232: RAISE OKL_API.G_EXCEPTION_ERROR;
2233: END IF;
2234: l_def_crsv_rec := fill_who_columns(l_def_crsv_rec);

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

2227: END IF;
2228: l_return_status := populate_new_record(l_crsv_rec, l_def_crsv_rec);
2229: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2231: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2232: RAISE OKL_API.G_EXCEPTION_ERROR;
2233: END IF;
2234: l_def_crsv_rec := fill_who_columns(l_def_crsv_rec);
2235: --- Validate all non-missing attributes (Item Level Validation)

Line 2232: RAISE OKL_API.G_EXCEPTION_ERROR;

2228: l_return_status := populate_new_record(l_crsv_rec, l_def_crsv_rec);
2229: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2231: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2232: RAISE OKL_API.G_EXCEPTION_ERROR;
2233: END IF;
2234: l_def_crsv_rec := fill_who_columns(l_def_crsv_rec);
2235: --- Validate all non-missing attributes (Item Level Validation)
2236: l_return_status := Validate_Attributes(l_def_crsv_rec);

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

2234: l_def_crsv_rec := fill_who_columns(l_def_crsv_rec);
2235: --- Validate all non-missing attributes (Item Level Validation)
2236: l_return_status := Validate_Attributes(l_def_crsv_rec);
2237: --- If any errors happen abort API
2238: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2239: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2240: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2241: RAISE OKL_API.G_EXCEPTION_ERROR;
2242: END IF;

Line 2239: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2235: --- Validate all non-missing attributes (Item Level Validation)
2236: l_return_status := Validate_Attributes(l_def_crsv_rec);
2237: --- If any errors happen abort API
2238: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2239: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2240: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2241: RAISE OKL_API.G_EXCEPTION_ERROR;
2242: END IF;
2243: l_return_status := Validate_Record(l_def_crsv_rec, l_db_crsv_rec);

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

2236: l_return_status := Validate_Attributes(l_def_crsv_rec);
2237: --- If any errors happen abort API
2238: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2239: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2240: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2241: RAISE OKL_API.G_EXCEPTION_ERROR;
2242: END IF;
2243: l_return_status := Validate_Record(l_def_crsv_rec, l_db_crsv_rec);
2244: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2241: RAISE OKL_API.G_EXCEPTION_ERROR;

2237: --- If any errors happen abort API
2238: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2239: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2240: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2241: RAISE OKL_API.G_EXCEPTION_ERROR;
2242: END IF;
2243: l_return_status := Validate_Record(l_def_crsv_rec, l_db_crsv_rec);
2244: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2240: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2241: RAISE OKL_API.G_EXCEPTION_ERROR;
2242: END IF;
2243: l_return_status := Validate_Record(l_def_crsv_rec, l_db_crsv_rec);
2244: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2247: RAISE OKL_API.G_EXCEPTION_ERROR;
2248: END IF;

Line 2245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2241: RAISE OKL_API.G_EXCEPTION_ERROR;
2242: END IF;
2243: l_return_status := Validate_Record(l_def_crsv_rec, l_db_crsv_rec);
2244: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2247: RAISE OKL_API.G_EXCEPTION_ERROR;
2248: END IF;
2249:

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

2242: END IF;
2243: l_return_status := Validate_Record(l_def_crsv_rec, l_db_crsv_rec);
2244: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2247: RAISE OKL_API.G_EXCEPTION_ERROR;
2248: END IF;
2249:
2250: -- Lock the Record

Line 2247: RAISE OKL_API.G_EXCEPTION_ERROR;

2243: l_return_status := Validate_Record(l_def_crsv_rec, l_db_crsv_rec);
2244: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2247: RAISE OKL_API.G_EXCEPTION_ERROR;
2248: END IF;
2249:
2250: -- Lock the Record
2251: lock_row(

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

2254: x_return_status => l_return_status,
2255: x_msg_count => x_msg_count,
2256: x_msg_data => x_msg_data,
2257: p_crsv_rec => p_crsv_rec);
2258: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2260: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2261: RAISE OKL_API.G_EXCEPTION_ERROR;
2262: END IF;

Line 2259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2255: x_msg_count => x_msg_count,
2256: x_msg_data => x_msg_data,
2257: p_crsv_rec => p_crsv_rec);
2258: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2260: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2261: RAISE OKL_API.G_EXCEPTION_ERROR;
2262: END IF;
2263:

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

2256: x_msg_data => x_msg_data,
2257: p_crsv_rec => p_crsv_rec);
2258: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2260: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2261: RAISE OKL_API.G_EXCEPTION_ERROR;
2262: END IF;
2263:
2264: -----------------------------------------

Line 2261: RAISE OKL_API.G_EXCEPTION_ERROR;

2257: p_crsv_rec => p_crsv_rec);
2258: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2260: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2261: RAISE OKL_API.G_EXCEPTION_ERROR;
2262: END IF;
2263:
2264: -----------------------------------------
2265: -- Move VIEW record to "Child" records --

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

2275: x_msg_data,
2276: l_crs_rec,
2277: lx_crs_rec
2278: );
2279: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2280: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2281: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2282: RAISE OKL_API.G_EXCEPTION_ERROR;
2283: END IF;

Line 2280: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2276: l_crs_rec,
2277: lx_crs_rec
2278: );
2279: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2280: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2281: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2282: RAISE OKL_API.G_EXCEPTION_ERROR;
2283: END IF;
2284: migrate(lx_crs_rec, l_def_crsv_rec);

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

2277: lx_crs_rec
2278: );
2279: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2280: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2281: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2282: RAISE OKL_API.G_EXCEPTION_ERROR;
2283: END IF;
2284: migrate(lx_crs_rec, l_def_crsv_rec);
2285: x_crsv_rec := l_def_crsv_rec;

Line 2282: RAISE OKL_API.G_EXCEPTION_ERROR;

2278: );
2279: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2280: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2281: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2282: RAISE OKL_API.G_EXCEPTION_ERROR;
2283: END IF;
2284: migrate(lx_crs_rec, l_def_crsv_rec);
2285: x_crsv_rec := l_def_crsv_rec;
2286: x_return_status := l_return_status;

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

2283: END IF;
2284: migrate(lx_crs_rec, l_def_crsv_rec);
2285: x_crsv_rec := l_def_crsv_rec;
2286: x_return_status := l_return_status;
2287: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2288: EXCEPTION
2289: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2290: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2291: (

Line 2289: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2285: x_crsv_rec := l_def_crsv_rec;
2286: x_return_status := l_return_status;
2287: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2288: EXCEPTION
2289: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2290: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2291: (
2292: l_api_name,
2293: G_PKG_NAME,

Line 2290: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2286: x_return_status := l_return_status;
2287: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2288: EXCEPTION
2289: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2290: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2291: (
2292: l_api_name,
2293: G_PKG_NAME,
2294: 'OKL_API.G_RET_STS_ERROR',

Line 2294: 'OKL_API.G_RET_STS_ERROR',

2290: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2291: (
2292: l_api_name,
2293: G_PKG_NAME,
2294: 'OKL_API.G_RET_STS_ERROR',
2295: x_msg_count,
2296: x_msg_data,
2297: '_PVT'
2298: );

Line 2299: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2295: x_msg_count,
2296: x_msg_data,
2297: '_PVT'
2298: );
2299: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2300: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2301: (
2302: l_api_name,
2303: G_PKG_NAME,

Line 2300: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2296: x_msg_data,
2297: '_PVT'
2298: );
2299: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2300: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2301: (
2302: l_api_name,
2303: G_PKG_NAME,
2304: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2304: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2300: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2301: (
2302: l_api_name,
2303: G_PKG_NAME,
2304: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2305: x_msg_count,
2306: x_msg_data,
2307: '_PVT'
2308: );

Line 2310: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2306: x_msg_data,
2307: '_PVT'
2308: );
2309: WHEN OTHERS THEN
2310: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2311: (
2312: l_api_name,
2313: G_PKG_NAME,
2314: 'OTHERS',

Line 2325: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2321: -- PL/SQL TBL update_row for:crsv_tbl --
2322: ----------------------------------------
2323: PROCEDURE update_row(
2324: p_api_version IN NUMBER,
2325: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2326: x_return_status OUT NOCOPY VARCHAR2,
2327: x_msg_count OUT NOCOPY NUMBER,
2328: x_msg_data OUT NOCOPY VARCHAR2,
2329: p_crsv_tbl IN crsv_tbl_type,

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

2327: x_msg_count OUT NOCOPY NUMBER,
2328: x_msg_data OUT NOCOPY VARCHAR2,
2329: p_crsv_tbl IN crsv_tbl_type,
2330: x_crsv_tbl OUT NOCOPY crsv_tbl_type,
2331: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2332:
2333: l_api_version CONSTANT NUMBER := 1;
2334: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2335: i NUMBER := 0;

Line 2337: OKL_API.init_msg_list(p_init_msg_list);

2333: l_api_version CONSTANT NUMBER := 1;
2334: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2335: i NUMBER := 0;
2336: BEGIN
2337: OKL_API.init_msg_list(p_init_msg_list);
2338: -- Make sure PL/SQL table has records in it before passing
2339: IF (p_crsv_tbl.COUNT > 0) THEN
2340: i := p_crsv_tbl.FIRST;
2341: LOOP

Line 2343: l_error_rec OKL_API.ERROR_REC_TYPE;

2339: IF (p_crsv_tbl.COUNT > 0) THEN
2340: i := p_crsv_tbl.FIRST;
2341: LOOP
2342: DECLARE
2343: l_error_rec OKL_API.ERROR_REC_TYPE;
2344: BEGIN
2345: l_error_rec.api_name := l_api_name;
2346: l_error_rec.api_package := G_PKG_NAME;
2347: l_error_rec.idx := i;

Line 2350: p_init_msg_list => OKL_API.G_FALSE,

2346: l_error_rec.api_package := G_PKG_NAME;
2347: l_error_rec.idx := i;
2348: update_row (
2349: p_api_version => p_api_version,
2350: p_init_msg_list => OKL_API.G_FALSE,
2351: x_return_status => l_error_rec.error_type,
2352: x_msg_count => l_error_rec.msg_count,
2353: x_msg_data => l_error_rec.msg_data,
2354: p_crsv_rec => p_crsv_tbl(i),

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

2352: x_msg_count => l_error_rec.msg_count,
2353: x_msg_data => l_error_rec.msg_data,
2354: p_crsv_rec => p_crsv_tbl(i),
2355: x_crsv_rec => x_crsv_tbl(i));
2356: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
2357: l_error_rec.sqlcode := SQLCODE;
2358: load_error_tbl(l_error_rec, px_error_tbl);
2359: ELSE
2360: x_msg_count := l_error_rec.msg_count;

Line 2364: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2360: x_msg_count := l_error_rec.msg_count;
2361: x_msg_data := l_error_rec.msg_data;
2362: END IF;
2363: EXCEPTION
2364: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2365: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2366: l_error_rec.sqlcode := SQLCODE;
2367: load_error_tbl(l_error_rec, px_error_tbl);
2368: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

2361: x_msg_data := l_error_rec.msg_data;
2362: END IF;
2363: EXCEPTION
2364: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2365: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2366: l_error_rec.sqlcode := SQLCODE;
2367: load_error_tbl(l_error_rec, px_error_tbl);
2368: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2369: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2368: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2364: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2365: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2366: l_error_rec.sqlcode := SQLCODE;
2367: load_error_tbl(l_error_rec, px_error_tbl);
2368: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2369: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2370: l_error_rec.sqlcode := SQLCODE;
2371: load_error_tbl(l_error_rec, px_error_tbl);
2372: WHEN OTHERS THEN

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

2365: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2366: l_error_rec.sqlcode := SQLCODE;
2367: load_error_tbl(l_error_rec, px_error_tbl);
2368: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2369: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2370: l_error_rec.sqlcode := SQLCODE;
2371: load_error_tbl(l_error_rec, px_error_tbl);
2372: WHEN OTHERS THEN
2373: l_error_rec.error_type := 'OTHERS';

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

2380: END IF;
2381: -- Loop through the error_tbl to find the error with the highest severity
2382: -- and return it.
2383: x_return_status := find_highest_exception(px_error_tbl);
2384: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2385: EXCEPTION
2386: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2387: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2388: (

Line 2386: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2382: -- and return it.
2383: x_return_status := find_highest_exception(px_error_tbl);
2384: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2385: EXCEPTION
2386: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2387: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2388: (
2389: l_api_name,
2390: G_PKG_NAME,

Line 2387: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2383: x_return_status := find_highest_exception(px_error_tbl);
2384: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2385: EXCEPTION
2386: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2387: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2388: (
2389: l_api_name,
2390: G_PKG_NAME,
2391: 'OKL_API.G_RET_STS_ERROR',

Line 2391: 'OKL_API.G_RET_STS_ERROR',

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

Line 2396: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2392: x_msg_count,
2393: x_msg_data,
2394: '_PVT'
2395: );
2396: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2397: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2398: (
2399: l_api_name,
2400: G_PKG_NAME,

Line 2397: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2401: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2397: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2398: (
2399: l_api_name,
2400: G_PKG_NAME,
2401: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2402: x_msg_count,
2403: x_msg_data,
2404: '_PVT'
2405: );

Line 2407: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2403: x_msg_data,
2404: '_PVT'
2405: );
2406: WHEN OTHERS THEN
2407: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2408: (
2409: l_api_name,
2410: G_PKG_NAME,
2411: 'OTHERS',

Line 2423: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2419: -- PL/SQL TBL update_row for:CRSV_TBL --
2420: ----------------------------------------
2421: PROCEDURE update_row(
2422: p_api_version IN NUMBER,
2423: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2424: x_return_status OUT NOCOPY VARCHAR2,
2425: x_msg_count OUT NOCOPY NUMBER,
2426: x_msg_data OUT NOCOPY VARCHAR2,
2427: p_crsv_tbl IN crsv_tbl_type,

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

2428: x_crsv_tbl OUT NOCOPY crsv_tbl_type) IS
2429:
2430: l_api_version CONSTANT NUMBER := 1;
2431: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2432: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2433: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2434: BEGIN
2435: OKL_API.init_msg_list(p_init_msg_list);
2436: -- Make sure PL/SQL table has records in it before passing

Line 2433: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2429:
2430: l_api_version CONSTANT NUMBER := 1;
2431: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2432: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2433: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2434: BEGIN
2435: OKL_API.init_msg_list(p_init_msg_list);
2436: -- Make sure PL/SQL table has records in it before passing
2437: IF (p_crsv_tbl.COUNT > 0) THEN

Line 2435: OKL_API.init_msg_list(p_init_msg_list);

2431: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2432: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2433: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2434: BEGIN
2435: OKL_API.init_msg_list(p_init_msg_list);
2436: -- Make sure PL/SQL table has records in it before passing
2437: IF (p_crsv_tbl.COUNT > 0) THEN
2438: update_row (
2439: p_api_version => p_api_version,

Line 2440: p_init_msg_list => OKL_API.G_FALSE,

2436: -- Make sure PL/SQL table has records in it before passing
2437: IF (p_crsv_tbl.COUNT > 0) THEN
2438: update_row (
2439: p_api_version => p_api_version,
2440: p_init_msg_list => OKL_API.G_FALSE,
2441: x_return_status => x_return_status,
2442: x_msg_count => x_msg_count,
2443: x_msg_data => x_msg_data,
2444: p_crsv_tbl => p_crsv_tbl,

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

2444: p_crsv_tbl => p_crsv_tbl,
2445: x_crsv_tbl => x_crsv_tbl,
2446: px_error_tbl => l_error_tbl);
2447: END IF;
2448: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2449: EXCEPTION
2450: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2451: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2452: (

Line 2450: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2446: px_error_tbl => l_error_tbl);
2447: END IF;
2448: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2449: EXCEPTION
2450: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2451: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2452: (
2453: l_api_name,
2454: G_PKG_NAME,

Line 2451: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2447: END IF;
2448: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2449: EXCEPTION
2450: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2451: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2452: (
2453: l_api_name,
2454: G_PKG_NAME,
2455: 'OKL_API.G_RET_STS_ERROR',

Line 2455: 'OKL_API.G_RET_STS_ERROR',

2451: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2452: (
2453: l_api_name,
2454: G_PKG_NAME,
2455: 'OKL_API.G_RET_STS_ERROR',
2456: x_msg_count,
2457: x_msg_data,
2458: '_PVT'
2459: );

Line 2460: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2456: x_msg_count,
2457: x_msg_data,
2458: '_PVT'
2459: );
2460: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2461: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2462: (
2463: l_api_name,
2464: G_PKG_NAME,

Line 2461: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2457: x_msg_data,
2458: '_PVT'
2459: );
2460: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2461: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2462: (
2463: l_api_name,
2464: G_PKG_NAME,
2465: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2465: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2461: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2462: (
2463: l_api_name,
2464: G_PKG_NAME,
2465: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2466: x_msg_count,
2467: x_msg_data,
2468: '_PVT'
2469: );

Line 2471: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2467: x_msg_data,
2468: '_PVT'
2469: );
2470: WHEN OTHERS THEN
2471: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2472: (
2473: l_api_name,
2474: G_PKG_NAME,
2475: 'OTHERS',

Line 2489: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2485: ------------------------------------------
2486: -- delete_row for:OKL_CURE_REFUND_STAGE --
2487: ------------------------------------------
2488: PROCEDURE delete_row(
2489: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2490: x_return_status OUT NOCOPY VARCHAR2,
2491: x_msg_count OUT NOCOPY NUMBER,
2492: x_msg_data OUT NOCOPY VARCHAR2,
2493: p_crs_rec IN crs_rec_type) IS

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

2493: p_crs_rec IN crs_rec_type) IS
2494:
2495: l_api_version CONSTANT NUMBER := 1;
2496: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2497: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2498: l_crs_rec crs_rec_type := p_crs_rec;
2499: l_row_notfound BOOLEAN := TRUE;
2500: BEGIN
2501: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

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

2497: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2498: l_crs_rec crs_rec_type := p_crs_rec;
2499: l_row_notfound BOOLEAN := TRUE;
2500: BEGIN
2501: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2502: p_init_msg_list,
2503: '_PVT',
2504: x_return_status);
2505: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

2501: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2502: p_init_msg_list,
2503: '_PVT',
2504: x_return_status);
2505: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2506: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2507: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2508: RAISE OKL_API.G_EXCEPTION_ERROR;
2509: END IF;

Line 2506: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2502: p_init_msg_list,
2503: '_PVT',
2504: x_return_status);
2505: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2506: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2507: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2508: RAISE OKL_API.G_EXCEPTION_ERROR;
2509: END IF;
2510:

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

2503: '_PVT',
2504: x_return_status);
2505: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2506: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2507: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2508: RAISE OKL_API.G_EXCEPTION_ERROR;
2509: END IF;
2510:
2511: DELETE FROM OKL_CURE_REFUND_STAGE

Line 2508: RAISE OKL_API.G_EXCEPTION_ERROR;

2504: x_return_status);
2505: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2506: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2507: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2508: RAISE OKL_API.G_EXCEPTION_ERROR;
2509: END IF;
2510:
2511: DELETE FROM OKL_CURE_REFUND_STAGE
2512: WHERE CURE_REFUND_STAGE_ID = p_crs_rec.cure_refund_stage_id;

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

2511: DELETE FROM OKL_CURE_REFUND_STAGE
2512: WHERE CURE_REFUND_STAGE_ID = p_crs_rec.cure_refund_stage_id;
2513:
2514: x_return_status := l_return_status;
2515: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2516: EXCEPTION
2517: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2518: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2519: (

Line 2517: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2513:
2514: x_return_status := l_return_status;
2515: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2516: EXCEPTION
2517: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2518: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2519: (
2520: l_api_name,
2521: G_PKG_NAME,

Line 2518: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2514: x_return_status := l_return_status;
2515: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2516: EXCEPTION
2517: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2518: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2519: (
2520: l_api_name,
2521: G_PKG_NAME,
2522: 'OKL_API.G_RET_STS_ERROR',

Line 2522: 'OKL_API.G_RET_STS_ERROR',

2518: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2519: (
2520: l_api_name,
2521: G_PKG_NAME,
2522: 'OKL_API.G_RET_STS_ERROR',
2523: x_msg_count,
2524: x_msg_data,
2525: '_PVT'
2526: );

Line 2527: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2523: x_msg_count,
2524: x_msg_data,
2525: '_PVT'
2526: );
2527: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2528: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2529: (
2530: l_api_name,
2531: G_PKG_NAME,

Line 2528: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2524: x_msg_data,
2525: '_PVT'
2526: );
2527: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2528: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2529: (
2530: l_api_name,
2531: G_PKG_NAME,
2532: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2532: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2528: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2529: (
2530: l_api_name,
2531: G_PKG_NAME,
2532: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2533: x_msg_count,
2534: x_msg_data,
2535: '_PVT'
2536: );

Line 2538: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2534: x_msg_data,
2535: '_PVT'
2536: );
2537: WHEN OTHERS THEN
2538: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2539: (
2540: l_api_name,
2541: G_PKG_NAME,
2542: 'OTHERS',

Line 2553: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2549: -- delete_row for:OKL_CURE_REFUND_STAGE_V --
2550: --------------------------------------------
2551: PROCEDURE delete_row(
2552: p_api_version IN NUMBER,
2553: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2554: x_return_status OUT NOCOPY VARCHAR2,
2555: x_msg_count OUT NOCOPY NUMBER,
2556: x_msg_data OUT NOCOPY VARCHAR2,
2557: p_crsv_rec IN crsv_rec_type) IS

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

2557: p_crsv_rec IN crsv_rec_type) IS
2558:
2559: l_api_version CONSTANT NUMBER := 1;
2560: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2561: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2562: l_crsv_rec crsv_rec_type := p_crsv_rec;
2563: l_crs_rec crs_rec_type;
2564: BEGIN
2565: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

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

2561: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2562: l_crsv_rec crsv_rec_type := p_crsv_rec;
2563: l_crs_rec crs_rec_type;
2564: BEGIN
2565: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2566: G_PKG_NAME,
2567: p_init_msg_list,
2568: l_api_version,
2569: p_api_version,

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

2568: l_api_version,
2569: p_api_version,
2570: '_PVT',
2571: x_return_status);
2572: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2573: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2574: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2575: RAISE OKL_API.G_EXCEPTION_ERROR;
2576: END IF;

Line 2573: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2569: p_api_version,
2570: '_PVT',
2571: x_return_status);
2572: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2573: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2574: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2575: RAISE OKL_API.G_EXCEPTION_ERROR;
2576: END IF;
2577: -----------------------------------------

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

2570: '_PVT',
2571: x_return_status);
2572: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2573: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2574: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2575: RAISE OKL_API.G_EXCEPTION_ERROR;
2576: END IF;
2577: -----------------------------------------
2578: -- Move VIEW record to "Child" records --

Line 2575: RAISE OKL_API.G_EXCEPTION_ERROR;

2571: x_return_status);
2572: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2573: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2574: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2575: RAISE OKL_API.G_EXCEPTION_ERROR;
2576: END IF;
2577: -----------------------------------------
2578: -- Move VIEW record to "Child" records --
2579: -----------------------------------------

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

2587: x_msg_count,
2588: x_msg_data,
2589: l_crs_rec
2590: );
2591: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2592: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2593: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2594: RAISE OKL_API.G_EXCEPTION_ERROR;
2595: END IF;

Line 2592: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2588: x_msg_data,
2589: l_crs_rec
2590: );
2591: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2592: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2593: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2594: RAISE OKL_API.G_EXCEPTION_ERROR;
2595: END IF;
2596: x_return_status := l_return_status;

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

2589: l_crs_rec
2590: );
2591: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2592: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2593: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2594: RAISE OKL_API.G_EXCEPTION_ERROR;
2595: END IF;
2596: x_return_status := l_return_status;
2597: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2594: RAISE OKL_API.G_EXCEPTION_ERROR;

2590: );
2591: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2592: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2593: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2594: RAISE OKL_API.G_EXCEPTION_ERROR;
2595: END IF;
2596: x_return_status := l_return_status;
2597: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2598: EXCEPTION

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

2593: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2594: RAISE OKL_API.G_EXCEPTION_ERROR;
2595: END IF;
2596: x_return_status := l_return_status;
2597: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2598: EXCEPTION
2599: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2600: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2601: (

Line 2599: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2595: END IF;
2596: x_return_status := l_return_status;
2597: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2598: EXCEPTION
2599: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2600: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2601: (
2602: l_api_name,
2603: G_PKG_NAME,

Line 2600: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2596: x_return_status := l_return_status;
2597: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2598: EXCEPTION
2599: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2600: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2601: (
2602: l_api_name,
2603: G_PKG_NAME,
2604: 'OKL_API.G_RET_STS_ERROR',

Line 2604: 'OKL_API.G_RET_STS_ERROR',

2600: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2601: (
2602: l_api_name,
2603: G_PKG_NAME,
2604: 'OKL_API.G_RET_STS_ERROR',
2605: x_msg_count,
2606: x_msg_data,
2607: '_PVT'
2608: );

Line 2609: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2605: x_msg_count,
2606: x_msg_data,
2607: '_PVT'
2608: );
2609: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2610: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2611: (
2612: l_api_name,
2613: G_PKG_NAME,

Line 2610: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2606: x_msg_data,
2607: '_PVT'
2608: );
2609: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2610: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2611: (
2612: l_api_name,
2613: G_PKG_NAME,
2614: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2614: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2610: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2611: (
2612: l_api_name,
2613: G_PKG_NAME,
2614: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2615: x_msg_count,
2616: x_msg_data,
2617: '_PVT'
2618: );

Line 2620: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2616: x_msg_data,
2617: '_PVT'
2618: );
2619: WHEN OTHERS THEN
2620: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2621: (
2622: l_api_name,
2623: G_PKG_NAME,
2624: 'OTHERS',

Line 2635: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2631: -- PL/SQL TBL delete_row for:OKL_CURE_REFUND_STAGE_V --
2632: -------------------------------------------------------
2633: PROCEDURE delete_row(
2634: p_api_version IN NUMBER,
2635: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2636: x_return_status OUT NOCOPY VARCHAR2,
2637: x_msg_count OUT NOCOPY NUMBER,
2638: x_msg_data OUT NOCOPY VARCHAR2,
2639: p_crsv_tbl IN crsv_tbl_type,

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

2636: x_return_status OUT NOCOPY VARCHAR2,
2637: x_msg_count OUT NOCOPY NUMBER,
2638: x_msg_data OUT NOCOPY VARCHAR2,
2639: p_crsv_tbl IN crsv_tbl_type,
2640: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2641:
2642: l_api_version CONSTANT NUMBER := 1;
2643: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2644: i NUMBER := 0;

Line 2646: OKL_API.init_msg_list(p_init_msg_list);

2642: l_api_version CONSTANT NUMBER := 1;
2643: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2644: i NUMBER := 0;
2645: BEGIN
2646: OKL_API.init_msg_list(p_init_msg_list);
2647: -- Make sure PL/SQL table has records in it before passing
2648: IF (p_crsv_tbl.COUNT > 0) THEN
2649: i := p_crsv_tbl.FIRST;
2650: LOOP

Line 2652: l_error_rec OKL_API.ERROR_REC_TYPE;

2648: IF (p_crsv_tbl.COUNT > 0) THEN
2649: i := p_crsv_tbl.FIRST;
2650: LOOP
2651: DECLARE
2652: l_error_rec OKL_API.ERROR_REC_TYPE;
2653: BEGIN
2654: l_error_rec.api_name := l_api_name;
2655: l_error_rec.api_package := G_PKG_NAME;
2656: l_error_rec.idx := i;

Line 2659: p_init_msg_list => OKL_API.G_FALSE,

2655: l_error_rec.api_package := G_PKG_NAME;
2656: l_error_rec.idx := i;
2657: delete_row (
2658: p_api_version => p_api_version,
2659: p_init_msg_list => OKL_API.G_FALSE,
2660: x_return_status => l_error_rec.error_type,
2661: x_msg_count => l_error_rec.msg_count,
2662: x_msg_data => l_error_rec.msg_data,
2663: p_crsv_rec => p_crsv_tbl(i));

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

2660: x_return_status => l_error_rec.error_type,
2661: x_msg_count => l_error_rec.msg_count,
2662: x_msg_data => l_error_rec.msg_data,
2663: p_crsv_rec => p_crsv_tbl(i));
2664: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
2665: l_error_rec.sqlcode := SQLCODE;
2666: load_error_tbl(l_error_rec, px_error_tbl);
2667: ELSE
2668: x_msg_count := l_error_rec.msg_count;

Line 2672: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2668: x_msg_count := l_error_rec.msg_count;
2669: x_msg_data := l_error_rec.msg_data;
2670: END IF;
2671: EXCEPTION
2672: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2673: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2674: l_error_rec.sqlcode := SQLCODE;
2675: load_error_tbl(l_error_rec, px_error_tbl);
2676: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

2669: x_msg_data := l_error_rec.msg_data;
2670: END IF;
2671: EXCEPTION
2672: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2673: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2674: l_error_rec.sqlcode := SQLCODE;
2675: load_error_tbl(l_error_rec, px_error_tbl);
2676: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2677: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2676: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2672: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2673: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2674: l_error_rec.sqlcode := SQLCODE;
2675: load_error_tbl(l_error_rec, px_error_tbl);
2676: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2677: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2678: l_error_rec.sqlcode := SQLCODE;
2679: load_error_tbl(l_error_rec, px_error_tbl);
2680: WHEN OTHERS THEN

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

2673: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2674: l_error_rec.sqlcode := SQLCODE;
2675: load_error_tbl(l_error_rec, px_error_tbl);
2676: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2677: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2678: l_error_rec.sqlcode := SQLCODE;
2679: load_error_tbl(l_error_rec, px_error_tbl);
2680: WHEN OTHERS THEN
2681: l_error_rec.error_type := 'OTHERS';

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

2688: END IF;
2689: -- Loop through the error_tbl to find the error with the highest severity
2690: -- and return it.
2691: x_return_status := find_highest_exception(px_error_tbl);
2692: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2693: EXCEPTION
2694: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2695: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2696: (

Line 2694: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2690: -- and return it.
2691: x_return_status := find_highest_exception(px_error_tbl);
2692: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2693: EXCEPTION
2694: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2695: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2696: (
2697: l_api_name,
2698: G_PKG_NAME,

Line 2695: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2691: x_return_status := find_highest_exception(px_error_tbl);
2692: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2693: EXCEPTION
2694: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2695: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2696: (
2697: l_api_name,
2698: G_PKG_NAME,
2699: 'OKL_API.G_RET_STS_ERROR',

Line 2699: 'OKL_API.G_RET_STS_ERROR',

2695: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2696: (
2697: l_api_name,
2698: G_PKG_NAME,
2699: 'OKL_API.G_RET_STS_ERROR',
2700: x_msg_count,
2701: x_msg_data,
2702: '_PVT'
2703: );

Line 2704: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2700: x_msg_count,
2701: x_msg_data,
2702: '_PVT'
2703: );
2704: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2705: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2706: (
2707: l_api_name,
2708: G_PKG_NAME,

Line 2705: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2701: x_msg_data,
2702: '_PVT'
2703: );
2704: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2705: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2706: (
2707: l_api_name,
2708: G_PKG_NAME,
2709: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2709: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2715: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2731: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2727: -- PL/SQL TBL delete_row for:OKL_CURE_REFUND_STAGE_V --
2728: -------------------------------------------------------
2729: PROCEDURE delete_row(
2730: p_api_version IN NUMBER,
2731: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2732: x_return_status OUT NOCOPY VARCHAR2,
2733: x_msg_count OUT NOCOPY NUMBER,
2734: x_msg_data OUT NOCOPY VARCHAR2,
2735: p_crsv_tbl IN crsv_tbl_type) IS

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

2735: p_crsv_tbl IN crsv_tbl_type) IS
2736:
2737: l_api_version CONSTANT NUMBER := 1;
2738: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2739: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2740: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2741: BEGIN
2742: OKL_API.init_msg_list(p_init_msg_list);
2743: -- Make sure PL/SQL table has records in it before passing

Line 2740: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2736:
2737: l_api_version CONSTANT NUMBER := 1;
2738: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2739: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2740: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2741: BEGIN
2742: OKL_API.init_msg_list(p_init_msg_list);
2743: -- Make sure PL/SQL table has records in it before passing
2744: IF (p_crsv_tbl.COUNT > 0) THEN

Line 2742: OKL_API.init_msg_list(p_init_msg_list);

2738: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2739: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2740: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2741: BEGIN
2742: OKL_API.init_msg_list(p_init_msg_list);
2743: -- Make sure PL/SQL table has records in it before passing
2744: IF (p_crsv_tbl.COUNT > 0) THEN
2745: delete_row (
2746: p_api_version => p_api_version,

Line 2747: p_init_msg_list => OKL_API.G_FALSE,

2743: -- Make sure PL/SQL table has records in it before passing
2744: IF (p_crsv_tbl.COUNT > 0) THEN
2745: delete_row (
2746: p_api_version => p_api_version,
2747: p_init_msg_list => OKL_API.G_FALSE,
2748: x_return_status => x_return_status,
2749: x_msg_count => x_msg_count,
2750: x_msg_data => x_msg_data,
2751: p_crsv_tbl => p_crsv_tbl,

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

2750: x_msg_data => x_msg_data,
2751: p_crsv_tbl => p_crsv_tbl,
2752: px_error_tbl => l_error_tbl);
2753: END IF;
2754: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2755: EXCEPTION
2756: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2757: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2758: (

Line 2756: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2752: px_error_tbl => l_error_tbl);
2753: END IF;
2754: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2755: EXCEPTION
2756: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2757: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2758: (
2759: l_api_name,
2760: G_PKG_NAME,

Line 2757: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2753: END IF;
2754: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2755: EXCEPTION
2756: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2757: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2758: (
2759: l_api_name,
2760: G_PKG_NAME,
2761: 'OKL_API.G_RET_STS_ERROR',

Line 2761: 'OKL_API.G_RET_STS_ERROR',

2757: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2758: (
2759: l_api_name,
2760: G_PKG_NAME,
2761: 'OKL_API.G_RET_STS_ERROR',
2762: x_msg_count,
2763: x_msg_data,
2764: '_PVT'
2765: );

Line 2766: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2762: x_msg_count,
2763: x_msg_data,
2764: '_PVT'
2765: );
2766: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2767: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2768: (
2769: l_api_name,
2770: G_PKG_NAME,

Line 2767: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2763: x_msg_data,
2764: '_PVT'
2765: );
2766: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2767: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2768: (
2769: l_api_name,
2770: G_PKG_NAME,
2771: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2771: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2767: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2768: (
2769: l_api_name,
2770: G_PKG_NAME,
2771: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2772: x_msg_count,
2773: x_msg_data,
2774: '_PVT'
2775: );

Line 2777: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2773: x_msg_data,
2774: '_PVT'
2775: );
2776: WHEN OTHERS THEN
2777: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2778: (
2779: l_api_name,
2780: G_PKG_NAME,
2781: 'OTHERS',