DBA Data[Home] [Help]

APPS.INV_TRX_UTIL_PUB dependencies on FND_MSG_PUB

Line 91: fnd_msg_pub.ADD;

87:
88: IF (v_acct_period_id = 0)
89: OR(v_acct_period_id = -1) THEN
90: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
91: fnd_msg_pub.ADD;
92: RAISE fnd_api.g_exc_error;
93: END IF;
94:
95: IF (p_trx_action_id = inv_globals.g_action_issue)

Line 246: x_proc_msg := fnd_msg_pub.get(1, 'F');

242:
243: RETURN 0;
244: EXCEPTION
245: WHEN fnd_api.g_exc_error THEN
246: x_proc_msg := fnd_msg_pub.get(1, 'F');
247: RETURN -1;
248: WHEN OTHERS THEN
249: x_proc_msg := SUBSTR(SQLERRM, 1, 200);
250: RETURN -1;

Line 1298: fnd_msg_pub.ADD;

1294: IF l_debug = 1 THEN
1295: inv_log_util.trace('Error: Transaction Temp ID has to be passed', g_pkg_name || '.' || l_api_name, 3);
1296: END IF;
1297: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
1298: fnd_msg_pub.ADD;
1299: RAISE fnd_api.g_exc_error;
1300: END IF;
1301:
1302: -- Not Nullable columns should not be passed as MissNum or MissChar or MissDate

Line 1314: fnd_msg_pub.ADD;

1310: inv_log_util.trace('Error: The passed value will make the Not NULLABLE column NULL', g_pkg_name || '.' || l_api_name, 3);
1311: END IF;
1312: fnd_message.set_name('INV','INV_DATA_ERROR');
1313: fnd_message.set_token('ENTITY',l_api_name);
1314: fnd_msg_pub.ADD;
1315: RAISE fnd_api.g_exc_error;
1316: END IF;
1317:
1318: -- Querying MMTT to get some required values.

Line 1348: fnd_msg_pub.ADD;

1344: invttmtx.tdatechk(l_organization_id, l_transaction_date, l_acct_period_id, l_open_past_period);
1345: IF l_acct_period_id = -1 OR l_acct_period_id = 0 THEN
1346: inv_log_util.trace('Error: Period is not open for the Organization', g_pkg_name || '.' || l_api_name, 3);
1347: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
1348: fnd_msg_pub.ADD;
1349: RAISE fnd_api.g_exc_error;
1350: END IF;
1351:
1352: -- Conversion between Primary Qty and Transaction Qty

Line 1359: fnd_msg_pub.ADD;

1355: FETCH c_item_info INTO l_primary_uom;
1356: IF c_item_info%NOTFOUND THEN
1357: CLOSE c_item_info;
1358: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');
1359: fnd_msg_pub.ADD;
1360: RAISE fnd_api.g_exc_error;
1361: END IF;
1362: CLOSE c_item_info;
1363:

Line 1379: fnd_msg_pub.ADD;

1375: fnd_message.set_name('INV','INV_UOM_CONVERSION_ERROR');
1376: fnd_message.set_token('UOM1',l_transaction_uom);
1377: fnd_message.set_token('UOM2',l_primary_uom);
1378: fnd_message.set_token('MODULE',l_api_name);
1379: fnd_msg_pub.ADD;
1380: RAISE fnd_api.g_exc_error;
1381: END IF;
1382: ELSIF l_txn_qty IS NULL AND l_primary_qty IS NOT NULL THEN
1383: l_txn_qty := inv_convert.inv_um_convert(

Line 1397: fnd_msg_pub.ADD;

1393: fnd_message.set_name('INV','INV_UOM_CONVERSION_ERROR');
1394: fnd_message.set_token('UOM1',l_primary_uom);
1395: fnd_message.set_token('UOM2',l_transaction_uom);
1396: fnd_message.set_token('MODULE',l_api_name);
1397: fnd_msg_pub.ADD;
1398: RAISE fnd_api.g_exc_error;
1399: END IF;
1400: END IF;
1401: END IF;

Line 1803: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1799: END IF;
1800: EXCEPTION
1801: WHEN fnd_api.g_exc_error THEN
1802: x_return_status := fnd_api.g_ret_sts_error;
1803: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1804: WHEN fnd_api.g_exc_unexpected_error THEN
1805: x_return_status := fnd_api.g_ret_sts_unexp_error;
1806: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1807: WHEN OTHERS THEN

Line 1806: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1802: x_return_status := fnd_api.g_ret_sts_error;
1803: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1804: WHEN fnd_api.g_exc_unexpected_error THEN
1805: x_return_status := fnd_api.g_ret_sts_unexp_error;
1806: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1807: WHEN OTHERS THEN
1808: x_return_status := fnd_api.g_ret_sts_unexp_error;
1809: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1810: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 1809: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1805: x_return_status := fnd_api.g_ret_sts_unexp_error;
1806: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1807: WHEN OTHERS THEN
1808: x_return_status := fnd_api.g_ret_sts_unexp_error;
1809: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1810: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1811: END IF;
1812: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1813: END copy_insert_line_trx;

Line 1810: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

1806: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1807: WHEN OTHERS THEN
1808: x_return_status := fnd_api.g_ret_sts_unexp_error;
1809: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1810: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1811: END IF;
1812: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1813: END copy_insert_line_trx;
1814:

Line 1812: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1808: x_return_status := fnd_api.g_ret_sts_unexp_error;
1809: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1810: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1811: END IF;
1812: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1813: END copy_insert_line_trx;
1814:
1815:
1816: -- Name: DELETE_SER_TRX