DBA Data[Home] [Help]

APPS.OKS_REPORT_TEMPLATES_PVT dependencies on FND_MESSAGE

Line 695: fnd_message.set_name('OKS','OKS_TS_DUPLICATE_RECORD');

691: (l_end_date BETWEEN p_rtmpv_rec.start_date AND NVL(p_rtmpv_rec.end_date,SYSDATE+1)) OR
692: (p_rtmpv_rec.start_date BETWEEN l_start_date AND l_end_date) OR
693: (NVL(p_rtmpv_rec.end_date,SYSDATE+1) BETWEEN l_start_date AND l_end_date) THEN
694: -- error
695: fnd_message.set_name('OKS','OKS_TS_DUPLICATE_RECORD');
696: fnd_msg_pub.add;
697: CLOSE csr_check_record2;
698: RETURN OKC_API.G_RET_STS_ERROR;
699: END IF; -- duplicate record found with dates overlap

Line 736: fnd_message.set_name('OKS','OKS_TS_DUPLICATE_RECORD');

732: (l_end_date BETWEEN p_rtmpv_rec.start_date AND NVL(p_rtmpv_rec.end_date,SYSDATE+1)) OR
733: (p_rtmpv_rec.start_date BETWEEN l_start_date AND l_end_date) OR
734: (NVL(p_rtmpv_rec.end_date,SYSDATE+1) BETWEEN l_start_date AND l_end_date) THEN
735: -- error
736: fnd_message.set_name('OKS','OKS_TS_DUPLICATE_RECORD');
737: fnd_msg_pub.add;
738: CLOSE csr_check_record1;
739: RETURN OKC_API.G_RET_STS_ERROR;
740: END IF; -- duplicate record found with dates overlap

Line 791: fnd_message.set_name('OKS','OKS_TS_DUPLICATE_RECORD');

787: (l_end_date BETWEEN p_rtmpv_rec.start_date AND NVL(p_rtmpv_rec.end_date,SYSDATE+1)) OR
788: (p_rtmpv_rec.start_date BETWEEN l_start_date AND l_end_date) OR
789: (NVL(p_rtmpv_rec.end_date,SYSDATE+1) BETWEEN l_start_date AND l_end_date) THEN
790: -- error
791: fnd_message.set_name('OKS','OKS_TS_DUPLICATE_RECORD');
792: fnd_msg_pub.add;
793: CLOSE csr_check_record3;
794: RETURN OKC_API.G_RET_STS_ERROR;
795: END IF; -- duplicate record found with dates overlap

Line 848: fnd_message.set_name('OKS','OKS_TS_DUPLICATE_RECORD');

844: (l_end_date BETWEEN p_rtmpv_rec.start_date AND NVL(p_rtmpv_rec.end_date,SYSDATE+1)) OR
845: (p_rtmpv_rec.start_date BETWEEN l_start_date AND l_end_date) OR
846: (NVL(p_rtmpv_rec.end_date,SYSDATE+1) BETWEEN l_start_date AND l_end_date) THEN
847: -- error
848: fnd_message.set_name('OKS','OKS_TS_DUPLICATE_RECORD');
849: fnd_msg_pub.add;
850: CLOSE csr_check_record4;
851: RETURN OKC_API.G_RET_STS_ERROR;
852: END IF; -- duplicate record found with dates overlap

Line 904: fnd_message.set_name('OKS','OKS_TS_DUPLICATE_RECORD');

900: (l_end_date BETWEEN p_rtmpv_rec.start_date AND NVL(p_rtmpv_rec.end_date,SYSDATE+1)) OR
901: (p_rtmpv_rec.start_date BETWEEN l_start_date AND l_end_date) OR
902: (NVL(p_rtmpv_rec.end_date,SYSDATE+1) BETWEEN l_start_date AND l_end_date) THEN
903: -- error
904: fnd_message.set_name('OKS','OKS_TS_DUPLICATE_RECORD');
905: fnd_msg_pub.add;
906: CLOSE csr_check_record5;
907: RETURN OKC_API.G_RET_STS_ERROR;
908: END IF; -- duplicate record found with dates overlap

Line 959: fnd_message.set_name('OKS','OKS_TS_DUPLICATE_RECORD');

955: (l_end_date BETWEEN p_rtmpv_rec.start_date AND NVL(p_rtmpv_rec.end_date,SYSDATE+1)) OR
956: (p_rtmpv_rec.start_date BETWEEN l_start_date AND l_end_date) OR
957: (NVL(p_rtmpv_rec.end_date,SYSDATE+1) BETWEEN l_start_date AND l_end_date) THEN
958: -- error
959: fnd_message.set_name('OKS','OKS_TS_DUPLICATE_RECORD');
960: fnd_msg_pub.add;
961: CLOSE csr_check_record6;
962: RETURN OKC_API.G_RET_STS_ERROR;
963: END IF; -- duplicate record found with dates overlap

Line 991: fnd_message.set_name('OKS','OKS_TS_TMPL_DATA');

987:
988: IF ( p_rtmpv_rec.message_template_id IS NULL ) AND
989: ( p_rtmpv_rec.report_id IS NULL ) THEN
990: -- error
991: fnd_message.set_name('OKS','OKS_TS_TMPL_DATA');
992: fnd_msg_pub.add;
993: RETURN OKC_API.G_RET_STS_ERROR;
994: END IF; -- check if atleast Message template or Attachment template is entered
995: