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

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

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:

Line 103: aso_debug_pub.add('Add_to_Container_from_IB:Config Header Id:'||c_item_rec.config_inst_hdr_id,1,'N');

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;

Line 104: aso_debug_pub.add('Add_to_Container_from_IB:Config Rev Num:'||c_item_rec.config_inst_rev_num,1,'N');

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;

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

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:

Line 129: aso_debug_pub.add('Add_to_Container_from_IB: Config Header Id:'||l_hdr_id,1,'N');

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: /**************************************************************

Line 130: aso_debug_pub.add('Add_to_Container_from_IB: Config Rev Number:'||l_rev_nbr,1,'N');

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

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

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');

Line 140: aso_debug_pub.add('Add_to_Container_from_IB:Inventory Item Id:'||c_mdl_item_details_rec.inventory_item_id,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;

Line 141: aso_debug_pub.add('Add_to_Container_from_IB:Organization Id'||c_mdl_item_details_rec.organization_id,1,'N');

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:

Line 142: aso_debug_pub.add('Add_to_Container_from_IB:Quantity:'||c_mdl_item_details_rec.quantity,1,'N');

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: /**************************************************************

Line 143: aso_debug_pub.add('Add_to_Container_from_IB:UOM Code:'||c_mdl_item_details_rec.uom_code,1,'N');

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

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

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');

Line 198: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Return status:'||x_return_status,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:

Line 199: aso_debug_pub.add('Add_to_Container_from_IB:Add_to_config_tree:Msg count:'||x_msg_count,1,'N');

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;

Line 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');

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:

Line 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');

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

Line 218: IF aso_debug_pub.g_debug_flag = 'Y' 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:

Line 219: aso_debug_pub.add('Add_to_Container_from_IB:Config Valid Info:'||l_complete_configuration_flag,1,'N');

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

Line 220: aso_debug_pub.add('Add_to_Container_from_IB:Config Complete Info:'||l_valid_configuration_flag,1,'N');

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;

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

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

Line 259: aso_debug_pub.add('Add_to_Container_from_IB:Last Update date:'||l_last_update_date,1,'N');

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;

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

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:

Line 297: aso_debug_pub.add('Add_to_Container_from_IB:Get_config_details:Return status:'||x_return_status,1,'N');

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

Line 298: aso_debug_pub.add('Add_to_Container_from_IB:Get_config_details:Msg count:'||x_msg_count,1,'N');

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;

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

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

Line 311: aso_debug_pub.add(' End of add to container API ', 1, 'Y');

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

Line 504: IF aso_debug_pub.g_debug_flag = 'Y' 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:

Line 505: aso_debug_pub.add('Reconfigure_from_IB:Config Header Id:'||c_item_rec.config_inst_hdr_id,1,'N');

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;

Line 506: aso_debug_pub.add('Reconfigure_from_IB:Config Rev Num:'||c_item_rec.config_inst_rev_num,1,'N');

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;

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

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:

Line 535: aso_debug_pub.add('Reconfigure_from_IB:Generate_config_trees:Return status:'||x_return_status,1,'N');

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

Line 536: aso_debug_pub.add('Reconfigure_from_IB:Generate_config_trees:Msg count:'||x_msg_count,1,'N');

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;

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

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:

Line 556: aso_debug_pub.add('Reconfigure_from_IB:UOM:'||l_uom,1,'N');

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

Line 557: aso_debug_pub.add('Reconfigure_from_IB:Quantity:'||l_quantity,1,'N');

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;

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

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

Line 588: aso_debug_pub.add('Reconfigure_from_IB:Last Update date:'||l_last_update_date,1,'N');

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;

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

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:

Line 644: aso_debug_pub.add('Reconfigure_from_IB:update_Quote:Return status:'||x_return_status,1,'N');

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

Line 645: aso_debug_pub.add('Reconfigure_from_IB:update_Quote:Msg count:'||x_msg_count,1,'N');

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;

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

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:

Line 669: aso_debug_pub.add('Reconfigure_from_IB:Config Valid Info:'||l_complete_configuration_flag,1,'N');

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

Line 670: aso_debug_pub.add('Reconfigure_from_IB:Config Complete Info:'||l_valid_configuration_flag,1,'N');

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;

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

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:

Line 699: aso_debug_pub.add('Reconfigure_from_IB:Config Valid Info:'||l_complete_configuration_flag,1,'N');

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

Line 700: aso_debug_pub.add('Reconfigure_from_IB:Config Complete Info:'||l_valid_configuration_flag,1,'N');

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;

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

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:

Line 738: aso_debug_pub.add('Reconfigure_from_IB:Get_config_details:Return status:'||x_return_status,1,'N');

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

Line 739: aso_debug_pub.add('Reconfigure_from_IB:Get_config_details:Msg count:'||x_msg_count,1,'N');

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;

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

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

Line 755: aso_debug_pub.add(' End of Reconfigure API ', 1, 'Y');

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

Line 956: IF aso_debug_pub.g_debug_flag = 'Y' 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;

Line 957: aso_debug_pub.add('Deactivate_from_quote:quote_line_id:'||c_deactivate_all_item_rec.quote_line_id,1,'N');

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;

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

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:

Line 973: aso_debug_pub.add('Deactivate_from_quote:quote_line_id: '|| l_qte_line_tbl(i).quote_line_id ,1,'N');

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

Line 974: aso_debug_pub.add('Deactivate_from_quote:l_macd_flag: '|| l_macd_flag ,1,'N');

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;

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

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:

Line 987: aso_debug_pub.add('Deactivate_from_quote:l_macd_qte_line_tbl.count: '|| l_macd_qte_line_tbl.count,1,'N');

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

Line 988: aso_debug_pub.add('Deactivate_from_quote:ORIGINAL l_qte_line_tbl.count: '|| l_qte_line_tbl.count,1,'N');

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;

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

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

Line 995: aso_debug_pub.add('Deactivate_from_quote:MODIFIED l_qte_line_tbl.count: '|| l_qte_line_tbl.count,1,'N');

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:

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

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:

Line 1030: aso_debug_pub.add('Deactivate_from_quote:Config header Id:'||l_config_header_id,1,'N');

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

Line 1031: aso_debug_pub.add('Deactivate_from_quote:Config Rev num:'||l_rev_num,1,'N');

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;

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

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:

Line 1077: aso_debug_pub.add('Deactivate_from_quote:ext_deactivate_item: Return status:'||x_return_status,1,'N');

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

Line 1078: aso_debug_pub.add('Deactivate_from_quote:ext_deactivate_item: Msg count:'||x_msg_count,1,'N');

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;

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

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:

Line 1095: aso_debug_pub.add('Deactivate_from_quote:Config Valid Info:'||l_complete_configuration_flag,1,'N');

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

Line 1096: aso_debug_pub.add('Deactivate_from_quote:Config Complete Info:'||l_valid_configuration_flag,1,'N');

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;

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

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:

Line 1146: aso_debug_pub.add('Deactivate_from_quote:Config Valid Info:'||l_complete_configuration_flag,1,'N');

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

Line 1147: aso_debug_pub.add('Deactivate_from_quote:Config Complete Info:'||l_valid_configuration_flag,1,'N');

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

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

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:

Line 1173: aso_debug_pub.add('Deactivate_from_quote:Last Update date:'||l_last_update_date,1,'N');

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

Line 1174: aso_debug_pub.add('Deactivate_from_quote:Object Version Number:'||l_obj_version_number,1,'N');

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;

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

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');

Line 1197: aso_debug_pub.add('Deactivate_from_quote:Before calling get_config_details ', 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');

Line 1198: aso_debug_pub.add('Deactivate_from_quote:l_config_rec.config_header_id: '||l_config_rec.config_header_id, 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;

Line 1199: aso_debug_pub.add('Deactivate_from_quote:l_config_rec.config_revision_num: '||l_config_rec.config_revision_num, 1, 'N');

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:

Line 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');

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:

Line 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');

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:

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

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:

Line 1222: aso_debug_pub.add('Deactivate_from_quote:Get_config_details:x_return_status'||x_return_status, 1, 'N');

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

Line 1223: aso_debug_pub.add('Deactivate_from_quote:Get_config_details:x_return_status'||x_msg_count, 1, 'N');

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;

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

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;

Line 1233: aso_debug_pub.add('Deactivate_from_quote:Write to l_deactivate_mdl_Tbl', 1, 'N');

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;

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

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);

Line 1246: aso_debug_pub.add('Deactivate_from_quote:Query Quote Header Rec', 1, 'N');

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:

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

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

Line 1254: aso_debug_pub.add(' End of Deactivate from quote API ', 1, 'Y');

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