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_PMV_PORTAL_UTIL_PUB dependencies on FND_API

Line 117: x_return_Status := FND_API.G_RET_STS_SUCCESS;

113: lDimensionGroup VARCHAR2(150);
114:
115: BEGIN
116:
117: x_return_Status := FND_API.G_RET_STS_SUCCESS;
118:
119: --First get the function_name for this pagE_id
120: IF (c_func%ISOPEN ) THEN
121: CLOSE c_func;

Line 145: WHEN FND_API.G_EXC_ERROR THEN

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

Line 146: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 214: WHEN FND_API.G_EXC_ERROR THEN

210: CLOSE c_time;
211: l_time_level_label := UPPER(BIS_PMV_QUERY_PVT.getParameterAcronym('BIS_TIME_LEVEL_VALUES', l_time_param_name));
212: x_time_level_label := l_time_level_label;
213: EXCEPTION
214: WHEN FND_API.G_EXC_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 215: x_return_status := FND_API.G_RET_STS_ERROR;

211: l_time_level_label := UPPER(BIS_PMV_QUERY_PVT.getParameterAcronym('BIS_TIME_LEVEL_VALUES', l_time_param_name));
212: x_time_level_label := l_time_level_label;
213: EXCEPTION
214: WHEN FND_API.G_EXC_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

213: EXCEPTION
214: WHEN FND_API.G_EXC_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
220: WHEN OTHERS THEN
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

214: WHEN FND_API.G_EXC_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
220: WHEN OTHERS THEN
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
220: WHEN OTHERS THEN
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
223: END;
224:
225: -- added user_id for bug 4752246

Line 256: WHEN FND_API.G_EXC_ERROR THEN

252: CLOSE c_time;
253: l_time_level_label := UPPER(BIS_PMV_QUERY_PVT.getParameterAcronym('BIS_TIME_LEVEL_VALUES', l_time_param_name));
254: x_time_level_label := l_time_level_label;
255: EXCEPTION
256: WHEN FND_API.G_EXC_ERROR THEN
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 257: x_return_status := FND_API.G_RET_STS_ERROR;

253: l_time_level_label := UPPER(BIS_PMV_QUERY_PVT.getParameterAcronym('BIS_TIME_LEVEL_VALUES', l_time_param_name));
254: x_time_level_label := l_time_level_label;
255: EXCEPTION
256: WHEN FND_API.G_EXC_ERROR THEN
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

255: EXCEPTION
256: WHEN FND_API.G_EXC_ERROR THEN
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

256: WHEN FND_API.G_EXC_ERROR THEN
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
265: END GET_TIME_LABEL_FROM_SESSION;
266:
267:

Line 300: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

296: ,x_msg_count => l_msg_count
297: ,x_msg_data => l_msg_data
298: );
299: END IF;
300: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
301: lLabel := '';
302: END IF;
303:
304: RETURN lLabel ;

Line 387: x_return_status := FND_API.G_RET_STS_SUCCESS;

383: FETCH c_RnkLvlShrtName INTO x_rank_level_shrt_name;
384: CLOSE c_RnkLvlShrtName;
385: END IF;
386:
387: x_return_status := FND_API.G_RET_STS_SUCCESS;
388:
389: EXCEPTION
390:
391: WHEN FND_API.G_EXC_ERROR THEN

Line 391: WHEN FND_API.G_EXC_ERROR THEN

387: x_return_status := FND_API.G_RET_STS_SUCCESS;
388:
389: EXCEPTION
390:
391: WHEN FND_API.G_EXC_ERROR THEN
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 392: x_return_status := FND_API.G_RET_STS_ERROR;

388:
389: EXCEPTION
390:
391: WHEN FND_API.G_EXC_ERROR THEN
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

390:
391: WHEN FND_API.G_EXC_ERROR THEN
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
397: WHEN OTHERS THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

391: WHEN FND_API.G_EXC_ERROR THEN
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
397: WHEN OTHERS THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
397: WHEN OTHERS THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
400:
401: END GET_RANK_LEVEL_SHRT_NAME;
402:

Line 443: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

439: ,x_return_Status => x_return_status
440: ,x_msg_count => x_msg_count
441: ,x_msg_data => x_msg_data
442: );
443: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
444: RETURN;
445: END IF;
446: /* PMF team no longer needs the number of values for that dimension level . Commenting this code
447: out

Line 463: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

459: ,x_return_status => l_return_status
460: ,x_msg_count => l_msg_count
461: ,x_msg_data => l_msg_data );
462:
463: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
464: RETURN;
465: END IF;
466:
467: -- replace with all so that the query picks up all the values,

Line 501: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

497: ,x_msg_count => l_msg_count
498: ,x_msg_data => l_msg_data);
499: END IF;
500:
501: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
502: RETURN;
503: END IF;
504:
505: BIS_PMV_QUERY_PVT.substitute_lov_where (

Line 515: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

511: x_msg_count => l_msg_count,
512: x_msg_data => l_msg_data
513: ) ;
514:
515: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
516: RETURN;
517: END IF;
518:
519: -- remove the order by from the lov_sql_stmt and append the lov where to it

Line 527: WHEN FND_API.G_EXC_ERROR THEN

523: -- run the sql and obtain the count
524: execute immediate 'SELECT count(*) FROM ('||v_lov_sql_stmt||') ' INTO x_number_values;*/
525: EXCEPTION
526:
527: WHEN FND_API.G_EXC_ERROR THEN
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 528: x_return_status := FND_API.G_RET_STS_ERROR;

524: execute immediate 'SELECT count(*) FROM ('||v_lov_sql_stmt||') ' INTO x_number_values;*/
525: EXCEPTION
526:
527: WHEN FND_API.G_EXC_ERROR THEN
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

526:
527: WHEN FND_API.G_EXC_ERROR THEN
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
533: WHEN OTHERS THEN
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

527: WHEN FND_API.G_EXC_ERROR THEN
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
533: WHEN OTHERS THEN
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
533: WHEN OTHERS THEN
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
536:
537: END get_rank_level_and_num_values;
538:

Line 565: WHEN FND_API.G_EXC_ERROR THEN

561: );
562:
563:
564: EXCEPTION
565: WHEN FND_API.G_EXC_ERROR THEN
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
568:
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 566: x_return_status := FND_API.G_RET_STS_ERROR;

562:
563:
564: EXCEPTION
565: WHEN FND_API.G_EXC_ERROR THEN
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
568:
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

565: WHEN FND_API.G_EXC_ERROR THEN
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
568:
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
572: WHEN OTHERS THEN
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

566: x_return_status := FND_API.G_RET_STS_ERROR;
567: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
568:
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
572: WHEN OTHERS THEN
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data) ;
572: WHEN OTHERS THEN
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
575:
576: END clean_portlets ;
577: