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_REFRESH_SALES_PVT dependencies on OZF_UTILITY_PVT

Line 87: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;

83: l_prof_check VARCHAR2(1) := 'T';
84:
85: BEGIN
86:
87: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
88:
89: SAVEPOINT full_load;
90:
91: x_return_status := FND_API.g_ret_sts_success;

Line 95: ozf_utility_pvt.write_conc_log('-- l_global_start_date is : ' || l_global_start_date ) ;

91: x_return_status := FND_API.g_ret_sts_success;
92:
93: -- Check for Profile Values
94:
95: ozf_utility_pvt.write_conc_log('-- l_global_start_date is : ' || l_global_start_date ) ;
96: ozf_utility_pvt.write_conc_log('-- l_common_uom is : ' || l_common_uom ) ;
97: ozf_utility_pvt.write_conc_log('-- l_common_currency_code is : ' || l_common_currency_code ) ;
98: ozf_utility_pvt.write_conc_log('-- l_curr_conv_type is : ' || l_curr_conv_type ) ;
99:

Line 96: ozf_utility_pvt.write_conc_log('-- l_common_uom is : ' || l_common_uom ) ;

92:
93: -- Check for Profile Values
94:
95: ozf_utility_pvt.write_conc_log('-- l_global_start_date is : ' || l_global_start_date ) ;
96: ozf_utility_pvt.write_conc_log('-- l_common_uom is : ' || l_common_uom ) ;
97: ozf_utility_pvt.write_conc_log('-- l_common_currency_code is : ' || l_common_currency_code ) ;
98: ozf_utility_pvt.write_conc_log('-- l_curr_conv_type is : ' || l_curr_conv_type ) ;
99:
100: IF l_global_start_date IS NULL

Line 97: ozf_utility_pvt.write_conc_log('-- l_common_currency_code is : ' || l_common_currency_code ) ;

93: -- Check for Profile Values
94:
95: ozf_utility_pvt.write_conc_log('-- l_global_start_date is : ' || l_global_start_date ) ;
96: ozf_utility_pvt.write_conc_log('-- l_common_uom is : ' || l_common_uom ) ;
97: ozf_utility_pvt.write_conc_log('-- l_common_currency_code is : ' || l_common_currency_code ) ;
98: ozf_utility_pvt.write_conc_log('-- l_curr_conv_type is : ' || l_curr_conv_type ) ;
99:
100: IF l_global_start_date IS NULL
101: THEN

Line 98: ozf_utility_pvt.write_conc_log('-- l_curr_conv_type is : ' || l_curr_conv_type ) ;

94:
95: ozf_utility_pvt.write_conc_log('-- l_global_start_date is : ' || l_global_start_date ) ;
96: ozf_utility_pvt.write_conc_log('-- l_common_uom is : ' || l_common_uom ) ;
97: ozf_utility_pvt.write_conc_log('-- l_common_currency_code is : ' || l_common_currency_code ) ;
98: ozf_utility_pvt.write_conc_log('-- l_curr_conv_type is : ' || l_curr_conv_type ) ;
99:
100: IF l_global_start_date IS NULL
101: THEN
102: l_prof_check := 'N';

Line 113: ozf_utility_pvt.write_conc_log(l_mesg);

109: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_MISSING_PROFILE_VALUE');
110: FND_MESSAGE.Set_Token('PROFILE_NAME', l_user_profile_option_name);
111: l_mesg := FND_MESSAGE.get;
112:
113: ozf_utility_pvt.write_conc_log(l_mesg);
114: END IF;
115:
116:
117: IF l_common_uom IS NULL

Line 130: ozf_utility_pvt.write_conc_log(l_mesg);

126: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_MISSING_PROFILE_VALUE');
127: FND_MESSAGE.Set_Token('PROFILE_NAME', l_user_profile_option_name);
128: l_mesg := FND_MESSAGE.get;
129:
130: ozf_utility_pvt.write_conc_log(l_mesg);
131: END IF;
132:
133: IF l_common_currency_code IS NULL
134: THEN

Line 146: ozf_utility_pvt.write_conc_log(l_mesg);

142: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_MISSING_PROFILE_VALUE');
143: FND_MESSAGE.Set_Token('PROFILE_NAME', l_user_profile_option_name);
144: l_mesg := FND_MESSAGE.Get;
145:
146: ozf_utility_pvt.write_conc_log(l_mesg);
147: END IF;
148:
149: IF l_curr_conv_type IS NULL
150: THEN

Line 162: ozf_utility_pvt.write_conc_log(l_mesg);

158: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_MISSING_PROFILE_VALUE');
159: FND_MESSAGE.Set_Token('PROFILE_NAME', l_user_profile_option_name);
160: l_mesg := FND_MESSAGE.Get;
161:
162: ozf_utility_pvt.write_conc_log(l_mesg);
163: END IF;
164:
165: IF l_prof_check = 'N'
166: THEN

Line 172: ozf_utility_pvt.write_conc_log(' -- Updating errors from previous run., if any ');

168: END IF;
169:
170: -- Process any error from the previous run
171:
172: ozf_utility_pvt.write_conc_log(' -- Updating errors from previous run., if any ');
173:
174: UPDATE ozf_sales_transactions_all
175: SET common_amount = gl_currency_api.convert_amount_sql(currency_code,
176: common_currency_code,

Line 208: ozf_utility_pvt.write_conc_log(' -- Inserting New transaction ');

204: WHERE source_code = 'OM'
205: AND error_flag = 'Y';
206:
207:
208: ozf_utility_pvt.write_conc_log(' -- Inserting New transaction ');
209:
210: -- Insert
211: INSERT INTO ozf_sales_transactions_all(
212: SALES_TRANSACTION_ID ,

Line 354: ozf_utility_pvt.write_conc_log(' -- Currency and UOM conversion Errors -- ');

350: Get all records from ozf_sales_transactions_all with error_flag = 'Y'
351: converted_quantity = -9999 or converted_amount = -1
352: */
353:
354: ozf_utility_pvt.write_conc_log(' -- Currency and UOM conversion Errors -- ');
355:
356: FOR err IN error_csr
357: LOOP
358: IF err.common_quantity < 0

Line 368: ozf_utility_pvt.write_conc_log(l_mesg);

364: FND_MESSAGE.Set_Token('TO_VALUE', err.common_uom_code);
365: FND_MESSAGE.Set_Token('DATE', err.transaction_date);
366: l_mesg := FND_MESSAGE.Get;
367:
368: ozf_utility_pvt.write_conc_log(l_mesg);
369:
370: END IF;
371:
372: IF err.common_amount < 0

Line 382: ozf_utility_pvt.write_conc_log(l_mesg);

378: FND_MESSAGE.Set_Token('TO_VALUE', err.common_currency_code);
379: FND_MESSAGE.Set_Token('DATE', err.transaction_date);
380: l_mesg := FND_MESSAGE.Get;
381:
382: ozf_utility_pvt.write_conc_log(l_mesg);
383:
384: END IF;
385:
386: END LOOP;

Line 390: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');

386: END LOOP;
387:
388: --
389: -- End full load logic
390: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
391:
392: EXCEPTION
393: WHEN FND_API.G_EXC_ERROR THEN
394: x_return_status := FND_API.g_ret_sts_error ;

Line 398: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' Unexpected Error ' );

394: x_return_status := FND_API.g_ret_sts_error ;
395:
396: WHEN OTHERS THEN
397: x_return_status := FND_API.g_ret_sts_unexp_error ;
398: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' Unexpected Error ' );
399: ozf_utility_pvt.write_conc_log(sqlerrm(sqlcode) );
400:
401: END full_load;
402:

Line 399: ozf_utility_pvt.write_conc_log(sqlerrm(sqlcode) );

395:
396: WHEN OTHERS THEN
397: x_return_status := FND_API.g_ret_sts_unexp_error ;
398: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' Unexpected Error ' );
399: ozf_utility_pvt.write_conc_log(sqlerrm(sqlcode) );
400:
401: END full_load;
402:
403:

Line 411: ozf_utility_pvt.write_conc_log(' -- Begin Materialized view refresh -- ');

407: ,RETCODE OUT NOCOPY NUMBER)
408: IS
409: BEGIN
410:
411: ozf_utility_pvt.write_conc_log(' -- Begin Materialized view refresh -- ');
412:
413: DBMS_MVIEW.REFRESH(
414: list => 'ORDER' ,
415: method => '?'

Line 418: ozf_utility_pvt.write_conc_log(' -- End Materialized view refresh -- ');

414: list => 'ORDER' ,
415: method => '?'
416: );
417:
418: ozf_utility_pvt.write_conc_log(' -- End Materialized view refresh -- ');
419: --------------------------------------------------------
420: -- Gather statistics for the use of cost-based optimizer
421: --------------------------------------------------------
422:

Line 423: ozf_utility_pvt.write_conc_log(' -- Begin FND_STATS API to gather table statstics -- ');

419: --------------------------------------------------------
420: -- Gather statistics for the use of cost-based optimizer
421: --------------------------------------------------------
422:
423: ozf_utility_pvt.write_conc_log(' -- Begin FND_STATS API to gather table statstics -- ');
424:
425: fnd_stats.gather_table_stats (ownname=>'APPS', tabname=>'OZF_ORDER_SALES_SUMRY_MV');
426:
427: ozf_utility_pvt.write_conc_log(' -- End FND_STATS API to gather table statstics -- ');

Line 427: ozf_utility_pvt.write_conc_log(' -- End FND_STATS API to gather table statstics -- ');

423: ozf_utility_pvt.write_conc_log(' -- Begin FND_STATS API to gather table statstics -- ');
424:
425: fnd_stats.gather_table_stats (ownname=>'APPS', tabname=>'OZF_ORDER_SALES_SUMRY_MV');
426:
427: ozf_utility_pvt.write_conc_log(' -- End FND_STATS API to gather table statstics -- ');
428:
429: EXCEPTION
430:
431: WHEN FND_API.G_EXC_ERROR THEN

Line 437: ozf_utility_pvt.write_conc_log(Retcode||':'||Errbuf);

433:
434: WHEN OTHERS THEN
435: Errbuf:= sqlerrm;
436: Retcode:=sqlcode;
437: ozf_utility_pvt.write_conc_log(Retcode||':'||Errbuf);
438:
439: END order_sales_sumry_mv_refresh;
440: */
441:

Line 458: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' (-)');

454: x_return_status VARCHAR2(1) ;
455: l_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;
456:
457: BEGIN
458: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' (-)');
459:
460: -- Initialize API return status to SUCCESS
461: x_return_status := FND_API.G_RET_STS_SUCCESS;
462:

Line 480: ozf_utility_pvt.write_conc_log(' -- Commiting Transactions before MV Refresh ');

476: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
477: RAISE FND_API.g_exc_unexpected_error;
478: END IF;
479:
480: ozf_utility_pvt.write_conc_log(' -- Commiting Transactions before MV Refresh ');
481:
482: COMMIT;
483:
484: ozf_utility_pvt.write_conc_log(' -- Committed !! ');

Line 484: ozf_utility_pvt.write_conc_log(' -- Committed !! ');

480: ozf_utility_pvt.write_conc_log(' -- Commiting Transactions before MV Refresh ');
481:
482: COMMIT;
483:
484: ozf_utility_pvt.write_conc_log(' -- Committed !! ');
485: --
486: -- Refresh the MVS here
487: --
488:

Line 489: ozf_utility_pvt.write_conc_log(' -- Begin MV Refresh -- ');

485: --
486: -- Refresh the MVS here
487: --
488:
489: ozf_utility_pvt.write_conc_log(' -- Begin MV Refresh -- ');
490:
491: ozf_refresh_view_pvt.load(ERRBUF, RETCODE, 'ORDER');
492: ozf_refresh_view_pvt.load(ERRBUF, RETCODE, 'INVENTORY');
493:

Line 494: ozf_utility_pvt.write_conc_log(' -- End MV Refresh -- ');

490:
491: ozf_refresh_view_pvt.load(ERRBUF, RETCODE, 'ORDER');
492: ozf_refresh_view_pvt.load(ERRBUF, RETCODE, 'INVENTORY');
493:
494: ozf_utility_pvt.write_conc_log(' -- End MV Refresh -- ');
495:
496: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' (+)');
497:
498: EXCEPTION

Line 496: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' (+)');

492: ozf_refresh_view_pvt.load(ERRBUF, RETCODE, 'INVENTORY');
493:
494: ozf_utility_pvt.write_conc_log(' -- End MV Refresh -- ');
495:
496: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' (+)');
497:
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: x_return_status := FND_API.g_ret_sts_error ;

Line 503: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Expected Error');

499: WHEN FND_API.G_EXC_ERROR THEN
500: x_return_status := FND_API.g_ret_sts_error ;
501: ERRBUF := x_msg_data;
502: RETCODE := 2;
503: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Expected Error');
504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: x_return_status := FND_API.g_ret_sts_unexp_error ;
507: ERRBUF := sqlerrm(sqlcode);

Line 509: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Unexpected Error');

505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: x_return_status := FND_API.g_ret_sts_unexp_error ;
507: ERRBUF := sqlerrm(sqlcode);
508: RETCODE := 2;
509: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Unexpected Error');
510:
511: WHEN OTHERS THEN
512: x_return_status := FND_API.g_ret_sts_unexp_error ;
513: ERRBUF := sqlerrm(sqlcode);

Line 515: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Others');

511: WHEN OTHERS THEN
512: x_return_status := FND_API.g_ret_sts_unexp_error ;
513: ERRBUF := sqlerrm(sqlcode);
514: RETCODE := 2;
515: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Others');
516:
517: END load;
518:
519: