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();
212:
213: FND_MSG_PUB.Add_Exc_Msg
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();
212:
213: FND_MSG_PUB.Add_Exc_Msg
214: ( G_PKG_NAME ,
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();
212:
213: FND_MSG_PUB.Add_Exc_Msg
214: ( G_PKG_NAME ,
215: l_api_name ,
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);
233: fnd_message.set_token('EVENT_KEY', p_event_key);
234: l_mesg_text := fnd_message.get();
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);
233: fnd_message.set_token('EVENT_KEY', p_event_key);
234: l_mesg_text := fnd_message.get();
235:
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);
233: fnd_message.set_token('EVENT_KEY', p_event_key);
234: l_mesg_text := fnd_message.get();
235:
236: FND_MSG_PUB.Add_Exc_Msg
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);
233: fnd_message.set_token('EVENT_KEY', p_event_key);
234: l_mesg_text := fnd_message.get();
235:
236: FND_MSG_PUB.Add_Exc_Msg
237: ( G_PKG_NAME ,
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);
233: fnd_message.set_token('EVENT_KEY', p_event_key);
234: l_mesg_text := fnd_message.get();
235:
236: FND_MSG_PUB.Add_Exc_Msg
237: ( G_PKG_NAME ,
238: l_api_name ,
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);
256: l_mesg_text := fnd_message.get();
257:
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);
256: l_mesg_text := fnd_message.get();
257:
258: FND_MSG_PUB.Add_Exc_Msg
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);
256: l_mesg_text := fnd_message.get();
257:
258: FND_MSG_PUB.Add_Exc_Msg
259: ( G_PKG_NAME ,
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);
256: l_mesg_text := fnd_message.get();
257:
258: FND_MSG_PUB.Add_Exc_Msg
259: ( G_PKG_NAME ,
260: l_api_name ,
274:
275: --close the cursor that was opened
276: close l_ack_csr;
277:
278: fnd_message.set_name('EDR','EDR_ACK_DUPLICATE_ACKN');
279: fnd_message.set_token('ERECORD_ID', p_erecord_id);
280: l_mesg_text := fnd_message.get();
281:
282: FND_MSG_PUB.Add_Exc_Msg
275: --close the cursor that was opened
276: close l_ack_csr;
277:
278: fnd_message.set_name('EDR','EDR_ACK_DUPLICATE_ACKN');
279: fnd_message.set_token('ERECORD_ID', p_erecord_id);
280: l_mesg_text := fnd_message.get();
281:
282: FND_MSG_PUB.Add_Exc_Msg
283: ( G_PKG_NAME ,
276: close l_ack_csr;
277:
278: fnd_message.set_name('EDR','EDR_ACK_DUPLICATE_ACKN');
279: fnd_message.set_token('ERECORD_ID', p_erecord_id);
280: l_mesg_text := fnd_message.get();
281:
282: FND_MSG_PUB.Add_Exc_Msg
283: ( G_PKG_NAME ,
284: l_api_name ,
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();
306:
307: FND_MSG_PUB.Add_Exc_Msg
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();
306:
307: FND_MSG_PUB.Add_Exc_Msg
308: ( G_PKG_NAME ,
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();
306:
307: FND_MSG_PUB.Add_Exc_Msg
308: ( G_PKG_NAME ,
309: l_api_name ,