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

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84: l_size NUMBER := 100000;
85: l_retrieved NUMBER;
86: --
87: BEGIN
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89: --
90: SELECT
91: DIMENSION_LEVEL_SHORT_NAME
92: , DIMENSION_LEVEL_NAME

Line 198: x_return_status := FND_API.G_RET_STS_ERROR;

194: WHEN NO_DATA_FOUND THEN
195: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
196: DBMS_SQL.CLOSE_CURSOR(l_cursor);
197: END IF;
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
200: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:NO_DATA_FOUND'); htp.para;
201: END IF;
202: RAISE FND_API.G_EXC_ERROR;

Line 202: RAISE FND_API.G_EXC_ERROR;

198: x_return_status := FND_API.G_RET_STS_ERROR;
199: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
200: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:NO_DATA_FOUND'); htp.para;
201: END IF;
202: RAISE FND_API.G_EXC_ERROR;
203: WHEN FND_API.G_EXC_ERROR THEN
204: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
205: DBMS_SQL.CLOSE_CURSOR(l_cursor);
206: END IF;

Line 203: WHEN FND_API.G_EXC_ERROR THEN

199: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
200: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:NO_DATA_FOUND'); htp.para;
201: END IF;
202: RAISE FND_API.G_EXC_ERROR;
203: WHEN FND_API.G_EXC_ERROR THEN
204: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
205: DBMS_SQL.CLOSE_CURSOR(l_cursor);
206: END IF;
207: x_return_status := FND_API.G_RET_STS_ERROR;

Line 207: x_return_status := FND_API.G_RET_STS_ERROR;

203: WHEN FND_API.G_EXC_ERROR THEN
204: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
205: DBMS_SQL.CLOSE_CURSOR(l_cursor);
206: END IF;
207: x_return_status := FND_API.G_RET_STS_ERROR;
208: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
209: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_ERROR'); htp.para;
210: END IF;
211: RAISE;

Line 212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

208: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
209: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_ERROR'); htp.para;
210: END IF;
211: RAISE;
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
214: DBMS_SQL.CLOSE_CURSOR(l_cursor);
215: END IF;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
214: DBMS_SQL.CLOSE_CURSOR(l_cursor);
215: END IF;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
218: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;
219: END IF;
220: RAISE;

Line 225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

221: WHEN OTHERS THEN
222: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
223: DBMS_SQL.CLOSE_CURSOR(l_cursor);
224: END IF;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: BIS_UTILITIES_PVT.Add_Error_Message
227: ( p_error_table => x_error_Tbl
228: , p_error_msg_id => SQLCODE
229: , p_error_description => SQLERRM

Line 235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

231: );
232: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
233: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:OTHERS'); htp.para;
234: END IF;
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: --
237: END Get_Org_Dim_Values;
238: --
239: --

Line 266: x_return_status := FND_API.G_RET_STS_SUCCESS;

262: l_size NUMBER := 100000;
263: l_retrieved NUMBER;
264: --
265: BEGIN
266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267: --
268: SELECT
269: DIMENSION_LEVEL_SHORT_NAME
270: , DIMENSION_LEVEL_NAME

Line 355: x_return_status := FND_API.G_RET_STS_ERROR;

351: WHEN NO_DATA_FOUND THEN
352: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
353: DBMS_SQL.CLOSE_CURSOR(l_cursor);
354: END IF;
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
357: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:NO_DATA_FOUND'); htp.para;
358: END IF;
359: RAISE FND_API.G_EXC_ERROR;

Line 359: RAISE FND_API.G_EXC_ERROR;

355: x_return_status := FND_API.G_RET_STS_ERROR;
356: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
357: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:NO_DATA_FOUND'); htp.para;
358: END IF;
359: RAISE FND_API.G_EXC_ERROR;
360: WHEN FND_API.G_EXC_ERROR THEN
361: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
362: DBMS_SQL.CLOSE_CURSOR(l_cursor);
363: END IF;

Line 360: WHEN FND_API.G_EXC_ERROR THEN

356: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
357: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:NO_DATA_FOUND'); htp.para;
358: END IF;
359: RAISE FND_API.G_EXC_ERROR;
360: WHEN FND_API.G_EXC_ERROR THEN
361: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
362: DBMS_SQL.CLOSE_CURSOR(l_cursor);
363: END IF;
364: x_return_status := FND_API.G_RET_STS_ERROR;

Line 364: x_return_status := FND_API.G_RET_STS_ERROR;

360: WHEN FND_API.G_EXC_ERROR THEN
361: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
362: DBMS_SQL.CLOSE_CURSOR(l_cursor);
363: END IF;
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
366: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_ERROR'); htp.para;
367: END IF;
368: RAISE;

Line 369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

365: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
366: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_ERROR'); htp.para;
367: END IF;
368: RAISE;
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
371: DBMS_SQL.CLOSE_CURSOR(l_cursor);
372: END IF;
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
371: DBMS_SQL.CLOSE_CURSOR(l_cursor);
372: END IF;
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
375: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;
376: END IF;
377: RAISE;

Line 382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

378: WHEN OTHERS THEN
379: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
380: DBMS_SQL.CLOSE_CURSOR(l_cursor);
381: END IF;
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: BIS_UTILITIES_PVT.Add_Error_Message
384: ( p_error_table => x_error_Tbl
385: , p_error_msg_id => SQLCODE
386: , p_error_description => SQLERRM

Line 392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

388: );
389: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
390: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:OTHERS'); htp.para;
391: END IF;
392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
393: --
394: END Get_Org_Dim_Values;
395: --
396: --

Line 422: x_return_status := FND_API.G_RET_STS_SUCCESS;

418: l_size NUMBER := 100000;
419: l_retrieved NUMBER;
420: --
421: BEGIN
422: x_return_status := FND_API.G_RET_STS_SUCCESS;
423: --
424: SELECT
425: DIMENSION_LEVEL_SHORT_NAME
426: , DIMENSION_LEVEL_NAME

Line 496: x_return_status := FND_API.G_RET_STS_ERROR;

492: WHEN NO_DATA_FOUND THEN
493: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
494: DBMS_SQL.CLOSE_CURSOR(l_cursor);
495: END IF;
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
498: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:NO_DATA_FOUND'); htp.para;
499: END IF;
500: RAISE FND_API.G_EXC_ERROR;

Line 500: RAISE FND_API.G_EXC_ERROR;

496: x_return_status := FND_API.G_RET_STS_ERROR;
497: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
498: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:NO_DATA_FOUND'); htp.para;
499: END IF;
500: RAISE FND_API.G_EXC_ERROR;
501: WHEN FND_API.G_EXC_ERROR THEN
502: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
503: DBMS_SQL.CLOSE_CURSOR(l_cursor);
504: END IF;

