DBA Data[Home] [Help]

APPS.PO_MODIFY_REQUISITION_PVT dependencies on PO_MESSAGE_S

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

191: WHEN FND_API.g_exc_unexpected_error THEN
192: ROLLBACK TO split_requisition_lines_PVT;
193: po_moac_utils_pvt.set_org_context(l_old_org_id);
194:
195: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
196: FND_MSG_PUB.Add;
197: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
198: x_msg_data := FND_MESSAGE.get;
199: x_error_msg_tbl.extend(1);

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

212: po_moac_utils_pvt.set_org_context(l_old_org_id);
213:
214: BEGIN
215: -- Log a debug message, add the error the the API message list.
216: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
217: FND_MSG_PUB.Add;
218: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
219: x_msg_data := FND_MESSAGE.get;
220: x_error_msg_tbl.extend(1);

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

765: WHEN OTHERS THEN
766: ROLLBACK TO create_requisition_lines_PVT;
767: BEGIN
768: -- Log a debug message, add the error the the API message list.
769: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
770: FND_MSG_PUB.Add;
771: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
772: x_msg_data := FND_MESSAGE.get;
773: x_error_msg_tbl.extend(1);

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

1049: p_data => x_msg_data);
1050: IF(x_msg_count>0)THEN
1051: NULL;
1052: ELSE
1053: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
1054: FND_MSG_PUB.Add;
1055: END IF;
1056:
1057: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());

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

1105: WHEN OTHERS THEN
1106: ROLLBACK TO post_requisition_lines_PVT;
1107: BEGIN
1108: -- Log a debug message, add the error the the API message list.
1109: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
1110: FND_MSG_PUB.Add;
1111: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
1112: x_msg_data := FND_MESSAGE.get;
1113: x_error_msg_tbl.extend(1);

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

1216: IF PO_LOG.d_stmt THEN
1217: PO_LOG.stmt(d_module_base,d_progress,'No rows inserted into PO_REQ_SPLIT_LINES_GT');
1218: END IF;
1219:
1220: po_message_s.sql_error('No rows inserted into PO_REQ_SPLIT_LINES_GT', d_progress, sqlcode);
1221: FND_MSG_PUB.add;
1222: RAISE FND_API.g_exc_unexpected_error;
1223: END IF;
1224:

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

1320: END IF;
1321:
1322: WHEN OTHERS THEN
1323:
1324: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);
1325: FND_MSG_PUB.Add;
1326: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
1327:
1328: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;