70: x_return_status := FND_API.G_RET_STS_ERROR;
71: fnd_message.set_name('PA','PA_UNKNOWN_ACTION');
72: fnd_message.set_token('PKG_NAME','PA_STATUSES_PUB');
73: fnd_message.set_token('PROCEDURE_NAME','delete_status');
74: fnd_msg_pub.add();
75: fnd_msg_pub.count_and_get(p_count => x_msg_count,
76: p_data => x_msg_data);
77: raise;
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
71: fnd_message.set_name('PA','PA_UNKNOWN_ACTION');
72: fnd_message.set_token('PKG_NAME','PA_STATUSES_PUB');
73: fnd_message.set_token('PROCEDURE_NAME','delete_status');
74: fnd_msg_pub.add();
75: fnd_msg_pub.count_and_get(p_count => x_msg_count,
76: p_data => x_msg_data);
77: raise;
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: rollback;
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
82: fnd_message.set_token('PKG_NAME','PA_STATUSES_PUB');
83: fnd_message.set_token('PROCEDURE_NAME','delete_status');
84: fnd_msg_pub.add();
85: fnd_msg_pub.count_and_get(p_count => x_msg_count,
86: p_data => x_msg_data);
87: raise;
88: WHEN OTHERS THEN
81: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
82: fnd_message.set_token('PKG_NAME','PA_STATUSES_PUB');
83: fnd_message.set_token('PROCEDURE_NAME','delete_status');
84: fnd_msg_pub.add();
85: fnd_msg_pub.count_and_get(p_count => x_msg_count,
86: p_data => x_msg_data);
87: raise;
88: WHEN OTHERS THEN
89: rollback;
87: raise;
88: WHEN OTHERS THEN
89: rollback;
90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
91: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STATUSES_PUB',
92: p_procedure_name => 'delete_status',
93: p_error_text => SUBSTRB(SQLERRM,1,240));
94: fnd_msg_pub.count_and_get(p_count => x_msg_count,
95: p_data => x_msg_data);
90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
91: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STATUSES_PUB',
92: p_procedure_name => 'delete_status',
93: p_error_text => SUBSTRB(SQLERRM,1,240));
94: fnd_msg_pub.count_and_get(p_count => x_msg_count,
95: p_data => x_msg_data);
96: raise;
97:
98: