DBA Data[Home] [Help]

APPS.EDR_TRANS_ACKN_PVT dependencies on FND_API

Line 85: IF NOT FND_API.Compatible_API_Call (l_api_version ,

81: where erecord_id = p_erecord_id;
82:
83: begin
84: -- Standard call to check for call compatibility.
85: IF NOT FND_API.Compatible_API_Call (l_api_version ,
86: p_api_version ,
87: l_api_name ,
88: G_PKG_NAME )
89: THEN

Line 90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

86: p_api_version ,
87: l_api_name ,
88: G_PKG_NAME )
89: THEN
90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
91: END IF;
92:
93: -- Initialize message list if p_init_msg_list is set to TRUE.
94: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 94: IF FND_API.to_Boolean( p_init_msg_list ) THEN

90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
91: END IF;
92:
93: -- Initialize message list if p_init_msg_list is set to TRUE.
94: IF FND_API.to_Boolean( p_init_msg_list ) THEN
95: FND_MSG_PUB.initialize;
96: END IF;
97:
98: -- Initialize API return status to success

Line 99: x_return_status := FND_API.G_RET_STS_SUCCESS;

95: FND_MSG_PUB.initialize;
96: END IF;
97:
98: -- Initialize API return status to success
99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100:
101: -- API Body
102: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
103:

Line 102: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

98: -- Initialize API return status to success
99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100:
101: -- API Body
102: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
103:
104: -- validate if this is a duplicate acknowledgement
105: if p_validation_level >= G_VALIDATE_DUP_ACK then
106: open l_ack_csr;

Line 129: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

125: p_erecord_id => p_erecord_id
126: );
127:
128: -- If any errors happen abort API.
129: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
132: RAISE INVALID_ERECORD_ERROR;
133: END IF;

Line 130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

126: );
127:
128: -- If any errors happen abort API.
129: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
132: RAISE INVALID_ERECORD_ERROR;
133: END IF;
134: end if;

Line 131: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

127:
128: -- If any errors happen abort API.
129: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
132: RAISE INVALID_ERECORD_ERROR;
133: END IF;
134: end if;
135:

Line 204: x_return_status := FND_API.G_RET_STS_ERROR ;

200: );
201:
202: EXCEPTION
203: WHEN INVALID_ERECORD_ERROR THEN
204: x_return_status := FND_API.G_RET_STS_ERROR ;
205:
206: fnd_message.set_name('EDR','EDR_ACK_INVALID_ERECORD');
207: fnd_message.set_token('ERECORD_ID', p_erecord_id);
208: l_mesg_text := fnd_message.get();

Line 221: x_return_status := FND_API.G_RET_STS_ERROR ;

217: p_data => x_msg_data
218: );
219:
220: WHEN INVALID_ACK_STATUS_ERROR THEN
221: x_return_status := FND_API.G_RET_STS_ERROR ;
222:
223: fnd_message.set_name('EDR','EDR_ACK_INVALID_STATUS');
224: fnd_message.set_token('ERECORD_ID', p_erecord_id);
225: fnd_message.set_token('STATUS', p_trans_status);

Line 239: x_return_status := FND_API.G_RET_STS_ERROR ;

235: p_data => x_msg_data
236: );
237:
238: WHEN DUPLICATE_ACK_ERROR THEN
239: x_return_status := FND_API.G_RET_STS_ERROR ;
240:
241: --close the cursor that was opened
242: close l_ack_csr;
243:

Line 258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

254: ( p_count => x_msg_count ,
255: p_data => x_msg_data
256: );
257:
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
260:
261: FND_MSG_PUB.Count_And_Get
262: ( p_count => x_msg_count ,

Line 259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

255: p_data => x_msg_data
256: );
257:
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
260:
261: FND_MSG_PUB.Count_And_Get
262: ( p_count => x_msg_count ,
263: p_data => x_msg_data

Line 267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

263: p_data => x_msg_data
264: );
265:
266: WHEN OTHERS THEN
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
268:
269: IF FND_MSG_PUB.Check_Msg_Level
270: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
271: THEN

Line 287: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE ,

283: end INSERT_ROW;
284:
285: procedure SEND_ACKN_AUTO
286: ( p_api_version IN NUMBER ,
287: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE ,
288: x_return_status OUT NOCOPY VARCHAR2 ,
289: x_msg_count OUT NOCOPY NUMBER ,
290: x_msg_data OUT NOCOPY VARCHAR2 ,
291: p_event_name IN VARCHAR2 ,

Line 310: IF NOT FND_API.Compatible_API_Call (l_api_version ,

306: L_LAST_UPDATE_LOGIN NUMBER;
307:
308: begin
309: -- Standard call to check for call compatibility.
310: IF NOT FND_API.Compatible_API_Call (l_api_version ,
311: p_api_version ,
312: l_api_name ,
313: G_PKG_NAME )
314: THEN

Line 315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

311: p_api_version ,
312: l_api_name ,
313: G_PKG_NAME )
314: THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:
318: -- Initialize message list if p_init_msg_list is set to TRUE.
319: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 319: IF FND_API.to_Boolean( p_init_msg_list ) THEN

315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:
318: -- Initialize message list if p_init_msg_list is set to TRUE.
319: IF FND_API.to_Boolean( p_init_msg_list ) THEN
320: FND_MSG_PUB.initialize;
321: END IF;
322:
323: -- Initialize API return status to success

Line 324: x_return_status := FND_API.G_RET_STS_SUCCESS;

320: FND_MSG_PUB.initialize;
321: END IF;
322:
323: -- Initialize API return status to success
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326: -- API Body
327:
328: -- This API is called after all the validations are done

Line 353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

349: -- always commit, this is an autonomous txn
350: COMMIT;
351:
352: EXCEPTION
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: ROLLBACK;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
356:
357: FND_MSG_PUB.Count_And_Get

Line 355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

351:
352: EXCEPTION
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: ROLLBACK;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
356:
357: FND_MSG_PUB.Count_And_Get
358: ( p_count => x_msg_count ,
359: p_data => x_msg_data

Line 364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

360: );
361:
362: WHEN OTHERS THEN
363: ROLLBACK;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
365:
366: IF FND_MSG_PUB.Check_Msg_Level
367: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
368: THEN