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

Line 184: WHEN FND_API.G_EXC_ERROR THEN

180: fnd_file.put_line(fnd_file.log,'after card activity');
181: end loop;
182:
183: EXCEPTION
184: WHEN FND_API.G_EXC_ERROR THEN
185: fnd_file.put_line(fnd_file.log,'Error in Create_Requisition '||sqlerrm(sqlcode));
186: Raise FND_API.G_EXC_ERROR;
187: WHEN OTHERS THEN
188: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 186: Raise FND_API.G_EXC_ERROR;

182:
183: EXCEPTION
184: WHEN FND_API.G_EXC_ERROR THEN
185: fnd_file.put_line(fnd_file.log,'Error in Create_Requisition '||sqlerrm(sqlcode));
186: Raise FND_API.G_EXC_ERROR;
187: WHEN OTHERS THEN
188: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
189: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Create_Requisition');
190: END IF;

Line 192: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

188: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
189: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Create_Requisition');
190: END IF;
191: fnd_file.put_line(fnd_file.log,'Error in Create_Requisition '||sqlerrm(sqlcode));
192: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
193: end Create_Requisition;
194:
195: Procedure Create_Transfer_Order(
196: p_kanban_card_rec_tbl IN t_cards_to_consolidate,

Line 204: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

200: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
201: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
202: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
203: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
204: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
205: l_msg_count NUMBER;
206: l_msg_data VARCHAR2(240);
207: msg VARCHAR2(2000);
208: l_header_id Number := FND_API.G_MISS_NUM;

Line 208: l_header_id Number := FND_API.G_MISS_NUM;

204: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
205: l_msg_count NUMBER;
206: l_msg_data VARCHAR2(240);
207: msg VARCHAR2(2000);
208: l_header_id Number := FND_API.G_MISS_NUM;
209: l_line_num Number := 0;
210: l_item_locator_control_code NUMBER;
211: l_from_sub_locator_type NUMBER;
212: l_to_sub_locator_type NUMBER;

Line 241: l_trohdr_rec.db_flag := FND_API.G_TRUE;

237: l_trohdr_rec.status_date := sysdate;
238: l_trohdr_rec.to_subinventory_code := l_Kanban_Card_Rec_Tbl(1).subinventory_name;
239: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
240: l_trohdr_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_REPLENISHMENT;
241: l_trohdr_rec.db_flag := FND_API.G_TRUE;
242: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
243: fnd_file.put_line(fnd_file.log,'before loop');
244: For l_order_count in 1..l_Kanban_Card_Rec_Tbl.Count Loop
245: fnd_file.put_line(fnd_file.log,'inside loop');

Line 299: l_trolin_tbl(l_order_count).line_id := FND_API.G_MISS_NUM;

295: l_trolin_tbl(l_order_count).inventory_item_id := l_Kanban_Card_Rec_Tbl(l_order_count).inventory_item_id;
296: l_trolin_tbl(l_order_count).last_updated_by := FND_GLOBAL.USER_ID;
297: l_trolin_tbl(l_order_count).last_update_date := sysdate;
298: l_trolin_tbl(l_order_count).last_update_login := FND_GLOBAL.LOGIN_ID;
299: l_trolin_tbl(l_order_count).line_id := FND_API.G_MISS_NUM;
300: l_trolin_tbl(l_order_count).line_number := l_line_num;
301: l_trolin_tbl(l_order_count).line_status := INV_Globals.G_TO_STATUS_PREAPPROVED;
302: l_trolin_tbl(l_order_count).organization_id := l_Kanban_Card_Rec_Tbl(l_order_count).organization_id;
303: l_trolin_tbl(l_order_count).quantity := l_Kanban_Card_Rec_Tbl(l_order_count).kanban_size;

Line 332: RAISE FND_API.g_exc_error;

328: ,to_name => NULL);
329: IF l_secondary_qty < 0 THEN
330: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order '||'Uom Conversion Failed for Creating Transfer Order:'||
331: l_Kanban_Card_Rec_Tbl(1).inventory_item_id|| ', '|| l_Kanban_Card_Rec_Tbl(1).organization_id||l_proc_name);
332: RAISE FND_API.g_exc_error;
333: END IF ;
334: ELSE
335: l_secondary_uom_code := NULL ;
336: l_secondary_qty := NULL ;

Line 342: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;

338:
339: l_trolin_tbl(l_order_count).to_subinventory_code:= l_Kanban_Card_Rec_Tbl(1).subinventory_name;
340: l_trolin_tbl(l_order_count).uom_code := p_primary_uom_code;
341: l_trolin_tbl(l_order_count).transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_SUBXFR;
342: l_trolin_tbl(l_order_count).db_flag := FND_API.G_TRUE;
343: l_trolin_tbl(l_order_count).operation := INV_GLOBALS.G_OPR_CREATE;
344: l_trolin_tbl(l_order_count).secondary_quantity := l_secondary_qty;
345: l_trolin_tbl(l_order_count).secondary_uom := l_secondary_uom_code;
346:

Line 351: p_init_msg_list => FND_API.G_TRUE,

347: END LOOP;
348:
349: INV_Transfer_Order_PVT.Process_Transfer_Order
350: ( p_api_version_number => 1.0 ,
351: p_init_msg_list => FND_API.G_TRUE,
352: x_return_status => l_return_status,
353: x_msg_count => l_msg_count,
354: x_msg_data => l_msg_data,
355: p_trohdr_rec => l_trohdr_rec,

Line 361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

357: x_trohdr_rec => l_x_trohdr_rec,
358: x_trolin_tbl => l_x_trolin_tbl
359: );
360:
361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
362: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Create_transfer_order');
363: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order '||sqlerrm(sqlcode));
364: RAISE FND_API.g_exc_error;
365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 364: RAISE FND_API.g_exc_error;

360:
361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
362: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Create_transfer_order');
363: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order '||sqlerrm(sqlcode));
364: RAISE FND_API.g_exc_error;
365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
366: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Create_transfer_order');
367: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order '||sqlerrm(sqlcode));
368: RAISE FND_API.g_exc_error;

Line 365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
362: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Create_transfer_order');
363: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order '||sqlerrm(sqlcode));
364: RAISE FND_API.g_exc_error;
365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
366: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Create_transfer_order');
367: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order '||sqlerrm(sqlcode));
368: RAISE FND_API.g_exc_error;
369: END IF;

Line 368: RAISE FND_API.g_exc_error;

364: RAISE FND_API.g_exc_error;
365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
366: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Create_transfer_order');
367: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order '||sqlerrm(sqlcode));
368: RAISE FND_API.g_exc_error;
369: END IF;
370:
371: BEGIN
372: SELECT MKP.auto_allocate_flag INTO l_auto_Allocate_flag

Line 410: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

406: SELECT MTRH.request_number INTO l_mo_request_number
407: FROM Mtl_Txn_Request_Headers MTRH
408: WHERE MTRH.Header_id = l_Kanban_Card_Rec_Tbl(1).document_header_id;
409:
410: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
411: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_MO_ALLOC_SUCCESS');
412: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
413: FND_MSG_PUB.Add;
414: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order during auto allocate '||fnd_message.get);

Line 415: RAISE FND_API.g_exc_error;

411: FND_MESSAGE.SET_NAME('INV','INV_KANBAN_MO_ALLOC_SUCCESS');
412: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
413: FND_MSG_PUB.Add;
414: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order during auto allocate '||fnd_message.get);
415: RAISE FND_API.g_exc_error;
416: ELSE
417: FND_MESSAGE.SET_NAME('INV','INV_MO_ALLOC_FAIL');
418: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
419: FND_MSG_PUB.Add;

Line 421: RAISE FND_API.g_exc_error;

417: FND_MESSAGE.SET_NAME('INV','INV_MO_ALLOC_FAIL');
418: FND_MESSAGE.SET_TOKEN('MOVE_ORDER',l_mo_request_number);
419: FND_MSG_PUB.Add;
420: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order during auto allocate '||fnd_message.get);
421: RAISE FND_API.g_exc_error;
422: END IF;
423: END IF;
424:
425: EXCEPTION

Line 426: WHEN FND_API.G_EXC_ERROR THEN

422: END IF;
423: END IF;
424:
425: EXCEPTION
426: WHEN FND_API.G_EXC_ERROR THEN
427: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order '||sqlerrm(sqlcode));
428: Raise FND_API.G_EXC_ERROR;
429: WHEN OTHERS THEN
430: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 428: Raise FND_API.G_EXC_ERROR;

424:
425: EXCEPTION
426: WHEN FND_API.G_EXC_ERROR THEN
427: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order '||sqlerrm(sqlcode));
428: Raise FND_API.G_EXC_ERROR;
429: WHEN OTHERS THEN
430: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
431: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,'Create_Transfer_Order');
432: END IF;

Line 434: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

430: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
431: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,'Create_Transfer_Order');
432: END IF;
433: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order '||sqlerrm(sqlcode));
434: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
435: END Create_Transfer_Order;
436:
437:
438: PROCEDURE Create_Replenishment

Line 662: WHEN FND_API.G_EXC_ERROR THEN

658: FND_MSG_PUB.Add;
659: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||fnd_message.get);
660: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||sqlerrm(sqlcode));
661: x_return_status := 1;
662: WHEN FND_API.G_EXC_ERROR THEN
663: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||fnd_message.get);
664: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||sqlerrm(sqlcode));
665: x_return_status := 1;
666: WHEN OTHERS THEN