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.BSC_PORTLET_UI_WRAPPER dependencies on FND_API

Line 146: WHEN FND_API.G_EXC_ERROR THEN

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

Line 148: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 158: x_return_status := FND_API.G_RET_STS_ERROR;

154: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
155: ,p_data => x_msg_data);
156: WHEN NO_DATA_FOUND THEN
157: rollback;
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
160: ,p_data => x_msg_data);
161: WHEN OTHERS THEN
162: rollback;

Line 163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

159: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
160: ,p_data => x_msg_data);
161: WHEN OTHERS THEN
162: rollback;
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
165: ,p_data => x_msg_data);
166:
167: END Get_Page_Params;

Line 195: WHEN FND_API.G_EXC_ERROR THEN

191: ,x_msg_data => x_msg_data
192: );
193:
194: EXCEPTION
195: WHEN FND_API.G_EXC_ERROR THEN
196: rollback;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
199: ,p_data => x_msg_data);

Line 197: x_return_status := FND_API.G_RET_STS_ERROR;

193:
194: EXCEPTION
195: WHEN FND_API.G_EXC_ERROR THEN
196: rollback;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
199: ,p_data => x_msg_data);
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: rollback;

Line 200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

196: rollback;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
199: ,p_data => x_msg_data);
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: rollback;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
204: ,p_data => x_msg_data);

Line 202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

198: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
199: ,p_data => x_msg_data);
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: rollback;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
204: ,p_data => x_msg_data);
205: WHEN NO_DATA_FOUND THEN
206: rollback;

Line 207: x_return_status := FND_API.G_RET_STS_ERROR;

203: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
204: ,p_data => x_msg_data);
205: WHEN NO_DATA_FOUND THEN
206: rollback;
207: x_return_status := FND_API.G_RET_STS_ERROR;
208: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
209: ,p_data => x_msg_data);
210: WHEN OTHERS THEN
211: rollback;

Line 212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

208: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
209: ,p_data => x_msg_data);
210: WHEN OTHERS THEN
211: rollback;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
214: ,p_data => x_msg_data);
215:
216: END Get_Ranking_Parameter;

Line 276: WHEN FND_API.G_EXC_ERROR THEN

272: END IF; */
273:
274:
275: EXCEPTION
276: WHEN FND_API.G_EXC_ERROR THEN
277: rollback;
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
280: ,p_data => x_msg_data);

Line 278: x_return_status := FND_API.G_RET_STS_ERROR;

274:
275: EXCEPTION
276: WHEN FND_API.G_EXC_ERROR THEN
277: rollback;
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
280: ,p_data => x_msg_data);
281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
282: rollback;

Line 281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

277: rollback;
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
280: ,p_data => x_msg_data);
281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
282: rollback;
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
285: ,p_data => x_msg_data);

Line 283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

279: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
280: ,p_data => x_msg_data);
281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
282: rollback;
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
285: ,p_data => x_msg_data);
286: WHEN NO_DATA_FOUND THEN
287: rollback;

Line 288: x_return_status := FND_API.G_RET_STS_ERROR;

284: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
285: ,p_data => x_msg_data);
286: WHEN NO_DATA_FOUND THEN
287: rollback;
288: x_return_status := FND_API.G_RET_STS_ERROR;
289: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
290: ,p_data => x_msg_data);
291: WHEN OTHERS THEN
292: rollback;

Line 293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

289: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
290: ,p_data => x_msg_data);
291: WHEN OTHERS THEN
292: rollback;
293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
294: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
295: ,p_data => x_msg_data);
296: END Validate_Responsibility;
297:

Line 411: RAISE FND_API.G_EXC_ERROR;

407: IF p_user_id IS NULL OR p_reference_path IS NULL OR p_resp_id IS NULL OR
408: p_tab_id IS NULL OR p_view_id IS NULL OR p_portlet_name IS NULL THEN
409: FND_MESSAGE.SET_NAME('BSC','BSC_CV_POR_CUST_INVALID_PARAMS');
410: FND_MSG_PUB.ADD;
411: RAISE FND_API.G_EXC_ERROR;
412: END IF;
413:
414: -- Get the plug_id. We need to continue using it because
415: -- it is part of the key of the table.

Line 489: WHEN FND_API.G_EXC_ERROR THEN

485:
486: COMMIT;
487:
488: EXCEPTION
489: WHEN FND_API.G_EXC_ERROR THEN
490: rollback;
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
493: ,p_data => x_msg_data);

Line 491: x_return_status := FND_API.G_RET_STS_ERROR;

487:
488: EXCEPTION
489: WHEN FND_API.G_EXC_ERROR THEN
490: rollback;
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
493: ,p_data => x_msg_data);
494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
495: rollback;

Line 494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

490: rollback;
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
493: ,p_data => x_msg_data);
494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
495: rollback;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
498: ,p_data => x_msg_data);

Line 496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

492: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
493: ,p_data => x_msg_data);
494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
495: rollback;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
498: ,p_data => x_msg_data);
499: WHEN NO_DATA_FOUND THEN
500: rollback;

Line 501: x_return_status := FND_API.G_RET_STS_ERROR;

497: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
498: ,p_data => x_msg_data);
499: WHEN NO_DATA_FOUND THEN
500: rollback;
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
503: ,p_data => x_msg_data);
504: WHEN OTHERS THEN
505: rollback;

Line 506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

502: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
503: ,p_data => x_msg_data);
504: WHEN OTHERS THEN
505: rollback;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
508: ,p_data => x_msg_data);
509: END Apply_CustomView_Parameters;
510:

Line 549: RAISE FND_API.G_EXC_ERROR;

545: IF p_user_id IS NULL OR p_reference_path IS NULL OR p_resp_id IS NULL OR
546: p_tab_id IS NULL OR p_kpi_code IS NULL OR p_portlet_name IS NULL THEN
547: FND_MESSAGE.SET_NAME('BSC','BSC_CV_POR_CUST_INVALID_PARAMS');
548: FND_MSG_PUB.ADD;
549: RAISE FND_API.G_EXC_ERROR;
550: END IF;
551:
552: -- Get the plug_id. We need to continue using it because
553: -- it is part of the key of the table.

Line 633: WHEN FND_API.G_EXC_ERROR THEN

629:
630: COMMIT;
631:
632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: rollback;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
637: ,p_data => x_msg_data);

Line 635: x_return_status := FND_API.G_RET_STS_ERROR;

631:
632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: rollback;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
637: ,p_data => x_msg_data);
638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
639: rollback;

Line 638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

634: rollback;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
637: ,p_data => x_msg_data);
638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
639: rollback;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
642: ,p_data => x_msg_data);

Line 640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

636: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
637: ,p_data => x_msg_data);
638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
639: rollback;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
642: ,p_data => x_msg_data);
643: WHEN NO_DATA_FOUND THEN
644: rollback;

Line 645: x_return_status := FND_API.G_RET_STS_ERROR;

641: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
642: ,p_data => x_msg_data);
643: WHEN NO_DATA_FOUND THEN
644: rollback;
645: x_return_status := FND_API.G_RET_STS_ERROR;
646: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
647: ,p_data => x_msg_data);
648: WHEN OTHERS THEN
649: rollback;

Line 650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

646: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
647: ,p_data => x_msg_data);
648: WHEN OTHERS THEN
649: rollback;
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
652: ,p_data => x_msg_data);
653: END Apply_Graph_Parameters;
654:

Line 700: RAISE FND_API.G_EXC_ERROR;

696: p_details_flag IS NULL OR p_group_flag IS NULL OR p_porlet_name IS NULL OR p_number_array IS NULL
697: THEN
698: FND_MESSAGE.SET_NAME('BSC','BSC_CV_POR_CUST_INVALID_PARAMS');
699: FND_MSG_PUB.ADD;
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702:
703: -- Get the plug_id. We need to continue using it because
704: -- it is part of the key of the table.

Line 730: WHEN FND_API.G_EXC_ERROR THEN

726:
727: COMMIT;
728:
729: EXCEPTION
730: WHEN FND_API.G_EXC_ERROR THEN
731: rollback;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
734: ,p_data => x_msg_data);

Line 732: x_return_status := FND_API.G_RET_STS_ERROR;

728:
729: EXCEPTION
730: WHEN FND_API.G_EXC_ERROR THEN
731: rollback;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
734: ,p_data => x_msg_data);
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
736: rollback;

Line 735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

731: rollback;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
734: ,p_data => x_msg_data);
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
736: rollback;
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
739: ,p_data => x_msg_data);

Line 737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

733: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
734: ,p_data => x_msg_data);
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
736: rollback;
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
739: ,p_data => x_msg_data);
740: WHEN NO_DATA_FOUND THEN
741: rollback;

Line 742: x_return_status := FND_API.G_RET_STS_ERROR;

738: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
739: ,p_data => x_msg_data);
740: WHEN NO_DATA_FOUND THEN
741: rollback;
742: x_return_status := FND_API.G_RET_STS_ERROR;
743: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
744: ,p_data => x_msg_data);
745: WHEN OTHERS THEN
746: rollback;

Line 747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

743: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
744: ,p_data => x_msg_data);
745: WHEN OTHERS THEN
746: rollback;
747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
748: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
749: ,p_data => x_msg_data);
750: END Apply_Kpi_List_Parameters;
751:

Line 774: l_commit := FND_API.G_FALSE;

770: BEGIN
771:
772:
773: IF(p_commit IS NULL ) THEN
774: l_commit := FND_API.G_FALSE;
775: ELSE
776: l_commit := p_commit;
777: END IF;
778:

Line 826: IF(l_commit = FND_API.G_TRUE) THEN

822: UPDATE icx_portlet_customizations
823: SET caching_key = to_char(to_number(NVL(caching_key, 0))+1)
824: WHERE reference_path = p_reference_path;
825:
826: IF(l_commit = FND_API.G_TRUE) THEN
827: COMMIT;
828: END IF;
829:
830: END IF;

Line 836: x_return_status := FND_API.G_RET_STS_ERROR;

832:
833: EXCEPTION
834: WHEN NO_DATA_FOUND THEN
835: rollback;
836: x_return_status := FND_API.G_RET_STS_ERROR;
837:
838: WHEN OTHERS THEN
839: rollback;
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

836: x_return_status := FND_API.G_RET_STS_ERROR;
837:
838: WHEN OTHERS THEN
839: rollback;
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841:
842: END checkUpdateCustView;
843: /************************************************************************************
844: ************************************************************************************/