[Home] [Help]
63: close c_justification;
64:
65: --dbms_output.put_line('l_proposal_form_number'||l_proposal_form_number);
66: if l_proposal_form_number is not null then
67: igw_report_processing.create_reporting_data(p_proposal_id, l_proposal_form_number, l_return_status,
68: l_msg_data, l_msg_count);
69:
70: --dbms_output.put_line('l_return_status first'||l_return_status);
71: --dbms_output.put_line('l_msg_data first'||l_msg_data);
69:
70: --dbms_output.put_line('l_return_status first'||l_return_status);
71: --dbms_output.put_line('l_msg_data first'||l_msg_data);
72: if l_return_status <> 'S' then
73: l_procedure_name := 'IGW_REPORT_PROCESSING.CREATE_REPORTING_DATA';
74: raise FND_API.G_EXC_ERROR;
75: end if;
76:
77: igw_report_processing.create_base_rate(p_proposal_id, l_proposal_form_number, l_return_status,
73: l_procedure_name := 'IGW_REPORT_PROCESSING.CREATE_REPORTING_DATA';
74: raise FND_API.G_EXC_ERROR;
75: end if;
76:
77: igw_report_processing.create_base_rate(p_proposal_id, l_proposal_form_number, l_return_status,
78: l_msg_data, l_msg_count);
79: if l_return_status <> 'S' then
80: l_procedure_name := 'IGW_REPORT_PROCESSING.CREATE_BASE_RATE';
81: raise FND_API.G_EXC_ERROR;
76:
77: igw_report_processing.create_base_rate(p_proposal_id, l_proposal_form_number, l_return_status,
78: l_msg_data, l_msg_count);
79: if l_return_status <> 'S' then
80: l_procedure_name := 'IGW_REPORT_PROCESSING.CREATE_BASE_RATE';
81: raise FND_API.G_EXC_ERROR;
82: end if;
83:
84: igw_report_processing.create_budget_justification(p_proposal_id
80: l_procedure_name := 'IGW_REPORT_PROCESSING.CREATE_BASE_RATE';
81: raise FND_API.G_EXC_ERROR;
82: end if;
83:
84: igw_report_processing.create_budget_justification(p_proposal_id
85: ,l_proposal_form_number, l_return_status, l_msg_data);
86: if l_return_status <> 'S' then
87: l_procedure_name := 'IGW_REPORT_PROCESSING.CREATE_BUDGET_JUSTIFICATION';
88: raise FND_API.G_EXC_ERROR;
83:
84: igw_report_processing.create_budget_justification(p_proposal_id
85: ,l_proposal_form_number, l_return_status, l_msg_data);
86: if l_return_status <> 'S' then
87: l_procedure_name := 'IGW_REPORT_PROCESSING.CREATE_BUDGET_JUSTIFICATION';
88: raise FND_API.G_EXC_ERROR;
89: end if;
90:
91: if l_abstract is null then
88: raise FND_API.G_EXC_ERROR;
89: end if;
90:
91: if l_abstract is null then
92: igw_report_processing.dump_justification(p_proposal_id
93: ,l_proposal_form_number, l_return_status, l_msg_data);
94: if l_return_status <> 'S' then
95: l_procedure_name := 'IGW_REPORT_PROCESSING.DUMP_JUSTIFICATION';
96: raise FND_API.G_EXC_ERROR;
91: if l_abstract is null then
92: igw_report_processing.dump_justification(p_proposal_id
93: ,l_proposal_form_number, l_return_status, l_msg_data);
94: if l_return_status <> 'S' then
95: l_procedure_name := 'IGW_REPORT_PROCESSING.DUMP_JUSTIFICATION';
96: raise FND_API.G_EXC_ERROR;
97: end if;
98: end if;
99: end if;