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 FND_API

Line 91: x_return_status := FND_API.g_ret_sts_success;

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;
92:
93: -- Check for Profile Values
94:
95: ozf_utility_pvt.write_conc_log('-- l_global_start_date is : ' || l_global_start_date ) ;

Line 167: RAISE FND_API.g_exc_error;

163: END IF;
164:
165: IF l_prof_check = 'N'
166: THEN
167: RAISE FND_API.g_exc_error;
168: END IF;
169:
170: -- Process any error from the previous run
171:

Line 393: WHEN FND_API.G_EXC_ERROR THEN

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 ;
395:
396: WHEN OTHERS THEN
397: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 394: x_return_status := FND_API.g_ret_sts_error ;

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 ;
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 ' );

Line 397: x_return_status := FND_API.g_ret_sts_unexp_error ;

393: WHEN FND_API.G_EXC_ERROR THEN
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;

Line 431: WHEN FND_API.G_EXC_ERROR THEN

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
432: Retcode := -2;
433:
434: WHEN OTHERS THEN
435: Errbuf:= sqlerrm;

Line 455: l_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;

451: l_api_name CONSTANT VARCHAR2(30) := 'ozf_refresh_order_sales_pkg';
452: x_msg_count NUMBER;
453: x_msg_data VARCHAR2(240);
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:

Line 461: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
463: IF (NVL(p_increment_mode,'N') = 'N')
464: THEN
465: DELETE FROM ozf_sales_transactions_all

Line 473: IF x_return_status = FND_API.g_ret_sts_error

469: COMMIT;
470:
471: full_load( x_return_status );
472:
473: IF x_return_status = FND_API.g_ret_sts_error
474: THEN
475: RAISE FND_API.g_exc_error;
476: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
477: RAISE FND_API.g_exc_unexpected_error;

Line 475: RAISE FND_API.g_exc_error;

471: full_load( x_return_status );
472:
473: IF x_return_status = FND_API.g_ret_sts_error
474: THEN
475: RAISE FND_API.g_exc_error;
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:

Line 476: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

472:
473: IF x_return_status = FND_API.g_ret_sts_error
474: THEN
475: RAISE FND_API.g_exc_error;
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 ');

Line 477: RAISE FND_API.g_exc_unexpected_error;

473: IF x_return_status = FND_API.g_ret_sts_error
474: THEN
475: RAISE FND_API.g_exc_error;
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:

Line 499: WHEN FND_API.G_EXC_ERROR THEN

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 ;
501: ERRBUF := x_msg_data;
502: RETCODE := 2;
503: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Expected Error');

Line 500: x_return_status := FND_API.g_ret_sts_error ;

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 ;
501: ERRBUF := x_msg_data;
502: RETCODE := 2;
503: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Expected Error');
504:

Line 505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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);
508: RETCODE := 2;
509: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Unexpected Error');

Line 506: x_return_status := FND_API.g_ret_sts_unexp_error ;

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);
508: RETCODE := 2;
509: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Unexpected Error');
510:

Line 512: x_return_status := FND_API.g_ret_sts_unexp_error ;

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);
514: RETCODE := 2;
515: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Others');
516: