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 AMS_UTILITY_PVT

Line 39: ams_utility_pvt.Convert_Currency (

35: END IF;
36:
37: -- Call the proper AMS_UTILITY_API API to convert the amount.
38:
39: ams_utility_pvt.Convert_Currency (
40: x_return_status ,
41: p_from_currency,
42: l_to_currency,
43: sysdate,

Line 162: -- AMS_UTILITY_PVT.debug_message('Private API: ' || 'Running the populate procedure');

158: -- Initialize API return status to SUCCESS
159: x_return_status := FND_API.G_RET_STS_SUCCESS;
160:
161: -- Debug Message
162: -- AMS_UTILITY_PVT.debug_message('Private API: ' || 'Running the populate procedure');
163:
164: /* Find if the data will be loaded for the first time or not.*/
165: DECLARE
166: CURSOR chk_history_data IS

Line 194: ams_utility_pvt.write_conc_log('First Time Load is already run. Subsequent Load should be run .');

190: END IF;
191:
192: IF (l_end_date IS NOT NULL AND p_start_date IS NOT NULL)
193: THEN
194: ams_utility_pvt.write_conc_log('First Time Load is already run. Subsequent Load should be run .');
195: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now');
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198:

Line 195: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now');

191:
192: IF (l_end_date IS NOT NULL AND p_start_date IS NOT NULL)
193: THEN
194: ams_utility_pvt.write_conc_log('First Time Load is already run. Subsequent Load should be run .');
195: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now');
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198:
199:

Line 203: ams_utility_pvt.write_conc_log('The start date cannot be greater than or equal to the current end date');

199:
200: IF p_start_date IS NOT NULL THEN
201:
202: IF (p_start_date >= l_temp_p_end_date) THEN
203: ams_utility_pvt.write_conc_log('The start date cannot be greater than or equal to the current end date');
204: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now ');
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207:

Line 204: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now ');

200: IF p_start_date IS NOT NULL THEN
201:
202: IF (p_start_date >= l_temp_p_end_date) THEN
203: ams_utility_pvt.write_conc_log('The start date cannot be greater than or equal to the current end date');
204: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now ');
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207:
208: l_temp_start_date := trunc(p_start_date);

Line 216: ams_utility_pvt.write_conc_log('This program is already run upto: ' || trunc(l_end_date));

212: ELSE
213: IF l_end_date IS NOT NULL THEN
214:
215: IF (l_temp_p_end_date <= l_end_date) THEN
216: ams_utility_pvt.write_conc_log('This program is already run upto: ' || trunc(l_end_date));
217: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now ');
218: RAISE FND_API.g_exc_error;
219: END IF;
220:

Line 217: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now ');

213: IF l_end_date IS NOT NULL THEN
214:
215: IF (l_temp_p_end_date <= l_end_date) THEN
216: ams_utility_pvt.write_conc_log('This program is already run upto: ' || trunc(l_end_date));
217: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now ');
218: RAISE FND_API.g_exc_error;
219: END IF;
220:
221: l_temp_start_date := trunc(l_end_date) + 1;

Line 254: ams_utility_pvt.write_conc_log('----Period Validation----');

250: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
251: RAISE FND_API.g_exc_unexpected_error;
252: END IF;
253: ELSE
254: ams_utility_pvt.write_conc_log('----Period Validation----');
255: ams_utility_pvt.write_conc_log(l_period_error);
256: ams_utility_pvt.write_conc_log('----Currency Validation----');
257: ams_utility_pvt.write_conc_log(l_currency_error);
258:

Line 255: ams_utility_pvt.write_conc_log(l_period_error);

251: RAISE FND_API.g_exc_unexpected_error;
252: END IF;
253: ELSE
254: ams_utility_pvt.write_conc_log('----Period Validation----');
255: ams_utility_pvt.write_conc_log(l_period_error);
256: ams_utility_pvt.write_conc_log('----Currency Validation----');
257: ams_utility_pvt.write_conc_log(l_currency_error);
258:
259: END IF;

Line 256: ams_utility_pvt.write_conc_log('----Currency Validation----');

252: END IF;
253: ELSE
254: ams_utility_pvt.write_conc_log('----Period Validation----');
255: ams_utility_pvt.write_conc_log(l_period_error);
256: ams_utility_pvt.write_conc_log('----Currency Validation----');
257: ams_utility_pvt.write_conc_log(l_currency_error);
258:
259: END IF;
260:

Line 257: ams_utility_pvt.write_conc_log(l_currency_error);

253: ELSE
254: ams_utility_pvt.write_conc_log('----Period Validation----');
255: ams_utility_pvt.write_conc_log(l_period_error);
256: ams_utility_pvt.write_conc_log('----Currency Validation----');
257: ams_utility_pvt.write_conc_log(l_currency_error);
258:
259: END IF;
260:
261: --Standard check of commit

Line 268: ams_utility_pvt.write_conc_log('Campaigns Concurrent Program Succesfully Completed ');

264: COMMIT WORK;
265: END IF;
266:
267: COMMIT;
268: ams_utility_pvt.write_conc_log('Campaigns Concurrent Program Succesfully Completed ');
269:
270: -- Standard call to get message count and if count is 1, get message info.
271: FND_MSG_PUB.Count_And_Get
272: (p_count => x_msg_count,

Line 343: --AMS_UTILITY_PVT.debug_message('Private API: ' || 'Running the LOG_HISTORY procedure ');

339:
340: BEGIN
341:
342: -- Debug Message
343: --AMS_UTILITY_PVT.debug_message('Private API: ' || 'Running the LOG_HISTORY procedure ');
344:
345: /* -- Standard call to check for call compatibility.
346: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
347: p_api_version_number,

Line 528: ams_utility_pvt.write_conc_log(p_start_date || ' '|| p_end_date);

524: l_schema VARCHAR2(30);
525: l_return BOOLEAN;
526: BEGIN
527: l_return := fnd_installation.get_app_info('BIM', l_status1, l_industry1, l_schema);
528: ams_utility_pvt.write_conc_log(p_start_date || ' '|| p_end_date);
529: -- Standard call to check for call compatibility.
530: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
531: p_api_version_number,
532: l_api_name,

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 2730: ams_utility_pvt.write_conc_log(p_start_date || ' '|| p_end_date);

2726: l_industry1 VARCHAR2(5);
2727: l_return boolean;
2728: BEGIN
2729: l_return := fnd_installation.get_app_info('BIM', l_status1, l_industry1, l_schema);
2730: ams_utility_pvt.write_conc_log(p_start_date || ' '|| p_end_date);
2731: l_camp := 0;
2732:
2733: -- Standard call to check for call compatibility.
2734: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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: