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

Line 37: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE

33:
34: PROCEDURE Process_Line
35: (
36: p_api_version IN NUMBER
37: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
38: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
39: , p_mo_hdr_rec IN GMI_Move_Order_Global.mo_hdr_rec
40: , p_mo_line_rec IN GMI_Move_Order_Global.mo_line_rec
41: , p_grouping_rule_id IN NUMBER

Line 38: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

34: PROCEDURE Process_Line
35: (
36: p_api_version IN NUMBER
37: , p_validation_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE
38: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
39: , p_mo_hdr_rec IN GMI_Move_Order_Global.mo_hdr_rec
40: , p_mo_line_rec IN GMI_Move_Order_Global.mo_line_rec
41: , p_grouping_rule_id IN NUMBER
42: , p_print_mode IN VARCHAR2

Line 43: , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE

39: , p_mo_hdr_rec IN GMI_Move_Order_Global.mo_hdr_rec
40: , p_mo_line_rec IN GMI_Move_Order_Global.mo_line_rec
41: , p_grouping_rule_id IN NUMBER
42: , p_print_mode IN VARCHAR2
43: , p_allow_partial_pick IN VARCHAR2 DEFAULT FND_API.G_TRUE
44: , p_allow_delete IN VARCHAR2 DEFAULT NULL
45: , x_detail_rec_count OUT NOCOPY NUMBER
46: , x_return_status OUT NOCOPY VARCHAR2
47: , x_msg_count OUT NOCOPY NUMBER

Line 145: IF NOT fnd_api.Compatible_API_Call(l_api_version

141: GMI_Reservation_Util.PrintLn('Entering_GMI_Pick_Release_PVT.');
142:
143: SAVEPOINT Process_Line_PVT;
144: /* Standard Call to check for call compatibility */
145: IF NOT fnd_api.Compatible_API_Call(l_api_version
146: , p_api_version
147: , l_api_name
148: , G_PKG_NAME) THEN
149: RAISE FND_API.g_exc_unexpected_error;

Line 149: RAISE FND_API.g_exc_unexpected_error;

145: IF NOT fnd_api.Compatible_API_Call(l_api_version
146: , p_api_version
147: , l_api_name
148: , G_PKG_NAME) THEN
149: RAISE FND_API.g_exc_unexpected_error;
150: END IF;
151:
152: /* Initialize API return status to success */
153: x_return_status := FND_API.g_ret_sts_success;

Line 153: x_return_status := FND_API.g_ret_sts_success;

149: RAISE FND_API.g_exc_unexpected_error;
150: END IF;
151:
152: /* Initialize API return status to success */
153: x_return_status := FND_API.g_ret_sts_success;
154:
155: --==================================================================
156:
157: l_p_allow_delete := p_allow_delete;

Line 178: , FND_API.G_FALSE

174: GMI_Reservation_Util.PrintLn('l_tran_rec.trans_id = ' || l_tran_rec.trans_id);
175:
176: GMI_TRANS_ENGINE_PUB.delete_pending_transaction
177: ( 1
178: , FND_API.G_FALSE
179: , FND_API.G_FALSE
180: , FND_API.G_VALID_LEVEL_FULL
181: , l_tran_rec
182: , l_tran_row

Line 179: , FND_API.G_FALSE

175:
176: GMI_TRANS_ENGINE_PUB.delete_pending_transaction
177: ( 1
178: , FND_API.G_FALSE
179: , FND_API.G_FALSE
180: , FND_API.G_VALID_LEVEL_FULL
181: , l_tran_rec
182: , l_tran_row
183: , x_return_status

Line 180: , FND_API.G_VALID_LEVEL_FULL

176: GMI_TRANS_ENGINE_PUB.delete_pending_transaction
177: ( 1
178: , FND_API.G_FALSE
179: , FND_API.G_FALSE
180: , FND_API.G_VALID_LEVEL_FULL
181: , l_tran_rec
182: , l_tran_row
183: , x_return_status
184: , x_msg_count

Line 190: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

186: );
187:
188: GMI_Reservation_Util.PrintLn('return from DELETE PENDING TRANS x_return_status = ' || x_return_status);
189:
190: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
191: THEN
192: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;

Line 193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

189:
190: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
191: THEN
192: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195: FETCH c_get_trans_id INTO ic_tran_tbl_row;
196: END LOOP;
197: CLOSE c_get_trans_id;

Line 216: IF (p_allow_partial_pick = FND_API.G_FALSE)

212:
213: /* Override the printing mode to deferred if allow partial pick is false. */
214: /* Otherwise set it based on the parameter passed in. */
215: -- Bug 1717145, 2-Apr-2001, odaboval, set the print_mode
216: IF (p_allow_partial_pick = FND_API.G_FALSE)
217: THEN
218: l_pick_slip_mode := 'E';
219: ELSE
220: l_pick_slip_mode := p_print_mode;

Line 247: RAISE FND_API.G_EXC_ERROR;

243: FND_MESSAGE.SET_NAME('GMI','INV_ITEM_NOTFOUND');
244: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_mo_line_rec.organization_id);
245: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_mo_line_rec.inventory_item_id);
246: FND_MSG_PUB.Add;
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249: CLOSE c_mtl_items;
250:
251: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PVT. To find : SecondInventory, from_subInv_code='||p_mo_line_rec.from_subinventory_code);

Line 266: RAISE FND_API.G_EXC_ERROR;

262: FND_MESSAGE.SET_NAME('GMI','INV_DELIV_INFO_MISSING');
263: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_mo_line_rec.organization_id);
264: FND_MESSAGE.Set_Token('FROM_SUBINVENTORY_CODE', p_mo_line_rec.from_subinventory_code);
265: FND_MSG_PUB.Add;
266: RAISE FND_API.G_EXC_ERROR;
267: END IF;
268: CLOSE c_second_inventory;
269: END IF;
270:

Line 282: RAISE FND_API.G_EXC_ERROR;

278: THEN
279: FND_MESSAGE.set_name('GMI', 'INV_INT_TXN_CODE');
280: FND_MESSAGE.Set_Token('TRANSACTION_TYPE_ID', p_mo_line_rec.transaction_type_id);
281: FND_MSG_PUB.add;
282: RAISE FND_API.G_EXC_ERROR;
283: END IF;
284: CLOSE c_transaction_type;
285:
286: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PVT. Transaction Type found!');

Line 294: RAISE FND_API.G_EXC_ERROR;

290: IF ( l_mso_header_id IS NULL ) THEN
291: FND_MESSAGE.SET_NAME('GMI','INV_COULD_NOT_GET_MSO_HEADER');
292: FND_MESSAGE.Set_Token('OE_HEADER_ID', l_demand_info.oe_header_id);
293: FND_MSG_PUB.Add;
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296:
297: /* find out the corresponding delivery detail id to fill in ic_tran_pnd */
298: /* this could result more than 1 delivery, need to do a loop for the deliveries */

Line 312: l_qry_rsv_rec.supply_source_type_id := FND_API.G_MISS_NUM;

308: l_qry_rsv_rec.inventory_item_id := p_mo_line_rec.inventory_item_id;
309: l_qry_rsv_rec.demand_source_type_id := l_demand_source_type;
310: l_qry_rsv_rec.demand_source_header_id := l_mso_header_id;
311: l_qry_rsv_rec.demand_source_line_id := l_demand_info.oe_line_id;
312: l_qry_rsv_rec.supply_source_type_id := FND_API.G_MISS_NUM;
313: l_qry_rsv_rec.reservation_uom_code := p_mo_line_rec.uom_code;
314: /* B1800659 */
315: --l_qry_rsv_rec.reservation_quantity := nvl(p_mo_line_rec.quantity,0)
316: -- - nvl(p_mo_line_rec.quantity_delivered,0);

Line 363: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

359: , x_msg_count => x_msg_count
360: , x_msg_data => x_msg_data);
361:
362: /* Return an error if the Reallocation call failed */
363: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
364: ROLLBACK TO Process_Line_PVT;
365: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
366: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Reallocate');
367: FND_MESSAGE.Set_Token('WHERE', 'GMI_Pick_Release_PVT.Process_Line');

Line 369: RAISE FND_API.G_EXC_ERROR;

365: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
366: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Reallocate');
367: FND_MESSAGE.Set_Token('WHERE', 'GMI_Pick_Release_PVT.Process_Line');
368: FND_MSG_PUB.Add;
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371: END LOOP;
372: END IF; /* The item is reservable */
373:

Line 390: /* RAISE fnd_api.g_exc_unexpected_error; */

386: /* GMI_Reservation_Util.PrintLn('qty detailed < mo_line.primary_qty : Couldnt Pick Full'); */
387: /* ROLLBACK TO Process_Line_PVT; */
388: /* FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_PICK_FULL'); */
389: /* FND_MSG_PUB.Add; */
390: /* RAISE fnd_api.g_exc_unexpected_error; */
391: /* END IF; */
392:
393: /* ============================================================================ */
394: /* Set the returned values : */

Line 424: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

420: , x_msg_data => x_msg_data);
421:
422: /* , p_allow_partial_pick => p_allow_partial_pick */
423:
424: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
425: ROLLBACK TO Process_Line_PVT;
426: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
427: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Pick_Slip_and_Print');
428: FND_MESSAGE.Set_Token('WHERE', 'GMI_Pick_Release_PVT.Process_Line');

Line 430: RAISE FND_API.G_EXC_ERROR;

426: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
427: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Pick_Slip_and_Print');
428: FND_MESSAGE.Set_Token('WHERE', 'GMI_Pick_Release_PVT.Process_Line');
429: FND_MSG_PUB.Add;
430: RAISE FND_API.G_EXC_ERROR;
431: END IF;
432:
433:
434: GMI_Reservation_Util.PrintLn('In the end of GMI_Pick_Release_PVT.Process_Line : NO Error, detail_rec_count='||x_detail_rec_count);

Line 438: WHEN FND_API.G_EXC_ERROR THEN

434: GMI_Reservation_Util.PrintLn('In the end of GMI_Pick_Release_PVT.Process_Line : NO Error, detail_rec_count='||x_detail_rec_count);
435:
436:
437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439: x_return_status := FND_API.G_RET_STS_ERROR;
440:
441: /* Get message count and data */
442: FND_MSG_PUB.count_and_get

Line 439: x_return_status := FND_API.G_RET_STS_ERROR;

435:
436:
437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439: x_return_status := FND_API.G_RET_STS_ERROR;
440:
441: /* Get message count and data */
442: FND_MSG_PUB.count_and_get
443: ( p_count => x_msg_count

Line 449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

445: );
446:
447:
448: WHEN OTHERS THEN
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450:
451: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
452: , l_api_name
453: );