98: **************************************************************/
99: For i IN 1.. P_Instance_tbl.count Loop
100: For c_item_rec IN c_item_csr(P_Instance_tbl(i).instance_id) LOOP
101:
102: IF aso_debug_pub.g_debug_flag = 'Y' THEN
103: aso_debug_pub.add('Add_to_Container_from_IB:Config Header Id:'||c_item_rec.config_inst_hdr_id,1,'N');
104: aso_debug_pub.add('Add_to_Container_from_IB:Config Rev Num:'||c_item_rec.config_inst_rev_num,1,'N');
105: END IF;
106:
99: For i IN 1.. P_Instance_tbl.count Loop
100: For c_item_rec IN c_item_csr(P_Instance_tbl(i).instance_id) LOOP
101:
102: IF aso_debug_pub.g_debug_flag = 'Y' THEN
103: aso_debug_pub.add('Add_to_Container_from_IB:Config Header Id:'||c_item_rec.config_inst_hdr_id,1,'N');
104: aso_debug_pub.add('Add_to_Container_from_IB:Config Rev Num:'||c_item_rec.config_inst_rev_num,1,'N');
105: END IF;
106:
107: l_ins_config_hdr_tbl(i).config_hdr_id := c_item_rec.config_inst_hdr_id;
100: For c_item_rec IN c_item_csr(P_Instance_tbl(i).instance_id) LOOP
101:
102: IF aso_debug_pub.g_debug_flag = 'Y' THEN
103: aso_debug_pub.add('Add_to_Container_from_IB:Config Header Id:'||c_item_rec.config_inst_hdr_id,1,'N');
104: aso_debug_pub.add('Add_to_Container_from_IB:Config Rev Num:'||c_item_rec.config_inst_rev_num,1,'N');
105: END IF;
106:
107: l_ins_config_hdr_tbl(i).config_hdr_id := c_item_rec.config_inst_hdr_id;
108: l_ins_config_hdr_tbl(i).config_rev_nbr:= c_item_rec.config_inst_rev_num;
124: l_hdr_id := null;
125: l_rev_nbr:= null;
126: end;
127:
128: IF aso_debug_pub.g_debug_flag = 'Y' THEN
129: aso_debug_pub.add('Add_to_Container_from_IB: Config Header Id:'||l_hdr_id,1,'N');
130: aso_debug_pub.add('Add_to_Container_from_IB: Config Rev Number:'||l_rev_nbr,1,'N');
131: END IF;
132:
125: l_rev_nbr:= null;
126: end;
127:
128: IF aso_debug_pub.g_debug_flag = 'Y' THEN
129: aso_debug_pub.add('Add_to_Container_from_IB: Config Header Id:'||l_hdr_id,1,'N');
130: aso_debug_pub.add('Add_to_Container_from_IB: Config Rev Number:'||l_rev_nbr,1,'N');
131: END IF;
132:
133: /**************************************************************
126: end;
127:
128: IF aso_debug_pub.g_debug_flag = 'Y' THEN
129: aso_debug_pub.add('Add_to_Container_from_IB: Config Header Id:'||l_hdr_id,1,'N');
130: aso_debug_pub.add('Add_to_Container_from_IB: Config Rev Number:'||l_rev_nbr,1,'N');
131: END IF;
132:
133: /**************************************************************
134: Find item details from Quote line containing Model Item
135: ***************************************************************/
136:
137: For c_mdl_item_details_rec IN c_mdl_item_details_csr(p_quote_line_id) LOOP
138:
139: IF aso_debug_pub.g_debug_flag = 'Y' THEN
140: aso_debug_pub.add('Add_to_Container_from_IB:Inventory Item Id:'||c_mdl_item_details_rec.inventory_item_id,1,'N');
141: aso_debug_pub.add('Add_to_Container_from_IB:Organization Id'||c_mdl_item_details_rec.organization_id,1,'N');
142: aso_debug_pub.add('Add_to_Container_from_IB:Quantity:'||c_mdl_item_details_rec.quantity,1,'N');
143: aso_debug_pub.add('Add_to_Container_from_IB:UOM Code:'||c_mdl_item_details_rec.uom_code,1,'N');
136:
137: For c_mdl_item_details_rec IN c_mdl_item_details_csr(p_quote_line_id) LOOP
138:
139: IF aso_debug_pub.g_debug_flag = 'Y' THEN
140: aso_debug_pub.add('Add_to_Container_from_IB:Inventory Item Id:'||c_mdl_item_details_rec.inventory_item_id,1,'N');
141: aso_debug_pub.add('Add_to_Container_from_IB:Organization Id'||c_mdl_item_details_rec.organization_id,1,'N');
142: aso_debug_pub.add('Add_to_Container_from_IB:Quantity:'||c_mdl_item_details_rec.quantity,1,'N');
143: aso_debug_pub.add('Add_to_Container_from_IB:UOM Code:'||c_mdl_item_details_rec.uom_code,1,'N');
144: END IF;
137: For c_mdl_item_details_rec IN c_mdl_item_details_csr(p_quote_line_id) LOOP
138:
139: IF aso_debug_pub.g_debug_flag = 'Y' THEN
140: aso_debug_pub.add('Add_to_Container_from_IB:Inventory Item Id:'||c_mdl_item_details_rec.inventory_item_id,1,'N');
141: aso_debug_pub.add('Add_to_Container_from_IB:Organization Id'||c_mdl_item_details_rec.organization_id,1,'N');
142: aso_debug_pub.add('Add_to_Container_from_IB:Quantity:'||c_mdl_item_details_rec.quantity,1,'N');
143: aso_debug_pub.add('Add_to_Container_from_IB:UOM Code:'||c_mdl_item_details_rec.uom_code,1,'N');
144: END IF;
145:
138:
139: IF aso_debug_pub.g_debug_flag = 'Y' THEN
140: aso_debug_pub.add('Add_to_Container_from_IB:Inventory Item Id:'||c_mdl_item_details_rec.inventory_item_id,1,'N');
141: aso_debug_pub.add('Add_to_Container_from_IB:Organization Id'||c_mdl_item_details_rec.organization_id,1,'N');
142: aso_debug_pub.add('Add_to_Container_from_IB:Quantity:'||c_mdl_item_details_rec.quantity,1,'N');
143: aso_debug_pub.add('Add_to_Container_from_IB:UOM Code:'||c_mdl_item_details_rec.uom_code,1,'N');
144: END IF;
145:
146: /**************************************************************
139: IF aso_debug_pub.g_debug_flag = 'Y' THEN
140: aso_debug_pub.add('Add_to_Container_from_IB:Inventory Item Id:'||c_mdl_item_details_rec.inventory_item_id,1,'N');
141: aso_debug_pub.add('Add_to_Container_from_IB:Organization Id'||c_mdl_item_details_rec.organization_id,1,'N');
142: aso_debug_pub.add('Add_to_Container_from_IB:Quantity:'||c_mdl_item_details_rec.quantity,1,'N');
143: aso_debug_pub.add('Add_to_Container_from_IB:UOM Code:'||c_mdl_item_details_rec.uom_code,1,'N');
144: END IF;
145:
146: /**************************************************************
147: Create Applicability parameter record
192: x_msg_data => x_msg_data);
193:
194: end if;
195:
196: IF aso_debug_pub.g_debug_flag = 'Y' THEN
197:
198: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Return status:'||x_return_status,1,'N');
199: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Msg count:'||x_msg_count,1,'N');
200: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Config Header Id:'||lx_config_tree_rec.config_hdr_id,1,'N');
194: end if;
195:
196: IF aso_debug_pub.g_debug_flag = 'Y' THEN
197:
198: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Return status:'||x_return_status,1,'N');
199: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Msg count:'||x_msg_count,1,'N');
200: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Config Header Id:'||lx_config_tree_rec.config_hdr_id,1,'N');
201: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Config Rev Number:'||lx_config_tree_rec.config_rev_nbr,1,'N');
202:
195:
196: IF aso_debug_pub.g_debug_flag = 'Y' THEN
197:
198: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Return status:'||x_return_status,1,'N');
199: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Msg count:'||x_msg_count,1,'N');
200: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Config Header Id:'||lx_config_tree_rec.config_hdr_id,1,'N');
201: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Config Rev Number:'||lx_config_tree_rec.config_rev_nbr,1,'N');
202:
203: END IF;
196: IF aso_debug_pub.g_debug_flag = 'Y' THEN
197:
198: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Return status:'||x_return_status,1,'N');
199: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Msg count:'||x_msg_count,1,'N');
200: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Config Header Id:'||lx_config_tree_rec.config_hdr_id,1,'N');
201: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Config Rev Number:'||lx_config_tree_rec.config_rev_nbr,1,'N');
202:
203: END IF;
204:
197:
198: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Return status:'||x_return_status,1,'N');
199: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Msg count:'||x_msg_count,1,'N');
200: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Config Header Id:'||lx_config_tree_rec.config_hdr_id,1,'N');
201: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Config Rev Number:'||lx_config_tree_rec.config_rev_nbr,1,'N');
202:
203: END IF;
204:
205: IF x_return_status = FND_API.G_RET_STS_ERROR then
214: Open c_configuration_details_csr(lx_config_tree_rec.config_hdr_id,lx_config_tree_rec.config_rev_nbr);
215:
216: fetch c_configuration_details_csr into l_valid_configuration_flag,l_complete_configuration_flag;
217:
218: IF aso_debug_pub.g_debug_flag = 'Y' THEN
219: aso_debug_pub.add('Add_to_Container_from_IB:Config Valid Info:'||l_complete_configuration_flag,1,'N');
220: aso_debug_pub.add('Add_to_Container_from_IB:Config Complete Info:'||l_valid_configuration_flag,1,'N');
221: END IF;
222:
215:
216: fetch c_configuration_details_csr into l_valid_configuration_flag,l_complete_configuration_flag;
217:
218: IF aso_debug_pub.g_debug_flag = 'Y' THEN
219: aso_debug_pub.add('Add_to_Container_from_IB:Config Valid Info:'||l_complete_configuration_flag,1,'N');
220: aso_debug_pub.add('Add_to_Container_from_IB:Config Complete Info:'||l_valid_configuration_flag,1,'N');
221: END IF;
222:
223: IF c_configuration_details_csr%NOTFOUND THEN
216: fetch c_configuration_details_csr into l_valid_configuration_flag,l_complete_configuration_flag;
217:
218: IF aso_debug_pub.g_debug_flag = 'Y' THEN
219: aso_debug_pub.add('Add_to_Container_from_IB:Config Valid Info:'||l_complete_configuration_flag,1,'N');
220: aso_debug_pub.add('Add_to_Container_from_IB:Config Complete Info:'||l_valid_configuration_flag,1,'N');
221: END IF;
222:
223: IF c_configuration_details_csr%NOTFOUND THEN
224: CLOSE c_configuration_details_csr;
254: Open c_last_update_date_csr(P_QTE_HEADER_REC.quote_header_id);
255:
256: fetch c_last_update_date_csr into l_last_update_date;
257:
258: IF aso_debug_pub.g_debug_flag = 'Y' THEN
259: aso_debug_pub.add('Add_to_Container_from_IB:Last Update date:'||l_last_update_date,1,'N');
260: END IF;
261:
262: IF c_last_update_date_csr%NOTFOUND THEN
255:
256: fetch c_last_update_date_csr into l_last_update_date;
257:
258: IF aso_debug_pub.g_debug_flag = 'Y' THEN
259: aso_debug_pub.add('Add_to_Container_from_IB:Last Update date:'||l_last_update_date,1,'N');
260: END IF;
261:
262: IF c_last_update_date_csr%NOTFOUND THEN
263: CLOSE c_last_update_date_csr;
292: x_msg_data => x_msg_data
293: );
294:
295:
296: IF aso_debug_pub.g_debug_flag = 'Y' THEN
297: aso_debug_pub.add('Add_to_Container_from_IB:Get_config_details:Return status:'||x_return_status,1,'N');
298: aso_debug_pub.add('Add_to_Container_from_IB:Get_config_details:Msg count:'||x_msg_count,1,'N');
299: END IF;
300:
293: );
294:
295:
296: IF aso_debug_pub.g_debug_flag = 'Y' THEN
297: aso_debug_pub.add('Add_to_Container_from_IB:Get_config_details:Return status:'||x_return_status,1,'N');
298: aso_debug_pub.add('Add_to_Container_from_IB:Get_config_details:Msg count:'||x_msg_count,1,'N');
299: END IF;
300:
301: IF x_return_status = FND_API.G_RET_STS_ERROR then
294:
295:
296: IF aso_debug_pub.g_debug_flag = 'Y' THEN
297: aso_debug_pub.add('Add_to_Container_from_IB:Get_config_details:Return status:'||x_return_status,1,'N');
298: aso_debug_pub.add('Add_to_Container_from_IB:Get_config_details:Msg count:'||x_msg_count,1,'N');
299: END IF;
300:
301: IF x_return_status = FND_API.G_RET_STS_ERROR then
302: raise FND_API.G_EXC_ERROR;
306:
307: x_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_quote_header_id);
308:
309: -- End of API body
310: IF aso_debug_pub.g_debug_flag = 'Y' THEN
311: aso_debug_pub.add('****** End of add to container API ******', 1, 'Y');
312: END IF;
313:
314: -- Standard check of p_commit
307: x_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_quote_header_id);
308:
309: -- End of API body
310: IF aso_debug_pub.g_debug_flag = 'Y' THEN
311: aso_debug_pub.add('****** End of add to container API ******', 1, 'Y');
312: END IF;
313:
314: -- Standard check of p_commit
315: IF FND_API.To_Boolean(p_commit) THEN
500: For c_item_rec IN c_item_csr(P_Instance_tbl(i).instance_id) LOOP
501: l_ins_config_hdr_tbl(i).config_hdr_id := c_item_rec.config_inst_hdr_id;
502: l_ins_config_hdr_tbl(i).config_rev_nbr := c_item_rec.config_inst_rev_num;
503:
504: IF aso_debug_pub.g_debug_flag = 'Y' THEN
505: aso_debug_pub.add('Reconfigure_from_IB:Config Header Id:'||c_item_rec.config_inst_hdr_id,1,'N');
506: aso_debug_pub.add('Reconfigure_from_IB:Config Rev Num:'||c_item_rec.config_inst_rev_num,1,'N');
507: END IF;
508:
501: l_ins_config_hdr_tbl(i).config_hdr_id := c_item_rec.config_inst_hdr_id;
502: l_ins_config_hdr_tbl(i).config_rev_nbr := c_item_rec.config_inst_rev_num;
503:
504: IF aso_debug_pub.g_debug_flag = 'Y' THEN
505: aso_debug_pub.add('Reconfigure_from_IB:Config Header Id:'||c_item_rec.config_inst_hdr_id,1,'N');
506: aso_debug_pub.add('Reconfigure_from_IB:Config Rev Num:'||c_item_rec.config_inst_rev_num,1,'N');
507: END IF;
508:
509: END LOOP;
502: l_ins_config_hdr_tbl(i).config_rev_nbr := c_item_rec.config_inst_rev_num;
503:
504: IF aso_debug_pub.g_debug_flag = 'Y' THEN
505: aso_debug_pub.add('Reconfigure_from_IB:Config Header Id:'||c_item_rec.config_inst_hdr_id,1,'N');
506: aso_debug_pub.add('Reconfigure_from_IB:Config Rev Num:'||c_item_rec.config_inst_rev_num,1,'N');
507: END IF;
508:
509: END LOOP;
510: END LOOP;
530: x_msg_count => x_msg_count,
531: x_msg_data => x_msg_data);
532:
533:
534: IF aso_debug_pub.g_debug_flag = 'Y' THEN
535: aso_debug_pub.add('Reconfigure_from_IB:Generate_config_trees:Return status:'||x_return_status,1,'N');
536: aso_debug_pub.add('Reconfigure_from_IB:Generate_config_trees:Msg count:'||x_msg_count,1,'N');
537: END IF;
538:
531: x_msg_data => x_msg_data);
532:
533:
534: IF aso_debug_pub.g_debug_flag = 'Y' THEN
535: aso_debug_pub.add('Reconfigure_from_IB:Generate_config_trees:Return status:'||x_return_status,1,'N');
536: aso_debug_pub.add('Reconfigure_from_IB:Generate_config_trees:Msg count:'||x_msg_count,1,'N');
537: END IF;
538:
539: IF x_return_status = FND_API.G_RET_STS_ERROR then
532:
533:
534: IF aso_debug_pub.g_debug_flag = 'Y' THEN
535: aso_debug_pub.add('Reconfigure_from_IB:Generate_config_trees:Return status:'||x_return_status,1,'N');
536: aso_debug_pub.add('Reconfigure_from_IB:Generate_config_trees:Msg count:'||x_msg_count,1,'N');
537: END IF;
538:
539: IF x_return_status = FND_API.G_RET_STS_ERROR then
540: raise FND_API.G_EXC_ERROR;
551: Open c_uom_qty_csr(lx_out_config_tree_tbl(j).config_hdr_id,lx_out_config_tree_tbl(j).config_rev_nbr,lx_out_config_tree_tbl(j).config_item_id);
552:
553: fetch c_uom_qty_csr into l_uom, l_quantity;
554:
555: IF aso_debug_pub.g_debug_flag = 'Y' THEN
556: aso_debug_pub.add('Reconfigure_from_IB:UOM:'||l_uom,1,'N');
557: aso_debug_pub.add('Reconfigure_from_IB:Quantity:'||l_quantity,1,'N');
558: END IF;
559:
552:
553: fetch c_uom_qty_csr into l_uom, l_quantity;
554:
555: IF aso_debug_pub.g_debug_flag = 'Y' THEN
556: aso_debug_pub.add('Reconfigure_from_IB:UOM:'||l_uom,1,'N');
557: aso_debug_pub.add('Reconfigure_from_IB:Quantity:'||l_quantity,1,'N');
558: END IF;
559:
560: IF c_uom_qty_csr%NOTFOUND THEN
553: fetch c_uom_qty_csr into l_uom, l_quantity;
554:
555: IF aso_debug_pub.g_debug_flag = 'Y' THEN
556: aso_debug_pub.add('Reconfigure_from_IB:UOM:'||l_uom,1,'N');
557: aso_debug_pub.add('Reconfigure_from_IB:Quantity:'||l_quantity,1,'N');
558: END IF;
559:
560: IF c_uom_qty_csr%NOTFOUND THEN
561: CLOSE c_uom_qty_csr;
583: Open c_last_update_date_csr(P_QTE_HEADER_REC.quote_header_id);
584:
585: fetch c_last_update_date_csr into l_last_update_date;
586:
587: IF aso_debug_pub.g_debug_flag = 'Y' THEN
588: aso_debug_pub.add('Reconfigure_from_IB:Last Update date:'||l_last_update_date,1,'N');
589: END IF;
590:
591: IF c_last_update_date_csr%NOTFOUND THEN
584:
585: fetch c_last_update_date_csr into l_last_update_date;
586:
587: IF aso_debug_pub.g_debug_flag = 'Y' THEN
588: aso_debug_pub.add('Reconfigure_from_IB:Last Update date:'||l_last_update_date,1,'N');
589: END IF;
590:
591: IF c_last_update_date_csr%NOTFOUND THEN
592: CLOSE c_configuration_details_csr;
639: X_Return_Status => x_Return_Status,
640: X_Msg_Count => x_Msg_Count,
641: X_Msg_Data => x_Msg_Data);
642:
643: IF aso_debug_pub.g_debug_flag = 'Y' THEN
644: aso_debug_pub.add('Reconfigure_from_IB:update_Quote:Return status:'||x_return_status,1,'N');
645: aso_debug_pub.add('Reconfigure_from_IB:update_Quote:Msg count:'||x_msg_count,1,'N');
646: END IF;
647:
640: X_Msg_Count => x_Msg_Count,
641: X_Msg_Data => x_Msg_Data);
642:
643: IF aso_debug_pub.g_debug_flag = 'Y' THEN
644: aso_debug_pub.add('Reconfigure_from_IB:update_Quote:Return status:'||x_return_status,1,'N');
645: aso_debug_pub.add('Reconfigure_from_IB:update_Quote:Msg count:'||x_msg_count,1,'N');
646: END IF;
647:
648: IF x_return_status = FND_API.G_RET_STS_ERROR then
641: X_Msg_Data => x_Msg_Data);
642:
643: IF aso_debug_pub.g_debug_flag = 'Y' THEN
644: aso_debug_pub.add('Reconfigure_from_IB:update_Quote:Return status:'||x_return_status,1,'N');
645: aso_debug_pub.add('Reconfigure_from_IB:update_Quote:Msg count:'||x_msg_count,1,'N');
646: END IF;
647:
648: IF x_return_status = FND_API.G_RET_STS_ERROR then
649: raise FND_API.G_EXC_ERROR;
664: Open c_configuration_details_csr(lx_out_config_tree_tbl(k).config_hdr_id,lx_out_config_tree_tbl(k).config_rev_nbr);
665:
666: fetch c_configuration_details_csr into l_valid_configuration_flag,l_complete_configuration_flag;
667:
668: IF aso_debug_pub.g_debug_flag = 'Y' THEN
669: aso_debug_pub.add('Reconfigure_from_IB:Config Valid Info:'||l_complete_configuration_flag,1,'N');
670: aso_debug_pub.add('Reconfigure_from_IB:Config Complete Info:'||l_valid_configuration_flag,1,'N');
671: END IF;
672:
665:
666: fetch c_configuration_details_csr into l_valid_configuration_flag,l_complete_configuration_flag;
667:
668: IF aso_debug_pub.g_debug_flag = 'Y' THEN
669: aso_debug_pub.add('Reconfigure_from_IB:Config Valid Info:'||l_complete_configuration_flag,1,'N');
670: aso_debug_pub.add('Reconfigure_from_IB:Config Complete Info:'||l_valid_configuration_flag,1,'N');
671: END IF;
672:
673: IF c_configuration_details_csr%NOTFOUND THEN
666: fetch c_configuration_details_csr into l_valid_configuration_flag,l_complete_configuration_flag;
667:
668: IF aso_debug_pub.g_debug_flag = 'Y' THEN
669: aso_debug_pub.add('Reconfigure_from_IB:Config Valid Info:'||l_complete_configuration_flag,1,'N');
670: aso_debug_pub.add('Reconfigure_from_IB:Config Complete Info:'||l_valid_configuration_flag,1,'N');
671: END IF;
672:
673: IF c_configuration_details_csr%NOTFOUND THEN
674: CLOSE c_configuration_details_csr;
694: Open c_mdl_item_details_csr(lx_Qte_Line_Tbl(k).quote_line_id);
695:
696: fetch c_mdl_item_details_csr into l_quantity, l_uom;
697:
698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
699: aso_debug_pub.add('Reconfigure_from_IB:Config Valid Info:'||l_complete_configuration_flag,1,'N');
700: aso_debug_pub.add('Reconfigure_from_IB:Config Complete Info:'||l_valid_configuration_flag,1,'N');
701: END IF;
702:
695:
696: fetch c_mdl_item_details_csr into l_quantity, l_uom;
697:
698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
699: aso_debug_pub.add('Reconfigure_from_IB:Config Valid Info:'||l_complete_configuration_flag,1,'N');
700: aso_debug_pub.add('Reconfigure_from_IB:Config Complete Info:'||l_valid_configuration_flag,1,'N');
701: END IF;
702:
703: IF c_mdl_item_details_csr%NOTFOUND THEN
696: fetch c_mdl_item_details_csr into l_quantity, l_uom;
697:
698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
699: aso_debug_pub.add('Reconfigure_from_IB:Config Valid Info:'||l_complete_configuration_flag,1,'N');
700: aso_debug_pub.add('Reconfigure_from_IB:Config Complete Info:'||l_valid_configuration_flag,1,'N');
701: END IF;
702:
703: IF c_mdl_item_details_csr%NOTFOUND THEN
704: CLOSE c_mdl_item_details_csr;
733: x_msg_count => x_msg_count ,
734: x_msg_data => x_msg_data
735: );
736:
737: IF aso_debug_pub.g_debug_flag = 'Y' THEN
738: aso_debug_pub.add('Reconfigure_from_IB:Get_config_details:Return status:'||x_return_status,1,'N');
739: aso_debug_pub.add('Reconfigure_from_IB:Get_config_details:Msg count:'||x_msg_count,1,'N');
740: END IF;
741:
734: x_msg_data => x_msg_data
735: );
736:
737: IF aso_debug_pub.g_debug_flag = 'Y' THEN
738: aso_debug_pub.add('Reconfigure_from_IB:Get_config_details:Return status:'||x_return_status,1,'N');
739: aso_debug_pub.add('Reconfigure_from_IB:Get_config_details:Msg count:'||x_msg_count,1,'N');
740: END IF;
741:
742: IF x_return_status = FND_API.G_RET_STS_ERROR then
735: );
736:
737: IF aso_debug_pub.g_debug_flag = 'Y' THEN
738: aso_debug_pub.add('Reconfigure_from_IB:Get_config_details:Return status:'||x_return_status,1,'N');
739: aso_debug_pub.add('Reconfigure_from_IB:Get_config_details:Msg count:'||x_msg_count,1,'N');
740: END IF;
741:
742: IF x_return_status = FND_API.G_RET_STS_ERROR then
743: raise FND_API.G_EXC_ERROR;
750: x_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(P_QTE_HEADER_REC.quote_header_id);
751:
752: -- End of API body
753:
754: IF aso_debug_pub.g_debug_flag = 'Y' THEN
755: aso_debug_pub.add('****** End of Reconfigure API ******', 1, 'Y');
756: END IF;
757:
758: -- Standard check of p_commit
751:
752: -- End of API body
753:
754: IF aso_debug_pub.g_debug_flag = 'Y' THEN
755: aso_debug_pub.add('****** End of Reconfigure API ******', 1, 'Y');
756: END IF;
757:
758: -- Standard check of p_commit
759: IF FND_API.To_Boolean(p_commit) THEN
952: IF (P_Control_Rec.deactivate_all = FND_API.G_TRUE)THEN
953: For c_deactivate_all_item_rec IN c_deactivate_all_item_csr(P_Qte_Header_Rec.quote_header_id) LOOP
954: l_line_count := l_line_count + 1;
955:
956: IF aso_debug_pub.g_debug_flag = 'Y' THEN
957: aso_debug_pub.add('Deactivate_from_quote:quote_line_id:'||c_deactivate_all_item_rec.quote_line_id,1,'N');
958: END IF;
959:
960: l_qte_line_tbl(l_line_count).quote_line_id := c_deactivate_all_item_rec.quote_line_id;
953: For c_deactivate_all_item_rec IN c_deactivate_all_item_csr(P_Qte_Header_Rec.quote_header_id) LOOP
954: l_line_count := l_line_count + 1;
955:
956: IF aso_debug_pub.g_debug_flag = 'Y' THEN
957: aso_debug_pub.add('Deactivate_from_quote:quote_line_id:'||c_deactivate_all_item_rec.quote_line_id,1,'N');
958: END IF;
959:
960: l_qte_line_tbl(l_line_count).quote_line_id := c_deactivate_all_item_rec.quote_line_id;
961: END LOOP;
968: open c_check_for_macd(l_qte_line_tbl(i).quote_line_id);
969: fetch c_check_for_macd into l_macd_flag;
970: close c_check_for_macd;
971:
972: IF aso_debug_pub.g_debug_flag = 'Y' THEN
973: aso_debug_pub.add('Deactivate_from_quote:quote_line_id: '|| l_qte_line_tbl(i).quote_line_id ,1,'N');
974: aso_debug_pub.add('Deactivate_from_quote:l_macd_flag: '|| l_macd_flag ,1,'N');
975: END IF;
976:
969: fetch c_check_for_macd into l_macd_flag;
970: close c_check_for_macd;
971:
972: IF aso_debug_pub.g_debug_flag = 'Y' THEN
973: aso_debug_pub.add('Deactivate_from_quote:quote_line_id: '|| l_qte_line_tbl(i).quote_line_id ,1,'N');
974: aso_debug_pub.add('Deactivate_from_quote:l_macd_flag: '|| l_macd_flag ,1,'N');
975: END IF;
976:
977: if nvl(l_macd_flag,'X') = 'N' then
970: close c_check_for_macd;
971:
972: IF aso_debug_pub.g_debug_flag = 'Y' THEN
973: aso_debug_pub.add('Deactivate_from_quote:quote_line_id: '|| l_qte_line_tbl(i).quote_line_id ,1,'N');
974: aso_debug_pub.add('Deactivate_from_quote:l_macd_flag: '|| l_macd_flag ,1,'N');
975: END IF;
976:
977: if nvl(l_macd_flag,'X') = 'N' then
978: l_macd_qte_line_tbl(l_macd_qte_line_tbl.count + 1).quote_line_id := l_qte_line_tbl(i).quote_line_id;
982: l_macd_flag := null;
983:
984: end loop;
985:
986: IF aso_debug_pub.g_debug_flag = 'Y' THEN
987: aso_debug_pub.add('Deactivate_from_quote:l_macd_qte_line_tbl.count: '|| l_macd_qte_line_tbl.count,1,'N');
988: aso_debug_pub.add('Deactivate_from_quote:ORIGINAL l_qte_line_tbl.count: '|| l_qte_line_tbl.count,1,'N');
989: END IF;
990:
983:
984: end loop;
985:
986: IF aso_debug_pub.g_debug_flag = 'Y' THEN
987: aso_debug_pub.add('Deactivate_from_quote:l_macd_qte_line_tbl.count: '|| l_macd_qte_line_tbl.count,1,'N');
988: aso_debug_pub.add('Deactivate_from_quote:ORIGINAL l_qte_line_tbl.count: '|| l_qte_line_tbl.count,1,'N');
989: END IF;
990:
991: -- reset the qte line tbl to have only MACD Lines
984: end loop;
985:
986: IF aso_debug_pub.g_debug_flag = 'Y' THEN
987: aso_debug_pub.add('Deactivate_from_quote:l_macd_qte_line_tbl.count: '|| l_macd_qte_line_tbl.count,1,'N');
988: aso_debug_pub.add('Deactivate_from_quote:ORIGINAL l_qte_line_tbl.count: '|| l_qte_line_tbl.count,1,'N');
989: END IF;
990:
991: -- reset the qte line tbl to have only MACD Lines
992: l_qte_line_tbl := l_macd_qte_line_tbl;
990:
991: -- reset the qte line tbl to have only MACD Lines
992: l_qte_line_tbl := l_macd_qte_line_tbl;
993:
994: IF aso_debug_pub.g_debug_flag = 'Y' THEN
995: aso_debug_pub.add('Deactivate_from_quote:MODIFIED l_qte_line_tbl.count: '|| l_qte_line_tbl.count,1,'N');
996: END IF;
997:
998: -- end of fox for bug 4900023
991: -- reset the qte line tbl to have only MACD Lines
992: l_qte_line_tbl := l_macd_qte_line_tbl;
993:
994: IF aso_debug_pub.g_debug_flag = 'Y' THEN
995: aso_debug_pub.add('Deactivate_from_quote:MODIFIED l_qte_line_tbl.count: '|| l_qte_line_tbl.count,1,'N');
996: END IF;
997:
998: -- end of fox for bug 4900023
999:
1025: Open c_chk_qte_line_mdl_csr(l_qte_line_tbl(i).quote_line_id);
1026:
1027: fetch c_chk_qte_line_mdl_csr into l_config_header_id, l_rev_num;
1028:
1029: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1030: aso_debug_pub.add('Deactivate_from_quote:Config header Id:'||l_config_header_id,1,'N');
1031: aso_debug_pub.add('Deactivate_from_quote:Config Rev num:'||l_rev_num,1,'N');
1032: END IF;
1033:
1026:
1027: fetch c_chk_qte_line_mdl_csr into l_config_header_id, l_rev_num;
1028:
1029: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1030: aso_debug_pub.add('Deactivate_from_quote:Config header Id:'||l_config_header_id,1,'N');
1031: aso_debug_pub.add('Deactivate_from_quote:Config Rev num:'||l_rev_num,1,'N');
1032: END IF;
1033:
1034: IF c_chk_qte_line_mdl_csr%NOTFOUND THEN
1027: fetch c_chk_qte_line_mdl_csr into l_config_header_id, l_rev_num;
1028:
1029: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1030: aso_debug_pub.add('Deactivate_from_quote:Config header Id:'||l_config_header_id,1,'N');
1031: aso_debug_pub.add('Deactivate_from_quote:Config Rev num:'||l_rev_num,1,'N');
1032: END IF;
1033:
1034: IF c_chk_qte_line_mdl_csr%NOTFOUND THEN
1035: l_config_header_id := null;
1072: x_return_status => x_return_status,
1073: x_msg_count => x_msg_count,
1074: x_msg_data => x_msg_data );
1075:
1076: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1077: aso_debug_pub.add('Deactivate_from_quote:ext_deactivate_item: Return status:'||x_return_status,1,'N');
1078: aso_debug_pub.add('Deactivate_from_quote:ext_deactivate_item: Msg count:'||x_msg_count,1,'N');
1079: END IF;
1080:
1073: x_msg_count => x_msg_count,
1074: x_msg_data => x_msg_data );
1075:
1076: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1077: aso_debug_pub.add('Deactivate_from_quote:ext_deactivate_item: Return status:'||x_return_status,1,'N');
1078: aso_debug_pub.add('Deactivate_from_quote:ext_deactivate_item: Msg count:'||x_msg_count,1,'N');
1079: END IF;
1080:
1081: IF x_return_status = FND_API.G_RET_STS_ERROR then
1074: x_msg_data => x_msg_data );
1075:
1076: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1077: aso_debug_pub.add('Deactivate_from_quote:ext_deactivate_item: Return status:'||x_return_status,1,'N');
1078: aso_debug_pub.add('Deactivate_from_quote:ext_deactivate_item: Msg count:'||x_msg_count,1,'N');
1079: END IF;
1080:
1081: IF x_return_status = FND_API.G_RET_STS_ERROR then
1082: raise FND_API.G_EXC_ERROR;
1090: Open c_top_mdl_csr(c_deactivate_item_rec.config_header_id,c_deactivate_item_rec.config_revision_num);
1091:
1092: fetch c_top_mdl_csr into l_config_item_id;
1093:
1094: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1095: aso_debug_pub.add('Deactivate_from_quote:Config Valid Info:'||l_complete_configuration_flag,1,'N');
1096: aso_debug_pub.add('Deactivate_from_quote:Config Complete Info:'||l_valid_configuration_flag,1,'N');
1097: END IF;
1098:
1091:
1092: fetch c_top_mdl_csr into l_config_item_id;
1093:
1094: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1095: aso_debug_pub.add('Deactivate_from_quote:Config Valid Info:'||l_complete_configuration_flag,1,'N');
1096: aso_debug_pub.add('Deactivate_from_quote:Config Complete Info:'||l_valid_configuration_flag,1,'N');
1097: END IF;
1098:
1099: IF c_top_mdl_csr%FOUND THEN
1092: fetch c_top_mdl_csr into l_config_item_id;
1093:
1094: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1095: aso_debug_pub.add('Deactivate_from_quote:Config Valid Info:'||l_complete_configuration_flag,1,'N');
1096: aso_debug_pub.add('Deactivate_from_quote:Config Complete Info:'||l_valid_configuration_flag,1,'N');
1097: END IF;
1098:
1099: IF c_top_mdl_csr%FOUND THEN
1100: l_copy_conf_mdl_Tbl(i).config_item_id := l_config_item_id;
1141:
1142: fetch c_top_mdl_details_csr into l_quote_line_id,l_quantity, l_uom_code,l_complete_configuration_flag,
1143: l_valid_configuration_flag;
1144:
1145: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1146: aso_debug_pub.add('Deactivate_from_quote:Config Valid Info:'||l_complete_configuration_flag,1,'N');
1147: aso_debug_pub.add('Deactivate_from_quote:Config Complete Info:'||l_valid_configuration_flag,1,'N');
1148: END IF;
1149:
1142: fetch c_top_mdl_details_csr into l_quote_line_id,l_quantity, l_uom_code,l_complete_configuration_flag,
1143: l_valid_configuration_flag;
1144:
1145: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1146: aso_debug_pub.add('Deactivate_from_quote:Config Valid Info:'||l_complete_configuration_flag,1,'N');
1147: aso_debug_pub.add('Deactivate_from_quote:Config Complete Info:'||l_valid_configuration_flag,1,'N');
1148: END IF;
1149:
1150: IF c_top_mdl_details_csr%NOTFOUND THEN
1143: l_valid_configuration_flag;
1144:
1145: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1146: aso_debug_pub.add('Deactivate_from_quote:Config Valid Info:'||l_complete_configuration_flag,1,'N');
1147: aso_debug_pub.add('Deactivate_from_quote:Config Complete Info:'||l_valid_configuration_flag,1,'N');
1148: END IF;
1149:
1150: IF c_top_mdl_details_csr%NOTFOUND THEN
1151: null;-- No Action
1168:
1169: Open c_last_update_date_csr(P_QTE_HEADER_REC.quote_header_id);
1170: fetch c_last_update_date_csr into l_last_update_date,l_obj_version_number;
1171:
1172: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1173: aso_debug_pub.add('Deactivate_from_quote:Last Update date:'||l_last_update_date,1,'N');
1174: aso_debug_pub.add('Deactivate_from_quote:Object Version Number:'||l_obj_version_number,1,'N');
1175: END IF;
1176:
1169: Open c_last_update_date_csr(P_QTE_HEADER_REC.quote_header_id);
1170: fetch c_last_update_date_csr into l_last_update_date,l_obj_version_number;
1171:
1172: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1173: aso_debug_pub.add('Deactivate_from_quote:Last Update date:'||l_last_update_date,1,'N');
1174: aso_debug_pub.add('Deactivate_from_quote:Object Version Number:'||l_obj_version_number,1,'N');
1175: END IF;
1176:
1177: IF c_last_update_date_csr%NOTFOUND THEN
1170: fetch c_last_update_date_csr into l_last_update_date,l_obj_version_number;
1171:
1172: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1173: aso_debug_pub.add('Deactivate_from_quote:Last Update date:'||l_last_update_date,1,'N');
1174: aso_debug_pub.add('Deactivate_from_quote:Object Version Number:'||l_obj_version_number,1,'N');
1175: END IF;
1176:
1177: IF c_last_update_date_csr%NOTFOUND THEN
1178: CLOSE c_last_update_date_csr;
1192:
1193: l_QTE_HEADER_REC.last_update_date := l_last_update_date;
1194: l_QTE_HEADER_REC.object_version_number := l_obj_version_number;
1195:
1196: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1197: aso_debug_pub.add('Deactivate_from_quote:Before calling get_config_details ', 1, 'N');
1198: aso_debug_pub.add('Deactivate_from_quote:l_config_rec.config_header_id: '||l_config_rec.config_header_id, 1, 'N');
1199: aso_debug_pub.add('Deactivate_from_quote:l_config_rec.config_revision_num: '||l_config_rec.config_revision_num, 1, 'N');
1200: aso_debug_pub.add('Deactivate_from_quote:l_copy_conf_mdl_Tbl.config_header_id: '||l_copy_conf_mdl_Tbl(j).config_header_id, 1, 'N');
1193: l_QTE_HEADER_REC.last_update_date := l_last_update_date;
1194: l_QTE_HEADER_REC.object_version_number := l_obj_version_number;
1195:
1196: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1197: aso_debug_pub.add('Deactivate_from_quote:Before calling get_config_details ', 1, 'N');
1198: aso_debug_pub.add('Deactivate_from_quote:l_config_rec.config_header_id: '||l_config_rec.config_header_id, 1, 'N');
1199: aso_debug_pub.add('Deactivate_from_quote:l_config_rec.config_revision_num: '||l_config_rec.config_revision_num, 1, 'N');
1200: aso_debug_pub.add('Deactivate_from_quote:l_copy_conf_mdl_Tbl.config_header_id: '||l_copy_conf_mdl_Tbl(j).config_header_id, 1, 'N');
1201: aso_debug_pub.add('Deactivate_from_quote:l_copy_conf_mdl_Tbl.config_revision_num: '||l_copy_conf_mdl_Tbl(j).config_revision_num, 1, 'N');
1194: l_QTE_HEADER_REC.object_version_number := l_obj_version_number;
1195:
1196: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1197: aso_debug_pub.add('Deactivate_from_quote:Before calling get_config_details ', 1, 'N');
1198: aso_debug_pub.add('Deactivate_from_quote:l_config_rec.config_header_id: '||l_config_rec.config_header_id, 1, 'N');
1199: aso_debug_pub.add('Deactivate_from_quote:l_config_rec.config_revision_num: '||l_config_rec.config_revision_num, 1, 'N');
1200: aso_debug_pub.add('Deactivate_from_quote:l_copy_conf_mdl_Tbl.config_header_id: '||l_copy_conf_mdl_Tbl(j).config_header_id, 1, 'N');
1201: aso_debug_pub.add('Deactivate_from_quote:l_copy_conf_mdl_Tbl.config_revision_num: '||l_copy_conf_mdl_Tbl(j).config_revision_num, 1, 'N');
1202: END IF;
1195:
1196: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1197: aso_debug_pub.add('Deactivate_from_quote:Before calling get_config_details ', 1, 'N');
1198: aso_debug_pub.add('Deactivate_from_quote:l_config_rec.config_header_id: '||l_config_rec.config_header_id, 1, 'N');
1199: aso_debug_pub.add('Deactivate_from_quote:l_config_rec.config_revision_num: '||l_config_rec.config_revision_num, 1, 'N');
1200: aso_debug_pub.add('Deactivate_from_quote:l_copy_conf_mdl_Tbl.config_header_id: '||l_copy_conf_mdl_Tbl(j).config_header_id, 1, 'N');
1201: aso_debug_pub.add('Deactivate_from_quote:l_copy_conf_mdl_Tbl.config_revision_num: '||l_copy_conf_mdl_Tbl(j).config_revision_num, 1, 'N');
1202: END IF;
1203:
1196: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1197: aso_debug_pub.add('Deactivate_from_quote:Before calling get_config_details ', 1, 'N');
1198: aso_debug_pub.add('Deactivate_from_quote:l_config_rec.config_header_id: '||l_config_rec.config_header_id, 1, 'N');
1199: aso_debug_pub.add('Deactivate_from_quote:l_config_rec.config_revision_num: '||l_config_rec.config_revision_num, 1, 'N');
1200: aso_debug_pub.add('Deactivate_from_quote:l_copy_conf_mdl_Tbl.config_header_id: '||l_copy_conf_mdl_Tbl(j).config_header_id, 1, 'N');
1201: aso_debug_pub.add('Deactivate_from_quote:l_copy_conf_mdl_Tbl.config_revision_num: '||l_copy_conf_mdl_Tbl(j).config_revision_num, 1, 'N');
1202: END IF;
1203:
1204:
1197: aso_debug_pub.add('Deactivate_from_quote:Before calling get_config_details ', 1, 'N');
1198: aso_debug_pub.add('Deactivate_from_quote:l_config_rec.config_header_id: '||l_config_rec.config_header_id, 1, 'N');
1199: aso_debug_pub.add('Deactivate_from_quote:l_config_rec.config_revision_num: '||l_config_rec.config_revision_num, 1, 'N');
1200: aso_debug_pub.add('Deactivate_from_quote:l_copy_conf_mdl_Tbl.config_header_id: '||l_copy_conf_mdl_Tbl(j).config_header_id, 1, 'N');
1201: aso_debug_pub.add('Deactivate_from_quote:l_copy_conf_mdl_Tbl.config_revision_num: '||l_copy_conf_mdl_Tbl(j).config_revision_num, 1, 'N');
1202: END IF;
1203:
1204:
1205:
1217: x_msg_count => x_msg_count ,
1218: x_msg_data => x_msg_data
1219: );
1220:
1221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1222: aso_debug_pub.add('Deactivate_from_quote:Get_config_details:x_return_status'||x_return_status, 1, 'N');
1223: aso_debug_pub.add('Deactivate_from_quote:Get_config_details:x_return_status'||x_msg_count, 1, 'N');
1224: END IF;
1225:
1218: x_msg_data => x_msg_data
1219: );
1220:
1221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1222: aso_debug_pub.add('Deactivate_from_quote:Get_config_details:x_return_status'||x_return_status, 1, 'N');
1223: aso_debug_pub.add('Deactivate_from_quote:Get_config_details:x_return_status'||x_msg_count, 1, 'N');
1224: END IF;
1225:
1226: IF x_return_status = FND_API.G_RET_STS_ERROR then
1219: );
1220:
1221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1222: aso_debug_pub.add('Deactivate_from_quote:Get_config_details:x_return_status'||x_return_status, 1, 'N');
1223: aso_debug_pub.add('Deactivate_from_quote:Get_config_details:x_return_status'||x_msg_count, 1, 'N');
1224: END IF;
1225:
1226: IF x_return_status = FND_API.G_RET_STS_ERROR then
1227: raise FND_API.G_EXC_ERROR;
1228: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1229: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1230: END IF;
1231:
1232: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1233: aso_debug_pub.add('Deactivate_from_quote:Write to l_deactivate_mdl_Tbl', 1, 'N');
1234: END IF;
1235:
1236: l_deactivate_mdl_Tbl(l_count).config_item_id := l_copy_conf_mdl_Tbl(j).config_item_id;
1229: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1230: END IF;
1231:
1232: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1233: aso_debug_pub.add('Deactivate_from_quote:Write to l_deactivate_mdl_Tbl', 1, 'N');
1234: END IF;
1235:
1236: l_deactivate_mdl_Tbl(l_count).config_item_id := l_copy_conf_mdl_Tbl(j).config_item_id;
1237: l_deactivate_mdl_Tbl(l_count).config_header_id := l_copy_conf_mdl_Tbl(j).config_header_id;
1241:
1242: END LOOP;
1243: end if;
1244:
1245: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1246: aso_debug_pub.add('Deactivate_from_quote:Query Quote Header Rec', 1, 'N');
1247: END IF;
1248:
1249: x_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(P_QTE_HEADER_REC.quote_header_id);
1242: END LOOP;
1243: end if;
1244:
1245: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1246: aso_debug_pub.add('Deactivate_from_quote:Query Quote Header Rec', 1, 'N');
1247: END IF;
1248:
1249: x_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(P_QTE_HEADER_REC.quote_header_id);
1250:
1249: x_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(P_QTE_HEADER_REC.quote_header_id);
1250:
1251: -- End of API body
1252:
1253: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1254: aso_debug_pub.add('****** End of Deactivate from quote API ******', 1, 'Y');
1255: END IF;
1256:
1257: -- Standard check of p_commit
1250:
1251: -- End of API body
1252:
1253: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1254: aso_debug_pub.add('****** End of Deactivate from quote API ******', 1, 'Y');
1255: END IF;
1256:
1257: -- Standard check of p_commit
1258: IF FND_API.To_Boolean(p_commit) THEN