DBA Data[Home] [Help]

APPS.INV_TRX_UTIL_PUB dependencies on FND_MSG_PUB

Line 115: fnd_msg_pub.ADD;

111:
112: IF (v_acct_period_id = 0)
113: OR(v_acct_period_id = -1) THEN
114: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
115: fnd_msg_pub.ADD;
116: RAISE fnd_api.g_exc_error;
117: END IF;
118:
119: -- Start Bug 8939057

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

370:
371: RETURN 0;
372: EXCEPTION
373: WHEN fnd_api.g_exc_error THEN
374: x_proc_msg := fnd_msg_pub.get(1, 'F');
375: RETURN -1;
376: WHEN OTHERS THEN
377: x_proc_msg := SUBSTR(SQLERRM, 1, 200);
378: RETURN -1;

Line 1427: fnd_msg_pub.ADD;

1423: IF l_debug = 1 THEN
1424: inv_log_util.trace('Error: Transaction Temp ID has to be passed', g_pkg_name || '.' || l_api_name, 3);
1425: END IF;
1426: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
1427: fnd_msg_pub.ADD;
1428: RAISE fnd_api.g_exc_error;
1429: END IF;
1430:
1431: -- Not Nullable columns should not be passed as MissNum or MissChar or MissDate

Line 1443: fnd_msg_pub.ADD;

1439: inv_log_util.trace('Error: The passed value will make the Not NULLABLE column NULL', g_pkg_name || '.' || l_api_name, 3);
1440: END IF;
1441: fnd_message.set_name('INV','INV_DATA_ERROR');
1442: fnd_message.set_token('ENTITY',l_api_name);
1443: fnd_msg_pub.ADD;
1444: RAISE fnd_api.g_exc_error;
1445: END IF;
1446:
1447: -- Querying MMTT to get some required values.

Line 1477: fnd_msg_pub.ADD;

1473: invttmtx.tdatechk(l_organization_id, l_transaction_date, l_acct_period_id, l_open_past_period);
1474: IF l_acct_period_id = -1 OR l_acct_period_id = 0 THEN
1475: inv_log_util.trace('Error: Period is not open for the Organization', g_pkg_name || '.' || l_api_name, 3);
1476: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
1477: fnd_msg_pub.ADD;
1478: RAISE fnd_api.g_exc_error;
1479: END IF;
1480:
1481: -- Conversion between Primary Qty and Transaction Qty

Line 1488: fnd_msg_pub.ADD;

1484: FETCH c_item_info INTO l_primary_uom;
1485: IF c_item_info%NOTFOUND THEN
1486: CLOSE c_item_info;
1487: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');
1488: fnd_msg_pub.ADD;
1489: RAISE fnd_api.g_exc_error;
1490: END IF;
1491: CLOSE c_item_info;
1492:

Line 1508: fnd_msg_pub.ADD;

1504: fnd_message.set_name('INV','INV_UOM_CONVERSION_ERROR');
1505: fnd_message.set_token('UOM1',l_transaction_uom);
1506: fnd_message.set_token('UOM2',l_primary_uom);
1507: fnd_message.set_token('MODULE',l_api_name);
1508: fnd_msg_pub.ADD;
1509: RAISE fnd_api.g_exc_error;
1510: END IF;
1511: ELSIF l_txn_qty IS NULL AND l_primary_qty IS NOT NULL THEN
1512: l_txn_qty := inv_convert.inv_um_convert(

Line 1526: fnd_msg_pub.ADD;

1522: fnd_message.set_name('INV','INV_UOM_CONVERSION_ERROR');
1523: fnd_message.set_token('UOM1',l_primary_uom);
1524: fnd_message.set_token('UOM2',l_transaction_uom);
1525: fnd_message.set_token('MODULE',l_api_name);
1526: fnd_msg_pub.ADD;
1527: RAISE fnd_api.g_exc_error;
1528: END IF;
1529: END IF;
1530: END IF;

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

1938: END IF;
1939: EXCEPTION
1940: WHEN fnd_api.g_exc_error THEN
1941: x_return_status := fnd_api.g_ret_sts_error;
1942: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1943: WHEN fnd_api.g_exc_unexpected_error THEN
1944: x_return_status := fnd_api.g_ret_sts_unexp_error;
1945: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1946: WHEN OTHERS THEN

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

1941: x_return_status := fnd_api.g_ret_sts_error;
1942: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1943: WHEN fnd_api.g_exc_unexpected_error THEN
1944: x_return_status := fnd_api.g_ret_sts_unexp_error;
1945: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1946: WHEN OTHERS THEN
1947: x_return_status := fnd_api.g_ret_sts_unexp_error;
1948: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1949: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

1944: x_return_status := fnd_api.g_ret_sts_unexp_error;
1945: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1946: WHEN OTHERS THEN
1947: x_return_status := fnd_api.g_ret_sts_unexp_error;
1948: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1949: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1950: END IF;
1951: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1952: END copy_insert_line_trx;

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

1945: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1946: WHEN OTHERS THEN
1947: x_return_status := fnd_api.g_ret_sts_unexp_error;
1948: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1949: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1950: END IF;
1951: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1952: END copy_insert_line_trx;
1953:

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

1947: x_return_status := fnd_api.g_ret_sts_unexp_error;
1948: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1949: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1950: END IF;
1951: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1952: END copy_insert_line_trx;
1953:
1954:
1955: -- Name: DELETE_SER_TRX