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_PRICING_FLOWS_PVT dependencies on FND_API

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

19: ******************************************************************************/
20:
21: PROCEDURE Price_Entire_Quote(
22: P_Api_Version_Number IN NUMBER,
23: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
24: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
26: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
27: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

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

20:
21: PROCEDURE Price_Entire_Quote(
22: P_Api_Version_Number IN NUMBER,
23: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
24: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
26: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
27: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
28: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

Line 72: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

68:
69: BEGIN
70:
71: -- Standard call to check for call compatibility.
72: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
73: p_api_version_number,
74: l_api_name,
75: G_PKG_NAME)
76: THEN

Line 77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

73: p_api_version_number,
74: l_api_name,
75: G_PKG_NAME)
76: THEN
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END IF;
79:
80: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
81: l_pricing_start_time := dbms_utility.get_time;

Line 85: x_return_status := FND_API.G_RET_STS_SUCCESS;

81: l_pricing_start_time := dbms_utility.get_time;
82: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Start of Price_Entire_Quote',1,'Y');
83: END IF;
84:
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
88: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:p_control_rec.request_type:'||p_control_rec.request_type,1,'Y');
89: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:p_control_rec.pricing_event:'||p_control_rec.pricing_event,1,'Y');

Line 249: OR l_qte_line_tbl(i).price_list_id= FND_API.G_MISS_NUM) Then

245: END IF;
246: ELSE
247: /*Default the price list*/
248: If (l_qte_line_tbl(i).price_list_id is null
249: OR l_qte_line_tbl(i).price_list_id= FND_API.G_MISS_NUM) Then
250: l_qte_line_tbl(i).price_list_id := p_qte_header_rec.price_list_id;
251: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
252: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Price list id defaulted from Header:'
253: ||NVL(to_char(l_qte_line_tbl(i).price_list_id),'NULL'),1,'Y');

Line 574: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

570: (p_control_rec =>l_req_control_rec
571: ,x_return_status =>l_return_status
572: ,x_return_status_Text =>l_return_status_Text
573: );
574: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
575: x_return_status := l_return_status;
576: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
577: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
578: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);

Line 581: RAISE FND_API.G_EXC_ERROR;

577: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
578: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);
579: FND_MSG_PUB.ADD;
580: END IF;
581: RAISE FND_API.G_EXC_ERROR;
582: END IF;
583:
584: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
585: l_pricing_start_time := dbms_utility.get_time;

Line 598: P_Init_Msg_List => FND_API.G_FALSE,

594:
595:
596: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
597: P_Api_Version_Number => 1.0,
598: P_Init_Msg_List => FND_API.G_FALSE,
599: P_Commit => FND_API.G_FALSE,
600: p_control_rec => l_prc_control_rec,
601: p_qte_header_rec => p_qte_header_rec,
602: x_return_status => x_return_status,

Line 599: P_Commit => FND_API.G_FALSE,

595:
596: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
597: P_Api_Version_Number => 1.0,
598: P_Init_Msg_List => FND_API.G_FALSE,
599: P_Commit => FND_API.G_FALSE,
600: p_control_rec => l_prc_control_rec,
601: p_qte_header_rec => p_qte_header_rec,
602: x_return_status => x_return_status,
603: x_msg_count => x_msg_count,

Line 611: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

607: ||nvl(x_return_status,'NULL'),1,'Y');
608: END IF;
609:
610: If p_internal_call_flag = 'N' then
611: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
612: ASO_PRICING_CORE_PVT.Process_PRG(
613: P_Api_Version_Number => 1.0,
614: P_Init_Msg_List => FND_API.G_FALSE,
615: P_Commit => FND_API.G_FALSE,

Line 614: P_Init_Msg_List => FND_API.G_FALSE,

610: If p_internal_call_flag = 'N' then
611: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
612: ASO_PRICING_CORE_PVT.Process_PRG(
613: P_Api_Version_Number => 1.0,
614: P_Init_Msg_List => FND_API.G_FALSE,
615: P_Commit => FND_API.G_FALSE,
616: p_control_rec => l_prc_control_rec,
617: p_qte_header_rec => p_qte_header_rec,
618: x_qte_line_tbl => x_qte_line_tbl,

Line 615: P_Commit => FND_API.G_FALSE,

611: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
612: ASO_PRICING_CORE_PVT.Process_PRG(
613: P_Api_Version_Number => 1.0,
614: P_Init_Msg_List => FND_API.G_FALSE,
615: P_Commit => FND_API.G_FALSE,
616: p_control_rec => l_prc_control_rec,
617: p_qte_header_rec => p_qte_header_rec,
618: x_qte_line_tbl => x_qte_line_tbl,
619: x_return_status => x_return_status,

Line 628: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS

624: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Process_PRG : x_return_status: '
625: ||nvl(x_return_status,'NULL'),1,'Y');
626: END IF;
627:
628: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS
629:
630: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
631: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
632: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After Process_PRG : x_qte_line_tbl.count: '

Line 630: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

626: END IF;
627:
628: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS
629:
630: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
631: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
632: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After Process_PRG : x_qte_line_tbl.count: '
633: ||x_qte_line_tbl.count,1,'Y');
634: END IF;

Line 638: P_Init_Msg_List => FND_API.G_FALSE,

634: END IF;
635:
636: ASO_PRICING_CORE_PVT.Process_Charges(
637: P_Api_Version_Number => 1.0,
638: P_Init_Msg_List => FND_API.G_FALSE,
639: P_Commit => FND_API.G_FALSE,
640: p_control_rec => l_prc_control_rec,
641: p_qte_header_rec => p_qte_header_rec,
642: x_return_status => x_return_status,

Line 639: P_Commit => FND_API.G_FALSE,

635:
636: ASO_PRICING_CORE_PVT.Process_Charges(
637: P_Api_Version_Number => 1.0,
638: P_Init_Msg_List => FND_API.G_FALSE,
639: P_Commit => FND_API.G_FALSE,
640: p_control_rec => l_prc_control_rec,
641: p_qte_header_rec => p_qte_header_rec,
642: x_return_status => x_return_status,
643: x_msg_count => x_msg_count,

Line 650: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS

646: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Process_Charges : x_return_status: '
647: ||nvl(x_return_status,'NULL'),1,'Y');
648: END IF;
649:
650: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS
651:
652: End If;--p_internal_call_flag = 'N'
653: End if;--(l_qte_line_tbl.count <> 0 ) OR (p_control_rec.pricing_event = 'ORDER')
654:

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

687:
688: PROCEDURE Price_Quote_Line(
689:
690: P_Api_Version_Number IN NUMBER,
691: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
692: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
693: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
694: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
695: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

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

688: PROCEDURE Price_Quote_Line(
689:
690: P_Api_Version_Number IN NUMBER,
691: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
692: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
693: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
694: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
695: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
696: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

Line 771: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

767: -- Standard Start of API savepoint
768: SAVEPOINT PRICE_QUOTE_LINE_PVT;
769:
770: -- Standard call to check for call compatibility.
771: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
772: p_api_version_number,
773: l_api_name,
774: G_PKG_NAME)
775: THEN

Line 776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

772: p_api_version_number,
773: l_api_name,
774: G_PKG_NAME)
775: THEN
776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
777: END IF;
778:
779: x_return_status := FND_API.G_RET_STS_SUCCESS;
780:

Line 779: x_return_status := FND_API.G_RET_STS_SUCCESS;

775: THEN
776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
777: END IF;
778:
779: x_return_status := FND_API.G_RET_STS_SUCCESS;
780:
781:
782: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
783: aso_debug_pub.add('p_control_rec.request_type:'||p_control_rec.request_type,1,'Y');

Line 1134: l_qte_line_tbl(i).price_list_id= FND_API.G_MISS_NUM) THEN

1130: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: l_qte_line_tbl(i).price_list_id :'||NVL(to_char(l_qte_line_tbl(i).price_list_id),'NULL'),1,'Y');
1131: END IF;
1132: -- Pass Header level price list by default.
1133: IF (l_qte_line_tbl(i).price_list_id is null OR
1134: l_qte_line_tbl(i).price_list_id= FND_API.G_MISS_NUM) THEN
1135: l_qte_line_tbl(i).price_list_id := p_qte_header_rec.price_list_id;
1136: END IF;
1137:
1138:

Line 1362: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1358: ,x_return_status =>l_return_status
1359: ,x_return_status_Text =>l_return_status_Text
1360: );
1361:
1362: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1363: x_return_status := l_return_status;
1364: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1365: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
1366: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);

Line 1369: RAISE FND_API.G_EXC_ERROR;

1365: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
1366: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);
1367: FND_MSG_PUB.ADD;
1368: END IF;
1369: RAISE FND_API.G_EXC_ERROR;
1370: END IF;
1371:
1372: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1373: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');

Line 1384: P_Init_Msg_List => FND_API.G_FALSE,

1380:
1381:
1382: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
1383: P_Api_Version_Number => 1.0,
1384: P_Init_Msg_List => FND_API.G_FALSE,
1385: P_Commit => p_commit,
1386: p_control_rec => p_control_rec,
1387: p_qte_header_rec => p_qte_header_rec,
1388: x_return_status => x_return_status,

Line 1400: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1396: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Copy_Price_To_Quote : x_msg_data: '
1397: ||NVL(x_msg_data,'X'),1,'Y');
1398: END IF;
1399:
1400: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1401:
1402: ASO_PRICING_CORE_PVT.Process_Charges(
1403: P_Api_Version_Number => 1.0,
1404: P_Init_Msg_List => FND_API.G_FALSE,

Line 1404: P_Init_Msg_List => FND_API.G_FALSE,

1400: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1401:
1402: ASO_PRICING_CORE_PVT.Process_Charges(
1403: P_Api_Version_Number => 1.0,
1404: P_Init_Msg_List => FND_API.G_FALSE,
1405: P_Commit => p_commit,
1406: p_control_rec => p_control_rec,
1407: p_qte_header_rec => p_qte_header_rec,
1408: x_return_status => x_return_status,

Line 1416: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS

1412: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Process_Charges : x_return_status: '
1413: ||nvl(x_return_status,'NULL'),1,'Y');
1414: END IF;
1415:
1416: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS
1417: FND_MSG_PUB.Count_And_Get
1418: ( p_encoded => 'F',
1419: p_count => x_msg_count,
1420: p_data => x_msg_data

Line 1432: WHEN FND_API.G_EXC_ERROR THEN

1428: END IF;
1429: END LOOP;
1430:
1431: EXCEPTION
1432: WHEN FND_API.G_EXC_ERROR THEN
1433: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1434: aso_debug_pub.add('after inside EXCEPTION return status'||x_return_status, 1, 'Y');
1435: END IF;
1436: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 1447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1443: ,X_MSG_COUNT => X_MSG_COUNT
1444: ,X_MSG_DATA => X_MSG_DATA
1445: ,X_RETURN_STATUS => X_RETURN_STATUS);
1446:
1447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1448: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1449: P_API_NAME => L_API_NAME
1450: ,P_PKG_NAME => G_PKG_NAME
1451: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

1478: ******************************************************************************/
1479:
1480: PROCEDURE Price_Quote_With_Change_Lines(
1481: P_Api_Version_Number IN NUMBER,
1482: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1483: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1484: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
1485: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1486: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

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

1479:
1480: PROCEDURE Price_Quote_With_Change_Lines(
1481: P_Api_Version_Number IN NUMBER,
1482: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1483: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1484: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
1485: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1486: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
1487: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

Line 1540: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1536:
1537: BEGIN
1538:
1539: -- Standard call to check for call compatibility.
1540: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1541: p_api_version_number,
1542: l_api_name,
1543: G_PKG_NAME)
1544: THEN

Line 1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1541: p_api_version_number,
1542: l_api_name,
1543: G_PKG_NAME)
1544: THEN
1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1546: END IF;
1547:
1548: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1549: l_pricing_start_time := dbms_utility.get_time;

Line 1553: x_return_status := FND_API.G_RET_STS_SUCCESS;

1549: l_pricing_start_time := dbms_utility.get_time;
1550: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Start of Price_Quote_With_Change_Lines',1,'Y');
1551: END IF;
1552:
1553: x_return_status := FND_API.G_RET_STS_SUCCESS;
1554:
1555: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1556: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:p_control_rec.request_type:'||p_control_rec.request_type,1,'Y');
1557: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:p_control_rec.pricing_event:'||p_control_rec.pricing_event,1,'Y');

Line 1689: P_change_line_flag => FND_API.G_TRUE);

1685: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Pricing_Line_Rows...',1,'Y');
1686: END IF;
1687:
1688: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Pricing_Line_Rows(P_Qte_Header_Id => p_qte_header_rec.quote_header_id,
1689: P_change_line_flag => FND_API.G_TRUE);
1690: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1691: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After Query_Lines_lineIdlocation l_qte_line_tbl.count :'
1692: ||NVL(l_qte_line_tbl.count,0),1,'Y');
1693: l_pricing_end_time := dbms_utility.get_time;

Line 2255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2251: (p_control_rec =>l_req_control_rec
2252: ,x_return_status =>l_return_status
2253: ,x_return_status_Text =>l_return_status_Text
2254: );
2255: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2256: x_return_status := l_return_status;
2257: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2258: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
2259: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);

Line 2262: RAISE FND_API.G_EXC_ERROR;

2258: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
2259: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);
2260: FND_MSG_PUB.ADD;
2261: END IF;
2262: RAISE FND_API.G_EXC_ERROR;
2263: END IF;
2264:
2265: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2266: l_pricing_start_time := dbms_utility.get_time;

Line 2279: P_Init_Msg_List => FND_API.G_FALSE,

2275: END IF;
2276: /*Insert all the applied adjustments and the nonapplied manual adjustments*/
2277: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
2278: P_Api_Version_Number => 1.0,
2279: P_Init_Msg_List => FND_API.G_FALSE,
2280: P_Commit => FND_API.G_FALSE,
2281: p_control_rec => l_prc_control_rec,
2282: p_qte_header_rec => p_qte_header_rec,
2283: P_Insert_Type => 'HDR',

Line 2280: P_Commit => FND_API.G_FALSE,

2276: /*Insert all the applied adjustments and the nonapplied manual adjustments*/
2277: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
2278: P_Api_Version_Number => 1.0,
2279: P_Init_Msg_List => FND_API.G_FALSE,
2280: P_Commit => FND_API.G_FALSE,
2281: p_control_rec => l_prc_control_rec,
2282: p_qte_header_rec => p_qte_header_rec,
2283: P_Insert_Type => 'HDR',
2284: x_return_status => x_return_status,

Line 2293: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2289: ||nvl(x_return_status,'NULL'),1,'Y');
2290: END IF;
2291:
2292: If p_internal_call_flag = 'N' then
2293: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2294: ASO_PRICING_CORE_PVT.Process_PRG(
2295: P_Api_Version_Number => 1.0,
2296: P_Init_Msg_List => FND_API.G_FALSE,
2297: P_Commit => FND_API.G_FALSE,

Line 2296: P_Init_Msg_List => FND_API.G_FALSE,

2292: If p_internal_call_flag = 'N' then
2293: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2294: ASO_PRICING_CORE_PVT.Process_PRG(
2295: P_Api_Version_Number => 1.0,
2296: P_Init_Msg_List => FND_API.G_FALSE,
2297: P_Commit => FND_API.G_FALSE,
2298: p_control_rec => l_prc_control_rec,
2299: p_qte_header_rec => p_qte_header_rec,
2300: x_qte_line_tbl => x_qte_line_tbl,

Line 2297: P_Commit => FND_API.G_FALSE,

2293: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2294: ASO_PRICING_CORE_PVT.Process_PRG(
2295: P_Api_Version_Number => 1.0,
2296: P_Init_Msg_List => FND_API.G_FALSE,
2297: P_Commit => FND_API.G_FALSE,
2298: p_control_rec => l_prc_control_rec,
2299: p_qte_header_rec => p_qte_header_rec,
2300: x_qte_line_tbl => x_qte_line_tbl,
2301: x_return_status => x_return_status,

Line 2310: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS

2306: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Process_PRG : x_return_status: '
2307: ||nvl(x_return_status,'NULL'),1,'Y');
2308: END IF;
2309:
2310: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS
2311:
2312: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2313: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2314: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After Process_PRG : x_qte_line_tbl.count: '

Line 2312: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2308: END IF;
2309:
2310: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS
2311:
2312: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2313: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2314: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After Process_PRG : x_qte_line_tbl.count: '
2315: ||x_qte_line_tbl.count,1,'Y');
2316: END IF;

Line 2320: P_Init_Msg_List => FND_API.G_FALSE,

2316: END IF;
2317:
2318: ASO_PRICING_CORE_PVT.Process_Charges(
2319: P_Api_Version_Number => 1.0,
2320: P_Init_Msg_List => FND_API.G_FALSE,
2321: P_Commit => FND_API.G_FALSE,
2322: p_control_rec => l_prc_control_rec,
2323: p_qte_header_rec => p_qte_header_rec,
2324: x_return_status => x_return_status,

Line 2321: P_Commit => FND_API.G_FALSE,

2317:
2318: ASO_PRICING_CORE_PVT.Process_Charges(
2319: P_Api_Version_Number => 1.0,
2320: P_Init_Msg_List => FND_API.G_FALSE,
2321: P_Commit => FND_API.G_FALSE,
2322: p_control_rec => l_prc_control_rec,
2323: p_qte_header_rec => p_qte_header_rec,
2324: x_return_status => x_return_status,
2325: x_msg_count => x_msg_count,

Line 2332: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS

2328: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Process_Charges : x_return_status: '
2329: ||nvl(x_return_status,'NULL'),1,'Y');
2330: END IF;
2331:
2332: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS
2333: End If;--p_internal_call_flag = 'N'??????????Is this okay????
2334:
2335: -- After the code review according to SPGOPAL if the summary line flag is 'N' then we don't need to make
2336: -- the calculate flag. Also we cannot compare the percentage of the header level since in future if there

Line 2347: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2343: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Total time taken (in secs) in Price Entire Quote(Besides Pricing):'||l_accum_aso_time/100,1,'Y');
2344: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Total time taken (in secs) in Pricing+BuildContext:'||l_accum_qp_time/100,1,'Y');
2345: END IF;
2346:
2347: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2348: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2349: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Before Calling Calculate Call l_complete_qte_flag:'
2350: ||l_complete_qte_flag,1,'Y');
2351: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Before Calling Calculate Call lx_order_status_rec.summary_line_flag:'

Line 2370: P_Init_Msg_List => FND_API.G_FALSE,

2366: --Call Calculate only call
2367:
2368: Price_Quote_Calculate_Call(
2369: P_Api_Version_Number => P_Api_Version_Number,
2370: P_Init_Msg_List => FND_API.G_FALSE,
2371: P_Commit => FND_API.G_FALSE,
2372: p_control_rec => l_prc_control_rec,
2373: p_qte_header_rec => p_qte_header_rec,
2374: p_delta_line_id_tbl => l_qte_line_id_tbl,

Line 2371: P_Commit => FND_API.G_FALSE,

2367:
2368: Price_Quote_Calculate_Call(
2369: P_Api_Version_Number => P_Api_Version_Number,
2370: P_Init_Msg_List => FND_API.G_FALSE,
2371: P_Commit => FND_API.G_FALSE,
2372: p_control_rec => l_prc_control_rec,
2373: p_qte_header_rec => p_qte_header_rec,
2374: p_delta_line_id_tbl => l_qte_line_id_tbl,
2375: x_qte_line_tbl => lx_Qte_Line_Tbl,

Line 2385: END IF;-- x_return_status = FND_API.G_RET_STS_SUCCESS

2381:
2382: End If;-- If l_complete_qte_flag = 'N'
2383:
2384:
2385: END IF;-- x_return_status = FND_API.G_RET_STS_SUCCESS
2386:
2387:
2388: --End If;--p_internal_call_flag = 'N'
2389: End if;-- (l_Qte_Line_id_tbl.EXISTS(1)) OR (p_control_rec.pricing_event = 'ORDER')

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

2406: END Price_Quote_With_Change_Lines;
2407:
2408: PROCEDURE Price_Quote_Calculate_Call(
2409: P_Api_Version_Number IN NUMBER,
2410: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2411: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2412: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
2413: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2414: p_delta_line_id_tbl IN JTF_NUMBER_TABLE,

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

2407:
2408: PROCEDURE Price_Quote_Calculate_Call(
2409: P_Api_Version_Number IN NUMBER,
2410: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2411: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2412: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
2413: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2414: p_delta_line_id_tbl IN JTF_NUMBER_TABLE,
2415: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 2452: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2448: l_accum_qp_time NUMBER;
2449:
2450: BEGIN
2451: -- Standard call to check for call compatibility.
2452: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2453: p_api_version_number,
2454: l_api_name,
2455: G_PKG_NAME)
2456: THEN

Line 2457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2453: p_api_version_number,
2454: l_api_name,
2455: G_PKG_NAME)
2456: THEN
2457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2458: END IF;
2459:
2460: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2461: l_pricing_start_time := dbms_utility.get_time;

Line 2465: x_return_status := FND_API.G_RET_STS_SUCCESS;

2461: l_pricing_start_time := dbms_utility.get_time;
2462: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Start of Price_Quote_Calculate_Call',1,'Y');
2463: END IF;
2464:
2465: x_return_status := FND_API.G_RET_STS_SUCCESS;
2466:
2467: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2468: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:p_control_rec.request_type:'||p_control_rec.request_type,1,'Y');
2469: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:p_control_rec.pricing_event:'||p_control_rec.pricing_event,1,'Y');

Line 2816: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2812: (p_control_rec =>l_req_control_rec
2813: ,x_return_status =>l_return_status
2814: ,x_return_status_Text =>l_return_status_Text
2815: );
2816: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2817: x_return_status := l_return_status;
2818: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2819: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
2820: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);

Line 2823: RAISE FND_API.G_EXC_ERROR;

2819: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
2820: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);
2821: FND_MSG_PUB.ADD;
2822: END IF;
2823: RAISE FND_API.G_EXC_ERROR;
2824: END IF;
2825:
2826: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2827: l_pricing_start_time := dbms_utility.get_time;

Line 2839: P_Init_Msg_List => FND_API.G_FALSE,

2835: END IF;
2836:
2837: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
2838: P_Api_Version_Number => 1.0,
2839: P_Init_Msg_List => FND_API.G_FALSE,
2840: P_Commit => FND_API.G_FALSE,
2841: p_control_rec => l_prc_control_rec,
2842: p_qte_header_rec => p_qte_header_rec,
2843: p_insert_type => 'HDR_ONLY',

Line 2840: P_Commit => FND_API.G_FALSE,

2836:
2837: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
2838: P_Api_Version_Number => 1.0,
2839: P_Init_Msg_List => FND_API.G_FALSE,
2840: P_Commit => FND_API.G_FALSE,
2841: p_control_rec => l_prc_control_rec,
2842: p_qte_header_rec => p_qte_header_rec,
2843: p_insert_type => 'HDR_ONLY',
2844: x_return_status => x_return_status,

Line 2851: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2847: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2848: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Copy_Price_To_Quote : x_return_status: '
2849: ||nvl(x_return_status,'NULL'),1,'Y');
2850: END IF;
2851: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2852: ASO_PRICING_CORE_PVT.Process_Charges(
2853: P_Api_Version_Number => 1.0,
2854: P_Init_Msg_List => FND_API.G_FALSE,
2855: P_Commit => FND_API.G_FALSE,

Line 2854: P_Init_Msg_List => FND_API.G_FALSE,

2850: END IF;
2851: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2852: ASO_PRICING_CORE_PVT.Process_Charges(
2853: P_Api_Version_Number => 1.0,
2854: P_Init_Msg_List => FND_API.G_FALSE,
2855: P_Commit => FND_API.G_FALSE,
2856: p_control_rec => l_prc_control_rec,
2857: p_qte_header_rec => p_qte_header_rec,
2858: x_return_status => x_return_status,

Line 2855: P_Commit => FND_API.G_FALSE,

2851: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2852: ASO_PRICING_CORE_PVT.Process_Charges(
2853: P_Api_Version_Number => 1.0,
2854: P_Init_Msg_List => FND_API.G_FALSE,
2855: P_Commit => FND_API.G_FALSE,
2856: p_control_rec => l_prc_control_rec,
2857: p_qte_header_rec => p_qte_header_rec,
2858: x_return_status => x_return_status,
2859: x_msg_count => x_msg_count,