212: --
213: BEGIN
214:
215: bis_debug_pub.Add('> parse_DF_Column_Line');
216: x_return_status := FND_API.G_RET_STS_SUCCESS;
217: -- get row of text from table
218: l_string := bis_vg_util.get_row ( p_View_Column_Table
219: , p_Column_Pointer
220: , x_return_status
346: bis_debug_pub.Add('< parse_DF_Column_Line');
347: --
348:
349: EXCEPTION
350: when FND_API.G_EXC_ERROR then
351: x_return_status := FND_API.G_RET_STS_ERROR ;
352: RAISE FND_API.G_EXC_ERROR;
353: when FND_API.G_EXC_UNEXPECTED_ERROR then
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: --
348:
349: EXCEPTION
350: when FND_API.G_EXC_ERROR then
351: x_return_status := FND_API.G_RET_STS_ERROR ;
352: RAISE FND_API.G_EXC_ERROR;
353: when FND_API.G_EXC_UNEXPECTED_ERROR then
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348:
349: EXCEPTION
350: when FND_API.G_EXC_ERROR then
351: x_return_status := FND_API.G_RET_STS_ERROR ;
352: RAISE FND_API.G_EXC_ERROR;
353: when FND_API.G_EXC_UNEXPECTED_ERROR then
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: when others then
349: EXCEPTION
350: when FND_API.G_EXC_ERROR then
351: x_return_status := FND_API.G_RET_STS_ERROR ;
352: RAISE FND_API.G_EXC_ERROR;
353: when FND_API.G_EXC_UNEXPECTED_ERROR then
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: when others then
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
350: when FND_API.G_EXC_ERROR then
351: x_return_status := FND_API.G_RET_STS_ERROR ;
352: RAISE FND_API.G_EXC_ERROR;
353: when FND_API.G_EXC_UNEXPECTED_ERROR then
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: when others then
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358: BIS_VG_UTIL.Add_Error_Message
351: x_return_status := FND_API.G_RET_STS_ERROR ;
352: RAISE FND_API.G_EXC_ERROR;
353: when FND_API.G_EXC_UNEXPECTED_ERROR then
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: when others then
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358: BIS_VG_UTIL.Add_Error_Message
359: ( p_error_msg_id => SQLCODE
353: when FND_API.G_EXC_UNEXPECTED_ERROR then
354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: when others then
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
358: BIS_VG_UTIL.Add_Error_Message
359: ( p_error_msg_id => SQLCODE
360: , p_error_description => SQLERRM
361: , p_error_proc_name => G_PKG_NAME||'.parse_DF_Column_Line'
365: bis_vg_log.update_failure_log( x_error_tbl
366: , x_return_status
367: , x_error_Tbl
368: );
369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
370:
371: END parse_DF_Column_Line;
372: --
373: -- ============================================================================
435: l_tmp_pointer bis_vg_types.View_Character_Pointer_Type;
436: --
437: BEGIN
438: bis_debug_pub.Add('> parse_DF_Select_Line');
439: x_return_status := FND_API.G_RET_STS_SUCCESS;
440: -- get '_DF'
441: l_whole_tag := bis_vg_parser.get_token_increment_pointer
442: ( p_View_Select_Table
443: , p_Select_Pointer
480: bis_vg_log.update_failure_log( x_error_tbl
481: , x_return_status
482: , x_error_Tbl
483: );
484: RAISE FND_API.G_EXC_ERROR;
485: END IF;
486:
487: x_Application_Name := bis_vg_parser.get_token_increment_pointer
488: ( p_View_Select_Table
515: bis_vg_log.update_failure_log( x_error_tbl
516: , x_return_status
517: , x_error_Tbl
518: );
519: RAISE FND_API.G_EXC_ERROR;
520: END IF;
521:
522: --EDW flag change
523:
569: bis_vg_log.update_failure_log( x_error_tbl
570: , x_return_status
571: , x_error_Tbl
572: );
573: RAISE FND_API.G_EXC_ERROR;
574:
575: END IF;
576:
577: bis_debug_pub.Add('x_Desc_Flex_Name = ' || x_Desc_Flex_Name);
608: bis_vg_log.update_failure_log( x_error_tbl
609: , x_return_status
610: , x_error_Tbl
611: );
612: RAISE FND_API.G_EXC_ERROR;
613: END IF;
614:
615: IF check_application_validity(x_Application_Name)
616: THEN
636: bis_vg_log.update_failure_log( x_error_tbl
637: , x_return_status
638: , x_error_Tbl
639: );
640: RAISE FND_API.G_EXC_ERROR;
641:
642: END IF;
643:
644: --
643:
644: --
645: EXCEPTION
646: when
647: FND_API.G_EXC_ERROR then
648: x_return_status := FND_API.G_RET_STS_ERROR ;
649: RAISE FND_API.G_EXC_ERROR;
650: when FND_API.G_EXC_UNEXPECTED_ERROR then
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
644: --
645: EXCEPTION
646: when
647: FND_API.G_EXC_ERROR then
648: x_return_status := FND_API.G_RET_STS_ERROR ;
649: RAISE FND_API.G_EXC_ERROR;
650: when FND_API.G_EXC_UNEXPECTED_ERROR then
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: EXCEPTION
646: when
647: FND_API.G_EXC_ERROR then
648: x_return_status := FND_API.G_RET_STS_ERROR ;
649: RAISE FND_API.G_EXC_ERROR;
650: when FND_API.G_EXC_UNEXPECTED_ERROR then
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: when others then
646: when
647: FND_API.G_EXC_ERROR then
648: x_return_status := FND_API.G_RET_STS_ERROR ;
649: RAISE FND_API.G_EXC_ERROR;
650: when FND_API.G_EXC_UNEXPECTED_ERROR then
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: when others then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
647: FND_API.G_EXC_ERROR then
648: x_return_status := FND_API.G_RET_STS_ERROR ;
649: RAISE FND_API.G_EXC_ERROR;
650: when FND_API.G_EXC_UNEXPECTED_ERROR then
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: when others then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: BIS_VG_UTIL.Add_Error_Message
648: x_return_status := FND_API.G_RET_STS_ERROR ;
649: RAISE FND_API.G_EXC_ERROR;
650: when FND_API.G_EXC_UNEXPECTED_ERROR then
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: when others then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: BIS_VG_UTIL.Add_Error_Message
656: ( p_error_msg_id => SQLCODE
650: when FND_API.G_EXC_UNEXPECTED_ERROR then
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: when others then
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: BIS_VG_UTIL.Add_Error_Message
656: ( p_error_msg_id => SQLCODE
657: , p_error_description => SQLERRM
658: , p_error_proc_name => G_PKG_NAME||'.parse_DF_Select_Line'
662: bis_vg_log.update_failure_log( x_error_tbl
663: , x_return_status
664: , x_error_Tbl
665: );
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667:
668: END parse_DF_Select_Line;
669: --
670: -- =============================================================================
725: cv CurType;
726: --
727: BEGIN
728: bis_debug_pub.Add('> add_desc_flexfield_segments');
729: x_return_status := FND_API.G_RET_STS_SUCCESS;
730: IF(p_Prefix IS NOT NULL) THEN
731: l_prefix := p_Prefix || '_';
732: END IF;
733:
863: END IF;
864: bis_debug_pub.Add('< add_desc_flexfield_segments');
865: --
866: EXCEPTION
867: when FND_API.G_EXC_ERROR then
868: x_return_status := FND_API.G_RET_STS_ERROR ;
869: RAISE FND_API.G_EXC_ERROR;
870: when FND_API.G_EXC_UNEXPECTED_ERROR then
871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
864: bis_debug_pub.Add('< add_desc_flexfield_segments');
865: --
866: EXCEPTION
867: when FND_API.G_EXC_ERROR then
868: x_return_status := FND_API.G_RET_STS_ERROR ;
869: RAISE FND_API.G_EXC_ERROR;
870: when FND_API.G_EXC_UNEXPECTED_ERROR then
871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
865: --
866: EXCEPTION
867: when FND_API.G_EXC_ERROR then
868: x_return_status := FND_API.G_RET_STS_ERROR ;
869: RAISE FND_API.G_EXC_ERROR;
870: when FND_API.G_EXC_UNEXPECTED_ERROR then
871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
873: when others then
866: EXCEPTION
867: when FND_API.G_EXC_ERROR then
868: x_return_status := FND_API.G_RET_STS_ERROR ;
869: RAISE FND_API.G_EXC_ERROR;
870: when FND_API.G_EXC_UNEXPECTED_ERROR then
871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
873: when others then
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
867: when FND_API.G_EXC_ERROR then
868: x_return_status := FND_API.G_RET_STS_ERROR ;
869: RAISE FND_API.G_EXC_ERROR;
870: when FND_API.G_EXC_UNEXPECTED_ERROR then
871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
873: when others then
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
875: BIS_VG_UTIL.Add_Error_Message
868: x_return_status := FND_API.G_RET_STS_ERROR ;
869: RAISE FND_API.G_EXC_ERROR;
870: when FND_API.G_EXC_UNEXPECTED_ERROR then
871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
873: when others then
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
875: BIS_VG_UTIL.Add_Error_Message
876: ( p_error_msg_id => SQLCODE
870: when FND_API.G_EXC_UNEXPECTED_ERROR then
871: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
873: when others then
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
875: BIS_VG_UTIL.Add_Error_Message
876: ( p_error_msg_id => SQLCODE
877: , p_error_description => SQLERRM
878: , p_error_proc_name => G_PKG_NAME||'.add_desc_flexfield_segments'
882: bis_vg_log.update_failure_log( x_error_tbl
883: , x_return_status
884: , x_error_Tbl
885: );
886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
887:
888: END add_desc_flexfield_segments;
889: --
890: -- =============================================================================
963: if FND_INSTALLATION.GET_APP_INFO(p_Application_Name,l_dummy1, l_dummy2,l_schema) = false then
964: bis_debug_pub.Add('FND_INSTALLATION.GET_APP_INFO returned with error');
965: end if;
966:
967: x_return_status := FND_API.G_RET_STS_SUCCESS;
968: FND_DFLEX.GET_FLEXFIELD( appl_short_name => p_Application_Name
969: , flexfield_name => p_Desc_Flex_Name
970: , flexfield => l_flexfield
971: , flexinfo => l_flexinfo
1127: --- bis_debug_pub.debug_off;
1128: --
1129:
1130: EXCEPTION
1131: when FND_API.G_EXC_ERROR then
1132: x_return_status := FND_API.G_RET_STS_ERROR ;
1133: RAISE FND_API.G_EXC_ERROR;
1134: when FND_API.G_EXC_UNEXPECTED_ERROR then
1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1128: --
1129:
1130: EXCEPTION
1131: when FND_API.G_EXC_ERROR then
1132: x_return_status := FND_API.G_RET_STS_ERROR ;
1133: RAISE FND_API.G_EXC_ERROR;
1134: when FND_API.G_EXC_UNEXPECTED_ERROR then
1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1129:
1130: EXCEPTION
1131: when FND_API.G_EXC_ERROR then
1132: x_return_status := FND_API.G_RET_STS_ERROR ;
1133: RAISE FND_API.G_EXC_ERROR;
1134: when FND_API.G_EXC_UNEXPECTED_ERROR then
1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: when others then
1130: EXCEPTION
1131: when FND_API.G_EXC_ERROR then
1132: x_return_status := FND_API.G_RET_STS_ERROR ;
1133: RAISE FND_API.G_EXC_ERROR;
1134: when FND_API.G_EXC_UNEXPECTED_ERROR then
1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: when others then
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1131: when FND_API.G_EXC_ERROR then
1132: x_return_status := FND_API.G_RET_STS_ERROR ;
1133: RAISE FND_API.G_EXC_ERROR;
1134: when FND_API.G_EXC_UNEXPECTED_ERROR then
1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: when others then
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1139: BIS_VG_UTIL.Add_Error_Message
1132: x_return_status := FND_API.G_RET_STS_ERROR ;
1133: RAISE FND_API.G_EXC_ERROR;
1134: when FND_API.G_EXC_UNEXPECTED_ERROR then
1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: when others then
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1139: BIS_VG_UTIL.Add_Error_Message
1140: ( p_error_msg_id => SQLCODE
1134: when FND_API.G_EXC_UNEXPECTED_ERROR then
1135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: when others then
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1139: BIS_VG_UTIL.Add_Error_Message
1140: ( p_error_msg_id => SQLCODE
1141: , p_error_description => SQLERRM
1142: , p_error_proc_name => G_PKG_NAME||'.update_Desc_Flex_Tables'
1146: bis_vg_log.update_failure_log( x_error_tbl
1147: , x_return_status
1148: , x_error_Tbl
1149: );
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151:
1152:
1153: END update_Desc_Flex_Tables;
1154: --
1213: l_EDW_Flag BOOLEAN; --EDW flag change
1214: l_DUMMY_Flag BOOLEAN; --EDW flag change
1215: BEGIN
1216: bis_debug_pub.Add('> add_Desc_Flex_Info');
1217: x_return_status := FND_API.G_RET_STS_SUCCESS;
1218:
1219: parse_DF_Column_Line( p_View_Column_Table
1220: , p_Column_Pointer
1221: , x_Column_Pointer
1298:
1299: EXCEPTION
1300: when bis_view_generator_pvt.cannot_prune_non_edw_view THEN
1301: RAISE; -- same exception
1302: when FND_API.G_EXC_ERROR then
1303: x_return_status := FND_API.G_RET_STS_ERROR ;
1304: RAISE; -- same exception
1305: when FND_API.G_EXC_UNEXPECTED_ERROR then
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1299: EXCEPTION
1300: when bis_view_generator_pvt.cannot_prune_non_edw_view THEN
1301: RAISE; -- same exception
1302: when FND_API.G_EXC_ERROR then
1303: x_return_status := FND_API.G_RET_STS_ERROR ;
1304: RAISE; -- same exception
1305: when FND_API.G_EXC_UNEXPECTED_ERROR then
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1307: RAISE; -- same exception
1301: RAISE; -- same exception
1302: when FND_API.G_EXC_ERROR then
1303: x_return_status := FND_API.G_RET_STS_ERROR ;
1304: RAISE; -- same exception
1305: when FND_API.G_EXC_UNEXPECTED_ERROR then
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1307: RAISE; -- same exception
1308: when others then
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1302: when FND_API.G_EXC_ERROR then
1303: x_return_status := FND_API.G_RET_STS_ERROR ;
1304: RAISE; -- same exception
1305: when FND_API.G_EXC_UNEXPECTED_ERROR then
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1307: RAISE; -- same exception
1308: when others then
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1310: BIS_VG_UTIL.Add_Error_Message
1305: when FND_API.G_EXC_UNEXPECTED_ERROR then
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1307: RAISE; -- same exception
1308: when others then
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1310: BIS_VG_UTIL.Add_Error_Message
1311: ( p_error_msg_id => SQLCODE
1312: , p_error_description => SQLERRM
1313: , p_error_proc_name => G_PKG_NAME||'.add_Desc_Flex_Info'
1317: bis_vg_log.update_failure_log( x_error_tbl
1318: , x_return_status
1319: , x_error_Tbl
1320: );
1321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1322:
1323:
1324: END add_Desc_Flex_Info;
1325: --