[Home] [Help]
1: PACKAGE BODY ASO_NETWORK_UI_PVT as
2: /* $Header: asovnetb.pls 120.1 2005/06/29 12:42:13 appldev ship $ */
3: -- Start of Comments
4: -- Package name : ASO_NETWORK_UI_PVT
5: -- Purpose : This is a wrapper, to make the CZ API Calls for MACD Functionality in Quoting Forms UI
1: PACKAGE BODY ASO_NETWORK_UI_PVT as
2: /* $Header: asovnetb.pls 120.1 2005/06/29 12:42:13 appldev ship $ */
3: -- Start of Comments
4: -- Package name : ASO_NETWORK_UI_PVT
5: -- Purpose : This is a wrapper, to make the CZ API Calls for MACD Functionality in Quoting Forms UI
6: -- History :
7: -- NOTE :
8: -- End of Comments
12: -- API type: public
13: -- Function: Checks if a model specified by the top inventory_item_id and
14: -- organization_id is a network container model.
15:
16: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_NETWORK_UI_PVT';
17: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ASOVNETB.PLS';
18:
19: procedure aso_is_container(p_api_version IN NUMBER
20: ,p_inventory_item_id IN NUMBER
18:
19: procedure aso_is_container(p_api_version IN NUMBER
20: ,p_inventory_item_id IN NUMBER
21: ,p_organization_id IN NUMBER
22: ,p_appl_param_rec IN ASO_NETWORK_UI_PVT.aso_appl_param_rec_type
23: ,x_return_value OUT NOCOPY VARCHAR2
24: ,x_return_status OUT NOCOPY VARCHAR2
25: ,x_msg_count OUT NOCOPY NUMBER
26: ,x_msg_data OUT NOCOPY VARCHAR2
39: BEGIN
40: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
41:
42: IF aso_debug_pub.g_debug_flag = 'Y' THEN
43: aso_debug_pub.add('ASO_NETWORK_UI_PVT.Aso_Is_Container BEGIN');
44: END IF;
45:
46: l_appl_param_rec.calling_application_id := P_appl_param_rec.calling_application_id;
47:
62:
63: IF aso_debug_pub.g_debug_flag = 'Y' THEN
64: aso_debug_pub.add('X_Return_value from Cz_NETWORK_API_Pub.Is_Container '||x_return_value);
65: aso_debug_pub.add('X_Return_Status from Cz_NETWORK_API_Pub.Is_Container '||X_Return_Status);
66: aso_debug_pub.add('ASO_NETWORK_UI_PVT.Aso_Is_Container END');
67: END IF;
68:
69: EXCEPTION
70: WHEN FND_API.G_EXC_ERROR THEN
109:
110: procedure aso_get_contained_models(p_api_version IN NUMBER
111: ,p_inventory_item_id IN NUMBER
112: ,p_organization_id IN NUMBER
113: ,p_appl_param_rec IN ASO_NETWORK_UI_PVT.aso_appl_param_rec_type
114: ,x_model_tbl OUT NOCOPY ASO_NETWORK_UI_PVT.aso_number_tbl_type
115: ,x_return_status OUT NOCOPY VARCHAR2
116: ,x_msg_count OUT NOCOPY NUMBER
117: ,x_msg_data OUT NOCOPY VARCHAR2
110: procedure aso_get_contained_models(p_api_version IN NUMBER
111: ,p_inventory_item_id IN NUMBER
112: ,p_organization_id IN NUMBER
113: ,p_appl_param_rec IN ASO_NETWORK_UI_PVT.aso_appl_param_rec_type
114: ,x_model_tbl OUT NOCOPY ASO_NETWORK_UI_PVT.aso_number_tbl_type
115: ,x_return_status OUT NOCOPY VARCHAR2
116: ,x_msg_count OUT NOCOPY NUMBER
117: ,x_msg_data OUT NOCOPY VARCHAR2
118: )
127: BEGIN
128: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
129:
130: IF aso_debug_pub.g_debug_flag = 'Y' THEN
131: aso_debug_pub.add('ASO_NETWORK_UI_PVT.Aso_Get_Contained_Models BEGIN');
132: END IF;
133:
134: --x_model_tbl := ASO_NETWORK_UI_PVT.aso_number_tbl_type();
135:
130: IF aso_debug_pub.g_debug_flag = 'Y' THEN
131: aso_debug_pub.add('ASO_NETWORK_UI_PVT.Aso_Get_Contained_Models BEGIN');
132: END IF;
133:
134: --x_model_tbl := ASO_NETWORK_UI_PVT.aso_number_tbl_type();
135:
136: l_appl_param_rec.calling_application_id := P_appl_param_rec.calling_application_id;
137:
138: IF aso_debug_pub.g_debug_flag = 'Y' THEN
163:
164: End If;
165:
166: IF aso_debug_pub.g_debug_flag = 'Y' THEN
167: aso_debug_pub.add('ASO_NETWORK_UI_PVT.Aso_Get_Contained_Models END');
168: END IF;
169:
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
209: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
211: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
212: P_qte_line_tbl IN ASO_QUOTE_PUB.Qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl ,
213: P_instance_tbl IN ASO_NETWORK_UI_PVT.Aso_Instance_Tbl_Type,
214: p_operation_code IN VARCHAR2,
215: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
216: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
217: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
231:
232: End If;
233:
234: IF aso_debug_pub.g_debug_flag = 'Y' THEN
235: aso_debug_pub.add('Call TO ASO_NETWORK_UI_PVT.Aso_Config_Operations Begin ');
236: END IF;
237:
238: Aso_Config_Operations_Int.Config_Operations(
239: p_api_version_number => p_api_version_number,
250: x_msg_count => x_msg_count,
251: x_msg_data => x_msg_data);
252:
253: IF aso_debug_pub.g_debug_flag = 'Y' THEN
254: aso_debug_pub.add('return ASO_NETWORK_UI_PVT.Aso_Config_Operations '||X_Return_Status);
255: aso_debug_pub.add('ASO_NETWORK_UI_PVT.Aso_Config_Operations END');
256: END IF;
257:
258: EXCEPTION
251: x_msg_data => x_msg_data);
252:
253: IF aso_debug_pub.g_debug_flag = 'Y' THEN
254: aso_debug_pub.add('return ASO_NETWORK_UI_PVT.Aso_Config_Operations '||X_Return_Status);
255: aso_debug_pub.add('ASO_NETWORK_UI_PVT.Aso_Config_Operations END');
256: END IF;
257:
258: EXCEPTION
259: WHEN FND_API.G_EXC_ERROR THEN
363: );
364:
365: END Aso_Get_config_details;
366:
367: End ASO_NETWORK_UI_PVT;
368: