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.

[Home] [Help]

APPS.BIS_PMV_PAGE_PARAMS_PUB dependencies on FND_API

Line 58: x_return_status := FND_API.G_RET_STS_SUCCESS;

54: l_index1 number;
55: l_index2 number;
56:
57: BEGIN
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59: -- We need to comment the part about icx_sec.validateSession since it is going to fail anyway.
60: /*if (p_Session_id is null) then
61: if (not icx_sec.validateSession) then
62: null;

Line 142: WHEN FND_API.G_EXC_ERROR THEN

138: end if;
139: end if; --end of l_asOfDate_parameter is not null
140: end if;
141: EXCEPTION
142: WHEN FND_API.G_EXC_ERROR THEN
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
145: x_msg_data);
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 143: x_return_status := FND_API.G_RET_STS_ERROR;

139: end if; --end of l_asOfDate_parameter is not null
140: end if;
141: EXCEPTION
142: WHEN FND_API.G_EXC_ERROR THEN
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
145: x_msg_data);
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

142: WHEN FND_API.G_EXC_ERROR THEN
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
145: x_msg_data);
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
149: x_msg_data);
150: WHEN OTHERS THEN

Line 147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

143: x_return_status := FND_API.G_RET_STS_ERROR;
144: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
145: x_msg_data);
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
149: x_msg_data);
150: WHEN OTHERS THEN
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
149: x_msg_data);
150: WHEN OTHERS THEN
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
153: x_msg_data);
154: END;
155:

Line 175: x_return_status := FND_API.G_RET_STS_SUCCESS;

171: ORDER BY bua.attribute_name;
172:
173: l_param_string varchar2(32767);
174: BEGIN
175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176: FOR c_rec IN c_paramString LOOP
177: if ( l_param_string is null ) then
178: l_param_string := 'dbiParameters%3DY';
179: end if;

Line 186: WHEN FND_API.G_EXC_ERROR THEN

182: l_param_string := l_param_string || wfa_html.conv_special_url_chars(c_Rec.session_description);
183: END LOOP;
184: x_param_string := l_param_string;
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
189: x_msg_data);
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 187: x_return_status := FND_API.G_RET_STS_ERROR;

183: END LOOP;
184: x_param_string := l_param_string;
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
189: x_msg_data);
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

186: WHEN FND_API.G_EXC_ERROR THEN
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
189: x_msg_data);
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
193: x_msg_data);
194: WHEN OTHERS THEN

Line 191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
189: x_msg_data);
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
193: x_msg_data);
194: WHEN OTHERS THEN
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
193: x_msg_data);
194: WHEN OTHERS THEN
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
197: x_msg_data);
198: END;
199: PROCEDURE RETRIEVE_PARAMSTR_BYUSERID

Line 217: x_return_status := FND_API.G_RET_STS_SUCCESS;

213: ORDER BY bua.attribute_name;
214:
215: l_param_string varchar2(32767);
216: BEGIN
217: x_return_status := FND_API.G_RET_STS_SUCCESS;
218: FOR c_rec IN c_paramString LOOP
219: if ( l_param_string is null ) then
220: l_param_string := 'dbiParameters=Y';
221: end if;

Line 228: WHEN FND_API.G_EXC_ERROR THEN

224: l_param_string := l_param_string || wfa_html.conv_special_url_chars(c_Rec.session_description);
225: END LOOP;
226: x_param_string := l_param_string;
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
231: x_msg_data);
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225: END LOOP;
226: x_param_string := l_param_string;
227: EXCEPTION
228: WHEN FND_API.G_EXC_ERROR THEN
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
231: x_msg_data);
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

228: WHEN FND_API.G_EXC_ERROR THEN
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
231: x_msg_data);
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
235: x_msg_data);
236: WHEN OTHERS THEN

Line 233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

229: x_return_status := FND_API.G_RET_STS_ERROR;
230: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
231: x_msg_data);
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
235: x_msg_data);
236: WHEN OTHERS THEN
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
235: x_msg_data);
236: WHEN OTHERS THEN
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data =>
239: x_msg_data);
240: END;
241:

Line 354: WHEN FND_API.G_EXC_ERROR THEN

350: END IF;
351: END IF; -- not related link
352:
353: EXCEPTION
354: WHEN FND_API.G_EXC_ERROR THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
357: p_data =>x_msg_data);
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 355: x_return_status := FND_API.G_RET_STS_ERROR;

351: END IF; -- not related link
352:
353: EXCEPTION
354: WHEN FND_API.G_EXC_ERROR THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
357: p_data =>x_msg_data);
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

354: WHEN FND_API.G_EXC_ERROR THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
357: p_data =>x_msg_data);
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
361: p_data =>x_msg_data);
362: WHEN OTHERS THEN

Line 359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

355: x_return_status := FND_API.G_RET_STS_ERROR;
356: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
357: p_data =>x_msg_data);
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
361: p_data =>x_msg_data);
362: WHEN OTHERS THEN
363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
361: p_data =>x_msg_data);
362: WHEN OTHERS THEN
363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
364: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
365: p_data => x_msg_data);
366:
367: