DBA Data[Home] [Help]

APPS.ASO_SERVICE_CONTRACTS_INT dependencies on ASO_UTILITY_PVT

Line 459: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

455: );
456:
457: EXCEPTION
458: WHEN FND_API.G_EXC_ERROR THEN
459: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
460: P_API_NAME => L_API_NAME
461: ,P_PKG_NAME => G_PKG_NAME
462: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
463: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 463: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

459: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
460: P_API_NAME => L_API_NAME
461: ,P_PKG_NAME => G_PKG_NAME
462: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
463: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
464: ,P_SQLCODE => SQLCODE
465: ,P_SQLERRM => SQLERRM
466: ,X_MSG_COUNT => X_MSG_COUNT
467: ,X_MSG_DATA => X_MSG_DATA

Line 471: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

467: ,X_MSG_DATA => X_MSG_DATA
468: ,X_RETURN_STATUS => X_RETURN_STATUS);
469:
470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
471: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
472: P_API_NAME => L_API_NAME
473: ,P_PKG_NAME => G_PKG_NAME
474: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
475: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 475: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

471: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
472: P_API_NAME => L_API_NAME
473: ,P_PKG_NAME => G_PKG_NAME
474: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
475: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
476: ,P_SQLCODE => SQLCODE
477: ,P_SQLERRM => SQLERRM
478: ,X_MSG_COUNT => X_MSG_COUNT
479: ,X_MSG_DATA => X_MSG_DATA

Line 483: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

479: ,X_MSG_DATA => X_MSG_DATA
480: ,X_RETURN_STATUS => X_RETURN_STATUS);
481:
482: WHEN OTHERS THEN
483: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
484: P_API_NAME => L_API_NAME
485: ,P_PKG_NAME => G_PKG_NAME
486: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
487: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 486: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

482: WHEN OTHERS THEN
483: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
484: P_API_NAME => L_API_NAME
485: ,P_PKG_NAME => G_PKG_NAME
486: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
487: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
488: ,P_SQLCODE => SQLCODE
489: ,P_SQLERRM => SQLERRM
490: ,X_MSG_COUNT => X_MSG_COUNT

Line 487: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

483: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
484: P_API_NAME => L_API_NAME
485: ,P_PKG_NAME => G_PKG_NAME
486: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
487: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
488: ,P_SQLCODE => SQLCODE
489: ,P_SQLERRM => SQLERRM
490: ,X_MSG_COUNT => X_MSG_COUNT
491: ,X_MSG_DATA => X_MSG_DATA

Line 568: aso_utility_pvt.print_login_info();

564: END IF;
565:
566: IF aso_debug_pub.g_debug_flag = 'Y' THEN
567:
568: aso_utility_pvt.print_login_info();
569: aso_debug_pub.add('ASO_service_contracts_INT.Get_Duration: Before call OKS_OMINT_PUB.Get Duration.',1,'Y');
570: aso_debug_pub.add('Get Duration: p_customer_id: '||p_customer_id, 1, 'Y');
571: aso_debug_pub.add('Get Duration: p_system_id: '||p_system_id, 1, 'Y');
572: aso_debug_pub.add('Get Duration: p_service_duration: '||p_service_duration, 1, 'Y');

Line 605: aso_utility_pvt.print_login_info();

601: aso_debug_pub.add('Get Duration: After Call to OKS_OMINT_PUB.Get_Duration: X_return_status: '||X_return_status, 1, 'Y');
602: aso_debug_pub.add('Get Duration: x_service_duration: '||x_service_duration, 1, 'Y');
603: aso_debug_pub.add('Get Duration: x_service_period: '||x_service_period, 1, 'Y');
604: aso_debug_pub.add('Get Duration: x_new_end_date: '||x_new_end_date, 1, 'Y');
605: aso_utility_pvt.print_login_info();
606:
607: END IF;
608:
609:

Line 638: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

