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

Line 225: x_return_status := FND_API.G_RET_STS_SUCCESS;

221: l_char VARCHAR2(1);
222: BEGIN
223: l_done := FALSE;
224: bis_debug_pub.Add('> get_tag_keyword_position');
225: x_return_status := FND_API.G_RET_STS_SUCCESS;
226: l_pointer := p_start_pointer;
227: WHILE (NOT l_done) LOOP
228: l_pointer := bis_vg_parser.get_keyword_position
229: ( p_view_table

Line 273: when FND_API.G_EXC_ERROR then

269: RETURN l_pointer;
270: --
271: --
272: EXCEPTION
273: when FND_API.G_EXC_ERROR then
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: RAISE FND_API.G_EXC_ERROR;
276: when FND_API.G_EXC_UNEXPECTED_ERROR then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 274: x_return_status := FND_API.G_RET_STS_ERROR ;

270: --
271: --
272: EXCEPTION
273: when FND_API.G_EXC_ERROR then
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: RAISE FND_API.G_EXC_ERROR;
276: when FND_API.G_EXC_UNEXPECTED_ERROR then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 275: RAISE FND_API.G_EXC_ERROR;

271: --
272: EXCEPTION
273: when FND_API.G_EXC_ERROR then
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: RAISE FND_API.G_EXC_ERROR;
276: when FND_API.G_EXC_UNEXPECTED_ERROR then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: when others then

Line 276: when FND_API.G_EXC_UNEXPECTED_ERROR then

272: EXCEPTION
273: when FND_API.G_EXC_ERROR then
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: RAISE FND_API.G_EXC_ERROR;
276: when FND_API.G_EXC_UNEXPECTED_ERROR then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: when others then
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

273: when FND_API.G_EXC_ERROR then
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: RAISE FND_API.G_EXC_ERROR;
276: when FND_API.G_EXC_UNEXPECTED_ERROR then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: when others then
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: BIS_VG_UTIL.Add_Error_Message

Line 278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: RAISE FND_API.G_EXC_ERROR;
276: when FND_API.G_EXC_UNEXPECTED_ERROR then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: when others then
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: BIS_VG_UTIL.Add_Error_Message
282: ( p_error_msg_id => SQLCODE

Line 280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

276: when FND_API.G_EXC_UNEXPECTED_ERROR then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: when others then
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: BIS_VG_UTIL.Add_Error_Message
282: ( p_error_msg_id => SQLCODE
283: , p_error_description => SQLERRM
284: , p_error_proc_name => G_PKG_NAME||'.get_tag_keyword_position'

Line 288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

284: , p_error_proc_name => G_PKG_NAME||'.get_tag_keyword_position'
285: , p_error_table => x_error_tbl
286: , x_error_table => x_error_tbl
287: );
288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
289: END get_tag_keyword_position;
290: --
291: -- ============================================================================
292: --PROCEDURE : Update_Flexfields

Line 339: x_return_status := FND_API.G_RET_STS_SUCCESS;

335: l_col NUMBER;
336: BEGIN
337: --
338: bis_debug_pub.Add('> update_flexfields');
339: x_return_status := FND_API.G_RET_STS_SUCCESS;
340: --
341: --- --- --- DEBUG ---
342: --- bis_vg_util.print_view_pointer ( p_select_pointer
343: --- , x_return_status

Line 400: RAISE FND_API.G_EXC_ERROR;

396: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
397: , p_error_table => x_error_tbl
398: , x_error_table => x_error_tbl
399: );
400: RAISE FND_API.G_EXC_ERROR;
401:
402: END IF;
403: ---
404: bis_debug_pub.Add('l_str = '||l_str);

Line 472: when FND_API.G_EXC_ERROR then

468: END IF;
469: bis_debug_pub.Add('< update_flexfields');
470: --
471: EXCEPTION
472: when FND_API.G_EXC_ERROR then
473: x_return_status := FND_API.G_RET_STS_ERROR ;
474: RAISE FND_API.G_EXC_ERROR;
475: when FND_API.G_EXC_UNEXPECTED_ERROR then
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 473: x_return_status := FND_API.G_RET_STS_ERROR ;

469: bis_debug_pub.Add('< update_flexfields');
470: --
471: EXCEPTION
472: when FND_API.G_EXC_ERROR then
473: x_return_status := FND_API.G_RET_STS_ERROR ;
474: RAISE FND_API.G_EXC_ERROR;
475: when FND_API.G_EXC_UNEXPECTED_ERROR then
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 474: RAISE FND_API.G_EXC_ERROR;

470: --
471: EXCEPTION
472: when FND_API.G_EXC_ERROR then
473: x_return_status := FND_API.G_RET_STS_ERROR ;
474: RAISE FND_API.G_EXC_ERROR;
475: when FND_API.G_EXC_UNEXPECTED_ERROR then
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: when others then

Line 475: when FND_API.G_EXC_UNEXPECTED_ERROR then

471: EXCEPTION
472: when FND_API.G_EXC_ERROR then
473: x_return_status := FND_API.G_RET_STS_ERROR ;
474: RAISE FND_API.G_EXC_ERROR;
475: when FND_API.G_EXC_UNEXPECTED_ERROR then
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: when others then
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

472: when FND_API.G_EXC_ERROR then
473: x_return_status := FND_API.G_RET_STS_ERROR ;
474: RAISE FND_API.G_EXC_ERROR;
475: when FND_API.G_EXC_UNEXPECTED_ERROR then
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: when others then
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
480: BIS_VG_UTIL.Add_Error_Message

Line 477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

473: x_return_status := FND_API.G_RET_STS_ERROR ;
474: RAISE FND_API.G_EXC_ERROR;
475: when FND_API.G_EXC_UNEXPECTED_ERROR then
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: when others then
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
480: BIS_VG_UTIL.Add_Error_Message
481: ( p_error_msg_id => SQLCODE

Line 479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

475: when FND_API.G_EXC_UNEXPECTED_ERROR then
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: when others then
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
480: BIS_VG_UTIL.Add_Error_Message
481: ( p_error_msg_id => SQLCODE
482: , p_error_description => SQLERRM
483: , p_error_proc_name => G_PKG_NAME||'. update_flexfields'

Line 487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

483: , p_error_proc_name => G_PKG_NAME||'. update_flexfields'
484: , p_error_table => x_error_tbl
485: , x_error_table => x_error_tbl
486: );
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: --
489: END update_flexfields;
490: --
491: -- ============================================================================

Line 520: x_return_status := FND_API.G_RET_STS_SUCCESS;

516: l_select_pointer bis_vg_types.view_character_pointer_type;
517: --
518: BEGIN
519: bis_debug_pub.Add('> exclude_comma');
520: x_return_status := FND_API.G_RET_STS_SUCCESS;
521: l_select_pointer := p_Select_Pointer;
522: WHILE( bis_vg_util.get_char( p_View_Select_Text_Table
523: , l_select_pointer
524: , x_return_status

Line 566: when FND_API.G_EXC_ERROR then

562: END IF;
563: bis_debug_pub.Add('< exclude_comma_before_tag');
564: RETURN 1;
565: EXCEPTION
566: when FND_API.G_EXC_ERROR then
567: x_return_status := FND_API.G_RET_STS_ERROR ;
568: RAISE FND_API.G_EXC_ERROR;
569: when FND_API.G_EXC_UNEXPECTED_ERROR then
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 567: x_return_status := FND_API.G_RET_STS_ERROR ;

563: bis_debug_pub.Add('< exclude_comma_before_tag');
564: RETURN 1;
565: EXCEPTION
566: when FND_API.G_EXC_ERROR then
567: x_return_status := FND_API.G_RET_STS_ERROR ;
568: RAISE FND_API.G_EXC_ERROR;
569: when FND_API.G_EXC_UNEXPECTED_ERROR then
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 568: RAISE FND_API.G_EXC_ERROR;

564: RETURN 1;
565: EXCEPTION
566: when FND_API.G_EXC_ERROR then
567: x_return_status := FND_API.G_RET_STS_ERROR ;
568: RAISE FND_API.G_EXC_ERROR;
569: when FND_API.G_EXC_UNEXPECTED_ERROR then
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: when others then

Line 569: when FND_API.G_EXC_UNEXPECTED_ERROR then

565: EXCEPTION
566: when FND_API.G_EXC_ERROR then
567: x_return_status := FND_API.G_RET_STS_ERROR ;
568: RAISE FND_API.G_EXC_ERROR;
569: when FND_API.G_EXC_UNEXPECTED_ERROR then
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: when others then
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

566: when FND_API.G_EXC_ERROR then
567: x_return_status := FND_API.G_RET_STS_ERROR ;
568: RAISE FND_API.G_EXC_ERROR;
569: when FND_API.G_EXC_UNEXPECTED_ERROR then
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: when others then
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
574: BIS_VG_UTIL.Add_Error_Message

Line 571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

567: x_return_status := FND_API.G_RET_STS_ERROR ;
568: RAISE FND_API.G_EXC_ERROR;
569: when FND_API.G_EXC_UNEXPECTED_ERROR then
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: when others then
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
574: BIS_VG_UTIL.Add_Error_Message
575: ( p_error_msg_id => SQLCODE

Line 573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

569: when FND_API.G_EXC_UNEXPECTED_ERROR then
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: when others then
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
574: BIS_VG_UTIL.Add_Error_Message
575: ( p_error_msg_id => SQLCODE
576: , p_error_description => SQLERRM
577: , p_error_proc_name => G_PKG_NAME||'. exclude_comma_before_tag'

Line 581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

577: , p_error_proc_name => G_PKG_NAME||'. exclude_comma_before_tag'
578: , p_error_table => x_error_tbl
579: , x_error_table => x_error_tbl
580: );
581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
582: END exclude_comma_before_tag;
583: --
584: -- ============================================================================
585: --PROCEDURE : exclude_comma_after_tag

Line 612: x_return_status := FND_API.G_RET_STS_SUCCESS;

608: l_select_pointer bis_vg_types.view_character_pointer_type;
609: --
610: BEGIN
611: bis_debug_pub.Add('> exclude_comma_after_tag');
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613: l_select_pointer := p_Select_Pointer;
614: WHILE( bis_vg_util.get_char( p_View_Select_Text_Table
615: , l_select_pointer
616: , x_return_status

Line 659: when FND_API.G_EXC_ERROR then

655: END IF;
656: bis_debug_pub.Add('< exclude_comma_after_tag');
657:
658: EXCEPTION
659: when FND_API.G_EXC_ERROR then
660: x_return_status := FND_API.G_RET_STS_ERROR ;
661: RAISE FND_API.G_EXC_ERROR;
662: when FND_API.G_EXC_UNEXPECTED_ERROR then
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 660: x_return_status := FND_API.G_RET_STS_ERROR ;

656: bis_debug_pub.Add('< exclude_comma_after_tag');
657:
658: EXCEPTION
659: when FND_API.G_EXC_ERROR then
660: x_return_status := FND_API.G_RET_STS_ERROR ;
661: RAISE FND_API.G_EXC_ERROR;
662: when FND_API.G_EXC_UNEXPECTED_ERROR then
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 661: RAISE FND_API.G_EXC_ERROR;

657:
658: EXCEPTION
659: when FND_API.G_EXC_ERROR then
660: x_return_status := FND_API.G_RET_STS_ERROR ;
661: RAISE FND_API.G_EXC_ERROR;
662: when FND_API.G_EXC_UNEXPECTED_ERROR then
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
665: when others then

Line 662: when FND_API.G_EXC_UNEXPECTED_ERROR then

658: EXCEPTION
659: when FND_API.G_EXC_ERROR then
660: x_return_status := FND_API.G_RET_STS_ERROR ;
661: RAISE FND_API.G_EXC_ERROR;
662: when FND_API.G_EXC_UNEXPECTED_ERROR then
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
665: when others then
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

659: when FND_API.G_EXC_ERROR then
660: x_return_status := FND_API.G_RET_STS_ERROR ;
661: RAISE FND_API.G_EXC_ERROR;
662: when FND_API.G_EXC_UNEXPECTED_ERROR then
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
665: when others then
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
667: BIS_VG_UTIL.Add_Error_Message

Line 664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

660: x_return_status := FND_API.G_RET_STS_ERROR ;
661: RAISE FND_API.G_EXC_ERROR;
662: when FND_API.G_EXC_UNEXPECTED_ERROR then
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
665: when others then
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
667: BIS_VG_UTIL.Add_Error_Message
668: ( p_error_msg_id => SQLCODE

Line 666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

662: when FND_API.G_EXC_UNEXPECTED_ERROR then
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
665: when others then
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
667: BIS_VG_UTIL.Add_Error_Message
668: ( p_error_msg_id => SQLCODE
669: , p_error_description => SQLERRM
670: , p_error_proc_name => G_PKG_NAME||'. exclude_comma_after_tag'

Line 674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

670: , p_error_proc_name => G_PKG_NAME||'. exclude_comma_after_tag'
671: , p_error_table => x_error_tbl
672: , x_error_table => x_error_tbl
673: );
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END exclude_comma_after_tag;
676:
677:
678: --- ========================================================================

Line 753: when FND_API.G_EXC_ERROR then

749:
750: bis_debug_pub.Add('< Get_base_Table_Cols');
751:
752: EXCEPTION
753: when FND_API.G_EXC_ERROR then
754: RAISE FND_API.G_EXC_ERROR;
755: when FND_API.G_EXC_UNEXPECTED_ERROR then
756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: when others then

Line 754: RAISE FND_API.G_EXC_ERROR;

750: bis_debug_pub.Add('< Get_base_Table_Cols');
751:
752: EXCEPTION
753: when FND_API.G_EXC_ERROR then
754: RAISE FND_API.G_EXC_ERROR;
755: when FND_API.G_EXC_UNEXPECTED_ERROR then
756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: when others then
758: BIS_VG_UTIL.Add_Error_Message

Line 755: when FND_API.G_EXC_UNEXPECTED_ERROR then

751:
752: EXCEPTION
753: when FND_API.G_EXC_ERROR then
754: RAISE FND_API.G_EXC_ERROR;
755: when FND_API.G_EXC_UNEXPECTED_ERROR then
756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: when others then
758: BIS_VG_UTIL.Add_Error_Message
759: ( p_error_msg_id => SQLCODE

Line 756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

752: EXCEPTION
753: when FND_API.G_EXC_ERROR then
754: RAISE FND_API.G_EXC_ERROR;
755: when FND_API.G_EXC_UNEXPECTED_ERROR then
756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: when others then
758: BIS_VG_UTIL.Add_Error_Message
759: ( p_error_msg_id => SQLCODE
760: , p_error_description => SQLERRM

Line 765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

761: , p_error_proc_name => G_PKG_NAME||'.Get_base_Table_Cols'
762: , p_error_table => x_error_tbl
763: , x_error_table => x_error_tbl
764: );
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END Get_base_Table_Cols;
767:
768:
769: --- ========================================================================

Line 935: when FND_API.G_EXC_ERROR then

931: bis_debug_pub.Add('< Get_Base_Table_Selects');
932:
933:
934: EXCEPTION
935: when FND_API.G_EXC_ERROR then
936: RAISE FND_API.G_EXC_ERROR;
937: when FND_API.G_EXC_UNEXPECTED_ERROR then
938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
939: when others then

Line 936: RAISE FND_API.G_EXC_ERROR;

932:
933:
934: EXCEPTION
935: when FND_API.G_EXC_ERROR then
936: RAISE FND_API.G_EXC_ERROR;
937: when FND_API.G_EXC_UNEXPECTED_ERROR then
938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
939: when others then
940: BIS_VG_UTIL.Add_Error_Message

Line 937: when FND_API.G_EXC_UNEXPECTED_ERROR then

933:
934: EXCEPTION
935: when FND_API.G_EXC_ERROR then
936: RAISE FND_API.G_EXC_ERROR;
937: when FND_API.G_EXC_UNEXPECTED_ERROR then
938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
939: when others then
940: BIS_VG_UTIL.Add_Error_Message
941: ( p_error_msg_id => SQLCODE

Line 938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

934: EXCEPTION
935: when FND_API.G_EXC_ERROR then
936: RAISE FND_API.G_EXC_ERROR;
937: when FND_API.G_EXC_UNEXPECTED_ERROR then
938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
939: when others then
940: BIS_VG_UTIL.Add_Error_Message
941: ( p_error_msg_id => SQLCODE
942: , p_error_description => SQLERRM

Line 947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; END get_base_table_selects;

943: , p_error_proc_name => G_PKG_NAME||'.Get_Base_Table_Selects'
944: , p_error_table => x_error_tbl
945: , x_error_table => x_error_tbl
946: );
947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; END get_base_table_selects;
948:
949: --- ========================================================================
950: --- PROCEDURE : Update_View
951: --- PARAMETERS:

Line 1015: --- x_return_status := FND_API.G_RET_STS_SUCCESS;

1011: BEGIN
1012: --
1013: l_in_union := FALSE;
1014: bis_debug_pub.Add('> Update_View');
1015: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
1016:
1017:
1018:
1019:

Line 1590: when FND_API.G_EXC_ERROR then

1586: --- );
1587: bis_debug_pub.Add('< Update_View');
1588: --
1589: EXCEPTION
1590: when FND_API.G_EXC_ERROR then
1591: bis_debug_pub.add('x_error_tbl.count = '||x_error_tbl.count);
1592: --- x_return_status := FND_API.G_RET_STS_ERROR ;
1593: RAISE FND_API.G_EXC_ERROR;
1594: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1592: --- x_return_status := FND_API.G_RET_STS_ERROR ;

1588: --
1589: EXCEPTION
1590: when FND_API.G_EXC_ERROR then
1591: bis_debug_pub.add('x_error_tbl.count = '||x_error_tbl.count);
1592: --- x_return_status := FND_API.G_RET_STS_ERROR ;
1593: RAISE FND_API.G_EXC_ERROR;
1594: when FND_API.G_EXC_UNEXPECTED_ERROR then
1595: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1593: RAISE FND_API.G_EXC_ERROR;

1589: EXCEPTION
1590: when FND_API.G_EXC_ERROR then
1591: bis_debug_pub.add('x_error_tbl.count = '||x_error_tbl.count);
1592: --- x_return_status := FND_API.G_RET_STS_ERROR ;
1593: RAISE FND_API.G_EXC_ERROR;
1594: when FND_API.G_EXC_UNEXPECTED_ERROR then
1595: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597: when others then

Line 1594: when FND_API.G_EXC_UNEXPECTED_ERROR then

1590: when FND_API.G_EXC_ERROR then
1591: bis_debug_pub.add('x_error_tbl.count = '||x_error_tbl.count);
1592: --- x_return_status := FND_API.G_RET_STS_ERROR ;
1593: RAISE FND_API.G_EXC_ERROR;
1594: when FND_API.G_EXC_UNEXPECTED_ERROR then
1595: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597: when others then
1598: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1595: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1591: bis_debug_pub.add('x_error_tbl.count = '||x_error_tbl.count);
1592: --- x_return_status := FND_API.G_RET_STS_ERROR ;
1593: RAISE FND_API.G_EXC_ERROR;
1594: when FND_API.G_EXC_UNEXPECTED_ERROR then
1595: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597: when others then
1598: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1599: BIS_VG_UTIL.Add_Error_Message

Line 1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1592: --- x_return_status := FND_API.G_RET_STS_ERROR ;
1593: RAISE FND_API.G_EXC_ERROR;
1594: when FND_API.G_EXC_UNEXPECTED_ERROR then
1595: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597: when others then
1598: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1599: BIS_VG_UTIL.Add_Error_Message
1600: ( p_error_msg_id => SQLCODE

Line 1598: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1594: when FND_API.G_EXC_UNEXPECTED_ERROR then
1595: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597: when others then
1598: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1599: BIS_VG_UTIL.Add_Error_Message
1600: ( p_error_msg_id => SQLCODE
1601: , p_error_description => SQLERRM
1602: , p_error_proc_name => G_PKG_NAME||'.Update_View'

Line 1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1602: , p_error_proc_name => G_PKG_NAME||'.Update_View'
1603: , p_error_table => x_error_tbl
1604: , x_error_table => x_error_tbl
1605: );
1606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1607: --
1608: END Update_View;
1609: --
1610: --

Line 1637: x_return_status := FND_API.G_RET_STS_SUCCESS;

1633: l_end_pos NUMBER;
1634: --
1635: BEGIN
1636: bis_debug_pub.Add('> handle_gen_exception');
1637: x_return_status := FND_API.G_RET_STS_SUCCESS;
1638: --
1639: -- get first message in message queue
1640: l_error_msg := fnd_msg_pub.get(fnd_msg_pub.G_FIRST, FND_API.G_TRUE);
1641: -- get application short name

Line 1640: l_error_msg := fnd_msg_pub.get(fnd_msg_pub.G_FIRST, FND_API.G_TRUE);

1636: bis_debug_pub.Add('> handle_gen_exception');
1637: x_return_status := FND_API.G_RET_STS_SUCCESS;
1638: --
1639: -- get first message in message queue
1640: l_error_msg := fnd_msg_pub.get(fnd_msg_pub.G_FIRST, FND_API.G_TRUE);
1641: -- get application short name
1642: l_appl_short := SUBSTR( l_error_msg
1643: , 1
1644: , INSTR(l_error_msg, FND_API.G_MISS_CHAR) - 1

Line 1644: , INSTR(l_error_msg, FND_API.G_MISS_CHAR) - 1

1640: l_error_msg := fnd_msg_pub.get(fnd_msg_pub.G_FIRST, FND_API.G_TRUE);
1641: -- get application short name
1642: l_appl_short := SUBSTR( l_error_msg
1643: , 1
1644: , INSTR(l_error_msg, FND_API.G_MISS_CHAR) - 1
1645: );
1646: l_end_pos := INSTR(l_error_msg, FND_API.G_MISS_CHAR, 1, 2)
1647: - LENGTH(l_appl_short) - 2;
1648: -- get message_name

Line 1646: l_end_pos := INSTR(l_error_msg, FND_API.G_MISS_CHAR, 1, 2)

1642: l_appl_short := SUBSTR( l_error_msg
1643: , 1
1644: , INSTR(l_error_msg, FND_API.G_MISS_CHAR) - 1
1645: );
1646: l_end_pos := INSTR(l_error_msg, FND_API.G_MISS_CHAR, 1, 2)
1647: - LENGTH(l_appl_short) - 2;
1648: -- get message_name
1649: l_error_msg := SUBSTR(l_error_msg, LENGTH(l_appl_short)+2, l_end_pos);
1650: -- get message_code

Line 1664: l_error_msg := fnd_msg_pub.get(p_encoded => FND_API.G_FALSE);

1660: --- assumption: as the message stack is first populated with the
1661: --- message explaining the exception and then with the execution trace for
1662: --- every procedure in the call stack, the user-friendly message is the first
1663: --- one
1664: l_error_msg := fnd_msg_pub.get(p_encoded => FND_API.G_FALSE);
1665: fnd_message.set_name( application => bis_vg_types.MESSAGE_APPLICATION
1666: , name => 'BIS_VG_FAIL_VIEW_NAME_PROMPT'
1667: );
1668: fnd_message.set_token('VIEW_NAME', p_viewname);

Line 1678: fnd_msg_pub.get(p_encoded => FND_API.G_FALSE)

1674: l_trace := '';
1675: FOR i IN 2 .. l_count LOOP
1676: l_trace := SUBSTR( l_trace ||
1677: ' ' ||
1678: fnd_msg_pub.get(p_encoded => FND_API.G_FALSE)
1679: , 1
1680: , 2000
1681: );
1682: END LOOP;

Line 1696: when FND_API.G_EXC_ERROR then

1692: , x_error_Tbl
1693: );
1694: bis_debug_pub.Add('< handle_gen_exception');
1695: EXCEPTION
1696: when FND_API.G_EXC_ERROR then
1697: x_return_status := FND_API.G_RET_STS_ERROR ;
1698: RAISE FND_API.G_EXC_ERROR;
1699: when FND_API.G_EXC_UNEXPECTED_ERROR then
1700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1697: x_return_status := FND_API.G_RET_STS_ERROR ;

1693: );
1694: bis_debug_pub.Add('< handle_gen_exception');
1695: EXCEPTION
1696: when FND_API.G_EXC_ERROR then
1697: x_return_status := FND_API.G_RET_STS_ERROR ;
1698: RAISE FND_API.G_EXC_ERROR;
1699: when FND_API.G_EXC_UNEXPECTED_ERROR then
1700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1698: RAISE FND_API.G_EXC_ERROR;

1694: bis_debug_pub.Add('< handle_gen_exception');
1695: EXCEPTION
1696: when FND_API.G_EXC_ERROR then
1697: x_return_status := FND_API.G_RET_STS_ERROR ;
1698: RAISE FND_API.G_EXC_ERROR;
1699: when FND_API.G_EXC_UNEXPECTED_ERROR then
1700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702: when others then

Line 1699: when FND_API.G_EXC_UNEXPECTED_ERROR then

1695: EXCEPTION
1696: when FND_API.G_EXC_ERROR then
1697: x_return_status := FND_API.G_RET_STS_ERROR ;
1698: RAISE FND_API.G_EXC_ERROR;
1699: when FND_API.G_EXC_UNEXPECTED_ERROR then
1700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702: when others then
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1696: when FND_API.G_EXC_ERROR then
1697: x_return_status := FND_API.G_RET_STS_ERROR ;
1698: RAISE FND_API.G_EXC_ERROR;
1699: when FND_API.G_EXC_UNEXPECTED_ERROR then
1700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702: when others then
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1704: BIS_VG_UTIL.Add_Error_Message

Line 1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1697: x_return_status := FND_API.G_RET_STS_ERROR ;
1698: RAISE FND_API.G_EXC_ERROR;
1699: when FND_API.G_EXC_UNEXPECTED_ERROR then
1700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702: when others then
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1704: BIS_VG_UTIL.Add_Error_Message
1705: ( p_error_msg_id => SQLCODE

Line 1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1699: when FND_API.G_EXC_UNEXPECTED_ERROR then
1700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702: when others then
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1704: BIS_VG_UTIL.Add_Error_Message
1705: ( p_error_msg_id => SQLCODE
1706: , p_error_description => SQLERRM
1707: , p_error_proc_name => G_PKG_NAME||'. handle_gen_exception'

Line 1711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1707: , p_error_proc_name => G_PKG_NAME||'. handle_gen_exception'
1708: , p_error_table => x_error_tbl
1709: , x_error_table => x_error_tbl
1710: );
1711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1712: END handle_gen_exception;
1713: --
1714: --
1715: -- ============================================================================

Line 2012: WHEN FND_API.g_exc_unexpected_error

2008: COMMIT;
2009:
2010: --- dbms_output.put_line('GENERATE_PRUNED_VIEW - Status updated');
2011: EXCEPTION
2012: WHEN FND_API.g_exc_unexpected_error
2013: THEN
2014: --- bis_debug_pub.dumpdebug;
2015: bis_vg_log.write_error_to_string(l_error_string);
2016: execute immediate update_status_stmt

Line 2024: WHEN FND_API.g_exc_error

2020: p_viewname;
2021: COMMIT;
2022:
2023: --- RAISE; --- the same exception
2024: WHEN FND_API.g_exc_error
2025: THEN
2026: --- bis_debug_pub.dumpdebug;
2027: bis_vg_log.write_error_to_string(l_error_string);
2028: execute immediate update_status_stmt

Line 2188: RAISE FND_API.G_EXC_ERROR;

2184: , p_error_table => l_error_tbl
2185: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2186: , x_error_table => l_error_tbl
2187: );
2188: RAISE FND_API.G_EXC_ERROR;
2189: END IF;
2190:
2191:
2192: --

Line 2385: when FND_API.G_EXC_ERROR then

2381: END IF; --- Mode check
2382: --
2383: EXCEPTION
2384: --
2385: when FND_API.G_EXC_ERROR then
2386: bis_vg_log.backpatch_failure_log( l_View_Table(i).view_name
2387: , l_return_status
2388: , l_error_Tbl
2389: );

Line 2390: l_return_status := FND_API.G_RET_STS_ERROR ;

2386: bis_vg_log.backpatch_failure_log( l_View_Table(i).view_name
2387: , l_return_status
2388: , l_error_Tbl
2389: );
2390: l_return_status := FND_API.G_RET_STS_ERROR ;
2391: when FND_API.G_EXC_UNEXPECTED_ERROR then
2392: bis_vg_log.backpatch_failure_log( l_View_Table(i).view_name
2393: , l_return_status
2394: , l_error_Tbl

Line 2391: when FND_API.G_EXC_UNEXPECTED_ERROR then

2387: , l_return_status
2388: , l_error_Tbl
2389: );
2390: l_return_status := FND_API.G_RET_STS_ERROR ;
2391: when FND_API.G_EXC_UNEXPECTED_ERROR then
2392: bis_vg_log.backpatch_failure_log( l_View_Table(i).view_name
2393: , l_return_status
2394: , l_error_Tbl
2395: );

Line 2396: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2392: bis_vg_log.backpatch_failure_log( l_View_Table(i).view_name
2393: , l_return_status
2394: , l_error_Tbl
2395: );
2396: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2397: --
2398: WHEN OTHERS THEN
2399: bis_vg_log.update_failure_log( l_View_Table(i).view_name
2400: , SQLCODE

Line 2425: WHEN FND_API.G_EXC_ERROR THEN

2421: --
2422: bis_debug_pub.Add('< generate_Views');
2423: --
2424: EXCEPTION
2425: WHEN FND_API.G_EXC_ERROR THEN
2426: bis_vg_log.update_failure_log( l_error_tbl
2427: , l_return_status
2428: , l_error_Tbl
2429: );

Line 2486: x_return_status := FND_API.G_RET_STS_SUCCESS;

2482: )
2483: IS
2484: BEGIN
2485: bis_debug_pub.Add('> set_mode');
2486: x_return_status := FND_API.G_RET_STS_SUCCESS;
2487: g_mode := p_mode;
2488: bis_debug_pub.Add('< set_mode');
2489: --
2490: EXCEPTION

Line 2491: when FND_API.G_EXC_ERROR then

2487: g_mode := p_mode;
2488: bis_debug_pub.Add('< set_mode');
2489: --
2490: EXCEPTION
2491: when FND_API.G_EXC_ERROR then
2492: x_return_status := FND_API.G_RET_STS_ERROR ;
2493: RAISE FND_API.G_EXC_ERROR;
2494: when FND_API.G_EXC_UNEXPECTED_ERROR then
2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2492: x_return_status := FND_API.G_RET_STS_ERROR ;

2488: bis_debug_pub.Add('< set_mode');
2489: --
2490: EXCEPTION
2491: when FND_API.G_EXC_ERROR then
2492: x_return_status := FND_API.G_RET_STS_ERROR ;
2493: RAISE FND_API.G_EXC_ERROR;
2494: when FND_API.G_EXC_UNEXPECTED_ERROR then
2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2493: RAISE FND_API.G_EXC_ERROR;

2489: --
2490: EXCEPTION
2491: when FND_API.G_EXC_ERROR then
2492: x_return_status := FND_API.G_RET_STS_ERROR ;
2493: RAISE FND_API.G_EXC_ERROR;
2494: when FND_API.G_EXC_UNEXPECTED_ERROR then
2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2497: when others then

Line 2494: when FND_API.G_EXC_UNEXPECTED_ERROR then

2490: EXCEPTION
2491: when FND_API.G_EXC_ERROR then
2492: x_return_status := FND_API.G_RET_STS_ERROR ;
2493: RAISE FND_API.G_EXC_ERROR;
2494: when FND_API.G_EXC_UNEXPECTED_ERROR then
2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2497: when others then
2498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2491: when FND_API.G_EXC_ERROR then
2492: x_return_status := FND_API.G_RET_STS_ERROR ;
2493: RAISE FND_API.G_EXC_ERROR;
2494: when FND_API.G_EXC_UNEXPECTED_ERROR then
2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2497: when others then
2498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2499: BIS_VG_UTIL.Add_Error_Message

Line 2496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2492: x_return_status := FND_API.G_RET_STS_ERROR ;
2493: RAISE FND_API.G_EXC_ERROR;
2494: when FND_API.G_EXC_UNEXPECTED_ERROR then
2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2497: when others then
2498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2499: BIS_VG_UTIL.Add_Error_Message
2500: ( p_error_msg_id => SQLCODE

Line 2498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2494: when FND_API.G_EXC_UNEXPECTED_ERROR then
2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2497: when others then
2498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2499: BIS_VG_UTIL.Add_Error_Message
2500: ( p_error_msg_id => SQLCODE
2501: , p_error_description => SQLERRM
2502: , p_error_proc_name => G_PKG_NAME||'.set_mode'

Line 2506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2502: , p_error_proc_name => G_PKG_NAME||'.set_mode'
2503: , p_error_table => x_error_tbl
2504: , x_error_table => x_error_tbl
2505: );
2506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2507: END set_mode;
2508:
2509: END bis_view_generator_pvt;
2510: