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_EVENT_FACTS dependencies on AMS_UTILITY_PVT

Line 49: ams_utility_pvt.Convert_Currency (

45: END IF;
46:
47: -- Call the proper AMS_UTILITY_API API to convert the amount.
48:
49: ams_utility_pvt.Convert_Currency (
50: x_return_status ,
51: p_from_currency,
52: l_to_currency,
53: sysdate,

Line 137: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

133: FND_MSG_PUB.initialize;
134: END IF;
135:
136: -- Debug Message
137: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
138:
139: -- Initialize API return status to SUCCESS
140: x_return_status := FND_API.G_RET_STS_SUCCESS;
141:

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

157: l_err_code :=0;
158: IF (l_err_code = 0) THEN -- Validation Succesful
159: IF (l_max_end_date IS NOT NULL AND p_start_date IS NOT NULL)
160: THEN
161: ams_utility_pvt.write_conc_log('First Time Load is already run. Subsequent Load should be run.');
162: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now');
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:

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

158: IF (l_err_code = 0) THEN -- Validation Succesful
159: IF (l_max_end_date IS NOT NULL AND p_start_date IS NOT NULL)
160: THEN
161: ams_utility_pvt.write_conc_log('First Time Load is already run. Subsequent Load should be run.');
162: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now');
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:
166:

Line 170: ams_utility_pvt.write_conc_log('The start date cannot be greater than current end date');

166:
167: IF p_start_date IS NOT NULL THEN
168:
169: IF (p_start_date > p_end_date) THEN
170: ams_utility_pvt.write_conc_log('The start date cannot be greater than current end date');
171: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now ');
172: RAISE FND_API.G_EXC_ERROR;
173: END IF;
174:

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

167: IF p_start_date IS NOT NULL THEN
168:
169: IF (p_start_date > p_end_date) THEN
170: ams_utility_pvt.write_conc_log('The start date cannot be greater than current end date');
171: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now ');
172: RAISE FND_API.G_EXC_ERROR;
173: END IF;
174:
175: EVENT_SUBSEQUENT_LOAD(p_start_datel => p_start_date

Line 194: ams_utility_pvt.write_conc_log('The current end date cannot be less than the last end date ');

190:
191: IF l_max_end_date IS NOT NULL THEN
192:
193: IF (p_end_date <= l_max_end_date) THEN
194: ams_utility_pvt.write_conc_log('The current end date cannot be less than the last end date ');
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: IF l_max_end_date IS NOT NULL THEN
192:
193: IF (p_end_date <= l_max_end_date) THEN
194: ams_utility_pvt.write_conc_log('The current end date cannot be less than the last end date ');
195: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now ');
196: RAISE FND_API.g_exc_error;
197: END IF;
198:
199: EVENT_SUBSEQUENT_LOAD(p_start_datel => l_max_end_date + 1

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

212: RAISE FND_API.g_exc_unexpected_error;
213: END IF;
214: END IF;
215: ELSE
216: ams_utility_pvt.write_conc_log('----Period Validation----');
217: ams_utility_pvt.write_conc_log(l_period_error);
218: ams_utility_pvt.write_conc_log('----Currency Validation----');
219: ams_utility_pvt.write_conc_log(l_currency_error);
220: END IF;

Line 217: ams_utility_pvt.write_conc_log(l_period_error);

213: END IF;
214: END IF;
215: ELSE
216: ams_utility_pvt.write_conc_log('----Period Validation----');
217: ams_utility_pvt.write_conc_log(l_period_error);
218: ams_utility_pvt.write_conc_log('----Currency Validation----');
219: ams_utility_pvt.write_conc_log(l_currency_error);
220: END IF;
221:

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

214: END IF;
215: ELSE
216: ams_utility_pvt.write_conc_log('----Period Validation----');
217: ams_utility_pvt.write_conc_log(l_period_error);
218: ams_utility_pvt.write_conc_log('----Currency Validation----');
219: ams_utility_pvt.write_conc_log(l_currency_error);
220: END IF;
221:
222: --Standard check of commit

Line 219: ams_utility_pvt.write_conc_log(l_currency_error);

215: ELSE
216: ams_utility_pvt.write_conc_log('----Period Validation----');
217: ams_utility_pvt.write_conc_log(l_period_error);
218: ams_utility_pvt.write_conc_log('----Currency Validation----');
219: ams_utility_pvt.write_conc_log(l_currency_error);
220: END IF;
221:
222: --Standard check of commit
223: IF FND_API.To_Boolean ( p_commit ) THEN

Line 457: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

453: THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456: -- Debug Message
457: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
458:
459: -- Initialize API return status to SUCCESS
460: x_return_status := FND_API.G_RET_STS_SUCCESS;
461: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: Running the First Load '||sqlerrm(sqlcode));

Line 461: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: Running the First Load '||sqlerrm(sqlcode));

457: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
458:
459: -- Initialize API return status to SUCCESS
460: x_return_status := FND_API.G_RET_STS_SUCCESS;
461: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: Running the First Load '||sqlerrm(sqlcode));
462: l_profile := FND_PROFILE.VALUE('AMS Budget Adjustment Grace Period in Days')+0; --for grace period
463: if l_profile is null then
464: l_profile :=0;
465: end if;

Line 516: ams_utility_pvt.write_conc_log(p_start_datel || ' '|| p_end_datel);

512:
513: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 1000';
514:
515: /*This insert statement is getting transactions book of order, leads happen and event header level between p_start_date and p_end_date */
516: ams_utility_pvt.write_conc_log(p_start_datel || ' '|| p_end_datel);
517:
518: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
519: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE FIRST INSERT BEGIN.' || l_temp_msg);
520: INSERT /*+ append parallel(EDF,1) */ INTO

Line 519: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE FIRST INSERT BEGIN.' || l_temp_msg);

515: /*This insert statement is getting transactions book of order, leads happen and event header level between p_start_date and p_end_date */
516: ams_utility_pvt.write_conc_log(p_start_datel || ' '|| p_end_datel);
517:
518: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
519: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE FIRST INSERT BEGIN.' || l_temp_msg);
520: INSERT /*+ append parallel(EDF,1) */ INTO
521: bim_r_even_daily_facts EDF(
522: event_daily_transaction_id
523: ,creation_date

Line 833: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: AFTER FIRST INSERT.' || l_temp_msg);

829: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
830: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_even_daily_facts nologging';
831:
832: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
833: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: AFTER FIRST INSERT.' || l_temp_msg);
834:
835: EXCEPTION
836: WHEN OTHERS THEN
837: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';

Line 842: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR FIRST INSERT. '||sqlerrm(sqlcode));

838: x_return_status := FND_API.G_RET_STS_ERROR;
839: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
840: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
841: FND_MSG_PUB.Add;
842: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR FIRST INSERT. '||sqlerrm(sqlcode));
843: RAISE FND_API.G_EXC_ERROR;
844: end;
845:
846: begin

Line 852: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE SECOND INSERT BEGIN.' || l_temp_msg);

848: /*This insert statement is getting transactions book of order, leads happen and event offer level between
849: p_start_date and p_end_date parameter*/
850:
851: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
852: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE SECOND INSERT BEGIN.' || l_temp_msg);
853: INSERT /*+ append parallel(EDF,1) */ INTO
854: bim_r_even_daily_facts EDF(
855: event_daily_transaction_id
856: ,creation_date

Line 1161: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: AFTER SECOND INSERT.' || l_temp_msg);

1157: or g.opportunities >0
1158: or g.opportunity_amt >0) inner;
1159:
1160: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1161: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: AFTER SECOND INSERT.' || l_temp_msg);
1162:
1163: commit;
1164: --dbms_output.put_line('after insert row count:'||SQL%ROWCOUNT);
1165: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';

Line 1175: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR SECOND INSERT. '||sqlerrm(sqlcode));

1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1173: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1174: FND_MSG_PUB.Add;
1175: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR SECOND INSERT. '||sqlerrm(sqlcode));
1176: RAISE FND_API.G_EXC_ERROR;
1177: END;
1178:
1179: --dbms_output.put_line('before second insert row count:');

Line 1185: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE THIRD INSERT BEGIN.' || l_temp_msg);

1181: BEGIN
1182: /*This insert statement is getting transactions for budget on event header and offer level between
1183: p_start_date and p_end_date parameter*/
1184: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1185: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE THIRD INSERT BEGIN.' || l_temp_msg);
1186: INSERT INTO /*+ append parallel(EDF,1) */
1187: bim_r_even_daily_facts EDF(
1188: event_daily_transaction_id
1189: ,creation_date

Line 1462: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: AFTER THIRD INSERT.' || l_temp_msg);

1458: and ad.creation_date <= p_end_datel
1459: AND ad.creation_date is not null)INNER;
1460:
1461: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1462: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: AFTER THIRD INSERT.' || l_temp_msg);
1463:
1464: commit;
1465:
1466: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';

Line 1475: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR THIRD INSERT. '||sqlerrm(sqlcode));

1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1473: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1474: FND_MSG_PUB.Add;
1475: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR THIRD INSERT. '||sqlerrm(sqlcode));
1476: RAISE FND_API.G_EXC_ERROR;
1477: END;
1478:
1479:

Line 1486: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE SECOND INSERT.' || l_temp_msg);

1482: /* This piece of code picks up the leads,opportunities,budget amounts,attended,registered,cancelled
1483: for the one-off event offers */
1484:
1485: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1486: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE SECOND INSERT.' || l_temp_msg);
1487: --Insert into bim_r_even_daily_facts for one-off event offer level
1488:
1489: INSERT INTO
1490: bim_r_even_daily_facts ewf(

Line 1895: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE registration INSERT BEGIN.' || l_temp_msg);

1891: /* This insert statement is getting the registration,cancellations,attended that happened before the ONE-OFF event offer started */
1892:
1893: BEGIN
1894: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
1895: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE registration INSERT BEGIN.' || l_temp_msg);
1896:
1897: FOR y IN get_one_off_events(p_start_datel)
1898: LOOP
1899:

Line 1908: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: Exception for finding the min of creation date for cost and revenue. '||sqlerrm(sqlcode));

1904: WHERE event_offer_id = y.event_offer_id;
1905: EXCEPTION
1906: WHEN OTHERS THEN
1907: NULL;
1908: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: Exception for finding the min of creation date for cost and revenue. '||sqlerrm(sqlcode));
1909: RAISE FND_API.G_EXC_ERROR;
1910: END;
1911:
1912: IF l_min_date IS NOT NULL THEN

Line 2051: ams_utility_pvt.write_conc_log('Exception for registered no data found. '||sqlerrm(sqlcode));

2047:
2048: EXCEPTION
2049: WHEN NO_DATA_FOUND THEN
2050: NULL;
2051: ams_utility_pvt.write_conc_log('Exception for registered no data found. '||sqlerrm(sqlcode));
2052: RAISE FND_API.G_EXC_ERROR;
2053: END;
2054:
2055: END IF;

Line 2060: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: AFTER registration INSERT.' || l_temp_msg);

2056:
2057: END LOOP;
2058:
2059: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2060: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: AFTER registration INSERT.' || l_temp_msg);
2061: COMMIT;
2062: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
2063: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_even_daily_facts nologging';
2064: EXCEPTION

Line 2072: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION registration insert statement. '||sqlerrm(sqlcode));

2068: x_return_status := FND_API.G_RET_STS_ERROR;
2069: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2070: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2071: FND_MSG_PUB.Add;
2072: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION registration insert statement. '||sqlerrm(sqlcode));
2073: RAISE FND_API.G_EXC_ERROR;
2074: END;
2075:
2076:

Line 2083: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE registration INSERT BEGIN.' || l_temp_msg);

2079: /* This insert statement is getting the registration that happened before the event offer started */
2080:
2081: BEGIN
2082: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2083: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE registration INSERT BEGIN.' || l_temp_msg);
2084: FOR x IN get_event(p_start_datel)
2085: LOOP
2086:
2087: BEGIN

Line 2095: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: Exception for finding the min of creation date for cost and revenue. '||sqlerrm(sqlcode));

2091: WHERE event_offer_id = x.event_offer_id;
2092: EXCEPTION
2093: WHEN OTHERS THEN
2094: NULL;
2095: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: Exception for finding the min of creation date for cost and revenue. '||sqlerrm(sqlcode));
2096: RAISE FND_API.G_EXC_ERROR;
2097: END;
2098:
2099: IF l_min_date IS NOT NULL THEN

Line 2244: ams_utility_pvt.write_conc_log('Exception for registered no data found. '||sqlerrm(sqlcode));

2240:
2241: EXCEPTION
2242: WHEN NO_DATA_FOUND THEN
2243: NULL;
2244: ams_utility_pvt.write_conc_log('Exception for registered no data found. '||sqlerrm(sqlcode));
2245: RAISE FND_API.G_EXC_ERROR;
2246: END;
2247:
2248: END IF;

Line 2255: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: AFTER registration INSERT.' || l_temp_msg);

2251:
2252: END LOOP;
2253:
2254: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2255: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: AFTER registration INSERT.' || l_temp_msg);
2256: COMMIT;
2257: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
2258: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_even_daily_facts nologging';
2259: EXCEPTION

Line 2267: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION registration insert statement. '||sqlerrm(sqlcode));

2263: x_return_status := FND_API.G_RET_STS_ERROR;
2264: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2265: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2266: FND_MSG_PUB.Add;
2267: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION registration insert statement. '||sqlerrm(sqlcode));
2268: RAISE FND_API.G_EXC_ERROR;
2269: END;
2270:
2271: -- analyze the bim_r_event_daily_facts with dbms_stats

Line 2299: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEGIN UPDATE FOR COST AND REVENUE.' || l_temp_msg);

2295: GROUP BY event_header_id,event_offer_id;
2296:
2297: BEGIN
2298: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2299: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEGIN UPDATE FOR COST AND REVENUE.' || l_temp_msg);
2300:
2301: FOR x IN event_dates LOOP
2302:
2303: BEGIN

Line 2318: ams_utility_pvt.write_conc_log('FROM COST SELECT SQL ' || sqlerrm(sqlcode));

2314: EXCEPTION
2315: WHEN NO_DATA_FOUND THEN
2316: NULL;
2317: WHEN OTHERS THEN
2318: ams_utility_pvt.write_conc_log('FROM COST SELECT SQL ' || sqlerrm(sqlcode));
2319: RAISE FND_API.G_EXC_ERROR;
2320: END;
2321:
2322: BEGIN

Line 2338: ams_utility_pvt.write_conc_log('FROM REVENUE SELECT SQL ' || sqlerrm(sqlcode));

2334: EXCEPTION
2335: WHEN NO_DATA_FOUND THEN
2336: NULL;
2337: WHEN OTHERS THEN
2338: ams_utility_pvt.write_conc_log('FROM REVENUE SELECT SQL ' || sqlerrm(sqlcode));
2339: RAISE FND_API.G_EXC_ERROR;
2340: END;
2341:
2342: BEGIN

Line 2356: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR UPDATE FOR COST AND REVENUE' || sqlerrm(sqlcode));

2352: EXCEPTION
2353: WHEN NO_DATA_FOUND THEN
2354: NULL;
2355: WHEN OTHERS THEN
2356: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR UPDATE FOR COST AND REVENUE' || sqlerrm(sqlcode));
2357: RAISE FND_API.G_EXC_ERROR;
2358: END;
2359: END LOOP;
2360: END;

Line 2397: ams_utility_pvt.write_conc_log('FROM COST SELECT SQL ' || sqlerrm(sqlcode));

2393: EXCEPTION
2394: WHEN NO_DATA_FOUND THEN
2395: NULL;
2396: WHEN OTHERS THEN
2397: ams_utility_pvt.write_conc_log('FROM COST SELECT SQL ' || sqlerrm(sqlcode));
2398: RAISE FND_API.G_EXC_ERROR;
2399: END;
2400:
2401: BEGIN

Line 2416: ams_utility_pvt.write_conc_log('FROM REVENUE SELECT SQL ' || sqlerrm(sqlcode));

2412: EXCEPTION
2413: WHEN NO_DATA_FOUND THEN
2414: NULL;
2415: WHEN OTHERS THEN
2416: ams_utility_pvt.write_conc_log('FROM REVENUE SELECT SQL ' || sqlerrm(sqlcode));
2417: RAISE FND_API.G_EXC_ERROR;
2418: END;
2419:
2420:

Line 2434: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR UPDATE FOR COST AND REVENUE' || sqlerrm(sqlcode));

2430: EXCEPTION
2431: WHEN NO_DATA_FOUND THEN
2432: NULL;
2433: WHEN OTHERS THEN
2434: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR UPDATE FOR COST AND REVENUE' || sqlerrm(sqlcode));
2435: RAISE FND_API.G_EXC_ERROR;
2436: END;
2437:
2438: END LOOP;

Line 2448: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: END UPDATE FOR COST AND REVENUE.' || l_temp_msg);

2444:
2445:
2446:
2447: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2448: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: END UPDATE FOR COST AND REVENUE.' || l_temp_msg);
2449: commit;
2450:
2451: --insert into bim_r_even_weekly_facts table
2452: BEGIN

Line 2458: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE INSERT INTO WEEKLY FACTS TABLE.' || l_temp_msg);

2454:
2455: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_weekly_facts_s CACHE 1000';
2456:
2457: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2458: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: BEFORE INSERT INTO WEEKLY FACTS TABLE.' || l_temp_msg);
2459:
2460: INSERT /*+ append */ INTO
2461: bim_r_even_weekly_facts ewf(
2462: event_weekly_transaction_id

Line 2633: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: AFTER INSERT INTO WEEKLY FACTS.' || l_temp_msg);

2629: ,year
2630: ,booked_orders
2631: ,booked_orders_amt) inner;
2632: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2633: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: AFTER INSERT INTO WEEKLY FACTS.' || l_temp_msg);
2634: COMMIT;
2635:
2636: /* If there are some data insert into bim_r_even_daily_facts and bim_r_even_weekly_facts, then insert a record into bim_rep_history*/
2637:

Line 2654: ams_utility_pvt.write_conc_log('End of Events Facts Program -- First Load');

2650:
2651: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
2652: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_even_daily_facts nologging';
2653:
2654: ams_utility_pvt.write_conc_log('End of Events Facts Program -- First Load');
2655:
2656: EXCEPTION
2657: WHEN NO_DATA_FOUND THEN
2658: null;

Line 2659: ams_utility_pvt.write_conc_log('When no data found in weekly insert in first load. '||sqlerrm(sqlcode));

2655:
2656: EXCEPTION
2657: WHEN NO_DATA_FOUND THEN
2658: null;
2659: ams_utility_pvt.write_conc_log('When no data found in weekly insert in first load. '||sqlerrm(sqlcode));
2660:
2661: RAISE FND_API.G_EXC_ERROR;
2662: WHEN OTHERS THEN
2663:

Line 2670: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR INSERT INTO WEEKLY FACTS. '||sqlerrm(sqlcode));

2666: x_return_status := FND_API.G_RET_STS_ERROR;
2667: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2668: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2669: FND_MSG_PUB.Add;
2670: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR INSERT INTO WEEKLY FACTS. '||sqlerrm(sqlcode));
2671: RAISE FND_API.G_EXC_ERROR;
2672: END;
2673:
2674: -- analyze the BIM_R_EVEN_WEEKLY_FACTS with dbms_stats

Line 2712: ams_utility_pvt.write_conc_log('Exception for creating index for first load. '||sqlerrm(sqlcode));

2708: END LOOP;
2709: EXCEPTION
2710: WHEN OTHERS THEN
2711: -- DBMS_OUTPUT.PUT_LINE(sqlerrm(sqlcode));
2712: ams_utility_pvt.write_conc_log('Exception for creating index for first load. '||sqlerrm(sqlcode));
2713: RAISE FND_API.G_EXC_ERROR;
2714: NULL;
2715: END;
2716:

Line 2727: ams_utility_pvt.write_conc_log('EXPECTED EXCEPTION '||sqlerrm(sqlcode));

2723: p_count => x_msg_count,
2724: p_data => x_msg_data
2725: );
2726:
2727: ams_utility_pvt.write_conc_log('EXPECTED EXCEPTION '||sqlerrm(sqlcode));
2728: RAISE FND_API.G_EXC_ERROR;
2729:
2730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2731:

Line 2741: ams_utility_pvt.write_conc_log('UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));

2737: p_count => x_msg_count,
2738: p_data => x_msg_data
2739: );
2740:
2741: ams_utility_pvt.write_conc_log('UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
2742: RAISE FND_API.G_EXC_ERROR;
2743:
2744: WHEN OTHERS THEN
2745:

Line 2760: ams_utility_pvt.write_conc_log('OTHERS EXCEPTION '||sqlerrm(sqlcode));

2756: p_count => x_msg_count,
2757: p_data => x_msg_data
2758: );
2759:
2760: ams_utility_pvt.write_conc_log('OTHERS EXCEPTION '||sqlerrm(sqlcode));
2761: ams_utility_pvt.write_conc_log('Before end of event_first_load for first load. ');
2762: RAISE FND_API.G_EXC_ERROR;
2763: END EVENT_FIRST_LOAD;
2764:

Line 2761: ams_utility_pvt.write_conc_log('Before end of event_first_load for first load. ');

2757: p_data => x_msg_data
2758: );
2759:
2760: ams_utility_pvt.write_conc_log('OTHERS EXCEPTION '||sqlerrm(sqlcode));
2761: ams_utility_pvt.write_conc_log('Before end of event_first_load for first load. ');
2762: RAISE FND_API.G_EXC_ERROR;
2763: END EVENT_FIRST_LOAD;
2764:
2765:

Line 2812: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

2808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2809: END IF;
2810:
2811: -- Debug Message
2812: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2813:
2814: BEGIN
2815: l_table_name :='bim_r_even_daily_facts';
2816:

Line 2826: ams_utility_pvt.write_conc_log('EVENT:LOAD: BEFORE FIRST INSERT.' || l_temp_msg);

2822: CLOSE MIN_START_DATE;
2823: END IF;
2824:
2825: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
2826: ams_utility_pvt.write_conc_log('EVENT:LOAD: BEFORE FIRST INSERT.' || l_temp_msg);
2827: --Insert into bim_r_even_daily_facts on event offer level
2828: INSERT INTO
2829: bim_r_even_daily_facts ewf(
2830: event_daily_transaction_id

Line 3290: ams_utility_pvt.write_conc_log('EVENT:LOAD: AFTER FIRST INSERT.' || l_temp_msg);

3286: and ad.event_offer_id = a.event_offer_id
3287: --and ad.creation_date is not null
3288: ;
3289: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
3290: ams_utility_pvt.write_conc_log('EVENT:LOAD: AFTER FIRST INSERT.' || l_temp_msg);
3291: commit;
3292:
3293: ---------------------------------------------------------------------------------
3294: /* This piece of code picks up the leads,opportunities,budget amounts,attended,registered,cancelled

Line 3298: ams_utility_pvt.write_conc_log('EVENT:LOAD: BEFORE SECOND INSERT.' || l_temp_msg);

3294: /* This piece of code picks up the leads,opportunities,budget amounts,attended,registered,cancelled
3295: for the one-off event offers */
3296:
3297: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
3298: ams_utility_pvt.write_conc_log('EVENT:LOAD: BEFORE SECOND INSERT.' || l_temp_msg);
3299: --Insert into bim_r_even_daily_facts for one-off event offer level
3300:
3301: INSERT INTO
3302: bim_r_even_daily_facts ewf(

Line 3789: ams_utility_pvt.write_conc_log('EVENT:LOAD: EXCEPTION FOR FIRST INSERT. '||sqlerrm(sqlcode));

3785: x_return_status := FND_API.G_RET_STS_ERROR;
3786: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
3787: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3788: FND_MSG_PUB.Add;
3789: ams_utility_pvt.write_conc_log('EVENT:LOAD: EXCEPTION FOR FIRST INSERT. '||sqlerrm(sqlcode));
3790: RAISE FND_API.G_EXC_ERROR;
3791: END;
3792:
3793:

Line 3804: ams_utility_pvt.write_conc_log('EVENT:LOAD: BEFORE SECOND INSERT.' || l_temp_msg);

3800:
3801: --insert into bim_r_even_daily_facts on event header level
3802:
3803: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
3804: ams_utility_pvt.write_conc_log('EVENT:LOAD: BEFORE SECOND INSERT.' || l_temp_msg);
3805:
3806: INSERT INTO
3807: bim_r_even_daily_facts ewf(
3808: event_daily_transaction_id

Line 4250: ams_utility_pvt.write_conc_log('EVENT:LOAD: AFTER SECOND INSERT.' || l_temp_msg);

4246: and ad.event_header_id = a.event_header_id
4247: --AND ad.creation_date IS NOT NULL
4248: ;
4249: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4250: ams_utility_pvt.write_conc_log('EVENT:LOAD: AFTER SECOND INSERT.' || l_temp_msg);
4251: commit;
4252:
4253: EXCEPTION
4254: WHEN OTHERS THEN

Line 4262: ams_utility_pvt.write_conc_log('EVENT:LOAD: EXCEPTION FOR SECOND INSERT. '||sqlerrm(sqlcode));

4258: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
4259: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
4260: FND_MSG_PUB.Add;
4261:
4262: ams_utility_pvt.write_conc_log('EVENT:LOAD: EXCEPTION FOR SECOND INSERT. '||sqlerrm(sqlcode));
4263: RAISE FND_API.G_EXC_ERROR;
4264: END;
4265:
4266: -- analyze the BIM_R_EVEN_daily_facts with dbms_stats

Line 4280: ams_utility_pvt.write_conc_log('EVENT:LOAD: BEFORE INSERT INTO WEEKLY FACTS TABLE.' || l_temp_msg);

4276: /* insert into bim_r_even_weekly_facts */
4277: l_table_name :='bim_r_even_weekly_facts';
4278:
4279: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4280: ams_utility_pvt.write_conc_log('EVENT:LOAD: BEFORE INSERT INTO WEEKLY FACTS TABLE.' || l_temp_msg);
4281:
4282: INSERT /*+ append */ INTO
4283: bim_r_even_weekly_facts ewf(
4284: event_weekly_transaction_id

Line 4456: ams_utility_pvt.write_conc_log('EVENT:LOAD: AFTER INSERT INTO WEEKLY TABLE.' || l_temp_msg);

4452: ,year
4453: ,booked_orders
4454: ,booked_orders_amt) inner;
4455: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
4456: ams_utility_pvt.write_conc_log('EVENT:LOAD: AFTER INSERT INTO WEEKLY TABLE.' || l_temp_msg);
4457: commit;
4458:
4459: --IF SQL%ROWCOUNT >0 THEN
4460: LOG_HISTORY(

Line 4471: ams_utility_pvt.write_conc_log('End of Events Facts Program -- Subsequent Load');

4467:
4468: );
4469: --END IF;
4470:
4471: ams_utility_pvt.write_conc_log('End of Events Facts Program -- Subsequent Load');
4472:
4473: EXCEPTION
4474: WHEN OTHERS THEN
4475: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4479: ams_utility_pvt.write_conc_log('EVENT:LOAD: EXCEPTION FOR INSERT INTO WEEKLY TABLE. '||sqlerrm(sqlcode));

4475: x_return_status := FND_API.G_RET_STS_ERROR;
4476: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
4477: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
4478: FND_MSG_PUB.Add;
4479: ams_utility_pvt.write_conc_log('EVENT:LOAD: EXCEPTION FOR INSERT INTO WEEKLY TABLE. '||sqlerrm(sqlcode));
4480: RAISE FND_API.G_EXC_ERROR;
4481: END ;
4482: --END IF;
4483: EXCEPTION

Line 4494: ams_utility_pvt.write_conc_log('EVENT:LOAD:EXPECTED EXCEPTION '||sqlerrm(sqlcode));

4490: p_count => x_msg_count,
4491: p_data => x_msg_data
4492: );
4493:
4494: ams_utility_pvt.write_conc_log('EVENT:LOAD:EXPECTED EXCEPTION '||sqlerrm(sqlcode));
4495: RAISE FND_API.G_EXC_ERROR;
4496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4497:
4498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4507: ams_utility_pvt.write_conc_log('EVENT:LOAD: UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));

4503: p_count => x_msg_count,
4504: p_data => x_msg_data
4505: );
4506:
4507: ams_utility_pvt.write_conc_log('EVENT:LOAD: UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
4508: RAISE FND_API.G_EXC_ERROR;
4509: WHEN OTHERS THEN
4510:
4511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4525: ams_utility_pvt.write_conc_log('EVENT:LOAD: OTHERS EXCEPTION '||sqlerrm(sqlcode));

4521: p_count => x_msg_count,
4522: p_data => x_msg_data
4523: );
4524:
4525: ams_utility_pvt.write_conc_log('EVENT:LOAD: OTHERS EXCEPTION '||sqlerrm(sqlcode));
4526: END EVENT_SUBSEQUENT_LOAD;
4527: END BIM_EVENT_FACTS;