[Home] [Help]
23: at the header level
24: 2. Other then the normal required columns, the headers inserted into FUN_BAL_HEADERS_GT table
25: must have a status of 'OK' in order for the balancing API to process the header.
26: 3. The lines inserted into FUN_BAL_LINES_GT table must have the generated column set to 'N'.
27: 4. The calling program would have to display the errors found in FUN_BAL_ERRORS_GT to the user
28: using their own FND_MESSAGES, as the message details and the context to be displayed to the
29: user are different for different calling programs. The calling probrams can use the
30: FUN_BAL_HEADERS_GT table to figure out which journals contain an error. A journal ended
31: in error would have its status set to 'ERROR'.
38: primary ledger information to balance the journal. If the ALC ledger is passed in accidentally,
39: unexpected exceptions could happen. Setup data would be derived from the primary ledger.
40:
41:
42: Possible error codes to be found in fun_bal_errors_gt table are:
43: -------------------------------------------------------------------------
44: Generic
45: =====
46: 1. FUN_BSV_INVALID
121:
122: TYPE headers_tab_type IS TABLE OF fun_bal_headers_gt%rowtype;
123: TYPE lines_tab_type IS TABLE OF fun_bal_lines_gt%rowtype;
124: TYPE results_tab_type IS TABLE OF fun_bal_results_gt%rowtype;
125: TYPE errors_tab_type IS TABLE OF fun_bal_errors_gt%rowtype;
126: TYPE inter_le_bsv_map_tab_type IS TABLE OF fun_bal_inter_bsv_map_t%rowtype;
127: TYPE intra_le_bsv_map_tab_type IS TABLE OF fun_bal_intra_bsv_map_t%rowtype;
128: --TYPE le_bsv_map_tab_type IS TABLE OF fun_bal_le_bsv_map_gt%rowtype;
129: TYPE inter_int_tab_type IS TABLE OF fun_bal_inter_int_gt%rowtype;
188: get out of it.
189: TYPE headers_tab_type IS REF CURSOR RETURN fun_bal_headers_gt%rowtype;
190: TYPE lines_tab_type IS REF CURSOR RETURN fun_bal_lines_gt%rowtype;
191: TYPE results_tab_type IS REF CURSOR RETURN fun_bal_results_gt%rowtype;
192: TYPE errors_tab_type IS REF CURSOR RETURN fun_bal_errors_gt%rowtype;
193: TYPE le_bsv_map_tab_type IS REF CURSOR RETURN fun_bal_le_bsv_map_gt%rowtype;
194: TYPE inter_int_tab_type IS REF CURSOR RETURN fun_bal_inter_int_gt%rowtype;
195: TYPE intra_int_tab_type IS REF CURSOR RETURN fun_bal_intra_int_gt%rowtype;
196: PROCEDURE auto_test1(test_csr IN test_csr_type1) IS