68: ROLLBACK TO Delete_Procedure_Related;
69: END IF;
70:
71: x_return_status := FND_API.G_RET_STS_ERROR;
72: fnd_msg_pub.count_and_get(p_count => x_msg_count,
73: p_data => x_msg_data);
74: WHEN OTHERS THEN
75: IF p_commit = FND_API.G_TRUE THEN
76: ROLLBACK TO Delete_Procedure_Related;
76: ROLLBACK TO Delete_Procedure_Related;
77: END IF;
78:
79: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
80: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_ASSESSMENTS_PVT',
81: p_procedure_name => 'Delete_Procedure_Related',
82: p_error_text => SUBSTRB(SQLERRM,1,240));
83:
84: fnd_msg_pub.count_and_get(p_count => x_msg_count,
80: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_ASSESSMENTS_PVT',
81: p_procedure_name => 'Delete_Procedure_Related',
82: p_error_text => SUBSTRB(SQLERRM,1,240));
83:
84: fnd_msg_pub.count_and_get(p_count => x_msg_count,
85: p_data => x_msg_data);
86:
87: END Delete_Procedure_Related;
88:
147: ROLLBACK TO Delete_Assessment_Related;
148: END IF;
149:
150: x_return_status := FND_API.G_RET_STS_ERROR;
151: fnd_msg_pub.count_and_get(p_count => x_msg_count,
152: p_data => x_msg_data);
153: WHEN OTHERS THEN
154: IF p_commit = FND_API.G_TRUE THEN
155: ROLLBACK TO Delete_Assessment_Related;
155: ROLLBACK TO Delete_Assessment_Related;
156: END IF;
157:
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_ASSESSMENTS_PVT',
160: p_procedure_name => 'Delete_Assessment_Related',
161: p_error_text => SUBSTRB(SQLERRM,1,240));
162:
163: fnd_msg_pub.count_and_get(p_count => x_msg_count,
159: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_ASSESSMENTS_PVT',
160: p_procedure_name => 'Delete_Assessment_Related',
161: p_error_text => SUBSTRB(SQLERRM,1,240));
162:
163: fnd_msg_pub.count_and_get(p_count => x_msg_count,
164: p_data => x_msg_data);
165:
166: END Delete_Assessment_Related;
167: