APPS.BIM_I_SGMT_FACTS_PKG dependencies on BIM_I_SGMT_FACTS_PKG

Line 1: PACKAGE BODY BIM_I_SGMT_FACTS_PKG AS

1: PACKAGE BODY BIM_I_SGMT_FACTS_PKG AS
2: /*$Header: bimisgfb.pls 120.23.12010000.1 2008/07/29 21:04:47 appldev ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_I_SGMT_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimisgfb.pls';

Line 4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_I_SGMT_FACTS_PKG';

1: PACKAGE BODY BIM_I_SGMT_FACTS_PKG AS
2: /*$Header: bimisgfb.pls 120.23.12010000.1 2008/07/29 21:04:47 appldev ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_I_SGMT_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimisgfb.pls';
6: g_initial_start_date DATE ;
7:
8:

Line 39: l_api_name CONSTANT VARCHAR2(30) := 'BIM_I_SGMT_FACTS_PKG';

35: l_start_date DATE;
36: l_end_date DATE;
37: l_user_id NUMBER := FND_GLOBAL.USER_ID();
38: l_api_version_number CONSTANT NUMBER := 1.0;
39: l_api_name CONSTANT VARCHAR2(30) := 'BIM_I_SGMT_FACTS_PKG';
40: l_mesg_text VARCHAR2(100);
41: l_load_type VARCHAR2(100);
42: l_year_start_date DATE;
43: l_global_date DATE;

Line 634: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));

630: p_count => x_msg_count,
631: p_data => x_msg_data
632: );
633:
634: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
635:
636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
637:
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 648: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:FIRST_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));

644: p_count => x_msg_count,
645: p_data => x_msg_data
646: );
647:
648: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:FIRST_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
649:
650: WHEN OTHERS THEN
651:
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 668: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:FIRST_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));

664: p_count => x_msg_count,
665: p_data => x_msg_data
666: );
667:
668: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:FIRST_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
669:
670:
671: END first_load;
672:

Line 1030: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));

1026: p_count => x_msg_count,
1027: p_data => x_msg_data
1028: );
1029:
1030: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
1031:
1032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1033:
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1044: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:INCREMENTAL_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));

1040: p_count => x_msg_count,
1041: p_data => x_msg_data
1042: );
1043:
1044: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:INCREMENTAL_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
1045:
1046: WHEN OTHERS THEN
1047:
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1063: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:INCREMENTAL_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));

1059: p_count => x_msg_count,
1060: p_data => x_msg_data
1061: );
1062:
1063: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:INCREMENTAL_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
1064:
1065:
1066: END incremental_load;
1067:

Line 1069: END bim_i_sgmt_facts_pkg;

1065:
1066: END incremental_load;
1067:
1068:
1069: END bim_i_sgmt_facts_pkg;
1070: