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 127: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

123:
124: -- Standard Start of API savepoint
125: SAVEPOINT Add_Template_To_Quote_PVT;
126:
127: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
128:
129: IF aso_debug_pub.g_debug_flag = 'Y' THEN
130: aso_debug_pub.add('****** Start of Add_Template_To_Quote API ******', 1, 'Y');
131: END IF;

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

125: SAVEPOINT Add_Template_To_Quote_PVT;
126:
127: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
128:
129: IF aso_debug_pub.g_debug_flag = 'Y' THEN
130: aso_debug_pub.add('****** Start of Add_Template_To_Quote API ******', 1, 'Y');
131: END IF;
132:
133: -- Standard call to check for call compatibility.

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

126:
127: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
128:
129: IF aso_debug_pub.g_debug_flag = 'Y' THEN
130: aso_debug_pub.add('****** Start of Add_Template_To_Quote API ******', 1, 'Y');
131: END IF;
132:
133: -- Standard call to check for call compatibility.
134: IF NOT FND_API.Compatible_API_Call(

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

151: -- API body
152: l_qte_header_rec := p_qte_header_rec;
153:
154: IF (p_qte_header_rec.org_id is null or p_qte_header_rec.org_id = fnd_api.g_miss_num ) then
155: IF aso_debug_pub.g_debug_flag = 'Y' THEN
156: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Input ogr_id is null or g_miss', 1, 'Y');
157: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: p_qte_header_rec.quote_header_id: ' || p_qte_header_rec.quote_header_id, 1, 'Y');
158: END IF;
159:

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

152: l_qte_header_rec := p_qte_header_rec;
153:
154: IF (p_qte_header_rec.org_id is null or p_qte_header_rec.org_id = fnd_api.g_miss_num ) then
155: IF aso_debug_pub.g_debug_flag = 'Y' THEN
156: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Input ogr_id is null or g_miss', 1, 'Y');
157: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: p_qte_header_rec.quote_header_id: ' || p_qte_header_rec.quote_header_id, 1, 'Y');
158: END IF;
159:
160: open c_get_org_id(p_qte_header_rec.quote_header_id);

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

153:
154: IF (p_qte_header_rec.org_id is null or p_qte_header_rec.org_id = fnd_api.g_miss_num ) then
155: IF aso_debug_pub.g_debug_flag = 'Y' THEN
156: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: Input ogr_id is null or g_miss', 1, 'Y');
157: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: p_qte_header_rec.quote_header_id: ' || p_qte_header_rec.quote_header_id, 1, 'Y');
158: END IF;
159:
160: open c_get_org_id(p_qte_header_rec.quote_header_id);
161: fetch c_get_org_id into l_qte_header_rec.org_id;

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

160: open c_get_org_id(p_qte_header_rec.quote_header_id);
161: fetch c_get_org_id into l_qte_header_rec.org_id;
162: close c_get_org_id;
163:
164: IF aso_debug_pub.g_debug_flag = 'Y' THEN
165: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: l_qte_header_rec.org_id: '|| l_qte_header_rec.org_id, 1, 'Y');
166: END IF;
167:
168: END IF;

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

161: fetch c_get_org_id into l_qte_header_rec.org_id;
162: close c_get_org_id;
163:
164: IF aso_debug_pub.g_debug_flag = 'Y' THEN
165: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: l_qte_header_rec.org_id: '|| l_qte_header_rec.org_id, 1, 'Y');
166: END IF;
167:
168: END IF;
169:

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

180:
181: l_pricing_control_rec.request_type := 'ASO';
182: l_pricing_control_rec.pricing_event := 'BATCH';
183:
184: IF aso_debug_pub.g_debug_flag = 'Y' THEN
185: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Validate_Pricing_Order', 1, 'Y');
186: END IF;
187:
188: ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order(

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

181: l_pricing_control_rec.request_type := 'ASO';
182: l_pricing_control_rec.pricing_event := 'BATCH';
183:
184: IF aso_debug_pub.g_debug_flag = 'Y' THEN
185: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Validate_Pricing_Order', 1, 'Y');
186: END IF;
187:
188: ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order(
189: p_api_version_number => 1.0,

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

202: x_msg_count => x_msg_count,
203: x_msg_data => x_msg_data
204: );
205:
206: IF aso_debug_pub.g_debug_flag = 'Y' THEN
207: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Validate_Pricing_Order', 1, 'Y');
208: END IF;
209:
210: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

203: x_msg_data => x_msg_data
204: );
205:
206: IF aso_debug_pub.g_debug_flag = 'Y' THEN
207: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Validate_Pricing_Order', 1, 'Y');
208: END IF;
209:
210: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
211: RAISE FND_API.G_EXC_ERROR;

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

212: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:
216: IF aso_debug_pub.g_debug_flag = 'Y' THEN
217: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start validated lines loop', 1, 'Y');
218: END IF;
219:
220: FOR i IN 1..lpx_qte_line_tbl.count LOOP

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

213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:
216: IF aso_debug_pub.g_debug_flag = 'Y' THEN
217: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start validated lines loop', 1, 'Y');
218: END IF;
219:
220: FOR i IN 1..lpx_qte_line_tbl.count LOOP
221: IF lpx_qte_line_tbl(i).pricing_status_code <> FND_API.G_RET_STS_SUCCESS THEN

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

224: FOR conc_segments_rec IN c_conc_segments(lpx_qte_line_tbl(i).inventory_item_id) LOOP
225: l_conc_segments := conc_segments_rec.concatenated_segments;
226: END LOOP;
227:
228: IF aso_debug_pub.g_debug_flag = 'Y' THEN
229: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: item has pricing error: ' || lpx_qte_line_tbl(i).pricing_status_text, 1, 'N');
230: END IF;
231: FND_MESSAGE.Set_Name('ASO', 'ASO_QTM_INVALID_PRICELIST');
232: FND_MESSAGE.Set_Token('INVITEM', l_conc_segments, FALSE);

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

225: l_conc_segments := conc_segments_rec.concatenated_segments;
226: END LOOP;
227:
228: IF aso_debug_pub.g_debug_flag = 'Y' THEN
229: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: item has pricing error: ' || lpx_qte_line_tbl(i).pricing_status_text, 1, 'N');
230: END IF;
231: FND_MESSAGE.Set_Name('ASO', 'ASO_QTM_INVALID_PRICELIST');
232: FND_MESSAGE.Set_Token('INVITEM', l_conc_segments, FALSE);
233: FND_MSG_PUB.ADD;

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

245: END LOOP;
246: END IF;
247: END LOOP;
248:
249: IF aso_debug_pub.g_debug_flag = 'Y' THEN
250: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end validated lines loop', 1, 'Y');
251: END IF;
252:
253: l_template_line_count := 0;

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

246: END IF;
247: END LOOP;
248:
249: IF aso_debug_pub.g_debug_flag = 'Y' THEN
250: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end validated lines loop', 1, 'Y');
251: END IF;
252:
253: l_template_line_count := 0;
254:

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

251: END IF;
252:
253: l_template_line_count := 0;
254:
255: IF aso_debug_pub.g_debug_flag = 'Y' THEN
256: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start drop items loop', 1, 'Y');
257: END IF;
258:
259: FOR i IN 1..lpx_qte_line_tbl.count LOOP

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

252:
253: l_template_line_count := 0;
254:
255: IF aso_debug_pub.g_debug_flag = 'Y' THEN
256: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start drop items loop', 1, 'Y');
257: END IF;
258:
259: FOR i IN 1..lpx_qte_line_tbl.count LOOP
260: l_dropped_flag := 'N';

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

269: l_search_line_id_tbl(lpx_qte_line_tbl(i).quote_line_id) := l_template_line_count;
270: END IF;
271: END LOOP;
272:
273: IF aso_debug_pub.g_debug_flag = 'Y' THEN
274: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end drop items loop', 1, 'Y');
275: END IF;
276:
277: l_template_line_count := 0;

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

270: END IF;
271: END LOOP;
272:
273: IF aso_debug_pub.g_debug_flag = 'Y' THEN
274: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end drop items loop', 1, 'Y');
275: END IF;
276:
277: l_template_line_count := 0;
278:

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

275: END IF;
276:
277: l_template_line_count := 0;
278:
279: IF aso_debug_pub.g_debug_flag = 'Y' THEN
280: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start line details loop', 1, 'Y');
281: END IF;
282:
283: FOR i IN 1..l_qte_line_tbl.count LOOP

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

276:
277: l_template_line_count := 0;
278:
279: IF aso_debug_pub.g_debug_flag = 'Y' THEN
280: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start line details loop', 1, 'Y');
281: END IF;
282:
283: FOR i IN 1..l_qte_line_tbl.count LOOP
284: IF l_qte_line_tbl(i).item_type_code IN ('MDL','CFG') THEN

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

329: END IF;
330:
331: END LOOP;
332:
333: IF aso_debug_pub.g_debug_flag = 'Y' THEN
334: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end line details loop', 1, 'Y');
335: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start copy configuration loop', 1, 'Y');
336: END IF;
337:

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

330:
331: END LOOP;
332:
333: IF aso_debug_pub.g_debug_flag = 'Y' THEN
334: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end line details loop', 1, 'Y');
335: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start copy configuration loop', 1, 'Y');
336: END IF;
337:
338: FOR i IN 1..l_qte_line_tbl.count LOOP

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

331: END LOOP;
332:
333: IF aso_debug_pub.g_debug_flag = 'Y' THEN
334: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end line details loop', 1, 'Y');
335: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start copy configuration loop', 1, 'Y');
336: END IF;
337:
338: FOR i IN 1..l_qte_line_tbl.count LOOP
339: IF l_qte_line_tbl(i).item_type_code = 'MDL' THEN

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

345: l_config_header_id := l_qte_line_dtl_tbl(j).config_header_id;
346: l_config_rev_number := l_qte_line_dtl_tbl(j).config_revision_num;
347:
348:
349: IF aso_debug_pub.g_debug_flag = 'Y' THEN
350: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Copy_Configuration', 1, 'Y');
351: END IF;
352:
353:

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

346: l_config_rev_number := l_qte_line_dtl_tbl(j).config_revision_num;
347:
348:
349: IF aso_debug_pub.g_debug_flag = 'Y' THEN
350: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Copy_Configuration', 1, 'Y');
351: END IF;
352:
353:
354: /*ASO_CFG_INT.Copy_Configuration(

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

380: x_msg_count => x_msg_count,
381: x_msg_data => x_msg_data
382: );
383:
384: IF aso_debug_pub.g_debug_flag = 'Y' THEN
385: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Copy_Configuration', 1, 'Y');
386: END IF;
387:
388: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

381: x_msg_data => x_msg_data
382: );
383:
384: IF aso_debug_pub.g_debug_flag = 'Y' THEN
385: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Copy_Configuration', 1, 'Y');
386: END IF;
387:
388: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
389: RAISE FND_API.G_EXC_ERROR;

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

429: x_qte_line_tbl := l_qte_line_tbl;
430: x_qte_line_dtl_tbl := l_qte_line_dtl_tbl;
431: ELSE
432:
433: IF aso_debug_pub.g_debug_flag = 'Y' THEN
434: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end copy configuration loop', 1, 'Y');
435: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Update_Quote', 1, 'Y');
436:
437: END IF;

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

430: x_qte_line_dtl_tbl := l_qte_line_dtl_tbl;
431: ELSE
432:
433: IF aso_debug_pub.g_debug_flag = 'Y' THEN
434: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end copy configuration loop', 1, 'Y');
435: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Update_Quote', 1, 'Y');
436:
437: END IF;
438:

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

431: ELSE
432:
433: IF aso_debug_pub.g_debug_flag = 'Y' THEN
434: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end copy configuration loop', 1, 'Y');
435: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Update_Quote', 1, 'Y');
436:
437: END IF;
438:
439: ASO_QUOTE_PUB.Update_Quote(

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

466: X_Msg_Count => x_msg_count,
467: X_Msg_Data => x_msg_data
468: );
469:
470: IF aso_debug_pub.g_debug_flag = 'Y' THEN
471: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Update_Quote', 1, 'Y');
472: END IF;
473:
474: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

467: X_Msg_Data => x_msg_data
468: );
469:
470: IF aso_debug_pub.g_debug_flag = 'Y' THEN
471: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Update_Quote', 1, 'Y');
472: END IF;
473:
474: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
475: RAISE FND_API.G_EXC_ERROR;

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

479:
480: x_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
481: x_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_sort(p_qte_header_rec.quote_header_id);
482:
483: IF aso_debug_pub.g_debug_flag = 'Y' THEN
484: For l in x_qte_line_tbl.FIRST..x_qte_line_tbl.LAST LOOP
485: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:quote line id :'||x_qte_line_tbl(l).quote_line_id,1,'Y');
486: END LOOP;
487: end if;

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

481: x_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_sort(p_qte_header_rec.quote_header_id);
482:
483: IF aso_debug_pub.g_debug_flag = 'Y' THEN
484: For l in x_qte_line_tbl.FIRST..x_qte_line_tbl.LAST LOOP
485: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:quote line id :'||x_qte_line_tbl(l).quote_line_id,1,'Y');
486: END LOOP;
487: end if;
488:
489: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

485: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:quote line id :'||x_qte_line_tbl(l).quote_line_id,1,'Y');
486: END LOOP;
487: end if;
488:
489: IF aso_debug_pub.g_debug_flag = 'Y' THEN
490: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start line relationships loop', 1, 'Y');
491: END IF;
492:
493: FOR i in 1..x_qte_line_tbl.count LOOP

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

486: END LOOP;
487: end if;
488:
489: IF aso_debug_pub.g_debug_flag = 'Y' THEN
490: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start line relationships loop', 1, 'Y');
491: END IF;
492:
493: FOR i in 1..x_qte_line_tbl.count LOOP
494: l_line_rltship_rec := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;

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

496: x_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(x_qte_line_tbl(i).quote_line_id);
497:
498: IF x_qte_line_dtl_tbl.count > 0 THEN
499:
500: IF aso_debug_pub.g_debug_flag = 'Y' THEN
501: For k in x_qte_line_dtl_tbl.FIRST..x_qte_line_dtl_tbl.LAST LOOP
502: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:quote line detail id :'||x_qte_line_dtl_tbl(k).quote_line_detail_id,1,'Y');
503: END LOOP;
504: end if;

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

498: IF x_qte_line_dtl_tbl.count > 0 THEN
499:
500: IF aso_debug_pub.g_debug_flag = 'Y' THEN
501: For k in x_qte_line_dtl_tbl.FIRST..x_qte_line_dtl_tbl.LAST LOOP
502: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT:quote line detail id :'||x_qte_line_dtl_tbl(k).quote_line_detail_id,1,'Y');
503: END LOOP;
504: end if;
505:
506:

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

510: l_line_rltship_rec.QUOTE_LINE_ID := x_qte_line_dtl_tbl(1).ref_line_id;
511: l_line_rltship_rec.RELATED_QUOTE_LINE_ID := x_qte_line_dtl_tbl(1).quote_line_id;
512: l_line_rltship_rec.RELATIONSHIP_TYPE_CODE := 'CONFIG';
513:
514: IF aso_debug_pub.g_debug_flag = 'Y' THEN
515: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Create_Line_Rltship', 1, 'Y');
516: END IF;
517:
518: ASO_LINE_RLTSHIP_PVT.Create_Line_Rltship(

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

511: l_line_rltship_rec.RELATED_QUOTE_LINE_ID := x_qte_line_dtl_tbl(1).quote_line_id;
512: l_line_rltship_rec.RELATIONSHIP_TYPE_CODE := 'CONFIG';
513:
514: IF aso_debug_pub.g_debug_flag = 'Y' THEN
515: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Create_Line_Rltship', 1, 'Y');
516: END IF;
517:
518: ASO_LINE_RLTSHIP_PVT.Create_Line_Rltship(
519: P_Api_Version_Number => 1.0,

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

526: X_Msg_Count => x_msg_count,
527: X_Msg_Data => x_msg_data
528: );
529:
530: IF aso_debug_pub.g_debug_flag = 'Y' THEN
531: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Create_Line_Rltship: lx_line_relationship_id: '||lx_line_relationship_id, 1, 'Y');
532: END IF;
533:
534: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

527: X_Msg_Data => x_msg_data
528: );
529:
530: IF aso_debug_pub.g_debug_flag = 'Y' THEN
531: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Create_Line_Rltship: lx_line_relationship_id: '||lx_line_relationship_id, 1, 'Y');
532: END IF;
533:
534: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
535: RAISE FND_API.G_EXC_ERROR;

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

539: END IF;
540: END IF;
541: END LOOP;
542:
543: IF aso_debug_pub.g_debug_flag = 'Y' THEN
544: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end line relationships loop', 1, 'Y');
545:
546: END IF;
547: END IF;--Template manager

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

540: END IF;
541: END LOOP;
542:
543: IF aso_debug_pub.g_debug_flag = 'Y' THEN
544: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: end line relationships loop', 1, 'Y');
545:
546: END IF;
547: END IF;--Template manager
548:

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

547: END IF;--Template manager
548:
549:
550: -- End of API body
551: IF aso_debug_pub.g_debug_flag = 'Y' THEN
552: aso_debug_pub.add('****** End of Add_Template_To_Quote API ******', 1, 'Y');
553: END IF;
554:
555: -- Standard check of p_commit

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

548:
549:
550: -- End of API body
551: IF aso_debug_pub.g_debug_flag = 'Y' THEN
552: aso_debug_pub.add('****** End of Add_Template_To_Quote API ******', 1, 'Y');
553: END IF;
554:
555: -- Standard check of p_commit
556: IF FND_API.To_Boolean(p_commit) THEN