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_QUOTE_TMPL_PVT dependencies on ASO_DEBUG_PUB

Line 134: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

130:
131: -- Standard Start of API savepoint
132: SAVEPOINT Add_Template_To_Quote_PVT;
133:
134: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
135:
136: IF aso_debug_pub.g_debug_flag = 'Y' THEN
137: aso_debug_pub.add('****** Start of Add_Template_To_Quote API ******', 1, 'Y');
138: END IF;

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

132: SAVEPOINT Add_Template_To_Quote_PVT;
133:
134: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
135:
136: IF aso_debug_pub.g_debug_flag = 'Y' THEN
137: aso_debug_pub.add('****** Start of Add_Template_To_Quote API ******', 1, 'Y');
138: END IF;
139:
140: -- Standard call to check for call compatibility.

Line 137: aso_debug_pub.add(' Start of Add_Template_To_Quote API ', 1, 'Y');

133:
134: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
135:
136: IF aso_debug_pub.g_debug_flag = 'Y' THEN
137: aso_debug_pub.add('****** Start of Add_Template_To_Quote API ******', 1, 'Y');
138: END IF;
139:
140: -- Standard call to check for call compatibility.
141: IF NOT FND_API.Compatible_API_Call(

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

158: -- API body
159: l_qte_header_rec := p_qte_header_rec;
160:
161: IF (p_qte_header_rec.org_id is null or p_qte_header_rec.org_id = fnd_api.g_miss_num ) then
162: IF aso_debug_pub.g_debug_flag = 'Y' THEN
163: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Input ogr_id is null or g_miss', 1, 'Y');
164: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: p_qte_header_rec.quote_header_id: ' || p_qte_header_rec.quote_header_id, 1, 'Y');
165: END IF;
166:

Line 163: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Input ogr_id is null or g_miss', 1, 'Y');

159: l_qte_header_rec := p_qte_header_rec;
160:
161: IF (p_qte_header_rec.org_id is null or p_qte_header_rec.org_id = fnd_api.g_miss_num ) then
162: IF aso_debug_pub.g_debug_flag = 'Y' THEN
163: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Input ogr_id is null or g_miss', 1, 'Y');
164: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: p_qte_header_rec.quote_header_id: ' || p_qte_header_rec.quote_header_id, 1, 'Y');
165: END IF;
166:
167: open c_get_org_id(p_qte_header_rec.quote_header_id);

Line 164: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: p_qte_header_rec.quote_header_id: ' || p_qte_header_rec.quote_header_id, 1, 'Y');

160:
161: IF (p_qte_header_rec.org_id is null or p_qte_header_rec.org_id = fnd_api.g_miss_num ) then
162: IF aso_debug_pub.g_debug_flag = 'Y' THEN
163: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Input ogr_id is null or g_miss', 1, 'Y');
164: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: p_qte_header_rec.quote_header_id: ' || p_qte_header_rec.quote_header_id, 1, 'Y');
165: END IF;
166:
167: open c_get_org_id(p_qte_header_rec.quote_header_id);
168: fetch c_get_org_id into l_qte_header_rec.org_id;

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

171:
172:
173: END IF;
174:
175: IF aso_debug_pub.g_debug_flag = 'Y' THEN
176: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: l_qte_header_rec.org_id: '|| l_qte_header_rec.org_id, 1, 'Y');
177: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: p_qte_header_rec.org_id: '|| p_qte_header_rec.org_id, 1, 'Y');
178: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:template filter profile value: '|| l_prof_temp_filter, 1, 'Y');
179: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before setting org context '||p_template_id_tbl.count);

Line 176: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: l_qte_header_rec.org_id: '|| l_qte_header_rec.org_id, 1, 'Y');

172:
173: END IF;
174:
175: IF aso_debug_pub.g_debug_flag = 'Y' THEN
176: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: l_qte_header_rec.org_id: '|| l_qte_header_rec.org_id, 1, 'Y');
177: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: p_qte_header_rec.org_id: '|| p_qte_header_rec.org_id, 1, 'Y');
178: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:template filter profile value: '|| l_prof_temp_filter, 1, 'Y');
179: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before setting org context '||p_template_id_tbl.count);
180: END IF;

Line 177: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: p_qte_header_rec.org_id: '|| p_qte_header_rec.org_id, 1, 'Y');

173: END IF;
174:
175: IF aso_debug_pub.g_debug_flag = 'Y' THEN
176: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: l_qte_header_rec.org_id: '|| l_qte_header_rec.org_id, 1, 'Y');
177: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: p_qte_header_rec.org_id: '|| p_qte_header_rec.org_id, 1, 'Y');
178: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:template filter profile value: '|| l_prof_temp_filter, 1, 'Y');
179: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before setting org context '||p_template_id_tbl.count);
180: END IF;
181:

Line 178: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:template filter profile value: '|| l_prof_temp_filter, 1, 'Y');

174:
175: IF aso_debug_pub.g_debug_flag = 'Y' THEN
176: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: l_qte_header_rec.org_id: '|| l_qte_header_rec.org_id, 1, 'Y');
177: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: p_qte_header_rec.org_id: '|| p_qte_header_rec.org_id, 1, 'Y');
178: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:template filter profile value: '|| l_prof_temp_filter, 1, 'Y');
179: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before setting org context '||p_template_id_tbl.count);
180: END IF;
181:
182:

Line 179: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before setting org context '||p_template_id_tbl.count);

175: IF aso_debug_pub.g_debug_flag = 'Y' THEN
176: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: l_qte_header_rec.org_id: '|| l_qte_header_rec.org_id, 1, 'Y');
177: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: p_qte_header_rec.org_id: '|| p_qte_header_rec.org_id, 1, 'Y');
178: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:template filter profile value: '|| l_prof_temp_filter, 1, 'Y');
179: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before setting org context '||p_template_id_tbl.count);
180: END IF;
181:
182:
183:

Line 204: --aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: entered else of profile');

200: -- Quote operating unit is same as template operating unit
201: if l_prof_temp_filter='Q' then
202: l_validate_item:=true;
203: else
204: --aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: entered else of profile');
205: -- validate item based on new operating unit
206: l_validate_item:=Validate_Item(
207: p_qte_header_rec => l_qte_header_rec,
208: p_quote_line_id => l_qte_line_tbl(j).quote_line_id,

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

231:
232: l_pricing_control_rec.request_type := 'ASO';
233: l_pricing_control_rec.pricing_event := 'BATCH';
234:
235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
236: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Validate_Pricing_Order', 1, 'Y');
237: END IF;
238:
239: ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order(

Line 236: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Validate_Pricing_Order', 1, 'Y');

232: l_pricing_control_rec.request_type := 'ASO';
233: l_pricing_control_rec.pricing_event := 'BATCH';
234:
235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
236: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Validate_Pricing_Order', 1, 'Y');
237: END IF;
238:
239: ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order(
240: p_api_version_number => 1.0,

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

253: x_msg_count => x_msg_count,
254: x_msg_data => x_msg_data
255: );
256:
257: IF aso_debug_pub.g_debug_flag = 'Y' THEN
258: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Validate_Pricing_Order', 1, 'Y');
259: END IF;
260:
261: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 258: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Validate_Pricing_Order', 1, 'Y');

254: x_msg_data => x_msg_data
255: );
256:
257: IF aso_debug_pub.g_debug_flag = 'Y' THEN
258: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Validate_Pricing_Order', 1, 'Y');
259: END IF;
260:
261: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
262: RAISE FND_API.G_EXC_ERROR;

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

263: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266:
267: IF aso_debug_pub.g_debug_flag = 'Y' THEN
268: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start validated lines loop', 1, 'Y');
269: END IF;
270:
271: FOR i IN 1..lpx_qte_line_tbl.count LOOP

Line 268: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start validated lines loop', 1, 'Y');

264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266:
267: IF aso_debug_pub.g_debug_flag = 'Y' THEN
268: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start validated lines loop', 1, 'Y');
269: END IF;
270:
271: FOR i IN 1..lpx_qte_line_tbl.count LOOP
272: IF lpx_qte_line_tbl(i).pricing_status_code <> FND_API.G_RET_STS_SUCCESS THEN

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

275: FOR conc_segments_rec IN c_conc_segments(lpx_qte_line_tbl(i).inventory_item_id) LOOP
276: l_conc_segments := conc_segments_rec.concatenated_segments;
277: END LOOP;
278:
279: IF aso_debug_pub.g_debug_flag = 'Y' THEN
280: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: item has pricing error: ' || lpx_qte_line_tbl(i).pricing_status_text, 1, 'N');
281: END IF;
282: FND_MESSAGE.Set_Name('ASO', 'ASO_QTM_INVALID_PRICELIST');
283: FND_MESSAGE.Set_Token('INVITEM', l_conc_segments, FALSE);

Line 280: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: item has pricing error: ' || lpx_qte_line_tbl(i).pricing_status_text, 1, 'N');

276: l_conc_segments := conc_segments_rec.concatenated_segments;
277: END LOOP;
278:
279: IF aso_debug_pub.g_debug_flag = 'Y' THEN
280: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: item has pricing error: ' || lpx_qte_line_tbl(i).pricing_status_text, 1, 'N');
281: END IF;
282: FND_MESSAGE.Set_Name('ASO', 'ASO_QTM_INVALID_PRICELIST');
283: FND_MESSAGE.Set_Token('INVITEM', l_conc_segments, FALSE);
284: FND_MSG_PUB.ADD;

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

296: END LOOP;
297: END IF;
298: END LOOP;
299:
300: IF aso_debug_pub.g_debug_flag = 'Y' THEN
301: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end validated lines loop', 1, 'Y');
302: END IF;
303:
304: l_template_line_count := 0;

Line 301: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end validated lines loop', 1, 'Y');

297: END IF;
298: END LOOP;
299:
300: IF aso_debug_pub.g_debug_flag = 'Y' THEN
301: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end validated lines loop', 1, 'Y');
302: END IF;
303:
304: l_template_line_count := 0;
305:

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

302: END IF;
303:
304: l_template_line_count := 0;
305:
306: IF aso_debug_pub.g_debug_flag = 'Y' THEN
307: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start drop items loop', 1, 'Y');
308: END IF;
309:
310: FOR i IN 1..lpx_qte_line_tbl.count LOOP

Line 307: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start drop items loop', 1, 'Y');

303:
304: l_template_line_count := 0;
305:
306: IF aso_debug_pub.g_debug_flag = 'Y' THEN
307: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start drop items loop', 1, 'Y');
308: END IF;
309:
310: FOR i IN 1..lpx_qte_line_tbl.count LOOP
311: l_dropped_flag := 'N';

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

320: l_search_line_id_tbl(lpx_qte_line_tbl(i).quote_line_id) := l_template_line_count;
321: END IF;
322: END LOOP;
323:
324: IF aso_debug_pub.g_debug_flag = 'Y' THEN
325: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end drop items loop', 1, 'Y');
326: END IF;
327:
328: l_template_line_count := 0;

Line 325: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end drop items loop', 1, 'Y');

321: END IF;
322: END LOOP;
323:
324: IF aso_debug_pub.g_debug_flag = 'Y' THEN
325: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end drop items loop', 1, 'Y');
326: END IF;
327:
328: l_template_line_count := 0;
329:

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

326: END IF;
327:
328: l_template_line_count := 0;
329:
330: IF aso_debug_pub.g_debug_flag = 'Y' THEN
331: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start line details loop', 1, 'Y');
332: END IF;
333:
334: FOR i IN 1..l_qte_line_tbl.count LOOP

Line 331: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start line details loop', 1, 'Y');

327:
328: l_template_line_count := 0;
329:
330: IF aso_debug_pub.g_debug_flag = 'Y' THEN
331: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start line details loop', 1, 'Y');
332: END IF;
333:
334: FOR i IN 1..l_qte_line_tbl.count LOOP
335: IF l_qte_line_tbl(i).item_type_code IN ('MDL','CFG') THEN

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

392: END IF;
393:
394: END LOOP;
395:
396: IF aso_debug_pub.g_debug_flag = 'Y' THEN
397: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end line details loop', 1, 'Y');
398: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start copy configuration loop', 1, 'Y');
399: END IF;
400:

Line 397: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end line details loop', 1, 'Y');

393:
394: END LOOP;
395:
396: IF aso_debug_pub.g_debug_flag = 'Y' THEN
397: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end line details loop', 1, 'Y');
398: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start copy configuration loop', 1, 'Y');
399: END IF;
400:
401: FOR i IN 1..l_qte_line_tbl.count LOOP

Line 398: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start copy configuration loop', 1, 'Y');

394: END LOOP;
395:
396: IF aso_debug_pub.g_debug_flag = 'Y' THEN
397: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end line details loop', 1, 'Y');
398: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start copy configuration loop', 1, 'Y');
399: END IF;
400:
401: FOR i IN 1..l_qte_line_tbl.count LOOP
402: IF l_qte_line_tbl(i).item_type_code = 'MDL' THEN

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

408: l_config_header_id := l_qte_line_dtl_tbl(j).config_header_id;
409: l_config_rev_number := l_qte_line_dtl_tbl(j).config_revision_num;
410:
411:
412: IF aso_debug_pub.g_debug_flag = 'Y' THEN
413: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Copy_Configuration', 1, 'Y');
414: END IF;
415:
416:

Line 413: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Copy_Configuration', 1, 'Y');

409: l_config_rev_number := l_qte_line_dtl_tbl(j).config_revision_num;
410:
411:
412: IF aso_debug_pub.g_debug_flag = 'Y' THEN
413: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Copy_Configuration', 1, 'Y');
414: END IF;
415:
416:
417: /*ASO_CFG_INT.Copy_Configuration(

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

443: x_msg_count => x_msg_count,
444: x_msg_data => x_msg_data
445: );
446:
447: IF aso_debug_pub.g_debug_flag = 'Y' THEN
448: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Copy_Configuration', 1, 'Y');
449: END IF;
450:
451: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 448: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Copy_Configuration', 1, 'Y');

444: x_msg_data => x_msg_data
445: );
446:
447: IF aso_debug_pub.g_debug_flag = 'Y' THEN
448: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Copy_Configuration', 1, 'Y');
449: END IF;
450:
451: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
452: RAISE FND_API.G_EXC_ERROR;

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

492: x_qte_line_tbl := l_qte_line_tbl;
493: x_qte_line_dtl_tbl := l_qte_line_dtl_tbl;
494: ELSE
495:
496: IF aso_debug_pub.g_debug_flag = 'Y' THEN
497: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end copy configuration loop', 1, 'Y');
498: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Update_Quote', 1, 'Y');
499:
500: END IF;

Line 497: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end copy configuration loop', 1, 'Y');

493: x_qte_line_dtl_tbl := l_qte_line_dtl_tbl;
494: ELSE
495:
496: IF aso_debug_pub.g_debug_flag = 'Y' THEN
497: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end copy configuration loop', 1, 'Y');
498: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Update_Quote', 1, 'Y');
499:
500: END IF;
501:

Line 498: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Update_Quote', 1, 'Y');

494: ELSE
495:
496: IF aso_debug_pub.g_debug_flag = 'Y' THEN
497: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end copy configuration loop', 1, 'Y');
498: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Update_Quote', 1, 'Y');
499:
500: END IF;
501:
502: --mo_global.set_policy_context('S', l_qte_header_rec.org_id);

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

532: );
533:
534: --mo_global.set_policy_context('M', null);
535:
536: IF aso_debug_pub.g_debug_flag = 'Y' THEN
537: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Update_Quote', 1, 'Y');
538: END IF;
539:
540: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 537: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Update_Quote', 1, 'Y');

533:
534: --mo_global.set_policy_context('M', null);
535:
536: IF aso_debug_pub.g_debug_flag = 'Y' THEN
537: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Update_Quote', 1, 'Y');
538: END IF;
539:
540: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
541: RAISE FND_API.G_EXC_ERROR;

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

546: -- Commented for bug no 6731701 so that only the record for newly inserted line go into relationship table
547: /* x_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
548: x_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_sort(p_qte_header_rec.quote_header_id);
549: */
550: IF aso_debug_pub.g_debug_flag = 'Y' THEN
551: For l in x_qte_line_tbl.FIRST..x_qte_line_tbl.LAST LOOP
552: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:quote line id :'||x_qte_line_tbl(l).quote_line_id,1,'Y');
553: END LOOP;
554: end if;

Line 552: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:quote line id :'||x_qte_line_tbl(l).quote_line_id,1,'Y');

548: x_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_sort(p_qte_header_rec.quote_header_id);
549: */
550: IF aso_debug_pub.g_debug_flag = 'Y' THEN
551: For l in x_qte_line_tbl.FIRST..x_qte_line_tbl.LAST LOOP
552: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:quote line id :'||x_qte_line_tbl(l).quote_line_id,1,'Y');
553: END LOOP;
554: end if;
555:
556: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

552: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:quote line id :'||x_qte_line_tbl(l).quote_line_id,1,'Y');
553: END LOOP;
554: end if;
555:
556: IF aso_debug_pub.g_debug_flag = 'Y' THEN
557: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start line relationships loop', 1, 'Y');
558: END IF;
559:
560: FOR i in 1..x_qte_line_tbl.count LOOP

Line 557: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start line relationships loop', 1, 'Y');

553: END LOOP;
554: end if;
555:
556: IF aso_debug_pub.g_debug_flag = 'Y' THEN
557: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start line relationships loop', 1, 'Y');
558: END IF;
559:
560: FOR i in 1..x_qte_line_tbl.count LOOP
561: l_line_rltship_rec := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;

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

563: x_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(x_qte_line_tbl(i).quote_line_id);
564:
565: IF x_qte_line_dtl_tbl.count > 0 THEN
566:
567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
568: For k in x_qte_line_dtl_tbl.FIRST..x_qte_line_dtl_tbl.LAST LOOP
569: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:quote line detail id :'||x_qte_line_dtl_tbl(k).quote_line_detail_id,1,'Y');
570: END LOOP;
571: end if;

Line 569: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:quote line detail id :'||x_qte_line_dtl_tbl(k).quote_line_detail_id,1,'Y');

565: IF x_qte_line_dtl_tbl.count > 0 THEN
566:
567: IF aso_debug_pub.g_debug_flag = 'Y' THEN
568: For k in x_qte_line_dtl_tbl.FIRST..x_qte_line_dtl_tbl.LAST LOOP
569: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:quote line detail id :'||x_qte_line_dtl_tbl(k).quote_line_detail_id,1,'Y');
570: END LOOP;
571: end if;
572:
573:

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

577: l_line_rltship_rec.QUOTE_LINE_ID := x_qte_line_dtl_tbl(1).ref_line_id;
578: l_line_rltship_rec.RELATED_QUOTE_LINE_ID := x_qte_line_dtl_tbl(1).quote_line_id;
579: l_line_rltship_rec.RELATIONSHIP_TYPE_CODE := 'CONFIG';
580:
581: IF aso_debug_pub.g_debug_flag = 'Y' THEN
582: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Create_Line_Rltship', 1, 'Y');
583: END IF;
584:
585: ASO_LINE_RLTSHIP_PVT.Create_Line_Rltship(

Line 582: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Create_Line_Rltship', 1, 'Y');

578: l_line_rltship_rec.RELATED_QUOTE_LINE_ID := x_qte_line_dtl_tbl(1).quote_line_id;
579: l_line_rltship_rec.RELATIONSHIP_TYPE_CODE := 'CONFIG';
580:
581: IF aso_debug_pub.g_debug_flag = 'Y' THEN
582: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Create_Line_Rltship', 1, 'Y');
583: END IF;
584:
585: ASO_LINE_RLTSHIP_PVT.Create_Line_Rltship(
586: P_Api_Version_Number => 1.0,

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

593: X_Msg_Count => x_msg_count,
594: X_Msg_Data => x_msg_data
595: );
596:
597: IF aso_debug_pub.g_debug_flag = 'Y' THEN
598: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Create_Line_Rltship: lx_line_relationship_id: '||lx_line_relationship_id, 1, 'Y');
599: END IF;
600:
601: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 598: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Create_Line_Rltship: lx_line_relationship_id: '||lx_line_relationship_id, 1, 'Y');

594: X_Msg_Data => x_msg_data
595: );
596:
597: IF aso_debug_pub.g_debug_flag = 'Y' THEN
598: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Create_Line_Rltship: lx_line_relationship_id: '||lx_line_relationship_id, 1, 'Y');
599: END IF;
600:
601: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
602: RAISE FND_API.G_EXC_ERROR;

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

606: END IF;
607: END IF;
608: END LOOP;
609:
610: IF aso_debug_pub.g_debug_flag = 'Y' THEN
611: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end line relationships loop', 1, 'Y');
612:
613: END IF;
614: END IF;--Template manager

Line 611: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end line relationships loop', 1, 'Y');

607: END IF;
608: END LOOP;
609:
610: IF aso_debug_pub.g_debug_flag = 'Y' THEN
611: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end line relationships loop', 1, 'Y');
612:
613: END IF;
614: END IF;--Template manager
615:

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

614: END IF;--Template manager
615:
616:
617: -- End of API body
618: IF aso_debug_pub.g_debug_flag = 'Y' THEN
619: aso_debug_pub.add('****** End of Add_Template_To_Quote API ******', 1, 'Y');
620: END IF;
621:
622: -- Standard check of p_commit

Line 619: aso_debug_pub.add(' End of Add_Template_To_Quote API ', 1, 'Y');

615:
616:
617: -- End of API body
618: IF aso_debug_pub.g_debug_flag = 'Y' THEN
619: aso_debug_pub.add('****** End of Add_Template_To_Quote API ******', 1, 'Y');
620: END IF;
621:
622: -- Standard check of p_commit
623: IF FND_API.To_Boolean(p_commit) THEN

Line 749: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

745:
746: -- end service items
747:
748: begin
749: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
750:
751: IF aso_debug_pub.g_debug_flag = 'Y' THEN
752: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: *** Start of API body ***', 1, 'Y');
753: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');

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

747:
748: begin
749: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
750:
751: IF aso_debug_pub.g_debug_flag = 'Y' THEN
752: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: *** Start of API body ***', 1, 'Y');
753: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');
754: --aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_organization_id: '|| p_organization_id, 1, 'N');
755: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_quantity: '|| p_quantity, 1, 'N');

Line 752: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: * Start of API body *', 1, 'Y');

748: begin
749: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
750:
751: IF aso_debug_pub.g_debug_flag = 'Y' THEN
752: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: *** Start of API body ***', 1, 'Y');
753: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');
754: --aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_organization_id: '|| p_organization_id, 1, 'N');
755: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_quantity: '|| p_quantity, 1, 'N');
756: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_uom_code: '|| p_uom_code, 1, 'N');

Line 753: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');

749: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
750:
751: IF aso_debug_pub.g_debug_flag = 'Y' THEN
752: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: *** Start of API body ***', 1, 'Y');
753: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');
754: --aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_organization_id: '|| p_organization_id, 1, 'N');
755: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_quantity: '|| p_quantity, 1, 'N');
756: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_uom_code: '|| p_uom_code, 1, 'N');
757: END IF;

Line 754: --aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_organization_id: '|| p_organization_id, 1, 'N');

750:
751: IF aso_debug_pub.g_debug_flag = 'Y' THEN
752: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: *** Start of API body ***', 1, 'Y');
753: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');
754: --aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_organization_id: '|| p_organization_id, 1, 'N');
755: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_quantity: '|| p_quantity, 1, 'N');
756: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_uom_code: '|| p_uom_code, 1, 'N');
757: END IF;
758:

Line 755: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_quantity: '|| p_quantity, 1, 'N');

751: IF aso_debug_pub.g_debug_flag = 'Y' THEN
752: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: *** Start of API body ***', 1, 'Y');
753: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');
754: --aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_organization_id: '|| p_organization_id, 1, 'N');
755: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_quantity: '|| p_quantity, 1, 'N');
756: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_uom_code: '|| p_uom_code, 1, 'N');
757: END IF;
758:
759:

Line 756: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_uom_code: '|| p_uom_code, 1, 'N');

752: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: *** Start of API body ***', 1, 'Y');
753: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_inventory_item_id: '|| p_inventory_item_id, 1, 'N');
754: --aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_organization_id: '|| p_organization_id, 1, 'N');
755: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_quantity: '|| p_quantity, 1, 'N');
756: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: p_uom_code: '|| p_uom_code, 1, 'N');
757: END IF;
758:
759:
760: FOR conc_segments_rec IN c_conc_segments(p_inventory_item_id) LOOP

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

764:
765: l_master_organization_id := oe_sys_parameters.value(param_name => 'MASTER_ORGANIZATION_ID',
766: p_org_id => p_qte_header_rec.org_id);
767:
768: IF aso_debug_pub.g_debug_flag = 'Y' THEN
769: aso_debug_pub.add('l_master_organization_id: ' || l_master_organization_id);
770: aso_debug_pub.add(' p_qte_header_rec.org_id: ' || p_qte_header_rec.org_id);
771: END IF;
772:

Line 769: aso_debug_pub.add('l_master_organization_id: ' || l_master_organization_id);

765: l_master_organization_id := oe_sys_parameters.value(param_name => 'MASTER_ORGANIZATION_ID',
766: p_org_id => p_qte_header_rec.org_id);
767:
768: IF aso_debug_pub.g_debug_flag = 'Y' THEN
769: aso_debug_pub.add('l_master_organization_id: ' || l_master_organization_id);
770: aso_debug_pub.add(' p_qte_header_rec.org_id: ' || p_qte_header_rec.org_id);
771: END IF;
772:
773: open c_in_org_in_master_org(p_inventory_item_id,l_master_organization_id);

Line 770: aso_debug_pub.add(' p_qte_header_rec.org_id: ' || p_qte_header_rec.org_id);

766: p_org_id => p_qte_header_rec.org_id);
767:
768: IF aso_debug_pub.g_debug_flag = 'Y' THEN
769: aso_debug_pub.add('l_master_organization_id: ' || l_master_organization_id);
770: aso_debug_pub.add(' p_qte_header_rec.org_id: ' || p_qte_header_rec.org_id);
771: END IF;
772:
773: open c_in_org_in_master_org(p_inventory_item_id,l_master_organization_id);
774: fetch c_in_org_in_master_org into l_segment1;

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

772:
773: open c_in_org_in_master_org(p_inventory_item_id,l_master_organization_id);
774: fetch c_in_org_in_master_org into l_segment1;
775: if c_in_org_in_master_org%NOTFOUND THEN
776: IF aso_debug_pub.g_debug_flag = 'Y' THEN
777: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Item does not exist in the master org',1,'N');
778: END IF;
779:
780: RETURN FALSE;

Line 777: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Item does not exist in the master org',1,'N');

773: open c_in_org_in_master_org(p_inventory_item_id,l_master_organization_id);
774: fetch c_in_org_in_master_org into l_segment1;
775: if c_in_org_in_master_org%NOTFOUND THEN
776: IF aso_debug_pub.g_debug_flag = 'Y' THEN
777: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Item does not exist in the master org',1,'N');
778: END IF;
779:
780: RETURN FALSE;
781:

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

795:
796:
797: IF orderable_items_rec.service_item_flag = 'Y' THEN
798: IF (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') <> 'N') OR (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') is null) THEN
799: IF aso_debug_pub.g_debug_flag = 'Y' THEN
800: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: item is of type service:' || p_inventory_item_id, 1, 'N');
801: END IF;
802: open c_service_ref_quote(p_quote_line_id);
803: fetch c_service_ref_quote into l_service_ref_line_id;

Line 800: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: item is of type service:' || p_inventory_item_id, 1, 'N');

796:
797: IF orderable_items_rec.service_item_flag = 'Y' THEN
798: IF (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') <> 'N') OR (fnd_profile.value('ASO_REQUIRE_SERVICE_REFERENCE') is null) THEN
799: IF aso_debug_pub.g_debug_flag = 'Y' THEN
800: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: item is of type service:' || p_inventory_item_id, 1, 'N');
801: END IF;
802: open c_service_ref_quote(p_quote_line_id);
803: fetch c_service_ref_quote into l_service_ref_line_id;
804: close c_service_ref_quote;

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

830: p_check_service_rec => l_check_service_rec,
831: X_Available_YN => l_Available_YN
832: );
833: IF l_Available_YN = 'N' THEN
834: IF aso_debug_pub.g_debug_flag = 'Y' THEN
835: aso_debug_pub.add('UPDATE_QUOTE:SERVICE_not available');
836: END IF;
837: return false;
838: end if;

Line 835: aso_debug_pub.add('UPDATE_QUOTE:SERVICE_not available');

831: X_Available_YN => l_Available_YN
832: );
833: IF l_Available_YN = 'N' THEN
834: IF aso_debug_pub.g_debug_flag = 'Y' THEN
835: aso_debug_pub.add('UPDATE_QUOTE:SERVICE_not available');
836: END IF;
837: return false;
838: end if;
839:

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

855: FND_PROFILE.Value('RESP_APPL_ID')
856: );
857:
858: IF l_ui_def_id IS NULL THEN
859: IF aso_debug_pub.g_debug_flag = 'Y' THEN
860: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: item does not have a configurable ui:'
861: || p_inventory_item_id, 1, 'N');
862: END IF;
863:

Line 860: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: item does not have a configurable ui:'

856: );
857:
858: IF l_ui_def_id IS NULL THEN
859: IF aso_debug_pub.g_debug_flag = 'Y' THEN
860: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: item does not have a configurable ui:'
861: || p_inventory_item_id, 1, 'N');
862: END IF;
863:
864:

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

874: l_output_qty,
875: l_primary_qty,
876: l_return_status
877: );
878: IF aso_debug_pub.g_debug_flag = 'Y' THEN
879: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:p_quantity'|| p_quantity, 1, 'N');
880: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_return_status'|| l_return_status, 1, 'N');
881: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_uom_code'|| l_uom_code, 1, 'N');
882: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_output_qty'|| l_output_qty, 1, 'N');

Line 879: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:p_quantity'|| p_quantity, 1, 'N');

875: l_primary_qty,
876: l_return_status
877: );
878: IF aso_debug_pub.g_debug_flag = 'Y' THEN
879: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:p_quantity'|| p_quantity, 1, 'N');
880: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_return_status'|| l_return_status, 1, 'N');
881: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_uom_code'|| l_uom_code, 1, 'N');
882: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_output_qty'|| l_output_qty, 1, 'N');
883: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_primary_qty'|| l_primary_qty, 1, 'N');

Line 880: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_return_status'|| l_return_status, 1, 'N');

876: l_return_status
877: );
878: IF aso_debug_pub.g_debug_flag = 'Y' THEN
879: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:p_quantity'|| p_quantity, 1, 'N');
880: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_return_status'|| l_return_status, 1, 'N');
881: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_uom_code'|| l_uom_code, 1, 'N');
882: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_output_qty'|| l_output_qty, 1, 'N');
883: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_primary_qty'|| l_primary_qty, 1, 'N');
884: END IF;

Line 881: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_uom_code'|| l_uom_code, 1, 'N');

877: );
878: IF aso_debug_pub.g_debug_flag = 'Y' THEN
879: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:p_quantity'|| p_quantity, 1, 'N');
880: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_return_status'|| l_return_status, 1, 'N');
881: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_uom_code'|| l_uom_code, 1, 'N');
882: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_output_qty'|| l_output_qty, 1, 'N');
883: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_primary_qty'|| l_primary_qty, 1, 'N');
884: END IF;
885:

Line 882: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_output_qty'|| l_output_qty, 1, 'N');

878: IF aso_debug_pub.g_debug_flag = 'Y' THEN
879: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:p_quantity'|| p_quantity, 1, 'N');
880: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_return_status'|| l_return_status, 1, 'N');
881: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_uom_code'|| l_uom_code, 1, 'N');
882: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_output_qty'|| l_output_qty, 1, 'N');
883: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_primary_qty'|| l_primary_qty, 1, 'N');
884: END IF;
885:
886: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR p_quantity <= 0 THEN

Line 883: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_primary_qty'|| l_primary_qty, 1, 'N');

879: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:p_quantity'|| p_quantity, 1, 'N');
880: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_return_status'|| l_return_status, 1, 'N');
881: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_uom_code'|| l_uom_code, 1, 'N');
882: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_output_qty'|| l_output_qty, 1, 'N');
883: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_primary_qty'|| l_primary_qty, 1, 'N');
884: END IF;
885:
886: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR p_quantity <= 0 THEN
887: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

883: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item:l_primary_qty'|| l_primary_qty, 1, 'N');
884: END IF;
885:
886: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR p_quantity <= 0 THEN
887: IF aso_debug_pub.g_debug_flag = 'Y' THEN
888: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: item has invalid quantity:'
889: || p_inventory_item_id, 1, 'N');
890: END IF;
891:

Line 888: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: item has invalid quantity:'

884: END IF;
885:
886: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR p_quantity <= 0 THEN
887: IF aso_debug_pub.g_debug_flag = 'Y' THEN
888: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: item has invalid quantity:'
889: || p_inventory_item_id, 1, 'N');
890: END IF;
891:
892:

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

895:
896: END LOOP;
897:
898: /*IF l_orderable_flag = 'N' THEN
899: IF aso_debug_pub.g_debug_flag = 'Y' THEN
900: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: item not orderable:'|| p_inventory_item_id, 1, 'N');
901: END IF;
902: RETURN FALSE;
903: END IF;

Line 900: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: item not orderable:'|| p_inventory_item_id, 1, 'N');

896: END LOOP;
897:
898: /*IF l_orderable_flag = 'N' THEN
899: IF aso_debug_pub.g_debug_flag = 'Y' THEN
900: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: item not orderable:'|| p_inventory_item_id, 1, 'N');
901: END IF;
902: RETURN FALSE;
903: END IF;
904: */

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

902: RETURN FALSE;
903: END IF;
904: */
905:
906: IF aso_debug_pub.g_debug_flag = 'Y' THEN
907: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: *** End of API body ***', 1, 'Y');
908: END IF;
909:
910: return true;

Line 907: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: * End of API body *', 1, 'Y');

903: END IF;
904: */
905:
906: IF aso_debug_pub.g_debug_flag = 'Y' THEN
907: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Validate_Item: *** End of API body ***', 1, 'Y');
908: END IF;
909:
910: return true;
911: end Validate_Item;