201: ,X_MSG_DATA => X_MSG_DATA
202: ,X_RETURN_STATUS => X_RETURN_STATUS);
203: WHEN OTHERS THEN
204: Rollback to create_orders_pub;
205: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
206: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
207: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
208: FND_MSG_PUB.ADD;
209: fnd_msg_pub.count_and_get
202: ,X_RETURN_STATUS => X_RETURN_STATUS);
203: WHEN OTHERS THEN
204: Rollback to create_orders_pub;
205: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
206: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
207: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
208: FND_MSG_PUB.ADD;
209: fnd_msg_pub.count_and_get
210: ( p_count => x_msg_count
203: WHEN OTHERS THEN
204: Rollback to create_orders_pub;
205: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
206: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, FALSE);
207: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, FALSE);
208: FND_MSG_PUB.ADD;
209: fnd_msg_pub.count_and_get
210: ( p_count => x_msg_count
211: , p_data => x_msg_data);