APPS.GML_INTORD_LOT_STS dependencies on FND_API

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84: l_msg_data VARCHAR2(1000);
85:
86: BEGIN
87:
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:
90: IF p_ship_lot_status IS NULL THEN
91: x_msg_data := 'null p_ship_lot_status passed to proc derive_porc_lot_status';
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:
90: IF p_ship_lot_status IS NULL THEN
91: x_msg_data := 'null p_ship_lot_status passed to proc derive_porc_lot_status';
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
93: x_txn_allowed := 'N';
94: x_rcpt_lot_status := NULL;
95: RETURN;
96: END IF;

Line 159: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

155: , p_location => p_location
156: , p_to_status => p_ship_lot_status
157: , x_return_status => l_return_status
158: , x_msg_data => l_msg_data );
159: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
160: x_msg_data := l_msg_data;
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
162: x_txn_allowed := 'N';
163: x_rcpt_lot_status := NULL;

Line 161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

157: , x_return_status => l_return_status
158: , x_msg_data => l_msg_data );
159: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
160: x_msg_data := l_msg_data;
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
162: x_txn_allowed := 'N';
163: x_rcpt_lot_status := NULL;
164: END IF;
165: RETURN;

Line 173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

169:
170: EXCEPTION
171: WHEN OTHERS THEN
172: x_msg_data := 'derive_porc_lot_status failed unexpected error';
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
174: x_txn_allowed := 'N';
175: x_rcpt_lot_status := NULL;
176:
177: END derive_porc_lot_status;

Line 263: x_return_status := FND_API.G_RET_STS_SUCCESS;

259:
260:
261: BEGIN
262:
263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264:
265: SELECT *
266: INTO l_item_rec
267: FROM ic_item_mst

Line 272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

268: WHERE item_id = p_item_id;
269:
270: IF l_item_rec.status_ctl = 0 THEN
271: x_msg_data := 'Item is not status controlled';
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: RETURN;
274: END IF;
275:
276: SELECT s.co_code, w.orgn_code

Line 311: x_return_status := FND_API.G_RET_STS_ERROR;

307: AND lot_id = p_lot_id;
308:
309: EXCEPTION WHEN OTHERS THEN
310: x_msg_data := 'Error updating the status in ic_loct_inv';
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: END;
313: RETURN;
314:
315: IF Get_Reason_Code%ISOPEN THEN

Line 326: x_return_status := FND_API.G_RET_STS_ERROR;

322:
323: -- Set the context for the GMI APIs
324: IF( NOT Gmigutl.Setup(l_trans_rec.user_name) ) THEN
325: x_msg_data := 'Error during Gmigutl.Setup';
326: x_return_status := FND_API.G_RET_STS_ERROR;
327: RETURN;
328: END IF;
329:
330: -- Call the standard API and check the return status

Line 360: x_return_status := FND_API.G_RET_STS_ERROR;

356:
357: l_message_data := l_message_data||l_data;
358: END LOOP;
359: x_msg_data := 'Inv Posting Failed '||l_message_data;
360: x_return_status := FND_API.G_RET_STS_ERROR;
361: RETURN;
362: END IF;
363:
364: EXCEPTION

Line 367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

363:
364: EXCEPTION
365: WHEN OTHERS THEN
366: x_msg_data := 'Inv Posting Failed, Unexpected error';
367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
368: END;
369:
370:
371: EXCEPTION

Line 374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

370:
371: EXCEPTION
372: WHEN OTHERS THEN
373: x_msg_data := 'change_inv_lot_status failed, unexpected error';
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375:
376: END change_inv_lot_status;
377:
378: -------------------------------------------------------------------------------

Line 433: x_return_status := FND_API.G_RET_STS_SUCCESS;

429: l_number NUMBER := 1;
430:
431: BEGIN
432:
433: x_return_status := FND_API.G_RET_STS_SUCCESS;
434:
435: --delete plsql table before populating
436: x_lot_sts_tab.DELETE;
437:

Line 447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

443:
444: EXCEPTION
445: WHEN OTHERS THEN
446: x_msg_data := 'get_omso_lot_status failed unexpected error';
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448:
449: END get_omso_lot_status;
450:
451: