APPS.BIM_RESPONSE_FACTS_PKG dependencies on BIM_RESPONSE_FACTS_PKG

Line 1: PACKAGE BODY BIM_RESPONSE_FACTS_PKG AS

1: PACKAGE BODY BIM_RESPONSE_FACTS_PKG AS
2: /*$Header: bimrspfb.pls 120.3 2005/11/11 05:08:59 arvikuma noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(200) := 'BIM_RESPONSE_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimrspfb.pls';

Line 4: g_pkg_name CONSTANT VARCHAR2(200) := 'BIM_RESPONSE_FACTS_PKG';

1: PACKAGE BODY BIM_RESPONSE_FACTS_PKG AS
2: /*$Header: bimrspfb.pls 120.3 2005/11/11 05:08:59 arvikuma noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(200) := 'BIM_RESPONSE_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimrspfb.pls';
6:
7: ----------------------------------------------------------------------------------------------------
8: /* This procedure will conditionally call RESPONSES_FACTS_LOAD */

Line 34: l_api_name CONSTANT VARCHAR2(30) := 'BIM_RESPONSE_FACTS_PKG';

30: l_end_date DATE;
31: l_user_id NUMBER := FND_GLOBAL.USER_ID();
32: l_sysdate DATE := SYSDATE;
33: l_api_version_number CONSTANT NUMBER := 1.0;
34: l_api_name CONSTANT VARCHAR2(30) := 'BIM_RESPONSE_FACTS_PKG';
35: l_success VARCHAR2(3);
36: s_date DATE := to_date('01/01/1950 01:01:01', 'DD/MM/YYYY HH:MI:SS') ;
37: l_temp DATE;
38: l_mesg_text VARCHAR2(100);

Line 229: l_api_name CONSTANT VARCHAR2(30) := 'BIM_RESPONSE_FACTS_PKG';

225: IS
226: l_user_id NUMBER := FND_GLOBAL.USER_ID();
227: l_sysdate DATE := SYSDATE;
228: l_api_version_number CONSTANT NUMBER := 1.0;
229: l_api_name CONSTANT VARCHAR2(30) := 'BIM_RESPONSE_FACTS_PKG';
230: l_success VARCHAR2(3);
231:
232: BEGIN
233:

Line 831: ams_utility_pvt.write_conc_log('BIM_RESPONSE_FACTS_PKG:RESPONSES_FACTS_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));

827: p_count => x_msg_count,
828: p_data => x_msg_data
829: );
830:
831: ams_utility_pvt.write_conc_log('BIM_RESPONSE_FACTS_PKG:RESPONSES_FACTS_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
832:
833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
834:
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 844: ams_utility_pvt.write_conc_log('BIM_RESPONSE_FACTS_PKG:RESPONSES_FACTS_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));

840: p_count => x_msg_count,
841: p_data => x_msg_data
842: );
843:
844: ams_utility_pvt.write_conc_log('BIM_RESPONSE_FACTS_PKG:RESPONSES_FACTS_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
845:
846: WHEN OTHERS THEN
847:
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 862: ams_utility_pvt.write_conc_log('BIM_RESPONSE_FACTS_PKG:RESPONSES_FACTS_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));

858: p_count => x_msg_count,
859: p_data => x_msg_data
860: );
861:
862: ams_utility_pvt.write_conc_log('BIM_RESPONSE_FACTS_PKG:RESPONSES_FACTS_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
863:
864:
865: END RESPONSES_FACTS_LOAD;
866:

Line 868: END BIM_RESPONSE_FACTS_PKG;

864:
865: END RESPONSES_FACTS_LOAD;
866:
867:
868: END BIM_RESPONSE_FACTS_PKG;