27: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
28: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.GENERATE_XML_AND_NTFS.begin', '<
29: END IF;
30:
31: fnd_file.put_line(fnd_file.log, '<
33: fnd_file.put_line(fnd_file.log, 'Run Name : ' || p_run_name);
34: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_cons_entity_id);
35: fnd_file.put_line(fnd_file.log, 'Category Code : ' || p_category_code);
28: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.GENERATE_XML_AND_NTFS.begin', '<
29: END IF;
30:
31: fnd_file.put_line(fnd_file.log, '<
32: fnd_file.put_line(fnd_file.log, 'Execution Type : ' || p_execution_type);
33: fnd_file.put_line(fnd_file.log, 'Run Name : ' || p_run_name);
34: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_cons_entity_id);
35: fnd_file.put_line(fnd_file.log, 'Category Code : ' || p_category_code);
36: fnd_file.put_line(fnd_file.log, 'Child Entity : ' || p_child_entity_id);
29: END IF;
30:
31: fnd_file.put_line(fnd_file.log, '<
32: fnd_file.put_line(fnd_file.log, 'Execution Type : ' || p_execution_type);
33: fnd_file.put_line(fnd_file.log, 'Run Name : ' || p_run_name);
34: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_cons_entity_id);
35: fnd_file.put_line(fnd_file.log, 'Category Code : ' || p_category_code);
36: fnd_file.put_line(fnd_file.log, 'Child Entity : ' || p_child_entity_id);
37: fnd_file.put_line(fnd_file.log, 'Run Detail : ' || p_run_detail_id);
30:
31: fnd_file.put_line(fnd_file.log, '<
32: fnd_file.put_line(fnd_file.log, 'Execution Type : ' || p_execution_type);
33: fnd_file.put_line(fnd_file.log, 'Run Name : ' || p_run_name);
34: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_cons_entity_id);
35: fnd_file.put_line(fnd_file.log, 'Category Code : ' || p_category_code);
36: fnd_file.put_line(fnd_file.log, 'Child Entity : ' || p_child_entity_id);
37: fnd_file.put_line(fnd_file.log, 'Run Detail : ' || p_run_detail_id);
38: fnd_file.put_line(fnd_file.log, 'Entry Identifier : ' || p_entry_id);
31: fnd_file.put_line(fnd_file.log, '<
32: fnd_file.put_line(fnd_file.log, 'Execution Type : ' || p_execution_type);
33: fnd_file.put_line(fnd_file.log, 'Run Name : ' || p_run_name);
34: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_cons_entity_id);
35: fnd_file.put_line(fnd_file.log, 'Category Code : ' || p_category_code);
36: fnd_file.put_line(fnd_file.log, 'Child Entity : ' || p_child_entity_id);
37: fnd_file.put_line(fnd_file.log, 'Run Detail : ' || p_run_detail_id);
38: fnd_file.put_line(fnd_file.log, 'Entry Identifier : ' || p_entry_id);
39: fnd_file.put_line(fnd_file.log, 'Load Identifier : ' || p_load_id);
32: fnd_file.put_line(fnd_file.log, 'Execution Type : ' || p_execution_type);
33: fnd_file.put_line(fnd_file.log, 'Run Name : ' || p_run_name);
34: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_cons_entity_id);
35: fnd_file.put_line(fnd_file.log, 'Category Code : ' || p_category_code);
36: fnd_file.put_line(fnd_file.log, 'Child Entity : ' || p_child_entity_id);
37: fnd_file.put_line(fnd_file.log, 'Run Detail : ' || p_run_detail_id);
38: fnd_file.put_line(fnd_file.log, 'Entry Identifier : ' || p_entry_id);
39: fnd_file.put_line(fnd_file.log, 'Load Identifier : ' || p_load_id);
40: fnd_file.put_line(fnd_file.log, '<
33: fnd_file.put_line(fnd_file.log, 'Run Name : ' || p_run_name);
34: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_cons_entity_id);
35: fnd_file.put_line(fnd_file.log, 'Category Code : ' || p_category_code);
36: fnd_file.put_line(fnd_file.log, 'Child Entity : ' || p_child_entity_id);
37: fnd_file.put_line(fnd_file.log, 'Run Detail : ' || p_run_detail_id);
38: fnd_file.put_line(fnd_file.log, 'Entry Identifier : ' || p_entry_id);
39: fnd_file.put_line(fnd_file.log, 'Load Identifier : ' || p_load_id);
40: fnd_file.put_line(fnd_file.log, '<
41:
34: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_cons_entity_id);
35: fnd_file.put_line(fnd_file.log, 'Category Code : ' || p_category_code);
36: fnd_file.put_line(fnd_file.log, 'Child Entity : ' || p_child_entity_id);
37: fnd_file.put_line(fnd_file.log, 'Run Detail : ' || p_run_detail_id);
38: fnd_file.put_line(fnd_file.log, 'Entry Identifier : ' || p_entry_id);
39: fnd_file.put_line(fnd_file.log, 'Load Identifier : ' || p_load_id);
40: fnd_file.put_line(fnd_file.log, '<
41:
42: IF (p_execution_type = 'CONS_PROCESS') THEN
35: fnd_file.put_line(fnd_file.log, 'Category Code : ' || p_category_code);
36: fnd_file.put_line(fnd_file.log, 'Child Entity : ' || p_child_entity_id);
37: fnd_file.put_line(fnd_file.log, 'Run Detail : ' || p_run_detail_id);
38: fnd_file.put_line(fnd_file.log, 'Entry Identifier : ' || p_entry_id);
39: fnd_file.put_line(fnd_file.log, 'Load Identifier : ' || p_load_id);
40: fnd_file.put_line(fnd_file.log, '<
41:
42: IF (p_execution_type = 'CONS_PROCESS') THEN
43: fnd_file.put_line(fnd_file.log, '<
36: fnd_file.put_line(fnd_file.log, 'Child Entity : ' || p_child_entity_id);
37: fnd_file.put_line(fnd_file.log, 'Run Detail : ' || p_run_detail_id);
38: fnd_file.put_line(fnd_file.log, 'Entry Identifier : ' || p_entry_id);
39: fnd_file.put_line(fnd_file.log, 'Load Identifier : ' || p_load_id);
40: fnd_file.put_line(fnd_file.log, '<
42: IF (p_execution_type = 'CONS_PROCESS') THEN
43: fnd_file.put_line(fnd_file.log, '<
44: --Bugfix 4874306: Eliminate calls to XML Generation in order to leverage data templates
39: fnd_file.put_line(fnd_file.log, 'Load Identifier : ' || p_load_id);
40: fnd_file.put_line(fnd_file.log, '<
41:
42: IF (p_execution_type = 'CONS_PROCESS') THEN
43: fnd_file.put_line(fnd_file.log, '<
45: --gcs_xml_gen_pkg.submit_entry_xml_gen(
46: -- x_errbuf => x_errbuf,
47: -- x_retcode => x_retcode,
50: -- p_category_code => p_category_code,
51: -- p_child_entity_id => p_child_entity_id,
52: -- p_run_detail_id => p_run_detail_id);
53: ELSIF (p_execution_type = 'IMPACT_ENGINE') THEN
54: fnd_file.put_line(fnd_file.log, '<
56: --In this case the control is coming from Data Submission,
57: --we need to send the notification without attachment. Making call to the notification workflow
58: gcs_wf_ntf_pkg.raise_impact_notification(
71: sub_request => FALSE,
72: argument1 => p_entry_id,
73: argument2 => p_run_name,
74: argument3 => p_cons_entity_id );
75: fnd_file.put_line(fnd_file.log, 'Submitted PDF Generation Request: '|| l_request_id);
76: END IF;
77: --End of Bugfix 5524909
78: fnd_file.put_line(fnd_file.log, '<
79: ELSIF (p_execution_type = 'NTF_ONLY' AND p_category_code = 'AGGREGATION') THEN
74: argument3 => p_cons_entity_id );
75: fnd_file.put_line(fnd_file.log, 'Submitted PDF Generation Request: '|| l_request_id);
76: END IF;
77: --End of Bugfix 5524909
78: fnd_file.put_line(fnd_file.log, '<
80: fnd_file.put_line(fnd_file.log, '<
81: gcs_wf_ntf_pkg.raise_status_notification(
82: p_cons_detail_id => p_run_detail_id);
76: END IF;
77: --End of Bugfix 5524909
78: fnd_file.put_line(fnd_file.log, '<
79: ELSIF (p_execution_type = 'NTF_ONLY' AND p_category_code = 'AGGREGATION') THEN
80: fnd_file.put_line(fnd_file.log, '<
82: p_cons_detail_id => p_run_detail_id);
83: fnd_file.put_line(fnd_file.log, '<
84: fnd_file.put_line(fnd_file.log, '<
79: ELSIF (p_execution_type = 'NTF_ONLY' AND p_category_code = 'AGGREGATION') THEN
80: fnd_file.put_line(fnd_file.log, '<
81: gcs_wf_ntf_pkg.raise_status_notification(
82: p_cons_detail_id => p_run_detail_id);
83: fnd_file.put_line(fnd_file.log, '<
85:
86: --Bugfix 5288100: If request error code is NOT_APPLICABLE then do not launched XML Writer Program
87: SELECT request_error_code
80: fnd_file.put_line(fnd_file.log, '<
81: gcs_wf_ntf_pkg.raise_status_notification(
82: p_cons_detail_id => p_run_detail_id);
83: fnd_file.put_line(fnd_file.log, '<
84: fnd_file.put_line(fnd_file.log, '<
86: --Bugfix 5288100: If request error code is NOT_APPLICABLE then do not launched XML Writer Program
87: SELECT request_error_code
88: INTO l_request_error_code
99: argument3 => p_cons_entity_id,
100: argument4 => NULL );
101: commit;
102: END IF;
103: fnd_file.put_line(fnd_file.log, 'Submitted XML Generation Request: '||l_request_id);
104: fnd_file.put_line(fnd_file.log, '<
105: ELSIF (p_execution_type = 'NTF_ONLY') THEN
106: fnd_file.put_line(fnd_file.log, '<
107: gcs_wf_ntf_pkg.raise_status_notification(
100: argument4 => NULL );
101: commit;
102: END IF;
103: fnd_file.put_line(fnd_file.log, 'Submitted XML Generation Request: '||l_request_id);
104: fnd_file.put_line(fnd_file.log, '<
106: fnd_file.put_line(fnd_file.log, '<
107: gcs_wf_ntf_pkg.raise_status_notification(
108: p_cons_detail_id => p_run_detail_id);
102: END IF;
103: fnd_file.put_line(fnd_file.log, 'Submitted XML Generation Request: '||l_request_id);
104: fnd_file.put_line(fnd_file.log, '<
105: ELSIF (p_execution_type = 'NTF_ONLY') THEN
106: fnd_file.put_line(fnd_file.log, '<
108: p_cons_detail_id => p_run_detail_id);
109: fnd_file.put_line(fnd_file.log, '<
110: END IF;
105: ELSIF (p_execution_type = 'NTF_ONLY') THEN
106: fnd_file.put_line(fnd_file.log, '<
107: gcs_wf_ntf_pkg.raise_status_notification(
108: p_cons_detail_id => p_run_detail_id);
109: fnd_file.put_line(fnd_file.log, '<
111:
112:
113: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
114: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.GENERATE_XML_AND_NTFS.end', '<
115: END IF;
116: EXCEPTION
117: WHEN OTHERS THEN
118: fnd_file.put_line(fnd_file.log, 'Fatal Error Occurred : ' || SQLERRM);
119: l_ret_status_code := fnd_concurrent.set_completion_status(
120: status => 'ERROR',
121: message => NULL);
122: END generate_xml_and_ntfs;