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.13 2012/01/31 06:40:04 vidsrini ship $ */
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.13 2012/01/31 06:40:04 vidsrini ship $ */
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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;

Line 913: END ASO_QUOTE_TMPL_PVT;

909:
910: return true;
911: end Validate_Item;
912:
913: END ASO_QUOTE_TMPL_PVT;
914: