79: x_shipment_tbl => x_shipment_tbl );
80:
81: EXCEPTION
82: WHEN FND_API.G_EXC_ERROR THEN
83: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
84: P_API_NAME => L_API_NAME
85: ,P_PKG_NAME => G_PKG_NAME
86: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
87: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
83: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
84: P_API_NAME => L_API_NAME
85: ,P_PKG_NAME => G_PKG_NAME
86: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
87: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
88: ,X_MSG_COUNT => X_MSG_COUNT
89: ,X_MSG_DATA => X_MSG_DATA
90: ,X_RETURN_STATUS => X_RETURN_STATUS);
91:
89: ,X_MSG_DATA => X_MSG_DATA
90: ,X_RETURN_STATUS => X_RETURN_STATUS);
91:
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
94: P_API_NAME => L_API_NAME
95: ,P_PKG_NAME => G_PKG_NAME
96: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
97: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
93: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
94: P_API_NAME => L_API_NAME
95: ,P_PKG_NAME => G_PKG_NAME
96: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
97: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
98: ,X_MSG_COUNT => X_MSG_COUNT
99: ,X_MSG_DATA => X_MSG_DATA
100: ,X_RETURN_STATUS => X_RETURN_STATUS);
101:
99: ,X_MSG_DATA => X_MSG_DATA
100: ,X_RETURN_STATUS => X_RETURN_STATUS);
101:
102: WHEN OTHERS THEN
103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
104: P_API_NAME => L_API_NAME
105: ,P_PKG_NAME => G_PKG_NAME
106: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
107: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
102: WHEN OTHERS THEN
103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
104: P_API_NAME => L_API_NAME
105: ,P_PKG_NAME => G_PKG_NAME
106: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
107: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
108: ,X_MSG_COUNT => X_MSG_COUNT
109: ,X_MSG_DATA => X_MSG_DATA
110: ,X_RETURN_STATUS => X_RETURN_STATUS);
103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
104: P_API_NAME => L_API_NAME
105: ,P_PKG_NAME => G_PKG_NAME
106: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
107: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
108: ,X_MSG_COUNT => X_MSG_COUNT
109: ,X_MSG_DATA => X_MSG_DATA
110: ,X_RETURN_STATUS => X_RETURN_STATUS);
111:
346: EXCEPTION
347:
348: WHEN FND_API.G_EXC_ERROR THEN
349:
350: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
351: P_PKG_NAME => G_PKG_NAME,
352: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
353: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
354: X_MSG_COUNT => X_MSG_COUNT,
349:
350: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
351: P_PKG_NAME => G_PKG_NAME,
352: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
353: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
354: X_MSG_COUNT => X_MSG_COUNT,
355: X_MSG_DATA => X_MSG_DATA,
356: X_RETURN_STATUS => X_RETURN_STATUS);
357:
356: X_RETURN_STATUS => X_RETURN_STATUS);
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359:
360: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
361: P_PKG_NAME => G_PKG_NAME,
362: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
363: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
364: X_MSG_COUNT => X_MSG_COUNT,
359:
360: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
361: P_PKG_NAME => G_PKG_NAME,
362: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
363: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
364: X_MSG_COUNT => X_MSG_COUNT,
365: X_MSG_DATA => X_MSG_DATA,
366: X_RETURN_STATUS => X_RETURN_STATUS);
367:
371: IF aso_debug_pub.g_debug_flag = 'Y' THEN
372: aso_debug_pub.add('ASO_CFG_INT: copy_configuration: Inside when others exception');
373: END IF;
374:
375: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
376: P_PKG_NAME => G_PKG_NAME,
377: P_SQLERRM => SQLERRM,
378: P_SQLCODE => SQLCODE,
379: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
375: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,
376: P_PKG_NAME => G_PKG_NAME,
377: P_SQLERRM => SQLERRM,
378: P_SQLCODE => SQLCODE,
379: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
380: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
381: X_MSG_COUNT => X_MSG_COUNT,
382: X_MSG_DATA => X_MSG_DATA,
383: X_RETURN_STATUS => X_RETURN_STATUS);
376: P_PKG_NAME => G_PKG_NAME,
377: P_SQLERRM => SQLERRM,
378: P_SQLCODE => SQLCODE,
379: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
380: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,
381: X_MSG_COUNT => X_MSG_COUNT,
382: X_MSG_DATA => X_MSG_DATA,
383: X_RETURN_STATUS => X_RETURN_STATUS);
384:
787: l_old_config_hdr_id NUMBER;
788: l_ship_model_complete_flag VARCHAR2(1);
789:
790: l_control_rec ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE
791: := ASO_UTILITY_PVT.Get_Pricing_Control_Rec;
792: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
793: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;
794: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
795: l_qte_line_dtl_search ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
875:
876: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
877: IF aso_debug_pub.g_debug_flag = 'Y' THEN
878: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
879: ASO_UTILITY_PVT.print_login_info;
880: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
881: END IF;
882:
883: -- Change Done By Girish
1590: else
1591: close c_config_exist_in_cz;
1592: end if;
1593:
1594: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1595: P_API_NAME => L_API_NAME
1596: ,P_PKG_NAME => G_PKG_NAME
1597: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1598: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1594: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1595: P_API_NAME => L_API_NAME
1596: ,P_PKG_NAME => G_PKG_NAME
1597: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1598: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1599: ,X_MSG_COUNT => X_MSG_COUNT
1600: ,X_MSG_DATA => X_MSG_DATA
1601: ,X_RETURN_STATUS => X_RETURN_STATUS);
1602:
1641: else
1642: close c_config_exist_in_cz;
1643: end if;
1644:
1645: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1646: P_API_NAME => L_API_NAME
1647: ,P_PKG_NAME => G_PKG_NAME
1648: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1649: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1645: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1646: P_API_NAME => L_API_NAME
1647: ,P_PKG_NAME => G_PKG_NAME
1648: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1649: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1650: ,X_MSG_COUNT => X_MSG_COUNT
1651: ,X_MSG_DATA => X_MSG_DATA
1652: ,X_RETURN_STATUS => X_RETURN_STATUS);
1653:
1692: else
1693: close c_config_exist_in_cz;
1694: end if;
1695:
1696: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1697: P_API_NAME => L_API_NAME
1698: ,P_PKG_NAME => G_PKG_NAME
1699: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1700: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1695:
1696: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1697: P_API_NAME => L_API_NAME
1698: ,P_PKG_NAME => G_PKG_NAME
1699: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1700: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1701: ,P_SQLCODE => SQLCODE
1702: ,P_SQLERRM => SQLERRM
1703: ,X_MSG_COUNT => X_MSG_COUNT
1696: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1697: P_API_NAME => L_API_NAME
1698: ,P_PKG_NAME => G_PKG_NAME
1699: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1700: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
1701: ,P_SQLCODE => SQLCODE
1702: ,P_SQLERRM => SQLERRM
1703: ,X_MSG_COUNT => X_MSG_COUNT
1704: ,X_MSG_DATA => X_MSG_DATA
1844: END IF;
1845:
1846: IF c_quote_hdr_id%FOUND THEN
1847:
1848: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row ( l_quote_header_id );
1849:
1850: -- The following function returns all other rows of the quote which do not belong to
1851: -- this configuration plus the model line itself
1852:
2454:
2455: --Initialize API return status to SUCCESS
2456: x_return_status := FND_API.G_RET_STS_SUCCESS;
2457:
2458: l_model_line_rec := aso_utility_pvt.Query_Qte_Line_Row( P_Qte_Line_Id => p_model_line_id );
2459:
2460: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2461: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Qte_Line_Row');
2462: END IF;
2457:
2458: l_model_line_rec := aso_utility_pvt.Query_Qte_Line_Row( P_Qte_Line_Id => p_model_line_id );
2459:
2460: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2461: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Qte_Line_Row');
2462: END IF;
2463:
2464: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );
2465:
2460: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2461: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Qte_Line_Row');
2462: END IF;
2463:
2464: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );
2465:
2466: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2467: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Line_Dtl_Rows');
2468: END IF;
2463:
2464: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );
2465:
2466: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2467: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Line_Dtl_Rows');
2468: END IF;
2469:
2470: /* Fix for bug 3998564 */
2471: --OPEN C_org_id( l_model_line_rec.quote_header_id);
3110: FND_MSG_PUB.initialize;
3111: END IF;
3112:
3113: -- Get model line info
3114: l_model_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_model_line_id);
3115: l_model_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_model_line_id);
3116:
3117: -- Call Create_hdr_xml to create the input header XML message
3118: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3111: END IF;
3112:
3113: -- Get model line info
3114: l_model_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_model_line_id);
3115: l_model_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_model_line_id);
3116:
3117: -- Call Create_hdr_xml to create the input header XML message
3118: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3119: aso_debug_pub.add('Validate_Configuration: Before call to Create_hdr_xml.');