DBA Data[Home] [Help]

APPS.GMI_MOVE_ORDER_HEADER_PVT dependencies on FND_API

Line 38: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

34: -- add NOCOPY to x_mo_hdr_rec
35: PROCEDURE Process_Move_Order_Header
36: (
37: p_api_version_number IN NUMBER
38: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
39: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
40: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
41: , p_mo_hdr_rec IN GMI_Move_Order_Global.MO_HDR_REC
42: , x_mo_hdr_rec OUT NOCOPY GMI_Move_Order_Global.MO_HDR_REC

Line 39: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

35: PROCEDURE Process_Move_Order_Header
36: (
37: p_api_version_number IN NUMBER
38: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
39: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
40: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
41: , p_mo_hdr_rec IN GMI_Move_Order_Global.MO_HDR_REC
42: , x_mo_hdr_rec OUT NOCOPY GMI_Move_Order_Global.MO_HDR_REC
43: , x_return_status OUT NOCOPY VARCHAR2

Line 40: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

36: (
37: p_api_version_number IN NUMBER
38: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
39: , p_validation_flag IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
40: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
41: , p_mo_hdr_rec IN GMI_Move_Order_Global.MO_HDR_REC
42: , x_mo_hdr_rec OUT NOCOPY GMI_Move_Order_Global.MO_HDR_REC
43: , x_return_status OUT NOCOPY VARCHAR2
44: , x_msg_count OUT NOCOPY NUMBER

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

48: l_api_name CONSTANT VARCHAR2 (30) := 'PROCESS_MOVE_ORDER_HEADER';
49: l_api_version_number CONSTANT NUMBER := 1.0;
50: l_msg_count NUMBER :=0;
51: l_msg_data VARCHAR2(2000);
52: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
53: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.mo_hdr_rec:= p_mo_hdr_rec;
54:
55:
56: BEGIN

Line 68: IF NOT FND_API.Compatible_API_CALL ( l_api_version_number

64: /* DBMS_OUTPUT.PUT_LINE('IN MOVE ORDER HDR'); */
65:
66: /* Standard call to check for call compatibility. */
67:
68: IF NOT FND_API.Compatible_API_CALL ( l_api_version_number
69: , p_api_version_number
70: , l_api_name
71: , G_PKG_NAME
72: )

Line 74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

70: , l_api_name
71: , G_PKG_NAME
72: )
73: THEN
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END IF;
76:
77: /* Initialize message list if p_int_msg_lst is set TRUE. */
78: IF FND_API.to_boolean(p_init_msg_lst)

Line 78: IF FND_API.to_boolean(p_init_msg_lst)

74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END IF;
76:
77: /* Initialize message list if p_int_msg_lst is set TRUE. */
78: IF FND_API.to_boolean(p_init_msg_lst)
79: THEN
80: FND_MSG_PUB.Initialize;
81: END IF;
82: /* Initialize API return status to sucess */

Line 84: x_return_status := FND_API.G_RET_STS_SUCCESS;

80: FND_MSG_PUB.Initialize;
81: END IF;
82: /* Initialize API return status to sucess */
83:
84: x_return_status := FND_API.G_RET_STS_SUCCESS;
85:
86: WSH_Util_Core.PrintLn('Move_Order_Header PVT => '||p_mo_hdr_rec.operation);
87:
88:

Line 91: RAISE FND_API.G_EXC_ERROR;

87:
88:
89: IF check_required( p_mo_hdr_rec => l_mo_hdr_rec) THEN
90: FND_MESSAGE.SET_NAME('GMI','Required Values Missing');
91: RAISE FND_API.G_EXC_ERROR;
92: END IF;
93:
94:
95: WSH_Util_Core.PrintLn('Move_Order_Header PVT => '||p_mo_hdr_rec.operation);

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

149: WSH_Util_Core.PrintLn('Seq Header id => '||x_mo_hdr_rec.header_id);
150:
151: /* FND_MESSAGE.Set_Name('GMI','Entering_GMI_Create_Move_Order_Header'); */
152: /* FND_MSG_PUB.Add; */
153: /* RAISE FND_API.G_EXC_ERROR; */
154:
155: EXCEPTION
156: WHEN fnd_api.g_exc_error THEN
157: x_return_status := fnd_api.g_ret_sts_error;

Line 156: WHEN fnd_api.g_exc_error THEN

152: /* FND_MSG_PUB.Add; */
153: /* RAISE FND_API.G_EXC_ERROR; */
154:
155: EXCEPTION
156: WHEN fnd_api.g_exc_error THEN
157: x_return_status := fnd_api.g_ret_sts_error;
158:
159: /* Get message count and data */
160: FND_MSG_PUB.count_and_get

Line 157: x_return_status := fnd_api.g_ret_sts_error;

153: /* RAISE FND_API.G_EXC_ERROR; */
154:
155: EXCEPTION
156: WHEN fnd_api.g_exc_error THEN
157: x_return_status := fnd_api.g_ret_sts_error;
158:
159: /* Get message count and data */
160: FND_MSG_PUB.count_and_get
161: ( p_count => x_msg_count

Line 166: x_return_status := fnd_api.g_ret_sts_error;

162: , p_data => x_msg_data
163: );
164:
165: WHEN OTHERS THEN
166: x_return_status := fnd_api.g_ret_sts_error;
167:
168: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
169: , l_api_name
170: );