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;
1335: END IF;
1336: END LOOP;
1337: -- assign it to the out variable
1338: x_lot_serial_attributes_count := l_rec_index;
1339: x_return_status := fnd_api.g_ret_sts_success ;
1340:
1341: EXCEPTION
1342: WHEN fnd_api.g_exc_error THEN
1343: x_return_status := fnd_api.g_ret_sts_error ;
1338: x_lot_serial_attributes_count := l_rec_index;
1339: x_return_status := fnd_api.g_ret_sts_success ;
1340:
1341: EXCEPTION
1342: WHEN fnd_api.g_exc_error THEN
1343: x_return_status := fnd_api.g_ret_sts_error ;
1344:
1345: WHEN fnd_api.g_exc_unexpected_error THEN
1346: x_return_status := fnd_api.g_ret_sts_unexp_error;
1339: x_return_status := fnd_api.g_ret_sts_success ;
1340:
1341: EXCEPTION
1342: WHEN fnd_api.g_exc_error THEN
1343: x_return_status := fnd_api.g_ret_sts_error ;
1344:
1345: WHEN fnd_api.g_exc_unexpected_error THEN
1346: x_return_status := fnd_api.g_ret_sts_unexp_error;
1347:
1341: EXCEPTION
1342: WHEN fnd_api.g_exc_error THEN
1343: x_return_status := fnd_api.g_ret_sts_error ;
1344:
1345: WHEN fnd_api.g_exc_unexpected_error THEN
1346: x_return_status := fnd_api.g_ret_sts_unexp_error;
1347:
1348: WHEN others THEN
1349: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1342: WHEN fnd_api.g_exc_error THEN
1343: x_return_status := fnd_api.g_ret_sts_error ;
1344:
1345: WHEN fnd_api.g_exc_unexpected_error THEN
1346: x_return_status := fnd_api.g_ret_sts_unexp_error;
1347:
1348: WHEN others THEN
1349: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1350: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1345: WHEN fnd_api.g_exc_unexpected_error THEN
1346: x_return_status := fnd_api.g_ret_sts_unexp_error;
1347:
1348: WHEN others THEN
1349: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1350: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
1351: fnd_msg_pub.add_exc_msg(g_pkg_name, 'GET_ATTRIBUTE_VALUES');
1352: END IF;
1353: END get_attribute_values;
1888: x_concatenated_values := null;
1889: FND_MESSAGE.SET_NAME('INV', 'INV_FND_GENERIC_MSG');
1890: FND_MESSAGE.SET_TOKEN('MSG', fnd_flex_descval.error_message);
1891: FND_MSG_PUB.ADD;
1892: raise fnd_api.g_exc_unexpected_error;
1893: END IF;
1894: debug('after getting x_concatenated_values ' || x_concatenated_values, 'GET_INV_SERIAL_ATTR', 9);
1895: EXCEPTION
1896: when no_data_found THEN
1894: debug('after getting x_concatenated_values ' || x_concatenated_values, 'GET_INV_SERIAL_ATTR', 9);
1895: EXCEPTION
1896: when no_data_found THEN
1897: null;
1898: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
1899: x_return_status := 'U';
1900: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
1901: when others then
1902: x_return_status := 'U';
1896: when no_data_found THEN
1897: null;
1898: when FND_API.G_EXC_UNEXPECTED_ERROR THEN
1899: x_return_status := 'U';
1900: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
1901: when others then
1902: x_return_status := 'U';
1903: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
1904: END get_inv_serial_attributes;
1899: x_return_status := 'U';
1900: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
1901: when others then
1902: x_return_status := 'U';
1903: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
1904: END get_inv_serial_attributes;
1905:
1906:
1907: END INV_LOT_SEL_ATTR;