eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MO_LINE_DETAIL_UTIL dependencies on FND_MESSAGE

Line 1223: fnd_message.set_name('INV', 'OE_LOCK_ROW_CHANGED');

1219:
1220: x_return_status := fnd_api.g_ret_sts_error;
1221:
1222: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1223: fnd_message.set_name('INV', 'OE_LOCK_ROW_CHANGED');
1224: fnd_msg_pub.ADD;
1225: END IF;
1226: END IF;
1227:

Line 1234: fnd_message.set_name('INV', 'OE_LOCK_ROW_DELETED');

1230: WHEN NO_DATA_FOUND THEN
1231: x_return_status := fnd_api.g_ret_sts_error;
1232:
1233: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1234: fnd_message.set_name('INV', 'OE_LOCK_ROW_DELETED');
1235: fnd_msg_pub.ADD;
1236: END IF;
1237: WHEN app_exceptions.record_lock_exception THEN
1238: x_return_status := fnd_api.g_ret_sts_error;

Line 1241: fnd_message.set_name('INV', 'OE_LOCK_ROW_ALREADY_LOCKED');

1237: WHEN app_exceptions.record_lock_exception THEN
1238: x_return_status := fnd_api.g_ret_sts_error;
1239:
1240: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1241: fnd_message.set_name('INV', 'OE_LOCK_ROW_ALREADY_LOCKED');
1242: fnd_msg_pub.ADD;
1243: END IF;
1244: WHEN OTHERS THEN
1245: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2148: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

2144: SAVEPOINT update_qty;
2145: x_return_status := fnd_api.g_ret_sts_success;
2146:
2147: IF p_move_order_line_id IS NULL THEN
2148: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
2149: fnd_msg_pub.ADD;
2150: RAISE fnd_api.g_exc_unexpected_error;
2151: END IF;
2152:

Line 2156: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

2152:
2153: i := p_mold_table.FIRST;
2154:
2155: IF i IS NULL THEN
2156: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
2157: fnd_msg_pub.ADD;
2158: RAISE fnd_api.g_exc_unexpected_error;
2159: END IF;
2160:

Line 2164: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

2160:
2161: WHILE i IS NOT NULL LOOP
2162: IF p_mold_table(i).organization_id IS NULL
2163: OR p_mold_table(i).organization_id = fnd_api.g_miss_num THEN
2164: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
2165: fnd_msg_pub.ADD;
2166: RAISE fnd_api.g_exc_unexpected_error;
2167: END IF;
2168:

Line 2171: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

2167: END IF;
2168:
2169: IF p_mold_table(i).subinventory_code IS NULL
2170: OR p_mold_table(i).subinventory_code = fnd_api.g_miss_char THEN
2171: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
2172: fnd_msg_pub.ADD;
2173: RAISE fnd_api.g_exc_unexpected_error;
2174: END IF;
2175:

Line 2177: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

2173: RAISE fnd_api.g_exc_unexpected_error;
2174: END IF;
2175:
2176: IF p_mold_table(i).locator_id = fnd_api.g_miss_num THEN
2177: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
2178: fnd_msg_pub.ADD;
2179: RAISE fnd_api.g_exc_unexpected_error;
2180: END IF;
2181:

Line 2184: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

2180: END IF;
2181:
2182: IF p_mold_table(i).inventory_item_id IS NULL
2183: OR p_mold_table(i).locator_id = fnd_api.g_miss_num THEN
2184: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
2185: fnd_msg_pub.ADD;
2186: RAISE fnd_api.g_exc_unexpected_error;
2187: END IF;
2188:

Line 2190: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

2186: RAISE fnd_api.g_exc_unexpected_error;
2187: END IF;
2188:
2189: IF p_mold_table(i).revision = fnd_api.g_miss_char THEN
2190: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
2191: fnd_msg_pub.ADD;
2192: RAISE fnd_api.g_exc_unexpected_error;
2193: END IF;
2194:

Line 2196: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

2192: RAISE fnd_api.g_exc_unexpected_error;
2193: END IF;
2194:
2195: IF p_mold_table(i).lot_number = fnd_api.g_miss_char THEN
2196: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
2197: fnd_msg_pub.ADD;
2198: RAISE fnd_api.g_exc_unexpected_error;
2199: END IF;
2200:

Line 2202: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

2198: RAISE fnd_api.g_exc_unexpected_error;
2199: END IF;
2200:
2201: IF p_mold_table(i).serial_number = fnd_api.g_miss_char THEN
2202: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
2203: fnd_msg_pub.ADD;
2204: RAISE fnd_api.g_exc_unexpected_error;
2205: END IF;
2206:

Line 2208: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

2204: RAISE fnd_api.g_exc_unexpected_error;
2205: END IF;
2206:
2207: IF p_mold_table(i).transaction_uom = fnd_api.g_miss_char THEN
2208: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
2209: fnd_msg_pub.ADD;
2210: RAISE fnd_api.g_exc_unexpected_error;
2211: END IF;
2212:

Line 2216: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');

2212:
2213: IF p_mold_table(i).transaction_quantity IS NULL
2214: OR p_mold_table(i).transaction_quantity = 0
2215: OR p_mold_table(i).locator_id = fnd_api.g_miss_num THEN
2216: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
2217: fnd_msg_pub.ADD;
2218: RAISE fnd_api.g_exc_unexpected_error;
2219: END IF;
2220:

Line 2235: fnd_message.set_name('INV', 'INV-NO ITEM RECORD');

2231: WHERE inventory_item_id = p_mold_table(i).inventory_item_id
2232: AND organization_id = p_mold_table(i).organization_id;
2233: EXCEPTION
2234: WHEN NO_DATA_FOUND THEN
2235: fnd_message.set_name('INV', 'INV-NO ITEM RECORD');
2236: fnd_msg_pub.ADD;
2237: RAISE fnd_api.g_exc_error;
2238: WHEN OTHERS THEN
2239: RAISE;

Line 2244: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

2240: END;
2241:
2242: -- API does not handle serial controlled items
2243: IF l_serial_control_code IN(2, 5) THEN
2244: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2245: fnd_message.set_token('ENTITY1', 'SERIAL_CONTROL', TRUE);
2246: fnd_msg_pub.ADD;
2247: RAISE fnd_api.g_exc_error;
2248: END IF;

Line 2245: fnd_message.set_token('ENTITY1', 'SERIAL_CONTROL', TRUE);

2241:
2242: -- API does not handle serial controlled items
2243: IF l_serial_control_code IN(2, 5) THEN
2244: fnd_message.set_name('INV', 'INV_FIELD_INVALID');
2245: fnd_message.set_token('ENTITY1', 'SERIAL_CONTROL', TRUE);
2246: fnd_msg_pub.ADD;
2247: RAISE fnd_api.g_exc_error;
2248: END IF;
2249:

Line 2263: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');

2259: , NULL
2260: );
2261:
2262: IF l_primary_quantity = -99999 THEN
2263: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2264: fnd_message.set_token('UOM', p_mold_table(i).transaction_uom);
2265: fnd_message.set_token('ROUTINE', 'inv_mo_line_detail_util.update_quantity_allocations');
2266: fnd_msg_pub.ADD;
2267: RAISE fnd_api.g_exc_error;

Line 2264: fnd_message.set_token('UOM', p_mold_table(i).transaction_uom);

2260: );
2261:
2262: IF l_primary_quantity = -99999 THEN
2263: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2264: fnd_message.set_token('UOM', p_mold_table(i).transaction_uom);
2265: fnd_message.set_token('ROUTINE', 'inv_mo_line_detail_util.update_quantity_allocations');
2266: fnd_msg_pub.ADD;
2267: RAISE fnd_api.g_exc_error;
2268: END IF;

Line 2265: fnd_message.set_token('ROUTINE', 'inv_mo_line_detail_util.update_quantity_allocations');

2261:
2262: IF l_primary_quantity = -99999 THEN
2263: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2264: fnd_message.set_token('UOM', p_mold_table(i).transaction_uom);
2265: fnd_message.set_token('ROUTINE', 'inv_mo_line_detail_util.update_quantity_allocations');
2266: fnd_msg_pub.ADD;
2267: RAISE fnd_api.g_exc_error;
2268: END IF;
2269:

Line 2317: fnd_message.set_name('INV', 'INV_QUANTITY_TOO_BIG');

2313: , secondary_transaction_quantity = p_mold_table(i).secondary_transaction_quantity
2314: , primary_quantity = l_primary_quantity
2315: WHERE ROWID = l_mmtt_rowid;
2316: ELSIF l_mmtt_transaction_quantity < p_mold_table(i).transaction_quantity THEN
2317: fnd_message.set_name('INV', 'INV_QUANTITY_TOO_BIG');
2318: fnd_msg_pub.ADD;
2319: RAISE fnd_api.g_exc_error;
2320: END IF;
2321: ELSIF l_lot_control_code = 2

Line 2396: fnd_message.set_name('INV', 'INV_QUANTITY_TOO_BIG');

2392: , secondary_quantity = p_mold_table(i).secondary_transaction_quantity
2393: , primary_quantity = l_primary_quantity
2394: WHERE ROWID = l_mtlt_rowid;
2395: ELSIF l_mtlt_transaction_quantity < p_mold_table(i).transaction_quantity THEN
2396: fnd_message.set_name('INV', 'INV_QUANTITY_TOO_BIG');
2397: fnd_msg_pub.ADD;
2398: RAISE fnd_api.g_exc_error;
2399: END IF;
2400: END IF; -- Type of item control

Line 2456: fnd_message.set_name('INV', 'INV_MGD_MVT_TOO_MANY_TRANS');

2452: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2453: EXCEPTION
2454: WHEN TOO_MANY_ROWS THEN
2455: x_return_status := fnd_api.g_ret_sts_error;
2456: fnd_message.set_name('INV', 'INV_MGD_MVT_TOO_MANY_TRANS');
2457: fnd_msg_pub.ADD;
2458: ROLLBACK TO update_qty;
2459: WHEN NO_DATA_FOUND THEN
2460: x_return_status := fnd_api.g_ret_sts_error;

Line 2461: fnd_message.set_name('INV', 'INV_NO_RECORDS');

2457: fnd_msg_pub.ADD;
2458: ROLLBACK TO update_qty;
2459: WHEN NO_DATA_FOUND THEN
2460: x_return_status := fnd_api.g_ret_sts_error;
2461: fnd_message.set_name('INV', 'INV_NO_RECORDS');
2462: fnd_message.set_token('ENTITY', l_current_table);
2463: fnd_msg_pub.ADD;
2464: -- Get message count and data
2465: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2462: fnd_message.set_token('ENTITY', l_current_table);

2458: ROLLBACK TO update_qty;
2459: WHEN NO_DATA_FOUND THEN
2460: x_return_status := fnd_api.g_ret_sts_error;
2461: fnd_message.set_name('INV', 'INV_NO_RECORDS');
2462: fnd_message.set_token('ENTITY', l_current_table);
2463: fnd_msg_pub.ADD;
2464: -- Get message count and data
2465: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2466: ROLLBACK TO update_qty;

Line 2504: fnd_message.set_name('INV','INV_MISSING_REQUIRED_PARAMETER');

2500: BEGIN
2501: x_return_status := fnd_api.g_ret_sts_success;
2502: IF p_mo_line_id IS NULL AND p_transaction_temp_id IS NULL THEN
2503: debug('Either Move Order Line ID or Transaction Temp ID has to be passed','DELETE_ALLOCATIONS');
2504: fnd_message.set_name('INV','INV_MISSING_REQUIRED_PARAMETER');
2505: fnd_msg_pub.ADD;
2506: RAISE fnd_api.g_exc_error;
2507: END IF;
2508: