DBA Data[Home] [Help]

APPS.INV_LOT_SEL_ATTR dependencies on FND_API

Line 661: x_return_status := fnd_api.g_ret_sts_success ;

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;

Line 666: 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;
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

Line 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 ;

Line 671: x_return_status := fnd_api.g_ret_sts_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:

Line 673: WHEN fnd_api.g_exc_unexpected_error THEN

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 ;

Line 674: 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

Line 677: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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;

Line 1491: x_return_status := fnd_api.g_ret_sts_success;

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 ;

Line 1494: WHEN fnd_api.g_exc_error THEN

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;

Line 1495: x_return_status := fnd_api.g_ret_sts_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:

Line 1497: WHEN fnd_api.g_exc_unexpected_error THEN

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 ;

Line 1498: 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

Line 1501: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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;

Line 2044: raise fnd_api.g_exc_unexpected_error;

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

Line 2050: when FND_API.G_EXC_UNEXPECTED_ERROR 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';

Line 2052: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);

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;

Line 2055: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);

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:

Line 2235: x_return_status := fnd_api.g_ret_sts_success;

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);

Line 2266: x_return_status := fnd_api.g_ret_sts_error;

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

Line 2279: x_return_status := fnd_api.g_ret_sts_error;

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 */