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_QUOTE_TMPL_PVT

Line 1: PACKAGE BODY ASO_QUOTE_TMPL_PVT AS

1: PACKAGE BODY ASO_QUOTE_TMPL_PVT AS
2: /* $Header: asovqtmb.pls 120.3 2006/08/22 18:26:03 bmishra noship $ */
3:
4: -- Start of Comments
5: -- Package name : ASO_QUOTE_TMPL_PVT

Line 5: -- Package name : ASO_QUOTE_TMPL_PVT

1: PACKAGE BODY ASO_QUOTE_TMPL_PVT AS
2: /* $Header: asovqtmb.pls 120.3 2006/08/22 18:26:03 bmishra noship $ */
3:
4: -- Start of Comments
5: -- Package name : ASO_QUOTE_TMPL_PVT
6: -- Purpose :
7: -- End of Comments
8:
9:

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_QUOTE_TMPL_PVT';

7: -- End of Comments
8:
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_QUOTE_TMPL_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asovqtmb.pls';
13:
14:
15:

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 610: END ASO_QUOTE_TMPL_PVT;

606:
607: END Add_Template_To_Quote;
608:
609:
610: END ASO_QUOTE_TMPL_PVT;
611: