APPS.OKL_CNR_PVT dependencies on OKC_API

Line 155: Okc_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');

151: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
152: IF (p_cnrv_rec.legal_entity_id IS NOT NULL) THEN
153: l_exists := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_cnrv_rec.legal_entity_id);
154: IF(l_exists<>1) THEN
155: Okc_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');
156: RAISE item_not_found_error;
157: END IF;
158: END IF;
159: EXCEPTION

Line 161: x_return_status := Okc_Api.G_RET_STS_ERROR;

157: END IF;
158: END IF;
159: EXCEPTION
160: WHEN item_not_found_error THEN
161: x_return_status := Okc_Api.G_RET_STS_ERROR;
162:
163: WHEN OTHERS THEN
164: -- store SQL error message on message stack for caller
165: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 165: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

161: x_return_status := Okc_Api.G_RET_STS_ERROR;
162:
163: WHEN OTHERS THEN
164: -- store SQL error message on message stack for caller
165: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
166: ,p_msg_name => g_unexpected_error
167: ,p_token1 => g_sqlcode_token
168: ,p_token1_value =>SQLCODE
169: ,p_token2 => g_sqlerrm_token

Line 173: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

169: ,p_token2 => g_sqlerrm_token
170: ,p_token2_value =>SQLERRM);
171:
172: -- notify caller of an UNEXPECTED error
173: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
174: END validate_legal_entity_id;
175:
176: -- for LE Uptake project 08-11-2006
177:

Line 770: IF (l_cnrv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN

766: p_cnrv_rec IN cnrv_rec_type
767: ) RETURN cnrv_rec_type IS
768: l_cnrv_rec cnrv_rec_type := p_cnrv_rec;
769: BEGIN
770: IF (l_cnrv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN
771: l_cnrv_rec.object_version_number := NULL;
772: END IF;
773: IF (l_cnrv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR) THEN
774: l_cnrv_rec.sfwt_flag := NULL;

Line 773: IF (l_cnrv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR) THEN

769: BEGIN
770: IF (l_cnrv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN
771: l_cnrv_rec.object_version_number := NULL;
772: END IF;
773: IF (l_cnrv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR) THEN
774: l_cnrv_rec.sfwt_flag := NULL;
775: END IF;
776: IF (l_cnrv_rec.ibt_id = Okc_Api.G_MISS_NUM) THEN
777: l_cnrv_rec.ibt_id := NULL;

Line 776: IF (l_cnrv_rec.ibt_id = Okc_Api.G_MISS_NUM) THEN

772: END IF;
773: IF (l_cnrv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR) THEN
774: l_cnrv_rec.sfwt_flag := NULL;
775: END IF;
776: IF (l_cnrv_rec.ibt_id = Okc_Api.G_MISS_NUM) THEN
777: l_cnrv_rec.ibt_id := NULL;
778: END IF;
779: IF (l_cnrv_rec.ixx_id = Okc_Api.G_MISS_NUM) THEN
780: l_cnrv_rec.ixx_id := NULL;

Line 779: IF (l_cnrv_rec.ixx_id = Okc_Api.G_MISS_NUM) THEN

775: END IF;
776: IF (l_cnrv_rec.ibt_id = Okc_Api.G_MISS_NUM) THEN
777: l_cnrv_rec.ibt_id := NULL;
778: END IF;
779: IF (l_cnrv_rec.ixx_id = Okc_Api.G_MISS_NUM) THEN
780: l_cnrv_rec.ixx_id := NULL;
781: END IF;
782: IF (l_cnrv_rec.currency_code = Okc_Api.G_MISS_CHAR) THEN
783: l_cnrv_rec.currency_code := NULL;

Line 782: IF (l_cnrv_rec.currency_code = Okc_Api.G_MISS_CHAR) THEN

778: END IF;
779: IF (l_cnrv_rec.ixx_id = Okc_Api.G_MISS_NUM) THEN
780: l_cnrv_rec.ixx_id := NULL;
781: END IF;
782: IF (l_cnrv_rec.currency_code = Okc_Api.G_MISS_CHAR) THEN
783: l_cnrv_rec.currency_code := NULL;
784: END IF;
785: IF (l_cnrv_rec.irm_id = Okc_Api.G_MISS_NUM) THEN
786: l_cnrv_rec.irm_id := NULL;

Line 785: IF (l_cnrv_rec.irm_id = Okc_Api.G_MISS_NUM) THEN

781: END IF;
782: IF (l_cnrv_rec.currency_code = Okc_Api.G_MISS_CHAR) THEN
783: l_cnrv_rec.currency_code := NULL;
784: END IF;
785: IF (l_cnrv_rec.irm_id = Okc_Api.G_MISS_NUM) THEN
786: l_cnrv_rec.irm_id := NULL;
787: END IF;
788: IF (l_cnrv_rec.inf_id = Okc_Api.G_MISS_NUM) THEN
789: l_cnrv_rec.inf_id := NULL;

Line 788: IF (l_cnrv_rec.inf_id = Okc_Api.G_MISS_NUM) THEN

784: END IF;
785: IF (l_cnrv_rec.irm_id = Okc_Api.G_MISS_NUM) THEN
786: l_cnrv_rec.irm_id := NULL;
787: END IF;
788: IF (l_cnrv_rec.inf_id = Okc_Api.G_MISS_NUM) THEN
789: l_cnrv_rec.inf_id := NULL;
790: END IF;
791: IF (l_cnrv_rec.set_of_books_id = Okc_Api.G_MISS_NUM) THEN
792: l_cnrv_rec.set_of_books_id := NULL;

Line 791: IF (l_cnrv_rec.set_of_books_id = Okc_Api.G_MISS_NUM) THEN

787: END IF;
788: IF (l_cnrv_rec.inf_id = Okc_Api.G_MISS_NUM) THEN
789: l_cnrv_rec.inf_id := NULL;
790: END IF;
791: IF (l_cnrv_rec.set_of_books_id = Okc_Api.G_MISS_NUM) THEN
792: l_cnrv_rec.set_of_books_id := NULL;
793: END IF;
794: IF (l_cnrv_rec.consolidated_invoice_number = Okc_Api.G_MISS_CHAR) THEN
795: l_cnrv_rec.consolidated_invoice_number := NULL;

Line 794: IF (l_cnrv_rec.consolidated_invoice_number = Okc_Api.G_MISS_CHAR) THEN

790: END IF;
791: IF (l_cnrv_rec.set_of_books_id = Okc_Api.G_MISS_NUM) THEN
792: l_cnrv_rec.set_of_books_id := NULL;
793: END IF;
794: IF (l_cnrv_rec.consolidated_invoice_number = Okc_Api.G_MISS_CHAR) THEN
795: l_cnrv_rec.consolidated_invoice_number := NULL;
796: END IF;
797: IF (l_cnrv_rec.trx_status_code = Okc_Api.G_MISS_CHAR) THEN
798: l_cnrv_rec.trx_status_code := NULL;

Line 797: IF (l_cnrv_rec.trx_status_code = Okc_Api.G_MISS_CHAR) THEN

793: END IF;
794: IF (l_cnrv_rec.consolidated_invoice_number = Okc_Api.G_MISS_CHAR) THEN
795: l_cnrv_rec.consolidated_invoice_number := NULL;
796: END IF;
797: IF (l_cnrv_rec.trx_status_code = Okc_Api.G_MISS_CHAR) THEN
798: l_cnrv_rec.trx_status_code := NULL;
799: END IF;
800: IF (l_cnrv_rec.invoice_pull_yn = Okc_Api.G_MISS_CHAR) THEN
801: l_cnrv_rec.invoice_pull_yn := NULL;

Line 800: IF (l_cnrv_rec.invoice_pull_yn = Okc_Api.G_MISS_CHAR) THEN

796: END IF;
797: IF (l_cnrv_rec.trx_status_code = Okc_Api.G_MISS_CHAR) THEN
798: l_cnrv_rec.trx_status_code := NULL;
799: END IF;
800: IF (l_cnrv_rec.invoice_pull_yn = Okc_Api.G_MISS_CHAR) THEN
801: l_cnrv_rec.invoice_pull_yn := NULL;
802: END IF;
803: IF (l_cnrv_rec.date_consolidated = Okc_Api.G_MISS_DATE) THEN
804: l_cnrv_rec.date_consolidated := NULL;

Line 803: IF (l_cnrv_rec.date_consolidated = Okc_Api.G_MISS_DATE) THEN

799: END IF;
800: IF (l_cnrv_rec.invoice_pull_yn = Okc_Api.G_MISS_CHAR) THEN
801: l_cnrv_rec.invoice_pull_yn := NULL;
802: END IF;
803: IF (l_cnrv_rec.date_consolidated = Okc_Api.G_MISS_DATE) THEN
804: l_cnrv_rec.date_consolidated := NULL;
805: END IF;
806: IF (l_cnrv_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR) THEN
807: l_cnrv_rec.private_label_logo_url := NULL;

Line 806: IF (l_cnrv_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR) THEN

802: END IF;
803: IF (l_cnrv_rec.date_consolidated = Okc_Api.G_MISS_DATE) THEN
804: l_cnrv_rec.date_consolidated := NULL;
805: END IF;
806: IF (l_cnrv_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR) THEN
807: l_cnrv_rec.private_label_logo_url := NULL;
808: END IF;
809: IF (l_cnrv_rec.amount = Okc_Api.G_MISS_NUM) THEN
810: l_cnrv_rec.amount := NULL;

Line 809: IF (l_cnrv_rec.amount = Okc_Api.G_MISS_NUM) THEN

805: END IF;
806: IF (l_cnrv_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR) THEN
807: l_cnrv_rec.private_label_logo_url := NULL;
808: END IF;
809: IF (l_cnrv_rec.amount = Okc_Api.G_MISS_NUM) THEN
810: l_cnrv_rec.amount := NULL;
811: END IF;
812: IF (l_cnrv_rec.due_date = Okc_Api.G_MISS_DATE) THEN
813: l_cnrv_rec.due_date := NULL;

Line 812: IF (l_cnrv_rec.due_date = Okc_Api.G_MISS_DATE) THEN

808: END IF;
809: IF (l_cnrv_rec.amount = Okc_Api.G_MISS_NUM) THEN
810: l_cnrv_rec.amount := NULL;
811: END IF;
812: IF (l_cnrv_rec.due_date = Okc_Api.G_MISS_DATE) THEN
813: l_cnrv_rec.due_date := NULL;
814: END IF;
815: IF (l_cnrv_rec.attribute_category = Okc_Api.G_MISS_CHAR) THEN
816: l_cnrv_rec.attribute_category := NULL;

Line 815: IF (l_cnrv_rec.attribute_category = Okc_Api.G_MISS_CHAR) THEN

811: END IF;
812: IF (l_cnrv_rec.due_date = Okc_Api.G_MISS_DATE) THEN
813: l_cnrv_rec.due_date := NULL;
814: END IF;
815: IF (l_cnrv_rec.attribute_category = Okc_Api.G_MISS_CHAR) THEN
816: l_cnrv_rec.attribute_category := NULL;
817: END IF;
818: IF (l_cnrv_rec.attribute1 = Okc_Api.G_MISS_CHAR) THEN
819: l_cnrv_rec.attribute1 := NULL;

Line 818: IF (l_cnrv_rec.attribute1 = Okc_Api.G_MISS_CHAR) THEN

814: END IF;
815: IF (l_cnrv_rec.attribute_category = Okc_Api.G_MISS_CHAR) THEN
816: l_cnrv_rec.attribute_category := NULL;
817: END IF;
818: IF (l_cnrv_rec.attribute1 = Okc_Api.G_MISS_CHAR) THEN
819: l_cnrv_rec.attribute1 := NULL;
820: END IF;
821: IF (l_cnrv_rec.attribute2 = Okc_Api.G_MISS_CHAR) THEN
822: l_cnrv_rec.attribute2 := NULL;

Line 821: IF (l_cnrv_rec.attribute2 = Okc_Api.G_MISS_CHAR) THEN

817: END IF;
818: IF (l_cnrv_rec.attribute1 = Okc_Api.G_MISS_CHAR) THEN
819: l_cnrv_rec.attribute1 := NULL;
820: END IF;
821: IF (l_cnrv_rec.attribute2 = Okc_Api.G_MISS_CHAR) THEN
822: l_cnrv_rec.attribute2 := NULL;
823: END IF;
824: IF (l_cnrv_rec.attribute3 = Okc_Api.G_MISS_CHAR) THEN
825: l_cnrv_rec.attribute3 := NULL;

Line 824: IF (l_cnrv_rec.attribute3 = Okc_Api.G_MISS_CHAR) THEN

820: END IF;
821: IF (l_cnrv_rec.attribute2 = Okc_Api.G_MISS_CHAR) THEN
822: l_cnrv_rec.attribute2 := NULL;
823: END IF;
824: IF (l_cnrv_rec.attribute3 = Okc_Api.G_MISS_CHAR) THEN
825: l_cnrv_rec.attribute3 := NULL;
826: END IF;
827: IF (l_cnrv_rec.attribute4 = Okc_Api.G_MISS_CHAR) THEN
828: l_cnrv_rec.attribute4 := NULL;

Line 827: IF (l_cnrv_rec.attribute4 = Okc_Api.G_MISS_CHAR) THEN

823: END IF;
824: IF (l_cnrv_rec.attribute3 = Okc_Api.G_MISS_CHAR) THEN
825: l_cnrv_rec.attribute3 := NULL;
826: END IF;
827: IF (l_cnrv_rec.attribute4 = Okc_Api.G_MISS_CHAR) THEN
828: l_cnrv_rec.attribute4 := NULL;
829: END IF;
830: IF (l_cnrv_rec.attribute5 = Okc_Api.G_MISS_CHAR) THEN
831: l_cnrv_rec.attribute5 := NULL;

Line 830: IF (l_cnrv_rec.attribute5 = Okc_Api.G_MISS_CHAR) THEN

826: END IF;
827: IF (l_cnrv_rec.attribute4 = Okc_Api.G_MISS_CHAR) THEN
828: l_cnrv_rec.attribute4 := NULL;
829: END IF;
830: IF (l_cnrv_rec.attribute5 = Okc_Api.G_MISS_CHAR) THEN
831: l_cnrv_rec.attribute5 := NULL;
832: END IF;
833: IF (l_cnrv_rec.attribute6 = Okc_Api.G_MISS_CHAR) THEN
834: l_cnrv_rec.attribute6 := NULL;

Line 833: IF (l_cnrv_rec.attribute6 = Okc_Api.G_MISS_CHAR) THEN

829: END IF;
830: IF (l_cnrv_rec.attribute5 = Okc_Api.G_MISS_CHAR) THEN
831: l_cnrv_rec.attribute5 := NULL;
832: END IF;
833: IF (l_cnrv_rec.attribute6 = Okc_Api.G_MISS_CHAR) THEN
834: l_cnrv_rec.attribute6 := NULL;
835: END IF;
836: IF (l_cnrv_rec.attribute7 = Okc_Api.G_MISS_CHAR) THEN
837: l_cnrv_rec.attribute7 := NULL;

Line 836: IF (l_cnrv_rec.attribute7 = Okc_Api.G_MISS_CHAR) THEN

832: END IF;
833: IF (l_cnrv_rec.attribute6 = Okc_Api.G_MISS_CHAR) THEN
834: l_cnrv_rec.attribute6 := NULL;
835: END IF;
836: IF (l_cnrv_rec.attribute7 = Okc_Api.G_MISS_CHAR) THEN
837: l_cnrv_rec.attribute7 := NULL;
838: END IF;
839: IF (l_cnrv_rec.attribute8 = Okc_Api.G_MISS_CHAR) THEN
840: l_cnrv_rec.attribute8 := NULL;

Line 839: IF (l_cnrv_rec.attribute8 = Okc_Api.G_MISS_CHAR) THEN

835: END IF;
836: IF (l_cnrv_rec.attribute7 = Okc_Api.G_MISS_CHAR) THEN
837: l_cnrv_rec.attribute7 := NULL;
838: END IF;
839: IF (l_cnrv_rec.attribute8 = Okc_Api.G_MISS_CHAR) THEN
840: l_cnrv_rec.attribute8 := NULL;
841: END IF;
842: IF (l_cnrv_rec.attribute9 = Okc_Api.G_MISS_CHAR) THEN
843: l_cnrv_rec.attribute9 := NULL;

Line 842: IF (l_cnrv_rec.attribute9 = Okc_Api.G_MISS_CHAR) THEN

838: END IF;
839: IF (l_cnrv_rec.attribute8 = Okc_Api.G_MISS_CHAR) THEN
840: l_cnrv_rec.attribute8 := NULL;
841: END IF;
842: IF (l_cnrv_rec.attribute9 = Okc_Api.G_MISS_CHAR) THEN
843: l_cnrv_rec.attribute9 := NULL;
844: END IF;
845: IF (l_cnrv_rec.attribute10 = Okc_Api.G_MISS_CHAR) THEN
846: l_cnrv_rec.attribute10 := NULL;

Line 845: IF (l_cnrv_rec.attribute10 = Okc_Api.G_MISS_CHAR) THEN

841: END IF;
842: IF (l_cnrv_rec.attribute9 = Okc_Api.G_MISS_CHAR) THEN
843: l_cnrv_rec.attribute9 := NULL;
844: END IF;
845: IF (l_cnrv_rec.attribute10 = Okc_Api.G_MISS_CHAR) THEN
846: l_cnrv_rec.attribute10 := NULL;
847: END IF;
848: IF (l_cnrv_rec.attribute11 = Okc_Api.G_MISS_CHAR) THEN
849: l_cnrv_rec.attribute11 := NULL;

Line 848: IF (l_cnrv_rec.attribute11 = Okc_Api.G_MISS_CHAR) THEN

844: END IF;
845: IF (l_cnrv_rec.attribute10 = Okc_Api.G_MISS_CHAR) THEN
846: l_cnrv_rec.attribute10 := NULL;
847: END IF;
848: IF (l_cnrv_rec.attribute11 = Okc_Api.G_MISS_CHAR) THEN
849: l_cnrv_rec.attribute11 := NULL;
850: END IF;
851: IF (l_cnrv_rec.attribute12 = Okc_Api.G_MISS_CHAR) THEN
852: l_cnrv_rec.attribute12 := NULL;

Line 851: IF (l_cnrv_rec.attribute12 = Okc_Api.G_MISS_CHAR) THEN

847: END IF;
848: IF (l_cnrv_rec.attribute11 = Okc_Api.G_MISS_CHAR) THEN
849: l_cnrv_rec.attribute11 := NULL;
850: END IF;
851: IF (l_cnrv_rec.attribute12 = Okc_Api.G_MISS_CHAR) THEN
852: l_cnrv_rec.attribute12 := NULL;
853: END IF;
854: IF (l_cnrv_rec.attribute13 = Okc_Api.G_MISS_CHAR) THEN
855: l_cnrv_rec.attribute13 := NULL;

Line 854: IF (l_cnrv_rec.attribute13 = Okc_Api.G_MISS_CHAR) THEN

850: END IF;
851: IF (l_cnrv_rec.attribute12 = Okc_Api.G_MISS_CHAR) THEN
852: l_cnrv_rec.attribute12 := NULL;
853: END IF;
854: IF (l_cnrv_rec.attribute13 = Okc_Api.G_MISS_CHAR) THEN
855: l_cnrv_rec.attribute13 := NULL;
856: END IF;
857: IF (l_cnrv_rec.attribute14 = Okc_Api.G_MISS_CHAR) THEN
858: l_cnrv_rec.attribute14 := NULL;

Line 857: IF (l_cnrv_rec.attribute14 = Okc_Api.G_MISS_CHAR) THEN

853: END IF;
854: IF (l_cnrv_rec.attribute13 = Okc_Api.G_MISS_CHAR) THEN
855: l_cnrv_rec.attribute13 := NULL;
856: END IF;
857: IF (l_cnrv_rec.attribute14 = Okc_Api.G_MISS_CHAR) THEN
858: l_cnrv_rec.attribute14 := NULL;
859: END IF;
860: IF (l_cnrv_rec.attribute15 = Okc_Api.G_MISS_CHAR) THEN
861: l_cnrv_rec.attribute15 := NULL;

Line 860: IF (l_cnrv_rec.attribute15 = Okc_Api.G_MISS_CHAR) THEN

856: END IF;
857: IF (l_cnrv_rec.attribute14 = Okc_Api.G_MISS_CHAR) THEN
858: l_cnrv_rec.attribute14 := NULL;
859: END IF;
860: IF (l_cnrv_rec.attribute15 = Okc_Api.G_MISS_CHAR) THEN
861: l_cnrv_rec.attribute15 := NULL;
862: END IF;
863: IF (l_cnrv_rec.request_id = Okc_Api.G_MISS_NUM) THEN
864: l_cnrv_rec.request_id := NULL;

Line 863: IF (l_cnrv_rec.request_id = Okc_Api.G_MISS_NUM) THEN

859: END IF;
860: IF (l_cnrv_rec.attribute15 = Okc_Api.G_MISS_CHAR) THEN
861: l_cnrv_rec.attribute15 := NULL;
862: END IF;
863: IF (l_cnrv_rec.request_id = Okc_Api.G_MISS_NUM) THEN
864: l_cnrv_rec.request_id := NULL;
865: END IF;
866: IF (l_cnrv_rec.program_application_id = Okc_Api.G_MISS_NUM) THEN
867: l_cnrv_rec.program_application_id := NULL;

Line 866: IF (l_cnrv_rec.program_application_id = Okc_Api.G_MISS_NUM) THEN

862: END IF;
863: IF (l_cnrv_rec.request_id = Okc_Api.G_MISS_NUM) THEN
864: l_cnrv_rec.request_id := NULL;
865: END IF;
866: IF (l_cnrv_rec.program_application_id = Okc_Api.G_MISS_NUM) THEN
867: l_cnrv_rec.program_application_id := NULL;
868: END IF;
869: IF (l_cnrv_rec.program_id = Okc_Api.G_MISS_NUM) THEN
870: l_cnrv_rec.program_id := NULL;

Line 869: IF (l_cnrv_rec.program_id = Okc_Api.G_MISS_NUM) THEN

865: END IF;
866: IF (l_cnrv_rec.program_application_id = Okc_Api.G_MISS_NUM) THEN
867: l_cnrv_rec.program_application_id := NULL;
868: END IF;
869: IF (l_cnrv_rec.program_id = Okc_Api.G_MISS_NUM) THEN
870: l_cnrv_rec.program_id := NULL;
871: END IF;
872: IF (l_cnrv_rec.program_update_date = Okc_Api.G_MISS_DATE) THEN
873: l_cnrv_rec.program_update_date := NULL;

Line 872: IF (l_cnrv_rec.program_update_date = Okc_Api.G_MISS_DATE) THEN

868: END IF;
869: IF (l_cnrv_rec.program_id = Okc_Api.G_MISS_NUM) THEN
870: l_cnrv_rec.program_id := NULL;
871: END IF;
872: IF (l_cnrv_rec.program_update_date = Okc_Api.G_MISS_DATE) THEN
873: l_cnrv_rec.program_update_date := NULL;
874: END IF;
875: IF (l_cnrv_rec.org_id = Okc_Api.G_MISS_NUM) THEN
876: l_cnrv_rec.org_id := NULL;

Line 875: IF (l_cnrv_rec.org_id = Okc_Api.G_MISS_NUM) THEN

871: END IF;
872: IF (l_cnrv_rec.program_update_date = Okc_Api.G_MISS_DATE) THEN
873: l_cnrv_rec.program_update_date := NULL;
874: END IF;
875: IF (l_cnrv_rec.org_id = Okc_Api.G_MISS_NUM) THEN
876: l_cnrv_rec.org_id := NULL;
877: END IF;
878: IF (l_cnrv_rec.created_by = Okc_Api.G_MISS_NUM) THEN
879: l_cnrv_rec.created_by := NULL;

Line 878: IF (l_cnrv_rec.created_by = Okc_Api.G_MISS_NUM) THEN

874: END IF;
875: IF (l_cnrv_rec.org_id = Okc_Api.G_MISS_NUM) THEN
876: l_cnrv_rec.org_id := NULL;
877: END IF;
878: IF (l_cnrv_rec.created_by = Okc_Api.G_MISS_NUM) THEN
879: l_cnrv_rec.created_by := NULL;
880: END IF;
881: IF (l_cnrv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
882: l_cnrv_rec.creation_date := NULL;

Line 881: IF (l_cnrv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN

877: END IF;
878: IF (l_cnrv_rec.created_by = Okc_Api.G_MISS_NUM) THEN
879: l_cnrv_rec.created_by := NULL;
880: END IF;
881: IF (l_cnrv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
882: l_cnrv_rec.creation_date := NULL;
883: END IF;
884: IF (l_cnrv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
885: l_cnrv_rec.last_updated_by := NULL;

Line 884: IF (l_cnrv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN

880: END IF;
881: IF (l_cnrv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
882: l_cnrv_rec.creation_date := NULL;
883: END IF;
884: IF (l_cnrv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
885: l_cnrv_rec.last_updated_by := NULL;
886: END IF;
887: IF (l_cnrv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
888: l_cnrv_rec.last_update_date := NULL;

Line 887: IF (l_cnrv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN

883: END IF;
884: IF (l_cnrv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
885: l_cnrv_rec.last_updated_by := NULL;
886: END IF;
887: IF (l_cnrv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
888: l_cnrv_rec.last_update_date := NULL;
889: END IF;
890: IF (l_cnrv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
891: l_cnrv_rec.last_update_login := NULL;

Line 890: IF (l_cnrv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN

886: END IF;
887: IF (l_cnrv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
888: l_cnrv_rec.last_update_date := NULL;
889: END IF;
890: IF (l_cnrv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
891: l_cnrv_rec.last_update_login := NULL;
892: END IF;
893: -- for LE Uptake project 08-11-2006
894: IF (l_cnrv_rec.legal_entity_id = Okc_Api.G_MISS_NUM) THEN

Line 894: IF (l_cnrv_rec.legal_entity_id = Okc_Api.G_MISS_NUM) THEN

890: IF (l_cnrv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
891: l_cnrv_rec.last_update_login := NULL;
892: END IF;
893: -- for LE Uptake project 08-11-2006
894: IF (l_cnrv_rec.legal_entity_id = Okc_Api.G_MISS_NUM) THEN
895: l_cnrv_rec.legal_entity_id := NULL;
896: END IF;
897: -- for LE Uptake project 08-11-2006
898: RETURN(l_cnrv_rec);

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

905: -------------------------------------------------
906: FUNCTION Validate_Attributes (
907: p_cnrv_rec IN cnrv_rec_type
908: ) RETURN VARCHAR2 IS
909: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
910: -- Added 04/19/2001 -- Sunil Mathew
911: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
912: BEGIN
913: -- Added 04/19/2001 -- Sunil Mathew

Line 1001: IF p_cnrv_rec.id = Okc_Api.G_MISS_NUM OR

997: END IF;
998:
999: -- End Addition 04/19/2001 -- Sunil Mathew
1000:
1001: IF p_cnrv_rec.id = Okc_Api.G_MISS_NUM OR
1002: p_cnrv_rec.id IS NULL
1003: THEN
1004: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
1005: l_return_status := Okc_Api.G_RET_STS_ERROR;

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

1000:
1001: IF p_cnrv_rec.id = Okc_Api.G_MISS_NUM OR
1002: p_cnrv_rec.id IS NULL
1003: THEN
1004: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
1005: l_return_status := Okc_Api.G_RET_STS_ERROR;
1006: ELSIF p_cnrv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
1007: p_cnrv_rec.object_version_number IS NULL
1008: THEN

Line 1005: l_return_status := Okc_Api.G_RET_STS_ERROR;

1001: IF p_cnrv_rec.id = Okc_Api.G_MISS_NUM OR
1002: p_cnrv_rec.id IS NULL
1003: THEN
1004: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
1005: l_return_status := Okc_Api.G_RET_STS_ERROR;
1006: ELSIF p_cnrv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
1007: p_cnrv_rec.object_version_number IS NULL
1008: THEN
1009: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 1006: ELSIF p_cnrv_rec.object_version_number = Okc_Api.G_MISS_NUM OR

1002: p_cnrv_rec.id IS NULL
1003: THEN
1004: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
1005: l_return_status := Okc_Api.G_RET_STS_ERROR;
1006: ELSIF p_cnrv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
1007: p_cnrv_rec.object_version_number IS NULL
1008: THEN
1009: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
1010: l_return_status := Okc_Api.G_RET_STS_ERROR;

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

1005: l_return_status := Okc_Api.G_RET_STS_ERROR;
1006: ELSIF p_cnrv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
1007: p_cnrv_rec.object_version_number IS NULL
1008: THEN
1009: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
1010: l_return_status := Okc_Api.G_RET_STS_ERROR;
1011: ELSIF p_cnrv_rec.ibt_id = Okc_Api.G_MISS_NUM OR
1012: p_cnrv_rec.ibt_id IS NULL
1013: THEN

Line 1010: l_return_status := Okc_Api.G_RET_STS_ERROR;

1006: ELSIF p_cnrv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
1007: p_cnrv_rec.object_version_number IS NULL
1008: THEN
1009: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
1010: l_return_status := Okc_Api.G_RET_STS_ERROR;
1011: ELSIF p_cnrv_rec.ibt_id = Okc_Api.G_MISS_NUM OR
1012: p_cnrv_rec.ibt_id IS NULL
1013: THEN
1014: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ibt_id');

Line 1011: ELSIF p_cnrv_rec.ibt_id = Okc_Api.G_MISS_NUM OR

1007: p_cnrv_rec.object_version_number IS NULL
1008: THEN
1009: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
1010: l_return_status := Okc_Api.G_RET_STS_ERROR;
1011: ELSIF p_cnrv_rec.ibt_id = Okc_Api.G_MISS_NUM OR
1012: p_cnrv_rec.ibt_id IS NULL
1013: THEN
1014: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ibt_id');
1015: l_return_status := Okc_Api.G_RET_STS_ERROR;

Line 1014: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ibt_id');

1010: l_return_status := Okc_Api.G_RET_STS_ERROR;
1011: ELSIF p_cnrv_rec.ibt_id = Okc_Api.G_MISS_NUM OR
1012: p_cnrv_rec.ibt_id IS NULL
1013: THEN
1014: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ibt_id');
1015: l_return_status := Okc_Api.G_RET_STS_ERROR;
1016: ELSIF p_cnrv_rec.ixx_id = Okc_Api.G_MISS_NUM OR
1017: p_cnrv_rec.ixx_id IS NULL
1018: THEN

Line 1015: l_return_status := Okc_Api.G_RET_STS_ERROR;

1011: ELSIF p_cnrv_rec.ibt_id = Okc_Api.G_MISS_NUM OR
1012: p_cnrv_rec.ibt_id IS NULL
1013: THEN
1014: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ibt_id');
1015: l_return_status := Okc_Api.G_RET_STS_ERROR;
1016: ELSIF p_cnrv_rec.ixx_id = Okc_Api.G_MISS_NUM OR
1017: p_cnrv_rec.ixx_id IS NULL
1018: THEN
1019: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ixx_id');

Line 1016: ELSIF p_cnrv_rec.ixx_id = Okc_Api.G_MISS_NUM OR

1012: p_cnrv_rec.ibt_id IS NULL
1013: THEN
1014: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ibt_id');
1015: l_return_status := Okc_Api.G_RET_STS_ERROR;
1016: ELSIF p_cnrv_rec.ixx_id = Okc_Api.G_MISS_NUM OR
1017: p_cnrv_rec.ixx_id IS NULL
1018: THEN
1019: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ixx_id');
1020: l_return_status := Okc_Api.G_RET_STS_ERROR;

Line 1019: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ixx_id');

1015: l_return_status := Okc_Api.G_RET_STS_ERROR;
1016: ELSIF p_cnrv_rec.ixx_id = Okc_Api.G_MISS_NUM OR
1017: p_cnrv_rec.ixx_id IS NULL
1018: THEN
1019: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ixx_id');
1020: l_return_status := Okc_Api.G_RET_STS_ERROR;
1021: ELSIF p_cnrv_rec.currency_code = Okc_Api.G_MISS_CHAR OR
1022: p_cnrv_rec.currency_code IS NULL
1023: THEN

Line 1020: l_return_status := Okc_Api.G_RET_STS_ERROR;

1016: ELSIF p_cnrv_rec.ixx_id = Okc_Api.G_MISS_NUM OR
1017: p_cnrv_rec.ixx_id IS NULL
1018: THEN
1019: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ixx_id');
1020: l_return_status := Okc_Api.G_RET_STS_ERROR;
1021: ELSIF p_cnrv_rec.currency_code = Okc_Api.G_MISS_CHAR OR
1022: p_cnrv_rec.currency_code IS NULL
1023: THEN
1024: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'currency_code');

Line 1021: ELSIF p_cnrv_rec.currency_code = Okc_Api.G_MISS_CHAR OR

1017: p_cnrv_rec.ixx_id IS NULL
1018: THEN
1019: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ixx_id');
1020: l_return_status := Okc_Api.G_RET_STS_ERROR;
1021: ELSIF p_cnrv_rec.currency_code = Okc_Api.G_MISS_CHAR OR
1022: p_cnrv_rec.currency_code IS NULL
1023: THEN
1024: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'currency_code');
1025: l_return_status := Okc_Api.G_RET_STS_ERROR;

Line 1024: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'currency_code');

1020: l_return_status := Okc_Api.G_RET_STS_ERROR;
1021: ELSIF p_cnrv_rec.currency_code = Okc_Api.G_MISS_CHAR OR
1022: p_cnrv_rec.currency_code IS NULL
1023: THEN
1024: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'currency_code');
1025: l_return_status := Okc_Api.G_RET_STS_ERROR;
1026: ELSIF p_cnrv_rec.irm_id = Okc_Api.G_MISS_NUM OR
1027: p_cnrv_rec.irm_id IS NULL
1028: THEN

Line 1025: l_return_status := Okc_Api.G_RET_STS_ERROR;

1021: ELSIF p_cnrv_rec.currency_code = Okc_Api.G_MISS_CHAR OR
1022: p_cnrv_rec.currency_code IS NULL
1023: THEN
1024: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'currency_code');
1025: l_return_status := Okc_Api.G_RET_STS_ERROR;
1026: ELSIF p_cnrv_rec.irm_id = Okc_Api.G_MISS_NUM OR
1027: p_cnrv_rec.irm_id IS NULL
1028: THEN
1029: NULL;

Line 1026: ELSIF p_cnrv_rec.irm_id = Okc_Api.G_MISS_NUM OR

1022: p_cnrv_rec.currency_code IS NULL
1023: THEN
1024: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'currency_code');
1025: l_return_status := Okc_Api.G_RET_STS_ERROR;
1026: ELSIF p_cnrv_rec.irm_id = Okc_Api.G_MISS_NUM OR
1027: p_cnrv_rec.irm_id IS NULL
1028: THEN
1029: NULL;
1030: ELSIF p_cnrv_rec.set_of_books_id = Okc_Api.G_MISS_NUM OR

Line 1030: ELSIF p_cnrv_rec.set_of_books_id = Okc_Api.G_MISS_NUM OR

1026: ELSIF p_cnrv_rec.irm_id = Okc_Api.G_MISS_NUM OR
1027: p_cnrv_rec.irm_id IS NULL
1028: THEN
1029: NULL;
1030: ELSIF p_cnrv_rec.set_of_books_id = Okc_Api.G_MISS_NUM OR
1031: p_cnrv_rec.set_of_books_id IS NULL
1032: THEN
1033: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'set_of_books_id');
1034: l_return_status := Okc_Api.G_RET_STS_ERROR;

Line 1033: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'set_of_books_id');

1029: NULL;
1030: ELSIF p_cnrv_rec.set_of_books_id = Okc_Api.G_MISS_NUM OR
1031: p_cnrv_rec.set_of_books_id IS NULL
1032: THEN
1033: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'set_of_books_id');
1034: l_return_status := Okc_Api.G_RET_STS_ERROR;
1035: ELSIF p_cnrv_rec.trx_status_code = Okc_Api.G_MISS_CHAR OR
1036: p_cnrv_rec.trx_status_code IS NULL
1037: THEN

Line 1034: l_return_status := Okc_Api.G_RET_STS_ERROR;

1030: ELSIF p_cnrv_rec.set_of_books_id = Okc_Api.G_MISS_NUM OR
1031: p_cnrv_rec.set_of_books_id IS NULL
1032: THEN
1033: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'set_of_books_id');
1034: l_return_status := Okc_Api.G_RET_STS_ERROR;
1035: ELSIF p_cnrv_rec.trx_status_code = Okc_Api.G_MISS_CHAR OR
1036: p_cnrv_rec.trx_status_code IS NULL
1037: THEN
1038: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_status_code');

Line 1035: ELSIF p_cnrv_rec.trx_status_code = Okc_Api.G_MISS_CHAR OR

1031: p_cnrv_rec.set_of_books_id IS NULL
1032: THEN
1033: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'set_of_books_id');
1034: l_return_status := Okc_Api.G_RET_STS_ERROR;
1035: ELSIF p_cnrv_rec.trx_status_code = Okc_Api.G_MISS_CHAR OR
1036: p_cnrv_rec.trx_status_code IS NULL
1037: THEN
1038: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_status_code');
1039: l_return_status := Okc_Api.G_RET_STS_ERROR;

Line 1038: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_status_code');

1034: l_return_status := Okc_Api.G_RET_STS_ERROR;
1035: ELSIF p_cnrv_rec.trx_status_code = Okc_Api.G_MISS_CHAR OR
1036: p_cnrv_rec.trx_status_code IS NULL
1037: THEN
1038: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_status_code');
1039: l_return_status := Okc_Api.G_RET_STS_ERROR;
1040: ELSIF p_cnrv_rec.date_consolidated = Okc_Api.G_MISS_DATE OR
1041: p_cnrv_rec.date_consolidated IS NULL
1042: THEN

Line 1039: l_return_status := Okc_Api.G_RET_STS_ERROR;

1035: ELSIF p_cnrv_rec.trx_status_code = Okc_Api.G_MISS_CHAR OR
1036: p_cnrv_rec.trx_status_code IS NULL
1037: THEN
1038: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_status_code');
1039: l_return_status := Okc_Api.G_RET_STS_ERROR;
1040: ELSIF p_cnrv_rec.date_consolidated = Okc_Api.G_MISS_DATE OR
1041: p_cnrv_rec.date_consolidated IS NULL
1042: THEN
1043: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'date_consolidated');

Line 1040: ELSIF p_cnrv_rec.date_consolidated = Okc_Api.G_MISS_DATE OR

1036: p_cnrv_rec.trx_status_code IS NULL
1037: THEN
1038: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'trx_status_code');
1039: l_return_status := Okc_Api.G_RET_STS_ERROR;
1040: ELSIF p_cnrv_rec.date_consolidated = Okc_Api.G_MISS_DATE OR
1041: p_cnrv_rec.date_consolidated IS NULL
1042: THEN
1043: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'date_consolidated');
1044: l_return_status := Okc_Api.G_RET_STS_ERROR;

Line 1043: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'date_consolidated');

1039: l_return_status := Okc_Api.G_RET_STS_ERROR;
1040: ELSIF p_cnrv_rec.date_consolidated = Okc_Api.G_MISS_DATE OR
1041: p_cnrv_rec.date_consolidated IS NULL
1042: THEN
1043: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'date_consolidated');
1044: l_return_status := Okc_Api.G_RET_STS_ERROR;
1045: END IF;
1046: RETURN(l_return_status);
1047: END Validate_Attributes;

Line 1044: l_return_status := Okc_Api.G_RET_STS_ERROR;

1040: ELSIF p_cnrv_rec.date_consolidated = Okc_Api.G_MISS_DATE OR
1041: p_cnrv_rec.date_consolidated IS NULL
1042: THEN
1043: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'date_consolidated');
1044: l_return_status := Okc_Api.G_RET_STS_ERROR;
1045: END IF;
1046: RETURN(l_return_status);
1047: END Validate_Attributes;
1048:

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

1054: ---------------------------------------------
1055: FUNCTION Validate_Record (
1056: p_cnrv_rec IN cnrv_rec_type
1057: ) RETURN VARCHAR2 IS
1058: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1059: BEGIN
1060: RETURN (l_return_status);
1061: END Validate_Record;
1062:

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

1201: p_cnrv_rec IN cnrv_rec_type) IS
1202:
1203: l_api_version CONSTANT NUMBER := 1;
1204: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1205: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1206: l_cnrv_rec cnrv_rec_type := p_cnrv_rec;
1207: l_cnr_rec cnr_rec_type;
1208: l_okl_cnsld_ar_hdrs_tl_rec okl_cnsld_ar_hdrs_tl_rec_type;
1209: BEGIN

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

1206: l_cnrv_rec cnrv_rec_type := p_cnrv_rec;
1207: l_cnr_rec cnr_rec_type;
1208: l_okl_cnsld_ar_hdrs_tl_rec okl_cnsld_ar_hdrs_tl_rec_type;
1209: BEGIN
1210: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1211: G_PKG_NAME,
1212: p_init_msg_list,
1213: l_api_version,
1214: p_api_version,

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

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

Line 1218: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1220: RAISE Okc_Api.G_EXCEPTION_ERROR;

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

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

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

Line 1226: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1228: RAISE Okc_Api.G_EXCEPTION_ERROR;

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

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

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

Line 1232: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1234: RAISE Okc_Api.G_EXCEPTION_ERROR;

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

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

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

Line 1238: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

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

Line 1239: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

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

Line 1243: 'OKC_API.G_RET_STS_ERROR',

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

Line 1248: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1249: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

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

Line 1253: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1259: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

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

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

1278: p_cnrv_tbl IN cnrv_tbl_type) IS
1279:
1280: l_api_version CONSTANT NUMBER := 1;
1281: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1282: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1283: i NUMBER := 0;
1284: BEGIN
1285: Okc_Api.init_msg_list(p_init_msg_list);
1286: -- Make sure PL/SQL table has records in it before passing

Line 1285: Okc_Api.init_msg_list(p_init_msg_list);

1281: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1282: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1283: i NUMBER := 0;
1284: BEGIN
1285: Okc_Api.init_msg_list(p_init_msg_list);
1286: -- Make sure PL/SQL table has records in it before passing
1287: IF (p_cnrv_tbl.COUNT > 0) THEN
1288: i := p_cnrv_tbl.FIRST;
1289: LOOP

Line 1292: p_init_msg_list => Okc_Api.G_FALSE,

1288: i := p_cnrv_tbl.FIRST;
1289: LOOP
1290: validate_row (
1291: p_api_version => p_api_version,
1292: p_init_msg_list => Okc_Api.G_FALSE,
1293: x_return_status => x_return_status,
1294: x_msg_count => x_msg_count,
1295: x_msg_data => x_msg_data,
1296: p_cnrv_rec => p_cnrv_tbl(i));

Line 1302: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1298: i := p_cnrv_tbl.NEXT(i);
1299: END LOOP;
1300: END IF;
1301: EXCEPTION
1302: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1303: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1304: (
1305: l_api_name,
1306: G_PKG_NAME,

Line 1303: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1299: END LOOP;
1300: END IF;
1301: EXCEPTION
1302: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1303: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1304: (
1305: l_api_name,
1306: G_PKG_NAME,
1307: 'OKC_API.G_RET_STS_ERROR',

Line 1307: 'OKC_API.G_RET_STS_ERROR',

1303: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1304: (
1305: l_api_name,
1306: G_PKG_NAME,
1307: 'OKC_API.G_RET_STS_ERROR',
1308: x_msg_count,
1309: x_msg_data,
1310: '_PVT'
1311: );

Line 1312: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1313: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1309: x_msg_data,
1310: '_PVT'
1311: );
1312: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1313: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1314: (
1315: l_api_name,
1316: G_PKG_NAME,
1317: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1317: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1313: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1314: (
1315: l_api_name,
1316: G_PKG_NAME,
1317: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1318: x_msg_count,
1319: x_msg_data,
1320: '_PVT'
1321: );

Line 1323: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1319: x_msg_data,
1320: '_PVT'
1321: );
1322: WHEN OTHERS THEN
1323: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1324: (
1325: l_api_name,
1326: G_PKG_NAME,
1327: 'OTHERS',

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

1346: x_cnr_rec OUT NOCOPY cnr_rec_type) IS
1347:
1348: l_api_version CONSTANT NUMBER := 1;
1349: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
1350: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1351: l_cnr_rec cnr_rec_type := p_cnr_rec;
1352: l_def_cnr_rec cnr_rec_type;
1353: --------------------------------------------
1354: -- Set_Attributes for:OKL_CNSLD_AR_HDRS_B --

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

1356: FUNCTION Set_Attributes (
1357: p_cnr_rec IN cnr_rec_type,
1358: x_cnr_rec OUT NOCOPY cnr_rec_type
1359: ) RETURN VARCHAR2 IS
1360: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1361: BEGIN
1362: x_cnr_rec := p_cnr_rec;
1363: RETURN(l_return_status);
1364: END Set_Attributes;

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

1362: x_cnr_rec := p_cnr_rec;
1363: RETURN(l_return_status);
1364: END Set_Attributes;
1365: BEGIN
1366: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1367: p_init_msg_list,
1368: '_PVT',
1369: x_return_status);
1370: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

1366: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1367: p_init_msg_list,
1368: '_PVT',
1369: x_return_status);
1370: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1371: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1372: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1373: RAISE Okc_Api.G_EXCEPTION_ERROR;
1374: END IF;

Line 1371: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1367: p_init_msg_list,
1368: '_PVT',
1369: x_return_status);
1370: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1371: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1372: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1373: RAISE Okc_Api.G_EXCEPTION_ERROR;
1374: END IF;
1375: --- Setting item attributes

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

1368: '_PVT',
1369: x_return_status);
1370: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1371: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1372: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1373: RAISE Okc_Api.G_EXCEPTION_ERROR;
1374: END IF;
1375: --- Setting item attributes
1376: l_return_status := Set_Attributes(

Line 1373: RAISE Okc_Api.G_EXCEPTION_ERROR;

1369: x_return_status);
1370: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1371: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1372: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1373: RAISE Okc_Api.G_EXCEPTION_ERROR;
1374: END IF;
1375: --- Setting item attributes
1376: l_return_status := Set_Attributes(
1377: p_cnr_rec, -- IN

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

1376: l_return_status := Set_Attributes(
1377: p_cnr_rec, -- IN
1378: l_cnr_rec); -- OUT
1379: --- If any errors happen abort API
1380: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1381: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1382: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1383: RAISE Okc_Api.G_EXCEPTION_ERROR;
1384: END IF;

Line 1381: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1377: p_cnr_rec, -- IN
1378: l_cnr_rec); -- OUT
1379: --- If any errors happen abort API
1380: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1381: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1382: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1383: RAISE Okc_Api.G_EXCEPTION_ERROR;
1384: END IF;
1385: INSERT INTO OKL_CNSLD_AR_HDRS_B(

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

1378: l_cnr_rec); -- OUT
1379: --- If any errors happen abort API
1380: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1381: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1382: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1383: RAISE Okc_Api.G_EXCEPTION_ERROR;
1384: END IF;
1385: INSERT INTO OKL_CNSLD_AR_HDRS_B(
1386: id,

Line 1383: RAISE Okc_Api.G_EXCEPTION_ERROR;

1379: --- If any errors happen abort API
1380: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1381: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1382: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1383: RAISE Okc_Api.G_EXCEPTION_ERROR;
1384: END IF;
1385: INSERT INTO OKL_CNSLD_AR_HDRS_B(
1386: id,
1387: consolidated_invoice_number,

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

1467: l_cnr_rec.last_update_login,
1468: l_cnr_rec.legal_entity_id); -- for LE Uptake project 08-11-2006
1469: -- Set OUT values
1470: x_cnr_rec := l_cnr_rec;
1471: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1472: EXCEPTION
1473: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1474: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1475: (

Line 1473: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1469: -- Set OUT values
1470: x_cnr_rec := l_cnr_rec;
1471: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1472: EXCEPTION
1473: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1474: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1475: (
1476: l_api_name,
1477: G_PKG_NAME,

Line 1474: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1470: x_cnr_rec := l_cnr_rec;
1471: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1472: EXCEPTION
1473: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1474: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1475: (
1476: l_api_name,
1477: G_PKG_NAME,
1478: 'OKC_API.G_RET_STS_ERROR',

Line 1478: 'OKC_API.G_RET_STS_ERROR',

1474: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1475: (
1476: l_api_name,
1477: G_PKG_NAME,
1478: 'OKC_API.G_RET_STS_ERROR',
1479: x_msg_count,
1480: x_msg_data,
1481: '_PVT'
1482: );

Line 1483: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1479: x_msg_count,
1480: x_msg_data,
1481: '_PVT'
1482: );
1483: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1484: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1485: (
1486: l_api_name,
1487: G_PKG_NAME,

Line 1484: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1480: x_msg_data,
1481: '_PVT'
1482: );
1483: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1484: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1485: (
1486: l_api_name,
1487: G_PKG_NAME,
1488: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1488: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1484: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1485: (
1486: l_api_name,
1487: G_PKG_NAME,
1488: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1489: x_msg_count,
1490: x_msg_data,
1491: '_PVT'
1492: );

Line 1494: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1490: x_msg_data,
1491: '_PVT'
1492: );
1493: WHEN OTHERS THEN
1494: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1495: (
1496: l_api_name,
1497: G_PKG_NAME,
1498: 'OTHERS',

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

1513: x_okl_cnsld_ar_hdrs_tl_rec OUT NOCOPY okl_cnsld_ar_hdrs_tl_rec_type) IS
1514:
1515: l_api_version CONSTANT NUMBER := 1;
1516: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
1517: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1518: l_okl_cnsld_ar_hdrs_tl_rec okl_cnsld_ar_hdrs_tl_rec_type := p_okl_cnsld_ar_hdrs_tl_rec;
1519: ldefoklcnsldarhdrstlrec okl_cnsld_ar_hdrs_tl_rec_type;
1520: CURSOR get_languages IS
1521: SELECT *

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

1527: FUNCTION Set_Attributes (
1528: p_okl_cnsld_ar_hdrs_tl_rec IN okl_cnsld_ar_hdrs_tl_rec_type,
1529: x_okl_cnsld_ar_hdrs_tl_rec OUT NOCOPY okl_cnsld_ar_hdrs_tl_rec_type
1530: ) RETURN VARCHAR2 IS
1531: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1532: BEGIN
1533: x_okl_cnsld_ar_hdrs_tl_rec := p_okl_cnsld_ar_hdrs_tl_rec;
1534: x_okl_cnsld_ar_hdrs_tl_rec.LANGUAGE := USERENV('LANG');
1535: x_okl_cnsld_ar_hdrs_tl_rec.SOURCE_LANG := USERENV('LANG');

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

1535: x_okl_cnsld_ar_hdrs_tl_rec.SOURCE_LANG := USERENV('LANG');
1536: RETURN(l_return_status);
1537: END Set_Attributes;
1538: BEGIN
1539: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1540: p_init_msg_list,
1541: '_PVT',
1542: x_return_status);
1543: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

1539: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1540: p_init_msg_list,
1541: '_PVT',
1542: x_return_status);
1543: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1544: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1545: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1546: RAISE Okc_Api.G_EXCEPTION_ERROR;
1547: END IF;

Line 1544: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1540: p_init_msg_list,
1541: '_PVT',
1542: x_return_status);
1543: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1544: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1545: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1546: RAISE Okc_Api.G_EXCEPTION_ERROR;
1547: END IF;
1548: --- Setting item attributes

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

1541: '_PVT',
1542: x_return_status);
1543: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1544: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1545: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1546: RAISE Okc_Api.G_EXCEPTION_ERROR;
1547: END IF;
1548: --- Setting item attributes
1549: l_return_status := Set_Attributes(

Line 1546: RAISE Okc_Api.G_EXCEPTION_ERROR;

1542: x_return_status);
1543: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1544: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1545: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1546: RAISE Okc_Api.G_EXCEPTION_ERROR;
1547: END IF;
1548: --- Setting item attributes
1549: l_return_status := Set_Attributes(
1550: p_okl_cnsld_ar_hdrs_tl_rec, -- IN

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

1549: l_return_status := Set_Attributes(
1550: p_okl_cnsld_ar_hdrs_tl_rec, -- IN
1551: l_okl_cnsld_ar_hdrs_tl_rec); -- OUT
1552: --- If any errors happen abort API
1553: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1556: RAISE Okc_Api.G_EXCEPTION_ERROR;
1557: END IF;

Line 1554: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1550: p_okl_cnsld_ar_hdrs_tl_rec, -- IN
1551: l_okl_cnsld_ar_hdrs_tl_rec); -- OUT
1552: --- If any errors happen abort API
1553: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1556: RAISE Okc_Api.G_EXCEPTION_ERROR;
1557: END IF;
1558: FOR l_lang_rec IN get_languages LOOP

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

1551: l_okl_cnsld_ar_hdrs_tl_rec); -- OUT
1552: --- If any errors happen abort API
1553: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1556: RAISE Okc_Api.G_EXCEPTION_ERROR;
1557: END IF;
1558: FOR l_lang_rec IN get_languages LOOP
1559: l_okl_cnsld_ar_hdrs_tl_rec.LANGUAGE := l_lang_rec.language_code;

Line 1556: RAISE Okc_Api.G_EXCEPTION_ERROR;

1552: --- If any errors happen abort API
1553: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1556: RAISE Okc_Api.G_EXCEPTION_ERROR;
1557: END IF;
1558: FOR l_lang_rec IN get_languages LOOP
1559: l_okl_cnsld_ar_hdrs_tl_rec.LANGUAGE := l_lang_rec.language_code;
1560: INSERT INTO OKL_CNSLD_AR_HDRS_TL(

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

1581: l_okl_cnsld_ar_hdrs_tl_rec.last_update_login);
1582: END LOOP;
1583: -- Set OUT values
1584: x_okl_cnsld_ar_hdrs_tl_rec := l_okl_cnsld_ar_hdrs_tl_rec;
1585: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1586: EXCEPTION
1587: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1588: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1589: (

Line 1587: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1583: -- Set OUT values
1584: x_okl_cnsld_ar_hdrs_tl_rec := l_okl_cnsld_ar_hdrs_tl_rec;
1585: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1586: EXCEPTION
1587: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1588: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1589: (
1590: l_api_name,
1591: G_PKG_NAME,

Line 1588: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1584: x_okl_cnsld_ar_hdrs_tl_rec := l_okl_cnsld_ar_hdrs_tl_rec;
1585: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1586: EXCEPTION
1587: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1588: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1589: (
1590: l_api_name,
1591: G_PKG_NAME,
1592: 'OKC_API.G_RET_STS_ERROR',

Line 1592: 'OKC_API.G_RET_STS_ERROR',

1588: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1589: (
1590: l_api_name,
1591: G_PKG_NAME,
1592: 'OKC_API.G_RET_STS_ERROR',
1593: x_msg_count,
1594: x_msg_data,
1595: '_PVT'
1596: );

Line 1597: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1593: x_msg_count,
1594: x_msg_data,
1595: '_PVT'
1596: );
1597: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1598: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1599: (
1600: l_api_name,
1601: G_PKG_NAME,

Line 1598: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1594: x_msg_data,
1595: '_PVT'
1596: );
1597: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1598: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1599: (
1600: l_api_name,
1601: G_PKG_NAME,
1602: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1602: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1598: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1599: (
1600: l_api_name,
1601: G_PKG_NAME,
1602: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1603: x_msg_count,
1604: x_msg_data,
1605: '_PVT'
1606: );

Line 1608: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1604: x_msg_data,
1605: '_PVT'
1606: );
1607: WHEN OTHERS THEN
1608: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1609: (
1610: l_api_name,
1611: G_PKG_NAME,
1612: 'OTHERS',

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

1628: x_cnrv_rec OUT NOCOPY cnrv_rec_type) IS
1629:
1630: l_api_version CONSTANT NUMBER := 1;
1631: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1632: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1633: l_cnrv_rec cnrv_rec_type;
1634: l_def_cnrv_rec cnrv_rec_type;
1635: l_cnr_rec cnr_rec_type;
1636: lx_cnr_rec cnr_rec_type;

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

1657: FUNCTION Set_Attributes (
1658: p_cnrv_rec IN cnrv_rec_type,
1659: x_cnrv_rec OUT NOCOPY cnrv_rec_type
1660: ) RETURN VARCHAR2 IS
1661: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1662: BEGIN
1663: x_cnrv_rec := p_cnrv_rec;
1664: x_cnrv_rec.OBJECT_VERSION_NUMBER := 1;
1665: x_cnrv_rec.SFWT_FLAG := 'N';

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

1680:
1681: RETURN(l_return_status);
1682: END Set_Attributes;
1683: BEGIN
1684: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1685: G_PKG_NAME,
1686: p_init_msg_list,
1687: l_api_version,
1688: p_api_version,

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

1687: l_api_version,
1688: p_api_version,
1689: '_PVT',
1690: x_return_status);
1691: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1693: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1694: RAISE Okc_Api.G_EXCEPTION_ERROR;
1695: END IF;

Line 1692: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1688: p_api_version,
1689: '_PVT',
1690: x_return_status);
1691: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1693: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1694: RAISE Okc_Api.G_EXCEPTION_ERROR;
1695: END IF;
1696: l_cnrv_rec := null_out_defaults(p_cnrv_rec);

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

1689: '_PVT',
1690: x_return_status);
1691: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1693: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1694: RAISE Okc_Api.G_EXCEPTION_ERROR;
1695: END IF;
1696: l_cnrv_rec := null_out_defaults(p_cnrv_rec);
1697: -- Set primary key value

Line 1694: RAISE Okc_Api.G_EXCEPTION_ERROR;

1690: x_return_status);
1691: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1693: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1694: RAISE Okc_Api.G_EXCEPTION_ERROR;
1695: END IF;
1696: l_cnrv_rec := null_out_defaults(p_cnrv_rec);
1697: -- Set primary key value
1698: l_cnrv_rec.ID := get_seq_id;

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

1700: l_return_status := Set_Attributes(
1701: l_cnrv_rec, -- IN
1702: l_def_cnrv_rec); -- OUT
1703: --- If any errors happen abort API
1704: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1705: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1706: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1707: RAISE Okc_Api.G_EXCEPTION_ERROR;
1708: END IF;

Line 1705: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1701: l_cnrv_rec, -- IN
1702: l_def_cnrv_rec); -- OUT
1703: --- If any errors happen abort API
1704: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1705: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1706: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1707: RAISE Okc_Api.G_EXCEPTION_ERROR;
1708: END IF;
1709: l_def_cnrv_rec := fill_who_columns(l_def_cnrv_rec);

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

1702: l_def_cnrv_rec); -- OUT
1703: --- If any errors happen abort API
1704: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1705: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1706: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1707: RAISE Okc_Api.G_EXCEPTION_ERROR;
1708: END IF;
1709: l_def_cnrv_rec := fill_who_columns(l_def_cnrv_rec);
1710: --- Validate all non-missing attributes (Item Level Validation)

Line 1707: RAISE Okc_Api.G_EXCEPTION_ERROR;

1703: --- If any errors happen abort API
1704: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1705: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1706: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1707: RAISE Okc_Api.G_EXCEPTION_ERROR;
1708: END IF;
1709: l_def_cnrv_rec := fill_who_columns(l_def_cnrv_rec);
1710: --- Validate all non-missing attributes (Item Level Validation)
1711: l_return_status := Validate_Attributes(l_def_cnrv_rec);

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

1709: l_def_cnrv_rec := fill_who_columns(l_def_cnrv_rec);
1710: --- Validate all non-missing attributes (Item Level Validation)
1711: l_return_status := Validate_Attributes(l_def_cnrv_rec);
1712: --- If any errors happen abort API
1713: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1714: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1715: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1716: RAISE Okc_Api.G_EXCEPTION_ERROR;
1717: END IF;

Line 1714: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1710: --- Validate all non-missing attributes (Item Level Validation)
1711: l_return_status := Validate_Attributes(l_def_cnrv_rec);
1712: --- If any errors happen abort API
1713: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1714: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1715: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1716: RAISE Okc_Api.G_EXCEPTION_ERROR;
1717: END IF;
1718: l_return_status := Validate_Record(l_def_cnrv_rec);

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

1711: l_return_status := Validate_Attributes(l_def_cnrv_rec);
1712: --- If any errors happen abort API
1713: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1714: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1715: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1716: RAISE Okc_Api.G_EXCEPTION_ERROR;
1717: END IF;
1718: l_return_status := Validate_Record(l_def_cnrv_rec);
1719: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1716: RAISE Okc_Api.G_EXCEPTION_ERROR;

1712: --- If any errors happen abort API
1713: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1714: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1715: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1716: RAISE Okc_Api.G_EXCEPTION_ERROR;
1717: END IF;
1718: l_return_status := Validate_Record(l_def_cnrv_rec);
1719: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1720: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

1715: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1716: RAISE Okc_Api.G_EXCEPTION_ERROR;
1717: END IF;
1718: l_return_status := Validate_Record(l_def_cnrv_rec);
1719: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1720: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1721: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1722: RAISE Okc_Api.G_EXCEPTION_ERROR;
1723: END IF;

Line 1720: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1716: RAISE Okc_Api.G_EXCEPTION_ERROR;
1717: END IF;
1718: l_return_status := Validate_Record(l_def_cnrv_rec);
1719: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1720: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1721: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1722: RAISE Okc_Api.G_EXCEPTION_ERROR;
1723: END IF;
1724: --------------------------------------

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

1717: END IF;
1718: l_return_status := Validate_Record(l_def_cnrv_rec);
1719: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1720: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1721: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1722: RAISE Okc_Api.G_EXCEPTION_ERROR;
1723: END IF;
1724: --------------------------------------
1725: -- Move VIEW record to "Child" records

Line 1722: RAISE Okc_Api.G_EXCEPTION_ERROR;

1718: l_return_status := Validate_Record(l_def_cnrv_rec);
1719: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1720: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1721: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1722: RAISE Okc_Api.G_EXCEPTION_ERROR;
1723: END IF;
1724: --------------------------------------
1725: -- Move VIEW record to "Child" records
1726: --------------------------------------

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

1736: x_msg_data,
1737: l_cnr_rec,
1738: lx_cnr_rec
1739: );
1740: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1741: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1742: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1743: RAISE Okc_Api.G_EXCEPTION_ERROR;
1744: END IF;

Line 1741: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1737: l_cnr_rec,
1738: lx_cnr_rec
1739: );
1740: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1741: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1742: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1743: RAISE Okc_Api.G_EXCEPTION_ERROR;
1744: END IF;
1745: migrate(lx_cnr_rec, l_def_cnrv_rec);

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

1738: lx_cnr_rec
1739: );
1740: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1741: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1742: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1743: RAISE Okc_Api.G_EXCEPTION_ERROR;
1744: END IF;
1745: migrate(lx_cnr_rec, l_def_cnrv_rec);
1746: insert_row(

Line 1743: RAISE Okc_Api.G_EXCEPTION_ERROR;

1739: );
1740: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1741: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1742: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1743: RAISE Okc_Api.G_EXCEPTION_ERROR;
1744: END IF;
1745: migrate(lx_cnr_rec, l_def_cnrv_rec);
1746: insert_row(
1747: p_init_msg_list,

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

1750: x_msg_data,
1751: l_okl_cnsld_ar_hdrs_tl_rec,
1752: lx_okl_cnsld_ar_hdrs_tl_rec
1753: );
1754: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1755: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1756: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1757: RAISE Okc_Api.G_EXCEPTION_ERROR;
1758: END IF;

Line 1755: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1751: l_okl_cnsld_ar_hdrs_tl_rec,
1752: lx_okl_cnsld_ar_hdrs_tl_rec
1753: );
1754: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1755: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1756: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1757: RAISE Okc_Api.G_EXCEPTION_ERROR;
1758: END IF;
1759: migrate(lx_okl_cnsld_ar_hdrs_tl_rec, l_def_cnrv_rec);

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

1752: lx_okl_cnsld_ar_hdrs_tl_rec
1753: );
1754: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1755: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1756: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1757: RAISE Okc_Api.G_EXCEPTION_ERROR;
1758: END IF;
1759: migrate(lx_okl_cnsld_ar_hdrs_tl_rec, l_def_cnrv_rec);
1760: -- Set OUT values

Line 1757: RAISE Okc_Api.G_EXCEPTION_ERROR;

1753: );
1754: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1755: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1756: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1757: RAISE Okc_Api.G_EXCEPTION_ERROR;
1758: END IF;
1759: migrate(lx_okl_cnsld_ar_hdrs_tl_rec, l_def_cnrv_rec);
1760: -- Set OUT values
1761: x_cnrv_rec := l_def_cnrv_rec;

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

1758: END IF;
1759: migrate(lx_okl_cnsld_ar_hdrs_tl_rec, l_def_cnrv_rec);
1760: -- Set OUT values
1761: x_cnrv_rec := l_def_cnrv_rec;
1762: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1763: EXCEPTION
1764: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1765: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1766: (

Line 1764: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1760: -- Set OUT values
1761: x_cnrv_rec := l_def_cnrv_rec;
1762: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1763: EXCEPTION
1764: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1765: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1766: (
1767: l_api_name,
1768: G_PKG_NAME,

Line 1765: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1761: x_cnrv_rec := l_def_cnrv_rec;
1762: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1763: EXCEPTION
1764: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1765: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1766: (
1767: l_api_name,
1768: G_PKG_NAME,
1769: 'OKC_API.G_RET_STS_ERROR',

Line 1769: 'OKC_API.G_RET_STS_ERROR',

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

Line 1774: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1775: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

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

Line 1779: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1785: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

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

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

1805: x_cnrv_tbl OUT NOCOPY cnrv_tbl_type) IS
1806:
1807: l_api_version CONSTANT NUMBER := 1;
1808: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1809: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1810: i NUMBER := 0;
1811: BEGIN
1812: Okc_Api.init_msg_list(p_init_msg_list);
1813: -- Make sure PL/SQL table has records in it before passing

Line 1812: Okc_Api.init_msg_list(p_init_msg_list);

1808: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1809: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1810: i NUMBER := 0;
1811: BEGIN
1812: Okc_Api.init_msg_list(p_init_msg_list);
1813: -- Make sure PL/SQL table has records in it before passing
1814: IF (p_cnrv_tbl.COUNT > 0) THEN
1815: i := p_cnrv_tbl.FIRST;
1816: LOOP

Line 1819: p_init_msg_list => Okc_Api.G_FALSE,

1815: i := p_cnrv_tbl.FIRST;
1816: LOOP
1817: insert_row (
1818: p_api_version => p_api_version,
1819: p_init_msg_list => Okc_Api.G_FALSE,
1820: x_return_status => x_return_status,
1821: x_msg_count => x_msg_count,
1822: x_msg_data => x_msg_data,
1823: p_cnrv_rec => p_cnrv_tbl(i),

Line 1830: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1826: i := p_cnrv_tbl.NEXT(i);
1827: END LOOP;
1828: END IF;
1829: EXCEPTION
1830: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1831: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1832: (
1833: l_api_name,
1834: G_PKG_NAME,

Line 1831: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1827: END LOOP;
1828: END IF;
1829: EXCEPTION
1830: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1831: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1832: (
1833: l_api_name,
1834: G_PKG_NAME,
1835: 'OKC_API.G_RET_STS_ERROR',

Line 1835: 'OKC_API.G_RET_STS_ERROR',

1831: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1832: (
1833: l_api_name,
1834: G_PKG_NAME,
1835: 'OKC_API.G_RET_STS_ERROR',
1836: x_msg_count,
1837: x_msg_data,
1838: '_PVT'
1839: );

Line 1840: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1836: x_msg_count,
1837: x_msg_data,
1838: '_PVT'
1839: );
1840: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1841: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1842: (
1843: l_api_name,
1844: G_PKG_NAME,

Line 1841: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1837: x_msg_data,
1838: '_PVT'
1839: );
1840: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1841: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1842: (
1843: l_api_name,
1844: G_PKG_NAME,
1845: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1845: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1841: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1842: (
1843: l_api_name,
1844: G_PKG_NAME,
1845: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1846: x_msg_count,
1847: x_msg_data,
1848: '_PVT'
1849: );

Line 1851: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1847: x_msg_data,
1848: '_PVT'
1849: );
1850: WHEN OTHERS THEN
1851: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1852: (
1853: l_api_name,
1854: G_PKG_NAME,
1855: 'OTHERS',

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

1886: FROM OKL_CNSLD_AR_HDRS_B
1887: WHERE ID = p_cnr_rec.id;
1888: l_api_version CONSTANT NUMBER := 1;
1889: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1890: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1891: l_object_version_number OKL_CNSLD_AR_HDRS_B.OBJECT_VERSION_NUMBER%TYPE;
1892: lc_object_version_number OKL_CNSLD_AR_HDRS_B.OBJECT_VERSION_NUMBER%TYPE;
1893: l_row_notfound BOOLEAN := FALSE;
1894: lc_row_notfound BOOLEAN := FALSE;

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

1892: lc_object_version_number OKL_CNSLD_AR_HDRS_B.OBJECT_VERSION_NUMBER%TYPE;
1893: l_row_notfound BOOLEAN := FALSE;
1894: lc_row_notfound BOOLEAN := FALSE;
1895: BEGIN
1896: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1897: p_init_msg_list,
1898: '_PVT',
1899: x_return_status);
1900: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

1896: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1897: p_init_msg_list,
1898: '_PVT',
1899: x_return_status);
1900: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1901: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1902: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1903: RAISE Okc_Api.G_EXCEPTION_ERROR;
1904: END IF;

Line 1901: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1897: p_init_msg_list,
1898: '_PVT',
1899: x_return_status);
1900: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1901: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1902: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1903: RAISE Okc_Api.G_EXCEPTION_ERROR;
1904: END IF;
1905: BEGIN

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

1898: '_PVT',
1899: x_return_status);
1900: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1901: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1902: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1903: RAISE Okc_Api.G_EXCEPTION_ERROR;
1904: END IF;
1905: BEGIN
1906: OPEN lock_csr(p_cnr_rec);

Line 1903: RAISE Okc_Api.G_EXCEPTION_ERROR;

1899: x_return_status);
1900: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1901: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1902: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1903: RAISE Okc_Api.G_EXCEPTION_ERROR;
1904: END IF;
1905: BEGIN
1906: OPEN lock_csr(p_cnr_rec);
1907: FETCH lock_csr INTO l_object_version_number;

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

1911: WHEN E_Resource_Busy THEN
1912: IF (lock_csr%ISOPEN) THEN
1913: CLOSE lock_csr;
1914: END IF;
1915: Okc_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1916: RAISE App_Exceptions.RECORD_LOCK_EXCEPTION;
1917: END;
1918:
1919: IF ( l_row_notfound ) THEN

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

1922: lc_row_notfound := lchk_csr%NOTFOUND;
1923: CLOSE lchk_csr;
1924: END IF;
1925: IF (lc_row_notfound) THEN
1926: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1927: RAISE Okc_Api.G_EXCEPTION_ERROR;
1928: ELSIF lc_object_version_number > p_cnr_rec.object_version_number THEN
1929: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1930: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 1927: RAISE Okc_Api.G_EXCEPTION_ERROR;

1923: CLOSE lchk_csr;
1924: END IF;
1925: IF (lc_row_notfound) THEN
1926: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1927: RAISE Okc_Api.G_EXCEPTION_ERROR;
1928: ELSIF lc_object_version_number > p_cnr_rec.object_version_number THEN
1929: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1930: RAISE Okc_Api.G_EXCEPTION_ERROR;
1931: ELSIF lc_object_version_number <> p_cnr_rec.object_version_number THEN

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

1925: IF (lc_row_notfound) THEN
1926: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1927: RAISE Okc_Api.G_EXCEPTION_ERROR;
1928: ELSIF lc_object_version_number > p_cnr_rec.object_version_number THEN
1929: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1930: RAISE Okc_Api.G_EXCEPTION_ERROR;
1931: ELSIF lc_object_version_number <> p_cnr_rec.object_version_number THEN
1932: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1933: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 1930: RAISE Okc_Api.G_EXCEPTION_ERROR;

1926: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1927: RAISE Okc_Api.G_EXCEPTION_ERROR;
1928: ELSIF lc_object_version_number > p_cnr_rec.object_version_number THEN
1929: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1930: RAISE Okc_Api.G_EXCEPTION_ERROR;
1931: ELSIF lc_object_version_number <> p_cnr_rec.object_version_number THEN
1932: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1933: RAISE Okc_Api.G_EXCEPTION_ERROR;
1934: ELSIF lc_object_version_number = -1 THEN

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

1928: ELSIF lc_object_version_number > p_cnr_rec.object_version_number THEN
1929: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1930: RAISE Okc_Api.G_EXCEPTION_ERROR;
1931: ELSIF lc_object_version_number <> p_cnr_rec.object_version_number THEN
1932: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1933: RAISE Okc_Api.G_EXCEPTION_ERROR;
1934: ELSIF lc_object_version_number = -1 THEN
1935: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1936: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 1933: RAISE Okc_Api.G_EXCEPTION_ERROR;

1929: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1930: RAISE Okc_Api.G_EXCEPTION_ERROR;
1931: ELSIF lc_object_version_number <> p_cnr_rec.object_version_number THEN
1932: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1933: RAISE Okc_Api.G_EXCEPTION_ERROR;
1934: ELSIF lc_object_version_number = -1 THEN
1935: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1936: RAISE Okc_Api.G_EXCEPTION_ERROR;
1937: END IF;

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

1931: ELSIF lc_object_version_number <> p_cnr_rec.object_version_number THEN
1932: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1933: RAISE Okc_Api.G_EXCEPTION_ERROR;
1934: ELSIF lc_object_version_number = -1 THEN
1935: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1936: RAISE Okc_Api.G_EXCEPTION_ERROR;
1937: END IF;
1938: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1939: EXCEPTION

Line 1936: RAISE Okc_Api.G_EXCEPTION_ERROR;

1932: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1933: RAISE Okc_Api.G_EXCEPTION_ERROR;
1934: ELSIF lc_object_version_number = -1 THEN
1935: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1936: RAISE Okc_Api.G_EXCEPTION_ERROR;
1937: END IF;
1938: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1939: EXCEPTION
1940: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

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

1934: ELSIF lc_object_version_number = -1 THEN
1935: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1936: RAISE Okc_Api.G_EXCEPTION_ERROR;
1937: END IF;
1938: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1939: EXCEPTION
1940: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1941: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1942: (

Line 1940: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1936: RAISE Okc_Api.G_EXCEPTION_ERROR;
1937: END IF;
1938: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1939: EXCEPTION
1940: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1941: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1942: (
1943: l_api_name,
1944: G_PKG_NAME,

Line 1941: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1937: END IF;
1938: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1939: EXCEPTION
1940: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1941: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1942: (
1943: l_api_name,
1944: G_PKG_NAME,
1945: 'OKC_API.G_RET_STS_ERROR',

Line 1945: 'OKC_API.G_RET_STS_ERROR',

1941: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1942: (
1943: l_api_name,
1944: G_PKG_NAME,
1945: 'OKC_API.G_RET_STS_ERROR',
1946: x_msg_count,
1947: x_msg_data,
1948: '_PVT'
1949: );

Line 1950: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1951: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1947: x_msg_data,
1948: '_PVT'
1949: );
1950: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1951: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1952: (
1953: l_api_name,
1954: G_PKG_NAME,
1955: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1955: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1951: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1952: (
1953: l_api_name,
1954: G_PKG_NAME,
1955: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1956: x_msg_count,
1957: x_msg_data,
1958: '_PVT'
1959: );

Line 1961: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

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

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

1987: FOR UPDATE NOWAIT;
1988:
1989: l_api_version CONSTANT NUMBER := 1;
1990: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';
1991: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1992: l_lock_var lock_csr%ROWTYPE;
1993: l_row_notfound BOOLEAN := FALSE;
1994: lc_row_notfound BOOLEAN := FALSE;
1995: BEGIN

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

1992: l_lock_var lock_csr%ROWTYPE;
1993: l_row_notfound BOOLEAN := FALSE;
1994: lc_row_notfound BOOLEAN := FALSE;
1995: BEGIN
1996: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1997: p_init_msg_list,
1998: '_PVT',
1999: x_return_status);
2000: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

1996: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1997: p_init_msg_list,
1998: '_PVT',
1999: x_return_status);
2000: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2001: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2002: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2003: RAISE Okc_Api.G_EXCEPTION_ERROR;
2004: END IF;

Line 2001: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1997: p_init_msg_list,
1998: '_PVT',
1999: x_return_status);
2000: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2001: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2002: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2003: RAISE Okc_Api.G_EXCEPTION_ERROR;
2004: END IF;
2005: BEGIN

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

1998: '_PVT',
1999: x_return_status);
2000: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2001: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2002: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2003: RAISE Okc_Api.G_EXCEPTION_ERROR;
2004: END IF;
2005: BEGIN
2006: OPEN lock_csr(p_okl_cnsld_ar_hdrs_tl_rec);

Line 2003: RAISE Okc_Api.G_EXCEPTION_ERROR;

1999: x_return_status);
2000: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2001: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2002: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2003: RAISE Okc_Api.G_EXCEPTION_ERROR;
2004: END IF;
2005: BEGIN
2006: OPEN lock_csr(p_okl_cnsld_ar_hdrs_tl_rec);
2007: FETCH lock_csr INTO l_lock_var;

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

2011: WHEN E_Resource_Busy THEN
2012: IF (lock_csr%ISOPEN) THEN
2013: CLOSE lock_csr;
2014: END IF;
2015: Okc_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
2016: RAISE App_Exceptions.RECORD_LOCK_EXCEPTION;
2017: END;
2018:
2019: IF ( l_row_notfound ) THEN

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

2016: RAISE App_Exceptions.RECORD_LOCK_EXCEPTION;
2017: END;
2018:
2019: IF ( l_row_notfound ) THEN
2020: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
2021: RAISE Okc_Api.G_EXCEPTION_ERROR;
2022: END IF;
2023: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2024: EXCEPTION

Line 2021: RAISE Okc_Api.G_EXCEPTION_ERROR;

2017: END;
2018:
2019: IF ( l_row_notfound ) THEN
2020: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
2021: RAISE Okc_Api.G_EXCEPTION_ERROR;
2022: END IF;
2023: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2024: EXCEPTION
2025: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

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

2019: IF ( l_row_notfound ) THEN
2020: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
2021: RAISE Okc_Api.G_EXCEPTION_ERROR;
2022: END IF;
2023: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2024: EXCEPTION
2025: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2026: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2027: (

Line 2025: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2021: RAISE Okc_Api.G_EXCEPTION_ERROR;
2022: END IF;
2023: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2024: EXCEPTION
2025: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2026: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2027: (
2028: l_api_name,
2029: G_PKG_NAME,

Line 2026: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2022: END IF;
2023: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2024: EXCEPTION
2025: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2026: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2027: (
2028: l_api_name,
2029: G_PKG_NAME,
2030: 'OKC_API.G_RET_STS_ERROR',

Line 2030: 'OKC_API.G_RET_STS_ERROR',

2026: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2027: (
2028: l_api_name,
2029: G_PKG_NAME,
2030: 'OKC_API.G_RET_STS_ERROR',
2031: x_msg_count,
2032: x_msg_data,
2033: '_PVT'
2034: );

Line 2035: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2031: x_msg_count,
2032: x_msg_data,
2033: '_PVT'
2034: );
2035: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2036: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2037: (
2038: l_api_name,
2039: G_PKG_NAME,

Line 2036: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2032: x_msg_data,
2033: '_PVT'
2034: );
2035: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2036: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2037: (
2038: l_api_name,
2039: G_PKG_NAME,
2040: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2040: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2036: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2037: (
2038: l_api_name,
2039: G_PKG_NAME,
2040: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2041: x_msg_count,
2042: x_msg_data,
2043: '_PVT'
2044: );

Line 2046: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2042: x_msg_data,
2043: '_PVT'
2044: );
2045: WHEN OTHERS THEN
2046: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2047: (
2048: l_api_name,
2049: G_PKG_NAME,
2050: 'OTHERS',

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

2065: p_cnrv_rec IN cnrv_rec_type) IS
2066:
2067: l_api_version CONSTANT NUMBER := 1;
2068: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
2069: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2070: l_cnr_rec cnr_rec_type;
2071: l_okl_cnsld_ar_hdrs_tl_rec okl_cnsld_ar_hdrs_tl_rec_type;
2072: BEGIN
2073: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

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

2069: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2070: l_cnr_rec cnr_rec_type;
2071: l_okl_cnsld_ar_hdrs_tl_rec okl_cnsld_ar_hdrs_tl_rec_type;
2072: BEGIN
2073: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2074: G_PKG_NAME,
2075: p_init_msg_list,
2076: l_api_version,
2077: p_api_version,

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

2076: l_api_version,
2077: p_api_version,
2078: '_PVT',
2079: x_return_status);
2080: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2081: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2082: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2083: RAISE Okc_Api.G_EXCEPTION_ERROR;
2084: END IF;

Line 2081: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2077: p_api_version,
2078: '_PVT',
2079: x_return_status);
2080: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2081: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2082: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2083: RAISE Okc_Api.G_EXCEPTION_ERROR;
2084: END IF;
2085: --------------------------------------

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

2078: '_PVT',
2079: x_return_status);
2080: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2081: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2082: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2083: RAISE Okc_Api.G_EXCEPTION_ERROR;
2084: END IF;
2085: --------------------------------------
2086: -- Move VIEW record to "Child" records

Line 2083: RAISE Okc_Api.G_EXCEPTION_ERROR;

2079: x_return_status);
2080: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2081: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2082: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2083: RAISE Okc_Api.G_EXCEPTION_ERROR;
2084: END IF;
2085: --------------------------------------
2086: -- Move VIEW record to "Child" records
2087: --------------------------------------

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

2096: x_msg_count,
2097: x_msg_data,
2098: l_cnr_rec
2099: );
2100: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2101: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2102: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2103: RAISE Okc_Api.G_EXCEPTION_ERROR;
2104: END IF;

Line 2101: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2097: x_msg_data,
2098: l_cnr_rec
2099: );
2100: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2101: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2102: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2103: RAISE Okc_Api.G_EXCEPTION_ERROR;
2104: END IF;
2105: lock_row(

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

2098: l_cnr_rec
2099: );
2100: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2101: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2102: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2103: RAISE Okc_Api.G_EXCEPTION_ERROR;
2104: END IF;
2105: lock_row(
2106: p_init_msg_list,

Line 2103: RAISE Okc_Api.G_EXCEPTION_ERROR;

2099: );
2100: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2101: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2102: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2103: RAISE Okc_Api.G_EXCEPTION_ERROR;
2104: END IF;
2105: lock_row(
2106: p_init_msg_list,
2107: x_return_status,

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

2108: x_msg_count,
2109: x_msg_data,
2110: l_okl_cnsld_ar_hdrs_tl_rec
2111: );
2112: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2113: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2114: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2115: RAISE Okc_Api.G_EXCEPTION_ERROR;
2116: END IF;

Line 2113: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2109: x_msg_data,
2110: l_okl_cnsld_ar_hdrs_tl_rec
2111: );
2112: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2113: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2114: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2115: RAISE Okc_Api.G_EXCEPTION_ERROR;
2116: END IF;
2117: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

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

2110: l_okl_cnsld_ar_hdrs_tl_rec
2111: );
2112: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2113: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2114: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2115: RAISE Okc_Api.G_EXCEPTION_ERROR;
2116: END IF;
2117: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2118: EXCEPTION

Line 2115: RAISE Okc_Api.G_EXCEPTION_ERROR;

2111: );
2112: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2113: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2114: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2115: RAISE Okc_Api.G_EXCEPTION_ERROR;
2116: END IF;
2117: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2118: EXCEPTION
2119: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

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

2113: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2114: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2115: RAISE Okc_Api.G_EXCEPTION_ERROR;
2116: END IF;
2117: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2118: EXCEPTION
2119: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2120: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2121: (

Line 2119: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2115: RAISE Okc_Api.G_EXCEPTION_ERROR;
2116: END IF;
2117: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2118: EXCEPTION
2119: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2120: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2121: (
2122: l_api_name,
2123: G_PKG_NAME,

Line 2120: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2116: END IF;
2117: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2118: EXCEPTION
2119: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2120: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2121: (
2122: l_api_name,
2123: G_PKG_NAME,
2124: 'OKC_API.G_RET_STS_ERROR',

Line 2124: 'OKC_API.G_RET_STS_ERROR',

2120: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2121: (
2122: l_api_name,
2123: G_PKG_NAME,
2124: 'OKC_API.G_RET_STS_ERROR',
2125: x_msg_count,
2126: x_msg_data,
2127: '_PVT'
2128: );

Line 2129: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2125: x_msg_count,
2126: x_msg_data,
2127: '_PVT'
2128: );
2129: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2130: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2131: (
2132: l_api_name,
2133: G_PKG_NAME,

Line 2130: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2126: x_msg_data,
2127: '_PVT'
2128: );
2129: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2130: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2131: (
2132: l_api_name,
2133: G_PKG_NAME,
2134: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2134: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2130: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2131: (
2132: l_api_name,
2133: G_PKG_NAME,
2134: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2135: x_msg_count,
2136: x_msg_data,
2137: '_PVT'
2138: );

Line 2140: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2136: x_msg_data,
2137: '_PVT'
2138: );
2139: WHEN OTHERS THEN
2140: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2141: (
2142: l_api_name,
2143: G_PKG_NAME,
2144: 'OTHERS',

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

2159: p_cnrv_tbl IN cnrv_tbl_type) IS
2160:
2161: l_api_version CONSTANT NUMBER := 1;
2162: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2163: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2164: i NUMBER := 0;
2165: BEGIN
2166: Okc_Api.init_msg_list(p_init_msg_list);
2167: -- Make sure PL/SQL table has records in it before passing

Line 2166: Okc_Api.init_msg_list(p_init_msg_list);

2162: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2163: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2164: i NUMBER := 0;
2165: BEGIN
2166: Okc_Api.init_msg_list(p_init_msg_list);
2167: -- Make sure PL/SQL table has records in it before passing
2168: IF (p_cnrv_tbl.COUNT > 0) THEN
2169: i := p_cnrv_tbl.FIRST;
2170: LOOP

Line 2173: p_init_msg_list => Okc_Api.G_FALSE,

2169: i := p_cnrv_tbl.FIRST;
2170: LOOP
2171: lock_row (
2172: p_api_version => p_api_version,
2173: p_init_msg_list => Okc_Api.G_FALSE,
2174: x_return_status => x_return_status,
2175: x_msg_count => x_msg_count,
2176: x_msg_data => x_msg_data,
2177: p_cnrv_rec => p_cnrv_tbl(i));

Line 2183: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2179: i := p_cnrv_tbl.NEXT(i);
2180: END LOOP;
2181: END IF;
2182: EXCEPTION
2183: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2184: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2185: (
2186: l_api_name,
2187: G_PKG_NAME,

Line 2184: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2180: END LOOP;
2181: END IF;
2182: EXCEPTION
2183: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2184: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2185: (
2186: l_api_name,
2187: G_PKG_NAME,
2188: 'OKC_API.G_RET_STS_ERROR',

Line 2188: 'OKC_API.G_RET_STS_ERROR',

2184: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2185: (
2186: l_api_name,
2187: G_PKG_NAME,
2188: 'OKC_API.G_RET_STS_ERROR',
2189: x_msg_count,
2190: x_msg_data,
2191: '_PVT'
2192: );

Line 2193: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2189: x_msg_count,
2190: x_msg_data,
2191: '_PVT'
2192: );
2193: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2194: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2195: (
2196: l_api_name,
2197: G_PKG_NAME,

Line 2194: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2190: x_msg_data,
2191: '_PVT'
2192: );
2193: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2194: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2195: (
2196: l_api_name,
2197: G_PKG_NAME,
2198: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2198: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2194: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2195: (
2196: l_api_name,
2197: G_PKG_NAME,
2198: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2199: x_msg_count,
2200: x_msg_data,
2201: '_PVT'
2202: );

Line 2204: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2200: x_msg_data,
2201: '_PVT'
2202: );
2203: WHEN OTHERS THEN
2204: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2205: (
2206: l_api_name,
2207: G_PKG_NAME,
2208: 'OTHERS',

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

2227: x_cnr_rec OUT NOCOPY cnr_rec_type) IS
2228:
2229: l_api_version CONSTANT NUMBER := 1;
2230: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
2231: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2232: l_cnr_rec cnr_rec_type := p_cnr_rec;
2233: l_def_cnr_rec cnr_rec_type;
2234: l_row_notfound BOOLEAN := TRUE;
2235: ----------------------------------

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

2240: x_cnr_rec OUT NOCOPY cnr_rec_type
2241: ) RETURN VARCHAR2 IS
2242: l_cnr_rec cnr_rec_type;
2243: l_row_notfound BOOLEAN := TRUE;
2244: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2245: BEGIN
2246: x_cnr_rec := p_cnr_rec;
2247: -- Get current database values
2248: l_cnr_rec := get_rec(p_cnr_rec, l_row_notfound);

Line 2250: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

2246: x_cnr_rec := p_cnr_rec;
2247: -- Get current database values
2248: l_cnr_rec := get_rec(p_cnr_rec, l_row_notfound);
2249: IF (l_row_notfound) THEN
2250: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2251: END IF;
2252: IF (x_cnr_rec.id = Okc_Api.G_MISS_NUM)
2253: THEN
2254: x_cnr_rec.id := l_cnr_rec.id;

Line 2252: IF (x_cnr_rec.id = Okc_Api.G_MISS_NUM)

2248: l_cnr_rec := get_rec(p_cnr_rec, l_row_notfound);
2249: IF (l_row_notfound) THEN
2250: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2251: END IF;
2252: IF (x_cnr_rec.id = Okc_Api.G_MISS_NUM)
2253: THEN
2254: x_cnr_rec.id := l_cnr_rec.id;
2255: END IF;
2256: IF (x_cnr_rec.consolidated_invoice_number = Okc_Api.G_MISS_CHAR)

Line 2256: IF (x_cnr_rec.consolidated_invoice_number = Okc_Api.G_MISS_CHAR)

2252: IF (x_cnr_rec.id = Okc_Api.G_MISS_NUM)
2253: THEN
2254: x_cnr_rec.id := l_cnr_rec.id;
2255: END IF;
2256: IF (x_cnr_rec.consolidated_invoice_number = Okc_Api.G_MISS_CHAR)
2257: THEN
2258: x_cnr_rec.consolidated_invoice_number := l_cnr_rec.consolidated_invoice_number;
2259: END IF;
2260: IF (x_cnr_rec.trx_status_code = Okc_Api.G_MISS_CHAR)

Line 2260: IF (x_cnr_rec.trx_status_code = Okc_Api.G_MISS_CHAR)

2256: IF (x_cnr_rec.consolidated_invoice_number = Okc_Api.G_MISS_CHAR)
2257: THEN
2258: x_cnr_rec.consolidated_invoice_number := l_cnr_rec.consolidated_invoice_number;
2259: END IF;
2260: IF (x_cnr_rec.trx_status_code = Okc_Api.G_MISS_CHAR)
2261: THEN
2262: x_cnr_rec.trx_status_code := l_cnr_rec.trx_status_code;
2263: END IF;
2264: IF (x_cnr_rec.currency_code = Okc_Api.G_MISS_CHAR)

Line 2264: IF (x_cnr_rec.currency_code = Okc_Api.G_MISS_CHAR)

2260: IF (x_cnr_rec.trx_status_code = Okc_Api.G_MISS_CHAR)
2261: THEN
2262: x_cnr_rec.trx_status_code := l_cnr_rec.trx_status_code;
2263: END IF;
2264: IF (x_cnr_rec.currency_code = Okc_Api.G_MISS_CHAR)
2265: THEN
2266: x_cnr_rec.currency_code := l_cnr_rec.currency_code;
2267: END IF;
2268: IF (x_cnr_rec.set_of_books_id = Okc_Api.G_MISS_NUM)

Line 2268: IF (x_cnr_rec.set_of_books_id = Okc_Api.G_MISS_NUM)

2264: IF (x_cnr_rec.currency_code = Okc_Api.G_MISS_CHAR)
2265: THEN
2266: x_cnr_rec.currency_code := l_cnr_rec.currency_code;
2267: END IF;
2268: IF (x_cnr_rec.set_of_books_id = Okc_Api.G_MISS_NUM)
2269: THEN
2270: x_cnr_rec.set_of_books_id := l_cnr_rec.set_of_books_id;
2271: END IF;
2272: IF (x_cnr_rec.ibt_id = Okc_Api.G_MISS_NUM)

Line 2272: IF (x_cnr_rec.ibt_id = Okc_Api.G_MISS_NUM)

2268: IF (x_cnr_rec.set_of_books_id = Okc_Api.G_MISS_NUM)
2269: THEN
2270: x_cnr_rec.set_of_books_id := l_cnr_rec.set_of_books_id;
2271: END IF;
2272: IF (x_cnr_rec.ibt_id = Okc_Api.G_MISS_NUM)
2273: THEN
2274: x_cnr_rec.ibt_id := l_cnr_rec.ibt_id;
2275: END IF;
2276: IF (x_cnr_rec.ixx_id = Okc_Api.G_MISS_NUM)

Line 2276: IF (x_cnr_rec.ixx_id = Okc_Api.G_MISS_NUM)

2272: IF (x_cnr_rec.ibt_id = Okc_Api.G_MISS_NUM)
2273: THEN
2274: x_cnr_rec.ibt_id := l_cnr_rec.ibt_id;
2275: END IF;
2276: IF (x_cnr_rec.ixx_id = Okc_Api.G_MISS_NUM)
2277: THEN
2278: x_cnr_rec.ixx_id := l_cnr_rec.ixx_id;
2279: END IF;
2280: IF (x_cnr_rec.irm_id = Okc_Api.G_MISS_NUM)

Line 2280: IF (x_cnr_rec.irm_id = Okc_Api.G_MISS_NUM)

2276: IF (x_cnr_rec.ixx_id = Okc_Api.G_MISS_NUM)
2277: THEN
2278: x_cnr_rec.ixx_id := l_cnr_rec.ixx_id;
2279: END IF;
2280: IF (x_cnr_rec.irm_id = Okc_Api.G_MISS_NUM)
2281: THEN
2282: x_cnr_rec.irm_id := l_cnr_rec.irm_id;
2283: END IF;
2284: IF (x_cnr_rec.inf_id = Okc_Api.G_MISS_NUM)

Line 2284: IF (x_cnr_rec.inf_id = Okc_Api.G_MISS_NUM)

2280: IF (x_cnr_rec.irm_id = Okc_Api.G_MISS_NUM)
2281: THEN
2282: x_cnr_rec.irm_id := l_cnr_rec.irm_id;
2283: END IF;
2284: IF (x_cnr_rec.inf_id = Okc_Api.G_MISS_NUM)
2285: THEN
2286: x_cnr_rec.inf_id := l_cnr_rec.inf_id;
2287: END IF;
2288: IF (x_cnr_rec.amount = Okc_Api.G_MISS_NUM)

Line 2288: IF (x_cnr_rec.amount = Okc_Api.G_MISS_NUM)

2284: IF (x_cnr_rec.inf_id = Okc_Api.G_MISS_NUM)
2285: THEN
2286: x_cnr_rec.inf_id := l_cnr_rec.inf_id;
2287: END IF;
2288: IF (x_cnr_rec.amount = Okc_Api.G_MISS_NUM)
2289: THEN
2290: x_cnr_rec.amount := l_cnr_rec.amount;
2291: END IF;
2292: IF (x_cnr_rec.date_consolidated = Okc_Api.G_MISS_DATE)

Line 2292: IF (x_cnr_rec.date_consolidated = Okc_Api.G_MISS_DATE)

2288: IF (x_cnr_rec.amount = Okc_Api.G_MISS_NUM)
2289: THEN
2290: x_cnr_rec.amount := l_cnr_rec.amount;
2291: END IF;
2292: IF (x_cnr_rec.date_consolidated = Okc_Api.G_MISS_DATE)
2293: THEN
2294: x_cnr_rec.date_consolidated := l_cnr_rec.date_consolidated;
2295: END IF;
2296: IF (x_cnr_rec.invoice_pull_yn = Okc_Api.G_MISS_CHAR)

Line 2296: IF (x_cnr_rec.invoice_pull_yn = Okc_Api.G_MISS_CHAR)

2292: IF (x_cnr_rec.date_consolidated = Okc_Api.G_MISS_DATE)
2293: THEN
2294: x_cnr_rec.date_consolidated := l_cnr_rec.date_consolidated;
2295: END IF;
2296: IF (x_cnr_rec.invoice_pull_yn = Okc_Api.G_MISS_CHAR)
2297: THEN
2298: x_cnr_rec.invoice_pull_yn := l_cnr_rec.invoice_pull_yn;
2299: END IF;
2300: IF (x_cnr_rec.object_version_number = Okc_Api.G_MISS_NUM)

Line 2300: IF (x_cnr_rec.object_version_number = Okc_Api.G_MISS_NUM)

2296: IF (x_cnr_rec.invoice_pull_yn = Okc_Api.G_MISS_CHAR)
2297: THEN
2298: x_cnr_rec.invoice_pull_yn := l_cnr_rec.invoice_pull_yn;
2299: END IF;
2300: IF (x_cnr_rec.object_version_number = Okc_Api.G_MISS_NUM)
2301: THEN
2302: x_cnr_rec.object_version_number := l_cnr_rec.object_version_number;
2303: END IF;
2304: IF (x_cnr_rec.request_id = Okc_Api.G_MISS_NUM)

Line 2304: IF (x_cnr_rec.request_id = Okc_Api.G_MISS_NUM)

2300: IF (x_cnr_rec.object_version_number = Okc_Api.G_MISS_NUM)
2301: THEN
2302: x_cnr_rec.object_version_number := l_cnr_rec.object_version_number;
2303: END IF;
2304: IF (x_cnr_rec.request_id = Okc_Api.G_MISS_NUM)
2305: THEN
2306: x_cnr_rec.request_id := l_cnr_rec.request_id;
2307: END IF;
2308: IF (x_cnr_rec.program_application_id = Okc_Api.G_MISS_NUM)

Line 2308: IF (x_cnr_rec.program_application_id = Okc_Api.G_MISS_NUM)

2304: IF (x_cnr_rec.request_id = Okc_Api.G_MISS_NUM)
2305: THEN
2306: x_cnr_rec.request_id := l_cnr_rec.request_id;
2307: END IF;
2308: IF (x_cnr_rec.program_application_id = Okc_Api.G_MISS_NUM)
2309: THEN
2310: x_cnr_rec.program_application_id := l_cnr_rec.program_application_id;
2311: END IF;
2312: IF (x_cnr_rec.program_id = Okc_Api.G_MISS_NUM)

Line 2312: IF (x_cnr_rec.program_id = Okc_Api.G_MISS_NUM)

2308: IF (x_cnr_rec.program_application_id = Okc_Api.G_MISS_NUM)
2309: THEN
2310: x_cnr_rec.program_application_id := l_cnr_rec.program_application_id;
2311: END IF;
2312: IF (x_cnr_rec.program_id = Okc_Api.G_MISS_NUM)
2313: THEN
2314: x_cnr_rec.program_id := l_cnr_rec.program_id;
2315: END IF;
2316: IF (x_cnr_rec.program_update_date = Okc_Api.G_MISS_DATE)

Line 2316: IF (x_cnr_rec.program_update_date = Okc_Api.G_MISS_DATE)

2312: IF (x_cnr_rec.program_id = Okc_Api.G_MISS_NUM)
2313: THEN
2314: x_cnr_rec.program_id := l_cnr_rec.program_id;
2315: END IF;
2316: IF (x_cnr_rec.program_update_date = Okc_Api.G_MISS_DATE)
2317: THEN
2318: x_cnr_rec.program_update_date := l_cnr_rec.program_update_date;
2319: END IF;
2320: IF (x_cnr_rec.org_id = Okc_Api.G_MISS_NUM)

Line 2320: IF (x_cnr_rec.org_id = Okc_Api.G_MISS_NUM)

2316: IF (x_cnr_rec.program_update_date = Okc_Api.G_MISS_DATE)
2317: THEN
2318: x_cnr_rec.program_update_date := l_cnr_rec.program_update_date;
2319: END IF;
2320: IF (x_cnr_rec.org_id = Okc_Api.G_MISS_NUM)
2321: THEN
2322: x_cnr_rec.org_id := l_cnr_rec.org_id;
2323: END IF;
2324: IF (x_cnr_rec.due_date = Okc_Api.G_MISS_DATE)

Line 2324: IF (x_cnr_rec.due_date = Okc_Api.G_MISS_DATE)

2320: IF (x_cnr_rec.org_id = Okc_Api.G_MISS_NUM)
2321: THEN
2322: x_cnr_rec.org_id := l_cnr_rec.org_id;
2323: END IF;
2324: IF (x_cnr_rec.due_date = Okc_Api.G_MISS_DATE)
2325: THEN
2326: x_cnr_rec.due_date := l_cnr_rec.due_date;
2327: END IF;
2328: IF (x_cnr_rec.attribute_category = Okc_Api.G_MISS_CHAR)

Line 2328: IF (x_cnr_rec.attribute_category = Okc_Api.G_MISS_CHAR)

2324: IF (x_cnr_rec.due_date = Okc_Api.G_MISS_DATE)
2325: THEN
2326: x_cnr_rec.due_date := l_cnr_rec.due_date;
2327: END IF;
2328: IF (x_cnr_rec.attribute_category = Okc_Api.G_MISS_CHAR)
2329: THEN
2330: x_cnr_rec.attribute_category := l_cnr_rec.attribute_category;
2331: END IF;
2332: IF (x_cnr_rec.attribute1 = Okc_Api.G_MISS_CHAR)

Line 2332: IF (x_cnr_rec.attribute1 = Okc_Api.G_MISS_CHAR)

2328: IF (x_cnr_rec.attribute_category = Okc_Api.G_MISS_CHAR)
2329: THEN
2330: x_cnr_rec.attribute_category := l_cnr_rec.attribute_category;
2331: END IF;
2332: IF (x_cnr_rec.attribute1 = Okc_Api.G_MISS_CHAR)
2333: THEN
2334: x_cnr_rec.attribute1 := l_cnr_rec.attribute1;
2335: END IF;
2336: IF (x_cnr_rec.attribute2 = Okc_Api.G_MISS_CHAR)

Line 2336: IF (x_cnr_rec.attribute2 = Okc_Api.G_MISS_CHAR)

2332: IF (x_cnr_rec.attribute1 = Okc_Api.G_MISS_CHAR)
2333: THEN
2334: x_cnr_rec.attribute1 := l_cnr_rec.attribute1;
2335: END IF;
2336: IF (x_cnr_rec.attribute2 = Okc_Api.G_MISS_CHAR)
2337: THEN
2338: x_cnr_rec.attribute2 := l_cnr_rec.attribute2;
2339: END IF;
2340: IF (x_cnr_rec.attribute3 = Okc_Api.G_MISS_CHAR)

Line 2340: IF (x_cnr_rec.attribute3 = Okc_Api.G_MISS_CHAR)

2336: IF (x_cnr_rec.attribute2 = Okc_Api.G_MISS_CHAR)
2337: THEN
2338: x_cnr_rec.attribute2 := l_cnr_rec.attribute2;
2339: END IF;
2340: IF (x_cnr_rec.attribute3 = Okc_Api.G_MISS_CHAR)
2341: THEN
2342: x_cnr_rec.attribute3 := l_cnr_rec.attribute3;
2343: END IF;
2344: IF (x_cnr_rec.attribute4 = Okc_Api.G_MISS_CHAR)

Line 2344: IF (x_cnr_rec.attribute4 = Okc_Api.G_MISS_CHAR)

2340: IF (x_cnr_rec.attribute3 = Okc_Api.G_MISS_CHAR)
2341: THEN
2342: x_cnr_rec.attribute3 := l_cnr_rec.attribute3;
2343: END IF;
2344: IF (x_cnr_rec.attribute4 = Okc_Api.G_MISS_CHAR)
2345: THEN
2346: x_cnr_rec.attribute4 := l_cnr_rec.attribute4;
2347: END IF;
2348: IF (x_cnr_rec.attribute5 = Okc_Api.G_MISS_CHAR)

Line 2348: IF (x_cnr_rec.attribute5 = Okc_Api.G_MISS_CHAR)

2344: IF (x_cnr_rec.attribute4 = Okc_Api.G_MISS_CHAR)
2345: THEN
2346: x_cnr_rec.attribute4 := l_cnr_rec.attribute4;
2347: END IF;
2348: IF (x_cnr_rec.attribute5 = Okc_Api.G_MISS_CHAR)
2349: THEN
2350: x_cnr_rec.attribute5 := l_cnr_rec.attribute5;
2351: END IF;
2352: IF (x_cnr_rec.attribute6 = Okc_Api.G_MISS_CHAR)

Line 2352: IF (x_cnr_rec.attribute6 = Okc_Api.G_MISS_CHAR)

2348: IF (x_cnr_rec.attribute5 = Okc_Api.G_MISS_CHAR)
2349: THEN
2350: x_cnr_rec.attribute5 := l_cnr_rec.attribute5;
2351: END IF;
2352: IF (x_cnr_rec.attribute6 = Okc_Api.G_MISS_CHAR)
2353: THEN
2354: x_cnr_rec.attribute6 := l_cnr_rec.attribute6;
2355: END IF;
2356: IF (x_cnr_rec.attribute7 = Okc_Api.G_MISS_CHAR)

Line 2356: IF (x_cnr_rec.attribute7 = Okc_Api.G_MISS_CHAR)

2352: IF (x_cnr_rec.attribute6 = Okc_Api.G_MISS_CHAR)
2353: THEN
2354: x_cnr_rec.attribute6 := l_cnr_rec.attribute6;
2355: END IF;
2356: IF (x_cnr_rec.attribute7 = Okc_Api.G_MISS_CHAR)
2357: THEN
2358: x_cnr_rec.attribute7 := l_cnr_rec.attribute7;
2359: END IF;
2360: IF (x_cnr_rec.attribute8 = Okc_Api.G_MISS_CHAR)

Line 2360: IF (x_cnr_rec.attribute8 = Okc_Api.G_MISS_CHAR)

2356: IF (x_cnr_rec.attribute7 = Okc_Api.G_MISS_CHAR)
2357: THEN
2358: x_cnr_rec.attribute7 := l_cnr_rec.attribute7;
2359: END IF;
2360: IF (x_cnr_rec.attribute8 = Okc_Api.G_MISS_CHAR)
2361: THEN
2362: x_cnr_rec.attribute8 := l_cnr_rec.attribute8;
2363: END IF;
2364: IF (x_cnr_rec.attribute9 = Okc_Api.G_MISS_CHAR)

Line 2364: IF (x_cnr_rec.attribute9 = Okc_Api.G_MISS_CHAR)

2360: IF (x_cnr_rec.attribute8 = Okc_Api.G_MISS_CHAR)
2361: THEN
2362: x_cnr_rec.attribute8 := l_cnr_rec.attribute8;
2363: END IF;
2364: IF (x_cnr_rec.attribute9 = Okc_Api.G_MISS_CHAR)
2365: THEN
2366: x_cnr_rec.attribute9 := l_cnr_rec.attribute9;
2367: END IF;
2368: IF (x_cnr_rec.attribute10 = Okc_Api.G_MISS_CHAR)

Line 2368: IF (x_cnr_rec.attribute10 = Okc_Api.G_MISS_CHAR)

2364: IF (x_cnr_rec.attribute9 = Okc_Api.G_MISS_CHAR)
2365: THEN
2366: x_cnr_rec.attribute9 := l_cnr_rec.attribute9;
2367: END IF;
2368: IF (x_cnr_rec.attribute10 = Okc_Api.G_MISS_CHAR)
2369: THEN
2370: x_cnr_rec.attribute10 := l_cnr_rec.attribute10;
2371: END IF;
2372: IF (x_cnr_rec.attribute11 = Okc_Api.G_MISS_CHAR)

Line 2372: IF (x_cnr_rec.attribute11 = Okc_Api.G_MISS_CHAR)

2368: IF (x_cnr_rec.attribute10 = Okc_Api.G_MISS_CHAR)
2369: THEN
2370: x_cnr_rec.attribute10 := l_cnr_rec.attribute10;
2371: END IF;
2372: IF (x_cnr_rec.attribute11 = Okc_Api.G_MISS_CHAR)
2373: THEN
2374: x_cnr_rec.attribute11 := l_cnr_rec.attribute11;
2375: END IF;
2376: IF (x_cnr_rec.attribute12 = Okc_Api.G_MISS_CHAR)

Line 2376: IF (x_cnr_rec.attribute12 = Okc_Api.G_MISS_CHAR)

2372: IF (x_cnr_rec.attribute11 = Okc_Api.G_MISS_CHAR)
2373: THEN
2374: x_cnr_rec.attribute11 := l_cnr_rec.attribute11;
2375: END IF;
2376: IF (x_cnr_rec.attribute12 = Okc_Api.G_MISS_CHAR)
2377: THEN
2378: x_cnr_rec.attribute12 := l_cnr_rec.attribute12;
2379: END IF;
2380: IF (x_cnr_rec.attribute13 = Okc_Api.G_MISS_CHAR)

Line 2380: IF (x_cnr_rec.attribute13 = Okc_Api.G_MISS_CHAR)

2376: IF (x_cnr_rec.attribute12 = Okc_Api.G_MISS_CHAR)
2377: THEN
2378: x_cnr_rec.attribute12 := l_cnr_rec.attribute12;
2379: END IF;
2380: IF (x_cnr_rec.attribute13 = Okc_Api.G_MISS_CHAR)
2381: THEN
2382: x_cnr_rec.attribute13 := l_cnr_rec.attribute13;
2383: END IF;
2384: IF (x_cnr_rec.attribute14 = Okc_Api.G_MISS_CHAR)

Line 2384: IF (x_cnr_rec.attribute14 = Okc_Api.G_MISS_CHAR)

2380: IF (x_cnr_rec.attribute13 = Okc_Api.G_MISS_CHAR)
2381: THEN
2382: x_cnr_rec.attribute13 := l_cnr_rec.attribute13;
2383: END IF;
2384: IF (x_cnr_rec.attribute14 = Okc_Api.G_MISS_CHAR)
2385: THEN
2386: x_cnr_rec.attribute14 := l_cnr_rec.attribute14;
2387: END IF;
2388: IF (x_cnr_rec.attribute15 = Okc_Api.G_MISS_CHAR)

Line 2388: IF (x_cnr_rec.attribute15 = Okc_Api.G_MISS_CHAR)

2384: IF (x_cnr_rec.attribute14 = Okc_Api.G_MISS_CHAR)
2385: THEN
2386: x_cnr_rec.attribute14 := l_cnr_rec.attribute14;
2387: END IF;
2388: IF (x_cnr_rec.attribute15 = Okc_Api.G_MISS_CHAR)
2389: THEN
2390: x_cnr_rec.attribute15 := l_cnr_rec.attribute15;
2391: END IF;
2392: IF (x_cnr_rec.created_by = Okc_Api.G_MISS_NUM)

Line 2392: IF (x_cnr_rec.created_by = Okc_Api.G_MISS_NUM)

2388: IF (x_cnr_rec.attribute15 = Okc_Api.G_MISS_CHAR)
2389: THEN
2390: x_cnr_rec.attribute15 := l_cnr_rec.attribute15;
2391: END IF;
2392: IF (x_cnr_rec.created_by = Okc_Api.G_MISS_NUM)
2393: THEN
2394: x_cnr_rec.created_by := l_cnr_rec.created_by;
2395: END IF;
2396: IF (x_cnr_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 2396: IF (x_cnr_rec.creation_date = Okc_Api.G_MISS_DATE)

2392: IF (x_cnr_rec.created_by = Okc_Api.G_MISS_NUM)
2393: THEN
2394: x_cnr_rec.created_by := l_cnr_rec.created_by;
2395: END IF;
2396: IF (x_cnr_rec.creation_date = Okc_Api.G_MISS_DATE)
2397: THEN
2398: x_cnr_rec.creation_date := l_cnr_rec.creation_date;
2399: END IF;
2400: IF (x_cnr_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 2400: IF (x_cnr_rec.last_updated_by = Okc_Api.G_MISS_NUM)

2396: IF (x_cnr_rec.creation_date = Okc_Api.G_MISS_DATE)
2397: THEN
2398: x_cnr_rec.creation_date := l_cnr_rec.creation_date;
2399: END IF;
2400: IF (x_cnr_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2401: THEN
2402: x_cnr_rec.last_updated_by := l_cnr_rec.last_updated_by;
2403: END IF;
2404: IF (x_cnr_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 2404: IF (x_cnr_rec.last_update_date = Okc_Api.G_MISS_DATE)

2400: IF (x_cnr_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2401: THEN
2402: x_cnr_rec.last_updated_by := l_cnr_rec.last_updated_by;
2403: END IF;
2404: IF (x_cnr_rec.last_update_date = Okc_Api.G_MISS_DATE)
2405: THEN
2406: x_cnr_rec.last_update_date := l_cnr_rec.last_update_date;
2407: END IF;
2408: IF (x_cnr_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 2408: IF (x_cnr_rec.last_update_login = Okc_Api.G_MISS_NUM)

2404: IF (x_cnr_rec.last_update_date = Okc_Api.G_MISS_DATE)
2405: THEN
2406: x_cnr_rec.last_update_date := l_cnr_rec.last_update_date;
2407: END IF;
2408: IF (x_cnr_rec.last_update_login = Okc_Api.G_MISS_NUM)
2409: THEN
2410: x_cnr_rec.last_update_login := l_cnr_rec.last_update_login;
2411: END IF;
2412: -- for LE Uptake project 08-11-2006

Line 2413: IF (x_cnr_rec.legal_entity_id = Okc_Api.G_MISS_NUM)

2409: THEN
2410: x_cnr_rec.last_update_login := l_cnr_rec.last_update_login;
2411: END IF;
2412: -- for LE Uptake project 08-11-2006
2413: IF (x_cnr_rec.legal_entity_id = Okc_Api.G_MISS_NUM)
2414: THEN
2415: x_cnr_rec.legal_entity_id := l_cnr_rec.legal_entity_id;
2416: END IF;
2417: -- for LE Uptake project 08-11-2006

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

2423: FUNCTION Set_Attributes (
2424: p_cnr_rec IN cnr_rec_type,
2425: x_cnr_rec OUT NOCOPY cnr_rec_type
2426: ) RETURN VARCHAR2 IS
2427: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2428: BEGIN
2429: x_cnr_rec := p_cnr_rec;
2430: RETURN(l_return_status);
2431: END Set_Attributes;

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

2429: x_cnr_rec := p_cnr_rec;
2430: RETURN(l_return_status);
2431: END Set_Attributes;
2432: BEGIN
2433: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2434: p_init_msg_list,
2435: '_PVT',
2436: x_return_status);
2437: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

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

Line 2438: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2434: p_init_msg_list,
2435: '_PVT',
2436: x_return_status);
2437: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2438: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2439: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2440: RAISE Okc_Api.G_EXCEPTION_ERROR;
2441: END IF;
2442: --- Setting item attributes

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

2435: '_PVT',
2436: x_return_status);
2437: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2438: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2439: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2440: RAISE Okc_Api.G_EXCEPTION_ERROR;
2441: END IF;
2442: --- Setting item attributes
2443: l_return_status := Set_Attributes(

Line 2440: RAISE Okc_Api.G_EXCEPTION_ERROR;

2436: x_return_status);
2437: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2438: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2439: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2440: RAISE Okc_Api.G_EXCEPTION_ERROR;
2441: END IF;
2442: --- Setting item attributes
2443: l_return_status := Set_Attributes(
2444: p_cnr_rec, -- IN

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

2443: l_return_status := Set_Attributes(
2444: p_cnr_rec, -- IN
2445: l_cnr_rec); -- OUT
2446: --- If any errors happen abort API
2447: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2448: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2449: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2450: RAISE Okc_Api.G_EXCEPTION_ERROR;
2451: END IF;

Line 2448: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2444: p_cnr_rec, -- IN
2445: l_cnr_rec); -- OUT
2446: --- If any errors happen abort API
2447: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2448: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2449: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2450: RAISE Okc_Api.G_EXCEPTION_ERROR;
2451: END IF;
2452: l_return_status := populate_new_record(l_cnr_rec, l_def_cnr_rec);

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

2445: l_cnr_rec); -- OUT
2446: --- If any errors happen abort API
2447: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2448: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2449: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2450: RAISE Okc_Api.G_EXCEPTION_ERROR;
2451: END IF;
2452: l_return_status := populate_new_record(l_cnr_rec, l_def_cnr_rec);
2453: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2450: RAISE Okc_Api.G_EXCEPTION_ERROR;

2446: --- If any errors happen abort API
2447: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2448: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2449: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2450: RAISE Okc_Api.G_EXCEPTION_ERROR;
2451: END IF;
2452: l_return_status := populate_new_record(l_cnr_rec, l_def_cnr_rec);
2453: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

2449: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2450: RAISE Okc_Api.G_EXCEPTION_ERROR;
2451: END IF;
2452: l_return_status := populate_new_record(l_cnr_rec, l_def_cnr_rec);
2453: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2455: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2456: RAISE Okc_Api.G_EXCEPTION_ERROR;
2457: END IF;

Line 2454: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2450: RAISE Okc_Api.G_EXCEPTION_ERROR;
2451: END IF;
2452: l_return_status := populate_new_record(l_cnr_rec, l_def_cnr_rec);
2453: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2455: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2456: RAISE Okc_Api.G_EXCEPTION_ERROR;
2457: END IF;
2458: UPDATE OKL_CNSLD_AR_HDRS_B

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

2451: END IF;
2452: l_return_status := populate_new_record(l_cnr_rec, l_def_cnr_rec);
2453: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2455: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2456: RAISE Okc_Api.G_EXCEPTION_ERROR;
2457: END IF;
2458: UPDATE OKL_CNSLD_AR_HDRS_B
2459: SET CONSOLIDATED_INVOICE_NUMBER = l_def_cnr_rec.consolidated_invoice_number,

Line 2456: RAISE Okc_Api.G_EXCEPTION_ERROR;

2452: l_return_status := populate_new_record(l_cnr_rec, l_def_cnr_rec);
2453: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2455: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2456: RAISE Okc_Api.G_EXCEPTION_ERROR;
2457: END IF;
2458: UPDATE OKL_CNSLD_AR_HDRS_B
2459: SET CONSOLIDATED_INVOICE_NUMBER = l_def_cnr_rec.consolidated_invoice_number,
2460: TRX_STATUS_CODE = l_def_cnr_rec.trx_status_code,

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

2498: LEGAL_ENTITY_ID = l_def_cnr_rec.legal_entity_id -- for LE Uptake project 08-11-2006
2499: WHERE ID = l_def_cnr_rec.id;
2500:
2501: x_cnr_rec := l_def_cnr_rec;
2502: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2503: EXCEPTION
2504: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2505: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2506: (

Line 2504: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2500:
2501: x_cnr_rec := l_def_cnr_rec;
2502: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2503: EXCEPTION
2504: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2505: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2506: (
2507: l_api_name,
2508: G_PKG_NAME,

Line 2505: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2501: x_cnr_rec := l_def_cnr_rec;
2502: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2503: EXCEPTION
2504: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2505: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2506: (
2507: l_api_name,
2508: G_PKG_NAME,
2509: 'OKC_API.G_RET_STS_ERROR',

Line 2509: 'OKC_API.G_RET_STS_ERROR',

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

Line 2514: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2515: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

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

Line 2519: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2515: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2516: (
2517: l_api_name,
2518: G_PKG_NAME,
2519: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2520: x_msg_count,
2521: x_msg_data,
2522: '_PVT'
2523: );

Line 2525: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2521: x_msg_data,
2522: '_PVT'
2523: );
2524: WHEN OTHERS THEN
2525: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2526: (
2527: l_api_name,
2528: G_PKG_NAME,
2529: 'OTHERS',

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

2544: x_okl_cnsld_ar_hdrs_tl_rec OUT NOCOPY okl_cnsld_ar_hdrs_tl_rec_type) IS
2545:
2546: l_api_version CONSTANT NUMBER := 1;
2547: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
2548: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2549: l_okl_cnsld_ar_hdrs_tl_rec okl_cnsld_ar_hdrs_tl_rec_type := p_okl_cnsld_ar_hdrs_tl_rec;
2550: ldefoklcnsldarhdrstlrec okl_cnsld_ar_hdrs_tl_rec_type;
2551: l_row_notfound BOOLEAN := TRUE;
2552: ----------------------------------

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

2557: x_okl_cnsld_ar_hdrs_tl_rec OUT NOCOPY okl_cnsld_ar_hdrs_tl_rec_type
2558: ) RETURN VARCHAR2 IS
2559: l_okl_cnsld_ar_hdrs_tl_rec okl_cnsld_ar_hdrs_tl_rec_type;
2560: l_row_notfound BOOLEAN := TRUE;
2561: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2562: BEGIN
2563: x_okl_cnsld_ar_hdrs_tl_rec := p_okl_cnsld_ar_hdrs_tl_rec;
2564: -- Get current database values
2565: l_okl_cnsld_ar_hdrs_tl_rec := get_rec(p_okl_cnsld_ar_hdrs_tl_rec, l_row_notfound);

Line 2567: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

2563: x_okl_cnsld_ar_hdrs_tl_rec := p_okl_cnsld_ar_hdrs_tl_rec;
2564: -- Get current database values
2565: l_okl_cnsld_ar_hdrs_tl_rec := get_rec(p_okl_cnsld_ar_hdrs_tl_rec, l_row_notfound);
2566: IF (l_row_notfound) THEN
2567: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2568: END IF;
2569: IF (x_okl_cnsld_ar_hdrs_tl_rec.id = Okc_Api.G_MISS_NUM)
2570: THEN
2571: x_okl_cnsld_ar_hdrs_tl_rec.id := l_okl_cnsld_ar_hdrs_tl_rec.id;

Line 2569: IF (x_okl_cnsld_ar_hdrs_tl_rec.id = Okc_Api.G_MISS_NUM)

2565: l_okl_cnsld_ar_hdrs_tl_rec := get_rec(p_okl_cnsld_ar_hdrs_tl_rec, l_row_notfound);
2566: IF (l_row_notfound) THEN
2567: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2568: END IF;
2569: IF (x_okl_cnsld_ar_hdrs_tl_rec.id = Okc_Api.G_MISS_NUM)
2570: THEN
2571: x_okl_cnsld_ar_hdrs_tl_rec.id := l_okl_cnsld_ar_hdrs_tl_rec.id;
2572: END IF;
2573: IF (x_okl_cnsld_ar_hdrs_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)

Line 2573: IF (x_okl_cnsld_ar_hdrs_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)

2569: IF (x_okl_cnsld_ar_hdrs_tl_rec.id = Okc_Api.G_MISS_NUM)
2570: THEN
2571: x_okl_cnsld_ar_hdrs_tl_rec.id := l_okl_cnsld_ar_hdrs_tl_rec.id;
2572: END IF;
2573: IF (x_okl_cnsld_ar_hdrs_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2574: THEN
2575: x_okl_cnsld_ar_hdrs_tl_rec.LANGUAGE := l_okl_cnsld_ar_hdrs_tl_rec.LANGUAGE;
2576: END IF;
2577: IF (x_okl_cnsld_ar_hdrs_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)

Line 2577: IF (x_okl_cnsld_ar_hdrs_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)

2573: IF (x_okl_cnsld_ar_hdrs_tl_rec.LANGUAGE = Okc_Api.G_MISS_CHAR)
2574: THEN
2575: x_okl_cnsld_ar_hdrs_tl_rec.LANGUAGE := l_okl_cnsld_ar_hdrs_tl_rec.LANGUAGE;
2576: END IF;
2577: IF (x_okl_cnsld_ar_hdrs_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2578: THEN
2579: x_okl_cnsld_ar_hdrs_tl_rec.source_lang := l_okl_cnsld_ar_hdrs_tl_rec.source_lang;
2580: END IF;
2581: IF (x_okl_cnsld_ar_hdrs_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)

Line 2581: IF (x_okl_cnsld_ar_hdrs_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)

2577: IF (x_okl_cnsld_ar_hdrs_tl_rec.source_lang = Okc_Api.G_MISS_CHAR)
2578: THEN
2579: x_okl_cnsld_ar_hdrs_tl_rec.source_lang := l_okl_cnsld_ar_hdrs_tl_rec.source_lang;
2580: END IF;
2581: IF (x_okl_cnsld_ar_hdrs_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2582: THEN
2583: x_okl_cnsld_ar_hdrs_tl_rec.sfwt_flag := l_okl_cnsld_ar_hdrs_tl_rec.sfwt_flag;
2584: END IF;
2585: IF (x_okl_cnsld_ar_hdrs_tl_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR)

Line 2585: IF (x_okl_cnsld_ar_hdrs_tl_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR)

2581: IF (x_okl_cnsld_ar_hdrs_tl_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2582: THEN
2583: x_okl_cnsld_ar_hdrs_tl_rec.sfwt_flag := l_okl_cnsld_ar_hdrs_tl_rec.sfwt_flag;
2584: END IF;
2585: IF (x_okl_cnsld_ar_hdrs_tl_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR)
2586: THEN
2587: x_okl_cnsld_ar_hdrs_tl_rec.private_label_logo_url := l_okl_cnsld_ar_hdrs_tl_rec.private_label_logo_url;
2588: END IF;
2589: IF (x_okl_cnsld_ar_hdrs_tl_rec.created_by = Okc_Api.G_MISS_NUM)

Line 2589: IF (x_okl_cnsld_ar_hdrs_tl_rec.created_by = Okc_Api.G_MISS_NUM)

2585: IF (x_okl_cnsld_ar_hdrs_tl_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR)
2586: THEN
2587: x_okl_cnsld_ar_hdrs_tl_rec.private_label_logo_url := l_okl_cnsld_ar_hdrs_tl_rec.private_label_logo_url;
2588: END IF;
2589: IF (x_okl_cnsld_ar_hdrs_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2590: THEN
2591: x_okl_cnsld_ar_hdrs_tl_rec.created_by := l_okl_cnsld_ar_hdrs_tl_rec.created_by;
2592: END IF;
2593: IF (x_okl_cnsld_ar_hdrs_tl_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 2593: IF (x_okl_cnsld_ar_hdrs_tl_rec.creation_date = Okc_Api.G_MISS_DATE)

2589: IF (x_okl_cnsld_ar_hdrs_tl_rec.created_by = Okc_Api.G_MISS_NUM)
2590: THEN
2591: x_okl_cnsld_ar_hdrs_tl_rec.created_by := l_okl_cnsld_ar_hdrs_tl_rec.created_by;
2592: END IF;
2593: IF (x_okl_cnsld_ar_hdrs_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2594: THEN
2595: x_okl_cnsld_ar_hdrs_tl_rec.creation_date := l_okl_cnsld_ar_hdrs_tl_rec.creation_date;
2596: END IF;
2597: IF (x_okl_cnsld_ar_hdrs_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 2597: IF (x_okl_cnsld_ar_hdrs_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)

2593: IF (x_okl_cnsld_ar_hdrs_tl_rec.creation_date = Okc_Api.G_MISS_DATE)
2594: THEN
2595: x_okl_cnsld_ar_hdrs_tl_rec.creation_date := l_okl_cnsld_ar_hdrs_tl_rec.creation_date;
2596: END IF;
2597: IF (x_okl_cnsld_ar_hdrs_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2598: THEN
2599: x_okl_cnsld_ar_hdrs_tl_rec.last_updated_by := l_okl_cnsld_ar_hdrs_tl_rec.last_updated_by;
2600: END IF;
2601: IF (x_okl_cnsld_ar_hdrs_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 2601: IF (x_okl_cnsld_ar_hdrs_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)

2597: IF (x_okl_cnsld_ar_hdrs_tl_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2598: THEN
2599: x_okl_cnsld_ar_hdrs_tl_rec.last_updated_by := l_okl_cnsld_ar_hdrs_tl_rec.last_updated_by;
2600: END IF;
2601: IF (x_okl_cnsld_ar_hdrs_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2602: THEN
2603: x_okl_cnsld_ar_hdrs_tl_rec.last_update_date := l_okl_cnsld_ar_hdrs_tl_rec.last_update_date;
2604: END IF;
2605: IF (x_okl_cnsld_ar_hdrs_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 2605: IF (x_okl_cnsld_ar_hdrs_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)

2601: IF (x_okl_cnsld_ar_hdrs_tl_rec.last_update_date = Okc_Api.G_MISS_DATE)
2602: THEN
2603: x_okl_cnsld_ar_hdrs_tl_rec.last_update_date := l_okl_cnsld_ar_hdrs_tl_rec.last_update_date;
2604: END IF;
2605: IF (x_okl_cnsld_ar_hdrs_tl_rec.last_update_login = Okc_Api.G_MISS_NUM)
2606: THEN
2607: x_okl_cnsld_ar_hdrs_tl_rec.last_update_login := l_okl_cnsld_ar_hdrs_tl_rec.last_update_login;
2608: END IF;
2609: RETURN(l_return_status);

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

2614: FUNCTION Set_Attributes (
2615: p_okl_cnsld_ar_hdrs_tl_rec IN okl_cnsld_ar_hdrs_tl_rec_type,
2616: x_okl_cnsld_ar_hdrs_tl_rec OUT NOCOPY okl_cnsld_ar_hdrs_tl_rec_type
2617: ) RETURN VARCHAR2 IS
2618: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2619: BEGIN
2620: x_okl_cnsld_ar_hdrs_tl_rec := p_okl_cnsld_ar_hdrs_tl_rec;
2621: x_okl_cnsld_ar_hdrs_tl_rec.LANGUAGE := USERENV('LANG');
2622: x_okl_cnsld_ar_hdrs_tl_rec.SOURCE_LANG := USERENV('LANG');

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

2622: x_okl_cnsld_ar_hdrs_tl_rec.SOURCE_LANG := USERENV('LANG');
2623: RETURN(l_return_status);
2624: END Set_Attributes;
2625: BEGIN
2626: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2627: p_init_msg_list,
2628: '_PVT',
2629: x_return_status);
2630: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

2626: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2627: p_init_msg_list,
2628: '_PVT',
2629: x_return_status);
2630: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2631: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2632: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2633: RAISE Okc_Api.G_EXCEPTION_ERROR;
2634: END IF;

Line 2631: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2627: p_init_msg_list,
2628: '_PVT',
2629: x_return_status);
2630: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2631: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2632: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2633: RAISE Okc_Api.G_EXCEPTION_ERROR;
2634: END IF;
2635: --- Setting item attributes

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

2628: '_PVT',
2629: x_return_status);
2630: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2631: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2632: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2633: RAISE Okc_Api.G_EXCEPTION_ERROR;
2634: END IF;
2635: --- Setting item attributes
2636: l_return_status := Set_Attributes(

Line 2633: RAISE Okc_Api.G_EXCEPTION_ERROR;

2629: x_return_status);
2630: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2631: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2632: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2633: RAISE Okc_Api.G_EXCEPTION_ERROR;
2634: END IF;
2635: --- Setting item attributes
2636: l_return_status := Set_Attributes(
2637: p_okl_cnsld_ar_hdrs_tl_rec, -- IN

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

2636: l_return_status := Set_Attributes(
2637: p_okl_cnsld_ar_hdrs_tl_rec, -- IN
2638: l_okl_cnsld_ar_hdrs_tl_rec); -- OUT
2639: --- If any errors happen abort API
2640: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2641: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2642: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2643: RAISE Okc_Api.G_EXCEPTION_ERROR;
2644: END IF;

Line 2641: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2637: p_okl_cnsld_ar_hdrs_tl_rec, -- IN
2638: l_okl_cnsld_ar_hdrs_tl_rec); -- OUT
2639: --- If any errors happen abort API
2640: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2641: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2642: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2643: RAISE Okc_Api.G_EXCEPTION_ERROR;
2644: END IF;
2645: l_return_status := populate_new_record(l_okl_cnsld_ar_hdrs_tl_rec, ldefoklcnsldarhdrstlrec);

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

2638: l_okl_cnsld_ar_hdrs_tl_rec); -- OUT
2639: --- If any errors happen abort API
2640: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2641: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2642: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2643: RAISE Okc_Api.G_EXCEPTION_ERROR;
2644: END IF;
2645: l_return_status := populate_new_record(l_okl_cnsld_ar_hdrs_tl_rec, ldefoklcnsldarhdrstlrec);
2646: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2643: RAISE Okc_Api.G_EXCEPTION_ERROR;

2639: --- If any errors happen abort API
2640: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2641: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2642: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2643: RAISE Okc_Api.G_EXCEPTION_ERROR;
2644: END IF;
2645: l_return_status := populate_new_record(l_okl_cnsld_ar_hdrs_tl_rec, ldefoklcnsldarhdrstlrec);
2646: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2647: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

2642: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2643: RAISE Okc_Api.G_EXCEPTION_ERROR;
2644: END IF;
2645: l_return_status := populate_new_record(l_okl_cnsld_ar_hdrs_tl_rec, ldefoklcnsldarhdrstlrec);
2646: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2647: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2648: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2649: RAISE Okc_Api.G_EXCEPTION_ERROR;
2650: END IF;

Line 2647: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2643: RAISE Okc_Api.G_EXCEPTION_ERROR;
2644: END IF;
2645: l_return_status := populate_new_record(l_okl_cnsld_ar_hdrs_tl_rec, ldefoklcnsldarhdrstlrec);
2646: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2647: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2648: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2649: RAISE Okc_Api.G_EXCEPTION_ERROR;
2650: END IF;
2651: UPDATE OKL_CNSLD_AR_HDRS_TL

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

2644: END IF;
2645: l_return_status := populate_new_record(l_okl_cnsld_ar_hdrs_tl_rec, ldefoklcnsldarhdrstlrec);
2646: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2647: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2648: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2649: RAISE Okc_Api.G_EXCEPTION_ERROR;
2650: END IF;
2651: UPDATE OKL_CNSLD_AR_HDRS_TL
2652: SET PRIVATE_LABEL_LOGO_URL = ldefoklcnsldarhdrstlrec.private_label_logo_url,

Line 2649: RAISE Okc_Api.G_EXCEPTION_ERROR;

2645: l_return_status := populate_new_record(l_okl_cnsld_ar_hdrs_tl_rec, ldefoklcnsldarhdrstlrec);
2646: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2647: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2648: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2649: RAISE Okc_Api.G_EXCEPTION_ERROR;
2650: END IF;
2651: UPDATE OKL_CNSLD_AR_HDRS_TL
2652: SET PRIVATE_LABEL_LOGO_URL = ldefoklcnsldarhdrstlrec.private_label_logo_url,
2653: CREATED_BY = ldefoklcnsldarhdrstlrec.created_by,

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

2664: WHERE ID = ldefoklcnsldarhdrstlrec.id
2665: AND SOURCE_LANG <> USERENV('LANG');
2666:
2667: x_okl_cnsld_ar_hdrs_tl_rec := ldefoklcnsldarhdrstlrec;
2668: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2669: EXCEPTION
2670: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2671: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2672: (

Line 2670: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2666:
2667: x_okl_cnsld_ar_hdrs_tl_rec := ldefoklcnsldarhdrstlrec;
2668: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2669: EXCEPTION
2670: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2671: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2672: (
2673: l_api_name,
2674: G_PKG_NAME,

Line 2671: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2667: x_okl_cnsld_ar_hdrs_tl_rec := ldefoklcnsldarhdrstlrec;
2668: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2669: EXCEPTION
2670: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2671: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2672: (
2673: l_api_name,
2674: G_PKG_NAME,
2675: 'OKC_API.G_RET_STS_ERROR',

Line 2675: 'OKC_API.G_RET_STS_ERROR',

2671: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2672: (
2673: l_api_name,
2674: G_PKG_NAME,
2675: 'OKC_API.G_RET_STS_ERROR',
2676: x_msg_count,
2677: x_msg_data,
2678: '_PVT'
2679: );

Line 2680: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2676: x_msg_count,
2677: x_msg_data,
2678: '_PVT'
2679: );
2680: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2681: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2682: (
2683: l_api_name,
2684: G_PKG_NAME,

Line 2681: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2677: x_msg_data,
2678: '_PVT'
2679: );
2680: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2681: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2682: (
2683: l_api_name,
2684: G_PKG_NAME,
2685: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2685: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2681: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2682: (
2683: l_api_name,
2684: G_PKG_NAME,
2685: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2686: x_msg_count,
2687: x_msg_data,
2688: '_PVT'
2689: );

Line 2691: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2687: x_msg_data,
2688: '_PVT'
2689: );
2690: WHEN OTHERS THEN
2691: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2692: (
2693: l_api_name,
2694: G_PKG_NAME,
2695: 'OTHERS',

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

2711: x_cnrv_rec OUT NOCOPY cnrv_rec_type) IS
2712:
2713: l_api_version CONSTANT NUMBER := 1;
2714: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2715: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2716: l_cnrv_rec cnrv_rec_type := p_cnrv_rec;
2717: l_def_cnrv_rec cnrv_rec_type;
2718: l_okl_cnsld_ar_hdrs_tl_rec okl_cnsld_ar_hdrs_tl_rec_type;
2719: lx_okl_cnsld_ar_hdrs_tl_rec okl_cnsld_ar_hdrs_tl_rec_type;

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

2740: x_cnrv_rec OUT NOCOPY cnrv_rec_type
2741: ) RETURN VARCHAR2 IS
2742: l_cnrv_rec cnrv_rec_type;
2743: l_row_notfound BOOLEAN := TRUE;
2744: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2745: BEGIN
2746: x_cnrv_rec := p_cnrv_rec;
2747: -- Get current database values
2748: l_cnrv_rec := get_rec(p_cnrv_rec, l_row_notfound);

Line 2750: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

2746: x_cnrv_rec := p_cnrv_rec;
2747: -- Get current database values
2748: l_cnrv_rec := get_rec(p_cnrv_rec, l_row_notfound);
2749: IF (l_row_notfound) THEN
2750: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2751: END IF;
2752: IF (x_cnrv_rec.id = Okc_Api.G_MISS_NUM)
2753: THEN
2754: x_cnrv_rec.id := l_cnrv_rec.id;

Line 2752: IF (x_cnrv_rec.id = Okc_Api.G_MISS_NUM)

2748: l_cnrv_rec := get_rec(p_cnrv_rec, l_row_notfound);
2749: IF (l_row_notfound) THEN
2750: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2751: END IF;
2752: IF (x_cnrv_rec.id = Okc_Api.G_MISS_NUM)
2753: THEN
2754: x_cnrv_rec.id := l_cnrv_rec.id;
2755: END IF;
2756: IF (x_cnrv_rec.object_version_number = Okc_Api.G_MISS_NUM)

Line 2756: IF (x_cnrv_rec.object_version_number = Okc_Api.G_MISS_NUM)

2752: IF (x_cnrv_rec.id = Okc_Api.G_MISS_NUM)
2753: THEN
2754: x_cnrv_rec.id := l_cnrv_rec.id;
2755: END IF;
2756: IF (x_cnrv_rec.object_version_number = Okc_Api.G_MISS_NUM)
2757: THEN
2758: x_cnrv_rec.object_version_number := l_cnrv_rec.object_version_number;
2759: END IF;
2760: IF (x_cnrv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)

Line 2760: IF (x_cnrv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)

2756: IF (x_cnrv_rec.object_version_number = Okc_Api.G_MISS_NUM)
2757: THEN
2758: x_cnrv_rec.object_version_number := l_cnrv_rec.object_version_number;
2759: END IF;
2760: IF (x_cnrv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2761: THEN
2762: x_cnrv_rec.sfwt_flag := l_cnrv_rec.sfwt_flag;
2763: END IF;
2764: IF (x_cnrv_rec.ibt_id = Okc_Api.G_MISS_NUM)

Line 2764: IF (x_cnrv_rec.ibt_id = Okc_Api.G_MISS_NUM)

2760: IF (x_cnrv_rec.sfwt_flag = Okc_Api.G_MISS_CHAR)
2761: THEN
2762: x_cnrv_rec.sfwt_flag := l_cnrv_rec.sfwt_flag;
2763: END IF;
2764: IF (x_cnrv_rec.ibt_id = Okc_Api.G_MISS_NUM)
2765: THEN
2766: x_cnrv_rec.ibt_id := l_cnrv_rec.ibt_id;
2767: END IF;
2768: IF (x_cnrv_rec.ixx_id = Okc_Api.G_MISS_NUM)

Line 2768: IF (x_cnrv_rec.ixx_id = Okc_Api.G_MISS_NUM)

2764: IF (x_cnrv_rec.ibt_id = Okc_Api.G_MISS_NUM)
2765: THEN
2766: x_cnrv_rec.ibt_id := l_cnrv_rec.ibt_id;
2767: END IF;
2768: IF (x_cnrv_rec.ixx_id = Okc_Api.G_MISS_NUM)
2769: THEN
2770: x_cnrv_rec.ixx_id := l_cnrv_rec.ixx_id;
2771: END IF;
2772: IF (x_cnrv_rec.currency_code = Okc_Api.G_MISS_CHAR)

Line 2772: IF (x_cnrv_rec.currency_code = Okc_Api.G_MISS_CHAR)

2768: IF (x_cnrv_rec.ixx_id = Okc_Api.G_MISS_NUM)
2769: THEN
2770: x_cnrv_rec.ixx_id := l_cnrv_rec.ixx_id;
2771: END IF;
2772: IF (x_cnrv_rec.currency_code = Okc_Api.G_MISS_CHAR)
2773: THEN
2774: x_cnrv_rec.currency_code := l_cnrv_rec.currency_code;
2775: END IF;
2776: IF (x_cnrv_rec.irm_id = Okc_Api.G_MISS_NUM)

Line 2776: IF (x_cnrv_rec.irm_id = Okc_Api.G_MISS_NUM)

2772: IF (x_cnrv_rec.currency_code = Okc_Api.G_MISS_CHAR)
2773: THEN
2774: x_cnrv_rec.currency_code := l_cnrv_rec.currency_code;
2775: END IF;
2776: IF (x_cnrv_rec.irm_id = Okc_Api.G_MISS_NUM)
2777: THEN
2778: x_cnrv_rec.irm_id := l_cnrv_rec.irm_id;
2779: END IF;
2780: IF (x_cnrv_rec.inf_id = Okc_Api.G_MISS_NUM)

Line 2780: IF (x_cnrv_rec.inf_id = Okc_Api.G_MISS_NUM)

2776: IF (x_cnrv_rec.irm_id = Okc_Api.G_MISS_NUM)
2777: THEN
2778: x_cnrv_rec.irm_id := l_cnrv_rec.irm_id;
2779: END IF;
2780: IF (x_cnrv_rec.inf_id = Okc_Api.G_MISS_NUM)
2781: THEN
2782: x_cnrv_rec.inf_id := l_cnrv_rec.inf_id;
2783: END IF;
2784: IF (x_cnrv_rec.set_of_books_id = Okc_Api.G_MISS_NUM)

Line 2784: IF (x_cnrv_rec.set_of_books_id = Okc_Api.G_MISS_NUM)

2780: IF (x_cnrv_rec.inf_id = Okc_Api.G_MISS_NUM)
2781: THEN
2782: x_cnrv_rec.inf_id := l_cnrv_rec.inf_id;
2783: END IF;
2784: IF (x_cnrv_rec.set_of_books_id = Okc_Api.G_MISS_NUM)
2785: THEN
2786: x_cnrv_rec.set_of_books_id := l_cnrv_rec.set_of_books_id;
2787: END IF;
2788: IF (x_cnrv_rec.consolidated_invoice_number = Okc_Api.G_MISS_CHAR)

Line 2788: IF (x_cnrv_rec.consolidated_invoice_number = Okc_Api.G_MISS_CHAR)

2784: IF (x_cnrv_rec.set_of_books_id = Okc_Api.G_MISS_NUM)
2785: THEN
2786: x_cnrv_rec.set_of_books_id := l_cnrv_rec.set_of_books_id;
2787: END IF;
2788: IF (x_cnrv_rec.consolidated_invoice_number = Okc_Api.G_MISS_CHAR)
2789: THEN
2790: x_cnrv_rec.consolidated_invoice_number := l_cnrv_rec.consolidated_invoice_number;
2791: END IF;
2792: IF (x_cnrv_rec.trx_status_code = Okc_Api.G_MISS_CHAR)

Line 2792: IF (x_cnrv_rec.trx_status_code = Okc_Api.G_MISS_CHAR)

2788: IF (x_cnrv_rec.consolidated_invoice_number = Okc_Api.G_MISS_CHAR)
2789: THEN
2790: x_cnrv_rec.consolidated_invoice_number := l_cnrv_rec.consolidated_invoice_number;
2791: END IF;
2792: IF (x_cnrv_rec.trx_status_code = Okc_Api.G_MISS_CHAR)
2793: THEN
2794: x_cnrv_rec.trx_status_code := l_cnrv_rec.trx_status_code;
2795: END IF;
2796: IF (x_cnrv_rec.invoice_pull_yn = Okc_Api.G_MISS_CHAR)

Line 2796: IF (x_cnrv_rec.invoice_pull_yn = Okc_Api.G_MISS_CHAR)

2792: IF (x_cnrv_rec.trx_status_code = Okc_Api.G_MISS_CHAR)
2793: THEN
2794: x_cnrv_rec.trx_status_code := l_cnrv_rec.trx_status_code;
2795: END IF;
2796: IF (x_cnrv_rec.invoice_pull_yn = Okc_Api.G_MISS_CHAR)
2797: THEN
2798: x_cnrv_rec.invoice_pull_yn := l_cnrv_rec.invoice_pull_yn;
2799: END IF;
2800: IF (x_cnrv_rec.date_consolidated = Okc_Api.G_MISS_DATE)

Line 2800: IF (x_cnrv_rec.date_consolidated = Okc_Api.G_MISS_DATE)

2796: IF (x_cnrv_rec.invoice_pull_yn = Okc_Api.G_MISS_CHAR)
2797: THEN
2798: x_cnrv_rec.invoice_pull_yn := l_cnrv_rec.invoice_pull_yn;
2799: END IF;
2800: IF (x_cnrv_rec.date_consolidated = Okc_Api.G_MISS_DATE)
2801: THEN
2802: x_cnrv_rec.date_consolidated := l_cnrv_rec.date_consolidated;
2803: END IF;
2804: IF (x_cnrv_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR)

Line 2804: IF (x_cnrv_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR)

2800: IF (x_cnrv_rec.date_consolidated = Okc_Api.G_MISS_DATE)
2801: THEN
2802: x_cnrv_rec.date_consolidated := l_cnrv_rec.date_consolidated;
2803: END IF;
2804: IF (x_cnrv_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR)
2805: THEN
2806: x_cnrv_rec.private_label_logo_url := l_cnrv_rec.private_label_logo_url;
2807: END IF;
2808: IF (x_cnrv_rec.amount = Okc_Api.G_MISS_NUM)

Line 2808: IF (x_cnrv_rec.amount = Okc_Api.G_MISS_NUM)

2804: IF (x_cnrv_rec.private_label_logo_url = Okc_Api.G_MISS_CHAR)
2805: THEN
2806: x_cnrv_rec.private_label_logo_url := l_cnrv_rec.private_label_logo_url;
2807: END IF;
2808: IF (x_cnrv_rec.amount = Okc_Api.G_MISS_NUM)
2809: THEN
2810: x_cnrv_rec.amount := l_cnrv_rec.amount;
2811: END IF;
2812: IF (x_cnrv_rec.due_date = Okc_Api.G_MISS_DATE)

Line 2812: IF (x_cnrv_rec.due_date = Okc_Api.G_MISS_DATE)

2808: IF (x_cnrv_rec.amount = Okc_Api.G_MISS_NUM)
2809: THEN
2810: x_cnrv_rec.amount := l_cnrv_rec.amount;
2811: END IF;
2812: IF (x_cnrv_rec.due_date = Okc_Api.G_MISS_DATE)
2813: THEN
2814: x_cnrv_rec.due_date := l_cnrv_rec.due_date;
2815: END IF;
2816: IF (x_cnrv_rec.attribute_category = Okc_Api.G_MISS_CHAR)

Line 2816: IF (x_cnrv_rec.attribute_category = Okc_Api.G_MISS_CHAR)

2812: IF (x_cnrv_rec.due_date = Okc_Api.G_MISS_DATE)
2813: THEN
2814: x_cnrv_rec.due_date := l_cnrv_rec.due_date;
2815: END IF;
2816: IF (x_cnrv_rec.attribute_category = Okc_Api.G_MISS_CHAR)
2817: THEN
2818: x_cnrv_rec.attribute_category := l_cnrv_rec.attribute_category;
2819: END IF;
2820: IF (x_cnrv_rec.attribute1 = Okc_Api.G_MISS_CHAR)

Line 2820: IF (x_cnrv_rec.attribute1 = Okc_Api.G_MISS_CHAR)

2816: IF (x_cnrv_rec.attribute_category = Okc_Api.G_MISS_CHAR)
2817: THEN
2818: x_cnrv_rec.attribute_category := l_cnrv_rec.attribute_category;
2819: END IF;
2820: IF (x_cnrv_rec.attribute1 = Okc_Api.G_MISS_CHAR)
2821: THEN
2822: x_cnrv_rec.attribute1 := l_cnrv_rec.attribute1;
2823: END IF;
2824: IF (x_cnrv_rec.attribute2 = Okc_Api.G_MISS_CHAR)

Line 2824: IF (x_cnrv_rec.attribute2 = Okc_Api.G_MISS_CHAR)

2820: IF (x_cnrv_rec.attribute1 = Okc_Api.G_MISS_CHAR)
2821: THEN
2822: x_cnrv_rec.attribute1 := l_cnrv_rec.attribute1;
2823: END IF;
2824: IF (x_cnrv_rec.attribute2 = Okc_Api.G_MISS_CHAR)
2825: THEN
2826: x_cnrv_rec.attribute2 := l_cnrv_rec.attribute2;
2827: END IF;
2828: IF (x_cnrv_rec.attribute3 = Okc_Api.G_MISS_CHAR)

Line 2828: IF (x_cnrv_rec.attribute3 = Okc_Api.G_MISS_CHAR)

2824: IF (x_cnrv_rec.attribute2 = Okc_Api.G_MISS_CHAR)
2825: THEN
2826: x_cnrv_rec.attribute2 := l_cnrv_rec.attribute2;
2827: END IF;
2828: IF (x_cnrv_rec.attribute3 = Okc_Api.G_MISS_CHAR)
2829: THEN
2830: x_cnrv_rec.attribute3 := l_cnrv_rec.attribute3;
2831: END IF;
2832: IF (x_cnrv_rec.attribute4 = Okc_Api.G_MISS_CHAR)

Line 2832: IF (x_cnrv_rec.attribute4 = Okc_Api.G_MISS_CHAR)

2828: IF (x_cnrv_rec.attribute3 = Okc_Api.G_MISS_CHAR)
2829: THEN
2830: x_cnrv_rec.attribute3 := l_cnrv_rec.attribute3;
2831: END IF;
2832: IF (x_cnrv_rec.attribute4 = Okc_Api.G_MISS_CHAR)
2833: THEN
2834: x_cnrv_rec.attribute4 := l_cnrv_rec.attribute4;
2835: END IF;
2836: IF (x_cnrv_rec.attribute5 = Okc_Api.G_MISS_CHAR)

Line 2836: IF (x_cnrv_rec.attribute5 = Okc_Api.G_MISS_CHAR)

2832: IF (x_cnrv_rec.attribute4 = Okc_Api.G_MISS_CHAR)
2833: THEN
2834: x_cnrv_rec.attribute4 := l_cnrv_rec.attribute4;
2835: END IF;
2836: IF (x_cnrv_rec.attribute5 = Okc_Api.G_MISS_CHAR)
2837: THEN
2838: x_cnrv_rec.attribute5 := l_cnrv_rec.attribute5;
2839: END IF;
2840: IF (x_cnrv_rec.attribute6 = Okc_Api.G_MISS_CHAR)

Line 2840: IF (x_cnrv_rec.attribute6 = Okc_Api.G_MISS_CHAR)

2836: IF (x_cnrv_rec.attribute5 = Okc_Api.G_MISS_CHAR)
2837: THEN
2838: x_cnrv_rec.attribute5 := l_cnrv_rec.attribute5;
2839: END IF;
2840: IF (x_cnrv_rec.attribute6 = Okc_Api.G_MISS_CHAR)
2841: THEN
2842: x_cnrv_rec.attribute6 := l_cnrv_rec.attribute6;
2843: END IF;
2844: IF (x_cnrv_rec.attribute7 = Okc_Api.G_MISS_CHAR)

Line 2844: IF (x_cnrv_rec.attribute7 = Okc_Api.G_MISS_CHAR)

2840: IF (x_cnrv_rec.attribute6 = Okc_Api.G_MISS_CHAR)
2841: THEN
2842: x_cnrv_rec.attribute6 := l_cnrv_rec.attribute6;
2843: END IF;
2844: IF (x_cnrv_rec.attribute7 = Okc_Api.G_MISS_CHAR)
2845: THEN
2846: x_cnrv_rec.attribute7 := l_cnrv_rec.attribute7;
2847: END IF;
2848: IF (x_cnrv_rec.attribute8 = Okc_Api.G_MISS_CHAR)

Line 2848: IF (x_cnrv_rec.attribute8 = Okc_Api.G_MISS_CHAR)

2844: IF (x_cnrv_rec.attribute7 = Okc_Api.G_MISS_CHAR)
2845: THEN
2846: x_cnrv_rec.attribute7 := l_cnrv_rec.attribute7;
2847: END IF;
2848: IF (x_cnrv_rec.attribute8 = Okc_Api.G_MISS_CHAR)
2849: THEN
2850: x_cnrv_rec.attribute8 := l_cnrv_rec.attribute8;
2851: END IF;
2852: IF (x_cnrv_rec.attribute9 = Okc_Api.G_MISS_CHAR)

Line 2852: IF (x_cnrv_rec.attribute9 = Okc_Api.G_MISS_CHAR)

2848: IF (x_cnrv_rec.attribute8 = Okc_Api.G_MISS_CHAR)
2849: THEN
2850: x_cnrv_rec.attribute8 := l_cnrv_rec.attribute8;
2851: END IF;
2852: IF (x_cnrv_rec.attribute9 = Okc_Api.G_MISS_CHAR)
2853: THEN
2854: x_cnrv_rec.attribute9 := l_cnrv_rec.attribute9;
2855: END IF;
2856: IF (x_cnrv_rec.attribute10 = Okc_Api.G_MISS_CHAR)

Line 2856: IF (x_cnrv_rec.attribute10 = Okc_Api.G_MISS_CHAR)

2852: IF (x_cnrv_rec.attribute9 = Okc_Api.G_MISS_CHAR)
2853: THEN
2854: x_cnrv_rec.attribute9 := l_cnrv_rec.attribute9;
2855: END IF;
2856: IF (x_cnrv_rec.attribute10 = Okc_Api.G_MISS_CHAR)
2857: THEN
2858: x_cnrv_rec.attribute10 := l_cnrv_rec.attribute10;
2859: END IF;
2860: IF (x_cnrv_rec.attribute11 = Okc_Api.G_MISS_CHAR)

Line 2860: IF (x_cnrv_rec.attribute11 = Okc_Api.G_MISS_CHAR)

2856: IF (x_cnrv_rec.attribute10 = Okc_Api.G_MISS_CHAR)
2857: THEN
2858: x_cnrv_rec.attribute10 := l_cnrv_rec.attribute10;
2859: END IF;
2860: IF (x_cnrv_rec.attribute11 = Okc_Api.G_MISS_CHAR)
2861: THEN
2862: x_cnrv_rec.attribute11 := l_cnrv_rec.attribute11;
2863: END IF;
2864: IF (x_cnrv_rec.attribute12 = Okc_Api.G_MISS_CHAR)

Line 2864: IF (x_cnrv_rec.attribute12 = Okc_Api.G_MISS_CHAR)

2860: IF (x_cnrv_rec.attribute11 = Okc_Api.G_MISS_CHAR)
2861: THEN
2862: x_cnrv_rec.attribute11 := l_cnrv_rec.attribute11;
2863: END IF;
2864: IF (x_cnrv_rec.attribute12 = Okc_Api.G_MISS_CHAR)
2865: THEN
2866: x_cnrv_rec.attribute12 := l_cnrv_rec.attribute12;
2867: END IF;
2868: IF (x_cnrv_rec.attribute13 = Okc_Api.G_MISS_CHAR)

Line 2868: IF (x_cnrv_rec.attribute13 = Okc_Api.G_MISS_CHAR)

2864: IF (x_cnrv_rec.attribute12 = Okc_Api.G_MISS_CHAR)
2865: THEN
2866: x_cnrv_rec.attribute12 := l_cnrv_rec.attribute12;
2867: END IF;
2868: IF (x_cnrv_rec.attribute13 = Okc_Api.G_MISS_CHAR)
2869: THEN
2870: x_cnrv_rec.attribute13 := l_cnrv_rec.attribute13;
2871: END IF;
2872: IF (x_cnrv_rec.attribute14 = Okc_Api.G_MISS_CHAR)

Line 2872: IF (x_cnrv_rec.attribute14 = Okc_Api.G_MISS_CHAR)

2868: IF (x_cnrv_rec.attribute13 = Okc_Api.G_MISS_CHAR)
2869: THEN
2870: x_cnrv_rec.attribute13 := l_cnrv_rec.attribute13;
2871: END IF;
2872: IF (x_cnrv_rec.attribute14 = Okc_Api.G_MISS_CHAR)
2873: THEN
2874: x_cnrv_rec.attribute14 := l_cnrv_rec.attribute14;
2875: END IF;
2876: IF (x_cnrv_rec.attribute15 = Okc_Api.G_MISS_CHAR)

Line 2876: IF (x_cnrv_rec.attribute15 = Okc_Api.G_MISS_CHAR)

2872: IF (x_cnrv_rec.attribute14 = Okc_Api.G_MISS_CHAR)
2873: THEN
2874: x_cnrv_rec.attribute14 := l_cnrv_rec.attribute14;
2875: END IF;
2876: IF (x_cnrv_rec.attribute15 = Okc_Api.G_MISS_CHAR)
2877: THEN
2878: x_cnrv_rec.attribute15 := l_cnrv_rec.attribute15;
2879: END IF;
2880: IF (x_cnrv_rec.request_id = Okc_Api.G_MISS_NUM)

Line 2880: IF (x_cnrv_rec.request_id = Okc_Api.G_MISS_NUM)

2876: IF (x_cnrv_rec.attribute15 = Okc_Api.G_MISS_CHAR)
2877: THEN
2878: x_cnrv_rec.attribute15 := l_cnrv_rec.attribute15;
2879: END IF;
2880: IF (x_cnrv_rec.request_id = Okc_Api.G_MISS_NUM)
2881: THEN
2882: x_cnrv_rec.request_id := l_cnrv_rec.request_id;
2883: END IF;
2884: IF (x_cnrv_rec.program_application_id = Okc_Api.G_MISS_NUM)

Line 2884: IF (x_cnrv_rec.program_application_id = Okc_Api.G_MISS_NUM)

2880: IF (x_cnrv_rec.request_id = Okc_Api.G_MISS_NUM)
2881: THEN
2882: x_cnrv_rec.request_id := l_cnrv_rec.request_id;
2883: END IF;
2884: IF (x_cnrv_rec.program_application_id = Okc_Api.G_MISS_NUM)
2885: THEN
2886: x_cnrv_rec.program_application_id := l_cnrv_rec.program_application_id;
2887: END IF;
2888: IF (x_cnrv_rec.program_id = Okc_Api.G_MISS_NUM)

Line 2888: IF (x_cnrv_rec.program_id = Okc_Api.G_MISS_NUM)

2884: IF (x_cnrv_rec.program_application_id = Okc_Api.G_MISS_NUM)
2885: THEN
2886: x_cnrv_rec.program_application_id := l_cnrv_rec.program_application_id;
2887: END IF;
2888: IF (x_cnrv_rec.program_id = Okc_Api.G_MISS_NUM)
2889: THEN
2890: x_cnrv_rec.program_id := l_cnrv_rec.program_id;
2891: END IF;
2892: IF (x_cnrv_rec.program_update_date = Okc_Api.G_MISS_DATE)

Line 2892: IF (x_cnrv_rec.program_update_date = Okc_Api.G_MISS_DATE)

2888: IF (x_cnrv_rec.program_id = Okc_Api.G_MISS_NUM)
2889: THEN
2890: x_cnrv_rec.program_id := l_cnrv_rec.program_id;
2891: END IF;
2892: IF (x_cnrv_rec.program_update_date = Okc_Api.G_MISS_DATE)
2893: THEN
2894: x_cnrv_rec.program_update_date := l_cnrv_rec.program_update_date;
2895: END IF;
2896: IF (x_cnrv_rec.org_id = Okc_Api.G_MISS_NUM)

Line 2896: IF (x_cnrv_rec.org_id = Okc_Api.G_MISS_NUM)

2892: IF (x_cnrv_rec.program_update_date = Okc_Api.G_MISS_DATE)
2893: THEN
2894: x_cnrv_rec.program_update_date := l_cnrv_rec.program_update_date;
2895: END IF;
2896: IF (x_cnrv_rec.org_id = Okc_Api.G_MISS_NUM)
2897: THEN
2898: x_cnrv_rec.org_id := l_cnrv_rec.org_id;
2899: END IF;
2900: IF (x_cnrv_rec.created_by = Okc_Api.G_MISS_NUM)

Line 2900: IF (x_cnrv_rec.created_by = Okc_Api.G_MISS_NUM)

2896: IF (x_cnrv_rec.org_id = Okc_Api.G_MISS_NUM)
2897: THEN
2898: x_cnrv_rec.org_id := l_cnrv_rec.org_id;
2899: END IF;
2900: IF (x_cnrv_rec.created_by = Okc_Api.G_MISS_NUM)
2901: THEN
2902: x_cnrv_rec.created_by := l_cnrv_rec.created_by;
2903: END IF;
2904: IF (x_cnrv_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 2904: IF (x_cnrv_rec.creation_date = Okc_Api.G_MISS_DATE)

2900: IF (x_cnrv_rec.created_by = Okc_Api.G_MISS_NUM)
2901: THEN
2902: x_cnrv_rec.created_by := l_cnrv_rec.created_by;
2903: END IF;
2904: IF (x_cnrv_rec.creation_date = Okc_Api.G_MISS_DATE)
2905: THEN
2906: x_cnrv_rec.creation_date := l_cnrv_rec.creation_date;
2907: END IF;
2908: IF (x_cnrv_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 2908: IF (x_cnrv_rec.last_updated_by = Okc_Api.G_MISS_NUM)

2904: IF (x_cnrv_rec.creation_date = Okc_Api.G_MISS_DATE)
2905: THEN
2906: x_cnrv_rec.creation_date := l_cnrv_rec.creation_date;
2907: END IF;
2908: IF (x_cnrv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2909: THEN
2910: x_cnrv_rec.last_updated_by := l_cnrv_rec.last_updated_by;
2911: END IF;
2912: IF (x_cnrv_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 2912: IF (x_cnrv_rec.last_update_date = Okc_Api.G_MISS_DATE)

2908: IF (x_cnrv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2909: THEN
2910: x_cnrv_rec.last_updated_by := l_cnrv_rec.last_updated_by;
2911: END IF;
2912: IF (x_cnrv_rec.last_update_date = Okc_Api.G_MISS_DATE)
2913: THEN
2914: x_cnrv_rec.last_update_date := l_cnrv_rec.last_update_date;
2915: END IF;
2916: IF (x_cnrv_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 2916: IF (x_cnrv_rec.last_update_login = Okc_Api.G_MISS_NUM)

2912: IF (x_cnrv_rec.last_update_date = Okc_Api.G_MISS_DATE)
2913: THEN
2914: x_cnrv_rec.last_update_date := l_cnrv_rec.last_update_date;
2915: END IF;
2916: IF (x_cnrv_rec.last_update_login = Okc_Api.G_MISS_NUM)
2917: THEN
2918: x_cnrv_rec.last_update_login := l_cnrv_rec.last_update_login;
2919: END IF;
2920: -- for LE Uptake project 08-11-2006

Line 2921: IF (x_cnrv_rec.legal_entity_id = Okc_Api.G_MISS_NUM)

2917: THEN
2918: x_cnrv_rec.last_update_login := l_cnrv_rec.last_update_login;
2919: END IF;
2920: -- for LE Uptake project 08-11-2006
2921: IF (x_cnrv_rec.legal_entity_id = Okc_Api.G_MISS_NUM)
2922: THEN
2923: x_cnrv_rec.legal_entity_id := l_cnrv_rec.legal_entity_id;
2924: END IF;
2925: -- for LE Uptake project 08-11-2006

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

2931: FUNCTION Set_Attributes (
2932: p_cnrv_rec IN cnrv_rec_type,
2933: x_cnrv_rec OUT NOCOPY cnrv_rec_type
2934: ) RETURN VARCHAR2 IS
2935: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2936: BEGIN
2937: x_cnrv_rec := p_cnrv_rec;
2938: x_cnrv_rec.OBJECT_VERSION_NUMBER := NVL(x_cnrv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2939: IF (x_cnrv_rec.request_id IS NULL OR x_cnrv_rec.request_id = Okl_Api.G_MISS_NUM) THEN

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

2958:
2959: RETURN(l_return_status);
2960: END Set_Attributes;
2961: BEGIN
2962: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2963: G_PKG_NAME,
2964: p_init_msg_list,
2965: l_api_version,
2966: p_api_version,

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

2965: l_api_version,
2966: p_api_version,
2967: '_PVT',
2968: x_return_status);
2969: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2970: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2971: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2972: RAISE Okc_Api.G_EXCEPTION_ERROR;
2973: END IF;

Line 2970: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2966: p_api_version,
2967: '_PVT',
2968: x_return_status);
2969: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2970: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2971: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2972: RAISE Okc_Api.G_EXCEPTION_ERROR;
2973: END IF;
2974: --- Setting item attributes

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

2967: '_PVT',
2968: x_return_status);
2969: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2970: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2971: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2972: RAISE Okc_Api.G_EXCEPTION_ERROR;
2973: END IF;
2974: --- Setting item attributes
2975: l_return_status := Set_Attributes(

Line 2972: RAISE Okc_Api.G_EXCEPTION_ERROR;

2968: x_return_status);
2969: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2970: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2971: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2972: RAISE Okc_Api.G_EXCEPTION_ERROR;
2973: END IF;
2974: --- Setting item attributes
2975: l_return_status := Set_Attributes(
2976: p_cnrv_rec, -- IN

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

2975: l_return_status := Set_Attributes(
2976: p_cnrv_rec, -- IN
2977: l_cnrv_rec); -- OUT
2978: --- If any errors happen abort API
2979: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2980: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2981: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2982: RAISE Okc_Api.G_EXCEPTION_ERROR;
2983: END IF;

Line 2980: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2976: p_cnrv_rec, -- IN
2977: l_cnrv_rec); -- OUT
2978: --- If any errors happen abort API
2979: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2980: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2981: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2982: RAISE Okc_Api.G_EXCEPTION_ERROR;
2983: END IF;
2984: l_return_status := populate_new_record(l_cnrv_rec, l_def_cnrv_rec);

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

2977: l_cnrv_rec); -- OUT
2978: --- If any errors happen abort API
2979: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2980: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2981: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2982: RAISE Okc_Api.G_EXCEPTION_ERROR;
2983: END IF;
2984: l_return_status := populate_new_record(l_cnrv_rec, l_def_cnrv_rec);
2985: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2982: RAISE Okc_Api.G_EXCEPTION_ERROR;

2978: --- If any errors happen abort API
2979: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2980: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2981: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2982: RAISE Okc_Api.G_EXCEPTION_ERROR;
2983: END IF;
2984: l_return_status := populate_new_record(l_cnrv_rec, l_def_cnrv_rec);
2985: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2986: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

2981: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2982: RAISE Okc_Api.G_EXCEPTION_ERROR;
2983: END IF;
2984: l_return_status := populate_new_record(l_cnrv_rec, l_def_cnrv_rec);
2985: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2986: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2987: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2988: RAISE Okc_Api.G_EXCEPTION_ERROR;
2989: END IF;

Line 2986: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2982: RAISE Okc_Api.G_EXCEPTION_ERROR;
2983: END IF;
2984: l_return_status := populate_new_record(l_cnrv_rec, l_def_cnrv_rec);
2985: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2986: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2987: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2988: RAISE Okc_Api.G_EXCEPTION_ERROR;
2989: END IF;
2990: l_def_cnrv_rec := fill_who_columns(l_def_cnrv_rec);

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

2983: END IF;
2984: l_return_status := populate_new_record(l_cnrv_rec, l_def_cnrv_rec);
2985: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2986: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2987: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2988: RAISE Okc_Api.G_EXCEPTION_ERROR;
2989: END IF;
2990: l_def_cnrv_rec := fill_who_columns(l_def_cnrv_rec);
2991: --- Validate all non-missing attributes (Item Level Validation)

Line 2988: RAISE Okc_Api.G_EXCEPTION_ERROR;

2984: l_return_status := populate_new_record(l_cnrv_rec, l_def_cnrv_rec);
2985: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2986: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2987: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2988: RAISE Okc_Api.G_EXCEPTION_ERROR;
2989: END IF;
2990: l_def_cnrv_rec := fill_who_columns(l_def_cnrv_rec);
2991: --- Validate all non-missing attributes (Item Level Validation)
2992: l_return_status := Validate_Attributes(l_def_cnrv_rec);

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

2990: l_def_cnrv_rec := fill_who_columns(l_def_cnrv_rec);
2991: --- Validate all non-missing attributes (Item Level Validation)
2992: l_return_status := Validate_Attributes(l_def_cnrv_rec);
2993: --- If any errors happen abort API
2994: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2995: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2996: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2997: RAISE Okc_Api.G_EXCEPTION_ERROR;
2998: END IF;

Line 2995: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2991: --- Validate all non-missing attributes (Item Level Validation)
2992: l_return_status := Validate_Attributes(l_def_cnrv_rec);
2993: --- If any errors happen abort API
2994: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2995: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2996: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2997: RAISE Okc_Api.G_EXCEPTION_ERROR;
2998: END IF;
2999: l_return_status := Validate_Record(l_def_cnrv_rec);

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

2992: l_return_status := Validate_Attributes(l_def_cnrv_rec);
2993: --- If any errors happen abort API
2994: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2995: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2996: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2997: RAISE Okc_Api.G_EXCEPTION_ERROR;
2998: END IF;
2999: l_return_status := Validate_Record(l_def_cnrv_rec);
3000: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2997: RAISE Okc_Api.G_EXCEPTION_ERROR;

2993: --- If any errors happen abort API
2994: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2995: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2996: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2997: RAISE Okc_Api.G_EXCEPTION_ERROR;
2998: END IF;
2999: l_return_status := Validate_Record(l_def_cnrv_rec);
3000: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3001: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

2996: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2997: RAISE Okc_Api.G_EXCEPTION_ERROR;
2998: END IF;
2999: l_return_status := Validate_Record(l_def_cnrv_rec);
3000: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3001: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3002: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3003: RAISE Okc_Api.G_EXCEPTION_ERROR;
3004: END IF;

Line 3001: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2997: RAISE Okc_Api.G_EXCEPTION_ERROR;
2998: END IF;
2999: l_return_status := Validate_Record(l_def_cnrv_rec);
3000: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3001: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3002: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3003: RAISE Okc_Api.G_EXCEPTION_ERROR;
3004: END IF;
3005:

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

2998: END IF;
2999: l_return_status := Validate_Record(l_def_cnrv_rec);
3000: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3001: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3002: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3003: RAISE Okc_Api.G_EXCEPTION_ERROR;
3004: END IF;
3005:
3006: --------------------------------------

Line 3003: RAISE Okc_Api.G_EXCEPTION_ERROR;

2999: l_return_status := Validate_Record(l_def_cnrv_rec);
3000: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3001: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3002: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3003: RAISE Okc_Api.G_EXCEPTION_ERROR;
3004: END IF;
3005:
3006: --------------------------------------
3007: -- Move VIEW record to "Child" records

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

3018: x_msg_data,
3019: l_okl_cnsld_ar_hdrs_tl_rec,
3020: lx_okl_cnsld_ar_hdrs_tl_rec
3021: );
3022: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3023: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3024: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3025: RAISE Okc_Api.G_EXCEPTION_ERROR;
3026: END IF;

Line 3023: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3019: l_okl_cnsld_ar_hdrs_tl_rec,
3020: lx_okl_cnsld_ar_hdrs_tl_rec
3021: );
3022: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3023: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3024: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3025: RAISE Okc_Api.G_EXCEPTION_ERROR;
3026: END IF;
3027: migrate(lx_okl_cnsld_ar_hdrs_tl_rec, l_def_cnrv_rec);

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

3020: lx_okl_cnsld_ar_hdrs_tl_rec
3021: );
3022: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3023: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3024: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3025: RAISE Okc_Api.G_EXCEPTION_ERROR;
3026: END IF;
3027: migrate(lx_okl_cnsld_ar_hdrs_tl_rec, l_def_cnrv_rec);
3028: update_row(

Line 3025: RAISE Okc_Api.G_EXCEPTION_ERROR;

3021: );
3022: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3023: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3024: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3025: RAISE Okc_Api.G_EXCEPTION_ERROR;
3026: END IF;
3027: migrate(lx_okl_cnsld_ar_hdrs_tl_rec, l_def_cnrv_rec);
3028: update_row(
3029: p_init_msg_list,

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

3032: x_msg_data,
3033: l_cnr_rec,
3034: lx_cnr_rec
3035: );
3036: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3037: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3038: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3039: RAISE Okc_Api.G_EXCEPTION_ERROR;
3040: END IF;

Line 3037: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3033: l_cnr_rec,
3034: lx_cnr_rec
3035: );
3036: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3037: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3038: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3039: RAISE Okc_Api.G_EXCEPTION_ERROR;
3040: END IF;
3041: migrate(lx_cnr_rec, l_def_cnrv_rec);

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

3034: lx_cnr_rec
3035: );
3036: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3037: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3038: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3039: RAISE Okc_Api.G_EXCEPTION_ERROR;
3040: END IF;
3041: migrate(lx_cnr_rec, l_def_cnrv_rec);
3042: x_cnrv_rec := l_def_cnrv_rec;

Line 3039: RAISE Okc_Api.G_EXCEPTION_ERROR;

3035: );
3036: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3037: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3038: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3039: RAISE Okc_Api.G_EXCEPTION_ERROR;
3040: END IF;
3041: migrate(lx_cnr_rec, l_def_cnrv_rec);
3042: x_cnrv_rec := l_def_cnrv_rec;
3043: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

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

3039: RAISE Okc_Api.G_EXCEPTION_ERROR;
3040: END IF;
3041: migrate(lx_cnr_rec, l_def_cnrv_rec);
3042: x_cnrv_rec := l_def_cnrv_rec;
3043: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3044: EXCEPTION
3045: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3046: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3047: (

Line 3045: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

3041: migrate(lx_cnr_rec, l_def_cnrv_rec);
3042: x_cnrv_rec := l_def_cnrv_rec;
3043: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3044: EXCEPTION
3045: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3046: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3047: (
3048: l_api_name,
3049: G_PKG_NAME,

Line 3046: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3042: x_cnrv_rec := l_def_cnrv_rec;
3043: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3044: EXCEPTION
3045: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3046: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3047: (
3048: l_api_name,
3049: G_PKG_NAME,
3050: 'OKC_API.G_RET_STS_ERROR',

Line 3050: 'OKC_API.G_RET_STS_ERROR',

3046: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3047: (
3048: l_api_name,
3049: G_PKG_NAME,
3050: 'OKC_API.G_RET_STS_ERROR',
3051: x_msg_count,
3052: x_msg_data,
3053: '_PVT'
3054: );

Line 3055: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3051: x_msg_count,
3052: x_msg_data,
3053: '_PVT'
3054: );
3055: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3056: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3057: (
3058: l_api_name,
3059: G_PKG_NAME,

Line 3056: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3052: x_msg_data,
3053: '_PVT'
3054: );
3055: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3056: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3057: (
3058: l_api_name,
3059: G_PKG_NAME,
3060: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3060: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3056: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3057: (
3058: l_api_name,
3059: G_PKG_NAME,
3060: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3061: x_msg_count,
3062: x_msg_data,
3063: '_PVT'
3064: );

Line 3066: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3062: x_msg_data,
3063: '_PVT'
3064: );
3065: WHEN OTHERS THEN
3066: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3067: (
3068: l_api_name,
3069: G_PKG_NAME,
3070: 'OTHERS',

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

3086: x_cnrv_tbl OUT NOCOPY cnrv_tbl_type) IS
3087:
3088: l_api_version CONSTANT NUMBER := 1;
3089: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
3090: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3091: i NUMBER := 0;
3092: BEGIN
3093: Okc_Api.init_msg_list(p_init_msg_list);
3094: -- Make sure PL/SQL table has records in it before passing

Line 3093: Okc_Api.init_msg_list(p_init_msg_list);

3089: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
3090: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3091: i NUMBER := 0;
3092: BEGIN
3093: Okc_Api.init_msg_list(p_init_msg_list);
3094: -- Make sure PL/SQL table has records in it before passing
3095: IF (p_cnrv_tbl.COUNT > 0) THEN
3096: i := p_cnrv_tbl.FIRST;
3097: LOOP

Line 3100: p_init_msg_list => Okc_Api.G_FALSE,

3096: i := p_cnrv_tbl.FIRST;
3097: LOOP
3098: update_row (
3099: p_api_version => p_api_version,
3100: p_init_msg_list => Okc_Api.G_FALSE,
3101: x_return_status => x_return_status,
3102: x_msg_count => x_msg_count,
3103: x_msg_data => x_msg_data,
3104: p_cnrv_rec => p_cnrv_tbl(i),

Line 3111: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

3107: i := p_cnrv_tbl.NEXT(i);
3108: END LOOP;
3109: END IF;
3110: EXCEPTION
3111: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3112: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3113: (
3114: l_api_name,
3115: G_PKG_NAME,

Line 3112: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3108: END LOOP;
3109: END IF;
3110: EXCEPTION
3111: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3112: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3113: (
3114: l_api_name,
3115: G_PKG_NAME,
3116: 'OKC_API.G_RET_STS_ERROR',

Line 3116: 'OKC_API.G_RET_STS_ERROR',

3112: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3113: (
3114: l_api_name,
3115: G_PKG_NAME,
3116: 'OKC_API.G_RET_STS_ERROR',
3117: x_msg_count,
3118: x_msg_data,
3119: '_PVT'
3120: );

Line 3121: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3117: x_msg_count,
3118: x_msg_data,
3119: '_PVT'
3120: );
3121: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3122: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3123: (
3124: l_api_name,
3125: G_PKG_NAME,

Line 3122: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3118: x_msg_data,
3119: '_PVT'
3120: );
3121: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3122: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3123: (
3124: l_api_name,
3125: G_PKG_NAME,
3126: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3126: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3122: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3123: (
3124: l_api_name,
3125: G_PKG_NAME,
3126: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3127: x_msg_count,
3128: x_msg_data,
3129: '_PVT'
3130: );

Line 3132: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3128: x_msg_data,
3129: '_PVT'
3130: );
3131: WHEN OTHERS THEN
3132: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3133: (
3134: l_api_name,
3135: G_PKG_NAME,
3136: 'OTHERS',

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

3154: p_cnr_rec IN cnr_rec_type) IS
3155:
3156: l_api_version CONSTANT NUMBER := 1;
3157: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
3158: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3159: l_cnr_rec cnr_rec_type:= p_cnr_rec;
3160: l_row_notfound BOOLEAN := TRUE;
3161: BEGIN
3162: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

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

3158: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3159: l_cnr_rec cnr_rec_type:= p_cnr_rec;
3160: l_row_notfound BOOLEAN := TRUE;
3161: BEGIN
3162: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
3163: p_init_msg_list,
3164: '_PVT',
3165: x_return_status);
3166: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

3162: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
3163: p_init_msg_list,
3164: '_PVT',
3165: x_return_status);
3166: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3167: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3168: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3169: RAISE Okc_Api.G_EXCEPTION_ERROR;
3170: END IF;

Line 3167: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3163: p_init_msg_list,
3164: '_PVT',
3165: x_return_status);
3166: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3167: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3168: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3169: RAISE Okc_Api.G_EXCEPTION_ERROR;
3170: END IF;
3171: DELETE FROM OKL_CNSLD_AR_HDRS_B

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

3164: '_PVT',
3165: x_return_status);
3166: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3167: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3168: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3169: RAISE Okc_Api.G_EXCEPTION_ERROR;
3170: END IF;
3171: DELETE FROM OKL_CNSLD_AR_HDRS_B
3172: WHERE ID = l_cnr_rec.id;

Line 3169: RAISE Okc_Api.G_EXCEPTION_ERROR;

3165: x_return_status);
3166: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3167: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3168: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3169: RAISE Okc_Api.G_EXCEPTION_ERROR;
3170: END IF;
3171: DELETE FROM OKL_CNSLD_AR_HDRS_B
3172: WHERE ID = l_cnr_rec.id;
3173:

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

3170: END IF;
3171: DELETE FROM OKL_CNSLD_AR_HDRS_B
3172: WHERE ID = l_cnr_rec.id;
3173:
3174: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3175: EXCEPTION
3176: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3177: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3178: (

Line 3176: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

3172: WHERE ID = l_cnr_rec.id;
3173:
3174: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3175: EXCEPTION
3176: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3177: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3178: (
3179: l_api_name,
3180: G_PKG_NAME,

Line 3177: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3173:
3174: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3175: EXCEPTION
3176: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3177: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3178: (
3179: l_api_name,
3180: G_PKG_NAME,
3181: 'OKC_API.G_RET_STS_ERROR',

Line 3181: 'OKC_API.G_RET_STS_ERROR',

3177: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3178: (
3179: l_api_name,
3180: G_PKG_NAME,
3181: 'OKC_API.G_RET_STS_ERROR',
3182: x_msg_count,
3183: x_msg_data,
3184: '_PVT'
3185: );

Line 3186: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3182: x_msg_count,
3183: x_msg_data,
3184: '_PVT'
3185: );
3186: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3187: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3188: (
3189: l_api_name,
3190: G_PKG_NAME,

Line 3187: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3183: x_msg_data,
3184: '_PVT'
3185: );
3186: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3187: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3188: (
3189: l_api_name,
3190: G_PKG_NAME,
3191: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3191: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3187: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3188: (
3189: l_api_name,
3190: G_PKG_NAME,
3191: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3192: x_msg_count,
3193: x_msg_data,
3194: '_PVT'
3195: );

Line 3197: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3193: x_msg_data,
3194: '_PVT'
3195: );
3196: WHEN OTHERS THEN
3197: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3198: (
3199: l_api_name,
3200: G_PKG_NAME,
3201: 'OTHERS',

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

3215: p_okl_cnsld_ar_hdrs_tl_rec IN okl_cnsld_ar_hdrs_tl_rec_type) IS
3216:
3217: l_api_version CONSTANT NUMBER := 1;
3218: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
3219: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3220: l_okl_cnsld_ar_hdrs_tl_rec okl_cnsld_ar_hdrs_tl_rec_type:= p_okl_cnsld_ar_hdrs_tl_rec;
3221: l_row_notfound BOOLEAN := TRUE;
3222: ---------------------------------------------
3223: -- Set_Attributes for:OKL_CNSLD_AR_HDRS_TL --

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

3225: FUNCTION Set_Attributes (
3226: p_okl_cnsld_ar_hdrs_tl_rec IN okl_cnsld_ar_hdrs_tl_rec_type,
3227: x_okl_cnsld_ar_hdrs_tl_rec OUT NOCOPY okl_cnsld_ar_hdrs_tl_rec_type
3228: ) RETURN VARCHAR2 IS
3229: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3230: BEGIN
3231: x_okl_cnsld_ar_hdrs_tl_rec := p_okl_cnsld_ar_hdrs_tl_rec;
3232: x_okl_cnsld_ar_hdrs_tl_rec.LANGUAGE := USERENV('LANG');
3233: RETURN(l_return_status);

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

3232: x_okl_cnsld_ar_hdrs_tl_rec.LANGUAGE := USERENV('LANG');
3233: RETURN(l_return_status);
3234: END Set_Attributes;
3235: BEGIN
3236: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
3237: p_init_msg_list,
3238: '_PVT',
3239: x_return_status);
3240: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

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

3236: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
3237: p_init_msg_list,
3238: '_PVT',
3239: x_return_status);
3240: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3241: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3242: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3243: RAISE Okc_Api.G_EXCEPTION_ERROR;
3244: END IF;

Line 3241: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3237: p_init_msg_list,
3238: '_PVT',
3239: x_return_status);
3240: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3241: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3242: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3243: RAISE Okc_Api.G_EXCEPTION_ERROR;
3244: END IF;
3245: --- Setting item attributes

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

3238: '_PVT',
3239: x_return_status);
3240: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3241: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3242: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3243: RAISE Okc_Api.G_EXCEPTION_ERROR;
3244: END IF;
3245: --- Setting item attributes
3246: l_return_status := Set_Attributes(

Line 3243: RAISE Okc_Api.G_EXCEPTION_ERROR;

3239: x_return_status);
3240: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3241: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3242: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3243: RAISE Okc_Api.G_EXCEPTION_ERROR;
3244: END IF;
3245: --- Setting item attributes
3246: l_return_status := Set_Attributes(
3247: p_okl_cnsld_ar_hdrs_tl_rec, -- IN

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

3246: l_return_status := Set_Attributes(
3247: p_okl_cnsld_ar_hdrs_tl_rec, -- IN
3248: l_okl_cnsld_ar_hdrs_tl_rec); -- OUT
3249: --- If any errors happen abort API
3250: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3251: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3252: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3253: RAISE Okc_Api.G_EXCEPTION_ERROR;
3254: END IF;

Line 3251: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3247: p_okl_cnsld_ar_hdrs_tl_rec, -- IN
3248: l_okl_cnsld_ar_hdrs_tl_rec); -- OUT
3249: --- If any errors happen abort API
3250: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3251: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3252: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3253: RAISE Okc_Api.G_EXCEPTION_ERROR;
3254: END IF;
3255: DELETE FROM OKL_CNSLD_AR_HDRS_TL

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

3248: l_okl_cnsld_ar_hdrs_tl_rec); -- OUT
3249: --- If any errors happen abort API
3250: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3251: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3252: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3253: RAISE Okc_Api.G_EXCEPTION_ERROR;
3254: END IF;
3255: DELETE FROM OKL_CNSLD_AR_HDRS_TL
3256: WHERE ID = l_okl_cnsld_ar_hdrs_tl_rec.id;

Line 3253: RAISE Okc_Api.G_EXCEPTION_ERROR;

3249: --- If any errors happen abort API
3250: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3251: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3252: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3253: RAISE Okc_Api.G_EXCEPTION_ERROR;
3254: END IF;
3255: DELETE FROM OKL_CNSLD_AR_HDRS_TL
3256: WHERE ID = l_okl_cnsld_ar_hdrs_tl_rec.id;
3257:

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

3254: END IF;
3255: DELETE FROM OKL_CNSLD_AR_HDRS_TL
3256: WHERE ID = l_okl_cnsld_ar_hdrs_tl_rec.id;
3257:
3258: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3259: EXCEPTION
3260: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3261: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3262: (

Line 3260: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

3256: WHERE ID = l_okl_cnsld_ar_hdrs_tl_rec.id;
3257:
3258: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3259: EXCEPTION
3260: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3261: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3262: (
3263: l_api_name,
3264: G_PKG_NAME,

Line 3261: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3257:
3258: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3259: EXCEPTION
3260: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3261: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3262: (
3263: l_api_name,
3264: G_PKG_NAME,
3265: 'OKC_API.G_RET_STS_ERROR',

Line 3265: 'OKC_API.G_RET_STS_ERROR',

3261: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3262: (
3263: l_api_name,
3264: G_PKG_NAME,
3265: 'OKC_API.G_RET_STS_ERROR',
3266: x_msg_count,
3267: x_msg_data,
3268: '_PVT'
3269: );

Line 3270: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3266: x_msg_count,
3267: x_msg_data,
3268: '_PVT'
3269: );
3270: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3271: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3272: (
3273: l_api_name,
3274: G_PKG_NAME,

Line 3271: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3267: x_msg_data,
3268: '_PVT'
3269: );
3270: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3271: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3272: (
3273: l_api_name,
3274: G_PKG_NAME,
3275: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3275: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3271: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3272: (
3273: l_api_name,
3274: G_PKG_NAME,
3275: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3276: x_msg_count,
3277: x_msg_data,
3278: '_PVT'
3279: );

Line 3281: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3277: x_msg_data,
3278: '_PVT'
3279: );
3280: WHEN OTHERS THEN
3281: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3282: (
3283: l_api_name,
3284: G_PKG_NAME,
3285: 'OTHERS',

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

3300: p_cnrv_rec IN cnrv_rec_type) IS
3301:
3302: l_api_version CONSTANT NUMBER := 1;
3303: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
3304: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3305: l_cnrv_rec cnrv_rec_type := p_cnrv_rec;
3306: l_okl_cnsld_ar_hdrs_tl_rec okl_cnsld_ar_hdrs_tl_rec_type;
3307: l_cnr_rec cnr_rec_type;
3308: BEGIN

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

3305: l_cnrv_rec cnrv_rec_type := p_cnrv_rec;
3306: l_okl_cnsld_ar_hdrs_tl_rec okl_cnsld_ar_hdrs_tl_rec_type;
3307: l_cnr_rec cnr_rec_type;
3308: BEGIN
3309: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
3310: G_PKG_NAME,
3311: p_init_msg_list,
3312: l_api_version,
3313: p_api_version,

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

3312: l_api_version,
3313: p_api_version,
3314: '_PVT',
3315: x_return_status);
3316: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3317: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3318: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3319: RAISE Okc_Api.G_EXCEPTION_ERROR;
3320: END IF;

Line 3317: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3313: p_api_version,
3314: '_PVT',
3315: x_return_status);
3316: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3317: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3318: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3319: RAISE Okc_Api.G_EXCEPTION_ERROR;
3320: END IF;
3321: --------------------------------------

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

3314: '_PVT',
3315: x_return_status);
3316: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3317: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3318: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3319: RAISE Okc_Api.G_EXCEPTION_ERROR;
3320: END IF;
3321: --------------------------------------
3322: -- Move VIEW record to "Child" records

Line 3319: RAISE Okc_Api.G_EXCEPTION_ERROR;

3315: x_return_status);
3316: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3317: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3318: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3319: RAISE Okc_Api.G_EXCEPTION_ERROR;
3320: END IF;
3321: --------------------------------------
3322: -- Move VIEW record to "Child" records
3323: --------------------------------------

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

3332: x_msg_count,
3333: x_msg_data,
3334: l_okl_cnsld_ar_hdrs_tl_rec
3335: );
3336: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3337: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3338: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3339: RAISE Okc_Api.G_EXCEPTION_ERROR;
3340: END IF;

Line 3337: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3333: x_msg_data,
3334: l_okl_cnsld_ar_hdrs_tl_rec
3335: );
3336: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3337: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3338: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3339: RAISE Okc_Api.G_EXCEPTION_ERROR;
3340: END IF;
3341: delete_row(

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

3334: l_okl_cnsld_ar_hdrs_tl_rec
3335: );
3336: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3337: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3338: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3339: RAISE Okc_Api.G_EXCEPTION_ERROR;
3340: END IF;
3341: delete_row(
3342: p_init_msg_list,

Line 3339: RAISE Okc_Api.G_EXCEPTION_ERROR;

3335: );
3336: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3337: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3338: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3339: RAISE Okc_Api.G_EXCEPTION_ERROR;
3340: END IF;
3341: delete_row(
3342: p_init_msg_list,
3343: x_return_status,

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

3344: x_msg_count,
3345: x_msg_data,
3346: l_cnr_rec
3347: );
3348: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3349: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3350: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3351: RAISE Okc_Api.G_EXCEPTION_ERROR;
3352: END IF;

Line 3349: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3345: x_msg_data,
3346: l_cnr_rec
3347: );
3348: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3349: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3350: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3351: RAISE Okc_Api.G_EXCEPTION_ERROR;
3352: END IF;
3353: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

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

3346: l_cnr_rec
3347: );
3348: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3349: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3350: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3351: RAISE Okc_Api.G_EXCEPTION_ERROR;
3352: END IF;
3353: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3354: EXCEPTION

Line 3351: RAISE Okc_Api.G_EXCEPTION_ERROR;

3347: );
3348: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
3349: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3350: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3351: RAISE Okc_Api.G_EXCEPTION_ERROR;
3352: END IF;
3353: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3354: EXCEPTION
3355: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

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

3349: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3350: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
3351: RAISE Okc_Api.G_EXCEPTION_ERROR;
3352: END IF;
3353: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3354: EXCEPTION
3355: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3356: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3357: (

Line 3355: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

3351: RAISE Okc_Api.G_EXCEPTION_ERROR;
3352: END IF;
3353: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3354: EXCEPTION
3355: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3356: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3357: (
3358: l_api_name,
3359: G_PKG_NAME,

Line 3356: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3352: END IF;
3353: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
3354: EXCEPTION
3355: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3356: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3357: (
3358: l_api_name,
3359: G_PKG_NAME,
3360: 'OKC_API.G_RET_STS_ERROR',

Line 3360: 'OKC_API.G_RET_STS_ERROR',

3356: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3357: (
3358: l_api_name,
3359: G_PKG_NAME,
3360: 'OKC_API.G_RET_STS_ERROR',
3361: x_msg_count,
3362: x_msg_data,
3363: '_PVT'
3364: );

Line 3365: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3361: x_msg_count,
3362: x_msg_data,
3363: '_PVT'
3364: );
3365: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3366: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3367: (
3368: l_api_name,
3369: G_PKG_NAME,

Line 3366: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3362: x_msg_data,
3363: '_PVT'
3364: );
3365: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3366: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3367: (
3368: l_api_name,
3369: G_PKG_NAME,
3370: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3370: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3366: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3367: (
3368: l_api_name,
3369: G_PKG_NAME,
3370: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3371: x_msg_count,
3372: x_msg_data,
3373: '_PVT'
3374: );

Line 3376: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3372: x_msg_data,
3373: '_PVT'
3374: );
3375: WHEN OTHERS THEN
3376: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3377: (
3378: l_api_name,
3379: G_PKG_NAME,
3380: 'OTHERS',

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

3395: p_cnrv_tbl IN cnrv_tbl_type) IS
3396:
3397: l_api_version CONSTANT NUMBER := 1;
3398: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3399: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3400: i NUMBER := 0;
3401: BEGIN
3402: Okc_Api.init_msg_list(p_init_msg_list);
3403: -- Make sure PL/SQL table has records in it before passing

Line 3402: Okc_Api.init_msg_list(p_init_msg_list);

3398: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3399: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3400: i NUMBER := 0;
3401: BEGIN
3402: Okc_Api.init_msg_list(p_init_msg_list);
3403: -- Make sure PL/SQL table has records in it before passing
3404: IF (p_cnrv_tbl.COUNT > 0) THEN
3405: i := p_cnrv_tbl.FIRST;
3406: LOOP

Line 3409: p_init_msg_list => Okc_Api.G_FALSE,

3405: i := p_cnrv_tbl.FIRST;
3406: LOOP
3407: delete_row (
3408: p_api_version => p_api_version,
3409: p_init_msg_list => Okc_Api.G_FALSE,
3410: x_return_status => x_return_status,
3411: x_msg_count => x_msg_count,
3412: x_msg_data => x_msg_data,
3413: p_cnrv_rec => p_cnrv_tbl(i));

Line 3419: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

3415: i := p_cnrv_tbl.NEXT(i);
3416: END LOOP;
3417: END IF;
3418: EXCEPTION
3419: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3420: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3421: (
3422: l_api_name,
3423: G_PKG_NAME,

Line 3420: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

3416: END LOOP;
3417: END IF;
3418: EXCEPTION
3419: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
3420: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3421: (
3422: l_api_name,
3423: G_PKG_NAME,
3424: 'OKC_API.G_RET_STS_ERROR',

Line 3424: 'OKC_API.G_RET_STS_ERROR',

3420: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
3421: (
3422: l_api_name,
3423: G_PKG_NAME,
3424: 'OKC_API.G_RET_STS_ERROR',
3425: x_msg_count,
3426: x_msg_data,
3427: '_PVT'
3428: );

Line 3429: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

3425: x_msg_count,
3426: x_msg_data,
3427: '_PVT'
3428: );
3429: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3430: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3431: (
3432: l_api_name,
3433: G_PKG_NAME,

Line 3430: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3426: x_msg_data,
3427: '_PVT'
3428: );
3429: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
3430: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3431: (
3432: l_api_name,
3433: G_PKG_NAME,
3434: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 3434: 'OKC_API.G_RET_STS_UNEXP_ERROR',

3430: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3431: (
3432: l_api_name,
3433: G_PKG_NAME,
3434: 'OKC_API.G_RET_STS_UNEXP_ERROR',
3435: x_msg_count,
3436: x_msg_data,
3437: '_PVT'
3438: );

Line 3440: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

3436: x_msg_data,
3437: '_PVT'
3438: );
3439: WHEN OTHERS THEN
3440: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
3441: (
3442: l_api_name,
3443: G_PKG_NAME,
3444: 'OTHERS',