38: END IF;
39:
40: EXCEPTION
41: WHEN NO_DATA_FOUND THEN
42: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in ' || G_PKG_NAME || '.' || l_api_name
43: || SUBSTR (SQLERRM, 1, 100), 1, 200));
44: WHEN OTHERS THEN
45: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in ' || G_PKG_NAME || '.' || l_api_name
46: || SUBSTR (SQLERRM, 1, 100), 1, 200));
41: WHEN NO_DATA_FOUND THEN
42: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in ' || G_PKG_NAME || '.' || l_api_name
43: || SUBSTR (SQLERRM, 1, 100), 1, 200));
44: WHEN OTHERS THEN
45: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in ' || G_PKG_NAME || '.' || l_api_name
46: || SUBSTR (SQLERRM, 1, 100), 1, 200));
47: errbuf := SQLERRM;
48: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
49:
59: BEGIN
60:
61: SAVEPOINT Populate_Fin_Summary;
62:
63: fnd_file.put_line (fnd_file.LOG, 'Certification_Id:'||p_certification_id);
64:
65: update amw_fin_process_eval_sum set
66: LAST_UPDATE_DATE = sysdate,
67: last_updated_by = fnd_global.user_id,
77: where fin_certification_id = p_certification_id;
78:
79: EXCEPTION
80: WHEN NO_DATA_FOUND THEN
81: fnd_file.put_line(fnd_file.LOG, 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name );
82: WHEN OTHERS THEN
83: ROLLBACK TO Populate_Fin_Summary;
84: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Finding_Sum'
85: || SUBSTR (SQLERRM, 1, 100), 1, 200));
80: WHEN NO_DATA_FOUND THEN
81: fnd_file.put_line(fnd_file.LOG, 'NO DATA FOUND IN ' || G_PKG_NAME || '.' || l_api_name );
82: WHEN OTHERS THEN
83: ROLLBACK TO Populate_Fin_Summary;
84: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Finding_Sum'
85: || SUBSTR (SQLERRM, 1, 100), 1, 200));
86:
87: END Populate_Fin_Summary;
88: