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

Line 42: | p_init_msg_list FND_API.G_TRUE to reset list

38: /***************************************************************************/
39: /*
40: | PARAMETERS:
41: | p_api_version Known api version
42: | p_init_msg_list FND_API.G_TRUE to reset list
43: | p_commit Commit flag. API commits if this is set.
44: | p_mo_line_id Move order line id to pick confirm
45: | p_delivery_detail_id Delivery detail id to pick confirm
46: | x_return_status Return status

Line 153: x_return_status := FND_API.G_RET_STS_SUCCESS;

149:
150: BEGIN
151: /*Init variables
152: =========================================*/
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154: l_default_lot := FND_PROFILE.VALUE('IC$DEFAULT_LOT');
155: l_default_loct := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
156:
157:

Line 166: IF NOT FND_API.compatible_api_call (

162:
163: /*Standard call to check for call compatibility.
164: ==============================================*/
165:
166: IF NOT FND_API.compatible_api_call (
167: l_api_version,
168: p_api_version,
169: l_api_name,
170: G_PKG_NAME)

Line 172: PrintMsg('FND_API.compatible_api_call failed');

168: p_api_version,
169: l_api_name,
170: G_PKG_NAME)
171: THEN
172: PrintMsg('FND_API.compatible_api_call failed');
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: END IF;
175:
176: /* Check p_init_msg_list

Line 173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

169: l_api_name,
170: G_PKG_NAME)
171: THEN
172: PrintMsg('FND_API.compatible_api_call failed');
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: END IF;
175:
176: /* Check p_init_msg_list
177: =========================================*/

Line 178: IF FND_API.to_boolean(p_init_msg_list)

174: END IF;
175:
176: /* Check p_init_msg_list
177: =========================================*/
178: IF FND_API.to_boolean(p_init_msg_list)
179: THEN
180: FND_MSG_PUB.initialize;
181: END IF;
182:

Line 221: RAISE FND_API.G_EXC_ERROR;

217: p_mo_line_id);
218: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_MO_LINE_ID');
219: FND_MESSAGE.SET_TOKEN('MO_LINE_ID ',p_mo_line_id );
220: FND_MSG_PUB.Add;
221: RAISE FND_API.G_EXC_ERROR;
222: END IF;
223:
224: CLOSE move_order_line_cur;
225: /* Else see if delivery line is passed */

Line 240: RAISE FND_API.G_EXC_ERROR;

236: CLOSE move_order_line_cur2;
237: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_DEL_DETAIL_ID');
238: FND_MESSAGE.SET_TOKEN('DEL_DETAIL_ID',p_delivery_detail_id );
239: FND_MSG_PUB.Add;
240: RAISE FND_API.G_EXC_ERROR;
241: END IF;
242: CLOSE move_order_line_cur2;
243: /* Neither the move order nor the delivery detail is passed */
244: ELSE

Line 248: RAISE FND_API.G_EXC_ERROR;

244: ELSE
245: PrintMsg('ERROR: No move order line or delivery delivery detail line is passed ');
246: FND_MESSAGE.SET_NAME('GMI','GMI_API_NO_INPUT_LINE_ID');
247: FND_MSG_PUB.Add;
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250:
251:
252: -- Get OPM Item Id from Inventory_item_id

Line 263: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

259: , x_msg_count => x_msg_count
260: , x_msg_data => x_msg_data) ;
261:
262:
263: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
264: THEN
265: PrintMsg('ERROR - Get Item Details returned Error ');
266: FND_MESSAGE.Set_Name('GMI','GMI_API_ITEM_NOT_FOUND');
267: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_mo_line_row.organization_id);

Line 271: RAISE FND_API.G_EXC_ERROR;

267: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_mo_line_row.organization_id);
268: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_mo_line_row.inventory_item_id);
269: FND_MESSAGE.Set_Token('LINE_ID', l_mo_line_row.line_id);
270: FND_MSG_PUB.Add;
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273:
274: /* Print the Item Details */
275:

Line 292: RAISE FND_API.G_EXC_ERROR;

288: IF( get_whse_code_dtl%NOTFOUND )
289: THEN
290: CLOSE get_whse_code_dtl;
291: PrintMsg('ERROR - Warehouse does not exist ');
292: RAISE FND_API.G_EXC_ERROR;
293: END IF;
294: CLOSE get_whse_code_dtl;
295:
296: PrintMsg('The Warehouse Details : ' );

Line 317: RAISE FND_API.G_EXC_ERROR;

313: IF( trans_with_default_cur%NOTFOUND )
314: THEN
315: CLOSE trans_with_default_cur;
316: PrintMsg('ERROR - trans_with_default_cur failed ');
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319: CLOSE trans_with_default_cur;
320:
321: ELSE

Line 331: RAISE FND_API.G_EXC_ERROR;

327: IF( trans_with_no_default_cur%NOTFOUND )
328: THEN
329: CLOSE trans_with_no_default_cur;
330: PrintMsg('ERROR - trans_with_no_default_cur failed ');
331: RAISE FND_API.G_EXC_ERROR;
332: END IF;
333: CLOSE trans_with_no_default_cur;
334:
335: END IF;

Line 353: RAISE FND_API.G_EXC_ERROR;

349: FND_MESSAGE.Set_Name('GMI','GMI_API_NO_ALLOCATIONS');
350: FND_MESSAGE.Set_Token('MO_LINE_ID', l_mo_line_row.line_id);
351: FND_MESSAGE.Set_Token('DELIVERY_DETAIL_ID', p_delivery_detail_id);
352: FND_MSG_PUB.Add;
353: RAISE FND_API.G_EXC_ERROR;
354: END IF;
355:
356: /* Get The Move Order line (1 line) in to l_mo_line_tbl(1)
357: This has to be done 'coz the pvt expects mo_line_tbl */

Line 378: RAISE FND_API.G_EXC_ERROR;

374: PrintMsg('ERROR : Pick_Confirm : the MO is locked for line_id= '|| l_mo_line_row.line_id);
375: FND_MESSAGE.Set_Name('GMI','GMI_API_MO_LINE_LOCKED');
376: FND_MESSAGE.Set_Token('MO_LINE_ID', l_mo_line_row.line_id);
377: FND_MSG_PUB.Add;
378: RAISE FND_API.G_EXC_ERROR;
379: END IF;
380:
381:
382: /* Check That we have at least one Move Order Line Rec */

Line 391: RAISE FND_API.G_EXC_ERROR;

387: FND_MESSAGE.SET_NAME('GMI', 'GMI_API_NO_LINES_TO_PICK_CONF');
388: FND_MESSAGE.Set_Token('MO_LINE_ID', l_mo_line_row.line_id);
389: FND_MESSAGE.Set_Token('DELIVERY_DETAIL_ID', p_delivery_detail_id);
390: FND_MSG_PUB.Add;
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: PrintMsg('Before calling GMI_PICK_WAVE_CONFIRM_PVT.PICK_CONFIRM');
395:

Line 402: , p_commit => FND_API.G_FALSE

398: GMI_PICK_WAVE_CONFIRM_PVT.PICK_CONFIRM
399: (
400: p_api_version_number => p_api_version
401: , p_init_msg_lst => p_init_msg_list
402: , p_commit => FND_API.G_FALSE
403: , p_delivery_detail_id => p_delivery_detail_id
404: , p_mo_LINE_tbl => l_mo_line_tbl
405: , x_mo_LINE_tbl => ll_mo_line_tbl
406: , x_return_status => x_return_status

Line 412: IF(p_commit = FND_API.G_TRUE AND x_return_status <> FND_API.G_RET_STS_ERROR) THEN

408: , x_msg_data => x_msg_data
409: );
410:
411: /* Commit if p_commit is set to true and return_status is not error */
412: IF(p_commit = FND_API.G_TRUE AND x_return_status <> FND_API.G_RET_STS_ERROR) THEN
413: COMMIT;
414: END IF;
415:
416: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING )

Line 425: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS )

421: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
422: FND_MSG_PUB.Add;
423: RAISE L_WARNING;
424:
425: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS )
426: THEN
427: PrintMsg('ERROR : Returning from Pick_Confirm_Pvt with error');
428: FND_MESSAGE.SET_NAME('GMI','GMI_API_PICK_CONFIRM_ERROR');
429: FND_MESSAGE.SET_TOKEN('MO_LINE_ID',l_mo_line_rec.line_id);

Line 432: RAISE FND_API.G_EXC_ERROR;

428: FND_MESSAGE.SET_NAME('GMI','GMI_API_PICK_CONFIRM_ERROR');
429: FND_MESSAGE.SET_TOKEN('MO_LINE_ID',l_mo_line_rec.line_id);
430: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
431: FND_MSG_PUB.Add;
432: RAISE FND_API.G_EXC_ERROR;
433: ELSE
434: PrintMsg('SUCCESS : Returning from Pick_Confirm_Pvt with success');
435: END IF;
436:

Line 442: WHEN FND_API.G_EXC_ERROR THEN

438:
439: /* EXCEPTION HANDLING
440: ====================*/
441: EXCEPTION
442: WHEN FND_API.G_EXC_ERROR THEN
443:
444: --ROLLBACK TO SAVEPOINT Pick_Confirm_SP;
445:
446:

Line 447: x_return_status := FND_API.G_RET_STS_ERROR;

443:
444: --ROLLBACK TO SAVEPOINT Pick_Confirm_SP;
445:
446:
447: x_return_status := FND_API.G_RET_STS_ERROR;
448:
449: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
450: , l_api_name
451: );

Line 452: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

448:
449: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
450: , l_api_name
451: );
452: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
453: , p_count => x_msg_count
454: , p_data => x_msg_data
455: );
456:

Line 457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

453: , p_count => x_msg_count
454: , p_data => x_msg_data
455: );
456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: --ROLLBACK TO SAVEPOINT Pick_Confirm_SP;
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
460:
461: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

455: );
456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: --ROLLBACK TO SAVEPOINT Pick_Confirm_SP;
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
460:
461: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
462: , l_api_name
463: );

Line 464: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

460:
461: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
462: , l_api_name
463: );
464: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
465: , p_count => x_msg_count
466: , p_data => x_msg_data
467: );
468: WHEN L_WARNING THEN

Line 475: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

471:
472: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
473: , l_api_name
474: );
475: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
476: , p_count => x_msg_count
477: , p_data => x_msg_data);
478:
479: WHEN OTHERS THEN