eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MATERIAL_STATUS_PUB dependencies on FND_API

Line 9: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

5: g_pkg_name constant varchar2(50) := 'INV_MATERIAL_STATUS_PUB';
6:
7: PROCEDURE update_status
8: ( p_api_version_number IN NUMBER
9: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
10: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
11: , x_return_status OUT NOCOPY VARCHAR2
12: , x_msg_count OUT NOCOPY NUMBER
13: , x_msg_data OUT NOCOPY VARCHAR2

Line 10: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

6:
7: PROCEDURE update_status
8: ( p_api_version_number IN NUMBER
9: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
10: , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
11: , x_return_status OUT NOCOPY VARCHAR2
12: , x_msg_count OUT NOCOPY NUMBER
13: , x_msg_data OUT NOCOPY VARCHAR2
14: , p_object_type IN VARCHAR2

Line 19: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

15: , p_status_rec IN INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type
16: ) IS
17: l_api_version_number CONSTANT NUMBER := 1.0;
18: l_api_name CONSTANT VARCHAR2(30):= 'UPDATE_STATUS';
19: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
20: l_status_rec INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type;
21: l_msg_count NUMBER;
22: l_msg_data VARCHAR2(240);
23: l_lot_status_enabled VARCHAR2(1);

Line 30: IF NOT FND_API.Compatible_API_Call

26: l_default_serial_status_id NUMBER;
27:
28: BEGIN
29: -- Standard call to check for call compatibility
30: IF NOT FND_API.Compatible_API_Call
31: ( l_api_version_number
32: , p_api_version_number
33: , l_api_name
34: , G_PKG_NAME

Line 37: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

33: , l_api_name
34: , G_PKG_NAME
35: )
36: THEN
37: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39:
40: -- Initialize message list.
41: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 41: IF fnd_api.to_boolean(p_init_msg_lst) THEN

37: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39:
40: -- Initialize message list.
41: IF fnd_api.to_boolean(p_init_msg_lst) THEN
42: fnd_msg_pub.initialize;
43: END IF;
44:
45: if p_object_type = 'O' or p_object_type = 'S' then

Line 57: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

53: ,x_lot_status_enabled => l_lot_status_enabled
54: ,x_default_lot_status_id => l_default_lot_status_id
55: ,x_serial_status_enabled => l_serial_status_enabled
56: ,x_default_serial_status_id => l_default_serial_status_id);
57: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
58: RAISE fnd_api.g_exc_unexpected_error;
59: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
60: RAISE fnd_api.g_exc_error;
61: END IF;

Line 58: RAISE fnd_api.g_exc_unexpected_error;

54: ,x_default_lot_status_id => l_default_lot_status_id
55: ,x_serial_status_enabled => l_serial_status_enabled
56: ,x_default_serial_status_id => l_default_serial_status_id);
57: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
58: RAISE fnd_api.g_exc_unexpected_error;
59: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
60: RAISE fnd_api.g_exc_error;
61: END IF;
62: if (l_lot_status_enabled = 'N' AND p_object_type = 'O') or

Line 59: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

55: ,x_serial_status_enabled => l_serial_status_enabled
56: ,x_default_serial_status_id => l_default_serial_status_id);
57: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
58: RAISE fnd_api.g_exc_unexpected_error;
59: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
60: RAISE fnd_api.g_exc_error;
61: END IF;
62: if (l_lot_status_enabled = 'N' AND p_object_type = 'O') or
63: (l_serial_status_enabled = 'N' AND p_object_type = 'S') then

Line 60: RAISE fnd_api.g_exc_error;

56: ,x_default_serial_status_id => l_default_serial_status_id);
57: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
58: RAISE fnd_api.g_exc_unexpected_error;
59: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
60: RAISE fnd_api.g_exc_error;
61: END IF;
62: if (l_lot_status_enabled = 'N' AND p_object_type = 'O') or
63: (l_serial_status_enabled = 'N' AND p_object_type = 'S') then
64: RAISE fnd_api.g_exc_error;

Line 64: RAISE fnd_api.g_exc_error;

60: RAISE fnd_api.g_exc_error;
61: END IF;
62: if (l_lot_status_enabled = 'N' AND p_object_type = 'O') or
63: (l_serial_status_enabled = 'N' AND p_object_type = 'S') then
64: RAISE fnd_api.g_exc_error;
65: end if;
66: end if;
67:
68: l_status_rec := p_status_rec;

Line 140: l_return_status := fnd_api.g_ret_sts_error;

136: -- Onhand Material Status Support (6633612): Object type is passed as 'Q' from QtyManager.java to
137: -- avoid the update of onhand records. In this case we only want the new record to be inserted into
138: -- the history table.
139: if p_object_type <> 'Q' then
140: l_return_status := fnd_api.g_ret_sts_error;
141: end if;
142: end if;
143:
144: -- Bug 6798024: For object_type Q, no update statement is executed, hence

Line 153: if( p_commit = FND_API.G_TRUE ) Then

149:
150: -- Insert the update history to the update status history table
151: INV_MATERIAL_STATUS_PKG.Insert_status_history(p_status_rec);
152:
153: if( p_commit = FND_API.G_TRUE ) Then
154: commit;
155: end if;
156:
157: x_return_status := l_return_status;

Line 161: WHEN FND_API.G_EXC_ERROR THEN

157: x_return_status := l_return_status;
158:
159: EXCEPTION
160:
161: WHEN FND_API.G_EXC_ERROR THEN
162: x_return_status := FND_API.G_RET_STS_ERROR;
163:
164: -- Get message count and data
165: FND_MSG_PUB.Count_And_Get

Line 162: x_return_status := FND_API.G_RET_STS_ERROR;

158:
159: EXCEPTION
160:
161: WHEN FND_API.G_EXC_ERROR THEN
162: x_return_status := FND_API.G_RET_STS_ERROR;
163:
164: -- Get message count and data
165: FND_MSG_PUB.Count_And_Get
166: ( p_count => x_msg_count

Line 170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

166: ( p_count => x_msg_count
167: , p_data => x_msg_data
168: );
169:
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172:
173: -- Get message count and data
174: FND_MSG_PUB.Count_And_Get

Line 171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

167: , p_data => x_msg_data
168: );
169:
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
172:
173: -- Get message count and data
174: FND_MSG_PUB.Count_And_Get
175: ( p_count => x_msg_count

Line 180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

176: , p_data => x_msg_data
177: );
178:
179: WHEN OTHERS THEN
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181:
182: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
183: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
184: END IF;