170:
171: EXCEPTION
172: WHEN Fnd_Api.G_EXC_ERROR THEN
173: ROLLBACK;
174: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
175: P_API_NAME => L_API_NAME
176: ,P_PKG_NAME => G_PKG_NAME
177: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
178: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
174: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
175: P_API_NAME => L_API_NAME
176: ,P_PKG_NAME => G_PKG_NAME
177: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
178: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
179: ,P_SQLCODE => SQLCODE
180: ,P_SQLERRM => SQLERRM
181: ,X_MSG_COUNT => X_MSG_COUNT
182: ,X_MSG_DATA => X_MSG_DATA
183: ,X_RETURN_STATUS => X_RETURN_STATUS);
184:
185: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
186: ROLLBACK;
187: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
188: P_API_NAME => L_API_NAME
189: ,P_PKG_NAME => G_PKG_NAME
190: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
191: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
187: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
188: P_API_NAME => L_API_NAME
189: ,P_PKG_NAME => G_PKG_NAME
190: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
191: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
192: ,P_SQLCODE => SQLCODE
193: ,P_SQLERRM => SQLERRM
194: ,X_MSG_COUNT => X_MSG_COUNT
195: ,X_MSG_DATA => X_MSG_DATA
196: ,X_RETURN_STATUS => X_RETURN_STATUS);
197:
198: WHEN OTHERS THEN
199: ROLLBACK;
200: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
201: P_API_NAME => L_API_NAME
202: ,P_PKG_NAME => G_PKG_NAME
203: ,P_EXCEPTION_LEVEL => Ibc_Utilities_Pvt.G_EXC_OTHERS
204: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
199: ROLLBACK;
200: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
201: P_API_NAME => L_API_NAME
202: ,P_PKG_NAME => G_PKG_NAME
203: ,P_EXCEPTION_LEVEL => Ibc_Utilities_Pvt.G_EXC_OTHERS
204: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
205: ,P_SQLCODE => SQLCODE
206: ,P_SQLERRM => SQLERRM
207: ,X_MSG_COUNT => X_MSG_COUNT
200: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
201: P_API_NAME => L_API_NAME
202: ,P_PKG_NAME => G_PKG_NAME
203: ,P_EXCEPTION_LEVEL => Ibc_Utilities_Pvt.G_EXC_OTHERS
204: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
205: ,P_SQLCODE => SQLCODE
206: ,P_SQLERRM => SQLERRM
207: ,X_MSG_COUNT => X_MSG_COUNT
208: ,X_MSG_DATA => X_MSG_DATA
370:
371: EXCEPTION
372: WHEN Fnd_Api.G_EXC_ERROR THEN
373: ROLLBACK;
374: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
375: P_API_NAME => L_API_NAME
376: ,P_PKG_NAME => G_PKG_NAME
377: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
378: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
374: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
375: P_API_NAME => L_API_NAME
376: ,P_PKG_NAME => G_PKG_NAME
377: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
378: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
379: ,P_SQLCODE => SQLCODE
380: ,P_SQLERRM => SQLERRM
381: ,X_MSG_COUNT => X_MSG_COUNT
382: ,X_MSG_DATA => X_MSG_DATA
383: ,X_RETURN_STATUS => X_RETURN_STATUS);
384:
385: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
386: ROLLBACK;
387: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
388: P_API_NAME => L_API_NAME
389: ,P_PKG_NAME => G_PKG_NAME
390: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
391: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
387: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
388: P_API_NAME => L_API_NAME
389: ,P_PKG_NAME => G_PKG_NAME
390: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
391: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
392: ,P_SQLCODE => SQLCODE
393: ,P_SQLERRM => SQLERRM
394: ,X_MSG_COUNT => X_MSG_COUNT
395: ,X_MSG_DATA => X_MSG_DATA
396: ,X_RETURN_STATUS => X_RETURN_STATUS);
397:
398: WHEN OTHERS THEN
399: ROLLBACK;
400: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
401: P_API_NAME => L_API_NAME
402: ,P_PKG_NAME => G_PKG_NAME
403: ,P_EXCEPTION_LEVEL => Ibc_Utilities_Pvt.G_EXC_OTHERS
404: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
399: ROLLBACK;
400: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
401: P_API_NAME => L_API_NAME
402: ,P_PKG_NAME => G_PKG_NAME
403: ,P_EXCEPTION_LEVEL => Ibc_Utilities_Pvt.G_EXC_OTHERS
404: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
405: ,P_SQLCODE => SQLCODE
406: ,P_SQLERRM => SQLERRM
407: ,X_MSG_COUNT => X_MSG_COUNT
400: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
401: P_API_NAME => L_API_NAME
402: ,P_PKG_NAME => G_PKG_NAME
403: ,P_EXCEPTION_LEVEL => Ibc_Utilities_Pvt.G_EXC_OTHERS
404: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
405: ,P_SQLCODE => SQLCODE
406: ,P_SQLERRM => SQLERRM
407: ,X_MSG_COUNT => X_MSG_COUNT
408: ,X_MSG_DATA => X_MSG_DATA
507:
508: EXCEPTION
509: WHEN Fnd_Api.G_EXC_ERROR THEN
510: ROLLBACK;
511: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
512: P_API_NAME => L_API_NAME
513: ,P_PKG_NAME => G_PKG_NAME
514: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
515: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
511: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
512: P_API_NAME => L_API_NAME
513: ,P_PKG_NAME => G_PKG_NAME
514: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_ERROR
515: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
516: ,P_SQLCODE => SQLCODE
517: ,P_SQLERRM => SQLERRM
518: ,X_MSG_COUNT => X_MSG_COUNT
519: ,X_MSG_DATA => X_MSG_DATA
520: ,X_RETURN_STATUS => X_RETURN_STATUS);
521:
522: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
523: ROLLBACK;
524: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
525: P_API_NAME => L_API_NAME
526: ,P_PKG_NAME => G_PKG_NAME
527: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
528: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
524: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
525: P_API_NAME => L_API_NAME
526: ,P_PKG_NAME => G_PKG_NAME
527: ,P_EXCEPTION_LEVEL => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
528: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
529: ,P_SQLCODE => SQLCODE
530: ,P_SQLERRM => SQLERRM
531: ,X_MSG_COUNT => X_MSG_COUNT
532: ,X_MSG_DATA => X_MSG_DATA
533: ,X_RETURN_STATUS => X_RETURN_STATUS);
534:
535: WHEN OTHERS THEN
536: ROLLBACK;
537: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
538: P_API_NAME => L_API_NAME
539: ,P_PKG_NAME => G_PKG_NAME
540: ,P_EXCEPTION_LEVEL => Ibc_Utilities_Pvt.G_EXC_OTHERS
541: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
536: ROLLBACK;
537: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
538: P_API_NAME => L_API_NAME
539: ,P_PKG_NAME => G_PKG_NAME
540: ,P_EXCEPTION_LEVEL => Ibc_Utilities_Pvt.G_EXC_OTHERS
541: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
542: ,P_SQLCODE => SQLCODE
543: ,P_SQLERRM => SQLERRM
544: ,X_MSG_COUNT => X_MSG_COUNT
537: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
538: P_API_NAME => L_API_NAME
539: ,P_PKG_NAME => G_PKG_NAME
540: ,P_EXCEPTION_LEVEL => Ibc_Utilities_Pvt.G_EXC_OTHERS
541: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT
542: ,P_SQLCODE => SQLCODE
543: ,P_SQLERRM => SQLERRM
544: ,X_MSG_COUNT => X_MSG_COUNT
545: ,X_MSG_DATA => X_MSG_DATA
787: EXCEPTION
788: WHEN Fnd_Api.G_EXC_ERROR THEN
789: ROLLBACK TO SVPT_UPSERT_CV_LABELS;
790: --DBMS_OUTPUT.put_line('Expected Error');
791: Ibc_Utilities_Pvt.handle_exceptions(
792: p_api_name => L_API_NAME
793: ,p_pkg_name => G_PKG_NAME
794: ,p_exception_level => Fnd_Msg_Pub.G_MSG_LVL_ERROR
795: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
791: Ibc_Utilities_Pvt.handle_exceptions(
792: p_api_name => L_API_NAME
793: ,p_pkg_name => G_PKG_NAME
794: ,p_exception_level => Fnd_Msg_Pub.G_MSG_LVL_ERROR
795: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
796: ,p_sqlcode => SQLCODE
797: ,p_sqlerrm => SQLERRM
798: ,x_msg_count => x_msg_count
799: ,x_msg_data => x_msg_data
802:
803: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
804: ROLLBACK TO SVPT_UPSERT_CV_LABELS;
805: --DBMS_OUTPUT.put_line('Unexpected error');
806: Ibc_Utilities_Pvt.handle_exceptions(
807: p_api_name => L_API_NAME
808: ,p_pkg_name => G_PKG_NAME
809: ,p_exception_level => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
810: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
806: Ibc_Utilities_Pvt.handle_exceptions(
807: p_api_name => L_API_NAME
808: ,p_pkg_name => G_PKG_NAME
809: ,p_exception_level => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
810: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
811: ,p_sqlcode => SQLCODE
812: ,p_sqlerrm => SQLERRM
813: ,x_msg_count => x_msg_count
814: ,x_msg_data => x_msg_data
817:
818: WHEN OTHERS THEN
819: ROLLBACK TO SVPT_UPSERT_CV_LABELS;
820: --DBMS_OUTPUT.put_line('Other error');
821: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
822: p_api_name => L_API_NAME
823: ,p_pkg_name => G_PKG_NAME
824: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
825: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
820: --DBMS_OUTPUT.put_line('Other error');
821: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
822: p_api_name => L_API_NAME
823: ,p_pkg_name => G_PKG_NAME
824: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
825: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
826: ,p_sqlcode => SQLCODE
827: ,p_sqlerrm => SQLERRM
828: ,x_msg_count => x_msg_count
821: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
822: p_api_name => L_API_NAME
823: ,p_pkg_name => G_PKG_NAME
824: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
825: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
826: ,p_sqlcode => SQLCODE
827: ,p_sqlerrm => SQLERRM
828: ,x_msg_count => x_msg_count
829: ,x_msg_data => x_msg_data
979: EXCEPTION
980: WHEN Fnd_Api.G_EXC_ERROR THEN
981: ROLLBACK TO SVPT_UPSERT_CV_LABELS;
982: --DBMS_OUTPUT.put_line('Expected Error');
983: Ibc_Utilities_Pvt.handle_exceptions(
984: p_api_name => L_API_NAME
985: ,p_pkg_name => G_PKG_NAME
986: ,p_exception_level => Fnd_Msg_Pub.G_MSG_LVL_ERROR
987: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
983: Ibc_Utilities_Pvt.handle_exceptions(
984: p_api_name => L_API_NAME
985: ,p_pkg_name => G_PKG_NAME
986: ,p_exception_level => Fnd_Msg_Pub.G_MSG_LVL_ERROR
987: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
988: ,p_sqlcode => SQLCODE
989: ,p_sqlerrm => SQLERRM
990: ,x_msg_count => x_msg_count
991: ,x_msg_data => x_msg_data
994:
995: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
996: ROLLBACK TO SVPT_UPSERT_CV_LABELS;
997: --DBMS_OUTPUT.put_line('Unexpected error');
998: Ibc_Utilities_Pvt.handle_exceptions(
999: p_api_name => L_API_NAME
1000: ,p_pkg_name => G_PKG_NAME
1001: ,p_exception_level => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
1002: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
998: Ibc_Utilities_Pvt.handle_exceptions(
999: p_api_name => L_API_NAME
1000: ,p_pkg_name => G_PKG_NAME
1001: ,p_exception_level => Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR
1002: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
1003: ,p_sqlcode => SQLCODE
1004: ,p_sqlerrm => SQLERRM
1005: ,x_msg_count => x_msg_count
1006: ,x_msg_data => x_msg_data
1009:
1010: WHEN OTHERS THEN
1011: ROLLBACK TO SVPT_UPSERT_CV_LABELS;
1012: --DBMS_OUTPUT.put_line('Other error');
1013: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1014: p_api_name => L_API_NAME
1015: ,p_pkg_name => G_PKG_NAME
1016: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
1017: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
1012: --DBMS_OUTPUT.put_line('Other error');
1013: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1014: p_api_name => L_API_NAME
1015: ,p_pkg_name => G_PKG_NAME
1016: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
1017: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
1018: ,p_sqlcode => SQLCODE
1019: ,p_sqlerrm => SQLERRM
1020: ,x_msg_count => x_msg_count
1013: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(
1014: p_api_name => L_API_NAME
1015: ,p_pkg_name => G_PKG_NAME
1016: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS
1017: ,p_package_type => Ibc_Utilities_Pvt.G_PVT
1018: ,p_sqlcode => SQLCODE
1019: ,p_sqlerrm => SQLERRM
1020: ,x_msg_count => x_msg_count
1021: ,x_msg_data => x_msg_data