eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_VALIDATE_CFG_PVT dependencies on ASO_DEBUG_PUB

Line 88: IF aso_debug_pub.g_debug_flag = 'Y' THEN

84: BEGIN
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,

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 108: IF aso_debug_pub.g_debug_flag = 'Y' THEN

104: l_model_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_model_line_id);
105: l_model_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_model_line_id);
106:
107: -- Call Create_header_xml to create the input header XML message
108: IF aso_debug_pub.g_debug_flag = 'Y' THEN
109: aso_debug_pub.add('Validate_Configuration: Before call to 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;

Line 109: aso_debug_pub.add('Validate_Configuration: Before call to Create_header_xml.');

105: l_model_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_model_line_id);
106:
107: -- Call Create_header_xml to create the input header XML message
108: IF aso_debug_pub.g_debug_flag = 'Y' THEN
109: aso_debug_pub.add('Validate_Configuration: Before call to 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:

Line 110: aso_debug_pub.add('Validate_Configuration: Before call to Create_header_xml. P_EFFECTIVE_DATE'||P_EFFECTIVE_DATE);

106:
107: -- Call Create_header_xml to create the input header XML message
108: IF aso_debug_pub.g_debug_flag = 'Y' THEN
109: aso_debug_pub.add('Validate_Configuration: Before call to 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');

Line 111: aso_debug_pub.add('Validate_Configuration: Before call to Create_header_xml. P_model_lookup_DATE'||P_model_lookup_DATE);

107: -- Call Create_header_xml to create the input header XML message
108: IF aso_debug_pub.g_debug_flag = 'Y' THEN
109: aso_debug_pub.add('Validate_Configuration: Before call to 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,

Line 124: IF aso_debug_pub.g_debug_flag = 'Y' THEN

120: P_model_lookup_DATE => P_model_lookup_DATE,
121: X_xml_hdr => l_xml_hdr,
122: X_return_status => l_return_status );
123:
124: IF aso_debug_pub.g_debug_flag = 'Y' THEN
125:
126: aso_debug_pub.add('Validate_Configuration: After call to Create_header_xml l_return_status: '||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);

Line 126: aso_debug_pub.add('Validate_Configuration: After call to Create_header_xml l_return_status: '||l_return_status);

122: X_return_status => l_return_status );
123:
124: IF aso_debug_pub.g_debug_flag = 'Y' THEN
125:
126: aso_debug_pub.add('Validate_Configuration: After call to Create_header_xml l_return_status: '||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:

Line 127: aso_debug_pub.add('Validate_Configuration: After call to Create_header_xml Length of l_xml_hdr : '||length(l_xml_hdr));

123:
124: IF aso_debug_pub.g_debug_flag = 'Y' THEN
125:
126: aso_debug_pub.add('Validate_Configuration: After call to Create_header_xml l_return_status: '||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);

Line 128: --aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration: Before call to Send_input_xml'||l_xml_hdr);

124: IF aso_debug_pub.g_debug_flag = 'Y' THEN
125:
126: aso_debug_pub.add('Validate_Configuration: After call to Create_header_xml l_return_status: '||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);

Line 138: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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
137:
138: IF aso_debug_pub.g_debug_flag = 'Y' THEN
139: aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration: Before call to Send_input_xml');
140: END IF;
141:
142: ASO_CFG_INT.Send_input_xml( P_Qte_Line_Tbl => P_Qte_Line_Tbl,

Line 139: aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration: Before call to Send_input_xml');

135:
136: -- Call Send_Input_Xml to call CZ batch validate procedure and get the output XML message
137:
138: IF aso_debug_pub.g_debug_flag = 'Y' THEN
139: aso_debug_pub.add('ASO_CFG_INT: Validate_Configuration: Before call to Send_input_xml');
140: END IF;
141:
142: ASO_CFG_INT.Send_input_xml( P_Qte_Line_Tbl => P_Qte_Line_Tbl,
143: P_Qte_Line_Dtl_Tbl => P_Qte_Line_Dtl_Tbl,

Line 152: IF aso_debug_pub.g_debug_flag = 'Y' THEN

148: X_msg_count => l_msg_count,
149: X_msg_data => l_msg_data
150: );
151:
152: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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:

Line 153: aso_debug_pub.add('Validate_Configuration: After call to Send_input_xml');

149: X_msg_data => l_msg_data
150: );
151:
152: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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);

Line 154: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);

150: );
151:
152: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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);

Line 166: IF aso_debug_pub.g_debug_flag = 'Y' THEN

162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
163: l_delete_config := fnd_api.g_true;
164: END IF;
165:
166: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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:

Line 167: aso_debug_pub.add('Validate_Configuration: Before Call to Parse_Output_xml',1,'N');

163: l_delete_config := fnd_api.g_true;
164: END IF;
165:
166: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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);

Line 168: aso_debug_pub.add('Validate_Configuration: l_delete_config: '||l_delete_config);

164: END IF;
165:
166: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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:

Line 184: IF aso_debug_pub.g_debug_flag = 'Y' THEN

180: x_msg_count => l_msg_count,
181: x_msg_data => l_msg_data
182: );
183:
184: IF aso_debug_pub.g_debug_flag = 'Y' THEN
185: aso_debug_pub.add('Validate_Configuration: After call to Parse_output_xml');
186: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
187: END IF;
188:

