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

Line 56: IF (p_lpov_rec.id IS NOT NULL AND p_lpov_rec.id <> OKC_API.G_MISS_NUM) THEN

52: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
53: BEGIN
54:
55: -- Check if value passed for id
56: IF (p_lpov_rec.id IS NOT NULL AND p_lpov_rec.id <> OKC_API.G_MISS_NUM) THEN
57:
58: OPEN okl_name_csr(p_lpov_rec);
59: FETCH okl_name_csr INTO l_name;
60:

Line 69: l_return_status := OKC_API.G_RET_STS_ERROR;

65: ,p_token1 => 'COL_NAME'
66: ,p_token1_value => 'Late Policy Name');
67:
68: -- notify caller of an error
69: l_return_status := OKC_API.G_RET_STS_ERROR;
70: END IF;
71:
72: END IF;
73: CLOSE okl_name_csr;

Line 292: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

288: ) RETURN lpov_rec_type IS
289: l_lpov_rec lpov_rec_type;
290: l_row_notfound BOOLEAN := TRUE;
291: BEGIN
292: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
293: l_lpov_rec := get_rec(p_lpov_rec, l_row_notfound);
294: IF (l_row_notfound) THEN
295: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
296: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 295: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');

291: BEGIN
292: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
293: l_lpov_rec := get_rec(p_lpov_rec, l_row_notfound);
294: IF (l_row_notfound) THEN
295: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
296: x_return_status := Okc_Api.G_RET_STS_ERROR;
297: END IF;
298: RETURN(l_lpov_rec);
299: END get_rec;

Line 296: x_return_status := Okc_Api.G_RET_STS_ERROR;

292: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
293: l_lpov_rec := get_rec(p_lpov_rec, l_row_notfound);
294: IF (l_row_notfound) THEN
295: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
296: x_return_status := Okc_Api.G_RET_STS_ERROR;
297: END IF;
298: RETURN(l_lpov_rec);
299: END get_rec;
300: -----------------------------------------------------------

Line 433: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

429: ) RETURN lpo_rec_type IS
430: l_lpo_rec lpo_rec_type;
431: l_row_notfound BOOLEAN := TRUE;
432: BEGIN
433: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
434: l_lpo_rec := get_rec(p_lpo_rec, l_row_notfound);
435: IF (l_row_notfound) THEN
436: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
437: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 436: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');

432: BEGIN
433: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
434: l_lpo_rec := get_rec(p_lpo_rec, l_row_notfound);
435: IF (l_row_notfound) THEN
436: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
437: x_return_status := Okc_Api.G_RET_STS_ERROR;
438: END IF;
439: RETURN(l_lpo_rec);
440: END get_rec;

Line 437: x_return_status := Okc_Api.G_RET_STS_ERROR;

433: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
434: l_lpo_rec := get_rec(p_lpo_rec, l_row_notfound);
435: IF (l_row_notfound) THEN
436: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
437: x_return_status := Okc_Api.G_RET_STS_ERROR;
438: END IF;
439: RETURN(l_lpo_rec);
440: END get_rec;
441: -----------------------------------------------------------

Line 504: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

500: ) RETURN okl_late_policies_tl_rec_type IS
501: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
502: l_row_notfound BOOLEAN := TRUE;
503: BEGIN
504: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
505: l_okl_late_policies_tl_rec := get_rec(p_okl_late_policies_tl_rec, l_row_notfound);
506: IF (l_row_notfound) THEN
507: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
508: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 507: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');

503: BEGIN
504: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
505: l_okl_late_policies_tl_rec := get_rec(p_okl_late_policies_tl_rec, l_row_notfound);
506: IF (l_row_notfound) THEN
507: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
508: x_return_status := Okc_Api.G_RET_STS_ERROR;
509: END IF;
510: RETURN(l_okl_late_policies_tl_rec);
511: END get_rec;

Line 508: x_return_status := Okc_Api.G_RET_STS_ERROR;

504: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
505: l_okl_late_policies_tl_rec := get_rec(p_okl_late_policies_tl_rec, l_row_notfound);
506: IF (l_row_notfound) THEN
507: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
508: x_return_status := Okc_Api.G_RET_STS_ERROR;
509: END IF;
510: RETURN(l_okl_late_policies_tl_rec);
511: END get_rec;
512: -----------------------------------------------------------

Line 530: IF (l_lpov_rec.id = Okc_Api.G_MISS_NUM ) THEN

526: p_lpov_rec IN lpov_rec_type
527: ) RETURN lpov_rec_type IS
528: l_lpov_rec lpov_rec_type := p_lpov_rec;
529: BEGIN
530: IF (l_lpov_rec.id = Okc_Api.G_MISS_NUM ) THEN
531: l_lpov_rec.id := NULL;
532: END IF;
533: IF (l_lpov_rec.org_id = Okc_Api.G_MISS_NUM ) THEN
534: l_lpov_rec.org_id := NULL;

Line 533: IF (l_lpov_rec.org_id = Okc_Api.G_MISS_NUM ) THEN

529: BEGIN
530: IF (l_lpov_rec.id = Okc_Api.G_MISS_NUM ) THEN
531: l_lpov_rec.id := NULL;
532: END IF;
533: IF (l_lpov_rec.org_id = Okc_Api.G_MISS_NUM ) THEN
534: l_lpov_rec.org_id := NULL;
535: END IF;
536: IF (l_lpov_rec.name = Okc_Api.G_MISS_CHAR ) THEN
537: l_lpov_rec.name := NULL;

Line 536: IF (l_lpov_rec.name = Okc_Api.G_MISS_CHAR ) THEN

532: END IF;
533: IF (l_lpov_rec.org_id = Okc_Api.G_MISS_NUM ) THEN
534: l_lpov_rec.org_id := NULL;
535: END IF;
536: IF (l_lpov_rec.name = Okc_Api.G_MISS_CHAR ) THEN
537: l_lpov_rec.name := NULL;
538: END IF;
539: IF (l_lpov_rec.description = Okc_Api.G_MISS_CHAR ) THEN
540: l_lpov_rec.description := NULL;

Line 539: IF (l_lpov_rec.description = Okc_Api.G_MISS_CHAR ) THEN

535: END IF;
536: IF (l_lpov_rec.name = Okc_Api.G_MISS_CHAR ) THEN
537: l_lpov_rec.name := NULL;
538: END IF;
539: IF (l_lpov_rec.description = Okc_Api.G_MISS_CHAR ) THEN
540: l_lpov_rec.description := NULL;
541: END IF;
542: IF (l_lpov_rec.ise_id = Okc_Api.G_MISS_NUM ) THEN
543: l_lpov_rec.ise_id := NULL;

Line 542: IF (l_lpov_rec.ise_id = Okc_Api.G_MISS_NUM ) THEN

538: END IF;
539: IF (l_lpov_rec.description = Okc_Api.G_MISS_CHAR ) THEN
540: l_lpov_rec.description := NULL;
541: END IF;
542: IF (l_lpov_rec.ise_id = Okc_Api.G_MISS_NUM ) THEN
543: l_lpov_rec.ise_id := NULL;
544: END IF;
545: IF (l_lpov_rec.tdf_id = Okc_Api.G_MISS_NUM ) THEN
546: l_lpov_rec.tdf_id := NULL;

Line 545: IF (l_lpov_rec.tdf_id = Okc_Api.G_MISS_NUM ) THEN

541: END IF;
542: IF (l_lpov_rec.ise_id = Okc_Api.G_MISS_NUM ) THEN
543: l_lpov_rec.ise_id := NULL;
544: END IF;
545: IF (l_lpov_rec.tdf_id = Okc_Api.G_MISS_NUM ) THEN
546: l_lpov_rec.tdf_id := NULL;
547: END IF;
548: IF (l_lpov_rec.idx_id = Okc_Api.G_MISS_NUM ) THEN
549: l_lpov_rec.idx_id := NULL;

Line 548: IF (l_lpov_rec.idx_id = Okc_Api.G_MISS_NUM ) THEN

544: END IF;
545: IF (l_lpov_rec.tdf_id = Okc_Api.G_MISS_NUM ) THEN
546: l_lpov_rec.tdf_id := NULL;
547: END IF;
548: IF (l_lpov_rec.idx_id = Okc_Api.G_MISS_NUM ) THEN
549: l_lpov_rec.idx_id := NULL;
550: END IF;
551: IF (l_lpov_rec.late_policy_type_code = Okc_Api.G_MISS_CHAR ) THEN
552: l_lpov_rec.late_policy_type_code := NULL;

Line 551: IF (l_lpov_rec.late_policy_type_code = Okc_Api.G_MISS_CHAR ) THEN

547: END IF;
548: IF (l_lpov_rec.idx_id = Okc_Api.G_MISS_NUM ) THEN
549: l_lpov_rec.idx_id := NULL;
550: END IF;
551: IF (l_lpov_rec.late_policy_type_code = Okc_Api.G_MISS_CHAR ) THEN
552: l_lpov_rec.late_policy_type_code := NULL;
553: END IF;
554: IF (l_lpov_rec.object_version_number = Okc_Api.G_MISS_NUM ) THEN
555: l_lpov_rec.object_version_number := NULL;

Line 554: IF (l_lpov_rec.object_version_number = Okc_Api.G_MISS_NUM ) THEN

550: END IF;
551: IF (l_lpov_rec.late_policy_type_code = Okc_Api.G_MISS_CHAR ) THEN
552: l_lpov_rec.late_policy_type_code := NULL;
553: END IF;
554: IF (l_lpov_rec.object_version_number = Okc_Api.G_MISS_NUM ) THEN
555: l_lpov_rec.object_version_number := NULL;
556: END IF;
557: IF (l_lpov_rec.late_chrg_allowed_yn = Okc_Api.G_MISS_CHAR ) THEN
558: l_lpov_rec.late_chrg_allowed_yn := NULL;

Line 557: IF (l_lpov_rec.late_chrg_allowed_yn = Okc_Api.G_MISS_CHAR ) THEN

553: END IF;
554: IF (l_lpov_rec.object_version_number = Okc_Api.G_MISS_NUM ) THEN
555: l_lpov_rec.object_version_number := NULL;
556: END IF;
557: IF (l_lpov_rec.late_chrg_allowed_yn = Okc_Api.G_MISS_CHAR ) THEN
558: l_lpov_rec.late_chrg_allowed_yn := NULL;
559: END IF;
560: IF (l_lpov_rec.late_chrg_fixed_yn = Okc_Api.G_MISS_CHAR ) THEN
561: l_lpov_rec.late_chrg_fixed_yn := NULL;

Line 560: IF (l_lpov_rec.late_chrg_fixed_yn = Okc_Api.G_MISS_CHAR ) THEN

556: END IF;
557: IF (l_lpov_rec.late_chrg_allowed_yn = Okc_Api.G_MISS_CHAR ) THEN
558: l_lpov_rec.late_chrg_allowed_yn := NULL;
559: END IF;
560: IF (l_lpov_rec.late_chrg_fixed_yn = Okc_Api.G_MISS_CHAR ) THEN
561: l_lpov_rec.late_chrg_fixed_yn := NULL;
562: END IF;
563: IF (l_lpov_rec.late_chrg_amount = Okc_Api.G_MISS_NUM ) THEN
564: l_lpov_rec.late_chrg_amount := NULL;

Line 563: IF (l_lpov_rec.late_chrg_amount = Okc_Api.G_MISS_NUM ) THEN

559: END IF;
560: IF (l_lpov_rec.late_chrg_fixed_yn = Okc_Api.G_MISS_CHAR ) THEN
561: l_lpov_rec.late_chrg_fixed_yn := NULL;
562: END IF;
563: IF (l_lpov_rec.late_chrg_amount = Okc_Api.G_MISS_NUM ) THEN
564: l_lpov_rec.late_chrg_amount := NULL;
565: END IF;
566: IF (l_lpov_rec.late_chrg_rate = Okc_Api.G_MISS_NUM ) THEN
567: l_lpov_rec.late_chrg_rate := NULL;

Line 566: IF (l_lpov_rec.late_chrg_rate = Okc_Api.G_MISS_NUM ) THEN

562: END IF;
563: IF (l_lpov_rec.late_chrg_amount = Okc_Api.G_MISS_NUM ) THEN
564: l_lpov_rec.late_chrg_amount := NULL;
565: END IF;
566: IF (l_lpov_rec.late_chrg_rate = Okc_Api.G_MISS_NUM ) THEN
567: l_lpov_rec.late_chrg_rate := NULL;
568: END IF;
569: IF (l_lpov_rec.late_chrg_grace_period = Okc_Api.G_MISS_NUM ) THEN
570: l_lpov_rec.late_chrg_grace_period := NULL;

Line 569: IF (l_lpov_rec.late_chrg_grace_period = Okc_Api.G_MISS_NUM ) THEN

565: END IF;
566: IF (l_lpov_rec.late_chrg_rate = Okc_Api.G_MISS_NUM ) THEN
567: l_lpov_rec.late_chrg_rate := NULL;
568: END IF;
569: IF (l_lpov_rec.late_chrg_grace_period = Okc_Api.G_MISS_NUM ) THEN
570: l_lpov_rec.late_chrg_grace_period := NULL;
571: END IF;
572: IF (l_lpov_rec.late_chrg_minimum_balance = Okc_Api.G_MISS_NUM ) THEN
573: l_lpov_rec.late_chrg_minimum_balance := NULL;

Line 572: IF (l_lpov_rec.late_chrg_minimum_balance = Okc_Api.G_MISS_NUM ) THEN

568: END IF;
569: IF (l_lpov_rec.late_chrg_grace_period = Okc_Api.G_MISS_NUM ) THEN
570: l_lpov_rec.late_chrg_grace_period := NULL;
571: END IF;
572: IF (l_lpov_rec.late_chrg_minimum_balance = Okc_Api.G_MISS_NUM ) THEN
573: l_lpov_rec.late_chrg_minimum_balance := NULL;
574: END IF;
575: IF (l_lpov_rec.minimum_late_charge = Okc_Api.G_MISS_NUM ) THEN
576: l_lpov_rec.minimum_late_charge := NULL;

Line 575: IF (l_lpov_rec.minimum_late_charge = Okc_Api.G_MISS_NUM ) THEN

571: END IF;
572: IF (l_lpov_rec.late_chrg_minimum_balance = Okc_Api.G_MISS_NUM ) THEN
573: l_lpov_rec.late_chrg_minimum_balance := NULL;
574: END IF;
575: IF (l_lpov_rec.minimum_late_charge = Okc_Api.G_MISS_NUM ) THEN
576: l_lpov_rec.minimum_late_charge := NULL;
577: END IF;
578: IF (l_lpov_rec.maximum_late_charge = Okc_Api.G_MISS_NUM ) THEN
579: l_lpov_rec.maximum_late_charge := NULL;

Line 578: IF (l_lpov_rec.maximum_late_charge = Okc_Api.G_MISS_NUM ) THEN

574: END IF;
575: IF (l_lpov_rec.minimum_late_charge = Okc_Api.G_MISS_NUM ) THEN
576: l_lpov_rec.minimum_late_charge := NULL;
577: END IF;
578: IF (l_lpov_rec.maximum_late_charge = Okc_Api.G_MISS_NUM ) THEN
579: l_lpov_rec.maximum_late_charge := NULL;
580: END IF;
581: IF (l_lpov_rec.late_int_allowed_yn = Okc_Api.G_MISS_CHAR ) THEN
582: l_lpov_rec.late_int_allowed_yn := NULL;

Line 581: IF (l_lpov_rec.late_int_allowed_yn = Okc_Api.G_MISS_CHAR ) THEN

577: END IF;
578: IF (l_lpov_rec.maximum_late_charge = Okc_Api.G_MISS_NUM ) THEN
579: l_lpov_rec.maximum_late_charge := NULL;
580: END IF;
581: IF (l_lpov_rec.late_int_allowed_yn = Okc_Api.G_MISS_CHAR ) THEN
582: l_lpov_rec.late_int_allowed_yn := NULL;
583: END IF;
584: IF (l_lpov_rec.late_int_fixed_yn = Okc_Api.G_MISS_CHAR ) THEN
585: l_lpov_rec.late_int_fixed_yn := NULL;

Line 584: IF (l_lpov_rec.late_int_fixed_yn = Okc_Api.G_MISS_CHAR ) THEN

580: END IF;
581: IF (l_lpov_rec.late_int_allowed_yn = Okc_Api.G_MISS_CHAR ) THEN
582: l_lpov_rec.late_int_allowed_yn := NULL;
583: END IF;
584: IF (l_lpov_rec.late_int_fixed_yn = Okc_Api.G_MISS_CHAR ) THEN
585: l_lpov_rec.late_int_fixed_yn := NULL;
586: END IF;
587: IF (l_lpov_rec.late_int_rate = Okc_Api.G_MISS_NUM ) THEN
588: l_lpov_rec.late_int_rate := NULL;

Line 587: IF (l_lpov_rec.late_int_rate = Okc_Api.G_MISS_NUM ) THEN

583: END IF;
584: IF (l_lpov_rec.late_int_fixed_yn = Okc_Api.G_MISS_CHAR ) THEN
585: l_lpov_rec.late_int_fixed_yn := NULL;
586: END IF;
587: IF (l_lpov_rec.late_int_rate = Okc_Api.G_MISS_NUM ) THEN
588: l_lpov_rec.late_int_rate := NULL;
589: END IF;
590: IF (l_lpov_rec.adder_rate = Okc_Api.G_MISS_NUM ) THEN
591: l_lpov_rec.adder_rate := NULL;

Line 590: IF (l_lpov_rec.adder_rate = Okc_Api.G_MISS_NUM ) THEN

586: END IF;
587: IF (l_lpov_rec.late_int_rate = Okc_Api.G_MISS_NUM ) THEN
588: l_lpov_rec.late_int_rate := NULL;
589: END IF;
590: IF (l_lpov_rec.adder_rate = Okc_Api.G_MISS_NUM ) THEN
591: l_lpov_rec.adder_rate := NULL;
592: END IF;
593: IF (l_lpov_rec.late_int_grace_period = Okc_Api.G_MISS_NUM ) THEN
594: l_lpov_rec.late_int_grace_period := NULL;

Line 593: IF (l_lpov_rec.late_int_grace_period = Okc_Api.G_MISS_NUM ) THEN

589: END IF;
590: IF (l_lpov_rec.adder_rate = Okc_Api.G_MISS_NUM ) THEN
591: l_lpov_rec.adder_rate := NULL;
592: END IF;
593: IF (l_lpov_rec.late_int_grace_period = Okc_Api.G_MISS_NUM ) THEN
594: l_lpov_rec.late_int_grace_period := NULL;
595: END IF;
596: IF (l_lpov_rec.late_int_minimum_balance = Okc_Api.G_MISS_NUM ) THEN
597: l_lpov_rec.late_int_minimum_balance := NULL;

Line 596: IF (l_lpov_rec.late_int_minimum_balance = Okc_Api.G_MISS_NUM ) THEN

592: END IF;
593: IF (l_lpov_rec.late_int_grace_period = Okc_Api.G_MISS_NUM ) THEN
594: l_lpov_rec.late_int_grace_period := NULL;
595: END IF;
596: IF (l_lpov_rec.late_int_minimum_balance = Okc_Api.G_MISS_NUM ) THEN
597: l_lpov_rec.late_int_minimum_balance := NULL;
598: END IF;
599: IF (l_lpov_rec.minimum_late_interest = Okc_Api.G_MISS_NUM ) THEN
600: l_lpov_rec.minimum_late_interest := NULL;

Line 599: IF (l_lpov_rec.minimum_late_interest = Okc_Api.G_MISS_NUM ) THEN

595: END IF;
596: IF (l_lpov_rec.late_int_minimum_balance = Okc_Api.G_MISS_NUM ) THEN
597: l_lpov_rec.late_int_minimum_balance := NULL;
598: END IF;
599: IF (l_lpov_rec.minimum_late_interest = Okc_Api.G_MISS_NUM ) THEN
600: l_lpov_rec.minimum_late_interest := NULL;
601: END IF;
602: IF (l_lpov_rec.maximum_late_interest = Okc_Api.G_MISS_NUM ) THEN
603: l_lpov_rec.maximum_late_interest := NULL;

Line 602: IF (l_lpov_rec.maximum_late_interest = Okc_Api.G_MISS_NUM ) THEN

598: END IF;
599: IF (l_lpov_rec.minimum_late_interest = Okc_Api.G_MISS_NUM ) THEN
600: l_lpov_rec.minimum_late_interest := NULL;
601: END IF;
602: IF (l_lpov_rec.maximum_late_interest = Okc_Api.G_MISS_NUM ) THEN
603: l_lpov_rec.maximum_late_interest := NULL;
604: END IF;
605: IF (l_lpov_rec.attribute_category = Okc_Api.G_MISS_CHAR ) THEN
606: l_lpov_rec.attribute_category := NULL;

Line 605: IF (l_lpov_rec.attribute_category = Okc_Api.G_MISS_CHAR ) THEN

601: END IF;
602: IF (l_lpov_rec.maximum_late_interest = Okc_Api.G_MISS_NUM ) THEN
603: l_lpov_rec.maximum_late_interest := NULL;
604: END IF;
605: IF (l_lpov_rec.attribute_category = Okc_Api.G_MISS_CHAR ) THEN
606: l_lpov_rec.attribute_category := NULL;
607: END IF;
608: IF (l_lpov_rec.attribute1 = Okc_Api.G_MISS_CHAR ) THEN
609: l_lpov_rec.attribute1 := NULL;

Line 608: IF (l_lpov_rec.attribute1 = Okc_Api.G_MISS_CHAR ) THEN

604: END IF;
605: IF (l_lpov_rec.attribute_category = Okc_Api.G_MISS_CHAR ) THEN
606: l_lpov_rec.attribute_category := NULL;
607: END IF;
608: IF (l_lpov_rec.attribute1 = Okc_Api.G_MISS_CHAR ) THEN
609: l_lpov_rec.attribute1 := NULL;
610: END IF;
611: IF (l_lpov_rec.attribute2 = Okc_Api.G_MISS_CHAR ) THEN
612: l_lpov_rec.attribute2 := NULL;

Line 611: IF (l_lpov_rec.attribute2 = Okc_Api.G_MISS_CHAR ) THEN

607: END IF;
608: IF (l_lpov_rec.attribute1 = Okc_Api.G_MISS_CHAR ) THEN
609: l_lpov_rec.attribute1 := NULL;
610: END IF;
611: IF (l_lpov_rec.attribute2 = Okc_Api.G_MISS_CHAR ) THEN
612: l_lpov_rec.attribute2 := NULL;
613: END IF;
614: IF (l_lpov_rec.attribute3 = Okc_Api.G_MISS_CHAR ) THEN
615: l_lpov_rec.attribute3 := NULL;

Line 614: IF (l_lpov_rec.attribute3 = Okc_Api.G_MISS_CHAR ) THEN

610: END IF;
611: IF (l_lpov_rec.attribute2 = Okc_Api.G_MISS_CHAR ) THEN
612: l_lpov_rec.attribute2 := NULL;
613: END IF;
614: IF (l_lpov_rec.attribute3 = Okc_Api.G_MISS_CHAR ) THEN
615: l_lpov_rec.attribute3 := NULL;
616: END IF;
617: IF (l_lpov_rec.attribute4 = Okc_Api.G_MISS_CHAR ) THEN
618: l_lpov_rec.attribute4 := NULL;

Line 617: IF (l_lpov_rec.attribute4 = Okc_Api.G_MISS_CHAR ) THEN

613: END IF;
614: IF (l_lpov_rec.attribute3 = Okc_Api.G_MISS_CHAR ) THEN
615: l_lpov_rec.attribute3 := NULL;
616: END IF;
617: IF (l_lpov_rec.attribute4 = Okc_Api.G_MISS_CHAR ) THEN
618: l_lpov_rec.attribute4 := NULL;
619: END IF;
620: IF (l_lpov_rec.attribute5 = Okc_Api.G_MISS_CHAR ) THEN
621: l_lpov_rec.attribute5 := NULL;

Line 620: IF (l_lpov_rec.attribute5 = Okc_Api.G_MISS_CHAR ) THEN

616: END IF;
617: IF (l_lpov_rec.attribute4 = Okc_Api.G_MISS_CHAR ) THEN
618: l_lpov_rec.attribute4 := NULL;
619: END IF;
620: IF (l_lpov_rec.attribute5 = Okc_Api.G_MISS_CHAR ) THEN
621: l_lpov_rec.attribute5 := NULL;
622: END IF;
623: IF (l_lpov_rec.attribute6 = Okc_Api.G_MISS_CHAR ) THEN
624: l_lpov_rec.attribute6 := NULL;

Line 623: IF (l_lpov_rec.attribute6 = Okc_Api.G_MISS_CHAR ) THEN

619: END IF;
620: IF (l_lpov_rec.attribute5 = Okc_Api.G_MISS_CHAR ) THEN
621: l_lpov_rec.attribute5 := NULL;
622: END IF;
623: IF (l_lpov_rec.attribute6 = Okc_Api.G_MISS_CHAR ) THEN
624: l_lpov_rec.attribute6 := NULL;
625: END IF;
626: IF (l_lpov_rec.attribute7 = Okc_Api.G_MISS_CHAR ) THEN
627: l_lpov_rec.attribute7 := NULL;

Line 626: IF (l_lpov_rec.attribute7 = Okc_Api.G_MISS_CHAR ) THEN

622: END IF;
623: IF (l_lpov_rec.attribute6 = Okc_Api.G_MISS_CHAR ) THEN
624: l_lpov_rec.attribute6 := NULL;
625: END IF;
626: IF (l_lpov_rec.attribute7 = Okc_Api.G_MISS_CHAR ) THEN
627: l_lpov_rec.attribute7 := NULL;
628: END IF;
629: IF (l_lpov_rec.attribute8 = Okc_Api.G_MISS_CHAR ) THEN
630: l_lpov_rec.attribute8 := NULL;

Line 629: IF (l_lpov_rec.attribute8 = Okc_Api.G_MISS_CHAR ) THEN

625: END IF;
626: IF (l_lpov_rec.attribute7 = Okc_Api.G_MISS_CHAR ) THEN
627: l_lpov_rec.attribute7 := NULL;
628: END IF;
629: IF (l_lpov_rec.attribute8 = Okc_Api.G_MISS_CHAR ) THEN
630: l_lpov_rec.attribute8 := NULL;
631: END IF;
632: IF (l_lpov_rec.attribute9 = Okc_Api.G_MISS_CHAR ) THEN
633: l_lpov_rec.attribute9 := NULL;

Line 632: IF (l_lpov_rec.attribute9 = Okc_Api.G_MISS_CHAR ) THEN

628: END IF;
629: IF (l_lpov_rec.attribute8 = Okc_Api.G_MISS_CHAR ) THEN
630: l_lpov_rec.attribute8 := NULL;
631: END IF;
632: IF (l_lpov_rec.attribute9 = Okc_Api.G_MISS_CHAR ) THEN
633: l_lpov_rec.attribute9 := NULL;
634: END IF;
635: IF (l_lpov_rec.attribute10 = Okc_Api.G_MISS_CHAR ) THEN
636: l_lpov_rec.attribute10 := NULL;

Line 635: IF (l_lpov_rec.attribute10 = Okc_Api.G_MISS_CHAR ) THEN

631: END IF;
632: IF (l_lpov_rec.attribute9 = Okc_Api.G_MISS_CHAR ) THEN
633: l_lpov_rec.attribute9 := NULL;
634: END IF;
635: IF (l_lpov_rec.attribute10 = Okc_Api.G_MISS_CHAR ) THEN
636: l_lpov_rec.attribute10 := NULL;
637: END IF;
638: IF (l_lpov_rec.attribute11 = Okc_Api.G_MISS_CHAR ) THEN
639: l_lpov_rec.attribute11 := NULL;

Line 638: IF (l_lpov_rec.attribute11 = Okc_Api.G_MISS_CHAR ) THEN

634: END IF;
635: IF (l_lpov_rec.attribute10 = Okc_Api.G_MISS_CHAR ) THEN
636: l_lpov_rec.attribute10 := NULL;
637: END IF;
638: IF (l_lpov_rec.attribute11 = Okc_Api.G_MISS_CHAR ) THEN
639: l_lpov_rec.attribute11 := NULL;
640: END IF;
641: IF (l_lpov_rec.attribute12 = Okc_Api.G_MISS_CHAR ) THEN
642: l_lpov_rec.attribute12 := NULL;

Line 641: IF (l_lpov_rec.attribute12 = Okc_Api.G_MISS_CHAR ) THEN

637: END IF;
638: IF (l_lpov_rec.attribute11 = Okc_Api.G_MISS_CHAR ) THEN
639: l_lpov_rec.attribute11 := NULL;
640: END IF;
641: IF (l_lpov_rec.attribute12 = Okc_Api.G_MISS_CHAR ) THEN
642: l_lpov_rec.attribute12 := NULL;
643: END IF;
644: IF (l_lpov_rec.attribute13 = Okc_Api.G_MISS_CHAR ) THEN
645: l_lpov_rec.attribute13 := NULL;

Line 644: IF (l_lpov_rec.attribute13 = Okc_Api.G_MISS_CHAR ) THEN

640: END IF;
641: IF (l_lpov_rec.attribute12 = Okc_Api.G_MISS_CHAR ) THEN
642: l_lpov_rec.attribute12 := NULL;
643: END IF;
644: IF (l_lpov_rec.attribute13 = Okc_Api.G_MISS_CHAR ) THEN
645: l_lpov_rec.attribute13 := NULL;
646: END IF;
647: IF (l_lpov_rec.attribute14 = Okc_Api.G_MISS_CHAR ) THEN
648: l_lpov_rec.attribute14 := NULL;

Line 647: IF (l_lpov_rec.attribute14 = Okc_Api.G_MISS_CHAR ) THEN

643: END IF;
644: IF (l_lpov_rec.attribute13 = Okc_Api.G_MISS_CHAR ) THEN
645: l_lpov_rec.attribute13 := NULL;
646: END IF;
647: IF (l_lpov_rec.attribute14 = Okc_Api.G_MISS_CHAR ) THEN
648: l_lpov_rec.attribute14 := NULL;
649: END IF;
650: IF (l_lpov_rec.attribute15 = Okc_Api.G_MISS_CHAR ) THEN
651: l_lpov_rec.attribute15 := NULL;

Line 650: IF (l_lpov_rec.attribute15 = Okc_Api.G_MISS_CHAR ) THEN

646: END IF;
647: IF (l_lpov_rec.attribute14 = Okc_Api.G_MISS_CHAR ) THEN
648: l_lpov_rec.attribute14 := NULL;
649: END IF;
650: IF (l_lpov_rec.attribute15 = Okc_Api.G_MISS_CHAR ) THEN
651: l_lpov_rec.attribute15 := NULL;
652: END IF;
653: IF (l_lpov_rec.created_by = Okc_Api.G_MISS_NUM ) THEN
654: l_lpov_rec.created_by := NULL;

Line 653: IF (l_lpov_rec.created_by = Okc_Api.G_MISS_NUM ) THEN

649: END IF;
650: IF (l_lpov_rec.attribute15 = Okc_Api.G_MISS_CHAR ) THEN
651: l_lpov_rec.attribute15 := NULL;
652: END IF;
653: IF (l_lpov_rec.created_by = Okc_Api.G_MISS_NUM ) THEN
654: l_lpov_rec.created_by := NULL;
655: END IF;
656: IF (l_lpov_rec.creation_date = Okc_Api.G_MISS_DATE ) THEN
657: l_lpov_rec.creation_date := NULL;

Line 656: IF (l_lpov_rec.creation_date = Okc_Api.G_MISS_DATE ) THEN

652: END IF;
653: IF (l_lpov_rec.created_by = Okc_Api.G_MISS_NUM ) THEN
654: l_lpov_rec.created_by := NULL;
655: END IF;
656: IF (l_lpov_rec.creation_date = Okc_Api.G_MISS_DATE ) THEN
657: l_lpov_rec.creation_date := NULL;
658: END IF;
659: IF (l_lpov_rec.last_updated_by = Okc_Api.G_MISS_NUM ) THEN
660: l_lpov_rec.last_updated_by := NULL;

Line 659: IF (l_lpov_rec.last_updated_by = Okc_Api.G_MISS_NUM ) THEN

655: END IF;
656: IF (l_lpov_rec.creation_date = Okc_Api.G_MISS_DATE ) THEN
657: l_lpov_rec.creation_date := NULL;
658: END IF;
659: IF (l_lpov_rec.last_updated_by = Okc_Api.G_MISS_NUM ) THEN
660: l_lpov_rec.last_updated_by := NULL;
661: END IF;
662: IF (l_lpov_rec.last_update_date = Okc_Api.G_MISS_DATE ) THEN
663: l_lpov_rec.last_update_date := NULL;

Line 662: IF (l_lpov_rec.last_update_date = Okc_Api.G_MISS_DATE ) THEN

658: END IF;
659: IF (l_lpov_rec.last_updated_by = Okc_Api.G_MISS_NUM ) THEN
660: l_lpov_rec.last_updated_by := NULL;
661: END IF;
662: IF (l_lpov_rec.last_update_date = Okc_Api.G_MISS_DATE ) THEN
663: l_lpov_rec.last_update_date := NULL;
664: END IF;
665: IF (l_lpov_rec.last_update_login = Okc_Api.G_MISS_NUM ) THEN
666: l_lpov_rec.last_update_login := NULL;

Line 665: IF (l_lpov_rec.last_update_login = Okc_Api.G_MISS_NUM ) THEN

661: END IF;
662: IF (l_lpov_rec.last_update_date = Okc_Api.G_MISS_DATE ) THEN
663: l_lpov_rec.last_update_date := NULL;
664: END IF;
665: IF (l_lpov_rec.last_update_login = Okc_Api.G_MISS_NUM ) THEN
666: l_lpov_rec.last_update_login := NULL;
667: END IF;
668: IF (l_lpov_rec.days_in_year = Okc_Api.G_MISS_CHAR ) THEN
669: l_lpov_rec.days_in_year := NULL;

Line 668: IF (l_lpov_rec.days_in_year = Okc_Api.G_MISS_CHAR ) THEN

664: END IF;
665: IF (l_lpov_rec.last_update_login = Okc_Api.G_MISS_NUM ) THEN
666: l_lpov_rec.last_update_login := NULL;
667: END IF;
668: IF (l_lpov_rec.days_in_year = Okc_Api.G_MISS_CHAR ) THEN
669: l_lpov_rec.days_in_year := NULL;
670: END IF;
671: RETURN(l_lpov_rec);
672: END null_out_defaults;

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

678: -------------------------------------------------
679: FUNCTION Validate_Attributes (
680: p_lpov_rec IN lpov_rec_type
681: ) RETURN VARCHAR2 IS
682: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
683: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
684: BEGIN
685: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
686: Okc_Util.ADD_VIEW('OKL_LATE_POLICIES_V', x_return_status);

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

679: FUNCTION Validate_Attributes (
680: p_lpov_rec IN lpov_rec_type
681: ) RETURN VARCHAR2 IS
682: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
683: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
684: BEGIN
685: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
686: Okc_Util.ADD_VIEW('OKL_LATE_POLICIES_V', x_return_status);
687: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

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

683: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
684: BEGIN
685: -- Call OKC_UTIL.ADD_VIEW to prepare the PL/SQL table to hold columns of view
686: Okc_Util.ADD_VIEW('OKL_LATE_POLICIES_V', x_return_status);
687: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
688: l_return_status := x_return_status;
689: RAISE G_EXCEPTION_HALT_VALIDATION;
690: END IF;
691: -----------------------------

Line 751: Okc_Api.SET_MESSAGE( p_app_name => G_APP_NAME

747: EXCEPTION
748: WHEN G_EXCEPTION_HALT_VALIDATION THEN
749: RETURN(l_return_status);
750: WHEN OTHERS THEN
751: Okc_Api.SET_MESSAGE( p_app_name => G_APP_NAME
752: ,p_msg_name => G_UNEXPECTED_ERROR
753: ,p_token1 => G_SQLCODE_TOKEN
754: ,p_token1_value => SQLCODE
755: ,p_token2 => G_SQLERRM_TOKEN

Line 757: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

753: ,p_token1 => G_SQLCODE_TOKEN
754: ,p_token1_value => SQLCODE
755: ,p_token2 => G_SQLERRM_TOKEN
756: ,p_token2_value => SQLERRM);
757: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
758: RETURN(l_return_status);
759: END Validate_Attributes;
760: ---------------------------------------------------------------------------
761: -- PROCEDURE Validate_Record

Line 937: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

933: -- validate_row for:OKL_LATE_POLICIES_V --
934: ------------------------------------------
935: PROCEDURE validate_row(
936: p_api_version IN NUMBER,
937: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
938: x_return_status OUT NOCOPY VARCHAR2,
939: x_msg_count OUT NOCOPY NUMBER,
940: x_msg_data OUT NOCOPY VARCHAR2,
941: p_lpov_rec IN lpov_rec_type) IS

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

941: p_lpov_rec IN lpov_rec_type) IS
942:
943: l_api_version CONSTANT NUMBER := 1;
944: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
945: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
946: l_lpov_rec lpov_rec_type := p_lpov_rec;
947: l_lpo_rec lpo_rec_type;
948: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
949: BEGIN

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

946: l_lpov_rec lpov_rec_type := p_lpov_rec;
947: l_lpo_rec lpo_rec_type;
948: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
949: BEGIN
950: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
951: G_PKG_NAME,
952: p_init_msg_list,
953: l_api_version,
954: p_api_version,

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

953: l_api_version,
954: p_api_version,
955: '_PVT',
956: x_return_status);
957: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
958: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
959: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
960: RAISE Okc_Api.G_EXCEPTION_ERROR;
961: END IF;

Line 958: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

954: p_api_version,
955: '_PVT',
956: x_return_status);
957: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
958: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
959: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
960: RAISE Okc_Api.G_EXCEPTION_ERROR;
961: END IF;
962: --- Validate all non-missing attributes (Item Level Validation)

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

955: '_PVT',
956: x_return_status);
957: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
958: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
959: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
960: RAISE Okc_Api.G_EXCEPTION_ERROR;
961: END IF;
962: --- Validate all non-missing attributes (Item Level Validation)
963: l_return_status := Validate_Attributes(l_lpov_rec);

Line 960: RAISE Okc_Api.G_EXCEPTION_ERROR;

956: x_return_status);
957: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
958: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
959: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
960: RAISE Okc_Api.G_EXCEPTION_ERROR;
961: END IF;
962: --- Validate all non-missing attributes (Item Level Validation)
963: l_return_status := Validate_Attributes(l_lpov_rec);
964: --- If any errors happen abort API

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

961: END IF;
962: --- Validate all non-missing attributes (Item Level Validation)
963: l_return_status := Validate_Attributes(l_lpov_rec);
964: --- If any errors happen abort API
965: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
966: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
967: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
968: RAISE Okc_Api.G_EXCEPTION_ERROR;
969: END IF;

Line 966: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

962: --- Validate all non-missing attributes (Item Level Validation)
963: l_return_status := Validate_Attributes(l_lpov_rec);
964: --- If any errors happen abort API
965: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
966: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
967: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
968: RAISE Okc_Api.G_EXCEPTION_ERROR;
969: END IF;
970: l_return_status := Validate_Record(l_lpov_rec);

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

963: l_return_status := Validate_Attributes(l_lpov_rec);
964: --- If any errors happen abort API
965: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
966: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
967: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
968: RAISE Okc_Api.G_EXCEPTION_ERROR;
969: END IF;
970: l_return_status := Validate_Record(l_lpov_rec);
971: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 968: RAISE Okc_Api.G_EXCEPTION_ERROR;

964: --- If any errors happen abort API
965: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
966: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
967: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
968: RAISE Okc_Api.G_EXCEPTION_ERROR;
969: END IF;
970: l_return_status := Validate_Record(l_lpov_rec);
971: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
972: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

967: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
968: RAISE Okc_Api.G_EXCEPTION_ERROR;
969: END IF;
970: l_return_status := Validate_Record(l_lpov_rec);
971: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
972: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
973: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
974: RAISE Okc_Api.G_EXCEPTION_ERROR;
975: END IF;

Line 972: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

968: RAISE Okc_Api.G_EXCEPTION_ERROR;
969: END IF;
970: l_return_status := Validate_Record(l_lpov_rec);
971: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
972: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
973: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
974: RAISE Okc_Api.G_EXCEPTION_ERROR;
975: END IF;
976: x_return_status := l_return_status;

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

969: END IF;
970: l_return_status := Validate_Record(l_lpov_rec);
971: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
972: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
973: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
974: RAISE Okc_Api.G_EXCEPTION_ERROR;
975: END IF;
976: x_return_status := l_return_status;
977: EXCEPTION

Line 974: RAISE Okc_Api.G_EXCEPTION_ERROR;

970: l_return_status := Validate_Record(l_lpov_rec);
971: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
972: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
973: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
974: RAISE Okc_Api.G_EXCEPTION_ERROR;
975: END IF;
976: x_return_status := l_return_status;
977: EXCEPTION
978: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 978: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

974: RAISE Okc_Api.G_EXCEPTION_ERROR;
975: END IF;
976: x_return_status := l_return_status;
977: EXCEPTION
978: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
979: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
980: (
981: l_api_name,
982: G_PKG_NAME,

Line 979: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

975: END IF;
976: x_return_status := l_return_status;
977: EXCEPTION
978: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
979: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
980: (
981: l_api_name,
982: G_PKG_NAME,
983: 'OKC_API.G_RET_STS_ERROR',

Line 983: 'OKC_API.G_RET_STS_ERROR',

979: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
980: (
981: l_api_name,
982: G_PKG_NAME,
983: 'OKC_API.G_RET_STS_ERROR',
984: x_msg_count,
985: x_msg_data,
986: '_PVT'
987: );

Line 988: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

984: x_msg_count,
985: x_msg_data,
986: '_PVT'
987: );
988: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
989: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
990: (
991: l_api_name,
992: G_PKG_NAME,

Line 989: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

985: x_msg_data,
986: '_PVT'
987: );
988: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
989: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
990: (
991: l_api_name,
992: G_PKG_NAME,
993: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 993: 'OKC_API.G_RET_STS_UNEXP_ERROR',

989: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
990: (
991: l_api_name,
992: G_PKG_NAME,
993: 'OKC_API.G_RET_STS_UNEXP_ERROR',
994: x_msg_count,
995: x_msg_data,
996: '_PVT'
997: );

Line 999: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

995: x_msg_data,
996: '_PVT'
997: );
998: WHEN OTHERS THEN
999: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1000: (
1001: l_api_name,
1002: G_PKG_NAME,
1003: 'OTHERS',

Line 1018: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1014: -- PL/SQL TBL validate_row for:OKL_LATE_POLICIES_V --
1015: -----------------------------------------------------
1016: PROCEDURE validate_row(
1017: p_api_version IN NUMBER,
1018: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1019: x_return_status OUT NOCOPY VARCHAR2,
1020: x_msg_count OUT NOCOPY NUMBER,
1021: x_msg_data OUT NOCOPY VARCHAR2,
1022: p_lpov_tbl IN lpov_tbl_type) IS

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

1023:
1024: l_api_version CONSTANT NUMBER := 1;
1025: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1026: i NUMBER := 0;
1027: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1028: BEGIN
1029: Okc_Api.init_msg_list(p_init_msg_list);
1030: -- Make sure PL/SQL table has records in it before passing
1031: IF (p_lpov_tbl.COUNT > 0) THEN

Line 1029: Okc_Api.init_msg_list(p_init_msg_list);

1025: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1026: i NUMBER := 0;
1027: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1028: BEGIN
1029: Okc_Api.init_msg_list(p_init_msg_list);
1030: -- Make sure PL/SQL table has records in it before passing
1031: IF (p_lpov_tbl.COUNT > 0) THEN
1032: i := p_lpov_tbl.FIRST;
1033: LOOP

Line 1035: p_init_msg_list => Okc_Api.G_FALSE,

1031: IF (p_lpov_tbl.COUNT > 0) THEN
1032: i := p_lpov_tbl.FIRST;
1033: LOOP
1034: validate_row (p_api_version => p_api_version,
1035: p_init_msg_list => Okc_Api.G_FALSE,
1036: x_return_status => x_return_status,
1037: x_msg_count => x_msg_count,
1038: x_msg_data => x_msg_data,
1039: p_lpov_rec => p_lpov_tbl(i));

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

1040: EXIT WHEN (i = p_lpov_tbl.LAST);
1041: i := p_lpov_tbl.NEXT(i);
1042: END LOOP;
1043: END IF;
1044: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1045: EXCEPTION
1046: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1047: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1048: (

Line 1046: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1042: END LOOP;
1043: END IF;
1044: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1045: EXCEPTION
1046: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1047: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1048: (
1049: l_api_name,
1050: G_PKG_NAME,

Line 1047: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 1051: 'OKC_API.G_RET_STS_ERROR',

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

Line 1056: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1057: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 1061: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1067: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 1085: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1081: ----------------------------------------
1082: -- insert_row for:OKL_LATE_POLICIES_B --
1083: ----------------------------------------
1084: PROCEDURE insert_row(
1085: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1086: x_return_status OUT NOCOPY VARCHAR2,
1087: x_msg_count OUT NOCOPY NUMBER,
1088: x_msg_data OUT NOCOPY VARCHAR2,
1089: p_lpo_rec IN lpo_rec_type,

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

1090: x_lpo_rec OUT NOCOPY lpo_rec_type) IS
1091:
1092: l_api_version CONSTANT NUMBER := 1;
1093: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1094: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1095: l_lpo_rec lpo_rec_type := p_lpo_rec;
1096: l_def_lpo_rec lpo_rec_type;
1097: --------------------------------------------
1098: -- Set_Attributes for:OKL_LATE_POLICIES_B --

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

1100: FUNCTION Set_Attributes (
1101: p_lpo_rec IN lpo_rec_type,
1102: x_lpo_rec OUT NOCOPY lpo_rec_type
1103: ) RETURN VARCHAR2 IS
1104: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1105: BEGIN
1106: x_lpo_rec := p_lpo_rec;
1107: RETURN(l_return_status);
1108: END Set_Attributes;

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

1106: x_lpo_rec := p_lpo_rec;
1107: RETURN(l_return_status);
1108: END Set_Attributes;
1109: BEGIN
1110: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1111: p_init_msg_list,
1112: '_PVT',
1113: x_return_status);
1114: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

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

Line 1115: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1117: RAISE Okc_Api.G_EXCEPTION_ERROR;

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

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

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

Line 1125: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1121: p_lpo_rec, -- IN
1122: l_lpo_rec); -- OUT
1123: --- If any errors happen abort API
1124: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1125: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1126: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1127: RAISE Okc_Api.G_EXCEPTION_ERROR;
1128: END IF;
1129: INSERT INTO OKL_LATE_POLICIES_B(

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

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

Line 1127: RAISE Okc_Api.G_EXCEPTION_ERROR;

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

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

1220: l_lpo_rec.days_in_year);
1221: -- Set OUT values
1222: x_lpo_rec := l_lpo_rec;
1223: x_return_status := l_return_status;
1224: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1225: EXCEPTION
1226: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1227: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1228: (

Line 1226: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1222: x_lpo_rec := l_lpo_rec;
1223: x_return_status := l_return_status;
1224: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1225: EXCEPTION
1226: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1227: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1228: (
1229: l_api_name,
1230: G_PKG_NAME,

Line 1227: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1223: x_return_status := l_return_status;
1224: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1225: EXCEPTION
1226: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1227: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1228: (
1229: l_api_name,
1230: G_PKG_NAME,
1231: 'OKC_API.G_RET_STS_ERROR',

Line 1231: 'OKC_API.G_RET_STS_ERROR',

1227: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1228: (
1229: l_api_name,
1230: G_PKG_NAME,
1231: 'OKC_API.G_RET_STS_ERROR',
1232: x_msg_count,
1233: x_msg_data,
1234: '_PVT'
1235: );

Line 1236: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1232: x_msg_count,
1233: x_msg_data,
1234: '_PVT'
1235: );
1236: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1237: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1238: (
1239: l_api_name,
1240: G_PKG_NAME,

Line 1237: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1233: x_msg_data,
1234: '_PVT'
1235: );
1236: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1237: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1238: (
1239: l_api_name,
1240: G_PKG_NAME,
1241: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1241: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1247: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 1261: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1257: -----------------------------------------
1258: -- insert_row for:OKL_LATE_POLICIES_TL --
1259: -----------------------------------------
1260: PROCEDURE insert_row(
1261: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1262: x_return_status OUT NOCOPY VARCHAR2,
1263: x_msg_count OUT NOCOPY NUMBER,
1264: x_msg_data OUT NOCOPY VARCHAR2,
1265: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,

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

1266: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type) IS
1267:
1268: l_api_version CONSTANT NUMBER := 1;
1269: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1270: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1271: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type := p_okl_late_policies_tl_rec;
1272: l_def_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
1273: CURSOR get_languages IS
1274: SELECT *

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

1280: FUNCTION Set_Attributes (
1281: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
1282: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type
1283: ) RETURN VARCHAR2 IS
1284: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1285: BEGIN
1286: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;
1287: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');
1288: x_okl_late_policies_tl_rec.SOURCE_LANG := USERENV('LANG');

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

1288: x_okl_late_policies_tl_rec.SOURCE_LANG := USERENV('LANG');
1289: RETURN(l_return_status);
1290: END Set_Attributes;
1291: BEGIN
1292: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1293: p_init_msg_list,
1294: '_PVT',
1295: x_return_status);
1296: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

1292: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1293: p_init_msg_list,
1294: '_PVT',
1295: x_return_status);
1296: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1297: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1298: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1299: RAISE Okc_Api.G_EXCEPTION_ERROR;
1300: END IF;

Line 1297: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1293: p_init_msg_list,
1294: '_PVT',
1295: x_return_status);
1296: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1297: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1298: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1299: RAISE Okc_Api.G_EXCEPTION_ERROR;
1300: END IF;
1301: --- Setting item attributes

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

1294: '_PVT',
1295: x_return_status);
1296: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1297: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1298: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1299: RAISE Okc_Api.G_EXCEPTION_ERROR;
1300: END IF;
1301: --- Setting item attributes
1302: l_return_status := Set_Attributes(

Line 1299: RAISE Okc_Api.G_EXCEPTION_ERROR;

1295: x_return_status);
1296: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1297: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1298: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1299: RAISE Okc_Api.G_EXCEPTION_ERROR;
1300: END IF;
1301: --- Setting item attributes
1302: l_return_status := Set_Attributes(
1303: p_okl_late_policies_tl_rec, -- IN

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

1302: l_return_status := Set_Attributes(
1303: p_okl_late_policies_tl_rec, -- IN
1304: l_okl_late_policies_tl_rec); -- OUT
1305: --- If any errors happen abort API
1306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1309: RAISE Okc_Api.G_EXCEPTION_ERROR;
1310: END IF;

Line 1307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1303: p_okl_late_policies_tl_rec, -- IN
1304: l_okl_late_policies_tl_rec); -- OUT
1305: --- If any errors happen abort API
1306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1309: RAISE Okc_Api.G_EXCEPTION_ERROR;
1310: END IF;
1311: FOR l_lang_rec IN get_languages LOOP

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

1304: l_okl_late_policies_tl_rec); -- OUT
1305: --- If any errors happen abort API
1306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1309: RAISE Okc_Api.G_EXCEPTION_ERROR;
1310: END IF;
1311: FOR l_lang_rec IN get_languages LOOP
1312: l_okl_late_policies_tl_rec.LANGUAGE := l_lang_rec.language_code;

Line 1309: RAISE Okc_Api.G_EXCEPTION_ERROR;

1305: --- If any errors happen abort API
1306: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1309: RAISE Okc_Api.G_EXCEPTION_ERROR;
1310: END IF;
1311: FOR l_lang_rec IN get_languages LOOP
1312: l_okl_late_policies_tl_rec.LANGUAGE := l_lang_rec.language_code;
1313: INSERT INTO OKL_LATE_POLICIES_TL(

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

1335: END LOOP;
1336: -- Set OUT values
1337: x_okl_late_policies_tl_rec := l_okl_late_policies_tl_rec;
1338: x_return_status := l_return_status;
1339: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1340: EXCEPTION
1341: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1342: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1343: (

Line 1341: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

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

Line 1342: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 1346: 'OKC_API.G_RET_STS_ERROR',

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

Line 1351: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1352: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 1356: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1362: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 1377: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1373: -- insert_row for :OKL_LATE_POLICIES_V --
1374: -----------------------------------------
1375: PROCEDURE insert_row(
1376: p_api_version IN NUMBER,
1377: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1378: x_return_status OUT NOCOPY VARCHAR2,
1379: x_msg_count OUT NOCOPY NUMBER,
1380: x_msg_data OUT NOCOPY VARCHAR2,
1381: p_lpov_rec IN lpov_rec_type,

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

1382: x_lpov_rec OUT NOCOPY lpov_rec_type) IS
1383:
1384: l_api_version CONSTANT NUMBER := 1;
1385: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1386: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1387: l_lpov_rec lpov_rec_type := p_lpov_rec;
1388: l_def_lpov_rec lpov_rec_type;
1389: l_lpo_rec lpo_rec_type;
1390: lx_lpo_rec lpo_rec_type;

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

1411: FUNCTION Set_Attributes (
1412: p_lpov_rec IN lpov_rec_type,
1413: x_lpov_rec OUT NOCOPY lpov_rec_type
1414: ) RETURN VARCHAR2 IS
1415: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1416: BEGIN
1417: x_lpov_rec := p_lpov_rec;
1418: x_lpov_rec.OBJECT_VERSION_NUMBER := 1;
1419: RETURN(l_return_status);

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

1418: x_lpov_rec.OBJECT_VERSION_NUMBER := 1;
1419: RETURN(l_return_status);
1420: END Set_Attributes;
1421: BEGIN
1422: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1423: G_PKG_NAME,
1424: p_init_msg_list,
1425: l_api_version,
1426: p_api_version,

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

1425: l_api_version,
1426: p_api_version,
1427: '_PVT',
1428: x_return_status);
1429: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1430: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1431: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1432: RAISE Okc_Api.G_EXCEPTION_ERROR;
1433: END IF;

Line 1430: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1426: p_api_version,
1427: '_PVT',
1428: x_return_status);
1429: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1430: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1431: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1432: RAISE Okc_Api.G_EXCEPTION_ERROR;
1433: END IF;
1434: l_lpov_rec := null_out_defaults(p_lpov_rec);

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

1427: '_PVT',
1428: x_return_status);
1429: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1430: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1431: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1432: RAISE Okc_Api.G_EXCEPTION_ERROR;
1433: END IF;
1434: l_lpov_rec := null_out_defaults(p_lpov_rec);
1435: -- Set primary key value

Line 1432: RAISE Okc_Api.G_EXCEPTION_ERROR;

1428: x_return_status);
1429: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1430: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1431: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1432: RAISE Okc_Api.G_EXCEPTION_ERROR;
1433: END IF;
1434: l_lpov_rec := null_out_defaults(p_lpov_rec);
1435: -- Set primary key value
1436: l_lpov_rec.ID := get_seq_id;

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

1438: l_return_Status := Set_Attributes(
1439: l_lpov_rec, -- IN
1440: l_def_lpov_rec); -- OUT
1441: --- If any errors happen abort API
1442: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1443: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1444: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1445: RAISE Okc_Api.G_EXCEPTION_ERROR;
1446: END IF;

Line 1443: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1439: l_lpov_rec, -- IN
1440: l_def_lpov_rec); -- OUT
1441: --- If any errors happen abort API
1442: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1443: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1444: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1445: RAISE Okc_Api.G_EXCEPTION_ERROR;
1446: END IF;
1447: l_def_lpov_rec := fill_who_columns(l_def_lpov_rec);

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

1440: l_def_lpov_rec); -- OUT
1441: --- If any errors happen abort API
1442: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1443: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1444: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1445: RAISE Okc_Api.G_EXCEPTION_ERROR;
1446: END IF;
1447: l_def_lpov_rec := fill_who_columns(l_def_lpov_rec);
1448: --- Validate all non-missing attributes (Item Level Validation)

Line 1445: RAISE Okc_Api.G_EXCEPTION_ERROR;

1441: --- If any errors happen abort API
1442: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1443: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1444: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1445: RAISE Okc_Api.G_EXCEPTION_ERROR;
1446: END IF;
1447: l_def_lpov_rec := fill_who_columns(l_def_lpov_rec);
1448: --- Validate all non-missing attributes (Item Level Validation)
1449: l_return_status := Validate_Attributes(l_def_lpov_rec);

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

1447: l_def_lpov_rec := fill_who_columns(l_def_lpov_rec);
1448: --- Validate all non-missing attributes (Item Level Validation)
1449: l_return_status := Validate_Attributes(l_def_lpov_rec);
1450: --- If any errors happen abort API
1451: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1452: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1453: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1454: RAISE Okc_Api.G_EXCEPTION_ERROR;
1455: END IF;

Line 1452: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1448: --- Validate all non-missing attributes (Item Level Validation)
1449: l_return_status := Validate_Attributes(l_def_lpov_rec);
1450: --- If any errors happen abort API
1451: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1452: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1453: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1454: RAISE Okc_Api.G_EXCEPTION_ERROR;
1455: END IF;
1456: l_return_status := Validate_Record(l_def_lpov_rec);

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

1449: l_return_status := Validate_Attributes(l_def_lpov_rec);
1450: --- If any errors happen abort API
1451: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1452: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1453: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1454: RAISE Okc_Api.G_EXCEPTION_ERROR;
1455: END IF;
1456: l_return_status := Validate_Record(l_def_lpov_rec);
1457: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1454: RAISE Okc_Api.G_EXCEPTION_ERROR;

1450: --- If any errors happen abort API
1451: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1452: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1453: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1454: RAISE Okc_Api.G_EXCEPTION_ERROR;
1455: END IF;
1456: l_return_status := Validate_Record(l_def_lpov_rec);
1457: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

1453: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1454: RAISE Okc_Api.G_EXCEPTION_ERROR;
1455: END IF;
1456: l_return_status := Validate_Record(l_def_lpov_rec);
1457: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1460: RAISE Okc_Api.G_EXCEPTION_ERROR;
1461: END IF;

Line 1458: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1454: RAISE Okc_Api.G_EXCEPTION_ERROR;
1455: END IF;
1456: l_return_status := Validate_Record(l_def_lpov_rec);
1457: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1460: RAISE Okc_Api.G_EXCEPTION_ERROR;
1461: END IF;
1462: -----------------------------------------

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

1455: END IF;
1456: l_return_status := Validate_Record(l_def_lpov_rec);
1457: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1460: RAISE Okc_Api.G_EXCEPTION_ERROR;
1461: END IF;
1462: -----------------------------------------
1463: -- Move VIEW record to "Child" records --

Line 1460: RAISE Okc_Api.G_EXCEPTION_ERROR;

1456: l_return_status := Validate_Record(l_def_lpov_rec);
1457: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1460: RAISE Okc_Api.G_EXCEPTION_ERROR;
1461: END IF;
1462: -----------------------------------------
1463: -- Move VIEW record to "Child" records --
1464: -----------------------------------------

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

1474: x_msg_data,
1475: l_lpo_rec,
1476: lx_lpo_rec
1477: );
1478: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1479: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1480: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1481: RAISE Okc_Api.G_EXCEPTION_ERROR;
1482: END IF;

Line 1479: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1475: l_lpo_rec,
1476: lx_lpo_rec
1477: );
1478: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1479: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1480: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1481: RAISE Okc_Api.G_EXCEPTION_ERROR;
1482: END IF;
1483: migrate(lx_lpo_rec, l_def_lpov_rec);

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

1476: lx_lpo_rec
1477: );
1478: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1479: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1480: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1481: RAISE Okc_Api.G_EXCEPTION_ERROR;
1482: END IF;
1483: migrate(lx_lpo_rec, l_def_lpov_rec);
1484: insert_row(

Line 1481: RAISE Okc_Api.G_EXCEPTION_ERROR;

1477: );
1478: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1479: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1480: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1481: RAISE Okc_Api.G_EXCEPTION_ERROR;
1482: END IF;
1483: migrate(lx_lpo_rec, l_def_lpov_rec);
1484: insert_row(
1485: p_init_msg_list,

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

1488: x_msg_data,
1489: l_okl_late_policies_tl_rec,
1490: lx_okl_late_policies_tl_rec
1491: );
1492: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1493: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1494: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1495: RAISE Okc_Api.G_EXCEPTION_ERROR;
1496: END IF;

Line 1493: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1489: l_okl_late_policies_tl_rec,
1490: lx_okl_late_policies_tl_rec
1491: );
1492: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1493: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1494: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1495: RAISE Okc_Api.G_EXCEPTION_ERROR;
1496: END IF;
1497: migrate(lx_okl_late_policies_tl_rec, l_def_lpov_rec);

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

1490: lx_okl_late_policies_tl_rec
1491: );
1492: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1493: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1494: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1495: RAISE Okc_Api.G_EXCEPTION_ERROR;
1496: END IF;
1497: migrate(lx_okl_late_policies_tl_rec, l_def_lpov_rec);
1498: -- Set OUT values

Line 1495: RAISE Okc_Api.G_EXCEPTION_ERROR;

1491: );
1492: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1493: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1494: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1495: RAISE Okc_Api.G_EXCEPTION_ERROR;
1496: END IF;
1497: migrate(lx_okl_late_policies_tl_rec, l_def_lpov_rec);
1498: -- Set OUT values
1499: x_lpov_rec := l_def_lpov_rec;

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

1497: migrate(lx_okl_late_policies_tl_rec, l_def_lpov_rec);
1498: -- Set OUT values
1499: x_lpov_rec := l_def_lpov_rec;
1500: x_return_status := l_return_status;
1501: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1502: EXCEPTION
1503: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1504: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1505: (

Line 1503: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1499: x_lpov_rec := l_def_lpov_rec;
1500: x_return_status := l_return_status;
1501: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1502: EXCEPTION
1503: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1504: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1505: (
1506: l_api_name,
1507: G_PKG_NAME,

Line 1504: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 1508: 'OKC_API.G_RET_STS_ERROR',

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

Line 1513: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1514: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 1518: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1524: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 1539: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1535: -- PL/SQL TBL insert_row for:LPOV_TBL --
1536: ----------------------------------------
1537: PROCEDURE insert_row(
1538: p_api_version IN NUMBER,
1539: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1540: x_return_status OUT NOCOPY VARCHAR2,
1541: x_msg_count OUT NOCOPY NUMBER,
1542: x_msg_data OUT NOCOPY VARCHAR2,
1543: p_lpov_tbl IN lpov_tbl_type,

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

1544: x_lpov_tbl OUT NOCOPY lpov_tbl_type) IS
1545:
1546: l_api_version CONSTANT NUMBER := 1;
1547: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1548: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1549: i NUMBER := 0;
1550: BEGIN
1551: Okc_Api.init_msg_list(p_init_msg_list);
1552: -- Make sure PL/SQL table has records in it before passing

Line 1551: Okc_Api.init_msg_list(p_init_msg_list);

1547: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1548: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1549: i NUMBER := 0;
1550: BEGIN
1551: Okc_Api.init_msg_list(p_init_msg_list);
1552: -- Make sure PL/SQL table has records in it before passing
1553: IF (p_lpov_tbl.COUNT > 0) THEN
1554: i := p_lpov_tbl.FIRST;
1555: LOOP

Line 1558: p_init_msg_list => Okc_Api.G_FALSE,

1554: i := p_lpov_tbl.FIRST;
1555: LOOP
1556: insert_row (
1557: p_api_version => p_api_version,
1558: p_init_msg_list => Okc_Api.G_FALSE,
1559: x_return_status => x_return_status,
1560: x_msg_count => x_msg_count,
1561: x_msg_data => x_msg_data,
1562: p_lpov_rec => p_lpov_tbl(i),

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

1564: EXIT WHEN (i = p_lpov_tbl.LAST);
1565: i := p_lpov_tbl.NEXT(i);
1566: END LOOP;
1567: END IF;
1568: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1569: EXCEPTION
1570: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1571: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1572: (

Line 1570: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1566: END LOOP;
1567: END IF;
1568: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1569: EXCEPTION
1570: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1571: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1572: (
1573: l_api_name,
1574: G_PKG_NAME,

Line 1571: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1567: END IF;
1568: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1569: EXCEPTION
1570: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1571: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1572: (
1573: l_api_name,
1574: G_PKG_NAME,
1575: 'OKC_API.G_RET_STS_ERROR',

Line 1575: 'OKC_API.G_RET_STS_ERROR',

1571: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1572: (
1573: l_api_name,
1574: G_PKG_NAME,
1575: 'OKC_API.G_RET_STS_ERROR',
1576: x_msg_count,
1577: x_msg_data,
1578: '_PVT'
1579: );

Line 1580: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1576: x_msg_count,
1577: x_msg_data,
1578: '_PVT'
1579: );
1580: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1581: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1582: (
1583: l_api_name,
1584: G_PKG_NAME,

Line 1581: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1577: x_msg_data,
1578: '_PVT'
1579: );
1580: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1581: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1582: (
1583: l_api_name,
1584: G_PKG_NAME,
1585: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1585: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1581: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1582: (
1583: l_api_name,
1584: G_PKG_NAME,
1585: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1586: x_msg_count,
1587: x_msg_data,
1588: '_PVT'
1589: );

Line 1591: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1587: x_msg_data,
1588: '_PVT'
1589: );
1590: WHEN OTHERS THEN
1591: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1592: (
1593: l_api_name,
1594: G_PKG_NAME,
1595: 'OTHERS',

Line 1609: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1605: --------------------------------------
1606: -- lock_row for:OKL_LATE_POLICIES_B --
1607: --------------------------------------
1608: PROCEDURE lock_row(
1609: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1610: x_return_status OUT NOCOPY VARCHAR2,
1611: x_msg_count OUT NOCOPY NUMBER,
1612: x_msg_data OUT NOCOPY VARCHAR2,
1613: p_lpo_rec IN lpo_rec_type) IS

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

1626: FROM OKL_LATE_POLICIES_B
1627: WHERE ID = p_lpo_rec.id;
1628: l_api_version CONSTANT NUMBER := 1;
1629: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1630: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1631: l_object_version_number OKL_LATE_POLICIES_B.OBJECT_VERSION_NUMBER%TYPE;
1632: lc_object_version_number OKL_LATE_POLICIES_B.OBJECT_VERSION_NUMBER%TYPE;
1633: l_row_notfound BOOLEAN := FALSE;
1634: lc_row_notfound BOOLEAN := FALSE;

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

1632: lc_object_version_number OKL_LATE_POLICIES_B.OBJECT_VERSION_NUMBER%TYPE;
1633: l_row_notfound BOOLEAN := FALSE;
1634: lc_row_notfound BOOLEAN := FALSE;
1635: BEGIN
1636: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1637: p_init_msg_list,
1638: '_PVT',
1639: x_return_status);
1640: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

1636: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1637: p_init_msg_list,
1638: '_PVT',
1639: x_return_status);
1640: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1641: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1642: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1643: RAISE Okc_Api.G_EXCEPTION_ERROR;
1644: END IF;

Line 1641: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1637: p_init_msg_list,
1638: '_PVT',
1639: x_return_status);
1640: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1641: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1642: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1643: RAISE Okc_Api.G_EXCEPTION_ERROR;
1644: END IF;
1645: BEGIN

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

1638: '_PVT',
1639: x_return_status);
1640: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1641: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1642: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1643: RAISE Okc_Api.G_EXCEPTION_ERROR;
1644: END IF;
1645: BEGIN
1646: OPEN lock_csr(p_lpo_rec);

Line 1643: RAISE Okc_Api.G_EXCEPTION_ERROR;

1639: x_return_status);
1640: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1641: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1642: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1643: RAISE Okc_Api.G_EXCEPTION_ERROR;
1644: END IF;
1645: BEGIN
1646: OPEN lock_csr(p_lpo_rec);
1647: FETCH lock_csr INTO l_object_version_number;

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

1651: WHEN E_Resource_Busy THEN
1652: IF (lock_csr%ISOPEN) THEN
1653: CLOSE lock_csr;
1654: END IF;
1655: Okc_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1656: RAISE App_Exceptions.RECORD_LOCK_EXCEPTION;
1657: END;
1658:
1659: IF ( l_row_notfound ) THEN

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

1662: lc_row_notfound := lchk_csr%NOTFOUND;
1663: CLOSE lchk_csr;
1664: END IF;
1665: IF (lc_row_notfound) THEN
1666: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1667: RAISE Okc_Api.G_EXCEPTION_ERROR;
1668: ELSIF lc_object_version_number > p_lpo_rec.object_version_number THEN
1669: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1670: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 1667: RAISE Okc_Api.G_EXCEPTION_ERROR;

1663: CLOSE lchk_csr;
1664: END IF;
1665: IF (lc_row_notfound) THEN
1666: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1667: RAISE Okc_Api.G_EXCEPTION_ERROR;
1668: ELSIF lc_object_version_number > p_lpo_rec.object_version_number THEN
1669: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1670: RAISE Okc_Api.G_EXCEPTION_ERROR;
1671: ELSIF lc_object_version_number <> p_lpo_rec.object_version_number THEN

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

1665: IF (lc_row_notfound) THEN
1666: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1667: RAISE Okc_Api.G_EXCEPTION_ERROR;
1668: ELSIF lc_object_version_number > p_lpo_rec.object_version_number THEN
1669: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1670: RAISE Okc_Api.G_EXCEPTION_ERROR;
1671: ELSIF lc_object_version_number <> p_lpo_rec.object_version_number THEN
1672: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1673: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 1670: RAISE Okc_Api.G_EXCEPTION_ERROR;

1666: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1667: RAISE Okc_Api.G_EXCEPTION_ERROR;
1668: ELSIF lc_object_version_number > p_lpo_rec.object_version_number THEN
1669: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1670: RAISE Okc_Api.G_EXCEPTION_ERROR;
1671: ELSIF lc_object_version_number <> p_lpo_rec.object_version_number THEN
1672: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1673: RAISE Okc_Api.G_EXCEPTION_ERROR;
1674: ELSIF lc_object_version_number = -1 THEN

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

1668: ELSIF lc_object_version_number > p_lpo_rec.object_version_number THEN
1669: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1670: RAISE Okc_Api.G_EXCEPTION_ERROR;
1671: ELSIF lc_object_version_number <> p_lpo_rec.object_version_number THEN
1672: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1673: RAISE Okc_Api.G_EXCEPTION_ERROR;
1674: ELSIF lc_object_version_number = -1 THEN
1675: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1676: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 1673: RAISE Okc_Api.G_EXCEPTION_ERROR;

1669: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1670: RAISE Okc_Api.G_EXCEPTION_ERROR;
1671: ELSIF lc_object_version_number <> p_lpo_rec.object_version_number THEN
1672: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1673: RAISE Okc_Api.G_EXCEPTION_ERROR;
1674: ELSIF lc_object_version_number = -1 THEN
1675: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1676: RAISE Okc_Api.G_EXCEPTION_ERROR;
1677: END IF;

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

1671: ELSIF lc_object_version_number <> p_lpo_rec.object_version_number THEN
1672: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1673: RAISE Okc_Api.G_EXCEPTION_ERROR;
1674: ELSIF lc_object_version_number = -1 THEN
1675: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1676: RAISE Okc_Api.G_EXCEPTION_ERROR;
1677: END IF;
1678: x_return_status := l_return_status;
1679: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1676: RAISE Okc_Api.G_EXCEPTION_ERROR;

1672: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1673: RAISE Okc_Api.G_EXCEPTION_ERROR;
1674: ELSIF lc_object_version_number = -1 THEN
1675: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1676: RAISE Okc_Api.G_EXCEPTION_ERROR;
1677: END IF;
1678: x_return_status := l_return_status;
1679: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1680: EXCEPTION

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

1675: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1676: RAISE Okc_Api.G_EXCEPTION_ERROR;
1677: END IF;
1678: x_return_status := l_return_status;
1679: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1680: EXCEPTION
1681: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1682: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1683: (

Line 1681: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1677: END IF;
1678: x_return_status := l_return_status;
1679: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1680: EXCEPTION
1681: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1682: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1683: (
1684: l_api_name,
1685: G_PKG_NAME,

Line 1682: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1678: x_return_status := l_return_status;
1679: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1680: EXCEPTION
1681: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1682: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1683: (
1684: l_api_name,
1685: G_PKG_NAME,
1686: 'OKC_API.G_RET_STS_ERROR',

Line 1686: 'OKC_API.G_RET_STS_ERROR',

1682: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1683: (
1684: l_api_name,
1685: G_PKG_NAME,
1686: 'OKC_API.G_RET_STS_ERROR',
1687: x_msg_count,
1688: x_msg_data,
1689: '_PVT'
1690: );

Line 1691: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1687: x_msg_count,
1688: x_msg_data,
1689: '_PVT'
1690: );
1691: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1692: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1693: (
1694: l_api_name,
1695: G_PKG_NAME,

Line 1692: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1688: x_msg_data,
1689: '_PVT'
1690: );
1691: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1692: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1693: (
1694: l_api_name,
1695: G_PKG_NAME,
1696: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1696: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1692: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1693: (
1694: l_api_name,
1695: G_PKG_NAME,
1696: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1697: x_msg_count,
1698: x_msg_data,
1699: '_PVT'
1700: );

Line 1702: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1698: x_msg_data,
1699: '_PVT'
1700: );
1701: WHEN OTHERS THEN
1702: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1703: (
1704: l_api_name,
1705: G_PKG_NAME,
1706: 'OTHERS',

Line 1716: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1712: ---------------------------------------
1713: -- lock_row for:OKL_LATE_POLICIES_TL --
1714: ---------------------------------------
1715: PROCEDURE lock_row(
1716: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1717: x_return_status OUT NOCOPY VARCHAR2,
1718: x_msg_count OUT NOCOPY NUMBER,
1719: x_msg_data OUT NOCOPY VARCHAR2,
1720: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type) IS

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

1728: FOR UPDATE NOWAIT;
1729:
1730: l_api_version CONSTANT NUMBER := 1;
1731: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';
1732: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1733: l_lock_var lock_csr%ROWTYPE;
1734: l_row_notfound BOOLEAN := FALSE;
1735: lc_row_notfound BOOLEAN := FALSE;
1736: BEGIN

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

1733: l_lock_var lock_csr%ROWTYPE;
1734: l_row_notfound BOOLEAN := FALSE;
1735: lc_row_notfound BOOLEAN := FALSE;
1736: BEGIN
1737: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1738: p_init_msg_list,
1739: '_PVT',
1740: x_return_status);
1741: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

1737: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1738: p_init_msg_list,
1739: '_PVT',
1740: x_return_status);
1741: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1742: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1743: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1744: RAISE Okc_Api.G_EXCEPTION_ERROR;
1745: END IF;

Line 1742: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1738: p_init_msg_list,
1739: '_PVT',
1740: x_return_status);
1741: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1742: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1743: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1744: RAISE Okc_Api.G_EXCEPTION_ERROR;
1745: END IF;
1746: BEGIN

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

1739: '_PVT',
1740: x_return_status);
1741: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1742: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1743: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1744: RAISE Okc_Api.G_EXCEPTION_ERROR;
1745: END IF;
1746: BEGIN
1747: OPEN lock_csr(p_okl_late_policies_tl_rec);

Line 1744: RAISE Okc_Api.G_EXCEPTION_ERROR;

1740: x_return_status);
1741: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1742: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1743: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1744: RAISE Okc_Api.G_EXCEPTION_ERROR;
1745: END IF;
1746: BEGIN
1747: OPEN lock_csr(p_okl_late_policies_tl_rec);
1748: FETCH lock_csr INTO l_lock_var;

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

1752: WHEN E_Resource_Busy THEN
1753: IF (lock_csr%ISOPEN) THEN
1754: CLOSE lock_csr;
1755: END IF;
1756: Okc_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1757: RAISE App_Exceptions.RECORD_LOCK_EXCEPTION;
1758: END;
1759:
1760: IF ( l_row_notfound ) THEN

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

1757: RAISE App_Exceptions.RECORD_LOCK_EXCEPTION;
1758: END;
1759:
1760: IF ( l_row_notfound ) THEN
1761: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1762: RAISE Okc_Api.G_EXCEPTION_ERROR;
1763: END IF;
1764: x_return_status := l_return_status;
1765: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1762: RAISE Okc_Api.G_EXCEPTION_ERROR;

1758: END;
1759:
1760: IF ( l_row_notfound ) THEN
1761: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1762: RAISE Okc_Api.G_EXCEPTION_ERROR;
1763: END IF;
1764: x_return_status := l_return_status;
1765: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1766: EXCEPTION

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

1761: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1762: RAISE Okc_Api.G_EXCEPTION_ERROR;
1763: END IF;
1764: x_return_status := l_return_status;
1765: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1766: EXCEPTION
1767: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1768: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1769: (

Line 1767: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1763: END IF;
1764: x_return_status := l_return_status;
1765: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1766: EXCEPTION
1767: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1768: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1769: (
1770: l_api_name,
1771: G_PKG_NAME,

Line 1768: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1764: x_return_status := l_return_status;
1765: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1766: EXCEPTION
1767: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1768: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1769: (
1770: l_api_name,
1771: G_PKG_NAME,
1772: 'OKC_API.G_RET_STS_ERROR',

Line 1772: 'OKC_API.G_RET_STS_ERROR',

1768: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1769: (
1770: l_api_name,
1771: G_PKG_NAME,
1772: 'OKC_API.G_RET_STS_ERROR',
1773: x_msg_count,
1774: x_msg_data,
1775: '_PVT'
1776: );

Line 1777: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1773: x_msg_count,
1774: x_msg_data,
1775: '_PVT'
1776: );
1777: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1778: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1779: (
1780: l_api_name,
1781: G_PKG_NAME,

Line 1778: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1774: x_msg_data,
1775: '_PVT'
1776: );
1777: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1778: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1779: (
1780: l_api_name,
1781: G_PKG_NAME,
1782: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1782: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1778: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1779: (
1780: l_api_name,
1781: G_PKG_NAME,
1782: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1783: x_msg_count,
1784: x_msg_data,
1785: '_PVT'
1786: );

Line 1788: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1784: x_msg_data,
1785: '_PVT'
1786: );
1787: WHEN OTHERS THEN
1788: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1789: (
1790: l_api_name,
1791: G_PKG_NAME,
1792: 'OTHERS',

Line 1803: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1799: -- lock_row for: OKL_LATE_POLICIES_V --
1800: ---------------------------------------
1801: PROCEDURE lock_row(
1802: p_api_version IN NUMBER,
1803: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1804: x_return_status OUT NOCOPY VARCHAR2,
1805: x_msg_count OUT NOCOPY NUMBER,
1806: x_msg_data OUT NOCOPY VARCHAR2,
1807: p_lpov_rec IN lpov_rec_type) IS

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

1807: p_lpov_rec IN lpov_rec_type) IS
1808:
1809: l_api_version CONSTANT NUMBER := 1;
1810: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1811: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1812: l_lpo_rec lpo_rec_type;
1813: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
1814: BEGIN
1815: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

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

1811: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1812: l_lpo_rec lpo_rec_type;
1813: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
1814: BEGIN
1815: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1816: G_PKG_NAME,
1817: p_init_msg_list,
1818: l_api_version,
1819: p_api_version,

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

1818: l_api_version,
1819: p_api_version,
1820: '_PVT',
1821: x_return_status);
1822: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1823: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1824: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1825: RAISE Okc_Api.G_EXCEPTION_ERROR;
1826: END IF;

Line 1823: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1819: p_api_version,
1820: '_PVT',
1821: x_return_status);
1822: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1823: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1824: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1825: RAISE Okc_Api.G_EXCEPTION_ERROR;
1826: END IF;
1827: -----------------------------------------

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

1820: '_PVT',
1821: x_return_status);
1822: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1823: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1824: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1825: RAISE Okc_Api.G_EXCEPTION_ERROR;
1826: END IF;
1827: -----------------------------------------
1828: -- Move VIEW record to "Child" records --

Line 1825: RAISE Okc_Api.G_EXCEPTION_ERROR;

1821: x_return_status);
1822: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1823: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1824: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1825: RAISE Okc_Api.G_EXCEPTION_ERROR;
1826: END IF;
1827: -----------------------------------------
1828: -- Move VIEW record to "Child" records --
1829: -----------------------------------------

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

1838: x_msg_count,
1839: x_msg_data,
1840: l_lpo_rec
1841: );
1842: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1844: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1845: RAISE Okc_Api.G_EXCEPTION_ERROR;
1846: END IF;

Line 1843: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1839: x_msg_data,
1840: l_lpo_rec
1841: );
1842: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1844: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1845: RAISE Okc_Api.G_EXCEPTION_ERROR;
1846: END IF;
1847: lock_row(

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

1840: l_lpo_rec
1841: );
1842: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1844: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1845: RAISE Okc_Api.G_EXCEPTION_ERROR;
1846: END IF;
1847: lock_row(
1848: p_init_msg_list,

Line 1845: RAISE Okc_Api.G_EXCEPTION_ERROR;

1841: );
1842: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1844: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1845: RAISE Okc_Api.G_EXCEPTION_ERROR;
1846: END IF;
1847: lock_row(
1848: p_init_msg_list,
1849: l_return_status,

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

1850: x_msg_count,
1851: x_msg_data,
1852: l_okl_late_policies_tl_rec
1853: );
1854: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1855: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1856: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1857: RAISE Okc_Api.G_EXCEPTION_ERROR;
1858: END IF;

Line 1855: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1851: x_msg_data,
1852: l_okl_late_policies_tl_rec
1853: );
1854: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1855: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1856: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1857: RAISE Okc_Api.G_EXCEPTION_ERROR;
1858: END IF;
1859: x_return_status := l_return_status;

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

1852: l_okl_late_policies_tl_rec
1853: );
1854: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1855: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1856: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1857: RAISE Okc_Api.G_EXCEPTION_ERROR;
1858: END IF;
1859: x_return_status := l_return_status;
1860: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1857: RAISE Okc_Api.G_EXCEPTION_ERROR;

1853: );
1854: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1855: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1856: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1857: RAISE Okc_Api.G_EXCEPTION_ERROR;
1858: END IF;
1859: x_return_status := l_return_status;
1860: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1861: EXCEPTION

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

1856: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1857: RAISE Okc_Api.G_EXCEPTION_ERROR;
1858: END IF;
1859: x_return_status := l_return_status;
1860: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1861: EXCEPTION
1862: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1863: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1864: (

Line 1862: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1858: END IF;
1859: x_return_status := l_return_status;
1860: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1861: EXCEPTION
1862: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1863: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1864: (
1865: l_api_name,
1866: G_PKG_NAME,

Line 1863: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1859: x_return_status := l_return_status;
1860: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1861: EXCEPTION
1862: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1863: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1864: (
1865: l_api_name,
1866: G_PKG_NAME,
1867: 'OKC_API.G_RET_STS_ERROR',

Line 1867: 'OKC_API.G_RET_STS_ERROR',

1863: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1864: (
1865: l_api_name,
1866: G_PKG_NAME,
1867: 'OKC_API.G_RET_STS_ERROR',
1868: x_msg_count,
1869: x_msg_data,
1870: '_PVT'
1871: );

Line 1872: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1868: x_msg_count,
1869: x_msg_data,
1870: '_PVT'
1871: );
1872: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1873: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1874: (
1875: l_api_name,
1876: G_PKG_NAME,

Line 1873: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1869: x_msg_data,
1870: '_PVT'
1871: );
1872: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1873: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1874: (
1875: l_api_name,
1876: G_PKG_NAME,
1877: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1877: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1873: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1874: (
1875: l_api_name,
1876: G_PKG_NAME,
1877: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1878: x_msg_count,
1879: x_msg_data,
1880: '_PVT'
1881: );

Line 1883: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1879: x_msg_data,
1880: '_PVT'
1881: );
1882: WHEN OTHERS THEN
1883: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1884: (
1885: l_api_name,
1886: G_PKG_NAME,
1887: 'OTHERS',

Line 1898: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1894: -- PL/SQL TBL lock_row for:LPOV_TBL --
1895: --------------------------------------
1896: PROCEDURE lock_row(
1897: p_api_version IN NUMBER,
1898: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1899: x_return_status OUT NOCOPY VARCHAR2,
1900: x_msg_count OUT NOCOPY NUMBER,
1901: x_msg_data OUT NOCOPY VARCHAR2,
1902: p_lpov_tbl IN lpov_tbl_type) IS

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

1902: p_lpov_tbl IN lpov_tbl_type) IS
1903:
1904: l_api_version CONSTANT NUMBER := 1;
1905: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1906: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1907: i NUMBER := 0;
1908: BEGIN
1909: Okc_Api.init_msg_list(p_init_msg_list);
1910: -- Make sure PL/SQL table has recrods in it before passing

Line 1909: Okc_Api.init_msg_list(p_init_msg_list);

1905: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1906: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1907: i NUMBER := 0;
1908: BEGIN
1909: Okc_Api.init_msg_list(p_init_msg_list);
1910: -- Make sure PL/SQL table has recrods in it before passing
1911: IF (p_lpov_tbl.COUNT > 0) THEN
1912: i := p_lpov_tbl.FIRST;
1913: LOOP

Line 1916: p_init_msg_list => Okc_Api.G_FALSE,

1912: i := p_lpov_tbl.FIRST;
1913: LOOP
1914: lock_row(
1915: p_api_version => p_api_version,
1916: p_init_msg_list => Okc_Api.G_FALSE,
1917: x_return_status => x_return_status,
1918: x_msg_count => x_msg_count,
1919: x_msg_data => x_msg_data,
1920: p_lpov_rec => p_lpov_tbl(i));

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

1921: EXIT WHEN (i = p_lpov_tbl.LAST);
1922: i := p_lpov_tbl.NEXT(i);
1923: END LOOP;
1924: END IF;
1925: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1926: EXCEPTION
1927: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1928: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1929: (

Line 1927: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1923: END LOOP;
1924: END IF;
1925: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1926: EXCEPTION
1927: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1928: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1929: (
1930: l_api_name,
1931: G_PKG_NAME,

Line 1928: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1924: END IF;
1925: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1926: EXCEPTION
1927: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1928: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1929: (
1930: l_api_name,
1931: G_PKG_NAME,
1932: 'OKC_API.G_RET_STS_ERROR',

Line 1932: 'OKC_API.G_RET_STS_ERROR',

1928: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1929: (
1930: l_api_name,
1931: G_PKG_NAME,
1932: 'OKC_API.G_RET_STS_ERROR',
1933: x_msg_count,
1934: x_msg_data,
1935: '_PVT'
1936: );

Line 1937: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1933: x_msg_count,
1934: x_msg_data,
1935: '_PVT'
1936: );
1937: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1938: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1939: (
1940: l_api_name,
1941: G_PKG_NAME,

Line 1938: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1934: x_msg_data,
1935: '_PVT'
1936: );
1937: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1938: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1939: (
1940: l_api_name,
1941: G_PKG_NAME,
1942: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1942: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1938: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1939: (
1940: l_api_name,
1941: G_PKG_NAME,
1942: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1943: x_msg_count,
1944: x_msg_data,
1945: '_PVT'
1946: );

Line 1948: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1944: x_msg_data,
1945: '_PVT'
1946: );
1947: WHEN OTHERS THEN
1948: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1949: (
1950: l_api_name,
1951: G_PKG_NAME,
1952: 'OTHERS',

Line 1965: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1961: ----------------------------------------
1962: -- update_row for:OKL_LATE_POLICIES_B --
1963: ----------------------------------------
1964: PROCEDURE update_row(
1965: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1966: x_return_status OUT NOCOPY VARCHAR2,
1967: x_msg_count OUT NOCOPY NUMBER,
1968: x_msg_data OUT NOCOPY VARCHAR2,
1969: p_lpo_rec IN lpo_rec_type,

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

1970: x_lpo_rec OUT NOCOPY lpo_rec_type) IS
1971:
1972: l_api_version CONSTANT NUMBER := 1;
1973: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1974: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1975: l_lpo_rec lpo_rec_type := p_lpo_rec;
1976: l_def_lpo_rec lpo_rec_type;
1977: l_row_notfound BOOLEAN := TRUE;
1978: ----------------------------------

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

1983: x_lpo_rec OUT NOCOPY lpo_rec_type
1984: ) RETURN VARCHAR2 IS
1985: l_lpo_rec lpo_rec_type;
1986: l_row_notfound BOOLEAN := TRUE;
1987: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1988: BEGIN
1989: x_lpo_rec := p_lpo_rec;
1990: -- Get current database values
1991: l_lpo_rec := get_rec(p_lpo_rec, l_return_status);

Line 1992: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN

1988: BEGIN
1989: x_lpo_rec := p_lpo_rec;
1990: -- Get current database values
1991: l_lpo_rec := get_rec(p_lpo_rec, l_return_status);
1992: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
1993: IF (x_lpo_rec.id = Okc_Api.G_MISS_NUM)
1994: THEN
1995: x_lpo_rec.id := l_lpo_rec.id;
1996: END IF;

Line 1993: IF (x_lpo_rec.id = Okc_Api.G_MISS_NUM)

1989: x_lpo_rec := p_lpo_rec;
1990: -- Get current database values
1991: l_lpo_rec := get_rec(p_lpo_rec, l_return_status);
1992: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
1993: IF (x_lpo_rec.id = Okc_Api.G_MISS_NUM)
1994: THEN
1995: x_lpo_rec.id := l_lpo_rec.id;
1996: END IF;
1997: IF (x_lpo_rec.org_id = Okc_Api.G_MISS_NUM)

Line 1997: IF (x_lpo_rec.org_id = Okc_Api.G_MISS_NUM)

1993: IF (x_lpo_rec.id = Okc_Api.G_MISS_NUM)
1994: THEN
1995: x_lpo_rec.id := l_lpo_rec.id;
1996: END IF;
1997: IF (x_lpo_rec.org_id = Okc_Api.G_MISS_NUM)
1998: THEN
1999: x_lpo_rec.org_id := l_lpo_rec.org_id;
2000: END IF;
2001: IF (x_lpo_rec.ise_id = Okc_Api.G_MISS_NUM)

Line 2001: IF (x_lpo_rec.ise_id = Okc_Api.G_MISS_NUM)

1997: IF (x_lpo_rec.org_id = Okc_Api.G_MISS_NUM)
1998: THEN
1999: x_lpo_rec.org_id := l_lpo_rec.org_id;
2000: END IF;
2001: IF (x_lpo_rec.ise_id = Okc_Api.G_MISS_NUM)
2002: THEN
2003: x_lpo_rec.ise_id := l_lpo_rec.ise_id;
2004: END IF;
2005: IF (x_lpo_rec.tdf_id = Okc_Api.G_MISS_NUM)

Line 2005: IF (x_lpo_rec.tdf_id = Okc_Api.G_MISS_NUM)

2001: IF (x_lpo_rec.ise_id = Okc_Api.G_MISS_NUM)
2002: THEN
2003: x_lpo_rec.ise_id := l_lpo_rec.ise_id;
2004: END IF;
2005: IF (x_lpo_rec.tdf_id = Okc_Api.G_MISS_NUM)
2006: THEN
2007: x_lpo_rec.tdf_id := l_lpo_rec.tdf_id;
2008: END IF;
2009: IF (x_lpo_rec.idx_id = Okc_Api.G_MISS_NUM)

Line 2009: IF (x_lpo_rec.idx_id = Okc_Api.G_MISS_NUM)

2005: IF (x_lpo_rec.tdf_id = Okc_Api.G_MISS_NUM)
2006: THEN
2007: x_lpo_rec.tdf_id := l_lpo_rec.tdf_id;
2008: END IF;
2009: IF (x_lpo_rec.idx_id = Okc_Api.G_MISS_NUM)
2010: THEN
2011: x_lpo_rec.idx_id := l_lpo_rec.idx_id;
2012: END IF;
2013: IF (x_lpo_rec.late_policy_type_code = Okc_Api.G_MISS_CHAR)

Line 2013: IF (x_lpo_rec.late_policy_type_code = Okc_Api.G_MISS_CHAR)

2009: IF (x_lpo_rec.idx_id = Okc_Api.G_MISS_NUM)
2010: THEN
2011: x_lpo_rec.idx_id := l_lpo_rec.idx_id;
2012: END IF;
2013: IF (x_lpo_rec.late_policy_type_code = Okc_Api.G_MISS_CHAR)
2014: THEN
2015: x_lpo_rec.late_policy_type_code := l_lpo_rec.late_policy_type_code;
2016: END IF;
2017: IF (x_lpo_rec.object_version_number = Okc_Api.G_MISS_NUM)

Line 2017: IF (x_lpo_rec.object_version_number = Okc_Api.G_MISS_NUM)

2013: IF (x_lpo_rec.late_policy_type_code = Okc_Api.G_MISS_CHAR)
2014: THEN
2015: x_lpo_rec.late_policy_type_code := l_lpo_rec.late_policy_type_code;
2016: END IF;
2017: IF (x_lpo_rec.object_version_number = Okc_Api.G_MISS_NUM)
2018: THEN
2019: x_lpo_rec.object_version_number := l_lpo_rec.object_version_number;
2020: END IF;
2021: IF (x_lpo_rec.late_chrg_allowed_yn = Okc_Api.G_MISS_CHAR)

Line 2021: IF (x_lpo_rec.late_chrg_allowed_yn = Okc_Api.G_MISS_CHAR)

2017: IF (x_lpo_rec.object_version_number = Okc_Api.G_MISS_NUM)
2018: THEN
2019: x_lpo_rec.object_version_number := l_lpo_rec.object_version_number;
2020: END IF;
2021: IF (x_lpo_rec.late_chrg_allowed_yn = Okc_Api.G_MISS_CHAR)
2022: THEN
2023: x_lpo_rec.late_chrg_allowed_yn := l_lpo_rec.late_chrg_allowed_yn;
2024: END IF;
2025: IF (x_lpo_rec.late_chrg_fixed_yn = Okc_Api.G_MISS_CHAR)

Line 2025: IF (x_lpo_rec.late_chrg_fixed_yn = Okc_Api.G_MISS_CHAR)

2021: IF (x_lpo_rec.late_chrg_allowed_yn = Okc_Api.G_MISS_CHAR)
2022: THEN
2023: x_lpo_rec.late_chrg_allowed_yn := l_lpo_rec.late_chrg_allowed_yn;
2024: END IF;
2025: IF (x_lpo_rec.late_chrg_fixed_yn = Okc_Api.G_MISS_CHAR)
2026: THEN
2027: x_lpo_rec.late_chrg_fixed_yn := l_lpo_rec.late_chrg_fixed_yn;
2028: END IF;
2029: IF (x_lpo_rec.late_chrg_amount = Okc_Api.G_MISS_NUM)

Line 2029: IF (x_lpo_rec.late_chrg_amount = Okc_Api.G_MISS_NUM)

2025: IF (x_lpo_rec.late_chrg_fixed_yn = Okc_Api.G_MISS_CHAR)
2026: THEN
2027: x_lpo_rec.late_chrg_fixed_yn := l_lpo_rec.late_chrg_fixed_yn;
2028: END IF;
2029: IF (x_lpo_rec.late_chrg_amount = Okc_Api.G_MISS_NUM)
2030: THEN
2031: x_lpo_rec.late_chrg_amount := l_lpo_rec.late_chrg_amount;
2032: END IF;
2033: IF (x_lpo_rec.late_chrg_rate = Okc_Api.G_MISS_NUM)

Line 2033: IF (x_lpo_rec.late_chrg_rate = Okc_Api.G_MISS_NUM)

2029: IF (x_lpo_rec.late_chrg_amount = Okc_Api.G_MISS_NUM)
2030: THEN
2031: x_lpo_rec.late_chrg_amount := l_lpo_rec.late_chrg_amount;
2032: END IF;
2033: IF (x_lpo_rec.late_chrg_rate = Okc_Api.G_MISS_NUM)
2034: THEN
2035: x_lpo_rec.late_chrg_rate := l_lpo_rec.late_chrg_rate;
2036: END IF;
2037: IF (x_lpo_rec.late_chrg_grace_period = Okc_Api.G_MISS_NUM)

Line 2037: IF (x_lpo_rec.late_chrg_grace_period = Okc_Api.G_MISS_NUM)

2033: IF (x_lpo_rec.late_chrg_rate = Okc_Api.G_MISS_NUM)
2034: THEN
2035: x_lpo_rec.late_chrg_rate := l_lpo_rec.late_chrg_rate;
2036: END IF;
2037: IF (x_lpo_rec.late_chrg_grace_period = Okc_Api.G_MISS_NUM)
2038: THEN
2039: x_lpo_rec.late_chrg_grace_period := l_lpo_rec.late_chrg_grace_period;
2040: END IF;
2041: IF (x_lpo_rec.late_chrg_minimum_balance = Okc_Api.G_MISS_NUM)

Line 2041: IF (x_lpo_rec.late_chrg_minimum_balance = Okc_Api.G_MISS_NUM)

2037: IF (x_lpo_rec.late_chrg_grace_period = Okc_Api.G_MISS_NUM)
2038: THEN
2039: x_lpo_rec.late_chrg_grace_period := l_lpo_rec.late_chrg_grace_period;
2040: END IF;
2041: IF (x_lpo_rec.late_chrg_minimum_balance = Okc_Api.G_MISS_NUM)
2042: THEN
2043: x_lpo_rec.late_chrg_minimum_balance := l_lpo_rec.late_chrg_minimum_balance;
2044: END IF;
2045: IF (x_lpo_rec.minimum_late_charge = Okc_Api.G_MISS_NUM)

Line 2045: IF (x_lpo_rec.minimum_late_charge = Okc_Api.G_MISS_NUM)

2041: IF (x_lpo_rec.late_chrg_minimum_balance = Okc_Api.G_MISS_NUM)
2042: THEN
2043: x_lpo_rec.late_chrg_minimum_balance := l_lpo_rec.late_chrg_minimum_balance;
2044: END IF;
2045: IF (x_lpo_rec.minimum_late_charge = Okc_Api.G_MISS_NUM)
2046: THEN
2047: x_lpo_rec.minimum_late_charge := l_lpo_rec.minimum_late_charge;
2048: END IF;
2049: IF (x_lpo_rec.maximum_late_charge = Okc_Api.G_MISS_NUM)

Line 2049: IF (x_lpo_rec.maximum_late_charge = Okc_Api.G_MISS_NUM)

2045: IF (x_lpo_rec.minimum_late_charge = Okc_Api.G_MISS_NUM)
2046: THEN
2047: x_lpo_rec.minimum_late_charge := l_lpo_rec.minimum_late_charge;
2048: END IF;
2049: IF (x_lpo_rec.maximum_late_charge = Okc_Api.G_MISS_NUM)
2050: THEN
2051: x_lpo_rec.maximum_late_charge := l_lpo_rec.maximum_late_charge;
2052: END IF;
2053: IF (x_lpo_rec.late_int_allowed_yn = Okc_Api.G_MISS_CHAR)

Line 2053: IF (x_lpo_rec.late_int_allowed_yn = Okc_Api.G_MISS_CHAR)

2049: IF (x_lpo_rec.maximum_late_charge = Okc_Api.G_MISS_NUM)
2050: THEN
2051: x_lpo_rec.maximum_late_charge := l_lpo_rec.maximum_late_charge;
2052: END IF;
2053: IF (x_lpo_rec.late_int_allowed_yn = Okc_Api.G_MISS_CHAR)
2054: THEN
2055: x_lpo_rec.late_int_allowed_yn := l_lpo_rec.late_int_allowed_yn;
2056: END IF;
2057: IF (x_lpo_rec.late_int_fixed_yn = Okc_Api.G_MISS_CHAR)

Line 2057: IF (x_lpo_rec.late_int_fixed_yn = Okc_Api.G_MISS_CHAR)

2053: IF (x_lpo_rec.late_int_allowed_yn = Okc_Api.G_MISS_CHAR)
2054: THEN
2055: x_lpo_rec.late_int_allowed_yn := l_lpo_rec.late_int_allowed_yn;
2056: END IF;
2057: IF (x_lpo_rec.late_int_fixed_yn = Okc_Api.G_MISS_CHAR)
2058: THEN
2059: x_lpo_rec.late_int_fixed_yn := l_lpo_rec.late_int_fixed_yn;
2060: END IF;
2061: IF (x_lpo_rec.late_int_rate = Okc_Api.G_MISS_NUM)

Line 2061: IF (x_lpo_rec.late_int_rate = Okc_Api.G_MISS_NUM)

2057: IF (x_lpo_rec.late_int_fixed_yn = Okc_Api.G_MISS_CHAR)
2058: THEN
2059: x_lpo_rec.late_int_fixed_yn := l_lpo_rec.late_int_fixed_yn;
2060: END IF;
2061: IF (x_lpo_rec.late_int_rate = Okc_Api.G_MISS_NUM)
2062: THEN
2063: x_lpo_rec.late_int_rate := l_lpo_rec.late_int_rate;
2064: END IF;
2065: IF (x_lpo_rec.adder_rate = Okc_Api.G_MISS_NUM)

Line 2065: IF (x_lpo_rec.adder_rate = Okc_Api.G_MISS_NUM)

2061: IF (x_lpo_rec.late_int_rate = Okc_Api.G_MISS_NUM)
2062: THEN
2063: x_lpo_rec.late_int_rate := l_lpo_rec.late_int_rate;
2064: END IF;
2065: IF (x_lpo_rec.adder_rate = Okc_Api.G_MISS_NUM)
2066: THEN
2067: x_lpo_rec.adder_rate := l_lpo_rec.adder_rate;
2068: END IF;
2069: IF (x_lpo_rec.late_int_grace_period = Okc_Api.G_MISS_NUM)

Line 2069: IF (x_lpo_rec.late_int_grace_period = Okc_Api.G_MISS_NUM)

2065: IF (x_lpo_rec.adder_rate = Okc_Api.G_MISS_NUM)
2066: THEN
2067: x_lpo_rec.adder_rate := l_lpo_rec.adder_rate;
2068: END IF;
2069: IF (x_lpo_rec.late_int_grace_period = Okc_Api.G_MISS_NUM)
2070: THEN
2071: x_lpo_rec.late_int_grace_period := l_lpo_rec.late_int_grace_period;
2072: END IF;
2073: IF (x_lpo_rec.late_int_minimum_balance = Okc_Api.G_MISS_NUM)

Line 2073: IF (x_lpo_rec.late_int_minimum_balance = Okc_Api.G_MISS_NUM)

2069: IF (x_lpo_rec.late_int_grace_period = Okc_Api.G_MISS_NUM)
2070: THEN
2071: x_lpo_rec.late_int_grace_period := l_lpo_rec.late_int_grace_period;
2072: END IF;
2073: IF (x_lpo_rec.late_int_minimum_balance = Okc_Api.G_MISS_NUM)
2074: THEN
2075: x_lpo_rec.late_int_minimum_balance := l_lpo_rec.late_int_minimum_balance;
2076: END IF;
2077: IF (x_lpo_rec.minimum_late_interest = Okc_Api.G_MISS_NUM)

Line 2077: IF (x_lpo_rec.minimum_late_interest = Okc_Api.G_MISS_NUM)

2073: IF (x_lpo_rec.late_int_minimum_balance = Okc_Api.G_MISS_NUM)
2074: THEN
2075: x_lpo_rec.late_int_minimum_balance := l_lpo_rec.late_int_minimum_balance;
2076: END IF;
2077: IF (x_lpo_rec.minimum_late_interest = Okc_Api.G_MISS_NUM)
2078: THEN
2079: x_lpo_rec.minimum_late_interest := l_lpo_rec.minimum_late_interest;
2080: END IF;
2081: IF (x_lpo_rec.maximum_late_interest = Okc_Api.G_MISS_NUM)

Line 2081: IF (x_lpo_rec.maximum_late_interest = Okc_Api.G_MISS_NUM)

2077: IF (x_lpo_rec.minimum_late_interest = Okc_Api.G_MISS_NUM)
2078: THEN
2079: x_lpo_rec.minimum_late_interest := l_lpo_rec.minimum_late_interest;
2080: END IF;
2081: IF (x_lpo_rec.maximum_late_interest = Okc_Api.G_MISS_NUM)
2082: THEN
2083: x_lpo_rec.maximum_late_interest := l_lpo_rec.maximum_late_interest;
2084: END IF;
2085: IF (x_lpo_rec.attribute_category = Okc_Api.G_MISS_CHAR)

Line 2085: IF (x_lpo_rec.attribute_category = Okc_Api.G_MISS_CHAR)

2081: IF (x_lpo_rec.maximum_late_interest = Okc_Api.G_MISS_NUM)
2082: THEN
2083: x_lpo_rec.maximum_late_interest := l_lpo_rec.maximum_late_interest;
2084: END IF;
2085: IF (x_lpo_rec.attribute_category = Okc_Api.G_MISS_CHAR)
2086: THEN
2087: x_lpo_rec.attribute_category := l_lpo_rec.attribute_category;
2088: END IF;
2089: IF (x_lpo_rec.attribute1 = Okc_Api.G_MISS_CHAR)

Line 2089: IF (x_lpo_rec.attribute1 = Okc_Api.G_MISS_CHAR)

2085: IF (x_lpo_rec.attribute_category = Okc_Api.G_MISS_CHAR)
2086: THEN
2087: x_lpo_rec.attribute_category := l_lpo_rec.attribute_category;
2088: END IF;
2089: IF (x_lpo_rec.attribute1 = Okc_Api.G_MISS_CHAR)
2090: THEN
2091: x_lpo_rec.attribute1 := l_lpo_rec.attribute1;
2092: END IF;
2093: IF (x_lpo_rec.attribute2 = Okc_Api.G_MISS_CHAR)

Line 2093: IF (x_lpo_rec.attribute2 = Okc_Api.G_MISS_CHAR)

2089: IF (x_lpo_rec.attribute1 = Okc_Api.G_MISS_CHAR)
2090: THEN
2091: x_lpo_rec.attribute1 := l_lpo_rec.attribute1;
2092: END IF;
2093: IF (x_lpo_rec.attribute2 = Okc_Api.G_MISS_CHAR)
2094: THEN
2095: x_lpo_rec.attribute2 := l_lpo_rec.attribute2;
2096: END IF;
2097: IF (x_lpo_rec.attribute3 = Okc_Api.G_MISS_CHAR)

Line 2097: IF (x_lpo_rec.attribute3 = Okc_Api.G_MISS_CHAR)

2093: IF (x_lpo_rec.attribute2 = Okc_Api.G_MISS_CHAR)
2094: THEN
2095: x_lpo_rec.attribute2 := l_lpo_rec.attribute2;
2096: END IF;
2097: IF (x_lpo_rec.attribute3 = Okc_Api.G_MISS_CHAR)
2098: THEN
2099: x_lpo_rec.attribute3 := l_lpo_rec.attribute3;
2100: END IF;
2101: IF (x_lpo_rec.attribute4 = Okc_Api.G_MISS_CHAR)

Line 2101: IF (x_lpo_rec.attribute4 = Okc_Api.G_MISS_CHAR)

2097: IF (x_lpo_rec.attribute3 = Okc_Api.G_MISS_CHAR)
2098: THEN
2099: x_lpo_rec.attribute3 := l_lpo_rec.attribute3;
2100: END IF;
2101: IF (x_lpo_rec.attribute4 = Okc_Api.G_MISS_CHAR)
2102: THEN
2103: x_lpo_rec.attribute4 := l_lpo_rec.attribute4;
2104: END IF;
2105: IF (x_lpo_rec.attribute5 = Okc_Api.G_MISS_CHAR)

Line 2105: IF (x_lpo_rec.attribute5 = Okc_Api.G_MISS_CHAR)

2101: IF (x_lpo_rec.attribute4 = Okc_Api.G_MISS_CHAR)
2102: THEN
2103: x_lpo_rec.attribute4 := l_lpo_rec.attribute4;
2104: END IF;
2105: IF (x_lpo_rec.attribute5 = Okc_Api.G_MISS_CHAR)
2106: THEN
2107: x_lpo_rec.attribute5 := l_lpo_rec.attribute5;
2108: END IF;
2109: IF (x_lpo_rec.attribute6 = Okc_Api.G_MISS_CHAR)

Line 2109: IF (x_lpo_rec.attribute6 = Okc_Api.G_MISS_CHAR)

2105: IF (x_lpo_rec.attribute5 = Okc_Api.G_MISS_CHAR)
2106: THEN
2107: x_lpo_rec.attribute5 := l_lpo_rec.attribute5;
2108: END IF;
2109: IF (x_lpo_rec.attribute6 = Okc_Api.G_MISS_CHAR)
2110: THEN
2111: x_lpo_rec.attribute6 := l_lpo_rec.attribute6;
2112: END IF;
2113: IF (x_lpo_rec.attribute7 = Okc_Api.G_MISS_CHAR)

Line 2113: IF (x_lpo_rec.attribute7 = Okc_Api.G_MISS_CHAR)

2109: IF (x_lpo_rec.attribute6 = Okc_Api.G_MISS_CHAR)
2110: THEN
2111: x_lpo_rec.attribute6 := l_lpo_rec.attribute6;
2112: END IF;
2113: IF (x_lpo_rec.attribute7 = Okc_Api.G_MISS_CHAR)
2114: THEN
2115: x_lpo_rec.attribute7 := l_lpo_rec.attribute7;
2116: END IF;
2117: IF (x_lpo_rec.attribute8 = Okc_Api.G_MISS_CHAR)

Line 2117: IF (x_lpo_rec.attribute8 = Okc_Api.G_MISS_CHAR)

2113: IF (x_lpo_rec.attribute7 = Okc_Api.G_MISS_CHAR)
2114: THEN
2115: x_lpo_rec.attribute7 := l_lpo_rec.attribute7;
2116: END IF;
2117: IF (x_lpo_rec.attribute8 = Okc_Api.G_MISS_CHAR)
2118: THEN
2119: x_lpo_rec.attribute8 := l_lpo_rec.attribute8;
2120: END IF;
2121: IF (x_lpo_rec.attribute9 = Okc_Api.G_MISS_CHAR)

Line 2121: IF (x_lpo_rec.attribute9 = Okc_Api.G_MISS_CHAR)

2117: IF (x_lpo_rec.attribute8 = Okc_Api.G_MISS_CHAR)
2118: THEN
2119: x_lpo_rec.attribute8 := l_lpo_rec.attribute8;
2120: END IF;
2121: IF (x_lpo_rec.attribute9 = Okc_Api.G_MISS_CHAR)
2122: THEN
2123: x_lpo_rec.attribute9 := l_lpo_rec.attribute9;
2124: END IF;
2125: IF (x_lpo_rec.attribute10 = Okc_Api.G_MISS_CHAR)

Line 2125: IF (x_lpo_rec.attribute10 = Okc_Api.G_MISS_CHAR)

2121: IF (x_lpo_rec.attribute9 = Okc_Api.G_MISS_CHAR)
2122: THEN
2123: x_lpo_rec.attribute9 := l_lpo_rec.attribute9;
2124: END IF;
2125: IF (x_lpo_rec.attribute10 = Okc_Api.G_MISS_CHAR)
2126: THEN
2127: x_lpo_rec.attribute10 := l_lpo_rec.attribute10;
2128: END IF;
2129: IF (x_lpo_rec.attribute11 = Okc_Api.G_MISS_CHAR)

Line 2129: IF (x_lpo_rec.attribute11 = Okc_Api.G_MISS_CHAR)

2125: IF (x_lpo_rec.attribute10 = Okc_Api.G_MISS_CHAR)
2126: THEN
2127: x_lpo_rec.attribute10 := l_lpo_rec.attribute10;
2128: END IF;
2129: IF (x_lpo_rec.attribute11 = Okc_Api.G_MISS_CHAR)
2130: THEN
2131: x_lpo_rec.attribute11 := l_lpo_rec.attribute11;
2132: END IF;
2133: IF (x_lpo_rec.attribute12 = Okc_Api.G_MISS_CHAR)

Line 2133: IF (x_lpo_rec.attribute12 = Okc_Api.G_MISS_CHAR)

2129: IF (x_lpo_rec.attribute11 = Okc_Api.G_MISS_CHAR)
2130: THEN
2131: x_lpo_rec.attribute11 := l_lpo_rec.attribute11;
2132: END IF;
2133: IF (x_lpo_rec.attribute12 = Okc_Api.G_MISS_CHAR)
2134: THEN
2135: x_lpo_rec.attribute12 := l_lpo_rec.attribute12;
2136: END IF;
2137: IF (x_lpo_rec.attribute13 = Okc_Api.G_MISS_CHAR)

Line 2137: IF (x_lpo_rec.attribute13 = Okc_Api.G_MISS_CHAR)

2133: IF (x_lpo_rec.attribute12 = Okc_Api.G_MISS_CHAR)
2134: THEN
2135: x_lpo_rec.attribute12 := l_lpo_rec.attribute12;
2136: END IF;
2137: IF (x_lpo_rec.attribute13 = Okc_Api.G_MISS_CHAR)
2138: THEN
2139: x_lpo_rec.attribute13 := l_lpo_rec.attribute13;
2140: END IF;
2141: IF (x_lpo_rec.attribute14 = Okc_Api.G_MISS_CHAR)

Line 2141: IF (x_lpo_rec.attribute14 = Okc_Api.G_MISS_CHAR)

2137: IF (x_lpo_rec.attribute13 = Okc_Api.G_MISS_CHAR)
2138: THEN
2139: x_lpo_rec.attribute13 := l_lpo_rec.attribute13;
2140: END IF;
2141: IF (x_lpo_rec.attribute14 = Okc_Api.G_MISS_CHAR)
2142: THEN
2143: x_lpo_rec.attribute14 := l_lpo_rec.attribute14;
2144: END IF;
2145: IF (x_lpo_rec.attribute15 = Okc_Api.G_MISS_CHAR)

Line 2145: IF (x_lpo_rec.attribute15 = Okc_Api.G_MISS_CHAR)

2141: IF (x_lpo_rec.attribute14 = Okc_Api.G_MISS_CHAR)
2142: THEN
2143: x_lpo_rec.attribute14 := l_lpo_rec.attribute14;
2144: END IF;
2145: IF (x_lpo_rec.attribute15 = Okc_Api.G_MISS_CHAR)
2146: THEN
2147: x_lpo_rec.attribute15 := l_lpo_rec.attribute15;
2148: END IF;
2149: IF (x_lpo_rec.created_by = Okc_Api.G_MISS_NUM)

Line 2149: IF (x_lpo_rec.created_by = Okc_Api.G_MISS_NUM)

2145: IF (x_lpo_rec.attribute15 = Okc_Api.G_MISS_CHAR)
2146: THEN
2147: x_lpo_rec.attribute15 := l_lpo_rec.attribute15;
2148: END IF;
2149: IF (x_lpo_rec.created_by = Okc_Api.G_MISS_NUM)
2150: THEN
2151: x_lpo_rec.created_by := l_lpo_rec.created_by;
2152: END IF;
2153: IF (x_lpo_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 2153: IF (x_lpo_rec.creation_date = Okc_Api.G_MISS_DATE)

2149: IF (x_lpo_rec.created_by = Okc_Api.G_MISS_NUM)
2150: THEN
2151: x_lpo_rec.created_by := l_lpo_rec.created_by;
2152: END IF;
2153: IF (x_lpo_rec.creation_date = Okc_Api.G_MISS_DATE)
2154: THEN
2155: x_lpo_rec.creation_date := l_lpo_rec.creation_date;
2156: END IF;
2157: IF (x_lpo_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 2157: IF (x_lpo_rec.last_updated_by = Okc_Api.G_MISS_NUM)

2153: IF (x_lpo_rec.creation_date = Okc_Api.G_MISS_DATE)
2154: THEN
2155: x_lpo_rec.creation_date := l_lpo_rec.creation_date;
2156: END IF;
2157: IF (x_lpo_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2158: THEN
2159: x_lpo_rec.last_updated_by := l_lpo_rec.last_updated_by;
2160: END IF;
2161: IF (x_lpo_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 2161: IF (x_lpo_rec.last_update_date = Okc_Api.G_MISS_DATE)

2157: IF (x_lpo_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2158: THEN
2159: x_lpo_rec.last_updated_by := l_lpo_rec.last_updated_by;
2160: END IF;
2161: IF (x_lpo_rec.last_update_date = Okc_Api.G_MISS_DATE)
2162: THEN
2163: x_lpo_rec.last_update_date := l_lpo_rec.last_update_date;
2164: END IF;
2165: IF (x_lpo_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 2165: IF (x_lpo_rec.last_update_login = Okc_Api.G_MISS_NUM)

2161: IF (x_lpo_rec.last_update_date = Okc_Api.G_MISS_DATE)
2162: THEN
2163: x_lpo_rec.last_update_date := l_lpo_rec.last_update_date;
2164: END IF;
2165: IF (x_lpo_rec.last_update_login = Okc_Api.G_MISS_NUM)
2166: THEN
2167: x_lpo_rec.last_update_login := l_lpo_rec.last_update_login;
2168: END IF;
2169: IF (x_lpo_rec.days_in_year = Okc_Api.G_MISS_CHAR)

Line 2169: IF (x_lpo_rec.days_in_year = Okc_Api.G_MISS_CHAR)

2165: IF (x_lpo_rec.last_update_login = Okc_Api.G_MISS_NUM)
2166: THEN
2167: x_lpo_rec.last_update_login := l_lpo_rec.last_update_login;
2168: END IF;
2169: IF (x_lpo_rec.days_in_year = Okc_Api.G_MISS_CHAR)
2170: THEN
2171: x_lpo_rec.days_in_year := l_lpo_rec.days_in_year;
2172: END IF;
2173: END IF;

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

2179: FUNCTION Set_Attributes (
2180: p_lpo_rec IN lpo_rec_type,
2181: x_lpo_rec OUT NOCOPY lpo_rec_type
2182: ) RETURN VARCHAR2 IS
2183: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2184: BEGIN
2185: x_lpo_rec := p_lpo_rec;
2186: x_lpo_rec.OBJECT_VERSION_NUMBER := p_lpo_rec.OBJECT_VERSION_NUMBER + 1;
2187: RETURN(l_return_status);

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

2186: x_lpo_rec.OBJECT_VERSION_NUMBER := p_lpo_rec.OBJECT_VERSION_NUMBER + 1;
2187: RETURN(l_return_status);
2188: END Set_Attributes;
2189: BEGIN
2190: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2191: p_init_msg_list,
2192: '_PVT',
2193: x_return_status);
2194: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

2190: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2191: p_init_msg_list,
2192: '_PVT',
2193: x_return_status);
2194: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2195: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2196: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2197: RAISE Okc_Api.G_EXCEPTION_ERROR;
2198: END IF;

Line 2195: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2191: p_init_msg_list,
2192: '_PVT',
2193: x_return_status);
2194: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2195: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2196: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2197: RAISE Okc_Api.G_EXCEPTION_ERROR;
2198: END IF;
2199: --- Setting item attributes

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

2192: '_PVT',
2193: x_return_status);
2194: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2195: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2196: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2197: RAISE Okc_Api.G_EXCEPTION_ERROR;
2198: END IF;
2199: --- Setting item attributes
2200: l_return_status := Set_Attributes(

Line 2197: RAISE Okc_Api.G_EXCEPTION_ERROR;

2193: x_return_status);
2194: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2195: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2196: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2197: RAISE Okc_Api.G_EXCEPTION_ERROR;
2198: END IF;
2199: --- Setting item attributes
2200: l_return_status := Set_Attributes(
2201: p_lpo_rec, -- IN

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

2200: l_return_status := Set_Attributes(
2201: p_lpo_rec, -- IN
2202: l_lpo_rec); -- OUT
2203: --- If any errors happen abort API
2204: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2205: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2206: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2207: RAISE Okc_Api.G_EXCEPTION_ERROR;
2208: END IF;

Line 2205: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2201: p_lpo_rec, -- IN
2202: l_lpo_rec); -- OUT
2203: --- If any errors happen abort API
2204: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2205: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2206: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2207: RAISE Okc_Api.G_EXCEPTION_ERROR;
2208: END IF;
2209: l_return_status := populate_new_record(l_lpo_rec, l_def_lpo_rec);

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

2202: l_lpo_rec); -- OUT
2203: --- If any errors happen abort API
2204: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2205: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2206: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2207: RAISE Okc_Api.G_EXCEPTION_ERROR;
2208: END IF;
2209: l_return_status := populate_new_record(l_lpo_rec, l_def_lpo_rec);
2210: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2207: RAISE Okc_Api.G_EXCEPTION_ERROR;

2203: --- If any errors happen abort API
2204: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2205: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2206: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2207: RAISE Okc_Api.G_EXCEPTION_ERROR;
2208: END IF;
2209: l_return_status := populate_new_record(l_lpo_rec, l_def_lpo_rec);
2210: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2211: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

2206: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2207: RAISE Okc_Api.G_EXCEPTION_ERROR;
2208: END IF;
2209: l_return_status := populate_new_record(l_lpo_rec, l_def_lpo_rec);
2210: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2211: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2212: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2213: RAISE Okc_Api.G_EXCEPTION_ERROR;
2214: END IF;

Line 2211: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2207: RAISE Okc_Api.G_EXCEPTION_ERROR;
2208: END IF;
2209: l_return_status := populate_new_record(l_lpo_rec, l_def_lpo_rec);
2210: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2211: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2212: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2213: RAISE Okc_Api.G_EXCEPTION_ERROR;
2214: END IF;
2215: UPDATE OKL_LATE_POLICIES_B

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

2208: END IF;
2209: l_return_status := populate_new_record(l_lpo_rec, l_def_lpo_rec);
2210: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2211: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2212: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2213: RAISE Okc_Api.G_EXCEPTION_ERROR;
2214: END IF;
2215: UPDATE OKL_LATE_POLICIES_B
2216: SET ORG_ID = NVL(l_def_lpo_rec.org_id, MO_GLOBAL.GET_CURRENT_ORG_ID()),

Line 2213: RAISE Okc_Api.G_EXCEPTION_ERROR;

2209: l_return_status := populate_new_record(l_lpo_rec, l_def_lpo_rec);
2210: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2211: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2212: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2213: RAISE Okc_Api.G_EXCEPTION_ERROR;
2214: END IF;
2215: UPDATE OKL_LATE_POLICIES_B
2216: SET ORG_ID = NVL(l_def_lpo_rec.org_id, MO_GLOBAL.GET_CURRENT_ORG_ID()),
2217: ISE_ID = l_def_lpo_rec.ise_id,

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

2260: WHERE ID = l_def_lpo_rec.id;
2261:
2262: x_lpo_rec := l_lpo_rec;
2263: x_return_status := l_return_status;
2264: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2265: EXCEPTION
2266: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2267: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2268: (

Line 2266: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2262: x_lpo_rec := l_lpo_rec;
2263: x_return_status := l_return_status;
2264: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2265: EXCEPTION
2266: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2267: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2268: (
2269: l_api_name,
2270: G_PKG_NAME,

Line 2267: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2263: x_return_status := l_return_status;
2264: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2265: EXCEPTION
2266: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2267: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2268: (
2269: l_api_name,
2270: G_PKG_NAME,
2271: 'OKC_API.G_RET_STS_ERROR',

Line 2271: 'OKC_API.G_RET_STS_ERROR',

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

Line 2276: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2272: x_msg_count,
2273: x_msg_data,
2274: '_PVT'
2275: );
2276: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2277: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2278: (
2279: l_api_name,
2280: G_PKG_NAME,

Line 2277: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 2281: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2277: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2278: (
2279: l_api_name,
2280: G_PKG_NAME,
2281: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2282: x_msg_count,
2283: x_msg_data,
2284: '_PVT'
2285: );

Line 2287: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2283: x_msg_data,
2284: '_PVT'
2285: );
2286: WHEN OTHERS THEN
2287: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2288: (
2289: l_api_name,
2290: G_PKG_NAME,
2291: 'OTHERS',

Line 2301: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2297: -----------------------------------------
2298: -- update_row for:OKL_LATE_POLICIES_TL --
2299: -----------------------------------------
2300: PROCEDURE update_row(
2301: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2302: x_return_status OUT NOCOPY VARCHAR2,
2303: x_msg_count OUT NOCOPY NUMBER,
2304: x_msg_data OUT NOCOPY VARCHAR2,
2305: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,

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

2306: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type) IS
2307:
2308: l_api_version CONSTANT NUMBER := 1;
2309: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2310: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2311: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type := p_okl_late_policies_tl_rec;
2312: l_def_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
2313: l_row_notfound BOOLEAN := TRUE;
2314: ----------------------------------

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

2319: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type
2320: ) RETURN VARCHAR2 IS
2321: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
2322: l_row_notfound BOOLEAN := TRUE;
2323: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2324: BEGIN
2325: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;
2326: -- Get current database values
2327: l_okl_late_policies_tl_rec := get_rec(p_okl_late_policies_tl_rec, l_return_status);

Line 2328: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN

2324: BEGIN
2325: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;
2326: -- Get current database values
2327: l_okl_late_policies_tl_rec := get_rec(p_okl_late_policies_tl_rec, l_return_status);
2328: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
2329: IF (x_okl_late_policies_tl_rec.id = Okc_Api.G_MISS_NUM)
2330: THEN
2331: x_okl_late_policies_tl_rec.id := l_okl_late_policies_tl_rec.id;
2332: END IF;

Line 2329: IF (x_okl_late_policies_tl_rec.id = Okc_Api.G_MISS_NUM)

2325: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;
2326: -- Get current database values
2327: l_okl_late_policies_tl_rec := get_rec(p_okl_late_policies_tl_rec, l_return_status);
2328: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
2329: IF (x_okl_late_policies_tl_rec.id = Okc_Api.G_MISS_NUM)
2330: THEN
2331: x_okl_late_policies_tl_rec.id := l_okl_late_policies_tl_rec.id;
2332: END IF;
2333: IF (x_okl_late_policies_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)

Line 2333: IF (x_okl_late_policies_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)

2329: IF (x_okl_late_policies_tl_rec.id = Okc_Api.G_MISS_NUM)
2330: THEN
2331: x_okl_late_policies_tl_rec.id := l_okl_late_policies_tl_rec.id;
2332: END IF;
2333: IF (x_okl_late_policies_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2334: THEN
2335: x_okl_late_policies_tl_rec.LANGUAGE := l_okl_late_policies_tl_rec.LANGUAGE;
2336: END IF;
2337: IF (x_okl_late_policies_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)

Line 2337: IF (x_okl_late_policies_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)

2333: IF (x_okl_late_policies_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2334: THEN
2335: x_okl_late_policies_tl_rec.LANGUAGE := l_okl_late_policies_tl_rec.LANGUAGE;
2336: END IF;
2337: IF (x_okl_late_policies_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2338: THEN
2339: x_okl_late_policies_tl_rec.source_lang := l_okl_late_policies_tl_rec.source_lang;
2340: END IF;
2341: IF (x_okl_late_policies_tl_rec.name = Okc_Api.G_MISS_CHAR)

Line 2341: IF (x_okl_late_policies_tl_rec.name = Okc_Api.G_MISS_CHAR)

2337: IF (x_okl_late_policies_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2338: THEN
2339: x_okl_late_policies_tl_rec.source_lang := l_okl_late_policies_tl_rec.source_lang;
2340: END IF;
2341: IF (x_okl_late_policies_tl_rec.name = Okc_Api.G_MISS_CHAR)
2342: THEN
2343: x_okl_late_policies_tl_rec.name := l_okl_late_policies_tl_rec.name;
2344: END IF;
2345: IF (x_okl_late_policies_tl_rec.description = Okc_Api.G_MISS_CHAR)

Line 2345: IF (x_okl_late_policies_tl_rec.description = Okc_Api.G_MISS_CHAR)

2341: IF (x_okl_late_policies_tl_rec.name = Okc_Api.G_MISS_CHAR)
2342: THEN
2343: x_okl_late_policies_tl_rec.name := l_okl_late_policies_tl_rec.name;
2344: END IF;
2345: IF (x_okl_late_policies_tl_rec.description = Okc_Api.G_MISS_CHAR)
2346: THEN
2347: x_okl_late_policies_tl_rec.description := l_okl_late_policies_tl_rec.description;
2348: END IF;
2349: IF (x_okl_late_policies_tl_rec.created_by = Okc_Api.G_MISS_NUM)

Line 2349: IF (x_okl_late_policies_tl_rec.created_by = Okc_Api.G_MISS_NUM)

2345: IF (x_okl_late_policies_tl_rec.description = Okc_Api.G_MISS_CHAR)
2346: THEN
2347: x_okl_late_policies_tl_rec.description := l_okl_late_policies_tl_rec.description;
2348: END IF;
2349: IF (x_okl_late_policies_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2350: THEN
2351: x_okl_late_policies_tl_rec.created_by := l_okl_late_policies_tl_rec.created_by;
2352: END IF;
2353: IF (x_okl_late_policies_tl_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 2353: IF (x_okl_late_policies_tl_rec.creation_date = Okc_Api.G_MISS_DATE)

2349: IF (x_okl_late_policies_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2350: THEN
2351: x_okl_late_policies_tl_rec.created_by := l_okl_late_policies_tl_rec.created_by;
2352: END IF;
2353: IF (x_okl_late_policies_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2354: THEN
2355: x_okl_late_policies_tl_rec.creation_date := l_okl_late_policies_tl_rec.creation_date;
2356: END IF;
2357: IF (x_okl_late_policies_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 2357: IF (x_okl_late_policies_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)

2353: IF (x_okl_late_policies_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2354: THEN
2355: x_okl_late_policies_tl_rec.creation_date := l_okl_late_policies_tl_rec.creation_date;
2356: END IF;
2357: IF (x_okl_late_policies_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2358: THEN
2359: x_okl_late_policies_tl_rec.last_updated_by := l_okl_late_policies_tl_rec.last_updated_by;
2360: END IF;
2361: IF (x_okl_late_policies_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 2361: IF (x_okl_late_policies_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)

2357: IF (x_okl_late_policies_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2358: THEN
2359: x_okl_late_policies_tl_rec.last_updated_by := l_okl_late_policies_tl_rec.last_updated_by;
2360: END IF;
2361: IF (x_okl_late_policies_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2362: THEN
2363: x_okl_late_policies_tl_rec.last_update_date := l_okl_late_policies_tl_rec.last_update_date;
2364: END IF;
2365: IF (x_okl_late_policies_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 2365: IF (x_okl_late_policies_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)

2361: IF (x_okl_late_policies_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2362: THEN
2363: x_okl_late_policies_tl_rec.last_update_date := l_okl_late_policies_tl_rec.last_update_date;
2364: END IF;
2365: IF (x_okl_late_policies_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
2366: THEN
2367: x_okl_late_policies_tl_rec.last_update_login := l_okl_late_policies_tl_rec.last_update_login;
2368: END IF;
2369: END IF;

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

2375: FUNCTION Set_Attributes (
2376: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type,
2377: x_okl_late_policies_tl_rec OUT NOCOPY okl_late_policies_tl_rec_type
2378: ) RETURN VARCHAR2 IS
2379: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2380: BEGIN
2381: x_okl_late_policies_tl_rec := p_okl_late_policies_tl_rec;
2382: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');
2383: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');

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

2383: x_okl_late_policies_tl_rec.LANGUAGE := USERENV('LANG');
2384: RETURN(l_return_status);
2385: END Set_Attributes;
2386: BEGIN
2387: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2388: p_init_msg_list,
2389: '_PVT',
2390: x_return_status);
2391: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

2387: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2388: p_init_msg_list,
2389: '_PVT',
2390: x_return_status);
2391: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2392: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2393: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2394: RAISE Okc_Api.G_EXCEPTION_ERROR;
2395: END IF;

Line 2392: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2388: p_init_msg_list,
2389: '_PVT',
2390: x_return_status);
2391: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2392: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2393: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2394: RAISE Okc_Api.G_EXCEPTION_ERROR;
2395: END IF;
2396: --- Setting item attributes

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

2389: '_PVT',
2390: x_return_status);
2391: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2392: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2393: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2394: RAISE Okc_Api.G_EXCEPTION_ERROR;
2395: END IF;
2396: --- Setting item attributes
2397: l_return_status := Set_Attributes(

Line 2394: RAISE Okc_Api.G_EXCEPTION_ERROR;

2390: x_return_status);
2391: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2392: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2393: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2394: RAISE Okc_Api.G_EXCEPTION_ERROR;
2395: END IF;
2396: --- Setting item attributes
2397: l_return_status := Set_Attributes(
2398: p_okl_late_policies_tl_rec, -- IN

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

2397: l_return_status := Set_Attributes(
2398: p_okl_late_policies_tl_rec, -- IN
2399: l_okl_late_policies_tl_rec); -- OUT
2400: --- If any errors happen abort API
2401: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2402: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2403: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2404: RAISE Okc_Api.G_EXCEPTION_ERROR;
2405: END IF;

Line 2402: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2398: p_okl_late_policies_tl_rec, -- IN
2399: l_okl_late_policies_tl_rec); -- OUT
2400: --- If any errors happen abort API
2401: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2402: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2403: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2404: RAISE Okc_Api.G_EXCEPTION_ERROR;
2405: END IF;
2406: l_return_status := populate_new_record(l_okl_late_policies_tl_rec, l_def_okl_late_policies_tl_rec);

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

2399: l_okl_late_policies_tl_rec); -- OUT
2400: --- If any errors happen abort API
2401: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2402: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2403: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2404: RAISE Okc_Api.G_EXCEPTION_ERROR;
2405: END IF;
2406: l_return_status := populate_new_record(l_okl_late_policies_tl_rec, l_def_okl_late_policies_tl_rec);
2407: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2404: RAISE Okc_Api.G_EXCEPTION_ERROR;

2400: --- If any errors happen abort API
2401: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2402: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2403: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2404: RAISE Okc_Api.G_EXCEPTION_ERROR;
2405: END IF;
2406: l_return_status := populate_new_record(l_okl_late_policies_tl_rec, l_def_okl_late_policies_tl_rec);
2407: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2408: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

2403: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2404: RAISE Okc_Api.G_EXCEPTION_ERROR;
2405: END IF;
2406: l_return_status := populate_new_record(l_okl_late_policies_tl_rec, l_def_okl_late_policies_tl_rec);
2407: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2408: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2409: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2410: RAISE Okc_Api.G_EXCEPTION_ERROR;
2411: END IF;

Line 2408: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2404: RAISE Okc_Api.G_EXCEPTION_ERROR;
2405: END IF;
2406: l_return_status := populate_new_record(l_okl_late_policies_tl_rec, l_def_okl_late_policies_tl_rec);
2407: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2408: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2409: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2410: RAISE Okc_Api.G_EXCEPTION_ERROR;
2411: END IF;
2412: UPDATE OKL_LATE_POLICIES_TL

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

2405: END IF;
2406: l_return_status := populate_new_record(l_okl_late_policies_tl_rec, l_def_okl_late_policies_tl_rec);
2407: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2408: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2409: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2410: RAISE Okc_Api.G_EXCEPTION_ERROR;
2411: END IF;
2412: UPDATE OKL_LATE_POLICIES_TL
2413: SET NAME = l_def_okl_late_policies_tl_rec.name,

Line 2410: RAISE Okc_Api.G_EXCEPTION_ERROR;

2406: l_return_status := populate_new_record(l_okl_late_policies_tl_rec, l_def_okl_late_policies_tl_rec);
2407: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2408: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2409: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2410: RAISE Okc_Api.G_EXCEPTION_ERROR;
2411: END IF;
2412: UPDATE OKL_LATE_POLICIES_TL
2413: SET NAME = l_def_okl_late_policies_tl_rec.name,
2414: DESCRIPTION = l_def_okl_late_policies_tl_rec.description,

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

2427: AND SOURCE_LANG <> USERENV('LANG');
2428: */
2429: x_okl_late_policies_tl_rec := l_okl_late_policies_tl_rec;
2430: x_return_status := l_return_status;
2431: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2432: EXCEPTION
2433: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2434: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2435: (

Line 2433: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2429: x_okl_late_policies_tl_rec := l_okl_late_policies_tl_rec;
2430: x_return_status := l_return_status;
2431: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2432: EXCEPTION
2433: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2434: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2435: (
2436: l_api_name,
2437: G_PKG_NAME,

Line 2434: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 2438: 'OKC_API.G_RET_STS_ERROR',

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

Line 2443: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2444: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 2448: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 2454: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 2469: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2465: -- update_row for:OKL_LATE_POLICIES_V --
2466: ----------------------------------------
2467: PROCEDURE update_row(
2468: p_api_version IN NUMBER,
2469: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2470: x_return_status OUT NOCOPY VARCHAR2,
2471: x_msg_count OUT NOCOPY NUMBER,
2472: x_msg_data OUT NOCOPY VARCHAR2,
2473: p_lpov_rec IN lpov_rec_type,

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

2474: x_lpov_rec OUT NOCOPY lpov_rec_type) IS
2475:
2476: l_api_version CONSTANT NUMBER := 1;
2477: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2478: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2479: l_lpov_rec lpov_rec_type := p_lpov_rec;
2480: l_def_lpov_rec lpov_rec_type;
2481: l_db_lpov_rec lpov_rec_type;
2482: l_lpo_rec lpo_rec_type;

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

2503: p_lpov_rec IN lpov_rec_type,
2504: x_lpov_rec OUT NOCOPY lpov_rec_type
2505: ) RETURN VARCHAR2 IS
2506: l_row_notfound BOOLEAN := TRUE;
2507: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2508: BEGIN
2509: x_lpov_rec := p_lpov_rec;
2510: -- Get current database values
2511: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it

Line 2514: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN

2510: -- Get current database values
2511: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2512: -- so it may be verified through LOCK_ROW.
2513: l_db_lpov_rec := get_rec(p_lpov_rec, l_return_status);
2514: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
2515: IF (x_lpov_rec.id = Okc_Api.G_MISS_NUM)
2516: THEN
2517: x_lpov_rec.id := l_db_lpov_rec.id;
2518: END IF;

Line 2515: IF (x_lpov_rec.id = Okc_Api.G_MISS_NUM)

2511: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
2512: -- so it may be verified through LOCK_ROW.
2513: l_db_lpov_rec := get_rec(p_lpov_rec, l_return_status);
2514: IF (l_return_status = Okc_Api.G_RET_STS_SUCCESS) THEN
2515: IF (x_lpov_rec.id = Okc_Api.G_MISS_NUM)
2516: THEN
2517: x_lpov_rec.id := l_db_lpov_rec.id;
2518: END IF;
2519: IF (x_lpov_rec.org_id = Okc_Api.G_MISS_NUM)

Line 2519: IF (x_lpov_rec.org_id = Okc_Api.G_MISS_NUM)

2515: IF (x_lpov_rec.id = Okc_Api.G_MISS_NUM)
2516: THEN
2517: x_lpov_rec.id := l_db_lpov_rec.id;
2518: END IF;
2519: IF (x_lpov_rec.org_id = Okc_Api.G_MISS_NUM)
2520: THEN
2521: x_lpov_rec.org_id := l_db_lpov_rec.org_id;
2522: END IF;
2523: IF (x_lpov_rec.object_version_number = Okl_Api.G_MISS_NUM)

Line 2527: IF (x_lpov_rec.name = Okc_Api.G_MISS_CHAR)

2523: IF (x_lpov_rec.object_version_number = Okl_Api.G_MISS_NUM)
2524: THEN
2525: x_lpov_rec.object_version_number := l_db_lpov_rec.object_version_number;
2526: END IF;
2527: IF (x_lpov_rec.name = Okc_Api.G_MISS_CHAR)
2528: THEN
2529: x_lpov_rec.name := l_db_lpov_rec.name;
2530: END IF;
2531: IF (x_lpov_rec.description = Okc_Api.G_MISS_CHAR)

Line 2531: IF (x_lpov_rec.description = Okc_Api.G_MISS_CHAR)

2527: IF (x_lpov_rec.name = Okc_Api.G_MISS_CHAR)
2528: THEN
2529: x_lpov_rec.name := l_db_lpov_rec.name;
2530: END IF;
2531: IF (x_lpov_rec.description = Okc_Api.G_MISS_CHAR)
2532: THEN
2533: x_lpov_rec.description := l_db_lpov_rec.description;
2534: END IF;
2535: IF (x_lpov_rec.ise_id = Okc_Api.G_MISS_NUM)

Line 2535: IF (x_lpov_rec.ise_id = Okc_Api.G_MISS_NUM)

2531: IF (x_lpov_rec.description = Okc_Api.G_MISS_CHAR)
2532: THEN
2533: x_lpov_rec.description := l_db_lpov_rec.description;
2534: END IF;
2535: IF (x_lpov_rec.ise_id = Okc_Api.G_MISS_NUM)
2536: THEN
2537: x_lpov_rec.ise_id := l_db_lpov_rec.ise_id;
2538: END IF;
2539: IF (x_lpov_rec.tdf_id = Okc_Api.G_MISS_NUM)

Line 2539: IF (x_lpov_rec.tdf_id = Okc_Api.G_MISS_NUM)

2535: IF (x_lpov_rec.ise_id = Okc_Api.G_MISS_NUM)
2536: THEN
2537: x_lpov_rec.ise_id := l_db_lpov_rec.ise_id;
2538: END IF;
2539: IF (x_lpov_rec.tdf_id = Okc_Api.G_MISS_NUM)
2540: THEN
2541: x_lpov_rec.tdf_id := l_db_lpov_rec.tdf_id;
2542: END IF;
2543: IF (x_lpov_rec.idx_id = Okc_Api.G_MISS_NUM)

Line 2543: IF (x_lpov_rec.idx_id = Okc_Api.G_MISS_NUM)

2539: IF (x_lpov_rec.tdf_id = Okc_Api.G_MISS_NUM)
2540: THEN
2541: x_lpov_rec.tdf_id := l_db_lpov_rec.tdf_id;
2542: END IF;
2543: IF (x_lpov_rec.idx_id = Okc_Api.G_MISS_NUM)
2544: THEN
2545: x_lpov_rec.idx_id := l_db_lpov_rec.idx_id;
2546: END IF;
2547: IF (x_lpov_rec.late_policy_type_code = Okc_Api.G_MISS_CHAR)

Line 2547: IF (x_lpov_rec.late_policy_type_code = Okc_Api.G_MISS_CHAR)

2543: IF (x_lpov_rec.idx_id = Okc_Api.G_MISS_NUM)
2544: THEN
2545: x_lpov_rec.idx_id := l_db_lpov_rec.idx_id;
2546: END IF;
2547: IF (x_lpov_rec.late_policy_type_code = Okc_Api.G_MISS_CHAR)
2548: THEN
2549: x_lpov_rec.late_policy_type_code := l_db_lpov_rec.late_policy_type_code;
2550: END IF;
2551: IF (x_lpov_rec.late_chrg_allowed_yn = Okc_Api.G_MISS_CHAR)

Line 2551: IF (x_lpov_rec.late_chrg_allowed_yn = Okc_Api.G_MISS_CHAR)

2547: IF (x_lpov_rec.late_policy_type_code = Okc_Api.G_MISS_CHAR)
2548: THEN
2549: x_lpov_rec.late_policy_type_code := l_db_lpov_rec.late_policy_type_code;
2550: END IF;
2551: IF (x_lpov_rec.late_chrg_allowed_yn = Okc_Api.G_MISS_CHAR)
2552: THEN
2553: x_lpov_rec.late_chrg_allowed_yn := l_db_lpov_rec.late_chrg_allowed_yn;
2554: END IF;
2555: IF (x_lpov_rec.late_chrg_fixed_yn = Okc_Api.G_MISS_CHAR)

Line 2555: IF (x_lpov_rec.late_chrg_fixed_yn = Okc_Api.G_MISS_CHAR)

2551: IF (x_lpov_rec.late_chrg_allowed_yn = Okc_Api.G_MISS_CHAR)
2552: THEN
2553: x_lpov_rec.late_chrg_allowed_yn := l_db_lpov_rec.late_chrg_allowed_yn;
2554: END IF;
2555: IF (x_lpov_rec.late_chrg_fixed_yn = Okc_Api.G_MISS_CHAR)
2556: THEN
2557: x_lpov_rec.late_chrg_fixed_yn := l_db_lpov_rec.late_chrg_fixed_yn;
2558: END IF;
2559: IF (x_lpov_rec.late_chrg_amount = Okc_Api.G_MISS_NUM)

Line 2559: IF (x_lpov_rec.late_chrg_amount = Okc_Api.G_MISS_NUM)

2555: IF (x_lpov_rec.late_chrg_fixed_yn = Okc_Api.G_MISS_CHAR)
2556: THEN
2557: x_lpov_rec.late_chrg_fixed_yn := l_db_lpov_rec.late_chrg_fixed_yn;
2558: END IF;
2559: IF (x_lpov_rec.late_chrg_amount = Okc_Api.G_MISS_NUM)
2560: THEN
2561: x_lpov_rec.late_chrg_amount := l_db_lpov_rec.late_chrg_amount;
2562: END IF;
2563: IF (x_lpov_rec.late_chrg_rate = Okc_Api.G_MISS_NUM)

Line 2563: IF (x_lpov_rec.late_chrg_rate = Okc_Api.G_MISS_NUM)

2559: IF (x_lpov_rec.late_chrg_amount = Okc_Api.G_MISS_NUM)
2560: THEN
2561: x_lpov_rec.late_chrg_amount := l_db_lpov_rec.late_chrg_amount;
2562: END IF;
2563: IF (x_lpov_rec.late_chrg_rate = Okc_Api.G_MISS_NUM)
2564: THEN
2565: x_lpov_rec.late_chrg_rate := l_db_lpov_rec.late_chrg_rate;
2566: END IF;
2567: IF (x_lpov_rec.late_chrg_grace_period = Okc_Api.G_MISS_NUM)

Line 2567: IF (x_lpov_rec.late_chrg_grace_period = Okc_Api.G_MISS_NUM)

2563: IF (x_lpov_rec.late_chrg_rate = Okc_Api.G_MISS_NUM)
2564: THEN
2565: x_lpov_rec.late_chrg_rate := l_db_lpov_rec.late_chrg_rate;
2566: END IF;
2567: IF (x_lpov_rec.late_chrg_grace_period = Okc_Api.G_MISS_NUM)
2568: THEN
2569: x_lpov_rec.late_chrg_grace_period := l_db_lpov_rec.late_chrg_grace_period;
2570: END IF;
2571: IF (x_lpov_rec.late_chrg_minimum_balance = Okc_Api.G_MISS_NUM)

Line 2571: IF (x_lpov_rec.late_chrg_minimum_balance = Okc_Api.G_MISS_NUM)

2567: IF (x_lpov_rec.late_chrg_grace_period = Okc_Api.G_MISS_NUM)
2568: THEN
2569: x_lpov_rec.late_chrg_grace_period := l_db_lpov_rec.late_chrg_grace_period;
2570: END IF;
2571: IF (x_lpov_rec.late_chrg_minimum_balance = Okc_Api.G_MISS_NUM)
2572: THEN
2573: x_lpov_rec.late_chrg_minimum_balance := l_db_lpov_rec.late_chrg_minimum_balance;
2574: END IF;
2575: IF (x_lpov_rec.minimum_late_charge = Okc_Api.G_MISS_NUM)

Line 2575: IF (x_lpov_rec.minimum_late_charge = Okc_Api.G_MISS_NUM)

2571: IF (x_lpov_rec.late_chrg_minimum_balance = Okc_Api.G_MISS_NUM)
2572: THEN
2573: x_lpov_rec.late_chrg_minimum_balance := l_db_lpov_rec.late_chrg_minimum_balance;
2574: END IF;
2575: IF (x_lpov_rec.minimum_late_charge = Okc_Api.G_MISS_NUM)
2576: THEN
2577: x_lpov_rec.minimum_late_charge := l_db_lpov_rec.minimum_late_charge;
2578: END IF;
2579: IF (x_lpov_rec.maximum_late_charge = Okc_Api.G_MISS_NUM)

Line 2579: IF (x_lpov_rec.maximum_late_charge = Okc_Api.G_MISS_NUM)

2575: IF (x_lpov_rec.minimum_late_charge = Okc_Api.G_MISS_NUM)
2576: THEN
2577: x_lpov_rec.minimum_late_charge := l_db_lpov_rec.minimum_late_charge;
2578: END IF;
2579: IF (x_lpov_rec.maximum_late_charge = Okc_Api.G_MISS_NUM)
2580: THEN
2581: x_lpov_rec.maximum_late_charge := l_db_lpov_rec.maximum_late_charge;
2582: END IF;
2583: IF (x_lpov_rec.late_int_allowed_yn = Okc_Api.G_MISS_CHAR)

Line 2583: IF (x_lpov_rec.late_int_allowed_yn = Okc_Api.G_MISS_CHAR)

2579: IF (x_lpov_rec.maximum_late_charge = Okc_Api.G_MISS_NUM)
2580: THEN
2581: x_lpov_rec.maximum_late_charge := l_db_lpov_rec.maximum_late_charge;
2582: END IF;
2583: IF (x_lpov_rec.late_int_allowed_yn = Okc_Api.G_MISS_CHAR)
2584: THEN
2585: x_lpov_rec.late_int_allowed_yn := l_db_lpov_rec.late_int_allowed_yn;
2586: END IF;
2587: IF (x_lpov_rec.late_int_fixed_yn = Okc_Api.G_MISS_CHAR)

Line 2587: IF (x_lpov_rec.late_int_fixed_yn = Okc_Api.G_MISS_CHAR)

2583: IF (x_lpov_rec.late_int_allowed_yn = Okc_Api.G_MISS_CHAR)
2584: THEN
2585: x_lpov_rec.late_int_allowed_yn := l_db_lpov_rec.late_int_allowed_yn;
2586: END IF;
2587: IF (x_lpov_rec.late_int_fixed_yn = Okc_Api.G_MISS_CHAR)
2588: THEN
2589: x_lpov_rec.late_int_fixed_yn := l_db_lpov_rec.late_int_fixed_yn;
2590: END IF;
2591: IF (x_lpov_rec.late_int_rate = Okc_Api.G_MISS_NUM)

Line 2591: IF (x_lpov_rec.late_int_rate = Okc_Api.G_MISS_NUM)

2587: IF (x_lpov_rec.late_int_fixed_yn = Okc_Api.G_MISS_CHAR)
2588: THEN
2589: x_lpov_rec.late_int_fixed_yn := l_db_lpov_rec.late_int_fixed_yn;
2590: END IF;
2591: IF (x_lpov_rec.late_int_rate = Okc_Api.G_MISS_NUM)
2592: THEN
2593: x_lpov_rec.late_int_rate := l_db_lpov_rec.late_int_rate;
2594: END IF;
2595: IF (x_lpov_rec.adder_rate = Okc_Api.G_MISS_NUM)

Line 2595: IF (x_lpov_rec.adder_rate = Okc_Api.G_MISS_NUM)

2591: IF (x_lpov_rec.late_int_rate = Okc_Api.G_MISS_NUM)
2592: THEN
2593: x_lpov_rec.late_int_rate := l_db_lpov_rec.late_int_rate;
2594: END IF;
2595: IF (x_lpov_rec.adder_rate = Okc_Api.G_MISS_NUM)
2596: THEN
2597: x_lpov_rec.adder_rate := l_db_lpov_rec.adder_rate;
2598: END IF;
2599: IF (x_lpov_rec.late_int_grace_period = Okc_Api.G_MISS_NUM)

Line 2599: IF (x_lpov_rec.late_int_grace_period = Okc_Api.G_MISS_NUM)

2595: IF (x_lpov_rec.adder_rate = Okc_Api.G_MISS_NUM)
2596: THEN
2597: x_lpov_rec.adder_rate := l_db_lpov_rec.adder_rate;
2598: END IF;
2599: IF (x_lpov_rec.late_int_grace_period = Okc_Api.G_MISS_NUM)
2600: THEN
2601: x_lpov_rec.late_int_grace_period := l_db_lpov_rec.late_int_grace_period;
2602: END IF;
2603: IF (x_lpov_rec.late_int_minimum_balance = Okc_Api.G_MISS_NUM)

Line 2603: IF (x_lpov_rec.late_int_minimum_balance = Okc_Api.G_MISS_NUM)

2599: IF (x_lpov_rec.late_int_grace_period = Okc_Api.G_MISS_NUM)
2600: THEN
2601: x_lpov_rec.late_int_grace_period := l_db_lpov_rec.late_int_grace_period;
2602: END IF;
2603: IF (x_lpov_rec.late_int_minimum_balance = Okc_Api.G_MISS_NUM)
2604: THEN
2605: x_lpov_rec.late_int_minimum_balance := l_db_lpov_rec.late_int_minimum_balance;
2606: END IF;
2607: IF (x_lpov_rec.minimum_late_interest = Okc_Api.G_MISS_NUM)

Line 2607: IF (x_lpov_rec.minimum_late_interest = Okc_Api.G_MISS_NUM)

2603: IF (x_lpov_rec.late_int_minimum_balance = Okc_Api.G_MISS_NUM)
2604: THEN
2605: x_lpov_rec.late_int_minimum_balance := l_db_lpov_rec.late_int_minimum_balance;
2606: END IF;
2607: IF (x_lpov_rec.minimum_late_interest = Okc_Api.G_MISS_NUM)
2608: THEN
2609: x_lpov_rec.minimum_late_interest := l_db_lpov_rec.minimum_late_interest;
2610: END IF;
2611: IF (x_lpov_rec.maximum_late_interest = Okc_Api.G_MISS_NUM)

Line 2611: IF (x_lpov_rec.maximum_late_interest = Okc_Api.G_MISS_NUM)

2607: IF (x_lpov_rec.minimum_late_interest = Okc_Api.G_MISS_NUM)
2608: THEN
2609: x_lpov_rec.minimum_late_interest := l_db_lpov_rec.minimum_late_interest;
2610: END IF;
2611: IF (x_lpov_rec.maximum_late_interest = Okc_Api.G_MISS_NUM)
2612: THEN
2613: x_lpov_rec.maximum_late_interest := l_db_lpov_rec.maximum_late_interest;
2614: END IF;
2615: IF (x_lpov_rec.attribute_category = Okc_Api.G_MISS_CHAR)

Line 2615: IF (x_lpov_rec.attribute_category = Okc_Api.G_MISS_CHAR)

2611: IF (x_lpov_rec.maximum_late_interest = Okc_Api.G_MISS_NUM)
2612: THEN
2613: x_lpov_rec.maximum_late_interest := l_db_lpov_rec.maximum_late_interest;
2614: END IF;
2615: IF (x_lpov_rec.attribute_category = Okc_Api.G_MISS_CHAR)
2616: THEN
2617: x_lpov_rec.attribute_category := l_db_lpov_rec.attribute_category;
2618: END IF;
2619: IF (x_lpov_rec.attribute1 = Okc_Api.G_MISS_CHAR)

Line 2619: IF (x_lpov_rec.attribute1 = Okc_Api.G_MISS_CHAR)

2615: IF (x_lpov_rec.attribute_category = Okc_Api.G_MISS_CHAR)
2616: THEN
2617: x_lpov_rec.attribute_category := l_db_lpov_rec.attribute_category;
2618: END IF;
2619: IF (x_lpov_rec.attribute1 = Okc_Api.G_MISS_CHAR)
2620: THEN
2621: x_lpov_rec.attribute1 := l_db_lpov_rec.attribute1;
2622: END IF;
2623: IF (x_lpov_rec.attribute2 = Okc_Api.G_MISS_CHAR)

Line 2623: IF (x_lpov_rec.attribute2 = Okc_Api.G_MISS_CHAR)

2619: IF (x_lpov_rec.attribute1 = Okc_Api.G_MISS_CHAR)
2620: THEN
2621: x_lpov_rec.attribute1 := l_db_lpov_rec.attribute1;
2622: END IF;
2623: IF (x_lpov_rec.attribute2 = Okc_Api.G_MISS_CHAR)
2624: THEN
2625: x_lpov_rec.attribute2 := l_db_lpov_rec.attribute2;
2626: END IF;
2627: IF (x_lpov_rec.attribute3 = Okc_Api.G_MISS_CHAR)

Line 2627: IF (x_lpov_rec.attribute3 = Okc_Api.G_MISS_CHAR)

2623: IF (x_lpov_rec.attribute2 = Okc_Api.G_MISS_CHAR)
2624: THEN
2625: x_lpov_rec.attribute2 := l_db_lpov_rec.attribute2;
2626: END IF;
2627: IF (x_lpov_rec.attribute3 = Okc_Api.G_MISS_CHAR)
2628: THEN
2629: x_lpov_rec.attribute3 := l_db_lpov_rec.attribute3;
2630: END IF;
2631: IF (x_lpov_rec.attribute4 = Okc_Api.G_MISS_CHAR)

Line 2631: IF (x_lpov_rec.attribute4 = Okc_Api.G_MISS_CHAR)

2627: IF (x_lpov_rec.attribute3 = Okc_Api.G_MISS_CHAR)
2628: THEN
2629: x_lpov_rec.attribute3 := l_db_lpov_rec.attribute3;
2630: END IF;
2631: IF (x_lpov_rec.attribute4 = Okc_Api.G_MISS_CHAR)
2632: THEN
2633: x_lpov_rec.attribute4 := l_db_lpov_rec.attribute4;
2634: END IF;
2635: IF (x_lpov_rec.attribute5 = Okc_Api.G_MISS_CHAR)

Line 2635: IF (x_lpov_rec.attribute5 = Okc_Api.G_MISS_CHAR)

2631: IF (x_lpov_rec.attribute4 = Okc_Api.G_MISS_CHAR)
2632: THEN
2633: x_lpov_rec.attribute4 := l_db_lpov_rec.attribute4;
2634: END IF;
2635: IF (x_lpov_rec.attribute5 = Okc_Api.G_MISS_CHAR)
2636: THEN
2637: x_lpov_rec.attribute5 := l_db_lpov_rec.attribute5;
2638: END IF;
2639: IF (x_lpov_rec.attribute6 = Okc_Api.G_MISS_CHAR)

Line 2639: IF (x_lpov_rec.attribute6 = Okc_Api.G_MISS_CHAR)

2635: IF (x_lpov_rec.attribute5 = Okc_Api.G_MISS_CHAR)
2636: THEN
2637: x_lpov_rec.attribute5 := l_db_lpov_rec.attribute5;
2638: END IF;
2639: IF (x_lpov_rec.attribute6 = Okc_Api.G_MISS_CHAR)
2640: THEN
2641: x_lpov_rec.attribute6 := l_db_lpov_rec.attribute6;
2642: END IF;
2643: IF (x_lpov_rec.attribute7 = Okc_Api.G_MISS_CHAR)

Line 2643: IF (x_lpov_rec.attribute7 = Okc_Api.G_MISS_CHAR)

2639: IF (x_lpov_rec.attribute6 = Okc_Api.G_MISS_CHAR)
2640: THEN
2641: x_lpov_rec.attribute6 := l_db_lpov_rec.attribute6;
2642: END IF;
2643: IF (x_lpov_rec.attribute7 = Okc_Api.G_MISS_CHAR)
2644: THEN
2645: x_lpov_rec.attribute7 := l_db_lpov_rec.attribute7;
2646: END IF;
2647: IF (x_lpov_rec.attribute8 = Okc_Api.G_MISS_CHAR)

Line 2647: IF (x_lpov_rec.attribute8 = Okc_Api.G_MISS_CHAR)

2643: IF (x_lpov_rec.attribute7 = Okc_Api.G_MISS_CHAR)
2644: THEN
2645: x_lpov_rec.attribute7 := l_db_lpov_rec.attribute7;
2646: END IF;
2647: IF (x_lpov_rec.attribute8 = Okc_Api.G_MISS_CHAR)
2648: THEN
2649: x_lpov_rec.attribute8 := l_db_lpov_rec.attribute8;
2650: END IF;
2651: IF (x_lpov_rec.attribute9 = Okc_Api.G_MISS_CHAR)

Line 2651: IF (x_lpov_rec.attribute9 = Okc_Api.G_MISS_CHAR)

2647: IF (x_lpov_rec.attribute8 = Okc_Api.G_MISS_CHAR)
2648: THEN
2649: x_lpov_rec.attribute8 := l_db_lpov_rec.attribute8;
2650: END IF;
2651: IF (x_lpov_rec.attribute9 = Okc_Api.G_MISS_CHAR)
2652: THEN
2653: x_lpov_rec.attribute9 := l_db_lpov_rec.attribute9;
2654: END IF;
2655: IF (x_lpov_rec.attribute10 = Okc_Api.G_MISS_CHAR)

Line 2655: IF (x_lpov_rec.attribute10 = Okc_Api.G_MISS_CHAR)

2651: IF (x_lpov_rec.attribute9 = Okc_Api.G_MISS_CHAR)
2652: THEN
2653: x_lpov_rec.attribute9 := l_db_lpov_rec.attribute9;
2654: END IF;
2655: IF (x_lpov_rec.attribute10 = Okc_Api.G_MISS_CHAR)
2656: THEN
2657: x_lpov_rec.attribute10 := l_db_lpov_rec.attribute10;
2658: END IF;
2659: IF (x_lpov_rec.attribute11 = Okc_Api.G_MISS_CHAR)

Line 2659: IF (x_lpov_rec.attribute11 = Okc_Api.G_MISS_CHAR)

2655: IF (x_lpov_rec.attribute10 = Okc_Api.G_MISS_CHAR)
2656: THEN
2657: x_lpov_rec.attribute10 := l_db_lpov_rec.attribute10;
2658: END IF;
2659: IF (x_lpov_rec.attribute11 = Okc_Api.G_MISS_CHAR)
2660: THEN
2661: x_lpov_rec.attribute11 := l_db_lpov_rec.attribute11;
2662: END IF;
2663: IF (x_lpov_rec.attribute12 = Okc_Api.G_MISS_CHAR)

Line 2663: IF (x_lpov_rec.attribute12 = Okc_Api.G_MISS_CHAR)

2659: IF (x_lpov_rec.attribute11 = Okc_Api.G_MISS_CHAR)
2660: THEN
2661: x_lpov_rec.attribute11 := l_db_lpov_rec.attribute11;
2662: END IF;
2663: IF (x_lpov_rec.attribute12 = Okc_Api.G_MISS_CHAR)
2664: THEN
2665: x_lpov_rec.attribute12 := l_db_lpov_rec.attribute12;
2666: END IF;
2667: IF (x_lpov_rec.attribute13 = Okc_Api.G_MISS_CHAR)

Line 2667: IF (x_lpov_rec.attribute13 = Okc_Api.G_MISS_CHAR)

2663: IF (x_lpov_rec.attribute12 = Okc_Api.G_MISS_CHAR)
2664: THEN
2665: x_lpov_rec.attribute12 := l_db_lpov_rec.attribute12;
2666: END IF;
2667: IF (x_lpov_rec.attribute13 = Okc_Api.G_MISS_CHAR)
2668: THEN
2669: x_lpov_rec.attribute13 := l_db_lpov_rec.attribute13;
2670: END IF;
2671: IF (x_lpov_rec.attribute14 = Okc_Api.G_MISS_CHAR)

Line 2671: IF (x_lpov_rec.attribute14 = Okc_Api.G_MISS_CHAR)

2667: IF (x_lpov_rec.attribute13 = Okc_Api.G_MISS_CHAR)
2668: THEN
2669: x_lpov_rec.attribute13 := l_db_lpov_rec.attribute13;
2670: END IF;
2671: IF (x_lpov_rec.attribute14 = Okc_Api.G_MISS_CHAR)
2672: THEN
2673: x_lpov_rec.attribute14 := l_db_lpov_rec.attribute14;
2674: END IF;
2675: IF (x_lpov_rec.attribute15 = Okc_Api.G_MISS_CHAR)

Line 2675: IF (x_lpov_rec.attribute15 = Okc_Api.G_MISS_CHAR)

2671: IF (x_lpov_rec.attribute14 = Okc_Api.G_MISS_CHAR)
2672: THEN
2673: x_lpov_rec.attribute14 := l_db_lpov_rec.attribute14;
2674: END IF;
2675: IF (x_lpov_rec.attribute15 = Okc_Api.G_MISS_CHAR)
2676: THEN
2677: x_lpov_rec.attribute15 := l_db_lpov_rec.attribute15;
2678: END IF;
2679: IF (x_lpov_rec.created_by = Okc_Api.G_MISS_NUM)

Line 2679: IF (x_lpov_rec.created_by = Okc_Api.G_MISS_NUM)

2675: IF (x_lpov_rec.attribute15 = Okc_Api.G_MISS_CHAR)
2676: THEN
2677: x_lpov_rec.attribute15 := l_db_lpov_rec.attribute15;
2678: END IF;
2679: IF (x_lpov_rec.created_by = Okc_Api.G_MISS_NUM)
2680: THEN
2681: x_lpov_rec.created_by := l_db_lpov_rec.created_by;
2682: END IF;
2683: IF (x_lpov_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 2683: IF (x_lpov_rec.creation_date = Okc_Api.G_MISS_DATE)

2679: IF (x_lpov_rec.created_by = Okc_Api.G_MISS_NUM)
2680: THEN
2681: x_lpov_rec.created_by := l_db_lpov_rec.created_by;
2682: END IF;
2683: IF (x_lpov_rec.creation_date = Okc_Api.G_MISS_DATE)
2684: THEN
2685: x_lpov_rec.creation_date := l_db_lpov_rec.creation_date;
2686: END IF;
2687: IF (x_lpov_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 2687: IF (x_lpov_rec.last_updated_by = Okc_Api.G_MISS_NUM)

2683: IF (x_lpov_rec.creation_date = Okc_Api.G_MISS_DATE)
2684: THEN
2685: x_lpov_rec.creation_date := l_db_lpov_rec.creation_date;
2686: END IF;
2687: IF (x_lpov_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2688: THEN
2689: x_lpov_rec.last_updated_by := l_db_lpov_rec.last_updated_by;
2690: END IF;
2691: IF (x_lpov_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 2691: IF (x_lpov_rec.last_update_date = Okc_Api.G_MISS_DATE)

2687: IF (x_lpov_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2688: THEN
2689: x_lpov_rec.last_updated_by := l_db_lpov_rec.last_updated_by;
2690: END IF;
2691: IF (x_lpov_rec.last_update_date = Okc_Api.G_MISS_DATE)
2692: THEN
2693: x_lpov_rec.last_update_date := l_db_lpov_rec.last_update_date;
2694: END IF;
2695: IF (x_lpov_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 2695: IF (x_lpov_rec.last_update_login = Okc_Api.G_MISS_NUM)

2691: IF (x_lpov_rec.last_update_date = Okc_Api.G_MISS_DATE)
2692: THEN
2693: x_lpov_rec.last_update_date := l_db_lpov_rec.last_update_date;
2694: END IF;
2695: IF (x_lpov_rec.last_update_login = Okc_Api.G_MISS_NUM)
2696: THEN
2697: x_lpov_rec.last_update_login := l_db_lpov_rec.last_update_login;
2698: END IF;
2699: IF (x_lpov_rec.days_in_year = Okc_Api.G_MISS_CHAR)

Line 2699: IF (x_lpov_rec.days_in_year = Okc_Api.G_MISS_CHAR)

2695: IF (x_lpov_rec.last_update_login = Okc_Api.G_MISS_NUM)
2696: THEN
2697: x_lpov_rec.last_update_login := l_db_lpov_rec.last_update_login;
2698: END IF;
2699: IF (x_lpov_rec.days_in_year = Okc_Api.G_MISS_CHAR)
2700: THEN
2701: x_lpov_rec.days_in_year := l_db_lpov_rec.days_in_year;
2702: END IF;
2703: END IF;

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

2709: FUNCTION Set_Attributes (
2710: p_lpov_rec IN lpov_rec_type,
2711: x_lpov_rec OUT NOCOPY lpov_rec_type
2712: ) RETURN VARCHAR2 IS
2713: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2714: BEGIN
2715: x_lpov_rec := p_lpov_rec;
2716: RETURN(l_return_status);
2717: END Set_Attributes;

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

2715: x_lpov_rec := p_lpov_rec;
2716: RETURN(l_return_status);
2717: END Set_Attributes;
2718: BEGIN
2719: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2720: G_PKG_NAME,
2721: p_init_msg_list,
2722: l_api_version,
2723: p_api_version,

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

2722: l_api_version,
2723: p_api_version,
2724: '_PVT',
2725: x_return_status);
2726: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2727: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2728: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2729: RAISE Okc_Api.G_EXCEPTION_ERROR;
2730: END IF;

Line 2727: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2723: p_api_version,
2724: '_PVT',
2725: x_return_status);
2726: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2727: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2728: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2729: RAISE Okc_Api.G_EXCEPTION_ERROR;
2730: END IF;
2731: --- Setting item attributes

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

2724: '_PVT',
2725: x_return_status);
2726: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2727: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2728: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2729: RAISE Okc_Api.G_EXCEPTION_ERROR;
2730: END IF;
2731: --- Setting item attributes
2732: l_return_status := Set_Attributes(

Line 2729: RAISE Okc_Api.G_EXCEPTION_ERROR;

2725: x_return_status);
2726: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2727: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2728: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2729: RAISE Okc_Api.G_EXCEPTION_ERROR;
2730: END IF;
2731: --- Setting item attributes
2732: l_return_status := Set_Attributes(
2733: p_lpov_rec, -- IN

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

2732: l_return_status := Set_Attributes(
2733: p_lpov_rec, -- IN
2734: x_lpov_rec); -- OUT
2735: --- If any errors happen abort API
2736: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2737: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2738: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2739: RAISE Okc_Api.G_EXCEPTION_ERROR;
2740: END IF;

Line 2737: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2733: p_lpov_rec, -- IN
2734: x_lpov_rec); -- OUT
2735: --- If any errors happen abort API
2736: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2737: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2738: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2739: RAISE Okc_Api.G_EXCEPTION_ERROR;
2740: END IF;
2741: l_return_status := populate_new_record(l_lpov_rec, l_def_lpov_rec);

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

2734: x_lpov_rec); -- OUT
2735: --- If any errors happen abort API
2736: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2737: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2738: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2739: RAISE Okc_Api.G_EXCEPTION_ERROR;
2740: END IF;
2741: l_return_status := populate_new_record(l_lpov_rec, l_def_lpov_rec);
2742: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2739: RAISE Okc_Api.G_EXCEPTION_ERROR;

2735: --- If any errors happen abort API
2736: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2737: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2738: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2739: RAISE Okc_Api.G_EXCEPTION_ERROR;
2740: END IF;
2741: l_return_status := populate_new_record(l_lpov_rec, l_def_lpov_rec);
2742: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2743: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

2738: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2739: RAISE Okc_Api.G_EXCEPTION_ERROR;
2740: END IF;
2741: l_return_status := populate_new_record(l_lpov_rec, l_def_lpov_rec);
2742: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2743: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2744: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2745: RAISE Okc_Api.G_EXCEPTION_ERROR;
2746: END IF;

Line 2743: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2739: RAISE Okc_Api.G_EXCEPTION_ERROR;
2740: END IF;
2741: l_return_status := populate_new_record(l_lpov_rec, l_def_lpov_rec);
2742: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2743: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2744: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2745: RAISE Okc_Api.G_EXCEPTION_ERROR;
2746: END IF;
2747: l_def_lpov_rec := fill_who_columns(l_def_lpov_rec);

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

2740: END IF;
2741: l_return_status := populate_new_record(l_lpov_rec, l_def_lpov_rec);
2742: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2743: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2744: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2745: RAISE Okc_Api.G_EXCEPTION_ERROR;
2746: END IF;
2747: l_def_lpov_rec := fill_who_columns(l_def_lpov_rec);
2748: --- Validate all non-missing attributes (Item Level Validation)

Line 2745: RAISE Okc_Api.G_EXCEPTION_ERROR;

2741: l_return_status := populate_new_record(l_lpov_rec, l_def_lpov_rec);
2742: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2743: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2744: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2745: RAISE Okc_Api.G_EXCEPTION_ERROR;
2746: END IF;
2747: l_def_lpov_rec := fill_who_columns(l_def_lpov_rec);
2748: --- Validate all non-missing attributes (Item Level Validation)
2749: l_return_status := Validate_Attributes(l_def_lpov_rec);

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

2747: l_def_lpov_rec := fill_who_columns(l_def_lpov_rec);
2748: --- Validate all non-missing attributes (Item Level Validation)
2749: l_return_status := Validate_Attributes(l_def_lpov_rec);
2750: --- If any errors happen abort API
2751: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2752: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2753: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2754: RAISE Okc_Api.G_EXCEPTION_ERROR;
2755: END IF;

Line 2752: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2748: --- Validate all non-missing attributes (Item Level Validation)
2749: l_return_status := Validate_Attributes(l_def_lpov_rec);
2750: --- If any errors happen abort API
2751: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2752: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2753: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2754: RAISE Okc_Api.G_EXCEPTION_ERROR;
2755: END IF;
2756: l_return_status := Validate_Record(l_def_lpov_rec);

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

2749: l_return_status := Validate_Attributes(l_def_lpov_rec);
2750: --- If any errors happen abort API
2751: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2752: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2753: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2754: RAISE Okc_Api.G_EXCEPTION_ERROR;
2755: END IF;
2756: l_return_status := Validate_Record(l_def_lpov_rec);
2757: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2754: RAISE Okc_Api.G_EXCEPTION_ERROR;

2750: --- If any errors happen abort API
2751: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2752: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2753: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2754: RAISE Okc_Api.G_EXCEPTION_ERROR;
2755: END IF;
2756: l_return_status := Validate_Record(l_def_lpov_rec);
2757: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2758: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

2753: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2754: RAISE Okc_Api.G_EXCEPTION_ERROR;
2755: END IF;
2756: l_return_status := Validate_Record(l_def_lpov_rec);
2757: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2758: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2759: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2760: RAISE Okc_Api.G_EXCEPTION_ERROR;
2761: END IF;

Line 2758: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2754: RAISE Okc_Api.G_EXCEPTION_ERROR;
2755: END IF;
2756: l_return_status := Validate_Record(l_def_lpov_rec);
2757: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2758: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2759: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2760: RAISE Okc_Api.G_EXCEPTION_ERROR;
2761: END IF;
2762:

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

2755: END IF;
2756: l_return_status := Validate_Record(l_def_lpov_rec);
2757: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2758: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2759: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2760: RAISE Okc_Api.G_EXCEPTION_ERROR;
2761: END IF;
2762:
2763: -----------------------------------------

Line 2760: RAISE Okc_Api.G_EXCEPTION_ERROR;

2756: l_return_status := Validate_Record(l_def_lpov_rec);
2757: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2758: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2759: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2760: RAISE Okc_Api.G_EXCEPTION_ERROR;
2761: END IF;
2762:
2763: -----------------------------------------
2764: -- Move VIEW record to "Child" records --

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

2775: x_msg_data,
2776: l_lpo_rec,
2777: lx_lpo_rec
2778: );
2779: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2780: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2781: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2782: RAISE Okc_Api.G_EXCEPTION_ERROR;
2783: END IF;

Line 2780: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2776: l_lpo_rec,
2777: lx_lpo_rec
2778: );
2779: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2780: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2781: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2782: RAISE Okc_Api.G_EXCEPTION_ERROR;
2783: END IF;
2784: migrate(lx_lpo_rec, l_def_lpov_rec);

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

2777: lx_lpo_rec
2778: );
2779: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2780: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2781: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2782: RAISE Okc_Api.G_EXCEPTION_ERROR;
2783: END IF;
2784: migrate(lx_lpo_rec, l_def_lpov_rec);
2785: update_row(

Line 2782: RAISE Okc_Api.G_EXCEPTION_ERROR;

2778: );
2779: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2780: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2781: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2782: RAISE Okc_Api.G_EXCEPTION_ERROR;
2783: END IF;
2784: migrate(lx_lpo_rec, l_def_lpov_rec);
2785: update_row(
2786: p_init_msg_list,

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

2789: x_msg_data,
2790: l_okl_late_policies_tl_rec,
2791: lx_okl_late_policies_tl_rec
2792: );
2793: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2794: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2795: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2796: RAISE Okc_Api.G_EXCEPTION_ERROR;
2797: END IF;

Line 2794: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2790: l_okl_late_policies_tl_rec,
2791: lx_okl_late_policies_tl_rec
2792: );
2793: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2794: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2795: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2796: RAISE Okc_Api.G_EXCEPTION_ERROR;
2797: END IF;
2798: migrate(lx_okl_late_policies_tl_rec, l_def_lpov_rec);

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

2791: lx_okl_late_policies_tl_rec
2792: );
2793: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2794: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2795: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2796: RAISE Okc_Api.G_EXCEPTION_ERROR;
2797: END IF;
2798: migrate(lx_okl_late_policies_tl_rec, l_def_lpov_rec);
2799: x_lpov_rec := l_def_lpov_rec;

Line 2796: RAISE Okc_Api.G_EXCEPTION_ERROR;

2792: );
2793: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2794: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2795: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2796: RAISE Okc_Api.G_EXCEPTION_ERROR;
2797: END IF;
2798: migrate(lx_okl_late_policies_tl_rec, l_def_lpov_rec);
2799: x_lpov_rec := l_def_lpov_rec;
2800: x_return_status := l_return_status;

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

2797: END IF;
2798: migrate(lx_okl_late_policies_tl_rec, l_def_lpov_rec);
2799: x_lpov_rec := l_def_lpov_rec;
2800: x_return_status := l_return_status;
2801: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2802: EXCEPTION
2803: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2804: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2805: (

Line 2803: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2799: x_lpov_rec := l_def_lpov_rec;
2800: x_return_status := l_return_status;
2801: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2802: EXCEPTION
2803: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2804: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2805: (
2806: l_api_name,
2807: G_PKG_NAME,

Line 2804: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2800: x_return_status := l_return_status;
2801: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2802: EXCEPTION
2803: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2804: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2805: (
2806: l_api_name,
2807: G_PKG_NAME,
2808: 'OKC_API.G_RET_STS_ERROR',

Line 2808: 'OKC_API.G_RET_STS_ERROR',

2804: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2805: (
2806: l_api_name,
2807: G_PKG_NAME,
2808: 'OKC_API.G_RET_STS_ERROR',
2809: x_msg_count,
2810: x_msg_data,
2811: '_PVT'
2812: );

Line 2813: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2814: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2810: x_msg_data,
2811: '_PVT'
2812: );
2813: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2814: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2815: (
2816: l_api_name,
2817: G_PKG_NAME,
2818: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2818: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2814: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2815: (
2816: l_api_name,
2817: G_PKG_NAME,
2818: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2819: x_msg_count,
2820: x_msg_data,
2821: '_PVT'
2822: );

Line 2824: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 2840: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2836: -- PL/SQL TBL update_row for:LPOV_TBL --
2837: ----------------------------------------
2838: PROCEDURE update_row(
2839: p_api_version IN NUMBER,
2840: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2841: x_return_status OUT NOCOPY VARCHAR2,
2842: x_msg_count OUT NOCOPY NUMBER,
2843: x_msg_data OUT NOCOPY VARCHAR2,
2844: p_lpov_tbl IN lpov_tbl_type,

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

2845: x_lpov_tbl OUT NOCOPY lpov_tbl_type) IS
2846:
2847: l_api_version CONSTANT NUMBER := 1;
2848: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2849: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2850: i NUMBER := 0;
2851: BEGIN
2852: Okc_Api.init_msg_list(p_init_msg_list);
2853: -- Make sure PL/SQL table has records in it before passing

Line 2852: Okc_Api.init_msg_list(p_init_msg_list);

2848: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2849: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2850: i NUMBER := 0;
2851: BEGIN
2852: Okc_Api.init_msg_list(p_init_msg_list);
2853: -- Make sure PL/SQL table has records in it before passing
2854: IF (p_lpov_tbl.COUNT > 0) THEN
2855: i := p_lpov_tbl.FIRST;
2856: LOOP

Line 2859: p_init_msg_list => Okc_Api.G_FALSE,

2855: i := p_lpov_tbl.FIRST;
2856: LOOP
2857: update_row (
2858: p_api_version => p_api_version,
2859: p_init_msg_list => Okc_Api.G_FALSE,
2860: x_return_status => x_return_status,
2861: x_msg_count => x_msg_count,
2862: x_msg_data => x_msg_data,
2863: p_lpov_rec => p_lpov_tbl(i),

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

2865: EXIT WHEN (i = p_lpov_tbl.LAST);
2866: i := p_lpov_tbl.NEXT(i);
2867: END LOOP;
2868: END IF;
2869: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2870: EXCEPTION
2871: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2872: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2873: (

Line 2871: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2867: END LOOP;
2868: END IF;
2869: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2870: EXCEPTION
2871: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2872: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2873: (
2874: l_api_name,
2875: G_PKG_NAME,

Line 2872: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2868: END IF;
2869: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2870: EXCEPTION
2871: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2872: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2873: (
2874: l_api_name,
2875: G_PKG_NAME,
2876: 'OKC_API.G_RET_STS_ERROR',

Line 2876: 'OKC_API.G_RET_STS_ERROR',

2872: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2873: (
2874: l_api_name,
2875: G_PKG_NAME,
2876: 'OKC_API.G_RET_STS_ERROR',
2877: x_msg_count,
2878: x_msg_data,
2879: '_PVT'
2880: );

Line 2881: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2877: x_msg_count,
2878: x_msg_data,
2879: '_PVT'
2880: );
2881: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2882: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2883: (
2884: l_api_name,
2885: G_PKG_NAME,

Line 2882: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2878: x_msg_data,
2879: '_PVT'
2880: );
2881: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2882: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2883: (
2884: l_api_name,
2885: G_PKG_NAME,
2886: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2886: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 2892: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 2910: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2906: ----------------------------------------
2907: -- delete_row for:OKL_LATE_POLICIES_B --
2908: ----------------------------------------
2909: PROCEDURE delete_row(
2910: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2911: x_return_status OUT NOCOPY VARCHAR2,
2912: x_msg_count OUT NOCOPY NUMBER,
2913: x_msg_data OUT NOCOPY VARCHAR2,
2914: p_lpo_rec IN lpo_rec_type) IS

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

2914: p_lpo_rec IN lpo_rec_type) IS
2915:
2916: l_api_version CONSTANT NUMBER := 1;
2917: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2918: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2919: l_lpo_rec lpo_rec_type := p_lpo_rec;
2920: l_row_notfound BOOLEAN := TRUE;
2921: BEGIN
2922: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

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

2918: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2919: l_lpo_rec lpo_rec_type := p_lpo_rec;
2920: l_row_notfound BOOLEAN := TRUE;
2921: BEGIN
2922: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2923: p_init_msg_list,
2924: '_PVT',
2925: x_return_status);
2926: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

2922: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2923: p_init_msg_list,
2924: '_PVT',
2925: x_return_status);
2926: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2927: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2928: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2929: RAISE Okc_Api.G_EXCEPTION_ERROR;
2930: END IF;

Line 2927: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2923: p_init_msg_list,
2924: '_PVT',
2925: x_return_status);
2926: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2927: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2928: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2929: RAISE Okc_Api.G_EXCEPTION_ERROR;
2930: END IF;
2931:

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

2924: '_PVT',
2925: x_return_status);
2926: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2927: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2928: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2929: RAISE Okc_Api.G_EXCEPTION_ERROR;
2930: END IF;
2931:
2932: DELETE FROM OKL_LATE_POLICIES_B

Line 2929: RAISE Okc_Api.G_EXCEPTION_ERROR;

2925: x_return_status);
2926: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2927: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2928: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2929: RAISE Okc_Api.G_EXCEPTION_ERROR;
2930: END IF;
2931:
2932: DELETE FROM OKL_LATE_POLICIES_B
2933: WHERE ID = p_lpo_rec.id;

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

2932: DELETE FROM OKL_LATE_POLICIES_B
2933: WHERE ID = p_lpo_rec.id;
2934:
2935: x_return_status := l_return_status;
2936: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2937: EXCEPTION
2938: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2939: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2940: (

Line 2938: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2934:
2935: x_return_status := l_return_status;
2936: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2937: EXCEPTION
2938: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2939: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2940: (
2941: l_api_name,
2942: G_PKG_NAME,

Line 2939: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2935: x_return_status := l_return_status;
2936: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2937: EXCEPTION
2938: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2939: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2940: (
2941: l_api_name,
2942: G_PKG_NAME,
2943: 'OKC_API.G_RET_STS_ERROR',

Line 2943: 'OKC_API.G_RET_STS_ERROR',

2939: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2940: (
2941: l_api_name,
2942: G_PKG_NAME,
2943: 'OKC_API.G_RET_STS_ERROR',
2944: x_msg_count,
2945: x_msg_data,
2946: '_PVT'
2947: );

Line 2948: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2944: x_msg_count,
2945: x_msg_data,
2946: '_PVT'
2947: );
2948: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2949: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2950: (
2951: l_api_name,
2952: G_PKG_NAME,

Line 2949: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2945: x_msg_data,
2946: '_PVT'
2947: );
2948: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2949: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2950: (
2951: l_api_name,
2952: G_PKG_NAME,
2953: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2953: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 2959: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 2973: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2969: -----------------------------------------
2970: -- delete_row for:OKL_LATE_POLICIES_TL --
2971: -----------------------------------------
2972: PROCEDURE delete_row(
2973: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2974: x_return_status OUT NOCOPY VARCHAR2,
2975: x_msg_count OUT NOCOPY NUMBER,
2976: x_msg_data OUT NOCOPY VARCHAR2,
2977: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type) IS

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

2977: p_okl_late_policies_tl_rec IN okl_late_policies_tl_rec_type) IS
2978:
2979: l_api_version CONSTANT NUMBER := 1;
2980: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2981: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2982: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type := p_okl_late_policies_tl_rec;
2983: l_row_notfound BOOLEAN := TRUE;
2984: BEGIN
2985: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

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

2981: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2982: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type := p_okl_late_policies_tl_rec;
2983: l_row_notfound BOOLEAN := TRUE;
2984: BEGIN
2985: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2986: p_init_msg_list,
2987: '_PVT',
2988: x_return_status);
2989: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

2985: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2986: p_init_msg_list,
2987: '_PVT',
2988: x_return_status);
2989: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2990: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2991: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2992: RAISE Okc_Api.G_EXCEPTION_ERROR;
2993: END IF;

Line 2990: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2986: p_init_msg_list,
2987: '_PVT',
2988: x_return_status);
2989: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2990: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2991: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2992: RAISE Okc_Api.G_EXCEPTION_ERROR;
2993: END IF;
2994:

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

2987: '_PVT',
2988: x_return_status);
2989: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2990: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2991: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2992: RAISE Okc_Api.G_EXCEPTION_ERROR;
2993: END IF;
2994:
2995: DELETE FROM OKL_LATE_POLICIES_TL

Line 2992: RAISE Okc_Api.G_EXCEPTION_ERROR;

2988: x_return_status);
2989: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2990: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2991: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2992: RAISE Okc_Api.G_EXCEPTION_ERROR;
2993: END IF;
2994:
2995: DELETE FROM OKL_LATE_POLICIES_TL
2996: WHERE ID = p_okl_late_policies_tl_rec.id;

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

2995: DELETE FROM OKL_LATE_POLICIES_TL
2996: WHERE ID = p_okl_late_policies_tl_rec.id;
2997:
2998: x_return_status := l_return_status;
2999: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3000: EXCEPTION
3001: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3002: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3003: (

Line 3001: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2997:
2998: x_return_status := l_return_status;
2999: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3000: EXCEPTION
3001: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3002: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3003: (
3004: l_api_name,
3005: G_PKG_NAME,

Line 3002: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2998: x_return_status := l_return_status;
2999: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3000: EXCEPTION
3001: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3002: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3003: (
3004: l_api_name,
3005: G_PKG_NAME,
3006: 'OKC_API.G_RET_STS_ERROR',

Line 3006: 'OKC_API.G_RET_STS_ERROR',

3002: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3003: (
3004: l_api_name,
3005: G_PKG_NAME,
3006: 'OKC_API.G_RET_STS_ERROR',
3007: x_msg_count,
3008: x_msg_data,
3009: '_PVT'
3010: );

Line 3011: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3007: x_msg_count,
3008: x_msg_data,
3009: '_PVT'
3010: );
3011: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3012: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3013: (
3014: l_api_name,
3015: G_PKG_NAME,

Line 3012: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3008: x_msg_data,
3009: '_PVT'
3010: );
3011: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3012: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3013: (
3014: l_api_name,
3015: G_PKG_NAME,
3016: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3016: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3012: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3013: (
3014: l_api_name,
3015: G_PKG_NAME,
3016: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3017: x_msg_count,
3018: x_msg_data,
3019: '_PVT'
3020: );

Line 3022: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3018: x_msg_data,
3019: '_PVT'
3020: );
3021: WHEN OTHERS THEN
3022: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3023: (
3024: l_api_name,
3025: G_PKG_NAME,
3026: 'OTHERS',

Line 3037: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

3033: -- delete_row for:OKL_LATE_POLICIES_V --
3034: ----------------------------------------
3035: PROCEDURE delete_row(
3036: p_api_version IN NUMBER,
3037: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3038: x_return_status OUT NOCOPY VARCHAR2,
3039: x_msg_count OUT NOCOPY NUMBER,
3040: x_msg_data OUT NOCOPY VARCHAR2,
3041: p_lpov_rec IN lpov_rec_type) IS

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

3041: p_lpov_rec IN lpov_rec_type) IS
3042:
3043: l_api_version CONSTANT NUMBER := 1;
3044: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3045: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3046: l_lpov_rec lpov_rec_type := p_lpov_rec;
3047: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
3048: l_lpo_rec lpo_rec_type;
3049: BEGIN

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

3046: l_lpov_rec lpov_rec_type := p_lpov_rec;
3047: l_okl_late_policies_tl_rec okl_late_policies_tl_rec_type;
3048: l_lpo_rec lpo_rec_type;
3049: BEGIN
3050: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
3051: G_PKG_NAME,
3052: p_init_msg_list,
3053: l_api_version,
3054: p_api_version,

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

3053: l_api_version,
3054: p_api_version,
3055: '_PVT',
3056: x_return_status);
3057: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3058: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3059: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3060: RAISE Okc_Api.G_EXCEPTION_ERROR;
3061: END IF;

Line 3058: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3054: p_api_version,
3055: '_PVT',
3056: x_return_status);
3057: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3058: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3059: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3060: RAISE Okc_Api.G_EXCEPTION_ERROR;
3061: END IF;
3062: -----------------------------------------

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

3055: '_PVT',
3056: x_return_status);
3057: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3058: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3059: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3060: RAISE Okc_Api.G_EXCEPTION_ERROR;
3061: END IF;
3062: -----------------------------------------
3063: -- Move VIEW record to "Child" records --

Line 3060: RAISE Okc_Api.G_EXCEPTION_ERROR;

3056: x_return_status);
3057: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3058: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3059: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3060: RAISE Okc_Api.G_EXCEPTION_ERROR;
3061: END IF;
3062: -----------------------------------------
3063: -- Move VIEW record to "Child" records --
3064: -----------------------------------------

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

3073: x_msg_count,
3074: x_msg_data,
3075: l_okl_late_policies_tl_rec
3076: );
3077: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3078: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3079: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3080: RAISE Okc_Api.G_EXCEPTION_ERROR;
3081: END IF;

Line 3078: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3074: x_msg_data,
3075: l_okl_late_policies_tl_rec
3076: );
3077: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3078: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3079: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3080: RAISE Okc_Api.G_EXCEPTION_ERROR;
3081: END IF;
3082: delete_row(

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

3075: l_okl_late_policies_tl_rec
3076: );
3077: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3078: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3079: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3080: RAISE Okc_Api.G_EXCEPTION_ERROR;
3081: END IF;
3082: delete_row(
3083: p_init_msg_list,

Line 3080: RAISE Okc_Api.G_EXCEPTION_ERROR;

3076: );
3077: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3078: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3079: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3080: RAISE Okc_Api.G_EXCEPTION_ERROR;
3081: END IF;
3082: delete_row(
3083: p_init_msg_list,
3084: l_return_status,

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

3085: x_msg_count,
3086: x_msg_data,
3087: l_lpo_rec
3088: );
3089: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3090: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3091: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3092: RAISE Okc_Api.G_EXCEPTION_ERROR;
3093: END IF;

Line 3090: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3086: x_msg_data,
3087: l_lpo_rec
3088: );
3089: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3090: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3091: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3092: RAISE Okc_Api.G_EXCEPTION_ERROR;
3093: END IF;
3094: x_return_status := l_return_status;

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

3087: l_lpo_rec
3088: );
3089: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3090: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3091: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3092: RAISE Okc_Api.G_EXCEPTION_ERROR;
3093: END IF;
3094: x_return_status := l_return_status;
3095: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 3092: RAISE Okc_Api.G_EXCEPTION_ERROR;

3088: );
3089: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3090: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3091: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3092: RAISE Okc_Api.G_EXCEPTION_ERROR;
3093: END IF;
3094: x_return_status := l_return_status;
3095: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3096: EXCEPTION

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

3091: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3092: RAISE Okc_Api.G_EXCEPTION_ERROR;
3093: END IF;
3094: x_return_status := l_return_status;
3095: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3096: EXCEPTION
3097: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3098: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3099: (

Line 3097: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

3093: END IF;
3094: x_return_status := l_return_status;
3095: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3096: EXCEPTION
3097: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3098: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3099: (
3100: l_api_name,
3101: G_PKG_NAME,

Line 3098: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3094: x_return_status := l_return_status;
3095: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3096: EXCEPTION
3097: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3098: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3099: (
3100: l_api_name,
3101: G_PKG_NAME,
3102: 'OKC_API.G_RET_STS_ERROR',

Line 3102: 'OKC_API.G_RET_STS_ERROR',

3098: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3099: (
3100: l_api_name,
3101: G_PKG_NAME,
3102: 'OKC_API.G_RET_STS_ERROR',
3103: x_msg_count,
3104: x_msg_data,
3105: '_PVT'
3106: );

Line 3107: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3103: x_msg_count,
3104: x_msg_data,
3105: '_PVT'
3106: );
3107: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3108: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3109: (
3110: l_api_name,
3111: G_PKG_NAME,

Line 3108: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3104: x_msg_data,
3105: '_PVT'
3106: );
3107: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3108: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3109: (
3110: l_api_name,
3111: G_PKG_NAME,
3112: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3112: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3108: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3109: (
3110: l_api_name,
3111: G_PKG_NAME,
3112: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3113: x_msg_count,
3114: x_msg_data,
3115: '_PVT'
3116: );

Line 3118: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3114: x_msg_data,
3115: '_PVT'
3116: );
3117: WHEN OTHERS THEN
3118: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3119: (
3120: l_api_name,
3121: G_PKG_NAME,
3122: 'OTHERS',

Line 3133: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

3129: -- PL/SQL TBL delete_row for:OKL_LATE_POLICIES_V --
3130: ---------------------------------------------------
3131: PROCEDURE delete_row(
3132: p_api_version IN NUMBER,
3133: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
3134: x_return_status OUT NOCOPY VARCHAR2,
3135: x_msg_count OUT NOCOPY NUMBER,
3136: x_msg_data OUT NOCOPY VARCHAR2,
3137: p_lpov_tbl IN lpov_tbl_type) IS

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

3137: p_lpov_tbl IN lpov_tbl_type) IS
3138:
3139: l_api_version CONSTANT NUMBER := 1;
3140: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3141: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3142: i NUMBER := 0;
3143: BEGIN
3144: Okc_Api.init_msg_list(p_init_msg_list);
3145: -- Make sure PL/SQL table has records in it before passing

Line 3144: Okc_Api.init_msg_list(p_init_msg_list);

3140: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3141: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3142: i NUMBER := 0;
3143: BEGIN
3144: Okc_Api.init_msg_list(p_init_msg_list);
3145: -- Make sure PL/SQL table has records in it before passing
3146: IF (p_lpov_tbl.COUNT > 0) THEN
3147: i := p_lpov_tbl.FIRST;
3148: LOOP

Line 3151: p_init_msg_list => Okc_Api.G_FALSE,

3147: i := p_lpov_tbl.FIRST;
3148: LOOP
3149: delete_row (
3150: p_api_version => p_api_version,
3151: p_init_msg_list => Okc_Api.G_FALSE,
3152: x_return_status => x_return_status,
3153: x_msg_count => x_msg_count,
3154: x_msg_data => x_msg_data,
3155: p_lpov_rec => p_lpov_tbl(i));

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

3157: EXIT WHEN (i = p_lpov_tbl.LAST);
3158: i := p_lpov_tbl.NEXT(i);
3159: END LOOP;
3160: END IF;
3161: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3162: EXCEPTION
3163: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3164: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3165: (

Line 3163: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

3159: END LOOP;
3160: END IF;
3161: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3162: EXCEPTION
3163: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3164: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3165: (
3166: l_api_name,
3167: G_PKG_NAME,

Line 3164: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3160: END IF;
3161: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3162: EXCEPTION
3163: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3164: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3165: (
3166: l_api_name,
3167: G_PKG_NAME,
3168: 'OKC_API.G_RET_STS_ERROR',

Line 3168: 'OKC_API.G_RET_STS_ERROR',

3164: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3165: (
3166: l_api_name,
3167: G_PKG_NAME,
3168: 'OKC_API.G_RET_STS_ERROR',
3169: x_msg_count,
3170: x_msg_data,
3171: '_PVT'
3172: );

Line 3173: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3169: x_msg_count,
3170: x_msg_data,
3171: '_PVT'
3172: );
3173: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3174: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3175: (
3176: l_api_name,
3177: G_PKG_NAME,

Line 3174: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3170: x_msg_data,
3171: '_PVT'
3172: );
3173: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3174: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3175: (
3176: l_api_name,
3177: G_PKG_NAME,
3178: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3178: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3174: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3175: (
3176: l_api_name,
3177: G_PKG_NAME,
3178: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3179: x_msg_count,
3180: x_msg_data,
3181: '_PVT'
3182: );

Line 3184: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3180: x_msg_data,
3181: '_PVT'
3182: );
3183: WHEN OTHERS THEN
3184: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3185: (
3186: l_api_name,
3187: G_PKG_NAME,
3188: 'OTHERS',