APPS.FTE_LTL_LOADER dependencies on FND_GLOBAL

Line 25: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

21: ------------------------------------------------------------------------------------------*/
22:
23: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_LTL_LOADER';
24:
25: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
26: G_ACTION VARCHAR2(10);
27: G_LTL_UOM VARCHAR2(5) := 'Lbs';
28: G_ORIG_COUNTRY VARCHAR2(10) := 'US';
29: G_DEST_COUNTRY VARCHAR2(10) := 'US';

Line 3921: l_requests_tab := FND_CONCURRENT.GET_SUB_REQUESTS(FND_GLOBAL.CONC_REQUEST_ID);

3917:
3918: --+
3919: -- Get back the status from each child.
3920: --+
3921: l_requests_tab := FND_CONCURRENT.GET_SUB_REQUESTS(FND_GLOBAL.CONC_REQUEST_ID);
3922:
3923: l_counter := l_requests_tab.first;
3924:
3925: WHILE (l_counter is not null) LOOP

Line 4373: l_carriage_return VARCHAR2(1) := Fnd_Global.Local_Chr(13);

4369: p_load_id IN VARCHAR2,
4370: x_status OUT NOCOPY NUMBER,
4371: x_error_msg OUT NOCOPY VARCHAR2) IS
4372:
4373: l_carriage_return VARCHAR2(1) := Fnd_Global.Local_Chr(13);
4374: l_linefeed VARCHAR2(1) := Fnd_Global.Local_Chr(10);
4375: l_size NUMBER;
4376: l_content BLOB;
4377: l_amount BINARY_INTEGER := 12000;

Line 4374: l_linefeed VARCHAR2(1) := Fnd_Global.Local_Chr(10);

4370: x_status OUT NOCOPY NUMBER,
4371: x_error_msg OUT NOCOPY VARCHAR2) IS
4372:
4373: l_carriage_return VARCHAR2(1) := Fnd_Global.Local_Chr(13);
4374: l_linefeed VARCHAR2(1) := Fnd_Global.Local_Chr(10);
4375: l_size NUMBER;
4376: l_content BLOB;
4377: l_amount BINARY_INTEGER := 12000;
4378: l_position INTEGER := 1;

Line 4476: || fnd_global.newline || sqlerrm);

4472: WHEN OTHERS THEN
4473: x_status := 2;
4474: x_error_msg := SQLERRM;
4475: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Unexpected error while reading file: [Row ' || g_processed_lines || '].'
4476: || fnd_global.newline || sqlerrm);
4477: FTE_UTIL_PKG.Exit_Debug(l_module_name);
4478:
4479: END READ_LTL_FILE_FROM_TABLE;
4480:

Line 4506: l_carriage_return VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(13);

4502: x_status OUT NOCOPY NUMBER) IS
4503:
4504: l_chart_file UTL_FILE.file_type;
4505: l_src_file_dir VARCHAR2(500);
4506: l_carriage_return VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(13);
4507: l_line VARCHAR2(1000);
4508: isFileEmpty VARCHAR2(1) := 'Y';
4509:
4510: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.READ_LTL_FILE_FROM_DIR';

Line 4607: || fnd_global.newline || l_line || fnd_global.newline || sqlerrm);

4603: WHEN OTHERS THEN
4604: x_status := 2;
4605: x_error_msg := SQLERRM;
4606: FTE_UTIL_PKG.Write_LogFile(l_module_name,'UNEXPECTED ERROR while reading file: [Row ' || g_processed_lines || '].'
4607: || fnd_global.newline || l_line || fnd_global.newline || sqlerrm);
4608: FTE_UTIL_PKG.Exit_Debug(l_module_name);
4609:
4610: END READ_LTL_FILE_FROM_DIR;
4611: