56: WHEN OTHERS THEN
57: x_msg_count := 1;
58: x_msg_data := substr(SQLERRM,1,240);
59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
60: FND_MSG_PUB.add_exc_msg
61: (p_pkg_name => 'PA_STATUS_LIST_ITEMS_PVT'
62: , p_procedure_name => PA_DEBUG.G_Err_Stack
63: , p_error_text => substr(SQLERRM,1,240));
64: RETURN;
122: WHEN OTHERS THEN
123: x_msg_count := 1;
124: x_msg_data := substr(SQLERRM,1,240);
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: FND_MSG_PUB.add_exc_msg
127: (p_pkg_name => 'PA_STATUS_LIST_ITEMS_PVT'
128: , p_procedure_name => PA_DEBUG.G_Err_Stack
129: , p_error_text => substr(SQLERRM,1,240));
130: RETURN;
180: WHEN OTHERS THEN
181: x_msg_count := 1;
182: x_msg_data := substr(SQLERRM,1,240);
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: FND_MSG_PUB.add_exc_msg
185: (p_pkg_name => 'PA_STATUS_LIST_ITEMS_PVT'
186: , p_procedure_name => PA_DEBUG.G_Err_Stack
187: , p_error_text => substr(SQLERRM,1,240));
188: RETURN;