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

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

174: ) RETURN qcov_rec_type IS
175: l_qcov_rec qcov_rec_type;
176: l_row_notfound BOOLEAN := TRUE;
177: BEGIN
178: x_return_status := OKL_API.G_RET_STS_SUCCESS;
179: l_qcov_rec := get_rec(p_qcov_rec, l_row_notfound);
180: IF (l_row_notfound) THEN
181: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
182: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 181: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');

177: BEGIN
178: x_return_status := OKL_API.G_RET_STS_SUCCESS;
179: l_qcov_rec := get_rec(p_qcov_rec, l_row_notfound);
180: IF (l_row_notfound) THEN
181: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
182: x_return_status := OKL_API.G_RET_STS_ERROR;
183: END IF;
184: RETURN(l_qcov_rec);
185: END get_rec;

Line 182: x_return_status := OKL_API.G_RET_STS_ERROR;

178: x_return_status := OKL_API.G_RET_STS_SUCCESS;
179: l_qcov_rec := get_rec(p_qcov_rec, l_row_notfound);
180: IF (l_row_notfound) THEN
181: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
182: x_return_status := OKL_API.G_RET_STS_ERROR;
183: END IF;
184: RETURN(l_qcov_rec);
185: END get_rec;
186: -----------------------------------------------------------

Line 281: x_return_status := OKL_API.G_RET_STS_SUCCESS;

277: ) RETURN qco_rec_type IS
278: l_qco_rec qco_rec_type;
279: l_row_notfound BOOLEAN := TRUE;
280: BEGIN
281: x_return_status := OKL_API.G_RET_STS_SUCCESS;
282: l_qco_rec := get_rec(p_qco_rec, l_row_notfound);
283: IF (l_row_notfound) THEN
284: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
285: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 284: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');

280: BEGIN
281: x_return_status := OKL_API.G_RET_STS_SUCCESS;
282: l_qco_rec := get_rec(p_qco_rec, l_row_notfound);
283: IF (l_row_notfound) THEN
284: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
285: x_return_status := OKL_API.G_RET_STS_ERROR;
286: END IF;
287: RETURN(l_qco_rec);
288: END get_rec;

Line 285: x_return_status := OKL_API.G_RET_STS_ERROR;

281: x_return_status := OKL_API.G_RET_STS_SUCCESS;
282: l_qco_rec := get_rec(p_qco_rec, l_row_notfound);
283: IF (l_row_notfound) THEN
284: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
285: x_return_status := OKL_API.G_RET_STS_ERROR;
286: END IF;
287: RETURN(l_qco_rec);
288: END get_rec;
289: -----------------------------------------------------------

Line 307: IF (l_qcov_rec.id = OKL_API.G_MISS_NUM ) THEN

303: p_qcov_rec IN qcov_rec_type
304: ) RETURN qcov_rec_type IS
305: l_qcov_rec qcov_rec_type := p_qcov_rec;
306: BEGIN
307: IF (l_qcov_rec.id = OKL_API.G_MISS_NUM ) THEN
308: l_qcov_rec.id := NULL;
309: END IF;
310: IF (l_qcov_rec.qte_id = OKL_API.G_MISS_NUM ) THEN
311: l_qcov_rec.qte_id := NULL;

Line 310: IF (l_qcov_rec.qte_id = OKL_API.G_MISS_NUM ) THEN

306: BEGIN
307: IF (l_qcov_rec.id = OKL_API.G_MISS_NUM ) THEN
308: l_qcov_rec.id := NULL;
309: END IF;
310: IF (l_qcov_rec.qte_id = OKL_API.G_MISS_NUM ) THEN
311: l_qcov_rec.qte_id := NULL;
312: END IF;
313: IF (l_qcov_rec.cfo_id = OKL_API.G_MISS_NUM ) THEN
314: l_qcov_rec.cfo_id := NULL;

Line 313: IF (l_qcov_rec.cfo_id = OKL_API.G_MISS_NUM ) THEN

309: END IF;
310: IF (l_qcov_rec.qte_id = OKL_API.G_MISS_NUM ) THEN
311: l_qcov_rec.qte_id := NULL;
312: END IF;
313: IF (l_qcov_rec.cfo_id = OKL_API.G_MISS_NUM ) THEN
314: l_qcov_rec.cfo_id := NULL;
315: END IF;
316: IF (l_qcov_rec.base_source_id = OKL_API.G_MISS_NUM ) THEN
317: l_qcov_rec.base_source_id := NULL;

Line 316: IF (l_qcov_rec.base_source_id = OKL_API.G_MISS_NUM ) THEN

312: END IF;
313: IF (l_qcov_rec.cfo_id = OKL_API.G_MISS_NUM ) THEN
314: l_qcov_rec.cfo_id := NULL;
315: END IF;
316: IF (l_qcov_rec.base_source_id = OKL_API.G_MISS_NUM ) THEN
317: l_qcov_rec.base_source_id := NULL;
318: END IF;
319: IF (l_qcov_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
320: l_qcov_rec.object_version_number := NULL;

Line 319: IF (l_qcov_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN

315: END IF;
316: IF (l_qcov_rec.base_source_id = OKL_API.G_MISS_NUM ) THEN
317: l_qcov_rec.base_source_id := NULL;
318: END IF;
319: IF (l_qcov_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
320: l_qcov_rec.object_version_number := NULL;
321: END IF;
322: IF (l_qcov_rec.created_by = OKL_API.G_MISS_NUM ) THEN
323: l_qcov_rec.created_by := NULL;

Line 322: IF (l_qcov_rec.created_by = OKL_API.G_MISS_NUM ) THEN

318: END IF;
319: IF (l_qcov_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
320: l_qcov_rec.object_version_number := NULL;
321: END IF;
322: IF (l_qcov_rec.created_by = OKL_API.G_MISS_NUM ) THEN
323: l_qcov_rec.created_by := NULL;
324: END IF;
325: IF (l_qcov_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
326: l_qcov_rec.creation_date := NULL;

Line 325: IF (l_qcov_rec.creation_date = OKL_API.G_MISS_DATE ) THEN

321: END IF;
322: IF (l_qcov_rec.created_by = OKL_API.G_MISS_NUM ) THEN
323: l_qcov_rec.created_by := NULL;
324: END IF;
325: IF (l_qcov_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
326: l_qcov_rec.creation_date := NULL;
327: END IF;
328: IF (l_qcov_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
329: l_qcov_rec.last_updated_by := NULL;

Line 328: IF (l_qcov_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN

324: END IF;
325: IF (l_qcov_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
326: l_qcov_rec.creation_date := NULL;
327: END IF;
328: IF (l_qcov_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
329: l_qcov_rec.last_updated_by := NULL;
330: END IF;
331: IF (l_qcov_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
332: l_qcov_rec.last_update_date := NULL;

Line 331: IF (l_qcov_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN

327: END IF;
328: IF (l_qcov_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
329: l_qcov_rec.last_updated_by := NULL;
330: END IF;
331: IF (l_qcov_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
332: l_qcov_rec.last_update_date := NULL;
333: END IF;
334: IF (l_qcov_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
335: l_qcov_rec.last_update_login := NULL;

Line 334: IF (l_qcov_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN

330: END IF;
331: IF (l_qcov_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
332: l_qcov_rec.last_update_date := NULL;
333: END IF;
334: IF (l_qcov_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
335: l_qcov_rec.last_update_login := NULL;
336: END IF;
337: IF (l_qcov_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
338: l_qcov_rec.attribute_category := NULL;

Line 337: IF (l_qcov_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN

333: END IF;
334: IF (l_qcov_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
335: l_qcov_rec.last_update_login := NULL;
336: END IF;
337: IF (l_qcov_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
338: l_qcov_rec.attribute_category := NULL;
339: END IF;
340: IF (l_qcov_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
341: l_qcov_rec.attribute1 := NULL;

Line 340: IF (l_qcov_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN

336: END IF;
337: IF (l_qcov_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
338: l_qcov_rec.attribute_category := NULL;
339: END IF;
340: IF (l_qcov_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
341: l_qcov_rec.attribute1 := NULL;
342: END IF;
343: IF (l_qcov_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
344: l_qcov_rec.attribute2 := NULL;

Line 343: IF (l_qcov_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN

339: END IF;
340: IF (l_qcov_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
341: l_qcov_rec.attribute1 := NULL;
342: END IF;
343: IF (l_qcov_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
344: l_qcov_rec.attribute2 := NULL;
345: END IF;
346: IF (l_qcov_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
347: l_qcov_rec.attribute3 := NULL;

Line 346: IF (l_qcov_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN

342: END IF;
343: IF (l_qcov_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
344: l_qcov_rec.attribute2 := NULL;
345: END IF;
346: IF (l_qcov_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
347: l_qcov_rec.attribute3 := NULL;
348: END IF;
349: IF (l_qcov_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
350: l_qcov_rec.attribute4 := NULL;

Line 349: IF (l_qcov_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN

345: END IF;
346: IF (l_qcov_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
347: l_qcov_rec.attribute3 := NULL;
348: END IF;
349: IF (l_qcov_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
350: l_qcov_rec.attribute4 := NULL;
351: END IF;
352: IF (l_qcov_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
353: l_qcov_rec.attribute5 := NULL;

Line 352: IF (l_qcov_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN

348: END IF;
349: IF (l_qcov_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
350: l_qcov_rec.attribute4 := NULL;
351: END IF;
352: IF (l_qcov_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
353: l_qcov_rec.attribute5 := NULL;
354: END IF;
355: IF (l_qcov_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
356: l_qcov_rec.attribute6 := NULL;

Line 355: IF (l_qcov_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN

351: END IF;
352: IF (l_qcov_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
353: l_qcov_rec.attribute5 := NULL;
354: END IF;
355: IF (l_qcov_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
356: l_qcov_rec.attribute6 := NULL;
357: END IF;
358: IF (l_qcov_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
359: l_qcov_rec.attribute7 := NULL;

Line 358: IF (l_qcov_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN

354: END IF;
355: IF (l_qcov_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
356: l_qcov_rec.attribute6 := NULL;
357: END IF;
358: IF (l_qcov_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
359: l_qcov_rec.attribute7 := NULL;
360: END IF;
361: IF (l_qcov_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
362: l_qcov_rec.attribute8 := NULL;

Line 361: IF (l_qcov_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN

357: END IF;
358: IF (l_qcov_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
359: l_qcov_rec.attribute7 := NULL;
360: END IF;
361: IF (l_qcov_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
362: l_qcov_rec.attribute8 := NULL;
363: END IF;
364: IF (l_qcov_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
365: l_qcov_rec.attribute9 := NULL;

Line 364: IF (l_qcov_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN

360: END IF;
361: IF (l_qcov_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
362: l_qcov_rec.attribute8 := NULL;
363: END IF;
364: IF (l_qcov_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
365: l_qcov_rec.attribute9 := NULL;
366: END IF;
367: IF (l_qcov_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
368: l_qcov_rec.attribute10 := NULL;

Line 367: IF (l_qcov_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN

363: END IF;
364: IF (l_qcov_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
365: l_qcov_rec.attribute9 := NULL;
366: END IF;
367: IF (l_qcov_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
368: l_qcov_rec.attribute10 := NULL;
369: END IF;
370: IF (l_qcov_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
371: l_qcov_rec.attribute11 := NULL;

Line 370: IF (l_qcov_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN

366: END IF;
367: IF (l_qcov_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
368: l_qcov_rec.attribute10 := NULL;
369: END IF;
370: IF (l_qcov_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
371: l_qcov_rec.attribute11 := NULL;
372: END IF;
373: IF (l_qcov_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
374: l_qcov_rec.attribute12 := NULL;

Line 373: IF (l_qcov_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN

369: END IF;
370: IF (l_qcov_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
371: l_qcov_rec.attribute11 := NULL;
372: END IF;
373: IF (l_qcov_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
374: l_qcov_rec.attribute12 := NULL;
375: END IF;
376: IF (l_qcov_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
377: l_qcov_rec.attribute13 := NULL;

Line 376: IF (l_qcov_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN

372: END IF;
373: IF (l_qcov_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
374: l_qcov_rec.attribute12 := NULL;
375: END IF;
376: IF (l_qcov_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
377: l_qcov_rec.attribute13 := NULL;
378: END IF;
379: IF (l_qcov_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
380: l_qcov_rec.attribute14 := NULL;

Line 379: IF (l_qcov_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN

375: END IF;
376: IF (l_qcov_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
377: l_qcov_rec.attribute13 := NULL;
378: END IF;
379: IF (l_qcov_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
380: l_qcov_rec.attribute14 := NULL;
381: END IF;
382: IF (l_qcov_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
383: l_qcov_rec.attribute15 := NULL;

Line 382: IF (l_qcov_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN

378: END IF;
379: IF (l_qcov_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
380: l_qcov_rec.attribute14 := NULL;
381: END IF;
382: IF (l_qcov_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
383: l_qcov_rec.attribute15 := NULL;
384: END IF;
385: RETURN(l_qcov_rec);
386: END null_out_defaults;

Line 396: IF (p_qcov_rec.id = OKL_API.G_MISS_NUM OR p_qcov_rec.id IS NULL) THEN

392: x_return_status OUT NOCOPY VARCHAR2) IS
393: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
394: BEGIN
395:
396: IF (p_qcov_rec.id = OKL_API.G_MISS_NUM OR p_qcov_rec.id IS NULL) THEN
397: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
398: l_return_status := OKL_API.G_RET_STS_ERROR;
399: END IF;
400: x_return_status := l_return_status;

Line 397: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');

393: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
394: BEGIN
395:
396: IF (p_qcov_rec.id = OKL_API.G_MISS_NUM OR p_qcov_rec.id IS NULL) THEN
397: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
398: l_return_status := OKL_API.G_RET_STS_ERROR;
399: END IF;
400: x_return_status := l_return_status;
401:

Line 398: l_return_status := OKL_API.G_RET_STS_ERROR;

394: BEGIN
395:
396: IF (p_qcov_rec.id = OKL_API.G_MISS_NUM OR p_qcov_rec.id IS NULL) THEN
397: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
398: l_return_status := OKL_API.G_RET_STS_ERROR;
399: END IF;
400: x_return_status := l_return_status;
401:
402: EXCEPTION

Line 405: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

401:
402: EXCEPTION
403:
404: WHEN OTHERS THEN
405: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
406: ,p_msg_name => G_UNEXPECTED_ERROR
407: ,p_token1 => G_SQLCODE_TOKEN
408: ,p_token1_value => SQLCODE
409: ,p_token2 => G_SQLERRM_TOKEN

Line 411: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

407: ,p_token1 => G_SQLCODE_TOKEN
408: ,p_token1_value => SQLCODE
409: ,p_token2 => G_SQLERRM_TOKEN
410: ,p_token2_value => SQLERRM);
411: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
412: END validate_id;
413: -------------------------------------
414: -- Validate_Attributes for: QTE_ID --
415: -------------------------------------

Line 435: IF (p_qcov_rec.qte_id = OKL_API.G_MISS_NUM OR p_qcov_rec.qte_id IS NULL)

431: WHERE OKL_TRX_REQUESTS.id = p_id;
432:
433:
434: BEGIN
435: IF (p_qcov_rec.qte_id = OKL_API.G_MISS_NUM OR p_qcov_rec.qte_id IS NULL)
436: THEN
437:
438: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'qte_id');
439: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 438: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'qte_id');

434: BEGIN
435: IF (p_qcov_rec.qte_id = OKL_API.G_MISS_NUM OR p_qcov_rec.qte_id IS NULL)
436: THEN
437:
438: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'qte_id');
439: l_return_status := OKL_API.G_RET_STS_ERROR;
440: ELSE
441: -- enforce foreign key
442: OPEN okl_qcov_qtev_fk_csr(p_qcov_rec.qte_id) ;

Line 439: l_return_status := OKL_API.G_RET_STS_ERROR;

435: IF (p_qcov_rec.qte_id = OKL_API.G_MISS_NUM OR p_qcov_rec.qte_id IS NULL)
436: THEN
437:
438: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'qte_id');
439: l_return_status := OKL_API.G_RET_STS_ERROR;
440: ELSE
441: -- enforce foreign key
442: OPEN okl_qcov_qtev_fk_csr(p_qcov_rec.qte_id) ;
443: FETCH okl_qcov_qtev_fk_csr into l_dummy_var ;

Line 474: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

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

Line 480: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

Line 500: IF (p_qcov_rec.cfo_id = OKL_API.G_MISS_NUM OR p_qcov_rec.cfo_id IS NULL)

496: WHERE okl_cash_flow_objects_v.id = p_id;
497:
498: BEGIN
499:
500: IF (p_qcov_rec.cfo_id = OKL_API.G_MISS_NUM OR p_qcov_rec.cfo_id IS NULL)
501: THEN
502: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cfo_id');
503: l_return_status := OKL_API.G_RET_STS_ERROR;
504: ELSE

Line 502: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cfo_id');

498: BEGIN
499:
500: IF (p_qcov_rec.cfo_id = OKL_API.G_MISS_NUM OR p_qcov_rec.cfo_id IS NULL)
501: THEN
502: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cfo_id');
503: l_return_status := OKL_API.G_RET_STS_ERROR;
504: ELSE
505: -- enforce foreign key
506: OPEN okl_qcov_cfov_fk_csr(p_qcov_rec.cfo_id) ;

Line 503: l_return_status := OKL_API.G_RET_STS_ERROR;

499:
500: IF (p_qcov_rec.cfo_id = OKL_API.G_MISS_NUM OR p_qcov_rec.cfo_id IS NULL)
501: THEN
502: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cfo_id');
503: l_return_status := OKL_API.G_RET_STS_ERROR;
504: ELSE
505: -- enforce foreign key
506: OPEN okl_qcov_cfov_fk_csr(p_qcov_rec.cfo_id) ;
507: FETCH okl_qcov_cfov_fk_csr into l_dummy_var ;

Line 528: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

524: x_return_status := l_return_status;
525: EXCEPTION
526:
527: WHEN OTHERS THEN
528: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
529: ,p_msg_name => G_UNEXPECTED_ERROR
530: ,p_token1 => G_SQLCODE_TOKEN
531: ,p_token1_value => SQLCODE
532: ,p_token2 => G_SQLERRM_TOKEN

Line 534: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

530: ,p_token1 => G_SQLCODE_TOKEN
531: ,p_token1_value => SQLCODE
532: ,p_token2 => G_SQLERRM_TOKEN
533: ,p_token2_value => SQLERRM);
534: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
535: END validate_cfo_id;
536: ---------------------------------------------
537: -- Validate_Attributes for: BASE_SOURCE_ID --
538: ---------------------------------------------

Line 545: IF (p_qcov_rec.base_source_id = OKL_API.G_MISS_NUM OR p_qcov_rec.base_source_id IS NULL)

541: x_return_status OUT NOCOPY VARCHAR2) IS
542: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
543: BEGIN
544:
545: IF (p_qcov_rec.base_source_id = OKL_API.G_MISS_NUM OR p_qcov_rec.base_source_id IS NULL)
546: THEN
547: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'base_source_id');
548: l_return_status := OKL_API.G_RET_STS_ERROR;
549: END IF;

Line 547: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'base_source_id');

543: BEGIN
544:
545: IF (p_qcov_rec.base_source_id = OKL_API.G_MISS_NUM OR p_qcov_rec.base_source_id IS NULL)
546: THEN
547: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'base_source_id');
548: l_return_status := OKL_API.G_RET_STS_ERROR;
549: END IF;
550: x_return_status := l_return_status;
551: EXCEPTION

Line 548: l_return_status := OKL_API.G_RET_STS_ERROR;

544:
545: IF (p_qcov_rec.base_source_id = OKL_API.G_MISS_NUM OR p_qcov_rec.base_source_id IS NULL)
546: THEN
547: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'base_source_id');
548: l_return_status := OKL_API.G_RET_STS_ERROR;
549: END IF;
550: x_return_status := l_return_status;
551: EXCEPTION
552:

Line 554: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

550: x_return_status := l_return_status;
551: EXCEPTION
552:
553: WHEN OTHERS THEN
554: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
555: ,p_msg_name => G_UNEXPECTED_ERROR
556: ,p_token1 => G_SQLCODE_TOKEN
557: ,p_token1_value => SQLCODE
558: ,p_token2 => G_SQLERRM_TOKEN

Line 560: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

556: ,p_token1 => G_SQLCODE_TOKEN
557: ,p_token1_value => SQLCODE
558: ,p_token2 => G_SQLERRM_TOKEN
559: ,p_token2_value => SQLERRM);
560: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
561: END validate_base_source_id;
562: ----------------------------------------------------
563: -- Validate_Attributes for: OBJECT_VERSION_NUMBER --
564: ----------------------------------------------------

Line 571: IF (p_qcov_rec.object_version_number = OKL_API.G_MISS_NUM OR p_qcov_rec.object_version_number IS NULL)

567: x_return_status OUT NOCOPY VARCHAR2) IS
568: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
569: BEGIN
570:
571: IF (p_qcov_rec.object_version_number = OKL_API.G_MISS_NUM OR p_qcov_rec.object_version_number IS NULL)
572: THEN
573: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
574: l_return_status := OKL_API.G_RET_STS_ERROR;
575:

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

569: BEGIN
570:
571: IF (p_qcov_rec.object_version_number = OKL_API.G_MISS_NUM OR p_qcov_rec.object_version_number IS NULL)
572: THEN
573: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
574: l_return_status := OKL_API.G_RET_STS_ERROR;
575:
576: END IF;
577: x_return_status := l_return_status;

Line 574: l_return_status := OKL_API.G_RET_STS_ERROR;

570:
571: IF (p_qcov_rec.object_version_number = OKL_API.G_MISS_NUM OR p_qcov_rec.object_version_number IS NULL)
572: THEN
573: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
574: l_return_status := OKL_API.G_RET_STS_ERROR;
575:
576: END IF;
577: x_return_status := l_return_status;
578: EXCEPTION

Line 581: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

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

Line 587: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

583: ,p_token1 => G_SQLCODE_TOKEN
584: ,p_token1_value => SQLCODE
585: ,p_token2 => G_SQLERRM_TOKEN
586: ,p_token2_value => SQLERRM);
587: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
588: END validate_object_version_number;
589: ---------------------------------------------------------------------------
590: -- FUNCTION Validate_Attributes
591: ---------------------------------------------------------------------------

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

594: --------------------------------------------------------
595: FUNCTION Validate_Attributes (
596: p_qcov_rec IN qcov_rec_type
597: ) RETURN VARCHAR2 IS
598: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
599: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
600: BEGIN
601: -----------------------------
602: -- Column Level Validation --

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

595: FUNCTION Validate_Attributes (
596: p_qcov_rec IN qcov_rec_type
597: ) RETURN VARCHAR2 IS
598: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
599: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
600: BEGIN
601: -----------------------------
602: -- Column Level Validation --
603: -----------------------------

Line 674: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

670: EXCEPTION
671: WHEN G_EXCEPTION_HALT_VALIDATION THEN
672: RETURN(x_return_status);
673: WHEN OTHERS THEN
674: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
675: ,p_msg_name => G_UNEXPECTED_ERROR
676: ,p_token1 => G_SQLCODE_TOKEN
677: ,p_token1_value => SQLCODE
678: ,p_token2 => G_SQLERRM_TOKEN

Line 680: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

676: ,p_token1 => G_SQLCODE_TOKEN
677: ,p_token1_value => SQLCODE
678: ,p_token2 => G_SQLERRM_TOKEN
679: ,p_token2_value => SQLERRM);
680: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
681: RETURN(x_return_status);
682: END Validate_Attributes;
683: ---------------------------------------------------------------------------
684: -- PROCEDURE Validate_Record

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

691: FUNCTION Validate_Record (
692: p_qcov_rec IN qcov_rec_type,
693: p_db_qcov_rec IN qcov_rec_type
694: ) RETURN VARCHAR2 IS
695: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
696: ------------------------------------
697: -- FUNCTION validate_foreign_keys --
698: ------------------------------------
699: FUNCTION validate_foreign_keys (

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

712: FROM Okl_Trx_Quotes_V
713: WHERE okl_trx_quotes_v.id = p_id;
714: l_okl_qcov_qtev_fk okl_qcov_qtev_fk_csr%ROWTYPE;
715:
716: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
717: l_row_notfound BOOLEAN := TRUE;
718: BEGIN
719: IF ((p_qcov_rec.CFO_ID IS NOT NULL)
720: AND

Line 728: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CFO_ID');

724: FETCH okl_qcov_cfov_fk_csr INTO l_okl_qcov_cfov_fk;
725: l_row_notfound := okl_qcov_cfov_fk_csr%NOTFOUND;
726: CLOSE okl_qcov_cfov_fk_csr;
727: IF (l_row_notfound) THEN
728: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CFO_ID');
729: RAISE item_not_found_error;
730: END IF;
731: END IF;
732: IF ((p_qcov_rec.QTE_ID IS NOT NULL)

Line 741: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'QTE_ID');

737: FETCH okl_qcov_qtev_fk_csr INTO l_okl_qcov_qtev_fk;
738: l_row_notfound := okl_qcov_qtev_fk_csr%NOTFOUND;
739: CLOSE okl_qcov_qtev_fk_csr;
740: IF (l_row_notfound) THEN
741: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'QTE_ID');
742: RAISE item_not_found_error;
743: END IF;
744: END IF;
745: RETURN (l_return_status);

Line 748: l_return_status := OKL_API.G_RET_STS_ERROR;

744: END IF;
745: RETURN (l_return_status);
746: EXCEPTION
747: WHEN item_not_found_error THEN
748: l_return_status := OKL_API.G_RET_STS_ERROR;
749: RETURN (l_return_status);
750: END validate_foreign_keys;
751: BEGIN
752: l_return_status := validate_foreign_keys(p_qcov_rec, p_db_qcov_rec);

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

754: END Validate_Record;
755: FUNCTION Validate_Record (
756: p_qcov_rec IN qcov_rec_type
757: ) RETURN VARCHAR2 IS
758: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
759: l_db_qcov_rec qcov_rec_type := get_rec(p_qcov_rec);
760: BEGIN
761: l_return_status := Validate_Record(p_qcov_rec => p_qcov_rec,
762: p_db_qcov_rec => l_db_qcov_rec);

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

847: p_qcov_rec IN qcov_rec_type) IS
848:
849: l_api_version CONSTANT NUMBER := 1;
850: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
851: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
852: l_qcov_rec qcov_rec_type := p_qcov_rec;
853: l_qco_rec qco_rec_type;
854: l_qco_rec qco_rec_type;
855: BEGIN

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

852: l_qcov_rec qcov_rec_type := p_qcov_rec;
853: l_qco_rec qco_rec_type;
854: l_qco_rec qco_rec_type;
855: BEGIN
856: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
857: G_PKG_NAME,
858: p_init_msg_list,
859: l_api_version,
860: p_api_version,

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

859: l_api_version,
860: p_api_version,
861: 'PVT',
862: x_return_status);
863: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
864: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
865: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
866: RAISE OKL_API.G_EXCEPTION_ERROR;
867: END IF;

Line 864: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

860: p_api_version,
861: 'PVT',
862: x_return_status);
863: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
864: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
865: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
866: RAISE OKL_API.G_EXCEPTION_ERROR;
867: END IF;
868: --- Validate all non-missing attributes (Item Level Validation)

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

861: 'PVT',
862: x_return_status);
863: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
864: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
865: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
866: RAISE OKL_API.G_EXCEPTION_ERROR;
867: END IF;
868: --- Validate all non-missing attributes (Item Level Validation)
869: l_return_status := Validate_Attributes(l_qcov_rec);

Line 866: RAISE OKL_API.G_EXCEPTION_ERROR;

862: x_return_status);
863: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
864: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
865: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
866: RAISE OKL_API.G_EXCEPTION_ERROR;
867: END IF;
868: --- Validate all non-missing attributes (Item Level Validation)
869: l_return_status := Validate_Attributes(l_qcov_rec);
870: --- If any errors happen abort API

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

867: END IF;
868: --- Validate all non-missing attributes (Item Level Validation)
869: l_return_status := Validate_Attributes(l_qcov_rec);
870: --- If any errors happen abort API
871: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
872: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
873: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
874: RAISE OKL_API.G_EXCEPTION_ERROR;
875: END IF;

Line 872: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

868: --- Validate all non-missing attributes (Item Level Validation)
869: l_return_status := Validate_Attributes(l_qcov_rec);
870: --- If any errors happen abort API
871: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
872: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
873: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
874: RAISE OKL_API.G_EXCEPTION_ERROR;
875: END IF;
876:

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

869: l_return_status := Validate_Attributes(l_qcov_rec);
870: --- If any errors happen abort API
871: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
872: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
873: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
874: RAISE OKL_API.G_EXCEPTION_ERROR;
875: END IF;
876:
877: /*

Line 874: RAISE OKL_API.G_EXCEPTION_ERROR;

870: --- If any errors happen abort API
871: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
872: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
873: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
874: RAISE OKL_API.G_EXCEPTION_ERROR;
875: END IF;
876:
877: /*
878: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,

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

877: /*
878: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
879: -- which has been moved to individaul valiadte attribute procedures
880: l_return_status := Validate_Record(l_qcov_rec);
881: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
883: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
884: RAISE OKL_API.G_EXCEPTION_ERROR;
885: END IF;

Line 882: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

878: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
879: -- which has been moved to individaul valiadte attribute procedures
880: l_return_status := Validate_Record(l_qcov_rec);
881: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
883: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
884: RAISE OKL_API.G_EXCEPTION_ERROR;
885: END IF;
886: */

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

879: -- which has been moved to individaul valiadte attribute procedures
880: l_return_status := Validate_Record(l_qcov_rec);
881: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
883: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
884: RAISE OKL_API.G_EXCEPTION_ERROR;
885: END IF;
886: */
887:

Line 884: RAISE OKL_API.G_EXCEPTION_ERROR;

880: l_return_status := Validate_Record(l_qcov_rec);
881: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
883: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
884: RAISE OKL_API.G_EXCEPTION_ERROR;
885: END IF;
886: */
887:
888: x_return_status := l_return_status;

Line 890: WHEN OKL_API.G_EXCEPTION_ERROR THEN

886: */
887:
888: x_return_status := l_return_status;
889: EXCEPTION
890: WHEN OKL_API.G_EXCEPTION_ERROR THEN
891: x_return_status := OKL_API.HANDLE_EXCEPTIONS
892: (
893: l_api_name,
894: G_PKG_NAME,

Line 891: x_return_status := OKL_API.HANDLE_EXCEPTIONS

887:
888: x_return_status := l_return_status;
889: EXCEPTION
890: WHEN OKL_API.G_EXCEPTION_ERROR THEN
891: x_return_status := OKL_API.HANDLE_EXCEPTIONS
892: (
893: l_api_name,
894: G_PKG_NAME,
895: 'OKL_API.G_RET_STS_ERROR',

Line 895: 'OKL_API.G_RET_STS_ERROR',

891: x_return_status := OKL_API.HANDLE_EXCEPTIONS
892: (
893: l_api_name,
894: G_PKG_NAME,
895: 'OKL_API.G_RET_STS_ERROR',
896: x_msg_count,
897: x_msg_data,
898: '_PVT'
899: );

Line 900: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

896: x_msg_count,
897: x_msg_data,
898: '_PVT'
899: );
900: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
901: x_return_status := OKL_API.HANDLE_EXCEPTIONS
902: (
903: l_api_name,
904: G_PKG_NAME,

Line 901: x_return_status := OKL_API.HANDLE_EXCEPTIONS

897: x_msg_data,
898: '_PVT'
899: );
900: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
901: x_return_status := OKL_API.HANDLE_EXCEPTIONS
902: (
903: l_api_name,
904: G_PKG_NAME,
905: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 905: 'OKL_API.G_RET_STS_UNEXP_ERROR',

901: x_return_status := OKL_API.HANDLE_EXCEPTIONS
902: (
903: l_api_name,
904: G_PKG_NAME,
905: 'OKL_API.G_RET_STS_UNEXP_ERROR',
906: x_msg_count,
907: x_msg_data,
908: '_PVT'
909: );

Line 911: x_return_status := OKL_API.HANDLE_EXCEPTIONS

907: x_msg_data,
908: '_PVT'
909: );
910: WHEN OTHERS THEN
911: x_return_status := OKL_API.HANDLE_EXCEPTIONS
912: (
913: l_api_name,
914: G_PKG_NAME,
915: 'OTHERS',

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

927: x_return_status OUT NOCOPY VARCHAR2,
928: x_msg_count OUT NOCOPY NUMBER,
929: x_msg_data OUT NOCOPY VARCHAR2,
930: p_qcov_tbl IN qcov_tbl_type,
931: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
932:
933: l_api_version CONSTANT NUMBER := 1;
934: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
935: i NUMBER := 0;

Line 937: OKL_API.init_msg_list(p_init_msg_list);

933: l_api_version CONSTANT NUMBER := 1;
934: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
935: i NUMBER := 0;
936: BEGIN
937: OKL_API.init_msg_list(p_init_msg_list);
938: -- Make sure PL/SQL table has records in it before passing
939: IF (p_qcov_tbl.COUNT > 0) THEN
940: i := p_qcov_tbl.FIRST;
941: LOOP

Line 943: l_error_rec OKL_API.ERROR_REC_TYPE;

939: IF (p_qcov_tbl.COUNT > 0) THEN
940: i := p_qcov_tbl.FIRST;
941: LOOP
942: DECLARE
943: l_error_rec OKL_API.ERROR_REC_TYPE;
944: BEGIN
945: l_error_rec.api_name := l_api_name;
946: l_error_rec.api_package := G_PKG_NAME;
947: l_error_rec.idx := i;

Line 950: p_init_msg_list => OKL_API.G_FALSE,

946: l_error_rec.api_package := G_PKG_NAME;
947: l_error_rec.idx := i;
948: validate_row (
949: p_api_version => p_api_version,
950: p_init_msg_list => OKL_API.G_FALSE,
951: x_return_status => l_error_rec.error_type,
952: x_msg_count => l_error_rec.msg_count,
953: x_msg_data => l_error_rec.msg_data,
954: p_qcov_rec => p_qcov_tbl(i));

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

951: x_return_status => l_error_rec.error_type,
952: x_msg_count => l_error_rec.msg_count,
953: x_msg_data => l_error_rec.msg_data,
954: p_qcov_rec => p_qcov_tbl(i));
955: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
956: l_error_rec.sqlcode := SQLCODE;
957: load_error_tbl(l_error_rec, px_error_tbl);
958: ELSE
959: x_msg_count := l_error_rec.msg_count;

Line 963: WHEN OKL_API.G_EXCEPTION_ERROR THEN

959: x_msg_count := l_error_rec.msg_count;
960: x_msg_data := l_error_rec.msg_data;
961: END IF;
962: EXCEPTION
963: WHEN OKL_API.G_EXCEPTION_ERROR THEN
964: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
965: l_error_rec.sqlcode := SQLCODE;
966: load_error_tbl(l_error_rec, px_error_tbl);
967: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

960: x_msg_data := l_error_rec.msg_data;
961: END IF;
962: EXCEPTION
963: WHEN OKL_API.G_EXCEPTION_ERROR THEN
964: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
965: l_error_rec.sqlcode := SQLCODE;
966: load_error_tbl(l_error_rec, px_error_tbl);
967: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
968: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 967: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

963: WHEN OKL_API.G_EXCEPTION_ERROR THEN
964: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
965: l_error_rec.sqlcode := SQLCODE;
966: load_error_tbl(l_error_rec, px_error_tbl);
967: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
968: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
969: l_error_rec.sqlcode := SQLCODE;
970: load_error_tbl(l_error_rec, px_error_tbl);
971: WHEN OTHERS THEN

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

964: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
965: l_error_rec.sqlcode := SQLCODE;
966: load_error_tbl(l_error_rec, px_error_tbl);
967: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
968: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
969: l_error_rec.sqlcode := SQLCODE;
970: load_error_tbl(l_error_rec, px_error_tbl);
971: WHEN OTHERS THEN
972: l_error_rec.error_type := 'OTHERS';

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

979: END IF;
980: -- Loop through the error_tbl to find the error with the highest severity
981: -- and return it.
982: x_return_status := find_highest_exception(px_error_tbl);
983: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
984: EXCEPTION
985: WHEN OKL_API.G_EXCEPTION_ERROR THEN
986: x_return_status := OKL_API.HANDLE_EXCEPTIONS
987: (

Line 985: WHEN OKL_API.G_EXCEPTION_ERROR THEN

981: -- and return it.
982: x_return_status := find_highest_exception(px_error_tbl);
983: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
984: EXCEPTION
985: WHEN OKL_API.G_EXCEPTION_ERROR THEN
986: x_return_status := OKL_API.HANDLE_EXCEPTIONS
987: (
988: l_api_name,
989: G_PKG_NAME,

Line 986: x_return_status := OKL_API.HANDLE_EXCEPTIONS

982: x_return_status := find_highest_exception(px_error_tbl);
983: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
984: EXCEPTION
985: WHEN OKL_API.G_EXCEPTION_ERROR THEN
986: x_return_status := OKL_API.HANDLE_EXCEPTIONS
987: (
988: l_api_name,
989: G_PKG_NAME,
990: 'OKL_API.G_RET_STS_ERROR',

Line 990: 'OKL_API.G_RET_STS_ERROR',

986: x_return_status := OKL_API.HANDLE_EXCEPTIONS
987: (
988: l_api_name,
989: G_PKG_NAME,
990: 'OKL_API.G_RET_STS_ERROR',
991: x_msg_count,
992: x_msg_data,
993: '_PVT'
994: );

Line 995: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

991: x_msg_count,
992: x_msg_data,
993: '_PVT'
994: );
995: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
996: x_return_status := OKL_API.HANDLE_EXCEPTIONS
997: (
998: l_api_name,
999: G_PKG_NAME,

Line 996: x_return_status := OKL_API.HANDLE_EXCEPTIONS

992: x_msg_data,
993: '_PVT'
994: );
995: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
996: x_return_status := OKL_API.HANDLE_EXCEPTIONS
997: (
998: l_api_name,
999: G_PKG_NAME,
1000: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1000: 'OKL_API.G_RET_STS_UNEXP_ERROR',

996: x_return_status := OKL_API.HANDLE_EXCEPTIONS
997: (
998: l_api_name,
999: G_PKG_NAME,
1000: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1001: x_msg_count,
1002: x_msg_data,
1003: '_PVT'
1004: );

Line 1006: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1002: x_msg_data,
1003: '_PVT'
1004: );
1005: WHEN OTHERS THEN
1006: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1007: (
1008: l_api_name,
1009: G_PKG_NAME,
1010: 'OTHERS',

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

1026: p_qcov_tbl IN qcov_tbl_type) IS
1027:
1028: l_api_version CONSTANT NUMBER := 1;
1029: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1030: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1031: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1032: BEGIN
1033: OKL_API.init_msg_list(p_init_msg_list);
1034: -- Make sure PL/SQL table has records in it before passing

Line 1031: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1027:
1028: l_api_version CONSTANT NUMBER := 1;
1029: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1030: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1031: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1032: BEGIN
1033: OKL_API.init_msg_list(p_init_msg_list);
1034: -- Make sure PL/SQL table has records in it before passing
1035: IF (p_qcov_tbl.COUNT > 0) THEN

Line 1033: OKL_API.init_msg_list(p_init_msg_list);

1029: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1030: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1031: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1032: BEGIN
1033: OKL_API.init_msg_list(p_init_msg_list);
1034: -- Make sure PL/SQL table has records in it before passing
1035: IF (p_qcov_tbl.COUNT > 0) THEN
1036: validate_row (
1037: p_api_version => p_api_version,

Line 1038: p_init_msg_list => OKL_API.G_FALSE,

1034: -- Make sure PL/SQL table has records in it before passing
1035: IF (p_qcov_tbl.COUNT > 0) THEN
1036: validate_row (
1037: p_api_version => p_api_version,
1038: p_init_msg_list => OKL_API.G_FALSE,
1039: x_return_status => x_return_status,
1040: x_msg_count => x_msg_count,
1041: x_msg_data => x_msg_data,
1042: p_qcov_tbl => p_qcov_tbl,

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

1041: x_msg_data => x_msg_data,
1042: p_qcov_tbl => p_qcov_tbl,
1043: px_error_tbl => l_error_tbl);
1044: END IF;
1045: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1046: EXCEPTION
1047: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1048: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1049: (

Line 1047: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1043: px_error_tbl => l_error_tbl);
1044: END IF;
1045: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1046: EXCEPTION
1047: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1048: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1049: (
1050: l_api_name,
1051: G_PKG_NAME,

Line 1048: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1044: END IF;
1045: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1046: EXCEPTION
1047: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1048: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1049: (
1050: l_api_name,
1051: G_PKG_NAME,
1052: 'OKL_API.G_RET_STS_ERROR',

Line 1052: 'OKL_API.G_RET_STS_ERROR',

1048: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1049: (
1050: l_api_name,
1051: G_PKG_NAME,
1052: 'OKL_API.G_RET_STS_ERROR',
1053: x_msg_count,
1054: x_msg_data,
1055: '_PVT'
1056: );

Line 1057: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1058: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1054: x_msg_data,
1055: '_PVT'
1056: );
1057: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1058: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1059: (
1060: l_api_name,
1061: G_PKG_NAME,
1062: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1062: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1068: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1091: x_qco_rec OUT NOCOPY qco_rec_type) IS
1092:
1093: l_api_version CONSTANT NUMBER := 1;
1094: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1095: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1096: l_qco_rec qco_rec_type := p_qco_rec;
1097: l_def_qco_rec qco_rec_type;
1098: -------------------------------------------------
1099: -- Set_Attributes for:OKL_TRX_QTE_CF_OBJECTS --

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

1101: FUNCTION Set_Attributes (
1102: p_qco_rec IN qco_rec_type,
1103: x_qco_rec OUT NOCOPY qco_rec_type
1104: ) RETURN VARCHAR2 IS
1105: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1106: BEGIN
1107: x_qco_rec := p_qco_rec;
1108: RETURN(l_return_status);
1109: END Set_Attributes;

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

1107: x_qco_rec := p_qco_rec;
1108: RETURN(l_return_status);
1109: END Set_Attributes;
1110: BEGIN
1111: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1112: p_init_msg_list,
1113: 'PVT',
1114: x_return_status);
1115: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1111: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1112: p_init_msg_list,
1113: 'PVT',
1114: x_return_status);
1115: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1117: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1118: RAISE OKL_API.G_EXCEPTION_ERROR;
1119: END IF;

Line 1116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1112: p_init_msg_list,
1113: 'PVT',
1114: x_return_status);
1115: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1117: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1118: RAISE OKL_API.G_EXCEPTION_ERROR;
1119: END IF;
1120: --- Setting item atributes

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

1113: 'PVT',
1114: x_return_status);
1115: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1117: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1118: RAISE OKL_API.G_EXCEPTION_ERROR;
1119: END IF;
1120: --- Setting item atributes
1121: l_return_status := Set_Attributes(

Line 1118: RAISE OKL_API.G_EXCEPTION_ERROR;

1114: x_return_status);
1115: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1116: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1117: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1118: RAISE OKL_API.G_EXCEPTION_ERROR;
1119: END IF;
1120: --- Setting item atributes
1121: l_return_status := Set_Attributes(
1122: p_qco_rec, -- IN

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

1121: l_return_status := Set_Attributes(
1122: p_qco_rec, -- IN
1123: l_qco_rec); -- OUT
1124: --- If any errors happen abort API
1125: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1127: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1128: RAISE OKL_API.G_EXCEPTION_ERROR;
1129: END IF;

Line 1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1122: p_qco_rec, -- IN
1123: l_qco_rec); -- OUT
1124: --- If any errors happen abort API
1125: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1127: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1128: RAISE OKL_API.G_EXCEPTION_ERROR;
1129: END IF;
1130: INSERT INTO OKL_TRX_QTE_CF_OBJECTS(

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

1123: l_qco_rec); -- OUT
1124: --- If any errors happen abort API
1125: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1127: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1128: RAISE OKL_API.G_EXCEPTION_ERROR;
1129: END IF;
1130: INSERT INTO OKL_TRX_QTE_CF_OBJECTS(
1131: id,

Line 1128: RAISE OKL_API.G_EXCEPTION_ERROR;

1124: --- If any errors happen abort API
1125: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1127: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1128: RAISE OKL_API.G_EXCEPTION_ERROR;
1129: END IF;
1130: INSERT INTO OKL_TRX_QTE_CF_OBJECTS(
1131: id,
1132: qte_id,

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

1183: l_qco_rec.attribute15);
1184: -- Set OUT values
1185: x_qco_rec := l_qco_rec;
1186: x_return_status := l_return_status;
1187: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1188: EXCEPTION
1189: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1190: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1191: (

Line 1189: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1185: x_qco_rec := l_qco_rec;
1186: x_return_status := l_return_status;
1187: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1188: EXCEPTION
1189: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1190: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1191: (
1192: l_api_name,
1193: G_PKG_NAME,

Line 1190: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1186: x_return_status := l_return_status;
1187: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1188: EXCEPTION
1189: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1190: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1191: (
1192: l_api_name,
1193: G_PKG_NAME,
1194: 'OKL_API.G_RET_STS_ERROR',

Line 1194: 'OKL_API.G_RET_STS_ERROR',

1190: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1191: (
1192: l_api_name,
1193: G_PKG_NAME,
1194: 'OKL_API.G_RET_STS_ERROR',
1195: x_msg_count,
1196: x_msg_data,
1197: '_PVT'
1198: );

Line 1199: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1195: x_msg_count,
1196: x_msg_data,
1197: '_PVT'
1198: );
1199: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1200: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1201: (
1202: l_api_name,
1203: G_PKG_NAME,

Line 1200: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1196: x_msg_data,
1197: '_PVT'
1198: );
1199: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1200: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1201: (
1202: l_api_name,
1203: G_PKG_NAME,
1204: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1204: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1200: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1201: (
1202: l_api_name,
1203: G_PKG_NAME,
1204: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1205: x_msg_count,
1206: x_msg_data,
1207: '_PVT'
1208: );

Line 1210: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1206: x_msg_data,
1207: '_PVT'
1208: );
1209: WHEN OTHERS THEN
1210: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1211: (
1212: l_api_name,
1213: G_PKG_NAME,
1214: 'OTHERS',

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

1230: x_qcov_rec OUT NOCOPY qcov_rec_type) IS
1231:
1232: l_api_version CONSTANT NUMBER := 1;
1233: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1234: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1235: l_qcov_rec qcov_rec_type := p_qcov_rec;
1236: l_def_qcov_rec qcov_rec_type;
1237: l_qco_rec qco_rec_type;
1238: lx_qco_rec qco_rec_type;

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

1257: FUNCTION Set_Attributes (
1258: p_qcov_rec IN qcov_rec_type,
1259: x_qcov_rec OUT NOCOPY qcov_rec_type
1260: ) RETURN VARCHAR2 IS
1261: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1262: BEGIN
1263: x_qcov_rec := p_qcov_rec;
1264: x_qcov_rec.OBJECT_VERSION_NUMBER := 1;
1265: RETURN(l_return_status);

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

1264: x_qcov_rec.OBJECT_VERSION_NUMBER := 1;
1265: RETURN(l_return_status);
1266: END Set_Attributes;
1267: BEGIN
1268: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1269: G_PKG_NAME,
1270: p_init_msg_list,
1271: l_api_version,
1272: p_api_version,

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

1271: l_api_version,
1272: p_api_version,
1273: 'PVT',
1274: x_return_status);
1275: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1277: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1278: RAISE OKL_API.G_EXCEPTION_ERROR;
1279: END IF;

Line 1276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1272: p_api_version,
1273: 'PVT',
1274: x_return_status);
1275: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1277: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1278: RAISE OKL_API.G_EXCEPTION_ERROR;
1279: END IF;
1280: l_qcov_rec := null_out_defaults(p_qcov_rec);

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

1273: 'PVT',
1274: x_return_status);
1275: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1277: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1278: RAISE OKL_API.G_EXCEPTION_ERROR;
1279: END IF;
1280: l_qcov_rec := null_out_defaults(p_qcov_rec);
1281: -- Set primary key value

Line 1278: RAISE OKL_API.G_EXCEPTION_ERROR;

1274: x_return_status);
1275: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1277: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1278: RAISE OKL_API.G_EXCEPTION_ERROR;
1279: END IF;
1280: l_qcov_rec := null_out_defaults(p_qcov_rec);
1281: -- Set primary key value
1282: l_qcov_rec.ID := get_seq_id;

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

1284: l_return_Status := Set_Attributes(
1285: l_qcov_rec, -- IN
1286: l_def_qcov_rec); -- OUT
1287: --- If any errors happen abort API
1288: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1289: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1290: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1291: RAISE OKL_API.G_EXCEPTION_ERROR;
1292: END IF;

Line 1289: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1285: l_qcov_rec, -- IN
1286: l_def_qcov_rec); -- OUT
1287: --- If any errors happen abort API
1288: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1289: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1290: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1291: RAISE OKL_API.G_EXCEPTION_ERROR;
1292: END IF;
1293: l_def_qcov_rec := fill_who_columns(l_def_qcov_rec);

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

1286: l_def_qcov_rec); -- OUT
1287: --- If any errors happen abort API
1288: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1289: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1290: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1291: RAISE OKL_API.G_EXCEPTION_ERROR;
1292: END IF;
1293: l_def_qcov_rec := fill_who_columns(l_def_qcov_rec);
1294: --- Validate all non-missing attributes (Item Level Validation)

Line 1291: RAISE OKL_API.G_EXCEPTION_ERROR;

1287: --- If any errors happen abort API
1288: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1289: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1290: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1291: RAISE OKL_API.G_EXCEPTION_ERROR;
1292: END IF;
1293: l_def_qcov_rec := fill_who_columns(l_def_qcov_rec);
1294: --- Validate all non-missing attributes (Item Level Validation)
1295: l_return_status := Validate_Attributes(l_def_qcov_rec);

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

1293: l_def_qcov_rec := fill_who_columns(l_def_qcov_rec);
1294: --- Validate all non-missing attributes (Item Level Validation)
1295: l_return_status := Validate_Attributes(l_def_qcov_rec);
1296: --- If any errors happen abort API
1297: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1298: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1299: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1300: RAISE OKL_API.G_EXCEPTION_ERROR;
1301: END IF;

Line 1298: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1294: --- Validate all non-missing attributes (Item Level Validation)
1295: l_return_status := Validate_Attributes(l_def_qcov_rec);
1296: --- If any errors happen abort API
1297: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1298: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1299: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1300: RAISE OKL_API.G_EXCEPTION_ERROR;
1301: END IF;
1302:

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

1295: l_return_status := Validate_Attributes(l_def_qcov_rec);
1296: --- If any errors happen abort API
1297: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1298: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1299: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1300: RAISE OKL_API.G_EXCEPTION_ERROR;
1301: END IF;
1302:
1303: /*

Line 1300: RAISE OKL_API.G_EXCEPTION_ERROR;

1296: --- If any errors happen abort API
1297: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1298: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1299: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1300: RAISE OKL_API.G_EXCEPTION_ERROR;
1301: END IF;
1302:
1303: /*
1304: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,

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

1303: /*
1304: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
1305: -- which has been moved to individaul valiadte attribute procedures
1306: l_return_status := Validate_Record(l_def_qcov_rec);
1307: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1308: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1309: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1310: RAISE OKL_API.G_EXCEPTION_ERROR;
1311: END IF;

Line 1308: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1304: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
1305: -- which has been moved to individaul valiadte attribute procedures
1306: l_return_status := Validate_Record(l_def_qcov_rec);
1307: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1308: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1309: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1310: RAISE OKL_API.G_EXCEPTION_ERROR;
1311: END IF;
1312: */

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

1305: -- which has been moved to individaul valiadte attribute procedures
1306: l_return_status := Validate_Record(l_def_qcov_rec);
1307: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1308: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1309: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1310: RAISE OKL_API.G_EXCEPTION_ERROR;
1311: END IF;
1312: */
1313:

Line 1310: RAISE OKL_API.G_EXCEPTION_ERROR;

1306: l_return_status := Validate_Record(l_def_qcov_rec);
1307: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1308: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1309: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1310: RAISE OKL_API.G_EXCEPTION_ERROR;
1311: END IF;
1312: */
1313:
1314: -----------------------------------------

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

1325: x_msg_data,
1326: l_qco_rec,
1327: lx_qco_rec
1328: );
1329: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1331: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1332: RAISE OKL_API.G_EXCEPTION_ERROR;
1333: END IF;

Line 1330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1326: l_qco_rec,
1327: lx_qco_rec
1328: );
1329: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1331: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1332: RAISE OKL_API.G_EXCEPTION_ERROR;
1333: END IF;
1334: migrate(lx_qco_rec, l_def_qcov_rec);

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

1327: lx_qco_rec
1328: );
1329: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1331: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1332: RAISE OKL_API.G_EXCEPTION_ERROR;
1333: END IF;
1334: migrate(lx_qco_rec, l_def_qcov_rec);
1335: -- Set OUT values

Line 1332: RAISE OKL_API.G_EXCEPTION_ERROR;

1328: );
1329: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1331: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1332: RAISE OKL_API.G_EXCEPTION_ERROR;
1333: END IF;
1334: migrate(lx_qco_rec, l_def_qcov_rec);
1335: -- Set OUT values
1336: x_qcov_rec := l_def_qcov_rec;

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

1334: migrate(lx_qco_rec, l_def_qcov_rec);
1335: -- Set OUT values
1336: x_qcov_rec := l_def_qcov_rec;
1337: x_return_status := l_return_status;
1338: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1339: EXCEPTION
1340: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1341: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1342: (

Line 1340: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1336: x_qcov_rec := l_def_qcov_rec;
1337: x_return_status := l_return_status;
1338: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1339: EXCEPTION
1340: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1341: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1342: (
1343: l_api_name,
1344: G_PKG_NAME,

Line 1341: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1337: x_return_status := l_return_status;
1338: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1339: EXCEPTION
1340: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1341: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1342: (
1343: l_api_name,
1344: G_PKG_NAME,
1345: 'OKL_API.G_RET_STS_ERROR',

Line 1345: 'OKL_API.G_RET_STS_ERROR',

1341: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1342: (
1343: l_api_name,
1344: G_PKG_NAME,
1345: 'OKL_API.G_RET_STS_ERROR',
1346: x_msg_count,
1347: x_msg_data,
1348: '_PVT'
1349: );

Line 1350: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1346: x_msg_count,
1347: x_msg_data,
1348: '_PVT'
1349: );
1350: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1351: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1352: (
1353: l_api_name,
1354: G_PKG_NAME,

Line 1351: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1347: x_msg_data,
1348: '_PVT'
1349: );
1350: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1351: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1352: (
1353: l_api_name,
1354: G_PKG_NAME,
1355: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1355: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1351: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1352: (
1353: l_api_name,
1354: G_PKG_NAME,
1355: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1356: x_msg_count,
1357: x_msg_data,
1358: '_PVT'
1359: );

Line 1361: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1357: x_msg_data,
1358: '_PVT'
1359: );
1360: WHEN OTHERS THEN
1361: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1362: (
1363: l_api_name,
1364: G_PKG_NAME,
1365: 'OTHERS',

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

1378: x_msg_count OUT NOCOPY NUMBER,
1379: x_msg_data OUT NOCOPY VARCHAR2,
1380: p_qcov_tbl IN qcov_tbl_type,
1381: x_qcov_tbl OUT NOCOPY qcov_tbl_type,
1382: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1383:
1384: l_api_version CONSTANT NUMBER := 1;
1385: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1386: i NUMBER := 0;

Line 1388: OKL_API.init_msg_list(p_init_msg_list);

1384: l_api_version CONSTANT NUMBER := 1;
1385: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1386: i NUMBER := 0;
1387: BEGIN
1388: OKL_API.init_msg_list(p_init_msg_list);
1389: -- Make sure PL/SQL table has records in it before passing
1390: IF (p_qcov_tbl.COUNT > 0) THEN
1391: i := p_qcov_tbl.FIRST;
1392: LOOP

Line 1394: l_error_rec OKL_API.ERROR_REC_TYPE;

1390: IF (p_qcov_tbl.COUNT > 0) THEN
1391: i := p_qcov_tbl.FIRST;
1392: LOOP
1393: DECLARE
1394: l_error_rec OKL_API.ERROR_REC_TYPE;
1395: BEGIN
1396: l_error_rec.api_name := l_api_name;
1397: l_error_rec.api_package := G_PKG_NAME;
1398: l_error_rec.idx := i;

Line 1401: p_init_msg_list => OKL_API.G_FALSE,

1397: l_error_rec.api_package := G_PKG_NAME;
1398: l_error_rec.idx := i;
1399: insert_row (
1400: p_api_version => p_api_version,
1401: p_init_msg_list => OKL_API.G_FALSE,
1402: x_return_status => l_error_rec.error_type,
1403: x_msg_count => l_error_rec.msg_count,
1404: x_msg_data => l_error_rec.msg_data,
1405: p_qcov_rec => p_qcov_tbl(i),

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

1403: x_msg_count => l_error_rec.msg_count,
1404: x_msg_data => l_error_rec.msg_data,
1405: p_qcov_rec => p_qcov_tbl(i),
1406: x_qcov_rec => x_qcov_tbl(i));
1407: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
1408: l_error_rec.sqlcode := SQLCODE;
1409: load_error_tbl(l_error_rec, px_error_tbl);
1410: ELSE
1411: x_msg_count := l_error_rec.msg_count;

Line 1415: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1411: x_msg_count := l_error_rec.msg_count;
1412: x_msg_data := l_error_rec.msg_data;
1413: END IF;
1414: EXCEPTION
1415: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1416: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1417: l_error_rec.sqlcode := SQLCODE;
1418: load_error_tbl(l_error_rec, px_error_tbl);
1419: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

1412: x_msg_data := l_error_rec.msg_data;
1413: END IF;
1414: EXCEPTION
1415: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1416: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1417: l_error_rec.sqlcode := SQLCODE;
1418: load_error_tbl(l_error_rec, px_error_tbl);
1419: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1420: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1419: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1415: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1416: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1417: l_error_rec.sqlcode := SQLCODE;
1418: load_error_tbl(l_error_rec, px_error_tbl);
1419: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1420: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1421: l_error_rec.sqlcode := SQLCODE;
1422: load_error_tbl(l_error_rec, px_error_tbl);
1423: WHEN OTHERS THEN

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

1416: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1417: l_error_rec.sqlcode := SQLCODE;
1418: load_error_tbl(l_error_rec, px_error_tbl);
1419: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1420: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1421: l_error_rec.sqlcode := SQLCODE;
1422: load_error_tbl(l_error_rec, px_error_tbl);
1423: WHEN OTHERS THEN
1424: l_error_rec.error_type := 'OTHERS';

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

1431: END IF;
1432: -- Loop through the error_tbl to find the error with the highest severity
1433: -- and return it.
1434: x_return_status := find_highest_exception(px_error_tbl);
1435: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1436: EXCEPTION
1437: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1438: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1439: (

Line 1437: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1433: -- and return it.
1434: x_return_status := find_highest_exception(px_error_tbl);
1435: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1436: EXCEPTION
1437: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1438: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1439: (
1440: l_api_name,
1441: G_PKG_NAME,

Line 1438: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1434: x_return_status := find_highest_exception(px_error_tbl);
1435: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1436: EXCEPTION
1437: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1438: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1439: (
1440: l_api_name,
1441: G_PKG_NAME,
1442: 'OKL_API.G_RET_STS_ERROR',

Line 1442: 'OKL_API.G_RET_STS_ERROR',

1438: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1439: (
1440: l_api_name,
1441: G_PKG_NAME,
1442: 'OKL_API.G_RET_STS_ERROR',
1443: x_msg_count,
1444: x_msg_data,
1445: '_PVT'
1446: );

Line 1447: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1443: x_msg_count,
1444: x_msg_data,
1445: '_PVT'
1446: );
1447: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1448: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1449: (
1450: l_api_name,
1451: G_PKG_NAME,

Line 1448: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1452: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1448: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1449: (
1450: l_api_name,
1451: G_PKG_NAME,
1452: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1453: x_msg_count,
1454: x_msg_data,
1455: '_PVT'
1456: );

Line 1458: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1454: x_msg_data,
1455: '_PVT'
1456: );
1457: WHEN OTHERS THEN
1458: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1459: (
1460: l_api_name,
1461: G_PKG_NAME,
1462: 'OTHERS',

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

1481: x_qcov_tbl OUT NOCOPY qcov_tbl_type) IS
1482:
1483: l_api_version CONSTANT NUMBER := 1;
1484: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1485: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1486: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1487: BEGIN
1488: OKL_API.init_msg_list(p_init_msg_list);
1489: -- Make sure PL/SQL table has records in it before passing

Line 1486: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1482:
1483: l_api_version CONSTANT NUMBER := 1;
1484: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1485: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1486: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1487: BEGIN
1488: OKL_API.init_msg_list(p_init_msg_list);
1489: -- Make sure PL/SQL table has records in it before passing
1490: IF (p_qcov_tbl.COUNT > 0) THEN

Line 1488: OKL_API.init_msg_list(p_init_msg_list);

1484: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1485: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1486: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1487: BEGIN
1488: OKL_API.init_msg_list(p_init_msg_list);
1489: -- Make sure PL/SQL table has records in it before passing
1490: IF (p_qcov_tbl.COUNT > 0) THEN
1491: insert_row (
1492: p_api_version => p_api_version,

Line 1493: p_init_msg_list => OKL_API.G_FALSE,

1489: -- Make sure PL/SQL table has records in it before passing
1490: IF (p_qcov_tbl.COUNT > 0) THEN
1491: insert_row (
1492: p_api_version => p_api_version,
1493: p_init_msg_list => OKL_API.G_FALSE,
1494: x_return_status => x_return_status,
1495: x_msg_count => x_msg_count,
1496: x_msg_data => x_msg_data,
1497: p_qcov_tbl => p_qcov_tbl,

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

1497: p_qcov_tbl => p_qcov_tbl,
1498: x_qcov_tbl => x_qcov_tbl,
1499: px_error_tbl => l_error_tbl);
1500: END IF;
1501: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1502: EXCEPTION
1503: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1504: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1505: (

Line 1503: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1499: px_error_tbl => l_error_tbl);
1500: END IF;
1501: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1502: EXCEPTION
1503: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1504: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1505: (
1506: l_api_name,
1507: G_PKG_NAME,

Line 1504: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1500: END IF;
1501: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1502: EXCEPTION
1503: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1504: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1505: (
1506: l_api_name,
1507: G_PKG_NAME,
1508: 'OKL_API.G_RET_STS_ERROR',

Line 1508: 'OKL_API.G_RET_STS_ERROR',

1504: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1505: (
1506: l_api_name,
1507: G_PKG_NAME,
1508: 'OKL_API.G_RET_STS_ERROR',
1509: x_msg_count,
1510: x_msg_data,
1511: '_PVT'
1512: );

Line 1513: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1509: x_msg_count,
1510: x_msg_data,
1511: '_PVT'
1512: );
1513: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1514: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1515: (
1516: l_api_name,
1517: G_PKG_NAME,

Line 1514: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1510: x_msg_data,
1511: '_PVT'
1512: );
1513: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1514: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1515: (
1516: l_api_name,
1517: G_PKG_NAME,
1518: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1518: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1514: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1515: (
1516: l_api_name,
1517: G_PKG_NAME,
1518: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1519: x_msg_count,
1520: x_msg_data,
1521: '_PVT'
1522: );

Line 1524: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1520: x_msg_data,
1521: '_PVT'
1522: );
1523: WHEN OTHERS THEN
1524: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1525: (
1526: l_api_name,
1527: G_PKG_NAME,
1528: 'OTHERS',

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

1547: x_qcov_tbl OUT NOCOPY qcov_tbl_type) IS
1548:
1549: l_api_version CONSTANT NUMBER := 1;
1550: l_api_name CONSTANT VARCHAR2(30) := 'insert_row_bulk';
1551: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1552: l_qcov_tbl qcov_tbl_type;
1553: l_qcov_rec qcov_rec_type;
1554:
1555: -- Arrays to store pl-sql table and pass it to bulk insert

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

1588: l_login_id NUMBER(15);
1589:
1590: BEGIN
1591:
1592: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1593: G_PKG_NAME,
1594: p_init_msg_list,
1595: l_api_version,
1596: p_api_version,

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

1596: p_api_version,
1597: '_PVT',
1598: x_return_status);
1599:
1600: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1602: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1603: RAISE OKL_API.G_EXCEPTION_ERROR;
1604: END IF;

Line 1601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1597: '_PVT',
1598: x_return_status);
1599:
1600: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1602: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1603: RAISE OKL_API.G_EXCEPTION_ERROR;
1604: END IF;
1605:

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

1598: x_return_status);
1599:
1600: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1602: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1603: RAISE OKL_API.G_EXCEPTION_ERROR;
1604: END IF;
1605:
1606: l_qcov_tbl := p_qcov_tbl;

Line 1603: RAISE OKL_API.G_EXCEPTION_ERROR;

1599:
1600: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1601: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1602: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1603: RAISE OKL_API.G_EXCEPTION_ERROR;
1604: END IF;
1605:
1606: l_qcov_tbl := p_qcov_tbl;
1607: i := l_qcov_tbl.FIRST;

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

1625:
1626: -- Validate all non-missing attributes (Item Level Validation)
1627: l_return_status := Validate_Attributes(l_qcov_rec);
1628: -- If any errors happen abort API
1629: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1631: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1632: RAISE OKL_API.G_EXCEPTION_ERROR;
1633: END IF;

Line 1630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1626: -- Validate all non-missing attributes (Item Level Validation)
1627: l_return_status := Validate_Attributes(l_qcov_rec);
1628: -- If any errors happen abort API
1629: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1631: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1632: RAISE OKL_API.G_EXCEPTION_ERROR;
1633: END IF;
1634:

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

1627: l_return_status := Validate_Attributes(l_qcov_rec);
1628: -- If any errors happen abort API
1629: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1631: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1632: RAISE OKL_API.G_EXCEPTION_ERROR;
1633: END IF;
1634:
1635: j:=j+1;

Line 1632: RAISE OKL_API.G_EXCEPTION_ERROR;

1628: -- If any errors happen abort API
1629: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1631: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1632: RAISE OKL_API.G_EXCEPTION_ERROR;
1633: END IF;
1634:
1635: j:=j+1;
1636: in_id(j) := l_qcov_rec.id;

Line 1726: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1722: in_attribute14(i),
1723: in_attribute15(i));
1724:
1725: x_qcov_tbl := l_qcov_tbl;
1726: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1727:
1728: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1729: EXCEPTION
1730: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

1724:
1725: x_qcov_tbl := l_qcov_tbl;
1726: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1727:
1728: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1729: EXCEPTION
1730: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1731: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1732: (

Line 1730: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1726: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1727:
1728: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1729: EXCEPTION
1730: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1731: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1732: (
1733: l_api_name,
1734: G_PKG_NAME,

Line 1731: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1727:
1728: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1729: EXCEPTION
1730: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1731: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1732: (
1733: l_api_name,
1734: G_PKG_NAME,
1735: 'OKL_API.G_RET_STS_ERROR',

Line 1735: 'OKL_API.G_RET_STS_ERROR',

1731: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1732: (
1733: l_api_name,
1734: G_PKG_NAME,
1735: 'OKL_API.G_RET_STS_ERROR',
1736: x_msg_count,
1737: x_msg_data,
1738: '_PVT'
1739: );

Line 1740: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1736: x_msg_count,
1737: x_msg_data,
1738: '_PVT'
1739: );
1740: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1741: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1742: (
1743: l_api_name,
1744: G_PKG_NAME,

Line 1741: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1737: x_msg_data,
1738: '_PVT'
1739: );
1740: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1741: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1742: (
1743: l_api_name,
1744: G_PKG_NAME,
1745: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1745: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1741: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1742: (
1743: l_api_name,
1744: G_PKG_NAME,
1745: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1746: x_msg_count,
1747: x_msg_data,
1748: '_PVT'
1749: );

Line 1751: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1747: x_msg_data,
1748: '_PVT'
1749: );
1750: WHEN OTHERS THEN
1751: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1752: (
1753: l_api_name,
1754: G_PKG_NAME,
1755: 'OTHERS',

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

1787: FROM OKL_TRX_QTE_CF_OBJECTS
1788: WHERE ID = p_qco_rec.id;
1789: l_api_version CONSTANT NUMBER := 1;
1790: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1791: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1792: l_object_version_number OKL_TRX_QTE_CF_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;
1793: lc_object_version_number OKL_TRX_QTE_CF_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;
1794: l_row_notfound BOOLEAN := FALSE;
1795: lc_row_notfound BOOLEAN := FALSE;

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

1793: lc_object_version_number OKL_TRX_QTE_CF_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;
1794: l_row_notfound BOOLEAN := FALSE;
1795: lc_row_notfound BOOLEAN := FALSE;
1796: BEGIN
1797: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1798: p_init_msg_list,
1799: 'PVT',
1800: x_return_status);
1801: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1797: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1798: p_init_msg_list,
1799: 'PVT',
1800: x_return_status);
1801: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1802: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1803: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1804: RAISE OKL_API.G_EXCEPTION_ERROR;
1805: END IF;

Line 1802: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1798: p_init_msg_list,
1799: 'PVT',
1800: x_return_status);
1801: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1802: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1803: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1804: RAISE OKL_API.G_EXCEPTION_ERROR;
1805: END IF;
1806: BEGIN

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

1799: 'PVT',
1800: x_return_status);
1801: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1802: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1803: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1804: RAISE OKL_API.G_EXCEPTION_ERROR;
1805: END IF;
1806: BEGIN
1807: OPEN lock_csr(p_qco_rec);

Line 1804: RAISE OKL_API.G_EXCEPTION_ERROR;

1800: x_return_status);
1801: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1802: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1803: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1804: RAISE OKL_API.G_EXCEPTION_ERROR;
1805: END IF;
1806: BEGIN
1807: OPEN lock_csr(p_qco_rec);
1808: FETCH lock_csr INTO l_object_version_number;

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

1812: WHEN E_Resource_Busy THEN
1813: IF (lock_csr%ISOPEN) THEN
1814: CLOSE lock_csr;
1815: END IF;
1816: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1817: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1818: END;
1819:
1820: IF ( l_row_notfound ) THEN

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

1823: lc_row_notfound := lchk_csr%NOTFOUND;
1824: CLOSE lchk_csr;
1825: END IF;
1826: IF (lc_row_notfound) THEN
1827: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1828: RAISE OKL_API.G_EXCEPTION_ERROR;
1829: ELSIF lc_object_version_number > p_qco_rec.object_version_number THEN
1830: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1831: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1828: RAISE OKL_API.G_EXCEPTION_ERROR;

1824: CLOSE lchk_csr;
1825: END IF;
1826: IF (lc_row_notfound) THEN
1827: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1828: RAISE OKL_API.G_EXCEPTION_ERROR;
1829: ELSIF lc_object_version_number > p_qco_rec.object_version_number THEN
1830: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1831: RAISE OKL_API.G_EXCEPTION_ERROR;
1832: ELSIF lc_object_version_number <> p_qco_rec.object_version_number THEN

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

1826: IF (lc_row_notfound) THEN
1827: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1828: RAISE OKL_API.G_EXCEPTION_ERROR;
1829: ELSIF lc_object_version_number > p_qco_rec.object_version_number THEN
1830: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1831: RAISE OKL_API.G_EXCEPTION_ERROR;
1832: ELSIF lc_object_version_number <> p_qco_rec.object_version_number THEN
1833: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1834: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1831: RAISE OKL_API.G_EXCEPTION_ERROR;

1827: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1828: RAISE OKL_API.G_EXCEPTION_ERROR;
1829: ELSIF lc_object_version_number > p_qco_rec.object_version_number THEN
1830: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1831: RAISE OKL_API.G_EXCEPTION_ERROR;
1832: ELSIF lc_object_version_number <> p_qco_rec.object_version_number THEN
1833: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1834: RAISE OKL_API.G_EXCEPTION_ERROR;
1835: ELSIF lc_object_version_number = -1 THEN

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

1829: ELSIF lc_object_version_number > p_qco_rec.object_version_number THEN
1830: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1831: RAISE OKL_API.G_EXCEPTION_ERROR;
1832: ELSIF lc_object_version_number <> p_qco_rec.object_version_number THEN
1833: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1834: RAISE OKL_API.G_EXCEPTION_ERROR;
1835: ELSIF lc_object_version_number = -1 THEN
1836: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1837: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1834: RAISE OKL_API.G_EXCEPTION_ERROR;

1830: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1831: RAISE OKL_API.G_EXCEPTION_ERROR;
1832: ELSIF lc_object_version_number <> p_qco_rec.object_version_number THEN
1833: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1834: RAISE OKL_API.G_EXCEPTION_ERROR;
1835: ELSIF lc_object_version_number = -1 THEN
1836: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1837: RAISE OKL_API.G_EXCEPTION_ERROR;
1838: END IF;

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

1832: ELSIF lc_object_version_number <> p_qco_rec.object_version_number THEN
1833: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1834: RAISE OKL_API.G_EXCEPTION_ERROR;
1835: ELSIF lc_object_version_number = -1 THEN
1836: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1837: RAISE OKL_API.G_EXCEPTION_ERROR;
1838: END IF;
1839: x_return_status := l_return_status;
1840: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1837: RAISE OKL_API.G_EXCEPTION_ERROR;

1833: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1834: RAISE OKL_API.G_EXCEPTION_ERROR;
1835: ELSIF lc_object_version_number = -1 THEN
1836: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1837: RAISE OKL_API.G_EXCEPTION_ERROR;
1838: END IF;
1839: x_return_status := l_return_status;
1840: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1841: EXCEPTION

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

1836: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1837: RAISE OKL_API.G_EXCEPTION_ERROR;
1838: END IF;
1839: x_return_status := l_return_status;
1840: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1841: EXCEPTION
1842: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1843: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1844: (

Line 1842: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 1843: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1847: 'OKL_API.G_RET_STS_ERROR',

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

Line 1852: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1853: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1857: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1863: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1882: p_qcov_rec IN qcov_rec_type) IS
1883:
1884: l_api_version CONSTANT NUMBER := 1;
1885: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1886: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1887: l_qco_rec qco_rec_type;
1888: BEGIN
1889: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1890: G_PKG_NAME,

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

1885: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1886: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1887: l_qco_rec qco_rec_type;
1888: BEGIN
1889: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1890: G_PKG_NAME,
1891: p_init_msg_list,
1892: l_api_version,
1893: p_api_version,

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

1892: l_api_version,
1893: p_api_version,
1894: 'PVT',
1895: x_return_status);
1896: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1899: RAISE OKL_API.G_EXCEPTION_ERROR;
1900: END IF;

Line 1897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1893: p_api_version,
1894: 'PVT',
1895: x_return_status);
1896: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1899: RAISE OKL_API.G_EXCEPTION_ERROR;
1900: END IF;
1901: -----------------------------------------

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

1894: 'PVT',
1895: x_return_status);
1896: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1899: RAISE OKL_API.G_EXCEPTION_ERROR;
1900: END IF;
1901: -----------------------------------------
1902: -- Move VIEW record to "Child" records --

Line 1899: RAISE OKL_API.G_EXCEPTION_ERROR;

1895: x_return_status);
1896: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1899: RAISE OKL_API.G_EXCEPTION_ERROR;
1900: END IF;
1901: -----------------------------------------
1902: -- Move VIEW record to "Child" records --
1903: -----------------------------------------

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

1911: x_msg_count,
1912: x_msg_data,
1913: l_qco_rec
1914: );
1915: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1916: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1917: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1918: RAISE OKL_API.G_EXCEPTION_ERROR;
1919: END IF;

Line 1916: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1912: x_msg_data,
1913: l_qco_rec
1914: );
1915: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1916: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1917: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1918: RAISE OKL_API.G_EXCEPTION_ERROR;
1919: END IF;
1920: x_return_status := l_return_status;

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

1913: l_qco_rec
1914: );
1915: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1916: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1917: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1918: RAISE OKL_API.G_EXCEPTION_ERROR;
1919: END IF;
1920: x_return_status := l_return_status;
1921: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1918: RAISE OKL_API.G_EXCEPTION_ERROR;

1914: );
1915: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1916: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1917: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1918: RAISE OKL_API.G_EXCEPTION_ERROR;
1919: END IF;
1920: x_return_status := l_return_status;
1921: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1922: EXCEPTION

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

1917: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1918: RAISE OKL_API.G_EXCEPTION_ERROR;
1919: END IF;
1920: x_return_status := l_return_status;
1921: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1922: EXCEPTION
1923: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1924: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1925: (

Line 1923: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1919: END IF;
1920: x_return_status := l_return_status;
1921: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1922: EXCEPTION
1923: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1924: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1925: (
1926: l_api_name,
1927: G_PKG_NAME,

Line 1924: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1928: 'OKL_API.G_RET_STS_ERROR',

1924: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1925: (
1926: l_api_name,
1927: G_PKG_NAME,
1928: 'OKL_API.G_RET_STS_ERROR',
1929: x_msg_count,
1930: x_msg_data,
1931: '_PVT'
1932: );

Line 1933: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1934: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1938: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1934: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1935: (
1936: l_api_name,
1937: G_PKG_NAME,
1938: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1939: x_msg_count,
1940: x_msg_data,
1941: '_PVT'
1942: );

Line 1944: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1960: x_return_status OUT NOCOPY VARCHAR2,
1961: x_msg_count OUT NOCOPY NUMBER,
1962: x_msg_data OUT NOCOPY VARCHAR2,
1963: p_qcov_tbl IN qcov_tbl_type,
1964: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1965:
1966: l_api_version CONSTANT NUMBER := 1;
1967: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1968: i NUMBER := 0;

Line 1970: OKL_API.init_msg_list(p_init_msg_list);

1966: l_api_version CONSTANT NUMBER := 1;
1967: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1968: i NUMBER := 0;
1969: BEGIN
1970: OKL_API.init_msg_list(p_init_msg_list);
1971: -- Make sure PL/SQL table has recrods in it before passing
1972: IF (p_qcov_tbl.COUNT > 0) THEN
1973: i := p_qcov_tbl.FIRST;
1974: LOOP

Line 1976: l_error_rec OKL_API.ERROR_REC_TYPE;

1972: IF (p_qcov_tbl.COUNT > 0) THEN
1973: i := p_qcov_tbl.FIRST;
1974: LOOP
1975: DECLARE
1976: l_error_rec OKL_API.ERROR_REC_TYPE;
1977: BEGIN
1978: l_error_rec.api_name := l_api_name;
1979: l_error_rec.api_package := G_PKG_NAME;
1980: l_error_rec.idx := i;

Line 1983: p_init_msg_list => OKL_API.G_FALSE,

1979: l_error_rec.api_package := G_PKG_NAME;
1980: l_error_rec.idx := i;
1981: lock_row(
1982: p_api_version => p_api_version,
1983: p_init_msg_list => OKL_API.G_FALSE,
1984: x_return_status => l_error_rec.error_type,
1985: x_msg_count => l_error_rec.msg_count,
1986: x_msg_data => l_error_rec.msg_data,
1987: p_qcov_rec => p_qcov_tbl(i));

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

1984: x_return_status => l_error_rec.error_type,
1985: x_msg_count => l_error_rec.msg_count,
1986: x_msg_data => l_error_rec.msg_data,
1987: p_qcov_rec => p_qcov_tbl(i));
1988: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
1989: l_error_rec.sqlcode := SQLCODE;
1990: load_error_tbl(l_error_rec, px_error_tbl);
1991: ELSE
1992: x_msg_count := l_error_rec.msg_count;

Line 1996: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1992: x_msg_count := l_error_rec.msg_count;
1993: x_msg_data := l_error_rec.msg_data;
1994: END IF;
1995: EXCEPTION
1996: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1997: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1998: l_error_rec.sqlcode := SQLCODE;
1999: load_error_tbl(l_error_rec, px_error_tbl);
2000: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

1993: x_msg_data := l_error_rec.msg_data;
1994: END IF;
1995: EXCEPTION
1996: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1997: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1998: l_error_rec.sqlcode := SQLCODE;
1999: load_error_tbl(l_error_rec, px_error_tbl);
2000: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2001: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2000: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1996: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1997: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1998: l_error_rec.sqlcode := SQLCODE;
1999: load_error_tbl(l_error_rec, px_error_tbl);
2000: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2001: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2002: l_error_rec.sqlcode := SQLCODE;
2003: load_error_tbl(l_error_rec, px_error_tbl);
2004: WHEN OTHERS THEN

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

1997: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1998: l_error_rec.sqlcode := SQLCODE;
1999: load_error_tbl(l_error_rec, px_error_tbl);
2000: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2001: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2002: l_error_rec.sqlcode := SQLCODE;
2003: load_error_tbl(l_error_rec, px_error_tbl);
2004: WHEN OTHERS THEN
2005: l_error_rec.error_type := 'OTHERS';

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

2012: END IF;
2013: -- Loop through the error_tbl to find the error with the highest severity
2014: -- and return it.
2015: x_return_status := find_highest_exception(px_error_tbl);
2016: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2017: EXCEPTION
2018: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2019: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2020: (

Line 2018: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2014: -- and return it.
2015: x_return_status := find_highest_exception(px_error_tbl);
2016: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2017: EXCEPTION
2018: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2019: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2020: (
2021: l_api_name,
2022: G_PKG_NAME,

Line 2019: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2015: x_return_status := find_highest_exception(px_error_tbl);
2016: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2017: EXCEPTION
2018: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2019: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2020: (
2021: l_api_name,
2022: G_PKG_NAME,
2023: 'OKL_API.G_RET_STS_ERROR',

Line 2023: 'OKL_API.G_RET_STS_ERROR',

2019: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2020: (
2021: l_api_name,
2022: G_PKG_NAME,
2023: 'OKL_API.G_RET_STS_ERROR',
2024: x_msg_count,
2025: x_msg_data,
2026: '_PVT'
2027: );

Line 2028: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2024: x_msg_count,
2025: x_msg_data,
2026: '_PVT'
2027: );
2028: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2029: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2030: (
2031: l_api_name,
2032: G_PKG_NAME,

Line 2029: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2025: x_msg_data,
2026: '_PVT'
2027: );
2028: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2029: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2030: (
2031: l_api_name,
2032: G_PKG_NAME,
2033: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2033: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2029: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2030: (
2031: l_api_name,
2032: G_PKG_NAME,
2033: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2034: x_msg_count,
2035: x_msg_data,
2036: '_PVT'
2037: );

Line 2039: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2035: x_msg_data,
2036: '_PVT'
2037: );
2038: WHEN OTHERS THEN
2039: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2040: (
2041: l_api_name,
2042: G_PKG_NAME,
2043: 'OTHERS',

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

2058: p_qcov_tbl IN qcov_tbl_type) IS
2059:
2060: l_api_version CONSTANT NUMBER := 1;
2061: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2062: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2063: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2064: BEGIN
2065: OKL_API.init_msg_list(p_init_msg_list);
2066: -- Make sure PL/SQL table has recrods in it before passing

Line 2063: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2059:
2060: l_api_version CONSTANT NUMBER := 1;
2061: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2062: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2063: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2064: BEGIN
2065: OKL_API.init_msg_list(p_init_msg_list);
2066: -- Make sure PL/SQL table has recrods in it before passing
2067: IF (p_qcov_tbl.COUNT > 0) THEN

Line 2065: OKL_API.init_msg_list(p_init_msg_list);

2061: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2062: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2063: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2064: BEGIN
2065: OKL_API.init_msg_list(p_init_msg_list);
2066: -- Make sure PL/SQL table has recrods in it before passing
2067: IF (p_qcov_tbl.COUNT > 0) THEN
2068: lock_row(
2069: p_api_version => p_api_version,

Line 2070: p_init_msg_list => OKL_API.G_FALSE,

2066: -- Make sure PL/SQL table has recrods in it before passing
2067: IF (p_qcov_tbl.COUNT > 0) THEN
2068: lock_row(
2069: p_api_version => p_api_version,
2070: p_init_msg_list => OKL_API.G_FALSE,
2071: x_return_status => x_return_status,
2072: x_msg_count => x_msg_count,
2073: x_msg_data => x_msg_data,
2074: p_qcov_tbl => p_qcov_tbl,

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

2073: x_msg_data => x_msg_data,
2074: p_qcov_tbl => p_qcov_tbl,
2075: px_error_tbl => l_error_tbl);
2076: END IF;
2077: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2078: EXCEPTION
2079: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2080: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2081: (

Line 2079: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2075: px_error_tbl => l_error_tbl);
2076: END IF;
2077: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2078: EXCEPTION
2079: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2080: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2081: (
2082: l_api_name,
2083: G_PKG_NAME,

Line 2080: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2076: END IF;
2077: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2078: EXCEPTION
2079: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2080: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2081: (
2082: l_api_name,
2083: G_PKG_NAME,
2084: 'OKL_API.G_RET_STS_ERROR',

Line 2084: 'OKL_API.G_RET_STS_ERROR',

2080: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2081: (
2082: l_api_name,
2083: G_PKG_NAME,
2084: 'OKL_API.G_RET_STS_ERROR',
2085: x_msg_count,
2086: x_msg_data,
2087: '_PVT'
2088: );

Line 2089: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2085: x_msg_count,
2086: x_msg_data,
2087: '_PVT'
2088: );
2089: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2090: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2091: (
2092: l_api_name,
2093: G_PKG_NAME,

Line 2090: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2086: x_msg_data,
2087: '_PVT'
2088: );
2089: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2090: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2091: (
2092: l_api_name,
2093: G_PKG_NAME,
2094: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2094: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2090: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2091: (
2092: l_api_name,
2093: G_PKG_NAME,
2094: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2095: x_msg_count,
2096: x_msg_data,
2097: '_PVT'
2098: );

Line 2100: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2096: x_msg_data,
2097: '_PVT'
2098: );
2099: WHEN OTHERS THEN
2100: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2101: (
2102: l_api_name,
2103: G_PKG_NAME,
2104: 'OTHERS',

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

2122: x_qco_rec OUT NOCOPY qco_rec_type) IS
2123:
2124: l_api_version CONSTANT NUMBER := 1;
2125: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
2126: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2127: l_qco_rec qco_rec_type := p_qco_rec;
2128: l_def_qco_rec qco_rec_type;
2129: l_row_notfound BOOLEAN := TRUE;
2130: ----------------------------------

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

2135: x_qco_rec OUT NOCOPY qco_rec_type
2136: ) RETURN VARCHAR2 IS
2137: l_qco_rec qco_rec_type;
2138: l_row_notfound BOOLEAN := TRUE;
2139: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2140: BEGIN
2141: x_qco_rec := p_qco_rec;
2142: -- Get current database values
2143: l_qco_rec := get_rec(p_qco_rec, l_return_status);

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

2140: BEGIN
2141: x_qco_rec := p_qco_rec;
2142: -- Get current database values
2143: l_qco_rec := get_rec(p_qco_rec, l_return_status);
2144: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2145: IF (x_qco_rec.id = OKL_API.G_MISS_NUM)
2146: THEN
2147: x_qco_rec.id := l_qco_rec.id;
2148: END IF;

Line 2145: IF (x_qco_rec.id = OKL_API.G_MISS_NUM)

2141: x_qco_rec := p_qco_rec;
2142: -- Get current database values
2143: l_qco_rec := get_rec(p_qco_rec, l_return_status);
2144: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2145: IF (x_qco_rec.id = OKL_API.G_MISS_NUM)
2146: THEN
2147: x_qco_rec.id := l_qco_rec.id;
2148: END IF;
2149: IF (x_qco_rec.qte_id = OKL_API.G_MISS_NUM)

Line 2149: IF (x_qco_rec.qte_id = OKL_API.G_MISS_NUM)

2145: IF (x_qco_rec.id = OKL_API.G_MISS_NUM)
2146: THEN
2147: x_qco_rec.id := l_qco_rec.id;
2148: END IF;
2149: IF (x_qco_rec.qte_id = OKL_API.G_MISS_NUM)
2150: THEN
2151: x_qco_rec.qte_id := l_qco_rec.qte_id;
2152: END IF;
2153: IF (x_qco_rec.cfo_id = OKL_API.G_MISS_NUM)

Line 2153: IF (x_qco_rec.cfo_id = OKL_API.G_MISS_NUM)

2149: IF (x_qco_rec.qte_id = OKL_API.G_MISS_NUM)
2150: THEN
2151: x_qco_rec.qte_id := l_qco_rec.qte_id;
2152: END IF;
2153: IF (x_qco_rec.cfo_id = OKL_API.G_MISS_NUM)
2154: THEN
2155: x_qco_rec.cfo_id := l_qco_rec.cfo_id;
2156: END IF;
2157: IF (x_qco_rec.base_source_id = OKL_API.G_MISS_NUM)

Line 2157: IF (x_qco_rec.base_source_id = OKL_API.G_MISS_NUM)

2153: IF (x_qco_rec.cfo_id = OKL_API.G_MISS_NUM)
2154: THEN
2155: x_qco_rec.cfo_id := l_qco_rec.cfo_id;
2156: END IF;
2157: IF (x_qco_rec.base_source_id = OKL_API.G_MISS_NUM)
2158: THEN
2159: x_qco_rec.base_source_id := l_qco_rec.base_source_id;
2160: END IF;
2161: IF (x_qco_rec.object_version_number = OKL_API.G_MISS_NUM)

Line 2161: IF (x_qco_rec.object_version_number = OKL_API.G_MISS_NUM)

2157: IF (x_qco_rec.base_source_id = OKL_API.G_MISS_NUM)
2158: THEN
2159: x_qco_rec.base_source_id := l_qco_rec.base_source_id;
2160: END IF;
2161: IF (x_qco_rec.object_version_number = OKL_API.G_MISS_NUM)
2162: THEN
2163: x_qco_rec.object_version_number := l_qco_rec.object_version_number;
2164: END IF;
2165: IF (x_qco_rec.created_by = OKL_API.G_MISS_NUM)

Line 2165: IF (x_qco_rec.created_by = OKL_API.G_MISS_NUM)

2161: IF (x_qco_rec.object_version_number = OKL_API.G_MISS_NUM)
2162: THEN
2163: x_qco_rec.object_version_number := l_qco_rec.object_version_number;
2164: END IF;
2165: IF (x_qco_rec.created_by = OKL_API.G_MISS_NUM)
2166: THEN
2167: x_qco_rec.created_by := l_qco_rec.created_by;
2168: END IF;
2169: IF (x_qco_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2169: IF (x_qco_rec.creation_date = OKL_API.G_MISS_DATE)

2165: IF (x_qco_rec.created_by = OKL_API.G_MISS_NUM)
2166: THEN
2167: x_qco_rec.created_by := l_qco_rec.created_by;
2168: END IF;
2169: IF (x_qco_rec.creation_date = OKL_API.G_MISS_DATE)
2170: THEN
2171: x_qco_rec.creation_date := l_qco_rec.creation_date;
2172: END IF;
2173: IF (x_qco_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2173: IF (x_qco_rec.last_updated_by = OKL_API.G_MISS_NUM)

2169: IF (x_qco_rec.creation_date = OKL_API.G_MISS_DATE)
2170: THEN
2171: x_qco_rec.creation_date := l_qco_rec.creation_date;
2172: END IF;
2173: IF (x_qco_rec.last_updated_by = OKL_API.G_MISS_NUM)
2174: THEN
2175: x_qco_rec.last_updated_by := l_qco_rec.last_updated_by;
2176: END IF;
2177: IF (x_qco_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2177: IF (x_qco_rec.last_update_date = OKL_API.G_MISS_DATE)

2173: IF (x_qco_rec.last_updated_by = OKL_API.G_MISS_NUM)
2174: THEN
2175: x_qco_rec.last_updated_by := l_qco_rec.last_updated_by;
2176: END IF;
2177: IF (x_qco_rec.last_update_date = OKL_API.G_MISS_DATE)
2178: THEN
2179: x_qco_rec.last_update_date := l_qco_rec.last_update_date;
2180: END IF;
2181: IF (x_qco_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2181: IF (x_qco_rec.last_update_login = OKL_API.G_MISS_NUM)

2177: IF (x_qco_rec.last_update_date = OKL_API.G_MISS_DATE)
2178: THEN
2179: x_qco_rec.last_update_date := l_qco_rec.last_update_date;
2180: END IF;
2181: IF (x_qco_rec.last_update_login = OKL_API.G_MISS_NUM)
2182: THEN
2183: x_qco_rec.last_update_login := l_qco_rec.last_update_login;
2184: END IF;
2185: IF (x_qco_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 2185: IF (x_qco_rec.attribute_category = OKL_API.G_MISS_CHAR)

2181: IF (x_qco_rec.last_update_login = OKL_API.G_MISS_NUM)
2182: THEN
2183: x_qco_rec.last_update_login := l_qco_rec.last_update_login;
2184: END IF;
2185: IF (x_qco_rec.attribute_category = OKL_API.G_MISS_CHAR)
2186: THEN
2187: x_qco_rec.attribute_category := l_qco_rec.attribute_category;
2188: END IF;
2189: IF (x_qco_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 2189: IF (x_qco_rec.attribute1 = OKL_API.G_MISS_CHAR)

2185: IF (x_qco_rec.attribute_category = OKL_API.G_MISS_CHAR)
2186: THEN
2187: x_qco_rec.attribute_category := l_qco_rec.attribute_category;
2188: END IF;
2189: IF (x_qco_rec.attribute1 = OKL_API.G_MISS_CHAR)
2190: THEN
2191: x_qco_rec.attribute1 := l_qco_rec.attribute1;
2192: END IF;
2193: IF (x_qco_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 2193: IF (x_qco_rec.attribute2 = OKL_API.G_MISS_CHAR)

2189: IF (x_qco_rec.attribute1 = OKL_API.G_MISS_CHAR)
2190: THEN
2191: x_qco_rec.attribute1 := l_qco_rec.attribute1;
2192: END IF;
2193: IF (x_qco_rec.attribute2 = OKL_API.G_MISS_CHAR)
2194: THEN
2195: x_qco_rec.attribute2 := l_qco_rec.attribute2;
2196: END IF;
2197: IF (x_qco_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 2197: IF (x_qco_rec.attribute3 = OKL_API.G_MISS_CHAR)

2193: IF (x_qco_rec.attribute2 = OKL_API.G_MISS_CHAR)
2194: THEN
2195: x_qco_rec.attribute2 := l_qco_rec.attribute2;
2196: END IF;
2197: IF (x_qco_rec.attribute3 = OKL_API.G_MISS_CHAR)
2198: THEN
2199: x_qco_rec.attribute3 := l_qco_rec.attribute3;
2200: END IF;
2201: IF (x_qco_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 2201: IF (x_qco_rec.attribute4 = OKL_API.G_MISS_CHAR)

2197: IF (x_qco_rec.attribute3 = OKL_API.G_MISS_CHAR)
2198: THEN
2199: x_qco_rec.attribute3 := l_qco_rec.attribute3;
2200: END IF;
2201: IF (x_qco_rec.attribute4 = OKL_API.G_MISS_CHAR)
2202: THEN
2203: x_qco_rec.attribute4 := l_qco_rec.attribute4;
2204: END IF;
2205: IF (x_qco_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 2205: IF (x_qco_rec.attribute5 = OKL_API.G_MISS_CHAR)

2201: IF (x_qco_rec.attribute4 = OKL_API.G_MISS_CHAR)
2202: THEN
2203: x_qco_rec.attribute4 := l_qco_rec.attribute4;
2204: END IF;
2205: IF (x_qco_rec.attribute5 = OKL_API.G_MISS_CHAR)
2206: THEN
2207: x_qco_rec.attribute5 := l_qco_rec.attribute5;
2208: END IF;
2209: IF (x_qco_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 2209: IF (x_qco_rec.attribute6 = OKL_API.G_MISS_CHAR)

2205: IF (x_qco_rec.attribute5 = OKL_API.G_MISS_CHAR)
2206: THEN
2207: x_qco_rec.attribute5 := l_qco_rec.attribute5;
2208: END IF;
2209: IF (x_qco_rec.attribute6 = OKL_API.G_MISS_CHAR)
2210: THEN
2211: x_qco_rec.attribute6 := l_qco_rec.attribute6;
2212: END IF;
2213: IF (x_qco_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 2213: IF (x_qco_rec.attribute7 = OKL_API.G_MISS_CHAR)

2209: IF (x_qco_rec.attribute6 = OKL_API.G_MISS_CHAR)
2210: THEN
2211: x_qco_rec.attribute6 := l_qco_rec.attribute6;
2212: END IF;
2213: IF (x_qco_rec.attribute7 = OKL_API.G_MISS_CHAR)
2214: THEN
2215: x_qco_rec.attribute7 := l_qco_rec.attribute7;
2216: END IF;
2217: IF (x_qco_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 2217: IF (x_qco_rec.attribute8 = OKL_API.G_MISS_CHAR)

2213: IF (x_qco_rec.attribute7 = OKL_API.G_MISS_CHAR)
2214: THEN
2215: x_qco_rec.attribute7 := l_qco_rec.attribute7;
2216: END IF;
2217: IF (x_qco_rec.attribute8 = OKL_API.G_MISS_CHAR)
2218: THEN
2219: x_qco_rec.attribute8 := l_qco_rec.attribute8;
2220: END IF;
2221: IF (x_qco_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 2221: IF (x_qco_rec.attribute9 = OKL_API.G_MISS_CHAR)

2217: IF (x_qco_rec.attribute8 = OKL_API.G_MISS_CHAR)
2218: THEN
2219: x_qco_rec.attribute8 := l_qco_rec.attribute8;
2220: END IF;
2221: IF (x_qco_rec.attribute9 = OKL_API.G_MISS_CHAR)
2222: THEN
2223: x_qco_rec.attribute9 := l_qco_rec.attribute9;
2224: END IF;
2225: IF (x_qco_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 2225: IF (x_qco_rec.attribute10 = OKL_API.G_MISS_CHAR)

2221: IF (x_qco_rec.attribute9 = OKL_API.G_MISS_CHAR)
2222: THEN
2223: x_qco_rec.attribute9 := l_qco_rec.attribute9;
2224: END IF;
2225: IF (x_qco_rec.attribute10 = OKL_API.G_MISS_CHAR)
2226: THEN
2227: x_qco_rec.attribute10 := l_qco_rec.attribute10;
2228: END IF;
2229: IF (x_qco_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 2229: IF (x_qco_rec.attribute11 = OKL_API.G_MISS_CHAR)

2225: IF (x_qco_rec.attribute10 = OKL_API.G_MISS_CHAR)
2226: THEN
2227: x_qco_rec.attribute10 := l_qco_rec.attribute10;
2228: END IF;
2229: IF (x_qco_rec.attribute11 = OKL_API.G_MISS_CHAR)
2230: THEN
2231: x_qco_rec.attribute11 := l_qco_rec.attribute11;
2232: END IF;
2233: IF (x_qco_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 2233: IF (x_qco_rec.attribute12 = OKL_API.G_MISS_CHAR)

2229: IF (x_qco_rec.attribute11 = OKL_API.G_MISS_CHAR)
2230: THEN
2231: x_qco_rec.attribute11 := l_qco_rec.attribute11;
2232: END IF;
2233: IF (x_qco_rec.attribute12 = OKL_API.G_MISS_CHAR)
2234: THEN
2235: x_qco_rec.attribute12 := l_qco_rec.attribute12;
2236: END IF;
2237: IF (x_qco_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 2237: IF (x_qco_rec.attribute13 = OKL_API.G_MISS_CHAR)

2233: IF (x_qco_rec.attribute12 = OKL_API.G_MISS_CHAR)
2234: THEN
2235: x_qco_rec.attribute12 := l_qco_rec.attribute12;
2236: END IF;
2237: IF (x_qco_rec.attribute13 = OKL_API.G_MISS_CHAR)
2238: THEN
2239: x_qco_rec.attribute13 := l_qco_rec.attribute13;
2240: END IF;
2241: IF (x_qco_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 2241: IF (x_qco_rec.attribute14 = OKL_API.G_MISS_CHAR)

2237: IF (x_qco_rec.attribute13 = OKL_API.G_MISS_CHAR)
2238: THEN
2239: x_qco_rec.attribute13 := l_qco_rec.attribute13;
2240: END IF;
2241: IF (x_qco_rec.attribute14 = OKL_API.G_MISS_CHAR)
2242: THEN
2243: x_qco_rec.attribute14 := l_qco_rec.attribute14;
2244: END IF;
2245: IF (x_qco_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 2245: IF (x_qco_rec.attribute15 = OKL_API.G_MISS_CHAR)

2241: IF (x_qco_rec.attribute14 = OKL_API.G_MISS_CHAR)
2242: THEN
2243: x_qco_rec.attribute14 := l_qco_rec.attribute14;
2244: END IF;
2245: IF (x_qco_rec.attribute15 = OKL_API.G_MISS_CHAR)
2246: THEN
2247: x_qco_rec.attribute15 := l_qco_rec.attribute15;
2248: END IF;
2249: END IF;

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

2255: FUNCTION Set_Attributes (
2256: p_qco_rec IN qco_rec_type,
2257: x_qco_rec OUT NOCOPY qco_rec_type
2258: ) RETURN VARCHAR2 IS
2259: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2260: BEGIN
2261: x_qco_rec := p_qco_rec;
2262: x_qco_rec.OBJECT_VERSION_NUMBER := p_qco_rec.OBJECT_VERSION_NUMBER + 1;
2263: RETURN(l_return_status);

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

2262: x_qco_rec.OBJECT_VERSION_NUMBER := p_qco_rec.OBJECT_VERSION_NUMBER + 1;
2263: RETURN(l_return_status);
2264: END Set_Attributes;
2265: BEGIN
2266: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2267: p_init_msg_list,
2268: 'PVT',
2269: x_return_status);
2270: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

2266: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2267: p_init_msg_list,
2268: 'PVT',
2269: x_return_status);
2270: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2272: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2273: RAISE OKL_API.G_EXCEPTION_ERROR;
2274: END IF;

Line 2271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2267: p_init_msg_list,
2268: 'PVT',
2269: x_return_status);
2270: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2272: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2273: RAISE OKL_API.G_EXCEPTION_ERROR;
2274: END IF;
2275: --- Setting item attributes

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

2268: 'PVT',
2269: x_return_status);
2270: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2272: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2273: RAISE OKL_API.G_EXCEPTION_ERROR;
2274: END IF;
2275: --- Setting item attributes
2276: l_return_status := Set_Attributes(

Line 2273: RAISE OKL_API.G_EXCEPTION_ERROR;

2269: x_return_status);
2270: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2272: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2273: RAISE OKL_API.G_EXCEPTION_ERROR;
2274: END IF;
2275: --- Setting item attributes
2276: l_return_status := Set_Attributes(
2277: p_qco_rec, -- IN

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

2276: l_return_status := Set_Attributes(
2277: p_qco_rec, -- IN
2278: l_qco_rec); -- OUT
2279: --- If any errors happen abort API
2280: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2281: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2282: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2283: RAISE OKL_API.G_EXCEPTION_ERROR;
2284: END IF;

Line 2281: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2277: p_qco_rec, -- IN
2278: l_qco_rec); -- OUT
2279: --- If any errors happen abort API
2280: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2281: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2282: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2283: RAISE OKL_API.G_EXCEPTION_ERROR;
2284: END IF;
2285: l_return_status := populate_new_record(l_qco_rec, l_def_qco_rec);

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

2278: l_qco_rec); -- OUT
2279: --- If any errors happen abort API
2280: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2281: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2282: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2283: RAISE OKL_API.G_EXCEPTION_ERROR;
2284: END IF;
2285: l_return_status := populate_new_record(l_qco_rec, l_def_qco_rec);
2286: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2283: RAISE OKL_API.G_EXCEPTION_ERROR;

2279: --- If any errors happen abort API
2280: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2281: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2282: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2283: RAISE OKL_API.G_EXCEPTION_ERROR;
2284: END IF;
2285: l_return_status := populate_new_record(l_qco_rec, l_def_qco_rec);
2286: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2287: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2282: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2283: RAISE OKL_API.G_EXCEPTION_ERROR;
2284: END IF;
2285: l_return_status := populate_new_record(l_qco_rec, l_def_qco_rec);
2286: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2287: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2288: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2289: RAISE OKL_API.G_EXCEPTION_ERROR;
2290: END IF;

Line 2287: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2283: RAISE OKL_API.G_EXCEPTION_ERROR;
2284: END IF;
2285: l_return_status := populate_new_record(l_qco_rec, l_def_qco_rec);
2286: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2287: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2288: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2289: RAISE OKL_API.G_EXCEPTION_ERROR;
2290: END IF;
2291: UPDATE OKL_TRX_QTE_CF_OBJECTS

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

2284: END IF;
2285: l_return_status := populate_new_record(l_qco_rec, l_def_qco_rec);
2286: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2287: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2288: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2289: RAISE OKL_API.G_EXCEPTION_ERROR;
2290: END IF;
2291: UPDATE OKL_TRX_QTE_CF_OBJECTS
2292: SET QTE_ID = l_def_qco_rec.qte_id,

Line 2289: RAISE OKL_API.G_EXCEPTION_ERROR;

2285: l_return_status := populate_new_record(l_qco_rec, l_def_qco_rec);
2286: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2287: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2288: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2289: RAISE OKL_API.G_EXCEPTION_ERROR;
2290: END IF;
2291: UPDATE OKL_TRX_QTE_CF_OBJECTS
2292: SET QTE_ID = l_def_qco_rec.qte_id,
2293: CFO_ID = l_def_qco_rec.cfo_id,

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

2317: WHERE ID = l_def_qco_rec.id;
2318:
2319: x_qco_rec := l_qco_rec;
2320: x_return_status := l_return_status;
2321: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2322: EXCEPTION
2323: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2324: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2325: (

Line 2323: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2319: x_qco_rec := l_qco_rec;
2320: x_return_status := l_return_status;
2321: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2322: EXCEPTION
2323: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2324: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2325: (
2326: l_api_name,
2327: G_PKG_NAME,

Line 2324: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2320: x_return_status := l_return_status;
2321: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2322: EXCEPTION
2323: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2324: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2325: (
2326: l_api_name,
2327: G_PKG_NAME,
2328: 'OKL_API.G_RET_STS_ERROR',

Line 2328: 'OKL_API.G_RET_STS_ERROR',

2324: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2325: (
2326: l_api_name,
2327: G_PKG_NAME,
2328: 'OKL_API.G_RET_STS_ERROR',
2329: x_msg_count,
2330: x_msg_data,
2331: '_PVT'
2332: );

Line 2333: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2334: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2330: x_msg_data,
2331: '_PVT'
2332: );
2333: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2334: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2335: (
2336: l_api_name,
2337: G_PKG_NAME,
2338: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2338: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2334: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2335: (
2336: l_api_name,
2337: G_PKG_NAME,
2338: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2339: x_msg_count,
2340: x_msg_data,
2341: '_PVT'
2342: );

Line 2344: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2340: x_msg_data,
2341: '_PVT'
2342: );
2343: WHEN OTHERS THEN
2344: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2345: (
2346: l_api_name,
2347: G_PKG_NAME,
2348: 'OTHERS',

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

2364: x_qcov_rec OUT NOCOPY qcov_rec_type) IS
2365:
2366: l_api_version CONSTANT NUMBER := 1;
2367: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2368: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2369: l_qcov_rec qcov_rec_type := p_qcov_rec;
2370: l_def_qcov_rec qcov_rec_type;
2371: l_db_qcov_rec qcov_rec_type;
2372: l_qco_rec qco_rec_type;

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

2391: p_qcov_rec IN qcov_rec_type,
2392: x_qcov_rec OUT NOCOPY qcov_rec_type
2393: ) RETURN VARCHAR2 IS
2394: l_row_notfound BOOLEAN := TRUE;
2395: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2396: BEGIN
2397: x_qcov_rec := p_qcov_rec;
2398: -- Get current database values
2399: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it

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

2398: -- Get current database values
2399: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2400: -- so it may be verified through LOCK_ROW.
2401: l_db_qcov_rec := get_rec(p_qcov_rec, l_return_status);
2402: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2403: IF (x_qcov_rec.id = OKL_API.G_MISS_NUM)
2404: THEN
2405: x_qcov_rec.id := l_db_qcov_rec.id;
2406: END IF;

Line 2403: IF (x_qcov_rec.id = OKL_API.G_MISS_NUM)

2399: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2400: -- so it may be verified through LOCK_ROW.
2401: l_db_qcov_rec := get_rec(p_qcov_rec, l_return_status);
2402: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2403: IF (x_qcov_rec.id = OKL_API.G_MISS_NUM)
2404: THEN
2405: x_qcov_rec.id := l_db_qcov_rec.id;
2406: END IF;
2407: IF (x_qcov_rec.qte_id = OKL_API.G_MISS_NUM)

Line 2407: IF (x_qcov_rec.qte_id = OKL_API.G_MISS_NUM)

2403: IF (x_qcov_rec.id = OKL_API.G_MISS_NUM)
2404: THEN
2405: x_qcov_rec.id := l_db_qcov_rec.id;
2406: END IF;
2407: IF (x_qcov_rec.qte_id = OKL_API.G_MISS_NUM)
2408: THEN
2409: x_qcov_rec.qte_id := l_db_qcov_rec.qte_id;
2410: END IF;
2411: IF (x_qcov_rec.cfo_id = OKL_API.G_MISS_NUM)

Line 2411: IF (x_qcov_rec.cfo_id = OKL_API.G_MISS_NUM)

2407: IF (x_qcov_rec.qte_id = OKL_API.G_MISS_NUM)
2408: THEN
2409: x_qcov_rec.qte_id := l_db_qcov_rec.qte_id;
2410: END IF;
2411: IF (x_qcov_rec.cfo_id = OKL_API.G_MISS_NUM)
2412: THEN
2413: x_qcov_rec.cfo_id := l_db_qcov_rec.cfo_id;
2414: END IF;
2415: IF (x_qcov_rec.base_source_id = OKL_API.G_MISS_NUM)

Line 2415: IF (x_qcov_rec.base_source_id = OKL_API.G_MISS_NUM)

2411: IF (x_qcov_rec.cfo_id = OKL_API.G_MISS_NUM)
2412: THEN
2413: x_qcov_rec.cfo_id := l_db_qcov_rec.cfo_id;
2414: END IF;
2415: IF (x_qcov_rec.base_source_id = OKL_API.G_MISS_NUM)
2416: THEN
2417: x_qcov_rec.base_source_id := l_db_qcov_rec.base_source_id;
2418: END IF;
2419: IF (x_qcov_rec.created_by = OKL_API.G_MISS_NUM)

Line 2419: IF (x_qcov_rec.created_by = OKL_API.G_MISS_NUM)

2415: IF (x_qcov_rec.base_source_id = OKL_API.G_MISS_NUM)
2416: THEN
2417: x_qcov_rec.base_source_id := l_db_qcov_rec.base_source_id;
2418: END IF;
2419: IF (x_qcov_rec.created_by = OKL_API.G_MISS_NUM)
2420: THEN
2421: x_qcov_rec.created_by := l_db_qcov_rec.created_by;
2422: END IF;
2423: IF (x_qcov_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2423: IF (x_qcov_rec.creation_date = OKL_API.G_MISS_DATE)

2419: IF (x_qcov_rec.created_by = OKL_API.G_MISS_NUM)
2420: THEN
2421: x_qcov_rec.created_by := l_db_qcov_rec.created_by;
2422: END IF;
2423: IF (x_qcov_rec.creation_date = OKL_API.G_MISS_DATE)
2424: THEN
2425: x_qcov_rec.creation_date := l_db_qcov_rec.creation_date;
2426: END IF;
2427: IF (x_qcov_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2427: IF (x_qcov_rec.last_updated_by = OKL_API.G_MISS_NUM)

2423: IF (x_qcov_rec.creation_date = OKL_API.G_MISS_DATE)
2424: THEN
2425: x_qcov_rec.creation_date := l_db_qcov_rec.creation_date;
2426: END IF;
2427: IF (x_qcov_rec.last_updated_by = OKL_API.G_MISS_NUM)
2428: THEN
2429: x_qcov_rec.last_updated_by := l_db_qcov_rec.last_updated_by;
2430: END IF;
2431: IF (x_qcov_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2431: IF (x_qcov_rec.last_update_date = OKL_API.G_MISS_DATE)

2427: IF (x_qcov_rec.last_updated_by = OKL_API.G_MISS_NUM)
2428: THEN
2429: x_qcov_rec.last_updated_by := l_db_qcov_rec.last_updated_by;
2430: END IF;
2431: IF (x_qcov_rec.last_update_date = OKL_API.G_MISS_DATE)
2432: THEN
2433: x_qcov_rec.last_update_date := l_db_qcov_rec.last_update_date;
2434: END IF;
2435: IF (x_qcov_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2435: IF (x_qcov_rec.last_update_login = OKL_API.G_MISS_NUM)

2431: IF (x_qcov_rec.last_update_date = OKL_API.G_MISS_DATE)
2432: THEN
2433: x_qcov_rec.last_update_date := l_db_qcov_rec.last_update_date;
2434: END IF;
2435: IF (x_qcov_rec.last_update_login = OKL_API.G_MISS_NUM)
2436: THEN
2437: x_qcov_rec.last_update_login := l_db_qcov_rec.last_update_login;
2438: END IF;
2439: IF (x_qcov_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 2439: IF (x_qcov_rec.attribute_category = OKL_API.G_MISS_CHAR)

2435: IF (x_qcov_rec.last_update_login = OKL_API.G_MISS_NUM)
2436: THEN
2437: x_qcov_rec.last_update_login := l_db_qcov_rec.last_update_login;
2438: END IF;
2439: IF (x_qcov_rec.attribute_category = OKL_API.G_MISS_CHAR)
2440: THEN
2441: x_qcov_rec.attribute_category := l_db_qcov_rec.attribute_category;
2442: END IF;
2443: IF (x_qcov_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 2443: IF (x_qcov_rec.attribute1 = OKL_API.G_MISS_CHAR)

2439: IF (x_qcov_rec.attribute_category = OKL_API.G_MISS_CHAR)
2440: THEN
2441: x_qcov_rec.attribute_category := l_db_qcov_rec.attribute_category;
2442: END IF;
2443: IF (x_qcov_rec.attribute1 = OKL_API.G_MISS_CHAR)
2444: THEN
2445: x_qcov_rec.attribute1 := l_db_qcov_rec.attribute1;
2446: END IF;
2447: IF (x_qcov_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 2447: IF (x_qcov_rec.attribute2 = OKL_API.G_MISS_CHAR)

2443: IF (x_qcov_rec.attribute1 = OKL_API.G_MISS_CHAR)
2444: THEN
2445: x_qcov_rec.attribute1 := l_db_qcov_rec.attribute1;
2446: END IF;
2447: IF (x_qcov_rec.attribute2 = OKL_API.G_MISS_CHAR)
2448: THEN
2449: x_qcov_rec.attribute2 := l_db_qcov_rec.attribute2;
2450: END IF;
2451: IF (x_qcov_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 2451: IF (x_qcov_rec.attribute3 = OKL_API.G_MISS_CHAR)

2447: IF (x_qcov_rec.attribute2 = OKL_API.G_MISS_CHAR)
2448: THEN
2449: x_qcov_rec.attribute2 := l_db_qcov_rec.attribute2;
2450: END IF;
2451: IF (x_qcov_rec.attribute3 = OKL_API.G_MISS_CHAR)
2452: THEN
2453: x_qcov_rec.attribute3 := l_db_qcov_rec.attribute3;
2454: END IF;
2455: IF (x_qcov_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 2455: IF (x_qcov_rec.attribute4 = OKL_API.G_MISS_CHAR)

2451: IF (x_qcov_rec.attribute3 = OKL_API.G_MISS_CHAR)
2452: THEN
2453: x_qcov_rec.attribute3 := l_db_qcov_rec.attribute3;
2454: END IF;
2455: IF (x_qcov_rec.attribute4 = OKL_API.G_MISS_CHAR)
2456: THEN
2457: x_qcov_rec.attribute4 := l_db_qcov_rec.attribute4;
2458: END IF;
2459: IF (x_qcov_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 2459: IF (x_qcov_rec.attribute5 = OKL_API.G_MISS_CHAR)

2455: IF (x_qcov_rec.attribute4 = OKL_API.G_MISS_CHAR)
2456: THEN
2457: x_qcov_rec.attribute4 := l_db_qcov_rec.attribute4;
2458: END IF;
2459: IF (x_qcov_rec.attribute5 = OKL_API.G_MISS_CHAR)
2460: THEN
2461: x_qcov_rec.attribute5 := l_db_qcov_rec.attribute5;
2462: END IF;
2463: IF (x_qcov_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 2463: IF (x_qcov_rec.attribute6 = OKL_API.G_MISS_CHAR)

2459: IF (x_qcov_rec.attribute5 = OKL_API.G_MISS_CHAR)
2460: THEN
2461: x_qcov_rec.attribute5 := l_db_qcov_rec.attribute5;
2462: END IF;
2463: IF (x_qcov_rec.attribute6 = OKL_API.G_MISS_CHAR)
2464: THEN
2465: x_qcov_rec.attribute6 := l_db_qcov_rec.attribute6;
2466: END IF;
2467: IF (x_qcov_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 2467: IF (x_qcov_rec.attribute7 = OKL_API.G_MISS_CHAR)

2463: IF (x_qcov_rec.attribute6 = OKL_API.G_MISS_CHAR)
2464: THEN
2465: x_qcov_rec.attribute6 := l_db_qcov_rec.attribute6;
2466: END IF;
2467: IF (x_qcov_rec.attribute7 = OKL_API.G_MISS_CHAR)
2468: THEN
2469: x_qcov_rec.attribute7 := l_db_qcov_rec.attribute7;
2470: END IF;
2471: IF (x_qcov_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 2471: IF (x_qcov_rec.attribute8 = OKL_API.G_MISS_CHAR)

2467: IF (x_qcov_rec.attribute7 = OKL_API.G_MISS_CHAR)
2468: THEN
2469: x_qcov_rec.attribute7 := l_db_qcov_rec.attribute7;
2470: END IF;
2471: IF (x_qcov_rec.attribute8 = OKL_API.G_MISS_CHAR)
2472: THEN
2473: x_qcov_rec.attribute8 := l_db_qcov_rec.attribute8;
2474: END IF;
2475: IF (x_qcov_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 2475: IF (x_qcov_rec.attribute9 = OKL_API.G_MISS_CHAR)

2471: IF (x_qcov_rec.attribute8 = OKL_API.G_MISS_CHAR)
2472: THEN
2473: x_qcov_rec.attribute8 := l_db_qcov_rec.attribute8;
2474: END IF;
2475: IF (x_qcov_rec.attribute9 = OKL_API.G_MISS_CHAR)
2476: THEN
2477: x_qcov_rec.attribute9 := l_db_qcov_rec.attribute9;
2478: END IF;
2479: IF (x_qcov_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 2479: IF (x_qcov_rec.attribute10 = OKL_API.G_MISS_CHAR)

2475: IF (x_qcov_rec.attribute9 = OKL_API.G_MISS_CHAR)
2476: THEN
2477: x_qcov_rec.attribute9 := l_db_qcov_rec.attribute9;
2478: END IF;
2479: IF (x_qcov_rec.attribute10 = OKL_API.G_MISS_CHAR)
2480: THEN
2481: x_qcov_rec.attribute10 := l_db_qcov_rec.attribute10;
2482: END IF;
2483: IF (x_qcov_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 2483: IF (x_qcov_rec.attribute11 = OKL_API.G_MISS_CHAR)

2479: IF (x_qcov_rec.attribute10 = OKL_API.G_MISS_CHAR)
2480: THEN
2481: x_qcov_rec.attribute10 := l_db_qcov_rec.attribute10;
2482: END IF;
2483: IF (x_qcov_rec.attribute11 = OKL_API.G_MISS_CHAR)
2484: THEN
2485: x_qcov_rec.attribute11 := l_db_qcov_rec.attribute11;
2486: END IF;
2487: IF (x_qcov_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 2487: IF (x_qcov_rec.attribute12 = OKL_API.G_MISS_CHAR)

2483: IF (x_qcov_rec.attribute11 = OKL_API.G_MISS_CHAR)
2484: THEN
2485: x_qcov_rec.attribute11 := l_db_qcov_rec.attribute11;
2486: END IF;
2487: IF (x_qcov_rec.attribute12 = OKL_API.G_MISS_CHAR)
2488: THEN
2489: x_qcov_rec.attribute12 := l_db_qcov_rec.attribute12;
2490: END IF;
2491: IF (x_qcov_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 2491: IF (x_qcov_rec.attribute13 = OKL_API.G_MISS_CHAR)

2487: IF (x_qcov_rec.attribute12 = OKL_API.G_MISS_CHAR)
2488: THEN
2489: x_qcov_rec.attribute12 := l_db_qcov_rec.attribute12;
2490: END IF;
2491: IF (x_qcov_rec.attribute13 = OKL_API.G_MISS_CHAR)
2492: THEN
2493: x_qcov_rec.attribute13 := l_db_qcov_rec.attribute13;
2494: END IF;
2495: IF (x_qcov_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 2495: IF (x_qcov_rec.attribute14 = OKL_API.G_MISS_CHAR)

2491: IF (x_qcov_rec.attribute13 = OKL_API.G_MISS_CHAR)
2492: THEN
2493: x_qcov_rec.attribute13 := l_db_qcov_rec.attribute13;
2494: END IF;
2495: IF (x_qcov_rec.attribute14 = OKL_API.G_MISS_CHAR)
2496: THEN
2497: x_qcov_rec.attribute14 := l_db_qcov_rec.attribute14;
2498: END IF;
2499: IF (x_qcov_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 2499: IF (x_qcov_rec.attribute15 = OKL_API.G_MISS_CHAR)

2495: IF (x_qcov_rec.attribute14 = OKL_API.G_MISS_CHAR)
2496: THEN
2497: x_qcov_rec.attribute14 := l_db_qcov_rec.attribute14;
2498: END IF;
2499: IF (x_qcov_rec.attribute15 = OKL_API.G_MISS_CHAR)
2500: THEN
2501: x_qcov_rec.attribute15 := l_db_qcov_rec.attribute15;
2502: END IF;
2503: END IF;

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

2509: FUNCTION Set_Attributes (
2510: p_qcov_rec IN qcov_rec_type,
2511: x_qcov_rec OUT NOCOPY qcov_rec_type
2512: ) RETURN VARCHAR2 IS
2513: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2514: BEGIN
2515: x_qcov_rec := p_qcov_rec;
2516: RETURN(l_return_status);
2517: END Set_Attributes;

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

2515: x_qcov_rec := p_qcov_rec;
2516: RETURN(l_return_status);
2517: END Set_Attributes;
2518: BEGIN
2519: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2520: G_PKG_NAME,
2521: p_init_msg_list,
2522: l_api_version,
2523: p_api_version,

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

2522: l_api_version,
2523: p_api_version,
2524: 'PVT',
2525: x_return_status);
2526: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2527: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2528: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2529: RAISE OKL_API.G_EXCEPTION_ERROR;
2530: END IF;

Line 2527: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2523: p_api_version,
2524: 'PVT',
2525: x_return_status);
2526: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2527: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2528: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2529: RAISE OKL_API.G_EXCEPTION_ERROR;
2530: END IF;
2531: --- Setting item attributes

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

2524: 'PVT',
2525: x_return_status);
2526: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2527: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2528: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2529: RAISE OKL_API.G_EXCEPTION_ERROR;
2530: END IF;
2531: --- Setting item attributes
2532: l_return_status := Set_Attributes(

Line 2529: RAISE OKL_API.G_EXCEPTION_ERROR;

2525: x_return_status);
2526: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2527: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2528: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2529: RAISE OKL_API.G_EXCEPTION_ERROR;
2530: END IF;
2531: --- Setting item attributes
2532: l_return_status := Set_Attributes(
2533: p_qcov_rec, -- IN

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

2532: l_return_status := Set_Attributes(
2533: p_qcov_rec, -- IN
2534: x_qcov_rec); -- OUT
2535: --- If any errors happen abort API
2536: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2537: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2538: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2539: RAISE OKL_API.G_EXCEPTION_ERROR;
2540: END IF;

Line 2537: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2533: p_qcov_rec, -- IN
2534: x_qcov_rec); -- OUT
2535: --- If any errors happen abort API
2536: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2537: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2538: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2539: RAISE OKL_API.G_EXCEPTION_ERROR;
2540: END IF;
2541: l_return_status := populate_new_record(l_qcov_rec, l_def_qcov_rec);

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

2534: x_qcov_rec); -- OUT
2535: --- If any errors happen abort API
2536: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2537: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2538: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2539: RAISE OKL_API.G_EXCEPTION_ERROR;
2540: END IF;
2541: l_return_status := populate_new_record(l_qcov_rec, l_def_qcov_rec);
2542: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2539: RAISE OKL_API.G_EXCEPTION_ERROR;

2535: --- If any errors happen abort API
2536: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2537: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2538: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2539: RAISE OKL_API.G_EXCEPTION_ERROR;
2540: END IF;
2541: l_return_status := populate_new_record(l_qcov_rec, l_def_qcov_rec);
2542: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2538: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2539: RAISE OKL_API.G_EXCEPTION_ERROR;
2540: END IF;
2541: l_return_status := populate_new_record(l_qcov_rec, l_def_qcov_rec);
2542: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2544: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2545: RAISE OKL_API.G_EXCEPTION_ERROR;
2546: END IF;

Line 2543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2539: RAISE OKL_API.G_EXCEPTION_ERROR;
2540: END IF;
2541: l_return_status := populate_new_record(l_qcov_rec, l_def_qcov_rec);
2542: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2544: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2545: RAISE OKL_API.G_EXCEPTION_ERROR;
2546: END IF;
2547: l_def_qcov_rec := fill_who_columns(l_def_qcov_rec);

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

2540: END IF;
2541: l_return_status := populate_new_record(l_qcov_rec, l_def_qcov_rec);
2542: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2544: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2545: RAISE OKL_API.G_EXCEPTION_ERROR;
2546: END IF;
2547: l_def_qcov_rec := fill_who_columns(l_def_qcov_rec);
2548: --- Validate all non-missing attributes (Item Level Validation)

Line 2545: RAISE OKL_API.G_EXCEPTION_ERROR;

2541: l_return_status := populate_new_record(l_qcov_rec, l_def_qcov_rec);
2542: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2544: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2545: RAISE OKL_API.G_EXCEPTION_ERROR;
2546: END IF;
2547: l_def_qcov_rec := fill_who_columns(l_def_qcov_rec);
2548: --- Validate all non-missing attributes (Item Level Validation)
2549: l_return_status := Validate_Attributes(l_def_qcov_rec);

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

2547: l_def_qcov_rec := fill_who_columns(l_def_qcov_rec);
2548: --- Validate all non-missing attributes (Item Level Validation)
2549: l_return_status := Validate_Attributes(l_def_qcov_rec);
2550: --- If any errors happen abort API
2551: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2552: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2553: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2554: RAISE OKL_API.G_EXCEPTION_ERROR;
2555: END IF;

Line 2552: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2548: --- Validate all non-missing attributes (Item Level Validation)
2549: l_return_status := Validate_Attributes(l_def_qcov_rec);
2550: --- If any errors happen abort API
2551: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2552: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2553: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2554: RAISE OKL_API.G_EXCEPTION_ERROR;
2555: END IF;
2556:

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

2549: l_return_status := Validate_Attributes(l_def_qcov_rec);
2550: --- If any errors happen abort API
2551: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2552: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2553: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2554: RAISE OKL_API.G_EXCEPTION_ERROR;
2555: END IF;
2556:
2557: /*

Line 2554: RAISE OKL_API.G_EXCEPTION_ERROR;

2550: --- If any errors happen abort API
2551: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2552: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2553: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2554: RAISE OKL_API.G_EXCEPTION_ERROR;
2555: END IF;
2556:
2557: /*
2558: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,

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

2557: /*
2558: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
2559: -- which has been moved to individaul valiadte attribute procedures
2560: l_return_status := Validate_Record(l_def_qcov_rec, l_db_qcov_rec);
2561: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2562: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2563: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2564: RAISE OKL_API.G_EXCEPTION_ERROR;
2565: END IF;

Line 2562: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2558: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
2559: -- which has been moved to individaul valiadte attribute procedures
2560: l_return_status := Validate_Record(l_def_qcov_rec, l_db_qcov_rec);
2561: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2562: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2563: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2564: RAISE OKL_API.G_EXCEPTION_ERROR;
2565: END IF;
2566: */

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

2559: -- which has been moved to individaul valiadte attribute procedures
2560: l_return_status := Validate_Record(l_def_qcov_rec, l_db_qcov_rec);
2561: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2562: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2563: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2564: RAISE OKL_API.G_EXCEPTION_ERROR;
2565: END IF;
2566: */
2567:

Line 2564: RAISE OKL_API.G_EXCEPTION_ERROR;

2560: l_return_status := Validate_Record(l_def_qcov_rec, l_db_qcov_rec);
2561: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2562: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2563: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2564: RAISE OKL_API.G_EXCEPTION_ERROR;
2565: END IF;
2566: */
2567:
2568: -- Lock the Record

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

2572: x_return_status => l_return_status,
2573: x_msg_count => x_msg_count,
2574: x_msg_data => x_msg_data,
2575: p_qcov_rec => p_qcov_rec);
2576: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2577: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2578: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2579: RAISE OKL_API.G_EXCEPTION_ERROR;
2580: END IF;

Line 2577: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2573: x_msg_count => x_msg_count,
2574: x_msg_data => x_msg_data,
2575: p_qcov_rec => p_qcov_rec);
2576: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2577: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2578: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2579: RAISE OKL_API.G_EXCEPTION_ERROR;
2580: END IF;
2581:

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

2574: x_msg_data => x_msg_data,
2575: p_qcov_rec => p_qcov_rec);
2576: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2577: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2578: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2579: RAISE OKL_API.G_EXCEPTION_ERROR;
2580: END IF;
2581:
2582: -----------------------------------------

Line 2579: RAISE OKL_API.G_EXCEPTION_ERROR;

2575: p_qcov_rec => p_qcov_rec);
2576: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2577: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2578: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2579: RAISE OKL_API.G_EXCEPTION_ERROR;
2580: END IF;
2581:
2582: -----------------------------------------
2583: -- Move VIEW record to "Child" records --

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

2593: x_msg_data,
2594: l_qco_rec,
2595: lx_qco_rec
2596: );
2597: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2599: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2600: RAISE OKL_API.G_EXCEPTION_ERROR;
2601: END IF;

Line 2598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2594: l_qco_rec,
2595: lx_qco_rec
2596: );
2597: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2599: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2600: RAISE OKL_API.G_EXCEPTION_ERROR;
2601: END IF;
2602: migrate(lx_qco_rec, l_def_qcov_rec);

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

2595: lx_qco_rec
2596: );
2597: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2599: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2600: RAISE OKL_API.G_EXCEPTION_ERROR;
2601: END IF;
2602: migrate(lx_qco_rec, l_def_qcov_rec);
2603: x_qcov_rec := l_def_qcov_rec;

Line 2600: RAISE OKL_API.G_EXCEPTION_ERROR;

2596: );
2597: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2599: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2600: RAISE OKL_API.G_EXCEPTION_ERROR;
2601: END IF;
2602: migrate(lx_qco_rec, l_def_qcov_rec);
2603: x_qcov_rec := l_def_qcov_rec;
2604: x_return_status := l_return_status;

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

2601: END IF;
2602: migrate(lx_qco_rec, l_def_qcov_rec);
2603: x_qcov_rec := l_def_qcov_rec;
2604: x_return_status := l_return_status;
2605: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2606: EXCEPTION
2607: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2608: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2609: (

Line 2607: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2603: x_qcov_rec := l_def_qcov_rec;
2604: x_return_status := l_return_status;
2605: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2606: EXCEPTION
2607: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2608: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2609: (
2610: l_api_name,
2611: G_PKG_NAME,

Line 2608: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2604: x_return_status := l_return_status;
2605: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2606: EXCEPTION
2607: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2608: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2609: (
2610: l_api_name,
2611: G_PKG_NAME,
2612: 'OKL_API.G_RET_STS_ERROR',

Line 2612: 'OKL_API.G_RET_STS_ERROR',

2608: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2609: (
2610: l_api_name,
2611: G_PKG_NAME,
2612: 'OKL_API.G_RET_STS_ERROR',
2613: x_msg_count,
2614: x_msg_data,
2615: '_PVT'
2616: );

Line 2617: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2613: x_msg_count,
2614: x_msg_data,
2615: '_PVT'
2616: );
2617: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2618: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2619: (
2620: l_api_name,
2621: G_PKG_NAME,

Line 2618: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2614: x_msg_data,
2615: '_PVT'
2616: );
2617: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2618: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2619: (
2620: l_api_name,
2621: G_PKG_NAME,
2622: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2622: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2618: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2619: (
2620: l_api_name,
2621: G_PKG_NAME,
2622: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2623: x_msg_count,
2624: x_msg_data,
2625: '_PVT'
2626: );

Line 2628: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2624: x_msg_data,
2625: '_PVT'
2626: );
2627: WHEN OTHERS THEN
2628: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2629: (
2630: l_api_name,
2631: G_PKG_NAME,
2632: 'OTHERS',

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

2645: x_msg_count OUT NOCOPY NUMBER,
2646: x_msg_data OUT NOCOPY VARCHAR2,
2647: p_qcov_tbl IN qcov_tbl_type,
2648: x_qcov_tbl OUT NOCOPY qcov_tbl_type,
2649: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2650:
2651: l_api_version CONSTANT NUMBER := 1;
2652: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2653: i NUMBER := 0;

Line 2655: OKL_API.init_msg_list(p_init_msg_list);

2651: l_api_version CONSTANT NUMBER := 1;
2652: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2653: i NUMBER := 0;
2654: BEGIN
2655: OKL_API.init_msg_list(p_init_msg_list);
2656: -- Make sure PL/SQL table has records in it before passing
2657: IF (p_qcov_tbl.COUNT > 0) THEN
2658: i := p_qcov_tbl.FIRST;
2659: LOOP

Line 2661: l_error_rec OKL_API.ERROR_REC_TYPE;

2657: IF (p_qcov_tbl.COUNT > 0) THEN
2658: i := p_qcov_tbl.FIRST;
2659: LOOP
2660: DECLARE
2661: l_error_rec OKL_API.ERROR_REC_TYPE;
2662: BEGIN
2663: l_error_rec.api_name := l_api_name;
2664: l_error_rec.api_package := G_PKG_NAME;
2665: l_error_rec.idx := i;

Line 2668: p_init_msg_list => OKL_API.G_FALSE,

2664: l_error_rec.api_package := G_PKG_NAME;
2665: l_error_rec.idx := i;
2666: update_row (
2667: p_api_version => p_api_version,
2668: p_init_msg_list => OKL_API.G_FALSE,
2669: x_return_status => l_error_rec.error_type,
2670: x_msg_count => l_error_rec.msg_count,
2671: x_msg_data => l_error_rec.msg_data,
2672: p_qcov_rec => p_qcov_tbl(i),

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

2670: x_msg_count => l_error_rec.msg_count,
2671: x_msg_data => l_error_rec.msg_data,
2672: p_qcov_rec => p_qcov_tbl(i),
2673: x_qcov_rec => x_qcov_tbl(i));
2674: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
2675: l_error_rec.sqlcode := SQLCODE;
2676: load_error_tbl(l_error_rec, px_error_tbl);
2677: ELSE
2678: x_msg_count := l_error_rec.msg_count;

Line 2682: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2678: x_msg_count := l_error_rec.msg_count;
2679: x_msg_data := l_error_rec.msg_data;
2680: END IF;
2681: EXCEPTION
2682: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2683: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2684: l_error_rec.sqlcode := SQLCODE;
2685: load_error_tbl(l_error_rec, px_error_tbl);
2686: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

2679: x_msg_data := l_error_rec.msg_data;
2680: END IF;
2681: EXCEPTION
2682: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2683: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2684: l_error_rec.sqlcode := SQLCODE;
2685: load_error_tbl(l_error_rec, px_error_tbl);
2686: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2687: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2686: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2682: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2683: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2684: l_error_rec.sqlcode := SQLCODE;
2685: load_error_tbl(l_error_rec, px_error_tbl);
2686: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2687: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2688: l_error_rec.sqlcode := SQLCODE;
2689: load_error_tbl(l_error_rec, px_error_tbl);
2690: WHEN OTHERS THEN

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

2683: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2684: l_error_rec.sqlcode := SQLCODE;
2685: load_error_tbl(l_error_rec, px_error_tbl);
2686: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2687: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2688: l_error_rec.sqlcode := SQLCODE;
2689: load_error_tbl(l_error_rec, px_error_tbl);
2690: WHEN OTHERS THEN
2691: l_error_rec.error_type := 'OTHERS';

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

2698: END IF;
2699: -- Loop through the error_tbl to find the error with the highest severity
2700: -- and return it.
2701: x_return_status := find_highest_exception(px_error_tbl);
2702: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2703: EXCEPTION
2704: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2705: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2706: (

Line 2704: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2700: -- and return it.
2701: x_return_status := find_highest_exception(px_error_tbl);
2702: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2703: EXCEPTION
2704: WHEN OKL_API.G_EXCEPTION_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_return_status := find_highest_exception(px_error_tbl);
2702: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2703: EXCEPTION
2704: WHEN OKL_API.G_EXCEPTION_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_ERROR',

Line 2709: 'OKL_API.G_RET_STS_ERROR',

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

Line 2714: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2715: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2719: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2725: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

2748: x_qcov_tbl OUT NOCOPY qcov_tbl_type) IS
2749:
2750: l_api_version CONSTANT NUMBER := 1;
2751: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2752: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2753: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2754: BEGIN
2755: OKL_API.init_msg_list(p_init_msg_list);
2756: -- Make sure PL/SQL table has records in it before passing

Line 2753: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2749:
2750: l_api_version CONSTANT NUMBER := 1;
2751: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2752: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2753: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2754: BEGIN
2755: OKL_API.init_msg_list(p_init_msg_list);
2756: -- Make sure PL/SQL table has records in it before passing
2757: IF (p_qcov_tbl.COUNT > 0) THEN

Line 2755: OKL_API.init_msg_list(p_init_msg_list);

2751: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2752: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2753: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2754: BEGIN
2755: OKL_API.init_msg_list(p_init_msg_list);
2756: -- Make sure PL/SQL table has records in it before passing
2757: IF (p_qcov_tbl.COUNT > 0) THEN
2758: update_row (
2759: p_api_version => p_api_version,

Line 2760: p_init_msg_list => OKL_API.G_FALSE,

2756: -- Make sure PL/SQL table has records in it before passing
2757: IF (p_qcov_tbl.COUNT > 0) THEN
2758: update_row (
2759: p_api_version => p_api_version,
2760: p_init_msg_list => OKL_API.G_FALSE,
2761: x_return_status => x_return_status,
2762: x_msg_count => x_msg_count,
2763: x_msg_data => x_msg_data,
2764: p_qcov_tbl => p_qcov_tbl,

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

2764: p_qcov_tbl => p_qcov_tbl,
2765: x_qcov_tbl => x_qcov_tbl,
2766: px_error_tbl => l_error_tbl);
2767: END IF;
2768: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2769: EXCEPTION
2770: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2771: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2772: (

Line 2770: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 2771: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2775: 'OKL_API.G_RET_STS_ERROR',

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

Line 2780: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2781: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2785: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2791: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

2813: p_qco_rec IN qco_rec_type) IS
2814:
2815: l_api_version CONSTANT NUMBER := 1;
2816: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2817: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2818: l_qco_rec qco_rec_type := p_qco_rec;
2819: l_row_notfound BOOLEAN := TRUE;
2820: BEGIN
2821: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

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

2817: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2818: l_qco_rec qco_rec_type := p_qco_rec;
2819: l_row_notfound BOOLEAN := TRUE;
2820: BEGIN
2821: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2822: p_init_msg_list,
2823: 'PVT',
2824: x_return_status);
2825: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

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

Line 2826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

2823: 'PVT',
2824: x_return_status);
2825: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2828: RAISE OKL_API.G_EXCEPTION_ERROR;
2829: END IF;
2830:
2831: DELETE FROM OKL_TRX_QTE_CF_OBJECTS

Line 2828: RAISE OKL_API.G_EXCEPTION_ERROR;

2824: x_return_status);
2825: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2827: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2828: RAISE OKL_API.G_EXCEPTION_ERROR;
2829: END IF;
2830:
2831: DELETE FROM OKL_TRX_QTE_CF_OBJECTS
2832: WHERE ID = p_qco_rec.id;

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

2831: DELETE FROM OKL_TRX_QTE_CF_OBJECTS
2832: WHERE ID = p_qco_rec.id;
2833:
2834: x_return_status := l_return_status;
2835: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2836: EXCEPTION
2837: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2838: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2839: (

Line 2837: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2833:
2834: x_return_status := l_return_status;
2835: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2836: EXCEPTION
2837: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2838: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2839: (
2840: l_api_name,
2841: G_PKG_NAME,

Line 2838: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2834: x_return_status := l_return_status;
2835: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2836: EXCEPTION
2837: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2838: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2839: (
2840: l_api_name,
2841: G_PKG_NAME,
2842: 'OKL_API.G_RET_STS_ERROR',

Line 2842: 'OKL_API.G_RET_STS_ERROR',

2838: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2839: (
2840: l_api_name,
2841: G_PKG_NAME,
2842: 'OKL_API.G_RET_STS_ERROR',
2843: x_msg_count,
2844: x_msg_data,
2845: '_PVT'
2846: );

Line 2847: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2843: x_msg_count,
2844: x_msg_data,
2845: '_PVT'
2846: );
2847: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2848: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2849: (
2850: l_api_name,
2851: G_PKG_NAME,

Line 2848: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2844: x_msg_data,
2845: '_PVT'
2846: );
2847: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2848: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2849: (
2850: l_api_name,
2851: G_PKG_NAME,
2852: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2852: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2848: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2849: (
2850: l_api_name,
2851: G_PKG_NAME,
2852: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2853: x_msg_count,
2854: x_msg_data,
2855: '_PVT'
2856: );

Line 2858: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2854: x_msg_data,
2855: '_PVT'
2856: );
2857: WHEN OTHERS THEN
2858: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2859: (
2860: l_api_name,
2861: G_PKG_NAME,
2862: 'OTHERS',

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

2877: p_qcov_rec IN qcov_rec_type) IS
2878:
2879: l_api_version CONSTANT NUMBER := 1;
2880: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2881: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2882: l_qcov_rec qcov_rec_type := p_qcov_rec;
2883: l_qco_rec qco_rec_type;
2884: BEGIN
2885: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

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

2881: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2882: l_qcov_rec qcov_rec_type := p_qcov_rec;
2883: l_qco_rec qco_rec_type;
2884: BEGIN
2885: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2886: G_PKG_NAME,
2887: p_init_msg_list,
2888: l_api_version,
2889: p_api_version,

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

2888: l_api_version,
2889: p_api_version,
2890: 'PVT',
2891: x_return_status);
2892: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2894: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2895: RAISE OKL_API.G_EXCEPTION_ERROR;
2896: END IF;

Line 2893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2889: p_api_version,
2890: 'PVT',
2891: x_return_status);
2892: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2894: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2895: RAISE OKL_API.G_EXCEPTION_ERROR;
2896: END IF;
2897: -----------------------------------------

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

2890: 'PVT',
2891: x_return_status);
2892: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2894: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2895: RAISE OKL_API.G_EXCEPTION_ERROR;
2896: END IF;
2897: -----------------------------------------
2898: -- Move VIEW record to "Child" records --

Line 2895: RAISE OKL_API.G_EXCEPTION_ERROR;

2891: x_return_status);
2892: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2894: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2895: RAISE OKL_API.G_EXCEPTION_ERROR;
2896: END IF;
2897: -----------------------------------------
2898: -- Move VIEW record to "Child" records --
2899: -----------------------------------------

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

2907: x_msg_count,
2908: x_msg_data,
2909: l_qco_rec
2910: );
2911: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2912: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2913: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2914: RAISE OKL_API.G_EXCEPTION_ERROR;
2915: END IF;

Line 2912: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2908: x_msg_data,
2909: l_qco_rec
2910: );
2911: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2912: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2913: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2914: RAISE OKL_API.G_EXCEPTION_ERROR;
2915: END IF;
2916: x_return_status := l_return_status;

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

2909: l_qco_rec
2910: );
2911: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2912: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2913: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2914: RAISE OKL_API.G_EXCEPTION_ERROR;
2915: END IF;
2916: x_return_status := l_return_status;
2917: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2914: RAISE OKL_API.G_EXCEPTION_ERROR;

2910: );
2911: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2912: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2913: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2914: RAISE OKL_API.G_EXCEPTION_ERROR;
2915: END IF;
2916: x_return_status := l_return_status;
2917: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2918: EXCEPTION

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

2913: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2914: RAISE OKL_API.G_EXCEPTION_ERROR;
2915: END IF;
2916: x_return_status := l_return_status;
2917: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2918: EXCEPTION
2919: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2920: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2921: (

Line 2919: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2915: END IF;
2916: x_return_status := l_return_status;
2917: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2918: EXCEPTION
2919: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2920: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2921: (
2922: l_api_name,
2923: G_PKG_NAME,

Line 2920: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2916: x_return_status := l_return_status;
2917: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2918: EXCEPTION
2919: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2920: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2921: (
2922: l_api_name,
2923: G_PKG_NAME,
2924: 'OKL_API.G_RET_STS_ERROR',

Line 2924: 'OKL_API.G_RET_STS_ERROR',

2920: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2921: (
2922: l_api_name,
2923: G_PKG_NAME,
2924: 'OKL_API.G_RET_STS_ERROR',
2925: x_msg_count,
2926: x_msg_data,
2927: '_PVT'
2928: );

Line 2929: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2925: x_msg_count,
2926: x_msg_data,
2927: '_PVT'
2928: );
2929: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2930: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2931: (
2932: l_api_name,
2933: G_PKG_NAME,

Line 2930: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2926: x_msg_data,
2927: '_PVT'
2928: );
2929: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2930: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2931: (
2932: l_api_name,
2933: G_PKG_NAME,
2934: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2934: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2930: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2931: (
2932: l_api_name,
2933: G_PKG_NAME,
2934: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2935: x_msg_count,
2936: x_msg_data,
2937: '_PVT'
2938: );

Line 2940: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2936: x_msg_data,
2937: '_PVT'
2938: );
2939: WHEN OTHERS THEN
2940: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2941: (
2942: l_api_name,
2943: G_PKG_NAME,
2944: 'OTHERS',

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

2956: x_return_status OUT NOCOPY VARCHAR2,
2957: x_msg_count OUT NOCOPY NUMBER,
2958: x_msg_data OUT NOCOPY VARCHAR2,
2959: p_qcov_tbl IN qcov_tbl_type,
2960: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2961:
2962: l_api_version CONSTANT NUMBER := 1;
2963: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2964: i NUMBER := 0;

Line 2966: OKL_API.init_msg_list(p_init_msg_list);

2962: l_api_version CONSTANT NUMBER := 1;
2963: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2964: i NUMBER := 0;
2965: BEGIN
2966: OKL_API.init_msg_list(p_init_msg_list);
2967: -- Make sure PL/SQL table has records in it before passing
2968: IF (p_qcov_tbl.COUNT > 0) THEN
2969: i := p_qcov_tbl.FIRST;
2970: LOOP

Line 2972: l_error_rec OKL_API.ERROR_REC_TYPE;

2968: IF (p_qcov_tbl.COUNT > 0) THEN
2969: i := p_qcov_tbl.FIRST;
2970: LOOP
2971: DECLARE
2972: l_error_rec OKL_API.ERROR_REC_TYPE;
2973: BEGIN
2974: l_error_rec.api_name := l_api_name;
2975: l_error_rec.api_package := G_PKG_NAME;
2976: l_error_rec.idx := i;

Line 2979: p_init_msg_list => OKL_API.G_FALSE,

2975: l_error_rec.api_package := G_PKG_NAME;
2976: l_error_rec.idx := i;
2977: delete_row (
2978: p_api_version => p_api_version,
2979: p_init_msg_list => OKL_API.G_FALSE,
2980: x_return_status => l_error_rec.error_type,
2981: x_msg_count => l_error_rec.msg_count,
2982: x_msg_data => l_error_rec.msg_data,
2983: p_qcov_rec => p_qcov_tbl(i));

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

2980: x_return_status => l_error_rec.error_type,
2981: x_msg_count => l_error_rec.msg_count,
2982: x_msg_data => l_error_rec.msg_data,
2983: p_qcov_rec => p_qcov_tbl(i));
2984: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
2985: l_error_rec.sqlcode := SQLCODE;
2986: load_error_tbl(l_error_rec, px_error_tbl);
2987: ELSE
2988: x_msg_count := l_error_rec.msg_count;

Line 2992: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2988: x_msg_count := l_error_rec.msg_count;
2989: x_msg_data := l_error_rec.msg_data;
2990: END IF;
2991: EXCEPTION
2992: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2993: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2994: l_error_rec.sqlcode := SQLCODE;
2995: load_error_tbl(l_error_rec, px_error_tbl);
2996: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

2989: x_msg_data := l_error_rec.msg_data;
2990: END IF;
2991: EXCEPTION
2992: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2993: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2994: l_error_rec.sqlcode := SQLCODE;
2995: load_error_tbl(l_error_rec, px_error_tbl);
2996: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2997: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2996: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2992: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2993: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2994: l_error_rec.sqlcode := SQLCODE;
2995: load_error_tbl(l_error_rec, px_error_tbl);
2996: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2997: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2998: l_error_rec.sqlcode := SQLCODE;
2999: load_error_tbl(l_error_rec, px_error_tbl);
3000: WHEN OTHERS THEN

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

2993: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2994: l_error_rec.sqlcode := SQLCODE;
2995: load_error_tbl(l_error_rec, px_error_tbl);
2996: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2997: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2998: l_error_rec.sqlcode := SQLCODE;
2999: load_error_tbl(l_error_rec, px_error_tbl);
3000: WHEN OTHERS THEN
3001: l_error_rec.error_type := 'OTHERS';

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

3008: END IF;
3009: -- Loop through the error_tbl to find the error with the highest severity
3010: -- and return it.
3011: x_return_status := find_highest_exception(px_error_tbl);
3012: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3013: EXCEPTION
3014: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3015: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3016: (

Line 3014: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3010: -- and return it.
3011: x_return_status := find_highest_exception(px_error_tbl);
3012: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3013: EXCEPTION
3014: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3015: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3016: (
3017: l_api_name,
3018: G_PKG_NAME,

Line 3015: x_return_status := OKL_API.HANDLE_EXCEPTIONS

3011: x_return_status := find_highest_exception(px_error_tbl);
3012: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3013: EXCEPTION
3014: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3015: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3016: (
3017: l_api_name,
3018: G_PKG_NAME,
3019: 'OKL_API.G_RET_STS_ERROR',

Line 3019: 'OKL_API.G_RET_STS_ERROR',

3015: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3016: (
3017: l_api_name,
3018: G_PKG_NAME,
3019: 'OKL_API.G_RET_STS_ERROR',
3020: x_msg_count,
3021: x_msg_data,
3022: '_PVT'
3023: );

Line 3024: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3020: x_msg_count,
3021: x_msg_data,
3022: '_PVT'
3023: );
3024: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3025: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3026: (
3027: l_api_name,
3028: G_PKG_NAME,

Line 3025: x_return_status := OKL_API.HANDLE_EXCEPTIONS

3021: x_msg_data,
3022: '_PVT'
3023: );
3024: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3025: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3026: (
3027: l_api_name,
3028: G_PKG_NAME,
3029: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3029: 'OKL_API.G_RET_STS_UNEXP_ERROR',

3025: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3026: (
3027: l_api_name,
3028: G_PKG_NAME,
3029: 'OKL_API.G_RET_STS_UNEXP_ERROR',
3030: x_msg_count,
3031: x_msg_data,
3032: '_PVT'
3033: );

Line 3035: x_return_status := OKL_API.HANDLE_EXCEPTIONS

3031: x_msg_data,
3032: '_PVT'
3033: );
3034: WHEN OTHERS THEN
3035: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3036: (
3037: l_api_name,
3038: G_PKG_NAME,
3039: 'OTHERS',

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

3055: p_qcov_tbl IN qcov_tbl_type) IS
3056:
3057: l_api_version CONSTANT NUMBER := 1;
3058: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3059: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3060: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3061: BEGIN
3062: OKL_API.init_msg_list(p_init_msg_list);
3063: -- Make sure PL/SQL table has records in it before passing

Line 3060: l_error_tbl OKL_API.ERROR_TBL_TYPE;

3056:
3057: l_api_version CONSTANT NUMBER := 1;
3058: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3059: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3060: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3061: BEGIN
3062: OKL_API.init_msg_list(p_init_msg_list);
3063: -- Make sure PL/SQL table has records in it before passing
3064: IF (p_qcov_tbl.COUNT > 0) THEN

Line 3062: OKL_API.init_msg_list(p_init_msg_list);

3058: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3059: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3060: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3061: BEGIN
3062: OKL_API.init_msg_list(p_init_msg_list);
3063: -- Make sure PL/SQL table has records in it before passing
3064: IF (p_qcov_tbl.COUNT > 0) THEN
3065: delete_row (
3066: p_api_version => p_api_version,

Line 3067: p_init_msg_list => OKL_API.G_FALSE,

3063: -- Make sure PL/SQL table has records in it before passing
3064: IF (p_qcov_tbl.COUNT > 0) THEN
3065: delete_row (
3066: p_api_version => p_api_version,
3067: p_init_msg_list => OKL_API.G_FALSE,
3068: x_return_status => x_return_status,
3069: x_msg_count => x_msg_count,
3070: x_msg_data => x_msg_data,
3071: p_qcov_tbl => p_qcov_tbl,

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

3070: x_msg_data => x_msg_data,
3071: p_qcov_tbl => p_qcov_tbl,
3072: px_error_tbl => l_error_tbl);
3073: END IF;
3074: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3075: EXCEPTION
3076: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3077: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3078: (

Line 3076: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3072: px_error_tbl => l_error_tbl);
3073: END IF;
3074: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3075: EXCEPTION
3076: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3077: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3078: (
3079: l_api_name,
3080: G_PKG_NAME,

Line 3077: x_return_status := OKL_API.HANDLE_EXCEPTIONS

3073: END IF;
3074: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3075: EXCEPTION
3076: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3077: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3078: (
3079: l_api_name,
3080: G_PKG_NAME,
3081: 'OKL_API.G_RET_STS_ERROR',

Line 3081: 'OKL_API.G_RET_STS_ERROR',

3077: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3078: (
3079: l_api_name,
3080: G_PKG_NAME,
3081: 'OKL_API.G_RET_STS_ERROR',
3082: x_msg_count,
3083: x_msg_data,
3084: '_PVT'
3085: );

Line 3086: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3082: x_msg_count,
3083: x_msg_data,
3084: '_PVT'
3085: );
3086: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3087: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3088: (
3089: l_api_name,
3090: G_PKG_NAME,

Line 3087: x_return_status := OKL_API.HANDLE_EXCEPTIONS

3083: x_msg_data,
3084: '_PVT'
3085: );
3086: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3087: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3088: (
3089: l_api_name,
3090: G_PKG_NAME,
3091: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3091: 'OKL_API.G_RET_STS_UNEXP_ERROR',

3087: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3088: (
3089: l_api_name,
3090: G_PKG_NAME,
3091: 'OKL_API.G_RET_STS_UNEXP_ERROR',
3092: x_msg_count,
3093: x_msg_data,
3094: '_PVT'
3095: );

Line 3097: x_return_status := OKL_API.HANDLE_EXCEPTIONS

3093: x_msg_data,
3094: '_PVT'
3095: );
3096: WHEN OTHERS THEN
3097: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3098: (
3099: l_api_name,
3100: G_PKG_NAME,
3101: 'OTHERS',