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 42: IF NOT FND_API.Compatible_API_Call

38:
39:
40: BEGIN
41: -- Standard call to check for call compatibility
42: IF NOT FND_API.Compatible_API_Call
43: ( l_api_version_number
44: , p_api_version_number
45: , l_api_name
46: , G_PKG_NAME

Line 49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

45: , l_api_name
46: , G_PKG_NAME
47: )
48: THEN
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51:
52: -- Initialize message list.
53: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 53: IF fnd_api.to_boolean(p_init_msg_lst) THEN

49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51:
52: -- Initialize message list.
53: IF fnd_api.to_boolean(p_init_msg_lst) THEN
54: fnd_msg_pub.initialize;
55: END IF;
56:
57: -- Bug 13731486

Line 74: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

70: ,x_lot_status_enabled => l_lot_status_enabled
71: ,x_default_lot_status_id => l_default_lot_status_id
72: ,x_serial_status_enabled => l_serial_status_enabled
73: ,x_default_serial_status_id => l_default_serial_status_id);
74: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
75: RAISE fnd_api.g_exc_unexpected_error;
76: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
77: RAISE fnd_api.g_exc_error;
78: END IF;

Line 75: RAISE fnd_api.g_exc_unexpected_error;

71: ,x_default_lot_status_id => l_default_lot_status_id
72: ,x_serial_status_enabled => l_serial_status_enabled
73: ,x_default_serial_status_id => l_default_serial_status_id);
74: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
75: RAISE fnd_api.g_exc_unexpected_error;
76: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
77: RAISE fnd_api.g_exc_error;
78: END IF;
79:

Line 76: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

72: ,x_serial_status_enabled => l_serial_status_enabled
73: ,x_default_serial_status_id => l_default_serial_status_id);
74: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
75: RAISE fnd_api.g_exc_unexpected_error;
76: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
77: RAISE fnd_api.g_exc_error;
78: END IF;
79:
80: -- Bug 13731486 : Checking for onhand status enabled org.

Line 77: RAISE fnd_api.g_exc_error;

73: ,x_default_serial_status_id => l_default_serial_status_id);
74: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
75: RAISE fnd_api.g_exc_unexpected_error;
76: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
77: RAISE fnd_api.g_exc_error;
78: END IF;
79:
80: -- Bug 13731486 : Checking for onhand status enabled org.
81: if (l_lot_status_enabled = 'N' AND p_object_type = 'O' AND l_default_status_id IS NULL) or

Line 83: RAISE fnd_api.g_exc_error;

79:
80: -- Bug 13731486 : Checking for onhand status enabled org.
81: if (l_lot_status_enabled = 'N' AND p_object_type = 'O' AND l_default_status_id IS NULL) or
82: (l_serial_status_enabled = 'N' AND p_object_type = 'S') then
83: RAISE fnd_api.g_exc_error;
84: end if;
85:
86: end if;
87:

Line 124: RAISE FND_API.G_EXC_ERROR;

120:
121: ELSE
122: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_UPD_RESV_FAIL');
123: FND_MSG_PUB.ADD;
124: RAISE FND_API.G_EXC_ERROR;
125: END IF;
126:
127:
128: elsif p_object_type = 'L' THEN

Line 160: RAISE FND_API.G_EXC_ERROR;

156: and inventory_location_id = l_status_rec.locator_id;
157: ELSE
158: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_UPD_RESV_FAIL');
159: FND_MSG_PUB.ADD;
160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162:
163: elsif p_object_type = 'O' THEN
164: --Bug 14028205 Added the select statement

Line 198: RAISE FND_API.G_EXC_ERROR;

194: and lot_number = l_status_rec.lot_number;
195: ELSE
196: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_UPD_RESV_FAIL');
197: FND_MSG_PUB.ADD;
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200:
201: elsif p_object_type = 'S' THEN
202: --Bug 14028205 Added the select statement

Line 246: RAISE FND_API.G_EXC_ERROR;

242: end if;
243: ELSE
244: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_UPD_RESV_FAIL');
245: FND_MSG_PUB.ADD;
246: RAISE FND_API.G_EXC_ERROR;
247: END IF;
248:
249: -- Start of changes for # 6633612---------------
250: elsif p_object_type = 'H' then

Line 300: RAISE FND_API.G_EXC_ERROR;

296: and nvl(lpn_id, -9999) = nvl(l_status_rec.lpn_id, -9999);
297: ELSE
298: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_UPD_RESV_FAIL');
299: FND_MSG_PUB.ADD;
300: RAISE FND_API.G_EXC_ERROR;
301: END IF;
302:
303: end if;
304: -- End of changes for # 6633612---------------

Line 310: l_return_status := fnd_api.g_ret_sts_error;

306: -- Onhand Material Status Support (6633612): Object type is passed as 'Q' from QtyManager.java to
307: -- avoid the update of onhand records. In this case we only want the new record to be inserted into
308: -- the history table.
309: if p_object_type <> 'Q' then
310: l_return_status := fnd_api.g_ret_sts_error;
311: end if;
312: end if;
313:
314:

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

334: INV_MATERIAL_STATUS_PKG.Insert_status_history(p_status_rec);
335: END IF;
336:
337:
338: if( p_commit = FND_API.G_TRUE ) Then
339: commit;
340: end if;
341:
342: x_return_status := l_return_status;

Line 346: WHEN FND_API.G_EXC_ERROR THEN

342: x_return_status := l_return_status;
343:
344: EXCEPTION
345:
346: WHEN FND_API.G_EXC_ERROR THEN
347:
348: -- Get message count and data
349: FND_MSG_PUB.Count_And_Get
350: ( p_count => x_msg_count

Line 353: x_return_status := FND_API.G_RET_STS_ERROR;

349: FND_MSG_PUB.Count_And_Get
350: ( p_count => x_msg_count
351: , p_data => x_msg_data
352: );
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: x_msg_data := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
355:
356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

352: );
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: x_msg_data := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
355:
356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358:
359: -- Get message count and data
360: FND_MSG_PUB.Count_And_Get

Line 357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

353: x_return_status := FND_API.G_RET_STS_ERROR;
354: x_msg_data := FND_MSG_PUB.GET(X_MSG_COUNT, 'F');
355:
356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358:
359: -- Get message count and data
360: FND_MSG_PUB.Count_And_Get
361: ( p_count => x_msg_count

Line 366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

362: , p_data => x_msg_data
363: );
364:
365: WHEN OTHERS THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
367:
368: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
369: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
370: END IF;