APPS.BIM_I_LEAD_FACTS_PKG dependencies on BIM_I_LEAD_FACTS_PKG

Line 1: PACKAGE BODY BIM_I_LEAD_FACTS_PKG AS

1: PACKAGE BODY BIM_I_LEAD_FACTS_PKG AS
2: /*$Header: bimildfb.pls 120.1 2005/10/11 05:38:48 sbassi noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_I_LEAD_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimildfb.pls';

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

1: PACKAGE BODY BIM_I_LEAD_FACTS_PKG AS
2: /*$Header: bimildfb.pls 120.1 2005/10/11 05:38:48 sbassi noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_I_LEAD_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimildfb.pls';
6: l_global_currency_code varchar2(20);
7:
8:

Line 98: l_api_name CONSTANT VARCHAR2(30) := 'BIM_I_LEAD_FACTS_PKG';

94: l_start_date DATE;
95: l_end_date DATE;
96: l_user_id NUMBER := FND_GLOBAL.USER_ID();
97: l_api_version_number CONSTANT NUMBER := 1.0;
98: l_api_name CONSTANT VARCHAR2(30) := 'BIM_I_LEAD_FACTS_PKG';
99: l_mesg_text VARCHAR2(100);
100: l_load_type VARCHAR2(100);
101: l_global_date DATE;
102: l_missing_date BOOLEAN := FALSE;

Line 792: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));

788: p_count => x_msg_count,
789: p_data => x_msg_data
790: );
791:
792: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
793:
794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
795:
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 805: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:FIRST_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));

801: p_count => x_msg_count,
802: p_data => x_msg_data
803: );
804:
805: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:FIRST_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
806:
807: WHEN OTHERS THEN
808:
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 823: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:FIRST_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));

819: p_count => x_msg_count,
820: p_data => x_msg_data
821: );
822:
823: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:FIRST_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
824:
825:
826: END FIRST_LOAD;
827:

Line 1512: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));

1508: p_count => x_msg_count,
1509: p_data => x_msg_data
1510: );
1511:
1512: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
1513:
1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1515:
1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1525: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:INCREMENTAL_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));

1521: p_count => x_msg_count,
1522: p_data => x_msg_data
1523: );
1524:
1525: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:INCREMENTAL_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
1526:
1527: WHEN OTHERS THEN
1528:
1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1543: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:INCREMENTAL_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));

1539: p_count => x_msg_count,
1540: p_data => x_msg_data
1541: );
1542:
1543: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:INCREMENTAL_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
1544:
1545:
1546: END INCREMENTAL_LOAD;
1547:

Line 1549: END BIM_I_LEAD_FACTS_PKG;

1545:
1546: END INCREMENTAL_LOAD;
1547:
1548:
1549: END BIM_I_LEAD_FACTS_PKG;
1550: