APPS.BIM_LEAD_FACTS_PKG dependencies on BIM_LEAD_FACTS_PKG

Line 1: PACKAGE BODY BIM_LEAD_FACTS_PKG AS

1: PACKAGE BODY BIM_LEAD_FACTS_PKG AS
2: /*$Header: bimldsfb.pls 120.2 2005/11/11 05:08:51 arvikuma noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_LEAD_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimldsfb.pls';

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

1: PACKAGE BODY BIM_LEAD_FACTS_PKG AS
2: /*$Header: bimldsfb.pls 120.2 2005/11/11 05:08:51 arvikuma noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_LEAD_FACTS_PKG';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimldsfb.pls';
6:
7: ------------------------------------------------------------------------------------------------
8: ----

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

35: l_end_date DATE;
36: l_user_id NUMBER := FND_GLOBAL.USER_ID();
37: l_sysdate DATE := SYSDATE;
38: l_api_version_number CONSTANT NUMBER := 1.0;
39: l_api_name CONSTANT VARCHAR2(30) := 'BIM_LEAD_FACTS_PKG';
40: l_success VARCHAR2(3);
41: l_temp DATE;
42: l_mesg_text VARCHAR2(100);
43: l_load_type VARCHAR2(100);

Line 258: l_api_name CONSTANT VARCHAR2(30) := 'BIM_LEAD_FACTS_PKG';

254: IS
255: l_user_id NUMBER := FND_GLOBAL.USER_ID();
256: l_sysdate DATE := SYSDATE;
257: l_api_version_number CONSTANT NUMBER := 1.0;
258: l_api_name CONSTANT VARCHAR2(30) := 'BIM_LEAD_FACTS_PKG';
259: l_success VARCHAR2(3);
260:
261: BEGIN
262:

Line 432: --ams_utility_pvt.write_conc_log('BIM_LEAD_FACTS_PKG: Running the Load_data ');

428:
429: -- Initialize API return status to SUCCESS
430: x_return_status := FND_API.G_RET_STS_SUCCESS;
431:
432: --ams_utility_pvt.write_conc_log('BIM_LEAD_FACTS_PKG: Running the Load_data ');
433:
434: -- The below four commands are necessary for the purpose of the parallel insertion */
435: --COMMIT;
436:

Line 1023: ams_utility_pvt.write_conc_log('BIM_LEAD_FACTS_PKG:LOAD_DATA:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));

1019: p_count => x_msg_count,
1020: p_data => x_msg_data
1021: );
1022:
1023: ams_utility_pvt.write_conc_log('BIM_LEAD_FACTS_PKG:LOAD_DATA:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
1024:
1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1026:
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1036: ams_utility_pvt.write_conc_log('BIM_LEAD_FACTS_PKG:LOAD_DATA:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));

1032: p_count => x_msg_count,
1033: p_data => x_msg_data
1034: );
1035:
1036: ams_utility_pvt.write_conc_log('BIM_LEAD_FACTS_PKG:LOAD_DATA:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
1037:
1038: WHEN OTHERS THEN
1039:
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1054: ams_utility_pvt.write_conc_log('BIM_LEAD_FACTS_PKG:LOAD_DATA:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));

1050: p_count => x_msg_count,
1051: p_data => x_msg_data
1052: );
1053:
1054: ams_utility_pvt.write_conc_log('BIM_LEAD_FACTS_PKG:LOAD_DATA:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
1055:
1056:
1057: END LOAD_DATA;
1058:

Line 1060: END BIM_LEAD_FACTS_PKG;

1056:
1057: END LOAD_DATA;
1058:
1059:
1060: END BIM_LEAD_FACTS_PKG;
1061: