40:
41: -- Standard Start of API savepoint
42: SAVEPOINT Copy_Quote_PUB;
43:
44: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
45:
46: -- Standard call to check for call compatibility.
47: IF NOT FND_API.Compatible_API_Call ( l_api_version,
48: p_api_version_number,
177:
178: -- Standard Start of API savepoint
179: SAVEPOINT Copy_Line_PUB;
180:
181: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
182:
183: -- Standard call to check for call compatibility.
184: IF NOT FND_API.Compatible_API_Call ( l_api_version,
185: p_api_version_number,
211: END IF;
212: raise FND_API.G_EXC_ERROR;
213: End if;
214:
215: IF aso_debug_pub.g_debug_flag = 'Y' THEN
216: aso_debug_pub.ADD ( ' Calling Copy_Line_Rows API ' , 1 , 'N' );
217: END IF;
218:
219: l_qte_header_rec := P_Qte_Header_Rec;
212: raise FND_API.G_EXC_ERROR;
213: End if;
214:
215: IF aso_debug_pub.g_debug_flag = 'Y' THEN
216: aso_debug_pub.ADD ( ' Calling Copy_Line_Rows API ' , 1 , 'N' );
217: END IF;
218:
219: l_qte_header_rec := P_Qte_Header_Rec;
220:
241: X_Return_Status => X_Return_Status,
242: X_Msg_Count => X_Msg_Count,
243: X_Msg_Data => X_Msg_Data);
244:
245: IF aso_debug_pub.g_debug_flag = 'Y' THEN
246: aso_debug_pub.ADD ( ' After calling Copy_Line_rows API ' , 1 , 'N' );
247: END IF;
248:
249: -- ER 3177722
242: X_Msg_Count => X_Msg_Count,
243: X_Msg_Data => X_Msg_Data);
244:
245: IF aso_debug_pub.g_debug_flag = 'Y' THEN
246: aso_debug_pub.ADD ( ' After calling Copy_Line_rows API ' , 1 , 'N' );
247: END IF;
248:
249: -- ER 3177722
250:
250:
251: if (x_return_status =FND_API.G_RET_STS_SUCCESS) then
252:
253: if l_copy_config_profile='N' then
254: IF aso_debug_pub.g_debug_flag = 'Y' THEN
255: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration l_quote_header_rec: '||P_Qte_Header_Id, 1, 'N');
256: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration X_Qte_Line_Id: '||X_Qte_Line_Id, 1, 'N');
257: end if;
258: select item_type_code into l_item_type_code
251: if (x_return_status =FND_API.G_RET_STS_SUCCESS) then
252:
253: if l_copy_config_profile='N' then
254: IF aso_debug_pub.g_debug_flag = 'Y' THEN
255: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration l_quote_header_rec: '||P_Qte_Header_Id, 1, 'N');
256: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration X_Qte_Line_Id: '||X_Qte_Line_Id, 1, 'N');
257: end if;
258: select item_type_code into l_item_type_code
259: from aso_Quote_lines_all
252:
253: if l_copy_config_profile='N' then
254: IF aso_debug_pub.g_debug_flag = 'Y' THEN
255: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration l_quote_header_rec: '||P_Qte_Header_Id, 1, 'N');
256: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration X_Qte_Line_Id: '||X_Qte_Line_Id, 1, 'N');
257: end if;
258: select item_type_code into l_item_type_code
259: from aso_Quote_lines_all
260: where quote_line_id=X_Qte_Line_Id;
257: end if;
258: select item_type_code into l_item_type_code
259: from aso_Quote_lines_all
260: where quote_line_id=X_Qte_Line_Id;
261: IF aso_debug_pub.g_debug_flag = 'Y' THEN
262: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration l_item_type_code: '||l_item_type_code, 1, 'N');
263: end if;
264:
265: if l_item_type_code='MDL' then
258: select item_type_code into l_item_type_code
259: from aso_Quote_lines_all
260: where quote_line_id=X_Qte_Line_Id;
261: IF aso_debug_pub.g_debug_flag = 'Y' THEN
262: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration l_item_type_code: '||l_item_type_code, 1, 'N');
263: end if;
264:
265: if l_item_type_code='MDL' then
266:
284: commit work;
285: end if;
286: */
287:
288: IF aso_debug_pub.g_debug_flag = 'Y' THEN
289: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration return status: '||x_Return_Status, 1, 'N');
290: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
291: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration x_msg_count: '||x_msg_count, 1, 'N');
292: END IF;
285: end if;
286: */
287:
288: IF aso_debug_pub.g_debug_flag = 'Y' THEN
289: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration return status: '||x_Return_Status, 1, 'N');
290: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
291: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration x_msg_count: '||x_msg_count, 1, 'N');
292: END IF;
293: END IF; -- MDL
286: */
287:
288: IF aso_debug_pub.g_debug_flag = 'Y' THEN
289: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration return status: '||x_Return_Status, 1, 'N');
290: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
291: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration x_msg_count: '||x_msg_count, 1, 'N');
292: END IF;
293: END IF; -- MDL
294: end if; -- profile
287:
288: IF aso_debug_pub.g_debug_flag = 'Y' THEN
289: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration return status: '||x_Return_Status, 1, 'N');
290: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
291: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration x_msg_count: '||x_msg_count, 1, 'N');
292: END IF;
293: END IF; -- MDL
294: end if; -- profile
295: end if; -- in case success