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_CONTAINER_GRP dependencies on FND_API

Line 42: x_return_status := fnd_api.g_ret_sts_success;

38: BEGIN
39: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
40: l_api_name := 'Auto_Create_LPNs';
41:
42: x_return_status := fnd_api.g_ret_sts_success;
43:
44: /* Validate input parameters in p_gen_lpn_rec */
45: /* Required parameters: organization_id, quantity */
46: IF p_gen_lpn_rec.organization_id IS NULL THEN

Line 52: RAISE fnd_api.g_exc_error;

48: mdebug('Organization is required, can not auto create LPN ');
49: END IF;
50: fnd_message.set_name('INV','INV_ORG_REQUIRED');
51: fnd_msg_pub.add;
52: RAISE fnd_api.g_exc_error;
53:
54: ELSIF p_gen_lpn_rec.quantity IS NULL THEN
55: IF (l_debug = 1) THEN
56: mdebug('Quantity is required, can not auto create LPN ');

Line 60: RAISE fnd_api.g_exc_error;

56: mdebug('Quantity is required, can not auto create LPN ');
57: END IF;
58: fnd_message.set_name('WMS','WMS_QUANTITY_REQUIRED');
59: fnd_msg_pub.add;
60: RAISE fnd_api.g_exc_error;
61:
62: END IF;
63:
64: /* Set value for ucc_128_suffix_flag

Line 112: WHEN FND_API.G_EXC_ERROR THEN

108: , x_created_lpns => p_lpn_table
109: );
110:
111: EXCEPTION
112: WHEN FND_API.G_EXC_ERROR THEN
113: x_return_status := fnd_api.g_ret_sts_error;
114: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
115: IF (l_debug = 1) THEN
116: FOR i in 1..x_msg_count LOOP

Line 113: x_return_status := fnd_api.g_ret_sts_error;

109: );
110:
111: EXCEPTION
112: WHEN FND_API.G_EXC_ERROR THEN
113: x_return_status := fnd_api.g_ret_sts_error;
114: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
115: IF (l_debug = 1) THEN
116: FOR i in 1..x_msg_count LOOP
117: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);

Line 123: x_return_status := fnd_api.g_ret_sts_unexp_error;

119: mdebug(l_api_name ||' SQL error: '|| SQLERRM(SQLCODE), G_ERROR);
120: mdebug('msg: '||l_msgdata, G_ERROR);
121: END IF;
122: WHEN OTHERS THEN
123: x_return_status := fnd_api.g_ret_sts_unexp_error;
124: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
125: IF (l_debug = 1) THEN
126: mdebug(l_api_name ||' SQL error: '|| SQLERRM(SQLCODE), G_ERROR);
127: END IF;

Line 142: x_return_status := fnd_api.g_ret_sts_success;

138: , p_caller IN VARCHAR2
139: , p_lpn_table IN OUT NOCOPY WMS_Data_Type_Definitions_PUB.LPNTableType
140: ) IS
141: BEGIN
142: x_return_status := fnd_api.g_ret_sts_success;
143:
144: /* Call Create_LPNs prcedure in private package */
145: WMS_CONTAINER_PVT.Create_LPNs (
146: p_api_version => p_api_version

Line 169: x_return_status := fnd_api.g_ret_sts_success;

165: , p_caller IN VARCHAR2
166: , p_lpn_table IN WMS_Data_Type_Definitions_PUB.LPNTableType
167: ) IS
168: BEGIN
169: x_return_status := fnd_api.g_ret_sts_success;
170:
171: /* Call Modify_LPNs prcedure in private package */
172: WMS_CONTAINER_PVT.Modify_LPNs (
173: p_api_version => p_api_version

Line 207: x_return_status := fnd_api.g_ret_sts_success;

203: BEGIN
204: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
205: l_api_name := 'LPN_Purge_Actions';
206:
207: x_return_status := fnd_api.g_ret_sts_success;
208:
209: IF (l_debug = 1) THEN
210: mdebug(l_api_name || ' Entered ' || g_pkg_version);
211: mdebug('ver='||p_api_version||' initmsg='||p_init_msg_list||' commit='||p_commit||' caller='||p_caller);

Line 237: IF x_return_status = fnd_api.g_ret_sts_success THEN

233: , p_lock_flag => 'N'
234: , p_lpn_id_table => l_valid_lpns
235: );
236:
237: IF x_return_status = fnd_api.g_ret_sts_success THEN
238: IF (l_debug = 1) THEN
239: mdebug('Number of validated LPNs: '||l_valid_lpns.count);
240: END IF;
241: p_lpn_purge_rec.lpn_ids := l_valid_lpns;

Line 269: IF x_return_status <> fnd_api.g_ret_sts_success THEN

265: , p_lock_flag => 'Y'
266: , p_lpn_id_table => l_valid_lpns
267: );
268:
269: IF x_return_status <> fnd_api.g_ret_sts_success THEN
270: IF (l_debug = 1) THEN
271: mdebug('Error calling Check_Purge_LPNs, can not proceed');
272: END IF;
273: RETURN;

Line 284: RAISE FND_API.G_EXC_ERROR;

280: mdebug('Validation failed, can not proceed');
281: END IF;
282: fnd_message.set_name('WMS','WMS_LPN_PURGE_VALIDATION');
283: fnd_msg_pub.add;
284: RAISE FND_API.G_EXC_ERROR;
285: ELSE
286: -- Validation passed, call Purge_LPNs to delete LPNs
287: IF (l_debug = 1) THEN
288: mdebug('Validation passed, calling WMS_PURGE_PVT.Purge_LPNs');

Line 303: END IF; -- End if of x_return_status<>fnd_api.g_ret_sts_success

299: , p_purge_count => l_purge_count
300: );
301: END IF; -- End if of l_valid_lpns.count<>p_lpn_purge_rec.lpn_ids.count
302:
303: END IF; -- End if of x_return_status<>fnd_api.g_ret_sts_success
304:
305: END IF; -- End if of p_action
306: EXCEPTION
307: WHEN FND_API.G_EXC_ERROR THEN

Line 307: WHEN FND_API.G_EXC_ERROR THEN

303: END IF; -- End if of x_return_status<>fnd_api.g_ret_sts_success
304:
305: END IF; -- End if of p_action
306: EXCEPTION
307: WHEN FND_API.G_EXC_ERROR THEN
308: x_return_status := fnd_api.g_ret_sts_error;
309: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
310: IF (l_debug = 1) THEN
311: FOR i in 1..x_msg_count LOOP

Line 308: x_return_status := fnd_api.g_ret_sts_error;

304:
305: END IF; -- End if of p_action
306: EXCEPTION
307: WHEN FND_API.G_EXC_ERROR THEN
308: x_return_status := fnd_api.g_ret_sts_error;
309: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
310: IF (l_debug = 1) THEN
311: FOR i in 1..x_msg_count LOOP
312: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);

Line 318: x_return_status := fnd_api.g_ret_sts_unexp_error;

314: mdebug(l_api_name ||' SQL error: '|| SQLERRM(SQLCODE), G_ERROR);
315: mdebug('msg: '||l_msgdata, G_ERROR);
316: END IF;
317: WHEN OTHERS THEN
318: x_return_status := fnd_api.g_ret_sts_unexp_error;
319: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
320: IF (l_debug = 1) THEN
321: mdebug(l_api_name ||' SQL error: '|| SQLERRM(SQLCODE), G_ERROR);
322: END IF;