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.INV_KANBAN_PVT dependencies on FND_PROFILE

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

39: X_Doc_Type_Po Out NOCOPY Number,
40: X_Doc_Type_Release Out NOCOPY Number,
41: X_Doc_Type_Internal_Req Out NOCOPY Number)
42: IS
43: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
44: Begin
45:
46: X_Ret_Success := FND_API.G_RET_STS_SUCCESS;
47: X_Ret_Error := FND_API.G_RET_STS_ERROR;

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

81: l_item_name varchar2(200);
82: l_loc_name varchar2(200);
83: l_subinventory varchar2(10);
84:
85: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
86: Begin
87: Select concatenated_segments,organization_code,
88: subinventory_name,locator_id,pull.organization_id
89: into x_item_name,x_org_code,x_subinventory,l_locator_id,

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

129: Where kanban_plan_id = p_kanban_plan_id;
130:
131: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
132:
133: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
134: Begin
135: If p_kanban_plan_id = INV_kanban_PVT.G_Current_Plan
136: then
137: For pull_sequences in get_pull_sequences

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

179: --
180: PROCEDURE Validate_Pull_Sequence
181: (p_Pull_Sequence_Rec INV_Kanban_PVT.Pull_sequence_Rec_Type)
182: IS
183: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
184: Begin
185: if p_Pull_Sequence_Rec.Organization_Id is null
186: then
187: FND_MESSAGE.SET_NAME('INV','INV_ORG_REQUIRED');

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

273: p_Pull_Sequence_Rec INV_Kanban_PVT.Pull_sequence_Rec_Type)
274: IS
275: l_Pull_Sequence_Rec INV_Kanban_PVT.Pull_sequence_Rec_Type;
276: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
277: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
278: Begin
279: FND_MSG_PUB.initialize;
280: l_Pull_Sequence_Rec := INV_PullSequence_PKG.Convert_Miss_To_Null
281: (p_Pull_Sequence_Rec);

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

332: l_item_name VARCHAR2(30);
333: l_loc_name VARCHAR2(30);
334:
335:
336: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
337: Begin
338: FND_MSG_PUB.initialize;
339: l_Pull_Sequence_Rec := x_Pull_Sequence_Rec;
340: l_Pull_Sequence_Rec.pull_sequence_id := Null;

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

480: v_generate_cards BOOLEAN := FALSE;
481: l_Pull_sequence_rec INV_Kanban_PVT.Pull_sequence_Rec_Type;
482:
483:
484: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
485:
486: l_operation_tbl INV_Kanban_PVT.operation_tbl_type; --Operation to be performed update/insert
487: l_report_generate_id NUMBER := 0; --Report id for generating cards
488: l_report_print_id NUMBER := 0; --Report id for printing cards

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

719: l_kanban_card_rec INV_Kanban_PVT.Kanban_Card_Rec_Type;
720: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
721: l_supply_status_from Varchar2(30);
722: l_supply_status_to Varchar2(30);
723: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
724: l_temp NUMBER := NULL;
725: l_update Boolean := TRUE; -- For Bug 3740514
726: l_return_msg varchar2(200);
727: l_return_msg_code number;

Line 731: if ( nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 AND p_Supply_Status = INV_KANBAN_PVT.G_Supply_Status_Full ) then

727: l_return_msg_code number;
728: Begin
729: -- added for eKanban project.
730: mydebug('In INV_KANBAN_PVT.Update_Card_Supply_Status api - 5');
731: if ( nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 AND p_Supply_Status = INV_KANBAN_PVT.G_Supply_Status_Full ) then
732: mydebug('calling flm_kanbancard_pub.change_card_status_full api: replenish_quantity='||p_replenish_quantity||', p_Supply_Status='||p_Supply_Status);
733: FLM_KANBANCARD_PUB.CHANGE_CARD_STATUS_FULL(p_Kanban_Card_Id => p_Kanban_Card_Id,
734: p_replenish_quantity => p_replenish_quantity,
735: X_ERR_MSG => l_return_msg,

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

887: l_reference_type_code Number;
888: l_move_order_line_id Number;
889: l_Supply_Status Number;
890:
891: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
892: Begin
893: mydebug('In INV_KANBAN_PVT.Update_Card_Supply_Status api - 4');
894: l_Supply_Status := p_Supply_Status;
895:

Line 901: if nvl(fnd_profile.value('INV_FILL_PARTIAL_MOVE_KANBAN'),2) = 2 then

897: -- supply status to 'Full' while partially transacting the move order.
898: -- The status changes to 'InProcess if 'INV_FILL_PARTIAL_MOVE_KANBAN'
899: -- profile value is set to 'No' and the IF conditions are satisfied.
900:
901: if nvl(fnd_profile.value('INV_FILL_PARTIAL_MOVE_KANBAN'),2) = 2 then
902: -- Bug 2383538 Checking the mtl_txn_request_lines when partially
903: -- transacting the move order to change the supply status to Inprocess
904: Begin
905: select line_id, nvl(quantity,0), nvl(reference_type_code,0)

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

984:
985: l_msg_data VARCHAR2(255);
986: l_msg_count NUMBER := NULL;
987:
988: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
989: Begin
990: mydebug('In INV_KANBAN_PVT.Update_Card_Supply_Status api - 3');
991: -- Standard Start of API savepoint
992:

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

1081: p_Document_Header_Id Number)
1082: IS
1083: l_Document_detail_id Number := FND_API.G_MISS_NUM;
1084:
1085: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1086: Begin
1087: mydebug('In INV_KANBAN_PVT.Update_Card_Supply_Status api - 2');
1088: Update_Card_Supply_Status(X_Return_Status => x_Return_Status,
1089: p_kanban_card_Id => p_Kanban_Card_Id,

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

1124: Return Boolean
1125: Is
1126: l_dummy varchar2(1);
1127:
1128: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1129: BEGIN
1130:
1131: Select 'x'
1132: INTO l_dummy

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

1174: p_kanban_size number)
1175: Return Number
1176: Is
1177: l_dummy varchar2(1);
1178: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1179: BEGIN
1180: Select 'x'
1181: INTO l_dummy
1182: FROM MTL_KANBAN_CARDS

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

1264: l_item_name varchar2(100);
1265: l_subinventory varchar2(10);
1266: l_loc_name varchar2(100);
1267:
1268: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1269: BEGIN
1270:
1271: if Valid_Kanban_Cards_exist(p_pull_sequence_id)
1272: then

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

1296: l_item_name varchar2(100);
1297: l_subinventory varchar2(10);
1298: l_loc_name varchar2(100);
1299:
1300: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1301: BEGIN
1302: if Valid_Kanban_Cards_exist(p_pull_sequence_id)
1303: then
1304: Get_Pull_sequence_Tokens(p_pull_sequence_id,l_org_code,

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

1329: x_loc_name Out NOCOPY varchar2,
1330: x_kanban_num Out NOCOPY varchar2 )
1331: IS
1332:
1333: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1334: Begin
1335: Select concatenated_segments,organization_code,kanban_card_number
1336: into x_item_name,x_org_code,x_kanban_num
1337: from mtl_system_items_kfv a , mtl_parameters b, mtl_kanban_cards card

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

1379: x_item_name varchar2(200);
1380: x_loc_name varchar2(200);
1381: x_kanban_num varchar2(30);
1382:
1383: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1384: BEGIN
1385: begin
1386: select subinventory_name, nvl(locator_id,0), inventory_item_id,
1387: organization_id, source_type, supply_status

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

1472: --
1473: --
1474: PROCEDURE Delete_Kanban_Cards(p_Pull_sequence_id number)
1475: IS
1476: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1477: BEGIN
1478:
1479: INV_KanbanCard_PKG.Delete_Cards_For_Pull_Seq(p_pull_sequence_id);
1480:

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

1508: /*declared by javakat to fix 11800873 from number to varcharto default supplier and supplier_site_id*/
1509: l_supplier_id NUMBER;
1510: l_supp_site_id NUMBER;
1511: l_temp NUMBER;
1512: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1513: BEGIN
1514:
1515: FND_MSG_PUB.initialize;
1516: l_kanban_Card_tbl.Delete;

Line 1571: if ( nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 0 )then

1567: END IF;
1568:
1569: --Existing kanban cards need to be cancelled only when creating a
1570: --regular replenishable card
1571: if ( nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 0 )then
1572: IF p_pull_sequence_rec.kanban_card_type <>
1573: INV_Kanban_Pvt.g_card_type_nonreplenishable then
1574: -- we should not delete old kanban cards but change their status
1575: -- for historical purposes.

Line 1591: If NVL(FND_PROFILE.VALUE('FLM_EKB_OPS_FLAG'),0)=INVKBCGN.flm_ekb_yes THEN

1587: l_Kanban_Card_Id := NULL;
1588: l_Kanban_Card_Number := NULL;
1589: /*added by javakat to fix 11800873 */
1590:
1591: If NVL(FND_PROFILE.VALUE('FLM_EKB_OPS_FLAG'),0)=INVKBCGN.flm_ekb_yes THEN
1592: IF (l_debug = 1 ) THEN
1593: INV_LOG_UTIL.TRACE('FLM: Enable E-Kanban is yes','INV_KANBAN_PVT.Create_Kanban_Cards');
1594: INV_LOG_UTIL.TRACE('Calling FLM_MULTIPLE_SUPPLIERS.GET_SUPPLIER','INV_KANBAN_PVT.Create_Kanban_Cards');
1595: END IF;

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

1756: l_loc_name varchar2(2000);
1757: l_subinventory varchar2(10);
1758: l_org_code varchar2(3);
1759:
1760: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1761: BEGIN
1762:
1763: FND_MSG_PUB.initialize;
1764: l_kanban_Card_tbl.Delete;

Line 1817: if ( nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 0) then

1813:
1814: --Existing kanban cards need to be cancelled only when creating a
1815: --regular replenishable card
1816: -- Do not cancel cards in eKanban.
1817: if ( nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 0) then
1818: IF p_pull_sequence_rec.kanban_card_type <>
1819: INV_Kanban_Pvt.g_card_type_nonreplenishable then
1820: -- we should not delete old kanban cards but change their status
1821: -- for historical purposes.

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

1938: Return Number
1939: Is
1940: l_next_replenish_cycle_Id Number;
1941:
1942: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1943: Begin
1944:
1945: Select MTL_KANBAN_REPLENISH_CYCLE_S.NextVal
1946: Into l_next_replenish_cycle_Id

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

1976: l_project_id NUMBER :=null;
1977: l_task_id NUMBER := null;
1978: l_project_reference_enabled NUMBER;
1979: l_project_accounting_context VARCHAR2(30);
1980: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1981: l_group_code varchar2(500) := null;
1982: l_consolidation_option Number := 1;
1983: begin
1984:

Line 2017: if ( nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1) then

2013: END IF;
2014: END IF;
2015:
2016: -- eKanban Changes.
2017: if ( nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1) then
2018: if p_kanban_card_rec_tbl(1).pull_sequence_id is not null then
2019: select CONSOLIDATION into l_consolidation_option
2020: from MTL_KANBAN_PULL_SEQUENCES
2021: where pull_sequence_id =p_kanban_card_rec_tbl(1).pull_sequence_id;

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

2201: l_org_locator_control_code NUMBER;
2202: l_auto_allocate_flag NUMBER; --Added for 3905884
2203: l_mo_request_number VARCHAR2(30); --Added for 3905884
2204: l_secondary_uom_code VARCHAR2(3);
2205: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2206: l_proc_name CONSTANT VARCHAR2(30) := 'Create_Transfer_Order';
2207: l_secondary_qty NUMBER;
2208: begin
2209:

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

2435: Function Launch_MLP(p_group_id IN Number) return BOOLEAN IS
2436:
2437: v_req_id NUMBER;
2438:
2439: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2440: BEGIN
2441:
2442: v_req_id := FND_REQUEST.SUBMIT_REQUEST( 'WIP', 'WICMLP',
2443: NULL, NULL, FALSE,

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

2480: l_task_id NUMBER := null;
2481: l_project_reference_enabled NUMBER;
2482: l_first_unit_start_date DATE;
2483: l_last_unit_completion_date DATE;
2484: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2485: l_status_type number;
2486: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2487: l_pre_proc_lead_time NUMBER; --Bug# 11717156
2488: begin

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

2482: l_first_unit_start_date DATE;
2483: l_last_unit_completion_date DATE;
2484: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2485: l_status_type number;
2486: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2487: l_pre_proc_lead_time NUMBER; --Bug# 11717156
2488: begin
2489:
2490:

Line 2498: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then

2494:
2495: For l_order_count in 1..p_Kanban_Card_Rec_Tbl.Count
2496: LOOP
2497: --eKanban Changes
2498: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then
2499: l_status_type := nvl(flm_kanban_config_params.get_dj_status_replenish(p_kanban_card_rec_tbl(1).organization_id),3);
2500: else
2501: l_status_type := 3;
2502: end if;

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

2654: l_task_id NUMBER :=NULL;
2655: l_project_reference_enabled NUMBER;
2656: l_first_unit_start_date DATE;
2657: l_last_unit_completion_date DATE;
2658: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2659: BEGIN
2660:
2661: begin
2662: select MAXIMUM_RATE into line_rate

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

2863: l_msg_count NUMBER;
2864: l_msg_data VARCHAR2(240);
2865: msg VARCHAR2(2000);
2866:
2867: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2868: BEGIN
2869:
2870: For l_order_count in 1..p_kanban_card_rec_tbl.Count
2871: Loop

Line 2994: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2990: l_mode_flag NUMBER := NULL;
2991: l_job_name VARCHAR2(255);
2992: l_first_unit_start_date DATE;
2993: l_last_unit_completion_date DATE;
2994: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2995: -- Following variable is added as a part of bug fix for bug # 3301126
2996: l_scheduling_method NUMBER := 2;
2997: l_status_type Number := 3;
2998:

Line 3001: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then

2997: l_status_type Number := 3;
2998:
2999: BEGIN
3000:
3001: if nvl(fnd_profile.VALUE('FLM_EKB_OPS_FLAG'),0) = 1 then
3002: l_status_type := nvl(flm_kanban_config_params.get_dj_status_replenish(p_kanban_card_rec_tbl(1).organization_id),3);
3003: else
3004: l_status_type := 3;
3005: end if;

Line 3008: IF(to_number(NVL(FND_PROFILE.VALUE('WSM_CREATE_LBJ_COPY_ROUTING'),0)) = 1 ) THEN

3004: l_status_type := 3;
3005: end if;
3006:
3007: -- Following IF_ELSE block is a part of bug fix for bug # 3301126
3008: IF(to_number(NVL(FND_PROFILE.VALUE('WSM_CREATE_LBJ_COPY_ROUTING'),0)) = 1 ) THEN
3009: l_scheduling_method := 1;
3010: ELSE
3011: l_scheduling_method := 2;
3012: END IF;

Line 3034: select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval

3030: ELSE
3031: l_mode_flag := 2;
3032: END IF;
3033:
3034: select FND_Profile.value('WIP_JOB_PREFIX')||wip_job_number_s.nextval
3035: INTO l_job_name
3036: from dual;
3037: --3100874 Outbound Flow Sequencing
3038: --if the need_by_date is passed completion date should be set to the

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

3190: v_cfm_flag number;
3191: v_priority number;
3192: v_wip_line_id number := NULL;
3193: l_is_lot_control VARCHAR2(1) := NULL;
3194: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3195: BEGIN
3196:
3197: begin
3198: select nvl(repetitive_planning_flag,'N'), nvl(fixed_lead_time,0),

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

3428: l_Kanban_Card_Rec_Tbl Kanban_Card_Tbl_Type;
3429: p_card_supply_status Number;
3430: revision_profile Number;
3431:
3432: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3433: l_consolidation_option NUMBER := null;
3434: Begin
3435: mydebug('Inside create_replenishment');
3436:

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

3551:
3552: /* Bug 971203. Do not check for revision control code.Get the value from the
3553: profile and if the profile is Yes, then get revision */
3554:
3555: revision_profile := fnd_profile.value('INV_PURCHASING_BY_REVISION') ;
3556: if revision_profile = 1 then
3557:
3558: l_sql_stmt_no := 50;
3559:

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

3743: -- current card if it is in wait status as it will be considered twice.
3744: And Kanban_card_Id <> p_Kanban_Card_Rec.Kanban_card_Id
3745: For Update Of Supply_Status NoWait;
3746:
3747: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3748: Begin
3749:
3750: l_Kanban_Card_tbl.delete;
3751: l_Wait_Kanban_card_Tbl.Delete;

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

3908: l_pull_seq_id_tbl INV_kanban_PVT.pull_sequence_id_Tbl_Type;
3909: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
3910: l_operation_tbl INV_Kanban_PVT.operation_tbl_type;/*This new local var has been added to
3911: keep in synch with the call to procedure update_pull_sequence_tbl */
3912: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3913: begin
3914:
3915: For pull_seq_rec IN (select pull_sequence_id from MTL_KANBAN_PULL_SEQUENCES
3916: Where Kanban_plan_id = -1 ) LOOP

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

3956: SELECT kanban_card_id
3957: FROM mtl_kanban_cards
3958: WHERE pull_sequence_id = p_pull_sequence_id ;
3959:
3960: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3961: BEGIN
3962:
3963: for kanban_cards_ids in get_kanban_card_ids
3964: LOOP

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

3981: x_att OUT NOCOPY NUMBER,
3982: x_err_code OUT NOCOPY NUMBER,
3983: x_err_msg OUT NOCOPY VARCHAR2)
3984: IS
3985: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3986: BEGIN
3987:
3988: wsmputil.return_att_quantity(p_org_id => p_org_id
3989: ,p_item_id => p_item_id

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

4025: X_ERROR_CODE OUT NOCOPY NUMBER,
4026: X_error_msg OUT NOCOPY VARCHAR2)
4027: IS
4028:
4029: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4030: BEGIN
4031:
4032: wsmputil.get_max_kanban_asmbly_qty
4033: ( P_BILL_SEQ_ID => p_bill_seq_id,

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

4065: l_lot_control NUMBER := NULL;
4066: l_cfm_flag NUMBER := NULL;
4067: l_assembly_item_id NUMBER := p_inventory_item_id;
4068: l_organization_id NUMBER := p_organization_id;
4069: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4070: BEGIN
4071: --fnd_message.debug('Inside eligible');
4072:
4073: IF wsmpvers.get_osfm_release_version <= '110508' THEN

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

4137: x_bom_seq_id OUT NOCOPY NUMBER,
4138: x_start_seq_num OUT NOCOPY NUMBER,
4139: X_error_code OUT NOCOPY NUMBER,
4140: X_error_msg OUT NOCOPY VARCHAR2) IS
4141: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4142: BEGIN
4143: wsmputil.GET_KANBAN_REC_GRP_INFO(p_organization_id => p_organization_id,
4144: p_kanban_assembly_id => p_kanban_assembly_id,
4145: p_rtg_rev_date => p_rtg_rev_date,

Line 4357: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4353: l_failed_lines NUMBER := 0;
4354: l_return_status VARCHAR2(1);
4355: l_msg_count NUMBER ;
4356: l_msg_data VARCHAR2(2000);
4357: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4358:
4359:
4360: /*Cursor to get mo line informations */
4361: CURSOR mo_lines_cur IS