eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_CAMPAIGN_FACTS dependencies on BIM_CAMPAIGN_FACTS

Line 1: PACKAGE BODY BIM_CAMPAIGN_FACTS AS

1: PACKAGE BODY BIM_CAMPAIGN_FACTS AS
2: /*$Header: bimcmpfb.pls 120.1 2005/12/05 06:50:19 arvikuma noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_CAMPAIGN_FACTS';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimcmpfb.pls';

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

1: PACKAGE BODY BIM_CAMPAIGN_FACTS AS
2: /*$Header: bimcmpfb.pls 120.1 2005/12/05 06:50:19 arvikuma noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(20) := 'BIM_CAMPAIGN_FACTS';
5: g_file_name CONSTANT VARCHAR2(20) := 'bimcmpfb.pls';
6:
7: FUNCTION convert_currency(
8: p_from_currency VARCHAR2

Line 547: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS: Running the First Load '||sqlerrm(sqlcode));

543:
544: -- Initialize API return status to SUCCESS
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546:
547: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS: Running the First Load '||sqlerrm(sqlcode));
548:
549: -- The below four commands are necessary for the purpose of the parallel insertion */
550:
551: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL dml ';

Line 606: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE FIRST INSERT ' || l_temp_msg);

602:
603: l_org_id := 0;
604:
605: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
606: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE FIRST INSERT ' || l_temp_msg);
607:
608: INSERT /*+ append parallel(CDF,1) */
609: INTO bim_r_camp_daily_facts CDF
610: (

Line 1110: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER FIRST INSERT ' || l_temp_msg);

1106:
1107: COMMIT;
1108:
1109: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1110: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER FIRST INSERT ' || l_temp_msg);
1111:
1112: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1113: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE SECOND INSERT ' || l_temp_msg);
1114:

Line 1113: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE SECOND INSERT ' || l_temp_msg);

1109: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1110: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER FIRST INSERT ' || l_temp_msg);
1111:
1112: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1113: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE SECOND INSERT ' || l_temp_msg);
1114:
1115: INSERT /*+ append parallel(CDF,1) */
1116: INTO bim_r_camp_daily_facts CDF
1117: (

Line 1699: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER SECOND INSERT ' || l_temp_msg);

1695: AND trunc(a.actual_exec_start_date) >= trunc(p_start_date)
1696: )Outer;
1697:
1698: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1699: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER SECOND INSERT ' || l_temp_msg);
1700:
1701: COMMIT;
1702: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_camp_daily_facts_s CACHE 20';
1703:

Line 1707: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE THIRD INSERT ' || l_temp_msg);

1703:
1704: /* This insert deals with the budgets for campaigns */
1705:
1706: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1707: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE THIRD INSERT ' || l_temp_msg);
1708:
1709: INSERT /*+ append parallel(CDF,1) */
1710: INTO bim_r_camp_daily_facts CDF
1711: (

Line 1972: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER THIRD INSERT ' || l_temp_msg);

1968: COMMIT;
1969:
1970:
1971: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1972: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER THIRD INSERT ' || l_temp_msg);
1973:
1974:
1975: /***************************************************************/
1976: /* This insert deals with schdule budgets */

Line 1979: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE FOURTH INSERT ' || l_temp_msg);

1975: /***************************************************************/
1976: /* This insert deals with schdule budgets */
1977:
1978: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1979: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE FOURTH INSERT ' || l_temp_msg);
1980:
1981: INSERT /*+ append parallel(CDF,1) */
1982: INTO bim_r_camp_daily_facts CDF
1983: (

Line 2295: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER FOURTH INSERT ' || l_temp_msg);

2291: COMMIT;
2292:
2293:
2294: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2295: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER FOURTH INSERT ' || l_temp_msg);
2296:
2297:
2298:
2299: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');

Line 2300: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE ANALYZING DAILY FACTS ' || l_temp_msg);

2296:
2297:
2298:
2299: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2300: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE ANALYZING DAILY FACTS ' || l_temp_msg);
2301:
2302: -- Analyze the daily facts table
2303: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_DAILY_FACTS', estimate_percent => 5,
2304: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 2307: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER ANALYZING DAILY FACTS ' || l_temp_msg);

2303: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_DAILY_FACTS', estimate_percent => 5,
2304: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2305:
2306: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2307: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER ANALYZING DAILY FACTS ' || l_temp_msg);
2308:
2309: /***************************************************************/
2310:
2311: /* INSERT INTO WEEKLY SUMMARY TABLE */

Line 2317: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE WEEKLY TABLE INSERT ' || l_temp_msg);

2313: /* Here we are inserting the summarized data into the weekly facts by taking it from the daily facts.
2314: For every week we have a record since we group by that weekend date which is nothing but the Load date. */
2315:
2316: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2317: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE WEEKLY TABLE INSERT ' || l_temp_msg);
2318:
2319: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_camp_weekly_facts';
2320:
2321: /*BEGIN BLOCK FOR THE WEEKLY INSERT */

Line 2511: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER WEEKLY TABLE INSERT ' || l_temp_msg);

2507: COMMIT;
2508:
2509:
2510: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2511: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER WEEKLY TABLE INSERT ' || l_temp_msg);
2512:
2513: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2514: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE ANALYZING WEEKLY FACTS ' || l_temp_msg);
2515:

Line 2514: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE ANALYZING WEEKLY FACTS ' || l_temp_msg);

2510: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2511: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER WEEKLY TABLE INSERT ' || l_temp_msg);
2512:
2513: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2514: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE ANALYZING WEEKLY FACTS ' || l_temp_msg);
2515:
2516: -- Analyze the daily facts table
2517: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_WEEKLY_FACTS', estimate_percent => 5,
2518: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 2521: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER ANALYZING WEEKLY FACTS ' || l_temp_msg);

2517: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_WEEKLY_FACTS', estimate_percent => 5,
2518: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
2519:
2520: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2521: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER ANALYZING WEEKLY FACTS ' || l_temp_msg);
2522:
2523:
2524: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2525: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE COST UPDATE ' || l_temp_msg);

Line 2525: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE COST UPDATE ' || l_temp_msg);

2521: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER ANALYZING WEEKLY FACTS ' || l_temp_msg);
2522:
2523:
2524: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2525: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE COST UPDATE ' || l_temp_msg);
2526:
2527:
2528: -- Make entry in the history table
2529:

Line 2536: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE CREATE INDEX ' || l_temp_msg);

2532:
2533: /* Piece of Code for Recreating the index on the same tablespace with the same storage parameters */
2534:
2535: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2536: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: BEFORE CREATE INDEX ' || l_temp_msg);
2537:
2538: i := i - 1;
2539: WHILE(i>=1) LOOP
2540: EXECUTE IMMEDIATE 'CREATE INDEX '

Line 2567: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER CREATE INDEX ' || l_temp_msg);

2563: i := i - 1;
2564: END LOOP;
2565:
2566: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2567: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD: AFTER CREATE INDEX ' || l_temp_msg);
2568:
2569: /* End of Code for Recreating the index on the same tablespace with the same storage parameters */
2570:
2571:

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

2582: p_count => x_msg_count,
2583: p_data => x_msg_data
2584: );
2585:
2586: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
2587:
2588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2589:
2590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2595: p_count => x_msg_count,
2596: p_data => x_msg_data
2597: );
2598:
2599: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
2600:
2601: WHEN OTHERS THEN
2602:
2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2613: p_count => x_msg_count,
2614: p_data => x_msg_data
2615: );
2616:
2617: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:FIRST_LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
2618:
2619: END CAMPAIGN_FIRST_LOAD;
2620:
2621:

Line 2817: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE FIRST INSERT ' || l_temp_msg);

2813:
2814: l_org_id := 0;
2815:
2816: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2817: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE FIRST INSERT ' || l_temp_msg);
2818:
2819: INSERT /*+ append parallel(CDF,1) */
2820: INTO bim_r_camp_daily_facts CDF
2821: (

Line 3321: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER FIRST INSERT ' || l_temp_msg);

3317:
3318: COMMIT;
3319:
3320: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
3321: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER FIRST INSERT ' || l_temp_msg);
3322:
3323:
3324: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
3325: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE SECOND INSERT ' || l_temp_msg);

Line 3325: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE SECOND INSERT ' || l_temp_msg);

3321: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER FIRST INSERT ' || l_temp_msg);
3322:
3323:
3324: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
3325: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE SECOND INSERT ' || l_temp_msg);
3326:
3327: INSERT /*+ append parallel(CDF,1) */
3328: INTO bim_r_camp_daily_facts CDF
3329: (

Line 3912: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER SECOND INSERT ' || l_temp_msg);

3908: )Outer;
3909:
3910: COMMIT;
3911: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
3912: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER SECOND INSERT ' || l_temp_msg);
3913:
3914: EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL dml ';
3915: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL dml ';
3916:

Line 3923: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE THIRD INSERT ' || l_temp_msg);

3919: /* The above main INSERT statement handles the amounts associated with the SCHEDULEs. Here with this stmt we
3920: are dealing with the CAMPAIGNs of the campaigns table */
3921:
3922: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
3923: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE THIRD INSERT ' || l_temp_msg);
3924: INSERT /*+ append parallel(CDF,1) */
3925: INTO bim_r_camp_daily_facts CDF
3926: (
3927: campaign_daily_transaction_id

Line 4187: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: THIRD SECOND INSERT ' || l_temp_msg);

4183: COMMIT;
4184:
4185:
4186: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4187: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: THIRD SECOND INSERT ' || l_temp_msg);
4188:
4189:
4190: /***************************************************************/
4191: /* This insert deals with schdule budgets */

Line 4194: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE FOURTH INSERT ' || l_temp_msg);

4190: /***************************************************************/
4191: /* This insert deals with schdule budgets */
4192:
4193: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4194: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE FOURTH INSERT ' || l_temp_msg);
4195:
4196: INSERT /*+ append parallel(CDF,1) */
4197: INTO bim_r_camp_daily_facts CDF
4198: (

Line 4515: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER FOURTH INSERT ' || l_temp_msg);

4511: COMMIT;
4512:
4513:
4514: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4515: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER FOURTH INSERT ' || l_temp_msg);
4516:
4517:
4518: /***************************************************************/
4519:

Line 4522: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE ANALYZING DAILY FACTS ' || l_temp_msg);

4518: /***************************************************************/
4519:
4520:
4521: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4522: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE ANALYZING DAILY FACTS ' || l_temp_msg);
4523:
4524: -- Analyze the daily facts table
4525: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_DAILY_FACTS', estimate_percent => 5,
4526: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 4529: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER ANALYZING DAILY FACTS ' || l_temp_msg);

4525: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_DAILY_FACTS', estimate_percent => 5,
4526: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4527:
4528: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4529: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER ANALYZING DAILY FACTS ' || l_temp_msg);
4530:
4531: /***************************************************************/
4532:
4533: /* INSERT INTO WEEKLY SUMMARY TABLE */

Line 4539: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE WEEKLY TABLE INSERT ' || l_temp_msg);

4535: /* Here we are inserting the summarized data into the weekly facts by taking it from the daily facts.
4536: For every week we have a record since we group by that weekend date which is nothing but the Load date. */
4537:
4538: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4539: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE WEEKLY TABLE INSERT ' || l_temp_msg);
4540:
4541: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_camp_weekly_facts';
4542:
4543: /*BEGIN BLOCK FOR THE WEEKLY INSERT */

Line 4734: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER WEEKLY TABLE INSERT ' || l_temp_msg);

4730: COMMIT;
4731:
4732:
4733: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4734: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER WEEKLY TABLE INSERT ' || l_temp_msg);
4735:
4736: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4737: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE ANALYZING WEEKLY FACTS ' || l_temp_msg);
4738:

Line 4737: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE ANALYZING WEEKLY FACTS ' || l_temp_msg);

4733: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4734: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER WEEKLY TABLE INSERT ' || l_temp_msg);
4735:
4736: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4737: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE ANALYZING WEEKLY FACTS ' || l_temp_msg);
4738:
4739: -- Analyze the daily facts table
4740: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_WEEKLY_FACTS', estimate_percent => 5,
4741: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 4744: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER ANALYZING WEEKLY FACTS ' || l_temp_msg);

4740: DBMS_STATS.gather_table_stats('BIM','BIM_R_CAMP_WEEKLY_FACTS', estimate_percent => 5,
4741: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
4742:
4743: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4744: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER ANALYZING WEEKLY FACTS ' || l_temp_msg);
4745:
4746:
4747: /* Piece of Code for Recreating the index on the same tablespace with the same storage parameters */
4748:

Line 4750: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE CREATE INDEX ' || l_temp_msg);

4746:
4747: /* Piece of Code for Recreating the index on the same tablespace with the same storage parameters */
4748:
4749: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4750: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: BEFORE CREATE INDEX ' || l_temp_msg);
4751:
4752: i := i - 1;
4753: WHILE(i>=1) LOOP
4754: EXECUTE IMMEDIATE 'CREATE INDEX '

Line 4781: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER CREATE INDEX ' || l_temp_msg);

4777: i := i - 1;
4778: END LOOP;
4779:
4780: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4781: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD: AFTER CREATE INDEX ' || l_temp_msg);
4782:
4783: /* End of Code for Recreating the index on the same tablespace with the same storage parameters */
4784:
4785:

Line 4801: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));

4797: p_count => x_msg_count,
4798: p_data => x_msg_data
4799: );
4800:
4801: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
4802:
4803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4804:
4805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4814: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));

4810: p_count => x_msg_count,
4811: p_data => x_msg_data
4812: );
4813:
4814: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
4815:
4816: WHEN OTHERS THEN
4817:
4818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4832: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));

4828: p_count => x_msg_count,
4829: p_data => x_msg_data
4830: );
4831:
4832: ams_utility_pvt.write_conc_log('BIM_CAMPAIGN_FACTS:LOAD:IN OTHERS EXCEPTION '||sqlerrm(sqlcode));
4833:
4834:
4835: END CAMPAIGN_SUBSEQUENT_LOAD;
4836:

Line 4872: END BIM_CAMPAIGN_FACTS;

4868: l_min_date := sysdate;
4869:
4870: END CAMPAIGN_DAILY_LOAD;
4871:
4872: END BIM_CAMPAIGN_FACTS;