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_CLL_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 42: p_error_tbl IN OKL_API.ERROR_TBL_TYPE

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

172: ) RETURN cllv_rec_type IS
173: l_cllv_rec cllv_rec_type;
174: l_row_notfound BOOLEAN := TRUE;
175: BEGIN
176: x_return_status := OKL_API.G_RET_STS_SUCCESS;
177: l_cllv_rec := get_rec(p_cllv_rec, l_row_notfound);
178: IF (l_row_notfound) THEN
179: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
180: x_return_status := OKL_API.G_RET_STS_ERROR;

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

175: BEGIN
176: x_return_status := OKL_API.G_RET_STS_SUCCESS;
177: l_cllv_rec := get_rec(p_cllv_rec, l_row_notfound);
178: IF (l_row_notfound) THEN
179: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
180: x_return_status := OKL_API.G_RET_STS_ERROR;
181: END IF;
182: RETURN(l_cllv_rec);
183: END get_rec;

Line 180: x_return_status := OKL_API.G_RET_STS_ERROR;

176: x_return_status := OKL_API.G_RET_STS_SUCCESS;
177: l_cllv_rec := get_rec(p_cllv_rec, l_row_notfound);
178: IF (l_row_notfound) THEN
179: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
180: x_return_status := OKL_API.G_RET_STS_ERROR;
181: END IF;
182: RETURN(l_cllv_rec);
183: END get_rec;
184: -----------------------------------------------------------

Line 277: x_return_status := OKL_API.G_RET_STS_SUCCESS;

273: ) RETURN okl_cntr_lvlng_lns_b_rec_type IS
274: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
275: l_row_notfound BOOLEAN := TRUE;
276: BEGIN
277: x_return_status := OKL_API.G_RET_STS_SUCCESS;
278: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_row_notfound);
279: IF (l_row_notfound) THEN
280: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
281: x_return_status := OKL_API.G_RET_STS_ERROR;

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

276: BEGIN
277: x_return_status := OKL_API.G_RET_STS_SUCCESS;
278: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_row_notfound);
279: IF (l_row_notfound) THEN
280: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
281: x_return_status := OKL_API.G_RET_STS_ERROR;
282: END IF;
283: RETURN(l_okl_cntr_lvlng_lns_b_rec);
284: END get_rec;

Line 281: x_return_status := OKL_API.G_RET_STS_ERROR;

277: x_return_status := OKL_API.G_RET_STS_SUCCESS;
278: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_row_notfound);
279: IF (l_row_notfound) THEN
280: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
281: x_return_status := OKL_API.G_RET_STS_ERROR;
282: END IF;
283: RETURN(l_okl_cntr_lvlng_lns_b_rec);
284: END get_rec;
285: -----------------------------------------------------------

Line 303: IF (l_cllv_rec.id = OKL_API.G_MISS_NUM ) THEN

299: p_cllv_rec IN cllv_rec_type
300: ) RETURN cllv_rec_type IS
301: l_cllv_rec cllv_rec_type := p_cllv_rec;
302: BEGIN
303: IF (l_cllv_rec.id = OKL_API.G_MISS_NUM ) THEN
304: l_cllv_rec.id := NULL;
305: END IF;
306: IF (l_cllv_rec.kle_id = OKL_API.G_MISS_NUM ) THEN
307: l_cllv_rec.kle_id := NULL;

Line 306: IF (l_cllv_rec.kle_id = OKL_API.G_MISS_NUM ) THEN

302: BEGIN
303: IF (l_cllv_rec.id = OKL_API.G_MISS_NUM ) THEN
304: l_cllv_rec.id := NULL;
305: END IF;
306: IF (l_cllv_rec.kle_id = OKL_API.G_MISS_NUM ) THEN
307: l_cllv_rec.kle_id := NULL;
308: END IF;
309: IF (l_cllv_rec.clg_id = OKL_API.G_MISS_NUM ) THEN
310: l_cllv_rec.clg_id := NULL;

Line 309: IF (l_cllv_rec.clg_id = OKL_API.G_MISS_NUM ) THEN

