[Home] [Help]
392:
393: BIS_VG_UTIL.Add_Error_message
394: ( p_error_msg_name => MISMATCHED_TAG_EXCEPTION_MSG
395: , p_error_proc_name => G_PKG_NAME||'.update_flexfields'
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;
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
1651: l_error_code := fnd_message.get_number( l_appl_short
1652: , l_error_msg
1653: );
1654: -- reset message stack
1655: fnd_msg_pub.reset;
1656: l_count := fnd_msg_pub.count_msg;
1657: --
1658: --- retrieve user-friendly message and pass it as a token for
1659: --- BIS_VG_FAIL_VIEW_NAME_PROMPT
1652: , l_error_msg
1653: );
1654: -- reset message stack
1655: fnd_msg_pub.reset;
1656: l_count := fnd_msg_pub.count_msg;
1657: --
1658: --- retrieve user-friendly message and pass it as a token for
1659: --- BIS_VG_FAIL_VIEW_NAME_PROMPT
1660: --- assumption: as the message stack is first populated with the
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);
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;
1681: );
1682: END LOOP;
1683: --
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
2105: OR g_mode = bis_vg_types.sqlplus_production_mode
2106: OR g_mode = bis_vg_types.remove_tags_mode
2107: ) THEN
2108: fnd_profile.put('FND_AS_MSG_LEVEL_THRESHOLD'
2109: , FND_MSG_PUB.G_MSG_LVL_SUCCESS);
2110: ELSE
2111: fnd_profile.put('FND_AS_MSG_LEVEL_THRESHOLD'
2112: , FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
2113: END IF;
2108: fnd_profile.put('FND_AS_MSG_LEVEL_THRESHOLD'
2109: , FND_MSG_PUB.G_MSG_LVL_SUCCESS);
2110: ELSE
2111: fnd_profile.put('FND_AS_MSG_LEVEL_THRESHOLD'
2112: , FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
2113: END IF;
2114: --
2115: l_debug_file := bis_debug_pub.set_debug_mode('FILE');
2116: bis_debug_pub.initialize;
2181: BIS_VG_UTIL.Add_Error_message
2182: ( p_error_msg_name => bis_view_generator_pvt.GENERATOR_NO_VIEWS
2183: , p_error_proc_name => G_PKG_NAME||'.generate_Views'
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;
2192: --
2193: --
2194: FOR i IN 1 .. l_View_Table.COUNT LOOP
2195: --
2196: fnd_msg_pub.initialize;
2197: l_generated_view_name :=
2198: bis_vg_util.get_generated_view_name (l_View_Table(i).view_name
2199: , l_return_status
2200: , l_error_Tbl
2467: WHEN OTHERS THEN
2468: bis_debug_pub.debug_on;
2469: bis_debug_pub.add('bis_view_generator_pvt.set_mode');
2470: bis_debug_pub.debug_off;
2471: fnd_msg_pub.Add_Exc_Msg( 'bis_view_generator_pvt'
2472: , 'set_mode'
2473: );
2474: RAISE;
2475: --