DBA Data[Home] [Help]

APPS.OKS_DEFAULTS_PUB dependencies on FND_MESSAGE

Line 66: fnd_message.set_name('OKS','OKS_DATE_OVERLAP');

62: (dup_check_rec.end_date BETWEEN p_start_date AND NVL(p_end_date,l_infinite_date)) OR
63: (p_start_date BETWEEN dup_check_rec.start_date AND NVL(dup_check_rec.end_date,l_infinite_date)) OR
64: (p_end_date BETWEEN dup_check_rec.start_date AND NVL(dup_check_rec.end_date,l_infinite_date)))
65: THEN
66: fnd_message.set_name('OKS','OKS_DATE_OVERLAP');
67: fnd_message.set_token('DATE','OKS_DATE_OVERLAP_GBSET',TRUE);
68: fnd_msg_pub.add;
69: x_overlap_yn := 'Y';
70: EXIT;

Line 67: fnd_message.set_token('DATE','OKS_DATE_OVERLAP_GBSET',TRUE);

63: (p_start_date BETWEEN dup_check_rec.start_date AND NVL(dup_check_rec.end_date,l_infinite_date)) OR
64: (p_end_date BETWEEN dup_check_rec.start_date AND NVL(dup_check_rec.end_date,l_infinite_date)))
65: THEN
66: fnd_message.set_name('OKS','OKS_DATE_OVERLAP');
67: fnd_message.set_token('DATE','OKS_DATE_OVERLAP_GBSET',TRUE);
68: fnd_msg_pub.add;
69: x_overlap_yn := 'Y';
70: EXIT;
71: END IF; -- duplicate record found with dates overlap