[Home] [Help]
32: G_PS_GENERIC_ERROR CONSTANT NUMBER := 3;
33: G_PS_SUCCESS CONSTANT NUMBER := 4;
34: G_RETCODE_SUCCESS_WITH_WARNING CONSTANT VARCHAR(1) := 'W';
35:
36: G_ERROR_TABLE_NAME VARCHAR2(99) := 'EGO_BULKLOAD_INTF';
37: G_ERROR_ENTITY_CODE VARCHAR2(99) := 'RRS_SITE';
38: G_ERROR_FILE_NAME VARCHAR2(99);
39: G_BO_IDENTIFIER VARCHAR2(99) := 'RRS_SITE';
40: G_DEBUG CONSTANT VARCHAR2(10) := NVL(FND_PROFILE.VALUE('RRS_DEBUG_TRACE'),0);
73: ERROR_FILE OUT NOCOPY VARCHAR2,
74: p_result_format_usage_id IN Number) Is
75: l_process_status char(100);
76: BEGIN
77: DELETE FROM EGO_BULKLOAD_INTF
78: WHERE RESULTFMT_USAGE_ID = p_result_format_usage_id
79: AND PROCESS_STATUS <> G_DATA_ROWS_UPLOADED_NEW;
80: Open_Debug_Session;
81: ERROR_FILE := G_ERRFILE_PATH_AND_NAME;
387: ELSE
388: l_dyn_attr_id_val_sql := l_dyn_attr_id_val_sql || l_intf_col_name_table(i) ;
389: END IF;
390: END LOOP; --end: FOR i IN 1..l_attr_id_table.COUNT LOOP
391: l_dyn_attr_id_val_sql := l_dyn_attr_id_val_sql || ' FROM EGO_BULKLOAD_INTF ' ;
392: l_dyn_attr_id_val_sql := l_dyn_attr_id_val_sql || ' WHERE RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';
393: l_dyn_attr_id_val_sql := l_dyn_attr_id_val_sql || ' AND PROCESS_STATUS = :PROCESS_STATUS ';
394: DBMS_SQL.PARSE(l_cursor_attr_id_val, l_dyn_attr_id_val_sql, DBMS_SQL.NATIVE);
395: --------------------------------------------------------------------
1123: l_process_status char(100);
1124: BEGIN
1125: Write_Conclog('Executing the BulkLoadEntities API ');
1126: Write_Conclog('User Defined Attributes Import Program *STARTED*');
1127: UPDATE EGO_BULKLOAD_INTF
1128: SET
1129: PROCESS_STATUS = G_PS_IN_PROCESS,
1130: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
1131: REQUEST_ID = FND_GLOBAL.conc_request_id,
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:
1170: IF l_retcode = 'S' THEN
1171: UPDATE EGO_BULKLOAD_INTF
1172: SET PROCESS_STATUS = G_PS_SUCCESS,
1173: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id,
1174: REQUEST_ID = FND_GLOBAL.conc_request_id,
1175: PROGRAM_APPLICATION_ID = FND_GLOBAL.prog_appl_id,