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.OZF_ACTIVITY_DENORM_PVT dependencies on OZF_UTILITY_PVT

Line 149: ozf_utility_pvt.write_conc_log('-- Last Refresh Date is : ' || l_latest_comp_date );

145: OPEN c_get_latest_comp_date(l_conc_program_id, l_app_id);
146: FETCH c_get_latest_comp_date INTO l_latest_comp_date;
147: CLOSE c_get_latest_comp_date;
148:
149: ozf_utility_pvt.write_conc_log('-- Last Refresh Date is : ' || l_latest_comp_date );
150: ozf_utility_pvt.write_conc_log('-- Increment Flag is : ' || p_increment_flag );
151: ozf_utility_pvt.write_conc_log('-- Start refresh offers --');
152:
153: l_return := fnd_installation.get_app_info('OZF', l_status, l_industry, l_schema);

Line 150: ozf_utility_pvt.write_conc_log('-- Increment Flag is : ' || p_increment_flag );

146: FETCH c_get_latest_comp_date INTO l_latest_comp_date;
147: CLOSE c_get_latest_comp_date;
148:
149: ozf_utility_pvt.write_conc_log('-- Last Refresh Date is : ' || l_latest_comp_date );
150: ozf_utility_pvt.write_conc_log('-- Increment Flag is : ' || p_increment_flag );
151: ozf_utility_pvt.write_conc_log('-- Start refresh offers --');
152:
153: l_return := fnd_installation.get_app_info('OZF', l_status, l_industry, l_schema);
154:

Line 151: ozf_utility_pvt.write_conc_log('-- Start refresh offers --');

147: CLOSE c_get_latest_comp_date;
148:
149: ozf_utility_pvt.write_conc_log('-- Last Refresh Date is : ' || l_latest_comp_date );
150: ozf_utility_pvt.write_conc_log('-- Increment Flag is : ' || p_increment_flag );
151: ozf_utility_pvt.write_conc_log('-- Start refresh offers --');
152:
153: l_return := fnd_installation.get_app_info('OZF', l_status, l_industry, l_schema);
154:
155: ozf_utility_pvt.write_conc_log('-- After getting schema name --');

Line 155: ozf_utility_pvt.write_conc_log('-- After getting schema name --');

151: ozf_utility_pvt.write_conc_log('-- Start refresh offers --');
152:
153: l_return := fnd_installation.get_app_info('OZF', l_status, l_industry, l_schema);
154:
155: ozf_utility_pvt.write_conc_log('-- After getting schema name --');
156: ozf_utility_pvt.write_conc_log('-- After getting schema name --' || l_schema );
157:
158: if p_increment_flag = 'N' then
159: EXECUTE IMMEDIATE 'ALTER table '||l_schema||'.ozf_activity_products_temp NOLOGGING';

Line 156: ozf_utility_pvt.write_conc_log('-- After getting schema name --' || l_schema );

152:
153: l_return := fnd_installation.get_app_info('OZF', l_status, l_industry, l_schema);
154:
155: ozf_utility_pvt.write_conc_log('-- After getting schema name --');
156: ozf_utility_pvt.write_conc_log('-- After getting schema name --' || l_schema );
157:
158: if p_increment_flag = 'N' then
159: EXECUTE IMMEDIATE 'ALTER table '||l_schema||'.ozf_activity_products_temp NOLOGGING';
160: EXECUTE IMMEDIATE 'ALTER table '||l_schema||'.ozf_activity_customers_temp NOLOGGING';

Line 163: ozf_utility_pvt.write_conc_log('-- After altering --');

159: EXECUTE IMMEDIATE 'ALTER table '||l_schema||'.ozf_activity_products_temp NOLOGGING';
160: EXECUTE IMMEDIATE 'ALTER table '||l_schema||'.ozf_activity_customers_temp NOLOGGING';
161: end if;
162:
163: ozf_utility_pvt.write_conc_log('-- After altering --');
164:
165: if p_increment_flag = 'N' then
166: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.ozf_activity_products_temp';
167: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.ozf_activity_customers_temp';

Line 170: ozf_utility_pvt.write_conc_log('-- After truncating --');

166: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.ozf_activity_products_temp';
167: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.ozf_activity_customers_temp';
168: end if;
169:
170: ozf_utility_pvt.write_conc_log('-- After truncating --');
171:
172: OZF_OFFR_ELIG_PROD_DENORM_PVT.refresh_offers(
173: ERRBUF,
174: RETCODE,

Line 188: ozf_utility_pvt.write_conc_log('-- End refresh Offers --');

184: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
185: RAISE FND_API.g_exc_unexpected_error;
186: END IF;
187:
188: ozf_utility_pvt.write_conc_log('-- End refresh Offers --');
189: IF p_offer_id IS NULL THEN
190: ozf_utility_pvt.write_conc_log('-- Start refresh schedules --');
191: OZF_SCHEDULE_DENORM_PVT.refresh_schedules(
192: ERRBUF,

Line 190: ozf_utility_pvt.write_conc_log('-- Start refresh schedules --');

186: END IF;
187:
188: ozf_utility_pvt.write_conc_log('-- End refresh Offers --');
189: IF p_offer_id IS NULL THEN
190: ozf_utility_pvt.write_conc_log('-- Start refresh schedules --');
191: OZF_SCHEDULE_DENORM_PVT.refresh_schedules(
192: ERRBUF,
193: RETCODE,
194: x_return_status,

Line 198: ozf_utility_pvt.write_conc_log('-- End refresh schedules --');

194: x_return_status,
195: p_increment_flag,
196: NVL(l_latest_comp_date, TO_DATE('01/01/1952','MM/DD/YYYY'))
197: );
198: ozf_utility_pvt.write_conc_log('-- End refresh schedules --');
199:
200:
201: IF x_return_status = FND_API.g_ret_sts_error
202: THEN

Line 212: ozf_utility_pvt.write_conc_log('-- Unexpected Error: --'||ERRBUF);

208:
209:
210: EXCEPTION
211: WHEN FND_API.g_exc_unexpected_error THEN
212: ozf_utility_pvt.write_conc_log('-- Unexpected Error: --'||ERRBUF);
213:
214: WHEN OTHERS THEN
215: ozf_utility_pvt.write_conc_log('-- Error: --'||ERRBUF);
216:

Line 215: ozf_utility_pvt.write_conc_log('-- Error: --'||ERRBUF);

211: WHEN FND_API.g_exc_unexpected_error THEN
212: ozf_utility_pvt.write_conc_log('-- Unexpected Error: --'||ERRBUF);
213:
214: WHEN OTHERS THEN
215: ozf_utility_pvt.write_conc_log('-- Error: --'||ERRBUF);
216:
217: END;
218:
219: END OZF_ACTIVITY_DENORM_PVT;