Line 501: WHEN FND_API.G_EXC_ERROR THEN

497: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
498: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:NO_DATA_FOUND'); htp.para;
499: END IF;
500: RAISE FND_API.G_EXC_ERROR;
501: WHEN FND_API.G_EXC_ERROR THEN
502: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
503: DBMS_SQL.CLOSE_CURSOR(l_cursor);
504: END IF;
505: x_return_status := FND_API.G_RET_STS_ERROR;

Line 505: x_return_status := FND_API.G_RET_STS_ERROR;

501: WHEN FND_API.G_EXC_ERROR THEN
502: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
503: DBMS_SQL.CLOSE_CURSOR(l_cursor);
504: END IF;
505: x_return_status := FND_API.G_RET_STS_ERROR;
506: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
507: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_ERROR'); htp.para;
508: END IF;
509: RAISE;

Line 510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

506: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
507: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_ERROR'); htp.para;
508: END IF;
509: RAISE;
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
512: DBMS_SQL.CLOSE_CURSOR(l_cursor);
513: END IF;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
512: DBMS_SQL.CLOSE_CURSOR(l_cursor);
513: END IF;
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
516: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;
517: END IF;
518: RAISE;

Line 523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

519: WHEN OTHERS THEN
520: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
521: DBMS_SQL.CLOSE_CURSOR(l_cursor);
522: END IF;
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: BIS_UTILITIES_PVT.Add_Error_Message
525: ( p_error_table => x_error_Tbl
526: , p_error_msg_id => SQLCODE
527: , p_error_description => SQLERRM

Line 533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

529: );
530: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
531: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Org_Dim_Values:OTHERS'); htp.para;
532: END IF;
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: END Get_Org_Dim_Values;
535: --
536: --
537: PROCEDURE Get_DimensionX_Values

Line 562: x_return_status := FND_API.G_RET_STS_SUCCESS;

558: l_size NUMBER := 100000;
559: l_retrieved NUMBER;
560: --
561: BEGIN
562: x_return_status := FND_API.G_RET_STS_SUCCESS;
563: --
564: SELECT
565: DIMENSION_LEVEL_SHORT_NAME
566: , DIMENSION_LEVEL_NAME

Line 638: x_return_status := FND_API.G_RET_STS_ERROR;

634: WHEN NO_DATA_FOUND THEN
635: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
636: DBMS_SQL.CLOSE_CURSOR(l_cursor);
637: END IF;
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
640: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_DimensionX_Values:NO_DATA_FOUND'); htp.para;
641: END IF;
642: RAISE FND_API.G_EXC_ERROR;

Line 642: RAISE FND_API.G_EXC_ERROR;

638: x_return_status := FND_API.G_RET_STS_ERROR;
639: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
640: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_DimensionX_Values:NO_DATA_FOUND'); htp.para;
641: END IF;
642: RAISE FND_API.G_EXC_ERROR;
643: WHEN FND_API.G_EXC_ERROR THEN
644: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
645: DBMS_SQL.CLOSE_CURSOR(l_cursor);
646: END IF;

Line 643: WHEN FND_API.G_EXC_ERROR THEN

639: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
640: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_DimensionX_Values:NO_DATA_FOUND'); htp.para;
641: END IF;
642: RAISE FND_API.G_EXC_ERROR;
643: WHEN FND_API.G_EXC_ERROR THEN
644: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
645: DBMS_SQL.CLOSE_CURSOR(l_cursor);
646: END IF;
647: x_return_status := FND_API.G_RET_STS_ERROR;

Line 647: x_return_status := FND_API.G_RET_STS_ERROR;

643: WHEN FND_API.G_EXC_ERROR THEN
644: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
645: DBMS_SQL.CLOSE_CURSOR(l_cursor);
646: END IF;
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
649: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_DimensionX_Values:G_EXC_ERROR'); htp.para;
650: END IF;
651: RAISE;

Line 652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

648: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
649: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_DimensionX_Values:G_EXC_ERROR'); htp.para;
650: END IF;
651: RAISE;
652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
653: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
654: DBMS_SQL.CLOSE_CURSOR(l_cursor);
655: END IF;
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
653: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
654: DBMS_SQL.CLOSE_CURSOR(l_cursor);
655: END IF;
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
658: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_DimensionX_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;
659: END IF;
660: RAISE;

Line 665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

661: WHEN OTHERS THEN
662: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
663: DBMS_SQL.CLOSE_CURSOR(l_cursor);
664: END IF;
665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
666: BIS_UTILITIES_PVT.Add_Error_Message
667: ( p_error_table => x_error_Tbl
668: , p_error_msg_id => SQLCODE
669: , p_error_description => SQLERRM

Line 675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

671: );
672: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
673: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_DimensionX_Values:OTHERS'); htp.para;
674: END IF;
675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
676: --
677: END Get_DimensionX_Values;
678: --
679: --

Line 710: x_return_status := FND_API.G_RET_STS_SUCCESS;

706: l_retrieved NUMBER;
707: l_Org_Dept BOOLEAN;
708: --
709: BEGIN
710: x_return_status := FND_API.G_RET_STS_SUCCESS;
711: --
712: SELECT
713: DIMENSION_LEVEL_SHORT_NAME
714: , DIMENSION_LEVEL_NAME

Line 805: x_return_status := FND_API.G_RET_STS_ERROR;

801: WHEN NO_DATA_FOUND THEN
802: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
803: DBMS_SQL.CLOSE_CURSOR(l_cursor);
804: END IF;
805: x_return_status := FND_API.G_RET_STS_ERROR;
806: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
807: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Time_Dim_Values:NO_DATA_FOUND'); htp.para;
808: END IF;
809: RAISE FND_API.G_EXC_ERROR;

Line 809: RAISE FND_API.G_EXC_ERROR;

805: x_return_status := FND_API.G_RET_STS_ERROR;
806: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
807: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Time_Dim_Values:NO_DATA_FOUND'); htp.para;
808: END IF;
809: RAISE FND_API.G_EXC_ERROR;
810: WHEN FND_API.G_EXC_ERROR THEN
811: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
812: DBMS_SQL.CLOSE_CURSOR(l_cursor);
813: END IF;

Line 810: WHEN FND_API.G_EXC_ERROR THEN

806: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
807: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Time_Dim_Values:NO_DATA_FOUND'); htp.para;
808: END IF;
809: RAISE FND_API.G_EXC_ERROR;
810: WHEN FND_API.G_EXC_ERROR THEN
811: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
812: DBMS_SQL.CLOSE_CURSOR(l_cursor);
813: END IF;
814: x_return_status := FND_API.G_RET_STS_ERROR;

Line 814: x_return_status := FND_API.G_RET_STS_ERROR;

810: WHEN FND_API.G_EXC_ERROR THEN
811: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
812: DBMS_SQL.CLOSE_CURSOR(l_cursor);
813: END IF;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
816: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Time_Dim_Values:G_EXC_ERROR'); htp.para;
817: END IF;
818: RAISE;

Line 819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

815: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
816: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Time_Dim_Values:G_EXC_ERROR'); htp.para;
817: END IF;
818: RAISE;
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
820: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
821: DBMS_SQL.CLOSE_CURSOR(l_cursor);
822: END IF;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
820: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
821: DBMS_SQL.CLOSE_CURSOR(l_cursor);
822: END IF;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
825: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Time_Dim_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;
826: END IF;
827: RAISE;

Line 832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

828: WHEN OTHERS THEN
829: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
830: DBMS_SQL.CLOSE_CURSOR(l_cursor);
831: END IF;
832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
833: BIS_UTILITIES_PVT.Add_Error_Message
834: ( p_error_table => x_error_Tbl
835: , p_error_msg_id => SQLCODE
836: , p_error_description => SQLERRM

Line 842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

838: );
839: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
840: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Time_Dim_Values:OTHERS'); htp.para;
841: END IF;
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: --
844: END Get_Time_Dim_Values;
845: --
846: --

Line 859: x_return_status := FND_API.G_RET_STS_SUCCESS;

855: --
856: l_unique BOOLEAN;
857: --
858: BEGIN
859: x_return_status := FND_API.G_RET_STS_SUCCESS;
860: --
861: FOR l_ind IN 1..p_Dim_Level_Value_Tbl.COUNT LOOP
862: l_unique := TRUE;
863: --

Line 880: WHEN FND_API.G_EXC_ERROR THEN

876: END IF;
877: END LOOP;
878: --
879: EXCEPTION
880: WHEN FND_API.G_EXC_ERROR THEN
881: x_return_status := FND_API.G_RET_STS_ERROR;
882: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
883: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Remove_Dup_Dim_Level_Values:G_EXC_ERROR'); htp.para;
884: END IF;

Line 881: x_return_status := FND_API.G_RET_STS_ERROR;

877: END LOOP;
878: --
879: EXCEPTION
880: WHEN FND_API.G_EXC_ERROR THEN
881: x_return_status := FND_API.G_RET_STS_ERROR;
882: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
883: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Remove_Dup_Dim_Level_Values:G_EXC_ERROR'); htp.para;
884: END IF;
885: RAISE;

Line 886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

882: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
883: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Remove_Dup_Dim_Level_Values:G_EXC_ERROR'); htp.para;
884: END IF;
885: RAISE;
886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
889: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Remove_Dup_Dim_Level_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;
890: END IF;

Line 887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

883: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Remove_Dup_Dim_Level_Values:G_EXC_ERROR'); htp.para;
884: END IF;
885: RAISE;
886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
888: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
889: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Remove_Dup_Dim_Level_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;
890: END IF;
891: RAISE;

Line 893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

889: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Remove_Dup_Dim_Level_Values:G_EXC_UNEXPECTED_ERROR'); htp.para;
890: END IF;
891: RAISE;
892: WHEN OTHERS THEN
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: BIS_UTILITIES_PVT.Add_Error_Message
895: ( p_error_table => x_error_Tbl
896: , p_error_msg_id => SQLCODE
897: , p_error_description => SQLERRM

Line 903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

899: );
900: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
901: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Remove_Dup_Dim_Level_Values:OTHERS'); htp.para;
902: END IF;
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: END Remove_Dup_Dim_Level_Values;
905: --
906: --
907: PROCEDURE Get_Start_Date

Line 927: x_return_status := FND_API.G_RET_STS_SUCCESS;

923: l_sql_result INTEGER := 0;
924: l_start_date DATE;
925: --
926: BEGIN
927: x_return_status := FND_API.G_RET_STS_SUCCESS;
928: --
929: SELECT
930: DIMENSION_LEVEL_SHORT_NAME
931: , LEVEL_VALUES_VIEW_NAME

Line 970: x_return_status := FND_API.G_RET_STS_ERROR;

966: WHEN NO_DATA_FOUND THEN
967: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
968: DBMS_SQL.CLOSE_CURSOR(l_cursor);
969: END IF;
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
972: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Start_Date:NO_DATA_FOUND'); htp.para;
973: END IF;
974: RAISE FND_API.G_EXC_ERROR;

Line 974: RAISE FND_API.G_EXC_ERROR;

970: x_return_status := FND_API.G_RET_STS_ERROR;
971: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
972: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Start_Date:NO_DATA_FOUND'); htp.para;
973: END IF;
974: RAISE FND_API.G_EXC_ERROR;
975: WHEN FND_API.G_EXC_ERROR THEN
976: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
977: DBMS_SQL.CLOSE_CURSOR(l_cursor);
978: END IF;

Line 975: WHEN FND_API.G_EXC_ERROR THEN

971: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
972: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Start_Date:NO_DATA_FOUND'); htp.para;
973: END IF;
974: RAISE FND_API.G_EXC_ERROR;
975: WHEN FND_API.G_EXC_ERROR THEN
976: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
977: DBMS_SQL.CLOSE_CURSOR(l_cursor);
978: END IF;
979: x_return_status := FND_API.G_RET_STS_ERROR;

Line 979: x_return_status := FND_API.G_RET_STS_ERROR;

975: WHEN FND_API.G_EXC_ERROR THEN
976: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
977: DBMS_SQL.CLOSE_CURSOR(l_cursor);
978: END IF;
979: x_return_status := FND_API.G_RET_STS_ERROR;
980: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
981: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Start_Date:G_EXC_ERROR'); htp.para;
982: END IF;
983: RAISE;

Line 984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

980: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
981: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Start_Date:G_EXC_ERROR'); htp.para;
982: END IF;
983: RAISE;
984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
985: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
986: DBMS_SQL.CLOSE_CURSOR(l_cursor);
987: END IF;
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
985: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
986: DBMS_SQL.CLOSE_CURSOR(l_cursor);
987: END IF;
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
990: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Start_Date:G_EXC_UNEXPECTED_ERROR'); htp.para;
991: END IF;
992: RAISE;

Line 997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

993: WHEN OTHERS THEN
994: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
995: DBMS_SQL.CLOSE_CURSOR(l_cursor);
996: END IF;
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998: BIS_UTILITIES_PVT.Add_Error_Message
999: ( p_error_table => x_error_Tbl
1000: , p_error_msg_id => SQLCODE
1001: , p_error_description => SQLERRM

Line 1007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1003: );
1004: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1005: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_Start_Date:OTHERS'); htp.para;
1006: END IF;
1007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1008: END Get_Start_Date;
1009: --
1010: --
1011: PROCEDURE Get_End_Date

Line 1031: x_return_status := FND_API.G_RET_STS_SUCCESS;

1027: l_sql_result INTEGER := 0;
1028: l_end_date DATE;
1029: --
1030: BEGIN
1031: x_return_status := FND_API.G_RET_STS_SUCCESS;
1032: --
1033: SELECT
1034: DIMENSION_LEVEL_SHORT_NAME
1035: , LEVEL_VALUES_VIEW_NAME

Line 1074: x_return_status := FND_API.G_RET_STS_ERROR;

1070: WHEN NO_DATA_FOUND THEN
1071: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1072: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1073: END IF;
1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1076: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_End_Date:NO_DATA_FOUND'); htp.para;
1077: END IF;
1078: RAISE FND_API.G_EXC_ERROR;

Line 1078: RAISE FND_API.G_EXC_ERROR;

1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1076: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_End_Date:NO_DATA_FOUND'); htp.para;
1077: END IF;
1078: RAISE FND_API.G_EXC_ERROR;
1079: WHEN FND_API.G_EXC_ERROR THEN
1080: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1081: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1082: END IF;

Line 1079: WHEN FND_API.G_EXC_ERROR THEN

1075: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1076: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_End_Date:NO_DATA_FOUND'); htp.para;
1077: END IF;
1078: RAISE FND_API.G_EXC_ERROR;
1079: WHEN FND_API.G_EXC_ERROR THEN
1080: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1081: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1082: END IF;
1083: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1083: x_return_status := FND_API.G_RET_STS_ERROR;

1079: WHEN FND_API.G_EXC_ERROR THEN
1080: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1081: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1082: END IF;
1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1085: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_End_Date:G_EXC_ERROR'); htp.para;
1086: END IF;
1087: RAISE;

Line 1088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1084: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1085: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_End_Date:G_EXC_ERROR'); htp.para;
1086: END IF;
1087: RAISE;
1088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1089: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1090: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1091: END IF;
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1089: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1090: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1091: END IF;
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1093: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1094: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_End_Date:G_EXC_UNEXPECTED_ERROR'); htp.para;
1095: END IF;
1096: RAISE;

Line 1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1097: WHEN OTHERS THEN
1098: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1099: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1100: END IF;
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1102: BIS_UTILITIES_PVT.Add_Error_Message
1103: ( p_error_table => x_error_Tbl
1104: , p_error_msg_id => SQLCODE
1105: , p_error_description => SQLERRM

Line 1111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1107: );
1108: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1109: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Get_End_Date:OTHERS'); htp.para;
1110: END IF;
1111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1112: END Get_End_Date;
1113: --
1114: --
1115: PROCEDURE Org_ID_to_Value

Line 1132: x_return_status := FND_API.G_RET_STS_SUCCESS;

1128: l_value VARCHAR2(250);
1129: l_select_stmt VARCHAR2(2000);
1130: --
1131: BEGIN
1132: x_return_status := FND_API.G_RET_STS_SUCCESS;
1133: x_Dim_Level_Value_Rec := p_Dim_Level_Value_Rec;
1134: --
1135: SELECT
1136: DIMENSION_LEVEL_SHORT_NAME

Line 1161: RAISE FND_API.G_EXC_ERROR;

1157: BIS_UTILITIES_PVT.Add_Error_Message
1158: ( p_error_msg_name => 'BIS_INVALID_ORGANIZATION_ID'
1159: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.Org_ID_to_Value'
1160: );
1161: RAISE FND_API.G_EXC_ERROR;
1162: END IF;
1163: x_Dim_Level_Value_Rec.Dimension_Level_Value_Name := l_value;
1164: x_Dim_Level_Value_Rec.Dimension_Level_Short_Name := l_short_name;
1165: x_Dim_Level_Value_Rec.Dimension_Level_Name := l_name;

Line 1173: RAISE FND_API.G_EXC_ERROR;

1169: BIS_UTILITIES_PVT.Add_Error_Message
1170: ( p_error_msg_name => 'BIS_INVALID_ORGANIZATION_ID'
1171: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.Org_ID_to_Value'
1172: );
1173: RAISE FND_API.G_EXC_ERROR;
1174: --
1175: ELSE
1176: -- populate record with name
1177: x_Dim_Level_Value_Rec.Dimension_Level_Value_Name := l_name;

Line 1184: x_return_status := FND_API.G_RET_STS_ERROR;

1180: END IF;
1181: --
1182: EXCEPTION
1183: WHEN NO_DATA_FOUND THEN
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1186: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_ID_to_Value:NO_DATA_FOUND'); htp.para;
1187: END IF;
1188: RAISE FND_API.G_EXC_ERROR;

Line 1188: RAISE FND_API.G_EXC_ERROR;

1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1186: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_ID_to_Value:NO_DATA_FOUND'); htp.para;
1187: END IF;
1188: RAISE FND_API.G_EXC_ERROR;
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1192: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_ID_to_Value:G_EXC_ERROR'); htp.para;

Line 1189: WHEN FND_API.G_EXC_ERROR THEN

1185: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1186: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_ID_to_Value:NO_DATA_FOUND'); htp.para;
1187: END IF;
1188: RAISE FND_API.G_EXC_ERROR;
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1192: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_ID_to_Value:G_EXC_ERROR'); htp.para;
1193: END IF;

Line 1190: x_return_status := FND_API.G_RET_STS_ERROR;

1186: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_ID_to_Value:NO_DATA_FOUND'); htp.para;
1187: END IF;
1188: RAISE FND_API.G_EXC_ERROR;
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: x_return_status := FND_API.G_RET_STS_ERROR;
1191: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1192: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_ID_to_Value:G_EXC_ERROR'); htp.para;
1193: END IF;
1194: RAISE;

Line 1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1191: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1192: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_ID_to_Value:G_EXC_ERROR'); htp.para;
1193: END IF;
1194: RAISE;
1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1197: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1198: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_ID_to_Value:G_EXC_UNEXPECTED_ERROR'); htp.para;
1199: END IF;

Line 1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1192: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_ID_to_Value:G_EXC_ERROR'); htp.para;
1193: END IF;
1194: RAISE;
1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1197: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1198: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_ID_to_Value:G_EXC_UNEXPECTED_ERROR'); htp.para;
1199: END IF;
1200: RAISE;

Line 1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1198: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_ID_to_Value:G_EXC_UNEXPECTED_ERROR'); htp.para;
1199: END IF;
1200: RAISE;
1201: WHEN OTHERS THEN
1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1203: BIS_UTILITIES_PVT.Add_Error_Message
1204: ( p_error_table => x_error_Tbl
1205: , p_error_msg_id => SQLCODE
1206: , p_error_description => SQLERRM

Line 1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1208: );
1209: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1210: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_ID_to_Value:OTHERS'); htp.para;
1211: END IF;
1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1213: END Org_ID_to_Value;
1214: --
1215: --
1216: PROCEDURE Org_Value_to_ID

Line 1233: x_return_status := FND_API.G_RET_STS_SUCCESS;

1229: l_value VARCHAR2(250);
1230: l_select_stmt VARCHAR2(2000);
1231: --
1232: BEGIN
1233: x_return_status := FND_API.G_RET_STS_SUCCESS;
1234: x_Dim_Level_Value_Rec := p_Dim_Level_Value_Rec;
1235: --
1236: SELECT
1237: DIMENSION_LEVEL_SHORT_NAME

Line 1263: RAISE FND_API.G_EXC_ERROR;

1259: BIS_UTILITIES_PVT.Add_Error_Message
1260: ( p_error_msg_name => 'BIS_INVALID_ORGANIZATION_VALUE'
1261: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.Org_Value_to_ID'
1262: );
1263: RAISE FND_API.G_EXC_ERROR;
1264: END IF;
1265: --
1266: x_Dim_Level_Value_Rec.Dimension_Level_Value_ID := l_id;
1267: x_Dim_Level_Value_Rec.Dimension_Level_Short_Name := l_short_name;

Line 1276: RAISE FND_API.G_EXC_ERROR;

1272: BIS_UTILITIES_PVT.Add_Error_Message
1273: ( p_error_msg_name => 'BIS_INVALID_ORGANIZATION_VALUE'
1274: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.Org_Value_to_ID'
1275: );
1276: RAISE FND_API.G_EXC_ERROR;
1277: --
1278: ELSE
1279: -- populate record with id
1280: x_Dim_Level_Value_Rec.Dimension_Level_Value_ID := '-1';

Line 1287: x_return_status := FND_API.G_RET_STS_ERROR;

1283: END IF;
1284: --
1285: EXCEPTION
1286: WHEN NO_DATA_FOUND THEN
1287: x_return_status := FND_API.G_RET_STS_ERROR;
1288: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1289: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_Value_to_ID:NO_DATA_FOUND'); htp.para;
1290: END IF;
1291: RAISE FND_API.G_EXC_ERROR;

Line 1291: RAISE FND_API.G_EXC_ERROR;

1287: x_return_status := FND_API.G_RET_STS_ERROR;
1288: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1289: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_Value_to_ID:NO_DATA_FOUND'); htp.para;
1290: END IF;
1291: RAISE FND_API.G_EXC_ERROR;
1292: WHEN FND_API.G_EXC_ERROR THEN
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1295: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_Value_to_ID:G_EXC_ERROR'); htp.para;

Line 1292: WHEN FND_API.G_EXC_ERROR THEN

1288: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1289: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_Value_to_ID:NO_DATA_FOUND'); htp.para;
1290: END IF;
1291: RAISE FND_API.G_EXC_ERROR;
1292: WHEN FND_API.G_EXC_ERROR THEN
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1295: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_Value_to_ID:G_EXC_ERROR'); htp.para;
1296: END IF;

Line 1293: x_return_status := FND_API.G_RET_STS_ERROR;

1289: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_Value_to_ID:NO_DATA_FOUND'); htp.para;
1290: END IF;
1291: RAISE FND_API.G_EXC_ERROR;
1292: WHEN FND_API.G_EXC_ERROR THEN
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1295: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_Value_to_ID:G_EXC_ERROR'); htp.para;
1296: END IF;
1297: RAISE;

Line 1298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1294: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1295: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_Value_to_ID:G_EXC_ERROR'); htp.para;
1296: END IF;
1297: RAISE;
1298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1300: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1301: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_Value_to_ID:G_EXC_UNEXPECTED_ERROR'); htp.para;
1302: END IF;

Line 1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1295: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_Value_to_ID:G_EXC_ERROR'); htp.para;
1296: END IF;
1297: RAISE;
1298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1300: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1301: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_Value_to_ID:G_EXC_UNEXPECTED_ERROR'); htp.para;
1302: END IF;
1303: RAISE;

Line 1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1301: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_Value_to_ID:G_EXC_UNEXPECTED_ERROR'); htp.para;
1302: END IF;
1303: RAISE;
1304: WHEN OTHERS THEN
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306: BIS_UTILITIES_PVT.Add_Error_Message
1307: ( p_error_table => x_error_Tbl
1308: , p_error_msg_id => SQLCODE
1309: , p_error_description => SQLERRM

Line 1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1311: );
1312: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1313: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Org_Value_to_ID:OTHERS'); htp.para;
1314: END IF;
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1316: END Org_Value_to_ID;
1317: --
1318: --
1319: PROCEDURE Time_ID_to_Value

Line 1337: x_return_status := FND_API.G_RET_STS_SUCCESS;

1333: l_value VARCHAR2(250);
1334: l_select_stmt VARCHAR2(2000);
1335: --
1336: BEGIN
1337: x_return_status := FND_API.G_RET_STS_SUCCESS;
1338: x_Dim_Level_Value_Rec := p_Dim_Level_Value_Rec;
1339: --
1340: SELECT
1341: DIMENSION_LEVEL_SHORT_NAME

Line 1386: RAISE FND_API.G_EXC_ERROR;

1382: BIS_UTILITIES_PVT.Add_Error_Message
1383: ( p_error_msg_name => 'BIS_INVALID_TIME_ID'
1384: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.Time_ID_to_Value'
1385: );
1386: RAISE FND_API.G_EXC_ERROR;
1387: END IF;
1388: --
1389: x_Dim_Level_Value_Rec.Dimension_Level_Value_Name := l_value;
1390: x_Dim_Level_Value_Rec.Dimension_Level_Short_Name := l_short_name;

Line 1399: RAISE FND_API.G_EXC_ERROR;

1395: BIS_UTILITIES_PVT.Add_Error_Message
1396: ( p_error_msg_name => 'BIS_INVALID_TIME_ID'
1397: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.Time_ID_to_Value'
1398: );
1399: RAISE FND_API.G_EXC_ERROR;
1400: --
1401: ELSE
1402: -- populate record with name
1403: x_Dim_Level_Value_Rec.Dimension_Level_Value_Name := l_name;

Line 1410: x_return_status := FND_API.G_RET_STS_ERROR;

1406: END IF;
1407: --
1408: EXCEPTION
1409: WHEN NO_DATA_FOUND THEN
1410: x_return_status := FND_API.G_RET_STS_ERROR;
1411: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1412: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_ID_to_Value:NO_DATA_FOUND'); htp.para;
1413: END IF;
1414: RAISE FND_API.G_EXC_ERROR;

Line 1414: RAISE FND_API.G_EXC_ERROR;

1410: x_return_status := FND_API.G_RET_STS_ERROR;
1411: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1412: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_ID_to_Value:NO_DATA_FOUND'); htp.para;
1413: END IF;
1414: RAISE FND_API.G_EXC_ERROR;
1415: WHEN FND_API.G_EXC_ERROR THEN
1416: x_return_status := FND_API.G_RET_STS_ERROR;
1417: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1418: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_ID_to_Value:G_EXC_ERROR'); htp.para;

Line 1415: WHEN FND_API.G_EXC_ERROR THEN

1411: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1412: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_ID_to_Value:NO_DATA_FOUND'); htp.para;
1413: END IF;
1414: RAISE FND_API.G_EXC_ERROR;
1415: WHEN FND_API.G_EXC_ERROR THEN
1416: x_return_status := FND_API.G_RET_STS_ERROR;
1417: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1418: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_ID_to_Value:G_EXC_ERROR'); htp.para;
1419: END IF;

Line 1416: x_return_status := FND_API.G_RET_STS_ERROR;

1412: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_ID_to_Value:NO_DATA_FOUND'); htp.para;
1413: END IF;
1414: RAISE FND_API.G_EXC_ERROR;
1415: WHEN FND_API.G_EXC_ERROR THEN
1416: x_return_status := FND_API.G_RET_STS_ERROR;
1417: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1418: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_ID_to_Value:G_EXC_ERROR'); htp.para;
1419: END IF;
1420: RAISE;

Line 1421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1417: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1418: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_ID_to_Value:G_EXC_ERROR'); htp.para;
1419: END IF;
1420: RAISE;
1421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1423: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1424: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_ID_to_Value:G_EXC_UNEXPECTED_ERROR'); htp.para;
1425: END IF;

Line 1422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1418: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_ID_to_Value:G_EXC_ERROR'); htp.para;
1419: END IF;
1420: RAISE;
1421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1423: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1424: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_ID_to_Value:G_EXC_UNEXPECTED_ERROR'); htp.para;
1425: END IF;
1426: RAISE;

Line 1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1424: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_ID_to_Value:G_EXC_UNEXPECTED_ERROR'); htp.para;
1425: END IF;
1426: RAISE;
1427: WHEN OTHERS THEN
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1429: BIS_UTILITIES_PVT.Add_Error_Message
1430: ( p_error_table => x_error_Tbl
1431: , p_error_msg_id => SQLCODE
1432: , p_error_description => SQLERRM

Line 1438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1434: );
1435: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1436: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_ID_to_Value:OTHERS'); htp.para;
1437: END IF;
1438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1439: END Time_ID_to_Value;
1440: --
1441: --
1442: PROCEDURE Time_Value_to_ID

Line 1460: x_return_status := FND_API.G_RET_STS_SUCCESS;

1456: l_value VARCHAR2(250);
1457: l_select_stmt VARCHAR2(2000);
1458: --
1459: BEGIN
1460: x_return_status := FND_API.G_RET_STS_SUCCESS;
1461: x_Dim_Level_Value_Rec := p_Dim_Level_Value_Rec;
1462: --
1463: SELECT
1464: DIMENSION_LEVEL_SHORT_NAME

Line 1512: RAISE FND_API.G_EXC_ERROR;

1508: BIS_UTILITIES_PVT.Add_Error_Message
1509: ( p_error_msg_name => 'BIS_INVALID_TIME_VALUE'
1510: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.Time_Value_to_ID'
1511: );
1512: RAISE FND_API.G_EXC_ERROR;
1513: END IF;
1514: --
1515: --
1516: x_Dim_Level_Value_Rec.Dimension_Level_Value_Name := l_value;

Line 1526: RAISE FND_API.G_EXC_ERROR;

1522: BIS_UTILITIES_PVT.Add_Error_Message
1523: ( p_error_msg_name => 'BIS_INVALID_TIME_VALUE'
1524: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.Time_Value_to_ID'
1525: );
1526: RAISE FND_API.G_EXC_ERROR;
1527: --
1528: ELSE
1529: -- populate record with name
1530: x_Dim_Level_Value_Rec.Dimension_Level_Value_ID := '-1';

Line 1537: x_return_status := FND_API.G_RET_STS_ERROR;

1533: END IF;
1534: --
1535: EXCEPTION
1536: WHEN NO_DATA_FOUND THEN
1537: x_return_status := FND_API.G_RET_STS_ERROR;
1538: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1539: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_Value_to_ID:NO_DATA_FOUND'); htp.para;
1540: END IF;
1541: RAISE FND_API.G_EXC_ERROR;

Line 1541: RAISE FND_API.G_EXC_ERROR;

1537: x_return_status := FND_API.G_RET_STS_ERROR;
1538: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1539: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_Value_to_ID:NO_DATA_FOUND'); htp.para;
1540: END IF;
1541: RAISE FND_API.G_EXC_ERROR;
1542: WHEN FND_API.G_EXC_ERROR THEN
1543: x_return_status := FND_API.G_RET_STS_ERROR;
1544: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1545: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_Value_to_ID:G_EXC_ERROR'); htp.para;

Line 1542: WHEN FND_API.G_EXC_ERROR THEN

1538: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1539: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_Value_to_ID:NO_DATA_FOUND'); htp.para;
1540: END IF;
1541: RAISE FND_API.G_EXC_ERROR;
1542: WHEN FND_API.G_EXC_ERROR THEN
1543: x_return_status := FND_API.G_RET_STS_ERROR;
1544: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1545: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_Value_to_ID:G_EXC_ERROR'); htp.para;
1546: END IF;

Line 1543: x_return_status := FND_API.G_RET_STS_ERROR;

1539: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_Value_to_ID:NO_DATA_FOUND'); htp.para;
1540: END IF;
1541: RAISE FND_API.G_EXC_ERROR;
1542: WHEN FND_API.G_EXC_ERROR THEN
1543: x_return_status := FND_API.G_RET_STS_ERROR;
1544: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1545: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_Value_to_ID:G_EXC_ERROR'); htp.para;
1546: END IF;
1547: RAISE;

Line 1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1544: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1545: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_Value_to_ID:G_EXC_ERROR'); htp.para;
1546: END IF;
1547: RAISE;
1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1551: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_Value_to_ID:G_EXC_UNEXPECTED_ERROR'); htp.para;
1552: END IF;

Line 1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1545: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_Value_to_ID:G_EXC_ERROR'); htp.para;
1546: END IF;
1547: RAISE;
1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1551: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_Value_to_ID:G_EXC_UNEXPECTED_ERROR'); htp.para;
1552: END IF;
1553: RAISE;

Line 1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1551: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_Value_to_ID:G_EXC_UNEXPECTED_ERROR'); htp.para;
1552: END IF;
1553: RAISE;
1554: WHEN OTHERS THEN
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1556: BIS_UTILITIES_PVT.Add_Error_Message
1557: ( p_error_table => x_error_Tbl
1558: , p_error_msg_id => SQLCODE
1559: , p_error_description => SQLERRM

Line 1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1561: );
1562: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1563: htp.p('BIS_DIM_LEVEL_VALUE_PVT.Time_Value_to_ID:OTHERS'); htp.para;
1564: END IF;
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END Time_Value_to_ID;
1567: --
1568: --
1569: PROCEDURE DimensionX_ID_to_Value

Line 1596: x_return_status := FND_API.G_RET_STS_SUCCESS;

1592: l_start_date DATE;
1593: l_end_date DATE;
1594: --
1595: BEGIN
1596: x_return_status := FND_API.G_RET_STS_SUCCESS;
1597: x_Dim_Level_Value_Rec := p_Dim_Level_Value_Rec;
1598: --
1599:
1600: BIS_PMF_GET_DIMLEVELS_PVT.Get_DimLevel_Values_Data

Line 1614: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then

1610: ,x_return_status => x_return_status
1611: ,x_msg_count => l_msg_count
1612: ,x_msg_data => l_msg_data
1613: );
1614: if(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1615: BIS_UTILITIES_PVT.Add_Error_Message
1616: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
1617: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.DimensionX_ID_to_Value'
1618: , p_error_table => x_error_tbl

Line 1621: RAISE FND_API.G_EXC_ERROR;

1617: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.DimensionX_ID_to_Value'
1618: , p_error_table => x_error_tbl
1619: , x_error_table => x_error_tbl
1620: );
1621: RAISE FND_API.G_EXC_ERROR;
1622: end if;
1623:
1624: --------------------
1625:

Line 1659: RAISE FND_API.G_EXC_ERROR;

1655: , p_value1 => l_name
1656: , p_error_table => x_error_tbl
1657: , x_error_table => x_error_tbl
1658: );
1659: RAISE FND_API.G_EXC_ERROR;
1660: END IF;
1661: x_Dim_Level_Value_Rec.Dimension_Level_Value_Name := SUBSTRB(l_value,1,240);
1662: x_Dim_Level_Value_Rec.Dimension_Level_Short_Name := l_short_name;
1663: x_Dim_Level_Value_Rec.Dimension_Level_Name := l_name;

Line 1679: RAISE FND_API.G_EXC_ERROR;

1675: , p_value1 => l_name
1676: , p_error_table => x_error_tbl
1677: , x_error_table => x_error_tbl
1678: );
1679: RAISE FND_API.G_EXC_ERROR;
1680: --
1681: ELSE
1682: -- populate record with name
1683: x_Dim_Level_Value_Rec.Dimension_Level_Value_Name := l_name;

Line 1691: x_return_status := FND_API.G_RET_STS_ERROR;

1687: --
1688: --commented out NOCOPY RAISE
1689: EXCEPTION
1690: WHEN NO_DATA_FOUND THEN
1691: x_return_status := FND_API.G_RET_STS_ERROR;
1692: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1693: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_ID_to_Value:NO_DATA_FOUND'); htp.para;
1694: END IF;
1695: --RAISE FND_API.G_EXC_ERROR;

Line 1695: --RAISE FND_API.G_EXC_ERROR;

1691: x_return_status := FND_API.G_RET_STS_ERROR;
1692: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1693: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_ID_to_Value:NO_DATA_FOUND'); htp.para;
1694: END IF;
1695: --RAISE FND_API.G_EXC_ERROR;
1696: WHEN FND_API.G_EXC_ERROR THEN
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1699: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_ID_to_Value:G_EXC_ERROR'); htp.para;

Line 1696: WHEN FND_API.G_EXC_ERROR THEN

1692: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1693: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_ID_to_Value:NO_DATA_FOUND'); htp.para;
1694: END IF;
1695: --RAISE FND_API.G_EXC_ERROR;
1696: WHEN FND_API.G_EXC_ERROR THEN
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1699: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_ID_to_Value:G_EXC_ERROR'); htp.para;
1700: END IF;

Line 1697: x_return_status := FND_API.G_RET_STS_ERROR;

1693: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_ID_to_Value:NO_DATA_FOUND'); htp.para;
1694: END IF;
1695: --RAISE FND_API.G_EXC_ERROR;
1696: WHEN FND_API.G_EXC_ERROR THEN
1697: x_return_status := FND_API.G_RET_STS_ERROR;
1698: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1699: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_ID_to_Value:G_EXC_ERROR'); htp.para;
1700: END IF;
1701: --RAISE;

Line 1702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1698: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1699: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_ID_to_Value:G_EXC_ERROR'); htp.para;
1700: END IF;
1701: --RAISE;
1702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1704: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1705: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_ID_to_Value:G_EXC_UNEXPECTED_ERROR'); htp.para;
1706: END IF;

Line 1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1699: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_ID_to_Value:G_EXC_ERROR'); htp.para;
1700: END IF;
1701: --RAISE;
1702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1704: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1705: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_ID_to_Value:G_EXC_UNEXPECTED_ERROR'); htp.para;
1706: END IF;
1707: --RAISE;

Line 1709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1705: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_ID_to_Value:G_EXC_UNEXPECTED_ERROR'); htp.para;
1706: END IF;
1707: --RAISE;
1708: WHEN OTHERS THEN
1709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1710: BIS_UTILITIES_PVT.Add_Error_Message
1711: ( p_error_table => x_error_Tbl
1712: , p_error_msg_id => SQLCODE
1713: , p_error_description => SQLERRM

Line 1719: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1715: );
1716: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1717: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_ID_to_Value:OTHERS'); htp.para;
1718: END IF;
1719: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1720: END DimensionX_ID_to_Value;
1721: --
1722: --
1723: PROCEDURE DimensionX_Value_to_ID

Line 1742: x_return_status := FND_API.G_RET_STS_SUCCESS;

1738: l_select_stmt VARCHAR2(2000);
1739: l_sql_result INTEGER := 0;
1740: --
1741: BEGIN
1742: x_return_status := FND_API.G_RET_STS_SUCCESS;
1743: x_Dim_Level_Value_Rec := p_Dim_Level_Value_Rec;
1744: --
1745: SELECT
1746: DIMENSION_LEVEL_SHORT_NAME

Line 1768: RAISE FND_API.G_EXC_ERROR;

1764: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.DimensionX_Value_to_ID'
1765: , p_token1 => 'DIM_LEVEL_NAME'
1766: , p_value1 => l_name
1767: );
1768: RAISE FND_API.G_EXC_ERROR;
1769: END IF;
1770: x_Dim_Level_Value_Rec.Dimension_Level_Value_ID := l_id;
1771: x_Dim_Level_Value_Rec.Dimension_Level_Short_Name := l_short_name;
1772: x_Dim_Level_Value_Rec.Dimension_Level_Name := l_name;

Line 1782: RAISE FND_API.G_EXC_ERROR;

1778: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.DimensionX_Value_to_ID'
1779: , p_token1 => 'DIM_LEVEL_NAME'
1780: , p_value1 => l_name
1781: );
1782: RAISE FND_API.G_EXC_ERROR;
1783: --
1784: ELSE
1785: -- populate record with name
1786: x_Dim_Level_Value_Rec.Dimension_Level_Value_ID := '-1';

Line 1793: x_return_status := FND_API.G_RET_STS_ERROR;

1789: END IF;
1790: --
1791: EXCEPTION
1792: WHEN NO_DATA_FOUND THEN
1793: x_return_status := FND_API.G_RET_STS_ERROR;
1794: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1795: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_Value_to_ID:NO_DATA_FOUND'); htp.para;
1796: END IF;
1797: RAISE FND_API.G_EXC_ERROR;

Line 1797: RAISE FND_API.G_EXC_ERROR;

1793: x_return_status := FND_API.G_RET_STS_ERROR;
1794: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1795: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_Value_to_ID:NO_DATA_FOUND'); htp.para;
1796: END IF;
1797: RAISE FND_API.G_EXC_ERROR;
1798: WHEN FND_API.G_EXC_ERROR THEN
1799: x_return_status := FND_API.G_RET_STS_ERROR;
1800: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1801: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_Value_to_ID:G_EXC_ERROR'); htp.para;

Line 1798: WHEN FND_API.G_EXC_ERROR THEN

1794: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1795: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_Value_to_ID:NO_DATA_FOUND'); htp.para;
1796: END IF;
1797: RAISE FND_API.G_EXC_ERROR;
1798: WHEN FND_API.G_EXC_ERROR THEN
1799: x_return_status := FND_API.G_RET_STS_ERROR;
1800: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1801: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_Value_to_ID:G_EXC_ERROR'); htp.para;
1802: END IF;

Line 1799: x_return_status := FND_API.G_RET_STS_ERROR;

1795: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_Value_to_ID:NO_DATA_FOUND'); htp.para;
1796: END IF;
1797: RAISE FND_API.G_EXC_ERROR;
1798: WHEN FND_API.G_EXC_ERROR THEN
1799: x_return_status := FND_API.G_RET_STS_ERROR;
1800: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1801: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_Value_to_ID:G_EXC_ERROR'); htp.para;
1802: END IF;
1803: RAISE;

Line 1804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1800: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1801: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_Value_to_ID:G_EXC_ERROR'); htp.para;
1802: END IF;
1803: RAISE;
1804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1806: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1807: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_Value_to_ID:G_EXC_UNEXPECTED_ERROR'); htp.para;
1808: END IF;

Line 1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1801: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_Value_to_ID:G_EXC_ERROR'); htp.para;
1802: END IF;
1803: RAISE;
1804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1806: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1807: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_Value_to_ID:G_EXC_UNEXPECTED_ERROR'); htp.para;
1808: END IF;
1809: RAISE;

Line 1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1807: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_Value_to_ID:G_EXC_UNEXPECTED_ERROR'); htp.para;
1808: END IF;
1809: RAISE;
1810: WHEN OTHERS THEN
1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1812: BIS_UTILITIES_PVT.Add_Error_Message
1813: ( p_error_table => x_error_Tbl
1814: , p_error_msg_id => SQLCODE
1815: , p_error_description => SQLERRM

Line 1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1817: );
1818: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN
1819: htp.p('BIS_DIM_LEVEL_VALUE_PVT.DimensionX_Value_to_ID:OTHERS'); htp.para;
1820: END IF;
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1822: END DimensionX_Value_to_ID;
1823:
1824: --
1825: Function Is_Current_Time_Period

Line 1934: if ( bis_utilities_pub.value_not_missing ( l_time_id ) = FND_API.G_TRUE )

1930: );
1931:
1932: x_current_time_id := l_time_id;
1933:
1934: if ( bis_utilities_pub.value_not_missing ( l_time_id ) = FND_API.G_TRUE )
1935: and ( bis_utilities_pub.value_not_null ( l_time_id ) = FND_API.G_TRUE )
1936: then
1937: BIS_UTILITIES_PUB.put_line(p_text => ' time id is ' || l_time_id );
1938: else

Line 1935: and ( bis_utilities_pub.value_not_null ( l_time_id ) = FND_API.G_TRUE )

1931:
1932: x_current_time_id := l_time_id;
1933:
1934: if ( bis_utilities_pub.value_not_missing ( l_time_id ) = FND_API.G_TRUE )
1935: and ( bis_utilities_pub.value_not_null ( l_time_id ) = FND_API.G_TRUE )
1936: then
1937: BIS_UTILITIES_PUB.put_line(p_text => ' time id is ' || l_time_id );
1938: else
1939: BIS_UTILITIES_PUB.put_line(p_text => ' time id is NULL ' );

Line 2096: if ( bis_utilities_pub.value_not_missing ( l_time_id ) = FND_API.G_TRUE )

2092: l_text := l_text || ' input time level value id = ' || p_Dim_Level_Value_Rec.Dimension_Level_value_ID ;
2093:
2094: l_text := l_text || ' ..... out NOCOPY of Is_Previous_Time_Period.';
2095:
2096: if ( bis_utilities_pub.value_not_missing ( l_time_id ) = FND_API.G_TRUE )
2097: and ( bis_utilities_pub.value_not_null ( l_time_id ) = FND_API.G_TRUE )
2098: then
2099: l_text := l_text || ' previous time id is ' || l_time_id ;
2100: else

Line 2097: and ( bis_utilities_pub.value_not_null ( l_time_id ) = FND_API.G_TRUE )

2093:
2094: l_text := l_text || ' ..... out NOCOPY of Is_Previous_Time_Period.';
2095:
2096: if ( bis_utilities_pub.value_not_missing ( l_time_id ) = FND_API.G_TRUE )
2097: and ( bis_utilities_pub.value_not_null ( l_time_id ) = FND_API.G_TRUE )
2098: then
2099: l_text := l_text || ' previous time id is ' || l_time_id ;
2100: else
2101: l_text := l_text || ' previous time id is NULL ' ;