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 FND_API

Line 8: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_CONFIG_OPERATIONS_PVT';
5:
6: PROCEDURE Add_to_Container_from_IB(
7: P_Api_Version_Number IN NUMBER,
8: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
12: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

Line 9: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

5:
6: PROCEDURE Add_to_Container_from_IB(
7: P_Api_Version_Number IN NUMBER,
8: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
12: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
13: P_Quote_line_Id IN NUMBER,

Line 10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

6: PROCEDURE Add_to_Container_from_IB(
7: P_Api_Version_Number IN NUMBER,
8: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
12: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
13: P_Quote_line_Id IN NUMBER,
14: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type,

Line 78: IF NOT FND_API.Compatible_API_Call (

74:
75: SAVEPOINT Add_to_Container_from_ib_pvt;
76:
77: -- Standard call to check for call compatibility.
78: IF NOT FND_API.Compatible_API_Call (
79: l_api_version,
80: p_api_version_Number,
81: l_api_name,
82: G_PKG_NAME )

Line 84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

80: p_api_version_Number,
81: l_api_name,
82: G_PKG_NAME )
83: THEN
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86:
87: -- Initialize message list if p_init_msg_list is set to TRUE.
88: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 88: IF FND_API.to_Boolean( p_init_msg_list ) THEN

84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86:
87: -- Initialize message list if p_init_msg_list is set to TRUE.
88: IF FND_API.to_Boolean( p_init_msg_list ) THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91:
92:

Line 94: x_return_status := FND_API.G_RET_STS_SUCCESS;

90: END IF;
91:
92:
93: -- Initialize API return status to success
94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95:
96: /**************************************************************
97: Create Config Instance header table
98: **************************************************************/

Line 205: IF x_return_status = FND_API.G_RET_STS_ERROR then

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
206: raise FND_API.G_EXC_ERROR;
207: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
208: raise FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;

Line 206: raise FND_API.G_EXC_ERROR;

202:
203: END IF;
204:
205: IF x_return_status = FND_API.G_RET_STS_ERROR then
206: raise FND_API.G_EXC_ERROR;
207: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
208: raise FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210:

Line 207: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

203: END IF;
204:
205: IF x_return_status = FND_API.G_RET_STS_ERROR then
206: raise FND_API.G_EXC_ERROR;
207: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
208: raise FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210:
211: /****************************************************************************

Line 208: raise FND_API.G_EXC_UNEXPECTED_ERROR;

204:
205: IF x_return_status = FND_API.G_RET_STS_ERROR then
206: raise FND_API.G_EXC_ERROR;
207: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
208: raise FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210:
211: /****************************************************************************
212: Get complete configuration and valid configuration info from CZ_CONFIG_HDRS

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221: END IF;
222:
223: IF c_configuration_details_csr%NOTFOUND THEN
224: CLOSE c_configuration_details_csr;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
227: FND_MESSAGE.Set_Name('ASO', 'ASO_CFG_DETAILS_NOT_FOUND');
228: FND_MSG_PUB.Add;
229: END IF;

Line 230: raise FND_API.G_EXC_ERROR;

226: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
227: FND_MESSAGE.Set_Name('ASO', 'ASO_CFG_DETAILS_NOT_FOUND');
228: FND_MSG_PUB.Add;
229: END IF;
230: raise FND_API.G_EXC_ERROR;
231: END IF;
232:
233: Close c_configuration_details_csr;
234:

Line 264: x_return_status := FND_API.G_RET_STS_ERROR;

260: END IF;
261:
262: IF c_last_update_date_csr%NOTFOUND THEN
263: CLOSE c_last_update_date_csr;
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
266: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
267: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
268: FND_MSG_PUB.ADD;

Line 270: raise FND_API.G_EXC_ERROR;

266: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
267: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
268: FND_MSG_PUB.ADD;
269: END IF;
270: raise FND_API.G_EXC_ERROR;
271:
272: END IF;
273:
274: Close c_last_update_date_csr;

Line 282: P_Init_Msg_List => FND_API.g_false,

278: l_QTE_HEADER_REC.last_update_date := l_last_update_date;
279:
280: ASO_CFG_PUB.Get_config_details(
281: P_Api_Version_Number =>1.0,
282: P_Init_Msg_List => FND_API.g_false,
283: p_commit => FND_API.g_false,
284: p_control_rec => p_control_rec,
285: p_config_rec => l_config_rec,
286: p_model_line_rec => l_model_line_rec,

Line 283: p_commit => FND_API.g_false,

279:
280: ASO_CFG_PUB.Get_config_details(
281: P_Api_Version_Number =>1.0,
282: P_Init_Msg_List => FND_API.g_false,
283: p_commit => FND_API.g_false,
284: p_control_rec => p_control_rec,
285: p_config_rec => l_config_rec,
286: p_model_line_rec => l_model_line_rec,
287: p_config_hdr_id => l_config_hdr_id,

Line 301: IF x_return_status = FND_API.G_RET_STS_ERROR 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;
303: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
304: raise FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;

Line 302: raise FND_API.G_EXC_ERROR;

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;
303: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
304: raise FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306:

Line 303: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

299: END IF;
300:
301: IF x_return_status = FND_API.G_RET_STS_ERROR then
302: raise FND_API.G_EXC_ERROR;
303: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
304: raise FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306:
307: x_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_quote_header_id);

Line 304: raise FND_API.G_EXC_UNEXPECTED_ERROR;

300:
301: IF x_return_status = FND_API.G_RET_STS_ERROR then
302: raise FND_API.G_EXC_ERROR;
303: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
304: raise FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306:
307: x_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_quote_header_id);
308:

Line 315: IF FND_API.To_Boolean(p_commit) 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
316: COMMIT WORK;
317: END IF;
318:
319: -- Standard call to get message count and if count is 1, get message info

Line 321: p_encoded => FND_API.G_FALSE,

317: END IF;
318:
319: -- Standard call to get message count and if count is 1, get message info
320: FND_Msg_Pub.Count_And_Get(
321: p_encoded => FND_API.G_FALSE,
322: p_count => x_msg_count ,
323: p_data => x_msg_data
324: );
325:

Line 329: WHEN FND_API.G_EXC_ERROR THEN

325:
326: END LOOP;
327:
328: EXCEPTION
329: WHEN FND_API.G_EXC_ERROR THEN
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
332: P_API_NAME => L_API_NAME
333: ,P_PKG_NAME => G_PKG_NAME

Line 330: x_return_status := FND_API.G_RET_STS_ERROR;

326: END LOOP;
327:
328: EXCEPTION
329: WHEN FND_API.G_EXC_ERROR THEN
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
332: P_API_NAME => L_API_NAME
333: ,P_PKG_NAME => G_PKG_NAME
334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

336: ,X_MSG_COUNT => X_MSG_COUNT
337: ,X_MSG_DATA => X_MSG_DATA
338: ,X_RETURN_STATUS => X_RETURN_STATUS);
339:
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
343: P_API_NAME => L_API_NAME
344: ,P_PKG_NAME => G_PKG_NAME

Line 341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

337: ,X_MSG_DATA => X_MSG_DATA
338: ,X_RETURN_STATUS => X_RETURN_STATUS);
339:
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
343: P_API_NAME => L_API_NAME
344: ,P_PKG_NAME => G_PKG_NAME
345: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

348: ,X_MSG_DATA => X_MSG_DATA
349: ,X_RETURN_STATUS => X_RETURN_STATUS);
350:
351: WHEN OTHERS THEN
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
354: P_API_NAME => L_API_NAME
355: ,P_PKG_NAME => G_PKG_NAME
356: ,P_SQLERRM => sqlerrm

Line 369: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

365:
366:
367: PROCEDURE Reconfigure_from_IB(
368: P_Api_Version_Number IN NUMBER,
369: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
370: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
373: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

Line 370: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

366:
367: PROCEDURE Reconfigure_from_IB(
368: P_Api_Version_Number IN NUMBER,
369: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
370: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
373: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
374: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type,

Line 371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

367: PROCEDURE Reconfigure_from_IB(
368: P_Api_Version_Number IN NUMBER,
369: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
370: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
373: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
374: P_instance_tbl IN ASO_QUOTE_HEADERS_PVT.Instance_Tbl_Type,
375: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 476: IF NOT FND_API.Compatible_API_Call (

472:
473: SAVEPOINT Reconfigure_from_IB_pvt;
474:
475: -- Standard call to check for call compatibility.
476: IF NOT FND_API.Compatible_API_Call (
477: l_api_version,
478: p_api_version_Number,
479: l_api_name,
480: G_PKG_NAME )

Line 482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

478: p_api_version_Number,
479: l_api_name,
480: G_PKG_NAME )
481: THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;
484:
485: -- Initialize message list if p_init_msg_list is set to TRUE.
486: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 486: IF FND_API.to_Boolean( p_init_msg_list ) THEN

482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;
484:
485: -- Initialize message list if p_init_msg_list is set to TRUE.
486: IF FND_API.to_Boolean( p_init_msg_list ) THEN
487: FND_MSG_PUB.initialize;
488: END IF;
489:
490:

Line 492: x_return_status := FND_API.G_RET_STS_SUCCESS;

488: END IF;
489:
490:
491: -- Initialize API return status to success
492: x_return_status := FND_API.G_RET_STS_SUCCESS;
493:
494:
495: /*********************************************************************
496: Create table of Config header Ids

Line 539: IF x_return_status = FND_API.G_RET_STS_ERROR 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;
541: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
542: raise FND_API.G_EXC_UNEXPECTED_ERROR;
543: END IF;

Line 540: raise FND_API.G_EXC_ERROR;

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;
541: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
542: raise FND_API.G_EXC_UNEXPECTED_ERROR;
543: END IF;
544:

Line 541: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

537: END IF;
538:
539: IF x_return_status = FND_API.G_RET_STS_ERROR then
540: raise FND_API.G_EXC_ERROR;
541: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
542: raise FND_API.G_EXC_UNEXPECTED_ERROR;
543: END IF;
544:
545: /**************************************************************

Line 542: raise FND_API.G_EXC_UNEXPECTED_ERROR;

538:
539: IF x_return_status = FND_API.G_RET_STS_ERROR then
540: raise FND_API.G_EXC_ERROR;
541: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
542: raise FND_API.G_EXC_UNEXPECTED_ERROR;
543: END IF;
544:
545: /**************************************************************
546: Call Update Quote for creating Quote lines

Line 562: x_return_status := FND_API.G_RET_STS_ERROR;

558: END IF;
559:
560: IF c_uom_qty_csr%NOTFOUND THEN
561: CLOSE c_uom_qty_csr;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
564: FND_MESSAGE.Set_Name('ASO', 'ASO_UOM_QTY_NOT_FOUND');
565: FND_MSG_PUB.Add;
566: END IF;

Line 567: raise FND_API.G_EXC_ERROR;

563: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
564: FND_MESSAGE.Set_Name('ASO', 'ASO_UOM_QTY_NOT_FOUND');
565: FND_MSG_PUB.Add;
566: END IF;
567: raise FND_API.G_EXC_ERROR;
568: END IF;
569:
570: l_Qte_Line_tbl(j).QUANTITY := l_quantity;
571: l_Qte_Line_tbl(j).UOM_CODE := l_uom;

Line 593: x_return_status := FND_API.G_RET_STS_ERROR;

589: END IF;
590:
591: IF c_last_update_date_csr%NOTFOUND THEN
592: CLOSE c_configuration_details_csr;
593: x_return_status := FND_API.G_RET_STS_ERROR;
594: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
595: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
596: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
597: FND_MSG_PUB.ADD;

Line 599: raise FND_API.G_EXC_ERROR;

595: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
596: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
597: FND_MSG_PUB.ADD;
598: END IF;
599: raise FND_API.G_EXC_ERROR;
600:
601: END IF;
602:
603: Close c_last_update_date_csr;

Line 648: IF x_return_status = FND_API.G_RET_STS_ERROR 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;
650: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
651: raise FND_API.G_EXC_UNEXPECTED_ERROR;
652: END IF;

Line 649: raise FND_API.G_EXC_ERROR;

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;
650: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
651: raise FND_API.G_EXC_UNEXPECTED_ERROR;
652: END IF;
653:

Line 650: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

646: END IF;
647:
648: IF x_return_status = FND_API.G_RET_STS_ERROR then
649: raise FND_API.G_EXC_ERROR;
650: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
651: raise FND_API.G_EXC_UNEXPECTED_ERROR;
652: END IF;
653:
654:

Line 651: raise FND_API.G_EXC_UNEXPECTED_ERROR;

647:
648: IF x_return_status = FND_API.G_RET_STS_ERROR then
649: raise FND_API.G_EXC_ERROR;
650: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
651: raise FND_API.G_EXC_UNEXPECTED_ERROR;
652: END IF;
653:
654:
655: /**************************************************************

Line 675: x_return_status := FND_API.G_RET_STS_ERROR;

671: END IF;
672:
673: IF c_configuration_details_csr%NOTFOUND THEN
674: CLOSE c_configuration_details_csr;
675: x_return_status := FND_API.G_RET_STS_ERROR;
676: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
677: FND_MESSAGE.Set_Name('ASO', 'ASO_CFG_DETAILS_NOT_FOUND');
678: FND_MSG_PUB.Add;
679: END IF;

Line 680: raise FND_API.G_EXC_ERROR;

676: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
677: FND_MESSAGE.Set_Name('ASO', 'ASO_CFG_DETAILS_NOT_FOUND');
678: FND_MSG_PUB.Add;
679: END IF;
680: raise FND_API.G_EXC_ERROR;
681:
682: END IF;
683:
684: Close c_configuration_details_csr;

Line 705: x_return_status := FND_API.G_RET_STS_ERROR;

701: END IF;
702:
703: IF c_mdl_item_details_csr%NOTFOUND THEN
704: CLOSE c_mdl_item_details_csr;
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
707: FND_MESSAGE.Set_Name('ASO', 'ASO_MDL_DETAILS_NOT_FOUND');
708: FND_MSG_PUB.Add;
709: END IF;

Line 710: raise FND_API.G_EXC_ERROR;

706: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
707: FND_MESSAGE.Set_Name('ASO', 'ASO_MDL_DETAILS_NOT_FOUND');
708: FND_MSG_PUB.Add;
709: END IF;
710: raise FND_API.G_EXC_ERROR;
711: END IF;
712:
713: Close c_mdl_item_details_csr;
714:

Line 724: P_Init_Msg_List => FND_API.g_false,

720: l_config_rev_nbr := lx_out_config_tree_tbl(k).config_rev_nbr ;
721:
722: ASO_CFG_PUB.Get_config_details(
723: P_Api_Version_Number => 1.0,
724: P_Init_Msg_List => FND_API.g_false,
725: p_commit => FND_API.g_false,
726: p_control_rec => p_control_rec,
727: p_config_rec => l_config_rec,
728: p_model_line_rec => l_model_line_rec,

Line 725: p_commit => FND_API.g_false,

721:
722: ASO_CFG_PUB.Get_config_details(
723: P_Api_Version_Number => 1.0,
724: P_Init_Msg_List => FND_API.g_false,
725: p_commit => FND_API.g_false,
726: p_control_rec => p_control_rec,
727: p_config_rec => l_config_rec,
728: p_model_line_rec => l_model_line_rec,
729: p_config_hdr_id => l_config_hdr_id,

Line 742: IF x_return_status = FND_API.G_RET_STS_ERROR 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;
744: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
745: raise FND_API.G_EXC_UNEXPECTED_ERROR;
746: END IF;

Line 743: raise FND_API.G_EXC_ERROR;

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;
744: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
745: raise FND_API.G_EXC_UNEXPECTED_ERROR;
746: END IF;
747:

Line 744: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

740: END IF;
741:
742: IF x_return_status = FND_API.G_RET_STS_ERROR then
743: raise FND_API.G_EXC_ERROR;
744: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
745: raise FND_API.G_EXC_UNEXPECTED_ERROR;
746: END IF;
747:
748: END LOOP;

Line 745: raise FND_API.G_EXC_UNEXPECTED_ERROR;

741:
742: IF x_return_status = FND_API.G_RET_STS_ERROR then
743: raise FND_API.G_EXC_ERROR;
744: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
745: raise FND_API.G_EXC_UNEXPECTED_ERROR;
746: END IF;
747:
748: END LOOP;
749:

Line 759: IF FND_API.To_Boolean(p_commit) 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
760: COMMIT WORK;
761: END IF;
762:
763: -- Standard call to get message count and if count is 1, get message info

Line 765: p_encoded => FND_API.G_FALSE,

761: END IF;
762:
763: -- Standard call to get message count and if count is 1, get message info
764: FND_Msg_Pub.Count_And_Get(
765: p_encoded => FND_API.G_FALSE,
766: p_count => x_msg_count,
767: p_data => x_msg_data
768: );
769:

Line 772: WHEN FND_API.G_EXC_ERROR THEN

768: );
769:
770:
771: EXCEPTION
772: WHEN FND_API.G_EXC_ERROR THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
775: P_API_NAME => L_API_NAME
776: ,P_PKG_NAME => G_PKG_NAME

Line 773: x_return_status := FND_API.G_RET_STS_ERROR;

769:
770:
771: EXCEPTION
772: WHEN FND_API.G_EXC_ERROR THEN
773: x_return_status := FND_API.G_RET_STS_ERROR;
774: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
775: P_API_NAME => L_API_NAME
776: ,P_PKG_NAME => G_PKG_NAME
777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

779: ,X_MSG_COUNT => X_MSG_COUNT
780: ,X_MSG_DATA => X_MSG_DATA
781: ,X_RETURN_STATUS => X_RETURN_STATUS);
782:
783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
786: P_API_NAME => L_API_NAME
787: ,P_PKG_NAME => G_PKG_NAME

Line 784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

780: ,X_MSG_DATA => X_MSG_DATA
781: ,X_RETURN_STATUS => X_RETURN_STATUS);
782:
783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
786: P_API_NAME => L_API_NAME
787: ,P_PKG_NAME => G_PKG_NAME
788: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

791: ,X_MSG_DATA => X_MSG_DATA
792: ,X_RETURN_STATUS => X_RETURN_STATUS);
793:
794: WHEN OTHERS THEN
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
797: P_API_NAME => L_API_NAME
798: ,P_PKG_NAME => G_PKG_NAME
799: ,P_SQLERRM => sqlerrm

Line 812: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

808:
809:
810: PROCEDURE Deactivate_from_quote(
811: P_Api_Version_Number IN NUMBER,
812: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
813: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
814: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
815: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
816: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,

Line 813: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

809:
810: PROCEDURE Deactivate_from_quote(
811: P_Api_Version_Number IN NUMBER,
812: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
813: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
814: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
815: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
816: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
817: P_qte_line_tbl IN ASO_QUOTE_PUB.Qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl,

Line 814: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

810: PROCEDURE Deactivate_from_quote(
811: P_Api_Version_Number IN NUMBER,
812: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
813: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
814: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
815: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
816: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
817: P_qte_line_tbl IN ASO_QUOTE_PUB.Qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl,
818: p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,

Line 818: p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,

814: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
815: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
816: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec,
817: P_qte_line_tbl IN ASO_QUOTE_PUB.Qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_Qte_line_tbl,
818: p_delete_flag IN VARCHAR2 := FND_API.G_TRUE,
819: x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
820: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
821: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
822: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 931: IF NOT FND_API.Compatible_API_Call (

927:
928: SAVEPOINT Deactivate_from_quote_pvt;
929:
930: -- Standard call to check for call compatibility.
931: IF NOT FND_API.Compatible_API_Call (
932: l_api_version,
933: p_api_version_Number,
934: l_api_name,
935: G_PKG_NAME )

Line 937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

933: p_api_version_Number,
934: l_api_name,
935: G_PKG_NAME )
936: THEN
937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
938: END IF;
939:
940: -- Initialize message list if p_init_msg_list is set to TRUE.
941: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 941: IF FND_API.to_Boolean( p_init_msg_list ) THEN

937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
938: END IF;
939:
940: -- Initialize message list if p_init_msg_list is set to TRUE.
941: IF FND_API.to_Boolean( p_init_msg_list ) THEN
942: FND_MSG_PUB.initialize;
943: END IF;
944:
945:

Line 947: x_return_status := FND_API.G_RET_STS_SUCCESS;

943: END IF;
944:
945:
946: -- Initialize API return status to success
947: x_return_status := FND_API.G_RET_STS_SUCCESS;
948:
949: /********************************************************************************
950: Construct "Deactivate quote line table" if "Deactivate flag" is set to 'True".
951: ********************************************************************************/

Line 952: IF (P_Control_Rec.deactivate_all = FND_API.G_TRUE)THEN

948:
949: /********************************************************************************
950: Construct "Deactivate quote line table" if "Deactivate flag" is set to 'True".
951: ********************************************************************************/
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

Line 1006: IF (P_Control_Rec.deactivate_all = FND_API.G_FALSE)THEN

1002: ********************************************************************/
1003:
1004: For i IN 1..l_qte_line_tbl.count Loop
1005:
1006: IF (P_Control_Rec.deactivate_all = FND_API.G_FALSE)THEN
1007:
1008: For c_de_item_rec IN c_deactivate_item_csr(l_qte_line_tbl(i).quote_line_id) LOOP
1009: if c_de_item_rec.config_delta > 0 then
1010: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1010: x_return_status := FND_API.G_RET_STS_ERROR;

1006: IF (P_Control_Rec.deactivate_all = FND_API.G_FALSE)THEN
1007:
1008: For c_de_item_rec IN c_deactivate_item_csr(l_qte_line_tbl(i).quote_line_id) LOOP
1009: if c_de_item_rec.config_delta > 0 then
1010: x_return_status := FND_API.G_RET_STS_ERROR;
1011: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1012: FND_MESSAGE.Set_Name('ASO', 'ASO_ITEM_CANT_BE_DEACTIVATED');
1013: FND_MSG_PUB.Add;
1014: END IF;

Line 1015: raise FND_API.G_EXC_ERROR;

1011: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1012: FND_MESSAGE.Set_Name('ASO', 'ASO_ITEM_CANT_BE_DEACTIVATED');
1013: FND_MSG_PUB.Add;
1014: END IF;
1015: raise FND_API.G_EXC_ERROR;
1016:
1017: end if;
1018: END LOOP;
1019: end if;

Line 1040: If l_config_header_id is not null and p_delete_flag = fnd_api.g_true then

1036: END IF;
1037:
1038: Close c_chk_qte_line_mdl_csr;
1039:
1040: If l_config_header_id is not null and p_delete_flag = fnd_api.g_true then
1041:
1042: /*******************************************************************
1043: Delete Quote line
1044: ********************************************************************/

Line 1051: p_update_header_flag => FND_API.G_FALSE,

1047:
1048: ASO_QUOTE_LINES_PVT.Delete_Quote_Line (
1049: P_Api_Version_Number => 1.0,
1050: p_control_rec => p_control_rec,
1051: p_update_header_flag => FND_API.G_FALSE,
1052: P_qte_Line_Rec => l_qte_line_rec,
1053: X_Return_Status => x_return_status,
1054: X_Msg_Count => x_msg_count,
1055: X_Msg_Data => x_msg_data);

Line 1057: IF x_return_status = FND_API.G_RET_STS_ERROR then

1053: X_Return_Status => x_return_status,
1054: X_Msg_Count => x_msg_count,
1055: X_Msg_Data => x_msg_data);
1056:
1057: IF x_return_status = FND_API.G_RET_STS_ERROR then
1058: raise FND_API.G_EXC_ERROR;
1059: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1060: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;

Line 1058: raise FND_API.G_EXC_ERROR;

1054: X_Msg_Count => x_msg_count,
1055: X_Msg_Data => x_msg_data);
1056:
1057: IF x_return_status = FND_API.G_RET_STS_ERROR then
1058: raise FND_API.G_EXC_ERROR;
1059: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1060: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;
1062:

Line 1059: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1055: X_Msg_Data => x_msg_data);
1056:
1057: IF x_return_status = FND_API.G_RET_STS_ERROR then
1058: raise FND_API.G_EXC_ERROR;
1059: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1060: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;
1062:
1063: else

Line 1060: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1056:
1057: IF x_return_status = FND_API.G_RET_STS_ERROR then
1058: raise FND_API.G_EXC_ERROR;
1059: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1060: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;
1062:
1063: else
1064:

Line 1081: IF x_return_status = FND_API.G_RET_STS_ERROR 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;
1083: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1084: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;

Line 1082: raise FND_API.G_EXC_ERROR;

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;
1083: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1084: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;
1086:

Line 1083: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1079: END IF;
1080:
1081: IF x_return_status = FND_API.G_RET_STS_ERROR then
1082: raise FND_API.G_EXC_ERROR;
1083: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1084: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;
1086:
1087: /**************************************************************

Line 1084: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1080:
1081: IF x_return_status = FND_API.G_RET_STS_ERROR then
1082: raise FND_API.G_EXC_ERROR;
1083: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1084: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1085: END IF;
1086:
1087: /**************************************************************
1088: Find the quote line containing the top model

Line 1179: x_return_status := FND_API.G_RET_STS_ERROR;

1175: END IF;
1176:
1177: IF c_last_update_date_csr%NOTFOUND THEN
1178: CLOSE c_last_update_date_csr;
1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1181: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1182: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1183: FND_MSG_PUB.ADD;

Line 1185: raise FND_API.G_EXC_ERROR;

1181: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
1182: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1183: FND_MSG_PUB.ADD;
1184: END IF;
1185: raise FND_API.G_EXC_ERROR;
1186:
1187: END IF;
1188:
1189: Close c_last_update_date_csr;

Line 1208: P_Init_Msg_List => FND_API.G_FALSE,

1204:
1205:
1206: ASO_CFG_PUB.Get_config_details(
1207: P_Api_Version_Number => P_Api_Version_Number,
1208: P_Init_Msg_List => FND_API.G_FALSE,
1209: p_commit => FND_API.G_FALSE,
1210: p_config_rec => l_config_rec,
1211: p_control_rec => p_control_rec,
1212: p_model_line_rec => l_model_line_rec,

Line 1209: p_commit => FND_API.G_FALSE,

1205:
1206: ASO_CFG_PUB.Get_config_details(
1207: P_Api_Version_Number => P_Api_Version_Number,
1208: P_Init_Msg_List => FND_API.G_FALSE,
1209: p_commit => FND_API.G_FALSE,
1210: p_config_rec => l_config_rec,
1211: p_control_rec => p_control_rec,
1212: p_model_line_rec => l_model_line_rec,
1213: p_config_hdr_id => l_copy_conf_mdl_Tbl(j).config_header_id,

Line 1226: IF x_return_status = FND_API.G_RET_STS_ERROR then

1222: aso_debug_pub.add('Deactivate_from_quote:Get_config_details:x_return_status'||x_return_status, 1, 'N');
1223: aso_debug_pub.add('Deactivate_from_quote:Get_config_details:x_return_status'||x_msg_count, 1, 'N');
1224: END IF;
1225:
1226: IF x_return_status = FND_API.G_RET_STS_ERROR then
1227: raise FND_API.G_EXC_ERROR;
1228: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1229: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1230: END IF;

Line 1227: raise FND_API.G_EXC_ERROR;

1223: aso_debug_pub.add('Deactivate_from_quote:Get_config_details:x_return_status'||x_msg_count, 1, 'N');
1224: END IF;
1225:
1226: IF x_return_status = FND_API.G_RET_STS_ERROR then
1227: raise FND_API.G_EXC_ERROR;
1228: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1229: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1230: END IF;
1231:

Line 1228: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1224: END IF;
1225:
1226: IF x_return_status = FND_API.G_RET_STS_ERROR then
1227: raise FND_API.G_EXC_ERROR;
1228: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1229: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1230: END IF;
1231:
1232: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1229: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1225:
1226: IF x_return_status = FND_API.G_RET_STS_ERROR then
1227: raise FND_API.G_EXC_ERROR;
1228: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1229: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1230: END IF;
1231:
1232: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1233: aso_debug_pub.add('Deactivate_from_quote:Write to l_deactivate_mdl_Tbl', 1, 'N');

Line 1258: IF FND_API.To_Boolean(p_commit) 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
1259: COMMIT WORK;
1260: END IF;
1261:
1262: -- Standard call to get message count and if count is 1, get message info

Line 1264: p_encoded => FND_API.G_FALSE,

1260: END IF;
1261:
1262: -- Standard call to get message count and if count is 1, get message info
1263: FND_Msg_Pub.Count_And_Get(
1264: p_encoded => FND_API.G_FALSE,
1265: p_count => x_msg_count,
1266: p_data => x_msg_data
1267: );
1268:

Line 1270: WHEN FND_API.G_EXC_ERROR THEN

1266: p_data => x_msg_data
1267: );
1268:
1269: EXCEPTION
1270: WHEN FND_API.G_EXC_ERROR THEN
1271: x_return_status := FND_API.G_RET_STS_ERROR;
1272: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1273: P_API_NAME => L_API_NAME
1274: ,P_PKG_NAME => G_PKG_NAME

Line 1271: x_return_status := FND_API.G_RET_STS_ERROR;

1267: );
1268:
1269: EXCEPTION
1270: WHEN FND_API.G_EXC_ERROR THEN
1271: x_return_status := FND_API.G_RET_STS_ERROR;
1272: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1273: P_API_NAME => L_API_NAME
1274: ,P_PKG_NAME => G_PKG_NAME
1275: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1277: ,X_MSG_COUNT => X_MSG_COUNT
1278: ,X_MSG_DATA => X_MSG_DATA
1279: ,X_RETURN_STATUS => X_RETURN_STATUS);
1280:
1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1283: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1284: P_API_NAME => L_API_NAME
1285: ,P_PKG_NAME => G_PKG_NAME

Line 1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1278: ,X_MSG_DATA => X_MSG_DATA
1279: ,X_RETURN_STATUS => X_RETURN_STATUS);
1280:
1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1283: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1284: P_API_NAME => L_API_NAME
1285: ,P_PKG_NAME => G_PKG_NAME
1286: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1289: ,X_MSG_DATA => X_MSG_DATA
1290: ,X_RETURN_STATUS => X_RETURN_STATUS);
1291:
1292: WHEN OTHERS THEN
1293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1295: P_API_NAME => L_API_NAME
1296: ,P_PKG_NAME => G_PKG_NAME
1297: ,P_SQLERRM => sqlerrm