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();
209:
210: FND_MSG_PUB.Add_Exc_Msg
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();
209:
210: FND_MSG_PUB.Add_Exc_Msg
211: ( G_PKG_NAME ,
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();
209:
210: FND_MSG_PUB.Add_Exc_Msg
211: ( G_PKG_NAME ,
212: l_api_name ,
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);
226: l_mesg_text := fnd_message.get();
227:
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);
226: l_mesg_text := fnd_message.get();
227:
228: FND_MSG_PUB.Add_Exc_Msg
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);
226: l_mesg_text := fnd_message.get();
227:
228: FND_MSG_PUB.Add_Exc_Msg
229: ( G_PKG_NAME ,
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);
226: l_mesg_text := fnd_message.get();
227:
228: FND_MSG_PUB.Add_Exc_Msg
229: ( G_PKG_NAME ,
230: l_api_name ,
240:
241: --close the cursor that was opened
242: close l_ack_csr;
243:
244: fnd_message.set_name('EDR','EDR_ACK_DUPLICATE_ACKN');
245: fnd_message.set_token('ERECORD_ID', p_erecord_id);
246: l_mesg_text := fnd_message.get();
247:
248: FND_MSG_PUB.Add_Exc_Msg
241: --close the cursor that was opened
242: close l_ack_csr;
243:
244: fnd_message.set_name('EDR','EDR_ACK_DUPLICATE_ACKN');
245: fnd_message.set_token('ERECORD_ID', p_erecord_id);
246: l_mesg_text := fnd_message.get();
247:
248: FND_MSG_PUB.Add_Exc_Msg
249: ( G_PKG_NAME ,
242: close l_ack_csr;
243:
244: fnd_message.set_name('EDR','EDR_ACK_DUPLICATE_ACKN');
245: fnd_message.set_token('ERECORD_ID', p_erecord_id);
246: l_mesg_text := fnd_message.get();
247:
248: FND_MSG_PUB.Add_Exc_Msg
249: ( G_PKG_NAME ,
250: l_api_name ,