DBA Data[Home] [Help]

APPS.POS_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 1025: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE) is

1021: PROCEDURE PROCESS_USER_ATTRS_DATA(
1022: ERRBUF OUT NOCOPY VARCHAR2
1023: ,RETCODE OUT NOCOPY VARCHAR2
1024: ,p_data_set_id IN NUMBER
1025: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE) is
1026: l_entity_index_counter NUMBER := 0;
1027: l_debug_level NUMBER := 0;
1028: l_user_attrs_return_status VARCHAR2(100);
1029: l_return_status VARCHAR2(1);

Line 1049: l_user_attrs_return_status := FND_API.G_RET_STS_SUCCESS;

1045: ELSE
1046: l_debug_level := 0; --Since Debug log is not opened, donot open Debug log for User-Attrs also.
1047: END IF;
1048:
1049: l_user_attrs_return_status := FND_API.G_RET_STS_SUCCESS;
1050: Open c_pos_supp_prof_ext_intf;
1051: fetch c_pos_supp_prof_ext_intf into l_cnt;
1052: Close c_pos_supp_prof_ext_intf;
1053: IF l_cnt > 0 THEN

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

1094: ,p_entity_id => 0 --G_ENTITY_ID --IN NUMBER
1095: ,p_entity_index => 0 --l_entity_index_counter --IN NUMBER
1096: ,p_entity_code => 'HZ_PARTIES' --IN VARCHAR2
1097: ,p_debug_level => l_debug_level --IN NUMBER
1098: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
1099: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
1100: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
1101: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
1102: ,p_commit => FND_API.G_FALSE --IN VARCHAR2

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

1095: ,p_entity_index => 0 --l_entity_index_counter --IN NUMBER
1096: ,p_entity_code => 'HZ_PARTIES' --IN VARCHAR2
1097: ,p_debug_level => l_debug_level --IN NUMBER
1098: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
1099: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
1100: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
1101: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
1102: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
1103: ,p_default_view_privilege => NULL --IN VARCHAR2

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

1096: ,p_entity_code => 'HZ_PARTIES' --IN VARCHAR2
1097: ,p_debug_level => l_debug_level --IN NUMBER
1098: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
1099: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
1100: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
1101: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
1102: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
1103: ,p_default_view_privilege => NULL --IN VARCHAR2
1104: ,p_default_edit_privilege => NULL

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

1097: ,p_debug_level => l_debug_level --IN NUMBER
1098: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
1099: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
1100: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
1101: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
1102: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
1103: ,p_default_view_privilege => NULL --IN VARCHAR2
1104: ,p_default_edit_privilege => NULL
1105: ,p_privilege_predicate_api_name => NULL

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

1098: ,p_init_error_handler => FND_API.G_FALSE --IN VARCHAR2
1099: ,p_init_fnd_msg_list => FND_API.G_FALSE --IN VARCHAR2
1100: ,p_log_errors => FND_API.G_TRUE --IN VARCHAR2
1101: ,p_add_errors_to_fnd_stack => FND_API.G_TRUE --IN VARCHAR2
1102: ,p_commit => FND_API.G_FALSE --IN VARCHAR2
1103: ,p_default_view_privilege => NULL --IN VARCHAR2
1104: ,p_default_edit_privilege => NULL
1105: ,p_privilege_predicate_api_name => NULL
1106: ,p_related_class_codes_query => l_rel_sql --IN VARCHAR2

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

1126: Write_Conclog('msg count '||l_msg_count);
1127: Write_Conclog('msg data '||l_msg_data);
1128:
1129:
1130: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN
1131: -----------------------------------------------
1132: -- Delete all successful rows from the table --
1133: -- (they're the only rows still in process) --
1134: -----------------------------------------------

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

1165: Write_Conclog('****End of All Error messages***');
1166: -----------------------------------------------------------
1167: -- Let caller know whether any rows failed in processing --
1168: -----------------------------------------------------------
1169: IF ( l_user_attrs_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1170: RETCODE := G_RETCODE_SUCCESS_WITH_WARNING;
1171: ELSE
1172: RETCODE := FND_API.G_RET_STS_SUCCESS;
1173: END IF;

Line 1172: RETCODE := FND_API.G_RET_STS_SUCCESS;

1168: -----------------------------------------------------------
1169: IF ( l_user_attrs_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1170: RETCODE := G_RETCODE_SUCCESS_WITH_WARNING;
1171: ELSE
1172: RETCODE := FND_API.G_RET_STS_SUCCESS;
1173: END IF;
1174: EXCEPTION
1175: WHEN OTHERS THEN
1176: ----------------------------------------

Line 1192: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

1188: END IF;
1189:
1190: Write_Conclog('Error! While Processing User Defined Attributes ' ) ;
1191: Write_Conclog('Error while processing Process User Attrs data API '||SQLCODE || ':'||SQLERRM);
1192: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
1193: END Process_User_Attrs_Data;
1194: ---------------------------------------------------------------------
1195: -- Main API called by Java Concurrent program
1196: ---------------------------------------------------------------------

Line 1268: -- p_purge_successful_lines => FND_API.G_FALSE);

1264: --PROCESS_USER_ATTRS_DATA(
1265: -- ERRBUF => l_errbuf,
1266: -- RETCODE => l_retcode,
1267: -- p_data_set_id => batch_id,
1268: -- p_purge_successful_lines => FND_API.G_FALSE);
1269:
1270: Write_Conclog('Return Code After Executing LOAD and PROCESS APIs '||l_retcode);
1271: Write_Conclog('Error Code After Executing LOAD and PROCESS APIs '||l_errbuf);
1272: