DBA Data[Home] [Help]

APPS.GMD_COMMON_GRP dependencies on GMD_DEBUG

Line 88: gmd_debug.put_line('Entered Procedure ITEM_IS_LOCATOR_CONTROLLED');

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;

Line 89: gmd_debug.put_line('p_organization_id : ' || p_organization_id);

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:

Line 90: gmd_debug.put_line('p_subinventory : ' || p_subinventory);

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:

Line 91: gmd_debug.put_line('p_inventory_item_id : ' || p_inventory_item_id);

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

Line 111: gmd_debug.put_line('subinventory ctrl = '||subinventory_ctrl);

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;

Line 116: gmd_debug.put_line('item ctrl = '||item_ctrl);

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;

Line 122: gmd_debug.put_line('organization ctrl = '||organization_ctrl||' org id='||p_organization_id);

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

Line 136: gmd_debug.put_line('x_locator_type ='||x_locator_type);

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 ;

Line 231: gmd_debug.put_line('Entered Procedure get_lot_attributes');

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

Line 232: gmd_debug.put_line('p_organization_id : ' || p_organization_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;

Line 233: gmd_debug.put_line('p_lot_number : ' || p_lot_number);

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:

Line 234: gmd_debug.put_line('p_inventory_item_id : ' || p_inventory_item_id);

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

Line 235: gmd_debug.put_line('p_lot_status_id : ' || p_lot_status_id);

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: