DBA Data[Home] [Help]

APPS.GMI_MOVE_ORDER_LINES_PVT dependencies on FND_API

Line 35: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

31:
32: PROCEDURE Process_Move_Order_LINES
33: (
34: p_api_version_number IN NUMBER
35: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
36: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
37: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
38: , p_mo_line_tbl IN GMI_Move_Order_Global.MO_LINE_TBL
39: , x_mo_line_tbl OUT NOCOPY GMI_Move_Order_Global.MO_LINE_TBL

Line 36: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

32: PROCEDURE Process_Move_Order_LINES
33: (
34: p_api_version_number IN NUMBER
35: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
36: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
37: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
38: , p_mo_line_tbl IN GMI_Move_Order_Global.MO_LINE_TBL
39: , x_mo_line_tbl OUT NOCOPY GMI_Move_Order_Global.MO_LINE_TBL
40: , x_return_status OUT NOCOPY VARCHAR2

Line 37: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

33: (
34: p_api_version_number IN NUMBER
35: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
36: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
37: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
38: , p_mo_line_tbl IN GMI_Move_Order_Global.MO_LINE_TBL
39: , x_mo_line_tbl OUT NOCOPY GMI_Move_Order_Global.MO_LINE_TBL
40: , x_return_status OUT NOCOPY VARCHAR2
41: , x_msg_count OUT NOCOPY NUMBER

Line 49: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;

45: l_api_name CONSTANT VARCHAR2 (30) := 'PROCESS_MOVE_ORDER_LINES';
46: l_api_version_number CONSTANT NUMBER := 1.0;
47: l_msg_count NUMBER :=0;
48: l_msg_data VARCHAR2(2000);
49: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
50: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
51: l_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;
52: l_opm_item_id NUMBER;
53: l_opm_noninv_ind NUMBER;

Line 128: IF NOT FND_API.Compatible_API_CALL ( l_api_version_number

124: /* DBMS_OUTPUT.PUT_LINE('IN MOVE ORDER LINES'); */
125:
126: /* Standard call to check for call compatibility. */
127:
128: IF NOT FND_API.Compatible_API_CALL ( l_api_version_number
129: , p_api_version_number
130: , l_api_name
131: , G_PKG_NAME
132: )

Line 134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

130: , l_api_name
131: , G_PKG_NAME
132: )
133: THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136:
137: /* Initialize message list if p_int_msg_lst is set TRUE. */
138: IF FND_API.to_boolean(p_init_msg_lst)

Line 138: IF FND_API.to_boolean(p_init_msg_lst)

134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: END IF;
136:
137: /* Initialize message list if p_int_msg_lst is set TRUE. */
138: IF FND_API.to_boolean(p_init_msg_lst)
139: THEN
140: FND_MSG_PUB.Initialize;
141: END IF;
142: /* Initialize API return status to sucess */

Line 144: x_return_status := FND_API.G_RET_STS_SUCCESS;

140: FND_MSG_PUB.Initialize;
141: END IF;
142: /* Initialize API return status to sucess */
143:
144: x_return_status := FND_API.G_RET_STS_SUCCESS;
145:
146: WSH_Util_Core.PrintLn('Move_Order_LINES PVT COUNT=> '||p_mo_line_tbl.COUNT);
147: gmi_reservation_util.PrintLn('Move_Order_LINES PVT COUNT=> '||p_mo_line_tbl.COUNT);
148:

Line 156: RAISE FND_API.G_EXC_ERROR;

152: WSH_Util_Core.PrintLn('move order line for source line_id > '|| l_mo_line_rec.txn_source_line_id );
153: WSH_Util_Core.PrintLn('Check Missing For Row > '|| I );
154: IF check_required( p_mo_line_rec => l_mo_line_rec) THEN
155: FND_MESSAGE.SET_NAME('GMI','Required Values Missing In Lines');
156: RAISE FND_API.G_EXC_ERROR;
157: END IF;
158: /* Need To Set l_trolin_rec.primary_quantity */
159: /* Initially Lets Set it to Requested Quantity ( quantity) */
160: /* Since they should be the same. */

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

255: , x_msg_count => x_msg_count
256: , x_msg_data => x_msg_data
257: );
258:
259: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
260: GMI_reservation_Util.PrintLn('Error returned by Create_dflt_lot_from_scratch in Process_Move_Order_LINES');
261: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
262: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.create_dflt_lot_from_scratch');
263: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);

Line 264: RAISE FND_API.G_EXC_ERROR;

260: GMI_reservation_Util.PrintLn('Error returned by Create_dflt_lot_from_scratch in Process_Move_Order_LINES');
261: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
262: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.create_dflt_lot_from_scratch');
263: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266:
267: GMI_RESERVATION_UTIL.find_default_lot
268: ( x_return_status => x_return_status,

Line 276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

272: p_line_id => l_mo_line_rec.txn_source_line_id
273: );
274: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
275: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278:
279: l_default_tran_rec.trans_id := l_trans_id;
280:

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

286: , x_return_status => x_return_status
287: , x_msg_count => x_msg_count
288: , x_msg_data => x_msg_data
289: );
290: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
291: GMI_reservation_Util.PrintLn('Error returned by balance_default_lot in Process_Move_Order_LINES');
292: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
293: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
294: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');

Line 296: RAISE FND_API.G_EXC_ERROR;

292: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
293: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
294: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
295: FND_MSG_PUB.Add;
296: RAISE FND_API.G_EXC_ERROR;
297: END IF;
298: END IF;
299: END IF;
300: /* End Bug 2973135 Uday Phadtare */

Line 317: /* RAISE FND_API.G_EXC_ERROR; */

313: WSH_Util_Core.PrintLn('Count MOL Table => '|| x_mo_line_tbl.COUNT);
314:
315: /* FND_MESSAGE.Set_Name('GMI','Entering_GMI_Create_Move_Order_LINES'); */
316: /* FND_MSG_PUB.Add; */
317: /* RAISE FND_API.G_EXC_ERROR; */
318:
319: EXCEPTION
320: WHEN fnd_api.g_exc_error THEN
321: x_return_status := fnd_api.g_ret_sts_error;

Line 320: WHEN fnd_api.g_exc_error THEN

316: /* FND_MSG_PUB.Add; */
317: /* RAISE FND_API.G_EXC_ERROR; */
318:
319: EXCEPTION
320: WHEN fnd_api.g_exc_error THEN
321: x_return_status := fnd_api.g_ret_sts_error;
322:
323: /* Get message count and data */
324: FND_MSG_PUB.count_and_get

Line 321: x_return_status := fnd_api.g_ret_sts_error;

317: /* RAISE FND_API.G_EXC_ERROR; */
318:
319: EXCEPTION
320: WHEN fnd_api.g_exc_error THEN
321: x_return_status := fnd_api.g_ret_sts_error;
322:
323: /* Get message count and data */
324: FND_MSG_PUB.count_and_get
325: ( p_count => x_msg_count

Line 330: x_return_status := fnd_api.g_ret_sts_error;

326: , p_data => x_msg_data
327: );
328:
329: WHEN OTHERS THEN
330: x_return_status := fnd_api.g_ret_sts_error;
331:
332: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
333: , l_api_name
334: );