54:
55: IS PRAGMA AUTONOMOUS_TRANSACTION;
56:
57: BEGIN
58: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
59: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_ENTRY_HEADERS.begin', '<
60: END IF;
61:
62: UPDATE gcs_entry_headers
55: IS PRAGMA AUTONOMOUS_TRANSACTION;
56:
57: BEGIN
58: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
59: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_ENTRY_HEADERS.begin', '<
61:
62: UPDATE gcs_entry_headers
63: SET processed_run_name = p_run_name,
68: WHERE entry_id = p_entry_id;
69:
70: COMMIT;
71:
72: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
73: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_ENTRY_HEADERS.end', '<
74: END IF;
75: END update_entry_headers;
76:
69:
70: COMMIT;
71:
72: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
73: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_ENTRY_HEADERS.end', '<
75: END update_entry_headers;
76:
77: PROCEDURE submit_xml_ntf_program(p_run_name IN VARCHAR2,
83:
84: l_request_id NUMBER(15);
85:
86: BEGIN
87: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
88: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SUBMIT_XML_NTF_PROGRAM.begin', '<
89: END IF;
90:
91: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
84: l_request_id NUMBER(15);
85:
86: BEGIN
87: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
88: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SUBMIT_XML_NTF_PROGRAM.begin', '<
90:
91: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Run Name : ' || p_run_name);
87: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
88: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SUBMIT_XML_NTF_PROGRAM.begin', '<
89: END IF;
90:
91: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Run Name : ' || p_run_name);
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Consoliation Entity : ' || p_cons_entity_id);
94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Category : ' || p_category_code);
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Child Entity : ' || p_child_entity_id);
88: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SUBMIT_XML_NTF_PROGRAM.begin', '<
89: END IF;
90:
91: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Run Name : ' || p_run_name);
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Consoliation Entity : ' || p_cons_entity_id);
94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Category : ' || p_category_code);
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Child Entity : ' || p_child_entity_id);
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Run Detail ID : ' || p_run_detail_id);
89: END IF;
90:
91: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Run Name : ' || p_run_name);
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Consoliation Entity : ' || p_cons_entity_id);
94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Category : ' || p_category_code);
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Child Entity : ' || p_child_entity_id);
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Run Detail ID : ' || p_run_detail_id);
97: END IF;
90:
91: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Run Name : ' || p_run_name);
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Consoliation Entity : ' || p_cons_entity_id);
94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Category : ' || p_category_code);
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Child Entity : ' || p_child_entity_id);
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Run Detail ID : ' || p_run_detail_id);
97: END IF;
98:
91: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Run Name : ' || p_run_name);
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Consoliation Entity : ' || p_cons_entity_id);
94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Category : ' || p_category_code);
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Child Entity : ' || p_child_entity_id);
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Run Detail ID : ' || p_run_detail_id);
97: END IF;
98:
99: fnd_file.put_line(fnd_file.log, 'Within submit_xml_ntf_program');
92: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Run Name : ' || p_run_name);
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Consoliation Entity : ' || p_cons_entity_id);
94: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Category : ' || p_category_code);
95: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Child Entity : ' || p_child_entity_id);
96: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.SUBMIT_XML_NTF_PROGRAM', 'Run Detail ID : ' || p_run_detail_id);
97: END IF;
98:
99: fnd_file.put_line(fnd_file.log, 'Within submit_xml_ntf_program');
100:
111:
112: fnd_file.put_line(fnd_file.log, 'Submitted request id : ' || l_request_id);
113:
114:
115: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
116: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SUBMIT_XML_NTF_PROGRAM.end', '<
117: END IF;
118:
119: COMMIT;
112: fnd_file.put_line(fnd_file.log, 'Submitted request id : ' || l_request_id);
113:
114:
115: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
116: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.SUBMIT_XML_NTF_PROGRAM.end', '<
118:
119: COMMIT;
120:
130: l_stat_entry_id NUMBER(15);
131:
132: BEGIN
133:
134: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_MODULE.begin', '<
136: END IF;
137: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
138: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Module Code : ' || module_code);
131:
132: BEGIN
133:
134: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_MODULE.begin', '<
137: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
138: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Module Code : ' || module_code);
139: END IF;
133:
134: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_MODULE.begin', '<
136: END IF;
137: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
138: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Module Code : ' || module_code);
139: END IF;
140:
141: IF (module_code = 'TRANSLATION') THEN
134: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_MODULE.begin', '<
136: END IF;
137: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
138: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Module Code : ' || module_code);
139: END IF;
140:
141: IF (module_code = 'TRANSLATION') THEN
142: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
138: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Module Code : ' || module_code);
139: END IF;
140:
141: IF (module_code = 'TRANSLATION') THEN
142: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entry ID : ' || p_parameter_list.entry_id);
144: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship : ' || p_parameter_list.cons_relationship_id);
145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Xlate Mode : ' || p_parameter_list.xlate_mode);
146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
139: END IF;
140:
141: IF (module_code = 'TRANSLATION') THEN
142: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entry ID : ' || p_parameter_list.entry_id);
144: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship : ' || p_parameter_list.cons_relationship_id);
145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Xlate Mode : ' || p_parameter_list.xlate_mode);
146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
147: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Xlate Entry ID : ' || p_parameter_list.xlate_entry_id);
140:
141: IF (module_code = 'TRANSLATION') THEN
142: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entry ID : ' || p_parameter_list.entry_id);
144: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship : ' || p_parameter_list.cons_relationship_id);
145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Xlate Mode : ' || p_parameter_list.xlate_mode);
146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
147: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Xlate Entry ID : ' || p_parameter_list.xlate_entry_id);
148: END IF;
141: IF (module_code = 'TRANSLATION') THEN
142: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entry ID : ' || p_parameter_list.entry_id);
144: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship : ' || p_parameter_list.cons_relationship_id);
145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Xlate Mode : ' || p_parameter_list.xlate_mode);
146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
147: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Xlate Entry ID : ' || p_parameter_list.xlate_entry_id);
148: END IF;
149:
142: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entry ID : ' || p_parameter_list.entry_id);
144: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship : ' || p_parameter_list.cons_relationship_id);
145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Xlate Mode : ' || p_parameter_list.xlate_mode);
146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
147: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Xlate Entry ID : ' || p_parameter_list.xlate_entry_id);
148: END IF;
149:
150: BEGIN
143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entry ID : ' || p_parameter_list.entry_id);
144: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship : ' || p_parameter_list.cons_relationship_id);
145: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Xlate Mode : ' || p_parameter_list.xlate_mode);
146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
147: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Xlate Entry ID : ' || p_parameter_list.xlate_entry_id);
148: END IF;
149:
150: BEGIN
151: gcs_translation_pkg.translate(p_parameter_list.errbuf,
172: p_bp_request_error_code => NVL(p_parameter_list.errbuf, 'COMPLETED'));
173:
174: ELSIF (module_code = 'DATAPREPARATION') THEN
175:
176: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.child_entity_id);
179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
180: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
173:
174: ELSIF (module_code = 'DATAPREPARATION') THEN
175:
176: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.child_entity_id);
179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
180: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
181: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cons Relationship : ' || p_parameter_list.cons_relationship_id);
174: ELSIF (module_code = 'DATAPREPARATION') THEN
175:
176: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.child_entity_id);
179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
180: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
181: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cons Relationship : ' || p_parameter_list.cons_relationship_id);
182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
175:
176: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.child_entity_id);
179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
180: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
181: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cons Relationship : ' || p_parameter_list.cons_relationship_id);
182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
183: END IF;
176: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.child_entity_id);
179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
180: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
181: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cons Relationship : ' || p_parameter_list.cons_relationship_id);
182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
183: END IF;
184:
177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.child_entity_id);
179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
180: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
181: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cons Relationship : ' || p_parameter_list.cons_relationship_id);
182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
183: END IF;
184:
185: gcs_data_prep_pkg.gcs_main_data_prep (
178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.child_entity_id);
179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
180: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
181: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cons Relationship : ' || p_parameter_list.cons_relationship_id);
182: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
183: END IF;
184:
185: gcs_data_prep_pkg.gcs_main_data_prep (
186: x_errbuf => p_parameter_list.errbuf,
196: --Bugfix 3666700: Removed call to insert intercompany transactions into temp table
197: --Bugfix 4307627: Removed call to update status for data preparation
198:
199: ELSIF (module_code = 'BALANCES_PROCESSOR') THEN
200: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
201: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period ID : ' || p_parameter_list.cal_period_id);
203: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Category Code : ' || p_parameter_list.category_code);
204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy Id : ' || p_parameter_list.hierarchy_id);
197: --Bugfix 4307627: Removed call to update status for data preparation
198:
199: ELSIF (module_code = 'BALANCES_PROCESSOR') THEN
200: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
201: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period ID : ' || p_parameter_list.cal_period_id);
203: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Category Code : ' || p_parameter_list.category_code);
204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy Id : ' || p_parameter_list.hierarchy_id);
205: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
198:
199: ELSIF (module_code = 'BALANCES_PROCESSOR') THEN
200: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
201: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period ID : ' || p_parameter_list.cal_period_id);
203: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Category Code : ' || p_parameter_list.category_code);
204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy Id : ' || p_parameter_list.hierarchy_id);
205: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Consolidation Entity ID : ' || p_parameter_list.cons_entity_id);
199: ELSIF (module_code = 'BALANCES_PROCESSOR') THEN
200: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
201: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period ID : ' || p_parameter_list.cal_period_id);
203: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Category Code : ' || p_parameter_list.category_code);
204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy Id : ' || p_parameter_list.hierarchy_id);
205: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Consolidation Entity ID : ' || p_parameter_list.cons_entity_id);
207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity ID : ' || p_parameter_list.child_entity_id);
200: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
201: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period ID : ' || p_parameter_list.cal_period_id);
203: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Category Code : ' || p_parameter_list.category_code);
204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy Id : ' || p_parameter_list.hierarchy_id);
205: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Consolidation Entity ID : ' || p_parameter_list.cons_entity_id);
207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity ID : ' || p_parameter_list.child_entity_id);
208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Undo Prior : ' || p_parameter_list.bp_undo_prior);
201: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period ID : ' || p_parameter_list.cal_period_id);
203: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Category Code : ' || p_parameter_list.category_code);
204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy Id : ' || p_parameter_list.hierarchy_id);
205: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Consolidation Entity ID : ' || p_parameter_list.cons_entity_id);
207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity ID : ' || p_parameter_list.child_entity_id);
208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Undo Prior : ' || p_parameter_list.bp_undo_prior);
209: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail ID : ' || p_parameter_list.run_detail_id);
202: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period ID : ' || p_parameter_list.cal_period_id);
203: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Category Code : ' || p_parameter_list.category_code);
204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy Id : ' || p_parameter_list.hierarchy_id);
205: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Consolidation Entity ID : ' || p_parameter_list.cons_entity_id);
207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity ID : ' || p_parameter_list.child_entity_id);
208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Undo Prior : ' || p_parameter_list.bp_undo_prior);
209: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail ID : ' || p_parameter_list.run_detail_id);
210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Post Xlate : ' || p_parameter_list.bp_post_xlate);
203: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Category Code : ' || p_parameter_list.category_code);
204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy Id : ' || p_parameter_list.hierarchy_id);
205: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Consolidation Entity ID : ' || p_parameter_list.cons_entity_id);
207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity ID : ' || p_parameter_list.child_entity_id);
208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Undo Prior : ' || p_parameter_list.bp_undo_prior);
209: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail ID : ' || p_parameter_list.run_detail_id);
210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Post Xlate : ' || p_parameter_list.bp_post_xlate);
211: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entry ID : ' || p_parameter_list.entry_id);
204: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy Id : ' || p_parameter_list.hierarchy_id);
205: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Consolidation Entity ID : ' || p_parameter_list.cons_entity_id);
207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity ID : ' || p_parameter_list.child_entity_id);
208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Undo Prior : ' || p_parameter_list.bp_undo_prior);
209: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail ID : ' || p_parameter_list.run_detail_id);
210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Post Xlate : ' || p_parameter_list.bp_post_xlate);
211: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entry ID : ' || p_parameter_list.entry_id);
212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Mode : ' || p_parameter_list.bp_mode);
205: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Consolidation Entity ID : ' || p_parameter_list.cons_entity_id);
207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity ID : ' || p_parameter_list.child_entity_id);
208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Undo Prior : ' || p_parameter_list.bp_undo_prior);
209: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail ID : ' || p_parameter_list.run_detail_id);
210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Post Xlate : ' || p_parameter_list.bp_post_xlate);
211: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entry ID : ' || p_parameter_list.entry_id);
212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Mode : ' || p_parameter_list.bp_mode);
213: END IF;
206: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Consolidation Entity ID : ' || p_parameter_list.cons_entity_id);
207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity ID : ' || p_parameter_list.child_entity_id);
208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Undo Prior : ' || p_parameter_list.bp_undo_prior);
209: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail ID : ' || p_parameter_list.run_detail_id);
210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Post Xlate : ' || p_parameter_list.bp_post_xlate);
211: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entry ID : ' || p_parameter_list.entry_id);
212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Mode : ' || p_parameter_list.bp_mode);
213: END IF;
214:
207: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity ID : ' || p_parameter_list.child_entity_id);
208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Undo Prior : ' || p_parameter_list.bp_undo_prior);
209: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail ID : ' || p_parameter_list.run_detail_id);
210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Post Xlate : ' || p_parameter_list.bp_post_xlate);
211: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entry ID : ' || p_parameter_list.entry_id);
212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Mode : ' || p_parameter_list.bp_mode);
213: END IF;
214:
215: gcs_dyn_fem_posting_pkg.gcs_fem_post(
208: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Undo Prior : ' || p_parameter_list.bp_undo_prior);
209: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail ID : ' || p_parameter_list.run_detail_id);
210: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Post Xlate : ' || p_parameter_list.bp_post_xlate);
211: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entry ID : ' || p_parameter_list.entry_id);
212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'BP Mode : ' || p_parameter_list.bp_mode);
213: END IF;
214:
215: gcs_dyn_fem_posting_pkg.gcs_fem_post(
216: errbuf => p_parameter_list.errbuf,
229: p_mode => p_parameter_list.bp_mode,
230: p_hier_dataset_code => p_parameter_list.hierarchy_dataset_code);
231: ELSIF (module_code = 'AGGREGATION') THEN
232:
233: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.cons_entity_id);
236: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
230: p_hier_dataset_code => p_parameter_list.hierarchy_dataset_code);
231: ELSIF (module_code = 'AGGREGATION') THEN
232:
233: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.cons_entity_id);
236: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
238: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cons Relationship : ' || p_parameter_list.cons_relationship_id);
231: ELSIF (module_code = 'AGGREGATION') THEN
232:
233: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.cons_entity_id);
236: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
238: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cons Relationship : ' || p_parameter_list.cons_relationship_id);
239: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
232:
233: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.cons_entity_id);
236: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
238: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cons Relationship : ' || p_parameter_list.cons_relationship_id);
239: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'End Date : ' || p_parameter_list.period_end_date);
233: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.cons_entity_id);
236: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
238: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cons Relationship : ' || p_parameter_list.cons_relationship_id);
239: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'End Date : ' || p_parameter_list.period_end_date);
241: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Stat Required : ' || p_parameter_list.stat_required);
234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.cons_entity_id);
236: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
238: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cons Relationship : ' || p_parameter_list.cons_relationship_id);
239: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'End Date : ' || p_parameter_list.period_end_date);
241: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Stat Required : ' || p_parameter_list.stat_required);
242: END IF;
235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.cons_entity_id);
236: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
238: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cons Relationship : ' || p_parameter_list.cons_relationship_id);
239: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'End Date : ' || p_parameter_list.period_end_date);
241: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Stat Required : ' || p_parameter_list.stat_required);
242: END IF;
243:
236: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
238: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cons Relationship : ' || p_parameter_list.cons_relationship_id);
239: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'End Date : ' || p_parameter_list.period_end_date);
241: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Stat Required : ' || p_parameter_list.stat_required);
242: END IF;
243:
244: gcs_aggregation_pkg.aggregate( p_run_detail_id => p_parameter_list.run_detail_id,
237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Detail : ' || p_parameter_list.run_detail_id);
238: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cons Relationship : ' || p_parameter_list.cons_relationship_id);
239: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'End Date : ' || p_parameter_list.period_end_date);
241: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Stat Required : ' || p_parameter_list.stat_required);
242: END IF;
243:
244: gcs_aggregation_pkg.aggregate( p_run_detail_id => p_parameter_list.run_detail_id,
245: p_hierarchy_id => p_parameter_list.hierarchy_id,
259: p_bp_request_error_code => NVL(p_parameter_list.errbuf, 'COMPLETED'));
260:
261: ELSIF (module_code = 'INTERCOMPANY') THEN
262:
263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
265: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.child_entity_id);
266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Intercompany Mode : ' || p_parameter_list.intercompany_mode);
260:
261: ELSIF (module_code = 'INTERCOMPANY') THEN
262:
263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
265: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.child_entity_id);
266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Intercompany Mode : ' || p_parameter_list.intercompany_mode);
268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Currency Code : ' || p_parameter_list.currency_code);
261: ELSIF (module_code = 'INTERCOMPANY') THEN
262:
263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
265: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.child_entity_id);
266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Intercompany Mode : ' || p_parameter_list.intercompany_mode);
268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Currency Code : ' || p_parameter_list.currency_code);
269: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Identifier : ' || p_parameter_list.run_name);
262:
263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
265: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.child_entity_id);
266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Intercompany Mode : ' || p_parameter_list.intercompany_mode);
268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Currency Code : ' || p_parameter_list.currency_code);
269: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Identifier : ' || p_parameter_list.run_name);
270: END IF;
263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
265: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.child_entity_id);
266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Intercompany Mode : ' || p_parameter_list.intercompany_mode);
268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Currency Code : ' || p_parameter_list.currency_code);
269: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Identifier : ' || p_parameter_list.run_name);
270: END IF;
271:
264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
265: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.child_entity_id);
266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Intercompany Mode : ' || p_parameter_list.intercompany_mode);
268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Currency Code : ' || p_parameter_list.currency_code);
269: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Identifier : ' || p_parameter_list.run_name);
270: END IF;
271:
272:
265: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Entity : ' || p_parameter_list.child_entity_id);
266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Cal Period : ' || p_parameter_list.cal_period_id);
267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Intercompany Mode : ' || p_parameter_list.intercompany_mode);
268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Currency Code : ' || p_parameter_list.currency_code);
269: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Identifier : ' || p_parameter_list.run_name);
270: END IF;
271:
272:
273: gcs_interco_processing_pkg.interco_process_main
284: x_retcode => p_parameter_list.retcode);
285:
286: ELSIF (module_code = 'RULES_PROCESSOR') THEN
287:
288: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Event Category : ' || p_parameter_list.rp_parameters.eventCategory);
290: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Data Set Code : ' || p_parameter_list.rp_parameters.datasetCode);
291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Parent Entity : ' || p_parameter_list.rp_parameters.parentEntity);
292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.rp_parameters.childEntity);
285:
286: ELSIF (module_code = 'RULES_PROCESSOR') THEN
287:
288: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Event Category : ' || p_parameter_list.rp_parameters.eventCategory);
290: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Data Set Code : ' || p_parameter_list.rp_parameters.datasetCode);
291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Parent Entity : ' || p_parameter_list.rp_parameters.parentEntity);
292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.rp_parameters.childEntity);
293: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Elim Entity : ' || p_parameter_list.rp_parameters.elimsEntity);
286: ELSIF (module_code = 'RULES_PROCESSOR') THEN
287:
288: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Event Category : ' || p_parameter_list.rp_parameters.eventCategory);
290: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Data Set Code : ' || p_parameter_list.rp_parameters.datasetCode);
291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Parent Entity : ' || p_parameter_list.rp_parameters.parentEntity);
292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.rp_parameters.childEntity);
293: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Elim Entity : ' || p_parameter_list.rp_parameters.elimsEntity);
294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Currency : ' || p_parameter_list.rp_parameters.currencyCode);
287:
288: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Event Category : ' || p_parameter_list.rp_parameters.eventCategory);
290: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Data Set Code : ' || p_parameter_list.rp_parameters.datasetCode);
291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Parent Entity : ' || p_parameter_list.rp_parameters.parentEntity);
292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.rp_parameters.childEntity);
293: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Elim Entity : ' || p_parameter_list.rp_parameters.elimsEntity);
294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Currency : ' || p_parameter_list.rp_parameters.currencyCode);
295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Event Type : ' || p_parameter_list.rp_parameters.eventType);
288: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Event Category : ' || p_parameter_list.rp_parameters.eventCategory);
290: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Data Set Code : ' || p_parameter_list.rp_parameters.datasetCode);
291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Parent Entity : ' || p_parameter_list.rp_parameters.parentEntity);
292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.rp_parameters.childEntity);
293: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Elim Entity : ' || p_parameter_list.rp_parameters.elimsEntity);
294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Currency : ' || p_parameter_list.rp_parameters.currencyCode);
295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Event Type : ' || p_parameter_list.rp_parameters.eventType);
296: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Rule Id : ' || p_parameter_list.elim_rule_id);
289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Event Category : ' || p_parameter_list.rp_parameters.eventCategory);
290: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Data Set Code : ' || p_parameter_list.rp_parameters.datasetCode);
291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Parent Entity : ' || p_parameter_list.rp_parameters.parentEntity);
292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.rp_parameters.childEntity);
293: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Elim Entity : ' || p_parameter_list.rp_parameters.elimsEntity);
294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Currency : ' || p_parameter_list.rp_parameters.currencyCode);
295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Event Type : ' || p_parameter_list.rp_parameters.eventType);
296: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Rule Id : ' || p_parameter_list.elim_rule_id);
297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship : ' || p_parameter_list.rp_parameters.relationship);
290: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Data Set Code : ' || p_parameter_list.rp_parameters.datasetCode);
291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Parent Entity : ' || p_parameter_list.rp_parameters.parentEntity);
292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.rp_parameters.childEntity);
293: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Elim Entity : ' || p_parameter_list.rp_parameters.elimsEntity);
294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Currency : ' || p_parameter_list.rp_parameters.currencyCode);
295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Event Type : ' || p_parameter_list.rp_parameters.eventType);
296: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Rule Id : ' || p_parameter_list.elim_rule_id);
297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship : ' || p_parameter_list.rp_parameters.relationship);
298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'To Percent : ' || p_parameter_list.rp_rule_data.toPercent);
291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Parent Entity : ' || p_parameter_list.rp_parameters.parentEntity);
292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.rp_parameters.childEntity);
293: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Elim Entity : ' || p_parameter_list.rp_parameters.elimsEntity);
294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Currency : ' || p_parameter_list.rp_parameters.currencyCode);
295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Event Type : ' || p_parameter_list.rp_parameters.eventType);
296: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Rule Id : ' || p_parameter_list.elim_rule_id);
297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship : ' || p_parameter_list.rp_parameters.relationship);
298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'To Percent : ' || p_parameter_list.rp_rule_data.toPercent);
299: END IF;
292: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.rp_parameters.childEntity);
293: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Elim Entity : ' || p_parameter_list.rp_parameters.elimsEntity);
294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Currency : ' || p_parameter_list.rp_parameters.currencyCode);
295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Event Type : ' || p_parameter_list.rp_parameters.eventType);
296: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Rule Id : ' || p_parameter_list.elim_rule_id);
297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship : ' || p_parameter_list.rp_parameters.relationship);
298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'To Percent : ' || p_parameter_list.rp_rule_data.toPercent);
299: END IF;
300:
293: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Elim Entity : ' || p_parameter_list.rp_parameters.elimsEntity);
294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Currency : ' || p_parameter_list.rp_parameters.currencyCode);
295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Event Type : ' || p_parameter_list.rp_parameters.eventType);
296: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Rule Id : ' || p_parameter_list.elim_rule_id);
297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship : ' || p_parameter_list.rp_parameters.relationship);
298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'To Percent : ' || p_parameter_list.rp_rule_data.toPercent);
299: END IF;
300:
301: p_parameter_list.retcode := gcs_rules_processor.process_rule(
294: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Currency : ' || p_parameter_list.rp_parameters.currencyCode);
295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Event Type : ' || p_parameter_list.rp_parameters.eventType);
296: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Rule Id : ' || p_parameter_list.elim_rule_id);
297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship : ' || p_parameter_list.rp_parameters.relationship);
298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'To Percent : ' || p_parameter_list.rp_rule_data.toPercent);
299: END IF;
300:
301: p_parameter_list.retcode := gcs_rules_processor.process_rule(
302: p_rule_id => p_parameter_list.elim_rule_id,
307: --Bugfix 3920448 : Remove update of run details for fules processor
308:
309: ELSIF (module_code = 'PERIOD_INITIALIZATION') THEN
310:
311: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
312: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
313: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.child_entity_id);
315: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Calendar Period : ' || p_parameter_list.cal_period_id);
308:
309: ELSIF (module_code = 'PERIOD_INITIALIZATION') THEN
310:
311: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
312: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
313: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.child_entity_id);
315: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Calendar Period : ' || p_parameter_list.cal_period_id);
316: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
309: ELSIF (module_code = 'PERIOD_INITIALIZATION') THEN
310:
311: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
312: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
313: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.child_entity_id);
315: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Calendar Period : ' || p_parameter_list.cal_period_id);
316: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
317: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship Id : ' || p_parameter_list.cons_relationship_id);
310:
311: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
312: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
313: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.child_entity_id);
315: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Calendar Period : ' || p_parameter_list.cal_period_id);
316: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
317: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship Id : ' || p_parameter_list.cons_relationship_id);
318: END IF;
311: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
312: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
313: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.child_entity_id);
315: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Calendar Period : ' || p_parameter_list.cal_period_id);
316: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
317: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship Id : ' || p_parameter_list.cons_relationship_id);
318: END IF;
319:
312: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
313: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.child_entity_id);
315: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Calendar Period : ' || p_parameter_list.cal_period_id);
316: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
317: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship Id : ' || p_parameter_list.cons_relationship_id);
318: END IF;
319:
320: gcs_period_init_pkg.create_period_init_entries(
313: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Child Entity : ' || p_parameter_list.child_entity_id);
315: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Calendar Period : ' || p_parameter_list.cal_period_id);
316: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
317: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Relationship Id : ' || p_parameter_list.cons_relationship_id);
318: END IF;
319:
320: gcs_period_init_pkg.create_period_init_entries(
321: p_errbuf => p_parameter_list.errbuf,
329: p_cons_entity_id => p_parameter_list.cons_entity_id,
330: p_translation_required => p_parameter_list.bp_post_xlate
331: );
332: ELSIF (module_code = 'UNDO_ELIMINATIONS') THEN
333: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
334: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
335: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
336: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Calendar Period : ' || p_parameter_list.cal_period_id);
337: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
330: p_translation_required => p_parameter_list.bp_post_xlate
331: );
332: ELSIF (module_code = 'UNDO_ELIMINATIONS') THEN
333: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
334: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
335: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
336: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Calendar Period : ' || p_parameter_list.cal_period_id);
337: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
338: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Undo Entity Type : ' || p_parameter_list.undo_entity_type);
331: );
332: ELSIF (module_code = 'UNDO_ELIMINATIONS') THEN
333: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
334: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
335: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
336: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Calendar Period : ' || p_parameter_list.cal_period_id);
337: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
338: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Undo Entity Type : ' || p_parameter_list.undo_entity_type);
339: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Undo Entity ID : ' || p_parameter_list.undo_entity_id);
332: ELSIF (module_code = 'UNDO_ELIMINATIONS') THEN
333: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
334: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
335: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
336: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Calendar Period : ' || p_parameter_list.cal_period_id);
337: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
338: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Undo Entity Type : ' || p_parameter_list.undo_entity_type);
339: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Undo Entity ID : ' || p_parameter_list.undo_entity_id);
340:
333: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
334: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
335: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
336: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Calendar Period : ' || p_parameter_list.cal_period_id);
337: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
338: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Undo Entity Type : ' || p_parameter_list.undo_entity_type);
339: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Undo Entity ID : ' || p_parameter_list.undo_entity_id);
340:
341: END IF;
334: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Run Name : ' || p_parameter_list.run_name);
335: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
336: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Calendar Period : ' || p_parameter_list.cal_period_id);
337: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
338: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Undo Entity Type : ' || p_parameter_list.undo_entity_type);
339: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Undo Entity ID : ' || p_parameter_list.undo_entity_id);
340:
341: END IF;
342: gcs_dyn_fem_posting_pkg.gcs_fem_delete(
335: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Hierarchy : ' || p_parameter_list.hierarchy_id);
336: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Calendar Period : ' || p_parameter_list.cal_period_id);
337: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Balance Type Code : ' || p_parameter_list.balance_type_code);
338: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Undo Entity Type : ' || p_parameter_list.undo_entity_type);
339: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXECUTE_MODULE', 'Undo Entity ID : ' || p_parameter_list.undo_entity_id);
340:
341: END IF;
342: gcs_dyn_fem_posting_pkg.gcs_fem_delete(
343: errbuf => p_parameter_list.errbuf,
352: END IF;
353:
354: COMMIT;
355:
356: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
357: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_MODULE.end', '<
358: END IF;
359:
360: END execute_module;
353:
354: COMMIT;
355:
356: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
357: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_MODULE.end', '<
359:
360: END execute_module;
361:
380: l_entry_id NUMBER(15);
381: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;
382:
383: BEGIN
384: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
385: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.BALANCES_PROCESSOR.begin', '<
386: END IF;
387:
388: l_parameter_list.category_code := WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid, 'CATEGORY_CODE', FALSE);
381: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;
382:
383: BEGIN
384: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
385: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.BALANCES_PROCESSOR.begin', '<
387:
388: l_parameter_list.category_code := WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid, 'CATEGORY_CODE', FALSE);
389: l_parameter_list.bp_post_xlate := 'N';
388: l_parameter_list.category_code := WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid, 'CATEGORY_CODE', FALSE);
389: l_parameter_list.bp_post_xlate := 'N';
390: l_parameter_list.bp_mode := 'I';
391:
392: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.BALANCES_PROCESSOR', 'Category Code : ' || l_parameter_list.category_code);
394: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.BALANCES_PROCESSOR', 'Post Xlate : ' || l_parameter_list.bp_post_xlate);
395: END IF;
396:
389: l_parameter_list.bp_post_xlate := 'N';
390: l_parameter_list.bp_mode := 'I';
391:
392: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.BALANCES_PROCESSOR', 'Category Code : ' || l_parameter_list.category_code);
394: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.BALANCES_PROCESSOR', 'Post Xlate : ' || l_parameter_list.bp_post_xlate);
395: END IF;
396:
397: IF (itemtype = 'GCSOPRWF') THEN
390: l_parameter_list.bp_mode := 'I';
391:
392: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
393: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.BALANCES_PROCESSOR', 'Category Code : ' || l_parameter_list.category_code);
394: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.BALANCES_PROCESSOR', 'Post Xlate : ' || l_parameter_list.bp_post_xlate);
395: END IF;
396:
397: IF (itemtype = 'GCSOPRWF') THEN
398:
462: AND run_name = cons_entity_wf_info.run_identifier
463: AND child_entity_id IS NOT NULL
464: AND category_code = l_parameter_list.category_code;
465:
466: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
467: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.BALANCES_PROCESSOR', 'Consolidation Rows to Process : ' || l_rows_to_process);
468: END IF;
469:
470: END IF;
463: AND child_entity_id IS NOT NULL
464: AND category_code = l_parameter_list.category_code;
465:
466: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
467: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.BALANCES_PROCESSOR', 'Consolidation Rows to Process : ' || l_rows_to_process);
468: END IF;
469:
470: END IF;
471:
484: END IF;
485:
486: result := 'COMPLETE';
487:
488: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
489: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.BALANCES_PROCESSOR.end', '<
490: END IF;
491:
492: END balances_processor;
485:
486: result := 'COMPLETE';
487:
488: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
489: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.BALANCES_PROCESSOR.end', '<
491:
492: END balances_processor;
493:
508: l_child_entity_id NUMBER(15);
509: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;
510: BEGIN
511:
512: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
513: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_ADJ_REQUIRED.begin', '<
514: END IF;
515:
516:
509: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;
510: BEGIN
511:
512: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
513: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_ADJ_REQUIRED.begin', '<
515:
516:
517: IF (itemtype = 'GCSOPRWF') THEN
543: IF (l_category_count > 0) THEN
544: IF ((cons_entity_wf_info.prior_run_identifier <> 'NO_PRIOR_RUN') AND (cons_entity_wf_info.process_method = 'INCREMENTAL')) THEN
545: BEGIN
546: -- Check if any impact occurred
547: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_ADJ_REQUIRED', '<
549: END IF;
550:
551: IF (itemtype = 'GCSOPRWF') THEN
544: IF ((cons_entity_wf_info.prior_run_identifier <> 'NO_PRIOR_RUN') AND (cons_entity_wf_info.process_method = 'INCREMENTAL')) THEN
545: BEGIN
546: -- Check if any impact occurred
547: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
548: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_ADJ_REQUIRED', '<
550:
551: IF (itemtype = 'GCSOPRWF') THEN
552: SELECT 'N'
564: AND run_entity_id = cons_entity_wf_info.consolidation_entity
565: AND impacted_flag = 'Y';
566: END IF;
567:
568: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
569: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_ADJ_REQUIRED', 'Found an Impact');
570: END IF;
571:
572: result := 'COMPLETE:T';
565: AND impacted_flag = 'Y';
566: END IF;
567:
568: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
569: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_ADJ_REQUIRED', 'Found an Impact');
570: END IF;
571:
572: result := 'COMPLETE:T';
573: --Bugfix 3818829 : Must undo all prior eliminations
608: result := 'COMPLETE:T';
609: END IF;
610: END IF;
611:
612: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
613: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_ADJ_REQUIRED.end', '<
614: END IF;
615:
616: END check_adj_required;
609: END IF;
610: END IF;
611:
612: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
613: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_ADJ_REQUIRED.end', '<
615:
616: END check_adj_required;
617:
627: l_max_category_number NUMBER(15) := NULL;
628:
629: BEGIN
630:
631: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
632: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CATEGORY_EXISTS.begin', '<
633: END IF;
634:
635: l_curr_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
628:
629: BEGIN
630:
631: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
632: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CATEGORY_EXISTS.begin', '<
634:
635: l_curr_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
636: l_max_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'NUM_OF_CATEGORIES', FALSE);
635: l_curr_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
636: l_max_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'NUM_OF_CATEGORIES', FALSE);
637: l_curr_category_number := l_curr_category_number + 1;
638:
639: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
640: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.CATEGORY_EXISTS', 'Current Category Number : ' || l_curr_category_number);
641: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.CATEGORY_EXISTS', 'Max Category Number : ' || l_max_category_number);
642: END IF;
643:
636: l_max_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'NUM_OF_CATEGORIES', FALSE);
637: l_curr_category_number := l_curr_category_number + 1;
638:
639: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
640: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.CATEGORY_EXISTS', 'Current Category Number : ' || l_curr_category_number);
641: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.CATEGORY_EXISTS', 'Max Category Number : ' || l_max_category_number);
642: END IF;
643:
644: IF (l_curr_category_number > l_max_category_number) THEN
637: l_curr_category_number := l_curr_category_number + 1;
638:
639: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
640: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.CATEGORY_EXISTS', 'Current Category Number : ' || l_curr_category_number);
641: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.CATEGORY_EXISTS', 'Max Category Number : ' || l_max_category_number);
642: END IF;
643:
644: IF (l_curr_category_number > l_max_category_number) THEN
645: result := 'COMPLETE:F';
647: WF_ENGINE.SetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', l_curr_category_number);
648: result := 'COMPLETE:T';
649: END IF;
650:
651: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
652: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CATEGORY_EXISTS.end', '<
653: END IF;
654: END category_exists;
655:
648: result := 'COMPLETE:T';
649: END IF;
650:
651: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
652: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CATEGORY_EXISTS.end', '<
654: END category_exists;
655:
656: PROCEDURE check_max_category( itemtype IN VARCHAR2,
664: l_max_category_number NUMBER(15) := NULL;
665:
666: BEGIN
667:
668: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
669: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_MAX_CATEGORY.begin', '<
670: END IF;
671:
672: l_curr_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
665:
666: BEGIN
667:
668: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
669: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_MAX_CATEGORY.begin', '<
671:
672: l_curr_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
673: l_max_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'NUM_OF_CATEGORIES', FALSE);
671:
672: l_curr_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
673: l_max_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'NUM_OF_CATEGORIES', FALSE);
674:
675: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
676: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.CHECK_MAX_CATEGORY', 'Current Category Number : ' || l_curr_category_number);
677: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.CHECK_MAX_CATEGORY', 'Max Category Number : ' || l_max_category_number);
678: END IF;
679:
672: l_curr_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
673: l_max_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'NUM_OF_CATEGORIES', FALSE);
674:
675: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
676: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.CHECK_MAX_CATEGORY', 'Current Category Number : ' || l_curr_category_number);
677: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.CHECK_MAX_CATEGORY', 'Max Category Number : ' || l_max_category_number);
678: END IF;
679:
680: IF (l_curr_category_number = l_max_category_number) THEN
673: l_max_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'NUM_OF_CATEGORIES', FALSE);
674:
675: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
676: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.CHECK_MAX_CATEGORY', 'Current Category Number : ' || l_curr_category_number);
677: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.CHECK_MAX_CATEGORY', 'Max Category Number : ' || l_max_category_number);
678: END IF;
679:
680: IF (l_curr_category_number = l_max_category_number) THEN
681: result := 'COMPLETE:F';
682: ELSE
683: result := 'COMPLETE:T';
684: END IF;
685:
686: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
687: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_MAX_CATEGORY.end', '<
688: END IF;
689:
690: END check_max_category;
683: result := 'COMPLETE:T';
684: END IF;
685:
686: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
687: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CHECK_MAX_CATEGORY.end', '<
689:
690: END check_max_category;
691:
772: AND NVL(disabled_cal_period_id - 1, NVL(geh.end_cal_period_id, p_cal_period_id))
773: AND 'N' = DECODE(geh.start_cal_period_id, geh.end_cal_period_id, geh.disabled_flag, 'N');
774:
775: BEGIN
776: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
777: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXTRACT_MANUAL_ADJ.begin', '<
778: END IF;
779:
780: l_curr_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
773: AND 'N' = DECODE(geh.start_cal_period_id, geh.end_cal_period_id, geh.disabled_flag, 'N');
774:
775: BEGIN
776: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
777: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXTRACT_MANUAL_ADJ.begin', '<
779:
780: l_curr_category_number := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
781:
815: END;
816: END IF;
817: END IF;
818:
819: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
820: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXTRACT_MANUAL_ADJ', 'Category Code : ' || l_category_code);
821: END IF;
822:
823: IF (l_category_code = 'ACQ_DISP') THEN
816: END IF;
817: END IF;
818:
819: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
820: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.EXTRACT_MANUAL_ADJ', 'Category Code : ' || l_category_code);
821: END IF;
822:
823: IF (l_category_code = 'ACQ_DISP') THEN
824:
884: END LOOP;
885: END IF;
886:
887: result := 'COMPLETE';
888: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
889: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXTRACT_MANUAL_ADJ.end', '<
890: END IF;
891:
892: END extract_manual_adj;
885: END IF;
886:
887: result := 'COMPLETE';
888: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
889: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXTRACT_MANUAL_ADJ.end', '<
891:
892: END extract_manual_adj;
893:
958: --Bugfix 5287762: Check if there is data to translate prior to running translation
959: l_translation_req_flag VARCHAR2(1) := 'Y';
960:
961: BEGIN
962: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
963: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_TRANSLATION.begin', '<
964: END IF;
965:
966: IF (itemtype = 'GCSOPRWF') THEN
959: l_translation_req_flag VARCHAR2(1) := 'Y';
960:
961: BEGIN
962: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
963: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_TRANSLATION.begin', '<
965:
966: IF (itemtype = 'GCSOPRWF') THEN
967: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,
1039: -- p_run_detail_id => l_parameter_list.run_detail_id);
1040:
1041: result := 'COMPLETE';
1042:
1043: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1044: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_TRANSLATION.end', '<
1045: END IF;
1046:
1047: END execute_translation;
1040:
1041: result := 'COMPLETE';
1042:
1043: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1044: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.EXECUTE_TRANSLATION.end', '<
1046:
1047: END execute_translation;
1048:
1059: cons_entity_wf_info gcs_cons_eng_utility_pkg.r_cons_entity_wf_info;
1060: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;
1061:
1062: BEGIN
1063: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1064: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PROCESS_STATUS.begin', '<
1065: END IF;
1066:
1067: IF (itemtype = 'GCSOPRWF') THEN
1060: oper_entity_wf_info gcs_cons_eng_utility_pkg.r_oper_entity_wf_info;
1061:
1062: BEGIN
1063: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1064: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PROCESS_STATUS.begin', '<
1066:
1067: IF (itemtype = 'GCSOPRWF') THEN
1068: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,
1077:
1078: l_category_code := WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid, 'CATEGORY_CODE', FALSE);
1079: l_status_code := WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid, 'STATUS_CODE', FALSE);
1080:
1081: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1082: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PROCESS_STATUS', 'Category Code : ' || l_category_code);
1083: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PROCESS_STATUS', 'Item Type : ' || itemtype);
1084: END IF;
1085:
1078: l_category_code := WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid, 'CATEGORY_CODE', FALSE);
1079: l_status_code := WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid, 'STATUS_CODE', FALSE);
1080:
1081: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1082: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PROCESS_STATUS', 'Category Code : ' || l_category_code);
1083: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PROCESS_STATUS', 'Item Type : ' || itemtype);
1084: END IF;
1085:
1086: IF (l_category_code = 'DATAPREPARATION') THEN
1079: l_status_code := WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid, 'STATUS_CODE', FALSE);
1080:
1081: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1082: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PROCESS_STATUS', 'Category Code : ' || l_category_code);
1083: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PROCESS_STATUS', 'Item Type : ' || itemtype);
1084: END IF;
1085:
1086: IF (l_category_code = 'DATAPREPARATION') THEN
1087:
1100: l_category_code := gcs_categories_pkg.g_cons_category_info(l_curr_category_num).category_code;
1101: ELSE
1102: l_category_code := gcs_categories_pkg.g_oper_category_info(l_curr_category_num).category_code;
1103: END IF;
1104: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1105: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PROCESS_STATUS', 'Actual Category Code : ' || l_category_code);
1106: END IF;
1107: gcs_cons_eng_run_dtls_pkg.update_category_status(
1108: p_run_name => cons_entity_wf_info.run_identifier,
1101: ELSE
1102: l_category_code := gcs_categories_pkg.g_oper_category_info(l_curr_category_num).category_code;
1103: END IF;
1104: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1105: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.UPDATE_PROCESS_STATUS', 'Actual Category Code : ' || l_category_code);
1106: END IF;
1107: gcs_cons_eng_run_dtls_pkg.update_category_status(
1108: p_run_name => cons_entity_wf_info.run_identifier,
1109: p_consolidation_entity_id => cons_entity_wf_info.consolidation_entity,
1112:
1113: END IF;
1114:
1115: result := 'COMPLETE';
1116: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1117: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PROCESS_STATUS', '<
1118: END IF;
1119: END update_process_status;
1120:
1113: END IF;
1114:
1115: result := 'COMPLETE';
1116: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1117: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_PROCESS_STATUS', '<
1119: END update_process_status;
1120:
1121: PROCEDURE eliminations_processor( itemtype IN VARCHAR2,
1259: AND gcer.cal_period_id = p_cal_period_id
1260: AND gcer.most_recent_flag = 'Y';
1261:
1262: BEGIN
1263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1264: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.ELIMINATIONS_PROCESSOR.begin', '<
1265: END IF;
1266: l_curr_category_num := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
1267:
1260: AND gcer.most_recent_flag = 'Y';
1261:
1262: BEGIN
1263: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1264: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.ELIMINATIONS_PROCESSOR.begin', '<
1266: l_curr_category_num := WF_ENGINE.GetItemAttrNumber(itemtype, itemkey, 'CURR_CATEGORY_NUM', FALSE);
1267:
1268: IF (itemtype = 'GCSOPRWF') THEN
1282: l_entity_id := cons_entity_wf_info.consolidation_entity;
1283:
1284: END IF;
1285:
1286: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1287: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Processing Category Code : ' || l_category_code);
1288: END IF;
1289:
1290: --Bugfix 5017120: Retrieve the eliminiation rules flag and consolidation rules flag
1283:
1284: END IF;
1285:
1286: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1287: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Processing Category Code : ' || l_category_code);
1288: END IF;
1289:
1290: --Bugfix 5017120: Retrieve the eliminiation rules flag and consolidation rules flag
1291: SELECT apply_elim_rules_flag,
1312: FROM gcs_entity_cons_attrs
1313: WHERE hierarchy_id = cons_entity_wf_info.consolidation_hierarchy
1314: AND entity_id = l_entity_id;
1315:
1316: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1317: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Parameters for Intercompany Engine');
1318: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Consolidation Hierarchy : ' || cons_entity_wf_info.consolidation_hierarchy );
1319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Calendar Period : ' || cons_entity_wf_info.consolidation_hierarchy );
1320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Balance Type : ' || cons_entity_wf_info.balance_type_code );
1313: WHERE hierarchy_id = cons_entity_wf_info.consolidation_hierarchy
1314: AND entity_id = l_entity_id;
1315:
1316: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1317: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Parameters for Intercompany Engine');
1318: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Consolidation Hierarchy : ' || cons_entity_wf_info.consolidation_hierarchy );
1319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Calendar Period : ' || cons_entity_wf_info.consolidation_hierarchy );
1320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Balance Type : ' || cons_entity_wf_info.balance_type_code );
1321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Entity Identifier : ' || l_entity_id );
1314: AND entity_id = l_entity_id;
1315:
1316: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1317: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Parameters for Intercompany Engine');
1318: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Consolidation Hierarchy : ' || cons_entity_wf_info.consolidation_hierarchy );
1319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Calendar Period : ' || cons_entity_wf_info.consolidation_hierarchy );
1320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Balance Type : ' || cons_entity_wf_info.balance_type_code );
1321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Entity Identifier : ' || l_entity_id );
1322: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Elimination Mode : ' || l_elim_mode);
1315:
1316: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1317: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Parameters for Intercompany Engine');
1318: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Consolidation Hierarchy : ' || cons_entity_wf_info.consolidation_hierarchy );
1319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Calendar Period : ' || cons_entity_wf_info.consolidation_hierarchy );
1320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Balance Type : ' || cons_entity_wf_info.balance_type_code );
1321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Entity Identifier : ' || l_entity_id );
1322: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Elimination Mode : ' || l_elim_mode);
1323: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Currency Code : ' || l_currency_code);
1316: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1317: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Parameters for Intercompany Engine');
1318: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Consolidation Hierarchy : ' || cons_entity_wf_info.consolidation_hierarchy );
1319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Calendar Period : ' || cons_entity_wf_info.consolidation_hierarchy );
1320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Balance Type : ' || cons_entity_wf_info.balance_type_code );
1321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Entity Identifier : ' || l_entity_id );
1322: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Elimination Mode : ' || l_elim_mode);
1323: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Currency Code : ' || l_currency_code);
1324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Run Name : ' || cons_entity_wf_info.run_identifier);
1317: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Parameters for Intercompany Engine');
1318: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Consolidation Hierarchy : ' || cons_entity_wf_info.consolidation_hierarchy );
1319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Calendar Period : ' || cons_entity_wf_info.consolidation_hierarchy );
1320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Balance Type : ' || cons_entity_wf_info.balance_type_code );
1321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Entity Identifier : ' || l_entity_id );
1322: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Elimination Mode : ' || l_elim_mode);
1323: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Currency Code : ' || l_currency_code);
1324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Run Name : ' || cons_entity_wf_info.run_identifier);
1325: END IF;
1318: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Consolidation Hierarchy : ' || cons_entity_wf_info.consolidation_hierarchy );
1319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Calendar Period : ' || cons_entity_wf_info.consolidation_hierarchy );
1320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Balance Type : ' || cons_entity_wf_info.balance_type_code );
1321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Entity Identifier : ' || l_entity_id );
1322: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Elimination Mode : ' || l_elim_mode);
1323: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Currency Code : ' || l_currency_code);
1324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Run Name : ' || cons_entity_wf_info.run_identifier);
1325: END IF;
1326:
1319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Calendar Period : ' || cons_entity_wf_info.consolidation_hierarchy );
1320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Balance Type : ' || cons_entity_wf_info.balance_type_code );
1321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Entity Identifier : ' || l_entity_id );
1322: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Elimination Mode : ' || l_elim_mode);
1323: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Currency Code : ' || l_currency_code);
1324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Run Name : ' || cons_entity_wf_info.run_identifier);
1325: END IF;
1326:
1327: l_parameter_list.hierarchy_id := cons_entity_wf_info.consolidation_hierarchy;
1320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Balance Type : ' || cons_entity_wf_info.balance_type_code );
1321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Entity Identifier : ' || l_entity_id );
1322: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Elimination Mode : ' || l_elim_mode);
1323: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Currency Code : ' || l_currency_code);
1324: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.ELIMINATIONS_PROCESSOR', 'Run Name : ' || cons_entity_wf_info.run_identifier);
1325: END IF;
1326:
1327: l_parameter_list.hierarchy_id := cons_entity_wf_info.consolidation_hierarchy;
1328: l_parameter_list.cal_period_id := cons_entity_wf_info.cal_period_id;
1460:
1461: EXCEPTION
1462: WHEN NO_DATA_FOUND THEN
1463: -- no operating entity was found, therefore, equity pick-up rule is just skipped
1464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1465: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.ELIMINATIONS_PROCESSOR', SQLERRM);
1466: END IF;
1467: null;
1468: END;
1461: EXCEPTION
1462: WHEN NO_DATA_FOUND THEN
1463: -- no operating entity was found, therefore, equity pick-up rule is just skipped
1464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1465: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.ELIMINATIONS_PROCESSOR', SQLERRM);
1466: END IF;
1467: null;
1468: END;
1469: END LOOP;
1520:
1521: END IF;
1522:
1523: result := 'COMPLETE';
1524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1525: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.ELIMINATIONS_PROCESSOR.end', '<
1526: END IF;
1527:
1528: END eliminations_processor;
1521: END IF;
1522:
1523: result := 'COMPLETE';
1524: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1525: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.ELIMINATIONS_PROCESSOR.end', '<
1527:
1528: END eliminations_processor;
1529:
1544: l_parameter_list gcs_cons_eng_utility_pkg.r_module_parameters;
1545:
1546: BEGIN
1547:
1548: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1549: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CREATE_INITIALIZING_JOURNAL.begin', '<
1550: END IF;
1551:
1552: IF (itemtype = 'GCSOPRWF') THEN
1545:
1546: BEGIN
1547:
1548: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1549: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CREATE_INITIALIZING_JOURNAL.begin', '<
1551:
1552: IF (itemtype = 'GCSOPRWF') THEN
1553: gcs_cons_eng_utility_pkg.get_oper_entity_wf_info (itemtype,
1614: execute_module('PERIOD_INITIALIZATION', l_parameter_list,itemkey);
1615:
1616: END IF;
1617:
1618: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1619: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CREATE_INITIALIZING_JOURNAL.end', '<
1620: END IF;
1621:
1622: result := 'COMPLETE';
1615:
1616: END IF;
1617:
1618: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1619: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.CREATE_INITIALIZING_JOURNAL.end', '<
1621:
1622: result := 'COMPLETE';
1623: EXCEPTION