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_CFP_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 180: x_return_status := OKL_API.G_RET_STS_SUCCESS;

176: ) RETURN cfpv_rec_type IS
177: l_cfpv_rec cfpv_rec_type;
178: l_row_notfound BOOLEAN := TRUE;
179: BEGIN
180: x_return_status := OKL_API.G_RET_STS_SUCCESS;
181: l_cfpv_rec := get_rec(p_cfpv_rec, l_row_notfound);
182: IF (l_row_notfound) THEN
183: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
184: x_return_status := OKL_API.G_RET_STS_ERROR;

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

179: BEGIN
180: x_return_status := OKL_API.G_RET_STS_SUCCESS;
181: l_cfpv_rec := get_rec(p_cfpv_rec, l_row_notfound);
182: IF (l_row_notfound) THEN
183: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
184: x_return_status := OKL_API.G_RET_STS_ERROR;
185: END IF;
186: RETURN(l_cfpv_rec);
187: END get_rec;

Line 184: x_return_status := OKL_API.G_RET_STS_ERROR;

180: x_return_status := OKL_API.G_RET_STS_SUCCESS;
181: l_cfpv_rec := get_rec(p_cfpv_rec, l_row_notfound);
182: IF (l_row_notfound) THEN
183: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
184: x_return_status := OKL_API.G_RET_STS_ERROR;
185: END IF;
186: RETURN(l_cfpv_rec);
187: END get_rec;
188: -----------------------------------------------------------

Line 285: x_return_status := OKL_API.G_RET_STS_SUCCESS;

281: ) RETURN cfp_rec_type IS
282: l_cfp_rec cfp_rec_type;
283: l_row_notfound BOOLEAN := TRUE;
284: BEGIN
285: x_return_status := OKL_API.G_RET_STS_SUCCESS;
286: l_cfp_rec := get_rec(p_cfp_rec, l_row_notfound);
287: IF (l_row_notfound) THEN
288: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
289: x_return_status := OKL_API.G_RET_STS_ERROR;

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

284: BEGIN
285: x_return_status := OKL_API.G_RET_STS_SUCCESS;
286: l_cfp_rec := get_rec(p_cfp_rec, l_row_notfound);
287: IF (l_row_notfound) THEN
288: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
289: x_return_status := OKL_API.G_RET_STS_ERROR;
290: END IF;
291: RETURN(l_cfp_rec);
292: END get_rec;

Line 289: x_return_status := OKL_API.G_RET_STS_ERROR;

285: x_return_status := OKL_API.G_RET_STS_SUCCESS;
286: l_cfp_rec := get_rec(p_cfp_rec, l_row_notfound);
287: IF (l_row_notfound) THEN
288: OKL_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
289: x_return_status := OKL_API.G_RET_STS_ERROR;
290: END IF;
291: RETURN(l_cfp_rec);
292: END get_rec;
293: -----------------------------------------------------------

Line 311: IF (l_cfpv_rec.id = OKL_API.G_MISS_NUM ) THEN

307: p_cfpv_rec IN cfpv_rec_type
308: ) RETURN cfpv_rec_type IS
309: l_cfpv_rec cfpv_rec_type := p_cfpv_rec;
310: BEGIN
311: IF (l_cfpv_rec.id = OKL_API.G_MISS_NUM ) THEN
312: l_cfpv_rec.id := NULL;
313: END IF;
314: IF (l_cfpv_rec.cfo_id = OKL_API.G_MISS_NUM ) THEN
315: l_cfpv_rec.cfo_id := NULL;

Line 314: IF (l_cfpv_rec.cfo_id = OKL_API.G_MISS_NUM ) THEN

310: BEGIN
311: IF (l_cfpv_rec.id = OKL_API.G_MISS_NUM ) THEN
312: l_cfpv_rec.id := NULL;
313: END IF;
314: IF (l_cfpv_rec.cfo_id = OKL_API.G_MISS_NUM ) THEN
315: l_cfpv_rec.cfo_id := NULL;
316: END IF;
317: IF (l_cfpv_rec.ptp_code = OKL_API.G_MISS_CHAR ) THEN
318: l_cfpv_rec.ptp_code := NULL;

Line 317: IF (l_cfpv_rec.ptp_code = OKL_API.G_MISS_CHAR ) THEN

313: END IF;
314: IF (l_cfpv_rec.cfo_id = OKL_API.G_MISS_NUM ) THEN
315: l_cfpv_rec.cfo_id := NULL;
316: END IF;
317: IF (l_cfpv_rec.ptp_code = OKL_API.G_MISS_CHAR ) THEN
318: l_cfpv_rec.ptp_code := NULL;
319: END IF;
320: IF (l_cfpv_rec.start_date = OKL_API.G_MISS_DATE ) THEN
321: l_cfpv_rec.start_date := NULL;

Line 320: IF (l_cfpv_rec.start_date = OKL_API.G_MISS_DATE ) THEN

316: END IF;
317: IF (l_cfpv_rec.ptp_code = OKL_API.G_MISS_CHAR ) THEN
318: l_cfpv_rec.ptp_code := NULL;
319: END IF;
320: IF (l_cfpv_rec.start_date = OKL_API.G_MISS_DATE ) THEN
321: l_cfpv_rec.start_date := NULL;
322: END IF;
323: IF (l_cfpv_rec.end_date = OKL_API.G_MISS_CHAR ) THEN
324: l_cfpv_rec.end_date := NULL;

Line 323: IF (l_cfpv_rec.end_date = OKL_API.G_MISS_CHAR ) THEN

319: END IF;
320: IF (l_cfpv_rec.start_date = OKL_API.G_MISS_DATE ) THEN
321: l_cfpv_rec.start_date := NULL;
322: END IF;
323: IF (l_cfpv_rec.end_date = OKL_API.G_MISS_CHAR ) THEN
324: l_cfpv_rec.end_date := NULL;
325: END IF;
326: IF (l_cfpv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
327: l_cfpv_rec.attribute_category := NULL;

Line 326: IF (l_cfpv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN

322: END IF;
323: IF (l_cfpv_rec.end_date = OKL_API.G_MISS_CHAR ) THEN
324: l_cfpv_rec.end_date := NULL;
325: END IF;
326: IF (l_cfpv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
327: l_cfpv_rec.attribute_category := NULL;
328: END IF;
329: IF (l_cfpv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
330: l_cfpv_rec.attribute1 := NULL;

Line 329: IF (l_cfpv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN

325: END IF;
326: IF (l_cfpv_rec.attribute_category = OKL_API.G_MISS_CHAR ) THEN
327: l_cfpv_rec.attribute_category := NULL;
328: END IF;
329: IF (l_cfpv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
330: l_cfpv_rec.attribute1 := NULL;
331: END IF;
332: IF (l_cfpv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
333: l_cfpv_rec.attribute2 := NULL;

Line 332: IF (l_cfpv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN

328: END IF;
329: IF (l_cfpv_rec.attribute1 = OKL_API.G_MISS_CHAR ) THEN
330: l_cfpv_rec.attribute1 := NULL;
331: END IF;
332: IF (l_cfpv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
333: l_cfpv_rec.attribute2 := NULL;
334: END IF;
335: IF (l_cfpv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
336: l_cfpv_rec.attribute3 := NULL;

Line 335: IF (l_cfpv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN

331: END IF;
332: IF (l_cfpv_rec.attribute2 = OKL_API.G_MISS_CHAR ) THEN
333: l_cfpv_rec.attribute2 := NULL;
334: END IF;
335: IF (l_cfpv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
336: l_cfpv_rec.attribute3 := NULL;
337: END IF;
338: IF (l_cfpv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
339: l_cfpv_rec.attribute4 := NULL;

Line 338: IF (l_cfpv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN

334: END IF;
335: IF (l_cfpv_rec.attribute3 = OKL_API.G_MISS_CHAR ) THEN
336: l_cfpv_rec.attribute3 := NULL;
337: END IF;
338: IF (l_cfpv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
339: l_cfpv_rec.attribute4 := NULL;
340: END IF;
341: IF (l_cfpv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
342: l_cfpv_rec.attribute5 := NULL;

Line 341: IF (l_cfpv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN

337: END IF;
338: IF (l_cfpv_rec.attribute4 = OKL_API.G_MISS_CHAR ) THEN
339: l_cfpv_rec.attribute4 := NULL;
340: END IF;
341: IF (l_cfpv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
342: l_cfpv_rec.attribute5 := NULL;
343: END IF;
344: IF (l_cfpv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
345: l_cfpv_rec.attribute6 := NULL;

Line 344: IF (l_cfpv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN

340: END IF;
341: IF (l_cfpv_rec.attribute5 = OKL_API.G_MISS_CHAR ) THEN
342: l_cfpv_rec.attribute5 := NULL;
343: END IF;
344: IF (l_cfpv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
345: l_cfpv_rec.attribute6 := NULL;
346: END IF;
347: IF (l_cfpv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
348: l_cfpv_rec.attribute7 := NULL;

Line 347: IF (l_cfpv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN

343: END IF;
344: IF (l_cfpv_rec.attribute6 = OKL_API.G_MISS_CHAR ) THEN
345: l_cfpv_rec.attribute6 := NULL;
346: END IF;
347: IF (l_cfpv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
348: l_cfpv_rec.attribute7 := NULL;
349: END IF;
350: IF (l_cfpv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
351: l_cfpv_rec.attribute8 := NULL;

Line 350: IF (l_cfpv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN

346: END IF;
347: IF (l_cfpv_rec.attribute7 = OKL_API.G_MISS_CHAR ) THEN
348: l_cfpv_rec.attribute7 := NULL;
349: END IF;
350: IF (l_cfpv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
351: l_cfpv_rec.attribute8 := NULL;
352: END IF;
353: IF (l_cfpv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
354: l_cfpv_rec.attribute9 := NULL;

Line 353: IF (l_cfpv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN

349: END IF;
350: IF (l_cfpv_rec.attribute8 = OKL_API.G_MISS_CHAR ) THEN
351: l_cfpv_rec.attribute8 := NULL;
352: END IF;
353: IF (l_cfpv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
354: l_cfpv_rec.attribute9 := NULL;
355: END IF;
356: IF (l_cfpv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
357: l_cfpv_rec.attribute10 := NULL;

Line 356: IF (l_cfpv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN

352: END IF;
353: IF (l_cfpv_rec.attribute9 = OKL_API.G_MISS_CHAR ) THEN
354: l_cfpv_rec.attribute9 := NULL;
355: END IF;
356: IF (l_cfpv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
357: l_cfpv_rec.attribute10 := NULL;
358: END IF;
359: IF (l_cfpv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
360: l_cfpv_rec.attribute11 := NULL;

Line 359: IF (l_cfpv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN

355: END IF;
356: IF (l_cfpv_rec.attribute10 = OKL_API.G_MISS_CHAR ) THEN
357: l_cfpv_rec.attribute10 := NULL;
358: END IF;
359: IF (l_cfpv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
360: l_cfpv_rec.attribute11 := NULL;
361: END IF;
362: IF (l_cfpv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
363: l_cfpv_rec.attribute12 := NULL;

Line 362: IF (l_cfpv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN

358: END IF;
359: IF (l_cfpv_rec.attribute11 = OKL_API.G_MISS_CHAR ) THEN
360: l_cfpv_rec.attribute11 := NULL;
361: END IF;
362: IF (l_cfpv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
363: l_cfpv_rec.attribute12 := NULL;
364: END IF;
365: IF (l_cfpv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
366: l_cfpv_rec.attribute13 := NULL;

Line 365: IF (l_cfpv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN

361: END IF;
362: IF (l_cfpv_rec.attribute12 = OKL_API.G_MISS_CHAR ) THEN
363: l_cfpv_rec.attribute12 := NULL;
364: END IF;
365: IF (l_cfpv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
366: l_cfpv_rec.attribute13 := NULL;
367: END IF;
368: IF (l_cfpv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
369: l_cfpv_rec.attribute14 := NULL;

Line 368: IF (l_cfpv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN

364: END IF;
365: IF (l_cfpv_rec.attribute13 = OKL_API.G_MISS_CHAR ) THEN
366: l_cfpv_rec.attribute13 := NULL;
367: END IF;
368: IF (l_cfpv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
369: l_cfpv_rec.attribute14 := NULL;
370: END IF;
371: IF (l_cfpv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
372: l_cfpv_rec.attribute15 := NULL;

Line 371: IF (l_cfpv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN

367: END IF;
368: IF (l_cfpv_rec.attribute14 = OKL_API.G_MISS_CHAR ) THEN
369: l_cfpv_rec.attribute14 := NULL;
370: END IF;
371: IF (l_cfpv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
372: l_cfpv_rec.attribute15 := NULL;
373: END IF;
374: IF (l_cfpv_rec.created_by = OKL_API.G_MISS_NUM ) THEN
375: l_cfpv_rec.created_by := NULL;

Line 374: IF (l_cfpv_rec.created_by = OKL_API.G_MISS_NUM ) THEN

370: END IF;
371: IF (l_cfpv_rec.attribute15 = OKL_API.G_MISS_CHAR ) THEN
372: l_cfpv_rec.attribute15 := NULL;
373: END IF;
374: IF (l_cfpv_rec.created_by = OKL_API.G_MISS_NUM ) THEN
375: l_cfpv_rec.created_by := NULL;
376: END IF;
377: IF (l_cfpv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
378: l_cfpv_rec.creation_date := NULL;

Line 377: IF (l_cfpv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN

373: END IF;
374: IF (l_cfpv_rec.created_by = OKL_API.G_MISS_NUM ) THEN
375: l_cfpv_rec.created_by := NULL;
376: END IF;
377: IF (l_cfpv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
378: l_cfpv_rec.creation_date := NULL;
379: END IF;
380: IF (l_cfpv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
381: l_cfpv_rec.last_updated_by := NULL;

Line 380: IF (l_cfpv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN

376: END IF;
377: IF (l_cfpv_rec.creation_date = OKL_API.G_MISS_DATE ) THEN
378: l_cfpv_rec.creation_date := NULL;
379: END IF;
380: IF (l_cfpv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
381: l_cfpv_rec.last_updated_by := NULL;
382: END IF;
383: IF (l_cfpv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
384: l_cfpv_rec.last_update_date := NULL;

Line 383: IF (l_cfpv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN

379: END IF;
380: IF (l_cfpv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
381: l_cfpv_rec.last_updated_by := NULL;
382: END IF;
383: IF (l_cfpv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
384: l_cfpv_rec.last_update_date := NULL;
385: END IF;
386: IF (l_cfpv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
387: l_cfpv_rec.last_update_login := NULL;

Line 386: IF (l_cfpv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN

382: END IF;
383: IF (l_cfpv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
384: l_cfpv_rec.last_update_date := NULL;
385: END IF;
386: IF (l_cfpv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
387: l_cfpv_rec.last_update_login := NULL;
388: END IF;
389: IF (l_cfpv_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
390: l_cfpv_rec.object_version_number := NULL;

Line 389: IF (l_cfpv_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN

385: END IF;
386: IF (l_cfpv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
387: l_cfpv_rec.last_update_login := NULL;
388: END IF;
389: IF (l_cfpv_rec.object_version_number = OKL_API.G_MISS_NUM ) THEN
390: l_cfpv_rec.object_version_number := NULL;
391: END IF;
392: RETURN(l_cfpv_rec);
393: END null_out_defaults;

Line 402: IF (p_cfpv_rec.id = OKL_API.G_MISS_NUM OR p_cfpv_rec.id IS NULL)

398: p_cfpv_rec IN cfpv_rec_type,
399: x_return_status OUT NOCOPY VARCHAR2) IS
400: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
401: BEGIN
402: IF (p_cfpv_rec.id = OKL_API.G_MISS_NUM OR p_cfpv_rec.id IS NULL)
403: THEN
404: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
405: l_return_status := OKL_API.G_RET_STS_ERROR;
406:

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

400: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
401: BEGIN
402: IF (p_cfpv_rec.id = OKL_API.G_MISS_NUM OR p_cfpv_rec.id IS NULL)
403: THEN
404: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
405: l_return_status := OKL_API.G_RET_STS_ERROR;
406:
407: END IF;
408: x_return_status := l_return_status;

Line 405: l_return_status := OKL_API.G_RET_STS_ERROR;

401: BEGIN
402: IF (p_cfpv_rec.id = OKL_API.G_MISS_NUM OR p_cfpv_rec.id IS NULL)
403: THEN
404: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
405: l_return_status := OKL_API.G_RET_STS_ERROR;
406:
407: END IF;
408: x_return_status := l_return_status;
409: EXCEPTION

Line 412: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

408: x_return_status := l_return_status;
409: EXCEPTION
410:
411: WHEN OTHERS THEN
412: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
413: ,p_msg_name => G_UNEXPECTED_ERROR
414: ,p_token1 => G_SQLCODE_TOKEN
415: ,p_token1_value => SQLCODE
416: ,p_token2 => G_SQLERRM_TOKEN

Line 418: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

414: ,p_token1 => G_SQLCODE_TOKEN
415: ,p_token1_value => SQLCODE
416: ,p_token2 => G_SQLERRM_TOKEN
417: ,p_token2_value => SQLERRM);
418: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
419: END validate_id;
420: -------------------------------------
421: -- Validate_Attributes for: CFO_ID --
422: -------------------------------------

Line 435: IF (p_cfpv_rec.cfo_id = OKL_API.G_MISS_NUM OR p_cfpv_rec.cfo_id IS NULL)

431: FROM Okl_Cash_Flow_Objects_V
432: WHERE okl_cash_flow_objects_v.id = p_id;
433: BEGIN
434:
435: IF (p_cfpv_rec.cfo_id = OKL_API.G_MISS_NUM OR p_cfpv_rec.cfo_id IS NULL)
436: THEN
437: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'cfo_id');
438: l_return_status := OKL_API.G_RET_STS_ERROR;
439: ELSE

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

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

Line 438: l_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 462: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

458: x_return_status := l_return_status;
459: EXCEPTION
460:
461: WHEN OTHERS THEN
462: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
463: ,p_msg_name => G_UNEXPECTED_ERROR
464: ,p_token1 => G_SQLCODE_TOKEN
465: ,p_token1_value => SQLCODE
466: ,p_token2 => G_SQLERRM_TOKEN

Line 468: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

464: ,p_token1 => G_SQLCODE_TOKEN
465: ,p_token1_value => SQLCODE
466: ,p_token2 => G_SQLERRM_TOKEN
467: ,p_token2_value => SQLERRM);
468: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
469: END validate_cfo_id;
470: ---------------------------------------
471: -- Validate_Attributes for: PTP_CODE --
472: ---------------------------------------

Line 488: IF (p_cfpv_rec.ptp_code = OKL_API.G_MISS_CHAR OR p_cfpv_rec.ptp_code IS NULL)

484: WHERE fnd_lookup_values.lookup_code = p_lookup_code
485: AND fnd_lookup_values.lookup_type = p_lookup_type;
486: BEGIN
487:
488: IF (p_cfpv_rec.ptp_code = OKL_API.G_MISS_CHAR OR p_cfpv_rec.ptp_code IS NULL)
489: THEN
490: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ptp_code');
491: l_return_status := OKL_API.G_RET_STS_ERROR;
492: ELSE

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

486: BEGIN
487:
488: IF (p_cfpv_rec.ptp_code = OKL_API.G_MISS_CHAR OR p_cfpv_rec.ptp_code IS NULL)
489: THEN
490: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ptp_code');
491: l_return_status := OKL_API.G_RET_STS_ERROR;
492: ELSE
493: -- enforce foreign key
494: OPEN okl_cfpv_ptp_fk_csr(p_cfpv_rec.ptp_code,'OKL_CF_OBJ_PERIOD_TYPE');

Line 491: l_return_status := OKL_API.G_RET_STS_ERROR;

487:
488: IF (p_cfpv_rec.ptp_code = OKL_API.G_MISS_CHAR OR p_cfpv_rec.ptp_code IS NULL)
489: THEN
490: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'ptp_code');
491: l_return_status := OKL_API.G_RET_STS_ERROR;
492: ELSE
493: -- enforce foreign key
494: OPEN okl_cfpv_ptp_fk_csr(p_cfpv_rec.ptp_code,'OKL_CF_OBJ_PERIOD_TYPE');
495: FETCH okl_cfpv_ptp_fk_csr INTO l_dummy_var;

Line 500: OKL_API.set_message(g_app_name,

496: CLOSE okl_cfpv_ptp_fk_csr;
497:
498: -- still set to default means data was not found
499: IF ( l_dummy_var = '?' ) THEN
500: OKL_API.set_message(g_app_name,
501: g_no_parent_record,
502: g_col_name_token,
503: 'ptp_code',
504: g_child_table_token ,

Line 516: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

512: x_return_status := l_return_status;
513: EXCEPTION
514:
515: WHEN OTHERS THEN
516: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
517: ,p_msg_name => G_UNEXPECTED_ERROR
518: ,p_token1 => G_SQLCODE_TOKEN
519: ,p_token1_value => SQLCODE
520: ,p_token2 => G_SQLERRM_TOKEN

Line 522: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

518: ,p_token1 => G_SQLCODE_TOKEN
519: ,p_token1_value => SQLCODE
520: ,p_token2 => G_SQLERRM_TOKEN
521: ,p_token2_value => SQLERRM);
522: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
523: END validate_ptp_code;
524: -----------------------------------------
525: -- Validate_Attributes for: START_DATE --
526: -----------------------------------------

Line 533: IF (p_cfpv_rec.start_date = OKL_API.G_MISS_DATE OR p_cfpv_rec.start_date IS NULL)

529: x_return_status OUT NOCOPY VARCHAR2) IS
530: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
531: BEGIN
532:
533: IF (p_cfpv_rec.start_date = OKL_API.G_MISS_DATE OR p_cfpv_rec.start_date IS NULL)
534: THEN
535: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'start_date');
536: l_return_status := OKL_API.G_RET_STS_ERROR;
537:

Line 535: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'start_date');

531: BEGIN
532:
533: IF (p_cfpv_rec.start_date = OKL_API.G_MISS_DATE OR p_cfpv_rec.start_date IS NULL)
534: THEN
535: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'start_date');
536: l_return_status := OKL_API.G_RET_STS_ERROR;
537:
538: END IF;
539: x_return_status := l_return_status;

Line 536: l_return_status := OKL_API.G_RET_STS_ERROR;

532:
533: IF (p_cfpv_rec.start_date = OKL_API.G_MISS_DATE OR p_cfpv_rec.start_date IS NULL)
534: THEN
535: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'start_date');
536: l_return_status := OKL_API.G_RET_STS_ERROR;
537:
538: END IF;
539: x_return_status := l_return_status;
540: EXCEPTION

Line 543: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

539: x_return_status := l_return_status;
540: EXCEPTION
541:
542: WHEN OTHERS THEN
543: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
544: ,p_msg_name => G_UNEXPECTED_ERROR
545: ,p_token1 => G_SQLCODE_TOKEN
546: ,p_token1_value => SQLCODE
547: ,p_token2 => G_SQLERRM_TOKEN

Line 549: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

545: ,p_token1 => G_SQLCODE_TOKEN
546: ,p_token1_value => SQLCODE
547: ,p_token2 => G_SQLERRM_TOKEN
548: ,p_token2_value => SQLERRM);
549: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
550: END validate_start_date;
551: ---------------------------------------------------------------------------
552: -- FUNCTION Validate_Attributes
553: ---------------------------------------------------------------------------

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

556: -----------------------------------------------------
557: FUNCTION Validate_Attributes (
558: p_cfpv_rec IN cfpv_rec_type
559: ) RETURN VARCHAR2 IS
560: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
561: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
562: BEGIN
563: -----------------------------
564: -- Column Level Validation --

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

557: FUNCTION Validate_Attributes (
558: p_cfpv_rec IN cfpv_rec_type
559: ) RETURN VARCHAR2 IS
560: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
561: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
562: BEGIN
563: -----------------------------
564: -- Column Level Validation --
565: -----------------------------

Line 623: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

619: EXCEPTION
620: WHEN G_EXCEPTION_HALT_VALIDATION THEN
621: RETURN(x_return_status);
622: WHEN OTHERS THEN
623: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
624: ,p_msg_name => G_UNEXPECTED_ERROR
625: ,p_token1 => G_SQLCODE_TOKEN
626: ,p_token1_value => SQLCODE
627: ,p_token2 => G_SQLERRM_TOKEN

Line 629: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

625: ,p_token1 => G_SQLCODE_TOKEN
626: ,p_token1_value => SQLCODE
627: ,p_token2 => G_SQLERRM_TOKEN
628: ,p_token2_value => SQLERRM);
629: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
630: RETURN(x_return_status);
631: END Validate_Attributes;
632: ---------------------------------------------------------------------------
633: -- PROCEDURE Validate_Record

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

639: FUNCTION Validate_Record (
640: p_cfpv_rec IN cfpv_rec_type,
641: p_db_cfpv_rec IN cfpv_rec_type
642: ) RETURN VARCHAR2 IS
643: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
644: ------------------------------------
645: -- FUNCTION validate_foreign_keys --
646: ------------------------------------
647: FUNCTION validate_foreign_keys (

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

660: FROM Fnd_Lookup_Values
661: WHERE fnd_lookup_values.lookup_code = p_lookup_code;
662: l_okl_cfpv_ptp_fk okl_cfpv_ptp_fk_csr%ROWTYPE;
663:
664: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
665: l_row_notfound BOOLEAN := TRUE;
666: BEGIN
667: IF ((p_cfpv_rec.PTP_CODE IS NOT NULL)
668: AND

Line 676: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PTP_CODE');

672: FETCH okl_cfpv_ptp_fk_csr INTO l_okl_cfpv_ptp_fk;
673: l_row_notfound := okl_cfpv_ptp_fk_csr%NOTFOUND;
674: CLOSE okl_cfpv_ptp_fk_csr;
675: IF (l_row_notfound) THEN
676: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'PTP_CODE');
677: RAISE item_not_found_error;
678: END IF;
679: END IF;
680: IF ((p_cfpv_rec.CFO_ID IS NOT NULL)

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

685: FETCH okl_cfpv_cfov_fk_csr INTO l_okl_cfpv_cfov_fk;
686: l_row_notfound := okl_cfpv_cfov_fk_csr%NOTFOUND;
687: CLOSE okl_cfpv_cfov_fk_csr;
688: IF (l_row_notfound) THEN
689: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CFO_ID');
690: RAISE item_not_found_error;
691: END IF;
692: END IF;
693: RETURN (l_return_status);

Line 696: l_return_status := OKL_API.G_RET_STS_ERROR;

692: END IF;
693: RETURN (l_return_status);
694: EXCEPTION
695: WHEN item_not_found_error THEN
696: l_return_status := OKL_API.G_RET_STS_ERROR;
697: RETURN (l_return_status);
698: END validate_foreign_keys;
699: BEGIN
700: l_return_status := validate_foreign_keys(p_cfpv_rec, p_db_cfpv_rec);

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

702: END Validate_Record;
703: FUNCTION Validate_Record (
704: p_cfpv_rec IN cfpv_rec_type
705: ) RETURN VARCHAR2 IS
706: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
707: l_db_cfpv_rec cfpv_rec_type := get_rec(p_cfpv_rec);
708: BEGIN
709: l_return_status := Validate_Record(p_cfpv_rec => p_cfpv_rec,
710: p_db_cfpv_rec => l_db_cfpv_rec);

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

797: p_cfpv_rec IN cfpv_rec_type) IS
798:
799: l_api_version CONSTANT NUMBER := 1;
800: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
801: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
802: l_cfpv_rec cfpv_rec_type := p_cfpv_rec;
803: l_cfp_rec cfp_rec_type;
804: l_cfp_rec cfp_rec_type;
805: BEGIN

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

802: l_cfpv_rec cfpv_rec_type := p_cfpv_rec;
803: l_cfp_rec cfp_rec_type;
804: l_cfp_rec cfp_rec_type;
805: BEGIN
806: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
807: G_PKG_NAME,
808: p_init_msg_list,
809: l_api_version,
810: p_api_version,

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

809: l_api_version,
810: p_api_version,
811: '_PVT',
812: x_return_status);
813: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
815: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
816: RAISE OKL_API.G_EXCEPTION_ERROR;
817: END IF;

Line 814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

810: p_api_version,
811: '_PVT',
812: x_return_status);
813: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
815: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
816: RAISE OKL_API.G_EXCEPTION_ERROR;
817: END IF;
818: --- Validate all non-missing attributes (Item Level Validation)

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

811: '_PVT',
812: x_return_status);
813: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
815: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
816: RAISE OKL_API.G_EXCEPTION_ERROR;
817: END IF;
818: --- Validate all non-missing attributes (Item Level Validation)
819: l_return_status := Validate_Attributes(l_cfpv_rec);

Line 816: RAISE OKL_API.G_EXCEPTION_ERROR;

812: x_return_status);
813: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
815: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
816: RAISE OKL_API.G_EXCEPTION_ERROR;
817: END IF;
818: --- Validate all non-missing attributes (Item Level Validation)
819: l_return_status := Validate_Attributes(l_cfpv_rec);
820: --- If any errors happen abort API

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

817: END IF;
818: --- Validate all non-missing attributes (Item Level Validation)
819: l_return_status := Validate_Attributes(l_cfpv_rec);
820: --- If any errors happen abort API
821: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
822: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
823: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
824: RAISE OKL_API.G_EXCEPTION_ERROR;
825: END IF;

Line 822: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

818: --- Validate all non-missing attributes (Item Level Validation)
819: l_return_status := Validate_Attributes(l_cfpv_rec);
820: --- If any errors happen abort API
821: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
822: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
823: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
824: RAISE OKL_API.G_EXCEPTION_ERROR;
825: END IF;
826:

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

819: l_return_status := Validate_Attributes(l_cfpv_rec);
820: --- If any errors happen abort API
821: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
822: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
823: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
824: RAISE OKL_API.G_EXCEPTION_ERROR;
825: END IF;
826:
827: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,

Line 824: RAISE OKL_API.G_EXCEPTION_ERROR;

820: --- If any errors happen abort API
821: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
822: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
823: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
824: RAISE OKL_API.G_EXCEPTION_ERROR;
825: END IF;
826:
827: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
828: -- which has been moved to individaul valiadte attribute procedures

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

826:
827: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
828: -- which has been moved to individaul valiadte attribute procedures
829: /* l_return_status := Validate_Record(l_cfpv_rec);
830: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
831: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
832: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
833: RAISE OKL_API.G_EXCEPTION_ERROR;
834: END IF;

Line 831: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

827: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
828: -- which has been moved to individaul valiadte attribute procedures
829: /* l_return_status := Validate_Record(l_cfpv_rec);
830: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
831: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
832: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
833: RAISE OKL_API.G_EXCEPTION_ERROR;
834: END IF;
835: */

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

828: -- which has been moved to individaul valiadte attribute procedures
829: /* l_return_status := Validate_Record(l_cfpv_rec);
830: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
831: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
832: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
833: RAISE OKL_API.G_EXCEPTION_ERROR;
834: END IF;
835: */
836:

Line 833: RAISE OKL_API.G_EXCEPTION_ERROR;

829: /* l_return_status := Validate_Record(l_cfpv_rec);
830: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
831: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
832: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
833: RAISE OKL_API.G_EXCEPTION_ERROR;
834: END IF;
835: */
836:
837: x_return_status := l_return_status;

Line 839: WHEN OKL_API.G_EXCEPTION_ERROR THEN

835: */
836:
837: x_return_status := l_return_status;
838: EXCEPTION
839: WHEN OKL_API.G_EXCEPTION_ERROR THEN
840: x_return_status := OKL_API.HANDLE_EXCEPTIONS
841: (
842: l_api_name,
843: G_PKG_NAME,

Line 840: x_return_status := OKL_API.HANDLE_EXCEPTIONS

836:
837: x_return_status := l_return_status;
838: EXCEPTION
839: WHEN OKL_API.G_EXCEPTION_ERROR THEN
840: x_return_status := OKL_API.HANDLE_EXCEPTIONS
841: (
842: l_api_name,
843: G_PKG_NAME,
844: 'OKL_API.G_RET_STS_ERROR',

Line 844: 'OKL_API.G_RET_STS_ERROR',

840: x_return_status := OKL_API.HANDLE_EXCEPTIONS
841: (
842: l_api_name,
843: G_PKG_NAME,
844: 'OKL_API.G_RET_STS_ERROR',
845: x_msg_count,
846: x_msg_data,
847: '_PVT'
848: );

Line 849: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 850: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 854: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 860: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

876: x_return_status OUT NOCOPY VARCHAR2,
877: x_msg_count OUT NOCOPY NUMBER,
878: x_msg_data OUT NOCOPY VARCHAR2,
879: p_cfpv_tbl IN cfpv_tbl_type,
880: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
881:
882: l_api_version CONSTANT NUMBER := 1;
883: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
884: i NUMBER := 0;

Line 886: OKL_API.init_msg_list(p_init_msg_list);

882: l_api_version CONSTANT NUMBER := 1;
883: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
884: i NUMBER := 0;
885: BEGIN
886: OKL_API.init_msg_list(p_init_msg_list);
887: -- Make sure PL/SQL table has records in it before passing
888: IF (p_cfpv_tbl.COUNT > 0) THEN
889: i := p_cfpv_tbl.FIRST;
890: LOOP

Line 892: l_error_rec OKL_API.ERROR_REC_TYPE;

888: IF (p_cfpv_tbl.COUNT > 0) THEN
889: i := p_cfpv_tbl.FIRST;
890: LOOP
891: DECLARE
892: l_error_rec OKL_API.ERROR_REC_TYPE;
893: BEGIN
894: l_error_rec.api_name := l_api_name;
895: l_error_rec.api_package := G_PKG_NAME;
896: l_error_rec.idx := i;

Line 899: p_init_msg_list => OKL_API.G_FALSE,

895: l_error_rec.api_package := G_PKG_NAME;
896: l_error_rec.idx := i;
897: validate_row (
898: p_api_version => p_api_version,
899: p_init_msg_list => OKL_API.G_FALSE,
900: x_return_status => l_error_rec.error_type,
901: x_msg_count => l_error_rec.msg_count,
902: x_msg_data => l_error_rec.msg_data,
903: p_cfpv_rec => p_cfpv_tbl(i));

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

900: x_return_status => l_error_rec.error_type,
901: x_msg_count => l_error_rec.msg_count,
902: x_msg_data => l_error_rec.msg_data,
903: p_cfpv_rec => p_cfpv_tbl(i));
904: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
905: l_error_rec.sqlcode := SQLCODE;
906: load_error_tbl(l_error_rec, px_error_tbl);
907: ELSE
908: x_msg_count := l_error_rec.msg_count;

Line 912: WHEN OKL_API.G_EXCEPTION_ERROR THEN

908: x_msg_count := l_error_rec.msg_count;
909: x_msg_data := l_error_rec.msg_data;
910: END IF;
911: EXCEPTION
912: WHEN OKL_API.G_EXCEPTION_ERROR THEN
913: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
914: l_error_rec.sqlcode := SQLCODE;
915: load_error_tbl(l_error_rec, px_error_tbl);
916: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

909: x_msg_data := l_error_rec.msg_data;
910: END IF;
911: EXCEPTION
912: WHEN OKL_API.G_EXCEPTION_ERROR THEN
913: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
914: l_error_rec.sqlcode := SQLCODE;
915: load_error_tbl(l_error_rec, px_error_tbl);
916: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
917: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 916: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

912: WHEN OKL_API.G_EXCEPTION_ERROR THEN
913: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
914: l_error_rec.sqlcode := SQLCODE;
915: load_error_tbl(l_error_rec, px_error_tbl);
916: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
917: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
918: l_error_rec.sqlcode := SQLCODE;
919: load_error_tbl(l_error_rec, px_error_tbl);
920: WHEN OTHERS THEN

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

913: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
914: l_error_rec.sqlcode := SQLCODE;
915: load_error_tbl(l_error_rec, px_error_tbl);
916: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
917: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
918: l_error_rec.sqlcode := SQLCODE;
919: load_error_tbl(l_error_rec, px_error_tbl);
920: WHEN OTHERS THEN
921: l_error_rec.error_type := 'OTHERS';

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

928: END IF;
929: -- Loop through the error_tbl to find the error with the highest severity
930: -- and return it.
931: x_return_status := find_highest_exception(px_error_tbl);
932: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
933: EXCEPTION
934: WHEN OKL_API.G_EXCEPTION_ERROR THEN
935: x_return_status := OKL_API.HANDLE_EXCEPTIONS
936: (

Line 934: WHEN OKL_API.G_EXCEPTION_ERROR THEN

930: -- and return it.
931: x_return_status := find_highest_exception(px_error_tbl);
932: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
933: EXCEPTION
934: WHEN OKL_API.G_EXCEPTION_ERROR THEN
935: x_return_status := OKL_API.HANDLE_EXCEPTIONS
936: (
937: l_api_name,
938: G_PKG_NAME,

Line 935: x_return_status := OKL_API.HANDLE_EXCEPTIONS

931: x_return_status := find_highest_exception(px_error_tbl);
932: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
933: EXCEPTION
934: WHEN OKL_API.G_EXCEPTION_ERROR THEN
935: x_return_status := OKL_API.HANDLE_EXCEPTIONS
936: (
937: l_api_name,
938: G_PKG_NAME,
939: 'OKL_API.G_RET_STS_ERROR',

Line 939: 'OKL_API.G_RET_STS_ERROR',

935: x_return_status := OKL_API.HANDLE_EXCEPTIONS
936: (
937: l_api_name,
938: G_PKG_NAME,
939: 'OKL_API.G_RET_STS_ERROR',
940: x_msg_count,
941: x_msg_data,
942: '_PVT'
943: );

Line 944: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

940: x_msg_count,
941: x_msg_data,
942: '_PVT'
943: );
944: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
945: x_return_status := OKL_API.HANDLE_EXCEPTIONS
946: (
947: l_api_name,
948: G_PKG_NAME,

Line 945: x_return_status := OKL_API.HANDLE_EXCEPTIONS

941: x_msg_data,
942: '_PVT'
943: );
944: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
945: x_return_status := OKL_API.HANDLE_EXCEPTIONS
946: (
947: l_api_name,
948: G_PKG_NAME,
949: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 949: 'OKL_API.G_RET_STS_UNEXP_ERROR',

945: x_return_status := OKL_API.HANDLE_EXCEPTIONS
946: (
947: l_api_name,
948: G_PKG_NAME,
949: 'OKL_API.G_RET_STS_UNEXP_ERROR',
950: x_msg_count,
951: x_msg_data,
952: '_PVT'
953: );

Line 955: x_return_status := OKL_API.HANDLE_EXCEPTIONS

951: x_msg_data,
952: '_PVT'
953: );
954: WHEN OTHERS THEN
955: x_return_status := OKL_API.HANDLE_EXCEPTIONS
956: (
957: l_api_name,
958: G_PKG_NAME,
959: 'OTHERS',

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

975: p_cfpv_tbl IN cfpv_tbl_type) IS
976:
977: l_api_version CONSTANT NUMBER := 1;
978: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
979: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
980: l_error_tbl OKL_API.ERROR_TBL_TYPE;
981: BEGIN
982: OKL_API.init_msg_list(p_init_msg_list);
983: -- Make sure PL/SQL table has records in it before passing

Line 980: l_error_tbl OKL_API.ERROR_TBL_TYPE;

976:
977: l_api_version CONSTANT NUMBER := 1;
978: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
979: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
980: l_error_tbl OKL_API.ERROR_TBL_TYPE;
981: BEGIN
982: OKL_API.init_msg_list(p_init_msg_list);
983: -- Make sure PL/SQL table has records in it before passing
984: IF (p_cfpv_tbl.COUNT > 0) THEN

Line 982: OKL_API.init_msg_list(p_init_msg_list);

978: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
979: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
980: l_error_tbl OKL_API.ERROR_TBL_TYPE;
981: BEGIN
982: OKL_API.init_msg_list(p_init_msg_list);
983: -- Make sure PL/SQL table has records in it before passing
984: IF (p_cfpv_tbl.COUNT > 0) THEN
985: validate_row (
986: p_api_version => p_api_version,

Line 987: p_init_msg_list => OKL_API.G_FALSE,

983: -- Make sure PL/SQL table has records in it before passing
984: IF (p_cfpv_tbl.COUNT > 0) THEN
985: validate_row (
986: p_api_version => p_api_version,
987: p_init_msg_list => OKL_API.G_FALSE,
988: x_return_status => x_return_status,
989: x_msg_count => x_msg_count,
990: x_msg_data => x_msg_data,
991: p_cfpv_tbl => p_cfpv_tbl,

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

990: x_msg_data => x_msg_data,
991: p_cfpv_tbl => p_cfpv_tbl,
992: px_error_tbl => l_error_tbl);
993: END IF;
994: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
995: EXCEPTION
996: WHEN OKL_API.G_EXCEPTION_ERROR THEN
997: x_return_status := OKL_API.HANDLE_EXCEPTIONS
998: (

Line 996: WHEN OKL_API.G_EXCEPTION_ERROR THEN

992: px_error_tbl => l_error_tbl);
993: END IF;
994: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
995: EXCEPTION
996: WHEN OKL_API.G_EXCEPTION_ERROR THEN
997: x_return_status := OKL_API.HANDLE_EXCEPTIONS
998: (
999: l_api_name,
1000: G_PKG_NAME,

Line 997: x_return_status := OKL_API.HANDLE_EXCEPTIONS

993: END IF;
994: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
995: EXCEPTION
996: WHEN OKL_API.G_EXCEPTION_ERROR THEN
997: x_return_status := OKL_API.HANDLE_EXCEPTIONS
998: (
999: l_api_name,
1000: G_PKG_NAME,
1001: 'OKL_API.G_RET_STS_ERROR',

Line 1001: 'OKL_API.G_RET_STS_ERROR',

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

Line 1006: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1007: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1011: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1017: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1040: x_cfp_rec OUT NOCOPY cfp_rec_type) IS
1041:
1042: l_api_version CONSTANT NUMBER := 1;
1043: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1044: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1045: l_cfp_rec cfp_rec_type := p_cfp_rec;
1046: l_def_cfp_rec cfp_rec_type;
1047: ----------------------------------------------
1048: -- Set_Attributes for:OKL_CF_OBJECT_PERIODS --

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

1050: FUNCTION Set_Attributes (
1051: p_cfp_rec IN cfp_rec_type,
1052: x_cfp_rec OUT NOCOPY cfp_rec_type
1053: ) RETURN VARCHAR2 IS
1054: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1055: BEGIN
1056: x_cfp_rec := p_cfp_rec;
1057: RETURN(l_return_status);
1058: END Set_Attributes;

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

1056: x_cfp_rec := p_cfp_rec;
1057: RETURN(l_return_status);
1058: END Set_Attributes;
1059: BEGIN
1060: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1061: p_init_msg_list,
1062: '_PVT',
1063: x_return_status);
1064: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1060: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1061: p_init_msg_list,
1062: '_PVT',
1063: x_return_status);
1064: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1065: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1066: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1067: RAISE OKL_API.G_EXCEPTION_ERROR;
1068: END IF;

Line 1065: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1061: p_init_msg_list,
1062: '_PVT',
1063: x_return_status);
1064: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1065: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1066: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1067: RAISE OKL_API.G_EXCEPTION_ERROR;
1068: END IF;
1069: --- Setting item atributes

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

1062: '_PVT',
1063: x_return_status);
1064: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1065: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1066: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1067: RAISE OKL_API.G_EXCEPTION_ERROR;
1068: END IF;
1069: --- Setting item atributes
1070: l_return_status := Set_Attributes(

Line 1067: RAISE OKL_API.G_EXCEPTION_ERROR;

1063: x_return_status);
1064: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1065: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1066: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1067: RAISE OKL_API.G_EXCEPTION_ERROR;
1068: END IF;
1069: --- Setting item atributes
1070: l_return_status := Set_Attributes(
1071: p_cfp_rec, -- IN

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

1070: l_return_status := Set_Attributes(
1071: p_cfp_rec, -- IN
1072: l_cfp_rec); -- OUT
1073: --- If any errors happen abort API
1074: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1075: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1076: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1077: RAISE OKL_API.G_EXCEPTION_ERROR;
1078: END IF;

Line 1075: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1071: p_cfp_rec, -- IN
1072: l_cfp_rec); -- OUT
1073: --- If any errors happen abort API
1074: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1075: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1076: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1077: RAISE OKL_API.G_EXCEPTION_ERROR;
1078: END IF;
1079: INSERT INTO OKL_CF_OBJECT_PERIODS(

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

1072: l_cfp_rec); -- OUT
1073: --- If any errors happen abort API
1074: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1075: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1076: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1077: RAISE OKL_API.G_EXCEPTION_ERROR;
1078: END IF;
1079: INSERT INTO OKL_CF_OBJECT_PERIODS(
1080: id,

Line 1077: RAISE OKL_API.G_EXCEPTION_ERROR;

1073: --- If any errors happen abort API
1074: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1075: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1076: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1077: RAISE OKL_API.G_EXCEPTION_ERROR;
1078: END IF;
1079: INSERT INTO OKL_CF_OBJECT_PERIODS(
1080: id,
1081: cfo_id,

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

1134: l_cfp_rec.object_version_number);
1135: -- Set OUT values
1136: x_cfp_rec := l_cfp_rec;
1137: x_return_status := l_return_status;
1138: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1139: EXCEPTION
1140: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1141: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1142: (

Line 1140: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1136: x_cfp_rec := l_cfp_rec;
1137: x_return_status := l_return_status;
1138: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1139: EXCEPTION
1140: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1141: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1142: (
1143: l_api_name,
1144: G_PKG_NAME,

Line 1141: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1137: x_return_status := l_return_status;
1138: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1139: EXCEPTION
1140: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1141: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1142: (
1143: l_api_name,
1144: G_PKG_NAME,
1145: 'OKL_API.G_RET_STS_ERROR',

Line 1145: 'OKL_API.G_RET_STS_ERROR',

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

Line 1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1146: x_msg_count,
1147: x_msg_data,
1148: '_PVT'
1149: );
1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1151: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1152: (
1153: l_api_name,
1154: G_PKG_NAME,

Line 1151: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1147: x_msg_data,
1148: '_PVT'
1149: );
1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1151: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1152: (
1153: l_api_name,
1154: G_PKG_NAME,
1155: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1155: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1151: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1152: (
1153: l_api_name,
1154: G_PKG_NAME,
1155: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1156: x_msg_count,
1157: x_msg_data,
1158: '_PVT'
1159: );

Line 1161: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1157: x_msg_data,
1158: '_PVT'
1159: );
1160: WHEN OTHERS THEN
1161: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1162: (
1163: l_api_name,
1164: G_PKG_NAME,
1165: 'OTHERS',

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

1181: x_cfpv_rec OUT NOCOPY cfpv_rec_type) IS
1182:
1183: l_api_version CONSTANT NUMBER := 1;
1184: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1185: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1186: l_cfpv_rec cfpv_rec_type := p_cfpv_rec;
1187: l_def_cfpv_rec cfpv_rec_type;
1188: l_cfp_rec cfp_rec_type;
1189: lx_cfp_rec cfp_rec_type;

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

1208: FUNCTION Set_Attributes (
1209: p_cfpv_rec IN cfpv_rec_type,
1210: x_cfpv_rec OUT NOCOPY cfpv_rec_type
1211: ) RETURN VARCHAR2 IS
1212: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1213: BEGIN
1214: x_cfpv_rec := p_cfpv_rec;
1215: x_cfpv_rec.OBJECT_VERSION_NUMBER := 1;
1216: RETURN(l_return_status);

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

1215: x_cfpv_rec.OBJECT_VERSION_NUMBER := 1;
1216: RETURN(l_return_status);
1217: END Set_Attributes;
1218: BEGIN
1219: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1220: G_PKG_NAME,
1221: p_init_msg_list,
1222: l_api_version,
1223: p_api_version,

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

1222: l_api_version,
1223: p_api_version,
1224: '_PVT',
1225: x_return_status);
1226: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1228: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1229: RAISE OKL_API.G_EXCEPTION_ERROR;
1230: END IF;

Line 1227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1223: p_api_version,
1224: '_PVT',
1225: x_return_status);
1226: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1228: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1229: RAISE OKL_API.G_EXCEPTION_ERROR;
1230: END IF;
1231: l_cfpv_rec := null_out_defaults(p_cfpv_rec);

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

1224: '_PVT',
1225: x_return_status);
1226: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1228: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1229: RAISE OKL_API.G_EXCEPTION_ERROR;
1230: END IF;
1231: l_cfpv_rec := null_out_defaults(p_cfpv_rec);
1232: -- Set primary key value

Line 1229: RAISE OKL_API.G_EXCEPTION_ERROR;

1225: x_return_status);
1226: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1228: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1229: RAISE OKL_API.G_EXCEPTION_ERROR;
1230: END IF;
1231: l_cfpv_rec := null_out_defaults(p_cfpv_rec);
1232: -- Set primary key value
1233: l_cfpv_rec.ID := get_seq_id;

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

1235: l_return_Status := Set_Attributes(
1236: l_cfpv_rec, -- IN
1237: l_def_cfpv_rec); -- OUT
1238: --- If any errors happen abort API
1239: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1240: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1241: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1242: RAISE OKL_API.G_EXCEPTION_ERROR;
1243: END IF;

Line 1240: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1236: l_cfpv_rec, -- IN
1237: l_def_cfpv_rec); -- OUT
1238: --- If any errors happen abort API
1239: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1240: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1241: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1242: RAISE OKL_API.G_EXCEPTION_ERROR;
1243: END IF;
1244: l_def_cfpv_rec := fill_who_columns(l_def_cfpv_rec);

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

1237: l_def_cfpv_rec); -- OUT
1238: --- If any errors happen abort API
1239: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1240: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1241: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1242: RAISE OKL_API.G_EXCEPTION_ERROR;
1243: END IF;
1244: l_def_cfpv_rec := fill_who_columns(l_def_cfpv_rec);
1245: --- Validate all non-missing attributes (Item Level Validation)

Line 1242: RAISE OKL_API.G_EXCEPTION_ERROR;

1238: --- If any errors happen abort API
1239: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1240: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1241: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1242: RAISE OKL_API.G_EXCEPTION_ERROR;
1243: END IF;
1244: l_def_cfpv_rec := fill_who_columns(l_def_cfpv_rec);
1245: --- Validate all non-missing attributes (Item Level Validation)
1246: l_return_status := Validate_Attributes(l_def_cfpv_rec);

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

1244: l_def_cfpv_rec := fill_who_columns(l_def_cfpv_rec);
1245: --- Validate all non-missing attributes (Item Level Validation)
1246: l_return_status := Validate_Attributes(l_def_cfpv_rec);
1247: --- If any errors happen abort API
1248: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1249: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1250: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1251: RAISE OKL_API.G_EXCEPTION_ERROR;
1252: END IF;

Line 1249: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1245: --- Validate all non-missing attributes (Item Level Validation)
1246: l_return_status := Validate_Attributes(l_def_cfpv_rec);
1247: --- If any errors happen abort API
1248: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1249: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1250: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1251: RAISE OKL_API.G_EXCEPTION_ERROR;
1252: END IF;
1253: /*

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

1246: l_return_status := Validate_Attributes(l_def_cfpv_rec);
1247: --- If any errors happen abort API
1248: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1249: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1250: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1251: RAISE OKL_API.G_EXCEPTION_ERROR;
1252: END IF;
1253: /*
1254: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,

Line 1251: RAISE OKL_API.G_EXCEPTION_ERROR;

1247: --- If any errors happen abort API
1248: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1249: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1250: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1251: RAISE OKL_API.G_EXCEPTION_ERROR;
1252: END IF;
1253: /*
1254: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
1255: -- which has been moved to individaul valiadte attribute procedures

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

1253: /*
1254: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
1255: -- which has been moved to individaul valiadte attribute procedures
1256: l_return_status := Validate_Record(l_def_cfpv_rec);
1257: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1258: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1259: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1260: RAISE OKL_API.G_EXCEPTION_ERROR;
1261: END IF;

Line 1258: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1254: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
1255: -- which has been moved to individaul valiadte attribute procedures
1256: l_return_status := Validate_Record(l_def_cfpv_rec);
1257: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1258: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1259: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1260: RAISE OKL_API.G_EXCEPTION_ERROR;
1261: END IF;
1262: */

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

1255: -- which has been moved to individaul valiadte attribute procedures
1256: l_return_status := Validate_Record(l_def_cfpv_rec);
1257: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1258: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1259: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1260: RAISE OKL_API.G_EXCEPTION_ERROR;
1261: END IF;
1262: */
1263: -----------------------------------------

Line 1260: RAISE OKL_API.G_EXCEPTION_ERROR;

1256: l_return_status := Validate_Record(l_def_cfpv_rec);
1257: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1258: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1259: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1260: RAISE OKL_API.G_EXCEPTION_ERROR;
1261: END IF;
1262: */
1263: -----------------------------------------
1264: -- Move VIEW record to "Child" records --

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

1274: x_msg_data,
1275: l_cfp_rec,
1276: lx_cfp_rec
1277: );
1278: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1279: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1280: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1281: RAISE OKL_API.G_EXCEPTION_ERROR;
1282: END IF;

Line 1279: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1275: l_cfp_rec,
1276: lx_cfp_rec
1277: );
1278: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1279: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1280: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1281: RAISE OKL_API.G_EXCEPTION_ERROR;
1282: END IF;
1283: migrate(lx_cfp_rec, l_def_cfpv_rec);

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

1276: lx_cfp_rec
1277: );
1278: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1279: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1280: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1281: RAISE OKL_API.G_EXCEPTION_ERROR;
1282: END IF;
1283: migrate(lx_cfp_rec, l_def_cfpv_rec);
1284: -- Set OUT values

Line 1281: RAISE OKL_API.G_EXCEPTION_ERROR;

1277: );
1278: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1279: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1280: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1281: RAISE OKL_API.G_EXCEPTION_ERROR;
1282: END IF;
1283: migrate(lx_cfp_rec, l_def_cfpv_rec);
1284: -- Set OUT values
1285: x_cfpv_rec := l_def_cfpv_rec;

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

1283: migrate(lx_cfp_rec, l_def_cfpv_rec);
1284: -- Set OUT values
1285: x_cfpv_rec := l_def_cfpv_rec;
1286: x_return_status := l_return_status;
1287: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1288: EXCEPTION
1289: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1290: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1291: (

Line 1289: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1285: x_cfpv_rec := l_def_cfpv_rec;
1286: x_return_status := l_return_status;
1287: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1288: EXCEPTION
1289: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1290: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1291: (
1292: l_api_name,
1293: G_PKG_NAME,

Line 1290: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1294: 'OKL_API.G_RET_STS_ERROR',

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

Line 1299: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1300: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1304: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1310: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1327: x_msg_count OUT NOCOPY NUMBER,
1328: x_msg_data OUT NOCOPY VARCHAR2,
1329: p_cfpv_tbl IN cfpv_tbl_type,
1330: x_cfpv_tbl OUT NOCOPY cfpv_tbl_type,
1331: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1332:
1333: l_api_version CONSTANT NUMBER := 1;
1334: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1335: i NUMBER := 0;

Line 1337: OKL_API.init_msg_list(p_init_msg_list);

1333: l_api_version CONSTANT NUMBER := 1;
1334: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1335: i NUMBER := 0;
1336: BEGIN
1337: OKL_API.init_msg_list(p_init_msg_list);
1338: -- Make sure PL/SQL table has records in it before passing
1339: IF (p_cfpv_tbl.COUNT > 0) THEN
1340: i := p_cfpv_tbl.FIRST;
1341: LOOP

Line 1343: l_error_rec OKL_API.ERROR_REC_TYPE;

1339: IF (p_cfpv_tbl.COUNT > 0) THEN
1340: i := p_cfpv_tbl.FIRST;
1341: LOOP
1342: DECLARE
1343: l_error_rec OKL_API.ERROR_REC_TYPE;
1344: BEGIN
1345: l_error_rec.api_name := l_api_name;
1346: l_error_rec.api_package := G_PKG_NAME;
1347: l_error_rec.idx := i;

Line 1350: p_init_msg_list => OKL_API.G_FALSE,

1346: l_error_rec.api_package := G_PKG_NAME;
1347: l_error_rec.idx := i;
1348: insert_row (
1349: p_api_version => p_api_version,
1350: p_init_msg_list => OKL_API.G_FALSE,
1351: x_return_status => l_error_rec.error_type,
1352: x_msg_count => l_error_rec.msg_count,
1353: x_msg_data => l_error_rec.msg_data,
1354: p_cfpv_rec => p_cfpv_tbl(i),

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

1352: x_msg_count => l_error_rec.msg_count,
1353: x_msg_data => l_error_rec.msg_data,
1354: p_cfpv_rec => p_cfpv_tbl(i),
1355: x_cfpv_rec => x_cfpv_tbl(i));
1356: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
1357: l_error_rec.sqlcode := SQLCODE;
1358: load_error_tbl(l_error_rec, px_error_tbl);
1359: ELSE
1360: x_msg_count := l_error_rec.msg_count;

Line 1364: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1360: x_msg_count := l_error_rec.msg_count;
1361: x_msg_data := l_error_rec.msg_data;
1362: END IF;
1363: EXCEPTION
1364: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1365: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1366: l_error_rec.sqlcode := SQLCODE;
1367: load_error_tbl(l_error_rec, px_error_tbl);
1368: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

1361: x_msg_data := l_error_rec.msg_data;
1362: END IF;
1363: EXCEPTION
1364: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1365: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1366: l_error_rec.sqlcode := SQLCODE;
1367: load_error_tbl(l_error_rec, px_error_tbl);
1368: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1369: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1368: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1364: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1365: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1366: l_error_rec.sqlcode := SQLCODE;
1367: load_error_tbl(l_error_rec, px_error_tbl);
1368: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1369: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1370: l_error_rec.sqlcode := SQLCODE;
1371: load_error_tbl(l_error_rec, px_error_tbl);
1372: WHEN OTHERS THEN

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

1365: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1366: l_error_rec.sqlcode := SQLCODE;
1367: load_error_tbl(l_error_rec, px_error_tbl);
1368: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1369: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1370: l_error_rec.sqlcode := SQLCODE;
1371: load_error_tbl(l_error_rec, px_error_tbl);
1372: WHEN OTHERS THEN
1373: l_error_rec.error_type := 'OTHERS';

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

1380: END IF;
1381: -- Loop through the error_tbl to find the error with the highest severity
1382: -- and return it.
1383: x_return_status := find_highest_exception(px_error_tbl);
1384: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1385: EXCEPTION
1386: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1387: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1388: (

Line 1386: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1382: -- and return it.
1383: x_return_status := find_highest_exception(px_error_tbl);
1384: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1385: EXCEPTION
1386: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1387: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1388: (
1389: l_api_name,
1390: G_PKG_NAME,

Line 1387: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1391: 'OKL_API.G_RET_STS_ERROR',

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

Line 1396: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1397: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1401: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1407: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1430: x_cfpv_tbl OUT NOCOPY cfpv_tbl_type) IS
1431:
1432: l_api_version CONSTANT NUMBER := 1;
1433: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1435: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1436: BEGIN
1437: OKL_API.init_msg_list(p_init_msg_list);
1438: -- Make sure PL/SQL table has records in it before passing

Line 1435: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1431:
1432: l_api_version CONSTANT NUMBER := 1;
1433: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1435: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1436: BEGIN
1437: OKL_API.init_msg_list(p_init_msg_list);
1438: -- Make sure PL/SQL table has records in it before passing
1439: IF (p_cfpv_tbl.COUNT > 0) THEN

Line 1437: OKL_API.init_msg_list(p_init_msg_list);

1433: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1435: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1436: BEGIN
1437: OKL_API.init_msg_list(p_init_msg_list);
1438: -- Make sure PL/SQL table has records in it before passing
1439: IF (p_cfpv_tbl.COUNT > 0) THEN
1440: insert_row (
1441: p_api_version => p_api_version,

Line 1442: p_init_msg_list => OKL_API.G_FALSE,

1438: -- Make sure PL/SQL table has records in it before passing
1439: IF (p_cfpv_tbl.COUNT > 0) THEN
1440: insert_row (
1441: p_api_version => p_api_version,
1442: p_init_msg_list => OKL_API.G_FALSE,
1443: x_return_status => x_return_status,
1444: x_msg_count => x_msg_count,
1445: x_msg_data => x_msg_data,
1446: p_cfpv_tbl => p_cfpv_tbl,

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

1446: p_cfpv_tbl => p_cfpv_tbl,
1447: x_cfpv_tbl => x_cfpv_tbl,
1448: px_error_tbl => l_error_tbl);
1449: END IF;
1450: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1451: EXCEPTION
1452: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1453: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1454: (

Line 1452: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1448: px_error_tbl => l_error_tbl);
1449: END IF;
1450: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1451: EXCEPTION
1452: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1453: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1454: (
1455: l_api_name,
1456: G_PKG_NAME,

Line 1453: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1449: END IF;
1450: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1451: EXCEPTION
1452: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1453: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1454: (
1455: l_api_name,
1456: G_PKG_NAME,
1457: 'OKL_API.G_RET_STS_ERROR',

Line 1457: 'OKL_API.G_RET_STS_ERROR',

1453: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1454: (
1455: l_api_name,
1456: G_PKG_NAME,
1457: 'OKL_API.G_RET_STS_ERROR',
1458: x_msg_count,
1459: x_msg_data,
1460: '_PVT'
1461: );

Line 1462: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1458: x_msg_count,
1459: x_msg_data,
1460: '_PVT'
1461: );
1462: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1463: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1464: (
1465: l_api_name,
1466: G_PKG_NAME,

Line 1463: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1459: x_msg_data,
1460: '_PVT'
1461: );
1462: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1463: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1464: (
1465: l_api_name,
1466: G_PKG_NAME,
1467: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1467: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1463: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1464: (
1465: l_api_name,
1466: G_PKG_NAME,
1467: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1468: x_msg_count,
1469: x_msg_data,
1470: '_PVT'
1471: );

Line 1473: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1469: x_msg_data,
1470: '_PVT'
1471: );
1472: WHEN OTHERS THEN
1473: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1474: (
1475: l_api_name,
1476: G_PKG_NAME,
1477: 'OTHERS',

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

1508: FROM OKL_CF_OBJECT_PERIODS
1509: WHERE ID = p_cfp_rec.id;
1510: l_api_version CONSTANT NUMBER := 1;
1511: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1512: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1513: l_object_version_number OKL_CF_OBJECT_PERIODS.OBJECT_VERSION_NUMBER%TYPE;
1514: lc_object_version_number OKL_CF_OBJECT_PERIODS.OBJECT_VERSION_NUMBER%TYPE;
1515: l_row_notfound BOOLEAN := FALSE;
1516: lc_row_notfound BOOLEAN := FALSE;

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

1514: lc_object_version_number OKL_CF_OBJECT_PERIODS.OBJECT_VERSION_NUMBER%TYPE;
1515: l_row_notfound BOOLEAN := FALSE;
1516: lc_row_notfound BOOLEAN := FALSE;
1517: BEGIN
1518: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1519: p_init_msg_list,
1520: '_PVT',
1521: x_return_status);
1522: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

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

Line 1523: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1519: p_init_msg_list,
1520: '_PVT',
1521: x_return_status);
1522: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1524: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1525: RAISE OKL_API.G_EXCEPTION_ERROR;
1526: END IF;
1527: BEGIN

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

1520: '_PVT',
1521: x_return_status);
1522: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1524: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1525: RAISE OKL_API.G_EXCEPTION_ERROR;
1526: END IF;
1527: BEGIN
1528: OPEN lock_csr(p_cfp_rec);

Line 1525: RAISE OKL_API.G_EXCEPTION_ERROR;

1521: x_return_status);
1522: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1524: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1525: RAISE OKL_API.G_EXCEPTION_ERROR;
1526: END IF;
1527: BEGIN
1528: OPEN lock_csr(p_cfp_rec);
1529: FETCH lock_csr INTO l_object_version_number;

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

1533: WHEN E_Resource_Busy THEN
1534: IF (lock_csr%ISOPEN) THEN
1535: CLOSE lock_csr;
1536: END IF;
1537: OKL_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1538: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1539: END;
1540:
1541: IF ( l_row_notfound ) THEN

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

1544: lc_row_notfound := lchk_csr%NOTFOUND;
1545: CLOSE lchk_csr;
1546: END IF;
1547: IF (lc_row_notfound) THEN
1548: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1549: RAISE OKL_API.G_EXCEPTION_ERROR;
1550: ELSIF lc_object_version_number > p_cfp_rec.object_version_number THEN
1551: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1552: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1549: RAISE OKL_API.G_EXCEPTION_ERROR;

1545: CLOSE lchk_csr;
1546: END IF;
1547: IF (lc_row_notfound) THEN
1548: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1549: RAISE OKL_API.G_EXCEPTION_ERROR;
1550: ELSIF lc_object_version_number > p_cfp_rec.object_version_number THEN
1551: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1552: RAISE OKL_API.G_EXCEPTION_ERROR;
1553: ELSIF lc_object_version_number <> p_cfp_rec.object_version_number THEN

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

1547: IF (lc_row_notfound) THEN
1548: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1549: RAISE OKL_API.G_EXCEPTION_ERROR;
1550: ELSIF lc_object_version_number > p_cfp_rec.object_version_number THEN
1551: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1552: RAISE OKL_API.G_EXCEPTION_ERROR;
1553: ELSIF lc_object_version_number <> p_cfp_rec.object_version_number THEN
1554: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1555: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1552: RAISE OKL_API.G_EXCEPTION_ERROR;

1548: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1549: RAISE OKL_API.G_EXCEPTION_ERROR;
1550: ELSIF lc_object_version_number > p_cfp_rec.object_version_number THEN
1551: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1552: RAISE OKL_API.G_EXCEPTION_ERROR;
1553: ELSIF lc_object_version_number <> p_cfp_rec.object_version_number THEN
1554: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1555: RAISE OKL_API.G_EXCEPTION_ERROR;
1556: ELSIF lc_object_version_number = -1 THEN

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

1550: ELSIF lc_object_version_number > p_cfp_rec.object_version_number THEN
1551: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1552: RAISE OKL_API.G_EXCEPTION_ERROR;
1553: ELSIF lc_object_version_number <> p_cfp_rec.object_version_number THEN
1554: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1555: RAISE OKL_API.G_EXCEPTION_ERROR;
1556: ELSIF lc_object_version_number = -1 THEN
1557: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1558: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1555: RAISE OKL_API.G_EXCEPTION_ERROR;

1551: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1552: RAISE OKL_API.G_EXCEPTION_ERROR;
1553: ELSIF lc_object_version_number <> p_cfp_rec.object_version_number THEN
1554: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1555: RAISE OKL_API.G_EXCEPTION_ERROR;
1556: ELSIF lc_object_version_number = -1 THEN
1557: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1558: RAISE OKL_API.G_EXCEPTION_ERROR;
1559: END IF;

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

1553: ELSIF lc_object_version_number <> p_cfp_rec.object_version_number THEN
1554: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1555: RAISE OKL_API.G_EXCEPTION_ERROR;
1556: ELSIF lc_object_version_number = -1 THEN
1557: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1558: RAISE OKL_API.G_EXCEPTION_ERROR;
1559: END IF;
1560: x_return_status := l_return_status;
1561: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1558: RAISE OKL_API.G_EXCEPTION_ERROR;

1554: OKL_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1555: RAISE OKL_API.G_EXCEPTION_ERROR;
1556: ELSIF lc_object_version_number = -1 THEN
1557: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1558: RAISE OKL_API.G_EXCEPTION_ERROR;
1559: END IF;
1560: x_return_status := l_return_status;
1561: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1562: EXCEPTION

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

1557: OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1558: RAISE OKL_API.G_EXCEPTION_ERROR;
1559: END IF;
1560: x_return_status := l_return_status;
1561: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1562: EXCEPTION
1563: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1564: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1565: (

Line 1563: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1559: END IF;
1560: x_return_status := l_return_status;
1561: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1562: EXCEPTION
1563: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1564: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1565: (
1566: l_api_name,
1567: G_PKG_NAME,

Line 1564: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1560: x_return_status := l_return_status;
1561: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1562: EXCEPTION
1563: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1564: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1565: (
1566: l_api_name,
1567: G_PKG_NAME,
1568: 'OKL_API.G_RET_STS_ERROR',

Line 1568: 'OKL_API.G_RET_STS_ERROR',

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

Line 1573: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1569: x_msg_count,
1570: x_msg_data,
1571: '_PVT'
1572: );
1573: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1574: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1575: (
1576: l_api_name,
1577: G_PKG_NAME,

Line 1574: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1570: x_msg_data,
1571: '_PVT'
1572: );
1573: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1574: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1575: (
1576: l_api_name,
1577: G_PKG_NAME,
1578: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1578: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1574: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1575: (
1576: l_api_name,
1577: G_PKG_NAME,
1578: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1579: x_msg_count,
1580: x_msg_data,
1581: '_PVT'
1582: );

Line 1584: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1580: x_msg_data,
1581: '_PVT'
1582: );
1583: WHEN OTHERS THEN
1584: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1585: (
1586: l_api_name,
1587: G_PKG_NAME,
1588: 'OTHERS',

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

1603: p_cfpv_rec IN cfpv_rec_type) IS
1604:
1605: l_api_version CONSTANT NUMBER := 1;
1606: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1607: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1608: l_cfp_rec cfp_rec_type;
1609: BEGIN
1610: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1611: G_PKG_NAME,

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

1606: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1607: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1608: l_cfp_rec cfp_rec_type;
1609: BEGIN
1610: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1611: G_PKG_NAME,
1612: p_init_msg_list,
1613: l_api_version,
1614: p_api_version,

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

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

Line 1618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1614: p_api_version,
1615: '_PVT',
1616: x_return_status);
1617: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1619: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1620: RAISE OKL_API.G_EXCEPTION_ERROR;
1621: END IF;
1622: -----------------------------------------

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

1615: '_PVT',
1616: x_return_status);
1617: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1619: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1620: RAISE OKL_API.G_EXCEPTION_ERROR;
1621: END IF;
1622: -----------------------------------------
1623: -- Move VIEW record to "Child" records --

Line 1620: RAISE OKL_API.G_EXCEPTION_ERROR;

1616: x_return_status);
1617: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1619: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1620: RAISE OKL_API.G_EXCEPTION_ERROR;
1621: END IF;
1622: -----------------------------------------
1623: -- Move VIEW record to "Child" records --
1624: -----------------------------------------

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

1632: x_msg_count,
1633: x_msg_data,
1634: l_cfp_rec
1635: );
1636: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1638: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1639: RAISE OKL_API.G_EXCEPTION_ERROR;
1640: END IF;

Line 1637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1633: x_msg_data,
1634: l_cfp_rec
1635: );
1636: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1638: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1639: RAISE OKL_API.G_EXCEPTION_ERROR;
1640: END IF;
1641: x_return_status := l_return_status;

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

1634: l_cfp_rec
1635: );
1636: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1638: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1639: RAISE OKL_API.G_EXCEPTION_ERROR;
1640: END IF;
1641: x_return_status := l_return_status;
1642: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1639: RAISE OKL_API.G_EXCEPTION_ERROR;

1635: );
1636: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1638: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1639: RAISE OKL_API.G_EXCEPTION_ERROR;
1640: END IF;
1641: x_return_status := l_return_status;
1642: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1643: EXCEPTION

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

1638: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1639: RAISE OKL_API.G_EXCEPTION_ERROR;
1640: END IF;
1641: x_return_status := l_return_status;
1642: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1643: EXCEPTION
1644: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1645: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1646: (

Line 1644: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1640: END IF;
1641: x_return_status := l_return_status;
1642: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1643: EXCEPTION
1644: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1645: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1646: (
1647: l_api_name,
1648: G_PKG_NAME,

Line 1645: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1649: 'OKL_API.G_RET_STS_ERROR',

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

Line 1654: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1655: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1659: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1665: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1681: x_return_status OUT NOCOPY VARCHAR2,
1682: x_msg_count OUT NOCOPY NUMBER,
1683: x_msg_data OUT NOCOPY VARCHAR2,
1684: p_cfpv_tbl IN cfpv_tbl_type,
1685: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
1686:
1687: l_api_version CONSTANT NUMBER := 1;
1688: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1689: i NUMBER := 0;

Line 1691: OKL_API.init_msg_list(p_init_msg_list);

1687: l_api_version CONSTANT NUMBER := 1;
1688: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1689: i NUMBER := 0;
1690: BEGIN
1691: OKL_API.init_msg_list(p_init_msg_list);
1692: -- Make sure PL/SQL table has recrods in it before passing
1693: IF (p_cfpv_tbl.COUNT > 0) THEN
1694: i := p_cfpv_tbl.FIRST;
1695: LOOP

Line 1697: l_error_rec OKL_API.ERROR_REC_TYPE;

1693: IF (p_cfpv_tbl.COUNT > 0) THEN
1694: i := p_cfpv_tbl.FIRST;
1695: LOOP
1696: DECLARE
1697: l_error_rec OKL_API.ERROR_REC_TYPE;
1698: BEGIN
1699: l_error_rec.api_name := l_api_name;
1700: l_error_rec.api_package := G_PKG_NAME;
1701: l_error_rec.idx := i;

Line 1704: p_init_msg_list => OKL_API.G_FALSE,

1700: l_error_rec.api_package := G_PKG_NAME;
1701: l_error_rec.idx := i;
1702: lock_row(
1703: p_api_version => p_api_version,
1704: p_init_msg_list => OKL_API.G_FALSE,
1705: x_return_status => l_error_rec.error_type,
1706: x_msg_count => l_error_rec.msg_count,
1707: x_msg_data => l_error_rec.msg_data,
1708: p_cfpv_rec => p_cfpv_tbl(i));

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

1705: x_return_status => l_error_rec.error_type,
1706: x_msg_count => l_error_rec.msg_count,
1707: x_msg_data => l_error_rec.msg_data,
1708: p_cfpv_rec => p_cfpv_tbl(i));
1709: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
1710: l_error_rec.sqlcode := SQLCODE;
1711: load_error_tbl(l_error_rec, px_error_tbl);
1712: ELSE
1713: x_msg_count := l_error_rec.msg_count;

Line 1717: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1713: x_msg_count := l_error_rec.msg_count;
1714: x_msg_data := l_error_rec.msg_data;
1715: END IF;
1716: EXCEPTION
1717: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1718: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1719: l_error_rec.sqlcode := SQLCODE;
1720: load_error_tbl(l_error_rec, px_error_tbl);
1721: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

1714: x_msg_data := l_error_rec.msg_data;
1715: END IF;
1716: EXCEPTION
1717: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1718: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1719: l_error_rec.sqlcode := SQLCODE;
1720: load_error_tbl(l_error_rec, px_error_tbl);
1721: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1722: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1721: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1717: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1718: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1719: l_error_rec.sqlcode := SQLCODE;
1720: load_error_tbl(l_error_rec, px_error_tbl);
1721: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1722: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1723: l_error_rec.sqlcode := SQLCODE;
1724: load_error_tbl(l_error_rec, px_error_tbl);
1725: WHEN OTHERS THEN

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

1718: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
1719: l_error_rec.sqlcode := SQLCODE;
1720: load_error_tbl(l_error_rec, px_error_tbl);
1721: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1722: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
1723: l_error_rec.sqlcode := SQLCODE;
1724: load_error_tbl(l_error_rec, px_error_tbl);
1725: WHEN OTHERS THEN
1726: l_error_rec.error_type := 'OTHERS';

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

1733: END IF;
1734: -- Loop through the error_tbl to find the error with the highest severity
1735: -- and return it.
1736: x_return_status := find_highest_exception(px_error_tbl);
1737: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1738: EXCEPTION
1739: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1740: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1741: (

Line 1739: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1735: -- and return it.
1736: x_return_status := find_highest_exception(px_error_tbl);
1737: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1738: EXCEPTION
1739: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1740: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1741: (
1742: l_api_name,
1743: G_PKG_NAME,

Line 1740: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1744: 'OKL_API.G_RET_STS_ERROR',

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

Line 1749: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1750: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 1754: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1760: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

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

1779: p_cfpv_tbl IN cfpv_tbl_type) IS
1780:
1781: l_api_version CONSTANT NUMBER := 1;
1782: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1783: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1784: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1785: BEGIN
1786: OKL_API.init_msg_list(p_init_msg_list);
1787: -- Make sure PL/SQL table has recrods in it before passing

Line 1784: l_error_tbl OKL_API.ERROR_TBL_TYPE;

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

Line 1786: OKL_API.init_msg_list(p_init_msg_list);

1782: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1783: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1784: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1785: BEGIN
1786: OKL_API.init_msg_list(p_init_msg_list);
1787: -- Make sure PL/SQL table has recrods in it before passing
1788: IF (p_cfpv_tbl.COUNT > 0) THEN
1789: lock_row(
1790: p_api_version => p_api_version,

Line 1791: p_init_msg_list => OKL_API.G_FALSE,

1787: -- Make sure PL/SQL table has recrods in it before passing
1788: IF (p_cfpv_tbl.COUNT > 0) THEN
1789: lock_row(
1790: p_api_version => p_api_version,
1791: p_init_msg_list => OKL_API.G_FALSE,
1792: x_return_status => x_return_status,
1793: x_msg_count => x_msg_count,
1794: x_msg_data => x_msg_data,
1795: p_cfpv_tbl => p_cfpv_tbl,

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

1794: x_msg_data => x_msg_data,
1795: p_cfpv_tbl => p_cfpv_tbl,
1796: px_error_tbl => l_error_tbl);
1797: END IF;
1798: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1799: EXCEPTION
1800: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1801: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1802: (

Line 1800: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1796: px_error_tbl => l_error_tbl);
1797: END IF;
1798: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1799: EXCEPTION
1800: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1801: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1802: (
1803: l_api_name,
1804: G_PKG_NAME,

Line 1801: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1797: END IF;
1798: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1799: EXCEPTION
1800: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1801: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1802: (
1803: l_api_name,
1804: G_PKG_NAME,
1805: 'OKL_API.G_RET_STS_ERROR',

Line 1805: 'OKL_API.G_RET_STS_ERROR',

1801: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1802: (
1803: l_api_name,
1804: G_PKG_NAME,
1805: 'OKL_API.G_RET_STS_ERROR',
1806: x_msg_count,
1807: x_msg_data,
1808: '_PVT'
1809: );

Line 1810: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1806: x_msg_count,
1807: x_msg_data,
1808: '_PVT'
1809: );
1810: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1811: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1812: (
1813: l_api_name,
1814: G_PKG_NAME,

Line 1811: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1807: x_msg_data,
1808: '_PVT'
1809: );
1810: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1811: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1812: (
1813: l_api_name,
1814: G_PKG_NAME,
1815: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1815: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1811: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1812: (
1813: l_api_name,
1814: G_PKG_NAME,
1815: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1816: x_msg_count,
1817: x_msg_data,
1818: '_PVT'
1819: );

Line 1821: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1817: x_msg_data,
1818: '_PVT'
1819: );
1820: WHEN OTHERS THEN
1821: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1822: (
1823: l_api_name,
1824: G_PKG_NAME,
1825: 'OTHERS',

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

1843: x_cfp_rec OUT NOCOPY cfp_rec_type) IS
1844:
1845: l_api_version CONSTANT NUMBER := 1;
1846: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1847: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1848: l_cfp_rec cfp_rec_type := p_cfp_rec;
1849: l_def_cfp_rec cfp_rec_type;
1850: l_row_notfound BOOLEAN := TRUE;
1851: ----------------------------------

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

1856: x_cfp_rec OUT NOCOPY cfp_rec_type
1857: ) RETURN VARCHAR2 IS
1858: l_cfp_rec cfp_rec_type;
1859: l_row_notfound BOOLEAN := TRUE;
1860: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1861: BEGIN
1862: x_cfp_rec := p_cfp_rec;
1863: -- Get current database values
1864: l_cfp_rec := get_rec(p_cfp_rec, l_return_status);

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

1861: BEGIN
1862: x_cfp_rec := p_cfp_rec;
1863: -- Get current database values
1864: l_cfp_rec := get_rec(p_cfp_rec, l_return_status);
1865: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1866: IF (x_cfp_rec.id = OKL_API.G_MISS_NUM)
1867: THEN
1868: x_cfp_rec.id := l_cfp_rec.id;
1869: END IF;

Line 1866: IF (x_cfp_rec.id = OKL_API.G_MISS_NUM)

1862: x_cfp_rec := p_cfp_rec;
1863: -- Get current database values
1864: l_cfp_rec := get_rec(p_cfp_rec, l_return_status);
1865: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1866: IF (x_cfp_rec.id = OKL_API.G_MISS_NUM)
1867: THEN
1868: x_cfp_rec.id := l_cfp_rec.id;
1869: END IF;
1870: IF (x_cfp_rec.cfo_id = OKL_API.G_MISS_NUM)

Line 1870: IF (x_cfp_rec.cfo_id = OKL_API.G_MISS_NUM)

1866: IF (x_cfp_rec.id = OKL_API.G_MISS_NUM)
1867: THEN
1868: x_cfp_rec.id := l_cfp_rec.id;
1869: END IF;
1870: IF (x_cfp_rec.cfo_id = OKL_API.G_MISS_NUM)
1871: THEN
1872: x_cfp_rec.cfo_id := l_cfp_rec.cfo_id;
1873: END IF;
1874: IF (x_cfp_rec.ptp_code = OKL_API.G_MISS_CHAR)

Line 1874: IF (x_cfp_rec.ptp_code = OKL_API.G_MISS_CHAR)

1870: IF (x_cfp_rec.cfo_id = OKL_API.G_MISS_NUM)
1871: THEN
1872: x_cfp_rec.cfo_id := l_cfp_rec.cfo_id;
1873: END IF;
1874: IF (x_cfp_rec.ptp_code = OKL_API.G_MISS_CHAR)
1875: THEN
1876: x_cfp_rec.ptp_code := l_cfp_rec.ptp_code;
1877: END IF;
1878: IF (x_cfp_rec.start_date = OKL_API.G_MISS_DATE)

Line 1878: IF (x_cfp_rec.start_date = OKL_API.G_MISS_DATE)

1874: IF (x_cfp_rec.ptp_code = OKL_API.G_MISS_CHAR)
1875: THEN
1876: x_cfp_rec.ptp_code := l_cfp_rec.ptp_code;
1877: END IF;
1878: IF (x_cfp_rec.start_date = OKL_API.G_MISS_DATE)
1879: THEN
1880: x_cfp_rec.start_date := l_cfp_rec.start_date;
1881: END IF;
1882: IF (x_cfp_rec.end_date = OKL_API.G_MISS_CHAR)

Line 1882: IF (x_cfp_rec.end_date = OKL_API.G_MISS_CHAR)

1878: IF (x_cfp_rec.start_date = OKL_API.G_MISS_DATE)
1879: THEN
1880: x_cfp_rec.start_date := l_cfp_rec.start_date;
1881: END IF;
1882: IF (x_cfp_rec.end_date = OKL_API.G_MISS_CHAR)
1883: THEN
1884: x_cfp_rec.end_date := l_cfp_rec.end_date;
1885: END IF;
1886: IF (x_cfp_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 1886: IF (x_cfp_rec.attribute_category = OKL_API.G_MISS_CHAR)

1882: IF (x_cfp_rec.end_date = OKL_API.G_MISS_CHAR)
1883: THEN
1884: x_cfp_rec.end_date := l_cfp_rec.end_date;
1885: END IF;
1886: IF (x_cfp_rec.attribute_category = OKL_API.G_MISS_CHAR)
1887: THEN
1888: x_cfp_rec.attribute_category := l_cfp_rec.attribute_category;
1889: END IF;
1890: IF (x_cfp_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 1890: IF (x_cfp_rec.attribute1 = OKL_API.G_MISS_CHAR)

1886: IF (x_cfp_rec.attribute_category = OKL_API.G_MISS_CHAR)
1887: THEN
1888: x_cfp_rec.attribute_category := l_cfp_rec.attribute_category;
1889: END IF;
1890: IF (x_cfp_rec.attribute1 = OKL_API.G_MISS_CHAR)
1891: THEN
1892: x_cfp_rec.attribute1 := l_cfp_rec.attribute1;
1893: END IF;
1894: IF (x_cfp_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 1894: IF (x_cfp_rec.attribute2 = OKL_API.G_MISS_CHAR)

1890: IF (x_cfp_rec.attribute1 = OKL_API.G_MISS_CHAR)
1891: THEN
1892: x_cfp_rec.attribute1 := l_cfp_rec.attribute1;
1893: END IF;
1894: IF (x_cfp_rec.attribute2 = OKL_API.G_MISS_CHAR)
1895: THEN
1896: x_cfp_rec.attribute2 := l_cfp_rec.attribute2;
1897: END IF;
1898: IF (x_cfp_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 1898: IF (x_cfp_rec.attribute3 = OKL_API.G_MISS_CHAR)

1894: IF (x_cfp_rec.attribute2 = OKL_API.G_MISS_CHAR)
1895: THEN
1896: x_cfp_rec.attribute2 := l_cfp_rec.attribute2;
1897: END IF;
1898: IF (x_cfp_rec.attribute3 = OKL_API.G_MISS_CHAR)
1899: THEN
1900: x_cfp_rec.attribute3 := l_cfp_rec.attribute3;
1901: END IF;
1902: IF (x_cfp_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 1902: IF (x_cfp_rec.attribute4 = OKL_API.G_MISS_CHAR)

1898: IF (x_cfp_rec.attribute3 = OKL_API.G_MISS_CHAR)
1899: THEN
1900: x_cfp_rec.attribute3 := l_cfp_rec.attribute3;
1901: END IF;
1902: IF (x_cfp_rec.attribute4 = OKL_API.G_MISS_CHAR)
1903: THEN
1904: x_cfp_rec.attribute4 := l_cfp_rec.attribute4;
1905: END IF;
1906: IF (x_cfp_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 1906: IF (x_cfp_rec.attribute5 = OKL_API.G_MISS_CHAR)

1902: IF (x_cfp_rec.attribute4 = OKL_API.G_MISS_CHAR)
1903: THEN
1904: x_cfp_rec.attribute4 := l_cfp_rec.attribute4;
1905: END IF;
1906: IF (x_cfp_rec.attribute5 = OKL_API.G_MISS_CHAR)
1907: THEN
1908: x_cfp_rec.attribute5 := l_cfp_rec.attribute5;
1909: END IF;
1910: IF (x_cfp_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 1910: IF (x_cfp_rec.attribute6 = OKL_API.G_MISS_CHAR)

1906: IF (x_cfp_rec.attribute5 = OKL_API.G_MISS_CHAR)
1907: THEN
1908: x_cfp_rec.attribute5 := l_cfp_rec.attribute5;
1909: END IF;
1910: IF (x_cfp_rec.attribute6 = OKL_API.G_MISS_CHAR)
1911: THEN
1912: x_cfp_rec.attribute6 := l_cfp_rec.attribute6;
1913: END IF;
1914: IF (x_cfp_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 1914: IF (x_cfp_rec.attribute7 = OKL_API.G_MISS_CHAR)

1910: IF (x_cfp_rec.attribute6 = OKL_API.G_MISS_CHAR)
1911: THEN
1912: x_cfp_rec.attribute6 := l_cfp_rec.attribute6;
1913: END IF;
1914: IF (x_cfp_rec.attribute7 = OKL_API.G_MISS_CHAR)
1915: THEN
1916: x_cfp_rec.attribute7 := l_cfp_rec.attribute7;
1917: END IF;
1918: IF (x_cfp_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 1918: IF (x_cfp_rec.attribute8 = OKL_API.G_MISS_CHAR)

1914: IF (x_cfp_rec.attribute7 = OKL_API.G_MISS_CHAR)
1915: THEN
1916: x_cfp_rec.attribute7 := l_cfp_rec.attribute7;
1917: END IF;
1918: IF (x_cfp_rec.attribute8 = OKL_API.G_MISS_CHAR)
1919: THEN
1920: x_cfp_rec.attribute8 := l_cfp_rec.attribute8;
1921: END IF;
1922: IF (x_cfp_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 1922: IF (x_cfp_rec.attribute9 = OKL_API.G_MISS_CHAR)

1918: IF (x_cfp_rec.attribute8 = OKL_API.G_MISS_CHAR)
1919: THEN
1920: x_cfp_rec.attribute8 := l_cfp_rec.attribute8;
1921: END IF;
1922: IF (x_cfp_rec.attribute9 = OKL_API.G_MISS_CHAR)
1923: THEN
1924: x_cfp_rec.attribute9 := l_cfp_rec.attribute9;
1925: END IF;
1926: IF (x_cfp_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 1926: IF (x_cfp_rec.attribute10 = OKL_API.G_MISS_CHAR)

1922: IF (x_cfp_rec.attribute9 = OKL_API.G_MISS_CHAR)
1923: THEN
1924: x_cfp_rec.attribute9 := l_cfp_rec.attribute9;
1925: END IF;
1926: IF (x_cfp_rec.attribute10 = OKL_API.G_MISS_CHAR)
1927: THEN
1928: x_cfp_rec.attribute10 := l_cfp_rec.attribute10;
1929: END IF;
1930: IF (x_cfp_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 1930: IF (x_cfp_rec.attribute11 = OKL_API.G_MISS_CHAR)

1926: IF (x_cfp_rec.attribute10 = OKL_API.G_MISS_CHAR)
1927: THEN
1928: x_cfp_rec.attribute10 := l_cfp_rec.attribute10;
1929: END IF;
1930: IF (x_cfp_rec.attribute11 = OKL_API.G_MISS_CHAR)
1931: THEN
1932: x_cfp_rec.attribute11 := l_cfp_rec.attribute11;
1933: END IF;
1934: IF (x_cfp_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 1934: IF (x_cfp_rec.attribute12 = OKL_API.G_MISS_CHAR)

1930: IF (x_cfp_rec.attribute11 = OKL_API.G_MISS_CHAR)
1931: THEN
1932: x_cfp_rec.attribute11 := l_cfp_rec.attribute11;
1933: END IF;
1934: IF (x_cfp_rec.attribute12 = OKL_API.G_MISS_CHAR)
1935: THEN
1936: x_cfp_rec.attribute12 := l_cfp_rec.attribute12;
1937: END IF;
1938: IF (x_cfp_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 1938: IF (x_cfp_rec.attribute13 = OKL_API.G_MISS_CHAR)

1934: IF (x_cfp_rec.attribute12 = OKL_API.G_MISS_CHAR)
1935: THEN
1936: x_cfp_rec.attribute12 := l_cfp_rec.attribute12;
1937: END IF;
1938: IF (x_cfp_rec.attribute13 = OKL_API.G_MISS_CHAR)
1939: THEN
1940: x_cfp_rec.attribute13 := l_cfp_rec.attribute13;
1941: END IF;
1942: IF (x_cfp_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 1942: IF (x_cfp_rec.attribute14 = OKL_API.G_MISS_CHAR)

1938: IF (x_cfp_rec.attribute13 = OKL_API.G_MISS_CHAR)
1939: THEN
1940: x_cfp_rec.attribute13 := l_cfp_rec.attribute13;
1941: END IF;
1942: IF (x_cfp_rec.attribute14 = OKL_API.G_MISS_CHAR)
1943: THEN
1944: x_cfp_rec.attribute14 := l_cfp_rec.attribute14;
1945: END IF;
1946: IF (x_cfp_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 1946: IF (x_cfp_rec.attribute15 = OKL_API.G_MISS_CHAR)

1942: IF (x_cfp_rec.attribute14 = OKL_API.G_MISS_CHAR)
1943: THEN
1944: x_cfp_rec.attribute14 := l_cfp_rec.attribute14;
1945: END IF;
1946: IF (x_cfp_rec.attribute15 = OKL_API.G_MISS_CHAR)
1947: THEN
1948: x_cfp_rec.attribute15 := l_cfp_rec.attribute15;
1949: END IF;
1950: IF (x_cfp_rec.created_by = OKL_API.G_MISS_NUM)

Line 1950: IF (x_cfp_rec.created_by = OKL_API.G_MISS_NUM)

1946: IF (x_cfp_rec.attribute15 = OKL_API.G_MISS_CHAR)
1947: THEN
1948: x_cfp_rec.attribute15 := l_cfp_rec.attribute15;
1949: END IF;
1950: IF (x_cfp_rec.created_by = OKL_API.G_MISS_NUM)
1951: THEN
1952: x_cfp_rec.created_by := l_cfp_rec.created_by;
1953: END IF;
1954: IF (x_cfp_rec.creation_date = OKL_API.G_MISS_DATE)

Line 1954: IF (x_cfp_rec.creation_date = OKL_API.G_MISS_DATE)

1950: IF (x_cfp_rec.created_by = OKL_API.G_MISS_NUM)
1951: THEN
1952: x_cfp_rec.created_by := l_cfp_rec.created_by;
1953: END IF;
1954: IF (x_cfp_rec.creation_date = OKL_API.G_MISS_DATE)
1955: THEN
1956: x_cfp_rec.creation_date := l_cfp_rec.creation_date;
1957: END IF;
1958: IF (x_cfp_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 1958: IF (x_cfp_rec.last_updated_by = OKL_API.G_MISS_NUM)

1954: IF (x_cfp_rec.creation_date = OKL_API.G_MISS_DATE)
1955: THEN
1956: x_cfp_rec.creation_date := l_cfp_rec.creation_date;
1957: END IF;
1958: IF (x_cfp_rec.last_updated_by = OKL_API.G_MISS_NUM)
1959: THEN
1960: x_cfp_rec.last_updated_by := l_cfp_rec.last_updated_by;
1961: END IF;
1962: IF (x_cfp_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 1962: IF (x_cfp_rec.last_update_date = OKL_API.G_MISS_DATE)

1958: IF (x_cfp_rec.last_updated_by = OKL_API.G_MISS_NUM)
1959: THEN
1960: x_cfp_rec.last_updated_by := l_cfp_rec.last_updated_by;
1961: END IF;
1962: IF (x_cfp_rec.last_update_date = OKL_API.G_MISS_DATE)
1963: THEN
1964: x_cfp_rec.last_update_date := l_cfp_rec.last_update_date;
1965: END IF;
1966: IF (x_cfp_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 1966: IF (x_cfp_rec.last_update_login = OKL_API.G_MISS_NUM)

1962: IF (x_cfp_rec.last_update_date = OKL_API.G_MISS_DATE)
1963: THEN
1964: x_cfp_rec.last_update_date := l_cfp_rec.last_update_date;
1965: END IF;
1966: IF (x_cfp_rec.last_update_login = OKL_API.G_MISS_NUM)
1967: THEN
1968: x_cfp_rec.last_update_login := l_cfp_rec.last_update_login;
1969: END IF;
1970: IF (x_cfp_rec.object_version_number = OKL_API.G_MISS_NUM)

Line 1970: IF (x_cfp_rec.object_version_number = OKL_API.G_MISS_NUM)

1966: IF (x_cfp_rec.last_update_login = OKL_API.G_MISS_NUM)
1967: THEN
1968: x_cfp_rec.last_update_login := l_cfp_rec.last_update_login;
1969: END IF;
1970: IF (x_cfp_rec.object_version_number = OKL_API.G_MISS_NUM)
1971: THEN
1972: x_cfp_rec.object_version_number := l_cfp_rec.object_version_number;
1973: END IF;
1974: END IF;

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

1980: FUNCTION Set_Attributes (
1981: p_cfp_rec IN cfp_rec_type,
1982: x_cfp_rec OUT NOCOPY cfp_rec_type
1983: ) RETURN VARCHAR2 IS
1984: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1985: BEGIN
1986: x_cfp_rec := p_cfp_rec;
1987: x_cfp_rec.OBJECT_VERSION_NUMBER := p_cfp_rec.OBJECT_VERSION_NUMBER + 1;
1988: RETURN(l_return_status);

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

1987: x_cfp_rec.OBJECT_VERSION_NUMBER := p_cfp_rec.OBJECT_VERSION_NUMBER + 1;
1988: RETURN(l_return_status);
1989: END Set_Attributes;
1990: BEGIN
1991: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1992: p_init_msg_list,
1993: '_PVT',
1994: x_return_status);
1995: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1991: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1992: p_init_msg_list,
1993: '_PVT',
1994: x_return_status);
1995: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1996: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1997: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1998: RAISE OKL_API.G_EXCEPTION_ERROR;
1999: END IF;

Line 1996: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1992: p_init_msg_list,
1993: '_PVT',
1994: x_return_status);
1995: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1996: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1997: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1998: RAISE OKL_API.G_EXCEPTION_ERROR;
1999: END IF;
2000: --- Setting item attributes

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

1993: '_PVT',
1994: x_return_status);
1995: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1996: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1997: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1998: RAISE OKL_API.G_EXCEPTION_ERROR;
1999: END IF;
2000: --- Setting item attributes
2001: l_return_status := Set_Attributes(

Line 1998: RAISE OKL_API.G_EXCEPTION_ERROR;

1994: x_return_status);
1995: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1996: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1997: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1998: RAISE OKL_API.G_EXCEPTION_ERROR;
1999: END IF;
2000: --- Setting item attributes
2001: l_return_status := Set_Attributes(
2002: p_cfp_rec, -- IN

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

2001: l_return_status := Set_Attributes(
2002: p_cfp_rec, -- IN
2003: l_cfp_rec); -- OUT
2004: --- If any errors happen abort API
2005: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2007: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2008: RAISE OKL_API.G_EXCEPTION_ERROR;
2009: END IF;

Line 2006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2002: p_cfp_rec, -- IN
2003: l_cfp_rec); -- OUT
2004: --- If any errors happen abort API
2005: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2007: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2008: RAISE OKL_API.G_EXCEPTION_ERROR;
2009: END IF;
2010: l_return_status := populate_new_record(l_cfp_rec, l_def_cfp_rec);

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

2003: l_cfp_rec); -- OUT
2004: --- If any errors happen abort API
2005: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2007: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2008: RAISE OKL_API.G_EXCEPTION_ERROR;
2009: END IF;
2010: l_return_status := populate_new_record(l_cfp_rec, l_def_cfp_rec);
2011: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2008: RAISE OKL_API.G_EXCEPTION_ERROR;

2004: --- If any errors happen abort API
2005: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2007: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2008: RAISE OKL_API.G_EXCEPTION_ERROR;
2009: END IF;
2010: l_return_status := populate_new_record(l_cfp_rec, l_def_cfp_rec);
2011: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2007: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2008: RAISE OKL_API.G_EXCEPTION_ERROR;
2009: END IF;
2010: l_return_status := populate_new_record(l_cfp_rec, l_def_cfp_rec);
2011: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2013: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_ERROR;
2015: END IF;

Line 2012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2008: RAISE OKL_API.G_EXCEPTION_ERROR;
2009: END IF;
2010: l_return_status := populate_new_record(l_cfp_rec, l_def_cfp_rec);
2011: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2013: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_ERROR;
2015: END IF;
2016: UPDATE OKL_CF_OBJECT_PERIODS

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

2009: END IF;
2010: l_return_status := populate_new_record(l_cfp_rec, l_def_cfp_rec);
2011: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2013: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_ERROR;
2015: END IF;
2016: UPDATE OKL_CF_OBJECT_PERIODS
2017: SET CFO_ID = l_def_cfp_rec.cfo_id,

Line 2014: RAISE OKL_API.G_EXCEPTION_ERROR;

2010: l_return_status := populate_new_record(l_cfp_rec, l_def_cfp_rec);
2011: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2013: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_ERROR;
2015: END IF;
2016: UPDATE OKL_CF_OBJECT_PERIODS
2017: SET CFO_ID = l_def_cfp_rec.cfo_id,
2018: PTP_CODE = l_def_cfp_rec.ptp_code,

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

2043: WHERE ID = l_def_cfp_rec.id;
2044:
2045: x_cfp_rec := l_cfp_rec;
2046: x_return_status := l_return_status;
2047: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2048: EXCEPTION
2049: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2050: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2051: (

Line 2049: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2045: x_cfp_rec := l_cfp_rec;
2046: x_return_status := l_return_status;
2047: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2048: EXCEPTION
2049: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2050: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2051: (
2052: l_api_name,
2053: G_PKG_NAME,

Line 2050: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2046: x_return_status := l_return_status;
2047: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2048: EXCEPTION
2049: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2050: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2051: (
2052: l_api_name,
2053: G_PKG_NAME,
2054: 'OKL_API.G_RET_STS_ERROR',

Line 2054: 'OKL_API.G_RET_STS_ERROR',

2050: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2051: (
2052: l_api_name,
2053: G_PKG_NAME,
2054: 'OKL_API.G_RET_STS_ERROR',
2055: x_msg_count,
2056: x_msg_data,
2057: '_PVT'
2058: );

Line 2059: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2055: x_msg_count,
2056: x_msg_data,
2057: '_PVT'
2058: );
2059: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2060: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2061: (
2062: l_api_name,
2063: G_PKG_NAME,

Line 2060: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2056: x_msg_data,
2057: '_PVT'
2058: );
2059: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2060: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2061: (
2062: l_api_name,
2063: G_PKG_NAME,
2064: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2064: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2060: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2061: (
2062: l_api_name,
2063: G_PKG_NAME,
2064: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2065: x_msg_count,
2066: x_msg_data,
2067: '_PVT'
2068: );

Line 2070: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2066: x_msg_data,
2067: '_PVT'
2068: );
2069: WHEN OTHERS THEN
2070: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2071: (
2072: l_api_name,
2073: G_PKG_NAME,
2074: 'OTHERS',

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

2090: x_cfpv_rec OUT NOCOPY cfpv_rec_type) IS
2091:
2092: l_api_version CONSTANT NUMBER := 1;
2093: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2094: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2095: l_cfpv_rec cfpv_rec_type := p_cfpv_rec;
2096: l_def_cfpv_rec cfpv_rec_type;
2097: l_db_cfpv_rec cfpv_rec_type;
2098: l_cfp_rec cfp_rec_type;

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

2117: p_cfpv_rec IN cfpv_rec_type,
2118: x_cfpv_rec OUT NOCOPY cfpv_rec_type
2119: ) RETURN VARCHAR2 IS
2120: l_row_notfound BOOLEAN := TRUE;
2121: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2122: BEGIN
2123: x_cfpv_rec := p_cfpv_rec;
2124: -- Get current database values
2125: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it

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

2124: -- Get current database values
2125: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2126: -- so it may be verified through LOCK_ROW.
2127: l_db_cfpv_rec := get_rec(p_cfpv_rec, l_return_status);
2128: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2129: IF (x_cfpv_rec.id = OKL_API.G_MISS_NUM)
2130: THEN
2131: x_cfpv_rec.id := l_db_cfpv_rec.id;
2132: END IF;

Line 2129: IF (x_cfpv_rec.id = OKL_API.G_MISS_NUM)

2125: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2126: -- so it may be verified through LOCK_ROW.
2127: l_db_cfpv_rec := get_rec(p_cfpv_rec, l_return_status);
2128: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
2129: IF (x_cfpv_rec.id = OKL_API.G_MISS_NUM)
2130: THEN
2131: x_cfpv_rec.id := l_db_cfpv_rec.id;
2132: END IF;
2133: IF (x_cfpv_rec.cfo_id = OKL_API.G_MISS_NUM)

Line 2133: IF (x_cfpv_rec.cfo_id = OKL_API.G_MISS_NUM)

2129: IF (x_cfpv_rec.id = OKL_API.G_MISS_NUM)
2130: THEN
2131: x_cfpv_rec.id := l_db_cfpv_rec.id;
2132: END IF;
2133: IF (x_cfpv_rec.cfo_id = OKL_API.G_MISS_NUM)
2134: THEN
2135: x_cfpv_rec.cfo_id := l_db_cfpv_rec.cfo_id;
2136: END IF;
2137: IF (x_cfpv_rec.ptp_code = OKL_API.G_MISS_CHAR)

Line 2137: IF (x_cfpv_rec.ptp_code = OKL_API.G_MISS_CHAR)

2133: IF (x_cfpv_rec.cfo_id = OKL_API.G_MISS_NUM)
2134: THEN
2135: x_cfpv_rec.cfo_id := l_db_cfpv_rec.cfo_id;
2136: END IF;
2137: IF (x_cfpv_rec.ptp_code = OKL_API.G_MISS_CHAR)
2138: THEN
2139: x_cfpv_rec.ptp_code := l_db_cfpv_rec.ptp_code;
2140: END IF;
2141: IF (x_cfpv_rec.start_date = OKL_API.G_MISS_DATE)

Line 2141: IF (x_cfpv_rec.start_date = OKL_API.G_MISS_DATE)

2137: IF (x_cfpv_rec.ptp_code = OKL_API.G_MISS_CHAR)
2138: THEN
2139: x_cfpv_rec.ptp_code := l_db_cfpv_rec.ptp_code;
2140: END IF;
2141: IF (x_cfpv_rec.start_date = OKL_API.G_MISS_DATE)
2142: THEN
2143: x_cfpv_rec.start_date := l_db_cfpv_rec.start_date;
2144: END IF;
2145: IF (x_cfpv_rec.end_date = OKL_API.G_MISS_CHAR)

Line 2145: IF (x_cfpv_rec.end_date = OKL_API.G_MISS_CHAR)

2141: IF (x_cfpv_rec.start_date = OKL_API.G_MISS_DATE)
2142: THEN
2143: x_cfpv_rec.start_date := l_db_cfpv_rec.start_date;
2144: END IF;
2145: IF (x_cfpv_rec.end_date = OKL_API.G_MISS_CHAR)
2146: THEN
2147: x_cfpv_rec.end_date := l_db_cfpv_rec.end_date;
2148: END IF;
2149: IF (x_cfpv_rec.attribute_category = OKL_API.G_MISS_CHAR)

Line 2149: IF (x_cfpv_rec.attribute_category = OKL_API.G_MISS_CHAR)

2145: IF (x_cfpv_rec.end_date = OKL_API.G_MISS_CHAR)
2146: THEN
2147: x_cfpv_rec.end_date := l_db_cfpv_rec.end_date;
2148: END IF;
2149: IF (x_cfpv_rec.attribute_category = OKL_API.G_MISS_CHAR)
2150: THEN
2151: x_cfpv_rec.attribute_category := l_db_cfpv_rec.attribute_category;
2152: END IF;
2153: IF (x_cfpv_rec.attribute1 = OKL_API.G_MISS_CHAR)

Line 2153: IF (x_cfpv_rec.attribute1 = OKL_API.G_MISS_CHAR)

2149: IF (x_cfpv_rec.attribute_category = OKL_API.G_MISS_CHAR)
2150: THEN
2151: x_cfpv_rec.attribute_category := l_db_cfpv_rec.attribute_category;
2152: END IF;
2153: IF (x_cfpv_rec.attribute1 = OKL_API.G_MISS_CHAR)
2154: THEN
2155: x_cfpv_rec.attribute1 := l_db_cfpv_rec.attribute1;
2156: END IF;
2157: IF (x_cfpv_rec.attribute2 = OKL_API.G_MISS_CHAR)

Line 2157: IF (x_cfpv_rec.attribute2 = OKL_API.G_MISS_CHAR)

2153: IF (x_cfpv_rec.attribute1 = OKL_API.G_MISS_CHAR)
2154: THEN
2155: x_cfpv_rec.attribute1 := l_db_cfpv_rec.attribute1;
2156: END IF;
2157: IF (x_cfpv_rec.attribute2 = OKL_API.G_MISS_CHAR)
2158: THEN
2159: x_cfpv_rec.attribute2 := l_db_cfpv_rec.attribute2;
2160: END IF;
2161: IF (x_cfpv_rec.attribute3 = OKL_API.G_MISS_CHAR)

Line 2161: IF (x_cfpv_rec.attribute3 = OKL_API.G_MISS_CHAR)

2157: IF (x_cfpv_rec.attribute2 = OKL_API.G_MISS_CHAR)
2158: THEN
2159: x_cfpv_rec.attribute2 := l_db_cfpv_rec.attribute2;
2160: END IF;
2161: IF (x_cfpv_rec.attribute3 = OKL_API.G_MISS_CHAR)
2162: THEN
2163: x_cfpv_rec.attribute3 := l_db_cfpv_rec.attribute3;
2164: END IF;
2165: IF (x_cfpv_rec.attribute4 = OKL_API.G_MISS_CHAR)

Line 2165: IF (x_cfpv_rec.attribute4 = OKL_API.G_MISS_CHAR)

2161: IF (x_cfpv_rec.attribute3 = OKL_API.G_MISS_CHAR)
2162: THEN
2163: x_cfpv_rec.attribute3 := l_db_cfpv_rec.attribute3;
2164: END IF;
2165: IF (x_cfpv_rec.attribute4 = OKL_API.G_MISS_CHAR)
2166: THEN
2167: x_cfpv_rec.attribute4 := l_db_cfpv_rec.attribute4;
2168: END IF;
2169: IF (x_cfpv_rec.attribute5 = OKL_API.G_MISS_CHAR)

Line 2169: IF (x_cfpv_rec.attribute5 = OKL_API.G_MISS_CHAR)

2165: IF (x_cfpv_rec.attribute4 = OKL_API.G_MISS_CHAR)
2166: THEN
2167: x_cfpv_rec.attribute4 := l_db_cfpv_rec.attribute4;
2168: END IF;
2169: IF (x_cfpv_rec.attribute5 = OKL_API.G_MISS_CHAR)
2170: THEN
2171: x_cfpv_rec.attribute5 := l_db_cfpv_rec.attribute5;
2172: END IF;
2173: IF (x_cfpv_rec.attribute6 = OKL_API.G_MISS_CHAR)

Line 2173: IF (x_cfpv_rec.attribute6 = OKL_API.G_MISS_CHAR)

2169: IF (x_cfpv_rec.attribute5 = OKL_API.G_MISS_CHAR)
2170: THEN
2171: x_cfpv_rec.attribute5 := l_db_cfpv_rec.attribute5;
2172: END IF;
2173: IF (x_cfpv_rec.attribute6 = OKL_API.G_MISS_CHAR)
2174: THEN
2175: x_cfpv_rec.attribute6 := l_db_cfpv_rec.attribute6;
2176: END IF;
2177: IF (x_cfpv_rec.attribute7 = OKL_API.G_MISS_CHAR)

Line 2177: IF (x_cfpv_rec.attribute7 = OKL_API.G_MISS_CHAR)

2173: IF (x_cfpv_rec.attribute6 = OKL_API.G_MISS_CHAR)
2174: THEN
2175: x_cfpv_rec.attribute6 := l_db_cfpv_rec.attribute6;
2176: END IF;
2177: IF (x_cfpv_rec.attribute7 = OKL_API.G_MISS_CHAR)
2178: THEN
2179: x_cfpv_rec.attribute7 := l_db_cfpv_rec.attribute7;
2180: END IF;
2181: IF (x_cfpv_rec.attribute8 = OKL_API.G_MISS_CHAR)

Line 2181: IF (x_cfpv_rec.attribute8 = OKL_API.G_MISS_CHAR)

2177: IF (x_cfpv_rec.attribute7 = OKL_API.G_MISS_CHAR)
2178: THEN
2179: x_cfpv_rec.attribute7 := l_db_cfpv_rec.attribute7;
2180: END IF;
2181: IF (x_cfpv_rec.attribute8 = OKL_API.G_MISS_CHAR)
2182: THEN
2183: x_cfpv_rec.attribute8 := l_db_cfpv_rec.attribute8;
2184: END IF;
2185: IF (x_cfpv_rec.attribute9 = OKL_API.G_MISS_CHAR)

Line 2185: IF (x_cfpv_rec.attribute9 = OKL_API.G_MISS_CHAR)

2181: IF (x_cfpv_rec.attribute8 = OKL_API.G_MISS_CHAR)
2182: THEN
2183: x_cfpv_rec.attribute8 := l_db_cfpv_rec.attribute8;
2184: END IF;
2185: IF (x_cfpv_rec.attribute9 = OKL_API.G_MISS_CHAR)
2186: THEN
2187: x_cfpv_rec.attribute9 := l_db_cfpv_rec.attribute9;
2188: END IF;
2189: IF (x_cfpv_rec.attribute10 = OKL_API.G_MISS_CHAR)

Line 2189: IF (x_cfpv_rec.attribute10 = OKL_API.G_MISS_CHAR)

2185: IF (x_cfpv_rec.attribute9 = OKL_API.G_MISS_CHAR)
2186: THEN
2187: x_cfpv_rec.attribute9 := l_db_cfpv_rec.attribute9;
2188: END IF;
2189: IF (x_cfpv_rec.attribute10 = OKL_API.G_MISS_CHAR)
2190: THEN
2191: x_cfpv_rec.attribute10 := l_db_cfpv_rec.attribute10;
2192: END IF;
2193: IF (x_cfpv_rec.attribute11 = OKL_API.G_MISS_CHAR)

Line 2193: IF (x_cfpv_rec.attribute11 = OKL_API.G_MISS_CHAR)

2189: IF (x_cfpv_rec.attribute10 = OKL_API.G_MISS_CHAR)
2190: THEN
2191: x_cfpv_rec.attribute10 := l_db_cfpv_rec.attribute10;
2192: END IF;
2193: IF (x_cfpv_rec.attribute11 = OKL_API.G_MISS_CHAR)
2194: THEN
2195: x_cfpv_rec.attribute11 := l_db_cfpv_rec.attribute11;
2196: END IF;
2197: IF (x_cfpv_rec.attribute12 = OKL_API.G_MISS_CHAR)

Line 2197: IF (x_cfpv_rec.attribute12 = OKL_API.G_MISS_CHAR)

2193: IF (x_cfpv_rec.attribute11 = OKL_API.G_MISS_CHAR)
2194: THEN
2195: x_cfpv_rec.attribute11 := l_db_cfpv_rec.attribute11;
2196: END IF;
2197: IF (x_cfpv_rec.attribute12 = OKL_API.G_MISS_CHAR)
2198: THEN
2199: x_cfpv_rec.attribute12 := l_db_cfpv_rec.attribute12;
2200: END IF;
2201: IF (x_cfpv_rec.attribute13 = OKL_API.G_MISS_CHAR)

Line 2201: IF (x_cfpv_rec.attribute13 = OKL_API.G_MISS_CHAR)

2197: IF (x_cfpv_rec.attribute12 = OKL_API.G_MISS_CHAR)
2198: THEN
2199: x_cfpv_rec.attribute12 := l_db_cfpv_rec.attribute12;
2200: END IF;
2201: IF (x_cfpv_rec.attribute13 = OKL_API.G_MISS_CHAR)
2202: THEN
2203: x_cfpv_rec.attribute13 := l_db_cfpv_rec.attribute13;
2204: END IF;
2205: IF (x_cfpv_rec.attribute14 = OKL_API.G_MISS_CHAR)

Line 2205: IF (x_cfpv_rec.attribute14 = OKL_API.G_MISS_CHAR)

2201: IF (x_cfpv_rec.attribute13 = OKL_API.G_MISS_CHAR)
2202: THEN
2203: x_cfpv_rec.attribute13 := l_db_cfpv_rec.attribute13;
2204: END IF;
2205: IF (x_cfpv_rec.attribute14 = OKL_API.G_MISS_CHAR)
2206: THEN
2207: x_cfpv_rec.attribute14 := l_db_cfpv_rec.attribute14;
2208: END IF;
2209: IF (x_cfpv_rec.attribute15 = OKL_API.G_MISS_CHAR)

Line 2209: IF (x_cfpv_rec.attribute15 = OKL_API.G_MISS_CHAR)

2205: IF (x_cfpv_rec.attribute14 = OKL_API.G_MISS_CHAR)
2206: THEN
2207: x_cfpv_rec.attribute14 := l_db_cfpv_rec.attribute14;
2208: END IF;
2209: IF (x_cfpv_rec.attribute15 = OKL_API.G_MISS_CHAR)
2210: THEN
2211: x_cfpv_rec.attribute15 := l_db_cfpv_rec.attribute15;
2212: END IF;
2213: IF (x_cfpv_rec.created_by = OKL_API.G_MISS_NUM)

Line 2213: IF (x_cfpv_rec.created_by = OKL_API.G_MISS_NUM)

2209: IF (x_cfpv_rec.attribute15 = OKL_API.G_MISS_CHAR)
2210: THEN
2211: x_cfpv_rec.attribute15 := l_db_cfpv_rec.attribute15;
2212: END IF;
2213: IF (x_cfpv_rec.created_by = OKL_API.G_MISS_NUM)
2214: THEN
2215: x_cfpv_rec.created_by := l_db_cfpv_rec.created_by;
2216: END IF;
2217: IF (x_cfpv_rec.creation_date = OKL_API.G_MISS_DATE)

Line 2217: IF (x_cfpv_rec.creation_date = OKL_API.G_MISS_DATE)

2213: IF (x_cfpv_rec.created_by = OKL_API.G_MISS_NUM)
2214: THEN
2215: x_cfpv_rec.created_by := l_db_cfpv_rec.created_by;
2216: END IF;
2217: IF (x_cfpv_rec.creation_date = OKL_API.G_MISS_DATE)
2218: THEN
2219: x_cfpv_rec.creation_date := l_db_cfpv_rec.creation_date;
2220: END IF;
2221: IF (x_cfpv_rec.last_updated_by = OKL_API.G_MISS_NUM)

Line 2221: IF (x_cfpv_rec.last_updated_by = OKL_API.G_MISS_NUM)

2217: IF (x_cfpv_rec.creation_date = OKL_API.G_MISS_DATE)
2218: THEN
2219: x_cfpv_rec.creation_date := l_db_cfpv_rec.creation_date;
2220: END IF;
2221: IF (x_cfpv_rec.last_updated_by = OKL_API.G_MISS_NUM)
2222: THEN
2223: x_cfpv_rec.last_updated_by := l_db_cfpv_rec.last_updated_by;
2224: END IF;
2225: IF (x_cfpv_rec.last_update_date = OKL_API.G_MISS_DATE)

Line 2225: IF (x_cfpv_rec.last_update_date = OKL_API.G_MISS_DATE)

2221: IF (x_cfpv_rec.last_updated_by = OKL_API.G_MISS_NUM)
2222: THEN
2223: x_cfpv_rec.last_updated_by := l_db_cfpv_rec.last_updated_by;
2224: END IF;
2225: IF (x_cfpv_rec.last_update_date = OKL_API.G_MISS_DATE)
2226: THEN
2227: x_cfpv_rec.last_update_date := l_db_cfpv_rec.last_update_date;
2228: END IF;
2229: IF (x_cfpv_rec.last_update_login = OKL_API.G_MISS_NUM)

Line 2229: IF (x_cfpv_rec.last_update_login = OKL_API.G_MISS_NUM)

2225: IF (x_cfpv_rec.last_update_date = OKL_API.G_MISS_DATE)
2226: THEN
2227: x_cfpv_rec.last_update_date := l_db_cfpv_rec.last_update_date;
2228: END IF;
2229: IF (x_cfpv_rec.last_update_login = OKL_API.G_MISS_NUM)
2230: THEN
2231: x_cfpv_rec.last_update_login := l_db_cfpv_rec.last_update_login;
2232: END IF;
2233: END IF;

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

2239: FUNCTION Set_Attributes (
2240: p_cfpv_rec IN cfpv_rec_type,
2241: x_cfpv_rec OUT NOCOPY cfpv_rec_type
2242: ) RETURN VARCHAR2 IS
2243: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2244: BEGIN
2245: x_cfpv_rec := p_cfpv_rec;
2246: RETURN(l_return_status);
2247: END Set_Attributes;

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

2245: x_cfpv_rec := p_cfpv_rec;
2246: RETURN(l_return_status);
2247: END Set_Attributes;
2248: BEGIN
2249: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2250: G_PKG_NAME,
2251: p_init_msg_list,
2252: l_api_version,
2253: p_api_version,

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

2252: l_api_version,
2253: p_api_version,
2254: '_PVT',
2255: x_return_status);
2256: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2257: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2258: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2259: RAISE OKL_API.G_EXCEPTION_ERROR;
2260: END IF;

Line 2257: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2253: p_api_version,
2254: '_PVT',
2255: x_return_status);
2256: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2257: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2258: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2259: RAISE OKL_API.G_EXCEPTION_ERROR;
2260: END IF;
2261: --- Setting item attributes

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

2254: '_PVT',
2255: x_return_status);
2256: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2257: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2258: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2259: RAISE OKL_API.G_EXCEPTION_ERROR;
2260: END IF;
2261: --- Setting item attributes
2262: l_return_status := Set_Attributes(

Line 2259: RAISE OKL_API.G_EXCEPTION_ERROR;

2255: x_return_status);
2256: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2257: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2258: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2259: RAISE OKL_API.G_EXCEPTION_ERROR;
2260: END IF;
2261: --- Setting item attributes
2262: l_return_status := Set_Attributes(
2263: p_cfpv_rec, -- IN

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

2262: l_return_status := Set_Attributes(
2263: p_cfpv_rec, -- IN
2264: x_cfpv_rec); -- OUT
2265: --- If any errors happen abort API
2266: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2267: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2268: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2269: RAISE OKL_API.G_EXCEPTION_ERROR;
2270: END IF;

Line 2267: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2263: p_cfpv_rec, -- IN
2264: x_cfpv_rec); -- OUT
2265: --- If any errors happen abort API
2266: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2267: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2268: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2269: RAISE OKL_API.G_EXCEPTION_ERROR;
2270: END IF;
2271: l_return_status := populate_new_record(l_cfpv_rec, l_def_cfpv_rec);

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

2264: x_cfpv_rec); -- OUT
2265: --- If any errors happen abort API
2266: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2267: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2268: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2269: RAISE OKL_API.G_EXCEPTION_ERROR;
2270: END IF;
2271: l_return_status := populate_new_record(l_cfpv_rec, l_def_cfpv_rec);
2272: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2269: RAISE OKL_API.G_EXCEPTION_ERROR;

2265: --- If any errors happen abort API
2266: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2267: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2268: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2269: RAISE OKL_API.G_EXCEPTION_ERROR;
2270: END IF;
2271: l_return_status := populate_new_record(l_cfpv_rec, l_def_cfpv_rec);
2272: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2268: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2269: RAISE OKL_API.G_EXCEPTION_ERROR;
2270: END IF;
2271: l_return_status := populate_new_record(l_cfpv_rec, l_def_cfpv_rec);
2272: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2274: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2275: RAISE OKL_API.G_EXCEPTION_ERROR;
2276: END IF;

Line 2273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2269: RAISE OKL_API.G_EXCEPTION_ERROR;
2270: END IF;
2271: l_return_status := populate_new_record(l_cfpv_rec, l_def_cfpv_rec);
2272: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2274: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2275: RAISE OKL_API.G_EXCEPTION_ERROR;
2276: END IF;
2277: l_def_cfpv_rec := fill_who_columns(l_def_cfpv_rec);

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

2270: END IF;
2271: l_return_status := populate_new_record(l_cfpv_rec, l_def_cfpv_rec);
2272: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2274: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2275: RAISE OKL_API.G_EXCEPTION_ERROR;
2276: END IF;
2277: l_def_cfpv_rec := fill_who_columns(l_def_cfpv_rec);
2278: --- Validate all non-missing attributes (Item Level Validation)

Line 2275: RAISE OKL_API.G_EXCEPTION_ERROR;

2271: l_return_status := populate_new_record(l_cfpv_rec, l_def_cfpv_rec);
2272: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2274: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2275: RAISE OKL_API.G_EXCEPTION_ERROR;
2276: END IF;
2277: l_def_cfpv_rec := fill_who_columns(l_def_cfpv_rec);
2278: --- Validate all non-missing attributes (Item Level Validation)
2279: l_return_status := Validate_Attributes(l_def_cfpv_rec);

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

2277: l_def_cfpv_rec := fill_who_columns(l_def_cfpv_rec);
2278: --- Validate all non-missing attributes (Item Level Validation)
2279: l_return_status := Validate_Attributes(l_def_cfpv_rec);
2280: --- If any errors happen abort API
2281: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2282: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2283: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2284: RAISE OKL_API.G_EXCEPTION_ERROR;
2285: END IF;

Line 2282: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2278: --- Validate all non-missing attributes (Item Level Validation)
2279: l_return_status := Validate_Attributes(l_def_cfpv_rec);
2280: --- If any errors happen abort API
2281: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2282: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2283: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2284: RAISE OKL_API.G_EXCEPTION_ERROR;
2285: END IF;
2286: /*

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

2279: l_return_status := Validate_Attributes(l_def_cfpv_rec);
2280: --- If any errors happen abort API
2281: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2282: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2283: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2284: RAISE OKL_API.G_EXCEPTION_ERROR;
2285: END IF;
2286: /*
2287: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,

Line 2284: RAISE OKL_API.G_EXCEPTION_ERROR;

2280: --- If any errors happen abort API
2281: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2282: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2283: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2284: RAISE OKL_API.G_EXCEPTION_ERROR;
2285: END IF;
2286: /*
2287: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
2288: -- which has been moved to individaul valiadte attribute procedures

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

2286: /*
2287: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
2288: -- which has been moved to individaul valiadte attribute procedures
2289: l_return_status := Validate_Record(l_def_cfpv_rec, l_db_cfpv_rec);
2290: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2291: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2292: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2293: RAISE OKL_API.G_EXCEPTION_ERROR;
2294: END IF;

Line 2291: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2287: -- SECHAWLA - Not required, as validate_record has code for foreign key validation only,
2288: -- which has been moved to individaul valiadte attribute procedures
2289: l_return_status := Validate_Record(l_def_cfpv_rec, l_db_cfpv_rec);
2290: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2291: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2292: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2293: RAISE OKL_API.G_EXCEPTION_ERROR;
2294: END IF;
2295: */

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

2288: -- which has been moved to individaul valiadte attribute procedures
2289: l_return_status := Validate_Record(l_def_cfpv_rec, l_db_cfpv_rec);
2290: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2291: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2292: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2293: RAISE OKL_API.G_EXCEPTION_ERROR;
2294: END IF;
2295: */
2296:

Line 2293: RAISE OKL_API.G_EXCEPTION_ERROR;

2289: l_return_status := Validate_Record(l_def_cfpv_rec, l_db_cfpv_rec);
2290: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2291: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2292: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2293: RAISE OKL_API.G_EXCEPTION_ERROR;
2294: END IF;
2295: */
2296:
2297: -- Lock the Record

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

2301: x_return_status => l_return_status,
2302: x_msg_count => x_msg_count,
2303: x_msg_data => x_msg_data,
2304: p_cfpv_rec => p_cfpv_rec);
2305: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2306: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2307: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2308: RAISE OKL_API.G_EXCEPTION_ERROR;
2309: END IF;

Line 2306: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2302: x_msg_count => x_msg_count,
2303: x_msg_data => x_msg_data,
2304: p_cfpv_rec => p_cfpv_rec);
2305: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2306: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2307: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2308: RAISE OKL_API.G_EXCEPTION_ERROR;
2309: END IF;
2310:

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

2303: x_msg_data => x_msg_data,
2304: p_cfpv_rec => p_cfpv_rec);
2305: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2306: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2307: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2308: RAISE OKL_API.G_EXCEPTION_ERROR;
2309: END IF;
2310:
2311: -----------------------------------------

Line 2308: RAISE OKL_API.G_EXCEPTION_ERROR;

2304: p_cfpv_rec => p_cfpv_rec);
2305: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2306: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2307: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2308: RAISE OKL_API.G_EXCEPTION_ERROR;
2309: END IF;
2310:
2311: -----------------------------------------
2312: -- Move VIEW record to "Child" records --

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

2322: x_msg_data,
2323: l_cfp_rec,
2324: lx_cfp_rec
2325: );
2326: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2328: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2329: RAISE OKL_API.G_EXCEPTION_ERROR;
2330: END IF;

Line 2327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2323: l_cfp_rec,
2324: lx_cfp_rec
2325: );
2326: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2328: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2329: RAISE OKL_API.G_EXCEPTION_ERROR;
2330: END IF;
2331: migrate(lx_cfp_rec, l_def_cfpv_rec);

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

2324: lx_cfp_rec
2325: );
2326: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2328: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2329: RAISE OKL_API.G_EXCEPTION_ERROR;
2330: END IF;
2331: migrate(lx_cfp_rec, l_def_cfpv_rec);
2332: x_cfpv_rec := l_def_cfpv_rec;

Line 2329: RAISE OKL_API.G_EXCEPTION_ERROR;

2325: );
2326: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2328: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2329: RAISE OKL_API.G_EXCEPTION_ERROR;
2330: END IF;
2331: migrate(lx_cfp_rec, l_def_cfpv_rec);
2332: x_cfpv_rec := l_def_cfpv_rec;
2333: x_return_status := l_return_status;

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

2330: END IF;
2331: migrate(lx_cfp_rec, l_def_cfpv_rec);
2332: x_cfpv_rec := l_def_cfpv_rec;
2333: x_return_status := l_return_status;
2334: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2335: EXCEPTION
2336: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2337: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2338: (

Line 2336: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2332: x_cfpv_rec := l_def_cfpv_rec;
2333: x_return_status := l_return_status;
2334: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2335: EXCEPTION
2336: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2337: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2338: (
2339: l_api_name,
2340: G_PKG_NAME,

Line 2337: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2333: x_return_status := l_return_status;
2334: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2335: EXCEPTION
2336: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2337: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2338: (
2339: l_api_name,
2340: G_PKG_NAME,
2341: 'OKL_API.G_RET_STS_ERROR',

Line 2341: 'OKL_API.G_RET_STS_ERROR',

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

Line 2346: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2342: x_msg_count,
2343: x_msg_data,
2344: '_PVT'
2345: );
2346: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2347: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2348: (
2349: l_api_name,
2350: G_PKG_NAME,

Line 2347: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2343: x_msg_data,
2344: '_PVT'
2345: );
2346: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2347: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2348: (
2349: l_api_name,
2350: G_PKG_NAME,
2351: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2351: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2347: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2348: (
2349: l_api_name,
2350: G_PKG_NAME,
2351: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2352: x_msg_count,
2353: x_msg_data,
2354: '_PVT'
2355: );

Line 2357: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2353: x_msg_data,
2354: '_PVT'
2355: );
2356: WHEN OTHERS THEN
2357: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2358: (
2359: l_api_name,
2360: G_PKG_NAME,
2361: 'OTHERS',

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

2374: x_msg_count OUT NOCOPY NUMBER,
2375: x_msg_data OUT NOCOPY VARCHAR2,
2376: p_cfpv_tbl IN cfpv_tbl_type,
2377: x_cfpv_tbl OUT NOCOPY cfpv_tbl_type,
2378: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2379:
2380: l_api_version CONSTANT NUMBER := 1;
2381: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2382: i NUMBER := 0;

Line 2384: OKL_API.init_msg_list(p_init_msg_list);

2380: l_api_version CONSTANT NUMBER := 1;
2381: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2382: i NUMBER := 0;
2383: BEGIN
2384: OKL_API.init_msg_list(p_init_msg_list);
2385: -- Make sure PL/SQL table has records in it before passing
2386: IF (p_cfpv_tbl.COUNT > 0) THEN
2387: i := p_cfpv_tbl.FIRST;
2388: LOOP

Line 2390: l_error_rec OKL_API.ERROR_REC_TYPE;

2386: IF (p_cfpv_tbl.COUNT > 0) THEN
2387: i := p_cfpv_tbl.FIRST;
2388: LOOP
2389: DECLARE
2390: l_error_rec OKL_API.ERROR_REC_TYPE;
2391: BEGIN
2392: l_error_rec.api_name := l_api_name;
2393: l_error_rec.api_package := G_PKG_NAME;
2394: l_error_rec.idx := i;

Line 2397: p_init_msg_list => OKL_API.G_FALSE,

2393: l_error_rec.api_package := G_PKG_NAME;
2394: l_error_rec.idx := i;
2395: update_row (
2396: p_api_version => p_api_version,
2397: p_init_msg_list => OKL_API.G_FALSE,
2398: x_return_status => l_error_rec.error_type,
2399: x_msg_count => l_error_rec.msg_count,
2400: x_msg_data => l_error_rec.msg_data,
2401: p_cfpv_rec => p_cfpv_tbl(i),

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

2399: x_msg_count => l_error_rec.msg_count,
2400: x_msg_data => l_error_rec.msg_data,
2401: p_cfpv_rec => p_cfpv_tbl(i),
2402: x_cfpv_rec => x_cfpv_tbl(i));
2403: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
2404: l_error_rec.sqlcode := SQLCODE;
2405: load_error_tbl(l_error_rec, px_error_tbl);
2406: ELSE
2407: x_msg_count := l_error_rec.msg_count;

Line 2411: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2407: x_msg_count := l_error_rec.msg_count;
2408: x_msg_data := l_error_rec.msg_data;
2409: END IF;
2410: EXCEPTION
2411: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2412: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2413: l_error_rec.sqlcode := SQLCODE;
2414: load_error_tbl(l_error_rec, px_error_tbl);
2415: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

2408: x_msg_data := l_error_rec.msg_data;
2409: END IF;
2410: EXCEPTION
2411: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2412: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2413: l_error_rec.sqlcode := SQLCODE;
2414: load_error_tbl(l_error_rec, px_error_tbl);
2415: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2416: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2415: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2411: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2412: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2413: l_error_rec.sqlcode := SQLCODE;
2414: load_error_tbl(l_error_rec, px_error_tbl);
2415: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2416: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2417: l_error_rec.sqlcode := SQLCODE;
2418: load_error_tbl(l_error_rec, px_error_tbl);
2419: WHEN OTHERS THEN

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

2412: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2413: l_error_rec.sqlcode := SQLCODE;
2414: load_error_tbl(l_error_rec, px_error_tbl);
2415: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2416: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2417: l_error_rec.sqlcode := SQLCODE;
2418: load_error_tbl(l_error_rec, px_error_tbl);
2419: WHEN OTHERS THEN
2420: l_error_rec.error_type := 'OTHERS';

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

2427: END IF;
2428: -- Loop through the error_tbl to find the error with the highest severity
2429: -- and return it.
2430: x_return_status := find_highest_exception(px_error_tbl);
2431: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2432: EXCEPTION
2433: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2434: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2435: (

Line 2433: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2429: -- and return it.
2430: x_return_status := find_highest_exception(px_error_tbl);
2431: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2432: EXCEPTION
2433: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2434: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2435: (
2436: l_api_name,
2437: G_PKG_NAME,

Line 2434: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2430: x_return_status := find_highest_exception(px_error_tbl);
2431: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2432: EXCEPTION
2433: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2434: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2435: (
2436: l_api_name,
2437: G_PKG_NAME,
2438: 'OKL_API.G_RET_STS_ERROR',

Line 2438: 'OKL_API.G_RET_STS_ERROR',

2434: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2435: (
2436: l_api_name,
2437: G_PKG_NAME,
2438: 'OKL_API.G_RET_STS_ERROR',
2439: x_msg_count,
2440: x_msg_data,
2441: '_PVT'
2442: );

Line 2443: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2439: x_msg_count,
2440: x_msg_data,
2441: '_PVT'
2442: );
2443: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2444: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2445: (
2446: l_api_name,
2447: G_PKG_NAME,

Line 2444: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2440: x_msg_data,
2441: '_PVT'
2442: );
2443: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2444: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2445: (
2446: l_api_name,
2447: G_PKG_NAME,
2448: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2448: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2444: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2445: (
2446: l_api_name,
2447: G_PKG_NAME,
2448: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2449: x_msg_count,
2450: x_msg_data,
2451: '_PVT'
2452: );

Line 2454: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2450: x_msg_data,
2451: '_PVT'
2452: );
2453: WHEN OTHERS THEN
2454: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2455: (
2456: l_api_name,
2457: G_PKG_NAME,
2458: 'OTHERS',

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

2477: x_cfpv_tbl OUT NOCOPY cfpv_tbl_type) IS
2478:
2479: l_api_version CONSTANT NUMBER := 1;
2480: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2481: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2482: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2483: BEGIN
2484: OKL_API.init_msg_list(p_init_msg_list);
2485: -- Make sure PL/SQL table has records in it before passing

Line 2482: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2478:
2479: l_api_version CONSTANT NUMBER := 1;
2480: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2481: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2482: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2483: BEGIN
2484: OKL_API.init_msg_list(p_init_msg_list);
2485: -- Make sure PL/SQL table has records in it before passing
2486: IF (p_cfpv_tbl.COUNT > 0) THEN

Line 2484: OKL_API.init_msg_list(p_init_msg_list);

2480: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2481: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2482: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2483: BEGIN
2484: OKL_API.init_msg_list(p_init_msg_list);
2485: -- Make sure PL/SQL table has records in it before passing
2486: IF (p_cfpv_tbl.COUNT > 0) THEN
2487: update_row (
2488: p_api_version => p_api_version,

Line 2489: p_init_msg_list => OKL_API.G_FALSE,

2485: -- Make sure PL/SQL table has records in it before passing
2486: IF (p_cfpv_tbl.COUNT > 0) THEN
2487: update_row (
2488: p_api_version => p_api_version,
2489: p_init_msg_list => OKL_API.G_FALSE,
2490: x_return_status => x_return_status,
2491: x_msg_count => x_msg_count,
2492: x_msg_data => x_msg_data,
2493: p_cfpv_tbl => p_cfpv_tbl,

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

2493: p_cfpv_tbl => p_cfpv_tbl,
2494: x_cfpv_tbl => x_cfpv_tbl,
2495: px_error_tbl => l_error_tbl);
2496: END IF;
2497: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2498: EXCEPTION
2499: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2500: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2501: (

Line 2499: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2495: px_error_tbl => l_error_tbl);
2496: END IF;
2497: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2498: EXCEPTION
2499: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2500: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2501: (
2502: l_api_name,
2503: G_PKG_NAME,

Line 2500: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2496: END IF;
2497: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2498: EXCEPTION
2499: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2500: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2501: (
2502: l_api_name,
2503: G_PKG_NAME,
2504: 'OKL_API.G_RET_STS_ERROR',

Line 2504: 'OKL_API.G_RET_STS_ERROR',

2500: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2501: (
2502: l_api_name,
2503: G_PKG_NAME,
2504: 'OKL_API.G_RET_STS_ERROR',
2505: x_msg_count,
2506: x_msg_data,
2507: '_PVT'
2508: );

Line 2509: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2505: x_msg_count,
2506: x_msg_data,
2507: '_PVT'
2508: );
2509: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2510: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2511: (
2512: l_api_name,
2513: G_PKG_NAME,

Line 2510: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2506: x_msg_data,
2507: '_PVT'
2508: );
2509: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2510: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2511: (
2512: l_api_name,
2513: G_PKG_NAME,
2514: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2514: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2510: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2511: (
2512: l_api_name,
2513: G_PKG_NAME,
2514: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2515: x_msg_count,
2516: x_msg_data,
2517: '_PVT'
2518: );

Line 2520: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2516: x_msg_data,
2517: '_PVT'
2518: );
2519: WHEN OTHERS THEN
2520: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2521: (
2522: l_api_name,
2523: G_PKG_NAME,
2524: 'OTHERS',

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

2542: p_cfp_rec IN cfp_rec_type) IS
2543:
2544: l_api_version CONSTANT NUMBER := 1;
2545: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2546: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2547: l_cfp_rec cfp_rec_type := p_cfp_rec;
2548: l_row_notfound BOOLEAN := TRUE;
2549: BEGIN
2550: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

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

2546: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2547: l_cfp_rec cfp_rec_type := p_cfp_rec;
2548: l_row_notfound BOOLEAN := TRUE;
2549: BEGIN
2550: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2551: p_init_msg_list,
2552: '_PVT',
2553: x_return_status);
2554: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

2550: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2551: p_init_msg_list,
2552: '_PVT',
2553: x_return_status);
2554: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2556: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2557: RAISE OKL_API.G_EXCEPTION_ERROR;
2558: END IF;

Line 2555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2551: p_init_msg_list,
2552: '_PVT',
2553: x_return_status);
2554: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2556: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2557: RAISE OKL_API.G_EXCEPTION_ERROR;
2558: END IF;
2559:

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

2552: '_PVT',
2553: x_return_status);
2554: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2556: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2557: RAISE OKL_API.G_EXCEPTION_ERROR;
2558: END IF;
2559:
2560: DELETE FROM OKL_CF_OBJECT_PERIODS

Line 2557: RAISE OKL_API.G_EXCEPTION_ERROR;

2553: x_return_status);
2554: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2555: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2556: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2557: RAISE OKL_API.G_EXCEPTION_ERROR;
2558: END IF;
2559:
2560: DELETE FROM OKL_CF_OBJECT_PERIODS
2561: WHERE ID = p_cfp_rec.id;

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

2560: DELETE FROM OKL_CF_OBJECT_PERIODS
2561: WHERE ID = p_cfp_rec.id;
2562:
2563: x_return_status := l_return_status;
2564: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2565: EXCEPTION
2566: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2567: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2568: (

Line 2566: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2562:
2563: x_return_status := l_return_status;
2564: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2565: EXCEPTION
2566: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2567: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2568: (
2569: l_api_name,
2570: G_PKG_NAME,

Line 2567: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2563: x_return_status := l_return_status;
2564: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2565: EXCEPTION
2566: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2567: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2568: (
2569: l_api_name,
2570: G_PKG_NAME,
2571: 'OKL_API.G_RET_STS_ERROR',

Line 2571: 'OKL_API.G_RET_STS_ERROR',

2567: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2568: (
2569: l_api_name,
2570: G_PKG_NAME,
2571: 'OKL_API.G_RET_STS_ERROR',
2572: x_msg_count,
2573: x_msg_data,
2574: '_PVT'
2575: );

Line 2576: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2572: x_msg_count,
2573: x_msg_data,
2574: '_PVT'
2575: );
2576: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2577: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2578: (
2579: l_api_name,
2580: G_PKG_NAME,

Line 2577: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2573: x_msg_data,
2574: '_PVT'
2575: );
2576: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2577: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2578: (
2579: l_api_name,
2580: G_PKG_NAME,
2581: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2581: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2577: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2578: (
2579: l_api_name,
2580: G_PKG_NAME,
2581: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2582: x_msg_count,
2583: x_msg_data,
2584: '_PVT'
2585: );

Line 2587: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2583: x_msg_data,
2584: '_PVT'
2585: );
2586: WHEN OTHERS THEN
2587: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2588: (
2589: l_api_name,
2590: G_PKG_NAME,
2591: 'OTHERS',

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

2606: p_cfpv_rec IN cfpv_rec_type) IS
2607:
2608: l_api_version CONSTANT NUMBER := 1;
2609: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2610: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2611: l_cfpv_rec cfpv_rec_type := p_cfpv_rec;
2612: l_cfp_rec cfp_rec_type;
2613: BEGIN
2614: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

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

2610: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2611: l_cfpv_rec cfpv_rec_type := p_cfpv_rec;
2612: l_cfp_rec cfp_rec_type;
2613: BEGIN
2614: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2615: G_PKG_NAME,
2616: p_init_msg_list,
2617: l_api_version,
2618: p_api_version,

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

2617: l_api_version,
2618: p_api_version,
2619: '_PVT',
2620: x_return_status);
2621: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2623: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2624: RAISE OKL_API.G_EXCEPTION_ERROR;
2625: END IF;

Line 2622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2618: p_api_version,
2619: '_PVT',
2620: x_return_status);
2621: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2623: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2624: RAISE OKL_API.G_EXCEPTION_ERROR;
2625: END IF;
2626: -----------------------------------------

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

2619: '_PVT',
2620: x_return_status);
2621: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2623: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2624: RAISE OKL_API.G_EXCEPTION_ERROR;
2625: END IF;
2626: -----------------------------------------
2627: -- Move VIEW record to "Child" records --

Line 2624: RAISE OKL_API.G_EXCEPTION_ERROR;

2620: x_return_status);
2621: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2622: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2623: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2624: RAISE OKL_API.G_EXCEPTION_ERROR;
2625: END IF;
2626: -----------------------------------------
2627: -- Move VIEW record to "Child" records --
2628: -----------------------------------------

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

2636: x_msg_count,
2637: x_msg_data,
2638: l_cfp_rec
2639: );
2640: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2641: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2642: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2643: RAISE OKL_API.G_EXCEPTION_ERROR;
2644: END IF;

Line 2641: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2637: x_msg_data,
2638: l_cfp_rec
2639: );
2640: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2641: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2642: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2643: RAISE OKL_API.G_EXCEPTION_ERROR;
2644: END IF;
2645: x_return_status := l_return_status;

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

2638: l_cfp_rec
2639: );
2640: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2641: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2642: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2643: RAISE OKL_API.G_EXCEPTION_ERROR;
2644: END IF;
2645: x_return_status := l_return_status;
2646: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2643: RAISE OKL_API.G_EXCEPTION_ERROR;

2639: );
2640: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2641: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2642: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2643: RAISE OKL_API.G_EXCEPTION_ERROR;
2644: END IF;
2645: x_return_status := l_return_status;
2646: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2647: EXCEPTION

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

2642: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2643: RAISE OKL_API.G_EXCEPTION_ERROR;
2644: END IF;
2645: x_return_status := l_return_status;
2646: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2647: EXCEPTION
2648: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2649: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2650: (

Line 2648: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2644: END IF;
2645: x_return_status := l_return_status;
2646: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2647: EXCEPTION
2648: WHEN OKL_API.G_EXCEPTION_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_return_status := l_return_status;
2646: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2647: EXCEPTION
2648: WHEN OKL_API.G_EXCEPTION_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_ERROR',

Line 2653: 'OKL_API.G_RET_STS_ERROR',

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

Line 2658: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2659: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2663: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2659: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2660: (
2661: l_api_name,
2662: G_PKG_NAME,
2663: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2664: x_msg_count,
2665: x_msg_data,
2666: '_PVT'
2667: );

Line 2669: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2665: x_msg_data,
2666: '_PVT'
2667: );
2668: WHEN OTHERS THEN
2669: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2670: (
2671: l_api_name,
2672: G_PKG_NAME,
2673: 'OTHERS',

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

2685: x_return_status OUT NOCOPY VARCHAR2,
2686: x_msg_count OUT NOCOPY NUMBER,
2687: x_msg_data OUT NOCOPY VARCHAR2,
2688: p_cfpv_tbl IN cfpv_tbl_type,
2689: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
2690:
2691: l_api_version CONSTANT NUMBER := 1;
2692: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2693: i NUMBER := 0;

Line 2695: OKL_API.init_msg_list(p_init_msg_list);

2691: l_api_version CONSTANT NUMBER := 1;
2692: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2693: i NUMBER := 0;
2694: BEGIN
2695: OKL_API.init_msg_list(p_init_msg_list);
2696: -- Make sure PL/SQL table has records in it before passing
2697: IF (p_cfpv_tbl.COUNT > 0) THEN
2698: i := p_cfpv_tbl.FIRST;
2699: LOOP

Line 2701: l_error_rec OKL_API.ERROR_REC_TYPE;

2697: IF (p_cfpv_tbl.COUNT > 0) THEN
2698: i := p_cfpv_tbl.FIRST;
2699: LOOP
2700: DECLARE
2701: l_error_rec OKL_API.ERROR_REC_TYPE;
2702: BEGIN
2703: l_error_rec.api_name := l_api_name;
2704: l_error_rec.api_package := G_PKG_NAME;
2705: l_error_rec.idx := i;

Line 2708: p_init_msg_list => OKL_API.G_FALSE,

2704: l_error_rec.api_package := G_PKG_NAME;
2705: l_error_rec.idx := i;
2706: delete_row (
2707: p_api_version => p_api_version,
2708: p_init_msg_list => OKL_API.G_FALSE,
2709: x_return_status => l_error_rec.error_type,
2710: x_msg_count => l_error_rec.msg_count,
2711: x_msg_data => l_error_rec.msg_data,
2712: p_cfpv_rec => p_cfpv_tbl(i));

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

2709: x_return_status => l_error_rec.error_type,
2710: x_msg_count => l_error_rec.msg_count,
2711: x_msg_data => l_error_rec.msg_data,
2712: p_cfpv_rec => p_cfpv_tbl(i));
2713: IF (l_error_rec.error_type <> OKL_API.G_RET_STS_SUCCESS) THEN
2714: l_error_rec.sqlcode := SQLCODE;
2715: load_error_tbl(l_error_rec, px_error_tbl);
2716: ELSE
2717: x_msg_count := l_error_rec.msg_count;

Line 2721: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2717: x_msg_count := l_error_rec.msg_count;
2718: x_msg_data := l_error_rec.msg_data;
2719: END IF;
2720: EXCEPTION
2721: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2722: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2723: l_error_rec.sqlcode := SQLCODE;
2724: load_error_tbl(l_error_rec, px_error_tbl);
2725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

2718: x_msg_data := l_error_rec.msg_data;
2719: END IF;
2720: EXCEPTION
2721: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2722: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2723: l_error_rec.sqlcode := SQLCODE;
2724: load_error_tbl(l_error_rec, px_error_tbl);
2725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2726: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2721: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2722: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2723: l_error_rec.sqlcode := SQLCODE;
2724: load_error_tbl(l_error_rec, px_error_tbl);
2725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2726: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2727: l_error_rec.sqlcode := SQLCODE;
2728: load_error_tbl(l_error_rec, px_error_tbl);
2729: WHEN OTHERS THEN

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

2722: l_error_rec.error_type := OKL_API.G_RET_STS_ERROR;
2723: l_error_rec.sqlcode := SQLCODE;
2724: load_error_tbl(l_error_rec, px_error_tbl);
2725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2726: l_error_rec.error_type := OKL_API.G_RET_STS_UNEXP_ERROR;
2727: l_error_rec.sqlcode := SQLCODE;
2728: load_error_tbl(l_error_rec, px_error_tbl);
2729: WHEN OTHERS THEN
2730: l_error_rec.error_type := 'OTHERS';

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

2737: END IF;
2738: -- Loop through the error_tbl to find the error with the highest severity
2739: -- and return it.
2740: x_return_status := find_highest_exception(px_error_tbl);
2741: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2742: EXCEPTION
2743: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2744: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2745: (

Line 2743: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2739: -- and return it.
2740: x_return_status := find_highest_exception(px_error_tbl);
2741: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2742: EXCEPTION
2743: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2744: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2745: (
2746: l_api_name,
2747: G_PKG_NAME,

Line 2744: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2740: x_return_status := find_highest_exception(px_error_tbl);
2741: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2742: EXCEPTION
2743: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2744: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2745: (
2746: l_api_name,
2747: G_PKG_NAME,
2748: 'OKL_API.G_RET_STS_ERROR',

Line 2748: 'OKL_API.G_RET_STS_ERROR',

2744: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2745: (
2746: l_api_name,
2747: G_PKG_NAME,
2748: 'OKL_API.G_RET_STS_ERROR',
2749: x_msg_count,
2750: x_msg_data,
2751: '_PVT'
2752: );

Line 2753: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2749: x_msg_count,
2750: x_msg_data,
2751: '_PVT'
2752: );
2753: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2754: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2755: (
2756: l_api_name,
2757: G_PKG_NAME,

Line 2754: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2750: x_msg_data,
2751: '_PVT'
2752: );
2753: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2754: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2755: (
2756: l_api_name,
2757: G_PKG_NAME,
2758: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2758: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2754: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2755: (
2756: l_api_name,
2757: G_PKG_NAME,
2758: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2759: x_msg_count,
2760: x_msg_data,
2761: '_PVT'
2762: );

Line 2764: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2760: x_msg_data,
2761: '_PVT'
2762: );
2763: WHEN OTHERS THEN
2764: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2765: (
2766: l_api_name,
2767: G_PKG_NAME,
2768: 'OTHERS',

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

2784: p_cfpv_tbl IN cfpv_tbl_type) IS
2785:
2786: l_api_version CONSTANT NUMBER := 1;
2787: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2788: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2789: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2790: BEGIN
2791: OKL_API.init_msg_list(p_init_msg_list);
2792: -- Make sure PL/SQL table has records in it before passing

Line 2789: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2785:
2786: l_api_version CONSTANT NUMBER := 1;
2787: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2788: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2789: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2790: BEGIN
2791: OKL_API.init_msg_list(p_init_msg_list);
2792: -- Make sure PL/SQL table has records in it before passing
2793: IF (p_cfpv_tbl.COUNT > 0) THEN

Line 2791: OKL_API.init_msg_list(p_init_msg_list);

2787: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2788: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2789: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2790: BEGIN
2791: OKL_API.init_msg_list(p_init_msg_list);
2792: -- Make sure PL/SQL table has records in it before passing
2793: IF (p_cfpv_tbl.COUNT > 0) THEN
2794: delete_row (
2795: p_api_version => p_api_version,

Line 2796: p_init_msg_list => OKL_API.G_FALSE,

2792: -- Make sure PL/SQL table has records in it before passing
2793: IF (p_cfpv_tbl.COUNT > 0) THEN
2794: delete_row (
2795: p_api_version => p_api_version,
2796: p_init_msg_list => OKL_API.G_FALSE,
2797: x_return_status => x_return_status,
2798: x_msg_count => x_msg_count,
2799: x_msg_data => x_msg_data,
2800: p_cfpv_tbl => p_cfpv_tbl,

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

2799: x_msg_data => x_msg_data,
2800: p_cfpv_tbl => p_cfpv_tbl,
2801: px_error_tbl => l_error_tbl);
2802: END IF;
2803: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2804: EXCEPTION
2805: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2806: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2807: (

Line 2805: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2801: px_error_tbl => l_error_tbl);
2802: END IF;
2803: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2804: EXCEPTION
2805: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2806: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2807: (
2808: l_api_name,
2809: G_PKG_NAME,

Line 2806: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2802: END IF;
2803: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2804: EXCEPTION
2805: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2806: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2807: (
2808: l_api_name,
2809: G_PKG_NAME,
2810: 'OKL_API.G_RET_STS_ERROR',

Line 2810: 'OKL_API.G_RET_STS_ERROR',

2806: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2807: (
2808: l_api_name,
2809: G_PKG_NAME,
2810: 'OKL_API.G_RET_STS_ERROR',
2811: x_msg_count,
2812: x_msg_data,
2813: '_PVT'
2814: );

Line 2815: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2811: x_msg_count,
2812: x_msg_data,
2813: '_PVT'
2814: );
2815: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2816: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2817: (
2818: l_api_name,
2819: G_PKG_NAME,

Line 2816: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2812: x_msg_data,
2813: '_PVT'
2814: );
2815: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2816: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2817: (
2818: l_api_name,
2819: G_PKG_NAME,
2820: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2820: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2816: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2817: (
2818: l_api_name,
2819: G_PKG_NAME,
2820: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2821: x_msg_count,
2822: x_msg_data,
2823: '_PVT'
2824: );

Line 2826: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2822: x_msg_data,
2823: '_PVT'
2824: );
2825: WHEN OTHERS THEN
2826: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2827: (
2828: l_api_name,
2829: G_PKG_NAME,
2830: 'OTHERS',