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

Line 7: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,

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

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

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

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

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

Line 42: p_error_tbl IN OKL_API.ERROR_TBL_TYPE

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

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

40: -- in a OKL_API.ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN OKL_API.ERROR_TBL_TYPE
43: ) RETURN VARCHAR2 IS
44: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
45: i INTEGER := 1;
46: BEGIN
47: IF (p_error_tbl.COUNT > 0) THEN
48: i := p_error_tbl.FIRST;

Line 50: IF (p_error_tbl(i).error_type <> OKL_API.G_RET_STS_SUCCESS) THEN

46: BEGIN
47: IF (p_error_tbl.COUNT > 0) THEN
48: i := p_error_tbl.FIRST;
49: LOOP
50: IF (p_error_tbl(i).error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
51: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
52: l_return_status := p_error_tbl(i).error_type;
53: END IF;
54: END IF;

Line 51: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

47: IF (p_error_tbl.COUNT > 0) THEN
48: i := p_error_tbl.FIRST;
49: LOOP
50: IF (p_error_tbl(i).error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
51: IF (l_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
52: l_return_status := p_error_tbl(i).error_type;
53: END IF;
54: END IF;
55: EXIT WHEN (i = p_error_tbl.LAST);

Line 178: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

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

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

Line 182: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 281: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

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

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

Line 285: x_return_status := OKL_API.G_RET_STS_ERROR;

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

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

303: p_cfov_rec IN cfov_rec_type
304: ) RETURN cfov_rec_type IS
305: l_cfov_rec cfov_rec_type := p_cfov_rec;
306: BEGIN
307: IF (l_cfov_rec.id = OKL_API.G_MISS_NUM ) THEN
308: l_cfov_rec.id := NULL;
309: END IF;
310: IF (l_cfov_rec.oty_code = OKL_API.G_MISS_CHAR ) THEN
311: l_cfov_rec.oty_code := NULL;

Line 310: IF (l_cfov_rec.oty_code = OKL_API.G_MISS_CHAR ) THEN

306: BEGIN
307: IF (l_cfov_rec.id = OKL_API.G_MISS_NUM ) THEN
308: l_cfov_rec.id := NULL;
309: END IF;
310: IF (l_cfov_rec.oty_code = OKL_API.G_MISS_CHAR ) THEN
311: l_cfov_rec.oty_code := NULL;
312: END IF;
313: IF (l_cfov_rec.source_table = OKL_API.G_MISS_CHAR ) THEN
314: l_cfov_rec.source_table := NULL;

Line 313: IF (l_cfov_rec.source_table = OKL_API.G_MISS_CHAR ) THEN

309: END IF;
310: IF (l_cfov_rec.oty_code = OKL_API.G_MISS_CHAR ) THEN
311: l_cfov_rec.oty_code := NULL;
312: END IF;
313: IF (l_cfov_rec.source_table = OKL_API.G_MISS_CHAR ) THEN
314: l_cfov_rec.source_table := NULL;
315: END IF;
316: IF (l_cfov_rec.source_id = OKL_API.G_MISS_NUM ) THEN
317: l_cfov_rec.source_id := NULL;

Line 316: IF (l_cfov_rec.source_id = OKL_API.G_MISS_NUM ) THEN

312: END IF;
313: IF (l_cfov_rec.source_table = OKL_API.G_MISS_CHAR ) THEN
314: l_cfov_rec.source_table := NULL;
315: END IF;
316: IF (l_cfov_rec.source_id = OKL_API.G_MISS_NUM ) THEN
317: l_cfov_rec.source_id := NULL;
318: END IF;
319: IF (l_cfov_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
320: l_cfov_rec.attribute_category := NULL;

Line 319: IF (l_cfov_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN

315: END IF;
316: IF (l_cfov_rec.source_id = OKL_API.G_MISS_NUM ) THEN
317: l_cfov_rec.source_id := NULL;
318: END IF;
319: IF (l_cfov_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
320: l_cfov_rec.attribute_category := NULL;
321: END IF;
322: IF (l_cfov_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
323: l_cfov_rec.attribute1 := NULL;

Line 322: IF (l_cfov_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN

318: END IF;
319: IF (l_cfov_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
320: l_cfov_rec.attribute_category := NULL;
321: END IF;
322: IF (l_cfov_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
323: l_cfov_rec.attribute1 := NULL;
324: END IF;
325: IF (l_cfov_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
326: l_cfov_rec.attribute2 := NULL;

Line 325: IF (l_cfov_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN

321: END IF;
322: IF (l_cfov_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
323: l_cfov_rec.attribute1 := NULL;
324: END IF;
325: IF (l_cfov_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
326: l_cfov_rec.attribute2 := NULL;
327: END IF;
328: IF (l_cfov_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
329: l_cfov_rec.attribute3 := NULL;

Line 328: IF (l_cfov_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN

324: END IF;
325: IF (l_cfov_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
326: l_cfov_rec.attribute2 := NULL;
327: END IF;
328: IF (l_cfov_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
329: l_cfov_rec.attribute3 := NULL;
330: END IF;
331: IF (l_cfov_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
332: l_cfov_rec.attribute4 := NULL;

Line 331: IF (l_cfov_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN

327: END IF;
328: IF (l_cfov_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
329: l_cfov_rec.attribute3 := NULL;
330: END IF;
331: IF (l_cfov_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
332: l_cfov_rec.attribute4 := NULL;
333: END IF;
334: IF (l_cfov_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
335: l_cfov_rec.attribute5 := NULL;

Line 334: IF (l_cfov_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN

330: END IF;
331: IF (l_cfov_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
332: l_cfov_rec.attribute4 := NULL;
333: END IF;
334: IF (l_cfov_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
335: l_cfov_rec.attribute5 := NULL;
336: END IF;
337: IF (l_cfov_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
338: l_cfov_rec.attribute6 := NULL;

Line 337: IF (l_cfov_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN

333: END IF;
334: IF (l_cfov_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
335: l_cfov_rec.attribute5 := NULL;
336: END IF;
337: IF (l_cfov_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
338: l_cfov_rec.attribute6 := NULL;
339: END IF;
340: IF (l_cfov_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
341: l_cfov_rec.attribute7 := NULL;

Line 340: IF (l_cfov_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN

336: END IF;
337: IF (l_cfov_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
338: l_cfov_rec.attribute6 := NULL;
339: END IF;
340: IF (l_cfov_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
341: l_cfov_rec.attribute7 := NULL;
342: END IF;
343: IF (l_cfov_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
344: l_cfov_rec.attribute8 := NULL;

Line 343: IF (l_cfov_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN

339: END IF;
340: IF (l_cfov_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
341: l_cfov_rec.attribute7 := NULL;
342: END IF;
343: IF (l_cfov_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
344: l_cfov_rec.attribute8 := NULL;
345: END IF;
346: IF (l_cfov_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
347: l_cfov_rec.attribute9 := NULL;

Line 346: IF (l_cfov_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN

342: END IF;
343: IF (l_cfov_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
344: l_cfov_rec.attribute8 := NULL;
345: END IF;
346: IF (l_cfov_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
347: l_cfov_rec.attribute9 := NULL;
348: END IF;
349: IF (l_cfov_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
350: l_cfov_rec.attribute10 := NULL;

Line 349: IF (l_cfov_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN

345: END IF;
346: IF (l_cfov_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
347: l_cfov_rec.attribute9 := NULL;
348: END IF;
349: IF (l_cfov_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
350: l_cfov_rec.attribute10 := NULL;
351: END IF;
352: IF (l_cfov_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
353: l_cfov_rec.attribute11 := NULL;

Line 352: IF (l_cfov_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN

348: END IF;
349: IF (l_cfov_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
350: l_cfov_rec.attribute10 := NULL;
351: END IF;
352: IF (l_cfov_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
353: l_cfov_rec.attribute11 := NULL;
354: END IF;
355: IF (l_cfov_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
356: l_cfov_rec.attribute12 := NULL;

Line 355: IF (l_cfov_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN

351: END IF;
352: IF (l_cfov_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
353: l_cfov_rec.attribute11 := NULL;
354: END IF;
355: IF (l_cfov_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
356: l_cfov_rec.attribute12 := NULL;
357: END IF;
358: IF (l_cfov_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
359: l_cfov_rec.attribute13 := NULL;

Line 358: IF (l_cfov_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN

354: END IF;
355: IF (l_cfov_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
356: l_cfov_rec.attribute12 := NULL;
357: END IF;
358: IF (l_cfov_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
359: l_cfov_rec.attribute13 := NULL;
360: END IF;
361: IF (l_cfov_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
362: l_cfov_rec.attribute14 := NULL;

Line 361: IF (l_cfov_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN

357: END IF;
358: IF (l_cfov_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
359: l_cfov_rec.attribute13 := NULL;
360: END IF;
361: IF (l_cfov_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
362: l_cfov_rec.attribute14 := NULL;
363: END IF;
364: IF (l_cfov_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
365: l_cfov_rec.attribute15 := NULL;

Line 364: IF (l_cfov_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN

360: END IF;
361: IF (l_cfov_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
362: l_cfov_rec.attribute14 := NULL;
363: END IF;
364: IF (l_cfov_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
365: l_cfov_rec.attribute15 := NULL;
366: END IF;
367: IF (l_cfov_rec.created_by = OKL_API.G_MISS_NUM ) THEN
368: l_cfov_rec.created_by := NULL;

Line 367: IF (l_cfov_rec.created_by = OKL_API.G_MISS_NUM ) THEN

363: END IF;
364: IF (l_cfov_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
365: l_cfov_rec.attribute15 := NULL;
366: END IF;
367: IF (l_cfov_rec.created_by = OKL_API.G_MISS_NUM ) THEN
368: l_cfov_rec.created_by := NULL;
369: END IF;
370: IF (l_cfov_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
371: l_cfov_rec.creation_date := NULL;

Line 370: IF (l_cfov_rec.creation_date = OKL_API.G_MISS_DATE ) THEN

366: END IF;
367: IF (l_cfov_rec.created_by = OKL_API.G_MISS_NUM ) THEN
368: l_cfov_rec.created_by := NULL;
369: END IF;
370: IF (l_cfov_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
371: l_cfov_rec.creation_date := NULL;
372: END IF;
373: IF (l_cfov_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
374: l_cfov_rec.last_updated_by := NULL;

Line 373: IF (l_cfov_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN

369: END IF;
370: IF (l_cfov_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
371: l_cfov_rec.creation_date := NULL;
372: END IF;
373: IF (l_cfov_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
374: l_cfov_rec.last_updated_by := NULL;
375: END IF;
376: IF (l_cfov_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
377: l_cfov_rec.last_update_date := NULL;

Line 376: IF (l_cfov_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN

372: END IF;
373: IF (l_cfov_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
374: l_cfov_rec.last_updated_by := NULL;
375: END IF;
376: IF (l_cfov_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
377: l_cfov_rec.last_update_date := NULL;
378: END IF;
379: IF (l_cfov_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
380: l_cfov_rec.last_update_login := NULL;

Line 379: IF (l_cfov_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN

375: END IF;
376: IF (l_cfov_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
377: l_cfov_rec.last_update_date := NULL;
378: END IF;
379: IF (l_cfov_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
380: l_cfov_rec.last_update_login := NULL;
381: END IF;
382: IF (l_cfov_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
383: l_cfov_rec.object_version_number := NULL;

Line 382: IF (l_cfov_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN

378: END IF;
379: IF (l_cfov_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
380: l_cfov_rec.last_update_login := NULL;
381: END IF;
382: IF (l_cfov_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
383: l_cfov_rec.object_version_number := NULL;
384: END IF;
385: RETURN(l_cfov_rec);
386: END null_out_defaults;

Line 395: IF (p_cfov_rec.id = OKL_API.G_MISS_NUM OR p_cfov_rec.id IS NULL)

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

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

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

Line 398: l_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 405: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

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

Line 411: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

Line 429: IF (p_cfov_rec.oty_code = OKL_API.G_MISS_CHAR OR p_cfov_rec.oty_code IS NULL)

425: WHERE fnd_lookup_values.lookup_code = p_lookup_code
426: AND fnd_lookup_values.lookup_type = p_lookup_type;
427: BEGIN
428:
429: IF (p_cfov_rec.oty_code = OKL_API.G_MISS_CHAR OR p_cfov_rec.oty_code IS NULL)
430: THEN
431: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'oty_code');
432: l_return_status := OKL_API.G_RET_STS_ERROR;
433: ELSE

Line 431: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'oty_code');

427: BEGIN
428:
429: IF (p_cfov_rec.oty_code = OKL_API.G_MISS_CHAR OR p_cfov_rec.oty_code IS NULL)
430: THEN
431: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'oty_code');
432: l_return_status := OKL_API.G_RET_STS_ERROR;
433: ELSE
434: -- enforce foreign key
435: OPEN okl_cfov_oty_fk_csr(p_cfov_rec.oty_code, 'OKL_CF_OBJECT_TYPE') ;

Line 432: l_return_status := OKL_API.G_RET_STS_ERROR;

428:
429: IF (p_cfov_rec.oty_code = OKL_API.G_MISS_CHAR OR p_cfov_rec.oty_code IS NULL)
430: THEN
431: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'oty_code');
432: l_return_status := OKL_API.G_RET_STS_ERROR;
433: ELSE
434: -- enforce foreign key
435: OPEN okl_cfov_oty_fk_csr(p_cfov_rec.oty_code, 'OKL_CF_OBJECT_TYPE') ;
436: FETCH okl_cfov_oty_fk_csr into l_dummy_var ;

Line 456: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

452: x_return_status := l_return_status;
453: EXCEPTION
454:
455: WHEN OTHERS THEN
456: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
457: ,p_msg_name => G_UNEXPECTED_ERROR
458: ,p_token1 => G_SQLCODE_TOKEN
459: ,p_token1_value => SQLCODE
460: ,p_token2 => G_SQLERRM_TOKEN

Line 462: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

458: ,p_token1 => G_SQLCODE_TOKEN
459: ,p_token1_value => SQLCODE
460: ,p_token2 => G_SQLERRM_TOKEN
461: ,p_token2_value => SQLERRM);
462: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
463: END validate_oty_code;
464: -------------------------------------------
465: -- Validate_Attributes for: SOURCE_TABLE --
466: -------------------------------------------

Line 473: IF (p_cfov_rec.source_table = OKL_API.G_MISS_CHAR OR p_cfov_rec.source_table IS NULL)

469: x_return_status OUT NOCOPY VARCHAR2) IS
470: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
471: BEGIN
472:
473: IF (p_cfov_rec.source_table = OKL_API.G_MISS_CHAR OR p_cfov_rec.source_table IS NULL)
474: THEN
475: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'source_table');
476: l_return_status := OKL_API.G_RET_STS_ERROR;
477:

Line 475: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'source_table');

471: BEGIN
472:
473: IF (p_cfov_rec.source_table = OKL_API.G_MISS_CHAR OR p_cfov_rec.source_table IS NULL)
474: THEN
475: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'source_table');
476: l_return_status := OKL_API.G_RET_STS_ERROR;
477:
478: END IF;
479: x_return_status := l_return_status;

Line 476: l_return_status := OKL_API.G_RET_STS_ERROR;

472:
473: IF (p_cfov_rec.source_table = OKL_API.G_MISS_CHAR OR p_cfov_rec.source_table IS NULL)
474: THEN
475: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'source_table');
476: l_return_status := OKL_API.G_RET_STS_ERROR;
477:
478: END IF;
479: x_return_status := l_return_status;
480: EXCEPTION

Line 483: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

479: x_return_status := l_return_status;
480: EXCEPTION
481:
482: WHEN OTHERS THEN
483: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
484: ,p_msg_name => G_UNEXPECTED_ERROR
485: ,p_token1 => G_SQLCODE_TOKEN
486: ,p_token1_value => SQLCODE
487: ,p_token2 => G_SQLERRM_TOKEN

Line 489: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

485: ,p_token1 => G_SQLCODE_TOKEN
486: ,p_token1_value => SQLCODE
487: ,p_token2 => G_SQLERRM_TOKEN
488: ,p_token2_value => SQLERRM);
489: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
490: END validate_source_table;
491: ----------------------------------------
492: -- Validate_Attributes for: SOURCE_ID --
493: ----------------------------------------

Line 500: IF (p_cfov_rec.source_id = OKL_API.G_MISS_NUM OR p_cfov_rec.source_id IS NULL)

496: x_return_status OUT NOCOPY VARCHAR2) IS
497: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
498: BEGIN
499:
500: IF (p_cfov_rec.source_id = OKL_API.G_MISS_NUM OR p_cfov_rec.source_id IS NULL)
501: THEN
502: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'source_id');
503: l_return_status := OKL_API.G_RET_STS_ERROR;
504:

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

498: BEGIN
499:
500: IF (p_cfov_rec.source_id = OKL_API.G_MISS_NUM OR p_cfov_rec.source_id IS NULL)
501: THEN
502: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'source_id');
503: l_return_status := OKL_API.G_RET_STS_ERROR;
504:
505: END IF;
506: x_return_status := l_return_status;

Line 503: l_return_status := OKL_API.G_RET_STS_ERROR;

499:
500: IF (p_cfov_rec.source_id = OKL_API.G_MISS_NUM OR p_cfov_rec.source_id IS NULL)
501: THEN
502: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'source_id');
503: l_return_status := OKL_API.G_RET_STS_ERROR;
504:
505: END IF;
506: x_return_status := l_return_status;
507: EXCEPTION

Line 510: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

506: x_return_status := l_return_status;
507: EXCEPTION
508:
509: WHEN OTHERS THEN
510: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
511: ,p_msg_name => G_UNEXPECTED_ERROR
512: ,p_token1 => G_SQLCODE_TOKEN
513: ,p_token1_value => SQLCODE
514: ,p_token2 => G_SQLERRM_TOKEN

Line 516: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

512: ,p_token1 => G_SQLCODE_TOKEN
513: ,p_token1_value => SQLCODE
514: ,p_token2 => G_SQLERRM_TOKEN
515: ,p_token2_value => SQLERRM);
516: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
517: END validate_source_id;
518: ---------------------------------------------------------------------------
519: -- FUNCTION Validate_Attributes
520: ---------------------------------------------------------------------------

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

523: -----------------------------------------------------
524: FUNCTION Validate_Attributes (
525: p_cfov_rec IN cfov_rec_type
526: ) RETURN VARCHAR2 IS
527: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
528: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
529: BEGIN
530: -----------------------------
531: -- Column Level Validation --

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

524: FUNCTION Validate_Attributes (
525: p_cfov_rec IN cfov_rec_type
526: ) RETURN VARCHAR2 IS
527: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
528: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
529: BEGIN
530: -----------------------------
531: -- Column Level Validation --
532: -----------------------------

Line 590: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

586: EXCEPTION
587: WHEN G_EXCEPTION_HALT_VALIDATION THEN
588: RETURN(x_return_status);
589: WHEN OTHERS THEN
590: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
591: ,p_msg_name => G_UNEXPECTED_ERROR
592: ,p_token1 => G_SQLCODE_TOKEN
593: ,p_token1_value => SQLCODE
594: ,p_token2 => G_SQLERRM_TOKEN

Line 596: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

592: ,p_token1 => G_SQLCODE_TOKEN
593: ,p_token1_value => SQLCODE
594: ,p_token2 => G_SQLERRM_TOKEN
595: ,p_token2_value => SQLERRM);
596: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
597: RETURN(x_return_status);
598: END Validate_Attributes;
599: ---------------------------------------------------------------------------
600: -- PROCEDURE Validate_Record

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

606: FUNCTION Validate_Record (
607: p_cfov_rec IN cfov_rec_type,
608: p_db_cfov_rec IN cfov_rec_type
609: ) RETURN VARCHAR2 IS
610: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
611:
612: ------------------------------------
613: -- FUNCTION validate_foreign_keys --
614: ------------------------------------

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

622: FROM Fnd_Lookup_Values
623: WHERE fnd_lookup_values.lookup_code = p_lookup_code;
624: l_okl_cfov_oty_fk okl_cfov_oty_fk_csr%ROWTYPE;
625:
626: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
627: l_row_notfound BOOLEAN := TRUE;
628: BEGIN
629: IF ((p_cfov_rec.OTY_CODE IS NOT NULL)
630: AND

Line 638: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'OTY_CODE');

634: FETCH okl_cfov_oty_fk_csr INTO l_okl_cfov_oty_fk;
635: l_row_notfound := okl_cfov_oty_fk_csr%NOTFOUND;
636: CLOSE okl_cfov_oty_fk_csr;
637: IF (l_row_notfound) THEN
638: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'OTY_CODE');
639: RAISE item_not_found_error;
640: END IF;
641: END IF;
642: RETURN (l_return_status);

Line 645: l_return_status := OKL_API.G_RET_STS_ERROR;

641: END IF;
642: RETURN (l_return_status);
643: EXCEPTION
644: WHEN item_not_found_error THEN
645: l_return_status := OKL_API.G_RET_STS_ERROR;
646: RETURN (l_return_status);
647: END validate_foreign_keys;
648:
649:

Line 653: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;

649:
650: FUNCTION validate_unique_keys (
651: p_cfov_rec IN cfov_rec_type
652: ) RETURN VARCHAR2 IS
653: l_return_status VARCHAR2(1) := okl_api.G_RET_STS_SUCCESS;
654: l_dummy VARCHAR2(1) := NULL;
655: l_lookup_meaning fnd_lookups.meaning%TYPE := NULL;
656: CURSOR okl_cash_flow_objects_csr(p_id NUMBER, p_source_table VARCHAR2, p_source_id NUMBER) IS
657: SELECT 'x'

Line 675: okl_api.SET_MESSAGE( p_app_name => 'OKL'

671: p_lookup_code => p_cfov_rec.oty_code,
672: p_validate_yn => 'Y');
673:
674: -- Cash Flow Object already exists for this OBJ_TYPE.
675: okl_api.SET_MESSAGE( p_app_name => 'OKL'
676: ,p_msg_name => 'OKL_AM_CF_OBJ_EXISTS'
677: ,p_token1 => 'OBJ_TYPE'
678: ,p_token1_value => l_lookup_meaning
679: );

Line 681: l_return_status := okl_api.G_RET_STS_ERROR;

677: ,p_token1 => 'OBJ_TYPE'
678: ,p_token1_value => l_lookup_meaning
679: );
680:
681: l_return_status := okl_api.G_RET_STS_ERROR;
682: END IF;
683: RETURN l_return_status;
684: END validate_unique_keys;
685: BEGIN

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

689: END Validate_Record;
690: FUNCTION Validate_Record (
691: p_cfov_rec IN cfov_rec_type
692: ) RETURN VARCHAR2 IS
693: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
694: l_db_cfov_rec cfov_rec_type := get_rec(p_cfov_rec);
695: BEGIN
696: l_return_status := Validate_Record(p_cfov_rec => p_cfov_rec,
697: p_db_cfov_rec => l_db_cfov_rec);

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

781: p_cfov_rec IN cfov_rec_type) IS
782:
783: l_api_version CONSTANT NUMBER := 1;
784: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
785: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
786: l_cfov_rec cfov_rec_type := p_cfov_rec;
787: l_cfo_rec cfo_rec_type;
788: l_cfo_rec cfo_rec_type;
789: BEGIN

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

786: l_cfov_rec cfov_rec_type := p_cfov_rec;
787: l_cfo_rec cfo_rec_type;
788: l_cfo_rec cfo_rec_type;
789: BEGIN
790: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
791: G_PKG_NAME,
792: p_init_msg_list,
793: l_api_version,
794: p_api_version,

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

793: l_api_version,
794: p_api_version,
795: '_PVT',
796: x_return_status);
797: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
798: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
799: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
800: RAISE OKL_API.G_EXCEPTION_ERROR;
801: END IF;

Line 798: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

794: p_api_version,
795: '_PVT',
796: x_return_status);
797: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
798: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
799: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
800: RAISE OKL_API.G_EXCEPTION_ERROR;
801: END IF;
802: --- Validate all non-missing attributes (Item Level Validation)

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

795: '_PVT',
796: x_return_status);
797: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
798: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
799: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
800: RAISE OKL_API.G_EXCEPTION_ERROR;
801: END IF;
802: --- Validate all non-missing attributes (Item Level Validation)
803: l_return_status := Validate_Attributes(l_cfov_rec);

Line 800: RAISE OKL_API.G_EXCEPTION_ERROR;

796: x_return_status);
797: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
798: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
799: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
800: RAISE OKL_API.G_EXCEPTION_ERROR;
801: END IF;
802: --- Validate all non-missing attributes (Item Level Validation)
803: l_return_status := Validate_Attributes(l_cfov_rec);
804: --- If any errors happen abort API

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

801: END IF;
802: --- Validate all non-missing attributes (Item Level Validation)
803: l_return_status := Validate_Attributes(l_cfov_rec);
804: --- If any errors happen abort API
805: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
806: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
807: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
808: RAISE OKL_API.G_EXCEPTION_ERROR;
809: END IF;

Line 806: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

802: --- Validate all non-missing attributes (Item Level Validation)
803: l_return_status := Validate_Attributes(l_cfov_rec);
804: --- If any errors happen abort API
805: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
806: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
807: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
808: RAISE OKL_API.G_EXCEPTION_ERROR;
809: END IF;
810:

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

803: l_return_status := Validate_Attributes(l_cfov_rec);
804: --- If any errors happen abort API
805: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
806: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
807: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
808: RAISE OKL_API.G_EXCEPTION_ERROR;
809: END IF;
810:
811: /*

Line 808: RAISE OKL_API.G_EXCEPTION_ERROR;

804: --- If any errors happen abort API
805: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
806: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
807: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
808: RAISE OKL_API.G_EXCEPTION_ERROR;
809: END IF;
810:
811: /*
812: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,

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

812: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
813: -- which has been moved to individaul validate attribute procedures
814:
815: l_return_status := Validate_Record(l_cfov_rec); -- validates unique keys
816: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
817: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
818: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
819: RAISE OKL_API.G_EXCEPTION_ERROR;
820: END IF;

Line 817: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

813: -- which has been moved to individaul validate attribute procedures
814:
815: l_return_status := Validate_Record(l_cfov_rec); -- validates unique keys
816: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
817: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
818: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
819: RAISE OKL_API.G_EXCEPTION_ERROR;
820: END IF;
821: */

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

814:
815: l_return_status := Validate_Record(l_cfov_rec); -- validates unique keys
816: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
817: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
818: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
819: RAISE OKL_API.G_EXCEPTION_ERROR;
820: END IF;
821: */
822:

Line 819: RAISE OKL_API.G_EXCEPTION_ERROR;

815: l_return_status := Validate_Record(l_cfov_rec); -- validates unique keys
816: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
817: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
818: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
819: RAISE OKL_API.G_EXCEPTION_ERROR;
820: END IF;
821: */
822:
823: x_return_status := l_return_status;

Line 825: WHEN OKL_API.G_EXCEPTION_ERROR THEN

821: */
822:
823: x_return_status := l_return_status;
824: EXCEPTION
825: WHEN OKL_API.G_EXCEPTION_ERROR THEN
826: x_return_status := OKL_API.HANDLE_EXCEPTIONS
827: (
828: l_api_name,
829: G_PKG_NAME,

Line 826: x_return_status := OKL_API.HANDLE_EXCEPTIONS

822:
823: x_return_status := l_return_status;
824: EXCEPTION
825: WHEN OKL_API.G_EXCEPTION_ERROR THEN
826: x_return_status := OKL_API.HANDLE_EXCEPTIONS
827: (
828: l_api_name,
829: G_PKG_NAME,
830: 'OKL_API.G_RET_STS_ERROR',

Line 830: 'OKL_API.G_RET_STS_ERROR',

826: x_return_status := OKL_API.HANDLE_EXCEPTIONS
827: (
828: l_api_name,
829: G_PKG_NAME,
830: 'OKL_API.G_RET_STS_ERROR',
831: x_msg_count,
832: x_msg_data,
833: '_PVT'
834: );

Line 835: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

831: x_msg_count,
832: x_msg_data,
833: '_PVT'
834: );
835: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
836: x_return_status := OKL_API.HANDLE_EXCEPTIONS
837: (
838: l_api_name,
839: G_PKG_NAME,

Line 836: x_return_status := OKL_API.HANDLE_EXCEPTIONS

832: x_msg_data,
833: '_PVT'
834: );
835: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
836: x_return_status := OKL_API.HANDLE_EXCEPTIONS
837: (
838: l_api_name,
839: G_PKG_NAME,
840: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 840: 'OKL_API.G_RET_STS_UNEXP_ERROR',

836: x_return_status := OKL_API.HANDLE_EXCEPTIONS
837: (
838: l_api_name,
839: G_PKG_NAME,
840: 'OKL_API.G_RET_STS_UNEXP_ERROR',
841: x_msg_count,
842: x_msg_data,
843: '_PVT'
844: );

Line 846: x_return_status := OKL_API.HANDLE_EXCEPTIONS

842: x_msg_data,
843: '_PVT'
844: );
845: WHEN OTHERS THEN
846: x_return_status := OKL_API.HANDLE_EXCEPTIONS
847: (
848: l_api_name,
849: G_PKG_NAME,
850: 'OTHERS',

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

862: x_return_status OUT NOCOPY VARCHAR2,
863: x_msg_count OUT NOCOPY NUMBER,
864: x_msg_data OUT NOCOPY VARCHAR2,
865: p_cfov_tbl IN cfov_tbl_type,
866: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
867:
868: l_api_version CONSTANT NUMBER := 1;
869: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
870: i NUMBER := 0;

Line 872: OKL_API.init_msg_list(p_init_msg_list);

868: l_api_version CONSTANT NUMBER := 1;
869: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
870: i NUMBER := 0;
871: BEGIN
872: OKL_API.init_msg_list(p_init_msg_list);
873: -- Make sure PL/SQL table has records in it before passing
874: IF (p_cfov_tbl.COUNT > 0) THEN
875: i := p_cfov_tbl.FIRST;
876: LOOP

Line 878: l_error_rec OKL_API.ERROR_REC_TYPE;

874: IF (p_cfov_tbl.COUNT > 0) THEN
875: i := p_cfov_tbl.FIRST;
876: LOOP
877: DECLARE
878: l_error_rec OKL_API.ERROR_REC_TYPE;
879: BEGIN
880: l_error_rec.api_name := l_api_name;
881: l_error_rec.api_package := G_PKG_NAME;
882: l_error_rec.idx := i;

Line 885: p_init_msg_list => OKL_API.G_FALSE,

881: l_error_rec.api_package := G_PKG_NAME;
882: l_error_rec.idx := i;
883: validate_row (
884: p_api_version => p_api_version,
885: p_init_msg_list => OKL_API.G_FALSE,
886: x_return_status => l_error_rec.error_type,
887: x_msg_count => l_error_rec.msg_count,
888: x_msg_data => l_error_rec.msg_data,
889: p_cfov_rec => p_cfov_tbl(i));

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

886: x_return_status => l_error_rec.error_type,
887: x_msg_count => l_error_rec.msg_count,
888: x_msg_data => l_error_rec.msg_data,
889: p_cfov_rec => p_cfov_tbl(i));
890: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
891: l_error_rec.sqlcode := SQLCODE;
892: load_error_tbl(l_error_rec, px_error_tbl);
893: ELSE
894: x_msg_count := l_error_rec.msg_count;

Line 898: WHEN OKL_API.G_EXCEPTION_ERROR THEN

894: x_msg_count := l_error_rec.msg_count;
895: x_msg_data := l_error_rec.msg_data;
896: END IF;
897: EXCEPTION
898: WHEN OKL_API.G_EXCEPTION_ERROR THEN
899: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
900: l_error_rec.sqlcode := SQLCODE;
901: load_error_tbl(l_error_rec, px_error_tbl);
902: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

895: x_msg_data := l_error_rec.msg_data;
896: END IF;
897: EXCEPTION
898: WHEN OKL_API.G_EXCEPTION_ERROR THEN
899: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
900: l_error_rec.sqlcode := SQLCODE;
901: load_error_tbl(l_error_rec, px_error_tbl);
902: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
903: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 902: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

898: WHEN OKL_API.G_EXCEPTION_ERROR THEN
899: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
900: l_error_rec.sqlcode := SQLCODE;
901: load_error_tbl(l_error_rec, px_error_tbl);
902: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
903: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
904: l_error_rec.sqlcode := SQLCODE;
905: load_error_tbl(l_error_rec, px_error_tbl);
906: WHEN OTHERS THEN

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

899: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
900: l_error_rec.sqlcode := SQLCODE;
901: load_error_tbl(l_error_rec, px_error_tbl);
902: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
903: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
904: l_error_rec.sqlcode := SQLCODE;
905: load_error_tbl(l_error_rec, px_error_tbl);
906: WHEN OTHERS THEN
907: l_error_rec.error_type := 'OTHERS';

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

914: END IF;
915: -- Loop through the error_tbl to find the error with the highest severity
916: -- and return it.
917: x_return_status := find_highest_exception(px_error_tbl);
918: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
919: EXCEPTION
920: WHEN OKL_API.G_EXCEPTION_ERROR THEN
921: x_return_status := OKL_API.HANDLE_EXCEPTIONS
922: (

Line 920: WHEN OKL_API.G_EXCEPTION_ERROR THEN

916: -- and return it.
917: x_return_status := find_highest_exception(px_error_tbl);
918: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
919: EXCEPTION
920: WHEN OKL_API.G_EXCEPTION_ERROR THEN
921: x_return_status := OKL_API.HANDLE_EXCEPTIONS
922: (
923: l_api_name,
924: G_PKG_NAME,

Line 921: x_return_status := OKL_API.HANDLE_EXCEPTIONS

917: x_return_status := find_highest_exception(px_error_tbl);
918: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
919: EXCEPTION
920: WHEN OKL_API.G_EXCEPTION_ERROR THEN
921: x_return_status := OKL_API.HANDLE_EXCEPTIONS
922: (
923: l_api_name,
924: G_PKG_NAME,
925: 'OKL_API.G_RET_STS_ERROR',

Line 925: 'OKL_API.G_RET_STS_ERROR',

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

Line 930: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 931: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 935: 'OKL_API.G_RET_STS_UNEXP_ERROR',

931: x_return_status := OKL_API.HANDLE_EXCEPTIONS
932: (
933: l_api_name,
934: G_PKG_NAME,
935: 'OKL_API.G_RET_STS_UNEXP_ERROR',
936: x_msg_count,
937: x_msg_data,
938: '_PVT'
939: );

Line 941: x_return_status := OKL_API.HANDLE_EXCEPTIONS

937: x_msg_data,
938: '_PVT'
939: );
940: WHEN OTHERS THEN
941: x_return_status := OKL_API.HANDLE_EXCEPTIONS
942: (
943: l_api_name,
944: G_PKG_NAME,
945: 'OTHERS',

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

961: p_cfov_tbl IN cfov_tbl_type) IS
962:
963: l_api_version CONSTANT NUMBER := 1;
964: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
965: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
966: l_error_tbl OKL_API.ERROR_TBL_TYPE;
967: BEGIN
968: OKL_API.init_msg_list(p_init_msg_list);
969: -- Make sure PL/SQL table has records in it before passing

Line 966: l_error_tbl OKL_API.ERROR_TBL_TYPE;

962:
963: l_api_version CONSTANT NUMBER := 1;
964: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
965: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
966: l_error_tbl OKL_API.ERROR_TBL_TYPE;
967: BEGIN
968: OKL_API.init_msg_list(p_init_msg_list);
969: -- Make sure PL/SQL table has records in it before passing
970: IF (p_cfov_tbl.COUNT > 0) THEN

Line 968: OKL_API.init_msg_list(p_init_msg_list);

964: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
965: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
966: l_error_tbl OKL_API.ERROR_TBL_TYPE;
967: BEGIN
968: OKL_API.init_msg_list(p_init_msg_list);
969: -- Make sure PL/SQL table has records in it before passing
970: IF (p_cfov_tbl.COUNT > 0) THEN
971: validate_row (
972: p_api_version => p_api_version,

Line 973: p_init_msg_list => OKL_API.G_FALSE,

969: -- Make sure PL/SQL table has records in it before passing
970: IF (p_cfov_tbl.COUNT > 0) THEN
971: validate_row (
972: p_api_version => p_api_version,
973: p_init_msg_list => OKL_API.G_FALSE,
974: x_return_status => x_return_status,
975: x_msg_count => x_msg_count,
976: x_msg_data => x_msg_data,
977: p_cfov_tbl => p_cfov_tbl,

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

976: x_msg_data => x_msg_data,
977: p_cfov_tbl => p_cfov_tbl,
978: px_error_tbl => l_error_tbl);
979: END IF;
980: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
981: EXCEPTION
982: WHEN OKL_API.G_EXCEPTION_ERROR THEN
983: x_return_status := OKL_API.HANDLE_EXCEPTIONS
984: (

Line 982: WHEN OKL_API.G_EXCEPTION_ERROR THEN

978: px_error_tbl => l_error_tbl);
979: END IF;
980: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
981: EXCEPTION
982: WHEN OKL_API.G_EXCEPTION_ERROR THEN
983: x_return_status := OKL_API.HANDLE_EXCEPTIONS
984: (
985: l_api_name,
986: G_PKG_NAME,

Line 983: x_return_status := OKL_API.HANDLE_EXCEPTIONS

979: END IF;
980: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
981: EXCEPTION
982: WHEN OKL_API.G_EXCEPTION_ERROR THEN
983: x_return_status := OKL_API.HANDLE_EXCEPTIONS
984: (
985: l_api_name,
986: G_PKG_NAME,
987: 'OKL_API.G_RET_STS_ERROR',

Line 987: 'OKL_API.G_RET_STS_ERROR',

983: x_return_status := OKL_API.HANDLE_EXCEPTIONS
984: (
985: l_api_name,
986: G_PKG_NAME,
987: 'OKL_API.G_RET_STS_ERROR',
988: x_msg_count,
989: x_msg_data,
990: '_PVT'
991: );

Line 992: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 993: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 997: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1003: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1026: x_cfo_rec OUT NOCOPY cfo_rec_type) IS
1027:
1028: l_api_version CONSTANT NUMBER := 1;
1029: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1030: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1031: l_cfo_rec cfo_rec_type := p_cfo_rec;
1032: l_def_cfo_rec cfo_rec_type;
1033: ----------------------------------------------
1034: -- Set_Attributes for:OKL_CASH_FLOW_OBJECTS --

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

1036: FUNCTION Set_Attributes (
1037: p_cfo_rec IN cfo_rec_type,
1038: x_cfo_rec OUT NOCOPY cfo_rec_type
1039: ) RETURN VARCHAR2 IS
1040: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1041: BEGIN
1042: x_cfo_rec := p_cfo_rec;
1043: RETURN(l_return_status);
1044: END Set_Attributes;

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

1042: x_cfo_rec := p_cfo_rec;
1043: RETURN(l_return_status);
1044: END Set_Attributes;
1045: BEGIN
1046: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1047: p_init_msg_list,
1048: '_PVT',
1049: x_return_status);
1050: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1046: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1047: p_init_msg_list,
1048: '_PVT',
1049: x_return_status);
1050: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1052: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1053: RAISE OKL_API.G_EXCEPTION_ERROR;
1054: END IF;

Line 1051: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1047: p_init_msg_list,
1048: '_PVT',
1049: x_return_status);
1050: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1052: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1053: RAISE OKL_API.G_EXCEPTION_ERROR;
1054: END IF;
1055: --- Setting item atributes

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

1048: '_PVT',
1049: x_return_status);
1050: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1052: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1053: RAISE OKL_API.G_EXCEPTION_ERROR;
1054: END IF;
1055: --- Setting item atributes
1056: l_return_status := Set_Attributes(

Line 1053: RAISE OKL_API.G_EXCEPTION_ERROR;

1049: x_return_status);
1050: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1052: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1053: RAISE OKL_API.G_EXCEPTION_ERROR;
1054: END IF;
1055: --- Setting item atributes
1056: l_return_status := Set_Attributes(
1057: p_cfo_rec, -- IN

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

1056: l_return_status := Set_Attributes(
1057: p_cfo_rec, -- IN
1058: l_cfo_rec); -- OUT
1059: --- If any errors happen abort API
1060: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1062: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1063: RAISE OKL_API.G_EXCEPTION_ERROR;
1064: END IF;

Line 1061: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1057: p_cfo_rec, -- IN
1058: l_cfo_rec); -- OUT
1059: --- If any errors happen abort API
1060: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1062: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1063: RAISE OKL_API.G_EXCEPTION_ERROR;
1064: END IF;
1065: INSERT INTO OKL_CASH_FLOW_OBJECTS(

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

1058: l_cfo_rec); -- OUT
1059: --- If any errors happen abort API
1060: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1062: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1063: RAISE OKL_API.G_EXCEPTION_ERROR;
1064: END IF;
1065: INSERT INTO OKL_CASH_FLOW_OBJECTS(
1066: id,

Line 1063: RAISE OKL_API.G_EXCEPTION_ERROR;

1059: --- If any errors happen abort API
1060: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1062: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1063: RAISE OKL_API.G_EXCEPTION_ERROR;
1064: END IF;
1065: INSERT INTO OKL_CASH_FLOW_OBJECTS(
1066: id,
1067: oty_code,

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

1118: l_cfo_rec.object_version_number);
1119: -- Set OUT values
1120: x_cfo_rec := l_cfo_rec;
1121: x_return_status := l_return_status;
1122: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1123: EXCEPTION
1124: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1125: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1126: (

Line 1124: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1120: x_cfo_rec := l_cfo_rec;
1121: x_return_status := l_return_status;
1122: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1123: EXCEPTION
1124: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1125: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1126: (
1127: l_api_name,
1128: G_PKG_NAME,

Line 1125: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1121: x_return_status := l_return_status;
1122: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1123: EXCEPTION
1124: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1125: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1126: (
1127: l_api_name,
1128: G_PKG_NAME,
1129: 'OKL_API.G_RET_STS_ERROR',

Line 1129: 'OKL_API.G_RET_STS_ERROR',

1125: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1126: (
1127: l_api_name,
1128: G_PKG_NAME,
1129: 'OKL_API.G_RET_STS_ERROR',
1130: x_msg_count,
1131: x_msg_data,
1132: '_PVT'
1133: );

Line 1134: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1130: x_msg_count,
1131: x_msg_data,
1132: '_PVT'
1133: );
1134: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1135: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1136: (
1137: l_api_name,
1138: G_PKG_NAME,

Line 1135: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1131: x_msg_data,
1132: '_PVT'
1133: );
1134: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1135: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1136: (
1137: l_api_name,
1138: G_PKG_NAME,
1139: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1139: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1135: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1136: (
1137: l_api_name,
1138: G_PKG_NAME,
1139: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1140: x_msg_count,
1141: x_msg_data,
1142: '_PVT'
1143: );

Line 1145: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1141: x_msg_data,
1142: '_PVT'
1143: );
1144: WHEN OTHERS THEN
1145: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1146: (
1147: l_api_name,
1148: G_PKG_NAME,
1149: 'OTHERS',

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

1165: x_cfov_rec OUT NOCOPY cfov_rec_type) IS
1166:
1167: l_api_version CONSTANT NUMBER := 1;
1168: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1169: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1170: l_cfov_rec cfov_rec_type := p_cfov_rec;
1171: l_def_cfov_rec cfov_rec_type;
1172: l_cfo_rec cfo_rec_type;
1173: lx_cfo_rec cfo_rec_type;

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

1192: FUNCTION Set_Attributes (
1193: p_cfov_rec IN cfov_rec_type,
1194: x_cfov_rec OUT NOCOPY cfov_rec_type
1195: ) RETURN VARCHAR2 IS
1196: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1197: BEGIN
1198: x_cfov_rec := p_cfov_rec;
1199: x_cfov_rec.OBJECT_VERSION_NUMBER := 1;
1200: RETURN(l_return_status);

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

1199: x_cfov_rec.OBJECT_VERSION_NUMBER := 1;
1200: RETURN(l_return_status);
1201: END Set_Attributes;
1202: BEGIN
1203: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1204: G_PKG_NAME,
1205: p_init_msg_list,
1206: l_api_version,
1207: p_api_version,

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

1206: l_api_version,
1207: p_api_version,
1208: '_PVT',
1209: x_return_status);
1210: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1212: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1213: RAISE OKL_API.G_EXCEPTION_ERROR;
1214: END IF;

Line 1211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1207: p_api_version,
1208: '_PVT',
1209: x_return_status);
1210: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1212: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1213: RAISE OKL_API.G_EXCEPTION_ERROR;
1214: END IF;
1215: l_cfov_rec := null_out_defaults(p_cfov_rec);

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

1208: '_PVT',
1209: x_return_status);
1210: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1212: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1213: RAISE OKL_API.G_EXCEPTION_ERROR;
1214: END IF;
1215: l_cfov_rec := null_out_defaults(p_cfov_rec);
1216: -- Set primary key value

Line 1213: RAISE OKL_API.G_EXCEPTION_ERROR;

1209: x_return_status);
1210: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1211: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1212: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1213: RAISE OKL_API.G_EXCEPTION_ERROR;
1214: END IF;
1215: l_cfov_rec := null_out_defaults(p_cfov_rec);
1216: -- Set primary key value
1217: l_cfov_rec.ID := get_seq_id;

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

1219: l_return_Status := Set_Attributes(
1220: l_cfov_rec, -- IN
1221: l_def_cfov_rec); -- OUT
1222: --- If any errors happen abort API
1223: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1226: RAISE OKL_API.G_EXCEPTION_ERROR;
1227: END IF;

Line 1224: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1220: l_cfov_rec, -- IN
1221: l_def_cfov_rec); -- OUT
1222: --- If any errors happen abort API
1223: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1226: RAISE OKL_API.G_EXCEPTION_ERROR;
1227: END IF;
1228: l_def_cfov_rec := fill_who_columns(l_def_cfov_rec);

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

1221: l_def_cfov_rec); -- OUT
1222: --- If any errors happen abort API
1223: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1226: RAISE OKL_API.G_EXCEPTION_ERROR;
1227: END IF;
1228: l_def_cfov_rec := fill_who_columns(l_def_cfov_rec);
1229: --- Validate all non-missing attributes (Item Level Validation)

Line 1226: RAISE OKL_API.G_EXCEPTION_ERROR;

1222: --- If any errors happen abort API
1223: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1225: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1226: RAISE OKL_API.G_EXCEPTION_ERROR;
1227: END IF;
1228: l_def_cfov_rec := fill_who_columns(l_def_cfov_rec);
1229: --- Validate all non-missing attributes (Item Level Validation)
1230: l_return_status := Validate_Attributes(l_def_cfov_rec);

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

1228: l_def_cfov_rec := fill_who_columns(l_def_cfov_rec);
1229: --- Validate all non-missing attributes (Item Level Validation)
1230: l_return_status := Validate_Attributes(l_def_cfov_rec);
1231: --- If any errors happen abort API
1232: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1233: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1234: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1235: RAISE OKL_API.G_EXCEPTION_ERROR;
1236: END IF;

Line 1233: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1229: --- Validate all non-missing attributes (Item Level Validation)
1230: l_return_status := Validate_Attributes(l_def_cfov_rec);
1231: --- If any errors happen abort API
1232: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1233: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1234: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1235: RAISE OKL_API.G_EXCEPTION_ERROR;
1236: END IF;
1237:

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

1230: l_return_status := Validate_Attributes(l_def_cfov_rec);
1231: --- If any errors happen abort API
1232: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1233: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1234: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1235: RAISE OKL_API.G_EXCEPTION_ERROR;
1236: END IF;
1237:
1238: /*

Line 1235: RAISE OKL_API.G_EXCEPTION_ERROR;

1231: --- If any errors happen abort API
1232: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1233: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1234: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1235: RAISE OKL_API.G_EXCEPTION_ERROR;
1236: END IF;
1237:
1238: /*
1239: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,

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

1239: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
1240: -- which has been moved to individaul validate attribute procedures
1241:
1242: l_return_status := Validate_Record(l_def_cfov_rec);
1243: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1245: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1246: RAISE OKL_API.G_EXCEPTION_ERROR;
1247: END IF;

Line 1244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1240: -- which has been moved to individaul validate attribute procedures
1241:
1242: l_return_status := Validate_Record(l_def_cfov_rec);
1243: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1245: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1246: RAISE OKL_API.G_EXCEPTION_ERROR;
1247: END IF;
1248: */

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

1241:
1242: l_return_status := Validate_Record(l_def_cfov_rec);
1243: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1245: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1246: RAISE OKL_API.G_EXCEPTION_ERROR;
1247: END IF;
1248: */
1249: -----------------------------------------

Line 1246: RAISE OKL_API.G_EXCEPTION_ERROR;

1242: l_return_status := Validate_Record(l_def_cfov_rec);
1243: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1245: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1246: RAISE OKL_API.G_EXCEPTION_ERROR;
1247: END IF;
1248: */
1249: -----------------------------------------
1250: -- Move VIEW record to "Child" records --

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

1260: x_msg_data,
1261: l_cfo_rec,
1262: lx_cfo_rec
1263: );
1264: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_ERROR;
1268: END IF;

Line 1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1261: l_cfo_rec,
1262: lx_cfo_rec
1263: );
1264: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_ERROR;
1268: END IF;
1269: migrate(lx_cfo_rec, l_def_cfov_rec);

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

1262: lx_cfo_rec
1263: );
1264: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_ERROR;
1268: END IF;
1269: migrate(lx_cfo_rec, l_def_cfov_rec);
1270: -- Set OUT values

Line 1267: RAISE OKL_API.G_EXCEPTION_ERROR;

1263: );
1264: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_ERROR;
1268: END IF;
1269: migrate(lx_cfo_rec, l_def_cfov_rec);
1270: -- Set OUT values
1271: x_cfov_rec := l_def_cfov_rec;

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

1269: migrate(lx_cfo_rec, l_def_cfov_rec);
1270: -- Set OUT values
1271: x_cfov_rec := l_def_cfov_rec;
1272: x_return_status := l_return_status;
1273: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1274: EXCEPTION
1275: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1276: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1277: (

Line 1275: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1271: x_cfov_rec := l_def_cfov_rec;
1272: x_return_status := l_return_status;
1273: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1274: EXCEPTION
1275: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1276: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1277: (
1278: l_api_name,
1279: G_PKG_NAME,

Line 1276: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1272: x_return_status := l_return_status;
1273: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1274: EXCEPTION
1275: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1276: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1277: (
1278: l_api_name,
1279: G_PKG_NAME,
1280: 'OKL_API.G_RET_STS_ERROR',

Line 1280: 'OKL_API.G_RET_STS_ERROR',

1276: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1277: (
1278: l_api_name,
1279: G_PKG_NAME,
1280: 'OKL_API.G_RET_STS_ERROR',
1281: x_msg_count,
1282: x_msg_data,
1283: '_PVT'
1284: );

Line 1285: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1281: x_msg_count,
1282: x_msg_data,
1283: '_PVT'
1284: );
1285: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1286: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1287: (
1288: l_api_name,
1289: G_PKG_NAME,

Line 1286: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1282: x_msg_data,
1283: '_PVT'
1284: );
1285: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1286: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1287: (
1288: l_api_name,
1289: G_PKG_NAME,
1290: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1290: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1286: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1287: (
1288: l_api_name,
1289: G_PKG_NAME,
1290: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1291: x_msg_count,
1292: x_msg_data,
1293: '_PVT'
1294: );

Line 1296: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1313: x_msg_count OUT NOCOPY NUMBER,
1314: x_msg_data OUT NOCOPY VARCHAR2,
1315: p_cfov_tbl IN cfov_tbl_type,
1316: x_cfov_tbl OUT NOCOPY cfov_tbl_type,
1317: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1318:
1319: l_api_version CONSTANT NUMBER := 1;
1320: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1321: i NUMBER := 0;

Line 1323: OKL_API.init_msg_list(p_init_msg_list);

1319: l_api_version CONSTANT NUMBER := 1;
1320: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1321: i NUMBER := 0;
1322: BEGIN
1323: OKL_API.init_msg_list(p_init_msg_list);
1324: -- Make sure PL/SQL table has records in it before passing
1325: IF (p_cfov_tbl.COUNT > 0) THEN
1326: i := p_cfov_tbl.FIRST;
1327: LOOP

Line 1329: l_error_rec OKL_API.ERROR_REC_TYPE;

1325: IF (p_cfov_tbl.COUNT > 0) THEN
1326: i := p_cfov_tbl.FIRST;
1327: LOOP
1328: DECLARE
1329: l_error_rec OKL_API.ERROR_REC_TYPE;
1330: BEGIN
1331: l_error_rec.api_name := l_api_name;
1332: l_error_rec.api_package := G_PKG_NAME;
1333: l_error_rec.idx := i;

Line 1336: p_init_msg_list => OKL_API.G_FALSE,

1332: l_error_rec.api_package := G_PKG_NAME;
1333: l_error_rec.idx := i;
1334: insert_row (
1335: p_api_version => p_api_version,
1336: p_init_msg_list => OKL_API.G_FALSE,
1337: x_return_status => l_error_rec.error_type,
1338: x_msg_count => l_error_rec.msg_count,
1339: x_msg_data => l_error_rec.msg_data,
1340: p_cfov_rec => p_cfov_tbl(i),

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

1338: x_msg_count => l_error_rec.msg_count,
1339: x_msg_data => l_error_rec.msg_data,
1340: p_cfov_rec => p_cfov_tbl(i),
1341: x_cfov_rec => x_cfov_tbl(i));
1342: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
1343: l_error_rec.sqlcode := SQLCODE;
1344: load_error_tbl(l_error_rec, px_error_tbl);
1345: ELSE
1346: x_msg_count := l_error_rec.msg_count;

Line 1350: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1346: x_msg_count := l_error_rec.msg_count;
1347: x_msg_data := l_error_rec.msg_data;
1348: END IF;
1349: EXCEPTION
1350: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1351: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1352: l_error_rec.sqlcode := SQLCODE;
1353: load_error_tbl(l_error_rec, px_error_tbl);
1354: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

1347: x_msg_data := l_error_rec.msg_data;
1348: END IF;
1349: EXCEPTION
1350: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1351: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1352: l_error_rec.sqlcode := SQLCODE;
1353: load_error_tbl(l_error_rec, px_error_tbl);
1354: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1355: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1354: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1350: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1351: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1352: l_error_rec.sqlcode := SQLCODE;
1353: load_error_tbl(l_error_rec, px_error_tbl);
1354: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1355: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1356: l_error_rec.sqlcode := SQLCODE;
1357: load_error_tbl(l_error_rec, px_error_tbl);
1358: WHEN OTHERS THEN

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

1351: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1352: l_error_rec.sqlcode := SQLCODE;
1353: load_error_tbl(l_error_rec, px_error_tbl);
1354: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1355: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1356: l_error_rec.sqlcode := SQLCODE;
1357: load_error_tbl(l_error_rec, px_error_tbl);
1358: WHEN OTHERS THEN
1359: l_error_rec.error_type := 'OTHERS';

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

1366: END IF;
1367: -- Loop through the error_tbl to find the error with the highest severity
1368: -- and return it.
1369: x_return_status := find_highest_exception(px_error_tbl);
1370: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1371: EXCEPTION
1372: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1373: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1374: (

Line 1372: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1368: -- and return it.
1369: x_return_status := find_highest_exception(px_error_tbl);
1370: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1371: EXCEPTION
1372: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1373: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1374: (
1375: l_api_name,
1376: G_PKG_NAME,

Line 1373: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1369: x_return_status := find_highest_exception(px_error_tbl);
1370: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1371: EXCEPTION
1372: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1373: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1374: (
1375: l_api_name,
1376: G_PKG_NAME,
1377: 'OKL_API.G_RET_STS_ERROR',

Line 1377: 'OKL_API.G_RET_STS_ERROR',

1373: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1374: (
1375: l_api_name,
1376: G_PKG_NAME,
1377: 'OKL_API.G_RET_STS_ERROR',
1378: x_msg_count,
1379: x_msg_data,
1380: '_PVT'
1381: );

Line 1382: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1378: x_msg_count,
1379: x_msg_data,
1380: '_PVT'
1381: );
1382: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1383: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1384: (
1385: l_api_name,
1386: G_PKG_NAME,

Line 1383: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1379: x_msg_data,
1380: '_PVT'
1381: );
1382: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1383: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1384: (
1385: l_api_name,
1386: G_PKG_NAME,
1387: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1387: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1383: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1384: (
1385: l_api_name,
1386: G_PKG_NAME,
1387: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1388: x_msg_count,
1389: x_msg_data,
1390: '_PVT'
1391: );

Line 1393: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1416: x_cfov_tbl OUT NOCOPY cfov_tbl_type) IS
1417:
1418: l_api_version CONSTANT NUMBER := 1;
1419: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1420: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1421: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1422: BEGIN
1423: OKL_API.init_msg_list(p_init_msg_list);
1424: -- Make sure PL/SQL table has records in it before passing

Line 1421: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1417:
1418: l_api_version CONSTANT NUMBER := 1;
1419: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1420: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1421: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1422: BEGIN
1423: OKL_API.init_msg_list(p_init_msg_list);
1424: -- Make sure PL/SQL table has records in it before passing
1425: IF (p_cfov_tbl.COUNT > 0) THEN

Line 1423: OKL_API.init_msg_list(p_init_msg_list);

1419: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1420: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1421: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1422: BEGIN
1423: OKL_API.init_msg_list(p_init_msg_list);
1424: -- Make sure PL/SQL table has records in it before passing
1425: IF (p_cfov_tbl.COUNT > 0) THEN
1426: insert_row (
1427: p_api_version => p_api_version,

Line 1428: p_init_msg_list => OKL_API.G_FALSE,

1424: -- Make sure PL/SQL table has records in it before passing
1425: IF (p_cfov_tbl.COUNT > 0) THEN
1426: insert_row (
1427: p_api_version => p_api_version,
1428: p_init_msg_list => OKL_API.G_FALSE,
1429: x_return_status => x_return_status,
1430: x_msg_count => x_msg_count,
1431: x_msg_data => x_msg_data,
1432: p_cfov_tbl => p_cfov_tbl,

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

1432: p_cfov_tbl => p_cfov_tbl,
1433: x_cfov_tbl => x_cfov_tbl,
1434: px_error_tbl => l_error_tbl);
1435: END IF;
1436: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1437: EXCEPTION
1438: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1439: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1440: (

Line 1438: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 1439: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1443: 'OKL_API.G_RET_STS_ERROR',

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

Line 1448: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1449: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1453: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1459: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1482: x_cfov_tbl OUT NOCOPY cfov_tbl_type) IS
1483:
1484: l_api_version CONSTANT NUMBER := 1;
1485: l_api_name CONSTANT VARCHAR2(30) := 'insert_row_bulk';
1486: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1487: l_cfov_tbl cfov_tbl_type;
1488: l_cfov_rec cfov_rec_type;
1489:
1490: -- Arrays to store pl-sql table and pass it to bulk insert

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

1522: l_user_id NUMBER(15);
1523: l_login_id NUMBER(15);
1524:
1525: BEGIN
1526: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1527: G_PKG_NAME,
1528: p_init_msg_list,
1529: l_api_version,
1530: p_api_version,

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

1530: p_api_version,
1531: '_PVT',
1532: x_return_status);
1533:
1534: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1537: RAISE OKL_API.G_EXCEPTION_ERROR;
1538: END IF;

Line 1535: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1531: '_PVT',
1532: x_return_status);
1533:
1534: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1537: RAISE OKL_API.G_EXCEPTION_ERROR;
1538: END IF;
1539:

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

1532: x_return_status);
1533:
1534: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1537: RAISE OKL_API.G_EXCEPTION_ERROR;
1538: END IF;
1539:
1540: l_cfov_tbl := p_cfov_tbl;

Line 1537: RAISE OKL_API.G_EXCEPTION_ERROR;

1533:
1534: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1535: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1536: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1537: RAISE OKL_API.G_EXCEPTION_ERROR;
1538: END IF;
1539:
1540: l_cfov_tbl := p_cfov_tbl;
1541: i := l_cfov_tbl.FIRST;

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

1559:
1560: -- Validate all non-missing attributes (Item Level Validation)
1561: l_return_status := Validate_Attributes(l_cfov_rec);
1562: -- If any errors happen abort API
1563: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1564: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1565: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1566: RAISE OKL_API.G_EXCEPTION_ERROR;
1567: END IF;

Line 1564: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1560: -- Validate all non-missing attributes (Item Level Validation)
1561: l_return_status := Validate_Attributes(l_cfov_rec);
1562: -- If any errors happen abort API
1563: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1564: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1565: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1566: RAISE OKL_API.G_EXCEPTION_ERROR;
1567: END IF;
1568:

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

1561: l_return_status := Validate_Attributes(l_cfov_rec);
1562: -- If any errors happen abort API
1563: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1564: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1565: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1566: RAISE OKL_API.G_EXCEPTION_ERROR;
1567: END IF;
1568:
1569: j:=j+1;

Line 1566: RAISE OKL_API.G_EXCEPTION_ERROR;

1562: -- If any errors happen abort API
1563: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1564: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1565: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1566: RAISE OKL_API.G_EXCEPTION_ERROR;
1567: END IF;
1568:
1569: j:=j+1;
1570: in_id(j) := l_cfov_rec.id;

Line 1660: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1656: in_last_update_login(i),
1657: in_object_version_number(i));
1658:
1659: x_cfov_tbl := l_cfov_tbl;
1660: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1661: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1662: EXCEPTION
1663: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1664: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

1657: in_object_version_number(i));
1658:
1659: x_cfov_tbl := l_cfov_tbl;
1660: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1661: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1662: EXCEPTION
1663: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1664: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1665: (

Line 1663: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1659: x_cfov_tbl := l_cfov_tbl;
1660: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1661: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1662: EXCEPTION
1663: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1664: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1665: (
1666: l_api_name,
1667: G_PKG_NAME,

Line 1664: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1660: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1661: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1662: EXCEPTION
1663: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1664: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1665: (
1666: l_api_name,
1667: G_PKG_NAME,
1668: 'OKL_API.G_RET_STS_ERROR',

Line 1668: 'OKL_API.G_RET_STS_ERROR',

1664: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1665: (
1666: l_api_name,
1667: G_PKG_NAME,
1668: 'OKL_API.G_RET_STS_ERROR',
1669: x_msg_count,
1670: x_msg_data,
1671: '_PVT'
1672: );

Line 1673: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1674: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1670: x_msg_data,
1671: '_PVT'
1672: );
1673: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1674: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1675: (
1676: l_api_name,
1677: G_PKG_NAME,
1678: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1678: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1674: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1675: (
1676: l_api_name,
1677: G_PKG_NAME,
1678: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1679: x_msg_count,
1680: x_msg_data,
1681: '_PVT'
1682: );

Line 1684: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1680: x_msg_data,
1681: '_PVT'
1682: );
1683: WHEN OTHERS THEN
1684: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1685: (
1686: l_api_name,
1687: G_PKG_NAME,
1688: 'OTHERS',

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

1720: FROM OKL_CASH_FLOW_OBJECTS
1721: WHERE ID = p_cfo_rec.id;
1722: l_api_version CONSTANT NUMBER := 1;
1723: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1724: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1725: l_object_version_number OKL_CASH_FLOW_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;
1726: lc_object_version_number OKL_CASH_FLOW_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;
1727: l_row_notfound BOOLEAN := FALSE;
1728: lc_row_notfound BOOLEAN := FALSE;

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

1726: lc_object_version_number OKL_CASH_FLOW_OBJECTS.OBJECT_VERSION_NUMBER%TYPE;
1727: l_row_notfound BOOLEAN := FALSE;
1728: lc_row_notfound BOOLEAN := FALSE;
1729: BEGIN
1730: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1731: p_init_msg_list,
1732: '_PVT',
1733: x_return_status);
1734: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1730: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1731: p_init_msg_list,
1732: '_PVT',
1733: x_return_status);
1734: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1735: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1736: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1737: RAISE OKL_API.G_EXCEPTION_ERROR;
1738: END IF;

Line 1735: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1731: p_init_msg_list,
1732: '_PVT',
1733: x_return_status);
1734: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1735: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1736: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1737: RAISE OKL_API.G_EXCEPTION_ERROR;
1738: END IF;
1739: BEGIN

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

1732: '_PVT',
1733: x_return_status);
1734: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1735: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1736: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1737: RAISE OKL_API.G_EXCEPTION_ERROR;
1738: END IF;
1739: BEGIN
1740: OPEN lock_csr(p_cfo_rec);

Line 1737: RAISE OKL_API.G_EXCEPTION_ERROR;

1733: x_return_status);
1734: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1735: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1736: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1737: RAISE OKL_API.G_EXCEPTION_ERROR;
1738: END IF;
1739: BEGIN
1740: OPEN lock_csr(p_cfo_rec);
1741: FETCH lock_csr INTO l_object_version_number;

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

1745: WHEN E_Resource_Busy THEN
1746: IF (lock_csr%ISOPEN) THEN
1747: CLOSE lock_csr;
1748: END IF;
1749: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1750: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1751: END;
1752:
1753: IF ( l_row_notfound ) THEN

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

1756: lc_row_notfound := lchk_csr%NOTFOUND;
1757: CLOSE lchk_csr;
1758: END IF;
1759: IF (lc_row_notfound) THEN
1760: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1761: RAISE OKL_API.G_EXCEPTION_ERROR;
1762: ELSIF lc_object_version_number > p_cfo_rec.object_version_number THEN
1763: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1764: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1761: RAISE OKL_API.G_EXCEPTION_ERROR;

1757: CLOSE lchk_csr;
1758: END IF;
1759: IF (lc_row_notfound) THEN
1760: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1761: RAISE OKL_API.G_EXCEPTION_ERROR;
1762: ELSIF lc_object_version_number > p_cfo_rec.object_version_number THEN
1763: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1764: RAISE OKL_API.G_EXCEPTION_ERROR;
1765: ELSIF lc_object_version_number <> p_cfo_rec.object_version_number THEN

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

1759: IF (lc_row_notfound) THEN
1760: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1761: RAISE OKL_API.G_EXCEPTION_ERROR;
1762: ELSIF lc_object_version_number > p_cfo_rec.object_version_number THEN
1763: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1764: RAISE OKL_API.G_EXCEPTION_ERROR;
1765: ELSIF lc_object_version_number <> p_cfo_rec.object_version_number THEN
1766: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1767: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1764: RAISE OKL_API.G_EXCEPTION_ERROR;

1760: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1761: RAISE OKL_API.G_EXCEPTION_ERROR;
1762: ELSIF lc_object_version_number > p_cfo_rec.object_version_number THEN
1763: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1764: RAISE OKL_API.G_EXCEPTION_ERROR;
1765: ELSIF lc_object_version_number <> p_cfo_rec.object_version_number THEN
1766: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1767: RAISE OKL_API.G_EXCEPTION_ERROR;
1768: ELSIF lc_object_version_number = -1 THEN

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

1762: ELSIF lc_object_version_number > p_cfo_rec.object_version_number THEN
1763: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1764: RAISE OKL_API.G_EXCEPTION_ERROR;
1765: ELSIF lc_object_version_number <> p_cfo_rec.object_version_number THEN
1766: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1767: RAISE OKL_API.G_EXCEPTION_ERROR;
1768: ELSIF lc_object_version_number = -1 THEN
1769: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1770: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1767: RAISE OKL_API.G_EXCEPTION_ERROR;

1763: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1764: RAISE OKL_API.G_EXCEPTION_ERROR;
1765: ELSIF lc_object_version_number <> p_cfo_rec.object_version_number THEN
1766: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1767: RAISE OKL_API.G_EXCEPTION_ERROR;
1768: ELSIF lc_object_version_number = -1 THEN
1769: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1770: RAISE OKL_API.G_EXCEPTION_ERROR;
1771: END IF;

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

1765: ELSIF lc_object_version_number <> p_cfo_rec.object_version_number THEN
1766: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1767: RAISE OKL_API.G_EXCEPTION_ERROR;
1768: ELSIF lc_object_version_number = -1 THEN
1769: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1770: RAISE OKL_API.G_EXCEPTION_ERROR;
1771: END IF;
1772: x_return_status := l_return_status;
1773: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1770: RAISE OKL_API.G_EXCEPTION_ERROR;

1766: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1767: RAISE OKL_API.G_EXCEPTION_ERROR;
1768: ELSIF lc_object_version_number = -1 THEN
1769: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1770: RAISE OKL_API.G_EXCEPTION_ERROR;
1771: END IF;
1772: x_return_status := l_return_status;
1773: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1774: EXCEPTION

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

1769: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1770: RAISE OKL_API.G_EXCEPTION_ERROR;
1771: END IF;
1772: x_return_status := l_return_status;
1773: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1774: EXCEPTION
1775: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1776: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1777: (

Line 1775: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1771: END IF;
1772: x_return_status := l_return_status;
1773: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1774: EXCEPTION
1775: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1776: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1777: (
1778: l_api_name,
1779: G_PKG_NAME,

Line 1776: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1772: x_return_status := l_return_status;
1773: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1774: EXCEPTION
1775: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1776: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1777: (
1778: l_api_name,
1779: G_PKG_NAME,
1780: 'OKL_API.G_RET_STS_ERROR',

Line 1780: 'OKL_API.G_RET_STS_ERROR',

1776: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1777: (
1778: l_api_name,
1779: G_PKG_NAME,
1780: 'OKL_API.G_RET_STS_ERROR',
1781: x_msg_count,
1782: x_msg_data,
1783: '_PVT'
1784: );

Line 1785: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1781: x_msg_count,
1782: x_msg_data,
1783: '_PVT'
1784: );
1785: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1786: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1787: (
1788: l_api_name,
1789: G_PKG_NAME,

Line 1786: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1782: x_msg_data,
1783: '_PVT'
1784: );
1785: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1786: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1787: (
1788: l_api_name,
1789: G_PKG_NAME,
1790: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1790: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1786: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1787: (
1788: l_api_name,
1789: G_PKG_NAME,
1790: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1791: x_msg_count,
1792: x_msg_data,
1793: '_PVT'
1794: );

Line 1796: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1792: x_msg_data,
1793: '_PVT'
1794: );
1795: WHEN OTHERS THEN
1796: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1797: (
1798: l_api_name,
1799: G_PKG_NAME,
1800: 'OTHERS',

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

1815: p_cfov_rec IN cfov_rec_type) IS
1816:
1817: l_api_version CONSTANT NUMBER := 1;
1818: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1819: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1820: l_cfo_rec cfo_rec_type;
1821: BEGIN
1822: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1823: G_PKG_NAME,

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

1818: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1819: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1820: l_cfo_rec cfo_rec_type;
1821: BEGIN
1822: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1823: G_PKG_NAME,
1824: p_init_msg_list,
1825: l_api_version,
1826: p_api_version,

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

1825: l_api_version,
1826: p_api_version,
1827: '_PVT',
1828: x_return_status);
1829: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1831: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1832: RAISE OKL_API.G_EXCEPTION_ERROR;
1833: END IF;

Line 1830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1826: p_api_version,
1827: '_PVT',
1828: x_return_status);
1829: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1831: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1832: RAISE OKL_API.G_EXCEPTION_ERROR;
1833: END IF;
1834: -----------------------------------------

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

1827: '_PVT',
1828: x_return_status);
1829: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1831: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1832: RAISE OKL_API.G_EXCEPTION_ERROR;
1833: END IF;
1834: -----------------------------------------
1835: -- Move VIEW record to "Child" records --

Line 1832: RAISE OKL_API.G_EXCEPTION_ERROR;

1828: x_return_status);
1829: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1831: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1832: RAISE OKL_API.G_EXCEPTION_ERROR;
1833: END IF;
1834: -----------------------------------------
1835: -- Move VIEW record to "Child" records --
1836: -----------------------------------------

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

1844: x_msg_count,
1845: x_msg_data,
1846: l_cfo_rec
1847: );
1848: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1849: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1850: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1851: RAISE OKL_API.G_EXCEPTION_ERROR;
1852: END IF;

Line 1849: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1845: x_msg_data,
1846: l_cfo_rec
1847: );
1848: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1849: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1850: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1851: RAISE OKL_API.G_EXCEPTION_ERROR;
1852: END IF;
1853: x_return_status := l_return_status;

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

1846: l_cfo_rec
1847: );
1848: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1849: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1850: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1851: RAISE OKL_API.G_EXCEPTION_ERROR;
1852: END IF;
1853: x_return_status := l_return_status;
1854: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1851: RAISE OKL_API.G_EXCEPTION_ERROR;

1847: );
1848: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1849: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1850: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1851: RAISE OKL_API.G_EXCEPTION_ERROR;
1852: END IF;
1853: x_return_status := l_return_status;
1854: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1855: EXCEPTION

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

1850: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1851: RAISE OKL_API.G_EXCEPTION_ERROR;
1852: END IF;
1853: x_return_status := l_return_status;
1854: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1855: EXCEPTION
1856: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1857: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1858: (

Line 1856: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1852: END IF;
1853: x_return_status := l_return_status;
1854: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1855: EXCEPTION
1856: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1857: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1858: (
1859: l_api_name,
1860: G_PKG_NAME,

Line 1857: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1853: x_return_status := l_return_status;
1854: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1855: EXCEPTION
1856: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1857: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1858: (
1859: l_api_name,
1860: G_PKG_NAME,
1861: 'OKL_API.G_RET_STS_ERROR',

Line 1861: 'OKL_API.G_RET_STS_ERROR',

1857: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1858: (
1859: l_api_name,
1860: G_PKG_NAME,
1861: 'OKL_API.G_RET_STS_ERROR',
1862: x_msg_count,
1863: x_msg_data,
1864: '_PVT'
1865: );

Line 1866: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1862: x_msg_count,
1863: x_msg_data,
1864: '_PVT'
1865: );
1866: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1867: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1868: (
1869: l_api_name,
1870: G_PKG_NAME,

Line 1867: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1863: x_msg_data,
1864: '_PVT'
1865: );
1866: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1867: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1868: (
1869: l_api_name,
1870: G_PKG_NAME,
1871: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1871: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1867: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1868: (
1869: l_api_name,
1870: G_PKG_NAME,
1871: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1872: x_msg_count,
1873: x_msg_data,
1874: '_PVT'
1875: );

Line 1877: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1873: x_msg_data,
1874: '_PVT'
1875: );
1876: WHEN OTHERS THEN
1877: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1878: (
1879: l_api_name,
1880: G_PKG_NAME,
1881: 'OTHERS',

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

1893: x_return_status OUT NOCOPY VARCHAR2,
1894: x_msg_count OUT NOCOPY NUMBER,
1895: x_msg_data OUT NOCOPY VARCHAR2,
1896: p_cfov_tbl IN cfov_tbl_type,
1897: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1898:
1899: l_api_version CONSTANT NUMBER := 1;
1900: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1901: i NUMBER := 0;

Line 1903: OKL_API.init_msg_list(p_init_msg_list);

1899: l_api_version CONSTANT NUMBER := 1;
1900: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1901: i NUMBER := 0;
1902: BEGIN
1903: OKL_API.init_msg_list(p_init_msg_list);
1904: -- Make sure PL/SQL table has recrods in it before passing
1905: IF (p_cfov_tbl.COUNT > 0) THEN
1906: i := p_cfov_tbl.FIRST;
1907: LOOP

Line 1909: l_error_rec OKL_API.ERROR_REC_TYPE;

1905: IF (p_cfov_tbl.COUNT > 0) THEN
1906: i := p_cfov_tbl.FIRST;
1907: LOOP
1908: DECLARE
1909: l_error_rec OKL_API.ERROR_REC_TYPE;
1910: BEGIN
1911: l_error_rec.api_name := l_api_name;
1912: l_error_rec.api_package := G_PKG_NAME;
1913: l_error_rec.idx := i;

Line 1916: p_init_msg_list => OKL_API.G_FALSE,

1912: l_error_rec.api_package := G_PKG_NAME;
1913: l_error_rec.idx := i;
1914: lock_row(
1915: p_api_version => p_api_version,
1916: p_init_msg_list => OKL_API.G_FALSE,
1917: x_return_status => l_error_rec.error_type,
1918: x_msg_count => l_error_rec.msg_count,
1919: x_msg_data => l_error_rec.msg_data,
1920: p_cfov_rec => p_cfov_tbl(i));

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

1917: x_return_status => l_error_rec.error_type,
1918: x_msg_count => l_error_rec.msg_count,
1919: x_msg_data => l_error_rec.msg_data,
1920: p_cfov_rec => p_cfov_tbl(i));
1921: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
1922: l_error_rec.sqlcode := SQLCODE;
1923: load_error_tbl(l_error_rec, px_error_tbl);
1924: ELSE
1925: x_msg_count := l_error_rec.msg_count;

Line 1929: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1925: x_msg_count := l_error_rec.msg_count;
1926: x_msg_data := l_error_rec.msg_data;
1927: END IF;
1928: EXCEPTION
1929: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1930: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1931: l_error_rec.sqlcode := SQLCODE;
1932: load_error_tbl(l_error_rec, px_error_tbl);
1933: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

1926: x_msg_data := l_error_rec.msg_data;
1927: END IF;
1928: EXCEPTION
1929: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1930: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1931: l_error_rec.sqlcode := SQLCODE;
1932: load_error_tbl(l_error_rec, px_error_tbl);
1933: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1934: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1933: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1929: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1930: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1931: l_error_rec.sqlcode := SQLCODE;
1932: load_error_tbl(l_error_rec, px_error_tbl);
1933: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1934: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1935: l_error_rec.sqlcode := SQLCODE;
1936: load_error_tbl(l_error_rec, px_error_tbl);
1937: WHEN OTHERS THEN

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

1930: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1931: l_error_rec.sqlcode := SQLCODE;
1932: load_error_tbl(l_error_rec, px_error_tbl);
1933: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1934: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1935: l_error_rec.sqlcode := SQLCODE;
1936: load_error_tbl(l_error_rec, px_error_tbl);
1937: WHEN OTHERS THEN
1938: l_error_rec.error_type := 'OTHERS';

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

1945: END IF;
1946: -- Loop through the error_tbl to find the error with the highest severity
1947: -- and return it.
1948: x_return_status := find_highest_exception(px_error_tbl);
1949: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1950: EXCEPTION
1951: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1952: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1953: (

Line 1951: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1947: -- and return it.
1948: x_return_status := find_highest_exception(px_error_tbl);
1949: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1950: EXCEPTION
1951: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1952: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1953: (
1954: l_api_name,
1955: G_PKG_NAME,

Line 1952: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1948: x_return_status := find_highest_exception(px_error_tbl);
1949: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1950: EXCEPTION
1951: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1952: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1953: (
1954: l_api_name,
1955: G_PKG_NAME,
1956: 'OKL_API.G_RET_STS_ERROR',

Line 1956: 'OKL_API.G_RET_STS_ERROR',

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

Line 1961: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1957: x_msg_count,
1958: x_msg_data,
1959: '_PVT'
1960: );
1961: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1962: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1963: (
1964: l_api_name,
1965: G_PKG_NAME,

Line 1962: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1966: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1962: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1963: (
1964: l_api_name,
1965: G_PKG_NAME,
1966: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1967: x_msg_count,
1968: x_msg_data,
1969: '_PVT'
1970: );

Line 1972: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1968: x_msg_data,
1969: '_PVT'
1970: );
1971: WHEN OTHERS THEN
1972: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1973: (
1974: l_api_name,
1975: G_PKG_NAME,
1976: 'OTHERS',

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

1991: p_cfov_tbl IN cfov_tbl_type) IS
1992:
1993: l_api_version CONSTANT NUMBER := 1;
1994: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1995: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1996: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1997: BEGIN
1998: OKL_API.init_msg_list(p_init_msg_list);
1999: -- Make sure PL/SQL table has recrods in it before passing

Line 1996: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1992:
1993: l_api_version CONSTANT NUMBER := 1;
1994: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1995: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1996: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1997: BEGIN
1998: OKL_API.init_msg_list(p_init_msg_list);
1999: -- Make sure PL/SQL table has recrods in it before passing
2000: IF (p_cfov_tbl.COUNT > 0) THEN

Line 1998: OKL_API.init_msg_list(p_init_msg_list);

1994: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1995: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1996: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1997: BEGIN
1998: OKL_API.init_msg_list(p_init_msg_list);
1999: -- Make sure PL/SQL table has recrods in it before passing
2000: IF (p_cfov_tbl.COUNT > 0) THEN
2001: lock_row(
2002: p_api_version => p_api_version,

Line 2003: p_init_msg_list => OKL_API.G_FALSE,

1999: -- Make sure PL/SQL table has recrods in it before passing
2000: IF (p_cfov_tbl.COUNT > 0) THEN
2001: lock_row(
2002: p_api_version => p_api_version,
2003: p_init_msg_list => OKL_API.G_FALSE,
2004: x_return_status => x_return_status,
2005: x_msg_count => x_msg_count,
2006: x_msg_data => x_msg_data,
2007: p_cfov_tbl => p_cfov_tbl,

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

2006: x_msg_data => x_msg_data,
2007: p_cfov_tbl => p_cfov_tbl,
2008: px_error_tbl => l_error_tbl);
2009: END IF;
2010: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2011: EXCEPTION
2012: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2013: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2014: (

Line 2012: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2008: px_error_tbl => l_error_tbl);
2009: END IF;
2010: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2011: EXCEPTION
2012: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2013: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2014: (
2015: l_api_name,
2016: G_PKG_NAME,

Line 2013: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2009: END IF;
2010: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2011: EXCEPTION
2012: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2013: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2014: (
2015: l_api_name,
2016: G_PKG_NAME,
2017: 'OKL_API.G_RET_STS_ERROR',

Line 2017: 'OKL_API.G_RET_STS_ERROR',

2013: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2014: (
2015: l_api_name,
2016: G_PKG_NAME,
2017: 'OKL_API.G_RET_STS_ERROR',
2018: x_msg_count,
2019: x_msg_data,
2020: '_PVT'
2021: );

Line 2022: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2023: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2027: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2033: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

2055: x_cfo_rec OUT NOCOPY cfo_rec_type) IS
2056:
2057: l_api_version CONSTANT NUMBER := 1;
2058: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
2059: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2060: l_cfo_rec cfo_rec_type := p_cfo_rec;
2061: l_def_cfo_rec cfo_rec_type;
2062: l_row_notfound BOOLEAN := TRUE;
2063: ----------------------------------

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

2068: x_cfo_rec OUT NOCOPY cfo_rec_type
2069: ) RETURN VARCHAR2 IS
2070: l_cfo_rec cfo_rec_type;
2071: l_row_notfound BOOLEAN := TRUE;
2072: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2073: BEGIN
2074: x_cfo_rec := p_cfo_rec;
2075: -- Get current database values
2076: l_cfo_rec := get_rec(p_cfo_rec, l_return_status);

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

2073: BEGIN
2074: x_cfo_rec := p_cfo_rec;
2075: -- Get current database values
2076: l_cfo_rec := get_rec(p_cfo_rec, l_return_status);
2077: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2078: IF (x_cfo_rec.id = OKL_API.G_MISS_NUM)
2079: THEN
2080: x_cfo_rec.id := l_cfo_rec.id;
2081: END IF;

Line 2078: IF (x_cfo_rec.id = OKL_API.G_MISS_NUM)

2074: x_cfo_rec := p_cfo_rec;
2075: -- Get current database values
2076: l_cfo_rec := get_rec(p_cfo_rec, l_return_status);
2077: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2078: IF (x_cfo_rec.id = OKL_API.G_MISS_NUM)
2079: THEN
2080: x_cfo_rec.id := l_cfo_rec.id;
2081: END IF;
2082: IF (x_cfo_rec.oty_code = OKL_API.G_MISS_CHAR)

Line 2082: IF (x_cfo_rec.oty_code = OKL_API.G_MISS_CHAR)

2078: IF (x_cfo_rec.id = OKL_API.G_MISS_NUM)
2079: THEN
2080: x_cfo_rec.id := l_cfo_rec.id;
2081: END IF;
2082: IF (x_cfo_rec.oty_code = OKL_API.G_MISS_CHAR)
2083: THEN
2084: x_cfo_rec.oty_code := l_cfo_rec.oty_code;
2085: END IF;
2086: IF (x_cfo_rec.source_table = OKL_API.G_MISS_CHAR)

Line 2086: IF (x_cfo_rec.source_table = OKL_API.G_MISS_CHAR)

2082: IF (x_cfo_rec.oty_code = OKL_API.G_MISS_CHAR)
2083: THEN
2084: x_cfo_rec.oty_code := l_cfo_rec.oty_code;
2085: END IF;
2086: IF (x_cfo_rec.source_table = OKL_API.G_MISS_CHAR)
2087: THEN
2088: x_cfo_rec.source_table := l_cfo_rec.source_table;
2089: END IF;
2090: IF (x_cfo_rec.source_id = OKL_API.G_MISS_NUM)

Line 2090: IF (x_cfo_rec.source_id = OKL_API.G_MISS_NUM)

2086: IF (x_cfo_rec.source_table = OKL_API.G_MISS_CHAR)
2087: THEN
2088: x_cfo_rec.source_table := l_cfo_rec.source_table;
2089: END IF;
2090: IF (x_cfo_rec.source_id = OKL_API.G_MISS_NUM)
2091: THEN
2092: x_cfo_rec.source_id := l_cfo_rec.source_id;
2093: END IF;
2094: IF (x_cfo_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 2094: IF (x_cfo_rec.attribute_category = OKL_API.G_MISS_CHAR)

2090: IF (x_cfo_rec.source_id = OKL_API.G_MISS_NUM)
2091: THEN
2092: x_cfo_rec.source_id := l_cfo_rec.source_id;
2093: END IF;
2094: IF (x_cfo_rec.attribute_category = OKL_API.G_MISS_CHAR)
2095: THEN
2096: x_cfo_rec.attribute_category := l_cfo_rec.attribute_category;
2097: END IF;
2098: IF (x_cfo_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 2098: IF (x_cfo_rec.attribute1 = OKL_API.G_MISS_CHAR)

2094: IF (x_cfo_rec.attribute_category = OKL_API.G_MISS_CHAR)
2095: THEN
2096: x_cfo_rec.attribute_category := l_cfo_rec.attribute_category;
2097: END IF;
2098: IF (x_cfo_rec.attribute1 = OKL_API.G_MISS_CHAR)
2099: THEN
2100: x_cfo_rec.attribute1 := l_cfo_rec.attribute1;
2101: END IF;
2102: IF (x_cfo_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 2102: IF (x_cfo_rec.attribute2 = OKL_API.G_MISS_CHAR)

2098: IF (x_cfo_rec.attribute1 = OKL_API.G_MISS_CHAR)
2099: THEN
2100: x_cfo_rec.attribute1 := l_cfo_rec.attribute1;
2101: END IF;
2102: IF (x_cfo_rec.attribute2 = OKL_API.G_MISS_CHAR)
2103: THEN
2104: x_cfo_rec.attribute2 := l_cfo_rec.attribute2;
2105: END IF;
2106: IF (x_cfo_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 2106: IF (x_cfo_rec.attribute3 = OKL_API.G_MISS_CHAR)

2102: IF (x_cfo_rec.attribute2 = OKL_API.G_MISS_CHAR)
2103: THEN
2104: x_cfo_rec.attribute2 := l_cfo_rec.attribute2;
2105: END IF;
2106: IF (x_cfo_rec.attribute3 = OKL_API.G_MISS_CHAR)
2107: THEN
2108: x_cfo_rec.attribute3 := l_cfo_rec.attribute3;
2109: END IF;
2110: IF (x_cfo_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 2110: IF (x_cfo_rec.attribute4 = OKL_API.G_MISS_CHAR)

2106: IF (x_cfo_rec.attribute3 = OKL_API.G_MISS_CHAR)
2107: THEN
2108: x_cfo_rec.attribute3 := l_cfo_rec.attribute3;
2109: END IF;
2110: IF (x_cfo_rec.attribute4 = OKL_API.G_MISS_CHAR)
2111: THEN
2112: x_cfo_rec.attribute4 := l_cfo_rec.attribute4;
2113: END IF;
2114: IF (x_cfo_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 2114: IF (x_cfo_rec.attribute5 = OKL_API.G_MISS_CHAR)

2110: IF (x_cfo_rec.attribute4 = OKL_API.G_MISS_CHAR)
2111: THEN
2112: x_cfo_rec.attribute4 := l_cfo_rec.attribute4;
2113: END IF;
2114: IF (x_cfo_rec.attribute5 = OKL_API.G_MISS_CHAR)
2115: THEN
2116: x_cfo_rec.attribute5 := l_cfo_rec.attribute5;
2117: END IF;
2118: IF (x_cfo_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 2118: IF (x_cfo_rec.attribute6 = OKL_API.G_MISS_CHAR)

2114: IF (x_cfo_rec.attribute5 = OKL_API.G_MISS_CHAR)
2115: THEN
2116: x_cfo_rec.attribute5 := l_cfo_rec.attribute5;
2117: END IF;
2118: IF (x_cfo_rec.attribute6 = OKL_API.G_MISS_CHAR)
2119: THEN
2120: x_cfo_rec.attribute6 := l_cfo_rec.attribute6;
2121: END IF;
2122: IF (x_cfo_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 2122: IF (x_cfo_rec.attribute7 = OKL_API.G_MISS_CHAR)

2118: IF (x_cfo_rec.attribute6 = OKL_API.G_MISS_CHAR)
2119: THEN
2120: x_cfo_rec.attribute6 := l_cfo_rec.attribute6;
2121: END IF;
2122: IF (x_cfo_rec.attribute7 = OKL_API.G_MISS_CHAR)
2123: THEN
2124: x_cfo_rec.attribute7 := l_cfo_rec.attribute7;
2125: END IF;
2126: IF (x_cfo_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 2126: IF (x_cfo_rec.attribute8 = OKL_API.G_MISS_CHAR)

2122: IF (x_cfo_rec.attribute7 = OKL_API.G_MISS_CHAR)
2123: THEN
2124: x_cfo_rec.attribute7 := l_cfo_rec.attribute7;
2125: END IF;
2126: IF (x_cfo_rec.attribute8 = OKL_API.G_MISS_CHAR)
2127: THEN
2128: x_cfo_rec.attribute8 := l_cfo_rec.attribute8;
2129: END IF;
2130: IF (x_cfo_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 2130: IF (x_cfo_rec.attribute9 = OKL_API.G_MISS_CHAR)

2126: IF (x_cfo_rec.attribute8 = OKL_API.G_MISS_CHAR)
2127: THEN
2128: x_cfo_rec.attribute8 := l_cfo_rec.attribute8;
2129: END IF;
2130: IF (x_cfo_rec.attribute9 = OKL_API.G_MISS_CHAR)
2131: THEN
2132: x_cfo_rec.attribute9 := l_cfo_rec.attribute9;
2133: END IF;
2134: IF (x_cfo_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 2134: IF (x_cfo_rec.attribute10 = OKL_API.G_MISS_CHAR)

2130: IF (x_cfo_rec.attribute9 = OKL_API.G_MISS_CHAR)
2131: THEN
2132: x_cfo_rec.attribute9 := l_cfo_rec.attribute9;
2133: END IF;
2134: IF (x_cfo_rec.attribute10 = OKL_API.G_MISS_CHAR)
2135: THEN
2136: x_cfo_rec.attribute10 := l_cfo_rec.attribute10;
2137: END IF;
2138: IF (x_cfo_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 2138: IF (x_cfo_rec.attribute11 = OKL_API.G_MISS_CHAR)

2134: IF (x_cfo_rec.attribute10 = OKL_API.G_MISS_CHAR)
2135: THEN
2136: x_cfo_rec.attribute10 := l_cfo_rec.attribute10;
2137: END IF;
2138: IF (x_cfo_rec.attribute11 = OKL_API.G_MISS_CHAR)
2139: THEN
2140: x_cfo_rec.attribute11 := l_cfo_rec.attribute11;
2141: END IF;
2142: IF (x_cfo_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 2142: IF (x_cfo_rec.attribute12 = OKL_API.G_MISS_CHAR)

2138: IF (x_cfo_rec.attribute11 = OKL_API.G_MISS_CHAR)
2139: THEN
2140: x_cfo_rec.attribute11 := l_cfo_rec.attribute11;
2141: END IF;
2142: IF (x_cfo_rec.attribute12 = OKL_API.G_MISS_CHAR)
2143: THEN
2144: x_cfo_rec.attribute12 := l_cfo_rec.attribute12;
2145: END IF;
2146: IF (x_cfo_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 2146: IF (x_cfo_rec.attribute13 = OKL_API.G_MISS_CHAR)

2142: IF (x_cfo_rec.attribute12 = OKL_API.G_MISS_CHAR)
2143: THEN
2144: x_cfo_rec.attribute12 := l_cfo_rec.attribute12;
2145: END IF;
2146: IF (x_cfo_rec.attribute13 = OKL_API.G_MISS_CHAR)
2147: THEN
2148: x_cfo_rec.attribute13 := l_cfo_rec.attribute13;
2149: END IF;
2150: IF (x_cfo_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 2150: IF (x_cfo_rec.attribute14 = OKL_API.G_MISS_CHAR)

2146: IF (x_cfo_rec.attribute13 = OKL_API.G_MISS_CHAR)
2147: THEN
2148: x_cfo_rec.attribute13 := l_cfo_rec.attribute13;
2149: END IF;
2150: IF (x_cfo_rec.attribute14 = OKL_API.G_MISS_CHAR)
2151: THEN
2152: x_cfo_rec.attribute14 := l_cfo_rec.attribute14;
2153: END IF;
2154: IF (x_cfo_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 2154: IF (x_cfo_rec.attribute15 = OKL_API.G_MISS_CHAR)

2150: IF (x_cfo_rec.attribute14 = OKL_API.G_MISS_CHAR)
2151: THEN
2152: x_cfo_rec.attribute14 := l_cfo_rec.attribute14;
2153: END IF;
2154: IF (x_cfo_rec.attribute15 = OKL_API.G_MISS_CHAR)
2155: THEN
2156: x_cfo_rec.attribute15 := l_cfo_rec.attribute15;
2157: END IF;
2158: IF (x_cfo_rec.created_by = OKL_API.G_MISS_NUM)

Line 2158: IF (x_cfo_rec.created_by = OKL_API.G_MISS_NUM)

2154: IF (x_cfo_rec.attribute15 = OKL_API.G_MISS_CHAR)
2155: THEN
2156: x_cfo_rec.attribute15 := l_cfo_rec.attribute15;
2157: END IF;
2158: IF (x_cfo_rec.created_by = OKL_API.G_MISS_NUM)
2159: THEN
2160: x_cfo_rec.created_by := l_cfo_rec.created_by;
2161: END IF;
2162: IF (x_cfo_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2162: IF (x_cfo_rec.creation_date = OKL_API.G_MISS_DATE)

2158: IF (x_cfo_rec.created_by = OKL_API.G_MISS_NUM)
2159: THEN
2160: x_cfo_rec.created_by := l_cfo_rec.created_by;
2161: END IF;
2162: IF (x_cfo_rec.creation_date = OKL_API.G_MISS_DATE)
2163: THEN
2164: x_cfo_rec.creation_date := l_cfo_rec.creation_date;
2165: END IF;
2166: IF (x_cfo_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2166: IF (x_cfo_rec.last_updated_by = OKL_API.G_MISS_NUM)

2162: IF (x_cfo_rec.creation_date = OKL_API.G_MISS_DATE)
2163: THEN
2164: x_cfo_rec.creation_date := l_cfo_rec.creation_date;
2165: END IF;
2166: IF (x_cfo_rec.last_updated_by = OKL_API.G_MISS_NUM)
2167: THEN
2168: x_cfo_rec.last_updated_by := l_cfo_rec.last_updated_by;
2169: END IF;
2170: IF (x_cfo_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2170: IF (x_cfo_rec.last_update_date = OKL_API.G_MISS_DATE)

2166: IF (x_cfo_rec.last_updated_by = OKL_API.G_MISS_NUM)
2167: THEN
2168: x_cfo_rec.last_updated_by := l_cfo_rec.last_updated_by;
2169: END IF;
2170: IF (x_cfo_rec.last_update_date = OKL_API.G_MISS_DATE)
2171: THEN
2172: x_cfo_rec.last_update_date := l_cfo_rec.last_update_date;
2173: END IF;
2174: IF (x_cfo_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2174: IF (x_cfo_rec.last_update_login = OKL_API.G_MISS_NUM)

2170: IF (x_cfo_rec.last_update_date = OKL_API.G_MISS_DATE)
2171: THEN
2172: x_cfo_rec.last_update_date := l_cfo_rec.last_update_date;
2173: END IF;
2174: IF (x_cfo_rec.last_update_login = OKL_API.G_MISS_NUM)
2175: THEN
2176: x_cfo_rec.last_update_login := l_cfo_rec.last_update_login;
2177: END IF;
2178: IF (x_cfo_rec.object_version_number = OKL_API.G_MISS_NUM)

Line 2178: IF (x_cfo_rec.object_version_number = OKL_API.G_MISS_NUM)

2174: IF (x_cfo_rec.last_update_login = OKL_API.G_MISS_NUM)
2175: THEN
2176: x_cfo_rec.last_update_login := l_cfo_rec.last_update_login;
2177: END IF;
2178: IF (x_cfo_rec.object_version_number = OKL_API.G_MISS_NUM)
2179: THEN
2180: x_cfo_rec.object_version_number := l_cfo_rec.object_version_number;
2181: END IF;
2182: END IF;

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

2188: FUNCTION Set_Attributes (
2189: p_cfo_rec IN cfo_rec_type,
2190: x_cfo_rec OUT NOCOPY cfo_rec_type
2191: ) RETURN VARCHAR2 IS
2192: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2193: BEGIN
2194: x_cfo_rec := p_cfo_rec;
2195: x_cfo_rec.OBJECT_VERSION_NUMBER := p_cfo_rec.OBJECT_VERSION_NUMBER + 1;
2196: RETURN(l_return_status);

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

2195: x_cfo_rec.OBJECT_VERSION_NUMBER := p_cfo_rec.OBJECT_VERSION_NUMBER + 1;
2196: RETURN(l_return_status);
2197: END Set_Attributes;
2198: BEGIN
2199: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2200: p_init_msg_list,
2201: '_PVT',
2202: x_return_status);
2203: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

2199: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2200: p_init_msg_list,
2201: '_PVT',
2202: x_return_status);
2203: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2204: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2205: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2206: RAISE OKL_API.G_EXCEPTION_ERROR;
2207: END IF;

Line 2204: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2200: p_init_msg_list,
2201: '_PVT',
2202: x_return_status);
2203: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2204: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2205: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2206: RAISE OKL_API.G_EXCEPTION_ERROR;
2207: END IF;
2208: --- Setting item attributes

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

2201: '_PVT',
2202: x_return_status);
2203: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2204: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2205: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2206: RAISE OKL_API.G_EXCEPTION_ERROR;
2207: END IF;
2208: --- Setting item attributes
2209: l_return_status := Set_Attributes(

Line 2206: RAISE OKL_API.G_EXCEPTION_ERROR;

2202: x_return_status);
2203: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2204: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2205: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2206: RAISE OKL_API.G_EXCEPTION_ERROR;
2207: END IF;
2208: --- Setting item attributes
2209: l_return_status := Set_Attributes(
2210: p_cfo_rec, -- IN

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

2209: l_return_status := Set_Attributes(
2210: p_cfo_rec, -- IN
2211: l_cfo_rec); -- OUT
2212: --- If any errors happen abort API
2213: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2215: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2216: RAISE OKL_API.G_EXCEPTION_ERROR;
2217: END IF;

Line 2214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2210: p_cfo_rec, -- IN
2211: l_cfo_rec); -- OUT
2212: --- If any errors happen abort API
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: l_return_status := populate_new_record(l_cfo_rec, l_def_cfo_rec);

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

2211: l_cfo_rec); -- OUT
2212: --- If any errors happen abort API
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: l_return_status := populate_new_record(l_cfo_rec, l_def_cfo_rec);
2219: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2216: RAISE OKL_API.G_EXCEPTION_ERROR;

2212: --- If any errors happen abort API
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: l_return_status := populate_new_record(l_cfo_rec, l_def_cfo_rec);
2219: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2220: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2215: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2216: RAISE OKL_API.G_EXCEPTION_ERROR;
2217: END IF;
2218: l_return_status := populate_new_record(l_cfo_rec, l_def_cfo_rec);
2219: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2220: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2221: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2222: RAISE OKL_API.G_EXCEPTION_ERROR;
2223: END IF;

Line 2220: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2216: RAISE OKL_API.G_EXCEPTION_ERROR;
2217: END IF;
2218: l_return_status := populate_new_record(l_cfo_rec, l_def_cfo_rec);
2219: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2220: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2221: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2222: RAISE OKL_API.G_EXCEPTION_ERROR;
2223: END IF;
2224: UPDATE OKL_CASH_FLOW_OBJECTS

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

2217: END IF;
2218: l_return_status := populate_new_record(l_cfo_rec, l_def_cfo_rec);
2219: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2220: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2221: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2222: RAISE OKL_API.G_EXCEPTION_ERROR;
2223: END IF;
2224: UPDATE OKL_CASH_FLOW_OBJECTS
2225: SET OTY_CODE = l_def_cfo_rec.oty_code,

Line 2222: RAISE OKL_API.G_EXCEPTION_ERROR;

2218: l_return_status := populate_new_record(l_cfo_rec, l_def_cfo_rec);
2219: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2220: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2221: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2222: RAISE OKL_API.G_EXCEPTION_ERROR;
2223: END IF;
2224: UPDATE OKL_CASH_FLOW_OBJECTS
2225: SET OTY_CODE = l_def_cfo_rec.oty_code,
2226: SOURCE_TABLE = l_def_cfo_rec.source_table,

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

2250: WHERE ID = l_def_cfo_rec.id;
2251:
2252: x_cfo_rec := l_cfo_rec;
2253: x_return_status := l_return_status;
2254: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2255: EXCEPTION
2256: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2257: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2258: (

Line 2256: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2252: x_cfo_rec := l_cfo_rec;
2253: x_return_status := l_return_status;
2254: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2255: EXCEPTION
2256: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2257: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2258: (
2259: l_api_name,
2260: G_PKG_NAME,

Line 2257: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2253: x_return_status := l_return_status;
2254: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2255: EXCEPTION
2256: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2257: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2258: (
2259: l_api_name,
2260: G_PKG_NAME,
2261: 'OKL_API.G_RET_STS_ERROR',

Line 2261: 'OKL_API.G_RET_STS_ERROR',

2257: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2258: (
2259: l_api_name,
2260: G_PKG_NAME,
2261: 'OKL_API.G_RET_STS_ERROR',
2262: x_msg_count,
2263: x_msg_data,
2264: '_PVT'
2265: );

Line 2266: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2262: x_msg_count,
2263: x_msg_data,
2264: '_PVT'
2265: );
2266: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2267: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2268: (
2269: l_api_name,
2270: G_PKG_NAME,

Line 2267: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2263: x_msg_data,
2264: '_PVT'
2265: );
2266: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2267: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2268: (
2269: l_api_name,
2270: G_PKG_NAME,
2271: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2271: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2267: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2268: (
2269: l_api_name,
2270: G_PKG_NAME,
2271: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2272: x_msg_count,
2273: x_msg_data,
2274: '_PVT'
2275: );

Line 2277: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2273: x_msg_data,
2274: '_PVT'
2275: );
2276: WHEN OTHERS THEN
2277: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2278: (
2279: l_api_name,
2280: G_PKG_NAME,
2281: 'OTHERS',

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

2297: x_cfov_rec OUT NOCOPY cfov_rec_type) IS
2298:
2299: l_api_version CONSTANT NUMBER := 1;
2300: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2301: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2302: l_cfov_rec cfov_rec_type := p_cfov_rec;
2303: l_def_cfov_rec cfov_rec_type;
2304: l_db_cfov_rec cfov_rec_type;
2305: l_cfo_rec cfo_rec_type;

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

2324: p_cfov_rec IN cfov_rec_type,
2325: x_cfov_rec OUT NOCOPY cfov_rec_type
2326: ) RETURN VARCHAR2 IS
2327: l_row_notfound BOOLEAN := TRUE;
2328: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2329: BEGIN
2330: x_cfov_rec := p_cfov_rec;
2331: -- Get current database values
2332: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it

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

2331: -- Get current database values
2332: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2333: -- so it may be verified through LOCK_ROW.
2334: l_db_cfov_rec := get_rec(p_cfov_rec, l_return_status);
2335: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2336: IF (x_cfov_rec.id = OKL_API.G_MISS_NUM)
2337: THEN
2338: x_cfov_rec.id := l_db_cfov_rec.id;
2339: END IF;

Line 2336: IF (x_cfov_rec.id = OKL_API.G_MISS_NUM)

2332: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2333: -- so it may be verified through LOCK_ROW.
2334: l_db_cfov_rec := get_rec(p_cfov_rec, l_return_status);
2335: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2336: IF (x_cfov_rec.id = OKL_API.G_MISS_NUM)
2337: THEN
2338: x_cfov_rec.id := l_db_cfov_rec.id;
2339: END IF;
2340: IF (x_cfov_rec.oty_code = OKL_API.G_MISS_CHAR)

Line 2340: IF (x_cfov_rec.oty_code = OKL_API.G_MISS_CHAR)

2336: IF (x_cfov_rec.id = OKL_API.G_MISS_NUM)
2337: THEN
2338: x_cfov_rec.id := l_db_cfov_rec.id;
2339: END IF;
2340: IF (x_cfov_rec.oty_code = OKL_API.G_MISS_CHAR)
2341: THEN
2342: x_cfov_rec.oty_code := l_db_cfov_rec.oty_code;
2343: END IF;
2344: IF (x_cfov_rec.source_table = OKL_API.G_MISS_CHAR)

Line 2344: IF (x_cfov_rec.source_table = OKL_API.G_MISS_CHAR)

2340: IF (x_cfov_rec.oty_code = OKL_API.G_MISS_CHAR)
2341: THEN
2342: x_cfov_rec.oty_code := l_db_cfov_rec.oty_code;
2343: END IF;
2344: IF (x_cfov_rec.source_table = OKL_API.G_MISS_CHAR)
2345: THEN
2346: x_cfov_rec.source_table := l_db_cfov_rec.source_table;
2347: END IF;
2348: IF (x_cfov_rec.source_id = OKL_API.G_MISS_NUM)

Line 2348: IF (x_cfov_rec.source_id = OKL_API.G_MISS_NUM)

2344: IF (x_cfov_rec.source_table = OKL_API.G_MISS_CHAR)
2345: THEN
2346: x_cfov_rec.source_table := l_db_cfov_rec.source_table;
2347: END IF;
2348: IF (x_cfov_rec.source_id = OKL_API.G_MISS_NUM)
2349: THEN
2350: x_cfov_rec.source_id := l_db_cfov_rec.source_id;
2351: END IF;
2352: IF (x_cfov_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 2352: IF (x_cfov_rec.attribute_category = OKL_API.G_MISS_CHAR)

2348: IF (x_cfov_rec.source_id = OKL_API.G_MISS_NUM)
2349: THEN
2350: x_cfov_rec.source_id := l_db_cfov_rec.source_id;
2351: END IF;
2352: IF (x_cfov_rec.attribute_category = OKL_API.G_MISS_CHAR)
2353: THEN
2354: x_cfov_rec.attribute_category := l_db_cfov_rec.attribute_category;
2355: END IF;
2356: IF (x_cfov_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 2356: IF (x_cfov_rec.attribute1 = OKL_API.G_MISS_CHAR)

2352: IF (x_cfov_rec.attribute_category = OKL_API.G_MISS_CHAR)
2353: THEN
2354: x_cfov_rec.attribute_category := l_db_cfov_rec.attribute_category;
2355: END IF;
2356: IF (x_cfov_rec.attribute1 = OKL_API.G_MISS_CHAR)
2357: THEN
2358: x_cfov_rec.attribute1 := l_db_cfov_rec.attribute1;
2359: END IF;
2360: IF (x_cfov_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 2360: IF (x_cfov_rec.attribute2 = OKL_API.G_MISS_CHAR)

2356: IF (x_cfov_rec.attribute1 = OKL_API.G_MISS_CHAR)
2357: THEN
2358: x_cfov_rec.attribute1 := l_db_cfov_rec.attribute1;
2359: END IF;
2360: IF (x_cfov_rec.attribute2 = OKL_API.G_MISS_CHAR)
2361: THEN
2362: x_cfov_rec.attribute2 := l_db_cfov_rec.attribute2;
2363: END IF;
2364: IF (x_cfov_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 2364: IF (x_cfov_rec.attribute3 = OKL_API.G_MISS_CHAR)

2360: IF (x_cfov_rec.attribute2 = OKL_API.G_MISS_CHAR)
2361: THEN
2362: x_cfov_rec.attribute2 := l_db_cfov_rec.attribute2;
2363: END IF;
2364: IF (x_cfov_rec.attribute3 = OKL_API.G_MISS_CHAR)
2365: THEN
2366: x_cfov_rec.attribute3 := l_db_cfov_rec.attribute3;
2367: END IF;
2368: IF (x_cfov_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 2368: IF (x_cfov_rec.attribute4 = OKL_API.G_MISS_CHAR)

2364: IF (x_cfov_rec.attribute3 = OKL_API.G_MISS_CHAR)
2365: THEN
2366: x_cfov_rec.attribute3 := l_db_cfov_rec.attribute3;
2367: END IF;
2368: IF (x_cfov_rec.attribute4 = OKL_API.G_MISS_CHAR)
2369: THEN
2370: x_cfov_rec.attribute4 := l_db_cfov_rec.attribute4;
2371: END IF;
2372: IF (x_cfov_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 2372: IF (x_cfov_rec.attribute5 = OKL_API.G_MISS_CHAR)

2368: IF (x_cfov_rec.attribute4 = OKL_API.G_MISS_CHAR)
2369: THEN
2370: x_cfov_rec.attribute4 := l_db_cfov_rec.attribute4;
2371: END IF;
2372: IF (x_cfov_rec.attribute5 = OKL_API.G_MISS_CHAR)
2373: THEN
2374: x_cfov_rec.attribute5 := l_db_cfov_rec.attribute5;
2375: END IF;
2376: IF (x_cfov_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 2376: IF (x_cfov_rec.attribute6 = OKL_API.G_MISS_CHAR)

2372: IF (x_cfov_rec.attribute5 = OKL_API.G_MISS_CHAR)
2373: THEN
2374: x_cfov_rec.attribute5 := l_db_cfov_rec.attribute5;
2375: END IF;
2376: IF (x_cfov_rec.attribute6 = OKL_API.G_MISS_CHAR)
2377: THEN
2378: x_cfov_rec.attribute6 := l_db_cfov_rec.attribute6;
2379: END IF;
2380: IF (x_cfov_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 2380: IF (x_cfov_rec.attribute7 = OKL_API.G_MISS_CHAR)

2376: IF (x_cfov_rec.attribute6 = OKL_API.G_MISS_CHAR)
2377: THEN
2378: x_cfov_rec.attribute6 := l_db_cfov_rec.attribute6;
2379: END IF;
2380: IF (x_cfov_rec.attribute7 = OKL_API.G_MISS_CHAR)
2381: THEN
2382: x_cfov_rec.attribute7 := l_db_cfov_rec.attribute7;
2383: END IF;
2384: IF (x_cfov_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 2384: IF (x_cfov_rec.attribute8 = OKL_API.G_MISS_CHAR)

2380: IF (x_cfov_rec.attribute7 = OKL_API.G_MISS_CHAR)
2381: THEN
2382: x_cfov_rec.attribute7 := l_db_cfov_rec.attribute7;
2383: END IF;
2384: IF (x_cfov_rec.attribute8 = OKL_API.G_MISS_CHAR)
2385: THEN
2386: x_cfov_rec.attribute8 := l_db_cfov_rec.attribute8;
2387: END IF;
2388: IF (x_cfov_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 2388: IF (x_cfov_rec.attribute9 = OKL_API.G_MISS_CHAR)

2384: IF (x_cfov_rec.attribute8 = OKL_API.G_MISS_CHAR)
2385: THEN
2386: x_cfov_rec.attribute8 := l_db_cfov_rec.attribute8;
2387: END IF;
2388: IF (x_cfov_rec.attribute9 = OKL_API.G_MISS_CHAR)
2389: THEN
2390: x_cfov_rec.attribute9 := l_db_cfov_rec.attribute9;
2391: END IF;
2392: IF (x_cfov_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 2392: IF (x_cfov_rec.attribute10 = OKL_API.G_MISS_CHAR)

2388: IF (x_cfov_rec.attribute9 = OKL_API.G_MISS_CHAR)
2389: THEN
2390: x_cfov_rec.attribute9 := l_db_cfov_rec.attribute9;
2391: END IF;
2392: IF (x_cfov_rec.attribute10 = OKL_API.G_MISS_CHAR)
2393: THEN
2394: x_cfov_rec.attribute10 := l_db_cfov_rec.attribute10;
2395: END IF;
2396: IF (x_cfov_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 2396: IF (x_cfov_rec.attribute11 = OKL_API.G_MISS_CHAR)

2392: IF (x_cfov_rec.attribute10 = OKL_API.G_MISS_CHAR)
2393: THEN
2394: x_cfov_rec.attribute10 := l_db_cfov_rec.attribute10;
2395: END IF;
2396: IF (x_cfov_rec.attribute11 = OKL_API.G_MISS_CHAR)
2397: THEN
2398: x_cfov_rec.attribute11 := l_db_cfov_rec.attribute11;
2399: END IF;
2400: IF (x_cfov_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 2400: IF (x_cfov_rec.attribute12 = OKL_API.G_MISS_CHAR)

2396: IF (x_cfov_rec.attribute11 = OKL_API.G_MISS_CHAR)
2397: THEN
2398: x_cfov_rec.attribute11 := l_db_cfov_rec.attribute11;
2399: END IF;
2400: IF (x_cfov_rec.attribute12 = OKL_API.G_MISS_CHAR)
2401: THEN
2402: x_cfov_rec.attribute12 := l_db_cfov_rec.attribute12;
2403: END IF;
2404: IF (x_cfov_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 2404: IF (x_cfov_rec.attribute13 = OKL_API.G_MISS_CHAR)

2400: IF (x_cfov_rec.attribute12 = OKL_API.G_MISS_CHAR)
2401: THEN
2402: x_cfov_rec.attribute12 := l_db_cfov_rec.attribute12;
2403: END IF;
2404: IF (x_cfov_rec.attribute13 = OKL_API.G_MISS_CHAR)
2405: THEN
2406: x_cfov_rec.attribute13 := l_db_cfov_rec.attribute13;
2407: END IF;
2408: IF (x_cfov_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 2408: IF (x_cfov_rec.attribute14 = OKL_API.G_MISS_CHAR)

2404: IF (x_cfov_rec.attribute13 = OKL_API.G_MISS_CHAR)
2405: THEN
2406: x_cfov_rec.attribute13 := l_db_cfov_rec.attribute13;
2407: END IF;
2408: IF (x_cfov_rec.attribute14 = OKL_API.G_MISS_CHAR)
2409: THEN
2410: x_cfov_rec.attribute14 := l_db_cfov_rec.attribute14;
2411: END IF;
2412: IF (x_cfov_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 2412: IF (x_cfov_rec.attribute15 = OKL_API.G_MISS_CHAR)

2408: IF (x_cfov_rec.attribute14 = OKL_API.G_MISS_CHAR)
2409: THEN
2410: x_cfov_rec.attribute14 := l_db_cfov_rec.attribute14;
2411: END IF;
2412: IF (x_cfov_rec.attribute15 = OKL_API.G_MISS_CHAR)
2413: THEN
2414: x_cfov_rec.attribute15 := l_db_cfov_rec.attribute15;
2415: END IF;
2416: IF (x_cfov_rec.created_by = OKL_API.G_MISS_NUM)

Line 2416: IF (x_cfov_rec.created_by = OKL_API.G_MISS_NUM)

2412: IF (x_cfov_rec.attribute15 = OKL_API.G_MISS_CHAR)
2413: THEN
2414: x_cfov_rec.attribute15 := l_db_cfov_rec.attribute15;
2415: END IF;
2416: IF (x_cfov_rec.created_by = OKL_API.G_MISS_NUM)
2417: THEN
2418: x_cfov_rec.created_by := l_db_cfov_rec.created_by;
2419: END IF;
2420: IF (x_cfov_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2420: IF (x_cfov_rec.creation_date = OKL_API.G_MISS_DATE)

2416: IF (x_cfov_rec.created_by = OKL_API.G_MISS_NUM)
2417: THEN
2418: x_cfov_rec.created_by := l_db_cfov_rec.created_by;
2419: END IF;
2420: IF (x_cfov_rec.creation_date = OKL_API.G_MISS_DATE)
2421: THEN
2422: x_cfov_rec.creation_date := l_db_cfov_rec.creation_date;
2423: END IF;
2424: IF (x_cfov_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2424: IF (x_cfov_rec.last_updated_by = OKL_API.G_MISS_NUM)

2420: IF (x_cfov_rec.creation_date = OKL_API.G_MISS_DATE)
2421: THEN
2422: x_cfov_rec.creation_date := l_db_cfov_rec.creation_date;
2423: END IF;
2424: IF (x_cfov_rec.last_updated_by = OKL_API.G_MISS_NUM)
2425: THEN
2426: x_cfov_rec.last_updated_by := l_db_cfov_rec.last_updated_by;
2427: END IF;
2428: IF (x_cfov_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2428: IF (x_cfov_rec.last_update_date = OKL_API.G_MISS_DATE)

2424: IF (x_cfov_rec.last_updated_by = OKL_API.G_MISS_NUM)
2425: THEN
2426: x_cfov_rec.last_updated_by := l_db_cfov_rec.last_updated_by;
2427: END IF;
2428: IF (x_cfov_rec.last_update_date = OKL_API.G_MISS_DATE)
2429: THEN
2430: x_cfov_rec.last_update_date := l_db_cfov_rec.last_update_date;
2431: END IF;
2432: IF (x_cfov_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2432: IF (x_cfov_rec.last_update_login = OKL_API.G_MISS_NUM)

2428: IF (x_cfov_rec.last_update_date = OKL_API.G_MISS_DATE)
2429: THEN
2430: x_cfov_rec.last_update_date := l_db_cfov_rec.last_update_date;
2431: END IF;
2432: IF (x_cfov_rec.last_update_login = OKL_API.G_MISS_NUM)
2433: THEN
2434: x_cfov_rec.last_update_login := l_db_cfov_rec.last_update_login;
2435: END IF;
2436: END IF;

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

2442: FUNCTION Set_Attributes (
2443: p_cfov_rec IN cfov_rec_type,
2444: x_cfov_rec OUT NOCOPY cfov_rec_type
2445: ) RETURN VARCHAR2 IS
2446: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2447: BEGIN
2448: x_cfov_rec := p_cfov_rec;
2449: RETURN(l_return_status);
2450: END Set_Attributes;

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

2448: x_cfov_rec := p_cfov_rec;
2449: RETURN(l_return_status);
2450: END Set_Attributes;
2451: BEGIN
2452: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2453: G_PKG_NAME,
2454: p_init_msg_list,
2455: l_api_version,
2456: p_api_version,

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

2455: l_api_version,
2456: p_api_version,
2457: '_PVT',
2458: x_return_status);
2459: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2460: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2461: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2462: RAISE OKL_API.G_EXCEPTION_ERROR;
2463: END IF;

Line 2460: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2456: p_api_version,
2457: '_PVT',
2458: x_return_status);
2459: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2460: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2461: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2462: RAISE OKL_API.G_EXCEPTION_ERROR;
2463: END IF;
2464: --- Setting item attributes

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

2457: '_PVT',
2458: x_return_status);
2459: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2460: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2461: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2462: RAISE OKL_API.G_EXCEPTION_ERROR;
2463: END IF;
2464: --- Setting item attributes
2465: l_return_status := Set_Attributes(

Line 2462: RAISE OKL_API.G_EXCEPTION_ERROR;

2458: x_return_status);
2459: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2460: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2461: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2462: RAISE OKL_API.G_EXCEPTION_ERROR;
2463: END IF;
2464: --- Setting item attributes
2465: l_return_status := Set_Attributes(
2466: p_cfov_rec, -- IN

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

2465: l_return_status := Set_Attributes(
2466: p_cfov_rec, -- IN
2467: x_cfov_rec); -- OUT
2468: --- If any errors happen abort API
2469: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2472: RAISE OKL_API.G_EXCEPTION_ERROR;
2473: END IF;

Line 2470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2466: p_cfov_rec, -- IN
2467: x_cfov_rec); -- OUT
2468: --- If any errors happen abort API
2469: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2472: RAISE OKL_API.G_EXCEPTION_ERROR;
2473: END IF;
2474: l_return_status := populate_new_record(l_cfov_rec, l_def_cfov_rec);

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

2467: x_cfov_rec); -- OUT
2468: --- If any errors happen abort API
2469: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2472: RAISE OKL_API.G_EXCEPTION_ERROR;
2473: END IF;
2474: l_return_status := populate_new_record(l_cfov_rec, l_def_cfov_rec);
2475: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2472: RAISE OKL_API.G_EXCEPTION_ERROR;

2468: --- If any errors happen abort API
2469: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2472: RAISE OKL_API.G_EXCEPTION_ERROR;
2473: END IF;
2474: l_return_status := populate_new_record(l_cfov_rec, l_def_cfov_rec);
2475: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2476: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2472: RAISE OKL_API.G_EXCEPTION_ERROR;
2473: END IF;
2474: l_return_status := populate_new_record(l_cfov_rec, l_def_cfov_rec);
2475: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2476: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2477: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2478: RAISE OKL_API.G_EXCEPTION_ERROR;
2479: END IF;

Line 2476: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2472: RAISE OKL_API.G_EXCEPTION_ERROR;
2473: END IF;
2474: l_return_status := populate_new_record(l_cfov_rec, l_def_cfov_rec);
2475: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2476: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2477: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2478: RAISE OKL_API.G_EXCEPTION_ERROR;
2479: END IF;
2480: l_def_cfov_rec := fill_who_columns(l_def_cfov_rec);

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

2473: END IF;
2474: l_return_status := populate_new_record(l_cfov_rec, l_def_cfov_rec);
2475: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2476: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2477: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2478: RAISE OKL_API.G_EXCEPTION_ERROR;
2479: END IF;
2480: l_def_cfov_rec := fill_who_columns(l_def_cfov_rec);
2481: --- Validate all non-missing attributes (Item Level Validation)

Line 2478: RAISE OKL_API.G_EXCEPTION_ERROR;

2474: l_return_status := populate_new_record(l_cfov_rec, l_def_cfov_rec);
2475: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2476: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2477: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2478: RAISE OKL_API.G_EXCEPTION_ERROR;
2479: END IF;
2480: l_def_cfov_rec := fill_who_columns(l_def_cfov_rec);
2481: --- Validate all non-missing attributes (Item Level Validation)
2482: l_return_status := Validate_Attributes(l_def_cfov_rec);

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

2480: l_def_cfov_rec := fill_who_columns(l_def_cfov_rec);
2481: --- Validate all non-missing attributes (Item Level Validation)
2482: l_return_status := Validate_Attributes(l_def_cfov_rec);
2483: --- If any errors happen abort API
2484: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2485: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2486: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2487: RAISE OKL_API.G_EXCEPTION_ERROR;
2488: END IF;

Line 2485: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2481: --- Validate all non-missing attributes (Item Level Validation)
2482: l_return_status := Validate_Attributes(l_def_cfov_rec);
2483: --- If any errors happen abort API
2484: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2485: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2486: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2487: RAISE OKL_API.G_EXCEPTION_ERROR;
2488: END IF;
2489:

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

2482: l_return_status := Validate_Attributes(l_def_cfov_rec);
2483: --- If any errors happen abort API
2484: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2485: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2486: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2487: RAISE OKL_API.G_EXCEPTION_ERROR;
2488: END IF;
2489:
2490: /*

Line 2487: RAISE OKL_API.G_EXCEPTION_ERROR;

2483: --- If any errors happen abort API
2484: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2485: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2486: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2487: RAISE OKL_API.G_EXCEPTION_ERROR;
2488: END IF;
2489:
2490: /*
2491: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,

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

2491: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
2492: -- which has been moved to individaul valiadte attribute procedures
2493:
2494: l_return_status := Validate_Record(l_def_cfov_rec, l_db_cfov_rec);
2495: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2496: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2497: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2498: RAISE OKL_API.G_EXCEPTION_ERROR;
2499: END IF;

Line 2496: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2492: -- which has been moved to individaul valiadte attribute procedures
2493:
2494: l_return_status := Validate_Record(l_def_cfov_rec, l_db_cfov_rec);
2495: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2496: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2497: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2498: RAISE OKL_API.G_EXCEPTION_ERROR;
2499: END IF;
2500: */

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

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

Line 2498: RAISE OKL_API.G_EXCEPTION_ERROR;

2494: l_return_status := Validate_Record(l_def_cfov_rec, l_db_cfov_rec);
2495: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2496: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2497: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2498: RAISE OKL_API.G_EXCEPTION_ERROR;
2499: END IF;
2500: */
2501:
2502: -- Lock the Record

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

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

Line 2511: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 2513: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 2532: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2528: l_cfo_rec,
2529: lx_cfo_rec
2530: );
2531: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2532: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2533: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2534: RAISE OKL_API.G_EXCEPTION_ERROR;
2535: END IF;
2536: migrate(lx_cfo_rec, l_def_cfov_rec);

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

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

Line 2534: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

2535: END IF;
2536: migrate(lx_cfo_rec, l_def_cfov_rec);
2537: x_cfov_rec := l_def_cfov_rec;
2538: x_return_status := l_return_status;
2539: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2540: EXCEPTION
2541: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2542: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2543: (

Line 2541: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 2542: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2546: 'OKL_API.G_RET_STS_ERROR',

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

Line 2551: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2552: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2556: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2562: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

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

Line 2589: OKL_API.init_msg_list(p_init_msg_list);

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

Line 2595: l_error_rec OKL_API.ERROR_REC_TYPE;

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

Line 2602: p_init_msg_list => OKL_API.G_FALSE,

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

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

2604: x_msg_count => l_error_rec.msg_count,
2605: x_msg_data => l_error_rec.msg_data,
2606: p_cfov_rec => p_cfov_tbl(i),
2607: x_cfov_rec => x_cfov_tbl(i));
2608: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
2609: l_error_rec.sqlcode := SQLCODE;
2610: load_error_tbl(l_error_rec, px_error_tbl);
2611: ELSE
2612: x_msg_count := l_error_rec.msg_count;

Line 2616: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

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

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

Line 2620: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

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

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

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

Line 2638: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2634: -- and return it.
2635: x_return_status := find_highest_exception(px_error_tbl);
2636: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2637: EXCEPTION
2638: WHEN OKL_API.G_EXCEPTION_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_return_status := find_highest_exception(px_error_tbl);
2636: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2637: EXCEPTION
2638: WHEN OKL_API.G_EXCEPTION_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_ERROR',

Line 2643: 'OKL_API.G_RET_STS_ERROR',

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

Line 2648: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2649: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2653: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2659: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

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

Line 2687: l_error_tbl OKL_API.ERROR_TBL_TYPE;

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

Line 2689: OKL_API.init_msg_list(p_init_msg_list);

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

Line 2694: p_init_msg_list => OKL_API.G_FALSE,

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

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

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

Line 2704: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 2705: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2709: 'OKL_API.G_RET_STS_ERROR',

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

Line 2714: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2715: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2719: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2725: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

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

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

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

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

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

Line 2760: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 2762: RAISE OKL_API.G_EXCEPTION_ERROR;

2758: x_return_status);
2759: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2760: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2761: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2762: RAISE OKL_API.G_EXCEPTION_ERROR;
2763: END IF;
2764:
2765: DELETE FROM OKL_CASH_FLOW_OBJECTS
2766: WHERE ID = p_cfo_rec.id;

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

2765: DELETE FROM OKL_CASH_FLOW_OBJECTS
2766: WHERE ID = p_cfo_rec.id;
2767:
2768: x_return_status := l_return_status;
2769: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2770: EXCEPTION
2771: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2772: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2773: (

Line 2771: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 2772: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2776: 'OKL_API.G_RET_STS_ERROR',

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

Line 2781: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2782: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2786: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2792: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

2811: p_cfov_rec IN cfov_rec_type) IS
2812:
2813: l_api_version CONSTANT NUMBER := 1;
2814: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2815: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2816: l_cfov_rec cfov_rec_type := p_cfov_rec;
2817: l_cfo_rec cfo_rec_type;
2818: BEGIN
2819: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

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

2815: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2816: l_cfov_rec cfov_rec_type := p_cfov_rec;
2817: l_cfo_rec cfo_rec_type;
2818: BEGIN
2819: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2820: G_PKG_NAME,
2821: p_init_msg_list,
2822: l_api_version,
2823: p_api_version,

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

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

Line 2827: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 2829: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 2846: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 2848: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 2853: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 2854: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2858: 'OKL_API.G_RET_STS_ERROR',

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

Line 2863: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2864: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2868: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2874: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

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

Line 2900: OKL_API.init_msg_list(p_init_msg_list);

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

Line 2906: l_error_rec OKL_API.ERROR_REC_TYPE;

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

Line 2913: p_init_msg_list => OKL_API.G_FALSE,

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

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

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

Line 2926: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

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

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

Line 2930: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

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

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

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

Line 2948: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 2949: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2953: 'OKL_API.G_RET_STS_ERROR',

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

Line 2958: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2959: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2963: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 2969: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

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

Line 2994: l_error_tbl OKL_API.ERROR_TBL_TYPE;

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

Line 2996: OKL_API.init_msg_list(p_init_msg_list);

2992: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2993: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2994: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2995: BEGIN
2996: OKL_API.init_msg_list(p_init_msg_list);
2997: -- Make sure PL/SQL table has records in it before passing
2998: IF (p_cfov_tbl.COUNT > 0) THEN
2999: delete_row (
3000: p_api_version => p_api_version,

Line 3001: p_init_msg_list => OKL_API.G_FALSE,

2997: -- Make sure PL/SQL table has records in it before passing
2998: IF (p_cfov_tbl.COUNT > 0) THEN
2999: delete_row (
3000: p_api_version => p_api_version,
3001: p_init_msg_list => OKL_API.G_FALSE,
3002: x_return_status => x_return_status,
3003: x_msg_count => x_msg_count,
3004: x_msg_data => x_msg_data,
3005: p_cfov_tbl => p_cfov_tbl,

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

3004: x_msg_data => x_msg_data,
3005: p_cfov_tbl => p_cfov_tbl,
3006: px_error_tbl => l_error_tbl);
3007: END IF;
3008: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3009: EXCEPTION
3010: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3011: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3012: (

Line 3010: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3006: px_error_tbl => l_error_tbl);
3007: END IF;
3008: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3009: EXCEPTION
3010: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3011: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3012: (
3013: l_api_name,
3014: G_PKG_NAME,

Line 3011: x_return_status := OKL_API.HANDLE_EXCEPTIONS

3007: END IF;
3008: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3009: EXCEPTION
3010: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3011: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3012: (
3013: l_api_name,
3014: G_PKG_NAME,
3015: 'OKL_API.G_RET_STS_ERROR',

Line 3015: 'OKL_API.G_RET_STS_ERROR',

3011: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3012: (
3013: l_api_name,
3014: G_PKG_NAME,
3015: 'OKL_API.G_RET_STS_ERROR',
3016: x_msg_count,
3017: x_msg_data,
3018: '_PVT'
3019: );

Line 3020: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 3021: x_return_status := OKL_API.HANDLE_EXCEPTIONS

3017: x_msg_data,
3018: '_PVT'
3019: );
3020: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3021: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3022: (
3023: l_api_name,
3024: G_PKG_NAME,
3025: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3025: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 3031: x_return_status := OKL_API.HANDLE_EXCEPTIONS

3027: x_msg_data,
3028: '_PVT'
3029: );
3030: WHEN OTHERS THEN
3031: x_return_status := OKL_API.HANDLE_EXCEPTIONS
3032: (
3033: l_api_name,
3034: G_PKG_NAME,
3035: 'OTHERS',