Line 185: aso_debug_pub.add('Validate_Configuration: After call to Parse_output_xml');

181: x_msg_data => l_msg_data
182: );
183:
184: IF aso_debug_pub.g_debug_flag = 'Y' THEN
185: aso_debug_pub.add('Validate_Configuration: After call to Parse_output_xml');
186: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
187: END IF;
188:
189: END IF;

Line 186: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);

182: );
183:
184: IF aso_debug_pub.g_debug_flag = 'Y' THEN
185: aso_debug_pub.add('Validate_Configuration: After call to Parse_output_xml');
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);

Line 202: IF aso_debug_pub.g_debug_flag = 'Y' THEN

198: if c_config_exist_in_cz%found then
199:
200: close c_config_exist_in_cz;
201:
202: IF aso_debug_pub.g_debug_flag = 'Y' THEN
203: aso_debug_pub.add('Update Quote: A higher version exist for this configuration so deleting it from CZ');
204: END IF;
205:
206: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,

Line 203: aso_debug_pub.add('Update Quote: A higher version exist for this configuration so deleting it from CZ');

199:
200: close c_config_exist_in_cz;
201:
202: IF aso_debug_pub.g_debug_flag = 'Y' THEN
203: aso_debug_pub.add('Update Quote: A higher version exist for this configuration so deleting it from CZ');
204: END IF;
205:
206: ASO_CFG_INT.DELETE_CONFIGURATION_AUTO( P_API_VERSION_NUMBER => 1.0,
207: P_INIT_MSG_LIST => FND_API.G_FALSE,

Line 214: IF aso_debug_pub.g_debug_flag = 'Y' THEN

210: X_RETURN_STATUS => x_return_status,
211: X_MSG_COUNT => x_msg_count,
212: X_MSG_DATA => x_msg_data);
213:
214: IF aso_debug_pub.g_debug_flag = 'Y' THEN
215: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION_AUTO: x_Return_Status: ' || x_Return_Status);
216: END IF;
217:
218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 215: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION_AUTO: x_Return_Status: ' || x_Return_Status);

211: X_MSG_COUNT => x_msg_count,
212: X_MSG_DATA => x_msg_data);
213:
214: IF aso_debug_pub.g_debug_flag = 'Y' THEN
215: aso_debug_pub.add('After call to ASO_CFG_INT.DELETE_CONFIGURATION_AUTO: x_Return_Status: ' || x_Return_Status);
216: END IF;
217:
218: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
219:

Line 247: IF aso_debug_pub.g_debug_flag = 'Y' THEN

243:
244: l_qte_header_rec.quote_header_id := l_model_line_rec.quote_header_id;
245:
246:
247: IF aso_debug_pub.g_debug_flag = 'Y' THEN
248: aso_debug_pub.add('Validate_Configuration: Before Call to ASO_CFG_INT.Get_config_details');
249: END IF;
250:
251: ASO_CFG_INT.Get_config_details(

Line 248: aso_debug_pub.add('Validate_Configuration: Before Call to ASO_CFG_INT.Get_config_details');

244: l_qte_header_rec.quote_header_id := l_model_line_rec.quote_header_id;
245:
246:
247: IF aso_debug_pub.g_debug_flag = 'Y' THEN
248: aso_debug_pub.add('Validate_Configuration: Before Call to ASO_CFG_INT.Get_config_details');
249: END IF;
250:
251: ASO_CFG_INT.Get_config_details(
252: p_api_version_number => 1.0,

Line 265: IF aso_debug_pub.g_debug_flag = 'Y' THEN

261: x_return_status => l_return_status,
262: x_msg_count => l_msg_count,
263: x_msg_data => l_msg_data );
264:
265: IF aso_debug_pub.g_debug_flag = 'Y' THEN
266: aso_debug_pub.add('Validate_Configuration: After Call to Get_config_details');
267: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
268: END IF;
269:

Line 266: aso_debug_pub.add('Validate_Configuration: After Call to Get_config_details');

262: x_msg_count => l_msg_count,
263: x_msg_data => l_msg_data );
264:
265: IF aso_debug_pub.g_debug_flag = 'Y' THEN
266: aso_debug_pub.add('Validate_Configuration: After Call to Get_config_details');
267: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);
268: END IF;
269:
270: ELSE

Line 267: aso_debug_pub.add('Validate_Configuration: l_return_status: '||l_return_status);

263: x_msg_data => l_msg_data );
264:
265: IF aso_debug_pub.g_debug_flag = 'Y' THEN
266: aso_debug_pub.add('Validate_Configuration: After Call to Get_config_details');
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');

Line 273: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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;
276:
277: END IF;

Line 274: aso_debug_pub.add('Validate_Configuration: l_delete_config: '||l_delete_config);

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;
276:
277: END IF;
278:

Line 279: IF aso_debug_pub.g_debug_flag = 'Y' THEN

275: END IF;
276:
277: END IF;
278:
279: IF aso_debug_pub.g_debug_flag = 'Y' THEN
280:
281: aso_debug_pub.add('End of procedure Validate_Configuration');
282: aso_debug_pub.add('l_return_status: '|| l_return_status);
283: aso_debug_pub.add('l_valid_configuration_flag: '|| l_valid_configuration_flag);

Line 281: aso_debug_pub.add('End of procedure Validate_Configuration');

277: END IF;
278:
279: IF aso_debug_pub.g_debug_flag = 'Y' THEN
280:
281: aso_debug_pub.add('End of procedure Validate_Configuration');
282: aso_debug_pub.add('l_return_status: '|| l_return_status);
283: aso_debug_pub.add('l_valid_configuration_flag: '|| l_valid_configuration_flag);
284: aso_debug_pub.add('l_complete_configuration_flag: '|| l_complete_configuration_flag);
285: aso_debug_pub.add('l_config_changed_flag: '|| l_config_changed_flag);

Line 282: aso_debug_pub.add('l_return_status: '|| l_return_status);

278:
279: IF aso_debug_pub.g_debug_flag = 'Y' THEN
280:
281: aso_debug_pub.add('End of procedure Validate_Configuration');
282: aso_debug_pub.add('l_return_status: '|| l_return_status);
283: aso_debug_pub.add('l_valid_configuration_flag: '|| l_valid_configuration_flag);
284: aso_debug_pub.add('l_complete_configuration_flag: '|| l_complete_configuration_flag);
285: aso_debug_pub.add('l_config_changed_flag: '|| l_config_changed_flag);
286: END IF;

Line 283: aso_debug_pub.add('l_valid_configuration_flag: '|| l_valid_configuration_flag);

279: IF aso_debug_pub.g_debug_flag = 'Y' THEN
280:
281: aso_debug_pub.add('End of procedure Validate_Configuration');
282: aso_debug_pub.add('l_return_status: '|| l_return_status);
283: aso_debug_pub.add('l_valid_configuration_flag: '|| l_valid_configuration_flag);
284: aso_debug_pub.add('l_complete_configuration_flag: '|| l_complete_configuration_flag);
285: aso_debug_pub.add('l_config_changed_flag: '|| l_config_changed_flag);
286: END IF;
287:

Line 284: aso_debug_pub.add('l_complete_configuration_flag: '|| l_complete_configuration_flag);

280:
281: aso_debug_pub.add('End of procedure Validate_Configuration');
282: aso_debug_pub.add('l_return_status: '|| l_return_status);
283: aso_debug_pub.add('l_valid_configuration_flag: '|| l_valid_configuration_flag);
284: aso_debug_pub.add('l_complete_configuration_flag: '|| l_complete_configuration_flag);
285: aso_debug_pub.add('l_config_changed_flag: '|| l_config_changed_flag);
286: END IF;
287:
288: x_config_header_id := l_config_header_id;

Line 285: aso_debug_pub.add('l_config_changed_flag: '|| l_config_changed_flag);

281: aso_debug_pub.add('End of procedure Validate_Configuration');
282: aso_debug_pub.add('l_return_status: '|| l_return_status);
283: aso_debug_pub.add('l_valid_configuration_flag: '|| l_valid_configuration_flag);
284: aso_debug_pub.add('l_complete_configuration_flag: '|| l_complete_configuration_flag);
285: aso_debug_pub.add('l_config_changed_flag: '|| l_config_changed_flag);
286: END IF;
287:
288: x_config_header_id := l_config_header_id;
289: x_config_revision_num := l_config_revision_num;

Line 303: IF aso_debug_pub.g_debug_flag = 'Y' THEN

299: x_return_status := FND_API.G_RET_STS_ERROR;
300:
301: end if;
302:
303: IF aso_debug_pub.g_debug_flag = 'Y' THEN
304: aso_debug_pub.add('End of Validate_Configuration', 1, 'N');
305: END IF;
306:
307: EXCEPTION

Line 304: aso_debug_pub.add('End of Validate_Configuration', 1, 'N');

300:
301: end if;
302:
303: IF aso_debug_pub.g_debug_flag = 'Y' THEN
304: aso_debug_pub.add('End of Validate_Configuration', 1, 'N');
305: END IF;
306:
307: EXCEPTION
308:

Line 311: IF aso_debug_pub.g_debug_flag = 'Y' THEN

307: EXCEPTION
308:
309: WHEN OTHERS THEN
310:
311: IF aso_debug_pub.g_debug_flag = 'Y' THEN
312: aso_debug_pub.add('Validate_Configuration: Inside WHEN OTHERS EXCEPTION', 1, 'Y');
313: END IF;
314:
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 312: aso_debug_pub.add('Validate_Configuration: Inside WHEN OTHERS EXCEPTION', 1, 'Y');

308:
309: WHEN OTHERS THEN
310:
311: IF aso_debug_pub.g_debug_flag = 'Y' THEN
312: aso_debug_pub.add('Validate_Configuration: Inside WHEN OTHERS EXCEPTION', 1, 'Y');
313: END IF;
314:
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316:

Line 387: IF aso_debug_pub.g_debug_flag = 'Y' THEN

383: x_config_effective_date DATE;
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');

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 397: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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 );
396:
397: IF aso_debug_pub.g_debug_flag = 'Y' THEN
398: aso_debug_pub.add('Create_header_xml: After call to aso_utility_pvt.Query_Qte_Line_Row');
399: END IF;
400:
401: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );

Line 398: aso_debug_pub.add('Create_header_xml: After call to aso_utility_pvt.Query_Qte_Line_Row');

394:
395: l_model_line_rec := aso_utility_pvt.Query_Qte_Line_Row( P_Qte_Line_Id => p_model_line_id );
396:
397: IF aso_debug_pub.g_debug_flag = 'Y' THEN
398: aso_debug_pub.add('Create_header_xml: After call to aso_utility_pvt.Query_Qte_Line_Row');
399: END IF;
400:
401: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );
402:

Line 403: IF aso_debug_pub.g_debug_flag = 'Y' THEN

399: END IF;
400:
401: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );
402:
403: IF aso_debug_pub.g_debug_flag = 'Y' THEN
404: aso_debug_pub.add('Create_header_xml: After call to aso_utility_pvt.Query_Line_Dtl_Rows');
405: END IF;
406:
407: /* Fix for bug 3998564 */

Line 404: aso_debug_pub.add('Create_header_xml: After call to aso_utility_pvt.Query_Line_Dtl_Rows');

400:
401: l_model_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows( P_Qte_Line_Id => p_model_line_id );
402:
403: IF aso_debug_pub.g_debug_flag = 'Y' THEN
404: aso_debug_pub.add('Create_header_xml: After call to aso_utility_pvt.Query_Line_Dtl_Rows');
405: END IF;
406:
407: /* Fix for bug 3998564 */
408: --OPEN C_org_id( l_model_line_rec.quote_header_id);

Line 416: IF aso_debug_pub.g_debug_flag = 'Y' THEN

412: FETCH c_inv_org_id INTO l_org_id;
413: CLOSE c_inv_org_id;
414: /* End of fix for bug 3998564 */
415:
416: IF aso_debug_pub.g_debug_flag = 'Y' THEN
417: aso_debug_pub.add('Create_header_xml: After C_org_id cursor: l_org_id: '|| l_org_id, 1, 'N');
418: END IF;
419:
420: IF l_org_id IS NULL THEN

Line 417: aso_debug_pub.add('Create_header_xml: After C_org_id cursor: l_org_id: '|| l_org_id, 1, 'N');

413: CLOSE c_inv_org_id;
414: /* End of fix for bug 3998564 */
415:
416: IF aso_debug_pub.g_debug_flag = 'Y' THEN
417: aso_debug_pub.add('Create_header_xml: After C_org_id cursor: l_org_id: '|| l_org_id, 1, 'N');
418: END IF;
419:
420: IF l_org_id IS NULL THEN
421:

Line 435: IF aso_debug_pub.g_debug_flag = 'Y' THEN

431: L_org_id := l_model_line_rec.org_id; --New Code Yogeshwar MOAC
432:
433: END IF;
434:
435: IF aso_debug_pub.g_debug_flag = 'Y' THEN
436: aso_debug_pub.add('Create_header_xml: After Defaulting from client info. l_org_id: '|| l_org_id);
437: END IF;
438:
439: --Set the values from model_line_rec, model_line_dtl_tbl and org_id

Line 436: aso_debug_pub.add('Create_header_xml: After Defaulting from client info. l_org_id: '|| l_org_id);

432:
433: END IF;
434:
435: IF aso_debug_pub.g_debug_flag = 'Y' THEN
436: aso_debug_pub.add('Create_header_xml: After Defaulting from client info. l_org_id: '|| l_org_id);
437: END IF;
438:
439: --Set the values from model_line_rec, model_line_dtl_tbl and org_id
440: l_context_org_id := to_char(l_org_id);

Line 460: IF aso_debug_pub.g_debug_flag = 'Y' THEN

456: l_config_creation_date := to_char(l_model_line_rec.creation_date,'MM-DD-YYYY-HH24-MI-SS');
457: l_model_quantity := to_char(l_model_line_rec.quantity);
458: l_current_date:= to_char(sysdate,'MM-DD-YYYY-HH24-MI-SS');
459:
460: IF aso_debug_pub.g_debug_flag = 'Y' THEN
461:
462: aso_debug_pub.add('Create_header_xml: l_context_org_id :' || l_context_org_id);
463: aso_debug_pub.add('Create_header_xml: l_inventory_item_id :' || l_inventory_item_id);
464: aso_debug_pub.add('Create_header_xml: l_config_header_id :' || l_config_header_id);

Line 462: aso_debug_pub.add('Create_header_xml: l_context_org_id :' || l_context_org_id);

458: l_current_date:= to_char(sysdate,'MM-DD-YYYY-HH24-MI-SS');
459:
460: IF aso_debug_pub.g_debug_flag = 'Y' THEN
461:
462: aso_debug_pub.add('Create_header_xml: l_context_org_id :' || l_context_org_id);
463: aso_debug_pub.add('Create_header_xml: l_inventory_item_id :' || l_inventory_item_id);
464: aso_debug_pub.add('Create_header_xml: l_config_header_id :' || l_config_header_id);
465: aso_debug_pub.add('Create_header_xml: l_config_rev_nbr :' || l_config_rev_nbr);
466: aso_debug_pub.add('Create_header_xml: l_config_creation_date:' || l_config_creation_date);

Line 463: aso_debug_pub.add('Create_header_xml: l_inventory_item_id :' || l_inventory_item_id);

459:
460: IF aso_debug_pub.g_debug_flag = 'Y' THEN
461:
462: aso_debug_pub.add('Create_header_xml: l_context_org_id :' || l_context_org_id);
463: aso_debug_pub.add('Create_header_xml: l_inventory_item_id :' || l_inventory_item_id);
464: aso_debug_pub.add('Create_header_xml: l_config_header_id :' || l_config_header_id);
465: aso_debug_pub.add('Create_header_xml: l_config_rev_nbr :' || l_config_rev_nbr);
466: aso_debug_pub.add('Create_header_xml: l_config_creation_date:' || l_config_creation_date);
467: aso_debug_pub.add('Create_header_xml: l_model_quantity :' || l_model_quantity);

Line 464: aso_debug_pub.add('Create_header_xml: l_config_header_id :' || l_config_header_id);

460: IF aso_debug_pub.g_debug_flag = 'Y' THEN
461:
462: aso_debug_pub.add('Create_header_xml: l_context_org_id :' || l_context_org_id);
463: aso_debug_pub.add('Create_header_xml: l_inventory_item_id :' || l_inventory_item_id);
464: aso_debug_pub.add('Create_header_xml: l_config_header_id :' || l_config_header_id);
465: aso_debug_pub.add('Create_header_xml: l_config_rev_nbr :' || l_config_rev_nbr);
466: aso_debug_pub.add('Create_header_xml: l_config_creation_date:' || l_config_creation_date);
467: aso_debug_pub.add('Create_header_xml: l_model_quantity :' || l_model_quantity);
468: aso_debug_pub.add('Create_header_xml: l_current_date:' || l_current_date);

Line 465: aso_debug_pub.add('Create_header_xml: l_config_rev_nbr :' || l_config_rev_nbr);

461:
462: aso_debug_pub.add('Create_header_xml: l_context_org_id :' || l_context_org_id);
463: aso_debug_pub.add('Create_header_xml: l_inventory_item_id :' || l_inventory_item_id);
464: aso_debug_pub.add('Create_header_xml: l_config_header_id :' || l_config_header_id);
465: aso_debug_pub.add('Create_header_xml: l_config_rev_nbr :' || l_config_rev_nbr);
466: aso_debug_pub.add('Create_header_xml: l_config_creation_date:' || l_config_creation_date);
467: aso_debug_pub.add('Create_header_xml: l_model_quantity :' || l_model_quantity);
468: aso_debug_pub.add('Create_header_xml: l_current_date:' || l_current_date);
469:

Line 466: aso_debug_pub.add('Create_header_xml: l_config_creation_date:' || l_config_creation_date);

462: aso_debug_pub.add('Create_header_xml: l_context_org_id :' || l_context_org_id);
463: aso_debug_pub.add('Create_header_xml: l_inventory_item_id :' || l_inventory_item_id);
464: aso_debug_pub.add('Create_header_xml: l_config_header_id :' || l_config_header_id);
465: aso_debug_pub.add('Create_header_xml: l_config_rev_nbr :' || l_config_rev_nbr);
466: aso_debug_pub.add('Create_header_xml: l_config_creation_date:' || l_config_creation_date);
467: aso_debug_pub.add('Create_header_xml: l_model_quantity :' || l_model_quantity);
468: aso_debug_pub.add('Create_header_xml: l_current_date:' || l_current_date);
469:
470: END IF;

Line 467: aso_debug_pub.add('Create_header_xml: l_model_quantity :' || l_model_quantity);

463: aso_debug_pub.add('Create_header_xml: l_inventory_item_id :' || l_inventory_item_id);
464: aso_debug_pub.add('Create_header_xml: l_config_header_id :' || l_config_header_id);
465: aso_debug_pub.add('Create_header_xml: l_config_rev_nbr :' || l_config_rev_nbr);
466: aso_debug_pub.add('Create_header_xml: l_config_creation_date:' || l_config_creation_date);
467: aso_debug_pub.add('Create_header_xml: l_model_quantity :' || l_model_quantity);
468: aso_debug_pub.add('Create_header_xml: l_current_date:' || l_current_date);
469:
470: END IF;
471:

Line 468: aso_debug_pub.add('Create_header_xml: l_current_date:' || l_current_date);

464: aso_debug_pub.add('Create_header_xml: l_config_header_id :' || l_config_header_id);
465: aso_debug_pub.add('Create_header_xml: l_config_rev_nbr :' || l_config_rev_nbr);
466: aso_debug_pub.add('Create_header_xml: l_config_creation_date:' || l_config_creation_date);
467: aso_debug_pub.add('Create_header_xml: l_model_quantity :' || l_model_quantity);
468: aso_debug_pub.add('Create_header_xml: l_current_date:' || l_current_date);
469:
470: END IF;
471:
472: -- Set values from profiles and env. variables.

Line 478: IF aso_debug_pub.g_debug_flag = 'Y' THEN

474: l_responsibility_id := fnd_global.resp_id;
475: l_database_id := fnd_web_config.database_id;
476: l_icx_session_ticket := cz_cf_api.icx_session_ticket;
477:
478: IF aso_debug_pub.g_debug_flag = 'Y' THEN
479:
480: aso_debug_pub.add('Create_header_xml: l_calling_application_id:' || l_calling_application_id);
481: aso_debug_pub.add('Create_header_xml: l_responsibility_id :' || l_responsibility_id);
482: aso_debug_pub.add('Create_header_xml: l_database_id :' || l_database_id);

Line 480: aso_debug_pub.add('Create_header_xml: l_calling_application_id:' || l_calling_application_id);

476: l_icx_session_ticket := cz_cf_api.icx_session_ticket;
477:
478: IF aso_debug_pub.g_debug_flag = 'Y' THEN
479:
480: aso_debug_pub.add('Create_header_xml: l_calling_application_id:' || l_calling_application_id);
481: aso_debug_pub.add('Create_header_xml: l_responsibility_id :' || l_responsibility_id);
482: aso_debug_pub.add('Create_header_xml: l_database_id :' || l_database_id);
483: aso_debug_pub.add('Create_header_xml: l_icx_session_ticket :' || l_icx_session_ticket);
484: aso_debug_pub.add('Create_header_xml: profile value:'|| l_config_effective_date_prof);

Line 481: aso_debug_pub.add('Create_header_xml: l_responsibility_id :' || l_responsibility_id);

477:
478: IF aso_debug_pub.g_debug_flag = 'Y' THEN
479:
480: aso_debug_pub.add('Create_header_xml: l_calling_application_id:' || l_calling_application_id);
481: aso_debug_pub.add('Create_header_xml: l_responsibility_id :' || l_responsibility_id);
482: aso_debug_pub.add('Create_header_xml: l_database_id :' || l_database_id);
483: aso_debug_pub.add('Create_header_xml: l_icx_session_ticket :' || l_icx_session_ticket);
484: aso_debug_pub.add('Create_header_xml: profile value:'|| l_config_effective_date_prof);
485:

Line 482: aso_debug_pub.add('Create_header_xml: l_database_id :' || l_database_id);

478: IF aso_debug_pub.g_debug_flag = 'Y' THEN
479:
480: aso_debug_pub.add('Create_header_xml: l_calling_application_id:' || l_calling_application_id);
481: aso_debug_pub.add('Create_header_xml: l_responsibility_id :' || l_responsibility_id);
482: aso_debug_pub.add('Create_header_xml: l_database_id :' || l_database_id);
483: aso_debug_pub.add('Create_header_xml: l_icx_session_ticket :' || l_icx_session_ticket);
484: aso_debug_pub.add('Create_header_xml: profile value:'|| l_config_effective_date_prof);
485:
486: END IF;

Line 483: aso_debug_pub.add('Create_header_xml: l_icx_session_ticket :' || l_icx_session_ticket);

479:
480: aso_debug_pub.add('Create_header_xml: l_calling_application_id:' || l_calling_application_id);
481: aso_debug_pub.add('Create_header_xml: l_responsibility_id :' || l_responsibility_id);
482: aso_debug_pub.add('Create_header_xml: l_database_id :' || l_database_id);
483: aso_debug_pub.add('Create_header_xml: l_icx_session_ticket :' || l_icx_session_ticket);
484: aso_debug_pub.add('Create_header_xml: profile value:'|| l_config_effective_date_prof);
485:
486: END IF;
487:

Line 484: aso_debug_pub.add('Create_header_xml: profile value:'|| l_config_effective_date_prof);

480: aso_debug_pub.add('Create_header_xml: l_calling_application_id:' || l_calling_application_id);
481: aso_debug_pub.add('Create_header_xml: l_responsibility_id :' || l_responsibility_id);
482: aso_debug_pub.add('Create_header_xml: l_database_id :' || l_database_id);
483: aso_debug_pub.add('Create_header_xml: l_icx_session_ticket :' || l_icx_session_ticket);
484: aso_debug_pub.add('Create_header_xml: profile value:'|| l_config_effective_date_prof);
485:
486: END IF;
487:
488: -- set param_names

Line 530: aso_debug_pub.add('Create_header_xml: Effective date provided ');

526: param_value(12) := l_model_quantity;
527: param_value(13) := l_icx_session_ticket;
528:
529: if (p_effective_date<>fnd_API.G_MISS_DATE) then
530: aso_debug_pub.add('Create_header_xml: Effective date provided ');
531: param_value(14) := to_char(p_effective_date,'MM-DD-YYYY-HH24-MI-SS');
532: param_value(15) :=to_char(P_model_lookup_DATE,'MM-DD-YYYY-HH24-MI-SS');
533: else
534: aso_debug_pub.add('Create_header_xml: Effective date not provided, use profile instead ');

Line 534: aso_debug_pub.add('Create_header_xml: Effective date not provided, use profile instead ');

