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_CS_TRANSACTIONS_PVT dependencies on OKL_API

Line 63: x_return_status := OKL_API.G_RET_STS_SUCCESS;

59: DBMS_SQL.COLUMN_VALUE(l_cursor, 4, x_credit_total);
60: DBMS_SQL.COLUMN_VALUE(l_cursor, 5, x_adjust_total);
61: END IF;
62:
63: x_return_status := OKL_API.G_RET_STS_SUCCESS;
64:
65: ELSIF l_rows = 0 THEN
66:
67: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 67: x_return_status := OKL_API.G_RET_STS_ERROR;

63: x_return_status := OKL_API.G_RET_STS_SUCCESS;
64:
65: ELSIF l_rows = 0 THEN
66:
67: x_return_status := OKL_API.G_RET_STS_ERROR;
68:
69: END IF;
70:
71: x_row_count := l_rows;

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

74: EXCEPTION
75:
76: WHEN OTHERS THEN
77:
78: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
79: p_msg_name => G_UNEXPECTED_ERROR,
80: p_token1 => G_SQLCODE_TOKEN,
81: p_token1_value => SQLCODE,
82: p_token2 => G_SQLERRM_TOKEN,

Line 85: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

81: p_token1_value => SQLCODE,
82: p_token2 => G_SQLERRM_TOKEN,
83: p_token2_value => SQLERRM);
84:
85: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
86: DBMS_SQL.CLOSE_CURSOR(l_cursor);
87:
88: END get_totals;
89:

Line 141: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

137:
138: IF (l_svf_applicable = '?') OR (l_svf_applicable = 'N') THEN
139: RETURN;
140: ELSIF (l_svf_applicable = 'Y') THEN
141: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
142: END IF;
143:
144: OPEN c_svf_info;
145: FETCH c_svf_info INTO x_svf_info_rec;

Line 148: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

144: OPEN c_svf_info;
145: FETCH c_svf_info INTO x_svf_info_rec;
146: CLOSE c_svf_info;
147: IF x_svf_info_rec.SVF_ID IS NOT NULL THEN
148: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
149: END IF;
150:
151: x_return_status := OKL_API.G_RET_STS_SUCCESS;
152:

Line 151: x_return_status := OKL_API.G_RET_STS_SUCCESS;

147: IF x_svf_info_rec.SVF_ID IS NOT NULL THEN
148: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
149: END IF;
150:
151: x_return_status := OKL_API.G_RET_STS_SUCCESS;
152:
153: EXCEPTION
154:
155: WHEN OTHERS THEN

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

153: EXCEPTION
154:
155: WHEN OTHERS THEN
156:
157: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
158: p_msg_name => G_UNEXPECTED_ERROR,
159: p_token1 => G_SQLCODE_TOKEN,
160: p_token1_value => SQLCODE,
161: p_token2 => G_SQLERRM_TOKEN,

Line 164: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

160: p_token1_value => SQLCODE,
161: p_token2 => G_SQLERRM_TOKEN,
162: p_token2_value => SQLERRM);
163:
164: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
165:
166: END get_svf_info;
167:
168:

Line 383: x_return_status := OKL_API.G_RET_STS_SUCCESS;

379: --END IF;
380:
381:
382:
383: x_return_status := OKL_API.G_RET_STS_SUCCESS;
384:
385: EXCEPTION
386:
387: WHEN OTHERS THEN

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

385: EXCEPTION
386:
387: WHEN OTHERS THEN
388:
389: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
390: p_msg_name => G_UNEXPECTED_ERROR,
391: p_token1 => G_SQLCODE_TOKEN,
392: p_token1_value => SQLCODE,
393: p_token2 => G_SQLERRM_TOKEN,

Line 396: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

392: p_token1_value => SQLCODE,
393: p_token2 => G_SQLERRM_TOKEN,
394: p_token2_value => SQLERRM);
395:
396: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
397:
398: END get_credit_memo_info;
399:
400:

Line 432: x_return_status := OKL_API.G_RET_STS_SUCCESS;

428:
429: OPEN c_ptm;
430: FETCH c_ptm INTO l_dummy;
431: IF c_ptm%FOUND THEN
432: x_return_status := OKL_API.G_RET_STS_SUCCESS;
433: ELSE
434: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
435: END IF;
436:

Line 434: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

430: FETCH c_ptm INTO l_dummy;
431: IF c_ptm%FOUND THEN
432: x_return_status := OKL_API.G_RET_STS_SUCCESS;
433: ELSE
434: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
435: END IF;
436:
437: CLOSE c_ptm;
438:

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

439: EXCEPTION
440:
441: WHEN OTHERS THEN
442:
443: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
444: p_msg_name => G_UNEXPECTED_ERROR,
445: p_token1 => G_SQLCODE_TOKEN,
446: p_token1_value => SQLCODE,
447: p_token2 => G_SQLERRM_TOKEN,

Line 450: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

446: p_token1_value => SQLCODE,
447: p_token2 => G_SQLERRM_TOKEN,
448: p_token2_value => SQLERRM);
449:
450: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
451:
452: END check_process_template;
453:
454:

Line 489: x_return_status := OKL_API.G_RET_STS_SUCCESS;

485: x_email := -1;
486: END IF;
487: CLOSE c_email;
488:
489: x_return_status := OKL_API.G_RET_STS_SUCCESS;
490:
491: EXCEPTION
492:
493: WHEN OTHERS THEN

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

491: EXCEPTION
492:
493: WHEN OTHERS THEN
494:
495: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
496: p_msg_name => G_UNEXPECTED_ERROR,
497: p_token1 => G_SQLCODE_TOKEN,
498: p_token1_value => SQLCODE,
499: p_token2 => G_SQLERRM_TOKEN,

Line 502: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

498: p_token1_value => SQLCODE,
499: p_token2 => G_SQLERRM_TOKEN,
500: p_token2_value => SQLERRM);
501:
502: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
503:
504: END get_pvt_label_email;
505:
506:

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

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

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

589:
590: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
591: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
592: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
593: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
594: p_msg_name => 'OKL_NO_STREAM_TYPE',
595: p_token1 => OKL_API.G_COL_NAME_TOKEN,
596: p_token1_value => p_sty_purpose);
597:

Line 595: p_token1 => OKL_API.G_COL_NAME_TOKEN,

591: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
592: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
593: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
594: p_msg_name => 'OKL_NO_STREAM_TYPE',
595: p_token1 => OKL_API.G_COL_NAME_TOKEN,
596: p_token1_value => p_sty_purpose);
597:
598: RAISE OKC_API.G_EXCEPTION_ERROR;
599: END IF;

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

603: EXCEPTION
604:
605: WHEN OTHERS THEN
606:
607: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
608: p_msg_name => G_UNEXPECTED_ERROR,
609: p_token1 => G_SQLCODE_TOKEN,
610: p_token1_value => SQLCODE,
611: p_token2 => G_SQLERRM_TOKEN,

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

648: EXCEPTION
649:
650: WHEN OTHERS THEN
651:
652: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
653: p_msg_name => G_UNEXPECTED_ERROR,
654: p_token1 => G_SQLCODE_TOKEN,
655: p_token1_value => SQLCODE,
656: p_token2 => G_SQLERRM_TOKEN,

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

691: EXCEPTION
692:
693: WHEN OTHERS THEN
694:
695: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
696: p_msg_name => G_UNEXPECTED_ERROR,
697: p_token1 => G_SQLCODE_TOKEN,
698: p_token1_value => SQLCODE,
699: p_token2 => G_SQLERRM_TOKEN,

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

755: EXCEPTION
756:
757: WHEN OTHERS THEN
758:
759: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
760: p_msg_name => G_UNEXPECTED_ERROR,
761: p_token1 => G_SQLCODE_TOKEN,
762: p_token1_value => SQLCODE,
763: p_token2 => G_SQLERRM_TOKEN,

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

810: l_factoring_code VARCHAR2(30);
811:
812: l_api_version CONSTANT NUMBER := 1;
813: l_init_msg_list CONSTANT CHAR := 'F';
814: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
815: l_line_number CONSTANT NUMBER := 1;
816:
817: -- Invoice Header
818: i_taiv_rec okl_trx_ar_invoices_pub.taiv_rec_type;

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

838: l_syndication_code := p_syndication_code;
839: l_factoring_code := p_factoring_code;
840:
841: IF (l_syndication_code IS NOT NULL) AND (l_factoring_code IS NOT NULL) THEN
842: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
843: p_msg_name => 'OKL_SYND_FACTOR_EXCLUSIVE');
844: RAISE OKL_API.G_EXCEPTION_ERROR;
845: END IF;
846:

Line 844: RAISE OKL_API.G_EXCEPTION_ERROR;

840:
841: IF (l_syndication_code IS NOT NULL) AND (l_factoring_code IS NOT NULL) THEN
842: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
843: p_msg_name => 'OKL_SYND_FACTOR_EXCLUSIVE');
844: RAISE OKL_API.G_EXCEPTION_ERROR;
845: END IF;
846:
847: l_sysdate := TRUNC(SYSDATE);
848: l_khr_id := p_khr_id;

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

856: l_svf_id := get_svf_id (l_svf_code);
857: l_pdt_id := get_pdt_id (l_khr_id);
858:
859: IF l_pdt_id IS NULL THEN
860: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
861: p_msg_name => 'OKL_NO_PRODUCT_FOUND');
862: RAISE OKL_API.G_EXCEPTION_ERROR;
863: END IF;
864:

Line 862: RAISE OKL_API.G_EXCEPTION_ERROR;

858:
859: IF l_pdt_id IS NULL THEN
860: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
861: p_msg_name => 'OKL_NO_PRODUCT_FOUND');
862: RAISE OKL_API.G_EXCEPTION_ERROR;
863: END IF;
864:
865: --l_factoring_synd := get_factor_synd(l_khr_id);
866: l_factoring_synd := NULL; -- BUG 2451833

Line 900: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

896: x_msg_data => x_msg_data,
897: p_taiv_rec => i_taiv_rec,
898: x_taiv_rec => r_taiv_rec);
899:
900: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
902: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
903: RAISE OKL_API.G_EXCEPTION_ERROR;
904: END IF;

Line 901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

897: p_taiv_rec => i_taiv_rec,
898: x_taiv_rec => r_taiv_rec);
899:
900: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
902: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
903: RAISE OKL_API.G_EXCEPTION_ERROR;
904: END IF;
905:

Line 902: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

898: x_taiv_rec => r_taiv_rec);
899:
900: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
902: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
903: RAISE OKL_API.G_EXCEPTION_ERROR;
904: END IF;
905:
906: ----------------------------------------------------------------------------------

Line 903: RAISE OKL_API.G_EXCEPTION_ERROR;

899:
900: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
902: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
903: RAISE OKL_API.G_EXCEPTION_ERROR;
904: END IF;
905:
906: ----------------------------------------------------------------------------------
907: -- Prepare Invoice Line

Line 934: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

930: x_msg_data => x_msg_data,
931: p_tilv_rec => i_tilv_rec,
932: x_tilv_rec => r_tilv_rec);
933:
934: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
937: RAISE OKL_API.G_EXCEPTION_ERROR;
938: END IF;

Line 935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

931: p_tilv_rec => i_tilv_rec,
932: x_tilv_rec => r_tilv_rec);
933:
934: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
937: RAISE OKL_API.G_EXCEPTION_ERROR;
938: END IF;
939:

Line 936: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

932: x_tilv_rec => r_tilv_rec);
933:
934: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
937: RAISE OKL_API.G_EXCEPTION_ERROR;
938: END IF;
939:
940: --Commented the following lines to call the Accounting Wrapper API.

Line 937: RAISE OKL_API.G_EXCEPTION_ERROR;

933:
934: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
937: RAISE OKL_API.G_EXCEPTION_ERROR;
938: END IF;
939:
940: --Commented the following lines to call the Accounting Wrapper API.
941: --The commented call does not take into account the dynamically

Line 992: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

988: p_acc_gen_primary_key_tbl => l_acc_gen_primary_key_tbl,
989: x_template_tbl => lx_template_tbl,
990: x_amount_tbl => lx_amount_tbl);
991:
992: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
993: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
994: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
995: RAISE OKL_API.G_EXCEPTION_ERROR;
996: END IF;

Line 993: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

989: x_template_tbl => lx_template_tbl,
990: x_amount_tbl => lx_amount_tbl);
991:
992: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
993: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
994: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
995: RAISE OKL_API.G_EXCEPTION_ERROR;
996: END IF;
997:

Line 994: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

990: x_amount_tbl => lx_amount_tbl);
991:
992: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
993: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
994: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
995: RAISE OKL_API.G_EXCEPTION_ERROR;
996: END IF;
997:
998: */

Line 995: RAISE OKL_API.G_EXCEPTION_ERROR;

991:
992: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
993: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
994: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
995: RAISE OKL_API.G_EXCEPTION_ERROR;
996: END IF;
997:
998: */
999:

Line 1018: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1014: ,x_msg_data => x_msg_data
1015: ,p_bpd_acc_rec => l_bpd_acc_rec);
1016:
1017:
1018: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1020: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1021: RAISE OKL_API.G_EXCEPTION_ERROR;
1022: END IF;

Line 1019: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1015: ,p_bpd_acc_rec => l_bpd_acc_rec);
1016:
1017:
1018: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1020: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1021: RAISE OKL_API.G_EXCEPTION_ERROR;
1022: END IF;
1023:

Line 1020: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1016:
1017:
1018: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1020: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1021: RAISE OKL_API.G_EXCEPTION_ERROR;
1022: END IF;
1023:
1024:

Line 1021: RAISE OKL_API.G_EXCEPTION_ERROR;

1017:
1018: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1020: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1021: RAISE OKL_API.G_EXCEPTION_ERROR;
1022: END IF;
1023:
1024:
1025: x_tai_id := r_taiv_rec.id;

Line 1031: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1027:
1028:
1029: EXCEPTION
1030:
1031: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1032:
1033: x_return_status := OKL_API.G_RET_STS_ERROR;
1034:
1035: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1033: x_return_status := OKL_API.G_RET_STS_ERROR;

1029: EXCEPTION
1030:
1031: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1032:
1033: x_return_status := OKL_API.G_RET_STS_ERROR;
1034:
1035: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1036:
1037: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1035: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1031: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1032:
1033: x_return_status := OKL_API.G_RET_STS_ERROR;
1034:
1035: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1036:
1037: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1038:
1039: WHEN OTHERS THEN

Line 1037: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1033: x_return_status := OKL_API.G_RET_STS_ERROR;
1034:
1035: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1036:
1037: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1038:
1039: WHEN OTHERS THEN
1040:
1041: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1037: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1038:
1039: WHEN OTHERS THEN
1040:
1041: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1042: p_msg_name => G_UNEXPECTED_ERROR,
1043: p_token1 => G_SQLCODE_TOKEN,
1044: p_token1_value => SQLCODE,
1045: p_token2 => G_SQLERRM_TOKEN,

Line 1048: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1044: p_token1_value => SQLCODE,
1045: p_token2 => G_SQLERRM_TOKEN,
1046: p_token2_value => SQLERRM);
1047:
1048: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1049:
1050: END create_svf_invoice;
1051:
1052: END okl_cs_transactions_pvt;