DBA Data[Home] [Help]

APPS.EDR_TRANS_ACKN_PUB dependencies on FND_API

Line 57: IF NOT FND_API.Compatible_API_Call (l_api_version ,

53: -- Standard Start of API savepoint
54: SAVEPOINT SEND_ACKN_PUB;
55: */
56: -- Standard call to check for call compatibility.
57: IF NOT FND_API.Compatible_API_Call (l_api_version ,
58: p_api_version ,
59: l_api_name ,
60: G_PKG_NAME )
61: THEN

Line 62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

58: p_api_version ,
59: l_api_name ,
60: G_PKG_NAME )
61: THEN
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: END IF;
64:
65: -- Initialize message list if p_init_msg_list is set to TRUE.
66: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 66: IF FND_API.to_Boolean( p_init_msg_list ) THEN

62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: END IF;
64:
65: -- Initialize message list if p_init_msg_list is set to TRUE.
66: IF FND_API.to_Boolean( p_init_msg_list ) THEN
67: FND_MSG_PUB.initialize;
68: END IF;
69:
70: -- Initialize API return status to success

Line 71: x_return_status := FND_API.G_RET_STS_SUCCESS;

67: FND_MSG_PUB.initialize;
68: END IF;
69:
70: -- Initialize API return status to success
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72:
73: -- BEGIN Bug : 3834375. Added Secure context to allow query of all rows
74: edr_ctx_pkg.set_secure_attr;
75: -- END Bug : 3834375

Line 92: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

88: x_event_key => l_event_key
89: );
90:
91: -- If any errors happen abort API.
92: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
95: RAISE INVALID_ERECORD_ERROR;
96: END IF;

Line 93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

89: );
90:
91: -- If any errors happen abort API.
92: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
95: RAISE INVALID_ERECORD_ERROR;
96: END IF;
97:

Line 94: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

90:
91: -- If any errors happen abort API.
92: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
93: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
94: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
95: RAISE INVALID_ERECORD_ERROR;
96: END IF;
97:
98: if l_event_name <> p_event_name OR l_event_key <> p_event_key

Line 151: IF FND_API.To_Boolean(p_autonomous_commit) THEN

147: -- Find out if the autonomous commit flag is on or not
148: -- if an auto commit is required call the corresponding
149: -- auto txn
150:
151: IF FND_API.To_Boolean(p_autonomous_commit) THEN
152: EDR_TRANS_ACKN_PVT.SEND_ACKN_AUTO
153: ( p_api_version => 1.0 ,
154: p_init_msg_list => FND_API.G_FALSE ,
155: x_return_status => l_return_status ,

Line 154: p_init_msg_list => FND_API.G_FALSE ,

150:
151: IF FND_API.To_Boolean(p_autonomous_commit) THEN
152: EDR_TRANS_ACKN_PVT.SEND_ACKN_AUTO
153: ( p_api_version => 1.0 ,
154: p_init_msg_list => FND_API.G_FALSE ,
155: x_return_status => l_return_status ,
156: x_msg_count => l_msg_count ,
157: x_msg_data => l_msg_data ,
158: p_event_name => p_event_name ,

Line 167: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

163: p_ackn_note => p_ackn_note
164: );
165:
166: -- If any errors happen abort API.
167: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;
170:
171: ELSE

Line 168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

164: );
165:
166: -- If any errors happen abort API.
167: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;
170:
171: ELSE
172: EDR_UTILITIES.getWhoColumns

Line 207: x_return_status := FND_API.G_RET_STS_ERROR ;

203: -- END Bug : 3834375
204: EXCEPTION
205: WHEN INVALID_ERECORD_ERROR THEN
206: -- ROLLBACK TO SEND_ACKN_PUB;
207: x_return_status := FND_API.G_RET_STS_ERROR ;
208:
209: fnd_message.set_name('EDR','EDR_ACK_INVALID_ERECORD');
210: fnd_message.set_token('ERECORD_ID', p_erecord_id);
211: l_mesg_text := fnd_message.get();

Line 228: x_return_status := FND_API.G_RET_STS_ERROR ;

224: edr_ctx_pkg.unset_secure_attr;
225: -- END Bug : 3834375
226: WHEN INVALID_EVENT_ERROR THEN
227: -- ROLLBACK TO SEND_ACKN_PUB;
228: x_return_status := FND_API.G_RET_STS_ERROR ;
229:
230: fnd_message.set_name('EDR','EDR_ACK_INVALID_EVENT');
231: fnd_message.set_token('ERECORD_ID', p_erecord_id);
232: fnd_message.set_token('EVENT_NAME', p_event_name);

Line 251: x_return_status := FND_API.G_RET_STS_ERROR ;

247: edr_ctx_pkg.unset_secure_attr;
248: -- END Bug : 3834375
249: WHEN INVALID_ACK_STATUS_ERROR THEN
250: -- ROLLBACK TO SEND_ACKN_PUB;
251: x_return_status := FND_API.G_RET_STS_ERROR ;
252:
253: fnd_message.set_name('EDR','EDR_ACK_INVALID_STATUS');
254: fnd_message.set_token('ERECORD_ID', p_erecord_id);
255: fnd_message.set_token('STATUS', p_trans_status);

Line 273: x_return_status := FND_API.G_RET_STS_ERROR ;

269: edr_ctx_pkg.unset_secure_attr;
270: -- END Bug : 3834375
271: WHEN DUPLICATE_ACK_ERROR THEN
272: -- ROLLBACK TO SEND_ACKN_PUB;
273: x_return_status := FND_API.G_RET_STS_ERROR ;
274:
275: --close the cursor that was opened
276: close l_ack_csr;
277:

Line 301: x_return_status := FND_API.G_RET_STS_ERROR;

297:
298: --close the cursor that was opened
299: close l_ack_csr;
300:
301: x_return_status := FND_API.G_RET_STS_ERROR;
302:
303: fnd_message.set_name('EDR','EDR_ACK_UNEXPECTED_ERROR');
304: fnd_message.set_token('ERECORD_ID', p_erecord_id);
305: l_mesg_text := fnd_message.get();

Line 320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

316:
317: -- BEGIN Bug : 3834375. Added Secure context to allow query of all rows
318: edr_ctx_pkg.unset_secure_attr;
319: -- END Bug : 3834375
320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
321: -- ROLLBACK;
322: -- ROLLBACK TO SEND_ACKN_PUB;
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
324:

Line 323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

319: -- END Bug : 3834375
320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
321: -- ROLLBACK;
322: -- ROLLBACK TO SEND_ACKN_PUB;
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
324:
325: FND_MSG_PUB.Count_And_Get
326: ( p_count => x_msg_count ,
327: p_data => x_msg_data

Line 336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

332: -- END Bug : 3834375
333: WHEN OTHERS THEN
334: -- ROLLBACK;
335: -- ROLLBACK TO SEND_ACKN_PUB;
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
337:
338: IF FND_MSG_PUB.Check_Msg_Level
339: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
340: THEN