DBA Data[Home] [Help]

APPS.PO_MODIFY_REQUISITION_PVT dependencies on FND_MSG_PUB

Line 252: FND_MSG_PUB.Add;

248: ROLLBACK TO split_requisition_lines_PVT;
249: po_moac_utils_pvt.set_org_context(l_old_org_id);
250:
251: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
252: FND_MSG_PUB.Add;
253: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
254: x_msg_data := FND_MESSAGE.get;
255: x_error_msg_tbl.extend(1);
256: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;

Line 253: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());

249: po_moac_utils_pvt.set_org_context(l_old_org_id);
250:
251: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
252: FND_MSG_PUB.Add;
253: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
254: x_msg_data := FND_MESSAGE.get;
255: x_error_msg_tbl.extend(1);
256: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;
257: x_return_status := FND_API.g_ret_sts_error;

Line 273: FND_MSG_PUB.Add;

269:
270: BEGIN
271: -- Log a debug message, add the error the the API message list.
272: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
273: FND_MSG_PUB.Add;
274: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
275: x_msg_data := FND_MESSAGE.get;
276: x_error_msg_tbl.extend(1);
277: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;

Line 274: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());

270: BEGIN
271: -- Log a debug message, add the error the the API message list.
272: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
273: FND_MSG_PUB.Add;
274: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
275: x_msg_data := FND_MESSAGE.get;
276: x_error_msg_tbl.extend(1);
277: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;
278:

Line 1211: FND_MSG_PUB.Add;

1207: ROLLBACK TO create_requisition_lines_PVT;
1208: BEGIN
1209: -- Log a debug message, add the error the the API message list.
1210: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
1211: FND_MSG_PUB.Add;
1212: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
1213: x_msg_data := FND_MESSAGE.get;
1214: x_error_msg_tbl.extend(1);
1215: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;

Line 1212: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());

1208: BEGIN
1209: -- Log a debug message, add the error the the API message list.
1210: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
1211: FND_MSG_PUB.Add;
1212: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
1213: x_msg_data := FND_MESSAGE.get;
1214: x_error_msg_tbl.extend(1);
1215: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1397: FND_MSG_PUB.Add;

1393: FOR i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT LOOP
1394: l_message_text := l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i);
1395: FND_MESSAGE.set_name('PO','PO_CUSTOM_MSG');
1396: FND_MESSAGE.set_token('TRANSLATED_TOKEN',l_message_text);
1397: FND_MSG_PUB.Add;
1398: END LOOP;
1399:
1400: RAISE FND_API.G_EXC_ERROR;
1401:

Line 1404: FND_MSG_PUB.Add;

1400: RAISE FND_API.G_EXC_ERROR;
1401:
1402: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1403: FND_MESSAGE.set_name('PO','PO_PDOI_TAX_CALCULATION_ERR');
1404: FND_MSG_PUB.Add;
1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1406: END IF;--l_return_status
1407: --
1408:

Line 1521: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1517: END IF;
1518: EXCEPTION
1519: WHEN FND_API.g_exc_unexpected_error THEN
1520: ROLLBACK TO post_requisition_lines_PVT;
1521: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1522: p_data => x_msg_data);
1523: IF(x_msg_count>0)THEN
1524: NULL;
1525: ELSE

Line 1527: FND_MSG_PUB.Add;

1523: IF(x_msg_count>0)THEN
1524: NULL;
1525: ELSE
1526: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
1527: FND_MSG_PUB.Add;
1528: END IF;
1529:
1530: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
1531: x_msg_data := FND_MESSAGE.get;

Line 1530: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());

1526: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
1527: FND_MSG_PUB.Add;
1528: END IF;
1529:
1530: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
1531: x_msg_data := FND_MESSAGE.get;
1532: x_error_msg_tbl.extend(1);
1533: x_error_msg_tbl(x_error_msg_tbl.COUNT) := x_msg_data;
1534:

Line 1547: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1543: END IF;
1544: WHEN FND_API.g_exc_error THEN
1545: ROLLBACK TO post_requisition_lines_PVT;
1546:
1547: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1548: p_data => x_msg_data);
1549:
1550: IF l_online_report_id IS NOT NULL THEN
1551: PO_Document_Control_PVT.add_online_report_msgs

Line 1559: FOR i IN 1..FND_MSG_PUB.count_msg loop

1555: ,x_return_status => x_return_status
1556: ,p_online_report_id => l_online_report_id);
1557: END IF;
1558:
1559: FOR i IN 1..FND_MSG_PUB.count_msg loop
1560: FND_MESSAGE.set_encoded(encoded_message =>
1561: FND_MSG_PUB.get(p_msg_index => i));
1562: x_error_msg_tbl.extend(1);
1563: x_error_msg_tbl(i) := FND_MESSAGE.get;

Line 1561: FND_MSG_PUB.get(p_msg_index => i));

1557: END IF;
1558:
1559: FOR i IN 1..FND_MSG_PUB.count_msg loop
1560: FND_MESSAGE.set_encoded(encoded_message =>
1561: FND_MSG_PUB.get(p_msg_index => i));
1562: x_error_msg_tbl.extend(1);
1563: x_error_msg_tbl(i) := FND_MESSAGE.get;
1564: END LOOP;
1565: --

Line 1583: FND_MSG_PUB.Add;

1579: ROLLBACK TO post_requisition_lines_PVT;
1580: BEGIN
1581: -- Log a debug message, add the error the the API message list.
1582: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
1583: FND_MSG_PUB.Add;
1584: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
1585: x_msg_data := FND_MESSAGE.get;
1586: x_error_msg_tbl.extend(1);
1587: x_error_msg_tbl(1) := x_msg_data;

Line 1584: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());

1580: BEGIN
1581: -- Log a debug message, add the error the the API message list.
1582: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
1583: FND_MSG_PUB.Add;
1584: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
1585: x_msg_data := FND_MESSAGE.get;
1586: x_error_msg_tbl.extend(1);
1587: x_error_msg_tbl(1) := x_msg_data;
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1694: FND_MSG_PUB.add;

1690: PO_LOG.stmt(d_module_base,d_progress,'No rows inserted into PO_REQ_SPLIT_LINES_GT');
1691: END IF;
1692:
1693: po_message_s.sql_error('No rows inserted into PO_REQ_SPLIT_LINES_GT', d_progress, sqlcode);
1694: FND_MSG_PUB.add;
1695: RAISE FND_API.g_exc_unexpected_error;
1696: END IF;
1697:
1698: d_progress := 40;

Line 1749: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1745: END IF;
1746:
1747: -- Standard call to get message count and if count is 1,
1748: -- get message info.
1749: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1750: x_return_status := FND_API.G_RET_STS_SUCCESS;
1751:
1752: d_progress := 70;
1753:

Line 1767: x_msg_data := FND_MSG_PUB.GET();

1763: WHEN FND_API.g_exc_unexpected_error THEN
1764:
1765: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1766:
1767: x_msg_data := FND_MSG_PUB.GET();
1768: x_return_status := FND_API.g_ret_sts_unexp_error;
1769:
1770: IF (PO_LOG.d_exc) THEN
1771: PO_LOG.exc(d_module_base, d_progress, SQLCODE || SQLERRM);

Line 1784: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1780: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1781:
1782: x_return_status := FND_API.g_ret_sts_error;
1783:
1784: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1785: p_data => x_msg_data);
1786:
1787: IF (PO_LOG.d_exc) THEN
1788: PO_LOG.exc(d_module_base, d_progress, SQLCODE || SQLERRM);

Line 1798: FND_MSG_PUB.Add;

1794:
1795: WHEN OTHERS THEN
1796:
1797: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
1798: FND_MSG_PUB.Add;
1799: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
1800:
1801: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1802: x_msg_data := FND_MESSAGE.get;

Line 1799: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());

1795: WHEN OTHERS THEN
1796:
1797: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
1798: FND_MSG_PUB.Add;
1799: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
1800:
1801: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1802: x_msg_data := FND_MESSAGE.get;
1803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1805: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

1801: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1802: x_msg_data := FND_MESSAGE.get;
1803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1804:
1805: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1806: p_data => x_msg_data);
1807:
1808: IF (PO_LOG.d_exc) THEN
1809: PO_LOG.exc(d_module_base, d_progress, SQLCODE || SQLERRM);