DBA Data[Home] [Help]

APPS.GMI_OM_UTIL dependencies on FND_API

Line 82: x_return_status := FND_API.G_RET_STS_SUCCESS;

78:
79: /* Clear Table */
80: l_Lot_serial_tbl.DELETE;
81:
82: x_return_status := FND_API.G_RET_STS_SUCCESS;
83:
84: GMI_RESERVATION_UTIL.Println('Getting item details for Apps Item ID '
85: ||to_char(p_reference_line_rec.inventory_item_id));
86: OPEN item_dtl;

Line 110: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

106: , x_msg_count => l_msg_count
107: , x_msg_data => l_msg_data);
108: END IF;
109:
110: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
111: GMI_RESERVATION_UTIL.Println('Unable to Get_AppsUOM_from_OPMUOM');
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: EXIT;
114: END IF;

Line 112: x_return_status := FND_API.G_RET_STS_ERROR;

108: END IF;
109:
110: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
111: GMI_RESERVATION_UTIL.Println('Unable to Get_AppsUOM_from_OPMUOM');
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: EXIT;
114: END IF;
115:
116: /* if item primary uom and rma uom are different convert trans qty */

Line 180: /* x_return_status := FND_API.G_RET_STS_ERROR; */

176: END LOOP;
177:
178: IF (l_number = 0) THEN
179: /* commenting following line because referencing unshipped line was giving errors. May be its an OM issue */
180: /* x_return_status := FND_API.G_RET_STS_ERROR; */
181: GMI_RESERVATION_UTIL.Println('Could not fetch lot quantities for order line id '||
182: to_char(p_original_line_rec.reference_line_id));
183: END IF;
184:

Line 191: x_return_status := FND_API.G_RET_STS_ERROR;

187: p_x_lot_serial_tbl := l_lot_serial_tbl;
188:
189: EXCEPTION
190: WHEN OTHERS THEN
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: GMI_RESERVATION_UTIL.Println('Raised When Others in GMI_RMA_LOT_QTY');
193: err_num := SQLCODE;
194: err_msg := SUBSTRB(SQLERRM, 1, 100);
195: GMI_RESERVATION_UTIL.Println(to_char(err_num)||'=>'||err_msg);