DBA Data[Home] [Help]

APPS.ASO_CFG_INT dependencies on ASO_UTILITY_PVT

Line 83: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 93: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 106: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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);

Line 107: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

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:

Line 350: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

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,

Line 353: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

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:

Line 360: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

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,

Line 363: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

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:

Line 375: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS( P_API_NAME => L_API_NAME,

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,

Line 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);

Line 380: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT,

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:

Line 791: := ASO_UTILITY_PVT.Get_Pricing_Control_Rec;

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;

Line 879: ASO_UTILITY_PVT.print_login_info;

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

Line 1594: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 1645: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 1696: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 1699: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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

Line 1700: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

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

Line 1848: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row ( l_quote_header_id );

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:

Line 2458: l_model_line_rec := aso_utility_pvt.Query_Qte_Line_Row( P_Qte_Line_Id => p_model_line_id );

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;

Line 2461: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Qte_Line_Row');

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:

Line 2464: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );

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;

Line 2467: aso_debug_pub.add('Create_hdr_xml: After call to aso_utility_pvt.Query_Line_Dtl_Rows');

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);

Line 3114: l_model_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_model_line_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

Line 3115: l_model_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_model_line_id);

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.');