DBA Data[Home] [Help]

APPS.PO_MODIFY_REQUISITION_PVT dependencies on FND_MSG_PUB

Line 196: FND_MSG_PUB.Add;

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);
200: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;

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

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);
200: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;
201: x_return_status := FND_API.g_ret_sts_error;

Line 217: FND_MSG_PUB.Add;

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);
221: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;

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

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);
221: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;
222:

Line 770: FND_MSG_PUB.Add;

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);
774: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;

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

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);
774: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 954: FND_MSG_PUB.Add;

950: FOR i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT LOOP
951: l_message_text := l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i);
952: FND_MESSAGE.set_name('PO','PO_CUSTOM_MSG');
953: FND_MESSAGE.set_token('TRANSLATED_TOKEN',l_message_text);
954: FND_MSG_PUB.Add;
955: END LOOP;
956:
957: RAISE FND_API.G_EXC_ERROR;
958:

Line 961: FND_MSG_PUB.Add;

957: RAISE FND_API.G_EXC_ERROR;
958:
959: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
960: FND_MESSAGE.set_name('PO','PO_PDOI_TAX_CALCULATION_ERR');
961: FND_MSG_PUB.Add;
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963: END IF;--l_return_status
964: --
965:

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

1044: END IF;
1045: EXCEPTION
1046: WHEN FND_API.g_exc_unexpected_error THEN
1047: ROLLBACK TO post_requisition_lines_PVT;
1048: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1049: p_data => x_msg_data);
1050: IF(x_msg_count>0)THEN
1051: NULL;
1052: ELSE

Line 1054: FND_MSG_PUB.Add;

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());
1058: x_msg_data := FND_MESSAGE.get;

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

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());
1058: x_msg_data := FND_MESSAGE.get;
1059: x_error_msg_tbl.extend(1);
1060: x_error_msg_tbl(x_error_msg_tbl.COUNT) := x_msg_data;
1061:

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

1070: END IF;
1071: WHEN FND_API.g_exc_error THEN
1072: ROLLBACK TO post_requisition_lines_PVT;
1073:
1074: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1075: p_data => x_msg_data);
1076:
1077: IF l_online_report_id IS NOT NULL THEN
1078: PO_Document_Control_PVT.add_online_report_msgs

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

1082: ,x_return_status => x_return_status
1083: ,p_online_report_id => l_online_report_id);
1084: END IF;
1085:
1086: FOR i IN 1..FND_MSG_PUB.count_msg loop
1087: FND_MESSAGE.set_encoded(encoded_message =>
1088: FND_MSG_PUB.get(p_msg_index => i));
1089: x_error_msg_tbl.extend(1);
1090: x_error_msg_tbl(i) := FND_MESSAGE.get;

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

1084: END IF;
1085:
1086: FOR i IN 1..FND_MSG_PUB.count_msg loop
1087: FND_MESSAGE.set_encoded(encoded_message =>
1088: FND_MSG_PUB.get(p_msg_index => i));
1089: x_error_msg_tbl.extend(1);
1090: x_error_msg_tbl(i) := FND_MESSAGE.get;
1091: END LOOP;
1092: --

Line 1110: FND_MSG_PUB.Add;

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);
1114: x_error_msg_tbl(1) := x_msg_data;

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

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);
1114: x_error_msg_tbl(1) := x_msg_data;
1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1221: FND_MSG_PUB.add;

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:
1225: d_progress := 40;

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

1272: END IF;
1273:
1274: -- Standard call to get message count and if count is 1,
1275: -- get message info.
1276: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1277: x_return_status := FND_API.G_RET_STS_SUCCESS;
1278:
1279: d_progress := 70;
1280:

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

1290: WHEN FND_API.g_exc_unexpected_error THEN
1291:
1292: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1293:
1294: x_msg_data := FND_MSG_PUB.GET();
1295: x_return_status := FND_API.g_ret_sts_unexp_error;
1296:
1297: IF (PO_LOG.d_exc) THEN
1298: PO_LOG.exc(d_module_base, d_progress, SQLCODE || SQLERRM);

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

1307: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1308:
1309: x_return_status := FND_API.g_ret_sts_error;
1310:
1311: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1312: p_data => x_msg_data);
1313:
1314: IF (PO_LOG.d_exc) THEN
1315: PO_LOG.exc(d_module_base, d_progress, SQLCODE || SQLERRM);

Line 1325: FND_MSG_PUB.Add;

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;
1329: x_msg_data := FND_MESSAGE.get;

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

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;
1329: x_msg_data := FND_MESSAGE.get;
1330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1328: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1329: x_msg_data := FND_MESSAGE.get;
1330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1331:
1332: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1333: p_data => x_msg_data);
1334:
1335: IF (PO_LOG.d_exc) THEN
1336: PO_LOG.exc(d_module_base, d_progress, SQLCODE || SQLERRM);