36: l_msg_data VARCHAR2(2000);
37: l_sqlerrm VARCHAR2(2000);
38:
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;
38:
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;
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:
44: END IF;
45:
46: l_appl_param_rec.calling_application_id := P_appl_param_rec.calling_application_id;
47:
48: IF aso_debug_pub.g_debug_flag = 'Y' THEN
49: aso_debug_pub.add('Call TO CZ_NETWORK_API_PUB.Is_Container ');
50: END IF;
51:
52: CZ_NETWORK_API_PUB.Is_Container
45:
46: l_appl_param_rec.calling_application_id := P_appl_param_rec.calling_application_id;
47:
48: IF aso_debug_pub.g_debug_flag = 'Y' THEN
49: aso_debug_pub.add('Call TO CZ_NETWORK_API_PUB.Is_Container ');
50: END IF;
51:
52: CZ_NETWORK_API_PUB.Is_Container
53: (p_api_version => p_api_version,
59: x_msg_count => x_msg_count,
60: x_msg_data => x_msg_data
61: );
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;
60: x_msg_data => x_msg_data
61: );
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:
61: );
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
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
124: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
125:
126: lx_model_tbl CZ_API_PUB.number_tbl_type;
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;
126: lx_model_tbl CZ_API_PUB.number_tbl_type;
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();
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:
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
139: aso_debug_pub.add('Call to CZ_NETWORK_API_PUB.Get_Contained_Models ');
140: END IF;
141:
142: CZ_NETWORK_API_PUB.Get_Contained_Models(
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
139: aso_debug_pub.add('Call to CZ_NETWORK_API_PUB.Get_Contained_Models ');
140: END IF;
141:
142: CZ_NETWORK_API_PUB.Get_Contained_Models(
143: p_api_version => p_api_version,
149: x_msg_count => x_msg_count,
150: x_msg_data => x_msg_data
151: );
152:
153: IF aso_debug_pub.g_debug_flag = 'Y' THEN
154: aso_debug_pub.add('return CZ_NETWORK_API_PUB.Get_Contained_Models '||X_Return_Status);
155: END IF;
156:
157: IF lx_model_tbl.COUNT > 0 THEN
150: x_msg_data => x_msg_data
151: );
152:
153: IF aso_debug_pub.g_debug_flag = 'Y' THEN
154: aso_debug_pub.add('return CZ_NETWORK_API_PUB.Get_Contained_Models '||X_Return_Status);
155: END IF;
156:
157: IF lx_model_tbl.COUNT > 0 THEN
158: --x_model_tbl.extend(lx_model_tbl.COUNT);
162: End Loop;
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
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
221: l_api_name CONSTANT VARCHAR2(30) := 'aso_config_operations';
222: l_instance_tbl ASO_QUOTE_HEADERS_PVT.Instance_tbl_type;
223:
224: Begin
225: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
226: IF P_Instance_tbl.COUNT > 0 THEN
227: For i IN P_Instance_Tbl.FIRST..P_Instance_Tbl.LAST
228: Loop
229: l_Instance_Tbl(i).Instance_Id := P_Instance_Tbl(i).Instance_Id;
230: End Loop;
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(
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,
249: x_return_status => x_return_status,
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:
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
303:
304: l_api_name CONSTANT VARCHAR2(30) := 'aso_get_config_details';
305:
306: BEGIN
307: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
308:
309: IF aso_debug_pub.g_debug_flag = 'Y' THEN
310: aso_debug_pub.add('Call to Aso_Get_Config_Details');
311: END IF;
305:
306: BEGIN
307: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
308:
309: IF aso_debug_pub.g_debug_flag = 'Y' THEN
310: aso_debug_pub.add('Call to Aso_Get_Config_Details');
311: END IF;
312:
313: ASO_CFG_INT.Get_Config_Details(
306: BEGIN
307: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
308:
309: IF aso_debug_pub.g_debug_flag = 'Y' THEN
310: aso_debug_pub.add('Call to Aso_Get_Config_Details');
311: END IF;
312:
313: ASO_CFG_INT.Get_Config_Details(
314: p_api_version_number => p_api_version_number,
324: x_msg_count => x_msg_count,
325: x_msg_data => x_msg_data
326: );
327:
328: IF aso_debug_pub.g_debug_flag = 'Y' THEN
329: aso_debug_pub.add('x_return_status, ASO Get_Config_Details '||x_return_status);
330: aso_debug_pub.add('Aso_get_config_details END');
331: END IF;
332:
325: x_msg_data => x_msg_data
326: );
327:
328: IF aso_debug_pub.g_debug_flag = 'Y' THEN
329: aso_debug_pub.add('x_return_status, ASO Get_Config_Details '||x_return_status);
330: aso_debug_pub.add('Aso_get_config_details END');
331: END IF;
332:
333:
326: );
327:
328: IF aso_debug_pub.g_debug_flag = 'Y' THEN
329: aso_debug_pub.add('x_return_status, ASO Get_Config_Details '||x_return_status);
330: aso_debug_pub.add('Aso_get_config_details END');
331: END IF;
332:
333:
334: EXCEPTION