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
503: EXCEPTION
504:
505: WHEN QP_COUPON_NOT_FOUND THEN
506:
507: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
508: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
509: x_return_status_txt := FND_MESSAGE.get;
510: x_return_status := FND_API.G_RET_STS_ERROR;
511:
504:
505: WHEN QP_COUPON_NOT_FOUND THEN
506:
507: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
508: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
509: x_return_status_txt := FND_MESSAGE.get;
510: x_return_status := FND_API.G_RET_STS_ERROR;
511:
512: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
505: WHEN QP_COUPON_NOT_FOUND THEN
506:
507: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
508: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
509: x_return_status_txt := FND_MESSAGE.get;
510: x_return_status := FND_API.G_RET_STS_ERROR;
511:
512: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
513:
510: x_return_status := FND_API.G_RET_STS_ERROR;
511:
512: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
513:
514: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
515: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
516: x_return_status_txt := FND_MESSAGE.get;
517: x_return_status := FND_API.G_RET_STS_ERROR;
518:
511:
512: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
513:
514: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
515: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
516: x_return_status_txt := FND_MESSAGE.get;
517: x_return_status := FND_API.G_RET_STS_ERROR;
518:
519: WHEN OTHERS THEN
512: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
513:
514: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
515: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
516: x_return_status_txt := FND_MESSAGE.get;
517: x_return_status := FND_API.G_RET_STS_ERROR;
518:
519: WHEN OTHERS THEN
520:
614: EXCEPTION
615:
616: WHEN QP_COUPON_NOT_FOUND THEN
617:
618: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
619: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
620: x_return_status_txt := FND_MESSAGE.get;
621: x_return_status := FND_API.G_RET_STS_ERROR;
622:
615:
616: WHEN QP_COUPON_NOT_FOUND THEN
617:
618: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
619: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
620: x_return_status_txt := FND_MESSAGE.get;
621: x_return_status := FND_API.G_RET_STS_ERROR;
622:
623: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
616: WHEN QP_COUPON_NOT_FOUND THEN
617:
618: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
619: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
620: x_return_status_txt := FND_MESSAGE.get;
621: x_return_status := FND_API.G_RET_STS_ERROR;
622:
623: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
624:
621: x_return_status := FND_API.G_RET_STS_ERROR;
622:
623: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
624:
625: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
626: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
627: x_return_status_txt := FND_MESSAGE.get;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629:
622:
623: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
624:
625: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
626: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
627: x_return_status_txt := FND_MESSAGE.get;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629:
630: WHEN OTHERS THEN
623: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
624:
625: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
626: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
627: x_return_status_txt := FND_MESSAGE.get;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629:
630: WHEN OTHERS THEN
631:
707: EXCEPTION
708:
709: WHEN QP_COUPON_NOT_FOUND THEN
710:
711: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
712: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
713: x_return_status_txt := FND_MESSAGE.get;
714: x_return_status := FND_API.G_RET_STS_ERROR;
715:
708:
709: WHEN QP_COUPON_NOT_FOUND THEN
710:
711: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
712: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
713: x_return_status_txt := FND_MESSAGE.get;
714: x_return_status := FND_API.G_RET_STS_ERROR;
715:
716: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
709: WHEN QP_COUPON_NOT_FOUND THEN
710:
711: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_NUMBER');
712: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
713: x_return_status_txt := FND_MESSAGE.get;
714: x_return_status := FND_API.G_RET_STS_ERROR;
715:
716: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
717:
714: x_return_status := FND_API.G_RET_STS_ERROR;
715:
716: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
717:
718: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
719: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
720: x_return_status_txt := FND_MESSAGE.get;
721: x_return_status := FND_API.G_RET_STS_ERROR;
722:
715:
716: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
717:
718: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
719: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
720: x_return_status_txt := FND_MESSAGE.get;
721: x_return_status := FND_API.G_RET_STS_ERROR;
722:
723: WHEN OTHERS THEN
716: WHEN QP_COUPON_QUALIFIER_NOT_FOUND THEN
717:
718: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_COUPON_QUALIFIER');
719: FND_MESSAGE.SET_TOKEN('COUPON_NUMBER', p_coupon_number);
720: x_return_status_txt := FND_MESSAGE.get;
721: x_return_status := FND_API.G_RET_STS_ERROR;
722:
723: WHEN OTHERS THEN
724: