DBA Data[Home] [Help]

APPS.BIS_VIEW_GENERATOR_PVT dependencies on BIS_VG_LOG

Line 1688: bis_vg_log.update_failure_log( p_ViewName

1684: -- empty message stack
1685: fnd_msg_pub.Initialize;
1686: --
1687: -- add entry to failure log to enable reporting
1688: bis_vg_log.update_failure_log( p_ViewName
1689: , l_error_code
1690: , SUBSTR(l_message||' '||l_trace, 1, 2000)
1691: , x_return_status
1692: , x_error_Tbl

Line 2015: bis_vg_log.write_error_to_string(l_error_string);

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
2017: using
2018: 'FAILED_PRUNED',
2019: l_error_string,

Line 2027: bis_vg_log.write_error_to_string(l_error_string);

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
2029: using
2030: 'FAILED_PRUNED',
2031: l_error_string,

Line 2155: bis_vg_log.init_log(l_return_status, l_error_Tbl);

2151: , l_View_Table
2152: , l_return_status
2153: , l_error_Tbl
2154: );
2155: bis_vg_log.init_log(l_return_status, l_error_Tbl);
2156:
2157: IF (g_mode <> bis_vg_types.production_mode) THEN
2158: --
2159: BEGIN

Line 2331: bis_vg_log.update_success_log( l_View_Table(i).view_name

2327: END IF;
2328:
2329:
2330:
2331: bis_vg_log.update_success_log( l_View_Table(i).view_name
2332: , l_generated_view_name
2333: , l_return_status
2334: , l_error_Tbl
2335: );

Line 2347: bis_vg_log.write_error_to_string(l_error_message);

2343: OR l_generated_view_name like '%FCV'
2344: )
2345: )
2346: THEN
2347: bis_vg_log.write_error_to_string(l_error_message);
2348: BEGIN
2349: execute immediate update_status_stmt
2350: using
2351: 'FAILED_ALL',

Line 2375: bis_vg_log.update_success_log( l_View_Table(i).view_name

2371: RAISE; --- the same excpetion to the next block
2372: END; --- BLOCK inside IF enumerate-without-generate mode
2373:
2374: ELSE --- enumerate-without-generate mode
2375: bis_vg_log.update_success_log( l_View_Table(i).view_name
2376: , l_generated_view_name
2377: , l_return_status
2378: , l_error_Tbl
2379: );

Line 2386: bis_vg_log.backpatch_failure_log( l_View_Table(i).view_name

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: );
2390: l_return_status := FND_API.G_RET_STS_ERROR ;

Line 2392: bis_vg_log.backpatch_failure_log( l_View_Table(i).view_name

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: );
2396: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2399: bis_vg_log.update_failure_log( l_View_Table(i).view_name

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
2401: , SQLERRM
2402: , l_return_status
2403: , l_error_Tbl

Line 2408: bis_vg_log.write_log( g_mode

2404: );
2405: END;
2406: END LOOP;
2407: --
2408: bis_vg_log.write_log( g_mode
2409: , p_all_flag
2410: , p_App_Short_Name
2411: , p_KF_Appl_Short_Name
2412: , p_Key_Flex_Code

Line 2426: bis_vg_log.update_failure_log( l_error_tbl

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: );
2430: bis_vg_log.backpatch_failure_log( 'N/A'

Line 2430: bis_vg_log.backpatch_failure_log( 'N/A'

2426: bis_vg_log.update_failure_log( l_error_tbl
2427: , l_return_status
2428: , l_error_Tbl
2429: );
2430: bis_vg_log.backpatch_failure_log( 'N/A'
2431: , l_return_status
2432: , l_error_Tbl
2433: );
2434: bis_vg_log.write_log ( g_mode

Line 2434: bis_vg_log.write_log ( g_mode

2430: bis_vg_log.backpatch_failure_log( 'N/A'
2431: , l_return_status
2432: , l_error_Tbl
2433: );
2434: bis_vg_log.write_log ( g_mode
2435: , p_all_flag
2436: , p_App_Short_Name
2437: , p_KF_Appl_Short_Name
2438: , p_Key_Flex_Code