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 BIS_UTILITIES_PVT

Line 35: REM | level method to BIS_UTILITIES_PVT.is_valid_time_dimension_level|

31: REM | for dimension level for bug 3033028 |
32: REM | 24-NOV-03 GRAMASAM added a check for time dimension level for bug |
33: REM | 3255072 |
34: REM | 09-JAN-2004 rpenneru bug#3352065 modified Check for TIME DIMENSION |
35: REM | level method to BIS_UTILITIES_PVT.is_valid_time_dimension_level|
36: REM | 09-JAN-2004 ankgoel bug#3001359 Modified to limit the dim level value|
37: REM | length to 240 characters |
38: REM | 19-OCT-2005 ppandey Enh 4618419- SQL Literal Fix |
39: REM | 02-NOV-2005 jxyu Fix bug#4711882 |

Line 199: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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;
203: WHEN FND_API.G_EXC_ERROR THEN

Line 208: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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

Line 217: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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

Line 226: BIS_UTILITIES_PVT.Add_Error_Message

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
230: , x_error_table => x_error_Tbl

Line 232: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

228: , p_error_msg_id => SQLCODE
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: --

Line 356: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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;
360: WHEN FND_API.G_EXC_ERROR THEN

Line 365: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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

Line 374: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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

Line 383: BIS_UTILITIES_PVT.Add_Error_Message

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
387: , x_error_table => x_error_Tbl

Line 389: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

385: , p_error_msg_id => SQLCODE
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: --

Line 497: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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;
501: WHEN FND_API.G_EXC_ERROR THEN

Line 506: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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

Line 515: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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

Line 524: BIS_UTILITIES_PVT.Add_Error_Message

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
528: , x_error_table => x_error_Tbl

Line 530: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

526: , p_error_msg_id => SQLCODE
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;

Line 639: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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;
643: WHEN FND_API.G_EXC_ERROR THEN

Line 648: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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

Line 657: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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

Line 666: BIS_UTILITIES_PVT.Add_Error_Message

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
670: , x_error_table => x_error_Tbl

Line 672: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

668: , p_error_msg_id => SQLCODE
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: --

Line 806: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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;
810: WHEN FND_API.G_EXC_ERROR THEN

Line 815: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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

Line 824: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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

Line 833: BIS_UTILITIES_PVT.Add_Error_Message

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
837: , x_error_table => x_error_Tbl

Line 839: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

835: , p_error_msg_id => SQLCODE
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: --

Line 882: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 888: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
892: WHEN OTHERS THEN

Line 894: BIS_UTILITIES_PVT.Add_Error_Message

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
898: , x_error_table => x_error_Tbl

Line 900: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

896: , p_error_msg_id => SQLCODE
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;

Line 971: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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;
975: WHEN FND_API.G_EXC_ERROR THEN

Line 980: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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

Line 989: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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

Line 998: BIS_UTILITIES_PVT.Add_Error_Message

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
1002: , x_error_table => x_error_Tbl

Line 1004: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1000: , p_error_msg_id => SQLCODE
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;

Line 1075: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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;
1079: WHEN FND_API.G_EXC_ERROR THEN

Line 1084: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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

Line 1093: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) 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

Line 1102: BIS_UTILITIES_PVT.Add_Error_Message

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
1106: , x_error_table => x_error_Tbl

Line 1108: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1104: , p_error_msg_id => SQLCODE
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;

Line 1157: BIS_UTILITIES_PVT.Add_Error_Message

1153: || ' WHERE ID = :1';
1154: --
1155: EXECUTE IMMEDIATE l_select_stmt INTO l_id, l_value USING p_Dim_Level_Value_Rec.Dimension_Level_Value_ID;
1156: IF (l_id IS NULL) THEN
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;

Line 1169: BIS_UTILITIES_PVT.Add_Error_Message

1165: x_Dim_Level_Value_Rec.Dimension_Level_Name := l_name;
1166: --
1167: ELSIF(p_Dim_Level_Value_Rec.Dimension_Level_Value_ID <> '-1') THEN
1168: -- populate error table
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;

Line 1185: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1189: WHEN FND_API.G_EXC_ERROR THEN

Line 1191: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1197: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1201: WHEN OTHERS THEN

Line 1203: BIS_UTILITIES_PVT.Add_Error_Message

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
1207: , x_error_table => x_error_Tbl

Line 1209: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1205: , p_error_msg_id => SQLCODE
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;

Line 1259: BIS_UTILITIES_PVT.Add_Error_Message

1255: --
1256: EXECUTE IMMEDIATE l_select_stmt INTO l_id, l_value USING p_Dim_Level_Value_Rec.Dimension_Level_Value_Name;
1257:
1258: IF (l_id IS NULL) THEN
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;

Line 1272: BIS_UTILITIES_PVT.Add_Error_Message

1268: x_Dim_Level_Value_Rec.Dimension_Level_Name := l_name;
1269: --
1270: ELSIF(p_Dim_Level_Value_Rec.Dimension_Level_Value_Name <> l_name) THEN
1271: -- populate error table
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;

Line 1288: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1292: WHEN FND_API.G_EXC_ERROR THEN

Line 1294: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1300: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1304: WHEN OTHERS THEN

Line 1306: BIS_UTILITIES_PVT.Add_Error_Message

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
1310: , x_error_table => x_error_Tbl

Line 1312: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1308: , p_error_msg_id => SQLCODE
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;

Line 1382: BIS_UTILITIES_PVT.Add_Error_Message

1378: USING p_Dim_Level_Value_Rec.Dimension_Level_Value_ID;
1379: END IF;
1380:
1381: IF l_period_set IS NULL THEN
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;

Line 1395: BIS_UTILITIES_PVT.Add_Error_Message

1391: x_Dim_Level_Value_Rec.Dimension_Level_Name := l_name;
1392: --
1393: ELSIF(p_Dim_Level_Value_Rec.Dimension_Level_Value_ID <> '-1') THEN
1394: -- populate error table
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;

Line 1411: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1415: WHEN FND_API.G_EXC_ERROR THEN

Line 1417: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1423: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1427: WHEN OTHERS THEN

Line 1429: BIS_UTILITIES_PVT.Add_Error_Message

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
1433: , x_error_table => x_error_Tbl

Line 1435: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1431: , p_error_msg_id => SQLCODE
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;

Line 1508: BIS_UTILITIES_PVT.Add_Error_Message

1504: --
1505: --
1506: IF(l_id IS NULL) THEN
1507: -- populate error table
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;

Line 1522: BIS_UTILITIES_PVT.Add_Error_Message

1518: x_Dim_Level_Value_Rec.Dimension_Level_Name := l_name;
1519: --
1520: ELSIF(p_Dim_Level_Value_Rec.Dimension_Level_Value_Name <> l_name) THEN
1521: -- populate error table
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;

Line 1538: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1542: WHEN FND_API.G_EXC_ERROR THEN

Line 1544: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1550: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1554: WHEN OTHERS THEN

Line 1556: BIS_UTILITIES_PVT.Add_Error_Message

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
1560: , x_error_table => x_error_Tbl

Line 1562: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1558: , p_error_msg_id => SQLCODE
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;

Line 1615: BIS_UTILITIES_PVT.Add_Error_Message

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
1619: , x_error_table => x_error_tbl

Line 1630: x_Dim_Level_Value_Rec.Dimension_Level_Value_Name := BIS_UTILITIES_PVT.GET_FND_MESSAGE( 'BIS_ALL_VALUE_ROLLING' ) ; -- 'All';

1626: IF(SUBSTR(l_short_name, 1, 5) <> 'TOTAL') THEN
1627:
1628: IF ( UPPER ( l_view_name ) = 'DUAL') then -- 2408906
1629:
1630: x_Dim_Level_Value_Rec.Dimension_Level_Value_Name := BIS_UTILITIES_PVT.GET_FND_MESSAGE( 'BIS_ALL_VALUE_ROLLING' ) ; -- 'All';
1631: x_Dim_Level_Value_Rec.Dimension_Level_Short_Name := l_short_name;
1632: x_Dim_Level_Value_Rec.Dimension_Level_Name := l_name;
1633:
1634: ELSE

Line 1644: ELSIF(BIS_UTILITIES_PVT.is_valid_time_dimension_level(p_Dim_Level_Value_Rec.Dimension_Level_ID, x_return_status) = TRUE) THEN

1640: (p_set_of_books_id IS NOT NULL)
1641: ) THEN
1642: l_select_stmt := l_select_stmt || ' AND SET_OF_BOOKS_ID = :2';
1643: EXECUTE IMMEDIATE l_select_stmt INTO l_id, l_value USING p_Dim_Level_Value_Rec.Dimension_Level_Value_Id, p_set_of_books_id;
1644: ELSIF(BIS_UTILITIES_PVT.is_valid_time_dimension_level(p_Dim_Level_Value_Rec.Dimension_Level_ID, x_return_status) = TRUE) THEN
1645: EXECUTE IMMEDIATE l_select_stmt INTO l_id, l_value, l_start_date, l_end_date USING p_Dim_Level_Value_Rec.Dimension_Level_Value_Id;
1646: ELSE
1647: EXECUTE IMMEDIATE l_select_stmt INTO l_id, l_value USING p_Dim_Level_Value_Rec.Dimension_Level_Value_Id;
1648: END IF;

Line 1651: BIS_UTILITIES_PVT.Add_Error_Message

1647: EXECUTE IMMEDIATE l_select_stmt INTO l_id, l_value USING p_Dim_Level_Value_Rec.Dimension_Level_Value_Id;
1648: END IF;
1649:
1650: IF (l_id IS NULL) THEN
1651: BIS_UTILITIES_PVT.Add_Error_Message
1652: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_VALUE_ID'
1653: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.DimensionX_ID_to_Value'
1654: , p_token1 => 'DIM_LEVEL_NAME'
1655: , p_value1 => l_name

Line 1671: BIS_UTILITIES_PVT.Add_Error_Message

1667:
1668: ELSIF(p_Dim_Level_Value_Rec.Dimension_Level_Value_ID <> '-1') THEN
1669: -- populate error table
1670: --added last two params
1671: BIS_UTILITIES_PVT.Add_Error_Message
1672: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_VALUE_ID'
1673: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.DimensionX_ID_to_Value'
1674: , p_token1 => 'DIM_LEVEL_NAME'
1675: , p_value1 => l_name

Line 1692: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1696: WHEN FND_API.G_EXC_ERROR THEN

Line 1698: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1704: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1708: WHEN OTHERS THEN

Line 1710: BIS_UTILITIES_PVT.Add_Error_Message

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
1714: , x_error_table => x_error_Tbl

Line 1716: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1712: , p_error_msg_id => SQLCODE
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;

Line 1762: BIS_UTILITIES_PVT.Add_Error_Message

1758: || ' WHERE Value = :1';
1759:
1760: EXECUTE IMMEDIATE l_select_stmt INTO l_id, l_value USING p_Dim_Level_Value_Rec.Dimension_Level_Value_Name;
1761: IF (l_id IS NULL) THEN
1762: BIS_UTILITIES_PVT.Add_Error_Message
1763: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_VALUE_NAME'
1764: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.DimensionX_Value_to_ID'
1765: , p_token1 => 'DIM_LEVEL_NAME'
1766: , p_value1 => l_name

Line 1776: BIS_UTILITIES_PVT.Add_Error_Message

1772: x_Dim_Level_Value_Rec.Dimension_Level_Name := l_name;
1773: --
1774: ELSIF(p_Dim_Level_Value_Rec.Dimension_Level_Value_Name <> l_name) THEN
1775: -- populate error table
1776: BIS_UTILITIES_PVT.Add_Error_Message
1777: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_VALUE_NAME'
1778: , p_error_proc_name => 'BIS_TARGET_VALIDATE_PVT.DimensionX_Value_to_ID'
1779: , p_token1 => 'DIM_LEVEL_NAME'
1780: , p_value1 => l_name

Line 1794: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1798: WHEN FND_API.G_EXC_ERROR THEN

Line 1800: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1806: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

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;
1810: WHEN OTHERS THEN

Line 1812: BIS_UTILITIES_PVT.Add_Error_Message

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
1816: , x_error_table => x_error_Tbl

Line 1818: IF(BIS_UTILITIES_PVT.G_DEBUG_FLAG = 1) THEN

1814: , p_error_msg_id => SQLCODE
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;

Line 1888: l_source := bis_utilities_pvt.GET_SOURCE_FROM_DIM_LEVEL

1884:
1885:
1886: l_level_id := p_Dim_Level_Value_Rec.Dimension_Level_ID;
1887:
1888: l_source := bis_utilities_pvt.GET_SOURCE_FROM_DIM_LEVEL
1889: (
1890: p_DimLevelId => l_level_id
1891: , p_DimLevelShortName => l_level_short_name -- l_level_name
1892: );

Line 1898: bis_utilities_pvt.Get_Org_Info_Based_On_Source

1894: BIS_UTILITIES_PUB.put_line(p_text =>' Source is '|| l_source );
1895:
1896:
1897: if ( l_source = 'OLTP' ) then
1898: bis_utilities_pvt.Get_Org_Info_Based_On_Source
1899: ( p_source => l_source,
1900: p_org_level_id => p_org_level_id,
1901: p_org_level_short_name => p_org_level_short_name,
1902: x_org_level_id => l_org_level_id,

Line 1922: bis_utilities_pvt.Get_Time_Level_Value_ID_Minus

1918: BIS_UTILITIES_PUB.put_line(p_text => ' ERROR: Is_Current_Time_Period : source can be only either OLTP or EDW ' );
1919: end if;
1920:
1921:
1922: bis_utilities_pvt.Get_Time_Level_Value_ID_Minus
1923: ( p_source => l_source,
1924: p_view_name => l_view_name,
1925: p_id_name => l_id_name,
1926: p_org_level_id => l_org_level_id,

Line 2027: l_source := bis_utilities_pvt.GET_SOURCE_FROM_DIM_LEVEL

2023: );
2024:
2025: l_level_id := p_Dim_Level_Value_Rec.Dimension_Level_ID;
2026:
2027: l_source := bis_utilities_pvt.GET_SOURCE_FROM_DIM_LEVEL
2028: (
2029: p_DimLevelId => l_level_id
2030: , p_DimLevelShortName => l_level_short_name -- l_level_name
2031: );

Line 2037: bis_utilities_pvt.Get_Org_Info_Based_On_Source

2033: l_text := l_text || ' Source is '|| l_source;
2034:
2035:
2036: if ( l_source = 'OLTP' ) then
2037: bis_utilities_pvt.Get_Org_Info_Based_On_Source
2038: ( p_source => l_source,
2039: p_org_level_id => p_org_level_id,
2040: p_org_level_short_name => p_org_level_short_name,
2041: x_org_level_id => l_org_level_id,

Line 2053: bis_utilities_pvt.Get_Time_Level_Value_ID_Minus

2049: l_text := l_text || ' ERROR: Is_Current_Time_Period : source can be only either OLTP or EDW ';
2050: end if;
2051:
2052:
2053: bis_utilities_pvt.Get_Time_Level_Value_ID_Minus
2054: ( p_source => l_source,
2055: p_view_name => l_view_name,
2056: p_id_name => l_id_name,
2057: p_org_level_id => l_org_level_id,

Line 2064: bis_utilities_pvt.Get_Start_End_Dates

2060: x_time_id => l_time_id
2061: );
2062:
2063:
2064: bis_utilities_pvt.Get_Start_End_Dates
2065: ( p_source => l_source,
2066: p_view_name => l_view_name,
2067: p_id_col_name => l_id_name,
2068: p_id_value_name => l_time_id,

Line 2079: bis_utilities_pvt.Get_Time_Level_Value_ID_Date

2075:
2076: l_time_id := NULL;
2077:
2078:
2079: bis_utilities_pvt.Get_Time_Level_Value_ID_Date
2080: ( p_source => l_source,
2081: p_view_name => l_view_name,
2082: p_id_name => l_id_name,
2083: p_org_level_id => l_org_level_id,