207: EXCEPTION
208: WHEN NO_DATA_FOUND THEN
209:
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: FND_MESSAGE.SET_NAME('PON', 'RECEIPT_NOT_CRE_FOR_DEPOSIT');
212: FND_MESSAGE.SET_TOKEN('DEPOSIT_TRX_NUM', p_trx_number);
213: FND_MSG_PUB.ADD;
214: x_receipt_num := NULL;
215: x_cash_receipt_id := NULL;
208: WHEN NO_DATA_FOUND THEN
209:
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: FND_MESSAGE.SET_NAME('PON', 'RECEIPT_NOT_CRE_FOR_DEPOSIT');
212: FND_MESSAGE.SET_TOKEN('DEPOSIT_TRX_NUM', p_trx_number);
213: FND_MSG_PUB.ADD;
214: x_receipt_num := NULL;
215: x_cash_receipt_id := NULL;
216: x_receipt_status := NULL;
242: AND acr.cash_receipt_id = x_cash_receipt_id;
243: EXCEPTION
244: WHEN NO_DATA_FOUND THEN
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: FND_MESSAGE.SET_NAME('PON', 'RECEIPT_NOT_CLEARED');
247: FND_MESSAGE.SET_TOKEN('DEPOSIT_TRX_NUM', p_trx_number);
248: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM', x_receipt_num);
249: FND_MSG_PUB.ADD;
250: x_receipt_num := NULL;
243: EXCEPTION
244: WHEN NO_DATA_FOUND THEN
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: FND_MESSAGE.SET_NAME('PON', 'RECEIPT_NOT_CLEARED');
247: FND_MESSAGE.SET_TOKEN('DEPOSIT_TRX_NUM', p_trx_number);
248: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM', x_receipt_num);
249: FND_MSG_PUB.ADD;
250: x_receipt_num := NULL;
251: x_cash_receipt_id := NULL;
244: WHEN NO_DATA_FOUND THEN
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: FND_MESSAGE.SET_NAME('PON', 'RECEIPT_NOT_CLEARED');
247: FND_MESSAGE.SET_TOKEN('DEPOSIT_TRX_NUM', p_trx_number);
248: FND_MESSAGE.SET_TOKEN('RECEIPT_NUM', x_receipt_num);
249: FND_MSG_PUB.ADD;
250: x_receipt_num := NULL;
251: x_cash_receipt_id := NULL;
252: x_receipt_status := NULL;