657: END IF; -- context is enabled
658: END LOOP contextLoop1;
659:
660: x_attributes_default_count := v_rec_index;
661: x_return_status := fnd_api.g_ret_sts_success ;
662:
663: --inv_debug.message('x_return_status is ' || x_return_status);
664: ELSE /* no segment is enabled */
665: x_attributes_default_count := 0;
662:
663: --inv_debug.message('x_return_status is ' || x_return_status);
664: ELSE /* no segment is enabled */
665: x_attributes_default_count := 0;
666: x_return_status := fnd_api.g_ret_sts_success ;
667: END IF; /* v_enabled */
668:
669: EXCEPTION
670: WHEN fnd_api.g_exc_error THEN
666: x_return_status := fnd_api.g_ret_sts_success ;
667: END IF; /* v_enabled */
668:
669: EXCEPTION
670: WHEN fnd_api.g_exc_error THEN
671: x_return_status := fnd_api.g_ret_sts_error ;
672:
673: WHEN fnd_api.g_exc_unexpected_error THEN
674: x_return_status := fnd_api.g_ret_sts_unexp_error ;
667: END IF; /* v_enabled */
668:
669: EXCEPTION
670: WHEN fnd_api.g_exc_error THEN
671: x_return_status := fnd_api.g_ret_sts_error ;
672:
673: WHEN fnd_api.g_exc_unexpected_error THEN
674: x_return_status := fnd_api.g_ret_sts_unexp_error ;
675:
669: EXCEPTION
670: WHEN fnd_api.g_exc_error THEN
671: x_return_status := fnd_api.g_ret_sts_error ;
672:
673: WHEN fnd_api.g_exc_unexpected_error THEN
674: x_return_status := fnd_api.g_ret_sts_unexp_error ;
675:
676: WHEN others THEN
677: x_return_status := fnd_api.g_ret_sts_unexp_error ;
670: WHEN fnd_api.g_exc_error THEN
671: x_return_status := fnd_api.g_ret_sts_error ;
672:
673: WHEN fnd_api.g_exc_unexpected_error THEN
674: x_return_status := fnd_api.g_ret_sts_unexp_error ;
675:
676: WHEN others THEN
677: x_return_status := fnd_api.g_ret_sts_unexp_error ;
678: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
673: WHEN fnd_api.g_exc_unexpected_error THEN
674: x_return_status := fnd_api.g_ret_sts_unexp_error ;
675:
676: WHEN others THEN
677: x_return_status := fnd_api.g_ret_sts_unexp_error ;
678: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
679: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);
680: END IF;
681: END get_default;
1487: END IF;
1488: END LOOP;
1489: -- assign it to the out variable
1490: x_lot_serial_attributes_count := l_rec_index;
1491: x_return_status := fnd_api.g_ret_sts_success;
1492:
1493: EXCEPTION
1494: WHEN fnd_api.g_exc_error THEN
1495: x_return_status := fnd_api.g_ret_sts_error ;
1490: x_lot_serial_attributes_count := l_rec_index;
1491: x_return_status := fnd_api.g_ret_sts_success;
1492:
1493: EXCEPTION
1494: WHEN fnd_api.g_exc_error THEN
1495: x_return_status := fnd_api.g_ret_sts_error ;
1496:
1497: WHEN fnd_api.g_exc_unexpected_error THEN
1498: x_return_status := fnd_api.g_ret_sts_unexp_error;
1491: x_return_status := fnd_api.g_ret_sts_success;
1492:
1493: EXCEPTION
1494: WHEN fnd_api.g_exc_error THEN
1495: x_return_status := fnd_api.g_ret_sts_error ;
1496:
1497: WHEN fnd_api.g_exc_unexpected_error THEN
1498: x_return_status := fnd_api.g_ret_sts_unexp_error;
1499:
1493: EXCEPTION
1494: WHEN fnd_api.g_exc_error THEN
1495: x_return_status := fnd_api.g_ret_sts_error ;
1496:
1497: WHEN fnd_api.g_exc_unexpected_error THEN
1498: x_return_status := fnd_api.g_ret_sts_unexp_error;
1499:
1500: WHEN others THEN
1501: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1494: WHEN fnd_api.g_exc_error THEN
1495: x_return_status := fnd_api.g_ret_sts_error ;
1496:
1497: WHEN fnd_api.g_exc_unexpected_error THEN
1498: x_return_status := fnd_api.g_ret_sts_unexp_error;
1499:
1500: WHEN others THEN
1501: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1502: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1497: WHEN fnd_api.g_exc_unexpected_error THEN
1498: x_return_status := fnd_api.g_ret_sts_unexp_error;
1499:
1500: WHEN others THEN
1501: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1502: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1503: fnd_msg_pub.add_exc_msg(g_pkg_name, 'GET_ATTRIBUTE_VALUES');
1504: END IF;
1505: END get_attribute_values;
2040: x_concatenated_values := null;
2041: FND_MESSAGE.SET_NAME('INV', 'INV_FND_GENERIC_MSG');
2042: FND_MESSAGE.SET_TOKEN('MSG', fnd_flex_descval.error_message);
2043: FND_MSG_PUB.ADD;
2044: raise fnd_api.g_exc_unexpected_error;
2045: END IF;
2046: debug('after getting x_concatenated_values ' || x_concatenated_values, 'GET_INV_SERIAL_ATTR', 9);
2047: EXCEPTION
2048: when no_data_found THEN
2046: debug('after getting x_concatenated_values ' || x_concatenated_values, 'GET_INV_SERIAL_ATTR', 9);
2047: EXCEPTION
2048: when no_data_found THEN
2049: null;
2050: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
2051: x_return_status := 'U';
2052: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
2053: when others then
2054: x_return_status := 'U';
2048: when no_data_found THEN
2049: null;
2050: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
2051: x_return_status := 'U';
2052: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
2053: when others then
2054: x_return_status := 'U';
2055: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
2056: END get_inv_serial_attributes;
2051: x_return_status := 'U';
2052: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
2053: when others then
2054: x_return_status := 'U';
2055: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
2056: END get_inv_serial_attributes;
2057:
2058: -- Bug 7350762 Code changes start
2059:
2231: BEGIN
2232:
2233: SAVEPOINT lock_lot_records;
2234:
2235: x_return_status := fnd_api.g_ret_sts_success;
2236:
2237: debug('Lot Generation => '|| p_lot_generation ,l_module_name, 9);
2238: debug('Lot Uniqueness => '|| p_lot_uniqueness ,l_module_name, 9);
2239: debug('Lot Prefix => '|| p_lot_prefix ,l_module_name, 9);
2262:
2263: IF l_already_locked = 'N' THEN /* Got the lock */
2264: RETURN TRUE;
2265: ELSE
2266: x_return_status := fnd_api.g_ret_sts_error;
2267: RETURN FALSE;
2268: END IF;
2269:
2270: EXCEPTION
2275: debug('Item with same prefix currently locked in Master or Organization items form',l_module_name,9);
2276: fnd_message.set_name('INV', 'INV_LOT_GEN_ERROR');
2277: fnd_msg_pub.ADD;
2278: END IF;
2279: x_return_status := fnd_api.g_ret_sts_error;
2280: RETURN FALSE;
2281: END lock_lot_records;
2282:
2283: /* End of changes for bug 8428348 */