DBA Data[Home] [Help]

APPS.GMI_OM_UTILITIES_PKG dependencies on FND_API

Line 121: l_return_status := FND_API.G_RET_STS_SUCCESS;

117: ===========================================*/
118: SAVEPOINT Delete_Alloc_BackOrder_MO_Line;
119:
120: l_mode := p_mode;
121: l_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123: OPEN wdd_cur;
124: LOOP
125: FETCH wdd_cur INTO wdd_row;

Line 139: , FND_API.G_FALSE

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
141: , FND_API.G_VALID_LEVEL_FULL
142: , l_tran_rec
143: , l_tran_row

Line 140: , FND_API.G_FALSE

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
141: , FND_API.G_VALID_LEVEL_FULL
142: , l_tran_rec
143: , l_tran_row
144: , l_return_status

Line 141: , FND_API.G_VALID_LEVEL_FULL

137: GMI_TRANS_ENGINE_PUB.delete_pending_transaction (
138: 1
139: , FND_API.G_FALSE
140: , FND_API.G_FALSE
141: , FND_API.G_VALID_LEVEL_FULL
142: , l_tran_rec
143: , l_tran_row
144: , l_return_status
145: , l_msg_count

Line 150: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;
153: END IF;
154:

Line 152: raise FND_API.G_EXC_ERROR;

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);
156: l_trans_qty2 := nvl(l_trans_qty2,0) + nvl(abs(get_trans_id_row.trans_qty2),0);

Line 179: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

175: p_source_code => 'INV'
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:

Line 181: raise FND_API.G_EXC_ERROR;

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 */
185:

Line 227: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

223: , x_msg_count => l_msg_count
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;

Line 229: raise FND_API.G_EXC_ERROR;

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 */
233:

Line 249: WHEN fnd_api.g_exc_error THEN

245:
246: RETURN TRUE;
247: EXCEPTION
248:
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');

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 265: WHEN fnd_api.g_exc_unexpected_error THEN

261: CLOSE get_trans_id_cur;
262: END IF;
263:
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

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