DBA Data[Home] [Help]

APPS.IBC_CV_LABEL_GRP dependencies on IBC_UTILITIES_PVT

Line 174: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(

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

Line 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

Line 187: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(

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

Line 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

Line 200: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(

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

Line 203: ,P_EXCEPTION_LEVEL => Ibc_Utilities_Pvt.G_EXC_OTHERS

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

Line 204: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT

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

Line 374: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(

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

Line 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

Line 387: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(

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

Line 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

Line 400: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(

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

Line 403: ,P_EXCEPTION_LEVEL => Ibc_Utilities_Pvt.G_EXC_OTHERS

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

Line 404: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT

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

Line 511: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(

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

Line 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

Line 524: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(

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

Line 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

Line 537: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(

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

Line 540: ,P_EXCEPTION_LEVEL => Ibc_Utilities_Pvt.G_EXC_OTHERS

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

Line 541: ,P_PACKAGE_TYPE => Ibc_Utilities_Pvt.G_PVT

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

Line 791: Ibc_Utilities_Pvt.handle_exceptions(

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

Line 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

Line 806: Ibc_Utilities_Pvt.handle_exceptions(

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

Line 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

Line 821: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(

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

Line 824: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS

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

Line 825: ,p_package_type => Ibc_Utilities_Pvt.G_PVT

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

Line 983: Ibc_Utilities_Pvt.handle_exceptions(

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

Line 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

Line 998: Ibc_Utilities_Pvt.handle_exceptions(

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

Line 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

Line 1013: Ibc_Utilities_Pvt.HANDLE_EXCEPTIONS(

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

Line 1016: ,p_exception_level => Ibc_Utilities_Pvt.G_EXC_OTHERS

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

Line 1017: ,p_package_type => Ibc_Utilities_Pvt.G_PVT

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