530: aso_debug_pub.add('Create_header_xml: Effective date provided ');
531: param_value(14) := to_char(p_effective_date,'MM-DD-YYYY-HH24-MI-SS');
532: param_value(15) :=to_char(P_model_lookup_DATE,'MM-DD-YYYY-HH24-MI-SS');
533: else
534: aso_debug_pub.add('Create_header_xml: Effective date not provided, use profile instead ');
535: -- Added extra parameters for config effective and lookup date ER 3177722 and setting the value based on new profile ASO : Configuration Effective Date
536: if l_config_effective_date_prof='C' then -- set to creation date
537: param_value(14) := l_config_creation_date;
538: param_value(15) := l_config_creation_date;

Line 559: -- aso_debug_pub.add('Create_header_xml: before forming xml loop ');

555: end if;
556: end if; -- p_effective_date
557:
558: l_rec_index := 1;
559: -- aso_debug_pub.add('Create_header_xml: before forming xml loop ');
560: LOOP
561: -- ex : 1890
562:
563: IF (param_value(l_rec_index) IS NOT NULL) THEN

Line 569: -- aso_debug_pub.add('Create_header_xml: before forming xml loop '||length(l_dummy));

565: l_dummy := ' 567: ||'>'|| param_value(l_rec_index) ||
568: '';
569: -- aso_debug_pub.add('Create_header_xml: before forming xml loop '||length(l_dummy));
570: -- aso_debug_pub.add('Create_header_xml: before forming xml loop '||l_dummy);
571: --aso_debug_pub.add('Create_header_xml: before forming xml loop '||length(l_xml_hdr));
572: l_xml_hdr := l_xml_hdr || l_dummy;
573:

Line 570: -- aso_debug_pub.add('Create_header_xml: before forming xml loop '||l_dummy);

566: '"' || param_name(l_rec_index) || '"'
567: ||'>'|| param_value(l_rec_index) ||
568: '';
569: -- aso_debug_pub.add('Create_header_xml: before forming xml loop '||length(l_dummy));
570: -- aso_debug_pub.add('Create_header_xml: before forming xml loop '||l_dummy);
571: --aso_debug_pub.add('Create_header_xml: before forming xml loop '||length(l_xml_hdr));
572: l_xml_hdr := l_xml_hdr || l_dummy;
573:
574: END IF;

Line 571: --aso_debug_pub.add('Create_header_xml: before forming xml loop '||length(l_xml_hdr));

567: ||'>'|| param_value(l_rec_index) ||
568: '';
569: -- aso_debug_pub.add('Create_header_xml: before forming xml loop '||length(l_dummy));
570: -- aso_debug_pub.add('Create_header_xml: before forming xml loop '||l_dummy);
571: --aso_debug_pub.add('Create_header_xml: before forming xml loop '||length(l_xml_hdr));
572: l_xml_hdr := l_xml_hdr || l_dummy;
573:
574: END IF;
575:

Line 588: IF aso_debug_pub.g_debug_flag = 'Y' THEN

584:
585: l_xml_hdr := l_xml_hdr || '';
586: l_xml_hdr := REPLACE(l_xml_hdr, ' ' , '+');
587:
588: IF aso_debug_pub.g_debug_flag = 'Y' THEN
589:
590: aso_debug_pub.add('Create_header_xml: Length of l_xml_hdr mesg: '||length(l_xml_hdr));
591: aso_debug_pub.add('Create_header_xml: 1st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 1, 100));
592: aso_debug_pub.add('Create_header_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));

Line 590: aso_debug_pub.add('Create_header_xml: Length of l_xml_hdr mesg: '||length(l_xml_hdr));

586: l_xml_hdr := REPLACE(l_xml_hdr, ' ' , '+');
587:
588: IF aso_debug_pub.g_debug_flag = 'Y' THEN
589:
590: aso_debug_pub.add('Create_header_xml: Length of l_xml_hdr mesg: '||length(l_xml_hdr));
591: aso_debug_pub.add('Create_header_xml: 1st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 1, 100));
592: aso_debug_pub.add('Create_header_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));
593: aso_debug_pub.add('Create_header_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
594: aso_debug_pub.add('Create_header_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));

Line 591: aso_debug_pub.add('Create_header_xml: 1st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 1, 100));

587:
588: IF aso_debug_pub.g_debug_flag = 'Y' THEN
589:
590: aso_debug_pub.add('Create_header_xml: Length of l_xml_hdr mesg: '||length(l_xml_hdr));
591: aso_debug_pub.add('Create_header_xml: 1st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 1, 100));
592: aso_debug_pub.add('Create_header_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));
593: aso_debug_pub.add('Create_header_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
594: aso_debug_pub.add('Create_header_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
595: aso_debug_pub.add('Create_header_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));

Line 592: aso_debug_pub.add('Create_header_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));

588: IF aso_debug_pub.g_debug_flag = 'Y' THEN
589:
590: aso_debug_pub.add('Create_header_xml: Length of l_xml_hdr mesg: '||length(l_xml_hdr));
591: aso_debug_pub.add('Create_header_xml: 1st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 1, 100));
592: aso_debug_pub.add('Create_header_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));
593: aso_debug_pub.add('Create_header_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
594: aso_debug_pub.add('Create_header_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
595: aso_debug_pub.add('Create_header_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));
596: aso_debug_pub.add('Create_header_xml: 6nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 501, 100));

Line 593: aso_debug_pub.add('Create_header_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));

589:
590: aso_debug_pub.add('Create_header_xml: Length of l_xml_hdr mesg: '||length(l_xml_hdr));
591: aso_debug_pub.add('Create_header_xml: 1st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 1, 100));
592: aso_debug_pub.add('Create_header_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));
593: aso_debug_pub.add('Create_header_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
594: aso_debug_pub.add('Create_header_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
595: aso_debug_pub.add('Create_header_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));
596: aso_debug_pub.add('Create_header_xml: 6nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 501, 100));
597: aso_debug_pub.add('Create_header_xml: 7rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 601, 100));

Line 594: aso_debug_pub.add('Create_header_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));

590: aso_debug_pub.add('Create_header_xml: Length of l_xml_hdr mesg: '||length(l_xml_hdr));
591: aso_debug_pub.add('Create_header_xml: 1st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 1, 100));
592: aso_debug_pub.add('Create_header_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));
593: aso_debug_pub.add('Create_header_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
594: aso_debug_pub.add('Create_header_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
595: aso_debug_pub.add('Create_header_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));
596: aso_debug_pub.add('Create_header_xml: 6nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 501, 100));
597: aso_debug_pub.add('Create_header_xml: 7rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 601, 100));
598: aso_debug_pub.add('Create_header_xml: 8th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 701, 100));

Line 595: aso_debug_pub.add('Create_header_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));

591: aso_debug_pub.add('Create_header_xml: 1st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 1, 100));
592: aso_debug_pub.add('Create_header_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));
593: aso_debug_pub.add('Create_header_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
594: aso_debug_pub.add('Create_header_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
595: aso_debug_pub.add('Create_header_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));
596: aso_debug_pub.add('Create_header_xml: 6nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 501, 100));
597: aso_debug_pub.add('Create_header_xml: 7rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 601, 100));
598: aso_debug_pub.add('Create_header_xml: 8th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 701, 100));
599:

Line 596: aso_debug_pub.add('Create_header_xml: 6nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 501, 100));

592: aso_debug_pub.add('Create_header_xml: 2nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 101, 100));
593: aso_debug_pub.add('Create_header_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
594: aso_debug_pub.add('Create_header_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
595: aso_debug_pub.add('Create_header_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));
596: aso_debug_pub.add('Create_header_xml: 6nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 501, 100));
597: aso_debug_pub.add('Create_header_xml: 7rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 601, 100));
598: aso_debug_pub.add('Create_header_xml: 8th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 701, 100));
599:
600: END IF;

Line 597: aso_debug_pub.add('Create_header_xml: 7rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 601, 100));

593: aso_debug_pub.add('Create_header_xml: 3rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 201, 100));
594: aso_debug_pub.add('Create_header_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
595: aso_debug_pub.add('Create_header_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));
596: aso_debug_pub.add('Create_header_xml: 6nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 501, 100));
597: aso_debug_pub.add('Create_header_xml: 7rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 601, 100));
598: aso_debug_pub.add('Create_header_xml: 8th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 701, 100));
599:
600: END IF;
601:

Line 598: aso_debug_pub.add('Create_header_xml: 8th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 701, 100));

594: aso_debug_pub.add('Create_header_xml: 4th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 301, 100));
595: aso_debug_pub.add('Create_header_xml: 5st Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 401, 100));
596: aso_debug_pub.add('Create_header_xml: 6nd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 501, 100));
597: aso_debug_pub.add('Create_header_xml: 7rd Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 601, 100));
598: aso_debug_pub.add('Create_header_xml: 8th Part of l_xml_hdr is: '||SUBSTR(l_xml_hdr, 701, 100));
599:
600: END IF;
601:
602: x_xml_hdr := l_xml_hdr;

Line 604: IF aso_debug_pub.g_debug_flag = 'Y' THEN

600: END IF;
601:
602: x_xml_hdr := l_xml_hdr;
603:
604: IF aso_debug_pub.g_debug_flag = 'Y' THEN
605: aso_debug_pub.add('End of Create_header_xml.', 1, 'Y');
606: END IF;
607:
608:

Line 605: aso_debug_pub.add('End of Create_header_xml.', 1, 'Y');

601:
602: x_xml_hdr := l_xml_hdr;
603:
604: IF aso_debug_pub.g_debug_flag = 'Y' THEN
605: aso_debug_pub.add('End of Create_header_xml.', 1, 'Y');
606: END IF;
607:
608:
609: EXCEPTION

Line 615: IF aso_debug_pub.g_debug_flag = 'Y' THEN

611: when others then
612:
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614:
615: IF aso_debug_pub.g_debug_flag = 'Y' THEN
616: aso_debug_pub.add('Create_header_xml: Inside When Others Exception: x_return_status: '||x_return_status, 1, 'N');
617: END IF;
618:
619: END Create_header_xml;

Line 616: aso_debug_pub.add('Create_header_xml: Inside When Others Exception: x_return_status: '||x_return_status, 1, 'N');

612:
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614:
615: IF aso_debug_pub.g_debug_flag = 'Y' THEN
616: aso_debug_pub.add('Create_header_xml: Inside When Others Exception: x_return_status: '||x_return_status, 1, 'N');
617: END IF;
618:
619: END Create_header_xml;
620: