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_FILE

Line 48: fnd_file.put_line(fnd_file.log,'Create_Requisition');

44: l_Current_Replenish_Cycle_Id Number;
45: l_group_code varchar2(500) := null;
46: l_Kanban_Card_Rec_Tbl t_cards_to_consolidate;
47: begin
48: fnd_file.put_line(fnd_file.log,'Create_Requisition');
49: l_project_accounting_context := null;
50:
51: l_Kanban_Card_Rec_Tbl := p_kanban_card_rec_tbl;
52:

Line 63: fnd_file.put_line(fnd_file.log,'before loop');

59: l_group_code := l_Kanban_Card_Rec_Tbl(1).pull_sequence_id||
60: l_Kanban_Card_Rec_Tbl(1).kanban_card_id||
61: l_Kanban_Card_Rec_Tbl(1).organization_id||
62: l_Kanban_Card_Rec_Tbl(1).current_replnsh_cycle_id;
63: fnd_file.put_line(fnd_file.log,'before loop');
64: For l_order_count in 1..l_Kanban_Card_Rec_Tbl.Count Loop
65: fnd_file.put_line(fnd_file.log,'inside loop');
66: IF (l_project_reference_enabled = 1)THEN
67: IF (l_Kanban_Card_Rec_Tbl(1).locator_id IS NOT NULL)THEN

Line 65: fnd_file.put_line(fnd_file.log,'inside loop');

61: l_Kanban_Card_Rec_Tbl(1).organization_id||
62: l_Kanban_Card_Rec_Tbl(1).current_replnsh_cycle_id;
63: fnd_file.put_line(fnd_file.log,'before loop');
64: For l_order_count in 1..l_Kanban_Card_Rec_Tbl.Count Loop
65: fnd_file.put_line(fnd_file.log,'inside loop');
66: IF (l_project_reference_enabled = 1)THEN
67: IF (l_Kanban_Card_Rec_Tbl(1).locator_id IS NOT NULL)THEN
68: SELECT project_id
69: INTO l_project_id

Line 170: fnd_file.put_line(fnd_file.log,'after card upd');

166: l_Kanban_Card_Rec_Tbl(l_order_count).Current_Replnsh_Cycle_Id := l_Current_Replenish_Cycle_Id;
167: l_Kanban_Card_Rec_Tbl(l_order_count).replenishment_count := nvl(l_Kanban_Card_Rec_Tbl(l_order_count).replenishment_count,0)+1;
168: l_Kanban_Card_Rec_Tbl(l_order_count).Last_Update_Date := SYSDATE;
169: l_Kanban_Card_Rec_Tbl(l_order_count).Last_Updated_By := FND_GLOBAL.USER_ID;
170: fnd_file.put_line(fnd_file.log,'after card upd');
171: Update Mtl_Kanban_Cards
172: Set Supply_Status = INV_Kanban_PVT.G_Supply_Status_Empty,
173: Current_Replnsh_Cycle_Id = l_Current_Replenish_Cycle_Id,
174: replenishment_count = nvl(replenishment_count,0)+1,

Line 180: fnd_file.put_line(fnd_file.log,'after card activity');

176: Last_Updated_By = FND_GLOBAL.USER_ID
177: Where Kanban_Card_Id = l_Kanban_Card_Rec_Tbl(l_order_count).Kanban_card_Id;
178:
179: INV_KanbanCard_PKG.Insert_Activity_For_Card(l_Kanban_Card_Rec_Tbl(l_order_count));
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

Line 185: fnd_file.put_line(fnd_file.log,'Error in Create_Requisition '||sqlerrm(sqlcode));

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
189: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Create_Requisition');

Line 191: fnd_file.put_line(fnd_file.log,'Error in Create_Requisition '||sqlerrm(sqlcode));

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;
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(

Line 223: fnd_file.put_line(fnd_file.log,'Create_Transfer_Order');

219: l_secondary_qty NUMBER;
220: l_Kanban_Card_Rec_Tbl t_cards_to_consolidate;
221: l_Current_Replenish_Cycle_Id Number;
222: begin
223: fnd_file.put_line(fnd_file.log,'Create_Transfer_Order');
224: l_Kanban_Card_Rec_Tbl := p_kanban_card_rec_tbl;
225: l_Current_Replenish_Cycle_Id := Get_Next_Replenish_Cycle_Id;
226: l_trohdr_rec.created_by := FND_GLOBAL.USER_ID;
227: l_trohdr_rec.creation_date := sysdate;

Line 243: fnd_file.put_line(fnd_file.log,'before loop');

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');
246: select location_control_code,secondary_uom_code
247: into l_item_locator_control_code,l_secondary_uom_code

Line 245: fnd_file.put_line(fnd_file.log,'inside loop');

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');
246: select location_control_code,secondary_uom_code
247: into l_item_locator_control_code,l_secondary_uom_code
248: from mtl_system_items
249: where organization_id = l_Kanban_Card_Rec_Tbl(l_order_count).organization_id

Line 330: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order '||'Uom Conversion Failed for Creating Transfer Order:'||

326: ,to_unit => l_secondary_uom_code
327: ,from_name => NULL
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

Line 363: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order '||sqlerrm(sqlcode));

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
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));

Line 367: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order '||sqlerrm(sqlcode));

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;
370:
371: BEGIN

Line 414: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order during auto allocate '||fnd_message.get);

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);
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);

Line 420: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order during auto allocate '||fnd_message.get);

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;
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:

Line 427: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order '||sqlerrm(sqlcode));

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
431: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,'Create_Transfer_Order');

Line 433: fnd_file.put_line(fnd_file.log,'Error in Create_Transfer_Order '||sqlerrm(sqlcode));

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;
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:

Line 476: fnd_file.put_line(fnd_file.log,'Create_replenishment');

472: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
473: l_consolidation_option NUMBER := null;
474: l_Kanban_Card_Rec_Tbl t_cards_to_consolidate;
475: Begin
476: fnd_file.put_line(fnd_file.log,'Create_replenishment');
477: l_Kanban_Card_Rec_Tbl := p_Kanban_Cards;
478:
479: l_sql_stmt_no := 5;
480:

Line 550: fnd_file.put_line(fnd_file.log,'sourcetype code');

546: and c.calendar_code = o.CALENDAR_CODE
547: and c.exception_set_id = o.CALENDAR_EXCEPTION_SET_ID
548: and c.calendar_date = trunc(sysdate);
549: END IF;
550: fnd_file.put_line(fnd_file.log,'sourcetype code');
551: if l_kanban_card_Rec_Tbl(1).source_Type = INV_Kanban_PVT.G_Source_Type_InterOrg Then
552: fnd_file.put_line(fnd_file.log,'inter1');
553: l_sql_stmt_no := 40;
554: select distinct org.location_id

Line 552: fnd_file.put_line(fnd_file.log,'inter1');

548: and c.calendar_date = trunc(sysdate);
549: END IF;
550: fnd_file.put_line(fnd_file.log,'sourcetype code');
551: if l_kanban_card_Rec_Tbl(1).source_Type = INV_Kanban_PVT.G_Source_Type_InterOrg Then
552: fnd_file.put_line(fnd_file.log,'inter1');
553: l_sql_stmt_no := 40;
554: select distinct org.location_id
555: into l_deliver_location_id
556: from hr_organization_units org,

Line 565: fnd_file.put_line(fnd_file.log,'supplier2');

561: and org.location_id = loc.location_id
562: and pla.location_id = loc.location_id;
563:
564: Elsif l_kanban_card_Rec_Tbl(1).source_Type = INV_Kanban_PVT.G_Source_Type_Supplier Then
565: fnd_file.put_line(fnd_file.log,'supplier2');
566: l_sql_stmt_no := 40;
567: select org.location_id
568: into l_deliver_location_id
569: from hr_organization_units org,

Line 606: fnd_file.put_line(fnd_file.log,'inter-final');

602:
603: If l_kanban_card_Rec_Tbl(1).source_type = INV_Kanban_PVT.G_Source_Type_InterOrg then
604: l_source_type_code := 'INVENTORY';
605: l_Requisition_type := 'INTERNAL';
606: fnd_file.put_line(fnd_file.log,'inter-final');
607: Create_Requisition( l_buyer_id, l_interface_source_code,
608: l_requisition_type, l_approval,
609: l_source_type_code, l_kanban_card_rec_tbl,
610: l_destination_type_code, l_deliver_location_id,

Line 620: fnd_file.put_line(fnd_file.log,'supplier-final');

616:
617: elsIf l_kanban_card_Rec_Tbl(1).source_type = INV_Kanban_PVT.G_Source_Type_Supplier Then
618: l_source_type_code := 'VENDOR';
619: l_Requisition_type := 'PURCHASE';
620: fnd_file.put_line(fnd_file.log,'supplier-final');
621: Create_Requisition( l_buyer_id, l_interface_source_code,
622: l_requisition_type, l_approval,
623: l_source_type_code, l_kanban_card_rec_tbl,
624: l_destination_type_code, l_deliver_location_id,

Line 634: fnd_file.put_line(fnd_file.log,'intra-final');

630:
631: elsIf l_kanban_card_Rec_Tbl(1).source_type = INV_Kanban_PVT.G_Source_Type_IntraOrg Then
632: l_source_type_code := 'INVENTORY';
633: l_Requisition_type := 'TRANSFER';
634: fnd_file.put_line(fnd_file.log,'intra-final');
635: Create_Transfer_Order(l_kanban_card_Rec_Tbl,l_need_by_date,l_Primary_Uom_Code);
636: else
637: x_return_status := 0;
638: Return;

Line 659: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||fnd_message.get);

655: FND_MESSAGE.SET_NAME('FND','CONC-FDWHOAMI INVALID USERID');
656: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));
657: end if;
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);

Line 660: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||sqlerrm(sqlcode));

656: FND_MESSAGE.SET_TOKEN('USERID',to_char(FND_GLOBAL.USER_ID));
657: end if;
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));

Line 663: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||fnd_message.get);

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
667: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||fnd_message.get);

Line 664: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||sqlerrm(sqlcode));

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
667: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||fnd_message.get);
668: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||sqlerrm(sqlcode));

Line 667: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||fnd_message.get);

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
667: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||fnd_message.get);
668: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||sqlerrm(sqlcode));
669: x_return_status := 1;
670: End Create_Replenishment;
671:

Line 668: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||sqlerrm(sqlcode));

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
667: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||fnd_message.get);
668: fnd_file.put_line(fnd_file.log,'Error in Create_Replenishment'||'( stmt_num: '||l_sql_stmt_no||') '||sqlerrm(sqlcode));
669: x_return_status := 1;
670: End Create_Replenishment;
671:
672:

Line 703: fnd_file.put_line(fnd_file.log,'Parameters to consolidation program: Ord Id : '||p_organization_id);

699: l_ou_id Number;
700: begin
701: retcode := 0; -- success
702:
703: fnd_file.put_line(fnd_file.log,'Parameters to consolidation program: Ord Id : '||p_organization_id);
704: fnd_file.put_line(fnd_file.log,'Parameters to consolidation program: Group Code : '||p_group_code);
705:
706: if p_organization_id is null then
707: fnd_file.put_line(fnd_file.log,'Organization parameter should be passed to consolidation program');

Line 704: fnd_file.put_line(fnd_file.log,'Parameters to consolidation program: Group Code : '||p_group_code);

700: begin
701: retcode := 0; -- success
702:
703: fnd_file.put_line(fnd_file.log,'Parameters to consolidation program: Ord Id : '||p_organization_id);
704: fnd_file.put_line(fnd_file.log,'Parameters to consolidation program: Group Code : '||p_group_code);
705:
706: if p_organization_id is null then
707: fnd_file.put_line(fnd_file.log,'Organization parameter should be passed to consolidation program');
708: raise no_data_found;

Line 707: fnd_file.put_line(fnd_file.log,'Organization parameter should be passed to consolidation program');

703: fnd_file.put_line(fnd_file.log,'Parameters to consolidation program: Ord Id : '||p_organization_id);
704: fnd_file.put_line(fnd_file.log,'Parameters to consolidation program: Group Code : '||p_group_code);
705:
706: if p_organization_id is null then
707: fnd_file.put_line(fnd_file.log,'Organization parameter should be passed to consolidation program');
708: raise no_data_found;
709: end if;
710:
711: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) <> 1 then

Line 713: fnd_file.put_line(fnd_file.log,fnd_message.get);

709: end if;
710:
711: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) <> 1 then
712: fnd_message.set_name('FLM', 'FLM_EKB_PROFILE_DISABLED');
713: fnd_file.put_line(fnd_file.log,fnd_message.get);
714: raise no_data_found;
715: end if;
716:
717: select mkc.kanban_card_id,mkc.kanban_card_number,mkc.pull_sequence_id,mkc.inventory_item_id,mkc.organization_id,mkc.subinventory_name,mkc.supply_status

Line 825: fnd_file.put_line(fnd_file.log,'Error While launching REQIMPORT');

821: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
822: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
823: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
824: IF v_req_id = 0 THEN
825: fnd_file.put_line(fnd_file.log,'Error While launching REQIMPORT');
826: l_status := 1;
827: END IF;
828: end if;
829: fnd_file.put_line(fnd_file.log,' Completed Kanban Consolidation ');

Line 829: fnd_file.put_line(fnd_file.log,' Completed Kanban Consolidation ');

825: fnd_file.put_line(fnd_file.log,'Error While launching REQIMPORT');
826: l_status := 1;
827: END IF;
828: end if;
829: fnd_file.put_line(fnd_file.log,' Completed Kanban Consolidation ');
830: COMMIT;
831:
832: IF l_status = 1 THEN
833: retcode := 2;