DBA Data[Home] [Help]

APPS.INV_EBI_CZ_PUB dependencies on FND_API

Line 23: x_return_status := FND_API.G_RET_STS_SUCCESS;

19:
20: BEGIN
21:
22: FND_MSG_PUB.initialize;
23: x_return_status := FND_API.G_RET_STS_SUCCESS;
24:
25: IF( p_inventory_item_id IS NOT NULL AND
26: p_inventory_item_id <> fnd_api.g_miss_num AND
27: p_organization_id IS NOT NULL AND

Line 26: p_inventory_item_id <> fnd_api.g_miss_num AND

22: FND_MSG_PUB.initialize;
23: x_return_status := FND_API.G_RET_STS_SUCCESS;
24:
25: IF( p_inventory_item_id IS NOT NULL AND
26: p_inventory_item_id <> fnd_api.g_miss_num AND
27: p_organization_id IS NOT NULL AND
28: p_organization_id <> fnd_api.g_miss_num) THEN
29:
30: SELECT bom_item_type ,concatenated_segments

Line 28: p_organization_id <> fnd_api.g_miss_num) THEN

24:
25: IF( p_inventory_item_id IS NOT NULL AND
26: p_inventory_item_id <> fnd_api.g_miss_num AND
27: p_organization_id IS NOT NULL AND
28: p_organization_id <> fnd_api.g_miss_num) THEN
29:
30: SELECT bom_item_type ,concatenated_segments
31: INTO l_bom_item_type_code ,l_item_number
32: FROM mtl_system_items_kfv

Line 44: RAISE FND_API.g_exc_error;

40:
41: FND_MESSAGE.set_name('INV','INV_EBI_CONFIG_NOT_A_MODEL');
42: FND_MESSAGE.set_token('ITEM', l_item_number);
43: FND_MSG_PUB.add;
44: RAISE FND_API.g_exc_error;
45:
46: END IF;
47:
48: IF(p_profile_name IS NOT NULL AND p_profile_name <> fnd_api.g_miss_char) THEN

Line 48: IF(p_profile_name IS NOT NULL AND p_profile_name <> fnd_api.g_miss_char) THEN

44: RAISE FND_API.g_exc_error;
45:
46: END IF;
47:
48: IF(p_profile_name IS NOT NULL AND p_profile_name <> fnd_api.g_miss_char) THEN
49:
50: SELECT fpov.PROFILE_OPTION_VALUE INTO x_profile_value
51: FROM FND_PROFILE_OPTION_VALUES fpov,FND_PROFILE_OPTIONS fpo
52: WHERE fpov.PROFILE_OPTION_ID = fpo.PROFILE_OPTION_ID

Line 63: WHEN FND_API.g_exc_error THEN

59: select instance_name INTO x_system_id from v$instance;
60:
61:
62: EXCEPTION
63: WHEN FND_API.g_exc_error THEN
64:
65: x_return_status := FND_API.g_ret_sts_error;
66:
67: IF(x_msg_data IS NULL) THEN

Line 65: x_return_status := FND_API.g_ret_sts_error;

61:
62: EXCEPTION
63: WHEN FND_API.g_exc_error THEN
64:
65: x_return_status := FND_API.g_ret_sts_error;
66:
67: IF(x_msg_data IS NULL) THEN
68: FND_MSG_PUB.count_and_get(
69: p_encoded => FND_API.g_false

Line 69: p_encoded => FND_API.g_false

65: x_return_status := FND_API.g_ret_sts_error;
66:
67: IF(x_msg_data IS NULL) THEN
68: FND_MSG_PUB.count_and_get(
69: p_encoded => FND_API.g_false
70: ,p_count => x_msg_count
71: ,p_data => x_msg_data
72: );
73: END IF;

Line 76: x_return_status := FND_API.g_ret_sts_unexp_error;

72: );
73: END IF;
74:
75: WHEN OTHERS THEN
76: x_return_status := FND_API.g_ret_sts_unexp_error;
77:
78: IF (x_msg_data IS NOT NULL) THEN
79: x_msg_data := x_msg_data||' -> INV_EBI_CZ_PUB.process_cz_init_msg ';
80: ELSE