eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_REPORT_TEMPLATES_PVT dependencies on FND_MSG_PUB

Line 17: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;

13: px_error_rec IN OUT NOCOPY OKC_API.ERROR_REC_TYPE,
14: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
15:
16: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
17: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;
18: l_msg_idx INTEGER := FND_MSG_PUB.G_NEXT;
19: BEGIN
20: -- FND_MSG_PUB has a small error in it. If we call FND_MSG_PUB.COUNT_AND_GET before
21: -- we call FND_MSG_PUB.GET, the variable FND_MSG_PUB uses to control the index of the

Line 18: l_msg_idx INTEGER := FND_MSG_PUB.G_NEXT;

14: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
15:
16: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
17: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;
18: l_msg_idx INTEGER := FND_MSG_PUB.G_NEXT;
19: BEGIN
20: -- FND_MSG_PUB has a small error in it. If we call FND_MSG_PUB.COUNT_AND_GET before
21: -- we call FND_MSG_PUB.GET, the variable FND_MSG_PUB uses to control the index of the
22: -- message stack gets set to 1. This makes sense until we call FND_MSG_PUB.GET which

Line 20: -- FND_MSG_PUB has a small error in it. If we call FND_MSG_PUB.COUNT_AND_GET before

16: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
17: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;
18: l_msg_idx INTEGER := FND_MSG_PUB.G_NEXT;
19: BEGIN
20: -- FND_MSG_PUB has a small error in it. If we call FND_MSG_PUB.COUNT_AND_GET before
21: -- we call FND_MSG_PUB.GET, the variable FND_MSG_PUB uses to control the index of the
22: -- message stack gets set to 1. This makes sense until we call FND_MSG_PUB.GET which
23: -- automatically increments the index by 1, (making it 2), however, when the GET function
24: -- attempts to pull message 2, we get a NO_DATA_FOUND exception because there isn't any

Line 21: -- we call FND_MSG_PUB.GET, the variable FND_MSG_PUB uses to control the index of the

17: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;
18: l_msg_idx INTEGER := FND_MSG_PUB.G_NEXT;
19: BEGIN
20: -- FND_MSG_PUB has a small error in it. If we call FND_MSG_PUB.COUNT_AND_GET before
21: -- we call FND_MSG_PUB.GET, the variable FND_MSG_PUB uses to control the index of the
22: -- message stack gets set to 1. This makes sense until we call FND_MSG_PUB.GET which
23: -- automatically increments the index by 1, (making it 2), however, when the GET function
24: -- attempts to pull message 2, we get a NO_DATA_FOUND exception because there isn't any
25: -- message 2. To circumvent this problem, check the amount of messages and compensate.

Line 22: -- message stack gets set to 1. This makes sense until we call FND_MSG_PUB.GET which

18: l_msg_idx INTEGER := FND_MSG_PUB.G_NEXT;
19: BEGIN
20: -- FND_MSG_PUB has a small error in it. If we call FND_MSG_PUB.COUNT_AND_GET before
21: -- we call FND_MSG_PUB.GET, the variable FND_MSG_PUB uses to control the index of the
22: -- message stack gets set to 1. This makes sense until we call FND_MSG_PUB.GET which
23: -- automatically increments the index by 1, (making it 2), however, when the GET function
24: -- attempts to pull message 2, we get a NO_DATA_FOUND exception because there isn't any
25: -- message 2. To circumvent this problem, check the amount of messages and compensate.
26: -- Again, this error only occurs when 1 message is on the stack because COUNT_AND_GET

Line 29: l_msg_idx := FND_MSG_PUB.G_FIRST;

25: -- message 2. To circumvent this problem, check the amount of messages and compensate.
26: -- Again, this error only occurs when 1 message is on the stack because COUNT_AND_GET
27: -- will only update the index variable when 1 and only 1 message is on the stack.
28: IF (last_msg_idx = 1) THEN
29: l_msg_idx := FND_MSG_PUB.G_FIRST;
30: END IF;
31: LOOP
32: fnd_msg_pub.get(
33: p_msg_index => l_msg_idx,

Line 32: fnd_msg_pub.get(

28: IF (last_msg_idx = 1) THEN
29: l_msg_idx := FND_MSG_PUB.G_FIRST;
30: END IF;
31: LOOP
32: fnd_msg_pub.get(
33: p_msg_index => l_msg_idx,
34: p_encoded => fnd_api.g_false,
35: p_data => px_error_rec.msg_data,
36: p_msg_index_out => px_error_rec.msg_count);

Line 696: fnd_msg_pub.add;

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
700: END IF; -- csr_check_record2%FOUND

Line 737: fnd_msg_pub.add;

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
741: END IF; -- csr_check_record1%FOUND

Line 792: fnd_msg_pub.add;

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
796: END IF; -- csr_check_record3%FOUND

Line 849: fnd_msg_pub.add;

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
853: END IF; -- csr_check_record4%FOUND

Line 905: fnd_msg_pub.add;

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
909: END IF; -- csr_check_record5%FOUND

Line 960: fnd_msg_pub.add;

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
964: END IF; -- csr_check_record6%FOUND

Line 992: fnd_msg_pub.add;

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:
996: -- skekkar