APPS.BIM_I_SGMT_ACT_FACTS_PKG dependencies on BIM_I_SGMT_ACT_FACTS_PKG

Line 1: PACKAGE BODY BIM_I_SGMT_ACT_FACTS_PKG AS

1: PACKAGE BODY BIM_I_SGMT_ACT_FACTS_PKG AS
2: /*$Header: bimisafb.pls 120.15.12010000.1 2008/07/29 21:04:39 appldev ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'BIM_I_SGMT_ACT_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimisafb.pls';

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'BIM_I_SGMT_ACT_FACTS_PKG';

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

Line 38: l_api_name CONSTANT VARCHAR2(30) := 'BIM_I_SGMT_ACT_FACTS_PKG';

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

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

487: p_count => x_msg_count,
488: p_data => x_msg_data
489: );
490:
491: bis_collection_utilities.log('BIM_I_SGMT_ACT_FACTS_PKG : FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
492:
493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
494:
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

501: p_count => x_msg_count,
502: p_data => x_msg_data
503: );
504:
505: bis_collection_utilities.log('BIM_I_SGMT_ACT_FACTS_PKG : FIRST_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
506:
507: WHEN OTHERS THEN
508:
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

520: p_count => x_msg_count,
521: p_data => x_msg_data
522: );
523:
524: bis_collection_utilities.log('BIM_I_SGMT_ACT_FACTS_PKG : FIRST_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
525:
526:
527:
528: END first_load;

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

759: p_count => x_msg_count,
760: p_data => x_msg_data
761: );
762:
763: bis_collection_utilities.log('BIM_I_SGMT_ACT_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
764:
765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
766:
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

773: p_count => x_msg_count,
774: p_data => x_msg_data
775: );
776:
777: bis_collection_utilities.log('BIM_I_SGMT_ACT_FACTS_PKG:INCREMENTAL_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
778:
779: WHEN OTHERS THEN
780:
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

792: p_count => x_msg_count,
793: p_data => x_msg_data
794: );
795:
796: bis_collection_utilities.log('BIM_I_SGMT_ACT_FACTS_PKG:INCREMENTAL_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
797:
798:
799: END incremental_load;
800:

Line 803: END BIM_I_SGMT_ACT_FACTS_PKG;

799: END incremental_load;
800:
801:
802:
803: END BIM_I_SGMT_ACT_FACTS_PKG;
804: