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.

[Home] [Help]

APPS.RRS_SITE_UDA_BULKLOAD_INTF dependencies on FND_API

Line 139: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

135: G_ERRFILE_PATH_AND_NAME := l_log_output_dir||'/'||G_ERROR_FILE_NAME;
136:
137: Write_Conclog('Debug File name is => ' || G_ERRFILE_PATH_AND_NAME);
138:
139: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
140: Write_Conclog('Unable to open error log file. Error => '||l_errbuff);
141: END IF;
142:
143: END IF; --IF c_get_utl_file_dir%FOUND THEN

Line 237: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE) IS

233: ERRBUF OUT NOCOPY VARCHAR2
234: ,RETCODE OUT NOCOPY VARCHAR2
235: ,p_batch_id IN NUMBER
236: ,p_data_set_id IN NUMBER
237: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE) IS
238: l_entity_index_counter NUMBER := 0;
239: l_debug_level NUMBER := 0;
240: l_user_attrs_return_status VARCHAR2(100);
241: l_return_status VARCHAR2(1);

Line 290: l_user_attrs_return_status := FND_API.G_RET_STS_SUCCESS;

286: ELSE
287: l_debug_level := 0; --Since Debug log is not opened, donot open Debug log for User-Attrs also.
288: END IF;
289: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_SITES' );
290: l_user_attrs_return_status := FND_API.G_RET_STS_SUCCESS;
291:
292: Open c_rrs_site_ua_intf;
293: fetch c_rrs_site_ua_intf into l_cnt;
294: Close c_rrs_site_ua_intf;

Line 357: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => G_API_VERSION, p_privilege => 'RRS_VIEW_SITE', p_object_name => 'RRS_SITE', p_object_key => l_site_id_list(i).site_id, p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then

353: p_processing_errors := rrs_processing_errors_tab();
354: local_processing_errors := rrs_processing_errors_tab();
355:
356:
357: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => G_API_VERSION, p_privilege => 'RRS_VIEW_SITE', p_object_name => 'RRS_SITE', p_object_key => l_site_id_list(i).site_id, p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then
358:
359: null;
360: else
361: l_row_status := 'E';

Line 382: p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then

378: end if;
379:
380: If (EGO_SECURITY_PUB.check_user_privilege(p_api_version => G_API_VERSION, p_privilege => 'RRS_EDIT_SITE',
381: p_object_name => 'RRS_SITE', p_object_key => l_site_id_list(i).site_id,
382: p_user_id => FND_GLOBAL.USER_ID )) = FND_API.G_TRUE then
383:
384: null;
385: else
386: l_row_status := 'E';

Line 460: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2

456: ,p_entity_index => l_entity_index_counter --IN NUMBER
457: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
458: --,p_debug_level => p_debug_level --IN NUMBER
459: ,p_debug_level => l_debug_level --IN NUMBER
460: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
461: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
462: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
463: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
464: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

Line 461: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2

457: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
458: --,p_debug_level => p_debug_level --IN NUMBER
459: ,p_debug_level => l_debug_level --IN NUMBER
460: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
461: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
462: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
463: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
464: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
465: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list --IN VARCHAR2

Line 462: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2

458: --,p_debug_level => p_debug_level --IN NUMBER
459: ,p_debug_level => l_debug_level --IN NUMBER
460: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
461: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
462: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
463: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
464: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
465: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list --IN VARCHAR2
466: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list

Line 463: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2

459: ,p_debug_level => l_debug_level --IN NUMBER
460: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
461: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
462: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
463: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
464: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
465: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list --IN VARCHAR2
466: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list
467: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name

Line 464: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

460: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
461: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
462: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
463: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
464: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
465: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list --IN VARCHAR2
466: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list
467: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name
468: ,p_related_class_codes_query => l_rel_sql --IN VARCHAR2

Line 566: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2

562: ,p_entity_index => l_entity_index_counter --IN NUMBER
563: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
564: --,p_debug_level => p_debug_level --IN NUMBER
565: ,p_debug_level => l_debug_level --IN NUMBER
566: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
567: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
568: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
569: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
570: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

Line 567: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2

563: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
564: --,p_debug_level => p_debug_level --IN NUMBER
565: ,p_debug_level => l_debug_level --IN NUMBER
566: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
567: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
568: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
569: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
570: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
571: ,p_default_view_privilege => 'RRS_LOCATION_VIEW' --IN VARCHAR2

Line 568: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2

564: --,p_debug_level => p_debug_level --IN NUMBER
565: ,p_debug_level => l_debug_level --IN NUMBER
566: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
567: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
568: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
569: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
570: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
571: ,p_default_view_privilege => 'RRS_LOCATION_VIEW' --IN VARCHAR2
572: ,p_default_edit_privilege => NULL

Line 569: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2

565: ,p_debug_level => l_debug_level --IN NUMBER
566: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
567: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
568: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
569: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
570: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
571: ,p_default_view_privilege => 'RRS_LOCATION_VIEW' --IN VARCHAR2
572: ,p_default_edit_privilege => NULL
573: ,p_privilege_predicate_api_name => NULL

Line 570: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

566: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
567: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
568: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
569: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
570: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
571: ,p_default_view_privilege => 'RRS_LOCATION_VIEW' --IN VARCHAR2
572: ,p_default_edit_privilege => NULL
573: ,p_privilege_predicate_api_name => NULL
574: ,p_related_class_codes_query => l_rel_sql --IN VARCHAR2

Line 661: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2

657: ,p_entity_index => l_entity_index_counter --IN NUMBER
658: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
659: --,p_debug_level => p_debug_level --IN NUMBER
660: ,p_debug_level => l_debug_level --IN NUMBER
661: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
662: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
663: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
664: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
665: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

Line 662: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2

658: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
659: --,p_debug_level => p_debug_level --IN NUMBER
660: ,p_debug_level => l_debug_level --IN NUMBER
661: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
662: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
663: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
664: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
665: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
666: ,p_default_view_privilege => 'RRS_TRADE_AREA_VIEW' --IN VARCHAR2

Line 663: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2

659: --,p_debug_level => p_debug_level --IN NUMBER
660: ,p_debug_level => l_debug_level --IN NUMBER
661: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
662: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
663: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
664: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
665: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
666: ,p_default_view_privilege => 'RRS_TRADE_AREA_VIEW' --IN VARCHAR2
667: ,p_default_edit_privilege => NULL

Line 664: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2

660: ,p_debug_level => l_debug_level --IN NUMBER
661: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
662: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
663: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
664: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
665: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
666: ,p_default_view_privilege => 'RRS_TRADE_AREA_VIEW' --IN VARCHAR2
667: ,p_default_edit_privilege => NULL
668: ,p_privilege_predicate_api_name => NULL

Line 665: ,p_commit => FND_API.G_TRUE --IN VARCHAR2

661: ,p_init_error_handler => FND_API.G_TRUE --IN VARCHAR2
662: ,p_init_fnd_msg_list => FND_API.G_TRUE --IN VARCHAR2
663: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
664: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
665: ,p_commit => FND_API.G_TRUE --IN VARCHAR2
666: ,p_default_view_privilege => 'RRS_TRADE_AREA_VIEW' --IN VARCHAR2
667: ,p_default_edit_privilege => NULL
668: ,p_privilege_predicate_api_name => NULL
669: ,p_related_class_codes_query => l_rel_sql --IN VARCHAR2

Line 727: IF ( l_user_attrs_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

723: Write_Conclog('****End of All Error messages***');
724: -----------------------------------------------------------
725: -- Let caller know whether any rows failed in processing --
726: -----------------------------------------------------------
727: IF ( l_user_attrs_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
728: RETCODE := FND_API.G_RET_STS_SUCCESS;
729: ELSIF ( l_user_attrs_return_status = G_RETCODE_SUCCESS_WITH_WARNING ) THEN
730: RETCODE := G_RETCODE_SUCCESS_WITH_WARNING;
731: ELSIF ( l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

Line 728: RETCODE := FND_API.G_RET_STS_SUCCESS;

724: -----------------------------------------------------------
725: -- Let caller know whether any rows failed in processing --
726: -----------------------------------------------------------
727: IF ( l_user_attrs_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
728: RETCODE := FND_API.G_RET_STS_SUCCESS;
729: ELSIF ( l_user_attrs_return_status = G_RETCODE_SUCCESS_WITH_WARNING ) THEN
730: RETCODE := G_RETCODE_SUCCESS_WITH_WARNING;
731: ELSIF ( l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
732: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

Line 731: ELSIF ( l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

727: IF ( l_user_attrs_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
728: RETCODE := FND_API.G_RET_STS_SUCCESS;
729: ELSIF ( l_user_attrs_return_status = G_RETCODE_SUCCESS_WITH_WARNING ) THEN
730: RETCODE := G_RETCODE_SUCCESS_WITH_WARNING;
731: ELSIF ( l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
732: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
733: ROLLBACK;
734: END IF;
735:

Line 732: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

728: RETCODE := FND_API.G_RET_STS_SUCCESS;
729: ELSIF ( l_user_attrs_return_status = G_RETCODE_SUCCESS_WITH_WARNING ) THEN
730: RETCODE := G_RETCODE_SUCCESS_WITH_WARNING;
731: ELSIF ( l_user_attrs_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
732: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
733: ROLLBACK;
734: END IF;
735:
736: BEGIN

Line 794: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

790: -- Mark all rows in process as errors --
791: ----------------------------------------
792: Write_Conclog('Error! While Processing User Defined Attributes ' ) ;
793: Write_Conclog('Error while processing Process User Attrs data API '||SQLCODE || ':'||SQLERRM);
794: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
795: ROLLBACK;
796: END LOAD_USERATTR_DATA;
797: END;