634: );
635:
636: EXCEPTION
637: WHEN FND_API.G_EXC_ERROR THEN
638: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
639: P_API_NAME => L_API_NAME
640: ,P_PKG_NAME => G_PKG_NAME
641: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
642: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 642: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

638: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
639: P_API_NAME => L_API_NAME
640: ,P_PKG_NAME => G_PKG_NAME
641: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
642: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
643: ,X_MSG_COUNT => X_MSG_COUNT
644: ,X_MSG_DATA => X_MSG_DATA
645: ,X_RETURN_STATUS => X_RETURN_STATUS);
646:

Line 648: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

644: ,X_MSG_DATA => X_MSG_DATA
645: ,X_RETURN_STATUS => X_RETURN_STATUS);
646:
647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
648: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
649: P_API_NAME => L_API_NAME
650: ,P_PKG_NAME => G_PKG_NAME
651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
652: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 652: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

648: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
649: P_API_NAME => L_API_NAME
650: ,P_PKG_NAME => G_PKG_NAME
651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
652: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
653: ,X_MSG_COUNT => X_MSG_COUNT
654: ,X_MSG_DATA => X_MSG_DATA
655: ,X_RETURN_STATUS => X_RETURN_STATUS);
656:

Line 658: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

654: ,X_MSG_DATA => X_MSG_DATA
655: ,X_RETURN_STATUS => X_RETURN_STATUS);
656:
657: WHEN OTHERS THEN
658: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
659: P_API_NAME => L_API_NAME
660: ,P_PKG_NAME => G_PKG_NAME
661: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
662: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 661: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

657: WHEN OTHERS THEN
658: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
659: P_API_NAME => L_API_NAME
660: ,P_PKG_NAME => G_PKG_NAME
661: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
662: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
663: ,X_MSG_COUNT => X_MSG_COUNT
664: ,X_MSG_DATA => X_MSG_DATA
665: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 662: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

658: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
659: P_API_NAME => L_API_NAME
660: ,P_PKG_NAME => G_PKG_NAME
661: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
662: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
663: ,X_MSG_COUNT => X_MSG_COUNT
664: ,X_MSG_DATA => X_MSG_DATA
665: ,X_RETURN_STATUS => X_RETURN_STATUS);
666: END Get_Duration;

Line 778: aso_utility_pvt.print_login_info();

774: */
775:
776: IF aso_debug_pub.g_debug_flag = 'Y' THEN
777: aso_debug_pub.add('Before Calling OKS_OMINT_PUB.Is_Service_Available ',1,'Y');
778: aso_utility_pvt.print_login_info();
779: END IF;
780:
781: OKS_OMINT_PUB.Is_Service_Available(
782: P_Api_Version => 1.0 ,

Line 792: aso_utility_pvt.print_login_info();

788: X_Available_YN => X_Available_YN );
789:
790: IF aso_debug_pub.g_debug_flag = 'Y' THEN
791: aso_debug_pub.add('After Calling OKS_OMINT_PUB.Is_Service_Available ',1,'Y');
792: aso_utility_pvt.print_login_info();
793: END IF;
794:
795:
796: -- Check return status from the above procedure call

Line 823: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

819: );
820:
821: EXCEPTION
822: WHEN FND_API.G_EXC_ERROR THEN
823: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
824: P_API_NAME => L_API_NAME
825: ,P_PKG_NAME => G_PKG_NAME
826: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
827: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 827: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

823: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
824: P_API_NAME => L_API_NAME
825: ,P_PKG_NAME => G_PKG_NAME
826: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
827: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
828: ,X_MSG_COUNT => X_MSG_COUNT
829: ,X_MSG_DATA => X_MSG_DATA
830: ,X_RETURN_STATUS => X_RETURN_STATUS);
831:

Line 833: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

829: ,X_MSG_DATA => X_MSG_DATA
830: ,X_RETURN_STATUS => X_RETURN_STATUS);
831:
832: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
833: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
834: P_API_NAME => L_API_NAME
835: ,P_PKG_NAME => G_PKG_NAME
836: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
837: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 837: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

833: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
834: P_API_NAME => L_API_NAME
835: ,P_PKG_NAME => G_PKG_NAME
836: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
837: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
838: ,X_MSG_COUNT => X_MSG_COUNT
839: ,X_MSG_DATA => X_MSG_DATA
840: ,X_RETURN_STATUS => X_RETURN_STATUS);
841:

Line 843: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

839: ,X_MSG_DATA => X_MSG_DATA
840: ,X_RETURN_STATUS => X_RETURN_STATUS);
841:
842: WHEN OTHERS THEN
843: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
844: P_API_NAME => L_API_NAME
845: ,P_PKG_NAME => G_PKG_NAME
846: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
847: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 846: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

842: WHEN OTHERS THEN
843: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
844: P_API_NAME => L_API_NAME
845: ,P_PKG_NAME => G_PKG_NAME
846: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
847: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
848: ,X_MSG_COUNT => X_MSG_COUNT
849: ,X_MSG_DATA => X_MSG_DATA
850: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 847: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

843: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
844: P_API_NAME => L_API_NAME
845: ,P_PKG_NAME => G_PKG_NAME
846: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
847: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
848: ,X_MSG_COUNT => X_MSG_COUNT
849: ,X_MSG_DATA => X_MSG_DATA
850: ,X_RETURN_STATUS => X_RETURN_STATUS);
851:

Line 955: aso_utility_pvt.print_login_info();

951: */
952:
953: IF aso_debug_pub.g_debug_flag = 'Y' THEN
954: aso_debug_pub.add('Before Calling OKS_OMINT_PUB.Available_Services ',1,'Y');
955: aso_utility_pvt.print_login_info();
956: END IF;
957:
958: OKS_OMINT_PUB.Available_Services(
959: P_Api_Version => 1.0 ,

Line 970: aso_utility_pvt.print_login_info();

966: );
967:
968: IF aso_debug_pub.g_debug_flag = 'Y' THEN
969: aso_debug_pub.add('ASO_SER_INT:After Call to OKS available_service: x_return_status '|| X_return_status, 1, 'Y');
970: aso_utility_pvt.print_login_info();
971: END IF;
972:
973: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
974: FOR i in 1..l_Orderable_Service_tbl.count LOOP

Line 1008: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1004: );
1005:
1006: EXCEPTION
1007: WHEN FND_API.G_EXC_ERROR THEN
1008: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1009: P_API_NAME => L_API_NAME
1010: ,P_PKG_NAME => G_PKG_NAME
1011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1012: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 1012: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

1008: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1009: P_API_NAME => L_API_NAME
1010: ,P_PKG_NAME => G_PKG_NAME
1011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1012: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1013: ,X_MSG_COUNT => X_MSG_COUNT
1014: ,X_MSG_DATA => X_MSG_DATA
1015: ,X_RETURN_STATUS => X_RETURN_STATUS);
1016:

Line 1018: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1014: ,X_MSG_DATA => X_MSG_DATA
1015: ,X_RETURN_STATUS => X_RETURN_STATUS);
1016:
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1019: P_API_NAME => L_API_NAME
1020: ,P_PKG_NAME => G_PKG_NAME
1021: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1022: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 1022: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

1018: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1019: P_API_NAME => L_API_NAME
1020: ,P_PKG_NAME => G_PKG_NAME
1021: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1022: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1023: ,X_MSG_COUNT => X_MSG_COUNT
1024: ,X_MSG_DATA => X_MSG_DATA
1025: ,X_RETURN_STATUS => X_RETURN_STATUS);
1026:

Line 1028: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1024: ,X_MSG_DATA => X_MSG_DATA
1025: ,X_RETURN_STATUS => X_RETURN_STATUS);
1026:
1027: WHEN OTHERS THEN
1028: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1029: P_API_NAME => L_API_NAME
1030: ,P_PKG_NAME => G_PKG_NAME
1031: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1032: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 1031: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1027: WHEN OTHERS THEN
1028: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1029: P_API_NAME => L_API_NAME
1030: ,P_PKG_NAME => G_PKG_NAME
1031: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1032: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1033: ,X_MSG_COUNT => X_MSG_COUNT
1034: ,X_MSG_DATA => X_MSG_DATA
1035: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1032: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

1028: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1029: P_API_NAME => L_API_NAME
1030: ,P_PKG_NAME => G_PKG_NAME
1031: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1032: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1033: ,X_MSG_COUNT => X_MSG_COUNT
1034: ,X_MSG_DATA => X_MSG_DATA
1035: ,X_RETURN_STATUS => X_RETURN_STATUS);
1036:

Line 1116: aso_utility_pvt.print_login_info();

1112: END IF;
1113:
1114: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1115: aso_debug_pub.add('Before Call to OKS_EXTWAR_UTIL_PUB.Get_Warranty_info', 1, 'Y');
1116: aso_utility_pvt.print_login_info();
1117: END IF;
1118:
1119: OKS_EXTWAR_UTIL_PUB.Get_Warranty_info(
1120: P_Api_Version => 1.0 ,

Line 1132: aso_utility_pvt.print_login_info();

1128: -- map the output
1129:
1130: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1131: aso_debug_pub.add('After Call to OKS_EXTWAR_UTIL_PUB.Get_Warranty_info', 1, 'Y');
1132: aso_utility_pvt.print_login_info();
1133: END IF;
1134:
1135:
1136: For i in 1..l_warranty_tbl.count LOOP

Line 1181: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1177: );
1178:
1179: EXCEPTION
1180: WHEN FND_API.G_EXC_ERROR THEN
1181: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1182: P_API_NAME => L_API_NAME
1183: ,P_PKG_NAME => G_PKG_NAME
1184: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1185: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 1185: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

1181: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1182: P_API_NAME => L_API_NAME
1183: ,P_PKG_NAME => G_PKG_NAME
1184: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1185: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1186: ,X_MSG_COUNT => X_MSG_COUNT
1187: ,X_MSG_DATA => X_MSG_DATA
1188: ,X_RETURN_STATUS => X_RETURN_STATUS);
1189:

Line 1191: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1187: ,X_MSG_DATA => X_MSG_DATA
1188: ,X_RETURN_STATUS => X_RETURN_STATUS);
1189:
1190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1191: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1192: P_API_NAME => L_API_NAME
1193: ,P_PKG_NAME => G_PKG_NAME
1194: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1195: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 1195: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

1191: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1192: P_API_NAME => L_API_NAME
1193: ,P_PKG_NAME => G_PKG_NAME
1194: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1195: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1196: ,X_MSG_COUNT => X_MSG_COUNT
1197: ,X_MSG_DATA => X_MSG_DATA
1198: ,X_RETURN_STATUS => X_RETURN_STATUS);
1199:

Line 1201: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1197: ,X_MSG_DATA => X_MSG_DATA
1198: ,X_RETURN_STATUS => X_RETURN_STATUS);
1199:
1200: WHEN OTHERS THEN
1201: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1202: P_API_NAME => L_API_NAME
1203: ,P_PKG_NAME => G_PKG_NAME
1204: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1205: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 1204: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1200: WHEN OTHERS THEN
1201: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1202: P_API_NAME => L_API_NAME
1203: ,P_PKG_NAME => G_PKG_NAME
1204: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1205: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1206: ,X_MSG_COUNT => X_MSG_COUNT
1207: ,X_MSG_DATA => X_MSG_DATA
1208: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1205: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

1201: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1202: P_API_NAME => L_API_NAME
1203: ,P_PKG_NAME => G_PKG_NAME
1204: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1205: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1206: ,X_MSG_COUNT => X_MSG_COUNT
1207: ,X_MSG_DATA => X_MSG_DATA
1208: ,X_RETURN_STATUS => X_RETURN_STATUS);
1209: