APPS.BIM_I_SGMT_CUST_FACTS_PKG dependencies on BIM_I_SGMT_CUST_FACTS_PKG

Line 1: PACKAGE BODY BIM_I_SGMT_CUST_FACTS_PKG AS

1: PACKAGE BODY BIM_I_SGMT_CUST_FACTS_PKG AS
2: /*$Header: bimiscfb.pls 120.16.12010000.1 2008/07/29 21:04:43 appldev ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'BIM_I_SGMT_CUST_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimispfb.pls';

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

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

Line 38: l_api_name CONSTANT VARCHAR2(30) := 'BIM_I_SGMT_CUST_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_CUST_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 501: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG : FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));

497: p_count => x_msg_count,
498: p_data => x_msg_data
499: );
500:
501: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG : FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504:
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

511: p_count => x_msg_count,
512: p_data => x_msg_data
513: );
514:
515: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG : FIRST_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
516:
517: WHEN OTHERS THEN
518:
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

530: p_count => x_msg_count,
531: p_data => x_msg_data
532: );
533:
534: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG : FIRST_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
535:
536: END first_load;
537:
538: --------------------------------------------------------------------------------------------------

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

890: p_count => x_msg_count,
891: p_data => x_msg_data
892: );
893:
894: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
895:
896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
897:
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

904: p_count => x_msg_count,
905: p_data => x_msg_data
906: );
907:
908: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG:INCREMENTAL_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
909:
910: WHEN OTHERS THEN
911:
912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

923: p_count => x_msg_count,
924: p_data => x_msg_data
925: );
926:
927: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG:INCREMENTAL_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
928:
929:
930: END incremental_load;
931:

Line 933: END BIM_I_SGMT_CUST_FACTS_PKG;

929:
930: END incremental_load;
931:
932:
933: END BIM_I_SGMT_CUST_FACTS_PKG;
934: