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 821: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

817: -- Standard Start of API savepoint
818: SAVEPOINT PRICE_QUOTE_LINE_PVT;
819:
820: -- Standard call to check for call compatibility.
821: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
822: p_api_version_number,
823: l_api_name,
824: G_PKG_NAME)
825: THEN

Line 826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

822: p_api_version_number,
823: l_api_name,
824: G_PKG_NAME)
825: THEN
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END IF;
828:
829: x_return_status := FND_API.G_RET_STS_SUCCESS;
830:

Line 829: x_return_status := FND_API.G_RET_STS_SUCCESS;

825: THEN
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END IF;
828:
829: x_return_status := FND_API.G_RET_STS_SUCCESS;
830:
831:
832: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
833: aso_debug_pub.add('p_control_rec.request_type:'||p_control_rec.request_type,1,'Y');

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

1308: 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');
1309: END IF;
1310: -- Pass Header level price list by default.
1311: IF (l_qte_line_tbl(i).price_list_id is null OR
1312: l_qte_line_tbl(i).price_list_id= FND_API.G_MISS_NUM) THEN
1313: l_qte_line_tbl(i).price_list_id := p_qte_header_rec.price_list_id;
1314: END IF;
1315:
1316:

Line 1540: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1536: ,x_return_status =>l_return_status
1537: ,x_return_status_Text =>l_return_status_Text
1538: );
1539:
1540: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1541: x_return_status := l_return_status;
1542: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1543: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
1544: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);

Line 1547: RAISE FND_API.G_EXC_ERROR;

1543: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
1544: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);
1545: FND_MSG_PUB.ADD;
1546: END IF;
1547: RAISE FND_API.G_EXC_ERROR;
1548: END IF;
1549:
1550: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1551: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');

Line 1562: P_Init_Msg_List => FND_API.G_FALSE,

1558:
1559:
1560: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
1561: P_Api_Version_Number => 1.0,
1562: P_Init_Msg_List => FND_API.G_FALSE,
1563: P_Commit => p_commit,
1564: p_control_rec => p_control_rec,
1565: p_qte_header_rec => p_qte_header_rec,
1566: x_return_status => x_return_status,

Line 1578: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1574: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Copy_Price_To_Quote : x_msg_data: '
1575: ||NVL(x_msg_data,'X'),1,'Y');
1576: END IF;
1577:
1578: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1579:
1580: ASO_PRICING_CORE_PVT.Process_Charges(
1581: P_Api_Version_Number => 1.0,
1582: P_Init_Msg_List => FND_API.G_FALSE,

Line 1582: P_Init_Msg_List => FND_API.G_FALSE,

1578: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1579:
1580: ASO_PRICING_CORE_PVT.Process_Charges(
1581: P_Api_Version_Number => 1.0,
1582: P_Init_Msg_List => FND_API.G_FALSE,
1583: P_Commit => p_commit,
1584: p_control_rec => p_control_rec,
1585: p_qte_header_rec => p_qte_header_rec,
1586: x_return_status => x_return_status,

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

1590: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Process_Charges : x_return_status: '
1591: ||nvl(x_return_status,'NULL'),1,'Y');
1592: END IF;
1593:
1594: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS
1595: FND_MSG_PUB.Count_And_Get
1596: ( p_encoded => 'F',
1597: p_count => x_msg_count,
1598: p_data => x_msg_data

Line 1610: WHEN FND_API.G_EXC_ERROR THEN

1606: END IF;
1607: END LOOP;
1608:
1609: EXCEPTION
1610: WHEN FND_API.G_EXC_ERROR THEN
1611: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1612: aso_debug_pub.add('after inside EXCEPTION return status'||x_return_status, 1, 'Y');
1613: END IF;
1614: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1621: ,X_MSG_COUNT => X_MSG_COUNT
1622: ,X_MSG_DATA => X_MSG_DATA
1623: ,X_RETURN_STATUS => X_RETURN_STATUS);
1624:
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1627: P_API_NAME => L_API_NAME
1628: ,P_PKG_NAME => G_PKG_NAME
1629: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

1656: ******************************************************************************/
1657:
1658: PROCEDURE Price_Quote_With_Change_Lines(
1659: P_Api_Version_Number IN NUMBER,
1660: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1661: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1662: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
1663: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1664: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

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

1657:
1658: PROCEDURE Price_Quote_With_Change_Lines(
1659: P_Api_Version_Number IN NUMBER,
1660: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1661: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1662: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
1663: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
1664: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
1665: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

Line 1724: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1720:
1721: BEGIN
1722:
1723: -- Standard call to check for call compatibility.
1724: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1725: p_api_version_number,
1726: l_api_name,
1727: G_PKG_NAME)
1728: THEN

Line 1729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1725: p_api_version_number,
1726: l_api_name,
1727: G_PKG_NAME)
1728: THEN
1729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1730: END IF;
1731:
1732: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1733: l_pricing_start_time := dbms_utility.get_time;

Line 1737: x_return_status := FND_API.G_RET_STS_SUCCESS;

1733: l_pricing_start_time := dbms_utility.get_time;
1734: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Start of Price_Quote_With_Change_Lines',1,'Y');
1735: END IF;
1736:
1737: x_return_status := FND_API.G_RET_STS_SUCCESS;
1738:
1739: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1740: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:p_control_rec.request_type:'||p_control_rec.request_type,1,'Y');
1741: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:p_control_rec.pricing_event:'||p_control_rec.pricing_event,1,'Y');

Line 1873: P_change_line_flag => FND_API.G_TRUE);

1869: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Start of Query_Pricing_Line_Rows...',1,'Y');
1870: END IF;
1871:
1872: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Pricing_Line_Rows(P_Qte_Header_Id => p_qte_header_rec.quote_header_id,
1873: P_change_line_flag => FND_API.G_TRUE);
1874: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1875: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After Query_Lines_lineIdlocation l_qte_line_tbl.count :'
1876: ||NVL(l_qte_line_tbl.count,0),1,'Y');
1877: l_pricing_end_time := dbms_utility.get_time;

Line 2495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2491: (p_control_rec =>l_req_control_rec
2492: ,x_return_status =>l_return_status
2493: ,x_return_status_Text =>l_return_status_Text
2494: );
2495: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2496: x_return_status := l_return_status;
2497: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2498: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
2499: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);

Line 2502: RAISE FND_API.G_EXC_ERROR;

2498: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
2499: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);
2500: FND_MSG_PUB.ADD;
2501: END IF;
2502: RAISE FND_API.G_EXC_ERROR;
2503: END IF;
2504:
2505: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2506: l_pricing_start_time := dbms_utility.get_time;

Line 2519: P_Init_Msg_List => FND_API.G_FALSE,

2515: END IF;
2516: /*Insert all the applied adjustments and the nonapplied manual adjustments*/
2517: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
2518: P_Api_Version_Number => 1.0,
2519: P_Init_Msg_List => FND_API.G_FALSE,
2520: P_Commit => FND_API.G_FALSE,
2521: p_control_rec => l_prc_control_rec,
2522: p_qte_header_rec => p_qte_header_rec,
2523: P_Insert_Type => 'HDR',

Line 2520: P_Commit => FND_API.G_FALSE,

2516: /*Insert all the applied adjustments and the nonapplied manual adjustments*/
2517: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
2518: P_Api_Version_Number => 1.0,
2519: P_Init_Msg_List => FND_API.G_FALSE,
2520: P_Commit => FND_API.G_FALSE,
2521: p_control_rec => l_prc_control_rec,
2522: p_qte_header_rec => p_qte_header_rec,
2523: P_Insert_Type => 'HDR',
2524: x_return_status => x_return_status,

Line 2533: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2529: ||nvl(x_return_status,'NULL'),1,'Y');
2530: END IF;
2531:
2532: If p_internal_call_flag = 'N' then
2533: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2534: ASO_PRICING_CORE_PVT.Process_PRG(
2535: P_Api_Version_Number => 1.0,
2536: P_Init_Msg_List => FND_API.G_FALSE,
2537: P_Commit => FND_API.G_FALSE,

Line 2536: P_Init_Msg_List => FND_API.G_FALSE,

2532: If p_internal_call_flag = 'N' then
2533: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2534: ASO_PRICING_CORE_PVT.Process_PRG(
2535: P_Api_Version_Number => 1.0,
2536: P_Init_Msg_List => FND_API.G_FALSE,
2537: P_Commit => FND_API.G_FALSE,
2538: p_control_rec => l_prc_control_rec,
2539: p_qte_header_rec => p_qte_header_rec,
2540: x_qte_line_tbl => x_qte_line_tbl,

Line 2537: P_Commit => FND_API.G_FALSE,

2533: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2534: ASO_PRICING_CORE_PVT.Process_PRG(
2535: P_Api_Version_Number => 1.0,
2536: P_Init_Msg_List => FND_API.G_FALSE,
2537: P_Commit => FND_API.G_FALSE,
2538: p_control_rec => l_prc_control_rec,
2539: p_qte_header_rec => p_qte_header_rec,
2540: x_qte_line_tbl => x_qte_line_tbl,
2541: x_return_status => x_return_status,

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

2546: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Process_PRG : x_return_status: '
2547: ||nvl(x_return_status,'NULL'),1,'Y');
2548: END IF;
2549:
2550: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS
2551:
2552: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2553: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2554: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After Process_PRG : x_qte_line_tbl.count: '

Line 2552: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2548: END IF;
2549:
2550: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS
2551:
2552: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2553: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2554: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: After Process_PRG : x_qte_line_tbl.count: '
2555: ||x_qte_line_tbl.count,1,'Y');
2556: END IF;

Line 2560: P_Init_Msg_List => FND_API.G_FALSE,

2556: END IF;
2557:
2558: ASO_PRICING_CORE_PVT.Process_Charges(
2559: P_Api_Version_Number => 1.0,
2560: P_Init_Msg_List => FND_API.G_FALSE,
2561: P_Commit => FND_API.G_FALSE,
2562: p_control_rec => l_prc_control_rec,
2563: p_qte_header_rec => p_qte_header_rec,
2564: x_return_status => x_return_status,

Line 2561: P_Commit => FND_API.G_FALSE,

2557:
2558: ASO_PRICING_CORE_PVT.Process_Charges(
2559: P_Api_Version_Number => 1.0,
2560: P_Init_Msg_List => FND_API.G_FALSE,
2561: P_Commit => FND_API.G_FALSE,
2562: p_control_rec => l_prc_control_rec,
2563: p_qte_header_rec => p_qte_header_rec,
2564: x_return_status => x_return_status,
2565: x_msg_count => x_msg_count,

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

2568: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Process_Charges : x_return_status: '
2569: ||nvl(x_return_status,'NULL'),1,'Y');
2570: END IF;
2571:
2572: END IF;--x_return_status = FND_API.G_RET_STS_SUCCESS
2573: End If;--p_internal_call_flag = 'N'??????????Is this okay????
2574:
2575: -- After the code review according to SPGOPAL if the summary line flag is 'N' then we don't need to make
2576: -- the calculate flag. Also we cannot compare the percentage of the header level since in future if there

Line 2587: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2583: 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');
2584: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Total time taken (in secs) in Pricing+BuildContext:'||l_accum_qp_time/100,1,'Y');
2585: END IF;
2586:
2587: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2588: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2589: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Before Calling Calculate Call l_complete_qte_flag:'
2590: ||l_complete_qte_flag,1,'Y');
2591: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Before Calling Calculate Call lx_order_status_rec.summary_line_flag:'

Line 2610: P_Init_Msg_List => FND_API.G_FALSE,

2606: --Call Calculate only call
2607:
2608: Price_Quote_Calculate_Call(
2609: P_Api_Version_Number => P_Api_Version_Number,
2610: P_Init_Msg_List => FND_API.G_FALSE,
2611: P_Commit => FND_API.G_FALSE,
2612: p_control_rec => l_prc_control_rec,
2613: p_qte_header_rec => p_qte_header_rec,
2614: p_delta_line_id_tbl => l_qte_line_id_tbl,

Line 2611: P_Commit => FND_API.G_FALSE,

2607:
2608: Price_Quote_Calculate_Call(
2609: P_Api_Version_Number => P_Api_Version_Number,
2610: P_Init_Msg_List => FND_API.G_FALSE,
2611: P_Commit => FND_API.G_FALSE,
2612: p_control_rec => l_prc_control_rec,
2613: p_qte_header_rec => p_qte_header_rec,
2614: p_delta_line_id_tbl => l_qte_line_id_tbl,
2615: x_qte_line_tbl => lx_Qte_Line_Tbl,

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

2621:
2622: End If;-- If l_complete_qte_flag = 'N'
2623:
2624:
2625: END IF;-- x_return_status = FND_API.G_RET_STS_SUCCESS
2626:
2627:
2628: --End If;--p_internal_call_flag = 'N'
2629: End if;-- (l_Qte_Line_id_tbl.EXISTS(1)) OR (p_control_rec.pricing_event = 'ORDER')

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

2646: END Price_Quote_With_Change_Lines;
2647:
2648: PROCEDURE Price_Quote_Calculate_Call(
2649: P_Api_Version_Number IN NUMBER,
2650: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2651: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2652: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
2653: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2654: p_delta_line_id_tbl IN JTF_NUMBER_TABLE,

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

2647:
2648: PROCEDURE Price_Quote_Calculate_Call(
2649: P_Api_Version_Number IN NUMBER,
2650: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2651: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
2652: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
2653: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2654: p_delta_line_id_tbl IN JTF_NUMBER_TABLE,
2655: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 2692: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2688: l_accum_qp_time NUMBER;
2689:
2690: BEGIN
2691: -- Standard call to check for call compatibility.
2692: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2693: p_api_version_number,
2694: l_api_name,
2695: G_PKG_NAME)
2696: THEN

Line 2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2693: p_api_version_number,
2694: l_api_name,
2695: G_PKG_NAME)
2696: THEN
2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2698: END IF;
2699:
2700: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2701: l_pricing_start_time := dbms_utility.get_time;

Line 2705: x_return_status := FND_API.G_RET_STS_SUCCESS;

2701: l_pricing_start_time := dbms_utility.get_time;
2702: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:Start of Price_Quote_Calculate_Call',1,'Y');
2703: END IF;
2704:
2705: x_return_status := FND_API.G_RET_STS_SUCCESS;
2706:
2707: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2708: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:p_control_rec.request_type:'||p_control_rec.request_type,1,'Y');
2709: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT:p_control_rec.pricing_event:'||p_control_rec.pricing_event,1,'Y');

Line 3056: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3052: (p_control_rec =>l_req_control_rec
3053: ,x_return_status =>l_return_status
3054: ,x_return_status_Text =>l_return_status_Text
3055: );
3056: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3057: x_return_status := l_return_status;
3058: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3059: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
3060: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);

Line 3063: RAISE FND_API.G_EXC_ERROR;

3059: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
3060: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);
3061: FND_MSG_PUB.ADD;
3062: END IF;
3063: RAISE FND_API.G_EXC_ERROR;
3064: END IF;
3065:
3066: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3067: l_pricing_start_time := dbms_utility.get_time;

Line 3079: P_Init_Msg_List => FND_API.G_FALSE,

3075: END IF;
3076:
3077: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
3078: P_Api_Version_Number => 1.0,
3079: P_Init_Msg_List => FND_API.G_FALSE,
3080: P_Commit => FND_API.G_FALSE,
3081: p_control_rec => l_prc_control_rec,
3082: p_qte_header_rec => p_qte_header_rec,
3083: p_insert_type => 'HDR_ONLY',

Line 3080: P_Commit => FND_API.G_FALSE,

3076:
3077: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
3078: P_Api_Version_Number => 1.0,
3079: P_Init_Msg_List => FND_API.G_FALSE,
3080: P_Commit => FND_API.G_FALSE,
3081: p_control_rec => l_prc_control_rec,
3082: p_qte_header_rec => p_qte_header_rec,
3083: p_insert_type => 'HDR_ONLY',
3084: x_return_status => x_return_status,

Line 3091: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3087: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3088: aso_debug_pub.add('ASO_PRICING_FLOWS_PVT: Copy_Price_To_Quote : x_return_status: '
3089: ||nvl(x_return_status,'NULL'),1,'Y');
3090: END IF;
3091: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3092: ASO_PRICING_CORE_PVT.Process_Charges(
3093: P_Api_Version_Number => 1.0,
3094: P_Init_Msg_List => FND_API.G_FALSE,
3095: P_Commit => FND_API.G_FALSE,

Line 3094: P_Init_Msg_List => FND_API.G_FALSE,

3090: END IF;
3091: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3092: ASO_PRICING_CORE_PVT.Process_Charges(
3093: P_Api_Version_Number => 1.0,
3094: P_Init_Msg_List => FND_API.G_FALSE,
3095: P_Commit => FND_API.G_FALSE,
3096: p_control_rec => l_prc_control_rec,
3097: p_qte_header_rec => p_qte_header_rec,
3098: x_return_status => x_return_status,

Line 3095: P_Commit => FND_API.G_FALSE,

3091: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3092: ASO_PRICING_CORE_PVT.Process_Charges(
3093: P_Api_Version_Number => 1.0,
3094: P_Init_Msg_List => FND_API.G_FALSE,
3095: P_Commit => FND_API.G_FALSE,
3096: p_control_rec => l_prc_control_rec,
3097: p_qte_header_rec => p_qte_header_rec,
3098: x_return_status => x_return_status,
3099: x_msg_count => x_msg_count,