169: IF (p_expiration_date IS NULL AND
170: (p_number_expiration_periods IS NULL OR
171: p_expiration_period_uom_code IS NULL)) THEN
172:
173: FND_MESSAGE.SET_NAME('QP', 'QP_EXPIRATION_DATE_NOT_SET');
174:
175: x_return_status_txt := FND_MESSAGE.GET;
176:
177: RAISE FND_API.G_EXC_ERROR;
171: p_expiration_period_uom_code IS NULL)) THEN
172:
173: FND_MESSAGE.SET_NAME('QP', 'QP_EXPIRATION_DATE_NOT_SET');
174:
175: x_return_status_txt := FND_MESSAGE.GET;
176:
177: RAISE FND_API.G_EXC_ERROR;
178:
179: END IF;
437: x_return_status := FND_API.G_RET_STS_ERROR;
438:
439: WHEN QP_COUPON_MODIFIER_NOT_FOUND THEN
440:
441: fnd_message.set_name('QP', 'QP_COUPON_MODIFIER_NOT_FOUND');
442: fnd_message.set_token('ID_COLUMN', 'LIST_LINE_ID');
443: fnd_message.set_token('LIST_LINE_ID', p_list_line_id);
444: x_return_status_txt := fnd_message.get;
445:
438:
439: WHEN QP_COUPON_MODIFIER_NOT_FOUND THEN
440:
441: fnd_message.set_name('QP', 'QP_COUPON_MODIFIER_NOT_FOUND');
442: fnd_message.set_token('ID_COLUMN', 'LIST_LINE_ID');
443: fnd_message.set_token('LIST_LINE_ID', p_list_line_id);
444: x_return_status_txt := fnd_message.get;
445:
446: x_return_status := FND_API.G_RET_STS_ERROR;
439: WHEN QP_COUPON_MODIFIER_NOT_FOUND THEN
440:
441: fnd_message.set_name('QP', 'QP_COUPON_MODIFIER_NOT_FOUND');
442: fnd_message.set_token('ID_COLUMN', 'LIST_LINE_ID');
443: fnd_message.set_token('LIST_LINE_ID', p_list_line_id);
444: x_return_status_txt := fnd_message.get;
445:
446: x_return_status := FND_API.G_RET_STS_ERROR;
447:
440:
441: fnd_message.set_name('QP', 'QP_COUPON_MODIFIER_NOT_FOUND');
442: fnd_message.set_token('ID_COLUMN', 'LIST_LINE_ID');
443: fnd_message.set_token('LIST_LINE_ID', p_list_line_id);
444: x_return_status_txt := fnd_message.get;
445:
446: x_return_status := FND_API.G_RET_STS_ERROR;
447:
448: WHEN OTHERS THEN
513: EXCEPTION
514:
515: WHEN QP_COUPON_NOT_FOUND THEN
516:
517: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
518: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
519: x_return_status_txt := FND_MESSAGE.get;
520: x_return_status := FND_API.G_RET_STS_ERROR;
521:
514:
515: WHEN QP_COUPON_NOT_FOUND THEN
516:
517: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
518: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
519: x_return_status_txt := FND_MESSAGE.get;
520: x_return_status := FND_API.G_RET_STS_ERROR;
521:
522: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
515: WHEN QP_COUPON_NOT_FOUND THEN
516:
517: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
518: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
519: x_return_status_txt := FND_MESSAGE.get;
520: x_return_status := FND_API.G_RET_STS_ERROR;
521:
522: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
523:
520: x_return_status := FND_API.G_RET_STS_ERROR;
521:
522: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
523:
524: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
525: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
526: x_return_status_txt := FND_MESSAGE.get;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528:
521:
522: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
523:
524: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
525: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
526: x_return_status_txt := FND_MESSAGE.get;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528:
529: WHEN OTHERS THEN
522: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
523:
524: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
525: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
526: x_return_status_txt := FND_MESSAGE.get;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528:
529: WHEN OTHERS THEN
530:
647: EXCEPTION
648:
649: WHEN QP_COUPON_NOT_FOUND THEN
650:
651: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
652: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
653: x_return_status_txt := FND_MESSAGE.get;
654: x_return_status := FND_API.G_RET_STS_ERROR;
655:
648:
649: WHEN QP_COUPON_NOT_FOUND THEN
650:
651: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
652: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
653: x_return_status_txt := FND_MESSAGE.get;
654: x_return_status := FND_API.G_RET_STS_ERROR;
655:
656: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
649: WHEN QP_COUPON_NOT_FOUND THEN
650:
651: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
652: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
653: x_return_status_txt := FND_MESSAGE.get;
654: x_return_status := FND_API.G_RET_STS_ERROR;
655:
656: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
657:
654: x_return_status := FND_API.G_RET_STS_ERROR;
655:
656: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
657:
658: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
659: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
660: x_return_status_txt := FND_MESSAGE.get;
661: x_return_status := FND_API.G_RET_STS_ERROR;
662:
655:
656: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
657:
658: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
659: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
660: x_return_status_txt := FND_MESSAGE.get;
661: x_return_status := FND_API.G_RET_STS_ERROR;
662:
663: WHEN OTHERS THEN
656: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
657:
658: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
659: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
660: x_return_status_txt := FND_MESSAGE.get;
661: x_return_status := FND_API.G_RET_STS_ERROR;
662:
663: WHEN OTHERS THEN
664:
740: EXCEPTION
741:
742: WHEN QP_COUPON_NOT_FOUND THEN
743:
744: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
745: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
746: x_return_status_txt := FND_MESSAGE.get;
747: x_return_status := FND_API.G_RET_STS_ERROR;
748:
741:
742: WHEN QP_COUPON_NOT_FOUND THEN
743:
744: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
745: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
746: x_return_status_txt := FND_MESSAGE.get;
747: x_return_status := FND_API.G_RET_STS_ERROR;
748:
749: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
742: WHEN QP_COUPON_NOT_FOUND THEN
743:
744: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
745: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
746: x_return_status_txt := FND_MESSAGE.get;
747: x_return_status := FND_API.G_RET_STS_ERROR;
748:
749: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
750:
747: x_return_status := FND_API.G_RET_STS_ERROR;
748:
749: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
750:
751: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
752: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
753: x_return_status_txt := FND_MESSAGE.get;
754: x_return_status := FND_API.G_RET_STS_ERROR;
755:
748:
749: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
750:
751: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
752: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
753: x_return_status_txt := FND_MESSAGE.get;
754: x_return_status := FND_API.G_RET_STS_ERROR;
755:
756: WHEN OTHERS THEN
749: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
750:
751: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
752: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
753: x_return_status_txt := FND_MESSAGE.get;
754: x_return_status := FND_API.G_RET_STS_ERROR;
755:
756: WHEN OTHERS THEN
757: