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_FPR_PVT dependencies on OKC_API

Line 286: IF (l_fprv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN

282: p_fprv_rec IN fprv_rec_type
283: ) RETURN fprv_rec_type IS
284: l_fprv_rec fprv_rec_type := p_fprv_rec;
285: BEGIN
286: IF (l_fprv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN
287: l_fprv_rec.object_version_number := NULL;
288: END IF;
289: IF (l_fprv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR) THEN
290: l_fprv_rec.sfwt_flag := NULL;

Line 289: IF (l_fprv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR) THEN

285: BEGIN
286: IF (l_fprv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN
287: l_fprv_rec.object_version_number := NULL;
288: END IF;
289: IF (l_fprv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR) THEN
290: l_fprv_rec.sfwt_flag := NULL;
291: END IF;
292: IF (l_fprv_rec.dsf_id = Okc_Api.G_MISS_NUM) THEN
293: l_fprv_rec.dsf_id := NULL;

Line 292: IF (l_fprv_rec.dsf_id = Okc_Api.G_MISS_NUM) THEN

288: END IF;
289: IF (l_fprv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR) THEN
290: l_fprv_rec.sfwt_flag := NULL;
291: END IF;
292: IF (l_fprv_rec.dsf_id = Okc_Api.G_MISS_NUM) THEN
293: l_fprv_rec.dsf_id := NULL;
294: END IF;
295: IF (l_fprv_rec.pmr_id = Okc_Api.G_MISS_NUM) THEN
296: l_fprv_rec.pmr_id := NULL;

Line 295: IF (l_fprv_rec.pmr_id = Okc_Api.G_MISS_NUM) THEN

291: END IF;
292: IF (l_fprv_rec.dsf_id = Okc_Api.G_MISS_NUM) THEN
293: l_fprv_rec.dsf_id := NULL;
294: END IF;
295: IF (l_fprv_rec.pmr_id = Okc_Api.G_MISS_NUM) THEN
296: l_fprv_rec.pmr_id := NULL;
297: END IF;
298: IF (l_fprv_rec.sequence_number = Okc_Api.G_MISS_NUM) THEN
299: l_fprv_rec.sequence_number := NULL;

Line 298: IF (l_fprv_rec.sequence_number = Okc_Api.G_MISS_NUM) THEN

294: END IF;
295: IF (l_fprv_rec.pmr_id = Okc_Api.G_MISS_NUM) THEN
296: l_fprv_rec.pmr_id := NULL;
297: END IF;
298: IF (l_fprv_rec.sequence_number = Okc_Api.G_MISS_NUM) THEN
299: l_fprv_rec.sequence_number := NULL;
300: END IF;
301: IF (l_fprv_rec.value = Okc_Api.G_MISS_CHAR) THEN
302: l_fprv_rec.value := NULL;

Line 301: IF (l_fprv_rec.value = Okc_Api.G_MISS_CHAR) THEN

297: END IF;
298: IF (l_fprv_rec.sequence_number = Okc_Api.G_MISS_NUM) THEN
299: l_fprv_rec.sequence_number := NULL;
300: END IF;
301: IF (l_fprv_rec.value = Okc_Api.G_MISS_CHAR) THEN
302: l_fprv_rec.value := NULL;
303: END IF;
304: IF (l_fprv_rec.instructions = Okc_Api.G_MISS_CHAR) THEN
305: l_fprv_rec.instructions := NULL;

Line 304: IF (l_fprv_rec.instructions = Okc_Api.G_MISS_CHAR) THEN

300: END IF;
301: IF (l_fprv_rec.value = Okc_Api.G_MISS_CHAR) THEN
302: l_fprv_rec.value := NULL;
303: END IF;
304: IF (l_fprv_rec.instructions = Okc_Api.G_MISS_CHAR) THEN
305: l_fprv_rec.instructions := NULL;
306: END IF;
307: IF (l_fprv_rec.fpr_type = Okc_Api.G_MISS_CHAR) THEN
308: l_fprv_rec.fpr_type := NULL;

Line 307: IF (l_fprv_rec.fpr_type = Okc_Api.G_MISS_CHAR) THEN

303: END IF;
304: IF (l_fprv_rec.instructions = Okc_Api.G_MISS_CHAR) THEN
305: l_fprv_rec.instructions := NULL;
306: END IF;
307: IF (l_fprv_rec.fpr_type = Okc_Api.G_MISS_CHAR) THEN
308: l_fprv_rec.fpr_type := NULL;
309: END IF;
310: IF (l_fprv_rec.created_by = Okc_Api.G_MISS_NUM) THEN
311: l_fprv_rec.created_by := NULL;

Line 310: IF (l_fprv_rec.created_by = Okc_Api.G_MISS_NUM) THEN

306: END IF;
307: IF (l_fprv_rec.fpr_type = Okc_Api.G_MISS_CHAR) THEN
308: l_fprv_rec.fpr_type := NULL;
309: END IF;
310: IF (l_fprv_rec.created_by = Okc_Api.G_MISS_NUM) THEN
311: l_fprv_rec.created_by := NULL;
312: END IF;
313: IF (l_fprv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
314: l_fprv_rec.creation_date := NULL;

Line 313: IF (l_fprv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN

309: END IF;
310: IF (l_fprv_rec.created_by = Okc_Api.G_MISS_NUM) THEN
311: l_fprv_rec.created_by := NULL;
312: END IF;
313: IF (l_fprv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
314: l_fprv_rec.creation_date := NULL;
315: END IF;
316: IF (l_fprv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
317: l_fprv_rec.last_updated_by := NULL;

Line 316: IF (l_fprv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN

312: END IF;
313: IF (l_fprv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
314: l_fprv_rec.creation_date := NULL;
315: END IF;
316: IF (l_fprv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
317: l_fprv_rec.last_updated_by := NULL;
318: END IF;
319: IF (l_fprv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
320: l_fprv_rec.last_update_date := NULL;

Line 319: IF (l_fprv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN

315: END IF;
316: IF (l_fprv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
317: l_fprv_rec.last_updated_by := NULL;
318: END IF;
319: IF (l_fprv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
320: l_fprv_rec.last_update_date := NULL;
321: END IF;
322: IF (l_fprv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
323: l_fprv_rec.last_update_login := NULL;

Line 322: IF (l_fprv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN

318: END IF;
319: IF (l_fprv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
320: l_fprv_rec.last_update_date := NULL;
321: END IF;
322: IF (l_fprv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
323: l_fprv_rec.last_update_login := NULL;
324: END IF;
325: RETURN(l_fprv_rec);
326: END null_out_defaults;

Line 340: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

336: ------------------------------------------------
337: FUNCTION Validate_Attributes (
338: p_fprv_rec IN fprv_rec_type
339: ) RETURN VARCHAR2 IS
340: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
341: BEGIN
342: IF p_fprv_rec.id = OKC_API.G_MISS_NUM OR
343: p_fprv_rec.id IS NULL
344: THEN

Line 342: IF p_fprv_rec.id = OKC_API.G_MISS_NUM OR

338: p_fprv_rec IN fprv_rec_type
339: ) RETURN VARCHAR2 IS
340: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
341: BEGIN
342: IF p_fprv_rec.id = OKC_API.G_MISS_NUM OR
343: p_fprv_rec.id IS NULL
344: THEN
345: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
346: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 345: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

341: BEGIN
342: IF p_fprv_rec.id = OKC_API.G_MISS_NUM OR
343: p_fprv_rec.id IS NULL
344: THEN
345: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
346: l_return_status := OKC_API.G_RET_STS_ERROR;
347: ELSIF p_fprv_rec.object_version_number = OKC_API.G_MISS_NUM OR
348: p_fprv_rec.object_version_number IS NULL
349: THEN

Line 346: l_return_status := OKC_API.G_RET_STS_ERROR;

342: IF p_fprv_rec.id = OKC_API.G_MISS_NUM OR
343: p_fprv_rec.id IS NULL
344: THEN
345: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
346: l_return_status := OKC_API.G_RET_STS_ERROR;
347: ELSIF p_fprv_rec.object_version_number = OKC_API.G_MISS_NUM OR
348: p_fprv_rec.object_version_number IS NULL
349: THEN
350: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 347: ELSIF p_fprv_rec.object_version_number = OKC_API.G_MISS_NUM OR

343: p_fprv_rec.id IS NULL
344: THEN
345: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
346: l_return_status := OKC_API.G_RET_STS_ERROR;
347: ELSIF p_fprv_rec.object_version_number = OKC_API.G_MISS_NUM OR
348: p_fprv_rec.object_version_number IS NULL
349: THEN
350: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
351: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 350: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

346: l_return_status := OKC_API.G_RET_STS_ERROR;
347: ELSIF p_fprv_rec.object_version_number = OKC_API.G_MISS_NUM OR
348: p_fprv_rec.object_version_number IS NULL
349: THEN
350: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
351: l_return_status := OKC_API.G_RET_STS_ERROR;
352: ELSIF p_fprv_rec.dsf_id = OKC_API.G_MISS_NUM OR
353: p_fprv_rec.dsf_id IS NULL
354: THEN

Line 351: l_return_status := OKC_API.G_RET_STS_ERROR;

347: ELSIF p_fprv_rec.object_version_number = OKC_API.G_MISS_NUM OR
348: p_fprv_rec.object_version_number IS NULL
349: THEN
350: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
351: l_return_status := OKC_API.G_RET_STS_ERROR;
352: ELSIF p_fprv_rec.dsf_id = OKC_API.G_MISS_NUM OR
353: p_fprv_rec.dsf_id IS NULL
354: THEN
355: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dsf_id');

Line 352: ELSIF p_fprv_rec.dsf_id = OKC_API.G_MISS_NUM OR

348: p_fprv_rec.object_version_number IS NULL
349: THEN
350: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
351: l_return_status := OKC_API.G_RET_STS_ERROR;
352: ELSIF p_fprv_rec.dsf_id = OKC_API.G_MISS_NUM OR
353: p_fprv_rec.dsf_id IS NULL
354: THEN
355: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dsf_id');
356: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 355: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dsf_id');

351: l_return_status := OKC_API.G_RET_STS_ERROR;
352: ELSIF p_fprv_rec.dsf_id = OKC_API.G_MISS_NUM OR
353: p_fprv_rec.dsf_id IS NULL
354: THEN
355: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dsf_id');
356: l_return_status := OKC_API.G_RET_STS_ERROR;
357: ELSIF p_fprv_rec.pmr_id = OKC_API.G_MISS_NUM OR
358: p_fprv_rec.pmr_id IS NULL
359: THEN

Line 356: l_return_status := OKC_API.G_RET_STS_ERROR;

352: ELSIF p_fprv_rec.dsf_id = OKC_API.G_MISS_NUM OR
353: p_fprv_rec.dsf_id IS NULL
354: THEN
355: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dsf_id');
356: l_return_status := OKC_API.G_RET_STS_ERROR;
357: ELSIF p_fprv_rec.pmr_id = OKC_API.G_MISS_NUM OR
358: p_fprv_rec.pmr_id IS NULL
359: THEN
360: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pmr_id');

Line 357: ELSIF p_fprv_rec.pmr_id = OKC_API.G_MISS_NUM OR

353: p_fprv_rec.dsf_id IS NULL
354: THEN
355: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dsf_id');
356: l_return_status := OKC_API.G_RET_STS_ERROR;
357: ELSIF p_fprv_rec.pmr_id = OKC_API.G_MISS_NUM OR
358: p_fprv_rec.pmr_id IS NULL
359: THEN
360: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pmr_id');
361: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 360: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pmr_id');

356: l_return_status := OKC_API.G_RET_STS_ERROR;
357: ELSIF p_fprv_rec.pmr_id = OKC_API.G_MISS_NUM OR
358: p_fprv_rec.pmr_id IS NULL
359: THEN
360: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pmr_id');
361: l_return_status := OKC_API.G_RET_STS_ERROR;
362: ELSIF p_fprv_rec.fpr_type = OKC_API.G_MISS_CHAR OR
363: p_fprv_rec.fpr_type IS NULL
364: THEN

Line 361: l_return_status := OKC_API.G_RET_STS_ERROR;

357: ELSIF p_fprv_rec.pmr_id = OKC_API.G_MISS_NUM OR
358: p_fprv_rec.pmr_id IS NULL
359: THEN
360: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pmr_id');
361: l_return_status := OKC_API.G_RET_STS_ERROR;
362: ELSIF p_fprv_rec.fpr_type = OKC_API.G_MISS_CHAR OR
363: p_fprv_rec.fpr_type IS NULL
364: THEN
365: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'fpr_type');

Line 362: ELSIF p_fprv_rec.fpr_type = OKC_API.G_MISS_CHAR OR

358: p_fprv_rec.pmr_id IS NULL
359: THEN
360: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'pmr_id');
361: l_return_status := OKC_API.G_RET_STS_ERROR;
362: ELSIF p_fprv_rec.fpr_type = OKC_API.G_MISS_CHAR OR
363: p_fprv_rec.fpr_type IS NULL
364: THEN
365: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'fpr_type');
366: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 365: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'fpr_type');

361: l_return_status := OKC_API.G_RET_STS_ERROR;
362: ELSIF p_fprv_rec.fpr_type = OKC_API.G_MISS_CHAR OR
363: p_fprv_rec.fpr_type IS NULL
364: THEN
365: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'fpr_type');
366: l_return_status := OKC_API.G_RET_STS_ERROR;
367: END IF;
368: RETURN(l_return_status);
369: END Validate_Attributes;

Line 366: l_return_status := OKC_API.G_RET_STS_ERROR;

362: ELSIF p_fprv_rec.fpr_type = OKC_API.G_MISS_CHAR OR
363: p_fprv_rec.fpr_type IS NULL
364: THEN
365: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'fpr_type');
366: l_return_status := OKC_API.G_RET_STS_ERROR;
367: END IF;
368: RETURN(l_return_status);
369: END Validate_Attributes;
370:

Line 380: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

376: --------------------------------------------
377: FUNCTION Validate_Record (
378: p_fprv_rec IN fprv_rec_type
379: ) RETURN VARCHAR2 IS
380: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
381: BEGIN
382: RETURN (l_return_status);
383: END Validate_Record;
384:

Line 410: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

406: ) IS
407:
408: BEGIN
409: -- initialize return status
410: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
411:
412: IF p_fprv_rec.id = Okc_Api.G_MISS_NUM OR
413: p_fprv_rec.id IS NULL
414: THEN

Line 412: IF p_fprv_rec.id = Okc_Api.G_MISS_NUM OR

408: BEGIN
409: -- initialize return status
410: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
411:
412: IF p_fprv_rec.id = Okc_Api.G_MISS_NUM OR
413: p_fprv_rec.id IS NULL
414: THEN
415: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
416: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 415: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

411:
412: IF p_fprv_rec.id = Okc_Api.G_MISS_NUM OR
413: p_fprv_rec.id IS NULL
414: THEN
415: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
416: x_return_status := Okc_Api.G_RET_STS_ERROR;
417: RAISE G_EXCEPTION_HALT_VALIDATION;
418: END IF;
419:

Line 416: x_return_status := Okc_Api.G_RET_STS_ERROR;

412: IF p_fprv_rec.id = Okc_Api.G_MISS_NUM OR
413: p_fprv_rec.id IS NULL
414: THEN
415: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
416: x_return_status := Okc_Api.G_RET_STS_ERROR;
417: RAISE G_EXCEPTION_HALT_VALIDATION;
418: END IF;
419:
420: EXCEPTION

Line 428: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

424: NULL;
425:
426: WHEN OTHERS THEN
427: -- store SQL error message on message stack for caller
428: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
429: ,p_msg_name => G_UNEXPECTED_ERROR
430: ,p_token1 => G_SQLCODE_TOKEN
431: ,p_token1_value => SQLCODE
432: ,p_token2 => G_SQLERRM_TOKEN

Line 436: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

432: ,p_token2 => G_SQLERRM_TOKEN
433: ,p_token2_value => SQLERRM);
434:
435: -- notify caller of an UNEXPECTED error
436: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
437:
438: END Validate_Id;
439:
440: ---------------------------------------------------------------------------

Line 460: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

456:
457: BEGIN
458:
459: -- initialize return status
460: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
461:
462: IF p_fprv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
463: p_fprv_rec.object_version_number IS NULL
464: THEN

Line 462: IF p_fprv_rec.object_version_number = Okc_Api.G_MISS_NUM OR

458:
459: -- initialize return status
460: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
461:
462: IF p_fprv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
463: p_fprv_rec.object_version_number IS NULL
464: THEN
465: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
466: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 465: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

461:
462: IF p_fprv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
463: p_fprv_rec.object_version_number IS NULL
464: THEN
465: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
466: x_return_status := Okc_Api.G_RET_STS_ERROR;
467: RAISE G_EXCEPTION_HALT_VALIDATION;
468: END IF;
469:

Line 466: x_return_status := Okc_Api.G_RET_STS_ERROR;

462: IF p_fprv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
463: p_fprv_rec.object_version_number IS NULL
464: THEN
465: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
466: x_return_status := Okc_Api.G_RET_STS_ERROR;
467: RAISE G_EXCEPTION_HALT_VALIDATION;
468: END IF;
469:
470: EXCEPTION

Line 478: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

474: NULL;
475:
476: WHEN OTHERS THEN
477: -- store SQL error message on message stack for caller
478: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
479: ,p_msg_name => G_UNEXPECTED_ERROR
480: ,p_token1 => G_SQLCODE_TOKEN
481: ,p_token1_value => SQLCODE
482: ,p_token2 => G_SQLERRM_TOKEN

Line 486: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

482: ,p_token2 => G_SQLERRM_TOKEN
483: ,p_token2_value => SQLERRM);
484:
485: -- notify caller of an UNEXPECTED error
486: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
487:
488: END Validate_Object_Version_Number;
489:
490: ---------------------------------------------------------------------------

Line 519: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

515:
516: BEGIN
517:
518: -- initialize return status
519: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
520:
521: IF p_fprv_rec.dsf_id = Okc_Api.G_MISS_NUM OR
522: p_fprv_rec.dsf_id IS NULL
523: THEN

Line 521: IF p_fprv_rec.dsf_id = Okc_Api.G_MISS_NUM OR

517:
518: -- initialize return status
519: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
520:
521: IF p_fprv_rec.dsf_id = Okc_Api.G_MISS_NUM OR
522: p_fprv_rec.dsf_id IS NULL
523: THEN
524: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dsf_id');
525: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 524: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dsf_id');

520:
521: IF p_fprv_rec.dsf_id = Okc_Api.G_MISS_NUM OR
522: p_fprv_rec.dsf_id IS NULL
523: THEN
524: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dsf_id');
525: x_return_status := Okc_Api.G_RET_STS_ERROR;
526: RAISE G_EXCEPTION_HALT_VALIDATION;
527: END IF;
528:

Line 525: x_return_status := Okc_Api.G_RET_STS_ERROR;

521: IF p_fprv_rec.dsf_id = Okc_Api.G_MISS_NUM OR
522: p_fprv_rec.dsf_id IS NULL
523: THEN
524: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'dsf_id');
525: x_return_status := Okc_Api.G_RET_STS_ERROR;
526: RAISE G_EXCEPTION_HALT_VALIDATION;
527: END IF;
528:
529: OPEN okl_Dsfv_pk_csr(p_fprv_rec.dsf_id);

Line 535: Okc_Api.set_message(G_APP_NAME,G_INVALID_KEY);

531: l_row_not_found := okl_dsfv_pk_csr%NOTFOUND;
532: CLOSE okl_dsfv_pk_csr;
533:
534: IF l_row_not_found THEN
535: Okc_Api.set_message(G_APP_NAME,G_INVALID_KEY);
536: x_return_status := Okc_Api.G_RET_STS_ERROR;
537: END IF;
538:
539: EXCEPTION

Line 536: x_return_status := Okc_Api.G_RET_STS_ERROR;

532: CLOSE okl_dsfv_pk_csr;
533:
534: IF l_row_not_found THEN
535: Okc_Api.set_message(G_APP_NAME,G_INVALID_KEY);
536: x_return_status := Okc_Api.G_RET_STS_ERROR;
537: END IF;
538:
539: EXCEPTION
540: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 547: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

543: NULL;
544:
545: WHEN OTHERS THEN
546: -- store SQL error message on message stack for caller
547: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
548: ,p_msg_name => G_UNEXPECTED_ERROR
549: ,p_token1 => G_SQLCODE_TOKEN
550: ,p_token1_value => SQLCODE
551: ,p_token2 => G_SQLERRM_TOKEN

Line 555: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

551: ,p_token2 => G_SQLERRM_TOKEN
552: ,p_token2_value => SQLERRM);
553:
554: -- notify caller of an UNEXPECTED error
555: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
556:
557: -- verify that the cursor was closed
558: IF okl_dsfv_pk_csr%ISOPEN THEN
559: CLOSE okl_dsfv_pk_csr;

Line 597: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

593:
594: BEGIN
595:
596: -- initialize return status
597: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
598:
599: OPEN okl_Dsfv_pk_csr(p_fprv_rec.dsf_id);
600: FETCH okl_dsfv_pk_csr INTO l_dummy;
601: l_row_not_found := okl_dsfv_pk_csr%NOTFOUND;

Line 605: Okc_Api.set_message(G_APP_NAME,G_INCORRECT_FUNC_TYPE);

601: l_row_not_found := okl_dsfv_pk_csr%NOTFOUND;
602: CLOSE okl_dsfv_pk_csr;
603:
604: IF l_row_not_found THEN
605: Okc_Api.set_message(G_APP_NAME,G_INCORRECT_FUNC_TYPE);
606: x_return_status := Okc_Api.G_RET_STS_ERROR;
607: END IF;
608:
609: EXCEPTION

Line 606: x_return_status := Okc_Api.G_RET_STS_ERROR;

602: CLOSE okl_dsfv_pk_csr;
603:
604: IF l_row_not_found THEN
605: Okc_Api.set_message(G_APP_NAME,G_INCORRECT_FUNC_TYPE);
606: x_return_status := Okc_Api.G_RET_STS_ERROR;
607: END IF;
608:
609: EXCEPTION
610: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 617: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

613: NULL;
614:
615: WHEN OTHERS THEN
616: -- store SQL error message on message stack for caller
617: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
618: ,p_msg_name => G_UNEXPECTED_ERROR
619: ,p_token1 => G_SQLCODE_TOKEN
620: ,p_token1_value => SQLCODE
621: ,p_token2 => G_SQLERRM_TOKEN

Line 625: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

621: ,p_token2 => G_SQLERRM_TOKEN
622: ,p_token2_value => SQLERRM);
623:
624: -- notify caller of an UNEXPECTED error
625: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
626:
627: -- verify that the cursor was closed
628: IF okl_dsfv_pk_csr%ISOPEN THEN
629: CLOSE okl_dsfv_pk_csr;

Line 652: -- l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

648: PROCEDURE Validate_Sfwt_Flag(p_fprv_rec IN fprv_rec_type,
649: x_return_status OUT NOCOPY VARCHAR2)
650: IS
651:
652: -- l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
653: l_return_status VARCHAR2(1) := OKL_API.G_TRUE;
654:
655: BEGIN
656: -- initialize return status

Line 657: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

653: l_return_status VARCHAR2(1) := OKL_API.G_TRUE;
654:
655: BEGIN
656: -- initialize return status
657: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
658:
659: -- check from domain values using the generic
660: -- l_return_status := Okl_Util.check_domain_yn(p_fprv_rec.sfwt_flag);
661: l_return_status := OKL_ACCOUNTING_UTIL.validate_lookup_code('YES_NO',p_fprv_rec.sfwt_flag,0,0);

Line 663: -- IF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

659: -- check from domain values using the generic
660: -- l_return_status := Okl_Util.check_domain_yn(p_fprv_rec.sfwt_flag);
661: l_return_status := OKL_ACCOUNTING_UTIL.validate_lookup_code('YES_NO',p_fprv_rec.sfwt_flag,0,0);
662:
663: -- IF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
664: IF (l_return_status = OKL_API.G_FALSE) THEN
665: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
666: p_msg_name => g_invalid_value,
667: p_token1 => g_col_name_token,

Line 665: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

661: l_return_status := OKL_ACCOUNTING_UTIL.validate_lookup_code('YES_NO',p_fprv_rec.sfwt_flag,0,0);
662:
663: -- IF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
664: IF (l_return_status = OKL_API.G_FALSE) THEN
665: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
666: p_msg_name => g_invalid_value,
667: p_token1 => g_col_name_token,
668: p_token1_value => 'sfwt_flag');
669: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 669: x_return_status := Okc_Api.G_RET_STS_ERROR;

665: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
666: p_msg_name => g_invalid_value,
667: p_token1 => g_col_name_token,
668: p_token1_value => 'sfwt_flag');
669: x_return_status := Okc_Api.G_RET_STS_ERROR;
670: END IF;
671:
672: EXCEPTION
673: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 680: Okc_Api.SET_MESSAGE( p_app_name => g_app_name,

676: NULL;
677:
678: WHEN OTHERS THEN
679: -- store SQL error message on message stack for caller
680: Okc_Api.SET_MESSAGE( p_app_name => g_app_name,
681: p_msg_name => g_unexpected_error,
682: p_token1 => g_sqlcode_token,
683: p_token1_value => SQLCODE,
684: p_token2 => g_sqlerrm_token,

Line 688: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

684: p_token2 => g_sqlerrm_token,
685: p_token2_value => SQLERRM );
686:
687: -- notify caller of an UNEXPECTED error
688: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
689:
690: END Validate_Sfwt_Flag;
691:
692: ---------------------------------------------------------------------------

Line 721: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

717:
718: BEGIN
719:
720: -- initialize return status
721: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
722:
723: -- RPOONUGA001: Modified the if condition to check the validility
724: -- in the case of valid pmr_id passed
725: IF p_fprv_rec.pmr_id <> Okc_Api.G_MISS_NUM AND

Line 725: IF p_fprv_rec.pmr_id <> Okc_Api.G_MISS_NUM AND

721: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
722:
723: -- RPOONUGA001: Modified the if condition to check the validility
724: -- in the case of valid pmr_id passed
725: IF p_fprv_rec.pmr_id <> Okc_Api.G_MISS_NUM AND
726: p_fprv_rec.pmr_id IS NOT NULL
727: THEN
728: OPEN okl_pmrv_pk_csr(p_fprv_rec.pmr_id);
729: FETCH okl_pmrv_pk_csr INTO l_dummy;

Line 734: Okc_Api.set_message(G_APP_NAME,G_INVALID_KEY);

730: l_row_not_found := okl_pmrv_pk_csr%NOTFOUND;
731: CLOSE okl_pmrv_pk_csr;
732:
733: IF l_row_not_found THEN
734: Okc_Api.set_message(G_APP_NAME,G_INVALID_KEY);
735: x_return_status := Okc_Api.G_RET_STS_ERROR;
736: END IF;
737: END IF;
738:

Line 735: x_return_status := Okc_Api.G_RET_STS_ERROR;

731: CLOSE okl_pmrv_pk_csr;
732:
733: IF l_row_not_found THEN
734: Okc_Api.set_message(G_APP_NAME,G_INVALID_KEY);
735: x_return_status := Okc_Api.G_RET_STS_ERROR;
736: END IF;
737: END IF;
738:
739: EXCEPTION

Line 747: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

743: NULL;
744:
745: WHEN OTHERS THEN
746: -- store SQL error message on message stack for caller
747: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
748: ,p_msg_name => G_UNEXPECTED_ERROR
749: ,p_token1 => G_SQLCODE_TOKEN
750: ,p_token1_value => SQLCODE
751: ,p_token2 => G_SQLERRM_TOKEN

Line 755: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

751: ,p_token2 => G_SQLERRM_TOKEN
752: ,p_token2_value => SQLERRM);
753:
754: -- notify caller of an UNEXPECTED error
755: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
756:
757: -- verify that the cursor was closed
758: IF okl_pmrv_pk_csr%ISOPEN THEN
759: CLOSE okl_pmrv_pk_csr;

Line 798: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

794: */
795:
796: BEGIN
797: -- initialize return status
798: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
799: IF p_fprv_rec.fpr_type = Okc_Api.G_MISS_CHAR OR
800: p_fprv_rec.fpr_type IS NULL
801: THEN
802: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'fpr_type');

Line 799: IF p_fprv_rec.fpr_type = Okc_Api.G_MISS_CHAR OR

795:
796: BEGIN
797: -- initialize return status
798: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
799: IF p_fprv_rec.fpr_type = Okc_Api.G_MISS_CHAR OR
800: p_fprv_rec.fpr_type IS NULL
801: THEN
802: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'fpr_type');
803: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 802: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'fpr_type');

