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.WMS_PURGE_PVT dependencies on FND_API

Line 17: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

13: EPC CONSTANT NUMBER :=5;
14:
15: PROCEDURE Check_Purge_LPNs (
16: p_api_version IN NUMBER
17: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
18: , p_commit IN VARCHAR2 := fnd_api.g_false
19: , x_return_status OUT NOCOPY VARCHAR2
20: , x_msg_count OUT NOCOPY NUMBER
21: , x_msg_data OUT NOCOPY VARCHAR2

Line 18: , p_commit IN VARCHAR2 := fnd_api.g_false

14:
15: PROCEDURE Check_Purge_LPNs (
16: p_api_version IN NUMBER
17: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
18: , p_commit IN VARCHAR2 := fnd_api.g_false
19: , x_return_status OUT NOCOPY VARCHAR2
20: , x_msg_count OUT NOCOPY NUMBER
21: , x_msg_data OUT NOCOPY VARCHAR2
22: , p_caller IN VARCHAR2

Line 43: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

39: -- Standard Start of API savepoint
40: SAVEPOINT Check_Purge_LPN_PVT;
41:
42: -- Standard call to check for call compatibility.
43: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
44: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
45: fnd_msg_pub.ADD;
46: RAISE fnd_api.g_exc_unexpected_error;
47: END IF;

Line 46: RAISE fnd_api.g_exc_unexpected_error;

42: -- Standard call to check for call compatibility.
43: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
44: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
45: fnd_msg_pub.ADD;
46: RAISE fnd_api.g_exc_unexpected_error;
47: END IF;
48:
49: -- Initialize message list if p_init_msg_list is set to TRUE.
50: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 50: IF fnd_api.to_boolean(p_init_msg_list) THEN

46: RAISE fnd_api.g_exc_unexpected_error;
47: END IF;
48:
49: -- Initialize message list if p_init_msg_list is set to TRUE.
50: IF fnd_api.to_boolean(p_init_msg_list) THEN
51: fnd_msg_pub.initialize;
52: END IF;
53:
54: -- Initialize API return status to success

Line 55: x_return_status := fnd_api.g_ret_sts_success;

51: fnd_msg_pub.initialize;
52: END IF;
53:
54: -- Initialize API return status to success
55: x_return_status := fnd_api.g_ret_sts_success;
56:
57: l_progress := 'Bulk insert LPNs into temp table for validation';
58: FORALL i IN p_lpn_id_table.first .. p_lpn_id_table.last
59: INSERT INTO WMS_TXN_CONTEXT_TEMP ( line_id, txn_source_name )

Line 114: x_return_status := fnd_api.g_ret_sts_unexp_error;

110: -- Standard call to get message count and data
111: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
112: EXCEPTION
113: WHEN OTHERS THEN
114: x_return_status := fnd_api.g_ret_sts_unexp_error;
115: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
116: IF (l_debug = 1) THEN
117: inv_trx_util_pub.trace(l_api_name ||' Error progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), l_api_name, 1);
118: END IF;

Line 124: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

120: END Check_Purge_LPNs;
121:
122: PROCEDURE Purge_LPNs (
123: p_api_version IN NUMBER
124: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
125: , p_commit IN VARCHAR2 := fnd_api.g_false
126: , x_return_status OUT NOCOPY VARCHAR2
127: , x_msg_count OUT NOCOPY NUMBER
128: , x_msg_data OUT NOCOPY VARCHAR2

Line 125: , p_commit IN VARCHAR2 := fnd_api.g_false

121:
122: PROCEDURE Purge_LPNs (
123: p_api_version IN NUMBER
124: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
125: , p_commit IN VARCHAR2 := fnd_api.g_false
126: , x_return_status OUT NOCOPY VARCHAR2
127: , x_msg_count OUT NOCOPY NUMBER
128: , x_msg_data OUT NOCOPY VARCHAR2
129: , p_caller IN VARCHAR2

Line 148: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

144: -- Standard Start of API savepoint
145: SAVEPOINT PURGE_LPNS_PVT;
146:
147: -- Standard call to check for call compatibility.
148: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
149: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
150: fnd_msg_pub.ADD;
151: RAISE fnd_api.g_exc_unexpected_error;
152: END IF;

Line 151: RAISE fnd_api.g_exc_unexpected_error;

147: -- Standard call to check for call compatibility.
148: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
149: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
150: fnd_msg_pub.ADD;
151: RAISE fnd_api.g_exc_unexpected_error;
152: END IF;
153:
154: -- Initialize message list if p_init_msg_list is set to TRUE.
155: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 155: IF fnd_api.to_boolean(p_init_msg_list) THEN

151: RAISE fnd_api.g_exc_unexpected_error;
152: END IF;
153:
154: -- Initialize message list if p_init_msg_list is set to TRUE.
155: IF fnd_api.to_boolean(p_init_msg_list) THEN
156: fnd_msg_pub.initialize;
157: END IF;
158:
159: -- Initialize API return status to success

Line 160: x_return_status := fnd_api.g_ret_sts_success;

156: fnd_msg_pub.initialize;
157: END IF;
158:
159: -- Initialize API return status to success
160: x_return_status := fnd_api.g_ret_sts_success;
161:
162: l_progress := 'Delete from packaging history of all content packages';
163: FORALL i IN p_lpn_id_table.first..p_lpn_id_table.last
164: DELETE FROM WMS_PACKAGING_HIST

Line 225: x_return_status := fnd_api.g_ret_sts_unexp_error;

221:
222:
223: EXCEPTION
224: WHEN OTHERS THEN
225: x_return_status := fnd_api.g_ret_sts_unexp_error;
226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
227: IF (l_debug = 1) THEN
228: inv_trx_util_pub.trace(l_api_name ||' Error progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), l_api_name, 1);
229: END IF;

Line 321: , p_init_msg_list => fnd_api.g_false

317: END IF;
318:
319: Check_Purge_LPNs (
320: p_api_version => 1.0
321: , p_init_msg_list => fnd_api.g_false
322: , p_commit => fnd_api.g_false
323: , x_return_status => l_return_status
324: , x_msg_count => x_msg_count
325: , x_msg_data => x_msg_data

Line 322: , p_commit => fnd_api.g_false

318:
319: Check_Purge_LPNs (
320: p_api_version => 1.0
321: , p_init_msg_list => fnd_api.g_false
322: , p_commit => fnd_api.g_false
323: , x_return_status => l_return_status
324: , x_msg_count => x_msg_count
325: , x_msg_data => x_msg_data
326: , p_caller => 'Purge_WMS'

Line 330: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN

326: , p_caller => 'Purge_WMS'
327: , p_lock_flag => 'Y'
328: , p_lpn_id_table => l_lpn_tbl );
329:
330: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
331: FND_MESSAGE.SET_NAME('INV','INV_API_PURGE_ERROR');
332: FND_MESSAGE.SET_TOKEN('API', 'Check_Purge_LPNs');
333: FND_MSG_PUB.ADD;
334: EXIT;

Line 349: , p_init_msg_list => fnd_api.g_false

345: END LOOP;
346:
347: WSH_WMS_LPN_GRP.Check_purge (
348: p_api_version_number => 1.0
349: , p_init_msg_list => fnd_api.g_false
350: , p_commit => fnd_api.g_false
351: , x_return_status => l_return_status
352: , x_msg_count => x_msg_count
353: , x_msg_data => x_msg_data

Line 350: , p_commit => fnd_api.g_false

346:
347: WSH_WMS_LPN_GRP.Check_purge (
348: p_api_version_number => 1.0
349: , p_init_msg_list => fnd_api.g_false
350: , p_commit => fnd_api.g_false
351: , x_return_status => l_return_status
352: , x_msg_count => x_msg_count
353: , x_msg_data => x_msg_data
354: , p_lpn_rec => l_wsh_lpn_rec );

Line 356: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN

352: , x_msg_count => x_msg_count
353: , x_msg_data => x_msg_data
354: , p_lpn_rec => l_wsh_lpn_rec );
355:
356: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
357: FND_MESSAGE.SET_NAME('INV','INV_API_PURGE_ERROR');
358: FND_MESSAGE.SET_TOKEN('API', 'WSH_WMS_LPN_GRP.Check_purge');
359: FND_MSG_PUB.ADD;
360: EXIT;

Line 381: , p_init_msg_list => fnd_api.g_false

377: l_tmp_purge_count := l_purge_count;
378:
379: Purge_LPNs (
380: p_api_version => 1.0
381: , p_init_msg_list => fnd_api.g_false
382: , p_commit => fnd_api.g_false
383: , x_return_status => l_return_status
384: , x_msg_count => x_msg_count
385: , x_msg_data => x_msg_data

Line 382: , p_commit => fnd_api.g_false

378:
379: Purge_LPNs (
380: p_api_version => 1.0
381: , p_init_msg_list => fnd_api.g_false
382: , p_commit => fnd_api.g_false
383: , x_return_status => l_return_status
384: , x_msg_count => x_msg_count
385: , x_msg_data => x_msg_data
386: , p_caller => 'Purge_WMS'

Line 390: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN

386: , p_caller => 'Purge_WMS'
387: , p_lpn_id_table => l_lpn_tbl
388: , p_purge_count => l_purge_count );
389:
390: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
391: l_purge_count := l_tmp_purge_count;
392: FND_MESSAGE.SET_NAME('INV','INV_API_PURGE_ERROR');
393: FND_MESSAGE.SET_TOKEN('API', 'Purge_LPNs');
394: FND_MSG_PUB.ADD;