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
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
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
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
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
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
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
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');
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:
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
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:
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
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:
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
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);
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;
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 ,
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
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
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:
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
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:
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
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);
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:
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 ,
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
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
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:
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
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:
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
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);
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:
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 ,
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
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
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:
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
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:
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
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);
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: