APPS.PSP_XMLGEN dependencies on FND_API

Line 2121: p_return_status := fnd_api.g_ret_sts_success;

2117: || ' WHERE person_id BETWEEN ' || p_start_person || ' AND ' || p_end_person
2118: || ' AND status_code <> ''R'' AND request_id = ' || p_request_id ||' )';
2119:
2120: EXECUTE IMMEDIATE sql_stmt ;
2121: p_return_status := fnd_api.g_ret_sts_success;
2122: EXCEPTION
2123: WHEN OTHERS THEN
2124: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2125:

Line 2141: p_return_status := fnd_api.g_ret_sts_error;

2137: p_pdf_request_id => g_request_id,
2138: p_error_message => sqlerrm,
2139: p_return_status => l_return_status);
2140: END IF;
2141: p_return_status := fnd_api.g_ret_sts_error;
2142: END COPY_PTAOE_FROM_GL_SEGMENTS;
2143: --- function for uva issues.. this can be replace dbms_xmlgen.convert in future.
2144: ---- fix for bug 4429787
2145: function convert_xml_controls(p_string varchar2) return varchar2 is

Line 2235: p_return_status := fnd_api.g_ret_sts_success;

2231: WHERE pre.request_id = p_request_id
2232: AND pre.source_id IS NOT NULL
2233: AND pre.source_name IS NULL;
2234:
2235: p_return_status := fnd_api.g_ret_sts_success;
2236: EXCEPTION
2237: WHEN OTHERS THEN
2238: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2239: fnd_msg_pub.add_exc_msg('PSP_XMLGEN', 'UPDATE_ER_ERROR_DETAILS', sqlerrm);

Line 2254: p_return_status := fnd_api.g_ret_sts_error;

2250: p_pdf_request_id => NULL,
2251: p_error_message => sqlerrm,
2252: p_return_status => l_return_status);
2253: END IF;
2254: p_return_status := fnd_api.g_ret_sts_error;
2255: END update_er_error_details;
2256:
2257:
2258: /* Procedure Added for Hospital effort report */

Line 2355: p_return_status := fnd_api.g_ret_sts_success;

2351: WHERE effort_report_detail_id = effort_report_detail_id_rec(I);
2352:
2353: effort_report_detail_id_rec.delete;
2354:
2355: p_return_status := fnd_api.g_ret_sts_success;
2356:
2357: EXCEPTION
2358: WHEN OTHERS THEN
2359: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 2367: p_return_status := fnd_api.g_ret_sts_unexp_error;

2363: p_source_id => NULL,
2364: p_error_message => sqlerrm,
2365: p_return_status => l_return_status);
2366:
2367: p_return_status := fnd_api.g_ret_sts_unexp_error;
2368:
2369: END update_grouping_category;
2370:
2371: