84:
85:
86: BEGIN
87: IF (l_debug = 'Y') THEN
88: gmd_debug.put_line('Entered Procedure ITEM_IS_LOCATOR_CONTROLLED');
89: gmd_debug.put_line('p_organization_id : ' || p_organization_id);
90: gmd_debug.put_line('p_subinventory : ' || p_subinventory);
91: gmd_debug.put_line('p_inventory_item_id : ' || p_inventory_item_id);
92: END IF;
85:
86: BEGIN
87: IF (l_debug = 'Y') THEN
88: gmd_debug.put_line('Entered Procedure ITEM_IS_LOCATOR_CONTROLLED');
89: gmd_debug.put_line('p_organization_id : ' || p_organization_id);
90: gmd_debug.put_line('p_subinventory : ' || p_subinventory);
91: gmd_debug.put_line('p_inventory_item_id : ' || p_inventory_item_id);
92: END IF;
93:
86: BEGIN
87: IF (l_debug = 'Y') THEN
88: gmd_debug.put_line('Entered Procedure ITEM_IS_LOCATOR_CONTROLLED');
89: gmd_debug.put_line('p_organization_id : ' || p_organization_id);
90: gmd_debug.put_line('p_subinventory : ' || p_subinventory);
91: gmd_debug.put_line('p_inventory_item_id : ' || p_inventory_item_id);
92: END IF;
93:
94:
87: IF (l_debug = 'Y') THEN
88: gmd_debug.put_line('Entered Procedure ITEM_IS_LOCATOR_CONTROLLED');
89: gmd_debug.put_line('p_organization_id : ' || p_organization_id);
90: gmd_debug.put_line('p_subinventory : ' || p_subinventory);
91: gmd_debug.put_line('p_inventory_item_id : ' || p_inventory_item_id);
92: END IF;
93:
94:
95: IF p_subinventory IS NULL
107: OPEN cur_subinventory( p_subinventory );
108: FETCH cur_subinventory INTO subinventory_ctrl;
109: CLOSE cur_subinventory;
110:
111: gmd_debug.put_line('subinventory ctrl = '||subinventory_ctrl);
112:
113: OPEN cur_item(p_inventory_item_id );
114: FETCH cur_item INTO item_ctrl;
115: CLOSE cur_item;
112:
113: OPEN cur_item(p_inventory_item_id );
114: FETCH cur_item INTO item_ctrl;
115: CLOSE cur_item;
116: gmd_debug.put_line('item ctrl = '||item_ctrl);
117:
118: --OPEN cur_organization(p_organization_id);
119: OPEN cur_organization;
120: FETCH cur_organization INTO organization_ctrl;
118: --OPEN cur_organization(p_organization_id);
119: OPEN cur_organization;
120: FETCH cur_organization INTO organization_ctrl;
121: CLOSE cur_organization;
122: gmd_debug.put_line('organization ctrl = '||organization_ctrl||' org id='||p_organization_id);
123:
124: If organization_ctrl in (1,2,3) then
125: x_locator_type := organization_ctrl;
126: ELSIF organization_ctrl = 4
132: ELSE
133: x_locator_type := 0;
134: x_return_status := FND_API.G_RET_STS_ERROR;
135: END IF;
136: gmd_debug.put_line('x_locator_type ='||x_locator_type);
137:
138: EXCEPTION
139: WHEN FND_API.G_EXC_ERROR THEN
140: x_return_status := FND_API.G_RET_STS_ERROR ;
227: WHERE status_id = p_lot_status_id;
228: END IF;
229:
230: IF (l_debug = 'Y') THEN
231: gmd_debug.put_line('Entered Procedure get_lot_attributes');
232: gmd_debug.put_line('p_organization_id : ' || p_organization_id);
233: gmd_debug.put_line('p_lot_number : ' || p_lot_number);
234: gmd_debug.put_line('p_inventory_item_id : ' || p_inventory_item_id);
235: gmd_debug.put_line('p_lot_status_id : ' || p_lot_status_id);
228: END IF;
229:
230: IF (l_debug = 'Y') THEN
231: gmd_debug.put_line('Entered Procedure get_lot_attributes');
232: gmd_debug.put_line('p_organization_id : ' || p_organization_id);
233: gmd_debug.put_line('p_lot_number : ' || p_lot_number);
234: gmd_debug.put_line('p_inventory_item_id : ' || p_inventory_item_id);
235: gmd_debug.put_line('p_lot_status_id : ' || p_lot_status_id);
236: END IF;
229:
230: IF (l_debug = 'Y') THEN
231: gmd_debug.put_line('Entered Procedure get_lot_attributes');
232: gmd_debug.put_line('p_organization_id : ' || p_organization_id);
233: gmd_debug.put_line('p_lot_number : ' || p_lot_number);
234: gmd_debug.put_line('p_inventory_item_id : ' || p_inventory_item_id);
235: gmd_debug.put_line('p_lot_status_id : ' || p_lot_status_id);
236: END IF;
237:
230: IF (l_debug = 'Y') THEN
231: gmd_debug.put_line('Entered Procedure get_lot_attributes');
232: gmd_debug.put_line('p_organization_id : ' || p_organization_id);
233: gmd_debug.put_line('p_lot_number : ' || p_lot_number);
234: gmd_debug.put_line('p_inventory_item_id : ' || p_inventory_item_id);
235: gmd_debug.put_line('p_lot_status_id : ' || p_lot_status_id);
236: END IF;
237:
238: EXCEPTION
231: gmd_debug.put_line('Entered Procedure get_lot_attributes');
232: gmd_debug.put_line('p_organization_id : ' || p_organization_id);
233: gmd_debug.put_line('p_lot_number : ' || p_lot_number);
234: gmd_debug.put_line('p_inventory_item_id : ' || p_inventory_item_id);
235: gmd_debug.put_line('p_lot_status_id : ' || p_lot_status_id);
236: END IF;
237:
238: EXCEPTION
239: