APPS.GMI_PICK_WAVE_CONFIRM_PUB dependencies on FND_API

Line 41: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

37: -- Added NOCOPY to x_mo_line_tbl
38: PROCEDURE PICK_CONFIRM
39: (
40: p_api_version_number IN NUMBER
41: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
42: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
43: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
44: , p_mo_LINE_tbl IN GMI_Move_Order_GLOBAL.mo_line_tbl
45: , x_mo_LINE_tbl OUT NOCOPY GMI_Move_Order_GLOBAL.mo_line_tbl

Line 42: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

38: PROCEDURE PICK_CONFIRM
39: (
40: p_api_version_number IN NUMBER
41: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
42: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
43: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
44: , p_mo_LINE_tbl IN GMI_Move_Order_GLOBAL.mo_line_tbl
45: , x_mo_LINE_tbl OUT NOCOPY GMI_Move_Order_GLOBAL.mo_line_tbl
46: , x_return_status OUT NOCOPY VARCHAR2

Line 43: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

39: (
40: p_api_version_number IN NUMBER
41: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
42: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
43: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
44: , p_mo_LINE_tbl IN GMI_Move_Order_GLOBAL.mo_line_tbl
45: , x_mo_LINE_tbl OUT NOCOPY GMI_Move_Order_GLOBAL.mo_line_tbl
46: , x_return_status OUT NOCOPY VARCHAR2
47: , x_msg_count OUT NOCOPY NUMBER

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

53: l_api_version_number CONSTANT NUMBER := 1.0;
54:
55: l_msg_count NUMBER :=0;
56: l_msg_data VARCHAR2(2000);
57: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
58: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
59: l_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;
60: -- HW OPM changes for NOCOPY
61: ll_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;

Line 73: IF NOT FND_API.Compatible_API_CALL ( l_api_version_number

69: GMI_Reservation_Util.PrintLn('IN MOVE ORDER line');
70: /* ************ DO I NEED SAVE POINT FOR PUBLIC DECLARATION ******* */
71: /* Standard call to check for call compatibility. */
72:
73: IF NOT FND_API.Compatible_API_CALL ( l_api_version_number
74: , p_api_version_number
75: , l_api_name
76: , G_PKG_NAME
77: )

Line 79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

75: , l_api_name
76: , G_PKG_NAME
77: )
78: THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:
82: GMI_Reservation_Util.PrintLn('After Check Version');
83: /* Initialize message list if p_int_msg_lst is set TRUE. */

Line 84: IF FND_API.to_boolean(p_init_msg_lst)

80: END IF;
81:
82: GMI_Reservation_Util.PrintLn('After Check Version');
83: /* Initialize message list if p_int_msg_lst is set TRUE. */
84: IF FND_API.to_boolean(p_init_msg_lst)
85: THEN
86: FND_MSG_PUB.Initialize;
87: END IF;
88:

Line 93: x_return_status := FND_API.G_RET_STS_SUCCESS;

89: GMI_Reservation_Util.PrintLn('After Init Messages');
90:
91: /* Initialize API return status to sucess */
92:
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: /* Check That we have at least one Move Order Line Rec */
96: GMI_Reservation_Util.PrintLn('mo_line_tbl.COUNT='||p_mo_line_tbl.count);
97:

Line 101: raise FND_API.G_EXC_ERROR;

97:
98: IF ( p_mo_line_tbl.count = 0 ) THEN
99: FND_MESSAGE.SET_NAME('INV', 'INV_NO_LINES_TO_PICK_CONFIRM');
100: FND_MSG_PUB.add;
101: raise FND_API.G_EXC_ERROR;
102: END IF;
103:
104: /* Convert Missing To NULL; */
105: GMI_Reservation_Util.PrintLn('Call Convert Missing To Null');

Line 144: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS AND

140: , p_manual_pick => l_manual_pick
141: );
142:
143: /* Return Output Variables */
144: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS AND
145: l_return_status <> 'X') THEN
146: IF ( l_return_status = 'W' )THEN -- HW BUG#:2296620
147: RAISE l_warning;
148: ElSE

Line 154: RAISE FND_API.G_EXC_ERROR;

150: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_PICK_WAVE_CONFIRM_PVT.PICK_CONFIRM');
151: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
152:
153: FND_MSG_PUB.Add;
154: RAISE FND_API.G_EXC_ERROR;
155: END IF;
156: END IF;
157:
158: -- HW OPM changes for NOCOPY

Line 166: WHEN FND_API.G_EXC_ERROR THEN

162: GMI_Reservation_Util.PrintLn('Count MOL table => ' || x_mo_line_tbl.count);
163:
164:
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168:
169: /* Get message count and data */
170: FND_MSG_PUB.count_and_get

Line 167: x_return_status := FND_API.G_RET_STS_ERROR;

163:
164:
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168:
169: /* Get message count and data */
170: FND_MSG_PUB.count_and_get
171: ( p_count => x_msg_count

Line 179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

175: WHEN l_warning THEN
176: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
177:
178: WHEN OTHERS THEN
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180:
181: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
182: , l_api_name
183: );