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
71: x_return_status := FND_API.G_RET_STS_ERROR;
72: FND_MSG_PUB.Count_And_Get(
73: p_encoded => FND_API.G_FALSE,
74: p_count => x_msg_count,
67: END IF;
68:
69: EXCEPTION
70: WHEN FND_API.G_EXC_ERROR THEN
71: x_return_status := FND_API.G_RET_STS_ERROR;
72: FND_MSG_PUB.Count_And_Get(
73: p_encoded => FND_API.G_FALSE,
74: p_count => x_msg_count,
75: p_data => x_msg_data
69: EXCEPTION
70: WHEN FND_API.G_EXC_ERROR THEN
71: x_return_status := FND_API.G_RET_STS_ERROR;
72: FND_MSG_PUB.Count_And_Get(
73: p_encoded => FND_API.G_FALSE,
74: p_count => x_msg_count,
75: p_data => x_msg_data
76: );
77:
74: p_count => x_msg_count,
75: p_data => x_msg_data
76: );
77:
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
80: FND_MSG_PUB.Count_And_Get(
81: p_encoded => FND_API.G_FALSE,
82: p_count => x_msg_count,
75: p_data => x_msg_data
76: );
77:
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
80: FND_MSG_PUB.Count_And_Get(
81: p_encoded => FND_API.G_FALSE,
82: p_count => x_msg_count,
83: p_data => x_msg_data
77:
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
80: FND_MSG_PUB.Count_And_Get(
81: p_encoded => FND_API.G_FALSE,
82: p_count => x_msg_count,
83: p_data => x_msg_data
84: );
85:
83: p_data => x_msg_data
84: );
85:
86: WHEN OTHERS THEN
87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
88: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
89: THEN
90: FND_MSG_PUB.Add_Exc_Msg(
91: G_PKG_NAME,
93: );
94: END IF;
95:
96: FND_MSG_PUB.Count_And_Get(
97: p_encoded => FND_API.G_FALSE,
98: p_count => x_msg_count,
99: p_data => x_msg_data
100: );
101: END Aso_Is_Container;
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
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: FND_MSG_PUB.Count_And_Get(
174: p_encoded => FND_API.G_FALSE,
175: p_count => x_msg_count,
168: END IF;
169:
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: FND_MSG_PUB.Count_And_Get(
174: p_encoded => FND_API.G_FALSE,
175: p_count => x_msg_count,
176: p_data => x_msg_data
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: FND_MSG_PUB.Count_And_Get(
174: p_encoded => FND_API.G_FALSE,
175: p_count => x_msg_count,
176: p_data => x_msg_data
177: );
178:
175: p_count => x_msg_count,
176: p_data => x_msg_data
177: );
178:
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: FND_MSG_PUB.Count_And_Get(
182: p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
176: p_data => x_msg_data
177: );
178:
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: FND_MSG_PUB.Count_And_Get(
182: p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
184: p_data => x_msg_data
178:
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: FND_MSG_PUB.Count_And_Get(
182: p_encoded => FND_API.G_FALSE,
183: p_count => x_msg_count,
184: p_data => x_msg_data
185: );
186:
184: p_data => x_msg_data
185: );
186:
187: WHEN OTHERS THEN
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
190: THEN
191: FND_MSG_PUB.Add_Exc_Msg(
192: G_PKG_NAME,
194: );
195: END IF;
196:
197: FND_MSG_PUB.Count_And_Get(
198: p_encoded => FND_API.G_FALSE,
199: p_count => x_msg_count,
200: p_data => x_msg_data
201: );
202:
203: END Aso_Get_Contained_Models;
204: --------------------------------------
205: PROCEDURE aso_config_operations(
206: P_Api_Version_Number IN NUMBER,
207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
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,
204: --------------------------------------
205: PROCEDURE aso_config_operations(
206: P_Api_Version_Number IN NUMBER,
207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
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 ,
205: PROCEDURE aso_config_operations(
206: P_Api_Version_Number IN NUMBER,
207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
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,
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
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: FND_MSG_PUB.Count_And_Get(
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,
256: END IF;
257:
258: EXCEPTION
259: WHEN FND_API.G_EXC_ERROR THEN
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: FND_MSG_PUB.Count_And_Get(
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,
264: p_data => x_msg_data
258: EXCEPTION
259: WHEN FND_API.G_EXC_ERROR THEN
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: FND_MSG_PUB.Count_And_Get(
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,
264: p_data => x_msg_data
265: );
266:
263: p_count => x_msg_count,
264: p_data => x_msg_data
265: );
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: FND_MSG_PUB.Count_And_Get(
270: p_encoded => FND_API.G_FALSE,
271: p_count => x_msg_count,
264: p_data => x_msg_data
265: );
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: FND_MSG_PUB.Count_And_Get(
270: p_encoded => FND_API.G_FALSE,
271: p_count => x_msg_count,
272: p_data => x_msg_data
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269: FND_MSG_PUB.Count_And_Get(
270: p_encoded => FND_API.G_FALSE,
271: p_count => x_msg_count,
272: p_data => x_msg_data
273: );
274: WHEN OTHERS THEN
271: p_count => x_msg_count,
272: p_data => x_msg_data
273: );
274: WHEN OTHERS THEN
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
277: FND_MSG_PUB.Add_Exc_Msg(
278: G_PKG_NAME,
279: l_api_name
280: );
281: END IF;
282:
283: FND_MSG_PUB.Count_And_Get(
284: p_encoded => FND_API.G_FALSE,
285: p_count => x_msg_count,
286: p_data => x_msg_data
287: );
288: END Aso_Config_Operations;
287: );
288: END Aso_Config_Operations;
289:
290: PROCEDURE Aso_Get_config_details(
291: P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
292: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
293: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
294: p_control_rec IN aso_quote_pub.control_rec_type := aso_quote_pub.G_MISS_control_rec,
295: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
288: END Aso_Config_Operations;
289:
290: PROCEDURE Aso_Get_config_details(
291: P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
292: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
293: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
294: p_control_rec IN aso_quote_pub.control_rec_type := aso_quote_pub.G_MISS_control_rec,
295: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
296: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
289:
290: PROCEDURE Aso_Get_config_details(
291: P_Api_Version_Number IN NUMBER := FND_API.G_MISS_NUM,
292: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
293: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
294: p_control_rec IN aso_quote_pub.control_rec_type := aso_quote_pub.G_MISS_control_rec,
295: p_config_rec IN aso_quote_pub.qte_line_dtl_rec_type,
296: p_model_line_rec IN aso_quote_pub.qte_line_rec_type,
297: p_config_hdr_id IN NUMBER ,
331: END IF;
332:
333:
334: EXCEPTION
335: WHEN FND_API.G_EXC_ERROR THEN
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: FND_MSG_PUB.Count_And_Get(
338: p_encoded => FND_API.G_FALSE,
339: p_count => x_msg_count,
332:
333:
334: EXCEPTION
335: WHEN FND_API.G_EXC_ERROR THEN
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: FND_MSG_PUB.Count_And_Get(
338: p_encoded => FND_API.G_FALSE,
339: p_count => x_msg_count,
340: p_data => x_msg_data
334: EXCEPTION
335: WHEN FND_API.G_EXC_ERROR THEN
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: FND_MSG_PUB.Count_And_Get(
338: p_encoded => FND_API.G_FALSE,
339: p_count => x_msg_count,
340: p_data => x_msg_data
341: );
342:
339: p_count => x_msg_count,
340: p_data => x_msg_data
341: );
342:
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: FND_MSG_PUB.Count_And_Get(
346: p_encoded => FND_API.G_FALSE,
347: p_count => x_msg_count,
340: p_data => x_msg_data
341: );
342:
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: FND_MSG_PUB.Count_And_Get(
346: p_encoded => FND_API.G_FALSE,
347: p_count => x_msg_count,
348: p_data => x_msg_data
342:
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: FND_MSG_PUB.Count_And_Get(
346: p_encoded => FND_API.G_FALSE,
347: p_count => x_msg_count,
348: p_data => x_msg_data
349: );
350: WHEN OTHERS THEN
347: p_count => x_msg_count,
348: p_data => x_msg_data
349: );
350: WHEN OTHERS THEN
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
353: FND_MSG_PUB.Add_Exc_Msg(
354: G_PKG_NAME,
355: l_api_name
356: );
357: END IF;
358:
359: FND_MSG_PUB.Count_And_Get(
360: p_encoded => FND_API.G_FALSE,
361: p_count => x_msg_count,
362: p_data => x_msg_data
363: );
364: