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.FTE_BULKLOAD_PKG dependencies on FND_GLOBAL

Line 27: g_carriage_return VARCHAR2(1) := Fnd_Global.Local_Chr(13);

23: -- --
24: ----------------------------------------------------------------------------- --
25:
26: G_PKG_NAME VARCHAR2(50) := 'FTE_BULKLOAD_PKG';
27: g_carriage_return VARCHAR2(1) := Fnd_Global.Local_Chr(13);
28: g_linefeed VARCHAR2(1) := Fnd_Global.Local_Chr(10);
29: g_tab VARCHAR2(1) := Fnd_Global.Local_Chr(9);
30:
31: ------------------------------------------------------------------

Line 28: g_linefeed VARCHAR2(1) := Fnd_Global.Local_Chr(10);

24: ----------------------------------------------------------------------------- --
25:
26: G_PKG_NAME VARCHAR2(50) := 'FTE_BULKLOAD_PKG';
27: g_carriage_return VARCHAR2(1) := Fnd_Global.Local_Chr(13);
28: g_linefeed VARCHAR2(1) := Fnd_Global.Local_Chr(10);
29: g_tab VARCHAR2(1) := Fnd_Global.Local_Chr(9);
30:
31: ------------------------------------------------------------------
32: -- Procedure: GET_PROCESS_ID

Line 29: g_tab VARCHAR2(1) := Fnd_Global.Local_Chr(9);

25:
26: G_PKG_NAME VARCHAR2(50) := 'FTE_BULKLOAD_PKG';
27: g_carriage_return VARCHAR2(1) := Fnd_Global.Local_Chr(13);
28: g_linefeed VARCHAR2(1) := Fnd_Global.Local_Chr(10);
29: g_tab VARCHAR2(1) := Fnd_Global.Local_Chr(9);
30:
31: ------------------------------------------------------------------
32: -- Procedure: GET_PROCESS_ID
33: -- Purpose: get the process id for qp interface tables

Line 195: 0, p_RequestId, EMPTY_BLOB(), FND_GLOBAL.USER_ID,

191: LAST_UPDATE_DATE,
192: LAST_UPDATE_LOGIN)
193:
194: VALUES (p_LoadId, p_LoadType, p_FileType, p_FileName,
195: 0, p_RequestId, EMPTY_BLOB(), FND_GLOBAL.USER_ID,
196: v_LastUpdateDate, FND_GLOBAL.USER_ID, v_LastUpdateDate, FND_GLOBAL.USER_ID);
197:
198: FTE_UTIL_PKG.Exit_Debug(l_module_name);
199: RETURN 0;

Line 196: v_LastUpdateDate, FND_GLOBAL.USER_ID, v_LastUpdateDate, FND_GLOBAL.USER_ID);

192: LAST_UPDATE_LOGIN)
193:
194: VALUES (p_LoadId, p_LoadType, p_FileType, p_FileName,
195: 0, p_RequestId, EMPTY_BLOB(), FND_GLOBAL.USER_ID,
196: v_LastUpdateDate, FND_GLOBAL.USER_ID, v_LastUpdateDate, FND_GLOBAL.USER_ID);
197:
198: FTE_UTIL_PKG.Exit_Debug(l_module_name);
199: RETURN 0;
200: END;

Line 376: fnd_global.apps_initialize(user_id => p_user_id,

372: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Tariff Name ', p_tariff_name);
373: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'User Debug ', p_user_debug);
374: END IF;
375:
376: fnd_global.apps_initialize(user_id => p_user_id,
377: resp_id => p_resp_id,
378: resp_appl_id => p_resp_appl_id);
379:
380: --+

Line 695: -- fnd_global.newline || 'Please make sure that the directory is accessible to UTL_FILE.';

691:
692: FTE_UTIL_PKG.Exit_Debug(l_module_name);
693: WHEN UTL_FILE.INVALID_PATH THEN
694: -- x_error_msg := 'File ' || l_src_file_dir || '/' || p_file_name || ' Not Accessible' ||
695: -- fnd_global.newline || 'Please make sure that the directory is accessible to UTL_FILE.';
696:
697: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
698: p_msg => 'FTE_FILE_NOT_ACCESSIBLE',
699: p_category => 'E');

Line 705: -- || fnd_global.newline || 'Please verify file and directory access privileges on the file system.';

701: x_status := 2;
702: FTE_UTIL_PKG.Exit_Debug(l_module_name);
703: WHEN UTL_FILE.INVALID_OPERATION THEN
704: -- x_error_msg := 'ERROR: The file does not exist, or file or directory access was denied by the operating system.'
705: -- || fnd_global.newline || 'Please verify file and directory access privileges on the file system.';
706:
707: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
708: p_msg => 'FTE_FILE_NOT_EXIST',
709: p_category => 'E');

Line 715: || fnd_global.newline || l_line || fnd_global.newline || sqlerrm;

711: x_status := 2;
712: FTE_UTIL_PKG.Exit_Debug(l_module_name);
713: WHEN OTHERS THEN
714: x_error_msg := 'Unexpected error while reading file: [Row ' || l_processed_lines || '].'
715: || fnd_global.newline || l_line || fnd_global.newline || sqlerrm;
716:
717: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, x_error_msg);
718:
719: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 943: || fnd_global.newline || sqlerrm;

939: FTE_UTIL_PKG.Exit_Debug(l_module_name);
940: EXCEPTION
941: WHEN OTHERS THEN
942: x_error_msg := 'Unexpected error while reading file: [Row ' || l_processed_lines || '].'
943: || fnd_global.newline || sqlerrm;
944:
945: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, x_error_msg);
946:
947: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 1256: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1252:
1253: IF (p_LoadType <> 'DTT_DWNLD') THEN
1254: UPDATE FTE_BULKLOAD_DATA
1255: SET request_id = p_RequestId,
1256: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1257: LAST_UPDATE_DATE = sysdate,
1258: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
1259: WHERE load_id = p_LoadId AND
1260: load_type = p_LoadType AND

Line 1258: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

1254: UPDATE FTE_BULKLOAD_DATA
1255: SET request_id = p_RequestId,
1256: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1257: LAST_UPDATE_DATE = sysdate,
1258: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
1259: WHERE load_id = p_LoadId AND
1260: load_type = p_LoadType AND
1261: file_type = p_FileType AND
1262: file_name = p_FileName;

Line 1267: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1263:
1264: ELSIF (p_LoadType = 'DTT_DWNLD') THEN
1265: UPDATE FTE_BULKLOAD_DATA
1266: SET request_id = p_RequestId,
1267: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1268: LAST_UPDATE_DATE = sysdate,
1269: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
1270: WHERE load_id = p_LoadId AND
1271: load_type = p_LoadType;

Line 1269: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

1265: UPDATE FTE_BULKLOAD_DATA
1266: SET request_id = p_RequestId,
1267: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1268: LAST_UPDATE_DATE = sysdate,
1269: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
1270: WHERE load_id = p_LoadId AND
1271: load_type = p_LoadType;
1272: END IF;
1273:

Line 1366: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1362:
1363: UPDATE FTE_BULKLOAD_DATA
1364: SET last_update_date = v_LastUpdateDate,
1365: file_size = v_FileSize,
1366: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1367: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
1368: WHERE load_id = p_LoadId;
1369: ELSE
1370: SELECT content

Line 1367: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID

1363: UPDATE FTE_BULKLOAD_DATA
1364: SET last_update_date = v_LastUpdateDate,
1365: file_size = v_FileSize,
1366: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1367: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
1368: WHERE load_id = p_LoadId;
1369: ELSE
1370: SELECT content
1371: INTO p_FileContents