DBA Data[Home] [Help]

APPS.ASO_VALIDATE_CFG_PVT dependencies on ASO_VALIDATE_CFG_PVT

Line 1: PACKAGE BODY ASO_VALIDATE_CFG_PVT as

1: PACKAGE BODY ASO_VALIDATE_CFG_PVT as
2: /* $Header: asovcfgb.pls 120.0.12010000.2 2010/04/14 06:50:57 rassharm noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_VALIDATE_CFG_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asovcfgb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_VALIDATE_CFG_PVT';

1: PACKAGE BODY ASO_VALIDATE_CFG_PVT as
2: /* $Header: asovcfgb.pls 120.0.12010000.2 2010/04/14 06:50:57 rassharm noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_VALIDATE_CFG_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asovcfgb.pls';
6:
7:
8: /*----------------------------------------------------------------------

Line 89: aso_debug_pub.add('ASO_VALIDATE_CFG_PVT: Validate_Configuration Begins', 1, 'Y');

85:
86: l_return_status := FND_API.G_RET_STS_SUCCESS;
87:
88: IF aso_debug_pub.g_debug_flag = 'Y' THEN
89: aso_debug_pub.add('ASO_VALIDATE_CFG_PVT: Validate_Configuration Begins', 1, 'Y');
90: END IF;
91:
92: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
93: p_api_version_number,

Line 114: -- dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT before create header xml');

110: aso_debug_pub.add('Validate_Configuration: Before call to Create_header_xml. P_EFFECTIVE_DATE'||P_EFFECTIVE_DATE);
111: aso_debug_pub.add('Validate_Configuration: Before call to Create_header_xml. P_model_lookup_DATE'||P_model_lookup_DATE);
112: END IF;
113:
114: -- dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT before create header xml');
115: /*aso_cfg_int.create_hdr_xml(P_model_line_id => P_model_line_id,
116: X_xml_hdr => l_xml_hdr,
117: X_return_status => l_return_status );*/
118: Create_header_xml ( P_model_line_id => P_model_line_id,

Line 131: -- dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT before send input xml'||l_return_status);

127: aso_debug_pub.add('Validate_Configuration: After call to Create_header_xml Length of l_xml_hdr : '||length(l_xml_hdr));
128: --aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration: Before call to Send_input_xml'||l_xml_hdr);
129: END IF;
130:
131: -- dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT before send input xml'||l_return_status);
132: -- dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT before send input xml'||l_xml_hdr);
133:
134: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
135:

Line 132: -- dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT before send input xml'||l_xml_hdr);

128: --aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration: Before call to Send_input_xml'||l_xml_hdr);
129: END IF;
130:
131: -- dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT before send input xml'||l_return_status);
132: -- dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT before send input xml'||l_xml_hdr);
133:
134: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
135:
136: -- Call Send_Input_Xml to call CZ batch validate procedure and get the output XML message

Line 157: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT after send input xml'||l_return_status);

153: aso_debug_pub.add('Validate_Configuration: After call to Send_input_xml');
154: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
155: END IF;
156:
157: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT after send input xml'||l_return_status);
158: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT after send input xml'||l_config_changed_flag);
159:
160: -- extract data from xml message.
161:

Line 158: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT after send input xml'||l_config_changed_flag);

154: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
155: END IF;
156:
157: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT after send input xml'||l_return_status);
158: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT after send input xml'||l_config_changed_flag);
159:
160: -- extract data from xml message.
161:
162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 171: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT before parse header xml'||l_return_status);

167: aso_debug_pub.add('Validate_Configuration: Before Call to Parse_Output_xml',1,'N');
168: aso_debug_pub.add('Validate_Configuration: l_delete_config: '||l_delete_config);
169: END IF;
170:
171: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT before parse header xml'||l_return_status);
172:
173: ASO_CFG_INT.Parse_output_xml
174: ( p_xml_msg => l_xml_message,
175: x_valid_configuration_flag => l_valid_configuration_flag,

Line 190: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT after parse header xml'||l_return_status);

186: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
187: END IF;
188:
189: END IF;
190: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT after parse header xml'||l_return_status);
191:
192: IF ((l_return_status =FND_API.G_RET_STS_SUCCESS) and (p_update_quote=fnd_api.g_false) and (l_delete_config=fnd_api.g_false))THEN
193:
194: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT p_update_quote is false');

Line 194: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT p_update_quote is false');

190: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT after parse header xml'||l_return_status);
191:
192: IF ((l_return_status =FND_API.G_RET_STS_SUCCESS) and (p_update_quote=fnd_api.g_false) and (l_delete_config=fnd_api.g_false))THEN
193:
194: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT p_update_quote is false');
195: open c_config_exist_in_cz(l_config_header_id, l_config_revision_num);
196: fetch c_config_exist_in_cz into l_new_config_hdr_id;
197:
198: if c_config_exist_in_cz%found then

Line 240: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT p_update_quote is true');

236: elsif (l_return_status = FND_API.G_RET_STS_SUCCESS) and (l_delete_config = fnd_api.g_false) and (p_update_quote = fnd_api.g_true)THEN
237:
238: -- Call GET_CONFIG_DETAILS to update the existing configuration
239: -- Set the Call_batch_validation_flag to FND_API.G_FALSE to avoid recursive call to update_quote
240: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT p_update_quote is true');
241: l_model_line_dtl_tbl(1).valid_configuration_flag := l_valid_configuration_flag;
242: l_model_line_dtl_tbl(1).complete_configuration_flag := l_complete_configuration_flag;
243:
244: l_qte_header_rec.quote_header_id := l_model_line_rec.quote_header_id;

Line 271: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT l_delete_config is true');

267: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
268: END IF;
269:
270: ELSE
271: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT l_delete_config is true');
272: l_delete_config := fnd_api.g_true;
273: IF aso_debug_pub.g_debug_flag = 'Y' THEN
274: aso_debug_pub.add('Validate_Configuration: l_delete_config: '||l_delete_config);
275: END IF;

Line 388: aso_debug_pub.add('ASO_VALIDATE_CFG_PVT Create_header_xml Begins.', 1, 'Y');

384: x_config_lookup_date DATE;
385:
386: BEGIN
387: IF aso_debug_pub.g_debug_flag = 'Y' THEN
388: aso_debug_pub.add('ASO_VALIDATE_CFG_PVT Create_header_xml Begins.', 1, 'Y');
389: END IF;
390:
391: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT rassharm create header xml');
392: --Initialize API return status to SUCCESS

Line 391: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT rassharm create header xml');

387: IF aso_debug_pub.g_debug_flag = 'Y' THEN
388: aso_debug_pub.add('ASO_VALIDATE_CFG_PVT Create_header_xml Begins.', 1, 'Y');
389: END IF;
390:
391: --dbms_output.put_line('Entered ASO_VALIDATE_CFG_PVT rassharm create header xml');
392: --Initialize API return status to SUCCESS
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:
395: l_model_line_rec := aso_utility_pvt.Query_Qte_Line_Row( P_Qte_Line_Id => p_model_line_id );

Line 623: end ASO_VALIDATE_CFG_PVT;

619: END Create_header_xml;
620:
621:
622:
623: end ASO_VALIDATE_CFG_PVT;