[Home] [Help]
167: x_return_status := fnd_api.g_ret_sts_success;
168: RETURN l_locator_control;
169: EXCEPTION
170: WHEN invalid_loc_control_exception THEN
171: fnd_message.set_name('INV','INV_INVALID_LOC_CONTROL');
172: fnd_msg_pub.ADD;
173: --
174: x_return_status := fnd_api.g_ret_sts_error ;
175: l_locator_control := -1 ;
299: FETCH l_subinventory_code_csr INTO l_putaway_sub;
300: IF l_subinventory_code_csr%notfound OR
301: l_putaway_sub IS NULL THEN
302: CLOSE l_subinventory_code_csr;
303: fnd_message.set_name('INV','INV_NO_DEFAULT_SUB');
304: fnd_msg_pub.ADD;
305: RAISE fnd_api.g_exc_error;
306: END IF;
307: CLOSE l_subinventory_code_csr;
334: RAISE fnd_api.g_exc_unexpected_error;
335: END IF;
336:
337: IF l_allowed <> 'Y' THEN
338: fnd_message.set_name('INV', 'INV_DETAIL_SUB_STATUS');
339: fnd_msg_pub.add;
340: raise fnd_api.g_exc_error;
341: END IF;
342: END IF;
345: -- now get the locator control and then determine if
346: -- default locator needs to be selected from item defaults
347: --
348: IF NOT l_sub_found THEN
349: fnd_message.set_name('INV','INV_NO_SUB_LOC_CONTROL');
350: fnd_msg_pub.ADD;
351: RAISE fnd_api.g_exc_error;
352: END if;
353:
373: OPEN l_locator_csr;
374: FETCH l_locator_csr INTO l_putaway_loc;
375: IF l_locator_csr%notfound OR l_putaway_loc IS NULL THEN
376: CLOSE l_locator_csr;
377: fnd_message.set_name('INV','INV_NO_DEFAULT_LOC');
378: fnd_msg_pub.ADD;
379: RAISE fnd_api.g_exc_error;
380: END IF;
381: ELSE
407: RAISE fnd_api.g_exc_unexpected_error;
408: END IF;
409:
410: IF l_allowed <> 'Y' THEN
411: fnd_message.set_name('INV', 'INV_DETAIL_LOC_STATUS');
412: fnd_msg_pub.add;
413: raise fnd_api.g_exc_error;
414: END IF;
415: END IF;
441:
442: If l_putaway_cg IS NULL Then
443: l_putaway_cg := l_putaway_cg_org;
444: if l_putaway_cg IS NULL then
445: fnd_message.set_name('INV','INV_NO_DEFAULT_COST_GROUP');
446: fnd_msg_pub.ADD;
447: RAISE fnd_api.g_exc_error;
448: end if;
449: End If;
695: OPEN l_rule_csr;
696: FETCH l_rule_csr INTO l_rev_rule, l_lot_rule, l_sub_rule, l_loc_rule;
697: IF l_rule_csr%notfound THEN
698: CLOSE l_rule_csr;
699: fnd_message.set_name('INV','INV_INVALID_PICKING_RULE');
700: fnd_msg_pub.ADD;
701: RAISE fnd_api.g_exc_error;
702: END IF;
703: CLOSE l_rule_csr;
703: CLOSE l_rule_csr;
704: --
705: IF l_rev_rule IS NULL OR l_lot_rule IS NULL OR
706: l_sub_rule IS NULL OR l_loc_rule IS NULL THEN
707: fnd_message.set_name('INV','INV_RULE_DEFINITION_ERROR');
708: fnd_msg_pub.ADD;
709: RAISE fnd_api.g_exc_error;
710: END IF;
711: ELSE
1364: IF p_request_context.transfer_flag AND use_this_row THEN
1365:
1366: -- First, get the line for from sub and to sub
1367: IF NOT (inv_cache.set_fromsub_rec(p_request_line_rec.organization_id, l_from_subinventory)) THEN
1368: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');
1369: fnd_msg_pub.add;
1370: RAISE fnd_api.g_exc_unexpected_error;
1371: END IF;
1372:
1370: RAISE fnd_api.g_exc_unexpected_error;
1371: END IF;
1372:
1373: IF NOT (inv_cache.set_tosub_rec(p_request_line_rec.organization_id, l_to_subinventory)) THEN
1374: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');
1375: fnd_msg_pub.add;
1376: RAISE fnd_api.g_exc_unexpected_error;
1377: END IF;
1378:
1376: RAISE fnd_api.g_exc_unexpected_error;
1377: END IF;
1378:
1379: IF NOT (inv_cache.set_org_rec(p_request_line_rec.organization_id)) THEN
1380: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');
1381: fnd_msg_pub.add;
1382: RAISE fnd_api.g_exc_unexpected_error;
1383: END IF;
1384: IF NOT (inv_cache.set_item_rec(p_request_line_rec.organization_id, p_request_line_rec.inventory_item_id)) THEN
1381: fnd_msg_pub.add;
1382: RAISE fnd_api.g_exc_unexpected_error;
1383: END IF;
1384: IF NOT (inv_cache.set_item_rec(p_request_line_rec.organization_id, p_request_line_rec.inventory_item_id)) THEN
1385: fnd_message.set_name('INV', 'INV_VALIDATE_SUB_FAILED');
1386: fnd_msg_pub.add;
1387: RAISE fnd_api.g_exc_unexpected_error;
1388: END IF;
1389:
1845: raise fnd_api.g_exc_error ;
1846: END IF;
1847: -- if no locations has been found, lets report error
1848: IF inv_detail_util_pvt.g_output_process_tbl.COUNT = 0 THEN
1849: --edited out called to fnd_message by jcearley, 12/2/99
1850: --fnd_message.set_name('INV','INV_SUGGESTION_FAILED');
1851: -- Suggestions not or only partially created through applying strategy
1852: --fnd_msg_pub.add;
1853: --RAISE fnd_api.g_exc_error;
1846: END IF;
1847: -- if no locations has been found, lets report error
1848: IF inv_detail_util_pvt.g_output_process_tbl.COUNT = 0 THEN
1849: --edited out called to fnd_message by jcearley, 12/2/99
1850: --fnd_message.set_name('INV','INV_SUGGESTION_FAILED');
1851: -- Suggestions not or only partially created through applying strategy
1852: --fnd_msg_pub.add;
1853: --RAISE fnd_api.g_exc_error;
1854: RETURN; -- do not raise exeception since it is not an error if can't find qty