DBA Data[Home] [Help]

APPS.GMI_OM_UTILITIES_PKG dependencies on GMI_RESERVATION_UTIL

Line 114: gmi_reservation_util.println('In Function Delete_Alloc_BackOrder_MO_Line');

110: l_trans_qty2 NUMBER := 0;
111:
112:
113: BEGIN
114: gmi_reservation_util.println('In Function Delete_Alloc_BackOrder_MO_Line');
115:
116: /* Standard begin of API savepoint
117: ===========================================*/
118: SAVEPOINT Delete_Alloc_BackOrder_MO_Line;

Line 136: gmi_reservation_util.println('In Function Delete_Alloc_BackOrder_MO_Line Before delete_pending_transaction');

132: FETCH get_trans_id_cur INTO get_trans_id_row;
133: EXIT WHEN get_trans_id_cur%NOTFOUND;
134:
135: l_tran_rec.trans_id := get_trans_id_row.trans_id;
136: gmi_reservation_util.println('In Function Delete_Alloc_BackOrder_MO_Line Before delete_pending_transaction');
137: GMI_TRANS_ENGINE_PUB.delete_pending_transaction (
138: 1
139: , FND_API.G_FALSE
140: , FND_API.G_FALSE

Line 148: gmi_reservation_util.println('Return Status from delete_pending_transaction'|| l_return_status);

144: , l_return_status
145: , l_msg_count
146: , l_msg_data);
147:
148: gmi_reservation_util.println('Return Status from delete_pending_transaction'|| l_return_status);
149:
150: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
151: gmi_reservation_util.println('Error Status from delete_pending_transaction');
152: raise FND_API.G_EXC_ERROR;

Line 151: gmi_reservation_util.println('Error Status from delete_pending_transaction');

147:
148: gmi_reservation_util.println('Return Status from delete_pending_transaction'|| l_return_status);
149:
150: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
151: gmi_reservation_util.println('Error Status from delete_pending_transaction');
152: raise FND_API.G_EXC_ERROR;
153: END IF;
154:
155: l_trans_qty := nvl(l_trans_qty,0) + nvl(abs(get_trans_id_row.trans_qty),0);

Line 180: gmi_reservation_util.println('Error Status from WSH_INTERFACE.Update_Shipping_Attributes');

176: ,p_changed_attributes => l_shipping_attr
177: ,x_return_status => l_api_return_status
178: );
179: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
180: gmi_reservation_util.println('Error Status from WSH_INTERFACE.Update_Shipping_Attributes');
181: raise FND_API.G_EXC_ERROR;
182: END IF;
183:
184: END IF; /* IF ( l_mode = 'BO') THEN */

Line 208: gmi_reservation_util.println('Get_Default_Trans%NOTFOUND in Delete_Alloc_BackOrder_MO_Line');

204: OPEN Get_Default_Trans(l_txn_source_line_id) ;
205: FETCH Get_Default_Trans INTO l_default_trans_id;
206: IF( Get_Default_Trans%NOTFOUND) THEN
207: CLOSE Get_Default_Trans;
208: gmi_reservation_util.println('Get_Default_Trans%NOTFOUND in Delete_Alloc_BackOrder_MO_Line');
209: RETURN FALSE;
210: END IF ;
211:
212: CLOSE Get_Default_Trans;

Line 218: gmi_reservation_util.println('In Delete_Alloc_BackOrder_MO_Line before call to GMI_Reservation_Util.balance_default_lot');

214: IF NVL(l_default_trans_id,0) <> 0 THEN
215: l_in_tran_rec.trans_id := l_default_trans_id ;
216:
217: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_in_tran_rec, l_out_tran_rec) THEN
218: gmi_reservation_util.println('In Delete_Alloc_BackOrder_MO_Line before call to GMI_Reservation_Util.balance_default_lot');
219: GMI_Reservation_Util.balance_default_lot(
220: p_ic_default_rec => l_out_tran_rec
221: , p_opm_item_id => l_out_tran_rec.item_id
222: , x_return_status => l_return_status

Line 219: GMI_Reservation_Util.balance_default_lot(

215: l_in_tran_rec.trans_id := l_default_trans_id ;
216:
217: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_in_tran_rec, l_out_tran_rec) THEN
218: gmi_reservation_util.println('In Delete_Alloc_BackOrder_MO_Line before call to GMI_Reservation_Util.balance_default_lot');
219: GMI_Reservation_Util.balance_default_lot(
220: p_ic_default_rec => l_out_tran_rec
221: , p_opm_item_id => l_out_tran_rec.item_id
222: , x_return_status => l_return_status
223: , x_msg_count => l_msg_count

Line 228: gmi_reservation_util.println('Error Status from GMI_Reservation_Util.balance_default_lot');

224: , x_msg_data => l_msg_data
225: );
226:
227: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
228: gmi_reservation_util.println('Error Status from GMI_Reservation_Util.balance_default_lot');
229: raise FND_API.G_EXC_ERROR;
230: END IF;
231: END IF;
232: END IF; /* IF NVL(l_default_trans_id,0) <> 0 THEN */

Line 244: gmi_reservation_util.println('Successfully Returning from Delete_Alloc_BackOrder_MO_Line');

240: IF get_trans_id_cur%ISOPEN THEN
241: CLOSE get_trans_id_cur;
242: END IF;
243:
244: gmi_reservation_util.println('Successfully Returning from Delete_Alloc_BackOrder_MO_Line');
245:
246: RETURN TRUE;
247: EXCEPTION
248:

Line 253: GMI_Reservation_Util.PrintLn('Exception fnd_api.g_exc_error Delete_Alloc_BackOrder_MO_Line');

249: WHEN fnd_api.g_exc_error THEN
250:
251: ROLLBACK TO SAVEPOINT Delete_Alloc_BackOrder_MO_Line;
252:
253: GMI_Reservation_Util.PrintLn('Exception fnd_api.g_exc_error Delete_Alloc_BackOrder_MO_Line');
254: IF wdd_cur%ISOPEN THEN
255: CLOSE wdd_cur;
256: END IF;
257: IF get_default_trans%ISOPEN THEN

Line 268: GMI_Reservation_Util.PrintLn('Exception fnd_api.g_exc_error Delete_Alloc_BackOrder_MO_Line');

264: RETURN FALSE;
265: WHEN fnd_api.g_exc_unexpected_error THEN
266: ROLLBACK TO SAVEPOINT Delete_Alloc_BackOrder_MO_Line;
267:
268: GMI_Reservation_Util.PrintLn('Exception fnd_api.g_exc_error Delete_Alloc_BackOrder_MO_Line');
269: IF wdd_cur%ISOPEN THEN
270: CLOSE wdd_cur;
271: END IF;
272: IF get_default_trans%ISOPEN THEN

Line 283: GMI_Reservation_Util.PrintLn('Others Exception Delete_Alloc_BackOrder_MO_Line');

279: WHEN Others THEN
280:
281: ROLLBACK TO SAVEPOINT Delete_Alloc_BackOrder_MO_Line;
282:
283: GMI_Reservation_Util.PrintLn('Others Exception Delete_Alloc_BackOrder_MO_Line');
284: IF wdd_cur%ISOPEN THEN
285: CLOSE wdd_cur;
286: END IF;
287: IF get_default_trans%ISOPEN THEN