eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CDJ_PVT dependencies on OKL_API

Line 288: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

284: EXCEPTION
285:
286: WHEN OTHERS THEN
287:
288: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
289: p_msg_name => G_DB_ERROR,
290: p_token1 => G_PROG_NAME_TOKEN,
291: p_token1_value => l_prog_name,
292: p_token2 => G_SQLCODE_TOKEN,

Line 308: OKL_API.set_message(p_app_name => G_APP_NAME,

304: ------------------------
305: PROCEDURE validate_id (x_return_status OUT NOCOPY VARCHAR2, p_id IN NUMBER) IS
306: BEGIN
307: IF p_id IS NULL THEN
308: OKL_API.set_message(p_app_name => G_APP_NAME,
309: p_msg_name => G_COL_ERROR,
310: p_token1 => G_COL_NAME_TOKEN,
311: p_token1_value => 'id',
312: p_token2 => G_PKG_NAME_TOKEN,

Line 314: RAISE OKL_API.G_EXCEPTION_ERROR;

310: p_token1 => G_COL_NAME_TOKEN,
311: p_token1_value => 'id',
312: p_token2 => G_PKG_NAME_TOKEN,
313: p_token2_value => G_PKG_NAME);
314: RAISE OKL_API.G_EXCEPTION_ERROR;
315: END IF;
316: x_return_status := G_RET_STS_SUCCESS;
317: END validate_id;
318:

Line 326: OKL_API.set_message(p_app_name => G_APP_NAME,

322: -------------------------------------------
323: PROCEDURE validate_object_version_number (x_return_status OUT NOCOPY VARCHAR2, p_object_version_number IN NUMBER) IS
324: BEGIN
325: IF p_object_version_number IS NULL THEN
326: OKL_API.set_message(p_app_name => G_APP_NAME,
327: p_msg_name => G_COL_ERROR,
328: p_token1 => G_COL_NAME_TOKEN,
329: p_token1_value => 'object_version_number',
330: p_token2 => G_PKG_NAME_TOKEN,

Line 332: RAISE OKL_API.G_EXCEPTION_ERROR;

328: p_token1 => G_COL_NAME_TOKEN,
329: p_token1_value => 'object_version_number',
330: p_token2 => G_PKG_NAME_TOKEN,
331: p_token2_value => G_PKG_NAME);
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: END IF;
334: x_return_status := G_RET_STS_SUCCESS;
335: END validate_object_version_number;
336:

Line 344: OKL_API.set_message(p_app_name => G_APP_NAME,

340: -----------------------------------------
341: PROCEDURE validate_parent_object_code (x_return_status OUT NOCOPY VARCHAR2, p_parent_object_code IN VARCHAR2) IS
342: BEGIN
343: IF p_parent_object_code IS NULL THEN
344: OKL_API.set_message(p_app_name => G_APP_NAME,
345: p_msg_name => G_COL_ERROR,
346: p_token1 => G_COL_NAME_TOKEN,
347: p_token1_value => 'parent_object_code',
348: p_token2 => G_PKG_NAME_TOKEN,

Line 350: RAISE OKL_API.G_EXCEPTION_ERROR;

346: p_token1 => G_COL_NAME_TOKEN,
347: p_token1_value => 'parent_object_code',
348: p_token2 => G_PKG_NAME_TOKEN,
349: p_token2_value => G_PKG_NAME);
350: RAISE OKL_API.G_EXCEPTION_ERROR;
351: END IF;
352: x_return_status := G_RET_STS_SUCCESS;
353: END validate_parent_object_code;
354:

Line 362: OKL_API.set_message(p_app_name => G_APP_NAME,

358: -----------------------------------------
359: PROCEDURE validate_parent_object_id (x_return_status OUT NOCOPY VARCHAR2, p_parent_object_id IN NUMBER) IS
360: BEGIN
361: IF p_parent_object_id IS NULL THEN
362: OKL_API.set_message(p_app_name => G_APP_NAME,
363: p_msg_name => G_COL_ERROR,
364: p_token1 => G_COL_NAME_TOKEN,
365: p_token1_value => 'parent_object_id',
366: p_token2 => G_PKG_NAME_TOKEN,

Line 368: RAISE OKL_API.G_EXCEPTION_ERROR;

364: p_token1 => G_COL_NAME_TOKEN,
365: p_token1_value => 'parent_object_id',
366: p_token2 => G_PKG_NAME_TOKEN,
367: p_token2_value => G_PKG_NAME);
368: RAISE OKL_API.G_EXCEPTION_ERROR;
369: END IF;
370: x_return_status := G_RET_STS_SUCCESS;
371: END validate_parent_object_id;
372:

Line 380: OKL_API.set_message(p_app_name => G_APP_NAME,

376: --------------------------------------
377: PROCEDURE validate_adj_source_type (x_return_status OUT NOCOPY VARCHAR2, p_adj_source_type IN VARCHAR2) IS
378: BEGIN
379: IF p_adj_source_type IS NULL THEN
380: OKL_API.set_message(p_app_name => G_APP_NAME,
381: p_msg_name => G_COL_ERROR,
382: p_token1 => G_COL_NAME_TOKEN,
383: p_token1_value => 'adj_source_type',
384: p_token2 => G_PKG_NAME_TOKEN,

Line 386: RAISE OKL_API.G_EXCEPTION_ERROR;

382: p_token1 => G_COL_NAME_TOKEN,
383: p_token1_value => 'adj_source_type',
384: p_token2 => G_PKG_NAME_TOKEN,
385: p_token2_value => G_PKG_NAME);
386: RAISE OKL_API.G_EXCEPTION_ERROR;
387: END IF;
388: x_return_status := G_RET_STS_SUCCESS;
389: END validate_adj_source_type;
390:

Line 400: OKL_API.set_message(p_app_name => G_APP_NAME,

396: PROCEDURE validate_adj_stream_type (x_return_status OUT NOCOPY VARCHAR2, p_adj_rec IN cdjv_rec_type) IS
397: BEGIN
398: IF(p_adj_rec.processing_type IS NOT NULL) THEN
399: IF p_adj_rec.processing_type='BILL' AND p_adj_rec.stream_type_id IS NULL THEN
400: OKL_API.set_message(p_app_name => G_APP_NAME,
401: p_msg_name => 'OKL_STRM_TYPE_ID_REQUIRED');
402: RAISE OKL_API.G_EXCEPTION_ERROR;
403: END IF;
404: IF p_adj_rec.processing_type='CAPITALIZE' AND p_adj_rec.stream_type_id IS NOT NULL THEN

Line 402: RAISE OKL_API.G_EXCEPTION_ERROR;

398: IF(p_adj_rec.processing_type IS NOT NULL) THEN
399: IF p_adj_rec.processing_type='BILL' AND p_adj_rec.stream_type_id IS NULL THEN
400: OKL_API.set_message(p_app_name => G_APP_NAME,
401: p_msg_name => 'OKL_STRM_TYPE_ID_REQUIRED');
402: RAISE OKL_API.G_EXCEPTION_ERROR;
403: END IF;
404: IF p_adj_rec.processing_type='CAPITALIZE' AND p_adj_rec.stream_type_id IS NOT NULL THEN
405: OKL_API.set_message(p_app_name => G_APP_NAME,
406: p_msg_name => 'OKL_STRM_TYPE_ID_NOT_REQUIRED');

Line 405: OKL_API.set_message(p_app_name => G_APP_NAME,

401: p_msg_name => 'OKL_STRM_TYPE_ID_REQUIRED');
402: RAISE OKL_API.G_EXCEPTION_ERROR;
403: END IF;
404: IF p_adj_rec.processing_type='CAPITALIZE' AND p_adj_rec.stream_type_id IS NOT NULL THEN
405: OKL_API.set_message(p_app_name => G_APP_NAME,
406: p_msg_name => 'OKL_STRM_TYPE_ID_NOT_REQUIRED');
407: RAISE OKL_API.G_EXCEPTION_ERROR;
408: END IF;
409: END IF;

Line 407: RAISE OKL_API.G_EXCEPTION_ERROR;

403: END IF;
404: IF p_adj_rec.processing_type='CAPITALIZE' AND p_adj_rec.stream_type_id IS NOT NULL THEN
405: OKL_API.set_message(p_app_name => G_APP_NAME,
406: p_msg_name => 'OKL_STRM_TYPE_ID_NOT_REQUIRED');
407: RAISE OKL_API.G_EXCEPTION_ERROR;
408: END IF;
409: END IF;
410: x_return_status := G_RET_STS_SUCCESS;
411: END validate_adj_stream_type;

Line 441: OKL_API.set_message(p_app_name => G_APP_NAME,

437: FUNCTION validate_record (p_cdjv_rec IN cdjv_rec_type) RETURN VARCHAR2 IS
438: l_return_status VARCHAR2(1);
439: BEGIN
440: IF p_cdjv_rec.basis = 'ASSET_COST' AND ( p_cdjv_rec.percent_basis_value < 0 OR p_cdjv_rec.percent_basis_value > 100 )THEN
441: OKL_API.set_message(p_app_name => G_APP_NAME,
442: p_msg_name => 'OKL_PERCENT_BASIS_INVALID');
443: RAISE OKL_API.G_EXCEPTION_ERROR;
444: END IF;
445: RETURN G_RET_STS_SUCCESS;

Line 443: RAISE OKL_API.G_EXCEPTION_ERROR;

439: BEGIN
440: IF p_cdjv_rec.basis = 'ASSET_COST' AND ( p_cdjv_rec.percent_basis_value < 0 OR p_cdjv_rec.percent_basis_value > 100 )THEN
441: OKL_API.set_message(p_app_name => G_APP_NAME,
442: p_msg_name => 'OKL_PERCENT_BASIS_INVALID');
443: RAISE OKL_API.G_EXCEPTION_ERROR;
444: END IF;
445: RETURN G_RET_STS_SUCCESS;
446: END validate_record;
447:

Line 597: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

593: EXCEPTION
594:
595: WHEN OTHERS THEN
596:
597: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
598: p_msg_name => G_DB_ERROR,
599: p_token1 => G_PROG_NAME_TOKEN,
600: p_token1_value => l_prog_name,
601: p_token2 => G_SQLCODE_TOKEN,

Line 672: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

668: EXCEPTION
669:
670: WHEN OTHERS THEN
671:
672: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
673: p_msg_name => G_DB_ERROR,
674: p_token1 => G_PROG_NAME_TOKEN,
675: p_token1_value => l_prog_name,
676: p_token2 => G_SQLCODE_TOKEN,

Line 715: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

711:
712: l_return_status := validate_attributes(l_cdjv_rec);
713:
714: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
715: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
716: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
717: RAISE OKL_API.G_EXCEPTION_ERROR;
718: END IF;
719:

Line 717: RAISE OKL_API.G_EXCEPTION_ERROR;

713:
714: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
715: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
716: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
717: RAISE OKL_API.G_EXCEPTION_ERROR;
718: END IF;
719:
720: l_return_status := validate_record(l_cdjv_rec);
721:

Line 723: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

719:
720: l_return_status := validate_record(l_cdjv_rec);
721:
722: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
723: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
724: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
725: RAISE OKL_API.G_EXCEPTION_ERROR;
726: END IF;
727:

Line 725: RAISE OKL_API.G_EXCEPTION_ERROR;

721:
722: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
723: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
724: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
725: RAISE OKL_API.G_EXCEPTION_ERROR;
726: END IF;
727:
728: migrate (l_cdjv_rec, l_cdj_rec);
729: migrate (l_cdjv_rec, l_cdjtl_rec);

Line 734: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

730:
731: insert_row (x_return_status => l_return_status, p_cdj_rec => l_cdj_rec);
732:
733: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
734: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
735: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
736: RAISE OKL_API.G_EXCEPTION_ERROR;
737: END IF;
738:

Line 736: RAISE OKL_API.G_EXCEPTION_ERROR;

732:
733: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
734: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
735: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
736: RAISE OKL_API.G_EXCEPTION_ERROR;
737: END IF;
738:
739: insert_row (x_return_status => l_return_status, p_cdjtl_rec => l_cdjtl_rec);
740:

Line 742: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

738:
739: insert_row (x_return_status => l_return_status, p_cdjtl_rec => l_cdjtl_rec);
740:
741: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
742: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
743: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
744: RAISE OKL_API.G_EXCEPTION_ERROR;
745: END IF;
746:

Line 744: RAISE OKL_API.G_EXCEPTION_ERROR;

740:
741: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
742: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
743: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
744: RAISE OKL_API.G_EXCEPTION_ERROR;
745: END IF;
746:
747: x_cdjv_rec := l_cdjv_rec;
748: x_return_status := l_return_status;

Line 752: WHEN OKL_API.G_EXCEPTION_ERROR THEN

748: x_return_status := l_return_status;
749:
750: EXCEPTION
751:
752: WHEN OKL_API.G_EXCEPTION_ERROR THEN
753:
754: x_return_status := G_RET_STS_ERROR;
755:
756: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 756: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

752: WHEN OKL_API.G_EXCEPTION_ERROR THEN
753:
754: x_return_status := G_RET_STS_ERROR;
755:
756: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
757:
758: x_return_status := G_RET_STS_UNEXP_ERROR;
759:
760: WHEN OTHERS THEN

Line 762: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

758: x_return_status := G_RET_STS_UNEXP_ERROR;
759:
760: WHEN OTHERS THEN
761:
762: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
763: p_msg_name => G_DB_ERROR,
764: p_token1 => G_PROG_NAME_TOKEN,
765: p_token1_value => l_prog_name,
766: p_token2 => G_SQLCODE_TOKEN,

Line 805: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

801: p_cdjv_rec => p_cdjv_rec,
802: x_cdjv_rec => x_cdjv_rec);
803:
804: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
805: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
806: ELSIF l_return_status = G_RET_STS_ERROR THEN
807: RAISE OKL_API.G_EXCEPTION_ERROR;
808: END IF;
809:

Line 807: RAISE OKL_API.G_EXCEPTION_ERROR;

803:
804: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
805: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
806: ELSIF l_return_status = G_RET_STS_ERROR THEN
807: RAISE OKL_API.G_EXCEPTION_ERROR;
808: END IF;
809:
810: x_return_status := l_return_status;
811:

Line 814: WHEN OKL_API.G_EXCEPTION_ERROR THEN

810: x_return_status := l_return_status;
811:
812: EXCEPTION
813:
814: WHEN OKL_API.G_EXCEPTION_ERROR THEN
815:
816: x_return_status := G_RET_STS_ERROR;
817:
818: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 818: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

814: WHEN OKL_API.G_EXCEPTION_ERROR THEN
815:
816: x_return_status := G_RET_STS_ERROR;
817:
818: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
819:
820: x_return_status := G_RET_STS_UNEXP_ERROR;
821:
822: WHEN OTHERS THEN

Line 824: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

820: x_return_status := G_RET_STS_UNEXP_ERROR;
821:
822: WHEN OTHERS THEN
823:
824: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
825: p_msg_name => G_DB_ERROR,
826: p_token1 => G_PROG_NAME_TOKEN,
827: p_token1_value => l_prog_name,
828: p_token2 => G_SQLCODE_TOKEN,

Line 873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

869: p_cdjv_rec => p_cdjv_tbl(i),
870: x_cdjv_rec => x_cdjv_tbl(i));
871:
872: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
874: ELSIF l_return_status = G_RET_STS_ERROR THEN
875: RAISE OKL_API.G_EXCEPTION_ERROR;
876: END IF;
877:

Line 875: RAISE OKL_API.G_EXCEPTION_ERROR;

871:
872: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
874: ELSIF l_return_status = G_RET_STS_ERROR THEN
875: RAISE OKL_API.G_EXCEPTION_ERROR;
876: END IF;
877:
878: EXIT WHEN (i = p_cdjv_tbl.LAST);
879: i := p_cdjv_tbl.NEXT(i);

Line 895: WHEN OKL_API.G_EXCEPTION_ERROR THEN

891: x_return_status := l_return_status;
892:
893: EXCEPTION
894:
895: WHEN OKL_API.G_EXCEPTION_ERROR THEN
896:
897: x_return_status := G_RET_STS_ERROR;
898:
899: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 899: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

895: WHEN OKL_API.G_EXCEPTION_ERROR THEN
896:
897: x_return_status := G_RET_STS_ERROR;
898:
899: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
900:
901: x_return_status := G_RET_STS_UNEXP_ERROR;
902:
903: WHEN OTHERS THEN

Line 905: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

901: x_return_status := G_RET_STS_UNEXP_ERROR;
902:
903: WHEN OTHERS THEN
904:
905: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
906: p_msg_name => G_DB_ERROR,
907: p_token1 => G_PROG_NAME_TOKEN,
908: p_token1_value => l_prog_name,
909: p_token2 => G_SQLCODE_TOKEN,

Line 959: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

955:
956: IF (lock_csr%ISOPEN) THEN
957: CLOSE lock_csr;
958: END IF;
959: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
960: p_msg_name => G_OVN_ERROR2,
961: p_token1 => G_PROG_NAME_TOKEN,
962: p_token1_value => l_prog_name);
963: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 963: RAISE OKL_API.G_EXCEPTION_ERROR;

959: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
960: p_msg_name => G_OVN_ERROR2,
961: p_token1 => G_PROG_NAME_TOKEN,
962: p_token1_value => l_prog_name);
963: RAISE OKL_API.G_EXCEPTION_ERROR;
964: END;
965:
966: IF l_object_version_number IS NULL THEN
967:

Line 974: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

970: CLOSE lchk_csr;
971:
972: IF lc_object_version_number IS NULL THEN
973:
974: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
975: p_msg_name => G_OVN_ERROR3,
976: p_token1 => G_PROG_NAME_TOKEN,
977: p_token1_value => l_prog_name);
978:

Line 981: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

977: p_token1_value => l_prog_name);
978:
979: ELSIF lc_object_version_number <> p_cdj_rec.object_version_number THEN
980:
981: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
982: p_msg_name => G_OVN_ERROR,
983: p_token1 => G_PROG_NAME_TOKEN,
984: p_token1_value => l_prog_name);
985:

Line 988: RAISE OKL_API.G_EXCEPTION_ERROR;

984: p_token1_value => l_prog_name);
985:
986: END IF;
987:
988: RAISE OKL_API.G_EXCEPTION_ERROR;
989:
990: END IF;
991:
992: x_return_status := G_RET_STS_SUCCESS;

Line 996: WHEN OKL_API.G_EXCEPTION_ERROR THEN

992: x_return_status := G_RET_STS_SUCCESS;
993:
994: EXCEPTION
995:
996: WHEN OKL_API.G_EXCEPTION_ERROR THEN
997:
998: x_return_status := G_RET_STS_ERROR;
999:
1000: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1000: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

996: WHEN OKL_API.G_EXCEPTION_ERROR THEN
997:
998: x_return_status := G_RET_STS_ERROR;
999:
1000: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1001:
1002: x_return_status := G_RET_STS_UNEXP_ERROR;
1003:
1004: WHEN OTHERS THEN

Line 1006: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1002: x_return_status := G_RET_STS_UNEXP_ERROR;
1003:
1004: WHEN OTHERS THEN
1005:
1006: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1007: p_msg_name => G_DB_ERROR,
1008: p_token1 => G_PROG_NAME_TOKEN,
1009: p_token1_value => l_prog_name,
1010: p_token2 => G_SQLCODE_TOKEN,

Line 1036: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1032:
1033: lock_row (x_return_status => l_return_status, p_cdj_rec => p_cdj_rec);
1034:
1035: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1036: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1037: ELSIF l_return_status = G_RET_STS_ERROR THEN
1038: RAISE OKL_API.G_EXCEPTION_ERROR;
1039: END IF;
1040:

Line 1038: RAISE OKL_API.G_EXCEPTION_ERROR;

1034:
1035: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1036: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1037: ELSIF l_return_status = G_RET_STS_ERROR THEN
1038: RAISE OKL_API.G_EXCEPTION_ERROR;
1039: END IF;
1040:
1041: UPDATE okl_cost_adjustments_b
1042: SET

Line 1080: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1076: x_return_status := l_return_status;
1077:
1078: EXCEPTION
1079:
1080: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1081: x_return_status := G_RET_STS_ERROR;
1082:
1083: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1084: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1083: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1079:
1080: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1081: x_return_status := G_RET_STS_ERROR;
1082:
1083: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1084: x_return_status := G_RET_STS_UNEXP_ERROR;
1085:
1086: WHEN OTHERS THEN
1087: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 1087: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1083: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1084: x_return_status := G_RET_STS_UNEXP_ERROR;
1085:
1086: WHEN OTHERS THEN
1087: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1088: p_msg_name => G_DB_ERROR,
1089: p_token1 => G_PROG_NAME_TOKEN,
1090: p_token1_value => l_prog_name,
1091: p_token2 => G_SQLCODE_TOKEN,

Line 1135: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1131: EXCEPTION
1132:
1133: WHEN OTHERS THEN
1134:
1135: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1136: p_msg_name => G_DB_ERROR,
1137: p_token1 => G_PROG_NAME_TOKEN,
1138: p_token1_value => l_prog_name,
1139: p_token2 => G_SQLCODE_TOKEN,

Line 1182: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1178: x_cdjv_rec := p_cdjv_rec;
1179: l_db_cdjv_rec := get_rec (p_cdjv_rec.id, l_return_status);
1180:
1181: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1182: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1183: ELSIF l_return_status = G_RET_STS_ERROR THEN
1184: RAISE OKL_API.G_EXCEPTION_ERROR;
1185: END IF;
1186:

Line 1184: RAISE OKL_API.G_EXCEPTION_ERROR;

1180:
1181: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1182: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1183: ELSIF l_return_status = G_RET_STS_ERROR THEN
1184: RAISE OKL_API.G_EXCEPTION_ERROR;
1185: END IF;
1186:
1187: IF x_cdjv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1188: x_cdjv_rec.attribute_category := l_db_cdjv_rec.attribute_category;

Line 1283: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1279: RETURN l_return_status;
1280:
1281: EXCEPTION
1282:
1283: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1284:
1285: x_return_status := G_RET_STS_ERROR;
1286:
1287: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1287: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1283: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1284:
1285: x_return_status := G_RET_STS_ERROR;
1286:
1287: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1288:
1289: x_return_status := G_RET_STS_UNEXP_ERROR;
1290:
1291: WHEN OTHERS THEN

Line 1293: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1289: x_return_status := G_RET_STS_UNEXP_ERROR;
1290:
1291: WHEN OTHERS THEN
1292:
1293: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1294: p_msg_name => G_DB_ERROR,
1295: p_token1 => G_PROG_NAME_TOKEN,
1296: p_token1_value => l_prog_name,
1297: p_token2 => G_SQLCODE_TOKEN,

Line 1313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1309:
1310: l_return_status := populate_new_record (p_cdjv_rec, l_cdjv_rec);
1311:
1312: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1314: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1315: RAISE OKL_API.G_EXCEPTION_ERROR;
1316: END IF;
1317:

Line 1315: RAISE OKL_API.G_EXCEPTION_ERROR;

1311:
1312: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1314: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1315: RAISE OKL_API.G_EXCEPTION_ERROR;
1316: END IF;
1317:
1318: l_return_status := validate_attributes (l_cdjv_rec);
1319:

Line 1321: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1317:
1318: l_return_status := validate_attributes (l_cdjv_rec);
1319:
1320: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1321: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1322: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1323: RAISE OKL_API.G_EXCEPTION_ERROR;
1324: END IF;
1325:

Line 1323: RAISE OKL_API.G_EXCEPTION_ERROR;

1319:
1320: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1321: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1322: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1323: RAISE OKL_API.G_EXCEPTION_ERROR;
1324: END IF;
1325:
1326: l_return_status := validate_record (l_cdjv_rec);
1327:

Line 1329: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1325:
1326: l_return_status := validate_record (l_cdjv_rec);
1327:
1328: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1329: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1330: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1331: RAISE OKL_API.G_EXCEPTION_ERROR;
1332: END IF;
1333:

Line 1331: RAISE OKL_API.G_EXCEPTION_ERROR;

1327:
1328: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1329: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1330: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1331: RAISE OKL_API.G_EXCEPTION_ERROR;
1332: END IF;
1333:
1334: migrate (l_cdjv_rec, l_cdj_rec);
1335: migrate (l_cdjv_rec, l_cdjtl_rec);

Line 1340: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1336:
1337: update_row (x_return_status => l_return_status, p_cdj_rec => l_cdj_rec);
1338:
1339: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1340: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1341: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1342: RAISE OKL_API.G_EXCEPTION_ERROR;
1343: END IF;
1344:

Line 1342: RAISE OKL_API.G_EXCEPTION_ERROR;

1338:
1339: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1340: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1341: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1342: RAISE OKL_API.G_EXCEPTION_ERROR;
1343: END IF;
1344:
1345: update_row (x_return_status => l_return_status, p_cdjtl_rec => l_cdjtl_rec);
1346:

Line 1348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1344:
1345: update_row (x_return_status => l_return_status, p_cdjtl_rec => l_cdjtl_rec);
1346:
1347: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1349: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1350: RAISE OKL_API.G_EXCEPTION_ERROR;
1351: END IF;
1352:

Line 1350: RAISE OKL_API.G_EXCEPTION_ERROR;

1346:
1347: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1349: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1350: RAISE OKL_API.G_EXCEPTION_ERROR;
1351: END IF;
1352:
1353: x_return_status := l_return_status;
1354: x_cdjv_rec := l_cdjv_rec;

Line 1358: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1354: x_cdjv_rec := l_cdjv_rec;
1355:
1356: EXCEPTION
1357:
1358: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1359:
1360: x_return_status := G_RET_STS_ERROR;
1361:
1362: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1362: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1358: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1359:
1360: x_return_status := G_RET_STS_ERROR;
1361:
1362: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1363:
1364: x_return_status := G_RET_STS_UNEXP_ERROR;
1365:
1366: WHEN OTHERS THEN

Line 1368: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1364: x_return_status := G_RET_STS_UNEXP_ERROR;
1365:
1366: WHEN OTHERS THEN
1367:
1368: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1369: p_msg_name => G_DB_ERROR,
1370: p_token1 => G_PROG_NAME_TOKEN,
1371: p_token1_value => l_prog_name,
1372: p_token2 => G_SQLCODE_TOKEN,

Line 1411: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1407: p_cdjv_rec => p_cdjv_rec,
1408: x_cdjv_rec => x_cdjv_rec);
1409:
1410: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1411: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1412: ELSIF l_return_status = G_RET_STS_ERROR THEN
1413: RAISE OKL_API.G_EXCEPTION_ERROR;
1414: END IF;
1415:

Line 1413: RAISE OKL_API.G_EXCEPTION_ERROR;

1409:
1410: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1411: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1412: ELSIF l_return_status = G_RET_STS_ERROR THEN
1413: RAISE OKL_API.G_EXCEPTION_ERROR;
1414: END IF;
1415:
1416: x_return_status := l_return_status;
1417:

Line 1420: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1416: x_return_status := l_return_status;
1417:
1418: EXCEPTION
1419:
1420: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1421:
1422: x_return_status := G_RET_STS_ERROR;
1423:
1424: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1424: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1420: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1421:
1422: x_return_status := G_RET_STS_ERROR;
1423:
1424: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1425:
1426: x_return_status := G_RET_STS_UNEXP_ERROR;
1427:
1428: WHEN OTHERS THEN

Line 1430: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1426: x_return_status := G_RET_STS_UNEXP_ERROR;
1427:
1428: WHEN OTHERS THEN
1429:
1430: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1431: p_msg_name => G_DB_ERROR,
1432: p_token1 => G_PROG_NAME_TOKEN,
1433: p_token1_value => l_prog_name,
1434: p_token2 => G_SQLCODE_TOKEN,

Line 1482: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1478: p_cdjv_rec => p_cdjv_tbl(i),
1479: x_cdjv_rec => x_cdjv_tbl(i));
1480:
1481: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1482: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1483: ELSIF l_return_status = G_RET_STS_ERROR THEN
1484: RAISE OKL_API.G_EXCEPTION_ERROR;
1485: END IF;
1486:

Line 1484: RAISE OKL_API.G_EXCEPTION_ERROR;

1480:
1481: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1482: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1483: ELSIF l_return_status = G_RET_STS_ERROR THEN
1484: RAISE OKL_API.G_EXCEPTION_ERROR;
1485: END IF;
1486:
1487: EXIT WHEN (i = p_cdjv_tbl.LAST);
1488: i := p_cdjv_tbl.NEXT(i);

Line 1504: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1500: x_return_status := l_return_status;
1501:
1502: EXCEPTION
1503:
1504: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1505:
1506: x_return_status := G_RET_STS_ERROR;
1507:
1508: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1508: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1504: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1505:
1506: x_return_status := G_RET_STS_ERROR;
1507:
1508: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1509:
1510: x_return_status := G_RET_STS_UNEXP_ERROR;
1511:
1512: WHEN OTHERS THEN

Line 1514: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1510: x_return_status := G_RET_STS_UNEXP_ERROR;
1511:
1512: WHEN OTHERS THEN
1513:
1514: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1515: p_msg_name => G_DB_ERROR,
1516: p_token1 => G_PROG_NAME_TOKEN,
1517: p_token1_value => l_prog_name,
1518: p_token2 => G_SQLCODE_TOKEN,

Line 1550: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1546: EXCEPTION
1547:
1548: WHEN OTHERS THEN
1549:
1550: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1551: p_msg_name => G_DB_ERROR,
1552: p_token1 => G_PROG_NAME_TOKEN,
1553: p_token1_value => l_prog_name,
1554: p_token2 => G_SQLCODE_TOKEN,

Line 1591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1587: delete_row (x_return_status => l_return_status,
1588: p_id => p_cdjv_rec.id);
1589:
1590: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1592: ELSIF l_return_status = G_RET_STS_ERROR THEN
1593: RAISE OKL_API.G_EXCEPTION_ERROR;
1594: END IF;
1595:

Line 1593: RAISE OKL_API.G_EXCEPTION_ERROR;

1589:
1590: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1592: ELSIF l_return_status = G_RET_STS_ERROR THEN
1593: RAISE OKL_API.G_EXCEPTION_ERROR;
1594: END IF;
1595:
1596: x_return_status := l_return_status;
1597:

Line 1600: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1596: x_return_status := l_return_status;
1597:
1598: EXCEPTION
1599:
1600: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1601:
1602: x_return_status := G_RET_STS_ERROR;
1603:
1604: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1604: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1600: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1601:
1602: x_return_status := G_RET_STS_ERROR;
1603:
1604: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1605:
1606: x_return_status := G_RET_STS_UNEXP_ERROR;
1607:
1608: WHEN OTHERS THEN

Line 1610: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1606: x_return_status := G_RET_STS_UNEXP_ERROR;
1607:
1608: WHEN OTHERS THEN
1609:
1610: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1611: p_msg_name => G_DB_ERROR,
1612: p_token1 => G_PROG_NAME_TOKEN,
1613: p_token1_value => l_prog_name,
1614: p_token2 => G_SQLCODE_TOKEN,

Line 1660: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1656: delete_row (x_return_status => l_return_status,
1657: p_id => p_cdjv_tbl(i).id);
1658:
1659: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1660: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1661: ELSIF l_return_status = G_RET_STS_ERROR THEN
1662: RAISE OKL_API.G_EXCEPTION_ERROR;
1663: END IF;
1664:

Line 1662: RAISE OKL_API.G_EXCEPTION_ERROR;

1658:
1659: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1660: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1661: ELSIF l_return_status = G_RET_STS_ERROR THEN
1662: RAISE OKL_API.G_EXCEPTION_ERROR;
1663: END IF;
1664:
1665: EXIT WHEN (i = p_cdjv_tbl.LAST);
1666: i := p_cdjv_tbl.NEXT(i);

Line 1684: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1680: EXCEPTION
1681:
1682: WHEN OTHERS THEN
1683:
1684: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1685: p_msg_name => G_DB_ERROR,
1686: p_token1 => G_PROG_NAME_TOKEN,
1687: p_token1_value => l_prog_name,
1688: p_token2 => G_SQLCODE_TOKEN,