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 STRINGARRAY

Line 233: -- Purpose: Adding a row to a table of STRINGARRAYs from values in p_tokens.

229:
230: ----------------------------------------------------------------------------------
231: -- Function: ADD_ROW
232: --
233: -- Purpose: Adding a row to a table of STRINGARRAYs from values in p_tokens.
234: --
235: -- IN parameters:
236: -- 1. p_tokens: array of values parsed from the file to be stored
237: -- 2. p_table: a pl/sql table of STRINGARRAY

Line 237: -- 2. p_table: a pl/sql table of STRINGARRAY

233: -- Purpose: Adding a row to a table of STRINGARRAYs from values in p_tokens.
234: --
235: -- IN parameters:
236: -- 1. p_tokens: array of values parsed from the file to be stored
237: -- 2. p_table: a pl/sql table of STRINGARRAY
238: -- 3. p_col: a boolean, true if this line is a column header line, false else
239: --
240: -- Returns a number: -1 for no error, 1 for too few items in p_tokens, 2 for too many
241: ----------------------------------------------------------------------------------

Line 242: FUNCTION ADD_ROW(p_tokens IN STRINGARRAY,

238: -- 3. p_col: a boolean, true if this line is a column header line, false else
239: --
240: -- Returns a number: -1 for no error, 1 for too few items in p_tokens, 2 for too many
241: ----------------------------------------------------------------------------------
242: FUNCTION ADD_ROW(p_tokens IN STRINGARRAY,
243: p_block_header IN OUT NOCOPY block_header_tbl,
244: p_block_data IN OUT NOCOPY block_data_tbl,
245: p_col IN BOOLEAN) RETURN NUMBER IS
246:

Line 497: P_Tokens => STRINGARRAY('TYPE'),

493: x_error_msg => x_error_msg);
494: ELSE
495: x_status := 2;
496: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_TYPE_UNKNOWN',
497: P_Tokens => STRINGARRAY('TYPE'),
498: P_values => STRINGARRAY(p_block_type));
499: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
500: p_msg => x_error_msg,
501: p_category => 'D',

Line 498: P_values => STRINGARRAY(p_block_type));

494: ELSE
495: x_status := 2;
496: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_TYPE_UNKNOWN',
497: P_Tokens => STRINGARRAY('TYPE'),
498: P_values => STRINGARRAY(p_block_type));
499: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
500: p_msg => x_error_msg,
501: p_category => 'D',
502: p_line_number => p_line_number);

Line 538: l_tokens STRINGARRAY;

534: p_load_id IN NUMBER,
535: x_status OUT NOCOPY NUMBER,
536: x_error_msg OUT NOCOPY VARCHAR2) IS
537:
538: l_tokens STRINGARRAY;
539: l_debug_on BOOLEAN;
540: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.READ_BLOCK_FROM_DIR';
541: x_chart_file UTL_FILE.file_type;
542: l_src_file_dir VARCHAR2(500);

Line 612: p_tokens => STRINGARRAY('BLOCK'),

608:
609: IF (l_column_line) THEN
610: --throw error about no information
611: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_BLOCK_NO_LINE',
612: p_tokens => STRINGARRAY('BLOCK'),
613: p_values => STRINGARRAY(l_block_type));
614: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
615: p_msg => x_error_msg,
616: p_category => 'A');

Line 613: p_values => STRINGARRAY(l_block_type));

609: IF (l_column_line) THEN
610: --throw error about no information
611: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_BLOCK_NO_LINE',
612: p_tokens => STRINGARRAY('BLOCK'),
613: p_values => STRINGARRAY(l_block_type));
614: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
615: p_msg => x_error_msg,
616: p_category => 'A');
617:

Line 753: l_lines STRINGARRAY;

749: l_amount BINARY_INTEGER := 12000;
750: l_position INTEGER := 1;
751: data_buffer VARCHAR2(32000);
752: temp_buffer VARCHAR2(32000);
753: l_lines STRINGARRAY;
754: l_tokens STRINGARRAY;
755: l_debug_on BOOLEAN;
756: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.READ_BLOCK_FROM_TABLE';
757: l_block_type VARCHAR2(100);

Line 754: l_tokens STRINGARRAY;

750: l_position INTEGER := 1;
751: data_buffer VARCHAR2(32000);
752: temp_buffer VARCHAR2(32000);
753: l_lines STRINGARRAY;
754: l_tokens STRINGARRAY;
755: l_debug_on BOOLEAN;
756: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.READ_BLOCK_FROM_TABLE';
757: l_block_type VARCHAR2(100);
758: l_section_line BOOLEAN;

Line 1099: p_tokens => STRINGARRAY('NAME'),

1095: p_msg => ' ',
1096: p_category => NULL);
1097:
1098: l_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_BULKLOAD_PROCESSING', -- File Processed :
1099: p_tokens => STRINGARRAY('NAME'),
1100: p_values => STRINGARRAY(p_src_filename));
1101:
1102: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1103: p_msg => l_msg,

Line 1100: p_values => STRINGARRAY(p_src_filename));

1096: p_category => NULL);
1097:
1098: l_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_BULKLOAD_PROCESSING', -- File Processed :
1099: p_tokens => STRINGARRAY('NAME'),
1100: p_values => STRINGARRAY(p_src_filename));
1101:
1102: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1103: p_msg => l_msg,
1104: p_category => NULL);

Line 1107: p_tokens => STRINGARRAY('TYPE'),

1103: p_msg => l_msg,
1104: p_category => NULL);
1105:
1106: l_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_BULKLOAD_TYPE', -- Type of Load :
1107: p_tokens => STRINGARRAY('TYPE'),
1108: p_values => STRINGARRAY(l_type));
1109:
1110: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1111: p_msg => l_msg,

Line 1108: p_values => STRINGARRAY(l_type));

1104: p_category => NULL);
1105:
1106: l_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_BULKLOAD_TYPE', -- Type of Load :
1107: p_tokens => STRINGARRAY('TYPE'),
1108: p_values => STRINGARRAY(l_type));
1109:
1110: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1111: p_msg => l_msg,
1112: p_category => NULL);

Line 1115: p_tokens => STRINGARRAY('ID'),

1111: p_msg => l_msg,
1112: p_category => NULL);
1113:
1114: l_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_BULKLOAD_LOADID', -- Load ID :
1115: p_tokens => STRINGARRAY('ID'),
1116: p_values => STRINGARRAY(p_load_id));
1117:
1118: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1119: p_msg => l_msg,

Line 1116: p_values => STRINGARRAY(p_load_id));

1112: p_category => NULL);
1113:
1114: l_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_BULKLOAD_LOADID', -- Load ID :
1115: p_tokens => STRINGARRAY('ID'),
1116: p_values => STRINGARRAY(p_load_id));
1117:
1118: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1119: p_msg => l_msg,
1120: p_category => NULL);

Line 1123: p_tokens => STRINGARRAY('DEBUG'),

1119: p_msg => l_msg,
1120: p_category => NULL);
1121:
1122: l_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_BULKLOAD_DEBUG', -- Debug Enabled :
1123: p_tokens => STRINGARRAY('DEBUG'),
1124: p_values => STRINGARRAY(p_user_debug));
1125:
1126: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1127: p_msg => l_msg,

Line 1124: p_values => STRINGARRAY(p_user_debug));

1120: p_category => NULL);
1121:
1122: l_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_BULKLOAD_DEBUG', -- Debug Enabled :
1123: p_tokens => STRINGARRAY('DEBUG'),
1124: p_values => STRINGARRAY(p_user_debug));
1125:
1126: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1127: p_msg => l_msg,
1128: p_category => NULL);