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.BIS_RSG_PUB_APIS_PKG dependencies on FND_MESSAGE

Line 37: fnd_message.set_name('BIS','BIS_RSG_INVALID_ROOT_ID');

33:
34: open cv_root( p_root_request_id);
35: fetch cv_root into rset_id;
36: if(CV_ROOT%NOTFOUND or rset_id is null) THEN
37: fnd_message.set_name('BIS','BIS_RSG_INVALID_ROOT_ID');
38: fnd_message.set_token('RSID',TO_CHAR(p_root_request_id));
39: errbuf := FND_MESSAGE.GET;
40: errcode := 'BIS_RSG_INVALID_ROOT_ID';
41: close cv_root;

Line 38: fnd_message.set_token('RSID',TO_CHAR(p_root_request_id));

34: open cv_root( p_root_request_id);
35: fetch cv_root into rset_id;
36: if(CV_ROOT%NOTFOUND or rset_id is null) THEN
37: fnd_message.set_name('BIS','BIS_RSG_INVALID_ROOT_ID');
38: fnd_message.set_token('RSID',TO_CHAR(p_root_request_id));
39: errbuf := FND_MESSAGE.GET;
40: errcode := 'BIS_RSG_INVALID_ROOT_ID';
41: close cv_root;
42: return null;

Line 39: errbuf := FND_MESSAGE.GET;

35: fetch cv_root into rset_id;
36: if(CV_ROOT%NOTFOUND or rset_id is null) THEN
37: fnd_message.set_name('BIS','BIS_RSG_INVALID_ROOT_ID');
38: fnd_message.set_token('RSID',TO_CHAR(p_root_request_id));
39: errbuf := FND_MESSAGE.GET;
40: errcode := 'BIS_RSG_INVALID_ROOT_ID';
41: close cv_root;
42: return null;
43: else

Line 48: fnd_message.set_name('BIS','BIS_RSG_INVALID_ROOT_ID');

44: BEGIN
45: nrset_id := to_number(rset_id);
46: EXCEPTION
47: WHEN OTHERS THEN
48: fnd_message.set_name('BIS','BIS_RSG_INVALID_ROOT_ID');
49: fnd_message.set_token('RSID',TO_CHAR(p_root_request_id));
50: errbuf := FND_MESSAGE.GET;
51: errcode := 'BIS_RSG_INVALID_ROOT_ID';
52: close cv_root;

Line 49: fnd_message.set_token('RSID',TO_CHAR(p_root_request_id));

45: nrset_id := to_number(rset_id);
46: EXCEPTION
47: WHEN OTHERS THEN
48: fnd_message.set_name('BIS','BIS_RSG_INVALID_ROOT_ID');
49: fnd_message.set_token('RSID',TO_CHAR(p_root_request_id));
50: errbuf := FND_MESSAGE.GET;
51: errcode := 'BIS_RSG_INVALID_ROOT_ID';
52: close cv_root;
53: return null;

Line 50: errbuf := FND_MESSAGE.GET;

46: EXCEPTION
47: WHEN OTHERS THEN
48: fnd_message.set_name('BIS','BIS_RSG_INVALID_ROOT_ID');
49: fnd_message.set_token('RSID',TO_CHAR(p_root_request_id));
50: errbuf := FND_MESSAGE.GET;
51: errcode := 'BIS_RSG_INVALID_ROOT_ID';
52: close cv_root;
53: return null;
54: END;

Line 60: fnd_message.set_name('BIS','BIS_RSG_NO_RS_FOUND');

56:
57: open cv(nrset_id);
58: fetch cv into rs_name;
59: if(CV%NOTFOUND) THEN
60: fnd_message.set_name('BIS','BIS_RSG_NO_RS_FOUND');
61: fnd_message.set_token('RSID',TO_CHAR(p_root_request_id));
62: fnd_message.set_token('RSETID',rset_id);
63: errbuf := FND_MESSAGE.GET;
64: errcode := 'BIS_RSG_NO_RS_FOUND';

Line 61: fnd_message.set_token('RSID',TO_CHAR(p_root_request_id));

57: open cv(nrset_id);
58: fetch cv into rs_name;
59: if(CV%NOTFOUND) THEN
60: fnd_message.set_name('BIS','BIS_RSG_NO_RS_FOUND');
61: fnd_message.set_token('RSID',TO_CHAR(p_root_request_id));
62: fnd_message.set_token('RSETID',rset_id);
63: errbuf := FND_MESSAGE.GET;
64: errcode := 'BIS_RSG_NO_RS_FOUND';
65: else

Line 62: fnd_message.set_token('RSETID',rset_id);

58: fetch cv into rs_name;
59: if(CV%NOTFOUND) THEN
60: fnd_message.set_name('BIS','BIS_RSG_NO_RS_FOUND');
61: fnd_message.set_token('RSID',TO_CHAR(p_root_request_id));
62: fnd_message.set_token('RSETID',rset_id);
63: errbuf := FND_MESSAGE.GET;
64: errcode := 'BIS_RSG_NO_RS_FOUND';
65: else
66: fnd_message.set_name('BIS','BIS_RSG_SUCCESS');

Line 63: errbuf := FND_MESSAGE.GET;

59: if(CV%NOTFOUND) THEN
60: fnd_message.set_name('BIS','BIS_RSG_NO_RS_FOUND');
61: fnd_message.set_token('RSID',TO_CHAR(p_root_request_id));
62: fnd_message.set_token('RSETID',rset_id);
63: errbuf := FND_MESSAGE.GET;
64: errcode := 'BIS_RSG_NO_RS_FOUND';
65: else
66: fnd_message.set_name('BIS','BIS_RSG_SUCCESS');
67: errbuf := FND_MESSAGE.GET;

Line 66: fnd_message.set_name('BIS','BIS_RSG_SUCCESS');

62: fnd_message.set_token('RSETID',rset_id);
63: errbuf := FND_MESSAGE.GET;
64: errcode := 'BIS_RSG_NO_RS_FOUND';
65: else
66: fnd_message.set_name('BIS','BIS_RSG_SUCCESS');
67: errbuf := FND_MESSAGE.GET;
68: errcode := 'BIS_RSG_SUCCESS';
69: END IF;
70: close cv;

Line 67: errbuf := FND_MESSAGE.GET;

63: errbuf := FND_MESSAGE.GET;
64: errcode := 'BIS_RSG_NO_RS_FOUND';
65: else
66: fnd_message.set_name('BIS','BIS_RSG_SUCCESS');
67: errbuf := FND_MESSAGE.GET;
68: errcode := 'BIS_RSG_SUCCESS';
69: END IF;
70: close cv;
71: return rs_name;

Line 92: fnd_message.set_name('BIS','BIS_RSG_NO_RS_STANDALONE');

88: l_request_id := fnd_global.CONC_REQUEST_ID;
89: l_root_request_id := fnd_global.CONC_PRIORITY_REQUEST;
90:
91: if(l_request_id = l_root_request_id) then
92: fnd_message.set_name('BIS','BIS_RSG_NO_RS_STANDALONE');
93: fnd_message.set_token('RSID',TO_CHAR(l_request_id));
94: errbuf := FND_MESSAGE.GET;
95: errcode := 'BIS_RSG_NO_RS_STANDALONE';
96: return null;

Line 93: fnd_message.set_token('RSID',TO_CHAR(l_request_id));

89: l_root_request_id := fnd_global.CONC_PRIORITY_REQUEST;
90:
91: if(l_request_id = l_root_request_id) then
92: fnd_message.set_name('BIS','BIS_RSG_NO_RS_STANDALONE');
93: fnd_message.set_token('RSID',TO_CHAR(l_request_id));
94: errbuf := FND_MESSAGE.GET;
95: errcode := 'BIS_RSG_NO_RS_STANDALONE';
96: return null;
97: end if;

Line 94: errbuf := FND_MESSAGE.GET;

90:
91: if(l_request_id = l_root_request_id) then
92: fnd_message.set_name('BIS','BIS_RSG_NO_RS_STANDALONE');
93: fnd_message.set_token('RSID',TO_CHAR(l_request_id));
94: errbuf := FND_MESSAGE.GET;
95: errcode := 'BIS_RSG_NO_RS_STANDALONE';
96: return null;
97: end if;
98:

Line 123: fnd_message.set_name('BIS','BIS_RSG_NO_RSDATA_FOUND');

119: l_value := null;
120: open cv(p_req_set_name);
121: fetch cv into l_value;
122: if(CV%NOTFOUND) THEN
123: fnd_message.set_name('BIS','BIS_RSG_NO_RSDATA_FOUND');
124: fnd_message.set_token('RSNAME',p_req_set_name);
125: errbuf := FND_MESSAGE.GET;
126: errcode := 'BIS_RSG_NO_RSDATA_FOUND';
127: elsif l_value is null then

Line 124: fnd_message.set_token('RSNAME',p_req_set_name);

120: open cv(p_req_set_name);
121: fetch cv into l_value;
122: if(CV%NOTFOUND) THEN
123: fnd_message.set_name('BIS','BIS_RSG_NO_RSDATA_FOUND');
124: fnd_message.set_token('RSNAME',p_req_set_name);
125: errbuf := FND_MESSAGE.GET;
126: errcode := 'BIS_RSG_NO_RSDATA_FOUND';
127: elsif l_value is null then
128: fnd_message.set_name('BIS','BIS_RSG_RS_NO_REF_MODE');

Line 125: errbuf := FND_MESSAGE.GET;

121: fetch cv into l_value;
122: if(CV%NOTFOUND) THEN
123: fnd_message.set_name('BIS','BIS_RSG_NO_RSDATA_FOUND');
124: fnd_message.set_token('RSNAME',p_req_set_name);
125: errbuf := FND_MESSAGE.GET;
126: errcode := 'BIS_RSG_NO_RSDATA_FOUND';
127: elsif l_value is null then
128: fnd_message.set_name('BIS','BIS_RSG_RS_NO_REF_MODE');
129: fnd_message.set_token('RSNAME',p_req_set_name);

Line 128: fnd_message.set_name('BIS','BIS_RSG_RS_NO_REF_MODE');

124: fnd_message.set_token('RSNAME',p_req_set_name);
125: errbuf := FND_MESSAGE.GET;
126: errcode := 'BIS_RSG_NO_RSDATA_FOUND';
127: elsif l_value is null then
128: fnd_message.set_name('BIS','BIS_RSG_RS_NO_REF_MODE');
129: fnd_message.set_token('RSNAME',p_req_set_name);
130: errbuf := FND_MESSAGE.GET;
131: errcode := 'BIS_RSG_RS_NO_REF_MODE';
132: else

Line 129: fnd_message.set_token('RSNAME',p_req_set_name);

125: errbuf := FND_MESSAGE.GET;
126: errcode := 'BIS_RSG_NO_RSDATA_FOUND';
127: elsif l_value is null then
128: fnd_message.set_name('BIS','BIS_RSG_RS_NO_REF_MODE');
129: fnd_message.set_token('RSNAME',p_req_set_name);
130: errbuf := FND_MESSAGE.GET;
131: errcode := 'BIS_RSG_RS_NO_REF_MODE';
132: else
133: fnd_message.set_name('BIS','BIS_RSG_SUCCESS');

Line 130: errbuf := FND_MESSAGE.GET;

126: errcode := 'BIS_RSG_NO_RSDATA_FOUND';
127: elsif l_value is null then
128: fnd_message.set_name('BIS','BIS_RSG_RS_NO_REF_MODE');
129: fnd_message.set_token('RSNAME',p_req_set_name);
130: errbuf := FND_MESSAGE.GET;
131: errcode := 'BIS_RSG_RS_NO_REF_MODE';
132: else
133: fnd_message.set_name('BIS','BIS_RSG_SUCCESS');
134: errbuf := FND_MESSAGE.GET;

Line 133: fnd_message.set_name('BIS','BIS_RSG_SUCCESS');

129: fnd_message.set_token('RSNAME',p_req_set_name);
130: errbuf := FND_MESSAGE.GET;
131: errcode := 'BIS_RSG_RS_NO_REF_MODE';
132: else
133: fnd_message.set_name('BIS','BIS_RSG_SUCCESS');
134: errbuf := FND_MESSAGE.GET;
135: errcode := 'BIS_RSG_SUCCESS';
136: END IF;
137: close cv;

Line 134: errbuf := FND_MESSAGE.GET;

130: errbuf := FND_MESSAGE.GET;
131: errcode := 'BIS_RSG_RS_NO_REF_MODE';
132: else
133: fnd_message.set_name('BIS','BIS_RSG_SUCCESS');
134: errbuf := FND_MESSAGE.GET;
135: errcode := 'BIS_RSG_SUCCESS';
136: END IF;
137: close cv;
138: return l_value;

Line 200: fnd_message.set_name('BIS','BIS_RSG_NO_CONTENT_FOUND');

196: End loop;
197: end if;
198:
199: if(i=0 and p_content_type is null) THEN
200: fnd_message.set_name('BIS','BIS_RSG_NO_CONTENT_FOUND');
201: fnd_message.set_token('RSNAME',p_req_set_name);
202: errbuf := FND_MESSAGE.GET;
203: errcode := 'BIS_RSG_NO_CONTENT_FOUND';
204: elsif(i=0 and p_content_type ='REPORT') THEN

Line 201: fnd_message.set_token('RSNAME',p_req_set_name);

197: end if;
198:
199: if(i=0 and p_content_type is null) THEN
200: fnd_message.set_name('BIS','BIS_RSG_NO_CONTENT_FOUND');
201: fnd_message.set_token('RSNAME',p_req_set_name);
202: errbuf := FND_MESSAGE.GET;
203: errcode := 'BIS_RSG_NO_CONTENT_FOUND';
204: elsif(i=0 and p_content_type ='REPORT') THEN
205: fnd_message.set_name('BIS','BIS_RSG_NO_REPORT_FOUND');

Line 202: errbuf := FND_MESSAGE.GET;

198:
199: if(i=0 and p_content_type is null) THEN
200: fnd_message.set_name('BIS','BIS_RSG_NO_CONTENT_FOUND');
201: fnd_message.set_token('RSNAME',p_req_set_name);
202: errbuf := FND_MESSAGE.GET;
203: errcode := 'BIS_RSG_NO_CONTENT_FOUND';
204: elsif(i=0 and p_content_type ='REPORT') THEN
205: fnd_message.set_name('BIS','BIS_RSG_NO_REPORT_FOUND');
206: fnd_message.set_token('RSNAME',p_req_set_name);

Line 205: fnd_message.set_name('BIS','BIS_RSG_NO_REPORT_FOUND');

201: fnd_message.set_token('RSNAME',p_req_set_name);
202: errbuf := FND_MESSAGE.GET;
203: errcode := 'BIS_RSG_NO_CONTENT_FOUND';
204: elsif(i=0 and p_content_type ='REPORT') THEN
205: fnd_message.set_name('BIS','BIS_RSG_NO_REPORT_FOUND');
206: fnd_message.set_token('RSNAME',p_req_set_name);
207: errbuf := FND_MESSAGE.GET;
208: errcode := 'BIS_RSG_NO_REPORT_FOUND';
209: elsif(i=0 and p_content_type ='PAGE') THEN

Line 206: fnd_message.set_token('RSNAME',p_req_set_name);

202: errbuf := FND_MESSAGE.GET;
203: errcode := 'BIS_RSG_NO_CONTENT_FOUND';
204: elsif(i=0 and p_content_type ='REPORT') THEN
205: fnd_message.set_name('BIS','BIS_RSG_NO_REPORT_FOUND');
206: fnd_message.set_token('RSNAME',p_req_set_name);
207: errbuf := FND_MESSAGE.GET;
208: errcode := 'BIS_RSG_NO_REPORT_FOUND';
209: elsif(i=0 and p_content_type ='PAGE') THEN
210: fnd_message.set_name('BIS','BIS_RSG_NO_PAGE_FOUND');

Line 207: errbuf := FND_MESSAGE.GET;

203: errcode := 'BIS_RSG_NO_CONTENT_FOUND';
204: elsif(i=0 and p_content_type ='REPORT') THEN
205: fnd_message.set_name('BIS','BIS_RSG_NO_REPORT_FOUND');
206: fnd_message.set_token('RSNAME',p_req_set_name);
207: errbuf := FND_MESSAGE.GET;
208: errcode := 'BIS_RSG_NO_REPORT_FOUND';
209: elsif(i=0 and p_content_type ='PAGE') THEN
210: fnd_message.set_name('BIS','BIS_RSG_NO_PAGE_FOUND');
211: fnd_message.set_token('RSNAME',p_req_set_name);

Line 210: fnd_message.set_name('BIS','BIS_RSG_NO_PAGE_FOUND');

206: fnd_message.set_token('RSNAME',p_req_set_name);
207: errbuf := FND_MESSAGE.GET;
208: errcode := 'BIS_RSG_NO_REPORT_FOUND';
209: elsif(i=0 and p_content_type ='PAGE') THEN
210: fnd_message.set_name('BIS','BIS_RSG_NO_PAGE_FOUND');
211: fnd_message.set_token('RSNAME',p_req_set_name);
212: errbuf := FND_MESSAGE.GET;
213: errcode := 'BIS_RSG_NO_PAGE_FOUND';
214: else

Line 211: fnd_message.set_token('RSNAME',p_req_set_name);

207: errbuf := FND_MESSAGE.GET;
208: errcode := 'BIS_RSG_NO_REPORT_FOUND';
209: elsif(i=0 and p_content_type ='PAGE') THEN
210: fnd_message.set_name('BIS','BIS_RSG_NO_PAGE_FOUND');
211: fnd_message.set_token('RSNAME',p_req_set_name);
212: errbuf := FND_MESSAGE.GET;
213: errcode := 'BIS_RSG_NO_PAGE_FOUND';
214: else
215: fnd_message.set_name('BIS','BIS_RSG_SUCCESS');

Line 212: errbuf := FND_MESSAGE.GET;

208: errcode := 'BIS_RSG_NO_REPORT_FOUND';
209: elsif(i=0 and p_content_type ='PAGE') THEN
210: fnd_message.set_name('BIS','BIS_RSG_NO_PAGE_FOUND');
211: fnd_message.set_token('RSNAME',p_req_set_name);
212: errbuf := FND_MESSAGE.GET;
213: errcode := 'BIS_RSG_NO_PAGE_FOUND';
214: else
215: fnd_message.set_name('BIS','BIS_RSG_SUCCESS');
216: errbuf := FND_MESSAGE.GET;

Line 215: fnd_message.set_name('BIS','BIS_RSG_SUCCESS');

211: fnd_message.set_token('RSNAME',p_req_set_name);
212: errbuf := FND_MESSAGE.GET;
213: errcode := 'BIS_RSG_NO_PAGE_FOUND';
214: else
215: fnd_message.set_name('BIS','BIS_RSG_SUCCESS');
216: errbuf := FND_MESSAGE.GET;
217: errcode := 'BIS_RSG_SUCCESS';
218: end if;
219: EXCEPTION

Line 216: errbuf := FND_MESSAGE.GET;

212: errbuf := FND_MESSAGE.GET;
213: errcode := 'BIS_RSG_NO_PAGE_FOUND';
214: else
215: fnd_message.set_name('BIS','BIS_RSG_SUCCESS');
216: errbuf := FND_MESSAGE.GET;
217: errcode := 'BIS_RSG_SUCCESS';
218: end if;
219: EXCEPTION
220: WHEN OTHERS THEN