DBA Data[Home] [Help]

APPS.FLM_KANBAN_CONSOLIDATION dependencies on FND_PROFILE

Line 42: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

38: l_project_id NUMBER :=null;
39: l_task_id NUMBER := null;
40: l_project_reference_enabled NUMBER;
41: l_project_accounting_context VARCHAR2(30);
42: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
43: l_consolidation_option Number := 1;
44: l_Current_Replenish_Cycle_Id Number;
45: l_group_code varchar2(500) := null;
46: l_Kanban_Card_Rec_Tbl t_cards_to_consolidate;

Line 217: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

213: l_org_locator_control_code NUMBER;
214: l_auto_allocate_flag NUMBER;
215: l_mo_request_number VARCHAR2(30);
216: l_secondary_uom_code VARCHAR2(3);
217: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
218: l_proc_name CONSTANT VARCHAR2(30) := '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;

Line 472: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

468: l_Revision Varchar2(3);
469: l_Revision_qty_control_code Number;
470: revision_profile Number;
471:
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');

Line 576: revision_profile := fnd_profile.value('INV_PURCHASING_BY_REVISION') ;

572: l_kanban_card_Rec_Tbl(1).Organization_id
573: and org.location_id = loc.location_id;
574: end if;
575:
576: revision_profile := fnd_profile.value('INV_PURCHASING_BY_REVISION') ;
577: if revision_profile = 1 then
578:
579: l_sql_stmt_no := 50;
580:

Line 711: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) <> 1 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
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;