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

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

112: END IF;
113:
114: -- ******************************************************************
115:
116: IF aso_debug_pub.g_debug_flag = 'Y' THEN
117: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Tmpl_to_tmpl ' , 1 , 'Y' );
118: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl quote_header_id'||P_old_quote_header_Id , 1 , 'Y' );
119: end if;
120:

Line 117: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Tmpl_to_tmpl ' , 1 , 'Y' );

113:
114: -- ******************************************************************
115:
116: IF aso_debug_pub.g_debug_flag = 'Y' THEN
117: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Tmpl_to_tmpl ' , 1 , 'Y' );
118: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl quote_header_id'||P_old_quote_header_Id , 1 , 'Y' );
119: end if;
120:
121: OPEN C_Qte_Number;

Line 118: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl quote_header_id'||P_old_quote_header_Id , 1 , 'Y' );

114: -- ******************************************************************
115:
116: IF aso_debug_pub.g_debug_flag = 'Y' THEN
117: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Tmpl_to_tmpl ' , 1 , 'Y' );
118: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl quote_header_id'||P_old_quote_header_Id , 1 , 'Y' );
119: end if;
120:
121: OPEN C_Qte_Number;
122: FETCH C_Qte_Number INTO l_qte_header_rec.quote_number;

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

159: CLOSE c_qte_status_id;
160:
161:
162:
163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
164: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl ' , 1 , 'Y' );
165: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl quote_number'|| l_qte_header_rec.quote_number , 1 , 'Y' );
166: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl org_id'|| l_qte_header_rec.org_id , 1 , 'Y' );
167: end if;

Line 164: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl ' , 1 , 'Y' );

160:
161:
162:
163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
164: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl ' , 1 , 'Y' );
165: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl quote_number'|| l_qte_header_rec.quote_number , 1 , 'Y' );
166: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl org_id'|| l_qte_header_rec.org_id , 1 , 'Y' );
167: end if;
168:

Line 165: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl quote_number'|| l_qte_header_rec.quote_number , 1 , 'Y' );

161:
162:
163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
164: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl ' , 1 , 'Y' );
165: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl quote_number'|| l_qte_header_rec.quote_number , 1 , 'Y' );
166: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl org_id'|| l_qte_header_rec.org_id , 1 , 'Y' );
167: end if;
168:
169:

Line 166: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl org_id'|| l_qte_header_rec.org_id , 1 , 'Y' );

162:
163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
164: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl ' , 1 , 'Y' );
165: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl quote_number'|| l_qte_header_rec.quote_number , 1 , 'Y' );
166: aso_debug_pub.ADD ( 'Copy_Tmpl - Begin- ASO_COPY_TMPL_PUB.Copy_Quote_to_tmpl org_id'|| l_qte_header_rec.org_id , 1 , 'Y' );
167: end if;
168:
169:
170: l_qte_header_rec.TOTAL_LIST_PRICE := NULL;

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

207: , X_Return_Status => l_return_status
208: , X_Msg_Count => x_msg_count
209: , X_Msg_Data => x_msg_data
210: );
211: IF aso_debug_pub.g_debug_flag = 'Y' THEN
212: aso_debug_pub.ADD ( 'Copy_Tmpl - After copy_ header rows ' || l_return_status , 1 , 'Y' );
213: END IF;
214:
215: X_Qte_Number:= l_qte_header_rec.quote_number;

Line 212: aso_debug_pub.ADD ( 'Copy_Tmpl - After copy_ header rows ' || l_return_status , 1 , 'Y' );

208: , X_Msg_Count => x_msg_count
209: , X_Msg_Data => x_msg_data
210: );
211: IF aso_debug_pub.g_debug_flag = 'Y' THEN
212: aso_debug_pub.ADD ( 'Copy_Tmpl - After copy_ header rows ' || l_return_status , 1 , 'Y' );
213: END IF;
214:
215: X_Qte_Number:= l_qte_header_rec.quote_number;
216: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

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

225: x_return_status := FND_API.G_RET_STS_ERROR;
226: RAISE FND_API.G_EXC_ERROR;
227: END IF;
228:
229: IF aso_debug_pub.g_debug_flag = 'Y' THEN
230: aso_debug_pub.ADD ( 'Copy_template - before copy template rows ', 1 , 'Y' );
231: END IF;
232:
233:

Line 230: aso_debug_pub.ADD ( 'Copy_template - before copy template rows ', 1 , 'Y' );

226: RAISE FND_API.G_EXC_ERROR;
227: END IF;
228:
229: IF aso_debug_pub.g_debug_flag = 'Y' THEN
230: aso_debug_pub.ADD ( 'Copy_template - before copy template rows ', 1 , 'Y' );
231: END IF;
232:
233:
234:

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

243: , X_Return_Status => l_return_status
244: , X_Msg_Count => x_msg_count
245: , X_Msg_Data => x_msg_data
246: );
247: IF aso_debug_pub.g_debug_flag = 'Y' THEN
248: aso_debug_pub.ADD ( 'Copy_template - template rows ' || l_return_status , 1 , 'Y' );
249: END IF;
250:
251: if (l_return_status =FND_API.G_RET_STS_SUCCESS) then

Line 248: aso_debug_pub.ADD ( 'Copy_template - template rows ' || l_return_status , 1 , 'Y' );

244: , X_Msg_Count => x_msg_count
245: , X_Msg_Data => x_msg_data
246: );
247: IF aso_debug_pub.g_debug_flag = 'Y' THEN
248: aso_debug_pub.ADD ( 'Copy_template - template rows ' || l_return_status , 1 , 'Y' );
249: END IF;
250:
251: if (l_return_status =FND_API.G_RET_STS_SUCCESS) then
252:

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

251: if (l_return_status =FND_API.G_RET_STS_SUCCESS) then
252:
253:
254: if l_copy_config_profile='N' then
255: IF aso_debug_pub.g_debug_flag = 'Y' THEN
256: aso_debug_pub.add('Copy_template -before ASO_QUOTE_PUB.validate_model_configuration return status: ', 1, 'N');
257: end if;
258:
259: ASO_QUOTE_PUB.validate_model_configuration

Line 256: aso_debug_pub.add('Copy_template -before ASO_QUOTE_PUB.validate_model_configuration return status: ', 1, 'N');

252:
253:
254: if l_copy_config_profile='N' then
255: IF aso_debug_pub.g_debug_flag = 'Y' THEN
256: aso_debug_pub.add('Copy_template -before ASO_QUOTE_PUB.validate_model_configuration return status: ', 1, 'N');
257: end if;
258:
259: ASO_QUOTE_PUB.validate_model_configuration
260: (

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

274: if l_Return_Status=FND_API.G_RET_STS_SUCCESS then
275: commit work;
276: end if;
277:
278: IF aso_debug_pub.g_debug_flag = 'Y' THEN
279: aso_debug_pub.add('Copy_template -After ASO_QUOTE_PUB.validate_model_configuration return status: '||l_Return_Status, 1, 'N');
280: aso_debug_pub.add('Copy_template -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
281: END IF;
282:

Line 279: aso_debug_pub.add('Copy_template -After ASO_QUOTE_PUB.validate_model_configuration return status: '||l_Return_Status, 1, 'N');

275: commit work;
276: end if;
277:
278: IF aso_debug_pub.g_debug_flag = 'Y' THEN
279: aso_debug_pub.add('Copy_template -After ASO_QUOTE_PUB.validate_model_configuration return status: '||l_Return_Status, 1, 'N');
280: aso_debug_pub.add('Copy_template -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
281: END IF;
282:
283: end if; -- profile

Line 280: aso_debug_pub.add('Copy_template -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');

276: end if;
277:
278: IF aso_debug_pub.g_debug_flag = 'Y' THEN
279: aso_debug_pub.add('Copy_template -After ASO_QUOTE_PUB.validate_model_configuration return status: '||l_Return_Status, 1, 'N');
280: aso_debug_pub.add('Copy_template -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
281: END IF;
282:
283: end if; -- profile
284: end if; -- success

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

401:
402:
403: --l_qte_header_rec :=l_qte_header_rec_out ;
404:
405: IF aso_debug_pub.g_debug_flag = 'Y' THEN
406: aso_debug_pub.ADD ( 'Copy_Template - After insert_rows - status: ' || l_return_status , 1 , 'Y' );
407: END IF;
408:
409: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

Line 406: aso_debug_pub.ADD ( 'Copy_Template - After insert_rows - status: ' || l_return_status , 1 , 'Y' );

402:
403: --l_qte_header_rec :=l_qte_header_rec_out ;
404:
405: IF aso_debug_pub.g_debug_flag = 'Y' THEN
406: aso_debug_pub.ADD ( 'Copy_Template - After insert_rows - status: ' || l_return_status , 1 , 'Y' );
407: END IF;
408:
409: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

619: --
620: -- API body
621: --
622:
623: IF aso_debug_pub.g_debug_flag = 'Y' THEN
624: aso_debug_pub.ADD ('Copy_Template - Header and Lines' , 1, 'N' );
625: END IF;
626:
627:

Line 624: aso_debug_pub.ADD ('Copy_Template - Header and Lines' , 1, 'N' );

620: -- API body
621: --
622:
623: IF aso_debug_pub.g_debug_flag = 'Y' THEN
624: aso_debug_pub.ADD ('Copy_Template - Header and Lines' , 1, 'N' );
625: END IF;
626:
627:
628: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows ( p_qte_header_id );

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

685: l_qte_line_tbl( i ).ATTRIBUTE18 := Null;
686: l_qte_line_tbl( i ).ATTRIBUTE19 := Null;
687: l_qte_line_tbl( i ).ATTRIBUTE20 := Null;
688:
689: IF aso_debug_pub.g_debug_flag = 'Y' THEN
690: aso_debug_pub.ADD ( 'qte line id = ' || l_qte_line_id, 1, 'N' );
691: aso_debug_pub.ADD ( 'i = ' || i, 1, 'N' );
692: aso_debug_pub.ADD ( 'item_type_code = ' || l_qte_line_tbl ( i ).item_type_code , 1 , 'N' );
693: aso_debug_pub.ADD ( 'l_copy_flag ='||l_copy_flag);

Line 690: aso_debug_pub.ADD ( 'qte line id = ' || l_qte_line_id, 1, 'N' );

686: l_qte_line_tbl( i ).ATTRIBUTE19 := Null;
687: l_qte_line_tbl( i ).ATTRIBUTE20 := Null;
688:
689: IF aso_debug_pub.g_debug_flag = 'Y' THEN
690: aso_debug_pub.ADD ( 'qte line id = ' || l_qte_line_id, 1, 'N' );
691: aso_debug_pub.ADD ( 'i = ' || i, 1, 'N' );
692: aso_debug_pub.ADD ( 'item_type_code = ' || l_qte_line_tbl ( i ).item_type_code , 1 , 'N' );
693: aso_debug_pub.ADD ( 'l_copy_flag ='||l_copy_flag);
694: END IF;

Line 691: aso_debug_pub.ADD ( 'i = ' || i, 1, 'N' );

687: l_qte_line_tbl( i ).ATTRIBUTE20 := Null;
688:
689: IF aso_debug_pub.g_debug_flag = 'Y' THEN
690: aso_debug_pub.ADD ( 'qte line id = ' || l_qte_line_id, 1, 'N' );
691: aso_debug_pub.ADD ( 'i = ' || i, 1, 'N' );
692: aso_debug_pub.ADD ( 'item_type_code = ' || l_qte_line_tbl ( i ).item_type_code , 1 , 'N' );
693: aso_debug_pub.ADD ( 'l_copy_flag ='||l_copy_flag);
694: END IF;
695:

Line 692: aso_debug_pub.ADD ( 'item_type_code = ' || l_qte_line_tbl ( i ).item_type_code , 1 , 'N' );

688:
689: IF aso_debug_pub.g_debug_flag = 'Y' THEN
690: aso_debug_pub.ADD ( 'qte line id = ' || l_qte_line_id, 1, 'N' );
691: aso_debug_pub.ADD ( 'i = ' || i, 1, 'N' );
692: aso_debug_pub.ADD ( 'item_type_code = ' || l_qte_line_tbl ( i ).item_type_code , 1 , 'N' );
693: aso_debug_pub.ADD ( 'l_copy_flag ='||l_copy_flag);
694: END IF;
695:
696:

Line 693: aso_debug_pub.ADD ( 'l_copy_flag ='||l_copy_flag);

689: IF aso_debug_pub.g_debug_flag = 'Y' THEN
690: aso_debug_pub.ADD ( 'qte line id = ' || l_qte_line_id, 1, 'N' );
691: aso_debug_pub.ADD ( 'i = ' || i, 1, 'N' );
692: aso_debug_pub.ADD ( 'item_type_code = ' || l_qte_line_tbl ( i ).item_type_code , 1 , 'N' );
693: aso_debug_pub.ADD ( 'l_copy_flag ='||l_copy_flag);
694: END IF;
695:
696:
697:

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

705:
706: IF ( l_qte_line_dtl_tbl(1).RETURN_REF_TYPE = 'SALES ORDER' AND l_qte_line_dtl_tbl(1).RETURN_REF_LINE_ID IS NOT NULL AND
707: l_qte_line_dtl_tbl(1).INSTANCE_ID IS NOT NULL ) OR ( l_qte_line_dtl_tbl(1).REF_TYPE_CODE = 'TOP_MODEL' ) THEN
708: l_copy_flag:='F';
709: IF aso_debug_pub.g_debug_flag = 'Y' THEN
710: aso_debug_pub.ADD ('Install Base Check Failed' , 1, 'N' );
711: END IF;
712:
713: end if;

Line 710: aso_debug_pub.ADD ('Install Base Check Failed' , 1, 'N' );

706: IF ( l_qte_line_dtl_tbl(1).RETURN_REF_TYPE = 'SALES ORDER' AND l_qte_line_dtl_tbl(1).RETURN_REF_LINE_ID IS NOT NULL AND
707: l_qte_line_dtl_tbl(1).INSTANCE_ID IS NOT NULL ) OR ( l_qte_line_dtl_tbl(1).REF_TYPE_CODE = 'TOP_MODEL' ) THEN
708: l_copy_flag:='F';
709: IF aso_debug_pub.g_debug_flag = 'Y' THEN
710: aso_debug_pub.ADD ('Install Base Check Failed' , 1, 'N' );
711: END IF;
712:
713: end if;
714: end if; -- end "RETURN"

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

717: -- for Trade in
718: IF (l_qte_line_tbl(i).item_type_code = 'STD' ) and ( l_qte_line_tbl(i).line_category_code = 'RETURN' )THEN
719: if (l_qte_line_dtl_tbl(1).INSTANCE_ID IS NOT NULL) then
720: l_copy_flag:='F';
721: IF aso_debug_pub.g_debug_flag = 'Y' THEN
722: aso_debug_pub.ADD ('Trade in from install Base Check Failed' , 1, 'N' );
723: END IF;
724: end if;
725: end if; -- Trade in

Line 722: aso_debug_pub.ADD ('Trade in from install Base Check Failed' , 1, 'N' );

718: IF (l_qte_line_tbl(i).item_type_code = 'STD' ) and ( l_qte_line_tbl(i).line_category_code = 'RETURN' )THEN
719: if (l_qte_line_dtl_tbl(1).INSTANCE_ID IS NOT NULL) then
720: l_copy_flag:='F';
721: IF aso_debug_pub.g_debug_flag = 'Y' THEN
722: aso_debug_pub.ADD ('Trade in from install Base Check Failed' , 1, 'N' );
723: END IF;
724: end if;
725: end if; -- Trade in
726:

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

743: l_ato_model := fnd_api.g_true;
744: end if;
745:
746:
747: IF aso_debug_pub.g_debug_flag = 'Y' THEN
748: aso_debug_pub.ADD ( 'Before Calling ASO_CGF_INT.Copy Configuration' , 1 , 'N' );
749: END IF;
750:
751: ASO_CFG_INT.Copy_Configuration (

Line 748: aso_debug_pub.ADD ( 'Before Calling ASO_CGF_INT.Copy Configuration' , 1 , 'N' );

744: end if;
745:
746:
747: IF aso_debug_pub.g_debug_flag = 'Y' THEN
748: aso_debug_pub.ADD ( 'Before Calling ASO_CGF_INT.Copy Configuration' , 1 , 'N' );
749: END IF;
750:
751: ASO_CFG_INT.Copy_Configuration (
752: P_Api_version_NUmber => 1.0

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

762: , x_msg_data => x_msg_data
763: , p_autonomous_flag => FND_API.G_FALSE
764: );
765:
766: IF aso_debug_pub.g_debug_flag = 'Y' THEN
767: aso_debug_pub.ADD ( 'After Calling ASO_CGF_INT.Copy Configuration' , 1 , 'N' );
768: END IF;
769:
770: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 767: aso_debug_pub.ADD ( 'After Calling ASO_CGF_INT.Copy Configuration' , 1 , 'N' );

763: , p_autonomous_flag => FND_API.G_FALSE
764: );
765:
766: IF aso_debug_pub.g_debug_flag = 'Y' THEN
767: aso_debug_pub.ADD ( 'After Calling ASO_CGF_INT.Copy Configuration' , 1 , 'N' );
768: END IF;
769:
770: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
771: l_old_config_header_id :=

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

789:
790: l_serviceable_product_flag := l_qte_line_tbl ( i ).SERVICEABLE_PRODUCT_FLAG;
791: l_service_item_flag := l_qte_line_tbl ( i ).service_item_flag;
792:
793: IF aso_debug_pub.g_debug_flag = 'Y' THEN
794: aso_debug_pub.ADD ( 'service item flag = ' || l_service_item_flag , 1 , 'N' );
795: aso_debug_pub.ADD ( 'serviceable_product_flag = ' || l_serviceable_product_flag , 1 , 'N' );
796: END IF;
797:

Line 794: aso_debug_pub.ADD ( 'service item flag = ' || l_service_item_flag , 1 , 'N' );

790: l_serviceable_product_flag := l_qte_line_tbl ( i ).SERVICEABLE_PRODUCT_FLAG;
791: l_service_item_flag := l_qte_line_tbl ( i ).service_item_flag;
792:
793: IF aso_debug_pub.g_debug_flag = 'Y' THEN
794: aso_debug_pub.ADD ( 'service item flag = ' || l_service_item_flag , 1 , 'N' );
795: aso_debug_pub.ADD ( 'serviceable_product_flag = ' || l_serviceable_product_flag , 1 , 'N' );
796: END IF;
797:
798:

Line 795: aso_debug_pub.ADD ( 'serviceable_product_flag = ' || l_serviceable_product_flag , 1 , 'N' );

791: l_service_item_flag := l_qte_line_tbl ( i ).service_item_flag;
792:
793: IF aso_debug_pub.g_debug_flag = 'Y' THEN
794: aso_debug_pub.ADD ( 'service item flag = ' || l_service_item_flag , 1 , 'N' );
795: aso_debug_pub.ADD ( 'serviceable_product_flag = ' || l_serviceable_product_flag , 1 , 'N' );
796: END IF;
797:
798:
799:

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

808: l_copy_flag := 'F';
809: end if;
810: END IF;
811:
812: IF aso_debug_pub.g_debug_flag = 'Y' THEN
813: aso_debug_pub.ADD ( 'service item flag 2= ' || l_service_item_flag , 1 , 'N' );
814: END IF;
815:
816:

Line 813: aso_debug_pub.ADD ( 'service item flag 2= ' || l_service_item_flag , 1 , 'N' );

809: end if;
810: END IF;
811:
812: IF aso_debug_pub.g_debug_flag = 'Y' THEN
813: aso_debug_pub.ADD ( 'service item flag 2= ' || l_service_item_flag , 1 , 'N' );
814: END IF;
815:
816:
817:

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

887:
888:
889:
890:
891: IF aso_debug_pub.g_debug_flag = 'Y' THEN
892: aso_debug_pub.ADD ( 'Copy_Line_Rows - Before insert_quote_line_rows: ' || l_qte_line_id , 1 , 'Y' );
893: END IF;
894:
895:

Line 892: aso_debug_pub.ADD ( 'Copy_Line_Rows - Before insert_quote_line_rows: ' || l_qte_line_id , 1 , 'Y' );

888:
889:
890:
891: IF aso_debug_pub.g_debug_flag = 'Y' THEN
892: aso_debug_pub.ADD ( 'Copy_Line_Rows - Before insert_quote_line_rows: ' || l_qte_line_id , 1 , 'Y' );
893: END IF;
894:
895:
896:

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

950: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
951: x_return_status := FND_API.G_RET_STS_ERROR;
952: RAISE FND_API.G_EXC_ERROR;
953: END IF;
954: IF aso_debug_pub.g_debug_flag = 'Y' THEN
955: aso_debug_pub.ADD ( 'Copy_Template - After insert_quote_line_rows - status: ' || l_return_status , 1 , 'Y' );
956: END IF;
957:
958: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 955: aso_debug_pub.ADD ( 'Copy_Template - After insert_quote_line_rows - status: ' || l_return_status , 1 , 'Y' );

951: x_return_status := FND_API.G_RET_STS_ERROR;
952: RAISE FND_API.G_EXC_ERROR;
953: END IF;
954: IF aso_debug_pub.g_debug_flag = 'Y' THEN
955: aso_debug_pub.ADD ( 'Copy_Template - After insert_quote_line_rows - status: ' || l_return_status , 1 , 'Y' );
956: END IF;
957:
958: IF aso_debug_pub.g_debug_flag = 'Y' THEN
959: aso_debug_pub.ADD ( 'Copy_Template - Updating the top model and ato line id for the top model line ', 1 , 'Y' );

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

954: IF aso_debug_pub.g_debug_flag = 'Y' THEN
955: aso_debug_pub.ADD ( 'Copy_Template - After insert_quote_line_rows - status: ' || l_return_status , 1 , 'Y' );
956: END IF;
957:
958: IF aso_debug_pub.g_debug_flag = 'Y' THEN
959: aso_debug_pub.ADD ( 'Copy_Template - Updating the top model and ato line id for the top model line ', 1 , 'Y' );
960: aso_debug_pub.ADD ( 'Copy_Template - l_ato_model: ' || l_ato_model , 1 , 'Y' );
961: END IF;
962: update aso_quote_line_details

Line 959: aso_debug_pub.ADD ( 'Copy_Template - Updating the top model and ato line id for the top model line ', 1 , 'Y' );

955: aso_debug_pub.ADD ( 'Copy_Template - After insert_quote_line_rows - status: ' || l_return_status , 1 , 'Y' );
956: END IF;
957:
958: IF aso_debug_pub.g_debug_flag = 'Y' THEN
959: aso_debug_pub.ADD ( 'Copy_Template - Updating the top model and ato line id for the top model line ', 1 , 'Y' );
960: aso_debug_pub.ADD ( 'Copy_Template - l_ato_model: ' || l_ato_model , 1 , 'Y' );
961: END IF;
962: update aso_quote_line_details
963: set top_model_line_id = lx_qte_line_rec.quote_line_id,

Line 960: aso_debug_pub.ADD ( 'Copy_Template - l_ato_model: ' || l_ato_model , 1 , 'Y' );

956: END IF;
957:
958: IF aso_debug_pub.g_debug_flag = 'Y' THEN
959: aso_debug_pub.ADD ( 'Copy_Template - Updating the top model and ato line id for the top model line ', 1 , 'Y' );
960: aso_debug_pub.ADD ( 'Copy_Template - l_ato_model: ' || l_ato_model , 1 , 'Y' );
961: END IF;
962: update aso_quote_line_details
963: set top_model_line_id = lx_qte_line_rec.quote_line_id,
964: ato_line_id = decode(l_ato_model,fnd_api.g_true,lx_qte_line_rec.quote_line_id,null)

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

966:
967:
968: l_line_index_link_tbl ( l_qte_line_id ) :=
969: lx_qte_line_rec.quote_line_id;
970: IF aso_debug_pub.g_debug_flag = 'Y' THEN
971: aso_debug_pub.ADD ( 'Copy_Config - l_qte_line_tbl(i).item_type_code ' || l_qte_line_tbl ( i ).item_type_code , 1 , 'Y' );
972: aso_debug_pub.ADD ( 'Copy - l_qte_line_tbl(i).inventory_item_id ' || l_qte_line_tbl ( i ).inventory_item_id , 1 , 'Y' );
973: aso_debug_pub.ADD ( 'Copy - l_serviceable_product_flag ' || l_serviceable_product_flag , 1 , 'Y' );
974: END IF;

Line 971: aso_debug_pub.ADD ( 'Copy_Config - l_qte_line_tbl(i).item_type_code ' || l_qte_line_tbl ( i ).item_type_code , 1 , 'Y' );

967:
968: l_line_index_link_tbl ( l_qte_line_id ) :=
969: lx_qte_line_rec.quote_line_id;
970: IF aso_debug_pub.g_debug_flag = 'Y' THEN
971: aso_debug_pub.ADD ( 'Copy_Config - l_qte_line_tbl(i).item_type_code ' || l_qte_line_tbl ( i ).item_type_code , 1 , 'Y' );
972: aso_debug_pub.ADD ( 'Copy - l_qte_line_tbl(i).inventory_item_id ' || l_qte_line_tbl ( i ).inventory_item_id , 1 , 'Y' );
973: aso_debug_pub.ADD ( 'Copy - l_serviceable_product_flag ' || l_serviceable_product_flag , 1 , 'Y' );
974: END IF;
975:

Line 972: aso_debug_pub.ADD ( 'Copy - l_qte_line_tbl(i).inventory_item_id ' || l_qte_line_tbl ( i ).inventory_item_id , 1 , 'Y' );

968: l_line_index_link_tbl ( l_qte_line_id ) :=
969: lx_qte_line_rec.quote_line_id;
970: IF aso_debug_pub.g_debug_flag = 'Y' THEN
971: aso_debug_pub.ADD ( 'Copy_Config - l_qte_line_tbl(i).item_type_code ' || l_qte_line_tbl ( i ).item_type_code , 1 , 'Y' );
972: aso_debug_pub.ADD ( 'Copy - l_qte_line_tbl(i).inventory_item_id ' || l_qte_line_tbl ( i ).inventory_item_id , 1 , 'Y' );
973: aso_debug_pub.ADD ( 'Copy - l_serviceable_product_flag ' || l_serviceable_product_flag , 1 , 'Y' );
974: END IF;
975:
976:

Line 973: aso_debug_pub.ADD ( 'Copy - l_serviceable_product_flag ' || l_serviceable_product_flag , 1 , 'Y' );

969: lx_qte_line_rec.quote_line_id;
970: IF aso_debug_pub.g_debug_flag = 'Y' THEN
971: aso_debug_pub.ADD ( 'Copy_Config - l_qte_line_tbl(i).item_type_code ' || l_qte_line_tbl ( i ).item_type_code , 1 , 'Y' );
972: aso_debug_pub.ADD ( 'Copy - l_qte_line_tbl(i).inventory_item_id ' || l_qte_line_tbl ( i ).inventory_item_id , 1 , 'Y' );
973: aso_debug_pub.ADD ( 'Copy - l_serviceable_product_flag ' || l_serviceable_product_flag , 1 , 'Y' );
974: END IF;
975:
976:
977: -- code for copying service

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

977: -- code for copying service
978:
979: IF (l_serviceable_product_flag = 'Y' ) and (l_copy_flag='T') THEN
980:
981: IF aso_debug_pub.g_debug_flag = 'Y' THEN
982: aso_debug_pub.ADD ( 'Before Calling Service Copy ' , 1 , 'N' );
983: END IF;
984:
985: Copy_Tmpl_Service (

Line 982: aso_debug_pub.ADD ( 'Before Calling Service Copy ' , 1 , 'N' );

978:
979: IF (l_serviceable_product_flag = 'Y' ) and (l_copy_flag='T') THEN
980:
981: IF aso_debug_pub.g_debug_flag = 'Y' THEN
982: aso_debug_pub.ADD ( 'Before Calling Service Copy ' , 1 , 'N' );
983: END IF;
984:
985: Copy_Tmpl_Service (
986: p_qte_line_id => l_qte_line_id

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

993: );
994:
995:
996:
997: IF aso_debug_pub.g_debug_flag = 'Y' THEN
998: aso_debug_pub.ADD ( ' After Calling Service Copy' , 1 , 'N' );
999: END IF;
1000:
1001:

Line 998: aso_debug_pub.ADD ( ' After Calling Service Copy' , 1 , 'N' );

994:
995:
996:
997: IF aso_debug_pub.g_debug_flag = 'Y' THEN
998: aso_debug_pub.ADD ( ' After Calling Service Copy' , 1 , 'N' );
999: END IF;
1000:
1001:
1002: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

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

1032: l_config_rev_nbr;
1033: END LOOP;
1034: END IF;
1035:
1036: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1037: aso_debug_pub.ADD ( 'l_old_config_header_id = ' || l_old_config_header_id , 1 , 'N' );
1038: aso_debug_pub.ADD ( ' Before Calling Tmpl Quote Config Copy' , 1 , 'N' );
1039: END IF;
1040:

Line 1037: aso_debug_pub.ADD ( 'l_old_config_header_id = ' || l_old_config_header_id , 1 , 'N' );

1033: END LOOP;
1034: END IF;
1035:
1036: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1037: aso_debug_pub.ADD ( 'l_old_config_header_id = ' || l_old_config_header_id , 1 , 'N' );
1038: aso_debug_pub.ADD ( ' Before Calling Tmpl Quote Config Copy' , 1 , 'N' );
1039: END IF;
1040:
1041: Config_Copy_Tmpl (

Line 1038: aso_debug_pub.ADD ( ' Before Calling Tmpl Quote Config Copy' , 1 , 'N' );

1034: END IF;
1035:
1036: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1037: aso_debug_pub.ADD ( 'l_old_config_header_id = ' || l_old_config_header_id , 1 , 'N' );
1038: aso_debug_pub.ADD ( ' Before Calling Tmpl Quote Config Copy' , 1 , 'N' );
1039: END IF;
1040:
1041: Config_Copy_Tmpl (
1042: p_old_config_header_id => l_old_config_header_id

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

1051: , X_Msg_Count => x_msg_count
1052: , X_Msg_Data => x_msg_data
1053: );
1054:
1055: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1056: aso_debug_pub.ADD ( ' After Calling Copy Tmp Config Copy' , 1 , 'N' );
1057: END IF;
1058:
1059:

Line 1056: aso_debug_pub.ADD ( ' After Calling Copy Tmp Config Copy' , 1 , 'N' );

1052: , X_Msg_Data => x_msg_data
1053: );
1054:
1055: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1056: aso_debug_pub.ADD ( ' After Calling Copy Tmp Config Copy' , 1 , 'N' );
1057: END IF;
1058:
1059:
1060: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

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

1076: /* bug 1903605*/
1077:
1078: IF (l_orig_item_id_tbl IS NOT NULL) AND (l_new_item_id_tbl IS NOT NULL) THEN
1079:
1080: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1081: aso_debug_pub.ADD ( 'item_id_count > 0 ', 1 , 'N' );
1082: aso_debug_pub.ADD ( 'Orig Tbl Count ' ||l_orig_item_id_tbl.count, 1 , 'N' );
1083: aso_debug_pub.ADD ( 'New Tbl Count '||l_new_item_id_tbl.count, 1 , 'N' );
1084:

Line 1081: aso_debug_pub.ADD ( 'item_id_count > 0 ', 1 , 'N' );

1077:
1078: IF (l_orig_item_id_tbl IS NOT NULL) AND (l_new_item_id_tbl IS NOT NULL) THEN
1079:
1080: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1081: aso_debug_pub.ADD ( 'item_id_count > 0 ', 1 , 'N' );
1082: aso_debug_pub.ADD ( 'Orig Tbl Count ' ||l_orig_item_id_tbl.count, 1 , 'N' );
1083: aso_debug_pub.ADD ( 'New Tbl Count '||l_new_item_id_tbl.count, 1 , 'N' );
1084:
1085: END IF;

Line 1082: aso_debug_pub.ADD ( 'Orig Tbl Count ' ||l_orig_item_id_tbl.count, 1 , 'N' );

1078: IF (l_orig_item_id_tbl IS NOT NULL) AND (l_new_item_id_tbl IS NOT NULL) THEN
1079:
1080: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1081: aso_debug_pub.ADD ( 'item_id_count > 0 ', 1 , 'N' );
1082: aso_debug_pub.ADD ( 'Orig Tbl Count ' ||l_orig_item_id_tbl.count, 1 , 'N' );
1083: aso_debug_pub.ADD ( 'New Tbl Count '||l_new_item_id_tbl.count, 1 , 'N' );
1084:
1085: END IF;
1086:

Line 1083: aso_debug_pub.ADD ( 'New Tbl Count '||l_new_item_id_tbl.count, 1 , 'N' );

1079:
1080: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1081: aso_debug_pub.ADD ( 'item_id_count > 0 ', 1 , 'N' );
1082: aso_debug_pub.ADD ( 'Orig Tbl Count ' ||l_orig_item_id_tbl.count, 1 , 'N' );
1083: aso_debug_pub.ADD ( 'New Tbl Count '||l_new_item_id_tbl.count, 1 , 'N' );
1084:
1085: END IF;
1086:
1087: IF l_orig_item_id_tbl.count > 0 AND l_new_item_id_tbl.count > 0 THEN

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

1140:
1141:
1142:
1143:
1144: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1145: aso_debug_pub.ADD ( ' End Copy template Lines API ', 1 , 'N' );
1146: END IF;
1147:
1148: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1145: aso_debug_pub.ADD ( ' End Copy template Lines API ', 1 , 'N' );

1141:
1142:
1143:
1144: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1145: aso_debug_pub.ADD ( ' End Copy template Lines API ', 1 , 'N' );
1146: END IF;
1147:
1148: x_return_status := FND_API.G_RET_STS_SUCCESS;
1149:

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

1276:
1277:
1278: BEGIN
1279:
1280: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1281: aso_debug_pub.ADD ('Copy_Tmpl_Service - Begin ' , 1, 'Y' );
1282: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_new_qte_header_id ' || p_new_qte_header_id , 1 , 'Y' );
1283: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_qte_header_id ' || p_qte_header_id , 1 , 'Y' );
1284: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_qte_line_id ' || p_qte_line_id , 1 , 'Y' );

Line 1281: aso_debug_pub.ADD ('Copy_Tmpl_Service - Begin ' , 1, 'Y' );

1277:
1278: BEGIN
1279:
1280: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1281: aso_debug_pub.ADD ('Copy_Tmpl_Service - Begin ' , 1, 'Y' );
1282: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_new_qte_header_id ' || p_new_qte_header_id , 1 , 'Y' );
1283: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_qte_header_id ' || p_qte_header_id , 1 , 'Y' );
1284: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_qte_line_id ' || p_qte_line_id , 1 , 'Y' );
1285: END IF;

Line 1282: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_new_qte_header_id ' || p_new_qte_header_id , 1 , 'Y' );

1278: BEGIN
1279:
1280: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1281: aso_debug_pub.ADD ('Copy_Tmpl_Service - Begin ' , 1, 'Y' );
1282: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_new_qte_header_id ' || p_new_qte_header_id , 1 , 'Y' );
1283: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_qte_header_id ' || p_qte_header_id , 1 , 'Y' );
1284: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_qte_line_id ' || p_qte_line_id , 1 , 'Y' );
1285: END IF;
1286:

Line 1283: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_qte_header_id ' || p_qte_header_id , 1 , 'Y' );

1279:
1280: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1281: aso_debug_pub.ADD ('Copy_Tmpl_Service - Begin ' , 1, 'Y' );
1282: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_new_qte_header_id ' || p_new_qte_header_id , 1 , 'Y' );
1283: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_qte_header_id ' || p_qte_header_id , 1 , 'Y' );
1284: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_qte_line_id ' || p_qte_line_id , 1 , 'Y' );
1285: END IF;
1286:
1287: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1284: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_qte_line_id ' || p_qte_line_id , 1 , 'Y' );

1280: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1281: aso_debug_pub.ADD ('Copy_Tmpl_Service - Begin ' , 1, 'Y' );
1282: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_new_qte_header_id ' || p_new_qte_header_id , 1 , 'Y' );
1283: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_qte_header_id ' || p_qte_header_id , 1 , 'Y' );
1284: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - p_qte_line_id ' || p_qte_line_id , 1 , 'Y' );
1285: END IF;
1286:
1287: x_return_status := FND_API.G_RET_STS_SUCCESS;
1288:

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

1290:
1291: LOOP
1292: FETCH line_id_from_service INTO qte_line_id;
1293: EXIT WHEN line_id_from_service%NOTFOUND;
1294: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1295: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - inside cursor qte_line_id ' || qte_line_id , 1 , 'Y' );
1296: END IF;
1297:
1298: l_qte_line_rec :=

Line 1295: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - inside cursor qte_line_id ' || qte_line_id , 1 , 'Y' );

1291: LOOP
1292: FETCH line_id_from_service INTO qte_line_id;
1293: EXIT WHEN line_id_from_service%NOTFOUND;
1294: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1295: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - inside cursor qte_line_id ' || qte_line_id , 1 , 'Y' );
1296: END IF;
1297:
1298: l_qte_line_rec :=
1299: ASO_UTILITY_PVT.Query_Qte_Line_Row ( qte_line_id );

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

1321: IF l_qte_line_dtl_tbl ( k ).service_ref_type_code = 'QUOTE' THEN
1322:
1323: IF l_qte_line_dtl_tbl ( k ).service_ref_line_id IS NOT NULL THEN
1324:
1325: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1326: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - l_qte_line_dtl_tbl(k).service_ref_line_id ' || l_qte_line_dtl_tbl ( k ).service_ref_line_id , 1 , 'Y' );
1327: END IF;
1328: l_service_ref_line_id :=
1329: lx_line_index_link_tbl ( l_qte_line_dtl_tbl ( k ).service_ref_line_id );

Line 1326: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - l_qte_line_dtl_tbl(k).service_ref_line_id ' || l_qte_line_dtl_tbl ( k ).service_ref_line_id , 1 , 'Y' );

1322:
1323: IF l_qte_line_dtl_tbl ( k ).service_ref_line_id IS NOT NULL THEN
1324:
1325: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1326: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - l_qte_line_dtl_tbl(k).service_ref_line_id ' || l_qte_line_dtl_tbl ( k ).service_ref_line_id , 1 , 'Y' );
1327: END IF;
1328: l_service_ref_line_id :=
1329: lx_line_index_link_tbl ( l_qte_line_dtl_tbl ( k ).service_ref_line_id );
1330: l_qte_line_dtl_tbl ( k ).service_ref_line_id :=

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

1336: END LOOP;
1337:
1338: END IF;
1339:
1340: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1341: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - 2 l_service_ref_line_id ' || l_service_ref_line_id , 1 , 'Y' );
1342: END IF;
1343:
1344: --l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( qte_line_id );

Line 1341: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - 2 l_service_ref_line_id ' || l_service_ref_line_id , 1 , 'Y' );

1337:
1338: END IF;
1339:
1340: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1341: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - 2 l_service_ref_line_id ' || l_service_ref_line_id , 1 , 'Y' );
1342: END IF;
1343:
1344: --l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( qte_line_id );
1345:

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

1477: */
1478:
1479: --End of BC4J Fix
1480:
1481: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1482: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - Before insert_quote_line_rows: ' || p_qte_line_id , 1 , 'Y' );
1483: END IF;
1484: ASO_QUOTE_LINES_PVT.Insert_Quote_Line_Rows (
1485: p_control_rec => l_control_rec

Line 1482: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - Before insert_quote_line_rows: ' || p_qte_line_id , 1 , 'Y' );

1478:
1479: --End of BC4J Fix
1480:
1481: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1482: aso_debug_pub.ADD ( 'Copy_Tmpl_Service - Before insert_quote_line_rows: ' || p_qte_line_id , 1 , 'Y' );
1483: END IF;
1484: ASO_QUOTE_LINES_PVT.Insert_Quote_Line_Rows (
1485: p_control_rec => l_control_rec
1486: , P_qte_Line_Rec => l_qte_line_rec

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

1659:
1660:
1661: BEGIN
1662:
1663: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1664: aso_debug_pub.ADD ('Copy_Config_Tmpl - Begin ' , 1, 'Y' );
1665: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - p_new_qte_header_id ' || p_new_qte_header_id , 1 , 'Y' );
1666: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - p_qte_header_id ' || p_qte_header_id , 1 , 'Y' );
1667: END IF;

Line 1664: aso_debug_pub.ADD ('Copy_Config_Tmpl - Begin ' , 1, 'Y' );

1660:
1661: BEGIN
1662:
1663: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1664: aso_debug_pub.ADD ('Copy_Config_Tmpl - Begin ' , 1, 'Y' );
1665: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - p_new_qte_header_id ' || p_new_qte_header_id , 1 , 'Y' );
1666: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - p_qte_header_id ' || p_qte_header_id , 1 , 'Y' );
1667: END IF;
1668:

Line 1665: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - p_new_qte_header_id ' || p_new_qte_header_id , 1 , 'Y' );

1661: BEGIN
1662:
1663: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1664: aso_debug_pub.ADD ('Copy_Config_Tmpl - Begin ' , 1, 'Y' );
1665: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - p_new_qte_header_id ' || p_new_qte_header_id , 1 , 'Y' );
1666: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - p_qte_header_id ' || p_qte_header_id , 1 , 'Y' );
1667: END IF;
1668:
1669: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1666: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - p_qte_header_id ' || p_qte_header_id , 1 , 'Y' );

1662:
1663: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1664: aso_debug_pub.ADD ('Copy_Config_Tmpl - Begin ' , 1, 'Y' );
1665: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - p_new_qte_header_id ' || p_new_qte_header_id , 1 , 'Y' );
1666: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - p_qte_header_id ' || p_qte_header_id , 1 , 'Y' );
1667: END IF;
1668:
1669: x_return_status := FND_API.G_RET_STS_SUCCESS;
1670:

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

1675: );
1676: LOOP
1677: FETCH line_id_from_config INTO qte_line_id;
1678: EXIT WHEN line_id_from_config%NOTFOUND;
1679: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1680: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - inside cursor qte_line_id ' || qte_line_id , 1 , 'Y' );
1681: END IF;
1682:
1683: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( qte_line_id );

Line 1680: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - inside cursor qte_line_id ' || qte_line_id , 1 , 'Y' );

1676: LOOP
1677: FETCH line_id_from_config INTO qte_line_id;
1678: EXIT WHEN line_id_from_config%NOTFOUND;
1679: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1680: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - inside cursor qte_line_id ' || qte_line_id , 1 , 'Y' );
1681: END IF;
1682:
1683: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( qte_line_id );
1684:

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

1696: OPEN get_qte_line_number(lx_line_index_link_tbl(l_old_quote_line_id));
1697: FETCH get_qte_line_number into l_line_number;
1698: CLOSE get_qte_line_number;
1699:
1700: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1701: aso_debug_pub.ADD ( 'Line Number -- ' || l_line_number , 1 , 'Y' );
1702: END IF;
1703:
1704:

Line 1701: aso_debug_pub.ADD ( 'Line Number -- ' || l_line_number , 1 , 'Y' );

1697: FETCH get_qte_line_number into l_line_number;
1698: CLOSE get_qte_line_number;
1699:
1700: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1701: aso_debug_pub.ADD ( 'Line Number -- ' || l_line_number , 1 , 'Y' );
1702: END IF;
1703:
1704:
1705: l_qte_line_rec.line_number := l_line_number;

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

1742: OPEN C_Serviceable_Product ( l_qte_line_rec.organization_id , l_qte_line_rec.inventory_item_id );
1743: FETCH C_Serviceable_Product INTO l_serviceable_product_flag;
1744: CLOSE C_Serviceable_Product;
1745:
1746: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1747: aso_debug_pub.ADD ('Copy_Config_Tmpl - After querying all the records for the line ' , 1, 'Y' );
1748: END IF;
1749:
1750: FOR j IN 1 .. l_qte_line_dtl_tbl.COUNT LOOP

Line 1747: aso_debug_pub.ADD ('Copy_Config_Tmpl - After querying all the records for the line ' , 1, 'Y' );

1743: FETCH C_Serviceable_Product INTO l_serviceable_product_flag;
1744: CLOSE C_Serviceable_Product;
1745:
1746: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1747: aso_debug_pub.ADD ('Copy_Config_Tmpl - After querying all the records for the line ' , 1, 'Y' );
1748: END IF;
1749:
1750: FOR j IN 1 .. l_qte_line_dtl_tbl.COUNT LOOP
1751:

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

1748: END IF;
1749:
1750: FOR j IN 1 .. l_qte_line_dtl_tbl.COUNT LOOP
1751:
1752: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1753: aso_debug_pub.ADD ('Copy_Config_Tmpl - l_qte_line_dtl_tbl('||j||')ref_line_id: '||l_qte_line_dtl_tbl(j).ref_line_id , 1, 'Y' );
1754: aso_debug_pub.ADD ('Copy_Config_Tmpl - l_qte_line_dtl_tbl('||j||')top_model_line_id: '||l_qte_line_dtl_tbl(j).top_model_line_id , 1, 'Y' );
1755: aso_debug_pub.ADD ('Copy_Config_Tmpl - l_qte_line_dtl_tbl('||j||')ato_line_id: '||l_qte_line_dtl_tbl(j).ato_line_id , 1, 'Y' );
1756: END IF;

Line 1753: aso_debug_pub.ADD ('Copy_Config_Tmpl - l_qte_line_dtl_tbl('||j||')ref_line_id: '||l_qte_line_dtl_tbl(j).ref_line_id , 1, 'Y' );

1749:
1750: FOR j IN 1 .. l_qte_line_dtl_tbl.COUNT LOOP
1751:
1752: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1753: aso_debug_pub.ADD ('Copy_Config_Tmpl - l_qte_line_dtl_tbl('||j||')ref_line_id: '||l_qte_line_dtl_tbl(j).ref_line_id , 1, 'Y' );
1754: aso_debug_pub.ADD ('Copy_Config_Tmpl - l_qte_line_dtl_tbl('||j||')top_model_line_id: '||l_qte_line_dtl_tbl(j).top_model_line_id , 1, 'Y' );
1755: aso_debug_pub.ADD ('Copy_Config_Tmpl - l_qte_line_dtl_tbl('||j||')ato_line_id: '||l_qte_line_dtl_tbl(j).ato_line_id , 1, 'Y' );
1756: END IF;
1757:

Line 1754: aso_debug_pub.ADD ('Copy_Config_Tmpl - l_qte_line_dtl_tbl('||j||')top_model_line_id: '||l_qte_line_dtl_tbl(j).top_model_line_id , 1, 'Y' );

1750: FOR j IN 1 .. l_qte_line_dtl_tbl.COUNT LOOP
1751:
1752: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1753: aso_debug_pub.ADD ('Copy_Config_Tmpl - l_qte_line_dtl_tbl('||j||')ref_line_id: '||l_qte_line_dtl_tbl(j).ref_line_id , 1, 'Y' );
1754: aso_debug_pub.ADD ('Copy_Config_Tmpl - l_qte_line_dtl_tbl('||j||')top_model_line_id: '||l_qte_line_dtl_tbl(j).top_model_line_id , 1, 'Y' );
1755: aso_debug_pub.ADD ('Copy_Config_Tmpl - l_qte_line_dtl_tbl('||j||')ato_line_id: '||l_qte_line_dtl_tbl(j).ato_line_id , 1, 'Y' );
1756: END IF;
1757:
1758: l_ref_ln_id := lx_line_index_link_tbl ( l_qte_line_dtl_tbl ( j ).ref_line_id );

Line 1755: aso_debug_pub.ADD ('Copy_Config_Tmpl - l_qte_line_dtl_tbl('||j||')ato_line_id: '||l_qte_line_dtl_tbl(j).ato_line_id , 1, 'Y' );

1751:
1752: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1753: aso_debug_pub.ADD ('Copy_Config_Tmpl - l_qte_line_dtl_tbl('||j||')ref_line_id: '||l_qte_line_dtl_tbl(j).ref_line_id , 1, 'Y' );
1754: aso_debug_pub.ADD ('Copy_Config_Tmpl - l_qte_line_dtl_tbl('||j||')top_model_line_id: '||l_qte_line_dtl_tbl(j).top_model_line_id , 1, 'Y' );
1755: aso_debug_pub.ADD ('Copy_Config_Tmpl - l_qte_line_dtl_tbl('||j||')ato_line_id: '||l_qte_line_dtl_tbl(j).ato_line_id , 1, 'Y' );
1756: END IF;
1757:
1758: l_ref_ln_id := lx_line_index_link_tbl ( l_qte_line_dtl_tbl ( j ).ref_line_id );
1759: l_qte_line_dtl_tbl ( j ).ref_line_id := l_ref_ln_id;

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

1888: */
1889:
1890: --End of BC4J Fix
1891:
1892: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1893: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - Before insert_quote_line_rows: ' || l_quote_line_id , 1 , 'Y' );
1894: END IF;
1895: ASO_QUOTE_LINES_PVT.Insert_Quote_Line_Rows (
1896: p_control_rec => l_control_rec

Line 1893: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - Before insert_quote_line_rows: ' || l_quote_line_id , 1 , 'Y' );

1889:
1890: --End of BC4J Fix
1891:
1892: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1893: aso_debug_pub.ADD ( 'Copy_Config_Tmpl - Before insert_quote_line_rows: ' || l_quote_line_id , 1 , 'Y' );
1894: END IF;
1895: ASO_QUOTE_LINES_PVT.Insert_Quote_Line_Rows (
1896: p_control_rec => l_control_rec
1897: , P_qte_Line_Rec => l_qte_line_rec

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

1953: lx_line_index_link_tbl(qte_line_id) := lx_qte_line_rec.quote_line_id;
1954:
1955:
1956:
1957: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1958: aso_debug_pub.ADD('Copy_Config_Tmpl - l_qte_line_tbl(i).item_type_code ' || l_qte_line_rec.item_type_code , 1 , 'Y' );
1959: aso_debug_pub.ADD('Copy - l_qte_line_tbl(i).inventory_item_id ' || l_qte_line_rec.inventory_item_id , 1 , 'Y' );
1960: aso_debug_pub.ADD('Copy - l_serviceable_product_flag ' || l_serviceable_product_flag , 1 , 'Y' );
1961: END IF;

Line 1958: aso_debug_pub.ADD('Copy_Config_Tmpl - l_qte_line_tbl(i).item_type_code ' || l_qte_line_rec.item_type_code , 1 , 'Y' );

1954:
1955:
1956:
1957: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1958: aso_debug_pub.ADD('Copy_Config_Tmpl - l_qte_line_tbl(i).item_type_code ' || l_qte_line_rec.item_type_code , 1 , 'Y' );
1959: aso_debug_pub.ADD('Copy - l_qte_line_tbl(i).inventory_item_id ' || l_qte_line_rec.inventory_item_id , 1 , 'Y' );
1960: aso_debug_pub.ADD('Copy - l_serviceable_product_flag ' || l_serviceable_product_flag , 1 , 'Y' );
1961: END IF;
1962:

Line 1959: aso_debug_pub.ADD('Copy - l_qte_line_tbl(i).inventory_item_id ' || l_qte_line_rec.inventory_item_id , 1 , 'Y' );

1955:
1956:
1957: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1958: aso_debug_pub.ADD('Copy_Config_Tmpl - l_qte_line_tbl(i).item_type_code ' || l_qte_line_rec.item_type_code , 1 , 'Y' );
1959: aso_debug_pub.ADD('Copy - l_qte_line_tbl(i).inventory_item_id ' || l_qte_line_rec.inventory_item_id , 1 , 'Y' );
1960: aso_debug_pub.ADD('Copy - l_serviceable_product_flag ' || l_serviceable_product_flag , 1 , 'Y' );
1961: END IF;
1962:
1963: IF l_serviceable_product_flag = 'Y' THEN

Line 1960: aso_debug_pub.ADD('Copy - l_serviceable_product_flag ' || l_serviceable_product_flag , 1 , 'Y' );

1956:
1957: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1958: aso_debug_pub.ADD('Copy_Config_Tmpl - l_qte_line_tbl(i).item_type_code ' || l_qte_line_rec.item_type_code , 1 , 'Y' );
1959: aso_debug_pub.ADD('Copy - l_qte_line_tbl(i).inventory_item_id ' || l_qte_line_rec.inventory_item_id , 1 , 'Y' );
1960: aso_debug_pub.ADD('Copy - l_serviceable_product_flag ' || l_serviceable_product_flag , 1 , 'Y' );
1961: END IF;
1962:
1963: IF l_serviceable_product_flag = 'Y' THEN
1964: