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_VG_UTIL dependencies on BIS_VG_UTIL

Line 1: PACKAGE BODY BIS_VG_UTIL AS

1: PACKAGE BODY BIS_VG_UTIL AS
2: /* $Header: BISTUTLB.pls 115.12 2003/06/02 14:52:42 dbowles ship $ */
3:
4: -- Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA
5: -- All rights reserved.

Line 27: G_PKG_NAME CONSTANT VARCHAR(30) := 'BIS_VG_UTIL';

23: -- Added overloaded procedure concatenate_Tables to accept
24: -- types of BIS_VG_TYPES.Flex_Column_Comment_Table_Type.
25: -- 11-DEC-01 Edited by DBOWLES Added dr driver comments.
26: --
27: G_PKG_NAME CONSTANT VARCHAR(30) := 'BIS_VG_UTIL';
28: -- ============================================================================
29: -- FUNCTION : is_char_delimiter
30: -- PARAMETERS:
31: -- 1. p_character a valid character

Line 41: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

37: -- ============================================================================
38: FUNCTION is_char_delimiter
39: ( p_character IN VARCHAR2
40: , x_return_status OUT VARCHAR2
41: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
42: )
43: RETURN BOOLEAN IS
44: --
45: BEGIN

Line 73: BIS_VG_UTIL.Add_Error_Message

69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: when others then
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: BIS_VG_UTIL.Add_Error_Message
74: ( p_error_msg_id => SQLCODE
75: , p_error_description => SQLERRM
76: , p_error_proc_name => G_PKG_NAME||'.is_char_delimiter'
77: , p_error_table => x_error_tbl

Line 89: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

85: PROCEDURE create_Text_Table
86: ( p_String IN VARCHAR2
87: , x_View_Table OUT bis_vg_types.View_Text_Table_Type
88: , x_return_status OUT VARCHAR2
89: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
90: )
91: IS
92: --
93: l_beg_pos NUMBER := 1;

Line 174: BIS_VG_UTIL.Add_Error_Message

170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: when others then
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
174: BIS_VG_UTIL.Add_Error_Message
175: ( p_error_msg_id => SQLCODE
176: , p_error_description => SQLERRM
177: , p_error_proc_name => G_PKG_NAME||'.create_Text_Table'
178: , p_error_table => x_error_tbl

Line 188: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

184: --
185: FUNCTION get_valid_col_name
186: ( p_Col_Name IN VARCHAR2
187: , x_return_status OUT VARCHAR2
188: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
189: )
190: RETURN VARCHAR2 IS
191: --
192: l_String VARCHAR2(100);

Line 227: BIS_VG_UTIL.Add_Error_Message

223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: when others then
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
227: BIS_VG_UTIL.Add_Error_Message
228: ( p_error_msg_id => SQLCODE
229: , p_error_description => SQLERRM
230: , p_error_proc_name => G_PKG_NAME||'.get_valid_col_name'
231: , p_error_table => x_error_tbl

Line 244: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

240: ( p_String IN VARCHAR2
241: , p_Prefix IN VARCHAR2
242: , p_Suffix IN VARCHAR2
243: , x_return_status OUT VARCHAR2
244: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
245: )
246: RETURN VARCHAR2 IS
247: --
248: l_String VARCHAR2(100);

Line 272: BIS_VG_UTIL.Add_Error_Message

268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: when others then
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
272: BIS_VG_UTIL.Add_Error_Message
273: ( p_error_msg_id => SQLCODE
274: , p_error_description => SQLERRM
275: , p_error_proc_name => G_PKG_NAME||'.get_string_len30'
276: , p_error_table => x_error_tbl

Line 289: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

285: ( p_view_table IN bis_vg_types.View_Text_Table_Type
286: , p_start_pointer IN bis_vg_types.View_Character_Pointer_Type
287: , p_end_pointer IN bis_vg_types.View_Character_Pointer_Type
288: , x_return_status OUT VARCHAR2
289: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
290: )
291: RETURN VARCHAR2
292: IS
293: l_ret VARCHAR2(32000);

Line 362: BIS_VG_UTIL.Add_Error_Message

358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: when others then
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
362: BIS_VG_UTIL.Add_Error_Message
363: ( p_error_msg_id => SQLCODE
364: , p_error_description => SQLERRM
365: , p_error_proc_name => G_PKG_NAME||'.get_string'
366: , p_error_table => x_error_tbl

Line 377: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

373: FUNCTION get_char
374: ( p_view_table IN bis_vg_types.View_Text_Table_Type
375: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
376: , x_return_status OUT VARCHAR2
377: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
378: )
379: RETURN VARCHAR2
380: IS
381: BEGIN

Line 393: BIS_VG_UTIL.Add_Error_Message

389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
391: when others then
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393: BIS_VG_UTIL.Add_Error_Message
394: ( p_error_msg_id => SQLCODE
395: , p_error_description => SQLERRM
396: , p_error_proc_name => G_PKG_NAME||'.get_char'
397: , p_error_table => x_error_tbl

Line 408: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

404: FUNCTION increment_pointer
405: ( p_view_table IN bis_vg_types.View_Text_Table_Type
406: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
407: , x_return_status OUT VARCHAR2
408: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
409: )
410: RETURN bis_vg_types.view_character_pointer_type
411: is
412: l_str VARCHAR2(2000);

Line 441: BIS_VG_UTIL.Add_Error_Message

437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
439: when others then
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
441: BIS_VG_UTIL.Add_Error_Message
442: ( p_error_msg_id => SQLCODE
443: , p_error_description => SQLERRM
444: , p_error_proc_name => G_PKG_NAME||'.increment_pointer'
445: , p_error_table => x_error_tbl

Line 458: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

454: ( p_View_Table_A IN BIS_VG_TYPES.View_Text_Table_Type
455: , p_View_Table_B IN BIS_VG_TYPES.View_Text_Table_Type
456: , x_View_Table OUT BIS_VG_TYPES.View_Text_Table_Type
457: , x_return_status OUT VARCHAR2
458: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
459: )
460: IS
461: --
462: l_count INTEGER;

Line 484: BIS_VG_UTIL.Add_Error_Message

480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
482: when others then
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
484: BIS_VG_UTIL.Add_Error_Message
485: ( p_error_msg_id => SQLCODE
486: , p_error_description => SQLERRM
487: , p_error_proc_name => G_PKG_NAME||'.concatenate_Tables'
488: , p_error_table => x_error_tbl

Line 501: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

497: ( p_View_Table_A IN BIS_VG_TYPES.Flex_Column_Comment_Table_Type
498: , p_View_Table_B IN BIS_VG_TYPES.Flex_Column_Comment_Table_Type
499: , x_View_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
500: , x_return_status OUT VARCHAR2
501: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
502: )
503: IS
504: --
505: l_count INTEGER;

Line 527: BIS_VG_UTIL.Add_Error_Message

523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: when others then
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
527: BIS_VG_UTIL.Add_Error_Message
528: ( p_error_msg_id => SQLCODE
529: , p_error_description => SQLERRM
530: , p_error_proc_name => G_PKG_NAME||'.concatenate_Tables'
531: , p_error_table => x_error_tbl

Line 543: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

539: FUNCTION equal_pointers
540: ( p_start_pointer IN BIS_VG_TYPES.view_character_pointer_type
541: , p_end_pointer IN BIS_VG_TYPES.view_character_pointer_type
542: , x_return_status OUT VARCHAR2
543: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
544: )
545: RETURN BOOLEAN IS
546: --
547: BEGIN

Line 579: BIS_VG_UTIL.Add_Error_Message

575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: when others then
578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
579: BIS_VG_UTIL.Add_Error_Message
580: ( p_error_msg_id => SQLCODE
581: , p_error_description => SQLERRM
582: , p_error_proc_name => G_PKG_NAME||'.equal_pointers'
583: , p_error_table => x_error_tbl

Line 597: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

593: , p_start_pointer IN BIS_VG_TYPES.view_character_pointer_type
594: , p_end_pointer IN BIS_VG_TYPES.view_character_pointer_type
595: , x_View_Table OUT BIS_VG_TYPES.View_Text_Table_Type
596: , x_return_status OUT VARCHAR2
597: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
598: )
599: IS
600: l_str VARCHAR2(2000);
601: l_start NUMBER;

Line 695: BIS_VG_UTIL.Add_Error_Message

691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: when others then
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
695: BIS_VG_UTIL.Add_Error_Message
696: ( p_error_msg_id => SQLCODE
697: , p_error_description => SQLERRM
698: , p_error_proc_name => G_PKG_NAME||'.copy_part_of_table'
699: , p_error_table => x_error_tbl

Line 719: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

715: ========================================================================== */
716: PROCEDURE print_View_Text --{
717: ( p_View_Text_Table IN BIS_VG_TYPES.View_Text_Table_Type
718: , x_return_status OUT VARCHAR2
719: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
720: )
721: IS
722: --
723: i NUMBER;

Line 744: BIS_VG_UTIL.Add_Error_Message

740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: when others then
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
744: BIS_VG_UTIL.Add_Error_Message
745: ( p_error_msg_id => SQLCODE
746: , p_error_description => SQLERRM
747: , p_error_proc_name => G_PKG_NAME||'.print_View_Text'
748: , p_error_table => x_error_tbl

Line 768: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

764: ============================================================================ */
765: PROCEDURE print_View_pointer --{
766: ( p_pointer IN BIS_VG_TYPES.View_character_pointer_type
767: , x_return_status OUT VARCHAR2
768: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
769: )
770: IS
771: BEGIN
772: BIS_DEBUG_PUB.Add('> print_View_pointer');

Line 788: BIS_VG_UTIL.Add_Error_Message

784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: when others then
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
788: BIS_VG_UTIL.Add_Error_Message
789: ( p_error_msg_id => SQLCODE
790: , p_error_description => SQLERRM
791: , p_error_proc_name => G_PKG_NAME||'.print_View_pointer'
792: , p_error_table => x_error_tbl

Line 816: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

812: FUNCTION position_before_characters
813: ( p_View_Text_Table IN BIS_VG_TYPES.view_text_table_type
814: , p_str IN VARCHAR2
815: , x_return_status OUT VARCHAR2
816: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
817: )
818: RETURN bis_vg_types.view_character_pointer_type
819: IS
820: l_pointer bis_vg_types.view_character_pointer_type;

Line 844: BIS_VG_UTIL.Add_Error_Message

840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
842: when others then
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
844: BIS_VG_UTIL.Add_Error_Message
845: ( p_error_msg_id => SQLCODE
846: , p_error_description => SQLERRM
847: , p_error_proc_name => G_PKG_NAME||'.position_before_characters'
848: , p_error_table => x_error_tbl

Line 873: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

869: ( p_View_Text_Table IN BIS_VG_TYPES.view_text_table_type
870: , p_str IN VARCHAR2
871: , p_pointer IN bis_vg_types.view_character_pointer_type
872: , x_return_status OUT VARCHAR2
873: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
874: )
875: RETURN bis_vg_types.view_character_pointer_type
876: IS
877: l_pointer bis_vg_types.view_character_pointer_type;

Line 906: BIS_VG_UTIL.print_View_Pointer( l_pointer

902: l_pos := Instr(p_str, l_char);
903:
904: WHILE (l_pos <> 0) LOOP
905: BIS_DEBUG_PUB.Add('l_char = ' || l_char || ' l_pos = ' || l_pos);
906: BIS_VG_UTIL.print_View_Pointer( l_pointer
907: , x_return_status
908: , x_error_Tbl
909: );
910: l_pointer := decrement_pointer ( p_view_text_table

Line 924: BIS_VG_UTIL.print_View_Pointer ( l_pointer

920: l_pos := Instr(p_str, l_char);
921: END LOOP;
922:
923: bis_debug_pub.ADD('out of loop');
924: BIS_VG_UTIL.print_View_Pointer ( l_pointer
925: , x_return_status
926: , x_error_Tbl
927: );
928: BIS_DEBUG_PUB.Add('< position_before_characters');

Line 940: BIS_VG_UTIL.Add_Error_Message

936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
938: when others then
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940: BIS_VG_UTIL.Add_Error_Message
941: ( p_error_msg_id => SQLCODE
942: , p_error_description => SQLERRM
943: , p_error_proc_name => G_PKG_NAME||'.position_before_characters'
944: , p_error_table => x_error_tbl

Line 957: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

953: FUNCTION decrement_pointer
954: ( p_view_table IN bis_vg_types.View_Text_Table_Type
955: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
956: , x_return_status OUT VARCHAR2
957: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
958: )
959: RETURN bis_vg_types.view_character_pointer_type
960: IS
961: l_str VARCHAR2(2000);

Line 996: BIS_VG_UTIL.Add_Error_Message

992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: when others then
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
996: BIS_VG_UTIL.Add_Error_Message
997: ( p_error_msg_id => SQLCODE
998: , p_error_description => SQLERRM
999: , p_error_proc_name => G_PKG_NAME||'.decrement_pointer'
1000: , p_error_table => x_error_tbl

Line 1011: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1007: -- return TRUE if pointer is a null
1008: FUNCTION null_pointer
1009: (p_pointer IN bis_vg_types.view_character_pointer_type
1010: , x_return_status OUT VARCHAR2
1011: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1012: )
1013: RETURN BOOLEAN
1014: IS
1015: BEGIN

Line 1033: BIS_VG_UTIL.Add_Error_Message

1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: when others then
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1033: BIS_VG_UTIL.Add_Error_Message
1034: ( p_error_msg_id => SQLCODE
1035: , p_error_description => SQLERRM
1036: , p_error_proc_name => G_PKG_NAME||'.null_pointer'
1037: , p_error_table => x_error_tbl

Line 1049: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1045: FUNCTION get_row
1046: ( p_view_table IN bis_vg_types.View_Text_Table_Type
1047: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
1048: , x_return_status OUT VARCHAR2
1049: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1050: )
1051: RETURN bis_vg_types.view_text_table_rec_type
1052: IS
1053: BEGIN

Line 1074: BIS_VG_UTIL.Add_Error_Message

1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: when others then
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1074: BIS_VG_UTIL.Add_Error_Message
1075: ( p_error_msg_id => SQLCODE
1076: , p_error_description => SQLERRM
1077: , p_error_proc_name => G_PKG_NAME||'.get_row'
1078: , p_error_table => x_error_tbl

Line 1090: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1086: FUNCTION increment_pointer_by_row
1087: ( p_view_table IN bis_vg_types.View_Text_Table_Type
1088: , p_pointer IN bis_vg_types.View_Character_Pointer_Type
1089: , x_return_status OUT VARCHAR2
1090: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1091: )
1092: RETURN bis_vg_types.view_character_pointer_type
1093: IS
1094: l_pointer bis_vg_types.view_character_pointer_type;

Line 1122: BIS_VG_UTIL.Add_Error_Message

1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1120: when others then
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1122: BIS_VG_UTIL.Add_Error_Message
1123: ( p_error_msg_id => SQLCODE
1124: , p_error_description => SQLERRM
1125: , p_error_proc_name => G_PKG_NAME||'.increment_pointer_by_row'
1126: , p_error_table => x_error_tbl

Line 1137: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1133: -- this function returns the generated view name for the original view name
1134: FUNCTION get_generated_view_name
1135: ( p_view_name IN VARCHAR2
1136: , x_return_status OUT VARCHAR2
1137: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1138: )
1139: RETURN VARCHAR2
1140: IS
1141:

Line 1168: BIS_VG_UTIL.Add_Error_Message

1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: when others then
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1168: BIS_VG_UTIL.Add_Error_Message
1169: ( p_error_msg_id => SQLCODE
1170: , p_error_description => SQLERRM
1171: , p_error_proc_name => G_PKG_NAME||'.get_generated_view_name'
1172: , p_error_table => x_error_tbl

Line 1184: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1180: PROCEDURE add_message
1181: ( p_msg_name IN VARCHAR2
1182: , p_msg_level IN NUMBER
1183: , x_return_status OUT VARCHAR2
1184: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1185: )
1186: IS
1187: BEGIN
1188: IF (fnd_msg_pub.check_msg_level(p_msg_level) = TRUE) THEN

Line 1202: BIS_VG_UTIL.Add_Error_Message

1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1200: when others then
1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1202: BIS_VG_UTIL.Add_Error_Message
1203: ( p_error_msg_id => SQLCODE
1204: , p_error_description => SQLERRM
1205: , p_error_proc_name => G_PKG_NAME||'.add_message'
1206: , p_error_table => x_error_tbl

Line 1219: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1215: , p_msg_level IN NUMBER
1216: , p_token1 IN VARCHAR2
1217: , p_value1 IN VARCHAR2
1218: , x_return_status OUT VARCHAR2
1219: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1220: )
1221: IS
1222:
1223: BEGIN

Line 1239: BIS_VG_UTIL.Add_Error_Message

1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1237: when others then
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1239: BIS_VG_UTIL.Add_Error_Message
1240: ( p_error_msg_id => SQLCODE
1241: , p_error_description => SQLERRM
1242: , p_error_proc_name => G_PKG_NAME||'.add_message'
1243: , p_error_table => x_error_tbl

Line 1258: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1254: , p_value1 IN VARCHAR2
1255: , p_token2 IN VARCHAR2
1256: , p_value2 IN VARCHAR2
1257: , x_return_status OUT VARCHAR2
1258: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1259: )
1260: IS
1261: BEGIN
1262: IF (fnd_msg_pub.check_msg_level(p_msg_level) = TRUE) THEN

Line 1278: BIS_VG_UTIL.Add_Error_Message

1274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1276: when others then
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1278: BIS_VG_UTIL.Add_Error_Message
1279: ( p_error_msg_id => SQLCODE
1280: , p_error_description => SQLERRM
1281: , p_error_proc_name => G_PKG_NAME||'.add_message'
1282: , p_error_table => x_error_tbl

Line 1299: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1295: , p_value2 IN VARCHAR2
1296: , p_token3 IN VARCHAR2
1297: , p_value3 IN VARCHAR2
1298: , x_return_status OUT VARCHAR2
1299: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1300: )
1301: IS
1302: BEGIN
1303: IF (fnd_msg_pub.check_msg_level(p_msg_level) = TRUE) THEN

Line 1320: BIS_VG_UTIL.Add_Error_Message

1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1318: when others then
1319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1320: BIS_VG_UTIL.Add_Error_Message
1321: ( p_error_msg_id => SQLCODE
1322: , p_error_description => SQLERRM
1323: , p_error_proc_name => G_PKG_NAME||'.add_message'
1324: , p_error_table => x_error_tbl

Line 1337: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR

1333: PROCEDURE Add_Error_Message
1334: ( p_error_msg_name IN VARCHAR2
1335: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
1336: , p_error_proc_name IN VARCHAR2 := NULL
1337: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR
1338: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type
1339: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1340: )
1341: IS

Line 1338: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type

1334: ( p_error_msg_name IN VARCHAR2
1335: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
1336: , p_error_proc_name IN VARCHAR2 := NULL
1337: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR
1338: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type
1339: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1340: )
1341: IS
1342: --

Line 1339: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type

1335: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
1336: , p_error_proc_name IN VARCHAR2 := NULL
1337: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR
1338: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type
1339: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1340: )
1341: IS
1342: --
1343: l_error_rec BIS_VG_UTIL.Error_Rec_Type;

Line 1343: l_error_rec BIS_VG_UTIL.Error_Rec_Type;

1339: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1340: )
1341: IS
1342: --
1343: l_error_rec BIS_VG_UTIL.Error_Rec_Type;
1344: --
1345: BEGIN
1346: IF (fnd_msg_pub.check_msg_level(p_error_msg_level) = TRUE) THEN
1347: fnd_message.set_name(BIS_VG_TYPES.message_application, p_error_msg_name);

Line 1364: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR

1360: PROCEDURE Add_Error_Message
1361: ( p_error_msg_name IN VARCHAR2
1362: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
1363: , p_error_proc_name IN VARCHAR2 := NULL
1364: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR
1365: , p_token1 IN VARCHAR2
1366: , p_value1 IN VARCHAR2
1367: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type
1368: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type

Line 1367: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type

1363: , p_error_proc_name IN VARCHAR2 := NULL
1364: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR
1365: , p_token1 IN VARCHAR2
1366: , p_value1 IN VARCHAR2
1367: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type
1368: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1369: )
1370: IS
1371: --

Line 1368: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type

1364: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR
1365: , p_token1 IN VARCHAR2
1366: , p_value1 IN VARCHAR2
1367: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type
1368: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1369: )
1370: IS
1371: --
1372: l_error_rec BIS_VG_UTIL.Error_Rec_Type;

Line 1372: l_error_rec BIS_VG_UTIL.Error_Rec_Type;

1368: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1369: )
1370: IS
1371: --
1372: l_error_rec BIS_VG_UTIL.Error_Rec_Type;
1373: --
1374: BEGIN
1375:
1376: IF (fnd_msg_pub.check_msg_level(p_error_msg_level) = TRUE) THEN

Line 1396: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR

1392: PROCEDURE Add_Error_Message
1393: ( p_error_msg_name IN VARCHAR2
1394: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
1395: , p_error_proc_name IN VARCHAR2 := NULL
1396: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR
1397: , p_token1 IN VARCHAR2
1398: , p_value1 IN VARCHAR2
1399: , p_token2 IN VARCHAR2
1400: , p_value2 IN VARCHAR2

Line 1401: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type

1397: , p_token1 IN VARCHAR2
1398: , p_value1 IN VARCHAR2
1399: , p_token2 IN VARCHAR2
1400: , p_value2 IN VARCHAR2
1401: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type
1402: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1403: )
1404: IS
1405: --

Line 1402: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type

1398: , p_value1 IN VARCHAR2
1399: , p_token2 IN VARCHAR2
1400: , p_value2 IN VARCHAR2
1401: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type
1402: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1403: )
1404: IS
1405: --
1406: l_error_rec BIS_VG_UTIL.Error_Rec_Type;

Line 1406: l_error_rec BIS_VG_UTIL.Error_Rec_Type;

1402: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1403: )
1404: IS
1405: --
1406: l_error_rec BIS_VG_UTIL.Error_Rec_Type;
1407: --
1408: BEGIN
1409:
1410: IF (fnd_msg_pub.check_msg_level(p_error_msg_level) = TRUE) THEN

Line 1430: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR

1426: PROCEDURE Add_Error_Message
1427: ( p_error_msg_name IN VARCHAR2
1428: , p_error_msg_level IN NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR
1429: , p_error_proc_name IN VARCHAR2 := NULL
1430: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR
1431: , p_token1 IN VARCHAR2
1432: , p_value1 IN VARCHAR2
1433: , p_token2 IN VARCHAR2
1434: , p_value2 IN VARCHAR2

Line 1437: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type

1433: , p_token2 IN VARCHAR2
1434: , p_value2 IN VARCHAR2
1435: , p_token3 IN VARCHAR2
1436: , p_value3 IN VARCHAR2
1437: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type
1438: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1439: )
1440: IS
1441: --

Line 1438: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type

1434: , p_value2 IN VARCHAR2
1435: , p_token3 IN VARCHAR2
1436: , p_value3 IN VARCHAR2
1437: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type
1438: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1439: )
1440: IS
1441: --
1442: l_error_rec BIS_VG_UTIL.Error_Rec_Type;

Line 1442: l_error_rec BIS_VG_UTIL.Error_Rec_Type;

1438: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1439: )
1440: IS
1441: --
1442: l_error_rec BIS_VG_UTIL.Error_Rec_Type;
1443: --
1444: BEGIN
1445:
1446: IF (fnd_msg_pub.check_msg_level(p_error_msg_level) = TRUE) THEN

Line 1468: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR

1464: ( p_error_msg_id IN NUMBER := NULL
1465: , p_error_msg_name IN VARCHAR2 := NULL
1466: , p_error_description IN VARCHAR2 := NULL
1467: , p_error_proc_name IN VARCHAR2 := NULL
1468: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR
1469: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type
1470: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1471: )
1472: IS

Line 1469: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type

1465: , p_error_msg_name IN VARCHAR2 := NULL
1466: , p_error_description IN VARCHAR2 := NULL
1467: , p_error_proc_name IN VARCHAR2 := NULL
1468: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR
1469: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type
1470: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1471: )
1472: IS
1473: --

Line 1470: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type

1466: , p_error_description IN VARCHAR2 := NULL
1467: , p_error_proc_name IN VARCHAR2 := NULL
1468: , p_error_type IN VARCHAR2 := BIS_VG_UTIL.G_ERROR
1469: , p_error_table IN BIS_VG_UTIL.Error_Tbl_Type
1470: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1471: )
1472: IS
1473: --
1474: l_error_rec BIS_VG_UTIL.Error_Rec_Type;

Line 1474: l_error_rec BIS_VG_UTIL.Error_Rec_Type;

1470: , x_error_table OUT BIS_VG_UTIL.Error_Tbl_Type
1471: )
1472: IS
1473: --
1474: l_error_rec BIS_VG_UTIL.Error_Rec_Type;
1475: --
1476: BEGIN
1477:
1478: l_error_rec.Error_Msg_ID := p_error_msg_id;

Line 1663: END BIS_VG_UTIL;

1659:
1660:
1661: END find_Flex_Prompt;
1662:
1663: END BIS_VG_UTIL;