305: END IF;
306: IF (l_cllv_rec.kle_id = OKL_API.G_MISS_NUM ) THEN
307: l_cllv_rec.kle_id := NULL;
308: END IF;
309: IF (l_cllv_rec.clg_id = OKL_API.G_MISS_NUM ) THEN
310: l_cllv_rec.clg_id := NULL;
311: END IF;
312: IF (l_cllv_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
313: l_cllv_rec.object_version_number := NULL;

Line 312: IF (l_cllv_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN

308: END IF;
309: IF (l_cllv_rec.clg_id = OKL_API.G_MISS_NUM ) THEN
310: l_cllv_rec.clg_id := NULL;
311: END IF;
312: IF (l_cllv_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
313: l_cllv_rec.object_version_number := NULL;
314: END IF;
315: IF (l_cllv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
316: l_cllv_rec.attribute_category := NULL;

Line 315: IF (l_cllv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN

311: END IF;
312: IF (l_cllv_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
313: l_cllv_rec.object_version_number := NULL;
314: END IF;
315: IF (l_cllv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
316: l_cllv_rec.attribute_category := NULL;
317: END IF;
318: IF (l_cllv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
319: l_cllv_rec.attribute1 := NULL;

Line 318: IF (l_cllv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN

314: END IF;
315: IF (l_cllv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
316: l_cllv_rec.attribute_category := NULL;
317: END IF;
318: IF (l_cllv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
319: l_cllv_rec.attribute1 := NULL;
320: END IF;
321: IF (l_cllv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
322: l_cllv_rec.attribute2 := NULL;

Line 321: IF (l_cllv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN

317: END IF;
318: IF (l_cllv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
319: l_cllv_rec.attribute1 := NULL;
320: END IF;
321: IF (l_cllv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
322: l_cllv_rec.attribute2 := NULL;
323: END IF;
324: IF (l_cllv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
325: l_cllv_rec.attribute3 := NULL;

Line 324: IF (l_cllv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN

320: END IF;
321: IF (l_cllv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
322: l_cllv_rec.attribute2 := NULL;
323: END IF;
324: IF (l_cllv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
325: l_cllv_rec.attribute3 := NULL;
326: END IF;
327: IF (l_cllv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
328: l_cllv_rec.attribute4 := NULL;

Line 327: IF (l_cllv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN

323: END IF;
324: IF (l_cllv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
325: l_cllv_rec.attribute3 := NULL;
326: END IF;
327: IF (l_cllv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
328: l_cllv_rec.attribute4 := NULL;
329: END IF;
330: IF (l_cllv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
331: l_cllv_rec.attribute5 := NULL;

Line 330: IF (l_cllv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN

326: END IF;
327: IF (l_cllv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
328: l_cllv_rec.attribute4 := NULL;
329: END IF;
330: IF (l_cllv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
331: l_cllv_rec.attribute5 := NULL;
332: END IF;
333: IF (l_cllv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
334: l_cllv_rec.attribute6 := NULL;

Line 333: IF (l_cllv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN

329: END IF;
330: IF (l_cllv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
331: l_cllv_rec.attribute5 := NULL;
332: END IF;
333: IF (l_cllv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
334: l_cllv_rec.attribute6 := NULL;
335: END IF;
336: IF (l_cllv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
337: l_cllv_rec.attribute7 := NULL;

Line 336: IF (l_cllv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN

332: END IF;
333: IF (l_cllv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
334: l_cllv_rec.attribute6 := NULL;
335: END IF;
336: IF (l_cllv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
337: l_cllv_rec.attribute7 := NULL;
338: END IF;
339: IF (l_cllv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
340: l_cllv_rec.attribute8 := NULL;

Line 339: IF (l_cllv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN

335: END IF;
336: IF (l_cllv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
337: l_cllv_rec.attribute7 := NULL;
338: END IF;
339: IF (l_cllv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
340: l_cllv_rec.attribute8 := NULL;
341: END IF;
342: IF (l_cllv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
343: l_cllv_rec.attribute9 := NULL;

Line 342: IF (l_cllv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN

338: END IF;
339: IF (l_cllv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
340: l_cllv_rec.attribute8 := NULL;
341: END IF;
342: IF (l_cllv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
343: l_cllv_rec.attribute9 := NULL;
344: END IF;
345: IF (l_cllv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
346: l_cllv_rec.attribute10 := NULL;

Line 345: IF (l_cllv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN

341: END IF;
342: IF (l_cllv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
343: l_cllv_rec.attribute9 := NULL;
344: END IF;
345: IF (l_cllv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
346: l_cllv_rec.attribute10 := NULL;
347: END IF;
348: IF (l_cllv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
349: l_cllv_rec.attribute11 := NULL;

Line 348: IF (l_cllv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN

344: END IF;
345: IF (l_cllv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
346: l_cllv_rec.attribute10 := NULL;
347: END IF;
348: IF (l_cllv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
349: l_cllv_rec.attribute11 := NULL;
350: END IF;
351: IF (l_cllv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
352: l_cllv_rec.attribute12 := NULL;

Line 351: IF (l_cllv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN

347: END IF;
348: IF (l_cllv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
349: l_cllv_rec.attribute11 := NULL;
350: END IF;
351: IF (l_cllv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
352: l_cllv_rec.attribute12 := NULL;
353: END IF;
354: IF (l_cllv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
355: l_cllv_rec.attribute13 := NULL;

Line 354: IF (l_cllv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN

350: END IF;
351: IF (l_cllv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
352: l_cllv_rec.attribute12 := NULL;
353: END IF;
354: IF (l_cllv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
355: l_cllv_rec.attribute13 := NULL;
356: END IF;
357: IF (l_cllv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
358: l_cllv_rec.attribute14 := NULL;

Line 357: IF (l_cllv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN

353: END IF;
354: IF (l_cllv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
355: l_cllv_rec.attribute13 := NULL;
356: END IF;
357: IF (l_cllv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
358: l_cllv_rec.attribute14 := NULL;
359: END IF;
360: IF (l_cllv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
361: l_cllv_rec.attribute15 := NULL;

Line 360: IF (l_cllv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN

356: END IF;
357: IF (l_cllv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
358: l_cllv_rec.attribute14 := NULL;
359: END IF;
360: IF (l_cllv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
361: l_cllv_rec.attribute15 := NULL;
362: END IF;
363: IF (l_cllv_rec.created_by = OKL_API.G_MISS_NUM ) THEN
364: l_cllv_rec.created_by := NULL;

Line 363: IF (l_cllv_rec.created_by = OKL_API.G_MISS_NUM ) THEN

359: END IF;
360: IF (l_cllv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
361: l_cllv_rec.attribute15 := NULL;
362: END IF;
363: IF (l_cllv_rec.created_by = OKL_API.G_MISS_NUM ) THEN
364: l_cllv_rec.created_by := NULL;
365: END IF;
366: IF (l_cllv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
367: l_cllv_rec.creation_date := NULL;

Line 366: IF (l_cllv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN

362: END IF;
363: IF (l_cllv_rec.created_by = OKL_API.G_MISS_NUM ) THEN
364: l_cllv_rec.created_by := NULL;
365: END IF;
366: IF (l_cllv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
367: l_cllv_rec.creation_date := NULL;
368: END IF;
369: IF (l_cllv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
370: l_cllv_rec.last_updated_by := NULL;

Line 369: IF (l_cllv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN

365: END IF;
366: IF (l_cllv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
367: l_cllv_rec.creation_date := NULL;
368: END IF;
369: IF (l_cllv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
370: l_cllv_rec.last_updated_by := NULL;
371: END IF;
372: IF (l_cllv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
373: l_cllv_rec.last_update_date := NULL;

Line 372: IF (l_cllv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN

368: END IF;
369: IF (l_cllv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
370: l_cllv_rec.last_updated_by := NULL;
371: END IF;
372: IF (l_cllv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
373: l_cllv_rec.last_update_date := NULL;
374: END IF;
375: IF (l_cllv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
376: l_cllv_rec.last_update_login := NULL;

Line 375: IF (l_cllv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN

371: END IF;
372: IF (l_cllv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
373: l_cllv_rec.last_update_date := NULL;
374: END IF;
375: IF (l_cllv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
376: l_cllv_rec.last_update_login := NULL;
377: END IF;
378: RETURN(l_cllv_rec);
379: END null_out_defaults;

Line 388: x_return_status := OKL_API.G_RET_STS_SUCCESS;

384: PROCEDURE validate_id(
385: x_return_status OUT NOCOPY VARCHAR2,
386: p_id IN NUMBER) IS
387: BEGIN
388: x_return_status := OKL_API.G_RET_STS_SUCCESS;
389: IF (p_id = OKL_API.G_MISS_NUM OR
390: p_id IS NULL)
391: THEN
392: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Counter');

Line 389: IF (p_id = OKL_API.G_MISS_NUM OR

385: x_return_status OUT NOCOPY VARCHAR2,
386: p_id IN NUMBER) IS
387: BEGIN
388: x_return_status := OKL_API.G_RET_STS_SUCCESS;
389: IF (p_id = OKL_API.G_MISS_NUM OR
390: p_id IS NULL)
391: THEN
392: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Counter');
393: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 392: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Counter');

388: x_return_status := OKL_API.G_RET_STS_SUCCESS;
389: IF (p_id = OKL_API.G_MISS_NUM OR
390: p_id IS NULL)
391: THEN
392: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Counter');
393: x_return_status := OKL_API.G_RET_STS_ERROR;
394: RAISE G_EXCEPTION_HALT_VALIDATION;
395: END IF;
396: EXCEPTION

Line 393: x_return_status := OKL_API.G_RET_STS_ERROR;

389: IF (p_id = OKL_API.G_MISS_NUM OR
390: p_id IS NULL)
391: THEN
392: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Counter');
393: x_return_status := OKL_API.G_RET_STS_ERROR;
394: RAISE G_EXCEPTION_HALT_VALIDATION;
395: END IF;
396: EXCEPTION
397: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 400: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

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

Line 406: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

402: ,p_token1 => G_SQLCODE_TOKEN
403: ,p_token1_value => SQLCODE
404: ,p_token2 => G_SQLERRM_TOKEN
405: ,p_token2_value => SQLERRM);
406: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
407: END validate_id;
408: -------------------------------------
409: -- Validate_Attributes for: KLE_ID --
410: -------------------------------------

Line 415: x_return_status := OKL_API.G_RET_STS_SUCCESS;

411: PROCEDURE validate_kle_id(
412: x_return_status OUT NOCOPY VARCHAR2,
413: p_kle_id IN NUMBER) IS
414: BEGIN
415: x_return_status := OKL_API.G_RET_STS_SUCCESS;
416: IF (p_kle_id = OKL_API.G_MISS_NUM OR
417: p_kle_id IS NULL)
418: THEN
419: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Counter');

Line 416: IF (p_kle_id = OKL_API.G_MISS_NUM OR

412: x_return_status OUT NOCOPY VARCHAR2,
413: p_kle_id IN NUMBER) IS
414: BEGIN
415: x_return_status := OKL_API.G_RET_STS_SUCCESS;
416: IF (p_kle_id = OKL_API.G_MISS_NUM OR
417: p_kle_id IS NULL)
418: THEN
419: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Counter');
420: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 419: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Counter');

415: x_return_status := OKL_API.G_RET_STS_SUCCESS;
416: IF (p_kle_id = OKL_API.G_MISS_NUM OR
417: p_kle_id IS NULL)
418: THEN
419: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Counter');
420: x_return_status := OKL_API.G_RET_STS_ERROR;
421: RAISE G_EXCEPTION_HALT_VALIDATION;
422: END IF;
423: EXCEPTION

Line 420: x_return_status := OKL_API.G_RET_STS_ERROR;

416: IF (p_kle_id = OKL_API.G_MISS_NUM OR
417: p_kle_id IS NULL)
418: THEN
419: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Counter');
420: x_return_status := OKL_API.G_RET_STS_ERROR;
421: RAISE G_EXCEPTION_HALT_VALIDATION;
422: END IF;
423: EXCEPTION
424: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 427: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

423: EXCEPTION
424: WHEN G_EXCEPTION_HALT_VALIDATION THEN
425: null;
426: WHEN OTHERS THEN
427: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
428: ,p_msg_name => G_UNEXPECTED_ERROR
429: ,p_token1 => G_SQLCODE_TOKEN
430: ,p_token1_value => SQLCODE
431: ,p_token2 => G_SQLERRM_TOKEN

Line 433: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

429: ,p_token1 => G_SQLCODE_TOKEN
430: ,p_token1_value => SQLCODE
431: ,p_token2 => G_SQLERRM_TOKEN
432: ,p_token2_value => SQLERRM);
433: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
434: END validate_kle_id;
435: -------------------------------------
436: -- Validate_Attributes for: CLG_ID --
437: -------------------------------------

Line 442: x_return_status := OKL_API.G_RET_STS_SUCCESS;

438: PROCEDURE validate_clg_id(
439: x_return_status OUT NOCOPY VARCHAR2,
440: p_clg_id IN NUMBER) IS
441: BEGIN
442: x_return_status := OKL_API.G_RET_STS_SUCCESS;
443: IF (p_clg_id = OKL_API.G_MISS_NUM OR
444: p_clg_id IS NULL)
445: THEN
446: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'clg_id');

Line 443: IF (p_clg_id = OKL_API.G_MISS_NUM OR

439: x_return_status OUT NOCOPY VARCHAR2,
440: p_clg_id IN NUMBER) IS
441: BEGIN
442: x_return_status := OKL_API.G_RET_STS_SUCCESS;
443: IF (p_clg_id = OKL_API.G_MISS_NUM OR
444: p_clg_id IS NULL)
445: THEN
446: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'clg_id');
447: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 446: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'clg_id');

442: x_return_status := OKL_API.G_RET_STS_SUCCESS;
443: IF (p_clg_id = OKL_API.G_MISS_NUM OR
444: p_clg_id IS NULL)
445: THEN
446: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'clg_id');
447: x_return_status := OKL_API.G_RET_STS_ERROR;
448: RAISE G_EXCEPTION_HALT_VALIDATION;
449: END IF;
450: EXCEPTION

Line 447: x_return_status := OKL_API.G_RET_STS_ERROR;

443: IF (p_clg_id = OKL_API.G_MISS_NUM OR
444: p_clg_id IS NULL)
445: THEN
446: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'clg_id');
447: x_return_status := OKL_API.G_RET_STS_ERROR;
448: RAISE G_EXCEPTION_HALT_VALIDATION;
449: END IF;
450: EXCEPTION
451: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 454: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

450: EXCEPTION
451: WHEN G_EXCEPTION_HALT_VALIDATION THEN
452: null;
453: WHEN OTHERS THEN
454: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
455: ,p_msg_name => G_UNEXPECTED_ERROR
456: ,p_token1 => G_SQLCODE_TOKEN
457: ,p_token1_value => SQLCODE
458: ,p_token2 => G_SQLERRM_TOKEN

Line 460: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

456: ,p_token1 => G_SQLCODE_TOKEN
457: ,p_token1_value => SQLCODE
458: ,p_token2 => G_SQLERRM_TOKEN
459: ,p_token2_value => SQLERRM);
460: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
461: END validate_clg_id;
462: ----------------------------------------------------
463: -- Validate_Attributes for: OBJECT_VERSION_NUMBER --
464: ----------------------------------------------------

Line 469: x_return_status := OKL_API.G_RET_STS_SUCCESS;

465: PROCEDURE validate_object_version_number(
466: x_return_status OUT NOCOPY VARCHAR2,
467: p_object_version_number IN NUMBER) IS
468: BEGIN
469: x_return_status := OKL_API.G_RET_STS_SUCCESS;
470: IF (p_object_version_number = OKL_API.G_MISS_NUM OR
471: p_object_version_number IS NULL)
472: THEN
473: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');

Line 470: IF (p_object_version_number = OKL_API.G_MISS_NUM OR

466: x_return_status OUT NOCOPY VARCHAR2,
467: p_object_version_number IN NUMBER) IS
468: BEGIN
469: x_return_status := OKL_API.G_RET_STS_SUCCESS;
470: IF (p_object_version_number = OKL_API.G_MISS_NUM OR
471: p_object_version_number IS NULL)
472: THEN
473: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
474: x_return_status := OKL_API.G_RET_STS_ERROR;

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

469: x_return_status := OKL_API.G_RET_STS_SUCCESS;
470: IF (p_object_version_number = OKL_API.G_MISS_NUM OR
471: p_object_version_number IS NULL)
472: THEN
473: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
474: x_return_status := OKL_API.G_RET_STS_ERROR;
475: RAISE G_EXCEPTION_HALT_VALIDATION;
476: END IF;
477: EXCEPTION

Line 474: x_return_status := OKL_API.G_RET_STS_ERROR;

470: IF (p_object_version_number = OKL_API.G_MISS_NUM OR
471: p_object_version_number IS NULL)
472: THEN
473: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
474: x_return_status := OKL_API.G_RET_STS_ERROR;
475: RAISE G_EXCEPTION_HALT_VALIDATION;
476: END IF;
477: EXCEPTION
478: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 481: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

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

Line 487: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

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

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

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

Line 509: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

505: -- id
506: -- ***
507: validate_id(x_return_status, p_cllv_rec.id);
508: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
509: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
510: l_return_status := x_return_status;
511: END IF;
512: END IF;
513:

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

514: -- ***
515: -- kle_id
516: -- ***
517: validate_kle_id(x_return_status, p_cllv_rec.kle_id);
518: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
519: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
520: l_return_status := x_return_status;
521: END IF;
522: END IF;

Line 519: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

515: -- kle_id
516: -- ***
517: validate_kle_id(x_return_status, p_cllv_rec.kle_id);
518: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
519: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
520: l_return_status := x_return_status;
521: END IF;
522: END IF;
523:

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

523:
524: -- ***
525: -- clg_id
526: -- ***
527: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
528: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
529: l_return_status := x_return_status;
530: END IF;
531: END IF;

Line 528: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

524: -- ***
525: -- clg_id
526: -- ***
527: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
528: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
529: l_return_status := x_return_status;
530: END IF;
531: END IF;
532:

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

533: -- ***
534: -- object_version_number
535: -- ***
536: validate_object_version_number(x_return_status, p_cllv_rec.object_version_number);
537: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
538: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
539: l_return_status := x_return_status;
540: END IF;
541: END IF;

Line 538: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

534: -- object_version_number
535: -- ***
536: validate_object_version_number(x_return_status, p_cllv_rec.object_version_number);
537: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
538: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
539: l_return_status := x_return_status;
540: END IF;
541: END IF;
542:

Line 548: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

544: EXCEPTION
545: WHEN G_EXCEPTION_HALT_VALIDATION THEN
546: RETURN(l_return_status);
547: WHEN OTHERS THEN
548: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
549: ,p_msg_name => G_UNEXPECTED_ERROR
550: ,p_token1 => G_SQLCODE_TOKEN
551: ,p_token1_value => SQLCODE
552: ,p_token2 => G_SQLERRM_TOKEN

Line 554: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

550: ,p_token1 => G_SQLCODE_TOKEN
551: ,p_token1_value => SQLCODE
552: ,p_token2 => G_SQLERRM_TOKEN
553: ,p_token2_value => SQLERRM);
554: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
555: RETURN(l_return_status);
556: END Validate_Attributes;
557: ---------------------------------------------------------------------------
558: -- PROCEDURE Validate_Record

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

563: FUNCTION Validate_Record (
564: p_cllv_rec IN cllv_rec_type,
565: p_db_cllv_rec IN cllv_rec_type
566: ) RETURN VARCHAR2 IS
567: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
568: ------------------------------------
569: -- FUNCTION validate_foreign_keys --
570: ------------------------------------
571: FUNCTION validate_foreign_keys (

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

584: FROM Okl_K_Lines
585: WHERE okl_k_lines.id = p_id;
586: l_okl_cllv_kle_fk okl_cllv_kle_fk_csr%ROWTYPE;
587:
588: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
589: l_row_notfound BOOLEAN := TRUE;
590: BEGIN
591: /* IF ((p_cllv_rec.KLE_ID IS NOT NULL)
592: AND

Line 600: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'KLE_ID');

596: FETCH okl_cllv_kle_fk_csr INTO l_okl_cllv_kle_fk;
597: l_row_notfound := okl_cllv_kle_fk_csr%NOTFOUND;
598: CLOSE okl_cllv_kle_fk_csr;
599: IF (l_row_notfound) THEN
600: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'KLE_ID');
601: RAISE item_not_found_error;
602: END IF;
603: END IF;
604: */ IF ((p_cllv_rec.CLG_ID IS NOT NULL)

Line 613: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CLG_ID');

609: FETCH okl_cllv_clg_fk_csr INTO l_okl_cllv_clg_fk;
610: l_row_notfound := okl_cllv_clg_fk_csr%NOTFOUND;
611: CLOSE okl_cllv_clg_fk_csr;
612: IF (l_row_notfound) THEN
613: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CLG_ID');
614: RAISE item_not_found_error;
615: END IF;
616: END IF;
617: RETURN (l_return_status);

Line 620: l_return_status := OKL_API.G_RET_STS_ERROR;

616: END IF;
617: RETURN (l_return_status);
618: EXCEPTION
619: WHEN item_not_found_error THEN
620: l_return_status := OKL_API.G_RET_STS_ERROR;
621: RETURN (l_return_status);
622: END validate_foreign_keys;
623: BEGIN
624: l_return_status := validate_foreign_keys(p_cllv_rec, p_db_cllv_rec);

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

626: END Validate_Record;
627: FUNCTION Validate_Record (
628: p_cllv_rec IN cllv_rec_type
629: ) RETURN VARCHAR2 IS
630: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
631: l_db_cllv_rec cllv_rec_type := get_rec(p_cllv_rec);
632: BEGIN
633: l_return_status := Validate_Record(p_cllv_rec => p_cllv_rec,
634: p_db_cllv_rec => l_db_cllv_rec);

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

715: p_cllv_rec IN cllv_rec_type) IS
716:
717: l_api_version CONSTANT NUMBER := 1;
718: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
719: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
720: l_cllv_rec cllv_rec_type := p_cllv_rec;
721: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
722: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
723: BEGIN

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

720: l_cllv_rec cllv_rec_type := p_cllv_rec;
721: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
722: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
723: BEGIN
724: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
725: G_PKG_NAME,
726: p_init_msg_list,
727: l_api_version,
728: p_api_version,

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

727: l_api_version,
728: p_api_version,
729: '_PVT',
730: x_return_status);
731: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
732: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
734: RAISE OKL_API.G_EXCEPTION_ERROR;
735: END IF;

Line 732: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

728: p_api_version,
729: '_PVT',
730: x_return_status);
731: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
732: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
734: RAISE OKL_API.G_EXCEPTION_ERROR;
735: END IF;
736: --- Validate all non-missing attributes (Item Level Validation)

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

729: '_PVT',
730: x_return_status);
731: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
732: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
734: RAISE OKL_API.G_EXCEPTION_ERROR;
735: END IF;
736: --- Validate all non-missing attributes (Item Level Validation)
737: l_return_status := Validate_Attributes(l_cllv_rec);

Line 734: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

735: END IF;
736: --- Validate all non-missing attributes (Item Level Validation)
737: l_return_status := Validate_Attributes(l_cllv_rec);
738: --- If any errors happen abort API
739: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
740: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
741: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
742: RAISE OKL_API.G_EXCEPTION_ERROR;
743: END IF;

Line 740: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

736: --- Validate all non-missing attributes (Item Level Validation)
737: l_return_status := Validate_Attributes(l_cllv_rec);
738: --- If any errors happen abort API
739: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
740: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
741: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
742: RAISE OKL_API.G_EXCEPTION_ERROR;
743: END IF;
744: l_return_status := Validate_Record(l_cllv_rec);

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

737: l_return_status := Validate_Attributes(l_cllv_rec);
738: --- If any errors happen abort API
739: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
740: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
741: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
742: RAISE OKL_API.G_EXCEPTION_ERROR;
743: END IF;
744: l_return_status := Validate_Record(l_cllv_rec);
745: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 742: RAISE OKL_API.G_EXCEPTION_ERROR;

738: --- If any errors happen abort API
739: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
740: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
741: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
742: RAISE OKL_API.G_EXCEPTION_ERROR;
743: END IF;
744: l_return_status := Validate_Record(l_cllv_rec);
745: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
746: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

741: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
742: RAISE OKL_API.G_EXCEPTION_ERROR;
743: END IF;
744: l_return_status := Validate_Record(l_cllv_rec);
745: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
746: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
747: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
748: RAISE OKL_API.G_EXCEPTION_ERROR;
749: END IF;

Line 746: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

742: RAISE OKL_API.G_EXCEPTION_ERROR;
743: END IF;
744: l_return_status := Validate_Record(l_cllv_rec);
745: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
746: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
747: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
748: RAISE OKL_API.G_EXCEPTION_ERROR;
749: END IF;
750: x_return_status := l_return_status;

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

743: END IF;
744: l_return_status := Validate_Record(l_cllv_rec);
745: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
746: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
747: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
748: RAISE OKL_API.G_EXCEPTION_ERROR;
749: END IF;
750: x_return_status := l_return_status;
751: EXCEPTION

Line 748: RAISE OKL_API.G_EXCEPTION_ERROR;

744: l_return_status := Validate_Record(l_cllv_rec);
745: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
746: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
747: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
748: RAISE OKL_API.G_EXCEPTION_ERROR;
749: END IF;
750: x_return_status := l_return_status;
751: EXCEPTION
752: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 752: WHEN OKL_API.G_EXCEPTION_ERROR THEN

748: RAISE OKL_API.G_EXCEPTION_ERROR;
749: END IF;
750: x_return_status := l_return_status;
751: EXCEPTION
752: WHEN OKL_API.G_EXCEPTION_ERROR THEN
753: x_return_status := OKL_API.HANDLE_EXCEPTIONS
754: (
755: l_api_name,
756: G_PKG_NAME,

Line 753: x_return_status := OKL_API.HANDLE_EXCEPTIONS

749: END IF;
750: x_return_status := l_return_status;
751: EXCEPTION
752: WHEN OKL_API.G_EXCEPTION_ERROR THEN
753: x_return_status := OKL_API.HANDLE_EXCEPTIONS
754: (
755: l_api_name,
756: G_PKG_NAME,
757: 'OKL_API.G_RET_STS_ERROR',

Line 757: 'OKL_API.G_RET_STS_ERROR',

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

Line 762: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 763: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 767: 'OKL_API.G_RET_STS_UNEXP_ERROR',

763: x_return_status := OKL_API.HANDLE_EXCEPTIONS
764: (
765: l_api_name,
766: G_PKG_NAME,
767: 'OKL_API.G_RET_STS_UNEXP_ERROR',
768: x_msg_count,
769: x_msg_data,
770: '_PVT'
771: );

Line 773: x_return_status := OKL_API.HANDLE_EXCEPTIONS

769: x_msg_data,
770: '_PVT'
771: );
772: WHEN OTHERS THEN
773: x_return_status := OKL_API.HANDLE_EXCEPTIONS
774: (
775: l_api_name,
776: G_PKG_NAME,
777: 'OTHERS',

Line 788: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

784: -- PL/SQL TBL validate_row for:OKL_CNTR_LVLNG_LNS_V --
785: ------------------------------------------------------
786: PROCEDURE validate_row(
787: p_api_version IN NUMBER,
788: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
789: x_return_status OUT NOCOPY VARCHAR2,
790: x_msg_count OUT NOCOPY NUMBER,
791: x_msg_data OUT NOCOPY VARCHAR2,
792: p_cllv_tbl IN cllv_tbl_type,

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

789: x_return_status OUT NOCOPY VARCHAR2,
790: x_msg_count OUT NOCOPY NUMBER,
791: x_msg_data OUT NOCOPY VARCHAR2,
792: p_cllv_tbl IN cllv_tbl_type,
793: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
794:
795: l_api_version CONSTANT NUMBER := 1;
796: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
797: i NUMBER := 0;

Line 799: OKL_API.init_msg_list(p_init_msg_list);

795: l_api_version CONSTANT NUMBER := 1;
796: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
797: i NUMBER := 0;
798: BEGIN
799: OKL_API.init_msg_list(p_init_msg_list);
800: -- Make sure PL/SQL table has records in it before passing
801: IF (p_cllv_tbl.COUNT > 0) THEN
802: i := p_cllv_tbl.FIRST;
803: LOOP

Line 805: l_error_rec OKL_API.ERROR_REC_TYPE;

801: IF (p_cllv_tbl.COUNT > 0) THEN
802: i := p_cllv_tbl.FIRST;
803: LOOP
804: DECLARE
805: l_error_rec OKL_API.ERROR_REC_TYPE;
806: BEGIN
807: l_error_rec.api_name := l_api_name;
808: l_error_rec.api_package := G_PKG_NAME;
809: l_error_rec.idx := i;

Line 812: p_init_msg_list => OKL_API.G_FALSE,

808: l_error_rec.api_package := G_PKG_NAME;
809: l_error_rec.idx := i;
810: validate_row (
811: p_api_version => p_api_version,
812: p_init_msg_list => OKL_API.G_FALSE,
813: x_return_status => l_error_rec.error_type,
814: x_msg_count => l_error_rec.msg_count,
815: x_msg_data => l_error_rec.msg_data,
816: p_cllv_rec => p_cllv_tbl(i));

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

813: x_return_status => l_error_rec.error_type,
814: x_msg_count => l_error_rec.msg_count,
815: x_msg_data => l_error_rec.msg_data,
816: p_cllv_rec => p_cllv_tbl(i));
817: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
818: l_error_rec.sqlcode := SQLCODE;
819: load_error_tbl(l_error_rec, px_error_tbl);
820: ELSE
821: x_msg_count := l_error_rec.msg_count;

Line 825: WHEN OKL_API.G_EXCEPTION_ERROR THEN

821: x_msg_count := l_error_rec.msg_count;
822: x_msg_data := l_error_rec.msg_data;
823: END IF;
824: EXCEPTION
825: WHEN OKL_API.G_EXCEPTION_ERROR THEN
826: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
827: l_error_rec.sqlcode := SQLCODE;
828: load_error_tbl(l_error_rec, px_error_tbl);
829: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

822: x_msg_data := l_error_rec.msg_data;
823: END IF;
824: EXCEPTION
825: WHEN OKL_API.G_EXCEPTION_ERROR THEN
826: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
827: l_error_rec.sqlcode := SQLCODE;
828: load_error_tbl(l_error_rec, px_error_tbl);
829: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
830: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 829: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

825: WHEN OKL_API.G_EXCEPTION_ERROR THEN
826: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
827: l_error_rec.sqlcode := SQLCODE;
828: load_error_tbl(l_error_rec, px_error_tbl);
829: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
830: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
831: l_error_rec.sqlcode := SQLCODE;
832: load_error_tbl(l_error_rec, px_error_tbl);
833: WHEN OTHERS THEN

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

826: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
827: l_error_rec.sqlcode := SQLCODE;
828: load_error_tbl(l_error_rec, px_error_tbl);
829: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
830: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
831: l_error_rec.sqlcode := SQLCODE;
832: load_error_tbl(l_error_rec, px_error_tbl);
833: WHEN OTHERS THEN
834: l_error_rec.error_type := 'OTHERS';

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

841: END IF;
842: -- Loop through the error_tbl to find the error with the highest severity
843: -- and return it.
844: x_return_status := find_highest_exception(px_error_tbl);
845: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
846: EXCEPTION
847: WHEN OKL_API.G_EXCEPTION_ERROR THEN
848: x_return_status := OKL_API.HANDLE_EXCEPTIONS
849: (

Line 847: WHEN OKL_API.G_EXCEPTION_ERROR THEN

843: -- and return it.
844: x_return_status := find_highest_exception(px_error_tbl);
845: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
846: EXCEPTION
847: WHEN OKL_API.G_EXCEPTION_ERROR THEN
848: x_return_status := OKL_API.HANDLE_EXCEPTIONS
849: (
850: l_api_name,
851: G_PKG_NAME,

Line 848: x_return_status := OKL_API.HANDLE_EXCEPTIONS

844: x_return_status := find_highest_exception(px_error_tbl);
845: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
846: EXCEPTION
847: WHEN OKL_API.G_EXCEPTION_ERROR THEN
848: x_return_status := OKL_API.HANDLE_EXCEPTIONS
849: (
850: l_api_name,
851: G_PKG_NAME,
852: 'OKL_API.G_RET_STS_ERROR',

Line 852: 'OKL_API.G_RET_STS_ERROR',

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

Line 857: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 858: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 862: 'OKL_API.G_RET_STS_UNEXP_ERROR',

858: x_return_status := OKL_API.HANDLE_EXCEPTIONS
859: (
860: l_api_name,
861: G_PKG_NAME,
862: 'OKL_API.G_RET_STS_UNEXP_ERROR',
863: x_msg_count,
864: x_msg_data,
865: '_PVT'
866: );

Line 868: x_return_status := OKL_API.HANDLE_EXCEPTIONS

864: x_msg_data,
865: '_PVT'
866: );
867: WHEN OTHERS THEN
868: x_return_status := OKL_API.HANDLE_EXCEPTIONS
869: (
870: l_api_name,
871: G_PKG_NAME,
872: 'OTHERS',

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

888: p_cllv_tbl IN cllv_tbl_type) IS
889:
890: l_api_version CONSTANT NUMBER := 1;
891: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
892: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
893: l_error_tbl OKL_API.ERROR_TBL_TYPE;
894: BEGIN
895: OKL_API.init_msg_list(p_init_msg_list);
896: -- Make sure PL/SQL table has records in it before passing

Line 893: l_error_tbl OKL_API.ERROR_TBL_TYPE;

889:
890: l_api_version CONSTANT NUMBER := 1;
891: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
892: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
893: l_error_tbl OKL_API.ERROR_TBL_TYPE;
894: BEGIN
895: OKL_API.init_msg_list(p_init_msg_list);
896: -- Make sure PL/SQL table has records in it before passing
897: IF (p_cllv_tbl.COUNT > 0) THEN

Line 895: OKL_API.init_msg_list(p_init_msg_list);

891: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
892: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
893: l_error_tbl OKL_API.ERROR_TBL_TYPE;
894: BEGIN
895: OKL_API.init_msg_list(p_init_msg_list);
896: -- Make sure PL/SQL table has records in it before passing
897: IF (p_cllv_tbl.COUNT > 0) THEN
898: validate_row (
899: p_api_version => p_api_version,

Line 900: p_init_msg_list => OKL_API.G_FALSE,

896: -- Make sure PL/SQL table has records in it before passing
897: IF (p_cllv_tbl.COUNT > 0) THEN
898: validate_row (
899: p_api_version => p_api_version,
900: p_init_msg_list => OKL_API.G_FALSE,
901: x_return_status => x_return_status,
902: x_msg_count => x_msg_count,
903: x_msg_data => x_msg_data,
904: p_cllv_tbl => p_cllv_tbl,

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

903: x_msg_data => x_msg_data,
904: p_cllv_tbl => p_cllv_tbl,
905: px_error_tbl => l_error_tbl);
906: END IF;
907: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
908: EXCEPTION
909: WHEN OKL_API.G_EXCEPTION_ERROR THEN
910: x_return_status := OKL_API.HANDLE_EXCEPTIONS
911: (

Line 909: WHEN OKL_API.G_EXCEPTION_ERROR THEN

905: px_error_tbl => l_error_tbl);
906: END IF;
907: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
908: EXCEPTION
909: WHEN OKL_API.G_EXCEPTION_ERROR THEN
910: x_return_status := OKL_API.HANDLE_EXCEPTIONS
911: (
912: l_api_name,
913: G_PKG_NAME,

Line 910: x_return_status := OKL_API.HANDLE_EXCEPTIONS

906: END IF;
907: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
908: EXCEPTION
909: WHEN OKL_API.G_EXCEPTION_ERROR THEN
910: x_return_status := OKL_API.HANDLE_EXCEPTIONS
911: (
912: l_api_name,
913: G_PKG_NAME,
914: 'OKL_API.G_RET_STS_ERROR',

Line 914: 'OKL_API.G_RET_STS_ERROR',

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

Line 919: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 920: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 924: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 930: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 948: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

944: -----------------------------------------
945: -- insert_row for:OKL_CNTR_LVLNG_LNS_B --
946: -----------------------------------------
947: PROCEDURE insert_row(
948: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
949: x_return_status OUT NOCOPY VARCHAR2,
950: x_msg_count OUT NOCOPY NUMBER,
951: x_msg_data OUT NOCOPY VARCHAR2,
952: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,

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

953: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type) IS
954:
955: l_api_version CONSTANT NUMBER := 1;
956: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
957: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
958: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
959: l_def_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
960: ---------------------------------------------
961: -- Set_Attributes for:OKL_CNTR_LVLNG_LNS_B --

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

963: FUNCTION Set_Attributes (
964: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
965: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
966: ) RETURN VARCHAR2 IS
967: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
968: BEGIN
969: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
970: RETURN(l_return_status);
971: END Set_Attributes;

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

969: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
970: RETURN(l_return_status);
971: END Set_Attributes;
972: BEGIN
973: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
974: p_init_msg_list,
975: '_PVT',
976: x_return_status);
977: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

973: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
974: p_init_msg_list,
975: '_PVT',
976: x_return_status);
977: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
978: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
979: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
980: RAISE OKL_API.G_EXCEPTION_ERROR;
981: END IF;

Line 978: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

974: p_init_msg_list,
975: '_PVT',
976: x_return_status);
977: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
978: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
979: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
980: RAISE OKL_API.G_EXCEPTION_ERROR;
981: END IF;
982: --- Setting item atributes

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

975: '_PVT',
976: x_return_status);
977: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
978: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
979: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
980: RAISE OKL_API.G_EXCEPTION_ERROR;
981: END IF;
982: --- Setting item atributes
983: l_return_status := Set_Attributes(

Line 980: RAISE OKL_API.G_EXCEPTION_ERROR;

976: x_return_status);
977: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
978: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
979: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
980: RAISE OKL_API.G_EXCEPTION_ERROR;
981: END IF;
982: --- Setting item atributes
983: l_return_status := Set_Attributes(
984: p_okl_cntr_lvlng_lns_b_rec, -- IN

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

983: l_return_status := Set_Attributes(
984: p_okl_cntr_lvlng_lns_b_rec, -- IN
985: l_okl_cntr_lvlng_lns_b_rec); -- OUT
986: --- If any errors happen abort API
987: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_ERROR;
991: END IF;

Line 988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

984: p_okl_cntr_lvlng_lns_b_rec, -- IN
985: l_okl_cntr_lvlng_lns_b_rec); -- OUT
986: --- If any errors happen abort API
987: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_ERROR;
991: END IF;
992: INSERT INTO OKL_CNTR_LVLNG_LNS_B(

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

985: l_okl_cntr_lvlng_lns_b_rec); -- OUT
986: --- If any errors happen abort API
987: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_ERROR;
991: END IF;
992: INSERT INTO OKL_CNTR_LVLNG_LNS_B(
993: id,

Line 990: RAISE OKL_API.G_EXCEPTION_ERROR;

986: --- If any errors happen abort API
987: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_ERROR;
991: END IF;
992: INSERT INTO OKL_CNTR_LVLNG_LNS_B(
993: id,
994: kle_id,

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

1043: l_okl_cntr_lvlng_lns_b_rec.last_update_login);
1044: -- Set OUT values
1045: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1046: x_return_status := l_return_status;
1047: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1048: EXCEPTION
1049: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1050: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1051: (

Line 1049: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1045: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1046: x_return_status := l_return_status;
1047: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1048: EXCEPTION
1049: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1050: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1051: (
1052: l_api_name,
1053: G_PKG_NAME,

Line 1050: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1054: 'OKL_API.G_RET_STS_ERROR',

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

Line 1059: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1060: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1064: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1070: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1090: x_cllv_rec OUT NOCOPY cllv_rec_type) IS
1091:
1092: l_api_version CONSTANT NUMBER := 1;
1093: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1094: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1095: l_cllv_rec cllv_rec_type := p_cllv_rec;
1096: l_def_cllv_rec cllv_rec_type;
1097: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1098: lx_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;

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

1117: FUNCTION Set_Attributes (
1118: p_cllv_rec IN cllv_rec_type,
1119: x_cllv_rec OUT NOCOPY cllv_rec_type
1120: ) RETURN VARCHAR2 IS
1121: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1122: BEGIN
1123: x_cllv_rec := p_cllv_rec;
1124: x_cllv_rec.OBJECT_VERSION_NUMBER := 1;
1125: RETURN(l_return_status);

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

1124: x_cllv_rec.OBJECT_VERSION_NUMBER := 1;
1125: RETURN(l_return_status);
1126: END Set_Attributes;
1127: BEGIN
1128: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1129: G_PKG_NAME,
1130: p_init_msg_list,
1131: l_api_version,
1132: p_api_version,

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

1131: l_api_version,
1132: p_api_version,
1133: '_PVT',
1134: x_return_status);
1135: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1136: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1137: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1138: RAISE OKL_API.G_EXCEPTION_ERROR;
1139: END IF;

Line 1136: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1132: p_api_version,
1133: '_PVT',
1134: x_return_status);
1135: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1136: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1137: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1138: RAISE OKL_API.G_EXCEPTION_ERROR;
1139: END IF;
1140: l_cllv_rec := null_out_defaults(p_cllv_rec);

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

1133: '_PVT',
1134: x_return_status);
1135: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1136: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1137: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1138: RAISE OKL_API.G_EXCEPTION_ERROR;
1139: END IF;
1140: l_cllv_rec := null_out_defaults(p_cllv_rec);
1141: -- Set primary key value

Line 1138: RAISE OKL_API.G_EXCEPTION_ERROR;

1134: x_return_status);
1135: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1136: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1137: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1138: RAISE OKL_API.G_EXCEPTION_ERROR;
1139: END IF;
1140: l_cllv_rec := null_out_defaults(p_cllv_rec);
1141: -- Set primary key value
1142: l_cllv_rec.ID := get_seq_id;

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

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

Line 1149: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1145: l_cllv_rec, -- IN
1146: l_def_cllv_rec); -- OUT
1147: --- If any errors happen abort API
1148: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1149: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1150: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1151: RAISE OKL_API.G_EXCEPTION_ERROR;
1152: END IF;
1153: l_def_cllv_rec := fill_who_columns(l_def_cllv_rec);

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

1146: l_def_cllv_rec); -- OUT
1147: --- If any errors happen abort API
1148: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1149: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1150: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1151: RAISE OKL_API.G_EXCEPTION_ERROR;
1152: END IF;
1153: l_def_cllv_rec := fill_who_columns(l_def_cllv_rec);
1154: --- Validate all non-missing attributes (Item Level Validation)

Line 1151: RAISE OKL_API.G_EXCEPTION_ERROR;

1147: --- If any errors happen abort API
1148: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1149: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1150: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1151: RAISE OKL_API.G_EXCEPTION_ERROR;
1152: END IF;
1153: l_def_cllv_rec := fill_who_columns(l_def_cllv_rec);
1154: --- Validate all non-missing attributes (Item Level Validation)
1155: l_return_status := Validate_Attributes(l_def_cllv_rec);

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

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

Line 1158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

1155: l_return_status := Validate_Attributes(l_def_cllv_rec);
1156: --- If any errors happen abort API
1157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1160: RAISE OKL_API.G_EXCEPTION_ERROR;
1161: END IF;
1162: l_return_status := Validate_Record(l_def_cllv_rec);
1163: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1160: RAISE OKL_API.G_EXCEPTION_ERROR;

1156: --- If any errors happen abort API
1157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1160: RAISE OKL_API.G_EXCEPTION_ERROR;
1161: END IF;
1162: l_return_status := Validate_Record(l_def_cllv_rec);
1163: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1164: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1160: RAISE OKL_API.G_EXCEPTION_ERROR;
1161: END IF;
1162: l_return_status := Validate_Record(l_def_cllv_rec);
1163: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1164: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1165: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1166: RAISE OKL_API.G_EXCEPTION_ERROR;
1167: END IF;

Line 1164: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1160: RAISE OKL_API.G_EXCEPTION_ERROR;
1161: END IF;
1162: l_return_status := Validate_Record(l_def_cllv_rec);
1163: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1164: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1165: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1166: RAISE OKL_API.G_EXCEPTION_ERROR;
1167: END IF;
1168: -----------------------------------------

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

1161: END IF;
1162: l_return_status := Validate_Record(l_def_cllv_rec);
1163: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1164: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1165: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1166: RAISE OKL_API.G_EXCEPTION_ERROR;
1167: END IF;
1168: -----------------------------------------
1169: -- Move VIEW record to "Child" records --

Line 1166: RAISE OKL_API.G_EXCEPTION_ERROR;

1162: l_return_status := Validate_Record(l_def_cllv_rec);
1163: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1164: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1165: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1166: RAISE OKL_API.G_EXCEPTION_ERROR;
1167: END IF;
1168: -----------------------------------------
1169: -- Move VIEW record to "Child" records --
1170: -----------------------------------------

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

1179: x_msg_data,
1180: l_okl_cntr_lvlng_lns_b_rec,
1181: lx_okl_cntr_lvlng_lns_b_rec
1182: );
1183: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_ERROR;
1187: END IF;

Line 1184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1180: l_okl_cntr_lvlng_lns_b_rec,
1181: lx_okl_cntr_lvlng_lns_b_rec
1182: );
1183: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_ERROR;
1187: END IF;
1188: migrate(lx_okl_cntr_lvlng_lns_b_rec, l_def_cllv_rec);

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

1181: lx_okl_cntr_lvlng_lns_b_rec
1182: );
1183: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_ERROR;
1187: END IF;
1188: migrate(lx_okl_cntr_lvlng_lns_b_rec, l_def_cllv_rec);
1189: -- Set OUT values

Line 1186: RAISE OKL_API.G_EXCEPTION_ERROR;

1182: );
1183: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_ERROR;
1187: END IF;
1188: migrate(lx_okl_cntr_lvlng_lns_b_rec, l_def_cllv_rec);
1189: -- Set OUT values
1190: x_cllv_rec := l_def_cllv_rec;

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

1188: migrate(lx_okl_cntr_lvlng_lns_b_rec, l_def_cllv_rec);
1189: -- Set OUT values
1190: x_cllv_rec := l_def_cllv_rec;
1191: x_return_status := l_return_status;
1192: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1193: EXCEPTION
1194: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1195: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1196: (

Line 1194: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1190: x_cllv_rec := l_def_cllv_rec;
1191: x_return_status := l_return_status;
1192: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1193: EXCEPTION
1194: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1195: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1196: (
1197: l_api_name,
1198: G_PKG_NAME,

Line 1195: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1199: 'OKL_API.G_RET_STS_ERROR',

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

Line 1204: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1205: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1209: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1215: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1230: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1226: -- PL/SQL TBL insert_row for:CLLV_TBL --
1227: ----------------------------------------
1228: PROCEDURE insert_row(
1229: p_api_version IN NUMBER,
1230: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1231: x_return_status OUT NOCOPY VARCHAR2,
1232: x_msg_count OUT NOCOPY NUMBER,
1233: x_msg_data OUT NOCOPY VARCHAR2,
1234: p_cllv_tbl IN cllv_tbl_type,

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

1232: x_msg_count OUT NOCOPY NUMBER,
1233: x_msg_data OUT NOCOPY VARCHAR2,
1234: p_cllv_tbl IN cllv_tbl_type,
1235: x_cllv_tbl OUT NOCOPY cllv_tbl_type,
1236: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1237:
1238: l_api_version CONSTANT NUMBER := 1;
1239: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1240: i NUMBER := 0;

Line 1242: OKL_API.init_msg_list(p_init_msg_list);

1238: l_api_version CONSTANT NUMBER := 1;
1239: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1240: i NUMBER := 0;
1241: BEGIN
1242: OKL_API.init_msg_list(p_init_msg_list);
1243: -- Make sure PL/SQL table has records in it before passing
1244: IF (p_cllv_tbl.COUNT > 0) THEN
1245: i := p_cllv_tbl.FIRST;
1246: LOOP

Line 1248: l_error_rec OKL_API.ERROR_REC_TYPE;

1244: IF (p_cllv_tbl.COUNT > 0) THEN
1245: i := p_cllv_tbl.FIRST;
1246: LOOP
1247: DECLARE
1248: l_error_rec OKL_API.ERROR_REC_TYPE;
1249: BEGIN
1250: l_error_rec.api_name := l_api_name;
1251: l_error_rec.api_package := G_PKG_NAME;
1252: l_error_rec.idx := i;

Line 1255: p_init_msg_list => OKL_API.G_FALSE,

1251: l_error_rec.api_package := G_PKG_NAME;
1252: l_error_rec.idx := i;
1253: insert_row (
1254: p_api_version => p_api_version,
1255: p_init_msg_list => OKL_API.G_FALSE,
1256: x_return_status => l_error_rec.error_type,
1257: x_msg_count => l_error_rec.msg_count,
1258: x_msg_data => l_error_rec.msg_data,
1259: p_cllv_rec => p_cllv_tbl(i),

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

1257: x_msg_count => l_error_rec.msg_count,
1258: x_msg_data => l_error_rec.msg_data,
1259: p_cllv_rec => p_cllv_tbl(i),
1260: x_cllv_rec => x_cllv_tbl(i));
1261: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
1262: l_error_rec.sqlcode := SQLCODE;
1263: load_error_tbl(l_error_rec, px_error_tbl);
1264: ELSE
1265: x_msg_count := l_error_rec.msg_count;

Line 1269: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1265: x_msg_count := l_error_rec.msg_count;
1266: x_msg_data := l_error_rec.msg_data;
1267: END IF;
1268: EXCEPTION
1269: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1270: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1271: l_error_rec.sqlcode := SQLCODE;
1272: load_error_tbl(l_error_rec, px_error_tbl);
1273: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

1266: x_msg_data := l_error_rec.msg_data;
1267: END IF;
1268: EXCEPTION
1269: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1270: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1271: l_error_rec.sqlcode := SQLCODE;
1272: load_error_tbl(l_error_rec, px_error_tbl);
1273: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1274: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1273: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1269: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1270: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1271: l_error_rec.sqlcode := SQLCODE;
1272: load_error_tbl(l_error_rec, px_error_tbl);
1273: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1274: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1275: l_error_rec.sqlcode := SQLCODE;
1276: load_error_tbl(l_error_rec, px_error_tbl);
1277: WHEN OTHERS THEN

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

1270: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1271: l_error_rec.sqlcode := SQLCODE;
1272: load_error_tbl(l_error_rec, px_error_tbl);
1273: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1274: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1275: l_error_rec.sqlcode := SQLCODE;
1276: load_error_tbl(l_error_rec, px_error_tbl);
1277: WHEN OTHERS THEN
1278: l_error_rec.error_type := 'OTHERS';

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

1285: END IF;
1286: -- Loop through the error_tbl to find the error with the highest severity
1287: -- and return it.
1288: x_return_status := find_highest_exception(px_error_tbl);
1289: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1290: EXCEPTION
1291: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1292: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1293: (

Line 1291: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1287: -- and return it.
1288: x_return_status := find_highest_exception(px_error_tbl);
1289: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1290: EXCEPTION
1291: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1292: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1293: (
1294: l_api_name,
1295: G_PKG_NAME,

Line 1292: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1288: x_return_status := find_highest_exception(px_error_tbl);
1289: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1290: EXCEPTION
1291: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1292: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1293: (
1294: l_api_name,
1295: G_PKG_NAME,
1296: 'OKL_API.G_RET_STS_ERROR',

Line 1296: 'OKL_API.G_RET_STS_ERROR',

1292: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1293: (
1294: l_api_name,
1295: G_PKG_NAME,
1296: 'OKL_API.G_RET_STS_ERROR',
1297: x_msg_count,
1298: x_msg_data,
1299: '_PVT'
1300: );

Line 1301: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1297: x_msg_count,
1298: x_msg_data,
1299: '_PVT'
1300: );
1301: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1302: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1303: (
1304: l_api_name,
1305: G_PKG_NAME,

Line 1302: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1298: x_msg_data,
1299: '_PVT'
1300: );
1301: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1302: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1303: (
1304: l_api_name,
1305: G_PKG_NAME,
1306: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1306: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1312: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1333: x_cllv_tbl OUT NOCOPY cllv_tbl_type) IS
1334:
1335: l_api_version CONSTANT NUMBER := 1;
1336: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1337: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1338: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1339: BEGIN
1340: OKL_API.init_msg_list(p_init_msg_list);
1341: -- Make sure PL/SQL table has records in it before passing

Line 1338: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1334:
1335: l_api_version CONSTANT NUMBER := 1;
1336: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1337: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1338: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1339: BEGIN
1340: OKL_API.init_msg_list(p_init_msg_list);
1341: -- Make sure PL/SQL table has records in it before passing
1342: IF (p_cllv_tbl.COUNT > 0) THEN

Line 1340: OKL_API.init_msg_list(p_init_msg_list);

1336: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1337: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1338: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1339: BEGIN
1340: OKL_API.init_msg_list(p_init_msg_list);
1341: -- Make sure PL/SQL table has records in it before passing
1342: IF (p_cllv_tbl.COUNT > 0) THEN
1343: insert_row (
1344: p_api_version => p_api_version,

Line 1345: p_init_msg_list => OKL_API.G_FALSE,

1341: -- Make sure PL/SQL table has records in it before passing
1342: IF (p_cllv_tbl.COUNT > 0) THEN
1343: insert_row (
1344: p_api_version => p_api_version,
1345: p_init_msg_list => OKL_API.G_FALSE,
1346: x_return_status => x_return_status,
1347: x_msg_count => x_msg_count,
1348: x_msg_data => x_msg_data,
1349: p_cllv_tbl => p_cllv_tbl,

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

1349: p_cllv_tbl => p_cllv_tbl,
1350: x_cllv_tbl => x_cllv_tbl,
1351: px_error_tbl => l_error_tbl);
1352: END IF;
1353: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1354: EXCEPTION
1355: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1356: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1357: (

Line 1355: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1351: px_error_tbl => l_error_tbl);
1352: END IF;
1353: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1354: EXCEPTION
1355: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1356: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1357: (
1358: l_api_name,
1359: G_PKG_NAME,

Line 1356: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1352: END IF;
1353: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1354: EXCEPTION
1355: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1356: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1357: (
1358: l_api_name,
1359: G_PKG_NAME,
1360: 'OKL_API.G_RET_STS_ERROR',

Line 1360: 'OKL_API.G_RET_STS_ERROR',

1356: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1357: (
1358: l_api_name,
1359: G_PKG_NAME,
1360: 'OKL_API.G_RET_STS_ERROR',
1361: x_msg_count,
1362: x_msg_data,
1363: '_PVT'
1364: );

Line 1365: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1361: x_msg_count,
1362: x_msg_data,
1363: '_PVT'
1364: );
1365: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1366: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1367: (
1368: l_api_name,
1369: G_PKG_NAME,

Line 1366: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1362: x_msg_data,
1363: '_PVT'
1364: );
1365: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1366: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1367: (
1368: l_api_name,
1369: G_PKG_NAME,
1370: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1370: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1376: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1394: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1390: ---------------------------------------
1391: -- lock_row for:OKL_CNTR_LVLNG_LNS_B --
1392: ---------------------------------------
1393: PROCEDURE lock_row(
1394: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1395: x_return_status OUT NOCOPY VARCHAR2,
1396: x_msg_count OUT NOCOPY NUMBER,
1397: x_msg_data OUT NOCOPY VARCHAR2,
1398: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS

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

1411: FROM OKL_CNTR_LVLNG_LNS_B
1412: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id;
1413: l_api_version CONSTANT NUMBER := 1;
1414: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1415: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1416: l_object_version_number OKL_CNTR_LVLNG_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
1417: lc_object_version_number OKL_CNTR_LVLNG_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
1418: l_row_notfound BOOLEAN := FALSE;
1419: lc_row_notfound BOOLEAN := FALSE;

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

1417: lc_object_version_number OKL_CNTR_LVLNG_LNS_B.OBJECT_VERSION_NUMBER%TYPE;
1418: l_row_notfound BOOLEAN := FALSE;
1419: lc_row_notfound BOOLEAN := FALSE;
1420: BEGIN
1421: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1422: p_init_msg_list,
1423: '_PVT',
1424: x_return_status);
1425: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1421: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1422: p_init_msg_list,
1423: '_PVT',
1424: x_return_status);
1425: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1426: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1427: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1428: RAISE OKL_API.G_EXCEPTION_ERROR;
1429: END IF;

Line 1426: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1422: p_init_msg_list,
1423: '_PVT',
1424: x_return_status);
1425: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1426: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1427: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1428: RAISE OKL_API.G_EXCEPTION_ERROR;
1429: END IF;
1430: BEGIN

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

1423: '_PVT',
1424: x_return_status);
1425: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1426: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1427: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1428: RAISE OKL_API.G_EXCEPTION_ERROR;
1429: END IF;
1430: BEGIN
1431: OPEN lock_csr(p_okl_cntr_lvlng_lns_b_rec);

Line 1428: RAISE OKL_API.G_EXCEPTION_ERROR;

1424: x_return_status);
1425: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1426: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1427: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1428: RAISE OKL_API.G_EXCEPTION_ERROR;
1429: END IF;
1430: BEGIN
1431: OPEN lock_csr(p_okl_cntr_lvlng_lns_b_rec);
1432: FETCH lock_csr INTO l_object_version_number;

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

1436: WHEN E_Resource_Busy THEN
1437: IF (lock_csr%ISOPEN) THEN
1438: CLOSE lock_csr;
1439: END IF;
1440: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1441: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1442: END;
1443:
1444: IF ( l_row_notfound ) THEN

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

1447: lc_row_notfound := lchk_csr%NOTFOUND;
1448: CLOSE lchk_csr;
1449: END IF;
1450: IF (lc_row_notfound) THEN
1451: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1452: RAISE OKL_API.G_EXCEPTION_ERROR;
1453: ELSIF lc_object_version_number > p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1454: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1455: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1452: RAISE OKL_API.G_EXCEPTION_ERROR;

1448: CLOSE lchk_csr;
1449: END IF;
1450: IF (lc_row_notfound) THEN
1451: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1452: RAISE OKL_API.G_EXCEPTION_ERROR;
1453: ELSIF lc_object_version_number > p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1454: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1455: RAISE OKL_API.G_EXCEPTION_ERROR;
1456: ELSIF lc_object_version_number <> p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN

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

1450: IF (lc_row_notfound) THEN
1451: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1452: RAISE OKL_API.G_EXCEPTION_ERROR;
1453: ELSIF lc_object_version_number > p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1454: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1455: RAISE OKL_API.G_EXCEPTION_ERROR;
1456: ELSIF lc_object_version_number <> p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1457: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1458: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1455: RAISE OKL_API.G_EXCEPTION_ERROR;

1451: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1452: RAISE OKL_API.G_EXCEPTION_ERROR;
1453: ELSIF lc_object_version_number > p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1454: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1455: RAISE OKL_API.G_EXCEPTION_ERROR;
1456: ELSIF lc_object_version_number <> p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1457: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1458: RAISE OKL_API.G_EXCEPTION_ERROR;
1459: ELSIF lc_object_version_number = -1 THEN

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

1453: ELSIF lc_object_version_number > p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1454: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1455: RAISE OKL_API.G_EXCEPTION_ERROR;
1456: ELSIF lc_object_version_number <> p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1457: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1458: RAISE OKL_API.G_EXCEPTION_ERROR;
1459: ELSIF lc_object_version_number = -1 THEN
1460: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1461: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1458: RAISE OKL_API.G_EXCEPTION_ERROR;

1454: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1455: RAISE OKL_API.G_EXCEPTION_ERROR;
1456: ELSIF lc_object_version_number <> p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1457: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1458: RAISE OKL_API.G_EXCEPTION_ERROR;
1459: ELSIF lc_object_version_number = -1 THEN
1460: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1461: RAISE OKL_API.G_EXCEPTION_ERROR;
1462: END IF;

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

1456: ELSIF lc_object_version_number <> p_okl_cntr_lvlng_lns_b_rec.object_version_number THEN
1457: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1458: RAISE OKL_API.G_EXCEPTION_ERROR;
1459: ELSIF lc_object_version_number = -1 THEN
1460: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1461: RAISE OKL_API.G_EXCEPTION_ERROR;
1462: END IF;
1463: x_return_status := l_return_status;
1464: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1461: RAISE OKL_API.G_EXCEPTION_ERROR;

1457: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1458: RAISE OKL_API.G_EXCEPTION_ERROR;
1459: ELSIF lc_object_version_number = -1 THEN
1460: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1461: RAISE OKL_API.G_EXCEPTION_ERROR;
1462: END IF;
1463: x_return_status := l_return_status;
1464: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1465: EXCEPTION

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

1460: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1461: RAISE OKL_API.G_EXCEPTION_ERROR;
1462: END IF;
1463: x_return_status := l_return_status;
1464: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1465: EXCEPTION
1466: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1467: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1468: (

Line 1466: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1462: END IF;
1463: x_return_status := l_return_status;
1464: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1465: EXCEPTION
1466: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1467: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1468: (
1469: l_api_name,
1470: G_PKG_NAME,

Line 1467: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1463: x_return_status := l_return_status;
1464: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1465: EXCEPTION
1466: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1467: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1468: (
1469: l_api_name,
1470: G_PKG_NAME,
1471: 'OKL_API.G_RET_STS_ERROR',

Line 1471: 'OKL_API.G_RET_STS_ERROR',

1467: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1468: (
1469: l_api_name,
1470: G_PKG_NAME,
1471: 'OKL_API.G_RET_STS_ERROR',
1472: x_msg_count,
1473: x_msg_data,
1474: '_PVT'
1475: );

Line 1476: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1472: x_msg_count,
1473: x_msg_data,
1474: '_PVT'
1475: );
1476: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1477: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1478: (
1479: l_api_name,
1480: G_PKG_NAME,

Line 1477: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1473: x_msg_data,
1474: '_PVT'
1475: );
1476: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1477: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1478: (
1479: l_api_name,
1480: G_PKG_NAME,
1481: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1481: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1487: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1506: p_cllv_rec IN cllv_rec_type) IS
1507:
1508: l_api_version CONSTANT NUMBER := 1;
1509: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1510: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1511: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1512: BEGIN
1513: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1514: G_PKG_NAME,

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

1509: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1510: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1511: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1512: BEGIN
1513: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1514: G_PKG_NAME,
1515: p_init_msg_list,
1516: l_api_version,
1517: p_api_version,

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

1516: l_api_version,
1517: p_api_version,
1518: '_PVT',
1519: x_return_status);
1520: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1522: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_ERROR;
1524: END IF;

Line 1521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1517: p_api_version,
1518: '_PVT',
1519: x_return_status);
1520: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1522: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_ERROR;
1524: END IF;
1525: -----------------------------------------

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

1518: '_PVT',
1519: x_return_status);
1520: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1522: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_ERROR;
1524: END IF;
1525: -----------------------------------------
1526: -- Move VIEW record to "Child" records --

Line 1523: RAISE OKL_API.G_EXCEPTION_ERROR;

1519: x_return_status);
1520: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1522: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_ERROR;
1524: END IF;
1525: -----------------------------------------
1526: -- Move VIEW record to "Child" records --
1527: -----------------------------------------

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

1535: x_msg_count,
1536: x_msg_data,
1537: l_okl_cntr_lvlng_lns_b_rec
1538: );
1539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1542: RAISE OKL_API.G_EXCEPTION_ERROR;
1543: END IF;

Line 1540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1536: x_msg_data,
1537: l_okl_cntr_lvlng_lns_b_rec
1538: );
1539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1542: RAISE OKL_API.G_EXCEPTION_ERROR;
1543: END IF;
1544: x_return_status := l_return_status;

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

1537: l_okl_cntr_lvlng_lns_b_rec
1538: );
1539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1542: RAISE OKL_API.G_EXCEPTION_ERROR;
1543: END IF;
1544: x_return_status := l_return_status;
1545: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1542: RAISE OKL_API.G_EXCEPTION_ERROR;

1538: );
1539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1542: RAISE OKL_API.G_EXCEPTION_ERROR;
1543: END IF;
1544: x_return_status := l_return_status;
1545: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1546: EXCEPTION

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

1541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1542: RAISE OKL_API.G_EXCEPTION_ERROR;
1543: END IF;
1544: x_return_status := l_return_status;
1545: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1546: EXCEPTION
1547: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1548: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1549: (

Line 1547: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 1548: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1552: 'OKL_API.G_RET_STS_ERROR',

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

Line 1557: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1558: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1562: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1568: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1583: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1579: -- PL/SQL TBL lock_row for:CLLV_TBL --
1580: --------------------------------------
1581: PROCEDURE lock_row(
1582: p_api_version IN NUMBER,
1583: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1584: x_return_status OUT NOCOPY VARCHAR2,
1585: x_msg_count OUT NOCOPY NUMBER,
1586: x_msg_data OUT NOCOPY VARCHAR2,
1587: p_cllv_tbl IN cllv_tbl_type,

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

1584: x_return_status OUT NOCOPY VARCHAR2,
1585: x_msg_count OUT NOCOPY NUMBER,
1586: x_msg_data OUT NOCOPY VARCHAR2,
1587: p_cllv_tbl IN cllv_tbl_type,
1588: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1589:
1590: l_api_version CONSTANT NUMBER := 1;
1591: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1592: i NUMBER := 0;

Line 1594: OKL_API.init_msg_list(p_init_msg_list);

1590: l_api_version CONSTANT NUMBER := 1;
1591: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1592: i NUMBER := 0;
1593: BEGIN
1594: OKL_API.init_msg_list(p_init_msg_list);
1595: -- Make sure PL/SQL table has recrods in it before passing
1596: IF (p_cllv_tbl.COUNT > 0) THEN
1597: i := p_cllv_tbl.FIRST;
1598: LOOP

Line 1600: l_error_rec OKL_API.ERROR_REC_TYPE;

1596: IF (p_cllv_tbl.COUNT > 0) THEN
1597: i := p_cllv_tbl.FIRST;
1598: LOOP
1599: DECLARE
1600: l_error_rec OKL_API.ERROR_REC_TYPE;
1601: BEGIN
1602: l_error_rec.api_name := l_api_name;
1603: l_error_rec.api_package := G_PKG_NAME;
1604: l_error_rec.idx := i;

Line 1607: p_init_msg_list => OKL_API.G_FALSE,

1603: l_error_rec.api_package := G_PKG_NAME;
1604: l_error_rec.idx := i;
1605: lock_row(
1606: p_api_version => p_api_version,
1607: p_init_msg_list => OKL_API.G_FALSE,
1608: x_return_status => l_error_rec.error_type,
1609: x_msg_count => l_error_rec.msg_count,
1610: x_msg_data => l_error_rec.msg_data,
1611: p_cllv_rec => p_cllv_tbl(i));

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

1608: x_return_status => l_error_rec.error_type,
1609: x_msg_count => l_error_rec.msg_count,
1610: x_msg_data => l_error_rec.msg_data,
1611: p_cllv_rec => p_cllv_tbl(i));
1612: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
1613: l_error_rec.sqlcode := SQLCODE;
1614: load_error_tbl(l_error_rec, px_error_tbl);
1615: ELSE
1616: x_msg_count := l_error_rec.msg_count;

Line 1620: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1616: x_msg_count := l_error_rec.msg_count;
1617: x_msg_data := l_error_rec.msg_data;
1618: END IF;
1619: EXCEPTION
1620: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1621: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1622: l_error_rec.sqlcode := SQLCODE;
1623: load_error_tbl(l_error_rec, px_error_tbl);
1624: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

1617: x_msg_data := l_error_rec.msg_data;
1618: END IF;
1619: EXCEPTION
1620: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1621: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1622: l_error_rec.sqlcode := SQLCODE;
1623: load_error_tbl(l_error_rec, px_error_tbl);
1624: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1625: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1624: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1620: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1621: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1622: l_error_rec.sqlcode := SQLCODE;
1623: load_error_tbl(l_error_rec, px_error_tbl);
1624: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1625: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1626: l_error_rec.sqlcode := SQLCODE;
1627: load_error_tbl(l_error_rec, px_error_tbl);
1628: WHEN OTHERS THEN

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

1621: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1622: l_error_rec.sqlcode := SQLCODE;
1623: load_error_tbl(l_error_rec, px_error_tbl);
1624: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1625: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1626: l_error_rec.sqlcode := SQLCODE;
1627: load_error_tbl(l_error_rec, px_error_tbl);
1628: WHEN OTHERS THEN
1629: l_error_rec.error_type := 'OTHERS';

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

1636: END IF;
1637: -- Loop through the error_tbl to find the error with the highest severity
1638: -- and return it.
1639: x_return_status := find_highest_exception(px_error_tbl);
1640: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1641: EXCEPTION
1642: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1643: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1644: (

Line 1642: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1638: -- and return it.
1639: x_return_status := find_highest_exception(px_error_tbl);
1640: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1641: EXCEPTION
1642: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1643: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1644: (
1645: l_api_name,
1646: G_PKG_NAME,

Line 1643: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1639: x_return_status := find_highest_exception(px_error_tbl);
1640: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1641: EXCEPTION
1642: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1643: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1644: (
1645: l_api_name,
1646: G_PKG_NAME,
1647: 'OKL_API.G_RET_STS_ERROR',

Line 1647: 'OKL_API.G_RET_STS_ERROR',

1643: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1644: (
1645: l_api_name,
1646: G_PKG_NAME,
1647: 'OKL_API.G_RET_STS_ERROR',
1648: x_msg_count,
1649: x_msg_data,
1650: '_PVT'
1651: );

Line 1652: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1648: x_msg_count,
1649: x_msg_data,
1650: '_PVT'
1651: );
1652: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1653: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1654: (
1655: l_api_name,
1656: G_PKG_NAME,

Line 1653: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1649: x_msg_data,
1650: '_PVT'
1651: );
1652: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1653: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1654: (
1655: l_api_name,
1656: G_PKG_NAME,
1657: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1657: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1663: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1682: p_cllv_tbl IN cllv_tbl_type) IS
1683:
1684: l_api_version CONSTANT NUMBER := 1;
1685: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1686: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1687: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1688: BEGIN
1689: OKL_API.init_msg_list(p_init_msg_list);
1690: -- Make sure PL/SQL table has recrods in it before passing

Line 1687: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1683:
1684: l_api_version CONSTANT NUMBER := 1;
1685: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1686: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1687: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1688: BEGIN
1689: OKL_API.init_msg_list(p_init_msg_list);
1690: -- Make sure PL/SQL table has recrods in it before passing
1691: IF (p_cllv_tbl.COUNT > 0) THEN

Line 1689: OKL_API.init_msg_list(p_init_msg_list);

1685: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1686: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1687: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1688: BEGIN
1689: OKL_API.init_msg_list(p_init_msg_list);
1690: -- Make sure PL/SQL table has recrods in it before passing
1691: IF (p_cllv_tbl.COUNT > 0) THEN
1692: lock_row(
1693: p_api_version => p_api_version,

Line 1694: p_init_msg_list => OKL_API.G_FALSE,

1690: -- Make sure PL/SQL table has recrods in it before passing
1691: IF (p_cllv_tbl.COUNT > 0) THEN
1692: lock_row(
1693: p_api_version => p_api_version,
1694: p_init_msg_list => OKL_API.G_FALSE,
1695: x_return_status => x_return_status,
1696: x_msg_count => x_msg_count,
1697: x_msg_data => x_msg_data,
1698: p_cllv_tbl => p_cllv_tbl,

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

1697: x_msg_data => x_msg_data,
1698: p_cllv_tbl => p_cllv_tbl,
1699: px_error_tbl => l_error_tbl);
1700: END IF;
1701: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1702: EXCEPTION
1703: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1704: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1705: (

Line 1703: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1699: px_error_tbl => l_error_tbl);
1700: END IF;
1701: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1702: EXCEPTION
1703: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1704: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1705: (
1706: l_api_name,
1707: G_PKG_NAME,

Line 1704: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1700: END IF;
1701: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1702: EXCEPTION
1703: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1704: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1705: (
1706: l_api_name,
1707: G_PKG_NAME,
1708: 'OKL_API.G_RET_STS_ERROR',

Line 1708: 'OKL_API.G_RET_STS_ERROR',

1704: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1705: (
1706: l_api_name,
1707: G_PKG_NAME,
1708: 'OKL_API.G_RET_STS_ERROR',
1709: x_msg_count,
1710: x_msg_data,
1711: '_PVT'
1712: );

Line 1713: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1709: x_msg_count,
1710: x_msg_data,
1711: '_PVT'
1712: );
1713: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1714: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1715: (
1716: l_api_name,
1717: G_PKG_NAME,

Line 1714: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1710: x_msg_data,
1711: '_PVT'
1712: );
1713: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1714: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1715: (
1716: l_api_name,
1717: G_PKG_NAME,
1718: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1718: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1724: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1741: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1737: -----------------------------------------
1738: -- update_row for:OKL_CNTR_LVLNG_LNS_B --
1739: -----------------------------------------
1740: PROCEDURE update_row(
1741: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1742: x_return_status OUT NOCOPY VARCHAR2,
1743: x_msg_count OUT NOCOPY NUMBER,
1744: x_msg_data OUT NOCOPY VARCHAR2,
1745: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,

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

1746: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type) IS
1747:
1748: l_api_version CONSTANT NUMBER := 1;
1749: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1750: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1751: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
1752: l_def_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1753: l_row_notfound BOOLEAN := TRUE;
1754: ----------------------------------

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

1759: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1760: ) RETURN VARCHAR2 IS
1761: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
1762: l_row_notfound BOOLEAN := TRUE;
1763: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1764: BEGIN
1765: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1766: -- Get current database values
1767: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_return_status);

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

1764: BEGIN
1765: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1766: -- Get current database values
1767: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_return_status);
1768: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1769: IF (x_okl_cntr_lvlng_lns_b_rec.id = OKL_API.G_MISS_NUM)
1770: THEN
1771: x_okl_cntr_lvlng_lns_b_rec.id := l_okl_cntr_lvlng_lns_b_rec.id;
1772: END IF;

Line 1769: IF (x_okl_cntr_lvlng_lns_b_rec.id = OKL_API.G_MISS_NUM)

1765: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1766: -- Get current database values
1767: l_okl_cntr_lvlng_lns_b_rec := get_rec(p_okl_cntr_lvlng_lns_b_rec, l_return_status);
1768: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1769: IF (x_okl_cntr_lvlng_lns_b_rec.id = OKL_API.G_MISS_NUM)
1770: THEN
1771: x_okl_cntr_lvlng_lns_b_rec.id := l_okl_cntr_lvlng_lns_b_rec.id;
1772: END IF;
1773: IF (x_okl_cntr_lvlng_lns_b_rec.kle_id = OKL_API.G_MISS_NUM)

Line 1773: IF (x_okl_cntr_lvlng_lns_b_rec.kle_id = OKL_API.G_MISS_NUM)

1769: IF (x_okl_cntr_lvlng_lns_b_rec.id = OKL_API.G_MISS_NUM)
1770: THEN
1771: x_okl_cntr_lvlng_lns_b_rec.id := l_okl_cntr_lvlng_lns_b_rec.id;
1772: END IF;
1773: IF (x_okl_cntr_lvlng_lns_b_rec.kle_id = OKL_API.G_MISS_NUM)
1774: THEN
1775: x_okl_cntr_lvlng_lns_b_rec.kle_id := l_okl_cntr_lvlng_lns_b_rec.kle_id;
1776: END IF;
1777: IF (x_okl_cntr_lvlng_lns_b_rec.clg_id = OKL_API.G_MISS_NUM)

Line 1777: IF (x_okl_cntr_lvlng_lns_b_rec.clg_id = OKL_API.G_MISS_NUM)

1773: IF (x_okl_cntr_lvlng_lns_b_rec.kle_id = OKL_API.G_MISS_NUM)
1774: THEN
1775: x_okl_cntr_lvlng_lns_b_rec.kle_id := l_okl_cntr_lvlng_lns_b_rec.kle_id;
1776: END IF;
1777: IF (x_okl_cntr_lvlng_lns_b_rec.clg_id = OKL_API.G_MISS_NUM)
1778: THEN
1779: x_okl_cntr_lvlng_lns_b_rec.clg_id := l_okl_cntr_lvlng_lns_b_rec.clg_id;
1780: END IF;
1781: IF (x_okl_cntr_lvlng_lns_b_rec.object_version_number = OKL_API.G_MISS_NUM)

Line 1781: IF (x_okl_cntr_lvlng_lns_b_rec.object_version_number = OKL_API.G_MISS_NUM)

1777: IF (x_okl_cntr_lvlng_lns_b_rec.clg_id = OKL_API.G_MISS_NUM)
1778: THEN
1779: x_okl_cntr_lvlng_lns_b_rec.clg_id := l_okl_cntr_lvlng_lns_b_rec.clg_id;
1780: END IF;
1781: IF (x_okl_cntr_lvlng_lns_b_rec.object_version_number = OKL_API.G_MISS_NUM)
1782: THEN
1783: x_okl_cntr_lvlng_lns_b_rec.object_version_number := l_okl_cntr_lvlng_lns_b_rec.object_version_number;
1784: END IF;
1785: IF (x_okl_cntr_lvlng_lns_b_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 1785: IF (x_okl_cntr_lvlng_lns_b_rec.attribute_category = OKL_API.G_MISS_CHAR)

1781: IF (x_okl_cntr_lvlng_lns_b_rec.object_version_number = OKL_API.G_MISS_NUM)
1782: THEN
1783: x_okl_cntr_lvlng_lns_b_rec.object_version_number := l_okl_cntr_lvlng_lns_b_rec.object_version_number;
1784: END IF;
1785: IF (x_okl_cntr_lvlng_lns_b_rec.attribute_category = OKL_API.G_MISS_CHAR)
1786: THEN
1787: x_okl_cntr_lvlng_lns_b_rec.attribute_category := l_okl_cntr_lvlng_lns_b_rec.attribute_category;
1788: END IF;
1789: IF (x_okl_cntr_lvlng_lns_b_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 1789: IF (x_okl_cntr_lvlng_lns_b_rec.attribute1 = OKL_API.G_MISS_CHAR)

1785: IF (x_okl_cntr_lvlng_lns_b_rec.attribute_category = OKL_API.G_MISS_CHAR)
1786: THEN
1787: x_okl_cntr_lvlng_lns_b_rec.attribute_category := l_okl_cntr_lvlng_lns_b_rec.attribute_category;
1788: END IF;
1789: IF (x_okl_cntr_lvlng_lns_b_rec.attribute1 = OKL_API.G_MISS_CHAR)
1790: THEN
1791: x_okl_cntr_lvlng_lns_b_rec.attribute1 := l_okl_cntr_lvlng_lns_b_rec.attribute1;
1792: END IF;
1793: IF (x_okl_cntr_lvlng_lns_b_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 1793: IF (x_okl_cntr_lvlng_lns_b_rec.attribute2 = OKL_API.G_MISS_CHAR)

1789: IF (x_okl_cntr_lvlng_lns_b_rec.attribute1 = OKL_API.G_MISS_CHAR)
1790: THEN
1791: x_okl_cntr_lvlng_lns_b_rec.attribute1 := l_okl_cntr_lvlng_lns_b_rec.attribute1;
1792: END IF;
1793: IF (x_okl_cntr_lvlng_lns_b_rec.attribute2 = OKL_API.G_MISS_CHAR)
1794: THEN
1795: x_okl_cntr_lvlng_lns_b_rec.attribute2 := l_okl_cntr_lvlng_lns_b_rec.attribute2;
1796: END IF;
1797: IF (x_okl_cntr_lvlng_lns_b_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 1797: IF (x_okl_cntr_lvlng_lns_b_rec.attribute3 = OKL_API.G_MISS_CHAR)

1793: IF (x_okl_cntr_lvlng_lns_b_rec.attribute2 = OKL_API.G_MISS_CHAR)
1794: THEN
1795: x_okl_cntr_lvlng_lns_b_rec.attribute2 := l_okl_cntr_lvlng_lns_b_rec.attribute2;
1796: END IF;
1797: IF (x_okl_cntr_lvlng_lns_b_rec.attribute3 = OKL_API.G_MISS_CHAR)
1798: THEN
1799: x_okl_cntr_lvlng_lns_b_rec.attribute3 := l_okl_cntr_lvlng_lns_b_rec.attribute3;
1800: END IF;
1801: IF (x_okl_cntr_lvlng_lns_b_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 1801: IF (x_okl_cntr_lvlng_lns_b_rec.attribute4 = OKL_API.G_MISS_CHAR)

1797: IF (x_okl_cntr_lvlng_lns_b_rec.attribute3 = OKL_API.G_MISS_CHAR)
1798: THEN
1799: x_okl_cntr_lvlng_lns_b_rec.attribute3 := l_okl_cntr_lvlng_lns_b_rec.attribute3;
1800: END IF;
1801: IF (x_okl_cntr_lvlng_lns_b_rec.attribute4 = OKL_API.G_MISS_CHAR)
1802: THEN
1803: x_okl_cntr_lvlng_lns_b_rec.attribute4 := l_okl_cntr_lvlng_lns_b_rec.attribute4;
1804: END IF;
1805: IF (x_okl_cntr_lvlng_lns_b_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 1805: IF (x_okl_cntr_lvlng_lns_b_rec.attribute5 = OKL_API.G_MISS_CHAR)

1801: IF (x_okl_cntr_lvlng_lns_b_rec.attribute4 = OKL_API.G_MISS_CHAR)
1802: THEN
1803: x_okl_cntr_lvlng_lns_b_rec.attribute4 := l_okl_cntr_lvlng_lns_b_rec.attribute4;
1804: END IF;
1805: IF (x_okl_cntr_lvlng_lns_b_rec.attribute5 = OKL_API.G_MISS_CHAR)
1806: THEN
1807: x_okl_cntr_lvlng_lns_b_rec.attribute5 := l_okl_cntr_lvlng_lns_b_rec.attribute5;
1808: END IF;
1809: IF (x_okl_cntr_lvlng_lns_b_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 1809: IF (x_okl_cntr_lvlng_lns_b_rec.attribute6 = OKL_API.G_MISS_CHAR)

1805: IF (x_okl_cntr_lvlng_lns_b_rec.attribute5 = OKL_API.G_MISS_CHAR)
1806: THEN
1807: x_okl_cntr_lvlng_lns_b_rec.attribute5 := l_okl_cntr_lvlng_lns_b_rec.attribute5;
1808: END IF;
1809: IF (x_okl_cntr_lvlng_lns_b_rec.attribute6 = OKL_API.G_MISS_CHAR)
1810: THEN
1811: x_okl_cntr_lvlng_lns_b_rec.attribute6 := l_okl_cntr_lvlng_lns_b_rec.attribute6;
1812: END IF;
1813: IF (x_okl_cntr_lvlng_lns_b_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 1813: IF (x_okl_cntr_lvlng_lns_b_rec.attribute7 = OKL_API.G_MISS_CHAR)

1809: IF (x_okl_cntr_lvlng_lns_b_rec.attribute6 = OKL_API.G_MISS_CHAR)
1810: THEN
1811: x_okl_cntr_lvlng_lns_b_rec.attribute6 := l_okl_cntr_lvlng_lns_b_rec.attribute6;
1812: END IF;
1813: IF (x_okl_cntr_lvlng_lns_b_rec.attribute7 = OKL_API.G_MISS_CHAR)
1814: THEN
1815: x_okl_cntr_lvlng_lns_b_rec.attribute7 := l_okl_cntr_lvlng_lns_b_rec.attribute7;
1816: END IF;
1817: IF (x_okl_cntr_lvlng_lns_b_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 1817: IF (x_okl_cntr_lvlng_lns_b_rec.attribute8 = OKL_API.G_MISS_CHAR)

1813: IF (x_okl_cntr_lvlng_lns_b_rec.attribute7 = OKL_API.G_MISS_CHAR)
1814: THEN
1815: x_okl_cntr_lvlng_lns_b_rec.attribute7 := l_okl_cntr_lvlng_lns_b_rec.attribute7;
1816: END IF;
1817: IF (x_okl_cntr_lvlng_lns_b_rec.attribute8 = OKL_API.G_MISS_CHAR)
1818: THEN
1819: x_okl_cntr_lvlng_lns_b_rec.attribute8 := l_okl_cntr_lvlng_lns_b_rec.attribute8;
1820: END IF;
1821: IF (x_okl_cntr_lvlng_lns_b_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 1821: IF (x_okl_cntr_lvlng_lns_b_rec.attribute9 = OKL_API.G_MISS_CHAR)

1817: IF (x_okl_cntr_lvlng_lns_b_rec.attribute8 = OKL_API.G_MISS_CHAR)
1818: THEN
1819: x_okl_cntr_lvlng_lns_b_rec.attribute8 := l_okl_cntr_lvlng_lns_b_rec.attribute8;
1820: END IF;
1821: IF (x_okl_cntr_lvlng_lns_b_rec.attribute9 = OKL_API.G_MISS_CHAR)
1822: THEN
1823: x_okl_cntr_lvlng_lns_b_rec.attribute9 := l_okl_cntr_lvlng_lns_b_rec.attribute9;
1824: END IF;
1825: IF (x_okl_cntr_lvlng_lns_b_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 1825: IF (x_okl_cntr_lvlng_lns_b_rec.attribute10 = OKL_API.G_MISS_CHAR)

1821: IF (x_okl_cntr_lvlng_lns_b_rec.attribute9 = OKL_API.G_MISS_CHAR)
1822: THEN
1823: x_okl_cntr_lvlng_lns_b_rec.attribute9 := l_okl_cntr_lvlng_lns_b_rec.attribute9;
1824: END IF;
1825: IF (x_okl_cntr_lvlng_lns_b_rec.attribute10 = OKL_API.G_MISS_CHAR)
1826: THEN
1827: x_okl_cntr_lvlng_lns_b_rec.attribute10 := l_okl_cntr_lvlng_lns_b_rec.attribute10;
1828: END IF;
1829: IF (x_okl_cntr_lvlng_lns_b_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 1829: IF (x_okl_cntr_lvlng_lns_b_rec.attribute11 = OKL_API.G_MISS_CHAR)

1825: IF (x_okl_cntr_lvlng_lns_b_rec.attribute10 = OKL_API.G_MISS_CHAR)
1826: THEN
1827: x_okl_cntr_lvlng_lns_b_rec.attribute10 := l_okl_cntr_lvlng_lns_b_rec.attribute10;
1828: END IF;
1829: IF (x_okl_cntr_lvlng_lns_b_rec.attribute11 = OKL_API.G_MISS_CHAR)
1830: THEN
1831: x_okl_cntr_lvlng_lns_b_rec.attribute11 := l_okl_cntr_lvlng_lns_b_rec.attribute11;
1832: END IF;
1833: IF (x_okl_cntr_lvlng_lns_b_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 1833: IF (x_okl_cntr_lvlng_lns_b_rec.attribute12 = OKL_API.G_MISS_CHAR)

1829: IF (x_okl_cntr_lvlng_lns_b_rec.attribute11 = OKL_API.G_MISS_CHAR)
1830: THEN
1831: x_okl_cntr_lvlng_lns_b_rec.attribute11 := l_okl_cntr_lvlng_lns_b_rec.attribute11;
1832: END IF;
1833: IF (x_okl_cntr_lvlng_lns_b_rec.attribute12 = OKL_API.G_MISS_CHAR)
1834: THEN
1835: x_okl_cntr_lvlng_lns_b_rec.attribute12 := l_okl_cntr_lvlng_lns_b_rec.attribute12;
1836: END IF;
1837: IF (x_okl_cntr_lvlng_lns_b_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 1837: IF (x_okl_cntr_lvlng_lns_b_rec.attribute13 = OKL_API.G_MISS_CHAR)

1833: IF (x_okl_cntr_lvlng_lns_b_rec.attribute12 = OKL_API.G_MISS_CHAR)
1834: THEN
1835: x_okl_cntr_lvlng_lns_b_rec.attribute12 := l_okl_cntr_lvlng_lns_b_rec.attribute12;
1836: END IF;
1837: IF (x_okl_cntr_lvlng_lns_b_rec.attribute13 = OKL_API.G_MISS_CHAR)
1838: THEN
1839: x_okl_cntr_lvlng_lns_b_rec.attribute13 := l_okl_cntr_lvlng_lns_b_rec.attribute13;
1840: END IF;
1841: IF (x_okl_cntr_lvlng_lns_b_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 1841: IF (x_okl_cntr_lvlng_lns_b_rec.attribute14 = OKL_API.G_MISS_CHAR)

1837: IF (x_okl_cntr_lvlng_lns_b_rec.attribute13 = OKL_API.G_MISS_CHAR)
1838: THEN
1839: x_okl_cntr_lvlng_lns_b_rec.attribute13 := l_okl_cntr_lvlng_lns_b_rec.attribute13;
1840: END IF;
1841: IF (x_okl_cntr_lvlng_lns_b_rec.attribute14 = OKL_API.G_MISS_CHAR)
1842: THEN
1843: x_okl_cntr_lvlng_lns_b_rec.attribute14 := l_okl_cntr_lvlng_lns_b_rec.attribute14;
1844: END IF;
1845: IF (x_okl_cntr_lvlng_lns_b_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 1845: IF (x_okl_cntr_lvlng_lns_b_rec.attribute15 = OKL_API.G_MISS_CHAR)

1841: IF (x_okl_cntr_lvlng_lns_b_rec.attribute14 = OKL_API.G_MISS_CHAR)
1842: THEN
1843: x_okl_cntr_lvlng_lns_b_rec.attribute14 := l_okl_cntr_lvlng_lns_b_rec.attribute14;
1844: END IF;
1845: IF (x_okl_cntr_lvlng_lns_b_rec.attribute15 = OKL_API.G_MISS_CHAR)
1846: THEN
1847: x_okl_cntr_lvlng_lns_b_rec.attribute15 := l_okl_cntr_lvlng_lns_b_rec.attribute15;
1848: END IF;
1849: IF (x_okl_cntr_lvlng_lns_b_rec.created_by = OKL_API.G_MISS_NUM)

Line 1849: IF (x_okl_cntr_lvlng_lns_b_rec.created_by = OKL_API.G_MISS_NUM)

1845: IF (x_okl_cntr_lvlng_lns_b_rec.attribute15 = OKL_API.G_MISS_CHAR)
1846: THEN
1847: x_okl_cntr_lvlng_lns_b_rec.attribute15 := l_okl_cntr_lvlng_lns_b_rec.attribute15;
1848: END IF;
1849: IF (x_okl_cntr_lvlng_lns_b_rec.created_by = OKL_API.G_MISS_NUM)
1850: THEN
1851: x_okl_cntr_lvlng_lns_b_rec.created_by := l_okl_cntr_lvlng_lns_b_rec.created_by;
1852: END IF;
1853: IF (x_okl_cntr_lvlng_lns_b_rec.creation_date = OKL_API.G_MISS_DATE)

Line 1853: IF (x_okl_cntr_lvlng_lns_b_rec.creation_date = OKL_API.G_MISS_DATE)

1849: IF (x_okl_cntr_lvlng_lns_b_rec.created_by = OKL_API.G_MISS_NUM)
1850: THEN
1851: x_okl_cntr_lvlng_lns_b_rec.created_by := l_okl_cntr_lvlng_lns_b_rec.created_by;
1852: END IF;
1853: IF (x_okl_cntr_lvlng_lns_b_rec.creation_date = OKL_API.G_MISS_DATE)
1854: THEN
1855: x_okl_cntr_lvlng_lns_b_rec.creation_date := l_okl_cntr_lvlng_lns_b_rec.creation_date;
1856: END IF;
1857: IF (x_okl_cntr_lvlng_lns_b_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 1857: IF (x_okl_cntr_lvlng_lns_b_rec.last_updated_by = OKL_API.G_MISS_NUM)

1853: IF (x_okl_cntr_lvlng_lns_b_rec.creation_date = OKL_API.G_MISS_DATE)
1854: THEN
1855: x_okl_cntr_lvlng_lns_b_rec.creation_date := l_okl_cntr_lvlng_lns_b_rec.creation_date;
1856: END IF;
1857: IF (x_okl_cntr_lvlng_lns_b_rec.last_updated_by = OKL_API.G_MISS_NUM)
1858: THEN
1859: x_okl_cntr_lvlng_lns_b_rec.last_updated_by := l_okl_cntr_lvlng_lns_b_rec.last_updated_by;
1860: END IF;
1861: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 1861: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_date = OKL_API.G_MISS_DATE)

1857: IF (x_okl_cntr_lvlng_lns_b_rec.last_updated_by = OKL_API.G_MISS_NUM)
1858: THEN
1859: x_okl_cntr_lvlng_lns_b_rec.last_updated_by := l_okl_cntr_lvlng_lns_b_rec.last_updated_by;
1860: END IF;
1861: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_date = OKL_API.G_MISS_DATE)
1862: THEN
1863: x_okl_cntr_lvlng_lns_b_rec.last_update_date := l_okl_cntr_lvlng_lns_b_rec.last_update_date;
1864: END IF;
1865: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 1865: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_login = OKL_API.G_MISS_NUM)

1861: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_date = OKL_API.G_MISS_DATE)
1862: THEN
1863: x_okl_cntr_lvlng_lns_b_rec.last_update_date := l_okl_cntr_lvlng_lns_b_rec.last_update_date;
1864: END IF;
1865: IF (x_okl_cntr_lvlng_lns_b_rec.last_update_login = OKL_API.G_MISS_NUM)
1866: THEN
1867: x_okl_cntr_lvlng_lns_b_rec.last_update_login := l_okl_cntr_lvlng_lns_b_rec.last_update_login;
1868: END IF;
1869: END IF;

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

1875: FUNCTION Set_Attributes (
1876: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type,
1877: x_okl_cntr_lvlng_lns_b_rec OUT NOCOPY okl_cntr_lvlng_lns_b_rec_type
1878: ) RETURN VARCHAR2 IS
1879: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1880: BEGIN
1881: x_okl_cntr_lvlng_lns_b_rec := p_okl_cntr_lvlng_lns_b_rec;
1882: x_okl_cntr_lvlng_lns_b_rec.OBJECT_VERSION_NUMBER := p_okl_cntr_lvlng_lns_b_rec.OBJECT_VERSION_NUMBER + 1;
1883: RETURN(l_return_status);

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

1882: x_okl_cntr_lvlng_lns_b_rec.OBJECT_VERSION_NUMBER := p_okl_cntr_lvlng_lns_b_rec.OBJECT_VERSION_NUMBER + 1;
1883: RETURN(l_return_status);
1884: END Set_Attributes;
1885: BEGIN
1886: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1887: p_init_msg_list,
1888: '_PVT',
1889: x_return_status);
1890: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1886: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1887: p_init_msg_list,
1888: '_PVT',
1889: x_return_status);
1890: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1891: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1892: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1893: RAISE OKL_API.G_EXCEPTION_ERROR;
1894: END IF;

Line 1891: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1887: p_init_msg_list,
1888: '_PVT',
1889: x_return_status);
1890: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1891: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1892: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1893: RAISE OKL_API.G_EXCEPTION_ERROR;
1894: END IF;
1895: --- Setting item attributes

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

1888: '_PVT',
1889: x_return_status);
1890: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1891: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1892: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1893: RAISE OKL_API.G_EXCEPTION_ERROR;
1894: END IF;
1895: --- Setting item attributes
1896: l_return_status := Set_Attributes(

Line 1893: RAISE OKL_API.G_EXCEPTION_ERROR;

1889: x_return_status);
1890: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1891: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1892: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1893: RAISE OKL_API.G_EXCEPTION_ERROR;
1894: END IF;
1895: --- Setting item attributes
1896: l_return_status := Set_Attributes(
1897: p_okl_cntr_lvlng_lns_b_rec, -- IN

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

1896: l_return_status := Set_Attributes(
1897: p_okl_cntr_lvlng_lns_b_rec, -- IN
1898: l_okl_cntr_lvlng_lns_b_rec); -- OUT
1899: --- If any errors happen abort API
1900: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1902: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1903: RAISE OKL_API.G_EXCEPTION_ERROR;
1904: END IF;

Line 1901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1897: p_okl_cntr_lvlng_lns_b_rec, -- IN
1898: l_okl_cntr_lvlng_lns_b_rec); -- OUT
1899: --- If any errors happen abort API
1900: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1902: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1903: RAISE OKL_API.G_EXCEPTION_ERROR;
1904: END IF;
1905: l_return_status := populate_new_record(l_okl_cntr_lvlng_lns_b_rec, l_def_okl_cntr_lvlng_lns_b_rec);

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

1898: l_okl_cntr_lvlng_lns_b_rec); -- OUT
1899: --- If any errors happen abort API
1900: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1902: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1903: RAISE OKL_API.G_EXCEPTION_ERROR;
1904: END IF;
1905: l_return_status := populate_new_record(l_okl_cntr_lvlng_lns_b_rec, l_def_okl_cntr_lvlng_lns_b_rec);
1906: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1903: RAISE OKL_API.G_EXCEPTION_ERROR;

1899: --- If any errors happen abort API
1900: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1902: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1903: RAISE OKL_API.G_EXCEPTION_ERROR;
1904: END IF;
1905: l_return_status := populate_new_record(l_okl_cntr_lvlng_lns_b_rec, l_def_okl_cntr_lvlng_lns_b_rec);
1906: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1907: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1902: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1903: RAISE OKL_API.G_EXCEPTION_ERROR;
1904: END IF;
1905: l_return_status := populate_new_record(l_okl_cntr_lvlng_lns_b_rec, l_def_okl_cntr_lvlng_lns_b_rec);
1906: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1907: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1908: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1909: RAISE OKL_API.G_EXCEPTION_ERROR;
1910: END IF;

Line 1907: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1903: RAISE OKL_API.G_EXCEPTION_ERROR;
1904: END IF;
1905: l_return_status := populate_new_record(l_okl_cntr_lvlng_lns_b_rec, l_def_okl_cntr_lvlng_lns_b_rec);
1906: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1907: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1908: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1909: RAISE OKL_API.G_EXCEPTION_ERROR;
1910: END IF;
1911: UPDATE OKL_CNTR_LVLNG_LNS_B

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

1904: END IF;
1905: l_return_status := populate_new_record(l_okl_cntr_lvlng_lns_b_rec, l_def_okl_cntr_lvlng_lns_b_rec);
1906: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1907: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1908: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1909: RAISE OKL_API.G_EXCEPTION_ERROR;
1910: END IF;
1911: UPDATE OKL_CNTR_LVLNG_LNS_B
1912: SET KLE_ID = l_def_okl_cntr_lvlng_lns_b_rec.kle_id,

Line 1909: RAISE OKL_API.G_EXCEPTION_ERROR;

1905: l_return_status := populate_new_record(l_okl_cntr_lvlng_lns_b_rec, l_def_okl_cntr_lvlng_lns_b_rec);
1906: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1907: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1908: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1909: RAISE OKL_API.G_EXCEPTION_ERROR;
1910: END IF;
1911: UPDATE OKL_CNTR_LVLNG_LNS_B
1912: SET KLE_ID = l_def_okl_cntr_lvlng_lns_b_rec.kle_id,
1913: CLG_ID = l_def_okl_cntr_lvlng_lns_b_rec.clg_id,

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

1936: WHERE ID = l_def_okl_cntr_lvlng_lns_b_rec.id;
1937:
1938: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1939: x_return_status := l_return_status;
1940: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1941: EXCEPTION
1942: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1943: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1944: (

Line 1942: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1938: x_okl_cntr_lvlng_lns_b_rec := l_okl_cntr_lvlng_lns_b_rec;
1939: x_return_status := l_return_status;
1940: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1941: EXCEPTION
1942: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1943: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1944: (
1945: l_api_name,
1946: G_PKG_NAME,

Line 1943: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1939: x_return_status := l_return_status;
1940: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1941: EXCEPTION
1942: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1943: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1944: (
1945: l_api_name,
1946: G_PKG_NAME,
1947: 'OKL_API.G_RET_STS_ERROR',

Line 1947: 'OKL_API.G_RET_STS_ERROR',

1943: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1944: (
1945: l_api_name,
1946: G_PKG_NAME,
1947: 'OKL_API.G_RET_STS_ERROR',
1948: x_msg_count,
1949: x_msg_data,
1950: '_PVT'
1951: );

Line 1952: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1948: x_msg_count,
1949: x_msg_data,
1950: '_PVT'
1951: );
1952: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1953: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1954: (
1955: l_api_name,
1956: G_PKG_NAME,

Line 1953: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1949: x_msg_data,
1950: '_PVT'
1951: );
1952: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1953: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1954: (
1955: l_api_name,
1956: G_PKG_NAME,
1957: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1957: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1953: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1954: (
1955: l_api_name,
1956: G_PKG_NAME,
1957: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1958: x_msg_count,
1959: x_msg_data,
1960: '_PVT'
1961: );

Line 1963: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1959: x_msg_data,
1960: '_PVT'
1961: );
1962: WHEN OTHERS THEN
1963: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1964: (
1965: l_api_name,
1966: G_PKG_NAME,
1967: 'OTHERS',

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

1983: x_cllv_rec OUT NOCOPY cllv_rec_type) IS
1984:
1985: l_api_version CONSTANT NUMBER := 1;
1986: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1987: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1988: l_cllv_rec cllv_rec_type := p_cllv_rec;
1989: l_def_cllv_rec cllv_rec_type;
1990: l_db_cllv_rec cllv_rec_type;
1991: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;

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

2010: p_cllv_rec IN cllv_rec_type,
2011: x_cllv_rec OUT NOCOPY cllv_rec_type
2012: ) RETURN VARCHAR2 IS
2013: l_row_notfound BOOLEAN := TRUE;
2014: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2015: BEGIN
2016: x_cllv_rec := p_cllv_rec;
2017: -- Get current database values
2018: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it

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

2017: -- Get current database values
2018: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2019: -- so it may be verified through LOCK_ROW.
2020: l_db_cllv_rec := get_rec(p_cllv_rec, l_return_status);
2021: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2022: IF (x_cllv_rec.id = OKL_API.G_MISS_NUM)
2023: THEN
2024: x_cllv_rec.id := l_db_cllv_rec.id;
2025: END IF;

Line 2022: IF (x_cllv_rec.id = OKL_API.G_MISS_NUM)

2018: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2019: -- so it may be verified through LOCK_ROW.
2020: l_db_cllv_rec := get_rec(p_cllv_rec, l_return_status);
2021: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2022: IF (x_cllv_rec.id = OKL_API.G_MISS_NUM)
2023: THEN
2024: x_cllv_rec.id := l_db_cllv_rec.id;
2025: END IF;
2026: -- Hand Coded

Line 2027: IF (x_cllv_rec.object_version_number = OKL_API.G_MISS_NUM)

2023: THEN
2024: x_cllv_rec.id := l_db_cllv_rec.id;
2025: END IF;
2026: -- Hand Coded
2027: IF (x_cllv_rec.object_version_number = OKL_API.G_MISS_NUM)
2028: THEN
2029: x_cllv_rec.object_version_number := l_db_cllv_rec.object_version_number;
2030: END IF;
2031: -- End hand Coded

Line 2032: IF (x_cllv_rec.kle_id = OKL_API.G_MISS_NUM)

2028: THEN
2029: x_cllv_rec.object_version_number := l_db_cllv_rec.object_version_number;
2030: END IF;
2031: -- End hand Coded
2032: IF (x_cllv_rec.kle_id = OKL_API.G_MISS_NUM)
2033: THEN
2034: x_cllv_rec.kle_id := l_db_cllv_rec.kle_id;
2035: END IF;
2036: IF (x_cllv_rec.clg_id = OKL_API.G_MISS_NUM)

Line 2036: IF (x_cllv_rec.clg_id = OKL_API.G_MISS_NUM)

2032: IF (x_cllv_rec.kle_id = OKL_API.G_MISS_NUM)
2033: THEN
2034: x_cllv_rec.kle_id := l_db_cllv_rec.kle_id;
2035: END IF;
2036: IF (x_cllv_rec.clg_id = OKL_API.G_MISS_NUM)
2037: THEN
2038: x_cllv_rec.clg_id := l_db_cllv_rec.clg_id;
2039: END IF;
2040: IF (x_cllv_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 2040: IF (x_cllv_rec.attribute_category = OKL_API.G_MISS_CHAR)

2036: IF (x_cllv_rec.clg_id = OKL_API.G_MISS_NUM)
2037: THEN
2038: x_cllv_rec.clg_id := l_db_cllv_rec.clg_id;
2039: END IF;
2040: IF (x_cllv_rec.attribute_category = OKL_API.G_MISS_CHAR)
2041: THEN
2042: x_cllv_rec.attribute_category := l_db_cllv_rec.attribute_category;
2043: END IF;
2044: IF (x_cllv_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 2044: IF (x_cllv_rec.attribute1 = OKL_API.G_MISS_CHAR)

2040: IF (x_cllv_rec.attribute_category = OKL_API.G_MISS_CHAR)
2041: THEN
2042: x_cllv_rec.attribute_category := l_db_cllv_rec.attribute_category;
2043: END IF;
2044: IF (x_cllv_rec.attribute1 = OKL_API.G_MISS_CHAR)
2045: THEN
2046: x_cllv_rec.attribute1 := l_db_cllv_rec.attribute1;
2047: END IF;
2048: IF (x_cllv_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 2048: IF (x_cllv_rec.attribute2 = OKL_API.G_MISS_CHAR)

2044: IF (x_cllv_rec.attribute1 = OKL_API.G_MISS_CHAR)
2045: THEN
2046: x_cllv_rec.attribute1 := l_db_cllv_rec.attribute1;
2047: END IF;
2048: IF (x_cllv_rec.attribute2 = OKL_API.G_MISS_CHAR)
2049: THEN
2050: x_cllv_rec.attribute2 := l_db_cllv_rec.attribute2;
2051: END IF;
2052: IF (x_cllv_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 2052: IF (x_cllv_rec.attribute3 = OKL_API.G_MISS_CHAR)

2048: IF (x_cllv_rec.attribute2 = OKL_API.G_MISS_CHAR)
2049: THEN
2050: x_cllv_rec.attribute2 := l_db_cllv_rec.attribute2;
2051: END IF;
2052: IF (x_cllv_rec.attribute3 = OKL_API.G_MISS_CHAR)
2053: THEN
2054: x_cllv_rec.attribute3 := l_db_cllv_rec.attribute3;
2055: END IF;
2056: IF (x_cllv_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 2056: IF (x_cllv_rec.attribute4 = OKL_API.G_MISS_CHAR)

2052: IF (x_cllv_rec.attribute3 = OKL_API.G_MISS_CHAR)
2053: THEN
2054: x_cllv_rec.attribute3 := l_db_cllv_rec.attribute3;
2055: END IF;
2056: IF (x_cllv_rec.attribute4 = OKL_API.G_MISS_CHAR)
2057: THEN
2058: x_cllv_rec.attribute4 := l_db_cllv_rec.attribute4;
2059: END IF;
2060: IF (x_cllv_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 2060: IF (x_cllv_rec.attribute5 = OKL_API.G_MISS_CHAR)

2056: IF (x_cllv_rec.attribute4 = OKL_API.G_MISS_CHAR)
2057: THEN
2058: x_cllv_rec.attribute4 := l_db_cllv_rec.attribute4;
2059: END IF;
2060: IF (x_cllv_rec.attribute5 = OKL_API.G_MISS_CHAR)
2061: THEN
2062: x_cllv_rec.attribute5 := l_db_cllv_rec.attribute5;
2063: END IF;
2064: IF (x_cllv_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 2064: IF (x_cllv_rec.attribute6 = OKL_API.G_MISS_CHAR)

2060: IF (x_cllv_rec.attribute5 = OKL_API.G_MISS_CHAR)
2061: THEN
2062: x_cllv_rec.attribute5 := l_db_cllv_rec.attribute5;
2063: END IF;
2064: IF (x_cllv_rec.attribute6 = OKL_API.G_MISS_CHAR)
2065: THEN
2066: x_cllv_rec.attribute6 := l_db_cllv_rec.attribute6;
2067: END IF;
2068: IF (x_cllv_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 2068: IF (x_cllv_rec.attribute7 = OKL_API.G_MISS_CHAR)

2064: IF (x_cllv_rec.attribute6 = OKL_API.G_MISS_CHAR)
2065: THEN
2066: x_cllv_rec.attribute6 := l_db_cllv_rec.attribute6;
2067: END IF;
2068: IF (x_cllv_rec.attribute7 = OKL_API.G_MISS_CHAR)
2069: THEN
2070: x_cllv_rec.attribute7 := l_db_cllv_rec.attribute7;
2071: END IF;
2072: IF (x_cllv_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 2072: IF (x_cllv_rec.attribute8 = OKL_API.G_MISS_CHAR)

2068: IF (x_cllv_rec.attribute7 = OKL_API.G_MISS_CHAR)
2069: THEN
2070: x_cllv_rec.attribute7 := l_db_cllv_rec.attribute7;
2071: END IF;
2072: IF (x_cllv_rec.attribute8 = OKL_API.G_MISS_CHAR)
2073: THEN
2074: x_cllv_rec.attribute8 := l_db_cllv_rec.attribute8;
2075: END IF;
2076: IF (x_cllv_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 2076: IF (x_cllv_rec.attribute9 = OKL_API.G_MISS_CHAR)

2072: IF (x_cllv_rec.attribute8 = OKL_API.G_MISS_CHAR)
2073: THEN
2074: x_cllv_rec.attribute8 := l_db_cllv_rec.attribute8;
2075: END IF;
2076: IF (x_cllv_rec.attribute9 = OKL_API.G_MISS_CHAR)
2077: THEN
2078: x_cllv_rec.attribute9 := l_db_cllv_rec.attribute9;
2079: END IF;
2080: IF (x_cllv_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 2080: IF (x_cllv_rec.attribute10 = OKL_API.G_MISS_CHAR)

2076: IF (x_cllv_rec.attribute9 = OKL_API.G_MISS_CHAR)
2077: THEN
2078: x_cllv_rec.attribute9 := l_db_cllv_rec.attribute9;
2079: END IF;
2080: IF (x_cllv_rec.attribute10 = OKL_API.G_MISS_CHAR)
2081: THEN
2082: x_cllv_rec.attribute10 := l_db_cllv_rec.attribute10;
2083: END IF;
2084: IF (x_cllv_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 2084: IF (x_cllv_rec.attribute11 = OKL_API.G_MISS_CHAR)

2080: IF (x_cllv_rec.attribute10 = OKL_API.G_MISS_CHAR)
2081: THEN
2082: x_cllv_rec.attribute10 := l_db_cllv_rec.attribute10;
2083: END IF;
2084: IF (x_cllv_rec.attribute11 = OKL_API.G_MISS_CHAR)
2085: THEN
2086: x_cllv_rec.attribute11 := l_db_cllv_rec.attribute11;
2087: END IF;
2088: IF (x_cllv_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 2088: IF (x_cllv_rec.attribute12 = OKL_API.G_MISS_CHAR)

2084: IF (x_cllv_rec.attribute11 = OKL_API.G_MISS_CHAR)
2085: THEN
2086: x_cllv_rec.attribute11 := l_db_cllv_rec.attribute11;
2087: END IF;
2088: IF (x_cllv_rec.attribute12 = OKL_API.G_MISS_CHAR)
2089: THEN
2090: x_cllv_rec.attribute12 := l_db_cllv_rec.attribute12;
2091: END IF;
2092: IF (x_cllv_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 2092: IF (x_cllv_rec.attribute13 = OKL_API.G_MISS_CHAR)

2088: IF (x_cllv_rec.attribute12 = OKL_API.G_MISS_CHAR)
2089: THEN
2090: x_cllv_rec.attribute12 := l_db_cllv_rec.attribute12;
2091: END IF;
2092: IF (x_cllv_rec.attribute13 = OKL_API.G_MISS_CHAR)
2093: THEN
2094: x_cllv_rec.attribute13 := l_db_cllv_rec.attribute13;
2095: END IF;
2096: IF (x_cllv_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 2096: IF (x_cllv_rec.attribute14 = OKL_API.G_MISS_CHAR)

2092: IF (x_cllv_rec.attribute13 = OKL_API.G_MISS_CHAR)
2093: THEN
2094: x_cllv_rec.attribute13 := l_db_cllv_rec.attribute13;
2095: END IF;
2096: IF (x_cllv_rec.attribute14 = OKL_API.G_MISS_CHAR)
2097: THEN
2098: x_cllv_rec.attribute14 := l_db_cllv_rec.attribute14;
2099: END IF;
2100: IF (x_cllv_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 2100: IF (x_cllv_rec.attribute15 = OKL_API.G_MISS_CHAR)

2096: IF (x_cllv_rec.attribute14 = OKL_API.G_MISS_CHAR)
2097: THEN
2098: x_cllv_rec.attribute14 := l_db_cllv_rec.attribute14;
2099: END IF;
2100: IF (x_cllv_rec.attribute15 = OKL_API.G_MISS_CHAR)
2101: THEN
2102: x_cllv_rec.attribute15 := l_db_cllv_rec.attribute15;
2103: END IF;
2104: IF (x_cllv_rec.created_by = OKL_API.G_MISS_NUM)

Line 2104: IF (x_cllv_rec.created_by = OKL_API.G_MISS_NUM)

2100: IF (x_cllv_rec.attribute15 = OKL_API.G_MISS_CHAR)
2101: THEN
2102: x_cllv_rec.attribute15 := l_db_cllv_rec.attribute15;
2103: END IF;
2104: IF (x_cllv_rec.created_by = OKL_API.G_MISS_NUM)
2105: THEN
2106: x_cllv_rec.created_by := l_db_cllv_rec.created_by;
2107: END IF;
2108: IF (x_cllv_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2108: IF (x_cllv_rec.creation_date = OKL_API.G_MISS_DATE)

2104: IF (x_cllv_rec.created_by = OKL_API.G_MISS_NUM)
2105: THEN
2106: x_cllv_rec.created_by := l_db_cllv_rec.created_by;
2107: END IF;
2108: IF (x_cllv_rec.creation_date = OKL_API.G_MISS_DATE)
2109: THEN
2110: x_cllv_rec.creation_date := l_db_cllv_rec.creation_date;
2111: END IF;
2112: IF (x_cllv_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2112: IF (x_cllv_rec.last_updated_by = OKL_API.G_MISS_NUM)

2108: IF (x_cllv_rec.creation_date = OKL_API.G_MISS_DATE)
2109: THEN
2110: x_cllv_rec.creation_date := l_db_cllv_rec.creation_date;
2111: END IF;
2112: IF (x_cllv_rec.last_updated_by = OKL_API.G_MISS_NUM)
2113: THEN
2114: x_cllv_rec.last_updated_by := l_db_cllv_rec.last_updated_by;
2115: END IF;
2116: IF (x_cllv_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2116: IF (x_cllv_rec.last_update_date = OKL_API.G_MISS_DATE)

2112: IF (x_cllv_rec.last_updated_by = OKL_API.G_MISS_NUM)
2113: THEN
2114: x_cllv_rec.last_updated_by := l_db_cllv_rec.last_updated_by;
2115: END IF;
2116: IF (x_cllv_rec.last_update_date = OKL_API.G_MISS_DATE)
2117: THEN
2118: x_cllv_rec.last_update_date := l_db_cllv_rec.last_update_date;
2119: END IF;
2120: IF (x_cllv_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2120: IF (x_cllv_rec.last_update_login = OKL_API.G_MISS_NUM)

2116: IF (x_cllv_rec.last_update_date = OKL_API.G_MISS_DATE)
2117: THEN
2118: x_cllv_rec.last_update_date := l_db_cllv_rec.last_update_date;
2119: END IF;
2120: IF (x_cllv_rec.last_update_login = OKL_API.G_MISS_NUM)
2121: THEN
2122: x_cllv_rec.last_update_login := l_db_cllv_rec.last_update_login;
2123: END IF;
2124: END IF;

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

2130: FUNCTION Set_Attributes (
2131: p_cllv_rec IN cllv_rec_type,
2132: x_cllv_rec OUT NOCOPY cllv_rec_type
2133: ) RETURN VARCHAR2 IS
2134: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2135: BEGIN
2136: x_cllv_rec := p_cllv_rec;
2137: RETURN(l_return_status);
2138: END Set_Attributes;

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

2136: x_cllv_rec := p_cllv_rec;
2137: RETURN(l_return_status);
2138: END Set_Attributes;
2139: BEGIN
2140: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2141: G_PKG_NAME,
2142: p_init_msg_list,
2143: l_api_version,
2144: p_api_version,

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

2143: l_api_version,
2144: p_api_version,
2145: '_PVT',
2146: x_return_status);
2147: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2149: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2150: RAISE OKL_API.G_EXCEPTION_ERROR;
2151: END IF;

Line 2148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2144: p_api_version,
2145: '_PVT',
2146: x_return_status);
2147: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2149: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2150: RAISE OKL_API.G_EXCEPTION_ERROR;
2151: END IF;
2152: --- Setting item attributes

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

2145: '_PVT',
2146: x_return_status);
2147: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2149: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2150: RAISE OKL_API.G_EXCEPTION_ERROR;
2151: END IF;
2152: --- Setting item attributes
2153: l_return_status := Set_Attributes(

Line 2150: RAISE OKL_API.G_EXCEPTION_ERROR;

2146: x_return_status);
2147: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2149: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2150: RAISE OKL_API.G_EXCEPTION_ERROR;
2151: END IF;
2152: --- Setting item attributes
2153: l_return_status := Set_Attributes(
2154: p_cllv_rec, -- IN

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

2153: l_return_status := Set_Attributes(
2154: p_cllv_rec, -- IN
2155: x_cllv_rec); -- OUT
2156: --- If any errors happen abort API
2157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2160: RAISE OKL_API.G_EXCEPTION_ERROR;
2161: END IF;

Line 2158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2154: p_cllv_rec, -- IN
2155: x_cllv_rec); -- OUT
2156: --- If any errors happen abort API
2157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2160: RAISE OKL_API.G_EXCEPTION_ERROR;
2161: END IF;
2162: l_return_status := populate_new_record(l_cllv_rec, l_def_cllv_rec);

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

2155: x_cllv_rec); -- OUT
2156: --- If any errors happen abort API
2157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2160: RAISE OKL_API.G_EXCEPTION_ERROR;
2161: END IF;
2162: l_return_status := populate_new_record(l_cllv_rec, l_def_cllv_rec);
2163: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2160: RAISE OKL_API.G_EXCEPTION_ERROR;

2156: --- If any errors happen abort API
2157: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2158: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2160: RAISE OKL_API.G_EXCEPTION_ERROR;
2161: END IF;
2162: l_return_status := populate_new_record(l_cllv_rec, l_def_cllv_rec);
2163: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2164: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2159: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2160: RAISE OKL_API.G_EXCEPTION_ERROR;
2161: END IF;
2162: l_return_status := populate_new_record(l_cllv_rec, l_def_cllv_rec);
2163: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2164: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2165: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2166: RAISE OKL_API.G_EXCEPTION_ERROR;
2167: END IF;

Line 2164: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2160: RAISE OKL_API.G_EXCEPTION_ERROR;
2161: END IF;
2162: l_return_status := populate_new_record(l_cllv_rec, l_def_cllv_rec);
2163: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2164: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2165: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2166: RAISE OKL_API.G_EXCEPTION_ERROR;
2167: END IF;
2168: l_def_cllv_rec := fill_who_columns(l_def_cllv_rec);

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

2161: END IF;
2162: l_return_status := populate_new_record(l_cllv_rec, l_def_cllv_rec);
2163: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2164: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2165: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2166: RAISE OKL_API.G_EXCEPTION_ERROR;
2167: END IF;
2168: l_def_cllv_rec := fill_who_columns(l_def_cllv_rec);
2169: --- Validate all non-missing attributes (Item Level Validation)

Line 2166: RAISE OKL_API.G_EXCEPTION_ERROR;

2162: l_return_status := populate_new_record(l_cllv_rec, l_def_cllv_rec);
2163: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2164: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2165: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2166: RAISE OKL_API.G_EXCEPTION_ERROR;
2167: END IF;
2168: l_def_cllv_rec := fill_who_columns(l_def_cllv_rec);
2169: --- Validate all non-missing attributes (Item Level Validation)
2170: l_return_status := Validate_Attributes(l_def_cllv_rec);

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

2168: l_def_cllv_rec := fill_who_columns(l_def_cllv_rec);
2169: --- Validate all non-missing attributes (Item Level Validation)
2170: l_return_status := Validate_Attributes(l_def_cllv_rec);
2171: --- If any errors happen abort API
2172: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2174: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2175: RAISE OKL_API.G_EXCEPTION_ERROR;
2176: END IF;

Line 2173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2169: --- Validate all non-missing attributes (Item Level Validation)
2170: l_return_status := Validate_Attributes(l_def_cllv_rec);
2171: --- If any errors happen abort API
2172: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2174: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2175: RAISE OKL_API.G_EXCEPTION_ERROR;
2176: END IF;
2177: l_return_status := Validate_Record(l_def_cllv_rec, l_db_cllv_rec);

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

2170: l_return_status := Validate_Attributes(l_def_cllv_rec);
2171: --- If any errors happen abort API
2172: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2174: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2175: RAISE OKL_API.G_EXCEPTION_ERROR;
2176: END IF;
2177: l_return_status := Validate_Record(l_def_cllv_rec, l_db_cllv_rec);
2178: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2175: RAISE OKL_API.G_EXCEPTION_ERROR;

2171: --- If any errors happen abort API
2172: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2174: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2175: RAISE OKL_API.G_EXCEPTION_ERROR;
2176: END IF;
2177: l_return_status := Validate_Record(l_def_cllv_rec, l_db_cllv_rec);
2178: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2179: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2174: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2175: RAISE OKL_API.G_EXCEPTION_ERROR;
2176: END IF;
2177: l_return_status := Validate_Record(l_def_cllv_rec, l_db_cllv_rec);
2178: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2179: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2180: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2181: RAISE OKL_API.G_EXCEPTION_ERROR;
2182: END IF;

Line 2179: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2175: RAISE OKL_API.G_EXCEPTION_ERROR;
2176: END IF;
2177: l_return_status := Validate_Record(l_def_cllv_rec, l_db_cllv_rec);
2178: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2179: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2180: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2181: RAISE OKL_API.G_EXCEPTION_ERROR;
2182: END IF;
2183:

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

2176: END IF;
2177: l_return_status := Validate_Record(l_def_cllv_rec, l_db_cllv_rec);
2178: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2179: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2180: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2181: RAISE OKL_API.G_EXCEPTION_ERROR;
2182: END IF;
2183:
2184: -- Lock the Record

Line 2181: RAISE OKL_API.G_EXCEPTION_ERROR;

2177: l_return_status := Validate_Record(l_def_cllv_rec, l_db_cllv_rec);
2178: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2179: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2180: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2181: RAISE OKL_API.G_EXCEPTION_ERROR;
2182: END IF;
2183:
2184: -- Lock the Record
2185: /* lock_row(

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

2188: x_return_status => l_return_status,
2189: x_msg_count => x_msg_count,
2190: x_msg_data => x_msg_data,
2191: p_cllv_rec => p_cllv_rec);
2192: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2193: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2194: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2195: RAISE OKL_API.G_EXCEPTION_ERROR;
2196: END IF;

Line 2193: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2189: x_msg_count => x_msg_count,
2190: x_msg_data => x_msg_data,
2191: p_cllv_rec => p_cllv_rec);
2192: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2193: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2194: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2195: RAISE OKL_API.G_EXCEPTION_ERROR;
2196: END IF;
2197: */

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

2190: x_msg_data => x_msg_data,
2191: p_cllv_rec => p_cllv_rec);
2192: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2193: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2194: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2195: RAISE OKL_API.G_EXCEPTION_ERROR;
2196: END IF;
2197: */
2198: -----------------------------------------

Line 2195: RAISE OKL_API.G_EXCEPTION_ERROR;

2191: p_cllv_rec => p_cllv_rec);
2192: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2193: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2194: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2195: RAISE OKL_API.G_EXCEPTION_ERROR;
2196: END IF;
2197: */
2198: -----------------------------------------
2199: -- Move VIEW record to "Child" records --

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

2209: x_msg_data,
2210: l_okl_cntr_lvlng_lns_b_rec,
2211: lx_okl_cntr_lvlng_lns_b_rec
2212: );
2213: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2215: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2216: RAISE OKL_API.G_EXCEPTION_ERROR;
2217: END IF;

Line 2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2210: l_okl_cntr_lvlng_lns_b_rec,
2211: lx_okl_cntr_lvlng_lns_b_rec
2212: );
2213: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2215: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2216: RAISE OKL_API.G_EXCEPTION_ERROR;
2217: END IF;
2218: migrate(lx_okl_cntr_lvlng_lns_b_rec, l_def_cllv_rec);

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

2211: lx_okl_cntr_lvlng_lns_b_rec
2212: );
2213: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2215: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2216: RAISE OKL_API.G_EXCEPTION_ERROR;
2217: END IF;
2218: migrate(lx_okl_cntr_lvlng_lns_b_rec, l_def_cllv_rec);
2219: x_cllv_rec := l_def_cllv_rec;

Line 2216: RAISE OKL_API.G_EXCEPTION_ERROR;

2212: );
2213: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2215: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2216: RAISE OKL_API.G_EXCEPTION_ERROR;
2217: END IF;
2218: migrate(lx_okl_cntr_lvlng_lns_b_rec, l_def_cllv_rec);
2219: x_cllv_rec := l_def_cllv_rec;
2220: x_return_status := l_return_status;

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

2217: END IF;
2218: migrate(lx_okl_cntr_lvlng_lns_b_rec, l_def_cllv_rec);
2219: x_cllv_rec := l_def_cllv_rec;
2220: x_return_status := l_return_status;
2221: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2222: EXCEPTION
2223: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2224: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2225: (

Line 2223: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2219: x_cllv_rec := l_def_cllv_rec;
2220: x_return_status := l_return_status;
2221: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2222: EXCEPTION
2223: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2224: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2225: (
2226: l_api_name,
2227: G_PKG_NAME,

Line 2224: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2220: x_return_status := l_return_status;
2221: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2222: EXCEPTION
2223: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2224: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2225: (
2226: l_api_name,
2227: G_PKG_NAME,
2228: 'OKL_API.G_RET_STS_ERROR',

Line 2228: 'OKL_API.G_RET_STS_ERROR',

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

Line 2233: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2229: x_msg_count,
2230: x_msg_data,
2231: '_PVT'
2232: );
2233: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2234: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2235: (
2236: l_api_name,
2237: G_PKG_NAME,

Line 2234: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2230: x_msg_data,
2231: '_PVT'
2232: );
2233: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2234: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2235: (
2236: l_api_name,
2237: G_PKG_NAME,
2238: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2238: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2234: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2235: (
2236: l_api_name,
2237: G_PKG_NAME,
2238: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2239: x_msg_count,
2240: x_msg_data,
2241: '_PVT'
2242: );

Line 2244: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2240: x_msg_data,
2241: '_PVT'
2242: );
2243: WHEN OTHERS THEN
2244: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2245: (
2246: l_api_name,
2247: G_PKG_NAME,
2248: 'OTHERS',

Line 2259: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2255: -- PL/SQL TBL update_row for:cllv_tbl --
2256: ----------------------------------------
2257: PROCEDURE update_row(
2258: p_api_version IN NUMBER,
2259: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2260: x_return_status OUT NOCOPY VARCHAR2,
2261: x_msg_count OUT NOCOPY NUMBER,
2262: x_msg_data OUT NOCOPY VARCHAR2,
2263: p_cllv_tbl IN cllv_tbl_type,

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

2261: x_msg_count OUT NOCOPY NUMBER,
2262: x_msg_data OUT NOCOPY VARCHAR2,
2263: p_cllv_tbl IN cllv_tbl_type,
2264: x_cllv_tbl OUT NOCOPY cllv_tbl_type,
2265: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2266:
2267: l_api_version CONSTANT NUMBER := 1;
2268: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2269: i NUMBER := 0;

Line 2271: OKL_API.init_msg_list(p_init_msg_list);

2267: l_api_version CONSTANT NUMBER := 1;
2268: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2269: i NUMBER := 0;
2270: BEGIN
2271: OKL_API.init_msg_list(p_init_msg_list);
2272: -- Make sure PL/SQL table has records in it before passing
2273: IF (p_cllv_tbl.COUNT > 0) THEN
2274: i := p_cllv_tbl.FIRST;
2275: LOOP

Line 2277: l_error_rec OKL_API.ERROR_REC_TYPE;

2273: IF (p_cllv_tbl.COUNT > 0) THEN
2274: i := p_cllv_tbl.FIRST;
2275: LOOP
2276: DECLARE
2277: l_error_rec OKL_API.ERROR_REC_TYPE;
2278: BEGIN
2279: l_error_rec.api_name := l_api_name;
2280: l_error_rec.api_package := G_PKG_NAME;
2281: l_error_rec.idx := i;

Line 2284: p_init_msg_list => OKL_API.G_FALSE,

2280: l_error_rec.api_package := G_PKG_NAME;
2281: l_error_rec.idx := i;
2282: update_row (
2283: p_api_version => p_api_version,
2284: p_init_msg_list => OKL_API.G_FALSE,
2285: x_return_status => l_error_rec.error_type,
2286: x_msg_count => l_error_rec.msg_count,
2287: x_msg_data => l_error_rec.msg_data,
2288: p_cllv_rec => p_cllv_tbl(i),

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

2286: x_msg_count => l_error_rec.msg_count,
2287: x_msg_data => l_error_rec.msg_data,
2288: p_cllv_rec => p_cllv_tbl(i),
2289: x_cllv_rec => x_cllv_tbl(i));
2290: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
2291: l_error_rec.sqlcode := SQLCODE;
2292: load_error_tbl(l_error_rec, px_error_tbl);
2293: ELSE
2294: x_msg_count := l_error_rec.msg_count;

Line 2298: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2294: x_msg_count := l_error_rec.msg_count;
2295: x_msg_data := l_error_rec.msg_data;
2296: END IF;
2297: EXCEPTION
2298: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2299: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2300: l_error_rec.sqlcode := SQLCODE;
2301: load_error_tbl(l_error_rec, px_error_tbl);
2302: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

2295: x_msg_data := l_error_rec.msg_data;
2296: END IF;
2297: EXCEPTION
2298: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2299: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2300: l_error_rec.sqlcode := SQLCODE;
2301: load_error_tbl(l_error_rec, px_error_tbl);
2302: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2303: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2302: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2298: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2299: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2300: l_error_rec.sqlcode := SQLCODE;
2301: load_error_tbl(l_error_rec, px_error_tbl);
2302: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2303: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2304: l_error_rec.sqlcode := SQLCODE;
2305: load_error_tbl(l_error_rec, px_error_tbl);
2306: WHEN OTHERS THEN

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

2299: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2300: l_error_rec.sqlcode := SQLCODE;
2301: load_error_tbl(l_error_rec, px_error_tbl);
2302: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2303: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2304: l_error_rec.sqlcode := SQLCODE;
2305: load_error_tbl(l_error_rec, px_error_tbl);
2306: WHEN OTHERS THEN
2307: l_error_rec.error_type := 'OTHERS';

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

2314: END IF;
2315: -- Loop through the error_tbl to find the error with the highest severity
2316: -- and return it.
2317: x_return_status := find_highest_exception(px_error_tbl);
2318: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2319: EXCEPTION
2320: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2321: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2322: (

Line 2320: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2316: -- and return it.
2317: x_return_status := find_highest_exception(px_error_tbl);
2318: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2319: EXCEPTION
2320: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2321: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2322: (
2323: l_api_name,
2324: G_PKG_NAME,

Line 2321: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2317: x_return_status := find_highest_exception(px_error_tbl);
2318: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2319: EXCEPTION
2320: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2321: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2322: (
2323: l_api_name,
2324: G_PKG_NAME,
2325: 'OKL_API.G_RET_STS_ERROR',

Line 2325: 'OKL_API.G_RET_STS_ERROR',

2321: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2322: (
2323: l_api_name,
2324: G_PKG_NAME,
2325: 'OKL_API.G_RET_STS_ERROR',
2326: x_msg_count,
2327: x_msg_data,
2328: '_PVT'
2329: );

Line 2330: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2331: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2335: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2341: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

2362: x_cllv_tbl OUT NOCOPY cllv_tbl_type) IS
2363:
2364: l_api_version CONSTANT NUMBER := 1;
2365: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2366: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2367: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2368: BEGIN
2369: OKL_API.init_msg_list(p_init_msg_list);
2370: -- Make sure PL/SQL table has records in it before passing

Line 2367: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2363:
2364: l_api_version CONSTANT NUMBER := 1;
2365: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2366: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2367: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2368: BEGIN
2369: OKL_API.init_msg_list(p_init_msg_list);
2370: -- Make sure PL/SQL table has records in it before passing
2371: IF (p_cllv_tbl.COUNT > 0) THEN

Line 2369: OKL_API.init_msg_list(p_init_msg_list);

2365: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2366: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2367: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2368: BEGIN
2369: OKL_API.init_msg_list(p_init_msg_list);
2370: -- Make sure PL/SQL table has records in it before passing
2371: IF (p_cllv_tbl.COUNT > 0) THEN
2372: update_row (
2373: p_api_version => p_api_version,

Line 2374: p_init_msg_list => OKL_API.G_FALSE,

2370: -- Make sure PL/SQL table has records in it before passing
2371: IF (p_cllv_tbl.COUNT > 0) THEN
2372: update_row (
2373: p_api_version => p_api_version,
2374: p_init_msg_list => OKL_API.G_FALSE,
2375: x_return_status => x_return_status,
2376: x_msg_count => x_msg_count,
2377: x_msg_data => x_msg_data,
2378: p_cllv_tbl => p_cllv_tbl,

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

2378: p_cllv_tbl => p_cllv_tbl,
2379: x_cllv_tbl => x_cllv_tbl,
2380: px_error_tbl => l_error_tbl);
2381: END IF;
2382: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2383: EXCEPTION
2384: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2385: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2386: (

Line 2384: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2380: px_error_tbl => l_error_tbl);
2381: END IF;
2382: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2383: EXCEPTION
2384: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2385: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2386: (
2387: l_api_name,
2388: G_PKG_NAME,

Line 2385: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2381: END IF;
2382: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2383: EXCEPTION
2384: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2385: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2386: (
2387: l_api_name,
2388: G_PKG_NAME,
2389: 'OKL_API.G_RET_STS_ERROR',

Line 2389: 'OKL_API.G_RET_STS_ERROR',

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

Line 2394: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2395: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2399: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2405: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2423: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2419: -----------------------------------------
2420: -- delete_row for:OKL_CNTR_LVLNG_LNS_B --
2421: -----------------------------------------
2422: PROCEDURE delete_row(
2423: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2424: x_return_status OUT NOCOPY VARCHAR2,
2425: x_msg_count OUT NOCOPY NUMBER,
2426: x_msg_data OUT NOCOPY VARCHAR2,
2427: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS

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

2427: p_okl_cntr_lvlng_lns_b_rec IN okl_cntr_lvlng_lns_b_rec_type) IS
2428:
2429: l_api_version CONSTANT NUMBER := 1;
2430: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2431: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2432: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
2433: l_row_notfound BOOLEAN := TRUE;
2434: BEGIN
2435: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

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

2431: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2432: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type := p_okl_cntr_lvlng_lns_b_rec;
2433: l_row_notfound BOOLEAN := TRUE;
2434: BEGIN
2435: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2436: p_init_msg_list,
2437: '_PVT',
2438: x_return_status);
2439: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

2435: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2436: p_init_msg_list,
2437: '_PVT',
2438: x_return_status);
2439: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2440: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2441: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2442: RAISE OKL_API.G_EXCEPTION_ERROR;
2443: END IF;

Line 2440: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2436: p_init_msg_list,
2437: '_PVT',
2438: x_return_status);
2439: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2440: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2441: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2442: RAISE OKL_API.G_EXCEPTION_ERROR;
2443: END IF;
2444:

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

2437: '_PVT',
2438: x_return_status);
2439: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2440: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2441: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2442: RAISE OKL_API.G_EXCEPTION_ERROR;
2443: END IF;
2444:
2445: DELETE FROM OKL_CNTR_LVLNG_LNS_B

Line 2442: RAISE OKL_API.G_EXCEPTION_ERROR;

2438: x_return_status);
2439: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2440: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2441: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2442: RAISE OKL_API.G_EXCEPTION_ERROR;
2443: END IF;
2444:
2445: DELETE FROM OKL_CNTR_LVLNG_LNS_B
2446: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id;

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

2445: DELETE FROM OKL_CNTR_LVLNG_LNS_B
2446: WHERE ID = p_okl_cntr_lvlng_lns_b_rec.id;
2447:
2448: x_return_status := l_return_status;
2449: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2450: EXCEPTION
2451: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2452: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2453: (

Line 2451: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 2452: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2456: 'OKL_API.G_RET_STS_ERROR',

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

Line 2461: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2462: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2466: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2472: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

2491: p_cllv_rec IN cllv_rec_type) IS
2492:
2493: l_api_version CONSTANT NUMBER := 1;
2494: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2495: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2496: l_cllv_rec cllv_rec_type := p_cllv_rec;
2497: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
2498: BEGIN
2499: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

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

2495: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2496: l_cllv_rec cllv_rec_type := p_cllv_rec;
2497: l_okl_cntr_lvlng_lns_b_rec okl_cntr_lvlng_lns_b_rec_type;
2498: BEGIN
2499: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2500: G_PKG_NAME,
2501: p_init_msg_list,
2502: l_api_version,
2503: p_api_version,

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

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

Line 2507: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

2504: '_PVT',
2505: x_return_status);
2506: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2507: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2508: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2509: RAISE OKL_API.G_EXCEPTION_ERROR;
2510: END IF;
2511: -----------------------------------------
2512: -- Move VIEW record to "Child" records --

Line 2509: RAISE OKL_API.G_EXCEPTION_ERROR;

2505: x_return_status);
2506: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2507: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2508: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2509: RAISE OKL_API.G_EXCEPTION_ERROR;
2510: END IF;
2511: -----------------------------------------
2512: -- Move VIEW record to "Child" records --
2513: -----------------------------------------

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

2521: x_msg_count,
2522: x_msg_data,
2523: l_okl_cntr_lvlng_lns_b_rec
2524: );
2525: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2526: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2527: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2528: RAISE OKL_API.G_EXCEPTION_ERROR;
2529: END IF;

Line 2526: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

2523: l_okl_cntr_lvlng_lns_b_rec
2524: );
2525: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2526: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2527: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2528: RAISE OKL_API.G_EXCEPTION_ERROR;
2529: END IF;
2530: x_return_status := l_return_status;
2531: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2528: RAISE OKL_API.G_EXCEPTION_ERROR;

2524: );
2525: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2526: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2527: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2528: RAISE OKL_API.G_EXCEPTION_ERROR;
2529: END IF;
2530: x_return_status := l_return_status;
2531: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2532: EXCEPTION

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

2527: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2528: RAISE OKL_API.G_EXCEPTION_ERROR;
2529: END IF;
2530: x_return_status := l_return_status;
2531: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2532: EXCEPTION
2533: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2534: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2535: (

Line 2533: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2529: END IF;
2530: x_return_status := l_return_status;
2531: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2532: EXCEPTION
2533: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2534: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2535: (
2536: l_api_name,
2537: G_PKG_NAME,

Line 2534: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2530: x_return_status := l_return_status;
2531: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2532: EXCEPTION
2533: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2534: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2535: (
2536: l_api_name,
2537: G_PKG_NAME,
2538: 'OKL_API.G_RET_STS_ERROR',

Line 2538: 'OKL_API.G_RET_STS_ERROR',

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

Line 2543: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2539: x_msg_count,
2540: x_msg_data,
2541: '_PVT'
2542: );
2543: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2544: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2545: (
2546: l_api_name,
2547: G_PKG_NAME,

Line 2544: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2540: x_msg_data,
2541: '_PVT'
2542: );
2543: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2544: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2545: (
2546: l_api_name,
2547: G_PKG_NAME,
2548: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2548: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2554: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2569: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2565: -- PL/SQL TBL delete_row for:OKL_CNTR_LVLNG_LNS_V --
2566: ----------------------------------------------------
2567: PROCEDURE delete_row(
2568: p_api_version IN NUMBER,
2569: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2570: x_return_status OUT NOCOPY VARCHAR2,
2571: x_msg_count OUT NOCOPY NUMBER,
2572: x_msg_data OUT NOCOPY VARCHAR2,
2573: p_cllv_tbl IN cllv_tbl_type,

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

2570: x_return_status OUT NOCOPY VARCHAR2,
2571: x_msg_count OUT NOCOPY NUMBER,
2572: x_msg_data OUT NOCOPY VARCHAR2,
2573: p_cllv_tbl IN cllv_tbl_type,
2574: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2575:
2576: l_api_version CONSTANT NUMBER := 1;
2577: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2578: i NUMBER := 0;

Line 2580: OKL_API.init_msg_list(p_init_msg_list);

2576: l_api_version CONSTANT NUMBER := 1;
2577: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2578: i NUMBER := 0;
2579: BEGIN
2580: OKL_API.init_msg_list(p_init_msg_list);
2581: -- Make sure PL/SQL table has records in it before passing
2582: IF (p_cllv_tbl.COUNT > 0) THEN
2583: i := p_cllv_tbl.FIRST;
2584: LOOP

Line 2586: l_error_rec OKL_API.ERROR_REC_TYPE;

2582: IF (p_cllv_tbl.COUNT > 0) THEN
2583: i := p_cllv_tbl.FIRST;
2584: LOOP
2585: DECLARE
2586: l_error_rec OKL_API.ERROR_REC_TYPE;
2587: BEGIN
2588: l_error_rec.api_name := l_api_name;
2589: l_error_rec.api_package := G_PKG_NAME;
2590: l_error_rec.idx := i;

Line 2593: p_init_msg_list => OKL_API.G_FALSE,

2589: l_error_rec.api_package := G_PKG_NAME;
2590: l_error_rec.idx := i;
2591: delete_row (
2592: p_api_version => p_api_version,
2593: p_init_msg_list => OKL_API.G_FALSE,
2594: x_return_status => l_error_rec.error_type,
2595: x_msg_count => l_error_rec.msg_count,
2596: x_msg_data => l_error_rec.msg_data,
2597: p_cllv_rec => p_cllv_tbl(i));

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

2594: x_return_status => l_error_rec.error_type,
2595: x_msg_count => l_error_rec.msg_count,
2596: x_msg_data => l_error_rec.msg_data,
2597: p_cllv_rec => p_cllv_tbl(i));
2598: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
2599: l_error_rec.sqlcode := SQLCODE;
2600: load_error_tbl(l_error_rec, px_error_tbl);
2601: ELSE
2602: x_msg_count := l_error_rec.msg_count;

Line 2606: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2602: x_msg_count := l_error_rec.msg_count;
2603: x_msg_data := l_error_rec.msg_data;
2604: END IF;
2605: EXCEPTION
2606: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2607: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2608: l_error_rec.sqlcode := SQLCODE;
2609: load_error_tbl(l_error_rec, px_error_tbl);
2610: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

2603: x_msg_data := l_error_rec.msg_data;
2604: END IF;
2605: EXCEPTION
2606: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2607: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2608: l_error_rec.sqlcode := SQLCODE;
2609: load_error_tbl(l_error_rec, px_error_tbl);
2610: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2611: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2610: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2606: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2607: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2608: l_error_rec.sqlcode := SQLCODE;
2609: load_error_tbl(l_error_rec, px_error_tbl);
2610: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2611: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2612: l_error_rec.sqlcode := SQLCODE;
2613: load_error_tbl(l_error_rec, px_error_tbl);
2614: WHEN OTHERS THEN

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

2607: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2608: l_error_rec.sqlcode := SQLCODE;
2609: load_error_tbl(l_error_rec, px_error_tbl);
2610: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2611: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2612: l_error_rec.sqlcode := SQLCODE;
2613: load_error_tbl(l_error_rec, px_error_tbl);
2614: WHEN OTHERS THEN
2615: l_error_rec.error_type := 'OTHERS';

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

2622: END IF;
2623: -- Loop through the error_tbl to find the error with the highest severity
2624: -- and return it.
2625: x_return_status := find_highest_exception(px_error_tbl);
2626: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2627: EXCEPTION
2628: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2629: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2630: (

Line 2628: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2624: -- and return it.
2625: x_return_status := find_highest_exception(px_error_tbl);
2626: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2627: EXCEPTION
2628: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2629: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2630: (
2631: l_api_name,
2632: G_PKG_NAME,

Line 2629: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2625: x_return_status := find_highest_exception(px_error_tbl);
2626: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2627: EXCEPTION
2628: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2629: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2630: (
2631: l_api_name,
2632: G_PKG_NAME,
2633: 'OKL_API.G_RET_STS_ERROR',

Line 2633: 'OKL_API.G_RET_STS_ERROR',

2629: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2630: (
2631: l_api_name,
2632: G_PKG_NAME,
2633: 'OKL_API.G_RET_STS_ERROR',
2634: x_msg_count,
2635: x_msg_data,
2636: '_PVT'
2637: );

Line 2638: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2634: x_msg_count,
2635: x_msg_data,
2636: '_PVT'
2637: );
2638: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2639: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2640: (
2641: l_api_name,
2642: G_PKG_NAME,

Line 2639: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2635: x_msg_data,
2636: '_PVT'
2637: );
2638: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2639: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2640: (
2641: l_api_name,
2642: G_PKG_NAME,
2643: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2643: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2649: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

2669: p_cllv_tbl IN cllv_tbl_type) IS
2670:
2671: l_api_version CONSTANT NUMBER := 1;
2672: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2673: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2674: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2675: BEGIN
2676: OKL_API.init_msg_list(p_init_msg_list);
2677: -- Make sure PL/SQL table has records in it before passing

Line 2674: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2670:
2671: l_api_version CONSTANT NUMBER := 1;
2672: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2673: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2674: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2675: BEGIN
2676: OKL_API.init_msg_list(p_init_msg_list);
2677: -- Make sure PL/SQL table has records in it before passing
2678: IF (p_cllv_tbl.COUNT > 0) THEN

Line 2676: OKL_API.init_msg_list(p_init_msg_list);

2672: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2673: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2674: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2675: BEGIN
2676: OKL_API.init_msg_list(p_init_msg_list);
2677: -- Make sure PL/SQL table has records in it before passing
2678: IF (p_cllv_tbl.COUNT > 0) THEN
2679: delete_row (
2680: p_api_version => p_api_version,

Line 2681: p_init_msg_list => OKL_API.G_FALSE,

2677: -- Make sure PL/SQL table has records in it before passing
2678: IF (p_cllv_tbl.COUNT > 0) THEN
2679: delete_row (
2680: p_api_version => p_api_version,
2681: p_init_msg_list => OKL_API.G_FALSE,
2682: x_return_status => x_return_status,
2683: x_msg_count => x_msg_count,
2684: x_msg_data => x_msg_data,
2685: p_cllv_tbl => p_cllv_tbl,

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

2684: x_msg_data => x_msg_data,
2685: p_cllv_tbl => p_cllv_tbl,
2686: px_error_tbl => l_error_tbl);
2687: END IF;
2688: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2689: EXCEPTION
2690: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2691: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2692: (

Line 2690: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2686: px_error_tbl => l_error_tbl);
2687: END IF;
2688: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2689: EXCEPTION
2690: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2691: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2692: (
2693: l_api_name,
2694: G_PKG_NAME,

Line 2691: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2687: END IF;
2688: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2689: EXCEPTION
2690: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2691: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2692: (
2693: l_api_name,
2694: G_PKG_NAME,
2695: 'OKL_API.G_RET_STS_ERROR',

Line 2695: 'OKL_API.G_RET_STS_ERROR',

2691: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2692: (
2693: l_api_name,
2694: G_PKG_NAME,
2695: 'OKL_API.G_RET_STS_ERROR',
2696: x_msg_count,
2697: x_msg_data,
2698: '_PVT'
2699: );

Line 2700: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2701: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2697: x_msg_data,
2698: '_PVT'
2699: );
2700: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2701: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2702: (
2703: l_api_name,
2704: G_PKG_NAME,
2705: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2705: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2711: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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