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

Line 95: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

91: -- ============================================================================
92:
93: PROCEDURE init_log
94: ( x_return_status OUT VARCHAR2
95: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
96: )
97: IS
98: BEGIN
99: bis_debug_pub.Add('> init_log');

Line 114: BIS_VG_UTIL.Add_Error_Message

110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: when others then
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
114: BIS_VG_UTIL.Add_Error_Message
115: ( p_error_msg_id => SQLCODE
116: , p_error_description => SQLERRM
117: , p_error_proc_name => G_PKG_NAME||'.init_log'
118: , p_error_table => x_error_tbl

Line 139: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

135: PROCEDURE update_success_log
136: ( p_origbv IN bis_vg_types.view_name_type
137: , p_genbv IN bis_vg_types.view_name_type
138: , x_return_status OUT VARCHAR2
139: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
140: )
141: IS
142: l_result view_gen_success_type;
143: BEGIN

Line 161: BIS_VG_UTIL.Add_Error_Message

157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159: when others then
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
161: BIS_VG_UTIL.Add_Error_Message
162: ( p_error_msg_id => SQLCODE
163: , p_error_description => SQLERRM
164: , p_error_proc_name => G_PKG_NAME||'.update_success_log'
165: , p_error_table => x_error_tbl

Line 190: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

186: ( p_origbv IN bis_vg_types.view_name_type
187: , p_code IN NUMBER
188: , p_errm IN VARCHAR2
189: , x_return_status OUT VARCHAR2
190: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
191: )
192: IS
193: l_result view_gen_failure_type;
194: l_str VARCHAR2(100);

Line 216: BIS_VG_UTIL.Add_Error_Message

212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: when others then
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: BIS_VG_UTIL.Add_Error_Message
217: ( p_error_msg_id => SQLCODE
218: , p_error_description => SQLERRM
219: , p_error_proc_name => G_PKG_NAME||'.update_failure_log'
220: , p_error_table => x_error_tbl

Line 239: ( p_error_Tbl IN BIS_VG_UTIL.Error_Tbl_Type

235: --EXCEPTION : None
236: -- ============================================================================
237:
238: PROCEDURE update_failure_log
239: ( p_error_Tbl IN BIS_VG_UTIL.Error_Tbl_Type
240: , x_return_status OUT VARCHAR2
241: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
242: )
243: IS

Line 241: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

237:
238: PROCEDURE update_failure_log
239: ( p_error_Tbl IN BIS_VG_UTIL.Error_Tbl_Type
240: , x_return_status OUT VARCHAR2
241: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
242: )
243: IS
244: l_result view_gen_failure_type;
245: l_str VARCHAR2(100);

Line 276: BIS_VG_UTIL.Add_Error_Message

272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
274: when others then
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
276: BIS_VG_UTIL.Add_Error_Message
277: ( p_error_msg_id => SQLCODE
278: , p_error_description => SQLERRM
279: , p_error_proc_name => G_PKG_NAME||'.update_failure_log'
280: , p_error_table => x_error_tbl

Line 300: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

296: -- ============================================================================
297: PROCEDURE backpatch_failure_log
298: ( p_origbv IN bis_vg_types.view_name_type
299: , x_return_status OUT VARCHAR2
300: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
301: )
302: IS
303: l_counter NUMBER;
304: BEGIN

Line 333: BIS_VG_UTIL.Add_Error_Message

329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: when others then
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
333: BIS_VG_UTIL.Add_Error_Message
334: ( p_error_msg_id => SQLCODE
335: , p_error_description => SQLERRM
336: , p_error_proc_name => G_PKG_NAME||'.backpatch_failure_log'
337: , p_error_table => x_error_tbl

Line 358: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

354: PROCEDURE write_string
355: ( p_mode IN bis_vg_Types.view_generator_mode_type
356: , p_string IN VARCHAR2
357: , x_return_status OUT VARCHAR2
358: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
359: )
360: IS
361: BEGIN
362:

Line 385: BIS_VG_UTIL.Add_Error_Message

381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
383: when others then
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
385: BIS_VG_UTIL.Add_Error_Message
386: ( p_error_msg_id => SQLCODE
387: , p_error_description => SQLERRM
388: , p_error_proc_name => G_PKG_NAME||'.write_string'
389: , p_error_table => x_error_tbl

Line 410: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

406: PROCEDURE write_blank_line
407: ( p_mode IN bis_vg_Types.view_generator_mode_type
408: , p_count IN NUMBER
409: , x_return_status OUT VARCHAR2
410: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
411: )
412: IS
413: BEGIN
414: bis_debug_pub.Add('> write_blank_line');

Line 435: BIS_VG_UTIL.Add_Error_Message

431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
433: when others then
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
435: BIS_VG_UTIL.Add_Error_Message
436: ( p_error_msg_id => SQLCODE
437: , p_error_description => SQLERRM
438: , p_error_proc_name => G_PKG_NAME||'.write_blank_line'
439: , p_error_table => x_error_tbl

Line 476: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

472: , p_Lookup_Table_Name IN VARCHAR2
473: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
474: , p_View_Name IN BIS_VG_TYPES.View_Name_Type
475: , x_return_status OUT VARCHAR2
476: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
477: )
478: IS
479: l_str VARCHAR2(100);
480: l_length NUMBER;

Line 618: BIS_VG_UTIL.Add_Error_Message

614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
616: when others then
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
618: BIS_VG_UTIL.Add_Error_Message
619: ( p_error_msg_id => SQLCODE
620: , p_error_description => SQLERRM
621: , p_error_proc_name => G_PKG_NAME||'.write_inputs'
622: , p_error_table => x_error_tbl

Line 641: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type )

637: -- ============================================================================
638: PROCEDURE write_header
639: ( p_mode IN bis_vg_Types.view_generator_mode_type
640: , x_return_status OUT VARCHAR2
641: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type )
642: IS
643: l_date VARCHAR2(80);
644: l_head VARCHAR2(80);
645: l_str VARCHAR2(120);

Line 675: BIS_VG_UTIL.Add_Error_Message

671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
673: when others then
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
675: BIS_VG_UTIL.Add_Error_Message
676: ( p_error_msg_id => SQLCODE
677: , p_error_description => SQLERRM
678: , p_error_proc_name => G_PKG_NAME||'.write_header'
679: , p_error_table => x_error_tbl

Line 700: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

696: PROCEDURE write_success_views
697: ( p_mode IN bis_vg_Types.view_generator_mode_type
698: , p_gen_success_table IN view_gen_success_table_type
699: , x_return_status OUT VARCHAR2
700: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
701: )
702: IS
703: l_src VARCHAR2(100);
704: l_des VARCHAR2(100);

Line 761: BIS_VG_UTIL.Add_Error_Message

757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: when others then
760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
761: BIS_VG_UTIL.Add_Error_Message
762: ( p_error_msg_id => SQLCODE
763: , p_error_description => SQLERRM
764: , p_error_proc_name => G_PKG_NAME||'.write_success_views'
765: , p_error_table => x_error_tbl

Line 786: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

782: PROCEDURE write_failure_views
783: ( p_mode IN bis_vg_Types.view_generator_mode_type
784: , p_gen_failure_table IN view_gen_failure_table_type
785: , x_return_status OUT VARCHAR2
786: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
787: )
788: IS
789: l_result view_gen_failure_type;
790: l_failure BOOLEAN := FALSE;

Line 835: BIS_VG_UTIL.Add_Error_Message

831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
833: when others then
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
835: BIS_VG_UTIL.Add_Error_Message
836: ( p_error_msg_id => SQLCODE
837: , p_error_description => SQLERRM
838: , p_error_proc_name => G_PKG_NAME||'.write_failure_views'
839: , p_error_table => x_error_tbl

Line 876: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

872: , p_Lookup_Table_Name IN VARCHAR2
873: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
874: , p_View_Name IN BIS_VG_TYPES.View_Name_Type
875: , x_return_status OUT VARCHAR2
876: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
877: )
878: IS
879: l_msg_str VARCHAR2(2000);
880: BEGIN

Line 956: BIS_VG_UTIL.Add_Error_Message

952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
954: when others then
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
956: BIS_VG_UTIL.Add_Error_Message
957: ( p_error_msg_id => SQLCODE
958: , p_error_description => SQLERRM
959: , p_error_proc_name => G_PKG_NAME||'.write_log'
960: , p_error_table => x_error_tbl