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_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 724: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE) is

720: PROCEDURE PROCESS_USER_ATTRS_DATA(
721: ERRBUF OUT NOCOPY VARCHAR2
722: ,RETCODE OUT NOCOPY VARCHAR2
723: ,p_data_set_id IN NUMBER
724: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE) is
725: l_entity_index_counter NUMBER := 0;
726: l_debug_level NUMBER := 0;
727: l_user_attrs_return_status VARCHAR2(100);
728: l_return_status VARCHAR2(1);

Line 768: l_user_attrs_return_status := FND_API.G_RET_STS_SUCCESS;

764: ELSE
765: l_debug_level := 0; --Since Debug log is not opened, donot open Debug log for User-Attrs also.
766: END IF;
767:
768: l_user_attrs_return_status := FND_API.G_RET_STS_SUCCESS;
769: Open c_rrs_site_ua_intf;
770: fetch c_rrs_site_ua_intf into l_cnt;
771: Close c_rrs_site_ua_intf;
772:

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

833: ,p_entity_index => l_entity_index_counter --IN NUMBER
834: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
835: --,p_debug_level => p_debug_level --IN NUMBER
836: ,p_debug_level => l_debug_level --IN NUMBER
837: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
838: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
839: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
840: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
841: ,p_commit => FND_API.G_FALSE --IN VARCHAR2

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

834: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
835: --,p_debug_level => p_debug_level --IN NUMBER
836: ,p_debug_level => l_debug_level --IN NUMBER
837: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
838: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
839: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
840: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
841: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
842: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list --IN VARCHAR2

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

835: --,p_debug_level => p_debug_level --IN NUMBER
836: ,p_debug_level => l_debug_level --IN NUMBER
837: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
838: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
839: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
840: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
841: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
842: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list --IN VARCHAR2
843: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list

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

836: ,p_debug_level => l_debug_level --IN NUMBER
837: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
838: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
839: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
840: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
841: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
842: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list --IN VARCHAR2
843: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list
844: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name

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

837: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
838: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
839: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
840: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
841: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
842: ,p_default_dl_view_priv_list => l_default_dl_view_priv_list --IN VARCHAR2
843: ,p_default_dl_edit_priv_list => l_default_dl_edit_priv_list
844: ,p_privilege_predicate_api_name => l_privilege_predicate_api_name
845: ,p_related_class_codes_query => l_rel_sql --IN VARCHAR2

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

865: Write_Conclog('msg count '||l_msg_count);
866: Write_Conclog('msg data '||l_msg_data);
867:
868:
869: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN
870: -----------------------------------------------
871: -- Delete all successful rows from the table --
872: -- (they're the only rows still in process) --
873: -----------------------------------------------

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

919: ,p_entity_index => l_entity_index_counter --IN NUMBER
920: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
921: --,p_debug_level => p_debug_level --IN NUMBER
922: ,p_debug_level => l_debug_level --IN NUMBER
923: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
924: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
925: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
926: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
927: ,p_commit => FND_API.G_FALSE --IN VARCHAR2

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

920: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
921: --,p_debug_level => p_debug_level --IN NUMBER
922: ,p_debug_level => l_debug_level --IN NUMBER
923: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
924: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
925: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
926: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
927: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
928: ,p_default_view_privilege => 'RRS_LOCATION_VIEW' --IN VARCHAR2

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

921: --,p_debug_level => p_debug_level --IN NUMBER
922: ,p_debug_level => l_debug_level --IN NUMBER
923: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
924: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
925: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
926: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
927: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
928: ,p_default_view_privilege => 'RRS_LOCATION_VIEW' --IN VARCHAR2
929: ,p_default_edit_privilege => NULL

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

922: ,p_debug_level => l_debug_level --IN NUMBER
923: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
924: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
925: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
926: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
927: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
928: ,p_default_view_privilege => 'RRS_LOCATION_VIEW' --IN VARCHAR2
929: ,p_default_edit_privilege => NULL
930: ,p_privilege_predicate_api_name => NULL

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

923: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
924: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
925: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
926: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
927: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
928: ,p_default_view_privilege => 'RRS_LOCATION_VIEW' --IN VARCHAR2
929: ,p_default_edit_privilege => NULL
930: ,p_privilege_predicate_api_name => NULL
931: ,p_related_class_codes_query => l_rel_sql --IN VARCHAR2

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

940: Write_Conclog('Return Status '||l_user_attrs_return_status);
941: Write_Conclog('Error Code '||l_errorcode);
942: Write_Conclog('msg count '||l_msg_count);
943: Write_Conclog('msg data '||l_msg_data);
944: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN
945: -----------------------------------------------
946: -- Delete all successful rows from the table --
947: -- (they're the only rows still in process) --
948: -----------------------------------------------

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

996: ,p_entity_index => l_entity_index_counter --IN NUMBER
997: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
998: --,p_debug_level => p_debug_level --IN NUMBER
999: ,p_debug_level => l_debug_level --IN NUMBER
1000: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
1001: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
1002: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
1003: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
1004: ,p_commit => FND_API.G_FALSE --IN VARCHAR2

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

997: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2
998: --,p_debug_level => p_debug_level --IN NUMBER
999: ,p_debug_level => l_debug_level --IN NUMBER
1000: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
1001: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
1002: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
1003: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
1004: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
1005: ,p_default_view_privilege => 'RRS_TRADE_AREA_VIEW' --IN VARCHAR2

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

998: --,p_debug_level => p_debug_level --IN NUMBER
999: ,p_debug_level => l_debug_level --IN NUMBER
1000: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
1001: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
1002: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
1003: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
1004: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
1005: ,p_default_view_privilege => 'RRS_TRADE_AREA_VIEW' --IN VARCHAR2
1006: ,p_default_edit_privilege => NULL

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

999: ,p_debug_level => l_debug_level --IN NUMBER
1000: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
1001: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
1002: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
1003: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
1004: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
1005: ,p_default_view_privilege => 'RRS_TRADE_AREA_VIEW' --IN VARCHAR2
1006: ,p_default_edit_privilege => NULL
1007: ,p_privilege_predicate_api_name => NULL

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

1000: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
1001: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
1002: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
1003: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
1004: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
1005: ,p_default_view_privilege => 'RRS_TRADE_AREA_VIEW' --IN VARCHAR2
1006: ,p_default_edit_privilege => NULL
1007: ,p_privilege_predicate_api_name => NULL
1008: ,p_related_class_codes_query => l_rel_sql --IN VARCHAR2

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

1017: Write_Conclog('Return Status '||l_user_attrs_return_status);
1018: Write_Conclog('Error Code '||l_errorcode);
1019: Write_Conclog('msg count '||l_msg_count);
1020: Write_Conclog('msg data '||l_msg_data);
1021: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN
1022: -----------------------------------------------
1023: -- Delete all successful rows from the table --
1024: -- (they're the only rows still in process) --
1025: -----------------------------------------------

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

1053: Write_Conclog('****End of All Error messages***');
1054: -----------------------------------------------------------
1055: -- Let caller know whether any rows failed in processing --
1056: -----------------------------------------------------------
1057: IF ( l_user_attrs_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1058: RETCODE := G_RETCODE_SUCCESS_WITH_WARNING;
1059: ELSE
1060: RETCODE := FND_API.G_RET_STS_SUCCESS;
1061: END IF;

Line 1060: RETCODE := FND_API.G_RET_STS_SUCCESS;

1056: -----------------------------------------------------------
1057: IF ( l_user_attrs_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1058: RETCODE := G_RETCODE_SUCCESS_WITH_WARNING;
1059: ELSE
1060: RETCODE := FND_API.G_RET_STS_SUCCESS;
1061: END IF;
1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: ----------------------------------------

Line 1099: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

1095: AND PROCESS_STATUS = G_PS_IN_PROCESS;
1096: END IF;
1097: Write_Conclog('Error! While Processing User Defined Attributes ' ) ;
1098: Write_Conclog('Error while processing Process User Attrs data API '||SQLCODE || ':'||SQLERRM);
1099: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
1100: END Process_User_Attrs_Data;
1101: ---------------------------------------------------------------------
1102: -- Main API called by Java Concurrent program
1103: ---------------------------------------------------------------------

Line 1165: p_purge_successful_lines => FND_API.G_FALSE);

1161: PROCESS_USER_ATTRS_DATA(
1162: ERRBUF => l_errbuf,
1163: RETCODE => l_retcode,
1164: p_data_set_id => l_rrs_set_process_id,
1165: p_purge_successful_lines => FND_API.G_FALSE);
1166:
1167: Write_Conclog('Return Code After Executing LOAD and PROCESS APIs '||l_retcode);
1168: Write_Conclog('Error Code After Executing LOAD and PROCESS APIs '||l_errbuf);
1169: