DBA Data[Home] [Help]

APPS.PO_MODIFY_REQUISITION_PVT dependencies on PO_MESSAGE_S

Line 251: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);

247: WHEN FND_API.g_exc_unexpected_error THEN
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);

Line 272: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);

268: po_moac_utils_pvt.set_org_context(l_old_org_id);
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);

Line 1210: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);

1206: WHEN OTHERS THEN
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);

Line 1526: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);

1522: p_data => x_msg_data);
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());

Line 1582: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);

1578: WHEN OTHERS THEN
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);

Line 1693: po_message_s.sql_error('No rows inserted into PO_REQ_SPLIT_LINES_GT', d_progress, sqlcode);

1689: IF PO_LOG.d_stmt THEN
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:

Line 1797: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);

1793: END IF;
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;