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.RRS_BULKLOAD_ENTITIES dependencies on FND_API

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

150: G_ERRFILE_PATH_AND_NAME := l_log_output_dir||'/'||G_ERROR_FILE_NAME;
151:
152: Write_Conclog('Debug File name is => ' || G_ERRFILE_PATH_AND_NAME);
153:
154: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
155: Write_Conclog('Unable to open error log file. Error => '||l_errbuff);
156: END IF;
157:
158: END IF; --IF c_get_utl_file_dir%FOUND THEN

Line 665: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE) is

661: PROCEDURE PROCESS_USER_ATTRS_DATA(
662: ERRBUF OUT NOCOPY VARCHAR2
663: ,RETCODE OUT NOCOPY VARCHAR2
664: ,p_data_set_id IN NUMBER
665: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE) is
666: l_entity_index_counter NUMBER := 0;
667: l_debug_level NUMBER := 0;
668: l_user_attrs_return_status VARCHAR2(100);
669: l_return_status VARCHAR2(1);

Line 697: l_user_attrs_return_status := FND_API.G_RET_STS_SUCCESS;

693: ELSE
694: l_debug_level := 0; --Since Debug log is not opened, donot open Debug log for User-Attrs also.
695: END IF;
696:
697: l_user_attrs_return_status := FND_API.G_RET_STS_SUCCESS;
698: Open c_rrs_site_ua_intf;
699: fetch c_rrs_site_ua_intf into l_cnt;
700: Close c_rrs_site_ua_intf;
701: IF l_cnt > 0 THEN

Line 734: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2

730: ,p_entity_index => l_entity_index_counter --IN NUMBER
731: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
732: --,p_debug_level => p_debug_level --IN NUMBER
733: ,p_debug_level => l_debug_level --IN NUMBER
734: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
735: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
736: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
737: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
738: ,p_commit => FND_API.G_FALSE --IN VARCHAR2

Line 735: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2

731: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
732: --,p_debug_level => p_debug_level --IN NUMBER
733: ,p_debug_level => l_debug_level --IN NUMBER
734: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
735: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
736: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
737: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
738: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
739: ,p_default_view_privilege => NULL --IN VARCHAR2

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

732: --,p_debug_level => p_debug_level --IN NUMBER
733: ,p_debug_level => l_debug_level --IN NUMBER
734: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
735: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
736: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
737: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
738: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
739: ,p_default_view_privilege => NULL --IN VARCHAR2
740: ,p_default_edit_privilege => NULL

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

733: ,p_debug_level => l_debug_level --IN NUMBER
734: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
735: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
736: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
737: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
738: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
739: ,p_default_view_privilege => NULL --IN VARCHAR2
740: ,p_default_edit_privilege => NULL
741: ,p_privilege_predicate_api_name => NULL

Line 738: ,p_commit => FND_API.G_FALSE --IN VARCHAR2

734: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
735: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
736: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
737: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
738: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
739: ,p_default_view_privilege => NULL --IN VARCHAR2
740: ,p_default_edit_privilege => NULL
741: ,p_privilege_predicate_api_name => NULL
742: ,p_related_class_codes_query => l_rel_sql --IN VARCHAR2

Line 766: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN

762: Write_Conclog('msg count '||l_msg_count);
763: Write_Conclog('msg data '||l_msg_data);
764:
765:
766: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN
767: -----------------------------------------------
768: -- Delete all successful rows from the table --
769: -- (they're the only rows still in process) --
770: -----------------------------------------------

Line 820: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2

816: ,p_entity_index => l_entity_index_counter --IN NUMBER
817: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
818: --,p_debug_level => p_debug_level --IN NUMBER
819: ,p_debug_level => l_debug_level --IN NUMBER
820: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
821: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
822: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
823: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
824: ,p_commit => FND_API.G_FALSE --IN VARCHAR2

Line 821: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2

817: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
818: --,p_debug_level => p_debug_level --IN NUMBER
819: ,p_debug_level => l_debug_level --IN NUMBER
820: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
821: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
822: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
823: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
824: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
825: ,p_default_view_privilege => 'RRS_LOCATION_VIEW' --IN VARCHAR2

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

818: --,p_debug_level => p_debug_level --IN NUMBER
819: ,p_debug_level => l_debug_level --IN NUMBER
820: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
821: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
822: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
823: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
824: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
825: ,p_default_view_privilege => 'RRS_LOCATION_VIEW' --IN VARCHAR2
826: ,p_default_edit_privilege => NULL

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

819: ,p_debug_level => l_debug_level --IN NUMBER
820: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
821: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
822: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
823: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
824: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
825: ,p_default_view_privilege => 'RRS_LOCATION_VIEW' --IN VARCHAR2
826: ,p_default_edit_privilege => NULL
827: ,p_privilege_predicate_api_name => NULL

Line 824: ,p_commit => FND_API.G_FALSE --IN VARCHAR2

820: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
821: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
822: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
823: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
824: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
825: ,p_default_view_privilege => 'RRS_LOCATION_VIEW' --IN VARCHAR2
826: ,p_default_edit_privilege => NULL
827: ,p_privilege_predicate_api_name => NULL
828: ,p_related_class_codes_query => l_rel_sql --IN VARCHAR2

Line 841: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN

837: Write_Conclog('Return Status '||l_user_attrs_return_status);
838: Write_Conclog('Error Code '||l_errorcode);
839: Write_Conclog('msg count '||l_msg_count);
840: Write_Conclog('msg data '||l_msg_data);
841: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN
842: -----------------------------------------------
843: -- Delete all successful rows from the table --
844: -- (they're the only rows still in process) --
845: -----------------------------------------------

Line 897: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2

893: ,p_entity_index => l_entity_index_counter --IN NUMBER
894: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
895: --,p_debug_level => p_debug_level --IN NUMBER
896: ,p_debug_level => l_debug_level --IN NUMBER
897: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
898: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
899: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
900: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
901: ,p_commit => FND_API.G_FALSE --IN VARCHAR2

Line 898: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2

894: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
895: --,p_debug_level => p_debug_level --IN NUMBER
896: ,p_debug_level => l_debug_level --IN NUMBER
897: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
898: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
899: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
900: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
901: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
902: ,p_default_view_privilege => 'RRS_TRADE_AREA_VIEW' --IN VARCHAR2

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

895: --,p_debug_level => p_debug_level --IN NUMBER
896: ,p_debug_level => l_debug_level --IN NUMBER
897: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
898: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
899: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
900: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
901: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
902: ,p_default_view_privilege => 'RRS_TRADE_AREA_VIEW' --IN VARCHAR2
903: ,p_default_edit_privilege => NULL

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

896: ,p_debug_level => l_debug_level --IN NUMBER
897: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
898: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
899: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
900: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
901: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
902: ,p_default_view_privilege => 'RRS_TRADE_AREA_VIEW' --IN VARCHAR2
903: ,p_default_edit_privilege => NULL
904: ,p_privilege_predicate_api_name => NULL

Line 901: ,p_commit => FND_API.G_FALSE --IN VARCHAR2

897: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
898: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
899: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
900: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
901: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
902: ,p_default_view_privilege => 'RRS_TRADE_AREA_VIEW' --IN VARCHAR2
903: ,p_default_edit_privilege => NULL
904: ,p_privilege_predicate_api_name => NULL
905: ,p_related_class_codes_query => l_rel_sql --IN VARCHAR2

Line 918: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN

914: Write_Conclog('Return Status '||l_user_attrs_return_status);
915: Write_Conclog('Error Code '||l_errorcode);
916: Write_Conclog('msg count '||l_msg_count);
917: Write_Conclog('msg data '||l_msg_data);
918: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN
919: -----------------------------------------------
920: -- Delete all successful rows from the table --
921: -- (they're the only rows still in process) --
922: -----------------------------------------------

Line 954: IF ( l_user_attrs_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

950: Write_Conclog('****End of All Error messages***');
951: -----------------------------------------------------------
952: -- Let caller know whether any rows failed in processing --
953: -----------------------------------------------------------
954: IF ( l_user_attrs_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
955: RETCODE := G_RETCODE_SUCCESS_WITH_WARNING;
956: ELSE
957: RETCODE := FND_API.G_RET_STS_SUCCESS;
958: END IF;

Line 957: RETCODE := FND_API.G_RET_STS_SUCCESS;

953: -----------------------------------------------------------
954: IF ( l_user_attrs_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
955: RETCODE := G_RETCODE_SUCCESS_WITH_WARNING;
956: ELSE
957: RETCODE := FND_API.G_RET_STS_SUCCESS;
958: END IF;
959: EXCEPTION
960: WHEN OTHERS THEN
961: ----------------------------------------

Line 996: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

992: AND PROCESS_STATUS = G_PS_IN_PROCESS;
993: END IF;
994: Write_Conclog('Error! While Processing User Defined Attributes ' ) ;
995: Write_Conclog('Error while processing Process User Attrs data API '||SQLCODE || ':'||SQLERRM);
996: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
997: END Process_User_Attrs_Data;
998: ---------------------------------------------------------------------
999: -- Main API called by Java Concurrent program
1000: ---------------------------------------------------------------------

Line 1062: p_purge_successful_lines => FND_API.G_FALSE);

1058: PROCESS_USER_ATTRS_DATA(
1059: ERRBUF => l_errbuf,
1060: RETCODE => l_retcode,
1061: p_data_set_id => l_rrs_set_process_id,
1062: p_purge_successful_lines => FND_API.G_FALSE);
1063:
1064: Write_Conclog('Return Code After Executing LOAD and PROCESS APIs '||l_retcode);
1065: Write_Conclog('Error Code After Executing LOAD and PROCESS APIs '||l_errbuf);
1066: