[Home] [Help]
1: PACKAGE BODY BIS_DIM_LEVEL_VALUE_PVT AS
2: /* $Header: BISVDMVB.pls 120.2 2005/11/02 17:43:27 jxyu noship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA |
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;
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;
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;
221: WHEN OTHERS THEN
222: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
229: , p_error_description => SQLERRM
230: , x_error_table => x_error_Tbl
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;
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;
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;
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;
378: WHEN OTHERS THEN
379: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
386: , p_error_description => SQLERRM
387: , x_error_table => x_error_Tbl
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;
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;
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;
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;
519: WHEN OTHERS THEN
520: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
527: , p_error_description => SQLERRM
528: , x_error_table => x_error_Tbl
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: --
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;
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;
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;
661: WHEN OTHERS THEN
662: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
669: , p_error_description => SQLERRM
670: , x_error_table => x_error_Tbl
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;
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;
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;
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;
828: WHEN OTHERS THEN
829: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
836: , p_error_description => SQLERRM
837: , x_error_table => x_error_Tbl
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;
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;
886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;
892: WHEN OTHERS THEN
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
897: , p_error_description => SQLERRM
898: , x_error_table => x_error_Tbl
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: --
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;
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;
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;
993: WHEN OTHERS THEN
994: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1001: , p_error_description => SQLERRM
1002: , x_error_table => x_error_Tbl
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: --
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;
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;
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;
1097: WHEN OTHERS THEN
1098: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN
1105: , p_error_description => SQLERRM
1106: , x_error_table => x_error_Tbl
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: --
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;
1189: WHEN FND_API.G_EXC_ERROR THEN
1190: x_return_status := FND_API.G_RET_STS_ERROR;
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;
1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;
1201: WHEN OTHERS THEN
1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1206: , p_error_description => SQLERRM
1207: , x_error_table => x_error_Tbl
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: --
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;
1292: WHEN FND_API.G_EXC_ERROR THEN
1293: x_return_status := FND_API.G_RET_STS_ERROR;
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;
1298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;
1304: WHEN OTHERS THEN
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1309: , p_error_description => SQLERRM
1310: , x_error_table => x_error_Tbl
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: --
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;
1415: WHEN FND_API.G_EXC_ERROR THEN
1416: x_return_status := FND_API.G_RET_STS_ERROR;
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;
1421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;
1427: WHEN OTHERS THEN
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1432: , p_error_description => SQLERRM
1433: , x_error_table => x_error_Tbl
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: --
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;
1542: WHEN FND_API.G_EXC_ERROR THEN
1543: x_return_status := FND_API.G_RET_STS_ERROR;
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;
1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;
1554: WHEN OTHERS THEN
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1559: , p_error_description => SQLERRM
1560: , x_error_table => x_error_Tbl
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: --
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;
1696: WHEN FND_API.G_EXC_ERROR THEN
1697: x_return_status := FND_API.G_RET_STS_ERROR;
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;
1702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;
1708: WHEN OTHERS THEN
1709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1713: , p_error_description => SQLERRM
1714: , x_error_table => x_error_Tbl
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: --
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;
1798: WHEN FND_API.G_EXC_ERROR THEN
1799: x_return_status := FND_API.G_RET_STS_ERROR;
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;
1804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;
1810: WHEN OTHERS THEN
1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1815: , p_error_description => SQLERRM
1816: , x_error_table => x_error_Tbl
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:
2122:
2123: --
2124: --
2125:
2126: END BIS_DIM_LEVEL_VALUE_PVT;