798: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
799: IF p_fprv_rec.fpr_type = Okc_Api.G_MISS_CHAR OR
800: p_fprv_rec.fpr_type IS NULL
801: THEN
802: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'fpr_type');
803: x_return_status := Okc_Api.G_RET_STS_ERROR;
804: RAISE G_EXCEPTION_HALT_VALIDATION;
805: END IF;
806:

Line 803: x_return_status := Okc_Api.G_RET_STS_ERROR;

799: IF p_fprv_rec.fpr_type = Okc_Api.G_MISS_CHAR OR
800: p_fprv_rec.fpr_type IS NULL
801: THEN
802: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'fpr_type');
803: x_return_status := Okc_Api.G_RET_STS_ERROR;
804: RAISE G_EXCEPTION_HALT_VALIDATION;
805: END IF;
806:
807: /*

Line 817: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'fpr_type');

813:
814: l_row_found := OKL_ACCOUNTING_UTIL.validate_lookup_code('OKL_FUNCTION_PMR_TYPE',p_fprv_rec.fpr_type);
815: -- IF l_row_not_found then
816: IF (l_row_found = OKL_API.G_FALSE) then
817: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'fpr_type');
818: x_return_status := OKC_API.G_RET_STS_ERROR;
819: END IF;
820:
821: IF p_fprv_rec.fpr_type = G_STATIC_TYPE AND (p_fprv_rec.value = OKL_API.G_MISS_CHAR OR

Line 818: x_return_status := OKC_API.G_RET_STS_ERROR;

814: l_row_found := OKL_ACCOUNTING_UTIL.validate_lookup_code('OKL_FUNCTION_PMR_TYPE',p_fprv_rec.fpr_type);
815: -- IF l_row_not_found then
816: IF (l_row_found = OKL_API.G_FALSE) then
817: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'fpr_type');
818: x_return_status := OKC_API.G_RET_STS_ERROR;
819: END IF;
820:
821: IF p_fprv_rec.fpr_type = G_STATIC_TYPE AND (p_fprv_rec.value = OKL_API.G_MISS_CHAR OR
822: p_fprv_rec.value IS NULL)

Line 828: x_return_status := Okc_Api.G_RET_STS_ERROR;

824: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
825: p_msg_name => G_MISS_DATA,
826: p_token1 => G_COL_NAME_TOKEN,
827: p_token1_value => 'VALUE');
828: x_return_status := Okc_Api.G_RET_STS_ERROR;
829: RAISE G_EXCEPTION_HALT_VALIDATION;
830: END IF;
831:
832: IF p_fprv_rec.fpr_type = G_CONTEXT_TYPE AND (p_fprv_rec.pmr_id = OKL_API.G_MISS_NUM OR

Line 839: x_return_status := Okc_Api.G_RET_STS_ERROR;

835: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
836: p_msg_name => G_MISS_DATA,
837: p_token1 => G_COL_NAME_TOKEN,
838: p_token1_value => 'PMR_ID');
839: x_return_status := Okc_Api.G_RET_STS_ERROR;
840: RAISE G_EXCEPTION_HALT_VALIDATION;
841: END IF;
842:
843: EXCEPTION

Line 851: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

847: NULL;
848:
849: WHEN OTHERS THEN
850: -- store SQL error message on message stack for caller
851: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME
852: ,p_msg_name => G_UNEXPECTED_ERROR
853: ,p_token1 => G_SQLCODE_TOKEN
854: ,p_token1_value => SQLCODE
855: ,p_token2 => G_SQLERRM_TOKEN

Line 859: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

855: ,p_token2 => G_SQLERRM_TOKEN
856: ,p_token2_value => SQLERRM);
857:
858: -- notify caller of an UNEXPECTED error
859: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
860:
861: END Validate_Fpr_Type;
862:
863: ---------------------------------------------------------------------------

Line 880: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

876: FUNCTION Validate_Attributes (
877: p_fprv_rec IN fprv_rec_type
878: ) RETURN VARCHAR2 IS
879:
880: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
881: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
882: BEGIN
883: -- call each column-level validation
884:

Line 881: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

877: p_fprv_rec IN fprv_rec_type
878: ) RETURN VARCHAR2 IS
879:
880: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
881: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
882: BEGIN
883: -- call each column-level validation
884:
885: -- Validate_Id

Line 887: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

883: -- call each column-level validation
884:
885: -- Validate_Id
886: Validate_Id(p_fprv_rec, x_return_status);
887: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
888: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
889: -- need to exit
890: l_return_status := x_return_status;
891: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 888: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

884:
885: -- Validate_Id
886: Validate_Id(p_fprv_rec, x_return_status);
887: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
888: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
889: -- need to exit
890: l_return_status := x_return_status;
891: RAISE G_EXCEPTION_HALT_VALIDATION;
892: ELSE

Line 900: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

896: END IF;
897:
898: -- Validate_Object_Version_Number
899: Validate_Object_Version_Number(p_fprv_rec, x_return_status);
900: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
901: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
902: -- need to exit
903: l_return_status := x_return_status;
904: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 901: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

897:
898: -- Validate_Object_Version_Number
899: Validate_Object_Version_Number(p_fprv_rec, x_return_status);
900: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
901: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
902: -- need to exit
903: l_return_status := x_return_status;
904: RAISE G_EXCEPTION_HALT_VALIDATION;
905: ELSE

Line 913: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

909: END IF;
910:
911: -- Validate_Sfwt_Flag
912: Validate_Sfwt_Flag(p_fprv_rec, x_return_status);
913: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
914: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
915: -- need to exit
916: l_return_status := x_return_status;
917: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 914: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

910:
911: -- Validate_Sfwt_Flag
912: Validate_Sfwt_Flag(p_fprv_rec, x_return_status);
913: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
914: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
915: -- need to exit
916: l_return_status := x_return_status;
917: RAISE G_EXCEPTION_HALT_VALIDATION;
918: ELSE

Line 926: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

922: END IF;
923:
924: -- Validate_Dsf_id
925: Validate_Dsf_id(p_fprv_rec, x_return_status);
926: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
927: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
928: -- need to exit
929: l_return_status := x_return_status;
930: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 927: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

923:
924: -- Validate_Dsf_id
925: Validate_Dsf_id(p_fprv_rec, x_return_status);
926: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
927: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
928: -- need to exit
929: l_return_status := x_return_status;
930: RAISE G_EXCEPTION_HALT_VALIDATION;
931: ELSE

Line 941: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

937: -- Added by kthiruva on 08-Jun-2005 for Pricing Enhancements
938: -- Bug 4421600 - Start of Changes
939: -- Validate_Func_Code
940: Validate_Func_Code(p_fprv_rec, x_return_status);
941: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
942: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
943: -- need to exit
944: l_return_status := x_return_status;
945: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 942: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

938: -- Bug 4421600 - Start of Changes
939: -- Validate_Func_Code
940: Validate_Func_Code(p_fprv_rec, x_return_status);
941: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
942: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
943: -- need to exit
944: l_return_status := x_return_status;
945: RAISE G_EXCEPTION_HALT_VALIDATION;
946: ELSE

Line 956: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

952:
953: -- RPOONUGA001: Moved the code above validate_pmr_id
954: -- Validate_Fpr_Type
955: Validate_Fpr_Type(p_fprv_rec, x_return_status);
956: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
957: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
958: -- need to exit
959: l_return_status := x_return_status;
960: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 957: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

953: -- RPOONUGA001: Moved the code above validate_pmr_id
954: -- Validate_Fpr_Type
955: Validate_Fpr_Type(p_fprv_rec, x_return_status);
956: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
957: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
958: -- need to exit
959: l_return_status := x_return_status;
960: RAISE G_EXCEPTION_HALT_VALIDATION;
961: ELSE

Line 969: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

965: END IF;
966:
967: -- Validate_Pmr_Id
968: Validate_Pmr_Id(p_fprv_rec, x_return_status);
969: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
970: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
971: -- need to exit
972: l_return_status := x_return_status;
973: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 970: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

966:
967: -- Validate_Pmr_Id
968: Validate_Pmr_Id(p_fprv_rec, x_return_status);
969: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
970: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
971: -- need to exit
972: l_return_status := x_return_status;
973: RAISE G_EXCEPTION_HALT_VALIDATION;
974: ELSE

Line 988: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

984: RETURN (l_return_status);
985:
986: WHEN OTHERS THEN
987: -- store SQL error message on message stack for caller
988: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
989: p_msg_name => g_unexpected_error,
990: p_token1 => g_sqlcode_token,
991: p_token1_value => SQLCODE,
992: p_token2 => g_sqlerrm_token,

Line 995: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

991: p_token1_value => SQLCODE,
992: p_token2 => g_sqlerrm_token,
993: p_token2_value => SQLERRM);
994: -- notify caller of an UNEXPECTED error
995: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
996:
997: RETURN(l_return_status);
998: END Validate_Attributes;
999:

Line 1030: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

1026:
1027: BEGIN
1028:
1029: -- initialize return status
1030: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1031: OPEN okl_fpr_uk_csr(p_fprv_rec);
1032: FETCH okl_fpr_uk_csr INTO l_dummy;
1033: l_row_found := okl_fpr_uk_csr%FOUND;
1034: CLOSE okl_fpr_uk_csr;

Line 1036: Okc_Api.set_message(G_APP_NAME,G_UNQS, G_TABLE_TOKEN, 'Okl_Fnctn_Prmtrs_V');

1032: FETCH okl_fpr_uk_csr INTO l_dummy;
1033: l_row_found := okl_fpr_uk_csr%FOUND;
1034: CLOSE okl_fpr_uk_csr;
1035: IF l_row_found THEN
1036: Okc_Api.set_message(G_APP_NAME,G_UNQS, G_TABLE_TOKEN, 'Okl_Fnctn_Prmtrs_V');
1037: x_return_status := Okc_Api.G_RET_STS_ERROR;
1038: END IF;
1039: EXCEPTION
1040: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1037: x_return_status := Okc_Api.G_RET_STS_ERROR;

1033: l_row_found := okl_fpr_uk_csr%FOUND;
1034: CLOSE okl_fpr_uk_csr;
1035: IF l_row_found THEN
1036: Okc_Api.set_message(G_APP_NAME,G_UNQS, G_TABLE_TOKEN, 'Okl_Fnctn_Prmtrs_V');
1037: x_return_status := Okc_Api.G_RET_STS_ERROR;
1038: END IF;
1039: EXCEPTION
1040: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1041: -- no processing necessary; validation can continue

Line 1047: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

1043: NULL;
1044:
1045: WHEN OTHERS THEN
1046: -- store SQL error message on message stack for caller
1047: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1048: p_msg_name => g_unexpected_error,
1049: p_token1 => g_sqlcode_token,
1050: p_token1_value => SQLCODE,
1051: p_token2 => g_sqlerrm_token,

Line 1055: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1051: p_token2 => g_sqlerrm_token,
1052: p_token2_value => SQLERRM);
1053:
1054: -- notify caller of an UNEXPECTED error
1055: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1056:
1057: END Validate_Unique_Fpr_Record;
1058:
1059: ---------------------------------------------------------------------------

Line 1075: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1071:
1072: FUNCTION Validate_Record (
1073: p_fprv_rec IN fprv_rec_type
1074: ) RETURN VARCHAR2 IS
1075: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1076: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1077: BEGIN
1078: -- Validate_Unique_Fpr_Record
1079: Validate_Unique_Fpr_Record(p_fprv_rec, x_return_status);

Line 1076: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1072: FUNCTION Validate_Record (
1073: p_fprv_rec IN fprv_rec_type
1074: ) RETURN VARCHAR2 IS
1075: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1076: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1077: BEGIN
1078: -- Validate_Unique_Fpr_Record
1079: Validate_Unique_Fpr_Record(p_fprv_rec, x_return_status);
1080: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

Line 1080: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1076: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1077: BEGIN
1078: -- Validate_Unique_Fpr_Record
1079: Validate_Unique_Fpr_Record(p_fprv_rec, x_return_status);
1080: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1081: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1082: -- need to leave
1083: l_return_status := x_return_status;
1084: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1081: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1077: BEGIN
1078: -- Validate_Unique_Fpr_Record
1079: Validate_Unique_Fpr_Record(p_fprv_rec, x_return_status);
1080: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1081: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1082: -- need to leave
1083: l_return_status := x_return_status;
1084: RAISE G_EXCEPTION_HALT_VALIDATION;
1085: ELSE

Line 1100: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

1096: RETURN (l_return_status);
1097:
1098: WHEN OTHERS THEN
1099: -- store SQL error message on message stack for caller
1100: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1101: p_msg_name => g_unexpected_error,
1102: p_token1 => g_sqlcode_token,
1103: p_token1_value => SQLCODE,
1104: p_token2 => g_sqlerrm_token,

Line 1107: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1103: p_token1_value => SQLCODE,
1104: p_token2 => g_sqlerrm_token,
1105: p_token2_value => SQLERRM);
1106: -- notify caller of an UNEXPECTED error
1107: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1108: RETURN(l_return_status);
1109: END Validate_Record;
1110: -- END change : mvasudev
1111:

Line 1196: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1192: -- validate_row for:OKL_FNCTN_PRMTRS_V --
1193: -----------------------------------------
1194: PROCEDURE validate_row(
1195: p_api_version IN NUMBER,
1196: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1197: x_return_status OUT NOCOPY VARCHAR2,
1198: x_msg_count OUT NOCOPY NUMBER,
1199: x_msg_data OUT NOCOPY VARCHAR2,
1200: p_fprv_rec IN fprv_rec_type) IS

Line 1204: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1200: p_fprv_rec IN fprv_rec_type) IS
1201:
1202: l_api_version CONSTANT NUMBER := 1;
1203: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1204: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1205: l_fprv_rec fprv_rec_type := p_fprv_rec;
1206: l_fpr_rec fpr_rec_type;
1207: l_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type;
1208: BEGIN

Line 1209: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1205: l_fprv_rec fprv_rec_type := p_fprv_rec;
1206: l_fpr_rec fpr_rec_type;
1207: l_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type;
1208: BEGIN
1209: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1210: G_PKG_NAME,
1211: p_init_msg_list,
1212: l_api_version,
1213: p_api_version,

Line 1216: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1212: l_api_version,
1213: p_api_version,
1214: '_PVT',
1215: x_return_status);
1216: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1219: RAISE Okc_Api.G_EXCEPTION_ERROR;
1220: END IF;

Line 1217: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1213: p_api_version,
1214: '_PVT',
1215: x_return_status);
1216: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1219: RAISE Okc_Api.G_EXCEPTION_ERROR;
1220: END IF;
1221: --- Validate all non-missing attributes (Item Level Validation)

Line 1218: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1214: '_PVT',
1215: x_return_status);
1216: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1219: RAISE Okc_Api.G_EXCEPTION_ERROR;
1220: END IF;
1221: --- Validate all non-missing attributes (Item Level Validation)
1222: l_return_status := Validate_Attributes(l_fprv_rec);

Line 1219: RAISE Okc_Api.G_EXCEPTION_ERROR;

1215: x_return_status);
1216: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1219: RAISE Okc_Api.G_EXCEPTION_ERROR;
1220: END IF;
1221: --- Validate all non-missing attributes (Item Level Validation)
1222: l_return_status := Validate_Attributes(l_fprv_rec);
1223: --- If any errors happen abort API

Line 1224: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

Line 1225: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 1226: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1222: l_return_status := Validate_Attributes(l_fprv_rec);
1223: --- If any errors happen abort API
1224: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1225: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1226: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1227: RAISE Okc_Api.G_EXCEPTION_ERROR;
1228: END IF;
1229: l_return_status := Validate_Record(l_fprv_rec);
1230: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1227: RAISE Okc_Api.G_EXCEPTION_ERROR;

1223: --- If any errors happen abort API
1224: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1225: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1226: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1227: RAISE Okc_Api.G_EXCEPTION_ERROR;
1228: END IF;
1229: l_return_status := Validate_Record(l_fprv_rec);
1230: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1231: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1230: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1226: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1227: RAISE Okc_Api.G_EXCEPTION_ERROR;
1228: END IF;
1229: l_return_status := Validate_Record(l_fprv_rec);
1230: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1231: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1232: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1233: RAISE Okc_Api.G_EXCEPTION_ERROR;
1234: END IF;

Line 1231: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1227: RAISE Okc_Api.G_EXCEPTION_ERROR;
1228: END IF;
1229: l_return_status := Validate_Record(l_fprv_rec);
1230: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1231: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1232: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1233: RAISE Okc_Api.G_EXCEPTION_ERROR;
1234: END IF;
1235: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1232: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1228: END IF;
1229: l_return_status := Validate_Record(l_fprv_rec);
1230: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1231: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1232: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1233: RAISE Okc_Api.G_EXCEPTION_ERROR;
1234: END IF;
1235: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1236: EXCEPTION

Line 1233: RAISE Okc_Api.G_EXCEPTION_ERROR;

1229: l_return_status := Validate_Record(l_fprv_rec);
1230: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1231: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1232: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1233: RAISE Okc_Api.G_EXCEPTION_ERROR;
1234: END IF;
1235: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1236: EXCEPTION
1237: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 1235: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1231: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1232: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1233: RAISE Okc_Api.G_EXCEPTION_ERROR;
1234: END IF;
1235: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1236: EXCEPTION
1237: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1238: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1239: (

Line 1237: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1233: RAISE Okc_Api.G_EXCEPTION_ERROR;
1234: END IF;
1235: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1236: EXCEPTION
1237: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1238: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1239: (
1240: l_api_name,
1241: G_PKG_NAME,

Line 1238: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1234: END IF;
1235: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1236: EXCEPTION
1237: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1238: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1239: (
1240: l_api_name,
1241: G_PKG_NAME,
1242: 'OKC_API.G_RET_STS_ERROR',

Line 1242: 'OKC_API.G_RET_STS_ERROR',

1238: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1239: (
1240: l_api_name,
1241: G_PKG_NAME,
1242: 'OKC_API.G_RET_STS_ERROR',
1243: x_msg_count,
1244: x_msg_data,
1245: '_PVT'
1246: );

Line 1247: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1243: x_msg_count,
1244: x_msg_data,
1245: '_PVT'
1246: );
1247: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1248: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1249: (
1250: l_api_name,
1251: G_PKG_NAME,

Line 1248: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1244: x_msg_data,
1245: '_PVT'
1246: );
1247: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1248: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1249: (
1250: l_api_name,
1251: G_PKG_NAME,
1252: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1252: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1248: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1249: (
1250: l_api_name,
1251: G_PKG_NAME,
1252: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1253: x_msg_count,
1254: x_msg_data,
1255: '_PVT'
1256: );

Line 1258: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1254: x_msg_data,
1255: '_PVT'
1256: );
1257: WHEN OTHERS THEN
1258: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1259: (
1260: l_api_name,
1261: G_PKG_NAME,
1262: 'OTHERS',

Line 1273: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1269: -- PL/SQL TBL validate_row for:FPRV_TBL --
1270: ------------------------------------------
1271: PROCEDURE validate_row(
1272: p_api_version IN NUMBER,
1273: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1274: x_return_status OUT NOCOPY VARCHAR2,
1275: x_msg_count OUT NOCOPY NUMBER,
1276: x_msg_data OUT NOCOPY VARCHAR2,
1277: p_fprv_tbl IN fprv_tbl_type) IS

Line 1281: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1277: p_fprv_tbl IN fprv_tbl_type) IS
1278:
1279: l_api_version CONSTANT NUMBER := 1;
1280: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1281: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1282: i NUMBER := 0;
1283: -- START change : mvasudev, 05/15/2001
1284: -- Adding OverAll Status Flag
1285: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 1285: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1281: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1282: i NUMBER := 0;
1283: -- START change : mvasudev, 05/15/2001
1284: -- Adding OverAll Status Flag
1285: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1286: -- END change : mvasudev
1287: BEGIN
1288: Okc_Api.init_msg_list(p_init_msg_list);
1289: -- Make sure PL/SQL table has records in it before passing

Line 1288: Okc_Api.init_msg_list(p_init_msg_list);

1284: -- Adding OverAll Status Flag
1285: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1286: -- END change : mvasudev
1287: BEGIN
1288: Okc_Api.init_msg_list(p_init_msg_list);
1289: -- Make sure PL/SQL table has records in it before passing
1290: IF (p_fprv_tbl.COUNT > 0) THEN
1291: i := p_fprv_tbl.FIRST;
1292: LOOP

Line 1295: p_init_msg_list => Okc_Api.G_FALSE,

1291: i := p_fprv_tbl.FIRST;
1292: LOOP
1293: validate_row (
1294: p_api_version => p_api_version,
1295: p_init_msg_list => Okc_Api.G_FALSE,
1296: x_return_status => x_return_status,
1297: x_msg_count => x_msg_count,
1298: x_msg_data => x_msg_data,
1299: p_fprv_rec => p_fprv_tbl(i));

Line 1302: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1298: x_msg_data => x_msg_data,
1299: p_fprv_rec => p_fprv_tbl(i));
1300: -- START change : mvasudev, 05/15/2001
1301: -- store the highest degree of error
1302: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1303: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1304: l_overall_status := x_return_status;
1305: END IF;
1306: END IF;

Line 1303: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1299: p_fprv_rec => p_fprv_tbl(i));
1300: -- START change : mvasudev, 05/15/2001
1301: -- store the highest degree of error
1302: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1303: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1304: l_overall_status := x_return_status;
1305: END IF;
1306: END IF;
1307: -- END change : mvasudev

Line 1317: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1313: x_return_status := l_overall_status;
1314: -- END change : mvasudev
1315: END IF;
1316: EXCEPTION
1317: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1318: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1319: (
1320: l_api_name,
1321: G_PKG_NAME,

Line 1318: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1314: -- END change : mvasudev
1315: END IF;
1316: EXCEPTION
1317: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1318: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1319: (
1320: l_api_name,
1321: G_PKG_NAME,
1322: 'OKC_API.G_RET_STS_ERROR',

Line 1322: 'OKC_API.G_RET_STS_ERROR',

1318: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1319: (
1320: l_api_name,
1321: G_PKG_NAME,
1322: 'OKC_API.G_RET_STS_ERROR',
1323: x_msg_count,
1324: x_msg_data,
1325: '_PVT'
1326: );

Line 1327: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1323: x_msg_count,
1324: x_msg_data,
1325: '_PVT'
1326: );
1327: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1328: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1329: (
1330: l_api_name,
1331: G_PKG_NAME,

Line 1328: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1324: x_msg_data,
1325: '_PVT'
1326: );
1327: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1328: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1329: (
1330: l_api_name,
1331: G_PKG_NAME,
1332: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1332: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1328: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1329: (
1330: l_api_name,
1331: G_PKG_NAME,
1332: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1333: x_msg_count,
1334: x_msg_data,
1335: '_PVT'
1336: );

Line 1338: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1334: x_msg_data,
1335: '_PVT'
1336: );
1337: WHEN OTHERS THEN
1338: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1339: (
1340: l_api_name,
1341: G_PKG_NAME,
1342: 'OTHERS',

Line 1356: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1352: ---------------------------------------
1353: -- insert_row for:OKL_FNCTN_PRMTRS_B --
1354: ---------------------------------------
1355: PROCEDURE insert_row(
1356: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1357: x_return_status OUT NOCOPY VARCHAR2,
1358: x_msg_count OUT NOCOPY NUMBER,
1359: x_msg_data OUT NOCOPY VARCHAR2,
1360: p_fpr_rec IN fpr_rec_type,

Line 1365: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1361: x_fpr_rec OUT NOCOPY fpr_rec_type) IS
1362:
1363: l_api_version CONSTANT NUMBER := 1;
1364: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1365: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1366: l_fpr_rec fpr_rec_type := p_fpr_rec;
1367: l_def_fpr_rec fpr_rec_type;
1368: -------------------------------------------
1369: -- Set_Attributes for:OKL_FNCTN_PRMTRS_B --

Line 1375: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1371: FUNCTION Set_Attributes (
1372: p_fpr_rec IN fpr_rec_type,
1373: x_fpr_rec OUT NOCOPY fpr_rec_type
1374: ) RETURN VARCHAR2 IS
1375: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1376: BEGIN
1377: x_fpr_rec := p_fpr_rec;
1378: RETURN(l_return_status);
1379: END Set_Attributes;

Line 1381: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1377: x_fpr_rec := p_fpr_rec;
1378: RETURN(l_return_status);
1379: END Set_Attributes;
1380: BEGIN
1381: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1382: p_init_msg_list,
1383: '_PVT',
1384: x_return_status);
1385: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1385: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1381: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1382: p_init_msg_list,
1383: '_PVT',
1384: x_return_status);
1385: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1386: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1387: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1388: RAISE Okc_Api.G_EXCEPTION_ERROR;
1389: END IF;

Line 1386: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1382: p_init_msg_list,
1383: '_PVT',
1384: x_return_status);
1385: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1386: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1387: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1388: RAISE Okc_Api.G_EXCEPTION_ERROR;
1389: END IF;
1390: --- Setting item attributes

Line 1387: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1383: '_PVT',
1384: x_return_status);
1385: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1386: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1387: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1388: RAISE Okc_Api.G_EXCEPTION_ERROR;
1389: END IF;
1390: --- Setting item attributes
1391: l_return_status := Set_Attributes(

Line 1388: RAISE Okc_Api.G_EXCEPTION_ERROR;

1384: x_return_status);
1385: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1386: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1387: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1388: RAISE Okc_Api.G_EXCEPTION_ERROR;
1389: END IF;
1390: --- Setting item attributes
1391: l_return_status := Set_Attributes(
1392: p_fpr_rec, -- IN

Line 1395: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1391: l_return_status := Set_Attributes(
1392: p_fpr_rec, -- IN
1393: l_fpr_rec); -- OUT
1394: --- If any errors happen abort API
1395: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1396: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1397: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1398: RAISE Okc_Api.G_EXCEPTION_ERROR;
1399: END IF;

Line 1396: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1392: p_fpr_rec, -- IN
1393: l_fpr_rec); -- OUT
1394: --- If any errors happen abort API
1395: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1396: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1397: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1398: RAISE Okc_Api.G_EXCEPTION_ERROR;
1399: END IF;
1400: INSERT INTO OKL_FNCTN_PRMTRS_B(

Line 1397: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1393: l_fpr_rec); -- OUT
1394: --- If any errors happen abort API
1395: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1396: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1397: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1398: RAISE Okc_Api.G_EXCEPTION_ERROR;
1399: END IF;
1400: INSERT INTO OKL_FNCTN_PRMTRS_B(
1401: id,

Line 1398: RAISE Okc_Api.G_EXCEPTION_ERROR;

1394: --- If any errors happen abort API
1395: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1396: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1397: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1398: RAISE Okc_Api.G_EXCEPTION_ERROR;
1399: END IF;
1400: INSERT INTO OKL_FNCTN_PRMTRS_B(
1401: id,
1402: dsf_id,

Line 1426: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1422: l_fpr_rec.last_update_date,
1423: l_fpr_rec.last_update_login);
1424: -- Set OUT values
1425: x_fpr_rec := l_fpr_rec;
1426: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1427: EXCEPTION
1428: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1429: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1430: (

Line 1428: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1424: -- Set OUT values
1425: x_fpr_rec := l_fpr_rec;
1426: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1427: EXCEPTION
1428: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1429: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1430: (
1431: l_api_name,
1432: G_PKG_NAME,

Line 1429: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1425: x_fpr_rec := l_fpr_rec;
1426: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1427: EXCEPTION
1428: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1429: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1430: (
1431: l_api_name,
1432: G_PKG_NAME,
1433: 'OKC_API.G_RET_STS_ERROR',

Line 1433: 'OKC_API.G_RET_STS_ERROR',

1429: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1430: (
1431: l_api_name,
1432: G_PKG_NAME,
1433: 'OKC_API.G_RET_STS_ERROR',
1434: x_msg_count,
1435: x_msg_data,
1436: '_PVT'
1437: );

Line 1438: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1434: x_msg_count,
1435: x_msg_data,
1436: '_PVT'
1437: );
1438: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1439:
1440: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1441: (
1442: l_api_name,

Line 1440: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1436: '_PVT'
1437: );
1438: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1439:
1440: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1441: (
1442: l_api_name,
1443: G_PKG_NAME,
1444: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1444: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1440: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1441: (
1442: l_api_name,
1443: G_PKG_NAME,
1444: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1445: x_msg_count,
1446: x_msg_data,
1447: '_PVT'
1448: );

Line 1450: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1446: x_msg_data,
1447: '_PVT'
1448: );
1449: WHEN OTHERS THEN
1450: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1451: (
1452: l_api_name,
1453: G_PKG_NAME,
1454: 'OTHERS',

Line 1464: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1460: ----------------------------------------
1461: -- insert_row for:OKL_FNCTN_PRMTRS_TL --
1462: ----------------------------------------
1463: PROCEDURE insert_row(
1464: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1465: x_return_status OUT NOCOPY VARCHAR2,
1466: x_msg_count OUT NOCOPY NUMBER,
1467: x_msg_data OUT NOCOPY VARCHAR2,
1468: p_okl_fnctn_prmtrs_tl_rec IN okl_fnctn_prmtrs_tl_rec_type,

Line 1473: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1469: x_okl_fnctn_prmtrs_tl_rec OUT NOCOPY okl_fnctn_prmtrs_tl_rec_type) IS
1470:
1471: l_api_version CONSTANT NUMBER := 1;
1472: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1473: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1474: l_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type := p_okl_fnctn_prmtrs_tl_rec;
1475: ldefoklfnctnprmtrstlrec okl_fnctn_prmtrs_tl_rec_type;
1476: CURSOR get_languages IS
1477: SELECT *

Line 1487: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1483: FUNCTION Set_Attributes (
1484: p_okl_fnctn_prmtrs_tl_rec IN okl_fnctn_prmtrs_tl_rec_type,
1485: x_okl_fnctn_prmtrs_tl_rec OUT NOCOPY okl_fnctn_prmtrs_tl_rec_type
1486: ) RETURN VARCHAR2 IS
1487: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1488: BEGIN
1489: x_okl_fnctn_prmtrs_tl_rec := p_okl_fnctn_prmtrs_tl_rec;
1490: x_okl_fnctn_prmtrs_tl_rec.LANGUAGE := USERENV('LANG');
1491: x_okl_fnctn_prmtrs_tl_rec.SOURCE_LANG := USERENV('LANG');

Line 1495: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1491: x_okl_fnctn_prmtrs_tl_rec.SOURCE_LANG := USERENV('LANG');
1492: RETURN(l_return_status);
1493: END Set_Attributes;
1494: BEGIN
1495: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1496: p_init_msg_list,
1497: '_PVT',
1498: x_return_status);
1499: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1499: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1495: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1496: p_init_msg_list,
1497: '_PVT',
1498: x_return_status);
1499: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1500: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1501: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1502: RAISE Okc_Api.G_EXCEPTION_ERROR;
1503: END IF;

Line 1500: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1496: p_init_msg_list,
1497: '_PVT',
1498: x_return_status);
1499: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1500: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1501: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1502: RAISE Okc_Api.G_EXCEPTION_ERROR;
1503: END IF;
1504: --- Setting item attributes

Line 1501: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1497: '_PVT',
1498: x_return_status);
1499: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1500: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1501: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1502: RAISE Okc_Api.G_EXCEPTION_ERROR;
1503: END IF;
1504: --- Setting item attributes
1505: l_return_status := Set_Attributes(

Line 1502: RAISE Okc_Api.G_EXCEPTION_ERROR;

1498: x_return_status);
1499: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1500: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1501: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1502: RAISE Okc_Api.G_EXCEPTION_ERROR;
1503: END IF;
1504: --- Setting item attributes
1505: l_return_status := Set_Attributes(
1506: p_okl_fnctn_prmtrs_tl_rec, -- IN

Line 1509: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1505: l_return_status := Set_Attributes(
1506: p_okl_fnctn_prmtrs_tl_rec, -- IN
1507: l_okl_fnctn_prmtrs_tl_rec); -- OUT
1508: --- If any errors happen abort API
1509: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1510: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1511: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1512: RAISE Okc_Api.G_EXCEPTION_ERROR;
1513: END IF;

Line 1510: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1506: p_okl_fnctn_prmtrs_tl_rec, -- IN
1507: l_okl_fnctn_prmtrs_tl_rec); -- OUT
1508: --- If any errors happen abort API
1509: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1510: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1511: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1512: RAISE Okc_Api.G_EXCEPTION_ERROR;
1513: END IF;
1514: FOR l_lang_rec IN get_languages LOOP

Line 1511: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1507: l_okl_fnctn_prmtrs_tl_rec); -- OUT
1508: --- If any errors happen abort API
1509: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1510: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1511: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1512: RAISE Okc_Api.G_EXCEPTION_ERROR;
1513: END IF;
1514: FOR l_lang_rec IN get_languages LOOP
1515: l_okl_fnctn_prmtrs_tl_rec.LANGUAGE := l_lang_rec.language_code;

Line 1512: RAISE Okc_Api.G_EXCEPTION_ERROR;

1508: --- If any errors happen abort API
1509: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1510: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1511: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1512: RAISE Okc_Api.G_EXCEPTION_ERROR;
1513: END IF;
1514: FOR l_lang_rec IN get_languages LOOP
1515: l_okl_fnctn_prmtrs_tl_rec.LANGUAGE := l_lang_rec.language_code;
1516: INSERT INTO OKL_FNCTN_PRMTRS_TL(

Line 1543: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1539: l_okl_fnctn_prmtrs_tl_rec.last_update_login);
1540: END LOOP;
1541: -- Set OUT values
1542: x_okl_fnctn_prmtrs_tl_rec := l_okl_fnctn_prmtrs_tl_rec;
1543: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1544: EXCEPTION
1545: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1546: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1547: (

Line 1545: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1541: -- Set OUT values
1542: x_okl_fnctn_prmtrs_tl_rec := l_okl_fnctn_prmtrs_tl_rec;
1543: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1544: EXCEPTION
1545: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1546: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1547: (
1548: l_api_name,
1549: G_PKG_NAME,

Line 1546: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1542: x_okl_fnctn_prmtrs_tl_rec := l_okl_fnctn_prmtrs_tl_rec;
1543: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1544: EXCEPTION
1545: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1546: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1547: (
1548: l_api_name,
1549: G_PKG_NAME,
1550: 'OKC_API.G_RET_STS_ERROR',

Line 1550: 'OKC_API.G_RET_STS_ERROR',

1546: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1547: (
1548: l_api_name,
1549: G_PKG_NAME,
1550: 'OKC_API.G_RET_STS_ERROR',
1551: x_msg_count,
1552: x_msg_data,
1553: '_PVT'
1554: );

Line 1555: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1556: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1552: x_msg_data,
1553: '_PVT'
1554: );
1555: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1556: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1557: (
1558: l_api_name,
1559: G_PKG_NAME,
1560: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1560: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1556: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1557: (
1558: l_api_name,
1559: G_PKG_NAME,
1560: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1561: x_msg_count,
1562: x_msg_data,
1563: '_PVT'
1564: );

Line 1566: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

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

Line 1581: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1577: -- insert_row for:OKL_FNCTN_PRMTRS_V --
1578: ---------------------------------------
1579: PROCEDURE insert_row(
1580: p_api_version IN NUMBER,
1581: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1582: x_return_status OUT NOCOPY VARCHAR2,
1583: x_msg_count OUT NOCOPY NUMBER,
1584: x_msg_data OUT NOCOPY VARCHAR2,
1585: p_fprv_rec IN fprv_rec_type,

Line 1590: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1586: x_fprv_rec OUT NOCOPY fprv_rec_type) IS
1587:
1588: l_api_version CONSTANT NUMBER := 1;
1589: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1590: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1591: l_fprv_rec fprv_rec_type;
1592: l_def_fprv_rec fprv_rec_type;
1593: l_fpr_rec fpr_rec_type;
1594: lx_fpr_rec fpr_rec_type;

Line 1619: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1615: FUNCTION Set_Attributes (
1616: p_fprv_rec IN fprv_rec_type,
1617: x_fprv_rec OUT NOCOPY fprv_rec_type
1618: ) RETURN VARCHAR2 IS
1619: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1620: BEGIN
1621: x_fprv_rec := p_fprv_rec;
1622: x_fprv_rec.OBJECT_VERSION_NUMBER := 1;
1623: x_fprv_rec.SFWT_FLAG := 'N';

Line 1627: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1623: x_fprv_rec.SFWT_FLAG := 'N';
1624: RETURN(l_return_status);
1625: END Set_Attributes;
1626: BEGIN
1627: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1628: G_PKG_NAME,
1629: p_init_msg_list,
1630: l_api_version,
1631: p_api_version,

Line 1634: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1630: l_api_version,
1631: p_api_version,
1632: '_PVT',
1633: x_return_status);
1634: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1635: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1636: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1637: RAISE Okc_Api.G_EXCEPTION_ERROR;
1638: END IF;

Line 1635: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1631: p_api_version,
1632: '_PVT',
1633: x_return_status);
1634: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1635: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1636: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1637: RAISE Okc_Api.G_EXCEPTION_ERROR;
1638: END IF;
1639: l_fprv_rec := null_out_defaults(p_fprv_rec);

Line 1636: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1632: '_PVT',
1633: x_return_status);
1634: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1635: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1636: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1637: RAISE Okc_Api.G_EXCEPTION_ERROR;
1638: END IF;
1639: l_fprv_rec := null_out_defaults(p_fprv_rec);
1640: -- Set primary key value

Line 1637: RAISE Okc_Api.G_EXCEPTION_ERROR;

1633: x_return_status);
1634: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1635: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1636: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1637: RAISE Okc_Api.G_EXCEPTION_ERROR;
1638: END IF;
1639: l_fprv_rec := null_out_defaults(p_fprv_rec);
1640: -- Set primary key value
1641: l_fprv_rec.ID := get_seq_id;

Line 1647: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1643: l_return_status := Set_Attributes(
1644: l_fprv_rec, -- IN
1645: l_def_fprv_rec); -- OUT
1646: --- If any errors happen abort API
1647: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1648: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1649: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1650: RAISE Okc_Api.G_EXCEPTION_ERROR;
1651: END IF;

Line 1648: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1644: l_fprv_rec, -- IN
1645: l_def_fprv_rec); -- OUT
1646: --- If any errors happen abort API
1647: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1648: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1649: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1650: RAISE Okc_Api.G_EXCEPTION_ERROR;
1651: END IF;
1652: l_def_fprv_rec := fill_who_columns(l_def_fprv_rec);

Line 1649: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1645: l_def_fprv_rec); -- OUT
1646: --- If any errors happen abort API
1647: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1648: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1649: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1650: RAISE Okc_Api.G_EXCEPTION_ERROR;
1651: END IF;
1652: l_def_fprv_rec := fill_who_columns(l_def_fprv_rec);
1653: --- Validate all non-missing attributes (Item Level Validation)

Line 1650: RAISE Okc_Api.G_EXCEPTION_ERROR;

1646: --- If any errors happen abort API
1647: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1648: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1649: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1650: RAISE Okc_Api.G_EXCEPTION_ERROR;
1651: END IF;
1652: l_def_fprv_rec := fill_who_columns(l_def_fprv_rec);
1653: --- Validate all non-missing attributes (Item Level Validation)
1654: l_return_status := Validate_Attributes(l_def_fprv_rec);

Line 1656: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1652: l_def_fprv_rec := fill_who_columns(l_def_fprv_rec);
1653: --- Validate all non-missing attributes (Item Level Validation)
1654: l_return_status := Validate_Attributes(l_def_fprv_rec);
1655: --- If any errors happen abort API
1656: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1657: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1658: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1659: RAISE Okc_Api.G_EXCEPTION_ERROR;
1660: END IF;

Line 1657: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1653: --- Validate all non-missing attributes (Item Level Validation)
1654: l_return_status := Validate_Attributes(l_def_fprv_rec);
1655: --- If any errors happen abort API
1656: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1657: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1658: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1659: RAISE Okc_Api.G_EXCEPTION_ERROR;
1660: END IF;
1661: l_return_status := Validate_Record(l_def_fprv_rec);

Line 1658: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1654: l_return_status := Validate_Attributes(l_def_fprv_rec);
1655: --- If any errors happen abort API
1656: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1657: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1658: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1659: RAISE Okc_Api.G_EXCEPTION_ERROR;
1660: END IF;
1661: l_return_status := Validate_Record(l_def_fprv_rec);
1662: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1659: RAISE Okc_Api.G_EXCEPTION_ERROR;

1655: --- If any errors happen abort API
1656: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1657: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1658: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1659: RAISE Okc_Api.G_EXCEPTION_ERROR;
1660: END IF;
1661: l_return_status := Validate_Record(l_def_fprv_rec);
1662: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1663: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1662: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1658: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1659: RAISE Okc_Api.G_EXCEPTION_ERROR;
1660: END IF;
1661: l_return_status := Validate_Record(l_def_fprv_rec);
1662: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1663: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1664: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1665: RAISE Okc_Api.G_EXCEPTION_ERROR;
1666: END IF;

Line 1663: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1659: RAISE Okc_Api.G_EXCEPTION_ERROR;
1660: END IF;
1661: l_return_status := Validate_Record(l_def_fprv_rec);
1662: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1663: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1664: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1665: RAISE Okc_Api.G_EXCEPTION_ERROR;
1666: END IF;
1667: --------------------------------------

Line 1664: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1660: END IF;
1661: l_return_status := Validate_Record(l_def_fprv_rec);
1662: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1663: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1664: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1665: RAISE Okc_Api.G_EXCEPTION_ERROR;
1666: END IF;
1667: --------------------------------------
1668: -- Move VIEW record to "Child" records

Line 1665: RAISE Okc_Api.G_EXCEPTION_ERROR;

1661: l_return_status := Validate_Record(l_def_fprv_rec);
1662: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1663: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1664: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1665: RAISE Okc_Api.G_EXCEPTION_ERROR;
1666: END IF;
1667: --------------------------------------
1668: -- Move VIEW record to "Child" records
1669: --------------------------------------

Line 1683: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1679: x_msg_data,
1680: l_fpr_rec,
1681: lx_fpr_rec
1682: );
1683: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1684: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1685: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1686: RAISE Okc_Api.G_EXCEPTION_ERROR;
1687: END IF;

Line 1684: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1680: l_fpr_rec,
1681: lx_fpr_rec
1682: );
1683: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1684: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1685: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1686: RAISE Okc_Api.G_EXCEPTION_ERROR;
1687: END IF;
1688: migrate(lx_fpr_rec, l_def_fprv_rec);

Line 1685: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1681: lx_fpr_rec
1682: );
1683: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1684: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1685: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1686: RAISE Okc_Api.G_EXCEPTION_ERROR;
1687: END IF;
1688: migrate(lx_fpr_rec, l_def_fprv_rec);
1689: insert_row(

Line 1686: RAISE Okc_Api.G_EXCEPTION_ERROR;

1682: );
1683: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1684: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1685: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1686: RAISE Okc_Api.G_EXCEPTION_ERROR;
1687: END IF;
1688: migrate(lx_fpr_rec, l_def_fprv_rec);
1689: insert_row(
1690: p_init_msg_list,

Line 1697: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1693: x_msg_data,
1694: l_okl_fnctn_prmtrs_tl_rec,
1695: lx_okl_fnctn_prmtrs_tl_rec
1696: );
1697: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1698: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1699: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1700: RAISE Okc_Api.G_EXCEPTION_ERROR;
1701: END IF;

Line 1698: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1694: l_okl_fnctn_prmtrs_tl_rec,
1695: lx_okl_fnctn_prmtrs_tl_rec
1696: );
1697: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1698: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1699: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1700: RAISE Okc_Api.G_EXCEPTION_ERROR;
1701: END IF;
1702: migrate(lx_okl_fnctn_prmtrs_tl_rec, l_def_fprv_rec);

Line 1699: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1695: lx_okl_fnctn_prmtrs_tl_rec
1696: );
1697: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1698: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1699: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1700: RAISE Okc_Api.G_EXCEPTION_ERROR;
1701: END IF;
1702: migrate(lx_okl_fnctn_prmtrs_tl_rec, l_def_fprv_rec);
1703: -- Set OUT values

Line 1700: RAISE Okc_Api.G_EXCEPTION_ERROR;

1696: );
1697: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1698: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1699: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1700: RAISE Okc_Api.G_EXCEPTION_ERROR;
1701: END IF;
1702: migrate(lx_okl_fnctn_prmtrs_tl_rec, l_def_fprv_rec);
1703: -- Set OUT values
1704: x_fprv_rec := l_def_fprv_rec;

Line 1705: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1701: END IF;
1702: migrate(lx_okl_fnctn_prmtrs_tl_rec, l_def_fprv_rec);
1703: -- Set OUT values
1704: x_fprv_rec := l_def_fprv_rec;
1705: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1706: EXCEPTION
1707: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1708: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1709: (

Line 1707: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1703: -- Set OUT values
1704: x_fprv_rec := l_def_fprv_rec;
1705: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1706: EXCEPTION
1707: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1708: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1709: (
1710: l_api_name,
1711: G_PKG_NAME,

Line 1708: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1704: x_fprv_rec := l_def_fprv_rec;
1705: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1706: EXCEPTION
1707: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1708: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1709: (
1710: l_api_name,
1711: G_PKG_NAME,
1712: 'OKC_API.G_RET_STS_ERROR',

Line 1712: 'OKC_API.G_RET_STS_ERROR',

1708: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1709: (
1710: l_api_name,
1711: G_PKG_NAME,
1712: 'OKC_API.G_RET_STS_ERROR',
1713: x_msg_count,
1714: x_msg_data,
1715: '_PVT'
1716: );

Line 1717: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1718: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1714: x_msg_data,
1715: '_PVT'
1716: );
1717: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1718: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1719: (
1720: l_api_name,
1721: G_PKG_NAME,
1722: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1722: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1718: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1719: (
1720: l_api_name,
1721: G_PKG_NAME,
1722: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1723: x_msg_count,
1724: x_msg_data,
1725: '_PVT'
1726: );

Line 1728: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1724: x_msg_data,
1725: '_PVT'
1726: );
1727: WHEN OTHERS THEN
1728: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1729: (
1730: l_api_name,
1731: G_PKG_NAME,
1732: 'OTHERS',

Line 1743: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1739: -- PL/SQL TBL insert_row for:FPRV_TBL --
1740: ----------------------------------------
1741: PROCEDURE insert_row(
1742: p_api_version IN NUMBER,
1743: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1744: x_return_status OUT NOCOPY VARCHAR2,
1745: x_msg_count OUT NOCOPY NUMBER,
1746: x_msg_data OUT NOCOPY VARCHAR2,
1747: p_fprv_tbl IN fprv_tbl_type,

Line 1752: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1748: x_fprv_tbl OUT NOCOPY fprv_tbl_type) IS
1749:
1750: l_api_version CONSTANT NUMBER := 1;
1751: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1752: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1753: i NUMBER := 0;
1754: -- START change : mvasudev, 05/15/2001
1755: -- Adding OverAll Status Flag
1756: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 1756: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1752: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1753: i NUMBER := 0;
1754: -- START change : mvasudev, 05/15/2001
1755: -- Adding OverAll Status Flag
1756: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1757: -- END change : mvasudev
1758: BEGIN
1759: Okc_Api.init_msg_list(p_init_msg_list);
1760: -- Make sure PL/SQL table has records in it before passing

Line 1759: Okc_Api.init_msg_list(p_init_msg_list);

1755: -- Adding OverAll Status Flag
1756: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1757: -- END change : mvasudev
1758: BEGIN
1759: Okc_Api.init_msg_list(p_init_msg_list);
1760: -- Make sure PL/SQL table has records in it before passing
1761: IF (p_fprv_tbl.COUNT > 0) THEN
1762: i := p_fprv_tbl.FIRST;
1763: LOOP

Line 1766: p_init_msg_list => Okc_Api.G_FALSE,

1762: i := p_fprv_tbl.FIRST;
1763: LOOP
1764: insert_row (
1765: p_api_version => p_api_version,
1766: p_init_msg_list => Okc_Api.G_FALSE,
1767: x_return_status => x_return_status,
1768: x_msg_count => x_msg_count,
1769: x_msg_data => x_msg_data,
1770: p_fprv_rec => p_fprv_tbl(i),

Line 1774: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

1770: p_fprv_rec => p_fprv_tbl(i),
1771: x_fprv_rec => x_fprv_tbl(i));
1772: -- START change : mvasudev, 05/15/2001
1773: -- store the highest degree of error
1774: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1775: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1776: l_overall_status := x_return_status;
1777: END IF;
1778: END IF;

Line 1775: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

1771: x_fprv_rec => x_fprv_tbl(i));
1772: -- START change : mvasudev, 05/15/2001
1773: -- store the highest degree of error
1774: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
1775: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
1776: l_overall_status := x_return_status;
1777: END IF;
1778: END IF;
1779: -- END change : mvasudev

Line 1789: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1785: x_return_status := l_overall_status;
1786: -- END change : mvasudev
1787: END IF;
1788: EXCEPTION
1789: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1790: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1791: (
1792: l_api_name,
1793: G_PKG_NAME,

Line 1790: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1786: -- END change : mvasudev
1787: END IF;
1788: EXCEPTION
1789: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1790: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1791: (
1792: l_api_name,
1793: G_PKG_NAME,
1794: 'OKC_API.G_RET_STS_ERROR',

Line 1794: 'OKC_API.G_RET_STS_ERROR',

1790: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1791: (
1792: l_api_name,
1793: G_PKG_NAME,
1794: 'OKC_API.G_RET_STS_ERROR',
1795: x_msg_count,
1796: x_msg_data,
1797: '_PVT'
1798: );

Line 1799: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1795: x_msg_count,
1796: x_msg_data,
1797: '_PVT'
1798: );
1799: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1800: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1801: (
1802: l_api_name,
1803: G_PKG_NAME,

Line 1800: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1796: x_msg_data,
1797: '_PVT'
1798: );
1799: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1800: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1801: (
1802: l_api_name,
1803: G_PKG_NAME,
1804: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1804: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1800: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1801: (
1802: l_api_name,
1803: G_PKG_NAME,
1804: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1805: x_msg_count,
1806: x_msg_data,
1807: '_PVT'
1808: );

Line 1810: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

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

Line 1828: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1824: -------------------------------------
1825: -- lock_row for:OKL_FNCTN_PRMTRS_B --
1826: -------------------------------------
1827: PROCEDURE lock_row(
1828: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1829: x_return_status OUT NOCOPY VARCHAR2,
1830: x_msg_count OUT NOCOPY NUMBER,
1831: x_msg_data OUT NOCOPY VARCHAR2,
1832: p_fpr_rec IN fpr_rec_type) IS

Line 1849: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1845: FROM OKL_FNCTN_PRMTRS_B
1846: WHERE ID = p_fpr_rec.id;
1847: l_api_version CONSTANT NUMBER := 1;
1848: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1849: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1850: l_object_version_number OKL_FNCTN_PRMTRS_B.OBJECT_VERSION_NUMBER%TYPE;
1851: lc_object_version_number OKL_FNCTN_PRMTRS_B.OBJECT_VERSION_NUMBER%TYPE;
1852: l_row_notfound BOOLEAN := FALSE;
1853: lc_row_notfound BOOLEAN := FALSE;

Line 1855: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1851: lc_object_version_number OKL_FNCTN_PRMTRS_B.OBJECT_VERSION_NUMBER%TYPE;
1852: l_row_notfound BOOLEAN := FALSE;
1853: lc_row_notfound BOOLEAN := FALSE;
1854: BEGIN
1855: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1856: p_init_msg_list,
1857: '_PVT',
1858: x_return_status);
1859: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1859: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1855: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1856: p_init_msg_list,
1857: '_PVT',
1858: x_return_status);
1859: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1860: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1861: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1862: RAISE Okc_Api.G_EXCEPTION_ERROR;
1863: END IF;

Line 1860: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1856: p_init_msg_list,
1857: '_PVT',
1858: x_return_status);
1859: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1860: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1861: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1862: RAISE Okc_Api.G_EXCEPTION_ERROR;
1863: END IF;
1864: BEGIN

Line 1861: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1857: '_PVT',
1858: x_return_status);
1859: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1860: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1861: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1862: RAISE Okc_Api.G_EXCEPTION_ERROR;
1863: END IF;
1864: BEGIN
1865: OPEN lock_csr(p_fpr_rec);

Line 1862: RAISE Okc_Api.G_EXCEPTION_ERROR;

1858: x_return_status);
1859: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1860: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1861: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1862: RAISE Okc_Api.G_EXCEPTION_ERROR;
1863: END IF;
1864: BEGIN
1865: OPEN lock_csr(p_fpr_rec);
1866: FETCH lock_csr INTO l_object_version_number;

Line 1874: Okc_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1870: WHEN E_Resource_Busy THEN
1871: IF (lock_csr%ISOPEN) THEN
1872: CLOSE lock_csr;
1873: END IF;
1874: Okc_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1875: RAISE App_Exceptions.RECORD_LOCK_EXCEPTION;
1876: END;
1877:
1878: IF ( l_row_notfound ) THEN

Line 1885: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1881: lc_row_notfound := lchk_csr%NOTFOUND;
1882: CLOSE lchk_csr;
1883: END IF;
1884: IF (lc_row_notfound) THEN
1885: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1886: RAISE Okc_Api.G_EXCEPTION_ERROR;
1887: ELSIF lc_object_version_number > p_fpr_rec.object_version_number THEN
1888: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1889: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 1886: RAISE Okc_Api.G_EXCEPTION_ERROR;

1882: CLOSE lchk_csr;
1883: END IF;
1884: IF (lc_row_notfound) THEN
1885: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1886: RAISE Okc_Api.G_EXCEPTION_ERROR;
1887: ELSIF lc_object_version_number > p_fpr_rec.object_version_number THEN
1888: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1889: RAISE Okc_Api.G_EXCEPTION_ERROR;
1890: ELSIF lc_object_version_number <> p_fpr_rec.object_version_number THEN

Line 1888: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1884: IF (lc_row_notfound) THEN
1885: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1886: RAISE Okc_Api.G_EXCEPTION_ERROR;
1887: ELSIF lc_object_version_number > p_fpr_rec.object_version_number THEN
1888: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1889: RAISE Okc_Api.G_EXCEPTION_ERROR;
1890: ELSIF lc_object_version_number <> p_fpr_rec.object_version_number THEN
1891: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1892: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 1889: RAISE Okc_Api.G_EXCEPTION_ERROR;

1885: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1886: RAISE Okc_Api.G_EXCEPTION_ERROR;
1887: ELSIF lc_object_version_number > p_fpr_rec.object_version_number THEN
1888: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1889: RAISE Okc_Api.G_EXCEPTION_ERROR;
1890: ELSIF lc_object_version_number <> p_fpr_rec.object_version_number THEN
1891: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1892: RAISE Okc_Api.G_EXCEPTION_ERROR;
1893: ELSIF lc_object_version_number = -1 THEN

Line 1891: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1887: ELSIF lc_object_version_number > p_fpr_rec.object_version_number THEN
1888: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1889: RAISE Okc_Api.G_EXCEPTION_ERROR;
1890: ELSIF lc_object_version_number <> p_fpr_rec.object_version_number THEN
1891: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1892: RAISE Okc_Api.G_EXCEPTION_ERROR;
1893: ELSIF lc_object_version_number = -1 THEN
1894: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1895: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 1892: RAISE Okc_Api.G_EXCEPTION_ERROR;

1888: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1889: RAISE Okc_Api.G_EXCEPTION_ERROR;
1890: ELSIF lc_object_version_number <> p_fpr_rec.object_version_number THEN
1891: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1892: RAISE Okc_Api.G_EXCEPTION_ERROR;
1893: ELSIF lc_object_version_number = -1 THEN
1894: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1895: RAISE Okc_Api.G_EXCEPTION_ERROR;
1896: END IF;

Line 1894: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1890: ELSIF lc_object_version_number <> p_fpr_rec.object_version_number THEN
1891: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1892: RAISE Okc_Api.G_EXCEPTION_ERROR;
1893: ELSIF lc_object_version_number = -1 THEN
1894: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1895: RAISE Okc_Api.G_EXCEPTION_ERROR;
1896: END IF;
1897: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1898: EXCEPTION

Line 1895: RAISE Okc_Api.G_EXCEPTION_ERROR;

1891: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1892: RAISE Okc_Api.G_EXCEPTION_ERROR;
1893: ELSIF lc_object_version_number = -1 THEN
1894: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1895: RAISE Okc_Api.G_EXCEPTION_ERROR;
1896: END IF;
1897: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1898: EXCEPTION
1899: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 1897: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1893: ELSIF lc_object_version_number = -1 THEN
1894: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1895: RAISE Okc_Api.G_EXCEPTION_ERROR;
1896: END IF;
1897: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1898: EXCEPTION
1899: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1900: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1901: (

Line 1899: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1895: RAISE Okc_Api.G_EXCEPTION_ERROR;
1896: END IF;
1897: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1898: EXCEPTION
1899: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1900: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1901: (
1902: l_api_name,
1903: G_PKG_NAME,

Line 1900: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1896: END IF;
1897: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1898: EXCEPTION
1899: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1900: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1901: (
1902: l_api_name,
1903: G_PKG_NAME,
1904: 'OKC_API.G_RET_STS_ERROR',

Line 1904: 'OKC_API.G_RET_STS_ERROR',

1900: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1901: (
1902: l_api_name,
1903: G_PKG_NAME,
1904: 'OKC_API.G_RET_STS_ERROR',
1905: x_msg_count,
1906: x_msg_data,
1907: '_PVT'
1908: );

Line 1909: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1905: x_msg_count,
1906: x_msg_data,
1907: '_PVT'
1908: );
1909: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1910: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1911: (
1912: l_api_name,
1913: G_PKG_NAME,

Line 1910: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1906: x_msg_data,
1907: '_PVT'
1908: );
1909: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1910: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1911: (
1912: l_api_name,
1913: G_PKG_NAME,
1914: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1914: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1910: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1911: (
1912: l_api_name,
1913: G_PKG_NAME,
1914: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1915: x_msg_count,
1916: x_msg_data,
1917: '_PVT'
1918: );

Line 1920: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1916: x_msg_data,
1917: '_PVT'
1918: );
1919: WHEN OTHERS THEN
1920: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1921: (
1922: l_api_name,
1923: G_PKG_NAME,
1924: 'OTHERS',

Line 1934: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1930: --------------------------------------
1931: -- lock_row for:OKL_FNCTN_PRMTRS_TL --
1932: --------------------------------------
1933: PROCEDURE lock_row(
1934: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1935: x_return_status OUT NOCOPY VARCHAR2,
1936: x_msg_count OUT NOCOPY NUMBER,
1937: x_msg_data OUT NOCOPY VARCHAR2,
1938: p_okl_fnctn_prmtrs_tl_rec IN okl_fnctn_prmtrs_tl_rec_type) IS

Line 1950: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1946: FOR UPDATE NOWAIT;
1947:
1948: l_api_version CONSTANT NUMBER := 1;
1949: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';
1950: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1951: l_lock_var lock_csr%ROWTYPE;
1952: l_row_notfound BOOLEAN := FALSE;
1953: lc_row_notfound BOOLEAN := FALSE;
1954: BEGIN

Line 1955: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1951: l_lock_var lock_csr%ROWTYPE;
1952: l_row_notfound BOOLEAN := FALSE;
1953: lc_row_notfound BOOLEAN := FALSE;
1954: BEGIN
1955: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1956: p_init_msg_list,
1957: '_PVT',
1958: x_return_status);
1959: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1959: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1955: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1956: p_init_msg_list,
1957: '_PVT',
1958: x_return_status);
1959: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1960: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1961: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1962: RAISE Okc_Api.G_EXCEPTION_ERROR;
1963: END IF;

Line 1960: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1956: p_init_msg_list,
1957: '_PVT',
1958: x_return_status);
1959: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1960: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1961: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1962: RAISE Okc_Api.G_EXCEPTION_ERROR;
1963: END IF;
1964: BEGIN

Line 1961: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1957: '_PVT',
1958: x_return_status);
1959: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1960: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1961: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1962: RAISE Okc_Api.G_EXCEPTION_ERROR;
1963: END IF;
1964: BEGIN
1965: OPEN lock_csr(p_okl_fnctn_prmtrs_tl_rec);

Line 1962: RAISE Okc_Api.G_EXCEPTION_ERROR;

1958: x_return_status);
1959: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1960: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1961: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1962: RAISE Okc_Api.G_EXCEPTION_ERROR;
1963: END IF;
1964: BEGIN
1965: OPEN lock_csr(p_okl_fnctn_prmtrs_tl_rec);
1966: FETCH lock_csr INTO l_lock_var;

Line 1974: Okc_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1970: WHEN E_Resource_Busy THEN
1971: IF (lock_csr%ISOPEN) THEN
1972: CLOSE lock_csr;
1973: END IF;
1974: Okc_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1975: RAISE App_Exceptions.RECORD_LOCK_EXCEPTION;
1976: END;
1977:
1978: IF ( l_row_notfound ) THEN

Line 1979: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1975: RAISE App_Exceptions.RECORD_LOCK_EXCEPTION;
1976: END;
1977:
1978: IF ( l_row_notfound ) THEN
1979: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1980: RAISE Okc_Api.G_EXCEPTION_ERROR;
1981: END IF;
1982: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1983: EXCEPTION

Line 1980: RAISE Okc_Api.G_EXCEPTION_ERROR;

1976: END;
1977:
1978: IF ( l_row_notfound ) THEN
1979: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1980: RAISE Okc_Api.G_EXCEPTION_ERROR;
1981: END IF;
1982: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1983: EXCEPTION
1984: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 1982: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1978: IF ( l_row_notfound ) THEN
1979: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1980: RAISE Okc_Api.G_EXCEPTION_ERROR;
1981: END IF;
1982: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1983: EXCEPTION
1984: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1985: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1986: (

Line 1984: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1980: RAISE Okc_Api.G_EXCEPTION_ERROR;
1981: END IF;
1982: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1983: EXCEPTION
1984: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1985: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1986: (
1987: l_api_name,
1988: G_PKG_NAME,

Line 1985: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1981: END IF;
1982: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1983: EXCEPTION
1984: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1985: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1986: (
1987: l_api_name,
1988: G_PKG_NAME,
1989: 'OKC_API.G_RET_STS_ERROR',

Line 1989: 'OKC_API.G_RET_STS_ERROR',

1985: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1986: (
1987: l_api_name,
1988: G_PKG_NAME,
1989: 'OKC_API.G_RET_STS_ERROR',
1990: x_msg_count,
1991: x_msg_data,
1992: '_PVT'
1993: );

Line 1994: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1995: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1991: x_msg_data,
1992: '_PVT'
1993: );
1994: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1995: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1996: (
1997: l_api_name,
1998: G_PKG_NAME,
1999: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1999: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1995: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1996: (
1997: l_api_name,
1998: G_PKG_NAME,
1999: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2000: x_msg_count,
2001: x_msg_data,
2002: '_PVT'
2003: );

Line 2005: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

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

Line 2020: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2016: -- lock_row for:OKL_FNCTN_PRMTRS_V --
2017: -------------------------------------
2018: PROCEDURE lock_row(
2019: p_api_version IN NUMBER,
2020: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2021: x_return_status OUT NOCOPY VARCHAR2,
2022: x_msg_count OUT NOCOPY NUMBER,
2023: x_msg_data OUT NOCOPY VARCHAR2,
2024: p_fprv_rec IN fprv_rec_type) IS

Line 2028: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2024: p_fprv_rec IN fprv_rec_type) IS
2025:
2026: l_api_version CONSTANT NUMBER := 1;
2027: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2028: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2029: l_fpr_rec fpr_rec_type;
2030: l_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type;
2031: BEGIN
2032: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 2032: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

2028: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2029: l_fpr_rec fpr_rec_type;
2030: l_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type;
2031: BEGIN
2032: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2033: G_PKG_NAME,
2034: p_init_msg_list,
2035: l_api_version,
2036: p_api_version,

Line 2039: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2035: l_api_version,
2036: p_api_version,
2037: '_PVT',
2038: x_return_status);
2039: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2040: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2041: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2042: RAISE Okc_Api.G_EXCEPTION_ERROR;
2043: END IF;

Line 2040: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2036: p_api_version,
2037: '_PVT',
2038: x_return_status);
2039: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2040: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2041: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2042: RAISE Okc_Api.G_EXCEPTION_ERROR;
2043: END IF;
2044: --------------------------------------

Line 2041: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2037: '_PVT',
2038: x_return_status);
2039: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2040: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2041: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2042: RAISE Okc_Api.G_EXCEPTION_ERROR;
2043: END IF;
2044: --------------------------------------
2045: -- Move VIEW record to "Child" records

Line 2042: RAISE Okc_Api.G_EXCEPTION_ERROR;

2038: x_return_status);
2039: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2040: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2041: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2042: RAISE Okc_Api.G_EXCEPTION_ERROR;
2043: END IF;
2044: --------------------------------------
2045: -- Move VIEW record to "Child" records
2046: --------------------------------------

Line 2059: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2055: x_msg_count,
2056: x_msg_data,
2057: l_fpr_rec
2058: );
2059: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2060: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2061: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2062: RAISE Okc_Api.G_EXCEPTION_ERROR;
2063: END IF;

Line 2060: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2056: x_msg_data,
2057: l_fpr_rec
2058: );
2059: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2060: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2061: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2062: RAISE Okc_Api.G_EXCEPTION_ERROR;
2063: END IF;
2064: lock_row(

Line 2061: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2057: l_fpr_rec
2058: );
2059: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2060: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2061: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2062: RAISE Okc_Api.G_EXCEPTION_ERROR;
2063: END IF;
2064: lock_row(
2065: p_init_msg_list,

Line 2062: RAISE Okc_Api.G_EXCEPTION_ERROR;

2058: );
2059: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2060: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2061: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2062: RAISE Okc_Api.G_EXCEPTION_ERROR;
2063: END IF;
2064: lock_row(
2065: p_init_msg_list,
2066: x_return_status,

Line 2071: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2067: x_msg_count,
2068: x_msg_data,
2069: l_okl_fnctn_prmtrs_tl_rec
2070: );
2071: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2072: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2073: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2074: RAISE Okc_Api.G_EXCEPTION_ERROR;
2075: END IF;

Line 2072: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2068: x_msg_data,
2069: l_okl_fnctn_prmtrs_tl_rec
2070: );
2071: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2072: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2073: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2074: RAISE Okc_Api.G_EXCEPTION_ERROR;
2075: END IF;
2076: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2073: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2069: l_okl_fnctn_prmtrs_tl_rec
2070: );
2071: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2072: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2073: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2074: RAISE Okc_Api.G_EXCEPTION_ERROR;
2075: END IF;
2076: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2077: EXCEPTION

Line 2074: RAISE Okc_Api.G_EXCEPTION_ERROR;

2070: );
2071: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2072: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2073: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2074: RAISE Okc_Api.G_EXCEPTION_ERROR;
2075: END IF;
2076: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2077: EXCEPTION
2078: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 2076: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2072: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2073: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2074: RAISE Okc_Api.G_EXCEPTION_ERROR;
2075: END IF;
2076: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2077: EXCEPTION
2078: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2079: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2080: (

Line 2078: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2074: RAISE Okc_Api.G_EXCEPTION_ERROR;
2075: END IF;
2076: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2077: EXCEPTION
2078: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2079: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2080: (
2081: l_api_name,
2082: G_PKG_NAME,

Line 2079: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 2083: 'OKC_API.G_RET_STS_ERROR',

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

Line 2088: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2089: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

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

Line 2093: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 2099: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

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

Line 2114: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2110: -- PL/SQL TBL lock_row for:FPRV_TBL --
2111: --------------------------------------
2112: PROCEDURE lock_row(
2113: p_api_version IN NUMBER,
2114: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2115: x_return_status OUT NOCOPY VARCHAR2,
2116: x_msg_count OUT NOCOPY NUMBER,
2117: x_msg_data OUT NOCOPY VARCHAR2,
2118: p_fprv_tbl IN fprv_tbl_type) IS

Line 2122: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2118: p_fprv_tbl IN fprv_tbl_type) IS
2119:
2120: l_api_version CONSTANT NUMBER := 1;
2121: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2122: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2123: i NUMBER := 0;
2124: -- START change : mvasudev, 05/15/2001
2125: -- Adding OverAll Status Flag
2126: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2126: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2122: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2123: i NUMBER := 0;
2124: -- START change : mvasudev, 05/15/2001
2125: -- Adding OverAll Status Flag
2126: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2127: -- END change : mvasudev
2128: BEGIN
2129: Okc_Api.init_msg_list(p_init_msg_list);
2130: -- Make sure PL/SQL table has records in it before passing

Line 2129: Okc_Api.init_msg_list(p_init_msg_list);

2125: -- Adding OverAll Status Flag
2126: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2127: -- END change : mvasudev
2128: BEGIN
2129: Okc_Api.init_msg_list(p_init_msg_list);
2130: -- Make sure PL/SQL table has records in it before passing
2131: IF (p_fprv_tbl.COUNT > 0) THEN
2132: i := p_fprv_tbl.FIRST;
2133: LOOP

Line 2136: p_init_msg_list => Okc_Api.G_FALSE,

2132: i := p_fprv_tbl.FIRST;
2133: LOOP
2134: lock_row (
2135: p_api_version => p_api_version,
2136: p_init_msg_list => Okc_Api.G_FALSE,
2137: x_return_status => x_return_status,
2138: x_msg_count => x_msg_count,
2139: x_msg_data => x_msg_data,
2140: p_fprv_rec => p_fprv_tbl(i));

Line 2143: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

2139: x_msg_data => x_msg_data,
2140: p_fprv_rec => p_fprv_tbl(i));
2141: -- START change : mvasudev, 05/15/2001
2142: -- store the highest degree of error
2143: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2144: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2145: l_overall_status := x_return_status;
2146: END IF;
2147: END IF;

Line 2144: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

2140: p_fprv_rec => p_fprv_tbl(i));
2141: -- START change : mvasudev, 05/15/2001
2142: -- store the highest degree of error
2143: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2144: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2145: l_overall_status := x_return_status;
2146: END IF;
2147: END IF;
2148: -- END change : mvasudev

Line 2158: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2154: x_return_status := l_overall_status;
2155: -- END change : mvasudev
2156: END IF;
2157: EXCEPTION
2158: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2159: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2160: (
2161: l_api_name,
2162: G_PKG_NAME,

Line 2159: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2155: -- END change : mvasudev
2156: END IF;
2157: EXCEPTION
2158: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2159: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2160: (
2161: l_api_name,
2162: G_PKG_NAME,
2163: 'OKC_API.G_RET_STS_ERROR',

Line 2163: 'OKC_API.G_RET_STS_ERROR',

2159: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2160: (
2161: l_api_name,
2162: G_PKG_NAME,
2163: 'OKC_API.G_RET_STS_ERROR',
2164: x_msg_count,
2165: x_msg_data,
2166: '_PVT'
2167: );

Line 2168: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2164: x_msg_count,
2165: x_msg_data,
2166: '_PVT'
2167: );
2168: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2169: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2170: (
2171: l_api_name,
2172: G_PKG_NAME,

Line 2169: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2165: x_msg_data,
2166: '_PVT'
2167: );
2168: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2169: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2170: (
2171: l_api_name,
2172: G_PKG_NAME,
2173: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2173: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2169: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2170: (
2171: l_api_name,
2172: G_PKG_NAME,
2173: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2174: x_msg_count,
2175: x_msg_data,
2176: '_PVT'
2177: );

Line 2179: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2175: x_msg_data,
2176: '_PVT'
2177: );
2178: WHEN OTHERS THEN
2179: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2180: (
2181: l_api_name,
2182: G_PKG_NAME,
2183: 'OTHERS',

Line 2197: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2193: ---------------------------------------
2194: -- update_row for:OKL_FNCTN_PRMTRS_B --
2195: ---------------------------------------
2196: PROCEDURE update_row(
2197: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2198: x_return_status OUT NOCOPY VARCHAR2,
2199: x_msg_count OUT NOCOPY NUMBER,
2200: x_msg_data OUT NOCOPY VARCHAR2,
2201: p_fpr_rec IN fpr_rec_type,

Line 2206: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2202: x_fpr_rec OUT NOCOPY fpr_rec_type) IS
2203:
2204: l_api_version CONSTANT NUMBER := 1;
2205: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
2206: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2207: l_fpr_rec fpr_rec_type := p_fpr_rec;
2208: l_def_fpr_rec fpr_rec_type;
2209: l_row_notfound BOOLEAN := TRUE;
2210: ----------------------------------

Line 2219: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2215: x_fpr_rec OUT NOCOPY fpr_rec_type
2216: ) RETURN VARCHAR2 IS
2217: l_fpr_rec fpr_rec_type;
2218: l_row_notfound BOOLEAN := TRUE;
2219: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2220: BEGIN
2221: x_fpr_rec := p_fpr_rec;
2222: -- Get current database values
2223: l_fpr_rec := get_rec(p_fpr_rec, l_row_notfound);

Line 2225: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

2221: x_fpr_rec := p_fpr_rec;
2222: -- Get current database values
2223: l_fpr_rec := get_rec(p_fpr_rec, l_row_notfound);
2224: IF (l_row_notfound) THEN
2225: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2226: END IF;
2227: IF (x_fpr_rec.id = Okc_Api.G_MISS_NUM)
2228: THEN
2229: x_fpr_rec.id := l_fpr_rec.id;

Line 2227: IF (x_fpr_rec.id = Okc_Api.G_MISS_NUM)

2223: l_fpr_rec := get_rec(p_fpr_rec, l_row_notfound);
2224: IF (l_row_notfound) THEN
2225: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2226: END IF;
2227: IF (x_fpr_rec.id = Okc_Api.G_MISS_NUM)
2228: THEN
2229: x_fpr_rec.id := l_fpr_rec.id;
2230: END IF;
2231: IF (x_fpr_rec.dsf_id = Okc_Api.G_MISS_NUM)

Line 2231: IF (x_fpr_rec.dsf_id = Okc_Api.G_MISS_NUM)

2227: IF (x_fpr_rec.id = Okc_Api.G_MISS_NUM)
2228: THEN
2229: x_fpr_rec.id := l_fpr_rec.id;
2230: END IF;
2231: IF (x_fpr_rec.dsf_id = Okc_Api.G_MISS_NUM)
2232: THEN
2233: x_fpr_rec.dsf_id := l_fpr_rec.dsf_id;
2234: END IF;
2235: IF (x_fpr_rec.pmr_id = Okc_Api.G_MISS_NUM)

Line 2235: IF (x_fpr_rec.pmr_id = Okc_Api.G_MISS_NUM)

2231: IF (x_fpr_rec.dsf_id = Okc_Api.G_MISS_NUM)
2232: THEN
2233: x_fpr_rec.dsf_id := l_fpr_rec.dsf_id;
2234: END IF;
2235: IF (x_fpr_rec.pmr_id = Okc_Api.G_MISS_NUM)
2236: THEN
2237: x_fpr_rec.pmr_id := l_fpr_rec.pmr_id;
2238: END IF;
2239: IF (x_fpr_rec.fpr_type = Okc_Api.G_MISS_CHAR)

Line 2239: IF (x_fpr_rec.fpr_type = Okc_Api.G_MISS_CHAR)

2235: IF (x_fpr_rec.pmr_id = Okc_Api.G_MISS_NUM)
2236: THEN
2237: x_fpr_rec.pmr_id := l_fpr_rec.pmr_id;
2238: END IF;
2239: IF (x_fpr_rec.fpr_type = Okc_Api.G_MISS_CHAR)
2240: THEN
2241: x_fpr_rec.fpr_type := l_fpr_rec.fpr_type;
2242: END IF;
2243: IF (x_fpr_rec.object_version_number = Okc_Api.G_MISS_NUM)

Line 2243: IF (x_fpr_rec.object_version_number = Okc_Api.G_MISS_NUM)

2239: IF (x_fpr_rec.fpr_type = Okc_Api.G_MISS_CHAR)
2240: THEN
2241: x_fpr_rec.fpr_type := l_fpr_rec.fpr_type;
2242: END IF;
2243: IF (x_fpr_rec.object_version_number = Okc_Api.G_MISS_NUM)
2244: THEN
2245: x_fpr_rec.object_version_number := l_fpr_rec.object_version_number;
2246: END IF;
2247: IF (x_fpr_rec.sequence_number = Okc_Api.G_MISS_NUM)

Line 2247: IF (x_fpr_rec.sequence_number = Okc_Api.G_MISS_NUM)

2243: IF (x_fpr_rec.object_version_number = Okc_Api.G_MISS_NUM)
2244: THEN
2245: x_fpr_rec.object_version_number := l_fpr_rec.object_version_number;
2246: END IF;
2247: IF (x_fpr_rec.sequence_number = Okc_Api.G_MISS_NUM)
2248: THEN
2249: x_fpr_rec.sequence_number := l_fpr_rec.sequence_number;
2250: END IF;
2251: IF (x_fpr_rec.created_by = Okc_Api.G_MISS_NUM)

Line 2251: IF (x_fpr_rec.created_by = Okc_Api.G_MISS_NUM)

2247: IF (x_fpr_rec.sequence_number = Okc_Api.G_MISS_NUM)
2248: THEN
2249: x_fpr_rec.sequence_number := l_fpr_rec.sequence_number;
2250: END IF;
2251: IF (x_fpr_rec.created_by = Okc_Api.G_MISS_NUM)
2252: THEN
2253: x_fpr_rec.created_by := l_fpr_rec.created_by;
2254: END IF;
2255: IF (x_fpr_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 2255: IF (x_fpr_rec.creation_date = Okc_Api.G_MISS_DATE)

2251: IF (x_fpr_rec.created_by = Okc_Api.G_MISS_NUM)
2252: THEN
2253: x_fpr_rec.created_by := l_fpr_rec.created_by;
2254: END IF;
2255: IF (x_fpr_rec.creation_date = Okc_Api.G_MISS_DATE)
2256: THEN
2257: x_fpr_rec.creation_date := l_fpr_rec.creation_date;
2258: END IF;
2259: IF (x_fpr_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 2259: IF (x_fpr_rec.last_updated_by = Okc_Api.G_MISS_NUM)

2255: IF (x_fpr_rec.creation_date = Okc_Api.G_MISS_DATE)
2256: THEN
2257: x_fpr_rec.creation_date := l_fpr_rec.creation_date;
2258: END IF;
2259: IF (x_fpr_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2260: THEN
2261: x_fpr_rec.last_updated_by := l_fpr_rec.last_updated_by;
2262: END IF;
2263: IF (x_fpr_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 2263: IF (x_fpr_rec.last_update_date = Okc_Api.G_MISS_DATE)

2259: IF (x_fpr_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2260: THEN
2261: x_fpr_rec.last_updated_by := l_fpr_rec.last_updated_by;
2262: END IF;
2263: IF (x_fpr_rec.last_update_date = Okc_Api.G_MISS_DATE)
2264: THEN
2265: x_fpr_rec.last_update_date := l_fpr_rec.last_update_date;
2266: END IF;
2267: IF (x_fpr_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 2267: IF (x_fpr_rec.last_update_login = Okc_Api.G_MISS_NUM)

2263: IF (x_fpr_rec.last_update_date = Okc_Api.G_MISS_DATE)
2264: THEN
2265: x_fpr_rec.last_update_date := l_fpr_rec.last_update_date;
2266: END IF;
2267: IF (x_fpr_rec.last_update_login = Okc_Api.G_MISS_NUM)
2268: THEN
2269: x_fpr_rec.last_update_login := l_fpr_rec.last_update_login;
2270: END IF;
2271: RETURN(l_return_status);

Line 2280: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2276: FUNCTION Set_Attributes (
2277: p_fpr_rec IN fpr_rec_type,
2278: x_fpr_rec OUT NOCOPY fpr_rec_type
2279: ) RETURN VARCHAR2 IS
2280: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2281: BEGIN
2282: x_fpr_rec := p_fpr_rec;
2283: RETURN(l_return_status);
2284: END Set_Attributes;

Line 2286: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

2282: x_fpr_rec := p_fpr_rec;
2283: RETURN(l_return_status);
2284: END Set_Attributes;
2285: BEGIN
2286: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2287: p_init_msg_list,
2288: '_PVT',
2289: x_return_status);
2290: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

2286: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2287: p_init_msg_list,
2288: '_PVT',
2289: x_return_status);
2290: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2291: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2292: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2293: RAISE Okc_Api.G_EXCEPTION_ERROR;
2294: END IF;

Line 2291: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2287: p_init_msg_list,
2288: '_PVT',
2289: x_return_status);
2290: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2291: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2292: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2293: RAISE Okc_Api.G_EXCEPTION_ERROR;
2294: END IF;
2295: --- Setting item attributes

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

2288: '_PVT',
2289: x_return_status);
2290: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2291: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2292: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2293: RAISE Okc_Api.G_EXCEPTION_ERROR;
2294: END IF;
2295: --- Setting item attributes
2296: l_return_status := Set_Attributes(

Line 2293: RAISE Okc_Api.G_EXCEPTION_ERROR;

2289: x_return_status);
2290: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2291: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2292: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2293: RAISE Okc_Api.G_EXCEPTION_ERROR;
2294: END IF;
2295: --- Setting item attributes
2296: l_return_status := Set_Attributes(
2297: p_fpr_rec, -- IN

Line 2300: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2296: l_return_status := Set_Attributes(
2297: p_fpr_rec, -- IN
2298: l_fpr_rec); -- OUT
2299: --- If any errors happen abort API
2300: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2301: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2302: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2303: RAISE Okc_Api.G_EXCEPTION_ERROR;
2304: END IF;

Line 2301: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2297: p_fpr_rec, -- IN
2298: l_fpr_rec); -- OUT
2299: --- If any errors happen abort API
2300: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2301: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2302: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2303: RAISE Okc_Api.G_EXCEPTION_ERROR;
2304: END IF;
2305: l_return_status := populate_new_record(l_fpr_rec, l_def_fpr_rec);

Line 2302: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2298: l_fpr_rec); -- OUT
2299: --- If any errors happen abort API
2300: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2301: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2302: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2303: RAISE Okc_Api.G_EXCEPTION_ERROR;
2304: END IF;
2305: l_return_status := populate_new_record(l_fpr_rec, l_def_fpr_rec);
2306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2303: RAISE Okc_Api.G_EXCEPTION_ERROR;

2299: --- If any errors happen abort API
2300: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2301: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2302: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2303: RAISE Okc_Api.G_EXCEPTION_ERROR;
2304: END IF;
2305: l_return_status := populate_new_record(l_fpr_rec, l_def_fpr_rec);
2306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2302: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2303: RAISE Okc_Api.G_EXCEPTION_ERROR;
2304: END IF;
2305: l_return_status := populate_new_record(l_fpr_rec, l_def_fpr_rec);
2306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2309: RAISE Okc_Api.G_EXCEPTION_ERROR;
2310: END IF;

Line 2307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2303: RAISE Okc_Api.G_EXCEPTION_ERROR;
2304: END IF;
2305: l_return_status := populate_new_record(l_fpr_rec, l_def_fpr_rec);
2306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2309: RAISE Okc_Api.G_EXCEPTION_ERROR;
2310: END IF;
2311: UPDATE OKL_FNCTN_PRMTRS_B

Line 2308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2304: END IF;
2305: l_return_status := populate_new_record(l_fpr_rec, l_def_fpr_rec);
2306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2309: RAISE Okc_Api.G_EXCEPTION_ERROR;
2310: END IF;
2311: UPDATE OKL_FNCTN_PRMTRS_B
2312: SET DSF_ID = l_def_fpr_rec.dsf_id,

Line 2309: RAISE Okc_Api.G_EXCEPTION_ERROR;

2305: l_return_status := populate_new_record(l_fpr_rec, l_def_fpr_rec);
2306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2309: RAISE Okc_Api.G_EXCEPTION_ERROR;
2310: END IF;
2311: UPDATE OKL_FNCTN_PRMTRS_B
2312: SET DSF_ID = l_def_fpr_rec.dsf_id,
2313: PMR_ID = l_def_fpr_rec.pmr_id,

Line 2325: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2321: LAST_UPDATE_LOGIN = l_def_fpr_rec.last_update_login
2322: WHERE ID = l_def_fpr_rec.id;
2323:
2324: x_fpr_rec := l_def_fpr_rec;
2325: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2326: EXCEPTION
2327: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2328: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2329: (

Line 2327: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2323:
2324: x_fpr_rec := l_def_fpr_rec;
2325: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2326: EXCEPTION
2327: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2328: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2329: (
2330: l_api_name,
2331: G_PKG_NAME,

Line 2328: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2324: x_fpr_rec := l_def_fpr_rec;
2325: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2326: EXCEPTION
2327: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2328: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2329: (
2330: l_api_name,
2331: G_PKG_NAME,
2332: 'OKC_API.G_RET_STS_ERROR',

Line 2332: 'OKC_API.G_RET_STS_ERROR',

2328: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2329: (
2330: l_api_name,
2331: G_PKG_NAME,
2332: 'OKC_API.G_RET_STS_ERROR',
2333: x_msg_count,
2334: x_msg_data,
2335: '_PVT'
2336: );

Line 2337: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2333: x_msg_count,
2334: x_msg_data,
2335: '_PVT'
2336: );
2337: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2338: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2339: (
2340: l_api_name,
2341: G_PKG_NAME,

Line 2338: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2334: x_msg_data,
2335: '_PVT'
2336: );
2337: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2338: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2339: (
2340: l_api_name,
2341: G_PKG_NAME,
2342: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2342: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2338: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2339: (
2340: l_api_name,
2341: G_PKG_NAME,
2342: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2343: x_msg_count,
2344: x_msg_data,
2345: '_PVT'
2346: );

Line 2348: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2344: x_msg_data,
2345: '_PVT'
2346: );
2347: WHEN OTHERS THEN
2348: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2349: (
2350: l_api_name,
2351: G_PKG_NAME,
2352: 'OTHERS',

Line 2362: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2358: ----------------------------------------
2359: -- update_row for:OKL_FNCTN_PRMTRS_TL --
2360: ----------------------------------------
2361: PROCEDURE update_row(
2362: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2363: x_return_status OUT NOCOPY VARCHAR2,
2364: x_msg_count OUT NOCOPY NUMBER,
2365: x_msg_data OUT NOCOPY VARCHAR2,
2366: p_okl_fnctn_prmtrs_tl_rec IN okl_fnctn_prmtrs_tl_rec_type,

Line 2371: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2367: x_okl_fnctn_prmtrs_tl_rec OUT NOCOPY okl_fnctn_prmtrs_tl_rec_type) IS
2368:
2369: l_api_version CONSTANT NUMBER := 1;
2370: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2371: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2372: l_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type := p_okl_fnctn_prmtrs_tl_rec;
2373: ldefoklfnctnprmtrstlrec okl_fnctn_prmtrs_tl_rec_type;
2374: l_row_notfound BOOLEAN := TRUE;
2375: ----------------------------------

Line 2384: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2380: x_okl_fnctn_prmtrs_tl_rec OUT NOCOPY okl_fnctn_prmtrs_tl_rec_type
2381: ) RETURN VARCHAR2 IS
2382: l_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type;
2383: l_row_notfound BOOLEAN := TRUE;
2384: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2385: BEGIN
2386: x_okl_fnctn_prmtrs_tl_rec := p_okl_fnctn_prmtrs_tl_rec;
2387: -- Get current database values
2388: l_okl_fnctn_prmtrs_tl_rec := get_rec(p_okl_fnctn_prmtrs_tl_rec, l_row_notfound);

Line 2390: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

2386: x_okl_fnctn_prmtrs_tl_rec := p_okl_fnctn_prmtrs_tl_rec;
2387: -- Get current database values
2388: l_okl_fnctn_prmtrs_tl_rec := get_rec(p_okl_fnctn_prmtrs_tl_rec, l_row_notfound);
2389: IF (l_row_notfound) THEN
2390: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2391: END IF;
2392: IF (x_okl_fnctn_prmtrs_tl_rec.id = Okc_Api.G_MISS_NUM)
2393: THEN
2394: x_okl_fnctn_prmtrs_tl_rec.id := l_okl_fnctn_prmtrs_tl_rec.id;

Line 2392: IF (x_okl_fnctn_prmtrs_tl_rec.id = Okc_Api.G_MISS_NUM)

2388: l_okl_fnctn_prmtrs_tl_rec := get_rec(p_okl_fnctn_prmtrs_tl_rec, l_row_notfound);
2389: IF (l_row_notfound) THEN
2390: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2391: END IF;
2392: IF (x_okl_fnctn_prmtrs_tl_rec.id = Okc_Api.G_MISS_NUM)
2393: THEN
2394: x_okl_fnctn_prmtrs_tl_rec.id := l_okl_fnctn_prmtrs_tl_rec.id;
2395: END IF;
2396: IF (x_okl_fnctn_prmtrs_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)

Line 2396: IF (x_okl_fnctn_prmtrs_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)

2392: IF (x_okl_fnctn_prmtrs_tl_rec.id = Okc_Api.G_MISS_NUM)
2393: THEN
2394: x_okl_fnctn_prmtrs_tl_rec.id := l_okl_fnctn_prmtrs_tl_rec.id;
2395: END IF;
2396: IF (x_okl_fnctn_prmtrs_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2397: THEN
2398: x_okl_fnctn_prmtrs_tl_rec.LANGUAGE := l_okl_fnctn_prmtrs_tl_rec.LANGUAGE;
2399: END IF;
2400: IF (x_okl_fnctn_prmtrs_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)

Line 2400: IF (x_okl_fnctn_prmtrs_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)

2396: IF (x_okl_fnctn_prmtrs_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2397: THEN
2398: x_okl_fnctn_prmtrs_tl_rec.LANGUAGE := l_okl_fnctn_prmtrs_tl_rec.LANGUAGE;
2399: END IF;
2400: IF (x_okl_fnctn_prmtrs_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2401: THEN
2402: x_okl_fnctn_prmtrs_tl_rec.source_lang := l_okl_fnctn_prmtrs_tl_rec.source_lang;
2403: END IF;
2404: IF (x_okl_fnctn_prmtrs_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)

Line 2404: IF (x_okl_fnctn_prmtrs_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)

2400: IF (x_okl_fnctn_prmtrs_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2401: THEN
2402: x_okl_fnctn_prmtrs_tl_rec.source_lang := l_okl_fnctn_prmtrs_tl_rec.source_lang;
2403: END IF;
2404: IF (x_okl_fnctn_prmtrs_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2405: THEN
2406: x_okl_fnctn_prmtrs_tl_rec.sfwt_flag := l_okl_fnctn_prmtrs_tl_rec.sfwt_flag;
2407: END IF;
2408: IF (x_okl_fnctn_prmtrs_tl_rec.value = Okc_Api.G_MISS_CHAR)

Line 2408: IF (x_okl_fnctn_prmtrs_tl_rec.value = Okc_Api.G_MISS_CHAR)

2404: IF (x_okl_fnctn_prmtrs_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2405: THEN
2406: x_okl_fnctn_prmtrs_tl_rec.sfwt_flag := l_okl_fnctn_prmtrs_tl_rec.sfwt_flag;
2407: END IF;
2408: IF (x_okl_fnctn_prmtrs_tl_rec.value = Okc_Api.G_MISS_CHAR)
2409: THEN
2410: x_okl_fnctn_prmtrs_tl_rec.value := l_okl_fnctn_prmtrs_tl_rec.value;
2411: END IF;
2412: IF (x_okl_fnctn_prmtrs_tl_rec.instructions = Okc_Api.G_MISS_CHAR)

Line 2412: IF (x_okl_fnctn_prmtrs_tl_rec.instructions = Okc_Api.G_MISS_CHAR)

2408: IF (x_okl_fnctn_prmtrs_tl_rec.value = Okc_Api.G_MISS_CHAR)
2409: THEN
2410: x_okl_fnctn_prmtrs_tl_rec.value := l_okl_fnctn_prmtrs_tl_rec.value;
2411: END IF;
2412: IF (x_okl_fnctn_prmtrs_tl_rec.instructions = Okc_Api.G_MISS_CHAR)
2413: THEN
2414: x_okl_fnctn_prmtrs_tl_rec.instructions := l_okl_fnctn_prmtrs_tl_rec.instructions;
2415: END IF;
2416: IF (x_okl_fnctn_prmtrs_tl_rec.created_by = Okc_Api.G_MISS_NUM)

Line 2416: IF (x_okl_fnctn_prmtrs_tl_rec.created_by = Okc_Api.G_MISS_NUM)

2412: IF (x_okl_fnctn_prmtrs_tl_rec.instructions = Okc_Api.G_MISS_CHAR)
2413: THEN
2414: x_okl_fnctn_prmtrs_tl_rec.instructions := l_okl_fnctn_prmtrs_tl_rec.instructions;
2415: END IF;
2416: IF (x_okl_fnctn_prmtrs_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2417: THEN
2418: x_okl_fnctn_prmtrs_tl_rec.created_by := l_okl_fnctn_prmtrs_tl_rec.created_by;
2419: END IF;
2420: IF (x_okl_fnctn_prmtrs_tl_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 2420: IF (x_okl_fnctn_prmtrs_tl_rec.creation_date = Okc_Api.G_MISS_DATE)

2416: IF (x_okl_fnctn_prmtrs_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2417: THEN
2418: x_okl_fnctn_prmtrs_tl_rec.created_by := l_okl_fnctn_prmtrs_tl_rec.created_by;
2419: END IF;
2420: IF (x_okl_fnctn_prmtrs_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2421: THEN
2422: x_okl_fnctn_prmtrs_tl_rec.creation_date := l_okl_fnctn_prmtrs_tl_rec.creation_date;
2423: END IF;
2424: IF (x_okl_fnctn_prmtrs_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 2424: IF (x_okl_fnctn_prmtrs_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)

2420: IF (x_okl_fnctn_prmtrs_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2421: THEN
2422: x_okl_fnctn_prmtrs_tl_rec.creation_date := l_okl_fnctn_prmtrs_tl_rec.creation_date;
2423: END IF;
2424: IF (x_okl_fnctn_prmtrs_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2425: THEN
2426: x_okl_fnctn_prmtrs_tl_rec.last_updated_by := l_okl_fnctn_prmtrs_tl_rec.last_updated_by;
2427: END IF;
2428: IF (x_okl_fnctn_prmtrs_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 2428: IF (x_okl_fnctn_prmtrs_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)

2424: IF (x_okl_fnctn_prmtrs_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2425: THEN
2426: x_okl_fnctn_prmtrs_tl_rec.last_updated_by := l_okl_fnctn_prmtrs_tl_rec.last_updated_by;
2427: END IF;
2428: IF (x_okl_fnctn_prmtrs_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2429: THEN
2430: x_okl_fnctn_prmtrs_tl_rec.last_update_date := l_okl_fnctn_prmtrs_tl_rec.last_update_date;
2431: END IF;
2432: IF (x_okl_fnctn_prmtrs_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 2432: IF (x_okl_fnctn_prmtrs_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)

2428: IF (x_okl_fnctn_prmtrs_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2429: THEN
2430: x_okl_fnctn_prmtrs_tl_rec.last_update_date := l_okl_fnctn_prmtrs_tl_rec.last_update_date;
2431: END IF;
2432: IF (x_okl_fnctn_prmtrs_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
2433: THEN
2434: x_okl_fnctn_prmtrs_tl_rec.last_update_login := l_okl_fnctn_prmtrs_tl_rec.last_update_login;
2435: END IF;
2436: RETURN(l_return_status);

Line 2445: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2441: FUNCTION Set_Attributes (
2442: p_okl_fnctn_prmtrs_tl_rec IN okl_fnctn_prmtrs_tl_rec_type,
2443: x_okl_fnctn_prmtrs_tl_rec OUT NOCOPY okl_fnctn_prmtrs_tl_rec_type
2444: ) RETURN VARCHAR2 IS
2445: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2446: BEGIN
2447: x_okl_fnctn_prmtrs_tl_rec := p_okl_fnctn_prmtrs_tl_rec;
2448: x_okl_fnctn_prmtrs_tl_rec.LANGUAGE := USERENV('LANG');
2449: x_okl_fnctn_prmtrs_tl_rec.SOURCE_LANG := USERENV('LANG');

Line 2453: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

2449: x_okl_fnctn_prmtrs_tl_rec.SOURCE_LANG := USERENV('LANG');
2450: RETURN(l_return_status);
2451: END Set_Attributes;
2452: BEGIN
2453: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2454: p_init_msg_list,
2455: '_PVT',
2456: x_return_status);
2457: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2457: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2453: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2454: p_init_msg_list,
2455: '_PVT',
2456: x_return_status);
2457: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2458: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2459: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2460: RAISE Okc_Api.G_EXCEPTION_ERROR;
2461: END IF;

Line 2458: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2454: p_init_msg_list,
2455: '_PVT',
2456: x_return_status);
2457: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2458: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2459: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2460: RAISE Okc_Api.G_EXCEPTION_ERROR;
2461: END IF;
2462: --- Setting item attributes

Line 2459: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

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

Line 2460: RAISE Okc_Api.G_EXCEPTION_ERROR;

2456: x_return_status);
2457: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2458: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2459: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2460: RAISE Okc_Api.G_EXCEPTION_ERROR;
2461: END IF;
2462: --- Setting item attributes
2463: l_return_status := Set_Attributes(
2464: p_okl_fnctn_prmtrs_tl_rec, -- IN

Line 2467: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2463: l_return_status := Set_Attributes(
2464: p_okl_fnctn_prmtrs_tl_rec, -- IN
2465: l_okl_fnctn_prmtrs_tl_rec); -- OUT
2466: --- If any errors happen abort API
2467: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2468: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2469: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2470: RAISE Okc_Api.G_EXCEPTION_ERROR;
2471: END IF;

Line 2468: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2464: p_okl_fnctn_prmtrs_tl_rec, -- IN
2465: l_okl_fnctn_prmtrs_tl_rec); -- OUT
2466: --- If any errors happen abort API
2467: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2468: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2469: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2470: RAISE Okc_Api.G_EXCEPTION_ERROR;
2471: END IF;
2472: l_return_status := populate_new_record(l_okl_fnctn_prmtrs_tl_rec, ldefoklfnctnprmtrstlrec);

Line 2469: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2465: l_okl_fnctn_prmtrs_tl_rec); -- OUT
2466: --- If any errors happen abort API
2467: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2468: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2469: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2470: RAISE Okc_Api.G_EXCEPTION_ERROR;
2471: END IF;
2472: l_return_status := populate_new_record(l_okl_fnctn_prmtrs_tl_rec, ldefoklfnctnprmtrstlrec);
2473: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2470: RAISE Okc_Api.G_EXCEPTION_ERROR;

2466: --- If any errors happen abort API
2467: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2468: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2469: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2470: RAISE Okc_Api.G_EXCEPTION_ERROR;
2471: END IF;
2472: l_return_status := populate_new_record(l_okl_fnctn_prmtrs_tl_rec, ldefoklfnctnprmtrstlrec);
2473: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2474: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2473: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2469: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2470: RAISE Okc_Api.G_EXCEPTION_ERROR;
2471: END IF;
2472: l_return_status := populate_new_record(l_okl_fnctn_prmtrs_tl_rec, ldefoklfnctnprmtrstlrec);
2473: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2474: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2475: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2476: RAISE Okc_Api.G_EXCEPTION_ERROR;
2477: END IF;

Line 2474: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2470: RAISE Okc_Api.G_EXCEPTION_ERROR;
2471: END IF;
2472: l_return_status := populate_new_record(l_okl_fnctn_prmtrs_tl_rec, ldefoklfnctnprmtrstlrec);
2473: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2474: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2475: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2476: RAISE Okc_Api.G_EXCEPTION_ERROR;
2477: END IF;
2478: UPDATE OKL_FNCTN_PRMTRS_TL

Line 2475: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2471: END IF;
2472: l_return_status := populate_new_record(l_okl_fnctn_prmtrs_tl_rec, ldefoklfnctnprmtrstlrec);
2473: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2474: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2475: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2476: RAISE Okc_Api.G_EXCEPTION_ERROR;
2477: END IF;
2478: UPDATE OKL_FNCTN_PRMTRS_TL
2479: SET VALUE = ldefoklfnctnprmtrstlrec.value,

Line 2476: RAISE Okc_Api.G_EXCEPTION_ERROR;

2472: l_return_status := populate_new_record(l_okl_fnctn_prmtrs_tl_rec, ldefoklfnctnprmtrstlrec);
2473: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2474: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2475: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2476: RAISE Okc_Api.G_EXCEPTION_ERROR;
2477: END IF;
2478: UPDATE OKL_FNCTN_PRMTRS_TL
2479: SET VALUE = ldefoklfnctnprmtrstlrec.value,
2480: INSTRUCTIONS = ldefoklfnctnprmtrstlrec.instructions,

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

2493: WHERE ID = ldefoklfnctnprmtrstlrec.id
2494: AND SOURCE_LANG <> USERENV('LANG');
2495:
2496: x_okl_fnctn_prmtrs_tl_rec := ldefoklfnctnprmtrstlrec;
2497: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2498: EXCEPTION
2499: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2500: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2501: (

Line 2499: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2495:
2496: x_okl_fnctn_prmtrs_tl_rec := ldefoklfnctnprmtrstlrec;
2497: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2498: EXCEPTION
2499: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2500: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2501: (
2502: l_api_name,
2503: G_PKG_NAME,

Line 2500: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 2504: 'OKC_API.G_RET_STS_ERROR',

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

Line 2509: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2510: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

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

Line 2514: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 2520: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

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

Line 2535: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2531: -- update_row for:OKL_FNCTN_PRMTRS_V --
2532: ---------------------------------------
2533: PROCEDURE update_row(
2534: p_api_version IN NUMBER,
2535: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2536: x_return_status OUT NOCOPY VARCHAR2,
2537: x_msg_count OUT NOCOPY NUMBER,
2538: x_msg_data OUT NOCOPY VARCHAR2,
2539: p_fprv_rec IN fprv_rec_type,

Line 2544: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2540: x_fprv_rec OUT NOCOPY fprv_rec_type) IS
2541:
2542: l_api_version CONSTANT NUMBER := 1;
2543: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2544: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2545: l_fprv_rec fprv_rec_type := p_fprv_rec;
2546: l_def_fprv_rec fprv_rec_type;
2547: l_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type;
2548: lx_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type;

Line 2573: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2569: x_fprv_rec OUT NOCOPY fprv_rec_type
2570: ) RETURN VARCHAR2 IS
2571: l_fprv_rec fprv_rec_type;
2572: l_row_notfound BOOLEAN := TRUE;
2573: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2574: BEGIN
2575: x_fprv_rec := p_fprv_rec;
2576: -- Get current database values
2577: l_fprv_rec := get_rec(p_fprv_rec, l_row_notfound);

Line 2579: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

2575: x_fprv_rec := p_fprv_rec;
2576: -- Get current database values
2577: l_fprv_rec := get_rec(p_fprv_rec, l_row_notfound);
2578: IF (l_row_notfound) THEN
2579: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2580: END IF;
2581: IF (x_fprv_rec.id = Okc_Api.G_MISS_NUM)
2582: THEN
2583: x_fprv_rec.id := l_fprv_rec.id;

Line 2581: IF (x_fprv_rec.id = Okc_Api.G_MISS_NUM)

2577: l_fprv_rec := get_rec(p_fprv_rec, l_row_notfound);
2578: IF (l_row_notfound) THEN
2579: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2580: END IF;
2581: IF (x_fprv_rec.id = Okc_Api.G_MISS_NUM)
2582: THEN
2583: x_fprv_rec.id := l_fprv_rec.id;
2584: END IF;
2585: IF (x_fprv_rec.object_version_number = Okc_Api.G_MISS_NUM)

Line 2585: IF (x_fprv_rec.object_version_number = Okc_Api.G_MISS_NUM)

2581: IF (x_fprv_rec.id = Okc_Api.G_MISS_NUM)
2582: THEN
2583: x_fprv_rec.id := l_fprv_rec.id;
2584: END IF;
2585: IF (x_fprv_rec.object_version_number = Okc_Api.G_MISS_NUM)
2586: THEN
2587: x_fprv_rec.object_version_number := l_fprv_rec.object_version_number;
2588: END IF;
2589: IF (x_fprv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)

Line 2589: IF (x_fprv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)

2585: IF (x_fprv_rec.object_version_number = Okc_Api.G_MISS_NUM)
2586: THEN
2587: x_fprv_rec.object_version_number := l_fprv_rec.object_version_number;
2588: END IF;
2589: IF (x_fprv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2590: THEN
2591: x_fprv_rec.sfwt_flag := l_fprv_rec.sfwt_flag;
2592: END IF;
2593: IF (x_fprv_rec.dsf_id = Okc_Api.G_MISS_NUM)

Line 2593: IF (x_fprv_rec.dsf_id = Okc_Api.G_MISS_NUM)

2589: IF (x_fprv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2590: THEN
2591: x_fprv_rec.sfwt_flag := l_fprv_rec.sfwt_flag;
2592: END IF;
2593: IF (x_fprv_rec.dsf_id = Okc_Api.G_MISS_NUM)
2594: THEN
2595: x_fprv_rec.dsf_id := l_fprv_rec.dsf_id;
2596: END IF;
2597: IF (x_fprv_rec.pmr_id = Okc_Api.G_MISS_NUM)

Line 2597: IF (x_fprv_rec.pmr_id = Okc_Api.G_MISS_NUM)

2593: IF (x_fprv_rec.dsf_id = Okc_Api.G_MISS_NUM)
2594: THEN
2595: x_fprv_rec.dsf_id := l_fprv_rec.dsf_id;
2596: END IF;
2597: IF (x_fprv_rec.pmr_id = Okc_Api.G_MISS_NUM)
2598: THEN
2599: x_fprv_rec.pmr_id := l_fprv_rec.pmr_id;
2600: END IF;
2601: IF (x_fprv_rec.sequence_number = Okc_Api.G_MISS_NUM)

Line 2601: IF (x_fprv_rec.sequence_number = Okc_Api.G_MISS_NUM)

2597: IF (x_fprv_rec.pmr_id = Okc_Api.G_MISS_NUM)
2598: THEN
2599: x_fprv_rec.pmr_id := l_fprv_rec.pmr_id;
2600: END IF;
2601: IF (x_fprv_rec.sequence_number = Okc_Api.G_MISS_NUM)
2602: THEN
2603: x_fprv_rec.sequence_number := l_fprv_rec.sequence_number;
2604: END IF;
2605: IF (x_fprv_rec.value = Okc_Api.G_MISS_CHAR)

Line 2605: IF (x_fprv_rec.value = Okc_Api.G_MISS_CHAR)

2601: IF (x_fprv_rec.sequence_number = Okc_Api.G_MISS_NUM)
2602: THEN
2603: x_fprv_rec.sequence_number := l_fprv_rec.sequence_number;
2604: END IF;
2605: IF (x_fprv_rec.value = Okc_Api.G_MISS_CHAR)
2606: THEN
2607: x_fprv_rec.value := l_fprv_rec.value;
2608: END IF;
2609: IF (x_fprv_rec.instructions = Okc_Api.G_MISS_CHAR)

Line 2609: IF (x_fprv_rec.instructions = Okc_Api.G_MISS_CHAR)

2605: IF (x_fprv_rec.value = Okc_Api.G_MISS_CHAR)
2606: THEN
2607: x_fprv_rec.value := l_fprv_rec.value;
2608: END IF;
2609: IF (x_fprv_rec.instructions = Okc_Api.G_MISS_CHAR)
2610: THEN
2611: x_fprv_rec.instructions := l_fprv_rec.instructions;
2612: END IF;
2613: IF (x_fprv_rec.fpr_type = Okc_Api.G_MISS_CHAR)

Line 2613: IF (x_fprv_rec.fpr_type = Okc_Api.G_MISS_CHAR)

2609: IF (x_fprv_rec.instructions = Okc_Api.G_MISS_CHAR)
2610: THEN
2611: x_fprv_rec.instructions := l_fprv_rec.instructions;
2612: END IF;
2613: IF (x_fprv_rec.fpr_type = Okc_Api.G_MISS_CHAR)
2614: THEN
2615: x_fprv_rec.fpr_type := l_fprv_rec.fpr_type;
2616: END IF;
2617: IF (x_fprv_rec.created_by = Okc_Api.G_MISS_NUM)

Line 2617: IF (x_fprv_rec.created_by = Okc_Api.G_MISS_NUM)

2613: IF (x_fprv_rec.fpr_type = Okc_Api.G_MISS_CHAR)
2614: THEN
2615: x_fprv_rec.fpr_type := l_fprv_rec.fpr_type;
2616: END IF;
2617: IF (x_fprv_rec.created_by = Okc_Api.G_MISS_NUM)
2618: THEN
2619: x_fprv_rec.created_by := l_fprv_rec.created_by;
2620: END IF;
2621: IF (x_fprv_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 2621: IF (x_fprv_rec.creation_date = Okc_Api.G_MISS_DATE)

2617: IF (x_fprv_rec.created_by = Okc_Api.G_MISS_NUM)
2618: THEN
2619: x_fprv_rec.created_by := l_fprv_rec.created_by;
2620: END IF;
2621: IF (x_fprv_rec.creation_date = Okc_Api.G_MISS_DATE)
2622: THEN
2623: x_fprv_rec.creation_date := l_fprv_rec.creation_date;
2624: END IF;
2625: IF (x_fprv_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 2625: IF (x_fprv_rec.last_updated_by = Okc_Api.G_MISS_NUM)

2621: IF (x_fprv_rec.creation_date = Okc_Api.G_MISS_DATE)
2622: THEN
2623: x_fprv_rec.creation_date := l_fprv_rec.creation_date;
2624: END IF;
2625: IF (x_fprv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2626: THEN
2627: x_fprv_rec.last_updated_by := l_fprv_rec.last_updated_by;
2628: END IF;
2629: IF (x_fprv_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 2629: IF (x_fprv_rec.last_update_date = Okc_Api.G_MISS_DATE)

2625: IF (x_fprv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2626: THEN
2627: x_fprv_rec.last_updated_by := l_fprv_rec.last_updated_by;
2628: END IF;
2629: IF (x_fprv_rec.last_update_date = Okc_Api.G_MISS_DATE)
2630: THEN
2631: x_fprv_rec.last_update_date := l_fprv_rec.last_update_date;
2632: END IF;
2633: IF (x_fprv_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 2633: IF (x_fprv_rec.last_update_login = Okc_Api.G_MISS_NUM)

2629: IF (x_fprv_rec.last_update_date = Okc_Api.G_MISS_DATE)
2630: THEN
2631: x_fprv_rec.last_update_date := l_fprv_rec.last_update_date;
2632: END IF;
2633: IF (x_fprv_rec.last_update_login = Okc_Api.G_MISS_NUM)
2634: THEN
2635: x_fprv_rec.last_update_login := l_fprv_rec.last_update_login;
2636: END IF;
2637: RETURN(l_return_status);

Line 2646: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2642: FUNCTION Set_Attributes (
2643: p_fprv_rec IN fprv_rec_type,
2644: x_fprv_rec OUT NOCOPY fprv_rec_type
2645: ) RETURN VARCHAR2 IS
2646: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2647: BEGIN
2648: x_fprv_rec := p_fprv_rec;
2649: x_fprv_rec.OBJECT_VERSION_NUMBER := NVL(x_fprv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2650: RETURN(l_return_status);

Line 2653: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

2649: x_fprv_rec.OBJECT_VERSION_NUMBER := NVL(x_fprv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2650: RETURN(l_return_status);
2651: END Set_Attributes;
2652: BEGIN
2653: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2654: G_PKG_NAME,
2655: p_init_msg_list,
2656: l_api_version,
2657: p_api_version,

Line 2660: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2656: l_api_version,
2657: p_api_version,
2658: '_PVT',
2659: x_return_status);
2660: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2661: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2662: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2663: RAISE Okc_Api.G_EXCEPTION_ERROR;
2664: END IF;

Line 2661: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2657: p_api_version,
2658: '_PVT',
2659: x_return_status);
2660: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2661: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2662: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2663: RAISE Okc_Api.G_EXCEPTION_ERROR;
2664: END IF;
2665: --- Setting item attributes

Line 2662: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2658: '_PVT',
2659: x_return_status);
2660: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2661: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2662: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2663: RAISE Okc_Api.G_EXCEPTION_ERROR;
2664: END IF;
2665: --- Setting item attributes
2666: l_return_status := Set_Attributes(

Line 2663: RAISE Okc_Api.G_EXCEPTION_ERROR;

2659: x_return_status);
2660: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2661: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2662: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2663: RAISE Okc_Api.G_EXCEPTION_ERROR;
2664: END IF;
2665: --- Setting item attributes
2666: l_return_status := Set_Attributes(
2667: p_fprv_rec, -- IN

Line 2670: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2666: l_return_status := Set_Attributes(
2667: p_fprv_rec, -- IN
2668: l_fprv_rec); -- OUT
2669: --- If any errors happen abort API
2670: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2671: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2672: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2673: RAISE Okc_Api.G_EXCEPTION_ERROR;
2674: END IF;

Line 2671: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2667: p_fprv_rec, -- IN
2668: l_fprv_rec); -- OUT
2669: --- If any errors happen abort API
2670: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2671: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2672: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2673: RAISE Okc_Api.G_EXCEPTION_ERROR;
2674: END IF;
2675: l_return_status := populate_new_record(l_fprv_rec, l_def_fprv_rec);

Line 2672: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2668: l_fprv_rec); -- OUT
2669: --- If any errors happen abort API
2670: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2671: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2672: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2673: RAISE Okc_Api.G_EXCEPTION_ERROR;
2674: END IF;
2675: l_return_status := populate_new_record(l_fprv_rec, l_def_fprv_rec);
2676: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2673: RAISE Okc_Api.G_EXCEPTION_ERROR;

2669: --- If any errors happen abort API
2670: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2671: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2672: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2673: RAISE Okc_Api.G_EXCEPTION_ERROR;
2674: END IF;
2675: l_return_status := populate_new_record(l_fprv_rec, l_def_fprv_rec);
2676: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2677: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2676: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2672: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2673: RAISE Okc_Api.G_EXCEPTION_ERROR;
2674: END IF;
2675: l_return_status := populate_new_record(l_fprv_rec, l_def_fprv_rec);
2676: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2677: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2678: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2679: RAISE Okc_Api.G_EXCEPTION_ERROR;
2680: END IF;

Line 2677: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2673: RAISE Okc_Api.G_EXCEPTION_ERROR;
2674: END IF;
2675: l_return_status := populate_new_record(l_fprv_rec, l_def_fprv_rec);
2676: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2677: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2678: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2679: RAISE Okc_Api.G_EXCEPTION_ERROR;
2680: END IF;
2681: l_def_fprv_rec := fill_who_columns(l_def_fprv_rec);

Line 2678: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2674: END IF;
2675: l_return_status := populate_new_record(l_fprv_rec, l_def_fprv_rec);
2676: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2677: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2678: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2679: RAISE Okc_Api.G_EXCEPTION_ERROR;
2680: END IF;
2681: l_def_fprv_rec := fill_who_columns(l_def_fprv_rec);
2682: --- Validate all non-missing attributes (Item Level Validation)

Line 2679: RAISE Okc_Api.G_EXCEPTION_ERROR;

2675: l_return_status := populate_new_record(l_fprv_rec, l_def_fprv_rec);
2676: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2677: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2678: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2679: RAISE Okc_Api.G_EXCEPTION_ERROR;
2680: END IF;
2681: l_def_fprv_rec := fill_who_columns(l_def_fprv_rec);
2682: --- Validate all non-missing attributes (Item Level Validation)
2683: l_return_status := Validate_Attributes(l_def_fprv_rec);

Line 2685: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2681: l_def_fprv_rec := fill_who_columns(l_def_fprv_rec);
2682: --- Validate all non-missing attributes (Item Level Validation)
2683: l_return_status := Validate_Attributes(l_def_fprv_rec);
2684: --- If any errors happen abort API
2685: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2686: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2687: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2688: RAISE Okc_Api.G_EXCEPTION_ERROR;
2689: END IF;

Line 2686: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2682: --- Validate all non-missing attributes (Item Level Validation)
2683: l_return_status := Validate_Attributes(l_def_fprv_rec);
2684: --- If any errors happen abort API
2685: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2686: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2687: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2688: RAISE Okc_Api.G_EXCEPTION_ERROR;
2689: END IF;
2690: l_return_status := Validate_Record(l_def_fprv_rec);

Line 2687: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2683: l_return_status := Validate_Attributes(l_def_fprv_rec);
2684: --- If any errors happen abort API
2685: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2686: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2687: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2688: RAISE Okc_Api.G_EXCEPTION_ERROR;
2689: END IF;
2690: l_return_status := Validate_Record(l_def_fprv_rec);
2691: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2688: RAISE Okc_Api.G_EXCEPTION_ERROR;

2684: --- If any errors happen abort API
2685: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2686: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2687: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2688: RAISE Okc_Api.G_EXCEPTION_ERROR;
2689: END IF;
2690: l_return_status := Validate_Record(l_def_fprv_rec);
2691: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2692: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2691: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2687: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2688: RAISE Okc_Api.G_EXCEPTION_ERROR;
2689: END IF;
2690: l_return_status := Validate_Record(l_def_fprv_rec);
2691: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2692: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2693: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2694: RAISE Okc_Api.G_EXCEPTION_ERROR;
2695: END IF;

Line 2692: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2688: RAISE Okc_Api.G_EXCEPTION_ERROR;
2689: END IF;
2690: l_return_status := Validate_Record(l_def_fprv_rec);
2691: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2692: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2693: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2694: RAISE Okc_Api.G_EXCEPTION_ERROR;
2695: END IF;
2696:

Line 2693: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2689: END IF;
2690: l_return_status := Validate_Record(l_def_fprv_rec);
2691: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2692: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2693: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2694: RAISE Okc_Api.G_EXCEPTION_ERROR;
2695: END IF;
2696:
2697: --------------------------------------

Line 2694: RAISE Okc_Api.G_EXCEPTION_ERROR;

2690: l_return_status := Validate_Record(l_def_fprv_rec);
2691: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2692: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2693: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2694: RAISE Okc_Api.G_EXCEPTION_ERROR;
2695: END IF;
2696:
2697: --------------------------------------
2698: -- Move VIEW record to "Child" records

Line 2713: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2709: x_msg_data,
2710: l_okl_fnctn_prmtrs_tl_rec,
2711: lx_okl_fnctn_prmtrs_tl_rec
2712: );
2713: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2714: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2715: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2716: RAISE Okc_Api.G_EXCEPTION_ERROR;
2717: END IF;

Line 2714: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2710: l_okl_fnctn_prmtrs_tl_rec,
2711: lx_okl_fnctn_prmtrs_tl_rec
2712: );
2713: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2714: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2715: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2716: RAISE Okc_Api.G_EXCEPTION_ERROR;
2717: END IF;
2718: migrate(lx_okl_fnctn_prmtrs_tl_rec, l_def_fprv_rec);

Line 2715: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2711: lx_okl_fnctn_prmtrs_tl_rec
2712: );
2713: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2714: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2715: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2716: RAISE Okc_Api.G_EXCEPTION_ERROR;
2717: END IF;
2718: migrate(lx_okl_fnctn_prmtrs_tl_rec, l_def_fprv_rec);
2719: update_row(

Line 2716: RAISE Okc_Api.G_EXCEPTION_ERROR;

2712: );
2713: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2714: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2715: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2716: RAISE Okc_Api.G_EXCEPTION_ERROR;
2717: END IF;
2718: migrate(lx_okl_fnctn_prmtrs_tl_rec, l_def_fprv_rec);
2719: update_row(
2720: p_init_msg_list,

Line 2727: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2723: x_msg_data,
2724: l_fpr_rec,
2725: lx_fpr_rec
2726: );
2727: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2728: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2729: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2730: RAISE Okc_Api.G_EXCEPTION_ERROR;
2731: END IF;

Line 2728: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2724: l_fpr_rec,
2725: lx_fpr_rec
2726: );
2727: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2728: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2729: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2730: RAISE Okc_Api.G_EXCEPTION_ERROR;
2731: END IF;
2732: migrate(lx_fpr_rec, l_def_fprv_rec);

Line 2729: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2725: lx_fpr_rec
2726: );
2727: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2728: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2729: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2730: RAISE Okc_Api.G_EXCEPTION_ERROR;
2731: END IF;
2732: migrate(lx_fpr_rec, l_def_fprv_rec);
2733: x_fprv_rec := l_def_fprv_rec;

Line 2730: RAISE Okc_Api.G_EXCEPTION_ERROR;

2726: );
2727: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2728: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2729: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2730: RAISE Okc_Api.G_EXCEPTION_ERROR;
2731: END IF;
2732: migrate(lx_fpr_rec, l_def_fprv_rec);
2733: x_fprv_rec := l_def_fprv_rec;
2734: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2734: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2730: RAISE Okc_Api.G_EXCEPTION_ERROR;
2731: END IF;
2732: migrate(lx_fpr_rec, l_def_fprv_rec);
2733: x_fprv_rec := l_def_fprv_rec;
2734: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2735: EXCEPTION
2736: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2737: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2738: (

Line 2736: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2732: migrate(lx_fpr_rec, l_def_fprv_rec);
2733: x_fprv_rec := l_def_fprv_rec;
2734: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2735: EXCEPTION
2736: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2737: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2738: (
2739: l_api_name,
2740: G_PKG_NAME,

Line 2737: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2733: x_fprv_rec := l_def_fprv_rec;
2734: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2735: EXCEPTION
2736: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2737: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2738: (
2739: l_api_name,
2740: G_PKG_NAME,
2741: 'OKC_API.G_RET_STS_ERROR',

Line 2741: 'OKC_API.G_RET_STS_ERROR',

2737: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2738: (
2739: l_api_name,
2740: G_PKG_NAME,
2741: 'OKC_API.G_RET_STS_ERROR',
2742: x_msg_count,
2743: x_msg_data,
2744: '_PVT'
2745: );

Line 2746: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2742: x_msg_count,
2743: x_msg_data,
2744: '_PVT'
2745: );
2746: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2747: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2748: (
2749: l_api_name,
2750: G_PKG_NAME,

Line 2747: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2743: x_msg_data,
2744: '_PVT'
2745: );
2746: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2747: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2748: (
2749: l_api_name,
2750: G_PKG_NAME,
2751: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2751: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2747: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2748: (
2749: l_api_name,
2750: G_PKG_NAME,
2751: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2752: x_msg_count,
2753: x_msg_data,
2754: '_PVT'
2755: );

Line 2757: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2753: x_msg_data,
2754: '_PVT'
2755: );
2756: WHEN OTHERS THEN
2757: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2758: (
2759: l_api_name,
2760: G_PKG_NAME,
2761: 'OTHERS',

Line 2772: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2768: -- PL/SQL TBL update_row for:FPRV_TBL --
2769: ----------------------------------------
2770: PROCEDURE update_row(
2771: p_api_version IN NUMBER,
2772: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2773: x_return_status OUT NOCOPY VARCHAR2,
2774: x_msg_count OUT NOCOPY NUMBER,
2775: x_msg_data OUT NOCOPY VARCHAR2,
2776: p_fprv_tbl IN fprv_tbl_type,

Line 2781: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2777: x_fprv_tbl OUT NOCOPY fprv_tbl_type) IS
2778:
2779: l_api_version CONSTANT NUMBER := 1;
2780: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2781: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2782: i NUMBER := 0;
2783: -- START change : mvasudev, 05/15/2001
2784: -- Adding OverAll Status Flag
2785: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 2785: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2781: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2782: i NUMBER := 0;
2783: -- START change : mvasudev, 05/15/2001
2784: -- Adding OverAll Status Flag
2785: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2786: -- END change : mvasudev
2787: BEGIN
2788: Okc_Api.init_msg_list(p_init_msg_list);
2789: -- Make sure PL/SQL table has records in it before passing

Line 2788: Okc_Api.init_msg_list(p_init_msg_list);

2784: -- Adding OverAll Status Flag
2785: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2786: -- END change : mvasudev
2787: BEGIN
2788: Okc_Api.init_msg_list(p_init_msg_list);
2789: -- Make sure PL/SQL table has records in it before passing
2790: IF (p_fprv_tbl.COUNT > 0) THEN
2791: i := p_fprv_tbl.FIRST;
2792: LOOP

Line 2795: p_init_msg_list => Okc_Api.G_FALSE,

2791: i := p_fprv_tbl.FIRST;
2792: LOOP
2793: update_row (
2794: p_api_version => p_api_version,
2795: p_init_msg_list => Okc_Api.G_FALSE,
2796: x_return_status => x_return_status,
2797: x_msg_count => x_msg_count,
2798: x_msg_data => x_msg_data,
2799: p_fprv_rec => p_fprv_tbl(i),

Line 2803: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

2799: p_fprv_rec => p_fprv_tbl(i),
2800: x_fprv_rec => x_fprv_tbl(i));
2801: -- START change : mvasudev, 05/15/2001
2802: -- store the highest degree of error
2803: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2804: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2805: l_overall_status := x_return_status;
2806: END IF;
2807: END IF;

Line 2804: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

2800: x_fprv_rec => x_fprv_tbl(i));
2801: -- START change : mvasudev, 05/15/2001
2802: -- store the highest degree of error
2803: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
2804: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
2805: l_overall_status := x_return_status;
2806: END IF;
2807: END IF;
2808: -- END change : mvasudev

Line 2818: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2814: x_return_status := l_overall_status;
2815: -- END change : mvasudev
2816: END IF;
2817: EXCEPTION
2818: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2819: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2820: (
2821: l_api_name,
2822: G_PKG_NAME,

Line 2819: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2815: -- END change : mvasudev
2816: END IF;
2817: EXCEPTION
2818: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2819: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2820: (
2821: l_api_name,
2822: G_PKG_NAME,
2823: 'OKC_API.G_RET_STS_ERROR',

Line 2823: 'OKC_API.G_RET_STS_ERROR',

2819: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2820: (
2821: l_api_name,
2822: G_PKG_NAME,
2823: 'OKC_API.G_RET_STS_ERROR',
2824: x_msg_count,
2825: x_msg_data,
2826: '_PVT'
2827: );

Line 2828: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2824: x_msg_count,
2825: x_msg_data,
2826: '_PVT'
2827: );
2828: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2829: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2830: (
2831: l_api_name,
2832: G_PKG_NAME,

Line 2829: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2825: x_msg_data,
2826: '_PVT'
2827: );
2828: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2829: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2830: (
2831: l_api_name,
2832: G_PKG_NAME,
2833: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2833: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2829: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2830: (
2831: l_api_name,
2832: G_PKG_NAME,
2833: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2834: x_msg_count,
2835: x_msg_data,
2836: '_PVT'
2837: );

Line 2839: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2835: x_msg_data,
2836: '_PVT'
2837: );
2838: WHEN OTHERS THEN
2839: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2840: (
2841: l_api_name,
2842: G_PKG_NAME,
2843: 'OTHERS',

Line 2857: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2853: ---------------------------------------
2854: -- delete_row for:OKL_FNCTN_PRMTRS_B --
2855: ---------------------------------------
2856: PROCEDURE delete_row(
2857: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2858: x_return_status OUT NOCOPY VARCHAR2,
2859: x_msg_count OUT NOCOPY NUMBER,
2860: x_msg_data OUT NOCOPY VARCHAR2,
2861: p_fpr_rec IN fpr_rec_type) IS

Line 2865: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2861: p_fpr_rec IN fpr_rec_type) IS
2862:
2863: l_api_version CONSTANT NUMBER := 1;
2864: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2865: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2866: l_fpr_rec fpr_rec_type:= p_fpr_rec;
2867: l_row_notfound BOOLEAN := TRUE;
2868: BEGIN
2869: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 2869: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

2865: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2866: l_fpr_rec fpr_rec_type:= p_fpr_rec;
2867: l_row_notfound BOOLEAN := TRUE;
2868: BEGIN
2869: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2870: p_init_msg_list,
2871: '_PVT',
2872: x_return_status);
2873: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2873: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2869: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2870: p_init_msg_list,
2871: '_PVT',
2872: x_return_status);
2873: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2874: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2875: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2876: RAISE Okc_Api.G_EXCEPTION_ERROR;
2877: END IF;

Line 2874: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2870: p_init_msg_list,
2871: '_PVT',
2872: x_return_status);
2873: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2874: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2875: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2876: RAISE Okc_Api.G_EXCEPTION_ERROR;
2877: END IF;
2878: DELETE FROM OKL_FNCTN_PRMTRS_B

Line 2875: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2871: '_PVT',
2872: x_return_status);
2873: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2874: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2875: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2876: RAISE Okc_Api.G_EXCEPTION_ERROR;
2877: END IF;
2878: DELETE FROM OKL_FNCTN_PRMTRS_B
2879: WHERE ID = l_fpr_rec.id;

Line 2876: RAISE Okc_Api.G_EXCEPTION_ERROR;

2872: x_return_status);
2873: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2874: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2875: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2876: RAISE Okc_Api.G_EXCEPTION_ERROR;
2877: END IF;
2878: DELETE FROM OKL_FNCTN_PRMTRS_B
2879: WHERE ID = l_fpr_rec.id;
2880:

Line 2881: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2877: END IF;
2878: DELETE FROM OKL_FNCTN_PRMTRS_B
2879: WHERE ID = l_fpr_rec.id;
2880:
2881: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2882: EXCEPTION
2883: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2884: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2885: (

Line 2883: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2879: WHERE ID = l_fpr_rec.id;
2880:
2881: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2882: EXCEPTION
2883: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2884: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2885: (
2886: l_api_name,
2887: G_PKG_NAME,

Line 2884: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2880:
2881: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2882: EXCEPTION
2883: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2884: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2885: (
2886: l_api_name,
2887: G_PKG_NAME,
2888: 'OKC_API.G_RET_STS_ERROR',

Line 2888: 'OKC_API.G_RET_STS_ERROR',

2884: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2885: (
2886: l_api_name,
2887: G_PKG_NAME,
2888: 'OKC_API.G_RET_STS_ERROR',
2889: x_msg_count,
2890: x_msg_data,
2891: '_PVT'
2892: );

Line 2893: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2889: x_msg_count,
2890: x_msg_data,
2891: '_PVT'
2892: );
2893: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2894: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2895: (
2896: l_api_name,
2897: G_PKG_NAME,

Line 2894: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2890: x_msg_data,
2891: '_PVT'
2892: );
2893: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2894: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2895: (
2896: l_api_name,
2897: G_PKG_NAME,
2898: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2898: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2894: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2895: (
2896: l_api_name,
2897: G_PKG_NAME,
2898: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2899: x_msg_count,
2900: x_msg_data,
2901: '_PVT'
2902: );

Line 2904: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2900: x_msg_data,
2901: '_PVT'
2902: );
2903: WHEN OTHERS THEN
2904: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2905: (
2906: l_api_name,
2907: G_PKG_NAME,
2908: 'OTHERS',

Line 2918: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2914: ----------------------------------------
2915: -- delete_row for:OKL_FNCTN_PRMTRS_TL --
2916: ----------------------------------------
2917: PROCEDURE delete_row(
2918: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2919: x_return_status OUT NOCOPY VARCHAR2,
2920: x_msg_count OUT NOCOPY NUMBER,
2921: x_msg_data OUT NOCOPY VARCHAR2,
2922: p_okl_fnctn_prmtrs_tl_rec IN okl_fnctn_prmtrs_tl_rec_type) IS

Line 2926: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2922: p_okl_fnctn_prmtrs_tl_rec IN okl_fnctn_prmtrs_tl_rec_type) IS
2923:
2924: l_api_version CONSTANT NUMBER := 1;
2925: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2926: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2927: l_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type:= p_okl_fnctn_prmtrs_tl_rec;
2928: l_row_notfound BOOLEAN := TRUE;
2929: --------------------------------------------
2930: -- Set_Attributes for:OKL_FNCTN_PRMTRS_TL --

Line 2936: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2932: FUNCTION Set_Attributes (
2933: p_okl_fnctn_prmtrs_tl_rec IN okl_fnctn_prmtrs_tl_rec_type,
2934: x_okl_fnctn_prmtrs_tl_rec OUT NOCOPY okl_fnctn_prmtrs_tl_rec_type
2935: ) RETURN VARCHAR2 IS
2936: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2937: BEGIN
2938: x_okl_fnctn_prmtrs_tl_rec := p_okl_fnctn_prmtrs_tl_rec;
2939: x_okl_fnctn_prmtrs_tl_rec.LANGUAGE := USERENV('LANG');
2940: RETURN(l_return_status);

Line 2943: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

2939: x_okl_fnctn_prmtrs_tl_rec.LANGUAGE := USERENV('LANG');
2940: RETURN(l_return_status);
2941: END Set_Attributes;
2942: BEGIN
2943: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2944: p_init_msg_list,
2945: '_PVT',
2946: x_return_status);
2947: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2947: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2943: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2944: p_init_msg_list,
2945: '_PVT',
2946: x_return_status);
2947: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2948: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2949: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2950: RAISE Okc_Api.G_EXCEPTION_ERROR;
2951: END IF;

Line 2948: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2944: p_init_msg_list,
2945: '_PVT',
2946: x_return_status);
2947: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2948: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2949: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2950: RAISE Okc_Api.G_EXCEPTION_ERROR;
2951: END IF;
2952: --- Setting item attributes

Line 2949: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2945: '_PVT',
2946: x_return_status);
2947: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2948: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2949: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2950: RAISE Okc_Api.G_EXCEPTION_ERROR;
2951: END IF;
2952: --- Setting item attributes
2953: l_return_status := Set_Attributes(

Line 2950: RAISE Okc_Api.G_EXCEPTION_ERROR;

2946: x_return_status);
2947: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2948: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2949: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2950: RAISE Okc_Api.G_EXCEPTION_ERROR;
2951: END IF;
2952: --- Setting item attributes
2953: l_return_status := Set_Attributes(
2954: p_okl_fnctn_prmtrs_tl_rec, -- IN

Line 2957: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2953: l_return_status := Set_Attributes(
2954: p_okl_fnctn_prmtrs_tl_rec, -- IN
2955: l_okl_fnctn_prmtrs_tl_rec); -- OUT
2956: --- If any errors happen abort API
2957: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2958: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2959: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2960: RAISE Okc_Api.G_EXCEPTION_ERROR;
2961: END IF;

Line 2958: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2954: p_okl_fnctn_prmtrs_tl_rec, -- IN
2955: l_okl_fnctn_prmtrs_tl_rec); -- OUT
2956: --- If any errors happen abort API
2957: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2958: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2959: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2960: RAISE Okc_Api.G_EXCEPTION_ERROR;
2961: END IF;
2962: DELETE FROM OKL_FNCTN_PRMTRS_TL

Line 2959: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2955: l_okl_fnctn_prmtrs_tl_rec); -- OUT
2956: --- If any errors happen abort API
2957: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2958: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2959: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2960: RAISE Okc_Api.G_EXCEPTION_ERROR;
2961: END IF;
2962: DELETE FROM OKL_FNCTN_PRMTRS_TL
2963: WHERE ID = l_okl_fnctn_prmtrs_tl_rec.id;

Line 2960: RAISE Okc_Api.G_EXCEPTION_ERROR;

2956: --- If any errors happen abort API
2957: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2958: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2959: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2960: RAISE Okc_Api.G_EXCEPTION_ERROR;
2961: END IF;
2962: DELETE FROM OKL_FNCTN_PRMTRS_TL
2963: WHERE ID = l_okl_fnctn_prmtrs_tl_rec.id;
2964:

Line 2965: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2961: END IF;
2962: DELETE FROM OKL_FNCTN_PRMTRS_TL
2963: WHERE ID = l_okl_fnctn_prmtrs_tl_rec.id;
2964:
2965: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2966: EXCEPTION
2967: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2968: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2969: (

Line 2967: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2963: WHERE ID = l_okl_fnctn_prmtrs_tl_rec.id;
2964:
2965: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2966: EXCEPTION
2967: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2968: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2969: (
2970: l_api_name,
2971: G_PKG_NAME,

Line 2968: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2964:
2965: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2966: EXCEPTION
2967: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2968: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2969: (
2970: l_api_name,
2971: G_PKG_NAME,
2972: 'OKC_API.G_RET_STS_ERROR',

Line 2972: 'OKC_API.G_RET_STS_ERROR',

2968: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2969: (
2970: l_api_name,
2971: G_PKG_NAME,
2972: 'OKC_API.G_RET_STS_ERROR',
2973: x_msg_count,
2974: x_msg_data,
2975: '_PVT'
2976: );

Line 2977: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2973: x_msg_count,
2974: x_msg_data,
2975: '_PVT'
2976: );
2977: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2978: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2979: (
2980: l_api_name,
2981: G_PKG_NAME,

Line 2978: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2974: x_msg_data,
2975: '_PVT'
2976: );
2977: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2978: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2979: (
2980: l_api_name,
2981: G_PKG_NAME,
2982: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2982: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2978: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2979: (
2980: l_api_name,
2981: G_PKG_NAME,
2982: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2983: x_msg_count,
2984: x_msg_data,
2985: '_PVT'
2986: );

Line 2988: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2984: x_msg_data,
2985: '_PVT'
2986: );
2987: WHEN OTHERS THEN
2988: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2989: (
2990: l_api_name,
2991: G_PKG_NAME,
2992: 'OTHERS',

Line 3003: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2999: -- delete_row for:OKL_FNCTN_PRMTRS_V --
3000: ---------------------------------------
3001: PROCEDURE delete_row(
3002: p_api_version IN NUMBER,
3003: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3004: x_return_status OUT NOCOPY VARCHAR2,
3005: x_msg_count OUT NOCOPY NUMBER,
3006: x_msg_data OUT NOCOPY VARCHAR2,
3007: p_fprv_rec IN fprv_rec_type) IS

Line 3011: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

3007: p_fprv_rec IN fprv_rec_type) IS
3008:
3009: l_api_version CONSTANT NUMBER := 1;
3010: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3011: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3012: l_fprv_rec fprv_rec_type := p_fprv_rec;
3013: l_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type;
3014: l_fpr_rec fpr_rec_type;
3015: BEGIN

Line 3016: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

3012: l_fprv_rec fprv_rec_type := p_fprv_rec;
3013: l_okl_fnctn_prmtrs_tl_rec okl_fnctn_prmtrs_tl_rec_type;
3014: l_fpr_rec fpr_rec_type;
3015: BEGIN
3016: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
3017: G_PKG_NAME,
3018: p_init_msg_list,
3019: l_api_version,
3020: p_api_version,

Line 3023: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

3019: l_api_version,
3020: p_api_version,
3021: '_PVT',
3022: x_return_status);
3023: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3024: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3025: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3026: RAISE Okc_Api.G_EXCEPTION_ERROR;
3027: END IF;

Line 3024: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3020: p_api_version,
3021: '_PVT',
3022: x_return_status);
3023: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3024: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3025: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3026: RAISE Okc_Api.G_EXCEPTION_ERROR;
3027: END IF;
3028: --------------------------------------

Line 3025: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

3021: '_PVT',
3022: x_return_status);
3023: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3024: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3025: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3026: RAISE Okc_Api.G_EXCEPTION_ERROR;
3027: END IF;
3028: --------------------------------------
3029: -- Move VIEW record to "Child" records

Line 3026: RAISE Okc_Api.G_EXCEPTION_ERROR;

3022: x_return_status);
3023: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3024: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3025: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3026: RAISE Okc_Api.G_EXCEPTION_ERROR;
3027: END IF;
3028: --------------------------------------
3029: -- Move VIEW record to "Child" records
3030: --------------------------------------

Line 3043: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

3039: x_msg_count,
3040: x_msg_data,
3041: l_okl_fnctn_prmtrs_tl_rec
3042: );
3043: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3044: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3045: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3046: RAISE Okc_Api.G_EXCEPTION_ERROR;
3047: END IF;

Line 3044: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3040: x_msg_data,
3041: l_okl_fnctn_prmtrs_tl_rec
3042: );
3043: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3044: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3045: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3046: RAISE Okc_Api.G_EXCEPTION_ERROR;
3047: END IF;
3048: delete_row(

Line 3045: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

3041: l_okl_fnctn_prmtrs_tl_rec
3042: );
3043: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3044: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3045: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3046: RAISE Okc_Api.G_EXCEPTION_ERROR;
3047: END IF;
3048: delete_row(
3049: p_init_msg_list,

Line 3046: RAISE Okc_Api.G_EXCEPTION_ERROR;

3042: );
3043: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3044: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3045: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3046: RAISE Okc_Api.G_EXCEPTION_ERROR;
3047: END IF;
3048: delete_row(
3049: p_init_msg_list,
3050: x_return_status,

Line 3055: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

3051: x_msg_count,
3052: x_msg_data,
3053: l_fpr_rec
3054: );
3055: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3056: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3057: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3058: RAISE Okc_Api.G_EXCEPTION_ERROR;
3059: END IF;

Line 3056: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3052: x_msg_data,
3053: l_fpr_rec
3054: );
3055: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3056: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3057: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3058: RAISE Okc_Api.G_EXCEPTION_ERROR;
3059: END IF;
3060: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3057: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

3053: l_fpr_rec
3054: );
3055: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3056: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3057: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3058: RAISE Okc_Api.G_EXCEPTION_ERROR;
3059: END IF;
3060: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3061: EXCEPTION

Line 3058: RAISE Okc_Api.G_EXCEPTION_ERROR;

3054: );
3055: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3056: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3057: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3058: RAISE Okc_Api.G_EXCEPTION_ERROR;
3059: END IF;
3060: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3061: EXCEPTION
3062: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 3060: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

3056: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3057: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3058: RAISE Okc_Api.G_EXCEPTION_ERROR;
3059: END IF;
3060: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3061: EXCEPTION
3062: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3063: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3064: (

Line 3062: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

3058: RAISE Okc_Api.G_EXCEPTION_ERROR;
3059: END IF;
3060: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3061: EXCEPTION
3062: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3063: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3064: (
3065: l_api_name,
3066: G_PKG_NAME,

Line 3063: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3059: END IF;
3060: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3061: EXCEPTION
3062: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3063: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3064: (
3065: l_api_name,
3066: G_PKG_NAME,
3067: 'OKC_API.G_RET_STS_ERROR',

Line 3067: 'OKC_API.G_RET_STS_ERROR',

3063: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3064: (
3065: l_api_name,
3066: G_PKG_NAME,
3067: 'OKC_API.G_RET_STS_ERROR',
3068: x_msg_count,
3069: x_msg_data,
3070: '_PVT'
3071: );

Line 3072: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3068: x_msg_count,
3069: x_msg_data,
3070: '_PVT'
3071: );
3072: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3073: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3074: (
3075: l_api_name,
3076: G_PKG_NAME,

Line 3073: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3069: x_msg_data,
3070: '_PVT'
3071: );
3072: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3073: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3074: (
3075: l_api_name,
3076: G_PKG_NAME,
3077: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3077: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3073: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3074: (
3075: l_api_name,
3076: G_PKG_NAME,
3077: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3078: x_msg_count,
3079: x_msg_data,
3080: '_PVT'
3081: );

Line 3083: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3079: x_msg_data,
3080: '_PVT'
3081: );
3082: WHEN OTHERS THEN
3083: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3084: (
3085: l_api_name,
3086: G_PKG_NAME,
3087: 'OTHERS',

Line 3098: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

3094: -- PL/SQL TBL delete_row for:FPRV_TBL --
3095: ----------------------------------------
3096: PROCEDURE delete_row(
3097: p_api_version IN NUMBER,
3098: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3099: x_return_status OUT NOCOPY VARCHAR2,
3100: x_msg_count OUT NOCOPY NUMBER,
3101: x_msg_data OUT NOCOPY VARCHAR2,
3102: p_fprv_tbl IN fprv_tbl_type) IS

Line 3106: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

3102: p_fprv_tbl IN fprv_tbl_type) IS
3103:
3104: l_api_version CONSTANT NUMBER := 1;
3105: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3106: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3107: i NUMBER := 0;
3108: -- START change : mvasudev, 05/15/2001
3109: -- Adding OverAll Status Flag
3110: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

Line 3110: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

3106: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3107: i NUMBER := 0;
3108: -- START change : mvasudev, 05/15/2001
3109: -- Adding OverAll Status Flag
3110: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3111: -- END change : mvasudev
3112: BEGIN
3113: Okc_Api.init_msg_list(p_init_msg_list);
3114: -- Make sure PL/SQL table has records in it before passing

Line 3113: Okc_Api.init_msg_list(p_init_msg_list);

3109: -- Adding OverAll Status Flag
3110: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3111: -- END change : mvasudev
3112: BEGIN
3113: Okc_Api.init_msg_list(p_init_msg_list);
3114: -- Make sure PL/SQL table has records in it before passing
3115: IF (p_fprv_tbl.COUNT > 0) THEN
3116: i := p_fprv_tbl.FIRST;
3117: LOOP

Line 3120: p_init_msg_list => Okc_Api.G_FALSE,

3116: i := p_fprv_tbl.FIRST;
3117: LOOP
3118: delete_row (
3119: p_api_version => p_api_version,
3120: p_init_msg_list => Okc_Api.G_FALSE,
3121: x_return_status => x_return_status,
3122: x_msg_count => x_msg_count,
3123: x_msg_data => x_msg_data,
3124: p_fprv_rec => p_fprv_tbl(i));

Line 3127: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN

3123: x_msg_data => x_msg_data,
3124: p_fprv_rec => p_fprv_tbl(i));
3125: -- START change : mvasudev, 05/15/2001
3126: -- store the highest degree of error
3127: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
3128: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
3129: l_overall_status := x_return_status;
3130: END IF;
3131: END IF;

Line 3128: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN

3124: p_fprv_rec => p_fprv_tbl(i));
3125: -- START change : mvasudev, 05/15/2001
3126: -- store the highest degree of error
3127: IF x_return_status <> Okc_Api.G_RET_STS_SUCCESS THEN
3128: IF l_overall_status <> Okc_Api.G_RET_STS_UNEXP_ERROR THEN
3129: l_overall_status := x_return_status;
3130: END IF;
3131: END IF;
3132: -- END change : mvasudev

Line 3142: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

3138: x_return_status := l_overall_status;
3139: -- END change : mvasudev
3140: END IF;
3141: EXCEPTION
3142: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3143: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3144: (
3145: l_api_name,
3146: G_PKG_NAME,

Line 3143: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3139: -- END change : mvasudev
3140: END IF;
3141: EXCEPTION
3142: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3143: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3144: (
3145: l_api_name,
3146: G_PKG_NAME,
3147: 'OKC_API.G_RET_STS_ERROR',

Line 3147: 'OKC_API.G_RET_STS_ERROR',

3143: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3144: (
3145: l_api_name,
3146: G_PKG_NAME,
3147: 'OKC_API.G_RET_STS_ERROR',
3148: x_msg_count,
3149: x_msg_data,
3150: '_PVT'
3151: );

Line 3152: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3148: x_msg_count,
3149: x_msg_data,
3150: '_PVT'
3151: );
3152: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3153: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3154: (
3155: l_api_name,
3156: G_PKG_NAME,

Line 3153: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3149: x_msg_data,
3150: '_PVT'
3151: );
3152: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3153: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3154: (
3155: l_api_name,
3156: G_PKG_NAME,
3157: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3157: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3153: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3154: (
3155: l_api_name,
3156: G_PKG_NAME,
3157: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3158: x_msg_count,
3159: x_msg_data,
3160: '_PVT'
3161: );

Line 3163: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3159: x_msg_data,
3160: '_PVT'
3161: );
3162: WHEN OTHERS THEN
3163: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3164: (
3165: l_api_name,
3166: G_PKG_NAME,
3167: 'OTHERS',