DBA Data[Home] [Help]

APPS.INV_RMA_SERIAL_PVT dependencies on FND_API

Line 19: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE ,

15: -- Unexpected error
16:
17: procedure populate_temp_table(
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
20: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
21: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_msg_count OUT NOCOPY NUMBER,

Line 20: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

16:
17: procedure populate_temp_table(
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
20: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
21: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2,

Line 21: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

17: procedure populate_temp_table(
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
20: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
21: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2,
25: x_errorcode OUT NOCOPY NUMBER,

Line 64: IF NOT FND_API.Compatible_API_Call(l_api_version

60:
61: BEGIN
62:
63: -- Standard Call to check for call compatibility
64: IF NOT FND_API.Compatible_API_Call(l_api_version
65: , p_api_version
66: , l_api_name
67: , G_PKG_NAME) THEN
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

64: IF NOT FND_API.Compatible_API_Call(l_api_version
65: , p_api_version
66: , l_api_name
67: , G_PKG_NAME) THEN
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70: --
71: -- Initialize message list if p_init_msg_list is set to true
72: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 72: IF FND_API.to_Boolean(p_init_msg_list) THEN

68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70: --
71: -- Initialize message list if p_init_msg_list is set to true
72: IF FND_API.to_Boolean(p_init_msg_list) THEN
73: FND_MSG_PUB.initialize;
74: END IF;
75: --
76: -- Initialisize API return status to success

Line 77: x_return_status := FND_API.G_RET_STS_SUCCESS;

73: FND_MSG_PUB.initialize;
74: END IF;
75: --
76: -- Initialisize API return status to success
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78: x_errorcode := 0;
79: INV_RMA_SERIAL_PVT.g_return_status := x_return_status; --3572112
80: INV_RMA_SERIAL_PVT.g_error_code := x_errorcode; --3572112
81: INV_RMA_SERIAL_PVT.g_rma_line_id := p_rma_line_id; --3572112

Line 148: RAISE FND_API.G_EXC_ERROR;

144:
145: IF (l_count = 0) THEN
146: x_errorcode := 1;
147: INV_RMA_SERIAL_PVT.g_error_code := x_errorcode; --3572112
148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF (l_count > 0) THEN
150:
151: OPEN oe_lot_serials(l_orig_line_id);
152: LOOP

Line 171: RAISE FND_API.G_EXC_ERROR;

167:
168: BEGIN
169: x_errorcode := to_number(l_err);
170: INV_RMA_SERIAL_PVT.g_error_code := x_errorcode; --3572112
171: RAISE FND_API.G_EXC_ERROR;
172: END;
173: END IF;
174:
175: l_number_part := TO_NUMBER(l_fm_num);

Line 208: x_return_status := FND_API.G_RET_STS_SUCCESS;

204:
205: END LOOP;
206: END LOOP;
207: END IF;
208: x_return_status := FND_API.G_RET_STS_SUCCESS;
209: INV_RMA_SERIAL_PVT.g_return_status := x_return_status;
210:
211: ELSE IF (l_temp_count > 0) THEN
212: --Serials are already populated in the temp table

Line 214: x_return_status := FND_API.G_RET_STS_SUCCESS;

210:
211: ELSE IF (l_temp_count > 0) THEN
212: --Serials are already populated in the temp table
213: --return error_code = 0 and success.
214: x_return_status := FND_API.G_RET_STS_SUCCESS;
215: x_errorcode := 0;
216: INV_RMA_SERIAL_PVT.g_return_status := x_return_status; --3572112
217: INV_RMA_SERIAL_PVT.g_error_code := x_errorcode; --3572112
218: END IF;

Line 223: WHEN FND_API.G_EXC_ERROR THEN

219:
220: END IF;
221:
222: EXCEPTION
223: WHEN FND_API.G_EXC_ERROR THEN
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: INV_RMA_SERIAL_PVT.g_return_status := x_return_status; --3572112
226:
227: WHEN OTHERS THEN

Line 224: x_return_status := FND_API.G_RET_STS_ERROR;

220: END IF;
221:
222: EXCEPTION
223: WHEN FND_API.G_EXC_ERROR THEN
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: INV_RMA_SERIAL_PVT.g_return_status := x_return_status; --3572112
226:
227: WHEN OTHERS THEN
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

224: x_return_status := FND_API.G_RET_STS_ERROR;
225: INV_RMA_SERIAL_PVT.g_return_status := x_return_status; --3572112
226:
227: WHEN OTHERS THEN
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: INV_RMA_SERIAL_PVT.g_return_status := x_return_status; --3572112
230:
231: END populate_temp_table;
232: -- Added the below function for bug 3572112