DBA Data[Home] [Help]

APPS.BIM_I_SRC_CODE_PKG dependencies on BIM_I_SRC_CODE_PKG

Line 1: PACKAGE BODY BIM_I_SRC_CODE_PKG AS

1: PACKAGE BODY BIM_I_SRC_CODE_PKG AS
2: /*$Header: bimiscdb.pls 120.6 2006/01/23 02:08:06 arvikuma noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_I_SRC_CODE_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimiscdb.pls';

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

1: PACKAGE BODY BIM_I_SRC_CODE_PKG AS
2: /*$Header: bimiscdb.pls 120.6 2006/01/23 02:08:06 arvikuma noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_I_SRC_CODE_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimiscdb.pls';
6: g_start_date CONSTANT DATE := to_date(fnd_profile.value('BIS_GLOBAL_START_DATE'),'MM/DD/YYYY');
7:
8: ------------------------------------------------------------------------------------------------

Line 38: l_api_name CONSTANT VARCHAR2(30) := 'BIM_I_SRC_CODE_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_SRC_CODE_PKG';
39: l_mesg_text VARCHAR2(100);
40: l_load_type VARCHAR2(100);
41: l_global_date CONSTANT DATE := bis_common_parameters.get_global_start_date;
42: l_missing_date BOOLEAN := FALSE;

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

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

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

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

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

816: p_count => x_msg_count,
817: p_data => x_msg_data
818: );
819:
820: ams_utility_pvt.write_conc_log('BIM_I_SRC_CODE_PKG:FIRST_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
821:
822:
823: END FIRST_LOAD;
824:

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

1527: p_count => x_msg_count,
1528: p_data => x_msg_data
1529: );
1530:
1531: ams_utility_pvt.write_conc_log('BIM_I_SRC_CODE_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
1532:
1533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1534:
1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1540: p_count => x_msg_count,
1541: p_data => x_msg_data
1542: );
1543:
1544: ams_utility_pvt.write_conc_log('BIM_I_SRC_CODE_PKG:INCREMENTAL_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
1545:
1546: WHEN OTHERS THEN
1547:
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1558: p_count => x_msg_count,
1559: p_data => x_msg_data
1560: );
1561:
1562: ams_utility_pvt.write_conc_log('BIM_I_SRC_CODE_PKG:INCREMENTAL_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
1563:
1564:
1565: END INCREMENTAL_LOAD;
1566:

Line 1568: END BIM_I_SRC_CODE_PKG;

1564:
1565: END INCREMENTAL_LOAD;
1566:
1567:
1568: END BIM_I_SRC_CODE_PKG;
1569: