DBA Data[Home] [Help]

APPS.GMI_MOVE_ORDER_LINES_PUB dependencies on FND_API

Line 47: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

43:
44: PROCEDURE Process_Move_Order_lines
45: (
46: p_api_version_number IN NUMBER
47: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
48: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
49: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
50: , p_mo_LINE_tbl IN GMI_Move_Order_GLOBAL.mo_line_tbl
51: , x_mo_LINE_tbl OUT NOCOPY GMI_Move_Order_GLOBAL.mo_line_tbl

Line 48: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

44: PROCEDURE Process_Move_Order_lines
45: (
46: p_api_version_number IN NUMBER
47: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
48: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
49: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
50: , p_mo_LINE_tbl IN GMI_Move_Order_GLOBAL.mo_line_tbl
51: , x_mo_LINE_tbl OUT NOCOPY GMI_Move_Order_GLOBAL.mo_line_tbl
52: , x_return_status OUT NOCOPY VARCHAR2

Line 49: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

45: (
46: p_api_version_number IN NUMBER
47: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
48: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
49: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
50: , p_mo_LINE_tbl IN GMI_Move_Order_GLOBAL.mo_line_tbl
51: , x_mo_LINE_tbl OUT NOCOPY GMI_Move_Order_GLOBAL.mo_line_tbl
52: , x_return_status OUT NOCOPY VARCHAR2
53: , x_msg_count OUT NOCOPY NUMBER

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

57: l_api_name CONSTANT VARCHAR2 (30) := 'PROCESS_MOVE_ORDER_LINES';
58: l_api_version_number CONSTANT NUMBER := 1.0;
59: l_msg_count NUMBER :=0;
60: l_msg_data VARCHAR2(2000);
61: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
62: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
63: l_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;
64:
65: CURSOR get_sales_order (V_line_id NUMBER) IS

Line 81: IF NOT FND_API.Compatible_API_CALL ( l_api_version_number

77: ************ DO I NEED SAVE POINT FOR PUBLIC DECLARATION *******
78: Standard call to check for call compatibility.
79: */
80:
81: IF NOT FND_API.Compatible_API_CALL ( l_api_version_number
82: , p_api_version_number
83: , l_api_name
84: , G_PKG_NAME
85: )

Line 87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

83: , l_api_name
84: , G_PKG_NAME
85: )
86: THEN
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: END IF;
89:
90: /* Initialize message list if p_int_msg_lst is set TRUE. */
91: IF FND_API.to_boolean(p_init_msg_lst)

Line 91: IF FND_API.to_boolean(p_init_msg_lst)

87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: END IF;
89:
90: /* Initialize message list if p_int_msg_lst is set TRUE. */
91: IF FND_API.to_boolean(p_init_msg_lst)
92: THEN
93: FND_MSG_PUB.Initialize;
94: END IF;
95:

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

93: FND_MSG_PUB.Initialize;
94: END IF;
95:
96: /* Initialize API return status to sucess */
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99:
100:
101: WSH_Util_Core.PrintLn('Call Convert Missing To Null');

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

165: /* GMI_Move_Order_Header_Util.Insert_Row( l_mo_hdr_rec); */
166:
167: /* FND_MESSAGE.Set_Name('GMI','Entering_GMI_Create_Move_Order_Header'); */
168: /* FND_MSG_PUB.Add; */
169: /* RAISE FND_API.G_EXC_ERROR; */
170:
171: EXCEPTION
172: WHEN fnd_api.g_exc_error THEN
173: x_return_status := fnd_api.g_ret_sts_error;

Line 172: WHEN fnd_api.g_exc_error THEN

168: /* FND_MSG_PUB.Add; */
169: /* RAISE FND_API.G_EXC_ERROR; */
170:
171: EXCEPTION
172: WHEN fnd_api.g_exc_error THEN
173: x_return_status := fnd_api.g_ret_sts_error;
174:
175: /* Get message count and data */
176: FND_MSG_PUB.count_and_get

Line 173: x_return_status := fnd_api.g_ret_sts_error;

169: /* RAISE FND_API.G_EXC_ERROR; */
170:
171: EXCEPTION
172: WHEN fnd_api.g_exc_error THEN
173: x_return_status := fnd_api.g_ret_sts_error;
174:
175: /* Get message count and data */
176: FND_MSG_PUB.count_and_get
177: ( p_count => x_msg_count

Line 182: x_return_status := fnd_api.g_ret_sts_error;

178: , p_data => x_msg_data
179: );
180:
181: WHEN OTHERS THEN
182: x_return_status := fnd_api.g_ret_sts_error;
183:
184: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
185: , l_api_name
186: );