DBA Data[Home] [Help]

APPS.PO_ADVANCED_PRICE_PVT dependencies on FND_API

Line 373: -- FND_API.G_RET_STS_SUCCESS if API succeeds

369: -- Base Unit Price.
370: --x_unit_price
371: -- Adjusted Unit Price.
372: --x_return_status
373: -- FND_API.G_RET_STS_SUCCESS if API succeeds
374: -- FND_API.G_RET_STS_ERROR if API fails
375: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
376: --Testing:
377: --

Line 374: -- FND_API.G_RET_STS_ERROR if API fails

370: --x_unit_price
371: -- Adjusted Unit Price.
372: --x_return_status
373: -- FND_API.G_RET_STS_SUCCESS if API succeeds
374: -- FND_API.G_RET_STS_ERROR if API fails
375: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
376: --Testing:
377: --
378: --End of Comments

Line 375: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

371: -- Adjusted Unit Price.
372: --x_return_status
373: -- FND_API.G_RET_STS_SUCCESS if API succeeds
374: -- FND_API.G_RET_STS_ERROR if API fails
375: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
376: --Testing:
377: --
378: --End of Comments
379: -------------------------------------------------------------------------------

Line 484: x_return_status := FND_API.G_RET_STS_SUCCESS;

480:
481: BEGIN
482:
483: -- Initialize OUT parameters
484: x_return_status := FND_API.G_RET_STS_SUCCESS;
485: x_base_unit_price := p_unit_price;
486: x_unit_price := p_unit_price;
487: l_draft_id := p_draft_id; --Enhanced Pricing
488:

Line 732: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

728: PO_DEBUG.debug_var(l_log_head, l_progress, 'x_return_status', x_return_status);
729: PO_DEBUG.debug_var(l_log_head, l_progress, 'l_return_status_text', l_return_status_text);
730: END IF;
731:
732: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
733: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
734: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
735: FND_MSG_PUB.Add;
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

732: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
733: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
734: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
735: FND_MSG_PUB.Add;
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
738: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
739: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
740: FND_MSG_PUB.Add;

Line 737: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

733: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
734: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
735: FND_MSG_PUB.Add;
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
738: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
739: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
740: FND_MSG_PUB.Add;
741: RAISE FND_API.G_EXC_ERROR;

Line 741: RAISE FND_API.G_EXC_ERROR;

737: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
738: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
739: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
740: FND_MSG_PUB.Add;
741: RAISE FND_API.G_EXC_ERROR;
742: END IF;
743:
744: -- Don't call QP_PREQ_GRP.INSERT_LINE_ATTRS2 since PO has no
745: -- ASK_FOR attributes

Line 815: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

811: PO_DEBUG.debug_var(l_log_head, l_progress, 'x_return_status', x_return_status);
812: PO_DEBUG.debug_var(l_log_head, l_progress, 'l_return_status_text', l_return_status_text);
813: END IF;
814:
815: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
816: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
817: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
818: FND_MSG_PUB.Add;
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

815: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
816: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
817: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
818: FND_MSG_PUB.Add;
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
821: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
822: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
823: FND_MSG_PUB.Add;

Line 820: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

816: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
817: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
818: FND_MSG_PUB.Add;
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
821: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
822: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
823: FND_MSG_PUB.Add;
824: RAISE FND_API.G_EXC_ERROR;

Line 824: RAISE FND_API.G_EXC_ERROR;

820: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
821: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
822: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
823: FND_MSG_PUB.Add;
824: RAISE FND_API.G_EXC_ERROR;
825: END IF;
826:
827: --Enhanced Pricing Start:
828: --Bug:8598002 renamed p_retro_pricing to p_pricing_call_src, to distinguish calls from retro and auto creation

Line 863: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

859: , x_msg_data => l_msg_data
860: );
861:
862: l_progress := '230';
863: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
864: PO_DEBUG.debug_var(l_log_head, l_progress, 'l_return_status', l_return_status);
865: PO_DEBUG.debug_unexp(l_log_head, l_progress,'audit_qp_price_adjustment errors out');
866: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
867: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_msg_data);

Line 869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

865: PO_DEBUG.debug_unexp(l_log_head, l_progress,'audit_qp_price_adjustment errors out');
866: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
867: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_msg_data);
868: FND_MSG_PUB.Add;
869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
870: END IF;
871: --
872:
873: l_progress := '240';

Line 917: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

913: END IF;
914:
915: x_unit_price := NVL(x_unit_price, x_base_unit_price);
916:
917: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
918: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
919: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_price_status_text);
920: x_return_status := FND_API.g_ret_sts_error;
921: END IF;

Line 920: x_return_status := FND_API.g_ret_sts_error;

916:
917: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
918: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
919: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_price_status_text);
920: x_return_status := FND_API.g_ret_sts_error;
921: END IF;
922:
923: l_progress := '300';
924: IF g_debug_stmt THEN

Line 935: WHEN FND_API.G_EXC_ERROR THEN

931: x_unit_price);
932: END IF;
933:
934: EXCEPTION
935: WHEN FND_API.G_EXC_ERROR THEN
936: --raised expected error: assume raiser already pushed onto the stack
937: l_exception_msg := FND_MSG_PUB.get(
938: p_msg_index => FND_MSG_PUB.G_LAST
939: , p_encoded => 'F'

Line 945: x_return_status := FND_API.g_ret_sts_error;

941: IF g_debug_unexp THEN
942: PO_DEBUG.debug_var(l_log_head, l_progress, 'l_exception_msg',
943: l_exception_msg);
944: END IF;
945: x_return_status := FND_API.g_ret_sts_error;
946: -- Push the po_return_msg onto msg list and message stack
947: FND_MESSAGE.set_name('PO', 'PO_QP_PRICE_API_ERROR');
948: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_exception_msg);
949:

Line 950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

946: -- Push the po_return_msg onto msg list and message stack
947: FND_MESSAGE.set_name('PO', 'PO_QP_PRICE_API_ERROR');
948: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_exception_msg);
949:
950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
951: --raised unexpected error: assume raiser already pushed onto the stack
952: l_exception_msg := FND_MSG_PUB.get(
953: p_msg_index => FND_MSG_PUB.G_LAST
954: , p_encoded => 'F'

Line 960: x_return_status := FND_API.g_ret_sts_unexp_error;

956: IF g_debug_unexp THEN
957: PO_DEBUG.debug_var(l_log_head, l_progress, 'l_exception_msg',
958: l_exception_msg);
959: END IF;
960: x_return_status := FND_API.g_ret_sts_unexp_error;
961: -- Push the po_return_msg onto msg list and message stack
962: FND_MESSAGE.set_name('PO', 'PO_QP_PRICE_API_ERROR');
963: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_exception_msg);
964:

Line 976: x_return_status := FND_API.g_ret_sts_unexp_error;

972: IF g_debug_unexp THEN
973: PO_DEBUG.debug_var(l_log_head, l_progress, 'l_exception_msg',
974: l_exception_msg);
975: END IF;
976: x_return_status := FND_API.g_ret_sts_unexp_error;
977: -- Push the po_return_msg onto msg list and message stack
978: FND_MESSAGE.set_name('PO', 'PO_QP_PRICE_API_ERROR');
979: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_exception_msg);
980: END get_advanced_price;

Line 1155: x_return_status := FND_API.G_RET_STS_SUCCESS;

1151: l_freight_charge_rec_tbl Freight_Charges_Rec_Tbl_Type;
1152: BEGIN
1153:
1154: -- Initialize OUT parameters
1155: x_return_status := FND_API.G_RET_STS_SUCCESS;
1156: IF g_debug_stmt THEN
1157: PO_LOG.proc_begin(l_log_head);
1158: PO_LOG.proc_begin(l_log_head, 'p_header_rec.org_id', p_header_rec.org_id);
1159: PO_LOG.proc_begin(l_log_head, 'p_header_rec.p_order_header_id', p_header_rec.p_order_header_id);

Line 1512: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1508: PO_LOG.stmt(l_log_head, d_pos, 'x_return_status', x_return_status);
1509: PO_LOG.stmt(l_log_head, d_pos, 'l_return_status_text', l_return_status_text);
1510: END IF;
1511:
1512: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1513: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
1514: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
1515: FND_MSG_PUB.Add;
1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1512: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1513: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
1514: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
1515: FND_MSG_PUB.Add;
1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1517: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1518: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
1519: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
1520: FND_MSG_PUB.Add;

Line 1517: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1513: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
1514: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
1515: FND_MSG_PUB.Add;
1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1517: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1518: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
1519: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
1520: FND_MSG_PUB.Add;
1521: RAISE FND_API.G_EXC_ERROR;

Line 1521: RAISE FND_API.G_EXC_ERROR;

1517: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1518: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
1519: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
1520: FND_MSG_PUB.Add;
1521: RAISE FND_API.G_EXC_ERROR;
1522: END IF;
1523:
1524: -- Don't call QP_PREQ_GRP.INSERT_LINE_ATTRS2 since PO has no
1525: -- ASK_FOR attributes

Line 1563: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1559: PO_LOG.stmt(l_log_head, d_pos, 'x_return_status', x_return_status);
1560: PO_LOG.stmt(l_log_head, d_pos, 'l_return_status_text', l_return_status_text);
1561: END IF;
1562:
1563: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1564: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
1565: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
1566: FND_MSG_PUB.Add;
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1563: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1564: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
1565: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
1566: FND_MSG_PUB.Add;
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1569: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
1570: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
1571: FND_MSG_PUB.Add;

Line 1568: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1564: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
1565: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
1566: FND_MSG_PUB.Add;
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1569: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
1570: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
1571: FND_MSG_PUB.Add;
1572: RAISE FND_API.G_EXC_ERROR;

Line 1572: RAISE FND_API.G_EXC_ERROR;

1568: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1569: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
1570: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
1571: FND_MSG_PUB.Add;
1572: RAISE FND_API.G_EXC_ERROR;
1573: END IF;
1574:
1575: /** No custom price hook for receiving.. need to
1576: incorporate it. whenever we are planning to use

Line 1589: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1585: , x_msg_data => l_msg_data
1586: );
1587:
1588: l_progress := '230';
1589: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1590: PO_DEBUG.debug_var(l_log_head,l_progress,'l_return_status',l_return_status);
1591: PO_DEBUG.debug_unexp(l_log_head,l_progress,'audit_qp_price_adjustment errors out');
1592: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1593: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_msg_data);

Line 1595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1591: PO_DEBUG.debug_unexp(l_log_head,l_progress,'audit_qp_price_adjustment errors out');
1592: FND_MESSAGE.SET_NAME('PO','PO_QP_PRICE_API_ERROR');
1593: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_msg_data);
1594: FND_MSG_PUB.Add;
1595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1596: END IF;
1597: */
1598:
1599: d_pos := 240;

Line 1694: WHEN FND_API.G_EXC_ERROR THEN

1690: PO_LOG.proc_end(l_log_head, 'x_price_tbl(' || j || ').pricing_status_text', x_price_tbl(j).pricing_status_text);
1691: END LOOP;
1692: END IF;
1693: EXCEPTION
1694: WHEN FND_API.G_EXC_ERROR THEN
1695: --raised expected error: assume raiser already pushed onto the stack
1696: l_exception_msg := FND_MSG_PUB.get(
1697: p_msg_index => FND_MSG_PUB.G_LAST
1698: , p_encoded => 'F'

Line 1703: x_return_status := FND_API.g_ret_sts_error;

1699: );
1700: IF g_debug_unexp THEN
1701: PO_LOG.exc(l_log_head, d_pos, l_exception_msg);
1702: END IF;
1703: x_return_status := FND_API.g_ret_sts_error;
1704: -- Push the po_return_msg onto msg list and message stack
1705: FND_MESSAGE.set_name('PO', 'PO_QP_PRICE_API_ERROR');
1706: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_exception_msg);
1707:

Line 1708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1704: -- Push the po_return_msg onto msg list and message stack
1705: FND_MESSAGE.set_name('PO', 'PO_QP_PRICE_API_ERROR');
1706: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_exception_msg);
1707:
1708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1709: --raised unexpected error: assume raiser already pushed onto the stack
1710: l_exception_msg := FND_MSG_PUB.get(
1711: p_msg_index => FND_MSG_PUB.G_LAST
1712: , p_encoded => 'F'

Line 1717: x_return_status := FND_API.g_ret_sts_unexp_error;

1713: );
1714: IF g_debug_unexp THEN
1715: PO_LOG.exc(l_log_head, d_pos, l_exception_msg);
1716: END IF;
1717: x_return_status := FND_API.g_ret_sts_unexp_error;
1718: -- Push the po_return_msg onto msg list and message stack
1719: FND_MESSAGE.set_name('PO', 'PO_QP_PRICE_API_ERROR');
1720: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_exception_msg);
1721:

Line 1732: x_return_status := FND_API.g_ret_sts_unexp_error;

1728: l_exception_msg := FND_MESSAGE.get;
1729: IF g_debug_unexp THEN
1730: PO_LOG.exc(l_log_head, d_pos, l_exception_msg);
1731: END IF;
1732: x_return_status := FND_API.g_ret_sts_unexp_error;
1733: -- Push the po_return_msg onto msg list and message stack
1734: FND_MESSAGE.set_name('PO', 'PO_QP_PRICE_API_ERROR');
1735: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_exception_msg);
1736: END get_advanced_price;

Line 1799: -- FND_API.G_RET_STS_SUCCESS if API succeeds

1795: --p_unit_price
1796: -- Unit Price.
1797: --OUT:
1798: --x_return_status
1799: -- FND_API.G_RET_STS_SUCCESS if API succeeds
1800: -- FND_API.G_RET_STS_ERROR if API fails
1801: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1802: --Testing:
1803: --

Line 1800: -- FND_API.G_RET_STS_ERROR if API fails

1796: -- Unit Price.
1797: --OUT:
1798: --x_return_status
1799: -- FND_API.G_RET_STS_SUCCESS if API succeeds
1800: -- FND_API.G_RET_STS_ERROR if API fails
1801: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1802: --Testing:
1803: --
1804: --End of Comments

Line 1801: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

1797: --OUT:
1798: --x_return_status
1799: -- FND_API.G_RET_STS_SUCCESS if API succeeds
1800: -- FND_API.G_RET_STS_ERROR if API fails
1801: -- FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1802: --Testing:
1803: --
1804: --End of Comments
1805: -------------------------------------------------------------------------------

Line 1892: x_return_status := FND_API.G_RET_STS_SUCCESS;

1888:
1889: BEGIN
1890:
1891: --Initialize OUT parameters
1892: x_return_status := FND_API.G_RET_STS_SUCCESS;
1893:
1894: IF g_debug_stmt THEN
1895: PO_DEBUG.debug_begin(l_log_head);
1896: PO_DEBUG.debug_var(l_log_head, l_progress, 'p_org_id', p_org_id);

Line 2125: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2121: PO_DEBUG.debug_var(l_log_head, l_progress, 'x_return_status', x_return_status);
2122: PO_DEBUG.debug_var(l_log_head, l_progress, 'l_return_status_text', l_return_status_text);
2123: END IF;
2124:
2125: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2126: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
2127: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
2128: FND_MSG_PUB.Add;
2129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2125: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2126: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
2127: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
2128: FND_MSG_PUB.Add;
2129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2130: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2131: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
2132: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
2133: FND_MSG_PUB.Add;

Line 2130: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2126: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
2127: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
2128: FND_MSG_PUB.Add;
2129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2130: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2131: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
2132: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
2133: FND_MSG_PUB.Add;
2134: RAISE FND_API.G_EXC_ERROR;

Line 2134: RAISE FND_API.G_EXC_ERROR;

2130: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2131: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
2132: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
2133: FND_MSG_PUB.Add;
2134: RAISE FND_API.G_EXC_ERROR;
2135: END IF;
2136:
2137: -- Don't call QP_PREQ_GRP.INSERT_LINE_ATTRS2 since PO has no
2138: -- ASK_FOR attributes

Line 2178: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2174: PO_DEBUG.debug_var(l_log_head, l_progress, 'x_return_status', x_return_status);
2175: PO_DEBUG.debug_var(l_log_head, l_progress, 'l_return_status_text', l_return_status_text);
2176: END IF;
2177:
2178: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2179: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
2180: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
2181: FND_MSG_PUB.Add;
2182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2178: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2179: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
2180: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
2181: FND_MSG_PUB.Add;
2182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2183: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2184: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
2185: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
2186: FND_MSG_PUB.Add;

Line 2183: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2179: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
2180: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
2181: FND_MSG_PUB.Add;
2182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2183: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2184: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
2185: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
2186: FND_MSG_PUB.Add;
2187: RAISE FND_API.G_EXC_ERROR;

Line 2187: RAISE FND_API.G_EXC_ERROR;

2183: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2184: FND_MESSAGE.SET_NAME('PO', 'PO_QP_PRICE_API_ERROR');
2185: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_return_status_text);
2186: FND_MSG_PUB.Add;
2187: RAISE FND_API.G_EXC_ERROR;
2188: END IF;
2189:
2190: l_progress := '240';
2191: IF g_debug_stmt THEN

Line 2204: WHEN FND_API.G_EXC_ERROR THEN

2200: PO_DEBUG.debug_var(l_log_head, l_progress, 'x_return_status', x_return_status);
2201: END IF;
2202:
2203: EXCEPTION
2204: WHEN FND_API.G_EXC_ERROR THEN
2205: --raised expected error: assume raiser already pushed onto the stack
2206: l_exception_msg := FND_MSG_PUB.get(
2207: p_msg_index => FND_MSG_PUB.G_LAST
2208: , p_encoded => 'F'

Line 2214: x_return_status := FND_API.g_ret_sts_error;

2210: IF g_debug_unexp THEN
2211: PO_DEBUG.debug_var(l_log_head, l_progress, 'l_exception_msg',
2212: l_exception_msg);
2213: END IF;
2214: x_return_status := FND_API.g_ret_sts_error;
2215: -- Push the po_return_msg onto msg list and message stack
2216: FND_MESSAGE.set_name('PO', 'PO_QP_PRICE_API_ERROR');
2217: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_exception_msg);
2218:

Line 2219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2215: -- Push the po_return_msg onto msg list and message stack
2216: FND_MESSAGE.set_name('PO', 'PO_QP_PRICE_API_ERROR');
2217: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_exception_msg);
2218:
2219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2220: --raised unexpected error: assume raiser already pushed onto the stack
2221: l_exception_msg := FND_MSG_PUB.get(
2222: p_msg_index => FND_MSG_PUB.G_LAST
2223: , p_encoded => 'F'

Line 2229: x_return_status := FND_API.g_ret_sts_unexp_error;

2225: IF g_debug_unexp THEN
2226: PO_DEBUG.debug_var(l_log_head, l_progress, 'l_exception_msg',
2227: l_exception_msg);
2228: END IF;
2229: x_return_status := FND_API.g_ret_sts_unexp_error;
2230: -- Push the po_return_msg onto msg list and message stack
2231: FND_MESSAGE.set_name('PO', 'PO_QP_PRICE_API_ERROR');
2232: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_exception_msg);
2233:

Line 2245: x_return_status := FND_API.g_ret_sts_unexp_error;

2241: IF g_debug_unexp THEN
2242: PO_DEBUG.debug_var(l_log_head, l_progress, 'l_exception_msg',
2243: l_exception_msg);
2244: END IF;
2245: x_return_status := FND_API.g_ret_sts_unexp_error;
2246: -- Push the po_return_msg onto msg list and message stack
2247: FND_MESSAGE.set_name('PO', 'PO_QP_PRICE_API_ERROR');
2248: FND_MESSAGE.SET_TOKEN('ERROR_TEXT', l_exception_msg);
2249: END call_pricing_manual_modifier;