[Home] [Help]
1960: || ' WHERE person_id BETWEEN ' || p_start_person || ' AND ' || p_end_person
1961: || ' AND status_code <> ''R'' AND request_id = ' || p_request_id ||' )';
1962:
1963: EXECUTE IMMEDIATE sql_stmt ;
1964: p_return_status := fnd_api.g_ret_sts_success;
1965: EXCEPTION
1966: WHEN OTHERS THEN
1967: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'COPY_PTAOE_FROM_GL_SEGMENTS', sqlerrm);
1968: OPEN add_report_error_cur(sqlerrm);
1978: p_pdf_request_id => g_request_id,
1979: p_error_message => sqlerrm,
1980: p_return_status => l_return_status);
1981: END IF;
1982: p_return_status := fnd_api.g_ret_sts_error;
1983: END COPY_PTAOE_FROM_GL_SEGMENTS;
1984: --- function for uva issues.. this can be replace dbms_xmlgen.convert in future.
1985: ---- fix for bug 4429787
1986: function convert_xml_controls(p_string varchar2) return varchar2 is
2071: WHERE pre.request_id = p_request_id
2072: AND pre.source_id IS NOT NULL
2073: AND pre.source_name IS NULL;
2074:
2075: p_return_status := fnd_api.g_ret_sts_success;
2076: EXCEPTION
2077: WHEN OTHERS THEN
2078: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_ERROR_DETAILS', sqlerrm);
2079: OPEN add_report_error_cur(sqlerrm);
2089: p_pdf_request_id => NULL,
2090: p_error_message => sqlerrm,
2091: p_return_status => l_return_status);
2092: END IF;
2093: p_return_status := fnd_api.g_ret_sts_error;
2094: END update_er_error_details;
2095:
2096:
2097: /* Procedure Added for Hospital effort report */
2190: WHERE effort_report_detail_id = effort_report_detail_id_rec(I);
2191:
2192: effort_report_detail_id_rec.delete;
2193:
2194: p_return_status := fnd_api.g_ret_sts_success;
2195:
2196: EXCEPTION
2197: WHEN OTHERS THEN
2198: psp_general.add_report_error
2201: p_source_id => NULL,
2202: p_error_message => sqlerrm,
2203: p_return_status => l_return_status);
2204:
2205: p_return_status := fnd_api.g_ret_sts_unexp_error;
2206:
2207: END update_grouping_category;
2208:
2209: